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, 90890, 90967, 90969, 
    89061, 89053, 85062, 85064, 85148, 
    85150, 85194, 85196, 85240, 85242, 
    86133, 86135, 86156, 86158, 86641, 
    86643, 86710, 86712, 85102, 85104, 
    82833, 82835, 82906, 82908, 82979, 
    82981, 83393, 83395, 83403, 83405, 
    89807, 89809, 89859, 89861, 89931, 
    89933, 91497, 91499, 85295, 85297, 
    85392, 85394, 85443, 85445, 85494
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00203

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 (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,90890,90967,90969,89061,89053,85062,85064,85148,85150,85194,85196,85240,85242,86133,86135,86156,86158,86641,86643,86710,86712,85102,85104,82833,82835,82906,82908,82979,82981,83393,83395,83403,83405,89807,89809,89859,89861,89931,89933,91497,91499,85295,85297,85392,85394,85443,85445,85494)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
82833 nuie Arno 1200mm Wall Hung 4-Drawer Vanity & Double Basin - Solace Oak
82835 nuie Arno 1200mm Wall Hung 4-Drawer Vanity & Double Basin - Solace Oak
82906 nuie Arno 1200mm Wall Hung 4-Drawer Vanity & Double Basin - Anthracite
82908 nuie Arno 1200mm Wall Hung 4-Drawer Vanity & Double Basin - Anthracite
82979 nuie Arno 1200mm Wall Hung 4-Drawer Vanity & Double Basin - Charcoal Black
82981 nuie Arno 1200mm Wall Hung 4-Drawer Vanity & Double Basin - Charcoal Black
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
83393 nuie Athena Wall Hung 4 Drawer Vanity With Twin Polymarble Basin 1200mm - Anthracite Woodgrain
83395 nuie Athena Wall Hung 4 Drawer Vanity With Twin Ceramic Basin 1200mm - Anthracite Woodgrain
83403 nuie Athena Wall Hung 4 Drawer Vanity With Twin Polymarble Basin 1200mm - Hacienda Black
83405 nuie Athena Wall Hung 4 Drawer Vanity With Twin Ceramic Basin 1200mm - Hacienda Black
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
85062 Hudson Reed Fluted 1200mm Wall Hung 4-Drawer Vanity and Double Basin - Satin Anthracite
85064 Hudson Reed Fluted 1200mm Wall Hung 4-Drawer Vanity and Double Basin - Satin Anthracite
85102 Hudson Reed Fluted 1200mm Wall Hung 4-Drawer Vanity and Double Basin - Satin White
85104 Hudson Reed Fluted 1200mm Wall Hung 4-Drawer Vanity and Double Basin - Satin White
85148 Hudson Reed Fluted 1200mm Wall Hung 4-Drawer Vanity and Double Basin - Satin Grey
85150 Hudson Reed Fluted 1200mm Wall Hung 4-Drawer Vanity and Double Basin - Satin Grey
85194 Hudson Reed Fluted 1200mm Wall Hung 4-Drawer Vanity and Double Basin - Satin Blue
85196 Hudson Reed Fluted 1200mm Wall Hung 4-Drawer Vanity and Double Basin - Satin Blue
85240 Hudson Reed Fluted 1200mm Wall Hung 4-Drawer Vanity and Double Basin - Satin Green
85242 Hudson Reed Fluted 1200mm Wall Hung 4-Drawer Vanity and Double Basin - Satin Green
85295 nuie Deco 1200mm Wall Hung 4-Drawer Vanity & Double Basin - Satin Anthracite
85297 nuie Deco 1200mm Wall Hung 4-Drawer Vanity & Double Basin - Satin Anthracite
85392 nuie Deco 1200mm Wall Hung 4-Drawer Vanity & Double Basin - Satin Grey
85394 nuie Deco 1200mm Wall Hung 4-Drawer Vanity & Double Basin - Satin Grey
85443 nuie Deco 1200mm Wall Hung 4-Drawer Vanity & Double Basin - Satin Blue
85445 nuie Deco 1200mm Wall Hung 4-Drawer Vanity & Double Basin - Satin Blue
85494 nuie Deco 1200mm Wall Hung 4-Drawer Vanity & Double Basin - Satin Green
86133 Hudson Reed Havana Wall Hung 4 Drawer Vanity Basin Unit & Double Polymarble Basin, 1200mm - Graphite Grey
86135 Hudson Reed Havana Wall Hung 4 Drawer Vanity Basin Unit & Double Ceramic Basin, 1200mm - Graphite Grey
86156 Hudson Reed Havana Wall Hung 4 Drawer Vanity Basin Unit & Double Polymarble Basin, 1200mm - Coastal Grey
86158 Hudson Reed Havana Wall Hung 4 Drawer Vanity Basin Unit & Double Ceramic Basin, 1200mm - Coastal 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
86641 Hudson Reed Juno 1200mm Wall Hung 4-Door Vanity & Double Basin - Graphite Grey
86643 Hudson Reed Juno 1200mm Wall Hung 4-Door Vanity & Double Basin - Graphite Grey
86710 Hudson Reed Juno 1200mm Wall Hung 4-Door Vanity & Double Basin - Coastal Grey
86712 Hudson Reed Juno 1200mm Wall Hung 4-Door Vanity & Double Basin - Coastal Grey
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
89053 Hudson Reed Quartet Wall Hung 4 Drawer Double Cabinet with Twin Polymarble Basin 1440mm - Gloss White
89057 Hudson Reed Quartet Wall Hung 4 Drawer Double Cabinet with Twin Polymarble Basin 1440mm - Gloss Grey
89061 Hudson Reed Quartet Wall Hung 4 Drawer Double Cabinet with Twin Polymarble Basin 1440mm - Hacienda Black
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
89807 Hudson Reed Urban 1200mm Wall Hung 4-Drawer Vanity & Double Polymarble Basin - Satin Grey
89809 Hudson Reed Urban 1200mm Wall Hung 4-Drawer Vanity & Double Ceramic Basin - Satin Grey
89859 Hudson Reed Urban 1200mm Wall Hung 4-Drawer Vanity & Double Polymarble Basin - Satin Blue
89861 Hudson Reed Urban 1200mm Wall Hung 4-Drawer Vanity & Double Ceramic Basin - Satin Blue
89931 Hudson Reed Urban 1200mm Wall Hung 4-Drawer Vanity and Double Basin - Satin Green
89933 Hudson Reed Urban 1200mm Wall Hung 4-Drawer Vanity and Double Basin - Satin Green
90888 nuie Arno Wall Hung 4 Drawer Vanity & Double Polymarble Basin, 1200mm - Satin Anthracite
90890 nuie Arno Wall Hung 4 Drawer Vanity & Double Ceramic Basin, 1200mm - Satin Anthracite
90967 nuie Arno Wall Hung 4 Drawer Vanity & Double Polymarble Basin, 1200mm - Satin Grey
90969 nuie Arno Wall Hung 4 Drawer Vanity & Double Ceramic Basin, 1200mm - Satin Grey
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
91497 Hudson Reed Urban Wall Hung 4 Drawer Vanity & Double Polymarble Basin, 1200mm - Satin Anthracite
91499 Hudson Reed Urban Wall Hung 4 Drawer Vanity & Double Ceramic Basin, 1200mm - Satin Anthracite