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 (65479, 65585, 65597, 65683) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00041

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 (65479,65585,65597,65683) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	meta_keywords	meta_description	search_words
65479	<p>Whether found in a commercial building or residential property, the Cleveland helps every space feel stylish and illuminated—with minimal wasted energy. Turning to vintage industrial fixtures for inspiration, this flush mount pendant presents a truly timeless aesthetic. Equally suiting contemporary and traditional décors, the Cleveland helps any room take on a unique, elevated aesthetic. <br /> <br />Functionally, the Cleveland’s integrated LED components produce illumination far more efficiently than standard options. This technology wastes little electricity as heat as it emits light, considerably scaling down a building’s energy consumption. Eco-friendly, budget-conscious, and undeniably stylish: Transform any space with the Cleveland!</p> <p>\|break\|</p> <ul> <li>Hand built with an American made RLM warehouse shade, this quality industrial pendant is a lasting stem mount option.<span> </span></li> <li>Made-to-order. Learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> </ul>		A flush mount LED light with a vintage industrial style! The Cleveland integrates hyper-efficient LED technology into its design! Eco-conscious, budget-friendly, and endlessly customizable!	BLE-F-AI-LED, Cleveland LED, LED cleveland, Cleveland LED Flush Mount Light, Cleveland LED Flush Mount, Cleveland LED Flush Mount Lighting, Cleveland LED Flush Mount Lights, Cleveland LED Flush Mount pendant, Cleveland LED Flush Mount pendant Light, Cleveland LED Flush Light, Cleveland LED Flush pendant Light, Cleveland LED Flush pendant, Cleveland, BLE-F-AI, Cleveland Flush Mount Light, Cleveland Flush Mount, Cleveland Flush Mount Pendant, Cleveland Pendant, Cleveland Pendant Light, Cleveland ceiling light, Cleveland flush mount ceiling pendant, Cleveland flush, Flush Cleveland, The Cleveland Flush Mount Light, The Cleveland Flush Mount, The Cleveland Flush Mount Pendant, The Cleveland Pendant, The Cleveland Pendant Light, The Cleveland ceiling light, The Cleveland flush mount ceiling pendant, The Cleveland flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant, Cleveland Vintage Industrial Flush Mount Light, Cleveland Vintage Industrial Flush Mount, Cleveland Industrial Flush Mount Light, Cleveland Industrial Flush Mount, Cleveland Vintage Flush Mount Light, Cleveland Vintage Flush Mount, Vintage Industrial Flush Mount Light, Vintage Industrial Flush Mount, Industrial flush mount, industrial flush mount light, metropolitan,
65585	<p><span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW121534209 BCX0"><span class="NormalTextRun SCXW121534209 BCX0">String lights offer a simple way to completely transform outdoor spaces.<span> </span></span><span class="NormalTextRun SCXW121534209 BCX0">Measuring in</span><span class="NormalTextRun SCXW121534209 BCX0"><span> </span>at<span> </span></span><span class="NormalTextRun SCXW121534209 BCX0">forty-eight</span><span class="NormalTextRun SCXW121534209 BCX0"><span> </span>feet, this lighting option provides the right coverage for man</span><span class="NormalTextRun SCXW121534209 BCX0">y<span> </span></span><span class="NormalTextRun SCXW121534209 BCX0">exterior </span><span class="NormalTextRun SCXW121534209 BCX0">settings.<span> </span></span><span class="NormalTextRun SCXW121534209 BCX0">Turn your porch or patio into an outdoor oasis with the<span> </span></span><span class="NormalTextRun SCXW121534209 BCX0">ambiance</span><span class="NormalTextRun SCXW121534209 BCX0"><span> </span>provided exclusively by string lights!</span></span><span class="EOP SCXW121534209 BCX0" data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></p> <p>\|break\|</p> <ul> <li>15 Sockets - Standard E26 Medium Base</li> <li>Includes (15) S14 Clear 11W Bulbs </li> <li>48 ft. Cord with 3 ft. of Spacing Between Each Socket</li> <li>Up to 3 Strings Can Be Connected</li> <li>ETL Rated for Wet Location Use</li> </ul>	outdoor cafe lights, outdoor string lights, heavy duty string lighting, exterior strand lights, black cord lists, festoon lights,	Add ambiance to your patio, barn or market with our new commercial Cafe Lights! UL listed for wet locations, these cafe string lights dress up any outdoor space.	Outdoor Café String Lights, string lights, cord lights, heavy duty cord lights, Outdoor String Lights, Outdoor String Light, Outdoor String Lighting, outdoor string, festoon, festoon lighting, festoon lights, outside hanging lights, 18810002, string lights, string light, string lighting, outdoor string light, outdoor string lights, outdoor string lighting, Out door string light, out door string lights, out door string lighting, Exterior string light, exterior string lights, exterior string lighting, Outdoor rated string lights, outdoor rated string lighting, outdoor rated string light, Out door rated string lights, out door rated string lighting, out door rated string light, Exterior rated string light, exterior rated string lights, exterior rated string lighting, sing light, sting light, 18810005, bulbs with strings,
65597	<p>Bringing industrial elements into your décor has never been easier with the Copeland Stem Mount Pendant! Starting with a sturdy stem mounting, this fixture features a polished nickel vented cap atop a prismatic clear glass shade. A <span>metal-rimmed, Fresnel lens glass diffuser focuses the illumination for better task lighting and is held in place with knurled thumbscrews adding another beautiful industrial detail. </span></p> <p>\|break\|</p> <ul> <li>This product is imported by Hudson Valley, a 3<sup>rd</sup> party vendor, and is not manufactured by Barn Light Electric</li> <li>Features a Fresnel Lens Prismatic Glass Diffuser</li> <li>Includes a 3", 6", 12" and (2) 18" stems </li> </ul>		This sturdy stem mount pendant oozes industrial style but the prismatic glass shade adds a touch of elegance!	7311, 7311-AGB, 7311-OB, 7311-SN, 7311-PN, 7308, 7308-AGB, 7308-OB, 7308-SN, 7308-PN, 7311, 7315-AGB, 7315-OB, 7315-SN, 7315-PN, haverhill, hudson valley, glass pendant light, diffuser pendant light, light with metal arms, glass and metal light, ribbed glass, ribbed, ribbed glass pendant, glass stem light, glass farmhouse light, ambient glass lighting, glass industrial light,
65683	<p>With inspiration from an era when candles were the only option for illumination, the Ledford Chain Hung Pendant brings the timeless look of a lantern to the modern age. With its sleek Textured Black frame enclosing an opal glass shade, this lantern lends a classic vibe to kitchens, covered porches, and dining rooms. The rugged chain mounting adds a dash of industrial styling to create an eye-catching fixture!</p> <p>\|break\|</p> <ul> <li>This product is imported by Troy Lighting, a 3<sup>rd</sup> party vendor, and is not manufactured by Barn Light Electric</li> <li>Textured Black Finish </li> <li>Opal White Glass </li> </ul>		Outdoor lighting with a classic profile & rugged construction. White glass provides diffused illumination for less glare.	B6351, B6353, B6357, F6357, mission beach, troy, lantern, outdoor lantern, glass lantern, rectangle lantern, modern lantern, simple outdoor lantern, cylinder glass lantern, modern outdoor lantern, ledford, ledford chain, chain hung lantern, front porch lantern, F6357, chain lantern, chain mount lantern,