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 (
    13101, 
    12498, 
    12496, 
    12510, 
    12519, 
    12516, 
    12530, 
    12526, 
    12531, 
    12509, 
    12517, 
    12523, 
    12532, 
    12525, 
    12515, 
    12529, 
    12503, 
    13100, 
    12507, 
    12522, 
    12508, 
    12506, 
    12500, 
    12499, 
    12513, 
    12514, 
    13099, 
    12521, 
    12527, 
    12511, 
    12512, 
    12528, 
    12520, 
    12497, 
    12505, 
    12502, 
    12504, 
    10847, 
    13152, 
    10846, 
    10845, 
    10844, 
    10843, 
    10842, 
    10841, 
    10840, 
    10839, 
    10838, 
    10837, 
    10836, 
    10835, 
    10834, 
    10833, 
    10832, 
    10831, 
    10830, 
    10829, 
    10828, 
    10827, 
    12642, 
    12648, 
    12651, 
    12645, 
    12644, 
    12650, 
    12649, 
    12643, 
    12640, 
    12647, 
    15800, 
    12639, 
    12641, 
    12638, 
    12637, 
    12634, 
    12635, 
    12636, 
    12654, 
    12653, 
    12652, 
    12656, 
    12655, 
    12646, 
    12631, 
    12998, 
    12997, 
    12996, 
    12995, 
    10826, 
    10825, 
    10824, 
    10823, 
    10822, 
    10821, 
    10820, 
    10819, 
    10818, 
    10817, 
    10816, 
    10815, 
    10814, 
    10813, 
    13044, 
    13043, 
    13042, 
    13041, 
    13040, 
    13039, 
    13038, 
    13037, 
    13036, 
    13035, 
    13034, 
    13033, 
    13032, 
    13031, 
    13030, 
    13029, 
    13028, 
    13027, 
    13026, 
    13025, 
    13024, 
    13023, 
    13022, 
    13021, 
    13020, 
    13019
  )

Query time 0.00051

JSON explain

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