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 (
    94576, 94577, 94578, 94581, 94582, 94583, 
    94584, 94585, 94586, 94587, 94588, 
    94843, 94850, 94852, 94853, 95309, 
    95316, 95376, 95756, 95758, 95762, 
    95770, 95771, 95772, 95774, 95775, 
    95776, 95778, 95779, 95823, 95824, 
    95825, 95826, 95830, 95831, 95869, 
    95870, 95871, 95872, 95873, 95874, 
    95875, 95876, 95877, 95878, 95879, 
    95880, 95881, 95882, 95883, 95884, 
    95895, 95896, 95897, 95898, 95899, 
    95900, 95901, 95902, 95903, 95904, 
    95905, 95906, 95907, 95908, 95909, 
    95910, 95911, 95912, 95913, 95914, 
    95915, 95916, 95917, 95918, 95919, 
    95920, 95921, 95922, 95923, 95924, 
    95945, 95946, 96119, 96508, 96530, 
    96570, 96572, 96573, 97574, 97575, 
    97608, 97610, 97611, 97612, 97613
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00147

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 (94576,94577,94578,94581,94582,94583,94584,94585,94586,94587,94588,94843,94850,94852,94853,95309,95316,95376,95756,95758,95762,95770,95771,95772,95774,95775,95776,95778,95779,95823,95824,95825,95826,95830,95831,95869,95870,95871,95872,95873,95874,95875,95876,95877,95878,95879,95880,95881,95882,95883,95884,95895,95896,95897,95898,95899,95900,95901,95902,95903,95904,95905,95906,95907,95908,95909,95910,95911,95912,95913,95914,95915,95916,95917,95918,95919,95920,95921,95922,95923,95924,95945,95946,96119,96508,96530,96570,96572,96573,97574,97575,97608,97610,97611,97612,97613)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
94576
94577
94578
94581
94582
94583
94584
94585
94586
94587
94588
94843
94850
94852
94853
95309
95316
95376
95756
95758
95762
95770
95771
95772
95774
95775
95776
95778
95779
95823
95824
95825
95826
95830
95831
95869
95870
95871
95872
95873
95874
95875
95876
95877
95878
95879
95880
95881
95882
95883
95884
95895
95896
95897
95898
95899
95900
95901
95902
95903
95904
95905
95906
95907
95908
95909
95910
95911
95912
95913
95914
95915
95916
95917
95918
95919
95920
95921
95922
95923
95924
95945
95946
96119
96508
96530
96570
96572
96573
97574
97575
97608
97610
97611
97612
97613