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 (
    65803, 65804, 65805, 65813, 65814, 65815
  ) 
  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", "product_id"],
      "key": "product_id",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 6,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65803,65804,65805,65813,65814,65815) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words	promo_text
65803			30" laramie, oversized laramie, 30 laramie, laramie 30, laramie 30",
65804			30" laramie, oversized laramie, 30 laramie, laramie 30, laramie 30",
65805			30" laramie, oversized laramie, 30 laramie, laramie 30, laramie 30",
65813			30" chestnut, oversized chestnut, 30 chestnut, chestnut 30, chestnut 30",
65814			30" chestnut, oversized chestnut, 30 chestnut, chestnut 30, chestnut 30",
65815			30" chestnut, oversized chestnut, 30 chestnut, chestnut 30, chestnut 30",