--------------------------------------------------------------- [ 2023-05-27T02:03:54+08:00 ] 39.144.8.227 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002898s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010079s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001534s ] --------------------------------------------------------------- [ 2023-05-27T02:03:54+08:00 ] 223.104.255.109 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001532s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009067s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000957s ] --------------------------------------------------------------- [ 2023-05-27T02:04:03+08:00 ] 39.144.8.227 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230527&time=020301&v1=-01.375&v2=+00.016&v3=-00.961&v4=-00.044&v5=06.2&t=+19.6&h=58.8&rssi=+228&ccid=4600485905031420000099m9990000000418000001g3830,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001913s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012949s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000699s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230527',`time`='020301',`v1`=-1.375,`v2`=0.016,`v3`=-0.961,`v4`=-0.044,`v5`=6.2,`t`=19.6,`h`=58.8,`rssi`=228,`ccid`='4600485905031420000099m9990000000418000001g3830,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685124243 WHERE `imei` = '868922055643643' [ RunTime:0.000695s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012281s ] [ 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' , '230527' , '020301' , -1.375 , 0.016 , -0.961 , -0.044 , 6.2 , 19.6 , 58.8 , 228 , '4600485905031420000099m9990000000418000001g3830,N,00E000=-00.000' , 0 , 0 , 1685124243 , 1685124243) [ RunTime:0.001264s ] --------------------------------------------------------------- [ 2023-05-27T02:04:03+08:00 ] 223.104.255.109 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230527&time=020301&v1=-00.296&v2=+00.001&v3=-00.179&v4=-00.003&v5=06.0&t=+19.7&h=61.9&rssi=+222&ccid=4600485905031430000099m9990000000021000000g3040,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001718s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009671s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000814s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230527',`time`='020301',`v1`=-0.296,`v2`=0.001,`v3`=-0.179,`v4`=-0.003,`v5`=6,`t`=19.7,`h`=61.9,`rssi`=222,`ccid`='4600485905031430000099m9990000000021000000g3040,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685124243 WHERE `imei` = '868922055644013' [ RunTime:0.000665s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012287s ] [ 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' , '230527' , '020301' , -0.296 , 0.001 , -0.179 , -0.003 , 6 , 19.7 , 61.9 , 222 , '4600485905031430000099m9990000000021000000g3040,N,00E000=-00.000' , 0 , 0 , 1685124243 , 1685124243) [ RunTime:0.000565s ] --------------------------------------------------------------- [ 2023-05-27T11:16:27+08:00 ] 39.144.5.120 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.003071s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022546s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001417s ] --------------------------------------------------------------- [ 2023-05-27T11:16:29+08:00 ] 39.144.5.120 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1685157387&v1=0.029408&v2=0.014812&v3=0.028355&v4=0.001294&v5=11.880000&t=22.680809&h=78.869385&rssi=10&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002081s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010397s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000653s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1685157387,`v1`=0.029408,`v2`=0.014812,`v3`=0.028355,`v4`=0.001294,`v5`=11.88,`t`=22.680809,`h`=78.869385,`rssi`=10,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1685157389 WHERE `imei` = '868922055678110' [ RunTime:0.000710s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010361s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1685157387 , 0.029408 , 0.014812 , 0.028355 , 0.001294 , 11.88 , 22.680809 , 78.869385 , 10 , '898604650119C1078513' , '460048590708513' , -0 , 1685157389) [ RunTime:0.001187s ] --------------------------------------------------------------- [ 2023-05-27T14:03:54+08:00 ] 111.55.141.44 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002435s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012345s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001373s ] --------------------------------------------------------------- [ 2023-05-27T14:03:55+08:00 ] 39.144.16.232 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001832s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009839s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001357s ] --------------------------------------------------------------- [ 2023-05-27T14:04:03+08:00 ] 111.55.141.44 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230527&time=140301&v1=-01.375&v2=+00.030&v3=-00.957&v4=-00.043&v5=06.2&t=+27.7&h=57.3&rssi=+231&ccid=4600485905031420000099m9990000000420000001g3820,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001543s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009649s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000713s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230527',`time`='140301',`v1`=-1.375,`v2`=0.03,`v3`=-0.957,`v4`=-0.043,`v5`=6.2,`t`=27.7,`h`=57.3,`rssi`=231,`ccid`='4600485905031420000099m9990000000420000001g3820,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685167443 WHERE `imei` = '868922055643643' [ RunTime:0.000600s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014354s ] [ 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' , '230527' , '140301' , -1.375 , 0.03 , -0.957 , -0.043 , 6.2 , 27.7 , 57.3 , 231 , '4600485905031420000099m9990000000420000001g3820,N,00E000=-00.000' , 0 , 0 , 1685167443 , 1685167443) [ RunTime:0.000617s ] --------------------------------------------------------------- [ 2023-05-27T14:04:04+08:00 ] 39.144.16.232 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230527&time=140301&v1=-00.320&v2=+00.001&v3=+00.015&v4=-00.003&v5=05.7&t=+27.3&h=60.3&rssi=+222&ccid=4600485905031430000099m9990000000041000000g3450,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001625s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008902s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000670s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230527',`time`='140301',`v1`=-0.32,`v2`=0.001,`v3`=0.015,`v4`=-0.003,`v5`=5.7,`t`=27.3,`h`=60.3,`rssi`=222,`ccid`='4600485905031430000099m9990000000041000000g3450,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685167444 WHERE `imei` = '868922055644013' [ RunTime:0.000534s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009106s ] [ 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' , '230527' , '140301' , -0.32 , 0.001 , 0.015 , -0.003 , 5.7 , 27.3 , 60.3 , 222 , '4600485905031430000099m9990000000041000000g3450,N,00E000=-00.000' , 0 , 0 , 1685167444 , 1685167444) [ RunTime:0.000548s ] --------------------------------------------------------------- [ 2023-05-27T14:43:23+08:00 ] 111.55.138.151 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002593s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011649s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000688s ] --------------------------------------------------------------- [ 2023-05-27T14:43:24+08:00 ] 111.55.138.151 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1685169803&v1=0.016766&v2=0.015542&v3=0.014057&v4=-0.011769&v5=12.420000&t=23.463739&h=77.274841&rssi=30&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&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.009460s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1685169803,`v1`=0.016766,`v2`=0.015542,`v3`=0.014057,`v4`=-0.011769,`v5`=12.42,`t`=23.463739,`h`=77.274841,`rssi`=30,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1685169804 WHERE `imei` = '868922055684548' [ RunTime:0.000598s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011746s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1685169803 , 0.016766 , 0.015542 , 0.014057 , -0.011769 , 12.42 , 23.463739 , 77.274841 , 30 , '898604650119C1053137' , '460048590503137' , -0 , 1685169804) [ RunTime:0.000695s ] --------------------------------------------------------------- [ 2023-05-27T16:58:07+08:00 ] 111.55.140.80 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002819s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011475s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000769s ] --------------------------------------------------------------- [ 2023-05-27T16:58:08+08:00 ] 111.55.140.80 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1685177887&v1=0.018331&v2=0.013456&v3=0.016314&v4=-0.000151&v5=12.240000&t=23.345764&h=79.914612&rssi=28&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.186340,35.987197&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001652s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009579s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000707s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1685177887,`v1`=0.018331,`v2`=0.013456,`v3`=0.016314,`v4`=-0.000151,`v5`=12.24,`t`=23.345764,`h`=79.914612,`rssi`=28,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.186340,35.987197',`update_time`=1685177888 WHERE `imei` = '868922055647586' [ RunTime:0.000674s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012485s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055647586' , 1685177887 , 0.018331 , 0.013456 , 0.016314 , -0.000151 , 12.24 , 23.345764 , 79.914612 , 28 , '898604650119C1078512' , '460048590708512' , -0 , '120.186340,35.987197' , 1685177888) [ RunTime:0.000704s ] --------------------------------------------------------------- [ 2023-05-27T17:38:16+08:00 ] 221.178.127.189 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002547s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012443s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000805s ] --------------------------------------------------------------- [ 2023-05-27T17:38:17+08:00 ] 221.178.127.189 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1685180296&v1=0.027722&v2=0.012726&v3=0.026639&v4=0.015923&v5=12.240000&t=23.335039&h=77.541870&rssi=26&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.183709,35.984214&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002050s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009357s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000686s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1685180296,`v1`=0.027722,`v2`=0.012726,`v3`=0.026639,`v4`=0.015923,`v5`=12.24,`t`=23.335039,`h`=77.54187,`rssi`=26,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.183709,35.984214',`update_time`=1685180297 WHERE `imei` = '868922056976208' [ RunTime:0.000719s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008969s ] [ 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' , 1685180296 , 0.027722 , 0.012726 , 0.026639 , 0.015923 , 12.24 , 23.335039 , 77.54187 , 26 , '898604650119C1053139' , '460048590503139' , -0 , '120.183709,35.984214' , 1685180297) [ RunTime:0.000599s ] --------------------------------------------------------------- [ 2023-05-27T17:43:21+08:00 ] 218.204.252.28 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002389s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011141s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000708s ] --------------------------------------------------------------- [ 2023-05-27T17:43:23+08:00 ] 218.204.252.28 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1685180601&v1=0.020619&v2=0.015125&v3=0.016676&v4=-0.006953&v5=12.420000&t=23.345764&h=79.517883&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001823s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011625s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000745s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1685180601,`v1`=0.020619,`v2`=0.015125,`v3`=0.016676,`v4`=-0.006953,`v5`=12.42,`t`=23.345764,`h`=79.517883,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1685180603 WHERE `imei` = '868922055684209' [ RunTime:0.000661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012392s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1685180601 , 0.020619 , 0.015125 , 0.016676 , -0.006953 , 12.42 , 23.345764 , 79.517883 , 27 , '898604650119C1078511' , '460048590708511' , -0 , 1685180603) [ RunTime:0.000619s ] --------------------------------------------------------------- [ 2023-05-27T18:07:50+08:00 ] 39.144.12.159 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002109s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011270s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000649s ] --------------------------------------------------------------- [ 2023-05-27T18:07:59+08:00 ] 39.144.12.159 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230527&time=180701&v1=-01.194&v2=+00.017&v3=-01.059&v4=-00.515&v5=06.0&t=+24.9&h=77.9&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.162&a2=01.241&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002905s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015467s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000673s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230527',`time`='180701',`v1`=-1.194,`v2`=0.017,`v3`=-1.059,`v4`=-0.515,`v5`=6,`t`=24.9,`h`=77.9,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.162,`a2`=1.241,`update_time`=1685182079 WHERE `imei` = '868922055684076' [ RunTime:0.000561s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010305s ] [ 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' , '230527' , '180701' , -1.194 , 0.017 , -1.059 , -0.515 , 6 , 24.9 , 77.9 , 227 , '460044618415249' , -0 , 0.162 , 1.241 , 1685182079 , 1685182079) [ RunTime:0.000529s ] --------------------------------------------------------------- [ 2023-05-27T18:08:21+08:00 ] 111.55.140.109 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002096s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010980s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2023-05-27T18:08:22+08:00 ] 111.55.140.109 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1685182101&v1=0.018753&v2=0.015020&v3=0.016043&v4=-0.004846&v5=12.420000&t=23.217064&h=82.188171&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001883s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011248s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000655s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1685182101,`v1`=0.018753,`v2`=0.01502,`v3`=0.016043,`v4`=-0.004846,`v5`=12.42,`t`=23.217064,`h`=82.188171,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1685182102 WHERE `imei` = '868922055683920' [ RunTime:0.000536s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011088s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1685182101 , 0.018753 , 0.01502 , 0.016043 , -0.004846 , 12.42 , 23.217064 , 82.188171 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1685182102) [ RunTime:0.000494s ] --------------------------------------------------------------- [ 2023-05-27T20:55:24+08:00 ] 39.144.15.12 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002294s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010810s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000987s ] --------------------------------------------------------------- [ 2023-05-27T20:55:26+08:00 ] 39.144.15.12 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1685192124&v1=0.031756&v2=0.013664&v3=0.028686&v4=0.008157&v5=12.600000&t=22.755884&h=80.936951&rssi=30&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001654s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010144s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000819s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1685192124,`v1`=0.031756,`v2`=0.013664,`v3`=0.028686,`v4`=0.008157,`v5`=12.6,`t`=22.755884,`h`=80.936951,`rssi`=30,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1685192126 WHERE `imei` = '868922055683912' [ RunTime:0.000607s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011597s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1685192124 , 0.031756 , 0.013664 , 0.028686 , 0.008157 , 12.6 , 22.755884 , 80.936951 , 30 , '898604650119C1053138' , '460048590503138' , -0 , 1685192126) [ RunTime:0.000732s ] --------------------------------------------------------------- [ 2023-05-27T21:00:24+08:00 ] 111.55.140.209 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002589s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012170s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000703s ] --------------------------------------------------------------- [ 2023-05-27T21:00:26+08:00 ] 111.55.140.209 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1685192424&v1=0.018993&v2=0.013769&v3=0.016254&v4=-0.017127&v5=12.420000&t=22.734434&h=81.715149&rssi=27&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001728s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010609s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000723s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1685192424,`v1`=0.018993,`v2`=0.013769,`v3`=0.016254,`v4`=-0.017127,`v5`=12.42,`t`=22.734434,`h`=81.715149,`rssi`=27,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`update_time`=1685192426 WHERE `imei` = '868922055683771' [ RunTime:0.000545s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018950s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683771' , 1685192424 , 0.018993 , 0.013769 , 0.016254 , -0.017127 , 12.42 , 22.734434 , 81.715149 , 27 , '898604650119C1053136' , '460048590503136' , -0 , 1685192426) [ RunTime:0.000567s ] --------------------------------------------------------------- [ 2023-05-27T23:38:24+08:00 ] 39.144.15.66 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002717s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011973s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000739s ] --------------------------------------------------------------- [ 2023-05-27T23:38:26+08:00 ] 39.144.15.66 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1685201904&v1=0.007013&v2=0.014082&v3=0.004876&v4=-0.016043&v5=12.420000&t=22.616457&h=80.273193&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002110s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009950s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000746s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1685201904,`v1`=0.007013,`v2`=0.014082,`v3`=0.004876,`v4`=-0.016043,`v5`=12.42,`t`=22.616457,`h`=80.273193,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1685201906 WHERE `imei` = '868922055644021' [ RunTime:0.000616s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012648s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1685201904 , 0.007013 , 0.014082 , 0.004876 , -0.016043 , 12.42 , 22.616457 , 80.273193 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1685201906) [ RunTime:0.000724s ] --------------------------------------------------------------- [ 2023-05-27T23:59:24+08:00 ] 39.144.15.88 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002775s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010664s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000700s ] --------------------------------------------------------------- [ 2023-05-27T23:59:26+08:00 ] 39.144.15.88 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1685203164&v1=0.021281&v2=0.016063&v3=0.018301&v4=-0.006291&v5=12.240000&t=22.627182&h=79.105896&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001733s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009110s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1685203164,`v1`=0.021281,`v2`=0.016063,`v3`=0.018301,`v4`=-0.006291,`v5`=12.24,`t`=22.627182,`h`=79.105896,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1685203166 WHERE `imei` = '868922055680850' [ RunTime:0.000729s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011757s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1685203164 , 0.021281 , 0.016063 , 0.018301 , -0.006291 , 12.24 , 22.627182 , 79.105896 , 25 , '898604650119C1078510' , '460048590708510' , -0 , 1685203166) [ RunTime:0.000625s ]