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.00056

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_filters ALL PRIMARY 79 Using where
1 SIMPLE cscart_ult_objects_sharing eq_ref PRIMARY PRIMARY 159 stroysan.cscart_product_filters.filter_id,const,const 1 Using where; Using index

Result

filter_id feature_id
118 46095
116 46027
23 74
50 132
68 45991
114 0
61 46006
58 45988
102 72
12 55
52 134
32 97
74 83
77 46005
80 46039
81 46041
84 46043
87 70
89 45
98 46070
22 63
90 46018
88 46036
64 45989
35 62
14 58
67 46009
55 46004
1 0
13 59
60 46007
20 61
18 68
49 45987
40 100
39 114
42 109
36 79
37 86
48 78
43 110
44 111
45 105
57 45996
28 99
29 95
30 93
31 94
69 45997
71 45992
73 46032
79 46034
82 46040
85 46024
86 46025
91 46064
95 46047
96 46013
99 46074
100 46010
109 46079
103 46082
104 46081
107 46084
108 46085
110 46087
111 46088
113 46062
97 46020
115 46091
59 46003