--------------------------------------------------------------- [ 2023-03-26T02:03:55+08:00 ] 39.144.11.87 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003398s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013845s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001406s ] --------------------------------------------------------------- [ 2023-03-26T02:03:55+08:00 ] 117.132.193.111 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001671s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010188s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000807s ] --------------------------------------------------------------- [ 2023-03-26T02:04:04+08:00 ] 39.144.11.87 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230326&time=020301&v1=-01.289&v2=+00.026&v3=-00.953&v4=-00.024&v5=05.7&t=+04.4&h=62.2&rssi=+230&ccid=4600485905031420000099m9990000000326000001g3000,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.010968s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009603s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000680s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230326',`time`='020301',`v1`=-1.289,`v2`=0.026,`v3`=-0.953,`v4`=-0.024,`v5`=5.7,`t`=4.4,`h`=62.2,`rssi`=230,`ccid`='4600485905031420000099m9990000000326000001g3000,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679767444 WHERE `imei` = '868922055643643' [ RunTime:0.000660s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010692s ] [ 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' , '230326' , '020301' , -1.289 , 0.026 , -0.953 , -0.024 , 5.7 , 4.4 , 62.2 , 230 , '4600485905031420000099m9990000000326000001g3000,N,00E000=-00.000' , 0 , 0 , 1679767444 , 1679767444) [ RunTime:0.001181s ] --------------------------------------------------------------- [ 2023-03-26T02:04:04+08:00 ] 117.132.193.111 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230326&time=020301&v1=-00.296&v2=+00.001&v3=+00.014&v4=-00.018&v5=05.6&t=+05.0&h=64.8&rssi=+226&ccid=4600485905031430000099m9990000000036000000g3330,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002462s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009702s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000685s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230326',`time`='020301',`v1`=-0.296,`v2`=0.001,`v3`=0.014,`v4`=-0.018,`v5`=5.6,`t`=5,`h`=64.8,`rssi`=226,`ccid`='4600485905031430000099m9990000000036000000g3330,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679767444 WHERE `imei` = '868922055644013' [ RunTime:0.000524s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010767s ] [ 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' , '230326' , '020301' , -0.296 , 0.001 , 0.014 , -0.018 , 5.6 , 5 , 64.8 , 226 , '4600485905031430000099m9990000000036000000g3330,N,00E000=-00.000' , 0 , 0 , 1679767444 , 1679767444) [ RunTime:0.000549s ] --------------------------------------------------------------- [ 2023-03-26T02:32:23+08:00 ] 117.132.196.8 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ sql ] [ DB ] CONNECT:[ UseTime:0.002428s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011322s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000772s ] --------------------------------------------------------------- [ 2023-03-26T02:32:25+08:00 ] 117.132.196.8 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679769143&v1=0.027843&v2=0.215188&v3=0.028505&v4=0.027963&v5=12.420000&t=12.052237&h=43.507141&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001990s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010892s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000706s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679769143,`v1`=0.027843,`v2`=0.215188,`v3`=0.028505,`v4`=0.027963,`v5`=12.42,`t`=12.052237,`h`=43.507141,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679769145 WHERE `imei` = '868922056976109' [ RunTime:0.000664s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011160s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679769143 , 0.027843 , 0.215188 , 0.028505 , 0.027963 , 12.42 , 12.052237 , 43.507141 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1679769145) [ RunTime:0.000652s ] --------------------------------------------------------------- [ 2023-03-26T06:01:50+08:00 ] 117.132.193.43 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002313s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012792s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000741s ] --------------------------------------------------------------- [ 2023-03-26T06:01:59+08:00 ] 117.132.193.43 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230326&time=060101&v1=-01.118&v2=+00.027&v3=-00.786&v4=-00.483&v5=05.7&t=+01.5&h=81.0&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.350&a2=01.180&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001839s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010569s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000717s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230326',`time`='060101',`v1`=-1.118,`v2`=0.027,`v3`=-0.786,`v4`=-0.483,`v5`=5.7,`t`=1.5,`h`=81,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.35,`a2`=1.18,`update_time`=1679781719 WHERE `imei` = '868922055684076' [ RunTime:0.000711s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012648s ] [ 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' , '230326' , '060101' , -1.118 , 0.027 , -0.786 , -0.483 , 5.7 , 1.5 , 81 , 227 , '460044618415249' , -0 , 0.35 , 1.18 , 1679781719 , 1679781719) [ RunTime:0.000694s ] --------------------------------------------------------------- [ 2023-03-26T14:03:55+08:00 ] 39.144.15.37 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002780s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013082s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.002380s ] --------------------------------------------------------------- [ 2023-03-26T14:03:56+08:00 ] 221.178.125.227 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002032s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009794s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000678s ] --------------------------------------------------------------- [ 2023-03-26T14:04:03+08:00 ] 221.178.125.227 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230326&time=140301&v1=-01.295&v2=+00.032&v3=-00.946&v4=-00.023&v5=05.7&t=+14.7&h=60.2&rssi=+231&ccid=4600485905031420000099m9990000000340000001g3050,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002588s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010168s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000704s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230326',`time`='140301',`v1`=-1.295,`v2`=0.032,`v3`=-0.946,`v4`=-0.023,`v5`=5.7,`t`=14.7,`h`=60.2,`rssi`=231,`ccid`='4600485905031420000099m9990000000340000001g3050,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679810643 WHERE `imei` = '868922055643643' [ RunTime:0.000644s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012625s ] [ 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' , '230326' , '140301' , -1.295 , 0.032 , -0.946 , -0.023 , 5.7 , 14.7 , 60.2 , 231 , '4600485905031420000099m9990000000340000001g3050,N,00E000=-00.000' , 0 , 0 , 1679810643 , 1679810643) [ RunTime:0.001277s ] --------------------------------------------------------------- [ 2023-03-26T14:04:05+08:00 ] 39.144.15.37 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230326&time=140301&v1=-00.243&v2=+00.001&v3=+00.020&v4=-00.017&v5=06.0&t=+19.6&h=63.8&rssi=+227&ccid=4600485905031430000099m9990000000039000000g2840,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001624s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012639s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000699s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230326',`time`='140301',`v1`=-0.243,`v2`=0.001,`v3`=0.02,`v4`=-0.017,`v5`=6,`t`=19.6,`h`=63.8,`rssi`=227,`ccid`='4600485905031430000099m9990000000039000000g2840,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679810645 WHERE `imei` = '868922055644013' [ RunTime:0.000542s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011413s ] [ 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' , '230326' , '140301' , -0.243 , 0.001 , 0.02 , -0.017 , 6 , 19.6 , 63.8 , 227 , '4600485905031430000099m9990000000039000000g2840,N,00E000=-00.000' , 0 , 0 , 1679810645 , 1679810645) [ RunTime:0.000551s ] --------------------------------------------------------------- [ 2023-03-26T14:32:24+08:00 ] 39.144.11.17 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ sql ] [ DB ] CONNECT:[ UseTime:0.002663s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011628s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000744s ] --------------------------------------------------------------- [ 2023-03-26T14:32:25+08:00 ] 39.144.11.17 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679812344&v1=0.028023&v2=0.268072&v3=0.028776&v4=0.028023&v5=12.420000&t=16.192123&h=42.919678&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001803s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009584s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000728s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679812344,`v1`=0.028023,`v2`=0.268072,`v3`=0.028776,`v4`=0.028023,`v5`=12.42,`t`=16.192123,`h`=42.919678,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679812345 WHERE `imei` = '868922056976109' [ RunTime:0.000644s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012709s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679812344 , 0.028023 , 0.268072 , 0.028776 , 0.028023 , 12.42 , 16.192123 , 42.919678 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1679812345) [ RunTime:0.000851s ]