SHOW FULL COLUMNS FROM `yzn_cms_category` [ RunTime:0.005230s ]
SELECT * FROM `yzn_cms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000349s ]
SHOW FULL COLUMNS FROM `yzn_cms_article` [ RunTime:0.005671s ]
UPDATE `yzn_cms_article` SET `hits` = `hits` + 1 WHERE `id` = 2 [ RunTime:0.046208s ]
SELECT * FROM `yzn_cms_category` WHERE ( `status`=1 AND `parentid` = 34 ) ORDER BY `listorder` DESC LIMIT 0,100 [ RunTime:0.000499s ]
SELECT * FROM `yzn_cms_category` WHERE ( `status`=1 AND `parentid` = 40 ) ORDER BY `listorder` DESC LIMIT 0,100 [ RunTime:0.000397s ]
SELECT * FROM `yzn_cms_category` WHERE ( `status`=1 AND `parentid` = 23 ) ORDER BY `listorder` DESC LIMIT 0,100 [ RunTime:0.000459s ]
SELECT * FROM `yzn_cms_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000671s ]
SELECT * FROM `yzn_cms_category` WHERE ( `status`=1 AND `parentid` = 1 ) ORDER BY `listorder` DESC LIMIT 0,10 [ RunTime:0.000435s ]
SELECT * FROM `yzn_cms_category` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000425s ]
SELECT * FROM `yzn_cms_article` WHERE ( `status`=1 AND `catid` in(9,10,11,26,27,28,33,47,8) ) ORDER BY `id` DESC LIMIT 0,4 [ RunTime:0.000745s ]
SELECT * FROM `yzn_cms_article` WHERE ( `catid` = 32 AND `status` = 1 AND `id` > 2 ) LIMIT 1 [ RunTime:0.000820s ]
SELECT * FROM `yzn_cms_article` WHERE ( `catid` = 32 AND `status` = 1 AND `id` < 2 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000717s ]
SELECT * FROM `yzn_cms_article` WHERE ( `status`=1 AND (FIND_IN_SET('1', flag)) AND `catid` in(21,25,44,45,46,48,49,50,51,52,53,54,55,56,57,58,59,60,19) ) ORDER BY `listorder` DESC LIMIT 0,10 [ RunTime:0.001649s ]
QQ在线咨询
029-81324861
