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 (
    25319, 25320, 25321, 25322, 25323, 25324, 
    25325, 25326, 25327, 25328, 25329, 
    25330, 25331, 25332, 25333, 25334
  ) 
  AND cscart_product_descriptions.lang_code = 'ru'

Query time 0.00132

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 (25319,25320,25321,25322,25323,25324,25325,25326,25327,25328,25329,25330,25331,25332,25333,25334) and cscart_product_descriptions.lang_code = 'ru'"
    }
  }
}

Result

product_id short_description full_description unit_name
25319 Hose-electric water pump<p>Part number 375Y3GI230</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
25320 Hose-electric water pump<p>Part number 375Y3CV020</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
25321 Hose-electric water pump<p>Part number 375Y3GI240</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
25322 Hose-Battery Heater NO.2<p>Part number 375Y4CV050</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
25323 Bolt-BMA B type<p>Part number 375Z1GI000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
25324 Bolt-BMA C type<p>Part number 375Z2GI000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
25325 Bolt-BMA D type<p>Part number 375Z3GI000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
25326 Bolt-BMA E type<p>Part number 375Z4GI000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
25327 Bolt-BMA F Type<p>Part number 375Z5GI000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
25328 Volt-High Voltage Battery Type A<p>Part number 375Z6GI000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
25329 Volt-High Voltage Battery Type B<p>Part number 375Z7GI000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
25330 BOLT<p>Part number 1129005101</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
25331 BOLT<p>Part number 1140308206K</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
25332 BOLT<p>Part number 1140305106B</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
25333 Vehicle charging management system<p>Part number 350001XCD0</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
25334 Integrated charging control unit<p>Part number 364001XCA0</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>