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 (
    87359, 82436, 87381, 82435, 87375, 87372, 
    82487, 87371, 91481, 91480, 82491, 
    89563, 82490, 82489, 91478, 82488, 
    91479, 85638, 85637, 85636, 85635, 
    92560, 92561, 92562, 92563, 92564, 
    92565, 92566, 92567, 92568, 94012, 
    95074, 95075, 95076, 95077, 95078, 
    95079, 95080, 95081, 95082, 95083, 
    95341, 95342, 95356, 95357, 95473, 
    95474, 95476, 95477, 95479, 95480, 
    95482, 95483, 96186, 96187, 96188, 
    96781, 96782, 96793, 96794, 96795, 
    96796, 96797, 96798, 96799, 96800, 
    96801, 96802, 96803, 96804, 96805, 
    96806, 96959, 96960, 96961, 96962, 
    96963, 96964, 96965, 96966, 96967, 
    96968, 98517, 98518, 98519, 98520, 
    98893, 98898, 98899, 98901, 98905, 
    100338, 100339, 100340, 100343, 100345
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00196

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 (87359,82436,87381,82435,87375,87372,82487,87371,91481,91480,82491,89563,82490,82489,91478,82488,91479,85638,85637,85636,85635,92560,92561,92562,92563,92564,92565,92566,92567,92568,94012,95074,95075,95076,95077,95078,95079,95080,95081,95082,95083,95341,95342,95356,95357,95473,95474,95476,95477,95479,95480,95482,95483,96186,96187,96188,96781,96782,96793,96794,96795,96796,96797,96798,96799,96800,96801,96802,96803,96804,96805,96806,96959,96960,96961,96962,96963,96964,96965,96966,96967,96968,98517,98518,98519,98520,98893,98898,98899,98901,98905,100338,100339,100340,100343,100345)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
82435 Hudson Reed Apex 800mm Side Panel - 8mm Glass - Matt Black
82436 Hudson Reed Apex 900mm Side Panel - 8mm Glass - Matt Black
82487 nuie Pacific 1000mm Side Panel - 6mm Glass - Polished Chrome
82488 nuie Pacific 700mm Side Panel - 6mm Glass - Polished Chrome
82489 nuie Pacific 760mm Side Panel - 6mm Glass - Polished Chrome
82490 nuie Pacific 800mm Side Panel - 6mm Glass - Polished Chrome
82491 nuie Pacific 900mm Side Panel - 6mm Glass - Polished Chrome
85635 nuie Ella 700mm Side Panel - 5mm Glass - Satin Chrome
85636 nuie Ella 760mm Side Panel - 5mm Glass - Satin Chrome
85637 nuie Ella 800mm Side Panel - 5mm Glass - Satin Chrome
85638 nuie Ella 900mm Side Panel - 5mm Glass - Satin Chrome
87359 Hudson Reed Apex 1000mm Side Panel - 8mm Glass - Polished Chrome
87371 Hudson Reed Apex 700mm Side Panel - 8mm Glass - Polished Chrome
87372 Hudson Reed Apex 760mm Side Panel - 8mm Glass - Polished Chrome
87375 Hudson Reed Apex 800mm Side Panel - 8mm Glass - Polished Chrome
87381 Hudson Reed Apex 900mm Side Panel - 8mm Glass - Polished Chrome
89563 nuie Rene 900mm Side Panel - 6mm Glass - Matt Black
91478 nuie Rene 6mm Toughened Safety Glass Shower Side Panel, 700mm x 1850mm - Brushed Brass
91479 nuie Rene 6mm Toughened Safety Glass Shower Side Panel, 700mm x 1850mm - Matt Black
91480 nuie Rene 6mm Toughened Safety Glass Shower Side Panel, 800mm x 1850mm - Brushed Brass
91481 nuie Rene 6mm Toughened Safety Glass Shower Side Panel, 900mm x 1850mm - Brushed Brass
92560
92561
92562
92563
92564
92565
92566
92567
92568
94012
95074
95075
95076
95077
95078
95079
95080
95081
95082
95083
95341
95342
95356
95357
95473
95474
95476
95477
95479
95480
95482
95483
96186
96187
96188
96781
96782
96793
96794
96795
96796
96797
96798
96799
96800
96801
96802
96803
96804
96805
96806
96959
96960
96961
96962
96963
96964
96965
96966
96967
96968
98517
98518
98519
98520
98893
98898
98899
98901
98905
100338
100339
100340
100343
100345