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 (65691, 65692, 65693) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00058

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

Result

product_id	meta_description	search_words
65691	Sticking to a budget but don't want to sacrifice on quality or style? Our Barn Light Basics Aero Gooseneck Light is the light you've been looking for!	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, aero gooseneck, aero light, aero basic, aero gooseneck light, discount gooseneck light, discount goosenecks, basic goosenecks, budget gooseneck lights, budget friendly gooseneck lights, aero gooseneck, aero discount light, back to basics,
65692	Weather resistant aluminum makes our Barn Light Basics Aero Stem Mount Pendant a chic and inviting option for your porch lighting! Choose from four stylish finishes!	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, aero stem, aero light, aero basic, aero 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, aero discount light, aero discount, aero discount light, aero basic, aero basic light, discounted aero light, aero basics, basic aero light, budget barn light, budget aero, budget barn lights, discount aero, aero light, discount aero light, aero stem light, aero stem mount, discount aero stem light, budget discount aero stem light, back to basics,
65693	Our Barn Light Basics Aero Pendant Light is everything you know and love about our sleek, angular Aero shade - now at a price that your budget will thank you for!	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, aero basic, basic aero, aero basics, flared light, flared pendant, aero cord, aero pendant light, aero cord light, flared cord pendant, discount modern lights, basic modern light, aero light, back to basics,