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 (
    87296, 87297, 85852, 85853, 85862, 85863, 
    91007, 91008, 91019, 91020, 91031, 
    91032, 91044, 91045, 85842, 85843, 
    91004, 91005, 91016, 91017, 91028, 
    91029, 91040, 91041, 91042, 90008, 
    90564, 90570, 90576, 84678, 87304, 
    87305, 87316, 87317, 87328, 87329, 
    87340, 87341, 89818, 89819, 89870, 
    89871, 89942, 89943, 91508, 91509, 
    83083, 83084, 83611, 83612, 90922, 
    90923, 91001, 91002, 87292, 87293, 
    89816, 89868, 89940, 91506, 85848, 
    85849, 85858, 85859, 83081, 83609, 
    90920, 90999, 89997, 90004, 86471, 
    86472, 86747, 86748, 85838, 85839, 
    90546, 89817, 89869, 89941, 91507, 
    83082, 83610, 90921, 91000, 86469, 
    86745, 84808, 84809, 84826, 84827, 
    84838, 84839, 91106, 91192, 91247
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00177

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 (87296,87297,85852,85853,85862,85863,91007,91008,91019,91020,91031,91032,91044,91045,85842,85843,91004,91005,91016,91017,91028,91029,91040,91041,91042,90008,90564,90570,90576,84678,87304,87305,87316,87317,87328,87329,87340,87341,89818,89819,89870,89871,89942,89943,91508,91509,83083,83084,83611,83612,90922,90923,91001,91002,87292,87293,89816,89868,89940,91506,85848,85849,85858,85859,83081,83609,90920,90999,89997,90004,86471,86472,86747,86748,85838,85839,90546,89817,89869,89941,91507,83082,83610,90921,91000,86469,86745,84808,84809,84826,84827,84838,84839,91106,91192,91247)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
83081 nuie Arno 800mm Floor Standing 2-Drawer Vanity & Mid-Edge Basin - Satin Green
83082 nuie Arno 800mm Floor Standing 2-Drawer Vanity & Minimalist Basin - Satin Green
83083 nuie Arno 800mm Floor Standing 2-Drawer Vanity & Thin-Edge Basin - Satin Green
83084 nuie Arno 800mm Floor Standing 2-Drawer Vanity & Curved Basin - Satin Green
83609 nuie Athena Floor Standing 2 Drawer Vanity With Mid-Edge 1 Tap Hole Ceramic Basin 800mm - Gloss Grey
83610 nuie Athena Floor Standing 2 Drawer Vanity With Minimalist 1 Tap Hole Ceramic Basin 800mm - Gloss Grey
83611 nuie Athena Floor Standing 2 Drawer Vanity With Thin-Edge 1 Tap Hole Ceramic Basin 800mm - Gloss Grey
83612 nuie Athena Floor Standing 2 Drawer Vanity With Curved 1 Tap Hole Ceramic Basin 800mm - Gloss Grey
84678 Hudson Reed Fusion Wall Hung 4 Door Vanity Unit & Polymarble Basin Compact 1000mm - Gloss Grey
84808 nuie Classique Floor Standing 2 Door Vanity Basin Unit & 1 Tap Hole Fireclay Basin, 800mm - Satin Anthracite
84809 nuie Classique Floor Standing 2 Door Vanity Basin Unit & 3 Tap Hole Fireclay Basin, 800mm - Satin Anthracite
84826 nuie Classique Floor Standing 2 Door Vanity Basin Unit & 1 Tap Hole Fireclay Basin, 800mm - Satin Grey
84827 nuie Classique Floor Standing 2 Door Vanity Basin Unit & 3 Tap Hole Fireclay Basin, 800mm - Satin Grey
84838 nuie Classique Floor Standing 2 Door Vanity Basin Unit & 1 Tap Hole Fireclay Basin, 800mm - Satin Green
84839 nuie Classique Floor Standing 2 Door Vanity Basin Unit & 3 Tap Hole Fireclay Basin, 800mm - Satin Green
85838 nuie Parade Floor Standing 2 Drawer Vanity Unit with Polymarble Basin 600mm - Gloss White
85839 nuie Parade Floor Standing 2 Drawer Vanity Unit with Ceramic Basin 600mm - Gloss White
85842 nuie Parade Floor Standing 2 Drawer Vanity Unit with Polymarble Basin 800mm - Gloss White
85843 nuie Parade Floor Standing 2 Drawer Vanity Unit with Ceramic Basin 800mm - Gloss White
85848 nuie Parade Floor Standing 2 Drawer Vanity Basin Unit & Polymarble Basin, 600mm - Satin Anthracite
85849 nuie Parade Floor Standing 2 Drawer Vanity Basin Unit & Ceramic Basin, 600mm - Satin Anthracite
85852 nuie Parade Floor Standing 2 Drawer Vanity Basin Unit & Polymarble Basin, 800mm - Satin Anthracite
85853 nuie Parade Floor Standing 2 Drawer Vanity Basin Unit & Ceramic Basin, 800mm - Satin Anthracite
85858 nuie Parade Floor Standing 2 Drawer Vanity Basin Unit & Polymarble Basin, 600mm - Satin Green
85859 nuie Parade Floor Standing 2 Drawer Vanity Basin Unit & Ceramic Basin, 600mm - Satin Green
85862 nuie Parade Floor Standing 2 Drawer Vanity Basin Unit & Polymarble Basin, 800mm - Satin Green
85863 nuie Parade Floor Standing 2 Drawer Vanity Basin Unit & Ceramic Basin, 800mm - Satin Green
86469 Hudson Reed Juno 800mm Floor Standing 2-Door Vanity & Mid-Edge 1 Tap Hole Basin - Autumn Oak
86471 Hudson Reed Juno 800mm Floor Standing 2-Door Vanity & Thin-Edge 1 Tap Hole Basin - Autumn Oak
86472 Hudson Reed Juno 800mm Floor Standing 2-Door Vanity & Curved 1 Tap Hole Basin - Autumn Oak
86745 Hudson Reed Juno Floor Standing 2 Door Vanity Basin Unit & Mid-Edge Ceramic Basin, 800mm - Metallic Slate
86747 Hudson Reed Juno Floor Standing 2 Door Vanity Basin Unit & Thin-Edge Ceramic Basin, 800mm - Metallic Slate
86748 Hudson Reed Juno Floor Standing 2 Door Vanity Basin Unit & Curved Ceramic Basin, 800mm - Metallic Slate
87292 nuie Lunar Floor Standing 2 Drawer Unit & Polymarble Basin, 600mm - Satin White
87293 nuie Lunar Floor Standing 2 Drawer Unit & Ceramic Basin, 600mm - Satin White
87296 nuie Lunar Floor Standing 2 Drawer Unit & Polymarble Basin, 800mm - Satin White
87297 nuie Lunar Floor Standing 2 Drawer Unit & Ceramic Basin, 800mm - Satin White
87304 nuie Lunar Floor Standing 2 Drawer Unit & Polymarble Basin, 600mm - Satin Anthracite
87305 nuie Lunar Floor Standing 2 Drawer Unit & Ceramic Basin, 600mm - Satin Anthracite
87316 nuie Lunar Floor Standing 2 Drawer Unit & Polymarble Basin, 600mm - Satin Grey
87317 nuie Lunar Floor Standing 2 Drawer Unit & Ceramic Basin, 600mm - Satin Grey
87328 nuie Lunar Floor Standing 2 Drawer Unit & Polymarble Basin, 600mm - Satin Blue
87329 nuie Lunar Floor Standing 2 Drawer Unit & Ceramic Basin, 600mm - Satin Blue
87340 nuie Lunar Floor Standing 2 Drawer Unit & Polymarble Basin, 600mm - Satin Green
87341 nuie Lunar Floor Standing 2 Drawer Unit & Ceramic Basin, 600mm - Satin Green
89816 Hudson Reed Urban Floor Standing 2 Door 1 Drawer Vanity Unit with Mid-Edge Basin 800mm - Satin Grey
89817 Hudson Reed Urban Floor Standing 2 Door 1 Drawer Vanity Unit with Minimalist Basin 800mm - Satin Grey
89818 Hudson Reed Urban Floor Standing 2 Door Vanity Unit with Thin-Edge Basin 800mm - Satin Grey
89819 Hudson Reed Urban Floor Standing 2 Door Vanity Unit with Curved Basin 800mm - Satin Grey
89868 Hudson Reed Urban Floor Standing 2 Door 1 Drawer Vanity Unit with Mid-Edge Basin 800mm - Satin Blue
89869 Hudson Reed Urban Floor Standing 2 Door 1 Drawer Vanity Unit with Minimalist Basin 800mm - Satin Blue
89870 Hudson Reed Urban Floor Standing 2 Door Vanity Unit with Thin-Edge Basin 800mm - Satin Blue
89871 Hudson Reed Urban Floor Standing 2 Door Vanity Unit with Curved Basin 800mm - Satin Blue
89940 Hudson Reed Urban 800mm Floor Standing 2-Door/Drawer Unit and Mid-Edge Basin 1 Tap Hole - Satin Green
89941 Hudson Reed Urban 800mm Floor Standing 2-Door/Drawer Unit and Minimalist Basin 1 Tap Hole - Satin Green
89942 Hudson Reed Urban 800mm Floor Standing 2-Door/Drawer Unit and Thin-Edge Basin 1 Tap Hole - Satin Green
89943 Hudson Reed Urban 800mm Floor Standing 2-Door/Drawer Unit and Curved Basin 1 Tap Hole - Satin Green
89997 nuie Eden Floor Standing 3 Door 2 Drawer Vanity Unit with Mid-Edge Basin 1000mm - Gloss White
90004 nuie Eden Floor Standing 3 Door 2 Drawer Vanity Unit with Minimalist Basin 1000mm - Gloss White
90008 nuie Mayford Floor Standing 3 Door 3 Drawer Vanity Unit with Round Ceramic Basin 1250mm - Gloss White
90546 Nuie Arno 1200mm Floor Standing 4 Door Vanity & Worktop - Gloss White
90564 Nuie Arno 1200mm Floor Standing 4 Door Vanity & Worktop - Grey Vicenza Oak
90570 Nuie Arno 1200mm Floor Standing 4 Door Vanity & Worktop - Anthracite Woodgrain
90576 Nuie Arno 1200mm Floor Standing 4 Door Vanity & Worktop - Black Woodgrain
90920 nuie Arno Floor Standing 2 Drawer Vanity & Mid-Edge Ceramic Basin, 800mm - Satin Anthracite
90921 nuie Arno Floor Standing 2 Drawer Vanity & Minimalist Ceramic Basin, 800mm - Satin Anthracite
90922 nuie Arno Floor Standing 2 Drawer Vanity & Thin-Edge Ceramic Basin, 800mm - Satin Anthracite
90923 nuie Arno Floor Standing 2 Drawer Vanity & Curved Ceramic Basin, 800mm - Satin Anthracite
90999 nuie Arno Floor Standing 2 Drawer Vanity & Mid-Edge Ceramic Basin, 800mm - Satin Grey
91000 nuie Arno Floor Standing 2 Drawer Vanity & Minimalist Ceramic Basin, 800mm - Satin Grey
91001 nuie Arno Floor Standing 2 Drawer Vanity & Thin-Edge Ceramic Basin, 800mm - Satin Grey
91002 nuie Arno Floor Standing 2 Drawer Vanity & Curved Ceramic Basin, 800mm - Satin Grey
91004 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & 1 Tap Hole Fireclay Basin, 500mm - Satin White
91005 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & 3 Tap Hole Fireclay Basin, 500mm - Satin White
91007 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & 1 Tap Hole Fireclay Basin, 600mm - Satin White
91008 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & 3 Tap Hole Fireclay Basin, 600mm - Satin White
91016 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & 1 Tap Hole Fireclay Basin, 500mm - Cool Grey
91017 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & 3 Tap Hole Fireclay Basin, 500mm - Cool Grey
91019 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & 1 Tap Hole Fireclay Basin, 600mm - Cool Grey
91020 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & 3 Tap Hole Fireclay Basin, 600mm - Cool Grey
91028 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & 1 Tap Hole Fireclay Basin, 500mm - Indigo Blue
91029 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & 3 Tap Hole Fireclay Basin, 500mm - Indigo Blue
91031 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & 1 Tap Hole Fireclay Basin, 600mm - Indigo Blue
91032 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & 3 Tap Hole Fireclay Basin, 600mm - Indigo Blue
91040 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & 1 Tap Hole Fireclay Basin, 500mm - Matt Green
91041 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & 3 Tap Hole Fireclay Basin, 500mm - Matt Green
91042 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & 0 Tap Hole Fireclay Basin, 500mm - Matt Green
91044 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & 1 Tap Hole Fireclay Basin, 600mm - Matt Green
91045 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & 3 Tap Hole Fireclay Basin, 600mm - Matt Green
91106 nuie Classique Floor Standing 2 Door Unit & 0 Tap Hole Fireclay Basin, 800mm - Satin Anthracite
91192 nuie Classique Floor Standing 2 Door Unit & 0 Tap Hole Fireclay Basin, 800mm - Satin Grey
91247 nuie Classique Floor Standing 2 Door Unit & 0 Tap Hole Fireclay Basin, 800mm - Satin Green
91506 Hudson Reed Urban Floor Standing 2 Door Vanity & Mid-Edge Ceramic Basin, 800mm - Satin Anthracite
91507 Hudson Reed Urban Floor Standing 2 Door Vanity & Minimalist Ceramic Basin, 800mm - Satin Anthracite
91508 Hudson Reed Urban Floor Standing 2 Door Vanity & Thin-Edge Ceramic Basin, 800mm - Satin Anthracite
91509 Hudson Reed Urban Floor Standing 2 Door Vanity & Curved Ceramic Basin, 800mm - Satin Anthracite