--------------------------------------------------------------- [ 2022-10-06T05:20:17+08:00 ] 218.204.253.171 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002535s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011700s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.001048s ] --------------------------------------------------------------- [ 2022-10-06T05:20:18+08:00 ] 218.204.253.171 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1665004817&v1=0.018271&v2=0.012830&v3=0.015441&v4=-0.004365&v5=12.240000&t=16.095598&h=64.182800&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001661s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012325s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000764s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1665004817,`v1`=0.018271,`v2`=0.01283,`v3`=0.015441,`v4`=-0.004365,`v5`=12.24,`t`=16.095598,`h`=64.1828,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1665004818 WHERE `imei` = '868922055683920' [ RunTime:0.000650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012129s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1665004817 , 0.018271 , 0.01283 , 0.015441 , -0.004365 , 12.24 , 16.095598 , 64.1828 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1665004818) [ RunTime:0.000696s ] --------------------------------------------------------------- [ 2022-10-06T10:39:47+08:00 ] 117.132.192.208 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002285s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011683s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000726s ] --------------------------------------------------------------- [ 2022-10-06T10:39:49+08:00 ] 117.132.192.208 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1665023987&v1=0.007375&v2=0.046000&v3=0.007525&v4=0.007916&v5=12.060000&t=21.511660&h=70.126152&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001922s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010853s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000614s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1665023987,`v1`=0.007375,`v2`=0.046,`v3`=0.007525,`v4`=0.007916,`v5`=12.06,`t`=21.51166,`h`=70.126152,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1665023989 WHERE `imei` = '868922055677740' [ RunTime:0.000560s ] [ 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 ('868922055677740' , 1665023987 , 0.007375 , 0.046 , 0.007525 , 0.007916 , 12.06 , 21.51166 , 70.126152 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1665023989) [ RunTime:0.000604s ] --------------------------------------------------------------- [ 2022-10-06T17:20:18+08:00 ] 117.132.193.199 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002263s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010992s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000660s ] --------------------------------------------------------------- [ 2022-10-06T17:20:19+08:00 ] 117.132.193.199 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1665048018&v1=0.018331&v2=0.013560&v3=0.015532&v4=-0.004605&v5=12.240000&t=18.111916&h=64.281982&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001517s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009806s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000625s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1665048018,`v1`=0.018331,`v2`=0.01356,`v3`=0.015532,`v4`=-0.004605,`v5`=12.24,`t`=18.111916,`h`=64.281982,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1665048019 WHERE `imei` = '868922055683920' [ RunTime:0.000563s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011165s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1665048018 , 0.018331 , 0.01356 , 0.015532 , -0.004605 , 12.24 , 18.111916 , 64.281982 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1665048019) [ RunTime:0.000656s ] --------------------------------------------------------------- [ 2022-10-06T18:02:51+08:00 ] 39.144.11.101 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002234s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010099s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000938s ] --------------------------------------------------------------- [ 2022-10-06T18:02:59+08:00 ] 39.144.11.101 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221006&time=180201&v1=-01.186&v2=+00.026&v3=-01.077&v4=-00.640&v5=06.0&t=+13.6&h=80.8&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.136&a2=01.218&a3=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.010332s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000671s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221006',`time`='180201',`v1`=-1.186,`v2`=0.026,`v3`=-1.077,`v4`=-0.64,`v5`=6,`t`=13.6,`h`=80.8,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.136,`a2`=1.218,`update_time`=1665050579 WHERE `imei` = '868922055684076' [ RunTime:0.000611s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011725s ] [ 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' , '221006' , '180201' , -1.186 , 0.026 , -1.077 , -0.64 , 6 , 13.6 , 80.8 , 228 , '460044618415249' , -0 , 0.136 , 1.218 , 1665050579 , 1665050579) [ RunTime:0.000740s ] --------------------------------------------------------------- [ 2022-10-06T19:44:13+08:00 ] 39.144.16.81 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002257s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010590s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000655s ] --------------------------------------------------------------- [ 2022-10-06T19:44:14+08:00 ] 39.144.16.81 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1665056653&v1=0.026037&v2=0.080004&v3=0.020197&v4=-0.003040&v5=6.660000&t=11.440906&h=64.007324&rssi=21&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001533s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010462s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000605s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1665056653,`v1`=0.026037,`v2`=0.080004,`v3`=0.020197,`v4`=-0.00304,`v5`=6.66,`t`=11.440906,`h`=64.007324,`rssi`=21,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1665056654 WHERE `imei` = '868922055644211' [ RunTime:0.000535s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009384s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1665056653 , 0.026037 , 0.080004 , 0.020197 , -0.00304 , 6.66 , 11.440906 , 64.007324 , 21 , '89860426102071188505' , '460044618415255' , -0 , 1665056654) [ RunTime:0.000700s ] --------------------------------------------------------------- [ 2022-10-06T22:40:07+08:00 ] 221.178.125.192 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002329s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011618s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000823s ] --------------------------------------------------------------- [ 2022-10-06T22:40:09+08:00 ] 221.178.125.192 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1665067207&v1=0.007134&v2=0.069261&v3=0.007344&v4=0.007375&v5=12.240000&t=17.543381&h=70.057487&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ 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.009564s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000731s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1665067207,`v1`=0.007134,`v2`=0.069261,`v3`=0.007344,`v4`=0.007375,`v5`=12.24,`t`=17.543381,`h`=70.057487,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1665067209 WHERE `imei` = '868922055677740' [ RunTime:0.000547s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010769s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1665067207 , 0.007134 , 0.069261 , 0.007344 , 0.007375 , 12.24 , 17.543381 , 70.057487 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1665067209) [ RunTime:0.000621s ]