SELECT 
  product_id, 
  feature_short_desc 
FROM 
  cscart_ab__short_desc_from_features_values 
WHERE 
  product_id IN (
    18977, 20565, 19418, 18992, 21626, 18908, 
    18926, 19004, 22046, 18981, 22045, 
    22059, 18994, 21634, 18911, 18958, 
    19005, 22053, 18982, 20601, 22058, 
    18995, 21640, 18912, 18959, 19006, 
    22055, 18984, 20602, 22047, 18913, 
    18996, 21639, 18960, 19007, 22054, 
    18985, 20603, 21629, 18914, 18997, 
    21637, 18961, 19011, 22056, 18986, 
    21627, 21630, 18915, 18998, 21635, 
    18970, 19013, 22057, 18987, 21638, 
    21631, 18917, 18999, 22061, 22051, 
    18971, 19014, 22064, 18988, 21636, 
    21632, 18918, 19000, 22050, 22461, 
    18973, 19016, 22063, 18989, 21642, 
    22052, 18920, 19001, 22049, 22479, 
    18975, 19017, 9348, 18990, 21641, 22062, 
    18924, 19002, 22048, 18976, 19066, 
    9347, 18991, 21628, 22060, 18925, 19003, 
    22044
  ) 
  AND lang_code = 'uk' 
  AND storefront_id = 1 
  AND cscart_ab__short_desc_from_features_values.company_id = 1

Query time 0.00069

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_ab__short_desc_from_features_values",
          "access_type": "range",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "17",
          "used_key_parts": [
            "product_id",
            "lang_code",
            "company_id",
            "storefront_id"
          ],
          "rows": 99,
          "filtered": 100,
          "attached_condition": "cscart_ab__short_desc_from_features_values.storefront_id = 1 and cscart_ab__short_desc_from_features_values.company_id = 1 and cscart_ab__short_desc_from_features_values.product_id in (18977,20565,19418,18992,21626,18908,18926,19004,22046,18981,22045,22059,18994,21634,18911,18958,19005,22053,18982,20601,22058,18995,21640,18912,18959,19006,22055,18984,20602,22047,18913,18996,21639,18960,19007,22054,18985,20603,21629,18914,18997,21637,18961,19011,22056,18986,21627,21630,18915,18998,21635,18970,19013,22057,18987,21638,21631,18917,18999,22061,22051,18971,19014,22064,18988,21636,21632,18918,19000,22050,22461,18973,19016,22063,18989,21642,22052,18920,19001,22049,22479,18975,19017,9348,18990,21641,22062,18924,19002,22048,18976,19066,9347,18991,21628,22060,18925,19003,22044) and cscart_ab__short_desc_from_features_values.lang_code = 'uk'"
        }
      }
    ]
  }
}