• 海外教授+海归导师双护航
  • 学习计划+奖学金计划
  • 一生多师模式助力艺术留学之路

400-060-0105

钢琴留学全攻略:技能进阶·院校选择·职业发展一本通

钢琴留学全攻略:技能进阶·院校选择·职业发展一本通

授课机构: 上海美行思远

上课地点: 校区地址

成交/评价:

联系电话: 400-060-0105

钢琴留学全攻略:技能进阶·院校选择·职业发展一本通课程详情

古典钢琴留学:扎实功底与艺术表达的双重考验

上海美行思远教学团队指出,选择古典钢琴方向留学的学生,需明确两个核心能力要求:其一为技术层面的指法掌控,其二为艺术层面的音乐理解。不同于流行钢琴的即兴发挥,古典钢琴对指法精准度要求极高——从巴洛克时期的复调织体到浪漫主义的复杂和声,每个音符的触键力度、延音控制都需要长期训练。以贝多芬《月光奏鸣曲》为例,乐章的三连音需保持均匀的节奏,同时通过触键变化传递出忧郁与希望的情绪对比,这对基本功的要求远超普通练习曲。

除技术外,音乐表达能力是区分普通学习者与专业演奏者的关键。海外院校在 audition(试演)环节,不仅考察音阶琶音的完成度,更关注学生对作品背景的理解。如肖邦的夜曲并非单纯的"夜晚的旋律",而是融合了波兰亡国之痛与浪漫主义的个人抒情,演奏时需通过音色明暗变化、乐句呼吸处理,将这种复杂情感传递给听众。这要求学生在日常练习中,除技术训练外,还需大量阅读音乐史、作曲家传记,建立起对作品的深度认知。

英美钢琴留学:语言门槛与院校选择要点

美国院校:GPA与语言双轨要求

美国多数音乐院校对本科申请者的GPA(平均绩点)最低要求为3.0(满分4.0),部分院校如茱莉亚音乐学院、柯蒂斯音乐学院则需3.2以上。语言方面,托福成绩通常要求不低于79-80分,其中写作单项建议达到20分以上(因部分院校需提交音乐分析小论文);雅思一般要求6.5分,单项不低于6.0。需要注意的是,部分院校接受多邻国(Duolingo)成绩替代,如曼哈顿音乐学院要求总分105+,但具体需以当年官网更新为准。

在院校选择上,除传统的茱莉亚、柯蒂斯外,新英格兰音乐学院的古典钢琴项目以"技术+理论"双强著称,其课程包含19世纪钢琴文献研究与即兴伴奏训练;伊斯曼音乐学院则注重跨学科融合,学生可选修作曲系课程,为未来的演奏-创作双栖发展奠定基础。

英国院校:语言细节与专业特色

英国音乐院校的语言要求更注重单项均衡:雅思总分不低于6.5,单项不低于5.5;托福总分87+,其中听力17、阅读18、口语20、写作17为最低线。如皇家音乐学院(RAM)要求申请者在面试环节用英语阐述选曲动机,因此口语表达的流畅度直接影响录取结果。

专业特色方面,英国皇家北方音乐学院(RNCM)的钢琴系以"历史乐器演奏"为特色,学生可接触18-19世纪的古钢琴、早期三角钢琴,深入研究不同时期的演奏风格;伦敦大学皇家霍洛威学院则与英国爱乐乐团合作紧密,提供大量演出实践机会,适合目标成为职业演奏家的学生。

关联专业延伸:音乐治疗与电影配乐的申请要点

音乐治疗专业:技能与素养的双重考核

音乐治疗是音乐与心理学交叉的新兴领域,其申请要求区别于纯钢琴表演。申请者需掌握至少两种乐器(钢琴、吉他为常见选择)及基础声乐能力,重点考察三方面:

  1. 乐器演奏:需完成1首完整作品(如钢琴的巴赫小前奏曲或吉他的《阿尔罕布拉宫的回忆》片段),展示技术稳定性;
  2. 综合素养:面试中会通过情景模拟(如"如何为自闭症儿童设计音乐互动环节")考察沟通能力、心理学认知及对特殊群体的同理心;
  3. 学术写作:需提交1篇1500-2000字的个人陈述,结合自身经历阐述对音乐治疗的理解(如"钢琴陪伴失智老人的志愿者经历")。

适合人群:对医学辅助领域有兴趣、具备耐心与共情力、擅长跨学科思考的学生。

电影配乐方向:钢琴技能的跨界应用

对于兼具钢琴功底与创作兴趣的学生,电影配乐是值得关注的方向。美国南加州大学电影艺术学院、纽约大学提斯克艺术学院的配乐专业,要求申请者提交:

  • 原创配乐作品(可包含钢琴片段,如为短片《黄昏》创作的钢琴主奏主题曲);
  • 钢琴演奏录像(展示视奏能力,如现场演奏给定的电影场景配乐谱例);
  • 音乐理论测试(涉及和声分析、配器法基础)。

钢琴留学后的职业路径:从演奏家到教育者的多元选择

完成海外钢琴专业学习后,毕业生可选择的职业方向远超传统认知:

职业演奏家:舞台背后的持续精进

以郎朗、李云迪为代表的国际级演奏家,其成功不仅依赖天赋,更需要长期的舞台打磨。多数毕业生会从地方乐团钢琴师、音乐节特邀演奏者起步,通过参加肖邦国际钢琴比赛、范·克莱本国际钢琴比赛等赛事积累知名度。值得注意的是,现代演奏家需具备跨风格演绎能力——既能诠释贝多芬的古典严谨,也能驾驭电影配乐的流行元素,以适应多元化的演出市场。

音乐教育者:技能传承与个性化培养

选择教育方向的毕业生,可进入专业音乐学院(如美国伯克利音乐学院、英国皇家音乐学院)或高端艺术机构任教。教学重点从"技术训练"转向"个性化引导"——针对儿童需设计游戏化练琴方案(如用《小星星变奏曲》讲解变奏概念),针对成人爱好者则侧重音乐表达而非高难度技巧。据统计,欧美音乐院校中70%的钢琴教师拥有海外留学背景,其跨文化教学视野是核心竞争力。

音乐文化推广:跨界融合的新可能

随着音乐与文旅、科技的融合,钢琴专业毕业生还可参与音乐策展(如古典钢琴历史展)、音乐科技产品开发(如智能钢琴教学系统)、音乐IP运营(如某知名钢琴家的周边衍生品设计)等工作。这类岗位要求学生在留学期间主动拓展知识边界,选修艺术管理、数字媒体等课程,提升综合竞争力。

附:经典萨克斯名曲推荐(钢琴学习者拓展曲目参考)

尽管以钢琴为主修,了解其他乐器的经典作品有助于拓宽音乐视野。以下是世界著名的萨克斯名曲,部分作品有钢琴伴奏版本,可作为练习素材:

  • 《伊贝尔-萨克斯协奏曲》:法国作曲家伊贝尔为萨克斯与管弦乐队创作的经典,钢琴伴奏版适合练习连音与音色控制;
  • 《普罗旺斯组画》(Paule Maurice):以法国普罗旺斯地区民歌为灵感,旋律充满田园风情,适合培养音乐画面感;
  • 《克莱斯坦奏鸣曲》:美国作曲家克莱斯坦的代表作,结构严谨,可作为复调思维训练素材;
  • 《德彪西-狂想曲》:印象派大师德彪西的跨界之作,钢琴部分需注重和声色彩的变化;
  • 《丑角》(Milhaud Scaramouche):融合爵士元素的现代作品,适合练习节奏灵活性与即兴处理。

上海美行思远

上海美行思远
认证 7 年

成立: 2006年

认证 地址认证 教学保障 在线预约 到店体验 售后支持
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-06 22:03:31 HTTP/1.1 GET : http://www.eduih.com/s/4542/c/65460.html
  2. 运行时间 : 0.051890s [ 吞吐率:19.27req/s ] 内存消耗:397.61kb 文件加载: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.000414s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001071s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '4542' AND `site_id` = 3 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000275s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000615s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 4542 [ RunTime:0.000229s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000625s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 4542 [ RunTime:0.000233s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000669s ]
  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` = 4542 AND `a`.`content_id` = '65460' AND `course_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000962s ]
  10. (select content_id,course_name from fqi_school_course where school_id = '4542' and content_id < '65460' and site_id = '3' order by content_id desc limit 1) union all(select content_id,course_name from fqi_school_course where school_id = '4542' and content_id > '65460' and site_id <= '3' order by content_id asc limit 1) [ RunTime:0.001053s ]
  11. SELECT * FROM `fqi_school_course` WHERE `school_id` = 4542 AND `site_id` = 3 AND `course_status` = 1 AND `school_status` = 1 AND `school_class_id` = 16564 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000313s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 4542 AND `site_id` = 3 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 10 [ RunTime:0.000824s ]
  13. SELECT COUNT(*) AS think_count FROM `fqi_school_course` WHERE `school_id` = 4542 AND `course_status` = 1 [ RunTime:0.000242s ]
  14. SHOW FULL COLUMNS FROM `fqi_school_teacher` [ RunTime:0.000644s ]
  15. SELECT COUNT(*) AS think_count FROM `fqi_school_teacher` WHERE `school_id` = '4542' [ RunTime:0.000204s ]
  16. SHOW FULL COLUMNS FROM `fqi_school_comments` [ RunTime:0.000611s ]
  17. SELECT COUNT(*) AS think_count FROM `fqi_school_comments` WHERE `school_id` = '4542' [ RunTime:0.000184s ]
  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` = '3' AND `b`.`school_status` = '1' AND `course_status` = 1 AND `course_id` < '65460' ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.039010s ]
0.052213s