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 (
    90771, 87358, 87378, 82548, 90769, 87380, 
    87357, 87376, 87377, 90766, 90767, 
    87374, 90150, 90165, 87379, 84073, 
    84081, 82509, 87373, 82508, 90149, 
    90164, 90764, 90765, 90142, 90157, 
    90762, 90763, 90148, 90163
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00085

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 (90771,87358,87378,82548,90769,87380,87357,87376,87377,90766,90767,87374,90150,90165,87379,84073,84081,82509,87373,82508,90149,90164,90764,90765,90142,90157,90762,90763,90148,90163)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
82508 nuie Pacific 860mm Single Entry Quadrant Enclosure - 6mm Glass - Polished Chrome
82509 nuie Pacific 860mm Single Entry Quadrant Enclosure - 6mm Glass - Polished Chrome
82548 nuie Pacific 1050mm D Shape Enclosure - 6mm Glass - Polished Chrome
84073 Hudson Reed 1400mm Frame Screen With Ceiling Posts - 8mm Glass - Matt Black
84081 Hudson Reed Abstract 1400mm Frame Wetroom Screen with Ceiling Posts - 8mm Glass - Matt Black
87357 Hudson Reed Apex 1000 x 800mm Offset Quadrant Enclosure - 8mm Glass - Polished Chrome
87358 Hudson Reed Apex 1000 x 800mm Offset Quadrant Enclosure - 8mm Glass - Polished Chrome
87373 Hudson Reed Apex 800mm Quadrant Enclosure - 8mm Glass - Polished Chrome
87374 Hudson Reed Apex 800mm Quadrant Enclosure - 8mm Glass - Polished Chrome
87376 Hudson Reed Apex 900mm Quadrant - 8mm Glass - Matt Black
87377 Hudson Reed Apex 900mm Quadrant Enclosure - 8mm Glass - Polished Chrome
87378 Hudson Reed Apex 900mm Quadrant Enclosure - 8mm Glass - Polished Chrome
87379 Hudson Reed Apex 900 x 800mm Offset Quadrant Enclosure - 8mm Glass - Polished Chrome
87380 Hudson Reed Apex 900 x 800mm Offset Quadrant Enclosure - 8mm Glass - Polished Chrome
90142 nuie Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen 1850mm x 1400mm x 8mm - Brushed Brass
90148 Hudson Reed Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen & Support Bar 1950mm x 1100mm x 8mm - Brushed Brass
90149 Hudson Reed Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen & Support Bar 1950mm x 1200mm x 8mm - Brushed Brass
90150 Hudson Reed Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen & Support Bar 1950mm x 1400mm x 8mm - Brushed Brass
90157 nuie Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen 1850mm x 1400mm x 8mm - Matt Black
90163 Hudson Reed Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen & Support Bar 1950mm x 1100mm x 8mm - Matt Black
90164 Hudson Reed Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen & Support Bar 1950mm x 1200mm x 8mm - Matt Black
90165 Hudson Reed Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen & Support Bar 1950mm x 1400mm x 8mm - Matt Black
90762 Nuie 1200x800 Chrome Offset Quad & Tray - Left Hand
90763 Nuie 1200x800 Chrome Offset Quad & Tray - Right Hand
90764 Nuie 1000x800 Black Offset Quad & Tray - Left Hand
90765 Nuie 1000x800 Black Offset Quad & Tray - Right Hand
90766 Nuie 1200x800 Black Offset Quad & Tray - Left Hand
90767 Nuie 1200x800 Black Offset Quad & Tray - Right Hand
90769 Nuie 800 Chrome Quadrant Tray & Shower Kit
90771 Nuie 900 Chrome Quadrant Tray & Shower Kit