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 (
    83550, 83551, 83552, 83553, 86617, 86686, 
    83039, 90875, 90954, 85056, 85142, 
    85188, 85234, 84816, 84817, 86493, 
    86495, 86769, 86771, 91144, 85307, 
    85309, 85404, 85406, 85455, 85457, 
    85506, 85508, 82624, 83489
  ) 
  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 (83550,83551,83552,83553,86617,86686,83039,90875,90954,85056,85142,85188,85234,84816,84817,86493,86495,86769,86771,91144,85307,85309,85404,85406,85455,85457,85506,85508,82624,83489)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
82624 nuie Arno 800mm Wall Hung 1-Drawer Vanity & Minimalist Basin - Gloss White
83039 nuie Arno 600mm Wall Hung 2-Door Vanity & Mid-Edge Basin - Satin Green
83489 nuie Athena Wall Hung Single Drawer Vanity With Minimalist 1 Tap Hole Ceramic Basin 800mm - Gloss White
83550 nuie Athena Wall Hung 1 Drawer Vanity with Ceramic Mid-Edge Basin and Handle 500mm - Gloss Grey/Matt Black
83551 nuie Athena Wall Hung 1 Drawer Vanity with Ceramic Mid-Edge Basin and Handle 500mm - Gloss Grey/Brushed Brass
83552 nuie Athena Wall Hung 1 Drawer Vanity with Ceramic Mid-Edge Basin and Handle 500mm - Gloss Grey/Matt Black
83553 nuie Athena Wall Hung 1 Drawer Vanity with Ceramic Mid-Edge Basin and Handle 500mm - Gloss Grey/Chrome
84816 nuie Classique Wall Hung 1 Drawer Vanity Basin Unit & 1 Tap Hole Fireclay Basin, 500mm - Satin White
84817 nuie Classique Wall Hung 1 Drawer Vanity Basin Unit & 3 Tap Hole Fireclay Basin, 500mm - Satin White
85056 Hudson Reed Fluted 500mm Wall Hung Single Drawer Vanity and Thin-Edge Basin - Satin Anthracite
85142 Hudson Reed Fluted 500mm Wall Hung Single Drawer Vanity and Thin-Edge Basin - Satin Grey
85188 Hudson Reed Fluted 500mm Wall Hung Single Drawer Vanity and Thin-Edge Basin - Satin Blue
85234 Hudson Reed Fluted 500mm Wall Hung Single Drawer Vanity and Thin-Edge Basin - Satin Green
85307 nuie Deco 600mm Wall Hung Single Drawer Vanity & Thin-Edge Basin - Satin Anthracite
85309 nuie Deco 600mm Wall Hung Single Drawer Vanity & Curved Basin - Satin Anthracite
85404 nuie Deco 600mm Wall Hung Single Drawer Vanity & Thin-Edge Basin - Satin Grey
85406 nuie Deco 600mm Wall Hung Single Drawer Vanity & Curved Basin - Satin Grey
85455 nuie Deco 600mm Wall Hung Single Drawer Vanity & Thin-Edge Basin - Satin Blue
85457 nuie Deco 600mm Wall Hung Single Drawer Vanity & Curved Basin - Satin Blue
85506 nuie Deco 600mm Wall Hung Single Drawer Vanity & Thin-Edge Basin - Satin Green
85508 nuie Deco 600mm Wall Hung Single Drawer Vanity & Curved Basin - Satin Green
86493 Hudson Reed Juno 600mm Wall Hung 2-Door Vanity & Thin-Edge 1 Tap Hole Basin - Autumn Oak
86495 Hudson Reed Juno 600mm Wall Hung 2-Door Vanity & Curved 1 Tap Hole Basin - Autumn Oak
86617 Hudson Reed Juno 600mm Wall Hung Single Drawer Vanity & Mid-Edge 1 Tap Hole Basin - Graphite Grey
86686 Hudson Reed Juno 600mm Wall Hung Single Drawer Vanity & Mid-Edge 1 Tap Hole Basin - Coastal Grey
86769 Hudson Reed Juno Wall Hung 2 Door Vanity Basin Unit & Thin-Edge Ceramic Basin, 600mm - Metallic Slate
86771 Hudson Reed Juno Wall Hung 2 Door Vanity Basin Unit & Curved Ceramic Basin, 600mm - Metallic Slate
90875 nuie Arno Wall Hung 2 Door Vanity & Mid-Edge Ceramic Basin, 600mm - Satin Anthracite
90954 nuie Arno Wall Hung 2 Door Vanity & Mid-Edge Ceramic Basin, 600mm - Satin Grey
91144 nuie Classique Wall Hung 1 Drawer Unit & 0 Tap Hole Fireclay Basin, 500mm - Satin White