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 (3834, 3835, 3832, 3833) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00020

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": "3",
      "used_key_parts": ["product_id"],
      "rows": 4,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (3834,3835,3832,3833)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	search_words
3832	<p>The MOTOTRBO SL300 provides reliable push-to-talk communication for the mobile, everyday user in an ultra-slim and rugged profile. Whether you're coordinating a school event or working in the field, the SL300 is boldly designed to keep you efficiently connected. </p><p>The latest technology works to make operation of the SL300 simple and straightforward. Ergonomic design allows one-handed radio operation, and a versatile accessory portfolio gives you the freedom to focus on the job at hand. </p><p>The SL300 is compatible with the MOTOTRBO features you'll find are business-essential; for example a transmission can be interrupted to prioritize critical communications. Additionally, the SL300 utilizes digital and analog radio technology concurrently to fit seamlessly into your existing communication system. </p><h3>Key Features</h3><ul> <li>Ultra-Slim Profile</li> <li>Advanced Technology</li> <li>Simple Operation</li> <li>Dual Capacity Direct Mode</li> <li>Rugged and Reliable</li> <li>Range Max Receiver</li> <li>Analog/Digital</li> <li>Voice Announcement</li> <li>MicroUSB Connectivity</li> </ul><h2><br></h2>	sl300 radio, sl-300 radio, sl 300 radio
3833	<p>The MOTOTRBO SL300 provides reliable push-to-talk communication for the mobile, everyday user in an ultra-slim and rugged profile. Whether you're coordinating a school event or working in the field, the SL300 is boldly designed to keep you efficiently connected. </p><p>The latest technology works to make operation of the SL300 simple and straightforward. Ergonomic design allows one-handed radio operation, and a versatile accessory portfolio gives you the freedom to focus on the job at hand. </p><p>The SL300 is compatible with the MOTOTRBO features you'll find are business-essential; for example a transmission can be interrupted to prioritize critical communications. Additionally, the SL300 utilizes digital and analog radio technology concurrently to fit seamlessly into your existing communication system. </p><h3>Key Features</h3><ul> <li>Ultra-Slim Profile</li> <li>Advanced Technology</li> <li>Simple Operation</li> <li>Dual Capacity Direct Mode</li> <li>Rugged and Reliable</li> <li>Range Max Receiver</li> <li>Analog/Digital</li> <li>Voice Announcement</li> <li>MicroUSB Connectivity</li> </ul><h2><br></h2>	sl300 radio, sl-300 radio, sl 300 radio
3834	<p>The MOTOTRBO SL300 provides reliable push-to-talk communication for the mobile, everyday user in an ultra-slim and rugged profile. Whether you're coordinating a school event or working in the field, the SL300 is boldly designed to keep you efficiently connected. </p><p>The latest technology works to make operation of the SL300 simple and straightforward. Ergonomic design allows one-handed radio operation, and a versatile accessory portfolio gives you the freedom to focus on the job at hand. </p><p>The SL300 is compatible with the MOTOTRBO features you'll find are business-essential; for example a transmission can be interrupted to prioritize critical communications. Additionally, the SL300 utilizes digital and analog radio technology concurrently to fit seamlessly into your existing communication system. </p><h3>Key Features</h3><ul> <li>Ultra-Slim Profile</li> <li>Advanced Technology</li> <li>Simple Operation</li> <li>Dual Capacity Direct Mode</li> <li>Rugged and Reliable</li> <li>Range Max Receiver</li> <li>Analog/Digital</li> <li>Voice Announcement</li> <li>MicroUSB Connectivity</li> </ul>	sl300 radio, sl-300 radio, sl 300 radio
3835	<p>The MOTOTRBO SL300 provides reliable push-to-talk communication for the mobile, everyday user in an ultra-slim and rugged profile. Whether you're coordinating a school event or working in the field, the SL300 is boldly designed to keep you efficiently connected. </p><p>The latest technology works to make operation of the SL300 simple and straightforward. Ergonomic design allows one-handed radio operation, and a versatile accessory portfolio gives you the freedom to focus on the job at hand. </p><p>The SL300 is compatible with the MOTOTRBO features you'll find are business-essential; for example a transmission can be interrupted to prioritize critical communications. Additionally, the SL300 utilizes digital and analog radio technology concurrently to fit seamlessly into your existing communication system. </p><h3>Key Features</h3><ul> <li>Ultra-Slim Profile</li> <li>Advanced Technology</li> <li>Simple Operation</li> <li>Dual Capacity Direct Mode</li> <li>Rugged and Reliable</li> <li>Range Max Receiver</li> <li>Analog/Digital</li> <li>Voice Announcement</li> <li>MicroUSB Connectivity</li> </ul>	sl300 radio, sl-300 radio, sl 300 radio