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 (
    93353, 93354, 93355, 93750, 93751, 93752, 
    93794, 93848, 93849, 93886, 93887, 
    93888, 93889, 93890, 93891, 93892, 
    93893, 94484, 94486, 94487, 94488, 
    94489, 94490, 94491, 94493, 94494, 
    94496, 94499, 94501, 94505, 94506, 
    94507, 94509, 94511, 94512, 94513, 
    94515, 94516, 94517, 94518, 94519, 
    94520, 94521, 94522, 94523, 94524, 
    94525, 94526
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00118

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "21.63"
    },
    "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": "16.83",
        "eval_cost": "4.80",
        "prefix_cost": "21.63",
        "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 (93353,93354,93355,93750,93751,93752,93794,93848,93849,93886,93887,93888,93889,93890,93891,93892,93893,94484,94486,94487,94488,94489,94490,94491,94493,94494,94496,94499,94501,94505,94506,94507,94509,94511,94512,94513,94515,94516,94517,94518,94519,94520,94521,94522,94523,94524,94525,94526)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
93353
93354
93355
93750
93751
93752
93794
93848
93849
93886
93887
93888
93889
93890
93891
93892
93893
94484
94486
94487
94488
94489
94490
94491
94493
94494
94496
94499
94501
94505
94506
94507
94509
94511
94512
94513
94515
94516
94517
94518
94519
94520
94521
94522
94523
94524
94525
94526