当前位置:首页>iOSAPP>iOS 应用内购订阅订单系统设计与实现

iOS 应用内购订阅订单系统设计与实现

  • 2026-03-24 10:06:37
iOS 应用内购订阅订单系统设计与实现

本教程分为三大部分:

  1. 抽象系统设计思想与时序流程(目标、边界、关键原则、Mermaid 时序图)
  2. 详细接口设计与示例代码(REST 接口、鉴权、幂等、Java/PHP 示例)
  3. 服务部署与密钥管理(如何创建 .p8、生成 App 专用共享密钥、在服务器/容器/CI 中安全配置环境变量与 Secrets)

目标读者:后端工程师、移动端开发者、DevOps。

前提:你拥有 App Store Connect 权限(可以创建 Keys / 查看 App 详情)。

第一部分 — 抽象系统设计思想与时序流程

目标:明确系统边界、职责与失败模型,保证安全、一致与可观测。

  • 可信来源(Trust Anchor):后端为账务真相;客户端仅触发与表现。
  • 关键实体:User、Order(transaction_id)、Receipt(原始/摘要)、Subscription 状态、Notification Log、Idempotency Key。
  • 失败模型:外部依赖(Apple)可能延迟或不可用;需幂等、重试与补偿。

核心时序(客户端上报收据 → 后端验证 → 更新状态):

sequenceDiagram	participant App as iOS App	participant Backend as 验证服务	participant Apple as App Store Server	participant DB as 数据库	App->>Backend: POST /subscription/verify (receipt, idempotency_key)	Backend->>DB: insert verification job (idempotent)	Backend->>Apple: POST verifyReceipt / App Store Server API	Apple-->>Backend: verification result (status, latest_receipt_info)	Backend->>DB: upsert order by transaction_id, update subscription state	Backend-->>App: return canonical subscription status	Apple-->>Backend: Server-to-Server notification (renewal, cancel, refund)	Backend->>DB: apply notification updates (idempotent)

设计要点:

  • 所有账务决策必须基于后端与 Apple 的验证结果;
  • 使用 idempotency_key 与 transaction_id 保证幂等;
  • 保存原始收据与通知原文用于审计与对账;
  • 设计重试/补偿队列与监控告警(验证失败率、通知延迟、重试长度)。

第二部分 — 详细接口设计与示例代码

本节给出三个关键接口的详细定义与实现要点,以及 Java / PHP 的示例片段。

API 列表:

  • POST /subscription/verify — 客户端上报收据(同步返回当前订阅视图)
  • GET /subscription/status — 客户端查询订阅状态
  • POST /apple/notifications — Apple 的 Server-to-Server 通知回调(验签 + 幂等)

接口定义(示例)

  • POST /subscription/verify

    • 200:status: "active""expired"|"cancelled", expires_at: ISO8601, product_id
    • 4xx/5xx: error
    • Auth: Bearer
    • Body: { receipt: string (base64), idempotency_key: string, product_id?: string }
    • Responses:
  • GET /subscription/status

    • Auth: Bearer
    • Query: user_id or infer from token
    • 200: { subscriptions: [ { product_id, status, expires_at } ] }
  • POST /apple/notifications

    • No bearer auth; must verify Apple-signed payload
    • 200: OK when processed

实现关键点:

  • 幂等:用 idempotency_key 或 Apple 的 transaction_id 做唯一索引;
  • 验证 Apple:新版使用 JWT(由 .p8 签名生成)调用 App Store Server API;旧版 verifyReceipt 使用 password(App Shared Secret);
  • 事务与日志:订单更新与通知日志应在可回溯的事务或写日志后异步合并;
  • 稳定性:对外调用实现超时、重试与熔断策略。

示例:Java(Spring 风格,伪代码)— /subscription/verify

@RestControllerpublicclassSubscriptionController{@PostMapping("/subscription/verify")public ResponseEntity<?> verify(@RequestBody VerifyRequest req, @RequestHeader("Authorization") String auth) {// 1. 验证并解析 client JWT(略)// 2. 幂等检查if (verificationExists(req.getIdempotencyKey())) {return ResponseEntity.ok(getCachedStatus(req.getIdempotencyKey()));  }// 3. 调用 Apple 验证服务(appleClient 封装了 JWT 签名与请求)  AppleVerificationResult result = appleClient.verifyReceipt(req.getReceipt());// 4. 根据 transaction_id 做 upsert,并返回规范化状态  upsertOrderFromAppleResult(result);return ResponseEntity.ok(buildStatusResponse(result)); }}

示例:PHP(Laravel 风格,伪代码)— /apple/notifications

publicfunctionnotifications(Request $request){ $payload = $request->all();// 验签或解析 signedPayloadif (!verifyAppleSignedPayload($payload)) {return response('invalid'400); }// 幂等检查if (notificationProcessed($payload['notificationUUID'])) {return response('ok'200); } DB::transaction(function()use($payload){  insertNotificationLog($payload);  applyNotificationToOrder($payload); });return response('ok'200);}

补充:如何处理返回给客户端的订阅状态

  • 后端应返回“权威(canonical)”视图,包括 statusexpires_atproduct_id
  • 若后端对 Apple 的最终状态仍在异步校准中,可返回 pending 并在客户端重试查询。

第三部分 — 服务部署、密钥管理与具体操作步骤

本节把所有操作拆成可执行步骤:创建 .p8、获取 App Shared Secret、在服务器/容器/CI 中安全配置变量与 Secrets、示例命令与注意事项。

步骤 1:创建并下载 App Store Connect API Key(.p8

  1. 登录 App Store Connect(https://appstoreconnect.apple.com)。
  2. 打开 Users and Access → Keys。点击 Create API Key
  3. 创建后下载 AuthKey_XXXXX.p8 并记录 Key ID(示例 ABC123DEFG)与 Issuer ID(示例 1111-2222-3333-4444)。

注意:.p8 只可下载一次;若丢失需要新建并切换。

输出(应写入你的 Secrets 管理或部署说明):

  • APPLE_API_KEY_ID = Key ID
  • APPLE_ISSUER_ID = Issuer ID
  • APPLE_API_KEY_P8 = p8 私钥文本或 APPLE_API_KEY_P8_PATH 指向文件

步骤 2:生成 App 专用共享密钥(App Shared Secret)

  1. 在 App Store Connect 的 App 页面,找到 In-App Purchases / Subscriptions 设置。
  2. 查找 App-Specific Shared Secret,生成或复制。
  3. 存入 Secrets 管理(示例名 APPLE_SHARED_SECRET)。

注意:若使用旧版 verifyReceipt,请求中需要 password 字段(即 APPLE_SHARED_SECRET)。

步骤 3:在服务器 / 容器中安全配置密钥

推荐方案:

  • 生产:使用云 Secret Manager(AWS Secrets Manager / GCP Secret Manager / Azure Key Vault),并授予最小权限;
  • 容器:使用 Docker Secrets 或 Kubernetes Secret,把 .p8 挂载到容器文件系统而不是暴露为环境变量;
  • 开发:使用 .env(本地)并把 .env 加入 .gitignore,仓库保留 .env.example

示例 Documents/.env.example(已创建):

# Copy to .env and fill the real values locally. Do NOT commit .envAPPLE_API_KEY_ID=REPLACE_WITH_KEY_IDAPPLE_ISSUER_ID=REPLACE_WITH_ISSUER_IDAPPLE_SHARED_SECRET=REPLACE_WITH_SHARED_SECRETAPPLE_API_KEY_P8_PATH=/etc/keys/AuthKey_ABC123DEFG.p8

把 .p8 放到只读受限目录(Linux):

sudo mkdir -p /etc/keyssudo chown root:appuser /etc/keyssudo chmod 750 /etc/keyssudo mv AuthKey_ABC123DEFG.p8 /etc/keys/sudo chown root:appuser /etc/keys/AuthKey_ABC123DEFG.p8sudo chmod 640 /etc/keys/AuthKey_ABC123DEFG.p8

步骤 4:在后端运行时生成并使用 JWT(概要)

  • 读取 APPLE_API_KEY_P8_PATH,用私钥签名 JWT;header 包含 kid=Key ID;claims 包含 iss=Issuer ID、iatexp
  • 把 JWT 放入 Authorization: Bearer <jwt> 调用 Apple Server API;
  • 对旧流程(verifyReceipt)直接在请求 body 中放入 receipt-data 与 passwordAPPLE_SHARED_SECRET)。

步骤 5:配置 Apple Server-to-Server 通知

  1. 在 App Store Connect 配置通知回调 URL(HTTPS);
  2. 在回调处理里验证签名(或解析 signedPayload);
  3. 使用通知的唯一 id 做幂等处理,并把原始通知存档。

步骤 6:密钥轮换与运维要点

  • 支持按 kid 解签多套公钥;
  • 轮换流程:新 key 发布 → 验证与小面积流量测试 → 切换生产 → 撤销旧 key;
  • 把密钥访问写入审计日志,并设置告警(验证失败率、通知处理失败)。
推荐阅读
我的十年(工作纯享版)
失业笔记:叮!裁员礼包终于到账!
写在 35 周岁之后——大龄程序员该如何应对裁员潮
Seedance2.0 创作AI 漫剧初体验:带我打开新世界的大门!
Seedance2.0 制作漫剧逐渐上头,来看看我最新中秋独酌这一幕
Let’s Encrypt 羊毛党的安全福音
Swift async/await 并发编程实践:实现退避轮询策略

最新文章

随机文章

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