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 (
    93498, 93497, 93496, 93495, 93494, 93493, 
    93492, 93491, 93490, 93489, 93488, 
    93487, 93486, 93485, 93484, 93483, 
    93482, 93481, 93480, 93479, 93478, 
    93477, 93476, 93475, 93474, 93473, 
    93466, 94268, 94267, 94266, 93443, 
    93440, 93432, 93430, 93429, 93428, 
    93427, 93426, 93425, 93424
  )

Query time 0.00034

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