SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.001289s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (2,11,13,26,31,21,23) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 7 ORDER BY `oid` DESC [ RunTime:5.306530s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `oid` IN (1054378,1054192,1045064,1001674,994713,986402,951241,950674,950673,928091,923935,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921900,921899,603360,597719,556734,543331,534067,518557,518555,455292,452824,452823,445307,443456,443042,442960,441793,399875,398060,333198,288728,281527,281513,281512,281511,205652,201556,191988,176626,171457,98834,50956,6081,4942) AND `cid` IN (2,11,13,21,23,26,31) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.018813s ]
SELECT `id` FROM `zhimeng_goods` WHERE `oid` IN (1054378,1054192,1045064,1001674,994713,986402,951241,950674,950673,928091,923935,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921900,921899,603360,597719,556734,543331,534067,518557,518555,455292,452824,452823,445307,443456,443042,442960,441793,399875,398060,333198,288728,281527,281513,281512,281511,205652,201556,191988,176626,171457,98834,50956,6081,4942) AND `cid` IN (2,11,13,21,23,26,31) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.012877s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.001080s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.000920s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 2_11_13_26_31_21_23 LIMIT 1 [ RunTime:0.001441s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278964 LIMIT 1 [ RunTime:0.001252s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285481 LIMIT 1 [ RunTime:0.000960s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207632 LIMIT 1 [ RunTime:0.000943s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285621 LIMIT 1 [ RunTime:0.000840s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285715 LIMIT 1 [ RunTime:0.000814s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 211165 LIMIT 1 [ RunTime:0.000782s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313401 LIMIT 1 [ RunTime:0.000718s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278965 LIMIT 1 [ RunTime:0.000707s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285482 LIMIT 1 [ RunTime:0.000730s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285497 LIMIT 1 [ RunTime:0.000697s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285622 LIMIT 1 [ RunTime:0.000672s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285716 LIMIT 1 [ RunTime:0.000667s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313324 LIMIT 1 [ RunTime:0.000684s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313402 LIMIT 1 [ RunTime:0.000686s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353117 LIMIT 1 [ RunTime:0.000690s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 288995 LIMIT 1 [ RunTime:0.000653s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353190 LIMIT 1 [ RunTime:0.000693s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 289110 LIMIT 1 [ RunTime:0.000666s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354464 LIMIT 1 [ RunTime:0.000672s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 289114 LIMIT 1 [ RunTime:0.000660s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 289120 LIMIT 1 [ RunTime:0.000687s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 60876 LIMIT 1 [ RunTime:0.000690s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 60955 LIMIT 1 [ RunTime:0.000619s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 60977 LIMIT 1 [ RunTime:0.005777s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 61060 LIMIT 1 [ RunTime:0.000662s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 61064 LIMIT 1 [ RunTime:0.000693s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 61090 LIMIT 1 [ RunTime:0.000691s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 61132 LIMIT 1 [ RunTime:0.000668s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30386 LIMIT 1 [ RunTime:0.000703s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30395 LIMIT 1 [ RunTime:0.000646s ]