---------------------------------------------------------------
[ 2024-03-21T01:57:52+08:00 ] 117.132.192.1 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.003191s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015457s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001372s ]
---------------------------------------------------------------
[ 2024-03-21T01:58:00+08:00 ] 117.132.192.1 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=240321&time=015701&v1=-00.077&v2=+00.001&v3=+00.002&v4=-00.008&v5=05.6&t=+04.6&h=71.4&rssi=+221&ccid=4600485905031430000099m9990000000024000000g0750,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002446s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011234s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000825s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='240321',`time`='015701',`v1`=-0.077,`v2`=0.001,`v3`=0.002,`v4`=-0.008,`v5`=5.6,`t`=4.6,`h`=71.4,`rssi`=221,`ccid`='4600485905031430000099m9990000000024000000g0750,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1710957480  WHERE  `imei` = '868922055644013' [ RunTime:0.000719s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017057s ]
[ 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' , '240321' , '015701' , -0.077 , 0.001 , 0.002 , -0.008 , 5.6 , 4.6 , 71.4 , 221 , '4600485905031430000099m9990000000024000000g0750,N,00E000=-00.000' , 0 , 0 , 1710957480 , 1710957480) [ RunTime:0.002886s ]
---------------------------------------------------------------
[ 2024-03-21T08:20:01+08:00 ] 39.144.112.24 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.003197s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.017630s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001652s ]
---------------------------------------------------------------
[ 2024-03-21T08:20:03+08:00 ] 39.144.112.24 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710980401&v1=-0.748686&v2=0.537531&v3=-0.858402&v4=-1.060225&v5=6.300000&t=10.679424&h=77.663940&rssi=29&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428291,36.322644&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001899s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014654s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000778s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684209',`create_time`=1710980401,`v1`=-0.748686,`v2`=0.537531,`v3`=-0.858402,`v4`=-1.060225,`v5`=6.3,`t`=10.679424,`h`=77.66394,`rssi`=29,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428291,36.322644',`update_time`=1710980403  WHERE  `imei` = '868922055684209' [ RunTime:0.000840s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021276s ]
[ 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' , 1710980401 , -0.748686 , 0.537531 , -0.858402 , -1.060225 , 6.3 , 10.679424 , 77.66394 , 29 , '898604650119C1078511' , '460048590708511' , -0 , '120.428291,36.322644' , 1710980403) [ RunTime:0.005458s ]
---------------------------------------------------------------
[ 2024-03-21T08:28:09+08:00 ] 39.144.112.10 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002200s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010880s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001499s ]
---------------------------------------------------------------
[ 2024-03-21T08:28:10+08:00 ] 39.144.112.10 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710980889&v1=-1.175870&v2=0.062171&v3=-1.037950&v4=-0.518177&v5=6.300000&t=7.933799&h=77.236694&rssi=23&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002228s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012854s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000817s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1710980889,`v1`=-1.17587,`v2`=0.062171,`v3`=-1.03795,`v4`=-0.518177,`v5`=6.3,`t`=7.933799,`h`=77.236694,`rssi`=23,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710980890  WHERE  `imei` = '868922055644021' [ RunTime:0.000994s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012160s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710980889 , -1.17587 , 0.062171 , -1.03795 , -0.518177 , 6.3 , 7.933799 , 77.236694 , 23 , '898604650119C1053141' , '460048590503141' , -0 , 1710980890) [ RunTime:0.001375s ]
---------------------------------------------------------------
[ 2024-03-21T20:21:36+08:00 ] 39.144.11.181 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.003284s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.017277s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001094s ]
---------------------------------------------------------------
[ 2024-03-21T20:21:38+08:00 ] 39.144.11.181 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1711023696&v1=-1.066425&v2=0.630064&v3=-0.862255&v4=-0.809127&v5=6.300000&t=9.499663&h=78.663391&rssi=29&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428754,36.323908&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002616s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014480s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001120s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684209',`create_time`=1711023696,`v1`=-1.066425,`v2`=0.630064,`v3`=-0.862255,`v4`=-0.809127,`v5`=6.3,`t`=9.499663,`h`=78.663391,`rssi`=29,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428754,36.323908',`update_time`=1711023698  WHERE  `imei` = '868922055684209' [ RunTime:0.001930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014841s ]
[ 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' , 1711023696 , -1.066425 , 0.630064 , -0.862255 , -0.809127 , 6.3 , 9.499663 , 78.663391 , 29 , '898604650119C1078511' , '460048590708511' , -0 , '120.428754,36.323908' , 1711023698) [ RunTime:0.000762s ]
---------------------------------------------------------------
[ 2024-03-21T20:30:09+08:00 ] 117.132.193.198 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002444s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010893s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000719s ]
---------------------------------------------------------------
[ 2024-03-21T20:30:10+08:00 ] 117.132.193.198 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1711024209&v1=-1.172077&v2=0.055573&v3=-1.035422&v4=-0.516010&v5=6.300000&t=9.156460&h=78.449768&rssi=23&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.003132s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011767s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000918s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1711024209,`v1`=-1.172077,`v2`=0.055573,`v3`=-1.035422,`v4`=-0.51601,`v5`=6.3,`t`=9.15646,`h`=78.449768,`rssi`=23,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1711024210  WHERE  `imei` = '868922055644021' [ RunTime:0.000739s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012778s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1711024209 , -1.172077 , 0.055573 , -1.035422 , -0.51601 , 6.3 , 9.15646 , 78.449768 , 23 , '898604650119C1053141' , '460048590503141' , -0 , 1711024210) [ RunTime:0.000615s ]