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 (61696, 61693, 61698, 61565, 65453) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00047

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 (61696,61693,61698,61565,65453) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
61565 <p>Add all-American flair to your commercial restaurant lighting with the Tuscany Food Warmer Pendant. Hand crafted from commercial grade materials by local artisans, this pendant features a sloping cylindrical shade and comes in an array of stunning powder coat finish colors. Consider this modern pendant for all your commercial restaurant needs!</p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>!</li> </ul> food warmer lamp, restaurant ceiling lighting, commercial heating lamp, diner pendant light, decorative heat warmer lighting, down light heat lamp, modern restaurant pendant light Add all-American flair to your commercial restaurant lighting. Hand crafted by local artisans this pendant features a sloping cylindrical shade. Café Food Warmer Pendant, BLE-C-FW-CAF, food warmer light, restaurant lighting, commercial heating lamp, foodwarmer, food warming, heat lamp, heat light, food warmer pendant, food warming pendant, food warmer pendants, food warming pendants, food pendant, food pendants, food light, food lighting, food lamp, food light, restaurant heat lamps, food heat lamp, food heat lamps, heat lamp, heat lamps, restaurant food warmer, restaurant food warming pendant, heat lamp, restaurant heat lamp, tuscany, tuscany food warmer pendant, tuscany pendant, The Tuscany Collection, The Tuscany Series, Tuscany Collection Tuscany Series, SPS-0262, SPS 0262, SPS0262, heatlamp, warming lights, warming light, warming lighting, warming pendant, warming pendants, warming ceiling pendant, warming ceiling pendants, warming lamp, buffet lamps, tuscany cord hung, food warmers,
61693 <p>Fitting into contemporary decors, the Tuscany Cord Hung Pendant features an undersized warehouse shade, able to be hung alone or in groups. This ceiling lighting adds a unique design element to any sized space. Line several of these cord hung pendants along the counter in your kitchen. Or use a single pendant to highlight tables in restaurant dining rooms. The sleek style of this pendant lighting adds a modern style to any space.</p> <p>Customize this pendant by matching its finish color to your decor. With cord options available for both damp and dry locations, you can install the Tuscany Cord Hung Pendant in virtually any setting. This American made lighting is manufactured from high quality materials, resulting in a durable ceiling light!</p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A. </li> <li><span>This light fixture is made-to-order to suit your custom specifications. Learn more about the process<span> </span></span><a href="https://www.barnlight.com/behind-the-scenes-video-footage/">here</a>!</li> </ul> modern pendant, modern lighting, modern pendant lighting, ceiling lighting, American-made lighting The Tuscany's sleek, minimalist bell silhouette and flexible mount makes this ceiling light ideal for kitchen islands and contemporary office spaces! Tuscany Modern Cord Hung Pendant, BLE-C-CAF, tuscany, modern pendant, cord hung pendant, SPS-0369, SPS 0369, SPS0369, The Tuscany Collection, The Tuscany Series, Tuscany Collection Tuscany Series, corded pendant, corded pendants, corded pendant light, corded pendant lights, corded pendant lighting, corded ceiling pendant, corded ceiling pendants, corded ceiling light, corded ceiling lights, corded ceiling lighting, corded pendant light fixture, corded pendant light fixtures, corded pendant lighting fixture, corded pendant lighting fixtures, corded light fixture, corded light fixtures, corded lighting fixture, corded lighting fixtures, corded, tuscany cord hung,
61696 <p>The Tuscany Stem Mount Pendant features a sleek, minimalist bell silhouette that is perfect for contemporary kitchens. The durable stem mount makes this modern down light even more flexible as it can be hung in both indoor or outdoor locations. Consider this American made light for screened porches, living rooms, or commercial spaces such as retail cash wraps.</p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.</li> <li><span>This light fixture is made-to-order to suit your custom specifications. Learn more about the process<span> </span></span><a href="https://www.barnlight.com/behind-the-scenes-video-footage/">here</a>!</li> <li>Read more about our Tuscany Stem Mount Pendant over on the <a href="/inspiration/professionals-corner-modern-pendants-offer-industrial-vibe-to-cafe/" target="_blank">blog</a>!</li> </ul> minimalist pendant, stem mounted pendant light, colorful pendant lighting, down light pendant, cone pendant light with stem, modern pendant lighting, modern kitchen pendant, sloped pendant light fixture, contemporary lighting, retail cash wrap lighting The Tuscany's sleek, minimalist bell silhouette is perfect for contemporary kitchen. Its durable stem mount appeals to modern commercial lighting! Tuscany Modern Stem Mount Pendant, BLE-S-CAF, tuscany, modern stem mount pendant, modern light, stems, Stem pendant lights, stem light mount, stem light mounts, stem,
61698 <p>Our Tuscany Gooseneck Light brings minimalist style into your home or commercial spaces with its sleek, mini deep bowl shade. This 6.5" shade adds the perfect spot of light to hallways, breakfast nooks and powder rooms! A sturdy gooseneck arm brings this contemporary light to just the right height for your space.</p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>This light fixture is made-to-order to suit your custom specifications. Learn more about the process <a href="https://www.barnlight.com/behind-the-scenes-video-footage/" target="_blank">here</a>!</li> </ul> minimalist lighting for home exteriors, bell jar wall light, minimalist contemporary light, durable outdoor light, industrial garage lighting, modern walkway light, gooseneck down light, dark sky home lighting, factory style lighting, wall light, outdoor The Tuscany's subtly curved shade channels minimalist style into your home or commercial spaces! Add durability with our traditional gooseneck mount! Tuscany Gooseneck Light, BLE-G-CAF, tuscany, modern wall light, modern gooseneck light, SPS-0369, SPS 0369, SPS0369, The Tuscany Collection, The Tuscany Series, Tuscany Collection Tuscany Series, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount gooseneck light, Wall mount gooseneck lights, Wall mount gooseneck lighting, Wall mount gooseneck, Wall mount goosenecks, Wall mounted gooseneck light, Wall mounted gooseneck lights, Wall mounted gooseneck lighting, Wall mounted gooseneck, Wall mounted goosenecks, bleg,
65453 <p>The Tuscany Flush Mount Light strikes a chic, contemporary profile. A sleek round shade, which is affixed to a compact flush mounting, establishes this eye-catching style. With this design, the Tuscany elevates residential and commercial décors while providing the right touches of illumination. <br /><br />Various customizing options let the Tuscany assume the right style for every setting. Ranging from sophisticated to lively, our finish colors give the flush mount light a unique sense of personality. Create a one-of-a-kind look and revamp your home or business with this contemporary lighting fixture!</p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.</li> <li><span>This light fixture is made-to-order to suit your custom specifications. Learn more about the process<span> </span></span><a href="https://www.barnlight.com/behind-the-scenes-video-footage/">here</a>!</li> <li>Shade Size:<strong><span> </span></strong>Width 6.5" x Height 9" </li> <li>Read more about our Tuscany Flush Mount Light over on the blog!</li> </ul> Modern yet timeless, this flush mount light stands out in residential and commercial settings! Customize its appearance and elevate your decor! Tuscany Flush Mount Light, Tuscany Flush Mount, Tuscany Flush Mount Pendant, Tuscany Pendant, Tuscany Pendant Light, Tuscany ceiling light, Tuscany flush mount ceiling pendant, Tuscany flush, Flush Tuscany, The Tuscany Flush Mount Light, The Tuscany Flush Mount, The Tuscany Flush Mount Pendant, The Tuscany Pendant, The Tuscany Pendant Light, The Tuscany ceiling light, The Tuscany flush mount ceiling pendant, The Tuscany flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant,