Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

10.17 ms Query time

0 Invalid entities

19 Managed entities

Queries

Group similar statements

#▲

Time

Info

7.69 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, e1_.id AS id_20, e1_.name AS name_21, e1_.slug AS slug_22, e0_.scrapper_event_id AS scrapper_event_id_23, e0_.created_by_id AS created_by_id_24, e0_.festival_id AS festival_id_25 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 WHERE e0_.date_debut <= ? AND ((e0_.date_fin IS NULL AND e0_.date_debut >= ? AND e0_.date_debut < ?) OR (e0_.date_fin IS NOT NULL AND e0_.date_debut <= ? AND e0_.date_fin >= ?)) AND e0_.visible = true AND ((e0_.exclude_from_agenda = false OR e0_.exclude_from_agenda IS NULL)) AND (e0_.horaires_du_lieu = false OR EXISTS (SELECT 1 AS sclr_26 FROM event_place_link e3_ INNER JOIN place p4_ ON e3_.place_id = p4_.id INNER JOIN horaires h5_ ON p4_.id = h5_.place_id WHERE e3_.event_id = e0_.id AND e3_.role = ? AND h5_.jour = ? AND (h5_.ferme = false OR h5_.ferme IS NULL))) ORDER BY e0_.date_debut ASC

Parameters:

[
  "2027-03-21 00:00:00"
  "2027-03-20 00:00:00"
  "2027-03-21 00:00:00"
  "2027-03-21 00:00:00"
  "2027-03-20 00:00:00"
  "host"
  7
]

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,
  e1_.id AS id_20,
  e1_.name AS name_21,
  e1_.slug AS slug_22,
  e0_.scrapper_event_id AS scrapper_event_id_23,
  e0_.created_by_id AS created_by_id_24,
  e0_.festival_id AS festival_id_25
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
WHERE
  e0_.date_debut <= ?
  AND (
    (
      e0_.date_fin IS NULL
      AND e0_.date_debut >= ?
      AND e0_.date_debut < ?
    )
    OR (
      e0_.date_fin IS NOT NULL
      AND e0_.date_debut <= ?
      AND e0_.date_fin >= ?
    )
  )
  AND e0_.visible = true
  AND (
    (
      e0_.exclude_from_agenda = false
      OR e0_.exclude_from_agenda IS NULL
    )
  )
  AND (
    e0_.horaires_du_lieu = false
    OR EXISTS (
      SELECT
        1 AS sclr_26
      FROM
        event_place_link e3_
        INNER JOIN place p4_ ON e3_.place_id = p4_.id
        INNER JOIN horaires h5_ ON p4_.id = h5_.place_id
      WHERE
        e3_.event_id = e0_.id
        AND e3_.role = ?
        AND h5_.jour = ?
        AND (
          h5_.ferme = false
          OR h5_.ferme IS NULL
        )
    )
  )
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, e1_.id AS id_20, e1_.name AS name_21, e1_.slug AS slug_22, e0_.scrapper_event_id AS scrapper_event_id_23, e0_.created_by_id AS created_by_id_24, e0_.festival_id AS festival_id_25 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 WHERE e0_.date_debut <= '2027-03-21 00:00:00' AND ((e0_.date_fin IS NULL AND e0_.date_debut >= '2027-03-20 00:00:00' AND e0_.date_debut < '2027-03-21 00:00:00') OR (e0_.date_fin IS NOT NULL AND e0_.date_debut <= '2027-03-21 00:00:00' AND e0_.date_fin >= '2027-03-20 00:00:00')) AND e0_.visible = true AND ((e0_.exclude_from_agenda = false OR e0_.exclude_from_agenda IS NULL)) AND (e0_.horaires_du_lieu = false OR EXISTS (SELECT 1 AS sclr_26 FROM event_place_link e3_ INNER JOIN place p4_ ON e3_.place_id = p4_.id INNER JOIN horaires h5_ ON p4_.id = h5_.place_id WHERE e3_.event_id = e0_.id AND e3_.role = 'host' AND h5_.jour = 7 AND (h5_.ferme = false OR h5_.ferme IS NULL))) 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->findForToday (line 80)
7	App\Controller\AgendaController->agenda (line 168)
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.57 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:

[
  1162
]

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

#	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->agenda (line 170)
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.67 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM event_category t0 ORDER BY t0.name ASC

Parameters:

[]

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
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM event_category t0 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Controller\AgendaController->agenda (line 172)
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)

1.23 ms

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:

[
  12
]

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

#	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_0d44114e911da168c8afa0bc36ead504->block_body (line 282)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_341c1175f1586d8ee66b40d92461ada4->doDisplay (line 148)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_0d44114e911da168c8afa0bc36ead504->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\AgendaController->agenda (line 174)
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\EventCategory	14
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\EventPlace	No errors.
App\Entity\Place	No errors.
App\Entity\Horaires	No errors.
App\Entity\EventScrapper	No errors.
App\Entity\User	No errors.
App\Entity\Festival	No errors.
App\Entity\CategoryMapper	No errors.

Symfony Profiler

GET https://agenda-dev.toutpoitiers.com/agenda?date=2027-03-20

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping