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 (
    89686, 88383, 88384, 89683, 89684, 88363, 
    88109, 88121, 88133, 88280, 88281, 
    88282, 88357, 89680, 89681, 89682, 
    88362, 88108, 88120, 88132, 88276, 
    88277, 88278, 88279, 89676, 89677, 
    89678, 89679, 88355, 88356, 88358, 
    88359, 88360, 88361, 89696, 89675, 
    88107, 88119, 88131, 88275, 88304, 
    88305, 88353, 88354, 88271, 89674, 
    88351, 88352
  ) 
  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 (89686,88383,88384,89683,89684,88363,88109,88121,88133,88280,88281,88282,88357,89680,89681,89682,88362,88108,88120,88132,88276,88277,88278,88279,89676,89677,89678,89679,88355,88356,88358,88359,88360,88361,89696,89675,88107,88119,88131,88275,88304,88305,88353,88354,88271,89674,88351,88352)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
88107 nuie Rectangular Slimline Shower Tray 1200 x 900mm - White
88108 nuie Rectangular Slimline Shower Tray 1400 x 800mm - White
88109 nuie Rectangular Slimline Shower Tray 1400 x 900mm - White
88119 nuie Rectangular Slimline Shower Tray 1200 x 900mm - Grey
88120 nuie Rectangular Slimline Shower Tray 1400 x 800mm - Grey
88121 nuie Rectangular Slimline Shower Tray 1400 x 900mm - Grey
88131 nuie Rectangular Slimline Shower Tray 1200 x 900mm - Black
88132 nuie Rectangular Slimline Shower Tray 1400 x 800mm - Black
88133 nuie Rectangular Slimline Shower Tray 1400 x 900mm - Black
88271 nuie Slip Resistant Rectangular Slimline Shower Tray 1100 x 900mm - White
88275 nuie Slip Resistant Rectangular Slimline Shower Tray 1200 x 900mm - White
88276 nuie Slip Resistant Rectangular Slimline Shower Tray 1300 x 800mm - White
88277 nuie Slip Resistant Rectangular Slimline Shower Tray 1400 x 700mm - White
88278 nuie Slip Resistant Rectangular Slimline Shower Tray 1400 x 760mm - White
88279 nuie Slip Resistant Rectangular Slimline Shower Tray 1400 x 800mm - White
88280 nuie Slip Resistant Rectangular Slimline Shower Tray 1400 x 900mm - White
88281 nuie Slip Resistant Rectangular Slimline Shower Tray 1500 x 700mm - White
88282 nuie Slip Resistant Rectangular Slimline Shower Tray 1500 x 760mm - White
88304 nuie Slip Resistant Offset Quadrant Slimline Shower Tray Left Hand 1200 x 900mm - White
88305 nuie Slip Resistant Offset Quadrant Slimline Shower Tray Right Hand 1200 x 900mm - White
88351 nuie Rectangular Slimline Shower Tray 1500 x 800mm - White
88352 nuie Rectangular Slimline Shower Tray 1500 x 900mm - White
88353 nuie Rectangular Slimline Shower Tray 1600 x 700mm - White
88354 nuie Rectangular Slimline Shower Tray 1600 x 760mm - White
88355 nuie Rectangular Slimline Shower Tray 1600 x 800mm - White
88356 nuie Rectangular Slimline Shower Tray 1600 x 900mm - White
88357 nuie Bath Replacement Slimline Shower Tray 1700 x 700mm - White
88358 nuie Rectangular Slimline Shower Tray 1700 x 700mm - White
88359 nuie Rectangular Slimline Shower Tray 1700 x 760mm - White
88360 nuie Rectangular Slimline Shower Tray 1700 x 800mm - White
88361 nuie Rectangular Slimline Shower Tray 1700 x 900mm - White
88362 nuie Rectangular Slimline Shower Tray 1800 x 800mm - White
88363 nuie Rectangular Slimline Shower Tray 1800 x 900mm - White
88383 nuie Rectangular Walk-In Slimline Shower Tray 1400 x 800mm - White
88384 nuie Rectangular Walk-In Slimline Shower Tray 1400 x 900mm - White
89674 nuie Rectangular Slimline Shower Tray 1200 x 900mm - Slate Grey
89675 nuie Rectangular Slimline shower tray 1200 x 1000mm - Slate Grey
89676 nuie Rectangular Slimline Shower Tray 1300 x 800mm - Slate Grey
89677 nuie Rectangular Slimline Shower Tray 1400 x 700mm - Slate Grey
89678 nuie Rectangular Slimline Shower Tray 1400 x 760mm - Slate Grey
89679 nuie Rectangular Slimline Shower Tray 1400 x 800mm - Slate Grey
89680 nuie Rectangular Slimline Shower Tray 1400 x 900mm - Slate Grey
89681 nuie Rectangular Slimline Shower Tray 1500 x 700mm - Slate Grey
89682 nuie Rectangular Slimline Shower Tray 1500 x 760mm - Slate Grey
89683 nuie Rectangular Slimline Shower Tray 1500 x 800mm - Slate Grey
89684 nuie Rectangular Slimline Shower Tray 1500 x 900mm - Slate Grey
89686 nuie Rectangular Slimline Shower Tray 1600 x 760mm - Slate Grey
89696 nuie D Shaped Slimline Shower Tray - Slate Grey