Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

8.25 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.97 ms
(60.27%)

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_ LEFT JOIN event_event_category e2_ ON e0_.id = e2_.event_id LEFT JOIN event_category e1_ ON e1_.id = e2_.event_category_id LEFT JOIN event_scrapper e3_ ON e0_.scrapper_event_id = e3_.id WHERE e0_.slug = ? AND e0_.visible = ?

Parameters:

[
  "show-de-fin-d-annee-de-chorinitia"
  1
]

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_
  LEFT JOIN event_event_category e2_ ON e0_.id = e2_.event_id
  LEFT JOIN event_category e1_ ON e1_.id = e2_.event_category_id
  LEFT JOIN event_scrapper e3_ ON e0_.scrapper_event_id = e3_.id
WHERE
  e0_.slug = ?
  AND e0_.visible = ?

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_ LEFT JOIN event_event_category e2_ ON e0_.id = e2_.event_id LEFT JOIN event_category e1_ ON e1_.id = e2_.event_category_id LEFT JOIN event_scrapper e3_ ON e0_.scrapper_event_id = e3_.id WHERE e0_.slug = 'show-de-fin-d-annee-de-chorinitia' AND e0_.visible = 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\EventRepository->getEventDetail (line 162)
7	App\Controller\AgendaController->displayAgenda (line 203)
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)

1.21 ms
(14.72%)

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:

[
  5
]

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

#	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_37fc400bd1982b92371e20b832564841::block_body (line 269)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_341c1175f1586d8ee66b40d92461ada4->doDisplay (line 148)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_37fc400bd1982b92371e20b832564841->doDisplay (line 54)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
18	App\Controller\AgendaController->displayAgenda (line 211)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

0.82 ms
(9.99%)

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:

[
  1482
]

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

#	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\AgendaController->displayAgenda (line 208)
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)

0.73 ms
(8.89%)

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:

[
  1482
]

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

#	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_37fc400bd1982b92371e20b832564841->block_body (line 318)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_341c1175f1586d8ee66b40d92461ada4->doDisplay (line 148)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_37fc400bd1982b92371e20b832564841->doDisplay (line 54)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
24	App\Controller\AgendaController->displayAgenda (line 211)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 191)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

0.50 ms
(6.12%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.url_website AS url_website_3, t0.url_to_scan AS url_to_scan_4, t0.last_scan AS last_scan_5, t0.code AS code_6, t0.is_with_scrap_child AS is_with_scrap_child_7, t0.default_location_id AS default_location_id_8, t0.default_organizer_id AS default_organizer_id_9, t0.default_category_id AS default_category_id_10 FROM event_scrapper t0 WHERE t0.id = ?

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url_website AS url_website_3,
  t0.url_to_scan AS url_to_scan_4,
  t0.last_scan AS last_scan_5,
  t0.code AS code_6,
  t0.is_with_scrap_child AS is_with_scrap_child_7,
  t0.default_location_id AS default_location_id_8,
  t0.default_organizer_id AS default_organizer_id_9,
  t0.default_category_id AS default_category_id_10
FROM
  event_scrapper t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url_website AS url_website_3, t0.url_to_scan AS url_to_scan_4, t0.last_scan AS last_scan_5, t0.code AS code_6, t0.is_with_scrap_child AS is_with_scrap_child_7, t0.default_location_id AS default_location_id_8, t0.default_organizer_id AS default_organizer_id_9, t0.default_category_id AS default_category_id_10 FROM event_scrapper t0 WHERE t0.id = 8;

#	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_37fc400bd1982b92371e20b832564841::block_body (line 348)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_341c1175f1586d8ee66b40d92461ada4->doDisplay (line 148)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_37fc400bd1982b92371e20b832564841->doDisplay (line 54)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
18	App\Controller\AgendaController->displayAgenda (line 211)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	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\EventCategory	2
App\Entity\Event	1
App\Entity\EventScrapper	1
App\Entity\User	1
App\Entity\EventPlace	1
App\Entity\Place	1

Entities Mapping

Class	Mapping errors
App\Entity\Event	No errors.
App\Entity\EventCategory	No errors.
App\Entity\EventScrapper	No errors.
App\Entity\User	No errors.
App\Entity\Festival	No errors.
App\Entity\EventPlace	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/agenda/show-de-fin-d-annee-de-chorinitia

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping