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 (
    4078, 5006, 4112, 4110, 4109, 4111, 4113, 
    4114, 4116, 5076, 4136, 4219, 4121, 
    4120, 4122, 4129, 4119, 4080, 4079, 
    5883, 4075, 4076, 4089, 4074
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00037

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": 24,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4078,5006,4112,4110,4109,4111,4113,4114,4116,5076,4136,4219,4121,4120,4122,4129,4119,4080,4079,5883,4075,4076,4089,4074)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	full_description	search_words
4074		<p>Replacement Foam Earbuds </p>	CP200d Headset, Headsets/Lapel Mics/Surveillance Kits
4075		<p>Beige extra loud earphone. NOTE - Extra loud earphone exceeds OSHA Limits. </p>	CP200 Headset, CP200d Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4076		<p>Black extra loud earphone. NOTE - Extra loud earphone exceeds OSHA Limits. </p>	CP200 Headset, CP200d Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4078		<p>Replacement foam plugs. Noise reduction = 24dB Pack of 50. For RLN6230A/RLN6231A. </p>	CP200 Headset, SL300 Headset, CP200XLS Headset, CP200d Headset, XPR6100 Headset, XPR6350 Headset, XPR6550 Headset, XPR6380 Headset, XPR6580 Headset, XPR7350 Headset, XPR7380 Headset, XPR7550 Headset, XPR7580 Headset, APX1000 Headset, APX3000 Headset, APX4000 Headset, APX6000 Headset, APX7000 Headset, APX600XE Headset, APX7000XE Headsets/Lapel Mics/Surveillance Kits
4079		<p>This foam ear cushion replaces the cushion on Motorola's flexible ear receiver for speaker microphones. </p>	CP200 Headset, CP200d Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4080		<p>This black, receive-only earpiece contains a flexible earloop and speaker that rests external to the ear. </p>	CP110 Headset, CP200 Headset, CP200d Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4089			BPR20 Headset, BPR40 Headset, CP200d Headsets/Lapel Mics/Surveillance Kits
4109		<p>The Clear Comfortable Earpiece forms to the inside of the ear and is perfect for low noise environments. It's made of easy-to-clean, chemically-inert hypo-allergenic material. </p>	CP200d Headset, XPR6100 Headset, XPR6350 Headset, XPR6550 Headset, XPR6380 Headset, XPR6580 Headset, XPR7350 Headset, XPR7550 Headset, XPR7380 Headset, XPR7580 Headset, APX1000 Headset, APX3000 Headset, APX4000 Headset, APX4000XE Headset, APX6000 Headset, APX6000XE Headset, APX7000 Headset, APX7000XE Headsets/Lapel Mics/Surveillance Kits
4110		<p>The Clear Comfortable Earpiece forms to the inside of the ear and is perfect for low noise environments. It's made of easy-to-clean, chemically-inert hypo-allergenic material. </p>	CP200d Headset, XPR6100 Headset, XPR6350 Headset, XPR6550 Headset, XPR6380 Headset, XPR6580 Headset, XPR7350 Headset, XPR7550 Headset, XPR7380 Headset, XPR7580 Headset, APX1000 Headset, APX3000 Headset, APX4000 Headset, APX4000XE Headset, APX6000 Headset, APX6000XE Headset, APX7000 Headset, APX7000XE Headsets/Lapel Mics/Surveillance Kits
4111		<p>The Clear Comfortable Earpiece forms to the inside of the ear and is perfect for low noise environments. It's made of easy-to-clean, chemically-inert hypo-allergenic material. </p>	CP200d Headset, XPR6100 Headset, XPR6350 Headset, XPR6550 Headset, XPR6380 Headset, XPR6580 Headset, XPR7350 Headset, XPR7550 Headset, XPR7380 Headset, XPR7580 Headset, APX1000 Headset, APX3000 Headset, APX4000 Headset, APX4000XE Headset, APX6000 Headset, APX6000XE Headset, APX7000 Headset, APX7000XE Headsets/Lapel Mics/Surveillance Kits
4112		<p>The Clear Comfortable Earpiece forms to the inside of the ear and is perfect for low noise environments. It's made of easy-to-clean, chemically-inert hypo-allergenic material. </p>	CP200d Headset, XPR6100 Headset, XPR6350 Headset, XPR6550 Headset, XPR6380 Headset, XPR6580 Headset, XPR7350 Headset, XPR7550 Headset, XPR7380 Headset, XPR7580 Headset, APX1000 Headset, APX3000 Headset, APX4000 Headset, APX4000XE Headset, APX6000 Headset, APX6000XE Headset, APX7000 Headset, APX7000XE Headsets/Lapel Mics/Surveillance Kits
4113		<p>The Clear Comfortable Earpiece forms to the inside of the ear and is perfect for low noise environments. It's made of easy-to-clean, chemically-inert hypo-allergenic material. </p>	CP200d Headset, XPR6100 Headset, XPR6350 Headset, XPR6550 Headset, XPR6380 Headset, XPR6580 Headset, XPR7350 Headset, XPR7550 Headset, XPR7380 Headset, XPR7580 Headset, APX1000 Headset, APX3000 Headset, APX4000 Headset, APX4000XE Headset, APX6000 Headset, APX6000XE Headset, APX7000 Headset, APX7000XE Headsets/Lapel Mics/Surveillance Kits
4114		<p>The Clear Comfortable Earpiece forms to the inside of the ear and is perfect for low noise environments. It's made of easy-to-clean, chemically-inert hypo-allergenic material. </p>	CP200d Headset, XPR6100 Headset, XPR6350 Headset, XPR6550 Headset, XPR6380 Headset, XPR6580 Headset, XPR7350 Headset, XPR7550 Headset, XPR7380 Headset, XPR7580 Headset, APX1000 Headset, APX3000 Headset, APX4000 Headset, APX4000XE Headset, APX6000 Headset, APX6000XE Headset, APX7000 Headset, APX7000XE Headsets/Lapel Mics/Surveillance Kits
4116		<p>An earphone jack located on the microphone allows the user to receive audio when using this earpiece. The translucent tube provides a more discreet option for those that need to receive messages privately </p><p>UL certified TIA 4950 approved when used with a UL certified TIA 4950 approved APX 4000 two knob radio </p>	BPR20 Headset, CP200XLS Headset, CP200d Headset, CP200 Headset, CP185 Headset, BPR40 Headset, XPR6100 Headset, XPR6350 Headset, XPR6550 Headset, XPR6380 Headset, XPR6580 Headset, XPR7350 Headset, XPR7550 Headset, XPR7380 Headset, XPR7580 Headset, XPR3500 Headset, XPR3300 Headsets/Lapel Mics/Surveillance Kits
4119		<p>Quick disconnect noise kits provide extra comfort and/or noise protection for users wearing surveillance accessories. Lightweight, translucent tube attaches to Motorola surveillance accessories to provide flexibility and comfort. The quick disconnect qdapter allows users, especially those in multiple shift operations, to easily remove or alternate acoustic tubes. Clothing clip prevents accessory from being pulled from the ear due to body movement or head rotation. This black extreme noise kit includes 2 foam earplugs for high-noise environments and can be used with clear comfortable earpieces, Noise reduction = 24dB. For optimal performance, extra loud earphones are recommended. </p>	CP185 Headset, CP200 Headset, CP200d Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4120		<p>Includes 2 foam earplugs. For high-noise environments. Noise reduction = 24dB. Can be used with Clear Comfortable Earpieces, Beige </p><p>Extreme Noise Kits provide extra comfort and/or noise protection for users wearing surveillance accessories. </p><p>Lightweight, translucent tube attaches to Motorola surveillance accessories to provide flexibility and comfort, which now includes a new quick disconnect adapter. The Quick Disconnect Adapter allows users, especially those in multiple shift operations, to easily remove or alternate acoustic tubes. Clothing clip prevents accessory from being pulled from the ear due to body movement or head rotation. For optimal performance, Extra Loud Earphones are recommended. </p>	CP185 Headset, CP200 Headset, CP200d Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4121		<p>Includes 1 clear rubber eartip. For low-noise environments, does not provide hearing protection, Black </p><p>Extreme Noise Kits provide extra comfort and/or noise protection for users wearing surveillance accessories. </p><p>Lightweight, translucent tube attaches to Motorola surveillance accessories to provide flexibility and comfort, which now includes a new quick disconnect adapter. The Quick Disconnect Adapter allows users, especially those in multiple shift operations, to easily remove or alternate acoustic tubes. Clothing clip prevents accessory from being pulled from the ear due to body movement or head rotation. For optimal performance, Extra Loud Earphones are recommended. </p>	CP185 Headset, CP200 Headset, CP200d Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4122		<p>Includes 1 clear rubber eartip. For low-noise environments, does not provide hearing protection, Beige </p><p>Extreme Noise Kits provide extra comfort and/or noise protection for users wearing surveillance accessories. </p><p>Lightweight, translucent tube attaches to Motorola surveillance accessories to provide flexibility and comfort, which now includes a new quick disconnect adapter. The Quick Disconnect Adapter allows users, especially those in multiple shift operations, to easily remove or alternate acoustic tubes. Clothing clip prevents accessory from being pulled from the ear due to body movement or head rotation. For optimal performance, Extra Loud Earphones are recommended. </p>	CP185 Headset, CP200 Headset, CP200d Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4129		<p>Replacement foam earpad and windscreen kit for PMLN6538, BDN6773, HMN9013 and RMN4016 lightweight headsets. </p>	CP110 Headset, CP200 Headset, CP200d Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4136		<p>This earpiece is compatible with all Remote Speaker Microphones with a 3.5mm audio jack on the head of the microphone. </p>	PMLN4620A, BPR20 Headset, BPR40 Headset, CP185 Headset, CP200 Headset, CP200d Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4219		<p>This accessory retainer kit fits the following radios:</p><p>CP150, CP200, PR400, EP450</p><p>It is designed to support the 2-pin audio connector by reducing movement and strain on the pins themselves as well as the internal jack.</p>	CP200 Headset, CP200d Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
5006		<p>Low noise kit with Quick Disconnect translucent tube and clear rubber ear tip.</p>
5076		<p>Replacement standard clear rubber eartips. Pack of 25. For RLN6232A/RLN6241A.</p>
5883	<p>BEHIND THE HEAD HEAVY DUTY HEADSET / VOX, 2 PIN</p>		PMLN6854, dual muff headset, racing style headset