SHOW FULL COLUMNS FROM `yzn_cms_category` [ RunTime:0.004105s ]
SELECT * FROM `yzn_cms_category` WHERE `id` = 77 LIMIT 1 [ RunTime:0.001260s ]
SHOW FULL COLUMNS FROM `yzn_cms_product` [ RunTime:0.002660s ]
UPDATE `yzn_cms_product` SET `hits` = `hits` + 1 WHERE `id` = 100 [ RunTime:0.003307s ]
SELECT `cms_product`.*,`cms_product_data`.* FROM `yzn_cms_product` `cms_product` LEFT JOIN `yzn_cms_product_data` `cms_product_data` ON `cms_product`.`id`=`cms_product_data`.`did` WHERE `catid` = 77 AND `id` = 100 LIMIT 1 [ RunTime:0.001188s ]
SELECT * FROM `yzn_cms_product` WHERE ( `catid` = 77 AND `status` = 1 AND `id` < 100 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000858s ]
SELECT * FROM `yzn_cms_product` WHERE ( `catid` = 77 AND `status` = 1 AND `id` > 100 ) LIMIT 1 [ RunTime:0.000682s ]
SELECT * FROM `yzn_cms_category` WHERE ( `status`=1 AND `parentid` = 22 ) ORDER BY `listorder` ASC LIMIT 0,10 [ RunTime:0.000579s ]
