SELECT 
  pfv.feature_id, 
  pfv.product_id, 
  pfv.variant_id, 
  gp.group_id 
FROM 
  cscart_product_features_values AS pfv 
  INNER JOIN cscart_product_variation_group_products AS gp ON pfv.product_id = gp.product_id 
  INNER JOIN cscart_product_variation_group_features AS gpf ON gpf.group_id = gp.group_id 
  AND gpf.feature_id = pfv.feature_id 
WHERE 
  pfv.lang_code = 'en' 
  AND gp.group_id IN (
    226, 73, 203, 45, 213, 204, 812, 210, 201, 
    227, 183, 239, 415, 202, 208, 221, 228
  )

Query time 0.00164

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "60.36"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "gpf",
          "access_type": "range",
          "possible_keys": [
            "PRIMARY",
            "idx_group_id"
          ],
          "key": "idx_group_id",
          "used_key_parts": [
            "group_id"
          ],
          "key_length": "3",
          "rows_examined_per_scan": 22,
          "rows_produced_per_join": 22,
          "filtered": "100.00",
          "index_condition": "(`softwarepirmam_hewadelivard_cscart_4`.`gpf`.`group_id` in (226,73,203,45,213,204,812,210,201,227,183,239,415,202,208,221,228))",
          "cost_info": {
            "read_cost": "11.96",
            "eval_cost": "2.20",
            "prefix_cost": "14.16",
            "data_read_per_join": "2K"
          },
          "used_columns": [
            "feature_id",
            "group_id"
          ]
        }
      },
      {
        "table": {
          "table_name": "gp",
          "access_type": "ref",
          "possible_keys": [
            "PRIMARY",
            "idx_group_id"
          ],
          "key": "idx_group_id",
          "used_key_parts": [
            "group_id"
          ],
          "key_length": "3",
          "ref": [
            "softwarepirmam_hewadelivard_cscart_4.gpf.group_id"
          ],
          "rows_examined_per_scan": 3,
          "rows_produced_per_join": 66,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "16.50",
            "eval_cost": "6.60",
            "prefix_cost": "37.26",
            "data_read_per_join": "1K"
          },
          "used_columns": [
            "product_id",
            "group_id"
          ]
        }
      },
      {
        "table": {
          "table_name": "pfv",
          "access_type": "ref",
          "possible_keys": [
            "PRIMARY",
            "fl",
            "lang_code",
            "product_id",
            "fpl",
            "idx_product_feature_variant_id"
          ],
          "key": "fpl",
          "used_key_parts": [
            "feature_id",
            "product_id",
            "lang_code"
          ],
          "key_length": "12",
          "ref": [
            "softwarepirmam_hewadelivard_cscart_4.gpf.feature_id",
            "softwarepirmam_hewadelivard_cscart_4.gp.product_id",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 66,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "16.50",
            "eval_cost": "6.60",
            "prefix_cost": "60.36",
            "data_read_per_join": "51K"
          },
          "used_columns": [
            "feature_id",
            "product_id",
            "variant_id",
            "lang_code"
          ]
        }
      }
    ]
  }
}

Result

feature_id product_id variant_id group_id
656 908 1653 45
656 134 1652 45
656 1254 1726 73
656 1253 1725 73
656 247 1724 73
656 2395 1558 183
656 2396 1559 183
656 2397 1560 183
656 2398 1600 183
656 2467 1559 201
656 2468 1559 201
656 2469 1560 201
656 2470 1560 201
656 2471 1641 201
656 2472 1641 201
648 2467 1564 201
648 2468 1563 201
648 2469 1563 201
648 2470 1564 201
648 2471 1563 201
648 2472 1564 201
656 2473 2903 202
656 2475 1559 202
656 2476 1560 202
656 2477 1596 202
656 2478 1653 203
656 2483 1653 203
656 2482 1653 203
656 2484 2907 203
656 2485 2907 203
656 2486 2907 203
656 2487 2908 203
656 2488 2908 203
656 2489 2908 203
648 2478 1564 203
648 2483 1563 203
648 2482 1562 203
648 2484 1562 203
648 2485 1563 203
648 2486 1564 203
648 2487 1562 203
648 2488 1563 203
648 2489 1564 203
656 2490 2910 204
656 2491 1653 204
656 2492 1653 204
656 2493 2907 204
656 2494 2907 204
656 2495 2908 204
656 2496 2908 204
656 2497 2910 204
648 2490 1563 204
648 2491 1562 204
648 2492 1563 204
648 2493 1562 204
648 2494 1563 204
648 2495 1562 204
648 2496 1563 204
648 2497 1562 204
656 2506 1596 208
656 2507 1600 208
656 2508 2077 208
643 2512 1526 210
643 2513 1526 210
643 2509 1587 210
643 2514 1526 210
643 2515 1587 210
643 2516 1587 210
656 2512 1560 210
656 2513 1596 210
656 2509 1560 210
656 2514 1600 210
656 2515 1596 210
656 2516 1600 210
643 2524 1684 213
643 2525 2870 213
643 2526 2870 213
643 2527 2870 213
643 2528 2870 213
643 2529 1684 213
643 2530 1684 213
643 2531 1684 213
656 2524 1560 213
656 2525 1560 213
656 2526 1596 213
656 2527 1600 213
656 2528 2758 213
656 2529 1596 213
656 2530 1600 213
656 2531 2758 213
648 2524 1561 213
648 2525 1687 213
648 2526 1687 213
648 2527 1687 213
648 2528 1687 213
648 2529 1561 213
648 2530 1561 213
648 2531 1561 213
656 2534 1599 221
656 2564 2984 221
656 2565 2985 221
656 8422 2992 226
656 2574 2993 226
656 2576 1596 227
656 2577 1607 227
656 2578 1609 227
656 2579 1595 228
656 2580 1560 228
656 2615 1560 239
656 2620 1559 239
656 2621 1596 239
656 2502 1559 415
656 3639 1560 415
766 2432 8553 812
766 8485 8558 812
766 8484 8557 812
766 8483 8560 812