SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.000839s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (34,37,28,33,36,16,18) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 7 ORDER BY `oid` DESC [ RunTime:5.328559s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `oid` IN (1054378,1054192,1031950,1001674,986402,957113,951241,923932,923931,923930,923926,923925,923923,923922,923921,923917,923916,922809,921902,921901,921899,445307,357133,176626) AND `cid` IN (16,18,28,33,34,36,37) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.007003s ]
SELECT `id` FROM `zhimeng_goods` WHERE `oid` IN (1054378,1054192,1031950,1001674,986402,957113,951241,923932,923931,923930,923926,923925,923923,923922,923921,923917,923916,922809,921902,921901,921899,445307,357133,176626) AND `cid` IN (16,18,28,33,34,36,37) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.004706s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.000820s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.000742s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 34_37_28_33_36_16_18 LIMIT 1 [ RunTime:0.000806s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 864124 LIMIT 1 [ RunTime:0.000481s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 864125 LIMIT 1 [ RunTime:0.004008s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 864129 LIMIT 1 [ RunTime:0.002746s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 864171 LIMIT 1 [ RunTime:0.002303s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 864198 LIMIT 1 [ RunTime:0.001954s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 864256 LIMIT 1 [ RunTime:0.001817s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 864261 LIMIT 1 [ RunTime:0.001804s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1590113 LIMIT 1 [ RunTime:0.001864s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1590115 LIMIT 1 [ RunTime:0.001817s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1590124 LIMIT 1 [ RunTime:0.001731s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1590285 LIMIT 1 [ RunTime:0.002084s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1663321 LIMIT 1 [ RunTime:0.001573s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1590287 LIMIT 1 [ RunTime:0.001525s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1590288 LIMIT 1 [ RunTime:0.001485s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1237352 LIMIT 1 [ RunTime:0.001399s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 854674 LIMIT 1 [ RunTime:0.001368s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 854964 LIMIT 1 [ RunTime:0.001387s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1366945 LIMIT 1 [ RunTime:0.001351s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 854959 LIMIT 1 [ RunTime:0.001281s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 854677 LIMIT 1 [ RunTime:0.001297s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 855041 LIMIT 1 [ RunTime:0.001300s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1363393 LIMIT 1 [ RunTime:0.001221s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1363463 LIMIT 1 [ RunTime:0.001191s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1363667 LIMIT 1 [ RunTime:0.001220s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1363845 LIMIT 1 [ RunTime:0.001207s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1363851 LIMIT 1 [ RunTime:0.001194s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1363868 LIMIT 1 [ RunTime:0.001227s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1363875 LIMIT 1 [ RunTime:0.001227s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1363391 LIMIT 1 [ RunTime:0.001187s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1363421 LIMIT 1 [ RunTime:0.001179s ]