---------------------------------------------------------------
[ 2022-09-14T10:24:58+08:00 ] 117.132.195.217 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.002147s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010128s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000701s ]
---------------------------------------------------------------
[ 2022-09-14T10:24:59+08:00 ] 117.132.195.217 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1663122298&v1=0.008338&v2=0.028476&v3=0.008007&v4=0.009000&v5=12.240000&t=26.788399&h=71.323967&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001471s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010261s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000606s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055677740',`create_time`=1663122298,`v1`=0.008338,`v2`=0.028476,`v3`=0.008007,`v4`=0.009,`v5`=12.24,`t`=26.788399,`h`=71.323967,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1663122299  WHERE  `imei` = '868922055677740' [ RunTime:0.000555s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009799s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1663122298 , 0.008338 , 0.028476 , 0.008007 , 0.009 , 12.24 , 26.788399 , 71.323967 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1663122299) [ RunTime:0.000571s ]
---------------------------------------------------------------
[ 2022-09-14T14:03:50+08:00 ] 39.144.14.97 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002457s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010870s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000674s ]
---------------------------------------------------------------
[ 2022-09-14T14:03:59+08:00 ] 39.144.14.97 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=220914&time=140301&v1=-01.294&v2=+00.012&v3=-01.140&v4=-00.590&v5=06.2&t=+22.2&h=79.4&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.179&a2=01.309&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001414s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009991s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000655s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684076',`date`='220914',`time`='140301',`v1`=-1.294,`v2`=0.012,`v3`=-1.14,`v4`=-0.59,`v5`=6.2,`t`=22.2,`h`=79.4,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.179,`a2`=1.309,`update_time`=1663135439  WHERE  `imei` = '868922055684076' [ RunTime:0.000543s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009466s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '220914' , '140301' , -1.294 , 0.012 , -1.14 , -0.59 , 6.2 , 22.2 , 79.4 , 227 , '460044618415249' , -0 , 0.179 , 1.309 , 1663135439 , 1663135439) [ RunTime:0.000602s ]
---------------------------------------------------------------
[ 2022-09-14T14:29:35+08:00 ] 27.193.134.183 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002317s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011274s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE  `username` = 'user1'  AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000628s ]
---------------------------------------------------------------
[ 2022-09-14T14:29:36+08:00 ] 27.193.134.183 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001416s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009118s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000691s ]
---------------------------------------------------------------
[ 2022-09-14T14:44:17+08:00 ] 27.193.134.183 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002096s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008237s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `username` = 'user1' LIMIT 1 [ RunTime:0.000455s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000613s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.001064s ]
---------------------------------------------------------------
[ 2022-09-14T18:24:05+08:00 ] 27.193.134.183 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002223s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.011811s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000580s ]
---------------------------------------------------------------
[ 2022-09-14T18:24:08+08:00 ] 27.193.134.183 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001426s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009752s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000341s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000713s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000586s ]
---------------------------------------------------------------
[ 2022-09-14T18:24:30+08:00 ] 27.193.134.183 GET /admin/show/read/id/22/imei/868922055677740.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001401s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008326s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 22 LIMIT 1 [ RunTime:0.001264s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009734s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000795s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007966s ]
---------------------------------------------------------------
[ 2022-09-14T18:24:33+08:00 ] 27.193.134.183 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001924s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009843s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000300s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000673s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000573s ]
---------------------------------------------------------------
[ 2022-09-14T18:24:38+08:00 ] 27.193.134.183 GET /admin/show/read/id/31/imei/868922055644211.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001367s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010367s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 31 LIMIT 1 [ RunTime:0.000664s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010523s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000487s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644211' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001253s ]
---------------------------------------------------------------
[ 2022-09-14T18:24:42+08:00 ] 27.193.134.183 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001443s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008712s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000291s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000672s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000567s ]
---------------------------------------------------------------
[ 2022-09-14T18:24:54+08:00 ] 27.193.134.183 GET /admin/show/read/id/26/imei/868922055684076.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001461s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009341s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 26 LIMIT 1 [ RunTime:0.000580s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009713s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000865s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007290s ]
---------------------------------------------------------------
[ 2022-09-14T18:24:58+08:00 ] 27.193.134.183 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001700s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010118s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000306s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000695s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000601s ]
---------------------------------------------------------------
[ 2022-09-14T18:25:52+08:00 ] 27.193.134.183 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001867s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008518s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000670s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010333s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000497s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001760s ]
---------------------------------------------------------------
[ 2022-09-14T19:44:13+08:00 ] 39.144.15.227 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211
[ sql ] [ DB ] CONNECT:[ UseTime:0.002289s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012185s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000912s ]
---------------------------------------------------------------
[ 2022-09-14T19:44:15+08:00 ] 39.144.15.227 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1663155853&v1=0.026398&v2=0.025868&v3=0.016194&v4=-0.002860&v5=6.660000&t=19.795757&h=62.756104&rssi=20&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001637s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010867s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000595s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644211',`create_time`=1663155853,`v1`=0.026398,`v2`=0.025868,`v3`=0.016194,`v4`=-0.00286,`v5`=6.66,`t`=19.795757,`h`=62.756104,`rssi`=20,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1663155855  WHERE  `imei` = '868922055644211' [ RunTime:0.000558s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010588s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1663155853 , 0.026398 , 0.025868 , 0.016194 , -0.00286 , 6.66 , 19.795757 , 62.756104 , 20 , '89860426102071188505' , '460044618415255' , -0 , 1663155855) [ RunTime:0.000563s ]
---------------------------------------------------------------
[ 2022-09-14T22:25:18+08:00 ] 221.178.127.44 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.002178s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011114s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000620s ]
---------------------------------------------------------------
[ 2022-09-14T22:25:19+08:00 ] 221.178.127.44 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1663165518&v1=0.008097&v2=0.042975&v3=0.007736&v4=0.008759&v5=12.240000&t=24.385981&h=71.186638&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001639s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012071s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000635s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055677740',`create_time`=1663165518,`v1`=0.008097,`v2`=0.042975,`v3`=0.007736,`v4`=0.008759,`v5`=12.24,`t`=24.385981,`h`=71.186638,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1663165519  WHERE  `imei` = '868922055677740' [ RunTime:0.000565s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010914s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1663165518 , 0.008097 , 0.042975 , 0.007736 , 0.008759 , 12.24 , 24.385981 , 71.186638 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1663165519) [ RunTime:0.000562s ]