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 (
    88961, 85800, 82352, 91937, 91939, 91940, 
    91941, 91942, 91943, 88957, 88958, 
    85644, 88942, 86856, 88969, 88970, 
    88973, 88974, 87280, 87288, 85580, 
    86863, 82386, 88094, 89442, 89444, 
    88967, 88968, 88971, 88972, 88955, 
    88956, 92151, 92152, 92153, 92353, 
    92354, 92355, 92356, 88953, 88954, 
    87879, 82403, 82410, 82424, 91893, 
    91894, 91895
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00095

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "21.63"
    },
    "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": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "16.83",
        "eval_cost": "4.80",
        "prefix_cost": "21.63",
        "data_read_per_join": "183K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_product_descriptions`.`product_id` in (88961,85800,82352,91937,91939,91940,91941,91942,91943,88957,88958,85644,88942,86856,88969,88970,88973,88974,87280,87288,85580,86863,82386,88094,89442,89444,88967,88968,88971,88972,88955,88956,92151,92152,92153,92353,92354,92355,92356,88953,88954,87879,82403,82410,82424,91893,91894,91895)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
82352 Hudson Reed Multi Option Shower Kits Destiny Shower Kit - Chrome
82386 nuie Shower Kits Rigid Riser Kit - Chrome
82403 nuie Shower Kits Slide Rail Kit - Matt Black
82410 nuie Shower Kits Square Slider Rail Kit with Elbow - Gunmetal
82424 nuie Shower Kits Slide Rail Kit - Brushed Brass
85580 Roll Top Bath Pack
85644 High Level Flush Pipe Pack
85800 Hudson Reed Sarenna Curved 1 Tap Hole Polymarble Basin 700mm
86856 Hudson Reed Shower Accessories Shower Seat - Chrome
86863 1/2 Shower Curtain Ring
87280 Furniture Sparkling Black Worktop 1440mm - Black
87288 Furniture Sparkling White Worktop 1440mm - White
87879 nuie Mayford Round Ceramic 1 Tap Hole Basin 1200mm
88094 Old London Richmond Basin Stand - Chrome
88942 Hudson Reed Quartet 2 Tap Hole Polymarble Double Basin 1400mm
88953 Hudson Reed Fusion Left Hand Square L-Shaped 1 Tap Hole Polymarble Basin 1000mm
88954 Hudson Reed Fusion Right Hand Square L-Shaped 1 Tap Hole Polymarble Basin 1000mm
88955 Hudson Reed Fusion Left Hand Square L-Shaped 1 Tap Hole Polymarble Basin 1100mm
88956 Hudson Reed Fusion Right Hand Square L-Shaped 1 Tap Hole Polymarble Basin 1100mm
88957 Hudson Reed Fusion Left Hand Square L-Shaped 1 Tap Hole Polymarble Basin 1200mm
88958 Hudson Reed Fusion Right Hand Square L-Shaped 1 Tap Hole Polymarble Basin 1200mm
88961 nuie Deco 1200mm Double Polymarble Mid-Edge Basin - White
88967 Hudson Reed Fusion Left Hand Round Semi-Recessed 1 Tap Hole Polymarble Basin 1000mm
88968 Hudson Reed Fusion Right Hand Round Semi-Recessed 1 Tap Hole Polymarble Basin 1000mm
88969 Hudson Reed Fusion Left Hand Round Semi-Recessed 1 Tap Hole Polymarble Basin 1100mm
88970 Hudson Reed Fusion Right Hand Round Semi-Recessed 1 Tap Hole Polymarble Basin 1100mm
88971 Hudson Reed Fusion Left Hand Square Semi-Recessed 1 Tap Hole Polymarble Basin 1000mm
88972 Hudson Reed Fusion Right Hand Square Semi-Recessed 1 Tap Hole Polymarble Basin 1000mm
88973 Hudson Reed Fusion Left Hand Square Semi-Recessed 1 Tap Hole Polymarble Basin 1100mm
88974 Hudson Reed Fusion Right Hand Square Semi-Recessed 1 Tap Hole Polymarble Basin 1100mm
89442 Hudson Reed Sarenna Marble Worktop 1000mm - White
89444 Hudson Reed Sarenna Marble Worktop 1000mm - Grey
91893 BC Designs Victrion 3 Tier Towel Rack - Copper
91894 BC Designs Victrion 3 Tier Towel Rack - Gold
91895 BC Designs Victrion 3 Tier Towel Rack - Nickel
91937 BC Designs Victrion Traditional Slide Rail Kit and Handset - Brushed Chrome
91939 BC Designs Victrion Traditional Slide Rail Kit and Handset - Brushed Gold
91940 BC Designs Victrion Traditional Slide Rail Kit and Handset - Brushed Nickel
91941 BC Designs Victrion Traditional Slide Rail Kit and Handset - Copper
91942 BC Designs Victrion Traditional Slide Rail Kit and Handset - Gold
91943 BC Designs Victrion Traditional Slide Rail Kit and Handset - Nickel
92151 BC Designs Standpipes Traditional Bath Legs with Adjustable Shrouds - Copper
92152 BC Designs Standpipes Traditional Bath Legs with Adjustable Shrouds - Gold
92153 BC Designs Standpipes Traditional Bath Legs with Adjustable Shrouds - Nickel
92353 BC Designs Bath Legs with Adjustable Shrouds - Brushed Chrome
92354 BC Designs Bath Legs with Adjustable Shrouds - Brushed Copper
92355 BC Designs Bath Legs with Adjustable Shrouds - Brushed Gold
92356 BC Designs Bath Legs with Adjustable Shrouds - Brushed Nickel