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 (
    90287, 90176, 90192, 90309, 90236, 90241, 
    85960, 90235, 90240, 90225, 90183, 
    90234, 90239, 90224, 90199, 90173, 
    90308, 90223, 90278, 90286, 90198, 
    90222, 90221, 90197, 90205, 90216, 
    90220, 90191, 90277, 91538, 91539, 
    90210, 90233, 91536, 91537, 90190, 
    90182, 90172, 90276, 90204, 90215, 
    90209, 90232, 90196, 82561, 90189, 
    90268, 90264, 90266, 90273, 91311, 
    91313, 91315, 90267, 90274, 85649, 
    85650, 85651, 91312, 91314, 91316, 
    90263, 90270, 90269, 90275, 90265, 
    93356, 93357, 93358, 94081, 94082, 
    94085, 94088, 94089, 94090, 94093, 
    94095, 94096, 94097, 94098, 94099, 
    94116, 94117, 94118, 94165, 94166, 
    94167, 94168, 94169, 94170, 94171, 
    94172, 94173, 94174, 94175, 94176
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00184

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 (90287,90176,90192,90309,90236,90241,85960,90235,90240,90225,90183,90234,90239,90224,90199,90173,90308,90223,90278,90286,90198,90222,90221,90197,90205,90216,90220,90191,90277,91538,91539,90210,90233,91536,91537,90190,90182,90172,90276,90204,90215,90209,90232,90196,82561,90189,90268,90264,90266,90273,91311,91313,91315,90267,90274,85649,85650,85651,91312,91314,91316,90263,90270,90269,90275,90265,93356,93357,93358,94081,94082,94085,94088,94089,94090,94093,94095,94096,94097,94098,94099,94116,94117,94118,94165,94166,94167,94168,94169,94170,94171,94172,94173,94174,94175,94176)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
82561 nuie Wetroom Screen Support Arm - Chrome
85649 Hudson Reed Wetroom Screen Support Arm - Polished Chrome
85650 Hudson Reed Wetroom Screen Support Arm - Matt Black
85651 Hudson Reed Wetroom Screen Support Arm - Brushed Brass
85960 Hudson Reed 700mm Wetroom Screen With Arms and Feet - 8mm Glass - Polished Chrome
90172 nuie Fluted Wetroom Screens 300mmx1850mm Fluted Hinged Screen Including Support Bar - Polished Chrome
90173 nuie Fluted Wetroom Screens 800mmx1850mm Fluted Wetroom Screen Including Support Bar - Polished Chrome
90176 nuie Fluted Wetroom Screens 900mmx1850mm Fluted Wetroom Screen Including Support Bar - Polished Chrome
90182 Hudson Reed 300 x 1950mm Fluted Hinged Screen Including bar - Polished Chrome
90183 Hudson Reed Fluted Wetroom Screens 800mm x 1950mm Fluted Wetroom Screen Inc' Bar - Polished Chrome
90189 nuie Wetroom Return Screen 215 x 1850mm - 8mm Glass - Polished Chrome
90190 nuie Wetroom Hinged Screen 300 x 1850mm - 8mm Glass - Polished Chrome
90191 Hudson Reed Chrome Wetroom Swing Screen 300 x 1950mm - 8mm Glass - Polished Chrome
90192 Hudson Reed 1000mm Wetroom Screen & Support Bar - 8mm Glass - Polished Chrome
90196 Hudson Reed 215mm Wetroom Return Screen - 8mm Glass - Polished Chrome
90197 Hudson Reed 700mm Wetroom Screen & Support Bar - 8mm Glass - Polished Chrome
90198 Hudson Reed 800mm Wetroom Screen & Support Bar - 8mm Glass - Polished Chrome
90199 Hudson Reed 900mm Wetroom Screen & Support Bar - 8mm Glass - Polished Chrome
90204 Hudson Reed 215mm Return Screen With Brass Profile - 8mm Glass - Brushed Brass
90205 Hudson Reed 300mm Wetroom Swing Screen - 8mm Glass - Brushed Brass
90209 nuie 215mm Wetroom Return Screen - 8mm Glass - Matt Black
90210 nuie 300mm Wetroom Swing Screen - 8mm Glass - Matt Black
90215 Hudson Reed 215mm Return Screen With Black Profile - 8mm Glass - Polished Chrome
90216 Hudson Reed 300mm Wetroom Swing Screen - 8mm Glass - Matt Black
90220 nuie 700mm Wetroom Screen & Support Bar - 8mm Glass - Polished Chrome
90221 nuie 760mm Wetroom Screen & Support Bar - 8mm Glass - Polished Chrome
90222 nuie 800mm Wetroom Screen & Support Bar - 8mm Glass - Polished Chrome
90223 nuie 900mm Wetroom Screen & Support Bar - 8mm Glass - Polished Chrome
90224 nuie 1000mm Wetroom Screen & Support Bar - 8mm Glass - Polished Chrome
90225 nuie 1100mm Wetroom Screen & Support Bar - 8mm Glass - Polished Chrome
90232 nuie 215mm Wetroom Return Screen - 8mm Glass - Brushed Brass
90233 nuie 300mm Wetroom Swing Screen - 8mm Glass - Brushed Brass
90234 nuie 700mm Wetroom Screen With Support Bar - 8mm Glass - Brushed Brass
90235 nuie 760mm Wetroom Screen With Support Bar - 8mm Glass - Brushed Brass
90236 nuie 800mm Wetroom Screen With Support Bar - 8mm Glass - Brushed Brass
90239 nuie 700mm Wetroom Screen With Support Bar - 8mm Glass - Matt Black
90240 nuie 760mm Wetroom Screen With Support Bar - 8mm Glass - Matt Black
90241 nuie 800mm Wetroom Screen With Support Bar - 8mm Glass - Matt Black
90263 nuie Wetroom Screen Support Foot - Polished Chrome
90264 nuie 3000mm Wetroom Screen Ceiling Post - Polished Chrome
90265 Hudson Reed Wetroom Screen Horseshoe Support - Polished Chrome
90266 Hudson Reed Wetroom Wall Channel 1950mm Black - Matt Black
90267 RETURN SCREEN 'L' PROFILE Kit Black - Matt Black
90268 nuie Black Wetroom Screen Ceiling Post - Matt Black
90269 Hudson Reed Wetroom Screen Horseshoe Support Foot - Matt Black
90270 nuie Black Wetroom Foot and Wall Bracket - Matt Black
90273 Hudson Reed Wetroom Wall Channel 1950mm Brass - Brushed Brass
90274 Return Screen L Profile Kit 1950mm Brass - Brushed Brass
90275 Hudson Reed Wetroom Screen Horseshoe Support - Brushed Brass
90276 Hudson Reed 215mm Wetroom Return Screen - 8mm Glass - Matt Black
90277 Hudson Reed 300mm Wetroom Swing Screen - 8mm Glass - Matt Black
90278 Hudson Reed 700mm Framed Wetroom Screen - 8mm Glass - Matt Black
90286 Hudson Reed Abstract 700mm Frame Wetroom Screen - 8mm Glass - Matt Black
90287 Hudson Reed Abstract 760mm Frame Wetroom Screen - 8mm Glass - Matt Black
90308 Hudson Reed 800mm Arched Wetroom Screen - 8mm Glass - Matt Black
90309 Hudson Reed 900mm Arched Wetroom Screen - 8mm Glass - Matt Black
91311 Hudson Reed Wetroom Screen Accessories Flat Support Bar, 1202mm - Chrome
91312 Hudson Reed Wetroom Screen Accessories Support Arm T Piece, 19mm x 53mm x 53mm - Chrome
91313 Hudson Reed Wetroom Screen Accessories Flat Support Bar, 1202mm - Matt Black
91314 Hudson Reed Wetroom Screen Accessories Support Arm T Piece, 19mm x 53mm x 53mm - Matt Black
91315 Hudson Reed Wetroom Screen Accessories Flat Support Bar, 1202mm - Brushed Brass
91316 Hudson Reed Wetroom Screen Accessories Support Arm T Piece, 19mm x 53mm x 53mm - Brushed Brass
91536 nuie Fluted Wetroom Fluted Wetroom 8mm Toughened Safety Glass Swing Return Screen, 300mm x 1850mm - Brushed Brass
91537 nuie Fluted Wetroom Fluted Wetroom 8mm Toughened Safety Glass Swing Return Screen, 300mm x 1850mm - Matt Black
91538 Hudson Reed Fluted Wetroom Fluted Wetroom 8mm Toughened Safety Glass Swing Return Screen, 300mm x 1950mm - Brushed Brass
91539 Hudson Reed Fluted Wetroom Fluted Wetroom 8mm Toughened Safety Glass Swing Return Screen, 300mm x 1950mm - Matt Black
93356
93357
93358
94081
94082
94085
94088
94089
94090
94093
94095
94096
94097
94098
94099
94116
94117
94118
94165
94166
94167
94168
94169
94170
94171
94172
94173
94174
94175
94176