SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.000910s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` `g` LEFT JOIN `zhimeng_category` `c` ON `g`.`cid`=`c`.`id` WHERE `is_recommend` = 1 AND `g`.`bid` = '5' AND `price` BETWEEN '20000' AND '30000' AND `g`.`cid` = '30' AND `g`.`status` = '1' AND `g`.`goodsCode` LIKE '%3016%' AND `g`.`range` LIKE '%角大茴香%' LIMIT 1 [ RunTime:0.383529s ]
SELECT `g`.*,c.title as ptitle FROM `zhimeng_goods` `g` LEFT JOIN `zhimeng_category` `c` ON `g`.`cid`=`c`.`id` WHERE `is_recommend` = 1 AND `g`.`bid` = '5' AND `price` BETWEEN '20000' AND '30000' AND `g`.`cid` = '30' AND `g`.`status` = '1' AND `g`.`goodsCode` LIKE '%3016%' AND `g`.`range` LIKE '%角大茴香%' ORDER BY `g`.`id` DESC LIMIT 0,30 [ RunTime:0.382063s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.000851s ]