--------------------------------------------------------------- [ 2025-03-31T01:29:32+08:00 ] 111.55.120.67 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002770s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.564719s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000697s ] --------------------------------------------------------------- [ 2025-03-31T01:29:40+08:00 ] 111.55.120.67 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=250331&time=012901&v1=-00.052&v2=+00.001&v3=+00.014&v4=+00.008&v5=05.4&t=+07.6&h=72.4&rssi=+227&ccid=4600485905031430000099m9990000000031000000g0480,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001599s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009100s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='250331',`time`='012901',`v1`=-0.052,`v2`=0.001,`v3`=0.014,`v4`=0.008,`v5`=5.4,`t`=7.6,`h`=72.4,`rssi`=227,`ccid`='4600485905031430000099m9990000000031000000g0480,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1743355780 WHERE `imei` = '868922055644013' [ RunTime:0.000499s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008127s ] [ 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' , '250331' , '012901' , -0.052 , 0.001 , 0.014 , 0.008 , 5.4 , 7.6 , 72.4 , 227 , '4600485905031430000099m9990000000031000000g0480,N,00E000=-00.000' , 0 , 0 , 1743355780 , 1743355780) [ RunTime:0.000546s ] --------------------------------------------------------------- [ 2025-03-31T02:25:01+08:00 ] 111.55.120.83 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002437s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.083222s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000725s ] --------------------------------------------------------------- [ 2025-03-31T02:25:02+08:00 ] 111.55.120.83 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1743359101&v1=-1.088760&v2=0.128567&v3=-1.079970&v4=-0.727616&v5=6.300000&t=7.150867&h=73.498291&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428215,36.323871&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001433s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008028s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000617s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1743359101,`v1`=-1.08876,`v2`=0.128567,`v3`=-1.07997,`v4`=-0.727616,`v5`=6.3,`t`=7.150867,`h`=73.498291,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428215,36.323871',`update_time`=1743359102 WHERE `imei` = '868922055684209' [ RunTime:0.000484s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008483s ] [ 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' , 1743359101 , -1.08876 , 0.128567 , -1.07997 , -0.727616 , 6.3 , 7.150867 , 73.498291 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428215,36.323871' , 1743359102) [ RunTime:0.000613s ] --------------------------------------------------------------- [ 2025-03-31T09:18:05+08:00 ] 39.144.112.30 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002441s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009305s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000675s ] --------------------------------------------------------------- [ 2025-03-31T09:18:06+08:00 ] 39.144.112.30 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1743383885&v1=-1.349790&v2=0.056744&v3=-1.178820&v4=-0.658144&v5=6.480000&t=12.481240&h=80.990356&rssi=25&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001611s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009230s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000602s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1743383885,`v1`=-1.34979,`v2`=0.056744,`v3`=-1.17882,`v4`=-0.658144,`v5`=6.48,`t`=12.48124,`h`=80.990356,`rssi`=25,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1743383886 WHERE `imei` = '868922055644021' [ RunTime:0.000970s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007811s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1743383885 , -1.34979 , 0.056744 , -1.17882 , -0.658144 , 6.48 , 12.48124 , 80.990356 , 25 , '898604650119C1053141' , '460048590503141' , -0 , 1743383886) [ RunTime:0.000605s ]