SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.001176s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (37,22,17,10,19,1,33,44,40) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 9 ORDER BY `oid` DESC [ RunTime:2.585170s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `oid` IN (1060132,1054378,1001674,999440,986402,973454,968514,951241,950674,950673,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921900,921899,915069,880309,880308,880307,880306,880305,556734,543331,518557,518555,477168,470482,455362,452824,452823,445307,444221,443456,442960,431483,333198,281527,281513,281512,281511,176626,171457,50956,6081,4942) AND `cid` IN (1,10,17,19,22,33,37,40,44) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.026758s ]
SELECT `id` FROM `zhimeng_goods` WHERE `oid` IN (1060132,1054378,1001674,999440,986402,973454,968514,951241,950674,950673,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921900,921899,915069,880309,880308,880307,880306,880305,556734,543331,518557,518555,477168,470482,455362,452824,452823,445307,444221,443456,442960,431483,333198,281527,281513,281512,281511,176626,171457,50956,6081,4942) AND `cid` IN (1,10,17,19,22,33,37,40,44) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.013862s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.001171s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.001110s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 37_22_17_10_19_1_33_44_40 LIMIT 1 [ RunTime:0.008660s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207080 LIMIT 1 [ RunTime:0.000846s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207511 LIMIT 1 [ RunTime:0.000797s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285551 LIMIT 1 [ RunTime:0.001998s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285585 LIMIT 1 [ RunTime:0.000870s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285680 LIMIT 1 [ RunTime:0.000978s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 213462 LIMIT 1 [ RunTime:0.001143s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313504 LIMIT 1 [ RunTime:0.003929s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313556 LIMIT 1 [ RunTime:0.000813s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313645 LIMIT 1 [ RunTime:0.012058s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278957 LIMIT 1 [ RunTime:0.010023s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285479 LIMIT 1 [ RunTime:0.002158s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285552 LIMIT 1 [ RunTime:0.000927s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285586 LIMIT 1 [ RunTime:0.001108s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285681 LIMIT 1 [ RunTime:0.002822s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313420 LIMIT 1 [ RunTime:0.000867s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313505 LIMIT 1 [ RunTime:0.000824s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313555 LIMIT 1 [ RunTime:0.000775s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313644 LIMIT 1 [ RunTime:0.000771s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353116 LIMIT 1 [ RunTime:0.000719s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 288991 LIMIT 1 [ RunTime:0.000774s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353195 LIMIT 1 [ RunTime:0.000712s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 289001 LIMIT 1 [ RunTime:0.000715s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354463 LIMIT 1 [ RunTime:0.000457s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 289123 LIMIT 1 [ RunTime:0.000817s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354511 LIMIT 1 [ RunTime:0.000723s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354518 LIMIT 1 [ RunTime:0.000742s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354555 LIMIT 1 [ RunTime:0.000722s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30385 LIMIT 1 [ RunTime:0.000646s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30394 LIMIT 1 [ RunTime:0.000635s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30401 LIMIT 1 [ RunTime:0.000659s ]