SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.000829s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (37,22,17,10,19,4,33,28,11) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 9 ORDER BY `oid` DESC [ RunTime:6.138588s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `oid` IN (1054378,1001674,986402,973454,968514,957113,951241,950674,950673,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921900,921899,880309,880308,880307,880306,880305,556734,543331,541564,518557,518555,477168,470482,455362,452824,452823,445307,443456,442960,430927,398060,357133,347688,333198,329748,324544,299439,281527,281513,281512,281511,243998,176626,171457,50956,6081,4942) AND `cid` IN (4,10,11,17,19,22,28,33,37) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.022037s ]
SELECT `id` FROM `zhimeng_goods` WHERE `oid` IN (1054378,1001674,986402,973454,968514,957113,951241,950674,950673,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921900,921899,880309,880308,880307,880306,880305,556734,543331,541564,518557,518555,477168,470482,455362,452824,452823,445307,443456,442960,430927,398060,357133,347688,333198,329748,324544,299439,281527,281513,281512,281511,243998,176626,171457,50956,6081,4942) AND `cid` IN (4,10,11,17,19,22,28,33,37) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.013500s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.001026s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.000945s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 37_22_17_10_19_4_33_28_11 LIMIT 1 [ RunTime:0.000480s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207220 LIMIT 1 [ RunTime:0.000583s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207511 LIMIT 1 [ RunTime:0.000938s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285481 LIMIT 1 [ RunTime:0.000354s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285551 LIMIT 1 [ RunTime:0.000909s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285585 LIMIT 1 [ RunTime:0.000662s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285680 LIMIT 1 [ RunTime:0.000333s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313381 LIMIT 1 [ RunTime:0.000500s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 213462 LIMIT 1 [ RunTime:0.000466s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313504 LIMIT 1 [ RunTime:0.000473s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278984 LIMIT 1 [ RunTime:0.000453s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285479 LIMIT 1 [ RunTime:0.000460s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285482 LIMIT 1 [ RunTime:0.000283s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285552 LIMIT 1 [ RunTime:0.000480s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285586 LIMIT 1 [ RunTime:0.000493s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285681 LIMIT 1 [ RunTime:0.000325s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313382 LIMIT 1 [ RunTime:0.000541s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313420 LIMIT 1 [ RunTime:0.000503s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313505 LIMIT 1 [ RunTime:0.000500s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353166 LIMIT 1 [ RunTime:0.000527s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 288991 LIMIT 1 [ RunTime:0.000486s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 288995 LIMIT 1 [ RunTime:0.000296s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353195 LIMIT 1 [ RunTime:0.000483s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 289001 LIMIT 1 [ RunTime:0.000522s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354463 LIMIT 1 [ RunTime:0.000488s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 289119 LIMIT 1 [ RunTime:0.000482s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 289123 LIMIT 1 [ RunTime:0.000510s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354511 LIMIT 1 [ RunTime:0.000517s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30388 LIMIT 1 [ RunTime:0.000480s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30394 LIMIT 1 [ RunTime:0.000515s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30395 LIMIT 1 [ RunTime:0.000262s ]