学了一段时间的hadoop了,一直没有什么正经练手的机会,今天老师给了一个课堂测试来进行练手,正好试一下。
项目已上传至github:https://github.com/yandashan/MapReduce_Count1
Result文件数据说明:
Ip:106.39.41.166,(城市)
Date:10/Nov/2016:00:01:02 +0800,(日期)
Day:10,(天数)
Traffic: 54 ,(流量)
Type: video,(类型:视频video或文章article)
Id: 8701(视频或者文章的id)
测试要求:
1、 数据清洗:按照进行数据清洗,并将清洗后的数据导入hive数据库中。
两阶段数据清洗:
(1)第一阶段:把需要的信息从原始日志中提取出来
ip: 199.30.25.88
time: 10/Nov/2016:00:01:03 +0800
traffic: 62
文章: article/11325
视频: video/3235
(2)第二阶段:根据提取出来的信息做精细化操作
ip--->城市 city(IP)
date--> time:2016-11-10 00:01:03
day: 10
traffic:62
type:article/video
id:11325
(3)hive数据库表结构:
create table data( ip string, time string , day string, traffic bigint,
type string, id string )
2、数据处理:
·统计最受欢迎的视频/文章的Top10访问次数 (video/article)
·按照地市统计最受欢迎的Top10课程 (ip)
·按照流量统计最受欢迎的Top10课程 (traffic)
3、数据可视化:将统计结果倒入MySql数据库中,通过图形化展示的方式展现出来。
数据并没有上传到github,所以在这里展示一下。
基本数据类型如下:
1 106.39.41.166,10/Nov/2016:00:01:02 +0800,10,54 ,video,8701 2 113.140.11.123,10/Nov/2016:00:01:02 +0800,10,54 ,video,5915 3 125.122.216.102,10/Nov/2016:00:01:02 +0800,10,54 ,video,9819 4 116.231.219.242,10/Nov/2016:00:01:02 +0800,10,54 ,video,6335 5 61.136.143.62,10/Nov/2016:00:01:02 +0800,10,54 ,video,7629 6 39.186.247.142,10/Nov/2016:00:01:02 +0800,10,2957 ,video,3237 7 59.42.206.247,10/Nov/2016:00:01:02 +0800,10,54 ,video,7053 8 39.186.247.142,10/Nov/2016:00:01:02 +0800,10,66 ,video,3237 9 61.135.172.68,10/Nov/2016:00:01:02 +0800,10,67 ,video,3510 10 45.115.145.45,10/Nov/2016:00:01:02 +0800,10,67 ,video,13265 11 61.149.133.159,10/Nov/2016:00:01:02 +0800,10,54 ,video,13182 12 180.160.212.7,10/Nov/2016:00:01:02 +0800,10,54 ,video,2665 13 125.90.48.103,10/Nov/2016:00:01:02 +0800,10,54 ,video,7311 14 106.187.95.195,10/Nov/2016:00:01:02 +0800,10,54 ,video,5685 15 39.186.247.142,10/Nov/2016:00:01:02 +0800,10,317 ,video,3237 16 220.191.6.44,10/Nov/2016:00:01:02 +0800,10,72 ,video,1101 17 39.186.247.142,10/Nov/2016:00:01:02 +0800,10,4860 ,video,3237 18 61.142.10.231,10/Nov/2016:00:01:02 +0800,10,67 ,video,12551 19 27.17.35.94,10/Nov/2016:00:01:02 +0800,10,54 ,video,1412 20 120.198.231.154,10/Nov/2016:00:01:03 +0800,10,54 ,video,9817 21 113.93.90.94,10/Nov/2016:00:01:03 +0800,10,54 ,video,7475 22 114.249.93.42,10/Nov/2016:00:01:03 +0800,10,67 ,video,3221 23 171.8.152.203,10/Nov/2016:00:01:03 +0800,10,54 ,video,5914 24 199.30.25.88,10/Nov/2016:00:01:03 +0800,10,271 ,article,11325 25 199.30.25.88,10/Nov/2016:00:01:03 +0800,10,62 ,article,11325 26 39.186.247.142,10/Nov/2016:00:01:03 +0800,10,2311 ,video,3237 27 222.168.40.31,10/Nov/2016:00:01:03 +0800,10,54 ,video,2452 28 39.186.247.142,10/Nov/2016:00:01:03 +0800,10,307 ,video,3237 29 58.241.76.18,10/Nov/2016:00:01:03 +0800,10,2957 ,video,3235 30 49.81.162.183,10/Nov/2016:00:01:03 +0800,10,141 ,video,1816 31 125.94.93.221,10/Nov/2016:00:01:03 +0800,10,54 ,video,4441 32 101.200.101.201,10/Nov/2016:00:01:03 +0800,10,4468 ,article,4779 33 39.186.247.142,10/Nov/2016:00:01:03 +0800,10,951 ,video,3237 34 101.200.101.21,10/Nov/2016:00:01:03 +0800,10,524288 ,video,10506 35 58.241.76.18,10/Nov/2016:00:01:03 +0800,10,66 ,video,3235 36 101.200.101.21,10/Nov/2016:00:01:03 +0800,10,524288 ,video,10506 37 67.82.64.254,10/Nov/2016:00:01:03 +0800,10,54 ,video,2875 38 39.186.247.142,10/Nov/2016:00:01:03 +0800,10,72 ,video,3237 39 117.100.106.26,10/Nov/2016:00:01:03 +0800,10,54 ,video,4908 40 113.91.162.210,10/Nov/2016:00:01:03 +0800,10,54 ,video,10506 41 58.241.76.18,10/Nov/2016:00:01:03 +0800,10,951 ,video,3235 42 58.241.76.18,10/Nov/2016:00:01:03 +0800,10,5234 ,video,3235 43 139.211.44.77,10/Nov/2016:00:01:03 +0800,10,54 ,video,4848 44 39.186.247.142,10/Nov/2016:00:01:03 +0800,10,7227 ,video,3237 45 111.172.46.191,10/Nov/2016:00:01:04 +0800,10,67 ,video,3069 46 60.21.206.184,10/Nov/2016:00:01:04 +0800,10,67 ,video,6228 47 39.186.247.142,10/Nov/2016:00:01:04 +0800,10,4496 ,video,3237 48 39.186.247.142,10/Nov/2016:00:01:04 +0800,10,317 ,video,3237 49 112.64.61.203,10/Nov/2016:00:01:04 +0800,10,54 ,video,12532 50 222.171.107.65,10/Nov/2016:00:01:04 +0800,10,54 ,video,6837 51 183.60.162.108,10/Nov/2016:00:01:04 +0800,10,54 ,video,13168 52 171.214.155.3,10/Nov/2016:00:01:04 +0800,10,67 ,video,7558 53 39.186.247.142,10/Nov/2016:00:01:04 +0800,10,1092 ,video,3237 54 14.219.24.67,10/Nov/2016:00:01:04 +0800,10,54 ,video,773 55 115.195.60.166,10/Nov/2016:00:01:04 +0800,10,54 ,video,2769 56 175.20.94.66,10/Nov/2016:00:01:04 +0800,10,54 ,video,12299 57 101.81.42.203,10/Nov/2016:00:01:04 +0800,10,54 ,video,4017 58 60.191.47.90,10/Nov/2016:00:01:04 +0800,10,54 ,video,3664 59 114.249.202.36,10/Nov/2016:00:01:04 +0800,10,54 ,video,13330 60 120.198.231.150,10/Nov/2016:00:01:04 +0800,10,54 ,video,774 61 58.241.76.18,10/Nov/2016:00:01:04 +0800,10,95 ,video,3235 62 115.193.172.253,10/Nov/2016:00:01:04 +0800,10,67 ,video,2858 63 183.128.164.83,10/Nov/2016:00:01:04 +0800,10,67 ,video,12299 64 118.250.42.145,10/Nov/2016:00:01:04 +0800,10,67 ,video,11307 65 175.10.104.158,10/Nov/2016:00:01:04 +0800,10,54 ,video,3217 66 110.53.175.199,10/Nov/2016:00:01:04 +0800,10,54 ,video,8469 67 106.37.127.231,10/Nov/2016:00:01:04 +0800,10,2195 ,video,8199 68 171.216.125.79,10/Nov/2016:00:01:04 +0800,10,54 ,video,5219 69 115.193.172.253,10/Nov/2016:00:01:04 +0800,10,6589 ,video,2858 70 106.37.127.231,10/Nov/2016:00:01:04 +0800,10,349 ,video,8199 71 182.100.18.242,10/Nov/2016:00:01:05 +0800,10,54 ,video,8995 72 125.122.198.123,10/Nov/2016:00:01:05 +0800,10,54 ,video,10897 73 199.30.25.88,10/Nov/2016:00:01:05 +0800,10,5994 ,article,11325 74 115.193.172.253,10/Nov/2016:00:01:05 +0800,10,2961 ,video,3078 75 119.122.183.89,10/Nov/2016:00:01:05 +0800,10,7226 ,video,3244 76 140.207.97.98,10/Nov/2016:00:01:05 +0800,10,68 ,video,10936 77 183.128.164.83,10/Nov/2016:00:01:05 +0800,10,67 ,video,953 78 106.37.127.231,10/Nov/2016:00:01:05 +0800,10,1355 ,video,8199 79 116.23.248.47,10/Nov/2016:00:01:05 +0800,10,54 ,video,1034 80 111.112.84.51,10/Nov/2016:00:01:05 +0800,10,54 ,video,6843 81 115.193.172.253,10/Nov/2016:00:01:05 +0800,10,362 ,video,3078 82 106.37.127.231,10/Nov/2016:00:01:05 +0800,10,72 ,video,8199 83 117.135.159.4,10/Nov/2016:00:01:05 +0800,10,68 ,video,353 84 117.173.0.113,10/Nov/2016:00:01:05 +0800,10,2956 ,video,8135 85 211.162.33.107,10/Nov/2016:00:01:05 +0800,10,54 ,video,9815 86 106.37.127.231,10/Nov/2016:00:01:05 +0800,10,74 ,video,8199 87 116.23.155.253,10/Nov/2016:00:01:05 +0800,10,54 ,video,9661 88 106.37.127.231,10/Nov/2016:00:01:05 +0800,10,66 ,video,8199 89 115.193.172.253,10/Nov/2016:00:01:05 +0800,10,945 ,video,3078 90 112.65.57.88,10/Nov/2016:00:01:05 +0800,10,54 ,video,9593 91 117.173.0.113,10/Nov/2016:00:01:05 +0800,10,348 ,video,8135 92 58.20.14.170,10/Nov/2016:00:01:05 +0800,10,67 ,video,5682 93 113.139.190.95,10/Nov/2016:00:01:05 +0800,10,67 ,video,9832 94 119.122.183.89,10/Nov/2016:00:01:05 +0800,10,7226 ,video,3244 95 125.122.2.73,10/Nov/2016:00:01:05 +0800,10,54 ,video,243 96 106.37.127.231,10/Nov/2016:00:01:05 +0800,10,306 ,video,8199 97 117.173.0.113,10/Nov/2016:00:01:05 +0800,10,66 ,video,8135 98 115.193.172.253,10/Nov/2016:00:01:05 +0800,10,2345 ,video,3078 99 14.145.74.175,10/Nov/2016:00:01:05 +0800,10,72 ,video,678 100 115.193.172.253,10/Nov/2016:00:01:05 +0800,10,221 ,video,3078 101 115.193.172.253,10/Nov/2016:00:01:05 +0800,10,4042 ,video,3078 102 106.37.127.231,10/Nov/2016:00:01:05 +0800,10,3427 ,video,8199 103 122.206.190.75,10/Nov/2016:00:01:05 +0800,10,54 ,video,7707 104 115.193.172.253,10/Nov/2016:00:01:05 +0800,10,66 ,video,3078 105 110.65.101.188,10/Nov/2016:00:01:05 +0800,10,54 ,video,11786 106 58.20.14.170,10/Nov/2016:00:01:05 +0800,10,6417 ,video,5682 107 1.194.187.2,10/Nov/2016:00:01:05 +0800,10,54 ,video,2212 108 119.124.164.57,10/Nov/2016:00:01:05 +0800,10,54 ,video,4320 109 106.37.127.231,10/Nov/2016:00:01:05 +0800,10,3280 ,video,8199 110 58.20.14.170,10/Nov/2016:00:01:05 +0800,10,2957 ,video,5683 111 223.72.89.88,10/Nov/2016:00:01:05 +0800,10,67 ,video,2139 112 117.173.0.113,10/Nov/2016:00:01:05 +0800,10,1161 ,video,8135 113 115.193.172.253,10/Nov/2016:00:01:06 +0800,10,1801 ,video,3078 114 122.234.60.39,10/Nov/2016:00:01:06 +0800,10,6398 ,video,8837 115 117.173.0.113,10/Nov/2016:00:01:06 +0800,10,4882 ,video,8135 116 115.193.172.253,10/Nov/2016:00:01:06 +0800,10,362 ,video,3078 117 106.37.127.231,10/Nov/2016:00:01:06 +0800,10,302 ,video,8199 118 117.173.0.113,10/Nov/2016:00:01:06 +0800,10,16776 ,video,8135 119 115.193.172.253,10/Nov/2016:00:01:06 +0800,10,72 ,video,3078 120 14.154.180.16,10/Nov/2016:00:01:06 +0800,10,54 ,video,9886 121 49.4.156.97,10/Nov/2016:00:01:06 +0800,10,54 ,video,5914 122 101.81.50.177,10/Nov/2016:00:01:06 +0800,10,54 ,video,828 123 223.104.25.65,10/Nov/2016:00:01:06 +0800,10,54 ,video,9101 124 58.20.14.170,10/Nov/2016:00:01:06 +0800,10,347 ,video,5683 125 117.173.0.113,10/Nov/2016:00:01:06 +0800,10,305 ,video,8135 126 116.22.196.231,10/Nov/2016:00:01:06 +0800,10,54 ,video,6711 127 58.20.14.170,10/Nov/2016:00:01:06 +0800,10,66 ,video,5683 128 101.200.101.13,10/Nov/2016:00:01:06 +0800,10,524288 ,video,11938 129 106.37.127.231,10/Nov/2016:00:01:06 +0800,10,6412 ,video,8199 130 115.193.172.253,10/Nov/2016:00:01:06 +0800,10,395 ,video,3078 131 101.200.101.9,10/Nov/2016:00:01:06 +0800,10,524288 ,video,6139 132 58.20.14.170,10/Nov/2016:00:01:06 +0800,10,1201 ,video,5683 133 120.27.173.217,10/Nov/2016:00:01:06 +0800,10,4468 ,article,1167 134 220.191.6.44,10/Nov/2016:00:01:06 +0800,10,6323 ,video,1101 135 117.173.0.113,10/Nov/2016:00:01:06 +0800,10,72 ,video,8135 136 101.200.101.13,10/Nov/2016:00:01:06 +0800,10,524288 ,video,11938 137 112.5.237.224,10/Nov/2016:00:01:06 +0800,10,54 ,video,12478 138 106.37.127.231,10/Nov/2016:00:01:06 +0800,10,72 ,video,8199 139 115.193.172.253,10/Nov/2016:00:01:06 +0800,10,4496 ,video,3078 140 117.164.191.130,10/Nov/2016:00:01:06 +0800,10,54 ,video,6556 141 49.81.162.183,10/Nov/2016:00:01:06 +0800,10,67 ,video,1816 142 115.183.25.238,10/Nov/2016:00:01:06 +0800,10,54 ,video,5139 143 124.64.76.206,10/Nov/2016:00:01:06 +0800,10,54 ,video,3475 144 120.198.231.152,10/Nov/2016:00:01:06 +0800,10,54 ,video,8652 145 180.102.115.191,10/Nov/2016:00:01:06 +0800,10,54 ,video,10077 146 117.173.0.113,10/Nov/2016:00:01:06 +0800,10,2614 ,video,8135 147 223.93.140.242,10/Nov/2016:00:01:07 +0800,10,67 ,video,2147 148 115.193.172.253,10/Nov/2016:00:01:07 +0800,10,301 ,video,3078 149 113.105.128.252,10/Nov/2016:00:01:07 +0800,10,54 ,video,1671 150 117.173.0.113,10/Nov/2016:00:01:07 +0800,10,6784 ,video,8135 151 42.243.125.117,10/Nov/2016:00:01:07 +0800,10,54 ,video,8864 152 117.173.0.113,10/Nov/2016:00:01:07 +0800,10,572 ,video,8135 153 106.37.127.231,10/Nov/2016:00:01:07 +0800,10,6412 ,video,8199 154 112.87.108.52,10/Nov/2016:00:01:07 +0800,10,54 ,video,8671 155 120.85.202.68,10/Nov/2016:00:01:07 +0800,10,54 ,video,3096 156 115.193.172.253,10/Nov/2016:00:01:07 +0800,10,6589 ,video,3078 157 117.173.0.113,10/Nov/2016:00:01:07 +0800,10,72 ,video,8135 158 115.193.172.253,10/Nov/2016:00:01:07 +0800,10,72 ,video,3078 159 218.75.34.250,10/Nov/2016:00:01:07 +0800,10,54 ,video,9103 160 115.193.172.253,10/Nov/2016:00:01:07 +0800,10,6589 ,video,3078 161 58.20.14.170,10/Nov/2016:00:01:07 +0800,10,5485 ,video,5683 162 175.9.181.138,10/Nov/2016:00:01:07 +0800,10,67 ,video,2877 163 58.20.14.170,10/Nov/2016:00:01:07 +0800,10,72 ,video,5683 164 58.20.14.170,10/Nov/2016:00:01:08 +0800,10,3561 ,video,5683 165 114.42.37.247,10/Nov/2016:00:01:08 +0800,10,54 ,video,6492 166 14.145.74.175,10/Nov/2016:00:01:08 +0800,10,72 ,video,678 167 36.46.203.138,10/Nov/2016:00:01:08 +0800,10,54 ,video,2633 168 58.20.14.170,10/Nov/2016:00:01:08 +0800,10,2230 ,video,5683 169 101.200.101.207,10/Nov/2016:00:01:08 +0800,10,4468 ,article,11325 170 58.20.14.170,10/Nov/2016:00:01:08 +0800,10,2195 ,video,5683 171 58.20.14.170,10/Nov/2016:00:01:08 +0800,10,3388 ,video,5683 172 124.225.62.61,10/Nov/2016:00:01:08 +0800,10,54 ,video,9704 173 117.173.0.113,10/Nov/2016:00:01:08 +0800,10,6784 ,video,8135 174 121.33.168.58,10/Nov/2016:00:01:08 +0800,10,67 ,video,1803 175 58.20.14.170,10/Nov/2016:00:01:08 +0800,10,324 ,video,5683 176 222.70.27.27,10/Nov/2016:00:01:08 +0800,10,67 ,video,4877 177 58.20.14.170,10/Nov/2016:00:01:08 +0800,10,347 ,video,5683 178 58.20.14.170,10/Nov/2016:00:01:08 +0800,10,348 ,video,5683 179 106.37.127.231,10/Nov/2016:00:01:08 +0800,10,72 ,video,8199 180 111.201.78.80,10/Nov/2016:00:01:08 +0800,10,54 ,video,2544 181 119.139.136.103,10/Nov/2016:00:01:08 +0800,10,54 ,video,4831 182 61.51.82.242,10/Nov/2016:00:01:09 +0800,10,67 ,video,8792 183 120.85.77.238,10/Nov/2016:00:01:09 +0800,10,54 ,video,7624 184 113.200.27.28,10/Nov/2016:00:01:09 +0800,10,54 ,video,2427 185 61.242.42.35,10/Nov/2016:00:01:09 +0800,10,54 ,video,4736 186 211.97.105.190,10/Nov/2016:00:01:09 +0800,10,141 ,video,13003 187 49.52.99.46,10/Nov/2016:00:01:09 +0800,10,54 ,video,2168 188 106.120.213.44,10/Nov/2016:00:01:09 +0800,10,54 ,video,7533 189 121.35.180.159,10/Nov/2016:00:01:09 +0800,10,54 ,video,9808 190 119.131.106.128,10/Nov/2016:00:01:09 +0800,10,54 ,video,8378 191 180.170.100.94,10/Nov/2016:00:01:09 +0800,10,67 ,video,1412 192 59.42.128.119,10/Nov/2016:00:01:09 +0800,10,54 ,video,5539 193 218.106.145.12,10/Nov/2016:00:01:09 +0800,10,67 ,video,9447 194 183.166.10.212,10/Nov/2016:00:01:09 +0800,10,54 ,video,5867 195 121.69.41.98,10/Nov/2016:00:01:09 +0800,10,54 ,video,2710 196 211.157.164.39,10/Nov/2016:00:01:09 +0800,10,54 ,video,1667 197 115.198.204.33,10/Nov/2016:00:01:10 +0800,10,54 ,video,2929 198 180.156.241.168,10/Nov/2016:00:01:10 +0800,10,54 ,video,3208 199 39.182.64.209,10/Nov/2016:00:01:10 +0800,10,54 ,video,3221 200 218.76.42.130,10/Nov/2016:00:01:10 +0800,10,54 ,video,11561 201 183.157.162.62,10/Nov/2016:00:01:10 +0800,10,54 ,video,9319 202 218.17.207.61,10/Nov/2016:00:01:10 +0800,10,54 ,video,8711 203 122.233.75.87,10/Nov/2016:00:01:10 +0800,10,54 ,video,5475 204 101.200.101.204,10/Nov/2016:00:01:10 +0800,10,4468 ,article,11325 205 183.39.154.199,10/Nov/2016:00:01:10 +0800,10,141 ,video,13097 206 122.96.31.8,10/Nov/2016:00:01:10 +0800,10,54 ,video,13097 207 182.150.161.68,10/Nov/2016:00:01:10 +0800,10,54 ,video,3725 208 117.174.26.224,10/Nov/2016:00:01:10 +0800,10,54 ,video,4525 209 59.172.176.158,10/Nov/2016:00:01:10 +0800,10,67 ,video,4030 210 221.221.55.197,10/Nov/2016:00:01:11 +0800,10,54 ,video,3734 211 39.186.247.142,10/Nov/2016:00:01:11 +0800,10,72 ,video,3237 212 140.207.223.189,10/Nov/2016:00:01:11 +0800,10,54 ,video,13192 213 120.52.92.2,10/Nov/2016:00:01:11 +0800,10,67 ,video,12342 214 219.73.46.243,10/Nov/2016:00:01:11 +0800,10,54 ,video,4547 215 115.193.172.253,10/Nov/2016:00:01:11 +0800,10,6589 ,video,3078 216 183.39.154.199,10/Nov/2016:00:01:11 +0800,10,67 ,video,13097 217 27.38.115.174,10/Nov/2016:00:01:11 +0800,10,54 ,video,4519 218 183.14.120.94,10/Nov/2016:00:01:11 +0800,10,54 ,video,12344 219 183.63.102.133,10/Nov/2016:00:01:11 +0800,10,54 ,video,5139 220 106.185.43.251,10/Nov/2016:00:01:11 +0800,10,54 ,video,11950 221 27.47.233.232,10/Nov/2016:00:01:11 +0800,10,54 ,video,889 222 110.52.221.73,10/Nov/2016:00:01:11 +0800,10,54 ,video,2212 223 112.64.61.162,10/Nov/2016:00:01:11 +0800,10,54 ,video,2872 224 222.210.3.220,10/Nov/2016:00:01:11 +0800,10,54 ,video,5986 225 121.33.48.151,10/Nov/2016:00:01:11 +0800,10,54 ,video,4932 226 36.110.49.98,10/Nov/2016:00:01:11 +0800,10,54 ,video,4188 227 183.17.254.189,10/Nov/2016:00:01:12 +0800,10,54 ,video,371 228 113.66.21.10,10/Nov/2016:00:01:12 +0800,10,54 ,video,11447 229 119.122.183.89,10/Nov/2016:00:01:12 +0800,10,72 ,video,3244 230 1.84.205.195,10/Nov/2016:00:01:12 +0800,10,54 ,video,1412 231 222.74.205.119,10/Nov/2016:00:01:12 +0800,10,54 ,video,2316 232 122.234.60.39,10/Nov/2016:00:01:12 +0800,10,54 ,video,11549 233 113.204.170.2,10/Nov/2016:00:01:12 +0800,10,67 ,video,2163 234 220.181.38.111,10/Nov/2016:00:01:12 +0800,10,54 ,video,3735 235 218.6.242.42,10/Nov/2016:00:01:12 +0800,10,54 ,video,10694 236 123.117.40.2,10/Nov/2016:00:01:12 +0800,10,54 ,video,13311 237 183.17.235.181,10/Nov/2016:00:01:13 +0800,10,54 ,video,12466 238 118.26.11.9,10/Nov/2016:00:01:13 +0800,10,68 ,video,10688 239 112.192.207.41,10/Nov/2016:00:01:13 +0800,10,54 ,video,12302 240 58.20.14.170,10/Nov/2016:00:01:13 +0800,10,72 ,video,5683 241 125.124.158.86,10/Nov/2016:00:01:13 +0800,10,67 ,video,2863 242 116.3.7.232,10/Nov/2016:00:01:13 +0800,10,54 ,video,9028 243 116.231.194.12,10/Nov/2016:00:01:13 +0800,10,72 ,video,2469 244 139.196.128.78,10/Nov/2016:00:01:13 +0800,10,524288 ,video,9478 245 125.120.150.55,10/Nov/2016:00:01:13 +0800,10,67 ,video,9902 246 122.225.227.162,10/Nov/2016:00:01:13 +0800,10,54 ,video,10683 247 119.131.143.179,10/Nov/2016:00:01:13 +0800,10,141 ,video,2401 248 58.250.245.239,10/Nov/2016:00:01:13 +0800,10,54 ,video,10750 249 117.151.49.48,10/Nov/2016:00:01:13 +0800,10,54 ,video,3399 250 58.20.14.170,10/Nov/2016:00:01:13 +0800,10,6417 ,video,5683 251 112.86.38.76,10/Nov/2016:00:01:13 +0800,10,54 ,video,2926 252 113.140.11.123,10/Nov/2016:00:01:13 +0800,10,54 ,video,1803 253 140.205.253.132,10/Nov/2016:00:01:13 +0800,10,524288 ,video,7557 254 58.243.193.233,10/Nov/2016:00:01:14 +0800,10,54 ,video,6468 255 182.84.104.185,10/Nov/2016:00:01:14 +0800,10,54 ,video,5170 256 113.65.125.190,10/Nov/2016:00:01:14 +0800,10,54 ,video,8602 257 118.207.107.228,10/Nov/2016:00:01:14 +0800,10,67 ,video,4962 258 183.17.254.189,10/Nov/2016:00:01:14 +0800,10,6637 ,video,371 259 223.104.11.225,10/Nov/2016:00:01:14 +0800,10,54 ,video,889 260 183.6.25.202,10/Nov/2016:00:01:14 +0800,10,54 ,video,13044 261 124.78.41.245,10/Nov/2016:00:01:14 +0800,10,54 ,video,13010 262 210.30.193.153,10/Nov/2016:00:01:14 +0800,10,67 ,video,3521 263 218.18.125.103,10/Nov/2016:00:01:14 +0800,10,54 ,video,12344 264 59.63.249.151,10/Nov/2016:00:01:14 +0800,10,54 ,video,633 265 119.225.142.2,10/Nov/2016:00:01:14 +0800,10,54 ,video,4345 266 139.196.128.67,10/Nov/2016:00:01:14 +0800,10,524288 ,video,13109 267 125.94.93.221,10/Nov/2016:00:01:14 +0800,10,72 ,video,4441 268 113.66.254.162,10/Nov/2016:00:01:14 +0800,10,54 ,video,5915 269 120.41.28.17,10/Nov/2016:00:01:14 +0800,10,67 ,video,13277 270 1.192.25.84,10/Nov/2016:00:01:14 +0800,10,54 ,video,5551 271 119.136.147.91,10/Nov/2016:00:01:14 +0800,10,54 ,video,7740 272 113.120.48.150,10/Nov/2016:00:01:14 +0800,10,67 ,video,2869 273 116.236.162.66,10/Nov/2016:00:01:14 +0800,10,54 ,video,8880 274 139.196.128.67,10/Nov/2016:00:01:14 +0800,10,524288 ,video,13109 275 124.200.190.34,10/Nov/2016:00:01:15 +0800,10,54 ,video,9025 276 223.93.140.242,10/Nov/2016:00:01:15 +0800,10,67 ,video,9905 277 36.33.5.19,10/Nov/2016:00:01:15 +0800,10,54 ,video,12504 278 223.20.138.152,10/Nov/2016:00:01:15 +0800,10,54 ,video,1818 279 115.192.189.58,10/Nov/2016:00:01:15 +0800,10,54 ,video,9904 280 124.200.190.34,10/Nov/2016:00:01:15 +0800,10,67 ,video,9022 281 59.47.8.126,10/Nov/2016:00:01:15 +0800,10,54 ,video,4526 282 163.125.235.161,10/Nov/2016:00:01:15 +0800,10,54 ,video,11257 283 60.22.87.125,10/Nov/2016:00:01:15 +0800,10,72 ,video,1336 284 116.231.133.23,10/Nov/2016:00:01:15 +0800,10,67 ,video,11822 285 116.19.167.208,10/Nov/2016:00:01:15 +0800,10,54 ,video,7550 286 124.200.190.34,10/Nov/2016:00:01:15 +0800,10,67 ,video,9025 287 120.198.231.151,10/Nov/2016:00:01:15 +0800,10,54 ,video,2544 288 101.81.225.61,10/Nov/2016:00:01:15 +0800,10,54 ,video,12479 289 60.191.99.129,10/Nov/2016:00:01:15 +0800,10,54 ,video,6000 290 113.119.8.170,10/Nov/2016:00:01:15 +0800,10,54 ,video,11820 291 219.82.203.225,10/Nov/2016:00:01:15 +0800,10,54 ,video,2183 292 183.39.154.199,10/Nov/2016:00:01:15 +0800,10,67 ,video,13097 293 58.213.93.130,10/Nov/2016:00:01:15 +0800,10,67 ,video,775 294 183.39.154.199,10/Nov/2016:00:01:15 +0800,10,6195 ,video,13097 295 116.231.194.12,10/Nov/2016:00:01:15 +0800,10,54 ,video,2469 296 120.198.231.154,10/Nov/2016:00:01:15 +0800,10,54 ,video,902 297 120.193.5.12,10/Nov/2016:00:01:15 +0800,10,54 ,video,11620 298 14.106.225.10,10/Nov/2016:00:01:16 +0800,10,54 ,video,7623 299 106.89.87.107,10/Nov/2016:00:01:16 +0800,10,54 ,video,2523 300 113.71.152.167,10/Nov/2016:00:01:16 +0800,10,54 ,video,2492 301 112.86.205.25,10/Nov/2016:00:01:16 +0800,10,54 ,video,2499 302 49.4.161.46,10/Nov/2016:00:01:16 +0800,10,54 ,video,12396 303 218.88.46.108,10/Nov/2016:00:01:16 +0800,10,54 ,video,12576 304 122.191.204.232,10/Nov/2016:00:01:16 +0800,10,54 ,video,6074 305 183.39.154.199,10/Nov/2016:00:01:16 +0800,10,2959 ,video,13098 306 58.22.61.92,10/Nov/2016:00:01:16 +0800,10,54 ,video,3727 307 183.39.154.199,10/Nov/2016:00:01:16 +0800,10,348 ,video,13098 308 183.63.97.232,10/Nov/2016:00:01:16 +0800,10,54 ,video,7557 309 39.179.202.119,10/Nov/2016:00:01:16 +0800,10,67 ,video,1546 310 14.23.9.50,10/Nov/2016:00:01:16 +0800,10,54 ,video,5118 311 221.221.148.132,10/Nov/2016:00:01:16 +0800,10,1041 ,video,13153 312 128.250.0.113,10/Nov/2016:00:01:16 +0800,10,68 ,video,6584 313 110.179.148.54,10/Nov/2016:00:01:16 +0800,10,54 ,video,11698 314 183.39.154.199,10/Nov/2016:00:01:16 +0800,10,2027 ,video,13098 315 221.221.148.132,10/Nov/2016:00:01:16 +0800,10,3991 ,video,13153 316 58.60.6.23,10/Nov/2016:00:01:16 +0800,10,54 ,video,2257 317 210.30.100.2,10/Nov/2016:00:01:16 +0800,10,68 ,video,11551 318 183.39.154.199,10/Nov/2016:00:01:16 +0800,10,72 ,video,13098 319 111.0.200.141,10/Nov/2016:00:01:16 +0800,10,67 ,video,3400 320 183.228.49.158,10/Nov/2016:00:01:16 +0800,10,54 ,video,9633 321 183.39.154.199,10/Nov/2016:00:01:16 +0800,10,74 ,video,13098 322 221.221.148.132,10/Nov/2016:00:01:16 +0800,10,2700 ,video,13153 323 183.60.175.193,10/Nov/2016:00:01:16 +0800,10,54 ,video,1805 324 183.39.154.199,10/Nov/2016:00:01:16 +0800,10,348 ,video,13098 325 119.131.143.179,10/Nov/2016:00:01:16 +0800,10,67 ,video,2401 326 113.118.96.208,10/Nov/2016:00:01:16 +0800,10,54 ,video,9022 327 221.130.253.135,10/Nov/2016:00:01:16 +0800,10,67 ,video,12302 328 183.39.154.199,10/Nov/2016:00:01:17 +0800,10,2804 ,video,13098 329 119.131.143.179,10/Nov/2016:00:01:17 +0800,10,9035 ,video,2401 330 183.39.154.199,10/Nov/2016:00:01:17 +0800,10,324 ,video,13098 331 183.39.154.199,10/Nov/2016:00:01:17 +0800,10,185 ,video,13098 332 118.249.208.191,10/Nov/2016:00:01:17 +0800,10,8589 ,video,12831 333 183.39.154.199,10/Nov/2016:00:01:17 +0800,10,106 ,video,13098 334 117.32.216.53,10/Nov/2016:00:01:17 +0800,10,54 ,video,3326 335 183.39.154.199,10/Nov/2016:00:01:17 +0800,10,6195 ,video,13098 336 183.39.154.199,10/Nov/2016:00:01:17 +0800,10,4941 ,video,13098 337 119.131.143.179,10/Nov/2016:00:01:17 +0800,10,2959 ,video,2402 338 183.16.11.146,10/Nov/2016:00:01:17 +0800,10,54 ,video,7226 339 183.24.141.90,10/Nov/2016:00:01:17 +0800,10,54 ,video,7214 340 183.39.154.199,10/Nov/2016:00:01:17 +0800,10,72 ,video,13098 341 119.131.143.179,10/Nov/2016:00:01:17 +0800,10,354 ,video,2402 342 118.249.208.191,10/Nov/2016:00:01:17 +0800,10,8589 ,video,12831 343 183.39.154.199,10/Nov/2016:00:01:17 +0800,10,66 ,video,13098 344 119.131.143.179,10/Nov/2016:00:01:17 +0800,10,1422 ,video,2402 345 115.60.82.2,10/Nov/2016:00:01:17 +0800,10,54 ,video,12572 346 101.40.215.190,10/Nov/2016:00:01:17 +0800,10,54 ,video,4906 347 114.91.111.210,10/Nov/2016:00:01:18 +0800,10,54 ,video,696 348 119.131.143.179,10/Nov/2016:00:01:18 +0800,10,17707 ,video,2402 349 183.39.154.199,10/Nov/2016:00:01:18 +0800,10,4947 ,video,13098 350 101.227.12.253,10/Nov/2016:00:01:18 +0800,10,54 ,video,5646 351 223.74.37.85,10/Nov/2016:00:01:18 +0800,10,54 ,video,5694 352 61.148.244.107,10/Nov/2016:00:01:18 +0800,10,54 ,video,4825 353 125.119.38.58,10/Nov/2016:00:01:18 +0800,10,54 ,video,12560 354 119.131.143.179,10/Nov/2016:00:01:18 +0800,10,2635 ,video,2402 355 119.131.143.179,10/Nov/2016:00:01:18 +0800,10,4471 ,video,2402 356 119.131.143.179,10/Nov/2016:00:01:18 +0800,10,66 ,video,2402 357 58.20.14.170,10/Nov/2016:00:01:18 +0800,10,6417 ,video,5683 358 119.131.143.179,10/Nov/2016:00:01:18 +0800,10,354 ,video,2402 359 111.137.134.93,10/Nov/2016:00:01:18 +0800,10,7233 ,video,2752 360 58.242.129.249,10/Nov/2016:00:01:18 +0800,10,54 ,video,7228 361 58.250.176.134,10/Nov/2016:00:01:18 +0800,10,54 ,video,9214 362 119.131.143.179,10/Nov/2016:00:01:18 +0800,10,72 ,video,2402 363 119.131.143.179,10/Nov/2016:00:01:18 +0800,10,4373 ,video,2402 364 1.203.177.243,10/Nov/2016:00:01:18 +0800,10,6050 ,video,7361 365 119.131.143.179,10/Nov/2016:00:01:18 +0800,10,1081 ,video,2402 366 183.39.54.240,10/Nov/2016:00:01:18 +0800,10,54 ,video,13263 367 119.131.143.179,10/Nov/2016:00:01:19 +0800,10,329 ,video,2402 368 59.53.31.168,10/Nov/2016:00:01:19 +0800,10,54 ,video,9495 369 36.33.5.19,10/Nov/2016:00:01:19 +0800,10,6833 ,video,12504 370 119.131.143.179,10/Nov/2016:00:01:19 +0800,10,390 ,video,2402 371 1.203.177.243,10/Nov/2016:00:01:19 +0800,10,72 ,video,7361 372 60.186.195.123,10/Nov/2016:00:01:19 +0800,10,54 ,video,3653 373 115.156.237.9,10/Nov/2016:00:01:19 +0800,10,67 ,video,8746 374 125.120.150.55,10/Nov/2016:00:01:19 +0800,10,54 ,video,2450 375 106.37.179.179,10/Nov/2016:00:01:19 +0800,10,54 ,video,1430 376 123.112.21.116,10/Nov/2016:00:01:19 +0800,10,54 ,video,4441 377 221.221.148.132,10/Nov/2016:00:01:19 +0800,10,72 ,video,13153 378 122.71.75.164,10/Nov/2016:00:01:19 +0800,10,141 ,video,3354 379 119.131.143.179,10/Nov/2016:00:01:19 +0800,10,9035 ,video,2402 380 221.221.148.132,10/Nov/2016:00:01:19 +0800,10,319 ,video,13153 381 106.38.51.208,10/Nov/2016:00:01:19 +0800,10,54 ,video,3720 382 221.221.148.132,10/Nov/2016:00:01:19 +0800,10,3991 ,video,13153 383 71.17.103.212,10/Nov/2016:00:01:19 +0800,10,67 ,video,7075 384 183.228.51.173,10/Nov/2016:00:01:19 +0800,10,54 ,video,12484 385 42.236.157.243,10/Nov/2016:00:01:19 +0800,10,54 ,video,10694 386 124.133.245.246,10/Nov/2016:00:01:19 +0800,10,67 ,video,10681 387 125.77.188.210,10/Nov/2016:00:01:19 +0800,10,54 ,video,9356 388 110.184.220.157,10/Nov/2016:00:01:19 +0800,10,54 ,video,10427 389 139.196.128.65,10/Nov/2016:00:01:19 +0800,10,524288 ,video,7974 390 221.221.148.132,10/Nov/2016:00:01:19 +0800,10,6287 ,video,13153 391 119.131.143.179,10/Nov/2016:00:01:19 +0800,10,72 ,video,2402 392 120.1.177.245,10/Nov/2016:00:01:20 +0800,10,67 ,video,3723 393 183.39.154.199,10/Nov/2016:00:01:20 +0800,10,6195 ,video,13098 394 120.52.94.104,10/Nov/2016:00:01:20 +0800,10,54 ,video,8217 395 221.221.148.132,10/Nov/2016:00:01:20 +0800,10,349 ,video,13153 396 117.89.227.188,10/Nov/2016:00:01:20 +0800,10,66 ,video,1336 397 121.35.185.119,10/Nov/2016:00:01:20 +0800,10,68 ,video,6161 398 61.173.68.158,10/Nov/2016:00:01:20 +0800,10,54 ,video,12534 399 221.221.148.132,10/Nov/2016:00:01:20 +0800,10,2256 ,video,13153 400 125.91.244.214,10/Nov/2016:00:01:20 +0800,10,54 ,video,1416 401 117.35.88.30,10/Nov/2016:00:01:20 +0800,10,54 ,video,5926 402 14.23.136.224,10/Nov/2016:00:01:20 +0800,10,67 ,video,2316 403 117.89.227.188,10/Nov/2016:00:01:20 +0800,10,1416 ,video,1336 404 221.221.148.132,10/Nov/2016:00:01:20 +0800,10,72 ,video,13153 405 117.89.227.188,10/Nov/2016:00:01:20 +0800,10,4192 ,video,1336 406 124.65.98.198,10/Nov/2016:00:01:20 +0800,10,54 ,video,9887 407 219.157.250.14,10/Nov/2016:00:01:20 +0800,10,54 ,video,1328 408 221.221.148.132,10/Nov/2016:00:01:20 +0800,10,74 ,video,13153 409 117.89.227.188,10/Nov/2016:00:01:20 +0800,10,72 ,video,1336 410 61.190.33.6,10/Nov/2016:00:01:20 +0800,10,67 ,video,2858 411 117.89.227.188,10/Nov/2016:00:01:20 +0800,10,4418 ,video,1336 412 117.89.227.188,10/Nov/2016:00:01:20 +0800,10,678 ,video,1336 413 101.95.153.34,10/Nov/2016:00:01:20 +0800,10,54 ,video,1716 414 112.93.198.226,10/Nov/2016:00:01:20 +0800,10,54 ,video,3520 415 125.118.5.247,10/Nov/2016:00:01:20 +0800,10,54 ,video,1990 416 117.89.227.188,10/Nov/2016:00:01:20 +0800,10,2263 ,video,1336 417 1.194.144.222,10/Nov/2016:00:01:20 +0800,10,54 ,video,3589 418 114.249.202.36,10/Nov/2016:00:01:20 +0800,10,67 ,video,12505 419 122.71.75.164,10/Nov/2016:00:01:21 +0800,10,67 ,video,3354 420 117.89.227.188,10/Nov/2016:00:01:21 +0800,10,328 ,video,1336 421 116.19.167.230,10/Nov/2016:00:01:21 +0800,10,54 ,video,2004 422 110.184.67.238,10/Nov/2016:00:01:21 +0800,10,54 ,video,5539 423 223.80.97.99,10/Nov/2016:00:01:21 +0800,10,67 ,video,5553 424 122.71.75.164,10/Nov/2016:00:01:21 +0800,10,7766 ,video,3354 425 117.89.227.188,10/Nov/2016:00:01:21 +0800,10,2227 ,video,1336 426 125.88.24.35,10/Nov/2016:00:01:21 +0800,10,54 ,video,1901 427 112.115.177.220,10/Nov/2016:00:01:21 +0800,10,54 ,video,4285 428 117.89.227.188,10/Nov/2016:00:01:21 +0800,10,306 ,video,1336 429 222.240.165.84,10/Nov/2016:00:01:21 +0800,10,54 ,video,3520 430 222.131.22.52,10/Nov/2016:00:01:21 +0800,10,67 ,video,2789 431 122.234.60.39,10/Nov/2016:00:01:21 +0800,10,8443 ,video,8837 432 124.205.212.177,10/Nov/2016:00:01:21 +0800,10,54 ,video,10505 433 122.71.75.164,10/Nov/2016:00:01:21 +0800,10,2958 ,video,3369 434 210.12.48.132,10/Nov/2016:00:01:21 +0800,10,54 ,video,11822 435 61.183.118.241,10/Nov/2016:00:01:21 +0800,10,54 ,video,7682 436 117.89.227.188,10/Nov/2016:00:01:21 +0800,10,313 ,video,1336 437 183.128.108.110,10/Nov/2016:00:01:21 +0800,10,54 ,video,1778 438 218.18.157.66,10/Nov/2016:00:01:21 +0800,10,297 ,video,3659 439 121.207.180.238,10/Nov/2016:00:01:21 +0800,10,54 ,video,2685 440 14.23.183.93,10/Nov/2016:00:01:21 +0800,10,54 ,video,8925 441 122.71.75.164,10/Nov/2016:00:01:21 +0800,10,358 ,video,3369 442 122.71.75.164,10/Nov/2016:00:01:21 +0800,10,66 ,video,3369 443 59.46.181.226,10/Nov/2016:00:01:21 +0800,10,54 ,video,2469 444 49.74.38.249,10/Nov/2016:00:01:21 +0800,10,141 ,video,634 445 115.220.63.20,10/Nov/2016:00:01:21 +0800,10,54 ,video,4375 446 124.90.145.106,10/Nov/2016:00:01:21 +0800,10,54 ,video,5691 447 122.71.75.164,10/Nov/2016:00:01:21 +0800,10,1214 ,video,3369 448 117.89.227.188,10/Nov/2016:00:01:21 +0800,10,6665 ,video,1336 449 122.71.75.164,10/Nov/2016:00:01:22 +0800,10,2345 ,video,3369 450 58.217.139.123,10/Nov/2016:00:01:22 +0800,10,54 ,video,12701 451 218.18.157.66,10/Nov/2016:00:01:22 +0800,10,2345 ,video,3659 452 221.234.230.60,10/Nov/2016:00:01:22 +0800,10,54 ,video,9088 453 122.71.75.164,10/Nov/2016:00:01:22 +0800,10,358 ,video,3369 454 122.71.75.164,10/Nov/2016:00:01:22 +0800,10,4004 ,video,3369 455 117.89.227.188,10/Nov/2016:00:01:22 +0800,10,72 ,video,1336 456 218.18.157.66,10/Nov/2016:00:01:22 +0800,10,297 ,video,3659 457 36.57.168.12,10/Nov/2016:00:01:22 +0800,10,54 ,video,7557 458 117.172.25.86,10/Nov/2016:00:01:22 +0800,10,54 ,video,6694 459 125.90.50.60,10/Nov/2016:00:01:22 +0800,10,54 ,video,3151 460 122.71.75.164,10/Nov/2016:00:01:22 +0800,10,2535 ,video,3369 461 117.100.121.159,10/Nov/2016:00:01:22 +0800,10,54 ,video,6711 462 114.249.199.177,10/Nov/2016:00:01:22 +0800,10,54 ,video,11551 463 218.18.157.66,10/Nov/2016:00:01:22 +0800,10,308 ,video,3659 464 122.71.75.164,10/Nov/2016:00:01:22 +0800,10,1650 ,video,3369 465 121.33.51.254,10/Nov/2016:00:01:22 +0800,10,54 ,video,6512 466 182.100.20.75,10/Nov/2016:00:01:22 +0800,10,54 ,video,3244 467 122.71.75.164,10/Nov/2016:00:01:22 +0800,10,328 ,video,3369 468 27.41.88.229,10/Nov/2016:00:01:22 +0800,10,54 ,video,2911 469 123.118.216.81,10/Nov/2016:00:01:22 +0800,10,54 ,video,6421 470 1.203.177.243,10/Nov/2016:00:01:22 +0800,10,6050 ,video,7361 471 122.71.75.164,10/Nov/2016:00:01:22 +0800,10,72 ,video,3369 472 218.18.157.66,10/Nov/2016:00:01:22 +0800,10,448 ,video,3659 473 122.71.75.164,10/Nov/2016:00:01:23 +0800,10,742 ,video,3369 474 117.169.140.25,10/Nov/2016:00:01:23 +0800,10,54 ,video,1412 475 122.71.75.164,10/Nov/2016:00:01:23 +0800,10,4481 ,video,3369 476 218.18.157.66,10/Nov/2016:00:01:23 +0800,10,1884 ,video,3659 477 122.71.75.164,10/Nov/2016:00:01:23 +0800,10,7766 ,video,3369 478 210.21.221.18,10/Nov/2016:00:01:23 +0800,10,54 ,video,11736 479 117.100.231.8,10/Nov/2016:00:01:23 +0800,10,190 ,video,4017 480 108.61.180.213,10/Nov/2016:00:01:23 +0800,10,54 ,video,6841 481 114.141.190.122,10/Nov/2016:00:01:23 +0800,10,67 ,video,13160 482 36.57.145.114,10/Nov/2016:00:01:23 +0800,10,54 ,video,13271 483 120.86.130.234,10/Nov/2016:00:01:23 +0800,10,54 ,video,8175 484 210.41.96.62,10/Nov/2016:00:01:23 +0800,10,54 ,video,3604 485 218.18.157.66,10/Nov/2016:00:01:23 +0800,10,395 ,video,3659 486 27.154.86.14,10/Nov/2016:00:01:23 +0800,10,54 ,video,7863 487 117.100.231.8,10/Nov/2016:00:01:23 +0800,10,3168 ,video,4017 488 113.65.160.153,10/Nov/2016:00:01:23 +0800,10,54 ,video,3370 489 123.150.205.98,10/Nov/2016:00:01:23 +0800,10,68 ,video,1758 490 122.71.75.164,10/Nov/2016:00:01:23 +0800,10,72 ,video,3369 491 106.120.124.49,10/Nov/2016:00:01:23 +0800,10,54 ,video,3471 492 36.110.17.19,10/Nov/2016:00:01:24 +0800,10,54 ,video,13160 493 61.51.82.242,10/Nov/2016:00:01:24 +0800,10,67 ,video,6606 494 120.198.231.151,10/Nov/2016:00:01:24 +0800,10,54 ,video,13315 495 125.90.50.156,10/Nov/2016:00:01:24 +0800,10,54 ,video,2147 496 222.72.45.34,10/Nov/2016:00:01:24 +0800,10,54 ,video,11425 497 180.102.214.19,10/Nov/2016:00:01:24 +0800,10,54 ,video,7743 498 171.13.241.97,10/Nov/2016:00:01:24 +0800,10,54074 ,video,5534 499 171.13.241.97,10/Nov/2016:00:01:24 +0800,10,3212 ,video,5534 500 58.63.21.177,10/Nov/2016:00:01:24 +0800,10,67 ,video,9332 501 118.249.208.191,10/Nov/2016:00:01:24 +0800,10,54 ,video,12831 502 171.13.241.97,10/Nov/2016:00:01:24 +0800,10,2950 ,video,5534 503 112.64.10.8,10/Nov/2016:00:01:24 +0800,10,54 ,video,3521 504 119.130.104.156,10/Nov/2016:00:01:24 +0800,10,54 ,video,5677 505 110.185.16.31,10/Nov/2016:00:01:24 +0800,10,54 ,video,8652 506 171.13.241.97,10/Nov/2016:00:01:24 +0800,10,205544 ,video,5534 507 182.201.172.107,10/Nov/2016:00:01:24 +0800,10,54 ,video,13249 508 180.161.236.98,10/Nov/2016:00:01:24 +0800,10,54 ,video,156 509 183.48.71.10,10/Nov/2016:00:01:24 +0800,10,54 ,video,10400 510 58.250.247.130,10/Nov/2016:00:01:24 +0800,10,67 ,video,2872 511 59.40.133.15,10/Nov/2016:00:01:24 +0800,10,54 ,video,12501 512 110.90.61.111,10/Nov/2016:00:01:24 +0800,10,54 ,video,179 513 119.145.15.156,10/Nov/2016:00:01:25 +0800,10,54 ,video,11050 514 183.54.198.81,10/Nov/2016:00:01:25 +0800,10,54 ,video,1625 515 116.22.115.108,10/Nov/2016:00:01:25 +0800,10,54 ,video,3301 516 27.46.6.191,10/Nov/2016:00:01:25 +0800,10,54 ,video,1681 517 125.92.121.122,10/Nov/2016:00:01:25 +0800,10,54 ,video,13339 518 222.92.141.18,10/Nov/2016:00:01:25 +0800,10,54 ,video,11689 519 118.112.58.228,10/Nov/2016:00:01:25 +0800,10,54 ,video,8491 520 218.109.108.228,10/Nov/2016:00:01:25 +0800,10,54 ,video,9669 521 182.18.117.210,10/Nov/2016:00:01:25 +0800,10,54 ,video,8515 522 111.161.148.23,10/Nov/2016:00:01:25 +0800,10,54 ,video,9566 523 183.240.20.42,10/Nov/2016:00:01:26 +0800,10,54 ,video,525 524 58.44.240.162,10/Nov/2016:00:01:26 +0800,10,54 ,video,12815 525 60.186.5.64,10/Nov/2016:00:01:26 +0800,10,54 ,video,11551 526 222.129.145.85,10/Nov/2016:00:01:26 +0800,10,54 ,video,10324 527 183.207.178.205,10/Nov/2016:00:01:26 +0800,10,54 ,video,7409 528 101.224.111.144,10/Nov/2016:00:01:26 +0800,10,54 ,video,3085 529 111.198.233.158,10/Nov/2016:00:01:26 +0800,10,54 ,video,2633 530 119.131.106.128,10/Nov/2016:00:01:26 +0800,10,67 ,video,8485 531 123.53.190.91,10/Nov/2016:00:01:26 +0800,10,54 ,video,11316 532 123.157.208.18,10/Nov/2016:00:01:26 +0800,10,67 ,video,12622 533 175.152.2.169,10/Nov/2016:00:01:26 +0800,10,141 ,video,2644 534 45.32.34.196,10/Nov/2016:00:01:26 +0800,10,67 ,video,6687 535 171.120.24.254,10/Nov/2016:00:01:26 +0800,10,54 ,video,2520 536 171.8.148.158,10/Nov/2016:00:01:26 +0800,10,54 ,video,8299 537 202.107.210.51,10/Nov/2016:00:01:26 +0800,10,68 ,video,1904 538 58.250.198.7,10/Nov/2016:00:01:26 +0800,10,54 ,video,6701 539 118.207.116.20,10/Nov/2016:00:01:26 +0800,10,54 ,video,3002 540 222.79.80.123,10/Nov/2016:00:01:27 +0800,10,54 ,video,4415 541 182.242.227.199,10/Nov/2016:00:01:27 +0800,10,67 ,video,1628 542 42.48.158.135,10/Nov/2016:00:01:27 +0800,10,54 ,video,703 543 125.120.150.55,10/Nov/2016:00:01:27 +0800,10,67 ,video,8286 544 59.46.175.212,10/Nov/2016:00:01:27 +0800,10,54 ,video,12680 545 222.137.65.229,10/Nov/2016:00:01:27 +0800,10,54 ,video,7544 546 210.12.145.219,10/Nov/2016:00:01:27 +0800,10,54 ,video,1689 547 222.128.172.20,10/Nov/2016:00:01:27 +0800,10,54 ,video,10061 548 117.89.227.188,10/Nov/2016:00:01:27 +0800,10,6665 ,video,1336 549 210.30.58.22,10/Nov/2016:00:01:27 +0800,10,54 ,video,8152 550 119.130.185.151,10/Nov/2016:00:01:27 +0800,10,54 ,video,5647 551 124.65.98.198,10/Nov/2016:00:01:27 +0800,10,54 ,video,5987 552 61.142.10.231,10/Nov/2016:00:01:27 +0800,10,54 ,video,12482 553 14.153.236.58,10/Nov/2016:00:01:27 +0800,10,320 ,video,6689 554 14.153.236.58,10/Nov/2016:00:01:27 +0800,10,4166 ,video,6689 555 223.93.140.242,10/Nov/2016:00:01:28 +0800,10,67 ,video,9813 556 14.153.236.58,10/Nov/2016:00:01:28 +0800,10,66 ,video,6689 557 27.38.44.210,10/Nov/2016:00:01:28 +0800,10,54 ,video,816 558 14.153.236.58,10/Nov/2016:00:01:28 +0800,10,10732 ,video,6689 559 222.80.96.74,10/Nov/2016:00:01:28 +0800,10,54 ,video,1326 560 220.181.38.110,10/Nov/2016:00:01:28 +0800,10,54 ,video,12886 561 14.153.236.58,10/Nov/2016:00:01:28 +0800,10,2612 ,video,6689 562 61.183.118.245,10/Nov/2016:00:01:28 +0800,10,54 ,video,2752 563 14.153.236.58,10/Nov/2016:00:01:28 +0800,10,914 ,video,6689 564 125.90.50.87,10/Nov/2016:00:01:28 +0800,10,54 ,video,9579 565 117.41.234.99,10/Nov/2016:00:01:28 +0800,10,67 ,video,1091 566 120.198.231.151,10/Nov/2016:00:01:28 +0800,10,342 ,video,5644 567 120.198.231.151,10/Nov/2016:00:01:28 +0800,10,66 ,video,5644 568 14.153.236.58,10/Nov/2016:00:01:28 +0800,10,72 ,video,6689 569 120.198.231.151,10/Nov/2016:00:01:28 +0800,10,2959 ,video,5644 570 120.198.231.150,10/Nov/2016:00:01:28 +0800,10,54 ,video,10692 571 42.236.157.243,10/Nov/2016:00:01:28 +0800,10,67 ,video,10694 572 14.153.236.58,10/Nov/2016:00:01:28 +0800,10,74 ,video,6689 573 140.205.253.145,10/Nov/2016:00:01:28 +0800,10,524288 ,video,5609 574 14.153.236.58,10/Nov/2016:00:01:28 +0800,10,179 ,video,6689 575 219.243.215.194,10/Nov/2016:00:01:28 +0800,10,54 ,video,774 576 120.198.231.151,10/Nov/2016:00:01:28 +0800,10,1052 ,video,5644 577 120.196.62.207,10/Nov/2016:00:01:28 +0800,10,54 ,video,6510 578 14.153.236.58,10/Nov/2016:00:01:29 +0800,10,320 ,video,6689 579 175.152.2.169,10/Nov/2016:00:01:29 +0800,10,67 ,video,2644 580 115.192.161.60,10/Nov/2016:00:01:29 +0800,10,54 ,video,12897 581 112.64.60.228,10/Nov/2016:00:01:29 +0800,10,54 ,video,5433 582 113.107.163.197,10/Nov/2016:00:01:29 +0800,10,54 ,video,2808 583 122.71.75.164,10/Nov/2016:00:01:29 +0800,10,7766 ,video,3369 584 58.241.76.18,10/Nov/2016:00:01:29 +0800,10,2635 ,video,1802 585 175.152.2.169,10/Nov/2016:00:01:29 +0800,10,5 ,video,2644 586 120.198.231.151,10/Nov/2016:00:01:29 +0800,10,342 ,video,5644 587 110.88.48.16,10/Nov/2016:00:01:29 +0800,10,54 ,video,1762 588 123.157.217.162,10/Nov/2016:00:01:29 +0800,10,67 ,video,4417 589 117.41.234.99,10/Nov/2016:00:01:29 +0800,10,67 ,video,1202 590 60.191.78.148,10/Nov/2016:00:01:29 +0800,10,67 ,video,5478 591 120.198.231.151,10/Nov/2016:00:01:29 +0800,10,4849 ,video,5644 592 42.248.114.145,10/Nov/2016:00:01:29 +0800,10,54 ,video,4242 593 175.152.2.169,10/Nov/2016:00:01:29 +0800,10,8182 ,video,2644 594 80.78.215.116,10/Nov/2016:00:01:29 +0800,10,67 ,video,9905 595 125.120.150.55,10/Nov/2016:00:01:29 +0800,10,67 ,video,8286 596 111.37.29.165,10/Nov/2016:00:01:29 +0800,10,67 ,video,8413 597 14.153.236.58,10/Nov/2016:00:01:29 +0800,10,6777 ,video,6689 598 101.200.101.21,10/Nov/2016:00:01:29 +0800,10,524288 ,video,10506 599 58.241.76.18,10/Nov/2016:00:01:29 +0800,10,95 ,video,1802 600 218.245.66.245,10/Nov/2016:00:01:29 +0800,10,54 ,video,10674 601 120.196.62.207,10/Nov/2016:00:01:29 +0800,10,67 ,video,4525 602 113.120.49.46,10/Nov/2016:00:01:30 +0800,10,54 ,video,6206 603 182.242.227.199,10/Nov/2016:00:01:30 +0800,10,54 ,video,1626 604 120.198.231.151,10/Nov/2016:00:01:30 +0800,10,1921 ,video,5644 605 101.200.101.21,10/Nov/2016:00:01:30 +0800,10,524288 ,video,10506 606 114.251.179.129,10/Nov/2016:00:01:30 +0800,10,54 ,video,10450 607 113.132.11.88,10/Nov/2016:00:01:30 +0800,10,54 ,video,5664 608 115.171.143.119,10/Nov/2016:00:01:30 +0800,10,54 ,video,4713 609 115.199.179.156,10/Nov/2016:00:01:30 +0800,10,54 ,video,7099 610 120.52.92.3,10/Nov/2016:00:01:30 +0800,10,141 ,video,11288 611 220.181.38.112,10/Nov/2016:00:01:30 +0800,10,54 ,video,2475 612 183.5.244.42,10/Nov/2016:00:01:30 +0800,10,54 ,video,2474 613 59.172.176.229,10/Nov/2016:00:01:30 +0800,10,54 ,video,1328 614 218.205.169.193,10/Nov/2016:00:01:30 +0800,10,54 ,video,7950 615 59.172.142.93,10/Nov/2016:00:01:30 +0800,10,54 ,video,7704 616 219.143.13.59,10/Nov/2016:00:01:30 +0800,10,67 ,video,9547 617 14.153.236.58,10/Nov/2016:00:01:30 +0800,10,72 ,video,6689 618 39.176.195.5,10/Nov/2016:00:01:31 +0800,10,54 ,video,2687 619 122.224.33.106,10/Nov/2016:00:01:31 +0800,10,54 ,video,1455 620 61.141.142.19,10/Nov/2016:00:01:31 +0800,10,54 ,video,2882 621 116.233.89.239,10/Nov/2016:00:01:31 +0800,10,54 ,video,4708 622 1.85.61.18,10/Nov/2016:00:01:31 +0800,10,54 ,video,6578 623 58.209.20.172,10/Nov/2016:00:01:31 +0800,10,54 ,video,2174 624 112.80.186.13,10/Nov/2016:00:01:31 +0800,10,54 ,video,3345 625 120.210.189.251,10/Nov/2016:00:01:31 +0800,10,54 ,video,11224 626 119.131.143.179,10/Nov/2016:00:01:31 +0800,10,9035 ,video,2402 627 219.150.53.96,10/Nov/2016:00:01:31 +0800,10,54 ,video,1709 628 114.248.224.214,10/Nov/2016:00:01:31 +0800,10,67 ,video,1308 629 117.166.15.72,10/Nov/2016:00:01:31 +0800,10,54 ,video,4323 630 114.248.224.214,10/Nov/2016:00:01:31 +0800,10,6690 ,video,1308 631 110.80.26.230,10/Nov/2016:00:01:31 +0800,10,54 ,video,12481 632 58.62.103.176,10/Nov/2016:00:01:32 +0800,10,67 ,video,6429 633 222.212.194.52,10/Nov/2016:00:01:32 +0800,10,54 ,video,5615 634 182.18.111.38,10/Nov/2016:00:01:32 +0800,10,54 ,video,4451 635 114.249.93.42,10/Nov/2016:00:01:32 +0800,10,54 ,video,11950 636 113.246.94.4,10/Nov/2016:00:01:32 +0800,10,54 ,video,773 637 119.145.72.168,10/Nov/2016:00:01:32 +0800,10,54 ,video,6209 638 114.248.224.214,10/Nov/2016:00:01:32 +0800,10,2958 ,video,1309 639 113.87.230.207,10/Nov/2016:00:01:32 +0800,10,67 ,video,9802 640 117.100.231.8,10/Nov/2016:00:01:32 +0800,10,141 ,video,4017 641 118.207.116.20,10/Nov/2016:00:01:32 +0800,10,72 ,video,3002 642 222.168.40.123,10/Nov/2016:00:01:32 +0800,10,67 ,video,12883 643 49.74.38.249,10/Nov/2016:00:01:32 +0800,10,67 ,video,634 644 211.80.86.94,10/Nov/2016:00:01:32 +0800,10,67 ,video,5288 645 220.240.226.90,10/Nov/2016:00:01:32 +0800,10,54 ,video,2634 646 114.248.224.214,10/Nov/2016:00:01:32 +0800,10,339 ,video,1309 647 123.234.233.109,10/Nov/2016:00:01:32 +0800,10,67 ,video,11225 648 221.221.202.248,10/Nov/2016:00:01:32 +0800,10,54 ,video,3345 649 113.109.214.12,10/Nov/2016:00:01:32 +0800,10,54 ,video,10802 650 27.38.0.184,10/Nov/2016:00:01:32 +0800,10,54 ,video,7198 651 114.248.224.214,10/Nov/2016:00:01:32 +0800,10,1246 ,video,1309 652 124.127.79.228,10/Nov/2016:00:01:32 +0800,10,54 ,video,9819 653 101.40.175.228,10/Nov/2016:00:01:32 +0800,10,54 ,video,12905 654 116.243.183.21,10/Nov/2016:00:01:32 +0800,10,54 ,video,9970 655 220.198.208.176,10/Nov/2016:00:01:32 +0800,10,54 ,video,2789 656 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,1955 ,video,1309 657 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,519 ,video,1309 658 111.172.46.191,10/Nov/2016:00:01:33 +0800,10,54 ,video,1708 659 222.173.219.54,10/Nov/2016:00:01:33 +0800,10,54 ,video,5941 660 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,339 ,video,1309 661 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,306 ,video,1309 662 139.196.128.78,10/Nov/2016:00:01:33 +0800,10,524288 ,video,9478 663 39.179.202.119,10/Nov/2016:00:01:33 +0800,10,54 ,video,2159 664 58.250.198.10,10/Nov/2016:00:01:33 +0800,10,54 ,video,6712 665 221.221.223.134,10/Nov/2016:00:01:33 +0800,10,54 ,video,371 666 42.243.70.197,10/Nov/2016:00:01:33 +0800,10,54 ,video,4188 667 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,323 ,video,1309 668 58.33.184.252,10/Nov/2016:00:01:33 +0800,10,67 ,video,4247 669 113.132.11.206,10/Nov/2016:00:01:33 +0800,10,54 ,video,11823 670 218.65.215.17,10/Nov/2016:00:01:33 +0800,10,54 ,video,11041 671 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,2700 ,video,1309 672 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,3421 ,video,1309 673 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,66 ,video,1309 674 140.207.223.190,10/Nov/2016:00:01:33 +0800,10,54 ,video,3665 675 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,3421 ,video,1309 676 183.4.176.116,10/Nov/2016:00:01:33 +0800,10,54 ,video,2427 677 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,72 ,video,1309 678 122.224.33.97,10/Nov/2016:00:01:33 +0800,10,54 ,video,3016 679 123.149.32.122,10/Nov/2016:00:01:33 +0800,10,54 ,video,3645 680 211.83.242.122,10/Nov/2016:00:01:33 +0800,10,54 ,video,4451 681 106.5.219.134,10/Nov/2016:00:01:33 +0800,10,54 ,video,7479 682 182.100.26.109,10/Nov/2016:00:01:33 +0800,10,54 ,video,11709 683 114.248.224.214,10/Nov/2016:00:01:33 +0800,10,6690 ,video,1309 684 101.40.175.228,10/Nov/2016:00:01:34 +0800,10,67 ,video,11716 685 61.51.82.242,10/Nov/2016:00:01:34 +0800,10,54 ,video,3262 686 121.69.23.250,10/Nov/2016:00:01:34 +0800,10,54 ,video,12495 687 218.88.29.153,10/Nov/2016:00:01:34 +0800,10,54 ,video,1446 688 117.41.234.99,10/Nov/2016:00:01:34 +0800,10,54 ,video,1092 689 113.57.24.53,10/Nov/2016:00:01:34 +0800,10,54 ,video,2523 690 60.191.99.129,10/Nov/2016:00:01:34 +0800,10,54 ,video,3520 691 115.156.142.179,10/Nov/2016:00:01:34 +0800,10,54 ,video,12280 692 223.21.111.79,10/Nov/2016:00:01:34 +0800,10,54 ,video,11714 693 111.132.18.241,10/Nov/2016:00:01:34 +0800,10,54 ,video,3473 694 71.17.103.212,10/Nov/2016:00:01:34 +0800,10,67 ,video,7075 695 14.23.188.111,10/Nov/2016:00:01:34 +0800,10,54 ,video,2418 696 125.88.24.91,10/Nov/2016:00:01:34 +0800,10,54 ,video,1501 697 115.193.172.253,10/Nov/2016:00:01:34 +0800,10,72 ,video,3078 698 112.12.192.150,10/Nov/2016:00:01:34 +0800,10,54 ,video,1861 699 113.91.162.210,10/Nov/2016:00:01:34 +0800,10,67 ,video,1809 700 14.23.136.224,10/Nov/2016:00:01:34 +0800,10,54 ,video,2316 701 125.122.26.81,10/Nov/2016:00:01:35 +0800,10,54 ,video,3225 702 183.240.20.251,10/Nov/2016:00:01:35 +0800,10,54 ,video,3225 703 117.136.39.218,10/Nov/2016:00:01:35 +0800,10,54 ,video,1414 704 121.35.2.128,10/Nov/2016:00:01:35 +0800,10,54 ,video,12580 705 222.76.251.186,10/Nov/2016:00:01:35 +0800,10,54 ,video,11725 706 140.205.253.137,10/Nov/2016:00:01:35 +0800,10,524288 ,video,13181 707 14.28.139.202,10/Nov/2016:00:01:35 +0800,10,54 ,video,7727 708 171.37.141.121,10/Nov/2016:00:01:35 +0800,10,54 ,video,12163 709 180.173.242.43,10/Nov/2016:00:01:35 +0800,10,54 ,video,6046 710 223.20.63.251,10/Nov/2016:00:01:35 +0800,10,54 ,video,3246 711 27.42.25.21,10/Nov/2016:00:01:35 +0800,10,67 ,video,9888 712 113.87.161.137,10/Nov/2016:00:01:35 +0800,10,141 ,video,8006 713 183.66.87.224,10/Nov/2016:00:01:35 +0800,10,54 ,video,12133 714 220.168.79.189,10/Nov/2016:00:01:35 +0800,10,54 ,video,13038 715 175.10.206.212,10/Nov/2016:00:01:35 +0800,10,54 ,video,3956 716 118.207.116.20,10/Nov/2016:00:01:35 +0800,10,72 ,video,3002 717 112.10.27.228,10/Nov/2016:00:01:35 +0800,10,828 ,article,3669 718 112.10.27.228,10/Nov/2016:00:01:35 +0800,10,549 ,article,3669 719 112.10.27.228,10/Nov/2016:00:01:35 +0800,10,16756 ,article,3669 720 111.196.209.12,10/Nov/2016:00:01:35 +0800,10,54 ,video,11443 721 112.10.27.228,10/Nov/2016:00:01:35 +0800,10,498 ,article,3669 722 112.10.27.228,10/Nov/2016:00:01:35 +0800,10,12541 ,article,3669 723 171.8.199.118,10/Nov/2016:00:01:35 +0800,10,68 ,video,3738 724 112.10.27.228,10/Nov/2016:00:01:35 +0800,10,9800 ,article,3669 725 120.52.94.106,10/Nov/2016:00:01:36 +0800,10,54 ,video,678 726 112.10.27.228,10/Nov/2016:00:01:36 +0800,10,628 ,article,3669 727 112.10.27.228,10/Nov/2016:00:01:36 +0800,10,591 ,article,3669 728 112.10.27.228,10/Nov/2016:00:01:36 +0800,10,2951 ,article,3669 729 112.10.27.228,10/Nov/2016:00:01:36 +0800,10,270967 ,article,3669 730 117.100.231.8,10/Nov/2016:00:01:36 +0800,10,67 ,video,4017 731 182.138.128.41,10/Nov/2016:00:01:36 +0800,10,330 ,video,11239 732 182.138.128.41,10/Nov/2016:00:01:36 +0800,10,3892 ,video,11239 733 182.138.128.41,10/Nov/2016:00:01:36 +0800,10,66 ,video,11239 734 101.200.101.21,10/Nov/2016:00:01:36 +0800,10,524288 ,video,10506 735 182.138.128.41,10/Nov/2016:00:01:36 +0800,10,2959 ,video,11239 736 112.64.60.41,10/Nov/2016:00:01:36 +0800,10,54 ,video,4366 737 117.100.231.8,10/Nov/2016:00:01:36 +0800,10,7269 ,video,4017 738 112.10.27.228,10/Nov/2016:00:01:36 +0800,10,4468 ,article,3669 739 112.10.27.228,10/Nov/2016:00:01:36 +0800,10,2023 ,article,3669 740 182.138.128.41,10/Nov/2016:00:01:36 +0800,10,72 ,video,11239 741 114.242.167.68,10/Nov/2016:00:01:36 +0800,10,6511 ,video,4451 742 221.237.87.40,10/Nov/2016:00:01:36 +0800,10,54 ,video,8809 743 112.10.27.228,10/Nov/2016:00:01:36 +0800,10,18906 ,article,3669 744 1.85.61.37,10/Nov/2016:00:01:36 +0800,10,54 ,video,7212 745 112.10.27.228,10/Nov/2016:00:01:36 +0800,10,5102 ,article,3669 746 182.139.108.80,10/Nov/2016:00:01:36 +0800,10,54 ,video,1459 747 101.200.101.31,10/Nov/2016:00:01:36 +0800,10,524288 ,video,8175 748 182.138.128.41,10/Nov/2016:00:01:36 +0800,10,113 ,video,11239 749 114.248.224.214,10/Nov/2016:00:01:36 +0800,10,72 ,video,1309 750 182.138.128.41,10/Nov/2016:00:01:36 +0800,10,2614 ,video,11239 751 112.10.27.228,10/Nov/2016:00:01:36 +0800,10,890 ,article,3669 752 182.138.128.41,10/Nov/2016:00:01:36 +0800,10,330 ,video,11239 753 182.138.128.41,10/Nov/2016:00:01:36 +0800,10,643 ,video,11239 754 113.119.10.98,10/Nov/2016:00:01:36 +0800,10,67 ,video,6224 755 58.249.67.242,10/Nov/2016:00:01:37 +0800,10,54 ,video,11014 756 182.138.128.41,10/Nov/2016:00:01:37 +0800,10,303 ,video,11239 757 182.138.128.41,10/Nov/2016:00:01:37 +0800,10,318 ,video,11239 758 120.41.120.245,10/Nov/2016:00:01:37 +0800,10,54 ,video,5984 759 58.217.165.114,10/Nov/2016:00:01:37 +0800,10,54 ,video,10692 760 117.100.231.8,10/Nov/2016:00:01:37 +0800,10,2957 ,video,4018 761 182.138.128.41,10/Nov/2016:00:01:37 +0800,10,1541 ,video,11239 762 121.69.23.250,10/Nov/2016:00:01:37 +0800,10,67 ,video,12495 763 182.138.128.41,10/Nov/2016:00:01:37 +0800,10,74 ,video,11239 764 123.151.12.154,10/Nov/2016:00:01:37 +0800,10,3493 ,video,5865 765 182.138.128.41,10/Nov/2016:00:01:37 +0800,10,72 ,video,11239 766 39.159.109.210,10/Nov/2016:00:01:37 +0800,10,54 ,video,6203 767 222.73.202.154,10/Nov/2016:00:01:37 +0800,10,68 ,video,12678 768 61.152.132.230,10/Nov/2016:00:01:37 +0800,10,54 ,video,6495 769 182.138.128.41,10/Nov/2016:00:01:37 +0800,10,6207 ,video,11239 770 116.235.102.120,10/Nov/2016:00:01:37 +0800,10,54 ,video,8999 771 58.246.74.211,10/Nov/2016:00:01:37 +0800,10,67 ,video,11731 772 222.65.226.176,10/Nov/2016:00:01:37 +0800,10,54 ,video,10511 773 123.151.12.154,10/Nov/2016:00:01:37 +0800,10,2957 ,video,5866 774 218.106.145.12,10/Nov/2016:00:01:37 +0800,10,54 ,video,9447 775 110.65.101.188,10/Nov/2016:00:01:37 +0800,10,67 ,video,6721 776 117.100.231.8,10/Nov/2016:00:01:37 +0800,10,357 ,video,4018 777 116.237.53.200,10/Nov/2016:00:01:37 +0800,10,54 ,video,4161 778 27.41.69.240,10/Nov/2016:00:01:38 +0800,10,67 ,video,11610 779 58.217.165.114,10/Nov/2016:00:01:38 +0800,10,67 ,video,10690 780 71.17.103.212,10/Nov/2016:00:01:38 +0800,10,67 ,video,7075 781 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,66 ,video,4018 782 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,951 ,video,4018 783 49.77.220.79,10/Nov/2016:00:01:38 +0800,10,54 ,video,1102 784 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,5363 ,video,4018 785 58.63.21.177,10/Nov/2016:00:01:38 +0800,10,54 ,video,10314 786 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,894 ,video,4018 787 120.198.231.152,10/Nov/2016:00:01:38 +0800,10,54 ,video,1803 788 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,5155 ,video,4018 789 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,2286 ,video,4018 790 71.17.103.212,10/Nov/2016:00:01:38 +0800,10,6260 ,video,7075 791 121.207.222.221,10/Nov/2016:00:01:38 +0800,10,54 ,video,9328 792 39.187.166.65,10/Nov/2016:00:01:38 +0800,10,54 ,video,3632 793 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,2536 ,video,4018 794 171.216.69.80,10/Nov/2016:00:01:38 +0800,10,54 ,video,8714 795 123.119.218.242,10/Nov/2016:00:01:38 +0800,10,54 ,video,13013 796 223.81.137.65,10/Nov/2016:00:01:38 +0800,10,54 ,video,7303 797 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,357 ,video,4018 798 192.240.123.193,10/Nov/2016:00:01:38 +0800,10,67 ,video,12881 799 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,72 ,video,4018 800 116.24.24.10,10/Nov/2016:00:01:38 +0800,10,54 ,video,2910 801 117.100.231.8,10/Nov/2016:00:01:38 +0800,10,1092 ,video,4018 802 114.248.224.214,10/Nov/2016:00:01:39 +0800,10,4022 ,video,1309 803 113.143.158.241,10/Nov/2016:00:01:39 +0800,10,141 ,video,4299 804 36.5.155.118,10/Nov/2016:00:01:39 +0800,10,54 ,video,4251 805 114.248.224.214,10/Nov/2016:00:01:39 +0800,10,13241 ,video,1309 806 117.100.231.8,10/Nov/2016:00:01:39 +0800,10,321 ,video,4018 807 39.186.247.142,10/Nov/2016:00:01:39 +0800,10,7227 ,video,3237 808 119.123.177.2,10/Nov/2016:00:01:39 +0800,10,54 ,video,6420 809 110.80.187.200,10/Nov/2016:00:01:39 +0800,10,54 ,video,8356 810 114.24.40.251,10/Nov/2016:00:01:39 +0800,10,54 ,video,1059 811 14.127.27.212,10/Nov/2016:00:01:39 +0800,10,54 ,video,10686 812 113.87.161.137,10/Nov/2016:00:01:39 +0800,10,67 ,video,8006 813 49.72.238.254,10/Nov/2016:00:01:39 +0800,10,54 ,video,2664 814 115.231.148.38,10/Nov/2016:00:01:39 +0800,10,54 ,video,5645 815 106.39.200.44,10/Nov/2016:00:01:39 +0800,10,54 ,video,9579 816 222.178.202.108,10/Nov/2016:00:01:39 +0800,10,54 ,video,2861 817 115.174.68.92,10/Nov/2016:00:01:39 +0800,10,54 ,video,9809 818 183.204.48.118,10/Nov/2016:00:01:39 +0800,10,54 ,video,8212 819 119.130.229.205,10/Nov/2016:00:01:39 +0800,10,54 ,video,4761 820 59.41.95.198,10/Nov/2016:00:01:39 +0800,10,54 ,video,9023 821 101.38.157.182,10/Nov/2016:00:01:39 +0800,10,67 ,video,2163 822 221.226.97.31,10/Nov/2016:00:01:40 +0800,10,54 ,video,5139 823 202.107.210.51,10/Nov/2016:00:01:40 +0800,10,68 ,video,8476 824 183.185.57.58,10/Nov/2016:00:01:40 +0800,10,54 ,video,10679 825 140.207.223.186,10/Nov/2016:00:01:40 +0800,10,54 ,video,13310 826 101.39.103.224,10/Nov/2016:00:01:40 +0800,10,54 ,video,1412 827 140.207.223.186,10/Nov/2016:00:01:40 +0800,10,67 ,video,5609 828 202.107.210.51,10/Nov/2016:00:01:40 +0800,10,68 ,video,3380 829 210.30.109.61,10/Nov/2016:00:01:40 +0800,10,54 ,video,9819 830 202.118.102.15,10/Nov/2016:00:01:40 +0800,10,54 ,video,8141 831 116.227.96.89,10/Nov/2016:00:01:40 +0800,10,54 ,video,7600 832 118.113.41.210,10/Nov/2016:00:01:40 +0800,10,54 ,video,1054 833 119.129.80.141,10/Nov/2016:00:01:40 +0800,10,54 ,video,13048 834 171.34.223.23,10/Nov/2016:00:01:40 +0800,10,54 ,video,9813 835 95.85.18.128,10/Nov/2016:00:01:40 +0800,10,67 ,video,12302 836 117.152.76.120,10/Nov/2016:00:01:40 +0800,10,54 ,video,2667 837 60.29.171.162,10/Nov/2016:00:01:41 +0800,10,54 ,video,8913 838 180.175.49.155,10/Nov/2016:00:01:41 +0800,10,54 ,video,3665 839 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,67 ,video,4299 840 183.128.139.254,10/Nov/2016:00:01:41 +0800,10,54 ,video,365 841 115.60.4.28,10/Nov/2016:00:01:41 +0800,10,67 ,video,10198 842 58.132.202.208,10/Nov/2016:00:01:41 +0800,10,54 ,video,10710 843 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,6686 ,video,4299 844 222.65.233.105,10/Nov/2016:00:01:41 +0800,10,67 ,video,1627 845 122.91.39.170,10/Nov/2016:00:01:41 +0800,10,54 ,video,9366 846 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,2958 ,video,4311 847 112.10.127.193,10/Nov/2016:00:01:41 +0800,10,67 ,video,1090 848 123.124.147.8,10/Nov/2016:00:01:41 +0800,10,54 ,video,5677 849 120.198.231.151,10/Nov/2016:00:01:41 +0800,10,141 ,video,4242 850 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,377 ,video,4311 851 113.67.224.172,10/Nov/2016:00:01:41 +0800,10,54 ,video,818 852 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,752 ,video,4311 853 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,66 ,video,4311 854 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,395 ,video,4311 855 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,3416 ,video,4311 856 113.97.199.198,10/Nov/2016:00:01:41 +0800,10,67 ,video,772 857 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,2345 ,video,4311 858 111.0.200.141,10/Nov/2016:00:01:41 +0800,10,54 ,video,7558 859 111.201.78.80,10/Nov/2016:00:01:41 +0800,10,67 ,video,2452 860 113.143.158.241,10/Nov/2016:00:01:41 +0800,10,332 ,video,4311 861 27.38.60.148,10/Nov/2016:00:01:41 +0800,10,54 ,video,4650 862 182.138.128.41,10/Nov/2016:00:01:41 +0800,10,6207 ,video,11239 863 113.143.158.241,10/Nov/2016:00:01:42 +0800,10,348 ,video,4311 864 58.217.142.142,10/Nov/2016:00:01:42 +0800,10,72 ,video,6045 865 58.217.142.142,10/Nov/2016:00:01:42 +0800,10,66 ,video,6045 866 202.119.41.28,10/Nov/2016:00:01:42 +0800,10,67 ,video,2801 867 60.12.51.243,10/Nov/2016:00:01:42 +0800,10,54 ,video,6565 868 58.213.112.35,10/Nov/2016:00:01:42 +0800,10,54 ,video,5656 869 124.239.251.50,10/Nov/2016:00:01:42 +0800,10,67 ,video,2544 870 71.17.103.212,10/Nov/2016:00:01:42 +0800,10,2959 ,video,7076 871 113.14.0.15,10/Nov/2016:00:01:42 +0800,10,54 ,video,10811 872 27.38.115.174,10/Nov/2016:00:01:42 +0800,10,67 ,video,5986 873 120.236.154.86,10/Nov/2016:00:01:42 +0800,10,54 ,video,3653 874 58.217.142.142,10/Nov/2016:00:01:42 +0800,10,1953 ,video,6045 875 116.232.174.6,10/Nov/2016:00:01:42 +0800,10,54 ,video,2473 876 113.143.158.241,10/Nov/2016:00:01:42 +0800,10,6686 ,video,4311 877 171.217.47.216,10/Nov/2016:00:01:42 +0800,10,0 ,article,1204 878 202.119.41.28,10/Nov/2016:00:01:42 +0800,10,9013 ,video,2801 879 58.213.102.242,10/Nov/2016:00:01:42 +0800,10,54 ,video,9584 880 112.64.60.127,10/Nov/2016:00:01:42 +0800,10,54 ,video,9819 881 58.217.142.142,10/Nov/2016:00:01:42 +0800,10,3750 ,video,6045 882 113.143.158.241,10/Nov/2016:00:01:42 +0800,10,1296 ,video,4311 883 58.217.142.142,10/Nov/2016:00:01:42 +0800,10,179 ,video,6045 884 218.26.154.77,10/Nov/2016:00:01:42 +0800,10,54 ,video,1628 885 114.214.182.197,10/Nov/2016:00:01:42 +0800,10,67 ,video,1092 886 171.217.47.216,10/Nov/2016:00:01:42 +0800,10,2023 ,article,1204 887 113.143.158.241,10/Nov/2016:00:01:42 +0800,10,72 ,video,4311 888 125.85.67.44,10/Nov/2016:00:01:42 +0800,10,54 ,video,5224 889 58.217.142.142,10/Nov/2016:00:01:42 +0800,10,2353 ,video,6045 890 58.61.235.7,10/Nov/2016:00:01:42 +0800,10,54 ,video,10421 891 58.217.142.142,10/Nov/2016:00:01:42 +0800,10,634 ,video,6045 892 113.143.158.241,10/Nov/2016:00:01:42 +0800,10,377 ,video,4311 893 202.119.41.28,10/Nov/2016:00:01:42 +0800,10,2956 ,video,2801 894 118.198.203.49,10/Nov/2016:00:01:42 +0800,10,54 ,video,1478 895 61.142.10.231,10/Nov/2016:00:01:42 +0800,10,67 ,video,12483 896 14.156.71.170,10/Nov/2016:00:01:42 +0800,10,54 ,video,9906 897 117.23.82.56,10/Nov/2016:00:01:43 +0800,10,54 ,video,6845 898 113.143.158.241,10/Nov/2016:00:01:43 +0800,10,72 ,video,4311 899 140.205.253.137,10/Nov/2016:00:01:43 +0800,10,524288 ,video,4029 900 60.186.39.35,10/Nov/2016:00:01:43 +0800,10,67 ,video,7704 901 116.31.61.97,10/Nov/2016:00:01:43 +0800,10,67 ,video,4596 902 113.143.158.241,10/Nov/2016:00:01:43 +0800,10,4091 ,video,4311 903 222.209.9.194,10/Nov/2016:00:01:43 +0800,10,54 ,video,12535 904 202.119.41.28,10/Nov/2016:00:01:43 +0800,10,360 ,video,2801 905 163.125.235.161,10/Nov/2016:00:01:43 +0800,10,67 ,video,11639 906 119.131.143.179,10/Nov/2016:00:01:43 +0800,10,67 ,video,2402 907 202.119.41.28,10/Nov/2016:00:01:43 +0800,10,1422 ,video,2801 908 71.17.103.212,10/Nov/2016:00:01:43 +0800,10,66 ,video,7076 909 202.119.41.28,10/Nov/2016:00:01:43 +0800,10,66 ,video,2801 910 119.131.143.179,10/Nov/2016:00:01:43 +0800,10,12233 ,video,2402 911 60.186.194.249,10/Nov/2016:00:01:43 +0800,10,67 ,video,8643 912 202.119.41.28,10/Nov/2016:00:01:43 +0800,10,89 ,video,2801 913 117.100.231.8,10/Nov/2016:00:01:43 +0800,10,72 ,video,4018 914 59.172.246.60,10/Nov/2016:00:01:43 +0800,10,54 ,video,9820 915 58.217.142.142,10/Nov/2016:00:01:43 +0800,10,0 ,video,6045 916 58.217.142.142,10/Nov/2016:00:01:43 +0800,10,0 ,video,6045 917 60.176.120.135,10/Nov/2016:00:01:43 +0800,10,54 ,video,816 918 60.12.51.243,10/Nov/2016:00:01:43 +0800,10,67 ,video,6565 919 103.204.172.213,10/Nov/2016:00:01:43 +0800,10,54 ,video,7831 920 71.17.103.212,10/Nov/2016:00:01:43 +0800,10,516 ,video,7076 921 140.205.253.145,10/Nov/2016:00:01:43 +0800,10,524288 ,video,5609 922 118.250.42.145,10/Nov/2016:00:01:43 +0800,10,54 ,video,11307 923 180.102.237.112,10/Nov/2016:00:01:43 +0800,10,54 ,video,702 924 58.217.142.142,10/Nov/2016:00:01:43 +0800,10,2956 ,video,6042 925 210.12.14.35,10/Nov/2016:00:01:44 +0800,10,67 ,video,8599 926 27.223.6.43,10/Nov/2016:00:01:44 +0800,10,54 ,video,3723 927 58.217.142.142,10/Nov/2016:00:01:44 +0800,10,313 ,video,6042 928 58.217.142.142,10/Nov/2016:00:01:44 +0800,10,179 ,video,6042 929 120.52.92.5,10/Nov/2016:00:01:44 +0800,10,54 ,video,5118 930 131.107.0.115,10/Nov/2016:00:01:44 +0800,10,54 ,video,3179 931 117.100.231.8,10/Nov/2016:00:01:44 +0800,10,7269 ,video,4018 932 58.217.142.142,10/Nov/2016:00:01:44 +0800,10,66 ,video,6042 933 58.250.198.10,10/Nov/2016:00:01:44 +0800,10,67 ,video,6713 934 210.30.100.2,10/Nov/2016:00:01:44 +0800,10,68 ,video,7965 935 27.36.220.125,10/Nov/2016:00:01:44 +0800,10,54 ,video,6346 936 58.62.203.255,10/Nov/2016:00:01:44 +0800,10,54 ,video,6695 937 27.38.183.139,10/Nov/2016:00:01:44 +0800,10,54 ,video,5210 938 39.174.34.217,10/Nov/2016:00:01:44 +0800,10,54 ,video,9882 939 113.87.161.137,10/Nov/2016:00:01:44 +0800,10,67 ,video,8006 940 59.47.8.86,10/Nov/2016:00:01:44 +0800,10,54 ,video,7599 941 58.217.142.142,10/Nov/2016:00:01:44 +0800,10,2041 ,video,6042 942 14.219.128.52,10/Nov/2016:00:01:44 +0800,10,66 ,video,3850 943 101.95.9.246,10/Nov/2016:00:01:44 +0800,10,54 ,video,11225 944 123.157.208.18,10/Nov/2016:00:01:44 +0800,10,54 ,video,7727 945 59.175.227.254,10/Nov/2016:00:01:44 +0800,10,54 ,video,8601 946 202.119.41.28,10/Nov/2016:00:01:44 +0800,10,1081 ,video,2801 947 120.198.231.150,10/Nov/2016:00:01:44 +0800,10,54 ,video,2671 948 14.219.128.52,10/Nov/2016:00:01:44 +0800,10,366 ,video,3850 949 110.65.101.188,10/Nov/2016:00:01:44 +0800,10,67 ,video,2225 950 14.151.213.221,10/Nov/2016:00:01:44 +0800,10,67 ,video,9817 951 202.119.41.28,10/Nov/2016:00:01:44 +0800,10,360 ,video,2801 952 211.80.84.252,10/Nov/2016:00:01:44 +0800,10,54 ,video,11091 953 14.219.128.52,10/Nov/2016:00:01:44 +0800,10,395 ,video,3850 954 222.73.203.30,10/Nov/2016:00:01:44 +0800,10,54 ,video,11176 955 58.217.142.142,10/Nov/2016:00:01:44 +0800,10,2353 ,video,6042 956 101.39.103.224,10/Nov/2016:00:01:44 +0800,10,72 ,video,1412 957 71.17.103.212,10/Nov/2016:00:01:44 +0800,10,6260 ,video,7076 958 183.240.25.11,10/Nov/2016:00:01:45 +0800,10,54 ,video,4472 959 218.83.152.2,10/Nov/2016:00:01:45 +0800,10,54 ,video,7226 960 180.157.62.124,10/Nov/2016:00:01:45 +0800,10,54 ,video,8692 961 14.219.128.52,10/Nov/2016:00:01:45 +0800,10,4221 ,video,3850 962 125.33.135.73,10/Nov/2016:00:01:45 +0800,10,54 ,video,3075 963 14.219.128.52,10/Nov/2016:00:01:45 +0800,10,448 ,video,3850 964 122.206.190.75,10/Nov/2016:00:01:45 +0800,10,2443 ,video,7707 965 58.217.142.142,10/Nov/2016:00:01:45 +0800,10,1539 ,video,6042 966 58.217.142.142,10/Nov/2016:00:01:45 +0800,10,0 ,video,6042 967 58.217.142.142,10/Nov/2016:00:01:45 +0800,10,0 ,video,6042 968 58.217.142.142,10/Nov/2016:00:01:45 +0800,10,0 ,video,6042 969 14.219.128.52,10/Nov/2016:00:01:45 +0800,10,366 ,video,3850 970 59.42.128.119,10/Nov/2016:00:01:45 +0800,10,67 ,video,5289 971 123.157.217.162,10/Nov/2016:00:01:45 +0800,10,54 ,video,1445 972 120.34.233.118,10/Nov/2016:00:01:45 +0800,10,54 ,video,3521 973 125.119.38.58,10/Nov/2016:00:01:45 +0800,10,141 ,video,12560 974 113.66.157.53,10/Nov/2016:00:01:45 +0800,10,67 ,video,7501 975 98.25.241.43,10/Nov/2016:00:01:45 +0800,10,67 ,video,2360 976 183.58.250.1,10/Nov/2016:00:01:45 +0800,10,54 ,video,4359 977 129.10.9.110,10/Nov/2016:00:01:45 +0800,10,141 ,video,1708 978 210.41.96.62,10/Nov/2016:00:01:45 +0800,10,67 ,video,3354 979 14.219.128.52,10/Nov/2016:00:01:45 +0800,10,2345 ,video,3850 980 120.198.231.151,10/Nov/2016:00:01:45 +0800,10,5823 ,video,4242 981 119.80.170.215,10/Nov/2016:00:01:45 +0800,10,54 ,video,10506 982 120.198.231.152,10/Nov/2016:00:01:45 +0800,10,54 ,video,12495 983 222.65.107.24,10/Nov/2016:00:01:45 +0800,10,67 ,video,7648 984 117.191.16.103,10/Nov/2016:00:01:45 +0800,10,54 ,video,12677 985 14.219.128.52,10/Nov/2016:00:01:45 +0800,10,2519 ,video,3850 986 116.231.133.23,10/Nov/2016:00:01:45 +0800,10,54 ,video,8940 987 125.47.60.164,10/Nov/2016:00:01:45 +0800,10,54 ,video,3521 988 115.193.172.253,10/Nov/2016:00:01:46 +0800,10,72 ,video,3078 989 183.45.120.249,10/Nov/2016:00:01:46 +0800,10,54 ,video,3521 990 114.250.95.200,10/Nov/2016:00:01:46 +0800,10,54 ,video,9973 991 114.248.224.214,10/Nov/2016:00:01:46 +0800,10,6690 ,video,1309 992 221.217.59.20,10/Nov/2016:00:01:46 +0800,10,54 ,video,5647 993 218.85.36.129,10/Nov/2016:00:01:46 +0800,10,54 ,video,12471 994 101.200.101.31,10/Nov/2016:00:01:46 +0800,10,524288 ,video,8175 995 111.85.126.197,10/Nov/2016:00:01:46 +0800,10,54 ,video,4443 996 60.186.194.249,10/Nov/2016:00:01:46 +0800,10,54 ,video,8601 997 171.8.148.158,10/Nov/2016:00:01:46 +0800,10,67 ,video,8292 998 183.45.120.249,10/Nov/2016:00:01:46 +0800,10,67 ,video,13108 999 120.198.231.150,10/Nov/2016:00:01:46 +0800,10,54 ,video,7227 1000 202.119.41.28,10/Nov/2016:00:01:46 +0800,10,4992 ,video,2801 1001 114.242.249.126,10/Nov/2016:00:01:46 +0800,10,54 ,video,11950 1002 117.151.58.220,10/Nov/2016:00:01:46 +0800,10,54 ,video,1805 1003 175.9.181.84,10/Nov/2016:00:01:46 +0800,10,54 ,video,9821 1004 14.219.128.52,10/Nov/2016:00:01:46 +0800,10,6696 ,video,3850 1005 202.119.41.28,10/Nov/2016:00:01:46 +0800,10,2635 ,video,2801 1006 101.30.71.71,10/Nov/2016:00:01:46 +0800,10,54 ,video,8541 1007 120.198.231.151,10/Nov/2016:00:01:46 +0800,10,339 ,video,4246 1008 202.119.41.28,10/Nov/2016:00:01:46 +0800,10,2910 ,video,2801 1009 125.71.99.165,10/Nov/2016:00:01:46 +0800,10,54 ,video,2524 1010 14.219.128.52,10/Nov/2016:00:01:46 +0800,10,72 ,video,3850 1011 1.30.162.63,10/Nov/2016:00:01:46 +0800,10,54 ,video,3639 1012 202.119.41.28,10/Nov/2016:00:01:46 +0800,10,348 ,video,2801 1013 61.154.14.45,10/Nov/2016:00:01:46 +0800,10,54 ,video,11704 1014 183.12.65.111,10/Nov/2016:00:01:47 +0800,10,54 ,video,2803 1015 221.233.125.242,10/Nov/2016:00:01:47 +0800,10,54 ,video,2949 1016 223.93.140.242,10/Nov/2016:00:01:47 +0800,10,54 ,video,9277 1017 117.152.72.30,10/Nov/2016:00:01:47 +0800,10,54 ,video,8743 1018 119.131.143.179,10/Nov/2016:00:01:47 +0800,10,1422 ,video,2402 1019 113.120.48.150,10/Nov/2016:00:01:47 +0800,10,54 ,video,5868 1020 120.198.231.151,10/Nov/2016:00:01:47 +0800,10,66 ,video,4246 1021 202.119.41.28,10/Nov/2016:00:01:47 +0800,10,4547 ,video,2801 1022 119.131.143.179,10/Nov/2016:00:01:47 +0800,10,2959 ,video,2402 1023 39.186.247.142,10/Nov/2016:00:01:47 +0800,10,54 ,video,2168 1024 112.64.60.228,10/Nov/2016:00:01:47 +0800,10,67 ,video,5995 1025 202.119.41.28,10/Nov/2016:00:01:47 +0800,10,4253 ,video,2801 1026 218.18.222.206,10/Nov/2016:00:01:47 +0800,10,54 ,video,481 1027 120.39.8.104,10/Nov/2016:00:01:47 +0800,10,54 ,video,6688 1028 119.131.143.179,10/Nov/2016:00:01:47 +0800,10,17700 ,video,2402 1029 119.39.67.214,10/Nov/2016:00:01:47 +0800,10,54 ,video,1459 1030 120.198.231.151,10/Nov/2016:00:01:47 +0800,10,312 ,video,4246 1031 120.198.231.152,10/Nov/2016:00:01:47 +0800,10,67 ,video,11671 1032 218.29.60.105,10/Nov/2016:00:01:47 +0800,10,54 ,video,12485 1033 221.11.20.109,10/Nov/2016:00:01:47 +0800,10,54 ,video,5475 1034 119.131.143.179,10/Nov/2016:00:01:47 +0800,10,72 ,video,2402 1035 113.87.161.137,10/Nov/2016:00:01:47 +0800,10,6361 ,video,8006 1036 202.119.41.28,10/Nov/2016:00:01:47 +0800,10,9013 ,video,2801 1037 125.71.163.15,10/Nov/2016:00:01:47 +0800,10,54 ,video,12898 1038 202.119.41.28,10/Nov/2016:00:01:47 +0800,10,72 ,video,2801 1039 114.242.167.68,10/Nov/2016:00:01:47 +0800,10,54 ,video,4451 1040 120.236.154.145,10/Nov/2016:00:01:48 +0800,10,54 ,video,8990 1041 119.131.143.179,10/Nov/2016:00:01:48 +0800,10,66 ,video,2402 1042 171.34.223.30,10/Nov/2016:00:01:48 +0800,10,54 ,video,3663 1043 119.131.143.179,10/Nov/2016:00:01:48 +0800,10,390 ,video,2402 1044 219.82.237.114,10/Nov/2016:00:01:48 +0800,10,54 ,video,1501 1045 120.198.231.151,10/Nov/2016:00:01:48 +0800,10,72 ,video,4246 1046 171.113.106.131,10/Nov/2016:00:01:48 +0800,10,54 ,video,12136 1047 14.219.128.52,10/Nov/2016:00:01:48 +0800,10,6696 ,video,3850 1048 119.131.143.179,10/Nov/2016:00:01:48 +0800,10,1081 ,video,2402 1049 119.131.143.179,10/Nov/2016:00:01:48 +0800,10,4373 ,video,2402 1050 221.226.97.31,10/Nov/2016:00:01:48 +0800,10,54 ,video,4980 1051 14.120.160.170,10/Nov/2016:00:01:48 +0800,10,54 ,video,6407 1052 223.72.105.208,10/Nov/2016:00:01:48 +0800,10,54 ,video,5646 1053 173.254.225.7,10/Nov/2016:00:01:48 +0800,10,5 ,video,12814 1054 222.216.31.41,10/Nov/2016:00:01:48 +0800,10,54 ,video,1706 1055 101.229.244.33,10/Nov/2016:00:01:48 +0800,10,353 ,video,2030 1056 112.10.158.199,10/Nov/2016:00:01:48 +0800,10,54 ,video,7647 1057 115.156.237.9,10/Nov/2016:00:01:48 +0800,10,67 ,video,10966 1058 125.119.38.58,10/Nov/2016:00:01:49 +0800,10,67 ,video,12560 1059 125.90.49.233,10/Nov/2016:00:01:49 +0800,10,54 ,video,7714 1060 106.185.43.251,10/Nov/2016:00:01:49 +0800,10,72 ,video,11950 1061 180.155.124.103,10/Nov/2016:00:01:49 +0800,10,67 ,video,4710 1062 61.51.249.58,10/Nov/2016:00:01:49 +0800,10,54 ,video,1627 1063 183.240.27.98,10/Nov/2016:00:01:49 +0800,10,66 ,video,2779 1064 119.131.143.179,10/Nov/2016:00:01:49 +0800,10,354 ,video,2402 1065 101.229.244.33,10/Nov/2016:00:01:49 +0800,10,1246 ,video,2030 1066 180.155.124.103,10/Nov/2016:00:01:49 +0800,10,67 ,video,5984 1067 101.69.240.6,10/Nov/2016:00:01:49 +0800,10,54 ,video,4441 1068 58.249.67.242,10/Nov/2016:00:01:49 +0800,10,67 ,video,11018 1069 27.18.106.137,10/Nov/2016:00:01:49 +0800,10,54 ,video,6710 1070 101.229.244.33,10/Nov/2016:00:01:49 +0800,10,72 ,video,2030 1071 125.119.38.58,10/Nov/2016:00:01:49 +0800,10,6152 ,video,12560 1072 111.201.154.45,10/Nov/2016:00:01:49 +0800,10,54 ,video,11614 1073 119.131.143.179,10/Nov/2016:00:01:49 +0800,10,354 ,video,2402 1074 123.82.184.10,10/Nov/2016:00:01:49 +0800,10,54 ,video,4417 1075 175.25.164.134,10/Nov/2016:00:01:49 +0800,10,54 ,video,8086 1076 117.151.45.16,10/Nov/2016:00:01:49 +0800,10,54 ,video,7423 1077 125.119.38.58,10/Nov/2016:00:01:49 +0800,10,2958 ,video,12552 1078 101.229.244.33,10/Nov/2016:00:01:49 +0800,10,2700 ,video,2030 1079 120.41.120.245,10/Nov/2016:00:01:49 +0800,10,141 ,video,5984 1080 113.140.11.120,10/Nov/2016:00:01:49 +0800,10,54 ,video,1448 1081 120.236.174.170,10/Nov/2016:00:01:49 +0800,10,54 ,video,2007 1082 101.229.244.33,10/Nov/2016:00:01:49 +0800,10,4285 ,video,2030 1083 101.229.244.33,10/Nov/2016:00:01:49 +0800,10,137 ,video,2030 1084 173.254.225.7,10/Nov/2016:00:01:49 +0800,10,1774 ,video,12814 1085 218.30.109.26,10/Nov/2016:00:01:49 +0800,10,54 ,video,5940 1086 115.236.164.58,10/Nov/2016:00:01:49 +0800,10,54 ,video,1803 1087 182.119.231.213,10/Nov/2016:00:01:49 +0800,10,54 ,video,4187 1088 114.255.40.55,10/Nov/2016:00:01:49 +0800,10,54 ,video,5537 1089 59.40.133.15,10/Nov/2016:00:01:49 +0800,10,67 ,video,7846 1090 183.157.31.247,10/Nov/2016:00:01:49 +0800,10,329 ,video,12552 1091 222.44.80.121,10/Nov/2016:00:01:49 +0800,10,54 ,video,492 1092 183.240.27.98,10/Nov/2016:00:01:49 +0800,10,72 ,video,2779 1093 122.70.48.217,10/Nov/2016:00:01:49 +0800,10,54 ,video,12499 1094 115.60.58.190,10/Nov/2016:00:01:49 +0800,10,54 ,video,2496 1095 183.157.31.247,10/Nov/2016:00:01:49 +0800,10,74 ,video,12552 1096 101.229.244.33,10/Nov/2016:00:01:49 +0800,10,353 ,video,2030 1097 123.182.240.4,10/Nov/2016:00:01:50 +0800,10,141 ,video,6553 1098 14.219.128.52,10/Nov/2016:00:01:50 +0800,10,54 ,video,3850 1099 111.198.26.195,10/Nov/2016:00:01:50 +0800,10,54 ,video,4187 1100 120.198.231.154,10/Nov/2016:00:01:50 +0800,10,67 ,video,456 1101 183.240.27.98,10/Nov/2016:00:01:50 +0800,10,1188 ,video,2779 1102 119.131.153.247,10/Nov/2016:00:01:50 +0800,10,54 ,video,1948 1103 42.236.157.243,10/Nov/2016:00:01:50 +0800,10,141 ,video,10694 1104 59.63.249.142,10/Nov/2016:00:01:50 +0800,10,54 ,video,7254 1105 120.52.92.2,10/Nov/2016:00:01:50 +0800,10,67 ,video,13171 1106 218.17.157.250,10/Nov/2016:00:01:50 +0800,10,54 ,video,11201 1107 116.77.239.141,10/Nov/2016:00:01:50 +0800,10,2957 ,video,6541 1108 59.46.24.56,10/Nov/2016:00:01:50 +0800,10,54 ,video,5639 1109 119.131.143.179,10/Nov/2016:00:01:50 +0800,10,2635 ,video,2402 1110 124.205.5.242,10/Nov/2016:00:01:50 +0800,10,54 ,video,2170 1111 101.229.244.33,10/Nov/2016:00:01:50 +0800,10,1891 ,video,2030 1112 125.119.38.58,10/Nov/2016:00:01:50 +0800,10,621 ,video,12552 1113 218.244.198.7,10/Nov/2016:00:01:50 +0800,10,54 ,video,1803 1114 116.77.239.141,10/Nov/2016:00:01:50 +0800,10,322 ,video,6541 1115 101.229.244.33,10/Nov/2016:00:01:50 +0800,10,4285 ,video,2030 1116 119.101.92.177,10/Nov/2016:00:01:50 +0800,10,54 ,video,1430 1117 124.193.169.82,10/Nov/2016:00:01:50 +0800,10,54 ,video,12051 1118 112.10.127.193,10/Nov/2016:00:01:50 +0800,10,54 ,video,9819 1119 183.11.223.82,10/Nov/2016:00:01:50 +0800,10,54 ,video,10652 1120 125.119.38.58,10/Nov/2016:00:01:50 +0800,10,141 ,video,12552 1121 183.157.31.247,10/Nov/2016:00:01:50 +0800,10,3705 ,video,12552 1122 119.131.143.179,10/Nov/2016:00:01:50 +0800,10,4465 ,video,2402 1123 114.248.224.214,10/Nov/2016:00:01:50 +0800,10,54 ,video,1309 1124 125.119.38.58,10/Nov/2016:00:01:50 +0800,10,3705 ,video,12552 1125 115.216.30.106,10/Nov/2016:00:01:50 +0800,10,54 ,video,9136 1126 47.88.213.206,10/Nov/2016:00:01:50 +0800,10,54 ,video,5553 1127 183.240.27.98,10/Nov/2016:00:01:50 +0800,10,2345 ,video,2779 1128 101.229.244.33,10/Nov/2016:00:01:50 +0800,10,342 ,video,2030 1129 101.229.244.33,10/Nov/2016:00:01:50 +0800,10,74 ,video,2030 1130 183.157.31.247,10/Nov/2016:00:01:50 +0800,10,312 ,video,12552 1131 117.147.54.119,10/Nov/2016:00:01:50 +0800,10,54 ,video,2210 1132 114.248.224.214,10/Nov/2016:00:01:50 +0800,10,8875 ,video,1309 1133 124.79.111.37,10/Nov/2016:00:01:50 +0800,10,54 ,video,10834 1134 116.77.239.141,10/Nov/2016:00:01:50 +0800,10,322 ,video,6541 1135 125.119.38.58,10/Nov/2016:00:01:50 +0800,10,2472 ,video,12552 1136 119.131.143.179,10/Nov/2016:00:01:50 +0800,10,327 ,video,2402 1137 116.77.239.141,10/Nov/2016:00:01:50 +0800,10,66 ,video,6541 1138 117.147.54.119,10/Nov/2016:00:01:50 +0800,10,67 ,video,10656 1139 58.100.180.246,10/Nov/2016:00:01:50 +0800,10,54 ,video,3628 1140 123.14.16.49,10/Nov/2016:00:01:50 +0800,10,54 ,video,3296 1141 115.231.149.114,10/Nov/2016:00:01:50 +0800,10,54 ,video,11330 1142 125.119.38.58,10/Nov/2016:00:01:51 +0800,10,72 ,video,12552 1143 101.229.244.33,10/Nov/2016:00:01:51 +0800,10,6382 ,video,2030 1144 183.240.27.98,10/Nov/2016:00:01:51 +0800,10,7753 ,video,2779 1145 222.79.80.123,10/Nov/2016:00:01:51 +0800,10,67 ,video,2032 1146 124.207.69.26,10/Nov/2016:00:01:51 +0800,10,54 ,video,2138 1147 183.17.238.190,10/Nov/2016:00:01:51 +0800,10,54 ,video,9885 1148 58.135.115.122,10/Nov/2016:00:01:51 +0800,10,54 ,video,394 1149 183.240.27.98,10/Nov/2016:00:01:51 +0800,10,4519 ,video,2779 1150 219.143.13.59,10/Nov/2016:00:01:51 +0800,10,54 ,video,3474 1151 101.229.244.33,10/Nov/2016:00:01:51 +0800,10,72 ,video,2030 1152 122.224.99.166,10/Nov/2016:00:01:51 +0800,10,54 ,video,7857 1153 183.128.164.83,10/Nov/2016:00:01:51 +0800,10,54 ,video,10802 1154 140.205.253.147,10/Nov/2016:00:01:51 +0800,10,524288 ,video,2030 1155 125.119.38.58,10/Nov/2016:00:01:51 +0800,10,6152 ,video,12552 1156 183.240.27.98,10/Nov/2016:00:01:51 +0800,10,361 ,video,2779 1157 59.42.206.250,10/Nov/2016:00:01:51 +0800,10,67 ,video,12466 1158 180.167.7.200,10/Nov/2016:00:01:51 +0800,10,54 ,video,3479 1159 218.28.137.3,10/Nov/2016:00:01:51 +0800,10,54 ,video,4018 1160 120.198.231.152,10/Nov/2016:00:01:51 +0800,10,67 ,video,7475 1161 125.119.38.58,10/Nov/2016:00:01:51 +0800,10,72 ,video,12552 1162 101.229.244.33,10/Nov/2016:00:01:51 +0800,10,6382 ,video,2030 1163 119.131.143.179,10/Nov/2016:00:01:51 +0800,10,72 ,video,2402 1164 110.17.128.214,10/Nov/2016:00:01:51 +0800,10,54 ,video,4443 1165 125.119.38.58,10/Nov/2016:00:01:51 +0800,10,66 ,video,12552 1166 45.78.18.110,10/Nov/2016:00:01:51 +0800,10,54 ,video,4451 1167 202.119.41.28,10/Nov/2016:00:01:51 +0800,10,9013 ,video,2801 1168 182.100.43.246,10/Nov/2016:00:01:51 +0800,10,67 ,video,8322 1169 39.184.237.240,10/Nov/2016:00:01:51 +0800,10,66 ,video,10686 1170 183.240.27.98,10/Nov/2016:00:01:51 +0800,10,2865 ,video,2779 1171 115.35.190.57,10/Nov/2016:00:01:51 +0800,10,54 ,video,11825 1172 125.119.38.58,10/Nov/2016:00:01:51 +0800,10,6152 ,video,12552 1173 101.38.157.182,10/Nov/2016:00:01:51 +0800,10,67 ,video,2163 1174 116.77.239.141,10/Nov/2016:00:01:51 +0800,10,4882 ,video,6541 1175 115.174.68.92,10/Nov/2016:00:01:51 +0800,10,67 ,video,9804 1176 125.119.38.58,10/Nov/2016:00:01:51 +0800,10,329 ,video,12552 1177 125.81.90.200,10/Nov/2016:00:01:51 +0800,10,54 ,video,8143 1178 39.184.237.240,10/Nov/2016:00:01:52 +0800,10,72 ,video,10686 1179 183.240.27.98,10/Nov/2016:00:01:52 +0800,10,7753 ,video,2779 1180 116.213.171.153,10/Nov/2016:00:01:52 +0800,10,54 ,video,1748 1181 140.205.253.135,10/Nov/2016:00:01:52 +0800,10,524288 ,video,11724 1182 58.48.139.85,10/Nov/2016:00:01:52 +0800,10,54 ,video,9088 1183 183.45.18.241,10/Nov/2016:00:01:52 +0800,10,54 ,video,7726 1184 112.16.92.55,10/Nov/2016:00:01:52 +0800,10,54 ,video,3661 1185 125.119.38.58,10/Nov/2016:00:01:52 +0800,10,2195 ,video,12552 1186 116.77.239.141,10/Nov/2016:00:01:52 +0800,10,72 ,video,6541 1187 222.35.76.74,10/Nov/2016:00:01:52 +0800,10,54 ,video,2938 1188 59.33.240.171,10/Nov/2016:00:01:52 +0800,10,54 ,video,10290 1189 140.205.253.135,10/Nov/2016:00:01:52 +0800,10,524288 ,video,11724 1190 125.122.26.81,10/Nov/2016:00:01:52 +0800,10,141 ,video,3225 1191 39.184.237.240,10/Nov/2016:00:01:52 +0800,10,2411 ,video,10686 1192 116.77.239.141,10/Nov/2016:00:01:52 +0800,10,54 ,video,6541 1193 45.115.145.36,10/Nov/2016:00:01:52 +0800,10,54 ,video,3474 1194 59.111.99.119,10/Nov/2016:00:01:52 +0800,10,54 ,video,1625 1195 120.52.94.109,10/Nov/2016:00:01:52 +0800,10,54 ,video,4588 1196 39.184.237.240,10/Nov/2016:00:01:52 +0800,10,312 ,video,10686 1197 122.224.33.106,10/Nov/2016:00:01:52 +0800,10,54 ,video,1090 1198 183.60.162.112,10/Nov/2016:00:01:52 +0800,10,6127 ,video,12353 1199 183.60.162.107,10/Nov/2016:00:01:52 +0800,10,54 ,video,7767 1200 39.184.237.240,10/Nov/2016:00:01:52 +0800,10,361 ,video,10686 1201 42.234.105.133,10/Nov/2016:00:01:52 +0800,10,54 ,video,2860 1202 39.184.237.240,10/Nov/2016:00:01:52 +0800,10,2353 ,video,10686 1203 60.22.87.125,10/Nov/2016:00:01:52 +0800,10,54 ,video,1336 1204 101.200.101.21,10/Nov/2016:00:01:53 +0800,10,524288 ,video,10506 1205 58.248.197.207,10/Nov/2016:00:01:53 +0800,10,67 ,video,7063 1206 171.217.174.22,10/Nov/2016:00:01:53 +0800,10,54 ,video,4215 1207 60.191.78.148,10/Nov/2016:00:01:53 +0800,10,54 ,video,3590 1208 116.77.239.141,10/Nov/2016:00:01:53 +0800,10,7663 ,video,6541 1209 119.57.253.66,10/Nov/2016:00:01:53 +0800,10,54 ,video,2752 1210 39.184.237.240,10/Nov/2016:00:01:53 +0800,10,6685 ,video,10686 1211 180.160.68.63,10/Nov/2016:00:01:53 +0800,10,141 ,video,2634 1212 222.178.202.115,10/Nov/2016:00:01:53 +0800,10,54 ,video,3305 1213 140.207.223.189,10/Nov/2016:00:01:53 +0800,10,67 ,video,13192 1214 117.181.194.121,10/Nov/2016:00:01:53 +0800,10,54 ,video,2314 1215 210.30.109.61,10/Nov/2016:00:01:53 +0800,10,67 ,video,5911 1216 39.184.237.240,10/Nov/2016:00:01:53 +0800,10,3758 ,video,10686 1217 14.145.74.175,10/Nov/2016:00:01:53 +0800,10,54 ,video,678
关键代码:
数据清洗:
AccessLogCleanMapper:
定义常量,设置时间格式,并设置方法进行时间格式转化:
重写map方法,将数据分割后,取出,封装发送;
AccessLogCleanReduce:
接收写出;
AccessLogWritable:
在封装类中,需要重写这几个方法,用于序列化和反序列化对于字节的读取以及toString方法的返回格式:
数据输出(二次排序):
一次排序的话按照MapReduce的WordCount的排序方式就可以。
二次排序时,将统计到的数据全部分装到key中进行发送,并且重写CompareTo方法进行降序排序。
将数据存储到hive:
利用命令可以从hdfs上将数据按照一定格式进行上传到表中。
1 create table data( ip string, time string , day string, traffic bigint,type string, id string )row format delimited fields terminated by "," ; 2 //创建表,处理以逗号隔开的数据 3 show tables; 4 5 load data inpath '文件地址' into table data; 6 //将hdfs上的文件上传到hive中 7 select * from data;
最后进行数据的可视化展示,利用echarts就可以。
说实话,第一次练手做的很是不满意,很多细节的点Git不到。在做的过程中还信心满满,但是越做越满手。本来还想的使用hive仓库进行操作(那样会更简单),但是在连接的过程中,一段操作猛如虎,最后还是不能进行正常的连接,没办法,索性就用二次排序了。但是做完事后还是发现使用TreeMap更加符合这次的要求,接下来会进行代码的优化,还会继续上传到github中的。
说实在的,还是得把基础打牢啊,所以,对于这次的代码,个人感觉写的很烂,事实就是这样,欠的,迟早是要还的。