• 面向全球的一站式IT服务供应商
  • 中国IT职业人才培训领域的先行者
  • 致力于为应届毕业生和职场新人提供IT职业培训

400-882-1633

软件测试全流程核心知识详解:从基础概念到测试类型全解析

来源:合肥博为峰 时间:09-25

软件测试全流程核心知识详解:从基础概念到测试类型全解析

软件测试的本质与核心价值

在数字技术深度渗透的今天,软件已成为各行业运行的核心载体。而保障软件可靠性的关键环节——软件测试,正随着技术迭代不断扩展边界。简单来说,软件测试是通过系统性手段验证软件是否符合预期要求的过程,其核心目标不仅在于发现缺陷,更在于通过持续验证提升软件质量,确保最终产品能满足用户实际需求。

行业普遍认可的解释中,软件测试包含三重内涵:其一,作为质量促进过程,它贯穿软件全生命周期,通过科学方法验证正确性、完整性与安全性;其二,是实际输出与预期结果的对比机制,通过数据化分析识别偏差;其三,融合人工与自动化手段的操作过程,既包含对功能的显性验证,也涵盖对潜在风险的隐性排查。这种多维度的定义,决定了软件测试在软件开发中的关键地位。

软件质量:测试的终极衡量标准

理解软件测试,必须先明确其服务对象——软件质量。这里的质量并非单一维度的"无缺陷",而是软件满足规定或潜在用户需求的综合能力。具体表现为三个层面:一是功能与性能符合需求文档的明确描述,例如电商平台的支付功能需支持多种支付方式且响应时间≤2秒;二是开发过程符合行业标准,如代码遵循统一的命名规范、注释完整度达标;三是具备专业软件应有的隐含特征,包括可维护性、可扩展性、兼容性等。

举个例子,一款教育类APP不仅需要实现课程播放、作业提交等基础功能,还需在用户量激增时保持稳定运行(性能要求),在不同手机型号上呈现一致界面(兼容性要求),甚至在后续更新中能快速添加新功能(可扩展性要求)。这些都需要通过测试环节逐一验证。

测试全周期覆盖:从需求到交付的关键节点

软件测试并非仅存在于开发后期,而是贯穿从需求分析到上线运维的全生命周期。在需求阶段,需验证需求文档的完整性与可行性;设计阶段要检查架构设计是否满足性能与扩展要求;开发阶段通过单元测试、集成测试确保代码质量;发布前进行系统测试与验收测试;上线后还需持续监控运行状态,开展回归测试预防迭代风险。这种全周期覆盖,确保了每个环节的问题都能被及时发现。

以某金融系统开发为例:需求阶段需测试业务流程是否覆盖所有交易场景;设计阶段验证数据库架构能否支持百万级并发;开发阶段对每个接口进行单元测试;集成时检查模块间数据传输的准确性;系统测试模拟真实用户操作验证整体功能;最终由客户进行验收测试确认符合业务需求。每个环节的测试数据都会形成质量报告,为后续优化提供依据。

测试类型全景图:按维度划分的技术体系

根据不同维度,软件测试可分为多种类型。从开发阶段看,包含单元测试、集成测试、系统测试、验收测试四大阶段;从实施主体划分,涉及开发方自测、用户现场测试、第三方独立测试;从技术方法区分,则有白盒测试、黑盒测试、灰盒测试三种主流路径。每种分类下又包含具体的测试方法,共同构成完整的测试技术体系。

(一)按技术方法划分的核心类型

  • 黑盒测试:将被测对象视为不可见内部结构的"黑箱",仅依据需求文档验证功能是否达标。常见方法包括等价类划分(将输入数据分为有效/无效类别)、边界值分析(重点测试输入范围的边界点)、因果图分析(通过因果关系推导测试用例)等。例如测试一个登录功能,黑盒测试会关注输入正确/错误的账号密码时,系统是否返回对应的提示信息,而不涉及后台验证逻辑。
  • 白盒测试:与黑盒相反,强调对内部代码逻辑的深度检查。测试人员需了解程序结构,设计覆盖所有逻辑路径的测试用例。典型方法有语句覆盖(确保每条代码都被执行)、判定覆盖(覆盖所有条件分支)、路径覆盖(遍历所有可能的执行路径)等。例如验证一个计算函数,白盒测试会检查从输入到输出的每一条代码路径是否正确处理数据,包括循环次数、条件判断等细节。
  • 灰盒测试:结合黑盒与白盒的特点,既关注功能实现,也适当了解内部结构。常见于接口测试场景,例如测试两个模块间的数据传输,需知道接口参数定义(白盒信息),但无需深入每个模块的内部逻辑(黑盒验证)。

(二)按开发阶段划分的关键节点

  • 单元测试:针对最小可测试单元(如函数、类)的验证,是测试金字塔的基础。开发人员需在编码后立即执行,确保单个模块的正确性。例如一个计算订单金额的函数,单元测试会验证正常订单、折扣订单、空订单等不同输入场景下的输出是否符合预期。
  • 集成测试:当多个单元组合成模块后,验证模块间接口的正确性。常见策略有自顶向下(从高层模块开始逐步集成)和自底向上(从底层模块向上集成)。例如电商系统中,支付模块与订单模块集成时,需测试支付成功后订单状态是否自动更新为"已支付"。
  • 系统测试:对集成后的完整系统进行全面验证,覆盖功能、性能、安全等多维度。测试用例需模拟真实用户场景,例如社交APP的系统测试会包含高并发登录、大文件上传、敏感信息加密等测试点。
  • 验收测试:由用户或客户执行的最终验证,确保系统符合业务需求。测试环境通常与生产环境一致,例如医疗管理系统的验收测试会在医院真实业务场景中进行,验证挂号、分诊、病历管理等功能是否满足医护人员操作习惯。

(三)其他常见测试类型解析

  • 回归测试:在代码修改后重新执行原有测试用例,确认变更未引入新缺陷。例如修复一个支付bug后,需重新测试订单生成、库存扣减等关联功能,确保修复操作未影响其他模块。
  • 自动化测试:利用测试工具(如Selenium、JMeter)自动执行测试用例,适用于重复执行的场景。例如APP的每日冒烟测试(验证基本功能是否正常),通过自动化脚本可快速完成,节省人力。
  • 性能测试:评估系统在不同负载下的表现,包含负载测试(逐步增加用户量观察性能变化)和压力测试(找到系统承载能力)。例如视频直播平台需通过性能测试确定同时在线10万人时的卡顿率、延迟等指标是否达标。
  • UI测试:验证用户界面的友好性与一致性,包括布局是否合理、文字是否准确、操作是否流畅等。例如金融类APP的UI测试会检查按钮颜色是否符合品牌规范、输入框提示语是否清晰易懂。

测试实践的核心要点与发展趋势

在实际测试工作中,需注意三点:一是测试用例的设计要覆盖正常、异常、边界等多场景,避免遗漏潜在问题;二是测试结果需及时反馈,与开发团队协同定位缺陷;三是结合自动化工具提升效率,尤其是对重复执行的测试任务。随着DevOps的普及,测试正从独立阶段向持续集成演进,测试人员需更早参与需求讨论,更紧密地与开发、运维协作,实现"左移测试"(提前发现问题)与"右移测试"(上线后持续监控)。

未来,AI技术将深度赋能测试领域。通过机器学习分析历史缺陷数据,可智能生成测试用例;利用自然语言处理解析需求文档,自动提取测试点;借助智能监控实时识别系统异常,实现预测性测试。这些技术的应用,将推动软件测试从"发现缺陷"向"预防缺陷"升级,进一步提升软件质量保障能力。

课程导航
校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-06 11:42:28 HTTP/1.1 GET : http://www.edujk.com/s/4825/n/29374.html
  2. 运行时间 : 0.017871s [ 吞吐率:55.96req/s ] 内存消耗:378.91kb 文件加载:137
  3. 缓存信息 : 0 reads,0 writes
  1. /data/web/baijiao_branch_collect/public/index.php ( 0.79 KB )
  2. /data/web/baijiao_branch_collect/vendor/autoload.php ( 0.75 KB )
  3. /data/web/baijiao_branch_collect/vendor/composer/autoload_real.php ( 1.63 KB )
  4. /data/web/baijiao_branch_collect/vendor/composer/platform_check.php ( 0.90 KB )
  5. /data/web/baijiao_branch_collect/vendor/composer/ClassLoader.php ( 15.99 KB )
  6. /data/web/baijiao_branch_collect/vendor/composer/autoload_static.php ( 4.26 KB )
  7. /data/web/baijiao_branch_collect/vendor/topthink/think-helper/src/helper.php ( 8.34 KB )
  8. /data/web/baijiao_branch_collect/vendor/topthink/think-validate/src/helper.php ( 2.19 KB )
  9. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/helper.php ( 1.47 KB )
  10. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/stubs/load_stubs.php ( 0.16 KB )
  11. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
  12. /data/web/baijiao_branch_collect/vendor/topthink/think-container/src/Facade.php ( 2.71 KB )
  13. /data/web/baijiao_branch_collect/vendor/symfony/deprecation-contracts/function.php ( 0.99 KB )
  14. /data/web/baijiao_branch_collect/vendor/symfony/polyfill-mbstring/bootstrap.php ( 8.26 KB )
  15. /data/web/baijiao_branch_collect/vendor/symfony/polyfill-mbstring/bootstrap80.php ( 9.78 KB )
  16. /data/web/baijiao_branch_collect/vendor/symfony/var-dumper/Resources/functions/dump.php ( 1.49 KB )
  17. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/App.php ( 15.30 KB )
  18. /data/web/baijiao_branch_collect/vendor/topthink/think-container/src/Container.php ( 15.76 KB )
  19. /data/web/baijiao_branch_collect/vendor/psr/container/src/ContainerInterface.php ( 1.02 KB )
  20. /data/web/baijiao_branch_collect/app/provider.php ( 0.19 KB )
  21. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Http.php ( 6.04 KB )
  22. /data/web/baijiao_branch_collect/vendor/topthink/think-helper/src/helper/Str.php ( 7.29 KB )
  23. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Env.php ( 4.68 KB )
  24. /data/web/baijiao_branch_collect/app/common.php ( 10.83 KB )
  25. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/helper.php ( 18.78 KB )
  26. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Config.php ( 5.54 KB )
  27. /data/web/baijiao_branch_collect/config/app.php ( 1.29 KB )
  28. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
  29. /data/web/baijiao_branch_collect/config/cache.php ( 1.22 KB )
  30. /data/web/baijiao_branch_collect/config/config.php ( 0.26 KB )
  31. /data/web/baijiao_branch_collect/config/console.php ( 0.29 KB )
  32. /data/web/baijiao_branch_collect/config/cookie.php ( 0.56 KB )
  33. /data/web/baijiao_branch_collect/config/database.php ( 2.29 KB )
  34. /data/web/baijiao_branch_collect/config/filesystem.php ( 0.63 KB )
  35. /data/web/baijiao_branch_collect/config/lang.php ( 0.81 KB )
  36. /data/web/baijiao_branch_collect/config/log.php ( 1.37 KB )
  37. /data/web/baijiao_branch_collect/config/middleware.php ( 0.19 KB )
  38. /data/web/baijiao_branch_collect/config/route.php ( 1.54 KB )
  39. /data/web/baijiao_branch_collect/config/session.php ( 0.57 KB )
  40. /data/web/baijiao_branch_collect/config/trace.php ( 0.34 KB )
  41. /data/web/baijiao_branch_collect/config/view.php ( 0.81 KB )
  42. /data/web/baijiao_branch_collect/app/event.php ( 0.25 KB )
  43. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Event.php ( 7.67 KB )
  44. /data/web/baijiao_branch_collect/app/service.php ( 0.13 KB )
  45. /data/web/baijiao_branch_collect/app/AppService.php ( 0.26 KB )
  46. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Service.php ( 1.64 KB )
  47. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Lang.php ( 7.35 KB )
  48. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/lang/zh-cn.php ( 13.70 KB )
  49. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/initializer/Error.php ( 3.31 KB )
  50. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
  51. /data/web/baijiao_branch_collect/vendor/services.php ( 0.14 KB )
  52. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
  53. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
  54. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/service/ModelService.php ( 2.04 KB )
  55. /data/web/baijiao_branch_collect/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
  56. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Middleware.php ( 6.72 KB )
  57. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
  58. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/Paginator.php ( 11.86 KB )
  59. /data/web/baijiao_branch_collect/vendor/topthink/think-validate/src/Validate.php ( 63.20 KB )
  60. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/Model.php ( 23.55 KB )
  61. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 21.05 KB )
  62. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/concern/AutoWriteData.php ( 4.20 KB )
  63. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 6.75 KB )
  64. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/concern/DbConnect.php ( 5.16 KB )
  65. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.33 KB )
  66. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 28.30 KB )
  67. /data/web/baijiao_branch_collect/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
  68. /data/web/baijiao_branch_collect/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
  69. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/contract/Modelable.php ( 0.09 KB )
  70. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Db.php ( 2.88 KB )
  71. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/DbManager.php ( 8.52 KB )
  72. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Log.php ( 6.28 KB )
  73. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Manager.php ( 3.92 KB )
  74. /data/web/baijiao_branch_collect/vendor/psr/log/src/LoggerTrait.php ( 2.69 KB )
  75. /data/web/baijiao_branch_collect/vendor/psr/log/src/LoggerInterface.php ( 2.71 KB )
  76. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Cache.php ( 4.92 KB )
  77. /data/web/baijiao_branch_collect/vendor/psr/simple-cache/src/CacheInterface.php ( 4.71 KB )
  78. /data/web/baijiao_branch_collect/vendor/topthink/think-helper/src/helper/Arr.php ( 17.45 KB )
  79. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/cache/driver/Redis.php ( 6.94 KB )
  80. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/cache/Driver.php ( 9.03 KB )
  81. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 1.99 KB )
  82. /data/web/baijiao_branch_collect/app/Request.php ( 0.09 KB )
  83. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Request.php ( 55.78 KB )
  84. /data/web/baijiao_branch_collect/app/middleware.php ( 0.26 KB )
  85. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
  86. /data/web/baijiao_branch_collect/vendor/topthink/think-trace/src/TraceDebug.php ( 3.40 KB )
  87. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Route.php ( 23.73 KB )
  88. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/RuleName.php ( 5.75 KB )
  89. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/Domain.php ( 2.53 KB )
  90. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/RuleGroup.php ( 22.43 KB )
  91. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/Rule.php ( 26.95 KB )
  92. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.78 KB )
  93. /data/web/baijiao_branch_collect/route/app.php ( 3.05 KB )
  94. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/facade/Route.php ( 4.70 KB )
  95. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 4.74 KB )
  96. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/Dispatch.php ( 10.44 KB )
  97. /data/web/baijiao_branch_collect/app/controller/Index.php ( 33.26 KB )
  98. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/facade/Request.php ( 9.20 KB )
  99. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/Url.php ( 14.07 KB )
  100. /data/web/baijiao_branch_collect/app/model/IndexModel.php ( 19.95 KB )
  101. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/facade/Config.php ( 1.37 KB )
  102. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/facade/Cache.php ( 2.06 KB )
  103. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/facade/Db.php ( 0.93 KB )
  104. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 5.73 KB )
  105. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/PDOConnection.php ( 53.74 KB )
  106. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/Connection.php ( 8.39 KB )
  107. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.57 KB )
  108. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 16.58 KB )
  109. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/Builder.php ( 24.07 KB )
  110. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/BaseBuilder.php ( 27.50 KB )
  111. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/Query.php ( 15.97 KB )
  112. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/BaseQuery.php ( 45.13 KB )
  113. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.43 KB )
  114. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
  115. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 20.07 KB )
  116. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.66 KB )
  117. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 7.01 KB )
  118. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 19.37 KB )
  119. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 7.11 KB )
  120. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.63 KB )
  121. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.77 KB )
  122. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/log/driver/File.php ( 5.96 KB )
  123. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
  124. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/log/Channel.php ( 3.89 KB )
  125. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/event/LogRecord.php ( 1.02 KB )
  126. /data/web/baijiao_branch_collect/vendor/topthink/think-helper/src/Collection.php ( 16.47 KB )
  127. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Response.php ( 8.81 KB )
  128. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/response/View.php ( 3.29 KB )
  129. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Cookie.php ( 6.06 KB )
  130. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/View.php ( 4.39 KB )
  131. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/view/driver/Php.php ( 6.44 KB )
  132. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/contract/TemplateHandlerInterface.php ( 1.60 KB )
  133. /data/web/baijiao_branch_collect/view/index/pc/school_news_details.php ( 2.39 KB )
  134. /data/web/baijiao_branch_collect/view/index/pc/school_top.php ( 5.76 KB )
  135. /data/web/baijiao_branch_collect/view/index/pc/school_right.php ( 2.17 KB )
  136. /data/web/baijiao_branch_collect/view/index/pc/school_bottom.php ( 1.16 KB )
  137. /data/web/baijiao_branch_collect/vendor/topthink/think-trace/src/Html.php ( 4.42 KB )
  1. CONNECT:[ UseTime:0.000348s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001169s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '4825' AND `site_id` = 4 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000295s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000618s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 4825 [ RunTime:0.000255s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000621s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 4825 [ RunTime:0.000248s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000743s ]
  9. SELECT `a`.*,`content` FROM `fqi_school_news` `a` LEFT JOIN `fqi_school_news_content` `b` ON `b`.`content_id`=`a`.`content_id` WHERE `school_id` = 4825 AND `a`.`content_id` = '29374' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000662s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '4825' and content_id < '29374' and site_id <= '4' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '4825' and content_id > '29374' and site_id <= '4' order by content_id asc limit 1) [ RunTime:0.000727s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000741s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 4825 AND `site_id` = 4 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000421s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 4825 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000209s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 4825 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000167s ]
  15. SELECT `content_id`,`news_name`,`a`.`school_id`,`b`.`school_name` FROM `fqi_school_news` `a` LEFT JOIN `fqi_school` `b` ON `b`.`school_id`=`a`.`school_id` WHERE `a`.`site_id` = '4' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 29374 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.007027s ]
0.018194s