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 (
    13018, 
    13017, 
    13016, 
    13015, 
    13014, 
    13013, 
    13012, 
    13011, 
    13010, 
    13009, 
    13008, 
    13007, 
    13006, 
    13005, 
    13004, 
    13003, 
    13002, 
    13001, 
    13000, 
    12999, 
    10812, 
    10811, 
    10810, 
    10809, 
    10808, 
    10807, 
    10806, 
    10805, 
    10804, 
    10803, 
    10802, 
    10801, 
    10800, 
    10799, 
    10798, 
    10797, 
    10796, 
    10795, 
    10794, 
    10793, 
    10792, 
    10791, 
    10790, 
    10789, 
    10788, 
    10787, 
    10786, 
    10785, 
    10784, 
    10783, 
    10782, 
    10781, 
    10780, 
    10779, 
    10778, 
    10777, 
    10776, 
    10775, 
    10774, 
    10773, 
    10772, 
    10771, 
    10770, 
    10769, 
    10768, 
    10767, 
    10766, 
    10765, 
    10764, 
    10763, 
    10762, 
    10761, 
    10760, 
    10759, 
    10758, 
    10757, 
    10756, 
    10755, 
    10754, 
    10753, 
    10752, 
    10751, 
    10750, 
    10749, 
    10748, 
    10747, 
    15736, 
    15737, 
    15738, 
    15739, 
    15740, 
    15741, 
    15742, 
    15743, 
    15745, 
    15746, 
    15744, 
    12632, 
    12633, 
    10179, 
    10180, 
    10523, 
    10073, 
    10077, 
    10076, 
    10086, 
    10085, 
    10084, 
    10083, 
    10082, 
    10081, 
    10080, 
    10079, 
    10584, 
    10594, 
    12574, 
    10168, 
    10167, 
    12703, 
    15968, 
    15938, 
    10053, 
    10041, 
    9904, 
    9905, 
    15966, 
    15965, 
    9940
  )

Query time 0.00037

JSON explain

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