--------------------------------------------------------------- [ 2023-02-07T02:03:56+08:00 ] 39.144.10.48 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002297s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014077s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000718s ] --------------------------------------------------------------- [ 2023-02-07T02:03:57+08:00 ] 117.132.197.108 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.010618s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010112s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000764s ] --------------------------------------------------------------- [ 2023-02-07T02:04:04+08:00 ] 39.144.10.48 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230207&time=020301&v1=-01.236&v2=+00.030&v3=-00.953&v4=-00.031&v5=06.0&t=-00.5&h=61.9&rssi=+229&ccid=4600485905031420000099m9990000000259000001g2510,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002149s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010017s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000734s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230207',`time`='020301',`v1`=-1.236,`v2`=0.03,`v3`=-0.953,`v4`=-0.031,`v5`=6,`t`=-0.5,`h`=61.9,`rssi`=229,`ccid`='4600485905031420000099m9990000000259000001g2510,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675706644 WHERE `imei` = '868922055643643' [ RunTime:0.000780s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012927s ] [ 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' , '230207' , '020301' , -1.236 , 0.03 , -0.953 , -0.031 , 6 , -0.5 , 61.9 , 229 , '4600485905031420000099m9990000000259000001g2510,N,00E000=-00.000' , 0 , 0 , 1675706644 , 1675706644) [ RunTime:0.000821s ] --------------------------------------------------------------- [ 2023-02-07T02:04:05+08:00 ] 117.132.197.108 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230207&time=020301&v1=-00.289&v2=+00.001&v3=-00.052&v4=-00.014&v5=05.7&t=+00.0&h=65.0&rssi=+225&ccid=4600485905031430000099m9990000000039000000g3350,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001620s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011408s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000699s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230207',`time`='020301',`v1`=-0.289,`v2`=0.001,`v3`=-0.052,`v4`=-0.014,`v5`=5.7,`t`=0,`h`=65,`rssi`=225,`ccid`='4600485905031430000099m9990000000039000000g3350,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675706645 WHERE `imei` = '868922055644013' [ RunTime:0.000521s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011331s ] [ 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' , '230207' , '020301' , -0.289 , 0.001 , -0.052 , -0.014 , 5.7 , 0 , 65 , 225 , '4600485905031430000099m9990000000039000000g3350,N,00E000=-00.000' , 0 , 0 , 1675706645 , 1675706645) [ RunTime:0.000592s ] --------------------------------------------------------------- [ 2023-02-07T06:12:51+08:00 ] 221.178.127.123 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002735s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010107s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000704s ] --------------------------------------------------------------- [ 2023-02-07T06:13:00+08:00 ] 221.178.127.123 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230207&time=061201&v1=-01.262&v2=+00.021&v3=-01.032&v4=-00.621&v5=05.7&t=-00.1&h=80.7&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.256&a2=01.276&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002068s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011032s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000699s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230207',`time`='061201',`v1`=-1.262,`v2`=0.021,`v3`=-1.032,`v4`=-0.621,`v5`=5.7,`t`=-0.1,`h`=80.7,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.256,`a2`=1.276,`update_time`=1675721580 WHERE `imei` = '868922055684076' [ RunTime:0.000614s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012361s ] [ 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' , '230207' , '061201' , -1.262 , 0.021 , -1.032 , -0.621 , 5.7 , -0.1 , 80.7 , 228 , '460044618415249' , -0 , 0.256 , 1.276 , 1675721580 , 1675721580) [ RunTime:0.000640s ] --------------------------------------------------------------- [ 2023-02-07T14:03:54+08:00 ] 223.104.255.153 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002273s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012929s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000706s ] --------------------------------------------------------------- [ 2023-02-07T14:03:55+08:00 ] 221.178.127.127 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002018s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011175s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000917s ] --------------------------------------------------------------- [ 2023-02-07T14:04:02+08:00 ] 223.104.255.153 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230207&time=140301&v1=-00.291&v2=+00.001&v3=+00.014&v4=-00.015&v5=05.9&t=+08.8&h=64.0&rssi=+226&ccid=4600485905031430000099m9990000000037000000g3480,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001988s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010169s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000743s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230207',`time`='140301',`v1`=-0.291,`v2`=0.001,`v3`=0.014,`v4`=-0.015,`v5`=5.9,`t`=8.8,`h`=64,`rssi`=226,`ccid`='4600485905031430000099m9990000000037000000g3480,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675749842 WHERE `imei` = '868922055644013' [ RunTime:0.000662s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010206s ] [ 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' , '230207' , '140301' , -0.291 , 0.001 , 0.014 , -0.015 , 5.9 , 8.8 , 64 , 226 , '4600485905031430000099m9990000000037000000g3480,N,00E000=-00.000' , 0 , 0 , 1675749842 , 1675749842) [ RunTime:0.000811s ] --------------------------------------------------------------- [ 2023-02-07T14:04:03+08:00 ] 221.178.127.127 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230207&time=140301&v1=-01.237&v2=+00.078&v3=-00.928&v4=-00.030&v5=05.7&t=+07.9&h=61.1&rssi=+230&ccid=4600485905031420000099m9990000000280000001g2510,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001702s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009316s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000711s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230207',`time`='140301',`v1`=-1.237,`v2`=0.078,`v3`=-0.928,`v4`=-0.03,`v5`=5.7,`t`=7.9,`h`=61.1,`rssi`=230,`ccid`='4600485905031420000099m9990000000280000001g2510,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675749843 WHERE `imei` = '868922055643643' [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012994s ] [ 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' , '230207' , '140301' , -1.237 , 0.078 , -0.928 , -0.03 , 5.7 , 7.9 , 61.1 , 230 , '4600485905031420000099m9990000000280000001g2510,N,00E000=-00.000' , 0 , 0 , 1675749843 , 1675749843) [ RunTime:0.000599s ]