SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.000673s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (3,8,15,22,27,36,39) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 7 ORDER BY `oid` DESC [ RunTime:4.642476s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `oid` IN (1054378,1053011,1001674,999601,986402,973454,968514,957113,951241,950674,950673,928091,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921900,921899,880309,880308,880307,880306,880305,844653,597719,556734,543331,541123,518557,518555,499336,470482,455362,452824,452823,445307,443456,442960,442591,398060,363346,357133,333198,304802,288728,281527,281515,281513,281512,281511,279965,243998,176626,149006,98834,50942,30038,23905,6081,4942) AND `cid` IN (3,8,15,22,27,36,39) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.011010s ]
SELECT `id` FROM `zhimeng_goods` WHERE `oid` IN (1054378,1053011,1001674,999601,986402,973454,968514,957113,951241,950674,950673,928091,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921900,921899,880309,880308,880307,880306,880305,844653,597719,556734,543331,541123,518557,518555,499336,470482,455362,452824,452823,445307,443456,442960,442591,398060,363346,357133,333198,304802,288728,281527,281515,281513,281512,281511,279965,243998,176626,149006,98834,50942,30038,23905,6081,4942) AND `cid` IN (3,8,15,22,27,36,39) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.010505s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.000640s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.000615s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 3_8_15_22_27_36_39 LIMIT 1 [ RunTime:0.000812s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278977 LIMIT 1 [ RunTime:0.000769s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278997 LIMIT 1 [ RunTime:0.000715s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207709 LIMIT 1 [ RunTime:0.000500s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285680 LIMIT 1 [ RunTime:0.000487s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 211218 LIMIT 1 [ RunTime:0.000499s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 241914 LIMIT 1 [ RunTime:0.000481s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313537 LIMIT 1 [ RunTime:0.000466s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278978 LIMIT 1 [ RunTime:0.000454s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278995 LIMIT 1 [ RunTime:0.000473s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285535 LIMIT 1 [ RunTime:0.000473s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285681 LIMIT 1 [ RunTime:0.000472s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313347 LIMIT 1 [ RunTime:0.000460s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 241881 LIMIT 1 [ RunTime:0.000479s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313538 LIMIT 1 [ RunTime:0.000453s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 383567 LIMIT 1 [ RunTime:0.000458s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353989 LIMIT 1 [ RunTime:0.000489s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 355047 LIMIT 1 [ RunTime:0.000513s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 356207 LIMIT 1 [ RunTime:0.000470s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 357771 LIMIT 1 [ RunTime:0.000559s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353542 LIMIT 1 [ RunTime:0.000488s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353634 LIMIT 1 [ RunTime:0.000492s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 383561 LIMIT 1 [ RunTime:0.000504s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353958 LIMIT 1 [ RunTime:0.000469s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 355020 LIMIT 1 [ RunTime:0.000488s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 356185 LIMIT 1 [ RunTime:0.000483s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 357701 LIMIT 1 [ RunTime:0.000470s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353527 LIMIT 1 [ RunTime:0.000507s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353624 LIMIT 1 [ RunTime:0.000484s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 262784 LIMIT 1 [ RunTime:0.000494s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 262850 LIMIT 1 [ RunTime:0.000505s ]