Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

52.70 ms Query time

0 Invalid entities

7 Managed entities

3 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

47.39 ms
(89.93%)

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.address AS address_2, v0_.phone AS phone_3, v0_.latitude AS latitude_4, v0_.longitude AS longitude_5, v0_.email AS email_6, v0_.www AS www_7, v0_.facebook AS facebook_8, v0_.twitter AS twitter_9, v0_.soundcloud AS soundcloud_10, v0_.youtube AS youtube_11, v0_.status AS status_12, v0_.type AS type_13, v0_.google_place_id AS google_place_id_14, v0_.slug AS slug_15, v0_.date_add AS date_add_16, v0_.date_upd AS date_upd_17, v0_.user_id AS user_id_18, v0_.city_id AS city_id_19 FROM venue v0_ WHERE v0_.slug = ? AND v0_.type IN (?) LIMIT 1

Parameters:

[
  "basilica-di-sant-apollinare-in-classe"
  "PHYSICAL_VENUE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.name AS name_1,
  v0_.address AS address_2,
  v0_.phone AS phone_3,
  v0_.latitude AS latitude_4,
  v0_.longitude AS longitude_5,
  v0_.email AS email_6,
  v0_.www AS www_7,
  v0_.facebook AS facebook_8,
  v0_.twitter AS twitter_9,
  v0_.soundcloud AS soundcloud_10,
  v0_.youtube AS youtube_11,
  v0_.status AS status_12,
  v0_.type AS type_13,
  v0_.google_place_id AS google_place_id_14,
  v0_.slug AS slug_15,
  v0_.date_add AS date_add_16,
  v0_.date_upd AS date_upd_17,
  v0_.user_id AS user_id_18,
  v0_.city_id AS city_id_19
FROM
  venue v0_
WHERE
  v0_.slug = ?
  AND v0_.type IN (?)
LIMIT
  1

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.address AS address_2, v0_.phone AS phone_3, v0_.latitude AS latitude_4, v0_.longitude AS longitude_5, v0_.email AS email_6, v0_.www AS www_7, v0_.facebook AS facebook_8, v0_.twitter AS twitter_9, v0_.soundcloud AS soundcloud_10, v0_.youtube AS youtube_11, v0_.status AS status_12, v0_.type AS type_13, v0_.google_place_id AS google_place_id_14, v0_.slug AS slug_15, v0_.date_add AS date_add_16, v0_.date_upd AS date_upd_17, v0_.user_id AS user_id_18, v0_.city_id AS city_id_19 FROM venue v0_ WHERE v0_.slug = 'basilica-di-sant-apollinare-in-classe' AND v0_.type IN ('PHYSICAL_VENUE') 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\VenueRepository->findPubliclyVisibleBySlug (line 130)
7	App\Domain\Venue\QueryHandler\VenueGetBySlugQueryHandler->__invoke (line 19)
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\VenueController->profile (line 33)
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.22 ms
(2.31%)

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_.venue_id = ? AND e0_.date_event >= ? ORDER BY e0_.date_event ASC LIMIT 5

Parameters:

[
  2
  12880
  "2026-11-02 14:52:14"
]

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_.venue_id = ?
  AND e0_.date_event >= ?
ORDER BY
  e0_.date_event ASC
LIMIT
  5

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_.venue_id = 12880 AND e0_.date_event >= '2026-11-02 14:52:14' ORDER BY e0_.date_event ASC LIMIT 5;

#	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->findNextEventsByVenueAndDate (line 449)
7	App\Domain\Event\QueryHandler\EventGetNextEventsByVenueAndDateQueryHandler->{closure:App\Domain\Event\QueryHandler\EventGetNextEventsByVenueAndDateQueryHandler::__invoke():24} (line 28)
8	App\Domain\Event\QueryHandler\EventGetNextEventsByVenueAndDateQueryHandler->__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\VenueController->profile (line 49)
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.00 ms
(1.91%)

SELECT COUNT(e0_.id) AS sclr_0 FROM event e0_ WHERE e0_.venue_id = ? AND e0_.active = 1 AND e0_.deleted = 0 AND e0_.venue_pending = 0

Parameters:

[
  12880
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  event e0_
WHERE
  e0_.venue_id = ?
  AND e0_.active = 1
  AND e0_.deleted = 0
  AND e0_.venue_pending = 0

SELECT COUNT(e0_.id) AS sclr_0 FROM event e0_ WHERE e0_.venue_id = 12880 AND e0_.active = 1 AND e0_.deleted = 0 AND e0_.venue_pending = 0;

#	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\VenueRepository->hasPublicEvent (line 178)
8	App\Domain\Venue\QueryHandler\VenueHasPublicEventQueryHandler->__invoke (line 20)
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\VenueController->profile (line 41)
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.88 ms
(1.68%)

SELECT t0.id AS id_1, t0.logistics AS logistics_2, t0.rating_stage AS rating_stage_3, t0.rating_backstage AS rating_backstage_4, t0.rating_audio AS rating_audio_5, t0.rating_public AS rating_public_6, t0.rating_staff AS rating_staff_7, t0.rating_overall AS rating_overall_8, t0.comment AS comment_9, t0.date_add AS date_add_10, t0.date_upd AS date_upd_11, t0.artist_id AS artist_id_12, t0.event_id AS event_id_13, t0.venue_id AS venue_id_14 FROM venue_review t0 WHERE t0.venue_id = ? ORDER BY t0.date_add DESC

Parameters:

[
  12880
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.logistics AS logistics_2,
  t0.rating_stage AS rating_stage_3,
  t0.rating_backstage AS rating_backstage_4,
  t0.rating_audio AS rating_audio_5,
  t0.rating_public AS rating_public_6,
  t0.rating_staff AS rating_staff_7,
  t0.rating_overall AS rating_overall_8,
  t0.comment AS comment_9,
  t0.date_add AS date_add_10,
  t0.date_upd AS date_upd_11,
  t0.artist_id AS artist_id_12,
  t0.event_id AS event_id_13,
  t0.venue_id AS venue_id_14
FROM
  venue_review t0
WHERE
  t0.venue_id = ?
ORDER BY
  t0.date_add DESC

SELECT t0.id AS id_1, t0.logistics AS logistics_2, t0.rating_stage AS rating_stage_3, t0.rating_backstage AS rating_backstage_4, t0.rating_audio AS rating_audio_5, t0.rating_public AS rating_public_6, t0.rating_staff AS rating_staff_7, t0.rating_overall AS rating_overall_8, t0.comment AS comment_9, t0.date_add AS date_add_10, t0.date_upd AS date_upd_11, t0.artist_id AS artist_id_12, t0.event_id AS event_id_13, t0.venue_id AS venue_id_14 FROM venue_review t0 WHERE t0.venue_id = 12880 ORDER BY t0.date_add DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Domain\Venue\QueryHandler\VenueReviewGetByVenueQueryHandler->__invoke (line 18)
5	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 152)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 91)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 71)
8	Symfony\Component\Messenger\Middleware\ValidationMiddleware->handle (line 45)
9	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
10	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
11	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
12	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 37)
13	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 40)
14	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
15	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
16	App\Controller\Front\VenueController->profile (line 63)
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.79 ms
(1.51%)

SELECT t0.excerpt AS excerpt_1, t0.description AS description_2, t0.opening_time AS opening_time_3, t0.event_time AS event_time_4, t0.instrumentation AS instrumentation_5, t0.stage AS stage_6, t0.service AS service_7, t0.checksound_time AS checksound_time_8, t0.more_info AS more_info_9, t0.venue_id AS venue_id_10, t0.language_id AS language_id_11 FROM venue_lang t0 WHERE t0.venue_id = ?

Parameters:

[
  12880
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.excerpt AS excerpt_1,
  t0.description AS description_2,
  t0.opening_time AS opening_time_3,
  t0.event_time AS event_time_4,
  t0.instrumentation AS instrumentation_5,
  t0.stage AS stage_6,
  t0.service AS service_7,
  t0.checksound_time AS checksound_time_8,
  t0.more_info AS more_info_9,
  t0.venue_id AS venue_id_10,
  t0.language_id AS language_id_11
FROM
  venue_lang t0
WHERE
  t0.venue_id = ?

SELECT t0.excerpt AS excerpt_1, t0.description AS description_2, t0.opening_time AS opening_time_3, t0.event_time AS event_time_4, t0.instrumentation AS instrumentation_5, t0.stage AS stage_6, t0.service AS service_7, t0.checksound_time AS checksound_time_8, t0.more_info AS more_info_9, t0.venue_id AS venue_id_10, t0.language_id AS language_id_11 FROM venue_lang t0 WHERE t0.venue_id = 12880;

#	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	IteratorIterator->__construct (line 1994)
8	Twig\Extension\CoreExtension->filter (line 1994)
9	__TwigTemplate_5cf8c22636d0e738d62ecf2176c931aa::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\VenueController->profile (line 112)
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)

0.71 ms
(1.35%)

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:52:14"
  "2026-11-02 14:52:14"
]

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:52:14' AND c0_.ends_at >= '2026-11-02 14:52:14' 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_5cf8c22636d0e738d62ecf2176c931aa::block_header (line 204)
15	Twig\Template->yieldBlock (line 456)
16	__TwigTemplate_908fe77b0e1f5923906edfd8c2ecbfe6->doDisplay (line 171)
17	Twig\Template->yield (line 411)
18	__TwigTemplate_5cf8c22636d0e738d62ecf2176c931aa->doDisplay (line 67)
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\VenueController->profile (line 112)
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)

0.70 ms
(1.33%)

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:

[
  8107
]

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 = 8107;

#	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_5cf8c22636d0e738d62ecf2176c931aa::block_main (line 317)
6	Twig\Template->yieldBlock (line 456)
7	__TwigTemplate_908fe77b0e1f5923906edfd8c2ecbfe6->doDisplay (line 209)
8	Twig\Template->yield (line 411)
9	__TwigTemplate_5cf8c22636d0e738d62ecf2176c931aa->doDisplay (line 67)
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\VenueController->profile (line 112)
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

3 Hits

0 Misses

0 Puts

Number of cache hits

Region	Hits
append_only	3

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Lang	2
App\Entity\VenueLang	2
App\Entity\Venue	1
App\Entity\City	1
App\Entity\Country	1

Entities Mapping

Class	Mapping errors
App\Entity\Venue	No errors.
App\Entity\User	No errors.
App\Entity\City	No errors.
App\Entity\VenueLang	No errors.
App\Entity\Event	No errors.
App\Entity\Lang	No errors.
App\Entity\EventLang	No errors.
App\Entity\Artist	No errors.
App\Entity\Band	No errors.
App\Entity\VenueReview	No errors.
App\Entity\CallForArtists	No errors.
App\Entity\Country	No errors.

Symfony Profiler

GET https://app.dev.localero.it/venue/profile/basilica-di-sant-apollinare-in-classe

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