Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.66 ms Query time

0 Invalid entities

1 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

default connection

#▲

Time

Info

0.83 ms

SELECT t0.id AS id_1, t0.code AS code_2, t0.value AS value_3, t0.type AS type_4, t0.description AS description_5, t0.date_add AS date_add_6, t0.date_upd AS date_upd_7 FROM configuration t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "maintenance"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.value AS value_3,
  t0.type AS type_4,
  t0.description AS description_5,
  t0.date_add AS date_add_6,
  t0.date_upd AS date_upd_7
FROM
  configuration t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.value AS value_3, t0.type AS type_4, t0.description AS description_5, t0.date_add AS date_add_6, t0.date_upd AS date_upd_7 FROM configuration t0 WHERE t0.code = 'maintenance' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Repository\ConfigurationRepository->findOneByCode (line 23)
5	App\Service\ConfigurationService->{closure:App\Service\ConfigurationService::get():42} (line 45)
6	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():45} (line 48)
7	Symfony\Component\Cache\LockRegistry::compute (line 113)
8	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 67)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
12	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 53)
13	App\Service\ConfigurationService->get (line 42)
14	App\Service\ConfigurationService->getBool (line 66)
15	App\Service\MaintenanceChecker->isEnabled (line 24)
16	App\EventListener\MaintenanceListener->__invoke (line 30)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
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.66 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.32 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]+$"
  "l%"
]

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 'l%' 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)

0.86 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 14:01:46"
  "2026-11-02 14:01:46"
]

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 14:01:46' AND c0_.ends_at >= '2026-11-02 14:01:46' 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
App\Entity\Configuration	1

Entities Mapping

Class	Mapping errors
App\Entity\Configuration	No 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/l

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping