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 (
    260, 433, 195, 571, 305, 261, 364, 363, 
    404, 352, 418, 252, 155, 266, 383, 432, 
    373, 382, 366, 399, 688, 374, 304, 401, 
    365, 461, 463, 462
  )

Query time 0.00153

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "70.26"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "gp",
          "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": 55,
          "rows_produced_per_join": 55,
          "filtered": "100.00",
          "index_condition": "(`softwarepirmam_hewadelivard_cscart_4`.`gp`.`group_id` in (260,433,195,571,305,261,364,363,404,352,418,252,155,266,383,432,373,382,366,399,688,374,304,401,365,461,463,462))",
          "cost_info": {
            "read_cost": "26.26",
            "eval_cost": "5.50",
            "prefix_cost": "31.76",
            "data_read_per_join": "880"
          },
          "used_columns": [
            "product_id",
            "group_id"
          ]
        }
      },
      {
        "table": {
          "table_name": "gpf",
          "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.gp.group_id"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 55,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "13.75",
            "eval_cost": "5.50",
            "prefix_cost": "51.01",
            "data_read_per_join": "5K"
          },
          "used_columns": [
            "feature_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": 55,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "13.75",
            "eval_cost": "5.50",
            "prefix_cost": "70.26",
            "data_read_per_join": "42K"
          },
          "used_columns": [
            "feature_id",
            "product_id",
            "variant_id",
            "lang_code"
          ]
        }
      }
    ]
  }
}

Result

feature_id product_id variant_id group_id
656 2227 1600 155
656 2226 2315 155
656 2430 1560 195
656 2431 1559 195
656 2655 1559 252
656 2698 2985 260
656 2702 1560 261
656 2703 2993 261
656 2719 1600 266
656 2728 2993 266
656 2918 1560 304
656 2919 1559 304
656 2922 1560 305
656 2923 1559 305
656 3150 1560 352
656 3151 1559 352
656 3213 1559 363
656 3214 1560 363
656 3216 1560 364
656 3215 1559 364
656 3220 1559 365
656 3221 1560 365
656 3222 1559 366
656 3223 1560 366
656 3290 1560 373
656 3289 1559 373
656 3310 1560 374
656 3309 1559 374
656 3382 1560 382
656 3383 1559 382
656 3385 1560 383
656 3386 1559 383
656 3522 1559 399
656 3523 1560 399
656 3532 1559 401
656 3533 1560 401
656 3552 1559 404
656 3553 1560 404
656 3664 1560 418
656 3665 1559 418
656 3832 1560 432
656 3831 1559 432
656 3834 1559 433
656 3835 1560 433
708 3668 4425 461
708 4102 3784 461
708 4103 3784 462
708 3682 4425 462
708 4106 3784 463
708 3684 4425 463
656 5117 1560 571
656 5116 1559 571
656 5114 1558 571
656 5804 1559 688
656 6193 1560 688