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 (
    86524, 86800, 85124, 85125, 89075, 89076, 
    85360, 86500, 86776, 86147, 86148, 
    86170, 86171, 86663, 86664, 86732, 
    86733, 82819, 82892, 82965, 83073, 
    83626, 90909, 90988, 85083, 85169, 
    85215, 85261, 89074, 85123, 86195, 
    86218, 86527, 86803, 89079, 89080, 
    85320, 85321, 85417, 85418, 85468, 
    85469, 85519, 85520, 86184, 86185, 
    86207, 86208
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00062

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 (86524,86800,85124,85125,89075,89076,85360,86500,86776,86147,86148,86170,86171,86663,86664,86732,86733,82819,82892,82965,83073,83626,90909,90988,85083,85169,85215,85261,89074,85123,86195,86218,86527,86803,89079,89080,85320,85321,85417,85418,85468,85469,85519,85520,86184,86185,86207,86208)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
82819 nuie Arno 1200mm Wall Hung 2-Drawer Vanity & Worktop - Solace Oak
82892 nuie Arno 1200mm Wall Hung 2-Drawer Vanity & Worktop - Anthracite
82965 nuie Arno 1200mm Wall Hung 2-Drawer Vanity & Worktop - Charcoal Black
83073 nuie Arno 800mm Wall Hung 2-Drawer Vanity & Laminate Top - Satin Green
83626 nuie Athena Wall Hung 2 Drawer Vanity With Grey Worktop 800mm - Gloss Grey
85083 Hudson Reed Fluted 800mm Wall Hung 2-Drawer Vanity and Laminate Top - Satin Anthracite
85123 Hudson Reed Fluted 800mm Wall Hung 2-Drawer Vanity and Laminate Top - Satin White
85124 Hudson Reed Fluted 800mm Wall Hung 2-Drawer Vanity and Laminate Top - Satin White
85125 Hudson Reed Fluted 800mm Wall Hung 2-Drawer Vanity and Laminate Top - Satin White
85169 Hudson Reed Fluted 800mm Wall Hung 2-Drawer Vanity and Laminate Top - Satin Grey
85215 Hudson Reed Fluted 800mm Wall Hung 2-Drawer Vanity and Laminate Top - Satin Blue
85261 Hudson Reed Fluted 800mm Wall Hung 2-Drawer Vanity and Laminate Top - Satin Green
85320 nuie Deco 800mm Wall Hung 2-Drawer Vanity & Laminate Top - Satin Anthracite
85321 nuie Deco 800mm Wall Hung 2-Drawer Vanity & Laminate Top - Satin Anthracite
85360 nuie Deco 1200mm Wall Hung 2-Drawer Vanity & Worktop - Satin White
85417 nuie Deco 800mm Wall Hung 2-Drawer Vanity & Laminate Top - Satin Grey
85418 nuie Deco 800mm Wall Hung 2-Drawer Vanity & Laminate Top - Satin Grey
85468 nuie Deco 800mm Wall Hung 2-Drawer Vanity & Laminate Top - Satin Blue
85469 nuie Deco 800mm Wall Hung 2-Drawer Vanity & Laminate Top - Satin Blue
85519 nuie Deco 800mm Wall Hung 2-Drawer Vanity & Laminate Top - Satin Green
85520 nuie Deco 800mm Wall Hung 2-Drawer Vanity & Laminate Top - Satin Green
86147 Hudson Reed Havana Wall Hung 2 Drawer Unit & Laminate Worktop, 800mm - Graphite Grey/Sparkle Black
86148 Hudson Reed Havana Wall Hung 2 Drawer Unit & Laminate Worktop, 800mm - Graphite Grey/Sparkle White
86170 Hudson Reed Havana Wall Hung 2 Drawer Unit & Laminate Worktop, 800mm - Coastal Grey/Sparkle Black
86171 Hudson Reed Havana Wall Hung 2 Drawer Unit & Laminate Worktop, 800mm - Coastal Grey/Sparkle White
86184 Hudson Reed Havana Wall Hung 2 Drawer Unit & Laminate Worktop, 600mm - Metallic Slate/Sparkle Black
86185 Hudson Reed Havana Wall Hung 2 Drawer Unit & Laminate Worktop, 600mm - Metallic Slate/Sparkle White
86195 Hudson Reed Havana Wall Hung 2 Drawer Unit & Colour Match Worktop, 800mm - Metallic Slate
86207 Hudson Reed Havana Wall Hung 2 Drawer Unit & Laminate Worktop, 600mm - Autumn Oak/Sparkle Black
86208 Hudson Reed Havana Wall Hung 2 Drawer Unit & Laminate Worktop, 600mm - Autumn Oak/Sparkle White
86218 Hudson Reed Havana Wall Hung 2 Drawer Unit & Colour Match Worktop, 800mm - Autumn Oak
86500 Hudson Reed Juno 1200mm Wall Hung 4-Door Vanity & Worktop - Autumn Oak
86524 Hudson Reed Juno 800mm Wall Hung 2-Drawer Vanity & Laminate Top - Autumn Oak
86527 Hudson Reed Juno 800mm Wall Hung 2-Drawer Vanity & Worktop - Autumn Oak
86663 Hudson Reed Juno 800mm Wall Hung 2-Drawer Vanity & Laminate Top - Graphite Grey
86664 Hudson Reed Juno 800mm Wall Hung 2-Drawer Vanity & Laminate Top - Graphite Grey
86732 Hudson Reed Juno 800mm Wall Hung 2-Drawer Vanity & Laminate Top - Coastal Grey
86733 Hudson Reed Juno 800mm Wall Hung 2-Drawer Vanity & Laminate Top - Coastal Grey
86776 Hudson Reed Juno Wall Hung 4 Door Vanity Unit & Colour Match Worktop, 1200mm - Metallic Slate
86800 Hudson Reed Juno Wall Hung 2 Drawer Vanity Unit & Laminate Worktop, 800mm - Metallic Slate/Bellato Grey
86803 Hudson Reed Juno Wall Hung 2 Drawer Vanity Unit & Colour Match Worktop, 800mm - Metallic Slate
89074 Hudson Reed Quartet Wall Hung 2 Drawer Cabinet with Grey Worktop 720mm - Gloss Grey
89075 Hudson Reed Quartet Wall Hung 2 Drawer Cabinet with Sparkling Black Worktop 720mm - Gloss Grey
89076 Hudson Reed Quartet Wall Hung 2 Drawer Cabinet with Sparkling White Worktop 720mm - Gloss Grey
89079 Hudson Reed Quartet Wall Hung 2 Drawer Cabinet with Sparkling Black Worktop 720mm - Hacienda Black
89080 Hudson Reed Quartet Wall Hung 2 Drawer Cabinet with Sparkling White Worktop 720mm - Hacienda Black
90909 nuie Arno Wall Hung 2 Drawer Vanity & Laminate Worktop, 800mm - Satin Anthracite/Bellato Grey
90988 nuie Arno Wall Hung 2 Drawer Vanity & Laminate Worktop, 800mm - Satin Grey/Bellato Grey