--------------------------------------------------------------- [ 2023-03-10T02:03:52+08:00 ] 39.144.15.194 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003651s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015284s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001403s ] --------------------------------------------------------------- [ 2023-03-10T02:03:55+08:00 ] 111.55.137.10 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ 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.011266s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000768s ] --------------------------------------------------------------- [ 2023-03-10T02:04:01+08:00 ] 39.144.15.194 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230310&time=020301&v1=-01.303&v2=+00.021&v3=-00.977&v4=-00.020&v5=05.9&t=+07.1&h=63.3&rssi=+229&ccid=4600485905031420000099m9990000000323000001g3140,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001724s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010060s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000683s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230310',`time`='020301',`v1`=-1.303,`v2`=0.021,`v3`=-0.977,`v4`=-0.02,`v5`=5.9,`t`=7.1,`h`=63.3,`rssi`=229,`ccid`='4600485905031420000099m9990000000323000001g3140,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678385041 WHERE `imei` = '868922055643643' [ RunTime:0.000750s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014427s ] [ 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' , '230310' , '020301' , -1.303 , 0.021 , -0.977 , -0.02 , 5.9 , 7.1 , 63.3 , 229 , '4600485905031420000099m9990000000323000001g3140,N,00E000=-00.000' , 0 , 0 , 1678385041 , 1678385041) [ RunTime:0.001287s ] --------------------------------------------------------------- [ 2023-03-10T02:04:04+08:00 ] 111.55.137.10 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230310&time=020301&v1=-00.251&v2=+00.001&v3=-00.064&v4=-00.017&v5=05.9&t=+08.6&h=66.0&rssi=+225&ccid=4600485905031430000099m9990000000035000000g2800,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001658s ] 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` = '868922055644013' LIMIT 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230310',`time`='020301',`v1`=-0.251,`v2`=0.001,`v3`=-0.064,`v4`=-0.017,`v5`=5.9,`t`=8.6,`h`=66,`rssi`=225,`ccid`='4600485905031430000099m9990000000035000000g2800,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678385044 WHERE `imei` = '868922055644013' [ RunTime:0.000519s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008782s ] [ 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' , '230310' , '020301' , -0.251 , 0.001 , -0.064 , -0.017 , 5.9 , 8.6 , 66 , 225 , '4600485905031430000099m9990000000035000000g2800,N,00E000=-00.000' , 0 , 0 , 1678385044 , 1678385044) [ RunTime:0.000510s ] --------------------------------------------------------------- [ 2023-03-10T06:07:51+08:00 ] 39.144.7.212 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002385s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012863s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000764s ] --------------------------------------------------------------- [ 2023-03-10T06:07:59+08:00 ] 39.144.7.212 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230310&time=060701&v1=-01.268&v2=+00.019&v3=-01.090&v4=-00.657&v5=05.9&t=+06.7&h=82.0&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.207&a2=01.283&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.009910s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230310',`time`='060701',`v1`=-1.268,`v2`=0.019,`v3`=-1.09,`v4`=-0.657,`v5`=5.9,`t`=6.7,`h`=82,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.207,`a2`=1.283,`update_time`=1678399679 WHERE `imei` = '868922055684076' [ RunTime:0.000594s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011261s ] [ 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' , '230310' , '060701' , -1.268 , 0.019 , -1.09 , -0.657 , 5.9 , 6.7 , 82 , 227 , '460044618415249' , -0 , 0.207 , 1.283 , 1678399679 , 1678399679) [ RunTime:0.000617s ] --------------------------------------------------------------- [ 2023-03-10T08:51:28+08:00 ] 223.80.202.168 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002144s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012762s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.001168s ] --------------------------------------------------------------- [ 2023-03-10T08:51:29+08:00 ] 223.80.202.168 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001729s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010915s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000778s ] --------------------------------------------------------------- [ 2023-03-10T14:03:55+08:00 ] 39.144.7.227 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002254s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011778s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000687s ] --------------------------------------------------------------- [ 2023-03-10T14:03:55+08:00 ] 39.144.3.108 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002163s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010724s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2023-03-10T14:04:03+08:00 ] 39.144.7.227 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230310&time=140301&v1=-00.251&v2=+00.001&v3=+00.019&v4=-00.016&v5=06.0&t=+32.3&h=62.7&rssi=+224&ccid=4600485905031430000099m9990000000044000000g2920,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001727s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011761s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230310',`time`='140301',`v1`=-0.251,`v2`=0.001,`v3`=0.019,`v4`=-0.016,`v5`=6,`t`=32.3,`h`=62.7,`rssi`=224,`ccid`='4600485905031430000099m9990000000044000000g2920,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678428243 WHERE `imei` = '868922055644013' [ RunTime:0.000835s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015822s ] [ 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' , '230310' , '140301' , -0.251 , 0.001 , 0.019 , -0.016 , 6 , 32.3 , 62.7 , 224 , '4600485905031430000099m9990000000044000000g2920,N,00E000=-00.000' , 0 , 0 , 1678428243 , 1678428243) [ RunTime:0.001488s ] --------------------------------------------------------------- [ 2023-03-10T14:04:04+08:00 ] 39.144.3.108 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230310&time=140301&v1=-01.313&v2=+00.045&v3=-00.974&v4=-00.018&v5=06.2&t=+27.6&h=58.9&rssi=+229&ccid=4600485905031420000099m9990000000331000001g3220,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002456s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011017s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000679s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230310',`time`='140301',`v1`=-1.313,`v2`=0.045,`v3`=-0.974,`v4`=-0.018,`v5`=6.2,`t`=27.6,`h`=58.9,`rssi`=229,`ccid`='4600485905031420000099m9990000000331000001g3220,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678428244 WHERE `imei` = '868922055643643' [ RunTime:0.000546s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010636s ] [ 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' , '230310' , '140301' , -1.313 , 0.045 , -0.974 , -0.018 , 6.2 , 27.6 , 58.9 , 229 , '4600485905031420000099m9990000000331000001g3220,N,00E000=-00.000' , 0 , 0 , 1678428244 , 1678428244) [ RunTime:0.000520s ] --------------------------------------------------------------- [ 2023-03-10T15:43:08+08:00 ] 223.80.202.168 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002318s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011279s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000649s ] --------------------------------------------------------------- [ 2023-03-10T15:43:09+08:00 ] 223.80.202.168 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001959s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011088s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000906s ]