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 (
    5006, 4116, 4136, 4115, 4127, 4121, 4120, 
    4087, 4122, 4119, 4126, 4086, 4118, 
    4117, 4084, 5883, 4088
  ) 
  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": "3",
      "used_key_parts": ["product_id"],
      "rows": 17,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (5006,4116,4136,4115,4127,4121,4120,4087,4122,4119,4126,4086,4118,4117,4084,5883,4088)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
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
4088 <p>Ultra-light Mag One headsets are optimized for communications intensive environments in which personnel need to interact with customers while maintaining radio communications. Choose from a earhook, behind-the-head or over-the-head style headset. All provide high quality audio, easy-to-use functions and all-day comfort. </p> 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
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
5006 <p>Low noise kit with Quick Disconnect translucent tube and clear rubber ear tip.</p>
5883 <p>BEHIND THE HEAD HEAVY DUTY HEADSET / VOX, 2 PIN</p> PMLN6854, dual muff headset, racing style headset