Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

6.32 ms Query time

0 Invalid entities

3 Managed entities

Queries

Group similar statements

#▲

Time

Info

4.04 ms

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:

[
  "notre-dame-la-grande-icone-de-poitiers"
  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 = 'notre-dame-la-grande-icone-de-poitiers' 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)

0.61 ms

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:

[
  312
]

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

#	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)

1.03 ms

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:

[
  312
]

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

#	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.64 ms

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:

[
  19
]

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

#	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\Event	1
App\Entity\EventScrapper	1
App\Entity\User	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.

Symfony Profiler

GET https://agenda-dev.toutpoitiers.com/agenda/notre-dame-la-grande-icone-de-poitiers

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping