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 (
    93772, 93773, 93774, 93775, 93776, 93777, 
    93778, 93779, 93780, 93825, 93826, 
    93827, 93828, 93829, 94073, 94140, 
    94141, 94142, 94143, 94144, 94145, 
    94146, 94147, 94148, 94149, 94150, 
    94151, 94152, 94153, 94154, 94155, 
    94156, 94157, 94158, 94159, 94160, 
    94452, 94453, 94454, 94455, 94456, 
    94458, 94459, 94460, 94461, 94462, 
    94604, 94605, 94606, 94607, 94608, 
    94609, 94610, 94611, 94612, 94613, 
    94614, 94615, 94616, 94617, 94618, 
    94654, 94655, 94656, 94657, 94658, 
    94666, 94667, 94668, 94669, 94670, 
    94751, 94752, 94753, 94754, 94755, 
    94756, 94757, 94758, 94762, 94764, 
    95314, 95378, 95379, 95380, 95381, 
    95382, 95383, 95384, 95385, 95386, 
    95387, 95388, 95389, 95390, 95391
  )

Query time 0.00074

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 (93772,93773,93774,93775,93776,93777,93778,93779,93780,93825,93826,93827,93828,93829,94073,94140,94141,94142,94143,94144,94145,94146,94147,94148,94149,94150,94151,94152,94153,94154,94155,94156,94157,94158,94159,94160,94452,94453,94454,94455,94456,94458,94459,94460,94461,94462,94604,94605,94606,94607,94608,94609,94610,94611,94612,94613,94614,94615,94616,94617,94618,94654,94655,94656,94657,94658,94666,94667,94668,94669,94670,94751,94752,94753,94754,94755,94756,94757,94758,94762,94764,95314,95378,95379,95380,95381,95382,95383,95384,95385,95386,95387,95388,95389,95390,95391))",
          "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"
          ]
        }
      }
    ]
  }
}