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 (
    92557, 91938, 91937, 91939, 91940, 91941, 
    91942, 91943, 82403, 82410, 82424, 
    82362, 82360, 82404, 82342, 82367, 
    82338, 82337, 89595, 89596, 89597, 
    82336, 91936, 86810, 82375, 89590, 
    89589, 86806, 86809, 94023, 94696, 
    94697, 96295, 96298, 96708, 96718, 
    96719, 96720, 96724, 96734, 96735, 
    96738, 96743, 96758, 96759, 96764, 
    96775, 97820, 97821, 98258, 98259, 
    98260, 98261, 98262, 98263, 98264, 
    98265, 98690, 98693, 98694, 100374, 
    100375, 100380, 100381, 100382, 100383, 
    100598, 100601, 101635, 101636, 101639, 
    101640, 101644, 101645, 101646, 101647, 
    101648, 101649, 101650, 101651, 101652, 
    101653
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00085

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "36.94"
    },
    "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": 82,
      "rows_produced_per_join": 82,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "28.74",
        "eval_cost": "8.20",
        "prefix_cost": "36.94",
        "data_read_per_join": "312K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_product_descriptions`.`product_id` in (92557,91938,91937,91939,91940,91941,91942,91943,82403,82410,82424,82362,82360,82404,82342,82367,82338,82337,89595,89596,89597,82336,91936,86810,82375,89590,89589,86806,86809,94023,94696,94697,96295,96298,96708,96718,96719,96720,96724,96734,96735,96738,96743,96758,96759,96764,96775,97820,97821,98258,98259,98260,98261,98262,98263,98264,98265,98690,98693,98694,100374,100375,100380,100381,100382,100383,100598,100601,101635,101636,101639,101640,101644,101645,101646,101647,101648,101649,101650,101651,101652,101653)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
82336 nuie Shower Kits Slide Rail Kit - Chrome
82337 nuie Slimline Slide Rail Kit - Chrome
82338 Hudson Reed Slide Rail Kits Linear Slide Rail Kits - Chrome
82342 Hudson Reed Slide Rail Kits Water Saving Slide Rail Kit - Chrome
82360 nuie Showers Rail Kits Slide Rail Kit - Gunmetal
82362 Hudson Reed Slide Rail Kits Kubix Slide Rail Kit - Chrome
82367 nuie Shower Kits Slider Rail Kit - Chrome
82375 nuie Shower Kits Luxury Slide Rail Kit - Chrome
82403 nuie Shower Kits Slide Rail Kit - Matt Black
82404 Hudson Reed Slide Rail Kits Slider Rail Kit - Chrome / Black
82410 nuie Shower Kits Square Slider Rail Kit with Elbow - Gunmetal
82424 nuie Shower Kits Slide Rail Kit - Brushed Brass
86806 nuie Shower Kits Slide Rail Kit - Chrome
86809 nuie Shower Kits Slide Rail Kit - Chrome
86810 nuie Shower Kits Slide Rail Kit - Chrome
89589 nuie Shower Kits Slide Rail Kit - Chrome
89590 nuie Slide Rail Kit - Chrome
89595 nuie Shower Kits Slide Rail Kit - Matt Black
89596 nuie Shower Kits Round Slider Rail Kit with Elbow - Gunmetal
89597 nuie Shower Kits Slide Rail Kit - Brushed Brass
91936 BC Designs Victrion Traditional Slide Rail Kit and Handset - Chrome
91937 BC Designs Victrion Traditional Slide Rail Kit and Handset - Brushed Chrome
91938 BC Designs Victrion Traditional Slide Rail Kit and Handset - Brushed Copper
91939 BC Designs Victrion Traditional Slide Rail Kit and Handset - Brushed Gold
91940 BC Designs Victrion Traditional Slide Rail Kit and Handset - Brushed Nickel
91941 BC Designs Victrion Traditional Slide Rail Kit and Handset - Copper
91942 BC Designs Victrion Traditional Slide Rail Kit and Handset - Gold
91943 BC Designs Victrion Traditional Slide Rail Kit and Handset - Nickel
92557
94023
94696
94697
96295
96298
96708
96718
96719
96720
96724
96734
96735
96738
96743
96758
96759
96764
96775
97820
97821
98258
98259
98260
98261
98262
98263
98264
98265
98690
98693
98694
100374
100375
100380
100381
100382
100383
100598
100601
101635
101636
101639
101640
101644
101645
101646
101647
101648
101649
101650
101651
101652
101653