SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.001084s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `price` > '30000' AND `oid` IN (1054378,1045064,1021137,1021136,1021130,1021128,1009629,1007701,1006977,1001674,999440,999438,994713,986402,973454,968514,957113,951241,950674,950673,928091,923935,923932,923931,923930,923926,923925,923923,923922,923921,923916,922813,922811,922809,921902,921901,921900,921899,915069,906370,880309,880308,880307,880306,880305,844657,786973,744009,635458,612797,600331,600328,556734,543331,541564,541123,534067,534066,518557,518555,501832,499336,489484,477168,470485,470482,460817,455362,455292,452824,452823,445307,443471,443456,443038,442960,442426,441793,436870,433207,431483,427818,399875,398060,398059,390912,381067,368280,363347,357133,347688,337989,333198,324544,299437,295022,292848,281527,281513,281512,281511,279965,279908,248073,244492,243998,243096,235409,233035,218865,217507,214992,205652,199791,191988,190166,189930,176626,171863,171861,171457,159514,156383,149005,138418,138399,131965,131626,123308,98834,82221,50956,23905,23134,9040,6081,4942,28) AND `cid` IN (7,19,23) AND `bid` IN (1,2,3,9) AND `status` = 1 AND `range` LIKE '%美容院%' LIMIT 1 [ RunTime:0.043050s ]
SELECT `id` FROM `zhimeng_goods` WHERE `price` > '30000' AND `oid` IN (1054378,1045064,1021137,1021136,1021130,1021128,1009629,1007701,1006977,1001674,999440,999438,994713,986402,973454,968514,957113,951241,950674,950673,928091,923935,923932,923931,923930,923926,923925,923923,923922,923921,923916,922813,922811,922809,921902,921901,921900,921899,915069,906370,880309,880308,880307,880306,880305,844657,786973,744009,635458,612797,600331,600328,556734,543331,541564,541123,534067,534066,518557,518555,501832,499336,489484,477168,470485,470482,460817,455362,455292,452824,452823,445307,443471,443456,443038,442960,442426,441793,436870,433207,431483,427818,399875,398060,398059,390912,381067,368280,363347,357133,347688,337989,333198,324544,299437,295022,292848,281527,281513,281512,281511,279965,279908,248073,244492,243998,243096,235409,233035,218865,217507,214992,205652,199791,191988,190166,189930,176626,171863,171861,171457,159514,156383,149005,138418,138399,131965,131626,123308,98834,82221,50956,23905,23134,9040,6081,4942,28) AND `cid` IN (7,19,23) AND `bid` IN (1,2,3,9) AND `status` = 1 AND `range` LIKE '%美容院%' ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.025799s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.000758s ]