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",