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 (
    291, 292, 293, 294, 295, 296, 297, 298, 
    300, 302, 303, 304, 305, 306, 307, 308, 
    309, 310, 311, 312, 313, 314, 315, 316, 
    317, 318, 319, 320, 321, 330, 331, 332, 
    333, 334, 335, 338, 339, 340, 341, 342, 
    344, 345, 346, 347, 348, 349, 350, 351, 
    352, 353, 354, 355, 356, 357, 358, 359, 
    360, 361, 362, 363, 364, 365, 366, 367, 
    368, 369, 370, 371
  )

Query time 0.00022

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}