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 (
    87078, 87123, 87124, 87125, 87126, 87127, 
    87128, 87129, 86906, 86907, 86908, 
    86909, 86910, 86911, 86967, 86968, 
    86969, 86970, 86971, 86972, 87028, 
    87029, 87030, 87031, 87032, 87033, 
    87087, 87088, 87089, 87090, 87091, 
    87092, 86920, 86921, 86922, 86923, 
    86924, 86925, 86926, 86981, 86982, 
    86983, 86984, 86985, 86986, 86987, 
    87042, 87043, 87044, 87045, 87046, 
    87047, 87048, 87100, 87101, 87102, 
    87103, 87104, 87105, 87106, 86913, 
    86914, 86915, 86916, 86917, 86918, 
    86919, 86974, 86975, 86976, 86977, 
    86978, 86979, 86980, 87035, 87036, 
    87037, 87038, 87039, 87040, 87041, 
    87093, 87094, 87095, 87096, 87097, 
    87098, 87099, 91014, 91026, 91038, 
    91051, 86904, 86929, 86965, 86990
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00176

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 (87078,87123,87124,87125,87126,87127,87128,87129,86906,86907,86908,86909,86910,86911,86967,86968,86969,86970,86971,86972,87028,87029,87030,87031,87032,87033,87087,87088,87089,87090,87091,87092,86920,86921,86922,86923,86924,86925,86926,86981,86982,86983,86984,86985,86986,86987,87042,87043,87044,87045,87046,87047,87048,87100,87101,87102,87103,87104,87105,87106,86913,86914,86915,86916,86917,86918,86919,86974,86975,86976,86977,86978,86979,86980,87035,87036,87037,87038,87039,87040,87041,87093,87094,87095,87096,87097,87098,87099,91014,91026,91038,91051,86904,86929,86965,86990)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
86904 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole Ceramic Basin 1000mm - Storm Grey
86906 Old London Floor Standing 3 Door Angled Vanity Unit with 3 Tap Hole Grey Marble Top 750mm - Storm Grey
86907 Old London Floor Standing 3 Door Angled Vanity Unit with 3 Tap Hole White Marble Top 750mm - Storm Grey
86908 Old London Floor Standing 3 Door Angled Vanity Unit with 3 Tap Hole Black Marble Top 750mm - Storm Grey
86909 Old London Floor Standing 3 Door Angled Vanity Unit with 1 Tap Hole Grey Marble Top 750mm - Storm Grey
86910 Old London Floor Standing 3 Door Angled Vanity Unit with 1 Tap Hole White Marble Top 750mm - Storm Grey
86911 Old London Floor Standing 3 Door Angled Vanity Unit with 1 Tap Hole Black Marble Top 750mm - Storm Grey
86913 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole Black Marble Top 600mm - Storm Grey
86914 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole White Marble Top 600mm - Storm Grey
86915 Old London Old London Storm Grey Floor Standing 2 Door Vanity Basin Unit with Square Basin & 1 Tap Hole Marble Top, 600mm - Storm Grey
86916 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole Grey Marble Top 600mm - Storm Grey
86917 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole Black Marble Top 600mm - Storm Grey
86918 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole White Marble Top 600mm - Storm Grey
86919 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole Grey Marble Top 600mm - Storm Grey
86920 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole Black Marble Top 800mm - Storm Grey
86921 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole White Marble Top 800mm - Storm Grey
86922 Old London Old London Storm Grey Floor Standing 2 Door Vanity Basin Unit with Square Basin & 1 Tap Hole Marble Top, 800mm - Storm Grey
86923 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole Grey Marble Top 800mm - Storm Grey
86924 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole Black Marble Top 800mm - Storm Grey
86925 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole White Marble Top 800mm - Storm Grey
86926 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole Grey Marble Top 800mm - Storm Grey
86929 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole Ceramic Basin 1000mm - Storm Grey
86965 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole Ceramic Basin 1000mm - Twilight Blue
86967 Old London Floor Standing 3 Door Angled Vanity Unit with 3 Tap Hole Grey Marble Top 750mm - Twilight Blue
86968 Old London Floor Standing 3 Door Angled Vanity Unit with 3 Tap Hole White Marble Top 750mm - Twilight Blue
86969 Old London Floor Standing 3 Door Angled Vanity Unit with 3 Tap Hole Black Marble Top 750mm - Twilight Blue
86970 Old London Floor Standing 3 Door Angled Vanity Unit with 1 Tap Hole Grey Marble Top 750mm - Twilight Blue
86971 Old London Floor Standing 3 Door Angled Vanity Unit with 1 Tap Hole White Marble Top 750mm - Twilight Blue
86972 Old London Floor Standing 3 Door Angled Vanity Unit with 1 Tap Hole Black Marble Top 750mm - Twilight Blue
86974 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole Black Marble Top 600mm - Twilight Blue
86975 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole White Marble Top 600mm - Twilight Blue
86976 Old London Old London Twilight Blue Floor Standing 2 Door Vanity Basin Unit with Square Basin & 1 Tap Hole Marble Top, 600mm - Twilight Blue
86977 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole Grey Marble Top 600mm - Twilight Blue
86978 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole Black Marble Top 600mm - Twilight Blue
86979 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole White Marble Top 600mm - Twilight Blue
86980 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole Grey Marble Top 600mm - Twilight Blue
86981 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole Black Marble Top 800mm - Twilight Blue
86982 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole White Marble Top 800mm - Twilight Blue
86983 Old London Old London Twilight Blue Floor Standing 2 Door Vanity Basin Unit with Square Basin & 1 Tap Hole Marble Top, 800mm - Twilight Blue
86984 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole Grey Marble Top 800mm - Twilight Blue
86985 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole Black Marble Top 800mm - Twilight Blue
86986 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole White Marble Top 800mm - Twilight Blue
86987 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole Grey Marble Top 800mm - Twilight Blue
86990 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole Ceramic Basin 1000mm - Twilight Blue
87028 Old London Floor Standing 3 Door Angled Vanity Unit with 3 Tap Hole Grey Marble Top 750mm - Timeless Sand
87029 Old London Floor Standing 3 Door Angled Vanity Unit with 3 Tap Hole White Marble Top 750mm - Timeless Sand
87030 Old London Floor Standing 3 Door Angled Vanity Unit with 3 Tap Hole Black Marble Top 750mm - Timeless Sand
87031 Old London Floor Standing 3 Door Angled Vanity Unit with 1 Tap Hole Grey Marble Top 750mm - Timeless Sand
87032 Old London Floor Standing 3 Door Angled Vanity Unit with 1 Tap Hole White Marble Top 750mm - Timeless Sand
87033 Old London Floor Standing 3 Door Angled Vanity Unit with 1 Tap Hole Black Marble Top 750mm - Timeless Sand
87035 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole Black Marble Top 600mm - Timeless Sand
87036 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole White Marble Top 600mm - Timeless Sand
87037 Old London Old London Timeless Sand Floor Standing 2 Door Vanity Basin Unit with Square Basin & 1 Tap Hole Marble Top, 600mm - Timeless Sand
87038 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole Grey Marble Top 600mm - Timeless Sand
87039 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole Black Marble Top 600mm - Timeless Sand
87040 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole White Marble Top 600mm - Timeless Sand
87041 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole Grey Marble Top 600mm - Timeless Sand
87042 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole Black Marble Top 800mm - Timeless Sand
87043 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole White Marble Top 800mm - Timeless Sand
87044 Old London Old London Timeless Sand Floor Standing 2 Door Vanity Basin Unit with Square Basin & 1 Tap Hole Marble Top, 800mm - Timeless Sand
87045 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole Grey Marble Top 800mm - Timeless Sand
87046 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole Black Marble Top 800mm - Timeless Sand
87047 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole White Marble Top 800mm - Timeless Sand
87048 Old London Floor Standing 2 Door Vanity Unit with 3 Tap Hole Grey Marble Top 800mm - Timeless Sand
87078 Old London Floor Standing 2 Door Vanity Unit with 1 Tap Hole Grey Marble Top 1000mm - Timeless Sand
87087 Old London Floor Standing 3 Door Vanity Unit with 3 Tap Hole Grey Marble Top 1000mm - Hunter Green
87088 Old London Floor Standing 3 Door Vanity Unit with 3 Tap Hole White Marble Top 1000mm - Hunter Green
87089 Old London Floor Standing 3 Door Vanity Unit with 3 Tap Hole Black Marble Top 1000mm - Hunter Green
87090 Old London Floor Standing 3 Door Vanity Unit with 1 Tap Hole Grey Marble Top 1000mm - Hunter Green
87091 Old London Floor Standing 3 Door Vanity Unit with 1 Tap Hole White Marble Top 1000mm - Hunter Green
87092 Old London Floor Standing 3 Door Vanity Unit with 1 Tap Hole Black Marble Top 1000mm - Hunter Green
87093 Old London Floor Standing 3 Door Vanity Unit with 1 Tap Hole Black Marble Top 600mm - Hunter Green
87094 Old London Floor Standing 3 Door Vanity Unit with 1 Tap Hole White Marble Top 600mm - Hunter Green
87095 Old London Old London Hunter Green Floor Standing 4 Door Vanity Basin Unit with Square Basin & 1 Tap Hole Marble Top, 1200mm - Hunter Green
87096 Old London Floor Standing 3 Door Vanity Unit with 1 Tap Hole Grey Marble Top 600mm - Hunter Green
87097 Old London Floor Standing 3 Door Vanity Unit with 3 Tap Hole Black Marble Top 600mm - Hunter Green
87098 Old London Floor Standing 3 Door Vanity Unit with 3 Tap Hole White Marble Top 600mm - Hunter Green
87099 Old London Floor Standing 3 Door Vanity Unit with 3 Tap Hole Grey Marble Top 600mm - Hunter Green
87100 Old London Floor Standing 3 Door Vanity Unit with 1 Tap Hole Black Marble Top 800mm - Hunter Green
87101 Old London Floor Standing 3 Door Vanity Unit with 1 Tap Hole White Marble Top 800mm - Hunter Green
87102 Old London Old London Hunter Green Floor Standing 2 Door Vanity Basin Unit with Square Basin & 1 Tap Hole Marble Top, 600mm - Hunter Green
87103 Old London Floor Standing 3 Door Vanity Unit with 1 Tap Hole Grey Marble Top 800mm - Hunter Green
87104 Old London Floor Standing 3 Door Vanity Unit with 3 Tap Hole Black Marble Top 800mm - Hunter Green
87105 Old London Floor Standing 3 Door Vanity Unit with 3 Tap Hole White Marble Top 800mm - Hunter Green
87106 Old London Floor Standing 3 Door Vanity Unit with 3 Tap Hole Grey Marble Top 800mm - Hunter Green
87123 Old London Floor Standing 4 Door Vanity Unit with 1 Tap Hole Black Marble Top 1000mm - Hunter Green
87124 Old London Floor Standing 4 Door Vanity Unit with 1 Tap Hole White Marble Top 1000mm - Hunter Green
87125 Old London Old London Hunter Green Floor Standing 2 Door Vanity Basin Unit with Square Basin & 1 Tap Hole Marble Top, 800mm - Hunter Green
87126 Old London Floor Standing 4 Door Vanity Unit with 1 Tap Hole Grey Marble Top 1000mm - Hunter Green
87127 Old London Floor Standing 4 Door Vanity Unit with 3 Tap Hole Black Marble Top 1000mm - Hunter Green
87128 Old London Floor Standing 4 Door Vanity Unit with 3 Tap Hole White Marble Top 1000mm - Hunter Green
87129 Old London Floor Standing 4 Door Vanity Unit with 3 Tap Hole Grey Marble Top 1000mm - Hunter Green
91014 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & Single Bowl 1 Tap Hole Marble Top, 800mm - Satin White/White
91026 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & Single Bowl 1 Tap Hole Marble Top, 800mm - Cool Grey/White
91038 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & Single Bowl 1 Tap Hole Marble Top, 800mm - Indigo Blue/White
91051 Hudson Reed Bexley Floor Standing 2 Door 1 Shelf Vanity & Single Bowl 1 Tap Hole Marble Top, 800mm - Matt Green/White