--------------------------------------------------------------- [ 2023-02-06T02:03:55+08:00 ] 39.144.3.112 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002523s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013276s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000699s ] --------------------------------------------------------------- [ 2023-02-06T02:03:55+08:00 ] 117.132.197.69 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001660s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009914s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000668s ] --------------------------------------------------------------- [ 2023-02-06T02:04:03+08:00 ] 39.144.3.112 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230206&time=020301&v1=-00.289&v2=+00.001&v3=-00.010&v4=-00.014&v5=05.7&t=+03.2&h=64.6&rssi=+226&ccid=4600485905031430000099m9990000000035000000g3410,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002117s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010269s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000949s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230206',`time`='020301',`v1`=-0.289,`v2`=0.001,`v3`=-0.01,`v4`=-0.014,`v5`=5.7,`t`=3.2,`h`=64.6,`rssi`=226,`ccid`='4600485905031430000099m9990000000035000000g3410,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675620243 WHERE `imei` = '868922055644013' [ RunTime:0.000632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011986s ] [ 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' , '230206' , '020301' , -0.289 , 0.001 , -0.01 , -0.014 , 5.7 , 3.2 , 64.6 , 226 , '4600485905031430000099m9990000000035000000g3410,N,00E000=-00.000' , 0 , 0 , 1675620243 , 1675620243) [ RunTime:0.000996s ] --------------------------------------------------------------- [ 2023-02-06T02:04:04+08:00 ] 117.132.197.69 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230206&time=020301&v1=-01.240&v2=+00.017&v3=-00.938&v4=-00.031&v5=05.7&t=+01.5&h=61.4&rssi=+228&ccid=4600485905031420000099m9990000000278000001g2540,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001666s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010047s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000704s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230206',`time`='020301',`v1`=-1.24,`v2`=0.017,`v3`=-0.938,`v4`=-0.031,`v5`=5.7,`t`=1.5,`h`=61.4,`rssi`=228,`ccid`='4600485905031420000099m9990000000278000001g2540,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675620244 WHERE `imei` = '868922055643643' [ RunTime:0.000535s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011018s ] [ 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' , '230206' , '020301' , -1.24 , 0.017 , -0.938 , -0.031 , 5.7 , 1.5 , 61.4 , 228 , '4600485905031420000099m9990000000278000001g2540,N,00E000=-00.000' , 0 , 0 , 1675620244 , 1675620244) [ RunTime:0.000852s ] --------------------------------------------------------------- [ 2023-02-06T06:13:50+08:00 ] 39.144.4.55 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003732s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012205s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000889s ] --------------------------------------------------------------- [ 2023-02-06T06:13:59+08:00 ] 39.144.4.55 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230206&time=061301&v1=-01.262&v2=+00.019&v3=-00.923&v4=-00.633&v5=05.7&t=+00.1&h=80.8&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.360&a2=01.277&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001645s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011315s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000664s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230206',`time`='061301',`v1`=-1.262,`v2`=0.019,`v3`=-0.923,`v4`=-0.633,`v5`=5.7,`t`=0.1,`h`=80.8,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.36,`a2`=1.277,`update_time`=1675635239 WHERE `imei` = '868922055684076' [ RunTime:0.000595s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012825s ] [ 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' , '230206' , '061301' , -1.262 , 0.019 , -0.923 , -0.633 , 5.7 , 0.1 , 80.8 , 228 , '460044618415249' , -0 , 0.36 , 1.277 , 1675635239 , 1675635239) [ RunTime:0.001296s ] --------------------------------------------------------------- [ 2023-02-06T14:03:54+08:00 ] 117.132.197.185 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.014212s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000916s ] --------------------------------------------------------------- [ 2023-02-06T14:03:55+08:00 ] 39.144.1.123 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003208s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011812s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000847s ] --------------------------------------------------------------- [ 2023-02-06T14:04:03+08:00 ] 117.132.197.185 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230206&time=140301&v1=-00.285&v2=+00.002&v3=+00.019&v4=-00.014&v5=06.0&t=+13.9&h=64.4&rssi=+226&ccid=4600485905031430000099m9990000000038000000g3420,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002076s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010912s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000772s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230206',`time`='140301',`v1`=-0.285,`v2`=0.002,`v3`=0.019,`v4`=-0.014,`v5`=6,`t`=13.9,`h`=64.4,`rssi`=226,`ccid`='4600485905031430000099m9990000000038000000g3420,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675663443 WHERE `imei` = '868922055644013' [ RunTime:0.000649s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010358s ] [ 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' , '230206' , '140301' , -0.285 , 0.002 , 0.019 , -0.014 , 6 , 13.9 , 64.4 , 226 , '4600485905031430000099m9990000000038000000g3420,N,00E000=-00.000' , 0 , 0 , 1675663443 , 1675663443) [ RunTime:0.000674s ] --------------------------------------------------------------- [ 2023-02-06T14:04:04+08:00 ] 39.144.1.123 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230206&time=140301&v1=-01.240&v2=+00.065&v3=-00.917&v4=-00.030&v5=05.7&t=+10.1&h=60.5&rssi=+230&ccid=4600485905031420000099m9990000000294000001g2540,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001917s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010721s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000803s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230206',`time`='140301',`v1`=-1.24,`v2`=0.065,`v3`=-0.917,`v4`=-0.03,`v5`=5.7,`t`=10.1,`h`=60.5,`rssi`=230,`ccid`='4600485905031420000099m9990000000294000001g2540,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675663444 WHERE `imei` = '868922055643643' [ RunTime:0.000517s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010301s ] [ 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' , '230206' , '140301' , -1.24 , 0.065 , -0.917 , -0.03 , 5.7 , 10.1 , 60.5 , 230 , '4600485905031420000099m9990000000294000001g2540,N,00E000=-00.000' , 0 , 0 , 1675663444 , 1675663444) [ RunTime:0.000853s ]