SELECT 
  cscart_cp_power_seo_filter_names.name 
FROM 
  cscart_cp_power_seo_filter_names 
  LEFT JOIN cscart_product_filters on cscart_cp_power_seo_filter_names.filter_id = cscart_product_filters.filter_id 
WHERE 
  name in (
    'su-radyatoru-kale-17118617905'
  ) 
ORDER BY 
  cscart_product_filters.position ASC, 
  cscart_cp_power_seo_filter_names.name ASC

Query time 0.00016

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_cp_power_seo_filter_names ref PRIMARY,name PRIMARY 752 const 1 Using where; Using index; Using temporary; Using filesort
1 SIMPLE cscart_product_filters eq_ref PRIMARY PRIMARY 3 hobilifedt.cscart_cp_power_seo_filter_names.filter_id 1 Using where