Refactor code involved in git workflow

See merge request gitlab-org/gitlab!22266

Expose reference path for issuables

See merge request gitlab-org/gitlab!20354

Preload project, user and group to reuse objects

Closes #39113

See merge request gitlab-org/gitlab!21853

Add section to database docs for alternative primary keys

See merge request gitlab-org/gitlab!22044

Expose issuable references in 3 options: short, relative and full.
Short and full aways display corresponding issuable reference,
while relative displays the reference depending on the context
from which it was referenced.

Refactor some methods, classes and specs in
preparation for versioned snippets.

review-performance (and other review jobs) should also use `rules`

See merge request gitlab-org/gitlab!22236

Resolve "Replace Font Awesome cog icon with GitLab settings icon"

Closes #121931

See merge request gitlab-org/gitlab!22259

Docs: Fix typo in command to enable feature flag

See merge request gitlab-org/gitlab!22242

Refactor spec file to use the same wrapper name to ensure consistency

Closes #37743

See merge request gitlab-org/gitlab!22181

Fix a typo

See merge request gitlab-org/gitlab!22248

Refactoring Service Desk configuration docs

Closes #119362

See merge request gitlab-org/gitlab!22053

Combining steps and removing redundant image

Move items from database MR template checklist to documentation

See merge request gitlab-org/gitlab!21051

Add some extra checkboxes to the database MR template,
e.g. ask author to add SQL and query plan to the
description.

Limit size of search query for postgresql search

See merge request gitlab-org/gitlab!22208

When using non ES search without limits, we can easily get Stack level
too deep error. To fix it we implemented terms and character limits
for the search#show action.

Add saml identity presence filtering option to members API

Closes #118475

See merge request gitlab-org/gitlab!21931

Use `with_saml_identity=true` param to filter out
members without saml identity linked. You'll
have to have access to read group saml identities
to use this filter

Speed up path generation with build artifacts

Closes #121929

See merge request gitlab-org/gitlab!22257

Fix stack trace highlight for PHP

Closes #121714

See merge request gitlab-org/gitlab!22258

Pick a first alternative language for Sentry stack trace highlight,
when Rouge can't decide which lexer to choose.

`StackTraceHighlightDecorator` now works with PHP and Hack languages

Previously it would take seconds to render the pipeline index JSON
(/gitlab-org/gitlab/pipelines.json) in the GitLab project. Apparently,
we render over 5000 paths for `BuildArtifactEntity`, and generation of
these paths dominated the request time.

The Rails path helpers are slow because they check the namespace and
project parameters against large regular expressions, which include
`TOP_LEVEL_ROUTES` and `PROJECT_WILDCARD_ROUTES`, respectively.

We can speed this up by generating the paths directly with
strings. While this isn't ideal, this results in a 10x improvement in
speed:

```
Calculating -------------------------------------
                orig    86.000  i/100ms
                 new     1.272k i/100ms
-------------------------------------------------
                orig      1.343k (±13.8%) i/s -      6.536k
                 new     13.756k (±15.3%) i/s -     67.416k

Comparison:
                 new:    13756.3 i/s
                orig:     1343.3 i/s - 10.24x slower
```

To prevent these helper methods from breaking if the routes ever change,
we add tests to ensure that the results are the same.

Closes https://gitlab.com/gitlab-org/gitlab/issues/121929

Surface language and urgency information on error detail page

See merge request gitlab-org/gitlab!22122

Added related badges under issue title

Eliminate N+1 queries in PipelinesController#index

Closes #118427

See merge request gitlab-org/gitlab!22189

Don't run migration tests in unit test jobs

Closes #121602

See merge request gitlab-org/gitlab!22218

https://gitlab.com/gitlab-org/gitlab/merge_requests/20615 introduced a
performance regression: each failed build would generate additional SQL
queries, since they would be rendered by JobEntity. This commit fixes
that by preloading failed builds among other items and adds an N+1 query
test. This adds 4 additional queries per pipeline:

1. user
2. latest_statuses_ordered_by_stage
3. failed_builds
4. failed_builds metadata

Closes https://gitlab.com/gitlab-org/gitlab/issues/118427

Fix identation
Fix changlog description

Add approximate duration function

See merge request gitlab-org/gitlab!21803

Based on the distance_of_time_in_words function
from rails to convert a time in seconds to an
approximate time.

Update asciidoctor-plantuml 0.0.9 -> 0.0.10

See merge request gitlab-org/gitlab!22205

Ci resource group status transition (v2)

See merge request gitlab-org/gitlab!21899