SELECT 
  product_id, 
  group_id 
FROM 
  cscart_product_variation_group_products 
WHERE 
  group_id IN (
    620, 623, 260, 627, 608, 628, 410, 647, 
    559, 354, 433, 372, 642, 195, 646, 571, 
    306, 675, 305, 625, 409, 547, 261, 453, 
    562, 561, 556, 364, 363, 622, 621, 404, 
    282, 552, 661, 352, 564, 346, 345, 418, 
    252, 681, 155, 466, 666, 353, 381, 212, 
    266, 664, 383, 648, 432, 373, 382, 673, 
    689
  )

Query time 0.00121

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "108.76"
    },
    "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": 210,
      "rows_produced_per_join": 210,
      "filtered": "100.00",
      "index_condition": "(`softwarepirmam_hewadelivard_cscart_4`.`cscart_product_variation_group_products`.`group_id` in (620,623,260,627,608,628,410,647,559,354,433,372,642,195,646,571,306,675,305,625,409,547,261,453,562,561,556,364,363,622,621,404,282,552,661,352,564,346,345,418,252,681,155,466,666,353,381,212,266,664,383,648,432,373,382,673,689))",
      "cost_info": {
        "read_cost": "87.76",
        "eval_cost": "21.00",
        "prefix_cost": "108.76",
        "data_read_per_join": "3K"
      },
      "used_columns": [
        "product_id",
        "group_id"
      ]
    }
  }
}

Result

product_id group_id
2227 155
2226 155
2430 195
2431 195
2522 212
2655 252
2698 260
2702 261
2703 261
2719 266
2728 266
2805 282
2808 282
2922 305
2923 305
2924 306
2925 306
3112 345
3113 345
3114 346
3115 346
3150 352
3151 352
3042 353
3153 353
3155 354
3156 354
3213 363
3214 363
3216 364
3215 364
2737 372
3255 372
3290 373
3289 373
3377 381
3378 381
3382 382
3383 382
3385 383
3386 383
3552 404
3553 404
3604 409
3603 409
3605 410
3606 410
3664 418
3665 418
3832 432
3831 432
3834 433
3835 433
4024 453
3649 453
4026 453
4025 453
4110 466
4111 466
3811 466
4899 547
4898 547
4897 547
4896 547
4894 547
4915 552
4917 552
4924 552
4923 552
4922 552
4921 552
4920 552
4919 552
4918 552
4925 552
4927 552
4926 552
4944 556
4942 556
4945 556
4951 559
4953 559
4959 561
4958 561
4973 562
4972 562
4971 562
4970 562
4969 562
4968 562
4967 562
4966 562
4965 562
4964 562
4963 562
4962 562
4987 564
4986 564
4985 564
4984 564
4977 564
4976 564
4981 564
4980 564
4979 564
4978 564
4982 564
4983 564
5117 571
5116 571
5114 571
5618 608
5619 608
5620 608
5621 608
6149 620
5685 620
6148 620
6150 620
6151 620
5687 621
5688 621
5689 621
5690 621
5691 622
5692 622
5693 622
5694 622
5696 623
5697 623
5698 623
5699 623
5703 625
5704 625
5705 625
5721 627
5722 627
5723 627
5724 628
5725 628
5726 628
5894 642
5893 642
5892 642
5934 646
5935 646
5944 647
5945 647
5946 647
5947 647
6119 647
6120 647
6121 647
6122 647
6123 647
6124 647
6125 647
5948 648
6128 648
6127 648
6126 648
6129 648
6130 648
6131 648
6132 648
6133 648
6134 648
6135 648
6026 661
6025 661
6027 661
6028 661
6029 661
6030 661
6041 664
6042 664
6043 664
6044 664
6045 664
6046 664
6047 664
6054 666
6055 666
6056 666
6057 666
6058 666
6059 666
5956 673
6087 673
6088 673
6089 673
6090 673
6091 673
6092 673
6093 673
6098 675
6100 675
5683 681
6152 681
6153 681
6154 681
6155 681
6196 689
6195 689
6194 689
6197 689
6198 689
6199 689
6200 689
6201 689
6202 689