基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-11-10 19:39:51 HTTP/2.0 GET : https://www.1004619.com/tag/%E9%A3%8E%E6%B0%B4%E5%A0%AA%E8%88%86/page-7
- 运行时间 : 2.100284s [ 吞吐率:0.48req/s ] 内存消耗:598.82kb 文件加载:279
- 查询信息 : 130 queries
- 缓存信息 : 1 reads,0 writes
- 会话信息 : SESSION_ID=9084974dc66ee3bf84b8678aeef14747
- CONNECT:[ UseTime:0.010395s ] mysql:host=127.0.0.1;port=3306;dbname=jsbaike_com;charset=utf8mb4
- SHOW FULL COLUMNS FROM `tp_domain` [ RunTime:0.005827s ]
- SELECT * FROM `tp_domain` WHERE `channel_subdomain` = 1 [ RunTime:0.005796s ]
- SELECT `domain` FROM `tp_domain` [ RunTime:0.020219s ]
- SELECT * FROM `tp_domain` WHERE `domain` = '1004619.com' LIMIT 1 [ RunTime:0.009678s ]
- SELECT * FROM `tp_domain` WHERE `domain` = '1004619.com' LIMIT 1 [ RunTime:0.006301s ]
- SHOW FULL COLUMNS FROM `tp_page` [ RunTime:0.018496s ]
- SELECT * FROM `tp_page` WHERE `domain_id` IN (0,30) AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.010146s ]
- SELECT * FROM `tp_domain` WHERE `domain` = '1004619.com' LIMIT 1 [ RunTime:0.005069s ]
- SHOW FULL COLUMNS FROM `tp_tag` [ RunTime:0.011688s ]
- SELECT * FROM `tp_tag` WHERE `slug` = '风水堪舆' AND `status` = 1 AND `domain_id` = 30 LIMIT 1 [ RunTime:0.007992s ]
- SELECT * FROM `tp_tag` WHERE `slug` = '风水堪舆' AND `status` = 1 AND `domain_id` = 0 LIMIT 1 [ RunTime:0.001511s ]
- SHOW FULL COLUMNS FROM `tp_tag_course` [ RunTime:0.003358s ]
- 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` = '1893' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') GROUP BY `p`.`tag_id` [ RunTime:0.009022s ]
- SHOW FULL COLUMNS FROM `tp_tag_blog` [ RunTime:0.004713s ]
- 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` = '1893' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') GROUP BY `p`.`tag_id` [ RunTime:0.005576s ]
- SHOW FULL COLUMNS FROM `tp_tag_book` [ RunTime:0.002772s ]
- 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` = '1893' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') GROUP BY `p`.`tag_id` [ RunTime:0.005685s ]
- SHOW FULL COLUMNS FROM `tp_tag_resource` [ RunTime:0.023324s ]
- 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` = '1893' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') GROUP BY `p`.`tag_id` [ RunTime:0.004738s ]
- SHOW FULL COLUMNS FROM `tp_course` [ RunTime:0.003609s ]
- 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` = '1893' AND `c`.`status` = '1' AND `c`.`domain_id` IN ('0','30') [ RunTime:0.001355s ]
- SHOW FULL COLUMNS FROM `tp_blog` [ RunTime:0.004271s ]
- 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` = '1893' AND `b`.`status` = '1' AND `b`.`domain_id` IN ('0','30') [ RunTime:0.008097s ]
- SHOW FULL COLUMNS FROM `tp_book` [ RunTime:0.002741s ]
- 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` = '1893' AND `bk`.`status` = '1' AND `bk`.`domain_id` IN ('0','30') [ RunTime:0.002226s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 2336 LIMIT 1 [ RunTime:0.008484s ]
- SHOW FULL COLUMNS FROM `tp_category` [ RunTime:0.003662s ]
- SELECT `cate_path` FROM `tp_category` WHERE `cate_id` = 1 LIMIT 1 [ RunTime:0.006972s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 3061 LIMIT 1 [ RunTime:0.007377s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 3843 LIMIT 1 [ RunTime:0.005202s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 4548 LIMIT 1 [ RunTime:0.007043s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 5672 LIMIT 1 [ RunTime:0.002911s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 7236 LIMIT 1 [ RunTime:0.009296s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 14711 LIMIT 1 [ RunTime:0.003644s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 15364 LIMIT 1 [ RunTime:0.001224s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 15426 LIMIT 1 [ RunTime:0.001022s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 15445 LIMIT 1 [ RunTime:0.003969s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 15481 LIMIT 1 [ RunTime:0.000803s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 15503 LIMIT 1 [ RunTime:0.014036s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 18956 LIMIT 1 [ RunTime:0.011218s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 28746 LIMIT 1 [ RunTime:0.004361s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 29436 LIMIT 1 [ RunTime:0.004660s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 34064 LIMIT 1 [ RunTime:0.002221s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 39636 LIMIT 1 [ RunTime:0.006596s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 46382 LIMIT 1 [ RunTime:0.008125s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 52551 LIMIT 1 [ RunTime:0.003664s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 69455 LIMIT 1 [ RunTime:0.000915s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 72800 LIMIT 1 [ RunTime:0.000295s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 73783 LIMIT 1 [ RunTime:0.000760s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 74192 LIMIT 1 [ RunTime:0.000665s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 74433 LIMIT 1 [ RunTime:0.004105s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 80395 LIMIT 1 [ RunTime:0.000373s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 81011 LIMIT 1 [ RunTime:0.000837s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 92547 LIMIT 1 [ RunTime:0.003999s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 93379 LIMIT 1 [ RunTime:0.001383s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 93752 LIMIT 1 [ RunTime:0.002770s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 94229 LIMIT 1 [ RunTime:0.000908s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 100505 LIMIT 1 [ RunTime:0.001238s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 102555 LIMIT 1 [ RunTime:0.001637s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 103394 LIMIT 1 [ RunTime:0.000535s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 107280 LIMIT 1 [ RunTime:0.008248s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 109944 LIMIT 1 [ RunTime:0.002288s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 144265 LIMIT 1 [ RunTime:0.000435s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 144267 LIMIT 1 [ RunTime:0.002157s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 144270 LIMIT 1 [ RunTime:0.004810s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 144274 LIMIT 1 [ RunTime:0.000769s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 144276 LIMIT 1 [ RunTime:0.014789s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 144425 LIMIT 1 [ RunTime:0.002184s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 144432 LIMIT 1 [ RunTime:0.002162s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 144459 LIMIT 1 [ RunTime:0.001528s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 144498 LIMIT 1 [ RunTime:0.000556s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 150904 LIMIT 1 [ RunTime:0.002039s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151138 LIMIT 1 [ RunTime:0.011615s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151148 LIMIT 1 [ RunTime:0.008632s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151179 LIMIT 1 [ RunTime:0.000653s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151207 LIMIT 1 [ RunTime:0.001399s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151218 LIMIT 1 [ RunTime:0.008438s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151238 LIMIT 1 [ RunTime:0.005936s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151239 LIMIT 1 [ RunTime:0.006597s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151273 LIMIT 1 [ RunTime:0.000263s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151281 LIMIT 1 [ RunTime:0.000235s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151282 LIMIT 1 [ RunTime:0.006263s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151299 LIMIT 1 [ RunTime:0.004116s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151311 LIMIT 1 [ RunTime:0.001526s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151322 LIMIT 1 [ RunTime:0.003512s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151323 LIMIT 1 [ RunTime:0.002639s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151324 LIMIT 1 [ RunTime:0.000265s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151334 LIMIT 1 [ RunTime:0.002486s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151370 LIMIT 1 [ RunTime:0.002387s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151385 LIMIT 1 [ RunTime:0.000223s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151409 LIMIT 1 [ RunTime:0.002213s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151477 LIMIT 1 [ RunTime:0.002010s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151496 LIMIT 1 [ RunTime:0.000225s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151505 LIMIT 1 [ RunTime:0.000382s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151590 LIMIT 1 [ RunTime:0.013939s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151591 LIMIT 1 [ RunTime:0.013902s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151592 LIMIT 1 [ RunTime:0.000235s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151673 LIMIT 1 [ RunTime:0.004372s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151727 LIMIT 1 [ RunTime:0.005087s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151781 LIMIT 1 [ RunTime:0.000219s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151810 LIMIT 1 [ RunTime:0.000234s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151829 LIMIT 1 [ RunTime:0.000235s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151830 LIMIT 1 [ RunTime:0.000629s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151891 LIMIT 1 [ RunTime:0.000236s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151892 LIMIT 1 [ RunTime:0.001762s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151917 LIMIT 1 [ RunTime:0.006024s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 151930 LIMIT 1 [ RunTime:0.004559s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 152052 LIMIT 1 [ RunTime:0.000238s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 152053 LIMIT 1 [ RunTime:0.001851s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 152055 LIMIT 1 [ RunTime:0.002668s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 152056 LIMIT 1 [ RunTime:0.001741s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 152057 LIMIT 1 [ RunTime:0.001192s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 152059 LIMIT 1 [ RunTime:0.001557s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 152067 LIMIT 1 [ RunTime:0.000247s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 152068 LIMIT 1 [ RunTime:0.000260s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 152069 LIMIT 1 [ RunTime:0.010526s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 152107 LIMIT 1 [ RunTime:0.009564s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 152108 LIMIT 1 [ RunTime:0.006028s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 152127 LIMIT 1 [ RunTime:0.001888s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 152148 LIMIT 1 [ RunTime:0.001272s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 152214 LIMIT 1 [ RunTime:0.001866s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 152240 LIMIT 1 [ RunTime:0.000491s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 152244 LIMIT 1 [ RunTime:0.011612s ]
- SELECT `cate_id` FROM `tp_book` WHERE `id` = 152263 LIMIT 1 [ RunTime:0.005834s ]
- SHOW FULL COLUMNS FROM `tp_resource` [ RunTime:0.003213s ]
- 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` = '1893' AND `r`.`status` = '1' AND `r`.`domain_id` IN ('0','30') [ RunTime:0.013884s ]
- SELECT * FROM `tp_tag` WHERE `status` = 1 AND `domain_id` IN (0,30) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.942661s ]
- SELECT * FROM `tp_category` WHERE `menu_display` = 1 AND `parent_id` = 0 ORDER BY `level` ASC [ RunTime:0.011336s ]
- 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.003503s ]
- SELECT * FROM `tp_category` WHERE `menu_display` = 0 AND `parent_id` = 0 ORDER BY `level` ASC [ RunTime:0.005683s ]

2.210253s