SELECT 
  product_id, 
  group_id 
FROM 
  cscart_product_variation_group_products 
WHERE 
  group_id IN (
    433, 364, 363, 404, 434, 405, 380, 381, 
    470, 408, 432, 386, 379, 366, 399, 385, 
    437, 406, 446, 430, 374, 407, 377, 401, 
    436, 402, 384, 400
  )

Query time 0.00089

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "34.91"
    },
    "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": 62,
      "rows_produced_per_join": 62,
      "filtered": "100.00",
      "index_condition": "(`softwarepirmam_hewadelivard_cscart_4`.`cscart_product_variation_group_products`.`group_id` in (433,364,363,404,434,405,380,381,470,408,432,386,379,366,399,385,437,406,446,430,374,407,377,401,436,402,384,400))",
      "cost_info": {
        "read_cost": "28.71",
        "eval_cost": "6.20",
        "prefix_cost": "34.91",
        "data_read_per_join": "992"
      },
      "used_columns": [
        "product_id",
        "group_id"
      ]
    }
  }
}

Result

product_id group_id
3213 363
3214 363
3216 364
3215 364
3222 366
3223 366
3310 374
3309 374
3352 377
3351 377
3366 379
3367 379
3609 380
3370 380
3371 380
3377 381
3378 381
3398 384
3399 384
3401 385
3402 385
3404 386
3405 386
3522 399
3523 399
3525 400
3526 400
3532 401
3533 401
3548 402
3549 402
3552 404
3553 404
3610 405
3556 405
3557 405
3588 406
3559 406
3560 406
3591 407
3590 407
3593 408
3594 408
3812 430
3813 430
3832 432
3831 432
3834 433
3835 433
3836 434
3839 434
3838 434
3837 434
3873 436
3546 436
3876 437
3877 437
3923 446
3922 446
3373 470
4124 470
4125 470