Symfony Profiler

Query Metrics

22 Database Queries

6 Different statements

34.63 ms Query time

0 Invalid entities

55 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

14.46 ms
(41.77%)

SELECT t0.id AS id_1, t0.date_event AS date_event_2, t0.location AS location_3, t0.address AS address_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.poster_name AS poster_name_7, t0.poster_thumb_name AS poster_thumb_name_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.bandsintown_event_id AS bandsintown_event_id_11, t0.venue_pending AS venue_pending_12, t0.excluded_from_ranking AS excluded_from_ranking_13, t0.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_14, t0.price AS price_15, t0.access AS access_16, t0.date_add AS date_add_17, t0.date_upd AS date_upd_18, t0.followers_notified_at AS followers_notified_at_19, t0.reminder_day_before_sent_at AS reminder_day_before_sent_at_20, t0.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_21, t0.venue_id AS venue_id_22, t0.artist_id AS artist_id_23, t0.band_id AS band_id_24, t0.opener_id AS opener_id_25 FROM event t0 WHERE t0.venue_id = ?

Parameters:

[
  12975
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_event AS date_event_2,
  t0.location AS location_3,
  t0.address AS address_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.poster_name AS poster_name_7,
  t0.poster_thumb_name AS poster_thumb_name_8,
  t0.active AS active_9,
  t0.deleted AS deleted_10,
  t0.bandsintown_event_id AS bandsintown_event_id_11,
  t0.venue_pending AS venue_pending_12,
  t0.excluded_from_ranking AS excluded_from_ranking_13,
  t0.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_14,
  t0.price AS price_15,
  t0.access AS access_16,
  t0.date_add AS date_add_17,
  t0.date_upd AS date_upd_18,
  t0.followers_notified_at AS followers_notified_at_19,
  t0.reminder_day_before_sent_at AS reminder_day_before_sent_at_20,
  t0.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_21,
  t0.venue_id AS venue_id_22,
  t0.artist_id AS artist_id_23,
  t0.band_id AS band_id_24,
  t0.opener_id AS opener_id_25
FROM
  event t0
WHERE
  t0.venue_id = ?

SELECT t0.id AS id_1, t0.date_event AS date_event_2, t0.location AS location_3, t0.address AS address_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.poster_name AS poster_name_7, t0.poster_thumb_name AS poster_thumb_name_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.bandsintown_event_id AS bandsintown_event_id_11, t0.venue_pending AS venue_pending_12, t0.excluded_from_ranking AS excluded_from_ranking_13, t0.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_14, t0.price AS price_15, t0.access AS access_16, t0.date_add AS date_add_17, t0.date_upd AS date_upd_18, t0.followers_notified_at AS followers_notified_at_19, t0.reminder_day_before_sent_at AS reminder_day_before_sent_at_20, t0.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_21, t0.venue_id AS venue_id_22, t0.artist_id AS artist_id_23, t0.band_id AS band_id_24, t0.opener_id AS opener_id_25 FROM event t0 WHERE t0.venue_id = 12975;

#	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	__TwigTemplate_44fbaf9603376302087372e3524bfdef->doDisplay (line 195)
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\Extension\CoreExtension->include (line 1522)
13	__TwigTemplate_e489232ce8fc802776d2e5f698b94f64::block_main (line 393)
14	Twig\Template->yieldBlock (line 456)
15	__TwigTemplate_908fe77b0e1f5923906edfd8c2ecbfe6->doDisplay (line 209)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_e489232ce8fc802776d2e5f698b94f64->doDisplay (line 62)
18	Twig\Template->yield (line 411)
19	Twig\Template->display (line 366)
20	Twig\Template->render (line 381)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
26	App\Controller\Front\VenuesController->index (line 107)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 208)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

8.03 ms
(23.19%)

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:

[
  3342
]

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

#	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_44fbaf9603376302087372e3524bfdef::doDisplay (line 249)
6	Twig\Template->yield (line 411)
7	Twig\Template->display (line 366)
8	Twig\Template->render (line 381)
9	Twig\TemplateWrapper->render (line 51)
10	Twig\Extension\CoreExtension->include (line 1522)
11	__TwigTemplate_e489232ce8fc802776d2e5f698b94f64::block_main (line 393)
12	Twig\Template->yieldBlock (line 456)
13	__TwigTemplate_908fe77b0e1f5923906edfd8c2ecbfe6->doDisplay (line 209)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_e489232ce8fc802776d2e5f698b94f64->doDisplay (line 62)
16	Twig\Template->yield (line 411)
17	Twig\Template->display (line 366)
18	Twig\Template->render (line 381)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
24	App\Controller\Front\VenuesController->index (line 107)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 208)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

5.83 ms
(16.83%)

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, v1_.excerpt AS excerpt_18, v1_.description AS description_19, v1_.opening_time AS opening_time_20, v1_.event_time AS event_time_21, v1_.instrumentation AS instrumentation_22, v1_.stage AS stage_23, v1_.service AS service_24, v1_.checksound_time AS checksound_time_25, v1_.more_info AS more_info_26, v0_.user_id AS user_id_27, v0_.city_id AS city_id_28, v1_.venue_id AS venue_id_29, v1_.language_id AS language_id_30 FROM venue v0_ LEFT JOIN venue_lang v1_ ON v0_.id = v1_.venue_id AND (v0_.id = v1_.venue_id AND v1_.language_id = ?) WHERE v0_.type IN (?) AND (EXISTS (SELECT 1 AS sclr_31 FROM event e2_ WHERE e2_.venue_id = v0_.id AND e2_.active = 1 AND e2_.deleted = 0 AND e2_.venue_pending = 0)) ORDER BY v0_.name ASC LIMIT 9 OFFSET 135

Parameters:

[
  2
  "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,
  v1_.excerpt AS excerpt_18,
  v1_.description AS description_19,
  v1_.opening_time AS opening_time_20,
  v1_.event_time AS event_time_21,
  v1_.instrumentation AS instrumentation_22,
  v1_.stage AS stage_23,
  v1_.service AS service_24,
  v1_.checksound_time AS checksound_time_25,
  v1_.more_info AS more_info_26,
  v0_.user_id AS user_id_27,
  v0_.city_id AS city_id_28,
  v1_.venue_id AS venue_id_29,
  v1_.language_id AS language_id_30
FROM
  venue v0_
  LEFT JOIN venue_lang v1_ ON v0_.id = v1_.venue_id
  AND (
    v0_.id = v1_.venue_id
    AND v1_.language_id = ?
  )
WHERE
  v0_.type IN (?)
  AND (
    EXISTS (
      SELECT
        1 AS sclr_31
      FROM
        event e2_
      WHERE
        e2_.venue_id = v0_.id
        AND e2_.active = 1
        AND e2_.deleted = 0
        AND e2_.venue_pending = 0
    )
  )
ORDER BY
  v0_.name ASC
LIMIT
  9
OFFSET
  135

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, v1_.excerpt AS excerpt_18, v1_.description AS description_19, v1_.opening_time AS opening_time_20, v1_.event_time AS event_time_21, v1_.instrumentation AS instrumentation_22, v1_.stage AS stage_23, v1_.service AS service_24, v1_.checksound_time AS checksound_time_25, v1_.more_info AS more_info_26, v0_.user_id AS user_id_27, v0_.city_id AS city_id_28, v1_.venue_id AS venue_id_29, v1_.language_id AS language_id_30 FROM venue v0_ LEFT JOIN venue_lang v1_ ON v0_.id = v1_.venue_id AND (v0_.id = v1_.venue_id AND v1_.language_id = 2) WHERE v0_.type IN ('PHYSICAL_VENUE') AND (EXISTS (SELECT 1 AS sclr_31 FROM event e2_ WHERE e2_.venue_id = v0_.id AND e2_.active = 1 AND e2_.deleted = 0 AND e2_.venue_pending = 0)) ORDER BY v0_.name ASC LIMIT 9 OFFSET 135;

#	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\VenueRepository->findByFirstLetter (line 79)
7	App\Domain\Venue\QueryHandler\VenueGetAllByFiltersQueryHandler->__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\VenuesController->index (line 63)
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)

3.59 ms
(10.37%)

SELECT COUNT(v0_.id) AS sclr_0 FROM venue v0_ LEFT JOIN venue_lang v1_ ON v0_.id = v1_.venue_id AND (v0_.id = v1_.venue_id AND v1_.language_id = ?) WHERE v0_.type IN (?) AND (EXISTS (SELECT 1 AS sclr_1 FROM event e2_ WHERE e2_.venue_id = v0_.id AND e2_.active = 1 AND e2_.deleted = 0 AND e2_.venue_pending = 0))

Parameters:

[
  2
  "PHYSICAL_VENUE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  venue v0_
  LEFT JOIN venue_lang v1_ ON v0_.id = v1_.venue_id
  AND (
    v0_.id = v1_.venue_id
    AND v1_.language_id = ?
  )
WHERE
  v0_.type IN (?)
  AND (
    EXISTS (
      SELECT
        1 AS sclr_1
      FROM
        event e2_
      WHERE
        e2_.venue_id = v0_.id
        AND e2_.active = 1
        AND e2_.deleted = 0
        AND e2_.venue_pending = 0
    )
  )

SELECT COUNT(v0_.id) AS sclr_0 FROM venue v0_ LEFT JOIN venue_lang v1_ ON v0_.id = v1_.venue_id AND (v0_.id = v1_.venue_id AND v1_.language_id = 2) WHERE v0_.type IN ('PHYSICAL_VENUE') AND (EXISTS (SELECT 1 AS sclr_1 FROM event e2_ WHERE e2_.venue_id = v0_.id AND e2_.active = 1 AND e2_.deleted = 0 AND e2_.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->countByFirstLetter (line 113)
8	App\Domain\Venue\QueryHandler\VenueCountAllByFirstLetterQueryHandler->__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\VenuesController->index (line 54)
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.05 ms
(5.92%)

SELECT DISTINCT UPPER(SUBSTRING(v0_.name FROM 1 FOR 1)) AS sclr_0 FROM venue v0_ WHERE v0_.type IN (?) AND (EXISTS (SELECT 1 AS sclr_1 FROM event e1_ WHERE e1_.venue_id = v0_.id AND e1_.active = 1 AND e1_.deleted = 0 AND e1_.venue_pending = 0))

Parameters:

[
  "PHYSICAL_VENUE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT UPPER(
    SUBSTRING(
      v0_.name
      FROM
        1 FOR 1
    )
  ) AS sclr_0
FROM
  venue v0_
WHERE
  v0_.type IN (?)
  AND (
    EXISTS (
      SELECT
        1 AS sclr_1
      FROM
        event e1_
      WHERE
        e1_.venue_id = v0_.id
        AND e1_.active = 1
        AND e1_.deleted = 0
        AND e1_.venue_pending = 0
    )
  )

SELECT DISTINCT UPPER(SUBSTRING(v0_.name FROM 1 FOR 1)) AS sclr_0 FROM venue v0_ WHERE v0_.type IN ('PHYSICAL_VENUE') AND (EXISTS (SELECT 1 AS sclr_1 FROM event e1_ WHERE e1_.venue_id = v0_.id AND e1_.active = 1 AND e1_.deleted = 0 AND e1_.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->getResult (line 688)
6	App\Repository\VenueRepository->getVenuesFirstsLetter (line 32)
7	App\Domain\Venue\QueryHandler\VenueGetAllFirstsLettersQueryHandler->__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\VenuesController->index (line 49)
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.67 ms
(1.93%)

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

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:38:19' AND c0_.ends_at >= '2026-11-02 14:38:19' 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_e489232ce8fc802776d2e5f698b94f64::block_header (line 193)
15	Twig\Template->yieldBlock (line 456)
16	__TwigTemplate_908fe77b0e1f5923906edfd8c2ecbfe6->doDisplay (line 171)
17	Twig\Template->yield (line 411)
18	__TwigTemplate_e489232ce8fc802776d2e5f698b94f64->doDisplay (line 62)
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\VenuesController->index (line 107)
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\Event	10
App\Entity\Venue	9
App\Entity\City	9
App\Entity\VenueLang	9
App\Entity\Artist	7
App\Entity\Band	7
App\Entity\Country	2
App\Entity\Lang	1
App\Entity\User	1

Entities Mapping

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

Symfony Profiler

GET https://app.dev.localero.it/venues/all/16

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping