---------------------------------------------------------------
[ 2025-01-23T01:19:00+08:00 ] 111.55.120.13 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002528s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013364s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001532s ]
---------------------------------------------------------------
[ 2025-01-23T01:19:01+08:00 ] 111.55.120.13 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1737566340&v1=-1.117897&v2=0.141987&v3=-0.735833&v4=-0.811897&v5=6.300000&t=-2.319395&h=74.314636&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.427351,36.324286&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001904s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008307s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000639s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1737566340,`v1`=-1.117897,`v2`=0.141987,`v3`=-0.735833,`v4`=-0.811897,`v5`=6.3,`t`=-2.319395,`h`=74.314636,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.427351,36.324286',`update_time`=1737566341 WHERE `imei` = '868922055684209' [ RunTime:0.000558s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012257s ]
[ 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' , 1737566340 , -1.117897 , 0.141987 , -0.735833 , -0.811897 , 6.3 , -2.319395 , 74.314636 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.427351,36.324286' , 1737566341) [ RunTime:0.004151s ]
---------------------------------------------------------------
[ 2025-01-23T07:04:07+08:00 ] 111.55.120.12 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002481s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010848s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001506s ]
---------------------------------------------------------------
[ 2025-01-23T07:04:08+08:00 ] 111.55.120.12 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1737587047&v1=-1.309215&v2=0.051816&v3=-1.053964&v4=-0.702873&v5=5.580000&t=-3.810183&h=82.653564&rssi=25&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001595s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007857s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000659s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1737587047,`v1`=-1.309215,`v2`=0.051816,`v3`=-1.053964,`v4`=-0.702873,`v5`=5.58,`t`=-3.810183,`h`=82.653564,`rssi`=25,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1737587048 WHERE `imei` = '868922055644021' [ RunTime:0.000499s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008255s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1737587047 , -1.309215 , 0.051816 , -1.053964 , -0.702873 , 5.58 , -3.810183 , 82.653564 , 25 , '898604650119C1053141' , '460048590503141' , -0 , 1737587048) [ RunTime:0.001280s ]
---------------------------------------------------------------
[ 2025-01-23T10:31:43+08:00 ] 218.56.88.228 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002062s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012121s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'heating' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001285s ]
---------------------------------------------------------------
[ 2025-01-23T10:31:44+08:00 ] 218.56.88.228 GET /home/heating/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001419s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008735s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000424s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000767s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000970s ]
---------------------------------------------------------------
[ 2025-01-23T10:31:46+08:00 ] 218.56.88.228 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001749s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008917s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000869s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008274s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000565s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007939s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000530s ]
---------------------------------------------------------------
[ 2025-01-23T11:54:57+08:00 ] 116.95.203.153 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002022s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.011502s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000900s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007621s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000631s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008815s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000503s ]
---------------------------------------------------------------
[ 2025-01-23T11:55:18+08:00 ] 116.95.203.153 GET /home/heating/data_analysis.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001716s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010086s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000447s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000778s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000734s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.008599s ]
[ 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.000384s ]
[ 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.000357s ]
---------------------------------------------------------------
[ 2025-01-23T11:55:31+08:00 ] 116.95.203.153 GET /home/heating/data_analysis.html?keyword=123&start_date=2025-01-09&end_date=2025-01-23
[ sql ] [ DB ] CONNECT:[ UseTime:0.002015s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009748s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.001429s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000461s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000783s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000757s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.008782s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1736352000 AND `create_time` <= 1737561600 ) LIMIT 1 [ RunTime:0.001033s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1736352000 AND `create_time` <= 1737561600 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.002025s ]
---------------------------------------------------------------
[ 2025-01-23T11:56:49+08:00 ] 116.95.203.153 GET /home/heating/data_analysis.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001695s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.011272s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000511s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000994s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000838s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.009771s ]
[ 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.000339s ]
[ 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.000464s ]
---------------------------------------------------------------
[ 2025-01-23T15:33:23+08:00 ] 220.195.79.206 GET /home/heating/data_analysis.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.003285s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009897s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000528s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000810s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000671s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.008746s ]
[ 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.000330s ]
[ 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.000412s ]
---------------------------------------------------------------
[ 2025-01-23T15:33:26+08:00 ] 220.195.79.206 GET /home/heating/data_analysis.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001527s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009847s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000363s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000712s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000641s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.006967s ]
[ 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.000259s ]
[ 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.000314s ]
---------------------------------------------------------------
[ 2025-01-23T15:33:39+08:00 ] 220.195.79.206 GET /home/heating/data_analysis.html?keyword=123&start_date=2025-01-17&end_date=2025-01-23
[ sql ] [ DB ] CONNECT:[ UseTime:0.001459s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008668s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000824s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000372s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000634s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000636s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.007377s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1737043200 AND `create_time` <= 1737561600 ) LIMIT 1 [ RunTime:0.002444s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1737043200 AND `create_time` <= 1737561600 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.001213s ]
---------------------------------------------------------------
[ 2025-01-23T15:39:40+08:00 ] 220.195.79.206 GET /home/heating/data_analysis.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001950s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008883s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000436s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000791s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.001216s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.007554s ]
[ 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.000318s ]
[ 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.000344s ]