--------------------------------------------------------------- [ 2021-12-21T00:27:58+08:00 ] 117.132.195.92 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.004000s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030456s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000845s ] --------------------------------------------------------------- [ 2021-12-21T00:28:06+08:00 ] 117.132.195.92 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211221&time=002701&v1=-01.294&v2=+00.005&v3=-01.161&v4=-00.773&v5=06.0&t=+05.0&h=73.1&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.158&a2=01.311&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002070s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027994s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000730s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211221',`time`='002701',`v1`=-1.294,`v2`=0.005,`v3`=-1.161,`v4`=-0.773,`v5`=6,`t`=5,`h`=73.1,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.158,`a2`=1.311,`update_time`=1640017686 WHERE `imei` = '868922055684076' [ RunTime:0.000788s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018308s ] [ 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' , '211221' , '002701' , -1.294 , 0.005 , -1.161 , -0.773 , 6 , 5 , 73.1 , '460044618415249' , -0 , 0.158 , 1.311 , 1640017686 , 1640017686) [ RunTime:0.001146s ] --------------------------------------------------------------- [ 2021-12-21T02:27:57+08:00 ] 218.204.253.155 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003607s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032529s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000854s ] --------------------------------------------------------------- [ 2021-12-21T02:28:06+08:00 ] 218.204.253.155 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211221&time=022701&v1=-01.295&v2=+00.006&v3=-01.161&v4=-00.774&v5=06.0&t=+04.5&h=73.2&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.158&a2=01.311&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002076s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.020951s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000743s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211221',`time`='022701',`v1`=-1.295,`v2`=0.006,`v3`=-1.161,`v4`=-0.774,`v5`=6,`t`=4.5,`h`=73.2,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.158,`a2`=1.311,`update_time`=1640024886 WHERE `imei` = '868922055684076' [ RunTime:0.000808s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018084s ] [ 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' , '211221' , '022701' , -1.295 , 0.006 , -1.161 , -0.774 , 6 , 4.5 , 73.2 , '460044618415249' , -0 , 0.158 , 1.311 , 1640024886 , 1640024886) [ RunTime:0.000704s ] --------------------------------------------------------------- [ 2021-12-21T03:04:55+08:00 ] 39.144.2.169 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003175s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.037902s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000745s ] --------------------------------------------------------------- [ 2021-12-21T03:05:04+08:00 ] 39.144.2.169 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211221&time=030401&v1=-01.192&v2=+00.479&v3=-01.202&v4=+00.028&v5=06.0&t=+02.1&h=86.6&rssi=+225&imsi=460044618415257&v6=-00.000&a1=00.019&a2=01.199&a3=00.004&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002380s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026855s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000761s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211221',`time`='030401',`v1`=-1.192,`v2`=0.479,`v3`=-1.202,`v4`=0.028,`v5`=6,`t`=2.1,`h`=86.6,`rssi`=225,`imsi`='460044618415257',`v6`=-0,`a1`=0.019,`a2`=1.199,`update_time`=1640027104 WHERE `imei` = '868922055681221' [ RunTime:0.000719s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015224s ] [ 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' , '211221' , '030401' , -1.192 , 0.479 , -1.202 , 0.028 , 6 , 2.1 , 86.6 , '460044618415257' , -0 , 0.019 , 1.199 , 1640027104 , 1640027104) [ RunTime:0.000620s ] --------------------------------------------------------------- [ 2021-12-21T04:27:58+08:00 ] 117.132.193.239 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003215s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.048033s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001530s ] --------------------------------------------------------------- [ 2021-12-21T04:28:06+08:00 ] 117.132.193.239 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211221&time=042701&v1=-01.295&v2=+00.005&v3=-01.162&v4=-00.774&v5=06.0&t=+02.9&h=73.6&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.312&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002061s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022065s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000783s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211221',`time`='042701',`v1`=-1.295,`v2`=0.005,`v3`=-1.162,`v4`=-0.774,`v5`=6,`t`=2.9,`h`=73.6,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.312,`update_time`=1640032086 WHERE `imei` = '868922055684076' [ RunTime:0.000819s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017849s ] [ 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' , '211221' , '042701' , -1.295 , 0.005 , -1.162 , -0.774 , 6 , 2.9 , 73.6 , '460044618415249' , -0 , 0.159 , 1.312 , 1640032086 , 1640032086) [ RunTime:0.002150s ] --------------------------------------------------------------- [ 2021-12-21T06:27:57+08:00 ] 223.104.254.157 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003336s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.035168s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000837s ] --------------------------------------------------------------- [ 2021-12-21T06:28:05+08:00 ] 223.104.254.157 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211221&time=062701&v1=-01.295&v2=+00.005&v3=-01.162&v4=-00.773&v5=05.9&t=+01.2&h=73.7&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.312&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002502s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026032s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000915s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211221',`time`='062701',`v1`=-1.295,`v2`=0.005,`v3`=-1.162,`v4`=-0.773,`v5`=5.9,`t`=1.2,`h`=73.7,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.312,`update_time`=1640039285 WHERE `imei` = '868922055684076' [ RunTime:0.000944s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020593s ] [ 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' , '211221' , '062701' , -1.295 , 0.005 , -1.162 , -0.773 , 5.9 , 1.2 , 73.7 , '460044618415249' , -0 , 0.159 , 1.312 , 1640039285 , 1640039285) [ RunTime:0.000932s ] --------------------------------------------------------------- [ 2021-12-21T08:27:57+08:00 ] 39.144.17.185 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003490s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.044531s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000843s ] --------------------------------------------------------------- [ 2021-12-21T08:28:06+08:00 ] 39.144.17.185 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211221&time=082701&v1=-01.294&v2=+00.005&v3=-01.161&v4=-00.772&v5=05.9&t=+04.4&h=72.6&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.158&a2=01.311&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002212s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.035537s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000701s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211221',`time`='082701',`v1`=-1.294,`v2`=0.005,`v3`=-1.161,`v4`=-0.772,`v5`=5.9,`t`=4.4,`h`=72.6,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.158,`a2`=1.311,`update_time`=1640046486 WHERE `imei` = '868922055684076' [ RunTime:0.000779s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017089s ] [ 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' , '211221' , '082701' , -1.294 , 0.005 , -1.161 , -0.772 , 5.9 , 4.4 , 72.6 , '460044618415249' , -0 , 0.158 , 1.311 , 1640046486 , 1640046486) [ RunTime:0.000684s ] --------------------------------------------------------------- [ 2021-12-21T09:04:57+08:00 ] 117.132.195.93 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003885s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.034286s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000990s ] --------------------------------------------------------------- [ 2021-12-21T09:05:05+08:00 ] 117.132.195.93 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211221&time=090401&v1=-01.314&v2=+00.264&v3=-01.328&v4=+00.029&v5=06.0&t=+07.1&h=85.7&rssi=+227&imsi=460044618415257&v6=-00.000&a1=00.018&a2=01.255&a3=00.002&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002590s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022416s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000682s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211221',`time`='090401',`v1`=-1.314,`v2`=0.264,`v3`=-1.328,`v4`=0.029,`v5`=6,`t`=7.1,`h`=85.7,`rssi`=227,`imsi`='460044618415257',`v6`=-0,`a1`=0.018,`a2`=1.255,`update_time`=1640048705 WHERE `imei` = '868922055681221' [ RunTime:0.000640s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016144s ] [ 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' , '211221' , '090401' , -1.314 , 0.264 , -1.328 , 0.029 , 6 , 7.1 , 85.7 , '460044618415257' , -0 , 0.018 , 1.255 , 1640048705 , 1640048705) [ RunTime:0.000652s ] --------------------------------------------------------------- [ 2021-12-21T10:27:58+08:00 ] 39.144.2.249 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003219s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028310s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000775s ] --------------------------------------------------------------- [ 2021-12-21T10:28:06+08:00 ] 39.144.2.249 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211221&time=102701&v1=-01.293&v2=+00.004&v3=-01.159&v4=-00.773&v5=06.0&t=+12.5&h=71.7&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.158&a2=01.310&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002141s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024691s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000852s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211221',`time`='102701',`v1`=-1.293,`v2`=0.004,`v3`=-1.159,`v4`=-0.773,`v5`=6,`t`=12.5,`h`=71.7,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.158,`a2`=1.31,`update_time`=1640053686 WHERE `imei` = '868922055684076' [ RunTime:0.000781s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019021s ] [ 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' , '211221' , '102701' , -1.293 , 0.004 , -1.159 , -0.773 , 6 , 12.5 , 71.7 , '460044618415249' , -0 , 0.158 , 1.31 , 1640053686 , 1640053686) [ RunTime:0.001306s ] --------------------------------------------------------------- [ 2021-12-21T12:27:57+08:00 ] 39.144.14.19 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003387s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.038658s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000814s ] --------------------------------------------------------------- [ 2021-12-21T12:28:06+08:00 ] 39.144.14.19 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211221&time=122701&v1=-01.293&v2=+00.004&v3=-01.159&v4=-00.773&v5=06.0&t=+10.1&h=72.6&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.158&a2=01.310&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002129s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024687s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000767s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211221',`time`='122701',`v1`=-1.293,`v2`=0.004,`v3`=-1.159,`v4`=-0.773,`v5`=6,`t`=10.1,`h`=72.6,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.158,`a2`=1.31,`update_time`=1640060886 WHERE `imei` = '868922055684076' [ RunTime:0.000813s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017696s ] [ 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' , '211221' , '122701' , -1.293 , 0.004 , -1.159 , -0.773 , 6 , 10.1 , 72.6 , '460044618415249' , -0 , 0.158 , 1.31 , 1640060886 , 1640060886) [ RunTime:0.000967s ] --------------------------------------------------------------- [ 2021-12-21T14:27:57+08:00 ] 117.132.193.147 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003461s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033184s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001010s ] --------------------------------------------------------------- [ 2021-12-21T14:28:06+08:00 ] 117.132.193.147 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211221&time=142701&v1=-01.293&v2=+00.005&v3=-01.159&v4=-00.773&v5=06.0&t=+10.6&h=72.4&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.157&a2=01.309&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002026s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024546s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000736s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211221',`time`='142701',`v1`=-1.293,`v2`=0.005,`v3`=-1.159,`v4`=-0.773,`v5`=6,`t`=10.6,`h`=72.4,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.157,`a2`=1.309,`update_time`=1640068086 WHERE `imei` = '868922055684076' [ RunTime:0.000828s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017552s ] [ 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' , '211221' , '142701' , -1.293 , 0.005 , -1.159 , -0.773 , 6 , 10.6 , 72.4 , '460044618415249' , -0 , 0.157 , 1.309 , 1640068086 , 1640068086) [ RunTime:0.000701s ] --------------------------------------------------------------- [ 2021-12-21T15:04:56+08:00 ] 117.132.194.140 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003227s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030026s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000889s ] --------------------------------------------------------------- [ 2021-12-21T15:05:05+08:00 ] 117.132.194.140 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211221&time=150401&v1=-01.412&v2=+02.257&v3=-01.408&v4=+00.029&v5=06.2&t=+16.1&h=86.0&rssi=+226&imsi=460044618415257&v6=-00.000&a1=00.112&a2=05.327&a3=00.133&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002142s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027236s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000779s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211221',`time`='150401',`v1`=-1.412,`v2`=2.257,`v3`=-1.408,`v4`=0.029,`v5`=6.2,`t`=16.1,`h`=86,`rssi`=226,`imsi`='460044618415257',`v6`=-0,`a1`=0.112,`a2`=5.327,`update_time`=1640070305 WHERE `imei` = '868922055681221' [ RunTime:0.000700s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019318s ] [ 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' , '211221' , '150401' , -1.412 , 2.257 , -1.408 , 0.029 , 6.2 , 16.1 , 86 , '460044618415257' , -0 , 0.112 , 5.327 , 1640070305 , 1640070305) [ RunTime:0.000738s ] --------------------------------------------------------------- [ 2021-12-21T16:27:58+08:00 ] 39.144.1.21 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003283s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.035879s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000878s ] --------------------------------------------------------------- [ 2021-12-21T16:28:06+08:00 ] 39.144.1.21 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211221&time=162701&v1=-01.293&v2=+00.005&v3=-01.161&v4=-00.774&v5=06.0&t=+08.1&h=73.3&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.157&a2=01.310&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002036s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021991s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000787s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211221',`time`='162701',`v1`=-1.293,`v2`=0.005,`v3`=-1.161,`v4`=-0.774,`v5`=6,`t`=8.1,`h`=73.3,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.157,`a2`=1.31,`update_time`=1640075286 WHERE `imei` = '868922055684076' [ RunTime:0.000715s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016194s ] [ 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' , '211221' , '162701' , -1.293 , 0.005 , -1.161 , -0.774 , 6 , 8.1 , 73.3 , '460044618415249' , -0 , 0.157 , 1.31 , 1640075286 , 1640075286) [ RunTime:0.000711s ] --------------------------------------------------------------- [ 2021-12-21T16:47:50+08:00 ] 123.234.86.34 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003486s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.043639s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000782s ] --------------------------------------------------------------- [ 2021-12-21T16:47:52+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001920s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023114s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000415s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001490s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001372s ] --------------------------------------------------------------- [ 2021-12-21T16:48:04+08:00 ] 123.234.86.34 GET /admin/show/read/id/24/imei/868922055681221.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002303s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025534s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 24 LIMIT 1 [ RunTime:0.001224s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020373s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.004036s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681221' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001751s ] --------------------------------------------------------------- [ 2021-12-21T16:48:21+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002880s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023775s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000360s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001241s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001205s ] --------------------------------------------------------------- [ 2021-12-21T16:48:38+08:00 ] 123.234.86.34 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002565s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.039963s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000713s ] --------------------------------------------------------------- [ 2021-12-21T16:48:39+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002083s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021785s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001082s ] --------------------------------------------------------------- [ 2021-12-21T16:48:41+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003214s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021836s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000562s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000947s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000911s ] --------------------------------------------------------------- [ 2021-12-21T16:48:51+08:00 ] 123.234.86.34 GET /home/show/read/id/24/imei/868922055681221.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002278s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023063s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000767s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017519s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001087s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681221' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.001538s ] --------------------------------------------------------------- [ 2021-12-21T16:48:53+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002142s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024492s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000528s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000960s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000846s ] --------------------------------------------------------------- [ 2021-12-21T16:48:55+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004250s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024579s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001073s ] --------------------------------------------------------------- [ 2021-12-21T16:49:26+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002634s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.035118s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000584s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000991s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000882s ] --------------------------------------------------------------- [ 2021-12-21T16:49:32+08:00 ] 123.234.86.34 GET /home/show/read/id/24/imei/868922055681221.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002007s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023020s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000702s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017819s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001185s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681221' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.001458s ] --------------------------------------------------------------- [ 2021-12-21T16:49:35+08:00 ] 123.234.86.34 GET /home/show/read/id/24/imei/868922055681221.html?page=32 [ sql ] [ DB ] CONNECT:[ UseTime:0.002895s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028990s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000717s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017238s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001087s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681221' ORDER BY `update_time` ASC LIMIT 310,10 [ RunTime:0.009280s ] --------------------------------------------------------------- [ 2021-12-21T18:04:31+08:00 ] 112.9.190.216 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003777s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.026719s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000688s ] --------------------------------------------------------------- [ 2021-12-21T18:04:37+08:00 ] 112.9.190.216 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002148s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024375s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000411s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001389s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001282s ] --------------------------------------------------------------- [ 2021-12-21T18:04:47+08:00 ] 112.9.190.216 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.010830s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021899s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000791s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017967s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001125s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001498s ] --------------------------------------------------------------- [ 2021-12-21T18:27:57+08:00 ] 221.178.127.245 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.004890s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.040438s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000815s ] --------------------------------------------------------------- [ 2021-12-21T18:28:06+08:00 ] 221.178.127.245 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211221&time=182701&v1=-01.294&v2=+00.003&v3=-01.162&v4=-00.774&v5=06.0&t=+05.6&h=73.6&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.157&a2=01.310&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002052s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024018s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000721s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211221',`time`='182701',`v1`=-1.294,`v2`=0.003,`v3`=-1.162,`v4`=-0.774,`v5`=6,`t`=5.6,`h`=73.6,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.157,`a2`=1.31,`update_time`=1640082486 WHERE `imei` = '868922055684076' [ RunTime:0.000855s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.054837s ] [ 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' , '211221' , '182701' , -1.294 , 0.003 , -1.162 , -0.774 , 6 , 5.6 , 73.6 , '460044618415249' , -0 , 0.157 , 1.31 , 1640082486 , 1640082486) [ RunTime:0.000713s ] --------------------------------------------------------------- [ 2021-12-21T19:13:19+08:00 ] 112.224.65.1 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003054s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029488s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000806s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016621s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001096s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001342s ] --------------------------------------------------------------- [ 2021-12-21T20:27:58+08:00 ] 221.178.124.79 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003530s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030341s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000767s ] --------------------------------------------------------------- [ 2021-12-21T20:28:06+08:00 ] 221.178.124.79 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211221&time=202701&v1=-01.294&v2=+00.004&v3=-01.162&v4=-00.774&v5=05.4&t=+05.2&h=73.4&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.157&a2=01.310&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002563s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022965s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000764s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211221',`time`='202701',`v1`=-1.294,`v2`=0.004,`v3`=-1.162,`v4`=-0.774,`v5`=5.4,`t`=5.2,`h`=73.4,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.157,`a2`=1.31,`update_time`=1640089686 WHERE `imei` = '868922055684076' [ RunTime:0.000788s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017787s ] [ 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' , '211221' , '202701' , -1.294 , 0.004 , -1.162 , -0.774 , 5.4 , 5.2 , 73.4 , '460044618415249' , -0 , 0.157 , 1.31 , 1640089686 , 1640089686) [ RunTime:0.000721s ] --------------------------------------------------------------- [ 2021-12-21T21:04:58+08:00 ] 117.132.193.44 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.026036s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024546s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000783s ] --------------------------------------------------------------- [ 2021-12-21T21:05:05+08:00 ] 117.132.193.44 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211221&time=210401&v1=-01.533&v2=+01.257&v3=-01.541&v4=+00.029&v5=06.0&t=+06.1&h=86.6&rssi=+226&imsi=460044618415257&v6=-00.000&a1=00.066&a2=18.251&a3=00.290&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.004470s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022941s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000670s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211221',`time`='210401',`v1`=-1.533,`v2`=1.257,`v3`=-1.541,`v4`=0.029,`v5`=6,`t`=6.1,`h`=86.6,`rssi`=226,`imsi`='460044618415257',`v6`=-0,`a1`=0.066,`a2`=18.251,`update_time`=1640091905 WHERE `imei` = '868922055681221' [ RunTime:0.000714s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017129s ] [ 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' , '211221' , '210401' , -1.533 , 1.257 , -1.541 , 0.029 , 6 , 6.1 , 86.6 , '460044618415257' , -0 , 0.066 , 18.251 , 1640091905 , 1640091905) [ RunTime:0.000697s ] --------------------------------------------------------------- [ 2021-12-21T21:18:27+08:00 ] 123.234.86.34 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003157s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029921s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000759s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017069s ] [ 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.001409s ] --------------------------------------------------------------- [ 2021-12-21T22:11:47+08:00 ] 112.224.65.1 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003091s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027422s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000759s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016377s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001379s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001510s ] --------------------------------------------------------------- [ 2021-12-21T22:27:57+08:00 ] 39.144.12.181 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003715s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030310s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000749s ] --------------------------------------------------------------- [ 2021-12-21T22:28:06+08:00 ] 39.144.12.181 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211221&time=222701&v1=-01.293&v2=+00.004&v3=-01.160&v4=-00.775&v5=06.0&t=+05.0&h=73.3&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.158&a2=01.310&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002711s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025140s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000841s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211221',`time`='222701',`v1`=-1.293,`v2`=0.004,`v3`=-1.16,`v4`=-0.775,`v5`=6,`t`=5,`h`=73.3,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.158,`a2`=1.31,`update_time`=1640096886 WHERE `imei` = '868922055684076' [ RunTime:0.000768s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016986s ] [ 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' , '211221' , '222701' , -1.293 , 0.004 , -1.16 , -0.775 , 6 , 5 , 73.3 , '460044618415249' , -0 , 0.158 , 1.31 , 1640096886 , 1640096886) [ RunTime:0.000872s ] --------------------------------------------------------------- [ 2021-12-21T23:04:56+08:00 ] 112.9.190.216 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003314s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028927s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000860s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.024460s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001117s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001467s ]