---------------------------------------------------------------
[ 2022-09-12T08:55:01+08:00 ] 27.193.134.183 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001992s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.010084s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000561s ]
---------------------------------------------------------------
[ 2022-09-12T08:55:07+08:00 ] 27.193.134.183 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001552s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012496s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000492s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000778s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000694s ]
---------------------------------------------------------------
[ 2022-09-12T10:23:39+08:00 ] 39.144.6.198 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.002396s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010317s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000723s ]
---------------------------------------------------------------
[ 2022-09-12T10:23:40+08:00 ] 39.144.6.198 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1662949419&v1=0.008940&v2=0.051633&v3=0.008518&v4=0.009843&v5=12.240000&t=31.990063&h=71.873283&rssi=99&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001704s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009345s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000637s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055677740',`create_time`=1662949419,`v1`=0.00894,`v2`=0.051633,`v3`=0.008518,`v4`=0.009843,`v5`=12.24,`t`=31.990063,`h`=71.873283,`rssi`=99,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1662949420  WHERE  `imei` = '868922055677740' [ RunTime:0.000562s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012987s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1662949419 , 0.00894 , 0.051633 , 0.008518 , 0.009843 , 12.24 , 31.990063 , 71.873283 , 99 , '89860426102071188504' , '460044618415254' , -0 , 1662949420) [ RunTime:0.000693s ]
---------------------------------------------------------------
[ 2022-09-12T14:05:50+08:00 ] 221.178.124.189 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002240s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010456s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000728s ]
---------------------------------------------------------------
[ 2022-09-12T14:05:58+08:00 ] 221.178.124.189 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=220912&time=140501&v1=-01.293&v2=+00.016&v3=-01.145&v4=-00.607&v5=06.2&t=+29.1&h=78.7&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.171&a2=01.308&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001499s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009811s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000761s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684076',`date`='220912',`time`='140501',`v1`=-1.293,`v2`=0.016,`v3`=-1.145,`v4`=-0.607,`v5`=6.2,`t`=29.1,`h`=78.7,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.171,`a2`=1.308,`update_time`=1662962758  WHERE  `imei` = '868922055684076' [ RunTime:0.000595s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010636s ]
[ 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' , '220912' , '140501' , -1.293 , 0.016 , -1.145 , -0.607 , 6.2 , 29.1 , 78.7 , 227 , '460044618415249' , -0 , 0.171 , 1.308 , 1662962758 , 1662962758) [ RunTime:0.000783s ]
---------------------------------------------------------------
[ 2022-09-12T19:44:13+08:00 ] 117.132.198.91 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211
[ sql ] [ DB ] CONNECT:[ UseTime:0.002152s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010282s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000680s ]
---------------------------------------------------------------
[ 2022-09-12T19:44:15+08:00 ] 117.132.198.91 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1662983053&v1=0.026579&v2=0.039428&v3=0.022635&v4=-0.001896&v5=6.840000&t=20.900442&h=65.266174&rssi=20&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001534s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009784s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000692s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644211',`create_time`=1662983053,`v1`=0.026579,`v2`=0.039428,`v3`=0.022635,`v4`=-0.001896,`v5`=6.84,`t`=20.900442,`h`=65.266174,`rssi`=20,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1662983055  WHERE  `imei` = '868922055644211' [ RunTime:0.000622s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011629s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1662983053 , 0.026579 , 0.039428 , 0.022635 , -0.001896 , 6.84 , 20.900442 , 65.266174 , 20 , '89860426102071188505' , '460044618415255' , -0 , 1662983055) [ RunTime:0.000647s ]
---------------------------------------------------------------
[ 2022-09-12T22:23:58+08:00 ] 117.132.193.93 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.002272s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010758s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000632s ]
---------------------------------------------------------------
[ 2022-09-12T22:24:00+08:00 ] 117.132.193.93 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1662992638&v1=0.008398&v2=0.066757&v3=0.008067&v4=0.008940&v5=12.420000&t=27.603506&h=71.362114&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001513s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010202s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000677s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055677740',`create_time`=1662992638,`v1`=0.008398,`v2`=0.066757,`v3`=0.008067,`v4`=0.00894,`v5`=12.42,`t`=27.603506,`h`=71.362114,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1662992640  WHERE  `imei` = '868922055677740' [ RunTime:0.000595s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011711s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1662992638 , 0.008398 , 0.066757 , 0.008067 , 0.00894 , 12.42 , 27.603506 , 71.362114 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1662992640) [ RunTime:0.000628s ]