SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.000887s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (18,4,24,38,36,32) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 6 ORDER BY `oid` DESC [ RunTime:1.103643s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `bid` = 3 AND `oid` IN (1054378,1054192,1021129,1001674,999473,994713,986402,973494,973454,968514,957113,951241,950674,950673,923935,923932,923931,923930,923926,923925,923922,923921,923916,923913,921902,921901,921900,921899,844657,844653,556734,543331,518557,518555,497098,477168,470482,452824,452823,445307,443456,442960,430927,375045,357133,337989,333198,324544,304802,299439,288728,281527,281515,281513,281511,199791,176626,170408,149006,149005,125393,123316,123313,98123,82221,6081,4942) AND `cid` IN (4,18,24,32,36,38) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.029223s ]
SELECT `id` FROM `zhimeng_goods` WHERE `bid` = 3 AND `oid` IN (1054378,1054192,1021129,1001674,999473,994713,986402,973494,973454,968514,957113,951241,950674,950673,923935,923932,923931,923930,923926,923925,923922,923921,923916,923913,921902,921901,921900,921899,844657,844653,556734,543331,518557,518555,497098,477168,470482,452824,452823,445307,443456,442960,430927,375045,357133,337989,333198,324544,304802,299439,288728,281527,281515,281513,281511,199791,176626,170408,149006,149005,125393,123316,123313,98123,82221,6081,4942) AND `cid` IN (4,18,24,32,36,38) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.021376s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.004788s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.002023s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 18_4_24_38_36_32 LIMIT 1 [ RunTime:0.000393s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 27700 LIMIT 1 [ RunTime:0.000545s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 563300 LIMIT 1 [ RunTime:0.000776s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 563307 LIMIT 1 [ RunTime:0.000602s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 563311 LIMIT 1 [ RunTime:0.000609s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 563313 LIMIT 1 [ RunTime:0.001346s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 407307 LIMIT 1 [ RunTime:0.000710s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 410014 LIMIT 1 [ RunTime:0.004627s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 410304 LIMIT 1 [ RunTime:0.002682s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 410439 LIMIT 1 [ RunTime:0.000552s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 746380 LIMIT 1 [ RunTime:0.000524s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 746161 LIMIT 1 [ RunTime:0.000543s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 747073 LIMIT 1 [ RunTime:0.000497s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 747199 LIMIT 1 [ RunTime:0.001857s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 747258 LIMIT 1 [ RunTime:0.004836s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 747262 LIMIT 1 [ RunTime:0.003584s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1366988 LIMIT 1 [ RunTime:0.002052s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1367001 LIMIT 1 [ RunTime:0.001110s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1367007 LIMIT 1 [ RunTime:0.000769s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1367014 LIMIT 1 [ RunTime:0.000710s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1367017 LIMIT 1 [ RunTime:0.000680s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1367019 LIMIT 1 [ RunTime:0.000682s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1366949 LIMIT 1 [ RunTime:0.000725s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1366957 LIMIT 1 [ RunTime:0.000916s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1366963 LIMIT 1 [ RunTime:0.000808s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1366971 LIMIT 1 [ RunTime:0.000662s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1366975 LIMIT 1 [ RunTime:0.000682s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1366977 LIMIT 1 [ RunTime:0.000672s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1367029 LIMIT 1 [ RunTime:0.000788s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1367043 LIMIT 1 [ RunTime:0.000684s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1367049 LIMIT 1 [ RunTime:0.000674s ]