--------------------------------------------------------------- [ 2025-01-20T01:16:59+08:00 ] 39.144.112.44 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002210s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010292s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001515s ] --------------------------------------------------------------- [ 2025-01-20T01:17:01+08:00 ] 39.144.112.44 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1737307019&v1=-1.031388&v2=0.143881&v3=-0.745826&v4=-0.815629&v5=6.300000&t=-4.636015&h=74.451965&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.426598,36.323436&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003619s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008605s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000682s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1737307019,`v1`=-1.031388,`v2`=0.143881,`v3`=-0.745826,`v4`=-0.815629,`v5`=6.3,`t`=-4.636015,`h`=74.451965,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.426598,36.323436',`update_time`=1737307021 WHERE `imei` = '868922055684209' [ RunTime:0.000563s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013367s ] [ 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' , 1737307019 , -1.031388 , 0.143881 , -0.745826 , -0.815629 , 6.3 , -4.636015 , 74.451965 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.426598,36.323436' , 1737307021) [ RunTime:0.003623s ] --------------------------------------------------------------- [ 2025-01-20T06:58:07+08:00 ] 111.55.120.94 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002053s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012146s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001450s ] --------------------------------------------------------------- [ 2025-01-20T06:58:08+08:00 ] 111.55.120.94 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1737327487&v1=-1.307168&v2=0.050784&v3=-1.042044&v4=-0.688064&v5=6.300000&t=-6.888286&h=82.790894&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002226s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010237s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000732s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1737327487,`v1`=-1.307168,`v2`=0.050784,`v3`=-1.042044,`v4`=-0.688064,`v5`=6.3,`t`=-6.888286,`h`=82.790894,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1737327488 WHERE `imei` = '868922055644021' [ RunTime:0.000598s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011731s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1737327487 , -1.307168 , 0.050784 , -1.042044 , -0.688064 , 6.3 , -6.888286 , 82.790894 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1737327488) [ RunTime:0.001821s ] --------------------------------------------------------------- [ 2025-01-20T10:06:21+08:00 ] 218.56.88.228 GET / [ sql ] [ DB ] CONNECT:[ UseTime:0.003801s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011643s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.001306s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000546s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000692s ] --------------------------------------------------------------- [ 2025-01-20T10:06:23+08:00 ] 218.56.88.228 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001923s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.013567s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000626s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001049s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.001246s ] --------------------------------------------------------------- [ 2025-01-20T10:06:25+08:00 ] 218.56.88.228 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002000s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008973s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000793s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008651s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000542s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007015s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000487s ] --------------------------------------------------------------- [ 2025-01-20T11:22:15+08:00 ] 66.249.74.64 GET /admin/multipledata/delete/id/6382.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001977s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.012055s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 6382 [ RunTime:0.001259s ] --------------------------------------------------------------- [ 2025-01-20T11:22:18+08:00 ] 66.249.74.65 GET /admin/multipledata/delete.html [ error ] [0]方法参数错误:id --------------------------------------------------------------- [ 2025-01-20T14:49:56+08:00 ] 66.249.74.66 GET /admin/multipledata/delete/id/3733.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002027s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009238s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 3733 [ RunTime:0.000522s ] --------------------------------------------------------------- [ 2025-01-20T18:02:37+08:00 ] 27.115.124.70 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002081s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009241s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000920s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008145s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000583s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007773s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000527s ] --------------------------------------------------------------- [ 2025-01-20T18:03:21+08:00 ] 27.115.124.101 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.001263s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009135s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000475s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000683s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000680s ] --------------------------------------------------------------- [ 2025-01-20T18:03:21+08:00 ] 27.115.124.101 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.001244s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008555s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000460s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000963s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000681s ] --------------------------------------------------------------- [ 2025-01-20T19:26:51+08:00 ] 66.249.74.64 GET /admin/multipleshow/read/id/16/imei/863412043560864.html?page=-3451%09WHERE%0D5440%3D5440%0COR%0D1824%3D6980--%09ERhi [ sql ] [ DB ] CONNECT:[ UseTime:0.001999s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010710s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000535s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008005s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043560864' LIMIT 1 [ RunTime:0.015538s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043560864' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001660s ] --------------------------------------------------------------- [ 2025-01-20T21:45:19+08:00 ] 66.249.74.64 GET /admin/multipledata/delete/id/1529.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002365s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009374s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 1529 [ RunTime:0.000533s ]