SELECT 
  filter_id, 
  feature_id 
FROM 
  cscart_product_filters 
  INNER JOIN cscart_ult_objects_sharing ON (
    cscart_ult_objects_sharing.share_object_id = cscart_product_filters.filter_id 
    AND cscart_ult_objects_sharing.share_company_id = 1 
    AND cscart_ult_objects_sharing.share_object_type = 'product_filters'
  ) 
WHERE 
  status = 'A'

Query time 0.00019

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_product_filters",
          "access_type": "ALL",
          "possible_keys": ["PRIMARY"],
          "rows": 69,
          "filtered": 100,
          "attached_condition": "cscart_product_filters.`status` = 'A'"
        }
      },
      {
        "table": {
          "table_name": "cscart_ult_objects_sharing",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "159",
          "used_key_parts": [
            "share_object_id",
            "share_company_id",
            "share_object_type"
          ],
          "ref": [
            "lillyshop_lillyshop.cscart_product_filters.filter_id",
            "const",
            "const"
          ],
          "rows": 1,
          "filtered": 100,
          "attached_condition": "cscart_ult_objects_sharing.share_object_id = cscart_product_filters.filter_id and cscart_ult_objects_sharing.share_object_type = 'product_filters'",
          "using_index": true
        }
      }
    ]
  }
}

Result

filter_id feature_id
1 69
2 4
3 15
5 3
6 83
7 38
8 33
9 61
10 30
11 54
12 31
13 14
14 46
15 29
16 63
17 60
18 25
20 6
21 0
22 78
25 1
27 0
29 70
30 72
111 155
32 135
40 136
112 177
43 36
45 129
46 130
47 84
49 44
113 178
52 76
53 9
54 24
55 49
56 51
57 81
58 20
59 18
60 45
62 43
63 17
64 59
65 26
66 22
68 19
69 16
70 50
71 52
72 34
73 47
74 75
75 42
76 56
78 28
79 32
83 12
84 13
86 126
90 92
91 90
92 58
93 67
94 66
95 64
96 65