Sandbox

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 (
    4078, 4779, 5006, 5108, 4103, 4104, 3983, 
    4106, 4105, 3984, 4107, 3981, 3985, 
    3982, 4034, 4491, 5616, 5246, 6825, 
    6826, 4996, 6827, 6136, 6814
  ) 
  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 (4078,4779,5006,5108,4103,4104,3983,4106,4105,3984,4107,3981,3985,3982,4034,4491,5616,5246,6825,6826,4996,6827,6136,6814)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	full_description	search_words
3981		<p>Colored bands easily slip on antennas and enable you to quickly visually identify custom radio user groups. Each ID band kit is sold in packs of 10. </p>	SL300 Antenna, XPR3300 Antenna, XPR7580 Antenna, XPR7380 Antenna, XPR7350 Antenna, XPR3500 Antennas, TLK100, TLK 100
3982		<p>Colored bands easily slip on antennas and enable you to quickly visually identify custom radio user groups. Each ID band kit is sold in packs of 10. </p>	SL300 Antenna, XPR3500 Antenna, XPR7580 Antenna, XPR7380 Antenna, XPR7350 Antenna, XPR3300 Antennas, TLK100, TLK 100
3983		<p>Colored bands easily slip on antennas and enable you to quickly visually identify custom radio user groups. Each ID band kit is sold in packs of 10. </p>	SL300 Antenna, XPR3300 Antenna, XPR3500 Antenna, XPR7350 Antenna, XPR7380 Antenna, XPR7580 Antennas, TLK100, TLK 100
3984		<p>Colored bands easily slip on antennas and enable you to quickly visually identify custom radio user groups. Each ID band kit is sold in packs of 10. </p>	SL300 Antenna, XPR3300 Antenna, XPR3500 Antenna, XPR7350 Antenna, XPR7380 Antenna, XPR7580 Antennas, TLK100, TLK 100
3985		<p>Colored bands easily slip on antennas and enable you to quickly visually identify custom radio user groups. Each ID band kit is sold in packs of 10. </p>	SL300 Antenna, XPR3300 Antenna, XPR3500 Antenna, XPR7350 Antenna, XPR7380 Antenna, XPR7580 Antennas, TLK100, TLK 100
4034		<p>Heavy duty swivel belt clip for SL300, SL3500, TLK100 and TLK110</p>	SL300 clip, SL300 belt clip, SL3500 clip, SL3500e clip, SL3500 belt clip, SL3500e belt clip, TLK100 belt clip, TLK100 clip, TLK 100 clip, TLK 100 belt clip, TLK-100 clip, TLK-100 belt clip, PMLN-7128, PMLN7128B, PMLN-7128A, TLK110, TLK110 clip, TLK110 belt clip, TLK 110 clip, TLK 110 belt clip
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
4103		<p>Swivel earpiece with in-line PTT for TLK100, TLK110, SL300, SL7550, SL7580, SL7590 (SL7000e Series).</p>	SL300 Headset, Headsets/Lapel Mics/Surveillance Kits, SL300, SL-300, TLK100, TLK-100, TLK 100, 7189, PMLN-7189
4104			SL300 Headset, SL7550IS Headsets/Lapel Mics/Surveillance Kits, TLK100
4105			SL300 Headset, Headsets/Lapel Mics/Surveillance Kits, TLK100
4106			SL300 Headset, Headsets/Lapel Mics/Surveillance Kits, TLK100, SL300
4107			SL300 Headset, Headsets/Lapel Mics/Surveillance Kits, SL300, SL-300, TLK100, TLK 100, TLK-100
4491		<p>This nylon strap wraps conveniently around the wrist to allow you to easily carry your SL Series radio and provides additional protection against accidental drops.</p>	SL7550 Case, SL7580 Case, SL7590 Cases, TLK110 case, TLK110 strap, TLK110 wrist strap, TLK 110 case, TLK 110 strap, TLK 110 wrist strap
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
4996		<p>The Motorola OEM BT110 battery comes standard with the DTR600, DTR700 and TLK110.</p>	Motorola DTR600 battery, DTR700 battery, DTR 600, DTR 700 , DTR700, TLK110, TLK110 battery, TLK 110 battery
5006		<p>Low noise kit with Quick Disconnect translucent tube and clear rubber ear tip.</p>
5108		<p>Receive Only Earpiece with translucent tube and rubber eartip</p>	PMLN-7560, PMLN-7560A, PMLN 7560
5246		<p>Non IMPRES wired RSM with 2.5mm connector and integrated battery. Kit includes USB-A to Micro USB cable for charging.</p><ul><li>Dimensions (W x L x D): 58mm x 84mm x 24mm (without clip)</li><li>Weight includes RSM and cable: 154g</li><li>Battery life: 22 hours min (5/5/90 duty cycle)</li><li>Charge time: 2 hours typical</li><li>Operating voltage: 3.7V DC</li><li>Acoustic: windporting omni-directional</li><li>Emergency Button: no</li><li>Volume Control: no toggle</li><li>Programmable Button: no</li><li>IP Rating: IP67</li><li>Audio Jack 3.5mm: yes (compatible earpiece is PMLN7560A (Non UL))</li><li>Radio compatibility: MOTOTRBO SL series and WAVE Devices and Radios including, TLK100 and TLK110.</li></ul>	TLK100 speaker mic, TLK110 speaker mic
5616	<p><span data-bind="text: label">Audio Jack</span>: <span data-bind="text: value">3.5MM NON-THREADED</span> </p><p><span data-bind="text: label">Channel Control</span>: <span data-bind="text: value">No</span> </p><p><span data-bind="text: label">Display</span>: <span data-bind="text: value">NO DISPLAY</span> </p><p><span data-bind="text: label">Intrinsic Safety Rating</span>: <span data-bind="text: value">NO RATING</span> </p><p><span data-bind="text: label">IP Rating</span>: <span data-bind="text: value">IP67</span> </p><p><span data-bind="text: label">Microphone Type</span>: <span data-bind="text: value">WINDPORTING</span> </p><p><span data-bind="text: label">Programmable Button</span>: <span data-bind="text: value">ORANGE EMERGENCY AND MULTIPLE PROGRAMMABLE BUTTONS</span> </p><p><span data-bind="text: label">Technology</span>: <span data-bind="text: value">WIRELESS</span> </p><p><span data-bind="text: label">Volume Control</span>: <span data-bind="text: value">Yes</span> </p>		WM500, WM-500, PMMN-4127, PMMN4127A, PMMN-4127A, Bluetooth mic, Bluetooth speaker mic, TLK100 microphone, TLK100 BT mic, TLK100 bluetooth mic, TLK-100 bluetooth mic, TLK 100 bluetooth mic, R7 bluetooth mic, MOTOTRBO R7 bluetooth mic, R7 microphone, TLK110, TLK-110, TLK 110
6136	<p>EP910W Bluetooth™Earpiece with PTT</p>		Bluetooth earpiece, bluetooth PTT earpiece, Bluetooth PTT, EVOLVE, TLK100, TLK 100, TLK110, TLK 110, TLK150, TLK 150, TLK-100, TLK-110, TLK-150, TLK25, TLK-25, TLK 25
6814		<p>USB-C to USB-A charging cable. Included with TLK 25 and TLK110 </p>	PMKN-4294, PMKN-4294A, TLK-110, TLK110 cable, TLK110 charger cable, USB-C charger, USBC charger, USB-C charger cable
6825		<p>The PMLN8298 provides wireless push-to-talk communication, an emergency button, and radio calling functions - volume control, PTT button, emergency/call button function. It requires PMLN8190, PMLN8077, or PMLN8125, earpiece.</p>
6826		<p>The vehicle mount can be easily mounted with the WP300 and attached to a steering wheel or other vehicle attachable locations. Includes hook and loop strap and cable tie.</p>
6827	<p>This kit includes the WP300 Wireless Bluetooth Control Pod and the translucent tube earpiece (PMLN8190).</p>