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