SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.001315s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `bid` = 10 AND `price` BETWEEN '20000' AND '30000' AND `oid` IN (1060222,1054378,1043049,1012566,1012521,1009629,1001674,994713,986440,986402,957113,951241,923935,923932,923931,923930,923926,923925,923923,923922,923921,923916,923913,922813,922809,921902,921901,921900,921899,844657,844653,518244,470482,445307,357133,269747,199791,139440) AND `cid` IN (6,7,29,30,34) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.001704s ]
SELECT `id` FROM `zhimeng_goods` WHERE `bid` = 10 AND `price` BETWEEN '20000' AND '30000' AND `oid` IN (1060222,1054378,1043049,1012566,1012521,1009629,1001674,994713,986440,986402,957113,951241,923935,923932,923931,923930,923926,923925,923923,923922,923921,923916,923913,922813,922809,921902,921901,921900,921899,844657,844653,518244,470482,445307,357133,269747,199791,139440) AND `cid` IN (6,7,29,30,34) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.000931s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.001033s ]