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 (
    4135, 4823, 4832, 4814, 4819, 4820, 4821, 
    4818, 4816, 4822, 4817, 4815, 4827, 
    4825, 4831, 4830, 4829, 4839, 5061, 
    5060, 4835, 4837, 4836, 5111
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00042

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 (4135,4823,4832,4814,4819,4820,4821,4818,4816,4822,4817,4815,4827,4825,4831,4830,4829,4839,5061,5060,4835,4837,4836,5111)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
4135 <p>This earpiece is compatible with all Remote Speaker Microphones with a 3.5 mm audio jack on the head of the microphone. </p><p>UL certified TIA 4950 approved when used with a UL certified TIA 4950 approved APX 4000 two knob radio </p> AARLN4885A, AARLN4885B, BPR20 Speaker Mic, CP200XLS Speaker Mic, CP200d Speaker Mic, CP200 Speaker Mic, CP185 Speaker Mic, BPR40 Speaker Mic, XPR3300 Speaker Mic, XPR3500 Speaker Mic, XPR6100 Speaker Mic, XPR6350 Speaker Mic, XPR6550 Speaker Mic, XPR6380 Speaker Mic, XPR6580 Speaker Mic, XPR7350 Speaker Mic, XPR7380 Speaker Mic, XPR7550 Speaker Mic, XPR7580 Speaker Mic, APX1000 Speaker Mic, APX3000 Speaker Mic, APX4000 Speaker Mic, APX6000 Speaker Mic, APX7000 Speaker Mic, APX600XE Speaker Mic, APX7000XE Speaker Microphones, AARLN-4885, AARLN4885A, AARLN-4885A, AARLN-4885B
4814 <p>Replacement coil cord for Remote Speaker Microphone part numbers, PMMN4025, PMMN4046, and PMMN4050.</p> APX 1000 Speaker Mic, APX 3000 Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Mic, XPR 6100 Speaker Mic, XPR 6350 Speaker Mic, XPR 6380 Speaker Mic, XPR 6550 Speaker Mic, XPR 6580 Speaker Mic, XPR 7350 Speaker Mic, XPR 7380 Speaker Mic, XPR 7550 Speaker Mic, XPR 7580 Speaker Microphones
4815 APX 1000 Speaker Mic, APX 3000 Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Microphones
4816 <p>These cables provide a standard connection point from the remote speaker microphone to third party accessory products. These cables are compatible with HMN4104, HMN4103 and HMN4101.</p> APX 1000 Speaker Mic, APX 3000 Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Microphones
4817 <p>These cables provide a standard connection point from the remote speaker microphone to third party accessory products. These cables are compatible with HMN4104, HMN4103 and HMN4101.</p> APX 1000 Speaker Mic, APX 3000 Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Microphones
4818 <p>These cables provide a standard connection point from the remote speaker microphone to third party accessory products. These cables are compatible with HMN4104, HMN4103 and HMN4101.</p> APX 1000 Speaker Mic, APX 3000 Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Microphones
4819 <p>This durable large remote speaker microphone is easy to operate even while wearing gloves and features IMPRES audio, which optimizes your audio when operating in noisy environments. The noise-canceling acoustics negate background noise so your voice come through loud and clear when you speak directly into the microphone. IP-54 rating. </p><p>Also has a programmable orange emergency button and 3.5mm audio jack to attach earpieces for discreet communications. </p><p>Compatible with the following radios: APX1000, APX3000, APX4000, APX6000, APX6000XE, APX7000, APX7000XE, SRX2200, MTP830S, MTP830S.</p> APX 1000 Speaker Mic, APX 3000 Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Microphones
4820 <p>This large remote speaker microphone is easy to operate even while wearing gloves and features IMPRES audio which optimizes your audio when operating in noisy environments. The Windporting feature is specifically designed for windy outdoor environments and dramatically reduces the noise caused by howling winds and harsh weather.</p><p>Also has a volume switch, programmable orange emergency button and side programmable button. Replaces the PMMN4065A.</p> APX 1000 Speaker Mic, APX 3000 Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Microphones
4821 <p>This large remote speaker microphone is easy to operate even while wearing gloves and features IMPRES audio which optimizes your audio when operating in noisy environments. The Windporting feature is specifically designed for windy outdoor environments and dramatically reduces the noise caused by howling winds and harsh weather. Audio jack available to attach earpieces for discreet communications. </p> APX 1000 Speaker Mic, APX 3000 Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Microphones
4822 <p>Receive-Only Earpiece with translucent tube and rubber eartip (for HMN4104, HMN4103 and HMN4101 only)</p> RLN6424A, APX 1000 Speaker Mic, APX 3000 Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Microphones
4823 <p>Mission-Critical wireless remote speaker microphone With battery and rotating clip for all APX Series radios.</p> APX 3000 Speaker Mic, APX 4000 Speaker Mic, XPR 5580 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 3000 Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Mic, APX 1500 Speaker Mic, APX 4500 Speaker Mic, APX 6500 Speaker Mic, APX 7500 Speaker Mic, XPR 4350 Speaker Mic, XPR 4380 Speaker Mic, XPR 4550 Speaker Mic, XPR 4580 Speaker Mic, XPR 5350 Speaker Mic, XPR 5380 Speaker Mic, XPR 5550 Speaker Microphones
4825 <p>The HMN4103 is a rugged microphone with a display, volume control, two programmable buttons and an orange emergency button. Its 8-character display mimics the top display to show zone and channel information at a glance. It is designed with a large speaker that delivers audio that is clearer, more intelligible and up 50% louder than XTS-series RSMs. Meets rugged specifications for submersibility and includes a rugged, submersible audio jack from Motorola.</p> HMN4103A, APX 3000 Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Microphones
4827 <p>Motorola NMN6271 - IMPRES XP RSM with Dual Mic Noise Suppression, Volume Control, 1-Programmable Button and Orange Button. Rugged, Submersible (IP68) </p> APX 3000 Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Microphones
4829 <p>Compatible with APX radios, this APX remote speaker microphone is an IMPRES RSM that is windporting and rugged. (IP68).</p> APX 3000 Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Microphones, PMMN-4083, PMMN-4083A, PMMN-4083AL, PMMN 4083, PMMN 4083A, PMMN 4083AL, PMMN4083AL
4830 <p>IMPRES RSM with 3.5mm Threaded and NON-Threaded Audio Jack and Orange Button. Noise Cancelling (IP54)</p> APX 3000 Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Microphones, PMN4084, PMMN-4084, PMMN-4084A, PMMN4084-A
4831 <p> Motorola PMMN4099 - IMPRES Windporting RSM with Volume Toggle Switch, Orange Button, 3.5mm NON-Threaded Jack (IP55) </p> PMMN4099A, APX 3000 Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Microphones
4832 <p>Compatible with APX radios, this APX accessory is a wireless remote speaker microphone with battery, clip and dual unit charger.</p> APX 3000 Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 3000 Speaker Mic, APX 7000XE Speaker Mic, APX 4000 Speaker Mic, APX 4000XE Speaker Mic, APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Microphones, RLN-6554, RLN-6554A, RLN 6554
4835 <p>Standard Temperature Replacement Cable for XE RSM (NNTN8203 series)</p> APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Microphones
4836 <p>Xtreme Temperature Replacement Cable for XE RSM (NNTN8203 and NNTN8575 series)</p> APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Microphones
4837 <p>Clip Assembly with brass insert designed to work with the Boston Leather Straps (AY000223A01, AY000229A01) requires Clip Button NNTN8749 </p><p>The XE RSM clip paired with a clip button allows easy and secure access to your RSM when used with a Boston Radio Strap with Button Back Holder. </p> APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Microphones
4839 APX 6000 Speaker Mic, APX 6000XE Speaker Mic, APX 7000 Speaker Mic, APX 7000XE Speaker Microphones
5060 <p>XP RSM Replacement Cable with Audio Jack </p>
5061 <p>XP RSM Replacement Cable without Audio Jack </p>
5111 <p>Compatible with APX radios, this APX remote speaker microphone is the XE500 black housing, no channel knob, includes xtreme temperature cable.</p>