---------------------------------------------------------------
[ 2023-06-09T00:11:23+08:00 ] 39.144.4.164 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850
[ sql ] [ DB ] CONNECT:[ UseTime:0.002253s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010084s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000796s ]
---------------------------------------------------------------
[ 2023-06-09T00:11:24+08:00 ] 39.144.4.164 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1686240683&v1=0.021522&v2=0.013873&v3=0.018572&v4=-0.006110&v5=12.240000&t=26.831421&h=78.869385&rssi=27&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$
[ 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.010503s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000692s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1686240683,`v1`=0.021522,`v2`=0.013873,`v3`=0.018572,`v4`=-0.00611,`v5`=12.24,`t`=26.831421,`h`=78.869385,`rssi`=27,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1686240684 WHERE `imei` = '868922055680850' [ RunTime:0.000602s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010908s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1686240683 , 0.021522 , 0.013873 , 0.018572 , -0.00611 , 12.24 , 26.831421 , 78.869385 , 27 , '898604650119C1078510' , '460048590708510' , -0 , 1686240684) [ RunTime:0.000574s ]
---------------------------------------------------------------
[ 2023-06-09T02:03:55+08:00 ] 39.144.4.40 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002747s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011983s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000711s ]
---------------------------------------------------------------
[ 2023-06-09T02:03:55+08:00 ] 111.55.140.142 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ 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.011622s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000703s ]
---------------------------------------------------------------
[ 2023-06-09T02:04:03+08:00 ] 39.144.4.40 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230609&time=020301&v1=-01.386&v2=+00.016&v3=-01.023&v4=-00.043&v5=06.2&t=+22.4&h=59.4&rssi=+227&ccid=4600485905031420000099m9990000000366000001g3940,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001885s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010677s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000667s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230609',`time`='020301',`v1`=-1.386,`v2`=0.016,`v3`=-1.023,`v4`=-0.043,`v5`=6.2,`t`=22.4,`h`=59.4,`rssi`=227,`ccid`='4600485905031420000099m9990000000366000001g3940,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686247443 WHERE `imei` = '868922055643643' [ RunTime:0.000628s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012165s ]
[ 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' , '230609' , '020301' , -1.386 , 0.016 , -1.023 , -0.043 , 6.2 , 22.4 , 59.4 , 227 , '4600485905031420000099m9990000000366000001g3940,N,00E000=-00.000' , 0 , 0 , 1686247443 , 1686247443) [ RunTime:0.001213s ]
---------------------------------------------------------------
[ 2023-06-09T02:04:04+08:00 ] 111.55.140.142 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230609&time=020301&v1=-00.490&v2=+00.001&v3=+00.018&v4=-00.002&v5=06.0&t=+22.9&h=62.6&rssi=+222&ccid=4600485905031430000099m9990000000040000000g5130,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001566s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010777s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000689s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230609',`time`='020301',`v1`=-0.49,`v2`=0.001,`v3`=0.018,`v4`=-0.002,`v5`=6,`t`=22.9,`h`=62.6,`rssi`=222,`ccid`='4600485905031430000099m9990000000040000000g5130,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686247444 WHERE `imei` = '868922055644013' [ RunTime:0.000513s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010841s ]
[ 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' , '230609' , '020301' , -0.49 , 0.001 , 0.018 , -0.002 , 6 , 22.9 , 62.6 , 222 , '4600485905031430000099m9990000000040000000g5130,N,00E000=-00.000' , 0 , 0 , 1686247444 , 1686247444) [ RunTime:0.000554s ]
---------------------------------------------------------------
[ 2023-06-09T11:29:27+08:00 ] 39.144.3.107 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110
[ sql ] [ DB ] CONNECT:[ UseTime:0.002601s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013006s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001344s ]
---------------------------------------------------------------
[ 2023-06-09T11:29:28+08:00 ] 39.144.3.107 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1686281367&v1=0.030672&v2=0.013039&v3=0.030612&v4=0.001294&v5=12.420000&t=27.153173&h=78.899902&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.004147s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011400s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000711s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1686281367,`v1`=0.030672,`v2`=0.013039,`v3`=0.030612,`v4`=0.001294,`v5`=12.42,`t`=27.153173,`h`=78.899902,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1686281368 WHERE `imei` = '868922055678110' [ RunTime:0.000687s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011208s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1686281367 , 0.030672 , 0.013039 , 0.030612 , 0.001294 , 12.42 , 27.153173 , 78.899902 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1686281368) [ RunTime:0.001203s ]
---------------------------------------------------------------
[ 2023-06-09T14:03:54+08:00 ] 218.204.252.18 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ 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.012067s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000692s ]
---------------------------------------------------------------
[ 2023-06-09T14:03:55+08:00 ] 223.104.255.36 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001666s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021135s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000648s ]
---------------------------------------------------------------
[ 2023-06-09T14:04:02+08:00 ] 218.204.252.18 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230609&time=140301&v1=-01.386&v2=+00.025&v3=-01.012&v4=-00.043&v5=06.4&t=+38.0&h=55.2&rssi=+228&ccid=4600485905031420000099m9990000000374000001g3930,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001880s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009274s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000641s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230609',`time`='140301',`v1`=-1.386,`v2`=0.025,`v3`=-1.012,`v4`=-0.043,`v5`=6.4,`t`=38,`h`=55.2,`rssi`=228,`ccid`='4600485905031420000099m9990000000374000001g3930,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686290642 WHERE `imei` = '868922055643643' [ RunTime:0.000591s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011500s ]
[ 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' , '230609' , '140301' , -1.386 , 0.025 , -1.012 , -0.043 , 6.4 , 38 , 55.2 , 228 , '4600485905031420000099m9990000000374000001g3930,N,00E000=-00.000' , 0 , 0 , 1686290642 , 1686290642) [ RunTime:0.000633s ]
---------------------------------------------------------------
[ 2023-06-09T14:04:03+08:00 ] 223.104.255.36 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230609&time=140301&v1=-00.373&v2=+00.001&v3=+00.020&v4=-00.002&v5=06.0&t=+34.1&h=60.7&rssi=+225&ccid=4600485905031430000099m9990000000044000000g3910,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001628s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008531s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001354s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230609',`time`='140301',`v1`=-0.373,`v2`=0.001,`v3`=0.02,`v4`=-0.002,`v5`=6,`t`=34.1,`h`=60.7,`rssi`=225,`ccid`='4600485905031430000099m9990000000044000000g3910,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686290643 WHERE `imei` = '868922055644013' [ RunTime:0.000532s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010808s ]
[ 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' , '230609' , '140301' , -0.373 , 0.001 , 0.02 , -0.002 , 6 , 34.1 , 60.7 , 225 , '4600485905031430000099m9990000000044000000g3910,N,00E000=-00.000' , 0 , 0 , 1686290643 , 1686290643) [ RunTime:0.000513s ]
---------------------------------------------------------------
[ 2023-06-09T14:56:23+08:00 ] 221.178.126.127 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548
[ sql ] [ DB ] CONNECT:[ UseTime:0.002276s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011576s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000715s ]
---------------------------------------------------------------
[ 2023-06-09T14:56:24+08:00 ] 221.178.126.127 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1686293783&v1=0.016826&v2=0.013560&v3=0.014599&v4=-0.011769&v5=12.420000&t=27.314051&h=77.564758&rssi=30&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001723s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010542s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000673s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1686293783,`v1`=0.016826,`v2`=0.01356,`v3`=0.014599,`v4`=-0.011769,`v5`=12.42,`t`=27.314051,`h`=77.564758,`rssi`=30,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1686293784 WHERE `imei` = '868922055684548' [ RunTime:0.000611s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010707s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1686293783 , 0.016826 , 0.01356 , 0.014599 , -0.011769 , 12.42 , 27.314051 , 77.564758 , 30 , '898604650119C1053137' , '460048590503137' , -0 , 1686293784) [ RunTime:0.001212s ]
---------------------------------------------------------------
[ 2023-06-09T17:07:58+08:00 ] 39.144.15.222 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586
[ sql ] [ DB ] CONNECT:[ UseTime:0.002612s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012772s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000827s ]
---------------------------------------------------------------
[ 2023-06-09T17:08:00+08:00 ] 39.144.15.222 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1686301678&v1=0.018452&v2=0.012934&v3=0.015833&v4=-0.000271&v5=12.420000&t=27.099548&h=79.235596&rssi=29&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.185046,35.985797&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001813s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012865s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000772s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1686301678,`v1`=0.018452,`v2`=0.012934,`v3`=0.015833,`v4`=-0.000271,`v5`=12.42,`t`=27.099548,`h`=79.235596,`rssi`=29,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.185046,35.985797',`update_time`=1686301680 WHERE `imei` = '868922055647586' [ RunTime:0.000743s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012121s ]
[ 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' , 1686301678 , 0.018452 , 0.012934 , 0.015833 , -0.000271 , 12.42 , 27.099548 , 79.235596 , 29 , '898604650119C1078512' , '460048590708512' , -0 , '120.185046,35.985797' , 1686301680) [ RunTime:0.003394s ]
---------------------------------------------------------------
[ 2023-06-09T17:49:57+08:00 ] 39.144.11.106 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.002361s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.017605s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000959s ]
---------------------------------------------------------------
[ 2023-06-09T17:49:59+08:00 ] 39.144.11.106 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1686304197&v1=0.027000&v2=0.012621&v3=0.027241&v4=0.015682&v5=12.240000&t=26.938671&h=77.183289&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184898,35.985593&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001716s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009998s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000721s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1686304197,`v1`=0.027,`v2`=0.012621,`v3`=0.027241,`v4`=0.015682,`v5`=12.24,`t`=26.938671,`h`=77.183289,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184898,35.985593',`update_time`=1686304199 WHERE `imei` = '868922056976208' [ RunTime:0.000729s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010663s ]
[ 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' , 1686304197 , 0.027 , 0.012621 , 0.027241 , 0.015682 , 12.24 , 26.938671 , 77.183289 , 27 , '898604650119C1053139' , '460048590503139' , -0 , '120.184898,35.985593' , 1686304199) [ RunTime:0.003477s ]
---------------------------------------------------------------
[ 2023-06-09T17:56:20+08:00 ] 117.132.196.233 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002682s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010764s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000662s ]
---------------------------------------------------------------
[ 2023-06-09T17:56:21+08:00 ] 117.132.196.233 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1686304580&v1=0.020860&v2=0.013977&v3=0.017037&v4=-0.006893&v5=12.240000&t=26.992298&h=79.319519&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ 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.014502s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000659s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1686304580,`v1`=0.02086,`v2`=0.013977,`v3`=0.017037,`v4`=-0.006893,`v5`=12.24,`t`=26.992298,`h`=79.319519,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1686304581 WHERE `imei` = '868922055684209' [ RunTime:0.000551s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011486s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1686304580 , 0.02086 , 0.013977 , 0.017037 , -0.006893 , 12.24 , 26.992298 , 79.319519 , 27 , '898604650119C1078511' , '460048590708511' , -0 , 1686304581) [ RunTime:0.001042s ]
---------------------------------------------------------------
[ 2023-06-09T18:21:21+08:00 ] 117.132.195.63 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920
[ sql ] [ DB ] CONNECT:[ UseTime:0.002436s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011642s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000736s ]
---------------------------------------------------------------
[ 2023-06-09T18:21:22+08:00 ] 117.132.195.63 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1686306081&v1=0.019114&v2=0.014812&v3=0.016405&v4=-0.004846&v5=12.420000&t=26.863596&h=83.019775&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$
[ 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.010691s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000702s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1686306081,`v1`=0.019114,`v2`=0.014812,`v3`=0.016405,`v4`=-0.004846,`v5`=12.42,`t`=26.863596,`h`=83.019775,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1686306082 WHERE `imei` = '868922055683920' [ RunTime:0.000866s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011525s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1686306081 , 0.019114 , 0.014812 , 0.016405 , -0.004846 , 12.42 , 26.863596 , 83.019775 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1686306082) [ RunTime:0.000621s ]
---------------------------------------------------------------
[ 2023-06-09T21:06:24+08:00 ] 117.132.194.152 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912
[ sql ] [ DB ] CONNECT:[ UseTime:0.002665s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011968s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000727s ]
---------------------------------------------------------------
[ 2023-06-09T21:06:25+08:00 ] 117.132.194.152 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1686315984&v1=0.031214&v2=0.015855&v3=0.029077&v4=0.008037&v5=12.420000&t=26.767071&h=81.509155&rssi=19&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.185486,35.987445&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.003046s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015689s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000746s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1686315984,`v1`=0.031214,`v2`=0.015855,`v3`=0.029077,`v4`=0.008037,`v5`=12.42,`t`=26.767071,`h`=81.509155,`rssi`=19,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.185486,35.987445',`update_time`=1686315985 WHERE `imei` = '868922055683912' [ RunTime:0.000946s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012711s ]
[ 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' , 1686315984 , 0.031214 , 0.015855 , 0.029077 , 0.008037 , 12.42 , 26.767071 , 81.509155 , 19 , '898604650119C1053138' , '460048590503138' , -0 , '120.185486,35.987445' , 1686315985) [ RunTime:0.001321s ]
---------------------------------------------------------------
[ 2023-06-09T21:13:24+08:00 ] 111.55.136.254 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771
[ sql ] [ DB ] CONNECT:[ UseTime:0.002570s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012921s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000830s ]
---------------------------------------------------------------
[ 2023-06-09T21:13:25+08:00 ] 111.55.136.254 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1686316404&v1=0.019475&v2=0.014499&v3=0.016194&v4=-0.017308&v5=12.420000&t=26.713446&h=82.394165&rssi=26&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.185629,35.987633&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002048s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012838s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000958s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1686316404,`v1`=0.019475,`v2`=0.014499,`v3`=0.016194,`v4`=-0.017308,`v5`=12.42,`t`=26.713446,`h`=82.394165,`rssi`=26,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.185629,35.987633',`update_time`=1686316405 WHERE `imei` = '868922055683771' [ RunTime:0.000828s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011726s ]
[ 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' , 1686316404 , 0.019475 , 0.014499 , 0.016194 , -0.017308 , 12.42 , 26.713446 , 82.394165 , 26 , '898604650119C1053136' , '460048590503136' , -0 , '120.185629,35.987633' , 1686316405) [ RunTime:0.000711s ]
---------------------------------------------------------------
[ 2023-06-09T22:13:50+08:00 ] 111.55.141.114 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002397s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011913s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000740s ]
---------------------------------------------------------------
[ 2023-06-09T22:13:59+08:00 ] 111.55.141.114 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230609&time=221301&v1=-01.175&v2=+00.021&v3=-01.060&v4=-00.234&v5=06.0&t=+21.7&h=79.7&rssi=+224&imsi=460044618415249&v6=-00.000&a1=00.142&a2=01.237&a3=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.009824s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000640s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230609',`time`='221301',`v1`=-1.175,`v2`=0.021,`v3`=-1.06,`v4`=-0.234,`v5`=6,`t`=21.7,`h`=79.7,`rssi`=224,`imsi`='460044618415249',`v6`=-0,`a1`=0.142,`a2`=1.237,`update_time`=1686320039 WHERE `imei` = '868922055684076' [ RunTime:0.000587s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010748s ]
[ 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' , '230609' , '221301' , -1.175 , 0.021 , -1.06 , -0.234 , 6 , 21.7 , 79.7 , 224 , '460044618415249' , -0 , 0.142 , 1.237 , 1686320039 , 1686320039) [ RunTime:0.000617s ]
---------------------------------------------------------------
[ 2023-06-09T23:51:23+08:00 ] 39.144.14.76 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002434s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013213s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000695s ]
---------------------------------------------------------------
[ 2023-06-09T23:51:24+08:00 ] 39.144.14.76 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1686325883&v1=0.007676&v2=0.013351&v3=0.004846&v4=-0.015863&v5=12.420000&t=26.380966&h=80.616516&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001550s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009706s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000657s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1686325883,`v1`=0.007676,`v2`=0.013351,`v3`=0.004846,`v4`=-0.015863,`v5`=12.42,`t`=26.380966,`h`=80.616516,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1686325884 WHERE `imei` = '868922055644021' [ RunTime:0.000613s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009717s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1686325883 , 0.007676 , 0.013351 , 0.004846 , -0.015863 , 12.42 , 26.380966 , 80.616516 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1686325884) [ RunTime:0.000599s ]