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 (
    97041, 97042, 97043, 97044, 97047, 97048, 
    97049, 97050, 97051, 97052, 97053, 
    97054, 97055, 97056, 97810, 97811, 
    97812, 97813, 97814, 97815, 97816, 
    97817, 97834, 97835, 97836, 97837, 
    97838, 97839, 97840, 97988, 97989, 
    97990, 97991, 97992, 97993, 98030, 
    98031, 98032, 98033, 98034, 98035, 
    98157, 98158, 98159, 98160, 98161, 
    98162, 98163, 98164, 98165, 98166, 
    98167, 98168, 98224, 98225, 98226, 
    98227, 98228, 98234, 98235, 98236, 
    98237, 98238, 98239, 98240, 98241, 
    98242, 98243, 98244, 98245, 98246, 
    98247, 98248, 98249, 98250, 98251, 
    98252, 98253, 98254, 98255, 98256, 
    98257, 98687, 98688, 98689, 98691, 
    98692, 98697, 98698, 98699, 98700, 
    98701, 98738, 98739, 98740, 98741
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00225

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 (97041,97042,97043,97044,97047,97048,97049,97050,97051,97052,97053,97054,97055,97056,97810,97811,97812,97813,97814,97815,97816,97817,97834,97835,97836,97837,97838,97839,97840,97988,97989,97990,97991,97992,97993,98030,98031,98032,98033,98034,98035,98157,98158,98159,98160,98161,98162,98163,98164,98165,98166,98167,98168,98224,98225,98226,98227,98228,98234,98235,98236,98237,98238,98239,98240,98241,98242,98243,98244,98245,98246,98247,98248,98249,98250,98251,98252,98253,98254,98255,98256,98257,98687,98688,98689,98691,98692,98697,98698,98699,98700,98701,98738,98739,98740,98741)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
97041
97042
97043
97044
97047
97048
97049
97050
97051
97052
97053
97054
97055
97056
97810
97811
97812
97813
97814
97815
97816
97817
97834
97835
97836
97837
97838
97839
97840
97988
97989
97990
97991
97992
97993
98030
98031
98032
98033
98034
98035
98157
98158
98159
98160
98161
98162
98163
98164
98165
98166
98167
98168
98224
98225
98226
98227
98228
98234
98235
98236
98237
98238
98239
98240
98241
98242
98243
98244
98245
98246
98247
98248
98249
98250
98251
98252
98253
98254
98255
98256
98257
98687
98688
98689
98691
98692
98697
98698
98699
98700
98701
98738
98739
98740
98741