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, 4116, 5076, 4136, 4133, 4219, 
    4115, 4127, 4121, 4120, 4087, 4122, 
    4129, 4119, 4126, 4086, 4118, 4117, 
    4084, 4128, 4080, 4079, 4132
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00044

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,4116,5076,4136,4133,4219,4115,4127,4121,4120,4087,4122,4129,4119,4126,4086,4118,4117,4084,4128,4080,4079,4132)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	search_words
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
4084	<p>2 Piece Surveillance Kit, with Microphone and PTT Combined, Beige (2-wire rubber eartip style) </p>	HMN9754A, HMN9754B, HMN9754C, CP110 Headset, CP185 Headset, CP200 Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4086	<p>Mag One earpieces are small, comfortable and enable users to discreetly send and receive messages from their two-way radios. Choose from earbud or over-the-ear design, depending on user preference. </p>	BPR20 Headset, BPR40 Headset, CP185 Headset, CP200 Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4087	<p>Mag One earpieces are small, comfortable and enable users to discreetly send and receive messages from their two-way radios. Choose from earbud or over-the-ear design, depending on user preference. </p>	PMLN4443A, PMLN4443B, BPR20 Headset, BPR40 Headset, CP185 Headset, CP200 Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4115	<p>2 Piece Surveillance Kit, with Microphone and PTT Combined, Black (2-wire - rubber eartip style) </p>	BPR20 Headset, BPR40 Headset, CP110 Headset, CP185 Headset, CP200 Headset, CP200XLS 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
4117	<p>2-Wire Comfort Earpiece with Combined Microphone and PTT, Beige Surveillance Kits with Extended-Wear Comfort Earpieces include a Low Noise enhancement (RLN6232) already attached for extra comfort and convenience. </p>	CP110 Headset, CP185 Headset, CP200 Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4118	<p>2-Wire Comfort Earpiece with Combined Microphone and PTT, Black Surveillance Kits with Extended-Wear Comfort Earpieces include a Low Noise enhancement (RLN6232) already attached for extra comfort and convenience. </p>	CP110 Headset, CP185 Headset, CP200 Headset, CP200XLS 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
4126		BPR20 Headset, BPR40 Headset, CP185 Headset, CP200 Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4127		BPR20 Headset, BPR40 Headset, CP110 Headset, CP185 Headset, CP200 Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4128	<p>The PMLN5011 Temple Transducer Headset uses two bone vibration speakers for receiving, and a flexible boom microphone for transmitting. Unlike traditional headsets, the Temple Transducer allows the user's ears to be uncovered and completely free to hear surrounding environmental sounds while using the two-way portable radio. An in-line push-to-talk (PTT) button with clothing clip frees the user from holding the radio while communicating </p>	BPR20 Headset, BPR40 Headset, CP110 Headset, CP200 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
4132	<p>This lightweight headset provides high-clarity, discreet two-way communication, while maintaining the comfort necessary for extended wear in moderate noise environments. The single-muff, adjustable headset has a boom microphone and an in-line Push-to-Talk feature. </p>	RMN4016A, CP110 Headset, CP200 Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4133	<p>This medium-weight headset is ideal for two-way communication in high-noise environments;it mounts easily to hardhats with slots and has an excellent noise reduction rating of 22dB. Easily replaceable ear seals are filled with a liquid and foam combination to provide excellent sealing comfort. This black headset comes with a 3-foot coiled cord assembly and requires adapter cable RKN4094A. </p><p>Peltor Part Number – MT7H79P3E-34 </p>	RMN4051A, CP200 Headset, CP200XLS Headset, APX3000 Headset, APX4000 Headset, APX4000XE Headset, APX6000 Headset, APX6000XE Headset, APX7000 Headset, APX7000XE 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>