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 (
    84595, 84596, 84665, 84666, 84533, 84534, 
    84599, 84600, 84306, 84307, 84308, 
    84309, 84519, 84331, 84332, 84304, 
    84305, 84632, 84633, 84681, 84682, 
    84685, 84686, 84679, 84680, 84683, 
    84684, 84622, 84623, 84500
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00076

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 (84595,84596,84665,84666,84533,84534,84599,84600,84306,84307,84308,84309,84519,84331,84332,84304,84305,84632,84633,84681,84682,84685,84686,84679,84680,84683,84684,84622,84623,84500)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
84304 Hudson Reed Fusion Floor Standing 4 Door Vanity Basin Left Hand Combination 1200mm - Gloss White
84305 Hudson Reed Fusion Floor Standing 4 Door Vanity Basin Right Hand Combination 1200mm - Gloss White
84306 Hudson Reed Fusion Floor Standing 3 Door Vanity Basin & WC Left Hand Combination 1500mm - Gloss White
84307 Hudson Reed Fusion Floor Standing 3 Door Vanity Basin & WC Right Hand Combination 1500mm - Gloss White
84308 Hudson Reed Fusion Floor Standing 3 Door Vanity Basin & WC Left Hand Combination 1500mm - Gloss White
84309 Hudson Reed Fusion Floor Standing 3 Door Vanity Basin & WC Right Hand Combination 1500mm - Gloss White
84331 Hudson Reed Fusion Wall Hung 4 Drawer Vanity Unit & Twin Polymarble Basin 1200mm - Gloss White
84332 Hudson Reed Fusion Wall Hung 4 Drawer Vanity Unit & Twin Ceramic Basin 1200mm - Gloss White
84500 Hudson Reed Fusion Floor Standing 2 Door Vanity Basin & WC Left Hand Combination 1200mm - Anthracite Woodgrain
84519 Hudson Reed Fusion Floor Standing 4 Door Vanity Basin Combination Compact 1200mm - Anthracite Woodgrain
84533 Hudson Reed Fusion Floor Standing 4 Door Vanity Unit & Twin Polymarble Basin 1200mm - Anthracite Woodgrain
84534 Hudson Reed Fusion Floor Standing 4 Drawer Vanity Unit & Twin Ceramic Basin 1200mm - Anthracite Woodgrain
84595 Hudson Reed Fusion Wall Hung 4 Drawer Vanity Unit & Twin Polymarble Basin 1200mm - Hacienda Black
84596 Hudson Reed Fusion Wall Hung 4 Drawer Vanity Unit & Twin Ceramic Basin 1200mm - Hacienda Black
84599 Hudson Reed Fusion Floor Standing 4 Door Vanity Unit & Twin Polymarble Basin 1200mm - Hacienda Black
84600 Hudson Reed Fusion Floor Standing 4 Drawer Vanity Unit & Twin Ceramic Basin 1200mm - Hacienda Black
84622 Hudson Reed Fusion Floor Standing 2 Door Vanity Basin & WC Left Hand Combination 1100mm - Gloss Grey
84623 Hudson Reed Fusion Floor Standing 2 Door Vanity Basin & WC Right Hand Combination 1100mm - Gloss Grey
84632 Hudson Reed Fusion Floor Standing 2 Door Vanity Basin & WC Left Hand Combination 1200mm - Gloss Grey
84633 Hudson Reed Fusion Floor Standing 2 Door Vanity Basin & WC Right Hand Combination 1200mm - Gloss Grey
84665 Hudson Reed Fusion Floor Standing 4 Door Vanity Unit & Twin Polymarble Basin 1200mm - Gloss Grey
84666 Hudson Reed Fusion Floor Standing 4 Drawer Vanity Unit & Twin Ceramic Basin 1200mm - Gloss Grey
84679 Hudson Reed Fusion Floor Standing 2 Door Vanity Unit & WC with Left Hand Semi Recessed Basin Combination 1000mm - Gloss Grey
84680 Hudson Reed Fusion Floor Standing 2 Door Vanity Unit & WC with Right Hand Semi Recessed Basin Combination 1000mm - Gloss Grey
84681 Hudson Reed Fusion Floor Standing 2 Door Vanity Unit & WC with Left Hand Semi Recessed Basin Combination 1100mm - Gloss Grey
84682 Hudson Reed Fusion Floor Standing 2 Door Vanity Unit & WC with Right Hand Semi Recessed Basin Combination 1100mm - Gloss Grey
84683 Hudson Reed Fusion Floor Standing 2 Door Vanity Unit & WC with Left Hand Semi Recessed Basin Combination 1000mm - Gloss Grey
84684 Hudson Reed Fusion Floor Standing 2 Door Vanity Unit & WC with Right Hand Semi Recessed Basin Combination 1000mm - Gloss Grey
84685 Hudson Reed Fusion Floor Standing 2 Door Vanity Unit & WC with Left Hand Semi Recessed Basin Combination 1100mm - Gloss Grey
84686 Hudson Reed Fusion Floor Standing 2 Door Vanity Unit & WC with Right Hand Semi Recessed Basin Combination 1100mm - Gloss Grey