SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (62976, 65302, 65426, 65454) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00052

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 4,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (62976,65302,65426,65454) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
62976 Flush Mount Lighting, Ceiling Lighting, Ceramic Fixture Ceiling lighting with a sleek new style, the Kao Flush Mount is undersized, resulting in easy installation in smaller spaces. Add to homes and businesses! The Kao Flush Mount, kao flush mount, kao flush mount pendant, kao flush, koa flush mount, koa, kao ceiling lighting, kao ceiling light, kao pendant, kao ceiling pendant, kao light, kao, kao pendant light, kao pendant lighting, kao pendants, BLE-F-KAO, Alabax, pass & Seymour, pass and seymour, Flush mount light, kao collection, kao series, the kao collection, the kao series, koa, kao lighting, kao light, kao lights, Small mount lighting, Small mount light, Small mount lights, foyer light, foyer lights, foyer lighting,
65302 Timeless flush mount lighting design with unequaled craftsmanship! The Dino is manufactured in our Florida-based facility and is fully customizable! BLE-F-WHD, Dino flush mount, dino flush mounts, dino flush mount pendant, dino flush mount pendants, dino flush mount pendant light, dino flush mount pendant lights, dino flush mount pendant lighting, dino flush mount, dino flush mounts, dino flush mount pendant, dino flush mount pendants, dino flush pendant, dino flush pendants, dino flush mount light, dino flush pendant, flush mount dino, flush dino, Dino flush, dino flush pendant, dino flush pendant light, dino flush mount pendants, flush mount, flush mount light, flush mount pendant light, flush mount pendant lighting,
65426 A timeless lighting design, the Esso offers a hint of character to indoor and exterior spaces. Handcrafted, fully customizable, and incredibly stylish! BLE-F-WHE, Esso Flush Mount, Esso Flush Mounts, Esso Flush Mount Pendant, Esso Flush Mount Pendant Light, Esso Flush Mount Ceiling Pendant, Esso Flush Mount Ceiling Pendants, Esso Flush Pendant, Esso Flush Pendant Light, Esso Flush Pendant Lights, Esso flush ceiling light, esso flush mount ceiling light, flush mount pendant, flush mount light, flush mount ceiling pendant, The Esso Flush Mount, The Esso Flush Mounts, The Esso Flush Mount Pendant, The Esso Flush Mount Pendant Light, The Esso Flush Mount Ceiling Pendant, The Esso Flush Mount Ceiling Pendants, The Esso Flush Pendant, The Esso Flush Pendant Light, The Esso Flush Pendant Lights, the Esso flush ceiling light, the esso flush mount ceiling light, flush, flush mount, flush mount light, esso,
65454 Flush mount lighting with a modern edge, the Chateau elevates residential and commercial spaces! American made and handcrafted, this fully customizable flush mount light will transform every decor! Chateau Flush Mount Light, Chateau Flush Mount, Chateau Flush Mount Pendant, Chateau Pendant, Chateau Pendant Light, Chateau ceiling light, Chateau flush mount ceiling pendant, Chateau flush, Flush Chateau, The Chateau Flush Mount Light, The Chateau Flush Mount, The Chateau Flush Mount Pendant, The Chateau Pendant, The Chateau Pendant Light, The Chateau ceiling light, The Chateau flush mount ceiling pendant, The Chateau flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant, BLE-F-BIS,