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, 86599, 86600, 
    86668, 86669, 89043, 85133, 85373, 
    86617, 86686, 83039, 90875, 90954, 
    85056, 85142, 85188, 85234, 84673, 
    84674, 85076, 85077, 85162, 85163, 
    85208, 85209, 85254, 85255, 84816, 
    84817, 86493, 86495, 86769, 86771, 
    91144, 83035, 83036, 83307, 83592, 
    83593, 85307, 85309, 85404, 85406, 
    85455, 85457
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00168

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 (83550,83551,83552,83553,86599,86600,86668,86669,89043,85133,85373,86617,86686,83039,90875,90954,85056,85142,85188,85234,84673,84674,85076,85077,85162,85163,85208,85209,85254,85255,84816,84817,86493,86495,86769,86771,91144,83035,83036,83307,83592,83593,85307,85309,85404,85406,85455,85457)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
83035 nuie Arno 600mm Wall Hung 1-Drawer Vanity & Laminate Top - Satin Green
83036 nuie Arno 600mm Wall Hung 1-Drawer Vanity & Laminate Top - Satin Green
83039 nuie Arno 600mm Wall Hung 2-Door Vanity & Mid-Edge Basin - Satin Green
83307 nuie Athena Floor Standing 2 Drawer Vanity With Worktop 600mm - 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
83592 nuie Athena Wall Hung Single Drawer Vanity With Sparkling Black Worktop 600mm - Gloss Grey
83593 nuie Athena Wall Hung Single Drawer Vanity With Sparkling White Worktop 600mm - Gloss Grey
84673 Hudson Reed Fusion Wall Hung 2 Door Vanity Unit & Polymarble Basin 500mm - Gloss Grey
84674 Hudson Reed Fusion Wall Hung 2 Door Vanity Unit & Ceramic Basin 500mm - Gloss Grey
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
85076 Hudson Reed Fluted 600mm Wall Hung Single Drawer Vanity and Laminate Top - Satin Anthracite
85077 Hudson Reed Fluted 600mm Wall Hung Single Drawer Vanity and Laminate Top - Satin Anthracite
85133 Hudson Reed Fluted 800mm Wall Hung Single Drawer Vanity and Worktop - Satin White
85142 Hudson Reed Fluted 500mm Wall Hung Single Drawer Vanity and Thin-Edge Basin - Satin Grey
85162 Hudson Reed Fluted 600mm Wall Hung Single Drawer Vanity and Laminate Top - Satin Grey
85163 Hudson Reed Fluted 600mm Wall Hung Single Drawer Vanity and Laminate Top - Satin Grey
85188 Hudson Reed Fluted 500mm Wall Hung Single Drawer Vanity and Thin-Edge Basin - Satin Blue
85208 Hudson Reed Fluted 600mm Wall Hung Single Drawer Vanity and Laminate Top - Satin Blue
85209 Hudson Reed Fluted 600mm Wall Hung Single Drawer Vanity and Laminate Top - Satin Blue
85234 Hudson Reed Fluted 500mm Wall Hung Single Drawer Vanity and Thin-Edge Basin - Satin Green
85254 Hudson Reed Fluted 600mm Wall Hung Single Drawer Vanity and Laminate Top - Satin Green
85255 Hudson Reed Fluted 600mm Wall Hung Single Drawer Vanity and Laminate Top - 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
85373 nuie Deco 800mm Wall Hung Single Drawer Vanity & Laminate Top - Satin White
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
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
86599 Hudson Reed Juno 500mm Floor Standing 2-Door Vanity & Mid-Edge 1 Tap Hole Basin - Graphite Grey
86600 Hudson Reed Juno 500mm Floor Standing 2-Door Vanity & Minimalist 1 Tap Hole Basin - Graphite Grey
86617 Hudson Reed Juno 600mm Wall Hung Single Drawer Vanity & Mid-Edge 1 Tap Hole Basin - Graphite Grey
86668 Hudson Reed Juno 500mm Floor Standing 2-Door Vanity & Mid-Edge 1 Tap Hole Basin - Coastal Grey
86669 Hudson Reed Juno 500mm Floor Standing 2-Door Vanity & Minimalist 1 Tap Hole Basin - Coastal 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
89043 nuie Mayford Floor Standing 2 Door 1 Drawer Tall Unit 350mm - Gloss White
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