SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.001220s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (22,4,6,40,27,2,21) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 7 ORDER BY `oid` DESC [ RunTime:1.962220s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `oid` IN (1060132,1054378,1001674,994713,986402,973454,968514,951241,950677,950674,950673,940708,940703,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921900,921899,880309,880308,880307,880306,880305,844657,844653,635458,597719,556734,543331,534067,518557,518556,518555,477168,470482,455362,452824,452823,445307,443456,442960,399875,398060,368280,333198,299437,281527,281513,281512,281511,205652,176626,171457,170408,98834,50956,50942,23134,6081,4942) AND `cid` IN (2,4,6,21,22,27,40) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.064298s ]
SELECT `id` FROM `zhimeng_goods` WHERE `oid` IN (1060132,1054378,1001674,994713,986402,973454,968514,951241,950677,950674,950673,940708,940703,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921900,921899,880309,880308,880307,880306,880305,844657,844653,635458,597719,556734,543331,534067,518557,518556,518555,477168,470482,455362,452824,452823,445307,443456,442960,399875,398060,368280,333198,299437,281527,281513,281512,281511,205652,176626,171457,170408,98834,50956,50942,23134,6081,4942) AND `cid` IN (2,4,6,21,22,27,40) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 90,30 [ RunTime:0.025208s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.001084s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.001116s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 22_4_6_40_27_2_21 LIMIT 1 [ RunTime:0.000623s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 213972 LIMIT 1 [ RunTime:0.001400s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207121 LIMIT 1 [ RunTime:0.001301s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207209 LIMIT 1 [ RunTime:0.025589s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207248 LIMIT 1 [ RunTime:0.031417s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 210444 LIMIT 1 [ RunTime:0.016762s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 428235 LIMIT 1 [ RunTime:0.039126s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 211197 LIMIT 1 [ RunTime:0.013813s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 213969 LIMIT 1 [ RunTime:0.005136s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 425609 LIMIT 1 [ RunTime:0.017358s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 464766 LIMIT 1 [ RunTime:0.039254s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 425781 LIMIT 1 [ RunTime:0.019488s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 427319 LIMIT 1 [ RunTime:0.005295s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 427588 LIMIT 1 [ RunTime:0.021772s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 464783 LIMIT 1 [ RunTime:0.016022s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 427677 LIMIT 1 [ RunTime:0.003808s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 311291 LIMIT 1 [ RunTime:0.002810s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 311357 LIMIT 1 [ RunTime:0.004291s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 311403 LIMIT 1 [ RunTime:0.004587s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 311666 LIMIT 1 [ RunTime:0.004181s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 311679 LIMIT 1 [ RunTime:0.001221s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 311806 LIMIT 1 [ RunTime:0.001028s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 312248 LIMIT 1 [ RunTime:0.008319s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 383501 LIMIT 1 [ RunTime:0.001406s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 383623 LIMIT 1 [ RunTime:0.005141s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 383687 LIMIT 1 [ RunTime:0.013119s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 384137 LIMIT 1 [ RunTime:0.001264s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 384171 LIMIT 1 [ RunTime:0.000887s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 384594 LIMIT 1 [ RunTime:0.000752s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 386259 LIMIT 1 [ RunTime:0.001470s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 456106 LIMIT 1 [ RunTime:0.027109s ]