SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.000702s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `bid` = 1 AND `oid` IN (1054378,1012509,1001674,999589,999440,994713,986402,973454,973452,968514,957113,951241,950684,950674,950673,928091,923932,923931,923930,923926,923925,923923,923922,923921,923916,922809,921902,921901,921900,921899,915119,915107,915089,915083,915077,915075,915073,915061,915060,844653,612528,597719,556734,543331,534066,518557,518555,499336,482328,477168,459599,455362,452824,452823,448875,445307,443456,442960,442426,357133,337989,333198,299439,281527,281513,281512,281511,279965,243998,243080,243077,199791,198439,171457,134160,98834,50956,23134,6081,4942) AND `cid` IN (6,11,12,24,36,45) AND `bid` IN (1,2,3,9) AND `status` = 1 AND `range` LIKE '%拖把%' LIMIT 1 [ RunTime:0.038018s ]
SELECT `id` FROM `zhimeng_goods` WHERE `bid` = 1 AND `oid` IN (1054378,1012509,1001674,999589,999440,994713,986402,973454,973452,968514,957113,951241,950684,950674,950673,928091,923932,923931,923930,923926,923925,923923,923922,923921,923916,922809,921902,921901,921900,921899,915119,915107,915089,915083,915077,915075,915073,915061,915060,844653,612528,597719,556734,543331,534066,518557,518555,499336,482328,477168,459599,455362,452824,452823,448875,445307,443456,442960,442426,357133,337989,333198,299439,281527,281513,281512,281511,279965,243998,243080,243077,199791,198439,171457,134160,98834,50956,23134,6081,4942) AND `cid` IN (6,11,12,24,36,45) AND `bid` IN (1,2,3,9) AND `status` = 1 AND `range` LIKE '%拖把%' ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.021696s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.000841s ]