Sandbox

SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    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, 
  cscart_product_descriptions.unit_name 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (176) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00036

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "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	unit_name
176		<p> <p class="prod16bold" style="margin-top: 0px; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; color: #333333; font-weight: bold; font-size: 16px; text-align: left; text-decoration: none; font-family: Verdana, Arial, Helvetica, sans-serif; background-color: #ffffff;"><span id="_ctl0_MainContent_lblTitle">Quartet® Euro™ Magnetic Porcelain Total Erase® Mobile Easel</span></p> <p class="body12" style="margin-top: 0px; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; color: #333333; font-size: 12px; text-align: left; text-decoration: none; font-family: Verdana, Arial, Helvetica, sans-serif; background-color: #ffffff;"><span id="_ctl0_MainContent_lblDescription">Ultra-durable, ultra-smooth 27" x 41" mobile presentation easel with DuraMax® porcelain surface that will not scratch, dent, stain or ghost. Delivers superior performance when collaboration is needed in high-profile, heavy-use office environments. Magnetic surface doubles as bulletin board. Easy-to-clean writing surface requires minimal use of Quartet® cleaning solutions. Adjustable hooks and clamp hold standard-sized flipcharts for easy sheet tear-away meeting notes. Smooth-rolling 5-caster star-base wheels lock firmly in place for total control and mobility. Flexible spring-loaded height adjuster moves from 67" to 77" for optimal height. Includes spacious folding accessory tray and 4 assorted Quartet® whiteboard markers. Sleek Euro™ design with matte aluminum finish for maximum style and durability. 100% Satisfaction Guaranteed.</span></p> <p class="body12" style="margin-top: 0px; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; color: #333333; font-size: 12px; text-align: left; text-decoration: none; font-family: Verdana, Arial, Helvetica, sans-serif; background-color: #ffffff;"><span id="_ctl0_MainContent_lblFeatures"> </span></p> <ul style="color: #000000; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; text-align: left; background-color: #ffffff;"> <li class="body12" style="color: #333333; font-size: 12px; text-align: left; text-decoration: none;">Ultra-durable, ultra-smooth 27" W x 41" H mobile presentation easel with DuraMax® porcelain surface that will not scratch, dent, stain or ghost</li> <li class="body12" style="color: #333333; font-size: 12px; text-align: left; text-decoration: none;">Delivers superior performance when collaboration is needed in high-profile, heavy-use office environments</li> <li class="body12" style="color: #333333; font-size: 12px; text-align: left; text-decoration: none;">Magnetic surface doubles as bulletin board</li> <li class="body12" style="color: #333333; font-size: 12px; text-align: left; text-decoration: none;">Adjustable hooks and clamp hold standard-sized flipcharts for easy sheet tear-away</li> <li class="body12" style="color: #333333; font-size: 12px; text-align: left; text-decoration: none;">Easy-to-clean writing surface requires minimal use of Quartet® cleaning solutions</li> <li class="body12" style="color: #333333; font-size: 12px; text-align: left; text-decoration: none;">Smooth-rolling 5-caster star-base wheels lock firmly in place for total control and mobility</li> <li class="body12" style="color: #333333; font-size: 12px; text-align: left; text-decoration: none;">Flexible spring-loaded height adjuster moves from 67" to 77" for optimal height</li> <li class="body12" style="color: #333333; font-size: 12px; text-align: left; text-decoration: none;">Includes spacious folding accessory tray and 4 assorted Quartet® whiteboard markers</li> <li class="body12" style="color: #333333; font-size: 12px; text-align: left; text-decoration: none;">Sleek Euro™ design with matte aluminum finish for maximum style and durability</li> <li class="body12" style="color: #333333; font-size: 12px; text-align: left; text-decoration: none;">100% Satisfaction Guaranteed</li> </ul> </p>				<p class="product-promo-text"><span class="product-promo-header">FREE US shipping over $100!</span><span class="product-promo-body">Orders within next 2 days will be shipped on Monday</span></p>