SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.000766s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `price` BETWEEN '1000' AND '2300' AND `cid` IN (42,7,43,11,22,45,9,40,20) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 9 ORDER BY `oid` DESC [ RunTime:0.325036s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `cid` IN (42,7,43,11,22,45,9,40,20) AND `oid` <> 2584 AND 0 = 1 AND `status` = 1 AND `price` < '10000' AND `price` > '1000' LIMIT 1 [ RunTime:0.000765s ]
SELECT `id`,`cid`,`oid`,`image`,`price`,`range` FROM `zhimeng_goods` WHERE `cid` IN (42,7,43,11,22,45,9,40,20) AND `oid` <> 2584 AND 0 = 1 AND `status` = 1 AND `price` < '10000' AND `price` > '1000' ORDER BY `oid` ASC,`cid` ASC,`id` DESC LIMIT 0,30 [ RunTime:0.000611s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.000589s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.000605s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 42_7_43_11_22_45_9_40_20 LIMIT 1 [ RunTime:0.000291s ]