千里碼豆瓣評(píng)分爬取

千里碼
 豆瓣評(píng)分爬取
 豆瓣電影Top250收錄了至今為止，大家最喜歡的250部電影砂吞。
該列表呈現(xiàn)了每部電影的評(píng)分铃将，年份等基本信息。
這題的答案很簡(jiǎn)單侦厚，就是這個(gè)榜單的前166部電影的評(píng)分總和耻陕。

千里碼：

豆瓣評(píng)分爬取

# -*- coding: UTF-8 -*-
import urllib2
import requests , re
import sys , MySQLdb
import random

reload ( sys )
sys.setdefaultencoding ( 'utf-8' )
Type = sys.getfilesystemencoding ()
# 數(shù)據(jù)庫(kù)設(shè)置
MYSQL_HOST = 'localhost'
MYSQL_DBNAME = 'ip'
MYSQL_USER = 'mark'
MYSQL_PASSWD = '****'
MYSQL_PORT = 3306

# 此處修改偽造的頭字段,
headers = {
    'User-Agent': 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11'}

#獲取代理
def getProxy ( conn , cur , columns_data ):
    flag = random.choice ( columns_data )
    sql = "select proxy_ip,proxy_port from proxy where id =%d" % (flag)
    cur.execute ( sql )
    proxy = {}
    for each in cur.fetchall ():
        proxy[ 'http' ] = "http://%s:%s" % (each[ 0 ] , each[ 1 ])
    try:
        requests.get ( 'https://movie.douban.com/top250' , proxies=proxy )
    except:
        print "proxy error"
        getProxy ( conn , cur , columns_data )
    else:
        print "proxy success"
        return proxy

#獲取請(qǐng)求的HTML頁(yè)面
def get_request ( url , headers , conn , cur , columns_data ):
    proxy = getProxy ( conn , cur , columns_data )
    proxy_s = urllib2.ProxyHandler ( proxy )
    opener = urllib2.build_opener ( proxy_s )
    urllib2.install_opener ( opener )
    req = urllib2.Request ( url , headers=headers )
    r = urllib2.urlopen ( req )
    return r.read ()


if __name__ == "__main__":
    conn = MySQLdb.connect ( host=MYSQL_HOST , user=MYSQL_USER , passwd=MYSQL_PASSWD , db=MYSQL_DBNAME ,
                             port=MYSQL_PORT , charset='utf8' )
    cur = conn.cursor ()

    columns = "select id from proxy"
    cur.execute ( columns )
    columns_data = [ ]
    for each in cur.fetchall ():
        columns_data.append ( each[ 0 ] )

    url_total = [ 'https://movie.douban.com/top250?start=%d&filter=' % (each * 25) for each in range ( 7 ) ]
    print url_total
    data = [ ]
    for each in url_total:
        print each
        html = get_request ( each , headers , conn , cur , columns_data )
        re_str = r'<span class="rating_num" property="v:average">(\S+)</span>'
        for ebch in re.findall ( re_str , html ):
            data.append ( float ( str ( ebch ) ) )
    print data
    data = sorted ( data )
    print sum ( data[ :166 ] )

上述代碼中對(duì)應(yīng)的代理IP地址的SQL文件

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for proxy
-- ----------------------------
DROP TABLE IF EXISTS `proxy`;
CREATE TABLE `proxy` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `proxy_ip` varchar(255) NOT NULL,
  `proxy_port` int(11) DEFAULT NULL,
  `proxy_country` varchar(255) DEFAULT NULL,
  `proxy_type` varchar(255) DEFAULT NULL,
  `addtime` varchar(255) DEFAULT NULL,
  `last_test_time` varchar(255) DEFAULT NULL,
  `proxy_status` varchar(255) DEFAULT NULL,
  `Remarks` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=351 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of proxy
-- ----------------------------
INSERT INTO `proxy` VALUES ('126', '219.238.124.221', '3128', 'China', 'Transparent', 'Tue Sep 26 21:06:32 2017', '11 28', '1', 'ly');
INSERT INTO `proxy` VALUES ('127', '61.153.67.110', '9999', 'China', 'Elite', 'Tue Sep 26 21:06:32 2017', '11 26', '1', 'ly');
INSERT INTO `proxy` VALUES ('128', '47.93.63.47', '8888', 'China', 'Elite', 'Tue Sep 26 21:06:32 2017', '11 26', '1', 'ly');
INSERT INTO `proxy` VALUES ('129', '101.37.79.125', '3128', 'China', 'Transparent', 'Tue Sep 26 21:06:32 2017', '10 43', '1', 'ly');
INSERT INTO `proxy` VALUES ('130', '203.91.121.76', '3128', 'China', 'Transparent', 'Tue Sep 26 21:06:32 2017', '7 14', '1', 'ly');
INSERT INTO `proxy` VALUES ('131', '61.136.163.245', '3128', 'China', 'Transparent', 'Tue Sep 26 21:06:32 2017', '6 29', '1', 'ly');
INSERT INTO `proxy` VALUES ('132', '58.22.61.211', '3128', 'China', 'Transparent', 'Tue Sep 26 21:06:32 2017', '6 25', '1', 'ly');
INSERT INTO `proxy` VALUES ('133', '42.51.26.79', '3128', 'China', 'Transparent', 'Tue Sep 26 21:06:32 2017', '6 24', '1', 'ly');
INSERT INTO `proxy` VALUES ('134', '61.153.108.142', '80', 'China', 'Transparent', 'Tue Sep 26 21:06:32 2017', '6 2', '1', 'ly');
INSERT INTO `proxy` VALUES ('135', '110.53.202.169', '808', 'China', 'Transparent', 'Tue Sep 26 21:06:32 2017', '5 53', '1', 'ly');
INSERT INTO `proxy` VALUES ('136', '117.141.18.70', '65205', 'China', 'Elite', 'Tue Sep 26 21:06:32 2017', '5 45', '1', 'ly');
INSERT INTO `proxy` VALUES ('137', '122.226.183.145', '80', 'China', 'Transparent', 'Tue Sep 26 21:06:32 2017', '5 40', '1', 'ly');
INSERT INTO `proxy` VALUES ('138', '43.241.10.206', '8080', 'China', 'Elite', 'Tue Sep 26 21:06:32 2017', '5 40', '1', 'ly');
INSERT INTO `proxy` VALUES ('139', '123.118.34.110', '9000', 'China', 'Transparent', 'Tue Sep 26 21:06:32 2017', '5 26', '1', 'ly');
INSERT INTO `proxy` VALUES ('140', '124.238.235.135', '81', 'China', 'Elite', 'Tue Sep 26 21:06:32 2017', '5 11', '1', 'ly');
INSERT INTO `proxy` VALUES ('141', '222.185.137.204', '808', 'China', 'Elite', 'Tue Sep 26 21:06:32 2017', '5 1', '1', 'ly');
INSERT INTO `proxy` VALUES ('142', '101.4.136.34', '80', 'China', 'Elite', 'Tue Sep 26 21:06:32 2017', '4 59', '1', 'ly');
INSERT INTO `proxy` VALUES ('143', '122.72.99.104', '80', 'China', 'Transparent', 'Tue Sep 26 21:06:32 2017', '4 55', '1', 'ly');
INSERT INTO `proxy` VALUES ('144', '114.215.103.121', '8081', 'China', 'Elite', 'Tue Sep 26 21:06:32 2017', '4 52', '1', 'ly');
INSERT INTO `proxy` VALUES ('145', '159.226.249.93', '8080', 'China', 'Transparent', 'Tue Sep 26 21:06:32 2017', '4 48', '1', 'ly');
INSERT INTO `proxy` VALUES ('146', '106.14.51.145', '8118', 'China', 'Elite', 'Tue Sep 26 21:06:32 2017', '4 41', '1', 'ly');
INSERT INTO `proxy` VALUES ('147', '122.72.18.35', '80', 'China', 'Transparent', 'Tue Sep 26 21:06:32 2017', '4 39', '1', 'ly');
INSERT INTO `proxy` VALUES ('148', '123.7.82.20', '3128', 'China', 'Transparent', 'Tue Sep 26 21:06:32 2017', '3 35', '1', 'ly');
INSERT INTO `proxy` VALUES ('149', '122.228.179.178', '80', 'China', 'Elite', 'Tue Sep 26 21:06:32 2017', '3 28', '1', 'ly');
INSERT INTO `proxy` VALUES ('150', '123.147.165.144', '8080', 'China', 'Transparent', 'Tue Sep 26 21:06:32 2017', '2 58', '1', 'ly');
INSERT INTO `proxy` VALUES ('251', '203.88.210.121', '138', 'China', 'Elite', '17-09-26 21:04', '200天', '1', 'ly');
INSERT INTO `proxy` VALUES ('252', '117.84.205.140', '8118', 'China', 'Elite', '17-09-26 21:02', '1天', '1', 'ly');
INSERT INTO `proxy` VALUES ('253', '122.72.32.74', '80', 'China', 'Elite', '17-09-26 21:02', '335天', '1', 'ly');
INSERT INTO `proxy` VALUES ('254', '49.77.210.116', '27475', 'China', 'Elite', '17-09-26 21:01', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('255', '121.204.165.35', '8118', 'China', 'Elite', '17-09-26 21:01', '265天', '1', 'ly');
INSERT INTO `proxy` VALUES ('256', '49.64.103.196', '44074', 'China', 'Elite', '17-09-26 21:01', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('257', '60.169.220.213', '28481', 'China', 'Elite', '17-09-26 21:01', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('258', '61.135.217.7', '80', 'China', 'Elite', '17-09-26 21:01', '501天', '1', 'ly');
INSERT INTO `proxy` VALUES ('259', '123.160.26.198', '32721', 'China', 'Elite', '17-09-26 21:00', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('260', '123.162.201.88', '39428', 'China', 'Elite', '17-09-26 21:00', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('261', '140.255.255.169', '8118', 'China', 'Elite', '17-09-26 20:55', '15小時(shí)', '1', 'ly');
INSERT INTO `proxy` VALUES ('262', '171.39.29.221', '8123', 'China', 'Elite', '17-09-26 20:55', '62天', '1', 'ly');
INSERT INTO `proxy` VALUES ('263', '27.159.125.151', '8118', 'China', 'Elite', '17-09-26 20:53', '2小時(shí)', '1', 'ly');
INSERT INTO `proxy` VALUES ('264', '60.255.186.169', '8888', 'China', 'Elite', '17-09-26 20:52', '43天', '1', 'ly');
INSERT INTO `proxy` VALUES ('265', '36.251.248.76', '80', 'China', 'Elite', '17-09-26 20:51', '20天', '1', 'ly');
INSERT INTO `proxy` VALUES ('266', '121.12.42.181', '61234', 'China', 'Elite', '17-09-26 20:50', '25天', '1', 'ly');
INSERT INTO `proxy` VALUES ('267', '120.78.15.63', '80', 'China', 'Elite', '17-09-26 20:46', '9天', '1', 'ly');
INSERT INTO `proxy` VALUES ('268', '121.12.42.10', '61234', 'China', 'Elite', '17-09-26 20:45', '19天', '1', 'ly');
INSERT INTO `proxy` VALUES ('269', '115.218.83.192', '80', 'China', 'Elite', '17-09-26 20:44', '1天', '1', 'ly');
INSERT INTO `proxy` VALUES ('270', '49.81.250.174', '8118', 'China', 'Elite', '17-09-26 20:43', '14小時(shí)', '1', 'ly');
INSERT INTO `proxy` VALUES ('271', '36.102.62.45', '80', 'China', 'Elite', '17-09-26 20:36', '6天', '1', 'ly');
INSERT INTO `proxy` VALUES ('272', '101.68.73.54', '53281', 'China', 'Elite', '17-09-26 20:33', '41天', '1', 'ly');
INSERT INTO `proxy` VALUES ('273', '180.118.243.174', '61234', 'China', 'Elite', '17-09-26 20:33', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('274', '117.69.2.252', '20037', 'China', 'Elite', '17-09-26 20:33', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('275', '1.195.10.101', '34401', 'China', 'Elite', '17-09-26 20:33', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('276', '110.73.15.7', '8123', 'China', 'Elite', '17-09-26 20:33', '16天', '1', 'ly');
INSERT INTO `proxy` VALUES ('277', '222.163.214.90', '8118', 'China', 'Elite', '17-09-26 20:30', '18小時(shí)', '1', 'ly');
INSERT INTO `proxy` VALUES ('278', '113.120.132.122', '8118', 'China', 'Elite', '17-09-26 20:23', '1天', '1', 'ly');
INSERT INTO `proxy` VALUES ('279', '110.73.50.141', '8123', 'China', 'Elite', '17-09-26 20:22', '552天', '1', 'ly');
INSERT INTO `proxy` VALUES ('280', '110.73.42.169', '8123', 'China', 'Elite', '17-09-26 20:15', '21天', '1', 'ly');
INSERT INTO `proxy` VALUES ('281', '120.42.125.1', '28771', 'China', 'Elite', '17-09-26 20:11', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('282', '115.217.254.189', '30134', 'China', 'Elite', '17-09-26 20:11', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('283', '110.182.50.43', '8118', 'China', 'Elite', '17-09-26 20:04', '2天', '1', 'ly');
INSERT INTO `proxy` VALUES ('284', '111.155.116.245', '8123', 'China', 'Elite', '17-09-26 20:04', '212天', '1', 'ly');
INSERT INTO `proxy` VALUES ('285', '122.72.32.88', '80', 'China', 'Elite', '17-09-26 20:01', '335天', '1', 'ly');
INSERT INTO `proxy` VALUES ('286', '180.122.155.128', '33103', 'China', 'Elite', '17-09-26 20:00', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('287', '144.12.30.69', '4382', 'China', 'Elite', '17-09-26 20:00', '1天', '1', 'ly');
INSERT INTO `proxy` VALUES ('288', '122.242.94.63', '38006', 'China', 'Elite', '17-09-26 20:00', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('289', '180.120.200.240', '43902', 'China', 'Elite', '17-09-26 20:00', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('290', '1.194.118.164', '22850', 'China', 'Elite', '17-09-26 20:00', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('291', '110.73.52.34', '8123', 'China', 'Elite', '17-09-26 19:55', '705天', '1', 'ly');
INSERT INTO `proxy` VALUES ('292', '222.141.15.186', '8118', 'China', 'Elite', '17-09-26 19:50', '12小時(shí)', '1', 'ly');
INSERT INTO `proxy` VALUES ('293', '123.161.157.78', '43588', 'China', 'Elite', '17-09-26 19:33', '2分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('294', '113.121.250.165', '23785', 'China', 'Elite', '17-09-26 19:31', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('295', '111.155.116.215', '8123', 'China', 'Elite', '17-09-26 19:30', '168天', '1', 'ly');
INSERT INTO `proxy` VALUES ('296', '113.124.92.36', '25869', 'China', 'Elite', '17-09-26 19:30', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('297', '113.107.161.44', '808', 'China', 'Elite', '17-09-26 19:22', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('298', '117.78.37.198', '8000', 'China', 'Elite', '17-09-26 19:21', '56天', '1', 'ly');
INSERT INTO `proxy` VALUES ('299', '180.172.217.173', '34599', 'China', 'Elite', '17-09-26 19:00', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('300', '42.231.1.1', '80', 'China', 'Elite', '17-09-26 19:00', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('301', '115.221.127.232', '41445', 'China', 'Elite', '17-09-26 19:00', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('302', '115.221.127.232', '41445', 'China', 'Elite', '17-09-26 19:00', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('303', '121.31.100.194', '8123', 'China', 'Elite', '17-09-26 18:55', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('304', '49.73.100.36', '8118', 'China', 'Elite', '17-09-26 18:51', '10小時(shí)', '1', 'ly');
INSERT INTO `proxy` VALUES ('305', '121.31.103.233', '8123', 'China', 'Elite', '17-09-26 18:33', '375天', '1', 'ly');
INSERT INTO `proxy` VALUES ('306', '183.63.101.62', '53281', 'China', 'Elite', '17-09-26 18:33', '40天', '1', 'ly');
INSERT INTO `proxy` VALUES ('307', '123.55.191.158', '808', 'China', 'Elite', '17-09-26 18:30', '80天', '1', 'ly');
INSERT INTO `proxy` VALUES ('308', '113.128.27.212', '29016', 'China', 'Elite', '17-09-26 18:30', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('309', '60.24.153.214', '8118', 'China', 'Elite', '17-09-26 18:27', '10小時(shí)', '1', 'ly');
INSERT INTO `proxy` VALUES ('310', '113.249.159.135', '8118', 'China', 'Elite', '17-09-26 18:25', '3小時(shí)', '1', 'ly');
INSERT INTO `proxy` VALUES ('311', '27.184.124.175', '8118', 'China', 'Elite', '17-09-26 18:15', '7小時(shí)', '1', 'ly');
INSERT INTO `proxy` VALUES ('312', '114.95.184.20', '65205', 'China', 'Elite', '17-09-26 18:12', '4小時(shí)', '1', 'ly');
INSERT INTO `proxy` VALUES ('313', '183.63.223.2', '63000', 'China', 'Elite', '17-09-26 17:55', '294天', '1', 'ly');
INSERT INTO `proxy` VALUES ('314', '115.46.122.35', '8123', 'China', 'Elite', '17-09-26 17:44', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('315', '110.182.239.81', '53281', 'China', 'Elite', '17-09-26 17:33', '6天', '1', 'ly');
INSERT INTO `proxy` VALUES ('316', '110.72.218.113', '8123', 'China', 'Elite', '17-09-26 17:33', '516天', '1', 'ly');
INSERT INTO `proxy` VALUES ('317', '121.204.165.172', '8118', 'China', 'Elite', '17-09-26 17:30', '282天', '1', 'ly');
INSERT INTO `proxy` VALUES ('318', '114.89.157.106', '8118', 'China', 'Elite', '17-09-26 17:30', '11小時(shí)', '1', 'ly');
INSERT INTO `proxy` VALUES ('319', '125.78.104.243', '37656', 'China', 'Elite', '17-09-26 17:30', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('320', '171.13.37.235', '808', 'China', 'Elite', '17-09-26 17:30', '159天', '1', 'ly');
INSERT INTO `proxy` VALUES ('321', '117.25.190.25', '808', 'China', 'Elite', '17-09-26 17:30', '112天', '1', 'ly');
INSERT INTO `proxy` VALUES ('322', '180.122.154.118', '22512', 'China', 'Elite', '17-09-26 17:30', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('323', '121.12.42.50', '61234', 'China', 'Elite', '17-09-26 17:27', '6天', '1', 'ly');
INSERT INTO `proxy` VALUES ('324', '115.211.59.117', '8118', 'China', 'Elite', '17-09-26 17:24', '4小時(shí)', '1', 'ly');
INSERT INTO `proxy` VALUES ('325', '121.31.195.82', '8123', 'China', 'Elite', '17-09-26 17:22', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('326', '180.127.149.107', '808', 'China', 'Elite', '17-09-26 17:15', '4小時(shí)', '1', 'ly');
INSERT INTO `proxy` VALUES ('327', '49.77.210.67', '39862', 'China', 'Elite', '17-09-26 17:11', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('328', '60.182.236.230', '37150', 'China', 'Elite', '17-09-26 17:11', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('329', '121.31.102.45', '8123', 'China', 'Elite', '17-09-26 17:11', '207天', '1', 'ly');
INSERT INTO `proxy` VALUES ('330', '60.23.40.20', '80', 'China', 'Elite', '17-09-26 17:00', '3天', '1', 'ly');
INSERT INTO `proxy` VALUES ('331', '115.63.86.209', '80', 'China', 'Elite', '17-09-26 16:44', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('332', '1.63.107.198', '80', 'China', 'Elite', '17-09-26 16:41', '2天', '1', 'ly');
INSERT INTO `proxy` VALUES ('333', '220.166.243.246', '8118', 'China', 'Elite', '17-09-26 16:40', '4天', '1', 'ly');
INSERT INTO `proxy` VALUES ('334', '119.5.177.133', '80', 'China', 'Elite', '17-09-26 16:22', '52天', '1', 'ly');
INSERT INTO `proxy` VALUES ('335', '119.5.177.155', '4386', 'China', 'Elite', '17-09-26 16:22', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('336', '117.95.105.151', '36355', 'China', 'Elite', '17-09-26 16:01', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('337', '59.40.51.253', '8010', 'China', 'Elite', '17-09-26 15:44', '16天', '1', 'ly');
INSERT INTO `proxy` VALUES ('338', '140.250.158.95', '40601', 'China', 'Elite', '17-09-26 15:33', '2分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('339', '49.88.168.166', '46914', 'China', 'Elite', '17-09-26 15:30', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('340', '123.55.3.169', '24281', 'China', 'Elite', '17-09-26 15:30', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('341', '36.25.27.202', '25065', 'China', 'Elite', '17-09-26 15:30', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('342', '110.87.4.118', '27023', 'China', 'Elite', '17-09-26 15:22', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('343', '221.205.61.105', '80', 'China', 'Elite', '17-09-26 15:22', '6小時(shí)', '1', 'ly');
INSERT INTO `proxy` VALUES ('344', '49.87.177.104', '32659', 'China', 'Elite', '17-09-26 15:11', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('345', '59.49.129.60', '8998', 'China', 'Elite', '17-09-26 15:09', '219天', '1', 'ly');
INSERT INTO `proxy` VALUES ('346', '218.5.161.215', '35216', 'China', 'Elite', '17-09-26 15:00', '1分鐘', '1', 'ly');
INSERT INTO `proxy` VALUES ('347', '27.40.143.209', '61234', 'China', 'Elite', '17-09-26 14:56', '6小時(shí)', '1', 'ly');
INSERT INTO `proxy` VALUES ('348', '110.73.8.214', '8123', 'China', 'Elite', '17-09-26 14:45', '208天', '1', 'ly');
INSERT INTO `proxy` VALUES ('349', '180.118.240.167', '61234', 'China', 'Elite', '17-09-26 14:34', '2小時(shí)', '1', 'ly');
INSERT INTO `proxy` VALUES ('350', '61.142.240.132', '808', 'China', 'Elite', '17-09-26 14:34', '102天', '1', 'ly');

最后編輯于：2017.12.10 19:14:09

?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請(qǐng)聯(lián)系作者

人面猴
序言：七十年代末，一起剝皮案震驚了整個(gè)濱河市假夺，隨后出現(xiàn)的幾起案子，更是在濱河造成了極大的恐慌斋攀，老刑警劉巖已卷，帶你破解...
沈念sama閱讀 211,123評(píng)論 6贊 490
死咒
序言：濱河連續(xù)發(fā)生了三起死亡事件，死亡現(xiàn)場(chǎng)離奇詭異淳蔼，居然都是意外死亡侧蘸，警方通過(guò)查閱死者的電腦和手機(jī)，發(fā)現(xiàn)死者居然都...
沈念sama閱讀 90,031評(píng)論 2贊 384
救了他兩次的神仙讓他今天三更去死
文/潘曉璐我一進(jìn)店門鹉梨，熙熙樓的掌柜王于貴愁眉苦臉地迎上來(lái)讳癌，“玉大人，你說(shuō)我怎么就攤上這事存皂∩卫ぃ” “怎么了？”我有些...
開(kāi)封第一講書(shū)人閱讀 156,723評(píng)論 0贊 345
道士緝兇錄：失蹤的賣姜人
文/不壞的土叔我叫張陵旦袋，是天一觀的道長(zhǎng)骤菠。經(jīng)常有香客問(wèn)我，道長(zhǎng)疤孕，這世上最難降的妖魔是什么商乎？我笑而不...
開(kāi)封第一講書(shū)人閱讀 56,357評(píng)論 1贊 283
?港島之戀（遺憾婚禮）
正文為了忘掉前任，我火速辦了婚禮祭阀，結(jié)果婚禮上鹉戚，老公的妹妹穿的比我還像新娘。我一直安慰自己专控，他們只是感情好抹凳，可當(dāng)我...
茶點(diǎn)故事閱讀 65,412評(píng)論 5贊 384
惡毒庶女頂嫁案：這布局不是一般人想出來(lái)的
文/花漫我一把揭開(kāi)白布。她就那樣靜靜地躺著伦腐，像睡著了一般却桶。火紅的嫁衣襯著肌膚如雪帐偎。梳的紋絲不亂的頭發(fā)上，一...
開(kāi)封第一講書(shū)人閱讀 49,760評(píng)論 1贊 289
城市分裂傳說(shuō)
那天臂容，我揣著相機(jī)與錄音忆蚀，去河邊找鬼。笑死嘁扼，一個(gè)胖子當(dāng)著我的面吹牛信粮，可吹牛的內(nèi)容都是我干的。我是一名探鬼主播趁啸，決...
沈念sama閱讀 38,904評(píng)論 3贊 405
雙鴛鴦連環(huán)套：你想象不到人心有多黑
文/蒼蘭香墨我猛地睜開(kāi)眼强缘，長(zhǎng)吁一口氣：“原來(lái)是場(chǎng)噩夢(mèng)啊……” “哼！你這毒婦竟也來(lái)了不傅？” 一聲冷哼從身側(cè)響起旅掂，我...
開(kāi)封第一講書(shū)人閱讀 37,672評(píng)論 0贊 266
萬(wàn)榮殺人案實(shí)錄
序言：老撾萬(wàn)榮一對(duì)情侶失蹤，失蹤者是張志新（化名）和其女友劉穎访娶，沒(méi)想到半個(gè)月后商虐，有當(dāng)?shù)厝嗽跇?shù)林里發(fā)現(xiàn)了一具尸體，經(jīng)...
沈念sama閱讀 44,118評(píng)論 1贊 303
?護(hù)林員之死
正文獨(dú)居荒郊野嶺守林人離奇死亡崖疤，尸身上長(zhǎng)有42處帶血的膿包…… 初始之章·張勛以下內(nèi)容為張勛視角年9月15日...
茶點(diǎn)故事閱讀 36,456評(píng)論 2贊 325
?白月光啟示錄
正文我和宋清朗相戀三年秘车，在試婚紗的時(shí)候發(fā)現(xiàn)自己被綠了。大學(xué)時(shí)的朋友給我發(fā)了我未婚夫和他白月光在一起吃飯的照片劫哼。...
茶點(diǎn)故事閱讀 38,599評(píng)論 1贊 340
活死人
序言：一個(gè)原本活蹦亂跳的男人離奇死亡叮趴，死狀恐怖，靈堂內(nèi)的尸體忽然破棺而出权烧，到底是詐尸還是另有隱情眯亦，我是刑警寧澤，帶...
沈念sama閱讀 34,264評(píng)論 4贊 328
?日本核電站爆炸內(nèi)幕
正文年R本政府宣布般码，位于F島的核電站搔驼，受9級(jí)特大地震影響，放射性物質(zhì)發(fā)生泄漏侈询。R本人自食惡果不足惜舌涨，卻給世界環(huán)境...
茶點(diǎn)故事閱讀 39,857評(píng)論 3贊 312
男人毒藥：我在死后第九天來(lái)索命
文/蒙蒙一、第九天我趴在偏房一處隱蔽的房頂上張望扔字。院中可真熱鬧囊嘉，春花似錦、人聲如沸革为。這莊子的主人今日做“春日...
開(kāi)封第一講書(shū)人閱讀 30,731評(píng)論 0贊 21
一樁弒父案，背后竟有這般陰謀
文/蒼蘭香墨我抬頭看了看天上的太陽(yáng)震檩。三九已至琢蛤，卻和暖如春蜓堕，著一層夾襖步出監(jiān)牢的瞬間，已是汗流浹背博其。一陣腳步聲響...
開(kāi)封第一講書(shū)人閱讀 31,956評(píng)論 1贊 264
情欲美人皮
我被黑心中介騙來(lái)泰國(guó)打工套才，沒(méi)想到剛下飛機(jī)就差點(diǎn)兒被人妖公主榨干…… 1. 我叫王不留，地道東北人慕淡。一個(gè)月前我還...
沈念sama閱讀 46,286評(píng)論 2贊 360
代替公主和親
正文我出身青樓背伴，卻偏偏與公主長(zhǎng)得像，于是被迫代替她去往敵國(guó)和親峰髓。傳聞我的和親對(duì)象是個(gè)殘疾皇子傻寂，可洞房花燭夜當(dāng)晚...
茶點(diǎn)故事閱讀 43,465評(píng)論 2贊 348

千里碼 豆瓣評(píng)分爬取

千里碼：

豆瓣評(píng)分爬取

上述代碼中對(duì)應(yīng)的代理IP地址的SQL文件

推薦閱讀更多精彩內(nèi)容

千里碼豆瓣評(píng)分爬取