SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.000819s ]
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` = '9' AND `price` BETWEEN '20000' AND '30000' AND `g`.`cid` = '19' AND `g`.`status` = '1' AND `g`.`goodsCode` LIKE '%1909%' AND `g`.`range` LIKE '%非金属门框%' LIMIT 1 [ RunTime:0.401536s ]
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` = '9' AND `price` BETWEEN '20000' AND '30000' AND `g`.`cid` = '19' AND `g`.`status` = '1' AND `g`.`goodsCode` LIKE '%1909%' AND `g`.`range` LIKE '%非金属门框%' ORDER BY `g`.`id` DESC LIMIT 0,30 [ RunTime:0.509997s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.001183s ]