• 为国内互联网企业打造一支实用型人才队伍
  • 课程内容由易到难,针对零基础学员,细微颗粒讲解
  • 理论知识+项目实操+案例详解+助教督学+指导

400-888-4851

影视后期从业者职业发展全解析:八大热门方向深度解读

来源:华软教育 时间:12-14

影视后期从业者职业发展全解析:八大热门方向深度解读

影视后期方向深度解析:从企业到自由职业的多元选择

影视后期制作作为影视产业链的核心环节,随着短视频、网络影视、广告营销等领域的爆发式增长,相关岗位需求持续攀升。对于掌握AE、Pr、C4D等后期软件技能的从业者而言,职业选择已从传统电视台扩展至更广泛的应用场景。本文将结合行业现状,逐一解析当前代表性的八大方向,帮助从业者全面了解不同岗位的工作特点与发展前景。

一、综合服务类岗位:覆盖生活消费场景

1. 自主创业工作室与自媒体运营

在短视频平台崛起与内容创业浪潮下,个人或小型团队成立影视后期工作室成为热门选择。这类工作室主要承接娱乐搞笑类视频制作、知识科普类内容包装,或直接运营自有自媒体账号。盈利模式包括平台流量分成、品牌广告植入及定制内容接单。相较于传统企业,工作室的灵活性更高,但对市场敏感度和客户开发能力要求较强。部分成熟团队已从单一后期制作延伸至内容策划,形成“策划-拍摄-后期”全流程服务,进一步提升商业价值。

2. 婚庆服务机构后期制作

婚庆行业的标准化服务升级,催生了对高质量婚礼视频的需求。婚庆公司的后期岗位不仅负责视频剪辑、特效添加,还需配合前期拍摄完成全流程视觉呈现。从婚礼跟拍素材的精剪、新人成长片段的混剪,到婚礼现场VCR的包装设计,均需结合新人故事定制化处理。部分头部婚庆机构已将后期团队独立,提供“婚礼纪录片”“微电影式婚礼视频”等差异化服务,从业者的创意表达空间显著提升。

二、企业服务类岗位:聚焦商业视觉赋能

3. 广告公司视觉设计岗

广告公司的后期制作与品牌营销深度绑定,核心任务是通过视觉语言传递产品卖点。从TVC广告的特效制作、电商产品的详情页视频剪辑,到品牌宣传片的整体包装,均需结合市场策略调整视觉风格。大型广告公司通常设有专门的后期部门,分工细致(如3D建模组、动态图形组);中小型公司则要求从业者具备多技能复合能力,既能完成基础剪辑,也能制作MG动画或简单特效。随着品牌对短视频营销的重视,短视频广告制作已成为广告公司后期岗位的核心业务方向。

4. 电视台与媒体机构技术岗

传统电视台虽面临新媒体冲击,但其内容制作的专业性仍不可替代。电视台后期岗位主要负责新闻类节目包装(如滚动字幕条、新闻片头模板更新)、专题片剪辑及活动直播的实时画面处理。值得注意的是,地方台与卫视的工作内容差异较大:卫视更侧重综艺、晚会等大型节目的后期制作,技术要求更高;地方台则以新闻类内容为主,工作节奏相对固定。近年来,部分电视台开始布局新媒体平台(如官方抖音、视频号),后期岗位也需兼顾短视频内容的制作与运营。

三、创意制作类岗位:深耕影视工业链条

5. 影视特效公司技术岗

特效公司是影视后期技术的前沿阵地,主要承接电影、电视剧、网络大电影的特效制作任务。从基础的二维特效(如字幕特效、光效添加)到复杂的三维特效(如场景合成、角色动画),均需熟练运用AE、Nuke、Maya等软件。国内特效公司的业务正从“外包加工”向“自主创意”转型,具备剧本理解能力与艺术审美素养的后期人才更受青睐。随着虚拟拍摄技术的普及,特效制作与前期拍摄的融合度提升,从业者需掌握更多跨环节协作技能。

6. 动画制作公司合成岗

动画产业的快速发展(如《中国奇谭》《雾山五行》等作品的出圈),带动了动画后期合成岗位的需求增长。动画公司的后期工作主要包括画面分层合成、色彩校正、特效叠加(如火焰、烟雾效果)及镜头衔接处理。以二维动画制作为例,AE软件在关键帧动画、动态元素合成中应用广泛;三维动画则更多依赖后期合成软件完成灯光渲染调整。相较于影视特效,动画后期更注重画面的整体风格统一,对分镜脚本的理解能力要求较高。

四、灵活类方向:适配多元工作模式

7. 剧组与影视公司跟组后期

随着网络电影、网络剧的产量激增,剧组对跟组后期的需求显著增加。跟组后期需随剧组拍摄进度完成素材整理、粗剪及基础特效制作,确保导演能及时查看拍摄效果并调整方案。这一岗位对从业者的应急处理能力要求极高——需在有限时间内完成多机位素材的筛选与剪辑,同时适应剧组的高强度工作节奏。部分跟组后期会参与前期拍摄沟通,从后期视角提出镜头建议,逐步向“后期指导”角色转型。

8. 威客平台自由接单

威客平台(如猪八戒网、淘宝外包)为自由职业者提供了灵活的接单渠道。任务类型涵盖短视频剪辑、企业宣传片制作、电商产品视频包装等,价格根据难度与时长浮动。自由接单的优势在于时间自主,但也面临竞争激烈、客户需求不明确等问题。建议从业者建立个人作品集,聚焦特定领域(如美食类短视频、科技产品演示视频)形成差异化竞争力,同时注重客户口碑积累,通过老客户推荐获取优质订单。

职业发展建议:提升核心竞争力是关键

无论选择哪类方向,影视后期从业者的核心竞争力始终围绕“技术+创意”展开。技术层面需持续学习新软件(如AI辅助剪辑工具)与新技术(如虚拟制片流程);创意层面需培养对视觉语言的敏感度,通过分析优秀作品(广告、电影、动画)积累审美经验。此外,跨领域知识储备(如了解市场营销逻辑、熟悉影视剧本结构)能帮助从业者更好地理解客户需求,从“执行者”向“创意顾问”升级。

总体而言,影视后期行业的选择丰富且前景广阔。从业者可根据自身兴趣与特长选择细分方向,通过持续学习与经验积累,在影视工业链条中找到属于自己的职业坐标。

校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-04 08:49:42 HTTP/1.1 GET : http://www.aabrd.com/s/5047/n/30505.html
  2. 运行时间 : 0.014853s [ 吞吐率:67.33req/s ] 内存消耗:400.39kb 文件加载: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.000341s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.000902s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '5047' AND `site_id` = 19 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000245s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000564s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 5047 [ RunTime:0.000210s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000586s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 5047 [ RunTime:0.000198s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000614s ]
  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` = 5047 AND `a`.`content_id` = '30505' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000882s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '5047' and content_id < '30505' 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 = '5047' and content_id > '30505' and site_id <= '19' order by content_id asc limit 1) [ RunTime:0.000429s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000697s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 5047 AND `site_id` = 19 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.001273s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 5047 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000397s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 5047 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000188s ]
  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` < 30505 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.003638s ]
0.015146s