--------------------------------------------------------------- [ 2021-12-16T00:27:57+08:00 ] 39.144.16.186 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003771s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030164s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000887s ] --------------------------------------------------------------- [ 2021-12-16T00:28:05+08:00 ] 39.144.16.186 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211216&time=002701&v1=-01.293&v2=+00.004&v3=-01.161&v4=-00.768&v5=06.0&t=+06.2&h=72.0&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.155&a2=01.311&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002523s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027126s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000918s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211216',`time`='002701',`v1`=-1.293,`v2`=0.004,`v3`=-1.161,`v4`=-0.768,`v5`=6,`t`=6.2,`h`=72,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.155,`a2`=1.311,`update_time`=1639585685 WHERE `imei` = '868922055684076' [ RunTime:0.000827s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019106s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211216' , '002701' , -1.293 , 0.004 , -1.161 , -0.768 , 6 , 6.2 , 72 , '460044618415249' , -0 , 0.155 , 1.311 , 1639585685 , 1639585685) [ RunTime:0.000676s ] --------------------------------------------------------------- [ 2021-12-16T02:27:57+08:00 ] 39.144.13.176 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003110s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033099s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000809s ] --------------------------------------------------------------- [ 2021-12-16T02:28:06+08:00 ] 39.144.13.176 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211216&time=022701&v1=-01.293&v2=+00.004&v3=-01.161&v4=-00.768&v5=06.0&t=+06.5&h=71.9&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.156&a2=01.312&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002336s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025151s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000803s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211216',`time`='022701',`v1`=-1.293,`v2`=0.004,`v3`=-1.161,`v4`=-0.768,`v5`=6,`t`=6.5,`h`=71.9,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.156,`a2`=1.312,`update_time`=1639592886 WHERE `imei` = '868922055684076' [ RunTime:0.000737s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018726s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211216' , '022701' , -1.293 , 0.004 , -1.161 , -0.768 , 6 , 6.5 , 71.9 , '460044618415249' , -0 , 0.156 , 1.312 , 1639592886 , 1639592886) [ RunTime:0.000702s ] --------------------------------------------------------------- [ 2021-12-16T03:04:57+08:00 ] 39.144.8.115 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003339s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028181s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000762s ] --------------------------------------------------------------- [ 2021-12-16T03:05:05+08:00 ] 39.144.8.115 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211216&time=030401&v1=-01.151&v2=+00.364&v3=-01.166&v4=+00.028&v5=06.2&t=+06.0&h=86.4&rssi=+225&imsi=460044618415257&v6=-00.000&a1=00.019&a2=01.165&a3=00.004&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003181s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025231s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000786s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211216',`time`='030401',`v1`=-1.151,`v2`=0.364,`v3`=-1.166,`v4`=0.028,`v5`=6.2,`t`=6,`h`=86.4,`rssi`=225,`imsi`='460044618415257',`v6`=-0,`a1`=0.019,`a2`=1.165,`update_time`=1639595105 WHERE `imei` = '868922055681221' [ RunTime:0.000839s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019258s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055681221' , '211216' , '030401' , -1.151 , 0.364 , -1.166 , 0.028 , 6.2 , 6 , 86.4 , '460044618415257' , -0 , 0.019 , 1.165 , 1639595105 , 1639595105) [ RunTime:0.001144s ] --------------------------------------------------------------- [ 2021-12-16T04:27:58+08:00 ] 117.132.191.34 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003400s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029152s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000787s ] --------------------------------------------------------------- [ 2021-12-16T04:28:06+08:00 ] 117.132.191.34 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211216&time=042701&v1=-01.294&v2=+00.005&v3=-01.161&v4=-00.768&v5=06.0&t=+05.8&h=72.2&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.156&a2=01.312&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002049s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027789s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000843s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211216',`time`='042701',`v1`=-1.294,`v2`=0.005,`v3`=-1.161,`v4`=-0.768,`v5`=6,`t`=5.8,`h`=72.2,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.156,`a2`=1.312,`update_time`=1639600086 WHERE `imei` = '868922055684076' [ RunTime:0.000841s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019337s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211216' , '042701' , -1.294 , 0.005 , -1.161 , -0.768 , 6 , 5.8 , 72.2 , '460044618415249' , -0 , 0.156 , 1.312 , 1639600086 , 1639600086) [ RunTime:0.000738s ] --------------------------------------------------------------- [ 2021-12-16T06:27:57+08:00 ] 39.144.7.216 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003222s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.043073s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000797s ] --------------------------------------------------------------- [ 2021-12-16T06:28:06+08:00 ] 39.144.7.216 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211216&time=062701&v1=-01.292&v2=+00.004&v3=-01.161&v4=-00.767&v5=06.0&t=+06.0&h=71.9&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.154&a2=01.311&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002121s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024040s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000725s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211216',`time`='062701',`v1`=-1.292,`v2`=0.004,`v3`=-1.161,`v4`=-0.767,`v5`=6,`t`=6,`h`=71.9,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.154,`a2`=1.311,`update_time`=1639607286 WHERE `imei` = '868922055684076' [ RunTime:0.000785s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.027404s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211216' , '062701' , -1.292 , 0.004 , -1.161 , -0.767 , 6 , 6 , 71.9 , '460044618415249' , -0 , 0.154 , 1.311 , 1639607286 , 1639607286) [ RunTime:0.000679s ] --------------------------------------------------------------- [ 2021-12-16T08:27:58+08:00 ] 218.204.253.148 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003217s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.042386s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000886s ] --------------------------------------------------------------- [ 2021-12-16T08:28:06+08:00 ] 218.204.253.148 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211216&time=082701&v1=-01.293&v2=+00.004&v3=-01.161&v4=-00.767&v5=06.0&t=+06.1&h=72.0&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.156&a2=01.311&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002655s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028170s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000726s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211216',`time`='082701',`v1`=-1.293,`v2`=0.004,`v3`=-1.161,`v4`=-0.767,`v5`=6,`t`=6.1,`h`=72,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.156,`a2`=1.311,`update_time`=1639614486 WHERE `imei` = '868922055684076' [ RunTime:0.001168s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017760s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211216' , '082701' , -1.293 , 0.004 , -1.161 , -0.767 , 6 , 6.1 , 72 , '460044618415249' , -0 , 0.156 , 1.311 , 1639614486 , 1639614486) [ RunTime:0.000658s ] --------------------------------------------------------------- [ 2021-12-16T09:04:56+08:00 ] 218.204.252.132 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003187s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.035268s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000836s ] --------------------------------------------------------------- [ 2021-12-16T09:05:05+08:00 ] 218.204.252.132 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211216&time=090401&v1=-01.439&v2=+00.686&v3=-01.364&v4=+00.029&v5=06.0&t=+06.9&h=86.0&rssi=+225&imsi=460044618415257&v6=-00.000&a1=00.090&a2=17.232&a3=00.238&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003404s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030837s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000742s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211216',`time`='090401',`v1`=-1.439,`v2`=0.686,`v3`=-1.364,`v4`=0.029,`v5`=6,`t`=6.9,`h`=86,`rssi`=225,`imsi`='460044618415257',`v6`=-0,`a1`=0.09,`a2`=17.232,`update_time`=1639616705 WHERE `imei` = '868922055681221' [ RunTime:0.000870s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020769s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055681221' , '211216' , '090401' , -1.439 , 0.686 , -1.364 , 0.029 , 6 , 6.9 , 86 , '460044618415257' , -0 , 0.09 , 17.232 , 1639616705 , 1639616705) [ RunTime:0.000846s ] --------------------------------------------------------------- [ 2021-12-16T10:27:57+08:00 ] 39.144.2.8 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003365s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.040275s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000995s ] --------------------------------------------------------------- [ 2021-12-16T10:28:05+08:00 ] 39.144.2.8 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211216&time=102701&v1=-01.291&v2=+00.005&v3=-01.160&v4=-00.767&v5=06.0&t=+09.0&h=71.3&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.153&a2=01.309&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002282s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025180s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000760s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211216',`time`='102701',`v1`=-1.291,`v2`=0.005,`v3`=-1.16,`v4`=-0.767,`v5`=6,`t`=9,`h`=71.3,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.153,`a2`=1.309,`update_time`=1639621685 WHERE `imei` = '868922055684076' [ RunTime:0.001284s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021848s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211216' , '102701' , -1.291 , 0.005 , -1.16 , -0.767 , 6 , 9 , 71.3 , '460044618415249' , -0 , 0.153 , 1.309 , 1639621685 , 1639621685) [ RunTime:0.000755s ] --------------------------------------------------------------- [ 2021-12-16T11:37:25+08:00 ] 112.224.67.190 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003099s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026251s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000860s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017746s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001293s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001494s ] --------------------------------------------------------------- [ 2021-12-16T11:49:09+08:00 ] 112.224.67.190 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003241s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026479s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000890s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016989s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001427s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001344s ] --------------------------------------------------------------- [ 2021-12-16T11:49:14+08:00 ] 112.224.67.190 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002248s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024072s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000832s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001263s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001384s ] --------------------------------------------------------------- [ 2021-12-16T11:49:20+08:00 ] 112.224.67.190 GET /admin/show/read/id/26/imei/868922055684076.html [ 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.022516s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000701s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016608s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000985s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001365s ] --------------------------------------------------------------- [ 2021-12-16T12:14:43+08:00 ] 223.80.204.39 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003582s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027771s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000842s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020881s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001139s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001466s ] --------------------------------------------------------------- [ 2021-12-16T12:17:16+08:00 ] 223.80.204.39 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002625s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024047s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000684s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015806s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001103s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001356s ] --------------------------------------------------------------- [ 2021-12-16T12:27:57+08:00 ] 39.144.2.198 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003279s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032010s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000833s ] --------------------------------------------------------------- [ 2021-12-16T12:28:06+08:00 ] 39.144.2.198 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211216&time=122701&v1=-01.291&v2=+00.004&v3=-01.160&v4=-00.769&v5=06.0&t=+09.9&h=71.4&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.153&a2=01.309&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002595s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024873s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001065s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211216',`time`='122701',`v1`=-1.291,`v2`=0.004,`v3`=-1.16,`v4`=-0.769,`v5`=6,`t`=9.9,`h`=71.4,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.153,`a2`=1.309,`update_time`=1639628886 WHERE `imei` = '868922055684076' [ RunTime:0.001698s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.024319s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211216' , '122701' , -1.291 , 0.004 , -1.16 , -0.769 , 6 , 9.9 , 71.4 , '460044618415249' , -0 , 0.153 , 1.309 , 1639628886 , 1639628886) [ RunTime:0.000808s ] --------------------------------------------------------------- [ 2021-12-16T12:49:52+08:00 ] 223.80.204.39 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003369s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029863s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000882s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018371s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001150s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001482s ] --------------------------------------------------------------- [ 2021-12-16T13:00:17+08:00 ] 112.224.65.100 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003340s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.039322s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000686s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.032161s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001068s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001439s ] --------------------------------------------------------------- [ 2021-12-16T13:00:30+08:00 ] 112.224.65.100 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002156s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023533s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000859s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016201s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001097s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001540s ] --------------------------------------------------------------- [ 2021-12-16T13:12:15+08:00 ] 112.224.65.100 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003236s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033111s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000753s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015567s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001110s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001326s ] --------------------------------------------------------------- [ 2021-12-16T14:01:38+08:00 ] 123.234.86.34 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003298s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031658s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000846s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018465s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001086s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001404s ] --------------------------------------------------------------- [ 2021-12-16T14:27:58+08:00 ] 39.144.3.180 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.004256s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033546s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000769s ] --------------------------------------------------------------- [ 2021-12-16T14:28:06+08:00 ] 39.144.3.180 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211216&time=142701&v1=-01.292&v2=+00.004&v3=-01.158&v4=-00.771&v5=06.0&t=+08.9&h=72.0&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.157&a2=01.310&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002295s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027790s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000779s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211216',`time`='142701',`v1`=-1.292,`v2`=0.004,`v3`=-1.158,`v4`=-0.771,`v5`=6,`t`=8.9,`h`=72,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.157,`a2`=1.31,`update_time`=1639636086 WHERE `imei` = '868922055684076' [ RunTime:0.000899s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017870s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211216' , '142701' , -1.292 , 0.004 , -1.158 , -0.771 , 6 , 8.9 , 72 , '460044618415249' , -0 , 0.157 , 1.31 , 1639636086 , 1639636086) [ RunTime:0.000747s ] --------------------------------------------------------------- [ 2021-12-16T14:50:13+08:00 ] 112.224.65.100 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003332s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.046609s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000870s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.022051s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001672s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002372s ] --------------------------------------------------------------- [ 2021-12-16T14:54:05+08:00 ] 112.224.65.100 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002772s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024284s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000772s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017308s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001050s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001583s ] --------------------------------------------------------------- [ 2021-12-16T14:58:02+08:00 ] 112.224.65.100 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003173s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026995s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000730s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016424s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000919s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001242s ] --------------------------------------------------------------- [ 2021-12-16T15:04:57+08:00 ] 39.144.14.149 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.030260s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027363s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000743s ] --------------------------------------------------------------- [ 2021-12-16T15:05:05+08:00 ] 39.144.14.149 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211216&time=150401&v1=-01.770&v2=+01.251&v3=-01.624&v4=+00.028&v5=06.2&t=+08.5&h=86.4&rssi=+226&imsi=460044618415257&v6=-00.000&a1=00.076&a2=21.317&a3=00.304&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002982s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031239s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000745s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211216',`time`='150401',`v1`=-1.77,`v2`=1.251,`v3`=-1.624,`v4`=0.028,`v5`=6.2,`t`=8.5,`h`=86.4,`rssi`=226,`imsi`='460044618415257',`v6`=-0,`a1`=0.076,`a2`=21.317,`update_time`=1639638305 WHERE `imei` = '868922055681221' [ RunTime:0.000653s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016702s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055681221' , '211216' , '150401' , -1.77 , 1.251 , -1.624 , 0.028 , 6.2 , 8.5 , 86.4 , '460044618415257' , -0 , 0.076 , 21.317 , 1639638305 , 1639638305) [ RunTime:0.000914s ] --------------------------------------------------------------- [ 2021-12-16T16:27:57+08:00 ] 39.144.3.150 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003864s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.039038s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000887s ] --------------------------------------------------------------- [ 2021-12-16T16:28:05+08:00 ] 39.144.3.150 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211216&time=162701&v1=-01.292&v2=+00.004&v3=-01.156&v4=-00.771&v5=06.0&t=+07.3&h=72.3&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.160&a2=01.311&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002702s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029461s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000781s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211216',`time`='162701',`v1`=-1.292,`v2`=0.004,`v3`=-1.156,`v4`=-0.771,`v5`=6,`t`=7.3,`h`=72.3,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.16,`a2`=1.311,`update_time`=1639643285 WHERE `imei` = '868922055684076' [ RunTime:0.000727s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018764s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211216' , '162701' , -1.292 , 0.004 , -1.156 , -0.771 , 6 , 7.3 , 72.3 , '460044618415249' , -0 , 0.16 , 1.311 , 1639643285 , 1639643285) [ RunTime:0.000720s ] --------------------------------------------------------------- [ 2021-12-16T16:37:51+08:00 ] 123.234.86.34 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.006802s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.485709s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.001599s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:1.403558s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.002938s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 150,10 [ RunTime:0.005632s ] --------------------------------------------------------------- [ 2021-12-16T17:34:41+08:00 ] 123.234.86.34 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.003317s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028416s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000821s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018102s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001049s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 150,10 [ RunTime:0.005011s ] --------------------------------------------------------------- [ 2021-12-16T18:06:53+08:00 ] 112.224.65.100 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.003654s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032687s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.001265s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.027923s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.002392s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 150,10 [ RunTime:0.006078s ] --------------------------------------------------------------- [ 2021-12-16T18:27:57+08:00 ] 117.132.194.57 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003106s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.034807s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000846s ] --------------------------------------------------------------- [ 2021-12-16T18:28:06+08:00 ] 117.132.194.57 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211216&time=182701&v1=-01.294&v2=+00.004&v3=-01.157&v4=-00.772&v5=06.0&t=+05.1&h=72.6&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.161&a2=01.312&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003154s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027317s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000744s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211216',`time`='182701',`v1`=-1.294,`v2`=0.004,`v3`=-1.157,`v4`=-0.772,`v5`=6,`t`=5.1,`h`=72.6,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.161,`a2`=1.312,`update_time`=1639650486 WHERE `imei` = '868922055684076' [ RunTime:0.001228s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019333s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211216' , '182701' , -1.294 , 0.004 , -1.157 , -0.772 , 6 , 5.1 , 72.6 , '460044618415249' , -0 , 0.161 , 1.312 , 1639650486 , 1639650486) [ RunTime:0.000752s ] --------------------------------------------------------------- [ 2021-12-16T20:28:00+08:00 ] 117.132.195.231 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.037323s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.048261s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000800s ] --------------------------------------------------------------- [ 2021-12-16T20:28:06+08:00 ] 117.132.195.231 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211216&time=202701&v1=-01.294&v2=+00.004&v3=-01.157&v4=-00.772&v5=06.0&t=+04.1&h=72.7&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.165&a2=01.314&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002292s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022541s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000743s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211216',`time`='202701',`v1`=-1.294,`v2`=0.004,`v3`=-1.157,`v4`=-0.772,`v5`=6,`t`=4.1,`h`=72.7,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.165,`a2`=1.314,`update_time`=1639657686 WHERE `imei` = '868922055684076' [ RunTime:0.000802s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.047461s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211216' , '202701' , -1.294 , 0.004 , -1.157 , -0.772 , 6 , 4.1 , 72.7 , '460044618415249' , -0 , 0.165 , 1.314 , 1639657686 , 1639657686) [ RunTime:0.000720s ] --------------------------------------------------------------- [ 2021-12-16T21:04:58+08:00 ] 39.144.15.29 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.025097s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025982s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000827s ] --------------------------------------------------------------- [ 2021-12-16T21:05:05+08:00 ] 39.144.15.29 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211216&time=210401&v1=-01.135&v2=+00.931&v3=-01.140&v4=+00.028&v5=06.0&t=+03.4&h=86.4&rssi=+227&imsi=460044618415257&v6=-00.000&a1=00.052&a2=29.367&a3=00.346&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002573s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023008s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000864s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211216',`time`='210401',`v1`=-1.135,`v2`=0.931,`v3`=-1.14,`v4`=0.028,`v5`=6,`t`=3.4,`h`=86.4,`rssi`=227,`imsi`='460044618415257',`v6`=-0,`a1`=0.052,`a2`=29.367,`update_time`=1639659905 WHERE `imei` = '868922055681221' [ RunTime:0.000815s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.022534s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055681221' , '211216' , '210401' , -1.135 , 0.931 , -1.14 , 0.028 , 6 , 3.4 , 86.4 , '460044618415257' , -0 , 0.052 , 29.367 , 1639659905 , 1639659905) [ RunTime:0.000682s ] --------------------------------------------------------------- [ 2021-12-16T22:27:56+08:00 ] 39.144.14.77 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003113s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.034737s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000849s ] --------------------------------------------------------------- [ 2021-12-16T22:28:05+08:00 ] 39.144.14.77 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211216&time=222701&v1=-01.296&v2=+00.004&v3=-01.158&v4=-00.771&v5=06.0&t=+02.7&h=72.8&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.162&a2=01.313&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003119s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030388s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000774s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211216',`time`='222701',`v1`=-1.296,`v2`=0.004,`v3`=-1.158,`v4`=-0.771,`v5`=6,`t`=2.7,`h`=72.8,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.162,`a2`=1.313,`update_time`=1639664885 WHERE `imei` = '868922055684076' [ RunTime:0.000696s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021246s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211216' , '222701' , -1.296 , 0.004 , -1.158 , -0.771 , 6 , 2.7 , 72.8 , '460044618415249' , -0 , 0.162 , 1.313 , 1639664885 , 1639664885) [ RunTime:0.000678s ] --------------------------------------------------------------- [ 2021-12-16T23:54:06+08:00 ] 112.9.190.216 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.003205s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025640s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000785s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017277s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001617s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 150,10 [ RunTime:0.005428s ] --------------------------------------------------------------- [ 2021-12-16T23:55:29+08:00 ] 112.9.190.216 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.002354s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029598s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.001079s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.022428s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.002433s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 150,10 [ RunTime:0.005442s ]