--------------------------------------------------------------- [ 2021-12-24T00:27:57+08:00 ] 117.132.192.50 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003010s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.035758s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000809s ] --------------------------------------------------------------- [ 2021-12-24T00:28:06+08:00 ] 117.132.192.50 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211224&time=002701&v1=-01.293&v2=+00.011&v3=-01.160&v4=-00.774&v5=06.0&t=+04.5&h=73.6&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.310&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002114s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024739s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000778s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211224',`time`='002701',`v1`=-1.293,`v2`=0.011,`v3`=-1.16,`v4`=-0.774,`v5`=6,`t`=4.5,`h`=73.6,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.31,`update_time`=1640276886 WHERE `imei` = '868922055684076' [ RunTime:0.000753s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.033355s ] [ 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' , '211224' , '002701' , -1.293 , 0.011 , -1.16 , -0.774 , 6 , 4.5 , 73.6 , '460044618415249' , -0 , 0.159 , 1.31 , 1640276886 , 1640276886) [ RunTime:0.000849s ] --------------------------------------------------------------- [ 2021-12-24T02:27:58+08:00 ] 117.132.191.174 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003142s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.038454s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000834s ] --------------------------------------------------------------- [ 2021-12-24T02:28:06+08:00 ] 117.132.191.174 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211224&time=022701&v1=-01.293&v2=+00.011&v3=-01.160&v4=-00.774&v5=05.9&t=+02.4&h=73.8&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.310&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002198s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024984s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000678s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211224',`time`='022701',`v1`=-1.293,`v2`=0.011,`v3`=-1.16,`v4`=-0.774,`v5`=5.9,`t`=2.4,`h`=73.8,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.31,`update_time`=1640284086 WHERE `imei` = '868922055684076' [ RunTime:0.000709s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019086s ] [ 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' , '211224' , '022701' , -1.293 , 0.011 , -1.16 , -0.774 , 5.9 , 2.4 , 73.8 , '460044618415249' , -0 , 0.159 , 1.31 , 1640284086 , 1640284086) [ RunTime:0.000654s ] --------------------------------------------------------------- [ 2021-12-24T03:04:55+08:00 ] 221.178.124.213 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003139s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033871s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000732s ] --------------------------------------------------------------- [ 2021-12-24T03:05:03+08:00 ] 221.178.124.213 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211224&time=030401&v1=-01.433&v2=+00.904&v3=-01.452&v4=+00.028&v5=06.0&t=+01.6&h=86.5&rssi=+225&imsi=460044618415257&v6=-00.000&a1=00.042&a2=19.880&a3=00.287&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002244s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024399s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000683s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211224',`time`='030401',`v1`=-1.433,`v2`=0.904,`v3`=-1.452,`v4`=0.028,`v5`=6,`t`=1.6,`h`=86.5,`rssi`=225,`imsi`='460044618415257',`v6`=-0,`a1`=0.042,`a2`=19.88,`update_time`=1640286303 WHERE `imei` = '868922055681221' [ RunTime:0.000719s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020143s ] [ 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' , '211224' , '030401' , -1.433 , 0.904 , -1.452 , 0.028 , 6 , 1.6 , 86.5 , '460044618415257' , -0 , 0.042 , 19.88 , 1640286303 , 1640286303) [ RunTime:0.000696s ] --------------------------------------------------------------- [ 2021-12-24T04:27:57+08:00 ] 39.144.3.239 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003060s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030507s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000817s ] --------------------------------------------------------------- [ 2021-12-24T04:28:05+08:00 ] 39.144.3.239 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211224&time=042701&v1=-01.294&v2=+00.011&v3=-01.159&v4=-00.774&v5=05.9&t=+00.5&h=73.9&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.160&a2=01.311&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002085s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023639s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000690s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211224',`time`='042701',`v1`=-1.294,`v2`=0.011,`v3`=-1.159,`v4`=-0.774,`v5`=5.9,`t`=0.5,`h`=73.9,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.16,`a2`=1.311,`update_time`=1640291285 WHERE `imei` = '868922055684076' [ RunTime:0.001526s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018433s ] [ 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' , '211224' , '042701' , -1.294 , 0.011 , -1.159 , -0.774 , 5.9 , 0.5 , 73.9 , '460044618415249' , -0 , 0.16 , 1.311 , 1640291285 , 1640291285) [ RunTime:0.000641s ] --------------------------------------------------------------- [ 2021-12-24T06:27:57+08:00 ] 117.132.193.118 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003423s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032133s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000825s ] --------------------------------------------------------------- [ 2021-12-24T06:28:06+08:00 ] 117.132.193.118 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211224&time=062701&v1=-01.293&v2=+00.012&v3=-01.158&v4=-00.775&v5=05.9&t=-01.4&h=74.0&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.161&a2=01.310&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002149s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023019s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000948s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211224',`time`='062701',`v1`=-1.293,`v2`=0.012,`v3`=-1.158,`v4`=-0.775,`v5`=5.9,`t`=-1.4,`h`=74,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.161,`a2`=1.31,`update_time`=1640298486 WHERE `imei` = '868922055684076' [ RunTime:0.001080s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016669s ] [ 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' , '211224' , '062701' , -1.293 , 0.012 , -1.158 , -0.775 , 5.9 , -1.4 , 74 , '460044618415249' , -0 , 0.161 , 1.31 , 1640298486 , 1640298486) [ RunTime:0.000704s ] --------------------------------------------------------------- [ 2021-12-24T08:27:58+08:00 ] 39.144.12.243 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003754s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029310s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000890s ] --------------------------------------------------------------- [ 2021-12-24T08:28:06+08:00 ] 39.144.12.243 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211224&time=082701&v1=-01.294&v2=+00.013&v3=-01.158&v4=-00.774&v5=05.9&t=-02.3&h=73.9&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.164&a2=01.313&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002200s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024141s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000706s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211224',`time`='082701',`v1`=-1.294,`v2`=0.013,`v3`=-1.158,`v4`=-0.774,`v5`=5.9,`t`=-2.3,`h`=73.9,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.164,`a2`=1.313,`update_time`=1640305686 WHERE `imei` = '868922055684076' [ RunTime:0.000805s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021320s ] [ 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' , '211224' , '082701' , -1.294 , 0.013 , -1.158 , -0.774 , 5.9 , -2.3 , 73.9 , '460044618415249' , -0 , 0.164 , 1.313 , 1640305686 , 1640305686) [ RunTime:0.000690s ] --------------------------------------------------------------- [ 2021-12-24T09:04:57+08:00 ] 39.144.15.5 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003999s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032093s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000914s ] --------------------------------------------------------------- [ 2021-12-24T09:05:05+08:00 ] 39.144.15.5 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211224&time=090401&v1=-01.223&v2=+01.644&v3=-01.159&v4=+00.028&v5=06.0&t=-02.8&h=86.3&rssi=+226&imsi=460044618415257&v6=-00.000&a1=00.076&a2=11.447&a3=00.348&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002170s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025452s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000718s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211224',`time`='090401',`v1`=-1.223,`v2`=1.644,`v3`=-1.159,`v4`=0.028,`v5`=6,`t`=-2.8,`h`=86.3,`rssi`=226,`imsi`='460044618415257',`v6`=-0,`a1`=0.076,`a2`=11.447,`update_time`=1640307905 WHERE `imei` = '868922055681221' [ RunTime:0.000775s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021055s ] [ 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' , '211224' , '090401' , -1.223 , 1.644 , -1.159 , 0.028 , 6 , -2.8 , 86.3 , '460044618415257' , -0 , 0.076 , 11.447 , 1640307905 , 1640307905) [ RunTime:0.000695s ] --------------------------------------------------------------- [ 2021-12-24T09:37:54+08:00 ] 123.234.86.34 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003517s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.041587s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000701s ] --------------------------------------------------------------- [ 2021-12-24T09:37:57+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001875s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026581s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000407s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001592s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001447s ] --------------------------------------------------------------- [ 2021-12-24T09:38:14+08:00 ] 123.234.86.34 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002147s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.023031s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000649s ] --------------------------------------------------------------- [ 2021-12-24T09:38:19+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002192s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024450s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000381s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.002378s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001540s ] --------------------------------------------------------------- [ 2021-12-24T09:38:24+08:00 ] 123.234.86.34 GET /admin/show/read/id/24/imei/868922055681221.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002534s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026698s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000803s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019051s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001175s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681221' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001467s ] --------------------------------------------------------------- [ 2021-12-24T09:38:30+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002745s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025831s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000407s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001334s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001449s ] --------------------------------------------------------------- [ 2021-12-24T09:38:41+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002363s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024905s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000420s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001469s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001415s ] --------------------------------------------------------------- [ 2021-12-24T09:38:46+08:00 ] 123.234.86.34 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.002859s ] 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 COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000543s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001633s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001977s ] --------------------------------------------------------------- [ 2021-12-24T09:38:48+08:00 ] 123.234.86.34 GET /admin/show/index.html?page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.003155s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.037063s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000711s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.002391s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.002505s ] --------------------------------------------------------------- [ 2021-12-24T09:38:50+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002220s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023468s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000396s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001795s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001304s ] --------------------------------------------------------------- [ 2021-12-24T09:39:35+08:00 ] 123.234.86.34 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002869s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026925s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000731s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016613s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001171s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001517s ] --------------------------------------------------------------- [ 2021-12-24T10:27:58+08:00 ] 39.144.11.35 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.005823s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.082258s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001972s ] --------------------------------------------------------------- [ 2021-12-24T10:28:06+08:00 ] 39.144.11.35 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211224&time=102701&v1=-01.295&v2=+00.019&v3=-01.158&v4=-00.774&v5=05.2&t=-03.3&h=73.9&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.163&a2=01.311&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002077s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022260s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000800s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211224',`time`='102701',`v1`=-1.295,`v2`=0.019,`v3`=-1.158,`v4`=-0.774,`v5`=5.2,`t`=-3.3,`h`=73.9,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.163,`a2`=1.311,`update_time`=1640312886 WHERE `imei` = '868922055684076' [ RunTime:0.000778s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.026878s ] [ 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' , '211224' , '102701' , -1.295 , 0.019 , -1.158 , -0.774 , 5.2 , -3.3 , 73.9 , '460044618415249' , -0 , 0.163 , 1.311 , 1640312886 , 1640312886) [ RunTime:0.002969s ] --------------------------------------------------------------- [ 2021-12-24T12:27:57+08:00 ] 39.144.13.93 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003538s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029547s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001108s ] --------------------------------------------------------------- [ 2021-12-24T12:28:06+08:00 ] 39.144.13.93 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211224&time=122701&v1=-01.294&v2=+00.016&v3=-01.157&v4=-00.774&v5=05.9&t=-03.1&h=73.6&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.164&a2=01.312&a3=00.000&end=$ [ 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.024030s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000763s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211224',`time`='122701',`v1`=-1.294,`v2`=0.016,`v3`=-1.157,`v4`=-0.774,`v5`=5.9,`t`=-3.1,`h`=73.6,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.164,`a2`=1.312,`update_time`=1640320085 WHERE `imei` = '868922055684076' [ RunTime:0.000806s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016132s ] [ 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' , '211224' , '122701' , -1.294 , 0.016 , -1.157 , -0.774 , 5.9 , -3.1 , 73.6 , '460044618415249' , -0 , 0.164 , 1.312 , 1640320086 , 1640320086) [ RunTime:0.000806s ] --------------------------------------------------------------- [ 2021-12-24T14:27:58+08:00 ] 117.132.198.144 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003583s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.058080s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001370s ] --------------------------------------------------------------- [ 2021-12-24T14:28:06+08:00 ] 117.132.198.144 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211224&time=142701&v1=-01.295&v2=+00.017&v3=-01.157&v4=-00.774&v5=05.9&t=-02.4&h=73.4&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.164&a2=01.311&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002197s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025351s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000794s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211224',`time`='142701',`v1`=-1.295,`v2`=0.017,`v3`=-1.157,`v4`=-0.774,`v5`=5.9,`t`=-2.4,`h`=73.4,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.164,`a2`=1.311,`update_time`=1640327286 WHERE `imei` = '868922055684076' [ RunTime:0.000866s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017085s ] [ 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' , '211224' , '142701' , -1.295 , 0.017 , -1.157 , -0.774 , 5.9 , -2.4 , 73.4 , '460044618415249' , -0 , 0.164 , 1.311 , 1640327286 , 1640327286) [ RunTime:0.000744s ] --------------------------------------------------------------- [ 2021-12-24T15:04:56+08:00 ] 39.144.4.112 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003475s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031383s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001281s ] --------------------------------------------------------------- [ 2021-12-24T15:05:05+08:00 ] 39.144.4.112 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211224&time=150401&v1=-01.207&v2=+01.492&v3=-01.406&v4=+00.028&v5=06.0&t=-02.2&h=86.3&rssi=+227&imsi=460044618415257&v6=-00.000&a1=00.088&a2=11.194&a3=00.283&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002863s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023973s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000825s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211224',`time`='150401',`v1`=-1.207,`v2`=1.492,`v3`=-1.406,`v4`=0.028,`v5`=6,`t`=-2.2,`h`=86.3,`rssi`=227,`imsi`='460044618415257',`v6`=-0,`a1`=0.088,`a2`=11.194,`update_time`=1640329505 WHERE `imei` = '868922055681221' [ RunTime:0.000875s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019058s ] [ 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' , '211224' , '150401' , -1.207 , 1.492 , -1.406 , 0.028 , 6 , -2.2 , 86.3 , '460044618415257' , -0 , 0.088 , 11.194 , 1640329505 , 1640329505) [ RunTime:0.000819s ] --------------------------------------------------------------- [ 2021-12-24T15:33:21+08:00 ] 123.234.86.34 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004667s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.050047s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.001799s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.026554s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001726s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002850s ] --------------------------------------------------------------- [ 2021-12-24T15:33:29+08:00 ] 123.234.86.34 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004533s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.039804s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.001219s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.049919s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.002591s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002513s ] --------------------------------------------------------------- [ 2021-12-24T16:27:57+08:00 ] 221.178.127.69 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003327s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029369s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000830s ] --------------------------------------------------------------- [ 2021-12-24T16:28:05+08:00 ] 221.178.127.69 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211224&time=162701&v1=-01.293&v2=+00.018&v3=-01.157&v4=-00.774&v5=05.9&t=-04.0&h=73.7&rssi=+230&imsi=460044618415249&v6=-00.000&a1=00.162&a2=01.310&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002002s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023022s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000869s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211224',`time`='162701',`v1`=-1.293,`v2`=0.018,`v3`=-1.157,`v4`=-0.774,`v5`=5.9,`t`=-4,`h`=73.7,`rssi`=230,`imsi`='460044618415249',`v6`=-0,`a1`=0.162,`a2`=1.31,`update_time`=1640334485 WHERE `imei` = '868922055684076' [ RunTime:0.000772s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017632s ] [ 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' , '211224' , '162701' , -1.293 , 0.018 , -1.157 , -0.774 , 5.9 , -4 , 73.7 , '460044618415249' , -0 , 0.162 , 1.31 , 1640334485 , 1640334485) [ RunTime:0.000747s ] --------------------------------------------------------------- [ 2021-12-24T18:27:57+08:00 ] 39.144.13.148 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003133s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.038504s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000838s ] --------------------------------------------------------------- [ 2021-12-24T18:28:06+08:00 ] 39.144.13.148 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211224&time=182701&v1=-01.295&v2=+00.014&v3=-01.157&v4=-00.774&v5=05.9&t=-05.8&h=73.9&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.166&a2=01.312&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002226s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025388s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001405s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211224',`time`='182701',`v1`=-1.295,`v2`=0.014,`v3`=-1.157,`v4`=-0.774,`v5`=5.9,`t`=-5.8,`h`=73.9,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.166,`a2`=1.312,`update_time`=1640341686 WHERE `imei` = '868922055684076' [ RunTime:0.000802s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018296s ] [ 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' , '211224' , '182701' , -1.295 , 0.014 , -1.157 , -0.774 , 5.9 , -5.8 , 73.9 , '460044618415249' , -0 , 0.166 , 1.312 , 1640341686 , 1640341686) [ RunTime:0.000778s ] --------------------------------------------------------------- [ 2021-12-24T20:27:58+08:00 ] 117.132.194.13 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003315s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027982s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000781s ] --------------------------------------------------------------- [ 2021-12-24T20:28:06+08:00 ] 117.132.194.13 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211224&time=202701&v1=-01.297&v2=+00.014&v3=-01.156&v4=-00.773&v5=05.9&t=-06.5&h=73.9&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.170&a2=01.315&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003524s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.036987s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001108s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211224',`time`='202701',`v1`=-1.297,`v2`=0.014,`v3`=-1.156,`v4`=-0.773,`v5`=5.9,`t`=-6.5,`h`=73.9,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.17,`a2`=1.315,`update_time`=1640348886 WHERE `imei` = '868922055684076' [ RunTime:0.001222s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.027326s ] [ 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' , '211224' , '202701' , -1.297 , 0.014 , -1.156 , -0.773 , 5.9 , -6.5 , 73.9 , '460044618415249' , -0 , 0.17 , 1.315 , 1640348886 , 1640348886) [ RunTime:0.001147s ] --------------------------------------------------------------- [ 2021-12-24T21:04:57+08:00 ] 117.132.195.23 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003488s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033447s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000933s ] --------------------------------------------------------------- [ 2021-12-24T21:05:06+08:00 ] 117.132.195.23 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211224&time=210401&v1=-00.473&v2=+01.043&v3=-00.728&v4=+00.028&v5=06.0&t=-07.0&h=86.2&rssi=+225&imsi=460044618415257&v6=-00.000&a1=00.026&a2=00.690&a3=00.012&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003504s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031818s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001096s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211224',`time`='210401',`v1`=-0.473,`v2`=1.043,`v3`=-0.728,`v4`=0.028,`v5`=6,`t`=-7,`h`=86.2,`rssi`=225,`imsi`='460044618415257',`v6`=-0,`a1`=0.026,`a2`=0.69,`update_time`=1640351106 WHERE `imei` = '868922055681221' [ RunTime:0.001068s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020770s ] [ 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' , '211224' , '210401' , -0.473 , 1.043 , -0.728 , 0.028 , 6 , -7 , 86.2 , '460044618415257' , -0 , 0.026 , 0.69 , 1640351106 , 1640351106) [ RunTime:0.001014s ] --------------------------------------------------------------- [ 2021-12-24T22:27:58+08:00 ] 39.144.16.40 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.006239s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.087840s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001361s ] --------------------------------------------------------------- [ 2021-12-24T22:28:08+08:00 ] 39.144.16.40 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211224&time=222701&v1=-01.295&v2=+00.013&v3=-01.157&v4=-00.773&v5=05.9&t=-07.2&h=73.8&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.166&a2=01.313&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002340s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023708s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000797s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211224',`time`='222701',`v1`=-1.295,`v2`=0.013,`v3`=-1.157,`v4`=-0.773,`v5`=5.9,`t`=-7.2,`h`=73.8,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.166,`a2`=1.313,`update_time`=1640356088 WHERE `imei` = '868922055684076' [ RunTime:0.001085s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019208s ] [ 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' , '211224' , '222701' , -1.295 , 0.013 , -1.157 , -0.773 , 5.9 , -7.2 , 73.8 , '460044618415249' , -0 , 0.166 , 1.313 , 1640356088 , 1640356088) [ RunTime:0.000738s ]