当前位置:首页>python>Python爬虫完整教程

Python爬虫完整教程

  • 2026-08-18 23:11:17
Python爬虫完整教程

目录

  1. 爬虫基础
  2. 网络请求
  3. 数据解析
  4. 反爬处理
  5. 数据存储
  6. 框架爬虫
  7. 实战项目

第一章:爬虫基础

1.1 什么是爬虫

爬虫(Web Crawler)是模拟浏览器访问网站,自动抓取数据的程序。

1.2 爬虫工作流程

  1. 发送HTTP请求获取网页
  2. 解析HTML提取数据
  3. 存储数据到文件或数据库
  4. 循环抓取下一页

1.3 爬虫伦理

  • 遵守robots.txt协议
  • 控制请求频率,避免给服务器造成压力
  • 不抓取敏感数据
  • 仅用于学习和合法用途

1.4 环境准备

pip install requestspip install beautifulsoup4pip install lxmlpip install pandaspip install scrapy

第二章:网络请求

2.1 requests基础

import requests# GET请求response = requests.get("https://www.example.com")print(response.status_code)  # 状态码print(response.text)         # 文本内容print(response.content)      # 字节内容print(response.headers)      # 响应头print(response.url)          # 请求URL# 带参数的GET请求params = {"page"1"size"10}response = requests.get("https://api.example.com/data", params=params)# POST请求data = {"username""test""password""123456"}response = requests.post("https://httpbin.org/post", data=data)# JSON请求json_data = {"name""test""age"12}response = requests.post("https://httpbin.org/post", json=json_data)print(response.json())

2.2 请求头设置

headers = {"User-Agent""Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36","Referer""https://www.example.com","Accept""text/html,application/xhtml+xml","Accept-Language""zh-CN,zh;q=0.9","Cookie""session=abc123"}response = requests.get("https://www.example.com", headers=headers)

2.3 会话保持

session = requests.Session()# 登录login_data = {"username""test""password""123456"}session.post("https://www.example.com/login", data=login_data)# 使用同一会话访问需要登录的页面response = session.get("https://www.example.com/profile")

2.4 超时与重试

from requests.adapters import HTTPAdapterfrom urllib3.util.retry import Retry# 超时设置response = requests.get("https://www.example.com", timeout=5)# 重试机制session = requests.Session()retries = Retry(total=3, backoff_factor=1)adapter = HTTPAdapter(max_retries=retries)session.mount("http://", adapter)session.mount("https://", adapter)response = session.get("https://www.example.com")

2.5 SSL证书验证

# 禁用SSL验证(不推荐用于生产环境)response = requests.get("https://www.example.com", verify=False)# 使用自定义证书response = requests.get("https://www.example.com", cert="/path/to/cert.pem")

第三章:数据解析

3.1 BeautifulSoup

from bs4 import BeautifulSouphtml = """<html><head><title>测试页面</title></head><body>    <div class="content">        <h1>标题</h1>        <p class="text">段落1</p>        <p class="text">段落2</p>        <a href="https://example.com">链接</a>    </div></body></html>"""soup = BeautifulSoup(html, "lxml")# 查找元素title = soup.title.stringprint(title)  # 测试页面h1 = soup.h1.textprint(h1)  # 标题# 查找所有段落paragraphs = soup.find_all("p")for p in paragraphs:    print(p.text)# 按类名查找text_elements = soup.find_all("p", class_="text")# 按属性查找link = soup.find("a")print(link["href"])  # https://example.com# CSS选择器elements = soup.select(".content p")

3.2 lxml

from lxml import etreehtml = """<div class="content">    <h1>标题</h1>    <p>段落1</p>    <p>段落2</p></div>"""tree = etree.HTML(html)# XPath选择h1 = tree.xpath("//h1/text()")[0]print(h1)  # 标题paragraphs = tree.xpath("//p/text()")for p in paragraphs:    print(p)# 属性选择link = tree.xpath("//a/@href")print(link)

3.3 re正则表达式

import rehtml = '<a href="https://example.com">链接</a>'# 提取链接url = re.search(r'href="(.*?)"', html)if url:    print(url.group(1))  # https://example.com# 提取所有链接urls = re.findall(r'href="(.*?)"', html)print(urls)

3.4 PyQuery

from pyquery import PyQuery as pqhtml = """<div class="content">    <h1>标题</h1>    <p>段落1</p>    <p>段落2</p></div>"""doc = pq(html)# jQuery风格选择h1 = doc("h1").text()print(h1)  # 标题paragraphs = doc("p").items()for p in paragraphs:    print(p.text())

第四章:反爬处理

4.1 User-Agent轮换

import randomuser_agents = ["Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36","Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36","Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36"]headers = {"User-Agent": random.choice(user_agents)}response = requests.get("https://www.example.com", headers=headers)

4.2 IP代理

proxies = {"http""http://127.0.0.1:7890","https""http://127.0.0.1:7890"}response = requests.get("https://www.example.com", proxies=proxies)# 代理池proxy_list = ["http://proxy1:port","http://proxy2:port","http://proxy3:port"]proxy = {"http": random.choice(proxy_list)}response = requests.get("https://www.example.com", proxies=proxy)

4.3 验证码处理

# 打码平台API(示例)defrecognize_captcha(image_path):# 调用打码平台API# 返回识别结果pass# Selenium处理滑动验证码from selenium import webdriverfrom selenium.webdriver.common.action_chains import ActionChainsdriver = webdriver.Chrome()driver.get("https://www.example.com")# 定位滑块slider = driver.find_element_by_id("slider")# 模拟拖动action = ActionChains(driver)action.click_and_hold(slider).perform()action.move_by_offset(3000).perform()action.release().perform()

4.4 Cookie处理

# 从浏览器复制Cookiecookies = {"session""abc123","user""test"}response = requests.get("https://www.example.com", cookies=cookies)# 使用Session保持Cookiesession = requests.Session()response1 = session.get("https://www.example.com/login")response2 = session.get("https://www.example.com/profile")

4.5 JavaScript渲染

# Seleniumfrom selenium import webdriverfrom selenium.webdriver.common.by import Byfrom selenium.webdriver.support.ui import WebDriverWaitfrom selenium.webdriver.support import expected_conditions as ECdriver = webdriver.Chrome()driver.get("https://www.example.com")# 等待元素加载wait = WebDriverWait(driver, 10)element = wait.until(EC.presence_of_element_located((By.CLASS_NAME, "content")))# 获取渲染后的页面html = driver.page_sourcedriver.quit()# Pyppeteer(异步)import asynciofrom pyppeteer import launchasyncdefscrape():    browser = await launch()    page = await browser.newPage()await page.goto("https://www.example.com")    content = await page.content()await browser.close()return contentcontent = asyncio.get_event_loop().run_until_complete(scrape())

第五章:数据存储

5.1 CSV文件

import csv# 写入CSVwith open("data.csv""w", newline="", encoding="utf-8"as f:    writer = csv.writer(f)    writer.writerow(["姓名""年龄""城市"])    writer.writerow(["小明"12"北京"])    writer.writerow(["小红"14"上海"])# 读取CSVwith open("data.csv""r", encoding="utf-8"as f:    reader = csv.reader(f)for row in reader:        print(row)# 使用pandasimport pandas as pddf = pd.DataFrame({"姓名": ["小明""小红"], "年龄": [1214]})df.to_csv("data.csv", index=False)

5.2 JSON文件

import json# 写入JSONdata = {"name""小明""age"12"scores": [859278]}with open("data.json""w", encoding="utf-8"as f:    json.dump(data, f, ensure_ascii=False, indent=2)# 读取JSONwith open("data.json""r", encoding="utf-8"as f:    data = json.load(f)    print(data)

5.3 MySQL数据库

import pymysqldefsave_to_mysql(data):    conn = pymysql.connect(        host="localhost",        user="root",        password="password",        database="spider_db",        charset="utf8mb4"    )    cursor = conn.cursor()# 创建表    cursor.execute("""    CREATE TABLE IF NOT EXISTS articles (        id INT AUTO_INCREMENT PRIMARY KEY,        title VARCHAR(255),        url VARCHAR(255),        content TEXT    )    """)# 插入数据    sql = "INSERT INTO articles (title, url, content) VALUES (%s, %s, %s)"    cursor.execute(sql, (data["title"], data["url"], data["content"]))    conn.commit()    conn.close()

5.4 MongoDB

from pymongo import MongoClientdefsave_to_mongodb(data):    client = MongoClient("localhost"27017)    db = client["spider_db"]    collection = db["articles"]# 插入单条数据    collection.insert_one(data)# 插入多条数据# collection.insert_many(data_list)# 查询数据    results = collection.find({"title": {"$regex""Python"}})for result in results:        print(result)    client.close()

5.5 Redis缓存

import redisdefcache_url(url):    r = redis.Redis(host="localhost", port=6379, db=0)# 设置缓存    r.set(url, "1", ex=3600)  # 1小时过期# 检查是否已爬取if r.exists(url):returnTrue# 已爬取returnFalse# 未爬取

第六章:Scrapy框架

6.1 创建项目

scrapy startproject myspidercd myspiderscrapy genspider example example.com

6.2 项目结构

myspider/├── myspider/│   ├── __init__.py│   ├── items.py│   ├── middlewares.py│   ├── pipelines.py│   ├── settings.py│   └── spiders/│       ├── __init__.py│       └── example.py└── scrapy.cfg

6.3 定义Item

# items.pyimport scrapyclassArticleItem(scrapy.Item):    title = scrapy.Field()    url = scrapy.Field()    content = scrapy.Field()    publish_time = scrapy.Field()

6.4 编写Spider

# spiders/example.pyimport scrapyfrom myspider.items import ArticleItemclassExampleSpider(scrapy.Spider):    name = "example"    allowed_domains = ["example.com"]    start_urls = ["https://www.example.com"]defparse(self, response):# 解析文章列表        articles = response.css(".article-item")for article in articles:            item = ArticleItem()            item["title"] = article.css("h2::text").get()            item["url"] = article.css("a::attr(href)").get()# 跟进文章详情页yield scrapy.Request(                url=response.urljoin(item["url"]),                callback=self.parse_article,                meta={"item": item}            )# 翻页        next_page = response.css(".next-page::attr(href)").get()if next_page:yield scrapy.Request(                url=response.urljoin(next_page),                callback=self.parse            )defparse_article(self, response):        item = response.meta["item"]        item["content"] = response.css(".content::text").getall()        item["publish_time"] = response.css(".time::text").get()yield item

6.5 配置Settings

# settings.pyBOT_NAME = "myspider"SPIDER_MODULES = ["myspider.spiders"]NEWSPIDER_MODULE = "myspider.spiders"# 请求头DEFAULT_REQUEST_HEADERS = {"User-Agent""Mozilla/5.0 (Windows NT 10.0; Win64; x64)","Accept""text/html,application/xhtml+xml",}# 下载延迟(秒)DOWNLOAD_DELAY = 1# 并发请求数CONCURRENT_REQUESTS = 16# 禁用CookieCOOKIES_ENABLED = False# 中间件DOWNLOADER_MIDDLEWARES = {"myspider.middlewares.UserAgentMiddleware"400,}# 管道ITEM_PIPELINES = {"myspider.pipelines.DataPipeline"300,}

6.6 中间件

# middlewares.pyimport randomclassUserAgentMiddleware:def__init__(self):        self.user_agents = ["Mozilla/5.0 (Windows NT 10.0; Win64; x64)","Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7)",        ]defprocess_request(self, request, spider):        request.headers["User-Agent"] = random.choice(self.user_agents)

6.7 Pipeline

# pipelines.pyimport jsonimport pymysqlclassDataPipeline:defopen_spider(self, spider):        self.file = open("data.json""w", encoding="utf-8")defclose_spider(self, spider):        self.file.close()defprocess_item(self, item, spider):        line = json.dumps(dict(item), ensure_ascii=False) + "\n"        self.file.write(line)return itemclassMysqlPipeline:defopen_spider(self, spider):        self.conn = pymysql.connect(            host="localhost",            user="root",            password="password",            database="spider_db"        )        self.cursor = self.conn.cursor()defclose_spider(self, spider):        self.conn.close()defprocess_item(self, item, spider):        sql = "INSERT INTO articles (title, url, content) VALUES (%s, %s, %s)"        self.cursor.execute(sql, (item["title"], item["url"], item["content"]))        self.conn.commit()return item

6.8 运行爬虫

scrapy crawl example# 导出数据scrapy crawl example -o data.json

第七章:实战项目

7.1 爬取豆瓣电影Top250

import requestsfrom bs4 import BeautifulSoupimport csvimport timedefscrape_douban_top250():    headers = {"User-Agent""Mozilla/5.0 (Windows NT 10.0; Win64; x64)"    }    movies = []for page in range(10):        url = f"https://movie.douban.com/top250?start={page * 25}"        response = requests.get(url, headers=headers)        soup = BeautifulSoup(response.text, "lxml")        items = soup.find_all("div", class_="item")for item in items:            movie = {}            movie["rank"] = item.find("em").text            movie["title"] = item.find("span", class_="title").text            movie["rating"] = item.find("span", class_="rating_num").text            movie["info"] = item.find("div", class_="bd").p.text.strip()            movies.append(movie)        print(f"已完成第{page + 1}页")        time.sleep(1)# 保存到CSVwith open("douban_top250.csv""w", newline="", encoding="utf-8"as f:        writer = csv.DictWriter(f, fieldnames=["rank""title""rating""info"])        writer.writeheader()        writer.writerows(movies)    print(f"共抓取{len(movies)}部电影")if __name__ == "__main__":    scrape_douban_top250()

7.2 爬取新闻网站

import requestsfrom bs4 import BeautifulSoupimport jsonimport timedefscrape_news():    headers = {"User-Agent""Mozilla/5.0 (Windows NT 10.0; Win64; x64)"    }    articles = []for page in range(16):        url = f"https://www.example.com/news?page={page}"        response = requests.get(url, headers=headers)        soup = BeautifulSoup(response.text, "lxml")        items = soup.find_all("div", class_="news-item")for item in items:            article = {}            article["title"] = item.find("h2").text.strip()            article["url"] = item.find("a")["href"]            article["summary"] = item.find("p", class_="summary").text.strip()            article["time"] = item.find("span", class_="time").text.strip()            articles.append(article)        print(f"已完成第{page}页")        time.sleep(1)# 保存到JSONwith open("news.json""w", encoding="utf-8"as f:        json.dump(articles, f, ensure_ascii=False, indent=2)    print(f"共抓取{len(articles)}篇文章")if __name__ == "__main__":    scrape_news()

7.3 爬取商品信息

import requestsfrom bs4 import BeautifulSoupimport csvimport timedefscrape_products():    headers = {"User-Agent""Mozilla/5.0 (Windows NT 10.0; Win64; x64)"    }    products = []for page in range(16):        url = f"https://www.example.com/products?page={page}"        response = requests.get(url, headers=headers)        soup = BeautifulSoup(response.text, "lxml")        items = soup.find_all("div", class_="product-item")for item in items:            product = {}            product["name"] = item.find("h3", class_="name").text.strip()            product["price"] = item.find("span", class_="price").text.strip()            product["sales"] = item.find("span", class_="sales").text.strip()            product["shop"] = item.find("span", class_="shop").text.strip()            products.append(product)        print(f"已完成第{page}页")        time.sleep(1)# 保存到CSVwith open("products.csv""w", newline="", encoding="utf-8"as f:        writer = csv.DictWriter(f, fieldnames=["name""price""sales""shop"])        writer.writeheader()        writer.writerows(products)    print(f"共抓取{len(products)}个商品")if __name__ == "__main__":    scrape_products()

7.4 Scrapy实战:知乎爬虫

# zhihu/spiders/zhihu_spider.pyimport scrapyfrom zhihu.items import ZhihuItemclassZhihuSpider(scrapy.Spider):    name = "zhihu"    allowed_domains = ["zhihu.com"]    custom_settings = {"DEFAULT_REQUEST_HEADERS": {"User-Agent""Mozilla/5.0 (Windows NT 10.0; Win64; x64)","Referer""https://www.zhihu.com",        }    }    start_urls = ["https://www.zhihu.com/topics"]defparse(self, response):# 解析话题列表        topics = response.css(".zm-topic-list-item")for topic in topics:            url = topic.css("a::attr(href)").get()yield scrapy.Request(                url=response.urljoin(url),                callback=self.parse_topic            )defparse_topic(self, response):# 解析话题下的问题        questions = response.css(".QuestionItem-title a::attr(href)").getall()for question_url in questions:yield scrapy.Request(                url=response.urljoin(question_url),                callback=self.parse_question            )defparse_question(self, response):        item = ZhihuItem()        item["title"] = response.css("h1::text").get()        item["content"] = response.css(".RichContent-inner::text").getall()        item["url"] = response.urlyield item

7.5 异步爬虫

import asyncioimport aiohttpfrom bs4 import BeautifulSoupasyncdeffetch(session, url):asyncwith session.get(url) as response:returnawait response.text()asyncdefparse(html):    soup = BeautifulSoup(html, "lxml")    titles = soup.find_all("h2")return [title.text for title in titles]asyncdefscrape_page(session, url):    html = await fetch(session, url)returnawait parse(html)asyncdefmain():    urls = [f"https://www.example.com/page/{i}"for i in range(111)]asyncwith aiohttp.ClientSession() as session:        tasks = [scrape_page(session, url) for url in urls]        results = await asyncio.gather(*tasks)        all_titles = []for titles in results:            all_titles.extend(titles)        print(f"共抓取{len(all_titles)}个标题")if __name__ == "__main__":    asyncio.run(main())

7.6 Selenium实战:动态页面

from selenium import webdriverfrom selenium.webdriver.common.by import Byfrom selenium.webdriver.support.ui import WebDriverWaitfrom selenium.webdriver.support import expected_conditions as ECimport timedefscrape_dynamic_page():    options = webdriver.ChromeOptions()    options.add_argument("--headless")  # 无头模式    driver = webdriver.Chrome(options=options)    driver.get("https://www.example.com")# 等待元素加载    wait = WebDriverWait(driver, 10)    element = wait.until(        EC.presence_of_element_located((By.CLASS_NAME, "content"))    )# 滚动加载更多内容for i in range(5):        driver.execute_script("window.scrollTo(0, document.body.scrollHeight);")        time.sleep(1)# 提取数据    items = driver.find_elements(By.CLASS_NAME, "item")for item in items:        title = item.find_element(By.TAG_NAME, "h2").text        print(title)    driver.quit()if __name__ == "__main__":    scrape_dynamic_page()

附录:爬虫常用库

库名
用途
requests
HTTP请求
beautifulsoup4
HTML解析
lxml
XML/HTML解析
scrapy
爬虫框架
selenium
浏览器自动化
playwright
浏览器自动化
pyppeteer
无头浏览器
aiohttp
异步HTTP请求
pandas
数据处理
pymongo
MongoDB操作
pymysql
MySQL操作
redis
Redis操作

结语

爬虫技术应用广泛,但请遵守以下原则:

  1. 遵守网站robots.txt协议
  2. 控制爬取频率
  3. 不侵犯他人隐私
  4. 仅用于合法用途

祝你爬虫学习顺利!

最新文章

随机文章

基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-08-21 14:42:43 HTTP/2.0 GET : https://f.mffb.com.cn/a/506723.html
  2. 运行时间 : 0.227759s [ 吞吐率:4.39req/s ] 内存消耗:4,650.25kb 文件加载:140
  3. 缓存信息 : 0 reads,0 writes
  4. 会话信息 : SESSION_ID=376a9e0d580cd2741253c14fe42232b5
  1. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/public/index.php ( 0.79 KB )
  2. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/autoload.php ( 0.17 KB )
  3. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/composer/autoload_real.php ( 2.49 KB )
  4. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/composer/platform_check.php ( 0.90 KB )
  5. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/composer/ClassLoader.php ( 14.03 KB )
  6. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/composer/autoload_static.php ( 4.90 KB )
  7. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-helper/src/helper.php ( 8.34 KB )
  8. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-validate/src/helper.php ( 2.19 KB )
  9. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/helper.php ( 1.47 KB )
  10. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/stubs/load_stubs.php ( 0.16 KB )
  11. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
  12. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-container/src/Facade.php ( 2.71 KB )
  13. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/symfony/deprecation-contracts/function.php ( 0.99 KB )
  14. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/symfony/polyfill-mbstring/bootstrap.php ( 8.26 KB )
  15. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/symfony/polyfill-mbstring/bootstrap80.php ( 9.78 KB )
  16. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/symfony/var-dumper/Resources/functions/dump.php ( 1.49 KB )
  17. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-dumper/src/helper.php ( 0.18 KB )
  18. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/symfony/var-dumper/VarDumper.php ( 4.30 KB )
  19. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/App.php ( 15.30 KB )
  20. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-container/src/Container.php ( 15.76 KB )
  21. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/psr/container/src/ContainerInterface.php ( 1.02 KB )
  22. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/app/provider.php ( 0.19 KB )
  23. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Http.php ( 6.04 KB )
  24. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-helper/src/helper/Str.php ( 7.29 KB )
  25. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Env.php ( 4.68 KB )
  26. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/app/common.php ( 0.03 KB )
  27. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/helper.php ( 18.78 KB )
  28. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Config.php ( 5.54 KB )
  29. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/app.php ( 0.95 KB )
  30. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/cache.php ( 0.78 KB )
  31. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/console.php ( 0.23 KB )
  32. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/cookie.php ( 0.56 KB )
  33. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/database.php ( 2.48 KB )
  34. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
  35. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/filesystem.php ( 0.61 KB )
  36. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/lang.php ( 0.91 KB )
  37. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/log.php ( 1.35 KB )
  38. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/middleware.php ( 0.19 KB )
  39. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/route.php ( 1.89 KB )
  40. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/session.php ( 0.57 KB )
  41. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/trace.php ( 0.34 KB )
  42. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/view.php ( 0.82 KB )
  43. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/app/event.php ( 0.25 KB )
  44. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Event.php ( 7.67 KB )
  45. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/app/service.php ( 0.13 KB )
  46. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/app/AppService.php ( 0.26 KB )
  47. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Service.php ( 1.64 KB )
  48. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Lang.php ( 7.35 KB )
  49. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/lang/zh-cn.php ( 13.70 KB )
  50. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/initializer/Error.php ( 3.31 KB )
  51. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
  52. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/services.php ( 0.14 KB )
  53. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
  54. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
  55. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/service/ModelService.php ( 2.04 KB )
  56. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
  57. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Middleware.php ( 6.72 KB )
  58. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
  59. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/Paginator.php ( 11.86 KB )
  60. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-validate/src/Validate.php ( 63.20 KB )
  61. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/Model.php ( 23.55 KB )
  62. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 21.05 KB )
  63. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/model/concern/AutoWriteData.php ( 4.21 KB )
  64. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 6.44 KB )
  65. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/model/concern/DbConnect.php ( 5.16 KB )
  66. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.33 KB )
  67. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 28.29 KB )
  68. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
  69. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
  70. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/model/contract/Modelable.php ( 0.09 KB )
  71. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Db.php ( 2.88 KB )
  72. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/DbManager.php ( 8.52 KB )
  73. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Log.php ( 6.28 KB )
  74. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Manager.php ( 3.92 KB )
  75. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/psr/log/src/LoggerTrait.php ( 2.69 KB )
  76. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/psr/log/src/LoggerInterface.php ( 2.71 KB )
  77. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Cache.php ( 4.92 KB )
  78. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/psr/simple-cache/src/CacheInterface.php ( 4.71 KB )
  79. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-helper/src/helper/Arr.php ( 16.63 KB )
  80. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.84 KB )
  81. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/cache/Driver.php ( 9.03 KB )
  82. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 1.99 KB )
  83. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/app/Request.php ( 0.09 KB )
  84. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Request.php ( 55.78 KB )
  85. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/app/middleware.php ( 0.25 KB )
  86. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
  87. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-trace/src/TraceDebug.php ( 3.40 KB )
  88. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/middleware/SessionInit.php ( 1.94 KB )
  89. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Session.php ( 1.80 KB )
  90. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/session/driver/File.php ( 6.27 KB )
  91. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/contract/SessionHandlerInterface.php ( 0.87 KB )
  92. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/session/Store.php ( 7.12 KB )
  93. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Route.php ( 23.73 KB )
  94. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/route/RuleName.php ( 5.75 KB )
  95. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/route/Domain.php ( 2.53 KB )
  96. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/route/RuleGroup.php ( 22.43 KB )
  97. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/route/Rule.php ( 26.95 KB )
  98. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.78 KB )
  99. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/route/app.php ( 1.72 KB )
  100. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/facade/Route.php ( 4.70 KB )
  101. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 4.74 KB )
  102. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/route/Dispatch.php ( 10.44 KB )
  103. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/app/controller/Index.php ( 4.81 KB )
  104. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/app/BaseController.php ( 2.05 KB )
  105. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/facade/Db.php ( 0.93 KB )
  106. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 5.44 KB )
  107. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/PDOConnection.php ( 52.47 KB )
  108. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/Connection.php ( 8.39 KB )
  109. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.57 KB )
  110. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 16.58 KB )
  111. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/Builder.php ( 24.06 KB )
  112. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/BaseBuilder.php ( 27.50 KB )
  113. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/Query.php ( 15.71 KB )
  114. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/BaseQuery.php ( 45.13 KB )
  115. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.43 KB )
  116. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
  117. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 20.07 KB )
  118. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.66 KB )
  119. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 7.01 KB )
  120. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 19.37 KB )
  121. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 7.11 KB )
  122. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.63 KB )
  123. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.77 KB )
  124. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/log/driver/File.php ( 5.96 KB )
  125. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
  126. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/log/Channel.php ( 3.89 KB )
  127. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/event/LogRecord.php ( 1.02 KB )
  128. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-helper/src/Collection.php ( 16.47 KB )
  129. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/facade/View.php ( 1.70 KB )
  130. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/View.php ( 4.39 KB )
  131. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Response.php ( 8.81 KB )
  132. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/response/View.php ( 3.29 KB )
  133. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Cookie.php ( 6.06 KB )
  134. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-view/src/Think.php ( 8.38 KB )
  135. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/contract/TemplateHandlerInterface.php ( 1.60 KB )
  136. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-template/src/Template.php ( 46.61 KB )
  137. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-template/src/template/driver/File.php ( 2.41 KB )
  138. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-template/src/template/contract/DriverInterface.php ( 0.86 KB )
  139. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/runtime/temp/067d451b9a0c665040f3f1bdd3293d68.php ( 11.98 KB )
  140. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-trace/src/Html.php ( 4.42 KB )
  1. CONNECT:[ UseTime:0.001015s ] mysql:host=127.0.0.1;port=3306;dbname=f_mffb;charset=utf8mb4
  2. SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.001460s ]
  3. SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000706s ]
  4. SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000592s ]
  5. SHOW FULL COLUMNS FROM `set` [ RunTime:0.001291s ]
  6. SELECT * FROM `set` [ RunTime:0.018852s ]
  7. SHOW FULL COLUMNS FROM `article` [ RunTime:0.001424s ]
  8. SELECT * FROM `article` WHERE `id` = 506723 LIMIT 1 [ RunTime:0.001239s ]
  9. UPDATE `article` SET `lasttime` = 1787294563 WHERE `id` = 506723 [ RunTime:0.004979s ]
  10. SELECT * FROM `fenlei` WHERE `id` = 66 LIMIT 1 [ RunTime:0.000647s ]
  11. SELECT * FROM `article` WHERE `id` < 506723 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001139s ]
  12. SELECT * FROM `article` WHERE `id` > 506723 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001215s ]
  13. SELECT * FROM `article` WHERE `id` < 506723 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.002246s ]
  14. SELECT * FROM `article` WHERE `id` < 506723 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.002004s ]
  15. SELECT * FROM `article` WHERE `id` < 506723 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001843s ]
0.231393s