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 (
    4858, 4135, 4887, 4116, 4888, 4872, 4880
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00022

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": 7,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4858,4135,4887,4116,4888,4872,4880)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	search_words
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
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
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
4872		BDN6783A, BDN6783B, APX 1000 Headset, APX 3000 Headset, APX 4000 Headset, APX 4000XE Headset, APX 6000 Headset, APX 6000XE Headset, APX 7000 Headset, APX 7000XE Headsets/Lapel Mics/Surveillance Kits
4880	<p>This surveillance kit includes an extended-wear comfort earpiece with rubber eartip and clear, comfortable acoustic tube. Users hear transmissions clearly, while the clear tube provides a discreet appearance. This black, 2-wire kit has a combined microphone and Push-to-Talk feature.</p>	RLN5312A, APX 1000 Headset, APX 3000 Headset, APX 4000 Headset, APX 4000XE Headset, APX 6000 Headset, APX 6000XE Headset, APX 7000 Headset, APX 7000XE Headsets/Lapel Mics/Surveillance Kits
4887	<p>IMPRES 2-Wire Surveillance Kit with translucent tube, programmable button, black </p>	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
4888	<p>IMPRES 2-Wire Surveillance Kit with translucent tube, programmable button, bige</p>	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