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 (
    10246, 10247, 10248, 10249, 10250, 10251, 
    10252, 10253, 10254, 10255, 10256, 
    10257, 10258, 10259, 10260, 10261, 
    10425, 10426, 10427, 10428, 10429, 
    10430, 10431, 10432, 10433, 10434, 
    10435, 10436, 10437, 10438, 10439, 
    10440, 10441, 10442, 10443, 10444, 
    10522, 9803, 9805, 9797, 9800, 9799, 
    9798, 9801, 9802, 9806, 9804, 9809, 
    9810, 9811, 9812, 9807, 9808, 9905, 
    10168, 10041, 10643, 10606, 10094, 
    10097, 12703, 10177, 10175, 9813
  )

Query time 0.00089

JSON explain

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