--------------------------------------------------------------- [ 2022-09-13T10:24:19+08:00 ] 39.144.7.122 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.009702s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000632s ] --------------------------------------------------------------- [ 2022-09-13T10:24:20+08:00 ] 39.144.7.122 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1663035859&v1=0.008639&v2=0.027224&v3=0.008308&v4=0.009421&v5=12.240000&t=30.349125&h=71.674919&rssi=99&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001369s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008591s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000587s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1663035859,`v1`=0.008639,`v2`=0.027224,`v3`=0.008308,`v4`=0.009421,`v5`=12.24,`t`=30.349125,`h`=71.674919,`rssi`=99,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1663035860 WHERE `imei` = '868922055677740' [ RunTime:0.000521s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009436s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1663035859 , 0.008639 , 0.027224 , 0.008308 , 0.009421 , 12.24 , 30.349125 , 71.674919 , 99 , '89860426102071188504' , '460044618415254' , -0 , 1663035860) [ RunTime:0.000558s ] --------------------------------------------------------------- [ 2022-09-13T10:24:37+08:00 ] 223.80.200.194 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001392s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012183s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'xinghuo220kv' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.001233s ] --------------------------------------------------------------- [ 2022-09-13T10:24:38+08:00 ] 223.80.200.194 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001660s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009366s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000725s ] --------------------------------------------------------------- [ 2022-09-13T10:24:48+08:00 ] 223.80.200.194 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001442s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009410s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000457s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000615s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000512s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009981s ] [ 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.001807s ] [ 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.000435s ] --------------------------------------------------------------- [ 2022-09-13T10:25:00+08:00 ] 223.80.200.194 GET /home/data/index.html?keyword=868922055684076&start_date=2022-07-01&end_date=2022-09-13 [ sql ] [ DB ] CONNECT:[ UseTime:0.001423s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010811s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' AND `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000719s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000424s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000467s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000541s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010387s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1656604800 AND `update_time` <= 1662998400 ) LIMIT 1 [ RunTime:0.012763s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1656604800 AND `update_time` <= 1662998400 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.008807s ] --------------------------------------------------------------- [ 2022-09-13T10:25:26+08:00 ] 223.80.200.194 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001773s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010135s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000622s ] --------------------------------------------------------------- [ 2022-09-13T10:25:28+08:00 ] 223.80.200.194 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001411s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009577s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000562s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000668s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009535s ] [ 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.000597s ] [ 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.000400s ] --------------------------------------------------------------- [ 2022-09-13T14:04:50+08:00 ] 39.144.14.18 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002303s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010593s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000858s ] --------------------------------------------------------------- [ 2022-09-13T14:04:59+08:00 ] 39.144.14.18 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=220913&time=140401&v1=-01.292&v2=+00.018&v3=-01.141&v4=-00.607&v5=06.2&t=+30.4&h=77.9&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.173&a2=01.309&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001512s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009248s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='220913',`time`='140401',`v1`=-1.292,`v2`=0.018,`v3`=-1.141,`v4`=-0.607,`v5`=6.2,`t`=30.4,`h`=77.9,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.173,`a2`=1.309,`update_time`=1663049099 WHERE `imei` = '868922055684076' [ RunTime:0.000560s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011744s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '220913' , '140401' , -1.292 , 0.018 , -1.141 , -0.607 , 6.2 , 30.4 , 77.9 , 228 , '460044618415249' , -0 , 0.173 , 1.309 , 1663049099 , 1663049099) [ RunTime:0.000708s ] --------------------------------------------------------------- [ 2022-09-13T19:44:15+08:00 ] 221.178.125.15 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002154s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010698s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000651s ] --------------------------------------------------------------- [ 2022-09-13T19:44:17+08:00 ] 221.178.125.15 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1663069455&v1=0.026639&v2=0.039950&v3=0.023900&v4=-0.003522&v5=6.840000&t=21.640474&h=64.053101&rssi=20&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001476s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010027s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000651s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1663069455,`v1`=0.026639,`v2`=0.03995,`v3`=0.0239,`v4`=-0.003522,`v5`=6.84,`t`=21.640474,`h`=64.053101,`rssi`=20,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1663069457 WHERE `imei` = '868922055644211' [ RunTime:0.000652s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011664s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1663069455 , 0.026639 , 0.03995 , 0.0239 , -0.003522 , 6.84 , 21.640474 , 64.053101 , 20 , '89860426102071188505' , '460044618415255' , -0 , 1663069457) [ RunTime:0.000832s ] --------------------------------------------------------------- [ 2022-09-13T22:24:38+08:00 ] 117.132.191.66 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002037s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010085s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000620s ] --------------------------------------------------------------- [ 2022-09-13T22:24:39+08:00 ] 117.132.191.66 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1663079078&v1=0.008338&v2=0.016689&v3=0.008067&v4=0.008880&v5=12.420000&t=27.485529&h=71.056938&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001592s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008172s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000602s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1663079078,`v1`=0.008338,`v2`=0.016689,`v3`=0.008067,`v4`=0.00888,`v5`=12.42,`t`=27.485529,`h`=71.056938,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1663079079 WHERE `imei` = '868922055677740' [ RunTime:0.000537s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012645s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1663079078 , 0.008338 , 0.016689 , 0.008067 , 0.00888 , 12.42 , 27.485529 , 71.056938 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1663079079) [ RunTime:0.000611s ]