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 (65814, 65733, 65101, 65965) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00046

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": 4,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65814,65733,65101,65965) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	meta_description	search_words
65101	<p><span data-contrast="auto"><span data-wac-het="1">With its classic lines and large-scale profile, the Sinclair offers a simple yet commanding<span> </span></span></span><span data-contrast="auto"><span data-wac-het="1">look</span></span><span data-contrast="auto"><span data-wac-het="1">. Inspired by vintage shallow bowl shades, this pendant demonstrates the timelessness sought for both contemporary and traditional décors. A sturdy wire cable supports the shade’s substantial size and supplies a casual, industrial charm. As either a dramatic focal point or dynamic accent piece, the Sinclair helps every space feel stylish and elevated. </span></span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}" data-wac-het="1"> </span></p> <p><span data-contrast="auto"><span data-wac-het="1">Along with its memorable aesthetic, the shallow bowl shade also spreads ample illumination throughout an entire venue. Manufactured in the United States, the Sinclair is a rugged, dependable lighting option. An abundance of finish and other customizing options let this fixture adapt to any setting’s unique sense of style.</span></span></p> <p>\|break\|</p> <ul> <li>Features a 28" oversized shade, hand spun in the USA </li> <li><span>Made-to-order, learn more about the process</span><span> </span><a href="https://www.barnlight.com/video-gallery/">here</a><span>.</span></li> <li><span>LED version coming soon!</span></li> </ul>	With its large-scale profile and classic appearance, the 28” Sinclair stands out in every décor! Customize its appearance with your favorite finish color!	BLE-C-STU-SBS28, Sinclair 28" Pendant Light, Sinclair 28" Pendant, Sinclair 28" Light, Sinclair 28" Cord Pendant Light, Sinclair 28" Cord Pendant, Sinclair 28" Cord Light, Sinclair 28" Cord, Sinclair 28 Pendant Light, Sinclair 28 Pendant, Sinclair 28 Light, Sinclair 28 Cord Pendant Light, Sinclair 28 Cord Pendant, Sinclair 28 Cord Light, Sinclair 28 Cord, 28” Sinclair Pendant Light, 28” Sinclair Pendant, 28” Sinclair Light, 28” Sinclair Cord Pendant Light, 28” Sinclair Cord Pendant, 28” Sinclair Cord Light, 28” Sinclair Cord, 28” Sinclair Pendant Light, 28” Sinclair Pendant, 28” Sinclair Light, 28” Sinclair Cord Pendant Light, 28” Sinclair Cord Pendant, 28” Sinclair Cord Light, 28” Sinclair Cord, 28 Sinclair Pendant Light, 28 Sinclair Pendant, 28 Sinclair Light, 28 Sinclair Cord Pendant Light, 28 Sinclair Cord Pendant, 28 Sinclair Cord Light, 28 Sinclair Cord, Sinclair, Sinclair Pendant Light, Sinclair Pendant, Sinclair Cord Pendant, Sinclair Cord, 28”, 28" sinclair,
65733	<p><span>Make a bold statement with the eye-catching Avalon Studio Light! This light features an impressive 42" handspun shade crafted from high-quality aluminum ensuring long-lasting performance. The generous shade allows for a wide spread of light making it ideal for use over large workspaces or tables. The studio mounting features both cord and cable which lends a contemporary look.</span></p> <p><span>The American-made Avalon Studio Light can be customized with one of more than two dozen powder coat finish colors as well as a variety of cord colors allowing you to create a fixture to complement your home or business décor. </span></p> <p>\|break\|</p> <ul> <li>Hand built with an American-made RLM warehouse shade, <span>this quality industrial pendant</span><span> </span><span><span>is a lasting lighting option!</span></span></li> <li>Made-to-order; learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> <li><span>Freight delivery required.</span></li> </ul>		42" avalon, oversized avalon, 42 avalon, avalon 42, avalon 42",
65814	<p>This impressive 30" barn light will make an attention-getting addition to your home or commercial business! Choose from a variety of finish colors for the classic warehouse shade which is suspended from a durable cable mounting with an electrical cord to complete the look. This union between farmhouse details and a more relaxed mounting perfectly express the character of the Chestnut! </p> <p>American made and rugged enough for commercial applications, the Chestnut Studio Light gives its stylish take on warehouse lighting. Handcrafted to last, this pendant offers the durability needed in both industrial and high-traffic areas while still providing plenty of style.</p> <p>\|break\|</p> <ul> <li>Hand built with an American-made RLM warehouse shade, <span>this quality industrial pendant</span><span> </span><span><span>is a lasting lighting option!</span></span></li> <li>Made-to-order; learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> <li><span>Freight delivery required.</span></li> </ul>		30" chestnut, oversized chestnut, 30 chestnut, chestnut 30, chestnut 30",
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,