--------------------------------------------------------------- [ 2023-07-21T00:32:23+08:00 ] 117.132.191.58 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002506s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014231s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000728s ] --------------------------------------------------------------- [ 2023-07-21T00:32:25+08:00 ] 117.132.191.58 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1689870743&v1=0.008097&v2=0.014290&v3=0.006411&v4=-0.015742&v5=12.420000&t=29.469795&h=82.241577&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001676s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009496s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000702s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1689870743,`v1`=0.008097,`v2`=0.01429,`v3`=0.006411,`v4`=-0.015742,`v5`=12.42,`t`=29.469795,`h`=82.241577,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1689870745 WHERE `imei` = '868922055644021' [ RunTime:0.000636s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011564s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1689870743 , 0.008097 , 0.01429 , 0.006411 , -0.015742 , 12.42 , 29.469795 , 82.241577 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1689870745) [ RunTime:0.000672s ] --------------------------------------------------------------- [ 2023-07-21T00:52:23+08:00 ] 111.55.137.72 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002558s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014182s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000759s ] --------------------------------------------------------------- [ 2023-07-21T00:52:25+08:00 ] 111.55.137.72 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1689871943&v1=0.021522&v2=0.013247&v3=0.019294&v4=-0.006171&v5=12.240000&t=29.523420&h=78.838867&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001728s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010288s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000689s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1689871943,`v1`=0.021522,`v2`=0.013247,`v3`=0.019294,`v4`=-0.006171,`v5`=12.24,`t`=29.52342,`h`=78.838867,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1689871945 WHERE `imei` = '868922055680850' [ RunTime:0.000710s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011638s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1689871943 , 0.021522 , 0.013247 , 0.019294 , -0.006171 , 12.24 , 29.52342 , 78.838867 , 25 , '898604650119C1078510' , '460048590708510' , -0 , 1689871945) [ RunTime:0.000615s ] --------------------------------------------------------------- [ 2023-07-21T02:00:51+08:00 ] 39.144.5.55 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002553s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013034s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000736s ] --------------------------------------------------------------- [ 2023-07-21T02:00:59+08:00 ] 39.144.5.55 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230721&time=020001&v1=-01.123&v2=+00.013&v3=-01.012&v4=-00.530&v5=06.0&t=+24.9&h=77.9&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.138&a2=01.183&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002083s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012327s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000659s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230721',`time`='020001',`v1`=-1.123,`v2`=0.013,`v3`=-1.012,`v4`=-0.53,`v5`=6,`t`=24.9,`h`=77.9,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.138,`a2`=1.183,`update_time`=1689876059 WHERE `imei` = '868922055684076' [ RunTime:0.000588s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009335s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '230721' , '020001' , -1.123 , 0.013 , -1.012 , -0.53 , 6 , 24.9 , 77.9 , 228 , '460044618415249' , -0 , 0.138 , 1.183 , 1689876059 , 1689876059) [ RunTime:0.000655s ] --------------------------------------------------------------- [ 2023-07-21T02:03:54+08:00 ] 111.55.137.10 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003639s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013123s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000658s ] --------------------------------------------------------------- [ 2023-07-21T02:03:55+08:00 ] 111.55.141.206 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001724s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010935s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000663s ] --------------------------------------------------------------- [ 2023-07-21T02:04:03+08:00 ] 111.55.137.10 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230721&time=020301&v1=-01.319&v2=+00.024&v3=-01.014&v4=-00.027&v5=06.2&t=+26.1&h=61.5&rssi=+227&ccid=4600485905031420000099m9990000000315000001g3250,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001818s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012448s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000765s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230721',`time`='020301',`v1`=-1.319,`v2`=0.024,`v3`=-1.014,`v4`=-0.027,`v5`=6.2,`t`=26.1,`h`=61.5,`rssi`=227,`ccid`='4600485905031420000099m9990000000315000001g3250,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1689876243 WHERE `imei` = '868922055643643' [ RunTime:0.000810s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010071s ] [ 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 ('868922055643643' , '230721' , '020301' , -1.319 , 0.024 , -1.014 , -0.027 , 6.2 , 26.1 , 61.5 , 227 , '4600485905031420000099m9990000000315000001g3250,N,00E000=-00.000' , 0 , 0 , 1689876243 , 1689876243) [ RunTime:0.000562s ] --------------------------------------------------------------- [ 2023-07-21T02:04:04+08:00 ] 111.55.141.206 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230721&time=020301&v1=-00.485&v2=+00.001&v3=-00.256&v4=-00.006&v5=06.0&t=+26.0&h=65.7&rssi=+223&ccid=4600485905031430000099m9990000000070000000g4880,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001776s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010444s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000704s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230721',`time`='020301',`v1`=-0.485,`v2`=0.001,`v3`=-0.256,`v4`=-0.006,`v5`=6,`t`=26,`h`=65.7,`rssi`=223,`ccid`='4600485905031430000099m9990000000070000000g4880,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1689876244 WHERE `imei` = '868922055644013' [ RunTime:0.000568s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011246s ] [ 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' , '230721' , '020301' , -0.485 , 0.001 , -0.256 , -0.006 , 6 , 26 , 65.7 , 223 , '4600485905031430000099m9990000000070000000g4880,N,00E000=-00.000' , 0 , 0 , 1689876244 , 1689876244) [ RunTime:0.000548s ]