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 (
    4718, 4793, 4774, 4776, 4078, 4779, 4777, 
    4792, 4787, 4858, 4786, 4790, 4778, 
    4856, 4860, 4796, 4797, 4795, 4794, 
    4857, 5006, 4878, 4112, 4110
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00045

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 (4718,4793,4774,4776,4078,4779,4777,4792,4787,4858,4786,4790,4778,4856,4860,4796,4797,4795,4794,4857,5006,4878,4112,4110)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
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
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
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
4718 XPR 6100 Bluetooth Accessory, XPR 7580 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 4000 Bluetooth Accessory, APX 3000 Bluetooth Accessory, XPR 6350 Bluetooth Accessory, XPR 6380 Bluetooth Accessory, XPR 6550 Bluetooth Accessory, XPR 6580 Bluetooth Accessory, XPR 7350 Bluetooth Accessory, XPR 7380 Bluetooth Accessory, XPR 7550 Bluetooth Accessory, XPR 7580 Bluetooth Accessory, SL7550 Bluetooth Accessory, SL7580 Bluetooth Accessory, SL7590 Bluetooth Accessory, APX 3000 Bluetooth Accessory, APX 4000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, SL7550 Bluetooth Accessory, SL7580 Bluetooth Accessory, SL7590 Bluetooth Accessory, XPR 6100 Bluetooth Accessory, XPR 6350 Bluetooth Accessory, XPR 6380 Bluetooth Accessory, XPR 6550 Bluetooth Accessory, XPR 6580 Bluetooth Accessory, XPR 7350 Bluetooth Accessory, XPR 7380 Bluetooth Accessory, XPR 7550 Bluetooth
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
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
4777 <p>Receive Only Surveillance Kit, Black (single wire)</p> 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 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 Headsets/Lapel Mics/Surveillance Kits
4778 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 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 Headsets/Lapel Mics/Surveillance Kits
4779 <p>Replacement Ear Tips, Clear - Pack of 50 (for use with RLN5886 and RLN6242).</p> 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 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 Headsets/Lapel Mics/Surveillance Kits
4786 <p>Lightweight headsets provide high-clarity, hands free, discreet two-way communication, while maintaining the comfort necessary for extended-wear in moderate noise environments.</p> 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 7550 Headset, XPR 7380 Headset, XPR 7350 Headset, XPR 6580 Headset, XPR 6550 Headset, XPR 6380 Headset, XPR 6350 Headset, XPR 6100 Headset, XPR 7580 Headsets/Lapel Mics/Surveillance Kits
4787 <p>Bone conduction enables you to receive audio without covering the ear, allowing to either wear hearing protection in extreme noise environments or keep their ears open to external sounds such as outside traffic, fire alarms and machinery. </p> 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 7550 Headset, XPR 7380 Headset, XPR 7350 Headset, XPR 6580 Headset, XPR 6550 Headset, XPR 6380 Headset, XPR 6350 Headset, XPR 6100 Headset, XPR 7580 Headsets/Lapel Mics/Surveillance Kits
4790 <p>Provides high-clarity, hands free, discreet two-way, communication, while maintaining the comfort necessary for extended-wear in moderate noise environments. Adjustable over-the-head, single-ear headset with a boom microphone and in-line PTT.</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">SINGLE-EAR</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">Intrinsic Safety Rating</span>: <span data-bind="text: value">TIA4950(UL)</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">PTT</span>: <span data-bind="text: value">IN-LINE</span><br></p> 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 7550 Headset, XPR 7380 Headset, XPR 7350 Headset, XPR 6580 Headset, XPR 6550 Headset, XPR 6380 Headset, XPR 6350 Headset, XPR 6100 Headset, XPR 7580 Headsets/Lapel Mics/Surveillance Kits, lightweight headset, single muff headset, over-the-head headset, over the head headset
4792 <p>Motorola RLN6490 - XBT Headset BTN, Heavy Duty Headset , BT</p> <p>*ONLY COMPATIBLE WITH APX MODELS WITH FULL KEYPAD. Minimum radio requirements: Code-Plug Version - R13.00.01 Firmware - R13.00.05 Option Board - R08.00.00</p> RLN6490A, XPR6100 Headset Headset, XPR6350 Headset Headsets/Lapel Mics/Surveillance Kits
4793 <p>XBT HeadsetHB, Heavy Duty Headset , BT </p><p>*ONLY COMPATIBLE WITH APX MODELS WITH FULL KEYPAD. Minimum radio requirements: Code-Plug Version - R13.00.01 Firmware - R13.00.05 Option Board - R08.00.00 </p> RLN6491A, APX 3000 Headset, APX 4000 Headset, APX 4000XE Headset, APX 6000 Headset, APX 6000XE Headset, APX 7000 Headset, APX 7000XE 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, XPR 5350 Headset, XPR 5380 Headset, XPR 5550 Headset, XPR 5580 Headsets/Lapel Mics/Surveillance Kits
4794 <p>Audio Adapter, In-Line PTT Adapter, GCAI </p><p>Peltor Part Number - FL5063-34</p> APX 3000 Headset, APX 4000 Headset, APX 4000XE Headset, APX 6000 Headset, APX 6000XE Headset, APX 7000 Headset, APX 7000XE 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 Headsets/Lapel Mics/Surveillance Kits
4795 <p>Motorola RMN5137 - 3M Peltor MT Series 2-Way Comm Headset, MT7H79A Headband</p><p>Peltor Part Number - MT7H79A-C5063-34</p> RMN5137A, APX 3000 Headset, APX 4000 Headset, APX 4000XE Headset, APX 6000 Headset, APX 6000XE Headset, APX 7000 Headset, APX 7000XE 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 Headsets/Lapel Mics/Surveillance Kits
4796 <p>Motorola RMN5138 - 3M Peltor MT Series 2-Way Comm Headset, MT7H79B Neckband </p><p>Peltor Part Number –MT7H79B-C5063-34</p> RMN5138A, APX 3000 Headset, APX 4000 Headset, APX 4000XE Headset, APX 6000 Headset, APX 6000XE Headset, APX 7000 Headset, APX 7000XE 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 Headsets/Lapel Mics/Surveillance Kits
4797 <p>Motorola RMN5139 - 3M Peltor MT Series 2-Way Comm Headset, MT7H79P3E - Hard Hat Attachment </p><p>Peltor Part Number - MT7H79P3E-C5063-34</p> RMN5139A, APX 3000 Headset, APX 4000 Headset, APX 4000XE Headset, APX 6000 Headset, APX 6000XE Headset, APX 7000 Headset, APX 7000XE 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 Headsets/Lapel Mics/Surveillance Kits
4856 <p>Take surveillance operations to the next level with surveillance kits that allow you to transmit and receive discreet communications. These kits feature a streamlined design and durable, rugged cables that withstand tough working conditions. A quick-disconnect, durable and comfortable translucent tube enables easy sharing of this kit between shifts.The 3-wire surveillance kits feature one wire for receiving communication, one wire for the microphone, and one wire for the PTT. Motorola's state-of-the-art IMPRES technology allows communication between the radio and the audio accessory. The result is optimal audio performance, enhanced audio gain capability, and increased customization, assuring the highest quality communication.</p> 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 6100 Headset, XPR 6350 Headset, XPR 6380 Headset, XPR 6550 Headset, XPR 7350 Headset, XPR 7380 Headset, XPR 7550 Headset, XPR 7580 Headsets/Lapel Mics/Surveillance Kits
4857 <p>Take surveillance operations to the next level with surveillance kits that allow you to transmit and receive discreet communications. These kits feature a streamlined design and durable, rugged cables that withstand tough working conditions. A quick-disconnect, durable and comfortable translucent tube enables easy sharing of this kit between shifts.The 3-wire surveillance kits feature one wire for receiving communication, one wire for the microphone, and one wire for the PTT. Motorola's state-of-the-art IMPRES technology allows communication between the radio and the audio accessory. The result is optimal audio performance, enhanced audio gain capability, and increased customization, assuring the highest quality communication.</p> 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 6100 Headset, XPR 6350 Headset, XPR 6380 Headset, XPR 6550 Headset, XPR 7350 Headset, XPR 7380 Headset, XPR 7550 Headset, XPR 7580 Headsets/Lapel Mics/Surveillance Kits
4858 <p>IMPRES 2-Wire Surveillance Kit, programmable button, black </p> 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 6100 Headset, XPR 6350 Headset, XPR 6380 Headset, XPR 6550 Headset, XPR 7350 Headset, XPR 7380 Headset, XPR 7550 Headset, XPR 7580 Headsets/Lapel Mics/Surveillance Kits
4860 <p>Surveillance Low Noise Kit, includes 1 clear rubber eartip. For low-noise environments (does not provide hearing protection)</p> 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 6100 Headset, XPR 6350 Headset, XPR 6380 Headset, XPR 6550 Headset, XPR 7350 Headset, XPR 7380 Headset, XPR 7550 Headset, XPR 7580 Headsets/Lapel Mics/Surveillance Kits
4878 APX 1000 Headset, APX 7000XE Headset, APX 7000XE Headset, APX 7000 Headset, APX 6000XE Headset, APX 6000 Headset, APX 4000XE Headset, APX 4000 Headset, APX 3000 Headset, APX 3000 Headset, APX 4000 Headset, APX 4000XE Headset, APX 6000 Headset, APX 6000XE Headset, APX 7000 Headsets/Lapel Mics/Surveillance Kits
5006 <p>Low noise kit with Quick Disconnect translucent tube and clear rubber ear tip.</p>