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 (
    84026, 84027, 84028, 84029, 89626, 89639, 
    89652, 89523, 91308, 92050, 92138, 
    83954, 83956, 83958, 83960, 90061, 
    89623, 89636, 90106, 89649, 91304, 
    83982, 83983, 83984, 83985, 89187, 
    90081, 89485, 83128, 89619
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00071

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "13.52"
    },
    "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": 30,
      "rows_produced_per_join": 30,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "10.52",
        "eval_cost": "3.00",
        "prefix_cost": "13.52",
        "data_read_per_join": "114K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_product_descriptions`.`product_id` in (84026,84027,84028,84029,89626,89639,89652,89523,91308,92050,92138,83954,83956,83958,83960,90061,89623,89636,90106,89649,91304,83982,83983,83984,83985,89187,90081,89485,83128,89619)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
83128 nuie Arvan Deck Mounted Bath Filler - Brushed Brass
83954 Old London White Topaz With Lever Handle Deck Mounted Bath Filler - Chrome
83956 Old London White Topaz With Crosshead Handle Deck Mounted Bath Filler - Chrome
83958 Old London White Topaz With Lever Handle Deck Mounted Bath Filler - Chrome
83960 Old London White Topaz With Crosshead Handle Deck Mounted Bath Filler - Chrome
83982 Old London White Topaz With Lever Handle Wall Mounted Bath Spout & Stop Taps - Chrome / White
83983 Old London White Topaz With Crosshead Handle Wall Mounted Bath Spout & Stop Taps - Chrome / White
83984 Old London White Topaz With Lever Handle Wall Mounted Bath Spout & Stop Taps - Chrome / White
83985 Old London White Topaz With Crosshead Handle Wall Mounted Bath Spout & Stop Taps - Chrome / White
84026 Old London Black Topaz With Lever Handle Wall-Mounted Bath Spout - Chrome / Black
84027 Old London Black Topaz With Crosshead Handle Bath Spout - Chrome / Black
84028 Old London Black Topaz With Lever Handle Bath Spout - Chrome / Black
84029 Old London Black Topaz With Crosshead Handle Bath Spout - Chrome / Black
89187 nuie Sanford Deck Mounted 3 Tap Hole Bath Filler - Chrome
89485 Hudson Reed Soar Bath Filler - Chrome
89523 Hudson Reed Sottile Bath Filler - Chrome
89619 Hudson Reed Tec Lever Bath Filler - Chrome
89623 Hudson Reed Tec Lever Bath Filler - Matt Black
89626 Hudson Reed Tec Lever Bath Filler - Brushed Brass
89636 Hudson Reed Tec Crosshead Bath Filler - Matt Black
89639 Hudson Reed Tec Crosshead Bath Filler - Brushed Brass
89649 Hudson Reed Revolution Bath Filler - Matt Black
89652 Hudson Reed Revolution Bath Filler - Brushed Brass
90061 Hudson Reed Willow Bath Filler - Chrome
90081 nuie Windon Deck Mounted 3 Tap Hole Bath Filler - Chrome
90106 nuie Windon Deck Mounted Bath Filler - Brushed Brass
91304 nuie Aztec Deck Mount Bath Filler - Matt Black
91308 nuie Aztec Deck Mount Bath Filler - Brushed Brass
92050 BC Designs Victrion Wall Mount Crosshead 3 Tap Hole Bath Filler Tap - Chrome
92138 BC Designs Victrion Wall Mounted Lever 3 Tap Hole Bath Filler Tap - Chrome