基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-11-10 19:38:38 HTTP/2.0 GET : https://www.1004619.com/tag/%E5%8D%97%E6%B4%BE%E4%B8%83%E5%8F%94/page-3
- 运行时间 : 2.449171s [ 吞吐率:0.41req/s ] 内存消耗:555.50kb 文件加载:279
- 查询信息 : 60 queries
- 缓存信息 : 1 reads,0 writes
- 会话信息 : SESSION_ID=9084974dc66ee3bf84b8678aeef14747
- CONNECT:[ UseTime:0.019523s ] mysql:host=127.0.0.1;port=3306;dbname=jsbaike_com;charset=utf8mb4
- SHOW FULL COLUMNS FROM `tp_domain` [ RunTime:0.006694s ]
- SELECT * FROM `tp_domain` WHERE `channel_subdomain` = 1 [ RunTime:0.005042s ]
- SELECT `domain` FROM `tp_domain` [ RunTime:0.006487s ]
- SELECT * FROM `tp_domain` WHERE `domain` = '1004619.com' LIMIT 1 [ RunTime:0.004238s ]
- SELECT * FROM `tp_domain` WHERE `domain` = '1004619.com' LIMIT 1 [ RunTime:0.011995s ]
- SHOW FULL COLUMNS FROM `tp_page` [ RunTime:0.024789s ]
- SELECT * FROM `tp_page` WHERE `domain_id` IN (0,30) AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.013494s ]
- SELECT * FROM `tp_domain` WHERE `domain` = '1004619.com' LIMIT 1 [ RunTime:0.007724s ]
- SHOW FULL COLUMNS FROM `tp_tag` [ RunTime:0.006727s ]
- SELECT * FROM `tp_tag` WHERE `slug` = '南派七叔' AND `status` = 1 AND `domain_id` = 30 LIMIT 1 [ RunTime:0.007384s ]
- SELECT * FROM `tp_tag` WHERE `slug` = '南派七叔' AND `status` = 1 AND `domain_id` = 0 LIMIT 1 [ RunTime:0.003571s ]
- SHOW FULL COLUMNS FROM `tp_tag_course` [ RunTime:0.013463s ]
- SELECT p.tag_id, COUNT(DISTINCT p.course_id) AS n FROM `tp_tag_course` `p` INNER JOIN `tp_course` `c` ON `c`.`id`=`p`.`course_id` WHERE `p`.`tag_id` = '19863' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') GROUP BY `p`.`tag_id` [ RunTime:0.007285s ]
- SHOW FULL COLUMNS FROM `tp_tag_blog` [ RunTime:0.003617s ]
- SELECT p.tag_id, COUNT(DISTINCT p.blog_id) AS n FROM `tp_tag_blog` `p` INNER JOIN `tp_blog` `c` ON `c`.`id`=`p`.`blog_id` WHERE `p`.`tag_id` = '19863' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') GROUP BY `p`.`tag_id` [ RunTime:0.007935s ]
- SHOW FULL COLUMNS FROM `tp_tag_book` [ RunTime:0.010091s ]
- SELECT p.tag_id, COUNT(DISTINCT p.book_id) AS n FROM `tp_tag_book` `p` INNER JOIN `tp_book` `c` ON `c`.`id`=`p`.`book_id` WHERE `p`.`tag_id` = '19863' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') GROUP BY `p`.`tag_id` [ RunTime:0.009339s ]
- SHOW FULL COLUMNS FROM `tp_tag_resource` [ RunTime:0.004557s ]
- SELECT p.tag_id, COUNT(DISTINCT p.resource_id) AS n FROM `tp_tag_resource` `p` INNER JOIN `tp_resource` `c` ON `c`.`id`=`p`.`resource_id` WHERE `p`.`tag_id` = '19863' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') GROUP BY `p`.`tag_id` [ RunTime:0.008609s ]
- SHOW FULL COLUMNS FROM `tp_course` [ RunTime:0.002417s ]
- SELECT `c`.`id`,`c`.`title`,`c`.`subtitle`,`c`.`thumb`,`c`.`path`,`c`.`price`,`c`.`hits`,`c`.`addtime`,`cat`.`cate_path` FROM `tp_course` `c` INNER JOIN `tp_tag_course` `tc` ON `tc`.`course_id`=`c`.`id` LEFT JOIN `tp_category` `cat` ON `cat`.`cate_id`=`c`.`cate_id` WHERE `tc`.`tag_id` = '19863' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') [ RunTime:0.020000s ]
- SHOW FULL COLUMNS FROM `tp_blog` [ RunTime:0.002962s ]
- SELECT `b`.`id`,`b`.`title`,`b`.`slug`,`b`.`summary`,`b`.`thumb`,`b`.`author`,`b`.`hits`,`b`.`created_at`,bc.cate_path as cate_slug FROM `tp_blog` `b` INNER JOIN `tp_tag_blog` `tb` ON `tb`.`blog_id`=`b`.`id` LEFT JOIN `tp_category` `bc` ON `bc`.`cate_id`=`b`.`cate_id` WHERE `tb`.`tag_id` = '19863' AND `b`.`status` = '1' AND `b`.`domain_id` IN ('0','30') [ RunTime:0.008627s ]
- SHOW FULL COLUMNS FROM `tp_book` [ RunTime:0.017208s ]
- SELECT `bk`.`id`,`bk`.`title`,`bk`.`description`,`bk`.`thumb`,`bk`.`price`,`bk`.`hits`,`bk`.`addtime` FROM `tp_book` `bk` INNER JOIN `tp_tag_book` `tb` ON `tb`.`book_id`=`bk`.`id` WHERE `tb`.`tag_id` = '19863' AND `bk`.`status` = '1' AND `bk`.`domain_id` IN ('0','30') [ RunTime:0.005012s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 47630 LIMIT 1 [ RunTime:0.010368s ]
- SHOW FULL COLUMNS FROM `tp_category` [ RunTime:0.004033s ]
- SELECT `cate_path` FROM `tp_category` WHERE `cate_id` = 1 LIMIT 1 [ RunTime:0.004230s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 48672 LIMIT 1 [ RunTime:0.007994s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 52016 LIMIT 1 [ RunTime:0.005162s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 52684 LIMIT 1 [ RunTime:0.007199s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 65857 LIMIT 1 [ RunTime:0.001553s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 67310 LIMIT 1 [ RunTime:0.002927s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 67486 LIMIT 1 [ RunTime:0.001930s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 67488 LIMIT 1 [ RunTime:0.008798s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 68557 LIMIT 1 [ RunTime:0.002630s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 68889 LIMIT 1 [ RunTime:0.006261s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 69399 LIMIT 1 [ RunTime:0.004972s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 76686 LIMIT 1 [ RunTime:0.003286s ]
- SELECT `cate_path` FROM `tp_category` WHERE `cate_id` = 4 LIMIT 1 [ RunTime:0.002385s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 76697 LIMIT 1 [ RunTime:0.003262s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 76922 LIMIT 1 [ RunTime:0.006060s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 77724 LIMIT 1 [ RunTime:0.003101s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 77725 LIMIT 1 [ RunTime:0.002627s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 83285 LIMIT 1 [ RunTime:0.003277s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 87786 LIMIT 1 [ RunTime:0.007159s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 102403 LIMIT 1 [ RunTime:0.001819s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 102694 LIMIT 1 [ RunTime:0.002535s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 102696 LIMIT 1 [ RunTime:0.009860s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 104703 LIMIT 1 [ RunTime:0.005540s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 106533 LIMIT 1 [ RunTime:0.001528s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 106628 LIMIT 1 [ RunTime:0.001666s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 107278 LIMIT 1 [ RunTime:0.003919s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 107955 LIMIT 1 [ RunTime:0.008098s ]
- SHOW FULL COLUMNS FROM `tp_resource` [ RunTime:0.005793s ]
- SELECT `r`.`id`,`r`.`title`,`r`.`description`,`r`.`file_format`,`r`.`downloads`,`r`.`created_at`,`r`.`cate_id` FROM `tp_resource` `r` INNER JOIN `tp_tag_resource` `tr` ON `tr`.`resource_id`=`r`.`id` WHERE `tr`.`tag_id` = '19863' AND `r`.`status` = '1' AND `r`.`domain_id` IN ('0','30') [ RunTime:0.007568s ]
- SELECT * FROM `tp_tag` WHERE `status` = 1 AND `domain_id` IN (0,30) ORDER BY `sort` ASC,`id` DESC [ RunTime:1.467454s ]
- SELECT * FROM `tp_category` WHERE `menu_display` = 1 AND `parent_id` = 0 ORDER BY `level` ASC [ RunTime:0.016490s ]
- SELECT * FROM `tp_category` WHERE `parent_id` IN (1,2,3,4,5,6,7) AND `menu_display` = 1 ORDER BY `level` ASC,`cate_id` ASC [ RunTime:0.000504s ]
- SELECT * FROM `tp_category` WHERE `menu_display` = 0 AND `parent_id` = 0 ORDER BY `level` ASC [ RunTime:0.000948s ]

2.487554s