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 (62449) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00045

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
62449 <p>With a clean-cut, streamline style straight from the Atomic Era, the Brewster Pendant Light features a three-ring pendant design and durable cord mount. American made of commercial grade materials, this modern ring pendant light is custom made to your specifications. Choose finish color plus cord options to personalize this industrial ceiling light. </p> <p>Suitable for kitchens and dining rooms or commercial spaces that desire a unique industrial look to complement their brand. Hang alone or in pairs! Interested in saving time and money without sacrificing the style you love? Then go green with our <a href="/led-lighting/ceiling-lights/cord-hung-pendant-lighting/brewster-led-pendant-light/" target="_blank">Brewster LED Pendant Light</a><span>!</span></p> <p>|break|</p> <ul> <li><span>Manufactured in the U.S.A.</span></li> <li>Made-to-order, learn more about the process <a href="https://www.barnlight.com/video-gallery/">here</a>.</li> <li><span>Read more about the Brewster Pendant Light over on our<span> <a href="https://www.barnlight.com/inspiration/custom-lighting-delivers-punch-of-industrial-style-to-california-remodel/" target="_blank">blog</a></span></span>!</li> </ul> modern industrial pendant, modern kitchen light, modern ring pendant light, kitchen island pendant The Brewster Pendant boasts a clean-cut, streamline style straight from the Atomic Era with its three-ring pendant design and durable cord mount. Barn Light Brewster Pendant, Cord Hung, Brewster, Atomic light, rugged pendant, modern pendant, C-10LC, BLE-C-ULBR-PC, kitchen island light, ring pendant, halo pendant, ring pendant light, Pendant island lights, SPS-0034, SPS 0034, SPS0034, Brewster Collection, Brewster Series, The Brewster Collection, The Brewster Series, 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,