基本
文件
流程
错误
SQL
调试
- 请求信息 : 2025-04-12 18:23:40 HTTP/1.1 GET : http://hzyestar.com/plusfff/previewcontent.html?id=57974
- 运行时间 : 0.150584s [ 吞吐率：6.64req/s ] 内存消耗：5,107.43kb 文件加载：187
- 查询信息 : 73 queries
- 缓存信息 : 1 reads,0 writes
- 会话信息 : SESSION_ID=9c38f298ab092185854372745e228085
- CONNECT:[ UseTime:0.000192s ] mysql:host=localhost;port=3356;dbname=www_hzyestar_com;charset=utf8
- SHOW FULL COLUMNS FROM `yx_article` [ RunTime:0.000523s ]
- SELECT `a`.`id`,`a`.`ishtml`,a.id as aid,`a`.`filename`,c.id as typeid,`c`.`typedir`,c.temparticle as templet,`c`.`urlrule`,3 as typ FROM `yx_article` `a` INNER JOIN `yx_category` `c` ON `a`.`categoryid`=`c`.`id` WHERE `a`.`isdel` = '0' AND `a`.`id` = '57974' LIMIT 1 [ RunTime:0.000232s ]
- SHOW FULL COLUMNS FROM `yx_tagname` [ RunTime:0.000452s ]
- SELECT `tag` FROM `yx_tagname` WHERE `activation` = 1 ORDER BY `id` ASC [ RunTime:0.000161s ]
- SHOW FULL COLUMNS FROM `yx_category` [ RunTime:0.000557s ]
- SELECT `id` FROM `yx_category` WHERE `pid` = 210 [ RunTime:0.000213s ]
- SELECT *,concat(typedir,"/") as typedir FROM `yx_category` WHERE `ishidden` = 0 AND `id` IN (7,188,192,193,195,196,197,211) ORDER BY `sortrank` ASC,`id` ASC LIMIT 0,5 [ RunTime:0.000280s ]
- SELECT `id` FROM `yx_category` WHERE `pid` = 211 [ RunTime:0.000153s ]
- SELECT *,concat(typedir,"/") as typedir FROM `yx_category` WHERE `ishidden` = 0 AND `id` IN (239,240,241,242,243,244,415,460) ORDER BY `sortrank` ASC,`id` ASC LIMIT 4 [ RunTime:0.000225s ]
- SELECT `id` FROM `yx_category` WHERE `pid` = 196 [ RunTime:0.000122s ]
- SELECT *,concat(typedir,"/") as typedir FROM `yx_category` WHERE `ishidden` = 0 AND `id` IN (282,283,284,285,286,287,288,289,290,413) ORDER BY `sortrank` ASC,`id` ASC LIMIT 4 [ RunTime:0.000224s ]
- SELECT `id` FROM `yx_category` WHERE `pid` = 193 [ RunTime:0.000128s ]
- SELECT *,concat(typedir,"/") as typedir FROM `yx_category` WHERE `ishidden` = 0 AND `id` IN (254,255,256,259,260,261) ORDER BY `sortrank` ASC,`id` ASC LIMIT 4 [ RunTime:0.000205s ]
- SELECT `id` FROM `yx_category` WHERE `pid` = 7 [ RunTime:0.000116s ]
- SELECT *,concat(typedir,"/") as typedir FROM `yx_category` WHERE `ishidden` = 0 AND `id` IN (8,9,10,11,245,246,247,248,249,459) ORDER BY `sortrank` ASC,`id` ASC LIMIT 4 [ RunTime:0.000233s ]
- SELECT `id` FROM `yx_category` WHERE `pid` = 195 [ RunTime:0.000137s ]
- SELECT *,concat(typedir,"/") as typedir FROM `yx_category` WHERE `ishidden` = 0 AND `id` IN (266,267,268,269,270,274,275,276,277,279,280,281,479) ORDER BY `sortrank` ASC,`id` ASC LIMIT 4 [ RunTime:0.000223s ]
- SELECT `id` FROM `yx_category` WHERE `pid` = 85 [ RunTime:0.000127s ]
- SELECT *,concat(typedir,"/") as typedir FROM `yx_category` WHERE `ishidden` = 0 AND `id` IN (198,199,200,201,202,441) ORDER BY `sortrank` ASC,`id` ASC LIMIT 0,6 [ RunTime:0.000203s ]
- SELECT `id` FROM `yx_category` WHERE `pid` = 198 [ RunTime:0.000131s ]
- SELECT *,concat(typedir,"/") as typedir FROM `yx_category` WHERE `ishidden` = 0 AND `id` IN (86,88,89,102,311,312,412,427,522) ORDER BY `sortrank` ASC,`id` ASC LIMIT 4 [ RunTime:0.000208s ]
- SELECT `id` FROM `yx_category` WHERE `pid` = 199 [ RunTime:0.000147s ]
- SELECT *,concat(typedir,"/") as typedir FROM `yx_category` WHERE `ishidden` = 0 AND `id` IN (87,96,212,317,318,319,320,321,480) ORDER BY `sortrank` ASC,`id` ASC LIMIT 4 [ RunTime:0.000210s ]
- SELECT `id` FROM `yx_category` WHERE `pid` = 202 [ RunTime:0.000141s ]
- SELECT *,concat(typedir,"/") as typedir FROM `yx_category` WHERE `ishidden` = 0 AND `id` IN (338,339) ORDER BY `sortrank` ASC,`id` ASC LIMIT 4 [ RunTime:0.000165s ]
- SELECT `id` FROM `yx_category` WHERE `pid` = 200 [ RunTime:0.000107s ]
- SELECT *,concat(typedir,"/") as typedir FROM `yx_category` WHERE `ishidden` = 0 AND `id` IN (322,323,324,325,326,327,328,401,515,516) ORDER BY `sortrank` ASC,`id` ASC LIMIT 4 [ RunTime:0.000217s ]
- SELECT `id` FROM `yx_category` WHERE `pid` = 201 [ RunTime:0.000134s ]
- SELECT *,concat(typedir,"/") as typedir FROM `yx_category` WHERE `ishidden` = 0 AND `id` IN (104,329,330,332,333,335) ORDER BY `sortrank` ASC,`id` ASC LIMIT 4 [ RunTime:0.000216s ]
- SELECT `id` FROM `yx_category` WHERE `pid` = 441 [ RunTime:0.000127s ]
- SELECT *,concat(typedir,"/") as typedir FROM `yx_category` WHERE `ishidden` = 0 AND `id` IN (100,331) ORDER BY `sortrank` ASC,`id` ASC LIMIT 4 [ RunTime:0.000175s ]
- SELECT `id` FROM `yx_category` WHERE `pid` = 524 [ RunTime:0.000136s ]
- SELECT *,concat(typedir,"/") as typedir FROM `yx_category` WHERE `ishidden` = 0 AND `id` IN (525,526,527,528,529,530,531,532,533) ORDER BY `sortrank` ASC,`id` ASC LIMIT 4 [ RunTime:0.000221s ]
- SELECT `id` FROM `yx_category` WHERE `pid` = 209 [ RunTime:0.000139s ]
- SELECT *,concat(typedir,"/") as typedir FROM `yx_category` WHERE `ishidden` = 0 AND `id` IN (442,443,444,482) ORDER BY `sortrank` ASC,`id` ASC LIMIT 4 [ RunTime:0.000185s ]
- SELECT `id` FROM `yx_category` WHERE `pid` = 483 [ RunTime:0.000104s ]
- SELECT *,concat(typedir,"/") as typedir FROM `yx_category` WHERE `ishidden` = 0 AND `id` IN (484,485,486,487) ORDER BY `sortrank` ASC,`id` ASC LIMIT 4 [ RunTime:0.000263s ]
- SELECT `id`,`typename`,`ispart`,`typeimg`,concat(typedir,"/") as typedir,`isdefault`,`urlrule2` FROM `yx_category` WHERE `id` = 524 [ RunTime:0.000153s ]
- SELECT `id`,`typename`,`ispart`,`typeimg`,concat(typedir,"/") as typedir,`isdefault`,`urlrule2` FROM `yx_category` WHERE `id` = 209 [ RunTime:0.000120s ]
- SELECT `id`,`typename`,`ispart`,`typeimg`,concat(typedir,"/") as typedir,`isdefault`,`urlrule2` FROM `yx_category` WHERE `id` = 483 [ RunTime:0.000102s ]
- SELECT `tag` FROM `yx_tagname` WHERE `activation` = 1 ORDER BY `id` ASC [ RunTime:0.000174s ]
- SELECT `id`,`pid` FROM `yx_category` WHERE `ishidden` = 0 ORDER BY `id` DESC [ RunTime:0.000357s ]
- SHOW FULL COLUMNS FROM `yx_pseudostatic_config` [ RunTime:0.000694s ]
- SELECT * FROM `yx_pseudostatic_config` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000155s ]
- SELECT `channelid` FROM `yx_category` WHERE `id` = 278 LIMIT 1 [ RunTime:0.000147s ]
- SHOW FULL COLUMNS FROM `yx_attribute_field` [ RunTime:0.000583s ]
- SELECT DISTINCT `fieldname` FROM `yx_attribute_field` WHERE `channelid` = 1 [ RunTime:0.000178s ]
- SHOW FULL COLUMNS FROM `yx_channel` [ RunTime:0.000490s ]
- SELECT `iden` FROM `yx_channel` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000132s ]
- SELECT `a`.*,`b`.`typename`,`b`.`ispart`,b.id as typeid,`b`.`typedir`,`isdefault`,`b`.`urlrule`,`b`.`urlrule2`,`c`.`aid`,`c`.`templet`,`c`.`userip` FROM `yx_article` `a` INNER JOIN `yx_category` `b` ON `a`.`categoryid`=`b`.`id` INNER JOIN `yx_article_content` `c` ON `a`.`id`=`c`.`aid` WHERE `a`.`isexamine` = '0' AND `a`.`isdel` = '0' AND `b`.`ishidden` = '0' AND ( (a.categoryid in (278) and a.ismake=1) ) ORDER BY `id` DESC LIMIT 1,9 [ RunTime:0.000660s ]
- SELECT `keywords`,`channelid` FROM `yx_article` WHERE `id` = 57974 LIMIT 1 [ RunTime:0.000166s ]
- SELECT DISTINCT `fieldname` FROM `yx_attribute_field` WHERE `channelid` = 1 [ RunTime:0.000143s ]
- SELECT `iden` FROM `yx_channel` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000133s ]
- SELECT `id` FROM `yx_category` WHERE `channelid` = 1 AND `ishidden` = 0 ORDER BY `id` DESC [ RunTime:0.000451s ]
- SELECT * FROM `yx_pseudostatic_config` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000131s ]
- SELECT `a`.*,`b`.`typename`,`b`.`ispart`,b.id as typeid,`b`.`typedir`,`isdefault`,`b`.`urlrule`,`b`.`urlrule2`,`c`.`aid`,`c`.`templet`,`c`.`userip` FROM `yx_article` `a` INNER JOIN `yx_category` `b` ON `a`.`categoryid`=`b`.`id` INNER JOIN `yx_article_content` `c` ON `a`.`id`=`c`.`aid` WHERE ( (a.categoryid in (724,723,722,721,720,719,718,717,716,715,714,713,712,710,709,708,707,706,705,704,703,701,538,537,536,535,534,533,532,531,530,529,528,527,526,525,524,522,521,520,519,518,517,516,515,514,513,512,511,510,509,508,507,506,505,504,503,501,500,499,498,497,496,495,494,493,492,491,490,487,486,485,484,483,482,481,480,479,477,476,475,474,473,472,471,470,469,468,466,465,464,463,460,459,455,454,446,444,443,442,441,427,415,413,412,410,409,401,397,396,395,394,393,392,390,389,388,387,386,385,384,383,382,381,380,379,378,377,376,375,373,372,371,370,369,368,367,359,358,357,356,355,354,353,352,351,350,349,348,347,346,345,344,343,342,341,340,339,338,335,333,332,331,330,329,328,327,326,325,324,323,322,321,320,319,318,317,312,311,308,305,304,302,301,296,295,294,293,292,291,290,289,288,287,286,285,284,283,282,281,280,279,278,277,276,275,274,270,269,268,267,266,264,263,261,260,259,256,255,254,253,251,250,249,248,247,246,245,244,243,242,241,240,239,238,237,236,234,233,232,231,226,225,224,223,222,221,220,219,218,212,211,210,209,208,207,206,205,204,203,202,201,200,199,198,197,196,195,193,192,188,178,174,120,112,111,110,106,104,102,100,96,89,88,87,86,85,11,10,9,8,7) and a.ismake=1) ) AND `a`.`id` <> '57974' AND `a`.`isexamine` = '0' AND `a`.`isdel` = '0' AND `b`.`ishidden` = '0' AND `a`.`channelid` = '1' ORDER BY `pubdate` DESC LIMIT 9 [ RunTime:0.025822s ]
- SELECT `id`,`typename`,`ispart`,`typeimg`,concat(typedir,"/") as typedir,`isdefault`,`urlrule2` FROM `yx_category` WHERE `id` = 278 [ RunTime:0.000159s ]
- SELECT `id`,`typename`,`ispart`,`typeimg`,concat(typedir,"/") as typedir,`isdefault`,`urlrule2` FROM `yx_category` WHERE `id` = 278 [ RunTime:0.000099s ]
- SELECT `id`,`typename`,`ispart`,`typeimg`,concat(typedir,"/") as typedir,`isdefault`,`urlrule2` FROM `yx_category` WHERE `id` = 278 [ RunTime:0.000089s ]
- SELECT `id`,`typename`,`ispart`,`typeimg`,concat(typedir,"/") as typedir,`isdefault`,`urlrule2` FROM `yx_category` WHERE `id` = 278 [ RunTime:0.000087s ]
- SHOW FULL COLUMNS FROM `yx_website` [ RunTime:0.000426s ]
- SELECT `sitetoken` FROM `yx_website` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000113s ]
- SELECT `id`,id as typeid,`pid`,`ispart`,`typedir`,typedir as typelink,`typename`,`isdefault`,`urlrule2`,`seotitle`,`keywords`,`description`,`content`,`defaultname` FROM `yx_category` WHERE `id` = 278 LIMIT 1 [ RunTime:0.000127s ]
- SELECT `id`,`pid`,`ispart`,`typename`,`typedir`,`isdefault`,`urlrule2` FROM `yx_category` ORDER BY `id` DESC [ RunTime:0.000395s ]
- SELECT * FROM `yx_category` ORDER BY `id` DESC [ RunTime:0.000752s ]
- SELECT `channelid` FROM `yx_article` WHERE `id` = 57974 LIMIT 1 [ RunTime:0.000181s ]
- SELECT `iden` FROM `yx_channel` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000097s ]
- SELECT `a`.*,`b`.*,c.id as typeid,`c`.`typename`,`c`.`typedir`,`c`.`temparticle`,`c`.`urlrule`,`c`.`defaultname` FROM `yx_article` `a` INNER JOIN `yx_article_content` `b` ON `a`.`id`=`b`.`aid` INNER JOIN `yx_category` `c` ON `a`.`categoryid`=`c`.`id` WHERE `a`.`id` = '57974' AND `a`.`isexamine` = '0' AND `a`.`isdel` = '0' AND `c`.`ishidden` = '0' LIMIT 1 [ RunTime:0.000205s ]
- SELECT `fieldname` FROM `yx_attribute_field` WHERE `channelid` = 1 AND `attributeid` = 9 ORDER BY `id` DESC [ RunTime:0.000137s ]
- SELECT `id`,`pid`,`typedir`,`typename`,`ispart`,`isdefault`,`urlrule2` FROM `yx_category` WHERE `ishidden` = 0 ORDER BY `id` DESC [ RunTime:0.000407s ]
- SELECT * FROM `yx_pseudostatic_config` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000138s ]
- SELECT `a`.`id`,`a`.`ishtml`,`a`.`title`,`c`.`typedir`,`c`.`urlrule` FROM `yx_article` `a` INNER JOIN `yx_category` `c` ON `a`.`categoryid`=`c`.`id` WHERE `a`.`isexamine` = '0' AND `a`.`isdel` = '0' AND `c`.`ishidden` = '0' AND `a`.`id` < '57974' AND ( (a.categoryid in (1007,1006,1005,1004,1003,1002,1001,1000,999,998,997,996,995,994,993,991,990,989,988,987,986,985,984,983,980,979,978,977,976,973,972,971,970,969,967,966,965,964,963,962,961,960,959,958,957,956,955,954,953,952,951,950,949,948,947,946,945,944,943,942,941,940,939,938,937,936,935,934,933,932,931,930,929,928,927,926,925,924,923,922,921,920,919,918,917,916,915,914,913,912,911,910,909,908,907,906,905,904,903,902,901,900,899,898,897,896,895,894,893,892,891,890,889,888,887,886,885,884,883,882,881,880,879,878,877,876,875,874,873,872,871,870,724,723,722,721,720,719,718,717,716,715,714,713,712,710,709,708,707,706,705,704,703,701,538,537,536,535,534,533,532,531,530,529,528,527,526,525,524,522,521,520,519,518,517,516,515,514,513,512,511,510,509,508,507,506,505,504,503,501,500,499,498,497,496,495,494,493,492,491,490,487,486,485,484,483,482,481,480,479,477,476,475,474,473,472,471,470,469,468,466,465,464,463,460,459,455,454,446,444,443,442,441,427,415,413,412,410,409,401,397,396,395,394,393,392,390,389,388,387,386,385,384,383,382,381,380,379,378,377,376,375,373,372,371,370,369,368,367,359,358,357,356,355,354,353,352,351,350,349,348,347,346,345,344,343,342,341,340,339,338,335,333,332,331,330,329,328,327,326,325,324,323,322,321,320,319,318,317,312,311,308,305,304,302,301,296,295,294,293,292,291,290,289,288,287,286,285,284,283,282,281,280,279,278,277,276,275,274,270,269,268,267,266,264,263,261,260,259,256,255,254,253,251,250,249,248,247,246,245,244,243,242,241,240,239,238,237,236,234,233,232,231,226,225,224,223,222,221,220,219,218,212,211,210,209,208,207,206,205,204,203,202,201,200,199,198,197,196,195,193,192,188,178,174,120,112,111,110,106,104,102,100,96,89,88,87,86,85,11,10,9,8,7) and a.ismake=1) ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000669s ]
- SELECT `a`.`id`,`a`.`ishtml`,`a`.`title`,`c`.`typedir`,`c`.`urlrule` FROM `yx_article` `a` INNER JOIN `yx_category` `c` ON `a`.`categoryid`=`c`.`id` WHERE `a`.`isexamine` = '0' AND `a`.`isdel` = '0' AND `a`.`id` < '57974' AND `a`.`id` > '57974' AND ( (a.categoryid in (1007,1006,1005,1004,1003,1002,1001,1000,999,998,997,996,995,994,993,991,990,989,988,987,986,985,984,983,980,979,978,977,976,973,972,971,970,969,967,966,965,964,963,962,961,960,959,958,957,956,955,954,953,952,951,950,949,948,947,946,945,944,943,942,941,940,939,938,937,936,935,934,933,932,931,930,929,928,927,926,925,924,923,922,921,920,919,918,917,916,915,914,913,912,911,910,909,908,907,906,905,904,903,902,901,900,899,898,897,896,895,894,893,892,891,890,889,888,887,886,885,884,883,882,881,880,879,878,877,876,875,874,873,872,871,870,724,723,722,721,720,719,718,717,716,715,714,713,712,710,709,708,707,706,705,704,703,701,538,537,536,535,534,533,532,531,530,529,528,527,526,525,524,522,521,520,519,518,517,516,515,514,513,512,511,510,509,508,507,506,505,504,503,501,500,499,498,497,496,495,494,493,492,491,490,487,486,485,484,483,482,481,480,479,477,476,475,474,473,472,471,470,469,468,466,465,464,463,460,459,455,454,446,444,443,442,441,427,415,413,412,410,409,401,397,396,395,394,393,392,390,389,388,387,386,385,384,383,382,381,380,379,378,377,376,375,373,372,371,370,369,368,367,359,358,357,356,355,354,353,352,351,350,349,348,347,346,345,344,343,342,341,340,339,338,335,333,332,331,330,329,328,327,326,325,324,323,322,321,320,319,318,317,312,311,308,305,304,302,301,296,295,294,293,292,291,290,289,288,287,286,285,284,283,282,281,280,279,278,277,276,275,274,270,269,268,267,266,264,263,261,260,259,256,255,254,253,251,250,249,248,247,246,245,244,243,242,241,240,239,238,237,236,234,233,232,231,226,225,224,223,222,221,220,219,218,212,211,210,209,208,207,206,205,204,203,202,201,200,199,198,197,196,195,193,192,188,178,174,120,112,111,110,106,104,102,100,96,89,88,87,86,85,11,10,9,8,7) and a.ismake=1) ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000434s ]
0.169986s
