• 秉承“分享”的理念,毫无保留地把CG技术分享给更多人
  • 大力培养数字艺术设计人才,共同推动了中国数字艺术创意产业发展
  • 成为值得信赖的教育机构

400-018-6228

天津游戏特效大师班全解析:从技能提升到职业发展的系统学习路径

天津游戏特效大师班全解析:从技能提升到职业发展的系统学习路径

授课机构: 天津火星时代

上课地点: 校区地址

成交/评价:

联系电话: 400-018-6228

天津游戏特效大师班全解析:从技能提升到职业发展的系统学习路径课程详情

谁适合学游戏特效大师班?三类人群的职业突破选择

天津火星时代游戏特效大师班的课程设计充分考虑不同学习者的需求,无论是职业转型的探索者、热爱游戏的技术发烧友,还是已有设计基础的进阶者,都能找到匹配的成长路径。

类是跨行业转型者。许多非游戏行业从业者面临职业瓶颈,渴望进入高增长的游戏领域。游戏特效师作为技术与艺术结合的岗位,既需要一定的美术敏感度,也依赖软件操作能力,对零基础但学习意愿强的转行人群友好。课程会从基础软件操作开始,逐步过渡到项目实战,帮助学员快速建立行业竞争力。

第二类是游戏爱好者。这类学员对游戏特效有天然兴趣,但缺乏系统的技术训练。课程会将兴趣转化为职业能力,通过分析热门游戏的特效设计逻辑(如《原神》的元素反应特效、《王者荣耀》的技能动画),引导学员理解“好玩”背后的技术实现,同时掌握从概念设计到最终输出的完整流程。

第三类是有设计基础的进阶者。部分学员已掌握游戏原画或UI设计技能,希望向更具技术深度的方向发展。游戏特效作为游戏开发中的“动态设计”环节,与原画、UI有强关联性。课程会重点强化这类学员的动画制作、物理特效模拟等能力,帮助其从“静态设计者”升级为“动态效果实现者”。

课程学什么?游戏特效与动画的全流程技术拆解

游戏特效大师班的核心是培养“能落地、会创新”的实战型人才,课程内容围绕行业需求设计,覆盖从基础原理到项目实战的完整链条。

首先是动画基础与软件操作。学员将系统学习动画原理(如挤压与拉伸、跟随与重叠动作),掌握3ds Max、Maya等主流建模软件,以及After Effects、Houdini等特效工具的核心功能。例如,通过骨骼蒙皮绑定训练,理解角色动作的物理逻辑;通过粒子系统调试,掌握火焰、爆炸等特效的参数控制。

其次是游戏级特效制作流程。课程会按照“需求分析-概念设计-技术实现-优化输出”的行业标准流程展开教学。以角色技能特效为例,学员需先理解游戏角色的背景故事与技能定位,再通过草图确定特效风格(如科幻、国风、卡通),接着使用软件制作模型、添加动画,最后根据引擎要求(Unity/Unreal)调整文件格式与性能参数,确保特效在游戏中流畅运行。

最后是多风格特效实战。针对当前游戏市场的多样化需求,课程设置了不同风格的专项训练:从《英雄联盟》的写实类技能特效,到《光遇》的唯美场景特效,再到《动物森友会》的卡通化交互特效,学员将通过实际项目掌握不同风格的制作技巧,提升作品的适配性。

游戏特效制作场景图

学完能达到什么水平?从作品到的双重目标

游戏特效大师班的课程目标不仅是技术知识的积累,更注重培养学员独立完成项目的能力与职业竞争力,具体体现在两个层面。

技术层面,学员需掌握“场景-角色-道具”三大类特效的设计与制作。场景特效包括天气效果(雨、雪、雾)、环境交互(水流、火焰);角色特效涉及技能释放、状态变化(如中毒、加速);道具特效则涵盖武器光效、装备技能(如盾牌格挡时的冲击波)。通过系统训练,学员能独立完成从特效方案设计到引擎适配的全流程工作。

职业层面,课程强调“作品即简历”的理念。学员在学习过程中需完成3-5个完整的特效项目,涵盖不同风格与类型(如RPG游戏大招特效、休闲游戏交互特效),这些项目将组成个人作品集,直接用于求职。同时,课程会指导学员根据目标企业(如腾讯、米哈游、网易)的风格偏好调整作品方向,提升面试。

以往届学员为例,完成课程的学员平均能掌握5-8款行业主流软件,独立制作20+个特效案例,约85%的学员在结课后2个月内获得游戏公司的面试机会,其中60%成功入职初级游戏特效师岗位。

为什么选这个班?五大核心优势解析

在游戏培训市场中,天津火星时代游戏特效大师班的竞争力源于对行业需求的深度理解与教学模式的持续优化,具体体现在以下五个方面。

1. 课程内容与行业同步:课程团队定期与游戏公司技术专家沟通,及时更新教学内容。例如,针对近年流行的“次世代游戏特效”,课程新增了Houdini高级粒子系统、实时渲染优化等模块;针对移动端游戏的性能限制,增加了“轻量化特效制作”专项训练,确保学员所学与企业所需无缝对接。

2. 真实项目实战驱动:区别于传统教学的“案例演示”,课程采用“企业真实项目”作为训练素材。学员将参与游戏公司的外包项目(如独立游戏的技能特效制作、游戏版本更新的特效补充),在实际工作场景中学习需求沟通、进度管理、团队协作等职业技能,毕业即积累项目经验。

3. 双师教学+助教督学:主讲老师均为拥有5年以上游戏公司从业经验的技术骨干,负责核心知识讲解与项目指导;助教团队由往届优秀学员组成,提供每日学习答疑、进度跟踪与作业批改,确保“课上能听懂,课后能练会”。

4. 全流程支持:指导贯穿学习始终,包括简历优化(突出项目经验与软件技能)、作品集包装(按企业需求分类整理)、模拟面试(还原游戏公司技术面场景),以及合作企业内推机会。目前已与200+游戏公司建立人才输送合作,覆盖大厂、中型工作室及新兴游戏团队。

5. 灵活学习模式:针对在职学员需求,提供“线下集训+线上回放”的混合学习模式。线下班强调互动与实战,适合时间充裕的学员;线上班支持反复观看课程录像,配合直播答疑,满足边工作边学习的需求。

游戏特效师的职业前景:从初级到的成长路径

随着游戏产业的持续扩张(2023年中国游戏市场实际销售收入超3000亿元),游戏特效师的需求呈现爆发式增长。据游戏行业招聘平台统计,2023年游戏特效师岗位数量同比增长45%,平均月薪达12k-20k(一线城市特效师可达30k+)。

职业发展路径上,初级特效师(1-3年经验)主要负责基础特效制作,如技能光效、环境粒子;中级特效师(3-5年经验)需参与项目特效方案设计,协调原画、程序团队完成效果落地;特效师(5年以上经验)可晋升为特效主管或艺术指导,负责项目整体特效风格把控与新人培养。部分优秀从业者还可转向游戏主美、创意总监等更高阶岗位,或选择自主创业,成立特效外室。

无论是追求稳定的职业成长,还是向往创意自由的工作模式,游戏特效师都是游戏产业中极具发展潜力的岗位。天津火星时代游戏特效大师班正是为这一需求量身打造的学习平台,帮助学员快速掌握核心技能,在游戏行业的蓝海中找到属于自己的位置。

天津火星时代

天津火星时代
认证 7 年

成立: 2006年

认证 地址认证 教学保障 在线预约 到店体验 售后支持
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-04 00:43:09 HTTP/1.1 GET : http://www.aabqj.com/s/2833/c/93532.html
  2. 运行时间 : 0.057296s [ 吞吐率:17.45req/s ] 内存消耗:400.86kb 文件加载: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.000306s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001017s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '2833' AND `site_id` = 17 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000270s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000617s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 2833 [ RunTime:0.000212s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000594s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 2833 [ RunTime:0.000206s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000665s ]
  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` = 2833 AND `a`.`content_id` = '93532' AND `course_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000646s ]
  10. (select content_id,course_name from fqi_school_course where school_id = '2833' and content_id < '93532' and site_id = '17' order by content_id desc limit 1) union all(select content_id,course_name from fqi_school_course where school_id = '2833' and content_id > '93532' and site_id <= '17' order by content_id asc limit 1) [ RunTime:0.001613s ]
  11. SELECT * FROM `fqi_school_course` WHERE `school_id` = 2833 AND `site_id` = 17 AND `course_status` = 1 AND `school_status` = 1 AND `school_class_id` = 10649 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000369s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 2833 AND `site_id` = 17 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 10 [ RunTime:0.000321s ]
  13. SELECT COUNT(*) AS think_count FROM `fqi_school_course` WHERE `school_id` = 2833 AND `course_status` = 1 [ RunTime:0.000226s ]
  14. SHOW FULL COLUMNS FROM `fqi_school_teacher` [ RunTime:0.000619s ]
  15. SELECT COUNT(*) AS think_count FROM `fqi_school_teacher` WHERE `school_id` = '2833' [ RunTime:0.000222s ]
  16. SHOW FULL COLUMNS FROM `fqi_school_comments` [ RunTime:0.000637s ]
  17. SELECT COUNT(*) AS think_count FROM `fqi_school_comments` WHERE `school_id` = '2833' [ RunTime:0.000239s ]
  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` = '17' AND `b`.`school_status` = '1' AND `course_status` = 1 AND `course_id` < '93532' ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.042914s ]
0.057800s