--------------------------------------------------------------- [ 2025-02-01T01:26:59+08:00 ] 111.55.120.75 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002214s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009413s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000717s ] --------------------------------------------------------------- [ 2025-02-01T01:27:01+08:00 ] 111.55.120.75 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1738344419&v1=-1.048184&v2=0.100844&v3=-0.791549&v4=-0.805214&v5=6.300000&t=2.077895&h=74.169678&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.426815,36.322444&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001493s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009713s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000798s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1738344419,`v1`=-1.048184,`v2`=0.100844,`v3`=-0.791549,`v4`=-0.805214,`v5`=6.3,`t`=2.077895,`h`=74.169678,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.426815,36.322444',`update_time`=1738344421 WHERE `imei` = '868922055684209' [ RunTime:0.000601s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014931s ] [ 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' , 1738344419 , -1.048184 , 0.100844 , -0.791549 , -0.805214 , 6.3 , 2.077895 , 74.169678 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.426815,36.322444' , 1738344421) [ RunTime:0.003933s ] --------------------------------------------------------------- [ 2025-02-01T01:38:54+08:00 ] 39.144.112.38 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002662s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008510s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000655s ] --------------------------------------------------------------- [ 2025-02-01T01:39:02+08:00 ] 39.144.112.38 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=250201&time=013901&v1=-00.049&v2=+00.001&v3=+00.013&v4=+00.008&v5=05.2&t=+01.7&h=73.6&rssi=+226&ccid=4600485905031430000099m9990000000030000000g0470,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002172s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008097s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000566s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='250201',`time`='013901',`v1`=-0.049,`v2`=0.001,`v3`=0.013,`v4`=0.008,`v5`=5.2,`t`=1.7,`h`=73.6,`rssi`=226,`ccid`='4600485905031430000099m9990000000030000000g0470,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1738345142 WHERE `imei` = '868922055644013' [ RunTime:0.000395s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008113s ] [ 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' , '250201' , '013901' , -0.049 , 0.001 , 0.013 , 0.008 , 5.2 , 1.7 , 73.6 , 226 , '4600485905031430000099m9990000000030000000g0470,N,00E000=-00.000' , 0 , 0 , 1738345142 , 1738345142) [ RunTime:0.001349s ] --------------------------------------------------------------- [ 2025-02-01T06:07:21+08:00 ] 66.249.66.12 GET /admin/multipleshow/read/id/16/imei/863412043560864.html?page=-8774%22%0COR%091100%3D1100--%0CYmEs [ sql ] [ DB ] CONNECT:[ UseTime:0.002764s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011219s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000482s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.010705s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043560864' LIMIT 1 [ RunTime:0.015249s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043560864' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001652s ] --------------------------------------------------------------- [ 2025-02-01T07:22:07+08:00 ] 111.55.120.29 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002188s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011876s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001669s ] --------------------------------------------------------------- [ 2025-02-01T07:22:08+08:00 ] 111.55.120.29 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1738365727&v1=-1.313368&v2=0.034672&v3=-1.065673&v4=-0.718887&v5=6.120000&t=1.123362&h=82.508606&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001732s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008719s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000699s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1738365727,`v1`=-1.313368,`v2`=0.034672,`v3`=-1.065673,`v4`=-0.718887,`v5`=6.12,`t`=1.123362,`h`=82.508606,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1738365728 WHERE `imei` = '868922055644021' [ RunTime:0.000620s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010771s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1738365727 , -1.313368 , 0.034672 , -1.065673 , -0.718887 , 6.12 , 1.123362 , 82.508606 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1738365728) [ RunTime:0.003957s ] --------------------------------------------------------------- [ 2025-02-01T15:06:00+08:00 ] 27.115.124.6 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002668s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.012187s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000331s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000625s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000667s ] --------------------------------------------------------------- [ 2025-02-01T15:06:01+08:00 ] 27.115.124.38 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001277s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008633s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000264s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000616s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000693s ] --------------------------------------------------------------- [ 2025-02-01T15:08:04+08:00 ] 123.6.49.44 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001761s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009310s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000956s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.010729s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000584s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007537s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000569s ]