SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.001217s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (27,28,37) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 3 ORDER BY `oid` DESC [ RunTime:0.380373s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `bid` = 6 AND `price` > '30000' AND `oid` IN (1058838,1058005,1054378,1054192,1053011,1045064,1031950,1007794,1001674,999589,994713,986440,986402,973494,973455,973454,973452,973450,968520,968515,968514,957113,951241,950684,950674,950673,928091,923935,923932,923931,923930,923926,923925,923923,923922,923921,923917,923916,923913,922809,921902,921901,921900,921899,915219,915199,915132,915119,915118,915110,915107,915099,915089,915083,915082,915077,915075,915074,915073,915072,915070,915069,915061,915060,906461,906370,906282,906250,906184,906062,906025,904347,901127,880309,880308,880307,880306,880305,844657,844653,721566,697411,696649,696444,696149,696031,695908,695894,695877,695873,695800,695623,695603,694946,694480,694479,694467,694464,691688,671584,669707,662287,645469,632421,612446,603360,600330,600328,600327,597719,586232,556734,556068,550104,543331,542755,541564,541123,534067,534066,531627,518557,518555,506944,499336,497098,494407,489697,487140,482328,480613,477168,470485,470482,459206,455362,455183,452824,452823,449814,448585,445307,443456,442960,442914,419000,418947,409698,399875,398060,398059,390912,378961,378426,377353,375045,368311,368281,368280,368274,363347,363346,357787,357133,353995,353987,353983,347688,341191,335876,333198,329748,326849,324545,324544,311249,303062,303061,299439,299437,296510,288728,281527,281513,281512,281511,279965,255308,254669,250744,247167,244462,243998,235409,224898,218717,205652,199791,194996,192518,190753,190166,190109,187584,176626,171863,171861,171852,171457,170475,170408,167076,165311,160505,159514,154908,150018,149156,149047,149006,149005,138200,136210,134160,132006,131672,131635,131626,129017,128988,125393,123495,123412,123353,123322,123316,123313,123312,123177,100392,100367,98834,84121,60436,50956,50942,47653,46812,28795,23905,23896,23134,8149,6081,5874,4942,4898) AND `cid` IN (27,28,37) AND `bid` IN (1,2,3,9) AND `status` = 1 AND `range` LIKE '%录音装置%' LIMIT 1 [ RunTime:0.002252s ]
SELECT `id` FROM `zhimeng_goods` WHERE `bid` = 6 AND `price` > '30000' AND `oid` IN (1058838,1058005,1054378,1054192,1053011,1045064,1031950,1007794,1001674,999589,994713,986440,986402,973494,973455,973454,973452,973450,968520,968515,968514,957113,951241,950684,950674,950673,928091,923935,923932,923931,923930,923926,923925,923923,923922,923921,923917,923916,923913,922809,921902,921901,921900,921899,915219,915199,915132,915119,915118,915110,915107,915099,915089,915083,915082,915077,915075,915074,915073,915072,915070,915069,915061,915060,906461,906370,906282,906250,906184,906062,906025,904347,901127,880309,880308,880307,880306,880305,844657,844653,721566,697411,696649,696444,696149,696031,695908,695894,695877,695873,695800,695623,695603,694946,694480,694479,694467,694464,691688,671584,669707,662287,645469,632421,612446,603360,600330,600328,600327,597719,586232,556734,556068,550104,543331,542755,541564,541123,534067,534066,531627,518557,518555,506944,499336,497098,494407,489697,487140,482328,480613,477168,470485,470482,459206,455362,455183,452824,452823,449814,448585,445307,443456,442960,442914,419000,418947,409698,399875,398060,398059,390912,378961,378426,377353,375045,368311,368281,368280,368274,363347,363346,357787,357133,353995,353987,353983,347688,341191,335876,333198,329748,326849,324545,324544,311249,303062,303061,299439,299437,296510,288728,281527,281513,281512,281511,279965,255308,254669,250744,247167,244462,243998,235409,224898,218717,205652,199791,194996,192518,190753,190166,190109,187584,176626,171863,171861,171852,171457,170475,170408,167076,165311,160505,159514,154908,150018,149156,149047,149006,149005,138200,136210,134160,132006,131672,131635,131626,129017,128988,125393,123495,123412,123353,123322,123316,123313,123312,123177,100392,100367,98834,84121,60436,50956,50942,47653,46812,28795,23905,23896,23134,8149,6081,5874,4942,4898) AND `cid` IN (27,28,37) AND `bid` IN (1,2,3,9) AND `status` = 1 AND `range` LIKE '%录音装置%' ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.002084s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.000703s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.000590s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 27_28_37 LIMIT 1 [ RunTime:0.000667s ]