• 为社会培养高端复合型职业人才
  • 致力于提升学生的自我管理能力和职业素养
  • 注重学生职业思维能力的培养和身心健康的发展

400-666-4820

重庆开发者计算机技术进阶指南:三大核心路径深度解析

来源:重庆聚英技工学校 时间:03-14

重庆开发者计算机技术进阶指南:三大核心路径深度解析

重庆开发者计算机技术进阶指南:三大核心路径深度解析

技术提升的底层逻辑:从零散到系统的突破

在重庆的互联网技术圈,常能听到开发者讨论类似困惑:"学了很多新技术,为什么项目中还是用不上?""代码写了不少,可架构能力总上不去?"这些问题的核心,往往在于技术提升路径的不系统。真正的技术进阶,不是简单的技能叠加,而是通过"输入-消化-输出"的闭环,构建起可迁移的技术思维。本文将围绕三个关键动作展开——系统阅读、源码研读、代码重构,为重庆开发者提供可落地的技术突破方案。

环:技术阅读的广度与深度平衡

提到技术学习,"看书"是最基础却最易被轻视的环节。重庆某互联网公司技术主管张工分享过自己的经历:早期专注Java开发时,他认为只要掌握框架用法就能应对工作,直到接手一个需要跨平台协作的项目,因对C++底层机制不熟悉,导致接口调试耗时超预期。这让他意识到,技术阅读不能局限于单一领域。

具体来说,技术阅读需分两层推进:

1. 编程语言与工具链的横向拓展:除了Java、Python等主流语言,C/C++的内存管理机制、Windows与Unix系统的差异、C#的委托与事件模型,都是构建技术视野的关键。以Linux系统为例,深入理解其进程调度、文件系统原理,能帮助开发者在分布式系统设计中更合理地分配资源。

2. 软件工程思维的纵向深化:技术能力的天花板,往往由工程思维决定。《人月神话》中关于"焦油坑"的论述,揭示了大型项目开发中沟通成本的重要性;《敏捷开发实战》里的用户故事拆分方法,能帮助团队更精准地对接需求。笔者曾参与一个金融系统开发项目,初期因忽视版本控制规范,导致团队代码冲突频繁,后来引入《团队之美》中提到的分支管理策略,效率提升近40%。

值得注意的是,技术阅读要避免"收藏吃灰"的误区。建议建立阅读笔记库,将书中的关键概念与实际项目场景关联。例如阅读《Unix网络编程》时,可结合公司现有接口服务,分析TCP/IP协议在具体业务中的实现差异。

第二环:源代码阅读的"淘金"方法论

当多数开发者还在依赖文档和教程时,工程师早已将源代码作为"技术字典"。在重庆某AI企业的技术团队中,有个不成文的规定:新入职的后端开发必须在3个月内通读Spring Framework核心模块源码。团队负责人解释:"看文档只能知道'怎么用',读源码才能明白'为什么这样设计'。"

源代码阅读并非盲目翻找,需掌握科学方法:

1. 目标导向选源码:根据当前技术方向选择项目。若专注Web开发,Spring、MyBatis是必看;做大数据开发,Hadoop HDFS、Spark Core值得深入;前端开发者则可研究React的调和算法实现。以笔者为例,10年前因负责企业级应用开发,重点研读了JSF/MyFaces 80%的源码,其中关于组件生命周期的设计,至今仍在指导项目中的状态管理模块开发。

2. 分层拆解抓主线:大型框架源码往往包含成百上千个类,直接通读易陷入细节。正确的做法是从核心功能入手,逐步扩展。以Spring Framework为例,先理解IOC容器的Bean加载流程(BeanFactory -> ApplicationContext),再研究AOP的动态代理实现,最后关注与其他模块(如Spring MVC)的集成逻辑。去年笔者研究Hadoop HDFS Client时,先梳理了文件读写的核心接口(FileSystem、DFSClient),再深入分析租约机制、副本策略等细节,事半功倍。

3. 实践验证促吸收:阅读源码后,通过"仿写+测试"巩固理解。比如看完Spring的依赖注入实现,可以尝试用Java反射机制写一个简易版IOC容器;研究完HDFS的副本复制逻辑,可设计一个小实验,模拟网络延迟场景下的副本修复过程。这种"输入-输出"的闭环,能让源码中的设计思想真正转化为自身能力。

第三环:代码重构的"洁癖式"实践

在重庆某电商公司的代码仓库里,流传着一个"100行魔咒"——任何超过100行的方法体,都会被技术评审会重点关注。这种看似苛刻的要求,实则是团队对代码质量的坚守。正如《重构:改善既有代码的设计》中所言:"烂代码不是某个人的错,而是团队持续妥协的结果。"

代码重构的关键在于建立"预防-识别-优化"的全流程意识:

1. 编码阶段的预防机制:从写行代码开始,就应遵循"单一职责"原则。方法体长度严格控制在10-20行,复杂逻辑拆分为多个子方法;类的功能边界要清晰,避免"大而全"的上帝类。笔者曾参与重构一个订单处理模块,原代码中包含支付校验、物流对接、优惠计算等20多个功能点,拆分后形成8个独立类,后续需求变更的响应速度提升了60%。

2. 烂代码的识别信号:当遇到以下情况时,重构已迫在眉睫——重复代码超过3处(可提取工具类)、方法参数超过5个(考虑封装参数对象)、嵌套if-else超过3层(用策略模式或状态模式替代)、类名/方法名无法准确描述功能(需重命名)。曾接手一个遗留系统,其中有个"processData"方法包含2000多行代码,嵌套了7层条件判断,最终通过引入工厂模式+责任链模式,将代码量缩减至原1/5,可维护性大幅提升。

3. 重构后的验证保障:每次重构都需配套单元测试,确保功能不变。推荐使用JUnit+Mockito组合,覆盖正常流程、异常场景、边界条件。某金融项目中,团队对核心交易接口进行重构时,编写了120个测试用例,覆盖了98%的代码分支,有效避免了重构导致的线上故障。

重庆开发者的进阶启示:技术提升是一场持续修行

从系统阅读到源码研读,再到代码重构,这三个环节并非孤立存在,而是相互促进的技术提升闭环。重庆的开发者们身处西南地区重要的数字经济枢纽,面对智能网联汽车、人工智能等新兴产业的技术需求,更需要通过系统化的能力建设,抓住技术升级的窗口期。

最后想强调的是,技术提升没有捷径,但有方法。与其焦虑于"学什么",不如专注于"怎么学"。当你真正掌握了阅读的深度、源码的逻辑、重构的技巧,技术能力的跃升会成为水到渠成的结果。愿每一位重庆开发者,都能在技术的道路上,走出属于自己的坚实步伐。

课程导航
校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-06 03:21:59 HTTP/1.1 GET : http://www.aabqn.com/s/5368/n/31797.html
  2. 运行时间 : 0.021937s [ 吞吐率:45.59req/s ] 内存消耗:387.55kb 文件加载: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.000337s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001445s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '5368' AND `site_id` = 18 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000320s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000830s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 5368 [ RunTime:0.000278s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000809s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 5368 [ RunTime:0.000310s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000955s ]
  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` = 5368 AND `a`.`content_id` = '31797' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000711s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '5368' and content_id < '31797' and site_id <= '18' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '5368' and content_id > '31797' and site_id <= '18' order by content_id asc limit 1) [ RunTime:0.000914s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000967s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 5368 AND `site_id` = 18 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000564s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 5368 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000250s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 5368 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000235s ]
  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` = '18' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 31797 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.009640s ]
0.022239s