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

400-888-4851

游戏3D美术学习全流程解析:从基础软件到次世代制作的核心模块

来源:青岛完美动力教育 时间:02-17

游戏3D美术学习全流程解析:从基础软件到次世代制作的核心模块

游戏3D美术学习全流程:从基础到次世代的技能进阶指南

近年来国内游戏市场规模突破3000亿,3A大作与开放世界游戏层出不穷,对3D美术人才的需求呈现几何级增长。据行业报告显示,具备次世代制作能力的3D美术师平均薪资超15k,但符合企业需求的专业人才仅占从业者总数的23%。想要在这一领域站稳脚跟,必须系统掌握从基础软件到次世代流程的完整技能体系。本文将详细解析游戏3D美术学习的核心模块,帮助学习者明确方向。

一、3D美术基础:软件操作与造型能力培养

3D美术的入门阶段,核心是掌握基础软件工具与造型思维。首先需要攻克的是3ds Max——这款在游戏建模领域应用最广的软件。课程会系统讲解模型制作全流程,从基础命令(如移动、旋转、缩放)到游戏低模的造型规范:包括如何通过合理布线模型可变形性,如何控制面数符合引擎要求。

与3ds Max配套的是Photoshop的贴图绘制训练。学员需要掌握金属、木质、皮革等常见材质的表现技法,例如通过图层混合模式模拟金属的反光质感,用纹理叠加增强皮革的颗粒感。特别强调手写板的使用技巧——这是3D美术师的"画笔",从压感控制到笔触衔接,都需要大量练习来形成肌肉记忆。此阶段的重点不仅是软件操作,更在于培养观察力:学会分析真实物体的光影分布、材质细节,将其转化为数字世界的视觉语言。

二、场景与道具制作:构建游戏世界的基石

游戏场景是玩家的交互空间,其真实性与风格统一性直接影响沉浸感。场景道具制作模块需要掌握三大核心能力:模型搭建、UV拆分与贴图绘制。

模型搭建环节,学员将学习中西方建筑的结构差异(如中式飞檐的榫卯构造vs欧式城堡的石砌工艺),掌握模型比例控制技巧(例如如何通过参考图确定门窗尺寸),同时严格遵循面数限制规则——手机游戏场景道具通常控制在5000面以内,PC端也需控制在2万面以下。UV拆分则需要理解"公共贴图"的概念:通过合理摆放UV坐标,让同一张贴图能重复用于多个部件,既节省内存又视觉统一。

贴图绘制会用到PS与Body Paint 3D,重点训练光影逻辑:比如户外场景的阳光直射区与阴影过渡,室内场景的灯光漫反射效果。学员需要完成从古风客栈到未来科技基地的多风格场景项目,最终输出符合当前游戏主流(如UE5引擎)的高精度手绘场景作品。

三、角色设计:从人体结构到风格化表现

角色是游戏的灵魂,其建模与贴图质量直接决定玩家的情感连接。学习路径从人体解剖开始:需要熟悉骨骼比例(成人头身比7.5-8:1)、肌肉走向(如胸大肌与三角肌的衔接)、面部结构(三庭五眼的黄金比例)。在此基础上,掌握写实与Q版两种主流风格的建模差异——写实角色需要精准还原皮肤纹理,Q版则强调头部放大(头身比可达2-4:1)与表情符号化。

建模过程中,布线规则尤为关键:角色关节处(如肘部、膝盖)需要沿运动方向布线,避免变形时穿模;面部则需在眼周、嘴角增加循环边,表情动画的自然过渡。UV拆分需配合服装结构,例如复杂的铠甲要按甲片分布拆分,确保贴图细节(如金属划痕)能精准对应模型位置。

贴图绘制是角色设计的"最后一公里",需要针对不同材质专项突破:皮肤贴图要表现毛孔、血管等微细节,布料需区分棉麻的粗糙感与丝绸的光泽感,毛发则要通过分层绘制(底层绒毛+外层长毛)模拟真实质感。完成这些训练后,学员将能独立制作从古风侠客到未来机甲战士的全类型角色。

四、Zbrush雕刻:提升模型精度的关键工具

如果说3ds Max是搭建骨架的"建筑师",Zbrush就是赋予模型灵魂的"雕刻家"。这一模块建立在低模布线规范的基础上,重点学习高模雕刻技巧。针对不同物体特性,需要掌握差异化的雕刻策略:软质物体(如布料、皮肤)用平滑笔刷塑造自然褶皱,硬质物体(如金属、石头)用硬边笔刷刻画锐利棱角。

雕刻过程中需要平衡整体与细节:先确定大形(如角色的肌肉走向),再逐步细化(如皮肤的皱纹、铠甲的磨损痕迹)。特别强调"涨力感知"训练——通过观察真实物体受力后的变形(如拉伸的布料、挤压的皮肤),让数字模型更具物理真实感。完成的高模将用于烘焙法线贴图、置换贴图等,为后续次世代流程提供高精度数据支撑。

五、次世代制作:从硬表面到角色的全流程规范

次世代技术(PBR流程)是当前3A游戏的主流制作标准,其核心是通过高精度贴图(如金属度、粗糙度、法线贴图)模拟真实材质。学习分为道具场景与角色两大方向。

硬表面道具(如枪械、战车)制作需要严格遵循行业规范:模型面数控制(PC端约10万面,主机端可达20万面)、拓扑结构(沿物体轮廓卡线变形稳定)、UV拆分(避免重叠与拉伸)。贴图烘焙环节,需掌握Substance Painter的智能材质系统——通过预设参数快速生成锈迹、划痕等细节,同时支持手动绘制提升独特性。

次世代角色制作更强调细节深度:从Zbrush雕刻的高模中提取微细节(如皮肤的汗孔、装备的铆钉),通过烘焙转化为贴图信息;使用Substance Painter的分层绘制功能,叠加皮肤的皮脂层、布料的污渍层等,最终呈现照片级真实效果。完成这一阶段学习后,学员的作品将达到《赛博朋克2077》《艾尔登法环》等3A大作的制作标准。

六、Maya次世代:适配企业需求的技术补充

尽管3ds Max是主流建模工具,但部分游戏公司(尤其是主机游戏厂商)更倾向使用Maya。因此,Maya次世代提升模块重点讲解其独特功能:多边形建模命令(如插入循环边控制模型精度)、UV展开技巧(通过松弛工具优化UV分布)、硬表面卡线方法(利用边权重调整模型轮廓)。

特别值得关注的是Maya的毛发解决方案——通过Hair System与Fur工具,能高效制作角色头发、动物毛发等复杂效果,支持动态模拟与渲染优化。掌握Maya次世代技术后,学员将能无缝对接更多头部游戏公司的制作需求,显著提升竞争力。

总结来看,游戏3D美术学习是一个从基础软件到次世代技术的渐进过程,需要兼顾工具操作、造型能力与行业规范。随着游戏引擎(如UE5)的不断升级,对3D美术师的要求也在持续提升——不仅要会建模贴图,更要理解引擎渲染逻辑,才能制作出符合实时渲染需求的高品质资产。无论是想入行还是进阶的学习者,都需要围绕这些核心模块系统学习,才能在游戏美术领域占据一席之地。

基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-03 19:41:43 HTTP/1.1 GET : http://www.aabrd.com/s/3278/n/20107.html
  2. 运行时间 : 0.016474s [ 吞吐率:60.70req/s ] 内存消耗:403.59kb 文件加载: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.000376s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001040s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '3278' AND `site_id` = 19 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000327s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000566s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 3278 [ RunTime:0.000241s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000591s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 3278 [ RunTime:0.000254s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000643s ]
  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` = 3278 AND `a`.`content_id` = '20107' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.001225s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '3278' and content_id < '20107' 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 = '3278' and content_id > '20107' and site_id <= '19' order by content_id asc limit 1) [ RunTime:0.000753s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000737s ]
  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 4 [ RunTime:0.000284s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 3278 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000207s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 3278 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000157s ]
  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` < 20107 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.005354s ]
0.016779s