--------------------------------------------------------------- [ 2021-12-31T00:27:57+08:00 ] 39.144.17.117 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003071s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031093s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000735s ] --------------------------------------------------------------- [ 2021-12-31T00:28:05+08:00 ] 39.144.17.117 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211231&time=002701&v1=-01.297&v2=+00.016&v3=-01.151&v4=-00.763&v5=05.1&t=-04.3&h=74.3&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.174&a2=01.314&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001976s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022996s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000794s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211231',`time`='002701',`v1`=-1.297,`v2`=0.016,`v3`=-1.151,`v4`=-0.763,`v5`=5.1,`t`=-4.3,`h`=74.3,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.174,`a2`=1.314,`update_time`=1640881685 WHERE `imei` = '868922055684076' [ RunTime:0.000830s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021162s ] [ 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' , '211231' , '002701' , -1.297 , 0.016 , -1.151 , -0.763 , 5.1 , -4.3 , 74.3 , '460044618415249' , -0 , 0.174 , 1.314 , 1640881685 , 1640881685) [ RunTime:0.000724s ] --------------------------------------------------------------- [ 2021-12-31T02:27:57+08:00 ] 39.144.11.240 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003598s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.035318s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000971s ] --------------------------------------------------------------- [ 2021-12-31T02:28:06+08:00 ] 39.144.11.240 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211231&time=022701&v1=-01.297&v2=+00.016&v3=-01.148&v4=-00.762&v5=05.1&t=-04.8&h=74.2&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.176&a2=01.314&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002092s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024631s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000722s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211231',`time`='022701',`v1`=-1.297,`v2`=0.016,`v3`=-1.148,`v4`=-0.762,`v5`=5.1,`t`=-4.8,`h`=74.2,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.176,`a2`=1.314,`update_time`=1640888886 WHERE `imei` = '868922055684076' [ RunTime:0.000835s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016540s ] [ 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' , '211231' , '022701' , -1.297 , 0.016 , -1.148 , -0.762 , 5.1 , -4.8 , 74.2 , '460044618415249' , -0 , 0.176 , 1.314 , 1640888886 , 1640888886) [ RunTime:0.000727s ] --------------------------------------------------------------- [ 2021-12-31T03:04:56+08:00 ] 221.178.126.34 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.008363s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.055020s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001476s ] --------------------------------------------------------------- [ 2021-12-31T03:05:04+08:00 ] 221.178.126.34 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211231&time=030401&v1=-01.137&v2=+00.720&v3=-01.151&v4=+00.028&v5=06.0&t=-05.0&h=86.3&rssi=+225&imsi=460044618415257&v6=-00.000&a1=00.021&a2=04.840&a3=00.086&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002127s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024294s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000787s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211231',`time`='030401',`v1`=-1.137,`v2`=0.72,`v3`=-1.151,`v4`=0.028,`v5`=6,`t`=-5,`h`=86.3,`rssi`=225,`imsi`='460044618415257',`v6`=-0,`a1`=0.021,`a2`=4.84,`update_time`=1640891104 WHERE `imei` = '868922055681221' [ RunTime:0.000816s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019834s ] [ 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' , '211231' , '030401' , -1.137 , 0.72 , -1.151 , 0.028 , 6 , -5 , 86.3 , '460044618415257' , -0 , 0.021 , 4.84 , 1640891104 , 1640891104) [ RunTime:0.001079s ] --------------------------------------------------------------- [ 2021-12-31T04:27:58+08:00 ] 39.144.13.175 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003363s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032223s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000805s ] --------------------------------------------------------------- [ 2021-12-31T04:28:06+08:00 ] 39.144.13.175 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211231&time=042701&v1=-01.297&v2=+00.014&v3=-01.148&v4=-00.762&v5=05.1&t=-04.4&h=74.2&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.176&a2=01.314&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002718s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026458s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000802s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211231',`time`='042701',`v1`=-1.297,`v2`=0.014,`v3`=-1.148,`v4`=-0.762,`v5`=5.1,`t`=-4.4,`h`=74.2,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.176,`a2`=1.314,`update_time`=1640896086 WHERE `imei` = '868922055684076' [ RunTime:0.000715s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018002s ] [ 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' , '211231' , '042701' , -1.297 , 0.014 , -1.148 , -0.762 , 5.1 , -4.4 , 74.2 , '460044618415249' , -0 , 0.176 , 1.314 , 1640896086 , 1640896086) [ RunTime:0.000707s ] --------------------------------------------------------------- [ 2021-12-31T06:27:57+08:00 ] 39.144.2.255 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.032198s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000774s ] --------------------------------------------------------------- [ 2021-12-31T06:28:06+08:00 ] 39.144.2.255 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211231&time=062701&v1=-01.295&v2=+00.017&v3=-01.148&v4=-00.762&v5=05.9&t=-04.8&h=74.1&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.173&a2=01.312&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002243s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024884s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000804s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211231',`time`='062701',`v1`=-1.295,`v2`=0.017,`v3`=-1.148,`v4`=-0.762,`v5`=5.9,`t`=-4.8,`h`=74.1,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.173,`a2`=1.312,`update_time`=1640903286 WHERE `imei` = '868922055684076' [ RunTime:0.000785s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019844s ] [ 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' , '211231' , '062701' , -1.295 , 0.017 , -1.148 , -0.762 , 5.9 , -4.8 , 74.1 , '460044618415249' , -0 , 0.173 , 1.312 , 1640903286 , 1640903286) [ RunTime:0.001081s ] --------------------------------------------------------------- [ 2021-12-31T08:27:58+08:00 ] 39.144.16.130 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003362s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031230s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000843s ] --------------------------------------------------------------- [ 2021-12-31T08:28:06+08:00 ] 39.144.16.130 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211231&time=082701&v1=-01.295&v2=+00.018&v3=-01.147&v4=-00.762&v5=05.2&t=-00.3&h=73.3&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.175&a2=01.315&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002930s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028458s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001053s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211231',`time`='082701',`v1`=-1.295,`v2`=0.018,`v3`=-1.147,`v4`=-0.762,`v5`=5.2,`t`=-0.3,`h`=73.3,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.175,`a2`=1.315,`update_time`=1640910486 WHERE `imei` = '868922055684076' [ RunTime:0.001000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.023117s ] [ 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' , '211231' , '082701' , -1.295 , 0.018 , -1.147 , -0.762 , 5.2 , -0.3 , 73.3 , '460044618415249' , -0 , 0.175 , 1.315 , 1640910486 , 1640910486) [ RunTime:0.000895s ] --------------------------------------------------------------- [ 2021-12-31T09:04:56+08:00 ] 39.144.5.230 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003144s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029277s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000815s ] --------------------------------------------------------------- [ 2021-12-31T09:05:04+08:00 ] 39.144.5.230 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211231&time=090401&v1=-01.876&v2=+00.918&v3=-01.389&v4=+00.028&v5=06.0&t=+01.4&h=85.7&rssi=+226&imsi=460044618415257&v6=-00.000&a1=00.039&a2=14.599&a3=00.274&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002004s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023039s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000749s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211231',`time`='090401',`v1`=-1.876,`v2`=0.918,`v3`=-1.389,`v4`=0.028,`v5`=6,`t`=1.4,`h`=85.7,`rssi`=226,`imsi`='460044618415257',`v6`=-0,`a1`=0.039,`a2`=14.599,`update_time`=1640912704 WHERE `imei` = '868922055681221' [ RunTime:0.000803s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018856s ] [ 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' , '211231' , '090401' , -1.876 , 0.918 , -1.389 , 0.028 , 6 , 1.4 , 85.7 , '460044618415257' , -0 , 0.039 , 14.599 , 1640912704 , 1640912704) [ RunTime:0.000693s ] --------------------------------------------------------------- [ 2021-12-31T10:27:57+08:00 ] 39.144.14.153 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003197s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030879s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000819s ] --------------------------------------------------------------- [ 2021-12-31T10:28:05+08:00 ] 39.144.14.153 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211231&time=102701&v1=-01.293&v2=+00.014&v3=-01.146&v4=-00.761&v5=05.4&t=+09.0&h=72.7&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.174&a2=01.311&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002108s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023318s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000756s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211231',`time`='102701',`v1`=-1.293,`v2`=0.014,`v3`=-1.146,`v4`=-0.761,`v5`=5.4,`t`=9,`h`=72.7,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.174,`a2`=1.311,`update_time`=1640917685 WHERE `imei` = '868922055684076' [ RunTime:0.000846s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018331s ] [ 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' , '211231' , '102701' , -1.293 , 0.014 , -1.146 , -0.761 , 5.4 , 9 , 72.7 , '460044618415249' , -0 , 0.174 , 1.311 , 1640917685 , 1640917685) [ RunTime:0.000741s ] --------------------------------------------------------------- [ 2021-12-31T12:27:57+08:00 ] 39.144.16.8 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002996s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.034493s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001289s ] --------------------------------------------------------------- [ 2021-12-31T12:28:06+08:00 ] 39.144.16.8 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211231&time=122701&v1=-01.294&v2=+00.011&v3=-01.148&v4=-00.762&v5=05.4&t=+04.8&h=73.7&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.172&a2=01.310&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002042s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024948s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000763s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211231',`time`='122701',`v1`=-1.294,`v2`=0.011,`v3`=-1.148,`v4`=-0.762,`v5`=5.4,`t`=4.8,`h`=73.7,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.172,`a2`=1.31,`update_time`=1640924886 WHERE `imei` = '868922055684076' [ RunTime:0.000743s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021535s ] [ 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' , '211231' , '122701' , -1.294 , 0.011 , -1.148 , -0.762 , 5.4 , 4.8 , 73.7 , '460044618415249' , -0 , 0.172 , 1.31 , 1640924886 , 1640924886) [ RunTime:0.000753s ] --------------------------------------------------------------- [ 2021-12-31T14:27:58+08:00 ] 39.144.4.38 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.005796s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.045892s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000887s ] --------------------------------------------------------------- [ 2021-12-31T14:28:06+08:00 ] 39.144.4.38 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211231&time=142701&v1=-01.295&v2=+00.015&v3=-01.148&v4=-00.761&v5=05.4&t=+05.1&h=73.6&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.173&a2=01.312&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002084s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026856s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000854s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211231',`time`='142701',`v1`=-1.295,`v2`=0.015,`v3`=-1.148,`v4`=-0.761,`v5`=5.4,`t`=5.1,`h`=73.6,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.173,`a2`=1.312,`update_time`=1640932086 WHERE `imei` = '868922055684076' [ RunTime:0.000787s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021229s ] [ 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' , '211231' , '142701' , -1.295 , 0.015 , -1.148 , -0.761 , 5.4 , 5.1 , 73.6 , '460044618415249' , -0 , 0.173 , 1.312 , 1640932086 , 1640932086) [ RunTime:0.000802s ] --------------------------------------------------------------- [ 2021-12-31T15:04:56+08:00 ] 218.204.252.32 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003173s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033313s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000831s ] --------------------------------------------------------------- [ 2021-12-31T15:05:05+08:00 ] 218.204.252.32 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211231&time=150401&v1=-01.704&v2=+00.815&v3=-01.752&v4=+00.028&v5=05.9&t=+10.9&h=86.3&rssi=+226&imsi=460044618415257&v6=-00.000&a1=00.068&a2=27.898&a3=00.383&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003295s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026626s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000821s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211231',`time`='150401',`v1`=-1.704,`v2`=0.815,`v3`=-1.752,`v4`=0.028,`v5`=5.9,`t`=10.9,`h`=86.3,`rssi`=226,`imsi`='460044618415257',`v6`=-0,`a1`=0.068,`a2`=27.898,`update_time`=1640934305 WHERE `imei` = '868922055681221' [ RunTime:0.000946s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020843s ] [ 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' , '211231' , '150401' , -1.704 , 0.815 , -1.752 , 0.028 , 5.9 , 10.9 , 86.3 , '460044618415257' , -0 , 0.068 , 27.898 , 1640934305 , 1640934305) [ RunTime:0.000817s ] --------------------------------------------------------------- [ 2021-12-31T16:27:57+08:00 ] 117.132.191.94 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.037662s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000828s ] --------------------------------------------------------------- [ 2021-12-31T16:28:06+08:00 ] 117.132.191.94 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211231&time=162701&v1=-01.293&v2=+00.017&v3=-01.150&v4=-00.762&v5=05.6&t=+03.5&h=74.0&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.169&a2=01.309&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002109s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024283s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000716s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211231',`time`='162701',`v1`=-1.293,`v2`=0.017,`v3`=-1.15,`v4`=-0.762,`v5`=5.6,`t`=3.5,`h`=74,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.169,`a2`=1.309,`update_time`=1640939286 WHERE `imei` = '868922055684076' [ RunTime:0.000721s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018617s ] [ 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' , '211231' , '162701' , -1.293 , 0.017 , -1.15 , -0.762 , 5.6 , 3.5 , 74 , '460044618415249' , -0 , 0.169 , 1.309 , 1640939286 , 1640939286) [ RunTime:0.000673s ] --------------------------------------------------------------- [ 2021-12-31T16:48:26+08:00 ] 123.234.86.34 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005350s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.023911s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001265s ] --------------------------------------------------------------- [ 2021-12-31T16:48:27+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002098s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023955s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001065s ] --------------------------------------------------------------- [ 2021-12-31T16:48:29+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001921s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023665s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000552s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000964s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001086s ] --------------------------------------------------------------- [ 2021-12-31T17:03:40+08:00 ] 123.234.86.34 GET /home/show/index.html?keyword=868922055680157 [ sql ] [ DB ] CONNECT:[ UseTime:0.003604s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028629s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055680157%' AND `username` = 'user' LIMIT 1 [ RunTime:0.000620s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055680157%' AND `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000830s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001295s ] --------------------------------------------------------------- [ 2021-12-31T17:04:02+08:00 ] 123.234.86.34 GET /home/show/index.html?keyword= [ 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.024601s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000542s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001059s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000968s ]