• 集职业教育,考试培训,授权认证,网络教学为一体
  • 为中国建设,财经和商业领域内培养和输出了大量的精英人才
  • 致力于打造教育培训品牌!

400-888-4851

HR部署EHR系统前的四大关键筹备指南

来源:厦门国联政研 时间:06-29

HR部署EHR系统前的四大关键筹备指南

HR部署EHR系统前的四大关键筹备指南

一、明确高层决策意图与组建专项小组

在正式接触EHR系统前,HR首先需要解决的是"项目是否具备推进基础"的核心问题。这需要从两个维度入手:一是确认企业高层对EHR系统的部署意愿,二是搭建跨部门协作的专项小组。

高层决策的明确程度直接影响后续工作的价值。若领导层仅停留在"考虑阶段",此时投入大量资源进行系统调研可能导致精力浪费;若已明确"立项推进",则需立即启动筹备流程。这里的关键是通过正式沟通(如战略会议、书面批示等)获取决策层的明确态度,避免因信息偏差导致项目停滞。

组建专项小组是确保信息同步与效率的重要机制。小组成员应涵盖四类核心角色:HR部门负责人(掌握业务痛点)、IT技术主管(熟悉系统对接需求)、各业务线负责人(了解一线管理诉求)、以及具备决策权的企业高管(保障资源支持)。以某制造业企业为例,其专项小组通过每月2次的联席会,有效解决了生产部门考勤规则特殊化、财务系统数据同步等跨部门需求冲突,将系统调研周期缩短了40%。

小组需要共同确定的核心目标包括:(1)系统上线的时间节点与覆盖范围(如是否先覆盖总部再扩展分公司);(2)产品形态偏好(SaaS模式的轻量化部署或本地部署的高度定制);(3)供应商筛选维度(技术实力、行业经验、服务响应等);(4)采购方式(直接采购或公开招标)。这些目标的明确,为后续工作划定了清晰的边界。

二、科学规划项目预算的三大组成

预算规划是EHR系统筹备中容易被忽视却至关重要的环节。根据2023年人力资源信息化行业报告显示,63%的企业因预算规划不合理导致系统选型范围受限,28%出现后期追加费用超预期的情况。

合理的预算应包含三大核心模块:

  1. 软件版权费:这是系统采购的基础成本,受产品功能模块、用户数量、定制化程度影响。例如标准化SaaS产品通常按年/用户数收费(约50-200元/人/年),而高度定制的本地部署系统可能一次性收取50万-200万元。
  2. 实施服务费:包括系统配置、数据迁移、用户培训等环节的费用。据行业数据,实施费用通常为软件版权费的30%-50%,大型企业可能因业务复杂度达到80%以上。
  3. 运维保障费:涵盖系统升级、故障响应、数据安全维护等长期支出。SaaS模式一般包含在年费中(约占版权费的15%-25%),本地部署则需单独签订服务协议(年费用约为系统总价的8%-12%)。

建议HR通过两种方式验证预算合理性:一是参考企业过往IT系统投资比例(如制造业通常占年营收的0.3%-0.8%);二是向3-5家目标供应商获取初步报价,结合企业实际需求调整预算范围。某互联网企业通过"历史IT投资占比+供应商报价对比"的双维度验证,将预算偏差率控制在5%以内,为后续选型提供了充足的资金弹性。

三、多维度梳理需求,形成标准化文档

需求文档是连接企业实际诉求与供应商产品功能的关键桥梁。其编制需同时考虑业务场景与技术实现,具体可从以下四个层面展开:

1. 企业基础信息采集

需要明确组织架构复杂度(如是否有事业部、分子公司)、人员规模(当前人数及未来3年增长预测)、员工信息化水平(如是否习惯使用移动办公工具)。例如零售企业因门店分布广、员工流动性高,需重点关注移动端考勤和自助服务功能;科技企业因项目制管理普遍,需强化项目人力成本核算模块。

2. 业务痛点深度挖掘

从人力资源管理的12大核心模块(组织架构、员工管理、考勤、薪资、绩效、招聘、培训、流程审批、人事档案、社保公积金、报表分析、员工自助)出发,逐一梳理当前痛点。以考勤管理为例:是否存在跨时区打卡需求?是否需要对接门禁系统?弹性工作制如何统计工时?某教育机构通过痛点梳理,发现现有系统无法处理"教师线下授课+线上直播"的双重考勤场景,从而在需求文档中明确要求系统支持多维度考勤规则配置。

3. IT技术需求确认

需重点明确三方面:(1)系统对接要求(如与ERP、OA、财务系统的集成方式及数据交互频率);(2)安全等级(是否涉及敏感信息加密、访问权限分级);(3)部署环境(云服务器配置、本地服务器性能要求等)。某金融企业因涉及客户信息管理,在需求文档中明确要求系统通过ISO 27001信息安全认证,并支持金融行业数据加密标准。

4. 招标需求补充(如需)

若采用招标方式,需额外明确供应商要求(如软件企业认定、同类项目案例数量)、服务承诺(如响应时间、驻场支持时长)、报价结构(是否包含后期升级费用)等内容,确保招标过程公平透明。

四、编制需求说明书,提升供应商评估效率

需求说明书是将需求文档转化为可执行标准的关键文件,其内容需具体、可量化。通常应包含以下核心要素:

  • 功能需求描述:用具体场景说明所需功能。例如"需支持跨部门调岗时,自动同步考勤组、汇报关系及薪资结构,触发审批流程并更新人事档案",而非笼统表述"需要调岗管理功能"。
  • 系统对接清单:列出需对接的系统名称、接口类型(API/文件导入)、数据同步频率(实时/每日/每周)。
  • 限制条件说明:如"用户数上限不低于2000人""组织架构层级支持10级以上"等,避免后期因系统限制影响使用。

向供应商发送需求说明书后,建议要求其提供《需求满足度评分表》,对每项需求标注"完全满足""部分满足""不满足"并说明原因。某制造企业通过这种方式,发现3家候选供应商中,2家无法满足"多工厂计件工资核算"需求,1家在"社保公积金自动申报"功能上存在缺陷,从而快速缩小了选型范围。

在供应商演示环节,可对照需求说明书重点关注"部分满足"项的解决方案(如是否需要二次开发、额外费用多少),以及"不满足"项是否有替代方案。通过这种结构化评估,能有效避免因沟通偏差导致的系统功能与实际需求脱节问题。

总结来看,EHR系统的成功部署始于前期的充分准备。从确认高层意图到编制需求说明书,每个环节都需要HR以"业务主导者"的视角,结合企业实际需求与行业经验,系统性推进筹备工作。只有这样,才能确保后续的系统选型、实施与应用真正为企业人力资源管理赋能,实现效率提升与成本优化的双重目标。

校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-03 17:49:29 HTTP/1.1 GET : http://www.aabrd.com/s/364/n/15922.html
  2. 运行时间 : 0.012999s [ 吞吐率:76.93req/s ] 内存消耗:377.81kb 文件加载: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.000386s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001084s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '364' AND `site_id` = 19 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000279s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000605s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 364 [ RunTime:0.000213s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000603s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 364 [ RunTime:0.000195s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000611s ]
  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` = 364 AND `a`.`content_id` = '15922' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000743s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '364' and content_id < '15922' and site_id <= '19' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '364' and content_id > '15922' and site_id <= '19' order by content_id asc limit 1) [ RunTime:0.000444s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000782s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 364 AND `site_id` = 19 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000335s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 364 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000179s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 364 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000177s ]
  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` = '19' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 15922 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.002576s ]
0.013303s