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 (
    94778, 94779, 94780, 94781, 94782, 94783, 
    94784, 94785, 94786, 94787, 94788, 
    94789, 94790, 94791, 94792, 94793, 
    94794, 94795, 94814, 94815, 94833, 
    94834, 94835, 94836, 94837, 95443, 
    95444, 95445, 95446, 95447, 95791, 
    95792, 95793, 95794, 95795, 95796, 
    95797, 95798, 95799, 95800, 95801, 
    95802, 95804, 95806, 95808, 95810, 
    95812, 96564, 96565, 96566, 96567, 
    96568, 97716, 97717, 97718, 97774, 
    97786, 98146, 98148, 98152, 98155, 
    98407, 98408, 98409, 98410, 98552, 
    98553, 98554, 98555, 98556, 98763, 
    98764, 98765, 98766, 98767, 98768, 
    98818, 98822, 98826, 98830, 98859, 
    98860, 98861, 98862, 98863, 98865, 
    98867, 98869, 98871, 98873, 98910, 
    98911, 98912, 98913, 99313, 99314
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00171

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "51.87"
    },
    "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": "42.27",
        "eval_cost": "9.60",
        "prefix_cost": "51.87",
        "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 (94778,94779,94780,94781,94782,94783,94784,94785,94786,94787,94788,94789,94790,94791,94792,94793,94794,94795,94814,94815,94833,94834,94835,94836,94837,95443,95444,95445,95446,95447,95791,95792,95793,95794,95795,95796,95797,95798,95799,95800,95801,95802,95804,95806,95808,95810,95812,96564,96565,96566,96567,96568,97716,97717,97718,97774,97786,98146,98148,98152,98155,98407,98408,98409,98410,98552,98553,98554,98555,98556,98763,98764,98765,98766,98767,98768,98818,98822,98826,98830,98859,98860,98861,98862,98863,98865,98867,98869,98871,98873,98910,98911,98912,98913,99313,99314)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
94778
94779
94780
94781
94782
94783
94784
94785
94786
94787
94788
94789
94790
94791
94792
94793
94794
94795
94814
94815
94833
94834
94835
94836
94837
95443
95444
95445
95446
95447
95791
95792
95793
95794
95795
95796
95797
95798
95799
95800
95801
95802
95804
95806
95808
95810
95812
96564
96565
96566
96567
96568
97716
97717
97718
97774
97786
98146
98148
98152
98155
98407
98408
98409
98410
98552
98553
98554
98555
98556
98763
98764
98765
98766
98767
98768
98818
98822
98826
98830
98859
98860
98861
98862
98863
98865
98867
98869
98871
98873
98910
98911
98912
98913
99313
99314