--------------------------------------------------------------- [ 2023-06-28T00:09:23+08:00 ] 39.144.16.16 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002701s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.038286s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000718s ] --------------------------------------------------------------- [ 2023-06-28T00:09:25+08:00 ] 39.144.16.16 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1687882163&v1=0.007916&v2=0.015751&v3=0.005960&v4=-0.015742&v5=12.420000&t=26.059214&h=81.417603&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001653s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009841s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000751s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1687882163,`v1`=0.007916,`v2`=0.015751,`v3`=0.00596,`v4`=-0.015742,`v5`=12.42,`t`=26.059214,`h`=81.417603,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1687882165 WHERE `imei` = '868922055644021' [ RunTime:0.000650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010786s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1687882163 , 0.007916 , 0.015751 , 0.00596 , -0.015742 , 12.42 , 26.059214 , 81.417603 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1687882165) [ RunTime:0.001308s ] --------------------------------------------------------------- [ 2023-06-28T00:29:24+08:00 ] 111.55.141.191 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002504s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012727s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000750s ] --------------------------------------------------------------- [ 2023-06-28T00:29:25+08:00 ] 111.55.141.191 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1687883364&v1=0.021401&v2=0.013143&v3=0.018903&v4=-0.006231&v5=12.420000&t=26.145014&h=78.922791&rssi=27&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001652s ] 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` = '868922055680850' LIMIT 1 [ RunTime:0.000650s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1687883364,`v1`=0.021401,`v2`=0.013143,`v3`=0.018903,`v4`=-0.006231,`v5`=12.42,`t`=26.145014,`h`=78.922791,`rssi`=27,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1687883365 WHERE `imei` = '868922055680850' [ RunTime:0.000725s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010898s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1687883364 , 0.021401 , 0.013143 , 0.018903 , -0.006231 , 12.42 , 26.145014 , 78.922791 , 27 , '898604650119C1078510' , '460048590708510' , -0 , 1687883365) [ RunTime:0.001774s ] --------------------------------------------------------------- [ 2023-06-28T02:03:54+08:00 ] 223.104.255.44 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002593s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011986s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000738s ] --------------------------------------------------------------- [ 2023-06-28T02:03:55+08:00 ] 39.144.12.178 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001642s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011249s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000705s ] --------------------------------------------------------------- [ 2023-06-28T02:04:02+08:00 ] 223.104.255.44 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230628&time=020301&v1=-00.741&v2=+00.006&v3=-00.466&v4=+00.340&v5=06.2&t=+21.7&h=59.5&rssi=+227&ccid=4600485905031420000099m9990000000543000000g8680,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001554s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008680s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000664s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230628',`time`='020301',`v1`=-0.741,`v2`=0.006,`v3`=-0.466,`v4`=0.34,`v5`=6.2,`t`=21.7,`h`=59.5,`rssi`=227,`ccid`='4600485905031420000099m9990000000543000000g8680,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687889042 WHERE `imei` = '868922055643643' [ RunTime:0.000596s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011908s ] [ 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' , '230628' , '020301' , -0.741 , 0.006 , -0.466 , 0.34 , 6.2 , 21.7 , 59.5 , 227 , '4600485905031420000099m9990000000543000000g8680,N,00E000=-00.000' , 0 , 0 , 1687889042 , 1687889042) [ RunTime:0.000609s ] --------------------------------------------------------------- [ 2023-06-28T02:04:03+08:00 ] 39.144.12.178 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230628&time=020301&v1=-00.237&v2=+00.001&v3=-00.200&v4=-00.007&v5=06.0&t=+21.8&h=62.9&rssi=+223&ccid=4600485905031430000099m9990000000015000000g2350,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001708s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008625s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230628',`time`='020301',`v1`=-0.237,`v2`=0.001,`v3`=-0.2,`v4`=-0.007,`v5`=6,`t`=21.8,`h`=62.9,`rssi`=223,`ccid`='4600485905031430000099m9990000000015000000g2350,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687889043 WHERE `imei` = '868922055644013' [ RunTime:0.000545s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011486s ] [ 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' , '230628' , '020301' , -0.237 , 0.001 , -0.2 , -0.007 , 6 , 21.8 , 62.9 , 223 , '4600485905031430000099m9990000000015000000g2350,N,00E000=-00.000' , 0 , 0 , 1687889043 , 1687889043) [ RunTime:0.000511s ] --------------------------------------------------------------- [ 2023-06-28T11:48:28+08:00 ] 39.144.5.32 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.003199s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013247s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001361s ] --------------------------------------------------------------- [ 2023-06-28T11:48:29+08:00 ] 39.144.5.32 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1687924108&v1=0.030672&v2=0.014082&v3=0.039582&v4=0.001355&v5=12.240000&t=27.625078&h=79.159302&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001702s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010471s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000707s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1687924108,`v1`=0.030672,`v2`=0.014082,`v3`=0.039582,`v4`=0.001355,`v5`=12.24,`t`=27.625078,`h`=79.159302,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1687924109 WHERE `imei` = '868922055678110' [ RunTime:0.000681s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015602s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1687924108 , 0.030672 , 0.014082 , 0.039582 , 0.001355 , 12.24 , 27.625078 , 79.159302 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1687924109) [ RunTime:0.001187s ] --------------------------------------------------------------- [ 2023-06-28T14:03:54+08:00 ] 39.144.7.143 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003433s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012663s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001703s ] --------------------------------------------------------------- [ 2023-06-28T14:03:54+08:00 ] 39.144.6.172 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002111s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010157s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000719s ] --------------------------------------------------------------- [ 2023-06-28T14:04:02+08:00 ] 39.144.7.143 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230628&time=140301&v1=-01.433&v2=+00.024&v3=-01.127&v4=-00.052&v5=06.4&t=+36.4&h=56.7&rssi=+228&ccid=4600485905031420000099m9990000000318000001g4380,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002629s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012163s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000688s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230628',`time`='140301',`v1`=-1.433,`v2`=0.024,`v3`=-1.127,`v4`=-0.052,`v5`=6.4,`t`=36.4,`h`=56.7,`rssi`=228,`ccid`='4600485905031420000099m9990000000318000001g4380,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687932242 WHERE `imei` = '868922055643643' [ RunTime:0.000589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012096s ] [ 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' , '230628' , '140301' , -1.433 , 0.024 , -1.127 , -0.052 , 6.4 , 36.4 , 56.7 , 228 , '4600485905031420000099m9990000000318000001g4380,N,00E000=-00.000' , 0 , 0 , 1687932242 , 1687932242) [ RunTime:0.000730s ] --------------------------------------------------------------- [ 2023-06-28T14:04:03+08:00 ] 39.144.6.172 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230628&time=140301&v1=-00.620&v2=+00.002&v3=-00.067&v4=-00.005&v5=06.2&t=+35.2&h=60.7&rssi=+225&ccid=4600485905031430000099m9990000000064000000g6360,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002378s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011923s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000696s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230628',`time`='140301',`v1`=-0.62,`v2`=0.002,`v3`=-0.067,`v4`=-0.005,`v5`=6.2,`t`=35.2,`h`=60.7,`rssi`=225,`ccid`='4600485905031430000099m9990000000064000000g6360,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687932243 WHERE `imei` = '868922055644013' [ RunTime:0.000523s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010854s ] [ 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' , '230628' , '140301' , -0.62 , 0.002 , -0.067 , -0.005 , 6.2 , 35.2 , 60.7 , 225 , '4600485905031430000099m9990000000064000000g6360,N,00E000=-00.000' , 0 , 0 , 1687932243 , 1687932243) [ RunTime:0.000538s ] --------------------------------------------------------------- [ 2023-06-28T15:15:22+08:00 ] 117.132.192.8 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002828s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013048s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000747s ] --------------------------------------------------------------- [ 2023-06-28T15:15:23+08:00 ] 117.132.192.8 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1687936522&v1=0.017067&v2=0.014082&v3=0.015682&v4=-0.011589&v5=12.240000&t=28.161333&h=78.182739&rssi=29&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001697s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010302s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000695s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1687936522,`v1`=0.017067,`v2`=0.014082,`v3`=0.015682,`v4`=-0.011589,`v5`=12.24,`t`=28.161333,`h`=78.182739,`rssi`=29,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1687936523 WHERE `imei` = '868922055684548' [ RunTime:0.000633s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011165s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1687936522 , 0.017067 , 0.014082 , 0.015682 , -0.011589 , 12.24 , 28.161333 , 78.182739 , 29 , '898604650119C1053137' , '460048590503137' , -0 , 1687936523) [ RunTime:0.000617s ] --------------------------------------------------------------- [ 2023-06-28T17:26:03+08:00 ] 117.132.195.228 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002327s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012091s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000685s ] --------------------------------------------------------------- [ 2023-06-28T17:26:04+08:00 ] 117.132.195.228 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1687944363&v1=0.018452&v2=0.013664&v3=0.015171&v4=-0.000030&v5=12.240000&t=27.861031&h=79.044861&rssi=28&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.183772,35.985172&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002178s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012191s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000710s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1687944363,`v1`=0.018452,`v2`=0.013664,`v3`=0.015171,`v4`=-3.0E-5,`v5`=12.24,`t`=27.861031,`h`=79.044861,`rssi`=28,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.183772,35.985172',`update_time`=1687944364 WHERE `imei` = '868922055647586' [ RunTime:0.000848s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011385s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055647586' , 1687944363 , 0.018452 , 0.013664 , 0.015171 , -3.0E-5 , 12.24 , 27.861031 , 79.044861 , 28 , '898604650119C1078512' , '460048590708512' , -0 , '120.183772,35.985172' , 1687944364) [ RunTime:0.001200s ] --------------------------------------------------------------- [ 2023-06-28T18:07:00+08:00 ] 39.144.11.61 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002246s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010663s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000748s ] --------------------------------------------------------------- [ 2023-06-28T18:07:01+08:00 ] 39.144.11.61 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1687946820&v1=0.027783&v2=0.011787&v3=0.030853&v4=0.015682&v5=12.240000&t=27.710878&h=77.106995&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184179,35.984500&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002540s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012063s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000772s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1687946820,`v1`=0.027783,`v2`=0.011787,`v3`=0.030853,`v4`=0.015682,`v5`=12.24,`t`=27.710878,`h`=77.106995,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184179,35.984500',`update_time`=1687946821 WHERE `imei` = '868922056976208' [ RunTime:0.001100s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012240s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922056976208' , 1687946820 , 0.027783 , 0.011787 , 0.030853 , 0.015682 , 12.24 , 27.710878 , 77.106995 , 27 , '898604650119C1053139' , '460048590503139' , -0 , '120.184179,35.984500' , 1687946821) [ RunTime:0.001227s ] --------------------------------------------------------------- [ 2023-06-28T18:15:21+08:00 ] 39.144.10.55 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002474s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012683s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000732s ] --------------------------------------------------------------- [ 2023-06-28T18:15:23+08:00 ] 39.144.10.55 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1687947321&v1=0.021161&v2=0.012413&v3=0.017880&v4=-0.006833&v5=12.420000&t=27.721603&h=79.243225&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002025s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009896s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000857s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1687947321,`v1`=0.021161,`v2`=0.012413,`v3`=0.01788,`v4`=-0.006833,`v5`=12.42,`t`=27.721603,`h`=79.243225,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1687947323 WHERE `imei` = '868922055684209' [ RunTime:0.000654s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010881s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1687947321 , 0.021161 , 0.012413 , 0.01788 , -0.006833 , 12.42 , 27.721603 , 79.243225 , 27 , '898604650119C1078511' , '460048590708511' , -0 , 1687947323) [ RunTime:0.002267s ] --------------------------------------------------------------- [ 2023-06-28T18:40:20+08:00 ] 39.144.10.91 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002875s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011705s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.001085s ] --------------------------------------------------------------- [ 2023-06-28T18:40:22+08:00 ] 39.144.10.91 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1687948820&v1=0.018993&v2=0.014395&v3=0.017428&v4=-0.004786&v5=12.420000&t=27.582178&h=84.065002&rssi=25&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002370s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010036s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000756s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1687948820,`v1`=0.018993,`v2`=0.014395,`v3`=0.017428,`v4`=-0.004786,`v5`=12.42,`t`=27.582178,`h`=84.065002,`rssi`=25,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1687948822 WHERE `imei` = '868922055683920' [ RunTime:0.000584s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011473s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1687948820 , 0.018993 , 0.014395 , 0.017428 , -0.004786 , 12.42 , 27.582178 , 84.065002 , 25 , '89860426102071188500' , '460044618415250' , -0 , 1687948822) [ RunTime:0.000565s ] --------------------------------------------------------------- [ 2023-06-28T21:22:22+08:00 ] 111.55.136.144 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002884s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011960s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000773s ] --------------------------------------------------------------- [ 2023-06-28T21:22:23+08:00 ] 111.55.136.144 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1687958542&v1=0.032057&v2=0.015333&v3=0.029890&v4=0.007916&v5=12.420000&t=27.625078&h=82.485718&rssi=20&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.184875,35.985206&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001574s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011218s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000669s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1687958542,`v1`=0.032057,`v2`=0.015333,`v3`=0.02989,`v4`=0.007916,`v5`=12.42,`t`=27.625078,`h`=82.485718,`rssi`=20,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.184875,35.985206',`update_time`=1687958543 WHERE `imei` = '868922055683912' [ RunTime:0.000650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011527s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683912' , 1687958542 , 0.032057 , 0.015333 , 0.02989 , 0.007916 , 12.42 , 27.625078 , 82.485718 , 20 , '898604650119C1053138' , '460048590503138' , -0 , '120.184875,35.985206' , 1687958543) [ RunTime:0.001367s ] --------------------------------------------------------------- [ 2023-06-28T21:31:16+08:00 ] 117.132.198.173 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002300s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011934s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000714s ] --------------------------------------------------------------- [ 2023-06-28T21:31:18+08:00 ] 117.132.198.173 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1687959076&v1=0.019595&v2=0.012934&v3=0.017428&v4=-0.017007&v5=12.420000&t=27.635803&h=83.454651&rssi=28&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.185112,35.986464&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001982s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010373s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000692s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1687959076,`v1`=0.019595,`v2`=0.012934,`v3`=0.017428,`v4`=-0.017007,`v5`=12.42,`t`=27.635803,`h`=83.454651,`rssi`=28,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.185112,35.986464',`update_time`=1687959077 WHERE `imei` = '868922055683771' [ RunTime:0.000560s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011202s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683771' , 1687959076 , 0.019595 , 0.012934 , 0.017428 , -0.017007 , 12.42 , 27.635803 , 83.454651 , 28 , '898604650119C1053136' , '460048590503136' , -0 , '120.185112,35.986464' , 1687959078) [ RunTime:0.000567s ] --------------------------------------------------------------- [ 2023-06-28T22:00:50+08:00 ] 117.132.194.107 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002748s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010185s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000668s ] --------------------------------------------------------------- [ 2023-06-28T22:00:58+08:00 ] 117.132.194.107 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230628&time=220001&v1=-01.211&v2=+00.024&v3=-01.128&v4=-00.599&v5=06.0&t=+25.3&h=77.3&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.101&a2=01.246&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001918s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009800s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000818s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230628',`time`='220001',`v1`=-1.211,`v2`=0.024,`v3`=-1.128,`v4`=-0.599,`v5`=6,`t`=25.3,`h`=77.3,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.101,`a2`=1.246,`update_time`=1687960858 WHERE `imei` = '868922055684076' [ RunTime:0.000649s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010527s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '230628' , '220001' , -1.211 , 0.024 , -1.128 , -0.599 , 6 , 25.3 , 77.3 , 227 , '460044618415249' , -0 , 0.101 , 1.246 , 1687960858 , 1687960858) [ RunTime:0.000614s ]