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 (
    4774, 4776, 4775, 5006, 4112, 4110, 4109, 
    4111, 4113, 4114, 5108, 5107, 4522, 
    4518, 4521, 4519, 4520, 4930, 4922, 
    4923, 4929, 4924, 5104, 5102
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00043

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 (4774,4776,4775,5006,4112,4110,4109,4111,4113,4114,5108,5107,4522,4518,4521,4519,4520,4930,4922,4923,4929,4924,5104,5102)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
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
4518 <p>Mag One accessories are the only value-line of audio accessories tested and certified by Motorola and offer greater affordability and solid performance. These accessories do not meet the same level of specifications as our Motorola Original accessories. This Mag One swivel earpiece fits flexibly around the ear and features a combined microphone and push-to-talk on a single wire. </p> XPR 3300 Headset, XPR 3500 Headsets/Lapel Mics/Surveillance Kits, XPR3300e, XPR3500e
4519 <p>Mag One accessories are the only value-line of audio accessories tested and certified by Motorola and offer greater affordability and solid performance. These accessories do not meet the same level of specifications as our Motorola Original accessories. This Mag One earset is lightweight and the boom microphone makes it easier to communicate with other co-workers</p> XPR 3300 Headset, XPR 3500 Headsets/Lapel Mics/Surveillance Kits
4520 <p>Mag One accessories are the only value-line of audio accessories tested and certified by Motorola and offer greater affordability and solid performance. These accessories do not meet the same level of specifications as our Motorola Original accessories. This Mag One earbud is comfortable to wear and features a combined microphone and push-to-talk on a single wire. </p> XPR 3300 Headset, XPR 3500 Headsets/Lapel Mics/Surveillance Kits, XPR3300e, XPR3500e
4521 <p>Lightweight Over-the-Head Headset, Single Muff, In-line PTT and Boom Mic, VOX capable</p> XPR 3300 Headset, XPR 3500 Headsets/Lapel Mics/Surveillance Kits, XPR3300e, XPR3500e
4522 <p>2-wire surveillance kit with quick disconnect clear acoustic tube for XPR3000e Series. </p> XPR 3300 Headset, XPR 3500 Headsets/Lapel Mics/Surveillance Kits, XPR3300e, XPR3500e, 2 wire kit, 2 wire earpiece, 2-wire earpiece
4774 APX 1000 Headset, APX 3000 Headset, APX 4000 Headset, APX 4000XE Headset, APX 6000 Headset, APX 6000XE Headset, APX 7000 Headset, APX 7000XE Headset, XPR 3300 Headset, XPR 3500 Headset, XPR 6100 Headset, XPR 6350 Headset, XPR 6380 Headset, XPR 6550 Headset, XPR 6580 Headset, XPR 7350 Headset, XPR 7380 Headset, XPR 7550 Headset, XPR 7580 Headset, APX 1500 Headset, APX 4500 Headset, APX 6500 Headset, APX 7500 Headsets/Lapel Mics/Surveillance Kits
4775 APX 1000 Headset, APX 3000 Headset, APX 4000 Headset, APX 4000XE Headset, APX 6000 Headset, APX 6000XE Headset, APX 7000 Headset, APX 7000XE XPR 3300 Headset, XPR 3500 Headset, XPR 6100 Headset, XPR 6350 Headset, XPR 6380 Headset, XPR 6550 Headset, XPR 6580 Headset, XPR 7350 Headset, XPR 7380 Headset, XPR 7550 Headset, XPR 7580 Headset, APX 1500 Headset, APX 4500 Headset, APX 6500 Headset, APX 7500 Headsets/Lapel Mics/Surveillance Kits
4776 APX 1000 Headset, APX 3000 Headset, APX 4000 Headset, APX 4000XE Headset, APX 6000 Headset, APX 6000XE Headset, APX 7000 Headset, APX 7000XE Headset, XPR 3300 Headset, XPR 3500 Headset, XPR 6100 Headset, XPR 6350 Headset, XPR 6380 Headset, XPR 6550 Headset, XPR 6580 Headset, XPR 7350 Headset, XPR 7380 Headset, XPR 7550 Headset, XPR 7580 Headset, APX 1500 Headset, APX 4500 Headset, APX 6500 Headset, APX 7500 Headsets/Lapel Mics/Surveillance Kits
4922 <p>Adjustable D-Ring Earpiece with In-Line Microphone and PTT for XPR3300, XPR3300e, XPR3500, XPR3500e</p>
4923 <p><span data-bind="widgetLocaleText: 'dimensions'">Dimensions</span> (<span data-bind="text: msiDimensionUOM.value ? msiDimensionUOM.value : 'IN-Inch'">IN-Inch</span>): <span data-bind="text: value">4.5</span> <span data-bind="widgetLocaleText: 'width'">(W)</span> <span data-bind="text: value">36</span> <span data-bind="widgetLocaleText: 'height'">(H)</span> <span data-bind="text: value">7.75</span> <span data-bind="widgetLocaleText: 'length'">(L)</span></p><p><span data-bind="text: label">Connector Type</span>: <span data-bind="text: value">Direct to radio</span></p><p><span data-bind="text: label">Earpiece Style</span>: <span data-bind="text: value">Dual-muff</span></p><p><span data-bind="text: label">Headset Type</span>: <span data-bind="text: value">Behind-the-head</span></p><p><span data-bind="text: label">Microphone</span>: <span data-bind="text: value">Boom mic</span></p><p><span data-bind="text: label">Noise Reduction Rating</span>: <span data-bind="text: value">24 dB</span></p><p><span data-bind="text: label">PTT</span>: <span data-bind="text: value">On ear cup</span></p><p><span data-bind="widgetLocaleText: 'length'"><span data-bind="text: label">Technology</span>: <span data-bind="text: value">Motorola original</span><br></span></p> XPR3300e, XPR3500e, XPR 3300 headset, XPR 3500 headset, dual muff headset, XPR 3300e headset, XPR 3500e headset, behind the neck headset, behind the head headset
4924 <p>IS Rated - TIA4950</p><p>VOX Operation</p>
4929 <p><span data-bind="widgetLocaleText: 'dimensions'">Dimensions</span> (<span data-bind="text: msiDimensionUOM.value ? msiDimensionUOM.value : 'IN-Inch'">IN-Inch</span>): <span data-bind="text: value">4.5</span> <span data-bind="widgetLocaleText: 'width'">(W)</span> <span data-bind="text: value">36</span> <span data-bind="widgetLocaleText: 'height'">(H)</span> <span data-bind="text: value">7.75</span> <span data-bind="widgetLocaleText: 'length'">(L)</span></p><p><span data-bind="text: label">Connector Type</span>: <span data-bind="text: value">Direct to radio</span></p><p><span data-bind="text: label">Earpiece Style</span>: <span data-bind="text: value">Dual-muff</span></p><p><span data-bind="text: label">Headset Type</span>: <span data-bind="text: value">Over-the-head</span></p><p><span data-bind="text: label">Microphone</span>: <span data-bind="text: value">Boom mic</span></p><p><span data-bind="text: label">Noise Reduction Rating</span>: <span data-bind="text: value">24 dB</span></p><p><span data-bind="text: label">PTT</span>: <span data-bind="text: value">On ear cup</span></p><p><span data-bind="widgetLocaleText: 'length'"><span data-bind="text: label">Technology</span>: <span data-bind="text: value">Motorola original</span><br></span></p> XPR3300e headset, XPR3500e headset, over the head headset, padded headset, XPR 3300e headset, XPR 3500e headset, XPR-3300 headset, XPR-3500 headset
4930 <p>IS Rated - TIA4950 (UL)</p><p>24 db NRR</p><p>VOX Capable</p> dual muff headset, XPR3300e, XPR3500e, XPR 3300 headset, XPR 3500 headset, IS headset
5006 <p>Low noise kit with Quick Disconnect translucent tube and clear rubber ear tip.</p>
5102 <p>IMPRES 3-Wire Surveillance Kit with quick disconnect translucent tube, Beige</p>
5104
5107 <p>Receive only adjustable D-ring style earpiece with 3.5mm plug</p> PMLN-7396, PMLN 7396, PMLN-7396A, PMLN7396A
5108 <p>Receive Only Earpiece with translucent tube and rubber eartip</p> PMLN-7560, PMLN-7560A, PMLN 7560