SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.000695s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (10,17,22,24,37,42,32) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 7 ORDER BY `oid` DESC [ RunTime:0.924625s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `oid` IN (1060132,1054378,1001674,999440,994713,986402,973454,968514,957113,951241,950674,950673,928091,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921900,921899,600328,556734,543331,518557,518555,499336,477168,470482,455362,452824,452823,445307,443456,442960,430927,388561,357133,347688,333198,299439,288728,281527,281513,281512,281511,279965,176626,171457,170408,149006,50956,6081,4942) AND `cid` IN (10,17,22,24,32,37,42) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.022566s ]
SELECT `id` FROM `zhimeng_goods` WHERE `oid` IN (1060132,1054378,1001674,999440,994713,986402,973454,968514,957113,951241,950674,950673,928091,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921900,921899,600328,556734,543331,518557,518555,499336,477168,470482,455362,452824,452823,445307,443456,442960,430927,388561,357133,347688,333198,299439,288728,281527,281513,281512,281511,279965,176626,171457,170408,149006,50956,6081,4942) AND `cid` IN (10,17,22,24,32,37,42) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.017338s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.000755s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.000764s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 10_17_22_24_37_42_32 LIMIT 1 [ RunTime:0.000301s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207511 LIMIT 1 [ RunTime:0.000515s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285551 LIMIT 1 [ RunTime:0.000722s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285680 LIMIT 1 [ RunTime:0.000632s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 211067 LIMIT 1 [ RunTime:0.000547s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313411 LIMIT 1 [ RunTime:0.000518s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313504 LIMIT 1 [ RunTime:0.000558s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313584 LIMIT 1 [ RunTime:0.000482s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285479 LIMIT 1 [ RunTime:0.000475s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285552 LIMIT 1 [ RunTime:0.000487s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285681 LIMIT 1 [ RunTime:0.000545s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313246 LIMIT 1 [ RunTime:0.000471s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313412 LIMIT 1 [ RunTime:0.000526s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313505 LIMIT 1 [ RunTime:0.000460s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313583 LIMIT 1 [ RunTime:0.000647s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 288991 LIMIT 1 [ RunTime:0.000526s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353195 LIMIT 1 [ RunTime:0.000528s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354463 LIMIT 1 [ RunTime:0.000532s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354465 LIMIT 1 [ RunTime:0.000544s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354486 LIMIT 1 [ RunTime:0.000456s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354511 LIMIT 1 [ RunTime:0.000448s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354525 LIMIT 1 [ RunTime:0.000468s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 592811 LIMIT 1 [ RunTime:0.000464s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 592819 LIMIT 1 [ RunTime:0.000458s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 592824 LIMIT 1 [ RunTime:0.000530s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 592827 LIMIT 1 [ RunTime:0.000534s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 592837 LIMIT 1 [ RunTime:0.000472s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 648255 LIMIT 1 [ RunTime:0.000470s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 592845 LIMIT 1 [ RunTime:0.000454s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 563289 LIMIT 1 [ RunTime:0.000481s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 563296 LIMIT 1 [ RunTime:0.000556s ]