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 (
    10256, 10257, 10274, 10275, 10282, 10285, 
    10293, 10294, 10295, 10297, 10301, 
    10303, 10306, 10307, 10309, 10315
  ) 
  AND cscart_product_descriptions.lang_code = 'ru'

Query time 0.00043

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 (10256,10257,10274,10275,10282,10285,10293,10294,10295,10297,10301,10303,10306,10307,10309,10315) and cscart_product_descriptions.lang_code = 'ru'"
    }
  }
}

Result

product_id short_description full_description unit_name
10256 Handle assembly-rear door inside, left<p>Part number 83610T1000VCS</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10257 Handle assembly-rear door inside, right<p>Part number 83620T1000VCS</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10274 Actuator assembly - rear power door latch, left<p>Part number 81430T1400</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10275 Actuator assembly - rear power door latch, right<p>Part number 81440T1400</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10282 Bracket - rear outside handle support, left<p>Part number 83658T1000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10285 Bracket - rear outside handle support, right<p>Part number 83668T1000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10293 Motor assembly - power window regulator rear, left<p>Part number 83450T1000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10294 Motor assembly - power window regulator rear, right<p>Part number 83460T1000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10295 BOLT<p>Part number 1128106206B</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10297 Stay Assembly - Center Floor Tunnel Rear<p>Part number 65191T1000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10301 Bar assembly - cowl shock absorber housing, left<p>Part number 841A3T1000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10303 tunnel insulator<p>Part number 84114T1000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10306 plug-hole<p>Part number 83191B1000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10307 Tape-Blanking Hole<p>Part number 841812M000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10309 Pad-antivibration rear floor front, left<p>Part number 84163D2000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10315 plug-drain<p>Part number 1735650000B</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>