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 (64824, 64849, 64850) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00065

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 (64824,64849,64850) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	meta_keywords	meta_description	search_words
64824	<p>Acetylene tank lids never looked better! With an eye-catching rugged design, our Mig Pendant uses the tops of acetylene tanks for a creative new purpose. Now a striking ceiling pendant, the Mig provides homes and businesses with an authentic industrial edge, establishing unique residential or commercial décors. Fully customizable in an array of finishes!</p> <p>\|break\|</p> <ul> <li>Manufactured in the USA</li> <li><span>Pendant features a steel acetylene tank lid</span></li> <li>Available in marine grade, powder coat and unique spray finishes</li> <li>Read more about our Mig Pendant Light over on our<span> <a href="https://www.barnlight.com/inspiration/upcycled-industrial-pendants-highlight-brewpub-bar/" target="_blank">blog</a></span>!</li> </ul>	The Mig - Retro Steel Pendant Light, industrial pendant, cord hung pendant light, rustic pendant lighting, recycled lighting, recycled pendant lighting	This industrial pendant light features a recycled acetylene tank tops with vibrant powdercoat finishes.	The Mig - Retro Steel Pendant Light, BLE-MIG-008, mig light, mig fixture, cord hung pendant, mig pendant, the mig, mig, mig industrial, mig industrial pendant, mig industrial pendant light, mig light, mig lights, mig lighting mig industrial pendant lights, mig industrial pendant lighting, mig pendant, mig pendants, new listing, new mig, powder coat mig, industrial pendant, SPS-0008, SPS 0008, SPS0008, Mig Collection, The Mig Collection, Mig Series, The Mig 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, the mig retro, ivanhoe mig, gas cap,
64849	<p>Utilizing the tops of acetylene tanks as pendants, the Mig provides homes and businesses with an authentic industrial character. Clustered together, these pendants function as a creative, eye-catching focal point. This ceiling light’s rugged charm appeals to both contemporary and traditional décors, which lets any setting embrace a heightened aesthetic.</p> <p>An abundance of finish options —porcelain, powder coat, and a retro spray finish — gives this fixture a unique appearance, one that perfectly matches any space's sense of style.</p> <p>\|break\|</p> <ul> <li>Manufactured in the USA</li> <li><span>Multi-light pendant features a retired steel aceylene tank lid</span></li> <li>Migs are available in porcelain, powder coat and unique spray finishes</li> </ul>		Fully customizable, this multi-light pendant features an authentic industrial character. Give any space a rugged, eye-catching style!	new listing, new mig, BLE-C-MLP3-MIG, Mig Multi-Light Pendant, Mig Multi-Light Pendants, The Mig Multi-Light Pendant, The Mig Multi-Light Pendants, Mig, The mig, Mig Chandelier, Mig Pendant, Mig Pendants, Multi-light pendant, multi-light pendants, multi-light chandelier, multi-light chandeliers, Mig 3-light Pendant, Mig 3-light chandelier, Mig multilight pendant, mig multilight chandelier, multilight pendant, multilight chandelier, cluster pendant, cluster chandelier, multi-light cluster pendant, multilight cluster pendant, multi-light cluster chandelier, multilight cluster chandelier, Mig Multi Light Pendant, Mig Multi Light Pendants, The Mig Multi Light Pendant, The Mig Multi Light Pendants, Multi Light Pendant, Multi Light Chandelier, Multi Light Cluster Pendant, Multi Light Cluster Chandelier, mig multi light chandelier, mig multilight chandelier, Mig cluster chandelier, SPS-0473, SPS 0473, SPS0473, Mig Collection, The Mig Collection, Mig Series, The Mig Series, Triple Pendant lights, Triple Pendant lighting, Triple Pendant light, the mig retro, gas cap,
64850	<p>An imaginative yet rugged aesthetic, the Mig is made from acetylene tank tops. Two pendants are used in this design allowing this ceiling light to perform numerous roles within a space. With authentic and unique industrial character, the Mig can function as either a focal point or accent piece, elevating any décor.<br /> <br />Available with a wide array of finish options, this fixture can match any space’s preferred look. Choose bright colors for a playful appearance or subtler finishes for a more classic approach.</p> <p>\|break\|</p> <ul> <li>Manufactured in the USA</li> <li><span>This pendant features two retired steel aceylene tank lids</span></li> <li>Customizable in an array of porcelain, powder coat and retro spray finishes</li> </ul>		Industrial, stylish, and unique, this linear pendant features an authentic character and elevates any décor! Customize its look for your space!	new listing, new mig, BLE-C-CV24-MIG, Mig 2-Light Linear Pendant, Mig 2-Light Linear Chandelier, The Mig 2-Light Linear Pendant, The Mig 2-Light Linear Chandelier, Mig, The Mig, Mig 2 Light Linear Pendant, Mig 2 Light Linear Chandelier, 2-Light Linear Pendant, 2-Light Linear Chandelier, Linear Pendant, Linear Chandelier, 2-light, 2 light, two light, 2-light pendant, 2 light pendant, 2-light pendant, two light pendant, 2-light chandelier, two light chandelier, multi light pendant, multi light chandelier, multilight pendant, multilight chandelier, multi-light pendant, multi-light chandelier, mig multi light chandelier, mig multilight chandelier, migs, SPS-0473, SPS 0473, SPS0473, Mig Collection, The Mig Collection, Mig Series, The Mig Series, pendants, double, the mig retro, gas cap,