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 (
    86936, 86937, 86938, 86939, 86940, 86941, 
    86942, 86997, 86998, 86999, 87000, 
    87001, 87002, 87003, 87058, 87059, 
    87060, 87061, 87062, 87063, 87064, 
    87116, 87117, 87118, 87119, 87120, 
    87121, 87122, 86930, 86931, 86932, 
    86933, 86934, 86935, 86991, 86992, 
    86993, 86994, 86995, 86996, 87052, 
    87053, 87054, 87055, 87056, 87057, 
    87110, 87111, 87112, 87113, 87114, 
    87115, 86957, 86958, 86959, 86960, 
    86961, 86962, 87018, 87019, 87020, 
    87021, 87022, 87023, 87079, 87080, 
    87081, 87082, 87083, 87084, 87130, 
    87131, 87132, 87133, 87134, 87135, 
    86950, 86951, 86952, 86953, 86954, 
    86955, 86956, 87011, 87012, 87013, 
    87014, 87015, 87016, 87017, 87072, 
    87073, 87074, 87075, 87076, 87077
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00271

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 (86936,86937,86938,86939,86940,86941,86942,86997,86998,86999,87000,87001,87002,87003,87058,87059,87060,87061,87062,87063,87064,87116,87117,87118,87119,87120,87121,87122,86930,86931,86932,86933,86934,86935,86991,86992,86993,86994,86995,86996,87052,87053,87054,87055,87056,87057,87110,87111,87112,87113,87114,87115,86957,86958,86959,86960,86961,86962,87018,87019,87020,87021,87022,87023,87079,87080,87081,87082,87083,87084,87130,87131,87132,87133,87134,87135,86950,86951,86952,86953,86954,86955,86956,87011,87012,87013,87014,87015,87016,87017,87072,87073,87074,87075,87076,87077)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}