• 以企业直接需求为出发点,为企业提供覆盖产业洞察等多层次的咨询
  • 制定多种企业综合解决方案等咨询产品
  • 为企业实现显著的业绩提升和更具吸引力的杰出人才搭建保驾护航

400-888-4851

长沙国富如荷教育CDA数据挖掘工程师周末班:转岗/提升的系统学习路径解析

长沙国富如荷教育CDA数据挖掘工程师周末班:转岗/提升的系统学习路径解析

授课机构: 长沙国富如荷教育

上课地点: 校区地址

成交/评价:

联系电话: 400-888-4851

长沙国富如荷教育CDA数据挖掘工程师周末班:转岗/提升的系统学习路径解析课程详情

数据挖掘岗位人才需求下的学习新选择

数据挖掘作为数字经济时代的核心技能,正成为企业运营、产品优化、营销决策的关键支撑。越来越多从业者希望通过系统学习掌握这一技术,实现职业升级或转岗。长沙国富如荷教育推出的CDA数据挖掘工程师周末班,正是为满足这一需求而设计的针对性课程——无论是转岗数据挖掘工程师、机器学习工程师,还是希望提升技能的在职者,都能在这里找到适配的学习路径。

课程定位与核心设计逻辑

该课程以"岗位需求导向+认证考试适配"为双核心,专门面向希望转岗数据挖掘相关岗位的学员。目标岗位覆盖数据挖掘工程师、机器学习工程师、算法工程师、商业策略数据分析师等热门方向。课程设计遵循"基础-进阶-实战"的递进逻辑:从Python编程基础、数据清洗等工具技能入手,逐步过渡到统计分析方法、机器学习模型构建,最终通过行业实战项目串联知识体系,确保学员既能掌握理论考点,又能具备解决实际业务问题的能力。

值得强调的是,课程内容深度融合了CDA LEVEL II和CDA LEVEL III等级考试的所有考点。对于备考学员而言,这意味着学习过程本身就是高效的备考过程——每一个知识点的讲解都围绕考试要求展开,同时结合实际案例加深理解,避免了"为考试而学习"的割裂感。

明确的三大学习目标

通过系统学习,学员将达成三方面核心能力提升:

其一,熟练掌握数据挖掘全流程的Python实操。从数据清洗算法的选择与应用,到特征工程的关键步骤;从数据建模的模型调优,到数据可视化的结果呈现,每个环节都设置了针对性训练,确保学员能独立完成从原始数据到分析报告的全流程操作。

其二,深度理解Python数据挖掘算法与实践。课程不仅涵盖统计分析、统计模型等基础算法,还深入讲解机器学习、深度学习、文本挖掘等前沿算法。通过"原理讲解+代码演示+案例复现"的三重教学模式,帮助学员突破"知其然不知其所以然"的瓶颈。

其三,灵活运用数据挖掘算法解决行业问题。课程特别设置"行业业务问题拆解"模块,针对运营优化、产品迭代、精准营销等实际场景,引导学员通过策略优化和精准预测提出解决方案。例如,在电商行业案例中,学员将学习如何通过用户行为数据挖掘提升转化率;在金融行业案例中,如何通过风险数据建模降低坏账率。

适配多元需求的学习人群

课程设置充分考虑了不同学员的背景差异,以下几类人群尤为适合:

- 有数学/统计/计算机基础或数据分析经验,计划脱产学习后转岗数据挖掘岗的求职者。课程提供从工具到算法的完整知识链,帮助补齐岗位所需的核心技能缺口。

- 希望提升数据挖掘技术的在职从业者。课程内容紧密结合实际工作场景,例如针对运营岗位的学员,会重点讲解用户分群、营销效果预测等实用技能;针对产品岗位的学员,会强化用户行为分析、功能优化建模等内容。

- 从事算法科学、深度学习等工作的科研人员与工程师。课程不仅覆盖基础算法,还包含数据治理、业务策略优化等工程实践内容,帮助科研成果更好地落地应用。

- 产品、运营、营销等岗位从业者。课程特别设计"数据分析思维培养"环节,帮助非技术背景学员掌握用数据驱动决策的能力,例如如何通过用户画像数据优化产品功能,如何通过销售数据制定营销活动策略等。

- 备考CDA LEVEL II/LEVEL III的考生。课程内容与考试大纲高度匹配,授课教师会结合历年考题解析考点,同时通过模拟实操提升应试能力。

系统化课程内容详解

课程共设置六大核心章节,内容覆盖工具使用、理论基础、实战应用等多个维度,具体如下:

章 工具先导课:Python基础与数据清洗

作为数据挖掘的入门工具,Python的重要性不言而喻。本章节从Python基础语法开始,讲解标准数据类型、控制流语句、自定义函数等核心内容,同时重点训练数据清洗技能——这是实际工作中最常见的环节,约70%的数据挖掘项目需要先完成数据清洗。通过大量案例练习,学员将掌握缺失值处理、异常值检测、数据标准化等关键方法。

第二章 数字化工作保障机制:数据治理

数据治理是确保数据质量的核心环节。本章节深入讲解数据治理的驱动因素(如业务需求变化、合规要求等)、数据治理域(元数据管理、主数据管理等)、数据管理域(数据安全、数据生命周期管理等)及数据应用域(数据共享、数据服务等),并通过企业真实案例演示"如何开展数据治理",帮助学员理解数据治理与数据挖掘的协同关系。

第三章 数字化工作方法:EDIT模型应用

EDIT数字化模型是解决业务问题的系统方法。本章节分步骤讲解业务探查(E)、问题诊断(D)、业务策略优化(I)、算法工具介绍(T)的具体操作流程。例如,在业务探查环节,学员将学习如何通过数据采集和初步分析定位业务痛点;在问题诊断环节,如何通过统计方法验证假设;在策略优化环节,如何结合业务目标设计解决方案。

第四章 数据采集与模型管理

数据采集是数据挖掘的起点。本章节详细介绍结构化数据、非结构化数据的采集方法,包括数据库查询、API接口调用、网络爬虫(合规范围内)等技术。同时讲解数据模型管理的核心要点,如模型版本控制、模型性能评估等,确保学员能建立规范的数据采集与管理流程。

第五章 Python编程进阶:从基础到数据库操作

在完成基础语法学习后,本章节进一步深化Python编程能力。内容涵盖异常处理、类与面向对象编程等高级语法,重点讲解Python与数据库的连接操作(如MySQL、MongoDB)。通过实际项目练习,学员将掌握从数据库提取数据、处理数据到存储分析结果的全流程操作,为后续的大规模数据挖掘奠定基础。

第六章 Python数据探索、处理与可视化

数据探索与可视化是呈现分析结果的关键。本章节以Numpy和Pandas为工具,讲解数组操作、数据表处理、数据探索(如描述性统计、相关性分析)等技能,同时深入学习Matplotlib和Seaborn两大可视化库的使用。学员将学会根据分析目的选择合适的图表类型(如折线图展示趋势、热力图展示相关性),并掌握图表美化技巧,确析结果清晰易懂。

学习保障:全程督学与实战支持

区别于传统网课的"自学模式",CDA数据挖掘工程师周末班采用"授课教师全程督学"机制。从课程预习到作业批改,从阶段测试到项目答疑,教师团队将全程跟踪学习进度,及时解决学员遇到的技术问题。此外,课程设置多场直播答疑和习题串讲,针对高频问题进行集中讲解,确保知识点无遗漏。

在实战支持方面,课程引入多个行业真实项目案例,包括电商用户行为分析、金融风险建模、教育行业精准营销等。学员将以"项目组成员"的身份参与数据挖掘全流程,从需求分析到模型部署,切实提升解决实际问题的能力。这些实战经验不仅能丰富简历内容,更能帮助学员快速适应岗位要求。

长沙国富如荷教育

长沙国富如荷教育
认证 7 年

成立: 2006年

认证 地址认证 教学保障 在线预约 到店体验 售后支持
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-04 04:45:43 HTTP/1.1 GET : http://www.aabrd.com/s/6344/c/88313.html
  2. 运行时间 : 0.053448s [ 吞吐率:18.71req/s ] 内存消耗:402.47kb 文件加载: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.000256s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.000849s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '6344' AND `site_id` = 19 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000246s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000588s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 6344 [ RunTime:0.000264s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000648s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 6344 [ RunTime:0.000210s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000660s ]
  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` = 6344 AND `a`.`content_id` = '88313' AND `course_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000350s ]
  10. (select content_id,course_name from fqi_school_course where school_id = '6344' and content_id < '88313' and site_id = '19' order by content_id desc limit 1) union all(select content_id,course_name from fqi_school_course where school_id = '6344' and content_id > '88313' and site_id <= '19' order by content_id asc limit 1) [ RunTime:0.001368s ]
  11. SELECT * FROM `fqi_school_course` WHERE `school_id` = 6344 AND `site_id` = 19 AND `course_status` = 1 AND `school_status` = 1 AND `school_class_id` = 21589 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000328s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 6344 AND `site_id` = 19 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 10 [ RunTime:0.000303s ]
  13. SELECT COUNT(*) AS think_count FROM `fqi_school_course` WHERE `school_id` = 6344 AND `course_status` = 1 [ RunTime:0.000198s ]
  14. SHOW FULL COLUMNS FROM `fqi_school_teacher` [ RunTime:0.000674s ]
  15. SELECT COUNT(*) AS think_count FROM `fqi_school_teacher` WHERE `school_id` = '6344' [ RunTime:0.000195s ]
  16. SHOW FULL COLUMNS FROM `fqi_school_comments` [ RunTime:0.000577s ]
  17. SELECT COUNT(*) AS think_count FROM `fqi_school_comments` WHERE `school_id` = '6344' [ RunTime:0.000202s ]
  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` = '19' AND `b`.`school_status` = '1' AND `course_status` = 1 AND `course_id` < '88313' ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.041391s ]
0.053757s