• 拥有一支经验丰富、技艺精湛的教师团队
  • 教学针对性强,坚持小班教学
  • 致力于帮助学生提高设计技能和应试能力

400-666-4820

天津PS美工培训全解析:从0基础到实战接单的系统学习路径

天津PS美工培训全解析:从0基础到实战接单的系统学习路径

授课机构: 天津四方设计软件学院

上课地点: 校区地址

成交/评价:

联系电话: 400-666-4820

天津PS美工培训全解析:从0基础到实战接单的系统学习路径课程详情

天津PS美工培训:从技能入门到商业实战的系统成长方案

为什么选择四方设计软件学院PS美工培训班?

在天津,想找一门能快速转化为职业竞争力的技能,PS美工无疑是热门选择。四方设计软件学院的PS美工培训班之所以被众多学员推荐,关键在于其“实战导向+分层教学”的特色。这里的讲师团队均拥有5年以上商业设计经验,曾服务过电商、广告、新媒体等多个领域,熟悉行业最新需求——从淘宝店铺的产品精修到品牌海报的创意合成,从网页界面的视觉设计到动态图标的基础制作,讲师们不仅能讲透工具原理,更会结合真实商业案例拆解操作技巧。

不同于传统课堂的“填鸭式”教学,这里采用“理论讲解+机房实操+案例复盘”的三段式教学模式。每周3次固定实操课,讲师全程巡回指导,从钢笔工具的精准抠图到图层混合模式的灵活运用,从色彩平衡的参数调整到智能滤镜的批量处理,每个操作细节都会被反复打磨。学员完成的作业不仅会得到针对性点评,优秀作品更有机会被推荐至合作企业,成为求职时的加分项。

这门课适合哪些人学?

无论你是完全没接触过PS的“小白”,还是有一定基础但想提升商业应用能力的职场人,都能在这个课程中找到对应的学习路径。具体来说,以下几类人群尤其适合:

  • 0基础转行人群:想从传统行业转向设计领域,但缺乏系统学习渠道,希望通过3-4个月的集中学习掌握核心技能,快速进入美工、平面设计等岗位;
  • 职场技能提升者:现有工作需要用到PS(如电商运营、新媒体小编),但只会基础操作,想学习人像精修、产品调色等进阶技巧,提升工作效率和成果质量;
  • 兼职接单爱好者:希望利用业余时间通过PS技能接单(如修图、做海报、设计图标),需要掌握从需求沟通到作品交付的全流程能力,积累作品集;
  • 兴趣提升人群:对图片处理、设计创作有兴趣,想深入了解PS的底层逻辑,从“会用工具”到“能用工具创作”,满足个人或家庭的设计需求。

9大核心模块,覆盖PS美工全场景应用

课程内容围绕商业设计的实际需求展开,从基础原理到高阶技巧,从单一工具使用到综合项目实战,确保学员学完后能独立完成各类设计任务。具体模块如下:

模块一:PS核心工具与原理

重点讲解调色原理、图层/通道/蒙版的底层逻辑,以及滤镜的灵活应用。例如,通过对比“曲线调色”和“色阶调色”的差异,结合人像、产品、风景等不同类型图片,掌握根据需求选择调色工具的方法;通过分析通道的明暗关系,学习复杂背景下的精准抠图技巧(如毛发、玻璃、烟雾等)。

模块二:图形处理与素材制作

从基础的图形描图、抠图到复杂的图片合成、场景美化,覆盖电商、广告等常见场景。例如,学习如何将多个素材(产品图、背景图、文字)合成一张协调的海报,重点掌握色彩平衡调整、光影统一、元素比例等关键细节;通过实际案例学习素材的二次创作(如将普通风景图处理成插画风格)。

模块三:流行色调与调色技巧

针对当下主流的设计风格(如ins风、复古风、赛博朋克风),讲解不同色调的调色思路和参数设置。例如,ins风的“低饱和度+高亮度”调色方法,复古风的“暖黄滤镜+颗粒感”处理技巧,通过实际图片练习掌握“一键调色”到“精准微调”的过渡。

模块四:广告人像精修与插件应用

从基础的磨皮、祛痘到高阶的面部结构调整、光影优化,结合商业人像的常见需求(如证件照、写真、广告图),学习不同修图风格的处理方法。同时,系统讲解主流修图插件(如Portraiture、Topaz Mask AI)的使用技巧,提升修图效率。

模块五:淘宝商品精修与调色

针对电商行业的核心需求,讲解不同品类商品的精修要点(如服装的褶皱处理、珠宝的反光优化、食品的质感增强),以及如何根据店铺风格调整产品色调(如日系小清新、欧美简约风)。课程会提供真实的淘宝商品原图,学员需完成从“原图→精修图→详情页切片”的全流程操作。

模块六:海报合成与创意设计

从创意思路的梳理到素材的筛选与合成,学习如何将品牌理念、产品卖点转化为视觉语言。例如,为一款新咖啡产品设计海报,需要考虑目标人群(年轻人)、核心卖点(现磨新鲜),通过色彩(暖黄/卡其)、元素(咖啡杯、咖啡豆、蒸汽)的组合传递“温暖”“新鲜”的感觉。课程会通过分组实战,模拟真实设计提案流程。

模块七:网页界面设计与切片导出

掌握网页界面的编排布局原则(如信息层级、视觉动线),学习如何设计符合用户体验的PC端和移动端界面。课程会讲解“切片工具”的使用技巧,确保设计稿能准确还原为前端代码,同时兼顾加载速度和视觉效果。

模块八:UI图标设计与动态效果

从扁平图标到拟物图标,学习形状层的运用、图层样式的设置(如投影、斜面和浮雕),以及如何通过增加细节(如光影、材质)提升图标的拟真效果。此外,还会讲解简单的GIF动画制作方法(如图标微动画、加载动效),拓展设计的动态表现能力。

模块九:自动化处理与综合应用

学习如何利用PS的自动化功能(如动作录制、批处理)提升工作效率,理解智能对象和智能滤镜的优势(可编辑、不破坏原数据)。课程最后会设置综合项目,要求学员独立完成“广告调色+人像精修+海报合成+网页界面布局+UI图标设计”的全流程任务,检验学习成果。

学完这门课,你能达到什么水平?

通过3-4个月的系统学习,学员将具备以下核心能力:

  1. 掌握PS做图的底层逻辑,能根据设计需求灵活组合工具(如用通道抠图+图层蒙版调整+曲线调色完成一张产品精修图);
  2. 胜任美工助理岗位,能独立完成广告人像精修、淘宝商品精修、海报合成、网页界面设计等常见任务;
  3. 具备商业设计思维,能从用户需求出发优化设计方案(如根据目标人群调整海报色调、根据产品特性选择修图风格);
  4. 积累完整的作品集(包含10-15个商业级案例),为求职或兼职接单提供有力支撑。

值得一提的是,四方设计软件学院与多家本地广告公司、电商企业建立了合作关系,优秀学员可获得实习机会,部分表现突出者更能直接推荐,真正实现“学习-实践-”的闭环。

关于课程的常见问题解答

Q:0基础能学会吗?

完全可以。课程采用“从0到1”的渐进式教学,前2周会重点夯实基础(如界面认识、工具使用、基础操作),配合大量练习和讲师辅导,确保0基础学员也能跟上进度。

Q:课程有实操机会吗?

每周3次机房实操课,讲师全程指导;课后布置针对性作业(如一张人像精修、一组图标设计),并提供详细批改反馈;结课前的综合项目要求独立完成商业级设计任务,全面检验实操能力。

Q:学完能兼职接单吗?

可以。课程会讲解接单流程(需求沟通、报价、交付)和注意事项(版权问题、修改次数),并提供合作平台资源。部分学员在学习期间就能通过完成讲师推荐的小单积累经验和收入。

天津四方设计软件学院

天津四方设计软件学院
认证 7 年

成立: 2006年

认证 地址认证 教学保障 在线预约 到店体验 售后支持
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-05-02 08:32:08 HTTP/1.1 GET : http://www.eduej.com/s/7687/c/102196.html
  2. 运行时间 : 0.029804s [ 吞吐率:33.55req/s ] 内存消耗:403.77kb 文件加载: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.000393s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001002s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '7687' AND `site_id` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000235s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000592s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 7687 [ RunTime:0.000171s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000641s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 7687 [ RunTime:0.000186s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000650s ]
  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` = 7687 AND `a`.`content_id` = '102196' AND `course_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000898s ]
  10. (select content_id,course_name from fqi_school_course where school_id = '7687' and content_id < '102196' and site_id = '1' order by content_id desc limit 1) union all(select content_id,course_name from fqi_school_course where school_id = '7687' and content_id > '102196' and site_id <= '1' order by content_id asc limit 1) [ RunTime:0.001162s ]
  11. SELECT * FROM `fqi_school_course` WHERE `school_id` = 7687 AND `site_id` = 1 AND `course_status` = 1 AND `school_status` = 1 AND `school_class_id` = 24778 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000296s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 7687 AND `site_id` = 1 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 10 [ RunTime:0.000265s ]
  13. SELECT COUNT(*) AS think_count FROM `fqi_school_course` WHERE `school_id` = 7687 AND `course_status` = 1 [ RunTime:0.000159s ]
  14. SHOW FULL COLUMNS FROM `fqi_school_teacher` [ RunTime:0.000631s ]
  15. SELECT COUNT(*) AS think_count FROM `fqi_school_teacher` WHERE `school_id` = '7687' [ RunTime:0.000170s ]
  16. SHOW FULL COLUMNS FROM `fqi_school_comments` [ RunTime:0.000577s ]
  17. SELECT COUNT(*) AS think_count FROM `fqi_school_comments` WHERE `school_id` = '7687' [ RunTime:0.000181s ]
  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` = '1' AND `b`.`school_status` = '1' AND `course_status` = 1 AND `course_id` < '102196' ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.017870s ]
0.030116s