--------------------------------------------------------------- [ 2025-04-09T01:27:51+08:00 ] 111.55.120.39 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002138s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010018s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001504s ] --------------------------------------------------------------- [ 2025-04-09T01:28:00+08:00 ] 111.55.120.39 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=250409&time=012701&v1=-00.060&v2=+00.001&v3=+00.020&v4=+00.009&v5=05.6&t=+12.6&h=72.0&rssi=+222&ccid=4600485905031430000099m9990000000037000000g0600,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001666s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.573464s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000760s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='250409',`time`='012701',`v1`=-0.06,`v2`=0.001,`v3`=0.02,`v4`=0.009,`v5`=5.6,`t`=12.6,`h`=72,`rssi`=222,`ccid`='4600485905031430000099m9990000000037000000g0600,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1744133280 WHERE `imei` = '868922055644013' [ RunTime:0.000622s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010645s ] [ 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' , '250409' , '012701' , -0.06 , 0.001 , 0.02 , 0.009 , 5.6 , 12.6 , 72 , 222 , '4600485905031430000099m9990000000037000000g0600,N,00E000=-00.000' , 0 , 0 , 1744133280 , 1744133280) [ RunTime:0.003901s ] --------------------------------------------------------------- [ 2025-04-09T02:32:59+08:00 ] 111.55.120.85 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002069s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.279990s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000653s ] --------------------------------------------------------------- [ 2025-04-09T02:33:01+08:00 ] 111.55.120.85 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1744137179&v1=-1.086412&v2=0.186130&v3=-0.943736&v4=-0.809790&v5=6.120000&t=12.223838&h=73.025269&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428350,36.323094&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.449860s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.560751s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000898s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1744137179,`v1`=-1.086412,`v2`=0.18613,`v3`=-0.943736,`v4`=-0.80979,`v5`=6.12,`t`=12.223838,`h`=73.025269,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428350,36.323094',`update_time`=1744137181 WHERE `imei` = '868922055684209' [ RunTime:0.000718s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011145s ] [ 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' , 1744137179 , -1.086412 , 0.18613 , -0.943736 , -0.80979 , 6.12 , 12.223838 , 73.025269 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428350,36.323094' , 1744137181) [ RunTime:0.000887s ] --------------------------------------------------------------- [ 2025-04-09T07:22:17+08:00 ] 66.249.74.130 GET /admin/multipleshow/read/id/15/imei/863412043611030.html?page=24 [ sql ] [ DB ] CONNECT:[ UseTime:0.002204s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.558328s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000635s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008239s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043611030' LIMIT 1 [ RunTime:0.048021s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043611030' ORDER BY `update_time` DESC LIMIT 230,10 [ RunTime:0.003748s ] --------------------------------------------------------------- [ 2025-04-09T09:36:06+08:00 ] 111.55.120.70 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002003s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009788s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000685s ] --------------------------------------------------------------- [ 2025-04-09T09:36:07+08:00 ] 111.55.120.70 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1744162566&v1=-1.347442&v2=0.047549&v3=-1.172920&v4=-0.297181&v5=5.760000&t=18.304968&h=80.181641&rssi=28&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001786s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.557212s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000623s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1744162566,`v1`=-1.347442,`v2`=0.047549,`v3`=-1.17292,`v4`=-0.297181,`v5`=5.76,`t`=18.304968,`h`=80.181641,`rssi`=28,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1744162567 WHERE `imei` = '868922055644021' [ RunTime:0.000468s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008511s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1744162566 , -1.347442 , 0.047549 , -1.17292 , -0.297181 , 5.76 , 18.304968 , 80.181641 , 28 , '898604650119C1053141' , '460048590503141' , -0 , 1744162567) [ RunTime:0.000534s ] --------------------------------------------------------------- [ 2025-04-09T10:05:09+08:00 ] 124.129.68.232 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003159s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.070239s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'heating1' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000869s ] --------------------------------------------------------------- [ 2025-04-09T10:05:11+08:00 ] 124.129.68.232 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001832s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010020s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating1' LIMIT 1 [ RunTime:0.000470s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000820s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating1' ORDER BY `id` DESC [ RunTime:0.000772s ] --------------------------------------------------------------- [ 2025-04-09T10:06:16+08:00 ] 124.129.68.232 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002048s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010573s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating1' LIMIT 1 [ RunTime:0.002090s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001106s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating1' ORDER BY `id` DESC [ RunTime:0.001093s ] --------------------------------------------------------------- [ 2025-04-09T10:06:19+08:00 ] 124.129.68.232 GET /home/heating/communication/id/4/unique_identification_number/456.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002004s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.011920s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000894s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008713s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '456' ORDER BY `id` ASC [ RunTime:0.000518s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007819s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '456' LIMIT 1 [ RunTime:0.000593s ] --------------------------------------------------------------- [ 2025-04-09T10:07:06+08:00 ] 124.129.68.232 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.022044s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008768s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating1' LIMIT 1 [ RunTime:0.000426s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000787s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating1' ORDER BY `id` DESC [ RunTime:0.000755s ] --------------------------------------------------------------- [ 2025-04-09T10:07:15+08:00 ] 124.129.68.232 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.211657s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.555316s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating1' LIMIT 1 [ RunTime:0.000390s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000745s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating1' ORDER BY `id` DESC [ RunTime:0.000777s ] --------------------------------------------------------------- [ 2025-04-09T10:07:18+08:00 ] 124.129.68.232 GET /home/heating/communication/id/4/unique_identification_number/456.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001585s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008392s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000862s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007666s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '456' ORDER BY `id` ASC [ RunTime:0.000539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007363s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '456' LIMIT 1 [ RunTime:0.000554s ] --------------------------------------------------------------- [ 2025-04-09T10:07:28+08:00 ] 124.129.68.232 GET /home/heating/communication/id/4/unique_identification_number/456.html [ sql ] [ DB ] CONNECT:[ UseTime:0.212219s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.556724s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000875s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008128s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '456' ORDER BY `id` ASC [ RunTime:0.000555s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008044s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '456' LIMIT 1 [ RunTime:0.000618s ] --------------------------------------------------------------- [ 2025-04-09T10:22:19+08:00 ] 66.249.74.130 GET /admin/shelves/search.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002414s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_goods` [ RunTime:0.052051s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_goods` WHERE `collect_goods`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001320s ] [ sql ] [ SQL ] SELECT * FROM `collect_goods` WHERE `collect_goods`.`delete_time` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000429s ] [ sql ] [ SQL ] SELECT * FROM `collect_goods` WHERE `collect_goods`.`delete_time` IS NULL ORDER BY `id` DESC [ RunTime:0.000423s ] --------------------------------------------------------------- [ 2025-04-09T10:22:37+08:00 ] 124.129.68.232 GET /home/heating/communication/id/4/unique_identification_number/456.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002091s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.295875s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 4 LIMIT 1 [ RunTime:0.001291s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.011146s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '456' ORDER BY `id` ASC [ RunTime:0.000701s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008935s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '456' LIMIT 1 [ RunTime:0.000769s ] --------------------------------------------------------------- [ 2025-04-09T12:19:50+08:00 ] 66.249.74.129 GET /admin/multipleshow/read/id/15/imei/863412043611030.html?page=7 [ sql ] [ DB ] CONNECT:[ UseTime:0.002037s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.283099s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000607s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009038s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043611030' LIMIT 1 [ RunTime:0.003101s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043611030' ORDER BY `update_time` DESC LIMIT 60,10 [ RunTime:0.003566s ] --------------------------------------------------------------- [ 2025-04-09T18:16:19+08:00 ] 124.129.68.232 GET /home/heating/communication/id/4/unique_identification_number/456.html [ sql ] [ DB ] CONNECT:[ UseTime:0.216756s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.589754s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000973s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.009283s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '456' ORDER BY `id` ASC [ RunTime:0.000579s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007859s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '456' LIMIT 1 [ RunTime:0.000579s ]