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 (
    4116, 4136, 4115, 4127, 4087, 4126, 4086, 
    4128, 4089, 4091, 4108, 4085, 4090, 
    4971
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00030

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": 14,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4116,4136,4115,4127,4087,4126,4086,4128,4089,4091,4108,4085,4090,4971)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	full_description	search_words
4085	<p>Dual-Pin Earbud With In-Line Microphone and PTT</p>		PMLN4294A, PMLN4294B, PMLN4294C, BPR20 Headset, BPR40 Headsets/Lapel Mics/Surveillance Kits
4086		<p>Mag One earpieces are small, comfortable and enable users to discreetly send and receive messages from their two-way radios. Choose from earbud or over-the-ear design, depending on user preference. </p>	BPR20 Headset, BPR40 Headset, CP185 Headset, CP200 Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4087		<p>Mag One earpieces are small, comfortable and enable users to discreetly send and receive messages from their two-way radios. Choose from earbud or over-the-ear design, depending on user preference. </p>	PMLN4443A, PMLN4443B, BPR20 Headset, BPR40 Headset, CP185 Headset, CP200 Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4089			BPR20 Headset, BPR40 Headset, CP200d Headsets/Lapel Mics/Surveillance Kits
4090		<p>Ideal for environments that require Discrete communications, surveillance accessories allow the radio user to privately receive messages with an earpiece. This is a 2-wire surveillance kit with clear acoustic tube. </p>	BPR20 Headset, BPR40 Headsets/Lapel Mics/Surveillance Kits
4091		<p>D Shell Earpiece with PTT Mic. </p>	BPR20 Headset, BPR40 Headset, CP200 Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4108		<p>Small and lightweight, this earpiece clips comfortably to the ear. It features a boom microphone and in-line Push-to-Talk feature. </p>	BPR20 Headset, BPR40 Headset, CP200 Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4115		<p>2 Piece Surveillance Kit, with Microphone and PTT Combined, Black (2-wire - rubber eartip style) </p>	BPR20 Headset, BPR40 Headset, CP110 Headset, CP185 Headset, CP200 Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4116		<p>An earphone jack located on the microphone allows the user to receive audio when using this earpiece. The translucent tube provides a more discreet option for those that need to receive messages privately </p><p>UL certified TIA 4950 approved when used with a UL certified TIA 4950 approved APX 4000 two knob radio </p>	BPR20 Headset, CP200XLS Headset, CP200d Headset, CP200 Headset, CP185 Headset, BPR40 Headset, XPR6100 Headset, XPR6350 Headset, XPR6550 Headset, XPR6380 Headset, XPR6580 Headset, XPR7350 Headset, XPR7550 Headset, XPR7380 Headset, XPR7580 Headset, XPR3500 Headset, XPR3300 Headsets/Lapel Mics/Surveillance Kits
4126			BPR20 Headset, BPR40 Headset, CP185 Headset, CP200 Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4127			BPR20 Headset, BPR40 Headset, CP110 Headset, CP185 Headset, CP200 Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4128		<p>The PMLN5011 Temple Transducer Headset uses two bone vibration speakers for receiving, and a flexible boom microphone for transmitting. Unlike traditional headsets, the Temple Transducer allows the user's ears to be uncovered and completely free to hear surrounding environmental sounds while using the two-way portable radio. An in-line push-to-talk (PTT) button with clothing clip frees the user from holding the radio while communicating </p>	BPR20 Headset, BPR40 Headset, CP110 Headset, CP200 Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4136		<p>This earpiece is compatible with all Remote Speaker Microphones with a 3.5mm audio jack on the head of the microphone. </p>	PMLN4620A, BPR20 Headset, BPR40 Headset, CP185 Headset, CP200 Headset, CP200d Headset, CP200XLS Headsets/Lapel Mics/Surveillance Kits
4971