--------------------------------------------------------------- [ 2025-04-08T01:27:51+08:00 ] 111.55.120.87 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001972s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.310903s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000638s ] --------------------------------------------------------------- [ 2025-04-08T01:27:59+08:00 ] 111.55.120.87 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=250408&time=012701&v1=-00.061&v2=+00.001&v3=+00.016&v4=+00.009&v5=05.6&t=+12.9&h=72.8&rssi=+222&ccid=4600485905031430000099m9990000000034000000g0580,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001740s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007987s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000571s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='250408',`time`='012701',`v1`=-0.061,`v2`=0.001,`v3`=0.016,`v4`=0.009,`v5`=5.6,`t`=12.9,`h`=72.8,`rssi`=222,`ccid`='4600485905031430000099m9990000000034000000g0580,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1744046879 WHERE `imei` = '868922055644013' [ RunTime:0.000461s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007632s ] [ 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' , '250408' , '012701' , -0.061 , 0.001 , 0.016 , 0.009 , 5.6 , 12.9 , 72.8 , 222 , '4600485905031430000099m9990000000034000000g0580,N,00E000=-00.000' , 0 , 0 , 1744046879 , 1744046879) [ RunTime:0.000524s ] --------------------------------------------------------------- [ 2025-04-08T02:32:05+08:00 ] 111.55.120.40 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.003084s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009741s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001537s ] --------------------------------------------------------------- [ 2025-04-08T02:32:07+08:00 ] 111.55.120.40 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1744050725&v1=-1.016820&v2=0.198698&v3=-0.975010&v4=-0.809127&v5=6.300000&t=11.419456&h=73.544067&rssi=29&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.429132,36.322700&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001904s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.572686s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1744050725,`v1`=-1.01682,`v2`=0.198698,`v3`=-0.97501,`v4`=-0.809127,`v5`=6.3,`t`=11.419456,`h`=73.544067,`rssi`=29,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.429132,36.322700',`update_time`=1744050727 WHERE `imei` = '868922055684209' [ RunTime:0.000498s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007602s ] [ 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' , 1744050725 , -1.01682 , 0.198698 , -0.97501 , -0.809127 , 6.3 , 11.419456 , 73.544067 , 29 , '898604650119C1078511' , '460048590708511' , -0 , '120.429132,36.322700' , 1744050727) [ RunTime:0.000682s ] --------------------------------------------------------------- [ 2025-04-08T08:52:17+08:00 ] 66.249.79.161 GET /admin/multipledata/delete/id/4596.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002165s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009437s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4596 [ RunTime:0.001484s ] --------------------------------------------------------------- [ 2025-04-08T08:52:20+08:00 ] 66.249.79.161 GET /admin/multipledata/delete.html [ error ] [0]方法参数错误:id --------------------------------------------------------------- [ 2025-04-08T09:34:05+08:00 ] 111.55.120.59 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002863s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.071266s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000690s ] --------------------------------------------------------------- [ 2025-04-08T09:34:07+08:00 ] 111.55.120.59 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1744076045&v1=-1.344733&v2=0.038769&v3=-1.172860&v4=-0.690111&v5=6.300000&t=19.806482&h=79.876465&rssi=19&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001988s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008817s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000614s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1744076045,`v1`=-1.344733,`v2`=0.038769,`v3`=-1.17286,`v4`=-0.690111,`v5`=6.3,`t`=19.806482,`h`=79.876465,`rssi`=19,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1744076047 WHERE `imei` = '868922055644021' [ RunTime:0.000510s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009428s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1744076045 , -1.344733 , 0.038769 , -1.17286 , -0.690111 , 6.3 , 19.806482 , 79.876465 , 19 , '898604650119C1053141' , '460048590503141' , -0 , 1744076047) [ RunTime:0.000589s ] --------------------------------------------------------------- [ 2025-04-08T14:57:09+08:00 ] 1.29.92.42 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.002874s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.013702s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000611s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000858s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000721s ] --------------------------------------------------------------- [ 2025-04-08T14:57:11+08:00 ] 1.29.92.42 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001826s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009032s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000850s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.009994s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000725s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008785s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000607s ] --------------------------------------------------------------- [ 2025-04-08T14:57:22+08:00 ] 123.6.49.12 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.001305s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008495s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000341s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000681s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000690s ] --------------------------------------------------------------- [ 2025-04-08T14:57:22+08:00 ] 123.6.49.12 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.002228s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008562s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000276s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000627s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000665s ] --------------------------------------------------------------- [ 2025-04-08T14:57:31+08:00 ] 27.115.124.109 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001847s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010321s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000894s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007261s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000510s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007628s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000536s ] --------------------------------------------------------------- [ 2025-04-08T14:57:32+08:00 ] 27.115.124.6 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002167s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.012193s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000899s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008012s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000542s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007867s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000617s ]