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

Query time 0.00059

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 (65895,65896) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
65895 Oversized and energy-efficient, the Oxford LED Pendant features a 23" shade, steel wire suspension, and customizable cord—perfect for making a bold design statement. oxford studio, led oxford, the oxford, oversized led, oversized led light, oversized light, large modern light, modern led, studio oxford, oxford collection, studio mount led, oversized studio light, adjustable led light,
65896 Discover the Oxford Stem Mount Pendant — a bold 23" LED fixture with a sleek, modern silhouette and durable stem suspension, perfect for statement-making spaces. oxford stem, led oxford, the oxford, oversized led, oversized led light, oversized light, large modern light, modern led, stem oxford, oxford collection, stem mount led,