---------------------------------------------------------------
[ 2024-03-26T01:57:52+08:00 ] 39.144.10.250 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002534s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014862s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000716s ]
---------------------------------------------------------------
[ 2024-03-26T01:58:00+08:00 ] 39.144.10.250 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=240326&time=015701&v1=-00.069&v2=+00.001&v3=-00.019&v4=-00.005&v5=05.6&t=+03.8&h=71.4&rssi=+221&ccid=4600485905031430000099m9990000000012000000g0670,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001900s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011630s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000712s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='240326',`time`='015701',`v1`=-0.069,`v2`=0.001,`v3`=-0.019,`v4`=-0.005,`v5`=5.6,`t`=3.8,`h`=71.4,`rssi`=221,`ccid`='4600485905031430000099m9990000000012000000g0670,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1711389480  WHERE  `imei` = '868922055644013' [ RunTime:0.000673s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012921s ]
[ 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' , '240326' , '015701' , -0.069 , 0.001 , -0.019 , -0.005 , 5.6 , 3.8 , 71.4 , 221 , '4600485905031430000099m9990000000012000000g0670,N,00E000=-00.000' , 0 , 0 , 1711389480 , 1711389480) [ RunTime:0.000705s ]
---------------------------------------------------------------
[ 2024-03-26T08:30:26+08:00 ] 39.144.112.22 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002664s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011354s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000905s ]
---------------------------------------------------------------
[ 2024-03-26T08:30:27+08:00 ] 39.144.112.22 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1711413026&v1=0.160646&v2=0.550792&v3=-0.913395&v4=-0.302298&v5=6.480000&t=9.606915&h=77.404541&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428517,36.323335&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001704s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011451s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000776s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684209',`create_time`=1711413026,`v1`=0.160646,`v2`=0.550792,`v3`=-0.913395,`v4`=-0.302298,`v5`=6.48,`t`=9.606915,`h`=77.404541,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428517,36.323335',`update_time`=1711413027  WHERE  `imei` = '868922055684209' [ RunTime:0.000765s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012519s ]
[ 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' , 1711413026 , 0.160646 , 0.550792 , -0.913395 , -0.302298 , 6.48 , 9.606915 , 77.404541 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428517,36.323335' , 1711413027) [ RunTime:0.000636s ]
---------------------------------------------------------------
[ 2024-03-26T08:48:09+08:00 ] 39.144.112.9 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002426s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012708s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001107s ]
---------------------------------------------------------------
[ 2024-03-26T08:48:11+08:00 ] 39.144.112.9 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1711414089&v1=-1.260211&v2=0.057020&v3=-1.111485&v4=-0.620097&v5=6.480000&t=5.370501&h=77.526611&rssi=23&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002543s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012447s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000735s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1711414089,`v1`=-1.260211,`v2`=0.05702,`v3`=-1.111485,`v4`=-0.620097,`v5`=6.48,`t`=5.370501,`h`=77.526611,`rssi`=23,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1711414090  WHERE  `imei` = '868922055644021' [ RunTime:0.000680s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011810s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1711414089 , -1.260211 , 0.05702 , -1.111485 , -0.620097 , 6.48 , 5.370501 , 77.526611 , 23 , '898604650119C1053141' , '460048590503141' , -0 , 1711414090) [ RunTime:0.000657s ]
---------------------------------------------------------------
[ 2024-03-26T20:22:29+08:00 ] 221.178.127.224 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.004893s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.020441s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001391s ]
---------------------------------------------------------------
[ 2024-03-26T20:22:37+08:00 ] 221.178.127.224 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=240326&time=202201&v1=-01.000&v2=+00.011&v3=-00.929&v4=-00.357&v5=04.6&t=+07.6&h=81.8&rssi=+223&imsi=460044618415249&v6=-00.000&a1=00.087&a2=01.072&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002443s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011516s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000745s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684076',`date`='240326',`time`='202201',`v1`=-1,`v2`=0.011,`v3`=-0.929,`v4`=-0.357,`v5`=4.6,`t`=7.6,`h`=81.8,`rssi`=223,`imsi`='460044618415249',`v6`=-0,`a1`=0.087,`a2`=1.072,`update_time`=1711455757  WHERE  `imei` = '868922055684076' [ RunTime:0.000741s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.022248s ]
[ 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' , '240326' , '202201' , -1 , 0.011 , -0.929 , -0.357 , 4.6 , 7.6 , 81.8 , 223 , '460044618415249' , -0 , 0.087 , 1.072 , 1711455757 , 1711455757) [ RunTime:0.005430s ]
---------------------------------------------------------------
[ 2024-03-26T20:31:22+08:00 ] 39.144.112.1 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002993s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010823s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001399s ]
---------------------------------------------------------------
[ 2024-03-26T20:31:23+08:00 ] 39.144.112.1 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1711456282&v1=0.711903&v2=0.641781&v3=-0.826285&v4=-0.319937&v5=6.480000&t=9.832141&h=79.144043&rssi=30&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428415,36.323119&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002004s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011482s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000726s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684209',`create_time`=1711456282,`v1`=0.711903,`v2`=0.641781,`v3`=-0.826285,`v4`=-0.319937,`v5`=6.48,`t`=9.832141,`h`=79.144043,`rssi`=30,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428415,36.323119',`update_time`=1711456283  WHERE  `imei` = '868922055684209' [ RunTime:0.000637s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011593s ]
[ 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' , 1711456282 , 0.711903 , 0.641781 , -0.826285 , -0.319937 , 6.48 , 9.832141 , 79.144043 , 30 , '898604650119C1078511' , '460048590708511' , -0 , '120.428415,36.323119' , 1711456283) [ RunTime:0.001099s ]
---------------------------------------------------------------
[ 2024-03-26T20:50:09+08:00 ] 117.132.195.176 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002424s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013347s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000822s ]
---------------------------------------------------------------
[ 2024-03-26T20:50:10+08:00 ] 117.132.195.176 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1711457409&v1=-1.260271&v2=0.057510&v3=-1.114887&v4=-0.618532&v5=6.300000&t=9.317336&h=78.877014&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001879s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012414s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000792s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1711457409,`v1`=-1.260271,`v2`=0.05751,`v3`=-1.114887,`v4`=-0.618532,`v5`=6.3,`t`=9.317336,`h`=78.877014,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1711457410  WHERE  `imei` = '868922055644021' [ RunTime:0.000690s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012354s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1711457409 , -1.260271 , 0.05751 , -1.114887 , -0.618532 , 6.3 , 9.317336 , 78.877014 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1711457410) [ RunTime:0.000642s ]