--------------------------------------------------------------- [ 2025-01-17T01:14:12+08:00 ] 111.55.120.64 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002943s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010503s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001568s ] --------------------------------------------------------------- [ 2025-01-17T01:14:14+08:00 ] 111.55.120.64 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1737047652&v1=-1.028137&v2=0.103079&v3=-0.757355&v4=-0.818880&v5=6.300000&t=-7.027712&h=74.245972&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.429853,36.323804&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001908s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008824s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000677s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1737047652,`v1`=-1.028137,`v2`=0.103079,`v3`=-0.757355,`v4`=-0.81888,`v5`=6.3,`t`=-7.027712,`h`=74.245972,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.429853,36.323804',`update_time`=1737047654 WHERE `imei` = '868922055684209' [ RunTime:0.000578s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009531s ] [ 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' , 1737047652 , -1.028137 , 0.103079 , -0.757355 , -0.81888 , 6.3 , -7.027712 , 74.245972 , 27 , '898604650119C1078511' , '460048590708511' , -0 , '120.429853,36.323804' , 1737047654) [ RunTime:0.003974s ] --------------------------------------------------------------- [ 2025-01-17T06:31:24+08:00 ] 66.249.75.65 GET /admin/multipledata/delete/id/4919.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003217s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.010717s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4919 [ RunTime:0.000525s ] --------------------------------------------------------------- [ 2025-01-17T06:34:00+08:00 ] 66.249.75.66 GET /admin/multipledata/delete/id/4921.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001593s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008766s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4921 [ RunTime:0.000494s ] --------------------------------------------------------------- [ 2025-01-17T06:43:27+08:00 ] 66.249.75.66 GET /admin/multipledata/delete/id/6.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002157s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009713s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 6 [ RunTime:0.000508s ] --------------------------------------------------------------- [ 2025-01-17T06:44:48+08:00 ] 66.249.75.64 GET /admin/multipledata/delete/id/4159.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001541s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008529s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4159 [ RunTime:0.000523s ] --------------------------------------------------------------- [ 2025-01-17T06:52:08+08:00 ] 111.55.120.83 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.001970s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010484s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001622s ] --------------------------------------------------------------- [ 2025-01-17T06:52:09+08:00 ] 111.55.120.83 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1737067928&v1=-1.296271&v2=0.031979&v3=-1.045957&v4=-0.668499&v5=6.300000&t=-8.840254&h=82.562012&rssi=25&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.008040s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1737067928,`v1`=-1.296271,`v2`=0.031979,`v3`=-1.045957,`v4`=-0.668499,`v5`=6.3,`t`=-8.840254,`h`=82.562012,`rssi`=25,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1737067929 WHERE `imei` = '868922055644021' [ RunTime:0.000621s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011736s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1737067928 , -1.296271 , 0.031979 , -1.045957 , -0.668499 , 6.3 , -8.840254 , 82.562012 , 25 , '898604650119C1053141' , '460048590503141' , -0 , 1737067929) [ RunTime:0.003704s ] --------------------------------------------------------------- [ 2025-01-17T07:00:10+08:00 ] 66.249.75.66 GET /admin/multipledata/delete/id/4161.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002105s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009553s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4161 [ RunTime:0.000497s ] --------------------------------------------------------------- [ 2025-01-17T07:03:10+08:00 ] 66.249.75.66 GET /admin/multipledata/delete/id/4164.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001567s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.007904s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4164 [ RunTime:0.000500s ] --------------------------------------------------------------- [ 2025-01-17T08:26:21+08:00 ] 218.56.88.228 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002518s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.014513s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'heating' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001456s ] --------------------------------------------------------------- [ 2025-01-17T08:26:22+08:00 ] 218.56.88.228 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001432s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010229s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000508s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000837s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000795s ] --------------------------------------------------------------- [ 2025-01-17T08:26:24+08:00 ] 218.56.88.228 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001532s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008438s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000821s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008242s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000547s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007428s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000498s ] --------------------------------------------------------------- [ 2025-01-17T08:27:43+08:00 ] 218.56.88.228 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002342s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009131s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000894s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008036s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000509s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008054s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000542s ] --------------------------------------------------------------- [ 2025-01-17T08:28:21+08:00 ] 218.56.88.228 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001681s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008564s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000757s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.006569s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000480s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007702s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000487s ] --------------------------------------------------------------- [ 2025-01-17T08:29:38+08:00 ] 218.56.88.228 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001600s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008228s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000792s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.006804s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000457s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.006777s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000474s ] --------------------------------------------------------------- [ 2025-01-17T08:30:04+08:00 ] 218.56.88.228 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001689s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008308s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000813s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008105s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000466s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007065s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000496s ] --------------------------------------------------------------- [ 2025-01-17T12:03:59+08:00 ] 66.249.75.64 GET /admin/multipledata/delete/id/4799.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002615s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008945s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4799 [ RunTime:0.000508s ] --------------------------------------------------------------- [ 2025-01-17T12:04:53+08:00 ] 66.249.75.66 GET /admin/multipledata/delete.html [ error ] [0]方法参数错误:id --------------------------------------------------------------- [ 2025-01-17T14:22:49+08:00 ] 66.249.75.64 GET /admin/multipleshow/read/id/16/imei/863412043560864.html?page=26%29%0DAND%095258%3D%28SELECT%0D%28CASE%09WHEN%0A%285258%3D7841%29%0CTHEN%095258%0DELSE%0A%28SELECT%0C7841%0AUNION%0CSELECT%0D2870%29%09END%29%29--%09uXNt [ sql ] [ DB ] CONNECT:[ UseTime:0.002500s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011320s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000723s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009597s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043560864' LIMIT 1 [ RunTime:0.015759s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043560864' ORDER BY `update_time` DESC LIMIT 250,10 [ RunTime:0.002802s ] --------------------------------------------------------------- [ 2025-01-17T17:55:25+08:00 ] 66.249.75.65 GET /admin/multipleshow/read/id/16/imei/863412043560864.html?page=26%27%7C%7C%28SELECT%0DOQrK%0DFROM%0CDUAL%09WHERE%0C1055%3D1055%0CAND%0D5557%3D5255%29%7C%7C%27 [ sql ] [ DB ] CONNECT:[ UseTime:0.002384s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.009129s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000488s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008104s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043560864' LIMIT 1 [ RunTime:0.001448s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043560864' ORDER BY `update_time` DESC LIMIT 250,10 [ RunTime:0.001681s ] --------------------------------------------------------------- [ 2025-01-17T19:57:12+08:00 ] 27.115.124.109 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.002009s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008601s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000288s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000625s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000655s ] --------------------------------------------------------------- [ 2025-01-17T19:59:31+08:00 ] 27.115.124.53 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001820s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008780s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000282s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000649s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000722s ] --------------------------------------------------------------- [ 2025-01-17T21:59:22+08:00 ] 66.249.66.14 GET /admin/multipleshow/read/id/14/imei/862810047306690.html?page=69 [ sql ] [ DB ] CONNECT:[ UseTime:0.002834s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011671s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000736s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.010223s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047306690' LIMIT 1 [ RunTime:0.002108s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047306690' ORDER BY `update_time` DESC LIMIT 680,10 [ RunTime:0.004921s ]