--------------------------------------------------------------- [ 2022-10-28T00:03:58+08:00 ] 221.178.125.191 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002038s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010365s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000709s ] --------------------------------------------------------------- [ 2022-10-28T00:03:58+08:00 ] 39.144.16.101 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001671s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010674s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000622s ] --------------------------------------------------------------- [ 2022-10-28T00:04:06+08:00 ] 221.178.125.191 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=000301&v1=-00.990&v2=+00.041&v3=-00.986&v4=-00.043&v5=06.2&t=+10.1&h=55.4&rssi=+228&ccid=4600485905031420000099m9990000000012000001g0140,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001638s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010456s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='000301',`v1`=-0.99,`v2`=0.041,`v3`=-0.986,`v4`=-0.043,`v5`=6.2,`t`=10.1,`h`=55.4,`rssi`=228,`ccid`='4600485905031420000099m9990000000012000001g0140,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666886646 WHERE `imei` = '868922055643643' [ RunTime:0.000541s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010673s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '000301' , -0.99 , 0.041 , -0.986 , -0.043 , 6.2 , 10.1 , 55.4 , 228 , '4600485905031420000099m9990000000012000001g0140,N,00E000=-00.000' , 0 , 0 , 1666886646 , 1666886646) [ RunTime:0.000580s ] --------------------------------------------------------------- [ 2022-10-28T00:04:07+08:00 ] 39.144.16.101 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=000301&v1=-00.626&v2=+00.001&v3=-00.401&v4=+00.026&v5=05.9&t=+10.8&h=59.1&rssi=+225&ccid=4600485905031430000099m9990000000076000000g7140,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001656s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009899s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000610s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='000301',`v1`=-0.626,`v2`=0.001,`v3`=-0.401,`v4`=0.026,`v5`=5.9,`t`=10.8,`h`=59.1,`rssi`=225,`ccid`='4600485905031430000099m9990000000076000000g7140,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666886647 WHERE `imei` = '868922055644013' [ RunTime:0.000477s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009993s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '000301' , -0.626 , 0.001 , -0.401 , 0.026 , 5.9 , 10.8 , 59.1 , 225 , '4600485905031430000099m9990000000076000000g7140,N,00E000=-00.000' , 0 , 0 , 1666886647 , 1666886647) [ RunTime:0.000484s ] --------------------------------------------------------------- [ 2022-10-28T01:03:58+08:00 ] 39.144.12.134 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003054s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014168s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000983s ] --------------------------------------------------------------- [ 2022-10-28T01:03:58+08:00 ] 218.204.253.2 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002186s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012495s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000957s ] --------------------------------------------------------------- [ 2022-10-28T01:04:06+08:00 ] 39.144.12.134 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=010301&v1=-00.991&v2=+00.040&v3=-00.986&v4=-00.042&v5=06.2&t=+09.1&h=55.6&rssi=+229&ccid=4600485905031420000099m9990000000010000001g0150,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001371s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009765s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000638s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='010301',`v1`=-0.991,`v2`=0.04,`v3`=-0.986,`v4`=-0.042,`v5`=6.2,`t`=9.1,`h`=55.6,`rssi`=229,`ccid`='4600485905031420000099m9990000000010000001g0150,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666890246 WHERE `imei` = '868922055643643' [ RunTime:0.000531s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011375s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '010301' , -0.991 , 0.04 , -0.986 , -0.042 , 6.2 , 9.1 , 55.6 , 229 , '4600485905031420000099m9990000000010000001g0150,N,00E000=-00.000' , 0 , 0 , 1666890246 , 1666890246) [ RunTime:0.000898s ] --------------------------------------------------------------- [ 2022-10-28T01:04:06+08:00 ] 218.204.253.2 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=010301&v1=-00.612&v2=+00.001&v3=-00.477&v4=+00.030&v5=05.9&t=+10.0&h=59.1&rssi=+225&ccid=4600485905031430000099m9990000000073000000g6970,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001510s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009454s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000695s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='010301',`v1`=-0.612,`v2`=0.001,`v3`=-0.477,`v4`=0.03,`v5`=5.9,`t`=10,`h`=59.1,`rssi`=225,`ccid`='4600485905031430000099m9990000000073000000g6970,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666890246 WHERE `imei` = '868922055644013' [ RunTime:0.000488s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009678s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '010301' , -0.612 , 0.001 , -0.477 , 0.03 , 5.9 , 10 , 59.1 , 225 , '4600485905031430000099m9990000000073000000g6970,N,00E000=-00.000' , 0 , 0 , 1666890246 , 1666890246) [ RunTime:0.000624s ] --------------------------------------------------------------- [ 2022-10-28T02:03:57+08:00 ] 39.144.6.168 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002136s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011169s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2022-10-28T02:03:57+08:00 ] 221.178.127.67 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001583s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008996s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000647s ] --------------------------------------------------------------- [ 2022-10-28T02:04:06+08:00 ] 39.144.6.168 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=020301&v1=-00.992&v2=+00.040&v3=-00.986&v4=-00.042&v5=06.0&t=+08.3&h=55.6&rssi=+229&ccid=4600485905031420000099m9990000000008000001g0160,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001405s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011035s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000620s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='020301',`v1`=-0.992,`v2`=0.04,`v3`=-0.986,`v4`=-0.042,`v5`=6,`t`=8.3,`h`=55.6,`rssi`=229,`ccid`='4600485905031420000099m9990000000008000001g0160,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666893846 WHERE `imei` = '868922055643643' [ RunTime:0.000534s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011445s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '020301' , -0.992 , 0.04 , -0.986 , -0.042 , 6 , 8.3 , 55.6 , 229 , '4600485905031420000099m9990000000008000001g0160,N,00E000=-00.000' , 0 , 0 , 1666893846 , 1666893846) [ RunTime:0.000582s ] --------------------------------------------------------------- [ 2022-10-28T02:04:06+08:00 ] 221.178.127.67 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=020301&v1=-00.603&v2=+00.001&v3=-00.491&v4=+00.030&v5=05.9&t=+09.1&h=59.2&rssi=+225&ccid=4600485905031430000099m9990000000065000000g6840,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001717s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009479s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='020301',`v1`=-0.603,`v2`=0.001,`v3`=-0.491,`v4`=0.03,`v5`=5.9,`t`=9.1,`h`=59.2,`rssi`=225,`ccid`='4600485905031430000099m9990000000065000000g6840,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666893846 WHERE `imei` = '868922055644013' [ RunTime:0.000494s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009966s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '020301' , -0.603 , 0.001 , -0.491 , 0.03 , 5.9 , 9.1 , 59.2 , 225 , '4600485905031430000099m9990000000065000000g6840,N,00E000=-00.000' , 0 , 0 , 1666893846 , 1666893846) [ RunTime:0.000536s ] --------------------------------------------------------------- [ 2022-10-28T03:03:58+08:00 ] 117.132.193.169 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002318s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009956s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000731s ] --------------------------------------------------------------- [ 2022-10-28T03:03:58+08:00 ] 221.178.127.136 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001619s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009573s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000621s ] --------------------------------------------------------------- [ 2022-10-28T03:04:07+08:00 ] 117.132.193.169 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=030301&v1=-00.994&v2=+00.039&v3=-00.986&v4=-00.042&v5=06.0&t=+08.3&h=55.3&rssi=+229&ccid=4600485905031420000099m9990000000007000001g0170,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001434s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010376s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000642s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='030301',`v1`=-0.994,`v2`=0.039,`v3`=-0.986,`v4`=-0.042,`v5`=6,`t`=8.3,`h`=55.3,`rssi`=229,`ccid`='4600485905031420000099m9990000000007000001g0170,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666897447 WHERE `imei` = '868922055643643' [ RunTime:0.000625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010655s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '030301' , -0.994 , 0.039 , -0.986 , -0.042 , 6 , 8.3 , 55.3 , 229 , '4600485905031420000099m9990000000007000001g0170,N,00E000=-00.000' , 0 , 0 , 1666897447 , 1666897447) [ RunTime:0.000625s ] --------------------------------------------------------------- [ 2022-10-28T03:04:07+08:00 ] 221.178.127.136 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=030301&v1=-00.603&v2=+00.001&v3=-00.466&v4=+00.028&v5=05.9&t=+09.0&h=59.0&rssi=+223&ccid=4600485905031430000099m9990000000061000000g6840,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001410s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010668s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000793s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='030301',`v1`=-0.603,`v2`=0.001,`v3`=-0.466,`v4`=0.028,`v5`=5.9,`t`=9,`h`=59,`rssi`=223,`ccid`='4600485905031430000099m9990000000061000000g6840,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666897447 WHERE `imei` = '868922055644013' [ RunTime:0.000484s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010263s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '030301' , -0.603 , 0.001 , -0.466 , 0.028 , 5.9 , 9 , 59 , 223 , '4600485905031430000099m9990000000061000000g6840,N,00E000=-00.000' , 0 , 0 , 1666897447 , 1666897447) [ RunTime:0.000511s ] --------------------------------------------------------------- [ 2022-10-28T04:03:58+08:00 ] 39.144.10.111 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002163s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011252s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000691s ] --------------------------------------------------------------- [ 2022-10-28T04:03:59+08:00 ] 39.144.1.142 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001686s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011283s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000698s ] --------------------------------------------------------------- [ 2022-10-28T04:04:06+08:00 ] 39.144.10.111 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=040301&v1=-00.994&v2=+00.039&v3=-00.985&v4=-00.041&v5=06.0&t=+07.6&h=55.5&rssi=+229&ccid=4600485905031420000099m9990000000005000001g0180,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001350s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008476s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000589s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='040301',`v1`=-0.994,`v2`=0.039,`v3`=-0.985,`v4`=-0.041,`v5`=6,`t`=7.6,`h`=55.5,`rssi`=229,`ccid`='4600485905031420000099m9990000000005000001g0180,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666901046 WHERE `imei` = '868922055643643' [ RunTime:0.000529s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011956s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '040301' , -0.994 , 0.039 , -0.985 , -0.041 , 6 , 7.6 , 55.5 , 229 , '4600485905031420000099m9990000000005000001g0180,N,00E000=-00.000' , 0 , 0 , 1666901046 , 1666901046) [ RunTime:0.000641s ] --------------------------------------------------------------- [ 2022-10-28T04:04:06+08:00 ] 39.144.1.142 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=040301&v1=-00.602&v2=+00.001&v3=-00.502&v4=+00.031&v5=05.9&t=+08.4&h=59.2&rssi=+227&ccid=4600485905031430000099m9990000000072000000g6880,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001472s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009464s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000721s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='040301',`v1`=-0.602,`v2`=0.001,`v3`=-0.502,`v4`=0.031,`v5`=5.9,`t`=8.4,`h`=59.2,`rssi`=227,`ccid`='4600485905031430000099m9990000000072000000g6880,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666901046 WHERE `imei` = '868922055644013' [ RunTime:0.000582s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010527s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '040301' , -0.602 , 0.001 , -0.502 , 0.031 , 5.9 , 8.4 , 59.2 , 227 , '4600485905031430000099m9990000000072000000g6880,N,00E000=-00.000' , 0 , 0 , 1666901046 , 1666901046) [ RunTime:0.000847s ] --------------------------------------------------------------- [ 2022-10-28T05:03:57+08:00 ] 117.132.195.211 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002085s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009331s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000721s ] --------------------------------------------------------------- [ 2022-10-28T05:03:58+08:00 ] 117.132.193.107 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001555s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010497s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000722s ] --------------------------------------------------------------- [ 2022-10-28T05:04:05+08:00 ] 117.132.195.211 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=050301&v1=-00.586&v2=+00.001&v3=-00.502&v4=+00.032&v5=05.9&t=+07.5&h=59.3&rssi=+227&ccid=4600485905031430000099m9990000000074000000g6690,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001512s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008985s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000670s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='050301',`v1`=-0.586,`v2`=0.001,`v3`=-0.502,`v4`=0.032,`v5`=5.9,`t`=7.5,`h`=59.3,`rssi`=227,`ccid`='4600485905031430000099m9990000000074000000g6690,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666904645 WHERE `imei` = '868922055644013' [ RunTime:0.000563s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010198s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '050301' , -0.586 , 0.001 , -0.502 , 0.032 , 5.9 , 7.5 , 59.3 , 227 , '4600485905031430000099m9990000000074000000g6690,N,00E000=-00.000' , 0 , 0 , 1666904645 , 1666904645) [ RunTime:0.000735s ] --------------------------------------------------------------- [ 2022-10-28T05:04:06+08:00 ] 117.132.193.107 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=050301&v1=-00.996&v2=+00.038&v3=-00.985&v4=-00.041&v5=06.0&t=+06.7&h=55.6&rssi=+228&ccid=4600485905031420000099m9990000000004000001g0190,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001439s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010998s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000611s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='050301',`v1`=-0.996,`v2`=0.038,`v3`=-0.985,`v4`=-0.041,`v5`=6,`t`=6.7,`h`=55.6,`rssi`=228,`ccid`='4600485905031420000099m9990000000004000001g0190,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666904646 WHERE `imei` = '868922055643643' [ RunTime:0.000500s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010181s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '050301' , -0.996 , 0.038 , -0.985 , -0.041 , 6 , 6.7 , 55.6 , 228 , '4600485905031420000099m9990000000004000001g0190,N,00E000=-00.000' , 0 , 0 , 1666904646 , 1666904646) [ RunTime:0.000492s ] --------------------------------------------------------------- [ 2022-10-28T06:03:57+08:00 ] 39.144.4.3 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002875s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010320s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000620s ] --------------------------------------------------------------- [ 2022-10-28T06:03:58+08:00 ] 117.132.194.62 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001412s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010283s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000692s ] --------------------------------------------------------------- [ 2022-10-28T06:04:06+08:00 ] 39.144.4.3 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=060301&v1=-00.997&v2=+00.041&v3=-00.986&v4=-00.041&v5=06.0&t=+06.1&h=55.6&rssi=+231&ccid=4600485905031420000099m9990000000003000001g0200,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001400s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009770s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000778s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='060301',`v1`=-0.997,`v2`=0.041,`v3`=-0.986,`v4`=-0.041,`v5`=6,`t`=6.1,`h`=55.6,`rssi`=231,`ccid`='4600485905031420000099m9990000000003000001g0200,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666908246 WHERE `imei` = '868922055643643' [ RunTime:0.000601s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010818s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '060301' , -0.997 , 0.041 , -0.986 , -0.041 , 6 , 6.1 , 55.6 , 231 , '4600485905031420000099m9990000000003000001g0200,N,00E000=-00.000' , 0 , 0 , 1666908246 , 1666908246) [ RunTime:0.000641s ] --------------------------------------------------------------- [ 2022-10-28T06:04:06+08:00 ] 117.132.194.62 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=060301&v1=-00.560&v2=+00.001&v3=-00.409&v4=+00.028&v5=05.9&t=+06.9&h=59.3&rssi=+224&ccid=4600485905031430000099m9990000000095000000g6410,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001418s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009295s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000584s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='060301',`v1`=-0.56,`v2`=0.001,`v3`=-0.409,`v4`=0.028,`v5`=5.9,`t`=6.9,`h`=59.3,`rssi`=224,`ccid`='4600485905031430000099m9990000000095000000g6410,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666908246 WHERE `imei` = '868922055644013' [ RunTime:0.000463s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008559s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '060301' , -0.56 , 0.001 , -0.409 , 0.028 , 5.9 , 6.9 , 59.3 , 224 , '4600485905031430000099m9990000000095000000g6410,N,00E000=-00.000' , 0 , 0 , 1666908246 , 1666908246) [ RunTime:0.000452s ] --------------------------------------------------------------- [ 2022-10-28T07:03:57+08:00 ] 39.144.14.130 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002311s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011944s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000655s ] --------------------------------------------------------------- [ 2022-10-28T07:03:58+08:00 ] 39.144.14.167 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001405s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008626s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000808s ] --------------------------------------------------------------- [ 2022-10-28T07:04:06+08:00 ] 39.144.14.130 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=070301&v1=-00.555&v2=+00.001&v3=-00.488&v4=+00.034&v5=05.9&t=+06.9&h=59.0&rssi=+229&ccid=4600485905031430000099m9990000000089000000g6470,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001409s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009312s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000718s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='070301',`v1`=-0.555,`v2`=0.001,`v3`=-0.488,`v4`=0.034,`v5`=5.9,`t`=6.9,`h`=59,`rssi`=229,`ccid`='4600485905031430000099m9990000000089000000g6470,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666911846 WHERE `imei` = '868922055644013' [ RunTime:0.000548s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010998s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '070301' , -0.555 , 0.001 , -0.488 , 0.034 , 5.9 , 6.9 , 59 , 229 , '4600485905031430000099m9990000000089000000g6470,N,00E000=-00.000' , 0 , 0 , 1666911846 , 1666911846) [ RunTime:0.000561s ] --------------------------------------------------------------- [ 2022-10-28T07:04:07+08:00 ] 39.144.14.167 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=070301&v1=-00.998&v2=+00.041&v3=-00.985&v4=-00.041&v5=06.0&t=+06.1&h=55.3&rssi=+229&ccid=4600485905031420000099m9990000000002000001g0210,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001530s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008258s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000620s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='070301',`v1`=-0.998,`v2`=0.041,`v3`=-0.985,`v4`=-0.041,`v5`=6,`t`=6.1,`h`=55.3,`rssi`=229,`ccid`='4600485905031420000099m9990000000002000001g0210,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666911847 WHERE `imei` = '868922055643643' [ RunTime:0.000476s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009106s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '070301' , -0.998 , 0.041 , -0.985 , -0.041 , 6 , 6.1 , 55.3 , 229 , '4600485905031420000099m9990000000002000001g0210,N,00E000=-00.000' , 0 , 0 , 1666911847 , 1666911847) [ RunTime:0.000489s ] --------------------------------------------------------------- [ 2022-10-28T08:03:58+08:00 ] 117.132.198.131 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003044s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010501s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000705s ] --------------------------------------------------------------- [ 2022-10-28T08:03:59+08:00 ] 39.144.14.186 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001430s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010070s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000620s ] --------------------------------------------------------------- [ 2022-10-28T08:04:06+08:00 ] 117.132.198.131 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=080301&v1=-00.999&v2=+00.068&v3=-00.984&v4=-00.041&v5=06.0&t=+07.9&h=54.5&rssi=+231&ccid=4600485905031420000099m9990000000000000001g0220,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001492s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010429s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='080301',`v1`=-0.999,`v2`=0.068,`v3`=-0.984,`v4`=-0.041,`v5`=6,`t`=7.9,`h`=54.5,`rssi`=231,`ccid`='4600485905031420000099m9990000000000000001g0220,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666915446 WHERE `imei` = '868922055643643' [ RunTime:0.000577s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010658s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '080301' , -0.999 , 0.068 , -0.984 , -0.041 , 6 , 7.9 , 54.5 , 231 , '4600485905031420000099m9990000000000000001g0220,N,00E000=-00.000' , 0 , 0 , 1666915446 , 1666915446) [ RunTime:0.000563s ] --------------------------------------------------------------- [ 2022-10-28T08:04:07+08:00 ] 39.144.14.186 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=080301&v1=-00.515&v2=+00.001&v3=-00.383&v4=+00.026&v5=05.9&t=+08.8&h=58.1&rssi=+228&ccid=4600485905031430000099m9990000000098000000g5920,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001504s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008368s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='080301',`v1`=-0.515,`v2`=0.001,`v3`=-0.383,`v4`=0.026,`v5`=5.9,`t`=8.8,`h`=58.1,`rssi`=228,`ccid`='4600485905031430000099m9990000000098000000g5920,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666915447 WHERE `imei` = '868922055644013' [ RunTime:0.000489s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010412s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '080301' , -0.515 , 0.001 , -0.383 , 0.026 , 5.9 , 8.8 , 58.1 , 228 , '4600485905031430000099m9990000000098000000g5920,N,00E000=-00.000' , 0 , 0 , 1666915447 , 1666915447) [ RunTime:0.000481s ] --------------------------------------------------------------- [ 2022-10-28T09:03:57+08:00 ] 39.144.1.192 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002363s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010319s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000676s ] --------------------------------------------------------------- [ 2022-10-28T09:03:58+08:00 ] 39.144.14.237 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001725s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010720s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000682s ] --------------------------------------------------------------- [ 2022-10-28T09:04:05+08:00 ] 39.144.1.192 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=090301&v1=-00.671&v2=+00.001&v3=-00.285&v4=+00.023&v5=05.9&t=+11.2&h=57.5&rssi=+226&ccid=4600485905031430000099m9990000000073000000g7650,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001418s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009636s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000591s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='090301',`v1`=-0.671,`v2`=0.001,`v3`=-0.285,`v4`=0.023,`v5`=5.9,`t`=11.2,`h`=57.5,`rssi`=226,`ccid`='4600485905031430000099m9990000000073000000g7650,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666919045 WHERE `imei` = '868922055644013' [ RunTime:0.000565s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010681s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '090301' , -0.671 , 0.001 , -0.285 , 0.023 , 5.9 , 11.2 , 57.5 , 226 , '4600485905031430000099m9990000000073000000g7650,N,00E000=-00.000' , 0 , 0 , 1666919045 , 1666919045) [ RunTime:0.000565s ] --------------------------------------------------------------- [ 2022-10-28T09:04:06+08:00 ] 39.144.14.237 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=090301&v1=-01.001&v2=+00.069&v3=-00.985&v4=-00.042&v5=06.0&t=+10.6&h=53.8&rssi=+230&ccid=4600485905031420000099m9990000000001000001g0240,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001490s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010116s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000617s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='090301',`v1`=-1.001,`v2`=0.069,`v3`=-0.985,`v4`=-0.042,`v5`=6,`t`=10.6,`h`=53.8,`rssi`=230,`ccid`='4600485905031420000099m9990000000001000001g0240,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666919046 WHERE `imei` = '868922055643643' [ RunTime:0.000487s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009463s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '090301' , -1.001 , 0.069 , -0.985 , -0.042 , 6 , 10.6 , 53.8 , 230 , '4600485905031420000099m9990000000001000001g0240,N,00E000=-00.000' , 0 , 0 , 1666919046 , 1666919046) [ RunTime:0.000492s ] --------------------------------------------------------------- [ 2022-10-28T10:03:57+08:00 ] 39.144.4.36 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002197s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011298s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000700s ] --------------------------------------------------------------- [ 2022-10-28T10:03:57+08:00 ] 39.144.15.201 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001453s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009721s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000918s ] --------------------------------------------------------------- [ 2022-10-28T10:04:06+08:00 ] 39.144.4.36 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=100301&v1=-00.667&v2=+00.001&v3=+00.016&v4=+00.010&v5=05.9&t=+16.7&h=54.8&rssi=+226&ccid=4600485905031430000099m9990000000042000000g7760,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001441s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008954s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000600s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='100301',`v1`=-0.667,`v2`=0.001,`v3`=0.016,`v4`=0.01,`v5`=5.9,`t`=16.7,`h`=54.8,`rssi`=226,`ccid`='4600485905031430000099m9990000000042000000g7760,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666922646 WHERE `imei` = '868922055644013' [ RunTime:0.000532s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011364s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '100301' , -0.667 , 0.001 , 0.016 , 0.01 , 5.9 , 16.7 , 54.8 , 226 , '4600485905031430000099m9990000000042000000g7760,N,00E000=-00.000' , 0 , 0 , 1666922646 , 1666922646) [ RunTime:0.000571s ] --------------------------------------------------------------- [ 2022-10-28T10:04:06+08:00 ] 39.144.15.201 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=100301&v1=-01.003&v2=+00.065&v3=-00.986&v4=-00.043&v5=06.0&t=+12.4&h=53.7&rssi=+229&ccid=4600485905031420000099m9990000000003000001g0270,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002184s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010546s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000592s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='100301',`v1`=-1.003,`v2`=0.065,`v3`=-0.986,`v4`=-0.043,`v5`=6,`t`=12.4,`h`=53.7,`rssi`=229,`ccid`='4600485905031420000099m9990000000003000001g0270,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666922646 WHERE `imei` = '868922055643643' [ RunTime:0.000481s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010099s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '100301' , -1.003 , 0.065 , -0.986 , -0.043 , 6 , 12.4 , 53.7 , 229 , '4600485905031420000099m9990000000003000001g0270,N,00E000=-00.000' , 0 , 0 , 1666922646 , 1666922646) [ RunTime:0.000456s ] --------------------------------------------------------------- [ 2022-10-28T11:01:45+08:00 ] 27.223.154.40 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002484s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011203s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000708s ] --------------------------------------------------------------- [ 2022-10-28T11:01:47+08:00 ] 27.223.154.40 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001452s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010926s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000698s ] --------------------------------------------------------------- [ 2022-10-28T11:01:49+08:00 ] 27.223.154.40 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001635s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009706s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000473s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000760s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000564s ] --------------------------------------------------------------- [ 2022-10-28T11:01:51+08:00 ] 117.132.192.203 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681494 [ sql ] [ DB ] CONNECT:[ UseTime:0.001514s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009447s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681494' LIMIT 1 [ RunTime:0.000604s ] --------------------------------------------------------------- [ 2022-10-28T11:01:59+08:00 ] 117.132.192.203 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681494&date=221028&time=110101&v1=+00.007&v2=+00.210&v3=+00.008&v4=+00.009&v5=10.7&t=+22.1&h=58.1&rssi=+224&ccid=4600485905031400000099m9990000000024000000g0170,N,00E003=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001497s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009534s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681494' LIMIT 1 [ RunTime:0.000590s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681494',`date`='221028',`time`='110101',`v1`=0.007,`v2`=0.21,`v3`=0.008,`v4`=0.009,`v5`=10.7,`t`=22.1,`h`=58.1,`rssi`=224,`ccid`='4600485905031400000099m9990000000024000000g0170,N,00E003=-00.000',`a1`=0,`a2`=0,`update_time`=1666926119 WHERE `imei` = '868922055681494' [ RunTime:0.000535s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008564s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055681494' , '221028' , '110101' , 0.007 , 0.21 , 0.008 , 0.009 , 10.7 , 22.1 , 58.1 , 224 , '4600485905031400000099m9990000000024000000g0170,N,00E003=-00.000' , 0 , 0 , 1666926119 , 1666926119) [ RunTime:0.000596s ] --------------------------------------------------------------- [ 2022-10-28T11:02:32+08:00 ] 27.223.154.40 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001780s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010682s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000448s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000636s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000533s ] --------------------------------------------------------------- [ 2022-10-28T11:02:34+08:00 ] 27.223.154.40 GET /home/show/edit/id/33.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001479s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009336s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000726s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009948s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` [ RunTime:0.000386s ] --------------------------------------------------------------- [ 2022-10-28T11:02:42+08:00 ] 27.223.154.40 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013437s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010521s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000477s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000729s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000553s ] --------------------------------------------------------------- [ 2022-10-28T11:02:46+08:00 ] 27.223.154.40 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001464s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010789s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000730s ] --------------------------------------------------------------- [ 2022-10-28T11:02:54+08:00 ] 27.223.154.40 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001889s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009876s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000455s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000699s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000549s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008899s ] [ 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.000402s ] [ 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.000439s ] --------------------------------------------------------------- [ 2022-10-28T11:03:07+08:00 ] 27.223.154.40 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001513s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009731s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000456s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000646s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000517s ] --------------------------------------------------------------- [ 2022-10-28T11:03:58+08:00 ] 39.144.15.138 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001524s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009705s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000598s ] --------------------------------------------------------------- [ 2022-10-28T11:03:58+08:00 ] 117.132.195.31 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001527s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011549s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000594s ] --------------------------------------------------------------- [ 2022-10-28T11:04:02+08:00 ] 27.223.154.40 GET /home/show/read/id/33/imei/868922055644013.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001479s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010362s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000747s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009378s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000506s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001560s ] --------------------------------------------------------------- [ 2022-10-28T11:04:07+08:00 ] 117.132.195.31 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=110301&v1=-01.004&v2=+00.066&v3=-00.987&v4=-00.043&v5=06.2&t=+13.8&h=53.6&rssi=+229&ccid=4600485905031420000099m9990000000003000001g0280,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002434s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010232s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='110301',`v1`=-1.004,`v2`=0.066,`v3`=-0.987,`v4`=-0.043,`v5`=6.2,`t`=13.8,`h`=53.6,`rssi`=229,`ccid`='4600485905031420000099m9990000000003000001g0280,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666926247 WHERE `imei` = '868922055643643' [ RunTime:0.000529s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009761s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '110301' , -1.004 , 0.066 , -0.987 , -0.043 , 6.2 , 13.8 , 53.6 , 229 , '4600485905031420000099m9990000000003000001g0280,N,00E000=-00.000' , 0 , 0 , 1666926247 , 1666926247) [ RunTime:0.000463s ] --------------------------------------------------------------- [ 2022-10-28T11:04:08+08:00 ] 39.144.15.138 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=110301&v1=-00.677&v2=+00.001&v3=+00.016&v4=+00.011&v5=06.0&t=+21.5&h=54.5&rssi=+226&ccid=4600485905031430000099m9990000000043000000g7830,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001751s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009445s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000697s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='110301',`v1`=-0.677,`v2`=0.001,`v3`=0.016,`v4`=0.011,`v5`=6,`t`=21.5,`h`=54.5,`rssi`=226,`ccid`='4600485905031430000099m9990000000043000000g7830,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666926248 WHERE `imei` = '868922055644013' [ RunTime:0.000508s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009538s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '110301' , -0.677 , 0.001 , 0.016 , 0.011 , 6 , 21.5 , 54.5 , 226 , '4600485905031430000099m9990000000043000000g7830,N,00E000=-00.000' , 0 , 0 , 1666926248 , 1666926248) [ RunTime:0.000445s ] --------------------------------------------------------------- [ 2022-10-28T11:05:16+08:00 ] 27.223.154.40 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001697s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009653s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000471s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000671s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000503s ] --------------------------------------------------------------- [ 2022-10-28T12:03:58+08:00 ] 39.144.15.74 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002152s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010243s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000713s ] --------------------------------------------------------------- [ 2022-10-28T12:03:58+08:00 ] 221.178.126.87 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.007254s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022539s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000639s ] --------------------------------------------------------------- [ 2022-10-28T12:04:06+08:00 ] 39.144.15.74 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=120301&v1=-00.693&v2=+00.001&v3=+00.016&v4=+00.011&v5=06.0&t=+22.5&h=55.2&rssi=+219&ccid=4600485905031430000099m9990000000044000000g7970,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001356s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010506s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000590s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='120301',`v1`=-0.693,`v2`=0.001,`v3`=0.016,`v4`=0.011,`v5`=6,`t`=22.5,`h`=55.2,`rssi`=219,`ccid`='4600485905031430000099m9990000000044000000g7970,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666929846 WHERE `imei` = '868922055644013' [ RunTime:0.000540s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009759s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '120301' , -0.693 , 0.001 , 0.016 , 0.011 , 6 , 22.5 , 55.2 , 219 , '4600485905031430000099m9990000000044000000g7970,N,00E000=-00.000' , 0 , 0 , 1666929846 , 1666929846) [ RunTime:0.000615s ] --------------------------------------------------------------- [ 2022-10-28T12:04:06+08:00 ] 221.178.126.87 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=120301&v1=-01.006&v2=+00.041&v3=-00.988&v4=-00.043&v5=06.0&t=+15.3&h=53.4&rssi=+231&ccid=4600485905031420000099m9990000000003000001g0290,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001531s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007923s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000630s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='120301',`v1`=-1.006,`v2`=0.041,`v3`=-0.988,`v4`=-0.043,`v5`=6,`t`=15.3,`h`=53.4,`rssi`=231,`ccid`='4600485905031420000099m9990000000003000001g0290,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666929846 WHERE `imei` = '868922055643643' [ RunTime:0.000489s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009465s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '120301' , -1.006 , 0.041 , -0.988 , -0.043 , 6 , 15.3 , 53.4 , 231 , '4600485905031420000099m9990000000003000001g0290,N,00E000=-00.000' , 0 , 0 , 1666929846 , 1666929846) [ RunTime:0.000468s ] --------------------------------------------------------------- [ 2022-10-28T13:03:57+08:00 ] 39.144.14.114 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ 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.009960s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000696s ] --------------------------------------------------------------- [ 2022-10-28T13:03:58+08:00 ] 39.144.2.0 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001430s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009458s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000584s ] --------------------------------------------------------------- [ 2022-10-28T13:04:06+08:00 ] 39.144.14.114 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=130301&v1=-00.720&v2=+00.001&v3=+00.017&v4=+00.012&v5=06.0&t=+20.6&h=57.2&rssi=+225&ccid=4600485905031430000099m9990000000041000000g8200,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001772s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011085s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000800s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='130301',`v1`=-0.72,`v2`=0.001,`v3`=0.017,`v4`=0.012,`v5`=6,`t`=20.6,`h`=57.2,`rssi`=225,`ccid`='4600485905031430000099m9990000000041000000g8200,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666933446 WHERE `imei` = '868922055644013' [ RunTime:0.000699s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012051s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '130301' , -0.72 , 0.001 , 0.017 , 0.012 , 6 , 20.6 , 57.2 , 225 , '4600485905031430000099m9990000000041000000g8200,N,00E000=-00.000' , 0 , 0 , 1666933446 , 1666933446) [ RunTime:0.000730s ] --------------------------------------------------------------- [ 2022-10-28T13:04:07+08:00 ] 39.144.2.0 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=130301&v1=-01.007&v2=+00.065&v3=-00.988&v4=-00.044&v5=06.2&t=+16.4&h=53.4&rssi=+229&ccid=4600485905031420000099m9990000000004000001g0300,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001392s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008745s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000592s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='130301',`v1`=-1.007,`v2`=0.065,`v3`=-0.988,`v4`=-0.044,`v5`=6.2,`t`=16.4,`h`=53.4,`rssi`=229,`ccid`='4600485905031420000099m9990000000004000001g0300,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666933447 WHERE `imei` = '868922055643643' [ RunTime:0.000472s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010126s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '130301' , -1.007 , 0.065 , -0.988 , -0.044 , 6.2 , 16.4 , 53.4 , 229 , '4600485905031420000099m9990000000004000001g0300,N,00E000=-00.000' , 0 , 0 , 1666933447 , 1666933447) [ RunTime:0.000488s ] --------------------------------------------------------------- [ 2022-10-28T14:03:57+08:00 ] 39.144.4.149 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002149s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013029s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000710s ] --------------------------------------------------------------- [ 2022-10-28T14:03:58+08:00 ] 39.144.13.215 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001490s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010258s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000663s ] --------------------------------------------------------------- [ 2022-10-28T14:04:06+08:00 ] 39.144.4.149 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=140301&v1=-01.008&v2=+00.064&v3=-00.988&v4=-00.043&v5=06.2&t=+17.1&h=53.5&rssi=+229&ccid=4600485905031420000099m9990000000006000001g0310,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001357s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009025s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000587s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='140301',`v1`=-1.008,`v2`=0.064,`v3`=-0.988,`v4`=-0.043,`v5`=6.2,`t`=17.1,`h`=53.5,`rssi`=229,`ccid`='4600485905031420000099m9990000000006000001g0310,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666937046 WHERE `imei` = '868922055643643' [ RunTime:0.000543s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010502s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '140301' , -1.008 , 0.064 , -0.988 , -0.043 , 6.2 , 17.1 , 53.5 , 229 , '4600485905031420000099m9990000000006000001g0310,N,00E000=-00.000' , 0 , 0 , 1666937046 , 1666937046) [ RunTime:0.000580s ] --------------------------------------------------------------- [ 2022-10-28T14:04:07+08:00 ] 39.144.13.215 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=140301&v1=-00.714&v2=+00.001&v3=+00.018&v4=+00.011&v5=06.0&t=+19.0&h=57.9&rssi=+226&ccid=4600485905031430000099m9990000000041000000g8130,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001637s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010718s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000667s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='140301',`v1`=-0.714,`v2`=0.001,`v3`=0.018,`v4`=0.011,`v5`=6,`t`=19,`h`=57.9,`rssi`=226,`ccid`='4600485905031430000099m9990000000041000000g8130,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666937047 WHERE `imei` = '868922055644013' [ RunTime:0.000526s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010010s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '140301' , -0.714 , 0.001 , 0.018 , 0.011 , 6 , 19 , 57.9 , 226 , '4600485905031430000099m9990000000041000000g8130,N,00E000=-00.000' , 0 , 0 , 1666937047 , 1666937047) [ RunTime:0.000532s ] --------------------------------------------------------------- [ 2022-10-28T14:56:07+08:00 ] 27.223.154.40 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002142s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010533s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000478s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000661s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000555s ] --------------------------------------------------------------- [ 2022-10-28T15:03:57+08:00 ] 221.178.125.17 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002190s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010396s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000690s ] --------------------------------------------------------------- [ 2022-10-28T15:03:58+08:00 ] 221.178.124.60 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001413s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009774s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000633s ] --------------------------------------------------------------- [ 2022-10-28T15:04:06+08:00 ] 221.178.125.17 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=150301&v1=-01.009&v2=+00.063&v3=-00.989&v4=-00.043&v5=06.2&t=+17.4&h=53.7&rssi=+231&ccid=4600485905031420000099m9990000000004000001g0310,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001515s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010262s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000668s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='150301',`v1`=-1.009,`v2`=0.063,`v3`=-0.989,`v4`=-0.043,`v5`=6.2,`t`=17.4,`h`=53.7,`rssi`=231,`ccid`='4600485905031420000099m9990000000004000001g0310,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666940646 WHERE `imei` = '868922055643643' [ RunTime:0.000606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010697s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '150301' , -1.009 , 0.063 , -0.989 , -0.043 , 6.2 , 17.4 , 53.7 , 231 , '4600485905031420000099m9990000000004000001g0310,N,00E000=-00.000' , 0 , 0 , 1666940646 , 1666940646) [ RunTime:0.000621s ] --------------------------------------------------------------- [ 2022-10-28T15:04:06+08:00 ] 221.178.124.60 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=150301&v1=-00.720&v2=+00.001&v3=+00.018&v4=+00.011&v5=05.2&t=+17.9&h=58.2&rssi=+228&ccid=4600485905031430000099m9990000000040000000g8150,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001333s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009536s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000635s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='150301',`v1`=-0.72,`v2`=0.001,`v3`=0.018,`v4`=0.011,`v5`=5.2,`t`=17.9,`h`=58.2,`rssi`=228,`ccid`='4600485905031430000099m9990000000040000000g8150,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666940646 WHERE `imei` = '868922055644013' [ RunTime:0.000455s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010212s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '150301' , -0.72 , 0.001 , 0.018 , 0.011 , 5.2 , 17.9 , 58.2 , 228 , '4600485905031430000099m9990000000040000000g8150,N,00E000=-00.000' , 0 , 0 , 1666940646 , 1666940646) [ RunTime:0.000528s ] --------------------------------------------------------------- [ 2022-10-28T15:21:15+08:00 ] 39.144.7.2 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002085s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011179s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000734s ] --------------------------------------------------------------- [ 2022-10-28T15:21:15+08:00 ] 27.223.154.40 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001432s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.009306s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000541s ] --------------------------------------------------------------- [ 2022-10-28T15:21:16+08:00 ] 39.144.7.2 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666941675&v1=2.305596&v2=0.013664&v3=2.302827&v4=0.007916&v5=11.880000&t=21.726162&h=42.812901&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001475s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011292s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666941675,`v1`=2.305596,`v2`=0.013664,`v3`=2.302827,`v4`=0.007916,`v5`=11.88,`t`=21.726162,`h`=42.812901,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666941676 WHERE `imei` = '868922055677740' [ RunTime:0.000516s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010510s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666941675 , 2.305596 , 0.013664 , 2.302827 , 0.007916 , 11.88 , 21.726162 , 42.812901 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1666941676) [ RunTime:0.000778s ] --------------------------------------------------------------- [ 2022-10-28T15:21:21+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001783s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010040s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000353s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000767s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000603s ] --------------------------------------------------------------- [ 2022-10-28T15:21:30+08:00 ] 27.223.154.40 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001371s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011043s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000374s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000646s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000591s ] --------------------------------------------------------------- [ 2022-10-28T15:21:31+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001353s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010870s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000686s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010198s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000971s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007995s ] --------------------------------------------------------------- [ 2022-10-28T15:23:41+08:00 ] 117.132.198.180 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002263s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011326s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000704s ] --------------------------------------------------------------- [ 2022-10-28T15:23:42+08:00 ] 117.132.198.180 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666941820&v1=3.650721&v2=0.014290&v3=3.646356&v4=0.007916&v5=11.880000&t=22.251690&h=41.241245&rssi=17&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001475s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008713s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000672s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666941820,`v1`=3.650721,`v2`=0.01429,`v3`=3.646356,`v4`=0.007916,`v5`=11.88,`t`=22.25169,`h`=41.241245,`rssi`=17,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666941822 WHERE `imei` = '868922055677740' [ RunTime:0.000490s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010550s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666941820 , 3.650721 , 0.01429 , 3.646356 , 0.007916 , 11.88 , 22.25169 , 41.241245 , 17 , '89860426102071188504' , '460044618415254' , -0 , 1666941822) [ RunTime:0.000494s ] --------------------------------------------------------------- [ 2022-10-28T15:25:49+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ 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.010154s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000665s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008876s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000916s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007306s ] --------------------------------------------------------------- [ 2022-10-28T15:26:06+08:00 ] 117.132.191.129 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001451s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010232s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000659s ] --------------------------------------------------------------- [ 2022-10-28T15:26:08+08:00 ] 117.132.191.129 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666941966&v1=3.649457&v2=0.015855&v3=3.645182&v4=0.007977&v5=11.880000&t=22.434017&h=42.538242&rssi=19&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001949s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010256s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000645s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666941966,`v1`=3.649457,`v2`=0.015855,`v3`=3.645182,`v4`=0.007977,`v5`=11.88,`t`=22.434017,`h`=42.538242,`rssi`=19,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666941968 WHERE `imei` = '868922055677740' [ RunTime:0.000467s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009940s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666941966 , 3.649457 , 0.015855 , 3.645182 , 0.007977 , 11.88 , 22.434017 , 42.538242 , 19 , '89860426102071188504' , '460044618415254' , -0 , 1666941968) [ RunTime:0.000494s ] --------------------------------------------------------------- [ 2022-10-28T16:03:57+08:00 ] 117.132.197.32 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002086s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009821s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000682s ] --------------------------------------------------------------- [ 2022-10-28T16:03:58+08:00 ] 117.132.193.172 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001616s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010008s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000615s ] --------------------------------------------------------------- [ 2022-10-28T16:04:05+08:00 ] 117.132.197.32 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=160301&v1=-01.010&v2=+00.074&v3=-00.991&v4=-00.043&v5=06.2&t=+17.1&h=54.0&rssi=+230&ccid=4600485905031420000099m9990000000004000001g0320,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001554s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009663s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000646s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='160301',`v1`=-1.01,`v2`=0.074,`v3`=-0.991,`v4`=-0.043,`v5`=6.2,`t`=17.1,`h`=54,`rssi`=230,`ccid`='4600485905031420000099m9990000000004000001g0320,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666944245 WHERE `imei` = '868922055643643' [ RunTime:0.000631s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010121s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '160301' , -1.01 , 0.074 , -0.991 , -0.043 , 6.2 , 17.1 , 54 , 230 , '4600485905031420000099m9990000000004000001g0320,N,00E000=-00.000' , 0 , 0 , 1666944245 , 1666944245) [ RunTime:0.000578s ] --------------------------------------------------------------- [ 2022-10-28T16:04:06+08:00 ] 117.132.193.172 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=160301&v1=-00.716&v2=+00.001&v3=+00.018&v4=+00.011&v5=06.0&t=+17.3&h=58.2&rssi=+228&ccid=4600485905031430000099m9990000000040000000g8130,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001608s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009814s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000616s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='160301',`v1`=-0.716,`v2`=0.001,`v3`=0.018,`v4`=0.011,`v5`=6,`t`=17.3,`h`=58.2,`rssi`=228,`ccid`='4600485905031430000099m9990000000040000000g8130,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666944246 WHERE `imei` = '868922055644013' [ RunTime:0.000465s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009409s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '160301' , -0.716 , 0.001 , 0.018 , 0.011 , 6 , 17.3 , 58.2 , 228 , '4600485905031430000099m9990000000040000000g8130,N,00E000=-00.000' , 0 , 0 , 1666944246 , 1666944246) [ RunTime:0.000488s ] --------------------------------------------------------------- [ 2022-10-28T16:24:41+08:00 ] 117.132.195.5 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002238s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010548s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000681s ] --------------------------------------------------------------- [ 2022-10-28T16:24:42+08:00 ] 117.132.195.5 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666945481&v1=0.007254&v2=0.015542&v3=33.507046&v4=0.009060&v5=11.880000&t=20.353352&h=47.970375&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.002434s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011739s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001168s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666945481,`v1`=0.007254,`v2`=0.015542,`v3`=33.507046,`v4`=0.00906,`v5`=11.88,`t`=20.353352,`h`=47.970375,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666945482 WHERE `imei` = '868922055677740' [ RunTime:0.000882s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013296s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666945481 , 0.007254 , 0.015542 , 33.507046 , 0.00906 , 11.88 , 20.353352 , 47.970375 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1666945482) [ RunTime:0.000920s ] --------------------------------------------------------------- [ 2022-10-28T16:25:00+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001953s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011525s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000876s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014129s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001544s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.011584s ] --------------------------------------------------------------- [ 2022-10-28T16:32:25+08:00 ] 218.204.252.132 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002123s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009100s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000746s ] --------------------------------------------------------------- [ 2022-10-28T16:32:27+08:00 ] 218.204.252.132 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666945945&v1=1.061429&v2=0.264734&v3=2.823894&v4=0.007916&v5=11.880000&t=20.449877&h=46.551308&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001431s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009389s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000723s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666945945,`v1`=1.061429,`v2`=0.264734,`v3`=2.823894,`v4`=0.007916,`v5`=11.88,`t`=20.449877,`h`=46.551308,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666945947 WHERE `imei` = '868922055677740' [ RunTime:0.000452s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009257s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666945945 , 1.061429 , 0.264734 , 2.823894 , 0.007916 , 11.88 , 20.449877 , 46.551308 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1666945947) [ RunTime:0.000469s ] --------------------------------------------------------------- [ 2022-10-28T16:32:31+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001425s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008513s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000585s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009748s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000799s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.006863s ] --------------------------------------------------------------- [ 2022-10-28T16:34:52+08:00 ] 39.144.7.186 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001600s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009627s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000597s ] --------------------------------------------------------------- [ 2022-10-28T16:34:54+08:00 ] 39.144.7.186 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666946092&v1=2.826272&v2=0.016168&v3=2.822449&v4=0.007796&v5=11.880000&t=21.039757&h=45.017799&rssi=19&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001548s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011031s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000670s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666946092,`v1`=2.826272,`v2`=0.016168,`v3`=2.822449,`v4`=0.007796,`v5`=11.88,`t`=21.039757,`h`=45.017799,`rssi`=19,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666946094 WHERE `imei` = '868922055677740' [ RunTime:0.000540s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010664s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666946092 , 2.826272 , 0.016168 , 2.822449 , 0.007796 , 11.88 , 21.039757 , 45.017799 , 19 , '89860426102071188504' , '460044618415254' , -0 , 1666946094) [ RunTime:0.000471s ] --------------------------------------------------------------- [ 2022-10-28T16:35:24+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001538s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009014s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010237s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000813s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007188s ] --------------------------------------------------------------- [ 2022-10-28T16:41:28+08:00 ] 39.144.4.153 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002260s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014099s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000649s ] --------------------------------------------------------------- [ 2022-10-28T16:43:53+08:00 ] 221.178.124.196 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ 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.011174s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000666s ] --------------------------------------------------------------- [ 2022-10-28T16:43:55+08:00 ] 221.178.124.196 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666946633&v1=0.915201&v2=0.300303&v3=0.007736&v4=0.007736&v5=11.880000&t=22.165890&h=42.454319&rssi=25&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001415s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007518s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000584s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666946633,`v1`=0.915201,`v2`=0.300303,`v3`=0.007736,`v4`=0.007736,`v5`=11.88,`t`=22.16589,`h`=42.454319,`rssi`=25,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666946635 WHERE `imei` = '868922055677740' [ RunTime:0.000496s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010400s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666946633 , 0.915201 , 0.300303 , 0.007736 , 0.007736 , 11.88 , 22.16589 , 42.454319 , 25 , '89860426102071188504' , '460044618415254' , -0 , 1666946635) [ RunTime:0.000596s ] --------------------------------------------------------------- [ 2022-10-28T16:43:57+08:00 ] 221.178.124.196 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041635&v1=0.915141&v2=0.306875&v3=0.007826&v4=0.007916&v5=12.060000&t=22.873745&h=41.493015&rssi=25&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001745s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010391s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000593s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041635,`v1`=0.915141,`v2`=0.306875,`v3`=0.007826,`v4`=0.007916,`v5`=12.06,`t`=22.873745,`h`=41.493015,`rssi`=25,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666946637 WHERE `imei` = '868922055677740' [ RunTime:0.000444s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009774s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041635 , 0.915141 , 0.306875 , 0.007826 , 0.007916 , 12.06 , 22.873745 , 41.493015 , 25 , '89860426102071188504' , '460044618415254' , -0 , 1666946637) [ RunTime:0.000469s ] --------------------------------------------------------------- [ 2022-10-28T16:44:00+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001545s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009710s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000611s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010852s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000921s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007297s ] --------------------------------------------------------------- [ 2022-10-28T16:45:07+08:00 ] 39.144.1.90 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001636s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009822s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000592s ] --------------------------------------------------------------- [ 2022-10-28T16:45:09+08:00 ] 39.144.1.90 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666946707&v1=0.915201&v2=0.350058&v3=0.007796&v4=0.007676&v5=11.880000&t=22.444742&h=42.477207&rssi=26&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001409s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009944s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000699s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666946707,`v1`=0.915201,`v2`=0.350058,`v3`=0.007796,`v4`=0.007676,`v5`=11.88,`t`=22.444742,`h`=42.477207,`rssi`=26,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666946709 WHERE `imei` = '868922055677740' [ RunTime:0.000464s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009454s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666946707 , 0.915201 , 0.350058 , 0.007796 , 0.007676 , 11.88 , 22.444742 , 42.477207 , 26 , '89860426102071188504' , '460044618415254' , -0 , 1666946709) [ RunTime:0.000479s ] --------------------------------------------------------------- [ 2022-10-28T16:45:15+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001381s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010022s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000595s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010016s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000865s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.006991s ] --------------------------------------------------------------- [ 2022-10-28T16:47:34+08:00 ] 39.144.15.111 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001518s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011049s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.013453s ] --------------------------------------------------------------- [ 2022-10-28T16:47:35+08:00 ] 39.144.15.111 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666946854&v1=0.915141&v2=0.286117&v3=0.007645&v4=0.007615&v5=11.880000&t=21.865587&h=43.163853&rssi=25&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001624s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011260s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000622s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666946854,`v1`=0.915141,`v2`=0.286117,`v3`=0.007645,`v4`=0.007615,`v5`=11.88,`t`=21.865587,`h`=43.163853,`rssi`=25,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666946855 WHERE `imei` = '868922055677740' [ RunTime:0.000462s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010218s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666946854 , 0.915141 , 0.286117 , 0.007645 , 0.007615 , 11.88 , 21.865587 , 43.163853 , 25 , '89860426102071188504' , '460044618415254' , -0 , 1666946855) [ RunTime:0.000487s ] --------------------------------------------------------------- [ 2022-10-28T16:50:01+08:00 ] 39.144.5.195 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002223s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010403s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000665s ] --------------------------------------------------------------- [ 2022-10-28T16:50:02+08:00 ] 39.144.5.195 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666947001&v1=0.914960&v2=0.288934&v3=0.007645&v4=0.007615&v5=11.700000&t=21.511660&h=43.774204&rssi=27&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001639s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009804s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000756s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666947001,`v1`=0.91496,`v2`=0.288934,`v3`=0.007645,`v4`=0.007615,`v5`=11.7,`t`=21.51166,`h`=43.774204,`rssi`=27,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666947002 WHERE `imei` = '868922055677740' [ RunTime:0.000483s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008379s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666947001 , 0.91496 , 0.288934 , 0.007645 , 0.007615 , 11.7 , 21.51166 , 43.774204 , 27 , '89860426102071188504' , '460044618415254' , -0 , 1666947002) [ RunTime:0.000630s ] --------------------------------------------------------------- [ 2022-10-28T16:50:09+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001902s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012084s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000636s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009696s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000989s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007757s ] --------------------------------------------------------------- [ 2022-10-28T16:51:13+08:00 ] 39.144.6.89 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001464s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010695s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000756s ] --------------------------------------------------------------- [ 2022-10-28T16:51:14+08:00 ] 39.144.6.89 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666947073&v1=0.915020&v2=0.317723&v3=0.913907&v4=0.007736&v5=11.880000&t=21.854862&h=43.758945&rssi=27&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001788s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010944s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000867s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666947073,`v1`=0.91502,`v2`=0.317723,`v3`=0.913907,`v4`=0.007736,`v5`=11.88,`t`=21.854862,`h`=43.758945,`rssi`=27,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666947074 WHERE `imei` = '868922055677740' [ RunTime:0.000664s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013467s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666947073 , 0.91502 , 0.317723 , 0.913907 , 0.007736 , 11.88 , 21.854862 , 43.758945 , 27 , '89860426102071188504' , '460044618415254' , -0 , 1666947074) [ RunTime:0.000581s ] --------------------------------------------------------------- [ 2022-10-28T16:51:18+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001608s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010791s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.001072s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012368s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001031s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.010835s ] --------------------------------------------------------------- [ 2022-10-28T17:03:57+08:00 ] 117.132.195.213 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002196s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007988s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000692s ] --------------------------------------------------------------- [ 2022-10-28T17:03:57+08:00 ] 39.144.10.45 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001994s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009383s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000827s ] --------------------------------------------------------------- [ 2022-10-28T17:04:05+08:00 ] 117.132.195.213 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=170301&v1=-01.011&v2=+00.057&v3=-00.990&v4=-00.044&v5=06.2&t=+15.7&h=54.7&rssi=+229&ccid=4600485905031420000099m9990000000007000001g0330,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001655s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009536s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000761s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='170301',`v1`=-1.011,`v2`=0.057,`v3`=-0.99,`v4`=-0.044,`v5`=6.2,`t`=15.7,`h`=54.7,`rssi`=229,`ccid`='4600485905031420000099m9990000000007000001g0330,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666947845 WHERE `imei` = '868922055643643' [ RunTime:0.000570s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010201s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '170301' , -1.011 , 0.057 , -0.99 , -0.044 , 6.2 , 15.7 , 54.7 , 229 , '4600485905031420000099m9990000000007000001g0330,N,00E000=-00.000' , 0 , 0 , 1666947845 , 1666947845) [ RunTime:0.000507s ] --------------------------------------------------------------- [ 2022-10-28T17:04:06+08:00 ] 39.144.10.45 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=170301&v1=-00.724&v2=+00.001&v3=+00.016&v4=+00.011&v5=06.0&t=+15.9&h=58.7&rssi=+226&ccid=4600485905031430000099m9990000000041000000g8210,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001616s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010241s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000704s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='170301',`v1`=-0.724,`v2`=0.001,`v3`=0.016,`v4`=0.011,`v5`=6,`t`=15.9,`h`=58.7,`rssi`=226,`ccid`='4600485905031430000099m9990000000041000000g8210,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666947846 WHERE `imei` = '868922055644013' [ RunTime:0.000560s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010398s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '170301' , -0.724 , 0.001 , 0.016 , 0.011 , 6 , 15.9 , 58.7 , 226 , '4600485905031430000099m9990000000041000000g8210,N,00E000=-00.000' , 0 , 0 , 1666947846 , 1666947846) [ RunTime:0.000536s ] --------------------------------------------------------------- [ 2022-10-28T18:03:56+08:00 ] 39.144.5.33 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002067s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010326s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000650s ] --------------------------------------------------------------- [ 2022-10-28T18:03:58+08:00 ] 39.144.3.199 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001429s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007222s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000592s ] --------------------------------------------------------------- [ 2022-10-28T18:04:05+08:00 ] 39.144.5.33 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=180301&v1=-01.011&v2=+00.053&v3=-00.989&v4=-00.044&v5=06.2&t=+13.7&h=55.3&rssi=+229&ccid=4600485905031420000099m9990000000008000001g0340,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001494s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010588s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000683s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='180301',`v1`=-1.011,`v2`=0.053,`v3`=-0.989,`v4`=-0.044,`v5`=6.2,`t`=13.7,`h`=55.3,`rssi`=229,`ccid`='4600485905031420000099m9990000000008000001g0340,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666951445 WHERE `imei` = '868922055643643' [ RunTime:0.000659s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010692s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '180301' , -1.011 , 0.053 , -0.989 , -0.044 , 6.2 , 13.7 , 55.3 , 229 , '4600485905031420000099m9990000000008000001g0340,N,00E000=-00.000' , 0 , 0 , 1666951445 , 1666951445) [ RunTime:0.000572s ] --------------------------------------------------------------- [ 2022-10-28T18:04:07+08:00 ] 39.144.3.199 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=180301&v1=-00.742&v2=+00.001&v3=+00.000&v4=+00.012&v5=06.0&t=+14.1&h=59.2&rssi=+224&ccid=4600485905031430000099m9990000000045000000g8340,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001513s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009554s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000607s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='180301',`v1`=-0.742,`v2`=0.001,`v3`=0,`v4`=0.012,`v5`=6,`t`=14.1,`h`=59.2,`rssi`=224,`ccid`='4600485905031430000099m9990000000045000000g8340,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666951447 WHERE `imei` = '868922055644013' [ RunTime:0.000483s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010161s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '180301' , -0.742 , 0.001 , 0 , 0.012 , 6 , 14.1 , 59.2 , 224 , '4600485905031430000099m9990000000045000000g8340,N,00E000=-00.000' , 0 , 0 , 1666951447 , 1666951447) [ RunTime:0.000455s ] --------------------------------------------------------------- [ 2022-10-28T19:03:58+08:00 ] 117.132.193.84 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002192s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012649s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000679s ] --------------------------------------------------------------- [ 2022-10-28T19:03:58+08:00 ] 39.144.15.31 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001400s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008967s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000649s ] --------------------------------------------------------------- [ 2022-10-28T19:04:06+08:00 ] 117.132.193.84 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=190301&v1=-00.737&v2=+00.001&v3=+00.016&v4=+00.011&v5=05.9&t=+13.1&h=59.1&rssi=+226&ccid=4600485905031430000099m9990000000039000000g8300,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001514s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010763s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000687s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='190301',`v1`=-0.737,`v2`=0.001,`v3`=0.016,`v4`=0.011,`v5`=5.9,`t`=13.1,`h`=59.1,`rssi`=226,`ccid`='4600485905031430000099m9990000000039000000g8300,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666955046 WHERE `imei` = '868922055644013' [ RunTime:0.000602s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011190s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '190301' , -0.737 , 0.001 , 0.016 , 0.011 , 5.9 , 13.1 , 59.1 , 226 , '4600485905031430000099m9990000000039000000g8300,N,00E000=-00.000' , 0 , 0 , 1666955046 , 1666955046) [ RunTime:0.000583s ] --------------------------------------------------------------- [ 2022-10-28T19:04:07+08:00 ] 39.144.15.31 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=190301&v1=-01.012&v2=+00.044&v3=-00.988&v4=-00.043&v5=06.2&t=+12.6&h=55.3&rssi=+231&ccid=4600485905031420000099m9990000000010000001g0350,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001496s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009804s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000704s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='190301',`v1`=-1.012,`v2`=0.044,`v3`=-0.988,`v4`=-0.043,`v5`=6.2,`t`=12.6,`h`=55.3,`rssi`=231,`ccid`='4600485905031420000099m9990000000010000001g0350,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666955047 WHERE `imei` = '868922055643643' [ RunTime:0.000526s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010419s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '190301' , -1.012 , 0.044 , -0.988 , -0.043 , 6.2 , 12.6 , 55.3 , 231 , '4600485905031420000099m9990000000010000001g0350,N,00E000=-00.000' , 0 , 0 , 1666955047 , 1666955047) [ RunTime:0.000493s ] --------------------------------------------------------------- [ 2022-10-28T19:44:20+08:00 ] 39.144.10.225 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002259s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011966s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000678s ] --------------------------------------------------------------- [ 2022-10-28T19:44:22+08:00 ] 39.144.10.225 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1666957460&v1=0.025856&v2=0.049025&v3=0.021221&v4=-0.002258&v5=6.660000&t=9.446037&h=65.388245&rssi=22&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001402s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010628s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1666957460,`v1`=0.025856,`v2`=0.049025,`v3`=0.021221,`v4`=-0.002258,`v5`=6.66,`t`=9.446037,`h`=65.388245,`rssi`=22,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1666957462 WHERE `imei` = '868922055644211' [ RunTime:0.000531s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009449s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1666957460 , 0.025856 , 0.049025 , 0.021221 , -0.002258 , 6.66 , 9.446037 , 65.388245 , 22 , '89860426102071188505' , '460044618415255' , -0 , 1666957462) [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2022-10-28T20:03:58+08:00 ] 39.144.16.221 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ 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.010197s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000673s ] --------------------------------------------------------------- [ 2022-10-28T20:03:58+08:00 ] 218.204.253.186 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001883s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008434s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000629s ] --------------------------------------------------------------- [ 2022-10-28T20:04:06+08:00 ] 39.144.16.221 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=200301&v1=-00.719&v2=+00.001&v3=-00.035&v4=+00.012&v5=05.9&t=+12.2&h=59.2&rssi=+225&ccid=4600485905031430000099m9990000000049000000g8150,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001351s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008589s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000612s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='200301',`v1`=-0.719,`v2`=0.001,`v3`=-0.035,`v4`=0.012,`v5`=5.9,`t`=12.2,`h`=59.2,`rssi`=225,`ccid`='4600485905031430000099m9990000000049000000g8150,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666958646 WHERE `imei` = '868922055644013' [ RunTime:0.000473s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010375s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '200301' , -0.719 , 0.001 , -0.035 , 0.012 , 5.9 , 12.2 , 59.2 , 225 , '4600485905031430000099m9990000000049000000g8150,N,00E000=-00.000' , 0 , 0 , 1666958646 , 1666958646) [ RunTime:0.000547s ] --------------------------------------------------------------- [ 2022-10-28T20:04:06+08:00 ] 218.204.253.186 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=200301&v1=-01.013&v2=+00.037&v3=-00.989&v4=-00.043&v5=06.0&t=+11.6&h=55.4&rssi=+229&ccid=4600485905031420000099m9990000000011000001g0360,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001514s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008606s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000601s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='200301',`v1`=-1.013,`v2`=0.037,`v3`=-0.989,`v4`=-0.043,`v5`=6,`t`=11.6,`h`=55.4,`rssi`=229,`ccid`='4600485905031420000099m9990000000011000001g0360,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666958646 WHERE `imei` = '868922055643643' [ RunTime:0.000480s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010142s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '200301' , -1.013 , 0.037 , -0.989 , -0.043 , 6 , 11.6 , 55.4 , 229 , '4600485905031420000099m9990000000011000001g0360,N,00E000=-00.000' , 0 , 0 , 1666958646 , 1666958646) [ RunTime:0.000506s ] --------------------------------------------------------------- [ 2022-10-28T20:22:43+08:00 ] 112.226.103.28 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002132s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.009722s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000669s ] --------------------------------------------------------------- [ 2022-10-28T20:22:46+08:00 ] 112.226.103.28 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001554s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010251s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000326s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000710s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000571s ] --------------------------------------------------------------- [ 2022-10-28T20:22:54+08:00 ] 112.226.103.28 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001527s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009071s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000383s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000732s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000638s ] --------------------------------------------------------------- [ 2022-10-28T20:23:01+08:00 ] 112.226.103.28 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001704s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010997s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000712s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011050s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001268s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007337s ] --------------------------------------------------------------- [ 2022-10-28T20:23:04+08:00 ] 112.226.103.28 GET /admin/show/read/id/22/imei/868922055677740.html [ 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.008215s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000624s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008926s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000831s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.006866s ] --------------------------------------------------------------- [ 2022-10-28T21:03:57+08:00 ] 39.144.1.245 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002552s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011545s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000745s ] --------------------------------------------------------------- [ 2022-10-28T21:03:58+08:00 ] 223.104.254.153 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001534s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009539s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000627s ] --------------------------------------------------------------- [ 2022-10-28T21:04:06+08:00 ] 39.144.1.245 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=210301&v1=-00.701&v2=+00.001&v3=-00.215&v4=+00.019&v5=05.9&t=+11.2&h=59.3&rssi=+227&ccid=4600485905031430000099m9990000000068000000g7960,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001695s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009815s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='210301',`v1`=-0.701,`v2`=0.001,`v3`=-0.215,`v4`=0.019,`v5`=5.9,`t`=11.2,`h`=59.3,`rssi`=227,`ccid`='4600485905031430000099m9990000000068000000g7960,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666962246 WHERE `imei` = '868922055644013' [ RunTime:0.000579s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010620s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '210301' , -0.701 , 0.001 , -0.215 , 0.019 , 5.9 , 11.2 , 59.3 , 227 , '4600485905031430000099m9990000000068000000g7960,N,00E000=-00.000' , 0 , 0 , 1666962246 , 1666962246) [ RunTime:0.000574s ] --------------------------------------------------------------- [ 2022-10-28T21:04:06+08:00 ] 223.104.254.153 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=210301&v1=-01.014&v2=+00.038&v3=-00.987&v4=-00.043&v5=06.2&t=+10.3&h=55.6&rssi=+231&ccid=4600485905031420000099m9990000000015000001g0380,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001455s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010784s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000670s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='210301',`v1`=-1.014,`v2`=0.038,`v3`=-0.987,`v4`=-0.043,`v5`=6.2,`t`=10.3,`h`=55.6,`rssi`=231,`ccid`='4600485905031420000099m9990000000015000001g0380,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666962246 WHERE `imei` = '868922055643643' [ RunTime:0.000475s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009855s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '210301' , -1.014 , 0.038 , -0.987 , -0.043 , 6.2 , 10.3 , 55.6 , 231 , '4600485905031420000099m9990000000015000001g0380,N,00E000=-00.000' , 0 , 0 , 1666962246 , 1666962246) [ RunTime:0.000450s ] --------------------------------------------------------------- [ 2022-10-28T21:57:01+08:00 ] 112.226.103.28 GET /admin [ sql ] [ DB ] CONNECT:[ UseTime:0.002334s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010423s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000358s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000989s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000611s ] --------------------------------------------------------------- [ 2022-10-28T22:03:57+08:00 ] 39.144.18.34 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002093s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011196s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000723s ] --------------------------------------------------------------- [ 2022-10-28T22:03:58+08:00 ] 39.144.16.128 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001771s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012692s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000811s ] --------------------------------------------------------------- [ 2022-10-28T22:04:06+08:00 ] 39.144.18.34 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=220301&v1=-01.015&v2=+00.044&v3=-00.987&v4=-00.043&v5=06.0&t=+09.2&h=55.6&rssi=+229&ccid=4600485905031420000099m9990000000016000001g0380,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001327s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010799s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000788s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='220301',`v1`=-1.015,`v2`=0.044,`v3`=-0.987,`v4`=-0.043,`v5`=6,`t`=9.2,`h`=55.6,`rssi`=229,`ccid`='4600485905031420000099m9990000000016000001g0380,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666965846 WHERE `imei` = '868922055643643' [ RunTime:0.000617s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011943s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '220301' , -1.015 , 0.044 , -0.987 , -0.043 , 6 , 9.2 , 55.6 , 229 , '4600485905031420000099m9990000000016000001g0380,N,00E000=-00.000' , 0 , 0 , 1666965846 , 1666965846) [ RunTime:0.000612s ] --------------------------------------------------------------- [ 2022-10-28T22:04:07+08:00 ] 39.144.16.128 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=220301&v1=-00.687&v2=+00.001&v3=-00.464&v4=+00.029&v5=05.9&t=+10.2&h=59.4&rssi=+225&ccid=4600485905031430000099m9990000000098000000g7820,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001713s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011122s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000606s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='220301',`v1`=-0.687,`v2`=0.001,`v3`=-0.464,`v4`=0.029,`v5`=5.9,`t`=10.2,`h`=59.4,`rssi`=225,`ccid`='4600485905031430000099m9990000000098000000g7820,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666965847 WHERE `imei` = '868922055644013' [ RunTime:0.000475s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011120s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '220301' , -0.687 , 0.001 , -0.464 , 0.029 , 5.9 , 10.2 , 59.4 , 225 , '4600485905031430000099m9990000000098000000g7820,N,00E000=-00.000' , 0 , 0 , 1666965847 , 1666965847) [ RunTime:0.000476s ] --------------------------------------------------------------- [ 2022-10-28T22:05:50+08:00 ] 221.178.127.97 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.001664s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011474s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000657s ] --------------------------------------------------------------- [ 2022-10-28T22:05:59+08:00 ] 221.178.127.97 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221028&time=220501&v1=-01.280&v2=+00.029&v3=-01.122&v4=-00.764&v5=05.6&t=+10.9&h=81.2&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.185&a2=01.294&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001854s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009019s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000618s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221028',`time`='220501',`v1`=-1.28,`v2`=0.029,`v3`=-1.122,`v4`=-0.764,`v5`=5.6,`t`=10.9,`h`=81.2,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.185,`a2`=1.294,`update_time`=1666965959 WHERE `imei` = '868922055684076' [ RunTime:0.000480s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010272s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '221028' , '220501' , -1.28 , 0.029 , -1.122 , -0.764 , 5.6 , 10.9 , 81.2 , 228 , '460044618415249' , -0 , 0.185 , 1.294 , 1666965959 , 1666965959) [ RunTime:0.000657s ] --------------------------------------------------------------- [ 2022-10-28T23:03:58+08:00 ] 117.132.193.237 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.003366s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009872s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000651s ] --------------------------------------------------------------- [ 2022-10-28T23:03:58+08:00 ] 39.144.13.201 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001585s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013024s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000656s ] --------------------------------------------------------------- [ 2022-10-28T23:04:06+08:00 ] 117.132.193.237 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221028&time=230301&v1=-00.664&v2=+00.001&v3=-00.097&v4=+00.012&v5=05.9&t=+10.0&h=59.1&rssi=+226&ccid=4600485905031430000099m9990000000049000000g7570,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001560s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011319s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000660s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221028',`time`='230301',`v1`=-0.664,`v2`=0.001,`v3`=-0.097,`v4`=0.012,`v5`=5.9,`t`=10,`h`=59.1,`rssi`=226,`ccid`='4600485905031430000099m9990000000049000000g7570,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666969446 WHERE `imei` = '868922055644013' [ RunTime:0.000600s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010224s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221028' , '230301' , -0.664 , 0.001 , -0.097 , 0.012 , 5.9 , 10 , 59.1 , 226 , '4600485905031430000099m9990000000049000000g7570,N,00E000=-00.000' , 0 , 0 , 1666969446 , 1666969446) [ RunTime:0.000611s ] --------------------------------------------------------------- [ 2022-10-28T23:04:07+08:00 ] 39.144.13.201 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221028&time=230301&v1=-01.015&v2=+00.040&v3=-00.987&v4=-00.043&v5=06.0&t=+09.1&h=55.3&rssi=+229&ccid=4600485905031420000099m9990000000017000001g0380,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001485s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011474s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000791s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221028',`time`='230301',`v1`=-1.015,`v2`=0.04,`v3`=-0.987,`v4`=-0.043,`v5`=6,`t`=9.1,`h`=55.3,`rssi`=229,`ccid`='4600485905031420000099m9990000000017000001g0380,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666969447 WHERE `imei` = '868922055643643' [ RunTime:0.000501s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011328s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221028' , '230301' , -1.015 , 0.04 , -0.987 , -0.043 , 6 , 9.1 , 55.3 , 229 , '4600485905031420000099m9990000000017000001g0380,N,00E000=-00.000' , 0 , 0 , 1666969447 , 1666969447) [ RunTime:0.000513s ]