Symfony Profiler

Query Metrics

69 Database Queries

6 Different statements

40.98 ms Query time

0 Invalid entities

162 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

15.33 ms
(37.41%)

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:

[
  12969
]

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

#	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_103c3916337283d1bfe2e987a9f0ca27::doDisplay (line 156)
6	Twig\Template->yield (line 411)
7	__TwigTemplate_470066acdd1bdf4f55ae6d0e24ad865f->block_main (line 353)
8	Twig\Template->yieldBlock (line 456)
9	__TwigTemplate_908fe77b0e1f5923906edfd8c2ecbfe6->doDisplay (line 209)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_470066acdd1bdf4f55ae6d0e24ad865f->doDisplay (line 76)
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\EventsController->index (line 102)
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)

9.93 ms
(24.23%)

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_103c3916337283d1bfe2e987a9f0ca27::doDisplay (line 159)
6	Twig\Template->yield (line 411)
7	__TwigTemplate_470066acdd1bdf4f55ae6d0e24ad865f->block_main (line 353)
8	Twig\Template->yieldBlock (line 456)
9	__TwigTemplate_908fe77b0e1f5923906edfd8c2ecbfe6->doDisplay (line 209)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_470066acdd1bdf4f55ae6d0e24ad865f->doDisplay (line 76)
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\EventsController->index (line 102)
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)

7.16 ms
(17.46%)

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:

[
  80
]

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

#	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->getIterator (line 315)
7	Twig\Extension\CoreExtension->slice (line 761)
8	Twig\Extension\CoreExtension::first (line 793)
9	__TwigTemplate_103c3916337283d1bfe2e987a9f0ca27::doDisplay (line 170)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_470066acdd1bdf4f55ae6d0e24ad865f->block_main (line 353)
12	Twig\Template->yieldBlock (line 456)
13	__TwigTemplate_908fe77b0e1f5923906edfd8c2ecbfe6->doDisplay (line 209)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_470066acdd1bdf4f55ae6d0e24ad865f->doDisplay (line 76)
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\EventsController->index (line 102)
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)

4.01 ms
(9.78%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.music_genre_id AS music_genre_id_3, t0.language_id AS language_id_4 FROM music_genre_lang t0 WHERE t0.music_genre_id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.music_genre_id AS music_genre_id_3,
  t0.language_id AS language_id_4
FROM
  music_genre_lang t0
WHERE
  t0.music_genre_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.music_genre_id AS music_genre_id_3, t0.language_id AS language_id_4 FROM music_genre_lang t0 WHERE t0.music_genre_id = 9;

#	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\MusicGenre->getMusicGenresByLangId (line 57)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_103c3916337283d1bfe2e987a9f0ca27::doDisplay (line 176)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_470066acdd1bdf4f55ae6d0e24ad865f->block_main (line 353)
12	Twig\Template->yieldBlock (line 456)
13	__TwigTemplate_908fe77b0e1f5923906edfd8c2ecbfe6->doDisplay (line 209)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_470066acdd1bdf4f55ae6d0e24ad865f->doDisplay (line 76)
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\EventsController->index (line 102)
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)

3.58 ms
(8.73%)

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, b2_.id AS id_26, b2_.active AS active_27, b2_.name AS name_28, b2_.slug AS slug_29, b2_.foundation_year AS foundation_year_30, b2_.website AS website_31, b2_.facebook AS facebook_32, b2_.instagram AS instagram_33, b2_.tiktok AS tiktok_34, b2_.soundcloud AS soundcloud_35, b2_.youtube AS youtube_36, b2_.discord AS discord_37, b2_.twitter AS twitter_38, b2_.spotify AS spotify_39, b2_.twitch AS twitch_40, b2_.bandsintown AS bandsintown_41, b2_.bandsintown_api_key AS bandsintown_api_key_42, b2_.cover_name AS cover_name_43, b2_.cover_thumb AS cover_thumb_44, b2_.date_add AS date_add_45, b2_.date_upd AS date_upd_46, b2_.total_points AS total_points_47, b2_.ranking_position AS ranking_position_48, e0_.venue_id AS venue_id_49, e0_.artist_id AS artist_id_50, e0_.band_id AS band_id_51, e0_.opener_id AS opener_id_52, e1_.event_id AS event_id_53, e1_.language_id AS language_id_54, b2_.city_id AS city_id_55, b2_.owner_id AS owner_id_56, b2_.current_tier_id AS current_tier_id_57 FROM event e0_ LEFT JOIN event_lang e1_ ON e0_.id = e1_.event_id AND (e1_.language_id = ?) LEFT JOIN band b2_ ON e0_.band_id = b2_.id WHERE e0_.date_event >= ? AND e0_.venue_pending = 0 ORDER BY e0_.date_event ASC

Parameters:

[
  1
  "2026-11-02 00:00:00"
]

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,
  b2_.id AS id_26,
  b2_.active AS active_27,
  b2_.name AS name_28,
  b2_.slug AS slug_29,
  b2_.foundation_year AS foundation_year_30,
  b2_.website AS website_31,
  b2_.facebook AS facebook_32,
  b2_.instagram AS instagram_33,
  b2_.tiktok AS tiktok_34,
  b2_.soundcloud AS soundcloud_35,
  b2_.youtube AS youtube_36,
  b2_.discord AS discord_37,
  b2_.twitter AS twitter_38,
  b2_.spotify AS spotify_39,
  b2_.twitch AS twitch_40,
  b2_.bandsintown AS bandsintown_41,
  b2_.bandsintown_api_key AS bandsintown_api_key_42,
  b2_.cover_name AS cover_name_43,
  b2_.cover_thumb AS cover_thumb_44,
  b2_.date_add AS date_add_45,
  b2_.date_upd AS date_upd_46,
  b2_.total_points AS total_points_47,
  b2_.ranking_position AS ranking_position_48,
  e0_.venue_id AS venue_id_49,
  e0_.artist_id AS artist_id_50,
  e0_.band_id AS band_id_51,
  e0_.opener_id AS opener_id_52,
  e1_.event_id AS event_id_53,
  e1_.language_id AS language_id_54,
  b2_.city_id AS city_id_55,
  b2_.owner_id AS owner_id_56,
  b2_.current_tier_id AS current_tier_id_57
FROM
  event e0_
  LEFT JOIN event_lang e1_ ON e0_.id = e1_.event_id
  AND (e1_.language_id = ?)
  LEFT JOIN band b2_ ON e0_.band_id = b2_.id
WHERE
  e0_.date_event >= ?
  AND e0_.venue_pending = 0
ORDER BY
  e0_.date_event ASC

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, b2_.id AS id_26, b2_.active AS active_27, b2_.name AS name_28, b2_.slug AS slug_29, b2_.foundation_year AS foundation_year_30, b2_.website AS website_31, b2_.facebook AS facebook_32, b2_.instagram AS instagram_33, b2_.tiktok AS tiktok_34, b2_.soundcloud AS soundcloud_35, b2_.youtube AS youtube_36, b2_.discord AS discord_37, b2_.twitter AS twitter_38, b2_.spotify AS spotify_39, b2_.twitch AS twitch_40, b2_.bandsintown AS bandsintown_41, b2_.bandsintown_api_key AS bandsintown_api_key_42, b2_.cover_name AS cover_name_43, b2_.cover_thumb AS cover_thumb_44, b2_.date_add AS date_add_45, b2_.date_upd AS date_upd_46, b2_.total_points AS total_points_47, b2_.ranking_position AS ranking_position_48, e0_.venue_id AS venue_id_49, e0_.artist_id AS artist_id_50, e0_.band_id AS band_id_51, e0_.opener_id AS opener_id_52, e1_.event_id AS event_id_53, e1_.language_id AS language_id_54, b2_.city_id AS city_id_55, b2_.owner_id AS owner_id_56, b2_.current_tier_id AS current_tier_id_57 FROM event e0_ LEFT JOIN event_lang e1_ ON e0_.id = e1_.event_id AND (e1_.language_id = 1) LEFT JOIN band b2_ ON e0_.band_id = b2_.id WHERE e0_.date_event >= '2026-11-02 00:00:00' AND e0_.venue_pending = 0 ORDER BY e0_.date_event ASC;

#	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->getEventsFromToDate (line 191)
7	App\Domain\Event\QueryHandler\EventGetAllFromToDateQueryHandler->__invoke (line 22)
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\EventsController->index (line 89)
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.98 ms
(2.39%)

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 12:24:51"
  "2026-11-02 12:24:51"
]

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 12:24:51' AND c0_.ends_at >= '2026-11-02 12:24:51' 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_470066acdd1bdf4f55ae6d0e24ad865f::block_header (line 240)
15	Twig\Template->yieldBlock (line 456)
16	__TwigTemplate_908fe77b0e1f5923906edfd8c2ecbfe6->doDisplay (line 171)
17	Twig\Template->yield (line 411)
18	__TwigTemplate_470066acdd1bdf4f55ae6d0e24ad865f->doDisplay (line 76)
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\EventsController->index (line 102)
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	27
App\Entity\EventLang	27
App\Entity\City	27
App\Entity\Venue	26
App\Entity\MusicGenre	14
App\Entity\Artist	13
App\Entity\Band	12
App\Entity\MusicGenreLang	10
App\Entity\Lang	2
App\Entity\Tier	2
App\Entity\Country	1
App\Entity\User	1

Entities Mapping

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

Symfony Profiler

GET https://app.dev.localero.it/eventi

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