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 (62230, 65720, 65721) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00031

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 (62230,65720,65721) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	meta_keywords	meta_description	search_words
62230	<p>Although first introduced in the early 20<sup>th</sup> century, the Parabolic 3-Light Chandelier is a favorite in contemporary décors. This popularity is due to the fixture’s simple, half-dome shades and refined stem mounting. From traditional spaces to midcentury or modern styles, this chandelier complements and elevates any setting.</p> <p>Customize this unique pendant light with dozens of powder coat finishes. Handcrafted in the United States, the Parabolic still features the same commitment to craftsmanship as vintage, antique fixtures.</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><a href="https://www.barnlight.com/behind-the-scenes-video-footage/" target="_blank">here</a><span>!</span></li> </ul>	three light pendant, parabolic light, stem pendant light, mid century lighting, retro pendant light	Bring mid century lighting to any space with this 3-light chandelier. The Parabolic Chandelier features a refined stem pendant and retro, half-dome shades.	Parabolic 3-Light Chandelier, BLE-S-CH013, clamshell light, half shade pendant, chandelier, mid century, parabolic light, parabolic shade pendant, retro chandelier, parabolic, parabolic 3-light, 3-light parabolic, parabolic 3 light, 3 light parabolic, three light parabolic, parabolic three light, Parabolic 3 light chandelier, chandelier, chandeliers, three light chandelier, three light chandeliers, 3-light chandelier, 3-light chandeliers, 3 light chandelier, 3 light chandeliers, industrial chandelier, industrial chandeliers, farmhouse chandelier, farmhouse chandeliers, farm house chandelier, farm house chandeliers, small chandeliers,
65720	<p>Harkening back to early 20<sup>th</sup><span> </span>century designs, the Parabolic Wall Sconce features a simple, half-dome shade and slender adjustable arm. This sleek style, a favorite for both contemporary and traditional spaces, is perfect as a bedside light or for any space that needs focused task lighting.</p> <p>Easy to customize with more than 30 powder coat finish colors, this attractive wall sconce can be built to complement any d<span>é</span>cor. Handcrafted in the United States, the Parabolic Wall Sconce features the same commitment to craftsmanship and quality as vintage, antique fixtures.</p> <p>\|break\|</p> <ul> <li>Manufactured and handcrafted in the USA</li> <li><span><span class="ui-provider fz b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak" dir="ltr">Love this design but need a plug-in version? We've got you covered! Shop our plug-in version <a href="/lighting/wall-lights/wall-sconces/parabolic-plug-in-wall-sconce/">here</a>!</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>			parabolic sconce
65721	<p>The simple, rounded shade of the Parabolic Plug-In Wall Sconce offers a classic profile but can take on a more contemporary flair with a variety of powder coat finish colors. Choose traditional Black, White or Galvanized, or add updated style with Magenta, Royal Blue, or Lavendar.</p> <p>Mounted on a slender, adjustable arm, this wall light features plug-in convenience! Perfect for bedside lighting, workplace lighting, or any space that needs dedicated task lighting. American made to last!</p> <p> </p> <p>\|break\|</p> <ul> <li>Manufactured and handcrafted in the USA</li> <li><span><span class="ui-provider fz b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak" dir="ltr">Love this design but prefer it without the cord and plug? We've got you covered! Shop our hardwired version <a href="/lighting/wall-lights/wall-sconces/parabolic-wall-sconce/">here!</a></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>			parabolic wall sconce, parabolic sconce, parabolic plugin, parabolic plug in,