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

Query time 0.00060

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

Result

product_id	short_description	full_description	meta_keywords	meta_description	search_words	promo_text
61198		<p>With a mini warehouse shade affixed to your choice of gooseneck arm, the Barn Light Mini Artesia Wall Sconce becomes the perfect wall lighting for any home or business. As commercial lighting, this mini wall light functions as restaurant lighting in dining areas or rest rooms. Or equip your home with wall sconce lighting. It is damp rated, so this wall lighting can be installed on covered porches as well. <span style="text-decoration: underline;"><strong><br /></strong></span></p> <p>Inspired by vintage lighting, the Barn Light Mini Artesia Wall Sconce is hand built in America. Choose a powdercoat finish to match your decor. Or try adding an Edison Bulb, giving this lighting fixture the feel of vintage wall sconces.</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> <li>Read more about the Barn Light Mini Artesia Wall Sconce over on our <a href="https://www.barnlight.com/inspiration/mini-barn-wall-sconces-bring-vintage-feel-to-new-farmhouse/" target="_blank">blog</a>!</li> </ul>	mini barn light, kitchen island pendant light, mini wall sconce light, straight arm wall light, stylish wall sconce, petite wall light, little barn light, hallway sconce, mini hall sconce	This mini light makes a charming pendant for your kitchen lighting or island lighting. The mini barn shade is styled after an Artesia with custom finishes!	Barn Light Mini Artesia Wall Sconce, mini artesia wall sconce, mini wall light, mini wall sconce, BLE-W-WHMA, mini gooseneck, mini shade, mini, small barn light, small gooseneck, Straight arm light, bantam, bantam artesia, artesia, SPS-0058, SPS 0058, SPS0058, Artesia Collection, Artesia Series, The Artesia Collection, The Artesia Series, The Mini Artesia Collection, The Mini Artesia Series, Wall mount straight Arm, artesia mini sconce, artesia mini sconces, artesia mini wall sconce, artesia mini wall sconces, 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, 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, mini artesian, small sconces, artesia sconce, H-15006, mini curved warehouse shade,
61520		<p>Rooted in the industrial lighting styles of the early 20th century, the Barn Light Mini Artesia features an undersized shade. Despite its diminutive size, this fixture gives the charms of vintage lighting to any space. Made from commercial grade materials, the Artesia withstands installation in any setting. A single pendant light can be added to smaller kitchens or several pendants can be grouped together to create an interesting focal point.</p> <p>The Artesia also meets commercial lighting needs. The RLM shade can provide the necessary illumination in retail stores, restaurants and office spaces. Choose from an array of cord options and the powdercoat finish of your choice to coordinate the Artesia with the rest of your decor. Give any space the stylish look of this warehouse lighting today!</p> <p>\|break\|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Made-to-order, learn more about the process <a href="https://www.barnlight.com/video-gallery/">here</a>.</li> </ul>	mini pendant, mini task light, petite barn light ceiling light, mini kitchen island light, small RLM light, tiny barn light, classic mini pendant, mini artesia barn pendant, mini reflector shade pendant	Our popular Artesia light, now in mini-shade form! You will love this petite warehouse shade as a lighting accent in your kitchen, entryway, or office.	Barn Light Mini Artesia Pendant, mini pendants, mini artesia, BLE-C-WHMA, island lighting, SPS-0058, SPS 0058, SPS0058, Artesia Collection, Artesia Series, The Artesia Collection, The Artesia Series, The Mini Artesia Collection, The Mini Artesia 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, mini artesian, H-15006, mini curved warehouse shade, mini curved warehouse shade cord-hung ceiling light,