• 方普管理是国内认证、咨询、培训一体化标准服务创新领导品牌之一
  • 我们拥有来自全国的专家与稳定的核心顾问团队
  • 针对每项任务内容派遣具有相应技能的专业人士

400-888-4011

信息安全管理体系构建全流程指南:从策划到审核的实操要点

来源:福州方普管理 时间:08-05

信息安全管理体系构建全流程指南:从策划到审核的实操要点

信息安全管理体系构建全流程指南:从策划到审核的实操要点

一、前期筹备:体系搭建的基础工程

信息安全管理体系(ISMS)的建设并非一蹴而就,前期筹备阶段直接影响后续实施效果。这一阶段需要完成三项核心任务:首先是组织内部的认知统一——通过针对性培训,让管理层理解体系建设的战略意义,技术团队掌握基础方法论,业务部门明确自身安全责任。某制造业企业的实践显示,未开展前期培训的项目,后期执行偏差率高达40%。

其次是制定可执行的实施计划。建议采用"阶段目标+里程碑"的双轨制规划,例如将3个月设为基础准备期,6个月完成框架搭建,12个月实现体系试运行。计划需明确责任部门与协作机制,避免出现"多头管理"或"责任真空"。

最后是资源配置与现状调研。资源不仅包括人力、预算等显性投入,更需关注现有信息资产台账的完善程度。某金融机构的经验表明,未建立完整资产清单的项目,风险评估覆盖率仅能达到65%。同时需调研行业安全管理动态,参考ISO 27001等国际标准,结合组织实际情况调整实施路径。

二、范围界定:精准锁定管理边界

确定ISMS适用范围是避免"大而全"陷阱的关键步骤。组织需根据业务优先级、资产价值和风险等级,选择全组织覆盖或重点领域实施。某互联网企业曾因盲目追求"全覆盖",导致核心支付系统的安全投入被稀释,最终发生数据泄露事件。

具体操作时,可将组织划分为若干安全控制域。例如科技企业可设研发数据域、用户信息域、运维管理域;制造业可分生产控制系统域、供应链数据域、财务信息域。每个控制域需明确:适用的业务场景(如用户注册流程)、涉及的人员角色(如系统管理员、客服专员)、关联的信息系统(如CRM、ERP),以及资产间的依赖关系(如用户数据库支撑APP前端)。

特别提醒:范围界定需形成正式文档并经管理层审批。某医疗行业案例显示,未明确范围的项目,后期因业务扩展导致体系重构,额外增加30%的实施成本。

三、风险评估:识别安全隐患的关键动作

风险评估是ISMS的"神经中枢",需基于GB/T 22080(等同ISO 27001)等标准开展。具体包括三个层面:首先是资产价值评估,需对信息资产(如客户名单、专利文档)、系统资产(如服务器、数据库)、人员资产(如核心研发人员)进行分级,通常采用5级评分制(1级最低,5级最高)。

其次是威胁与脆弱性分析。威胁可能来自外部攻击(如APT攻击)、内部误操作(如文件误删除)或环境因素(如机房断电);脆弱性需结合漏洞扫描报告、历史安全事件记录等数据,识别系统配置缺陷、人员安全意识薄弱等问题。某能源企业通过漏洞扫描发现,83%的终端设备存在未修复的高危漏洞,为后续补丁管理提供了明确方向。

最后是风险等级计算。建议采用"影响×可能性"的评估模型,例如某客户信息数据库泄露的影响评分为4(严重业务损失),发生可能性评分为3(中等概率),则综合风险等级为12(需优先处理)。通过这一过程,组织可建立"高-中-低"风险清单,为后续控制措施选择提供依据。

四、框架搭建:构建系统化安全防护网

信息安全管理框架是ISMS的核心架构,需从战略、战术、执行三个维度设计。战略层面要与组织业务目标对齐,例如电商企业需重点保护用户交易数据,而教育机构需强化课程内容版权防护。战术层面需整合技术(如加密技术、访问控制)、管理(如安全策略、培训机制)、操作(如应急响应流程)三类控制措施。

具体实施步骤包括:1)建立资产清单,明确每类资产的责任人与保护要求;2)开展控制措施选择,根据风险评估结果,从ISO 27001的114项控制措施中筛选适用项(如针对用户信息泄露风险,选择"数据加密"和"访问审计");3)编制适用性声明(SoA),说明未选择某些控制措施的理由(如因技术限制暂不实施某项控制)。

某跨国企业的实践表明,采用"业务驱动+风险导向"的框架设计,可使安全措施与业务需求的匹配度提升60%,有效避免"为安全而安全"的资源浪费。

五、文件编制:固化管理要求的关键载体

文件化是ISMS的重要特征,需形成层次化的文档体系。层是安全方针,由最高管理者签发,明确组织的安全承诺(如"确保客户信息绝对安全")和总体目标(如"年度数据泄露事件≤1次")。第二层是管理手册,概述体系范围、框架结构和核心流程。

第三层是程序文件,详细说明具体操作规范,例如《访问控制管理程序》需规定账号创建流程、权限审批标准、定期审核要求等。某物流企业曾因程序文件缺失,导致新员工误操作删除运输数据,造成50万元直接损失。第四层是记录表单,如《风险评估记录表》《安全培训签到表》,这些记录是体系运行的证据,需保存至少3年。

特别注意:文件编制需遵循"可操作性"原则。某科技公司将安全方针写得过于抽象(如"全面保障信息安全"),导致基层员工无法理解执行,后修订为"客户数据泄露率≤0.1%,系统中断时间≤2小时/月"等量化指标,执行效果显著提升。

六、运行优化:动态调整的持续改进

体系文件发布后即进入运行阶段,此阶段的关键是"执行-监测-改进"的闭环管理。首先要开展全员宣贯,通过现场培训、在线测试等方式确保员工掌握文件要求。某零售企业的经验显示,未进行有效宣贯的项目,流程执行偏差率高达55%。

其次是建立监测机制。建议每月抽取10%的关键流程(如用户数据访问)进行合规性检查,每季度对风险清单进行重估(因业务扩展可能引入新风险)。某金融科技公司通过实时监测发现,某业务系统的API接口存在越权访问漏洞,及时修复避免了潜在的数据泄露。

当发现问题(如某次培训参与率仅60%)或风险变化(如行业出现新型攻击手段)时,需启动改进流程:分析根本原因(如培训时间与业务高峰冲突),制定纠正措施(如改为线上异步学习),跟踪实施效果(如次月参与率提升至95%)。通过这种动态调整,体系才能持续适应组织发展需求。

七、体系审核:验证有效性的最终关卡

审核是确保ISMS持续有效的关键手段,分为内部审核和外部审核。内部审核由组织自身或委托第三方实施,重点检查体系是否符合文件要求、控制措施是否有效执行。审核员需经过专业培训(如ISO 27001内审员认证),避免"自己审自己"的形式主义。某制造企业曾因内审流于形式,未发现生产控制系统的弱口令问题,最终导致设备被恶意控制。

外部审核(通常为ISO 27001认证)由独立第三方机构执行,审核范围涵盖体系的适宜性、充分性和有效性。通过认证不仅能提升组织的安全信誉(某企业获证后客户信任度提升30%),还能发现内部审核难以察觉的系统性问题(如跨部门协作漏洞)。

无论哪种审核,都需重视不符合项的整改。某互联网公司在外部审核中发现12项不符合项(如日志留存时间不足),通过3个月的整改,不仅解决了具体问题,更完善了"问题发现-整改-预防"的长效机制,体系成熟度显著提升。

结语:构建动态闭环的安全管理机制

信息安全管理体系的建立不是终点,而是持续改进的起点。从前期筹备到体系审核,每个环节都需要组织上下的深度参与——管理层提供战略支持,技术团队落实控制措施,业务部门配合执行要求。只有将安全意识融入企业文化,将管理要求转化为日常操作,才能真正实现"主动防护、动态响应"的信息安全目标,为组织的数字化发展筑牢安全屏障。

校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-04 01:43:51 HTTP/1.1 GET : http://www.aabqt.com/s/4695/n/28555.html
  2. 运行时间 : 0.016700s [ 吞吐率:59.88req/s ] 内存消耗:401.17kb 文件加载: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.000357s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001125s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '4695' AND `site_id` = 16 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000315s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000622s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 4695 [ RunTime:0.000213s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000610s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 4695 [ RunTime:0.000235s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000682s ]
  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` = 4695 AND `a`.`content_id` = '28555' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000653s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '4695' and content_id < '28555' and site_id <= '16' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '4695' and content_id > '28555' and site_id <= '16' order by content_id asc limit 1) [ RunTime:0.000558s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000702s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 4695 AND `site_id` = 16 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000997s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 4695 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000363s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 4695 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` = '16' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 28555 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.005182s ]
0.016983s