Sandbox

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 (65462, 65454) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00029

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": 2,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65462,65454) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words	promo_text
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,
65462		A unique industrial flush mount light! The Blue Collar helps modern homes and businesses feel stylish, timeless, and one-of-a-kind. Customizable with finish and glass options!	BLE-F-WGGWS, Blue collar Flush Mount Light, Blue collar Flush Mount, Blue collar Flush Mount Pendant, Blue collar Pendant, Blue collar Pendant Light, Blue collar ceiling light, Blue collar flush mount ceiling pendant, Blue collar flush, Flush Blue collar, The Blue collar Flush Mount Light, The Blue collar Flush Mount, The Blue collar Flush Mount Pendant, The Blue collar Pendant, The Blue collar Pendant Light, The Blue collar ceiling light, The Blue collar flush mount ceiling pendant, The Blue collar flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant,