--------------------------------------------------------------- [ 2023-06-15T00:17:19+08:00 ] 39.144.17.55 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.013431s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011597s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000759s ] --------------------------------------------------------------- [ 2023-06-15T00:17:20+08:00 ] 39.144.17.55 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1686759439&v1=0.021221&v2=0.014395&v3=0.018572&v4=-0.006291&v5=12.240000&t=25.458609&h=79.021973&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&gps=120.185163,35.987011&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002049s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012982s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000765s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1686759439,`v1`=0.021221,`v2`=0.014395,`v3`=0.018572,`v4`=-0.006291,`v5`=12.24,`t`=25.458609,`h`=79.021973,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`gps`='120.185163,35.987011',`update_time`=1686759440 WHERE `imei` = '868922055680850' [ RunTime:0.000669s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011988s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055680850' , 1686759439 , 0.021221 , 0.014395 , 0.018572 , -0.006291 , 12.24 , 25.458609 , 79.021973 , 25 , '898604650119C1078510' , '460048590708510' , -0 , '120.185163,35.987011' , 1686759440) [ RunTime:0.001344s ] --------------------------------------------------------------- [ 2023-06-15T02:03:54+08:00 ] 39.144.1.2 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002550s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014320s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000764s ] --------------------------------------------------------------- [ 2023-06-15T02:03:55+08:00 ] 39.144.5.63 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001682s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011275s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000642s ] --------------------------------------------------------------- [ 2023-06-15T02:04:03+08:00 ] 39.144.1.2 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230615&time=020301&v1=-00.327&v2=+00.001&v3=-00.065&v4=-00.002&v5=06.0&t=+20.8&h=62.8&rssi=+222&ccid=4600485905031430000099m9990000000034000000g3390,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001716s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011557s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230615',`time`='020301',`v1`=-0.327,`v2`=0.001,`v3`=-0.065,`v4`=-0.002,`v5`=6,`t`=20.8,`h`=62.8,`rssi`=222,`ccid`='4600485905031430000099m9990000000034000000g3390,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686765843 WHERE `imei` = '868922055644013' [ RunTime:0.000610s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011262s ] [ 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' , '230615' , '020301' , -0.327 , 0.001 , -0.065 , -0.002 , 6 , 20.8 , 62.8 , 222 , '4600485905031430000099m9990000000034000000g3390,N,00E000=-00.000' , 0 , 0 , 1686765843 , 1686765843) [ RunTime:0.000790s ] --------------------------------------------------------------- [ 2023-06-15T02:04:03+08:00 ] 39.144.5.63 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230615&time=020301&v1=-01.395&v2=+00.012&v3=-00.975&v4=-00.045&v5=06.2&t=+20.6&h=59.5&rssi=+228&ccid=4600485905031420000099m9990000000425000001g4030,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001697s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010599s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000717s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230615',`time`='020301',`v1`=-1.395,`v2`=0.012,`v3`=-0.975,`v4`=-0.045,`v5`=6.2,`t`=20.6,`h`=59.5,`rssi`=228,`ccid`='4600485905031420000099m9990000000425000001g4030,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686765843 WHERE `imei` = '868922055643643' [ RunTime:0.000565s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011476s ] [ 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' , '230615' , '020301' , -1.395 , 0.012 , -0.975 , -0.045 , 6.2 , 20.6 , 59.5 , 228 , '4600485905031420000099m9990000000425000001g4030,N,00E000=-00.000' , 0 , 0 , 1686765843 , 1686765843) [ RunTime:0.000565s ] --------------------------------------------------------------- [ 2023-06-15T11:35:28+08:00 ] 39.144.10.90 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002959s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011581s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000724s ] --------------------------------------------------------------- [ 2023-06-15T11:35:29+08:00 ] 39.144.10.90 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1686800128&v1=0.030371&v2=0.014707&v3=0.026549&v4=0.001415&v5=12.420000&t=26.059214&h=79.105896&rssi=30&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001738s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008873s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000664s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1686800128,`v1`=0.030371,`v2`=0.014707,`v3`=0.026549,`v4`=0.001415,`v5`=12.42,`t`=26.059214,`h`=79.105896,`rssi`=30,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1686800129 WHERE `imei` = '868922055678110' [ RunTime:0.000612s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011415s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1686800128 , 0.030371 , 0.014707 , 0.026549 , 0.001415 , 12.42 , 26.059214 , 79.105896 , 30 , '898604650119C1078513' , '460048590708513' , -0 , 1686800129) [ RunTime:0.000726s ] --------------------------------------------------------------- [ 2023-06-15T14:03:54+08:00 ] 117.132.192.68 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002464s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012977s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001451s ] --------------------------------------------------------------- [ 2023-06-15T14:03:55+08:00 ] 111.55.141.112 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001984s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010013s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000740s ] --------------------------------------------------------------- [ 2023-06-15T14:04:02+08:00 ] 117.132.192.68 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230615&time=140301&v1=-01.393&v2=+00.026&v3=-00.970&v4=-00.044&v5=06.4&t=+39.0&h=54.2&rssi=+230&ccid=4600485905031420000099m9990000000427000001g3990,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001614s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010185s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000648s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230615',`time`='140301',`v1`=-1.393,`v2`=0.026,`v3`=-0.97,`v4`=-0.044,`v5`=6.4,`t`=39,`h`=54.2,`rssi`=230,`ccid`='4600485905031420000099m9990000000427000001g3990,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686809042 WHERE `imei` = '868922055643643' [ RunTime:0.000600s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010798s ] [ 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' , '230615' , '140301' , -1.393 , 0.026 , -0.97 , -0.044 , 6.4 , 39 , 54.2 , 230 , '4600485905031420000099m9990000000427000001g3990,N,00E000=-00.000' , 0 , 0 , 1686809042 , 1686809042) [ RunTime:0.001570s ] --------------------------------------------------------------- [ 2023-06-15T14:04:03+08:00 ] 111.55.141.112 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230615&time=140301&v1=-00.464&v2=+00.001&v3=+00.019&v4=+00.000&v5=06.2&t=+34.8&h=59.8&rssi=+222&ccid=4600485905031430000099m9990000000046000000g4870,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001690s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011385s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000671s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230615',`time`='140301',`v1`=-0.464,`v2`=0.001,`v3`=0.019,`v4`=0,`v5`=6.2,`t`=34.8,`h`=59.8,`rssi`=222,`ccid`='4600485905031430000099m9990000000046000000g4870,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686809043 WHERE `imei` = '868922055644013' [ RunTime:0.000567s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011764s ] [ 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' , '230615' , '140301' , -0.464 , 0.001 , 0.019 , 0 , 6.2 , 34.8 , 59.8 , 222 , '4600485905031430000099m9990000000046000000g4870,N,00E000=-00.000' , 0 , 0 , 1686809043 , 1686809043) [ RunTime:0.001192s ] --------------------------------------------------------------- [ 2023-06-15T15:02:22+08:00 ] 117.132.196.251 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002356s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012805s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000725s ] --------------------------------------------------------------- [ 2023-06-15T15:02:23+08:00 ] 117.132.196.251 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1686812542&v1=0.016766&v2=0.016689&v3=0.014659&v4=-0.011649&v5=12.420000&t=26.295166&h=77.969116&rssi=29&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001915s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013139s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000722s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1686812542,`v1`=0.016766,`v2`=0.016689,`v3`=0.014659,`v4`=-0.011649,`v5`=12.42,`t`=26.295166,`h`=77.969116,`rssi`=29,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1686812543 WHERE `imei` = '868922055684548' [ RunTime:0.000679s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012703s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1686812542 , 0.016766 , 0.016689 , 0.014659 , -0.011649 , 12.42 , 26.295166 , 77.969116 , 29 , '898604650119C1053137' , '460048590503137' , -0 , 1686812543) [ RunTime:0.001361s ] --------------------------------------------------------------- [ 2023-06-15T16:46:48+08:00 ] 112.27.238.179 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002381s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.014641s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001266s ] --------------------------------------------------------------- [ 2023-06-15T16:46:49+08:00 ] 112.27.238.179 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001482s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011720s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000486s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000599s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000631s ] --------------------------------------------------------------- [ 2023-06-15T16:46:59+08:00 ] 112.27.238.179 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002010s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011242s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000566s ] --------------------------------------------------------------- [ 2023-06-15T17:14:23+08:00 ] 117.132.193.236 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002948s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012865s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000814s ] --------------------------------------------------------------- [ 2023-06-15T17:14:24+08:00 ] 117.132.193.236 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1686820463&v1=0.018271&v2=0.014395&v3=0.016465&v4=0.000090&v5=12.240000&t=26.220091&h=79.334778&rssi=28&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002197s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011307s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000720s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1686820463,`v1`=0.018271,`v2`=0.014395,`v3`=0.016465,`v4`=9.0E-5,`v5`=12.24,`t`=26.220091,`h`=79.334778,`rssi`=28,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1686820464 WHERE `imei` = '868922055647586' [ RunTime:0.000692s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011822s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1686820463 , 0.018271 , 0.014395 , 0.016465 , 9.0E-5 , 12.24 , 26.220091 , 79.334778 , 28 , '898604650119C1078512' , '460048590708512' , -0 , 1686820464) [ RunTime:0.001410s ] --------------------------------------------------------------- [ 2023-06-15T17:26:23+08:00 ] 112.27.238.183 GET /home/device/group.html?cmd=redirect&arubalp=12345 [ sql ] [ DB ] CONNECT:[ UseTime:0.002115s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011223s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000580s ] --------------------------------------------------------------- [ 2023-06-15T17:26:30+08:00 ] 112.27.238.182 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001459s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011431s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000562s ] --------------------------------------------------------------- [ 2023-06-15T17:54:00+08:00 ] 221.178.124.151 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.003030s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011498s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000725s ] --------------------------------------------------------------- [ 2023-06-15T17:54:02+08:00 ] 221.178.124.151 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1686822840&v1=0.026819&v2=0.014082&v3=0.027572&v4=0.015682&v5=12.240000&t=26.123564&h=77.305359&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.185020,35.986431&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001682s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011112s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000688s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1686822840,`v1`=0.026819,`v2`=0.014082,`v3`=0.027572,`v4`=0.015682,`v5`=12.24,`t`=26.123564,`h`=77.305359,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.185020,35.986431',`update_time`=1686822842 WHERE `imei` = '868922056976208' [ RunTime:0.000740s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011353s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922056976208' , 1686822840 , 0.026819 , 0.014082 , 0.027572 , 0.015682 , 12.24 , 26.123564 , 77.305359 , 27 , '898604650119C1053139' , '460048590503139' , -0 , '120.185020,35.986431' , 1686822842) [ RunTime:0.001179s ] --------------------------------------------------------------- [ 2023-06-15T18:02:21+08:00 ] 111.55.141.72 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002553s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013393s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000730s ] --------------------------------------------------------------- [ 2023-06-15T18:02:22+08:00 ] 111.55.141.72 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1686823341&v1=0.020920&v2=0.014499&v3=0.017007&v4=-0.006833&v5=12.420000&t=26.145014&h=79.494995&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001735s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010898s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000710s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1686823341,`v1`=0.02092,`v2`=0.014499,`v3`=0.017007,`v4`=-0.006833,`v5`=12.42,`t`=26.145014,`h`=79.494995,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1686823342 WHERE `imei` = '868922055684209' [ RunTime:0.000573s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010276s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1686823341 , 0.02092 , 0.014499 , 0.017007 , -0.006833 , 12.42 , 26.145014 , 79.494995 , 27 , '898604650119C1078511' , '460048590708511' , -0 , 1686823342) [ RunTime:0.001135s ] --------------------------------------------------------------- [ 2023-06-15T18:27:22+08:00 ] 39.144.8.122 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002444s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011202s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.001164s ] --------------------------------------------------------------- [ 2023-06-15T18:27:23+08:00 ] 39.144.8.122 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1686824842&v1=0.018993&v2=0.013769&v3=0.016435&v4=-0.004545&v5=12.420000&t=26.037764&h=83.500427&rssi=25&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001758s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008472s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000630s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1686824842,`v1`=0.018993,`v2`=0.013769,`v3`=0.016435,`v4`=-0.004545,`v5`=12.42,`t`=26.037764,`h`=83.500427,`rssi`=25,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1686824843 WHERE `imei` = '868922055683920' [ RunTime:0.000569s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010917s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1686824842 , 0.018993 , 0.013769 , 0.016435 , -0.004545 , 12.42 , 26.037764 , 83.500427 , 25 , '89860426102071188500' , '460044618415250' , -0 , 1686824843) [ RunTime:0.000652s ] --------------------------------------------------------------- [ 2023-06-15T21:12:24+08:00 ] 39.144.15.21 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002143s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013888s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000726s ] --------------------------------------------------------------- [ 2023-06-15T21:12:26+08:00 ] 39.144.15.21 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1686834744&v1=0.031696&v2=0.014916&v3=0.029137&v4=0.008037&v5=12.420000&t=25.372808&h=82.119507&rssi=18&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001985s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010788s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000672s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1686834744,`v1`=0.031696,`v2`=0.014916,`v3`=0.029137,`v4`=0.008037,`v5`=12.42,`t`=25.372808,`h`=82.119507,`rssi`=18,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1686834746 WHERE `imei` = '868922055683912' [ RunTime:0.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010893s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1686834744 , 0.031696 , 0.014916 , 0.029137 , 0.008037 , 12.42 , 25.372808 , 82.119507 , 18 , '898604650119C1053138' , '460048590503138' , -0 , 1686834746) [ RunTime:0.001225s ] --------------------------------------------------------------- [ 2023-06-15T21:19:23+08:00 ] 111.55.140.231 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002356s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010901s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000674s ] --------------------------------------------------------------- [ 2023-06-15T21:19:25+08:00 ] 111.55.140.231 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1686835163&v1=0.019294&v2=0.013769&v3=0.016224&v4=-0.017308&v5=12.420000&t=25.362083&h=83.004517&rssi=28&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001460s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021616s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000654s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1686835163,`v1`=0.019294,`v2`=0.013769,`v3`=0.016224,`v4`=-0.017308,`v5`=12.42,`t`=25.362083,`h`=83.004517,`rssi`=28,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`update_time`=1686835165 WHERE `imei` = '868922055683771' [ RunTime:0.000604s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010692s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683771' , 1686835163 , 0.019294 , 0.013769 , 0.016224 , -0.017308 , 12.42 , 25.362083 , 83.004517 , 28 , '898604650119C1053136' , '460048590503136' , -0 , 1686835165) [ RunTime:0.000598s ] --------------------------------------------------------------- [ 2023-06-15T22:09:50+08:00 ] 39.144.11.109 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002521s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011473s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000703s ] --------------------------------------------------------------- [ 2023-06-15T22:09:59+08:00 ] 39.144.11.109 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230615&time=220901&v1=-01.135&v2=+00.016&v3=-01.006&v4=-00.209&v5=06.0&t=+21.5&h=78.9&rssi=+221&imsi=460044618415249&v6=-00.000&a1=00.161&a2=01.207&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001653s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012410s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000705s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230615',`time`='220901',`v1`=-1.135,`v2`=0.016,`v3`=-1.006,`v4`=-0.209,`v5`=6,`t`=21.5,`h`=78.9,`rssi`=221,`imsi`='460044618415249',`v6`=-0,`a1`=0.161,`a2`=1.207,`update_time`=1686838199 WHERE `imei` = '868922055684076' [ RunTime:0.000585s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012065s ] [ 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' , '230615' , '220901' , -1.135 , 0.016 , -1.006 , -0.209 , 6 , 21.5 , 78.9 , 221 , '460044618415249' , -0 , 0.161 , 1.207 , 1686838199 , 1686838199) [ RunTime:0.000718s ] --------------------------------------------------------------- [ 2023-06-15T23:57:23+08:00 ] 39.144.16.172 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002637s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011614s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000678s ] --------------------------------------------------------------- [ 2023-06-15T23:57:25+08:00 ] 39.144.16.172 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1686844643&v1=0.007856&v2=0.013247&v3=0.005147&v4=-0.015863&v5=12.420000&t=25.265556&h=81.059021&rssi=11&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001512s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010463s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000644s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1686844643,`v1`=0.007856,`v2`=0.013247,`v3`=0.005147,`v4`=-0.015863,`v5`=12.42,`t`=25.265556,`h`=81.059021,`rssi`=11,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1686844645 WHERE `imei` = '868922055644021' [ RunTime:0.000599s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011519s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1686844643 , 0.007856 , 0.013247 , 0.005147 , -0.015863 , 12.42 , 25.265556 , 81.059021 , 11 , '898604650119C1053141' , '460048590503141' , -0 , 1686844645) [ RunTime:0.000612s ]