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

Query time 0.00050

JSON explain

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

Result

product_id	meta_keywords	meta_description	search_words	promo_text
375	Luffa, loofah, Egyptian Luffa	Luffas have been used for bathing since the days of the pharaohs. Indeed, our whole luffas are grown in the Nile Delta of Egypt, where they get enough sun and water to reach mammoth size. They provide an invigorating, gentle scrub to exfoliate dead skin a
1611	Luffa, loofah, Egyptian Luffa	Luffas have been used for bathing since the days of the pharaohs. Indeed, our whole luffas are grown in the Nile Delta of Egypt, where they get enough sun and water to reach mammoth size. They provide an invigorating, gentle scrub to exfoliate dead skin a