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

Query time 0.00040

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

Result

product_id meta_keywords meta_description search_words promo_text
65836 Elevate your space with The Carver LED Wall Light, a modern fixture featuring a sleek circular design, wood-grain accent, and energy-efficient LED technology. Available in three sizes for versatile styling. Carver LED Wall Light, Modern LED Wall Sconce, Wood Accent Wall Light, Minimalist LED Light Fixture, Contemporary Wall Lighting, Natural Wood Wall Sconce, Round LED Wall Lamp, Energy-Efficient Wall Light, Warm Ambient LED Fixture, Designer Wall Lighting, Neutral Tone Wall Light, Soft Glow LED Wall Fixture, Decorative Indoor Wall Lamp, Organic Modern Wall Light, Three Size LED Wall Light
65956 The Carver Flush Mount Light blends sleek, modern design with organic warmth. Powered by energy-efficient LED technology, this low-profile fixture delivers soft, inviting illumination for any space. Carver LED Wall Light, Modern LED Wall Sconce, Wood Accent Wall Light, Minimalist LED Light Fixture, Contemporary Wall Lighting, Natural Wood Wall Sconce, Round LED Wall Lamp, Energy-Efficient Wall Light, Warm Ambient LED Fixture, Designer Wall Lighting, Neutral Tone Wall Light, Soft Glow LED Wall Fixture, Decorative Indoor Wall Lamp, Organic Modern Wall Light, Three Size LED Wall Light, Flush Mount Light, Modern Flush Light, Modern Flush Mount Wall Light, Carver Flush Mount Light, Modern Wood Accent Light, LED Flush Mount Fixture, Handcrafted Wood Lighting, Low Profile Ceiling Light, Modern Rustic Flush Light, Energy Efficient Flush Mount