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 (
    203, 213, 204, 201, 227, 239, 415, 202, 
    221, 228, 217, 234, 207, 235, 215, 257, 
    241, 803, 205, 230, 244, 211, 808
  )

Query time 0.00329

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "92.46"
    },
    "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": 34,
          "rows_produced_per_join": 34,
          "filtered": "100.00",
          "index_condition": "(`softwarepirmam_hewadelivard_cscart_4`.`gpf`.`group_id` in (203,213,204,201,227,239,415,202,221,228,217,234,207,235,215,257,241,803,205,230,244,211,808))",
          "cost_info": {
            "read_cost": "17.66",
            "eval_cost": "3.40",
            "prefix_cost": "21.06",
            "data_read_per_join": "3K"
          },
          "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": 102,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "25.50",
            "eval_cost": "10.20",
            "prefix_cost": "56.76",
            "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": 102,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "25.50",
            "eval_cost": "10.20",
            "prefix_cost": "92.46",
            "data_read_per_join": "78K"
          },
          "used_columns": [
            "feature_id",
            "product_id",
            "variant_id",
            "lang_code"
          ]
        }
      }
    ]
  }
}

Result

feature_id product_id variant_id group_id
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 2499 1597 205
656 2500 1560 205
656 2503 2919 207
656 2504 1559 207
656 2505 1560 207
656 2517 1560 211
656 2518 1600 211
656 2519 2758 211
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 2538 1599 215
656 2540 1597 215
656 2541 1598 215
656 2550 2441 217
656 2549 2441 217
656 2548 1599 217
656 2544 1599 217
656 2551 1597 217
656 2552 1597 217
648 2550 1563 217
648 2549 1562 217
648 2548 1562 217
648 2544 1563 217
648 2551 1562 217
648 2552 1563 217
656 2534 1599 221
656 2564 2984 221
656 2565 2985 221
656 2576 1596 227
656 2577 1607 227
656 2578 1609 227
656 2579 1595 228
656 2580 1560 228
656 2581 1560 230
656 2585 1600 230
656 2586 1607 230
656 2596 1560 234
656 2597 1560 234
656 2598 1595 234
656 2599 1595 234
656 2600 1596 234
656 2601 1596 234
648 2596 1563 234
648 2597 1562 234
648 2598 1562 234
648 2599 1563 234
648 2600 1562 234
648 2601 1563 234
643 2602 1587 235
643 2604 1526 235
643 2605 1526 235
643 2606 1526 235
643 2607 1587 235
643 2608 1587 235
656 2602 1560 235
656 2604 1560 235
656 2605 1596 235
656 2606 1607 235
656 2607 1596 235
656 2608 1607 235
648 2602 1563 235
648 2604 1562 235
648 2605 1562 235
648 2606 1562 235
648 2607 1563 235
648 2608 1563 235
656 2615 1560 239
656 2620 1559 239
656 2621 1596 239
643 2623 1592 241
643 2624 1587 241
643 2625 1587 241
643 2626 1592 241
656 2623 1559 241
656 2624 1559 241
656 2625 1560 241
656 2626 1560 241
648 2623 1564 241
648 2624 1563 241
648 2625 1563 241
648 2626 1564 241
656 2631 1595 244
656 2632 1560 244
656 2633 2077 244
656 2685 1609 257
656 2686 1600 257
656 2687 1560 257
656 2502 1559 415
656 3639 1560 415
656 8417 1595 803
656 8418 1596 803
656 8419 1596 803
656 8420 1600 803
656 8398 1560 803
656 8415 1560 803
656 8416 1595 803
656 8421 1600 803
648 8417 1563 803
648 8418 1562 803
648 8419 1563 803
648 8420 1562 803
648 8398 1563 803
648 8415 1562 803
648 8416 1562 803
648 8421 1563 803
656 8399 1609 808
656 8476 1560 808
656 8477 1596 808