Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

5.33 ms Query time

0 Invalid entities

0 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

default connection

#▲

Time

Info

2.41 ms

SELECT DISTINCT UPPER(SUBSTRING(a0_.nickname FROM 1 FOR 1)) AS sclr_0 FROM artist a0_ WHERE a0_.nickname IS NOT NULL AND (a0_.nickname REGEXP ?) = 0 AND a0_.avatar_name IS NOT NULL

Parameters:

[
  "^artist_[0-9]+$"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT UPPER(
    SUBSTRING(
      a0_.nickname
      FROM
        1 FOR 1
    )
  ) AS sclr_0
FROM
  artist a0_
WHERE
  a0_.nickname IS NOT NULL
  AND (a0_.nickname REGEXP ?) = 0
  AND a0_.avatar_name IS NOT NULL

SELECT DISTINCT UPPER(SUBSTRING(a0_.nickname FROM 1 FOR 1)) AS sclr_0 FROM artist a0_ WHERE a0_.nickname IS NOT NULL AND (a0_.nickname REGEXP '^artist_[0-9]+$') = 0 AND a0_.avatar_name IS NOT NULL;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ArtistRepository->getArtistsFirstsLetter (line 208)
7	App\Domain\Artist\QueryHandler\ArtistGetAllFirstsLettersQueryHandler->__invoke (line 18)
8	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 152)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 91)
10	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 71)
11	Symfony\Component\Messenger\Middleware\ValidationMiddleware->handle (line 45)
12	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
13	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
14	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
15	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 37)
16	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 40)
17	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
18	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
19	App\Controller\Front\ArtistsController->index (line 41)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 208)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

1.12 ms

SELECT COUNT(a0_.id) AS sclr_0 FROM artist a0_ LEFT JOIN artist_lang a1_ ON a0_.id = a1_.artist_id AND (a0_.id = a1_.artist_id AND a1_.language_id = ?) WHERE a0_.nickname IS NOT NULL AND (a0_.nickname REGEXP ?) = 0 AND a0_.avatar_name IS NOT NULL AND a0_.nickname LIKE ? ESCAPE '!'

Parameters:

[
  2
  "^artist_[0-9]+$"
  "b%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  artist a0_
  LEFT JOIN artist_lang a1_ ON a0_.id = a1_.artist_id
  AND (
    a0_.id = a1_.artist_id
    AND a1_.language_id = ?
  )
WHERE
  a0_.nickname IS NOT NULL
  AND (a0_.nickname REGEXP ?) = 0
  AND a0_.avatar_name IS NOT NULL
  AND a0_.nickname LIKE ? ESCAPE '!'

SELECT COUNT(a0_.id) AS sclr_0 FROM artist a0_ LEFT JOIN artist_lang a1_ ON a0_.id = a1_.artist_id AND (a0_.id = a1_.artist_id AND a1_.language_id = 2) WHERE a0_.nickname IS NOT NULL AND (a0_.nickname REGEXP '^artist_[0-9]+$') = 0 AND a0_.avatar_name IS NOT NULL AND a0_.nickname LIKE 'b%' ESCAPE '!';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\ArtistRepository->countByFirstLetter (line 285)
8	App\Domain\Artist\QueryHandler\ArtistCountAllByFirstLetterQueryHandler->__invoke (line 18)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 152)
10	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 91)
11	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 71)
12	Symfony\Component\Messenger\Middleware\ValidationMiddleware->handle (line 45)
13	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
14	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
15	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
16	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 37)
17	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 40)
18	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
19	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
20	App\Controller\Front\ArtistsController->index (line 46)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 208)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

1.80 ms

SELECT c0_.id AS id_0 FROM call_for_artists c0_ WHERE c0_.starts_at <= ? AND c0_.ends_at >= ? LIMIT 1

Parameters:

[
  "2026-11-02 13:32:07"
  "2026-11-02 13:32:07"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0
FROM
  call_for_artists c0_
WHERE
  c0_.starts_at <= ?
  AND c0_.ends_at >= ?
LIMIT
  1

SELECT c0_.id AS id_0 FROM call_for_artists c0_ WHERE c0_.starts_at <= '2026-11-02 13:32:07' AND c0_.ends_at >= '2026-11-02 13:32:07' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\CallForArtistsRepository->hasOpen (line 44)
7	App\Twig\CallForArtistsExtension->hasOpenCallForArtists (line 35)
8	__TwigTemplate_743077446d456b9c74aef0d9b14b2b7f->doDisplay (line 50)
9	Twig\Template->yield (line 411)
10	Twig\Template->display (line 366)
11	Twig\Template->render (line 381)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Extension\CoreExtension->include (line 1522)
14	__TwigTemplate_52ae1097ae33744fd86770ca4dbd473b::block_header (line 194)
15	Twig\Template->yieldBlock (line 456)
16	__TwigTemplate_908fe77b0e1f5923906edfd8c2ecbfe6->doDisplay (line 171)
17	Twig\Template->yield (line 411)
18	__TwigTemplate_52ae1097ae33744fd86770ca4dbd473b->doDisplay (line 65)
19	Twig\Template->yield (line 411)
20	Twig\Template->display (line 366)
21	Twig\Template->render (line 381)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
27	App\Controller\Front\ArtistsController->index (line 73)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 208)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
messenger	doctrine.dbal.messenger_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

0 Hits

0 Misses

0 Puts

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
App\Entity\Artist	No errors.
App\Entity\ArtistLang	No errors.
App\Entity\CallForArtists	No errors.

Symfony Profiler

GET https://app.dev.localero.it/en/artists/b

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping