Symfony Profiler

Query Metrics

20 Database Queries

16 Different statements

24.63 ms Query time

0 Invalid entities

28 Managed entities

5 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

2.97 ms
(12.08%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.phone AS phone_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.email AS email_7, t0.www AS www_8, t0.facebook AS facebook_9, t0.twitter AS twitter_10, t0.soundcloud AS soundcloud_11, t0.youtube AS youtube_12, t0.status AS status_13, t0.type AS type_14, t0.google_place_id AS google_place_id_15, t0.slug AS slug_16, t0.date_add AS date_add_17, t0.date_upd AS date_upd_18, t0.user_id AS user_id_19, t0.city_id AS city_id_20 FROM venue t0 WHERE t0.id = ?

Parameters:

[
  181
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.phone AS phone_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.email AS email_7,
  t0.www AS www_8,
  t0.facebook AS facebook_9,
  t0.twitter AS twitter_10,
  t0.soundcloud AS soundcloud_11,
  t0.youtube AS youtube_12,
  t0.status AS status_13,
  t0.type AS type_14,
  t0.google_place_id AS google_place_id_15,
  t0.slug AS slug_16,
  t0.date_add AS date_add_17,
  t0.date_upd AS date_upd_18,
  t0.user_id AS user_id_19,
  t0.city_id AS city_id_20
FROM
  venue t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.phone AS phone_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.email AS email_7, t0.www AS www_8, t0.facebook AS facebook_9, t0.twitter AS twitter_10, t0.soundcloud AS soundcloud_11, t0.youtube AS youtube_12, t0.status AS status_13, t0.type AS type_14, t0.google_place_id AS google_place_id_15, t0.slug AS slug_16, t0.date_add AS date_add_17, t0.date_upd AS date_upd_18, t0.user_id AS user_id_19, t0.city_id AS city_id_20 FROM venue t0 WHERE t0.id = 181;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1794)
5	__TwigTemplate_1917670407e8045bb86c83a3624fad7f::doDisplay (line 79)
6	Twig\Template->yield (line 411)
7	__TwigTemplate_8df457c4b9f0b7828cdaa945687da54e->block_main (line 906)
8	Twig\Template->yieldBlock (line 456)
9	__TwigTemplate_908fe77b0e1f5923906edfd8c2ecbfe6->doDisplay (line 209)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_8df457c4b9f0b7828cdaa945687da54e->doDisplay (line 73)
12	Twig\Template->yield (line 411)
13	Twig\Template->display (line 366)
14	Twig\Template->render (line 381)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
20	App\Controller\Front\BandController->profile (line 722)
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)

2.63 ms
(10.67%)

SELECT e0_.id AS id_0, e0_.date_event AS date_event_1, e0_.location AS location_2, e0_.address AS address_3, e0_.latitude AS latitude_4, e0_.longitude AS longitude_5, e0_.poster_name AS poster_name_6, e0_.poster_thumb_name AS poster_thumb_name_7, e0_.active AS active_8, e0_.deleted AS deleted_9, e0_.bandsintown_event_id AS bandsintown_event_id_10, e0_.venue_pending AS venue_pending_11, e0_.excluded_from_ranking AS excluded_from_ranking_12, e0_.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_13, e0_.price AS price_14, e0_.access AS access_15, e0_.date_add AS date_add_16, e0_.date_upd AS date_upd_17, e0_.followers_notified_at AS followers_notified_at_18, e0_.reminder_day_before_sent_at AS reminder_day_before_sent_at_19, e0_.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_20, e1_.id AS id_21, e1_.title AS title_22, e1_.slug AS slug_23, e1_.description AS description_24, e1_.notes AS notes_25, e0_.venue_id AS venue_id_26, e0_.artist_id AS artist_id_27, e0_.band_id AS band_id_28, e0_.opener_id AS opener_id_29, e1_.event_id AS event_id_30, e1_.language_id AS language_id_31 FROM event e0_ LEFT JOIN event_lang e1_ ON e0_.id = e1_.event_id AND (e1_.language_id = ?) WHERE e0_.band_id = ? AND e0_.date_event < ? AND e0_.active = 1 AND e0_.deleted = 0 AND e0_.venue_pending = 0 ORDER BY e0_.date_event DESC, e0_.id DESC LIMIT 4

Parameters:

[
  2
  13
  "2026-11-02 13:06:06"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.date_event AS date_event_1,
  e0_.location AS location_2,
  e0_.address AS address_3,
  e0_.latitude AS latitude_4,
  e0_.longitude AS longitude_5,
  e0_.poster_name AS poster_name_6,
  e0_.poster_thumb_name AS poster_thumb_name_7,
  e0_.active AS active_8,
  e0_.deleted AS deleted_9,
  e0_.bandsintown_event_id AS bandsintown_event_id_10,
  e0_.venue_pending AS venue_pending_11,
  e0_.excluded_from_ranking AS excluded_from_ranking_12,
  e0_.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_13,
  e0_.price AS price_14,
  e0_.access AS access_15,
  e0_.date_add AS date_add_16,
  e0_.date_upd AS date_upd_17,
  e0_.followers_notified_at AS followers_notified_at_18,
  e0_.reminder_day_before_sent_at AS reminder_day_before_sent_at_19,
  e0_.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_20,
  e1_.id AS id_21,
  e1_.title AS title_22,
  e1_.slug AS slug_23,
  e1_.description AS description_24,
  e1_.notes AS notes_25,
  e0_.venue_id AS venue_id_26,
  e0_.artist_id AS artist_id_27,
  e0_.band_id AS band_id_28,
  e0_.opener_id AS opener_id_29,
  e1_.event_id AS event_id_30,
  e1_.language_id AS language_id_31
FROM
  event e0_
  LEFT JOIN event_lang e1_ ON e0_.id = e1_.event_id
  AND (e1_.language_id = ?)
WHERE
  e0_.band_id = ?
  AND e0_.date_event < ?
  AND e0_.active = 1
  AND e0_.deleted = 0
  AND e0_.venue_pending = 0
ORDER BY
  e0_.date_event DESC,
  e0_.id DESC
LIMIT
  4

SELECT e0_.id AS id_0, e0_.date_event AS date_event_1, e0_.location AS location_2, e0_.address AS address_3, e0_.latitude AS latitude_4, e0_.longitude AS longitude_5, e0_.poster_name AS poster_name_6, e0_.poster_thumb_name AS poster_thumb_name_7, e0_.active AS active_8, e0_.deleted AS deleted_9, e0_.bandsintown_event_id AS bandsintown_event_id_10, e0_.venue_pending AS venue_pending_11, e0_.excluded_from_ranking AS excluded_from_ranking_12, e0_.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_13, e0_.price AS price_14, e0_.access AS access_15, e0_.date_add AS date_add_16, e0_.date_upd AS date_upd_17, e0_.followers_notified_at AS followers_notified_at_18, e0_.reminder_day_before_sent_at AS reminder_day_before_sent_at_19, e0_.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_20, e1_.id AS id_21, e1_.title AS title_22, e1_.slug AS slug_23, e1_.description AS description_24, e1_.notes AS notes_25, e0_.venue_id AS venue_id_26, e0_.artist_id AS artist_id_27, e0_.band_id AS band_id_28, e0_.opener_id AS opener_id_29, e1_.event_id AS event_id_30, e1_.language_id AS language_id_31 FROM event e0_ LEFT JOIN event_lang e1_ ON e0_.id = e1_.event_id AND (e1_.language_id = 2) WHERE e0_.band_id = 13 AND e0_.date_event < '2026-11-02 13:06:06' AND e0_.active = 1 AND e0_.deleted = 0 AND e0_.venue_pending = 0 ORDER BY e0_.date_event DESC, e0_.id DESC LIMIT 4;

#	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\EventRepository->findPastEventsByBandBeforeDate (line 427)
7	App\Domain\Event\QueryHandler\EventGetPastEventsByBandAndDateQueryHandler->__invoke (line 29)
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\BandController->profile (line 701)
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)

2.63 ms
(10.66%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.state AS state_4, t0.people AS people_5, t0.google_place_id AS google_place_id_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.country_id AS country_id_9 FROM city t0 WHERE t0.id = ?

Parameters:

[
  4071
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.state AS state_4,
  t0.people AS people_5,
  t0.google_place_id AS google_place_id_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8,
  t0.country_id AS country_id_9
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.state AS state_4, t0.people AS people_5, t0.google_place_id AS google_place_id_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.country_id AS country_id_9 FROM city t0 WHERE t0.id = 4071;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1794)
5	__TwigTemplate_8df457c4b9f0b7828cdaa945687da54e::block_main (line 416)
6	Twig\Template->yieldBlock (line 456)
7	__TwigTemplate_908fe77b0e1f5923906edfd8c2ecbfe6->doDisplay (line 209)
8	Twig\Template->yield (line 411)
9	__TwigTemplate_8df457c4b9f0b7828cdaa945687da54e->doDisplay (line 73)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
18	App\Controller\Front\BandController->profile (line 722)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 208)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

1.96 ms
(7.97%)

SELECT e0_.id AS id_0, e0_.date_event AS date_event_1, e0_.location AS location_2, e0_.address AS address_3, e0_.latitude AS latitude_4, e0_.longitude AS longitude_5, e0_.poster_name AS poster_name_6, e0_.poster_thumb_name AS poster_thumb_name_7, e0_.active AS active_8, e0_.deleted AS deleted_9, e0_.bandsintown_event_id AS bandsintown_event_id_10, e0_.venue_pending AS venue_pending_11, e0_.excluded_from_ranking AS excluded_from_ranking_12, e0_.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_13, e0_.price AS price_14, e0_.access AS access_15, e0_.date_add AS date_add_16, e0_.date_upd AS date_upd_17, e0_.followers_notified_at AS followers_notified_at_18, e0_.reminder_day_before_sent_at AS reminder_day_before_sent_at_19, e0_.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_20, e1_.id AS id_21, e1_.title AS title_22, e1_.slug AS slug_23, e1_.description AS description_24, e1_.notes AS notes_25, e0_.venue_id AS venue_id_26, e0_.artist_id AS artist_id_27, e0_.band_id AS band_id_28, e0_.opener_id AS opener_id_29, e1_.event_id AS event_id_30, e1_.language_id AS language_id_31 FROM event e0_ LEFT JOIN event_lang e1_ ON e0_.id = e1_.event_id AND (e1_.language_id = ?) WHERE e0_.band_id = ? AND e0_.date_event >= ? AND e0_.venue_pending = 0 ORDER BY e0_.date_event ASC, e0_.id ASC LIMIT 4

Parameters:

[
  2
  13
  "2026-11-02 13:06:06"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.date_event AS date_event_1,
  e0_.location AS location_2,
  e0_.address AS address_3,
  e0_.latitude AS latitude_4,
  e0_.longitude AS longitude_5,
  e0_.poster_name AS poster_name_6,
  e0_.poster_thumb_name AS poster_thumb_name_7,
  e0_.active AS active_8,
  e0_.deleted AS deleted_9,
  e0_.bandsintown_event_id AS bandsintown_event_id_10,
  e0_.venue_pending AS venue_pending_11,
  e0_.excluded_from_ranking AS excluded_from_ranking_12,
  e0_.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_13,
  e0_.price AS price_14,
  e0_.access AS access_15,
  e0_.date_add AS date_add_16,
  e0_.date_upd AS date_upd_17,
  e0_.followers_notified_at AS followers_notified_at_18,
  e0_.reminder_day_before_sent_at AS reminder_day_before_sent_at_19,
  e0_.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_20,
  e1_.id AS id_21,
  e1_.title AS title_22,
  e1_.slug AS slug_23,
  e1_.description AS description_24,
  e1_.notes AS notes_25,
  e0_.venue_id AS venue_id_26,
  e0_.artist_id AS artist_id_27,
  e0_.band_id AS band_id_28,
  e0_.opener_id AS opener_id_29,
  e1_.event_id AS event_id_30,
  e1_.language_id AS language_id_31
FROM
  event e0_
  LEFT JOIN event_lang e1_ ON e0_.id = e1_.event_id
  AND (e1_.language_id = ?)
WHERE
  e0_.band_id = ?
  AND e0_.date_event >= ?
  AND e0_.venue_pending = 0
ORDER BY
  e0_.date_event ASC,
  e0_.id ASC
LIMIT
  4

SELECT e0_.id AS id_0, e0_.date_event AS date_event_1, e0_.location AS location_2, e0_.address AS address_3, e0_.latitude AS latitude_4, e0_.longitude AS longitude_5, e0_.poster_name AS poster_name_6, e0_.poster_thumb_name AS poster_thumb_name_7, e0_.active AS active_8, e0_.deleted AS deleted_9, e0_.bandsintown_event_id AS bandsintown_event_id_10, e0_.venue_pending AS venue_pending_11, e0_.excluded_from_ranking AS excluded_from_ranking_12, e0_.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_13, e0_.price AS price_14, e0_.access AS access_15, e0_.date_add AS date_add_16, e0_.date_upd AS date_upd_17, e0_.followers_notified_at AS followers_notified_at_18, e0_.reminder_day_before_sent_at AS reminder_day_before_sent_at_19, e0_.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_20, e1_.id AS id_21, e1_.title AS title_22, e1_.slug AS slug_23, e1_.description AS description_24, e1_.notes AS notes_25, e0_.venue_id AS venue_id_26, e0_.artist_id AS artist_id_27, e0_.band_id AS band_id_28, e0_.opener_id AS opener_id_29, e1_.event_id AS event_id_30, e1_.language_id AS language_id_31 FROM event e0_ LEFT JOIN event_lang e1_ ON e0_.id = e1_.event_id AND (e1_.language_id = 2) WHERE e0_.band_id = 13 AND e0_.date_event >= '2026-11-02 13:06:06' AND e0_.venue_pending = 0 ORDER BY e0_.date_event ASC, e0_.id ASC LIMIT 4;

#	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\EventRepository->findNextEventsByBandAndDate (line 396)
7	App\Domain\Event\QueryHandler\EventGetNextEventsByBandAndDateQueryHandler->{closure:App\Domain\Event\QueryHandler\EventGetNextEventsByBandAndDateQueryHandler::__invoke():24} (line 28)
8	App\Domain\Event\QueryHandler\EventGetNextEventsByBandAndDateQueryHandler->__invoke (line 53)
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\BandController->profile (line 688)
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.82 ms
(7.41%)

SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM event_vote_reaction e1_ INNER JOIN event_vote e0_ ON e1_.vote_id = e0_.id INNER JOIN event e2_ ON e0_.event_id = e2_.id WHERE e2_.band_id = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT e0_.id) AS sclr_0
FROM
  event_vote_reaction e1_
  INNER JOIN event_vote e0_ ON e1_.vote_id = e0_.id
  INNER JOIN event e2_ ON e0_.event_id = e2_.id
WHERE
  e2_.band_id = ?

SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM event_vote_reaction e1_ INNER JOIN event_vote e0_ ON e1_.vote_id = e0_.id INNER JOIN event e2_ ON e0_.event_id = e2_.id WHERE e2_.band_id = 13;

#	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\EventVoteReactionRepository->countVotesWithReactionsByBand (line 58)
8	App\Domain\Band\QueryHandler\BandGetReactionSummaryQueryHandler->__invoke (line 23)
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\BandController->profile (line 718)
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.57 ms
(6.36%)

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:06:07"
  "2026-11-02 13:06: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:06:07' AND c0_.ends_at >= '2026-11-02 13:06: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_8df457c4b9f0b7828cdaa945687da54e::block_header (line 291)
15	Twig\Template->yieldBlock (line 456)
16	__TwigTemplate_908fe77b0e1f5923906edfd8c2ecbfe6->doDisplay (line 171)
17	Twig\Template->yield (line 411)
18	__TwigTemplate_8df457c4b9f0b7828cdaa945687da54e->doDisplay (line 73)
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\BandController->profile (line 722)
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)

1.55 ms
(6.28%)

SELECT e0_.reaction AS reaction_0, COUNT(e0_.id) AS sclr_1 FROM event_vote_reaction e0_ INNER JOIN event_vote e1_ ON e0_.vote_id = e1_.id INNER JOIN event e2_ ON e1_.event_id = e2_.id WHERE e2_.band_id = ? GROUP BY e0_.reaction

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.reaction AS reaction_0,
  COUNT(e0_.id) AS sclr_1
FROM
  event_vote_reaction e0_
  INNER JOIN event_vote e1_ ON e0_.vote_id = e1_.id
  INNER JOIN event e2_ ON e1_.event_id = e2_.id
WHERE
  e2_.band_id = ?
GROUP BY
  e0_.reaction

SELECT e0_.reaction AS reaction_0, COUNT(e0_.id) AS sclr_1 FROM event_vote_reaction e0_ INNER JOIN event_vote e1_ ON e0_.vote_id = e1_.id INNER JOIN event e2_ ON e1_.event_id = e2_.id WHERE e2_.band_id = 13 GROUP BY e0_.reaction;

#	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->getArrayResult (line 700)
6	App\Repository\EventVoteReactionRepository->countByBand (line 35)
7	App\Domain\Band\QueryHandler\BandGetReactionSummaryQueryHandler->__invoke (line 24)
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\BandController->profile (line 718)
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.53 ms
(6.22%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.canonical_email AS canonical_email_3, t0.roles AS roles_4, t0.username AS username_5, t0.password AS password_6, t0.secure_key AS secure_key_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.phone AS phone_10, t0.avatar AS avatar_11, t0.avatar_thumbnail AS avatar_thumbnail_12, t0.jwt AS jwt_13, t0.timezone AS timezone_14, t0.optin AS optin_15, t0.newsletter AS newsletter_16, t0.is_verified AS is_verified_17, t0.is_blocked AS is_blocked_18, t0.is_deleted AS is_deleted_19, t0.last_registration_link_request AS last_registration_link_request_20, t0.last_login_link_request AS last_login_link_request_21, t0.last_login AS last_login_22, t0.country AS country_23, t0.google AS google_24, t0.facebook AS facebook_25, t0.apple AS apple_26, t0.date_add AS date_add_27, t0.date_upd AS date_upd_28, t0.language_id AS language_id_29, t30.id AS id_31, t30.firstname AS firstname_32, t30.lastname AS lastname_33, t30.nickname AS nickname_34, t30.slug AS slug_35, t30.excerpt AS excerpt_36, t30.mood AS mood_37, t30.exhibition AS exhibition_38, t30.crew AS crew_39, t30.biography AS biography_40, t30.original AS original_41, t30.cover AS cover_42, t30.instrumentation AS instrumentation_43, t30.willingness AS willingness_44, t30.www AS www_45, t30.facebook AS facebook_46, t30.twitter AS twitter_47, t30.soundcloud AS soundcloud_48, t30.youtube AS youtube_49, t30.avatar AS avatar_50, t30.wide AS wide_51, t30.thumb AS thumb_52, t30.privacy AS privacy_53, t30.solo_artist AS solo_artist_54, t30.avatar_name AS avatar_name_55, t30.avatar_thumb_name AS avatar_thumb_name_56, t30.cover_name AS cover_name_57, t30.date_add AS date_add_58, t30.date_upd AS date_upd_59, t30.last_inactivity_reminder_at AS last_inactivity_reminder_at_60, t30.inactivity_reminder_count AS inactivity_reminder_count_61, t30.user_id AS user_id_62, t30.preferred_band_id AS preferred_band_id_63, t30.invited_by_id AS invited_by_id_64 FROM user t0 LEFT JOIN artist t30 ON t30.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  21
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.canonical_email AS canonical_email_3,
  t0.roles AS roles_4,
  t0.username AS username_5,
  t0.password AS password_6,
  t0.secure_key AS secure_key_7,
  t0.firstname AS firstname_8,
  t0.lastname AS lastname_9,
  t0.phone AS phone_10,
  t0.avatar AS avatar_11,
  t0.avatar_thumbnail AS avatar_thumbnail_12,
  t0.jwt AS jwt_13,
  t0.timezone AS timezone_14,
  t0.optin AS optin_15,
  t0.newsletter AS newsletter_16,
  t0.is_verified AS is_verified_17,
  t0.is_blocked AS is_blocked_18,
  t0.is_deleted AS is_deleted_19,
  t0.last_registration_link_request AS last_registration_link_request_20,
  t0.last_login_link_request AS last_login_link_request_21,
  t0.last_login AS last_login_22,
  t0.country AS country_23,
  t0.google AS google_24,
  t0.facebook AS facebook_25,
  t0.apple AS apple_26,
  t0.date_add AS date_add_27,
  t0.date_upd AS date_upd_28,
  t0.language_id AS language_id_29,
  t30.id AS id_31,
  t30.firstname AS firstname_32,
  t30.lastname AS lastname_33,
  t30.nickname AS nickname_34,
  t30.slug AS slug_35,
  t30.excerpt AS excerpt_36,
  t30.mood AS mood_37,
  t30.exhibition AS exhibition_38,
  t30.crew AS crew_39,
  t30.biography AS biography_40,
  t30.original AS original_41,
  t30.cover AS cover_42,
  t30.instrumentation AS instrumentation_43,
  t30.willingness AS willingness_44,
  t30.www AS www_45,
  t30.facebook AS facebook_46,
  t30.twitter AS twitter_47,
  t30.soundcloud AS soundcloud_48,
  t30.youtube AS youtube_49,
  t30.avatar AS avatar_50,
  t30.wide AS wide_51,
  t30.thumb AS thumb_52,
  t30.privacy AS privacy_53,
  t30.solo_artist AS solo_artist_54,
  t30.avatar_name AS avatar_name_55,
  t30.avatar_thumb_name AS avatar_thumb_name_56,
  t30.cover_name AS cover_name_57,
  t30.date_add AS date_add_58,
  t30.date_upd AS date_upd_59,
  t30.last_inactivity_reminder_at AS last_inactivity_reminder_at_60,
  t30.inactivity_reminder_count AS inactivity_reminder_count_61,
  t30.user_id AS user_id_62,
  t30.preferred_band_id AS preferred_band_id_63,
  t30.invited_by_id AS invited_by_id_64
FROM
  user t0
  LEFT JOIN artist t30 ON t30.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.canonical_email AS canonical_email_3, t0.roles AS roles_4, t0.username AS username_5, t0.password AS password_6, t0.secure_key AS secure_key_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.phone AS phone_10, t0.avatar AS avatar_11, t0.avatar_thumbnail AS avatar_thumbnail_12, t0.jwt AS jwt_13, t0.timezone AS timezone_14, t0.optin AS optin_15, t0.newsletter AS newsletter_16, t0.is_verified AS is_verified_17, t0.is_blocked AS is_blocked_18, t0.is_deleted AS is_deleted_19, t0.last_registration_link_request AS last_registration_link_request_20, t0.last_login_link_request AS last_login_link_request_21, t0.last_login AS last_login_22, t0.country AS country_23, t0.google AS google_24, t0.facebook AS facebook_25, t0.apple AS apple_26, t0.date_add AS date_add_27, t0.date_upd AS date_upd_28, t0.language_id AS language_id_29, t30.id AS id_31, t30.firstname AS firstname_32, t30.lastname AS lastname_33, t30.nickname AS nickname_34, t30.slug AS slug_35, t30.excerpt AS excerpt_36, t30.mood AS mood_37, t30.exhibition AS exhibition_38, t30.crew AS crew_39, t30.biography AS biography_40, t30.original AS original_41, t30.cover AS cover_42, t30.instrumentation AS instrumentation_43, t30.willingness AS willingness_44, t30.www AS www_45, t30.facebook AS facebook_46, t30.twitter AS twitter_47, t30.soundcloud AS soundcloud_48, t30.youtube AS youtube_49, t30.avatar AS avatar_50, t30.wide AS wide_51, t30.thumb AS thumb_52, t30.privacy AS privacy_53, t30.solo_artist AS solo_artist_54, t30.avatar_name AS avatar_name_55, t30.avatar_thumb_name AS avatar_thumb_name_56, t30.cover_name AS cover_name_57, t30.date_add AS date_add_58, t30.date_upd AS date_upd_59, t30.last_inactivity_reminder_at AS last_inactivity_reminder_at_60, t30.inactivity_reminder_count AS inactivity_reminder_count_61, t30.user_id AS user_id_62, t30.preferred_band_id AS preferred_band_id_63, t30.invited_by_id AS invited_by_id_64 FROM user t0 LEFT JOIN artist t30 ON t30.user_id = t0.id WHERE t0.id = 21;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\User::getIsDeleted (line 457)
5	App\Entity\Band->{closure:App\Entity\Band::getArtists():356} (line 357)
6	array_filter (line 380)
7	Doctrine\Common\Collections\ArrayCollection::filter (line 380)
8	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 241)
9	App\Entity\Band->getArtists (line 356)
10	Twig\Extension\CoreExtension->getAttribute (line 1918)
11	__TwigTemplate_8df457c4b9f0b7828cdaa945687da54e::doDisplay (line 66)
12	Twig\Template->yield (line 411)
13	Twig\Template->display (line 366)
14	Twig\Template->render (line 381)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
20	App\Controller\Front\BandController->profile (line 722)
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.46 ms
(5.93%)

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.nickname AS nickname_4, t0.slug AS slug_5, t0.excerpt AS excerpt_6, t0.mood AS mood_7, t0.exhibition AS exhibition_8, t0.crew AS crew_9, t0.biography AS biography_10, t0.original AS original_11, t0.cover AS cover_12, t0.instrumentation AS instrumentation_13, t0.willingness AS willingness_14, t0.www AS www_15, t0.facebook AS facebook_16, t0.twitter AS twitter_17, t0.soundcloud AS soundcloud_18, t0.youtube AS youtube_19, t0.avatar AS avatar_20, t0.wide AS wide_21, t0.thumb AS thumb_22, t0.privacy AS privacy_23, t0.solo_artist AS solo_artist_24, t0.avatar_name AS avatar_name_25, t0.avatar_thumb_name AS avatar_thumb_name_26, t0.cover_name AS cover_name_27, t0.date_add AS date_add_28, t0.date_upd AS date_upd_29, t0.last_inactivity_reminder_at AS last_inactivity_reminder_at_30, t0.inactivity_reminder_count AS inactivity_reminder_count_31, t0.user_id AS user_id_32, t0.preferred_band_id AS preferred_band_id_33, t0.invited_by_id AS invited_by_id_34 FROM artist t0 INNER JOIN band_artist ON t0.id = band_artist.artist_id WHERE band_artist.band_id = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.nickname AS nickname_4,
  t0.slug AS slug_5,
  t0.excerpt AS excerpt_6,
  t0.mood AS mood_7,
  t0.exhibition AS exhibition_8,
  t0.crew AS crew_9,
  t0.biography AS biography_10,
  t0.original AS original_11,
  t0.cover AS cover_12,
  t0.instrumentation AS instrumentation_13,
  t0.willingness AS willingness_14,
  t0.www AS www_15,
  t0.facebook AS facebook_16,
  t0.twitter AS twitter_17,
  t0.soundcloud AS soundcloud_18,
  t0.youtube AS youtube_19,
  t0.avatar AS avatar_20,
  t0.wide AS wide_21,
  t0.thumb AS thumb_22,
  t0.privacy AS privacy_23,
  t0.solo_artist AS solo_artist_24,
  t0.avatar_name AS avatar_name_25,
  t0.avatar_thumb_name AS avatar_thumb_name_26,
  t0.cover_name AS cover_name_27,
  t0.date_add AS date_add_28,
  t0.date_upd AS date_upd_29,
  t0.last_inactivity_reminder_at AS last_inactivity_reminder_at_30,
  t0.inactivity_reminder_count AS inactivity_reminder_count_31,
  t0.user_id AS user_id_32,
  t0.preferred_band_id AS preferred_band_id_33,
  t0.invited_by_id AS invited_by_id_34
FROM
  artist t0
  INNER JOIN band_artist ON t0.id = band_artist.artist_id
WHERE
  band_artist.band_id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.nickname AS nickname_4, t0.slug AS slug_5, t0.excerpt AS excerpt_6, t0.mood AS mood_7, t0.exhibition AS exhibition_8, t0.crew AS crew_9, t0.biography AS biography_10, t0.original AS original_11, t0.cover AS cover_12, t0.instrumentation AS instrumentation_13, t0.willingness AS willingness_14, t0.www AS www_15, t0.facebook AS facebook_16, t0.twitter AS twitter_17, t0.soundcloud AS soundcloud_18, t0.youtube AS youtube_19, t0.avatar AS avatar_20, t0.wide AS wide_21, t0.thumb AS thumb_22, t0.privacy AS privacy_23, t0.solo_artist AS solo_artist_24, t0.avatar_name AS avatar_name_25, t0.avatar_thumb_name AS avatar_thumb_name_26, t0.cover_name AS cover_name_27, t0.date_add AS date_add_28, t0.date_upd AS date_upd_29, t0.last_inactivity_reminder_at AS last_inactivity_reminder_at_30, t0.inactivity_reminder_count AS inactivity_reminder_count_31, t0.user_id AS user_id_32, t0.preferred_band_id AS preferred_band_id_33, t0.invited_by_id AS invited_by_id_34 FROM artist t0 INNER JOIN band_artist ON t0.id = band_artist.artist_id WHERE band_artist.band_id = 13;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2737)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 239)
7	App\Entity\Band->getArtists (line 356)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_8df457c4b9f0b7828cdaa945687da54e::doDisplay (line 66)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
18	App\Controller\Front\BandController->profile (line 722)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 208)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

1.12 ms
(4.56%)

SELECT t0.id AS id_1, t0.description_short AS description_short_2, t0.description AS description_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.band_id AS band_id_6, t0.lang_id AS lang_id_7 FROM band_lang t0 WHERE t0.band_id = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description_short AS description_short_2,
  t0.description AS description_3,
  t0.date_add AS date_add_4,
  t0.date_upd AS date_upd_5,
  t0.band_id AS band_id_6,
  t0.lang_id AS lang_id_7
FROM
  band_lang t0
WHERE
  t0.band_id = ?

SELECT t0.id AS id_1, t0.description_short AS description_short_2, t0.description AS description_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.band_id AS band_id_6, t0.lang_id AS lang_id_7 FROM band_lang t0 WHERE t0.band_id = 13;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\Band->getBandLangByLocale (line 562)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_8df457c4b9f0b7828cdaa945687da54e::doDisplay (line 64)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
18	App\Controller\Front\BandController->profile (line 722)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 208)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

1.04 ms
(4.23%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.active AS active_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5 FROM music_genre t0 INNER JOIN band_music_genre ON t0.id = band_music_genre.music_genre_id WHERE band_music_genre.band_id = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.active AS active_3,
  t0.date_add AS date_add_4,
  t0.date_upd AS date_upd_5
FROM
  music_genre t0
  INNER JOIN band_music_genre ON t0.id = band_music_genre.music_genre_id
WHERE
  band_music_genre.band_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.active AS active_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5 FROM music_genre t0 INNER JOIN band_music_genre ON t0.id = band_music_genre.music_genre_id WHERE band_music_genre.band_id = 13;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2737)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_8df457c4b9f0b7828cdaa945687da54e::block_main (line 431)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_908fe77b0e1f5923906edfd8c2ecbfe6->doDisplay (line 209)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_8df457c4b9f0b7828cdaa945687da54e->doDisplay (line 73)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
22	App\Controller\Front\BandController->profile (line 722)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

1.00 ms
(4.06%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.file_name AS file_name_3, t0.position AS position_4, t0.date_add AS date_add_5, t0.band_id AS band_id_6 FROM band_media t0 WHERE t0.band_id = ? ORDER BY t0.position ASC

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.file_name AS file_name_3,
  t0.position AS position_4,
  t0.date_add AS date_add_5,
  t0.band_id AS band_id_6
FROM
  band_media t0
WHERE
  t0.band_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.file_name AS file_name_3, t0.position AS position_4, t0.date_add AS date_add_5, t0.band_id AS band_id_6 FROM band_media t0 WHERE t0.band_id = 13 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 239)
7	App\Entity\Band->getBandMediaByType (line 573)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_8df457c4b9f0b7828cdaa945687da54e::block_main (line 678)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_908fe77b0e1f5923906edfd8c2ecbfe6->doDisplay (line 209)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_8df457c4b9f0b7828cdaa945687da54e->doDisplay (line 73)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
22	App\Controller\Front\BandController->profile (line 722)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

1.00 ms
(4.04%)

SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.slug AS slug_4, t0.foundation_year AS foundation_year_5, t0.website AS website_6, t0.facebook AS facebook_7, t0.instagram AS instagram_8, t0.tiktok AS tiktok_9, t0.soundcloud AS soundcloud_10, t0.youtube AS youtube_11, t0.discord AS discord_12, t0.twitter AS twitter_13, t0.spotify AS spotify_14, t0.twitch AS twitch_15, t0.bandsintown AS bandsintown_16, t0.bandsintown_api_key AS bandsintown_api_key_17, t0.cover_name AS cover_name_18, t0.cover_thumb AS cover_thumb_19, t0.date_add AS date_add_20, t0.date_upd AS date_upd_21, t0.total_points AS total_points_22, t0.ranking_position AS ranking_position_23, t0.city_id AS city_id_24, t0.owner_id AS owner_id_25, t0.current_tier_id AS current_tier_id_26 FROM band t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "geno-his-rockin-dudes"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.foundation_year AS foundation_year_5,
  t0.website AS website_6,
  t0.facebook AS facebook_7,
  t0.instagram AS instagram_8,
  t0.tiktok AS tiktok_9,
  t0.soundcloud AS soundcloud_10,
  t0.youtube AS youtube_11,
  t0.discord AS discord_12,
  t0.twitter AS twitter_13,
  t0.spotify AS spotify_14,
  t0.twitch AS twitch_15,
  t0.bandsintown AS bandsintown_16,
  t0.bandsintown_api_key AS bandsintown_api_key_17,
  t0.cover_name AS cover_name_18,
  t0.cover_thumb AS cover_thumb_19,
  t0.date_add AS date_add_20,
  t0.date_upd AS date_upd_21,
  t0.total_points AS total_points_22,
  t0.ranking_position AS ranking_position_23,
  t0.city_id AS city_id_24,
  t0.owner_id AS owner_id_25,
  t0.current_tier_id AS current_tier_id_26
FROM
  band t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.slug AS slug_4, t0.foundation_year AS foundation_year_5, t0.website AS website_6, t0.facebook AS facebook_7, t0.instagram AS instagram_8, t0.tiktok AS tiktok_9, t0.soundcloud AS soundcloud_10, t0.youtube AS youtube_11, t0.discord AS discord_12, t0.twitter AS twitter_13, t0.spotify AS spotify_14, t0.twitch AS twitch_15, t0.bandsintown AS bandsintown_16, t0.bandsintown_api_key AS bandsintown_api_key_17, t0.cover_name AS cover_name_18, t0.cover_thumb AS cover_thumb_19, t0.date_add AS date_add_20, t0.date_upd AS date_upd_21, t0.total_points AS total_points_22, t0.ranking_position AS ranking_position_23, t0.city_id AS city_id_24, t0.owner_id AS owner_id_25, t0.current_tier_id AS current_tier_id_26 FROM band t0 WHERE t0.slug = 'geno-his-rockin-dudes' 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\Controller\Front\BandController->profile (line 673)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 208)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.95 ms
(3.85%)

SELECT COUNT(u0_.id) AS sclr_0 FROM user_band_follow u0_ WHERE u0_.band_id = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user_band_follow u0_
WHERE
  u0_.band_id = ?

SELECT COUNT(u0_.id) AS sclr_0 FROM user_band_follow u0_ WHERE u0_.band_id = 13;

#	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\Domain\Band\QueryHandler\BandGetFollowersCountQueryHandler->__invoke (line 28)
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\BandController->profile (line 678)
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)

0.75 ms
(3.04%)

SELECT t0.id AS id_1, t0.min_points AS min_points_2, t0.position AS position_3, t0.badge AS badge_4, t0.stars AS stars_5, t0.hex_code AS hex_code_6, t0.date_add AS date_add_7, t0.date_upd AS date_upd_8 FROM tier t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.min_points AS min_points_2,
  t0.position AS position_3,
  t0.badge AS badge_4,
  t0.stars AS stars_5,
  t0.hex_code AS hex_code_6,
  t0.date_add AS date_add_7,
  t0.date_upd AS date_upd_8
FROM
  tier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.min_points AS min_points_2, t0.position AS position_3, t0.badge AS badge_4, t0.stars AS stars_5, t0.hex_code AS hex_code_6, t0.date_add AS date_add_7, t0.date_upd AS date_upd_8 FROM tier t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\Tier::getTierLangs (line 63)
5	App\Entity\Tier->getTierByLangId (line 68)
6	Twig\Extension\CoreExtension->getAttribute (line 1918)
7	__TwigTemplate_8df457c4b9f0b7828cdaa945687da54e::doDisplay (line 70)
8	Twig\Template->yield (line 411)
9	Twig\Template->display (line 366)
10	Twig\Template->render (line 381)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
16	App\Controller\Front\BandController->profile (line 722)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 208)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.65 ms
(2.63%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.tier_id AS tier_id_3, t0.language_id AS language_id_4 FROM tier_lang t0 WHERE t0.tier_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tier_id AS tier_id_3,
  t0.language_id AS language_id_4
FROM
  tier_lang t0
WHERE
  t0.tier_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.tier_id AS tier_id_3, t0.language_id AS language_id_4 FROM tier_lang t0 WHERE t0.tier_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\Tier->getTierByLangId (line 68)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_8df457c4b9f0b7828cdaa945687da54e::doDisplay (line 70)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
18	App\Controller\Front\BandController->profile (line 722)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 208)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	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

5 Hits

0 Misses

0 Puts

Number of cache hits

Region	Hits
append_only	5

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Event	4
App\Entity\Venue	4
App\Entity\EventLang	4
App\Entity\City	3
App\Entity\Lang	2
App\Entity\BandLang	2
App\Entity\User	2
App\Entity\TierLang	2
App\Entity\Band	1
App\Entity\Artist	1
App\Entity\Tier	1
App\Entity\Country	1
App\Entity\BandMedia	1

Entities Mapping

Class	Mapping errors
App\Entity\Band	No errors.
App\Entity\City	No errors.
App\Entity\Artist	No errors.
App\Entity\Tier	No errors.
App\Entity\Event	No errors.
App\Entity\BandLang	No errors.
App\Entity\BandMedia	No errors.
App\Entity\MusicGenre	No errors.
App\Entity\UserBandFollow	No errors.
App\Entity\Lang	No errors.
App\Entity\EventLang	No errors.
App\Entity\Venue	No errors.
App\Entity\EventVote	No errors.
App\Entity\EventVoteReaction	No errors.
App\Entity\User	No errors.
App\Entity\ArtistLang	No errors.
App\Entity\ArtistType	No errors.
App\Entity\Instrument	No errors.
App\Entity\Notification	No errors.
App\Entity\TierLang	No errors.
App\Entity\CallForArtists	No errors.
App\Entity\Country	No errors.
App\Entity\VenueLang	No errors.

Symfony Profiler

GET https://app.dev.localero.it/band/profile/geno-his-rockin-dudes

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Number of cache hits

Managed Entities

default entity manager

Entities Mapping