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 (
    90714, 90720, 90713, 90719, 90728, 90729, 
    90717, 90723, 90725, 90727, 90712, 
    90718, 90586, 90587, 90730, 90731, 
    90724, 90726, 90716, 90722, 90592, 
    90593, 89243, 89244, 89253, 89254, 
    90588, 90590, 89245, 89246, 89247, 
    89248, 90589, 90591, 90715, 90721, 
    89249, 89250, 89251, 89252, 90048, 
    90049, 90050, 90051, 90052, 90053, 
    90018, 90019, 90020, 90021, 90032, 
    90033, 90034, 90035, 90036, 90037, 
    90042, 90043, 90044, 90045, 90046, 
    90047, 90058, 90059, 90014, 90015, 
    90016, 90017, 90026, 90027, 90028, 
    90029, 90030, 90031, 87836, 93834, 
    93835, 93882, 93883, 93884, 93885, 
    95360, 96122, 96124, 96125, 96126, 
    96127, 96131, 96155, 96156, 96195, 
    96196, 96197, 96198, 96199, 96200
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00086

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 (90714,90720,90713,90719,90728,90729,90717,90723,90725,90727,90712,90718,90586,90587,90730,90731,90724,90726,90716,90722,90592,90593,89243,89244,89253,89254,90588,90590,89245,89246,89247,89248,90589,90591,90715,90721,89249,89250,89251,89252,90048,90049,90050,90051,90052,90053,90018,90019,90020,90021,90032,90033,90034,90035,90036,90037,90042,90043,90044,90045,90046,90047,90058,90059,90014,90015,90016,90017,90026,90027,90028,90029,90030,90031,87836,93834,93835,93882,93883,93884,93885,95360,96122,96124,96125,96126,96127,96131,96155,96156,96195,96196,96197,96198,96199,96200)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
87836 nuie Linton Square Single Ended Bath 1500 x 700mm
89243 nuie Shower Baths 1700mm Left Hand Square Shower Bath Set
89244 nuie Shower Baths 1700mm Right Hand Square Shower Bath Set
89245 nuie Shower Baths 1700mm B Shaped Left Hand Bath Set
89246 nuie Shower Baths 1700mm B Shaped Right Hand Bath Set
89247 nuie Shower Baths 1500mm B Shaped Left Hand Bath Set
89248 nuie Shower Baths 1500mm B Shaped Right Hand Bath Set
89249 nuie Shower Baths 1700mm Left Hand P-Shaped Bath Set
89250 nuie Shower Baths 1700mm Right Hand P-Shaped Bath Set
89251 nuie Shower Baths 1500mm Left Hand P-Shaped Bath Set
89252 nuie Shower Baths 1500mm Right Hand P-Shaped Bath Set
89253 nuie Shower Baths 1500mm Left Hand Square Shower Bath Set
89254 nuie Shower Baths 1500mm Right Hand Square Shower Bath Set
90014 nuie Shower Baths B-Shaped Shower Sath Left Hand 1700mm - No Leg Set
90015 nuie Shower Baths B-Shaped Shower Sath Right Hand 1700mm - No Leg Set
90016 nuie Shower Baths B-Shaped Shower Sath Left Hand 1500mm - No Leg Set
90017 nuie Shower Baths B-Shaped Shower Sath Right Hand 1500mm - No Leg Set
90018 nuie Shower Baths 1500mm Left Hand B-Shaped Bath
90019 nuie Shower Baths 1500mm Right Hand B-Shaped Bath
90020 nuie Shower Baths 1700mm Left Hand B-Shaped Bath
90021 nuie Shower Baths 1700mm Right Hand B-Shaped Bath
90026 nuie Shower Baths P-Shaped Shower Bath Left Hand 1700mm - No Leg Set
90027 nuie Shower Baths P-Shaped Shower Bath Right Hand 1700mm - No Leg Set
90028 nuie Shower Baths P-Shaped Shower Bath Left Hand 1500mm - No Leg Set
90029 nuie Shower Baths P-Shaped Shower Bath Right Hand 1500mm - No Leg Set
90030 nuie Shower Baths P-Shaped Shower Bath Left Hand 1600mm - No Leg Set
90031 nuie Shower Baths P-Shaped Shower Bath Right Hand 1600mm - No Leg Set
90032 nuie Shower Baths 1500mm Left Hand P-Shaped Bath
90033 nuie Shower Baths 1500mm Right Hand P-Shaped Bath
90034 nuie Shower Baths 1600mm Left Hand P-Shaped Bath
90035 nuie Shower Baths 1600mm Right Hand P-Shaped Bath
90036 nuie Shower Baths 1700mm Left Hand P-Shaped Bath
90037 nuie Shower Baths 1700mm Right Hand P-Shaped Bath
90042 nuie Shower Baths L-Shape Square Shower Bath Left Hand 1700mm - No Leg Set
90043 nuie Shower Baths L-Shape Square Shower Bath Right Hand 1700mm - No Leg Set
90044 nuie Shower Baths L-Shape Square Shower Bath Left Hand 1500mm - No Leg Set
90045 nuie Shower Baths L-Shape Square Shower Bath Right Hand 1500mm - No Leg Set
90046 nuie Shower Baths L-Shape Square Shower Bath Left Hand 1600mm - No Leg Set
90047 nuie Shower Baths L-Shape Square Shower Bath Right Hand 1600mm - No Leg Set
90048 nuie Shower Baths 1500mm Left Hand Square Shower Bath
90049 nuie Shower Baths 1500mm Right Hand Square Shower Bath
90050 nuie Shower Baths 1600mm Left Hand Square Shower Bath
90051 nuie Shower Baths 1600mm Right Hand Square Shower Bath
90052 nuie Shower Baths 1700mm Left Hand Square Shower Bath
90053 nuie Shower Baths 1700mm Right Hand Square Shower Bath
90058 nuie Shower Baths L-Shape Square Shower Bath Left Hand 1700mm - No Leg Set
90059 nuie Shower Baths L-Shape Square Shower Bath Right Hand 1700mm - No Leg Set
90586 Nuie 1700 B-Bath Panel & Chrome Screen - Left Hand
90587 Nuie 1700 B-Bath Panel & Chrome Screen - Right Hand
90588 Nuie 1700 P-Bath Panel & Chrome Screen - Left Hand
90589 Nuie 1700 P-Bath Panel & Chrome Screen - Left Hand
90590 Nuie 1700 P-Bath Panel & Chrome Screen - Right Hand
90591 Nuie 1700 P-Bath Panel & Chrome Screen - Right Hand
90592 Nuie 1700 P-Bath Panel & Black Screen - Left Hand
90593 Nuie 1700 P-Bath Panel & Black Screen - Right Hand
90712 Nuie 1700 Square Bath Panel & Chrome Screen - Left Hand
90713 Nuie 1700 Square Bath Panel & Chrome Screen - Left Hand
90714 Nuie 1700 Square Bath Panel & Chrome Screen - Left Hand
90715 Nuie 1700 Square Bath Panel & Chrome Screen - Left Hand
90716 Nuie 1700 Square Bath Panel & Chrome Screen - Left Hand
90717 Nuie 1700 Square Bath Panel & Chrome Screen - Left Hand
90718 Nuie 1700 Square Bath Panel & Chrome Screen - Right Hand
90719 Nuie 1700 Square Bath Panel & Chrome Screen - Right Hand
90720 Nuie 1700 Square Bath Panel & Chrome Screen - Right Hand
90721 Nuie 1700 Square Bath Panel & Chrome Screen - Right Hand
90722 Nuie 1700 Square Bath Panel & Chrome Screen - Right Hand
90723 Nuie 1700 Square Bath Panel & Chrome Screen - Right Hand
90724 Nuie 1700 Square Bath Panel & Black Screen - Left Hand
90725 Nuie 1700 Square Bath Panel & Black Screen - Left Hand
90726 Nuie 1700 Square Bath Panel & Black Screen - Right Hand
90727 Nuie 1700 Square Bath Panel & Black Screen - Right Hand
90728 Nuie 1700 Square Bath Panel & Black Screen - Left Hand
90729 Nuie 1700 Square Bath Panel & Black Screen - Right Hand
90730 Nuie 1700 Square Bath Panel & B/Brass Screen - Left Hand
90731 Nuie 1700 Square Bath Panel & B/Brass Screen - Right Hand
93834
93835
93882
93883
93884
93885
95360
96122
96124
96125
96126
96127
96131
96155
96156
96195
96196
96197
96198
96199
96200