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 (
    90788, 90790, 90789, 90791, 90784, 90786, 
    90774, 90772, 90785, 90787, 90780, 
    90782, 90775, 87367, 90781, 90783, 
    90773, 90776, 90778, 87366, 87365, 
    90777, 90779, 87354, 90770, 87364, 
    82550, 90768, 87352, 87353, 90771, 
    87358, 87378, 82548, 90769, 87380, 
    87357, 87376, 87377, 90766, 90767, 
    87374, 90150, 90165, 87379, 84073, 
    84081, 82509, 87373, 82508, 90149, 
    90164, 90764, 90765, 90142, 90157, 
    90762, 90763, 90148, 90163, 82531, 
    87369, 84072, 84080, 82541, 90759, 
    90147, 90162, 82440, 87368, 87363, 
    84071, 84079, 84095, 90141, 90156, 
    90297, 90304, 82539, 82530, 84057, 
    84065, 82439, 82549, 87362, 84070, 
    84078, 90758, 90760, 90761, 85973, 
    87361, 87356, 84069, 84077, 82540
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00154

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "43.24"
    },
    "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": 96,
      "rows_produced_per_join": 96,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "33.64",
        "eval_cost": "9.60",
        "prefix_cost": "43.24",
        "data_read_per_join": "366K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_product_descriptions`.`product_id` in (90788,90790,90789,90791,90784,90786,90774,90772,90785,90787,90780,90782,90775,87367,90781,90783,90773,90776,90778,87366,87365,90777,90779,87354,90770,87364,82550,90768,87352,87353,90771,87358,87378,82548,90769,87380,87357,87376,87377,90766,90767,87374,90150,90165,87379,84073,84081,82509,87373,82508,90149,90164,90764,90765,90142,90157,90762,90763,90148,90163,82531,87369,84072,84080,82541,90759,90147,90162,82440,87368,87363,84071,84079,84095,90141,90156,90297,90304,82539,82530,84057,84065,82439,82549,87362,84070,84078,90758,90760,90761,85973,87361,87356,84069,84077,82540)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
82439 Hudson Reed Apex 1200mm Sliding Shower Door - 8mm Glass - Matt Black
82440 Hudson Reed Apex 1400mm Sliding Shower Door - 8mm Glass - Matt Black
82508 nuie Pacific 860mm Single Entry Quadrant Enclosure - 6mm Glass - Polished Chrome
82509 nuie Pacific 860mm Single Entry Quadrant Enclosure - 6mm Glass - Polished Chrome
82530 nuie Pacific 1700mm Double Sliding Door - 6mm Glass - Polished Chrome
82531 nuie Pacific 1700mm Double Sliding Door - 6mm Glass - Polished Chrome
82539 nuie Pacific 1200 x 800mm Offset Quadrant Enclosure - 6mm Glass - Polished Chrome
82540 nuie Pacific 1200 x 900mm Offset Quadrant Enclosure - 6mm Glass - Polished Chrome
82541 nuie Pacific 1200 x 900mm Offset Quadrant Enclosure - 6mm Glass - Polished Chrome
82548 nuie Pacific 1050mm D Shape Enclosure - 6mm Glass - Polished Chrome
82549 Glass Part for D Shaped Enclosure - 6mm Glass
82550 nuie Pacific 1050mm D Shape Enclosure - 6mm Glass - Polished Chrome
84057 Hudson Reed 1400mm Frame Screen with Arms and Feet - 8mm Glass - Matt Black
84065 Hudson Reed Abstract 1400mm Frame Wetroom Screen with Support Bars - 8mm Glass - Matt Black
84069 Hudson Reed 900mm Frame Screen With Ceiling Posts - 8mm Glass - Matt Black
84070 Hudson Reed 1000mm Frame Screen With Ceiling Posts - 8mm Glass - Matt Black
84071 Hudson Reed 1100mm Frame Screen With Ceiling Posts - 8mm Glass - Matt Black
84072 Hudson Reed 1200mm Frame Screen With Ceiling Posts - 8mm Glass - Matt Black
84073 Hudson Reed 1400mm Frame Screen With Ceiling Posts - 8mm Glass - Matt Black
84077 Hudson Reed Abstract 900mm Frame Wetroom Screen with Ceiling Posts - 8mm Glass - Matt Black
84078 Hudson Reed Abstract 1000mm Frame Wetroom Screen with Ceiling Posts - 8mm Glass - Matt Black
84079 Hudson Reed Abstract 1100mm Frame Wetroom Screen with Ceiling Posts - 8mm Glass - Matt Black
84080 Hudson Reed Abstract 1200mm Frame Wetroom Screen with Ceiling Posts - 8mm Glass - Matt Black
84081 Hudson Reed Abstract 1400mm Frame Wetroom Screen with Ceiling Posts - 8mm Glass - Matt Black
84095 Hudson Reed 1400mm Wetroom Screen with Ceiling Posts - 8mm Glass - Matt Black
85973 Hudson Reed 1400mm Wetroom Screen With Ceiling Post - 8mm Glass - Polished Chrome
87352 Hudson Reed Apex 1000mm Quadrant - 8mm Glass - Matt Black
87353 Hudson Reed Apex 1000mm Quadrant Enclosure - 8mm Glass - Polished Chrome
87354 Hudson Reed Apex 1000mm Quadrant Enclosure - 8mm Glass - Polished Chrome
87356 Hudson Reed Apex 1000mm Sliding Door - 8mm Glass - Polished Chrome
87357 Hudson Reed Apex 1000 x 800mm Offset Quadrant Enclosure - 8mm Glass - Polished Chrome
87358 Hudson Reed Apex 1000 x 800mm Offset Quadrant Enclosure - 8mm Glass - Polished Chrome
87361 Hudson Reed Apex 1100mm Sliding Door - 8mm Glass - Polished Chrome
87362 Hudson Reed Apex 1200mm Sliding Door - 8mm Glass - Polished Chrome
87363 Hudson Reed Apex 1200mm Sliding Door - 8mm Glass - Polished Chrome
87364 Hudson Reed Apex 1200 x 800mm Offset Quadrant Enclosure - 8mm Glass - Polished Chrome
87365 Hudson Reed Apex 1200 x 800mm Offset Quadrant Enclosure - 8mm Glass - Polished Chrome
87366 Hudson Reed Apex 1200 x 900mm Offset Quadrant Enclosure - 8mm Glass - Polished Chrome
87367 Hudson Reed Apex 1200 x 900mm Offset Quadrant Enclosure - 8mm Glass - Polished Chrome
87368 Hudson Reed Apex 1400mm Sliding Door - 8mm Glass - Polished Chrome
87369 Hudson Reed Apex 1400mm Sliding Door - 8mm Glass - Polished Chrome
87373 Hudson Reed Apex 800mm Quadrant Enclosure - 8mm Glass - Polished Chrome
87374 Hudson Reed Apex 800mm Quadrant Enclosure - 8mm Glass - Polished Chrome
87376 Hudson Reed Apex 900mm Quadrant - 8mm Glass - Matt Black
87377 Hudson Reed Apex 900mm Quadrant Enclosure - 8mm Glass - Polished Chrome
87378 Hudson Reed Apex 900mm Quadrant Enclosure - 8mm Glass - Polished Chrome
87379 Hudson Reed Apex 900 x 800mm Offset Quadrant Enclosure - 8mm Glass - Polished Chrome
87380 Hudson Reed Apex 900 x 800mm Offset Quadrant Enclosure - 8mm Glass - Polished Chrome
90141 nuie Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen 1850mm x 1200mm x 8mm - Brushed Brass
90142 nuie Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen 1850mm x 1400mm x 8mm - Brushed Brass
90147 Hudson Reed Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen & Support Bar 1950mm x 1000mm x 8mm - Brushed Brass
90148 Hudson Reed Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen & Support Bar 1950mm x 1100mm x 8mm - Brushed Brass
90149 Hudson Reed Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen & Support Bar 1950mm x 1200mm x 8mm - Brushed Brass
90150 Hudson Reed Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen & Support Bar 1950mm x 1400mm x 8mm - Brushed Brass
90156 nuie Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen 1850mm x 1200mm x 8mm - Matt Black
90157 nuie Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen 1850mm x 1400mm x 8mm - Matt Black
90162 Hudson Reed Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen & Support Bar 1950mm x 1000mm x 8mm - Matt Black
90163 Hudson Reed Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen & Support Bar 1950mm x 1100mm x 8mm - Matt Black
90164 Hudson Reed Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen & Support Bar 1950mm x 1200mm x 8mm - Matt Black
90165 Hudson Reed Full Outer Frame Wetroom Screens Full Outer Frame Wetroom 8mm Toughened Safety Glass Screen & Support Bar 1950mm x 1400mm x 8mm - Matt Black
90297 Hudson Reed 1400mm Outer Framed Wetroom Screen with Support Bar - 8mm Glass - Brushed Brass
90304 Hudson Reed 1400mm Outer Framed Wetroom Screen with Support Bar - 8mm Glass - Matt Black
90758 Nuie 800mm Black Quadrant & Tray
90759 Nuie 900mm Black Quadrant & Tray
90760 Nuie 1000x800 Chrome Offset Quad & Tray - Left Hand
90761 Nuie 1000x800 Chrome Offset Quad & Tray - Right Hand
90762 Nuie 1200x800 Chrome Offset Quad & Tray - Left Hand
90763 Nuie 1200x800 Chrome Offset Quad & Tray - Right Hand
90764 Nuie 1000x800 Black Offset Quad & Tray - Left Hand
90765 Nuie 1000x800 Black Offset Quad & Tray - Right Hand
90766 Nuie 1200x800 Black Offset Quad & Tray - Left Hand
90767 Nuie 1200x800 Black Offset Quad & Tray - Right Hand
90768 Nuie 800 Chrome Quadrant Tray & Shower Kit
90769 Nuie 800 Chrome Quadrant Tray & Shower Kit
90770 Nuie 900 Chrome Quadrant Tray & Shower Kit
90771 Nuie 900 Chrome Quadrant Tray & Shower Kit
90772 Nuie 800 Black Quadrant Tray & Shower Kit
90773 Nuie 800 Black Quadrant Tray & Shower Kit
90774 Nuie 900 Black Quadrant Tray & Shower Kit
90775 Nuie 900 Black Quadrant Tray & Shower Kit
90776 Nuie 1000x800 Chrome Offset Quad, Tray & Shower Kit - Left Hand
90777 Nuie 1000x800 Chrome Offset Quad, Tray & Shower Kit - Left Hand
90778 Nuie 1000x800 Chrome Offset Quad, Tray & Shower Kit - Right Hand
90779 Nuie 1000x800 Chrome Offset Quad, Tray & Shower Kit - Right Hand
90780 Nuie 1200x800 Chrome Offset Quad, Tray & Shower Kit - Left Hand
90781 Nuie 1200x800 Chrome Offset Quad, Tray & Shower Kit - Left Hand
90782 Nuie 1200x800 Chrome Offset Quad, Tray & Shower Kit - Right Hand
90783 Nuie 1200x800 Chrome Offset Quad, Tray & Shower Kit - Right Hand
90784 Nuie 1000x800 Black Offset Quad, Tray & Shower Kit - Left Hand
90785 Nuie 1000x800 Black Offset Quad, Tray & Shower Kit - Left Hand
90786 Nuie 1000x800 Black Offset Quad, Tray & Shower Kit - Right Hand
90787 Nuie 1000x800 Black Offset Quad, Tray & Shower Kit - Right Hand
90788 Nuie 1200x800 Black Offset Quad, Tray & Shower Kit - Left Hand
90789 Nuie 1200x800 Black Offset Quad, Tray & Shower Kit - Left Hand
90790 Nuie 1200x800 Black Offset Quad, Tray & Shower Kit - Right Hand
90791 Nuie 1200x800 Black Offset Quad, Tray & Shower Kit - Right Hand