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 (4135, 4142, 4140) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00021

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": 3,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4135,4142,4140)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	search_words
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
4140	<p>Motorola PMMN4077 – Remote Speaker Microphone - Mag One </p>	BPR20 Speaker Mic, BPR40 Speaker Microphones, PMMN-4077, PMMN-4077A, PMMN4077-A, BPR40d, BPR40d speaker mic, BPR40d mic, BPR40 mic, BPR 40, BPR 40 speaker mic, BPR 40 mic, CP100d speaker mic, CP100d RSM, CP100d mic, CP100d compact mic, CP185 speaker mic, CP185 compact mic, CP185 RSM
4142	<p>An earphone jack located on the remote speaker microphone allows the user to receive audio more discreetly when using this earpiece. This lightweight earpiece flexes to fit the ear contour for hours of comfortable wear. </p>	WADN4190A, BPR20 Speaker Mic, CP200XLS Speaker Mic, CP200d Speaker Mic, CP200 Speaker Mic, CP185 Speaker Mic, BPR40 Speaker Mic, XPR2500 Speaker Mic, XPR4350 Speaker Mic, XPR4550 Speaker Mic, XPR5350 Speaker Mic, XPR5550 Speaker Mic, XPR4380 Speaker Mic, XPR4580 Speaker Mic, XPR5380 Speaker Mic, XPR5580 Speaker Microphones