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 (
    65855, 65854, 65866, 65857, 65876, 65858, 
    65856, 65860, 65859, 65861
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00039

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": 10,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65855,65854,65866,65857,65876,65858,65856,65860,65859,65861) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	search_words
65854	<p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>\|break\|</p> <ul> <li>Dimensions: <span>MOL 11 ¼" x Dia. 6 ¼" </span></li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul>	new bulb, led bulb, green creative, 37096,
65855	<p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>\|break\|</p> <ul> <li>Dimensions: <span>MOL 11 ¼" x Dia. 6 ¼"</span></li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul>	new bulb, led bulb, green creative, 37097,
65856	<p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>\|break\|</p> <ul> <li>Dimensions: MOL 11 ¼" x Dia. 6 ¼" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul>	new bulb, led bulb, green creative, 37098,
65857	<p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>\|break\|</p> <ul> <li>Dimensions: MOL 11" x Dia.7 ⅞" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul>	new bulb, led bulb, green creative, 37099,
65858	<p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>\|break\|</p> <ul> <li>Dimensions: MOL 11" x Dia.7 ⅞" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul>	new bulb, led bulb, green creative, 37100,
65859	<p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>\|break\|</p> <ul> <li>Dimensions: MOL 11" x Dia.7 ⅞" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul>	new bulb, led bulb, green creative, 37101,
65860	<p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> 25</span></span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>\|break\|</p> <ul> <li>Dimensions: MOL 10 ¼" x Dia. 6 ¾" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul>	new bulb, led bulb, green creative, 37102,
65861	<p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>\|break\|</p> <ul> <li>Dimensions: MOL 6 ⅞" x Dia. 5" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul>	new bulb, led bulb, green creative, 37103,
65866	<p class="p1"><span class="s1">Illuminate your space with our versatile and energy-efficient LED bulb, designed to seamlessly replace traditional incandescent bulbs of 25W. This bulb enhances vibrant reds and delivers natural skin tones, making it perfect for any setting, from cozy bedrooms to professional workplaces. This bulb is suitable for use in totally enclosed fixtures and wet locations, making it appropriate for both indoor and outdoor applications. </span></p> <p>\|break\|</p> <ul> <li>Dimensions: MOL 5 ¼" x Dia. 2 ½" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Most Forward/Reverse Phase Controls </li> <li>320° Omnidirectional Beam Angle </li> </ul>	new bulb, led bulb, green creative, 36752,
65876	<p class="p1"><span class="s1">Illuminate your space with our versatile and energy-efficient LED bulb, designed to seamlessly replace traditional incandescent bulbs of 40W. This bulb enhances vibrant reds and delivers natural skin tones, making it perfect for any setting, from cozy bedrooms to professional workplaces. This bulb is suitable for use in totally enclosed fixtures and wet locations, making it appropriate for both indoor and outdoor applications. </span></p> <p>\|break\|</p> <ul> <li>Dimensions: MOL 3 ⅞" x Dia. 1 ½" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Most Forward/Reverse Phase Controls </li> <li>320° Omnidirectional Beam Angle </li> </ul>	new bulb, led bulb, green creative, 37063, candelabra,