--------------------------------------------------------------- [ 2023-03-27T02:03:54+08:00 ] 117.132.194.149 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003674s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012626s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001946s ] --------------------------------------------------------------- [ 2023-03-27T02:03:55+08:00 ] 111.55.137.25 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002361s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009619s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000654s ] --------------------------------------------------------------- [ 2023-03-27T02:04:03+08:00 ] 117.132.194.149 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230327&time=020301&v1=-01.295&v2=+00.017&v3=-00.951&v4=-00.023&v5=05.7&t=+05.1&h=61.9&rssi=+228&ccid=4600485905031420000099m9990000000337000001g3060,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001815s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010036s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001018s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230327',`time`='020301',`v1`=-1.295,`v2`=0.017,`v3`=-0.951,`v4`=-0.023,`v5`=5.7,`t`=5.1,`h`=61.9,`rssi`=228,`ccid`='4600485905031420000099m9990000000337000001g3060,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679853843 WHERE `imei` = '868922055643643' [ RunTime:0.000629s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012192s ] [ 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' , '230327' , '020301' , -1.295 , 0.017 , -0.951 , -0.023 , 5.7 , 5.1 , 61.9 , 228 , '4600485905031420000099m9990000000337000001g3060,N,00E000=-00.000' , 0 , 0 , 1679853843 , 1679853843) [ RunTime:0.001762s ] --------------------------------------------------------------- [ 2023-03-27T02:04:03+08:00 ] 111.55.137.25 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230327&time=020301&v1=-00.290&v2=+00.001&v3=-00.157&v4=-00.015&v5=05.7&t=+06.3&h=64.7&rssi=+225&ccid=4600485905031430000099m9990000000018000000g3300,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001798s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009632s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000639s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230327',`time`='020301',`v1`=-0.29,`v2`=0.001,`v3`=-0.157,`v4`=-0.015,`v5`=5.7,`t`=6.3,`h`=64.7,`rssi`=225,`ccid`='4600485905031430000099m9990000000018000000g3300,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679853843 WHERE `imei` = '868922055644013' [ RunTime:0.000525s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008976s ] [ 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' , '230327' , '020301' , -0.29 , 0.001 , -0.157 , -0.015 , 5.7 , 6.3 , 64.7 , 225 , '4600485905031430000099m9990000000018000000g3300,N,00E000=-00.000' , 0 , 0 , 1679853843 , 1679853843) [ RunTime:0.000587s ] --------------------------------------------------------------- [ 2023-03-27T02:32:23+08:00 ] 39.144.15.247 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ sql ] [ DB ] CONNECT:[ UseTime:0.002494s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011827s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000770s ] --------------------------------------------------------------- [ 2023-03-27T02:32:25+08:00 ] 39.144.15.247 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679855543&v1=0.028204&v2=0.640035&v3=0.028625&v4=0.028023&v5=12.420000&t=12.213113&h=43.522400&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001651s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010523s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000671s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679855543,`v1`=0.028204,`v2`=0.640035,`v3`=0.028625,`v4`=0.028023,`v5`=12.42,`t`=12.213113,`h`=43.5224,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679855545 WHERE `imei` = '868922056976109' [ RunTime:0.000608s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013425s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679855543 , 0.028204 , 0.640035 , 0.028625 , 0.028023 , 12.42 , 12.213113 , 43.5224 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1679855545) [ RunTime:0.000732s ] --------------------------------------------------------------- [ 2023-03-27T06:00:52+08:00 ] 39.144.14.3 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002173s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012647s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000810s ] --------------------------------------------------------------- [ 2023-03-27T06:01:00+08:00 ] 39.144.14.3 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230327&time=060001&v1=-01.148&v2=+00.022&v3=-00.952&v4=-00.509&v5=05.7&t=+02.4&h=80.9&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.229&a2=01.204&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001981s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010857s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000705s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230327',`time`='060001',`v1`=-1.148,`v2`=0.022,`v3`=-0.952,`v4`=-0.509,`v5`=5.7,`t`=2.4,`h`=80.9,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.229,`a2`=1.204,`update_time`=1679868060 WHERE `imei` = '868922055684076' [ RunTime:0.000609s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011137s ] [ 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' , '230327' , '060001' , -1.148 , 0.022 , -0.952 , -0.509 , 5.7 , 2.4 , 80.9 , 228 , '460044618415249' , -0 , 0.229 , 1.204 , 1679868060 , 1679868060) [ RunTime:0.000669s ] --------------------------------------------------------------- [ 2023-03-27T14:03:55+08:00 ] 39.144.8.85 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.003108s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011510s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001360s ] --------------------------------------------------------------- [ 2023-03-27T14:03:55+08:00 ] 117.132.192.174 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001757s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011626s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000780s ] --------------------------------------------------------------- [ 2023-03-27T14:04:03+08:00 ] 39.144.8.85 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230327&time=140301&v1=-00.247&v2=+00.001&v3=+00.020&v4=-00.017&v5=06.0&t=+23.0&h=63.2&rssi=+225&ccid=4600485905031430000099m9990000000039000000g2900,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001667s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011101s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000725s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230327',`time`='140301',`v1`=-0.247,`v2`=0.001,`v3`=0.02,`v4`=-0.017,`v5`=6,`t`=23,`h`=63.2,`rssi`=225,`ccid`='4600485905031430000099m9990000000039000000g2900,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679897043 WHERE `imei` = '868922055644013' [ RunTime:0.000761s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015274s ] [ 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' , '230327' , '140301' , -0.247 , 0.001 , 0.02 , -0.017 , 6 , 23 , 63.2 , 225 , '4600485905031430000099m9990000000039000000g2900,N,00E000=-00.000' , 0 , 0 , 1679897043 , 1679897043) [ RunTime:0.001239s ] --------------------------------------------------------------- [ 2023-03-27T14:04:04+08:00 ] 117.132.192.174 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230327&time=140301&v1=-01.292&v2=+00.050&v3=-00.942&v4=-00.022&v5=05.7&t=+20.6&h=59.5&rssi=+228&ccid=4600485905031420000099m9990000000343000001g3020,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001999s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009788s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000782s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230327',`time`='140301',`v1`=-1.292,`v2`=0.05,`v3`=-0.942,`v4`=-0.022,`v5`=5.7,`t`=20.6,`h`=59.5,`rssi`=228,`ccid`='4600485905031420000099m9990000000343000001g3020,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679897044 WHERE `imei` = '868922055643643' [ RunTime:0.000605s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011165s ] [ 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' , '230327' , '140301' , -1.292 , 0.05 , -0.942 , -0.022 , 5.7 , 20.6 , 59.5 , 228 , '4600485905031420000099m9990000000343000001g3020,N,00E000=-00.000' , 0 , 0 , 1679897044 , 1679897044) [ RunTime:0.000594s ] --------------------------------------------------------------- [ 2023-03-27T14:32:24+08:00 ] 39.144.10.219 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ sql ] [ DB ] CONNECT:[ UseTime:0.002325s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010672s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000666s ] --------------------------------------------------------------- [ 2023-03-27T14:32:25+08:00 ] 39.144.10.219 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679898744&v1=0.028204&v2=0.265151&v3=0.028896&v4=0.028023&v5=12.240000&t=17.597113&h=43.041748&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001581s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010976s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000819s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679898744,`v1`=0.028204,`v2`=0.265151,`v3`=0.028896,`v4`=0.028023,`v5`=12.24,`t`=17.597113,`h`=43.041748,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679898745 WHERE `imei` = '868922056976109' [ RunTime:0.000626s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013101s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679898744 , 0.028204 , 0.265151 , 0.028896 , 0.028023 , 12.24 , 17.597113 , 43.041748 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1679898745) [ RunTime:0.000740s ]