SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.018395s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (31,11,23,45,22,8,2) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 7 ORDER BY `oid` DESC [ RunTime:1.347628s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `oid` IN (1054378,1045064,1009629,1001674,999440,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,603360,597719,556734,543331,541564,534067,518557,518555,499336,455362,455292,452824,452823,445307,443456,443042,442960,441793,399875,398060,357133,337989,333198,299437,288728,281527,281513,281512,281511,279965,243998,205652,176626,171457,98834,29057,6081,4942) AND `cid` IN (2,8,11,22,23,31,45) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.023525s ]
SELECT `id` FROM `zhimeng_goods` WHERE `oid` IN (1054378,1045064,1009629,1001674,999440,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,603360,597719,556734,543331,541564,534067,518557,518555,499336,455362,455292,452824,452823,445307,443456,443042,442960,441793,399875,398060,357133,337989,333198,299437,288728,281527,281513,281512,281511,279965,243998,205652,176626,171457,98834,29057,6081,4942) AND `cid` IN (2,8,11,22,23,31,45) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.020635s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.001037s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.000741s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 31_11_23_45_22_8_2 LIMIT 1 [ RunTime:0.001425s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278964 LIMIT 1 [ RunTime:0.000537s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278997 LIMIT 1 [ RunTime:0.000561s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285481 LIMIT 1 [ RunTime:0.000475s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285680 LIMIT 1 [ RunTime:0.000470s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285715 LIMIT 1 [ RunTime:0.000450s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313401 LIMIT 1 [ RunTime:0.000433s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313659 LIMIT 1 [ RunTime:0.000463s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278965 LIMIT 1 [ RunTime:0.000428s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278995 LIMIT 1 [ RunTime:0.000440s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285482 LIMIT 1 [ RunTime:0.000463s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285681 LIMIT 1 [ RunTime:0.000425s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285716 LIMIT 1 [ RunTime:0.000466s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313402 LIMIT 1 [ RunTime:0.000429s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313663 LIMIT 1 [ RunTime:0.000423s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 383546 LIMIT 1 [ RunTime:0.000449s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353993 LIMIT 1 [ RunTime:0.000429s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354122 LIMIT 1 [ RunTime:0.000457s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 356214 LIMIT 1 [ RunTime:0.000428s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 356425 LIMIT 1 [ RunTime:0.000451s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 358583 LIMIT 1 [ RunTime:0.000451s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353827 LIMIT 1 [ RunTime:0.000856s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 60876 LIMIT 1 [ RunTime:0.000723s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 60917 LIMIT 1 [ RunTime:0.000684s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 60955 LIMIT 1 [ RunTime:0.000663s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 61063 LIMIT 1 [ RunTime:0.000557s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 61064 LIMIT 1 [ RunTime:0.000541s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 61132 LIMIT 1 [ RunTime:0.000527s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 243249 LIMIT 1 [ RunTime:0.000569s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30386 LIMIT 1 [ RunTime:0.000523s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 30392 LIMIT 1 [ RunTime:0.000522s ]