---------------------------------------------------------------
[ 2024-03-28T01:57:52+08:00 ] 111.55.140.175 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002260s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013173s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000705s ]
---------------------------------------------------------------
[ 2024-03-28T01:58:00+08:00 ] 111.55.140.175 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=240328&time=015701&v1=-00.072&v2=+00.001&v3=-00.009&v4=-00.004&v5=05.7&t=+09.1&h=71.1&rssi=+222&ccid=4600485905031430000099m9990000000015000000g0700,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&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.011826s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000640s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='240328',`time`='015701',`v1`=-0.072,`v2`=0.001,`v3`=-0.009,`v4`=-0.004,`v5`=5.7,`t`=9.1,`h`=71.1,`rssi`=222,`ccid`='4600485905031430000099m9990000000015000000g0700,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1711562280  WHERE  `imei` = '868922055644013' [ RunTime:0.000775s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012042s ]
[ 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' , '240328' , '015701' , -0.072 , 0.001 , -0.009 , -0.004 , 5.7 , 9.1 , 71.1 , 222 , '4600485905031430000099m9990000000015000000g0700,N,00E000=-00.000' , 0 , 0 , 1711562280 , 1711562280) [ RunTime:0.000655s ]
---------------------------------------------------------------
[ 2024-03-28T08:34:25+08:00 ] 39.144.112.35 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002753s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014930s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000825s ]
---------------------------------------------------------------
[ 2024-03-28T08:34:26+08:00 ] 39.144.112.35 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1711586065&v1=-0.239448&v2=0.579866&v3=-0.795974&v4=-0.521669&v5=6.300000&t=12.170213&h=77.969116&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428443,36.323191&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001585s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012825s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000860s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684209',`create_time`=1711586065,`v1`=-0.239448,`v2`=0.579866,`v3`=-0.795974,`v4`=-0.521669,`v5`=6.3,`t`=12.170213,`h`=77.969116,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428443,36.323191',`update_time`=1711586066  WHERE  `imei` = '868922055684209' [ RunTime:0.000770s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013070s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1711586065 , -0.239448 , 0.579866 , -0.795974 , -0.521669 , 6.3 , 12.170213 , 77.969116 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428443,36.323191' , 1711586066) [ RunTime:0.000721s ]
---------------------------------------------------------------
[ 2024-03-28T08:56:09+08:00 ] 111.55.141.23 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.003455s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014387s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000968s ]
---------------------------------------------------------------
[ 2024-03-28T08:56:10+08:00 ] 111.55.141.23 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1711587369&v1=-1.245281&v2=0.059372&v3=-1.103449&v4=-0.602458&v5=6.300000&t=11.676858&h=77.129883&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001895s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011442s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000724s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1711587369,`v1`=-1.245281,`v2`=0.059372,`v3`=-1.103449,`v4`=-0.602458,`v5`=6.3,`t`=11.676858,`h`=77.129883,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1711587370  WHERE  `imei` = '868922055644021' [ RunTime:0.000762s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012322s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1711587369 , -1.245281 , 0.059372 , -1.103449 , -0.602458 , 6.3 , 11.676858 , 77.129883 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1711587370) [ RunTime:0.000625s ]
---------------------------------------------------------------
[ 2024-03-28T20:35:27+08:00 ] 39.144.112.35 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.005693s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014634s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001836s ]
---------------------------------------------------------------
[ 2024-03-28T20:35:29+08:00 ] 39.144.112.35 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1711629327&v1=-0.796606&v2=0.649997&v3=-0.869449&v4=-1.119823&v5=6.300000&t=13.382149&h=78.831238&rssi=30&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428405,36.323126&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002603s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014589s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000813s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684209',`create_time`=1711629327,`v1`=-0.796606,`v2`=0.649997,`v3`=-0.869449,`v4`=-1.119823,`v5`=6.3,`t`=13.382149,`h`=78.831238,`rssi`=30,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428405,36.323126',`update_time`=1711629329  WHERE  `imei` = '868922055684209' [ RunTime:0.000996s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.024085s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1711629327 , -0.796606 , 0.649997 , -0.869449 , -1.119823 , 6.3 , 13.382149 , 78.831238 , 30 , '898604650119C1078511' , '460048590708511' , -0 , '120.428405,36.323126' , 1711629329) [ RunTime:0.006202s ]
---------------------------------------------------------------
[ 2024-03-28T20:58:09+08:00 ] 39.144.112.20 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002356s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012031s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001435s ]
---------------------------------------------------------------
[ 2024-03-28T20:58:14+08:00 ] 39.144.112.20 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1711630561&v1=-1.185081&v2=0.048794&v3=-1.053151&v4=-0.517335&v5=6.480000&t=13.017495&h=78.541321&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001904s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010702s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000687s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1711630561,`v1`=-1.185081,`v2`=0.048794,`v3`=-1.053151,`v4`=-0.517335,`v5`=6.48,`t`=13.017495,`h`=78.541321,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1711630694  WHERE  `imei` = '868922055644021' [ RunTime:0.000681s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011319s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1711630561 , -1.185081 , 0.048794 , -1.053151 , -0.517335 , 6.48 , 13.017495 , 78.541321 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1711630694) [ RunTime:0.000634s ]