SELECT 
  product_id, 
  group_id 
FROM 
  cscart_product_variation_group_products 
WHERE 
  group_id IN (
    89, 527, 415, 202, 208, 819, 221, 229, 
    228, 246, 354, 433, 167, 505, 509, 372, 
    217, 219, 175, 471, 541, 642, 610, 289, 
    234, 284, 247, 249, 207, 235, 815, 195, 
    643, 646
  )

Query time 0.00132

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "63.41"
    },
    "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": 122,
      "rows_produced_per_join": 122,
      "filtered": "100.00",
      "index_condition": "(`softwarepirmam_hewadelivard_cscart_4`.`cscart_product_variation_group_products`.`group_id` in (89,527,415,202,208,819,221,229,228,246,354,433,167,505,509,372,217,219,175,471,541,642,610,289,234,284,247,249,207,235,815,195,643,646))",
      "cost_info": {
        "read_cost": "51.21",
        "eval_cost": "12.20",
        "prefix_cost": "63.41",
        "data_read_per_join": "1K"
      },
      "used_columns": [
        "product_id",
        "group_id"
      ]
    }
  }
}

Result

product_id group_id
1273 89
1420 89
1421 89
1422 89
1423 89
1424 89
2302 167
2301 167
2363 175
2364 175
2365 175
2430 195
2431 195
2473 202
2475 202
2476 202
2477 202
2503 207
2504 207
2505 207
2506 208
2507 208
2508 208
2550 217
2549 217
2548 217
2544 217
2551 217
2552 217
2559 219
2560 219
3663 219
2534 221
2564 221
2565 221
2579 228
2580 228
2300 229
2582 229
2583 229
2584 229
2596 234
2597 234
2598 234
2599 234
2600 234
2601 234
2602 235
2604 235
2605 235
2606 235
2607 235
2608 235
2637 246
2638 246
2641 247
2291 247
2639 247
2640 247
2647 249
2646 249
2822 284
2823 284
2824 284
2825 284
2826 284
2842 289
2843 289
2844 289
2845 289
2846 289
2847 289
3155 354
3156 354
2737 372
3255 372
2502 415
3639 415
3834 433
3835 433
4126 471
4127 471
4128 471
4129 471
4294 505
4295 505
4319 509
4320 509
4321 509
4311 509
4315 509
4316 509
4317 509
4318 509
4526 527
4527 527
4528 527
4529 527
4530 527
4531 527
4532 527
4533 527
4796 541
4797 541
5624 610
5625 610
5894 642
5893 642
5892 642
5900 643
5899 643
5934 646
5935 646
2459 815
8492 815
8491 815
8493 815
8500 819
1532 819
8502 819
8501 819
8499 819