• 济南达内教育秉承“出高徒、高徒拿高薪”
  • 济南达内教育雄厚的技术能力和研发实力及过硬的教学质量。
  • 济南达内教育集人才培训、人才输送、软件开发为一体;

400-882-1933

网络维护核心场景解析:长距离布线难题与数据中心光纤部署全指南

来源:济南达内教育 时间:10-09

网络维护核心场景解析:长距离布线难题与数据中心光纤部署全指南

长距离网线施工:从标准到实战的解决方案

在企业网络部署中,办公区域空间跨度大是常见问题——比如办公大楼横向宽度超过百米,而网络接入点仅设置在大楼一侧,如何确保每层都能稳定高速联网?这不仅涉及基础网络知识,更需要遵循国际标准与工程经验的结合。

首先明确基础标准:平衡双绞线(即常见的超五类、六类网线)的有效传输距离,国际电工委员会(IEC)与TIA/EIA标准均限定为100米。这一数值的设定基于信号衰减、串扰等物理特性的综合考量——超过100米后,信号质量会因线缆电阻、电磁干扰等因素显著下降,具体表现为丢包率上升、传输速率降低,甚至出现间歇性断连。

以某企业办公大楼为例,建筑宽度达180米,网络接入点位于东侧。若按传统单点布线,西侧区域的网线长度将超过100米标准。此时规范的解决方案是:在楼层中间位置增设电信间(即网络分线箱),将整层划分为东西两个区域。东侧区域网线从主接入点敷设至东侧信息插座(长度≤90米),西侧区域网线则从新增电信间引出(同样控制在90米内)。这种“双电信间”设计既能满足标准要求,又能通过分区域管理降低后续维护复杂度。

部分场景下,可能因建筑结构限制无法增设电信间。此时有人会尝试使用高规格线缆(如七类网线)或优质模块直接延长布线。需注意的是,这类操作虽可能在短时间内维持网络连通(如支持10BASE-T的10Mbps速率),但无法对高速网络(如1000BASE-T的1000Mbps或万兆网络)的稳定支持。更关键的是,超标准布线会增加故障隐患——温湿度变化、线缆老化等因素可能导致原本“勉强可用”的线路突然失效,影响业务连续性。

另一种可行方案是中继设备介入。当线缆长度必须超过100米时,可在中间位置加装交换机或集线器。这类设备能重新放大、信号,补偿传输过程中的损耗。例如,在80米处放置一台非网管型交换机,前80米线缆连接主接入点与交换机,后80米线缆连接交换机与终端,总长度160米仍可稳定运行。需注意的是,中继设备需选择与现有网络兼容的型号(如支持相同的传输协议、端口速率),并做好设备供电与散热设计。

数据中心Fiber Channel布线:从选型到施工的技术要点

数据中心作为企业核心信息枢纽,其网络布线对稳定性、速率、扩展性有更高要求。Fiber Channel(光纤通道)因支持万兆级高速传输,成为存储网络(SAN)的主流选择。但不同于普通网线,光纤布线需关注更多技术细节。

1. 传输距离与光纤类型匹配

光纤分为多模与单模两大类,需根据数据中心内设备间的实际距离选择:

  • OM3多模光纤:采用850nm激光器,支持万兆(10Gbps)传输的距离为300米(针对10GBASE-SR标准),若升级至OM4多模光纤,传输距离可延长至550米。适用于数据中心内同一机房或相邻机房的设备互联。
  • 单模光纤:使用1310nm或1550nm激光器,传输距离可达10-40公里(具体取决于光模块功率)。主要用于数据中心之间的长距离互联(如主数据中心与灾备中心),或同一园区内跨建筑的光纤链路。

实际部署中需注意:多模光纤的芯径较粗(50μm或62.5μm),成本较低但传输距离有限;单模光纤芯径仅9μm,成本较高但适合长距离。需结合预算与传输需求综合选型。

2. 连接器与适配器的标准化选择

Fiber Channel设备的端口类型直接决定连接器的选择。目前主流的连接器包括:

  • SC连接器:方形接口,采用插拔式设计,具有较高的机械强度,常见于早期数据中心设备。
  • LC连接器:小尺寸接口(仅为SC的1/2),支持高密度部署,是当前万兆及以上网络的主流选择(如服务器、存储阵列的光口)。

施工时需确保连接器与设备端口完全匹配,避免因接口不兼容导致的信号衰减或无法连接。同时,光纤端面的清洁至关重要——灰尘、划痕会显著降低光信号耦合效率,建议使用专用清洁工具(如无尘布、光纤清洁笔)定期维护。

3. 防火等级与敷设方式的合规性

数据中心的防火等级(如GB 50174-2017《数据中心设计规范》中的A级、B级)对光纤线缆的燃烧性能有明确要求:

  • A级机房(容错型):要求线缆达到IEC 60332-3-24规定的成束燃烧A级(LSZH,低烟无卤),避免燃烧时释放有毒气体。
  • B级机房(冗余型):可选用成束燃烧B级线缆,但仍需满足低烟要求。

若采用敞开式电缆桥架敷设(常见于模块化数据中心),需额外检查线缆外护套的抗机械损伤能力,避免因桥架边缘摩擦导致的护套破损。对于垂直敷设(如从机房地板下至机柜顶部),应使用带有加强芯的光纤(如中心束管式结构),防止线缆自重导致的拉伸变形。

4. 光配线模块的合理布局

光配线模块是光纤链路的“枢纽”,其位置直接影响布线灵活性与维护效率。常见的部署场景包括:

  • 设备机柜顶部:适用于小规模数据中心,模块与设备光口直接相连,减少跳纤长度(建议跳纤≤5米)。
  • 布线列头柜:大型数据中心中,将光配线模块集中安装在列头柜内,便于统一管理与扩容,同时降低线缆交叉混乱的风险。
  • 敞开式桥架上:针对模块化数据中心的“即插即用”需求,可将光配线模块固定在桥架侧面,配合预端接光纤组件实现快速部署。

无论选择哪种方式,都需预留足够的操作空间(建议模块前预留600mm以上),并标注清晰的链路标识(如“存储区-服务器区”“主链路-备份链路”),以便日常维护与故障排查。

总结:网络维护的核心是标准与实践的结合

从长距离网线的规范施工到数据中心光纤的精准部署,网络维护的本质是在遵循国际标准(如TIA/EIA、IEC)的基础上,结合具体场景灵活调整。无论是增设电信间、使用中继设备,还是根据传输距离选择光纤类型、匹配连接器,其最终目标都是构建稳定、高效、可扩展的网络环境。

对于从业者而言,掌握这些技术要点不仅能提升项目交付质量,更能在面对复杂网络问题时快速定位根源、提出解决方案。随着5G、云计算等技术的发展,网络维护的场景将更加多样化,但“以标准为基础,以实践为导向”的核心原则始终不变。

校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-06-19 14:09:29 HTTP/1.1 GET : http://www.edufv.com/s/2983/n/18465.html
  2. 运行时间 : 0.012229s [ 吞吐率:81.77req/s ] 内存消耗:403.01kb 文件加载: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.000362s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001017s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '2983' AND `site_id` = 6 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000283s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000621s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 2983 [ RunTime:0.000230s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000614s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 2983 [ RunTime:0.000200s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000666s ]
  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` = 2983 AND `a`.`content_id` = '18465' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000295s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '2983' and content_id < '18465' and site_id <= '6' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '2983' and content_id > '18465' and site_id <= '6' order by content_id asc limit 1) [ RunTime:0.000460s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000709s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 2983 AND `site_id` = 6 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000316s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 2983 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000235s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 2983 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000180s ]
  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` = '6' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 18465 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.001738s ]
0.012546s