SHOW FULL COLUMNS FROM `yzn_cms_product` [ RunTime:0.000754s ]
UPDATE `yzn_cms_product` SET `hits` = `hits` + 1 WHERE `id` = 10 [ RunTime:0.005063s ]
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` = 20 AND `id` = 10 LIMIT 1 [ RunTime:0.000651s ]
SELECT * FROM `yzn_cms_product` WHERE ( `catid` = 20 AND `status` = 1 AND `id` < 10 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000664s ]
SELECT * FROM `yzn_cms_product` WHERE ( `catid` = 20 AND `status` = 1 AND `id` > 10 ) LIMIT 1 [ RunTime:0.000406s ]