当前位置:首页>python>Python异步编程实战:从async/await到高性能爬虫

Python异步编程实战:从async/await到高性能爬虫

  • 2026-06-30 00:51:11
Python异步编程实战:从async/await到高性能爬虫

Python异步编程实战:从async/await到高性能爬虫

同步爬虫爬100个页面要100秒,异步爬虫只要3秒——这就是协程的威力

这项技术到底解决了什么问题?

Python的requests库很好用,但有一个致命弱点:它是一次只能做一件事的“单线程思维”。当你爬取一个网页时,程序大部分时间在等待网络响应,CPU几乎空闲。请求100个页面,就要串行等待100次。

异步编程解决了这个IO密集型场景的效率问题:在等待网络响应时,切换到其他任务继续执行,一个线程就能处理成百上千个并发请求。

方式
爬100个页面耗时
CPU利用率
难度
同步(requests)
~100秒
2%
多线程(threading)
~15秒
30%
⭐⭐
异步(asyncio)
~3秒
10%
⭐⭐⭐

异步不是多线程——它是在单线程内通过协程切换实现并发。不涉及线程切换开销,也没有GIL的限制,非常适合IO密集型任务。

本教程从基础语法开始,逐步深入到一个实战项目:一个能爬取数千条数据的异步爬虫。

环境准备

# 创建项目目录mkdir python-asynccd python-async# 创建虚拟环境python -m venv venvsource venv/bin/activate# 安装依赖pip install aiohttp  # 异步HTTP客户端pip install httpx    # 更现代的异步HTTP客户端(支持HTTP/2)pip install pytest pytest-asyncio  # 异步测试

第一步:理解协程和事件循环

协程是异步编程的核心概念。它就像一个可以暂停和恢复的函数。

import asyncio# ============================================# 定义协程函数:用 async def 声明# ============================================asyncdefgreet(name):print(f"开始问候 {name}")await asyncio.sleep(1)  # 模拟IO操作,释放控制权print(f"你好, {name}!")returnf"结果: {name}"# ============================================# 运行协程的方式# ============================================asyncdefmain():# 方式1: 顺序执行(像同步一样)print("=== 顺序执行 ===")    result1 = await greet("张三")    result2 = await greet("李四")print(result1, result2)# 方式2: 并发执行(这才是异步的优势)print("\n=== 并发执行 ===")    results = await asyncio.gather(        greet("王五"),        greet("赵六"),        greet("钱七"),    )print(results)# 入口if __name__ == "__main__":    asyncio.run(main())

运行输出:

=== 顺序执行 ===开始问候 张三你好, 张三!          (等1秒)开始问候 李四你好, 李四!          (又等1秒)=== 并发执行 ===开始问候 王五开始问候 赵六开始问候 钱七你好, 王五!          (三个同时完成,共等1秒)你好, 赵六!你好, 钱七!

三个核心概念

概念
关键字
说明
协程函数
async def
定义后可返回协程对象
暂停等待
await
暂停当前协程,等待IO完成
并发执行
asyncio.gather()
同时运行多个协程

await的作用:它把控制权交还给事件循环,让事件循环可以去执行其他协程。没有await就没有并发——await点是协程之间切换的时机。

第二步:异步HTTP请求

创建 async_http_demo.py

import asyncioimport aiohttpimport timeasyncdeffetch(session, url):"""异步获取一个URL的内容"""try:asyncwith session.get(url, timeout=10as response:            data = await response.text()return {"url": url,"status": response.status,"length"len(data),            }except Exception as e:return {"url": url, "error"str(e)}asyncdeffetch_all(urls, max_concurrency=10):"""并发获取多个URL(控制并发数)"""# 信号量:限制最大并发数    semaphore = asyncio.Semaphore(max_concurrency)asyncdeffetch_with_limit(url):asyncwith semaphore:asyncwith aiohttp.ClientSession() as session:returnawait fetch(session, url)    tasks = [fetch_with_limit(url) for url in urls]returnawait asyncio.gather(*tasks)asyncdefmain():# 测试用的URL列表    urls = ["https://httpbin.org/delay/1","https://httpbin.org/delay/1","https://httpbin.org/delay/1","https://httpbin.org/json","https://httpbin.org/ip",    ] * 5# 25个请求print(f"开始并发请求 {len(urls)} 个URL...")    start = time.time()    results = await fetch_all(urls, max_concurrency=20)    elapsed = time.time() - start    success = [r for r in results if"error"notin r]    errors = [r for r in results if"error"in r]print(f"\n耗时: {elapsed:.2f}秒")print(f"成功: {len(success)}")print(f"失败: {len(errors)}")print(f"QPS: {len(results) / elapsed:.0f}")if __name__ == "__main__":    asyncio.run(main())

运行对比

  • • 同步方式25个请求(每个1秒):约25秒
  • • 异步方式25个请求(并发10个):约3秒

Semaphore的作用:限制同时进行的请求数。如果不加限制,25个请求同时发出,可能被服务器限流或者耗尽本地连接池。

第三步:异步实战——高性能爬虫

创建 crawler.py

import asyncioimport aiohttpimport jsonimport timefrom typing importListDictclassAsyncCrawler:"""异步爬虫框架"""def__init__(self, max_concurrency=50):self.max_concurrency = max_concurrencyself.semaphore = asyncio.Semaphore(max_concurrency)self.results = []asyncdeffetch_page(self, session, url):"""获取单个页面"""asyncwithself.semaphore:try:asyncwith session.get(url, timeout=15as response:if response.status == 200:returnawait response.text()else:returnNoneexcept asyncio.TimeoutError:returnNoneexcept Exception:returnNoneasyncdefparse(self, html):"""解析页面(子类重写此方法)"""return html[:100if html elseNoneasyncdefcrawl_one(self, session, url):"""爬取一个URL的完整流程:请求 → 解析 → 存储"""        html = awaitself.fetch_page(session, url)if html isNone:return {"url": url, "status""failed"}        data = awaitself.parse(html)return {"url": url, "status""success""data": data}asyncdefcrawl_many(self, urls):"""并发爬取多个URL"""        connector = aiohttp.TCPConnector(            limit=self.max_concurrency,   # 连接池大小            limit_per_host=20,            # 每个域名最多20个并发            ttl_dns_cache=300,            # DNS缓存5分钟        )asyncwith aiohttp.ClientSession(            connector=connector,            headers={"User-Agent""Mozilla/5.0 (compatible; AsyncCrawler/1.0)",            },        ) as session:            tasks = [self.crawl_one(session, url) for url in urls]self.results = await asyncio.gather(*tasks)returnself.resultsdefget_stats(self):"""获取爬取统计"""        total = len(self.results)        success = sum(1for r inself.results if r["status"] == "success")        failed = total - successreturn {"total": total,"success": success,"failed": failed,"success_rate"f"{success / total * 100:.1f}%"if total > 0else"N/A",        }# ============================================# 自定义爬虫:爬取JSONPlaceholder文章# ============================================classPostCrawler(AsyncCrawler):"""爬取JSONPlaceholder的博客文章"""asyncdefparse(self, html):"""解析JSON数据"""try:            data = json.loads(html)return {"id": data.get("id"),"title": data.get("title")[:50if data.get("title"else"","body_length"len(data.get("body""")),            }except json.JSONDecodeError:returnNoneasyncdefmain():# 生成URL列表(JSONPlaceholder有100篇文章)    urls = [f"https://jsonplaceholder.typicode.com/posts/{i}"for i inrange(1101)    ]print(f"🚀 开始爬取 {len(urls)} 个页面...")    start = time.time()    crawler = PostCrawler(max_concurrency=20)    results = await crawler.crawl_many(urls)    elapsed = time.time() - start    stats = crawler.get_stats()print(f"\n{'='*40}")print(f"📊 爬取统计")print(f"{'='*40}")print(f"总耗时: {elapsed:.2f}秒")print(f"总请求: {stats['total']}")print(f"成功数: {stats['success']}")print(f"失败数: {stats['failed']}")print(f"成功率: {stats['success_rate']}")print(f"QPS: {stats['total'] / elapsed:.0f}")# 打印几条结果示例print(f"\n📋 结果示例:")for r in results[:3]:if r["status"] == "success"and r["data"]:print(f"  [{r['data']['id']}{r['data']['title']}")if __name__ == "__main__":    asyncio.run(main())

运行:

python crawler.py

输出示例:

🚀 开始爬取 100 个页面...========================================📊 爬取统计========================================总耗时: 2.34秒总请求: 100成功数: 100失败数: 0成功率: 100.0%QPS: 43📋 结果示例:  [1] sunt aut facere repellat provident...  [2] qui est esse  [3] ea molestias quasi exercitationem...

第四步:异步文件读写和数据库操作

异步文件写入

import aiofilesasyncdefsave_results(results, filename):"""异步保存结果到文件"""asyncwith aiofiles.open(filename, 'w', encoding='utf-8'as f:for result in results:if result["status"] == "success":                line = json.dumps(result["data"], ensure_ascii=False) + "\n"await f.write(line)print(f"结果已保存到 {filename}")

异步数据库操作(PostgreSQL示例)

import asyncpgasyncdefsave_to_db(results):"""异步批量写入数据库"""    conn = await asyncpg.connect(        user='test', password='test',        database='test', host='localhost'    )asyncwith conn.transaction():for result in results:if result["status"] == "success":                data = result["data"]await conn.execute("INSERT INTO posts (id, title, body_length) VALUES ($1, $2, $3)",                    data["id"], data["title"], data["body_length"]                )await conn.close()

第五步:异步测试

创建 test_crawler.py

import pytestimport asynciofrom crawler import PostCrawler@pytest.mark.asyncioasyncdeftest_fetch_single_page():"""测试单页面爬取"""    crawler = PostCrawler(max_concurrency=1)    urls = ["https://jsonplaceholder.typicode.com/posts/1"]    results = await crawler.crawl_many(urls)assertlen(results) == 1assert results[0]["status"] == "success"assert results[0]["data"]["id"] == 1assert"title"in results[0]["data"]@pytest.mark.asyncioasyncdeftest_crawl_multiple_pages():"""测试多页面并发爬取"""    crawler = PostCrawler(max_concurrency=10)    urls = [f"https://jsonplaceholder.typicode.com/posts/{i}"for i inrange(111)]    results = await crawler.crawl_many(urls)    stats = crawler.get_stats()assert stats["total"] == 10assert stats["success"] == 10assert stats["failed"] == 0@pytest.mark.asyncioasyncdeftest_handle_error():"""测试错误处理"""    crawler = PostCrawler(max_concurrency=1)    urls = ["https://invalid-domain-12345.com/api"]    results = await crawler.crawl_many(urls)assert results[0]["status"] == "failed"
pytest test_crawler.py -v

实用技巧与避坑指南

  1. 1. 不要在协程中调用同步阻塞函数time.sleep()requests.get()会阻塞整个事件循环。应使用await asyncio.sleep()aiohttp等异步替代品。
  2. 2. 控制并发数:使用asyncio.Semaphore限制并发数。无限制并发可能被服务器封IP,或者耗尽本机文件描述符。
  3. 3. 正确处理异常:协程中的异常不会自动传播。使用asyncio.gather(return_exceptions=True)获取异常而不中断其他任务。或者使用try-except包裹每个协程内的逻辑。
  4. 4. 避免在协程中做CPU密集型计算:异步的优势在于IO密集型场景。大量的JSON解析或正则匹配应该在子线程中执行:await asyncio.to_thread(cpu_heavy_func, data)
  5. 5. Python 3.11+ 的TaskGroup(推荐)asyncio.TaskGroup是3.11引入的新特性,比asyncio.gather提供了更好的异常处理——组内任一任务失败,自动取消组内其他任务:
    asyncdefmain():asyncwith asyncio.TaskGroup() as tg:        tg.create_task(crawl("url1"))        tg.create_task(crawl("url2"))# 如果任何一个任务失败,其他任务会自动取消

总结

本教程完成了Python异步编程的完整学习路径:

层级
内容
关键语法
基础
协程和事件循环
async def
 + await + asyncio.run()
并发
多任务同时执行
asyncio.gather()
 + Semaphore
实战
高性能爬虫
aiohttp
 + TCPConnector
存储
异步文件和数据库
aiofiles
 + asyncpg
测试
异步测试
pytest.mark.asyncio

掌握了异步编程,你就能处理任何IO密集型的Python任务——爬虫、API网关、消息处理、实时数据流——用更少的资源实现更高的吞吐量。


最新文章

随机文章

基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-07-02 23:25:38 HTTP/2.0 GET : https://f.mffb.com.cn/a/501152.html
  2. 运行时间 : 0.423393s [ 吞吐率:2.36req/s ] 内存消耗:4,800.05kb 文件加载:140
  3. 缓存信息 : 0 reads,0 writes
  4. 会话信息 : SESSION_ID=94cf5b1988798c8ccbd6f9e6315887b1
  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.000972s ] mysql:host=127.0.0.1;port=3306;dbname=f_mffb;charset=utf8mb4
  2. SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.001336s ]
  3. SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.011037s ]
  4. SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.007739s ]
  5. SHOW FULL COLUMNS FROM `set` [ RunTime:0.001443s ]
  6. SELECT * FROM `set` [ RunTime:0.043553s ]
  7. SHOW FULL COLUMNS FROM `article` [ RunTime:0.002004s ]
  8. SELECT * FROM `article` WHERE `id` = 501152 LIMIT 1 [ RunTime:0.038323s ]
  9. UPDATE `article` SET `lasttime` = 1783005938 WHERE `id` = 501152 [ RunTime:0.015984s ]
  10. SELECT * FROM `fenlei` WHERE `id` = 66 LIMIT 1 [ RunTime:0.003622s ]
  11. SELECT * FROM `article` WHERE `id` < 501152 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.035169s ]
  12. SELECT * FROM `article` WHERE `id` > 501152 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.013498s ]
  13. SELECT * FROM `article` WHERE `id` < 501152 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.014385s ]
  14. SELECT * FROM `article` WHERE `id` < 501152 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.041767s ]
  15. SELECT * FROM `article` WHERE `id` < 501152 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.031510s ]
0.426732s