SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.000712s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (2,7,11,15,42,41,35) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 7 ORDER BY `oid` DESC [ RunTime:4.009012s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `oid` IN (1054378,1053011,994713,986402,973494,973454,968514,957113,951241,950674,950673,928091,923935,923932,923931,923930,923926,923925,923923,923922,923921,923916,923913,922813,922809,921902,921901,921900,921899,880309,880308,880307,880306,880305,600328,556734,543331,534065,477168,470482,452824,452823,448587,445307,443456,442426,441793,435096,399875,398060,375045,357133,333198,281527,281513,281512,281511,279965,243080,199791,176626,126763,83641,50956,4942) AND `cid` IN (2,7,11,15,35,41,42) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.020961s ]
SELECT `id` FROM `zhimeng_goods` WHERE `oid` IN (1054378,1053011,994713,986402,973494,973454,968514,957113,951241,950674,950673,928091,923935,923932,923931,923930,923926,923925,923923,923922,923921,923916,923913,922813,922809,921902,921901,921900,921899,880309,880308,880307,880306,880305,600328,556734,543331,534065,477168,470482,452824,452823,448587,445307,443456,442426,441793,435096,399875,398060,375045,357133,333198,281527,281513,281512,281511,279965,243080,199791,176626,126763,83641,50956,4942) AND `cid` IN (2,7,11,15,35,41,42) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.012252s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.000705s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.000714s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 2_7_11_15_42_41_35 LIMIT 1 [ RunTime:0.000635s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278964 LIMIT 1 [ RunTime:0.000365s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313092 LIMIT 1 [ RunTime:0.000305s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285481 LIMIT 1 [ RunTime:0.000302s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207709 LIMIT 1 [ RunTime:0.000295s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 213535 LIMIT 1 [ RunTime:0.000568s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313558 LIMIT 1 [ RunTime:0.001406s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313584 LIMIT 1 [ RunTime:0.002662s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353117 LIMIT 1 [ RunTime:0.000293s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1142618 LIMIT 1 [ RunTime:0.001320s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 288995 LIMIT 1 [ RunTime:0.000286s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 289000 LIMIT 1 [ RunTime:0.000270s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354495 LIMIT 1 [ RunTime:0.001050s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354520 LIMIT 1 [ RunTime:0.003545s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354525 LIMIT 1 [ RunTime:0.003257s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 39530 LIMIT 1 [ RunTime:0.000750s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 576747 LIMIT 1 [ RunTime:0.000638s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 576751 LIMIT 1 [ RunTime:0.002010s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 576750 LIMIT 1 [ RunTime:0.000625s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 39562 LIMIT 1 [ RunTime:0.000696s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 576758 LIMIT 1 [ RunTime:0.000626s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 576748 LIMIT 1 [ RunTime:0.000642s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 39564 LIMIT 1 [ RunTime:0.000714s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1255066 LIMIT 1 [ RunTime:0.000658s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1255679 LIMIT 1 [ RunTime:0.000627s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1256225 LIMIT 1 [ RunTime:0.000625s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1256557 LIMIT 1 [ RunTime:0.000640s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1258340 LIMIT 1 [ RunTime:0.000639s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1258496 LIMIT 1 [ RunTime:0.000623s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1258596 LIMIT 1 [ RunTime:0.000629s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 39831 LIMIT 1 [ RunTime:0.000658s ]