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 (61692, 61695, 61699, 61531, 65454) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00040

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 (61692,61695,61699,61531,65454) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	meta_keywords	meta_description	search_words
61531	<p>Keep those hot dishes hot with our Chateau Food Warmer Pendant! With a sleek, minimal sloping cylindrical shade, this decorative restaurant pendant can be paired with a heating lamp bulb for food warming applications. American made and customizable with a variety of finish colors to complement your commercial brand!</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>	bell kitchen light, commercial pendant lighting, 250W pendant light, heat warmer pendant light, food warmer ceiling light, restaurant lighting, decorative restaurant lighting, streamline diner pendant light	The Chateau heating light has a minimal sloping cylindrical shade. This commercial pendant can be paired with a heating lamp bulb for food warming applications.	Food Warming Commercial Curry 6" 250W Heat Warmer Pendant, 10FW400, food warmer lights, commercial lighting, restaurant lighting, commercial pendant, Bistro Food Warmer Pendant, BLE-C-FW-BISTRO, foodwarmer, food warming, food lamp, food light, restaurant heat lamps, food heat lamp, heat lamp, food lighting, food warmer, food warmer pendant, food warmer pendants, food warming pendant, food warming pendants, restaurant food warmer, restaurant food warming pendant, heat lamp, restaurant heat lamp, Chateau Collection, Chateau Series, The Chateau Collection, The Chateau Series, SPS-0261, SPS 0261, SPS0261, CHEATEAU, heatlamp, warming lights, warming light, warming lighting, warming pendant, warming pendants, warming ceiling pendant, warming ceiling pendants, warming lamp, buffet lamps, food warmers,
61692	<p>Injecting an unequaled elegance into classic industrial lighting fixtures, the Chateau Cord Hung Pendant becomes an eye-catching piece in any space. With an undersized shade, this fixture can be installed on its own or in groups. Allow this ceiling light to illuminate your kitchen or living space. With its sleek warehouse shade, this option suits restaurant lighting needs, heightening modern decors.</p> <p>This cord hung lighting is handspun by skilled, American craftsmen, a process that ensures a quality lighting option. With a wide array of cord options and finish colors available, this ceiling light is adaptable, available to take on a variety of looks!</p> <p>\|break\|</p> <ul> <li>Manufactured in the U.S.A. </li> <li>This pendant is made-to-order to suit your custom specifications, learn more about the process<span> </span><a href="https://www.barnlight.com/behind-the-scenes-video-footage/">here</a>! </li> </ul>	American made lighting, ceiling lighting, pendant lights	Cluster the Chateau Cord Hung Pendant for an eye catching lighting display. Hand spun by local artisans, hang these unique pendants in your home or office today!	Chateau Modern Cord Hung Pendant, chateau, BLE-C-BIS, modern pendant, minimalist pendant, cord hung pendant, cord hung modern, modern cord hung, modern, ceiling pendant, cord hung pendant, The Chateau Modern Cord Hung Pendant, Chateau Collection, Chateau Series, The Chateau Collection, The Chateau Series, SPS-0371, SPS 0371, SPS0371, BLE-C-BIS, CHEATEAU, SPS-0371, 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,
61695	<p>Add an eye-catching detail to your residential or commercial lighting plan with the Chateau Stem Mount Pendant. This hand crafted, mid century modern light is American made with quality materials to give you years of service. Customize with an array of powder coat finishes and mounting options. Hang in pairs or groups for a style statement like no other!</p> <p>\|break\|</p> <ul> <li>Made 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><span>!</span></li> </ul>	modern pendant lighting, hand crafted lighting, modern home decor lighting, modern kitchen lighting, contemporary island light, mid century modern stem light, can pendant light, modern bell light, bell shape pendant light, downlight pendant, retail cash,	Use the Chateau Pendant for an eye-catching lighting display for commercial and residential lighting plans! Its sleek and modern design is sure to create the perfect aesthetic for your space.	Chateau Stem Mount, BLE-S-BIS, Chateau, modern stem mount, modern pendant, modern stem, Chateau Collection, Chateau Series, The Chateau Collection, The Chateau Series, SPS-0371, SPS 0371, SPS0371, BLE-S-BIS, CHEATEAU, stems, Stem pendant lights, stem light mount, stem light mounts, stem,
61699	<p>With sleek lines and chic contemporary appeal, the Chateau features a unique style and character. Mounting this shade to a sturdy gooseneck arm allows installation in both indoor and outdoor settings, immediately elevating any décor. When outfitted with this fixture, homes and businesses can present updated, modern curb appeals and adopt inimitable interior designs.</p> <p>An abundance of finish colors lets the Chateau complement the numerous styles prominent in today’s homes and businesses, ranging from refined to playful. Create an eye-catching look and transform your space with one-of-a-kind gooseneck lighting.</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/">here</a>!</li> </ul>	bell shade gooseneck light, hand crafted gooseneck light, modern exterior lighting, modern garage lighting, contemporary outdoor wall lighting fixtures, outdoor wall light fixture, modern lantern style lighting, architectural wall light, GU 24 decorative	Add decorative down lighting with our Chateau Gooseneck Light! Its decoratively spun cone shape and durable wall arm makes it great for modern facades!	Chateau Gooseneck Light, BLE-G-BIS, modern gooseneck, modern wall light, chateau, chateau gooseneck, chateau wall light, chateau light, Chateau Collection, Chateau Series, The Chateau Collection, The Chateau Series, SPS-0371, SPS 0371, SPS0371, CHEATEAU, 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,
65454	<p>Modern lighting stands out with its clean, round lines and chic styles, and the Chateau perfects this look! As either an accent piece or focal point, this flush mount pendant’s curved profile functions as subtle hints of character in residential and commercial lighting plans. Customize the Chateau’s appearance with your favorite finish color and other unique options. </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 Chateau Flush Mount Light over on the <a href="/inspiration/professionals-corner-modern-pendants-offer-industrial-vibe-to-cafe/" target="_blank">blog</a>!</li> </ul>		Flush mount lighting with a modern edge, the Chateau elevates residential and commercial spaces! American made and handcrafted, this fully customizable flush mount light will transform every decor!	Chateau Flush Mount Light, Chateau Flush Mount, Chateau Flush Mount Pendant, Chateau Pendant, Chateau Pendant Light, Chateau ceiling light, Chateau flush mount ceiling pendant, Chateau flush, Flush Chateau, The Chateau Flush Mount Light, The Chateau Flush Mount, The Chateau Flush Mount Pendant, The Chateau Pendant, The Chateau Pendant Light, The Chateau ceiling light, The Chateau flush mount ceiling pendant, The Chateau flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant, BLE-F-BIS,