SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.001166s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (16,4,44,24,22,17,28,1,15) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 9 ORDER BY `oid` DESC [ RunTime:5.660126s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `oid` IN (1054378,1053011,1001674,994713,986402,973454,968514,957113,951241,950674,950673,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921899,543331,518557,518555,499336,477168,455362,452824,452823,445307,443456,443038,442960,418947,390912,357133,333198,299439,281527,281515,281513,281512,281511,247167,243998,236591,176626,171457,170408,149006,98834,50956,6081,4942) AND `cid` IN (1,4,15,16,17,22,24,28,44) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.063974s ]
SELECT `id` FROM `zhimeng_goods` WHERE `oid` IN (1054378,1053011,1001674,994713,986402,973454,968514,957113,951241,950674,950673,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921899,543331,518557,518555,499336,477168,455362,452824,452823,445307,443456,443038,442960,418947,390912,357133,333198,299439,281527,281515,281513,281512,281511,247167,243998,236591,176626,171457,170408,149006,98834,50956,6081,4942) AND `cid` IN (1,4,15,16,17,22,24,28,44) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.022519s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.028920s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.021916s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 16_4_44_24_22_17_28_1_15 LIMIT 1 [ RunTime:0.014055s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207080 LIMIT 1 [ RunTime:0.024167s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207220 LIMIT 1 [ RunTime:0.009443s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 207709 LIMIT 1 [ RunTime:0.005079s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285545 LIMIT 1 [ RunTime:0.002416s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285551 LIMIT 1 [ RunTime:0.002662s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285680 LIMIT 1 [ RunTime:0.003169s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 211067 LIMIT 1 [ RunTime:0.003423s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313381 LIMIT 1 [ RunTime:0.002838s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313645 LIMIT 1 [ RunTime:0.005353s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278957 LIMIT 1 [ RunTime:0.003939s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 278984 LIMIT 1 [ RunTime:0.003529s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285535 LIMIT 1 [ RunTime:0.004534s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285546 LIMIT 1 [ RunTime:0.022727s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285552 LIMIT 1 [ RunTime:0.004800s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 285681 LIMIT 1 [ RunTime:0.014231s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313246 LIMIT 1 [ RunTime:0.021036s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313382 LIMIT 1 [ RunTime:0.000813s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 313644 LIMIT 1 [ RunTime:0.025057s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353116 LIMIT 1 [ RunTime:0.002121s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353166 LIMIT 1 [ RunTime:0.000642s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 289000 LIMIT 1 [ RunTime:0.007181s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353193 LIMIT 1 [ RunTime:0.011538s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 353195 LIMIT 1 [ RunTime:0.005182s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354463 LIMIT 1 [ RunTime:0.001838s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354465 LIMIT 1 [ RunTime:0.009916s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 289119 LIMIT 1 [ RunTime:0.002266s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 354555 LIMIT 1 [ RunTime:0.003457s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 60872 LIMIT 1 [ RunTime:0.001791s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 60889 LIMIT 1 [ RunTime:0.003539s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 60984 LIMIT 1 [ RunTime:0.001556s ]