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 (
    91115, 91117, 91121, 91123, 91126, 91128, 
    91130, 91201, 91203, 91207, 91209, 
    91212, 91214, 91216, 91256, 91258, 
    91262, 91264, 91267, 91269, 91271, 
    91146, 91148, 91152, 91154, 91157, 
    91159, 91161, 89057, 86179, 86181, 
    86202, 86204, 86503, 86505, 86779, 
    86781, 89204, 89205, 89217, 89218, 
    89230, 89231, 83052, 83054, 83601, 
    83603, 90888
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00110

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "21.63"
    },
    "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": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "16.83",
        "eval_cost": "4.80",
        "prefix_cost": "21.63",
        "data_read_per_join": "183K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_product_descriptions`.`product_id` in (91115,91117,91121,91123,91126,91128,91130,91201,91203,91207,91209,91212,91214,91216,91256,91258,91262,91264,91267,91269,91271,91146,91148,91152,91154,91157,91159,91161,89057,86179,86181,86202,86204,86503,86505,86779,86781,89204,89205,89217,89218,89230,89231,83052,83054,83601,83603,90888)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
83052 nuie Arno 1200mm Wall Hung 4-Drawer Vanity & Double Basin - Satin Green
83054 nuie Arno 1200mm Wall Hung 4-Drawer Vanity & Double Basin - Satin Green
83601 nuie Athena Wall Hung 4 Drawer Vanity With Twin Polymarble Basin 1200mm - Gloss Grey
83603 nuie Athena Wall Hung 4 Drawer Vanity With Twin Ceramic Basin 1200mm - Gloss Grey
86179 Hudson Reed Havana Wall Hung 4 Drawer Vanity Basin Unit & Double Polymarble Basin, 1200mm - Metallic Slate
86181 Hudson Reed Havana Wall Hung 4 Drawer Vanity Basin Unit & Double Ceramic Basin, 1200mm - Metallic Slate
86202 Hudson Reed Havana Wall Hung 4 Drawer Vanity Basin Unit & Double Polymarble Basin, 1200mm - Autumn Oak
86204 Hudson Reed Havana Wall Hung 4 Drawer Vanity Basin Unit & Double Ceramic Basin, 1200mm - Autumn Oak
86503 Hudson Reed Juno 1200mm Wall Hung 4-Door Vanity & Double Basin - Autumn Oak
86505 Hudson Reed Juno 1200mm Wall Hung 4-Door Vanity & Double Basin - Autumn Oak
86779 Hudson Reed Juno Wall Hung 4 Drawer Vanity Basin Unit & Double Polymarble Basin, 1200mm - Metallic Slate
86781 Hudson Reed Juno Wall Hung 4 Drawer Vanity Basin Unit & Double Ceramic Basin, 1200mm - Metallic Slate
89057 Hudson Reed Quartet Wall Hung 4 Drawer Double Cabinet with Twin Polymarble Basin 1440mm - Gloss Grey
89204 Hudson Reed Sarenna Wall Hung Left Hand 2 Drawer 1 Door Vanity Unit with Polymarble Basin 1000mm - Moon White
89205 Hudson Reed Sarenna Wall Hung Right Hand 2 Drawer 1 Door Vanity Unit with Polymarble Basin 1000mm - Moon White
89217 Hudson Reed Sarenna Wall Hung Left Hand 2 Drawer 1 Door Vanity Unit with Polymarble Basin 1000mm - Dove Grey
89218 Hudson Reed Sarenna Wall Hung Right Hand 2 Drawer 1 Door Vanity Unit with Polymarble Basin 1000mm - Dove Grey
89230 Hudson Reed Sarenna Wall Hung Left Hand 2 Drawer 1 Door Vanity Unit with Polymarble Basin 1000mm - Mineral Blue
89231 Hudson Reed Sarenna Wall Hung Right Hand 2 Drawer 1 Door Vanity Unit with Polymarble Basin 1000mm - Mineral Blue
90888 nuie Arno Wall Hung 4 Drawer Vanity & Double Polymarble Basin, 1200mm - Satin Anthracite
91115 nuie Classique Wall Hung 2 Drawer Unit & 1 Tap Hole Marble Top with Oval Basin, 1200mm - Satin Anthracite/Black
91117 nuie Classique Wall Hung 2 Drawer Unit & 3 Tap Hole Marble Top with Oval Basin, 1200mm - Satin Anthracite/Black
91121 nuie Classique Wall Hung 2 Drawer Unit & 1 Tap Hole Marble Top with Oval Basin, 1200mm - Satin Anthracite/Grey
91123 nuie Classique Wall Hung 2 Drawer Unit & 3 Tap Hole Marble Top with Oval Basin, 1200mm - Satin Anthracite/Grey
91126 nuie Classique Wall Hung 2 Drawer Unit & 1 Tap Hole Marble Top with Oval Basin, 1200mm - Satin Anthracite/White
91128 nuie Classique Wall Hung 2 Drawer Unit & 3 Tap Hole Marble Top with Oval Basin, 1200mm - Satin Anthracite/White
91130 nuie Classique Wall Hung 2 Drawer Unit & 1 Tap Hole Marble Top with Square Basin, 1200mm - Satin Anthracite/White
91146 nuie Classique Wall Hung 2 Drawer Unit & 1 Tap Hole Marble Top with Oval Basin, 1200mm - Satin White/Black
91148 nuie Classique Wall Hung 2 Drawer Unit & 3 Tap Hole Marble Top with Oval Basin, 1200mm - Satin White/Black
91152 nuie Classique Wall Hung 2 Drawer Unit & 1 Tap Hole Marble Top with Oval Basin, 1200mm - Satin White/Grey
91154 nuie Classique Wall Hung 2 Drawer Unit & 3 Tap Hole Marble Top with Oval Basin, 1200mm - Satin White/Grey
91157 nuie Classique Wall Hung 2 Drawer Unit & 1 Tap Hole Marble Top with Oval Basin, 1200mm - Satin White/White
91159 nuie Classique Wall Hung 2 Drawer Unit & 3 Tap Hole Marble Top with Oval Basin, 1200mm - Satin White/White
91161 nuie Classique Wall Hung 2 Drawer Unit & 1 Tap Hole Marble Top with Square Basin, 1200mm - Satin White/White
91201 nuie Classique Wall Hung 2 Drawer Unit & 1 Tap Hole Marble Top with Oval Basin, 1200mm - Satin Grey/Black
91203 nuie Classique Wall Hung 2 Drawer Unit & 3 Tap Hole Marble Top with Oval Basin, 1200mm - Satin Grey/Black
91207 nuie Classique Wall Hung 2 Drawer Unit & 1 Tap Hole Marble Top with Oval Basin, 1200mm - Satin Grey/Grey
91209 nuie Classique Wall Hung 2 Drawer Unit & 3 Tap Hole Marble Top with Oval Basin, 1200mm - Satin Grey/Grey
91212 nuie Classique Wall Hung 2 Drawer Unit & 1 Tap Hole Marble Top with Oval Basin, 1200mm - Satin Grey/White
91214 nuie Classique Wall Hung 2 Drawer Unit & 3 Tap Hole Marble Top with Oval Basin, 1200mm - Satin Grey/White
91216 nuie Classique Wall Hung 2 Drawer Unit & 1 Tap Hole Marble Top with Square Basin, 1200mm - Satin Grey/White
91256 nuie Classique Wall Hung 2 Drawer Unit & 1 Tap Hole Marble Top with Oval Basin, 1200mm - Satin Green/Black
91258 nuie Classique Wall Hung 2 Drawer Unit & 3 Tap Hole Marble Top with Oval Basin, 1200mm - Satin Green/Black
91262 nuie Classique Wall Hung 2 Drawer Unit & 1 Tap Hole Marble Top with Oval Basin, 1200mm - Satin Green/Grey
91264 nuie Classique Wall Hung 2 Drawer Unit & 3 Tap Hole Marble Top with Oval Basin, 1200mm - Satin Green/Grey
91267 nuie Classique Wall Hung 2 Drawer Unit & 1 Tap Hole Marble Top with Oval Basin, 1200mm - Satin Green/White
91269 nuie Classique Wall Hung 2 Drawer Unit & 3 Tap Hole Marble Top with Oval Basin, 1200mm - Satin Green/White
91271 nuie Classique Wall Hung 2 Drawer Unit & 1 Tap Hole Marble Top with Square Basin, 1200mm - Satin Green/White