--------------------------------------------------------------- [ 2021-12-23T00:27:57+08:00 ] 39.144.5.68 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003323s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027880s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000840s ] --------------------------------------------------------------- [ 2021-12-23T00:28:06+08:00 ] 39.144.5.68 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211223&time=002701&v1=-01.294&v2=+00.013&v3=-01.161&v4=-00.775&v5=06.0&t=+02.3&h=74.2&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.311&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002091s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022005s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000676s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211223',`time`='002701',`v1`=-1.294,`v2`=0.013,`v3`=-1.161,`v4`=-0.775,`v5`=6,`t`=2.3,`h`=74.2,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.311,`update_time`=1640190486 WHERE `imei` = '868922055684076' [ RunTime:0.000707s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019816s ] [ 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' , '211223' , '002701' , -1.294 , 0.013 , -1.161 , -0.775 , 6 , 2.3 , 74.2 , '460044618415249' , -0 , 0.159 , 1.311 , 1640190486 , 1640190486) [ RunTime:0.000757s ] --------------------------------------------------------------- [ 2021-12-23T02:27:58+08:00 ] 39.144.15.55 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003991s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.039318s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000875s ] --------------------------------------------------------------- [ 2021-12-23T02:28:06+08:00 ] 39.144.15.55 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211223&time=022701&v1=-01.294&v2=+00.012&v3=-01.161&v4=-00.775&v5=06.0&t=+02.1&h=73.8&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.311&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002845s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.035416s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000735s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211223',`time`='022701',`v1`=-1.294,`v2`=0.012,`v3`=-1.161,`v4`=-0.775,`v5`=6,`t`=2.1,`h`=73.8,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.311,`update_time`=1640197686 WHERE `imei` = '868922055684076' [ RunTime:0.000829s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018323s ] [ 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' , '211223' , '022701' , -1.294 , 0.012 , -1.161 , -0.775 , 6 , 2.1 , 73.8 , '460044618415249' , -0 , 0.159 , 1.311 , 1640197686 , 1640197686) [ RunTime:0.000687s ] --------------------------------------------------------------- [ 2021-12-23T03:04:56+08:00 ] 39.144.5.138 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.004053s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027976s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000810s ] --------------------------------------------------------------- [ 2021-12-23T03:05:04+08:00 ] 39.144.5.138 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211223&time=030401&v1=-01.259&v2=+00.674&v3=-01.267&v4=+00.028&v5=06.0&t=+01.0&h=86.5&rssi=+225&imsi=460044618415257&v6=-00.000&a1=00.024&a2=06.908&a3=00.053&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002008s ] 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 `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000686s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211223',`time`='030401',`v1`=-1.259,`v2`=0.674,`v3`=-1.267,`v4`=0.028,`v5`=6,`t`=1,`h`=86.5,`rssi`=225,`imsi`='460044618415257',`v6`=-0,`a1`=0.024,`a2`=6.908,`update_time`=1640199904 WHERE `imei` = '868922055681221' [ RunTime:0.000784s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019036s ] [ 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' , '211223' , '030401' , -1.259 , 0.674 , -1.267 , 0.028 , 6 , 1 , 86.5 , '460044618415257' , -0 , 0.024 , 6.908 , 1640199904 , 1640199904) [ RunTime:0.000810s ] --------------------------------------------------------------- [ 2021-12-23T04:27:57+08:00 ] 221.178.125.57 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003743s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.038945s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000903s ] --------------------------------------------------------------- [ 2021-12-23T04:28:06+08:00 ] 221.178.125.57 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211223&time=042701&v1=-01.294&v2=+00.013&v3=-01.161&v4=-00.774&v5=05.9&t=+01.9&h=73.7&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.311&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002037s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022294s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000720s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211223',`time`='042701',`v1`=-1.294,`v2`=0.013,`v3`=-1.161,`v4`=-0.774,`v5`=5.9,`t`=1.9,`h`=73.7,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.311,`update_time`=1640204886 WHERE `imei` = '868922055684076' [ RunTime:0.000765s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021968s ] [ 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' , '211223' , '042701' , -1.294 , 0.013 , -1.161 , -0.774 , 5.9 , 1.9 , 73.7 , '460044618415249' , -0 , 0.159 , 1.311 , 1640204886 , 1640204886) [ RunTime:0.000694s ] --------------------------------------------------------------- [ 2021-12-23T06:27:58+08:00 ] 117.132.192.202 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003040s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.037069s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000766s ] --------------------------------------------------------------- [ 2021-12-23T06:28:06+08:00 ] 117.132.192.202 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211223&time=062701&v1=-01.293&v2=+00.013&v3=-01.161&v4=-00.775&v5=05.9&t=+02.0&h=73.6&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.158&a2=01.310&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001999s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022794s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000750s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211223',`time`='062701',`v1`=-1.293,`v2`=0.013,`v3`=-1.161,`v4`=-0.775,`v5`=5.9,`t`=2,`h`=73.6,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.158,`a2`=1.31,`update_time`=1640212086 WHERE `imei` = '868922055684076' [ RunTime:0.000817s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017713s ] [ 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' , '211223' , '062701' , -1.293 , 0.013 , -1.161 , -0.775 , 5.9 , 2 , 73.6 , '460044618415249' , -0 , 0.158 , 1.31 , 1640212086 , 1640212086) [ RunTime:0.000625s ] --------------------------------------------------------------- [ 2021-12-23T08:27:58+08:00 ] 39.144.10.202 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.005442s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.039612s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001744s ] --------------------------------------------------------------- [ 2021-12-23T08:28:05+08:00 ] 39.144.10.202 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211223&time=082701&v1=-01.293&v2=+00.015&v3=-01.160&v4=-00.774&v5=05.9&t=+03.0&h=73.2&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.161&a2=01.313&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002107s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024198s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000758s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211223',`time`='082701',`v1`=-1.293,`v2`=0.015,`v3`=-1.16,`v4`=-0.774,`v5`=5.9,`t`=3,`h`=73.2,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.161,`a2`=1.313,`update_time`=1640219285 WHERE `imei` = '868922055684076' [ RunTime:0.000794s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018249s ] [ 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' , '211223' , '082701' , -1.293 , 0.015 , -1.16 , -0.774 , 5.9 , 3 , 73.2 , '460044618415249' , -0 , 0.161 , 1.313 , 1640219285 , 1640219285) [ RunTime:0.001662s ] --------------------------------------------------------------- [ 2021-12-23T09:04:56+08:00 ] 221.178.124.179 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003378s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.035037s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000778s ] --------------------------------------------------------------- [ 2021-12-23T09:05:05+08:00 ] 221.178.124.179 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211223&time=090401&v1=-01.426&v2=+01.052&v3=-01.419&v4=+00.028&v5=06.0&t=+03.4&h=86.4&rssi=+226&imsi=460044618415257&v6=-00.000&a1=00.047&a2=19.070&a3=00.292&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002465s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026240s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000749s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211223',`time`='090401',`v1`=-1.426,`v2`=1.052,`v3`=-1.419,`v4`=0.028,`v5`=6,`t`=3.4,`h`=86.4,`rssi`=226,`imsi`='460044618415257',`v6`=-0,`a1`=0.047,`a2`=19.07,`update_time`=1640221505 WHERE `imei` = '868922055681221' [ RunTime:0.000834s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018657s ] [ 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' , '211223' , '090401' , -1.426 , 1.052 , -1.419 , 0.028 , 6 , 3.4 , 86.4 , '460044618415257' , -0 , 0.047 , 19.07 , 1640221505 , 1640221505) [ RunTime:0.000843s ] --------------------------------------------------------------- [ 2021-12-23T10:27:56+08:00 ] 39.144.14.153 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003357s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029274s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000803s ] --------------------------------------------------------------- [ 2021-12-23T10:28:05+08:00 ] 39.144.14.153 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211223&time=102701&v1=-01.293&v2=+00.016&v3=-01.160&v4=-00.773&v5=06.0&t=+08.2&h=72.2&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.310&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003234s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028777s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000904s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211223',`time`='102701',`v1`=-1.293,`v2`=0.016,`v3`=-1.16,`v4`=-0.773,`v5`=6,`t`=8.2,`h`=72.2,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.31,`update_time`=1640226485 WHERE `imei` = '868922055684076' [ RunTime:0.001015s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.023133s ] [ 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' , '211223' , '102701' , -1.293 , 0.016 , -1.16 , -0.773 , 6 , 8.2 , 72.2 , '460044618415249' , -0 , 0.159 , 1.31 , 1640226485 , 1640226485) [ RunTime:0.000997s ] --------------------------------------------------------------- [ 2021-12-23T11:58:19+08:00 ] 61.156.120.196 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003083s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032093s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000862s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016464s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001102s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001456s ] --------------------------------------------------------------- [ 2021-12-23T11:58:26+08:00 ] 61.156.120.196 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002785s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023897s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000401s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001326s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001423s ] --------------------------------------------------------------- [ 2021-12-23T11:58:29+08:00 ] 61.156.120.196 GET /admin/show/read/id/24/imei/868922055681221.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002470s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023845s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000714s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.026320s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001098s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681221' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001548s ] --------------------------------------------------------------- [ 2021-12-23T11:58:44+08:00 ] 61.156.120.196 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002477s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023934s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000433s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001324s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.002630s ] --------------------------------------------------------------- [ 2021-12-23T11:58:51+08:00 ] 61.156.120.196 GET /admin/show/edit/id/24.html [ 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.022716s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000766s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.032149s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` [ RunTime:0.000588s ] --------------------------------------------------------------- [ 2021-12-23T11:59:36+08:00 ] 61.156.120.196 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003041s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027621s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `interval`=360,`gps`='120.072436,36.059645',`username`='user',`introduce`='

新澳现场实验

',`update_time`=1640231976 WHERE `id` = 24 [ RunTime:0.000941s ] --------------------------------------------------------------- [ 2021-12-23T11:59:38+08:00 ] 61.156.120.196 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002250s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024394s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000438s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001370s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001407s ] --------------------------------------------------------------- [ 2021-12-23T11:59:40+08:00 ] 61.156.120.196 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002307s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024790s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000538s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001307s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001494s ] --------------------------------------------------------------- [ 2021-12-23T11:59:49+08:00 ] 61.156.120.196 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002681s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023916s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000376s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001314s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001373s ] --------------------------------------------------------------- [ 2021-12-23T11:59:55+08:00 ] 61.156.120.196 GET /admin/show/read/id/24/imei/868922055681221.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.023724s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000789s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015501s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001024s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681221' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001439s ] --------------------------------------------------------------- [ 2021-12-23T12:27:58+08:00 ] 39.144.11.187 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003507s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028466s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000799s ] --------------------------------------------------------------- [ 2021-12-23T12:28:06+08:00 ] 39.144.11.187 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211223&time=122701&v1=-01.291&v2=+00.013&v3=-01.159&v4=-00.773&v5=06.0&t=+09.9&h=72.4&rssi=+230&imsi=460044618415249&v6=-00.000&a1=00.157&a2=01.308&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002117s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024405s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000771s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211223',`time`='122701',`v1`=-1.291,`v2`=0.013,`v3`=-1.159,`v4`=-0.773,`v5`=6,`t`=9.9,`h`=72.4,`rssi`=230,`imsi`='460044618415249',`v6`=-0,`a1`=0.157,`a2`=1.308,`update_time`=1640233686 WHERE `imei` = '868922055684076' [ RunTime:0.000820s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018119s ] [ 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' , '211223' , '122701' , -1.291 , 0.013 , -1.159 , -0.773 , 6 , 9.9 , 72.4 , '460044618415249' , -0 , 0.157 , 1.308 , 1640233686 , 1640233686) [ RunTime:0.000925s ] --------------------------------------------------------------- [ 2021-12-23T12:52:48+08:00 ] 123.234.86.34 GET /admin/show/read/id/24/imei/868922055681221.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003094s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028398s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000852s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017071s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001102s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681221' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001414s ] --------------------------------------------------------------- [ 2021-12-23T12:56:40+08:00 ] 123.234.86.34 GET /admin/show/read/id/24/imei/868922055681221.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002299s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026425s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000770s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016445s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001110s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681221' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001543s ] --------------------------------------------------------------- [ 2021-12-23T12:59:59+08:00 ] 123.234.86.34 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002384s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.039002s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000680s ] --------------------------------------------------------------- [ 2021-12-23T13:00:01+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002333s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023766s ] [ 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.001218s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001190s ] --------------------------------------------------------------- [ 2021-12-23T13:00:20+08:00 ] 123.234.86.34 GET /admin/show/read/id/28/imei/868922055680157.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002164s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026816s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 28 LIMIT 1 [ RunTime:0.000844s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018196s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055680157' LIMIT 1 [ RunTime:0.001207s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055680157' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001456s ] --------------------------------------------------------------- [ 2021-12-23T13:00:23+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002215s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022073s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000399s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001380s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001297s ] --------------------------------------------------------------- [ 2021-12-23T13:00:24+08:00 ] 123.234.86.34 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002188s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021937s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000844s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015713s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001521s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002322s ] --------------------------------------------------------------- [ 2021-12-23T13:01:07+08:00 ] 123.234.86.34 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003694s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.023465s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'xinghuo220kv' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000728s ] --------------------------------------------------------------- [ 2021-12-23T13:01:08+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002158s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023358s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000886s ] --------------------------------------------------------------- [ 2021-12-23T13:01:12+08:00 ] 123.234.86.34 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002762s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025564s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000580s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000738s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000748s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017499s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.001900s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.000521s ] --------------------------------------------------------------- [ 2021-12-23T13:01:23+08:00 ] 123.234.86.34 GET /home/data/index.html?keyword=868922055684076&start_date=2021-12-01&end_date=2021-12-23 [ sql ] [ DB ] CONNECT:[ UseTime:0.001929s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023892s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' AND `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000835s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000497s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000604s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000876s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014849s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1638288000 AND `update_time` <= 1640188800 ) LIMIT 1 [ RunTime:0.001432s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1638288000 AND `update_time` <= 1640188800 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.008917s ] --------------------------------------------------------------- [ 2021-12-23T13:01:52+08:00 ] 123.234.86.34 GET /home/data/index.html?keyword=868922055684076&start_date=2021-12-05&end_date=2021-12-23 [ sql ] [ DB ] CONNECT:[ UseTime:0.003311s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022537s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' AND `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000826s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000575s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000550s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000956s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013935s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1638633600 AND `update_time` <= 1640188800 ) LIMIT 1 [ RunTime:0.001106s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1638633600 AND `update_time` <= 1640188800 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.008768s ] --------------------------------------------------------------- [ 2021-12-23T13:02:11+08:00 ] 123.234.86.34 GET /home/data/index.html?keyword=868922055684076&start_date=2021-12-06&end_date=2021-12-23 [ sql ] [ DB ] CONNECT:[ UseTime:0.002174s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022514s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' AND `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000808s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000816s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000604s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000580s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015409s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1638720000 AND `update_time` <= 1640188800 ) LIMIT 1 [ RunTime:0.001153s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1638720000 AND `update_time` <= 1640188800 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.007060s ] --------------------------------------------------------------- [ 2021-12-23T13:03:27+08:00 ] 123.234.86.34 GET /home/data/index.html?keyword=868922055684076&start_date=2021-12-04&end_date=2021-12-06 [ sql ] [ DB ] CONNECT:[ UseTime:0.002733s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028325s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' AND `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000806s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000548s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000590s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000675s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016981s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1638547200 AND `update_time` <= 1638720000 ) LIMIT 1 [ RunTime:0.001160s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1638547200 AND `update_time` <= 1638720000 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.004241s ] --------------------------------------------------------------- [ 2021-12-23T13:04:11+08:00 ] 123.234.86.34 GET /home/data/index.html?keyword=868922055684076&start_date=2021-12-06&end_date=2021-12-23 [ sql ] [ DB ] CONNECT:[ UseTime:0.002971s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025221s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' AND `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000702s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000926s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000546s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000598s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015173s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1638720000 AND `update_time` <= 1640188800 ) LIMIT 1 [ RunTime:0.001338s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1638720000 AND `update_time` <= 1640188800 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.007594s ] --------------------------------------------------------------- [ 2021-12-23T14:27:57+08:00 ] 39.144.2.185 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.004198s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030123s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000844s ] --------------------------------------------------------------- [ 2021-12-23T14:28:05+08:00 ] 39.144.2.185 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211223&time=142701&v1=-01.291&v2=+00.016&v3=-01.159&v4=-00.773&v5=06.0&t=+10.2&h=72.6&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.157&a2=01.308&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002679s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025154s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000850s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211223',`time`='142701',`v1`=-1.291,`v2`=0.016,`v3`=-1.159,`v4`=-0.773,`v5`=6,`t`=10.2,`h`=72.6,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.157,`a2`=1.308,`update_time`=1640240885 WHERE `imei` = '868922055684076' [ RunTime:0.000844s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018695s ] [ 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' , '211223' , '142701' , -1.291 , 0.016 , -1.159 , -0.773 , 6 , 10.2 , 72.6 , '460044618415249' , -0 , 0.157 , 1.308 , 1640240885 , 1640240885) [ RunTime:0.001318s ] --------------------------------------------------------------- [ 2021-12-23T15:04:57+08:00 ] 39.144.5.37 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.004431s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.041513s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001207s ] --------------------------------------------------------------- [ 2021-12-23T15:05:05+08:00 ] 39.144.5.37 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211223&time=150401&v1=-01.738&v2=+00.944&v3=-01.640&v4=+00.028&v5=06.2&t=+10.9&h=86.3&rssi=+226&imsi=460044618415257&v6=-00.000&a1=00.061&a2=23.165&a3=00.325&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002143s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022389s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000734s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211223',`time`='150401',`v1`=-1.738,`v2`=0.944,`v3`=-1.64,`v4`=0.028,`v5`=6.2,`t`=10.9,`h`=86.3,`rssi`=226,`imsi`='460044618415257',`v6`=-0,`a1`=0.061,`a2`=23.165,`update_time`=1640243105 WHERE `imei` = '868922055681221' [ RunTime:0.000801s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016613s ] [ 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' , '211223' , '150401' , -1.738 , 0.944 , -1.64 , 0.028 , 6.2 , 10.9 , 86.3 , '460044618415257' , -0 , 0.061 , 23.165 , 1640243105 , 1640243105) [ RunTime:0.000732s ] --------------------------------------------------------------- [ 2021-12-23T16:27:57+08:00 ] 221.178.124.173 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002972s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033936s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000750s ] --------------------------------------------------------------- [ 2021-12-23T16:28:06+08:00 ] 221.178.124.173 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211223&time=162701&v1=-01.291&v2=+00.015&v3=-01.159&v4=-00.774&v5=06.0&t=+08.7&h=73.2&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.155&a2=01.307&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002671s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.020864s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000740s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211223',`time`='162701',`v1`=-1.291,`v2`=0.015,`v3`=-1.159,`v4`=-0.774,`v5`=6,`t`=8.7,`h`=73.2,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.155,`a2`=1.307,`update_time`=1640248086 WHERE `imei` = '868922055684076' [ RunTime:0.000711s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017056s ] [ 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' , '211223' , '162701' , -1.291 , 0.015 , -1.159 , -0.774 , 6 , 8.7 , 73.2 , '460044618415249' , -0 , 0.155 , 1.307 , 1640248086 , 1640248086) [ RunTime:0.000678s ] --------------------------------------------------------------- [ 2021-12-23T18:27:58+08:00 ] 221.178.127.54 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003148s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029224s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000749s ] --------------------------------------------------------------- [ 2021-12-23T18:28:06+08:00 ] 221.178.127.54 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211223&time=182701&v1=-01.293&v2=+00.011&v3=-01.160&v4=-00.773&v5=06.0&t=+07.3&h=73.4&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.158&a2=01.309&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.024056s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000834s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211223',`time`='182701',`v1`=-1.293,`v2`=0.011,`v3`=-1.16,`v4`=-0.773,`v5`=6,`t`=7.3,`h`=73.4,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.158,`a2`=1.309,`update_time`=1640255286 WHERE `imei` = '868922055684076' [ RunTime:0.000797s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017277s ] [ 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' , '211223' , '182701' , -1.293 , 0.011 , -1.16 , -0.773 , 6 , 7.3 , 73.4 , '460044618415249' , -0 , 0.158 , 1.309 , 1640255286 , 1640255286) [ RunTime:0.000729s ] --------------------------------------------------------------- [ 2021-12-23T20:27:57+08:00 ] 39.144.5.70 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003326s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025915s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000811s ] --------------------------------------------------------------- [ 2021-12-23T20:28:06+08:00 ] 39.144.5.70 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211223&time=202701&v1=-01.293&v2=+00.011&v3=-01.159&v4=-00.773&v5=06.0&t=+06.2&h=73.4&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.311&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002105s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023448s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000749s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211223',`time`='202701',`v1`=-1.293,`v2`=0.011,`v3`=-1.159,`v4`=-0.773,`v5`=6,`t`=6.2,`h`=73.4,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.311,`update_time`=1640262486 WHERE `imei` = '868922055684076' [ RunTime:0.001216s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.022709s ] [ 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' , '211223' , '202701' , -1.293 , 0.011 , -1.159 , -0.773 , 6 , 6.2 , 73.4 , '460044618415249' , -0 , 0.159 , 1.311 , 1640262486 , 1640262486) [ RunTime:0.000736s ] --------------------------------------------------------------- [ 2021-12-23T21:04:58+08:00 ] 117.132.196.36 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.026157s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024680s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000838s ] --------------------------------------------------------------- [ 2021-12-23T21:05:05+08:00 ] 117.132.196.36 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211223&time=210401&v1=-00.647&v2=+01.035&v3=-00.721&v4=+00.029&v5=06.2&t=+05.9&h=86.5&rssi=+225&imsi=460044618415257&v6=-00.000&a1=00.035&a2=03.387&a3=00.358&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002716s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027161s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000738s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211223',`time`='210401',`v1`=-0.647,`v2`=1.035,`v3`=-0.721,`v4`=0.029,`v5`=6.2,`t`=5.9,`h`=86.5,`rssi`=225,`imsi`='460044618415257',`v6`=-0,`a1`=0.035,`a2`=3.387,`update_time`=1640264705 WHERE `imei` = '868922055681221' [ RunTime:0.001110s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020059s ] [ 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' , '211223' , '210401' , -0.647 , 1.035 , -0.721 , 0.029 , 6.2 , 5.9 , 86.5 , '460044618415257' , -0 , 0.035 , 3.387 , 1640264705 , 1640264705) [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2021-12-23T22:27:58+08:00 ] 39.144.8.45 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.004274s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.036960s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000887s ] --------------------------------------------------------------- [ 2021-12-23T22:28:06+08:00 ] 39.144.8.45 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211223&time=222701&v1=-01.292&v2=+00.010&v3=-01.160&v4=-00.774&v5=06.0&t=+05.7&h=73.4&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.158&a2=01.309&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002357s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027037s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000815s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211223',`time`='222701',`v1`=-1.292,`v2`=0.01,`v3`=-1.16,`v4`=-0.774,`v5`=6,`t`=5.7,`h`=73.4,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.158,`a2`=1.309,`update_time`=1640269686 WHERE `imei` = '868922055684076' [ RunTime:0.000846s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017321s ] [ 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' , '211223' , '222701' , -1.292 , 0.01 , -1.16 , -0.774 , 6 , 5.7 , 73.4 , '460044618415249' , -0 , 0.158 , 1.309 , 1640269686 , 1640269686) [ RunTime:0.000759s ]