SELECT 
  product_id, 
  group_id 
FROM 
  cscart_product_variation_group_products 
WHERE 
  group_id IN (
    226, 73, 203, 45, 213, 204, 812, 210, 201, 
    227, 183, 239, 415, 202, 208, 221, 228, 
    246, 217, 175, 234, 207, 235, 815, 225, 
    161, 215, 149
  )

Query time 0.00233

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "57.86"
    },
    "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": 113,
      "rows_produced_per_join": 113,
      "filtered": "100.00",
      "index_condition": "(`softwarepirmam_hewadelivard_cscart_4`.`cscart_product_variation_group_products`.`group_id` in (226,73,203,45,213,204,812,210,201,227,183,239,415,202,208,221,228,246,217,175,234,207,235,815,225,161,215,149))",
      "cost_info": {
        "read_cost": "46.56",
        "eval_cost": "11.30",
        "prefix_cost": "57.86",
        "data_read_per_join": "1K"
      },
      "used_columns": [
        "product_id",
        "group_id"
      ]
    }
  }
}

Result

product_id group_id
908 45
134 45
1254 73
1253 73
247 73
2109 149
2108 149
2107 149
2265 161
2264 161
2263 161
2253 161
2363 175
2364 175
2365 175
2395 183
2396 183
2397 183
2398 183
2467 201
2468 201
2469 201
2470 201
2471 201
2472 201
2473 202
2475 202
2476 202
2477 202
2478 203
2483 203
2482 203
2484 203
2485 203
2486 203
2487 203
2488 203
2489 203
2490 204
2491 204
2492 204
2493 204
2494 204
2495 204
2496 204
2497 204
2503 207
2504 207
2505 207
2506 208
2507 208
2508 208
2512 210
2513 210
2509 210
2514 210
2515 210
2516 210
2524 213
2525 213
2526 213
2527 213
2528 213
2529 213
2530 213
2531 213
2538 215
2540 215
2541 215
2550 217
2549 217
2548 217
2544 217
2551 217
2552 217
2534 221
2564 221
2565 221
2571 225
2572 225
8422 226
2574 226
2576 227
2577 227
2578 227
2579 228
2580 228
2596 234
2597 234
2598 234
2599 234
2600 234
2601 234
2602 235
2604 235
2605 235
2606 235
2607 235
2608 235
2615 239
2620 239
2621 239
2637 246
2638 246
2502 415
3639 415
2432 812
8485 812
8484 812
8483 812
2459 815
8492 815
8491 815
8493 815