• 前七天免费听课
  • 国内一线院线剪辑指导
  • 学习期间住宿免费

400-888-4851

掌握剪辑精髓的关键要点与实用技巧全解析

来源:北京映美剪辑学院 时间:11-19

掌握剪辑精髓的关键要点与实用技巧全解析

用画面讲故事的底层逻辑

视频剪辑的本质,是通过镜头的排列组合传递信息、引发共鸣。要实现这一点,首先需要理解“用画面叙事”的底层逻辑。简单来说,每个镜头都像故事的“语言”,如何让这些“语言”连贯、有逻辑、有感染力,是剪辑的核心课题。

动态画面衔接是基础原则。在实际操作中,画面不能是“静止”的——这里的静止不是指完全不动,而是缺乏“运动感”。比如固定机位的长镜头,虽然能传递稳定感,但连续使用会让观众产生视觉疲劳。正确的做法是让画面包含“推拉摇移跟升降”中的至少一种运动方式。如果遇到必须使用的固定画面(如珍贵的历史照片),可以通过AE等软件模拟推拉效果,虽然清晰度会有轻微损失,但画面流畅度的提升远大于这点损耗。

景别与机位的搭配也有讲究。两个连续镜头不宜使用相同景别或相似机位,否则容易让观众产生“重复”的观感。举个例子,前一个镜头是中景拍摄人物抬手,下一个镜头如果继续用中景且机位角度变化不大,画面会显得单调;但如果切换为近景拍摄手部动作,再切回全景展示环境,叙事层次会更丰富。当然,特殊艺术表达(如实验性短片)除外。

运动镜头的衔接时机需要精准把握。许多新手习惯等画面完全“定住”(即运动结束、画面稳定)后再切换,这会导致节奏拖沓。实际上,保留一点“未完成感”反而能调动观众的想象力。比如拍摄一个人跑步入画,当他跑到画面中央时切到下一个镜头,观众会自动“补全”他跑向终点的动作,这种“留白”是剪辑的重要技巧。

镜头逻辑顺序必须符合生活经验。以“冲泡咖啡”为例,合理的镜头顺序应该是:手拿起咖啡杯→打开咖啡罐→舀取咖啡粉→倒入杯中→加水搅拌。如果顺序颠倒为“加水搅拌→拿起咖啡杯”,观众会本能地感到别扭,因为不符合日常操作的认知。因此,剪辑前需要梳理事件的自然流程,确保镜头顺序与观众的经验一致。

节奏控制分为“内在节奏”和“外加节奏”。内在节奏由事件本身的发展逻辑决定——比如紧张的追逐戏需要快速切换镜头,温馨的对话场景则适合较长的镜头;外加节奏通过音乐、音效等外部元素调节,比如用快节奏的鼓点配合动作镜头,用舒缓的钢琴声配合情感表达。两者结合能让叙事更有层次。

剪辑画面示例

场景转换的8种实用方法

从一个场景过渡到另一个场景时,合理的转换方式能让观众自然跟随叙事节奏。以下8种方法覆盖了常见场景,灵活运用可提升视频的流畅度。

种是“相溶转换”。即前一个画面逐渐淡化,后一个画面同步浮现,类似“叠化”效果。这种方法过渡柔和,适合情感类内容(如回忆与现实的切换),几乎不会出错。

第二种是“淡入淡出”。以黑色为过渡,前一个画面渐暗至黑,再从黑渐亮显示下一个画面。这种方法仪式感强,常用于章节结束或情绪转折(如从欢乐场景转到悲伤场景)。

第三种是“遮掩物连接”。利用画面中的物体(如人物抬手、窗帘飘动)遮挡镜头,在遮挡瞬间切换场景。例如,人物抬手遮挡阳光,镜头切到他放下手时的新场景,观众会自然接受场景变化。

第四种是“模糊画面过渡”。通过调整焦距或后期处理让画面变模糊,在模糊状态下切换场景,再恢复清晰。这种方法适合时间或空间的快速跳跃(如从白天跳到夜晚)。

第五种是“运动模糊连接”。利用镜头运动(如快速横摇)产生的模糊效果,在模糊过程中完成场景切换。例如,镜头从人物面部快速摇向窗外,模糊瞬间切到窗外的新场景,流畅且有动感。

第六种是“相同风景空切”。两个场景中出现相同的风景元素(如同一棵树、同一片天空),直接切换镜头。例如,前一个场景是海边日落,后一个场景是另一个城市的海边日出,通过“海平线”这一共同元素连接,观众不会感到突兀。

第七种是“曝光效果过渡”。通过调整画面曝光(如过曝变白、欠曝变黑),在极端曝光状态下切换场景。这种方法常用于广告或音乐视频,能制造强烈的视觉冲击。

第八种是“分割画面过渡”。将屏幕分割为两部分,前一个场景在左半部分渐弱,后一个场景在右半部分渐强,最终完全替代。这种方法适合对比性内容(如新老场景对比)。

进阶剪辑的关键技巧

除了基础的叙事逻辑和场景转换,掌握一些进阶技巧能显著提升剪辑质量,让作品从“合格”迈向“优秀”。

多线叙事时,交替呈现不同镜头。例如,在讲述“两个角色同时行动”的情节时,交替切换两人的镜头,能制造紧张感或呼应感。需要注意的是,切换频率要与情节节奏匹配——高潮部分可快速切换,铺垫部分则适当延长单镜头时长。

连接困难时,尝试“跳出式剪辑”。当两个场景逻辑关联较弱时,不必强行寻找过渡元素,直接切换并通过后续内容补充关联。例如,前一个镜头是人物皱眉思考,下一个镜头直接切到他电脑上的邮件(邮件内容解释他思考的原因),观众会自动建立联系。

利用不同框架镜头制造节奏。通过调整画面边框(如圆形、方形、动态边框),让连续镜头呈现“渐进式”变化。例如,三个镜头分别使用小、中、大圆形边框,观众的视线会跟随边框扩展,产生视觉推进感。

保持分辨率与画面大小统一。前后镜头的分辨率不一致(如1080P与720P)或画面比例不同(如16:9与4:3),会导致视觉割裂。剪辑前需统一素材参数,必要时通过裁剪或缩放调整,确保画面连贯。

用1-2帧叠化替代硬切。画面直接切换容易产生“跳跃感”,尤其是情绪转换时。在两个镜头间叠加1-2帧的叠化(即前一个镜头渐弱、后一个镜头渐强),过渡会更自然。这种方法在短视频中尤为常用。

谨慎使用黄色系色彩。黄色在视频中易呈现“脏、暗”的视觉效果,尤其在光线不足的场景中。如果需要暖色调,可选择偏橙色的黄色(如#FFA500),既能保留温暖感,又不会显得浑浊。

高效剪辑的操作建议

实际操作中,细节处理和效率提升同样重要。以下是几个能优化流程、提升作品质量的实用建议。

多轨道音频对齐时,先对画面再对声音。许多新手习惯同时调整画面和音频,容易手忙脚乱。正确的方法是:先将几段视频的画面大致对齐(如人物动作同步),再逐帧调整音频,这样能更高效地完成匹配。

视频首尾使用渐变效果。开头用“淡入”(从黑渐亮)、结尾用“淡出”(从亮渐黑),能避免画面突然出现或消失的“突兀感”。这种处理在vlog、宣传片中尤为重要,能提升观众的观看体验。

音乐高潮对准画面高潮。在音乐与画面结合时,将音乐的“情绪峰值”(如鼓点加强、旋律拔高)与视频的“内容峰值”(如人物达成目标、情节转折)同步,能强化情感共鸣。例如,音乐的高潮部分配合人物欢呼的画面,观众的情绪会被更强烈地调动。

熟练使用快捷键提升效率。剪辑软件(如Premiere、Final Cut Pro)的快捷键能大幅减少操作时间。例如,Premiere中“J/K/L”键控制播放,“C”键切割素材,“V”键切换选择工具,掌握这些能让剪辑流程更顺畅。建议新手制作一张快捷键表,随时查阅练习。

剪辑软件界面示例

剪辑是一门“用画面说话”的艺术,需要理论知识与实践经验的结合。掌握本文提到的要点与技巧后,建议通过大量练习巩固——可以从剪辑短视频开始,逐步尝试复杂叙事。随着经验积累,你会越来越理解“剪辑精髓”的真正含义:不是技巧的堆砌,而是如何让观众“自然跟随、感同身受”。

课程导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-04 10:10:28 HTTP/1.1 GET : http://www.aabrd.com/s/4978/n/30145.html
  2. 运行时间 : 0.017985s [ 吞吐率:55.60req/s ] 内存消耗:378.28kb 文件加载: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.000348s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001238s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '4978' AND `site_id` = 19 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000305s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000882s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 4978 [ RunTime:0.000272s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000855s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 4978 [ RunTime:0.000273s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000916s ]
  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` = 4978 AND `a`.`content_id` = '30145' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000684s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '4978' and content_id < '30145' 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 = '4978' and content_id > '30145' and site_id <= '19' order by content_id asc limit 1) [ RunTime:0.000852s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.001029s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 4978 AND `site_id` = 19 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000418s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 4978 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000229s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 4978 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` = '19' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 30145 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.005847s ]
0.018319s