SHOW FULL COLUMNS FROM `yzn_cms_product` [ RunTime:0.000772s ]
SELECT COUNT(*) AS think_count FROM `yzn_cms_product` WHERE ( `status` = '1' AND `trade` = '2' AND `type` = '5' AND `status`=1 AND `catid` = 5 ) [ RunTime:0.000457s ]
SELECT * FROM `yzn_cms_product` WHERE ( `status` = '1' AND `trade` = '2' AND `type` = '5' AND `status`=1 AND `catid` = 5 ) ORDER BY `listorder` DESC LIMIT 0,8 [ RunTime:0.000434s ]