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 (
    89550, 83087, 89437, 91289, 84262, 84266, 
    90120, 89157, 89548, 90092, 90102, 
    90111, 82329, 86813, 86847, 89100, 
    89199, 82397, 86850, 83114, 83124, 
    83133, 89728, 89733, 90119, 83085, 
    89121, 89162, 89553, 83142
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00070

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "13.52"
    },
    "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": 30,
      "rows_produced_per_join": 30,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "10.52",
        "eval_cost": "3.00",
        "prefix_cost": "13.52",
        "data_read_per_join": "114K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_product_descriptions`.`product_id` in (89550,83087,89437,91289,84262,84266,90120,89157,89548,90092,90102,90111,82329,86813,86847,89100,89199,82397,86850,83114,83124,83133,89728,89733,90119,83085,89121,89162,89553,83142)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
82329 Hudson Reed Tec Pura Triple Thermostatic Shower Valve - Chrome
82397 Hudson Reed Tec Pura Twin Thermostatic Shower Valve - Matt Black
83085 Hudson Reed Art Twin Thermostatic Shower Valve With Diverter - Chrome
83087 Hudson Reed Art Triple Thermostatic Shower Valve - Chrome
83114 nuie Arvan Triple Thermostatic Valve - Matt Black
83124 nuie Arvan Triple Thermostatic Valve - Gunmetal
83133 nuie Arvan Triple Thermostatic Valve - Brushed Brass
83142 nuie Arvan Triple Thermostatic Valve With Diverter - Chrome
84262 Old London Black Topaz Twin Concealed Shower Valve - Chrome / Black
84266 Old London Black Topaz Twin Exposed Shower Valve - Chrome / Black
86813 nuie Square Showers Triple Thermostatic Shower Valve - Chrome
86847 Hudson Reed Tec Crosshead Triple Thermostatic Shower Valve - Chrome
86850 Hudson Reed Tec Crosshead Twin Thermostatic Shower Valve - Matt Black
89100 nuie Round Showers Triple Thermostatic Shower Valve - Chrome
89121 Hudson Reed Reign Twin Valve With Diverter - Chrome
89157 Hudson Reed Indus Twin Thermostatic Shower Valve With Diverter - Chrome
89162 Hudson Reed Round Valves Twin Valve with Diverter - Chrome
89199 nuie Sanford Triple Thermostatic Valve With Diverter - Chrome
89437 Hudson Reed Industrial Valves Twin Valve with Diverter - Chrome
89548 Hudson Reed Lennox Twin Thermostatic Shower Valve With Diverter - Chrome
89550 Hudson Reed Square Valves Triple Valve - Chrome
89553 Hudson Reed Square Valves Twin Valve with Diverter - Chrome
89728 Old London White Topaz Twin Thermostatic Shower Valve - Chrome / White
89733 Old London White Topaz Twin Thermostatic Shower Valve - Chrome / White
90092 nuie Windon Triple Thermostatic Valve - Matt Black
90102 nuie Windon Triple Thermostatic Valve - Gunmetal
90111 nuie Windon Triple Thermostatic Valve - Brushed Brass
90119 nuie Windon Triple Thermostatic Valve - Chrome
90120 nuie Windon Triple Thermostatic Valve With Diverter - Chrome
91289 nuie Aztec Triple Thermostatic Concealed Shower Valve - 2 Outlet - Matt Black