--------------------------------------------------------------- [ 2023-06-17T00:19:18+08:00 ] 39.144.2.8 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002747s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013415s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000753s ] --------------------------------------------------------------- [ 2023-06-17T00:19:19+08:00 ] 39.144.2.8 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1686932358&v1=0.021401&v2=0.012517&v3=0.018662&v4=-0.006351&v5=12.240000&t=25.909063&h=78.999084&rssi=26&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&gps=120.185118,35.986739&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001618s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010183s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1686932358,`v1`=0.021401,`v2`=0.012517,`v3`=0.018662,`v4`=-0.006351,`v5`=12.24,`t`=25.909063,`h`=78.999084,`rssi`=26,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`gps`='120.185118,35.986739',`update_time`=1686932359 WHERE `imei` = '868922055680850' [ RunTime:0.000849s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011221s ] [ 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' , 1686932358 , 0.021401 , 0.012517 , 0.018662 , -0.006351 , 12.24 , 25.909063 , 78.999084 , 26 , '898604650119C1078510' , '460048590708510' , -0 , '120.185118,35.986739' , 1686932359) [ RunTime:0.001221s ] --------------------------------------------------------------- [ 2023-06-17T02:03:54+08:00 ] 39.144.3.161 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002740s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013455s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000720s ] --------------------------------------------------------------- [ 2023-06-17T02:03:55+08:00 ] 117.132.194.40 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001636s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011381s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000651s ] --------------------------------------------------------------- [ 2023-06-17T02:04:02+08:00 ] 39.144.3.161 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230617&time=020301&v1=-01.382&v2=+00.014&v3=-00.957&v4=-00.047&v5=06.2&t=+21.5&h=59.3&rssi=+227&ccid=4600485905031420000099m9990000000429000001g3900,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002063s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010073s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000688s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230617',`time`='020301',`v1`=-1.382,`v2`=0.014,`v3`=-0.957,`v4`=-0.047,`v5`=6.2,`t`=21.5,`h`=59.3,`rssi`=227,`ccid`='4600485905031420000099m9990000000429000001g3900,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686938642 WHERE `imei` = '868922055643643' [ RunTime:0.000604s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011218s ] [ 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' , '230617' , '020301' , -1.382 , 0.014 , -0.957 , -0.047 , 6.2 , 21.5 , 59.3 , 227 , '4600485905031420000099m9990000000429000001g3900,N,00E000=-00.000' , 0 , 0 , 1686938642 , 1686938642) [ RunTime:0.000884s ] --------------------------------------------------------------- [ 2023-06-17T02:04:03+08:00 ] 117.132.194.40 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230617&time=020301&v1=-00.479&v2=+00.001&v3=-00.189&v4=+00.000&v5=06.0&t=+21.5&h=62.7&rssi=+223&ccid=4600485905031430000099m9990000000044000000g4950,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001694s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010435s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000688s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230617',`time`='020301',`v1`=-0.479,`v2`=0.001,`v3`=-0.189,`v4`=0,`v5`=6,`t`=21.5,`h`=62.7,`rssi`=223,`ccid`='4600485905031430000099m9990000000044000000g4950,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686938643 WHERE `imei` = '868922055644013' [ RunTime:0.000511s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010089s ] [ 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' , '230617' , '020301' , -0.479 , 0.001 , -0.189 , 0 , 6 , 21.5 , 62.7 , 223 , '4600485905031430000099m9990000000044000000g4950,N,00E000=-00.000' , 0 , 0 , 1686938643 , 1686938643) [ RunTime:0.000535s ] --------------------------------------------------------------- [ 2023-06-17T11:37:29+08:00 ] 111.55.136.103 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002940s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012908s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001298s ] --------------------------------------------------------------- [ 2023-06-17T11:37:36+08:00 ] 111.55.136.103 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1686973049&v1=0.030492&v2=0.013769&v3=0.026518&v4=0.001355&v5=12.240000&t=25.211931&h=79.350037&rssi=10&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001678s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010747s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000659s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1686973049,`v1`=0.030492,`v2`=0.013769,`v3`=0.026518,`v4`=0.001355,`v5`=12.24,`t`=25.211931,`h`=79.350037,`rssi`=10,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1686973056 WHERE `imei` = '868922055678110' [ RunTime:0.000762s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010738s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1686973049 , 0.030492 , 0.013769 , 0.026518 , 0.001355 , 12.24 , 25.211931 , 79.350037 , 10 , '898604650119C1078513' , '460048590708513' , -0 , 1686973056) [ RunTime:0.001543s ] --------------------------------------------------------------- [ 2023-06-17T14:03:54+08:00 ] 39.144.15.147 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003129s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012164s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.002671s ] --------------------------------------------------------------- [ 2023-06-17T14:03:54+08:00 ] 111.55.141.247 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ 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.011263s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000785s ] --------------------------------------------------------------- [ 2023-06-17T14:04:02+08:00 ] 39.144.15.147 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230617&time=140301&v1=-01.382&v2=+00.025&v3=-01.003&v4=-00.046&v5=06.4&t=+31.1&h=55.9&rssi=+227&ccid=4600485905031420000099m9990000000380000001g3890,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001633s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011681s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000780s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230617',`time`='140301',`v1`=-1.382,`v2`=0.025,`v3`=-1.003,`v4`=-0.046,`v5`=6.4,`t`=31.1,`h`=55.9,`rssi`=227,`ccid`='4600485905031420000099m9990000000380000001g3890,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686981842 WHERE `imei` = '868922055643643' [ RunTime:0.000783s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012607s ] [ 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' , '230617' , '140301' , -1.382 , 0.025 , -1.003 , -0.046 , 6.4 , 31.1 , 55.9 , 227 , '4600485905031420000099m9990000000380000001g3890,N,00E000=-00.000' , 0 , 0 , 1686981842 , 1686981842) [ RunTime:0.003891s ] --------------------------------------------------------------- [ 2023-06-17T14:04:03+08:00 ] 111.55.141.247 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230617&time=140301&v1=-00.547&v2=+00.001&v3=+00.001&v4=+00.000&v5=06.0&t=+28.2&h=60.2&rssi=+223&ccid=4600485905031430000099m9990000000044000000g5730,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001711s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010226s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000666s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230617',`time`='140301',`v1`=-0.547,`v2`=0.001,`v3`=0.001,`v4`=0,`v5`=6,`t`=28.2,`h`=60.2,`rssi`=223,`ccid`='4600485905031430000099m9990000000044000000g5730,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686981843 WHERE `imei` = '868922055644013' [ RunTime:0.000529s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010672s ] [ 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' , '230617' , '140301' , -0.547 , 0.001 , 0.001 , 0 , 6 , 28.2 , 60.2 , 223 , '4600485905031430000099m9990000000044000000g5730,N,00E000=-00.000' , 0 , 0 , 1686981843 , 1686981843) [ RunTime:0.001113s ] --------------------------------------------------------------- [ 2023-06-17T15:04:22+08:00 ] 218.204.252.70 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.003130s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013260s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000774s ] --------------------------------------------------------------- [ 2023-06-17T15:04:23+08:00 ] 218.204.252.70 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1686985462&v1=0.016766&v2=0.015438&v3=0.014719&v4=-0.011649&v5=12.240000&t=25.737461&h=78.121704&rssi=29&ccid=898604650119C1053137&imsi=460048590503137&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.010940s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000728s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1686985462,`v1`=0.016766,`v2`=0.015438,`v3`=0.014719,`v4`=-0.011649,`v5`=12.24,`t`=25.737461,`h`=78.121704,`rssi`=29,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1686985463 WHERE `imei` = '868922055684548' [ RunTime:0.000637s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012507s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1686985462 , 0.016766 , 0.015438 , 0.014719 , -0.011649 , 12.24 , 25.737461 , 78.121704 , 29 , '898604650119C1053137' , '460048590503137' , -0 , 1686985463) [ RunTime:0.001256s ] --------------------------------------------------------------- [ 2023-06-17T17:16:24+08:00 ] 39.144.17.26 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002690s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015385s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000774s ] --------------------------------------------------------------- [ 2023-06-17T17:16:26+08:00 ] 39.144.17.26 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1686993384&v1=0.018271&v2=0.014186&v3=0.015140&v4=-0.000090&v5=12.420000&t=25.469334&h=79.510254&rssi=26&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001842s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010979s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000727s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1686993384,`v1`=0.018271,`v2`=0.014186,`v3`=0.01514,`v4`=-9.0E-5,`v5`=12.42,`t`=25.469334,`h`=79.510254,`rssi`=26,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1686993386 WHERE `imei` = '868922055647586' [ RunTime:0.000769s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012770s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1686993384 , 0.018271 , 0.014186 , 0.01514 , -9.0E-5 , 12.42 , 25.469334 , 79.510254 , 26 , '898604650119C1078512' , '460048590708512' , -0 , 1686993386) [ RunTime:0.001281s ] --------------------------------------------------------------- [ 2023-06-17T17:56:23+08:00 ] 39.144.18.55 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002458s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012811s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000709s ] --------------------------------------------------------------- [ 2023-06-17T17:56:25+08:00 ] 39.144.18.55 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1686995783&v1=0.027301&v2=0.012621&v3=0.028204&v4=0.015622&v5=12.240000&t=25.533684&h=77.450317&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001698s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010720s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000734s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1686995783,`v1`=0.027301,`v2`=0.012621,`v3`=0.028204,`v4`=0.015622,`v5`=12.24,`t`=25.533684,`h`=77.450317,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1686995785 WHERE `imei` = '868922056976208' [ RunTime:0.000691s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012003s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1686995783 , 0.027301 , 0.012621 , 0.028204 , 0.015622 , 12.24 , 25.533684 , 77.450317 , 27 , '898604650119C1053139' , '460048590503139' , -0 , 1686995785) [ RunTime:0.001342s ] --------------------------------------------------------------- [ 2023-06-17T18:04:21+08:00 ] 117.132.191.169 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002392s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010662s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000990s ] --------------------------------------------------------------- [ 2023-06-17T18:04:23+08:00 ] 117.132.191.169 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1686996261&v1=0.020860&v2=0.012621&v3=0.016886&v4=-0.007013&v5=12.420000&t=25.469334&h=79.624695&rssi=26&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001838s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011077s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000720s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1686996261,`v1`=0.02086,`v2`=0.012621,`v3`=0.016886,`v4`=-0.007013,`v5`=12.42,`t`=25.469334,`h`=79.624695,`rssi`=26,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1686996263 WHERE `imei` = '868922055684209' [ RunTime:0.001576s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011417s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1686996261 , 0.02086 , 0.012621 , 0.016886 , -0.007013 , 12.42 , 25.469334 , 79.624695 , 26 , '898604650119C1078511' , '460048590708511' , -0 , 1686996263) [ RunTime:0.001456s ] --------------------------------------------------------------- [ 2023-06-17T18:29:20+08:00 ] 117.132.197.116 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002703s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012837s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000710s ] --------------------------------------------------------------- [ 2023-06-17T18:29:22+08:00 ] 117.132.197.116 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1686997760&v1=0.018993&v2=0.013769&v3=0.016495&v4=-0.004605&v5=12.420000&t=25.469334&h=83.683533&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002354s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010802s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000731s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1686997760,`v1`=0.018993,`v2`=0.013769,`v3`=0.016495,`v4`=-0.004605,`v5`=12.42,`t`=25.469334,`h`=83.683533,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1686997762 WHERE `imei` = '868922055683920' [ RunTime:0.000598s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012963s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1686997760 , 0.018993 , 0.013769 , 0.016495 , -0.004605 , 12.42 , 25.469334 , 83.683533 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1686997762) [ RunTime:0.000635s ] --------------------------------------------------------------- [ 2023-06-17T21:14:24+08:00 ] 117.132.194.247 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002383s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010673s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000777s ] --------------------------------------------------------------- [ 2023-06-17T21:14:26+08:00 ] 117.132.194.247 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1687007664&v1=0.030672&v2=0.014603&v3=0.029348&v4=0.008037&v5=12.420000&t=25.093956&h=82.241577&rssi=18&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.216067,36.008222&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001590s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009471s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000682s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1687007664,`v1`=0.030672,`v2`=0.014603,`v3`=0.029348,`v4`=0.008037,`v5`=12.42,`t`=25.093956,`h`=82.241577,`rssi`=18,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.216067,36.008222',`update_time`=1687007666 WHERE `imei` = '868922055683912' [ RunTime:0.000606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010010s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683912' , 1687007664 , 0.030672 , 0.014603 , 0.029348 , 0.008037 , 12.42 , 25.093956 , 82.241577 , 18 , '898604650119C1053138' , '460048590503138' , -0 , '120.216067,36.008222' , 1687007666) [ RunTime:0.001258s ] --------------------------------------------------------------- [ 2023-06-17T21:21:22+08:00 ] 111.55.141.249 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002498s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011409s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000693s ] --------------------------------------------------------------- [ 2023-06-17T21:21:23+08:00 ] 111.55.141.249 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1687008082&v1=0.019535&v2=0.014707&v3=0.016525&v4=-0.017127&v5=12.420000&t=25.040329&h=83.157104&rssi=28&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001591s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011900s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000659s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1687008082,`v1`=0.019535,`v2`=0.014707,`v3`=0.016525,`v4`=-0.017127,`v5`=12.42,`t`=25.040329,`h`=83.157104,`rssi`=28,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`update_time`=1687008083 WHERE `imei` = '868922055683771' [ RunTime:0.001344s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010719s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683771' , 1687008082 , 0.019535 , 0.014707 , 0.016525 , -0.017127 , 12.42 , 25.040329 , 83.157104 , 28 , '898604650119C1053136' , '460048590503136' , -0 , 1687008083) [ RunTime:0.000505s ] --------------------------------------------------------------- [ 2023-06-17T22:08:50+08:00 ] 39.144.7.53 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002377s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010766s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000736s ] --------------------------------------------------------------- [ 2023-06-17T22:08:58+08:00 ] 39.144.7.53 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230617&time=220801&v1=-01.182&v2=+00.019&v3=-01.052&v4=-00.237&v5=06.0&t=+21.6&h=77.6&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.163&a2=01.232&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001618s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010837s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000640s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230617',`time`='220801',`v1`=-1.182,`v2`=0.019,`v3`=-1.052,`v4`=-0.237,`v5`=6,`t`=21.6,`h`=77.6,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.163,`a2`=1.232,`update_time`=1687010938 WHERE `imei` = '868922055684076' [ RunTime:0.000609s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010930s ] [ 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' , '230617' , '220801' , -1.182 , 0.019 , -1.052 , -0.237 , 6 , 21.6 , 77.6 , 228 , '460044618415249' , -0 , 0.163 , 1.232 , 1687010938 , 1687010938) [ RunTime:0.000685s ] --------------------------------------------------------------- [ 2023-06-17T23:59:23+08:00 ] 111.55.140.135 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ 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.013112s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000806s ] --------------------------------------------------------------- [ 2023-06-17T23:59:25+08:00 ] 111.55.140.135 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1687017563&v1=0.007916&v2=0.014603&v3=0.005328&v4=-0.015923&v5=12.420000&t=24.943804&h=81.158203&rssi=11&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001715s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010687s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1687017563,`v1`=0.007916,`v2`=0.014603,`v3`=0.005328,`v4`=-0.015923,`v5`=12.42,`t`=24.943804,`h`=81.158203,`rssi`=11,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1687017565 WHERE `imei` = '868922055644021' [ RunTime:0.000688s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011189s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1687017563 , 0.007916 , 0.014603 , 0.005328 , -0.015923 , 12.42 , 24.943804 , 81.158203 , 11 , '898604650119C1053141' , '460048590503141' , -0 , 1687017565) [ RunTime:0.001308s ]