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 (
    89173, 90321, 90322, 90325, 90324, 90326, 
    90323, 90329, 90330, 90331, 90333, 
    90334, 90337, 90338, 90339, 90340, 
    90341, 90342, 90345, 90346, 90347, 
    90348, 90328, 90332, 90335, 90336, 
    90343, 90344, 90327, 90317, 90319, 
    90320, 87388, 87387, 87389, 87383, 
    87384, 89612, 89613, 87386, 87382, 
    89611, 94119, 94120, 94121, 94122, 
    94123, 94124, 94125, 94126, 94127, 
    94128, 94129, 94130, 94131, 94132, 
    94133, 94134, 94135, 94136, 94137, 
    94138, 94139, 94457, 94839, 94840, 
    94841, 95319, 95365, 95366, 95367, 
    95368, 95369, 95370, 95371, 95372, 
    95373, 95374, 95375, 95377, 95927, 
    95928, 95929, 95930, 95931, 96494, 
    96495, 96496, 96497, 96498, 96499, 
    96500, 96501, 96502, 96503, 96504
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00158

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 (89173,90321,90322,90325,90324,90326,90323,90329,90330,90331,90333,90334,90337,90338,90339,90340,90341,90342,90345,90346,90347,90348,90328,90332,90335,90336,90343,90344,90327,90317,90319,90320,87388,87387,87389,87383,87384,89612,89613,87386,87382,89611,94119,94120,94121,94122,94123,94124,94125,94126,94127,94128,94129,94130,94131,94132,94133,94134,94135,94136,94137,94138,94139,94457,94839,94840,94841,95319,95365,95366,95367,95368,95369,95370,95371,95372,95373,95374,95375,95377,95927,95928,95929,95930,95931,96494,96495,96496,96497,96498,96499,96500,96501,96502,96503,96504)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}