--------------------------------------------------------------- [ 2022-12-19T02:03:56+08:00 ] 117.132.194.94 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002543s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011169s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000705s ] --------------------------------------------------------------- [ 2022-12-19T02:03:56+08:00 ] 39.144.4.96 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001740s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009420s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000910s ] --------------------------------------------------------------- [ 2022-12-19T02:04:04+08:00 ] 117.132.194.94 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221219&time=020301&v1=-00.306&v2=+00.001&v3=-00.036&v4=-00.014&v5=05.6&t=-06.8&h=63.8&rssi=+224&ccid=4600485905031430000099m9990000000033000000g3570,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001835s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011808s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000653s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221219',`time`='020301',`v1`=-0.306,`v2`=0.001,`v3`=-0.036,`v4`=-0.014,`v5`=5.6,`t`=-6.8,`h`=63.8,`rssi`=224,`ccid`='4600485905031430000099m9990000000033000000g3570,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1671386644 WHERE `imei` = '868922055644013' [ RunTime:0.000580s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011505s ] [ 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' , '221219' , '020301' , -0.306 , 0.001 , -0.036 , -0.014 , 5.6 , -6.8 , 63.8 , 224 , '4600485905031430000099m9990000000033000000g3570,N,00E000=-00.000' , 0 , 0 , 1671386644 , 1671386644) [ RunTime:0.000718s ] --------------------------------------------------------------- [ 2022-12-19T02:04:04+08:00 ] 39.144.4.96 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221219&time=020301&v1=-00.129&v2=+00.005&v3=-00.019&v4=+00.256&v5=05.9&t=-08.1&h=60.4&rssi=+229&ccid=4600485905031420000099m9990000000960000000g9760,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002262s ] 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` = '868922055643643' LIMIT 1 [ RunTime:0.000656s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221219',`time`='020301',`v1`=-0.129,`v2`=0.005,`v3`=-0.019,`v4`=0.256,`v5`=5.9,`t`=-8.1,`h`=60.4,`rssi`=229,`ccid`='4600485905031420000099m9990000000960000000g9760,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1671386644 WHERE `imei` = '868922055643643' [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011029s ] [ 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' , '221219' , '020301' , -0.129 , 0.005 , -0.019 , 0.256 , 5.9 , -8.1 , 60.4 , 229 , '4600485905031420000099m9990000000960000000g9760,N,00E000=-00.000' , 0 , 0 , 1671386644 , 1671386644) [ RunTime:0.000555s ] --------------------------------------------------------------- [ 2022-12-19T02:05:45+08:00 ] 39.144.7.7 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.001771s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011282s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000717s ] --------------------------------------------------------------- [ 2022-12-19T02:05:54+08:00 ] 39.144.7.7 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221219&time=020501&v1=-01.276&v2=+00.024&v3=-01.117&v4=-00.692&v5=05.6&t=-03.8&h=80.2&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.190&a2=01.292&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001878s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011401s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001382s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221219',`time`='020501',`v1`=-1.276,`v2`=0.024,`v3`=-1.117,`v4`=-0.692,`v5`=5.6,`t`=-3.8,`h`=80.2,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.19,`a2`=1.292,`update_time`=1671386754 WHERE `imei` = '868922055684076' [ RunTime:0.000616s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011130s ] [ 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' , '221219' , '020501' , -1.276 , 0.024 , -1.117 , -0.692 , 5.6 , -3.8 , 80.2 , 227 , '460044618415249' , -0 , 0.19 , 1.292 , 1671386754 , 1671386754) [ RunTime:0.001648s ] --------------------------------------------------------------- [ 2022-12-19T14:03:55+08:00 ] 39.144.5.98 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002549s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012251s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000801s ] --------------------------------------------------------------- [ 2022-12-19T14:03:55+08:00 ] 221.178.124.174 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003075s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015078s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000963s ] --------------------------------------------------------------- [ 2022-12-19T14:04:03+08:00 ] 39.144.5.98 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221219&time=140301&v1=-00.347&v2=+00.001&v3=+00.019&v4=-00.012&v5=05.9&t=+06.0&h=64.5&rssi=+226&ccid=4600485905031430000099m9990000000037000000g4110,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001594s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010354s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000734s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221219',`time`='140301',`v1`=-0.347,`v2`=0.001,`v3`=0.019,`v4`=-0.012,`v5`=5.9,`t`=6,`h`=64.5,`rssi`=226,`ccid`='4600485905031430000099m9990000000037000000g4110,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1671429843 WHERE `imei` = '868922055644013' [ RunTime:0.000701s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012773s ] [ 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' , '221219' , '140301' , -0.347 , 0.001 , 0.019 , -0.012 , 5.9 , 6 , 64.5 , 226 , '4600485905031430000099m9990000000037000000g4110,N,00E000=-00.000' , 0 , 0 , 1671429843 , 1671429843) [ RunTime:0.000747s ] --------------------------------------------------------------- [ 2022-12-19T14:04:04+08:00 ] 221.178.124.174 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221219&time=140301&v1=-01.282&v2=+00.055&v3=-01.030&v4=-00.049&v5=05.6&t=+02.9&h=59.7&rssi=+230&ccid=4600485905031420000099m9990000000232000001g2960,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001702s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010848s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000676s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221219',`time`='140301',`v1`=-1.282,`v2`=0.055,`v3`=-1.03,`v4`=-0.049,`v5`=5.6,`t`=2.9,`h`=59.7,`rssi`=230,`ccid`='4600485905031420000099m9990000000232000001g2960,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1671429844 WHERE `imei` = '868922055643643' [ RunTime:0.000556s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011545s ] [ 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' , '221219' , '140301' , -1.282 , 0.055 , -1.03 , -0.049 , 5.6 , 2.9 , 59.7 , 230 , '4600485905031420000099m9990000000232000001g2960,N,00E000=-00.000' , 0 , 0 , 1671429844 , 1671429844) [ RunTime:0.000535s ]