mysql的select count如何才能更快点?
做这个查询要花我3秒的时间,不知道能不能更快点呢,谢谢大家
SELECT count(ID) AS amount FROM pb_products AS Product WHERE Product.status=1 AND Product.industry_id1=583 LIMIT 1
我试了下,去掉Product.status=1还是很慢,不知道杂办了
表结构
CREATE TABLE `pb_products` (
`id` int(10) NOT NULL auto_increment,
`member_id` int(10) NOT NULL,
`company_id` int(10) NOT NULL default '0',
`cache_companyname` varchar(100) NOT NULL default '',
`sort_id` tinyint(1) NOT NULL default '1',
`brand_id` smallint(6) NOT NULL default '0',
`category_id` smallint(6) NOT NULL default '0',
`industry_id1` smallint(6) NOT NULL default '0',
`industry_id2` smallint(6) NOT NULL default '0',
`industry_id3` smallint(6) NOT NULL default '0',
`area_id1` smallint(6) NOT NULL default '0',
`area_id2` smallint(6) NOT NULL default '0',
`area_id3` smallint(6) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`price` float(9,2) NOT NULL default '0.00',
`sn` varchar(20) NOT NULL default '',
`spec` varchar(20) NOT NULL default '',
`produce_area` varchar(50) NOT NULL default '',
`packing_content` varchar(100) NOT NULL default '',
`picture` varchar(500) NOT NULL,
`content` text,
`producttype_id` smallint(6) NOT NULL default '0',
`status` tinyint(1) NOT NULL default '0',
`state` tinyint(1) NOT NULL default '1',
`ifnew` tinyint(1) NOT NULL default '0',
`ifcommend` tinyint(1) NOT NULL default '0',
`priority` tinyint(1) NOT NULL default '0',
`tag_ids` varchar(255) default '',
`clicked` smallint(6) NOT NULL default '1',
`formattribute_ids` text,
`created` int(10) NOT NULL default '0',
`modified` int(10) NOT NULL default '0',
`PickUrl` varchar(500) NOT NULL,
PRIMARY KEY (`id`),
KEY `company_id` (`company_id`),
KEY `member_id` (`member_id`),
KEY `industry_id1` (`industry_id1`),
KEY `industry_id2` (`industry_id2`),
KEY `industry_id3` (`industry_id3`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=835924 ;