Draft: Resolve "Further Optimise SAST Vulnerability Auto-Resolving with In-Operator Optimisation"

• Please check this box if this contribution uses AI-generated content (including content generated by GitLab Duo features) as outlined in the GitLab DCO & CLA

What does this MR do and why?

Problem

The current implementation of the vulnerability_ids_for method uses a standard active record query, which can be computationally intensive

Solution

Use Batch Iterator of the InOperatorOptimization module

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

Related to #428522