• 拥有海量免费题库
  • 精益求精打造完善课程
  • 业内专业师资团队,成就您的职业梦想!

400-060-0105

特岗教师与编制教师核心差异全解析:岗位性质、待遇发展一目了然

来源:石家庄点跃教育 时间:05-27

特岗教师与编制教师核心差异全解析:岗位性质、待遇发展一目了然

一、基础概念:什么是特岗教师?什么是编制教师?

要理解二者区别,首先需明确核心定义。编制教师指纳入事业单位编制的教师岗位,其本质是事业单位正式工作人员。这类岗位通过各地教育部门组织的教师招聘考试(简称"考编")录用,入职后与学校签订长期聘用合同(通常首次签约5年,后续可续签),享受事业单位完整的工资福利体系,包括"五险一金"、绩效奖金、职称晋升等待遇,是教育行业公认的"稳定岗位"。

特岗教师则是国家"农村义务教育阶段学校教师特设岗位计划"的简称,主要面向中西部地区及偏远贫困县的义务教育阶段学校。该计划通过中央财政补贴吸引高校毕业生到基层任教,服务期为3年。服务期内,特岗教师与当地在编教师执行同等工资标准,工资由中央财政和地方财政共同承担(中央财政承担大头)。服务期满且考核合格者,可申请转为当地编制教师,实现"先服务后入编"的职业路径。

二、岗位定位:解决什么问题?覆盖哪些区域?

编制教师的招聘需求源于教育系统的常态化补充。无论是城市重点学校还是乡镇中心校,当出现教师自然减员(如退休、调岗)或因学校扩班需要新增师资时,教育部门会通过公开招聘考试补充编制教师。这类岗位覆盖范围广,从一线城市的示范校到县域内的普通中小学均有分布,岗位设置更注重满足学校日常教学的持续性需求。

特岗教师的设立具有明确的政策导向——重点解决农村地区、偏远山区义务教育阶段师资结构性矛盾。根据教育部历年文件要求,特岗教师原则上安排在县以下农村初中,部分地区会兼顾乡镇中心学校,但极少设置在县城及以上城区。例如某省2023年特岗教师岗位表显示,90%的岗位分布在人口少于3万的乡镇,且集中在语文、数学、英语等主科教学一线,旨在快速提升农村学校的核心学科教学质量。

三、待遇对比:薪资构成与长期保障有何不同?

(一)特岗教师待遇特点

特岗教师服务期内的工资由中央财政和地方财政共同承担。以中部某省为例,2024年特岗教师月平均工资约为4800元,其中中央财政承担3200元,地方财政补贴1600元,与当地在编教师的基础工资水平基本持平。此外,特岗教师同样享受乡镇工作补贴、农村教师周转宿舍等地方性福利,但需注意:服务期内不参与职称评定,需服务满3年后转编时方可启动职称晋升流程。

(二)编制教师待遇特点

编制教师的薪资由基本工资(岗位工资+薪级工资)、绩效工资、津贴补贴三部分构成。以东部某市小学一级教师为例,月基本工资约5200元,绩效工资(含课后服务补助)约2800元,加上住房公积金(双边2400元)、农村教师补贴(若在乡镇任教)等,综合月收入可达1.1万元左右。更关键的是,编制教师从入职起即可参与职称评审,随着教龄增长和职称晋升,薪资水平会持续提升,职业发展路径清晰稳定。

四、职业发展:两种路径的优势与选择建议

(一)特岗教师的三大发展优势

首先是"入编保障"。只要服务期内年度考核合格(通常超95%),特岗教师可直接转编,相当于"先上岗再入编"的绿色通道,这对渴望获得编制但考编竞争激烈的考生是重要机会。其次是"基层经验加成"。3年农村教学经历在后续考调城镇学校时具有明显优势——多地教育部门明确规定,城镇学校教师招聘中,具有特岗服务经历者可优先录用。最后是"政策倾斜支持"。部分省份为特岗教师提供考研加分(如服务期满后考教育类硕士加10分)、公务员定向招录等额外政策,拓宽了职业转型空间。

(二)编制教师的核心竞争力

编制教师的优势在于"稳定性"。一旦入职,除非出现重大教学事故或违法违纪行为,否则不会面临岗位变动风险。这种稳定性体现在薪资福利的持续性(如退休后享受事业单位养老金)、职称晋升的规范性(按教龄和业绩正常晋级)以及工作环境的可预期性(较少因政策调整出现岗位调动)。此外,编制教师在参与学校管理(如担任学科组长、年级主任)、获得培训机会(如省级骨干教师研修)等方面,往往比临聘教师或特岗教师拥有更多优先权。

(三)选择建议:结合自身规划做决定

如果您倾向于快速获得编制且能接受基层工作环境,特岗教师是优质选择——尤其适合来自农村地区、愿意为家乡教育事业贡献力量的毕业生。若您更看重工作地点的灵活性(如希望留在城区学校)或对职业稳定性有更高要求,直接报考编制教师更合适,但需注意热门地区的考编竞争可能非常激烈(部分岗位报录比超1:100)。

五、常见误区:这些认知需要纠正

误区一:"特岗教师只能在偏远山区工作"。实际政策中,特岗岗位设置以"县以下农村学校"为主,但"县以下"包含乡镇中心校,部分经济较发达县域的乡镇学校硬件设施已接近城区水平。例如江浙地区的部分特岗岗位,所在学校配备多媒体教室、实验室等现代化教学设备,工作环境并不差。

误区二:"特岗教师待遇低于编制教师"。根据《特岗教师管理办法》,特岗教师在服务期内与当地在编教师执行同等工资标准,差异仅在于工资来源(特岗教师工资由中央财政承担部分)。以2023年某省统计数据为例,特岗教师与同地区同职称在编教师的月工资差额不超过300元(主要是地方补贴的细微差别)。

误区三:"特岗转编后发展受限"。转编后的特岗教师与其他在编教师享有完全同等的职业发展权利。以某县2022年教师职称评审结果为例,当年转编的特岗教师中,15%成功晋升一级教师,与同期入职的非特岗编制教师晋升比例基本一致。

结语:教育使命高于岗位类型

无论是特岗教师还是编制教师,本质都是"人民教师"的一员。特岗教师用3年青春为农村教育注入活力,编制教师在常态化教学中传承知识薪火,二者共同构成了我国基础教育的坚实基石。选择岗位时,不妨多思考:自己更希望在怎样的环境中实现教育理想?是扎根基层助力教育公平,还是在更成熟的教学体系中精耕专业?答案没有对错,唯有与职业初心的契合度。

最后需要提醒的是,特岗教师和编制教师的具体政策会因地区、年份略有调整,建议备考前仔细阅读当年发布的《特岗教师招聘公告》和《教师公开招聘考试简章》,确保信息获取的准确性。

校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-03 15:34:27 HTTP/1.1 GET : http://www.eduih.com/s/1178/n/12085.html
  2. 运行时间 : 0.012114s [ 吞吐率:82.55req/s ] 内存消耗:399.10kb 文件加载: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.000339s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.000954s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '1178' AND `site_id` = 3 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000262s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000687s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 1178 [ RunTime:0.000225s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000739s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 1178 [ RunTime:0.000215s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000726s ]
  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` = 1178 AND `a`.`content_id` = '12085' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000666s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '1178' and content_id < '12085' and site_id <= '3' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '1178' and content_id > '12085' and site_id <= '3' order by content_id asc limit 1) [ RunTime:0.000434s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000801s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1178 AND `site_id` = 3 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000367s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1178 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000277s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 1178 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000195s ]
  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` = '3' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 12085 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.001366s ]
0.012423s