--------------------------------------------------------------- [ 2025-03-03T01:55:05+08:00 ] 39.144.112.22 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002144s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009891s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001367s ] --------------------------------------------------------------- [ 2025-03-03T01:55:06+08:00 ] 39.144.112.22 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1740938105&v1=-1.067930&v2=0.150160&v3=-1.038552&v4=-0.687763&v5=6.300000&t=1.284238&h=73.788208&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001469s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009167s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000647s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1740938105,`v1`=-1.06793,`v2`=0.15016,`v3`=-1.038552,`v4`=-0.687763,`v5`=6.3,`t`=1.284238,`h`=73.788208,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1740938106 WHERE `imei` = '868922055684209' [ RunTime:0.000529s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010657s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1740938105 , -1.06793 , 0.15016 , -1.038552 , -0.687763 , 6.3 , 1.284238 , 73.788208 , 31 , '898604650119C1078511' , '460048590708511' , -0 , 1740938106) [ RunTime:0.003502s ] --------------------------------------------------------------- [ 2025-03-03T08:22:06+08:00 ] 111.55.120.26 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.003261s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010714s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001409s ] --------------------------------------------------------------- [ 2025-03-03T08:22:07+08:00 ] 111.55.120.26 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1740961326&v1=-1.317643&v2=0.082253&v3=-1.061760&v4=-0.652305&v5=6.300000&t=0.490581&h=82.264465&rssi=27&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001268s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008175s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000686s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1740961326,`v1`=-1.317643,`v2`=0.082253,`v3`=-1.06176,`v4`=-0.652305,`v5`=6.3,`t`=0.490581,`h`=82.264465,`rssi`=27,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1740961327 WHERE `imei` = '868922055644021' [ RunTime:0.000772s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010180s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1740961326 , -1.317643 , 0.082253 , -1.06176 , -0.652305 , 6.3 , 0.490581 , 82.264465 , 27 , '898604650119C1053141' , '460048590503141' , -0 , 1740961327) [ RunTime:0.003033s ] --------------------------------------------------------------- [ 2025-03-03T11:33:01+08:00 ] 144.12.141.116 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002749s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012190s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'duolucaijiyi' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001373s ] --------------------------------------------------------------- [ 2025-03-03T11:33:03+08:00 ] 144.12.141.116 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001345s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009610s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000699s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.007999s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000842s ] --------------------------------------------------------------- [ 2025-03-03T11:33:10+08:00 ] 144.12.141.116 GET /home/data/multipledata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001381s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010242s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000386s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000485s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000415s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.007883s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.050881s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.002709s ] --------------------------------------------------------------- [ 2025-03-03T11:33:49+08:00 ] 144.12.141.116 GET /home/data/multipledata.html?keyword=862810047311997&start_date=2024-01-01&end_date=2024-12-31 [ sql ] [ DB ] CONNECT:[ UseTime:0.001399s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.007834s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' AND `imei` = '862810047311997' LIMIT 1 [ RunTime:0.000591s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000426s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000410s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000532s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.007696s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1704038400 AND `update_time` <= 1735574400 ) LIMIT 1 [ RunTime:0.003287s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1704038400 AND `update_time` <= 1735574400 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.007902s ] --------------------------------------------------------------- [ 2025-03-03T17:32:19+08:00 ] 1.27.108.47 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.003142s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.013212s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000393s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000668s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000765s ] --------------------------------------------------------------- [ 2025-03-03T17:32:25+08:00 ] 1.27.108.47 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.008918s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000631s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000717s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000670s ] --------------------------------------------------------------- [ 2025-03-03T17:32:36+08:00 ] 1.27.108.47 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001355s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.007684s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'heating' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001290s ] --------------------------------------------------------------- [ 2025-03-03T17:32:37+08:00 ] 1.27.108.47 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001518s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008806s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000475s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000778s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000629s ] --------------------------------------------------------------- [ 2025-03-03T17:32:38+08:00 ] 1.27.108.47 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002487s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010064s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.001051s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.010590s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000785s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.009322s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000846s ] --------------------------------------------------------------- [ 2025-03-03T17:33:03+08:00 ] 1.27.108.47 GET /home/heating/data_analysis.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002345s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010510s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000512s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001044s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000931s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.009948s ] [ 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.000382s ] [ 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.000453s ] --------------------------------------------------------------- [ 2025-03-03T17:33:12+08:00 ] 1.27.108.47 GET /home/heating/data_analysis.html?keyword=123&start_date=2025-03-01&end_date=2025-03-03 [ sql ] [ DB ] CONNECT:[ UseTime:0.001994s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010715s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.001565s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000682s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000675s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.026846s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1740758400 AND `create_time` <= 1740931200 ) LIMIT 1 [ RunTime:0.004361s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1740758400 AND `create_time` <= 1740931200 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.001600s ]