• 为员工创造价值,为客户创造价值;
  • 为推动全社会进步而努力;
  • 成为中国的企业IT人才培养解决方案提供商.

400-689-2779

MongoDB数据库管理全流程实战指南:从架构解析到集群运维的系统学习路径

MongoDB数据库管理全流程实战指南:从架构解析到集群运维的系统学习路径

授课机构: 南京柯普瑞IT学校

上课地点: 校区地址

成交/评价:

联系电话: 400-689-2779

MongoDB数据库管理全流程实战指南:从架构解析到集群运维的系统学习路径课程详情

一、MongoDB体系结构深度解析

要掌握MongoDB数据库管理,首先需理解其底层架构逻辑。MongoDB作为面向文档的NoSQL数据库,其设计初衷是解决传统关系型数据库在扩展性和非结构化数据处理上的局限。核心特性包括灵活的文档存储(BSON格式)、自动分片支持、复制集高可用机制等,这些特性使其在大数据场景、实时应用中表现突出。

从进程结构来看,MongoDB生态包含三个关键组件:负责路由请求的mongos路由进程、存储实际数据的mongod数据节点,以及管理分片元数据的config server配置服务器。三者协同工作,支撑起单机部署到分布式集群的不同场景。而目录与文件结构方面,数据文件(*.ns、*.0-*.n)、日志文件(mongod.log)、配置文件(mongod.conf)的存储路径与命名规则,直接关系到故障排查和性能调优效率——例如数据文件默认存储在/data/db目录,日志文件默认输出到/var/log/mongodb,这些基础路径是运维人员必须牢记的关键信息。

二、MongoDB Shell操作与基础管理

MongoDB Shell(mongo.exe)是数据库管理的核心工具,它不仅支持JavaScript语法交互,还能直接执行数据库操作命令。学习Shell的步是熟悉其数据类型——除了基础的字符串、数值、布尔值,还需掌握BSON特有的ObjectId(文档唯一标识)、Date(日期类型)、内嵌文档(Nested Document)等,这些是构建合理数据模型的基础。

CRUD操作(增删改查)是日常管理的高频场景。例如插入文档时,需注意write concern参数对写入确认级别的影响;查询操作中,投影(Projection)的合理使用能显著减少网络传输数据量;更新操作需掌握$set、$inc等修改器的差异;删除操作则必须谨慎,避免误删关键数据。此外,系统命令如show dbs(查看数据库)、db.stats()(获取数据库统计信息)、explain()(分析查询计划),都是诊断数据库状态的实用工具。

三、单服务器部署与配置规范

单节点部署是MongoDB应用的基础场景,其配置质量直接影响后续扩展能力。配置文件(mongod.conf)作为核心管理入口,需重点关注storage.engine(存储引擎,默认WiredTiger)、net.port(服务端口)、systemLog.path(日志路径)、setParameter(参数调优)等字段。例如,WiredTiger引擎的cacheSizeGB参数建议设置为系统内存的50%,既能缓存效率,又能避免与操作系统内存冲突。

数据文件分配方面,MongoDB采用预分配机制(初始16MB,后续倍增),这虽能减少文件碎片,但也可能导致磁盘空间骤增。运维人员需根据业务数据增长速率,提前规划磁盘容量并设置合理的预分配策略。日志文件作为故障排查的关键依据,需定期归档(可通过logRotate工具实现),避免日志过大影响服务性能。硬件与文件系统建议上,推荐使用SSD磁盘提升IO性能,文件系统选择ext4或XFS(避免使用NFS),并禁用atime属性减少磁盘IO消耗。

四、MongoDB安全配置与实践

数据库安全是企业数据管理的底线。MongoDB内置认证机制支持两种模式:SCRAM-SHA-1(默认)和x.509证书认证。前者通过用户名密码验证,适用于大多数业务场景;后者通过SSL证书实现双向认证,安全性更高,适合金融、医疗等敏感行业。启用认证后,需为不同角色(如read、readWrite、dbAdmin)分配权限,避免权限过度开放。

安全部署建议包括:禁用默认27017端口的公网暴露,通过NAT或VPC限制访问源;开启SSL/TLS加密传输,防止网络嗅探;定期审计用户权限(使用db.getUsers()命令),清理冗余账号;对敏感数据(如用户密码)采用应用层加密(如AES-256),避免数据库层面明文存储。此外,配置防火墙策略(如iptables或云厂商安全组),仅允许业务服务器访问MongoDB端口,是防御外部攻击的重要手段。

五、性能监控与故障诊断

MongoDB的性能监控需从多维度展开。mongostat工具可实时查看QPS(查询每秒)、插入/更新速率、锁等待时间等关键指标;mongotop则用于统计集合级别的读写耗时,帮助定位热点数据。内存与IO性能分析方面,需关注WiredTiger缓存命中率(理想值>95%)、磁盘IOPS(建议SSD达到2000+)、内存交换(swap使用应接近0),任何异常都可能导致性能骤降。

与第三方工具集成时,Munin适合基础指标的图形化展示,Cacti支持自定义阈值告警,Nagios则擅长复杂故障的自动化处理。MongoDB自带的网络控制台(通过--httpinterface参数启用)可提供JSON格式的状态报告,方便与监控系统对接。实际运维中,建议搭建“基础监控(mongostat)+ 深度分析(explain)+ 告警通知(Nagios)”的三层监控体系,确保问题早发现、早处理。

六、索引优化与查询性能调优

索引是提升查询性能的核心手段。MongoDB支持单一索引(基于单个字段)、复合索引(多个字段组合)、地理空间索引(处理经纬度数据)等类型。管理索引时,需注意索引的维护成本——每个索引都会增加写入开销,因此需根据查询模式(读多写少/写多读少)选择必要索引。例如,对订单表的“用户ID+下单时间”查询,创建复合索引{userId:1, orderTime:-1}比单独创建两个单一索引更高效。

识别次优查询可通过explain()命令的executionStats模式,重点关注executionTimeMillis(执行时间)、docsExamined(扫描文档数)、nReturned(返回文档数)等指标。若docsExamined远大于nReturned,说明存在全表扫描,需添加合适索引。此外,避免在索引字段使用正则表达式(如^前缀匹配除外)、否定查询($ne)等操作,这些会导致索引失效,严重影响性能。

七、驱动程序开发与连接管理

应用程序通过驱动程序(如Java的MongoDB Java Driver、Python的pymongo)与MongoDB通信。驱动的核心职责是将应用代码转换为MongoDB有线协议(基于BSON的二进制协议),并处理连接池管理、故障转移(如复制集节点切换)等逻辑。理解驱动与Shell的通信差异(Shell本质是JavaScript驱动的交互式实现),有助于定位应用层面的连接问题。

BSON作为MongoDB的文档存储格式,支持比JSON更丰富的数据类型(如Date、Binary),驱动会自动完成编程语言数据类型与BSON的转换。连接故障排查时,常见问题包括连接池耗尽(可通过设置maxPoolSize参数调整)、DNS解析失败(建议使用IP直连避免缓存问题)、认证超时(检查用户名密码及权限)。此外,驱动版本需与MongoDB服务端版本兼容(如4.4版本服务端建议使用4.x系列驱动),否则可能出现功能不匹配或性能问题。

八、高可用与可伸缩性架构设计

MongoDB的高可用通过复制集(Replica Set)实现,其核心机制是主节点(Primary)处理所有写操作,从节点(Secondary)通过oplog同步数据。当主节点故障时,剩余节点通过选举产生新主,实现自动故障转移。复制集至少需要3个节点(2个从节点+1个仲裁节点),以避免脑裂(Split Brain)问题。

写关注点(Write Concern)用于控制写操作的确认级别,常见选项包括{w:1}(主节点确认)、{w:"majority"}(多数节点确认)。选择更高的写关注点可提升数据耐久性,但会增加写入延迟,需根据业务需求(如金融交易要求强一致性,日志记录可接受最终一致性)权衡。处理复制失败时,需检查网络延迟(建议节点间RTT<20ms)、磁盘IO性能(从节点同步延迟可能由慢盘导致)、oplog大小(默认30天,可调整以适应大事务场景)。

自动分片(Sharding)是MongoDB横向扩展的核心技术,通过将数据按分片键(Shard Key)分散到多个分片集群(Shard Cluster),实现存储和查询的水平扩展。分片键的选择直接影响数据分布均衡性——理想的分片键应具备高基数(避免热点)和随机分布(如UUID),而时间戳(如orderTime)可能导致新数据集中在单个分片,引发写入热点。

分片集群的拓扑结构需结合复制集使用(每个分片本身是一个复制集),以同时实现高可用和可伸缩性。管理分片集群时,需关注块迁移(Chunk Migration)过程——当某个分片的块(Chunk,默认64MB)数据量超过阈值,mongos会自动将块迁移到其他分片。迁移过程可能影响查询性能,建议在业务低峰期执行手动平衡(使用sh.startBalancer()命令)。

九、备份与恢复策略设计

数据备份是容灾体系的最后一道防线。基于文件系统的备份策略适用于单节点或复制集场景,通过直接复制数据文件(需先执行db.fsyncLock()锁定写操作)实现,但缺点是备份时间长且影响业务。mongodump/mongorestore工具则通过逻辑备份(导出BSON文件)和恢复,支持选择性备份(如单个数据库/集合),适合增量备份场景。

rsync工具可用于复制集节点间的文件同步,配合cron定时任务实现近实时备份,但需注意文件锁问题(建议在从节点执行)。对于分片集群,需分别备份每个分片的复制集节点,恢复时按顺序导入分片数据并重建元数据。无论采用哪种备份方式,都应定期验证恢复流程(如每月一次全量恢复测试),确保备份数据的可用性。

南京柯普瑞IT学校

南京柯普瑞IT学校
认证 7 年

成立: 2006年

认证 地址认证 教学保障 在线预约 到店体验 售后支持
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-04 18:22:29 HTTP/1.1 GET : http://www.aabqy.com/s/1037/c/43856.html
  2. 运行时间 : 0.072355s [ 吞吐率:13.82req/s ] 内存消耗:405.85kb 文件加载: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.000323s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001044s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '1037' AND `site_id` = 23 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000271s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000708s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 1037 [ RunTime:0.000239s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000738s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 1037 [ RunTime:0.000289s ]
  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` = 1037 AND `a`.`content_id` = '43856' 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 = '1037' and content_id < '43856' 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 = '1037' and content_id > '43856' and site_id <= '23' order by content_id asc limit 1) [ RunTime:0.001518s ]
  11. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1037 AND `site_id` = 23 AND `course_status` = 1 AND `school_status` = 1 AND `school_class_id` = 4197 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000427s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1037 AND `site_id` = 23 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 10 [ RunTime:0.000960s ]
  13. SELECT COUNT(*) AS think_count FROM `fqi_school_course` WHERE `school_id` = 1037 AND `course_status` = 1 [ RunTime:0.000311s ]
  14. SHOW FULL COLUMNS FROM `fqi_school_teacher` [ RunTime:0.000675s ]
  15. SELECT COUNT(*) AS think_count FROM `fqi_school_teacher` WHERE `school_id` = '1037' [ RunTime:0.000232s ]
  16. SHOW FULL COLUMNS FROM `fqi_school_comments` [ RunTime:0.000600s ]
  17. SELECT COUNT(*) AS think_count FROM `fqi_school_comments` WHERE `school_id` = '1037' [ RunTime:0.000195s ]
  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` < '43856' ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.057667s ]
0.072708s