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 (
    90788, 90790, 90789, 90791, 90784, 90786, 
    90774, 90772, 90785, 90787, 90780, 
    90782, 90775, 87367, 90781, 90783, 
    90773, 90776, 90778, 87366, 87365, 
    90777, 90779, 87354, 90770, 87364, 
    82550, 90768, 87352, 87353, 90771, 
    87358, 87378, 82548, 90769, 87380, 
    87357, 87376, 87377, 90766, 90767, 
    87374, 90150, 90165, 87379, 84073, 
    84081, 82509, 87373, 82508, 90149, 
    90164, 90764, 90765, 90142, 90157, 
    90762, 90763, 90148, 90163, 82531, 
    87369, 84072, 84080, 82541, 90759, 
    90147, 90162, 82440, 87368, 87363, 
    84071, 84079, 84095, 90141, 90156, 
    90297, 90304, 82539, 82530, 84057, 
    84065, 82439, 82549, 87362, 84070, 
    84078, 90758, 90760, 90761, 85973, 
    87361, 87356, 84069, 84077, 82540
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00154

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 (90788,90790,90789,90791,90784,90786,90774,90772,90785,90787,90780,90782,90775,87367,90781,90783,90773,90776,90778,87366,87365,90777,90779,87354,90770,87364,82550,90768,87352,87353,90771,87358,87378,82548,90769,87380,87357,87376,87377,90766,90767,87374,90150,90165,87379,84073,84081,82509,87373,82508,90149,90164,90764,90765,90142,90157,90762,90763,90148,90163,82531,87369,84072,84080,82541,90759,90147,90162,82440,87368,87363,84071,84079,84095,90141,90156,90297,90304,82539,82530,84057,84065,82439,82549,87362,84070,84078,90758,90760,90761,85973,87361,87356,84069,84077,82540)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}