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 (
    10316, 10317, 10319, 10321, 10323, 10327, 
    10328, 10329, 10337, 10339, 10341, 
    10354, 10360, 10362, 10368, 10369
  ) 
  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 (10316,10317,10319,10321,10323,10327,10328,10329,10337,10339,10341,10354,10360,10362,10368,10369) and cscart_product_descriptions.lang_code = 'ru'"
    }
  }
}

Result

product_id short_description full_description unit_name
10316 plug-seal<p>Part number 84136G5000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10317 plug<p>Part number 84141D2000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10319 plug-drain<p>Part number 1735325501B</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10321 Pad-roof side<p>Part number 84181A7000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10323 Pad-roof side<p>Part number 8418229010</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10327 screw-tapping<p>Part number 1018805161</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10328 screw-machine<p>Part number 1220104101</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10329 screw-tapping<p>Part number 1249204121</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10337 Mat-Cup Holder<p>Part number 84623T1000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10339 cup holder assembly<p>Part number 84670T1100RWD</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10341 Tray-console top<p>Part number 84652T1000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10354 Pad-Wireless Charging<p>Part number 95570T1000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10360 Duct assembly-rear air ventilator, NO.2<p>Part number 97020T1000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10362 BRACKET<p>Part number 84635T1000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10368 Damper - Glove Box<p>Part number 84546J6000</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>
10369 Cover assembly - top of glove box housing<p>Part number 84540T10004X</p><p>If you are not sure about compatibility, please contact us in advance to confirm the part number.</p>