• 主力讲师都拥有8年以上的专业从业经验
  • 使得学员在短期内能够迅速提高到专业实操水平
  • 由浅深入、通俗易懂、直至推荐

400-882-1933

摄影手动对焦全场景应用指南:10类常见拍摄场景实操解析

来源:广州爱摄影培训学校 时间:04-11

摄影手动对焦全场景应用指南:10类常见拍摄场景实操解析

为什么摄影需要掌握手动对焦?

如今自动对焦(AF)几乎是相机的基础配置,但很多摄影爱好者可能忽略了一个关键点——自动对焦并非万能。在实际拍摄中,光线条件、拍摄对象特性、构图需求等因素,常会让AF系统"力不从心"。这时候,手动对焦就成了摄影师必须掌握的核心技能。它不仅能解决自动对焦的局限性问题,更能让创作者完全掌控画面焦点,实现更精准的创作表达。接下来,我们将逐一解析10类常见拍摄场景中,手动对焦的必要性与操作技巧。

野生动物拍摄:静音与自然的双重需求

拍摄野生动物时,自动对焦(AF)常遇到棘手问题。多数野生动物对声音异常敏感,即使是AF系统最轻微的"滴滴"对焦声,也可能惊飞鸟类、吓跑鹿群。曾有生态摄影师分享过经历:在拍摄林莺时使用AF,连续三次因对焦声导致鸟儿飞离;切换手动对焦后,成功捕捉到林莺梳理羽毛的自然状态。

操作建议:提前观察动物活动范围,预估其停留位置;使用实时取景功能放大画面,确认焦点精准落在动物眼部或关键部位;保持呼吸平稳,避免触碰相机产生额外声响。

透过玻璃拍摄:避免焦点偏移的有效方案

飞机舷窗、水族馆玻璃、博物馆展柜……这些场景下拍摄常需透过玻璃完成。此时AF系统容易"误判",将焦点锁定在玻璃反光或表面划痕上,导致主体模糊。例如在海洋馆拍摄海豚时,自动对焦可能被玻璃上的水痕吸引,而手动对焦能直接将焦点对准水中的海豚。

操作建议:贴近玻璃但避免触碰(防止产生指纹),调整拍摄角度减少反光;使用手动对焦环缓慢旋转,通过取景器观察主体轮廓清晰度变化,确认焦点准确后再按下快门。

弱光环境:突破AF系统的性能限制

自动对焦依赖光线反差完成工作,在弱光环境下(如夜晚路灯、室内暖光),物体明暗对比降低,AF系统常出现"拉风箱"(反复搜索焦点)现象。曾有摄影师在拍摄夜间教堂内景时,AF系统连续5秒无法完成对焦,切换手动模式后,通过实时取景放大功能,3秒内精准对焦在彩色玻璃窗的花纹上。

操作建议:开启相机实时取景功能,将画面放大至10倍以上;观察取景器中主体边缘是否锐利,微调对焦环直至轮廓清晰;若环境过于黑暗,可使用手机闪光灯短暂补光辅助对焦(注意避免光线直射主体)。

低反差物体:解决AF系统的"识别障碍"

光滑墙面、纯色布料、水面等低反差物体,因缺乏明显纹理细节,AF系统难以找到对焦参照点。例如拍摄白色墙面的抽象光影时,自动对焦可能在墙面不同区域反复跳转,导致画面始终模糊。手动对焦则能绕过这一限制,直接控制焦点位置。

操作建议:寻找画面中细微的纹理变化(如墙面上的微小斑点、布料的褶皱)作为对焦参考;若完全无细节,可先对向其他高反差物体(如旁边的绿植),半按快门锁定焦点后重新构图;或直接使用手动对焦环,通过观察取景器中光影边缘的锐利度判断焦点位置。

人像摄影:精准控制"心灵之窗"的清晰度

人像摄影的核心是捕捉眼神光,大光圈拍摄时(如f/1.8),景深极浅,焦点偏移1mm就可能导致眼睛模糊。自动对焦虽能快速锁定,但有时会误对焦在眉毛、鼻尖等位置。手动对焦则能确保焦点精准落在瞳孔位置,让人物眼神更具感染力。

操作建议:使用实时取景放大功能(推荐5倍以上),观察瞳孔边缘是否锐利;若被摄者有轻微移动,可先对焦在预计位置,通过语言引导被摄者保持静止后再拍摄;团体人像时,优先对焦在中间人物的眼睛,确保主次清晰。

微距摄影:掌控极浅景深的关键

微距摄影的景深可能只有几毫米,自动对焦常因"无法判断"而反复调整,导致拍摄效率低下。例如拍摄昆虫复眼时,AF系统可能在复眼与触须间来回切换,而手动对焦能让摄影师自主选择焦点,突出昆虫的细节特征。

操作建议:使用三脚架固定相机,避免手持抖动;开启实时取景并放大至10倍,缓慢旋转对焦环,观察被摄体纹理(如花瓣脉络、昆虫腿毛)的清晰度变化;若使用微距镜头,可配合对焦导轨微调相机位置,实现更精准的焦点控制。

三分法构图:突破对焦点位置的限制

部分入门级相机对焦点集中在画面中央,使用三分法构图(将主体放在画面1/3处)时,AF系统难以直接对焦在目标位置。此时手动对焦能绕过对焦点限制,先通过取景器确认主体位置,再手动调整焦点至理想区域。

操作建议:在取景器中用虚拟网格线标记三分法位置,确定主体应处的区域;通过手动对焦环调整焦点,同时观察画面中主体与背景的虚实关系,确保主体清晰、背景虚化自然;若相机支持自定义对焦点,可结合手动对焦进一步提升效率。

风光摄影:确保全景深的核心操作

拍摄风光时,常希望前景的岩石、中间的溪流、远处的山脉都保持清晰,这需要使用小光圈(如f/16)配合超焦距对焦。若使用自动对焦,按下快门时相机可能重新对焦在无限远,导致前景模糊。手动对焦则能精确调整至超焦距位置,确保全景深清晰。

操作建议:提前计算超焦距(可通过相机内置的景深预览功能或手机APP辅助);使用实时取景放大至画面1/3处(通常为前景与中景的过渡区域),调整对焦环直至该区域清晰;按下景深预览按钮,确认全景深效果符合预期后再拍摄。

HDR拍摄:多帧照片的焦点统一

HDR照片需要拍摄3-5张不同曝光的照片,后期合成时要求所有照片焦点完全一致。若使用自动对焦,每张照片的焦点可能因微小偏移导致合成后画面重影。手动对焦能锁定初始焦点,确保多帧照片的焦点完全重合。

操作建议:拍摄前使用手动对焦确定焦点,并用相机的"焦点锁定"功能(若有)固定;使用三脚架避免相机位移;拍摄过程中避免触碰对焦环,如需调整参数(如快门速度),优先调整光圈或ISO,保持对焦状态不变。

运动物体拍摄:弥补AF追焦的不足

高速运动物体(如赛车、飞鸟)的拍摄中,AF追焦系统虽能追踪,但受限于物体运动轨迹的突然变化(如急转、俯冲),常出现焦点丢失。手动对焦可通过预判物体运动轨迹,提前调整焦点至预计位置,配合高速连拍捕捉清晰画面。

操作建议:观察运动物体的速度与方向,估算其到达画面中心的时间;提前将焦点调整至该位置,保持半按快门准备拍摄;若物体运动规律稳定(如环形赛道),可使用"陷阱对焦"技巧,提前对焦在固定点,等待物体进入该区域时触发快门。

手动对焦的日常练习方法

掌握手动对焦并非一蹴而就,需要日常练习积累手感。建议从静态物体开始(如桌面摆件、窗外绿植),使用实时取景放大功能练习精准对焦;逐步过渡到动态物体(如走动的宠物、飘落的树叶),提升对焦反应速度;最后结合实际拍摄场景(如户外人像、夜景风光),在实战中巩固技巧。

需要注意的是,不同镜头的对焦环阻尼不同(定焦镜头通常更细腻,变焦镜头可能稍显松散),建议熟悉常用镜头的对焦特性,针对性调整操作力度。同时,定期清洁镜头前组镜片,避免灰尘影响取景器观察效果。

校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-06-19 15:40:08 HTTP/1.1 GET : http://www.edufv.com/s/1549/n/4412.html
  2. 运行时间 : 0.011603s [ 吞吐率:86.18req/s ] 内存消耗:399.92kb 文件加载: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.000383s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001043s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '1549' AND `site_id` = 6 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000236s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000564s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 1549 [ RunTime:0.000216s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000581s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 1549 [ RunTime:0.000245s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000626s ]
  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` = 1549 AND `a`.`content_id` = '4412' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000597s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '1549' and content_id < '4412' 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 = '1549' and content_id > '4412' and site_id <= '6' order by content_id asc limit 1) [ RunTime:0.000737s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000704s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1549 AND `site_id` = 6 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000383s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1549 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000181s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 1549 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000180s ]
  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` < 4412 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.001185s ]
0.011944s