--------------------------------------------------------------- [ 2025-03-08T01:33:22+08:00 ] 111.55.120.73 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.003104s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012801s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001921s ] --------------------------------------------------------------- [ 2025-03-08T01:33:30+08:00 ] 111.55.120.73 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=250308&time=013301&v1=-00.067&v2=+00.001&v3=+00.011&v4=+00.003&v5=05.4&t=+03.7&h=73.3&rssi=+223&ccid=4600485905031430000099m9990000000030000000g0640,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002128s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008589s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000786s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='250308',`time`='013301',`v1`=-0.067,`v2`=0.001,`v3`=0.011,`v4`=0.003,`v5`=5.4,`t`=3.7,`h`=73.3,`rssi`=223,`ccid`='4600485905031430000099m9990000000030000000g0640,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1741368810 WHERE `imei` = '868922055644013' [ RunTime:0.000794s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014546s ] [ 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' , '250308' , '013301' , -0.067 , 0.001 , 0.011 , 0.003 , 5.4 , 3.7 , 73.3 , 223 , '4600485905031430000099m9990000000030000000g0640,N,00E000=-00.000' , 0 , 0 , 1741368810 , 1741368810) [ RunTime:0.003029s ] --------------------------------------------------------------- [ 2025-03-08T02:01:28+08:00 ] 39.144.112.43 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002486s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014187s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000640s ] --------------------------------------------------------------- [ 2025-03-08T02:01:29+08:00 ] 39.144.112.43 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1741370488&v1=-1.212051&v2=0.132430&v3=-1.173221&v4=-0.716780&v5=6.120000&t=3.815361&h=73.856873&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428452,36.323164&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001736s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007569s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000559s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1741370488,`v1`=-1.212051,`v2`=0.13243,`v3`=-1.173221,`v4`=-0.71678,`v5`=6.12,`t`=3.815361,`h`=73.856873,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428452,36.323164',`update_time`=1741370489 WHERE `imei` = '868922055684209' [ RunTime:0.000497s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007380s ] [ 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' , 1741370488 , -1.212051 , 0.13243 , -1.173221 , -0.71678 , 6.12 , 3.815361 , 73.856873 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428452,36.323164' , 1741370489) [ RunTime:0.001316s ] --------------------------------------------------------------- [ 2025-03-08T04:10:08+08:00 ] 66.249.66.10 GET /admin/multipledata/delete/id/9165.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002090s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009027s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 9165 [ RunTime:0.000534s ] --------------------------------------------------------------- [ 2025-03-08T04:10:14+08:00 ] 66.249.66.10 GET /admin/multipledata/delete.html [ error ] [0]方法参数错误:id --------------------------------------------------------------- [ 2025-03-08T08:32:06+08:00 ] 111.55.120.44 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002067s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009278s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000712s ] --------------------------------------------------------------- [ 2025-03-08T08:32:11+08:00 ] 111.55.120.44 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1741393801&v1=-1.326974&v2=0.087957&v3=-1.073709&v4=-0.747121&v5=6.480000&t=5.563552&h=81.829590&rssi=25&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001820s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009658s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000719s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1741393801,`v1`=-1.326974,`v2`=0.087957,`v3`=-1.073709,`v4`=-0.747121,`v5`=6.48,`t`=5.563552,`h`=81.82959,`rssi`=25,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1741393931 WHERE `imei` = '868922055644021' [ RunTime:0.000525s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009543s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1741393801 , -1.326974 , 0.087957 , -1.073709 , -0.747121 , 6.48 , 5.563552 , 81.82959 , 25 , '898604650119C1053141' , '460048590503141' , -0 , 1741393931) [ RunTime:0.000738s ] --------------------------------------------------------------- [ 2025-03-08T09:39:07+08:00 ] 1.27.108.47 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.002243s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010629s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000476s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000637s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000754s ] --------------------------------------------------------------- [ 2025-03-08T09:39:26+08:00 ] 1.27.108.47 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001422s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.008477s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'heating' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001396s ] --------------------------------------------------------------- [ 2025-03-08T09:39:28+08:00 ] 1.27.108.47 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001795s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008766s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000507s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001729s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000759s ] --------------------------------------------------------------- [ 2025-03-08T09:39:29+08:00 ] 1.27.108.47 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001470s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010198s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000835s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008686s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007970s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000522s ] --------------------------------------------------------------- [ 2025-03-08T23:29:26+08:00 ] 66.249.74.129 GET /admin/multipledata/delete/id/659.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002811s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009991s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 659 [ RunTime:0.000543s ]