--------------------------------------------------------------- [ 2025-04-27T01:26:51+08:00 ] 39.144.112.29 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002782s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009023s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000622s ] --------------------------------------------------------------- [ 2025-04-27T01:27:00+08:00 ] 39.144.112.29 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=250427&time=012601&v1=-00.057&v2=+00.001&v3=+00.020&v4=+00.011&v5=05.7&t=+18.8&h=70.2&rssi=+221&ccid=4600485905031430000099m9990000000037000000g0720,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001519s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008703s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000592s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='250427',`time`='012601',`v1`=-0.057,`v2`=0.001,`v3`=0.02,`v4`=0.011,`v5`=5.7,`t`=18.8,`h`=70.2,`rssi`=221,`ccid`='4600485905031430000099m9990000000037000000g0720,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1745688420 WHERE `imei` = '868922055644013' [ RunTime:0.000463s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007694s ] [ 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' , '250427' , '012601' , -0.057 , 0.001 , 0.02 , 0.011 , 5.7 , 18.8 , 70.2 , 221 , '4600485905031430000099m9990000000037000000g0720,N,00E000=-00.000' , 0 , 0 , 1745688420 , 1745688420) [ RunTime:0.000498s ] --------------------------------------------------------------- [ 2025-04-27T02:49:00+08:00 ] 111.55.120.36 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002170s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010815s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001427s ] --------------------------------------------------------------- [ 2025-04-27T02:49:02+08:00 ] 111.55.120.36 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1745693340&v1=-1.110011&v2=0.152341&v3=-0.889766&v4=-0.850244&v5=6.300000&t=17.500586&h=71.644348&rssi=30&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428548,36.323668&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001563s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008274s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000645s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1745693340,`v1`=-1.110011,`v2`=0.152341,`v3`=-0.889766,`v4`=-0.850244,`v5`=6.3,`t`=17.500586,`h`=71.644348,`rssi`=30,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428548,36.323668',`update_time`=1745693342 WHERE `imei` = '868922055684209' [ RunTime:0.000481s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007813s ] [ 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' , 1745693340 , -1.110011 , 0.152341 , -0.889766 , -0.850244 , 6.3 , 17.500586 , 71.644348 , 30 , '898604650119C1078511' , '460048590708511' , -0 , '120.428548,36.323668' , 1745693342) [ RunTime:0.000536s ] --------------------------------------------------------------- [ 2025-04-27T08:55:03+08:00 ] 124.129.66.48 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002148s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.008633s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000494s ] --------------------------------------------------------------- [ 2025-04-27T08:55:07+08:00 ] 124.129.66.48 GET /admin/infordevice/device.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001886s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.010410s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_infordevice` LIMIT 1 [ RunTime:0.000288s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000489s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` ORDER BY `id` DESC [ RunTime:0.000463s ] --------------------------------------------------------------- [ 2025-04-27T08:55:10+08:00 ] 124.129.66.48 GET /admin/infordevice/communication/id/5/unique_identification_number/infor_device_001.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002020s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_infordevice` [ RunTime:0.008976s ] [ sql ] [ SQL ] SELECT * FROM `collect_infordevice` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000625s ] --------------------------------------------------------------- [ 2025-04-27T10:12:05+08:00 ] 111.55.120.87 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002342s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008800s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000665s ] --------------------------------------------------------------- [ 2025-04-27T10:12:07+08:00 ] 111.55.120.87 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1745719925&v1=-1.288506&v2=0.049337&v3=-1.076479&v4=-0.658325&v5=6.120000&t=22.391230&h=78.983826&rssi=26&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002163s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007862s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000968s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1745719925,`v1`=-1.288506,`v2`=0.049337,`v3`=-1.076479,`v4`=-0.658325,`v5`=6.12,`t`=22.39123,`h`=78.983826,`rssi`=26,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1745719927 WHERE `imei` = '868922055644021' [ RunTime:0.000498s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008756s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1745719925 , -1.288506 , 0.049337 , -1.076479 , -0.658325 , 6.12 , 22.39123 , 78.983826 , 26 , '898604650119C1053141' , '460048590503141' , -0 , 1745719927) [ RunTime:0.000509s ] --------------------------------------------------------------- [ 2025-04-27T10:38:41+08:00 ] 110.7.187.73 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.002444s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010020s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000400s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000740s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000959s ] --------------------------------------------------------------- [ 2025-04-27T10:38:50+08:00 ] 110.7.187.73 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001560s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.008725s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'heating' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001366s ] --------------------------------------------------------------- [ 2025-04-27T10:38:52+08:00 ] 110.7.187.73 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002088s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009218s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000500s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000850s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000675s ] --------------------------------------------------------------- [ 2025-04-27T10:38:57+08:00 ] 110.7.187.73 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.012197s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008758s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.001176s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.009697s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000642s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.009243s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000698s ] --------------------------------------------------------------- [ 2025-04-27T10:38:58+08:00 ] 123.6.49.44 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.001300s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008085s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000294s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000658s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000750s ] --------------------------------------------------------------- [ 2025-04-27T10:39:02+08:00 ] 123.6.49.47 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002887s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008341s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000355s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000723s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000725s ] --------------------------------------------------------------- [ 2025-04-27T21:39:11+08:00 ] 220.195.84.64 GET /home/heating/data_analysis.html?keyword=123&start_date=2025-04-01&end_date=2025-04-14 [ sql ] [ DB ] CONNECT:[ UseTime:0.003121s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008565s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000873s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000434s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000675s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000712s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.011769s ] [ 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.006365s ] [ 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.002915s ] --------------------------------------------------------------- [ 2025-04-27T21:39:18+08:00 ] 220.195.84.64 GET /home/heating/data_analysis.html?keyword=123&start_date=2025-04-01&end_date=2025-04-14 [ 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.008425s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000837s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000732s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000621s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000631s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.007348s ] [ 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.001821s ] [ 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.002738s ] --------------------------------------------------------------- [ 2025-04-27T21:39:24+08:00 ] 220.195.84.64 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001550s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009013s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000401s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000748s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000651s ] --------------------------------------------------------------- [ 2025-04-27T21:39:28+08:00 ] 220.195.84.64 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001706s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009841s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.001144s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008886s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.009021s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000627s ]