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, 4814, 4845, 4846, 4844, 4848, 4847, 
    4849, 4843, 4842
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00026

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": 10,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4135,4814,4845,4846,4844,4848,4847,4849,4843,4842)",
      "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
4842 <p>IMPRES Industrial Noise Cancelling Microphone Submersible (IP57)</p> NNTN8382A, 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
4843 <p>IMPRES INC (Industrial Noise-Canceling) remote speaker microphone w/ 3.5mm threaded audio jack</p> NNTN8383A, 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, NNTN-8383, NNTN-8383B
4844 <p>This accessory conveniently clips to your shirt pocket or lapel and enables easy communication without having to remove the radio from your belt. The Windporting feature helps lessen background noise from high winds, severe weather and other outdoor noises. Audio jack available to attach earpieces for discreet communications.</p> 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, XPR6100, XPR6350, XPR6550, XPR6580, XPR7350, XPR7550, XPR7380, XPR7580, PMMN-4024, PMMN-4024A
4845 <p>This accessory conveniently clips to your shirt pocket or lapel and enables easy communication without having to remove the radio from your belt. The IMPRES audio feature 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> 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
4846 <p>This accessory conveniently clips to your shirt pocket or lapel and enables easy communication without having to remove the radio from your belt. With its IP57 rating, this microphone can withstand up to one meter of submersion. Windporting remote speaker microphones lessen background noise from high winds, severe weather and other outdoor noises. </p> 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
4847 <p>This accessory conveniently clips to your shirt pocket or lapel and enables easy communication without having to remove the radio from your belt. 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. Volume control, emergency button and programmable button give you convenient access to critical features. </p> 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
4848 <p>This accessory conveniently clips to your shirt pocket or lapel and enables easy communication without having to remove the radio from your belt. This large microphone is easy to operate even while wearing gloves and features IMPRES audio which optimizes your audio when operating in noisy environments. The noise-cancelling feature reduces distracting background noises. Audio jack available to attach earpieces for discreet communications. </p> 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
4849 <p>Replacement cable for remote speaker microphone models PMMN4024 and PMMN4040.</p> 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