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 (65873, 65882, 65883, 65884) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00033

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": 4,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65873,65882,65883,65884) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
65873 Customize your lighting with the Duo Loma Stem Pendant, available in 10" and 14" sizes with mix-and-match finishes. Featuring a stacked bowl design, this modern pendant is perfect for kitchens, dining areas, and living spaces. Shop now! duo pendant, duo stem, duo stem mount, duo light, duo fixture, modern pendant, modern stem mount, modern light, two-toned light, twotoned light, two-tone, two tone fixture, customizable light, round pendant, dome pendant, mid-century modern pendant, midcentury, wood accent, wooden accent, wood, farmhouse, farmhouse pendant, sleek pendant, neutral pendant,
65882 Enhance your space with the Duo Loma Wall Sconce, a modern double-dome light available in over 30 stunning finishes. Ideal for ambient lighting in bedrooms, hallways, and living spaces. Shop now for contemporary elegance! duo sconce, duo light, duo fixture, modern sconce, modern light, two-toned light, twotoned light, two-tone, two tone fixture, customizable light, round sconce, dome sconce, mid-century modern sconce, midcentury, wood accent, wooden accent, wood, farmhouse, farmhouse sconce, wall lamp, sleek sconce, neutral sconce,
65883 Elevate your space with the Duo Loma LED Stem Pendant, a modern and energy-efficient light fixture with customizable finishes. Perfect for kitchens, dining areas, and living spaces. duo pendant, duo stem, duo stem mount, duo light, duo fixture, modern pendant, modern stem mount, modern light, two-toned light, twotoned light, two-tone, two tone fixture, customizable light, round pendant, dome pendant, mid-century modern pendant, midcentury, wood accent, wooden accent, wood, farmhouse, farmhouse pendant, sleek pendant, neutral pendant, duo led pendant, led duo, modern led light, modern led stem pendant, led farmhouse pendant,
65884 The Duo LED Wall Sconce features a modern double-dome design with customizable finishes and energy-efficient lighting. Perfect for contemporary, mid-century, and minimalist spaces. duo sconce, duo light, duo fixture, modern sconce, modern light, two-toned light, twotoned light, two-tone, two tone fixture, customizable light, round sconce, dome sconce, mid-century modern sconce, midcentury, wood accent, wooden accent, wood, farmhouse, farmhouse sconce, wall lamp, sleek sconce, neutral sconce, duo led, led duo, modern led sconce, farmhouse led sconce, led farmhouse sconce,