--------------------------------------------------------------- [ 2025-02-28T00:09:59+08:00 ] 66.249.79.162 GET /admin/multipleshow/read/id/16/imei/863412043560864.html?page=25 [ sql ] [ DB ] CONNECT:[ UseTime:0.002911s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.008996s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000845s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008083s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043560864' LIMIT 1 [ RunTime:0.055099s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043560864' ORDER BY `update_time` DESC LIMIT 240,10 [ RunTime:0.003241s ] --------------------------------------------------------------- [ 2025-02-28T01:33:51+08:00 ] 111.55.120.91 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002702s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010709s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001488s ] --------------------------------------------------------------- [ 2025-02-28T01:34:00+08:00 ] 111.55.120.91 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=250228&time=013301&v1=-00.065&v2=+00.001&v3=+00.011&v4=+00.003&v5=05.4&t=+05.5&h=73.4&rssi=+223&ccid=4600485905031430000099m9990000000030000000g0630,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001673s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024077s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000724s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='250228',`time`='013301',`v1`=-0.065,`v2`=0.001,`v3`=0.011,`v4`=0.003,`v5`=5.4,`t`=5.5,`h`=73.4,`rssi`=223,`ccid`='4600485905031430000099m9990000000030000000g0630,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1740677640 WHERE `imei` = '868922055644013' [ RunTime:0.000676s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013359s ] [ 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' , '250228' , '013301' , -0.065 , 0.001 , 0.011 , 0.003 , 5.4 , 5.5 , 73.4 , 223 , '4600485905031430000099m9990000000030000000g0630,N,00E000=-00.000' , 0 , 0 , 1740677640 , 1740677640) [ RunTime:0.003101s ] --------------------------------------------------------------- [ 2025-02-28T01:51:01+08:00 ] 111.55.120.39 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002035s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008815s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000623s ] --------------------------------------------------------------- [ 2025-02-28T01:51:02+08:00 ] 111.55.120.39 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1740678661&v1=-1.073228&v2=0.084934&v3=-1.049388&v4=-0.704980&v5=6.300000&t=1.005386&h=74.070496&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428472,36.323168&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001447s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008125s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000656s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1740678661,`v1`=-1.073228,`v2`=0.084934,`v3`=-1.049388,`v4`=-0.70498,`v5`=6.3,`t`=1.005386,`h`=74.070496,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428472,36.323168',`update_time`=1740678662 WHERE `imei` = '868922055684209' [ RunTime:0.000409s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.006946s ] [ 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' , 1740678661 , -1.073228 , 0.084934 , -1.049388 , -0.70498 , 6.3 , 1.005386 , 74.070496 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428472,36.323168' , 1740678662) [ RunTime:0.001910s ] --------------------------------------------------------------- [ 2025-02-28T02:28:26+08:00 ] 66.249.79.194 GET /admin/multipledata/delete/id/48.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002621s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.010350s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 48 [ RunTime:0.001260s ] --------------------------------------------------------------- [ 2025-02-28T04:53:06+08:00 ] 66.249.68.38 GET /admin/multipledata/delete/id/132.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002492s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009464s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 132 [ RunTime:0.000504s ] --------------------------------------------------------------- [ 2025-02-28T07:05:22+08:00 ] 66.249.79.32 GET /admin/multipleshow/read/id/6/imei/863412043541146.html?page=11 [ sql ] [ DB ] CONNECT:[ UseTime:0.003756s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010834s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000704s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009148s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043541146' LIMIT 1 [ RunTime:0.003880s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043541146' ORDER BY `update_time` DESC LIMIT 100,10 [ RunTime:0.004096s ] --------------------------------------------------------------- [ 2025-02-28T08:16:06+08:00 ] 111.55.120.71 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002098s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011162s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001844s ] --------------------------------------------------------------- [ 2025-02-28T08:16:07+08:00 ] 111.55.120.71 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1740701766&v1=-1.322098&v2=0.079081&v3=-1.061699&v4=-0.622144&v5=6.480000&t=3.332732&h=82.401794&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002775s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009333s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1740701766,`v1`=-1.322098,`v2`=0.079081,`v3`=-1.061699,`v4`=-0.622144,`v5`=6.48,`t`=3.332732,`h`=82.401794,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1740701767 WHERE `imei` = '868922055644021' [ RunTime:0.000753s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011851s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1740701766 , -1.322098 , 0.079081 , -1.061699 , -0.622144 , 6.48 , 3.332732 , 82.401794 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1740701767) [ RunTime:0.002928s ] --------------------------------------------------------------- [ 2025-02-28T09:56:28+08:00 ] 66.249.79.194 GET /admin/multipleshow/read/id/6/imei/863412043541146.html?page=13 [ sql ] [ DB ] CONNECT:[ UseTime:0.002378s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010163s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000597s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.007655s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043541146' LIMIT 1 [ RunTime:0.003198s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043541146' ORDER BY `update_time` DESC LIMIT 120,10 [ RunTime:0.003075s ] --------------------------------------------------------------- [ 2025-02-28T10:41:06+08:00 ] 1.27.108.47 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.002242s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.011035s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000491s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000928s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000851s ] --------------------------------------------------------------- [ 2025-02-28T10:41:08+08:00 ] 1.27.108.47 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001503s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009273s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000902s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.027673s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000671s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008671s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000544s ] --------------------------------------------------------------- [ 2025-02-28T10:41:24+08:00 ] 123.6.49.15 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.001261s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008299s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000682s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000709s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000901s ] --------------------------------------------------------------- [ 2025-02-28T10:41:24+08:00 ] 123.6.49.50 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.002365s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008190s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000276s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000683s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000737s ] --------------------------------------------------------------- [ 2025-02-28T10:41:27+08:00 ] 123.6.49.44 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001365s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010115s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000904s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007833s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000585s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007877s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000554s ] --------------------------------------------------------------- [ 2025-02-28T15:40:59+08:00 ] 1.27.108.47 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.002017s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008765s ] [ 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.000826s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.001020s ] --------------------------------------------------------------- [ 2025-02-28T15:41:01+08:00 ] 1.27.108.47 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002754s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.012570s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.001424s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.010528s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000791s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.009482s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000552s ] --------------------------------------------------------------- [ 2025-02-28T15:42:12+08:00 ] 1.27.108.47 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002152s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008787s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000378s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000752s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000691s ] --------------------------------------------------------------- [ 2025-02-28T15:42:14+08:00 ] 1.27.108.47 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001642s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009101s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000799s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007363s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000518s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.013580s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000578s ] --------------------------------------------------------------- [ 2025-02-28T15:42:21+08:00 ] 1.27.108.47 GET /home/heating/data_analysis.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001817s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008799s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000398s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000769s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000600s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.008438s ] [ 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.000409s ] [ 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.000388s ] --------------------------------------------------------------- [ 2025-02-28T15:42:33+08:00 ] 1.27.108.47 GET /home/heating/data_analysis.html?keyword=123&start_date=2025-02-14&end_date=2025-02-28 [ sql ] [ DB ] CONNECT:[ UseTime:0.001921s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.011978s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.001167s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000492s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001165s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000916s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.009614s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1739462400 AND `create_time` <= 1740672000 ) LIMIT 1 [ RunTime:0.004555s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1739462400 AND `create_time` <= 1740672000 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.003227s ] --------------------------------------------------------------- [ 2025-02-28T15:43:55+08:00 ] 1.27.108.47 GET /home/heating/data_analysis.html?keyword=123&start_date=2024-12-01&end_date=2025-02-28 [ sql ] [ DB ] CONNECT:[ UseTime:0.001499s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008585s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000823s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000382s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000617s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000610s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.007101s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1732982400 AND `create_time` <= 1740672000 ) LIMIT 1 [ RunTime:0.001221s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1732982400 AND `create_time` <= 1740672000 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.004287s ] --------------------------------------------------------------- [ 2025-02-28T15:45:54+08:00 ] 1.27.108.47 GET /home/heating/data_analysis.html?keyword=123&start_date=2025-01-01&end_date=2025-02-28 [ sql ] [ DB ] CONNECT:[ UseTime:0.001658s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008951s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000874s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000364s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000663s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000610s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.007938s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1735660800 AND `create_time` <= 1740672000 ) LIMIT 1 [ RunTime:0.001201s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1735660800 AND `create_time` <= 1740672000 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.004171s ] --------------------------------------------------------------- [ 2025-02-28T15:46:26+08:00 ] 1.27.108.47 GET /home/heating/data_analysis.html?keyword=123&start_date=2024-12-18&end_date=2025-01-31 [ sql ] [ DB ] CONNECT:[ UseTime:0.001905s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010207s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000875s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000481s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000659s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.008164s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1734451200 AND `create_time` <= 1738252800 ) LIMIT 1 [ RunTime:0.001279s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1734451200 AND `create_time` <= 1738252800 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.004026s ] --------------------------------------------------------------- [ 2025-02-28T15:46:33+08:00 ] 1.27.108.47 GET /home/heating/data_analysis.html?keyword=123&start_date=2024-12-18&end_date=2025-01-31 [ sql ] [ DB ] CONNECT:[ UseTime:0.001683s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009475s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.001691s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000514s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000856s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000798s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.009779s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1734451200 AND `create_time` <= 1738252800 ) LIMIT 1 [ RunTime:0.001392s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1734451200 AND `create_time` <= 1738252800 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.004020s ] --------------------------------------------------------------- [ 2025-02-28T15:47:29+08:00 ] 1.27.108.47 GET /home/heating/data_analysis.html?keyword=123&start_date=2025-02-01&end_date=2025-02-28 [ sql ] [ DB ] CONNECT:[ UseTime:0.001627s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008419s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000835s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000399s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001052s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000640s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.007724s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1738339200 AND `create_time` <= 1740672000 ) LIMIT 1 [ RunTime:0.001291s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1738339200 AND `create_time` <= 1740672000 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.003225s ] --------------------------------------------------------------- [ 2025-02-28T15:47:40+08:00 ] 1.27.108.47 GET /home/heating/data_analysis.html?keyword=123&start_date=2025-02-01&end_date=2025-02-28 [ sql ] [ DB ] CONNECT:[ UseTime:0.001694s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008391s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000796s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000404s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000704s ] [ 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.007981s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1738339200 AND `create_time` <= 1740672000 ) LIMIT 1 [ RunTime:0.001307s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1738339200 AND `create_time` <= 1740672000 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.003107s ] --------------------------------------------------------------- [ 2025-02-28T15:57:25+08:00 ] 1.27.108.47 GET /home/heating/data_analysis_day.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003119s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.011934s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001133s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000924s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdataave` [ RunTime:0.012756s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdataave` WHERE `unique_identification_number` IS NULL AND ( `create_time` >= 0 AND `create_time` <= 0 ) LIMIT 1 [ RunTime:0.000461s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdataave` WHERE `unique_identification_number` IS NULL AND ( `create_time` >= 0 AND `create_time` <= 0 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.000480s ] --------------------------------------------------------------- [ 2025-02-28T15:57:39+08:00 ] 1.27.108.47 GET /home/heating/data_analysis_day.html?keyword=123&start_date=2024-12-18&end_date=2025-02-28 [ sql ] [ DB ] CONNECT:[ UseTime:0.001638s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008869s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000909s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000390s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000624s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000672s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdataave` [ RunTime:0.007947s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdataave` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1734451200 AND `create_time` <= 1740672000 ) LIMIT 1 [ RunTime:0.003599s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdataave` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1734451200 AND `create_time` <= 1740672000 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.000665s ] --------------------------------------------------------------- [ 2025-02-28T15:58:03+08:00 ] 1.27.108.47 GET /home/heating/data_analysis_day.html?keyword=123&start_date=2024-12-31&end_date=2025-02-28 [ sql ] [ DB ] CONNECT:[ UseTime:0.002162s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009626s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000882s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000388s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000685s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000663s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdataave` [ RunTime:0.007653s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdataave` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1735574400 AND `create_time` <= 1740672000 ) LIMIT 1 [ RunTime:0.000417s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdataave` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1735574400 AND `create_time` <= 1740672000 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.000609s ] --------------------------------------------------------------- [ 2025-02-28T15:58:15+08:00 ] 1.27.108.47 GET /home/heating/data_analysis_day.html?keyword=123&start_date=2024-12-18&end_date=2025-02-28 [ sql ] [ DB ] CONNECT:[ UseTime:0.001521s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008834s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.001200s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000573s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000635s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000657s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdataave` [ RunTime:0.007512s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdataave` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1734451200 AND `create_time` <= 1740672000 ) LIMIT 1 [ RunTime:0.000428s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdataave` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1734451200 AND `create_time` <= 1740672000 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.001096s ] --------------------------------------------------------------- [ 2025-02-28T15:58:22+08:00 ] 1.27.108.47 GET /home/heating/data_analysis_day.html?keyword=123&start_date=2024-12-18&end_date=2025-02-28 [ sql ] [ DB ] CONNECT:[ UseTime:0.001876s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009063s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000844s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000548s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000909s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdataave` [ RunTime:0.007973s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdataave` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1734451200 AND `create_time` <= 1740672000 ) LIMIT 1 [ RunTime:0.000515s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdataave` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1734451200 AND `create_time` <= 1740672000 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.000656s ] --------------------------------------------------------------- [ 2025-02-28T20:37:51+08:00 ] 66.249.79.193 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.002008s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009610s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000379s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000699s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.001036s ] --------------------------------------------------------------- [ 2025-02-28T21:43:32+08:00 ] 220.195.79.156 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.002027s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008854s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000469s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001263s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000720s ] --------------------------------------------------------------- [ 2025-02-28T21:43:35+08:00 ] 220.195.79.156 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001439s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008907s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000452s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000739s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000622s ] --------------------------------------------------------------- [ 2025-02-28T21:43:38+08:00 ] 220.195.79.156 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001660s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008400s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000880s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008293s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000511s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007620s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.001153s ] --------------------------------------------------------------- [ 2025-02-28T21:44:56+08:00 ] 220.195.79.156 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001486s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009354s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000849s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007315s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000490s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008097s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000605s ]