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 (
    86890, 91864, 92374, 85576, 85584, 85572, 
    86900, 85592, 88907, 88908, 88905, 
    88906, 85546, 85571, 85573, 85574, 
    91877, 91878, 91879, 91880, 91881, 
    91882, 91883, 85555, 85594, 85564, 
    90025, 85575, 86889, 86895, 82359, 
    87888, 91844, 92185, 92382, 85561, 
    91856, 88910, 88909, 82370, 86893, 
    85553, 85559, 92172, 92358, 92359, 
    92360, 92361, 92362, 92363, 92364, 
    85560, 85566, 85641, 89988, 91848, 
    91888, 85569, 91876, 85545, 92357, 
    84237, 85548, 92913, 92914, 92915, 
    92916, 92917, 92918, 92919, 92920, 
    92921, 93283, 93285, 93287, 93289, 
    93291, 93753, 93754, 93755, 93756, 
    93757, 93758, 93759, 93760, 93761, 
    93762, 93763, 93764, 93765, 93766, 
    93767, 93768, 93769, 93770, 93771
  )

Query time 0.00068

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.05"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "f",
          "access_type": "ALL",
          "possible_keys": [
            "idx_group_id"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.25",
            "eval_cost": "0.10",
            "prefix_cost": "0.35",
            "data_read_per_join": "104"
          },
          "used_columns": [
            "feature_id",
            "purpose",
            "group_id"
          ]
        }
      },
      {
        "table": {
          "table_name": "g",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "id"
          ],
          "key_length": "3",
          "ref": [
            "nuie_scalesta_net.f.group_id"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.25",
            "eval_cost": "0.10",
            "prefix_cost": "0.70",
            "data_read_per_join": "400"
          },
          "used_columns": [
            "id",
            "code"
          ]
        }
      },
      {
        "table": {
          "table_name": "p",
          "access_type": "ref",
          "possible_keys": [
            "PRIMARY",
            "idx_group_id"
          ],
          "key": "idx_group_id",
          "used_key_parts": [
            "group_id"
          ],
          "key_length": "3",
          "ref": [
            "nuie_scalesta_net.f.group_id"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "index_condition": "(`nuie_scalesta_net`.`p`.`product_id` in (86890,91864,92374,85576,85584,85572,86900,85592,88907,88908,88905,88906,85546,85571,85573,85574,91877,91878,91879,91880,91881,91882,91883,85555,85594,85564,90025,85575,86889,86895,82359,87888,91844,92185,92382,85561,91856,88910,88909,82370,86893,85553,85559,92172,92358,92359,92360,92361,92362,92363,92364,85560,85566,85641,89988,91848,91888,85569,91876,85545,92357,84237,85548,92913,92914,92915,92916,92917,92918,92919,92920,92921,93283,93285,93287,93289,93291,93753,93754,93755,93756,93757,93758,93759,93760,93761,93762,93763,93764,93765,93766,93767,93768,93769,93770,93771))",
          "cost_info": {
            "read_cost": "0.25",
            "eval_cost": "0.10",
            "prefix_cost": "1.05",
            "data_read_per_join": "16"
          },
          "used_columns": [
            "product_id",
            "parent_product_id",
            "group_id"
          ]
        }
      }
    ]
  }
}