SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.000781s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (7,8,19,27,32,26,5) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 7 ORDER BY `oid` DESC [ RunTime:4.392697s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `oid` IN (1054378,1043049,1009629,1001674,999438,994713,986440,986402,973494,973455,973454,968514,957113,951241,950674,950673,940710,940708,940703,928091,923935,923932,923931,923930,923926,923925,923923,923922,923921,923918,923916,922809,921902,921901,921900,921899,915107,844657,603362,556734,543331,541564,534067,518557,518555,499336,470482,455362,452824,452823,448585,445307,443456,442960,398060,375045,368280,357133,347688,333198,279965,233035,199791,191988,176626,171457) AND `cid` IN (5,7,8,19,26,27,32) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.026055s ]
SELECT `id` FROM `zhimeng_goods` WHERE `oid` IN (1054378,1043049,1009629,1001674,999438,994713,986440,986402,973494,973455,973454,968514,957113,951241,950674,950673,940710,940708,940703,928091,923935,923932,923931,923930,923926,923925,923923,923922,923921,923918,923916,922809,921902,921901,921900,921899,915107,844657,603362,556734,543331,541564,534067,518557,518555,499336,470482,455362,452824,452823,448585,445307,443456,442960,398060,375045,368280,357133,347688,333198,279965,233035,199791,191988,176626,171457) AND `cid` IN (5,7,8,19,26,27,32) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.019648s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.000860s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.000802s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 7_8_19_27_32_26_5 LIMIT 1 [ RunTime:0.000373s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30389 LIMIT 1 [ RunTime:0.000970s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30391 LIMIT 1 [ RunTime:0.000558s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30392 LIMIT 1 [ RunTime:0.000447s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30403 LIMIT 1 [ RunTime:0.000464s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30410 LIMIT 1 [ RunTime:0.000422s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30411 LIMIT 1 [ RunTime:0.000549s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30416 LIMIT 1 [ RunTime:0.000448s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 39840 LIMIT 1 [ RunTime:0.000417s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 864084 LIMIT 1 [ RunTime:0.000465s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 864090 LIMIT 1 [ RunTime:0.000514s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 864133 LIMIT 1 [ RunTime:0.000434s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 864166 LIMIT 1 [ RunTime:0.000451s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 864167 LIMIT 1 [ RunTime:0.000422s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 864188 LIMIT 1 [ RunTime:0.000524s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1308762 LIMIT 1 [ RunTime:0.000442s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1308759 LIMIT 1 [ RunTime:0.000545s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1308765 LIMIT 1 [ RunTime:0.000472s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1308758 LIMIT 1 [ RunTime:0.000421s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1308780 LIMIT 1 [ RunTime:0.000437s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1308775 LIMIT 1 [ RunTime:0.000587s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1308771 LIMIT 1 [ RunTime:0.000448s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 77923 LIMIT 1 [ RunTime:0.000410s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 77926 LIMIT 1 [ RunTime:0.000458s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 77928 LIMIT 1 [ RunTime:0.000424s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 77925 LIMIT 1 [ RunTime:0.000411s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 77927 LIMIT 1 [ RunTime:0.000420s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 77929 LIMIT 1 [ RunTime:0.000413s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 77938 LIMIT 1 [ RunTime:0.000504s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 77943 LIMIT 1 [ RunTime:0.000419s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 77948 LIMIT 1 [ RunTime:0.000442s ]