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 (65800, 65801, 65802) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00044

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": 3,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65800,65801,65802) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words	promo_text
65800			42" avalon, oversized avalon, 42 avalon, avalon 42, avalon 42", 42" avalon led, led avalon 42, 42 avalon led, oversized avalon led, 42" led avalon,
65801			42" avalon, oversized avalon, 42 avalon, avalon 42, avalon 42",
65802			42" avalon, oversized avalon, 42 avalon, avalon 42, avalon 42",