--------------------------------------------------------------- [ 2021-12-27T00:27:57+08:00 ] 39.144.18.69 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003668s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028366s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000810s ] --------------------------------------------------------------- [ 2021-12-27T00:28:06+08:00 ] 39.144.18.69 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211227&time=002701&v1=-01.300&v2=+00.013&v3=-01.158&v4=-00.769&v5=05.9&t=-08.0&h=73.7&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.170&a2=01.318&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002562s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026527s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000721s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211227',`time`='002701',`v1`=-1.3,`v2`=0.013,`v3`=-1.158,`v4`=-0.769,`v5`=5.9,`t`=-8,`h`=73.7,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.17,`a2`=1.318,`update_time`=1640536086 WHERE `imei` = '868922055684076' [ RunTime:0.000821s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018229s ] [ 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' , '211227' , '002701' , -1.3 , 0.013 , -1.158 , -0.769 , 5.9 , -8 , 73.7 , '460044618415249' , -0 , 0.17 , 1.318 , 1640536086 , 1640536086) [ RunTime:0.001001s ] --------------------------------------------------------------- [ 2021-12-27T02:27:58+08:00 ] 117.132.191.245 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003209s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031622s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000847s ] --------------------------------------------------------------- [ 2021-12-27T02:28:06+08:00 ] 117.132.191.245 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211227&time=022701&v1=-01.300&v2=+00.012&v3=-01.159&v4=-00.769&v5=05.2&t=-07.6&h=73.6&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.170&a2=01.318&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001992s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027082s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000812s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211227',`time`='022701',`v1`=-1.3,`v2`=0.012,`v3`=-1.159,`v4`=-0.769,`v5`=5.2,`t`=-7.6,`h`=73.6,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.17,`a2`=1.318,`update_time`=1640543286 WHERE `imei` = '868922055684076' [ RunTime:0.000847s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019778s ] [ 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' , '211227' , '022701' , -1.3 , 0.012 , -1.159 , -0.769 , 5.2 , -7.6 , 73.6 , '460044618415249' , -0 , 0.17 , 1.318 , 1640543286 , 1640543286) [ RunTime:0.000691s ] --------------------------------------------------------------- [ 2021-12-27T03:04:55+08:00 ] 117.132.195.182 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003103s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025446s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000788s ] --------------------------------------------------------------- [ 2021-12-27T03:05:03+08:00 ] 117.132.195.182 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211227&time=030401&v1=-01.096&v2=+00.980&v3=-01.109&v4=+00.028&v5=06.0&t=-09.8&h=85.9&rssi=+225&imsi=460044618415257&v6=-00.000&a1=00.030&a2=13.097&a3=00.283&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001975s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022109s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001452s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211227',`time`='030401',`v1`=-1.096,`v2`=0.98,`v3`=-1.109,`v4`=0.028,`v5`=6,`t`=-9.8,`h`=85.9,`rssi`=225,`imsi`='460044618415257',`v6`=-0,`a1`=0.03,`a2`=13.097,`update_time`=1640545503 WHERE `imei` = '868922055681221' [ RunTime:0.000789s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019729s ] [ 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' , '211227' , '030401' , -1.096 , 0.98 , -1.109 , 0.028 , 6 , -9.8 , 85.9 , '460044618415257' , -0 , 0.03 , 13.097 , 1640545503 , 1640545503) [ RunTime:0.000672s ] --------------------------------------------------------------- [ 2021-12-27T04:27:57+08:00 ] 218.204.252.244 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002990s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027915s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000740s ] --------------------------------------------------------------- [ 2021-12-27T04:28:06+08:00 ] 218.204.252.244 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211227&time=042701&v1=-01.300&v2=+00.013&v3=-01.159&v4=-00.769&v5=05.9&t=-07.8&h=73.6&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.170&a2=01.318&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002405s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026477s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000769s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211227',`time`='042701',`v1`=-1.3,`v2`=0.013,`v3`=-1.159,`v4`=-0.769,`v5`=5.9,`t`=-7.8,`h`=73.6,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.17,`a2`=1.318,`update_time`=1640550486 WHERE `imei` = '868922055684076' [ RunTime:0.000819s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021686s ] [ 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' , '211227' , '042701' , -1.3 , 0.013 , -1.159 , -0.769 , 5.9 , -7.8 , 73.6 , '460044618415249' , -0 , 0.17 , 1.318 , 1640550486 , 1640550486) [ RunTime:0.000761s ] --------------------------------------------------------------- [ 2021-12-27T06:27:58+08:00 ] 39.144.2.104 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003053s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029928s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000806s ] --------------------------------------------------------------- [ 2021-12-27T06:28:06+08:00 ] 39.144.2.104 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211227&time=062701&v1=-01.298&v2=+00.014&v3=-01.159&v4=-00.769&v5=05.2&t=-07.8&h=73.6&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.168&a2=01.317&a3=00.000&end=$ [ 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.025688s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000776s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211227',`time`='062701',`v1`=-1.298,`v2`=0.014,`v3`=-1.159,`v4`=-0.769,`v5`=5.2,`t`=-7.8,`h`=73.6,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.168,`a2`=1.317,`update_time`=1640557686 WHERE `imei` = '868922055684076' [ RunTime:0.000802s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016320s ] [ 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' , '211227' , '062701' , -1.298 , 0.014 , -1.159 , -0.769 , 5.2 , -7.8 , 73.6 , '460044618415249' , -0 , 0.168 , 1.317 , 1640557686 , 1640557686) [ RunTime:0.000738s ] --------------------------------------------------------------- [ 2021-12-27T08:27:57+08:00 ] 39.144.18.161 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003373s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030239s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000829s ] --------------------------------------------------------------- [ 2021-12-27T08:28:06+08:00 ] 39.144.18.161 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211227&time=082701&v1=-01.302&v2=+00.016&v3=-01.158&v4=-00.767&v5=05.9&t=-01.8&h=72.8&rssi=+230&imsi=460044618415249&v6=-00.000&a1=00.172&a2=01.319&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002288s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027358s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000730s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211227',`time`='082701',`v1`=-1.302,`v2`=0.016,`v3`=-1.158,`v4`=-0.767,`v5`=5.9,`t`=-1.8,`h`=72.8,`rssi`=230,`imsi`='460044618415249',`v6`=-0,`a1`=0.172,`a2`=1.319,`update_time`=1640564886 WHERE `imei` = '868922055684076' [ RunTime:0.000907s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016805s ] [ 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' , '211227' , '082701' , -1.302 , 0.016 , -1.158 , -0.767 , 5.9 , -1.8 , 72.8 , '460044618415249' , -0 , 0.172 , 1.319 , 1640564886 , 1640564886) [ RunTime:0.000685s ] --------------------------------------------------------------- [ 2021-12-27T09:04:57+08:00 ] 39.144.15.160 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003140s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031715s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000750s ] --------------------------------------------------------------- [ 2021-12-27T09:05:05+08:00 ] 39.144.15.160 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211227&time=090401&v1=-01.219&v2=+01.605&v3=-00.988&v4=+00.028&v5=05.7&t=-01.2&h=85.6&rssi=+226&imsi=460044618415257&v6=-00.000&a1=00.061&a2=09.514&a3=00.215&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001985s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023812s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001626s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211227',`time`='090401',`v1`=-1.219,`v2`=1.605,`v3`=-0.988,`v4`=0.028,`v5`=5.7,`t`=-1.2,`h`=85.6,`rssi`=226,`imsi`='460044618415257',`v6`=-0,`a1`=0.061,`a2`=9.514,`update_time`=1640567105 WHERE `imei` = '868922055681221' [ RunTime:0.001182s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018172s ] [ 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' , '211227' , '090401' , -1.219 , 1.605 , -0.988 , 0.028 , 5.7 , -1.2 , 85.6 , '460044618415257' , -0 , 0.061 , 9.514 , 1640567105 , 1640567105) [ RunTime:0.000681s ] --------------------------------------------------------------- [ 2021-12-27T10:27:58+08:00 ] 39.144.18.73 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003072s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.043802s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000879s ] --------------------------------------------------------------- [ 2021-12-27T10:28:06+08:00 ] 39.144.18.73 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211227&time=102701&v1=-01.298&v2=+00.016&v3=-01.158&v4=-00.768&v5=06.0&t=+05.0&h=72.9&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.167&a2=01.314&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002021s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024281s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000770s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211227',`time`='102701',`v1`=-1.298,`v2`=0.016,`v3`=-1.158,`v4`=-0.768,`v5`=6,`t`=5,`h`=72.9,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.167,`a2`=1.314,`update_time`=1640572086 WHERE `imei` = '868922055684076' [ RunTime:0.000702s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020614s ] [ 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' , '211227' , '102701' , -1.298 , 0.016 , -1.158 , -0.768 , 6 , 5 , 72.9 , '460044618415249' , -0 , 0.167 , 1.314 , 1640572086 , 1640572086) [ RunTime:0.000703s ] --------------------------------------------------------------- [ 2021-12-27T12:27:57+08:00 ] 117.132.194.112 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003236s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031066s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000849s ] --------------------------------------------------------------- [ 2021-12-27T12:28:05+08:00 ] 117.132.194.112 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211227&time=122701&v1=-01.298&v2=+00.011&v3=-01.158&v4=-00.768&v5=06.0&t=+02.1&h=73.4&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.166&a2=01.315&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002315s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023609s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000773s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211227',`time`='122701',`v1`=-1.298,`v2`=0.011,`v3`=-1.158,`v4`=-0.768,`v5`=6,`t`=2.1,`h`=73.4,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.166,`a2`=1.315,`update_time`=1640579285 WHERE `imei` = '868922055684076' [ RunTime:0.000722s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020282s ] [ 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' , '211227' , '122701' , -1.298 , 0.011 , -1.158 , -0.768 , 6 , 2.1 , 73.4 , '460044618415249' , -0 , 0.166 , 1.315 , 1640579285 , 1640579285) [ RunTime:0.000825s ] --------------------------------------------------------------- [ 2021-12-27T14:27:57+08:00 ] 39.144.5.136 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.004186s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032132s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000841s ] --------------------------------------------------------------- [ 2021-12-27T14:28:06+08:00 ] 39.144.5.136 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211227&time=142701&v1=-01.298&v2=+00.014&v3=-01.158&v4=-00.768&v5=06.0&t=+03.1&h=73.2&rssi=+230&imsi=460044618415249&v6=-00.000&a1=00.166&a2=01.314&a3=00.000&end=$ [ 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.032861s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001117s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211227',`time`='142701',`v1`=-1.298,`v2`=0.014,`v3`=-1.158,`v4`=-0.768,`v5`=6,`t`=3.1,`h`=73.2,`rssi`=230,`imsi`='460044618415249',`v6`=-0,`a1`=0.166,`a2`=1.314,`update_time`=1640586486 WHERE `imei` = '868922055684076' [ RunTime:0.001109s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.027645s ] [ 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' , '211227' , '142701' , -1.298 , 0.014 , -1.158 , -0.768 , 6 , 3.1 , 73.2 , '460044618415249' , -0 , 0.166 , 1.314 , 1640586486 , 1640586486) [ RunTime:0.001019s ] --------------------------------------------------------------- [ 2021-12-27T15:04:56+08:00 ] 218.204.253.165 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003138s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.034820s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000798s ] --------------------------------------------------------------- [ 2021-12-27T15:05:04+08:00 ] 218.204.253.165 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211227&time=150401&v1=-01.391&v2=+01.512&v3=-01.447&v4=+00.028&v5=06.2&t=+10.8&h=86.1&rssi=+227&imsi=460044618415257&v6=-00.000&a1=00.084&a2=06.076&a3=00.095&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.030493s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000747s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211227',`time`='150401',`v1`=-1.391,`v2`=1.512,`v3`=-1.447,`v4`=0.028,`v5`=6.2,`t`=10.8,`h`=86.1,`rssi`=227,`imsi`='460044618415257',`v6`=-0,`a1`=0.084,`a2`=6.076,`update_time`=1640588704 WHERE `imei` = '868922055681221' [ RunTime:0.000826s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019405s ] [ 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' , '211227' , '150401' , -1.391 , 1.512 , -1.447 , 0.028 , 6.2 , 10.8 , 86.1 , '460044618415257' , -0 , 0.084 , 6.076 , 1640588704 , 1640588704) [ RunTime:0.000696s ] --------------------------------------------------------------- [ 2021-12-27T16:27:58+08:00 ] 117.132.192.23 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.006251s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.044650s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001607s ] --------------------------------------------------------------- [ 2021-12-27T16:28:06+08:00 ] 117.132.192.23 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211227&time=162701&v1=-01.297&v2=+00.018&v3=-01.158&v4=-00.768&v5=06.0&t=+02.0&h=73.5&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.164&a2=01.312&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002475s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021646s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000816s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211227',`time`='162701',`v1`=-1.297,`v2`=0.018,`v3`=-1.158,`v4`=-0.768,`v5`=6,`t`=2,`h`=73.5,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.164,`a2`=1.312,`update_time`=1640593686 WHERE `imei` = '868922055684076' [ RunTime:0.000892s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018711s ] [ 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' , '211227' , '162701' , -1.297 , 0.018 , -1.158 , -0.768 , 6 , 2 , 73.5 , '460044618415249' , -0 , 0.164 , 1.312 , 1640593686 , 1640593686) [ RunTime:0.001564s ] --------------------------------------------------------------- [ 2021-12-27T17:54:14+08:00 ] 123.234.86.34 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003681s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.042181s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.001309s ] --------------------------------------------------------------- [ 2021-12-27T17:54:18+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001971s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024494s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000413s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001356s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001460s ] --------------------------------------------------------------- [ 2021-12-27T17:54:51+08:00 ] 123.234.86.34 GET /admin/show/read/id/24/imei/868922055681221.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002111s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024645s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000949s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019245s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001833s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681221' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002243s ] --------------------------------------------------------------- [ 2021-12-27T17:55:05+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001943s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023871s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000441s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001344s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.010354s ] --------------------------------------------------------------- [ 2021-12-27T17:55:27+08:00 ] 123.234.86.34 GET /admin/show/read/id/24/imei/868922055681221.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002201s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025668s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000745s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015623s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001453s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681221' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001376s ] --------------------------------------------------------------- [ 2021-12-27T17:55:36+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002095s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021909s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000416s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001298s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001337s ] --------------------------------------------------------------- [ 2021-12-27T17:56:02+08:00 ] 123.234.86.34 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002123s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.035899s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001067s ] --------------------------------------------------------------- [ 2021-12-27T17:56:04+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002654s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021653s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001048s ] --------------------------------------------------------------- [ 2021-12-27T17:56:06+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001978s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.020512s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000532s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000990s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000877s ] --------------------------------------------------------------- [ 2021-12-27T17:56:14+08:00 ] 123.234.86.34 GET /home/show/read/id/24/imei/868922055681221.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002235s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025107s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000704s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014928s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001026s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681221' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.001458s ] --------------------------------------------------------------- [ 2021-12-27T17:57:13+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002605s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027878s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000564s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001133s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000883s ] --------------------------------------------------------------- [ 2021-12-27T18:27:57+08:00 ] 218.204.252.132 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003096s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031193s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000791s ] --------------------------------------------------------------- [ 2021-12-27T18:28:06+08:00 ] 218.204.252.132 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211227&time=182701&v1=-01.298&v2=+00.015&v3=-01.159&v4=-00.768&v5=05.9&t=-01.7&h=74.2&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.166&a2=01.315&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002327s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023520s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000810s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211227',`time`='182701',`v1`=-1.298,`v2`=0.015,`v3`=-1.159,`v4`=-0.768,`v5`=5.9,`t`=-1.7,`h`=74.2,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.166,`a2`=1.315,`update_time`=1640600886 WHERE `imei` = '868922055684076' [ RunTime:0.000787s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017353s ] [ 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' , '211227' , '182701' , -1.298 , 0.015 , -1.159 , -0.768 , 5.9 , -1.7 , 74.2 , '460044618415249' , -0 , 0.166 , 1.315 , 1640600886 , 1640600886) [ RunTime:0.000718s ] --------------------------------------------------------------- [ 2021-12-27T20:27:58+08:00 ] 39.144.15.208 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.006267s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.046251s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001364s ] --------------------------------------------------------------- [ 2021-12-27T20:28:06+08:00 ] 39.144.15.208 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211227&time=202701&v1=-01.297&v2=+00.015&v3=-01.158&v4=-00.768&v5=05.9&t=-02.4&h=73.9&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.168&a2=01.315&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002210s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023369s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000755s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211227',`time`='202701',`v1`=-1.297,`v2`=0.015,`v3`=-1.158,`v4`=-0.768,`v5`=5.9,`t`=-2.4,`h`=73.9,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.168,`a2`=1.315,`update_time`=1640608086 WHERE `imei` = '868922055684076' [ RunTime:0.000853s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017809s ] [ 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' , '211227' , '202701' , -1.297 , 0.015 , -1.158 , -0.768 , 5.9 , -2.4 , 73.9 , '460044618415249' , -0 , 0.168 , 1.315 , 1640608086 , 1640608086) [ RunTime:0.000716s ] --------------------------------------------------------------- [ 2021-12-27T21:04:58+08:00 ] 39.144.12.72 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.029465s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025890s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000831s ] --------------------------------------------------------------- [ 2021-12-27T21:05:05+08:00 ] 39.144.12.72 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211227&time=210401&v1=-00.988&v2=+01.150&v3=-00.904&v4=+00.028&v5=06.0&t=-01.8&h=86.2&rssi=+227&imsi=460044618415257&v6=-00.000&a1=00.022&a2=02.249&a3=00.063&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002138s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022443s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000729s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211227',`time`='210401',`v1`=-0.988,`v2`=1.15,`v3`=-0.904,`v4`=0.028,`v5`=6,`t`=-1.8,`h`=86.2,`rssi`=227,`imsi`='460044618415257',`v6`=-0,`a1`=0.022,`a2`=2.249,`update_time`=1640610305 WHERE `imei` = '868922055681221' [ RunTime:0.000839s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016205s ] [ 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' , '211227' , '210401' , -0.988 , 1.15 , -0.904 , 0.028 , 6 , -1.8 , 86.2 , '460044618415257' , -0 , 0.022 , 2.249 , 1640610305 , 1640610305) [ RunTime:0.000807s ] --------------------------------------------------------------- [ 2021-12-27T22:27:57+08:00 ] 221.178.127.54 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003171s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031568s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000809s ] --------------------------------------------------------------- [ 2021-12-27T22:28:06+08:00 ] 221.178.127.54 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211227&time=222701&v1=-01.298&v2=+00.012&v3=-01.159&v4=-00.768&v5=05.2&t=-02.5&h=73.8&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.168&a2=01.316&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001927s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023327s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000799s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211227',`time`='222701',`v1`=-1.298,`v2`=0.012,`v3`=-1.159,`v4`=-0.768,`v5`=5.2,`t`=-2.5,`h`=73.8,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.168,`a2`=1.316,`update_time`=1640615286 WHERE `imei` = '868922055684076' [ RunTime:0.000743s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.027101s ] [ 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' , '211227' , '222701' , -1.298 , 0.012 , -1.159 , -0.768 , 5.2 , -2.5 , 73.8 , '460044618415249' , -0 , 0.168 , 1.316 , 1640615286 , 1640615286) [ RunTime:0.000734s ]