--------------------------------------------------------------- [ 2023-06-21T00:02:24+08:00 ] 111.55.138.198 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002438s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012793s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000691s ] --------------------------------------------------------------- [ 2023-06-21T00:02:26+08:00 ] 111.55.138.198 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1687276944&v1=0.007736&v2=0.015333&v3=0.005117&v4=-0.015923&v5=12.420000&t=24.686401&h=81.356567&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002158s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010819s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000731s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1687276944,`v1`=0.007736,`v2`=0.015333,`v3`=0.005117,`v4`=-0.015923,`v5`=12.42,`t`=24.686401,`h`=81.356567,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1687276946 WHERE `imei` = '868922055644021' [ RunTime:0.000714s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011636s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1687276944 , 0.007736 , 0.015333 , 0.005117 , -0.015923 , 12.42 , 24.686401 , 81.356567 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1687276946) [ RunTime:0.001313s ] --------------------------------------------------------------- [ 2023-06-21T00:22:24+08:00 ] 223.104.255.188 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.003130s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011437s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000688s ] --------------------------------------------------------------- [ 2023-06-21T00:22:25+08:00 ] 223.104.255.188 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1687278144&v1=0.021281&v2=0.013664&v3=0.018452&v4=-0.006652&v5=12.240000&t=24.707851&h=79.212708&rssi=26&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001915s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010410s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000651s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1687278144,`v1`=0.021281,`v2`=0.013664,`v3`=0.018452,`v4`=-0.006652,`v5`=12.24,`t`=24.707851,`h`=79.212708,`rssi`=26,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1687278145 WHERE `imei` = '868922055680850' [ RunTime:0.000628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012026s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1687278144 , 0.021281 , 0.013664 , 0.018452 , -0.006652 , 12.24 , 24.707851 , 79.212708 , 26 , '898604650119C1078510' , '460048590708510' , -0 , 1687278145) [ RunTime:0.000651s ] --------------------------------------------------------------- [ 2023-06-21T02:03:54+08:00 ] 39.144.5.163 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002445s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011849s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000724s ] --------------------------------------------------------------- [ 2023-06-21T02:03:54+08:00 ] 39.144.10.199 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001847s ] 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 `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000661s ] --------------------------------------------------------------- [ 2023-06-21T02:04:03+08:00 ] 39.144.5.163 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230621&time=020301&v1=-01.379&v2=+00.014&v3=-00.932&v4=-00.045&v5=06.2&t=+19.5&h=59.8&rssi=+227&ccid=4600485905031420000099m9990000000454000001g3880,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001912s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009711s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230621',`time`='020301',`v1`=-1.379,`v2`=0.014,`v3`=-0.932,`v4`=-0.045,`v5`=6.2,`t`=19.5,`h`=59.8,`rssi`=227,`ccid`='4600485905031420000099m9990000000454000001g3880,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687284243 WHERE `imei` = '868922055643643' [ RunTime:0.000639s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010917s ] [ 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' , '230621' , '020301' , -1.379 , 0.014 , -0.932 , -0.045 , 6.2 , 19.5 , 59.8 , 227 , '4600485905031420000099m9990000000454000001g3880,N,00E000=-00.000' , 0 , 0 , 1687284243 , 1687284243) [ RunTime:0.001860s ] --------------------------------------------------------------- [ 2023-06-21T02:04:03+08:00 ] 39.144.10.199 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230621&time=020301&v1=-00.471&v2=+00.001&v3=-00.217&v4=+00.001&v5=06.0&t=+19.7&h=63.0&rssi=+222&ccid=4600485905031430000099m9990000000034000000g4860,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001399s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010320s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000631s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230621',`time`='020301',`v1`=-0.471,`v2`=0.001,`v3`=-0.217,`v4`=0.001,`v5`=6,`t`=19.7,`h`=63,`rssi`=222,`ccid`='4600485905031430000099m9990000000034000000g4860,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687284243 WHERE `imei` = '868922055644013' [ RunTime:0.000518s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010909s ] [ 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' , '230621' , '020301' , -0.471 , 0.001 , -0.217 , 0.001 , 6 , 19.7 , 63 , 222 , '4600485905031430000099m9990000000034000000g4860,N,00E000=-00.000' , 0 , 0 , 1687284243 , 1687284243) [ RunTime:0.000507s ] --------------------------------------------------------------- [ 2023-06-21T11:41:28+08:00 ] 117.132.196.143 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.003156s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013414s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001369s ] --------------------------------------------------------------- [ 2023-06-21T11:41:30+08:00 ] 117.132.196.143 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1687318888&v1=0.030732&v2=0.014395&v3=0.036151&v4=0.001415&v5=12.240000&t=27.442751&h=79.029602&rssi=30&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001662s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011008s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000721s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1687318888,`v1`=0.030732,`v2`=0.014395,`v3`=0.036151,`v4`=0.001415,`v5`=12.24,`t`=27.442751,`h`=79.029602,`rssi`=30,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1687318890 WHERE `imei` = '868922055678110' [ RunTime:0.000681s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011743s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1687318888 , 0.030732 , 0.014395 , 0.036151 , 0.001415 , 12.24 , 27.442751 , 79.029602 , 30 , '898604650119C1078513' , '460048590708513' , -0 , 1687318890) [ RunTime:0.001285s ] --------------------------------------------------------------- [ 2023-06-21T14:03:54+08:00 ] 39.144.3.16 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002305s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012642s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001288s ] --------------------------------------------------------------- [ 2023-06-21T14:03:55+08:00 ] 117.132.196.36 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001897s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009755s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2023-06-21T14:04:03+08:00 ] 39.144.3.16 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230621&time=140301&v1=-01.378&v2=+00.024&v3=-00.929&v4=-00.045&v5=06.4&t=+37.6&h=54.5&rssi=+228&ccid=4600485905031420000099m9990000000451000001g3840,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ 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.011659s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000693s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230621',`time`='140301',`v1`=-1.378,`v2`=0.024,`v3`=-0.929,`v4`=-0.045,`v5`=6.4,`t`=37.6,`h`=54.5,`rssi`=228,`ccid`='4600485905031420000099m9990000000451000001g3840,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687327443 WHERE `imei` = '868922055643643' [ RunTime:0.000616s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011437s ] [ 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' , '230621' , '140301' , -1.378 , 0.024 , -0.929 , -0.045 , 6.4 , 37.6 , 54.5 , 228 , '4600485905031420000099m9990000000451000001g3840,N,00E000=-00.000' , 0 , 0 , 1687327443 , 1687327443) [ RunTime:0.000626s ] --------------------------------------------------------------- [ 2023-06-21T14:04:04+08:00 ] 117.132.196.36 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230621&time=140301&v1=-00.495&v2=+00.001&v3=+00.017&v4=+00.002&v5=06.2&t=+37.1&h=58.6&rssi=+221&ccid=4600485905031430000099m9990000000051000000g5220,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ 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.010290s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000923s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230621',`time`='140301',`v1`=-0.495,`v2`=0.001,`v3`=0.017,`v4`=0.002,`v5`=6.2,`t`=37.1,`h`=58.6,`rssi`=221,`ccid`='4600485905031430000099m9990000000051000000g5220,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687327444 WHERE `imei` = '868922055644013' [ RunTime:0.000535s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011794s ] [ 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' , '230621' , '140301' , -0.495 , 0.001 , 0.017 , 0.002 , 6.2 , 37.1 , 58.6 , 221 , '4600485905031430000099m9990000000051000000g5220,N,00E000=-00.000' , 0 , 0 , 1687327444 , 1687327444) [ RunTime:0.000536s ] --------------------------------------------------------------- [ 2023-06-21T15:08:22+08:00 ] 39.144.2.127 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002312s ] 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` = '868922055684548' LIMIT 1 [ RunTime:0.000696s ] --------------------------------------------------------------- [ 2023-06-21T15:08:23+08:00 ] 39.144.2.127 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1687331302&v1=0.017067&v2=0.013977&v3=0.015261&v4=-0.011829&v5=12.240000&t=30.638830&h=77.091736&rssi=29&ccid=898604650119C1053137&imsi=460048590503137&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.009491s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000704s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1687331302,`v1`=0.017067,`v2`=0.013977,`v3`=0.015261,`v4`=-0.011829,`v5`=12.24,`t`=30.63883,`h`=77.091736,`rssi`=29,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1687331303 WHERE `imei` = '868922055684548' [ RunTime:0.000632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011791s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1687331302 , 0.017067 , 0.013977 , 0.015261 , -0.011829 , 12.24 , 30.63883 , 77.091736 , 29 , '898604650119C1053137' , '460048590503137' , -0 , 1687331303) [ RunTime:0.000645s ] --------------------------------------------------------------- [ 2023-06-21T17:20:22+08:00 ] 39.144.7.38 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002668s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013073s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000742s ] --------------------------------------------------------------- [ 2023-06-21T17:20:23+08:00 ] 39.144.7.38 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1687339222&v1=0.018452&v2=0.013560&v3=0.016194&v4=-0.000090&v5=12.240000&t=31.110735&h=78.190369&rssi=27&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.185032,35.986671&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002153s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012390s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000677s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1687339222,`v1`=0.018452,`v2`=0.01356,`v3`=0.016194,`v4`=-9.0E-5,`v5`=12.24,`t`=31.110735,`h`=78.190369,`rssi`=27,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.185032,35.986671',`update_time`=1687339223 WHERE `imei` = '868922055647586' [ RunTime:0.000739s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012275s ] [ 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' , 1687339222 , 0.018452 , 0.01356 , 0.016194 , -9.0E-5 , 12.24 , 31.110735 , 78.190369 , 27 , '898604650119C1078512' , '460048590708512' , -0 , '120.185032,35.986671' , 1687339223) [ RunTime:0.000639s ] --------------------------------------------------------------- [ 2023-06-21T18:00:23+08:00 ] 39.144.14.175 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002866s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012922s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000786s ] --------------------------------------------------------------- [ 2023-06-21T18:00:25+08:00 ] 39.144.14.175 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1687341623&v1=0.027542&v2=0.013039&v3=0.028926&v4=0.015502&v5=12.240000&t=31.464663&h=76.084656&rssi=28&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184910,35.985191&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002038s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012096s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000895s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1687341623,`v1`=0.027542,`v2`=0.013039,`v3`=0.028926,`v4`=0.015502,`v5`=12.24,`t`=31.464663,`h`=76.084656,`rssi`=28,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184910,35.985191',`update_time`=1687341625 WHERE `imei` = '868922056976208' [ RunTime:0.000707s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011051s ] [ 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' , 1687341623 , 0.027542 , 0.013039 , 0.028926 , 0.015502 , 12.24 , 31.464663 , 76.084656 , 28 , '898604650119C1053139' , '460048590503139' , -0 , '120.184910,35.985191' , 1687341625) [ RunTime:0.000836s ] --------------------------------------------------------------- [ 2023-06-21T18:08:21+08:00 ] 39.144.15.227 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002724s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009922s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000759s ] --------------------------------------------------------------- [ 2023-06-21T18:08:22+08:00 ] 39.144.15.227 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1687342101&v1=0.021462&v2=0.013456&v3=0.017850&v4=-0.006893&v5=12.420000&t=31.368137&h=78.320068&rssi=26&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002236s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010667s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000848s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1687342101,`v1`=0.021462,`v2`=0.013456,`v3`=0.01785,`v4`=-0.006893,`v5`=12.42,`t`=31.368137,`h`=78.320068,`rssi`=26,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1687342102 WHERE `imei` = '868922055684209' [ RunTime:0.000577s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010716s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1687342101 , 0.021462 , 0.013456 , 0.01785 , -0.006893 , 12.42 , 31.368137 , 78.320068 , 26 , '898604650119C1078511' , '460048590708511' , -0 , 1687342102) [ RunTime:0.000548s ] --------------------------------------------------------------- [ 2023-06-21T18:33:21+08:00 ] 111.55.138.120 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002765s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011182s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000704s ] --------------------------------------------------------------- [ 2023-06-21T18:33:22+08:00 ] 111.55.138.120 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1687343601&v1=0.019415&v2=0.014812&v3=0.016706&v4=-0.004666&v5=12.420000&t=30.606655&h=83.126587&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002023s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009131s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000721s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1687343601,`v1`=0.019415,`v2`=0.014812,`v3`=0.016706,`v4`=-0.004666,`v5`=12.42,`t`=30.606655,`h`=83.126587,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1687343602 WHERE `imei` = '868922055683920' [ RunTime:0.000622s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011340s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1687343601 , 0.019415 , 0.014812 , 0.016706 , -0.004666 , 12.42 , 30.606655 , 83.126587 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1687343602) [ RunTime:0.000672s ] --------------------------------------------------------------- [ 2023-06-21T21:18:04+08:00 ] 39.144.6.11 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ 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.011758s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000730s ] --------------------------------------------------------------- [ 2023-06-21T21:18:05+08:00 ] 39.144.6.11 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1687353484&v1=0.032117&v2=0.013977&v3=0.029167&v4=0.007977&v5=12.420000&t=28.075533&h=82.134766&rssi=20&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.187652,35.986010&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.010948s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000666s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1687353484,`v1`=0.032117,`v2`=0.013977,`v3`=0.029167,`v4`=0.007977,`v5`=12.42,`t`=28.075533,`h`=82.134766,`rssi`=20,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.187652,35.986010',`update_time`=1687353485 WHERE `imei` = '868922055683912' [ RunTime:0.000633s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010682s ] [ 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' , 1687353484 , 0.032117 , 0.013977 , 0.029167 , 0.007977 , 12.42 , 28.075533 , 82.134766 , 20 , '898604650119C1053138' , '460048590503138' , -0 , '120.187652,35.986010' , 1687353485) [ RunTime:0.000638s ] --------------------------------------------------------------- [ 2023-06-21T21:24:54+08:00 ] 117.132.194.139 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002386s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010220s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2023-06-21T21:24:55+08:00 ] 117.132.194.139 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1687353894&v1=0.019776&v2=0.014916&v3=0.016074&v4=-0.017247&v5=12.420000&t=28.000456&h=83.080811&rssi=28&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.184788,35.985189&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001512s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011188s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000756s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1687353894,`v1`=0.019776,`v2`=0.014916,`v3`=0.016074,`v4`=-0.017247,`v5`=12.42,`t`=28.000456,`h`=83.080811,`rssi`=28,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.184788,35.985189',`update_time`=1687353895 WHERE `imei` = '868922055683771' [ RunTime:0.000627s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011016s ] [ 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' , 1687353894 , 0.019776 , 0.014916 , 0.016074 , -0.017247 , 12.42 , 28.000456 , 83.080811 , 28 , '898604650119C1053136' , '460048590503136' , -0 , '120.184788,35.985189' , 1687353895) [ RunTime:0.000534s ] --------------------------------------------------------------- [ 2023-06-21T22:04:51+08:00 ] 223.104.255.33 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002803s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011461s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000761s ] --------------------------------------------------------------- [ 2023-06-21T22:04:59+08:00 ] 223.104.255.33 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230621&time=220401&v1=-01.153&v2=+00.017&v3=-01.023&v4=-00.203&v5=06.0&t=+24.1&h=79.2&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.162&a2=01.225&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.014915s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010274s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000696s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230621',`time`='220401',`v1`=-1.153,`v2`=0.017,`v3`=-1.023,`v4`=-0.203,`v5`=6,`t`=24.1,`h`=79.2,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.162,`a2`=1.225,`update_time`=1687356299 WHERE `imei` = '868922055684076' [ RunTime:0.000650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011994s ] [ 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' , '230621' , '220401' , -1.153 , 0.017 , -1.023 , -0.203 , 6 , 24.1 , 79.2 , 228 , '460044618415249' , -0 , 0.162 , 1.225 , 1687356299 , 1687356299) [ RunTime:0.000652s ]