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 (64657, 65481, 64659) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00036

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": 3,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (64657,65481,64659) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	meta_description	search_words
64657	<p>A timeless aesthetic with contemporary appeal, the Egg Pendant’s versatile sense of style is an instant favorite in every setting. Centered on a dramatic deep bowl shade, this design directs illumination downward while showcasing an eye-catching appearance. This fixture suspends its shade from a classic cord mounting, which imparts a casual feel and allows installation from any ceiling. <br /><br />Fully customizable, an abundance of finish colors and cord options offers endless combinations and configurations for the Egg Pendant’s design, letting everyone create truly unique looks for their projects. With its decorative appeal and functional purpose, this ceiling light can transform and invigorate any décor!</p> <p>\|break\|</p> <ul> <li>Handcrafted and American made in Titusville, Florida</li> <li>Every pendant is made-to-order, learn more about our<span> </span><a href="https://www.barnlight.com/video-gallery/" target="_blank">process</a>!</li> <li>Mix and match interior and exterior finishes</li> <li>See the entire Egg Collection <a href="https://www.barnlight.com/egg-collection-egg/" target="_blank">here</a>!</li> </ul>	A timeless yet unique design, the Egg Cord Hung Pendant Light captures attention in any location! Customize its look with various finish colors and cord styles!	egg, egg pendant, egg cord pendant, egg cord, new listing, BLE-C-DBE, Egg Cord Hung Pendant Light, Egg Cord Hung Pendant Lights, Egg Pendant Light, Egg Pendant, Egg pendants, egg ceiling pendant, egg, egg cord, egg cord hung, egg cord pendant, egg hanging pendant, Egg Cord Hung Pendant Lighting, Egg Pendant lighting, egg, BLE-C-DBE10, BLE-C-DBE16, BLE-C-DBE20, Deep bowl, deep bowls, deep bowl shade, deep bowl shades, deep bowl light, deep bowl lights, deep bowl lighting, deep bowl shade light, deep bowl shade lights, deep bowl shade lighting, deep bowl pendant, deep bowl pendants, deep bowl ceiling pendant, deep bowl ceiling light, deep bowl ceiling lights, deep bowl ceiling lighting, deep bowl pendant light, deep bowl pendant lights, deep bowl pendant lighting, deep bowl shade pendant, deep bowl shade pendants, deep bowl shade ceiling pendant, deep bowl shade ceiling light, deep bowl shade ceiling lights, deep bowl shade ceiling lighting, deep bowl shade pendant light, deep bowl shade pendant lights, deep bowl shade pendant lighting, Deep bowl cord mount, deep bowl cord mounts, deep bowl cord mount light, deep bowl cord mount lights, deep bowl cord mount lighting, deep bowl cord mount pendant, deep bowl cord mount pendants, deep bowl cord mount pendant light, deep bowl cord mount pendant lights, deep bowl cord mount pendant lighting, deep bowl cord mount ceiling light, deep bowl cord mount ceiling lights, deep bowl cord mount ceiling lighting, deep bowl cord mount ceiling pendant, deep bowl cord mount ceiling pendants, Cord mount deep bowl, cord mount deep bowl light, cord mount deep bowl lights, cord mount deep bowl lighting, cord mount deep bowl pendant, cord mount deep bowl pendants, cord mount deep bowl ceiling pendant, cord mount deep bowl ceiling pendants, cord mount deep bowl pendant light, cord mount deep bowl pendant lights, cord mount deep bowl pendant lighting, cord mount deep bowl ceiling light, cord mount deep bowl ceiling lighting, Deep bowl cord hung, deep bowl cord hung light, deep bowl cord hung lights, deep bowl cord hung lighting, deep bowl cord hung pendant, deep bowl cord hung pendants, deep bowl cord hung pendant light, deep bowl cord hung pendant lights, deep bowl cord hung pendant lighting, deep bowl cord hung ceiling light, deep bowl cord hung ceiling lights, deep bowl cord hung ceiling lighting, deep bowl cord hung ceiling pendant, deep bowl cord hung ceiling pendants, Cord hung deep bowl, cord hung deep bowl light, cord hung deep bowl lights, cord hung deep bowl lighting, cord hung deep bowl pendant, cord hung deep bowl pendants, cord hung deep bowl ceiling pendant, cord hung deep bowl ceiling pendants, cord hung deep bowl pendant light, cord hung deep bowl pendant lights, cord hung deep bowl pendant lighting, cord hung deep bowl ceiling light, cord hung deep bowl ceiling lighting, egg collection, egg series, the egg collection, the egg series, SPS-0432, SPS 0432, SPS0432, The egg pendant, 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, 23NDP1023
64659	<p>With its incomparable appearance and slender mounting, this pendant’s design emphasizes both style and function. A decorative addition to any space, the Egg’s simple yet eye-catching shade subtly commands attention as either a focal point or accent piece.</p> <p>Various finish colors and customization options help the Egg adjust its aesthetic to meet every décor’s exact needs. Exclusively made in our Florida-based manufacturing facility, this fixture features a heightened sense of quality. Hanging alone or in groups, this ceiling light can establish an elevated look.</p> <p>\|break\|</p> <ul> <li>Handcrafted and American made in Titusville, Florida</li> <li>Every pendant is made-to-order, learn more about our<span> </span><a href="https://www.barnlight.com/video-gallery/" target="_blank">process</a>!</li> <li>Mix and match interior and exterior finishes</li> <li>See the entire Egg Collection <a href="https://www.barnlight.com/egg-collection-egg/" target="_blank">here</a>!</li> </ul>	Stylish pendant lighting for any space! This stem mount light is handcrafted and fully customizable with various finish colors!	egg, egg stem, egg light, egg pendant, egg stem light, egg stem pendant, new listing, BLE-S-DBE, Egg Stem Mount Pendant Light, Egg Stem Mount Pendant Lights, Egg Stem Mount Pendant Lighting, Egg Pendant, Egg, Egg Stem, Egg Stem Mount, Egg Stem Pendant, Egg Stem light, Egg stem lighting, egg pendant, egg, egg lighting, egg ceiling pendant, egg ceiling lighting, egg stem pendant, BLE-S-DBE10, BLE-S-DBE16, BLE-S-DBE20, Deep bowl, deep bowls, deep bowl shade, deep bowl shades, deep bowl light, deep bowl lights, deep bowl lighting, deep bowl shade light, deep bowl shade lights, deep bowl shade lighting, deep bowl pendant, deep bowl pendants, deep bowl ceiling pendant, deep bowl ceiling light, deep bowl ceiling lights, deep bowl ceiling lighting, deep bowl pendant light, deep bowl pendant lights, deep bowl pendant lighting, deep bowl shade pendant, deep bowl shade pendants, deep bowl shade ceiling pendant, deep bowl shade ceiling light, deep bowl shade ceiling lights, deep bowl shade ceiling lighting, deep bowl shade pendant light, deep bowl shade pendant lights, deep bowl shade pendant lighting, Deep bowl stem mount, deep bowl stem mounts, deep bowl stem mount light, deep bowl stem mount lights, deep bowl stem mount lighting, deep bowl stem mount pendant, deep bowl stem mount pendants, deep bowl stem mount pendant light, deep bowl stem mount pendant lights, deep bowl stem mount pendant lighting, deep bowl stem mount ceiling light, deep bowl stem mount ceiling lights, deep bowl stem mount ceiling lighting, deep bowl stem mount ceiling pendant, deep bowl stem mount ceiling pendants, Stem mount deep bowl, stem mount deep bowl light, stem mount deep bowl lights, stem mount deep bowl lighting, stem mount deep bowl pendant, stem mount deep bowl pendants, stem mount deep bowl ceiling pendant, stem mount deep bowl ceiling pendants, stem mount deep bowl pendant light, stem mount deep bowl pendant lights, stem mount deep bowl pendant lighting, stem mount deep bowl ceiling light, stem mount deep bowl ceiling lighting, egg collection, egg series, the egg collection, the egg series, SPS-0432, SPS 0432, SPS0432, The egg pendant,
65481	<div>A versatile fixture, the Egg Wall Sconce's universal appeal centers on its deep bowl design and simple mounting. The shade's curved shape offers the timeless lines needed by both contemporary and traditional décors. From casual, playful spaces to more upscale venues, the Egg Wall Sconce ensures every setting feels unique and stylish.<br /> <br /> An abundance of finish options, including different colors for the shade's interior and exterior, lets everyone create their own unique designs. Create a custom look and put the finishing touches on your project with the Egg Wall Sconce!</div> <p>\|break\|</p> <ul> <li><span>Handcrafted and American made in Titusville, Florida</span></li> <li>Made-to-order, learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> </ul>	A modern yet timeless wall sconce, this fixture brings style and character to any location! Customize its appearance and elevate your home or business with the Egg Wall Sconce!	BDE, BLE-W-DBE10, Egg, egg sconce, egg wall sconce, egg wall sconces, the egg sconce, the egg wall sconce, egg sconces, egg wall light, egg wall lights, egg wall lighting, egg wall fixture, egg wall fixtures, egg sconce light, egg sconce lights, egg sconce lighting, the egg, navy, DBE10, DBE, W-DBE10, BLE-W-DBE, W-DBE, Deep bowl, deep bowls, deep bowl shade, deep bowl shades, deep bowl light, deep bowl lights, deep bowl lighting, deep bowl shade light, deep bowl shade lights, deep bowl shade lighting, Deep bowl sconce, deep bowl sconces, deep bowl wall sconce, deep bowl wall sconces, deep bowl wall sconce light, deep bowl sconce light, deep bowl sconce lights, deep bowl sconce lighting, deep bowl wall sconce lights, deep bowl wall sconce lighting, deep bowl shade sconce, deep bowl shade sconces, deep bowl shade wall sconce, deep bowl shade wall sconces, deep bowl shade sconce light, deep bowl shade sconce lights, deep bowl shade sconce lighting, deep bowl shade wall sconce light, deep bowl shade wall sconce lights, deep bowl shade wall sconce lighting, deep bowl wall light, deep bowl wall lights, deep bowl wall lighting, deep bowl shade wall light, deep bowl shade wall lights, deep bowl shade wall lighting, deep bowl sconce light fixture, deep bowl sconce light fixtures, deep bowl sconce lighting fixture, deep bowl sconce lighting fixtures, egg collection, egg series, the egg collection, the egg series, SPS-0609, SPS 0609, SPS0609, egg sconce collection, egg sconce series, egg wall sconce collection, egg wall sconce series, the egg sconce collection, the egg sconce series, the egg wall sconce collection, the egg wall sconce series, Interior barn light wall sconce, Interior barn light wall sconces, Interior sconce, interior sconces, interior wall sconce, interior wall sconces, Interior sconce light, Interior sconce lights, Interior sconce lighting, Interior wall light, Interior wall lights, Interior wall lighting, Interior light wall sconce, Interior light wall sconces, Interior light, Interior lights, Interior lighting, wall mount indoor light, wall mount indoor lights, wall mount indoor lighting, wall mount interior light, wall mount interior lights, wall mount interior lighting, wall mounted indoor light, wall mounted indoor lights, wall mounted indoor lighting, wall mounted interior light, wall mounted interior lights, wall mounted interior lighting, interior wall mount light, interior wall mount lights, interior wall mount lighting, interior wall mounted light, interior wall mounted lights, interior wall mounted lighting, wall mount interior sconce, wall mount interior sconces, wall mount interior wall sconce, wall mount interior wall sconces, wall mounted interior sconce, wall mounted interior sconces, wall mounted interior wall sconce, wall mounted interior wall sconces, wall mount indoor sconce, wall mount indoor sconces, wall mount indoor wall sconce, wall mount indoor wall sconces, wall mounted indoor sconce, wall mounted indoor sconces, wall mounted indoor wall sconce, wall mounted indoor wall sconces, Indoor barn light wall sconce, Indoor barn light wall sconces, Indoor sconce, Indoor sconces, Indoor wall sconce, Indoor wall sconces, Indoor sconce light, Indoor sconce lights, Indoor sconce lighting, Indoor wall light, Indoor wall lights, Indoor wall lighting, Indoor light wall sconce, Indoor light wall sconces, Indoor light, Indoor lights, Indoor lighting, 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 sconce light, Wall mount sconce lights, Wall mount sconce lighting, Wall mount sconce, Wall mount sconces, Wall mounted sconce light, Wall mounted sconce lights, Wall mounted sconce lighting, Wall mounted sconce, Wall mounted sconces, 10 inch, 10 inch shade, 10" shade, plug in barn light, plug-in barn light, plug-in light,