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 (
    22127, 22128, 22129, 22130, 22131, 22132, 
    22133, 22134, 22135, 22136, 22137, 
    22138, 22139, 22140, 22141, 22142
  ) 
  AND cscart_product_descriptions.lang_code = 'ru'

Query time 0.00048

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 (22127,22128,22129,22130,22131,22132,22133,22134,22135,22136,22137,22138,22139,22140,22141,22142) and cscart_product_descriptions.lang_code = 'ru'"
    }
  }
}

Result

product_id short_description full_description unit_name
22127 Holder - Fuel Tube<p>Part number 31359S1500</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22128 Holder - Fuel Tube<p>Part number 31360AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22129 PEDAL ASSY-ACCELERATOR<p>Part number 32700T1200</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22130 Pedal Assembly-Brake<p>Part number 32800AR150</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22131 PAD-PEDAL<p>Part number 32825T1200</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22132 battery assembly<p>Part number 37110CG820</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22133 Vent Hose Assembly-Battery<p>Part number 37140AR100</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22134 Clamp-Battery<p>Part number 37160AR100</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22135 Sensor Assembly-Battery<p>Part number 37180AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22136 Indicator assembly - shift lever<p>Part number 46750AR100</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22137 Auto Transaxle and Torque Converter Assembly<p>Part number 4500047JG0</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22138 Converter Assy-Torque<p>Part number 4510047840</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22139 Diff Assembly-Front<p>Part number 4740047651</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22140 transfer assembly<p>Part number 473004F003</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22141 plug-filter<p>Part number 474824F000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
22142 Flange Assembly - Rear<p>Part number 4734747100</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>