SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.000704s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (4,17,24,14,23,26,38,22) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 8 ORDER BY `oid` DESC [ RunTime:0.545805s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `price` > '30000' AND `oid` IN (1054378,1053011,1001674,994713,986402,973454,968514,957113,951241,950684,950674,950673,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921900,921899,556734,543331,518557,518555,477168,470482,452824,452823,445307,443456,442960,399875,390912,368274,357133,347688,333198,304802,288728,281527,281515,281513,281512,281511,247167,243998,236591,205652,176626,149006,138201,123316,98834,82221,50942,23905,23134,6081,4942) AND `cid` IN (4,14,17,22,23,24,26,38) AND `bid` IN (1,2,3,9) AND `status` = 1 LIMIT 1 [ RunTime:0.015268s ]
SELECT `id` FROM `zhimeng_goods` WHERE `price` > '30000' AND `oid` IN (1054378,1053011,1001674,994713,986402,973454,968514,957113,951241,950684,950674,950673,923932,923931,923930,923926,923925,923922,923921,923916,921902,921901,921900,921899,556734,543331,518557,518555,477168,470482,452824,452823,445307,443456,442960,399875,390912,368274,357133,347688,333198,304802,288728,281527,281515,281513,281512,281511,247167,243998,236591,205652,176626,149006,138201,123316,98834,82221,50942,23905,23134,6081,4942) AND `cid` IN (4,14,17,22,23,24,26,38) AND `bid` IN (1,2,3,9) AND `status` = 1 ORDER BY `oid` ASC,`cid` ASC LIMIT 0,30 [ RunTime:0.011308s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.000799s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.000803s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 4_17_24_14_23_26_38_22 LIMIT 1 [ RunTime:0.000713s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 341407 LIMIT 1 [ RunTime:0.000545s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1590102 LIMIT 1 [ RunTime:0.000302s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1590111 LIMIT 1 [ RunTime:0.001435s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1590114 LIMIT 1 [ RunTime:0.003400s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1590119 LIMIT 1 [ RunTime:0.001082s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1590120 LIMIT 1 [ RunTime:0.001034s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1590121 LIMIT 1 [ RunTime:0.000786s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1590122 LIMIT 1 [ RunTime:0.001072s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1590289 LIMIT 1 [ RunTime:0.000640s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 767311 LIMIT 1 [ RunTime:0.000650s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 767306 LIMIT 1 [ RunTime:0.000636s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 767302 LIMIT 1 [ RunTime:0.000723s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 767271 LIMIT 1 [ RunTime:0.000649s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 767270 LIMIT 1 [ RunTime:0.000705s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 767298 LIMIT 1 [ RunTime:0.000637s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 767296 LIMIT 1 [ RunTime:0.000682s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 767285 LIMIT 1 [ RunTime:0.000638s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 670825 LIMIT 1 [ RunTime:0.000674s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 670830 LIMIT 1 [ RunTime:0.000787s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 670810 LIMIT 1 [ RunTime:0.000732s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 670822 LIMIT 1 [ RunTime:0.000741s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 670820 LIMIT 1 [ RunTime:0.000743s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 670805 LIMIT 1 [ RunTime:0.000735s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 670806 LIMIT 1 [ RunTime:0.000680s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 670816 LIMIT 1 [ RunTime:0.000739s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1430493 LIMIT 1 [ RunTime:0.000941s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1431106 LIMIT 1 [ RunTime:0.002752s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1431296 LIMIT 1 [ RunTime:0.000651s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1431682 LIMIT 1 [ RunTime:0.002056s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1431686 LIMIT 1 [ RunTime:0.001811s ]