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 (
    65964, 65836, 65892, 65937, 65895, 65884, 
    65938, 65965
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00051

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": 8,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65964,65836,65892,65937,65895,65884,65938,65965) 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
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,
65892 Elevate your space with the Cassidy LED Globe Gooseneck Light—sculptural style, powerful performance, and over 30 finish options to complement any design.
65895 Oversized and energy-efficient, the Oxford LED Pendant features a 23" shade, steel wire suspension, and customizable cord—perfect for making a bold design statement. oxford studio, led oxford, the oxford, oversized led, oversized led light, oversized light, large modern light, modern led, studio oxford, oxford collection, studio mount led, oversized studio light, adjustable led light,
65937 LED linear light, wood suspension light, modern pendant lighting, handcrafted lighting, linear pendant, Suora light, kitchen island lighting, American made lighting, minimalist lighting, customizable light fixture Discover the Suora LED Linear Suspension Light, a sleek wood pendant handcrafted for modern spaces. Customizable finishes, energy-efficient LED, and timeless design make it perfect for dining areas, kitchens, and workspaces. Made in the USA. c-stu-dcm, c-stu-scm, linear suora, suora linear,
65938 LED wall sconce, wooden sconce, adjustable wall light, modern wall lighting, handcrafted lighting, dimmable sconce, Suora sconce, American-made lighting, hallway lighting, entryway sconce Discover the Suora LED Linear Wooden Adjustable Sconce, a sleek and versatile wall light that blends handcrafted wood with modern design. Features adjustable, dimmable LED lighting, customizable finishes, and American-made quality—perfect for hallways, en W-LIN, linear adjustable, suora sconce,
65964 The Isos LED Cone Studio Pendant combines modern form with natural warmth, featuring hand-spun metal and an optional wood accent. Made in Florida. isos studio, led isos, the isos, oversized led, oversized led light, oversized light, large modern light, modern led, studio isos, isos collection, studio mount led, oversized studio light, adjustable led light,
65965 The Isos Cone Studio Pendant features a sleek, contemporary design available in three shade sizes. Customize with a variety of finishes and a wood or metal top for a look that’s clean, versatile, and effortlessly sophisticated. isos studio, cord isos, the isos, oversized light, triangle light, geometric light, geometric pendant, large modern light, modern pendant, studio isos, isos collection, studio mount, oversized studio light, adjustable light,