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 (
    10705, 
    10706, 
    10707, 
    10708, 
    10709, 
    10710, 
    10711, 
    10712, 
    10668, 
    10669, 
    10670, 
    10671, 
    10672, 
    10673, 
    10674, 
    10675, 
    10676, 
    10677, 
    10678, 
    10679, 
    10680, 
    10681, 
    10682, 
    10683, 
    10684, 
    10685, 
    10686, 
    10725, 
    10724, 
    10701, 
    10699, 
    10698, 
    10696, 
    10695, 
    10693, 
    10692, 
    15958, 
    15957, 
    15956, 
    12600, 
    12602, 
    12604, 
    12606, 
    12608, 
    12603, 
    12615, 
    12597, 
    12609, 
    12610, 
    12607, 
    12596, 
    12611, 
    12613, 
    12612, 
    12605, 
    12601, 
    12616, 
    12599, 
    10666, 
    10664, 
    10663, 
    10661, 
    10659, 
    10658, 
    10657, 
    12619, 
    12620, 
    12593, 
    12595, 
    12585, 
    12587, 
    12623, 
    13091, 
    12588, 
    12590, 
    12591, 
    12592, 
    10497, 
    10498, 
    10499, 
    10500, 
    10501, 
    10502, 
    10503, 
    10504, 
    10505, 
    10506, 
    10507, 
    10508, 
    10509, 
    10510, 
    10511, 
    10512, 
    10513, 
    10514, 
    10515, 
    10516, 
    10517, 
    10518, 
    10519, 
    10520, 
    10521, 
    10641, 
    10640, 
    10639, 
    10638, 
    10637, 
    10636, 
    10635, 
    10634, 
    10633, 
    10632, 
    10631, 
    10630, 
    10629, 
    10628, 
    10627, 
    10626, 
    10625, 
    10624, 
    10623, 
    10622, 
    10621, 
    10620, 
    10619, 
    10618, 
    10617, 
    10616
  )

Query time 0.00043

JSON explain

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