• 郑州鬼谷学院采用项目教学法,深入浅出的知识传送模式
  • 郑州鬼谷学院以“实战教学、实用教学、实时教学”为理念
  • 真正培养出能够适应企业需要的应用型人才

400-689-2779

郑州鬼谷学院影视后期专业班:全流程实战教学体系解析与职业发展指南

郑州鬼谷学院影视后期专业班:全流程实战教学体系解析与职业发展指南

授课机构: 郑州鬼谷学院

上课地点: 校区地址

成交/评价:

联系电话: 400-689-2779

郑州鬼谷学院影视后期专业班:全流程实战教学体系解析与职业发展指南课程详情

影视后期行业现状与人才需求解析

随着《流浪地球》《长津湖》等国产特效大片票房屡创新高,影视后期制作已成为影视产业的核心竞争力。据行业数据显示,我国影视制作人才缺口目前超过100万,其中3D建模师、特效合成师、广告包装师等岗位需求尤为迫切。这一缺口源于行业快速发展与人才培养的滞后——影视后期不仅需要熟练掌握MAYA、AE等专业软件,更需兼具艺术审美与商业思维的复合型人才,而系统化的职业教育正是填补这一空白的关键。

以薪资水平为例,入行1-3年的初级影视后期制作师月薪普遍在8000元以上,具备3-5年经验的中高级人才(如特效合成主管、广告包装总监)月薪可达15000-30000元,部分参与头部项目的核心技术人员年收入甚至突破50万元。这一薪资竞争力,使得影视后期成为近年来职业教育领域的热门选择。

什么是影视后期专业?核心工作流程详解

影视后期制作是将拍摄素材、三维模型、动画片段等元素整合为完整影片的核心环节,主要包含两大领域:一是电影/电视剧的特效合成,如《阿凡达》中的虚拟场景、《西游记之大圣归来》的角色动画;二是影视广告与电视包装,如品牌宣传片的动态设计、电视频道的栏目包装。其具体流程可分为素材整理、粗剪、精剪、特效添加、调色、声音制作六大步骤,每个环节均需专业技术支撑。

以电影特效制作为例,一个爆炸镜头的完成需要:先用MAYA制作爆炸模型,通过Realflow模拟流体运动轨迹,再用FumeFX渲染烟雾细节,最后在Nuke中与实拍画面合成,并调整光影匹配度。这一过程不仅考验软件操作能力,更需要对物理规律、画面美感的深度理解。

郑州鬼谷学院影视后期专业班:全流程教学体系拆解

针对行业需求与岗位能力模型,郑州鬼谷学院影视后期专业班设计了「软件基础-模型渲染-动画制作-特效合成-广告包装」五大阶段教学体系,覆盖从入门到商业实战的全成长路径。以下为各阶段核心内容:

1. 软件基础:构建技术操作底层能力

本阶段以PS、MAYA为核心工具,系统讲解界面操作、常用命令与行业工作流。学员将掌握:PS的图层管理与调色技巧(如通过通道面板实现精准抠图);MAYA的基础建模(多边形工具制作简单物体)、材质灯光基础(如何通过Lambert材质模拟陶瓷质感);同时通过案例教学理解影视后期全流程,明确各环节的技术衔接点。

2. 影视模型渲染:打造电影级角色与场景

进阶阶段聚焦MAYA的高阶建模与渲染技术。学员将深入学习多边形建模命令(如Bevel、Extrude的组合应用),掌握角色模型的拓扑优化(确保动画时无穿帮);通过UV展开与贴图烘焙技术,为模型添加细节纹理(如角色皮肤的毛孔质感);最终完成影视级角色场景模型(如《指环王》风格的精灵角色)与广告包装模型(如汽车宣传片的3D产品模型)的制作。

3. 高级影视动画:赋予角色生命的动态艺术

动画制作是影视后期的「灵魂」环节。本阶段从基础动画法则(如挤压拉伸、跟随运动)入手,通过小球弹跳、角色行走等经典案例,逐步掌握Graph Editor的曲线调整(实现自然的加速减速)、摄像机动画(模拟电影级运镜)。最终要求学员完成角色跑跳、情绪表达等复杂动画(如《疯狂动物城》中兔子朱迪的跳跃动作),确保动态效果符合物理规律与角色性格。

4. 影视特效与合成:创造视觉奇观的核心技术

特效合成是影视后期的技术制高点。学员将学习MAYA/MAX的粒子系统(如爆炸碎片的轨迹控制)、流体模拟(如真实水面的折射与波纹)、柔体动力学(如布料的自然下垂);结合FumeFX制作浓烟、Realflow模拟海浪,最终在Nuke/AE中完成特效镜头与实拍画面的融合(如《流浪地球》中行星发动机的火焰与演员的互动)。同时引入MEL脚本语言,提升复杂特效的制作效率。

5. 后期广告与包装:商业场景的实战应用

广告与包装是影视后期的重要商业出口。本阶段以AE与C4D为核心工具,学习动态图形设计(如品牌LOGO的三维动画)、视频剪辑(Premiere的多轨道剪辑技巧)、栏目包装(电视频道的频道ID设计)。学员需完成商业级作品(如某手机品牌的新品宣传片、某卫视的晚间节目包装),从创意脚本到最终输出全程参与,强化商业需求理解与执行能力。

四大教学特色:从技术学习到职业发展的全程护航

区别于传统培训机构的「填鸭式」教学,郑州鬼谷学院影视后期专业班通过四大特色体系,确保学员「学得会、用得上、好」:

  • 主讲1对1指导:主讲团队由参与过《哪吒之魔童降世》《刺杀小说家》等头部项目的行业专家组成,平均从业经验10年以上。课程采用「小班制+1对1答疑」模式,学员可随时与讲师沟通技术难点,确保每个知识点「学透、练熟」。
  • 一线案例驱动教学:课件由长期服务于腾讯、爱奇艺等平台的研发团队开发,包含《流浪地球2》爆炸特效拆解、某汽车品牌TVC全流程制作等30+商业案例。学员在课堂上即可接触真实项目需求,毕业作品直接可作为求职作品集。
  • 专属助教全程陪伴:专业助教团队提供「每日学习打卡+作业批改+进度跟踪」服务,从软件安装到渲染报错,随时解决学员的技术问题。更通过「学习小组」活动,促进学员间的技术交流与项目合作。
  • 定制化职业发展支持:团队根据学员技术特点与职业目标,提供「城市-岗位-企业」三维匹配服务。合作企业涵盖中影集团、追光动画、蓝色光标等影视/广告头部机构,学员毕业后可直接参与校招内推,部分优秀学员更可获得项目跟组机会。

选择影视后期专业班,开启高潜力职业人生

在影视产业持续升级、特效需求爆发式增长的今天,掌握影视后期核心技术不仅是进入高薪行业的敲门砖,更是参与中国影视工业进步的重要契机。郑州鬼谷学院影视后期专业班以「实战导向、技术深度、保障」为核心,为每一位学员提供从技能提升到职业发展的完整路径。无论你是零基础小白,还是希望进阶的在职人员,这里都将成为你影视后期职业生涯的起点。

现在加入,你将获得:与行业技术专家面对面学习的机会、覆盖全流程的商业案例实操、专属团队的1对1指导,以及一个属于自己的、能打动企业HR的高质量作品集。这不仅是一次技能学习,更是一次改变职业轨迹的重要选择。

郑州鬼谷学院

郑州鬼谷学院
认证 7 年

成立: 2006年

认证 地址认证 教学保障 在线预约 到店体验 售后支持
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-03 23:44:24 HTTP/1.1 GET : http://www.aabqy.com/s/2769/c/39720.html
  2. 运行时间 : 0.064279s [ 吞吐率:15.56req/s ] 内存消耗:394.66kb 文件加载: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.000348s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.000912s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '2769' AND `site_id` = 23 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000255s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000599s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 2769 [ RunTime:0.000192s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000621s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 2769 [ RunTime:0.000200s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000666s ]
  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` = 2769 AND `a`.`content_id` = '39720' AND `course_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000862s ]
  10. (select content_id,course_name from fqi_school_course where school_id = '2769' and content_id < '39720' and site_id = '23' order by content_id desc limit 1) union all(select content_id,course_name from fqi_school_course where school_id = '2769' and content_id > '39720' and site_id <= '23' order by content_id asc limit 1) [ RunTime:0.000565s ]
  11. SELECT * FROM `fqi_school_course` WHERE `school_id` = 2769 AND `site_id` = 23 AND `course_status` = 1 AND `school_status` = 1 AND `school_class_id` = 10387 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000307s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 2769 AND `site_id` = 23 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 10 [ RunTime:0.000214s ]
  13. SELECT COUNT(*) AS think_count FROM `fqi_school_course` WHERE `school_id` = 2769 AND `course_status` = 1 [ RunTime:0.000146s ]
  14. SHOW FULL COLUMNS FROM `fqi_school_teacher` [ RunTime:0.000647s ]
  15. SELECT COUNT(*) AS think_count FROM `fqi_school_teacher` WHERE `school_id` = '2769' [ RunTime:0.000181s ]
  16. SHOW FULL COLUMNS FROM `fqi_school_comments` [ RunTime:0.000612s ]
  17. SELECT COUNT(*) AS think_count FROM `fqi_school_comments` WHERE `school_id` = '2769' [ RunTime:0.000199s ]
  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` = '23' AND `b`.`school_status` = '1' AND `course_status` = 1 AND `course_id` < '39720' ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.052872s ]
0.064615s