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 (61518, 61517, 62595, 65462, 65474) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00077

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 (61518,61517,62595,65462,65474) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	meta_keywords	meta_description	search_words
61517	<p>Add some industrial styling to your kitchen or dining room with The Blue Collar Pendant! With its wire cage guard silhouette, industrial pendant lighting is ideal for any space where you need bright task lighting. Functioning as both warehouse lighting and stylish interior lighting, the Blue Collar Pendant is capable of illuminating any space. Giving any room a modern feel, industrial pendants provide both style and functionality.</p> <p>American made and available in three shades sizes, this ceiling light can be customized with finish and cording options to complement any residential or commercial venue!</p> <p>\|break\|</p> <ul> <li>Features a die casted wire guard, steel wire cage and jelly jar glass.</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> <li>Read more about the Blue Collar Pendant Light in the Ben and Jerry's Vermont HQ break room over on our <a href="https://www.barnlight.com/inspiration/industrial-lighting-brings-rustic-vibe-to-ben-jerrys-vermont-hq/" target="_blank">blog</a>!</li> </ul>	wire guard warehouse shade pendant light, industrial guard shade pendant, wire guard ceiling light, caged pendant light	The Blue Collar pendant shows off industrial styling with its wire cage guard silhouette. This caged pendant light is ideal for kitchen lighting and bright task lighting!	Blue Collar Pendant, BLE-C-WGGWS, wire guard warehouse shade, wire guard shade, wire guard pendant, cage light, BLE-C-WGGWS12, BLE-C-WGGWS14, BLE-C-WGGWS16, caged pendant, caged pendant light, caged light, blue collar wire guard, blue collar warehouse shade, blue collar pendant, blue collar caged pendant, blue collar cage pendant, blue collar wire cage pendant, blue collar wire cage guard pendant, blue collar cage light, blue collar wire cage light, blue collar, blue collar cord hung, blue collar cord hung pendant, blue collar ceiling light, wire cage ceiling light, blue collar wire cage ceiling light, cord hung cage light, cage light, cage guard light, wire guard cage, wire guard light, blue collar wire guard, new listing, BLE-C-WGGWS12, BLE-C-WGGWS14, BLE-C-WGGWS16, blue collar collection, blue collar series, the blue collar collection, the blue collar series, SPS-0054, SPS 0054, SPS0054, 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,
61518	<p>This utilitarian ceiling light is loaded with industrial detailing from the sturdy stem mounting down to the wire cage and cast guard. American made from commercial grade materials, this wire guard pendant adds plenty of illumination to kitchen islands and dining rooms as well as restaurants, retail stores, and other commercial venues. Customize this rustic pendant with size, color, and mounting options!</p> <p>\|break\|</p> <ul> <li>Features a die casted wire guard, steel wire cage and jelly jar glass.<span> </span></li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> <li>Read more about the Blue Collar Stem Mount Pendant over on our<span> <a href="/inspiration/gooseneck-barn-lights-for-new-meerkat-exhibit-at-brevard-zoo/" target="_blank">blog</a></span>!</li> </ul>	wire cage stem mount pendant, stem mount industrial pendant, rustic swag light, wire cage warehouse shade pendant, wire guard pendant, wire guard stem mount ceiling light, decorative wire guard shade	The Blue Collar Pendant combines a wire guard warehouse shade with a hefty stem mount pendant for an industrial but airy statement light fixture.	The Blue Collar Stem Mount Pendant, BLE-S-WGGWS, blue collar pendant, wire guard shade, BLE-S-WGGWS12-PC, BLE-S-WGGWS14-PC, BLE-S-WGGWS16-PC, wire shade, wire pendant light, wire guard pendant light, wire guard stem mount, wire guard shade light, wire guard lighting, wire guard rlm shade, wire guard ceiling light, wire ceiling light, ceiling light, ceiling pendant light, stem mount ceiling light, blue collar pendant, blue collar wire guard, blue collar wire guard lighting, blue collar stem mount, blue collar stem mount lighting, blue collar industrial pendant, blue collar industrial pendant lighting, blue collar wire guard industrial pendant lighting, blue collar, blue collar light, blue collar lights, blue collar lighting, new listing, BLE-S-WGGWS12, BLE-S-WGGWS14, BLE-S-WGGWS16, blue collar collection, blue collar series, the blue collar collection, the blue collar series, SPS-0054, SPS 0054, SPS0054, stems, Stem pendant lights, stem light mount, stem light mounts, stem, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside pendant, Outside pendants, Outside ceiling pendant, Outside ceiling pendants, Outside pendant light, Outside pendant lights, Outside pendant lighting, Outside ceiling pendant, Outside ceiling pendants, pendent light, pendent lights, pendent lighting, pendent, ceiling pendent, ceiling pendents, Industrial pendent lighting, Industrial pendent light, Industrial pendent lights, Industrial ceiling pendent, Industrial ceiling pendents, outdoor pendent, outdoor pendents, outdoor pendent light, outdoor pendent lights, outdoor pendent lighting, outdoor ceiling pendent, outdoor ceiling pendents,
62595	<p>This utilitarian ceiling light is loaded with industrial detailing from the combination chain-and-cord mounting down to the wire cage and rugged cast guard. American made from commercial grade materials, this wire guard pendant adds plenty of industrial style and illumination to kitchen islands and dining rooms and is suitable for restaurants, retail stores, and other commercial venues too.</p> <p>Customize the Blue Collar Chain Hung Pendant with shade size, finish color, glass and mounting options. For a similar look in a different mount, don't miss the <a title="Blue Collar Stem Mount Pendant" href="/lighting/ceiling-lights/stem-mount-pendant-lighting/blue-collar-stem-mount-pendant/">Blue Collar Stem Mount Pendant</a> and to save money on your energy bills, check out the <a title="Blue Collar LED Pendant" href="/led-lighting/ceiling-lights/chain-hung-pendant-lighting/blue-collar-led-chain-hung-pendant-light/">Blue Collar LED Pendant</a>!</p> <p>\|break\|</p> <ul> <li>Features a die casted wire guard, steel wire cage and jelly jar glass.<span> </span></li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> </ul>		It doesn't get any more rugged than this! Our Blue Collar Chain Hung Pendant features a wire cage light shade, industrial guard, glass jelly jar and chain mount!	blue collar chain hung pendant light, the blue collar chain hung light, chain hung lighting, chain hung pendant, wire guard pendant light, wired pendant light, blue collar chain hung light, rugged lighting, wire guard light, industrial lighting, BLE-C-WGGWS-PC-CN36, BLE-C-WGGWS12-PC-CN36, BLE-C-WGGWS14-PC-CN36, BLE-C-WGGWS16-PC-CN36, new listing, BLE-CN-WGGWS12, BLE-CN-WGGWS14, BLE-CN-WGGWS16, blue collar collection, blue collar series, the blue collar collection, the blue collar series, SPS-0054, SPS 0054, SPS0054,
65462	<p>The Blue Collar Flush Mount proves that industrial styles can still feel creative and unique. In this design, sturdy metal wire assumes the shape of conventional RLM shades and guards. The fixture’s flush mounting allows installation closely against the ceiling, making the Blue Collar a stylish addition to hallways, entryways, and other undersized areas. <br /><br />With an abundance of customizing options, this flush mount light takes on color and personality. Bring a unique style and plenty of illumination to every décor with the Blue Collar Flush mount!</p> <p>\|break\|</p> <ul> <li>Features a die casted wire guard, steel wire cage and jelly jar glass.<span> </span></li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> </ul>		A unique industrial flush mount light! The Blue Collar helps modern homes and businesses feel stylish, timeless, and one-of-a-kind. Customizable with finish and glass options!	BLE-F-WGGWS, Blue collar Flush Mount Light, Blue collar Flush Mount, Blue collar Flush Mount Pendant, Blue collar Pendant, Blue collar Pendant Light, Blue collar ceiling light, Blue collar flush mount ceiling pendant, Blue collar flush, Flush Blue collar, The Blue collar Flush Mount Light, The Blue collar Flush Mount, The Blue collar Flush Mount Pendant, The Blue collar Pendant, The Blue collar Pendant Light, The Blue collar ceiling light, The Blue collar flush mount ceiling pendant, The Blue collar flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant,
65474	<p>The Blue Collar represents a union between old-world designs and modern efficiency standards. To create this look, sturdy metal wire assumes the shape of a traditional RLM shade. This creative yet still classic design offers a timeless look, elevating both modern and traditional décors. Our diverse assortment of finish and customizing options gives the Blue Collar its unique personality. <br /><br />This fixture also becomes a practical addition to a home or business by integrating cutting-edge LED components into its design. With this technology, the Blue Collar is among the most efficient lighting options for homes and businesses. Simply installing LED lighting will lower power costs and let a building meet strict building codes.</p> <p>\|break\|</p> <ul> <li>Features a die casted wire guard, steel wire cage and jelly jar glass.</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>!</li> </ul>		Authentic industrial charm and integrated LED technology! This flush mount pendant is the perfect option for smaller spaces. Save money as you revamp your décor!	BLE-F-WGGWS-LED, Blue collar LED, LED blue collar, Blue collar LED Flush Mount Light, Blue collar LED Flush Mount, Blue collar LED Flush Mount Lighting, Blue collar LED Flush Mount Lights, Blue collar LED Flush Mount pendant, Blue collar LED Flush Mount pendant Light, Blue collar LED Flush Light, Blue collar LED Flush pendant Light, Blue collar LED Flush pendant, Blue collar, BLE-F-WGGWS, Blue collar Flush Mount Light, Blue collar Flush Mount, Blue collar Flush Mount Pendant, Blue collar Pendant, Blue collar Pendant Light, Blue collar ceiling light, Blue collar flush mount ceiling pendant, Blue collar flush, Flush Blue collar, The Blue collar Flush Mount Light, The Blue collar Flush Mount, The Blue collar Flush Mount Pendant, The Blue collar Pendant, The Blue collar Pendant Light, The Blue collar ceiling light, The Blue collar flush mount ceiling pendant, The Blue collar flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant,