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 (
    94582, 94853, 95756, 95758, 95770, 95771, 
    95772, 95774, 95775, 95776, 95824, 
    95825, 95826, 96573, 97608, 97610, 
    97611, 97612, 97613, 97614, 97615, 
    97617, 97618, 97629, 97630, 97631, 
    97633, 97635, 97636, 97637, 97640, 
    97641, 97642, 97643, 97644, 97645, 
    97646, 97647, 97648, 97649, 97650, 
    97651, 97652, 97653, 97654, 97655, 
    97656, 97657, 97658, 97659, 97660, 
    97661, 97662, 97663, 97664, 97665, 
    97666, 97667, 97668, 97669, 97670, 
    97671, 97672, 97673, 97674, 97675, 
    97676, 97677, 97678, 97679, 97680, 
    97681, 97697, 97699, 97700, 97701, 
    97702, 97706, 99112, 99115, 99116, 
    99118, 99119, 99130, 99132, 99134, 
    99143, 99164, 99166, 99173, 99175, 
    99180, 99192, 99194, 99197, 99200
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00071

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 (94582,94853,95756,95758,95770,95771,95772,95774,95775,95776,95824,95825,95826,96573,97608,97610,97611,97612,97613,97614,97615,97617,97618,97629,97630,97631,97633,97635,97636,97637,97640,97641,97642,97643,97644,97645,97646,97647,97648,97649,97650,97651,97652,97653,97654,97655,97656,97657,97658,97659,97660,97661,97662,97663,97664,97665,97666,97667,97668,97669,97670,97671,97672,97673,97674,97675,97676,97677,97678,97679,97680,97681,97697,97699,97700,97701,97702,97706,99112,99115,99116,99118,99119,99130,99132,99134,99143,99164,99166,99173,99175,99180,99192,99194,99197,99200)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
94582
94853
95756
95758
95770
95771
95772
95774
95775
95776
95824
95825
95826
96573
97608
97610
97611
97612
97613
97614
97615
97617
97618
97629
97630
97631
97633
97635
97636
97637
97640
97641
97642
97643
97644
97645
97646
97647
97648
97649
97650
97651
97652
97653
97654
97655
97656
97657
97658
97659
97660
97661
97662
97663
97664
97665
97666
97667
97668
97669
97670
97671
97672
97673
97674
97675
97676
97677
97678
97679
97680
97681
97697
97699
97700
97701
97702
97706
99112
99115
99116
99118
99119
99130
99132
99134
99143
99164
99166
99173
99175
99180
99192
99194
99197
99200