• 致力于培养高质量数字化技术技能人才
  • 主要提供大学生技能培训、职后技能培训等
  • 凭借有教无类的职业教育理念,不断提升IT职业教育培训的质量

400-666-4820

北京千锋影视剪辑培训全解析:从软件实操到职业发展的系统学习路径

北京千锋影视剪辑培训全解析:从软件实操到职业发展的系统学习路径

授课机构: 北京IT培训机构

上课地点: 校区地址

成交/评价:

联系电话: 400-666-4820

北京千锋影视剪辑培训全解析:从软件实操到职业发展的系统学习路径课程详情

影视剪辑培训课程体系:全流程技能覆盖

影视剪辑作为数字内容生产的核心环节,对专业技能的系统性要求极高。北京千锋IT培训针对这一需求,打造了一套从基础理论到实战落地的影视剪辑培训体系,内容涵盖短视频应用、长篇制作、调色优化、文案策划四大核心模块,确保学员掌握全链路剪辑能力。

模块一:短视频剪辑应用与实战

在短视频流量主导的当下,掌握短视频剪辑技巧是入门影视行业的关键。课程从剪辑理论切入,逐步展开剪辑技巧、音乐编辑、创意混剪、视频包装等环节教学,最终通过项目实战完成完整短视频制作流程。学员将学习如何根据平台特性(如抖音、快手、B站)调整剪辑节奏,掌握转场特效、字幕设计、情绪卡点等实用技能,确保作品既符合用户观看习惯,又能突出内容核心。

模块二:FCP7与AVID影视长篇剪辑

针对电影、电视剧等长篇内容的剪辑需求,课程重点教授FCP7与Avid MC两款行业主流软件的操作。学员将系统学习电视剧多集连贯性剪辑、电影叙事节奏把控等核心技巧,同时掌握影视DIT(数字影像技术)流程,包括素材整理、格式转换、色彩管理等环节。此外,课程还融入影视配乐与音效制作内容,帮助学员理解声音与画面的协同关系,提升长篇作品的艺术表现力。

模块三:达芬奇调色进阶训练

调色是提升视频质感的关键步骤,课程通过实战案例解析一级调色与二级调色的应用场景。一级调色侧重亮度匹配与基础色彩校正,确保不同镜头间的色调统一;二级调色则深入磨皮瘦脸、风格化调色等高级技巧,覆盖短视频、Vlog、电商广告、影视剧等多类型需求。学员将学习如何根据内容主题选择调色工具(如HSL辅助、曲线工具),并掌握电影级调色的核心逻辑,使作品从“合格”迈向“专业”。

模块四:视频文案策划与拍摄实训

优质的视频内容离不开前期策划与拍摄支持。课程特别设置文案策划与拍摄实训环节,学员将学习如何撰写创意短片的分镜脚本,掌握机位设置、构图技巧(如三分法、对称构图)、布景逻辑及运镜方式(推轨、摇臂、手持)。同时,课程深入讲解不同场景下的布光方法(如自然光、人工光、混合光),并通过参与真实项目实训,熟悉从策划到拍摄再到后期的完整制作流程,培养“全流程创作者”思维。

六大主流软件操作:从入门到精通

影视剪辑的高效实现离不开工具支撑,北京千锋IT培训课程覆盖6款行业主流软件,根据不同应用场景针对性教学,帮助学员建立“软件-场景”的匹配思维。

Premiere:通用型剪辑首选

作为Adobe全家桶的核心成员,Premiere凭借强大的兼容性(支持多种格式导入)和易用性,成为广告制作、电视节目剪辑的首选工具。课程重点讲解其时间线编辑、关键帧调色、音频降噪等功能,学员可掌握从素材导入到成片输出的全流程操作,满足日常短视频与中长视频剪辑需求。

AE:特效与动态图形制作

AE(After Effects)是动态特效的“魔法工具”,适用于制作复杂转场、粒子效果、动态字幕等。课程将教授关键帧动画、表达式应用及第三方插件(如Trapcode Suite)的使用技巧,帮助学员为视频添加电影级特效,提升作品的视觉冲击力。

Motion:苹果生态高效辅助

作为Final Cut Pro的“黄金搭档”,Motion专注于动态图形设计,支持快速生成文字动画、转场模板及MG动画。课程将演示如何通过预设库加速制作,并讲解与Final Cut Pro的协同工作流程,适合苹果用户提升剪辑效率。

Final Cut:专业级非线性编辑

由苹果开发的Final Cut Pro以高效的渲染速度和先进的色彩管理著称,广泛应用于电影、纪录片剪辑。课程将深入讲解其智能素材管理、多机位剪辑及颜色分级功能,帮助学员掌握专业级非线性编辑的核心技巧。

Avid:电影工业标准工具

Avid Media Composer是好莱坞电影剪辑的“行业标配”,其优势在于高画质处理与多轨道剪辑稳定性。课程将教授其独特的剪辑逻辑(如动态剪辑模式),并解析电影剪辑中的同步声处理、多版本输出等高级操作,为学员进入影视工业奠定基础。

达芬奇调色:色彩校正与风格化

达芬奇调色软件以强大的色彩科学算法闻名,支持一级校正、二级调色及HDR制作。课程通过电影级案例(如商业广告、独立电影)演示其节点式调色流程,学员将掌握如何通过曲线、色轮等工具实现精准色彩控制,满足不同类型影片的调色需求。

选择影视剪辑培训的六大核心优势

在数字内容爆发的时代背景下,影视剪辑技能已成为个人职业发展的“硬通货”。北京千锋IT培训通过市场调研与反馈,总结出学习影视剪辑的六大核心优势,为学员提供清晰的价值参考。

薪资水平领先:技术稀缺性带来高回报

据职友集2023年数据显示,一线城市影视剪辑师平均月薪达1.2-1.8万元,剪辑师(3年以上经验)月薪普遍超过2.5万元。随着短视频、直播等行业对优质内容的需求激增,具备全流程剪辑能力的复合型人才更受企业青睐,薪资涨幅空间显著。

岗位需求旺盛:多领域释放人才缺口

从短视频平台(抖音、快手)到内容制作公司(MCN机构、广告公司),再到传统影视行业(电影制片厂、电视台),影视剪辑岗位需求持续增长。据《中国数字内容产业发展报告》统计,2023年影视剪辑相关岗位招聘量同比增长37%,人才缺口超50万人。

职业发展多元:从执行到创作的上升通道

掌握影视剪辑技能后,学员可选择多条发展路径:既可深耕剪辑岗位成为技术专家,也可向导演、制片等综合岗位转型;既可加入企业担任全职剪辑师,也可通过自由职业平台(如淘宝外包、一品威客)承接项目,实现工作时间自主。

入行门槛友好:零基础也能快速上手

与传统影视专业不同,影视剪辑更注重实操能力而非学历背景。北京千锋IT培训课程采用“理论+软件+实战”三阶教学法,零基础学员通过3-6个月系统学习,即可掌握主流软件操作与剪辑规范,快速胜任基础剪辑岗位。

创业空间广阔:技能变现灵活多样

除外,影视剪辑技能还可支撑个人创业。学员可成立独立剪辑工作室,承接企业宣传片、电商短视频、婚礼跟拍等项目;也可通过知识付费(如剪辑教程、模板售卖)拓展收入来源,实现“技能+商业”的双重价值。

行业生命周期长:技术迭代中的稳定需求

尽管剪辑软件不断更新(如Premiere从CS6到2024版),但剪辑的核心逻辑(叙事节奏、画面语言)始终不变。掌握底层技能的剪辑师可快速适应新工具,行业经验积累越久,职业竞争力越强,不存在“吃青春饭”的顾虑。

北京IT培训机构

北京IT培训机构
认证 7 年

成立: 2006年

认证 地址认证 教学保障 在线预约 到店体验 售后支持
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-06 03:29:57 HTTP/1.1 GET : http://www.aabqn.com/s/5692/c/79918.html
  2. 运行时间 : 0.052669s [ 吞吐率:18.99req/s ] 内存消耗:395.39kb 文件加载:136
  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_course_details.php ( 6.12 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_bottom.php ( 1.16 KB )
  136. /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.001103s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '5692' AND `site_id` = 18 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000268s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000980s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 5692 [ RunTime:0.000213s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000611s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 5692 [ RunTime:0.000227s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000655s ]
  9. SELECT `a`.*,`content` FROM `fqi_school_course` `a` LEFT JOIN `fqi_school_course_content` `b` ON `b`.`content_id`=`a`.`content_id` WHERE `school_id` = 5692 AND `a`.`content_id` = '79918' AND `course_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000573s ]
  10. (select content_id,course_name from fqi_school_course where school_id = '5692' and content_id < '79918' and site_id = '18' order by content_id desc limit 1) union all(select content_id,course_name from fqi_school_course where school_id = '5692' and content_id > '79918' and site_id <= '18' order by content_id asc limit 1) [ RunTime:0.001295s ]
  11. SELECT * FROM `fqi_school_course` WHERE `school_id` = 5692 AND `site_id` = 18 AND `course_status` = 1 AND `school_status` = 1 AND `school_class_id` = 20070 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000324s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 5692 AND `site_id` = 18 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 10 [ RunTime:0.000230s ]
  13. SELECT COUNT(*) AS think_count FROM `fqi_school_course` WHERE `school_id` = 5692 AND `course_status` = 1 [ RunTime:0.000164s ]
  14. SHOW FULL COLUMNS FROM `fqi_school_teacher` [ RunTime:0.000615s ]
  15. SELECT COUNT(*) AS think_count FROM `fqi_school_teacher` WHERE `school_id` = '5692' [ RunTime:0.000209s ]
  16. SHOW FULL COLUMNS FROM `fqi_school_comments` [ RunTime:0.000587s ]
  17. SELECT COUNT(*) AS think_count FROM `fqi_school_comments` WHERE `school_id` = '5692' [ RunTime:0.000202s ]
  18. SELECT `content_id`,`course_name`,`a`.`school_id`,`b`.`school_name` FROM `fqi_school_course` `a` LEFT JOIN `fqi_school` `b` ON `b`.`school_id`=`a`.`school_id` WHERE `a`.`site_id` = '18' AND `b`.`school_status` = '1' AND `course_status` = 1 AND `course_id` < '79918' ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.040210s ]
0.053014s