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 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (415294, 415292) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00044

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "2.81"
    },
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 2,
      "rows_produced_per_join": 2,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "2.41",
        "eval_cost": "0.40",
        "prefix_cost": "2.81",
        "data_read_per_join": "13K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`webmarco`.`cscart_product_descriptions`.`product_id` in (415294,415292)) and (`webmarco`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
415292 <p>Automatic water dispenser with cup holder<br /></p><p>Automatic Water Dispenser zsw-c06 with Cup Holder</p> <p>This automatic water dispenser is a perfect gadget for any home. You can say goodbye to the constant purchase of water bottles. With its help, you will no longer have to use manual water dispensers, because it will do the job for you.</p> <p>Technical specifications:<br />- Material: ABS, stainless steel<br />- Color: Black<br />- Power: 3.8W<br />- Charging: 2 hours<br />- Working: more than a month<br />- Power supply: USB charging<br />- Max. Basic load capacity: 25 kg<br />- Applicable bottled water: regular bottled water and wired PC bottled water<br />- Applicable water volume: 4.5L, 7.5L, 10L, 11.3L, 18.9L, etc.</p><p></p>
415294 <p>Electric bottle pump, dispenser, drinking water dispenser, USB charging<br /></p><p>AKU AUTOMATIC ELECTRIC PUMP FOR WATER CANS, PORTABLE, USB CHARGING</p> <p>Electric pumping device suitable for pure drinking water bottled in PET bottles of different volumes:</p> <p>5L (classic can and dosing can)<br />7.5F<br />11.3L<br />15L<br />18.9L<br /> <br />PORTABLE: The AKU water pump is great for home or office use, and its compact size makes it portable and great for hiking, picnics, sporting events, kids' camps, hot days at the beach or when we're grilling together by friends and loved ones. It is extremely easy to sanitize.</p><p></p>