SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.000900s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `price` < '10000' AND `oid` IN (1054378,1045064,1043049,1009629,1007701,1007418,1007413,1007342,1001674,999438,994713,986440,986402,973494,973455,973454,968514,957113,951241,950674,950673,940710,940708,940703,928091,923935,923932,923931,923930,923928,923926,923925,923923,923922,923921,923918,923916,922809,921902,921901,921900,921899,915107,880309,880308,880307,880306,880305,844657,603362,600328,556734,543331,541564,534067,518560,518557,518555,499336,470482,455362,452824,452823,448585,445307,444267,444247,444221,443456,443038,442960,442593,441767,399875,398060,375045,368280,357787,357133,347688,333198,299439,281527,281513,281512,281511,279965,233035,199791,191988,176626,171863,171457,123308,82221,6081,4942,28) AND `cid` IN (7,8,19,26,27,32) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.042112s ]
SELECT `id` FROM `zhimeng_goods` WHERE `price` < '10000' AND `oid` IN (1054378,1045064,1043049,1009629,1007701,1007418,1007413,1007342,1001674,999438,994713,986440,986402,973494,973455,973454,968514,957113,951241,950674,950673,940710,940708,940703,928091,923935,923932,923931,923930,923928,923926,923925,923923,923922,923921,923918,923916,922809,921902,921901,921900,921899,915107,880309,880308,880307,880306,880305,844657,603362,600328,556734,543331,541564,534067,518560,518557,518555,499336,470482,455362,452824,452823,448585,445307,444267,444247,444221,443456,443038,442960,442593,441767,399875,398060,375045,368280,357787,357133,347688,333198,299439,281527,281513,281512,281511,279965,233035,199791,191988,176626,171863,171457,123308,82221,6081,4942,28) AND `cid` IN (7,8,19,26,27,32) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.031889s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.000849s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 321270 LIMIT 1 [ RunTime:0.001161s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 321271 LIMIT 1 [ RunTime:0.000932s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 321277 LIMIT 1 [ RunTime:0.000738s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 321276 LIMIT 1 [ RunTime:0.000711s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 321391 LIMIT 1 [ RunTime:0.000679s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 321454 LIMIT 1 [ RunTime:0.000641s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313092 LIMIT 1 [ RunTime:0.000735s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278997 LIMIT 1 [ RunTime:0.000558s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285585 LIMIT 1 [ RunTime:0.000532s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 211165 LIMIT 1 [ RunTime:0.000551s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 211218 LIMIT 1 [ RunTime:0.000493s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313411 LIMIT 1 [ RunTime:0.000519s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353934 LIMIT 1 [ RunTime:0.000521s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353979 LIMIT 1 [ RunTime:0.000484s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 355284 LIMIT 1 [ RunTime:0.000517s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 357662 LIMIT 1 [ RunTime:0.000510s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 357757 LIMIT 1 [ RunTime:0.000482s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 358645 LIMIT 1 [ RunTime:0.000513s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 472565 LIMIT 1 [ RunTime:0.000550s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 472572 LIMIT 1 [ RunTime:0.000478s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 471581 LIMIT 1 [ RunTime:0.000511s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 471655 LIMIT 1 [ RunTime:0.000481s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 471671 LIMIT 1 [ RunTime:0.000482s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 471715 LIMIT 1 [ RunTime:0.000523s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30982 LIMIT 1 [ RunTime:0.000499s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 31000 LIMIT 1 [ RunTime:0.000506s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 31217 LIMIT 1 [ RunTime:0.000421s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 31318 LIMIT 1 [ RunTime:0.000405s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 31345 LIMIT 1 [ RunTime:0.000445s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 31419 LIMIT 1 [ RunTime:0.000403s ]