---------------------------------------------------------------
[ 2023-03-31T02:03:55+08:00 ] 39.144.3.3 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.003175s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012315s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001443s ]
---------------------------------------------------------------
[ 2023-03-31T02:03:55+08:00 ] 117.132.195.79 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001784s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009209s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000799s ]
---------------------------------------------------------------
[ 2023-03-31T02:04:03+08:00 ] 39.144.3.3 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230331&time=020301&v1=-01.296&v2=+00.026&v3=-00.949&v4=-00.023&v5=05.7&t=+07.0&h=62.4&rssi=+229&ccid=4600485905031420000099m9990000000342000001g3080,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001610s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010128s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000712s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230331',`time`='020301',`v1`=-1.296,`v2`=0.026,`v3`=-0.949,`v4`=-0.023,`v5`=5.7,`t`=7,`h`=62.4,`rssi`=229,`ccid`='4600485905031420000099m9990000000342000001g3080,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680199443  WHERE  `imei` = '868922055643643' [ RunTime:0.000743s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012809s ]
[ 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' , '230331' , '020301' , -1.296 , 0.026 , -0.949 , -0.023 , 5.7 , 7 , 62.4 , 229 , '4600485905031420000099m9990000000342000001g3080,N,00E000=-00.000' , 0 , 0 , 1680199443 , 1680199443) [ RunTime:0.001251s ]
---------------------------------------------------------------
[ 2023-03-31T02:04:04+08:00 ] 117.132.195.79 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230331&time=020301&v1=-00.259&v2=+00.001&v3=+00.016&v4=-00.019&v5=05.9&t=+08.5&h=65.5&rssi=+225&ccid=4600485905031430000099m9990000000036000000g3040,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001999s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011108s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000743s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230331',`time`='020301',`v1`=-0.259,`v2`=0.001,`v3`=0.016,`v4`=-0.019,`v5`=5.9,`t`=8.5,`h`=65.5,`rssi`=225,`ccid`='4600485905031430000099m9990000000036000000g3040,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680199444  WHERE  `imei` = '868922055644013' [ RunTime:0.000602s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010525s ]
[ 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' , '230331' , '020301' , -0.259 , 0.001 , 0.016 , -0.019 , 5.9 , 8.5 , 65.5 , 225 , '4600485905031430000099m9990000000036000000g3040,N,00E000=-00.000' , 0 , 0 , 1680199444 , 1680199444) [ RunTime:0.000535s ]
---------------------------------------------------------------
[ 2023-03-31T10:14:50+08:00 ] 111.55.141.85 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.003209s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012335s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000734s ]
---------------------------------------------------------------
[ 2023-03-31T10:14:59+08:00 ] 111.55.141.85 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230331&time=101401&v1=-01.279&v2=+00.021&v3=-01.089&v4=-00.402&v5=06.0&t=+22.6&h=79.7&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.216&a2=01.293&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001676s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010125s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000676s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684076',`date`='230331',`time`='101401',`v1`=-1.279,`v2`=0.021,`v3`=-1.089,`v4`=-0.402,`v5`=6,`t`=22.6,`h`=79.7,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.216,`a2`=1.293,`update_time`=1680228899  WHERE  `imei` = '868922055684076' [ RunTime:0.000864s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012123s ]
[ 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' , '230331' , '101401' , -1.279 , 0.021 , -1.089 , -0.402 , 6 , 22.6 , 79.7 , 227 , '460044618415249' , -0 , 0.216 , 1.293 , 1680228899 , 1680228899) [ RunTime:0.000596s ]
---------------------------------------------------------------
[ 2023-03-31T14:03:55+08:00 ] 39.144.14.216 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002332s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011129s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000795s ]
---------------------------------------------------------------
[ 2023-03-31T14:03:55+08:00 ] 218.204.253.21 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001630s ] 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.000815s ]
---------------------------------------------------------------
[ 2023-03-31T14:04:03+08:00 ] 39.144.14.216 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230331&time=140301&v1=-01.295&v2=+00.043&v3=-00.948&v4=-00.023&v5=05.9&t=+22.7&h=59.0&rssi=+229&ccid=4600485905031420000099m9990000000338000001g3030,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001612s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010995s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000955s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230331',`time`='140301',`v1`=-1.295,`v2`=0.043,`v3`=-0.948,`v4`=-0.023,`v5`=5.9,`t`=22.7,`h`=59,`rssi`=229,`ccid`='4600485905031420000099m9990000000338000001g3030,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680242643  WHERE  `imei` = '868922055643643' [ RunTime:0.000634s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010971s ]
[ 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' , '230331' , '140301' , -1.295 , 0.043 , -0.948 , -0.023 , 5.9 , 22.7 , 59 , 229 , '4600485905031420000099m9990000000338000001g3030,N,00E000=-00.000' , 0 , 0 , 1680242643 , 1680242643) [ RunTime:0.000646s ]
---------------------------------------------------------------
[ 2023-03-31T14:04:03+08:00 ] 218.204.253.21 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230331&time=140301&v1=-00.249&v2=+00.001&v3=+00.020&v4=-00.017&v5=06.0&t=+26.3&h=63.9&rssi=+225&ccid=4600485905031430000099m9990000000040000000g2900,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001845s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009738s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000657s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230331',`time`='140301',`v1`=-0.249,`v2`=0.001,`v3`=0.02,`v4`=-0.017,`v5`=6,`t`=26.3,`h`=63.9,`rssi`=225,`ccid`='4600485905031430000099m9990000000040000000g2900,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680242643  WHERE  `imei` = '868922055644013' [ RunTime:0.000538s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009098s ]
[ 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' , '230331' , '140301' , -0.249 , 0.001 , 0.02 , -0.017 , 6 , 26.3 , 63.9 , 225 , '4600485905031430000099m9990000000040000000g2900,N,00E000=-00.000' , 0 , 0 , 1680242643 , 1680242643) [ RunTime:0.000536s ]
---------------------------------------------------------------
[ 2023-03-31T16:12:11+08:00 ] 27.193.135.0 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002196s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.013524s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000626s ]
---------------------------------------------------------------
[ 2023-03-31T16:15:09+08:00 ] 27.193.135.0 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002176s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011143s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000401s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000794s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000935s ]
---------------------------------------------------------------
[ 2023-03-31T16:15:17+08:00 ] 27.193.135.0 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001796s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009933s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000325s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000844s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000853s ]