--------------------------------------------------------------- [ 2023-01-31T02:03:55+08:00 ] 117.132.195.114 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002289s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012015s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000761s ] --------------------------------------------------------------- [ 2023-01-31T02:03:56+08:00 ] 39.144.8.19 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001559s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011442s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000709s ] --------------------------------------------------------------- [ 2023-01-31T02:04:04+08:00 ] 117.132.195.114 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230131&time=020301&v1=-00.255&v2=+00.001&v3=+00.004&v4=-00.016&v5=05.6&t=+01.5&h=65.1&rssi=+225&ccid=4600485905031430000099m9990000000034000000g3110,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002679s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010210s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000707s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230131',`time`='020301',`v1`=-0.255,`v2`=0.001,`v3`=0.004,`v4`=-0.016,`v5`=5.6,`t`=1.5,`h`=65.1,`rssi`=225,`ccid`='4600485905031430000099m9990000000034000000g3110,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675101844 WHERE `imei` = '868922055644013' [ RunTime:0.000681s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010424s ] [ 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' , '230131' , '020301' , -0.255 , 0.001 , 0.004 , -0.016 , 5.6 , 1.5 , 65.1 , 225 , '4600485905031430000099m9990000000034000000g3110,N,00E000=-00.000' , 0 , 0 , 1675101844 , 1675101844) [ RunTime:0.000645s ] --------------------------------------------------------------- [ 2023-01-31T02:04:05+08:00 ] 39.144.8.19 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230131&time=020301&v1=-01.249&v2=+00.024&v3=-00.949&v4=-00.033&v5=06.0&t=-00.9&h=61.9&rssi=+230&ccid=4600485905031420000099m9990000000274000001g2630,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001982s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010051s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000697s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230131',`time`='020301',`v1`=-1.249,`v2`=0.024,`v3`=-0.949,`v4`=-0.033,`v5`=6,`t`=-0.9,`h`=61.9,`rssi`=230,`ccid`='4600485905031420000099m9990000000274000001g2630,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675101845 WHERE `imei` = '868922055643643' [ RunTime:0.000521s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010853s ] [ 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' , '230131' , '020301' , -1.249 , 0.024 , -0.949 , -0.033 , 6 , -0.9 , 61.9 , 230 , '4600485905031420000099m9990000000274000001g2630,N,00E000=-00.000' , 0 , 0 , 1675101845 , 1675101845) [ RunTime:0.000587s ] --------------------------------------------------------------- [ 2023-01-31T06:13:51+08:00 ] 39.144.5.117 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002834s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011605s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000687s ] --------------------------------------------------------------- [ 2023-01-31T06:13:59+08:00 ] 39.144.5.117 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230131&time=061301&v1=-01.260&v2=+00.022&v3=-01.088&v4=-00.600&v5=05.7&t=-00.2&h=81.0&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.204&a2=01.276&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001970s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011100s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000642s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230131',`time`='061301',`v1`=-1.26,`v2`=0.022,`v3`=-1.088,`v4`=-0.6,`v5`=5.7,`t`=-0.2,`h`=81,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.204,`a2`=1.276,`update_time`=1675116839 WHERE `imei` = '868922055684076' [ RunTime:0.000575s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010750s ] [ 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' , '230131' , '061301' , -1.26 , 0.022 , -1.088 , -0.6 , 5.7 , -0.2 , 81 , 228 , '460044618415249' , -0 , 0.204 , 1.276 , 1675116839 , 1675116839) [ RunTime:0.001269s ] --------------------------------------------------------------- [ 2023-01-31T14:03:55+08:00 ] 39.144.2.165 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002672s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013092s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000829s ] --------------------------------------------------------------- [ 2023-01-31T14:03:55+08:00 ] 221.178.126.87 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002671s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009734s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000711s ] --------------------------------------------------------------- [ 2023-01-31T14:04:04+08:00 ] 39.144.2.165 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230131&time=140301&v1=-00.286&v2=+00.001&v3=+00.019&v4=-00.014&v5=06.0&t=+15.0&h=64.8&rssi=+228&ccid=4600485905031430000099m9990000000038000000g3490,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001610s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010321s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000763s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230131',`time`='140301',`v1`=-0.286,`v2`=0.001,`v3`=0.019,`v4`=-0.014,`v5`=6,`t`=15,`h`=64.8,`rssi`=228,`ccid`='4600485905031430000099m9990000000038000000g3490,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675145044 WHERE `imei` = '868922055644013' [ RunTime:0.000610s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011331s ] [ 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' , '230131' , '140301' , -0.286 , 0.001 , 0.019 , -0.014 , 6 , 15 , 64.8 , 228 , '4600485905031430000099m9990000000038000000g3490,N,00E000=-00.000' , 0 , 0 , 1675145044 , 1675145044) [ RunTime:0.000625s ] --------------------------------------------------------------- [ 2023-01-31T14:04:04+08:00 ] 221.178.126.87 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230131&time=140301&v1=-01.246&v2=+00.055&v3=-00.932&v4=-00.032&v5=05.6&t=+12.3&h=60.1&rssi=+230&ccid=4600485905031420000099m9990000000283000001g2590,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&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.009637s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000794s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230131',`time`='140301',`v1`=-1.246,`v2`=0.055,`v3`=-0.932,`v4`=-0.032,`v5`=5.6,`t`=12.3,`h`=60.1,`rssi`=230,`ccid`='4600485905031420000099m9990000000283000001g2590,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675145044 WHERE `imei` = '868922055643643' [ RunTime:0.000603s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010483s ] [ 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' , '230131' , '140301' , -1.246 , 0.055 , -0.932 , -0.032 , 5.6 , 12.3 , 60.1 , 230 , '4600485905031420000099m9990000000283000001g2590,N,00E000=-00.000' , 0 , 0 , 1675145044 , 1675145044) [ RunTime:0.000570s ]