SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.000960s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (40,44,14,9,17,18,13,21,15) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 9 ORDER BY `oid` DESC [ RunTime:4.510555s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `oid` IN (1054378,1001674,994713,986402,951241,950674,950673,928091,923932,923931,923930,923926,923925,923923,923922,923921,923916,922809,921902,921901,921900,921899,556734,543331,518557,518555,452824,452823,445307,443456,442960,399875,347688,333198,288728,281527,281513,281511,176626,171457,50956,6081,4942) AND `cid` IN (9,13,14,15,17,18,21,40,44) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.009811s ]
SELECT `id` FROM `zhimeng_goods` WHERE `oid` IN (1054378,1001674,994713,986402,951241,950674,950673,928091,923932,923931,923930,923926,923925,923923,923922,923921,923916,922809,921902,921901,921900,921899,556734,543331,518557,518555,452824,452823,445307,443456,442960,399875,347688,333198,288728,281527,281513,281511,176626,171457,50956,6081,4942) AND `cid` IN (9,13,14,15,17,18,21,40,44) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.006166s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.000861s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.000942s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 40_44_14_9_17_18_13_21_15 LIMIT 1 [ RunTime:0.000815s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278999 LIMIT 1 [ RunTime:0.000633s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207632 LIMIT 1 [ RunTime:0.001268s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207683 LIMIT 1 [ RunTime:0.000471s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207709 LIMIT 1 [ RunTime:0.000387s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285551 LIMIT 1 [ RunTime:0.000346s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285581 LIMIT 1 [ RunTime:0.000326s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285621 LIMIT 1 [ RunTime:0.001530s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313556 LIMIT 1 [ RunTime:0.003810s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313645 LIMIT 1 [ RunTime:0.000319s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 279000 LIMIT 1 [ RunTime:0.001191s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285497 LIMIT 1 [ RunTime:0.002088s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285530 LIMIT 1 [ RunTime:0.000314s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285535 LIMIT 1 [ RunTime:0.000305s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285552 LIMIT 1 [ RunTime:0.000306s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285582 LIMIT 1 [ RunTime:0.000311s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285622 LIMIT 1 [ RunTime:0.001384s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313555 LIMIT 1 [ RunTime:0.004100s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313644 LIMIT 1 [ RunTime:0.000306s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353175 LIMIT 1 [ RunTime:0.001088s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353190 LIMIT 1 [ RunTime:0.002609s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353191 LIMIT 1 [ RunTime:0.000309s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 289000 LIMIT 1 [ RunTime:0.000291s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353195 LIMIT 1 [ RunTime:0.000270s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353200 LIMIT 1 [ RunTime:0.000276s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 289110 LIMIT 1 [ RunTime:0.001195s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354518 LIMIT 1 [ RunTime:0.002495s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354555 LIMIT 1 [ RunTime:0.001639s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30393 LIMIT 1 [ RunTime:0.001161s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30397 LIMIT 1 [ RunTime:0.001012s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30398 LIMIT 1 [ RunTime:0.000694s ]