---------------------------------------------------------------
[ 2022-09-10T10:22:09+08:00 ] 112.224.154.61 GET /
[ sql ] [ DB ] CONNECT:[ UseTime:0.002249s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010896s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `username` = 'user1' LIMIT 1 [ RunTime:0.003986s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000721s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000583s ]
---------------------------------------------------------------
[ 2022-09-10T10:22:16+08:00 ] 221.178.124.86 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.001808s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012240s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000645s ]
---------------------------------------------------------------
[ 2022-09-10T10:22:17+08:00 ] 221.178.124.86 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1662776536&v1=0.008579&v2=0.083759&v3=0.008398&v4=0.009482&v5=12.240000&t=30.359852&h=71.728325&rssi=99&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001634s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009185s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000605s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055677740',`create_time`=1662776536,`v1`=0.008579,`v2`=0.083759,`v3`=0.008398,`v4`=0.009482,`v5`=12.24,`t`=30.359852,`h`=71.728325,`rssi`=99,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1662776537  WHERE  `imei` = '868922055677740' [ RunTime:0.000535s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010980s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1662776536 , 0.008579 , 0.083759 , 0.008398 , 0.009482 , 12.24 , 30.359852 , 71.728325 , 99 , '89860426102071188504' , '460044618415254' , -0 , 1662776537) [ RunTime:0.000644s ]
---------------------------------------------------------------
[ 2022-09-10T14:06:49+08:00 ] 117.132.198.157 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002293s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012166s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000697s ]
---------------------------------------------------------------
[ 2022-09-10T14:06:58+08:00 ] 117.132.198.157 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=220910&time=140601&v1=-01.295&v2=+00.011&v3=-01.146&v4=-00.609&v5=06.2&t=+28.4&h=79.0&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.172&a2=01.310&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001807s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009405s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000671s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684076',`date`='220910',`time`='140601',`v1`=-1.295,`v2`=0.011,`v3`=-1.146,`v4`=-0.609,`v5`=6.2,`t`=28.4,`h`=79,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.172,`a2`=1.31,`update_time`=1662790018  WHERE  `imei` = '868922055684076' [ RunTime:0.000590s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012613s ]
[ 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' , '220910' , '140601' , -1.295 , 0.011 , -1.146 , -0.609 , 6.2 , 28.4 , 79 , 228 , '460044618415249' , -0 , 0.172 , 1.31 , 1662790018 , 1662790018) [ RunTime:0.000624s ]
---------------------------------------------------------------
[ 2022-09-10T19:44:15+08:00 ] 39.144.15.16 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211
[ sql ] [ DB ] CONNECT:[ UseTime:0.002311s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010072s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000670s ]
---------------------------------------------------------------
[ 2022-09-10T19:44:17+08:00 ] 39.144.15.16 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1662810255&v1=0.026579&v2=0.035048&v3=0.022756&v4=-0.003040&v5=6.660000&t=21.157845&h=64.960999&rssi=21&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001710s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009365s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000636s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644211',`create_time`=1662810255,`v1`=0.026579,`v2`=0.035048,`v3`=0.022756,`v4`=-0.00304,`v5`=6.66,`t`=21.157845,`h`=64.960999,`rssi`=21,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1662810257  WHERE  `imei` = '868922055644211' [ RunTime:0.000612s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011553s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1662810255 , 0.026579 , 0.035048 , 0.022756 , -0.00304 , 6.66 , 21.157845 , 64.960999 , 21 , '89860426102071188505' , '460044618415255' , -0 , 1662810257) [ RunTime:0.000643s ]
---------------------------------------------------------------
[ 2022-09-10T22:22:36+08:00 ] 218.204.252.162 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.002186s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010643s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000929s ]
---------------------------------------------------------------
[ 2022-09-10T22:22:37+08:00 ] 218.204.252.162 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1662819756&v1=0.008097&v2=0.031710&v3=0.008037&v4=0.008699&v5=12.240000&t=27.228128&h=71.400261&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001871s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009280s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000733s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055677740',`create_time`=1662819756,`v1`=0.008097,`v2`=0.03171,`v3`=0.008037,`v4`=0.008699,`v5`=12.24,`t`=27.228128,`h`=71.400261,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1662819757  WHERE  `imei` = '868922055677740' [ RunTime:0.000660s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009536s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1662819756 , 0.008097 , 0.03171 , 0.008037 , 0.008699 , 12.24 , 27.228128 , 71.400261 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1662819757) [ RunTime:0.000559s ]