--------------------------------------------------------------- [ 2025-04-10T01:27:52+08:00 ] 111.55.120.38 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002092s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.562100s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001545s ] --------------------------------------------------------------- [ 2025-04-10T01:28:00+08:00 ] 111.55.120.38 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=250410&time=012701&v1=-00.063&v2=+00.001&v3=-00.004&v4=+00.008&v5=05.4&t=+09.1&h=72.5&rssi=+222&ccid=4600485905031430000099m9990000000019000000g0640,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001569s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008138s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000668s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='250410',`time`='012701',`v1`=-0.063,`v2`=0.001,`v3`=-0.004,`v4`=0.008,`v5`=5.4,`t`=9.1,`h`=72.5,`rssi`=222,`ccid`='4600485905031430000099m9990000000019000000g0640,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1744219680 WHERE `imei` = '868922055644013' [ RunTime:0.000628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012293s ] [ 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' , '250410' , '012701' , -0.063 , 0.001 , -0.004 , 0.008 , 5.4 , 9.1 , 72.5 , 222 , '4600485905031430000099m9990000000019000000g0640,N,00E000=-00.000' , 0 , 0 , 1744219680 , 1744219680) [ RunTime:0.003932s ] --------------------------------------------------------------- [ 2025-04-10T02:34:14+08:00 ] 111.55.120.6 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002500s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029765s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000616s ] --------------------------------------------------------------- [ 2025-04-10T02:34:15+08:00 ] 111.55.120.6 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1744223654&v1=-1.105315&v2=0.227634&v3=-0.937987&v4=-0.816352&v5=6.300000&t=6.925640&h=73.658508&rssi=29&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428370,36.322949&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001523s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007605s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000576s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1744223654,`v1`=-1.105315,`v2`=0.227634,`v3`=-0.937987,`v4`=-0.816352,`v5`=6.3,`t`=6.92564,`h`=73.658508,`rssi`=29,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428370,36.322949',`update_time`=1744223655 WHERE `imei` = '868922055684209' [ RunTime:0.000450s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007301s ] [ 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' , 1744223654 , -1.105315 , 0.227634 , -0.937987 , -0.816352 , 6.3 , 6.92564 , 73.658508 , 29 , '898604650119C1078511' , '460048590708511' , -0 , '120.428370,36.322949' , 1744223655) [ RunTime:0.000647s ] --------------------------------------------------------------- [ 2025-04-10T09:38:05+08:00 ] 39.144.112.44 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002125s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011344s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000711s ] --------------------------------------------------------------- [ 2025-04-10T09:38:06+08:00 ] 39.144.112.44 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1744249085&v1=-1.337569&v2=0.049571&v3=-1.168195&v4=-0.490606&v5=6.120000&t=17.747263&h=79.884094&rssi=23&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001785s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.526267s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000614s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1744249085,`v1`=-1.337569,`v2`=0.049571,`v3`=-1.168195,`v4`=-0.490606,`v5`=6.12,`t`=17.747263,`h`=79.884094,`rssi`=23,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1744249086 WHERE `imei` = '868922055644021' [ RunTime:0.000502s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008982s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1744249085 , -1.337569 , 0.049571 , -1.168195 , -0.490606 , 6.12 , 17.747263 , 79.884094 , 23 , '898604650119C1053141' , '460048590503141' , -0 , 1744249086) [ RunTime:0.000558s ] --------------------------------------------------------------- [ 2025-04-10T10:52:40+08:00 ] 111.55.120.49 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002589s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009788s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000596s ] --------------------------------------------------------------- [ 2025-04-10T10:52:49+08:00 ] 111.55.120.49 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=250410&time=105201&v1=-01.014&v2=+00.015&v3=-00.836&v4=-00.455&v5=04.0&t=+26.8&h=80.7&rssi=+201&imsi=460044618415249&v6=-00.000&a1=00.216&a2=01.098&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002585s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007725s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000596s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='250410',`time`='105201',`v1`=-1.014,`v2`=0.015,`v3`=-0.836,`v4`=-0.455,`v5`=4,`t`=26.8,`h`=80.7,`rssi`=201,`imsi`='460044618415249',`v6`=-0,`a1`=0.216,`a2`=1.098,`update_time`=1744253569 WHERE `imei` = '868922055684076' [ RunTime:0.000485s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008176s ] [ 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' , '250410' , '105201' , -1.014 , 0.015 , -0.836 , -0.455 , 4 , 26.8 , 80.7 , 201 , '460044618415249' , -0 , 0.216 , 1.098 , 1744253569 , 1744253569) [ RunTime:0.001333s ] --------------------------------------------------------------- [ 2025-04-10T11:46:52+08:00 ] 220.195.79.8 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.002321s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.063800s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000431s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000771s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000706s ] --------------------------------------------------------------- [ 2025-04-10T11:46:57+08:00 ] 220.195.79.8 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002609s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.288770s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000846s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.009608s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000513s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007492s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000506s ] --------------------------------------------------------------- [ 2025-04-10T11:47:38+08:00 ] 220.195.79.8 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001653s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008947s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000839s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007433s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007453s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000563s ] --------------------------------------------------------------- [ 2025-04-10T20:28:04+08:00 ] 124.129.68.232 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002863s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.046243s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'heating1' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001438s ] --------------------------------------------------------------- [ 2025-04-10T20:28:05+08:00 ] 124.129.68.232 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001323s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008697s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating1' LIMIT 1 [ RunTime:0.000486s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000836s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating1' ORDER BY `id` DESC [ RunTime:0.001378s ] --------------------------------------------------------------- [ 2025-04-10T20:28:07+08:00 ] 124.129.68.232 GET /home/heating/communication/id/4/unique_identification_number/456.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001425s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009092s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 4 LIMIT 1 [ RunTime:0.001188s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008834s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '456' ORDER BY `id` ASC [ RunTime:0.000587s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007372s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '456' LIMIT 1 [ RunTime:0.000575s ] --------------------------------------------------------------- [ 2025-04-10T20:28:19+08:00 ] 27.115.124.101 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001339s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009001s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000327s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000699s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000767s ] --------------------------------------------------------------- [ 2025-04-10T20:28:19+08:00 ] 27.115.124.101 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001611s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009331s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000304s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000659s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000699s ]