CREATE TABLE `products` (
  `product_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `affiliate_store_product_id` varchar(255) DEFAULT NULL,
  `product_name` varchar(255) NOT NULL,
  `page_title` varchar(255) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `product_description_short` varchar(255) DEFAULT NULL,
  `product_description_long` varchar(255) DEFAULT NULL,
  `product_link_url` varchar(255) DEFAULT NULL,
  `product_url` varchar(255) NOT NULL,
  `product_price` varchar(255) DEFAULT NULL,
  `product_store_id` int(11) unsigned DEFAULT NULL,
  `sale_price` varchar(255) DEFAULT NULL,
  `product_status` char(255) DEFAULT NULL,
  PRIMARY KEY (`product_id`),
  UNIQUE KEY `storeProductId` (`affiliate_store_product_id`,`product_store_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7539 DEFAULT CHARSET=latin1;


EXPLAIN SELECT * FROM products WHERE product_store_id = 3


"id"    "select_type"   "table" "type"  "possible_keys" "key"   "key_len"   "ref"   "rows"  "Extra"
"1" "SIMPLE"    "products"  "ALL"   \N  \N  \N  \N  "1273"  "Using where"