为什么mysql索引使用B+Tree数据结构

请求信息 : 2025-07-03 21:05:36 HTTP/2.0 GET : /home/article/detail/id/273810.html
运行时间 : 0.0844s ( Load:0.0353s Init:0.0024s Exec:0.0421s Template:0.0046s )
吞吐率 : 11.85req/s
内存开销 : 1,623.41 kb
查询信息 : 12 queries 0 writes
文件加载 : 18
缓存信息 : 5 gets 0 writes
配置加载 : 132
会话信息 : SESSION_ID=0btackid2uv39stlnl2n7bg0ir

/www/wwwroot/www.chaojiit.com/index.php ( 1.30 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/ThinkPHP.php ( 4.71 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Think.class.php ( 12.32 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Storage.class.php ( 1.38 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Storage/Driver/File.class.php ( 3.56 KB )
/www/wwwroot/www.chaojiit.com/Application/Runtime/common~runtime.php ( 76.63 KB )
/www/wwwroot/www.chaojiit.com/Application/Home/Conf/config.php ( 0.05 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Behavior/ReadHtmlCacheBehavior.class.php ( 5.62 KB )
/www/wwwroot/www.chaojiit.com/Application/Home/Controller/ArticleController.class.php ( 6.10 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Model.class.php ( 67.27 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Db.class.php ( 5.70 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Db/Driver/Mysql.class.php ( 8.73 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Db/Driver.class.php ( 41.60 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Cache.class.php ( 3.84 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Cache/Driver/File.class.php ( 5.90 KB )
/www/wwwroot/www.chaojiit.com/Application/Runtime/Cache/Home/3c8a1a47a3534a7b1252c226abfc3928.php ( 15.77 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Behavior/WriteHtmlCacheBehavior.class.php ( 1.43 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Behavior/ShowPageTraceBehavior.class.php ( 5.27 KB )

[2] session_save_path(): open_basedir restriction in effect. File(/var/lib/php/session) is not within the allowed path(s): (/www/wwwroot/www.chaojiit.com/:/tmp/) /www/wwwroot/www.chaojiit.com/Application/Runtime/common~runtime.php 第 1 行.
[8192] Array and string offset access syntax with curly braces is deprecated /www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Cache/Driver/File.class.php 第 59 行.
[8] Undefined variable: user /www/wwwroot/www.chaojiit.com/Application/Runtime/Cache/Home/3c8a1a47a3534a7b1252c226abfc3928.php 第 35 行.
[8] Undefined variable: user /www/wwwroot/www.chaojiit.com/Application/Runtime/Cache/Home/3c8a1a47a3534a7b1252c226abfc3928.php 第 140 行.
[8] Trying to access array offset on value of type null /www/wwwroot/www.chaojiit.com/Application/Runtime/Cache/Home/3c8a1a47a3534a7b1252c226abfc3928.php 第 140 行.
[8] Undefined variable: user /www/wwwroot/www.chaojiit.com/Application/Runtime/Cache/Home/3c8a1a47a3534a7b1252c226abfc3928.php 第 141 行.
[8] Trying to access array offset on value of type null /www/wwwroot/www.chaojiit.com/Application/Runtime/Cache/Home/3c8a1a47a3534a7b1252c226abfc3928.php 第 141 行.
[8] Undefined variable: pinglun_list /www/wwwroot/www.chaojiit.com/Application/Runtime/Cache/Home/3c8a1a47a3534a7b1252c226abfc3928.php 第 150 行.
[8] Undefined variable: top_list /www/wwwroot/www.chaojiit.com/Application/Runtime/Cache/Home/3c8a1a47a3534a7b1252c226abfc3928.php 第 185 行.

SELECT `value` FROM `configuration` WHERE `name` = 'site_name' LIMIT 1 [ RunTime:0.0005s ]
SELECT * FROM `menu` WHERE `fid` = 0 AND `status` = 1 [ RunTime:0.0006s ]
SELECT * FROM `menu` WHERE `fid` = 1 AND `status` = 1 [ RunTime:0.0008s ]
SELECT * FROM `menu` WHERE `fid` = 2 AND `status` = 1 [ RunTime:0.0013s ]
SELECT * FROM `menu` WHERE `fid` = 3 AND `status` = 1 [ RunTime:0.0006s ]
SELECT * FROM `menu` WHERE `fid` = 4 AND `status` = 1 [ RunTime:0.0005s ]
SELECT * FROM `article` WHERE `id` = 273810 LIMIT 1 [ RunTime:0.0007s ]
SELECT * FROM `bloger` WHERE `id` = 271 LIMIT 1 [ RunTime:0.0021s ]
SELECT COUNT(*) AS tp_count FROM `article` WHERE `bloger_id` = 271 LIMIT 1 [ RunTime:0.0008s ]
SELECT `content` FROM `article_content` WHERE `article_id` = 273810 LIMIT 1 [ RunTime:0.0009s ]
SELECT `name` FROM `article_cate` WHERE `id` = 259 LIMIT 1 [ RunTime:0.0007s ]
SELECT * FROM `article` WHERE `bloger_id` = 271 ORDER BY view_count desc LIMIT 0,10 [ RunTime:0.0048s ]

为什么mysql索引使用B+Tree数据结构

最近更新

热门博客

[ 申请 ]友情链接：