Sandbox

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-bsg-17118617905-clone-clone-clone-tr-3'
  ) 
ORDER BY 
  cscart_product_filters.position ASC, 
  cscart_cp_power_seo_filter_names.name ASC

Query time 0.00014

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