--------------------------------------------------------------- [ 2025-04-15T01:26:51+08:00 ] 111.55.120.55 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002024s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010270s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000645s ] --------------------------------------------------------------- [ 2025-04-15T01:27:00+08:00 ] 111.55.120.55 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=250415&time=012601&v1=-00.078&v2=+00.001&v3=-00.009&v4=+00.007&v5=05.4&t=+07.8&h=71.3&rssi=+227&ccid=4600485905031430000099m9990000000019000000g0750,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001648s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010548s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000625s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='250415',`time`='012601',`v1`=-0.078,`v2`=0.001,`v3`=-0.009,`v4`=0.007,`v5`=5.4,`t`=7.8,`h`=71.3,`rssi`=227,`ccid`='4600485905031430000099m9990000000019000000g0750,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1744651620 WHERE `imei` = '868922055644013' [ RunTime:0.000488s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008155s ] [ 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' , '250415' , '012601' , -0.078 , 0.001 , -0.009 , 0.007 , 5.4 , 7.8 , 71.3 , 227 , '4600485905031430000099m9990000000019000000g0750,N,00E000=-00.000' , 0 , 0 , 1744651620 , 1744651620) [ RunTime:0.000534s ] --------------------------------------------------------------- [ 2025-04-15T02:38:20+08:00 ] 111.55.120.32 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002402s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009030s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000701s ] --------------------------------------------------------------- [ 2025-04-15T02:38:21+08:00 ] 111.55.120.32 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1744655900&v1=-1.103689&v2=0.152937&v3=-0.897863&v4=-0.830739&v5=6.300000&t=4.769895&h=72.910828&rssi=29&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428322,36.323116&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001475s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007712s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000665s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1744655900,`v1`=-1.103689,`v2`=0.152937,`v3`=-0.897863,`v4`=-0.830739,`v5`=6.3,`t`=4.769895,`h`=72.910828,`rssi`=29,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428322,36.323116',`update_time`=1744655901 WHERE `imei` = '868922055684209' [ RunTime:0.000468s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007895s ] [ 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' , 1744655900 , -1.103689 , 0.152937 , -0.897863 , -0.830739 , 6.3 , 4.769895 , 72.910828 , 29 , '898604650119C1078511' , '460048590708511' , -0 , '120.428322,36.323116' , 1744655901) [ RunTime:0.000549s ] --------------------------------------------------------------- [ 2025-04-15T07:38:01+08:00 ] 1.29.92.242 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.003195s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010152s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000567s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000854s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000681s ] --------------------------------------------------------------- [ 2025-04-15T07:38:14+08:00 ] 27.115.124.109 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.001787s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010308s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000415s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000871s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000880s ] --------------------------------------------------------------- [ 2025-04-15T07:38:14+08:00 ] 27.115.124.45 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.001438s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.012953s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000286s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000661s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000747s ] --------------------------------------------------------------- [ 2025-04-15T08:01:55+08:00 ] 220.195.84.122 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.001939s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009590s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000387s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000781s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000620s ] --------------------------------------------------------------- [ 2025-04-15T08:01:59+08:00 ] 220.195.84.122 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001531s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008835s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000909s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008706s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.001394s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.010501s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000670s ] --------------------------------------------------------------- [ 2025-04-15T08:02:22+08:00 ] 27.115.124.45 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001324s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008651s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000900s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008376s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000559s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007701s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000835s ] --------------------------------------------------------------- [ 2025-04-15T08:02:22+08:00 ] 27.115.124.38 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001613s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009912s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000873s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007455s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000492s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008194s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000491s ] --------------------------------------------------------------- [ 2025-04-15T08:03:31+08:00 ] 220.195.84.122 GET /home/heating/data_analysis_day.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001361s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008520s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000432s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000874s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000937s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdataave` [ RunTime:0.014240s ] [ 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.000416s ] [ 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.000398s ] --------------------------------------------------------------- [ 2025-04-15T08:03:33+08:00 ] 220.195.84.122 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001478s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009855s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.001538s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.009293s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000597s ] --------------------------------------------------------------- [ 2025-04-15T08:03:34+08:00 ] 220.195.84.122 GET /home/heating/data_analysis.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001990s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008593s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000389s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000822s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000667s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.009028s ] [ 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.000323s ] [ 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.000385s ] --------------------------------------------------------------- [ 2025-04-15T08:03:53+08:00 ] 220.195.84.122 GET /home/heating/data_analysis.html?keyword=123&start_date=2025-04-01&end_date=2025-04-14 [ 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.009004s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000942s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000455s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000703s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000718s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.008254s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1743436800 AND `create_time` <= 1744560000 ) LIMIT 1 [ RunTime:0.006610s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1743436800 AND `create_time` <= 1744560000 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.002800s ] --------------------------------------------------------------- [ 2025-04-15T08:23:09+08:00 ] 124.129.68.232 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002171s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.008190s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000518s ] --------------------------------------------------------------- [ 2025-04-15T08:23:22+08:00 ] 124.129.68.232 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001624s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.010162s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000571s ] --------------------------------------------------------------- [ 2025-04-15T08:23:25+08:00 ] 124.129.68.232 GET /admin/infordevice/device.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002207s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.008447s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_infordevice` LIMIT 1 [ RunTime:0.000257s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000510s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` ORDER BY `id` DESC [ RunTime:0.000449s ] --------------------------------------------------------------- [ 2025-04-15T08:23:27+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001577s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.008180s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000522s ] --------------------------------------------------------------- [ 2025-04-15T08:28:49+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002460s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.008442s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000544s ] --------------------------------------------------------------- [ 2025-04-15T08:33:53+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.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_infordevice` [ RunTime:0.008359s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000504s ] --------------------------------------------------------------- [ 2025-04-15T08:34:58+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002129s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.008220s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000502s ] --------------------------------------------------------------- [ 2025-04-15T08:34:59+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001552s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.007690s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000499s ] --------------------------------------------------------------- [ 2025-04-15T08:35:00+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001634s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.008459s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000506s ] --------------------------------------------------------------- [ 2025-04-15T08:35:38+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002217s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.008798s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000500s ] --------------------------------------------------------------- [ 2025-04-15T08:39:13+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001796s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.008240s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000487s ] --------------------------------------------------------------- [ 2025-04-15T08:52:07+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002115s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.008972s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000545s ] --------------------------------------------------------------- [ 2025-04-15T09:35:17+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003179s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.012717s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.001264s ] --------------------------------------------------------------- [ 2025-04-15T09:48:06+08:00 ] 39.144.112.14 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002099s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009696s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000706s ] --------------------------------------------------------------- [ 2025-04-15T09:48:07+08:00 ] 39.144.112.14 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1744681686&v1=-1.328419&v2=0.054605&v3=-1.152422&v4=-0.639903&v5=6.300000&t=19.506180&h=78.747314&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001501s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009033s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000685s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1744681686,`v1`=-1.328419,`v2`=0.054605,`v3`=-1.152422,`v4`=-0.639903,`v5`=6.3,`t`=19.50618,`h`=78.747314,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1744681687 WHERE `imei` = '868922055644021' [ RunTime:0.000641s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014669s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1744681686 , -1.328419 , 0.054605 , -1.152422 , -0.639903 , 6.3 , 19.50618 , 78.747314 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1744681687) [ RunTime:0.003877s ] --------------------------------------------------------------- [ 2025-04-15T11:49:41+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003083s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.008995s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000597s ] --------------------------------------------------------------- [ 2025-04-15T11:49:58+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001664s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.009117s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000506s ] --------------------------------------------------------------- [ 2025-04-15T11:50:02+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001497s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.008022s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000893s ] --------------------------------------------------------------- [ 2025-04-15T11:50:12+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001587s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.008685s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000542s ] --------------------------------------------------------------- [ 2025-04-15T11:50:13+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001454s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.008718s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000510s ] --------------------------------------------------------------- [ 2025-04-15T11:50:38+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001598s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.008242s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000526s ] --------------------------------------------------------------- [ 2025-04-15T11:50:42+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001752s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.008115s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000489s ] --------------------------------------------------------------- [ 2025-04-15T11:50:44+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002330s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.010297s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000652s ] --------------------------------------------------------------- [ 2025-04-15T11:54:34+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002486s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.008254s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000547s ] --------------------------------------------------------------- [ 2025-04-15T11:55:59+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002166s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.009889s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000630s ] --------------------------------------------------------------- [ 2025-04-15T12:05:30+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002168s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.009186s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000529s ] --------------------------------------------------------------- [ 2025-04-15T12:10:00+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001980s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.007757s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000506s ] --------------------------------------------------------------- [ 2025-04-15T12:49:31+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002407s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.008631s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000557s ] --------------------------------------------------------------- [ 2025-04-15T16:22:11+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002079s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.009059s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000614s ] --------------------------------------------------------------- [ 2025-04-15T17:10:35+08:00 ] 1.29.92.247 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.008787s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000310s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000652s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000717s ] --------------------------------------------------------------- [ 2025-04-15T17:10:46+08:00 ] 1.29.92.247 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002877s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.008260s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'heating' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000536s ] --------------------------------------------------------------- [ 2025-04-15T17:10:47+08:00 ] 1.29.92.247 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001534s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009517s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000445s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000864s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000719s ] --------------------------------------------------------------- [ 2025-04-15T17:10:53+08:00 ] 1.29.92.247 GET /home/heating/data_analysis.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001915s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008745s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000415s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000774s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000615s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.007830s ] [ 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.000446s ] [ 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.000389s ] --------------------------------------------------------------- [ 2025-04-15T17:11:16+08:00 ] 1.29.92.247 GET /home/heating/data_analysis.html?keyword=123&start_date=2024-12-01&end_date=2024-12-31 [ sql ] [ DB ] CONNECT:[ UseTime:0.002893s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010737s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.001228s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.003415s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000973s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000974s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.018700s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1732982400 AND `create_time` <= 1735574400 ) LIMIT 1 [ RunTime:0.003151s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1732982400 AND `create_time` <= 1735574400 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.016847s ] --------------------------------------------------------------- [ 2025-04-15T17:11:38+08:00 ] 1.29.92.247 GET /home/heating/data_analysis.html?keyword=123&start_date=2025-01-01&end_date=2025-01-31 [ sql ] [ DB ] CONNECT:[ UseTime:0.002561s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.011024s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.001177s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000504s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001283s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000754s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.010457s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1735660800 AND `create_time` <= 1738252800 ) LIMIT 1 [ RunTime:0.003588s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1735660800 AND `create_time` <= 1738252800 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.006384s ] --------------------------------------------------------------- [ 2025-04-15T17:11:57+08:00 ] 1.29.92.247 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.008919s ] [ 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.000422s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000622s ] [ 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.008166s ] [ 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.003738s ] [ 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.003656s ] --------------------------------------------------------------- [ 2025-04-15T17:12:24+08:00 ] 1.29.92.247 GET /home/heating/data_analysis.html?keyword=123&start_date=2025-03-01&end_date=2025-03-31 [ sql ] [ DB ] CONNECT:[ UseTime:0.001740s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009167s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000968s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000438s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000721s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000665s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.007956s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1740758400 AND `create_time` <= 1743350400 ) LIMIT 1 [ RunTime:0.001752s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1740758400 AND `create_time` <= 1743350400 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.003680s ] --------------------------------------------------------------- [ 2025-04-15T17:12:45+08:00 ] 1.29.92.247 GET /home/heating/data_analysis.html?keyword=123&start_date=2025-04-01&end_date=2025-03-15 [ sql ] [ DB ] CONNECT:[ UseTime:0.002723s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.011829s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.001382s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000571s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000943s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.001158s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.010126s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1743436800 AND `create_time` <= 1741968000 ) LIMIT 1 [ RunTime:0.003323s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1743436800 AND `create_time` <= 1741968000 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.003022s ] --------------------------------------------------------------- [ 2025-04-15T17:12:53+08:00 ] 1.29.92.247 GET /home/heating/data_analysis.html?keyword=123&start_date=2025-04-01&end_date=2025-04-15 [ sql ] [ DB ] CONNECT:[ UseTime:0.001795s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008790s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.001080s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000423s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001023s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000985s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.008250s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1743436800 AND `create_time` <= 1744646400 ) LIMIT 1 [ RunTime:0.002758s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1743436800 AND `create_time` <= 1744646400 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.004367s ] --------------------------------------------------------------- [ 2025-04-15T17:13:00+08:00 ] 1.29.92.247 GET /home/heating/data_analysis_day.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001653s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009098s ] [ 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.000847s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000641s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdataave` [ RunTime:0.008468s ] [ 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.000391s ] [ 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.000349s ] --------------------------------------------------------------- [ 2025-04-15T17:13:11+08:00 ] 1.29.92.247 GET /home/heating/data_analysis_day.html?keyword=123&start_date=2024-12-01&end_date=2025-04-15 [ sql ] [ DB ] CONNECT:[ UseTime:0.001768s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010217s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000995s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000516s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000705s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.001083s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdataave` [ RunTime:0.007679s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdataave` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1732982400 AND `create_time` <= 1744646400 ) LIMIT 1 [ RunTime:0.001588s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdataave` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1732982400 AND `create_time` <= 1744646400 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.000840s ] --------------------------------------------------------------- [ 2025-04-15T17:13:22+08:00 ] 1.29.92.247 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001766s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.011751s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000441s ] [ 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.000656s ] --------------------------------------------------------------- [ 2025-04-15T17:13:24+08:00 ] 1.29.92.247 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.008910s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000894s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008749s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000598s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008689s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000678s ] --------------------------------------------------------------- [ 2025-04-15T17:52:59+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001969s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.008563s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.001943s ] --------------------------------------------------------------- [ 2025-04-15T23:48:53+08:00 ] 124.129.68.232 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002010s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.009036s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000651s ]