SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.000902s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (43,3,15,22,27,8,36,32,38) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 9 ORDER BY `oid` DESC [ RunTime:5.882786s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `oid` IN (1054378,994713,986402,973454,968514,957113,951241,950674,950673,928091,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921900,921899,880309,880308,880307,880306,880305,844653,597719,556734,543331,518557,518555,499336,470482,455362,452824,452823,445307,443456,398060,333198,304802,299439,288728,281527,281515,281513,281512,281511,176626,149006,6081,4942) AND `cid` IN (3,8,15,22,27,32,36,38,43) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.025703s ]
SELECT `id` FROM `zhimeng_goods` WHERE `oid` IN (1054378,994713,986402,973454,968514,957113,951241,950674,950673,928091,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921900,921899,880309,880308,880307,880306,880305,844653,597719,556734,543331,518557,518555,499336,470482,455362,452824,452823,445307,443456,398060,333198,304802,299439,288728,281527,281515,281513,281512,281511,176626,149006,6081,4942) AND `cid` IN (3,8,15,22,27,32,36,38,43) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.025715s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.000967s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.004821s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 43_3_15_22_27_8_36_32_38 LIMIT 1 [ RunTime:0.000856s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278977 LIMIT 1 [ RunTime:0.001393s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278997 LIMIT 1 [ RunTime:0.001258s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207709 LIMIT 1 [ RunTime:0.007688s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285680 LIMIT 1 [ RunTime:0.004745s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 211218 LIMIT 1 [ RunTime:0.009981s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313411 LIMIT 1 [ RunTime:0.001001s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 241914 LIMIT 1 [ RunTime:0.004227s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313531 LIMIT 1 [ RunTime:0.003229s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 214065 LIMIT 1 [ RunTime:0.001669s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278978 LIMIT 1 [ RunTime:0.001390s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278995 LIMIT 1 [ RunTime:0.001313s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285535 LIMIT 1 [ RunTime:0.001422s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285681 LIMIT 1 [ RunTime:0.000821s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313347 LIMIT 1 [ RunTime:0.001360s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313412 LIMIT 1 [ RunTime:0.001269s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 241881 LIMIT 1 [ RunTime:0.001241s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313532 LIMIT 1 [ RunTime:0.001213s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313612 LIMIT 1 [ RunTime:0.000472s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 592796 LIMIT 1 [ RunTime:0.000523s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 592806 LIMIT 1 [ RunTime:0.000429s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 592815 LIMIT 1 [ RunTime:0.000401s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 592824 LIMIT 1 [ RunTime:0.000451s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 592829 LIMIT 1 [ RunTime:0.000406s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 592837 LIMIT 1 [ RunTime:0.000426s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 592841 LIMIT 1 [ RunTime:0.000422s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 592842 LIMIT 1 [ RunTime:0.000425s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 592846 LIMIT 1 [ RunTime:0.000490s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 864059 LIMIT 1 [ RunTime:0.000493s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 864090 LIMIT 1 [ RunTime:0.000417s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 864121 LIMIT 1 [ RunTime:0.000423s ]