---------------------------------------------------------------
[ 2025-01-28T01:24:01+08:00 ] 39.144.112.43 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002745s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009739s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001425s ]
---------------------------------------------------------------
[ 2025-01-28T01:24:02+08:00 ] 39.144.112.43 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1737998641&v1=-1.052699&v2=0.114636&v3=-0.795372&v4=-0.810512&v5=6.300000&t=-6.598709&h=73.750061&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.426814,36.323394&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001694s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008792s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000651s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1737998641,`v1`=-1.052699,`v2`=0.114636,`v3`=-0.795372,`v4`=-0.810512,`v5`=6.3,`t`=-6.598709,`h`=73.750061,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.426814,36.323394',`update_time`=1737998642 WHERE `imei` = '868922055684209' [ RunTime:0.000603s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013486s ]
[ 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' , 1737998641 , -1.052699 , 0.114636 , -0.795372 , -0.810512 , 6.3 , -6.598709 , 73.750061 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.426814,36.323394' , 1737998642) [ RunTime:0.003648s ]
---------------------------------------------------------------
[ 2025-01-28T07:14:08+08:00 ] 39.144.112.38 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002751s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.045295s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001527s ]
---------------------------------------------------------------
[ 2025-01-28T07:14:09+08:00 ] 39.144.112.38 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1738019648&v1=-1.310118&v2=0.041451&v3=-1.051194&v4=-0.704739&v5=6.120000&t=-7.177864&h=82.272095&rssi=26&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001293s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009420s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000847s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1738019648,`v1`=-1.310118,`v2`=0.041451,`v3`=-1.051194,`v4`=-0.704739,`v5`=6.12,`t`=-7.177864,`h`=82.272095,`rssi`=26,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1738019649 WHERE `imei` = '868922055644021' [ RunTime:0.000744s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011481s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1738019648 , -1.310118 , 0.041451 , -1.051194 , -0.704739 , 6.12 , -7.177864 , 82.272095 , 26 , '898604650119C1053141' , '460048590503141' , -0 , 1738019649) [ RunTime:0.004137s ]
---------------------------------------------------------------
[ 2025-01-28T08:37:22+08:00 ] 1.29.85.135 GET /home/heating
[ sql ] [ DB ] CONNECT:[ UseTime:0.001954s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010367s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000345s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000682s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000670s ]
---------------------------------------------------------------
[ 2025-01-28T08:37:48+08:00 ] 1.29.85.135 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001618s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009358s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'heating' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001437s ]
---------------------------------------------------------------
[ 2025-01-28T08:37:49+08:00 ] 1.29.85.135 GET /home/heating/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002827s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009685s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.001497s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000939s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000813s ]
---------------------------------------------------------------
[ 2025-01-28T08:37:51+08:00 ] 1.29.85.135 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001889s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010967s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000799s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008471s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000546s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007624s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000489s ]
---------------------------------------------------------------
[ 2025-01-28T08:38:36+08:00 ] 1.29.85.135 GET /home/heating/data_analysis.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001776s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008884s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000419s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000849s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000825s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.008316s ]
[ 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.000350s ]
[ 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.000343s ]
---------------------------------------------------------------
[ 2025-01-28T08:38:48+08:00 ] 1.29.85.135 GET /home/heating/data_analysis.html?keyword=123&start_date=2025-01-18&end_date=2025-01-28
[ sql ] [ DB ] CONNECT:[ UseTime:0.001558s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008272s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000839s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000400s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000625s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000646s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.007483s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1737129600 AND `create_time` <= 1737993600 ) LIMIT 1 [ RunTime:0.002518s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1737129600 AND `create_time` <= 1737993600 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.001642s ]