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

Query time 0.00064

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

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
65692 <p><span>Capture the look you love without breaking the bank! This collection of handcrafted fixtures </span><span>are offered with minimal customizing options for easy ordering and to help save you money. These fixtures are handspun from standard-grade aluminum which is longer lasting and more weather resistant than steel lighting</span><span>. All products within this collection are crafted with pride right here in America at our Florida manufacturing facility.</span></p> <p><span>The Aero’s timeless design originated in early 20th century lighting styles. Its stacked neck and flared base perfectly balance its vintage influences with a contemporary flair. Attaching this sleek RLM shade to a rugged stem mounting allows installation in exterior locations and high-traffic commercial spaces.</span></p> <p class="title">|break|</p> <ul> <li>Preview our entire Barn Light Basics Collection <a href="/barn-light-basics/">here</a>! </li> <li>Interested in additional customization options? Click <a href="/lighting/ceiling-lights/stem-mount-pendant-lighting/aero-stem-mount-pendant-light/" target="_blank">here</a> for our complete listing!</li> </ul> Weather resistant aluminum makes our Barn Light Basics Aero Stem Mount Pendant a chic and inviting option for your porch lighting! Choose from four stylish finishes! 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, aero stem, aero light, aero basic, aero 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, aero discount light, aero discount, aero discount light, aero basic, aero basic light, discounted aero light, aero basics, basic aero light, budget barn light, budget aero, budget barn lights, discount aero, aero light, discount aero light, aero stem light, aero stem mount, discount aero stem light, budget discount aero stem light, back to basics,
65693 <p><span>Capture the look you love without breaking the bank! Our Barn Light Basics collection of handcrafted fixtures </span><span>are offered with minimal customizing options for easy ordering and to help save you money. These fixtures are handspun from standard-grade aluminum which is longer lasting and more weather resistant than steel lighting</span><span>. All products within this collection are crafted with pride right here in America at our Florida manufacturing facility.</span></p> <p><span>The Aero integrates a sleek, modern flourish into the look of traditional barn light, establishing a design that complements updated styles. In hip settings like downtown restaurants and urban lofts, the Aero grounds a contemporary décor with its timeless appearance. Thanks to its vintage-inspired roots, the Aero also provides authentic touches of character to retro-inspired spaces.</span></p> <p class="title">|break|</p> <ul> <li>Ceiling canopy will match shade finish. </li> <li>Preview our entire Barn Light Basics Collection <a href="/barn-light-basics/">here</a>! </li> <li>Interested in additional customization options? Click <a href="/lighting/ceiling-lights/cord-hung-pendant-lighting/aero-pendant-light/" target="_blank">here</a> for our complete listing!</li> </ul> Our Barn Light Basics Aero Pendant Light is everything you know and love about our sleek, angular Aero shade - now at a price that your budget will thank you 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, aero basic, basic aero, aero basics, flared light, flared pendant, aero cord, aero pendant light, aero cord light, flared cord pendant, discount modern lights, basic modern light, aero light, back to basics,
65873 <p data-start="129" data-end="448">The Duo Stem Pendant is a bold and versatile lighting fixture designed for both style and flexibility. Featuring a mix-and-match design, this pendant allows you to choose three different finishes for the top, bottom and interior, giving you complete creative control to complement any interior.</p> <p data-start="450" data-end="745">Available in 10-inch and 14-inch sizes, the Duo Pendant showcases a stacked bowl design, offering a modern yet timeless aesthetic. Suspended from a sleek, thin stem, this pendant is perfect for dining rooms, kitchens, and living spaces, casting a warm and inviting glow.</p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Customizable with the unique ability to select different finishes for the bottom shade’s interior and exterior.</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>!</li> </ul> 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 <p data-start="133" data-end="448">The Duo Wall Sconce is a sophisticated blend of contemporary design and durable, American-made materials. Featuring a striking double-dome silhouette, this fixture is highly customizable with the ability to choose up to three different finishes to create the custom fixture you've always imagined. For subtle yet refined contrast, accessorize with an optional hand-carved wooden ring around the middle. </p> <p data-start="133" data-end="448">Designed for both ambient and task lighting, the sconce emits a soft, even glow, enhanced by an optional <a href="/lighting/accessories/bulbs/">decorative bulb</a>. Its sleek, curved form and high-quality finish make the Duo Wall Sconce a perfect addition to modern, mid-century, and minimalist interiors.</p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Customizable with the unique ability to select different finishes for the bottom shade’s interior and exterior.</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>!</li> </ul> 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,
65965 <p class="p1"><span>With its sleek profile and refined simplicity, the Isos Cone Studio Pendant brings contemporary style to any setting. Offered in three unique shade sizes, this pendant lets you create just the right look and level of impact. Choose from a wide selection of exterior and interior finishes, then top it with your choice of wood or metal for a natural or modern accent. The result is a clean, versatile aesthetic that feels effortlessly sophisticated.</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 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,