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 (
    87656, 87670, 87677, 87684, 87705, 87716, 
    87717, 87730, 87731, 90022, 90024, 
    90038, 90040, 90041, 87654, 87655, 
    87668, 87669, 87675, 87676, 87682, 
    87683, 87703, 87704, 87713, 87715, 
    87727, 87729, 88692, 88693, 88739, 
    88740, 90023, 90039, 90055, 87581, 
    87596, 87611, 88150, 88152, 88792, 
    87657, 87671, 87678, 87685, 87706, 
    87719, 87733, 88696, 88743, 88146, 
    88589, 84244, 84243, 88585, 84242, 
    88584, 88907, 88908, 88905, 88906, 
    88910, 88909, 92913, 92914, 92915, 
    92916, 92917, 92918, 92919, 92920, 
    92921, 93753, 93754, 93755, 93756, 
    93757, 93758, 93759, 93760, 93761, 
    93762, 93763, 93764, 93765, 93766, 
    93767, 93768, 93769, 93770, 93771, 
    93772, 93773, 93774, 93775, 93776
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00155

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 (87656,87670,87677,87684,87705,87716,87717,87730,87731,90022,90024,90038,90040,90041,87654,87655,87668,87669,87675,87676,87682,87683,87703,87704,87713,87715,87727,87729,88692,88693,88739,88740,90023,90039,90055,87581,87596,87611,88150,88152,88792,87657,87671,87678,87685,87706,87719,87733,88696,88743,88146,88589,84244,84243,88585,84242,88584,88907,88908,88905,88906,88910,88909,92913,92914,92915,92916,92917,92918,92919,92920,92921,93753,93754,93755,93756,93757,93758,93759,93760,93761,93762,93763,93764,93765,93766,93767,93768,93769,93770,93771,93772,93773,93774,93775,93776)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
84242 nuie Athena Straight End Panel & Plinth 700mm - White
84243 nuie Athena Straight End Panel & Plinth 750mm - White
84244 Athena End Panel & Plinth 800mm - Gloss White
87581 Hudson Reed Urban L-Shape Square Shower Bath End Panel 700mm - Satin White
87596 Hudson Reed Urban L-Shape Square Shower Bath End Panel 700mm - Satin Grey
87611 Hudson Reed Urban L-Shape Square Shower Bath End Panel 700mm - Satin Blue
87654 Hudson Reed 700mm Straight Bath End Panel & Plinth - Autumn Oak
87655 Hudson Reed 750mm Straight Bath End Panel & Plinth - Autumn Oak
87656 Hudson Reed 800mm Straight Bath End Panel & Plinth - Autumn Oak
87657 Hudson Reed 700mm L Shape Square Shower Bath End Panel - Autumn Oak
87668 Hudson Reed 700mm Straight Bath End Panel & Plinth - Graphite Grey
87669 Hudson Reed 750mm Straight Bath End Panel & Plinth - Graphite Grey
87670 Hudson Reed 800mm Straight Bath End Panel & Plinth - Graphite Grey
87671 Hudson Reed 700mm L Shape Square Shower Bath End Panel - Graphite Grey
87675 Hudson Reed 700mm Straight Bath End Panel & Plinth - Coastal Grey
87676 Hudson Reed 750mm Straight Bath End Panel & Plinth - Coastal Grey
87677 Hudson Reed 800mm Straight Bath End Panel & Plinth - Coastal Grey
87678 Hudson Reed 700mm L Shape Square Shower Bath End Panel - Coastal Grey
87682 Hudson Reed Havana Straight Shower Bath End Panel & Plinth, 700mm - Metallic Slate
87683 Hudson Reed Havana Straight Shower Bath End Panel & Plinth, 750mm - Metallic Slate
87684 Hudson Reed Havana Straight Shower Bath End Panel & Plinth, 800mm - Metallic Slate
87685 Hudson Reed Havana Square L Shape Shower Bath End Panel & Plinth, 700mm - Metallic Slate
87703 nuie 700mm Straight End Panel & Plinth - Solace Oak Woodgrain
87704 nuie 750mm Straight End Panel & Plinth - Solace Oak Woodgrain
87705 nuie 800mm Straight End Panel & Plinth - Solace Oak Woodgrain
87706 nuie 700mm L Shape Square Shower Bath End Panel - Solace Oak Woodgrain
87713 nuie 700mm Straight End Panel & Plinth - Anthracite Woodgrain
87715 nuie 750mm Straight End Panel & Plinth - Anthracite Woodgrain
87716 Hudson Reed Fusion Bath End Panel 800mm - Anthracite Woodgrain
87717 nuie 800mm Straight End Panel & Plinth - Anthracite Woodgrain
87719 nuie 700mm L Shape Square Shower Bath End Panel - Anthracite Woodgrain
87727 nuie 700mm Straight End Panel & Plinth - Charcoal Black Woodgrain
87729 nuie 750mm Straight End Panel & Plinth - Charcoal Black Woodgrain
87730 Hudson Reed Fusion Bath End Panel 800mm - Hacienda Black
87731 nuie 800mm Straight End Panel & Plinth - Charcoal Black Woodgrain
87733 nuie 700mm L Shape Square Shower Bath End Panel - Charcoal Black Woodgrain
88146 nuie Athena Shower Bath End Panel 700mm - Gloss White
88150 Hudson Reed 700mm L Shape Square Shower Bath End Panel - Satin Anthracite
88152 Hudson Reed 700mm L Shape Square Shower Bath End Panel - Satin Green
88584 Hudson Reed Fusion Bath End Panel & Plinth 700mm - Gloss White
88585 Hudson Reed Fusion Bath End Panel & Plinth 750mm - Gloss White
88589 Hudson Reed Fusion Shower Bath End Panel 700mm - Gloss White
88692 Hudson Reed Fusion Bath End Panel & Plinth 700mm - Anthracite Woodgrain
88693 Hudson Reed Fusion Bath End Panel & Plinth 750mm - Anthracite Woodgrain
88696 Hudson Reed Fusion Shower Bath End Panel 700mm - Anthracite Woodgrain
88739 Hudson Reed Fusion Bath End Panel & Plinth 700mm - Hacienda Black
88740 Hudson Reed Fusion Bath End Panel & Plinth 750mm - Hacienda Black
88743 Hudson Reed Fusion Shower Bath End Panel 700mm - Hacienda Black
88792 Hudson Reed Fusion Bath End Panel & Plinth 700mm - Gloss Grey
88905 nuie Bath Panels Acrylic Front Panel 1500mm - White
88906 nuie Bath Panels Acrylic Front Panel 1600mm - White
88907 nuie Bath Panels Acrylic Front Panel 1700mm - White
88908 nuie Bath Panels Acrylic Front Panel 1800mm - White
88909 nuie Bath Panels Acrylic End Panel 700mm - White
88910 nuie Bath Panels Acrylic End Panel 800mm - White
90022 nuie Bath Panels B-Shape Shower Bath Front Panel 1700mm - White
90023 nuie Bath Panels B-Shape Shower Bath End Panel 750mm - White
90024 nuie Bath Panels B-Shape Shower Bath Front Panel 1500mm - White
90038 nuie Bath Panels P-Shape Shower Bath Front Panel 1700mm - White
90039 nuie Bath Panels P-Shape Shower Bath End Panel 700mm - White
90040 nuie Bath Panels P-Shape Shower Bath Front Panel 1500mm - White
90041 nuie Bath Panels P-Shape Shower Bath Front Panel 1600mm - White
90055 nuie Bath Panels L-Shape Shower Bath End Panel 700mm - White
92913
92914
92915
92916
92917
92918
92919
92920
92921
93753
93754
93755
93756
93757
93758
93759
93760
93761
93762
93763
93764
93765
93766
93767
93768
93769
93770
93771
93772
93773
93774
93775
93776