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

Query time 0.00050

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": 2,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65462,65454) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
65454 <p>Modern lighting stands out with its clean, round lines and chic styles, and the Chateau perfects this look! As either an accent piece or focal point, this flush mount pendant’s curved profile functions as subtle hints of character in residential and commercial lighting plans. Customize the Chateau’s appearance with your favorite finish color and other unique options.  </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> </span></span><a href="https://www.barnlight.com/behind-the-scenes-video-footage/">here</a>!</li> <li>Shade Size:<strong><span> </span></strong>Width 6.5" x Height 9" </li> <li>Read more about our Chateau Flush Mount Light over on the <a href="/inspiration/professionals-corner-modern-pendants-offer-industrial-vibe-to-cafe/" target="_blank">blog</a>!</li> </ul> Flush mount lighting with a modern edge, the Chateau elevates residential and commercial spaces! American made and handcrafted, this fully customizable flush mount light will transform every decor! Chateau Flush Mount Light, Chateau Flush Mount, Chateau Flush Mount Pendant, Chateau Pendant, Chateau Pendant Light, Chateau ceiling light, Chateau flush mount ceiling pendant, Chateau flush, Flush Chateau, The Chateau Flush Mount Light, The Chateau Flush Mount, The Chateau Flush Mount Pendant, The Chateau Pendant, The Chateau Pendant Light, The Chateau ceiling light, The Chateau flush mount ceiling pendant, The Chateau flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant, BLE-F-BIS,
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,