--------------------------------------------------------------- [ 2022-09-16T05:20:18+08:00 ] 117.132.192.146 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002175s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009662s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2022-09-16T05:20:19+08:00 ] 117.132.192.146 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1663276818&v1=0.018813&v2=0.013664&v3=0.016856&v4=-0.004666&v5=12.420000&t=23.849844&h=64.404053&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001410s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010060s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000609s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1663276818,`v1`=0.018813,`v2`=0.013664,`v3`=0.016856,`v4`=-0.004666,`v5`=12.42,`t`=23.849844,`h`=64.404053,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1663276819 WHERE `imei` = '868922055683920' [ RunTime:0.000572s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010548s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1663276818 , 0.018813 , 0.013664 , 0.016856 , -0.004666 , 12.42 , 23.849844 , 64.404053 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1663276819) [ RunTime:0.000562s ] --------------------------------------------------------------- [ 2022-09-16T10:26:21+08:00 ] 117.132.196.76 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002490s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012214s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000662s ] --------------------------------------------------------------- [ 2022-09-16T10:26:23+08:00 ] 117.132.196.76 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1663295181&v1=0.009241&v2=0.064984&v3=0.008308&v4=0.011769&v5=12.240000&t=29.169367&h=71.911430&rssi=99&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001951s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009212s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000695s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1663295181,`v1`=0.009241,`v2`=0.064984,`v3`=0.008308,`v4`=0.011769,`v5`=12.24,`t`=29.169367,`h`=71.91143,`rssi`=99,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1663295183 WHERE `imei` = '868922055677740' [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008954s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1663295181 , 0.009241 , 0.064984 , 0.008308 , 0.011769 , 12.24 , 29.169367 , 71.91143 , 99 , '89860426102071188504' , '460044618415254' , -0 , 1663295183) [ RunTime:0.000579s ] --------------------------------------------------------------- [ 2022-09-16T10:33:39+08:00 ] 112.224.164.182 GET / [ sql ] [ DB ] CONNECT:[ UseTime:0.002111s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009310s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user1' LIMIT 1 [ RunTime:0.000521s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000765s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000595s ] --------------------------------------------------------------- [ 2022-09-16T14:02:50+08:00 ] 39.144.12.65 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002471s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009324s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000621s ] --------------------------------------------------------------- [ 2022-09-16T14:02:58+08:00 ] 39.144.12.65 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=220916&time=140201&v1=-00.927&v2=+00.007&v3=-00.850&v4=-00.268&v5=06.2&t=+24.5&h=78.4&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.112&a2=00.980&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001722s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008241s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000664s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='220916',`time`='140201',`v1`=-0.927,`v2`=0.007,`v3`=-0.85,`v4`=-0.268,`v5`=6.2,`t`=24.5,`h`=78.4,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.112,`a2`=0.98,`update_time`=1663308178 WHERE `imei` = '868922055684076' [ RunTime:0.000648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010535s ] [ 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' , '220916' , '140201' , -0.927 , 0.007 , -0.85 , -0.268 , 6.2 , 24.5 , 78.4 , 228 , '460044618415249' , -0 , 0.112 , 0.98 , 1663308178 , 1663308178) [ RunTime:0.000809s ] --------------------------------------------------------------- [ 2022-09-16T17:20:19+08:00 ] 117.132.195.96 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002774s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009799s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000663s ] --------------------------------------------------------------- [ 2022-09-16T17:20:20+08:00 ] 117.132.195.96 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1663320019&v1=0.019174&v2=0.028580&v3=0.016856&v4=-0.004666&v5=12.600000&t=25.640936&h=65.029663&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001544s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010748s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000583s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1663320019,`v1`=0.019174,`v2`=0.02858,`v3`=0.016856,`v4`=-0.004666,`v5`=12.6,`t`=25.640936,`h`=65.029663,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1663320020 WHERE `imei` = '868922055683920' [ RunTime:0.000541s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010012s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1663320019 , 0.019174 , 0.02858 , 0.016856 , -0.004666 , 12.6 , 25.640936 , 65.029663 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1663320020) [ RunTime:0.000570s ] --------------------------------------------------------------- [ 2022-09-16T19:44:13+08:00 ] 117.132.195.199 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002093s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008311s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000671s ] --------------------------------------------------------------- [ 2022-09-16T19:44:14+08:00 ] 117.132.195.199 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1663328653&v1=0.026338&v2=0.028685&v3=0.022003&v4=-0.003100&v5=6.660000&t=19.506180&h=63.610596&rssi=20&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001372s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008658s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000636s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1663328653,`v1`=0.026338,`v2`=0.028685,`v3`=0.022003,`v4`=-0.0031,`v5`=6.66,`t`=19.50618,`h`=63.610596,`rssi`=20,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1663328654 WHERE `imei` = '868922055644211' [ RunTime:0.000521s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010255s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1663328653 , 0.026338 , 0.028685 , 0.022003 , -0.0031 , 6.66 , 19.50618 , 63.610596 , 20 , '89860426102071188505' , '460044618415255' , -0 , 1663328654) [ RunTime:0.000588s ] --------------------------------------------------------------- [ 2022-09-16T22:26:41+08:00 ] 39.144.13.142 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002414s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010401s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000651s ] --------------------------------------------------------------- [ 2022-09-16T22:26:43+08:00 ] 39.144.13.142 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1663338401&v1=0.008398&v2=0.047877&v3=0.007826&v4=0.008940&v5=12.240000&t=24.139305&h=71.140862&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001441s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010878s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000694s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1663338401,`v1`=0.008398,`v2`=0.047877,`v3`=0.007826,`v4`=0.00894,`v5`=12.24,`t`=24.139305,`h`=71.140862,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1663338403 WHERE `imei` = '868922055677740' [ RunTime:0.000606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010920s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1663338401 , 0.008398 , 0.047877 , 0.007826 , 0.00894 , 12.24 , 24.139305 , 71.140862 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1663338403) [ RunTime:0.000593s ]