--------------------------------------------------------------- [ 2022-10-27T00:03:57+08:00 ] 117.132.197.124 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002631s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012229s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000713s ] --------------------------------------------------------------- [ 2022-10-27T00:04:06+08:00 ] 117.132.197.124 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=000301&v1=-00.667&v2=+00.001&v3=-00.547&v4=+00.042&v5=05.9&t=+11.2&h=58.8&rssi=+224&ccid=4600485905031430000099m9990000000084000000g7580,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001390s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010177s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='000301',`v1`=-0.667,`v2`=0.001,`v3`=-0.547,`v4`=0.042,`v5`=5.9,`t`=11.2,`h`=58.8,`rssi`=224,`ccid`='4600485905031430000099m9990000000084000000g7580,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666800246 WHERE `imei` = '868922055644013' [ RunTime:0.000561s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010806s ] [ 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' , '221027' , '000301' , -0.667 , 0.001 , -0.547 , 0.042 , 5.9 , 11.2 , 58.8 , 224 , '4600485905031430000099m9990000000084000000g7580,N,00E000=-00.000' , 0 , 0 , 1666800246 , 1666800246) [ RunTime:0.000653s ] --------------------------------------------------------------- [ 2022-10-27T01: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.002068s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011039s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000728s ] --------------------------------------------------------------- [ 2022-10-27T01:04:07+08:00 ] 117.132.193.237 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=010301&v1=-00.642&v2=+00.001&v3=-00.541&v4=+00.041&v5=05.9&t=+10.4&h=58.8&rssi=+227&ccid=4600485905031430000099m9990000000087000000g7360,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001463s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009924s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000627s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='010301',`v1`=-0.642,`v2`=0.001,`v3`=-0.541,`v4`=0.041,`v5`=5.9,`t`=10.4,`h`=58.8,`rssi`=227,`ccid`='4600485905031430000099m9990000000087000000g7360,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666803847 WHERE `imei` = '868922055644013' [ RunTime:0.000676s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008490s ] [ 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' , '221027' , '010301' , -0.642 , 0.001 , -0.541 , 0.041 , 5.9 , 10.4 , 58.8 , 227 , '4600485905031430000099m9990000000087000000g7360,N,00E000=-00.000' , 0 , 0 , 1666803847 , 1666803847) [ RunTime:0.000571s ] --------------------------------------------------------------- [ 2022-10-27T02:03:58+08:00 ] 117.132.198.156 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002113s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009661s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000629s ] --------------------------------------------------------------- [ 2022-10-27T02:04:07+08:00 ] 117.132.198.156 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=020301&v1=-00.597&v2=+00.001&v3=-00.436&v4=+00.035&v5=05.9&t=+10.3&h=58.5&rssi=+225&ccid=4600485905031430000099m9990000000122000000g6860,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001641s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007662s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000618s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='020301',`v1`=-0.597,`v2`=0.001,`v3`=-0.436,`v4`=0.035,`v5`=5.9,`t`=10.3,`h`=58.5,`rssi`=225,`ccid`='4600485905031430000099m9990000000122000000g6860,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666807446 WHERE `imei` = '868922055644013' [ RunTime:0.000530s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010919s ] [ 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' , '221027' , '020301' , -0.597 , 0.001 , -0.436 , 0.035 , 5.9 , 10.3 , 58.5 , 225 , '4600485905031430000099m9990000000122000000g6860,N,00E000=-00.000' , 0 , 0 , 1666807447 , 1666807447) [ RunTime:0.000620s ] --------------------------------------------------------------- [ 2022-10-27T03:03:56+08:00 ] 39.144.4.84 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002666s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011093s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000678s ] --------------------------------------------------------------- [ 2022-10-27T03:03:58+08:00 ] 39.144.3.166 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001836s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009235s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000710s ] --------------------------------------------------------------- [ 2022-10-27T03:04:04+08:00 ] 39.144.4.84 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221027&time=030301&v1=-00.963&v2=+00.036&v3=-00.981&v4=-00.040&v5=05.7&t=+09.4&h=55.1&rssi=+229&ccid=4600485905031420000099m9990000000039000000g9870,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001625s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010055s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000711s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221027',`time`='030301',`v1`=-0.963,`v2`=0.036,`v3`=-0.981,`v4`=-0.04,`v5`=5.7,`t`=9.4,`h`=55.1,`rssi`=229,`ccid`='4600485905031420000099m9990000000039000000g9870,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666811044 WHERE `imei` = '868922055643643' [ RunTime:0.000598s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011638s ] [ 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' , '221027' , '030301' , -0.963 , 0.036 , -0.981 , -0.04 , 5.7 , 9.4 , 55.1 , 229 , '4600485905031420000099m9990000000039000000g9870,N,00E000=-00.000' , 0 , 0 , 1666811044 , 1666811044) [ RunTime:0.000807s ] --------------------------------------------------------------- [ 2022-10-27T03:04:06+08:00 ] 39.144.3.166 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=030301&v1=-00.606&v2=+00.001&v3=-00.206&v4=+00.023&v5=05.9&t=+10.0&h=58.5&rssi=+227&ccid=4600485905031430000099m9990000000098000000g6730,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001435s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008901s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000586s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='030301',`v1`=-0.606,`v2`=0.001,`v3`=-0.206,`v4`=0.023,`v5`=5.9,`t`=10,`h`=58.5,`rssi`=227,`ccid`='4600485905031430000099m9990000000098000000g6730,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666811046 WHERE `imei` = '868922055644013' [ RunTime:0.000479s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009285s ] [ 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' , '221027' , '030301' , -0.606 , 0.001 , -0.206 , 0.023 , 5.9 , 10 , 58.5 , 227 , '4600485905031430000099m9990000000098000000g6730,N,00E000=-00.000' , 0 , 0 , 1666811046 , 1666811046) [ RunTime:0.000503s ] --------------------------------------------------------------- [ 2022-10-27T04:03:57+08:00 ] 117.132.194.89 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002177s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011486s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2022-10-27T04:04:06+08:00 ] 117.132.194.89 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=040301&v1=-00.598&v2=+00.001&v3=-00.232&v4=+00.024&v5=05.9&t=+09.9&h=58.5&rssi=+225&ccid=4600485905031430000099m9990000000106000000g6610,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002421s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010378s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000809s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='040301',`v1`=-0.598,`v2`=0.001,`v3`=-0.232,`v4`=0.024,`v5`=5.9,`t`=9.9,`h`=58.5,`rssi`=225,`ccid`='4600485905031430000099m9990000000106000000g6610,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666814646 WHERE `imei` = '868922055644013' [ RunTime:0.000657s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009470s ] [ 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' , '221027' , '040301' , -0.598 , 0.001 , -0.232 , 0.024 , 5.9 , 9.9 , 58.5 , 225 , '4600485905031430000099m9990000000106000000g6610,N,00E000=-00.000' , 0 , 0 , 1666814646 , 1666814646) [ RunTime:0.000700s ] --------------------------------------------------------------- [ 2022-10-27T05:03:58+08:00 ] 39.144.7.86 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.016142s ] 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.000915s ] --------------------------------------------------------------- [ 2022-10-27T05:04:07+08:00 ] 39.144.7.86 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=050301&v1=-00.569&v2=+00.001&v3=-00.236&v4=+00.023&v5=05.9&t=+09.4&h=58.6&rssi=+225&ccid=4600485905031430000099m9990000000111000000g6300,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001542s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009964s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000687s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='050301',`v1`=-0.569,`v2`=0.001,`v3`=-0.236,`v4`=0.023,`v5`=5.9,`t`=9.4,`h`=58.6,`rssi`=225,`ccid`='4600485905031430000099m9990000000111000000g6300,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666818247 WHERE `imei` = '868922055644013' [ RunTime:0.000689s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010628s ] [ 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' , '221027' , '050301' , -0.569 , 0.001 , -0.236 , 0.023 , 5.9 , 9.4 , 58.6 , 225 , '4600485905031430000099m9990000000111000000g6300,N,00E000=-00.000' , 0 , 0 , 1666818247 , 1666818247) [ RunTime:0.000834s ] --------------------------------------------------------------- [ 2022-10-27T06:03:58+08:00 ] 39.144.5.92 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002100s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009353s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000723s ] --------------------------------------------------------------- [ 2022-10-27T06:04:06+08:00 ] 39.144.5.92 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=060301&v1=-00.570&v2=+00.001&v3=-00.251&v4=+00.024&v5=05.9&t=+08.8&h=58.6&rssi=+225&ccid=4600485905031430000099m9990000000112000000g6300,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001649s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010313s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000786s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='060301',`v1`=-0.57,`v2`=0.001,`v3`=-0.251,`v4`=0.024,`v5`=5.9,`t`=8.8,`h`=58.6,`rssi`=225,`ccid`='4600485905031430000099m9990000000112000000g6300,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666821846 WHERE `imei` = '868922055644013' [ RunTime:0.000651s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012394s ] [ 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' , '221027' , '060301' , -0.57 , 0.001 , -0.251 , 0.024 , 5.9 , 8.8 , 58.6 , 225 , '4600485905031430000099m9990000000112000000g6300,N,00E000=-00.000' , 0 , 0 , 1666821846 , 1666821846) [ RunTime:0.000767s ] --------------------------------------------------------------- [ 2022-10-27T07:03:58+08:00 ] 39.144.15.98 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002191s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010525s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001161s ] --------------------------------------------------------------- [ 2022-10-27T07:04:06+08:00 ] 39.144.15.98 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=070301&v1=-00.581&v2=+00.001&v3=-00.272&v4=+00.026&v5=05.9&t=+09.2&h=58.3&rssi=+225&ccid=4600485905031430000099m9990000000116000000g6350,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001970s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008986s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000621s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='070301',`v1`=-0.581,`v2`=0.001,`v3`=-0.272,`v4`=0.026,`v5`=5.9,`t`=9.2,`h`=58.3,`rssi`=225,`ccid`='4600485905031430000099m9990000000116000000g6350,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666825446 WHERE `imei` = '868922055644013' [ RunTime:0.000554s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010649s ] [ 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' , '221027' , '070301' , -0.581 , 0.001 , -0.272 , 0.026 , 5.9 , 9.2 , 58.3 , 225 , '4600485905031430000099m9990000000116000000g6350,N,00E000=-00.000' , 0 , 0 , 1666825446 , 1666825446) [ RunTime:0.000680s ] --------------------------------------------------------------- [ 2022-10-27T08:03:57+08:00 ] 117.132.196.41 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002133s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010371s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000641s ] --------------------------------------------------------------- [ 2022-10-27T08:04:06+08:00 ] 117.132.196.41 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=080301&v1=-00.527&v2=+00.001&v3=-00.473&v4=+00.040&v5=05.9&t=+11.2&h=57.3&rssi=+224&ccid=4600485905031430000099m9990000000100000000g6280,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002105s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010129s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000640s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='080301',`v1`=-0.527,`v2`=0.001,`v3`=-0.473,`v4`=0.04,`v5`=5.9,`t`=11.2,`h`=57.3,`rssi`=224,`ccid`='4600485905031430000099m9990000000100000000g6280,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666829046 WHERE `imei` = '868922055644013' [ RunTime:0.000577s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011404s ] [ 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' , '221027' , '080301' , -0.527 , 0.001 , -0.473 , 0.04 , 5.9 , 11.2 , 57.3 , 224 , '4600485905031430000099m9990000000100000000g6280,N,00E000=-00.000' , 0 , 0 , 1666829046 , 1666829046) [ RunTime:0.000692s ] --------------------------------------------------------------- [ 2022-10-27T09:03:57+08:00 ] 218.204.253.23 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002577s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010781s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000747s ] --------------------------------------------------------------- [ 2022-10-27T09:03:58+08:00 ] 39.144.3.33 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ 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.008792s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000676s ] --------------------------------------------------------------- [ 2022-10-27T09:04:05+08:00 ] 218.204.253.23 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221027&time=090301&v1=-00.971&v2=+00.078&v3=-00.983&v4=-00.040&v5=06.0&t=+13.0&h=53.4&rssi=+229&ccid=4600485905031420000099m9990000000032000000g9940,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ 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.009120s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000613s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221027',`time`='090301',`v1`=-0.971,`v2`=0.078,`v3`=-0.983,`v4`=-0.04,`v5`=6,`t`=13,`h`=53.4,`rssi`=229,`ccid`='4600485905031420000099m9990000000032000000g9940,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666832645 WHERE `imei` = '868922055643643' [ RunTime:0.000542s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009426s ] [ 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' , '221027' , '090301' , -0.971 , 0.078 , -0.983 , -0.04 , 6 , 13 , 53.4 , 229 , '4600485905031420000099m9990000000032000000g9940,N,00E000=-00.000' , 0 , 0 , 1666832645 , 1666832645) [ RunTime:0.000799s ] --------------------------------------------------------------- [ 2022-10-27T09:04:07+08:00 ] 39.144.3.33 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=090301&v1=-00.678&v2=+00.001&v3=-00.274&v4=+00.026&v5=05.9&t=+13.4&h=56.9&rssi=+225&ccid=4600485905031430000099m9990000000076000000g7580,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.010969s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000661s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='090301',`v1`=-0.678,`v2`=0.001,`v3`=-0.274,`v4`=0.026,`v5`=5.9,`t`=13.4,`h`=56.9,`rssi`=225,`ccid`='4600485905031430000099m9990000000076000000g7580,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666832647 WHERE `imei` = '868922055644013' [ RunTime:0.000503s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010595s ] [ 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' , '221027' , '090301' , -0.678 , 0.001 , -0.274 , 0.026 , 5.9 , 13.4 , 56.9 , 225 , '4600485905031430000099m9990000000076000000g7580,N,00E000=-00.000' , 0 , 0 , 1666832647 , 1666832647) [ RunTime:0.000487s ] --------------------------------------------------------------- [ 2022-10-27T09:16:39+08:00 ] 112.9.188.102 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002271s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010814s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000623s ] --------------------------------------------------------------- [ 2022-10-27T09:16:40+08:00 ] 112.9.188.102 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001448s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010215s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000730s ] --------------------------------------------------------------- [ 2022-10-27T09:16:52+08:00 ] 112.9.188.102 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002314s ] 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 COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000536s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000840s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000743s ] --------------------------------------------------------------- [ 2022-10-27T09:16:56+08:00 ] 112.9.188.102 GET /home/show/read/id/33/imei/868922055644013.html [ 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.009625s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010742s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000577s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002762s ] --------------------------------------------------------------- [ 2022-10-27T09:51:57+08:00 ] 112.9.188.102 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002159s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010780s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000676s ] --------------------------------------------------------------- [ 2022-10-27T09:51:59+08:00 ] 112.9.188.102 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001622s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010804s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000757s ] --------------------------------------------------------------- [ 2022-10-27T09:52:01+08:00 ] 112.9.188.102 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001692s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010660s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000485s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000660s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000614s ] --------------------------------------------------------------- [ 2022-10-27T09:52:03+08:00 ] 112.9.188.102 GET /home/show/read/id/32/imei/868922055643643.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001421s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009267s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000635s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011111s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000533s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001028s ] --------------------------------------------------------------- [ 2022-10-27T09:52:37+08:00 ] 112.9.188.102 GET /home/show/read/id/32/imei/868922055643643.html?page=2 [ 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.011129s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000610s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010090s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000456s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 10,10 [ RunTime:0.001015s ] --------------------------------------------------------------- [ 2022-10-27T09:52:47+08:00 ] 112.9.188.102 GET /home/show/read/id/32/imei/868922055643643.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001293s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010126s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000653s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010519s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000579s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 20,10 [ RunTime:0.001124s ] --------------------------------------------------------------- [ 2022-10-27T09:53:12+08:00 ] 112.9.188.102 GET /home/show/read/id/32/imei/868922055643643.html?page=2 [ 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.009255s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000656s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010414s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000489s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 10,10 [ RunTime:0.001166s ] --------------------------------------------------------------- [ 2022-10-27T09:54:06+08:00 ] 112.9.188.102 GET /home/show/read/id/32/imei/868922055643643.html?page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.001557s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011316s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000673s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009798s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000444s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001054s ] --------------------------------------------------------------- [ 2022-10-27T09:54:16+08:00 ] 112.9.188.102 GET /home/show/index.html [ 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.010735s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000715s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000635s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000559s ] --------------------------------------------------------------- [ 2022-10-27T09:54:17+08:00 ] 112.9.188.102 GET /home/show/read/id/33/imei/868922055644013.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001473s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010151s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000686s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009689s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000571s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001520s ] --------------------------------------------------------------- [ 2022-10-27T09:54:51+08:00 ] 112.9.188.102 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001428s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010278s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000493s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000656s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000607s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011483s ] [ 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.000479s ] [ 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.000492s ] --------------------------------------------------------------- [ 2022-10-27T09:54:55+08:00 ] 112.9.188.102 GET /home/map/index.html [ 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.009069s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000712s ] --------------------------------------------------------------- [ 2022-10-27T09:54:56+08:00 ] 112.9.188.102 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001529s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010027s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000439s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000592s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000516s ] --------------------------------------------------------------- [ 2022-10-27T09:55:05+08:00 ] 112.9.188.102 GET /home/show/edit/id/32.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001442s ] 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 `id` = 32 LIMIT 1 [ RunTime:0.000819s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009963s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` [ RunTime:0.000374s ] --------------------------------------------------------------- [ 2022-10-27T09:55:09+08:00 ] 112.9.188.102 POST /home/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002485s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012923s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `interval`=60,`gps`='120.00148,36.33808',`introduce`='

胶州变电站高压线旁边

2022.10.22

',`update_time`=1666835709 WHERE `id` = 32 [ RunTime:0.000911s ] --------------------------------------------------------------- [ 2022-10-27T09:55:11+08:00 ] 112.9.188.102 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001577s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010783s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000450s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000666s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000544s ] --------------------------------------------------------------- [ 2022-10-27T09:55:21+08:00 ] 112.9.188.102 GET /home/show/read/id/32/imei/868922055643643.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001694s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009894s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000746s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011474s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000515s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001231s ] --------------------------------------------------------------- [ 2022-10-27T10:03:58+08:00 ] 39.144.15.133 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002173s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009370s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000611s ] --------------------------------------------------------------- [ 2022-10-27T10:04:06+08:00 ] 39.144.15.133 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=100301&v1=-00.697&v2=+00.001&v3=+00.014&v4=+00.012&v5=06.0&t=+19.6&h=53.8&rssi=+226&ccid=4600485905031430000099m9990000000045000000g8000,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002007s ] 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` = '868922055644013' LIMIT 1 [ RunTime:0.000630s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='100301',`v1`=-0.697,`v2`=0.001,`v3`=0.014,`v4`=0.012,`v5`=6,`t`=19.6,`h`=53.8,`rssi`=226,`ccid`='4600485905031430000099m9990000000045000000g8000,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666836246 WHERE `imei` = '868922055644013' [ RunTime:0.000510s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010149s ] [ 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' , '221027' , '100301' , -0.697 , 0.001 , 0.014 , 0.012 , 6 , 19.6 , 53.8 , 226 , '4600485905031430000099m9990000000045000000g8000,N,00E000=-00.000' , 0 , 0 , 1666836246 , 1666836246) [ RunTime:0.000781s ] --------------------------------------------------------------- [ 2022-10-27T10:18:25+08:00 ] 27.223.154.40 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003154s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.012141s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000601s ] --------------------------------------------------------------- [ 2022-10-27T10:18:32+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001792s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011444s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000440s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000847s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000685s ] --------------------------------------------------------------- [ 2022-10-27T10:23:18+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002201s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011454s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000401s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000700s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000602s ] --------------------------------------------------------------- [ 2022-10-27T10:23:58+08:00 ] 27.223.154.40 GET /admin/show/read/id/32/imei/868922055643643.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001460s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010075s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000611s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009954s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000495s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001011s ] --------------------------------------------------------------- [ 2022-10-27T10:24:05+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001447s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010245s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000387s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000706s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000614s ] --------------------------------------------------------------- [ 2022-10-27T10:26:54+08:00 ] 27.223.154.40 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.002014s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010572s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000505s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000771s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000688s ] --------------------------------------------------------------- [ 2022-10-27T10:27:02+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.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.011414s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000738s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009204s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.002231s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.012299s ] --------------------------------------------------------------- [ 2022-10-27T10:27:56+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001526s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010361s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000330s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000640s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000615s ] --------------------------------------------------------------- [ 2022-10-27T10:28:05+08:00 ] 27.223.154.40 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001503s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008940s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000317s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000678s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000604s ] --------------------------------------------------------------- [ 2022-10-27T10:28:36+08:00 ] 39.144.1.171 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001393s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009686s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000674s ] --------------------------------------------------------------- [ 2022-10-27T10:28:37+08:00 ] 39.144.1.171 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666837716&v1=0.762773&v2=0.015125&v3=0.007766&v4=0.007916&v5=11.880000&t=19.377369&h=64.312553&rssi=19&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001586s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009362s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000589s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666837716,`v1`=0.762773,`v2`=0.015125,`v3`=0.007766,`v4`=0.007916,`v5`=11.88,`t`=19.377369,`h`=64.312553,`rssi`=19,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666837717 WHERE `imei` = '868922055677740' [ RunTime:0.000530s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010269s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666837716 , 0.762773 , 0.015125 , 0.007766 , 0.007916 , 11.88 , 19.377369 , 64.312553 , 19 , '89860426102071188504' , '460044618415254' , -0 , 1666837717) [ RunTime:0.000566s ] --------------------------------------------------------------- [ 2022-10-27T10:28:42+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001443s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009178s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000615s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009906s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000803s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.006718s ] --------------------------------------------------------------- [ 2022-10-27T10:38:06+08:00 ] 39.144.15.71 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002354s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010099s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000637s ] --------------------------------------------------------------- [ 2022-10-27T10:38:08+08:00 ] 39.144.15.71 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666838286&v1=0.762592&v2=0.016168&v3=0.007465&v4=0.759883&v5=11.880000&t=19.624046&h=63.625904&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001654s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010961s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000621s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666838286,`v1`=0.762592,`v2`=0.016168,`v3`=0.007465,`v4`=0.759883,`v5`=11.88,`t`=19.624046,`h`=63.625904,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666838288 WHERE `imei` = '868922055677740' [ RunTime:0.000549s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010675s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666838286 , 0.762592 , 0.016168 , 0.007465 , 0.759883 , 11.88 , 19.624046 , 63.625904 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1666838288) [ RunTime:0.000658s ] --------------------------------------------------------------- [ 2022-10-27T10:38:14+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001449s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009678s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011193s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000909s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.006846s ] --------------------------------------------------------------- [ 2022-10-27T10:42:30+08:00 ] 39.144.6.62 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001684s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009007s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000618s ] --------------------------------------------------------------- [ 2022-10-27T10:42:32+08:00 ] 39.144.6.62 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666838550&v1=0.762773&v2=0.013873&v3=0.007615&v4=0.007435&v5=11.880000&t=20.074499&h=61.825367&rssi=19&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001389s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010803s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000606s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666838550,`v1`=0.762773,`v2`=0.013873,`v3`=0.007615,`v4`=0.007435,`v5`=11.88,`t`=20.074499,`h`=61.825367,`rssi`=19,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666838552 WHERE `imei` = '868922055677740' [ RunTime:0.000455s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009724s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666838550 , 0.762773 , 0.013873 , 0.007615 , 0.007435 , 11.88 , 20.074499 , 61.825367 , 19 , '89860426102071188504' , '460044618415254' , -0 , 1666838552) [ RunTime:0.000485s ] --------------------------------------------------------------- [ 2022-10-27T10:42:38+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ 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.008722s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000653s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009926s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000925s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007447s ] --------------------------------------------------------------- [ 2022-10-27T10:42:43+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001798s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009587s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000607s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010215s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000875s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007316s ] --------------------------------------------------------------- [ 2022-10-27T10:44:58+08:00 ] 39.144.10.103 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002054s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010988s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000665s ] --------------------------------------------------------------- [ 2022-10-27T10:44:59+08:00 ] 39.144.10.103 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666838698&v1=0.762592&v2=0.013977&v3=0.007495&v4=0.759823&v5=11.880000&t=20.439152&h=60.772511&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001520s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011072s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000777s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666838698,`v1`=0.762592,`v2`=0.013977,`v3`=0.007495,`v4`=0.759823,`v5`=11.88,`t`=20.439152,`h`=60.772511,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666838699 WHERE `imei` = '868922055677740' [ RunTime:0.000468s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010729s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666838698 , 0.762592 , 0.013977 , 0.007495 , 0.759823 , 11.88 , 20.439152 , 60.772511 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1666838699) [ RunTime:0.000562s ] --------------------------------------------------------------- [ 2022-10-27T10:45:04+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001528s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010666s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000726s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009867s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000819s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.006766s ] --------------------------------------------------------------- [ 2022-10-27T10:45:06+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.015616s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010282s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010793s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000909s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007121s ] --------------------------------------------------------------- [ 2022-10-27T10:49:41+08:00 ] 117.132.195.109 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001779s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010247s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000772s ] --------------------------------------------------------------- [ 2022-10-27T10:49:42+08:00 ] 117.132.195.109 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666838981&v1=0.761990&v2=0.014916&v3=0.007465&v4=0.011348&v5=11.880000&t=20.632204&h=59.483139&rssi=26&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001784s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013124s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000952s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666838981,`v1`=0.76199,`v2`=0.014916,`v3`=0.007465,`v4`=0.011348,`v5`=11.88,`t`=20.632204,`h`=59.483139,`rssi`=26,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666838982 WHERE `imei` = '868922055677740' [ RunTime:0.000563s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010995s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666838981 , 0.76199 , 0.014916 , 0.007465 , 0.011348 , 11.88 , 20.632204 , 59.483139 , 26 , '89860426102071188504' , '460044618415254' , -0 , 1666838982) [ RunTime:0.000556s ] --------------------------------------------------------------- [ 2022-10-27T10:49:44+08:00 ] 117.132.195.109 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666838825&v1=0.800218&v2=3.466368&v3=0.007405&v4=0.007856&v5=12.060000&t=20.546402&h=59.795944&rssi=26&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001553s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010955s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000661s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666838825,`v1`=0.800218,`v2`=3.466368,`v3`=0.007405,`v4`=0.007856,`v5`=12.06,`t`=20.546402,`h`=59.795944,`rssi`=26,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666838984 WHERE `imei` = '868922055677740' [ RunTime:0.000485s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010602s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666838825 , 0.800218 , 3.466368 , 0.007405 , 0.007856 , 12.06 , 20.546402 , 59.795944 , 26 , '89860426102071188504' , '460044618415254' , -0 , 1666838984) [ RunTime:0.000531s ] --------------------------------------------------------------- [ 2022-10-27T10:49:46+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ 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.009418s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000635s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009073s ] [ 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.006707s ] --------------------------------------------------------------- [ 2022-10-27T10:52:06+08:00 ] 117.132.193.38 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001986s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009983s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000618s ] --------------------------------------------------------------- [ 2022-10-27T10:52:07+08:00 ] 117.132.193.38 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666839126&v1=0.007134&v2=10.233775&v3=0.007585&v4=0.007796&v5=11.880000&t=20.878880&h=58.857529&rssi=27&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001391s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010522s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000644s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666839126,`v1`=0.007134,`v2`=10.233775,`v3`=0.007585,`v4`=0.007796,`v5`=11.88,`t`=20.87888,`h`=58.857529,`rssi`=27,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666839127 WHERE `imei` = '868922055677740' [ RunTime:0.000464s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010147s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666839126 , 0.007134 , 10.233775 , 0.007585 , 0.007796 , 11.88 , 20.87888 , 58.857529 , 27 , '89860426102071188504' , '460044618415254' , -0 , 1666839127) [ RunTime:0.000470s ] --------------------------------------------------------------- [ 2022-10-27T10:52:34+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002175s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010425s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010930s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000840s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.006999s ] --------------------------------------------------------------- [ 2022-10-27T11:01:01+08:00 ] 221.178.125.91 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002443s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012177s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000685s ] --------------------------------------------------------------- [ 2022-10-27T11:01:03+08:00 ] 221.178.125.91 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666839661&v1=0.007194&v2=10.555252&v3=0.007254&v4=0.760004&v5=11.880000&t=19.849272&h=61.543079&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.002012s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010076s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000608s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666839661,`v1`=0.007194,`v2`=10.555252,`v3`=0.007254,`v4`=0.760004,`v5`=11.88,`t`=19.849272,`h`=61.543079,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666839663 WHERE `imei` = '868922055677740' [ RunTime:0.000503s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010292s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666839661 , 0.007194 , 10.555252 , 0.007254 , 0.760004 , 11.88 , 19.849272 , 61.543079 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1666839663) [ RunTime:0.000609s ] --------------------------------------------------------------- [ 2022-10-27T11:01:07+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001591s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010578s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010577s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000844s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.006958s ] --------------------------------------------------------------- [ 2022-10-27T11:02:15+08:00 ] 117.132.191.235 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681494 [ sql ] [ DB ] CONNECT:[ UseTime:0.001601s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008799s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681494' LIMIT 1 [ RunTime:0.000671s ] --------------------------------------------------------------- [ 2022-10-27T11:02:23+08:00 ] 117.132.191.235 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681494&date=221027&time=111111&v1=+00.007&v2=+00.273&v3=+00.008&v4=+00.009&v5=10.7&t=+19.8&h=60.3&rssi=+223&ccid=4600485905031400000099m9990000000024000000g0170,N,00E003=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001468s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009279s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681494' LIMIT 1 [ RunTime:0.000620s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681494',`date`='221027',`time`='111111',`v1`=0.007,`v2`=0.273,`v3`=0.008,`v4`=0.009,`v5`=10.7,`t`=19.8,`h`=60.3,`rssi`=223,`ccid`='4600485905031400000099m9990000000024000000g0170,N,00E003=-00.000',`a1`=0,`a2`=0,`update_time`=1666839743 WHERE `imei` = '868922055681494' [ RunTime:0.000498s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008860s ] [ 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' , '221027' , '111111' , 0.007 , 0.273 , 0.008 , 0.009 , 10.7 , 19.8 , 60.3 , 223 , '4600485905031400000099m9990000000024000000g0170,N,00E003=-00.000' , 0 , 0 , 1666839743 , 1666839743) [ RunTime:0.000508s ] --------------------------------------------------------------- [ 2022-10-27T11:03:57+08:00 ] 39.144.12.198 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.010472s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000689s ] --------------------------------------------------------------- [ 2022-10-27T11:04:06+08:00 ] 39.144.12.198 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=110301&v1=-00.687&v2=+00.001&v3=+00.016&v4=+00.012&v5=06.0&t=+22.6&h=54.4&rssi=+227&ccid=4600485905031430000099m9990000000044000000g7900,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001572s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009482s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000587s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='110301',`v1`=-0.687,`v2`=0.001,`v3`=0.016,`v4`=0.012,`v5`=6,`t`=22.6,`h`=54.4,`rssi`=227,`ccid`='4600485905031430000099m9990000000044000000g7900,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666839846 WHERE `imei` = '868922055644013' [ RunTime:0.000461s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011421s ] [ 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' , '221027' , '110301' , -0.687 , 0.001 , 0.016 , 0.012 , 6 , 22.6 , 54.4 , 227 , '4600485905031430000099m9990000000044000000g7900,N,00E000=-00.000' , 0 , 0 , 1666839846 , 1666839846) [ RunTime:0.000436s ] --------------------------------------------------------------- [ 2022-10-27T11:06:13+08:00 ] 117.132.194.250 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.001613s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008506s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000614s ] --------------------------------------------------------------- [ 2022-10-27T11:06:14+08:00 ] 117.132.194.250 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1666839973&v1=0.025254&v2=0.523418&v3=0.025254&v4=0.775535&v5=11.880000&t=19.870832&h=56.599182&rssi=26&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001568s ] 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` = '868922056976208' LIMIT 1 [ RunTime:0.000597s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1666839973,`v1`=0.025254,`v2`=0.523418,`v3`=0.025254,`v4`=0.775535,`v5`=11.88,`t`=19.870832,`h`=56.599182,`rssi`=26,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1666839974 WHERE `imei` = '868922056976208' [ RunTime:0.000497s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009741s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1666839973 , 0.025254 , 0.523418 , 0.025254 , 0.775535 , 11.88 , 19.870832 , 56.599182 , 26 , '898604650119C1053139' , '460048590503139' , -0 , 1666839974) [ RunTime:0.000427s ] --------------------------------------------------------------- [ 2022-10-27T11:06:36+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001604s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008138s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000307s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000732s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000658s ] --------------------------------------------------------------- [ 2022-10-27T11:06:40+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ 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.009265s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000596s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011627s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000480s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000685s ] --------------------------------------------------------------- [ 2022-10-27T11:06:44+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ 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.011760s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000667s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011019s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000499s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000716s ] --------------------------------------------------------------- [ 2022-10-27T11:07:57+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001739s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009760s ] [ 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.000752s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000649s ] --------------------------------------------------------------- [ 2022-10-27T11:08:24+08:00 ] 218.204.253.179 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.001461s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009301s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000591s ] --------------------------------------------------------------- [ 2022-10-27T11:08:26+08:00 ] 218.204.253.179 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1666840104&v1=0.783241&v2=0.611767&v3=0.771562&v4=0.025615&v5=11.880000&t=20.610865&h=54.417175&rssi=26&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001572s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009489s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000624s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1666840104,`v1`=0.783241,`v2`=0.611767,`v3`=0.771562,`v4`=0.025615,`v5`=11.88,`t`=20.610865,`h`=54.417175,`rssi`=26,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1666840106 WHERE `imei` = '868922056976208' [ RunTime:0.000527s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010146s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1666840104 , 0.783241 , 0.611767 , 0.771562 , 0.025615 , 11.88 , 20.610865 , 54.417175 , 26 , '898604650119C1053139' , '460048590503139' , -0 , 1666840106) [ RunTime:0.000534s ] --------------------------------------------------------------- [ 2022-10-27T11:08:29+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001622s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009381s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010210s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000519s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000711s ] --------------------------------------------------------------- [ 2022-10-27T11:10:25+08:00 ] 218.204.252.101 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002177s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008910s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000741s ] --------------------------------------------------------------- [ 2022-10-27T11:10:26+08:00 ] 218.204.252.101 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1666840225&v1=0.783061&v2=0.603840&v3=0.783392&v4=0.025555&v5=11.880000&t=20.954067&h=53.356689&rssi=26&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001487s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008799s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000610s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1666840225,`v1`=0.783061,`v2`=0.60384,`v3`=0.783392,`v4`=0.025555,`v5`=11.88,`t`=20.954067,`h`=53.356689,`rssi`=26,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1666840226 WHERE `imei` = '868922056976208' [ RunTime:0.000551s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010622s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1666840225 , 0.783061 , 0.60384 , 0.783392 , 0.025555 , 11.88 , 20.954067 , 53.356689 , 26 , '898604650119C1053139' , '460048590503139' , -0 , 1666840226) [ RunTime:0.000494s ] --------------------------------------------------------------- [ 2022-10-27T11:10:32+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001755s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009955s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000629s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010941s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000564s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000860s ] --------------------------------------------------------------- [ 2022-10-27T11:10:34+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ 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.008985s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000928s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011948s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000525s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001039s ] --------------------------------------------------------------- [ 2022-10-27T11:10:47+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001552s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009729s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000615s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010258s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000672s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000769s ] --------------------------------------------------------------- [ 2022-10-27T11:10:48+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001759s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011371s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010313s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000620s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000757s ] --------------------------------------------------------------- [ 2022-10-27T11:14:43+08:00 ] 39.144.10.110 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002630s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013127s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.001794s ] --------------------------------------------------------------- [ 2022-10-27T11:14:44+08:00 ] 39.144.10.110 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1666840483&v1=0.783121&v2=0.560656&v3=0.770960&v4=0.025676&v5=11.880000&t=20.600140&h=54.043335&rssi=25&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002099s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012744s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000981s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1666840483,`v1`=0.783121,`v2`=0.560656,`v3`=0.77096,`v4`=0.025676,`v5`=11.88,`t`=20.60014,`h`=54.043335,`rssi`=25,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1666840484 WHERE `imei` = '868922056976208' [ RunTime:0.000758s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012265s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1666840483 , 0.783121 , 0.560656 , 0.77096 , 0.025676 , 11.88 , 20.60014 , 54.043335 , 25 , '898604650119C1053139' , '460048590503139' , -0 , 1666840484) [ RunTime:0.000727s ] --------------------------------------------------------------- [ 2022-10-27T11:14:48+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001676s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012384s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000794s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012488s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000669s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000887s ] --------------------------------------------------------------- [ 2022-10-27T11:14:58+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001896s ] 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 `id` = 35 LIMIT 1 [ RunTime:0.000734s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011844s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000522s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000733s ] --------------------------------------------------------------- [ 2022-10-27T11:15:30+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001471s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011424s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000696s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010822s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000719s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001036s ] --------------------------------------------------------------- [ 2022-10-27T11:15:58+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001842s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010165s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000680s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009374s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000520s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000714s ] --------------------------------------------------------------- [ 2022-10-27T11:16:00+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001542s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009811s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000755s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011824s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000562s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000902s ] --------------------------------------------------------------- [ 2022-10-27T11:16:26+08:00 ] 221.178.126.90 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.001896s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011140s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000719s ] --------------------------------------------------------------- [ 2022-10-27T11:16:28+08:00 ] 221.178.126.90 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1666840586&v1=0.783121&v2=0.572130&v3=0.771051&v4=0.025555&v5=11.880000&t=21.039867&h=52.898926&rssi=25&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001573s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010179s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000609s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1666840586,`v1`=0.783121,`v2`=0.57213,`v3`=0.771051,`v4`=0.025555,`v5`=11.88,`t`=21.039867,`h`=52.898926,`rssi`=25,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1666840588 WHERE `imei` = '868922056976208' [ RunTime:0.000482s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010565s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1666840586 , 0.783121 , 0.57213 , 0.771051 , 0.025555 , 11.88 , 21.039867 , 52.898926 , 25 , '898604650119C1053139' , '460048590503139' , -0 , 1666840588) [ RunTime:0.000462s ] --------------------------------------------------------------- [ 2022-10-27T11:16:32+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ 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.010190s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000619s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009636s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000486s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000697s ] --------------------------------------------------------------- [ 2022-10-27T11:19:56+08:00 ] 39.144.11.56 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002065s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009306s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000595s ] --------------------------------------------------------------- [ 2022-10-27T11:19:57+08:00 ] 39.144.11.56 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1666840796&v1=0.783181&v2=0.568584&v3=0.024923&v4=0.025555&v5=11.880000&t=20.846817&h=53.211731&rssi=26&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001416s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009234s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000590s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1666840796,`v1`=0.783181,`v2`=0.568584,`v3`=0.024923,`v4`=0.025555,`v5`=11.88,`t`=20.846817,`h`=53.211731,`rssi`=26,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1666840797 WHERE `imei` = '868922056976208' [ RunTime:0.000459s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008899s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1666840796 , 0.783181 , 0.568584 , 0.024923 , 0.025555 , 11.88 , 20.846817 , 53.211731 , 26 , '898604650119C1053139' , '460048590503139' , -0 , 1666840797) [ RunTime:0.000456s ] --------------------------------------------------------------- [ 2022-10-27T11:20:01+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001744s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012041s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000668s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010860s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000607s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000835s ] --------------------------------------------------------------- [ 2022-10-27T11:21:24+08:00 ] 117.132.193.176 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.001688s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010615s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000655s ] --------------------------------------------------------------- [ 2022-10-27T11:21:25+08:00 ] 117.132.193.176 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1666840884&v1=0.783121&v2=0.579432&v3=0.024923&v4=0.025615&v5=11.880000&t=21.157845&h=52.097839&rssi=26&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ 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.009892s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000586s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1666840884,`v1`=0.783121,`v2`=0.579432,`v3`=0.024923,`v4`=0.025615,`v5`=11.88,`t`=21.157845,`h`=52.097839,`rssi`=26,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1666840885 WHERE `imei` = '868922056976208' [ RunTime:0.000464s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009891s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1666840884 , 0.783121 , 0.579432 , 0.024923 , 0.025615 , 11.88 , 21.157845 , 52.097839 , 26 , '898604650119C1053139' , '460048590503139' , -0 , 1666840885) [ RunTime:0.000439s ] --------------------------------------------------------------- [ 2022-10-27T11:21:43+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001769s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008857s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000686s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010398s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000517s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000877s ] --------------------------------------------------------------- [ 2022-10-27T11:23:24+08:00 ] 39.144.18.133 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.001688s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009633s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000615s ] --------------------------------------------------------------- [ 2022-10-27T11:23:26+08:00 ] 39.144.18.133 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1666841004&v1=0.782880&v2=0.615418&v3=0.024803&v4=0.025555&v5=11.880000&t=21.297270&h=51.922363&rssi=25&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001516s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009939s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000668s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1666841004,`v1`=0.78288,`v2`=0.615418,`v3`=0.024803,`v4`=0.025555,`v5`=11.88,`t`=21.29727,`h`=51.922363,`rssi`=25,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1666841006 WHERE `imei` = '868922056976208' [ RunTime:0.000505s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010834s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1666841004 , 0.78288 , 0.615418 , 0.024803 , 0.025555 , 11.88 , 21.29727 , 51.922363 , 25 , '898604650119C1053139' , '460048590503139' , -0 , 1666841006) [ RunTime:0.000471s ] --------------------------------------------------------------- [ 2022-10-27T11:25:09+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013539s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008406s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009174s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000481s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000706s ] --------------------------------------------------------------- [ 2022-10-27T11:25:27+08:00 ] 39.144.16.236 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ 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.010837s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000759s ] --------------------------------------------------------------- [ 2022-10-27T11:25:29+08:00 ] 39.144.16.236 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1666841127&v1=0.782820&v2=0.647753&v3=0.024863&v4=0.025495&v5=11.880000&t=21.383072&h=51.861328&rssi=25&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001700s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010219s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000844s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1666841127,`v1`=0.78282,`v2`=0.647753,`v3`=0.024863,`v4`=0.025495,`v5`=11.88,`t`=21.383072,`h`=51.861328,`rssi`=25,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1666841129 WHERE `imei` = '868922056976208' [ RunTime:0.000696s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011970s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1666841127 , 0.78282 , 0.647753 , 0.024863 , 0.025495 , 11.88 , 21.383072 , 51.861328 , 25 , '898604650119C1053139' , '460048590503139' , -0 , 1666841129) [ RunTime:0.000612s ] --------------------------------------------------------------- [ 2022-10-27T11:25:51+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ 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.010998s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000659s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009530s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000517s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000786s ] --------------------------------------------------------------- [ 2022-10-27T11:25:53+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001790s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010034s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009448s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000575s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000743s ] --------------------------------------------------------------- [ 2022-10-27T11:25:58+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001627s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010419s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000902s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010551s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000516s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001065s ] --------------------------------------------------------------- [ 2022-10-27T11:32:08+08:00 ] 39.144.15.116 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002321s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010163s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000711s ] --------------------------------------------------------------- [ 2022-10-27T11:32:12+08:00 ] 39.144.15.116 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1666841528&v1=0.783482&v2=0.680506&v3=0.024803&v4=0.025555&v5=11.880000&t=20.546515&h=54.218811&rssi=25&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001367s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009174s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.001057s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1666841528,`v1`=0.783482,`v2`=0.680506,`v3`=0.024803,`v4`=0.025555,`v5`=11.88,`t`=20.546515,`h`=54.218811,`rssi`=25,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1666841532 WHERE `imei` = '868922056976208' [ RunTime:0.000465s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008942s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1666841528 , 0.783482 , 0.680506 , 0.024803 , 0.025555 , 11.88 , 20.546515 , 54.218811 , 25 , '898604650119C1053139' , '460048590503139' , -0 , 1666841532) [ RunTime:0.000464s ] --------------------------------------------------------------- [ 2022-10-27T11:32:32+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002209s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011177s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000676s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010773s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000533s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000857s ] --------------------------------------------------------------- [ 2022-10-27T11:34:41+08:00 ] 39.144.6.0 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.001552s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009672s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000672s ] --------------------------------------------------------------- [ 2022-10-27T11:34:42+08:00 ] 39.144.6.0 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1666841681&v1=0.783181&v2=0.367999&v3=0.024923&v4=0.025736&v5=11.880000&t=21.125669&h=52.723450&rssi=25&ccid=898604650119C1053139&imsi=460048590503139&v6=-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.009780s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1666841681,`v1`=0.783181,`v2`=0.367999,`v3`=0.024923,`v4`=0.025736,`v5`=11.88,`t`=21.125669,`h`=52.72345,`rssi`=25,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1666841682 WHERE `imei` = '868922056976208' [ RunTime:0.001047s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009849s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1666841681 , 0.783181 , 0.367999 , 0.024923 , 0.025736 , 11.88 , 21.125669 , 52.72345 , 25 , '898604650119C1053139' , '460048590503139' , -0 , 1666841682) [ RunTime:0.000519s ] --------------------------------------------------------------- [ 2022-10-27T11:34:47+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001389s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011320s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000720s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009859s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000501s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000836s ] --------------------------------------------------------------- [ 2022-10-27T11:36:26+08:00 ] 117.132.192.196 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ 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.012956s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000647s ] --------------------------------------------------------------- [ 2022-10-27T11:36:27+08:00 ] 117.132.192.196 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1666841786&v1=0.783121&v2=0.345156&v3=0.024893&v4=0.025615&v5=11.880000&t=21.490322&h=51.922363&rssi=25&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001682s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009772s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000660s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1666841786,`v1`=0.783121,`v2`=0.345156,`v3`=0.024893,`v4`=0.025615,`v5`=11.88,`t`=21.490322,`h`=51.922363,`rssi`=25,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1666841787 WHERE `imei` = '868922056976208' [ RunTime:0.000461s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010145s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1666841786 , 0.783121 , 0.345156 , 0.024893 , 0.025615 , 11.88 , 21.490322 , 51.922363 , 25 , '898604650119C1053139' , '460048590503139' , -0 , 1666841787) [ RunTime:0.000522s ] --------------------------------------------------------------- [ 2022-10-27T11:38:26+08:00 ] 39.144.16.41 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.001863s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009828s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000692s ] --------------------------------------------------------------- [ 2022-10-27T11:38:28+08:00 ] 39.144.16.41 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1666841906&v1=0.783121&v2=0.327632&v3=0.024923&v4=0.025555&v5=11.880000&t=21.597572&h=51.746887&rssi=25&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001643s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010028s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000660s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1666841906,`v1`=0.783121,`v2`=0.327632,`v3`=0.024923,`v4`=0.025555,`v5`=11.88,`t`=21.597572,`h`=51.746887,`rssi`=25,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1666841907 WHERE `imei` = '868922056976208' [ RunTime:0.000566s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009723s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1666841906 , 0.783121 , 0.327632 , 0.024923 , 0.025555 , 11.88 , 21.597572 , 51.746887 , 25 , '898604650119C1053139' , '460048590503139' , -0 , 1666841908) [ RunTime:0.000754s ] --------------------------------------------------------------- [ 2022-10-27T11:38:40+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001615s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011322s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011849s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000497s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000740s ] --------------------------------------------------------------- [ 2022-10-27T11:45:01+08:00 ] 39.144.4.3 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002480s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009945s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000670s ] --------------------------------------------------------------- [ 2022-10-27T11:45:03+08:00 ] 39.144.4.3 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1666842301&v1=0.783602&v2=0.378013&v3=0.329930&v4=0.025555&v5=11.880000&t=20.771740&h=53.906006&rssi=25&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001786s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010916s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000621s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1666842301,`v1`=0.783602,`v2`=0.378013,`v3`=0.32993,`v4`=0.025555,`v5`=11.88,`t`=20.77174,`h`=53.906006,`rssi`=25,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1666842303 WHERE `imei` = '868922056976208' [ RunTime:0.000482s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009621s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1666842301 , 0.783602 , 0.378013 , 0.32993 , 0.025555 , 11.88 , 20.77174 , 53.906006 , 25 , '898604650119C1053139' , '460048590503139' , -0 , 1666842303) [ RunTime:0.000475s ] --------------------------------------------------------------- [ 2022-10-27T11:45:09+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ 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.009271s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000622s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009948s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000502s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000799s ] --------------------------------------------------------------- [ 2022-10-27T11:45:20+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001532s ] 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` = 35 LIMIT 1 [ RunTime:0.000899s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011761s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000561s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000821s ] --------------------------------------------------------------- [ 2022-10-27T11:46:54+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001785s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008932s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000617s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010789s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000496s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000764s ] --------------------------------------------------------------- [ 2022-10-27T11:47:35+08:00 ] 39.144.3.62 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.001687s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009676s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000645s ] --------------------------------------------------------------- [ 2022-10-27T11:47:36+08:00 ] 39.144.3.62 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1666842455&v1=0.783241&v2=0.350893&v3=0.329719&v4=0.025615&v5=11.880000&t=21.157845&h=52.815002&rssi=28&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001670s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009104s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1666842455,`v1`=0.783241,`v2`=0.350893,`v3`=0.329719,`v4`=0.025615,`v5`=11.88,`t`=21.157845,`h`=52.815002,`rssi`=28,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1666842456 WHERE `imei` = '868922056976208' [ RunTime:0.000461s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010564s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1666842455 , 0.783241 , 0.350893 , 0.329719 , 0.025615 , 11.88 , 21.157845 , 52.815002 , 28 , '898604650119C1053139' , '460048590503139' , -0 , 1666842456) [ RunTime:0.000484s ] --------------------------------------------------------------- [ 2022-10-27T11:47:38+08:00 ] 27.223.154.40 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002206s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010299s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000642s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008636s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000475s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000865s ] --------------------------------------------------------------- [ 2022-10-27T11:53:53+08:00 ] 39.144.14.194 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002120s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009840s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000623s ] --------------------------------------------------------------- [ 2022-10-27T11:53:54+08:00 ] 39.144.14.194 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666842833&v1=0.762111&v2=0.015438&v3=0.007706&v4=0.007796&v5=11.700000&t=21.061207&h=59.315292&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001580s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010685s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000762s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666842833,`v1`=0.762111,`v2`=0.015438,`v3`=0.007706,`v4`=0.007796,`v5`=11.7,`t`=21.061207,`h`=59.315292,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666842834 WHERE `imei` = '868922055677740' [ RunTime:0.000618s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011730s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666842833 , 0.762111 , 0.015438 , 0.007706 , 0.007796 , 11.7 , 21.061207 , 59.315292 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1666842834) [ RunTime:0.000573s ] --------------------------------------------------------------- [ 2022-10-27T11:54:24+08:00 ] 27.223.154.40 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002036s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009812s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000342s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000668s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000628s ] --------------------------------------------------------------- [ 2022-10-27T11:54:27+08:00 ] 27.223.154.40 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001611s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008643s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000379s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000645s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000608s ] --------------------------------------------------------------- [ 2022-10-27T11:54:29+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001482s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011150s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000694s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010362s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000948s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007460s ] --------------------------------------------------------------- [ 2022-10-27T11:54:36+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001910s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009757s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000636s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009931s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000822s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007054s ] --------------------------------------------------------------- [ 2022-10-27T12:00:10+08:00 ] 117.132.195.250 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002454s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009471s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000679s ] --------------------------------------------------------------- [ 2022-10-27T12:00:12+08:00 ] 117.132.195.250 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666843210&v1=0.762171&v2=0.014812&v3=0.007796&v4=0.008097&v5=11.880000&t=23.817553&h=53.227032&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001542s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014263s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000714s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666843210,`v1`=0.762171,`v2`=0.014812,`v3`=0.007796,`v4`=0.008097,`v5`=11.88,`t`=23.817553,`h`=53.227032,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666843212 WHERE `imei` = '868922055677740' [ RunTime:0.000598s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011491s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666843210 , 0.762171 , 0.014812 , 0.007796 , 0.008097 , 11.88 , 23.817553 , 53.227032 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1666843212) [ RunTime:0.000646s ] --------------------------------------------------------------- [ 2022-10-27T12:00:15+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001646s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011143s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000696s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010749s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000931s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007471s ] --------------------------------------------------------------- [ 2022-10-27T12:03:58+08:00 ] 117.132.195.60 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001750s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009147s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000647s ] --------------------------------------------------------------- [ 2022-10-27T12:04:07+08:00 ] 117.132.195.60 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=120301&v1=-00.705&v2=+00.001&v3=+00.016&v4=+00.013&v5=06.0&t=+23.3&h=55.0&rssi=+224&ccid=4600485905031430000099m9990000000044000000g8030,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001486s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009744s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000638s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='120301',`v1`=-0.705,`v2`=0.001,`v3`=0.016,`v4`=0.013,`v5`=6,`t`=23.3,`h`=55,`rssi`=224,`ccid`='4600485905031430000099m9990000000044000000g8030,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666843447 WHERE `imei` = '868922055644013' [ RunTime:0.000472s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008905s ] [ 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' , '221027' , '120301' , -0.705 , 0.001 , 0.016 , 0.013 , 6 , 23.3 , 55 , 224 , '4600485905031430000099m9990000000044000000g8030,N,00E000=-00.000' , 0 , 0 , 1666843447 , 1666843447) [ RunTime:0.000472s ] --------------------------------------------------------------- [ 2022-10-27T12:21:49+08:00 ] 223.104.186.27 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002531s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010564s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000728s ] --------------------------------------------------------------- [ 2022-10-27T12:21:53+08:00 ] 223.104.186.27 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001525s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009825s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000490s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000758s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000581s ] --------------------------------------------------------------- [ 2022-10-27T12:22:01+08:00 ] 223.104.186.27 GET /home/show/read/id/33/imei/868922055644013.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001633s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011601s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000766s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010424s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000543s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002077s ] --------------------------------------------------------------- [ 2022-10-27T12:22:08+08:00 ] 223.104.186.27 GET /home/show/read/id/33/imei/868922055644013.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001465s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009405s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000612s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010490s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000508s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001482s ] --------------------------------------------------------------- [ 2022-10-27T12:22:46+08:00 ] 223.104.186.27 GET /home/show/read/id/32/imei/868922055643643.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001598s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009911s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000723s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011854s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000480s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000962s ] --------------------------------------------------------------- [ 2022-10-27T12:22:55+08:00 ] 223.104.186.27 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001596s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009903s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000862s ] --------------------------------------------------------------- [ 2022-10-27T12:22:56+08:00 ] 223.104.186.27 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001598s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011328s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000728s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000734s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000605s ] --------------------------------------------------------------- [ 2022-10-27T12:22:59+08:00 ] 223.104.186.27 GET /home/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001465s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008867s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000892s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009815s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.002520s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.008506s ] --------------------------------------------------------------- [ 2022-10-27T13:03:58+08:00 ] 117.132.197.67 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002346s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011602s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000729s ] --------------------------------------------------------------- [ 2022-10-27T13:04:06+08:00 ] 117.132.197.67 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=130301&v1=-00.696&v2=+00.001&v3=+00.017&v4=+00.013&v5=06.0&t=+22.6&h=56.2&rssi=+226&ccid=4600485905031430000099m9990000000044000000g7980,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001443s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009142s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000613s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='130301',`v1`=-0.696,`v2`=0.001,`v3`=0.017,`v4`=0.013,`v5`=6,`t`=22.6,`h`=56.2,`rssi`=226,`ccid`='4600485905031430000099m9990000000044000000g7980,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666847046 WHERE `imei` = '868922055644013' [ RunTime:0.000536s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010216s ] [ 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' , '221027' , '130301' , -0.696 , 0.001 , 0.017 , 0.013 , 6 , 22.6 , 56.2 , 226 , '4600485905031430000099m9990000000044000000g7980,N,00E000=-00.000' , 0 , 0 , 1666847046 , 1666847046) [ RunTime:0.000557s ] --------------------------------------------------------------- [ 2022-10-27T14:03:58+08:00 ] 218.204.253.29 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002347s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010259s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000626s ] --------------------------------------------------------------- [ 2022-10-27T14:04:06+08:00 ] 218.204.253.29 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=140301&v1=-00.683&v2=+00.001&v3=+00.017&v4=+00.012&v5=06.0&t=+21.3&h=56.9&rssi=+226&ccid=4600485905031430000099m9990000000043000000g7870,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001393s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008930s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000617s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='140301',`v1`=-0.683,`v2`=0.001,`v3`=0.017,`v4`=0.012,`v5`=6,`t`=21.3,`h`=56.9,`rssi`=226,`ccid`='4600485905031430000099m9990000000043000000g7870,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666850646 WHERE `imei` = '868922055644013' [ RunTime:0.000555s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009841s ] [ 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' , '221027' , '140301' , -0.683 , 0.001 , 0.017 , 0.012 , 6 , 21.3 , 56.9 , 226 , '4600485905031430000099m9990000000043000000g7870,N,00E000=-00.000' , 0 , 0 , 1666850646 , 1666850646) [ RunTime:0.000618s ] --------------------------------------------------------------- [ 2022-10-27T14:45:30+08:00 ] 117.132.191.240 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002257s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010972s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000886s ] --------------------------------------------------------------- [ 2022-10-27T14:45:31+08:00 ] 117.132.191.240 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666853130&v1=2.109643&v2=0.015125&v3=11.698921&v4=0.007977&v5=11.880000&t=26.080544&h=43.697910&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001724s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008885s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666853130,`v1`=2.109643,`v2`=0.015125,`v3`=11.698921,`v4`=0.007977,`v5`=11.88,`t`=26.080544,`h`=43.69791,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666853131 WHERE `imei` = '868922055677740' [ RunTime:0.000644s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011729s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666853130 , 2.109643 , 0.015125 , 11.698921 , 0.007977 , 11.88 , 26.080544 , 43.69791 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1666853131) [ RunTime:0.000741s ] --------------------------------------------------------------- [ 2022-10-27T14:45:46+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001910s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011075s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000734s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010475s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000968s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007344s ] --------------------------------------------------------------- [ 2022-10-27T14:46:57+08:00 ] 218.204.252.19 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ 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.010423s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000645s ] --------------------------------------------------------------- [ 2022-10-27T14:46:58+08:00 ] 218.204.252.19 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666853217&v1=1.355328&v2=0.016063&v3=0.008097&v4=0.008037&v5=11.880000&t=26.777674&h=43.491917&rssi=19&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001563s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010083s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000708s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666853217,`v1`=1.355328,`v2`=0.016063,`v3`=0.008097,`v4`=0.008037,`v5`=11.88,`t`=26.777674,`h`=43.491917,`rssi`=19,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666853218 WHERE `imei` = '868922055677740' [ RunTime:0.000433s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010483s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666853217 , 1.355328 , 0.016063 , 0.008097 , 0.008037 , 11.88 , 26.777674 , 43.491917 , 19 , '89860426102071188504' , '460044618415254' , -0 , 1666853218) [ RunTime:0.000491s ] --------------------------------------------------------------- [ 2022-10-27T14:47:02+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001414s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008973s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000908s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.023111s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001526s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.011510s ] --------------------------------------------------------------- [ 2022-10-27T14:49:23+08:00 ] 39.144.17.170 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001602s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011115s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000587s ] --------------------------------------------------------------- [ 2022-10-27T14:49:24+08:00 ] 39.144.17.170 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666853363&v1=2.299275&v2=0.015125&v3=177.234955&v4=0.009783&v5=11.880000&t=26.681149&h=42.667942&rssi=19&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&en [ sql ] [ DB ] CONNECT:[ UseTime:0.015814s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009467s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000852s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666853363,`v1`=2.299275,`v2`=0.015125,`v3`=177.234955,`v4`=0.009783,`v5`=11.88,`t`=26.681149,`h`=42.667942,`rssi`=19,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666853364 WHERE `imei` = '868922055677740' [ RunTime:0.000542s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012217s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666853363 , 2.299275 , 0.015125 , 177.234955 , 0.009783 , 11.88 , 26.681149 , 42.667942 , 19 , '89860426102071188504' , '460044618415254' , -0 , 1666853364) [ RunTime:0.000615s ] --------------------------------------------------------------- [ 2022-10-27T14:49:28+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001693s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011265s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000723s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011741s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000862s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.006968s ] --------------------------------------------------------------- [ 2022-10-27T14:53:59+08:00 ] 39.144.15.84 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002208s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010826s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000697s ] --------------------------------------------------------------- [ 2022-10-27T14:54:00+08:00 ] 39.144.15.84 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666853639&v1=2.301202&v2=0.016168&v3=176.978867&v4=0.010204&v5=11.880000&t=27.367554&h=42.194920&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&en [ sql ] [ DB ] CONNECT:[ UseTime:0.001641s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008478s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000598s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666853639,`v1`=2.301202,`v2`=0.016168,`v3`=176.978867,`v4`=0.010204,`v5`=11.88,`t`=27.367554,`h`=42.19492,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666853640 WHERE `imei` = '868922055677740' [ RunTime:0.000450s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010279s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666853639 , 2.301202 , 0.016168 , 176.978867 , 0.010204 , 11.88 , 27.367554 , 42.19492 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1666853640) [ RunTime:0.000473s ] --------------------------------------------------------------- [ 2022-10-27T14:54:03+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001520s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009562s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000690s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009585s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000823s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007237s ] --------------------------------------------------------------- [ 2022-10-27T14:54:05+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001488s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011107s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000646s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010352s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000854s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.006734s ] --------------------------------------------------------------- [ 2022-10-27T14:54:08+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001599s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009496s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000597s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010217s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000826s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007274s ] --------------------------------------------------------------- [ 2022-10-27T14:58:19+08:00 ] 39.144.12.46 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ 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.008221s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000603s ] --------------------------------------------------------------- [ 2022-10-27T14:58:20+08:00 ] 39.144.12.46 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666853899&v1=2.299937&v2=0.014707&v3=177.112991&v4=0.009421&v5=11.880000&t=27.367554&h=42.225437&rssi=17&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&en [ sql ] [ DB ] CONNECT:[ UseTime:0.001432s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.017698s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000592s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666853899,`v1`=2.299937,`v2`=0.014707,`v3`=177.112991,`v4`=0.009421,`v5`=11.88,`t`=27.367554,`h`=42.225437,`rssi`=17,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666853900 WHERE `imei` = '868922055677740' [ RunTime:0.000473s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009947s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666853899 , 2.299937 , 0.014707 , 177.112991 , 0.009421 , 11.88 , 27.367554 , 42.225437 , 17 , '89860426102071188504' , '460044618415254' , -0 , 1666853900) [ RunTime:0.000487s ] --------------------------------------------------------------- [ 2022-10-27T14:58:24+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001790s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007474s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000600s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010592s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000842s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007326s ] --------------------------------------------------------------- [ 2022-10-27T14:58:26+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001458s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010670s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000603s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010435s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000844s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007391s ] --------------------------------------------------------------- [ 2022-10-27T14:58:27+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001486s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010127s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009139s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000798s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007142s ] --------------------------------------------------------------- [ 2022-10-27T15:03:56+08:00 ] 221.178.125.202 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002151s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011018s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000613s ] --------------------------------------------------------------- [ 2022-10-27T15:03:57+08:00 ] 221.178.126.221 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001372s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009733s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000634s ] --------------------------------------------------------------- [ 2022-10-27T15:04:04+08:00 ] 221.178.125.202 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221027&time=150301&v1=-00.981&v2=+00.071&v3=-00.987&v4=-00.042&v5=06.2&t=+19.6&h=53.5&rssi=+230&ccid=4600485905031420000099m9990000000027000001g0040,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001459s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012558s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221027',`time`='150301',`v1`=-0.981,`v2`=0.071,`v3`=-0.987,`v4`=-0.042,`v5`=6.2,`t`=19.6,`h`=53.5,`rssi`=230,`ccid`='4600485905031420000099m9990000000027000001g0040,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666854244 WHERE `imei` = '868922055643643' [ RunTime:0.000516s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010079s ] [ 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' , '221027' , '150301' , -0.981 , 0.071 , -0.987 , -0.042 , 6.2 , 19.6 , 53.5 , 230 , '4600485905031420000099m9990000000027000001g0040,N,00E000=-00.000' , 0 , 0 , 1666854244 , 1666854244) [ RunTime:0.000524s ] --------------------------------------------------------------- [ 2022-10-27T15:04:06+08:00 ] 221.178.126.221 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=150301&v1=-00.659&v2=+00.001&v3=+00.017&v4=+00.011&v5=06.0&t=+20.1&h=57.4&rssi=+225&ccid=4600485905031430000099m9990000000042000000g7650,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.016241s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011062s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000636s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='150301',`v1`=-0.659,`v2`=0.001,`v3`=0.017,`v4`=0.011,`v5`=6,`t`=20.1,`h`=57.4,`rssi`=225,`ccid`='4600485905031430000099m9990000000042000000g7650,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666854246 WHERE `imei` = '868922055644013' [ RunTime:0.000511s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010689s ] [ 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' , '221027' , '150301' , -0.659 , 0.001 , 0.017 , 0.011 , 6 , 20.1 , 57.4 , 225 , '4600485905031430000099m9990000000042000000g7650,N,00E000=-00.000' , 0 , 0 , 1666854246 , 1666854246) [ RunTime:0.000455s ] --------------------------------------------------------------- [ 2022-10-27T15:15:28+08:00 ] 218.204.252.204 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002170s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011429s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000631s ] --------------------------------------------------------------- [ 2022-10-27T15:15:30+08:00 ] 218.204.252.204 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666854928&v1=2.302225&v2=0.016481&v3=177.172409&v4=0.009181&v5=11.880000&t=25.029486&h=46.925148&rssi=17&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&en [ sql ] [ DB ] CONNECT:[ UseTime:0.001767s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011000s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000685s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666854928,`v1`=2.302225,`v2`=0.016481,`v3`=177.172409,`v4`=0.009181,`v5`=11.88,`t`=25.029486,`h`=46.925148,`rssi`=17,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666854930 WHERE `imei` = '868922055677740' [ RunTime:0.000573s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011226s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666854928 , 2.302225 , 0.016481 , 177.172409 , 0.009181 , 11.88 , 25.029486 , 46.925148 , 17 , '89860426102071188504' , '460044618415254' , -0 , 1666854930) [ RunTime:0.000721s ] --------------------------------------------------------------- [ 2022-10-27T15:15:32+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001563s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011593s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000756s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009242s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000965s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.008174s ] --------------------------------------------------------------- [ 2022-10-27T15:17:26+08:00 ] 39.144.12.132 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ 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.008930s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000773s ] --------------------------------------------------------------- [ 2022-10-27T15:17:27+08:00 ] 39.144.12.132 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1666855046&v1=2.302586&v2=0.014290&v3=175.052734&v4=0.009722&v5=11.880000&t=25.715891&h=45.681557&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&en [ sql ] [ DB ] CONNECT:[ UseTime:0.001721s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009223s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000606s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1666855046,`v1`=2.302586,`v2`=0.01429,`v3`=175.052734,`v4`=0.009722,`v5`=11.88,`t`=25.715891,`h`=45.681557,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1666855047 WHERE `imei` = '868922055677740' [ RunTime:0.000477s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010181s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1666855046 , 2.302586 , 0.01429 , 175.052734 , 0.009722 , 11.88 , 25.715891 , 45.681557 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1666855047) [ RunTime:0.000455s ] --------------------------------------------------------------- [ 2022-10-27T15:17:32+08:00 ] 27.223.154.40 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001680s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008729s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000593s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009374s ] [ 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.007432s ] --------------------------------------------------------------- [ 2022-10-27T16:03:57+08:00 ] 117.132.192.108 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002471s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011186s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000642s ] --------------------------------------------------------------- [ 2022-10-27T16:03:58+08:00 ] 223.104.255.215 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ 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.008329s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000597s ] --------------------------------------------------------------- [ 2022-10-27T16:04:05+08:00 ] 117.132.192.108 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221027&time=160301&v1=-00.982&v2=+00.081&v3=-00.986&v4=-00.043&v5=06.2&t=+18.9&h=53.9&rssi=+229&ccid=4600485905031420000099m9990000000024000001g0050,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.009111s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000732s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221027',`time`='160301',`v1`=-0.982,`v2`=0.081,`v3`=-0.986,`v4`=-0.043,`v5`=6.2,`t`=18.9,`h`=53.9,`rssi`=229,`ccid`='4600485905031420000099m9990000000024000001g0050,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666857845 WHERE `imei` = '868922055643643' [ RunTime:0.000626s ] [ 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' , '221027' , '160301' , -0.982 , 0.081 , -0.986 , -0.043 , 6.2 , 18.9 , 53.9 , 229 , '4600485905031420000099m9990000000024000001g0050,N,00E000=-00.000' , 0 , 0 , 1666857845 , 1666857845) [ RunTime:0.000694s ] --------------------------------------------------------------- [ 2022-10-27T16:04:07+08:00 ] 223.104.255.215 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=160301&v1=-00.656&v2=+00.001&v3=+00.018&v4=+00.010&v5=06.0&t=+19.1&h=57.7&rssi=+227&ccid=4600485905031430000099m9990000000041000000g7640,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001450s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010107s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000604s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='160301',`v1`=-0.656,`v2`=0.001,`v3`=0.018,`v4`=0.01,`v5`=6,`t`=19.1,`h`=57.7,`rssi`=227,`ccid`='4600485905031430000099m9990000000041000000g7640,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666857847 WHERE `imei` = '868922055644013' [ RunTime:0.000480s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010682s ] [ 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' , '221027' , '160301' , -0.656 , 0.001 , 0.018 , 0.01 , 6 , 19.1 , 57.7 , 227 , '4600485905031430000099m9990000000041000000g7640,N,00E000=-00.000' , 0 , 0 , 1666857847 , 1666857847) [ RunTime:0.000475s ] --------------------------------------------------------------- [ 2022-10-27T17:03:56+08:00 ] 117.132.191.156 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002373s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011468s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000742s ] --------------------------------------------------------------- [ 2022-10-27T17:03:58+08:00 ] 221.178.126.119 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001752s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010113s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000693s ] --------------------------------------------------------------- [ 2022-10-27T17:04:05+08:00 ] 117.132.191.156 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221027&time=170301&v1=-00.982&v2=+00.060&v3=-00.986&v4=-00.043&v5=05.7&t=+17.7&h=54.4&rssi=+231&ccid=4600485905031420000099m9990000000023000001g0060,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001607s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008629s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000656s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221027',`time`='170301',`v1`=-0.982,`v2`=0.06,`v3`=-0.986,`v4`=-0.043,`v5`=5.7,`t`=17.7,`h`=54.4,`rssi`=231,`ccid`='4600485905031420000099m9990000000023000001g0060,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666861445 WHERE `imei` = '868922055643643' [ RunTime:0.000602s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011388s ] [ 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' , '221027' , '170301' , -0.982 , 0.06 , -0.986 , -0.043 , 5.7 , 17.7 , 54.4 , 231 , '4600485905031420000099m9990000000023000001g0060,N,00E000=-00.000' , 0 , 0 , 1666861445 , 1666861445) [ RunTime:0.000597s ] --------------------------------------------------------------- [ 2022-10-27T17:04:06+08:00 ] 221.178.126.119 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=170301&v1=-00.640&v2=+00.001&v3=+00.018&v4=+00.009&v5=06.0&t=+18.0&h=58.1&rssi=+225&ccid=4600485905031430000099m9990000000040000000g7440,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001473s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009889s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000687s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='170301',`v1`=-0.64,`v2`=0.001,`v3`=0.018,`v4`=0.009,`v5`=6,`t`=18,`h`=58.1,`rssi`=225,`ccid`='4600485905031430000099m9990000000040000000g7440,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666861446 WHERE `imei` = '868922055644013' [ RunTime:0.000505s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010577s ] [ 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' , '221027' , '170301' , -0.64 , 0.001 , 0.018 , 0.009 , 6 , 18 , 58.1 , 225 , '4600485905031430000099m9990000000040000000g7440,N,00E000=-00.000' , 0 , 0 , 1666861446 , 1666861446) [ RunTime:0.000507s ] --------------------------------------------------------------- [ 2022-10-27T18:03:57+08:00 ] 39.144.11.56 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002112s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010253s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000631s ] --------------------------------------------------------------- [ 2022-10-27T18:03:58+08:00 ] 39.144.17.44 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001595s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009656s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000885s ] --------------------------------------------------------------- [ 2022-10-27T18:04:06+08:00 ] 39.144.17.44 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=180301&v1=-00.633&v2=+00.001&v3=+00.017&v4=+00.009&v5=06.0&t=+16.5&h=58.5&rssi=+228&ccid=4600485905031430000099m9990000000040000000g7380,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001592s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009532s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000605s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='180301',`v1`=-0.633,`v2`=0.001,`v3`=0.017,`v4`=0.009,`v5`=6,`t`=16.5,`h`=58.5,`rssi`=228,`ccid`='4600485905031430000099m9990000000040000000g7380,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666865046 WHERE `imei` = '868922055644013' [ RunTime:0.000527s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010543s ] [ 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' , '221027' , '180301' , -0.633 , 0.001 , 0.017 , 0.009 , 6 , 16.5 , 58.5 , 228 , '4600485905031430000099m9990000000040000000g7380,N,00E000=-00.000' , 0 , 0 , 1666865046 , 1666865046) [ RunTime:0.000586s ] --------------------------------------------------------------- [ 2022-10-27T19:03:57+08:00 ] 39.144.13.117 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002325s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.018474s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000771s ] --------------------------------------------------------------- [ 2022-10-27T19:03:57+08:00 ] 218.204.252.33 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001706s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010057s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000617s ] --------------------------------------------------------------- [ 2022-10-27T19:04:05+08:00 ] 39.144.13.117 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221027&time=190301&v1=-00.985&v2=+00.048&v3=-00.986&v4=-00.043&v5=06.2&t=+15.0&h=55.0&rssi=+229&ccid=4600485905031420000099m9990000000019000001g0090,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001523s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011287s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000607s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221027',`time`='190301',`v1`=-0.985,`v2`=0.048,`v3`=-0.986,`v4`=-0.043,`v5`=6.2,`t`=15,`h`=55,`rssi`=229,`ccid`='4600485905031420000099m9990000000019000001g0090,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666868645 WHERE `imei` = '868922055643643' [ RunTime:0.000809s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011289s ] [ 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' , '221027' , '190301' , -0.985 , 0.048 , -0.986 , -0.043 , 6.2 , 15 , 55 , 229 , '4600485905031420000099m9990000000019000001g0090,N,00E000=-00.000' , 0 , 0 , 1666868645 , 1666868645) [ RunTime:0.000631s ] --------------------------------------------------------------- [ 2022-10-27T19:04:06+08:00 ] 218.204.252.33 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=190301&v1=-00.654&v2=+00.001&v3=+00.015&v4=+00.009&v5=06.0&t=+15.4&h=58.6&rssi=+226&ccid=4600485905031430000099m9990000000040000000g7530,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001707s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009327s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000589s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='190301',`v1`=-0.654,`v2`=0.001,`v3`=0.015,`v4`=0.009,`v5`=6,`t`=15.4,`h`=58.6,`rssi`=226,`ccid`='4600485905031430000099m9990000000040000000g7530,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666868646 WHERE `imei` = '868922055644013' [ RunTime:0.000652s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010083s ] [ 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' , '221027' , '190301' , -0.654 , 0.001 , 0.015 , 0.009 , 6 , 15.4 , 58.6 , 226 , '4600485905031430000099m9990000000040000000g7530,N,00E000=-00.000' , 0 , 0 , 1666868646 , 1666868646) [ RunTime:0.000575s ] --------------------------------------------------------------- [ 2022-10-27T19:44:17+08:00 ] 39.144.18.111 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002403s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010547s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000621s ] --------------------------------------------------------------- [ 2022-10-27T19:44:18+08:00 ] 39.144.18.111 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1666871057&v1=0.026097&v2=0.051528&v3=0.022635&v4=-0.002197&v5=6.660000&t=13.285623&h=65.243286&rssi=21&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001535s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009987s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000688s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1666871057,`v1`=0.026097,`v2`=0.051528,`v3`=0.022635,`v4`=-0.002197,`v5`=6.66,`t`=13.285623,`h`=65.243286,`rssi`=21,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1666871058 WHERE `imei` = '868922055644211' [ RunTime:0.000511s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009442s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1666871057 , 0.026097 , 0.051528 , 0.022635 , -0.002197 , 6.66 , 13.285623 , 65.243286 , 21 , '89860426102071188505' , '460044618415255' , -0 , 1666871058) [ RunTime:0.000543s ] --------------------------------------------------------------- [ 2022-10-27T20:03:58+08:00 ] 117.132.193.56 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002281s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009567s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000583s ] --------------------------------------------------------------- [ 2022-10-27T20:03:58+08:00 ] 39.144.18.30 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001674s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009388s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000600s ] --------------------------------------------------------------- [ 2022-10-27T20:04:06+08:00 ] 117.132.193.56 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221027&time=200301&v1=-00.986&v2=+00.038&v3=-00.986&v4=-00.042&v5=06.2&t=+13.8&h=55.2&rssi=+231&ccid=4600485905031420000099m9990000000019000001g0090,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ 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.009177s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000765s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221027',`time`='200301',`v1`=-0.986,`v2`=0.038,`v3`=-0.986,`v4`=-0.042,`v5`=6.2,`t`=13.8,`h`=55.2,`rssi`=231,`ccid`='4600485905031420000099m9990000000019000001g0090,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666872246 WHERE `imei` = '868922055643643' [ RunTime:0.000733s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013702s ] [ 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' , '221027' , '200301' , -0.986 , 0.038 , -0.986 , -0.042 , 6.2 , 13.8 , 55.2 , 231 , '4600485905031420000099m9990000000019000001g0090,N,00E000=-00.000' , 0 , 0 , 1666872246 , 1666872246) [ RunTime:0.000657s ] --------------------------------------------------------------- [ 2022-10-27T20:04:07+08:00 ] 39.144.18.30 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=200301&v1=-00.668&v2=+00.001&v3=-00.016&v4=+00.011&v5=05.9&t=+14.5&h=58.8&rssi=+225&ccid=4600485905031430000099m9990000000045000000g7660,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001322s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008546s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000591s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='200301',`v1`=-0.668,`v2`=0.001,`v3`=-0.016,`v4`=0.011,`v5`=5.9,`t`=14.5,`h`=58.8,`rssi`=225,`ccid`='4600485905031430000099m9990000000045000000g7660,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666872247 WHERE `imei` = '868922055644013' [ RunTime:0.000455s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009190s ] [ 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' , '221027' , '200301' , -0.668 , 0.001 , -0.016 , 0.011 , 5.9 , 14.5 , 58.8 , 225 , '4600485905031430000099m9990000000045000000g7660,N,00E000=-00.000' , 0 , 0 , 1666872247 , 1666872247) [ RunTime:0.000429s ] --------------------------------------------------------------- [ 2022-10-27T21:03:58+08:00 ] 39.144.13.42 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002322s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010437s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2022-10-27T21:03:58+08:00 ] 221.178.127.154 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001499s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009290s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000642s ] --------------------------------------------------------------- [ 2022-10-27T21:04:06+08:00 ] 39.144.13.42 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221027&time=210301&v1=-00.987&v2=+00.035&v3=-00.986&v4=-00.042&v5=06.2&t=+12.6&h=55.3&rssi=+229&ccid=4600485905031420000099m9990000000015000001g0100,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001460s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010690s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000677s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221027',`time`='210301',`v1`=-0.987,`v2`=0.035,`v3`=-0.986,`v4`=-0.042,`v5`=6.2,`t`=12.6,`h`=55.3,`rssi`=229,`ccid`='4600485905031420000099m9990000000015000001g0100,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666875846 WHERE `imei` = '868922055643643' [ RunTime:0.000562s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011547s ] [ 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' , '221027' , '210301' , -0.987 , 0.035 , -0.986 , -0.042 , 6.2 , 12.6 , 55.3 , 229 , '4600485905031420000099m9990000000015000001g0100,N,00E000=-00.000' , 0 , 0 , 1666875846 , 1666875846) [ RunTime:0.000606s ] --------------------------------------------------------------- [ 2022-10-27T21:04:06+08:00 ] 221.178.127.154 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=210301&v1=-00.644&v2=+00.001&v3=+00.001&v4=+00.009&v5=05.9&t=+13.3&h=59.0&rssi=+224&ccid=4600485905031430000099m9990000000042000000g7380,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.010276s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000676s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='210301',`v1`=-0.644,`v2`=0.001,`v3`=0.001,`v4`=0.009,`v5`=5.9,`t`=13.3,`h`=59,`rssi`=224,`ccid`='4600485905031430000099m9990000000042000000g7380,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666875846 WHERE `imei` = '868922055644013' [ RunTime:0.000628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010462s ] [ 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' , '221027' , '210301' , -0.644 , 0.001 , 0.001 , 0.009 , 5.9 , 13.3 , 59 , 224 , '4600485905031430000099m9990000000042000000g7380,N,00E000=-00.000' , 0 , 0 , 1666875846 , 1666875846) [ RunTime:0.000527s ] --------------------------------------------------------------- [ 2022-10-27T22:03:57+08:00 ] 117.132.195.190 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002501s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011078s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000737s ] --------------------------------------------------------------- [ 2022-10-27T22:03:58+08:00 ] 39.144.6.175 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002199s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011737s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000958s ] --------------------------------------------------------------- [ 2022-10-27T22:04:06+08:00 ] 117.132.195.190 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221027&time=220301&v1=-00.989&v2=+00.043&v3=-00.985&v4=-00.043&v5=06.2&t=+11.7&h=55.4&rssi=+231&ccid=4600485905031420000099m9990000000014000001g0120,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001347s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009863s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000736s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221027',`time`='220301',`v1`=-0.989,`v2`=0.043,`v3`=-0.985,`v4`=-0.043,`v5`=6.2,`t`=11.7,`h`=55.4,`rssi`=231,`ccid`='4600485905031420000099m9990000000014000001g0120,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666879446 WHERE `imei` = '868922055643643' [ RunTime:0.000635s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009649s ] [ 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' , '221027' , '220301' , -0.989 , 0.043 , -0.985 , -0.043 , 6.2 , 11.7 , 55.4 , 231 , '4600485905031420000099m9990000000014000001g0120,N,00E000=-00.000' , 0 , 0 , 1666879446 , 1666879446) [ RunTime:0.000569s ] --------------------------------------------------------------- [ 2022-10-27T22:04:06+08:00 ] 39.144.6.175 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=220301&v1=-00.642&v2=+00.001&v3=-00.279&v4=+00.021&v5=05.9&t=+12.4&h=59.0&rssi=+226&ccid=4600485905031430000099m9990000000063000000g7330,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001370s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008803s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000610s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='220301',`v1`=-0.642,`v2`=0.001,`v3`=-0.279,`v4`=0.021,`v5`=5.9,`t`=12.4,`h`=59,`rssi`=226,`ccid`='4600485905031430000099m9990000000063000000g7330,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666879446 WHERE `imei` = '868922055644013' [ RunTime:0.000472s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009197s ] [ 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' , '221027' , '220301' , -0.642 , 0.001 , -0.279 , 0.021 , 5.9 , 12.4 , 59 , 226 , '4600485905031430000099m9990000000063000000g7330,N,00E000=-00.000' , 0 , 0 , 1666879446 , 1666879446) [ RunTime:0.000412s ] --------------------------------------------------------------- [ 2022-10-27T22:05:51+08:00 ] 39.144.2.210 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002004s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010302s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000646s ] --------------------------------------------------------------- [ 2022-10-27T22:05:59+08:00 ] 39.144.2.210 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221027&time=220501&v1=-01.279&v2=+00.024&v3=-01.122&v4=-00.763&v5=06.0&t=+12.3&h=81.5&rssi=+221&imsi=460044618415249&v6=-00.000&a1=00.184&a2=01.294&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001648s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010344s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000615s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221027',`time`='220501',`v1`=-1.279,`v2`=0.024,`v3`=-1.122,`v4`=-0.763,`v5`=6,`t`=12.3,`h`=81.5,`rssi`=221,`imsi`='460044618415249',`v6`=-0,`a1`=0.184,`a2`=1.294,`update_time`=1666879559 WHERE `imei` = '868922055684076' [ RunTime:0.000483s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010557s ] [ 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' , '221027' , '220501' , -1.279 , 0.024 , -1.122 , -0.763 , 6 , 12.3 , 81.5 , 221 , '460044618415249' , -0 , 0.184 , 1.294 , 1666879559 , 1666879559) [ RunTime:0.000525s ] --------------------------------------------------------------- [ 2022-10-27T23:03:57+08:00 ] 117.132.192.60 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002638s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012076s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000697s ] --------------------------------------------------------------- [ 2022-10-27T23:03:58+08:00 ] 39.144.11.42 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001567s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009737s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000625s ] --------------------------------------------------------------- [ 2022-10-27T23:04:06+08:00 ] 117.132.192.60 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221027&time=230301&v1=-00.626&v2=+00.001&v3=-00.097&v4=+00.012&v5=05.9&t=+11.6&h=59.1&rssi=+228&ccid=4600485905031430000099m9990000000052000000g7140,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001601s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009548s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000829s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221027',`time`='230301',`v1`=-0.626,`v2`=0.001,`v3`=-0.097,`v4`=0.012,`v5`=5.9,`t`=11.6,`h`=59.1,`rssi`=228,`ccid`='4600485905031430000099m9990000000052000000g7140,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666883046 WHERE `imei` = '868922055644013' [ RunTime:0.000540s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010420s ] [ 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' , '221027' , '230301' , -0.626 , 0.001 , -0.097 , 0.012 , 5.9 , 11.6 , 59.1 , 228 , '4600485905031430000099m9990000000052000000g7140,N,00E000=-00.000' , 0 , 0 , 1666883046 , 1666883046) [ RunTime:0.000653s ] --------------------------------------------------------------- [ 2022-10-27T23:04:07+08:00 ] 39.144.11.42 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221027&time=230301&v1=-00.989&v2=+00.042&v3=-00.985&v4=-00.042&v5=06.0&t=+10.8&h=55.5&rssi=+229&ccid=4600485905031420000099m9990000000012000001g0130,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.009929s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000593s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221027',`time`='230301',`v1`=-0.989,`v2`=0.042,`v3`=-0.985,`v4`=-0.042,`v5`=6,`t`=10.8,`h`=55.5,`rssi`=229,`ccid`='4600485905031420000099m9990000000012000001g0130,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666883047 WHERE `imei` = '868922055643643' [ RunTime:0.000420s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009256s ] [ 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' , '221027' , '230301' , -0.989 , 0.042 , -0.985 , -0.042 , 6 , 10.8 , 55.5 , 229 , '4600485905031420000099m9990000000012000001g0130,N,00E000=-00.000' , 0 , 0 , 1666883047 , 1666883047) [ RunTime:0.000470s ]