• 贴心辅助你的学习与生活帮你提高自身职业素质
  • 通过从业能力培训,提高能力,为你合理匹配机构,推荐
  • 教研团队测评考核,试讲通过认证上岗

400-663-3380

影视剪辑师职业发展全解析:前景、方向与成长路径

来源:北京火星时代教育 时间:01-04

影视剪辑师职业发展全解析:前景、方向与成长路径

影视剪辑师职业发展全解析:前景、方向与成长路径

在短视频日均用户突破10亿、网络电影年上线超千部的数字内容时代,影视剪辑师早已从幕后走到行业核心位置。无论是一条15秒的抖音爆款视频,还是一部投资过亿的院线电影,剪辑环节都是决定内容质量的关键。对于有意进入这一领域的新手,或是希望拓展职业边界的从业者而言,了解影视剪辑师的发展前景与多元路径,是规划职业方向的重要前提。

影视剪辑师的核心工作与行业价值

简单来说,影视剪辑师的工作是将碎片化的素材转化为有逻辑、有情绪的完整内容。从基础的镜头拼接、节奏把控,到进阶的特效合成、画面调色,再到复杂的多机位素材整理与声画同步,每个环节都需要专业技能支撑。

以观众熟悉的影视剧为例,拍摄时的爆破场景多在绿幕棚完成,最终呈现的雪山、战场等真实画面,需要剪辑师与特效团队配合完成场景替换;综艺节目的“名场面”剪辑,通过镜头切换与音效叠加,能将普通对话转化为全网讨论的热点片段。这些案例都在说明:优秀的剪辑师不仅是技术执行者,更是内容的“二次创作者”。

随着内容平台的多元化发展,剪辑师的工作场景已从传统影视公司扩展至短视频平台、MCN机构、广告公司等。数据显示,2023年短视频内容生产占比超全网视频内容的65%,这意味着剪辑师需要适应更短的制作周期、更灵活的创作需求,同时也获得了更广阔的施展空间。

行业人才需求与薪资现状

数字内容产业的爆发式增长,直接带动了影视剪辑师的需求激增。据《2023数字内容人才报告》统计,影视后期制作领域的人才缺口已突破25万,其中特效剪辑、栏目包装、微电影制作等细分方向的岗位需求年增长率达35%。

薪资水平方面,初级剪辑师(1-3年经验)平均月薪在6000-10000元,主要负责基础剪辑与素材整理;中级剪辑师(3-5年经验)月薪可达12000-20000元,需独立完成项目全流程剪辑并参与创意策划;剪辑师(5年以上经验)或特效剪辑师,月薪普遍超过25000元,部分参与院线电影或头部综艺的从业者,项目提成可达数万元。

值得注意的是,随着“内容为王”理念的深化,具备“剪辑+创意”复合能力的从业者更受市场青睐。例如,能根据品牌调性调整剪辑风格的商业广告剪辑师,或熟悉短视频算法逻辑的平台剪辑师,其薪资溢价可达普通剪辑师的1.5-2倍。

主流方向与能力要求

影视剪辑师的选择呈现明显的多元化特征,不同方向对技能的侧重也有所差异:

1. 影视制作机构(电影/电视剧/网络大电影)

这类岗位对剪辑师的综合能力要求最高,需熟悉多机位素材整理、非线性编辑(NLE)系统操作,同时具备较强的叙事理解能力。例如,电影剪辑需配合导演完成“粗剪-精剪-定剪”全流程,可能涉及数十版修改;网络剧剪辑则需兼顾平台用户的观看习惯,控制单集节奏与悬念设置。

2. 综艺与晚会制作

综艺剪辑的核心是“制造看点”,需要从海量素材中挖掘有趣片段,并通过镜头切换、音效添加强化节目效果。例如,真人秀中的“矛盾冲突”剪辑,需精准把握嘉宾微表情与台词的时机;晚会剪辑则更注重整体流程的连贯性与视觉美感。

3. 商业广告与企业视频

广告剪辑需围绕品牌调性与产品卖点展开,通常制作周期短但修改频率高。例如,汽车广告可能需要突出科技感,剪辑时需强化镜头运动速度与光影对比;企业宣传片则更注重叙事的逻辑性,需将企业历史、产品优势、文化理念有序串联。

4. 短视频与自媒体内容

短视频平台(抖音、快手、视频号)的剪辑需求以“高效”和“抓眼球”为核心。剪辑师需熟悉平台算法规则(如前3秒完播率的重要性),掌握快速转场、字幕特效、背景音乐适配等技巧。部分头部MCN机构的剪辑岗位,还要求具备“热点跟剪”能力,能在热点事件发生后2小时内产出相关内容。

创业与兼职:拓展收入的多元路径

除了全职,影视剪辑师还可通过创业或兼职实现收入增长,以下是常见的两种模式:

1. 自主创业:工作室与独立接单

成立个人工作室是许多剪辑师的选择,主要服务对象包括中小企业(年会视频、产品宣传片)、自媒体博主(账号内容定制)、婚庆机构(婚礼跟拍剪辑)等。工作室的运营重点在于客户资源积累与口碑维护,初期可通过低价试单或合作分成打开市场,后期逐步提升客单价(普通企业视频剪辑报价约800-3000元/条,定制化内容可达5000元以上)。

2. 兼职变现:平台接单与内容创作

- 专业接单平台:如淘宝“短视频服务”、一品威客、牛片网等,可发布剪辑服务套餐(如“15秒短视频剪辑199元”),吸引中小商家订单;
- 自媒体内容变现:在B站、小红书等平台发布剪辑教程或作品案例,通过流量分成、课程销售、品牌合作实现盈利。例如,一位专注“vlog剪辑技巧”的博主,单条教学视频播放量超10万时,可获得平台补贴+广告分成约2000-5000元;
- 账号运营变现:通过剪辑热门内容(如影视解说、热点事件盘点)打造个人账号,粉丝量达到5万-10万时,可通过星图广告、直播打赏、商品带货等方式变现,月收入可达1万-3万元。

需要注意的是,兼职或创业需平衡时间与精力,建议新手先通过兼职积累经验与客户资源,再逐步过渡到全职创业。

从新手到:关键技能提升路径

想要在影视剪辑领域长期发展,持续提升技能是关键。以下是不同阶段的重点学习方向:

初级阶段(0-1年):夯实技术基础

重点掌握Pr(Premiere)、Final Cut Pro等主流剪辑软件的操作,学习镜头语言(如景别、角度、运动方式的运用)、基础调色(LUT预设使用)、音效处理(背景音乐选择与音量平衡)。可通过临摹优秀作品(如经典电影片段、爆款短视频)提升剪辑感觉。

中级阶段(1-3年):强化创意与流程把控

需要学习AE(After Effects)进行简单特效制作,掌握达芬奇(DaVinci Resolve)的专业调色技巧,同时提升对项目需求的理解能力。例如,接到一个美妆产品广告需求时,能快速判断目标受众(年轻女性)的审美偏好,选择合适的剪辑风格(轻快/高级感)与素材方向(产品特写/使用场景)。

阶段(3年以上):向“剪辑导演”转型

这一阶段需突破技术限制,向内容创意与团队管理方向发展。例如,参与前期策划(与导演、编剧讨论分镜脚本)、指导助理剪辑师工作、建立个人剪辑风格(如“文艺向”“快节奏”)。部分剪辑师甚至能通过剪辑影响作品的最终呈现,成为项目的核心创意成员。

总结来看,影视剪辑师的职业发展不仅依托于数字内容产业的持续增长,更受益于内容形式的多元化创新。无论是选择全职、自主创业还是兼职变现,只要持续提升技术与创意能力,都能在这个领域找到属于自己的发展空间。对于有意入行的新手而言,现在正是进入影视剪辑行业的黄金期——抓住机会,从学习一款剪辑软件、完成个作品开始,开启你的职业成长之旅吧!

校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-17 03:38:01 HTTP/1.1 GET : http://www.aabqp.com/s/5164/n/30961.html
  2. 运行时间 : 0.012566s [ 吞吐率:79.58req/s ] 内存消耗:401.34kb 文件加载: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.000356s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.000947s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '5164' AND `site_id` = 21 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000255s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000591s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 5164 [ RunTime:0.000204s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000601s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 5164 [ RunTime:0.000196s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000620s ]
  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` = 5164 AND `a`.`content_id` = '30961' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.001140s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '5164' and content_id < '30961' and site_id <= '21' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '5164' and content_id > '30961' and site_id <= '21' order by content_id asc limit 1) [ RunTime:0.000393s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000720s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 5164 AND `site_id` = 21 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000414s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 5164 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000223s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 5164 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000154s ]
  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` = '21' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 30961 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.002115s ]
0.012865s