--------------------------------------------------------------- [ 2023-06-23T00:04:23+08:00 ] 39.144.2.10 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002777s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011512s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000726s ] --------------------------------------------------------------- [ 2023-06-23T00:04:24+08:00 ] 39.144.2.10 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1687449863&v1=0.008157&v2=0.013560&v3=0.005569&v4=-0.015803&v5=12.420000&t=28.332935&h=80.921692&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002174s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010310s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1687449863,`v1`=0.008157,`v2`=0.01356,`v3`=0.005569,`v4`=-0.015803,`v5`=12.42,`t`=28.332935,`h`=80.921692,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1687449864 WHERE `imei` = '868922055644021' [ RunTime:0.000637s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010729s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1687449863 , 0.008157 , 0.01356 , 0.005569 , -0.015803 , 12.42 , 28.332935 , 80.921692 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1687449864) [ RunTime:0.000595s ] --------------------------------------------------------------- [ 2023-06-23T00:23:59+08:00 ] 39.144.12.141 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002979s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012025s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000788s ] --------------------------------------------------------------- [ 2023-06-23T00:24:00+08:00 ] 39.144.12.141 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1687451039&v1=0.021462&v2=0.013664&v3=0.018843&v4=-0.006291&v5=12.240000&t=28.247133&h=78.571838&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&gps=120.185695,35.986629&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001941s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010393s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000677s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1687451039,`v1`=0.021462,`v2`=0.013664,`v3`=0.018843,`v4`=-0.006291,`v5`=12.24,`t`=28.247133,`h`=78.571838,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`gps`='120.185695,35.986629',`update_time`=1687451040 WHERE `imei` = '868922055680850' [ RunTime:0.000626s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013553s ] [ 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' , 1687451039 , 0.021462 , 0.013664 , 0.018843 , -0.006291 , 12.24 , 28.247133 , 78.571838 , 25 , '898604650119C1078510' , '460048590708510' , -0 , '120.185695,35.986629' , 1687451040) [ RunTime:0.000773s ] --------------------------------------------------------------- [ 2023-06-23T02:03:54+08:00 ] 111.55.139.56 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002040s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012061s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000667s ] --------------------------------------------------------------- [ 2023-06-23T02:03:55+08:00 ] 39.144.14.97 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001683s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009952s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000679s ] --------------------------------------------------------------- [ 2023-06-23T02:04:02+08:00 ] 111.55.139.56 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230623&time=020301&v1=-01.378&v2=+00.011&v3=-00.909&v4=-00.045&v5=06.4&t=+24.5&h=59.9&rssi=+227&ccid=4600485905031420000099m9990000000479000001g3860,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001493s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011037s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000689s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230623',`time`='020301',`v1`=-1.378,`v2`=0.011,`v3`=-0.909,`v4`=-0.045,`v5`=6.4,`t`=24.5,`h`=59.9,`rssi`=227,`ccid`='4600485905031420000099m9990000000479000001g3860,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687457042 WHERE `imei` = '868922055643643' [ RunTime:0.000653s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011145s ] [ 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' , '230623' , '020301' , -1.378 , 0.011 , -0.909 , -0.045 , 6.4 , 24.5 , 59.9 , 227 , '4600485905031420000099m9990000000479000001g3860,N,00E000=-00.000' , 0 , 0 , 1687457042 , 1687457042) [ RunTime:0.000711s ] --------------------------------------------------------------- [ 2023-06-23T02:04:03+08:00 ] 39.144.14.97 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230623&time=020301&v1=-00.418&v2=+00.001&v3=-00.014&v4=+00.000&v5=06.0&t=+25.1&h=63.2&rssi=+222&ccid=4600485905031430000099m9990000000040000000g4400,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002964s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011559s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000763s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230623',`time`='020301',`v1`=-0.418,`v2`=0.001,`v3`=-0.014,`v4`=0,`v5`=6,`t`=25.1,`h`=63.2,`rssi`=222,`ccid`='4600485905031430000099m9990000000040000000g4400,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687457043 WHERE `imei` = '868922055644013' [ RunTime:0.000619s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012163s ] [ 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' , '230623' , '020301' , -0.418 , 0.001 , -0.014 , 0 , 6 , 25.1 , 63.2 , 222 , '4600485905031430000099m9990000000040000000g4400,N,00E000=-00.000' , 0 , 0 , 1687457043 , 1687457043) [ RunTime:0.000550s ] --------------------------------------------------------------- [ 2023-06-23T11:43:27+08:00 ] 39.144.7.105 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.003386s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013155s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001342s ] --------------------------------------------------------------- [ 2023-06-23T11:43:28+08:00 ] 39.144.7.105 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1687491807&v1=0.030552&v2=0.014603&v3=0.026609&v4=0.001355&v5=12.240000&t=28.300758&h=79.098267&rssi=30&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001817s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010882s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000689s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1687491807,`v1`=0.030552,`v2`=0.014603,`v3`=0.026609,`v4`=0.001355,`v5`=12.24,`t`=28.300758,`h`=79.098267,`rssi`=30,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1687491808 WHERE `imei` = '868922055678110' [ RunTime:0.001027s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012481s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1687491807 , 0.030552 , 0.014603 , 0.026609 , 0.001355 , 12.24 , 28.300758 , 79.098267 , 30 , '898604650119C1078513' , '460048590708513' , -0 , 1687491808) [ RunTime:0.001134s ] --------------------------------------------------------------- [ 2023-06-23T14:03:54+08:00 ] 39.144.8.42 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002811s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012148s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001303s ] --------------------------------------------------------------- [ 2023-06-23T14:03:55+08:00 ] 39.144.16.198 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001905s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011826s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000731s ] --------------------------------------------------------------- [ 2023-06-23T14:04:02+08:00 ] 39.144.8.42 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230623&time=140301&v1=-01.377&v2=+00.019&v3=-00.924&v4=-00.045&v5=06.4&t=+46.2&h=51.9&rssi=+227&ccid=4600485905031420000099m9990000000461000001g3830,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001976s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010902s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000788s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230623',`time`='140301',`v1`=-1.377,`v2`=0.019,`v3`=-0.924,`v4`=-0.045,`v5`=6.4,`t`=46.2,`h`=51.9,`rssi`=227,`ccid`='4600485905031420000099m9990000000461000001g3830,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687500242 WHERE `imei` = '868922055643643' [ RunTime:0.000652s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011244s ] [ 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' , '230623' , '140301' , -1.377 , 0.019 , -0.924 , -0.045 , 6.4 , 46.2 , 51.9 , 227 , '4600485905031420000099m9990000000461000001g3830,N,00E000=-00.000' , 0 , 0 , 1687500242 , 1687500242) [ RunTime:0.000640s ] --------------------------------------------------------------- [ 2023-06-23T14:04:03+08:00 ] 39.144.16.198 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230623&time=140301&v1=-00.463&v2=+00.001&v3=+00.020&v4=+00.003&v5=06.2&t=+45.6&h=56.6&rssi=+223&ccid=4600485905031430000099m9990000000054000000g4920,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001798s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012076s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000764s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230623',`time`='140301',`v1`=-0.463,`v2`=0.001,`v3`=0.02,`v4`=0.003,`v5`=6.2,`t`=45.6,`h`=56.6,`rssi`=223,`ccid`='4600485905031430000099m9990000000054000000g4920,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687500243 WHERE `imei` = '868922055644013' [ RunTime:0.000656s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011153s ] [ 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' , '230623' , '140301' , -0.463 , 0.001 , 0.02 , 0.003 , 6.2 , 45.6 , 56.6 , 223 , '4600485905031430000099m9990000000054000000g4920,N,00E000=-00.000' , 0 , 0 , 1687500243 , 1687500243) [ RunTime:0.000542s ] --------------------------------------------------------------- [ 2023-06-23T15:10:24+08:00 ] 39.144.5.140 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002451s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012351s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000691s ] --------------------------------------------------------------- [ 2023-06-23T15:10:25+08:00 ] 39.144.5.140 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1687504224&v1=0.017187&v2=0.016481&v3=0.015321&v4=-0.011709&v5=12.420000&t=29.652122&h=77.709717&rssi=27&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001790s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010372s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000659s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1687504224,`v1`=0.017187,`v2`=0.016481,`v3`=0.015321,`v4`=-0.011709,`v5`=12.42,`t`=29.652122,`h`=77.709717,`rssi`=27,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1687504225 WHERE `imei` = '868922055684548' [ RunTime:0.000618s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012791s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1687504224 , 0.017187 , 0.016481 , 0.015321 , -0.011709 , 12.42 , 29.652122 , 77.709717 , 27 , '898604650119C1053137' , '460048590503137' , -0 , 1687504225) [ RunTime:0.000600s ] --------------------------------------------------------------- [ 2023-06-23T16:34:55+08:00 ] 220.180.56.53 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002254s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.014425s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001656s ] --------------------------------------------------------------- [ 2023-06-23T16:34:56+08:00 ] 220.180.56.53 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001355s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010604s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000500s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001207s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000583s ] --------------------------------------------------------------- [ 2023-06-23T16:35:01+08:00 ] 220.180.56.53 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001665s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009805s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000542s ] --------------------------------------------------------------- [ 2023-06-23T17:05:02+08:00 ] 220.180.56.53 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002408s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010678s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000667s ] --------------------------------------------------------------- [ 2023-06-23T17:21:04+08:00 ] 111.55.140.230 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002530s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012700s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000773s ] --------------------------------------------------------------- [ 2023-06-23T17:21:05+08:00 ] 111.55.140.230 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1687512064&v1=0.018391&v2=0.013143&v3=0.016555&v4=-0.000030&v5=12.240000&t=30.231277&h=78.411621&rssi=26&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.184811,35.984969&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001980s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012287s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000673s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1687512064,`v1`=0.018391,`v2`=0.013143,`v3`=0.016555,`v4`=-3.0E-5,`v5`=12.24,`t`=30.231277,`h`=78.411621,`rssi`=26,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.184811,35.984969',`update_time`=1687512065 WHERE `imei` = '868922055647586' [ RunTime:0.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012027s ] [ 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' , 1687512064 , 0.018391 , 0.013143 , 0.016555 , -3.0E-5 , 12.24 , 30.231277 , 78.411621 , 26 , '898604650119C1078512' , '460048590708512' , -0 , '120.184811,35.984969' , 1687512065) [ RunTime:0.000680s ] --------------------------------------------------------------- [ 2023-06-23T18:02:02+08:00 ] 218.204.253.120 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002980s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011411s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000721s ] --------------------------------------------------------------- [ 2023-06-23T18:02:04+08:00 ] 218.204.253.120 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1687514522&v1=0.027421&v2=0.013351&v3=0.029408&v4=0.015502&v5=12.240000&t=29.920250&h=76.588196&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.183049,35.985042&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.011273s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000738s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1687514522,`v1`=0.027421,`v2`=0.013351,`v3`=0.029408,`v4`=0.015502,`v5`=12.24,`t`=29.92025,`h`=76.588196,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.183049,35.985042',`update_time`=1687514524 WHERE `imei` = '868922056976208' [ RunTime:0.000748s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011907s ] [ 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' , 1687514522 , 0.027421 , 0.013351 , 0.029408 , 0.015502 , 12.24 , 29.92025 , 76.588196 , 27 , '898604650119C1053139' , '460048590503139' , -0 , '120.183049,35.985042' , 1687514524) [ RunTime:0.000670s ] --------------------------------------------------------------- [ 2023-06-23T18:10:21+08:00 ] 117.132.195.191 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002335s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012200s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000679s ] --------------------------------------------------------------- [ 2023-06-23T18:10:22+08:00 ] 117.132.195.191 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1687515021&v1=0.021341&v2=0.013143&v3=0.018151&v4=-0.006773&v5=12.420000&t=30.038225&h=78.739685&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.013886s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009440s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1687515021,`v1`=0.021341,`v2`=0.013143,`v3`=0.018151,`v4`=-0.006773,`v5`=12.42,`t`=30.038225,`h`=78.739685,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1687515022 WHERE `imei` = '868922055684209' [ RunTime:0.000559s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010512s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1687515021 , 0.021341 , 0.013143 , 0.018151 , -0.006773 , 12.42 , 30.038225 , 78.739685 , 27 , '898604650119C1078511' , '460048590708511' , -0 , 1687515022) [ RunTime:0.000511s ] --------------------------------------------------------------- [ 2023-06-23T18:35:21+08:00 ] 221.178.126.129 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002514s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012857s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000709s ] --------------------------------------------------------------- [ 2023-06-23T18:35:22+08:00 ] 221.178.126.129 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1687516521&v1=0.019415&v2=0.014499&v3=0.017609&v4=-0.004666&v5=12.420000&t=29.748648&h=83.538574&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002101s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010354s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000661s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1687516521,`v1`=0.019415,`v2`=0.014499,`v3`=0.017609,`v4`=-0.004666,`v5`=12.42,`t`=29.748648,`h`=83.538574,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1687516522 WHERE `imei` = '868922055683920' [ RunTime:0.000621s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011898s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1687516521 , 0.019415 , 0.014499 , 0.017609 , -0.004666 , 12.42 , 29.748648 , 83.538574 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1687516522) [ RunTime:0.000641s ] --------------------------------------------------------------- [ 2023-06-23T21:19:56+08:00 ] 39.144.18.62 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.015729s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012956s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000740s ] --------------------------------------------------------------- [ 2023-06-23T21:19:57+08:00 ] 39.144.18.62 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1687526396&v1=0.032298&v2=0.016376&v3=0.029197&v4=0.007856&v5=12.420000&t=29.459070&h=82.005066&rssi=19&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.184833,35.985124&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001858s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010602s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000710s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1687526396,`v1`=0.032298,`v2`=0.016376,`v3`=0.029197,`v4`=0.007856,`v5`=12.42,`t`=29.45907,`h`=82.005066,`rssi`=19,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.184833,35.985124',`update_time`=1687526397 WHERE `imei` = '868922055683912' [ RunTime:0.000639s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009931s ] [ 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' , 1687526396 , 0.032298 , 0.016376 , 0.029197 , 0.007856 , 12.42 , 29.45907 , 82.005066 , 19 , '898604650119C1053138' , '460048590503138' , -0 , '120.184833,35.985124' , 1687526397) [ RunTime:0.000616s ] --------------------------------------------------------------- [ 2023-06-23T21:25:58+08:00 ] 39.144.16.153 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002653s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010965s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000719s ] --------------------------------------------------------------- [ 2023-06-23T21:26:00+08:00 ] 39.144.16.153 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1687526758&v1=0.019836&v2=0.013143&v3=0.016435&v4=-0.017187&v5=12.420000&t=29.459070&h=82.966370&rssi=27&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.184891,35.985052&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002031s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010316s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000648s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1687526758,`v1`=0.019836,`v2`=0.013143,`v3`=0.016435,`v4`=-0.017187,`v5`=12.42,`t`=29.45907,`h`=82.96637,`rssi`=27,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.184891,35.985052',`update_time`=1687526760 WHERE `imei` = '868922055683771' [ RunTime:0.000536s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009457s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683771' , 1687526758 , 0.019836 , 0.013143 , 0.016435 , -0.017187 , 12.42 , 29.45907 , 82.96637 , 27 , '898604650119C1053136' , '460048590503136' , -0 , '120.184891,35.985052' , 1687526760) [ RunTime:0.000497s ] --------------------------------------------------------------- [ 2023-06-23T22:03:51+08:00 ] 39.144.17.58 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002369s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013204s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2023-06-23T22:03:59+08:00 ] 39.144.17.58 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230623&time=220301&v1=-00.717&v2=+00.018&v3=-00.604&v4=-00.044&v5=06.0&t=+25.4&h=79.9&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.160&a2=00.889&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001773s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010757s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000739s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230623',`time`='220301',`v1`=-0.717,`v2`=0.018,`v3`=-0.604,`v4`=-0.044,`v5`=6,`t`=25.4,`h`=79.9,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.16,`a2`=0.889,`update_time`=1687529039 WHERE `imei` = '868922055684076' [ RunTime:0.000608s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011706s ] [ 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' , '230623' , '220301' , -0.717 , 0.018 , -0.604 , -0.044 , 6 , 25.4 , 79.9 , 227 , '460044618415249' , -0 , 0.16 , 0.889 , 1687529039 , 1687529039) [ RunTime:0.000619s ]