SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.001306s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (18,4,24,38,20,40,23) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 7 ORDER BY `oid` DESC [ RunTime:1.324257s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `oid` IN (1054378,1054192,1053011,1021136,1001674,994713,986402,973454,968514,957113,951241,950684,950674,950673,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921900,921899,844657,844653,556734,543331,518557,518555,477168,470482,452824,452823,445307,443456,442960,353983,347688,333198,296510,288728,281527,281515,281513,281511,205652,176626,149006,149005,138201,138200,125393,123316,123313,98834,82221,50942,23905,23134,6081,4942) AND `cid` IN (4,18,20,23,24,38,40) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.012422s ]
SELECT `id` FROM `zhimeng_goods` WHERE `oid` IN (1054378,1054192,1053011,1021136,1001674,994713,986402,973454,968514,957113,951241,950684,950674,950673,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921900,921899,844657,844653,556734,543331,518557,518555,477168,470482,452824,452823,445307,443456,442960,353983,347688,333198,296510,288728,281527,281515,281513,281511,205652,176626,149006,149005,138201,138200,125393,123316,123313,98834,82221,50942,23905,23134,6081,4942) AND `cid` IN (4,18,20,23,24,38,40) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.011859s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.000762s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.000713s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 18_4_24_38_20_40_23 LIMIT 1 [ RunTime:0.000335s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207220 LIMIT 1 [ RunTime:0.000813s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285581 LIMIT 1 [ RunTime:0.000684s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 210340 LIMIT 1 [ RunTime:0.000590s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285715 LIMIT 1 [ RunTime:0.000552s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 211067 LIMIT 1 [ RunTime:0.000535s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313531 LIMIT 1 [ RunTime:0.000524s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313556 LIMIT 1 [ RunTime:0.000491s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278984 LIMIT 1 [ RunTime:0.001340s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285582 LIMIT 1 [ RunTime:0.001354s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285603 LIMIT 1 [ RunTime:0.001209s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285716 LIMIT 1 [ RunTime:0.002309s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313246 LIMIT 1 [ RunTime:0.001347s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313532 LIMIT 1 [ RunTime:0.001372s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313555 LIMIT 1 [ RunTime:0.000913s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353844 LIMIT 1 [ RunTime:0.001189s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 355232 LIMIT 1 [ RunTime:0.000756s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 355321 LIMIT 1 [ RunTime:0.001136s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 356411 LIMIT 1 [ RunTime:0.001711s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 356749 LIMIT 1 [ RunTime:0.002145s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353595 LIMIT 1 [ RunTime:0.000674s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353662 LIMIT 1 [ RunTime:0.000678s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353855 LIMIT 1 [ RunTime:0.000729s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 355262 LIMIT 1 [ RunTime:0.000689s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 355326 LIMIT 1 [ RunTime:0.000639s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 356423 LIMIT 1 [ RunTime:0.000693s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 356772 LIMIT 1 [ RunTime:0.000655s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353613 LIMIT 1 [ RunTime:0.000632s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353670 LIMIT 1 [ RunTime:0.000768s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 262787 LIMIT 1 [ RunTime:0.000686s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 262972 LIMIT 1 [ RunTime:0.000664s ]