SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.000870s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (13,16,41,42,40,11,18) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 7 ORDER BY `oid` DESC [ RunTime:5.040297s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `oid` IN (1054378,1054192,1001674,994713,986402,951241,950674,950673,928091,923932,923931,923930,923926,923925,923923,923922,923921,923916,923913,922809,921902,921901,921899,586821,543331,518557,518555,452824,452823,445307,443456,442960,442426,333198,288728,281527,281513,281511,176626,98834,50956,6081,4942) AND `cid` IN (11,13,16,18,40,41,42) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.015849s ]
SELECT `id` FROM `zhimeng_goods` WHERE `oid` IN (1054378,1054192,1001674,994713,986402,951241,950674,950673,928091,923932,923931,923930,923926,923925,923923,923922,923921,923916,923913,922809,921902,921901,921899,586821,543331,518557,518555,452824,452823,445307,443456,442960,442426,333198,288728,281527,281513,281511,176626,98834,50956,6081,4942) AND `cid` IN (11,13,16,18,40,41,42) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.010970s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.002002s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.001025s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 13_16_41_42_40_11_18 LIMIT 1 [ RunTime:0.003539s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285481 LIMIT 1 [ RunTime:0.002549s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207632 LIMIT 1 [ RunTime:0.002215s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285545 LIMIT 1 [ RunTime:0.000427s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285581 LIMIT 1 [ RunTime:0.001580s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313556 LIMIT 1 [ RunTime:0.001571s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313558 LIMIT 1 [ RunTime:0.001271s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313584 LIMIT 1 [ RunTime:0.001353s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285482 LIMIT 1 [ RunTime:0.001438s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285497 LIMIT 1 [ RunTime:0.001578s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285546 LIMIT 1 [ RunTime:0.000465s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285582 LIMIT 1 [ RunTime:0.003914s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313555 LIMIT 1 [ RunTime:0.002229s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313559 LIMIT 1 [ RunTime:0.001820s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313583 LIMIT 1 [ RunTime:0.001788s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 288995 LIMIT 1 [ RunTime:0.001745s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353190 LIMIT 1 [ RunTime:0.002244s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353193 LIMIT 1 [ RunTime:0.000490s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353200 LIMIT 1 [ RunTime:0.001290s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354518 LIMIT 1 [ RunTime:0.001176s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354520 LIMIT 1 [ RunTime:0.002771s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354525 LIMIT 1 [ RunTime:0.004391s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 60955 LIMIT 1 [ RunTime:0.009742s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 60977 LIMIT 1 [ RunTime:0.001334s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 60997 LIMIT 1 [ RunTime:0.005692s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 61006 LIMIT 1 [ RunTime:0.003051s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 328889 LIMIT 1 [ RunTime:0.002249s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 61213 LIMIT 1 [ RunTime:0.002089s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1123101 LIMIT 1 [ RunTime:0.002085s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 864104 LIMIT 1 [ RunTime:0.000316s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 864113 LIMIT 1 [ RunTime:0.002370s ]