基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-11-10 19:38:53 HTTP/2.0 GET : https://www.1004619.com/tag/%E6%B5%8B%E8%AF%95%E8%BF%90%E7%BB%B4/page-5
- 运行时间 : 2.849382s [ 吞吐率:0.35req/s ] 内存消耗:575.40kb 文件加载:279
- 查询信息 : 89 queries
- 缓存信息 : 1 reads,0 writes
- 会话信息 : SESSION_ID=9084974dc66ee3bf84b8678aeef14747
- CONNECT:[ UseTime:0.020508s ] mysql:host=127.0.0.1;port=3306;dbname=jsbaike_com;charset=utf8mb4
- SHOW FULL COLUMNS FROM `tp_domain` [ RunTime:0.003467s ]
- SELECT * FROM `tp_domain` WHERE `channel_subdomain` = 1 [ RunTime:0.000716s ]
- SELECT `domain` FROM `tp_domain` [ RunTime:0.005453s ]
- SELECT * FROM `tp_domain` WHERE `domain` = '1004619.com' LIMIT 1 [ RunTime:0.003693s ]
- SELECT * FROM `tp_domain` WHERE `domain` = '1004619.com' LIMIT 1 [ RunTime:0.004980s ]
- SHOW FULL COLUMNS FROM `tp_page` [ RunTime:0.012532s ]
- SELECT * FROM `tp_page` WHERE `domain_id` IN (0,30) AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.005612s ]
- SELECT * FROM `tp_domain` WHERE `domain` = '1004619.com' LIMIT 1 [ RunTime:0.006501s ]
- SHOW FULL COLUMNS FROM `tp_tag` [ RunTime:0.001363s ]
- SELECT * FROM `tp_tag` WHERE `slug` = '测试运维' AND `status` = 1 AND `domain_id` = 30 LIMIT 1 [ RunTime:0.006489s ]
- SELECT * FROM `tp_tag` WHERE `slug` = '测试运维' AND `status` = 1 AND `domain_id` = 0 LIMIT 1 [ RunTime:0.003347s ]
- SHOW FULL COLUMNS FROM `tp_tag_course` [ RunTime:0.004670s ]
- 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` = '48812' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') GROUP BY `p`.`tag_id` [ RunTime:0.007183s ]
- SHOW FULL COLUMNS FROM `tp_tag_blog` [ RunTime:0.001955s ]
- 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` = '48812' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') GROUP BY `p`.`tag_id` [ RunTime:0.007064s ]
- SHOW FULL COLUMNS FROM `tp_tag_book` [ RunTime:0.004518s ]
- 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` = '48812' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') GROUP BY `p`.`tag_id` [ RunTime:0.005699s ]
- SHOW FULL COLUMNS FROM `tp_tag_resource` [ RunTime:0.007225s ]
- 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` = '48812' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') GROUP BY `p`.`tag_id` [ RunTime:0.002693s ]
- SHOW FULL COLUMNS FROM `tp_course` [ RunTime:0.004816s ]
- 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` = '48812' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') [ RunTime:0.011526s ]
- SHOW FULL COLUMNS FROM `tp_blog` [ RunTime:0.000845s ]
- 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` = '48812' AND `b`.`status` = '1' AND `b`.`domain_id` IN ('0','30') [ RunTime:0.002980s ]
- SHOW FULL COLUMNS FROM `tp_book` [ RunTime:0.004489s ]
- 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` = '48812' AND `bk`.`status` = '1' AND `bk`.`domain_id` IN ('0','30') [ RunTime:0.003023s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59295 LIMIT 1 [ RunTime:0.009592s ]
- SHOW FULL COLUMNS FROM `tp_category` [ RunTime:0.003135s ]
- SELECT `cate_path` FROM `tp_category` WHERE `cate_id` = 3 LIMIT 1 [ RunTime:0.003680s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59296 LIMIT 1 [ RunTime:0.008172s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59297 LIMIT 1 [ RunTime:0.000646s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59298 LIMIT 1 [ RunTime:0.004073s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59314 LIMIT 1 [ RunTime:0.002243s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59315 LIMIT 1 [ RunTime:0.001012s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59316 LIMIT 1 [ RunTime:0.001102s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59317 LIMIT 1 [ RunTime:0.012265s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59318 LIMIT 1 [ RunTime:0.009218s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59334 LIMIT 1 [ RunTime:0.001156s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59335 LIMIT 1 [ RunTime:0.001780s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59336 LIMIT 1 [ RunTime:0.002961s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59337 LIMIT 1 [ RunTime:0.001237s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59343 LIMIT 1 [ RunTime:0.000628s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59344 LIMIT 1 [ RunTime:0.012804s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59345 LIMIT 1 [ RunTime:0.002860s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59346 LIMIT 1 [ RunTime:0.002186s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59352 LIMIT 1 [ RunTime:0.002653s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59353 LIMIT 1 [ RunTime:0.003790s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59354 LIMIT 1 [ RunTime:0.009510s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59355 LIMIT 1 [ RunTime:0.001254s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59356 LIMIT 1 [ RunTime:0.002368s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59357 LIMIT 1 [ RunTime:0.000883s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59358 LIMIT 1 [ RunTime:0.002420s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59361 LIMIT 1 [ RunTime:0.011586s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59362 LIMIT 1 [ RunTime:0.004898s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59363 LIMIT 1 [ RunTime:0.000740s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59364 LIMIT 1 [ RunTime:0.002020s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59371 LIMIT 1 [ RunTime:0.000789s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59372 LIMIT 1 [ RunTime:0.002977s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59373 LIMIT 1 [ RunTime:0.009962s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59374 LIMIT 1 [ RunTime:0.002320s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59380 LIMIT 1 [ RunTime:0.001647s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59381 LIMIT 1 [ RunTime:0.001271s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59382 LIMIT 1 [ RunTime:0.011374s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59383 LIMIT 1 [ RunTime:0.001122s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59384 LIMIT 1 [ RunTime:0.000548s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59395 LIMIT 1 [ RunTime:0.000642s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59396 LIMIT 1 [ RunTime:0.000548s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59397 LIMIT 1 [ RunTime:0.000628s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59398 LIMIT 1 [ RunTime:0.002242s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59399 LIMIT 1 [ RunTime:0.000522s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59405 LIMIT 1 [ RunTime:0.000515s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59406 LIMIT 1 [ RunTime:0.000584s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59407 LIMIT 1 [ RunTime:0.000693s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59408 LIMIT 1 [ RunTime:0.001003s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59409 LIMIT 1 [ RunTime:0.000548s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59414 LIMIT 1 [ RunTime:0.002304s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59415 LIMIT 1 [ RunTime:0.000523s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59416 LIMIT 1 [ RunTime:0.000613s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59417 LIMIT 1 [ RunTime:0.000590s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59418 LIMIT 1 [ RunTime:0.000378s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59424 LIMIT 1 [ RunTime:0.001405s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59425 LIMIT 1 [ RunTime:0.000746s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59426 LIMIT 1 [ RunTime:0.000548s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 59427 LIMIT 1 [ RunTime:0.001384s ]
- SHOW FULL COLUMNS FROM `tp_resource` [ RunTime:0.000867s ]
- 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` = '48812' AND `r`.`status` = '1' AND `r`.`domain_id` IN ('0','30') [ RunTime:0.001401s ]
- SELECT * FROM `tp_tag` WHERE `status` = 1 AND `domain_id` IN (0,30) ORDER BY `sort` ASC,`id` DESC [ RunTime:1.803925s ]
- SELECT * FROM `tp_category` WHERE `menu_display` = 1 AND `parent_id` = 0 ORDER BY `level` ASC [ RunTime:0.001705s ]
- 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.007120s ]
- SELECT * FROM `tp_category` WHERE `menu_display` = 0 AND `parent_id` = 0 ORDER BY `level` ASC [ RunTime:0.003268s ]

2.992858s