--------------------------------------------------------------- [ 2022-10-20T05:20:16+08:00 ] 39.144.10.170 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ 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.010458s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000737s ] --------------------------------------------------------------- [ 2022-10-20T05:20:17+08:00 ] 39.144.10.170 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1666214416&v1=0.018211&v2=0.013456&v3=0.015441&v4=-0.004485&v5=12.060000&t=14.958737&h=63.252014&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001442s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011986s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000593s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1666214416,`v1`=0.018211,`v2`=0.013456,`v3`=0.015441,`v4`=-0.004485,`v5`=12.06,`t`=14.958737,`h`=63.252014,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1666214417 WHERE `imei` = '868922055683920' [ RunTime:0.000536s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.024170s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1666214416 , 0.018211 , 0.013456 , 0.015441 , -0.004485 , 12.06 , 14.958737 , 63.252014 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1666214417) [ RunTime:0.000588s ] --------------------------------------------------------------- [ 2022-10-20T10:49:10+08:00 ] 39.144.18.224 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002290s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012194s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000692s ] --------------------------------------------------------------- [ 2022-10-20T10:49:12+08:00 ] 39.144.18.224 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666234150&v1=0.007375&v2=0.036716&v3=0.007555&v4=0.007676&v5=11.700000&t=20.213924&h=69.737053&rssi=99&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001714s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010380s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000711s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666234150,`v1`=0.007375,`v2`=0.036716,`v3`=0.007555,`v4`=0.007676,`v5`=11.7,`t`=20.213924,`h`=69.737053,`rssi`=99,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666234152 WHERE `imei` = '868922055677740' [ RunTime:0.000627s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011454s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666234150 , 0.007375 , 0.036716 , 0.007555 , 0.007676 , 11.7 , 20.213924 , 69.737053 , 99 , '89860426102071188504' , '460044618415254' , -0 , 1666234152) [ RunTime:0.000951s ] --------------------------------------------------------------- [ 2022-10-20T11:28:23+08:00 ] 27.223.154.40 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002141s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.012691s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2022-10-20T11:28:27+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001489s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010963s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000344s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000737s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000751s ] --------------------------------------------------------------- [ 2022-10-20T11:29:02+08:00 ] 27.223.154.40 GET /admin/show/read/id/24/imei/868922055681221.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001612s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010255s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000698s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012443s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.002281s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681221' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.010982s ] --------------------------------------------------------------- [ 2022-10-20T11:29:06+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001667s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008367s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000375s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000733s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000631s ] --------------------------------------------------------------- [ 2022-10-20T11:31:53+08:00 ] 27.223.154.40 GET /admin/show/read/id/31/imei/868922055644211.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001890s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010069s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000588s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010074s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000483s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644211' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001313s ] --------------------------------------------------------------- [ 2022-10-20T15:05:08+08:00 ] 27.223.154.40 GET /admin/show/read/id/31/imei/868922055644211.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002252s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009738s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000848s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010961s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000672s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644211' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001793s ] --------------------------------------------------------------- [ 2022-10-20T15:05:51+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001737s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010050s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000356s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000783s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000605s ] --------------------------------------------------------------- [ 2022-10-20T15:06:20+08:00 ] 27.223.154.40 GET /admin/show/read/id/30/imei/868922055683920.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002632s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010120s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 30 LIMIT 1 [ RunTime:0.000723s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009795s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.001294s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002302s ] --------------------------------------------------------------- [ 2022-10-20T15:06:25+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002056s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008905s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000398s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000703s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000636s ] --------------------------------------------------------------- [ 2022-10-20T15:06:28+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001445s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009730s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000698s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010264s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001566s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.006775s ] --------------------------------------------------------------- [ 2022-10-20T15:06:36+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001709s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013059s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000390s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000807s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000716s ] --------------------------------------------------------------- [ 2022-10-20T15:06:38+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.015826s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011152s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000407s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000802s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000677s ] --------------------------------------------------------------- [ 2022-10-20T15:06:40+08:00 ] 27.223.154.40 GET /admin/show/read/id/30/imei/868922055683920.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001716s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010196s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 30 LIMIT 1 [ RunTime:0.000714s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008919s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000535s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002480s ] --------------------------------------------------------------- [ 2022-10-20T15:06:45+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001820s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010030s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000289s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000736s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000723s ] --------------------------------------------------------------- [ 2022-10-20T15:06:47+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001572s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010263s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000765s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011666s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000893s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.008768s ] --------------------------------------------------------------- [ 2022-10-20T15:07:00+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001587s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013760s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000396s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000747s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2022-10-20T15:07:02+08:00 ] 27.223.154.40 GET /admin/show/read/id/30/imei/868922055683920.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001970s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013264s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 30 LIMIT 1 [ RunTime:0.000980s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011349s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000606s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002181s ] --------------------------------------------------------------- [ 2022-10-20T15:17:59+08:00 ] 27.223.154.40 GET /admin/show/read/id/30/imei/868922055683920.html?page=29 [ sql ] [ DB ] CONNECT:[ UseTime:0.002631s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010637s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 30 LIMIT 1 [ RunTime:0.000731s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009656s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000607s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 280,10 [ RunTime:0.003875s ] --------------------------------------------------------------- [ 2022-10-20T15:42:24+08:00 ] 117.132.195.16 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.015997s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012512s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000679s ] [ sql ] [ SQL ] INSERT INTO `collect_show` (`imei` , `create_time` , `update_time`) VALUES ('868922055643643' , 1666251744 , 1666251744) [ RunTime:0.000457s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000578s ] --------------------------------------------------------------- [ 2022-10-20T15:42:25+08:00 ] 117.132.195.16 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055643643&create_time=1666251744&v1=0.023749&v2=0.014499&v3=0.021311&v4=0.008880&v5=11.700000&t=21.683374&h=51.571411&rssi=21&ccid=898604650119C1053142&imsi=460048590503142&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001486s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009691s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000729s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`create_time`=1666251744,`v1`=0.023749,`v2`=0.014499,`v3`=0.021311,`v4`=0.00888,`v5`=11.7,`t`=21.683374,`h`=51.571411,`rssi`=21,`ccid`='898604650119C1053142',`imsi`='460048590503142',`v6`=-0,`update_time`=1666251745 WHERE `imei` = '868922055643643' [ RunTime:0.000606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010829s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055643643' , 1666251744 , 0.023749 , 0.014499 , 0.021311 , 0.00888 , 11.7 , 21.683374 , 51.571411 , 21 , '898604650119C1053142' , '460048590503142' , -0 , 1666251745) [ RunTime:0.000801s ] --------------------------------------------------------------- [ 2022-10-20T15:42:33+08:00 ] 27.223.154.40 GET /admin [ sql ] [ DB ] CONNECT:[ UseTime:0.001768s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008956s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000339s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000678s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000677s ] --------------------------------------------------------------- [ 2022-10-20T15:42:34+08:00 ] 27.223.154.40 GET /admin [ sql ] [ DB ] CONNECT:[ UseTime:0.001605s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009514s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000292s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000687s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000571s ] --------------------------------------------------------------- [ 2022-10-20T15:43:05+08:00 ] 27.223.154.40 GET /admin [ sql ] [ DB ] CONNECT:[ UseTime:0.002531s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009934s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000367s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000719s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000738s ] --------------------------------------------------------------- [ 2022-10-20T15:43:09+08:00 ] 27.223.154.40 GET /admin/show/read/id/32/imei/868922055643643.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001472s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014386s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000794s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012267s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000531s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000650s ] --------------------------------------------------------------- [ 2022-10-20T15:44:21+08:00 ] 27.223.154.40 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.009379s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000347s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000662s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000885s ] --------------------------------------------------------------- [ 2022-10-20T15:44:24+08:00 ] 117.132.192.6 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001809s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012920s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000659s ] --------------------------------------------------------------- [ 2022-10-20T15:44:25+08:00 ] 27.223.154.40 GET /admin/show/index.html [ 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.010653s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000363s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000773s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000608s ] --------------------------------------------------------------- [ 2022-10-20T15:44:25+08:00 ] 117.132.192.6 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055643643&create_time=1666251864&v1=0.023990&v2=0.014499&v3=0.021311&v4=0.009120&v5=11.880000&t=21.747725&h=49.549622&rssi=20&ccid=898604650119C1053142&imsi=460048590503142&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001805s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011363s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`create_time`=1666251864,`v1`=0.02399,`v2`=0.014499,`v3`=0.021311,`v4`=0.00912,`v5`=11.88,`t`=21.747725,`h`=49.549622,`rssi`=20,`ccid`='898604650119C1053142',`imsi`='460048590503142',`v6`=-0,`update_time`=1666251865 WHERE `imei` = '868922055643643' [ RunTime:0.000509s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010619s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055643643' , 1666251864 , 0.02399 , 0.014499 , 0.021311 , 0.00912 , 11.88 , 21.747725 , 49.549622 , 20 , '898604650119C1053142' , '460048590503142' , -0 , 1666251865) [ RunTime:0.000522s ] --------------------------------------------------------------- [ 2022-10-20T15:44:28+08:00 ] 27.223.154.40 GET /admin/show/read/id/32/imei/868922055643643.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001699s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009154s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000669s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.022264s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000537s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000582s ] --------------------------------------------------------------- [ 2022-10-20T16:00:30+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002738s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013530s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000338s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000703s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000546s ] --------------------------------------------------------------- [ 2022-10-20T16:00:41+08:00 ] 39.144.2.255 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001356s ] 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` = '868922055644013' LIMIT 1 [ RunTime:0.000696s ] [ sql ] [ SQL ] INSERT INTO `collect_show` (`imei` , `create_time` , `update_time`) VALUES ('868922055644013' , 1666252841 , 1666252841) [ RunTime:0.000420s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000529s ] --------------------------------------------------------------- [ 2022-10-20T16:00:41+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002135s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009817s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000308s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000807s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000822s ] --------------------------------------------------------------- [ 2022-10-20T16:00:42+08:00 ] 39.144.2.255 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644013&create_time=1666252841&v1=0.024592&v2=0.018150&v3=0.022064&v4=-0.000391&v5=11.880000&t=24.203772&h=47.054810&rssi=18&ccid=898604650119C1053143&imsi=460048590503143&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001615s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009759s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000636s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`create_time`=1666252841,`v1`=0.024592,`v2`=0.01815,`v3`=0.022064,`v4`=-0.000391,`v5`=11.88,`t`=24.203772,`h`=47.05481,`rssi`=18,`ccid`='898604650119C1053143',`imsi`='460048590503143',`v6`=-0,`update_time`=1666252842 WHERE `imei` = '868922055644013' [ RunTime:0.000503s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009952s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644013' , 1666252841 , 0.024592 , 0.01815 , 0.022064 , -0.000391 , 11.88 , 24.203772 , 47.05481 , 18 , '898604650119C1053143' , '460048590503143' , -0 , 1666252842) [ RunTime:0.000456s ] --------------------------------------------------------------- [ 2022-10-20T16:00:46+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001531s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009519s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000353s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000768s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000824s ] --------------------------------------------------------------- [ 2022-10-20T16:00:53+08:00 ] 27.223.154.40 GET /admin/show/read/id/33/imei/868922055644013.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002048s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010812s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000765s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010617s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000587s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2022-10-20T16:02:15+08:00 ] 27.223.154.40 GET /admin/show/read/id/33/imei/868922055644013.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002153s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010263s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000714s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010463s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000448s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000607s ] --------------------------------------------------------------- [ 2022-10-20T16:02:18+08:00 ] 27.223.154.40 GET /admin/show/read/id/33/imei/868922055644013.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001389s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009438s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000587s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007803s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000428s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000540s ] --------------------------------------------------------------- [ 2022-10-20T16:02:22+08:00 ] 27.223.154.40 GET /admin/show/read/id/33/imei/868922055644013.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001397s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009947s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000620s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009559s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000455s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000564s ] --------------------------------------------------------------- [ 2022-10-20T16:02:24+08:00 ] 39.144.1.126 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001474s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011023s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000646s ] --------------------------------------------------------------- [ 2022-10-20T16:02:25+08:00 ] 39.144.1.126 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644013&create_time=1666252944&v1=0.024532&v2=0.017315&v3=0.021793&v4=-0.000452&v5=12.060000&t=23.356489&h=45.376343&rssi=18&ccid=898604650119C1053143&imsi=460048590503143&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001626s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010285s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`create_time`=1666252944,`v1`=0.024532,`v2`=0.017315,`v3`=0.021793,`v4`=-0.000452,`v5`=12.06,`t`=23.356489,`h`=45.376343,`rssi`=18,`ccid`='898604650119C1053143',`imsi`='460048590503143',`v6`=-0,`update_time`=1666252945 WHERE `imei` = '868922055644013' [ RunTime:0.000497s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010863s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644013' , 1666252944 , 0.024532 , 0.017315 , 0.021793 , -0.000452 , 12.06 , 23.356489 , 45.376343 , 18 , '898604650119C1053143' , '460048590503143' , -0 , 1666252945) [ RunTime:0.000455s ] --------------------------------------------------------------- [ 2022-10-20T16:02:29+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001585s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009902s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000337s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000659s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000564s ] --------------------------------------------------------------- [ 2022-10-20T16:02:33+08:00 ] 27.223.154.40 GET /admin/show/read/id/33/imei/868922055644013.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001465s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008309s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000600s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010498s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000444s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000624s ] --------------------------------------------------------------- [ 2022-10-20T19:18:34+08:00 ] 112.226.103.28 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002099s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.010010s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000504s ] --------------------------------------------------------------- [ 2022-10-20T19:44:13+08:00 ] 39.144.17.72 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ 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.010609s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000651s ] --------------------------------------------------------------- [ 2022-10-20T19:44:15+08:00 ] 39.144.17.72 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1666266253&v1=0.026157&v2=0.046626&v3=0.022575&v4=-0.000873&v5=6.660000&t=14.004204&h=64.556641&rssi=21&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001360s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009912s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000603s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1666266253,`v1`=0.026157,`v2`=0.046626,`v3`=0.022575,`v4`=-0.000873,`v5`=6.66,`t`=14.004204,`h`=64.556641,`rssi`=21,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1666266255 WHERE `imei` = '868922055644211' [ RunTime:0.000552s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011436s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1666266253 , 0.026157 , 0.046626 , 0.022575 , -0.000873 , 6.66 , 14.004204 , 64.556641 , 21 , '89860426102071188505' , '460044618415255' , -0 , 1666266255) [ RunTime:0.000627s ] --------------------------------------------------------------- [ 2022-10-20T22:10:51+08:00 ] 39.144.7.181 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003140s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010738s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000736s ] --------------------------------------------------------------- [ 2022-10-20T22:10:59+08:00 ] 39.144.7.181 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221020&time=221001&v1=-01.282&v2=+00.032&v3=-01.128&v4=-00.762&v5=06.0&t=+13.2&h=81.2&rssi=+220&imsi=460044618415249&v6=-00.000&a1=00.180&a2=01.299&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001496s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010680s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000598s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221020',`time`='221001',`v1`=-1.282,`v2`=0.032,`v3`=-1.128,`v4`=-0.762,`v5`=6,`t`=13.2,`h`=81.2,`rssi`=220,`imsi`='460044618415249',`v6`=-0,`a1`=0.18,`a2`=1.299,`update_time`=1666275059 WHERE `imei` = '868922055684076' [ RunTime:0.000528s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010875s ] [ 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' , '221020' , '221001' , -1.282 , 0.032 , -1.128 , -0.762 , 6 , 13.2 , 81.2 , 220 , '460044618415249' , -0 , 0.18 , 1.299 , 1666275059 , 1666275059) [ RunTime:0.000573s ] --------------------------------------------------------------- [ 2022-10-20T22:49:30+08:00 ] 39.144.7.242 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002182s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012282s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000640s ] --------------------------------------------------------------- [ 2022-10-20T22:49:31+08:00 ] 39.144.7.242 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666277370&v1=0.007194&v2=0.018045&v3=0.007314&v4=0.007495&v5=11.880000&t=18.090359&h=69.523430&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001736s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009891s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.013064s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666277370,`v1`=0.007194,`v2`=0.018045,`v3`=0.007314,`v4`=0.007495,`v5`=11.88,`t`=18.090359,`h`=69.52343,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666277371 WHERE `imei` = '868922055677740' [ RunTime:0.000561s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011417s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666277370 , 0.007194 , 0.018045 , 0.007314 , 0.007495 , 11.88 , 18.090359 , 69.52343 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1666277371) [ RunTime:0.000591s ]