SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.001300s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (10,12,23,31,45,1) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 6 ORDER BY `oid` DESC [ RunTime:3.203846s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `oid` IN (1060132,1054378,1001674,999440,994713,986402,973454,968514,957113,951241,950674,950673,928091,923932,923931,923930,923926,923925,923923,923922,923921,923916,922809,921902,921901,921900,921899,915069,880309,880308,880307,880306,880305,844657,844653,603360,597719,556734,543331,541564,534067,534066,518557,518555,499336,477168,455362,455292,452824,452823,445307,443456,443042,442960,357133,333198,281527,281515,281513,281512,281511,247167,243998,171457,170408,50956,6081,4942) AND `cid` IN (1,10,12,23,31,45) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.089901s ]
SELECT `id` FROM `zhimeng_goods` WHERE `oid` IN (1060132,1054378,1001674,999440,994713,986402,973454,968514,957113,951241,950674,950673,928091,923932,923931,923930,923926,923925,923923,923922,923921,923916,922809,921902,921901,921900,921899,915069,880309,880308,880307,880306,880305,844657,844653,603360,597719,556734,543331,541564,534067,534066,518557,518555,499336,477168,455362,455292,452824,452823,445307,443456,443042,442960,357133,333198,281527,281515,281513,281512,281511,247167,243998,171457,170408,50956,6081,4942) AND `cid` IN (1,10,12,23,31,45) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 30,30 [ RunTime:0.039186s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.027441s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.016679s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 10_12_23_31_45_1 LIMIT 1 [ RunTime:0.004151s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 530251 LIMIT 1 [ RunTime:0.000575s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 530404 LIMIT 1 [ RunTime:0.000681s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 530439 LIMIT 1 [ RunTime:0.004039s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 530612 LIMIT 1 [ RunTime:0.005234s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 530748 LIMIT 1 [ RunTime:0.002566s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 730219 LIMIT 1 [ RunTime:0.015694s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 514411 LIMIT 1 [ RunTime:0.002970s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 316672 LIMIT 1 [ RunTime:0.002286s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 507431 LIMIT 1 [ RunTime:0.007445s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 317341 LIMIT 1 [ RunTime:0.003840s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 507722 LIMIT 1 [ RunTime:0.015583s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 507927 LIMIT 1 [ RunTime:0.003621s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207066 LIMIT 1 [ RunTime:0.014786s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207433 LIMIT 1 [ RunTime:0.003715s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207581 LIMIT 1 [ RunTime:0.004453s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 428242 LIMIT 1 [ RunTime:0.001411s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 428283 LIMIT 1 [ RunTime:0.010738s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 214131 LIMIT 1 [ RunTime:0.001295s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207067 LIMIT 1 [ RunTime:0.003649s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207435 LIMIT 1 [ RunTime:0.001504s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207579 LIMIT 1 [ RunTime:0.001303s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 210925 LIMIT 1 [ RunTime:0.001372s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 213310 LIMIT 1 [ RunTime:0.001359s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 214133 LIMIT 1 [ RunTime:0.001227s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207068 LIMIT 1 [ RunTime:0.002225s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207436 LIMIT 1 [ RunTime:0.001436s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207580 LIMIT 1 [ RunTime:0.001667s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 210924 LIMIT 1 [ RunTime:0.001749s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 213309 LIMIT 1 [ RunTime:0.001876s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 214130 LIMIT 1 [ RunTime:0.001333s ]