--------------------------------------------------------------- [ 2021-12-17T00:27:58+08:00 ] 218.204.253.124 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003636s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028795s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001749s ] --------------------------------------------------------------- [ 2021-12-17T00:28:06+08:00 ] 218.204.253.124 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211217&time=002701&v1=-01.296&v2=+00.004&v3=-01.159&v4=-00.775&v5=05.9&t=+00.8&h=73.0&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.162&a2=01.314&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002069s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024044s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000685s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211217',`time`='002701',`v1`=-1.296,`v2`=0.004,`v3`=-1.159,`v4`=-0.775,`v5`=5.9,`t`=0.8,`h`=73,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.162,`a2`=1.314,`update_time`=1639672086 WHERE `imei` = '868922055684076' [ RunTime:0.000746s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018351s ] [ 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' , '211217' , '002701' , -1.296 , 0.004 , -1.159 , -0.775 , 5.9 , 0.8 , 73 , '460044618415249' , -0 , 0.162 , 1.314 , 1639672086 , 1639672086) [ RunTime:0.000653s ] --------------------------------------------------------------- [ 2021-12-17T02:27:57+08:00 ] 39.144.15.5 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ 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.033679s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000747s ] --------------------------------------------------------------- [ 2021-12-17T02:28:06+08:00 ] 39.144.15.5 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211217&time=022701&v1=-01.297&v2=+00.004&v3=-01.159&v4=-00.776&v5=05.9&t=-01.0&h=73.1&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.162&a2=01.314&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002224s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022237s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001503s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211217',`time`='022701',`v1`=-1.297,`v2`=0.004,`v3`=-1.159,`v4`=-0.776,`v5`=5.9,`t`=-1,`h`=73.1,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.162,`a2`=1.314,`update_time`=1639679286 WHERE `imei` = '868922055684076' [ RunTime:0.000789s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017173s ] [ 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' , '211217' , '022701' , -1.297 , 0.004 , -1.159 , -0.776 , 5.9 , -1 , 73.1 , '460044618415249' , -0 , 0.162 , 1.314 , 1639679286 , 1639679286) [ RunTime:0.000754s ] --------------------------------------------------------------- [ 2021-12-17T03:04:55+08:00 ] 39.144.16.217 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ 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.024296s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000743s ] --------------------------------------------------------------- [ 2021-12-17T03:05:04+08:00 ] 39.144.16.217 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211217&time=030401&v1=-01.365&v2=+00.294&v3=-01.383&v4=+00.028&v5=06.0&t=-03.1&h=86.3&rssi=+225&imsi=460044618415257&v6=-00.000&a1=00.018&a2=01.379&a3=00.002&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002344s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025893s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000773s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211217',`time`='030401',`v1`=-1.365,`v2`=0.294,`v3`=-1.383,`v4`=0.028,`v5`=6,`t`=-3.1,`h`=86.3,`rssi`=225,`imsi`='460044618415257',`v6`=-0,`a1`=0.018,`a2`=1.379,`update_time`=1639681504 WHERE `imei` = '868922055681221' [ RunTime:0.000772s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019316s ] [ 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' , '211217' , '030401' , -1.365 , 0.294 , -1.383 , 0.028 , 6 , -3.1 , 86.3 , '460044618415257' , -0 , 0.018 , 1.379 , 1639681504 , 1639681504) [ RunTime:0.000789s ] --------------------------------------------------------------- [ 2021-12-17T04:27:58+08:00 ] 39.144.5.39 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003218s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.038879s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000808s ] --------------------------------------------------------------- [ 2021-12-17T04:28:06+08:00 ] 39.144.5.39 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211217&time=042701&v1=-01.297&v2=+00.005&v3=-01.160&v4=-00.776&v5=05.9&t=-02.0&h=73.1&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.162&a2=01.314&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002880s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027720s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000975s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211217',`time`='042701',`v1`=-1.297,`v2`=0.005,`v3`=-1.16,`v4`=-0.776,`v5`=5.9,`t`=-2,`h`=73.1,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.162,`a2`=1.314,`update_time`=1639686486 WHERE `imei` = '868922055684076' [ RunTime:0.000759s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019018s ] [ 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' , '211217' , '042701' , -1.297 , 0.005 , -1.16 , -0.776 , 5.9 , -2 , 73.1 , '460044618415249' , -0 , 0.162 , 1.314 , 1639686486 , 1639686486) [ RunTime:0.000754s ] --------------------------------------------------------------- [ 2021-12-17T06:27:57+08:00 ] 39.144.14.45 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002986s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023884s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000744s ] --------------------------------------------------------------- [ 2021-12-17T06:28:06+08:00 ] 39.144.14.45 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211217&time=062701&v1=-01.296&v2=+00.003&v3=-01.160&v4=-00.776&v5=05.9&t=-02.3&h=72.8&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.161&a2=01.314&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002058s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023034s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000922s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211217',`time`='062701',`v1`=-1.296,`v2`=0.003,`v3`=-1.16,`v4`=-0.776,`v5`=5.9,`t`=-2.3,`h`=72.8,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.161,`a2`=1.314,`update_time`=1639693686 WHERE `imei` = '868922055684076' [ RunTime:0.000738s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017473s ] [ 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' , '211217' , '062701' , -1.296 , 0.003 , -1.16 , -0.776 , 5.9 , -2.3 , 72.8 , '460044618415249' , -0 , 0.161 , 1.314 , 1639693686 , 1639693686) [ RunTime:0.000665s ] --------------------------------------------------------------- [ 2021-12-17T08:27:58+08:00 ] 221.178.126.164 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003136s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.038617s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000891s ] --------------------------------------------------------------- [ 2021-12-17T08:28:06+08:00 ] 221.178.126.164 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211217&time=082701&v1=-01.297&v2=+00.004&v3=-01.159&v4=-00.776&v5=05.9&t=+00.2&h=72.4&rssi=+230&imsi=460044618415249&v6=-00.000&a1=00.162&a2=01.316&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002118s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024816s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000764s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211217',`time`='082701',`v1`=-1.297,`v2`=0.004,`v3`=-1.159,`v4`=-0.776,`v5`=5.9,`t`=0.2,`h`=72.4,`rssi`=230,`imsi`='460044618415249',`v6`=-0,`a1`=0.162,`a2`=1.316,`update_time`=1639700886 WHERE `imei` = '868922055684076' [ RunTime:0.000768s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018590s ] [ 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' , '211217' , '082701' , -1.297 , 0.004 , -1.159 , -0.776 , 5.9 , 0.2 , 72.4 , '460044618415249' , -0 , 0.162 , 1.316 , 1639700886 , 1639700886) [ RunTime:0.000762s ] --------------------------------------------------------------- [ 2021-12-17T09:04:57+08:00 ] 223.104.255.241 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003238s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028265s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000712s ] --------------------------------------------------------------- [ 2021-12-17T09:05:05+08:00 ] 223.104.255.241 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211217&time=090401&v1=-01.346&v2=+00.403&v3=-01.417&v4=+00.028&v5=06.0&t=+00.3&h=86.1&rssi=+225&imsi=460044618415257&v6=-00.000&a1=00.019&a2=02.473&a3=00.008&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002320s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025791s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000775s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211217',`time`='090401',`v1`=-1.346,`v2`=0.403,`v3`=-1.417,`v4`=0.028,`v5`=6,`t`=0.3,`h`=86.1,`rssi`=225,`imsi`='460044618415257',`v6`=-0,`a1`=0.019,`a2`=2.473,`update_time`=1639703105 WHERE `imei` = '868922055681221' [ RunTime:0.000712s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018832s ] [ 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' , '211217' , '090401' , -1.346 , 0.403 , -1.417 , 0.028 , 6 , 0.3 , 86.1 , '460044618415257' , -0 , 0.019 , 2.473 , 1639703105 , 1639703105) [ RunTime:0.000746s ] --------------------------------------------------------------- [ 2021-12-17T10:27:57+08:00 ] 221.178.124.193 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003608s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028441s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000845s ] --------------------------------------------------------------- [ 2021-12-17T10:28:05+08:00 ] 221.178.124.193 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211217&time=102701&v1=-01.296&v2=+00.005&v3=-01.157&v4=-00.776&v5=05.9&t=+01.4&h=72.4&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.164&a2=01.312&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002087s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025883s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000765s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211217',`time`='102701',`v1`=-1.296,`v2`=0.005,`v3`=-1.157,`v4`=-0.776,`v5`=5.9,`t`=1.4,`h`=72.4,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.164,`a2`=1.312,`update_time`=1639708085 WHERE `imei` = '868922055684076' [ RunTime:0.000737s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014787s ] [ 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' , '211217' , '102701' , -1.296 , 0.005 , -1.157 , -0.776 , 5.9 , 1.4 , 72.4 , '460044618415249' , -0 , 0.164 , 1.312 , 1639708085 , 1639708085) [ RunTime:0.000692s ] --------------------------------------------------------------- [ 2021-12-17T12:27:58+08:00 ] 39.144.11.163 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.010909s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027269s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000785s ] --------------------------------------------------------------- [ 2021-12-17T12:28:06+08:00 ] 39.144.11.163 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211217&time=122701&v1=-01.294&v2=+00.005&v3=-01.157&v4=-00.777&v5=05.9&t=-00.9&h=72.8&rssi=+230&imsi=460044618415249&v6=-00.000&a1=00.163&a2=01.314&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002052s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024102s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000756s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211217',`time`='122701',`v1`=-1.294,`v2`=0.005,`v3`=-1.157,`v4`=-0.777,`v5`=5.9,`t`=-0.9,`h`=72.8,`rssi`=230,`imsi`='460044618415249',`v6`=-0,`a1`=0.163,`a2`=1.314,`update_time`=1639715286 WHERE `imei` = '868922055684076' [ RunTime:0.000787s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015680s ] [ 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' , '211217' , '122701' , -1.294 , 0.005 , -1.157 , -0.777 , 5.9 , -0.9 , 72.8 , '460044618415249' , -0 , 0.163 , 1.314 , 1639715286 , 1639715286) [ RunTime:0.000747s ] --------------------------------------------------------------- [ 2021-12-17T14:27:57+08:00 ] 39.144.18.203 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003630s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029056s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001104s ] --------------------------------------------------------------- [ 2021-12-17T14:28:06+08:00 ] 39.144.18.203 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211217&time=142701&v1=-01.296&v2=+00.005&v3=-01.156&v4=-00.776&v5=05.9&t=-01.5&h=72.8&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.167&a2=01.316&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003241s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.036612s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001040s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211217',`time`='142701',`v1`=-1.296,`v2`=0.005,`v3`=-1.156,`v4`=-0.776,`v5`=5.9,`t`=-1.5,`h`=72.8,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.167,`a2`=1.316,`update_time`=1639722486 WHERE `imei` = '868922055684076' [ RunTime:0.001043s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.053728s ] [ 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' , '211217' , '142701' , -1.296 , 0.005 , -1.156 , -0.776 , 5.9 , -1.5 , 72.8 , '460044618415249' , -0 , 0.167 , 1.316 , 1639722486 , 1639722486) [ RunTime:0.001039s ] --------------------------------------------------------------- [ 2021-12-17T15:04:57+08:00 ] 39.144.18.227 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003263s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031332s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000764s ] --------------------------------------------------------------- [ 2021-12-17T15:05:05+08:00 ] 39.144.18.227 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211217&time=150401&v1=-01.907&v2=+02.308&v3=-01.756&v4=+00.028&v5=06.0&t=+01.5&h=86.4&rssi=+227&imsi=460044618415257&v6=-00.000&a1=00.117&a2=03.107&a3=00.094&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002035s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024282s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000730s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211217',`time`='150401',`v1`=-1.907,`v2`=2.308,`v3`=-1.756,`v4`=0.028,`v5`=6,`t`=1.5,`h`=86.4,`rssi`=227,`imsi`='460044618415257',`v6`=-0,`a1`=0.117,`a2`=3.107,`update_time`=1639724705 WHERE `imei` = '868922055681221' [ RunTime:0.000775s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019552s ] [ 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' , '211217' , '150401' , -1.907 , 2.308 , -1.756 , 0.028 , 6 , 1.5 , 86.4 , '460044618415257' , -0 , 0.117 , 3.107 , 1639724705 , 1639724705) [ RunTime:0.000639s ] --------------------------------------------------------------- [ 2021-12-17T16:27:57+08:00 ] 221.178.125.72 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003583s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033151s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001171s ] --------------------------------------------------------------- [ 2021-12-17T16:28:06+08:00 ] 221.178.125.72 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211217&time=162701&v1=-01.295&v2=+00.005&v3=-01.157&v4=-00.777&v5=05.9&t=-02.5&h=72.8&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.163&a2=01.311&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003451s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026961s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000812s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211217',`time`='162701',`v1`=-1.295,`v2`=0.005,`v3`=-1.157,`v4`=-0.777,`v5`=5.9,`t`=-2.5,`h`=72.8,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.163,`a2`=1.311,`update_time`=1639729686 WHERE `imei` = '868922055684076' [ RunTime:0.001215s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018588s ] [ 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' , '211217' , '162701' , -1.295 , 0.005 , -1.157 , -0.777 , 5.9 , -2.5 , 72.8 , '460044618415249' , -0 , 0.163 , 1.311 , 1639729686 , 1639729686) [ RunTime:0.000832s ] --------------------------------------------------------------- [ 2021-12-17T17:37:34+08:00 ] 123.234.86.34 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003127s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.042304s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000730s ] --------------------------------------------------------------- [ 2021-12-17T17:37:35+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002906s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029946s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001565s ] --------------------------------------------------------------- [ 2021-12-17T17:37:39+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001982s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023873s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000524s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000943s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001004s ] --------------------------------------------------------------- [ 2021-12-17T17:37:42+08:00 ] 123.234.86.34 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001832s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021649s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000519s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000960s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000838s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016897s ] [ 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.000492s ] [ 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.000421s ] --------------------------------------------------------------- [ 2021-12-17T17:37:44+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002172s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023104s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001074s ] --------------------------------------------------------------- [ 2021-12-17T17:37:46+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002601s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023545s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000515s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000939s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000839s ] --------------------------------------------------------------- [ 2021-12-17T17:37:49+08:00 ] 123.234.86.34 GET /home/user/edit.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001789s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.021400s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000585s ] --------------------------------------------------------------- [ 2021-12-17T18:27:58+08:00 ] 117.132.197.97 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003233s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032151s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.002590s ] --------------------------------------------------------------- [ 2021-12-17T18:28:07+08:00 ] 117.132.197.97 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211217&time=182701&v1=-01.298&v2=+00.005&v3=-01.158&v4=-00.776&v5=05.9&t=-04.0&h=73.0&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.165&a2=01.315&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002225s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024091s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000742s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211217',`time`='182701',`v1`=-1.298,`v2`=0.005,`v3`=-1.158,`v4`=-0.776,`v5`=5.9,`t`=-4,`h`=73,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.165,`a2`=1.315,`update_time`=1639736887 WHERE `imei` = '868922055684076' [ RunTime:0.000778s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017627s ] [ 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' , '211217' , '182701' , -1.298 , 0.005 , -1.158 , -0.776 , 5.9 , -4 , 73 , '460044618415249' , -0 , 0.165 , 1.315 , 1639736887 , 1639736887) [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2021-12-17T20:27:57+08:00 ] 221.178.126.87 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003476s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029181s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000888s ] --------------------------------------------------------------- [ 2021-12-17T20:28:06+08:00 ] 221.178.126.87 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211217&time=202701&v1=-01.299&v2=+00.005&v3=-01.159&v4=-00.776&v5=05.9&t=-05.3&h=73.0&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.168&a2=01.317&a3=00.000&end=$ [ 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.024839s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000760s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211217',`time`='202701',`v1`=-1.299,`v2`=0.005,`v3`=-1.159,`v4`=-0.776,`v5`=5.9,`t`=-5.3,`h`=73,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.168,`a2`=1.317,`update_time`=1639744086 WHERE `imei` = '868922055684076' [ RunTime:0.000729s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019171s ] [ 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' , '211217' , '202701' , -1.299 , 0.005 , -1.159 , -0.776 , 5.9 , -5.3 , 73 , '460044618415249' , -0 , 0.168 , 1.317 , 1639744086 , 1639744086) [ RunTime:0.000752s ] --------------------------------------------------------------- [ 2021-12-17T21:04:57+08:00 ] 39.144.5.63 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.005271s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030180s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000725s ] --------------------------------------------------------------- [ 2021-12-17T21:05:05+08:00 ] 39.144.5.63 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211217&time=210401&v1=-00.745&v2=+01.636&v3=-00.882&v4=+00.028&v5=06.0&t=-07.7&h=86.1&rssi=+226&imsi=460044618415257&v6=-00.000&a1=00.068&a2=13.498&a3=00.267&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002195s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026085s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000749s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211217',`time`='210401',`v1`=-0.745,`v2`=1.636,`v3`=-0.882,`v4`=0.028,`v5`=6,`t`=-7.7,`h`=86.1,`rssi`=226,`imsi`='460044618415257',`v6`=-0,`a1`=0.068,`a2`=13.498,`update_time`=1639746305 WHERE `imei` = '868922055681221' [ RunTime:0.000682s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021863s ] [ 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' , '211217' , '210401' , -0.745 , 1.636 , -0.882 , 0.028 , 6 , -7.7 , 86.1 , '460044618415257' , -0 , 0.068 , 13.498 , 1639746305 , 1639746305) [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2021-12-17T22:27:58+08:00 ] 39.144.11.41 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.006274s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.041379s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001801s ] --------------------------------------------------------------- [ 2021-12-17T22:28:06+08:00 ] 39.144.11.41 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211217&time=222701&v1=-01.299&v2=+00.004&v3=-01.160&v4=-00.777&v5=05.9&t=-06.4&h=73.0&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.164&a2=01.316&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002563s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025523s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000729s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211217',`time`='222701',`v1`=-1.299,`v2`=0.004,`v3`=-1.16,`v4`=-0.777,`v5`=5.9,`t`=-6.4,`h`=73,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.164,`a2`=1.316,`update_time`=1639751286 WHERE `imei` = '868922055684076' [ RunTime:0.000778s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018294s ] [ 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' , '211217' , '222701' , -1.299 , 0.004 , -1.16 , -0.777 , 5.9 , -6.4 , 73 , '460044618415249' , -0 , 0.164 , 1.316 , 1639751286 , 1639751286) [ RunTime:0.001289s ]