--------------------------------------------------------------- [ 2025-01-31T01:25:58+08:00 ] 111.55.120.90 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002135s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011604s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001709s ] --------------------------------------------------------------- [ 2025-01-31T01:26:00+08:00 ] 111.55.120.90 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1738257958&v1=-1.045355&v2=0.062128&v3=-0.793535&v4=-0.801422&v5=6.300000&t=-1.740239&h=74.009460&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428090,36.324946&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001851s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008487s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000661s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1738257958,`v1`=-1.045355,`v2`=0.062128,`v3`=-0.793535,`v4`=-0.801422,`v5`=6.3,`t`=-1.740239,`h`=74.00946,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428090,36.324946',`update_time`=1738257960 WHERE `imei` = '868922055684209' [ RunTime:0.000731s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012376s ] [ 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' , 1738257958 , -1.045355 , 0.062128 , -0.793535 , -0.801422 , 6.3 , -1.740239 , 74.00946 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428090,36.324946' , 1738257960) [ RunTime:0.004248s ] --------------------------------------------------------------- [ 2025-01-31T06:56:01+08:00 ] 45.116.153.134 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001986s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010249s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000905s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.009634s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000554s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008166s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000541s ] --------------------------------------------------------------- [ 2025-01-31T06:56:58+08:00 ] 45.116.153.134 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001403s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009137s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000425s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000768s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000649s ] --------------------------------------------------------------- [ 2025-01-31T06:56:59+08:00 ] 45.116.153.134 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001399s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010346s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000903s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.010773s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000458s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008087s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000484s ] --------------------------------------------------------------- [ 2025-01-31T07:20:06+08:00 ] 111.55.120.10 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002100s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008994s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001333s ] --------------------------------------------------------------- [ 2025-01-31T07:20:08+08:00 ] 111.55.120.10 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1738279206&v1=-1.320051&v2=0.040419&v3=-1.064830&v4=-0.779268&v5=6.300000&t=-0.549753&h=82.493347&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001639s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008426s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000634s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1738279206,`v1`=-1.320051,`v2`=0.040419,`v3`=-1.06483,`v4`=-0.779268,`v5`=6.3,`t`=-0.549753,`h`=82.493347,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1738279208 WHERE `imei` = '868922055644021' [ RunTime:0.000503s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008051s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1738279206 , -1.320051 , 0.040419 , -1.06483 , -0.779268 , 6.3 , -0.549753 , 82.493347 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1738279208) [ RunTime:0.001507s ] --------------------------------------------------------------- [ 2025-01-31T11:08:30+08:00 ] 66.249.75.64 GET /admin/multipledata/delete/id/4127.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003431s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.011904s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4127 [ RunTime:0.000541s ] --------------------------------------------------------------- [ 2025-01-31T11:12:30+08:00 ] 66.249.75.65 GET /admin/multipledata/delete/id/4121.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002716s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.007817s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4121 [ RunTime:0.000514s ] --------------------------------------------------------------- [ 2025-01-31T22:07:38+08:00 ] 120.225.172.121 GET / [ sql ] [ DB ] CONNECT:[ UseTime:0.002840s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011600s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.001288s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000554s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000560s ] --------------------------------------------------------------- [ 2025-01-31T22:07:40+08:00 ] 120.225.172.121 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001612s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.012131s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000495s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000734s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000722s ] --------------------------------------------------------------- [ 2025-01-31T22:07:43+08:00 ] 120.225.172.121 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.009042s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000882s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.009285s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000937s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007324s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000522s ]