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 (
    83883, 91764, 91580, 91581, 91582, 91583, 
    91584, 91585, 91586, 91587, 91588, 
    91589, 83877, 83880, 83889, 83890, 
    83893, 83895, 83884, 83886, 91627, 
    83891, 83892, 83896, 91700, 91701, 
    91702, 91703, 91704, 91705, 91706, 
    91707, 91571, 91572, 91573, 91574, 
    91575, 91576, 91577, 91578, 91579, 
    91610, 91611, 91612, 91613, 91614, 
    91615, 91616, 91617, 91618, 83879, 
    83881, 83887, 91787, 91796, 91797, 
    91798, 91799, 91800, 91801, 91802, 
    91803, 87870, 83894, 91622, 91698, 
    83885, 83888, 91626, 87867, 87868, 
    87869, 91620, 91540, 91541, 91542, 
    91543, 91544, 91545, 91546, 91547, 
    91548, 91549, 91624, 91804, 91805, 
    91806, 91807, 91808, 91809, 91810, 
    91811, 91621, 91601, 91602, 91603
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00080

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 (83883,91764,91580,91581,91582,91583,91584,91585,91586,91587,91588,91589,83877,83880,83889,83890,83893,83895,83884,83886,91627,83891,83892,83896,91700,91701,91702,91703,91704,91705,91706,91707,91571,91572,91573,91574,91575,91576,91577,91578,91579,91610,91611,91612,91613,91614,91615,91616,91617,91618,83879,83881,83887,91787,91796,91797,91798,91799,91800,91801,91802,91803,87870,83894,91622,91698,83885,83888,91626,87867,87868,87869,91620,91540,91541,91542,91543,91544,91545,91546,91547,91548,91549,91624,91804,91805,91806,91807,91808,91809,91810,91811,91621,91601,91602,91603)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
83877 BC Designs Copper Baths Freestanding Boat Bath - Copper Outer/Nickel Inner - 1700mm - Copper/Nickel
83879 BC Designs Copper Baths Freestanding Boat Bath - Copper Outer/Nickel Inner - 1500mm - Copper/Nickel
83880 BC Designs Copper Baths Freestanding Antique Copper Boat Bath - Nickel Inner - 1700mm - Antique Copper/Nickel
83881 BC Designs Copper Baths Freestanding Antique Copper Boat Bath - Nickel Inner - 1500mm - Antique Copper/Nickel
83883 <p>BC Designs Copper Baths Freestanding Boat Bath - Nickel Inner/Outer - 1700mm - Nickel</p>
83884 BC Designs Copper Baths Freestanding Boat Bath - Copper Inner/Verdigris Green Outer - 1700mm - Copper/Verdigris Green
83885 BC Designs Copper Baths Freestanding Boat Bath - Copper Inner/Verdigris Green Outer - 1500mm - Copper/Verdigris Green
83886 BC Designs Copper Baths Freestanding Boat Bath - Copper Inner/Patinata Blue Outer - 1700mm - Copper/Patinata Blue
83887 BC Designs Copper Baths Freestanding Boat Bath - Nickel Inner - Paint -1500mm - Nickel
83888 BC Designs Copper Baths Freestanding Boat Bath - Copper Inner/Patinata Blue Outer - 1500mm - Copper/Patinata
83889 BC Designs Copper Baths Freestanding Boat Bath - Tin Outer/Tin Inner - 1700mm - Tin
83890 BC Designs Copper Baths Freestanding Boat Bath - Brass Outer/Brass Inner - 1700mm - Brass
83891 BC Designs Copper Baths Freestanding Boat Bath - Tin Outer/Tin Inner - 1500mm - Tin
83892 BC Designs Copper Baths Freestanding Boat Bath - Brass Outer/Brass Inner - 1500mm - Brass
83893 BC Designs Copper Baths Freestanding Boat Bath - Copper Outer/Copper Inner - 1700mm - Copper
83894 BC Designs Copper Baths Freestanding Boat Bath - Copper Outer/Copper Inner - 1500mm - Copper
83895 BC Designs Copper Baths Freestanding Boat Bath Antique Outer/Inner - 1700mm - Antique Copper
83896 BC Designs Copper Baths Freestanding Boat Bath Antique Outer/Inner - 1500mm - Antique Copper
87867 <p>Hudson Reed Grace Round Freestanding Bath & Push Button Waste</p>
87868 Hudson Reed Rose Oval Freestanding Bath & Push Button Waste
87869 Hudson Reed Bella Square Freestanding Bath & Push Button Waste
87870 Old London Farringdon Double Ended Freestanding Bath & Push Button Waste -
91540 BC Designs Kurv Freestanding Curved Freestanding Bath 1890mm x 900mm - No Waste - Gloss White
91541 BC Designs Kurv Freestanding Curved Freestanding Bath 1890mm x 900mm - No Waste - Powder Blue
91542 BC Designs Kurv Freestanding Curved Freestanding Bath 1890mm x 900mm - No Waste - Light Fawn
91543 BC Designs Kurv Freestanding Curved Freestanding Bath 1890mm x 900mm - No Waste - Gunmetal
91544 BC Designs Kurv Freestanding Curved Freestanding Bath 1890mm x 900mm - No Waste - Industrial Grey
91545 BC Designs Kurv Freestanding Curved Freestanding Bath 1890mm x 900mm - No Waste - Khaki Green
91546 BC Designs Kurv Freestanding Curved Freestanding Bath 1890mm x 900mm - No Waste - Mushroom
91547 BC Designs Kurv Freestanding Curved Freestanding Bath 1890mm x 900mm - No Waste - Powder Grey
91548 BC Designs Kurv Freestanding Curved Freestanding Bath 1890mm x 900mm - No Waste - Satin Rose
91549 BC Designs Kurv Freestanding Curved Freestanding Bath 1890mm x 900mm - No Waste - Matt White
91571 BC Designs Magnus Square Freestanding Bath with Plinth and Overflow 1680mm x 750mm - No Waste - Gloss White
91572 BC Designs Magnus Square Freestanding Bath with Plinth and Overflow 1680mm x 750mm - No Waste - Powder Blue
91573 BC Designs Magnus Square Freestanding Bath with Plinth and Overflow 1680mm x 750mm - No Waste - Light Fawn
91574 BC Designs Magnus Square Freestanding Bath with Plinth and Overflow 1680mm x 750mm - No Waste - Gunmetal
91575 BC Designs Magnus Square Freestanding Bath with Plinth and Overflow 1680mm x 750mm - No Waste - Industrial Grey
91576 BC Designs Magnus Square Freestanding Bath with Plinth and Overflow 1680mm x 750mm - No Waste - Khaki Green
91577 BC Designs Magnus Square Freestanding Bath with Plinth and Overflow 1680mm x 750mm - No Waste - Mushroom
91578 BC Designs Magnus Square Freestanding Bath with Plinth and Overflow 1680mm x 750mm - No Waste - Powder Grey
91579 BC Designs Magnus Square Freestanding Bath with Plinth and Overflow 1680mm x 750mm - No Waste - Satin Rose
91580 BC Designs Aurelius Oval Freestanding Bath with Overflow 1740mm x 760mm - No Waste - Polished White
91581 BC Designs Aurelius Oval Freestanding Bath with Overflow 1740mm x 760mm - No Waste - Powder Blue
91582 BC Designs Aurelius Oval Freestanding Bath with Overflow 1740mm x 760mm - No Waste - Light Fawn
91583 BC Designs Aurelius Oval Freestanding Bath with Overflow 1740mm x 760mm - No Waste - Gunmetal
91584 BC Designs Aurelius Oval Freestanding Bath with Overflow 1740mm x 760mm - No Waste - Industrial Grey
91585 BC Designs Aurelius Oval Freestanding Bath with Overflow 1740mm x 760mm - No Waste - Khaki Green
91586 BC Designs Aurelius Oval Freestanding Bath with Overflow 1740mm x 760mm - No Waste - Mushroom
91587 BC Designs Aurelius Oval Freestanding Bath with Overflow 1740mm x 760mm - No Waste - Matt White
91588 BC Designs Aurelius Oval Freestanding Bath with Overflow 1740mm x 760mm - No Waste - Powder Grey
91589 BC Designs Aurelius Oval Freestanding Bath with Overflow 1740mm x 760mm - No Waste - Satin Rose
91601 BC Designs Casini Round Scalloped Freestanding Bath 1680mm x 750mm - No Waste - Polished/Matt White
91602 BC Designs Casini Round Scalloped Freestanding Bath 1680mm x 750mm - No Waste - Powder Blue
91603 BC Designs Casini Round Scalloped Freestanding Bath 1680mm x 750mm - No Waste - Light Fawn
91610 BC Designs Senator Curved Square Freestanding Bath 1804mm x 850mm - No Waste - Gloss White
91611 BC Designs Senator Curved Square Freestanding Bath 1804mm x 850mm - No Waste - Powder Blue
91612 BC Designs Senator Curved Square Freestanding Bath 1804mm x 850mm - No Waste - Light Fawn
91613 BC Designs Senator Curved Square Freestanding Bath 1804mm x 850mm - No Waste - Gunmetal
91614 BC Designs Senator Curved Square Freestanding Bath 1804mm x 850mm - No Waste - Industrial Grey
91615 BC Designs Senator Curved Square Freestanding Bath 1804mm x 850mm - No Waste - Khaki Green
91616 BC Designs Senator Curved Square Freestanding Bath 1804mm x 850mm - No Waste - Mushroom
91617 BC Designs Senator Curved Square Freestanding Bath 1804mm x 850mm - No Waste - Powder Grey
91618 BC Designs Senator Curved Square Freestanding Bath 1804mm x 850mm - No Waste - Satin Rose
91620 BC Designs Portman Bath Freestanding 1640 x 750 x 500 - Matt White
91621 BC Designs Cian Freestanding Slipper 1600mm - Matt White
91622 BC Designs Cian Freestanding Slipper 1600mm - Polished White
91624 BC Designs Verdicio Freestanding Bath 1680mm - Polished White
91626 BC Designs Wivenhoe Freestanding Bath - 1800mm - Polished White
91627 BC Designs Aston Freestanding Bath - 1720mm - Polished White
91698 BC Designs Essex Round Freestanding Bath with Leg Stand 1510mm x 760mm - No Waste - Matt White
91700 BC Designs Essex Round Freestanding Bath with Leg Stand 1510mm x 760mm - No Waste - Powder Blue
91701 BC Designs Essex Round Freestanding Bath with Leg Stand 1510mm x 760mm - No Waste - Light Fawn
91702 BC Designs Essex Round Freestanding Bath with Leg Stand 1510mm x 760mm - No Waste - Gunmetal
91703 BC Designs Essex Round Freestanding Bath with Leg Stand 1510mm x 760mm - No Waste - Industrial Grey
91704 BC Designs Essex Round Freestanding Bath with Leg Stand 1510mm x 760mm - No Waste - Khaki Green
91705 BC Designs Essex Round Freestanding Bath with Leg Stand 1510mm x 760mm - No Waste - Mushroom
91706 BC Designs Essex Round Freestanding Bath with Leg Stand 1510mm x 760mm - No Waste - Powder Grey
91707 BC Designs Essex Round Freestanding Bath with Leg Stand 1510mm x 760mm - No Waste - Satin Rose
91764 BC Designs 1700mm Slipper Bath - Copper Outer/Nickel Inner
91787 BC Designs Kurv Bath 1890 x 900 (No Waste) - Marble
91796 BC Designs Portman Bath 1640 x 750 x 500 - Powder Blue
91797 BC Designs Portman Bath 1640 x 750 x 500 - Light Fawn
91798 BC Designs Portman Bath 1640 x 750 x 500 - Gunmetal
91799 BC Designs Portman Bath 1640 x 750 x 500 - Industrial Grey
91800 BC Designs Portman Bath 1640 x 750 x 500 - Khaki Green
91801 BC Designs Portman Bath 1640 x 750 x 500 - Mushroom
91802 BC Designs Portman Bath 1640 x 750 x 500 - Powder Grey
91803 BC Designs Portman Bath 1640 x 750 x 500 - Satin Rose
91804 BC Designs Verdicio Bath 1680 x 700 - Powder Blue
91805 BC Designs Verdicio Bath 1680 x 700 - Light Fawn
91806 BC Designs Verdicio Bath 1680 x 700 - Gunmetal
91807 BC Designs Verdicio Bath 1680 x 700 - Industrial Grey
91808 BC Designs Verdicio Bath 1680 x 700 - Khaki Green
91809 BC Designs Verdicio Bath 1680 x 700 - Mushroom
91810 BC Designs Verdicio Bath 1680 x 700 - Powder Grey
91811 BC Designs Verdicio Bath 1680 x 700 - Satin Rose