Sandbox

SELECT 
  feature_id, 
  variant_id, 
  value, 
  value_int 
FROM 
  cscart_product_features_values 
WHERE 
  product_id = 9849 
  AND lang_code = 'de'

Query time 0.00046

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cscart_product_features_values	ref	lang_code,product_id,product_id_idx,product_feature_idx	product_id	3	const	59	Using where

Result

feature_id	variant_id	value	value_int
42	6257
30	240
127	5895
128	5899
129	5903
24	109
135	5964
135	5965
136	5973
136	5975
178	6308
136	5972
136	5976
176	6259
136	5974
136	5977