SHOW FULL COLUMNS FROM `yzn_cms_product` [ RunTime:0.004220s ]
UPDATE `yzn_cms_product` SET `hits` = `hits` + 1 WHERE `id` = 101 [ RunTime:0.003345s ]
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` = 101 LIMIT 1 [ RunTime:0.000926s ]
SELECT * FROM `yzn_cms_product` WHERE ( `catid` = 77 AND `status` = 1 AND `id` < 101 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000646s ]
SELECT * FROM `yzn_cms_product` WHERE ( `catid` = 77 AND `status` = 1 AND `id` > 101 ) LIMIT 1 [ RunTime:0.000493s ]
SHOW FULL COLUMNS FROM `yzn_cms_category` [ RunTime:0.002410s ]
SELECT * FROM `yzn_cms_category` WHERE ( `status`=1 AND `parentid` = 22 ) ORDER BY `listorder` ASC LIMIT 0,10 [ RunTime:0.000587s ]
