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 (65684, 65685, 65686) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00041

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

Result

product_id	meta_description	search_words
65684	Our most popular fixture is now even more affordable! Our Barn Light Basics The Original™ Gooseneck Light is the classic farmhouse style light you need!	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, original gooseneck, the original gooseneck, the original light, the original basic, the original gooseneck light, original light, original basic, original gooseneck light, discount gooseneck light, discount goosenecks, basic goosenecks, budget gooseneck lights, budget friendly gooseneck lights, back to basics, H-15112, H-15116, classic warehouse shade gooseneck rlm, classic warehouse shade,
65685	Searching for a durable, weather resistant fixture at a price you can't beat? Our Barn Light Basics The Original™ Stem Mount Pendant is exactly what 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, the original stem, the original light, the original basic, the original stem light, original stem, original light, original basic, original 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, original discount light, the original discount light, the original discount, original discount, original discount light, original basic, original basic light, the original basic light, the original basics, discounted deep bowl light, original basics, basic warehouse light, budget barn light, budget original, budget barn lights, discount original, original light, discount original light, original barn light, the original barn light, the original stem light, the original stem mount, discount the original stem light, original stem light, original stem mount, discount original stem light, budget discount original stem light, back to basics, H-15112, H-15116, classic warehouse shade stem mount pendant rlm, classic warehouse shade, basic original stem,
65686	The farmhouse charm you love has never been more affordable! Quality and style merge beautifully with our Barn Light Basics The Original™ Warehouse Pendant!	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, original basic, the original basic, original basics, original light, the original light, warehouse pendant, original warehouse pendant, the original warehouse pendant, original cord, the original cord, original pendant, the original pendant, original cord light, the original cord light, original cord pendant, the original cord pendant, discount barn lights, discount warehouse lights, basic barn light, simple barn light, minimal barn light, back to basics, H-15112, H-15116, classic warehouse shade cord-hung pendant rlm, classic warehouse shade,