• 合肥中公优是中公教育IT培训品牌
  • 过理论+实战+实训的“实训教学”模式
  • 拥有行业雄厚师资,打造实力专家团队

400-888-9073

软件测试核心技术全解析:从入门到进阶的学习路径指南

来源:合肥中公优 时间:09-02

软件测试核心技术全解析:从入门到进阶的学习路径指南

软件测试技术体系的底层逻辑与学习必要性

在数字化产品迭代速度持续加快的今天,软件测试已成为保障产品质量的关键环节。无论是电商平台的秒杀活动、社交软件的新版本上线,还是金融系统的交易流程,都需要专业测试人员通过系统化技术手段识别潜在风险。合肥中公优软件测试培训团队观察到,近年来选择进入这一领域的学习者数量年均增长超35%,但真正能快速胜任企业需求的专业人才仍存在较大缺口,核心原因在于对软件测试技术体系的掌握深度不足。

要成长为企业争抢的软件测试工程师,必须构建"基础-进阶-高阶"的技术能力金字塔。这一过程需要依次攻克功能测试、自动化测试、接口测试、性能测试四大技术模块,每个模块既独立又关联,共同构成完整的软件质量保障能力。

功能测试:软件测试的基石能力

作为软件测试的入门级技术,功能测试承担着验证产品是否符合需求规格的核心任务。合肥中公优教学团队强调,这一阶段的学习需重点掌握三大知识板块:

首先是计算机基础与测试理论。学习者需要熟悉操作系统原理(如Windows/Linux的基础操作)、数据库基本语法(MySQL的增删改查)、HTTP协议交互逻辑等底层知识,同时掌握测试用例设计的核心方法——等价类划分、边界值分析、因果图法等。以电商平台的"购物车功能"测试为例,通过边界值分析可以有效验证添加1件、99件、100件商品时的系统响应是否符合预期。

其次是测试工具的基础应用。虽然功能测试以手工测试为主,但仍需掌握缺陷管理工具(如Jira、禅道)的使用,能够规范记录测试过程中发现的问题,包括重现步骤、预期结果、实际结果等关键信息。这不仅是工作流程的要求,更是提升团队协作效率的重要环节。

最后是测试流程的全周期参与。从需求评审阶段的测试点提取,到测试计划制定、测试执行、缺陷跟踪,再到最终的测试报告输出,学习者需要完整经历软件测试的生命周期。这一过程能帮助建立全局思维,理解测试工作与开发、产品等其他岗位的协同关系。

自动化测试:提升效率的核心进阶

当功能测试能力趋于成熟后,自动化测试是职业发展的必然方向。随着企业对交付速度要求的提升,重复的回归测试、多版本兼容性测试等场景,仅靠手工测试已无法满足效率需求。合肥中公优的企业调研显示,掌握自动化测试技术的工程师,其岗位薪资较单纯功能测试人员平均高出40%-60%。

自动化测试的学习可分为三个技术分支:

1. 编程语言基础:Python因其语法简洁、类库丰富,成为自动化测试的首选语言。学习者需要掌握Python的变量类型、条件判断、循环结构、函数封装等基础语法,同时熟悉Pytest测试框架的使用,能够编写可复用的测试用例。

2. Web自动化测试:基于Selenium工具库,学习者需掌握元素定位(XPath、CSS Selector)、页面操作(表单填写、文件上传、弹窗处理)、断言验证等核心技能。以教育类网站的"课程报名"功能自动化测试为例,通过Selenium可以模拟用户从浏览课程到提交报名信息的全流程,快速验证不同浏览器(Chrome、Firefox)下的功能一致性。

3. App自动化测试:针对移动端应用,需学习Appium工具的使用,掌握Android与iOS系统的差异处理(如控件定位方式、手势操作)。特别要关注移动端特有的测试场景,包括横竖屏切换、网络状态变更(4G/5G/Wi-Fi)、电量不足时的功能表现等。例如,对短视频App进行自动化测试时,需要验证在弱网环境下视频加载的流畅性和异常提示的友好性。

接口测试:微服务架构下的关键技术

在分布式系统和微服务架构普及的今天,接口测试的重要性日益凸显。不同于前端功能测试,接口测试直接验证系统内部模块间的通信质量,能够更早发现代码级缺陷。合肥中公优的教学案例显示,掌握接口测试技术的工程师,可提前30%-50%发现潜在问题,显著降低后期修复成本。

接口测试的学习需重点突破以下技术点:

- 协议与数据格式:深入理解HTTP/HTTPS协议的请求方法(GET/POST/PUT/DELETE)、状态码含义(200/404/500),以及JSON/XML数据格式的解析方法。例如,在测试用户登录接口时,需要验证POST请求携带的JSON参数(用户名、密码)是否被正确接收,返回的JSON数据中token字段是否符合预期格式。

- 工具实操:熟练使用Jmeter进行接口性能测试,Postman进行接口功能测试,Fiddler进行抓包分析。以电商平台的"订单提交"接口为例,通过Postman可以模拟不同用户身份(普通用户、VIP用户)发送请求,验证接口返回的优惠信息是否准确;使用Jmeter则可以模拟1000并发用户同时提交订单,观察接口的响应时间和错误率。

- 持续集成:结合Jenkins工具实现接口测试的自动化执行,将测试用例集成到开发流程中,实现代码提交后自动触发测试。这一技术能有效缩短测试周期,是企业DevOps转型的重要组成部分。

性能测试:保障系统稳定性的高阶能力

当系统面临高并发请求(如双十一大促、春节红包)时,性能测试是确保系统不崩溃、不超时的最后一道防线。这一技术要求测试人员不仅能发现性能瓶颈,还能通过分析给出优化建议,因此对综合能力要求极高。

性能测试的学习可分为四个阶段:

1. 理论基础:掌握性能测试的核心指标(响应时间、吞吐量、并发用户数、资源利用率),理解负载测试、压力测试、稳定性测试的区别。例如,负载测试关注系统在不同用户量下的性能表现,压力测试则是找到系统能承受的负载极限。

2. 工具操作:以Jmeter为核心工具,学习虚拟用户脚本的编写(包括参数化、关联、断言设置)、测试场景的设计(递增负载、阶梯负载)、监控数据的采集(CPU/内存/磁盘I/O)。以金融理财平台的"基金购买"功能为例,通过Jmeter模拟5000用户同时购买基金的场景,监控数据库的QPS(每秒查询数)和服务器的内存占用情况。

3. 报告分析:能够从测试报告中定位性能瓶颈,例如发现数据库查询耗时过长可能是索引缺失导致,服务器CPU过高可能是代码死循环引起。合肥中公优的教学中会通过真实项目案例,指导学习者如何结合监控数据和代码日志进行深度分析。

4. 优化建议:基于分析结果,提出具体的优化方案,如数据库层面的索引优化、代码层面的循环简化、架构层面的分布式部署等。这一能力是区分普通测试工程师与高级测试专家的关键。

软件测试学习的实践建议与课程选择

掌握上述技术模块需要系统的学习路径和大量的实操练习。合肥中公优软件测试培训课程采用"理论+实战+企业项目"的三维教学模式,课程内容覆盖功能测试基础、自动化测试进阶、接口与性能测试高阶,同时引入电商、金融、教育等多个行业的真实项目案例,帮助学习者在实践中巩固技术。

对于有意向的学习者,建议先通过免费网课体验教学风格。网课内容包含软件测试入门知识、工具基础操作等实用内容,可帮助快速判断是否符合自身学习需求。若网课体验良好,欢迎预约线下免费试听,实地感受真实课堂氛围和项目实操环境。

需要特别说明的是,软件测试技术的学习是一个持续进阶的过程。从功能测试到性能测试,每个阶段都需要投入时间和精力进行实践。选择一家具备企业级项目资源、经验丰富的师资团队的培训机构,能有效缩短学习周期,少走技术弯路。

基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-04 13:53:37 HTTP/1.1 GET : http://www.peixunbb.com/s/2853/n/17751.html
  2. 运行时间 : 0.016120s [ 吞吐率:62.03req/s ] 内存消耗:412.23kb 文件加载: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.000323s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001191s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '2853' AND `site_id` = 14 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000294s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000781s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 2853 [ RunTime:0.000286s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000824s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 2853 [ RunTime:0.000334s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000827s ]
  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` = 2853 AND `a`.`content_id` = '17751' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.001072s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '2853' and content_id < '17751' and site_id <= '14' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '2853' and content_id > '17751' and site_id <= '14' order by content_id asc limit 1) [ RunTime:0.000746s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000693s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 2853 AND `site_id` = 14 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000378s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 2853 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000230s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 2853 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000202s ]
  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` = '14' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 17751 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.004080s ]
0.016409s