--------------------------------------------------------------- [ 2022-12-11T02:03:55+08:00 ] 39.144.4.184 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002249s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009572s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000705s ] --------------------------------------------------------------- [ 2022-12-11T02:03:55+08:00 ] 117.132.192.153 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.020476s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015127s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001100s ] --------------------------------------------------------------- [ 2022-12-11T02:04:03+08:00 ] 39.144.4.184 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221211&time=020301&v1=-00.375&v2=+00.001&v3=+00.013&v4=-00.014&v5=05.7&t=-00.5&h=64.2&rssi=+226&ccid=4600485905031430000099m9990000000036000000g4390,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001718s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010583s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000601s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221211',`time`='020301',`v1`=-0.375,`v2`=0.001,`v3`=0.013,`v4`=-0.014,`v5`=5.7,`t`=-0.5,`h`=64.2,`rssi`=226,`ccid`='4600485905031430000099m9990000000036000000g4390,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1670695443 WHERE `imei` = '868922055644013' [ RunTime:0.000562s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009840s ] [ 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' , '221211' , '020301' , -0.375 , 0.001 , 0.013 , -0.014 , 5.7 , -0.5 , 64.2 , 226 , '4600485905031430000099m9990000000036000000g4390,N,00E000=-00.000' , 0 , 0 , 1670695443 , 1670695443) [ RunTime:0.000643s ] --------------------------------------------------------------- [ 2022-12-11T02:04:04+08:00 ] 117.132.192.153 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221211&time=020301&v1=-00.186&v2=+00.006&v3=-00.037&v4=+00.248&v5=05.6&t=-00.9&h=61.2&rssi=+229&ccid=4600485905031420000099m9990000000947000000g9720,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001591s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010605s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000846s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221211',`time`='020301',`v1`=-0.186,`v2`=0.006,`v3`=-0.037,`v4`=0.248,`v5`=5.6,`t`=-0.9,`h`=61.2,`rssi`=229,`ccid`='4600485905031420000099m9990000000947000000g9720,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1670695444 WHERE `imei` = '868922055643643' [ RunTime:0.000504s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010460s ] [ 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' , '221211' , '020301' , -0.186 , 0.006 , -0.037 , 0.248 , 5.6 , -0.9 , 61.2 , 229 , '4600485905031420000099m9990000000947000000g9720,N,00E000=-00.000' , 0 , 0 , 1670695444 , 1670695444) [ RunTime:0.000514s ] --------------------------------------------------------------- [ 2022-12-11T02:05:51+08:00 ] 221.178.127.126 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.001427s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011326s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000633s ] --------------------------------------------------------------- [ 2022-12-11T02:06:00+08:00 ] 221.178.127.126 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221211&time=020501&v1=-01.274&v2=+00.019&v3=-01.115&v4=-00.695&v5=05.7&t=-00.9&h=80.6&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.188&a2=01.289&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001541s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010510s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221211',`time`='020501',`v1`=-1.274,`v2`=0.019,`v3`=-1.115,`v4`=-0.695,`v5`=5.7,`t`=-0.9,`h`=80.6,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.188,`a2`=1.289,`update_time`=1670695560 WHERE `imei` = '868922055684076' [ RunTime:0.000503s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011971s ] [ 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' , '221211' , '020501' , -1.274 , 0.019 , -1.115 , -0.695 , 5.7 , -0.9 , 80.6 , 228 , '460044618415249' , -0 , 0.188 , 1.289 , 1670695560 , 1670695560) [ RunTime:0.000547s ] --------------------------------------------------------------- [ 2022-12-11T14:03:55+08:00 ] 117.132.192.36 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002255s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013757s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000719s ] --------------------------------------------------------------- [ 2022-12-11T14:03:55+08:00 ] 39.144.13.68 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002088s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010565s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000633s ] --------------------------------------------------------------- [ 2022-12-11T14:04:04+08:00 ] 39.144.13.68 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221211&time=140301&v1=-00.150&v2=+00.006&v3=-00.024&v4=+00.242&v5=05.6&t=+04.1&h=60.3&rssi=+231&ccid=4600485905031420000099m9990000000965000000g9790,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001616s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010129s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000631s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221211',`time`='140301',`v1`=-0.15,`v2`=0.006,`v3`=-0.024,`v4`=0.242,`v5`=5.6,`t`=4.1,`h`=60.3,`rssi`=231,`ccid`='4600485905031420000099m9990000000965000000g9790,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1670738644 WHERE `imei` = '868922055643643' [ RunTime:0.000555s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011308s ] [ 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' , '221211' , '140301' , -0.15 , 0.006 , -0.024 , 0.242 , 5.6 , 4.1 , 60.3 , 231 , '4600485905031420000099m9990000000965000000g9790,N,00E000=-00.000' , 0 , 0 , 1670738644 , 1670738644) [ RunTime:0.000617s ]