Symfony Profiler

Query Metrics

17 Database Queries

5 Different statements

13.30 ms Query time

0 Invalid entities

18 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.48 ms
(33.67%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM event_category t0 INNER JOIN event_event_category ON t0.id = event_event_category.event_category_id WHERE event_event_category.event_id = ?

Parameters:

[
  2
]

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
FROM
  event_category t0
  INNER JOIN event_event_category ON t0.id = event_event_category.event_category_id
WHERE
  event_event_category.event_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM event_category t0 INNER JOIN event_event_category ON t0.id = event_event_category.event_category_id WHERE event_event_category.event_id = 2;

#	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_81cd0f589bb6450405b4fc0c14c8993f::doDisplay (line 48)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_3a82df208d2985056d684606eb05b62d->doDisplay (line 239)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
16	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
17	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
18	__TwigTemplate_4e9f29e097a109e00d44b2e564876e94->block_body (line 228)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_341c1175f1586d8ee66b40d92461ada4->doDisplay (line 148)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_4e9f29e097a109e00d44b2e564876e94->doDisplay (line 54)
23	Twig\Template->yield (line 402)
24	Twig\Template->display (line 358)
25	Twig\Template->render (line 373)
26	Twig\TemplateWrapper->render (line 51)
27	Twig\Environment->render (line 333)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
31	App\Controller\FestivalController->displayFestival (line 35)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 191)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 32)
37	require_once (line 5)

3.17 ms
(23.79%)

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.creation_date AS creation_date_3, e0_.url AS url_4, e0_.slug AS slug_5, e0_.last_update AS last_update_6, e0_.visible AS visible_7, e0_.date_debut AS date_debut_8, e0_.date_fin AS date_fin_9, e0_.uuid_tmp AS uuid_tmp_10, e0_.image AS image_11, e0_.location_fallback AS location_fallback_12, e0_.organizers_fallback AS organizers_fallback_13, e0_.image_name AS image_name_14, e0_.image_size AS image_size_15, e0_.updated_at AS updated_at_16, e0_.price AS price_17, e0_.exclude_from_agenda AS exclude_from_agenda_18, e0_.horaires_du_lieu AS horaires_du_lieu_19, e0_.scrapper_event_id AS scrapper_event_id_20, e0_.created_by_id AS created_by_id_21, e0_.festival_id AS festival_id_22 FROM event e0_ WHERE e0_.festival_id = ? AND e0_.visible = ? ORDER BY e0_.date_debut ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.description AS description_2,
  e0_.creation_date AS creation_date_3,
  e0_.url AS url_4,
  e0_.slug AS slug_5,
  e0_.last_update AS last_update_6,
  e0_.visible AS visible_7,
  e0_.date_debut AS date_debut_8,
  e0_.date_fin AS date_fin_9,
  e0_.uuid_tmp AS uuid_tmp_10,
  e0_.image AS image_11,
  e0_.location_fallback AS location_fallback_12,
  e0_.organizers_fallback AS organizers_fallback_13,
  e0_.image_name AS image_name_14,
  e0_.image_size AS image_size_15,
  e0_.updated_at AS updated_at_16,
  e0_.price AS price_17,
  e0_.exclude_from_agenda AS exclude_from_agenda_18,
  e0_.horaires_du_lieu AS horaires_du_lieu_19,
  e0_.scrapper_event_id AS scrapper_event_id_20,
  e0_.created_by_id AS created_by_id_21,
  e0_.festival_id AS festival_id_22
FROM
  event e0_
WHERE
  e0_.festival_id = ?
  AND e0_.visible = ?
ORDER BY
  e0_.date_debut ASC

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.creation_date AS creation_date_3, e0_.url AS url_4, e0_.slug AS slug_5, e0_.last_update AS last_update_6, e0_.visible AS visible_7, e0_.date_debut AS date_debut_8, e0_.date_fin AS date_fin_9, e0_.uuid_tmp AS uuid_tmp_10, e0_.image AS image_11, e0_.location_fallback AS location_fallback_12, e0_.organizers_fallback AS organizers_fallback_13, e0_.image_name AS image_name_14, e0_.image_size AS image_size_15, e0_.updated_at AS updated_at_16, e0_.price AS price_17, e0_.exclude_from_agenda AS exclude_from_agenda_18, e0_.horaires_du_lieu AS horaires_du_lieu_19, e0_.scrapper_event_id AS scrapper_event_id_20, e0_.created_by_id AS created_by_id_21, e0_.festival_id AS festival_id_22 FROM event e0_ WHERE e0_.festival_id = 1 AND e0_.visible = 1 ORDER BY e0_.date_debut 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->getEventFromFestival (line 184)
7	App\Controller\FestivalController->displayFestival (line 30)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

2.44 ms
(18.36%)

SELECT t0.id AS id_1, t0.role AS role_2, t0.event_id AS event_id_3, t0.place_id AS place_id_4 FROM event_place_link t0 WHERE t0.event_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.event_id AS event_id_3,
  t0.place_id AS place_id_4
FROM
  event_place_link t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.event_id AS event_id_3, t0.place_id AS place_id_4 FROM event_place_link t0 WHERE t0.event_id = 2;

#	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\Services\PlacesForEvent->eventPlaces (line 13)
8	App\Controller\FestivalController->displayFestival (line 32)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

2.29 ms
(17.19%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.description AS description_5, t0.image AS image_6, t0.slug AS slug_7, t0.updated_at AS updated_at_8, t0.image_name AS image_name_9, t0.image_size AS image_size_10, t0.ville AS ville_11, t0.url AS url_12 FROM festival t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "jazzellerault"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_debut AS date_debut_3,
  t0.date_fin AS date_fin_4,
  t0.description AS description_5,
  t0.image AS image_6,
  t0.slug AS slug_7,
  t0.updated_at AS updated_at_8,
  t0.image_name AS image_name_9,
  t0.image_size AS image_size_10,
  t0.ville AS ville_11,
  t0.url AS url_12
FROM
  festival t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.description AS description_5, t0.image AS image_6, t0.slug AS slug_7, t0.updated_at AS updated_at_8, t0.image_name AS image_name_9, t0.image_size AS image_size_10, t0.ville AS ville_11, t0.url AS url_12 FROM festival t0 WHERE t0.slug = 'jazzellerault' 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\ServiceEntityRepository->findOneBy (line 86)
4	App\Controller\FestivalController->displayFestival (line 28)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.93 ms
(6.99%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.adresse AS adresse_3, t0.slug AS slug_4, t0.ville AS ville_5, t0.codepostal AS codepostal_6, t0.description AS description_7, t0.telephone AS telephone_8, t0.email AS email_9, t0.url AS url_10, t0.proprietaire_id AS proprietaire_id_11 FROM place t0 WHERE t0.id = ?

Parameters:

[
  20
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.adresse AS adresse_3,
  t0.slug AS slug_4,
  t0.ville AS ville_5,
  t0.codepostal AS codepostal_6,
  t0.description AS description_7,
  t0.telephone AS telephone_8,
  t0.email AS email_9,
  t0.url AS url_10,
  t0.proprietaire_id AS proprietaire_id_11
FROM
  place t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.adresse AS adresse_3, t0.slug AS slug_4, t0.ville AS ville_5, t0.codepostal AS codepostal_6, t0.description AS description_7, t0.telephone AS telephone_8, t0.email AS email_9, t0.url AS url_10, t0.proprietaire_id AS proprietaire_id_11 FROM place t0 WHERE t0.id = 20;

#	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 1795)
5	__TwigTemplate_3a82df208d2985056d684606eb05b62d::doDisplay (line 183)
6	Twig\Template->yield (line 402)
7	Twig\Template->display (line 358)
8	Twig\Template->render (line 373)
9	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
10	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
11	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
12	__TwigTemplate_4e9f29e097a109e00d44b2e564876e94->block_body (line 228)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_341c1175f1586d8ee66b40d92461ada4->doDisplay (line 148)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_4e9f29e097a109e00d44b2e564876e94->doDisplay (line 54)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
25	App\Controller\FestivalController->displayFestival (line 35)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 191)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Event	7
App\Entity\EventPlace	6
App\Entity\Festival	1
App\Entity\EventScrapper	1
App\Entity\User	1
App\Entity\Place	1
App\Entity\EventCategory	1

Entities Mapping

Class	Mapping errors
App\Entity\Festival	No errors.
App\Entity\Event	No errors.
App\Entity\EventScrapper	No errors.
App\Entity\User	No errors.
App\Entity\EventPlace	No errors.
App\Entity\EventCategory	No errors.
App\Entity\Place	No errors.
App\Entity\Horaires	No errors.
App\Entity\CategoryMapper	No errors.

Symfony Profiler

GET https://agenda-dev.toutpoitiers.com/festival/jazzellerault

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping