SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.unit_name 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    22447, 22448, 22449, 22450, 22451, 22452, 
    22453, 22454, 22455, 22456, 22457, 
    22458, 22459, 22460, 22461, 22462
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00121

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id", "idx_product_lang"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 16,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (22447,22448,22449,22450,22451,22452,22453,22454,22455,22456,22457,22458,22459,22460,22461,22462) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description unit_name
22447 Support assembly - spring seat, right<p>Part number 65487AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22448 Panel complete - rear floor<p>Part number 65500AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22449 Panel-rear floor<p>Part number 65511AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22450 Panel assembly - rear floor side, left<p>Part number 65531AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22451 Panel assembly - rear floor side, right<p>Part number 65541AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22452 Bracket assembly battery mounting rear side NO.1<p>Part number 655C7AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22453 Reinforcement - rear floor wheel house, left<p>Part number 65538AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22454 Reinforcement - rear floor wheel house, right<p>Part number 65547AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22455 Extension assembly - rear floor center cross mounting, left<p>Part number 65535AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22456 Extension assembly - rear floor center cross mounting, right<p>Part number 65545AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22457 Member Assey - Rear Floor Center Cross Upper<p>Part number 65591AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22458 Panel assembly - spare tire wheel center<p>Part number 65693AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22459 Bracket assembly - battery mounting rear<p>Part number 65597AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22460 Rainf assembly-battery mounting rear center, left<p>Part number 655A3AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22461 Member-2nd row seat mounting, left<p>Part number 65612AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22462 Member - 2nd row seat mounting, right<p>Part number 65622AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>