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 (
    96064, 96065, 96066, 96067, 96068, 96069, 
    96070, 96071, 96072, 96073, 96074, 
    96075, 96076, 96077, 96078, 96079, 
    96080, 96081, 96082, 96083, 96084, 
    96085, 96086, 96087, 96088, 96089, 
    96090, 96091, 96092, 96093, 96094, 
    96095, 96096, 96097, 96098, 96099, 
    96100, 96101, 96102, 96103, 96104, 
    96383, 96384, 96385, 96386, 96387, 
    96388, 96389, 96390, 96391, 96394, 
    96395, 96396, 96397, 96398, 96399, 
    96400, 96409, 96410, 96429, 96432, 
    96433, 96442, 96443, 96444, 96445, 
    96446, 96447, 96448, 96449, 96450, 
    96451, 96452, 96453, 96454, 96455, 
    96456, 96457, 96458, 96459, 96460, 
    96461, 96462, 96463, 96464, 96465, 
    96466, 96467, 96468, 96469, 96470, 
    96471, 96472, 96473, 96474, 98600
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00159

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 (96064,96065,96066,96067,96068,96069,96070,96071,96072,96073,96074,96075,96076,96077,96078,96079,96080,96081,96082,96083,96084,96085,96086,96087,96088,96089,96090,96091,96092,96093,96094,96095,96096,96097,96098,96099,96100,96101,96102,96103,96104,96383,96384,96385,96386,96387,96388,96389,96390,96391,96394,96395,96396,96397,96398,96399,96400,96409,96410,96429,96432,96433,96442,96443,96444,96445,96446,96447,96448,96449,96450,96451,96452,96453,96454,96455,96456,96457,96458,96459,96460,96461,96462,96463,96464,96465,96466,96467,96468,96469,96470,96471,96472,96473,96474,98600)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
96064
96065
96066
96067
96068
96069
96070
96071
96072
96073
96074
96075
96076
96077
96078
96079
96080
96081
96082
96083
96084
96085
96086
96087
96088
96089
96090
96091
96092
96093
96094
96095
96096
96097
96098
96099
96100
96101
96102
96103
96104
96383
96384
96385
96386
96387
96388
96389
96390
96391
96394
96395
96396
96397
96398
96399
96400
96409
96410
96429
96432
96433
96442
96443
96444
96445
96446
96447
96448
96449
96450
96451
96452
96453
96454
96455
96456
96457
96458
96459
96460
96461
96462
96463
96464
96465
96466
96467
96468
96469
96470
96471
96472
96473
96474
98600