---------------------------------------------------------------
[ 2025-02-06T01:30:17+08:00 ] 111.55.120.64 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002975s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011117s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001503s ]
---------------------------------------------------------------
[ 2025-02-06T01:30:18+08:00 ] 111.55.120.64 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1738776617&v1=-1.068532&v2=0.115775&v3=-0.791218&v4=-0.729301&v5=6.120000&t=-8.368350&h=73.399109&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428450,36.323233&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002063s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009613s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000697s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684209',`create_time`=1738776617,`v1`=-1.068532,`v2`=0.115775,`v3`=-0.791218,`v4`=-0.729301,`v5`=6.12,`t`=-8.36835,`h`=73.399109,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428450,36.323233',`update_time`=1738776618  WHERE  `imei` = '868922055684209' [ RunTime:0.000643s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013024s ]
[ 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' , 1738776617 , -1.068532 , 0.115775 , -0.791218 , -0.729301 , 6.12 , -8.36835 , 73.399109 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428450,36.323233' , 1738776618) [ RunTime:0.004110s ]
---------------------------------------------------------------
[ 2025-02-06T07:32:07+08:00 ] 111.55.120.86 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.004325s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012486s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001406s ]
---------------------------------------------------------------
[ 2025-02-06T07:32:09+08:00 ] 111.55.120.86 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1738798327&v1=-1.324265&v2=0.032235&v3=-1.077653&v4=-0.719910&v5=6.120000&t=-8.250374&h=82.020325&rssi=26&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001502s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007910s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000621s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1738798327,`v1`=-1.324265,`v2`=0.032235,`v3`=-1.077653,`v4`=-0.71991,`v5`=6.12,`t`=-8.250374,`h`=82.020325,`rssi`=26,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1738798329  WHERE  `imei` = '868922055644021' [ RunTime:0.000528s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011367s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1738798327 , -1.324265 , 0.032235 , -1.077653 , -0.71991 , 6.12 , -8.250374 , 82.020325 , 26 , '898604650119C1053141' , '460048590503141' , -0 , 1738798329) [ RunTime:0.002861s ]
---------------------------------------------------------------
[ 2025-02-06T21:07:43+08:00 ] 221.199.162.17 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002997s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009953s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000998s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008736s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE  `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000542s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007076s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE  `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000502s ]
---------------------------------------------------------------
[ 2025-02-06T21:20:54+08:00 ] 221.199.162.17 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001987s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010690s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000903s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008384s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE  `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000602s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007407s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE  `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000501s ]