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 (
    115, 114, 817, 819, 820, 818, 90, 87, 76, 
    98, 102, 89, 92, 94, 85, 66, 63, 62, 54, 
    50, 45, 65
  )

Query time 0.00355

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "120.26"
    },
    "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": 45,
          "rows_produced_per_join": 45,
          "filtered": "100.00",
          "index_condition": "(`softwarepirmam_hewadelivard_cscart_4`.`gpf`.`group_id` in (115,114,817,819,820,818,90,87,76,98,102,89,92,94,85,66,63,62,54,50,45,65))",
          "cost_info": {
            "read_cost": "21.26",
            "eval_cost": "4.50",
            "prefix_cost": "25.76",
            "data_read_per_join": "4K"
          },
          "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": 135,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "33.75",
            "eval_cost": "13.50",
            "prefix_cost": "73.01",
            "data_read_per_join": "2K"
          },
          "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": 135,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "33.75",
            "eval_cost": "13.50",
            "prefix_cost": "120.26",
            "data_read_per_join": "104K"
          },
          "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 955 1560 50
656 942 1552 50
656 941 1552 50
656 446 1552 50
656 943 1552 50
656 954 1560 50
656 953 1560 50
656 952 1560 50
656 951 1559 50
656 950 1559 50
656 949 1559 50
656 948 1559 50
656 947 1553 50
656 946 1553 50
656 945 1553 50
656 944 1553 50
648 955 1564 50
648 942 1563 50
648 941 1562 50
648 446 1561 50
648 943 1564 50
648 954 1563 50
648 953 1562 50
648 952 1561 50
648 951 1564 50
648 950 1563 50
648 949 1562 50
648 948 1561 50
648 947 1564 50
648 946 1563 50
648 945 1562 50
648 944 1561 50
656 998 1659 54
656 997 1659 54
656 994 1558 54
656 995 1558 54
656 996 1659 54
656 493 1556 54
656 985 1660 54
656 986 1660 54
656 987 1660 54
656 988 1556 54
656 989 1556 54
656 990 1557 54
656 991 1557 54
656 992 1557 54
656 993 1558 54
648 998 1563 54
648 997 1562 54
648 994 1562 54
648 995 1563 54
648 996 1561 54
648 493 1561 54
648 985 1561 54
648 986 1562 54
648 987 1563 54
648 988 1562 54
648 989 1563 54
648 990 1561 54
648 991 1562 54
648 992 1563 54
648 993 1561 54
648 1128 1686 62
648 1127 1686 62
648 1126 1686 62
648 1125 1686 62
648 1124 1686 62
648 1123 1686 62
656 1128 1633 62
656 1127 1632 62
656 1126 1631 62
656 1125 1633 62
656 1124 1632 62
656 1123 1631 62
649 1128 1612 62
649 1127 1612 62
649 1126 1612 62
649 1125 1611 62
649 1124 1611 62
649 1123 1611 62
649 1139 1614 63
649 1138 1614 63
649 1137 1614 63
649 1136 1614 63
649 1135 1614 63
649 1134 1614 63
649 1133 1613 63
649 1132 1613 63
649 1131 1613 63
649 1130 1613 63
649 1129 1613 63
649 827 1613 63
656 1139 1633 63
656 1138 1553 63
656 1137 1637 63
656 1136 1636 63
656 1135 1635 63
656 1134 1634 63
656 1133 1633 63
656 1132 1553 63
656 1131 1637 63
656 1130 1636 63
656 1129 1635 63
656 827 1634 63
648 1139 1687 63
648 1138 1687 63
648 1137 1687 63
648 1136 1687 63
648 1135 1687 63
648 1134 1687 63
648 1133 1687 63
648 1132 1687 63
648 1131 1687 63
648 1130 1687 63
648 1129 1687 63
648 827 1687 63
658 1142 1701 65
658 853 1700 65
656 1146 1707 66
656 1145 1610 66
656 1144 1609 66
656 1143 1600 66
656 856 1599 66
643 1323 1587 76
643 1322 1587 76
643 1262 1526 76
643 1317 1526 76
643 1318 1526 76
643 1319 1526 76
643 1320 1587 76
643 1321 1587 76
656 1323 1751 76
656 1322 1750 76
656 1262 1748 76
656 1317 1749 76
656 1318 1750 76
656 1319 1751 76
656 1320 1748 76
656 1321 1749 76
648 1323 1562 76
648 1322 1562 76
648 1262 1562 76
648 1317 1562 76
648 1318 1562 76
648 1319 1562 76
648 1320 1562 76
648 1321 1562 76
643 1256 1684 85
643 1395 1684 85
643 1396 1684 85
643 1397 1591 85
643 1398 1591 85
643 1399 1591 85
656 1256 1560 85
656 1395 1766 85
656 1396 1682 85
656 1397 1560 85
656 1398 1766 85
656 1399 1682 85
648 1256 1687 85
648 1395 1687 85
648 1396 1687 85
648 1397 1561 85
648 1398 1561 85
648 1399 1561 85
643 1265 1526 87
643 1406 1526 87
643 1407 1526 87
643 1408 1526 87
643 1409 1526 87
643 1410 1526 87
643 1411 1526 87
643 1412 1526 87
656 1265 1773 87
656 1406 1775 87
656 1407 1775 87
656 1408 1776 87
656 1409 1776 87
656 1410 1773 87
656 1411 1774 87
656 1412 1774 87
648 1265 1562 87
648 1406 1562 87
648 1407 1563 87
648 1408 1562 87
648 1409 1563 87
648 1410 1563 87
648 1411 1562 87
648 1412 1563 87
643 1273 1587 89
643 1420 1587 89
643 1421 1587 89
643 1422 1587 89
643 1423 1587 89
643 1424 1587 89
656 1273 1778 89
656 1420 1778 89
656 1421 1755 89
656 1422 1755 89
656 1423 1558 89
656 1424 1558 89
648 1273 1562 89
648 1420 1563 89
648 1421 1562 89
648 1422 1563 89
648 1423 1562 89
648 1424 1563 89
643 1261 1526 90
643 1425 1526 90
643 1426 1526 90
643 1427 1526 90
643 1428 1526 90
643 1429 1526 90
643 1430 1526 90
643 1431 1526 90
656 1261 1779 90
656 1425 1779 90
656 1426 1780 90
656 1427 1780 90
656 1428 1781 90
656 1429 1781 90
656 1430 1782 90
656 1431 1782 90
648 1261 1561 90
648 1425 1562 90
648 1426 1561 90
648 1427 1562 90
648 1428 1561 90
648 1429 1562 90
648 1430 1561 90
648 1431 1562 90
643 1266 1587 92
643 1439 1587 92
643 1440 1587 92
643 1441 1587 92
643 1442 1587 92
643 1443 1587 92
643 1444 1587 92
643 1445 1587 92
643 1446 1587 92
643 1447 1587 92
643 1448 1587 92
643 1449 1587 92
656 1266 1554 92
656 1439 1785 92
656 1440 1785 92
656 1441 1785 92
656 1442 1786 92
656 1443 1786 92
656 1444 1786 92
656 1445 1554 92
656 1446 1554 92
656 1447 1760 92
656 1448 1760 92
656 1449 1760 92
648 1266 1562 92
648 1439 1562 92
648 1440 1563 92
648 1441 1564 92
648 1442 1562 92
648 1443 1563 92
648 1444 1564 92
648 1445 1563 92
648 1446 1564 92
648 1447 1562 92
648 1448 1563 92
648 1449 1564 92
643 1263 1526 94
643 1453 1526 94
643 1454 1526 94
643 1455 1526 94
643 1456 1526 94
643 1457 1526 94
643 1458 1526 94
643 1459 1526 94
656 1263 1787 94
656 1453 1787 94
656 1454 1788 94
656 1455 1788 94
656 1456 1789 94
656 1457 1789 94
656 1458 1774 94
656 1459 1774 94
648 1263 1561 94
648 1453 1562 94
648 1454 1561 94
648 1455 1562 94
648 1456 1561 94
648 1457 1562 94
648 1458 1561 94
648 1459 1562 94
649 1284 1792 98
649 1475 1792 98
649 1476 1793 98
649 1477 1793 98
656 1284 1607 98
656 1475 1560 98
656 1476 1560 98
656 1477 1607 98
643 1274 1684 102
643 1483 1684 102
643 1484 1684 102
643 1485 1526 102
643 1486 1526 102
643 1487 1526 102
656 1274 1912 102
656 1483 1607 102
656 1484 1913 102
656 1485 1607 102
656 1486 1912 102
656 1487 1913 102
648 1274 1687 102
648 1483 1687 102
648 1484 1687 102
648 1485 1561 102
648 1486 1561 102
648 1487 1561 102
656 1540 1912 114
656 1541 1559 114
656 1542 1559 115
656 1543 1607 115
766 8495 8551 817
766 1538 8558 817
766 8496 8557 817
766 1517 8557 818
766 8498 8558 818
766 8497 8805 818
766 8500 8551 819
766 1532 8558 819
766 8502 8553 819
766 8501 8557 819
766 8499 8556 819
766 8504 8557 820
766 1528 8558 820
766 8505 8553 820
766 8503 8556 820