SELECT `data` FROM `tj` WHERE ( `channel` = '11' AND `position` = 'hots' ) LIMIT 1 [ RunTime:0.000491s ]
SHOW FULL COLUMNS FROM `brand` [ RunTime:0.002038s ]
SELECT `name` FROM `brand` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000628s ]
SHOW FULL COLUMNS FROM `product` [ RunTime:0.002466s ]
SELECT COUNT(*) AS think_count FROM `product` WHERE ( `status` = 1 AND `category` LIKE '121212%' AND `origin` LIKE '1111%' AND `brand` = '北京茂源' ) [ RunTime:0.009733s ]
SELECT * FROM `product` WHERE ( `status` = 1 AND `category` LIKE '121212%' AND `origin` LIKE '1111%' AND `brand` = '北京茂源' ) ORDER BY `rank2` ASC,`id` DESC LIMIT 0,20 [ RunTime:0.009433s ]
SHOW FULL COLUMNS FROM `company` [ RunTime:0.002617s ]
SELECT * FROM `company` WHERE ( `id` = 109 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000672s ]
SHOW FULL COLUMNS FROM `category` [ RunTime:0.001833s ]
SELECT * FROM `category` WHERE ( LENGTH(code) = 2 ) AND `status` = 1 ORDER BY `code` ASC [ RunTime:0.001012s ]
SELECT * FROM `category` WHERE ( LENGTH(code) = 4 ) AND `status` = 1 AND `code` LIKE '12%' ORDER BY `code` ASC [ RunTime:0.000758s ]
SHOW FULL COLUMNS FROM `regional` [ RunTime:0.001564s ]
SELECT * FROM `regional` WHERE ( LENGTH(code) = 4 ) ORDER BY `code` ASC [ RunTime:0.001946s ]
SELECT * FROM `brand` WHERE `status` = 1 ORDER BY `rank` ASC,`id` DESC [ RunTime:0.000690s ]
SELECT * FROM `company` WHERE `status` = 1 ORDER BY `id` DESC LIMIT 2 [ RunTime:0.000587s ]
SELECT * FROM `product` WHERE `status` = 1 AND `commend` = 1 ORDER BY `rank` ASC,`id` DESC LIMIT 10 [ RunTime:0.008604s ]
SELECT * FROM `company` WHERE ( `id` IN (112,109) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000780s ]