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 (65688, 65689, 65690) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00045

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

Result

product_id	meta_description	search_words
65688	Looking for that perfect balance of coastal charm and industrial durability? Our Barn Light Basics Seaside Gooseneck Light is the affordable option for you!	basic light, discount light, discount lighting, better than steel lighting, budget lighting, budget friendly light, budget friendly lighting, budget friendly light fixture, barn light budget lighting, barn light discount lights, cheap lighting, barn lighting, steel lighting, modern light, modern light fixture, discount modern lights, basic modern light, seaside gooseneck, seaside light, seaside basic, seaside gooseneck light, discount gooseneck light, discount goosenecks, basic goosenecks, budget gooseneck lights, budget friendly gooseneck lights, radial wave gooseneck, radial wave discount light, back to basics, basic seaside gooseneck,
65689	Our inviting radial wave shade on a durable stem mount is the light you've been looking for! The Barn Light Basics Seaside Stem Mount Pendant offers style at a price you can't beat!	basic light, discount light, discount lighting, better than steel lighting, budget lighting, budget friendly light, budget friendly lighting, budget friendly light fixture, barn light budget lighting, barn light discount lights, cheap lighting, barn lighting, steel lighting, seaside stem, seaside light, seaside basic, seaside stem light, discount stem mount light, discount stems, discount stem mounts, basic stems, basic stem mounts, budget stem lights, budget stem mount lights, budget friendly stem lights, seaside discount light, seaside discount, seaside discount light, seaside basic, seaside basic light, discounted seaside light, seaside basics, basic radial wave light, budget barn light, budget seaside, budget barn lights, discount seaside, seaside radial wave light, discount seaside light, seaside stem light, seaside stem mount, discount seaside stem light, budget discount seaside stem light, back to basics,
65690	Our new Barn Light Basics Seaside Pendant Light is the undeniably stylish yet budget-friendly light you've been looking for! Quality isn't sacrificed even at this great price!	basic light, discount light, discount lighting, better than steel lighting, budget lighting, budget friendly light, budget friendly lighting, budget friendly light fixture, barn light budget lighting, barn light discount lights, cheap lighting, barn lighting, steel lighting, seaside basic, basic seaside, seaside basics, radial wave light, wave shaped pendant, seaside cord, seaside light, seaside pendant, radial wave cord light, seaside cord pendant, discount lights, basic lights, back to basics,