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 ('1227') 
  AND cscart_cp_power_seo_filter_names.type = 'v' 
  AND cscart_cp_power_seo_filter_names.lang_code = 'tr' 
  AND filter_id = 316

Query time 0.00017

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	5	Using index condition; Using where

Result

name	variant_id	filter_id	feature_id	type	lang_code
kale	1227	316	550	v	tr