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 (
    92067, 92068, 92069, 92070, 92071, 92072, 
    92073, 92083, 92084, 92085, 92086, 
    92087, 92088, 92089, 84018, 84019, 
    84020, 84021, 83974, 83975, 83976, 
    83977, 92066, 92082, 90073, 89179, 
    86383, 83095, 84101, 93039, 93040, 
    93041, 93042, 93043, 93044, 93045, 
    93046, 94718, 94722, 94727, 94731, 
    94735, 94739, 94743, 94747, 97025, 
    97842, 97846, 97851, 97855, 97859, 
    97863, 97867, 97871, 97911, 97912, 
    97913, 97914, 97943, 97944, 97945, 
    97946, 97968, 98107, 98108, 98109, 
    98110, 98111, 98112, 98113, 98114, 
    98351, 98352, 98353, 98354, 98355, 
    98356, 98357, 98358, 98359, 98360, 
    98361, 98362, 98363, 98364, 98365, 
    98366, 98685, 100145, 100891
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00158

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "40.54"
    },
    "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": 90,
      "rows_produced_per_join": 90,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "31.54",
        "eval_cost": "9.00",
        "prefix_cost": "40.54",
        "data_read_per_join": "343K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_product_descriptions`.`product_id` in (92067,92068,92069,92070,92071,92072,92073,92083,92084,92085,92086,92087,92088,92089,84018,84019,84020,84021,83974,83975,83976,83977,92066,92082,90073,89179,86383,83095,84101,93039,93040,93041,93042,93043,93044,93045,93046,94718,94722,94727,94731,94735,94739,94743,94747,97025,97842,97846,97851,97855,97859,97863,97867,97871,97911,97912,97913,97914,97943,97944,97945,97946,97968,98107,98108,98109,98110,98111,98112,98113,98114,98351,98352,98353,98354,98355,98356,98357,98358,98359,98360,98361,98362,98363,98364,98365,98366,98685,100145,100891)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
83095 nuie Arvan Mono Bidet Mixer With Pop-up Waste - Chrome
83974 Old London White Topaz With Lever Handle Bidet Tap - Chrome
83975 Old London White Topaz With Crosshead Handle Bidet Tap - Chrome
83976 Old London White Topaz With Lever Handle Bidet Tap - Chrome
83977 Old London White Topaz With Crosshead Handle Bidet Tap - Chrome
84018 Old London Black Topaz With Lever Handle Bidet Tap - Chrome
84019 Old London Black Topaz With Crosshead Handle Bidet Tap - Chrome
84020 Old London Black Topaz With Lever Handle Bidet Tap - Chrome
84021 Old London Black Topaz With Crosshead Handle Bidet Tap - Chrome
84101 nuie Binsey Mono Bidet Mixer With Pop-up Waste - Chrome
86383 nuie Beaumont Luxury Mono Bidet Mixer - Chrome
89179 nuie Sanford Mono Bidet Mixer With Pop-up Waste - Chrome
90073 nuie Windon Mono Bidet Mixer With Pop-up Waste - Chrome
92066 BC Designs Victrion Deck Mounted Lever Mono Bidet Mixer Tap - Chrome
92067 BC Designs Victrion Deck Mounted Lever Mono Bidet Mixer Tap - Brushed Chrome
92068 BC Designs Victrion Deck Mounted Lever Mono Bidet Mixer Tap - Brushed Copper
92069 BC Designs Victrion Deck Mounted Lever Mono Bidet Mixer Tap - Brushed Gold
92070 BC Designs Victrion Deck Mounted Lever Mono Bidet Mixer Tap - Brushed Nickel
92071 BC Designs Victrion Deck Mounted Lever Mono Bidet Mixer Tap - Copper
92072 BC Designs Victrion Deck Mounted Lever Mono Bidet Mixer Tap - Gold
92073 BC Designs Victrion Deck Mounted Lever Mono Bidet Mixer Tap - Nickel
92082 BC Designs Victrion Deck Mounted Crosshead Mono Bidet Mixer Tap - Chrome
92083 BC Designs Victrion Deck Mounted Crosshead Mono Bidet Mixer Tap - Brushed Chrome
92084 BC Designs Victrion Deck Mounted Crosshead Mono Bidet Mixer Tap - Brushed Copper
92085 BC Designs Victrion Deck Mounted Crosshead Mono Bidet Mixer Tap - Brushed Gold
92086 BC Designs Victrion Deck Mounted Crosshead Mono Bidet Mixer Tap - Brushed Nickel
92087 BC Designs Victrion Deck Mounted Crosshead Mono Bidet Mixer Tap - Copper
92088 BC Designs Victrion Deck Mounted Crosshead Mono Bidet Mixer Tap - Gold
92089 BC Designs Victrion Deck Mounted Crosshead Mono Bidet Mixer Tap - Nickel
93039
93040
93041
93042
93043
93044
93045
93046
94718
94722
94727
94731
94735
94739
94743
94747
97025
97842
97846
97851
97855
97859
97863
97867
97871
97911
97912
97913
97914
97943
97944
97945
97946
97968
98107
98108
98109
98110
98111
98112
98113
98114
98351
98352
98353
98354
98355
98356
98357
98358
98359
98360
98361
98362
98363
98364
98365
98366
98685
100145
100891