• 脚踏实地做教育,一丝不苟为服务;
  • 培养具有全球视野,知行合一的实干家.
  • 用真诚去回报学员,提供专业、贴心、有价值的服务;

400-888-4011

量化金融分析师AQF全解析:认证体系、课程架构与师资力量深度解读

量化金融分析师AQF全解析:认证体系、课程架构与师资力量深度解读

授课机构: 金程教育

上课地点: 校区地址

成交/评价:

联系电话: 400-888-4011

量化金融分析师AQF全解析:认证体系、课程架构与师资力量深度解读课程详情

量化金融分析师AQF:量化金融领域的专业能力标尺

一、AQF认证的权威背景与机构架构

量化金融分析师(Analyst of Quantitative Finance,简称AQF)是量化金融领域具有专业代表性的水平认证,其认证体系由量化金融专业委员会(Standard Committee of Quantitative Finance,SCQF)主导设计并组织考核颁证。这一认证的权威性不仅源于其严谨的考核标准,更依托于背后强大的学术支持与行业资源。

提及AQF的认证体系,就不得不了解其核心管理机构——中国市场学会量化金融专业委员会(以下简称“量专委”)。作为中国市场学会下属的独立二级机构,量专委自成立以来始终以“金融服务市场、市场促进金融”为目标,通过组织金融理论与实践研究、开展学术交流、整合专家资源等方式,为金融领域提供调研、培训、咨询、认证等多元化服务。其核心职能包括推动金融服务学术水平提升、加强金融实践沟通与技术交流、搭建金融高级人才培养平台,这些都为AQF认证的专业性和实用性奠定了坚实基础。

在量专委的组织架构中,量化金融标准委员会(SCQF)承担着具体的认证执行工作。该委员会在量专委专家委员会的指导下,负责AQF证书体系的专业水平认证、能力建设开发、研究咨询、教育培训及教材修订等核心任务,确保认证内容与行业发展同步,与实践需求匹配。

二、哪些人适合报考AQF?职业发展的适配人群分析

AQF认证的培养目标是为量化金融领域输送专业型人才,其课程内容与考核标准紧密贴合行业实际需求,因此适合的人群具有明确的职业指向性。具体而言,以下几类从业者或准从业者可重点关注:

1. 投资顾问与理财规划师:随着金融市场的复杂化,传统的定性分析已难以满足客户需求,掌握量化分析工具的投资顾问能更精准地构建投资组合,提升服务专业性。

2. 量化投资工程师:作为量化策略的执行者,需要系统掌握量化交易的底层逻辑与技术实现,AQF课程中的编程知识与策略开发模块能有效提升其技术能力。

3. 量化策略研究分析师:策略研发是量化投资的核心环节,AQF覆盖的主流交易策略解析与实盘模拟训练,能为策略研究提供方法论支持。

4. 行业研究中的量化分析人员:无论是金融行业还是实体产业的研究团队,量化分析能力已成为基础技能,AQF的知识体系能帮助其建立更严谨的分析框架。

简言之,任何希望在金融分析、投资决策中融入量化思维,或从事与量化投资直接相关工作的人员,都可通过AQF认证系统提升专业能力。

三、AQF核心课程体系:从基础到实战的完整知识链条

AQF课程设计以“主流交易策略学习”为核心,通过七大模块构建起从理论到实践的完整知识体系。这种模块化的设计既了知识的系统性,又兼顾了学习的渐进性,具体模块内容如下:

模块一:前导课程与体系介绍

作为入门环节,本模块重点梳理量化金融的发展脉络、AQF认证的核心价值及学习路径规划。通过案例分析帮助学员建立对量化投资的直观认知,明确学习目标。

模块二:量化投资基础

系统讲解量化投资的基本概念、常用模型(如CAPM、套利定价模型)及市场数据处理方法。这一模块为后续学习奠定理论基础,重点培养学员的量化思维模式。

模块三:Python编程知识

Python作为量化交易的主流编程语言,其编程能力是量化从业者的核心技能。本模块从基础语法入手,逐步讲解数据爬取、清洗、可视化及策略回测的编程实现,强调“学中用、用中学”。

模块四:量化交易策略解析

聚焦趋势跟踪、套利、高频交易等主流策略,通过历史数据回测与案例拆解,分析不同策略的适用场景、风险特征及优化方法,帮助学员掌握策略开发的核心逻辑。

模块五:面向对象与实盘交易

引入面向对象编程思想,讲解如何将策略逻辑封装为可复用的交易系统。同时结合实盘交易规则(如手续费、滑点计算),提升策略的实际落地能力。

模块六:实盘模拟交易

通过模拟交易平台,学员可将前序学习的策略投入模拟实战,体验完整的交易流程。课程设置实时反馈与策略优化指导,帮助学员积累实战经验。

模块七:基于优矿的进阶学习

优矿(Uqer)作为专业的量化研究平台,本模块将引导学员利用其强大的数据资源与计算能力,进行更复杂的策略开发与优化,接触行业前沿的量化技术。

相较于市面同类课程,AQF的优势在于体系的完整性——从理论到编程、从策略到实战环环相扣;内容的实用性——所有知识点均围绕行业实际需求设计;衔接的合理性——模块间难度递增,避免学习断层。

四、授课师资:金融实战与教学经验兼备的专业团队

AQF课程的教学质量,很大程度上得益于其强大的师资团队。授课教师不仅具备深厚的学术背景,更拥有丰富的金融行业实战经验,能够将理论知识与实践案例深度融合,以下为部分核心师资介绍:

纪老师 | 金程教育培训师

作为金程教育Excel金融建模、量化投资(AQF)课程开发负责人,纪老师在金融领域拥有多年从业经验,曾先后任职于中国建设银行、中信证券等头部机构,对企业IPO、投资理财、量化投资等领域有深入研究。

教学方面,纪老师累计授课超5000课时,教学满意度达9.8分(满分10分),其课程以“逻辑清晰、案例生动”著称。学术成果上,参与编写金程CFA系列参考书,包括翻译CFA协会官方教材《企业理财》《国际财务报告分析》及金程CFA中文Notes等,理论功底扎实。

授课领域覆盖CFA、FRM、ACCA、ChFP、银行从业、中级经济师、CFRM等,跨领域的教学经验使其能从更宏观的视角解析量化金融的应用价值。

盹师 | 金程教育培训师

盹师拥有中国人民大学信息学院工学硕士、财政金融学院经济学博士双重学历背景,同时持有CPA,通过CFA三级、FRM二级考试,学术背景扎实。

职业经历涵盖基金公司、金融培训机构、证券公司及金融监管机构:曾在某知名基金公司数量投资部担任研究员,负责股指期货对冲套利策略研究;在金融培训机构主导CFA培训计划与课件开发,主讲股票投资、固定收益等核心课程;在证券公司投行部参与企业上市项目,负责财务审核与分析;现任职于金融监管机构,从事金融市场研究工作。

这种跨机构、多角色的职业经历,使盹师的课程既包含实战操作细节,又能从监管视角解析行业规则,为学员提供更全面的知识输入。

两位老师仅是AQF师资团队的缩影,整个团队汇聚了高校学者、金融机构从业者及专业培训师,确保学员能接触到最前沿的行业动态与最实用的操作技巧。

结语:AQF认证的价值与职业发展前景

在金融科技快速发展的今天,量化分析已从“新兴工具”逐步演变为金融从业者的“必备技能”。AQF认证通过权威的知识体系、实战导向的课程设计及专业的师资团队,为从业者提供了系统提升量化能力的路径。无论是希望进入量化金融领域的新人,还是寻求职业进阶的从业者,AQF认证都能成为其职业发展的重要助力。

未来,随着金融市场的进一步复杂化与数字化,量化分析的应用场景将持续拓展,掌握AQF认证所涵盖的知识与技能,无疑能让从业者在竞争中占据更有利的位置。

金程教育

金程教育
认证 7 年

成立: 2006年

认证 地址认证 教学保障 在线预约 到店体验 售后支持
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-03 17:06:15 HTTP/1.1 GET : http://www.aabqt.com/s/1030/c/44755.html
  2. 运行时间 : 0.040339s [ 吞吐率:24.79req/s ] 内存消耗:392.92kb 文件加载: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.000282s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.000842s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '1030' AND `site_id` = 16 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000247s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000529s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 1030 [ RunTime:0.000223s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000612s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 1030 [ RunTime:0.000227s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000664s ]
  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` = 1030 AND `a`.`content_id` = '44755' AND `course_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000732s ]
  10. (select content_id,course_name from fqi_school_course where school_id = '1030' and content_id < '44755' and site_id = '16' order by content_id desc limit 1) union all(select content_id,course_name from fqi_school_course where school_id = '1030' and content_id > '44755' and site_id <= '16' order by content_id asc limit 1) [ RunTime:0.000946s ]
  11. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1030 AND `site_id` = 16 AND `course_status` = 1 AND `school_status` = 1 AND `school_class_id` = 4166 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000407s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1030 AND `site_id` = 16 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 10 [ RunTime:0.000267s ]
  13. SELECT COUNT(*) AS think_count FROM `fqi_school_course` WHERE `school_id` = 1030 AND `course_status` = 1 [ RunTime:0.000170s ]
  14. SHOW FULL COLUMNS FROM `fqi_school_teacher` [ RunTime:0.000629s ]
  15. SELECT COUNT(*) AS think_count FROM `fqi_school_teacher` WHERE `school_id` = '1030' [ RunTime:0.000186s ]
  16. SHOW FULL COLUMNS FROM `fqi_school_comments` [ RunTime:0.000602s ]
  17. SELECT COUNT(*) AS think_count FROM `fqi_school_comments` WHERE `school_id` = '1030' [ RunTime:0.000200s ]
  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` = '16' AND `b`.`school_status` = '1' AND `course_status` = 1 AND `course_id` < '44755' ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.028858s ]
0.040633s