• 以创意领航,秉承完美的理念
  • 致力于打造CG人才,为学员提供CG职业教育。
  • 一对一服务、实战项目教学

400-888-4851

游戏动作特效全流程实训班:从软件基础到作品的系统培养方案

游戏动作特效全流程实训班:从软件基础到作品的系统培养方案

授课机构: 青岛完美动力教育

上课地点: 校区地址

成交/评价:

联系电话: 400-888-4851

游戏动作特效全流程实训班:从软件基础到作品的系统培养方案课程详情

游戏动作特效全流程实训班:从软件基础到作品的系统培养方案

模块一:游戏动作特效U3D基础构建

游戏特效制作的核心在于软件工具的灵活运用与基础流程的精准把控。本阶段重点围绕3dsMax、Photoshop、U3D三大工具展开教学:3dsMax作为模型与动画的核心制作平台,需掌握基础建模、材质贴图与简单动画生成;Photoshop则聚焦特效贴图的绘制与后期处理技巧,包括粒子纹理设计、光效叠加等实用操作;U3D引擎的学习侧重特效资源的导入、参数调整与场景适配,确保制作的特效能够在游戏引擎中流畅运行。

课程通过「软件功能讲解+案例实操+问题复盘」的三重模式,带领学员完成场景特效(如草地随风摆动)、角色特效(如武器发光)、道具特效(如魔法卷轴展开)及物理攻击特效(如剑刃碰撞火花)的全流程制作。每完成一个案例,教师会针对学员作品的细节问题进行针对性指导,从贴图分辨率到粒子生命周期,从特效层级排列到引擎兼容性,逐一夯实基础能力。

U3D基础教学场景

模块二:职业技能进阶与风格化特效制作

游戏市场对特效的需求呈现多元化特征,不同游戏类型、职业定位需要匹配差异化的特效风格。本阶段以战士、法师、牧师三大经典职业为切入点,深入解析二次元、次时代写实、暗黑风等主流特效的设计逻辑与制作要点。例如,战士职业的技能特效需突出力量感,通过大体积粒子、强烈的碰撞反馈强化打击感;法师技能则侧重元素属性表现,如火焰的渐变色彩、雷电的分叉轨迹设计;牧师治疗技能需营造治愈氛围,采用柔化粒子、暖色调光效传递温和感。

课程同步覆盖MMORPG(大型多人在线角色扮演)与MOBA(多人在线战术竞技)两类热门游戏的特效差异:MMORPG更注重技能的视觉叙事性,特效需与角色背景、剧情发展相融合;MOBA则强调技能的即时反馈与战场辨识度,要求特效在复杂战斗场景中仍能清晰传达技能信息。通过具体案例拆解(如《XX手游》战士大招制作全记录),学员将掌握从需求分析到最终输出的完整技能特效制作方法论。

技能特效案例展示

模块三:动画基础与机械运动控制

动作与特效的协同是游戏画面表现的关键。本阶段首先解析3DMAX动画生成原理,从关键帧设置、插值算法到动画曲线调节,系统学习动画节奏与轨迹的控制技巧。通过简单场景元素(如旋转的门、升降的平台)与机械装置(如齿轮组、液压臂)的动画制作,学员将掌握骨骼搭建的核心思路——如何通过主骨骼控制整体运动,通过子骨骼实现细节联动,以及如何利用虚拟体(Dummy)约束复杂部件的运动轨迹。

课程特别设置「创意动画设计」环节,鼓励学员结合自身兴趣设计独特的动画方案。例如,有的学员尝试制作「蒸汽朋克风格的自动售货机」,通过齿轮转动、活塞伸缩等机械运动还原复古科技感;有的学员设计「魔法森林中的会说话树屋」,通过树枝摆动、门窗开合传递拟人化特征。教师会从「运动逻辑合理性」「视觉表现丰富性」「引擎适配性」三个维度进行点评,帮助学员将创意转化为可实现的动画作品。

机械动画制作示例

模块四:人形生物动画全流程制作

人形角色是游戏中的核心表现对象,其动作真实度直接影响玩家代入感。本阶段以游戏常见的男女主角为案例,系统讲解biped骨骼与bone骨骼的搭建方法:biped骨骼适用于标准化人形角色,自带步行、跑步等基础动作库,可快速生成符合人体工学的运动;bone骨骼则更灵活,适合需要个性化调整的角色(如体型夸张的魔法师、肌肉发达的战士)。

课程重点突破「骨骼与模型适配」「bonespro蒙皮技巧」两大难点:骨骼需与模型拓扑结构精准匹配,避免穿模或变形失真;蒙皮时需根据肌肉运动规律分配权重,例如大臂骨骼应控制三角肌区域,小臂骨骼控制肱二头肌区域,确保动作流畅自然。学员将学习走、跑、跳、待机、攻击、死亡等12类核心动作的制作,掌握「POSE TO POSE」(姿势到姿势)的动画设计理念——通过关键帧设置关键姿势,再调节中间帧过渡,最终生成符合游戏需求的细腻动作。

人形动画骨骼搭建

模块五:非人形生物动画设计与实现

游戏世界的丰富性离不开各类非人形生物的点缀,从温顺的坐骑到凶残的怪物,其动作设计需贴合生物特性。本阶段系统讲解四足动物(如战马、狼)、昆虫(如蝴蝶、甲虫)及异形怪物的骨骼搭建与动作逻辑:四足动物需注意四肢的交替运动规律,前腿与后腿的发力顺序;昆虫需表现外骨骼的刚性运动与翅膀的高频振动;怪物则可结合多种生物特征(如蜥蜴的爬行+蝙蝠的飞行),设计具有视觉冲击力的独特动作。

课程设置「生物特性分析」专项训练,学员需先观察真实生物的运动视频(如猎豹奔跑、螳螂捕食),提炼关键动作特征,再应用到游戏生物设计中。例如,设计「火焰狼」时,需保留狼的奔跑姿态,同时加入火焰粒子的动态效果;设计「机械甲虫」时,需模拟金属关节的卡顿感,配合齿轮转动的细节动画。通过这种「观察-提炼-创作」的训练模式,学员将掌握非人形生物动画的核心设计思维。

非人形生物动画案例

模块六:企业级DEMO实训与作品打磨

为帮助学员无缝对接游戏公司岗位需求,本阶段完全模拟企业实际制作流程:首先进行「模拟测试」,给定具体任务(如「为某MOBA游戏射手英雄设计一套技能动画+特效」),要求学员在规定时间内完成制作,教师从「效率」「质量」「创意」三方面点评,暴露技术短板;接着进入「自主设计」环节,学员需根据文字需求(如「设计一个玄幻风格的法师角色,包含待机、施法、大招三个动作及配套特效」)独立完成全流程制作,教师全程跟踪指导,解决引擎导出、资源优化等实际工作中常见问题。

最终阶段,学员需将已完成的角色动画与特效进行整合,输出符合游戏引擎要求的完整DEMO作品。教师会针对作品的「商业适配性」进行重点优化——例如调整特效粒子数量以平衡画质与性能,优化动画文件大小以提升加载速度,确保作品既能展现个人创意,又能满足企业实际生产需求。通过这一阶段的训练,学员不仅能获得高质量的作品,更能提前熟悉游戏公司的工作模式与协作流程,为正式入职奠定坚实基础。

企业级DEMO实训现场

本游戏动作特效培训班通过六大核心模块的系统教学,覆盖从软件基础到作品的全流程培养。无论是想入行的新手,还是希望提升技能的在职者,都能在这里找到适合自己的学习路径。课程采用「理论讲解+案例实操+企业实训」的三维教学模式,确保学员不仅掌握技术,更能理解游戏行业的实际需求。选择我们,就是选择与游戏行业前沿技术同步,为自己的职业发展开启更广阔的空间。

青岛完美动力教育

青岛完美动力教育
认证 7 年

成立: 2006年

认证 地址认证 教学保障 在线预约 到店体验 售后支持
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-03 16:31:51 HTTP/1.1 GET : http://www.aabrd.com/s/3278/c/47816.html
  2. 运行时间 : 0.056754s [ 吞吐率:17.62req/s ] 内存消耗:391.28kb 文件加载: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.000387s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001098s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '3278' AND `site_id` = 19 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000338s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000585s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 3278 [ RunTime:0.000249s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000625s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 3278 [ RunTime:0.000452s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000851s ]
  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` = 3278 AND `a`.`content_id` = '47816' AND `course_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000623s ]
  10. (select content_id,course_name from fqi_school_course where school_id = '3278' and content_id < '47816' and site_id = '19' order by content_id desc limit 1) union all(select content_id,course_name from fqi_school_course where school_id = '3278' and content_id > '47816' and site_id <= '19' order by content_id asc limit 1) [ RunTime:0.001106s ]
  11. SELECT * FROM `fqi_school_course` WHERE `school_id` = 3278 AND `site_id` = 19 AND `course_status` = 1 AND `school_status` = 1 AND `school_class_id` = 12365 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000268s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 3278 AND `site_id` = 19 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 10 [ RunTime:0.000200s ]
  13. SELECT COUNT(*) AS think_count FROM `fqi_school_course` WHERE `school_id` = 3278 AND `course_status` = 1 [ RunTime:0.000178s ]
  14. SHOW FULL COLUMNS FROM `fqi_school_teacher` [ RunTime:0.000633s ]
  15. SELECT COUNT(*) AS think_count FROM `fqi_school_teacher` WHERE `school_id` = '3278' [ RunTime:0.000237s ]
  16. SHOW FULL COLUMNS FROM `fqi_school_comments` [ RunTime:0.000568s ]
  17. SELECT COUNT(*) AS think_count FROM `fqi_school_comments` WHERE `school_id` = '3278' [ RunTime:0.000186s ]
  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` = '19' AND `b`.`school_status` = '1' AND `course_status` = 1 AND `course_id` < '47816' ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.044329s ]
0.057087s