Also use `pluck` instead of loading all objects in memory.

Add a multi-column index to `project_id` and `lfs_object_id` and
use a JOIN.

This also removes the existing `project_id` index since it'll be
redundant.

Utilize existing Projects::LfsPointers::LfsLinkService after
getting the OIDs of LFS objects that are present in the MR.

Also call the service in MergeRequests::RefreshService so if new
LFS object/s get pushed to MR's source branch, they will be linked
to target project as well (if they don't exist yet).

While backfilling LfsObjectsProject is ongoing, we should still
be looking at both the fork and source when finding for LFS
objects.

This way, older forks that are dependent on finding LFS objects
from the source, will still be able to find them. Newer forks,
should be able to find the object directly.

This is to avoid errors when pulling LFS objects in context of
the MR's target project.

These methods won't be necessary once all the `LfsObjectsProject`
are backfilled for forks.

When an existing project becomes a fork of another project, we
previously delete the LfsObjectsProject records of that fork.

Since we're now making each fork to have its own records, we
shouldn't delete records in that case anymore.

Previous behavior was `LfsObjectsProject` are created on the
source project.

To fix the issue whenever the source project gets deleted or
fork was selectively synced, we also need to create the records
for forks.

This way, they'll also have access to the `LfsObject` and no
longer dependent on the source project.

Load recaptcha config

Closes #202176

See merge request gitlab-org/gitlab!24539

Merge branch '17969-add-affected-projects-feature-to-instance-security-dashboard-frontend' into 'master'

Add vulnerable projects widget to instance security dashboard - frontend

See merge request gitlab-org/gitlab!24557

feat: x509 signed commits using openssl

See merge request gitlab-org/gitlab!17773

Simplify Group SAML SSO specs and run SAML IDP as a service at runtime

Closes #55242

See merge request gitlab-org/gitlab!24172

Also run IDP as a runtime service, create flows, refactor and
simplify all Group SAML specs

Expose theme and color scheme user preferences in API

See merge request gitlab-org/gitlab!24409

Updating tests. Validating newly exposed parameters

Blob header file path component

See merge request gitlab-org/gitlab!24354

2/4 components constituting the Blob File header component

Bump logs retention to 30 days

See merge request gitlab-org/gitlab!24466

Small typo in style_guides.md

See merge request gitlab-org/gitlab!24630

Regenerate feature_categories.yml from the website

See merge request gitlab-org/gitlab!24584

Add a tiny bit of Redis documentation, focusing on key naming for now

See merge request gitlab-org/gitlab!24270

Redact push options from error logs

Closes #202129

See merge request gitlab-org/gitlab!24540

Standardize QA tests' descriptions of the DevOps Plan stage

See merge request gitlab-org/gitlab!24621

Quarantine project audit logs for export events

See merge request gitlab-org/gitlab!24593

Fix RSpec cop violations

Closes #198581

See merge request gitlab-org/gitlab!24538

Fix a flaky unit test

See merge request gitlab-org/gitlab!24502

Fix group hook triggering from subgroup project

Closes #2372 and #12097

See merge request gitlab-org/gitlab!23333

This commit fixes a bug where group hooks on a
parent group where not triggered from a project
in a subgroup

Add pagination and new routing for docker container registry

See merge request gitlab-org/gitlab!23151

- routes for project
- routes for groups
- pagination in serialiser
- project controller
- group controller

fix: avoid setting user profile to public when updating via API

Closes #202070

See merge request gitlab-org/gitlab!24456

If a user is updated via a PUT API request and no value is
provided for the `private_profile` field, ignore it and do not set it to
the default value of public

Add search support for protected branches API

See merge request gitlab-org/gitlab!24137

A new `search` param is added to support searching for protected
branches by name.

This will be useful if user wants to look for a specific protected
branch but there are lots of protected branches per page.

Partially Resolve "Migrate spec/javascripts/environments/ to Jest"

Closes #194235

See merge request gitlab-org/gitlab!24084