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 (3775, 7883, 7884) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00028

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 3,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (3775,7883,7884) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	search_words
3775	<p>The Motorola MINITOR VI two-tone voice pager is ideal for fire departments and other organizations that need to react quickly in times of emergency. With up to 16 minutes of voice recording, customizable call alerts and improved receiver design, the MINITOR VI is flexible, rugged and reliable. It's built for the realities of first responders. </p><ul> <li>Up to 16 mins voice recording</li> <li>Message management: Next/Prev, FF/RWD, DEL, Lock/Unlock </li> <li>Customizable alert tones and memo announcements</li> <li>Programmable alerts and vibrate profiles</li> <li>Battery level voice announcements</li> <li>Alkaline battery support</li> </ul>	pager, voice pager, minitor, minitor 6, pagers, fire pager, fire pagers
7883	<p><strong>Replay. Respond.</strong><br> Compact, lightweight and durable, the MINITOR 7 is built for the realities of first responders. Whether in an urban incident or wildland fire, rely on the MINITOR’s 50 years of excellence; We understand the challenges you face - you need a device tough enough to withstand hazardous environments, to deliver life-saving information when you need it most. </p><h2>Two-Tone Pager</h2><p>Whether in an urban incident or wildland fire, a pager is the reliable solution; you will hear the message loud and clear, and you can replay it at will. </p><h2>Key features</h2><p><strong>Simple</strong><br> Error-proof design keeps you focused on the emergency </p><p><strong>Reliable</strong><br> Ingress protection IP66, IP67 for use in wet and dusty environments </p><p><strong>Safe</strong><rb></rb> Warning alert for when you need immediate help, and 5-channel scan ensures reduced risk of missed messages </p><h3>What's inside</h3><ul> <li>Up to 20 minutes of storage time</li> <li>Integrated button and speaker</li> <li>IP66 & 67 for protection against water and dust</li> <li>Warning alert for when you need immediate help</li> <li>5-channel scan</li> <li>Customizable voice announcements and alert tones</li> </ul>
7884	<p><strong>Replay. Respond.</strong><br> Compact, lightweight and durable, the MINITOR 7 is built for the realities of first responders. Whether in an urban incident or wildland fire, rely on the MINITOR’s 50 years of excellence; We understand the challenges you face - you need a device tough enough to withstand hazardous environments, to deliver life-saving information when you need it most. </p><h2>Two-Tone Pager</h2><p>Whether in an urban incident or wildland fire, a pager is the reliable solution; you will hear the message loud and clear, and you can replay it at will. </p><h2>Key features</h2><p><strong>Simple</strong><br> Error-proof design keeps you focused on the emergency </p><p><strong>Reliable</strong><br> Ingress protection IP66, IP67 for use in wet and dusty environments </p><p><strong>Safe</strong><rb></rb> Warning alert for when you need immediate help, and 5-channel scan ensures reduced risk of missed messages </p><h3>What's inside</h3><ul> <li>Up to 20 minutes of storage time</li> <li>Integrated button and speaker</li> <li>IP66 & 67 for protection against water and dust</li> <li>Warning alert for when you need immediate help</li> <li>5-channel scan</li> <li>Customizable voice announcements and alert tones</li> </ul>