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

Query time 0.00038

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
64352		<p>Successfully channeling midcentury nostalgia, the Bubble Stem Mount honors a classic look while still remaining relevant to the current era’s trends and preferences. To establish its nearly universal appeal, this pendant affixes a vintage-style globe shade and socket to a slender stem mounting. With this simple yet still highly fashionable aesthetic, the Bubble functions as the subtle accent piece needed to elevate residential and commercial décors.</p> <p>A vast selection of finish colors lets the Bubble adapt to any room’s particular requirements. Lively and playful colors, like Sunflower and Teal, enlivens a room, but more subdued neutral tones lets the pendant comply with already established décors. A white shade slightly mutes the light, imbuing a room with warmness, while more light escapes from the clear glass to brighten the space.</p> <p>\|break\|</p> <ul> <li>Manufactured in the U.S.A. </li> <li><span><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></span></li> <li><span>Read more about the Bubble Stem Mount Pendant over on our <a href="https://www.barnlight.com/inspiration/bubble-lights-embrace-minimalist-design-trends/" target="_blank">blog</a>!</span></li> </ul>		Classic midcentury style in a pendant light! Fully customizable with numerous finish options — including brass — and glass options! Free shipping!	The Bubble Stem Mount Pendant, The Bubble Stem Mount Pendant Light, The Bubble Stem Mount Pendant Lights, The Bubble Stem Mount Pendant Lighting, The Bubble Stem Mount Ceiling Pendant, The Bubble Stem Mount Ceiling Pendants, The Bubble Stem Mount Ceiling Light, The Bubble Stem Mount Ceiling Lights, The Bubble Stem Mount Ceiling Lighting, Bubble Stem Mount Pendant, Bubble Stem Mount Pendant Light, Bubble Stem Mount Pendant Lights, Bubble Stem Mount Pendant Lighting, Bubble Stem Mount Ceiling Pendant, Bubble Stem Mount Ceiling Pendants, Bubble Stem Mount Ceiling Light, Bubble Stem Mount Ceiling Lights, Bubble Stem Mount Ceiling Lighting, The Bubble Stem Pendant, The Bubble Stem Pendant Light, The Bubble Stem Pendant Lights, The Bubble Stem Pendant Lighting, The Bubble Stem Ceiling Pendant, The Bubble Stem Ceiling Pendants, The Bubble Stem Ceiling Light, The Bubble Stem Ceiling Lights, The Bubble Stem Ceiling Lighting, Bubble Stem Pendant, Bubble Stem Pendant Light, Bubble Stem Pendant Lights, Bubble Stem Pendant Lighting, Bubble Stem Ceiling Pendant, Bubble Stem Ceiling Pendants, Bubble Stem Ceiling Light, Bubble Stem Ceiling Lights, Bubble Stem Ceiling Lighting, The Bubble Pendant, The Bubble Pendant Light, The Bubble Pendant Lights, The Bubble Pendant Lighting, The Bubble Ceiling Pendant, The Bubble Ceiling Pendants, The Bubble Ceiling Light, The Bubble Ceiling Lights, The Bubble Ceiling Lighting, Bubble Pendant, Bubble Pendant Light, Bubble Pendant Lights, Bubble Pendant Lighting, Bubble Ceiling Pendant, Bubble Ceiling Pendants, Bubble Ceiling Light, Bubble Ceiling Lights, Bubble Ceiling Lighting, Midcentury pendant, mid-century pendant, mid century pendant, Midcentury pendant light, mid-century pendant light, mid century pendant light, Midcentury pendant lights, mid-century pendant lights, mid century pendant lights, Midcentury pendant lighting, mid-century pendant lighting, mid century pendant lighting, Midcentury ceiling pendant, mid-century ceiling pendant, mid century ceiling pendant, Midcentury ceiling pendants, mid-century ceiling pendants, mid century ceiling pendants, Midcentury ceiling light, mid-century ceiling light, mid century ceiling light, Midcentury ceiling lights, mid-century ceiling lights, mid century ceiling lights, Midcentury ceiling lighting, mid-century ceiling lighting, mid century ceiling lighting, Midcentury light, mid-century light, mid century light, Midcentury lights, mid-century lights, mid century lights, Midcentury lighting, mid-century lighting, mid century lighting, Modern pendant, modern pendants, modern pendant light, modern pendant lights, modern pendant lighting, modern ceiling pendant, modern ceiling pendants, modern ceiling light, modern ceiling lights, modern ceiling lighting, contemporary pendant, contemporary pendants, contemporary ceiling pendant, contemporary ceiling pendants, contemporary pendant light, contemporary pendant lights, contemporary pendant lighting, contemporary ceiling light, contemporary ceiling lights, contemporary ceiling lighting, midcentury light, mid-century lights, mid century lighting, modern light, modern lights, modern lighting, contemporary light, contemporary lights, contemporary lighting, BLE-S-BUB, midcentury modern, mid century modern, mid-century modern, new downtown and bubble. bubble light, buble, bubel, bubbel, bubble collection, bubble series, the bubble collection, the bubble series, SPS-0103, SPS 0103, SPS0103, bubble lights, bubble light, bubble lighting, bubble light fixture, bubble light fixtures, bubble lighting fixture, bubble light fixtures,