---------------------------------------------------------------
[ 2025-01-30T01:25:56+08:00 ] 39.144.112.15 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.001931s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009483s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000700s ]
---------------------------------------------------------------
[ 2025-01-30T01:25:58+08:00 ] 39.144.112.15 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1738171556&v1=-1.056552&v2=0.112870&v3=-0.822582&v4=-0.799315&v5=6.300000&t=-3.048701&h=74.131531&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428467,36.323386&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.013912s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007688s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000550s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684209',`create_time`=1738171556,`v1`=-1.056552,`v2`=0.11287,`v3`=-0.822582,`v4`=-0.799315,`v5`=6.3,`t`=-3.048701,`h`=74.131531,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428467,36.323386',`update_time`=1738171558  WHERE  `imei` = '868922055684209' [ RunTime:0.000402s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007504s ]
[ 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' , 1738171556 , -1.056552 , 0.11287 , -0.822582 , -0.799315 , 6.3 , -3.048701 , 74.131531 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428467,36.323386' , 1738171558) [ RunTime:0.001660s ]
---------------------------------------------------------------
[ 2025-01-30T07:18:07+08:00 ] 111.55.120.53 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002884s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011371s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001412s ]
---------------------------------------------------------------
[ 2025-01-30T07:18:08+08:00 ] 111.55.120.53 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1738192687&v1=-1.313790&v2=0.045165&v3=-1.061338&v4=-0.707569&v5=6.300000&t=-0.217275&h=82.211060&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001981s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007973s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000663s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1738192687,`v1`=-1.31379,`v2`=0.045165,`v3`=-1.061338,`v4`=-0.707569,`v5`=6.3,`t`=-0.217275,`h`=82.21106,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1738192688  WHERE  `imei` = '868922055644021' [ RunTime:0.000508s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010221s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1738192687 , -1.31379 , 0.045165 , -1.061338 , -0.707569 , 6.3 , -0.217275 , 82.21106 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1738192688) [ RunTime:0.003417s ]
---------------------------------------------------------------
[ 2025-01-30T13:23:27+08:00 ] 66.249.79.33 GET /admin/multipleshow/read/id/16/imei/863412043560864.html?page=-7213%27%09OR%0A1173%3D4759%0DAND%0C%27devt%27%3D%27devt
[ sql ] [ DB ] CONNECT:[ UseTime:0.002816s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011065s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE  `id` = 16 LIMIT 1 [ RunTime:0.000560s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009918s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE  `imei` = '863412043560864' LIMIT 1 [ RunTime:0.013906s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE  `imei` = '863412043560864' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001752s ]
---------------------------------------------------------------
[ 2025-01-30T20:07:53+08:00 ] 220.195.106.15 GET /home/heating/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002281s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.012027s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE  `username` = 'heating' LIMIT 1 [ RunTime:0.000907s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE  `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000832s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE  `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000667s ]
---------------------------------------------------------------
[ 2025-01-30T20:07:55+08:00 ] 220.195.106.15 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.008541s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000822s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.009516s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE  `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000559s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007197s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE  `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000546s ]
---------------------------------------------------------------
[ 2025-01-30T20:18:16+08:00 ] 123.6.49.44 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002028s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009037s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000841s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007305s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE  `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000473s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.006884s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE  `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000483s ]
---------------------------------------------------------------
[ 2025-01-30T20:24:11+08:00 ] 123.6.49.47 GET /home/heating/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001949s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008031s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE  `username` IS NULL LIMIT 1 [ RunTime:0.000270s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE  `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000655s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE  `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000641s ]