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

Query time 0.00055

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

Result

product_id	short_description	full_description	meta_keywords	meta_description	search_words	promo_text
61516		<p>Ideal for mini task lighting, the Barn Light Mini Eclipse Pendant features a petite shallow dome affixed to a durable cord. This warehouse lighting features a smaller shade, only a seven inch diameter. This makes the perfect to hang in groups over a kitchen island or alone in any nook that needs a spot of light. Or bring this pendant lighting to commercial venues. The Mini Eclipse elevates the style of retail stores, breweries and office spaces!</p> <p>Made from first quality materials, this miniature barn light is a great way to highlight stylish bulbs, like our vintage <a title="Nostalgic Edison Style Lighting" href="https://www.barnlight.com/accessories/light-bulbs/">Edison Bulbs</a>! As a smaller lighting option, the warehouse shade is just as durable as the larger options. Handspun from steel, American made lighting will last for generations.</p> <p>\|break\|</p> <ul> <li><span>Manufactured in the U.S.A.</span></li> <li>Made-to-order, learn more about the process <a href="https://www.barnlight.com/video-gallery/">here</a>.</li> </ul>	shallow dome mini pendant, miniature barn light shade, mini pendant for kitchen island, mini task lighting, small pendant ceiling lights, mini ceiling lighting, petite ceiling light, small shallow dome pendant	Ideal for custom utilitarian lighting, the Mini Eclipse Pendant has a petite shallow dome affixed to a durable cord. A great way to highlight stylish bulbs!	Mini Eclipse Pendant, mini barn light, mini eclipse, BLE-C-WHEM, small pendant, petite pendant lighting, small pendant light, miniature barn light, warehouse shade, small warehouse shade, ware house lighting, warehouse lighting, mini warehouse shade, mini warehouse light, mini pendant, mini pendant light, mini light, mini pendant lighting, ceiling pendant, ceiling lighting, mini ceiling pendant, mini ceiling lighting, eclipse light, eclipse lighting, eclipse pendant, eclipse ceiling pendant, SPS-0274, SPS 0274, SPS0274, eclipse collection, eclipse series, the eclipse collection, the eclipse 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,
61519		<p>Affixed to a wall plate via a gooseneck arm, the angle of your choosing, the Barn Light Mini Eclipse Wall Sconce brings the feel of vintage lighting to any home or commercial space. An industrial wall light, the mini warehouse shade is space saving, allowing installation almost anywhere. The ideal wall light for demanding settings like warehouses and workshops, the Eclipse Wall Sconce is a rugged lighting fixture. </p> <p>Wall lights also befit the interior of your home. Warehouse lighting complements contemporary design schemes, making it an ideal lighting fixture for anybody wanting a hip decor. Additionally, the compact structure of these industrial wall lights fit into tighter spaces, able to line hallways or provide unobtrusive lighting in bathrooms.</p> <p>Customize the Eclipse Wall Sconce's warehouse shade with one of our durable and colorful powder coat finish colors. Or give your wall lighting a classic feel with Edison Light Bulbs!</p> <p>\|break\|</p> <ul> <li>Manufactured in the U.S.A.</li> <li><span>Made-to-order, learn more about the process</span><span> </span><a href="https://www.barnlight.com/video-gallery/">here</a><span>.</span></li> <li>Check out our blog to read more about the Barn Light Mini Eclipse Wall Sconce in <a href="https://www.barnlight.com/inspiration/mini-wall-sconces-enhance-coastal-design-in-bathroom-makeover/" target="_blank">this</a> nautical-inspired bathroom or on <a href="https://www.barnlight.com/inspiration/compact-curvy-wall-sconces-add-just-the-right-touch-to-texas-cottages/" target="_blank">these</a> Texas cottages!</li> </ul>	small wall sconce, compact barn light sconce, compact sconce, mini shallow dome wall light, mini shallow dome sconce, mini gooseneck sconce light, petite wall sconce, small outdoor wall light, decorative accent lighting	This stylish industrial wall light combines a petite straight arm mount with a small barn style shade. Customize the warehouse shade with a colorful finish!	Barn Light Mini Eclipse Wall Sconce, mini astro sconce, mini astro wall light, mini barn light, small barn sconce, BLE-W-WHEM, eclipse sconce, mini gooseneck, mini shade, mini, warehouse shade, industrial sconce, wall lighting, exterior lighting, commercial lighting, wall light, Mini Eclipse Wall Sconce, sconce lighting, wall sconce, warehouse shade, warehouse lighting, wall lighting, warehouse wall lighting, outdoor lighting, outdoor lights, outdoor sconces, commercial lighting, commercial lights, commercial outdoor lighting, outdoor commercial lighting, Mini Eclipse outdoor light, Mini eclipse wall light, mini eclipse sconce, mini eclipse exterior light, mini eclipse sconce light, eclipse, eclipse sconce, mini sconce, mini eclipse, SPS-0275, SPS 0275, SPS0275, eclipse collection, eclipse series, the eclipse collection, the eclipse series, Wall mount sconce, wall mount sconces, sconce wall mount, sconce wall mounted, wall mount light, wall mount lights, wall mount lighting, wall mounted light, wall mounted lights, wall mounted lighting, wall mount sconce light, wall mount sconce lights, wall mount sconce lighting, wall mounted sconce light, wall mounted sconce lights, wall mounted sconce lighting, Interior barn light wall sconce, Interior barn light wall sconces, Interior sconce, interior sconces, interior wall sconce, interior wall sconces, Interior sconce light, Interior sconce lights, Interior sconce lighting, Interior wall light, Interior wall lights, Interior wall lighting, Interior light wall sconce, Interior light wall sconces, Interior light, Interior lights, Interior lighting, wall mount indoor light, wall mount indoor lights, wall mount indoor lighting, wall mount interior light, wall mount interior lights, wall mount interior lighting, wall mounted indoor light, wall mounted indoor lights, wall mounted indoor lighting, wall mounted interior light, wall mounted interior lights, wall mounted interior lighting, interior wall mount light, interior wall mount lights, interior wall mount lighting, interior wall mounted light, interior wall mounted lights, interior wall mounted lighting, wall mount interior sconce, wall mount interior sconces, wall mount interior wall sconce, wall mount interior wall sconces, wall mounted interior sconce, wall mounted interior sconces, wall mounted interior wall sconce, wall mounted interior wall sconces, wall mount indoor sconce, wall mount indoor sconces, wall mount indoor wall sconce, wall mount indoor wall sconces, wall mounted indoor sconce, wall mounted indoor sconces, wall mounted indoor wall sconce, wall mounted indoor wall sconces, Indoor barn light wall sconce, Indoor barn light wall sconces, Indoor sconce, Indoor sconces, Indoor wall sconce, Indoor wall sconces, Indoor sconce light, Indoor sconce lights, Indoor sconce lighting, Indoor wall light, Indoor wall lights, Indoor wall lighting, Indoor light wall sconce, Indoor light wall sconces, Indoor light, Indoor lights, Indoor lighting, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount sconce light, Wall mount sconce lights, Wall mount sconce lighting, Wall mount sconce, Wall mount sconces, Wall mounted sconce light, Wall mounted sconce lights, Wall mounted sconce lighting, Wall mounted sconce, Wall mounted sconces, small sconces,