SELECT 
  product_id, 
  feature_short_desc 
FROM 
  cscart_ab__short_desc_from_features_values 
WHERE 
  product_id IN (
    6730, 7172, 6924, 7084, 6814, 6683, 7411, 
    6684, 6685, 6686, 6687, 6688, 6689, 
    6690, 6693, 11052, 6694, 6912, 6691, 
    6913, 6682, 6695, 6696, 11104, 6692, 
    8688, 6697, 8000, 6698, 6699, 6700, 
    6701, 6702, 6703, 6704, 6705, 6707, 
    6708, 6709, 6710, 6714, 6706, 6716, 
    6717, 6718, 6715, 6719, 6720, 6721, 
    6711, 6723, 6722, 6724, 6712, 6725, 
    6726, 6727, 6728, 6729, 6731, 6732, 
    8742, 6733, 6734, 6735, 6736, 6713, 
    6737, 6738, 6739, 6740, 6741, 6742, 
    6748, 8801, 8802, 11103, 6744, 6745, 
    6746, 6747, 10992, 6749, 6750, 8743, 
    6751, 6752, 6753, 6754, 6755, 6756, 
    6757, 6758, 6759, 6760, 6915, 6916, 
    6761, 6762, 11378
  ) 
  AND lang_code = 'uk' 
  AND storefront_id = 1 
  AND cscart_ab__short_desc_from_features_values.company_id = 1

Query time 0.00088

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": 100,
          "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 (6730,7172,6924,7084,6814,6683,7411,6684,6685,6686,6687,6688,6689,6690,6693,11052,6694,6912,6691,6913,6682,6695,6696,11104,6692,8688,6697,8000,6698,6699,6700,6701,6702,6703,6704,6705,6707,6708,6709,6710,6714,6706,6716,6717,6718,6715,6719,6720,6721,6711,6723,6722,6724,6712,6725,6726,6727,6728,6729,6731,6732,8742,6733,6734,6735,6736,6713,6737,6738,6739,6740,6741,6742,6748,8801,8802,11103,6744,6745,6746,6747,10992,6749,6750,8743,6751,6752,6753,6754,6755,6756,6757,6758,6759,6760,6915,6916,6761,6762,11378) and cscart_ab__short_desc_from_features_values.lang_code = 'uk'"
        }
      }
    ]
  }
}