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 (
    23727, 23728, 23729, 23730, 23731, 23732, 
    23733, 23734, 23735, 23736, 23737, 
    23738, 23739, 23740, 23741, 23742
  ) 
  AND cscart_product_descriptions.lang_code = 'ru'

Query time 0.00036

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 (23727,23728,23729,23730,23731,23732,23733,23734,23735,23736,23737,23738,23739,23740,23741,23742) and cscart_product_descriptions.lang_code = 'ru'"
    }
  }
}

Result

product_id short_description full_description unit_name
23727 hose-suction<p>Part number 97763AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23728 Tube Assemblies - Suction & Liquid<p>Part number 97775AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23729 Tube-Suction & Liquid<p>Part number 97777AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23730 Engine Assembly-Sub<p>Part number 1Y21M2TA02</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23731 Auto Transaxle and Torque Converter Assembly<p>Part number 4500047JA0</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23732 plug<p>Part number 473492N000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23733 Disc-front wheel brake<p>Part number 51712T1100</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23734 Knuckle-front axle, left<p>Part number 51710AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23735 Knuckle-front axle, right<p>Part number 51711AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23736 Hub Assembly - Front Wheel<p>Part number 51730AR050</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23737 Cover - front brake disc dust left<p>Part number 51755AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23738 Cover - front brake disc dust right<p>Part number 51756AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23739 Wheel Assembly - Aluminum<p>Part number 52910AR100</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23740 Bush-Front Lower Arm "A"<p>Part number 54551AR000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23741 Bar assembly - front stabilizer<p>Part number 54810AR100</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23742 Bush-stabilizer bar<p>Part number 54813AR100</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>