--------------------------------------------------------------- [ 2025-01-27T01:23:18+08:00 ] 111.55.120.20 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002016s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011120s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001413s ] --------------------------------------------------------------- [ 2025-01-27T01:23:19+08:00 ] 111.55.120.20 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1737912198&v1=-1.051315&v2=0.108613&v3=-0.824870&v4=-0.803107&v5=6.300000&t=-3.552781&h=73.917908&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428414,36.323136&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002557s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008379s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000632s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1737912198,`v1`=-1.051315,`v2`=0.108613,`v3`=-0.82487,`v4`=-0.803107,`v5`=6.3,`t`=-3.552781,`h`=73.917908,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428414,36.323136',`update_time`=1737912199 WHERE `imei` = '868922055684209' [ RunTime:0.000571s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013807s ] [ 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' , 1737912198 , -1.051315 , 0.108613 , -0.82487 , -0.803107 , 6.3 , -3.552781 , 73.917908 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428414,36.323136' , 1737912199) [ RunTime:0.003855s ] --------------------------------------------------------------- [ 2025-01-27T07:12:08+08:00 ] 39.144.112.3 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002068s ] 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.001460s ] --------------------------------------------------------------- [ 2025-01-27T07:12:10+08:00 ] 39.144.112.3 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1737933128&v1=-1.308492&v2=0.031469&v3=-1.053602&v4=-0.711422&v5=6.300000&t=-5.590549&h=82.462830&rssi=26&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001813s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008193s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000981s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1737933128,`v1`=-1.308492,`v2`=0.031469,`v3`=-1.053602,`v4`=-0.711422,`v5`=6.3,`t`=-5.590549,`h`=82.46283,`rssi`=26,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1737933130 WHERE `imei` = '868922055644021' [ RunTime:0.000551s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009678s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1737933128 , -1.308492 , 0.031469 , -1.053602 , -0.711422 , 6.3 , -5.590549 , 82.46283 , 26 , '898604650119C1053141' , '460048590503141' , -0 , 1737933130) [ RunTime:0.001387s ] --------------------------------------------------------------- [ 2025-01-27T07:21:29+08:00 ] 66.249.65.160 GET /admin/multipleshow/read/id/16/imei/863412043560864.html?page=26%27%0DOR%0ANOT%0C8242%3D2400%0DAND%0A%27YUmB%27%3D%27YUmB [ sql ] [ DB ] CONNECT:[ UseTime:0.002132s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010160s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000509s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009981s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043560864' LIMIT 1 [ RunTime:0.015164s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043560864' ORDER BY `update_time` DESC LIMIT 250,10 [ RunTime:0.001765s ] --------------------------------------------------------------- [ 2025-01-27T10:35:58+08:00 ] 220.195.106.133 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002210s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010570s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000955s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008982s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000577s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008418s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000523s ] --------------------------------------------------------------- [ 2025-01-27T10:35:59+08:00 ] 220.195.106.133 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001993s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008822s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000436s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000710s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000656s ] --------------------------------------------------------------- [ 2025-01-27T10:36:03+08:00 ] 220.195.106.133 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001706s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008642s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000818s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007397s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000525s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007239s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000504s ] --------------------------------------------------------------- [ 2025-01-27T15:15:09+08:00 ] 1.29.85.135 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001972s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008896s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000397s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000801s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000622s ] --------------------------------------------------------------- [ 2025-01-27T18:58:03+08:00 ] 66.249.65.162 GET /admin/multipledata/delete/id/132.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002066s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.011570s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 132 [ RunTime:0.000541s ] --------------------------------------------------------------- [ 2025-01-27T19:15:29+08:00 ] 66.249.65.162 GET /admin/multipledata/delete/id/4127.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002579s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.011072s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4127 [ RunTime:0.000723s ] --------------------------------------------------------------- [ 2025-01-27T20:54:30+08:00 ] 66.249.68.1 GET /admin/multipledata/delete/id/4121.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002020s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.012431s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4121 [ RunTime:0.000520s ]