Sandbox

SELECT 
  cscart_cp_power_seo_filter_names.* 
FROM 
  cscart_cp_power_seo_filter_names 
WHERE 
  cscart_cp_power_seo_filter_names.variant_id IN ('1215') 
  AND cscart_cp_power_seo_filter_names.type = 'v' 
  AND cscart_cp_power_seo_filter_names.lang_code = 'tr' 
  AND filter_id = 314

Query time 0.00024

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cscart_cp_power_seo_filter_names	ref	type	type	21	const,const	2	Using index condition; Using where

Result

name	variant_id	filter_id	feature_id	type	lang_code
bmw	1215	314	551	v	tr