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 (
    91372, 91374, 91371, 91373, 91370, 91381, 
    91383, 91369, 91368, 91379, 91382, 
    91384, 91351, 91353, 91367, 91377, 
    91380, 91349, 91352, 91354, 91378, 
    91347, 91350, 91348, 91361, 91363, 
    91391, 91393, 91362, 91364, 91392, 
    91394, 91359, 91389, 91360, 91357, 
    91387, 91358, 91390, 91388, 96213, 
    96214, 96215, 96216, 96217, 96218, 
    96219, 96220, 96221, 96222, 96223, 
    96224, 96225, 96226, 96227, 96228, 
    96229, 96230, 96231, 96232, 96233, 
    96234, 96235, 96236, 96237, 96238, 
    96239, 96240, 96241, 96242, 96243, 
    96244, 96334, 96336, 96338, 96340, 
    98722, 98723, 98724, 98725, 98726, 
    98727, 98728, 98729, 98730, 98731, 
    98732, 98733, 98734, 98735, 98736, 
    98737, 98750, 98751, 98752, 98753
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00243

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 (91372,91374,91371,91373,91370,91381,91383,91369,91368,91379,91382,91384,91351,91353,91367,91377,91380,91349,91352,91354,91378,91347,91350,91348,91361,91363,91391,91393,91362,91364,91392,91394,91359,91389,91360,91357,91387,91358,91390,91388,96213,96214,96215,96216,96217,96218,96219,96220,96221,96222,96223,96224,96225,96226,96227,96228,96229,96230,96231,96232,96233,96234,96235,96236,96237,96238,96239,96240,96241,96242,96243,96244,96334,96336,96338,96340,98722,98723,98724,98725,98726,98727,98728,98729,98730,98731,98732,98733,98734,98735,98736,98737,98750,98751,98752,98753)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
91347 nuie Kitchen Taps Churni Mono Basin Twin Lever Square Basin Tap - Chrome
91348 nuie Kitchen Taps Churni Mono Basin Single Lever Square Basin Tap - Chrome
91349 nuie Kitchen Taps Churni Mono Basin Twin Lever Square Basin Tap - Matt Black
91350 nuie Kitchen Taps Churni Mono Basin Single Lever Square Basin Tap - Matt Black
91351 nuie Kitchen Taps Churni Mono Basin Twin Lever Square Basin Tap - Brushed Nickel
91352 nuie Kitchen Taps Churni Mono Basin Single Lever Square Basin Tap - Brushed Nickel
91353 nuie Kitchen Taps Churni Mono Basin Twin Lever Square Basin Tap - Brushed Brass
91354 nuie Kitchen Taps Churni Mono Basin Single Lever Square Basin Tap - Brushed Brass
91357 nuie Kitchen Taps Lachen Mono Basin Twin Lever Round Basin Tap - Chrome
91358 nuie Kitchen Taps Lachen Mono Basin Single Lever Round Basin Tap - Chrome
91359 nuie Kitchen Taps Lachen Mono Basin Twin Lever Round Basin Tap - Matt Black
91360 nuie Kitchen Taps Lachen Mono Basin Single Lever Round Basin Tap - Matt Black
91361 nuie Kitchen Taps Lachen Mono Basin Twin Lever Round Basin Tap - Brushed Nickel
91362 nuie Kitchen Taps Lachen Mono Basin Single Lever Round Basin Tap - Brushed Nickel
91363 nuie Kitchen Taps Lachen Mono Basin Twin Lever Round Basin Tap - Brushed Brass
91364 nuie Kitchen Taps Lachen Mono Basin Single Lever Round Basin Tap - Brushed Brass
91367 nuie Kitchen Taps Ravi Mono Basin Twin Lever Round Basin Tap & Rinser - Chrome
91368 nuie Kitchen Taps Ravi Mono Basin Single Lever Round Basin Tap & Rinser - Chrome
91369 nuie Kitchen Taps Ravi Mono Basin Twin Lever Round Basin Tap & Rinser - Matt Black
91370 nuie Kitchen Taps Ravi Mono Basin Single Lever Round Basin Tap & Rinser - Matt Black
91371 nuie Kitchen Taps Ravi Mono Basin Twin Lever Round Basin Tap & Rinser - Brushed Nickel
91372 nuie Kitchen Taps Ravi Mono Basin Single Lever Round Basin Tap & Rinser - Brushed Nickel
91373 nuie Kitchen Taps Ravi Mono Basin Twin Lever Round Basin Tap & Rinser - Brushed Brass
91374 nuie Kitchen Taps Ravi Mono Basin Single Lever Round Basin Tap & Rinser - Brushed Brass
91377 nuie Kitchen Taps Samir Mono Basin Twin Lever Round Basin Tap & Rinser - Chrome
91378 nuie Kitchen Taps Samir Mono Basin Single Lever Round Basin Tap & Rinser - Chrome
91379 nuie Kitchen Taps Samir Mono Basin Twin Lever Round Basin Tap & Rinser - Matt Black
91380 nuie Kitchen Taps Samir Mono Basin Single Lever Round Basin Tap & Rinser - Matt Black
91381 nuie Kitchen Taps Samir Mono Basin Twin Lever Round Basin Tap & Rinser - Brushed Nickel
91382 nuie Kitchen Taps Samir Mono Basin Single Lever Round Basin Tap & Rinser - Brushed Nickel
91383 nuie Kitchen Taps Samir Mono Basin Twin Lever Round Basin Tap & Rinser - Brushed Brass
91384 nuie Kitchen Taps Samir Mono Basin Single Lever Round Basin Tap & Rinser - Brushed Brass
91387 nuie Kitchen Taps Kosi Mono Basin Twin Lever Square Basin Tap & Rinser - Chrome
91388 nuie Kitchen Taps Kosi Mono Basin Single Lever Square Basin Tap & Rinser - Chrome
91389 nuie Kitchen Taps Kosi Mono Basin Twin Lever Square Basin Tap & Rinser - Matt Black
91390 nuie Kitchen Taps Kosi Mono Basin Single Lever Square Basin Tap & Rinser - Matt Black
91391 nuie Kitchen Taps Kosi Mono Basin Twin Lever Square Basin Tap & Rinser - Brushed Nickel
91392 nuie Kitchen Taps Kosi Mono Basin Single Lever Square Basin Tap & Rinser - Brushed Nickel
91393 nuie Kitchen Taps Kosi Mono Basin Twin Lever Square Basin Tap & Rinser - Brushed Brass
91394 nuie Kitchen Taps Kosi Mono Basin Single Lever Square Basin Tap & Rinser - Brushed Brass
96213
96214
96215
96216
96217
96218
96219
96220
96221
96222
96223
96224
96225
96226
96227
96228
96229
96230
96231
96232
96233
96234
96235
96236
96237
96238
96239
96240
96241
96242
96243
96244
96334
96336
96338
96340
98722
98723
98724
98725
98726
98727
98728
98729
98730
98731
98732
98733
98734
98735
98736
98737
98750
98751
98752
98753