基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-11-10 19:33:20 HTTP/2.0 GET : https://www.1004619.com/tag/%E5%AE%8C%E6%95%B4%E7%94%B5%E5%AD%90/page-8
- 运行时间 : 3.466824s [ 吞吐率:0.29req/s ] 内存消耗:583.43kb 文件加载:279
- 查询信息 : 125 queries
- 缓存信息 : 1 reads,0 writes
- 会话信息 : SESSION_ID=d219c193139667de13edf8130dd5119f
- CONNECT:[ UseTime:0.019776s ] mysql:host=127.0.0.1;port=3306;dbname=jsbaike_com;charset=utf8mb4
- SHOW FULL COLUMNS FROM `tp_domain` [ RunTime:0.019019s ]
- SELECT * FROM `tp_domain` WHERE `channel_subdomain` = 1 [ RunTime:0.008561s ]
- SELECT `domain` FROM `tp_domain` [ RunTime:0.021791s ]
- SELECT * FROM `tp_domain` WHERE `domain` = '1004619.com' LIMIT 1 [ RunTime:0.003023s ]
- SELECT * FROM `tp_domain` WHERE `domain` = '1004619.com' LIMIT 1 [ RunTime:0.011308s ]
- SHOW FULL COLUMNS FROM `tp_page` [ RunTime:0.003531s ]
- SELECT * FROM `tp_page` WHERE `domain_id` IN (0,30) AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002039s ]
- SELECT * FROM `tp_domain` WHERE `domain` = '1004619.com' LIMIT 1 [ RunTime:0.017581s ]
- SHOW FULL COLUMNS FROM `tp_tag` [ RunTime:0.001303s ]
- SELECT * FROM `tp_tag` WHERE `slug` = '完整电子' AND `status` = 1 AND `domain_id` = 30 LIMIT 1 [ RunTime:0.004638s ]
- SELECT * FROM `tp_tag` WHERE `slug` = '完整电子' AND `status` = 1 AND `domain_id` = 0 LIMIT 1 [ RunTime:0.003767s ]
- SHOW FULL COLUMNS FROM `tp_tag_course` [ RunTime:0.003398s ]
- 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` = '964' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') GROUP BY `p`.`tag_id` [ RunTime:0.011958s ]
- SHOW FULL COLUMNS FROM `tp_tag_blog` [ RunTime:0.002361s ]
- 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` = '964' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') GROUP BY `p`.`tag_id` [ RunTime:0.003759s ]
- SHOW FULL COLUMNS FROM `tp_tag_book` [ RunTime:0.012368s ]
- 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` = '964' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') GROUP BY `p`.`tag_id` [ RunTime:0.002918s ]
- SHOW FULL COLUMNS FROM `tp_tag_resource` [ RunTime:0.009552s ]
- 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` = '964' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') GROUP BY `p`.`tag_id` [ RunTime:0.009238s ]
- SHOW FULL COLUMNS FROM `tp_course` [ RunTime:0.004155s ]
- 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` = '964' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') [ RunTime:0.017745s ]
- SHOW FULL COLUMNS FROM `tp_blog` [ RunTime:0.001381s ]
- 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` = '964' AND `b`.`status` = '1' AND `b`.`domain_id` IN ('0','30') [ RunTime:0.008653s ]
- SHOW FULL COLUMNS FROM `tp_book` [ RunTime:0.004267s ]
- 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` = '964' AND `bk`.`status` = '1' AND `bk`.`domain_id` IN ('0','30') [ RunTime:0.006256s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 1116 LIMIT 1 [ RunTime:0.013337s ]
- SHOW FULL COLUMNS FROM `tp_category` [ RunTime:0.002224s ]
- SELECT `cate_path` FROM `tp_category` WHERE `cate_id` = 1 LIMIT 1 [ RunTime:0.004818s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 6287 LIMIT 1 [ RunTime:0.004948s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 6288 LIMIT 1 [ RunTime:0.012238s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 6833 LIMIT 1 [ RunTime:0.002404s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90987 LIMIT 1 [ RunTime:0.000855s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90988 LIMIT 1 [ RunTime:0.000541s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90989 LIMIT 1 [ RunTime:0.001010s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90990 LIMIT 1 [ RunTime:0.000926s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90991 LIMIT 1 [ RunTime:0.009541s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90992 LIMIT 1 [ RunTime:0.009169s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90993 LIMIT 1 [ RunTime:0.001196s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90994 LIMIT 1 [ RunTime:0.001047s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90995 LIMIT 1 [ RunTime:0.001167s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90998 LIMIT 1 [ RunTime:0.004192s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91000 LIMIT 1 [ RunTime:0.013986s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91001 LIMIT 1 [ RunTime:0.001274s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91002 LIMIT 1 [ RunTime:0.000964s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91004 LIMIT 1 [ RunTime:0.001609s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91005 LIMIT 1 [ RunTime:0.003047s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91007 LIMIT 1 [ RunTime:0.001197s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91010 LIMIT 1 [ RunTime:0.015316s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91011 LIMIT 1 [ RunTime:0.000840s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91012 LIMIT 1 [ RunTime:0.001162s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91013 LIMIT 1 [ RunTime:0.001003s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91015 LIMIT 1 [ RunTime:0.002903s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91016 LIMIT 1 [ RunTime:0.006985s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91017 LIMIT 1 [ RunTime:0.010972s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91018 LIMIT 1 [ RunTime:0.001351s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91019 LIMIT 1 [ RunTime:0.004392s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91020 LIMIT 1 [ RunTime:0.002693s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91021 LIMIT 1 [ RunTime:0.001182s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91022 LIMIT 1 [ RunTime:0.011836s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91023 LIMIT 1 [ RunTime:0.002321s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91024 LIMIT 1 [ RunTime:0.000919s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91026 LIMIT 1 [ RunTime:0.002461s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91027 LIMIT 1 [ RunTime:0.002472s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91028 LIMIT 1 [ RunTime:0.003562s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91201 LIMIT 1 [ RunTime:0.007684s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91202 LIMIT 1 [ RunTime:0.004673s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91203 LIMIT 1 [ RunTime:0.004727s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91204 LIMIT 1 [ RunTime:0.002527s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91206 LIMIT 1 [ RunTime:0.000690s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91215 LIMIT 1 [ RunTime:0.003417s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91217 LIMIT 1 [ RunTime:0.006468s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91218 LIMIT 1 [ RunTime:0.005484s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91219 LIMIT 1 [ RunTime:0.005344s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91220 LIMIT 1 [ RunTime:0.000895s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91221 LIMIT 1 [ RunTime:0.004004s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91222 LIMIT 1 [ RunTime:0.002663s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91223 LIMIT 1 [ RunTime:0.007173s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91224 LIMIT 1 [ RunTime:0.001744s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91225 LIMIT 1 [ RunTime:0.005478s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91226 LIMIT 1 [ RunTime:0.000939s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91227 LIMIT 1 [ RunTime:0.001885s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91228 LIMIT 1 [ RunTime:0.007359s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91229 LIMIT 1 [ RunTime:0.004227s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91231 LIMIT 1 [ RunTime:0.006198s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91234 LIMIT 1 [ RunTime:0.003964s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91235 LIMIT 1 [ RunTime:0.002191s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91236 LIMIT 1 [ RunTime:0.003762s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91237 LIMIT 1 [ RunTime:0.002855s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91238 LIMIT 1 [ RunTime:0.006869s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91239 LIMIT 1 [ RunTime:0.000622s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99398 LIMIT 1 [ RunTime:0.006720s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99545 LIMIT 1 [ RunTime:0.000963s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99586 LIMIT 1 [ RunTime:0.006103s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99613 LIMIT 1 [ RunTime:0.002256s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99648 LIMIT 1 [ RunTime:0.001300s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99662 LIMIT 1 [ RunTime:0.005469s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99683 LIMIT 1 [ RunTime:0.010829s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99779 LIMIT 1 [ RunTime:0.003840s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99804 LIMIT 1 [ RunTime:0.001233s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99833 LIMIT 1 [ RunTime:0.002401s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99834 LIMIT 1 [ RunTime:0.004696s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99835 LIMIT 1 [ RunTime:0.002802s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99837 LIMIT 1 [ RunTime:0.010420s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99912 LIMIT 1 [ RunTime:0.003227s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99913 LIMIT 1 [ RunTime:0.002011s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99914 LIMIT 1 [ RunTime:0.004920s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99917 LIMIT 1 [ RunTime:0.001077s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99956 LIMIT 1 [ RunTime:0.004086s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99957 LIMIT 1 [ RunTime:0.012514s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99958 LIMIT 1 [ RunTime:0.000951s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99959 LIMIT 1 [ RunTime:0.003380s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99965 LIMIT 1 [ RunTime:0.005701s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99990 LIMIT 1 [ RunTime:0.001921s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 100143 LIMIT 1 [ RunTime:0.012797s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 100205 LIMIT 1 [ RunTime:0.003615s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 100551 LIMIT 1 [ RunTime:0.003933s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 100797 LIMIT 1 [ RunTime:0.004326s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 100805 LIMIT 1 [ RunTime:0.004430s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 100906 LIMIT 1 [ RunTime:0.003390s ]
- SHOW FULL COLUMNS FROM `tp_resource` [ RunTime:0.013154s ]
- 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` = '964' AND `r`.`status` = '1' AND `r`.`domain_id` IN ('0','30') [ RunTime:0.003596s ]
- SELECT * FROM `tp_tag` WHERE `status` = 1 AND `domain_id` IN (0,30) ORDER BY `sort` ASC,`id` DESC [ RunTime:2.082455s ]
- SELECT * FROM `tp_category` WHERE `menu_display` = 1 AND `parent_id` = 0 ORDER BY `level` ASC [ RunTime:0.029475s ]
- 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.002090s ]
- SELECT * FROM `tp_category` WHERE `menu_display` = 0 AND `parent_id` = 0 ORDER BY `level` ASC [ RunTime:0.002873s ]

3.586161s