--------------------------------------------------------------- [ 2025-02-14T00:15:52+08:00 ] 66.249.66.14 GET /admin/multipledata/delete/id/82.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002445s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.010047s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 82 [ RunTime:0.000676s ] --------------------------------------------------------------- [ 2025-02-14T00:27:34+08:00 ] 66.249.66.13 GET /admin/multipledata/delete/id/739.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002320s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009878s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 739 [ RunTime:0.006938s ] --------------------------------------------------------------- [ 2025-02-14T01:37:03+08:00 ] 111.55.120.20 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002149s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009930s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001497s ] --------------------------------------------------------------- [ 2025-02-14T01:37:04+08:00 ] 111.55.120.20 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1739468223&v1=-1.059623&v2=0.118159&v3=-1.012425&v4=-0.713950&v5=6.300000&t=0.351155&h=74.215454&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.429125,36.323787&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002451s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007832s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000638s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1739468223,`v1`=-1.059623,`v2`=0.118159,`v3`=-1.012425,`v4`=-0.71395,`v5`=6.3,`t`=0.351155,`h`=74.215454,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.429125,36.323787',`update_time`=1739468224 WHERE `imei` = '868922055684209' [ RunTime:0.000577s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014058s ] [ 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' , 1739468223 , -1.059623 , 0.118159 , -1.012425 , -0.71395 , 6.3 , 0.351155 , 74.215454 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.429125,36.323787' , 1739468224) [ RunTime:0.003655s ] --------------------------------------------------------------- [ 2025-02-14T01:37:45+08:00 ] 39.144.112.19 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002176s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008115s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001371s ] --------------------------------------------------------------- [ 2025-02-14T01:37:50+08:00 ] 39.144.112.19 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=250214&time=013701&v1=-00.059&v2=+00.001&v3=+00.019&v4=+00.007&v5=05.4&t=+00.8&h=73.8&rssi=+222&ccid=4600485905031430000099m9990000000036000000g0570,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002801s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010321s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000559s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='250214',`time`='013701',`v1`=-0.059,`v2`=0.001,`v3`=0.019,`v4`=0.007,`v5`=5.4,`t`=0.8,`h`=73.8,`rssi`=222,`ccid`='4600485905031430000099m9990000000036000000g0570,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1739468270 WHERE `imei` = '868922055644013' [ RunTime:0.001209s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.006715s ] [ 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' , '250214' , '013701' , -0.059 , 0.001 , 0.019 , 0.007 , 5.4 , 0.8 , 73.8 , 222 , '4600485905031430000099m9990000000036000000g0570,N,00E000=-00.000' , 0 , 0 , 1739468270 , 1739468270) [ RunTime:0.000414s ] --------------------------------------------------------------- [ 2025-02-14T02:46:45+08:00 ] 66.249.66.12 GET /admin/multipledata/delete/id/720.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002016s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008396s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 720 [ RunTime:0.001419s ] --------------------------------------------------------------- [ 2025-02-14T05:35:29+08:00 ] 66.249.66.11 GET /admin/multipledata/delete/id/4127.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002468s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008613s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4127 [ RunTime:0.001284s ] --------------------------------------------------------------- [ 2025-02-14T06:02:47+08:00 ] 66.249.66.12 GET /admin/multipledata/delete/id/410.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001838s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009070s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 410 [ RunTime:0.000528s ] --------------------------------------------------------------- [ 2025-02-14T06:28:35+08:00 ] 220.195.74.100 GET /home/heating/data_analysis.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002156s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.011950s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000323s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000632s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000919s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.008011s ] [ 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.000360s ] [ 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.000465s ] --------------------------------------------------------------- [ 2025-02-14T06:28:49+08:00 ] 220.195.74.100 GET /home/heating/data_analysis.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001353s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008582s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000352s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000682s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000678s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.007994s ] [ 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.000342s ] [ 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.000420s ] --------------------------------------------------------------- [ 2025-02-14T06:29:12+08:00 ] 220.195.74.100 GET /home/heating/data_analysis.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001452s ] 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` IS NULL LIMIT 1 [ RunTime:0.000335s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000675s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000722s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.008133s ] [ 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.000321s ] [ 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.000405s ] --------------------------------------------------------------- [ 2025-02-14T07:48:07+08:00 ] 39.144.112.14 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002086s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009864s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001344s ] --------------------------------------------------------------- [ 2025-02-14T07:48:08+08:00 ] 39.144.112.14 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1739490487&v1=-1.324325&v2=0.065108&v3=-1.073439&v4=-0.689448&v5=6.120000&t=-2.995076&h=82.592529&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001925s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007601s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000636s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1739490487,`v1`=-1.324325,`v2`=0.065108,`v3`=-1.073439,`v4`=-0.689448,`v5`=6.12,`t`=-2.995076,`h`=82.592529,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1739490488 WHERE `imei` = '868922055644021' [ RunTime:0.000621s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013268s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1739490487 , -1.324325 , 0.065108 , -1.073439 , -0.689448 , 6.12 , -2.995076 , 82.592529 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1739490488) [ RunTime:0.003296s ] --------------------------------------------------------------- [ 2025-02-14T08:21:15+08:00 ] 66.249.66.10 GET /admin/multipledata/delete/id/832.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002016s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008379s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 832 [ RunTime:0.001265s ] --------------------------------------------------------------- [ 2025-02-14T10:39:43+08:00 ] 66.249.66.12 GET /admin/multipledata/delete/id/787.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002898s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008576s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 787 [ RunTime:0.000901s ] --------------------------------------------------------------- [ 2025-02-14T12:58:11+08:00 ] 66.249.66.11 GET /admin/multipledata/delete/id/3440.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002979s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008775s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 3440 [ RunTime:0.001344s ] --------------------------------------------------------------- [ 2025-02-14T17:35:06+08:00 ] 66.249.66.13 GET /admin/multipledata/delete/id/743.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002701s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.010056s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 743 [ RunTime:0.000691s ] --------------------------------------------------------------- [ 2025-02-14T17:35:12+08:00 ] 66.249.66.12 GET /admin/multipledata/delete.html [ error ] [0]方法参数错误:id --------------------------------------------------------------- [ 2025-02-14T19:53:34+08:00 ] 66.249.66.13 GET /admin/multipledata/delete/id/3337.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003155s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009232s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 3337 [ RunTime:0.001280s ] --------------------------------------------------------------- [ 2025-02-14T19:53:37+08:00 ] 66.249.66.12 GET /admin/multipledata/delete.html [ error ] [0]方法参数错误:id --------------------------------------------------------------- [ 2025-02-14T22:12:01+08:00 ] 66.249.74.129 GET /admin/multipledata/delete/id/3222.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002240s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009208s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 3222 [ RunTime:0.000535s ]