--------------------------------------------------------------- [ 2025-04-06T00:39:15+08:00 ] 66.249.77.161 GET /admin/multipledata/delete/id/4596.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002322s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009788s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4596 [ RunTime:0.001588s ] [ sql ] [ SQL ] DELETE FROM `collect_multipledata` WHERE `id` = 4596 [ RunTime:0.001376s ] --------------------------------------------------------------- [ 2025-04-06T00:40:14+08:00 ] 66.249.77.160 GET /admin/multipledata/delete.html [ error ] [0]方法参数错误:id --------------------------------------------------------------- [ 2025-04-06T01:27:51+08:00 ] 39.144.112.9 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002235s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008822s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000667s ] --------------------------------------------------------------- [ 2025-04-06T01:28:00+08:00 ] 39.144.112.9 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=250406&time=012701&v1=-00.046&v2=+00.001&v3=+00.004&v4=+00.008&v5=05.4&t=+08.8&h=71.6&rssi=+221&ccid=4600485905031430000099m9990000000021000000g0420,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002114s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009041s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='250406',`time`='012701',`v1`=-0.046,`v2`=0.001,`v3`=0.004,`v4`=0.008,`v5`=5.4,`t`=8.8,`h`=71.6,`rssi`=221,`ccid`='4600485905031430000099m9990000000021000000g0420,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1743874080 WHERE `imei` = '868922055644013' [ RunTime:0.000507s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008158s ] [ 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' , '250406' , '012701' , -0.046 , 0.001 , 0.004 , 0.008 , 5.4 , 8.8 , 71.6 , 221 , '4600485905031430000099m9990000000021000000g0420,N,00E000=-00.000' , 0 , 0 , 1743874080 , 1743874080) [ RunTime:0.000536s ] --------------------------------------------------------------- [ 2025-04-06T02:29:59+08:00 ] 111.55.120.94 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002800s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.539601s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001428s ] --------------------------------------------------------------- [ 2025-04-06T02:30:00+08:00 ] 111.55.120.94 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1743877799&v1=-1.078887&v2=0.148276&v3=-0.954000&v4=-0.806298&v5=6.480000&t=7.783648&h=73.048157&rssi=29&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428312,36.323153&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001531s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008122s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000600s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1743877799,`v1`=-1.078887,`v2`=0.148276,`v3`=-0.954,`v4`=-0.806298,`v5`=6.48,`t`=7.783648,`h`=73.048157,`rssi`=29,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428312,36.323153',`update_time`=1743877800 WHERE `imei` = '868922055684209' [ RunTime:0.000460s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007830s ] [ 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' , 1743877799 , -1.078887 , 0.148276 , -0.954 , -0.806298 , 6.48 , 7.783648 , 73.048157 , 29 , '898604650119C1078511' , '460048590708511' , -0 , '120.428312,36.323153' , 1743877800) [ RunTime:0.000527s ] --------------------------------------------------------------- [ 2025-04-06T05:16:10+08:00 ] 66.249.77.161 GET /admin/multipledata/delete/id/957.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002532s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.455650s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 957 [ RunTime:0.003260s ] --------------------------------------------------------------- [ 2025-04-06T09:30:06+08:00 ] 111.55.120.45 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002016s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010609s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001993s ] --------------------------------------------------------------- [ 2025-04-06T09:30:08+08:00 ] 111.55.120.45 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1743903006&v1=-1.344191&v2=0.038897&v3=-1.175840&v4=-0.685054&v5=6.480000&t=17.221733&h=79.968018&rssi=27&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001554s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008595s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000717s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1743903006,`v1`=-1.344191,`v2`=0.038897,`v3`=-1.17584,`v4`=-0.685054,`v5`=6.48,`t`=17.221733,`h`=79.968018,`rssi`=27,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1743903007 WHERE `imei` = '868922055644021' [ RunTime:0.000539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010269s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1743903006 , -1.344191 , 0.038897 , -1.17584 , -0.685054 , 6.48 , 17.221733 , 79.968018 , 27 , '898604650119C1053141' , '460048590503141' , -0 , 1743903008) [ RunTime:0.003428s ] --------------------------------------------------------------- [ 2025-04-06T10:54:20+08:00 ] 111.55.120.58 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.001952s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011491s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000678s ] --------------------------------------------------------------- [ 2025-04-06T10:54:28+08:00 ] 111.55.120.58 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=250406&time=105401&v1=-01.049&v2=+00.013&v3=-00.275&v4=-00.468&v5=04.6&t=+28.0&h=80.4&rssi=+231&imsi=460044618415249&v6=-00.000&a1=00.242&a2=01.112&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001711s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008897s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000612s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='250406',`time`='105401',`v1`=-1.049,`v2`=0.013,`v3`=-0.275,`v4`=-0.468,`v5`=4.6,`t`=28,`h`=80.4,`rssi`=231,`imsi`='460044618415249',`v6`=-0,`a1`=0.242,`a2`=1.112,`update_time`=1743908068 WHERE `imei` = '868922055684076' [ RunTime:0.000484s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008746s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '250406' , '105401' , -1.049 , 0.013 , -0.275 , -0.468 , 4.6 , 28 , 80.4 , 231 , '460044618415249' , -0 , 0.242 , 1.112 , 1743908068 , 1743908068) [ RunTime:0.001524s ] --------------------------------------------------------------- [ 2025-04-06T11:21:11+08:00 ] 1.29.92.42 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.002019s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.013196s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000313s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000665s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000754s ] --------------------------------------------------------------- [ 2025-04-06T11:21:19+08:00 ] 1.29.92.42 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001963s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009199s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'heating' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001697s ] --------------------------------------------------------------- [ 2025-04-06T11:21:21+08:00 ] 1.29.92.42 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002669s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.175894s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000602s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000949s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000891s ] --------------------------------------------------------------- [ 2025-04-06T11:21:27+08:00 ] 27.115.124.70 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.001423s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008265s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000341s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000679s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000714s ] --------------------------------------------------------------- [ 2025-04-06T11:21:36+08:00 ] 1.29.92.42 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001674s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009616s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000928s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.009508s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000575s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.010376s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000666s ] --------------------------------------------------------------- [ 2025-04-06T11:30:05+08:00 ] 220.195.84.122 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.002056s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009168s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000427s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000775s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000624s ] --------------------------------------------------------------- [ 2025-04-06T11:30:10+08:00 ] 220.195.84.122 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002865s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009137s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000843s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007849s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000534s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008598s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000508s ] --------------------------------------------------------------- [ 2025-04-06T11:30:14+08:00 ] 220.195.84.122 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001931s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.344943s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000831s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007717s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000500s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007345s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000503s ] --------------------------------------------------------------- [ 2025-04-06T11:30:52+08:00 ] 220.195.84.122 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001741s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008156s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000806s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.006627s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000469s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.006892s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000453s ] --------------------------------------------------------------- [ 2025-04-06T11:31:22+08:00 ] 220.195.84.122 GET /home/heating/data_analysis.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001998s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008267s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000416s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000747s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000672s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.011361s ] [ 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.000341s ] [ 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-04-06T11:31:33+08:00 ] 220.195.84.122 GET /home/heating/data_analysis.html?keyword=123&start_date=2025-04-01&end_date=2025-04-06 [ sql ] [ DB ] CONNECT:[ UseTime:0.001469s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008718s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000836s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000357s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000608s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000616s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.007840s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1743436800 AND `create_time` <= 1743868800 ) LIMIT 1 [ RunTime:0.006402s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1743436800 AND `create_time` <= 1743868800 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.002523s ] --------------------------------------------------------------- [ 2025-04-06T11:32:50+08:00 ] 220.195.84.122 GET /home/heating/data_analysis.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001697s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.561552s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000376s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000746s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000656s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.007207s ] [ 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.000303s ] [ 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.000341s ]