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 (
    88056, 88057, 88058, 87998, 88000, 88037, 
    90329, 90330, 90331, 90333, 90334, 
    90337, 90338, 90339, 90340, 90341, 
    90342, 90345, 90346, 90347, 90348, 
    87881, 88031, 87948, 88059, 88060, 
    88702, 88749, 89985, 87945, 89986, 
    88041, 86860, 87940, 87942, 87964, 
    90328, 90332, 90335, 90336, 90343, 
    90344, 88029, 88018, 88021, 88799, 
    88006, 88013, 88015, 87972, 88091, 
    88055, 88085, 88703, 88750, 87809, 
    87811, 87814, 87817, 87824, 90327, 
    88071, 88076, 88090, 87944, 88595, 
    88072, 88154, 87808, 87810, 87813, 
    87816, 87823, 87874, 87779, 87783, 
    87793, 87799, 87880, 87873, 90317, 
    90319, 90320, 88087, 88797, 87960, 
    87778, 87782, 87791, 87797, 87760, 
    88701, 88748, 88596, 88030, 88086
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00257

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 (88056,88057,88058,87998,88000,88037,90329,90330,90331,90333,90334,90337,90338,90339,90340,90341,90342,90345,90346,90347,90348,87881,88031,87948,88059,88060,88702,88749,89985,87945,89986,88041,86860,87940,87942,87964,90328,90332,90335,90336,90343,90344,88029,88018,88021,88799,88006,88013,88015,87972,88091,88055,88085,88703,88750,87809,87811,87814,87817,87824,90327,88071,88076,88090,87944,88595,88072,88154,87808,87810,87813,87816,87823,87874,87779,87783,87793,87799,87880,87873,90317,90319,90320,88087,88797,87960,87778,87782,87791,87797,87760,88701,88748,88596,88030,88086)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
86860 nuie Deco 600mm Laminate Worktop - Bellato Grey
87760 nuie Arno 800mm Worktop - Gloss White
87778 nuie Arno 600mm Worktop - Solace Oak
87779 nuie Arno 800mm Worktop - Solace Oak
87782 Juno Components Colour Match Worktop (605mm x 390mm x 18mm), 600mm - Metallic Slate
87783 Juno Components Colour Match Worktop (605mm x 390mm x 18mm), 800mm - Metallic Slate
87791 nuie Arno 600mm Worktop - Anthracite
87793 nuie Arno 800mm Worktop - Anthracite
87797 nuie Arno 600mm Worktop - Charcoal Black
87799 nuie Arno 800mm Worktop - Charcoal Black
87808 nuie Deco 600mm Worktop - Satin Anthracite
87809 nuie Deco 800mm Worktop - Satin Anthracite
87810 Furniture Worktop 600mm - Satin White
87811 nuie Deco 800mm Worktop - Satin White
87813 Furniture Worktop 600mm - Satin Grey
87814 nuie Deco 800mm Worktop - Satin Grey
87816 Furniture Worktop 600mm - Satin Blue
87817 nuie Deco 800mm Worktop - Satin Blue
87823 nuie Deco 600mm Worktop - Satin Green
87824 nuie Deco 800mm Laminate Worktop - Satin Green
87873 nuie Mayford Round Ceramic 1 Tap Hole Basin 450mm
87874 nuie Mayford Round Ceramic 1 Tap Hole Basin 550mm
87880 nuie Mayford Square Ceramic 1 Tap Hole Basin 450mm
87881 nuie Mayford Square Ceramic 1 Tap Hole Basin 550mm
87940 Old London Chancery 500mm Basin 1 Tap Hole
87942 Hudson Reed Chancery Small Cloakroom Basin 2 Tap Hole
87944 nuie Asselby Small Cloakroom Basin 1 Tap Hole
87945 nuie Asselby 600mm Medium Basin 1 Tap Hole
87948 nuie Provost Short Projection Cistern
87960 nuie Ambrose Full Pedestal
87964 Nuie 550mm Basin 1 Tap Hole
87972 Nuie 545mm Basin 1 Tap Hole
87998 nuie Provost 420mm Small Basin 1 Tap Hole
88000 nuie Provost Medium 520mm Basin 1 Tap Hole
88006 nuie Harmony 500mm Basin 1 Tap Hole
88013 nuie Melbourne Large Basin 1 Tap Hole
88015 nuie Melbourne Large Basin 2 Tap Hole
88018 <p>nuie Ivo Large Basin 1 Tap Hole</p>
88021 nuie Ivo 550 Basin 2 Tap Hole
88029 nuie Legend Cistern Including Chrome Handle
88030 nuie Legend Pedestal
88031 nuie Legend Large Basin 2 Tap Hole
88037 Old London Richmond 515mm Cloakroom Basin
88041 Old London Richmond Comfort Height Full Pedestal
88055 nuie Carlton Full Pedestal
88056 Old London Richmond 560mm Basin 2 Tap Hole
88057 Old London Richmond 560mm Basin 1 Tap Hole
88058 Old London Richmond 560mm 3 Tap Hole Basin
88059 Old London Richmond 500mm Basin 2 Tap Hole
88060 Old London Richmond 500mm Basin 1 Tap Hole
88071 Hudson Reed Arlo Full Pedestal
88072 Hudson Reed Arlo Square Semi Pedestal
88076 Hudson Reed Maya Full Pedestal
88085 nuie Ambrose Semi Pedestal
88086 nuie Melbourne 350mm Wall Hung Basin
88087 nuie Melbourne 450mm Wall Hung Basin
88090 nuie Melbourne 350mm Wall Hung Basin
88091 nuie Melbourne 450mm Wall Hung Basin
88154 nuie Lawton 560mm Basin 1 Tap Hole
88595 Hudson Reed Fusion Fitted Decorative End Panel - Gloss White
88596 Hudson Reed Fusion Fitted Plinth 2000mm - Gloss White
88701 Hudson Reed Fusion Fitted Plinth 1250mm - Anthracite Woodgrain
88702 Hudson Reed Fusion Fitted Decorative End Panel - Anthracite Woodgrain
88703 Hudson Reed Fusion Fitted Plinth 2000mm - Anthracite Woodgrain
88748 Hudson Reed Fusion Fitted Plinth 1250mm - Hacienda Black
88749 Hudson Reed Fusion Fitted Decorative End Panel - Hacienda Black
88750 Hudson Reed Fusion Fitted Plinth 2000mm - Hacienda Black
88797 Hudson Reed Fusion Fitted Plinth 1250mm - Gloss Grey
88799 Hudson Reed Fusion Fitted Plinth 2000mm - Gloss Grey
89985 BC Designs Victrion Pedestal (640mm Basin) - White
89986 BC Designs Victrion Pedestal (540mm Basin) - White
90317 nuie Ceramics Accessories Dual Flush Concealed Cistern
90319 nuie Ceramics Accessories Dual Flush Concealed Cistern - Chrome
90320 nuie Ceramics Accessories Dual Flush Concealed Cistern - Chrome
90327 nuie Ceramics Accessories Pneumatic Dual Flush Universal Access Concealed Cistern - Black/White
90328 nuie Ceramics Accessories Universal Access Cistern & Chrome Square Flush Plate - Chrome
90329 nuie Ceramics Accessories Universal Access Cistern & Matt Black Square Flush Plate
90330 nuie Ceramics Accessories Universal Access Cistern & Brushed Brass Square Flush Plate
90331 nuie Ceramics Accessories Concealed Cistern & Square Push Button - Gunmetal
90332 nuie Ceramics Accessories Universal Access Cistern & Chrome Traditional Flush Plate
90333 nuie Ceramics Accessories Universal Access Cistern & Matt Black Traditional Flush Plate
90334 nuie Ceramics Accessories Universal Access Cistern & Brushed Brass Traditional Flush Plate
90335 nuie Ceramics Accessories Universal Access Cistern & Chrome Square Flush Plate
90336 nuie Ceramics Accessories Universal Access Cistern & Chrome Square Flush Plate
90337 nuie Ceramics Accessories Universal Access Cistern & Matt Black Square Flush Plate
90338 nuie Ceramics Accessories Universal Access Cistern & Black Square Flush Plate
90339 nuie Ceramics Accessories Universal Access Cistern & Brushed Brass Square Flush Plate
90340 nuie Ceramics Accessories Universal Access Cistern & Brushed Brass Flush Plate
90341 nuie Ceramics Accessories Concealed Cistern & Square Push Button - Gunmetal
90342 nuie Ceramics Accessories Dual Flush Cistern & Square Push Button - Gunmetal
90343 nuie Ceramics Accessories Universal Access Cistern & Chrome Traditional Flush Plate
90344 nuie Ceramics Accessories Universal Access Cistern & Chrome Traditional Flush Plate
90345 nuie Ceramics Accessories Universal Access Cistern & Matt Black Traditional Flush Plate
90346 nuie Ceramics Accessories Universal Access Cistern & Matt Black Traditional Flush Plate
90347 nuie Ceramics Accessories Universal Access Cistern & Brushed Brass Traditional Flush Plate
90348 nuie Ceramics Accessories Universal Access Cistern & Brushed Brass Traditional Flush Plate