Sandbox

SELECT 
  f.feature_id, 
  f.purpose, 
  p.product_id, 
  p.parent_product_id, 
  g.id, 
  g.code 
FROM 
  cscart_product_variation_group_features AS f 
  INNER JOIN cscart_product_variation_groups AS g ON f.group_id = g.id 
  INNER JOIN cscart_product_variation_group_products AS p ON f.group_id = p.group_id 
WHERE 
  p.product_id IN (
    64531, 63919, 63727, 64535, 64525, 64524, 
    64509, 64424, 64100, 64099, 63197, 
    64508, 64507, 64506, 64505, 64429, 
    64428, 64427, 64426, 64425, 64393, 
    64208, 63573, 63572, 61775, 61755, 
    64145, 64122, 64121, 64120, 61891, 
    64080, 64079, 63775, 63898, 63897, 
    63871, 63718, 63301, 63300
  )

Query time 0.00023

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	ALL	PRIMARY,idx_group_id				376	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	3	toolboxdigitalshop_dev.p.group_id	1
1	SIMPLE	f	ref	idx_group_id	idx_group_id	3	toolboxdigitalshop_dev.p.group_id	7