--------------------------------------------------------------- [ 2021-12-20T00:27:58+08:00 ] 39.144.2.98 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003382s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029333s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000827s ] --------------------------------------------------------------- [ 2021-12-20T00:28:07+08:00 ] 39.144.2.98 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211220&time=002701&v1=-01.296&v2=+00.003&v3=-01.162&v4=-00.775&v5=06.0&t=+03.4&h=72.7&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.312&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003250s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029920s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000764s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211220',`time`='002701',`v1`=-1.296,`v2`=0.003,`v3`=-1.162,`v4`=-0.775,`v5`=6,`t`=3.4,`h`=72.7,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.312,`update_time`=1639931287 WHERE `imei` = '868922055684076' [ RunTime:0.000736s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020970s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211220' , '002701' , -1.296 , 0.003 , -1.162 , -0.775 , 6 , 3.4 , 72.7 , '460044618415249' , -0 , 0.159 , 1.312 , 1639931287 , 1639931287) [ RunTime:0.000863s ] --------------------------------------------------------------- [ 2021-12-20T02:27:58+08:00 ] 39.144.1.59 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.004402s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.086447s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.002321s ] --------------------------------------------------------------- [ 2021-12-20T02:28:06+08:00 ] 39.144.1.59 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211220&time=022701&v1=-01.296&v2=+00.004&v3=-01.162&v4=-00.775&v5=06.0&t=+03.2&h=72.8&rssi=+226&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.313&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003195s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.034405s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001358s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211220',`time`='022701',`v1`=-1.296,`v2`=0.004,`v3`=-1.162,`v4`=-0.775,`v5`=6,`t`=3.2,`h`=72.8,`rssi`=226,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.313,`update_time`=1639938486 WHERE `imei` = '868922055684076' [ RunTime:0.002100s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.029196s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211220' , '022701' , -1.296 , 0.004 , -1.162 , -0.775 , 6 , 3.2 , 72.8 , '460044618415249' , -0 , 0.159 , 1.313 , 1639938486 , 1639938486) [ RunTime:0.001759s ] --------------------------------------------------------------- [ 2021-12-20T03:04:56+08:00 ] 39.144.10.50 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003344s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030021s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000830s ] --------------------------------------------------------------- [ 2021-12-20T03:05:05+08:00 ] 39.144.10.50 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211220&time=030401&v1=-01.114&v2=+00.285&v3=-01.129&v4=+00.028&v5=06.0&t=+04.0&h=86.3&rssi=+225&imsi=460044618415257&v6=-00.000&a1=00.019&a2=01.126&a3=00.003&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002633s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024652s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000781s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211220',`time`='030401',`v1`=-1.114,`v2`=0.285,`v3`=-1.129,`v4`=0.028,`v5`=6,`t`=4,`h`=86.3,`rssi`=225,`imsi`='460044618415257',`v6`=-0,`a1`=0.019,`a2`=1.126,`update_time`=1639940705 WHERE `imei` = '868922055681221' [ RunTime:0.000739s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020680s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055681221' , '211220' , '030401' , -1.114 , 0.285 , -1.129 , 0.028 , 6 , 4 , 86.3 , '460044618415257' , -0 , 0.019 , 1.126 , 1639940705 , 1639940705) [ RunTime:0.000722s ] --------------------------------------------------------------- [ 2021-12-20T04:27:57+08:00 ] 39.144.15.111 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003185s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.036762s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000766s ] --------------------------------------------------------------- [ 2021-12-20T04:28:05+08:00 ] 39.144.15.111 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211220&time=042701&v1=-01.296&v2=+00.004&v3=-01.162&v4=-00.774&v5=06.0&t=+02.7&h=72.9&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.313&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002048s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022214s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000756s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211220',`time`='042701',`v1`=-1.296,`v2`=0.004,`v3`=-1.162,`v4`=-0.774,`v5`=6,`t`=2.7,`h`=72.9,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.313,`update_time`=1639945685 WHERE `imei` = '868922055684076' [ RunTime:0.000792s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020304s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211220' , '042701' , -1.296 , 0.004 , -1.162 , -0.774 , 6 , 2.7 , 72.9 , '460044618415249' , -0 , 0.159 , 1.313 , 1639945685 , 1639945685) [ RunTime:0.001009s ] --------------------------------------------------------------- [ 2021-12-20T06:27:57+08:00 ] 117.132.196.62 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.004453s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.038613s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000968s ] --------------------------------------------------------------- [ 2021-12-20T06:28:06+08:00 ] 117.132.196.62 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211220&time=062701&v1=-01.295&v2=+00.005&v3=-01.162&v4=-00.774&v5=06.0&t=+01.8&h=72.9&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.160&a2=01.312&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002106s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024938s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000740s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211220',`time`='062701',`v1`=-1.295,`v2`=0.005,`v3`=-1.162,`v4`=-0.774,`v5`=6,`t`=1.8,`h`=72.9,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.16,`a2`=1.312,`update_time`=1639952886 WHERE `imei` = '868922055684076' [ RunTime:0.000782s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018219s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211220' , '062701' , -1.295 , 0.005 , -1.162 , -0.774 , 6 , 1.8 , 72.9 , '460044618415249' , -0 , 0.16 , 1.312 , 1639952886 , 1639952886) [ RunTime:0.000798s ] --------------------------------------------------------------- [ 2021-12-20T08:03:45+08:00 ] 117.136.77.158 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003848s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.046346s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'xinghuo220kv' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000855s ] --------------------------------------------------------------- [ 2021-12-20T08:03:47+08:00 ] 117.136.77.158 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002870s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.037402s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.001381s ] --------------------------------------------------------------- [ 2021-12-20T08:11:00+08:00 ] 117.136.77.158 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003210s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029588s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000568s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000781s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000961s ] --------------------------------------------------------------- [ 2021-12-20T08:11:04+08:00 ] 117.136.77.158 GET /home/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003752s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032066s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.001232s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.022009s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001618s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.002129s ] --------------------------------------------------------------- [ 2021-12-20T08:11:11+08:00 ] 117.136.77.158 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002460s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032462s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000871s ] --------------------------------------------------------------- [ 2021-12-20T08:11:14+08:00 ] 117.136.77.158 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002098s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023922s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000546s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000739s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000609s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015638s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.000558s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.000628s ] --------------------------------------------------------------- [ 2021-12-20T08:11:30+08:00 ] 117.136.77.158 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002171s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024217s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000869s ] --------------------------------------------------------------- [ 2021-12-20T08:11:32+08:00 ] 117.136.77.158 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002597s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023869s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000613s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000873s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000806s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017565s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.000487s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.000465s ] --------------------------------------------------------------- [ 2021-12-20T08:11:52+08:00 ] 117.136.77.158 GET /home/data/index.html?keyword=868922055684076&start_date=2021-12-01&end_date=2021-12-20 [ sql ] [ DB ] CONNECT:[ UseTime:0.002153s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024836s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' AND `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000792s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000528s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000582s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000612s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017383s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1638288000 AND `update_time` <= 1639929600 ) LIMIT 1 [ RunTime:0.001184s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1638288000 AND `update_time` <= 1639929600 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.007603s ] --------------------------------------------------------------- [ 2021-12-20T08:18:28+08:00 ] 117.136.77.158 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003590s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031118s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000573s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000724s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000650s ] --------------------------------------------------------------- [ 2021-12-20T08:27:58+08:00 ] 39.144.14.196 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.004447s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.040090s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000846s ] --------------------------------------------------------------- [ 2021-12-20T08:28:06+08:00 ] 39.144.14.196 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211220&time=082701&v1=-01.296&v2=+00.004&v3=-01.161&v4=-00.773&v5=06.0&t=+05.3&h=72.0&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.160&a2=01.313&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001893s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023805s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000755s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211220',`time`='082701',`v1`=-1.296,`v2`=0.004,`v3`=-1.161,`v4`=-0.773,`v5`=6,`t`=5.3,`h`=72,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.16,`a2`=1.313,`update_time`=1639960086 WHERE `imei` = '868922055684076' [ RunTime:0.000713s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017608s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211220' , '082701' , -1.296 , 0.004 , -1.161 , -0.773 , 6 , 5.3 , 72 , '460044618415249' , -0 , 0.16 , 1.313 , 1639960086 , 1639960086) [ RunTime:0.000830s ] --------------------------------------------------------------- [ 2021-12-20T09:04:57+08:00 ] 39.144.16.55 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ 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.024733s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000721s ] --------------------------------------------------------------- [ 2021-12-20T09:05:05+08:00 ] 39.144.16.55 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211220&time=090401&v1=-01.213&v2=+00.557&v3=-01.225&v4=+00.029&v5=06.0&t=+08.3&h=85.5&rssi=+225&imsi=460044618415257&v6=-00.000&a1=00.020&a2=00.984&a3=00.007&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002100s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024707s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000739s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211220',`time`='090401',`v1`=-1.213,`v2`=0.557,`v3`=-1.225,`v4`=0.029,`v5`=6,`t`=8.3,`h`=85.5,`rssi`=225,`imsi`='460044618415257',`v6`=-0,`a1`=0.02,`a2`=0.984,`update_time`=1639962305 WHERE `imei` = '868922055681221' [ RunTime:0.000743s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016384s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055681221' , '211220' , '090401' , -1.213 , 0.557 , -1.225 , 0.029 , 6 , 8.3 , 85.5 , '460044618415257' , -0 , 0.02 , 0.984 , 1639962305 , 1639962305) [ RunTime:0.000707s ] --------------------------------------------------------------- [ 2021-12-20T10:27:57+08:00 ] 39.144.12.106 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003227s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032507s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000774s ] --------------------------------------------------------------- [ 2021-12-20T10:28:05+08:00 ] 39.144.12.106 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211220&time=102701&v1=-01.293&v2=+00.004&v3=-01.159&v4=-00.771&v5=06.0&t=+14.9&h=71.0&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.157&a2=01.310&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002089s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024477s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000770s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211220',`time`='102701',`v1`=-1.293,`v2`=0.004,`v3`=-1.159,`v4`=-0.771,`v5`=6,`t`=14.9,`h`=71,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.157,`a2`=1.31,`update_time`=1639967285 WHERE `imei` = '868922055684076' [ RunTime:0.000754s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017836s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211220' , '102701' , -1.293 , 0.004 , -1.159 , -0.771 , 6 , 14.9 , 71 , '460044618415249' , -0 , 0.157 , 1.31 , 1639967285 , 1639967285) [ RunTime:0.000691s ] --------------------------------------------------------------- [ 2021-12-20T12:27:57+08:00 ] 117.132.192.84 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003127s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028905s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000788s ] --------------------------------------------------------------- [ 2021-12-20T12:28:06+08:00 ] 117.132.192.84 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211220&time=122701&v1=-01.293&v2=+00.004&v3=-01.160&v4=-00.773&v5=06.0&t=+10.9&h=72.3&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.155&a2=01.309&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002004s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022376s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000742s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211220',`time`='122701',`v1`=-1.293,`v2`=0.004,`v3`=-1.16,`v4`=-0.773,`v5`=6,`t`=10.9,`h`=72.3,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.155,`a2`=1.309,`update_time`=1639974486 WHERE `imei` = '868922055684076' [ RunTime:0.000741s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016371s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211220' , '122701' , -1.293 , 0.004 , -1.16 , -0.773 , 6 , 10.9 , 72.3 , '460044618415249' , -0 , 0.155 , 1.309 , 1639974486 , 1639974486) [ RunTime:0.000745s ] --------------------------------------------------------------- [ 2021-12-20T13:18:01+08:00 ] 221.178.124.244 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ 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.034562s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001228s ] --------------------------------------------------------------- [ 2021-12-20T13:18:03+08:00 ] 221.178.124.244 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639977481&v1=0.008097&v2=4.062906&v3=0.007706&v4=0.007916&v5=5.220000&t=22.648518&h=43.636875&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002454s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021843s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000909s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639977481,`v1`=0.008097,`v2`=4.062906,`v3`=0.007706,`v4`=0.007916,`v5`=5.22,`t`=22.648518,`h`=43.636875,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639977483 WHERE `imei` = '868922055677740' [ RunTime:0.001153s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016715s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639977481 , 0.008097 , 4.062906 , 0.007706 , 0.007916 , 5.22 , 22.648518 , 43.636875 , '89860426102071188502' , '460044618415252' , -0 , 1639977483) [ RunTime:0.000646s ] --------------------------------------------------------------- [ 2021-12-20T13:48:25+08:00 ] 39.144.15.171 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003064s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026466s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000903s ] --------------------------------------------------------------- [ 2021-12-20T13:48:27+08:00 ] 39.144.15.171 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639979305&v1=0.007676&v2=0.781789&v3=0.007766&v4=0.008157&v5=5.220000&t=28.043234&h=35.694672&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002267s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021325s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000894s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639979305,`v1`=0.007676,`v2`=0.781789,`v3`=0.007766,`v4`=0.008157,`v5`=5.22,`t`=28.043234,`h`=35.694672,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639979307 WHERE `imei` = '868922055677740' [ RunTime:0.001057s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017658s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639979305 , 0.007676 , 0.781789 , 0.007766 , 0.008157 , 5.22 , 28.043234 , 35.694672 , '89860426102071188502' , '460044618415252' , -0 , 1639979307) [ RunTime:0.000713s ] --------------------------------------------------------------- [ 2021-12-20T13:48:29+08:00 ] 39.144.15.171 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041605&v1=0.000000&v2=0.700000&v3=0.000000&v4=0.000000&v5=5.400000&t=18.500000&h=69.910004&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.015013s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032531s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001298s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041605,`v1`=0,`v2`=0.7,`v3`=0,`v4`=0,`v5`=5.4,`t`=18.5,`h`=69.910004,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639979309 WHERE `imei` = '868922055677740' [ RunTime:0.001433s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.024036s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041605 , 0 , 0.7 , 0 , 0 , 5.4 , 18.5 , 69.910004 , '89860426102071188502' , '460044618415252' , -0 , 1639979309) [ RunTime:0.000877s ] --------------------------------------------------------------- [ 2021-12-20T13:50:23+08:00 ] 39.144.4.91 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002100s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027389s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001002s ] --------------------------------------------------------------- [ 2021-12-20T13:50:24+08:00 ] 39.144.4.91 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639979423&v1=0.007375&v2=0.790551&v3=0.007585&v4=0.007856&v5=5.220000&t=23.227673&h=44.270115&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002825s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021823s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000850s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639979423,`v1`=0.007375,`v2`=0.790551,`v3`=0.007585,`v4`=0.007856,`v5`=5.22,`t`=23.227673,`h`=44.270115,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639979424 WHERE `imei` = '868922055677740' [ RunTime:0.002062s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018393s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639979423 , 0.007375 , 0.790551 , 0.007585 , 0.007856 , 5.22 , 23.227673 , 44.270115 , '89860426102071188502' , '460044618415252' , -0 , 1639979424) [ RunTime:0.000686s ] --------------------------------------------------------------- [ 2021-12-20T13:50:43+08:00 ] 123.234.86.34 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003621s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.021416s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000652s ] --------------------------------------------------------------- [ 2021-12-20T13:50:44+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002275s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022525s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001069s ] --------------------------------------------------------------- [ 2021-12-20T13:50:48+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002497s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022681s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000575s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001078s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000908s ] --------------------------------------------------------------- [ 2021-12-20T13:50:52+08:00 ] 123.234.86.34 GET /home/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002596s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023902s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.001060s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.017328s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` [ RunTime:0.000474s ] --------------------------------------------------------------- [ 2021-12-20T13:50:55+08:00 ] 123.234.86.34 POST /home/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002131s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021921s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `interval`=5,`gps`='120.082436,36.159645',`introduce`=' ',`update_time`=1639979455 WHERE `id` = 22 [ RunTime:0.001180s ] --------------------------------------------------------------- [ 2021-12-20T13:50:56+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002588s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022102s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000592s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001009s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000940s ] --------------------------------------------------------------- [ 2021-12-20T13:51:05+08:00 ] 221.178.125.38 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002696s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024365s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001410s ] --------------------------------------------------------------- [ 2021-12-20T13:51:06+08:00 ] 221.178.125.38 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639979465&v1=0.007435&v2=0.778556&v3=0.007585&v4=0.007796&v5=5.220000&t=22.712870&h=45.124611&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001897s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021550s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000912s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639979465,`v1`=0.007435,`v2`=0.778556,`v3`=0.007585,`v4`=0.007796,`v5`=5.22,`t`=22.71287,`h`=45.124611,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639979466 WHERE `imei` = '868922055677740' [ RunTime:0.000960s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016313s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639979465 , 0.007435 , 0.778556 , 0.007585 , 0.007796 , 5.22 , 22.71287 , 45.124611 , '89860426102071188502' , '460044618415252' , -0 , 1639979466) [ RunTime:0.000549s ] --------------------------------------------------------------- [ 2021-12-20T13:51:57+08:00 ] 39.144.15.102 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002228s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023419s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000857s ] --------------------------------------------------------------- [ 2021-12-20T13:51:59+08:00 ] 39.144.15.102 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639979517&v1=0.007314&v2=0.770003&v3=0.007645&v4=0.007615&v5=5.220000&t=22.326765&h=47.215065&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002259s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024024s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001830s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639979517,`v1`=0.007314,`v2`=0.770003,`v3`=0.007645,`v4`=0.007615,`v5`=5.22,`t`=22.326765,`h`=47.215065,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639979519 WHERE `imei` = '868922055677740' [ RunTime:0.000959s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016155s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639979517 , 0.007314 , 0.770003 , 0.007645 , 0.007615 , 5.22 , 22.326765 , 47.215065 , '89860426102071188502' , '460044618415252' , -0 , 1639979519) [ RunTime:0.000491s ] --------------------------------------------------------------- [ 2021-12-20T13:52:46+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002616s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027579s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000940s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.002215s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001045s ] --------------------------------------------------------------- [ 2021-12-20T13:52:59+08:00 ] 39.144.10.83 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003095s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023140s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000916s ] --------------------------------------------------------------- [ 2021-12-20T13:53:00+08:00 ] 39.144.10.83 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639979579&v1=0.007254&v2=1.293004&v3=0.007615&v4=0.007796&v5=5.220000&t=21.715437&h=49.580177&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002195s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025636s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000955s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639979579,`v1`=0.007254,`v2`=1.293004,`v3`=0.007615,`v4`=0.007796,`v5`=5.22,`t`=21.715437,`h`=49.580177,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639979580 WHERE `imei` = '868922055677740' [ RunTime:0.001121s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018242s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639979579 , 0.007254 , 1.293004 , 0.007615 , 0.007796 , 5.22 , 21.715437 , 49.580177 , '89860426102071188502' , '460044618415252' , -0 , 1639979580) [ RunTime:0.000509s ] --------------------------------------------------------------- [ 2021-12-20T13:57:43+08:00 ] 39.144.13.198 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.004042s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028990s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000899s ] --------------------------------------------------------------- [ 2021-12-20T13:57:45+08:00 ] 39.144.13.198 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639979863&v1=0.007074&v2=0.727028&v3=0.007465&v4=0.007736&v5=5.220000&t=19.302294&h=55.950729&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002168s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024827s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000853s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639979863,`v1`=0.007074,`v2`=0.727028,`v3`=0.007465,`v4`=0.007736,`v5`=5.22,`t`=19.302294,`h`=55.950729,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639979865 WHERE `imei` = '868922055677740' [ RunTime:0.001178s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016397s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639979863 , 0.007074 , 0.727028 , 0.007465 , 0.007736 , 5.22 , 19.302294 , 55.950729 , '89860426102071188502' , '460044618415252' , -0 , 1639979865) [ RunTime:0.000514s ] --------------------------------------------------------------- [ 2021-12-20T14:04:02+08:00 ] 39.144.16.228 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003126s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025868s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000830s ] --------------------------------------------------------------- [ 2021-12-20T14:04:09+08:00 ] 39.144.16.228 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041623&v1=0.007555&v2=0.609055&v3=0.007706&v4=0.007977&v5=5.220000&t=24.772085&h=42.461948&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002598s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024595s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000868s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041623,`v1`=0.007555,`v2`=0.609055,`v3`=0.007706,`v4`=0.007977,`v5`=5.22,`t`=24.772085,`h`=42.461948,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639980249 WHERE `imei` = '868922055677740' [ RunTime:0.000988s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015646s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041623 , 0.007555 , 0.609055 , 0.007706 , 0.007977 , 5.22 , 24.772085 , 42.461948 , '89860426102071188502' , '460044618415252' , -0 , 1639980249) [ RunTime:0.000594s ] --------------------------------------------------------------- [ 2021-12-20T14:04:47+08:00 ] 117.132.195.38 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001943s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024542s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000846s ] --------------------------------------------------------------- [ 2021-12-20T14:04:52+08:00 ] 117.132.195.38 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639980287&v1=0.007435&v2=0.604570&v3=0.007645&v4=0.007916&v5=5.220000&t=23.967703&h=44.956764&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002147s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026317s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000866s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639980287,`v1`=0.007435,`v2`=0.60457,`v3`=0.007645,`v4`=0.007916,`v5`=5.22,`t`=23.967703,`h`=44.956764,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639980292 WHERE `imei` = '868922055677740' [ RunTime:0.001009s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016319s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639980287 , 0.007435 , 0.60457 , 0.007645 , 0.007916 , 5.22 , 23.967703 , 44.956764 , '89860426102071188502' , '460044618415252' , -0 , 1639980292) [ RunTime:0.000492s ] --------------------------------------------------------------- [ 2021-12-20T14:04:54+08:00 ] 117.132.195.38 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041623&v1=0.000000&v2=0.600000&v3=0.000000&v4=0.000000&v5=5.220000&t=24.770000&h=42.459999&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end=$ [ 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.022308s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000872s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041623,`v1`=0,`v2`=0.6,`v3`=0,`v4`=0,`v5`=5.22,`t`=24.77,`h`=42.459999,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639980294 WHERE `imei` = '868922055677740' [ RunTime:0.001032s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016365s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041623 , 0 , 0.6 , 0 , 0 , 5.22 , 24.77 , 42.459999 , '89860426102071188502' , '460044618415252' , -0 , 1639980294) [ RunTime:0.000568s ] --------------------------------------------------------------- [ 2021-12-20T14:05:19+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003230s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022617s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000529s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000952s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000840s ] --------------------------------------------------------------- [ 2021-12-20T14:05:34+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003332s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025776s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000984s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018131s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001672s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.001578s ] --------------------------------------------------------------- [ 2021-12-20T14:05:37+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html?page=59 [ sql ] [ DB ] CONNECT:[ UseTime:0.002991s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023613s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000937s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016024s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001018s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 580,10 [ RunTime:0.016983s ] --------------------------------------------------------------- [ 2021-12-20T14:09:26+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003076s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027870s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000630s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001473s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2021-12-20T14:10:15+08:00 ] 221.178.125.75 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002773s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023384s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000844s ] --------------------------------------------------------------- [ 2021-12-20T14:10:18+08:00 ] 221.178.125.75 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639980615&v1=0.007194&v2=0.547722&v3=0.007465&v4=0.007615&v5=5.220000&t=19.945799&h=54.997051&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002434s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032771s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001388s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639980615,`v1`=0.007194,`v2`=0.547722,`v3`=0.007465,`v4`=0.007615,`v5`=5.22,`t`=19.945799,`h`=54.997051,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639980618 WHERE `imei` = '868922055677740' [ RunTime:0.001579s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021670s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639980615 , 0.007194 , 0.547722 , 0.007465 , 0.007615 , 5.22 , 19.945799 , 54.997051 , '89860426102071188502' , '460044618415252' , -0 , 1639980618) [ RunTime:0.002021s ] --------------------------------------------------------------- [ 2021-12-20T14:27:58+08:00 ] 117.132.192.247 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003106s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025983s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000836s ] --------------------------------------------------------------- [ 2021-12-20T14:28:06+08:00 ] 117.132.192.247 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211220&time=142701&v1=-01.293&v2=+00.004&v3=-01.161&v4=-00.773&v5=06.0&t=+12.3&h=71.8&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.156&a2=01.309&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002048s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025478s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000750s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211220',`time`='142701',`v1`=-1.293,`v2`=0.004,`v3`=-1.161,`v4`=-0.773,`v5`=6,`t`=12.3,`h`=71.8,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.156,`a2`=1.309,`update_time`=1639981686 WHERE `imei` = '868922055684076' [ RunTime:0.000785s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016892s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211220' , '142701' , -1.293 , 0.004 , -1.161 , -0.773 , 6 , 12.3 , 71.8 , '460044618415249' , -0 , 0.156 , 1.309 , 1639981686 , 1639981686) [ RunTime:0.000658s ] --------------------------------------------------------------- [ 2021-12-20T14:37:49+08:00 ] 117.132.193.58 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003675s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.036964s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000927s ] --------------------------------------------------------------- [ 2021-12-20T14:37:51+08:00 ] 117.132.193.58 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639982269&v1=0.006652&v2=0.270262&v3=0.007405&v4=0.007495&v5=5.220000&t=19.720572&h=59.803574&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002092s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022909s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000810s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639982269,`v1`=0.006652,`v2`=0.270262,`v3`=0.007405,`v4`=0.007495,`v5`=5.22,`t`=19.720572,`h`=59.803574,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639982271 WHERE `imei` = '868922055677740' [ RunTime:0.000967s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015212s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639982269 , 0.006652 , 0.270262 , 0.007405 , 0.007495 , 5.22 , 19.720572 , 59.803574 , '89860426102071188502' , '460044618415252' , -0 , 1639982271) [ RunTime:0.000559s ] --------------------------------------------------------------- [ 2021-12-20T14:37:52+08:00 ] 117.132.193.58 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041605&v1=0.000000&v2=0.240000&v3=0.000000&v4=0.000000&v5=5.400000&t=19.070000&h=59.000000&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002449s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023299s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000847s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041605,`v1`=0,`v2`=0.24,`v3`=0,`v4`=0,`v5`=5.4,`t`=19.07,`h`=59,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639982272 WHERE `imei` = '868922055677740' [ RunTime:0.001019s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016762s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041605 , 0 , 0.24 , 0 , 0 , 5.4 , 19.07 , 59 , '89860426102071188502' , '460044618415252' , -0 , 1639982272) [ RunTime:0.000531s ] --------------------------------------------------------------- [ 2021-12-20T14:39:50+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002078s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023338s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000854s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016171s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000979s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.001402s ] --------------------------------------------------------------- [ 2021-12-20T14:39:57+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001853s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.020871s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000867s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015786s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001079s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 10,10 [ RunTime:0.001571s ] --------------------------------------------------------------- [ 2021-12-20T14:40:03+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html?page=60 [ sql ] [ DB ] CONNECT:[ UseTime:0.002916s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028416s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000851s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014594s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001149s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 590,10 [ RunTime:0.016431s ] --------------------------------------------------------------- [ 2021-12-20T14:40:09+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html?page=59 [ sql ] [ DB ] CONNECT:[ UseTime:0.002238s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022544s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000841s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015070s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001026s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 580,10 [ RunTime:0.016385s ] --------------------------------------------------------------- [ 2021-12-20T14:40:13+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html?page=58 [ sql ] [ DB ] CONNECT:[ UseTime:0.002349s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022716s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000875s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015439s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000997s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 570,10 [ RunTime:0.016620s ] --------------------------------------------------------------- [ 2021-12-20T14:40:15+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html?page=57 [ sql ] [ DB ] CONNECT:[ UseTime:0.002045s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022328s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000787s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016949s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001019s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 560,10 [ RunTime:0.016142s ] --------------------------------------------------------------- [ 2021-12-20T14:40:17+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html?page=56 [ sql ] [ DB ] CONNECT:[ UseTime:0.002760s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022550s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000855s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016070s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001136s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 550,10 [ RunTime:0.015721s ] --------------------------------------------------------------- [ 2021-12-20T14:47:32+08:00 ] 39.144.1.237 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003164s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024606s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000875s ] --------------------------------------------------------------- [ 2021-12-20T14:47:34+08:00 ] 39.144.1.237 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041620&v1=0.007134&v2=0.218838&v3=0.007495&v4=0.007676&v5=-95.040001&t=20.728729&h=56.103317&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001984s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021116s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000807s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041620,`v1`=0.007134,`v2`=0.218838,`v3`=0.007495,`v4`=0.007676,`v5`=-95.040001,`t`=20.728729,`h`=56.103317,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639982854 WHERE `imei` = '868922055677740' [ RunTime:0.000951s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014739s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041620 , 0.007134 , 0.218838 , 0.007495 , 0.007676 , -95.040001 , 20.728729 , 56.103317 , '89860426102071188502' , '460044618415252' , -0 , 1639982854) [ RunTime:0.000487s ] --------------------------------------------------------------- [ 2021-12-20T15:04:56+08:00 ] 39.144.14.93 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003660s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.036126s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001004s ] --------------------------------------------------------------- [ 2021-12-20T15:05:04+08:00 ] 39.144.14.93 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211220&time=150401&v1=-01.395&v2=+00.255&v3=-01.705&v4=+00.028&v5=06.2&t=+19.9&h=84.9&rssi=+226&imsi=460044618415257&v6=-00.000&a1=00.036&a2=06.064&a3=00.021&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002324s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027455s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001058s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211220',`time`='150401',`v1`=-1.395,`v2`=0.255,`v3`=-1.705,`v4`=0.028,`v5`=6.2,`t`=19.9,`h`=84.9,`rssi`=226,`imsi`='460044618415257',`v6`=-0,`a1`=0.036,`a2`=6.064,`update_time`=1639983904 WHERE `imei` = '868922055681221' [ RunTime:0.001101s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.027969s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055681221' , '211220' , '150401' , -1.395 , 0.255 , -1.705 , 0.028 , 6.2 , 19.9 , 84.9 , '460044618415257' , -0 , 0.036 , 6.064 , 1639983904 , 1639983904) [ RunTime:0.001204s ] --------------------------------------------------------------- [ 2021-12-20T16:27:57+08:00 ] 221.178.126.240 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003527s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.039458s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000895s ] --------------------------------------------------------------- [ 2021-12-20T16:28:05+08:00 ] 221.178.126.240 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211220&time=162701&v1=-01.293&v2=+00.005&v3=-01.161&v4=-00.773&v5=06.0&t=+10.9&h=72.6&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.155&a2=01.308&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002051s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022742s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000712s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211220',`time`='162701',`v1`=-1.293,`v2`=0.005,`v3`=-1.161,`v4`=-0.773,`v5`=6,`t`=10.9,`h`=72.6,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.155,`a2`=1.308,`update_time`=1639988885 WHERE `imei` = '868922055684076' [ RunTime:0.000732s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017182s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211220' , '162701' , -1.293 , 0.005 , -1.161 , -0.773 , 6 , 10.9 , 72.6 , '460044618415249' , -0 , 0.155 , 1.308 , 1639988885 , 1639988885) [ RunTime:0.000742s ] --------------------------------------------------------------- [ 2021-12-20T18:27:57+08:00 ] 39.144.8.221 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003693s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029377s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000840s ] --------------------------------------------------------------- [ 2021-12-20T18:28:06+08:00 ] 39.144.8.221 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211220&time=182701&v1=-01.295&v2=+00.004&v3=-01.162&v4=-00.774&v5=06.0&t=+04.7&h=74.1&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.157&a2=01.312&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002160s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023906s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000810s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211220',`time`='182701',`v1`=-1.295,`v2`=0.004,`v3`=-1.162,`v4`=-0.774,`v5`=6,`t`=4.7,`h`=74.1,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.157,`a2`=1.312,`update_time`=1639996086 WHERE `imei` = '868922055684076' [ RunTime:0.000792s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019220s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211220' , '182701' , -1.295 , 0.004 , -1.162 , -0.774 , 6 , 4.7 , 74.1 , '460044618415249' , -0 , 0.157 , 1.312 , 1639996086 , 1639996086) [ RunTime:0.000726s ] --------------------------------------------------------------- [ 2021-12-20T20:27:58+08:00 ] 39.144.6.130 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003260s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027255s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000777s ] --------------------------------------------------------------- [ 2021-12-20T20:28:06+08:00 ] 39.144.6.130 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211220&time=202701&v1=-01.295&v2=+00.004&v3=-01.161&v4=-00.773&v5=06.0&t=+05.3&h=73.2&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.161&a2=01.314&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002345s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024127s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000808s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211220',`time`='202701',`v1`=-1.295,`v2`=0.004,`v3`=-1.161,`v4`=-0.773,`v5`=6,`t`=5.3,`h`=73.2,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.161,`a2`=1.314,`update_time`=1640003286 WHERE `imei` = '868922055684076' [ RunTime:0.000793s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017427s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211220' , '202701' , -1.295 , 0.004 , -1.161 , -0.773 , 6 , 5.3 , 73.2 , '460044618415249' , -0 , 0.161 , 1.314 , 1640003286 , 1640003286) [ RunTime:0.000730s ] --------------------------------------------------------------- [ 2021-12-20T21:04:57+08:00 ] 117.132.194.144 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.023220s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023079s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000740s ] --------------------------------------------------------------- [ 2021-12-20T21:05:04+08:00 ] 117.132.194.144 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211220&time=210401&v1=-00.703&v2=+00.991&v3=-01.282&v4=+00.028&v5=06.2&t=+06.4&h=86.6&rssi=+226&imsi=460044618415257&v6=-00.000&a1=00.056&a2=15.993&a3=00.277&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002189s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022661s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000753s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211220',`time`='210401',`v1`=-0.703,`v2`=0.991,`v3`=-1.282,`v4`=0.028,`v5`=6.2,`t`=6.4,`h`=86.6,`rssi`=226,`imsi`='460044618415257',`v6`=-0,`a1`=0.056,`a2`=15.993,`update_time`=1640005504 WHERE `imei` = '868922055681221' [ RunTime:0.000685s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018346s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055681221' , '211220' , '210401' , -0.703 , 0.991 , -1.282 , 0.028 , 6.2 , 6.4 , 86.6 , '460044618415257' , -0 , 0.056 , 15.993 , 1640005504 , 1640005504) [ RunTime:0.000702s ] --------------------------------------------------------------- [ 2021-12-20T21:19:40+08:00 ] 223.104.255.219 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/867032052269912 [ sql ] [ DB ] CONNECT:[ UseTime:0.003146s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025395s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '867032052269912' LIMIT 1 [ RunTime:0.001107s ] --------------------------------------------------------------- [ 2021-12-20T21:19:42+08:00 ] 223.104.255.219 GET /kaiwu/public/index.php?s=/index/index/update/&imei=867032052269912&create_time=1640006380&v1=0.017789&v2=0.076771&v3=0.018000&v4=0.018391&v5=4.860000&t=26.724049&h=39.806919&rssi=99&ccid=89860426102071188503&imsi=460044618415253&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002645s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023768s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '867032052269912' LIMIT 1 [ RunTime:0.000765s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='867032052269912',`create_time`=1640006380,`v1`=0.017789,`v2`=0.076771,`v3`=0.018,`v4`=0.018391,`v5`=4.86,`t`=26.724049,`h`=39.806919,`rssi`=99,`ccid`='89860426102071188503',`imsi`='460044618415253',`v6`=-0,`update_time`=1640006382 WHERE `imei` = '867032052269912' [ RunTime:0.000836s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020639s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('867032052269912' , 1640006380 , 0.017789 , 0.076771 , 0.018 , 0.018391 , 4.86 , 26.724049 , 39.806919 , '89860426102071188503' , '460044618415253' , -0 , 1640006382) [ RunTime:0.000689s ] --------------------------------------------------------------- [ 2021-12-20T21:20:33+08:00 ] 123.234.86.34 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002495s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.035291s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = '0fb79824e56bbe1308ee004759a53799' LIMIT 1 [ RunTime:0.000740s ] --------------------------------------------------------------- [ 2021-12-20T21:20:55+08:00 ] 123.234.86.34 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003483s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.024210s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000572s ] --------------------------------------------------------------- [ 2021-12-20T21:20:57+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001965s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022913s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000394s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001417s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001627s ] --------------------------------------------------------------- [ 2021-12-20T21:21:05+08:00 ] 123.234.86.34 GET /admin/show/read/id/21/imei/867032052269912.html [ sql ] [ DB ] CONNECT:[ UseTime:0.011322s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023465s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000834s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017308s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '867032052269912' LIMIT 1 [ RunTime:0.001073s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '867032052269912' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001355s ] --------------------------------------------------------------- [ 2021-12-20T21:21:41+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002713s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022261s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000475s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001254s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001277s ] --------------------------------------------------------------- [ 2021-12-20T21:25:05+08:00 ] 39.144.12.252 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/867032052269912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002770s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027367s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '867032052269912' LIMIT 1 [ RunTime:0.000777s ] --------------------------------------------------------------- [ 2021-12-20T21:25:06+08:00 ] 39.144.12.252 GET /kaiwu/public/index.php?s=/index/index/update/&imei=867032052269912&create_time=1640006705&v1=0.017850&v2=0.069365&v3=0.017940&v4=0.018331&v5=4.860000&t=20.653654&h=54.569805&rssi=99&ccid=89860426102071188503&imsi=460044618415253&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003062s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030424s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '867032052269912' LIMIT 1 [ RunTime:0.001066s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='867032052269912',`create_time`=1640006705,`v1`=0.01785,`v2`=0.069365,`v3`=0.01794,`v4`=0.018331,`v5`=4.86,`t`=20.653654,`h`=54.569805,`rssi`=99,`ccid`='89860426102071188503',`imsi`='460044618415253',`v6`=-0,`update_time`=1640006706 WHERE `imei` = '867032052269912' [ RunTime:0.000989s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.024216s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('867032052269912' , 1640006705 , 0.01785 , 0.069365 , 0.01794 , 0.018331 , 4.86 , 20.653654 , 54.569805 , '89860426102071188503' , '460044618415253' , -0 , 1640006706) [ RunTime:0.000821s ] --------------------------------------------------------------- [ 2021-12-20T21:30:10+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003536s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.036679s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000466s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001298s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001212s ] --------------------------------------------------------------- [ 2021-12-20T21:30:29+08:00 ] 39.144.13.217 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/867032052269912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002181s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025256s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '867032052269912' LIMIT 1 [ RunTime:0.000730s ] --------------------------------------------------------------- [ 2021-12-20T21:30:31+08:00 ] 39.144.13.217 GET /kaiwu/public/index.php?s=/index/index/update/&imei=867032052269912&create_time=1640007029&v1=0.017669&v2=0.066444&v3=0.017850&v4=0.018151&v5=4.680000&t=19.420269&h=58.811752&rssi=99&ccid=89860426102071188503&imsi=460044618415253&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.010809s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.020023s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '867032052269912' LIMIT 1 [ RunTime:0.000729s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='867032052269912',`create_time`=1640007029,`v1`=0.017669,`v2`=0.066444,`v3`=0.01785,`v4`=0.018151,`v5`=4.68,`t`=19.420269,`h`=58.811752,`rssi`=99,`ccid`='89860426102071188503',`imsi`='460044618415253',`v6`=-0,`update_time`=1640007031 WHERE `imei` = '867032052269912' [ RunTime:0.000714s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021443s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('867032052269912' , 1640007029 , 0.017669 , 0.066444 , 0.01785 , 0.018151 , 4.68 , 19.420269 , 58.811752 , '89860426102071188503' , '460044618415253' , -0 , 1640007031) [ RunTime:0.000509s ] --------------------------------------------------------------- [ 2021-12-20T21:31:59+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002440s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025901s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000472s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001315s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001420s ] --------------------------------------------------------------- [ 2021-12-20T21:35:53+08:00 ] 223.104.255.250 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/867032052269912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002346s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025075s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '867032052269912' LIMIT 1 [ RunTime:0.000759s ] --------------------------------------------------------------- [ 2021-12-20T21:35:55+08:00 ] 223.104.255.250 GET /kaiwu/public/index.php?s=/index/index/update/&imei=867032052269912&create_time=1640007353&v1=0.017729&v2=0.069678&v3=0.017819&v4=0.018151&v5=4.680000&t=19.130692&h=60.467331&rssi=99&ccid=89860426102071188503&imsi=460044618415253&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002215s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022665s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '867032052269912' LIMIT 1 [ RunTime:0.000771s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='867032052269912',`create_time`=1640007353,`v1`=0.017729,`v2`=0.069678,`v3`=0.017819,`v4`=0.018151,`v5`=4.68,`t`=19.130692,`h`=60.467331,`rssi`=99,`ccid`='89860426102071188503',`imsi`='460044618415253',`v6`=-0,`update_time`=1640007355 WHERE `imei` = '867032052269912' [ RunTime:0.000683s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021932s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('867032052269912' , 1640007353 , 0.017729 , 0.069678 , 0.017819 , 0.018151 , 4.68 , 19.130692 , 60.467331 , '89860426102071188503' , '460044618415253' , -0 , 1640007355) [ RunTime:0.000559s ] --------------------------------------------------------------- [ 2021-12-20T21:36:35+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002212s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024660s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000418s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001763s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001381s ] --------------------------------------------------------------- [ 2021-12-20T21:41:16+08:00 ] 221.178.126.213 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/867032052269912 [ sql ] [ DB ] CONNECT:[ UseTime:0.003278s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033206s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '867032052269912' LIMIT 1 [ RunTime:0.001206s ] --------------------------------------------------------------- [ 2021-12-20T21:41:18+08:00 ] 221.178.126.213 GET /kaiwu/public/index.php?s=/index/index/update/&imei=867032052269912&create_time=1640007676&v1=0.017609&v2=0.068739&v3=0.017699&v4=0.018211&v5=4.860000&t=19.098516&h=61.031910&rssi=99&ccid=89860426102071188503&imsi=460044618415253&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002582s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023724s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '867032052269912' LIMIT 1 [ RunTime:0.000782s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='867032052269912',`create_time`=1640007676,`v1`=0.017609,`v2`=0.068739,`v3`=0.017699,`v4`=0.018211,`v5`=4.86,`t`=19.098516,`h`=61.03191,`rssi`=99,`ccid`='89860426102071188503',`imsi`='460044618415253',`v6`=-0,`update_time`=1640007678 WHERE `imei` = '867032052269912' [ RunTime:0.000696s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016042s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('867032052269912' , 1640007676 , 0.017609 , 0.068739 , 0.017699 , 0.018211 , 4.86 , 19.098516 , 61.03191 , '89860426102071188503' , '460044618415253' , -0 , 1640007678) [ RunTime:0.000543s ] --------------------------------------------------------------- [ 2021-12-20T21:46:41+08:00 ] 39.144.10.172 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/867032052269912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002732s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027900s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '867032052269912' LIMIT 1 [ RunTime:0.001348s ] --------------------------------------------------------------- [ 2021-12-20T21:46:42+08:00 ] 39.144.10.172 GET /kaiwu/public/index.php?s=/index/index/update/&imei=867032052269912&create_time=1640008001&v1=0.017669&v2=0.065297&v3=0.017819&v4=0.018151&v5=4.680000&t=19.162867&h=61.092945&rssi=99&ccid=89860426102071188503&imsi=460044618415253&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.025848s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '867032052269912' LIMIT 1 [ RunTime:0.000777s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='867032052269912',`create_time`=1640008001,`v1`=0.017669,`v2`=0.065297,`v3`=0.017819,`v4`=0.018151,`v5`=4.68,`t`=19.162867,`h`=61.092945,`rssi`=99,`ccid`='89860426102071188503',`imsi`='460044618415253',`v6`=-0,`update_time`=1640008002 WHERE `imei` = '867032052269912' [ RunTime:0.001078s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016083s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('867032052269912' , 1640008001 , 0.017669 , 0.065297 , 0.017819 , 0.018151 , 4.68 , 19.162867 , 61.092945 , '89860426102071188503' , '460044618415253' , -0 , 1640008002) [ RunTime:0.000699s ] --------------------------------------------------------------- [ 2021-12-20T22:27:57+08:00 ] 39.144.1.237 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002987s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027720s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000785s ] --------------------------------------------------------------- [ 2021-12-20T22:28:06+08:00 ] 39.144.1.237 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211220&time=222701&v1=-01.295&v2=+00.004&v3=-01.161&v4=-00.774&v5=06.0&t=+04.9&h=73.3&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.158&a2=01.311&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002022s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022704s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000782s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211220',`time`='222701',`v1`=-1.295,`v2`=0.004,`v3`=-1.161,`v4`=-0.774,`v5`=6,`t`=4.9,`h`=73.3,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.158,`a2`=1.311,`update_time`=1640010486 WHERE `imei` = '868922055684076' [ RunTime:0.000753s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017900s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211220' , '222701' , -1.295 , 0.004 , -1.161 , -0.774 , 6 , 4.9 , 73.3 , '460044618415249' , -0 , 0.158 , 1.311 , 1640010486 , 1640010486) [ RunTime:0.000707s ]