---------------------------------------------------------------
[ 2022-09-22T05:20:17+08:00 ] 39.144.12.153 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920
[ sql ] [ DB ] CONNECT:[ UseTime:0.002077s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011500s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000683s ]
---------------------------------------------------------------
[ 2022-09-22T05:20:18+08:00 ] 39.144.12.153 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1663795217&v1=0.018813&v2=0.012621&v3=0.016013&v4=-0.004545&v5=12.240000&t=22.230354&h=64.182800&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end
[ sql ] [ DB ] CONNECT:[ UseTime:0.001373s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009000s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000576s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1663795217,`v1`=0.018813,`v2`=0.012621,`v3`=0.016013,`v4`=-0.004545,`v5`=12.24,`t`=22.230354,`h`=64.1828,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1663795218  WHERE  `imei` = '868922055683920' [ RunTime:0.000571s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010893s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1663795217 , 0.018813 , 0.012621 , 0.016013 , -0.004545 , 12.24 , 22.230354 , 64.1828 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1663795218) [ RunTime:0.000673s ]
---------------------------------------------------------------
[ 2022-09-22T09:43:37+08:00 ] 39.77.143.252 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002191s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.009902s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000571s ]
---------------------------------------------------------------
[ 2022-09-22T09:43:41+08:00 ] 39.77.143.252 GET /admin/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002440s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.013550s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000478s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000811s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000589s ]
---------------------------------------------------------------
[ 2022-09-22T09:43:44+08:00 ] 39.77.143.252 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001865s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009939s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000312s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000696s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000562s ]
---------------------------------------------------------------
[ 2022-09-22T10:30:26+08:00 ] 39.144.10.62 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.002118s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008623s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000666s ]
---------------------------------------------------------------
[ 2022-09-22T10:30:27+08:00 ] 39.144.10.62 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1663813826&v1=0.008037&v2=0.097528&v3=0.008007&v4=0.008458&v5=12.240000&t=26.799124&h=71.323967&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001721s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008914s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000636s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055677740',`create_time`=1663813826,`v1`=0.008037,`v2`=0.097528,`v3`=0.008007,`v4`=0.008458,`v5`=12.24,`t`=26.799124,`h`=71.323967,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1663813827  WHERE  `imei` = '868922055677740' [ RunTime:0.000509s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010454s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1663813826 , 0.008037 , 0.097528 , 0.008007 , 0.008458 , 12.24 , 26.799124 , 71.323967 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1663813827) [ RunTime:0.000555s ]
---------------------------------------------------------------
[ 2022-09-22T17:20:16+08:00 ] 117.132.194.209 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920
[ sql ] [ DB ] CONNECT:[ UseTime:0.002053s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009495s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000622s ]
---------------------------------------------------------------
[ 2022-09-22T17:20:17+08:00 ] 117.132.194.209 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1663838416&v1=0.019114&v2=0.014707&v3=0.016375&v4=-0.004545&v5=12.420000&t=25.126131&h=64.755005&rssi=30&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end
[ sql ] [ DB ] CONNECT:[ UseTime:0.001344s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008485s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000654s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1663838416,`v1`=0.019114,`v2`=0.014707,`v3`=0.016375,`v4`=-0.004545,`v5`=12.42,`t`=25.126131,`h`=64.755005,`rssi`=30,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1663838417  WHERE  `imei` = '868922055683920' [ RunTime:0.000539s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010568s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1663838416 , 0.019114 , 0.014707 , 0.016375 , -0.004545 , 12.42 , 25.126131 , 64.755005 , 30 , '89860426102071188500' , '460044618415250' , -0 , 1663838417) [ RunTime:0.000552s ]
---------------------------------------------------------------
[ 2022-09-22T18:13:50+08:00 ] 39.144.3.170 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002174s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009418s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000631s ]
---------------------------------------------------------------
[ 2022-09-22T18:13:58+08:00 ] 39.144.3.170 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=220922&time=181301&v1=+01.557&v2=+00.020&v3=+01.560&v4=+02.305&v5=06.0&t=+20.5&h=80.7&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.141&a2=01.226&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001554s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009441s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000745s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684076',`date`='220922',`time`='181301',`v1`=1.557,`v2`=0.02,`v3`=1.56,`v4`=2.305,`v5`=6,`t`=20.5,`h`=80.7,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.141,`a2`=1.226,`update_time`=1663841638  WHERE  `imei` = '868922055684076' [ RunTime:0.000574s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011481s ]
[ 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' , '220922' , '181301' , 1.557 , 0.02 , 1.56 , 2.305 , 6 , 20.5 , 80.7 , 228 , '460044618415249' , -0 , 0.141 , 1.226 , 1663841638 , 1663841638) [ RunTime:0.000569s ]
---------------------------------------------------------------
[ 2022-09-22T19:44:13+08:00 ] 117.132.192.165 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211
[ sql ] [ DB ] CONNECT:[ UseTime:0.002400s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009885s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000688s ]
---------------------------------------------------------------
[ 2022-09-22T19:44:14+08:00 ] 117.132.192.165 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1663847053&v1=0.026398&v2=0.038177&v3=0.023448&v4=-0.003100&v5=6.840000&t=19.055725&h=64.808411&rssi=21&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001539s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011172s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000666s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644211',`create_time`=1663847053,`v1`=0.026398,`v2`=0.038177,`v3`=0.023448,`v4`=-0.0031,`v5`=6.84,`t`=19.055725,`h`=64.808411,`rssi`=21,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1663847054  WHERE  `imei` = '868922055644211' [ RunTime:0.000571s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010197s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1663847053 , 0.026398 , 0.038177 , 0.023448 , -0.0031 , 6.84 , 19.055725 , 64.808411 , 21 , '89860426102071188505' , '460044618415255' , -0 , 1663847054) [ RunTime:0.000636s ]
---------------------------------------------------------------
[ 2022-09-22T22:30:45+08:00 ] 39.144.16.57 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.002140s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010310s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000711s ]
---------------------------------------------------------------
[ 2022-09-22T22:30:47+08:00 ] 39.144.16.57 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1663857045&v1=0.007856&v2=0.064984&v3=0.007856&v4=0.008278&v5=12.240000&t=23.881903&h=70.644951&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001787s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008413s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000651s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055677740',`create_time`=1663857045,`v1`=0.007856,`v2`=0.064984,`v3`=0.007856,`v4`=0.008278,`v5`=12.24,`t`=23.881903,`h`=70.644951,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1663857047  WHERE  `imei` = '868922055677740' [ RunTime:0.000563s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011234s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1663857045 , 0.007856 , 0.064984 , 0.007856 , 0.008278 , 12.24 , 23.881903 , 70.644951 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1663857047) [ RunTime:0.000659s ]