• 从咨询到签订合同再到申请,金吉列为客户提供了完整、清晰的服务
  • 从申请、培训和服务体系上也是比较完善和成熟的留学机构
  • 根据客户具体情况定制个性化方案,帮助客户申请到理想的留学项目

400-689-2779

美国博士留学全流程攻略:从规划到入学的关键步骤与选校策略

美国博士留学全流程攻略:从规划到入学的关键步骤与选校策略

授课机构: 北京金吉列留学

上课地点: 校区地址

成交/评价:

联系电话: 400-689-2779

美国博士留学全流程攻略:从规划到入学的关键步骤与选校策略课程详情

美国博士留学全流程攻略:从规划到入学的关键步骤与选校策略

美国博士申请全阶段时间轴:分年级规划要点

申请美国博士是一场需要长期筹备的“马拉松”,不同阶段的核心任务差异显著。以北京金吉列留学多年服务经验来看,科学的时间规划能大幅提升录取成功率,以下按年级拆解关键动作——

大一大二/研一:科研基础与认知储备期

此阶段重点在于“打地基”:首先需稳定GPA成绩,美国院校博士项目对本科/硕士阶段均分普遍要求3.5+(满分4.0),需尽早关注核心专业课学习;其次要建立申博认知,通过学术讲座、导师交流或留学机构的免费咨询,了解博士培养模式、奖学金类型(如Fellowship、TA/RA)及目标国家政策;最后启动标化考试准备,GRE(部分理工科可免)、TOEFL/IELTS需明确目标分数(如TOP50院校通常要求托福100+),建议先完成词汇积累与基础题型训练。

大三/研二:冲刺准备与精准定位期

进入关键筹备阶段,首要任务是考出理想标化成绩——建议在大三上学期前完成首次考试,留出2-3次刷分时间;其次是院校与导师筛选,需结合自身研究方向(如计算机选AI/算法方向)、成绩匹配度(参考学校官网近年录取数据)及导师活跃度(通过Google Scholar查看近3年论文发表量);同步启动文书准备,包括个人陈述(需突出研究兴趣与过往科研经历)、推荐信(优先选择有海外背景或与目标导师有合作的教授),其中套辞信撰写尤为关键——需深度阅读目标教授近2年论文,提炼研究方向契合点,避免模板化内容。

大四上/研三上:材料提交与状态跟踪期

此阶段需完成“最后一公里”冲刺:10-12月集中提交网申(注意各校截止日期差异,部分TOP院校12月初截止),同步寄送纸质材料(如成绩单、学位证明)及GT成绩(通过ETS官方送分);提交后需定期查看申请系统状态,若材料缺失及时补寄;1-3月是面试高峰期,需针对导师研究方向准备常见问题(如“你的研究如何补充课题组现有成果?”),可通过模拟面试提升临场反应;同时保持与导师的邮件沟通,适当分享新发表的论文或研究进展。

大四下/研三下:结果确认与行前准备期

收到offer后需在规定时间内确认就读(通常4月15日前),同步启动奖学金协商(若未获得全额资助,可邮件询问是否有补录机会);签证准备需提前2个月预约面签,材料包括I-20表、录取信、资金证明(覆盖年学费+生活费)及研究计划;行前需完成体检(部分学校要求)、购买保险(美国强制要求)、预定机票与住宿(建议通过学校推荐的住宿平台),同时加入新生群了解当地生活注意事项。

美国博士选专业与院校:5大核心决策逻辑

与本科、硕士申请不同,博士阶段的“匹配度”远重于“排名”。北京金吉列留学结合数千案例总结,以下5大逻辑需重点关注——

1. 个人成绩:划定申请范围的“硬指标”

美国高校博士项目对成绩要求因专业而异:理工科更看重GPA(尤其是专业课)与GRE Sub(如物理、化学),文科则关注GPA+论文发表+语言成绩(托福105+常见)。建议通过学校官网“Admissions”页面查询近3年录取数据(部分院校会公布均分范围),同时参考Niche、Payscale等第三方平台的学生反馈,避免盲目冲刺“高不可攀”的目标。

2. 套辞效果:决定奖学金的“隐形门槛”

套辞信是与导师建立联系的关键工具,其核心不是“自我推销”,而是“研究共鸣”。建议申请者先通过Google Scholar下载目标教授近5年的3-5篇代表作,重点阅读引言与结论部分,提炼其研究瓶颈或未解决的问题;在套辞信中可写:“阅读您2022年发表于《Nature》的论文《XX研究》,发现当前对XX机制的探讨存在数据量限制,而我在硕士阶段参与的XX项目恰好运用了XX方法,或许能为课题组提供新视角。”此类具体表述能显著提升回复率,而获得导师明确“感兴趣”的回复后,录取概率可提升60%以上。

3. 学校规模:影响留任机会的“潜在因素”

美国博士毕业后,约40%的学生会选择留校担任助理教授(数据来源:美国大学教授协会2023报告)。一般来说,综合型大学(如加州大学系统)规模大、课题组多,对科研人员的需求更旺盛;而小型文理学院(如威廉姆斯学院)虽学术精尖,但教职岗位有限。若未来计划留在学术界,建议优先考虑学生人数超2万、年科研经费超5亿美元的院校,这类学校的“内部消化”能力更强。

4. 导师名气>专业排名:决定学术资源的“核心变量”

美国学术界的“圈层效应”显著——期刊审稿、国际会议发言等机会往往掌握在“领域大牛”手中。例如,计算机视觉领域的Yann LeCun(图灵奖得主)虽在纽约大学(综合排名30+),但其课题组的毕业生几乎全部进入MIT、斯坦福等院校任教。因此,与其执着于“专业排名前10”,不如重点关注导师的H指数(≥30为优质)、近年是否担任会议(如CVPR、NeurIPS)程序委员会成员,以及是否有工业界合作(能带来实际项目资源)。

5. 专业排名>综合排名:聚焦学术深度的“理性选择”

若目标是学术科研,专业排名比综合排名更具参考价值。例如,卡内基梅隆大学(CMU)综合排名约25,但计算机科学专业连续20年全美;德州农工大学(TAMU)综合排名60+,但其石油工程专业全球。建议通过U.S. News专业排名、QS学科排名交叉验证,优先选择在目标领域有5个以上“特色实验室”(如MIT的CSAIL实验室)的院校。

北京金吉列留学:全周期博士申请服务体系

针对美国博士申请的复杂性,北京金吉列留学构建了覆盖“规划-提升-申请-入学”的全周期服务,帮助申请者规避信息差、提升竞争力——

1. 定制化留学申请规划

根据学生的专业背景(如本科数学跨申生物信息学)、科研经历(是否有论文/专利)及目标院校(冲刺TOP30/稳妥TOP50),制定个性化时间规划表。例如,为GPA 3.2的学生设计“大三上学期选修2门高学分专业课+参与教授课题组”的提升方案,同步规划GRE首考时间(建议大三寒假前完成)。

2. 背景实力深度提升

针对科研背景薄弱的学生,提供“学术项目定制”服务:与海外高校合作开设远程科研课题(如“机器学习在医疗影像中的应用”),由常春藤教授指导,结项可获得推荐信;同时规划国际会议投稿(如IEEE、AAAI),提升学术履历的“含金量”。

3. 精准化选校策略制定

采用“冲刺-匹配-保底”三级选校法:冲刺校选择专业排名前10且导师研究方向高度契合的院校(约3所);匹配校为专业排名10-20且录取率15%-25%的院校(约5所);保底校选择专业排名20-30但地理位置优越(如加州、纽约)的院校(约2所)。所有选校均通过内部数据库(包含10万+录取案例)验证可行性。

4. 全流程申请与面试指导

文书团队由前招生官与海外博士组成,针对不同院校风格调整内容(如MIT偏好技术细节,哈佛更看重研究意义);面试环节提供“1对1模拟+逐句反馈”,覆盖技术问题(如“请解释你的论文方法论”)与行为问题(如“为什么选择我们课题组”),帮助学生熟悉导师提问逻辑,提升临场表现。

注:本文内容基于北京金吉列留学美国博士申请服务经验整理,具体规划需结合个人背景调整,建议通过官方渠道获取最新院校政策。

北京金吉列留学

北京金吉列留学
认证 7 年

成立: 2006年

认证 地址认证 教学保障 在线预约 到店体验 售后支持
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-04 19:28:16 HTTP/1.1 GET : http://www.aabqy.com/s/6935/c/94806.html
  2. 运行时间 : 0.069304s [ 吞吐率:14.43req/s ] 内存消耗:404.38kb 文件加载: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.000326s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001079s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '6935' AND `site_id` = 23 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000302s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000631s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 6935 [ RunTime:0.000283s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000618s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 6935 [ RunTime:0.000258s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000770s ]
  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` = 6935 AND `a`.`content_id` = '94806' AND `course_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000357s ]
  10. (select content_id,course_name from fqi_school_course where school_id = '6935' and content_id < '94806' and site_id = '23' order by content_id desc limit 1) union all(select content_id,course_name from fqi_school_course where school_id = '6935' and content_id > '94806' and site_id <= '23' order by content_id asc limit 1) [ RunTime:0.000871s ]
  11. SELECT * FROM `fqi_school_course` WHERE `school_id` = 6935 AND `site_id` = 23 AND `course_status` = 1 AND `school_status` = 1 AND `school_class_id` = 22938 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000352s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 6935 AND `site_id` = 23 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 10 [ RunTime:0.000281s ]
  13. SELECT COUNT(*) AS think_count FROM `fqi_school_course` WHERE `school_id` = 6935 AND `course_status` = 1 [ RunTime:0.000194s ]
  14. SHOW FULL COLUMNS FROM `fqi_school_teacher` [ RunTime:0.000685s ]
  15. SELECT COUNT(*) AS think_count FROM `fqi_school_teacher` WHERE `school_id` = '6935' [ 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` = '6935' [ RunTime:0.000198s ]
  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` = '23' AND `b`.`school_status` = '1' AND `course_status` = 1 AND `course_id` < '94806' ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.056596s ]
0.069650s