SELECT 
  filter_id, 
  feature_id 
FROM 
  cscart_product_filters 
WHERE 
  status = 'A'

Query time 0.00011

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_filters ALL 10 Using where

Result

filter_id feature_id
1 0
10 18
313 549
312 548
314 551
315 552
316 550
7 15
8 16
9 17