• 持续为泛娱乐行业游戏、影视、动漫等领域培育数字美术专业人才
  • 为全球观众及用户提供高质量的影视动画、数字艺术作品
  • 黑岩创办的8年间,服务过全球超过200家数字娱乐企业

400-882-1933

UE4技术岗位薪资现状与职业发展全解析

来源:福州黑岩教育 时间:09-29

UE4技术岗位薪资现状与职业发展全解析

游戏可视化领域爆发,UE4技术岗位为何成"香饽饽"?

近年来,随着元宇宙概念的兴起与数字孪生技术的普及,游戏、影视、建筑可视化等领域对3D交互内容的需求呈指数级增长。作为全球主流的实时3D引擎,UE4(Unreal Engine 4)凭借强大的渲染能力、跨平台适配性及开放的生态体系,已成为游戏开发、虚拟制片、工业仿真等场景的核心工具。这种技术应用的广泛性,直接催生了市场对UE4技术人才的旺盛需求——据《2023数字内容产业人才报告》显示,国内UE4相关岗位年增长率连续3年超过25%,部分一线城市的岗位缺口甚至达到现有从业者的1.5倍。

UE4技术应用场景示意图

从具体应用场景看,UE4不仅是《堡垒之夜》《赛博朋克2077》等现象级游戏的开发引擎,更在影视制作中实现了虚拟拍摄技术的革新——如《曼达洛人》采用的LED虚拟制片系统,正是基于UE4引擎搭建的实时渲染场景。此外,建筑行业的数字孪生展厅、汽车企业的3D交互营销平台,甚至医疗领域的手术模拟系统,都在大量使用UE4技术。这种"泛行业渗透"特性,使得UE4技术人才的职业选择远不止传统游戏开发,为从业者拓宽了职业发展的想象空间。

不同阶段UE4从业者薪资图谱:从入门到的收入曲线

技术岗位的薪资水平,本质上是市场对人才价值的直接定价。对于UE4从业者而言,薪资差异主要体现在经验积累、技术深度及行业赛道三个维度。结合拉勾网、猎聘等平台的最新数据,我们梳理了不同阶段从业者的典型收入情况:

1. 初级岗(0-2年经验)

主要负责基础模型搭建、材质调整及简单功能实现,通常需要熟练掌握蓝图脚本、基础光照设置等技能。一线城市起薪普遍在10k-15k/月,二三线城市约8k-12k/月。部分参与过完整项目的应届生,入职薪资可达12k-18k/月。

2. 中级岗(3-5年经验)

需具备独立完成场景开发、优化渲染效率、协同美术/程序团队的能力,部分岗位要求掌握C++代码扩展或VR/AR专项技术。一线城市薪资范围为18k-30k/月,部分大厂核心项目组可达35k/月以上;二三线城市约15k-25k/月。值得注意的是,具备影视虚拟制片或工业仿真项目经验的从业者,薪资普遍比纯游戏开发岗高15%-20%。

3. 高级岗(5年以上经验)

作为技术团队的核心骨干,需负责引擎定制、性能优化、技术方案评审等工作,部分岗位需主导跨部门技术规划。一线城市薪资普遍在35k-60k/月,头部企业或紧缺领域(如元宇宙内容开发)可达70k-100k/月;年薪方面,多数从业者在3-5年后年收入稳定在30万-60万区间,技术专家或项目负责人甚至能突破百万。

需要特别说明的是,上述数据基于公开招聘信息统计,实际收入会因企业性质(大厂/中小厂/外包)、项目盈利情况及个人技术稀缺性产生波动。例如,掌握UE5新特性(如Lumen全局光照、Nanite虚拟微多边形)的开发者,在2023年的市场溢价可达30%以上。

高薪背后的技术门槛:哪些能力决定了你的薪资上限?

尽管UE4岗位的薪资水平颇具吸引力,但"高回报"必然伴随"高要求"。通过分析200+份UE4岗位JD(职位描述),我们总结出市场对从业者的三大核心能力要求:

1. 技术深度:从"会用"到"精通"的跨越

初级开发者往往停留在"工具使用"层面,如熟练调用引擎内置功能完成基础开发;而高薪岗位更看重"技术深挖"能力,例如:理解引擎渲染管线原理并进行针对性优化,通过C++代码扩展引擎功能,解决复杂场景下的性能瓶颈(如大场景加载卡顿、多光源渲染延迟)等。某游戏公司技术总监在招聘时明确表示:"我们更愿意为能解决‘别人解决不了的问题’的开发者支付溢价。"

2. 行业适配:从"单一领域"到"复合场景"的迁移

随着UE4应用场景的拓展,企业对"行业+技术"复合型人才的需求日益迫切。例如,影视虚拟制片岗位需要从业者了解影视拍摄流程、镜头语言及灯光设计;工业仿真岗位则要求掌握机械结构原理、物理模拟参数设置等跨领域知识。具备多行业项目经验的开发者,不仅职业选择更灵活,在薪资谈判中也更具主动权。

3. 持续学习:技术迭代下的生存法则

UE4引擎本身处于快速迭代中——从UE4.27到UE5.2,每年都会推出新功能(如MetaHuman Creator、Live Link Face)和性能优化(如Nanite支持更复杂模型)。此外,行业趋势(如WebGL跨平台渲染需求、AIGC与引擎的结合)也在不断提出新挑战。某大厂技术HR坦言:"我们淘汰的不是‘经验不足’的人,而是‘拒绝学习’的人。那些能快速掌握新工具、适应新需求的开发者,薪资涨幅往往是同期入职者的2-3倍。"

职业提升路径:如何通过系统学习突破薪资瓶颈?

面对技术迭代与市场竞争,单纯依靠"工作经验积累"已难以满足职业发展需求。越来越多的从业者选择通过系统化培训提升竞争力,而优质的培训课程往往具备以下特征:

  • 以"项目实战"为核心:课程内容应围绕真实商业项目展开(如独立游戏开发、影视虚拟场景搭建),让学员在实践中掌握从需求分析到上线交付的全流程技能。
  • 紧跟技术前沿:课程需及时更新UE5新特性、行业新工具(如Houdini与UE4的联动)及跨领域应用案例(如建筑可视化中的实时渲染)。
  • 提供行业资源对接:优质培训机构通常与游戏公司、影视制作团队保持合作,能为学员提供项目实践机会、内推岗位及行业人脉资源。

需要提醒的是,选择培训课程时需重点考察机构的项目案例库、讲师背景(是否具备一线项目经验)及服务体系。毕竟,培训的最终目的是"提升职业价值",而非单纯获书。

结语:UE4技术岗位的"钱景",本质是"能力的变现"

回到最初的问题——"学习UE4的薪资水平高吗?"答案显然是肯定的,但这份"高薪资"绝非"轻松可得"。它既源于数字内容产业爆发带来的行业红利,更依赖于从业者对技术的深度钻研与持续学习。对于希望进入或深耕UE4领域的开发者而言,明确职业目标、提升技术硬实力、保持学习敏锐度,才是抓住行业机遇、实现高薪发展的关键。

课程导航
校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-06-21 19:58:13 HTTP/1.1 GET : http://www.edufv.com/s/4873/n/29449.html
  2. 运行时间 : 0.018013s [ 吞吐率:55.52req/s ] 内存消耗:384.31kb 文件加载: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.000446s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001257s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '4873' AND `site_id` = 6 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000295s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000630s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 4873 [ RunTime:0.000239s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000642s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 4873 [ RunTime:0.000235s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000677s ]
  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` = 4873 AND `a`.`content_id` = '29449' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000969s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '4873' and content_id < '29449' 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 = '4873' and content_id > '29449' and site_id <= '6' order by content_id asc limit 1) [ RunTime:0.000642s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000745s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 4873 AND `site_id` = 6 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000305s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 4873 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000180s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 4873 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000167s ]
  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` < 29449 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.006546s ]
0.018371s