SHOW FULL COLUMNS FROM `yzn_cms_category` [ RunTime:0.001505s ]
SELECT * FROM `yzn_cms_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000431s ]
SHOW FULL COLUMNS FROM `yzn_cms_article` [ RunTime:0.001030s ]
UPDATE `yzn_cms_article` SET `hits` = `hits` + 1 WHERE `id` = 86 [ RunTime:0.005391s ]
SELECT `cms_article`.*,`cms_article_data`.* FROM `yzn_cms_article` `cms_article` LEFT JOIN `yzn_cms_article_data` `cms_article_data` ON `cms_article`.`id`=`cms_article_data`.`did` WHERE `catid` = 7 AND `id` = 86 LIMIT 1 [ RunTime:0.000521s ]
select * from yzn_cms_tags ORDER BY hits DESC LIMIT 50 [ RunTime:0.000357s ]
SELECT * FROM `yzn_cms_article` WHERE ( `catid` = 7 AND `status` = 1 AND `id` < 86 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT * FROM `yzn_cms_article` WHERE ( `catid` = 7 AND `status` = 1 AND `id` > 86 ) LIMIT 1 [ RunTime:0.000294s ]
SELECT COUNT(*) AS think_count FROM `yzn_cms_article` WHERE ( `status`=1 AND `catid` = 7 ) [ RunTime:0.000276s ]
SELECT * FROM `yzn_cms_article` WHERE ( `status`=1 AND `catid` = 7 ) ORDER BY `listorder` ASC LIMIT 0,10 [ RunTime:0.000319s ]
SELECT * FROM `yzn_cms_article` WHERE ( thumb !='' AND `status`=1 AND `catid` = 7 ) ORDER BY `listorder` ASC LIMIT 0,10 [ RunTime:0.000338s ]
SELECT * FROM `yzn_cms_article` WHERE ( thumb !='' AND `status`=1 AND `catid` = 7 ) ORDER BY `hits` DESC LIMIT 0,1 [ RunTime:0.000398s ]
SELECT * FROM `yzn_cms_article` WHERE ( `status`=1 AND `catid` = 7 ) ORDER BY `hits` DESC LIMIT 0,10 [ RunTime:0.000405s ]
SELECT * FROM `yzn_cms_article` WHERE ( thumb !='' AND `status`=1 AND `catid` = 7 ) ORDER BY `hits` ASC LIMIT 0,1 [ RunTime:0.000489s ]
SELECT * FROM `yzn_cms_article` WHERE ( thumb !='' AND `status`=1 AND `catid` = 7 ) ORDER BY `hits` DESC LIMIT 0,10 [ RunTime:0.000374s ]
select * from yzn_cms_article ORDER BY hits DESC LIMIT 6 [ RunTime:0.000539s ]
微信收款码
支付宝收款码