• 帮助学员打好基础,再巩固提高
  • 知识实战结合培训
  • 辅助学员更好的学习

400-689-2779

整站关键词优化全流程解析:从基础框架到效果巩固的实战指南

来源:深圳兴途教育 时间:08-30

整站关键词优化全流程解析:从基础框架到效果巩固的实战指南

整站关键词优化的核心价值与底层逻辑

在搜索引擎竞争日益激烈的当下,单靠优化某个页面或某个关键词已难以实现稳定的排名增长。整站关键词优化作为系统性工程,通过对网站全维度的诊断与调整,能有效解决传统单维度优化的局限性。它并非简单的技术叠加,而是围绕用户需求与搜索引擎算法逻辑,构建一个“可抓取、易理解、高相关”的网站生态,最终实现排名、权重、用户体验的同步提升。

举个实际案例:某企业官网曾专注优化“SEO服务”这一核心词,虽短期排名上升,但因网站结构混乱、内容重复率高,3个月后排名大幅波动。引入整站优化后,通过调整URL路径、补充行业长尾内容、优化TDK标签,不仅“SEO服务”排名稳定在首页,还带动“企业SEO托管”“外贸网站优化”等12个相关词进入前20,这正是整站优化的价值体现。

整站优化覆盖的七大核心模块

要做好整站关键词优化,需明确其覆盖的具体维度。根据多年实战经验,可将其拆解为七大模块,每个模块相互影响,共同决定网站的综合表现。

1. 网站结构优化:构建清晰的“信息地图”

搜索引擎爬虫的抓取效率与网站结构直接相关。理想的结构应像“金字塔”:首页覆盖核心关键词,栏目页承载次核心词,内容页聚焦长尾词。需重点关注三点:一是层级深度控制在3层以内,避免“首页→栏目→子栏目→内容页”超过4级;二是导航栏使用文字链接而非图片,确保爬虫可识别;三是合理设置面包屑导航,帮助用户与爬虫快速定位当前页面层级。

以电商网站为例,若“女装→连衣裙→夏季连衣裙”的路径过长,可简化为“女装→夏季连衣裙”,同时通过内部链接将“连衣裙”关键词页面与相关内容页串联,既能缩短抓取路径,又能强化关键词相关性。

2. URL优化:让地址栏成为“隐形的关键词入口”

URL不仅是网站的“门牌号”,更是传递关键词信息的重要载体。优化要点包括:使用静态化URL(如www.example.com/seo-fuwu.html),避免动态参数(如www.example.com/?id=123&cat=seo);路径中包含核心关键词(如“seo-fuwu”对应“SEO服务”);控制字符长度在60个字符以内,过长的URL易被截断。

曾有客户网站因使用“www.example.com/?p=456”的动态URL,导致百度爬虫抓取率不足30%。改为“www.example.com/seo-tuoguan.html”后,1周内抓取量提升至85%,相关关键词排名也随之上涨。

3. 内容优化:从“关键词堆砌”到“用户需求满足”

内容是网站的核心竞争力,但许多优化者仍停留在“关键词密度”的误区。真正的内容优化需围绕“用户搜索意图”展开:首先通过百度指数、5118等工具分析目标关键词的搜索需求(如搜索“整站优化”的用户,可能同时关注“费用”“周期”“效果”);其次,内容结构采用“总-分-总”模式,开头明确回答用户核心问题,中间分点展开,结尾总结并引导转化;最后,确保内容原创度>80%,重复内容不仅无法获得排名,还可能被标记为“低质”。

例如,针对“企业SEO优化多少钱”这一关键词,内容应包含“基础套餐(5000-10000元)”“定制套餐(10000-30000元)”的具体服务内容对比,而非简单重复“SEO优化费用”。这种“需求导向”的内容,既能提升用户停留时长,又能增强搜索引擎对页面的“主题相关性”判断。

4. TDK优化:标题、描述、关键词的“黄金三角”

TDK(Title标题、Description描述、Keywords关键词)是页面与搜索引擎沟通的“张名片”。标题需控制在30个汉字内(约60字符),核心关键词前置(如“整站关键词优化|专业SEO公司|XX科技”);描述需用简洁语言概括页面价值(如“XX科技提供整站关键词优化服务,覆盖结构、内容、TDK等七大模块,助力网站排名稳定提升”);关键词标签虽对排名影响弱化,但仍需填写3-5个高相关词(如“整站优化,SEO全流程,网站排名提升”),避免堆砌。

测试数据显示,优化TDK后的页面,百度展现量平均提升40%,点击率提升25%。这是因为更精准的TDK能匹配用户搜索词,提高搜索结果的“相关性”评分。

5. 链接优化:构建“活的网站关系网”

链接分为内部链接与外部链接。内部链接需遵循“核心页→栏目页→内容页”的传递逻辑,通过锚文本(如“点击了解整站优化流程”)引导爬虫抓取与用户浏览;外部链接需注重质量而非数量,优先选择行业权威网站(如SEO研究中心、站长之家)的反向链接,避免垃圾外链导致降权。

某教育机构网站曾因购买大量论坛外链,导致被百度处罚。通过清理垃圾链接、与“教育资讯网”“培训行业协会”等优质站点交换链接后,2个月内权重从2恢复至4,核心关键词排名重回首页。

6. 网站引流与长尾词布局:扩大流量覆盖范围

除了核心关键词,长尾词贡献了网站70%的流量。需通过“关键词挖掘工具+用户搜索日志”筛选高转化长尾词(如“中小企业整站优化多少钱一个月”“2024年整站优化最新方法”),并为每个长尾词创作专题内容。同时,结合社交媒体(微信、微博)、行业论坛(知乎、豆瓣)进行内容分发,吸引精准流量导入网站,提升页面访问深度与转化率。

7. 数据监测与迭代优化:让优化“有迹可循”

整站优化并非“一劳永逸”,需通过百度统计、Google Analytics等工具持续监测:关键词排名变化(是否有新关键词进入前50)、用户行为数据(跳出率、页面停留时长)、爬虫抓取日志(是否有404错误、抓取延迟)。根据数据反馈,及时调整优化策略——若某栏目页跳出率>70%,可能是内容与标题不符,需重新优化描述;若爬虫频繁抓取失败,可能是服务器响应速度过慢,需联系主机商排查。

整站优化对比单维度优化的四大优势

为何越来越多企业选择整站关键词优化?核心在于其解决了传统单维度优化的四大痛点:

  • **排名稳定性更高**:单维度优化仅解决局部问题(如只优化内容),但结构混乱可能导致爬虫抓取不全,排名易波动;整站优化通过“结构+内容+链接”的协同优化,构建稳定的排名基础。
  • **流量覆盖更全面**:单维度优化聚焦核心词,可能忽略长尾词;整站优化通过长尾词布局,能覆盖更多用户搜索场景,流量来源更分散,抗风险能力更强。
  • **用户体验更优质**:单维度优化可能牺牲体验(如过度堆砌关键词);整站优化以用户需求为中心,从结构清晰到内容实用,全面提升浏览体验,间接提高转化率。
  • **长期价值更显著**:单维度优化效果可能随算法更新消失;整站优化通过夯实网站基础(如规范的结构、优质的内容),能适应算法变化,实现“一次优化,长期受益”。

总结:整站关键词优化的执行关键

整站关键词优化的本质,是通过系统性思维解决网站的“木桶效应”——找到影响排名的最短木板(可能是结构、内容或链接),并针对性补足。这需要优化者具备“用户思维”(理解搜索需求)、“算法思维”(熟悉搜索引擎规则)和“数据思维”(通过数据指导优化)。

最后强调:整站优化没有“捷径”,需耐心执行每个环节。但一旦基础打牢,网站将进入“良性循环”——排名上升带来更多流量,流量增加提升用户行为数据,用户行为数据优化又进一步推动排名增长。这,正是整站关键词优化的魅力所在。

基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-04 04:43:16 HTTP/1.1 GET : http://www.aabqy.com/s/3872/n/23592.html
  2. 运行时间 : 0.015775s [ 吞吐率:63.39req/s ] 内存消耗:403.75kb 文件加载: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.000391s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001323s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '3872' AND `site_id` = 23 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000340s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000617s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 3872 [ RunTime:0.000236s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000606s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 3872 [ RunTime:0.000252s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000674s ]
  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` = 3872 AND `a`.`content_id` = '23592' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000617s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '3872' and content_id < '23592' and site_id <= '23' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '3872' and content_id > '23592' and site_id <= '23' order by content_id asc limit 1) [ RunTime:0.000592s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000716s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 3872 AND `site_id` = 23 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000426s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 3872 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000221s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 3872 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000182s ]
  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` = '23' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 23592 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.004960s ]
0.016087s