Sandbox

SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '', 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  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 (65889, 65836, 65891, 65964) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00050

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

Result

product_id	full_description	meta_description	search_words
65836	<div> <div lang="en-US"> <p lang="en-US">Blending modern minimalism with organic warmth, The Carver LED Wall Light features a sleek circular design with a smooth, aluminum outer frame and a central handcrafted solid wood accent. This energy-efficient fixture is powered by integrated LED technology, providing a soft, ambient glow while ensuring long-lasting performance and low energy consumption.</p> <p class="p1"><span class="s1">Available in three size options, The Carver is versatile enough for various applications, from accent lighting in hallways to statement pieces in living spaces and bedrooms. Designed for both aesthetics and functionality, this fixture delivers a perfect balance of natural texture and contemporary design.</span></p> </div> </div> <p>\|break\|</p> <ul> <li>Manufactured in the U.S.A. </li> <li> <div>Part of our exclusive <a title="Learn more about our Timber & Ore Collection" href="/timber-ore-collection/">Timber & Ore Collection</a></div> </li> <li>All wood is sourced from North American suppliers who are committed to sustainable felling and regrowth practices.</li> <li><span>Every p</span><span>iece of wood is unique with slight, natural variations such as knots and grain differences due to natural growth patterns. Therefore, no two pieces will be exactly alike!</span></li> <li><span><span>This light fixture is made-to-order to suit your custom specifications. Learn more about the process </span><a href="https://www.barnlight.com/behind-the-scenes-video-footage/" target="_blank">here</a><span>!</span></span> </li> </ul>	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
65889	<p class="p1">The Cassidy LED Globe Chain Pendant combines industrial charm with modern versatility. Featuring a clean globe diffuser and a wide, flat shade, this fixture offers a bold yet balanced silhouette. The sturdy chain mount includes a quicklink for easy, adjustable hanging height, making it adaptable to a variety of spaces—from kitchen islands to commercial settings.</p> <p class="p1">With over 30 finish options available, you can tailor the look to perfectly suit your design vision. Energy-efficient LED technology delivers up to 2000 lumens of bright, ambient light.</p> <p>\|break\|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Acrylic globe provides soft, even light diffusion</li> <li><span><span>This light fixture is made-to-order to suit your custom specifications. Learn more about the process </span><a href="https://www.barnlight.com/behind-the-scenes-video-footage/" target="_blank">here</a><span>!</span></span></li> </ul>	The Cassidy LED Globe Chain Pendant combines modern style with customizable features, including adjustable hanging length and over 30 finish options. Shop now to elevate your lighting.
65891	<p class="p1">The Cassidy LED Globe Flush Mount Pendant offers a sleek, low-profile design that blends streamlined simplicity with bold visual impact. Its sculptural silhouette—featuring a wide shade and opal globe diffuser—delivers ambient, glare-free light while hugging close to the ceiling, making it ideal for lower-clearance spaces. Available in over 30 finish options, this fixture brings refined style and reliable performance to kitchens, hallways, or entryways alike.</p> <p>\|break\|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Acrylic globe provides soft, even light diffusion</li> <li><span><span>This light fixture is made-to-order to suit your custom specifications. Learn more about the process </span><a href="https://www.barnlight.com/behind-the-scenes-video-footage/" target="_blank">here</a><span>!</span></span></li> </ul>	The Cassidy LED Globe Flush Mount Light pairs bold, modern design with a space-saving profile—available in 30+ finishes for a customized, low-clearance lighting solution.
65964	<p class="p1"><span class="s1">The Isos LED Cone Studio Pendant blends modern minimalism with handcrafted warmth. Its clean cone shape and integrated LED technology provide efficient, ambient light. Customize your look with a wide range of exterior and interior finishes, and choose a wood or metal top to match your style, whether you prefer something natural and organic or sleek and contemporary. Thoughtfully crafted in Florida, the Isos Pendant offers a versatile lighting solution that feels both modern and inviting.</span></p> <p>\|break\|</p> <ul> <li>Manufactured in the U.S.A.</li> <li><span><span>Adjustable length with Griplock<strong class="Yjhzub">®</strong><span> </span>technology</span></span></li> <li>Made-to-order; learn more about the process<span> </span><a href="/video-gallery/">here</a></li> </ul>	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,