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

Query time 0.00036

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

Result

product_id	short_description	full_description	meta_keywords	meta_description	search_words	promo_text
65650		<p>Adopting traditional lines and a simple profile, the Homestead Pendant Light brings a vintage-inspired look to modern spaces. The flared amber glass instills warmth while adding a sense of character. In commercial spaces, the Homestead gives offices and retail stores a unique sense of style.</p> <p>The amber glass provides unparalleled style. Instead of the industrial feel typically associated with barn lights, the glass lends sophistication. The Homestead Pendant is the perfect addition to renovation projects or new construction. Add timeless style to your space today!</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>	glass pendant light, pendant lighting, industrial era lighting	Jazz up your pool table, billiard light, or commercial venue with this pendant light. Fully custom with industrial-era turn-keys, flared glass shade, and unique cords.	BLE-C-HSP, glass pendant, billiard light, holophane pendant, cased glass pendant, flared glass shade, vintage glass, socket pendant, Barn Light Homestead Pendant, spoke top, spoketop, milk glass pendant, BLE-CC-HSP, CC-HSP, HSP, Barn Light Homestead Pendant, Barn Light Homestead Pendants, Barn Light Homestead Pendant Light, Barn Light Homestead Pendant Lights, Barn Light Homestead Pendant Lighting, Homestead Pendant Light, Homestead Pendant Lights, Homestead Pendant Lighting, homestead, home stead, homestead ceiling pendant, homestead ceiling pendants, home stead pendant, home stead pendants, home stead pendant light, home stead pendant lights, home stead pendant lighting, home stead ceiling pendant, home stead ceiling pendants, farmhouse, modern farmhouse, farm house, modern farm house, modern farmhouse light, modern farmhouse lights, modern farmhouse lighting, modern farm house light, modern farm house lights, modern farm house lighting, farmhouse light, farmhouse lights, farmhouse lighting, farm house light, farm house lights, farm house lighting, homestead, home stead, stead, homesead, homestead pendant, home stead pendant, homestead pendants, home stead pendants, homested, home sted, homesteed, home steed, glass pendant, Pendant island lights, homestead light, homestead lights, homestead lighting, home stead light, home stead lights, home stead lighting, homestead light fixture, homestead light fixtures, home stead light fixture, home stead light fixtures, homestead lighting fixture, homestead lighting fixtures, home stead lighting fixture, home stead lighting fixtures, 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, homestead glass pendant, milk glass pendant, homestead glass pendant light, spoke top pendant lights,
65653		<p>Adopting traditional lines and a simple profile, the Homestead Pendant Light brings a vintage-inspired look to modern spaces. The green, flared glass harkens back to early 20th century styles and offers a classic look. This pendant light gifts any space a new sense of character providing a unique charm to living rooms, dining rooms, and kitchens. As commercial lighting, the Homestead gives office spaces and retail stores a sense of vintage style.</p> <p>Adopting a more sophisticated feel instead of the industrial feel typically associated with barn lights, the Homestead Pendant is the perfect addition for renovation projects or new construction. Add timeless style to your space today!</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>	glass pendant light, pendant lighting, industrial era lighting	Jazz up your pool table, billiard light, or commercial venue with this pendant light. Fully custom with industrial-era turn-keys, flared glass shade, and unique cords.	BLE-C-HSP, glass pendant, billiard light, holophane pendant, cased glass pendant, flared glass shade, vintage glass, socket pendant, Barn Light Homestead Pendant, spoke top, spoketop, milk glass pendant, BLE-CC-HSP, CC-HSP, HSP, Barn Light Homestead Pendant, Barn Light Homestead Pendants, Barn Light Homestead Pendant Light, Barn Light Homestead Pendant Lights, Barn Light Homestead Pendant Lighting, Homestead Pendant Light, Homestead Pendant Lights, Homestead Pendant Lighting, homestead, home stead, homestead ceiling pendant, homestead ceiling pendants, home stead pendant, home stead pendants, home stead pendant light, home stead pendant lights, home stead pendant lighting, home stead ceiling pendant, home stead ceiling pendants, farmhouse, modern farmhouse, farm house, modern farm house, modern farmhouse light, modern farmhouse lights, modern farmhouse lighting, modern farm house light, modern farm house lights, modern farm house lighting, farmhouse light, farmhouse lights, farmhouse lighting, farm house light, farm house lights, farm house lighting, homestead, home stead, stead, homesead, homestead pendant, home stead pendant, homestead pendants, home stead pendants, homested, home sted, homesteed, home steed, glass pendant, Pendant island lights, homestead light, homestead lights, homestead lighting, home stead light, home stead lights, home stead lighting, homestead light fixture, homestead light fixtures, home stead light fixture, home stead light fixtures, homestead lighting fixture, homestead lighting fixtures, home stead lighting fixture, home stead lighting fixtures, 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, homestead glass pendant, milk glass pendant, homestead glass pendant light, spoke top pendant lights,