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 (
    96688, 96689, 96690, 96691, 96692, 96694, 
    96695, 96696, 96697, 96708, 96718, 
    96719, 96720, 96724, 96734, 96735, 
    96738, 96739, 96743, 96746, 96747, 
    96749, 96751, 96758, 96759, 96764, 
    96775, 96778, 96779, 96780, 96789, 
    96790, 96791, 96839, 96840, 96841, 
    96918, 96919, 96985, 96986, 96987, 
    96988, 96989, 96990, 96991, 96992, 
    96993, 96994
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00132

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "26.88"
    },
    "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": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "22.08",
        "eval_cost": "4.80",
        "prefix_cost": "26.88",
        "data_read_per_join": "183K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_product_descriptions`.`product_id` in (96688,96689,96690,96691,96692,96694,96695,96696,96697,96708,96718,96719,96720,96724,96734,96735,96738,96739,96743,96746,96747,96749,96751,96758,96759,96764,96775,96778,96779,96780,96789,96790,96791,96839,96840,96841,96918,96919,96985,96986,96987,96988,96989,96990,96991,96992,96993,96994)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
96688
96689
96690
96691
96692
96694
96695
96696
96697
96708
96718
96719
96720
96724
96734
96735
96738
96739
96743
96746
96747
96749
96751
96758
96759
96764
96775
96778
96779
96780
96789
96790
96791
96839
96840
96841
96918
96919
96985
96986
96987
96988
96989
96990
96991
96992
96993
96994