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 (
    83335, 83345, 83048, 90884, 90963, 82827, 
    82828, 82900, 82901, 82973, 82974, 
    83235, 82849, 82922, 82995, 83479, 
    83487, 86626, 86695, 85313, 85410, 
    85461, 85512, 82596, 83359, 83272, 
    85359, 83557, 86499, 86775, 86634, 
    86703, 83155, 83160, 82818, 82891, 
    82964, 83338, 83348, 82826, 82899, 
    82972, 82608, 82609, 82630, 83495, 
    82599, 83362, 86637, 86706, 83184, 
    83189, 83165, 82829, 82902, 82975, 
    82607, 83198, 82610, 92603, 92604, 
    92605, 92606, 92607, 92608, 92609, 
    92610, 92611, 92612, 92613, 92614, 
    92615, 92616, 92617, 92618, 92619, 
    92626, 92627, 92628, 92629, 92630, 
    92631, 92632, 92633, 92634, 92635, 
    92636, 92637, 92638, 92639, 92640, 
    92641, 92642, 92649, 92650, 92651
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00188

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 (83335,83345,83048,90884,90963,82827,82828,82900,82901,82973,82974,83235,82849,82922,82995,83479,83487,86626,86695,85313,85410,85461,85512,82596,83359,83272,85359,83557,86499,86775,86634,86703,83155,83160,82818,82891,82964,83338,83348,82826,82899,82972,82608,82609,82630,83495,82599,83362,86637,86706,83184,83189,83165,82829,82902,82975,82607,83198,82610,92603,92604,92605,92606,92607,92608,92609,92610,92611,92612,92613,92614,92615,92616,92617,92618,92619,92626,92627,92628,92629,92630,92631,92632,92633,92634,92635,92636,92637,92638,92639,92640,92641,92642,92649,92650,92651)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
82596 nuie Arno 600mm Wall Hung 1-Drawer Vanity & Laminate Top - Gloss White
82599 nuie Arno 600mm Wall Hung 1-Drawer Vanity & Worktop - Gloss White
82607 nuie Arno 600mm Wall Hung 2-Door Vanity & Laminate Top - Gloss White
82608 nuie Arno 600mm Wall Hung 2-Door Vanity & Laminate Top - Gloss White
82609 nuie Arno 600mm Wall Hung 2-Door Vanity & Laminate Top - Gloss White
82610 nuie Arno 600mm Wall Hung 2-Door Vanity & Worktop - Gloss White
82630 nuie Arno 800mm Wall Hung 1-Drawer Vanity & Worktop - Gloss White
82818 nuie Arno 600mm Wall Hung 1-Drawer Vanity & Worktop - Solace Oak
82826 nuie Arno 600mm Wall Hung 2-Door Vanity & Laminate Top - Solace Oak
82827 nuie Arno 600mm Wall Hung 2-Door Vanity & Laminate Top - Solace Oak
82828 nuie Arno 600mm Wall Hung 2-Door Vanity & Laminate Top - Solace Oak
82829 nuie Arno 600mm Wall Hung 2-Door Vanity & Worktop - Solace Oak
82849 nuie Arno 800mm Wall Hung 1-Drawer Vanity & Worktop - Solace Oak
82891 nuie Arno 600mm Wall Hung 1-Drawer Vanity & Worktop - Anthracite
82899 nuie Arno 600mm Wall Hung 2-Door Vanity & Laminate Top - Anthracite
82900 nuie Arno 600mm Wall Hung 2-Door Vanity & Laminate Top - Anthracite
82901 nuie Arno 600mm Wall Hung 2-Door Vanity & Laminate Top - Anthracite
82902 nuie Arno 600mm Wall Hung 2-Door Vanity & Worktop - Anthracite
82922 nuie Arno 800mm Wall Hung 1-Drawer Vanity & Worktop - Anthracite
82964 nuie Arno 600mm Wall Hung 1-Drawer Vanity & Worktop - Charcoal Black
82972 nuie Arno 600mm Wall Hung 2-Door Vanity & Laminate Top - Charcoal Black
82973 nuie Arno 600mm Wall Hung 2-Door Vanity & Laminate Top - Charcoal Black
82974 nuie Arno 600mm Wall Hung 2-Door Vanity & Laminate Top - Charcoal Black
82975 nuie Arno 600mm Wall Hung 2-Door Vanity & Worktop - Charcoal Black
82995 nuie Arno 800mm Wall Hung 1-Drawer Vanity & Worktop - Charcoal Black
83048 nuie Arno 600mm Wall Hung 2-Door Vanity & Worktop - Satin Green
83155 nuie Athena Floor Standing 2 Door Vanity With Worktop 500mm - Anthracite Woodgrain
83160 nuie Athena Floor Standing 2 Door Vanity With Worktop 500mm - Hacienda Black
83165 nuie Athena Floor Standing 2 Door Vanity With Worktop 500mm - Gloss White
83184 nuie Athena Wall Hung Single Drawer Vanity With Worktop 500mm - Anthracite Woodgrain
83189 nuie Athena Wall Hung Single Drawer Vanity With Worktop 500mm - Hacienda Black
83198 nuie Athena Wall Hung Single Drawer Vanity With Worktop 500mm - Gloss White
83235 nuie Athena Wall Hung 2 Drawer Vanity With Worktop 500mm - Gloss White
83272 nuie Athena Floor Standing 2 Door Vanity With Worktop 600mm - Gloss White
83335 nuie Athena Wall Hung Single Drawer Vanity With Grey Worktop 600mm - Anthracite Woodgrain
83338 nuie Athena Wall Hung Single Drawer Vanity With Worktop 600mm - Anthracite Woodgrain
83345 nuie Athena Wall Hung Single Drawer Vanity With Grey Worktop 600mm - Hacienda Black
83348 nuie Athena Wall Hung Single Drawer Vanity With Worktop 600mm - Hacienda Black
83359 nuie Athena Wall Hung Single Drawer Vanity With Grey Worktop 600mm - Gloss White
83362 nuie Athena Wall Hung Single Drawer Vanity With Worktop 600mm - Gloss White
83479 nuie Athena Wall Hung Single Drawer Vanity With Worktop 800mm - Anthracite Woodgrain
83487 nuie Athena Wall Hung Single Drawer Vanity With Worktop 800mm - Hacienda Black
83495 nuie Athena Wall Hung Single Drawer Vanity With Worktop 800mm - Gloss White
83557 nuie Athena Wall Hung Single Drawer Vanity With Worktop 500mm - Gloss Grey
85313 nuie Deco 600mm Wall Hung Single Drawer Vanity & Worktop - Satin Anthracite
85359 nuie Deco 600mm Wall Hung Single Drawer Vanity & Worktop - Satin White
85410 nuie Deco 600mm Wall Hung Single Drawer Vanity & Worktop - Satin Grey
85461 nuie Deco 600mm Wall Hung Single Drawer Vanity & Worktop - Satin Blue
85512 nuie Deco 600mm Wall Hung Single Drawer Vanity & Worktop - Satin Green
86499 Hudson Reed Juno 600mm Wall Hung 2-Door Vanity & Worktop - Autumn Oak
86626 Hudson Reed Juno 600mm Wall Hung Single Drawer Vanity & Worktop - Graphite Grey
86634 Hudson Reed Juno 600mm Wall Hung 2-Door Vanity & Laminate Top - Graphite Grey
86637 Hudson Reed Juno 600mm Wall Hung 2-Door Vanity & Worktop - Graphite Grey
86695 Hudson Reed Juno 600mm Wall Hung Single Drawer Vanity & Worktop - Coastal Grey
86703 Hudson Reed Juno 600mm Wall Hung 2-Door Vanity & Laminate Top - Coastal Grey
86706 Hudson Reed Juno 600mm Wall Hung 2-Door Vanity & Worktop - Coastal Grey
86775 Hudson Reed Juno Wall Hung 2 Door Vanity Unit & Colour Match Worktop, 600mm - Metallic Slate
90884 nuie Arno Wall Hung 2 Door Vanity & Laminate Worktop, 600mm - Satin Anthracite
90963 nuie Arno Wall Hung 2 Door Vanity & Laminate Worktop, 600mm - Satin Grey
92603
92604
92605
92606
92607
92608
92609
92610
92611
92612
92613
92614
92615
92616
92617
92618
92619
92626
92627
92628
92629
92630
92631
92632
92633
92634
92635
92636
92637
92638
92639
92640
92641
92642
92649
92650
92651