--------------------------------------------------------------- [ 2025-03-20T01:31:29+08:00 ] 111.55.120.53 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.214130s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.555359s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000626s ] --------------------------------------------------------------- [ 2025-03-20T01:31:36+08:00 ] 111.55.120.53 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=250320&time=013101&v1=-00.061&v2=+00.001&v3=+00.018&v4=+00.008&v5=05.4&t=+06.7&h=73.5&rssi=+220&ccid=4600485905031430000099m9990000000035000000g0580,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001519s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:1.009850s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='250320',`time`='013101',`v1`=-0.061,`v2`=0.001,`v3`=0.018,`v4`=0.008,`v5`=5.4,`t`=6.7,`h`=73.5,`rssi`=220,`ccid`='4600485905031430000099m9990000000035000000g0580,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1742405496 WHERE `imei` = '868922055644013' [ RunTime:0.000480s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008043s ] [ 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' , '250320' , '013101' , -0.061 , 0.001 , 0.018 , 0.008 , 5.4 , 6.7 , 73.5 , 220 , '4600485905031430000099m9990000000035000000g0580,N,00E000=-00.000' , 0 , 0 , 1742405496 , 1742405496) [ RunTime:0.000535s ] --------------------------------------------------------------- [ 2025-03-20T02:13:59+08:00 ] 111.55.120.76 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.003118s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009272s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000635s ] --------------------------------------------------------------- [ 2025-03-20T02:14:01+08:00 ] 111.55.120.76 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1742408039&v1=-1.093395&v2=0.177031&v3=-1.068021&v4=-0.717622&v5=6.300000&t=5.778054&h=73.902649&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428608,36.323436&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001668s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.557267s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000673s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1742408039,`v1`=-1.093395,`v2`=0.177031,`v3`=-1.068021,`v4`=-0.717622,`v5`=6.3,`t`=5.778054,`h`=73.902649,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428608,36.323436',`update_time`=1742408041 WHERE `imei` = '868922055684209' [ RunTime:0.000469s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007514s ] [ 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' , 1742408039 , -1.093395 , 0.177031 , -1.068021 , -0.717622 , 6.3 , 5.778054 , 73.902649 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428608,36.323436' , 1742408041) [ RunTime:0.000543s ] --------------------------------------------------------------- [ 2025-03-20T08:01:29+08:00 ] 1.27.108.227 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.002014s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.011523s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000473s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000827s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000665s ] --------------------------------------------------------------- [ 2025-03-20T08:01:32+08:00 ] 1.27.108.227 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001467s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008280s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000808s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008815s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000531s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007096s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000476s ] --------------------------------------------------------------- [ 2025-03-20T08:01:48+08:00 ] 27.115.124.6 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.018461s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008217s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000867s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007637s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000474s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007089s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000486s ] --------------------------------------------------------------- [ 2025-03-20T08:01:56+08:00 ] 123.6.49.12 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.001323s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.543227s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000301s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000643s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000657s ] --------------------------------------------------------------- [ 2025-03-20T08:03:27+08:00 ] 1.27.108.227 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001942s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010774s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000763s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.006793s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000458s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007127s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000476s ] --------------------------------------------------------------- [ 2025-03-20T08:56:06+08:00 ] 111.55.120.90 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.320345s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000669s ] --------------------------------------------------------------- [ 2025-03-20T08:56:07+08:00 ] 111.55.120.90 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1742432166&v1=-1.339435&v2=0.070419&v3=-1.099716&v4=-0.700766&v5=6.120000&t=11.998610&h=81.333679&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001528s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008304s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000611s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1742432166,`v1`=-1.339435,`v2`=0.070419,`v3`=-1.099716,`v4`=-0.700766,`v5`=6.12,`t`=11.99861,`h`=81.333679,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1742432167 WHERE `imei` = '868922055644021' [ RunTime:0.000464s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007492s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1742432166 , -1.339435 , 0.070419 , -1.099716 , -0.700766 , 6.12 , 11.99861 , 81.333679 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1742432167) [ RunTime:0.000543s ] --------------------------------------------------------------- [ 2025-03-20T20:20:30+08:00 ] 66.249.68.71 GET /admin/multipledata/delete/id/4127.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002106s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008955s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4127 [ RunTime:0.002164s ]