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 (
    69618, 69616, 69615, 69459, 69449, 69401, 
    69350, 69507, 69506, 69505, 69503, 
    69447, 69410, 68998, 68698, 67810, 
    67809, 67808, 67807, 67806, 67805, 
    67804, 67803, 67802, 67801, 67800, 
    67799, 67798, 67797, 67796, 67795, 
    67794, 67793, 67792, 67791, 69107, 
    69432, 69348, 69005, 68836
  )

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