基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-11-10 19:33:18 HTTP/2.0 GET : https://www.1004619.com/tag/%E5%AE%8C%E6%95%B4%E7%94%B5%E5%AD%90/page-7
- 运行时间 : 2.806242s [ 吞吐率:0.36req/s ] 内存消耗:592.37kb 文件加载:279
- 查询信息 : 125 queries
- 缓存信息 : 1 reads,0 writes
- 会话信息 : SESSION_ID=d219c193139667de13edf8130dd5119f
- CONNECT:[ UseTime:0.006803s ] mysql:host=127.0.0.1;port=3306;dbname=jsbaike_com;charset=utf8mb4
- SHOW FULL COLUMNS FROM `tp_domain` [ RunTime:0.003341s ]
- SELECT * FROM `tp_domain` WHERE `channel_subdomain` = 1 [ RunTime:0.009632s ]
- SELECT `domain` FROM `tp_domain` [ RunTime:0.008235s ]
- SELECT * FROM `tp_domain` WHERE `domain` = '1004619.com' LIMIT 1 [ RunTime:0.001677s ]
- SELECT * FROM `tp_domain` WHERE `domain` = '1004619.com' LIMIT 1 [ RunTime:0.007921s ]
- SHOW FULL COLUMNS FROM `tp_page` [ RunTime:0.000533s ]
- SELECT * FROM `tp_page` WHERE `domain_id` IN (0,30) AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000686s ]
- SELECT * FROM `tp_domain` WHERE `domain` = '1004619.com' LIMIT 1 [ RunTime:0.002664s ]
- SHOW FULL COLUMNS FROM `tp_tag` [ RunTime:0.001814s ]
- SELECT * FROM `tp_tag` WHERE `slug` = '完整电子' AND `status` = 1 AND `domain_id` = 30 LIMIT 1 [ RunTime:0.008477s ]
- SELECT * FROM `tp_tag` WHERE `slug` = '完整电子' AND `status` = 1 AND `domain_id` = 0 LIMIT 1 [ RunTime:0.002315s ]
- SHOW FULL COLUMNS FROM `tp_tag_course` [ RunTime:0.011120s ]
- 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.002811s ]
- SHOW FULL COLUMNS FROM `tp_tag_blog` [ RunTime:0.006914s ]
- 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.006234s ]
- SHOW FULL COLUMNS FROM `tp_tag_book` [ RunTime:0.006833s ]
- 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.009281s ]
- SHOW FULL COLUMNS FROM `tp_tag_resource` [ RunTime:0.017316s ]
- 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.008590s ]
- SHOW FULL COLUMNS FROM `tp_course` [ RunTime:0.002040s ]
- 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.023390s ]
- SHOW FULL COLUMNS FROM `tp_blog` [ RunTime:0.004910s ]
- 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.012209s ]
- SHOW FULL COLUMNS FROM `tp_book` [ RunTime:0.008458s ]
- 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.010186s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 1116 LIMIT 1 [ RunTime:0.009393s ]
- SHOW FULL COLUMNS FROM `tp_category` [ RunTime:0.005420s ]
- SELECT `cate_path` FROM `tp_category` WHERE `cate_id` = 1 LIMIT 1 [ RunTime:0.008917s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 6287 LIMIT 1 [ RunTime:0.003684s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 6288 LIMIT 1 [ RunTime:0.003140s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 6833 LIMIT 1 [ RunTime:0.001134s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90987 LIMIT 1 [ RunTime:0.004232s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90988 LIMIT 1 [ RunTime:0.002892s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90989 LIMIT 1 [ RunTime:0.003244s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90990 LIMIT 1 [ RunTime:0.004775s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90991 LIMIT 1 [ RunTime:0.002643s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90992 LIMIT 1 [ RunTime:0.011399s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90993 LIMIT 1 [ RunTime:0.002372s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90994 LIMIT 1 [ RunTime:0.005390s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90995 LIMIT 1 [ RunTime:0.002345s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 90998 LIMIT 1 [ RunTime:0.005572s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91000 LIMIT 1 [ RunTime:0.002361s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91001 LIMIT 1 [ RunTime:0.004757s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91002 LIMIT 1 [ RunTime:0.000898s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91004 LIMIT 1 [ RunTime:0.008973s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91005 LIMIT 1 [ RunTime:0.002001s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91007 LIMIT 1 [ RunTime:0.002216s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91010 LIMIT 1 [ RunTime:0.002627s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91011 LIMIT 1 [ RunTime:0.002367s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91012 LIMIT 1 [ RunTime:0.005862s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91013 LIMIT 1 [ RunTime:0.001456s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91015 LIMIT 1 [ RunTime:0.004794s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91016 LIMIT 1 [ RunTime:0.003731s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91017 LIMIT 1 [ RunTime:0.002019s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91018 LIMIT 1 [ RunTime:0.004335s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91019 LIMIT 1 [ RunTime:0.006013s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91020 LIMIT 1 [ RunTime:0.001422s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91021 LIMIT 1 [ RunTime:0.004397s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91022 LIMIT 1 [ RunTime:0.002544s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91023 LIMIT 1 [ RunTime:0.004725s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91024 LIMIT 1 [ RunTime:0.002058s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91026 LIMIT 1 [ RunTime:0.004564s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91027 LIMIT 1 [ RunTime:0.002819s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91028 LIMIT 1 [ RunTime:0.004031s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91201 LIMIT 1 [ RunTime:0.004942s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91202 LIMIT 1 [ RunTime:0.002259s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91203 LIMIT 1 [ RunTime:0.003491s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91204 LIMIT 1 [ RunTime:0.004630s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91206 LIMIT 1 [ RunTime:0.001536s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91215 LIMIT 1 [ RunTime:0.006026s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91217 LIMIT 1 [ RunTime:0.002068s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91218 LIMIT 1 [ RunTime:0.005657s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91219 LIMIT 1 [ RunTime:0.001948s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91220 LIMIT 1 [ RunTime:0.002125s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91221 LIMIT 1 [ RunTime:0.004015s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91222 LIMIT 1 [ RunTime:0.003846s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91223 LIMIT 1 [ RunTime:0.001899s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91224 LIMIT 1 [ RunTime:0.003689s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91225 LIMIT 1 [ RunTime:0.003198s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91226 LIMIT 1 [ RunTime:0.003601s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91227 LIMIT 1 [ RunTime:0.001998s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91228 LIMIT 1 [ RunTime:0.001786s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91229 LIMIT 1 [ RunTime:0.004715s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91231 LIMIT 1 [ RunTime:0.002101s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91234 LIMIT 1 [ RunTime:0.003958s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91235 LIMIT 1 [ RunTime:0.002203s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91236 LIMIT 1 [ RunTime:0.002077s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91237 LIMIT 1 [ RunTime:0.002554s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91238 LIMIT 1 [ RunTime:0.002388s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 91239 LIMIT 1 [ RunTime:0.003773s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99398 LIMIT 1 [ RunTime:0.003016s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99545 LIMIT 1 [ RunTime:0.002335s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99586 LIMIT 1 [ RunTime:0.001875s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99613 LIMIT 1 [ RunTime:0.001934s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99648 LIMIT 1 [ RunTime:0.001779s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99662 LIMIT 1 [ RunTime:0.003983s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99683 LIMIT 1 [ RunTime:0.001458s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99779 LIMIT 1 [ RunTime:0.002284s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99804 LIMIT 1 [ RunTime:0.002584s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99833 LIMIT 1 [ RunTime:0.001938s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99834 LIMIT 1 [ RunTime:0.004259s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99835 LIMIT 1 [ RunTime:0.001462s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99837 LIMIT 1 [ RunTime:0.006580s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99912 LIMIT 1 [ RunTime:0.004078s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99913 LIMIT 1 [ RunTime:0.002346s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99914 LIMIT 1 [ RunTime:0.000746s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99917 LIMIT 1 [ RunTime:0.001089s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99956 LIMIT 1 [ RunTime:0.004628s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99957 LIMIT 1 [ RunTime:0.001977s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99958 LIMIT 1 [ RunTime:0.006298s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99959 LIMIT 1 [ RunTime:0.003000s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99965 LIMIT 1 [ RunTime:0.007582s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 99990 LIMIT 1 [ RunTime:0.006467s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 100143 LIMIT 1 [ RunTime:0.001859s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 100205 LIMIT 1 [ RunTime:0.005620s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 100551 LIMIT 1 [ RunTime:0.001915s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 100797 LIMIT 1 [ RunTime:0.002702s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 100805 LIMIT 1 [ RunTime:0.003271s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 100906 LIMIT 1 [ RunTime:0.010023s ]
- SHOW FULL COLUMNS FROM `tp_resource` [ RunTime:0.001728s ]
- 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.007246s ]
- SELECT * FROM `tp_tag` WHERE `status` = 1 AND `domain_id` IN (0,30) ORDER BY `sort` ASC,`id` DESC [ RunTime:1.421278s ]
- SELECT * FROM `tp_category` WHERE `menu_display` = 1 AND `parent_id` = 0 ORDER BY `level` ASC [ RunTime:0.022130s ]
- 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.009018s ]
- SELECT * FROM `tp_category` WHERE `menu_display` = 0 AND `parent_id` = 0 ORDER BY `level` ASC [ RunTime:0.001788s ]

3.035744s