Sandbox

SELECT 
  product_id, 
  group_id 
FROM 
  cscart_product_variation_group_products 
WHERE 
  group_id IN (89, 85, 92, 88, 93, 91, 94, 83)

Query time 0.00026

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "40.21"
    },
    "table": {
      "table_name": "cscart_product_variation_group_products",
      "access_type": "range",
      "possible_keys": [
        "idx_group_id"
      ],
      "key": "idx_group_id",
      "used_key_parts": [
        "group_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 23,
      "rows_produced_per_join": 23,
      "filtered": "100.00",
      "index_condition": "(`cscart`.`cscart_product_variation_group_products`.`group_id` in (89,85,92,88,93,91,94,83))",
      "cost_info": {
        "read_cost": "35.61",
        "eval_cost": "4.60",
        "prefix_cost": "40.21",
        "data_read_per_join": "368"
      },
      "used_columns": [
        "product_id",
        "group_id"
      ]
    }
  }
}

Result

product_id	group_id
833	83
832	83
841	85
840	85
839	85
838	85
837	85
853	88
852	88
858	89
857	89
856	89
855	89
854	89
867	91
866	91
865	91
864	91
872	92
871	92
870	92
869	92
868	92
874	93
873	93
878	94
877	94
876	94
875	94

product_id	group_id
833	83
832	83
841	85
840	85
839	85
838	85
837	85
853	88
852	88
858	89
857	89
856	89
855	89
854	89
867	91
866	91
865	91
864	91
872	92
871	92
870	92
869	92
868	92
874	93
873	93
878	94
877	94
876	94
875	94

product_id	group_id
833	83
832	83
841	85
840	85
839	85
838	85
837	85
853	88
852	88
858	89
857	89
856	89
855	89
854	89
867	91
866	91
865	91
864	91
872	92
871	92
870	92
869	92
868	92
874	93
873	93
878	94
877	94
876	94
875	94

product_id	group_id
833	83
832	83
841	85
840	85
839	85
838	85
837	85
853	88
852	88
858	89
857	89
856	89
855	89
854	89
867	91
866	91
865	91
864	91
872	92
871	92
870	92
869	92
868	92
874	93
873	93
878	94
877	94
876	94
875	94