--------------------------------------------------------------- [ 2025-04-07T00:38:02+08:00 ] 66.249.77.162 GET /admin/multipleshow/read/id/16/imei/863412043560864.html?page=26%27%29%29%0CAS%09vSTf%09WHERE%0A3333%3D3333%0DAND%099610%3D2491--%0DcXYj [ sql ] [ DB ] CONNECT:[ UseTime:0.002123s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.008662s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000560s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008475s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043560864' LIMIT 1 [ RunTime:0.055459s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043560864' ORDER BY `update_time` DESC LIMIT 250,10 [ RunTime:0.003501s ] --------------------------------------------------------------- [ 2025-04-07T01:27:53+08:00 ] 39.144.112.10 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001977s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.217981s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000678s ] --------------------------------------------------------------- [ 2025-04-07T01:28:00+08:00 ] 39.144.112.10 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=250407&time=012701&v1=-00.059&v2=+00.001&v3=+00.019&v4=+00.009&v5=05.6&t=+13.1&h=71.7&rssi=+222&ccid=4600485905031430000099m9990000000036000000g0560,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001483s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008120s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000561s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='250407',`time`='012701',`v1`=-0.059,`v2`=0.001,`v3`=0.019,`v4`=0.009,`v5`=5.6,`t`=13.1,`h`=71.7,`rssi`=222,`ccid`='4600485905031430000099m9990000000036000000g0560,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1743960480 WHERE `imei` = '868922055644013' [ RunTime:0.000453s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007595s ] [ 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' , '250407' , '012701' , -0.059 , 0.001 , 0.019 , 0.009 , 5.6 , 13.1 , 71.7 , 222 , '4600485905031430000099m9990000000036000000g0560,N,00E000=-00.000' , 0 , 0 , 1743960480 , 1743960480) [ RunTime:0.000525s ] --------------------------------------------------------------- [ 2025-04-07T02:30:58+08:00 ] 111.55.120.78 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002538s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.564644s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000732s ] --------------------------------------------------------------- [ 2025-04-07T02:30:59+08:00 ] 111.55.120.78 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1743964258&v1=-1.079489&v2=0.118223&v3=-0.951502&v4=-0.807382&v5=6.300000&t=14.422482&h=72.750610&rssi=29&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428357,36.323251&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001735s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008127s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000625s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1743964258,`v1`=-1.079489,`v2`=0.118223,`v3`=-0.951502,`v4`=-0.807382,`v5`=6.3,`t`=14.422482,`h`=72.75061,`rssi`=29,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428357,36.323251',`update_time`=1743964259 WHERE `imei` = '868922055684209' [ RunTime:0.000488s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008249s ] [ 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' , 1743964258 , -1.079489 , 0.118223 , -0.951502 , -0.807382 , 6.3 , 14.422482 , 72.75061 , 29 , '898604650119C1078511' , '460048590708511' , -0 , '120.428357,36.323251' , 1743964259) [ RunTime:0.000548s ] --------------------------------------------------------------- [ 2025-04-07T03:38:02+08:00 ] 66.249.77.161 GET /admin/multipleshow/read/id/16/imei/863412043560864.html?page=-4193%22%29%29%0DOR%0D6839%3D%28SELECT%0C%28CASE%0AWHEN%0A%286839%3D6839%29%0ATHEN%0A6839%0CELSE%0A%28SELECT%0D6000%0AUNION%0ASELECT%0A7078%29%09END%29%29--%0CFhTT [ sql ] [ DB ] CONNECT:[ UseTime:0.002670s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.237734s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000889s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.012237s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043560864' LIMIT 1 [ RunTime:0.005548s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043560864' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.005380s ] --------------------------------------------------------------- [ 2025-04-07T05:56:29+08:00 ] 66.249.77.160 GET /admin/multipleshow/read/id/16/imei/863412043560864.html?page=100 [ sql ] [ DB ] CONNECT:[ UseTime:0.002048s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.009223s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000597s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.007952s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043560864' LIMIT 1 [ RunTime:0.003144s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043560864' ORDER BY `update_time` DESC LIMIT 990,10 [ RunTime:0.003521s ] --------------------------------------------------------------- [ 2025-04-07T09:32:06+08:00 ] 111.55.120.82 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002179s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010545s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000716s ] --------------------------------------------------------------- [ 2025-04-07T09:32:08+08:00 ] 111.55.120.82 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1743989526&v1=-1.343228&v2=0.036034&v3=-1.174546&v4=-0.683850&v5=6.480000&t=21.511772&h=79.670471&rssi=26&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001566s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.539863s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000688s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1743989526,`v1`=-1.343228,`v2`=0.036034,`v3`=-1.174546,`v4`=-0.68385,`v5`=6.48,`t`=21.511772,`h`=79.670471,`rssi`=26,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1743989528 WHERE `imei` = '868922055644021' [ RunTime:0.000614s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008572s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1743989526 , -1.343228 , 0.036034 , -1.174546 , -0.68385 , 6.48 , 21.511772 , 79.670471 , 26 , '898604650119C1053141' , '460048590503141' , -0 , 1743989528) [ RunTime:0.000750s ] --------------------------------------------------------------- [ 2025-04-07T10:53:51+08:00 ] 111.55.120.37 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.424602s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.587420s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000626s ] --------------------------------------------------------------- [ 2025-04-07T10:53:59+08:00 ] 111.55.120.37 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=250407&time=105301&v1=-01.052&v2=+00.016&v3=-00.800&v4=-00.490&v5=04.6&t=+30.3&h=80.4&rssi=+231&imsi=460044618415249&v6=-00.000&a1=00.278&a2=01.121&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001500s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.446290s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000825s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='250407',`time`='105301',`v1`=-1.052,`v2`=0.016,`v3`=-0.8,`v4`=-0.49,`v5`=4.6,`t`=30.3,`h`=80.4,`rssi`=231,`imsi`='460044618415249',`v6`=-0,`a1`=0.278,`a2`=1.121,`update_time`=1743994439 WHERE `imei` = '868922055684076' [ RunTime:0.000628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010833s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '250407' , '105301' , -1.052 , 0.016 , -0.8 , -0.49 , 4.6 , 30.3 , 80.4 , 231 , '460044618415249' , -0 , 0.278 , 1.121 , 1743994439 , 1743994439) [ RunTime:0.001513s ] --------------------------------------------------------------- [ 2025-04-07T16:46:23+08:00 ] 220.195.78.164 GET /home/heating/data_analysis.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002189s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.419757s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000536s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000764s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000726s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.007890s ] [ 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.000343s ] [ 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.000369s ] --------------------------------------------------------------- [ 2025-04-07T16:46:34+08:00 ] 220.195.78.164 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001645s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.139959s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000418s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000766s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000641s ] --------------------------------------------------------------- [ 2025-04-07T16:46:38+08:00 ] 220.195.78.164 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001463s ] 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 `id` = 2 LIMIT 1 [ RunTime:0.000868s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008348s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000594s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008055s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000576s ] --------------------------------------------------------------- [ 2025-04-07T16:48:51+08:00 ] 220.195.78.164 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001799s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008826s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000835s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.006972s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000505s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007567s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000512s ] --------------------------------------------------------------- [ 2025-04-07T16:48:58+08:00 ] 220.195.78.164 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001743s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009113s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000896s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007484s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000510s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007129s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000526s ] --------------------------------------------------------------- [ 2025-04-07T16:48:59+08:00 ] 220.195.78.164 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.003038s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008823s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000513s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001020s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000696s ]