---------------------------------------------------------------
[ 2025-03-29T02:22:59+08:00 ] 111.55.120.81 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002409s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009567s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000716s ]
---------------------------------------------------------------
[ 2025-03-29T02:23:00+08:00 ] 111.55.120.81 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1743186179&v1=-1.099656&v2=0.095215&v3=-1.091679&v4=-0.723703&v5=6.480000&t=1.992095&h=73.963684&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428417,36.323173&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001741s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030369s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000647s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684209',`create_time`=1743186179,`v1`=-1.099656,`v2`=0.095215,`v3`=-1.091679,`v4`=-0.723703,`v5`=6.48,`t`=1.992095,`h`=73.963684,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428417,36.323173',`update_time`=1743186180  WHERE  `imei` = '868922055684209' [ RunTime:0.000529s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008350s ]
[ 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' , 1743186179 , -1.099656 , 0.095215 , -1.091679 , -0.723703 , 6.48 , 1.992095 , 73.963684 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428417,36.323173' , 1743186180) [ RunTime:0.001326s ]
---------------------------------------------------------------
[ 2025-03-29T02:23:02+08:00 ] 111.55.120.81 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1743099661&v1=-1.100860&v2=0.099780&v3=-1.091107&v4=-0.723281&v5=6.480000&t=4.651919&h=73.612732&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002160s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008369s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000632s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684209',`create_time`=1743099661,`v1`=-1.10086,`v2`=0.09978,`v3`=-1.091107,`v4`=-0.723281,`v5`=6.48,`t`=4.651919,`h`=73.612732,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1743186182  WHERE  `imei` = '868922055684209' [ RunTime:0.000432s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008104s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1743099661 , -1.10086 , 0.09978 , -1.091107 , -0.723281 , 6.48 , 4.651919 , 73.612732 , 31 , '898604650119C1078511' , '460048590708511' , -0 , 1743186182) [ RunTime:0.000448s ]
---------------------------------------------------------------
[ 2025-03-29T06:56:44+08:00 ] 220.195.106.218 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002416s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.012413s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.001246s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.011654s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE  `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000768s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.009831s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE  `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000557s ]
---------------------------------------------------------------
[ 2025-03-29T06:56:53+08:00 ] 123.6.49.44 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001473s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009557s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000991s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008220s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE  `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000609s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008281s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE  `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000630s ]
---------------------------------------------------------------
[ 2025-03-29T09:14:06+08:00 ] 111.55.120.51 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002116s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009523s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001647s ]
---------------------------------------------------------------
[ 2025-03-29T09:14:08+08:00 ] 111.55.120.51 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1743210846&v1=-1.352439&v2=0.056371&v3=-1.182793&v4=-0.619495&v5=5.760000&t=5.627903&h=81.768555&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001606s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008305s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000728s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1743210846,`v1`=-1.352439,`v2`=0.056371,`v3`=-1.182793,`v4`=-0.619495,`v5`=5.76,`t`=5.627903,`h`=81.768555,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1743210848  WHERE  `imei` = '868922055644021' [ RunTime:0.000481s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007771s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1743210846 , -1.352439 , 0.056371 , -1.182793 , -0.619495 , 5.76 , 5.627903 , 81.768555 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1743210848) [ RunTime:0.000575s ]