---------------------------------------------------------------
[ 2025-03-19T02:13:03+08:00 ] 111.55.120.53 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.003069s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011092s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001705s ]
---------------------------------------------------------------
[ 2025-03-19T02:13:04+08:00 ] 111.55.120.53 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1742321583&v1=-1.083703&v2=0.182895&v3=-1.064529&v4=-0.718525&v5=6.300000&t=-0.914407&h=73.551697&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428481,36.324365&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001387s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008737s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000720s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684209',`create_time`=1742321583,`v1`=-1.083703,`v2`=0.182895,`v3`=-1.064529,`v4`=-0.718525,`v5`=6.3,`t`=-0.914407,`h`=73.551697,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428481,36.324365',`update_time`=1742321584  WHERE  `imei` = '868922055684209' [ RunTime:0.000624s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.216273s ]
[ 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' , 1742321583 , -1.083703 , 0.182895 , -1.064529 , -0.718525 , 6.3 , -0.914407 , 73.551697 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428481,36.324365' , 1742321584) [ RunTime:0.003604s ]
---------------------------------------------------------------
[ 2025-03-19T05:37:53+08:00 ] 66.249.66.13 GET /home/heating/data_analysis.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002378s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.013309s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE  `username` IS NULL LIMIT 1 [ RunTime:0.000353s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE  `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000666s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE  `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000736s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.007896s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE  `unique_identification_number` IS NULL  AND ( `create_time` >= 0 AND `create_time` <= 0 ) LIMIT 1 [ RunTime:0.000350s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE  `unique_identification_number` IS NULL  AND ( `create_time` >= 0 AND `create_time` <= 0 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.000417s ]
---------------------------------------------------------------
[ 2025-03-19T08:54:07+08:00 ] 39.144.112.19 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002843s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.220920s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001529s ]
---------------------------------------------------------------
[ 2025-03-19T08:54:08+08:00 ] 39.144.112.19 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1742345647&v1=-1.336666&v2=0.073420&v3=-1.097127&v4=-0.706606&v5=6.300000&t=5.906755&h=81.585449&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001821s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010186s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000956s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1742345647,`v1`=-1.336666,`v2`=0.07342,`v3`=-1.097127,`v4`=-0.706606,`v5`=6.3,`t`=5.906755,`h`=81.585449,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1742345648  WHERE  `imei` = '868922055644021' [ RunTime:0.000655s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010438s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1742345647 , -1.336666 , 0.07342 , -1.097127 , -0.706606 , 6.3 , 5.906755 , 81.585449 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1742345648) [ RunTime:0.000788s ]