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 (61531, 61557, 61558, 61565) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00058

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": 4,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (61531,61557,61558,61565) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	meta_keywords	meta_description	search_words
61531	<p>Keep those hot dishes hot with our Chateau Food Warmer Pendant! With a sleek, minimal sloping cylindrical shade, this decorative restaurant pendant can be paired with a heating lamp bulb for food warming applications. American made and customizable with a variety of finish colors to complement your commercial brand!</p> <p>\|break\|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>!</li> </ul>	bell kitchen light, commercial pendant lighting, 250W pendant light, heat warmer pendant light, food warmer ceiling light, restaurant lighting, decorative restaurant lighting, streamline diner pendant light	The Chateau heating light has a minimal sloping cylindrical shade. This commercial pendant can be paired with a heating lamp bulb for food warming applications.	Food Warming Commercial Curry 6" 250W Heat Warmer Pendant, 10FW400, food warmer lights, commercial lighting, restaurant lighting, commercial pendant, Bistro Food Warmer Pendant, BLE-C-FW-BISTRO, foodwarmer, food warming, food lamp, food light, restaurant heat lamps, food heat lamp, heat lamp, food lighting, food warmer, food warmer pendant, food warmer pendants, food warming pendant, food warming pendants, restaurant food warmer, restaurant food warming pendant, heat lamp, restaurant heat lamp, Chateau Collection, Chateau Series, The Chateau Collection, The Chateau Series, SPS-0261, SPS 0261, SPS0261, CHEATEAU, heatlamp, warming lights, warming light, warming lighting, warming pendant, warming pendants, warming ceiling pendant, warming ceiling pendants, warming lamp, buffet lamps, food warmers,
61557	<p>Our Wilcox Food Warmer Pendant features an American made, deep bowl shade design that is ideal for modern and sophisticated commercial applications. Paired with a heat lamp bulb, this stylish restaurant light is fully customizable to complement any commercial brand and color scheme!</p> <p>\|break\|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>!</li> </ul> <p> </p>	food warmer and heat lamps, deep bowl commercial light, deep bowl heating lamp, restaurant and diner lighting, wide distribution heat light, commercial food warmer, restaurant barn light, down light food warmer	The Wilcox restaurant light features an American Made deep bowl shade--ideal for commercial applications. Pair with a heating lamp bulb to make a food warmer.	food warmer lights, commercial lighting, restaurant lighting, commercial pendant, BLE-C-FW-CANTINA, Cantina Food Warmer Pendant, foodwarmer, food warming, restaurant food warmer, restaurant food warming pendant, heat lamp, restaurant heat lamp, food light, food pendant, food lighting, food lamp, restaurant heat lamps, food heat lamp, SPS-0263, SPS 0263, SPS0263, Wilcox Series, Wilcox Collection, The Wilcox Series, The Wilcox Collection, Wilcox deep bowl series, wilcox deep bowl collection, the wilcox deep bowl series, the wilcox deep bowl collection, deep bowl series, deep bowl collection, heatlamp, warming lights, warming light, warming lighting, warming pendant, warming pendants, warming ceiling pendant, warming ceiling pendants, wilcox bowl, warming lamp, buffet lamps, food warmers,
61558	<p>The Canal Food Warmer Pendant features a long cylindrical cone and flared RLM shade to provide a generous span of both light and heat. Paired with a heat lamp bulb, this modern restaurant pendant is perfect for meal preparation in commercial settings such as restaurants, pubs, breweries and dining halls!</p> <p>\|break\|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>!</li> </ul> <p> </p>	flared light heat lamp, commercial food warmer lighting, diner lights, diner pendant fixtures, heating fixture, decorative commercial lighting, american made restaurant lighting, modern restaurant pendant lights, food warmer & heat lamps	The Canal heating lamps features a long cylindrical cone and flared reflector. Paired with a heat lamp bulb, this pendant is perfect for meal preparation!	Hibachi Food Warmer Pendant, food warmer lights, commercial lighting, restaurant lighting, commercial pendant, BLE-C-FW-HIBACHI, foodwarmer, food warming, food warmer, food warmer pendant, food warming pendants, food warmer pendants, food lamp, food light, restaurant heat lamps, food heat lamp, heat lamp, heat lamp pendant, heat lamp pendants, food light, food lighting, restaurant food warmer, restaurant food warming pendant, heat lamp, restaurant heat lamp, SPS0085, SPS 0085, SPS-0085, Canal Collection, The Canal Collection, Canal Series, The Canal Series, heatlamp, warming lights, warming light, warming lighting, warming pendant, warming pendants, warming ceiling pendant, warming ceiling pendants, warming lamp, buffet lamps, food warmers,
61565	<p>Add all-American flair to your commercial restaurant lighting with the Tuscany Food Warmer Pendant. Hand crafted from commercial grade materials by local artisans, this pendant features a sloping cylindrical shade and comes in an array of stunning powder coat finish colors. Consider this modern pendant for all your commercial restaurant needs!</p> <p>\|break\|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>!</li> </ul>	food warmer lamp, restaurant ceiling lighting, commercial heating lamp, diner pendant light, decorative heat warmer lighting, down light heat lamp, modern restaurant pendant light	Add all-American flair to your commercial restaurant lighting. Hand crafted by local artisans this pendant features a sloping cylindrical shade.	Café Food Warmer Pendant, BLE-C-FW-CAF, food warmer light, restaurant lighting, commercial heating lamp, foodwarmer, food warming, heat lamp, heat light, food warmer pendant, food warming pendant, food warmer pendants, food warming pendants, food pendant, food pendants, food light, food lighting, food lamp, food light, restaurant heat lamps, food heat lamp, food heat lamps, heat lamp, heat lamps, restaurant food warmer, restaurant food warming pendant, heat lamp, restaurant heat lamp, tuscany, tuscany food warmer pendant, tuscany pendant, The Tuscany Collection, The Tuscany Series, Tuscany Collection Tuscany Series, SPS-0262, SPS 0262, SPS0262, heatlamp, warming lights, warming light, warming lighting, warming pendant, warming pendants, warming ceiling pendant, warming ceiling pendants, warming lamp, buffet lamps, tuscany cord hung, food warmers,