SHOW FULL COLUMNS FROM `zhimeng_goods` [ RunTime:0.001425s ]
SELECT `oid` FROM `zhimeng_goods` WHERE `status` = 1 AND `cid` IN (42,31,10,14) AND `bid` IN (1,2,3,9) GROUP BY `oid` HAVING count(oid) >= 4 ORDER BY `oid` DESC [ RunTime:1.583109s ]
SELECT COUNT(*) AS think_count FROM `zhimeng_goods` WHERE `oid` IN (1054378,1054192,1031974,1012566,1001674,999601,999558,999440,994713,986402,973494,973454,973452,968515,968514,957113,951241,950674,950673,928091,923932,923931,923930,923926,923925,923923,923922,923921,923916,922813,922809,921902,921901,921900,921899,915130,915121,915118,915107,915091,915089,915083,915081,915076,915074,915073,915072,915070,915063,915061,915060,915033,915026,902253,901823,901822,901821,901809,880309,880308,880307,880306,880305,695800,669707,600328,597719,577348,574656,556734,550104,543331,534065,518558,518557,518555,517082,517045,514455,506944,482328,477168,452824,452823,448882,448585,445307,444249,444246,443456,443042,442963,442960,442920,442914,442381,437587,435262,435096,430927,419232,398060,391713,378994,378924,378917,375045,362951,357133,355733,334436,333198,329748,322509,311482,311249,299439,292445,288728,281527,281515,281513,281512,281511,279965,252303,248049,243998,198439,190056,189986,189932,176626,171457,167878,161306,126763,98123,50956,43764,6081,4942) AND `cid` IN (10,14,31,42) AND `bid` IN (1,2,3,9) AND `status` = 1 AND `range` LIKE '%计算机编程%' LIMIT 1 [ RunTime:0.095791s ]
SELECT `id` FROM `zhimeng_goods` WHERE `oid` IN (1054378,1054192,1031974,1012566,1001674,999601,999558,999440,994713,986402,973494,973454,973452,968515,968514,957113,951241,950674,950673,928091,923932,923931,923930,923926,923925,923923,923922,923921,923916,922813,922809,921902,921901,921900,921899,915130,915121,915118,915107,915091,915089,915083,915081,915076,915074,915073,915072,915070,915063,915061,915060,915033,915026,902253,901823,901822,901821,901809,880309,880308,880307,880306,880305,695800,669707,600328,597719,577348,574656,556734,550104,543331,534065,518558,518557,518555,517082,517045,514455,506944,482328,477168,452824,452823,448882,448585,445307,444249,444246,443456,443042,442963,442960,442920,442914,442381,437587,435262,435096,430927,419232,398060,391713,378994,378924,378917,375045,362951,357133,355733,334436,333198,329748,322509,311482,311249,299439,292445,288728,281527,281515,281513,281512,281511,279965,252303,248049,243998,198439,190056,189986,189932,176626,171457,167878,161306,126763,98123,50956,43764,6081,4942) AND `cid` IN (10,14,31,42) AND `bid` IN (1,2,3,9) AND `status` = 1 AND `range` LIKE '%计算机编程%' ORDER BY `price` ASC,`id` DESC LIMIT 0,30 [ RunTime:0.047915s ]
SHOW FULL COLUMNS FROM `zhimeng_tags` [ RunTime:0.011300s ]
SHOW FULL COLUMNS FROM `zhimeng_category` [ RunTime:0.001095s ]
SELECT `title` FROM `zhimeng_category` WHERE `id` = 42_31_10_14 LIMIT 1 [ RunTime:0.025915s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1517530 LIMIT 1 [ RunTime:0.025950s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1363912 LIMIT 1 [ RunTime:0.023422s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1363911 LIMIT 1 [ RunTime:0.008941s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1363910 LIMIT 1 [ RunTime:0.004420s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1363909 LIMIT 1 [ RunTime:0.003230s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1420347 LIMIT 1 [ RunTime:0.011377s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 527694 LIMIT 1 [ RunTime:0.002615s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 605292 LIMIT 1 [ RunTime:0.001927s ]
SHOW FULL COLUMNS FROM `zhimeng_onename` [ RunTime:0.000589s ]
SELECT `name` FROM `zhimeng_onename` WHERE `id` = 577348 LIMIT 1 [ RunTime:0.000209s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1511982 LIMIT 1 [ RunTime:0.000498s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1511981 LIMIT 1 [ RunTime:0.000517s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1367792 LIMIT 1 [ RunTime:0.000671s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1367760 LIMIT 1 [ RunTime:0.004585s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1367601 LIMIT 1 [ RunTime:0.000576s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1367552 LIMIT 1 [ RunTime:0.000735s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1367516 LIMIT 1 [ RunTime:0.001711s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1367425 LIMIT 1 [ RunTime:0.001835s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1367373 LIMIT 1 [ RunTime:0.001569s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1367324 LIMIT 1 [ RunTime:0.000529s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1367278 LIMIT 1 [ RunTime:0.000503s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1367233 LIMIT 1 [ RunTime:0.000523s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1367112 LIMIT 1 [ RunTime:0.000579s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 264319 LIMIT 1 [ RunTime:0.002198s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1461840 LIMIT 1 [ RunTime:0.000596s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1461829 LIMIT 1 [ RunTime:0.004006s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1461821 LIMIT 1 [ RunTime:0.012447s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 858881 LIMIT 1 [ RunTime:0.004672s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 1200024 LIMIT 1 [ RunTime:0.005066s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 407588 LIMIT 1 [ RunTime:0.005125s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 864281 LIMIT 1 [ RunTime:0.003220s ]
SELECT * FROM `zhimeng_goods` WHERE `id` = 854967 LIMIT 1 [ RunTime:0.007583s ]