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 (
    23295, 23296, 23297, 23298, 23299, 23300, 
    23301, 23302, 23303, 23304, 23305, 
    23306, 23307, 23308, 23309, 23310
  ) 
  AND cscart_product_descriptions.lang_code = 'ru'

Query time 0.00963

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 (23295,23296,23297,23298,23299,23300,23301,23302,23303,23304,23305,23306,23307,23308,23309,23310) and cscart_product_descriptions.lang_code = 'ru'"
    }
  }
}

Result

product_id short_description full_description unit_name
23295 Steering Wheel Remote Control Bezel Assembly<p>Part number 96700AR850VCS</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23296 Switch assembly - steering remote control left<p>Part number 96710AR000VCS</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23297 Switch assembly - steering remote control right<p>Part number 96720AR850VCS</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23298 bezel assembly<p>Part number 96750AR500VCS</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23299 Unit Assembly - TILT & TELE<p>Part number 95490T6001</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23300 Module assembly - steering wheel airbag<p>Part number 80100T6100NNB</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23301 Caliper Kit - Front Brake, Left<p>Part number 58180T6A31BRC</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23302 Caliper Kit - Front Brake, Right<p>Part number 58190T6A31BRC</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23303 Brake assembly-rear wheel, left<p>Part number 58210T6220BRC</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23304 Brake assembly-rear wheel, right<p>Part number 58230T6220BRC</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23305 Caliper Kit - Rear Brake, Left<p>Part number 58310T6A22BRC</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23306 Caliper Kit - Rear Brake, Right<p>Part number 58311T6A22BRC</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23307 Integrated electric brake<p>Part number 58520T6000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23308 Hose-brake front, left<p>Part number 58731T6060</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23309 Hose-brake front, right<p>Part number 58732T6060</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
23310 Sensor assembly - wheel speed, left<p>Part number 58930T6100</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>