• 我们引入西方先进的艺术教学体系课程及教学理念
  • 校内拥有企业的核心团队均来自于全球TOP5艺术院校的导师
  • 我们力争成为国际艺术教育的领跑者。

400-882-6911

城市设计专业留学全解析:课程体系·方向·教研实力深度解读

城市设计专业留学全解析:课程体系·方向·教研实力深度解读

授课机构: 上海品思国际艺术教育

上课地点: 校区地址

成交/评价:

联系电话: 400-882-6911

城市设计专业留学全解析:课程体系·方向·教研实力深度解读课程详情

城市设计留学的核心价值与学习定位

在全球城市化进程加速的今天,城市设计作为协调城市功能与空间美学的关键学科,正受到越来越多留学生的关注。区别于传统建筑设计的单一维度,城市设计更强调对城市整体形态、公共空间、人文脉络的系统性把控——这既是其学科魅力所在,也是海外学习的核心价值。对于选择上海品思国际艺术教育强化班的学员而言,课程不仅聚焦设计技能提升,更注重培养"从宏观规划到微观落地"的全局思维,帮助学员建立国际视野下的城市设计方法论。

需要明确的是,城市设计与城市规划存在显著差异。城市规划更侧重政策性与数据化分析,涉及土地利用、人口分布、基础设施布局等宏观决策;而城市设计则以具体图形化表达为核心,关注城市天际线、街道尺度、公共空间体验等具象要素。举个简单例子:当城市规划确定某区域为"文化休闲区"后,城市设计师需要进一步思考——怎样的建筑高度能形成舒适的空间围合?步行道宽度与绿化比例如何搭配更符合人体工学?这些细节正是城市设计的价值所在。

上海品思国际艺术教育强化班课程体系详解

作为针对城市设计学员的专项课程,上海品思国际艺术教育强化班采用自主研发的教材体系,将理论教学与实践项目深度融合。课程内容覆盖从基础认知到高阶设计的完整链条,具体可分为三大模块:

1. 基础理论与历史脉络

包含"中外城市建设史""城市地理学""城市生态学"等科目。以"中外城市建设史"为例,课程不仅梳理从古希腊城邦到现代智慧城市的发展历程,更通过对比北京胡同、威尼斯水巷、纽约高线公园等经典案例,解析不同文化背景下城市空间的生成逻辑。"城市生态学"则聚焦生态因子与城市形态的关系,教授学员如何通过风环境模拟、热岛效应分析等技术手段优化城市设计方案。

2. 核心设计技能培养

这一模块以"城市规划设计""城市详细规划""计算机辅助制图"为核心。其中"城市规划设计"课程设置多阶段实践任务:从1:5000尺度的区域规划,到1:1000的街区设计,再到1:200的节点深化,逐步提升学员的尺度转换能力。"计算机辅助制图"则重点训练SketchUp、Rhino、GIS等专业软件的综合应用,要求学员能通过三维建模直观呈现设计方案的空间效果。

3. 综合素养与行业对接

包含"政策分析""城市经济学""社会学"等科目。"政策分析"课程会系统解读《城乡规划法》《历史文化名城保护条例》等核心法规,帮助学员理解设计方案的合规性边界;"城市经济学"则引入开发成本测算、土地价值评估等内容,让设计方案更具落地可行性。值得一提的是,课程还设置"行业导师工作坊",定期邀请海外知名事务所设计师分享实际项目经验,缩短学习与的衔接周期。

城市设计留学的前景与职业路径

完成城市设计留学后,学员的方向呈现多元化特征,主要集中在以下三大领域:

1. 与公共机构

各级自然资源部门、城乡规划局、历史文化名城保护中心等单位,是城市设计专业人才的重要方向。主要承担城市总体规划编制、历史街区保护方案设计、重大项目规划论证等工作。具备海外留学背景的从业者,在参与国际合作项目(如"一带一路"城市建设)时更具竞争优势。

2. 设计企业与咨询机构

国内头部设计企业(如华建集团、同济设计)、国际事务所(如SOM、Gensler)的城市设计部门,以及房地产咨询公司(如戴德梁行、太平戴维斯)的规划顾问岗位,均对海外城市设计人才有持续需求。以某TOP5设计企业为例,其城市设计团队中海外背景成员占比达40%,主要负责高端商业综合体、文旅小镇等复杂项目的整体设计。

3. 学术研究与教育领域

选择继续攻读博士学位的学员,可进入高校或科研院所从事城市设计理论研究、教学工作。近年来,随着"智慧城市""韧性城市"等新兴方向的兴起,具备跨学科背景(如结合大数据、人工智能)的留学人才,在学术领域的发展空间愈发广阔。

值得注意的是,同时具备城市设计与建筑设计双背景的从业者,在市场中更受青睐。这类复合型人才既能完成城市层面的整体设计,又能把控建筑单体的细节处理,尤其在城市更新、老旧小区改造等综合性项目中优势显著。

上海品思国际艺术教育教研团队实力揭秘

课程质量的核心保障,在于教研团队的专业实力。上海品思国际艺术教育的城市设计教研团队,由三部分核心成员构成:

1. 海外名校归国导师

团队中60%的导师拥有哈佛GSD、MIT建筑系、 UCL巴特莱特建筑学院等全球院校的硕士/博士学位,部分成员曾参与纽约下东城改造、新加坡滨海湾规划等国际知名项目。他们不仅能传授前沿的设计理念,更能结合自身留学经历,为学员提供选校建议、作品集指导等个性化支持。

2. 一线设计师驻校讲师

团队与SOM、AECOM等国际事务所建立长期合作,定期邀请在职设计师担任驻校讲师。这些讲师会将实际项目中的难点(如历史建筑保护与商业开发的平衡、高密度城区的交通优化)带入课堂,通过"真题实做"的方式,培养学员解决复杂问题的能力。

3. 理论研究型学术顾问

团队聘请国内高校城市设计领域的教授作为学术顾问,负责课程体系的顶层设计与理论框架搭建。例如在"城市公共空间设计"模块,学术顾问会引入"场所精神""空间句法"等理论,帮助学员理解设计背后的学术逻辑,避免陷入"为设计而设计"的误区。

正是这种"理论+实践+国际视野"的复合型教研结构,确保了上海品思国际艺术教育强化班的教学质量。据往届学员反馈,通过系统学习,90%以上的学员能显著提升方案的逻辑性与创新性,在留学申请和竞争中更具优势。

总结:选择城市设计留学的关键考量

城市设计留学不仅是专业技能的提升,更是思维模式的重塑。在选择课程时,除了关注教材体系与师资力量,还需重点考察三点:一是课程是否包含真实项目实践(这直接影响竞争力);二是是否有海外院校合作资源(能为留学申请提供便利);三是是否注重跨学科能力培养(如与景观设计、环境工程的融合)。上海品思国际艺术教育强化班在这些方面均有突出表现,是城市设计留学学员的优质选择。

无论你是希望进入设计企业,还是从事学术研究,扎实的城市设计功底与国际视野都是核心竞争力。通过系统的课程学习与实践训练,相信每一位学员都能在城市设计领域找到属于自己的发展路径。

上海品思国际艺术教育

上海品思国际艺术教育
认证 7 年

成立: 2006年

认证 地址认证 教学保障 在线预约 到店体验 售后支持
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-04 22:53:21 HTTP/1.1 GET : http://www.edubq.com/s/1828/c/27206.html
  2. 运行时间 : 0.044846s [ 吞吐率:22.30req/s ] 内存消耗:394.52kb 文件加载: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.000331s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.000968s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '1828' AND `site_id` = 5 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000249s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000576s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 1828 [ RunTime:0.000196s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000593s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 1828 [ RunTime:0.000208s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000658s ]
  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` = 1828 AND `a`.`content_id` = '27206' AND `course_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000394s ]
  10. (select content_id,course_name from fqi_school_course where school_id = '1828' and content_id < '27206' and site_id = '5' order by content_id desc limit 1) union all(select content_id,course_name from fqi_school_course where school_id = '1828' and content_id > '27206' and site_id <= '5' order by content_id asc limit 1) [ RunTime:0.000694s ]
  11. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1828 AND `site_id` = 5 AND `course_status` = 1 AND `school_status` = 1 AND `school_class_id` = 7338 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000279s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1828 AND `site_id` = 5 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 10 [ RunTime:0.000236s ]
  13. SELECT COUNT(*) AS think_count FROM `fqi_school_course` WHERE `school_id` = 1828 AND `course_status` = 1 [ RunTime:0.000160s ]
  14. SHOW FULL COLUMNS FROM `fqi_school_teacher` [ RunTime:0.000612s ]
  15. SELECT COUNT(*) AS think_count FROM `fqi_school_teacher` WHERE `school_id` = '1828' [ RunTime:0.000192s ]
  16. SHOW FULL COLUMNS FROM `fqi_school_comments` [ RunTime:0.000574s ]
  17. SELECT COUNT(*) AS think_count FROM `fqi_school_comments` WHERE `school_id` = '1828' [ RunTime:0.000192s ]
  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` = '5' AND `b`.`school_status` = '1' AND `course_status` = 1 AND `course_id` < '27206' ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.034092s ]
0.045152s