Symfony Profiler

Query Metrics

114 Database Queries

8 Different statements

22.64 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.27 ms
(32.13%)

SELECT SUM(CASE WHEN s0_.statut_id = 1 THEN 1 ELSE 0 END) AS sclr_0, SUM(CASE WHEN s0_.statut_id = 2 THEN 1 ELSE 0 END) AS sclr_1 FROM sessions s1_ LEFT JOIN session_stagiaire s0_ ON s1_.id = s0_.session_id WHERE s1_.id = ? AND s1_.etat = ? ORDER BY s1_.id DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUM(
    CASE WHEN s0_.statut_id = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN s0_.statut_id = 2 THEN
      1
    ELSE
      0
    END
  ) AS sclr_1
FROM
  sessions s1_
  LEFT JOIN session_stagiaire s0_ ON s1_.id = s0_.session_id
WHERE
  s1_.id = ?
  AND s1_.etat = ?
ORDER BY
  s1_.id DESC

SELECT SUM(CASE WHEN s0_.statut_id = 1 THEN 1 ELSE 0 END) AS sclr_0, SUM(CASE WHEN s0_.statut_id = 2 THEN 1 ELSE 0 END) AS sclr_1 FROM sessions s1_ LEFT JOIN session_stagiaire s0_ ON s1_.id = s0_.session_id WHERE s1_.id = 1601 AND s1_.etat = 1 ORDER BY s1_.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 61)
7	App\Repository\Sessions\SessionsRepository->findNbStagiaireByAllStatut (line 44)
8	App\Controller\SiteWeb\SiteWebController->apiPlanning (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

7.26 ms
(32.06%)

SELECT t0.id AS id_1, t0.date_start AS date_start_2, t0.heure_debut AS heure_debut_3, t0.heure_debut_fin AS heure_debut_fin_4, t0.heure_fin AS heure_fin_5, t0.heure_fin_fin AS heure_fin_fin_6, t0.heure_am AS heure_am_7, t0.heure_pm AS heure_pm_8, t0.dernier_jour AS dernier_jour_9, t0.premier_jour AS premier_jour_10, t0.session_id AS session_id_11 FROM session_dates t0 WHERE t0.session_id = ? ORDER BY t0.date_start ASC

Parameters:

[
  1601
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_start AS date_start_2,
  t0.heure_debut AS heure_debut_3,
  t0.heure_debut_fin AS heure_debut_fin_4,
  t0.heure_fin AS heure_fin_5,
  t0.heure_fin_fin AS heure_fin_fin_6,
  t0.heure_am AS heure_am_7,
  t0.heure_pm AS heure_pm_8,
  t0.dernier_jour AS dernier_jour_9,
  t0.premier_jour AS premier_jour_10,
  t0.session_id AS session_id_11
FROM
  session_dates t0
WHERE
  t0.session_id = ?
ORDER BY
  t0.date_start ASC

SELECT t0.id AS id_1, t0.date_start AS date_start_2, t0.heure_debut AS heure_debut_3, t0.heure_debut_fin AS heure_debut_fin_4, t0.heure_fin AS heure_fin_5, t0.heure_fin_fin AS heure_fin_fin_6, t0.heure_am AS heure_am_7, t0.heure_pm AS heure_pm_8, t0.dernier_jour AS dernier_jour_9, t0.premier_jour AS premier_jour_10, t0.session_id AS session_id_11 FROM session_dates t0 WHERE t0.session_id = 1601 ORDER BY t0.date_start ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 167)
7	Doctrine\Common\Collections\AbstractLazyCollection->first (line 518)
8	Doctrine\ORM\PersistentCollection->first (line 51)
9	App\Controller\SiteWeb\SiteWebController->apiPlanning (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

3.03 ms
(13.38%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.updated_at AS updated_at_3, t0.filename AS filename_4, t0.url AS url_5, t0.type AS type_6, t0.theme_id AS theme_id_7 FROM media_categorie_programme t0 INNER JOIN formations_media_categorie_programme ON t0.id = formations_media_categorie_programme.media_categorie_programme_id WHERE formations_media_categorie_programme.formations_id = ?

Parameters:

[
  2092
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.updated_at AS updated_at_3,
  t0.filename AS filename_4,
  t0.url AS url_5,
  t0.type AS type_6,
  t0.theme_id AS theme_id_7
FROM
  media_categorie_programme t0
  INNER JOIN formations_media_categorie_programme ON t0.id = formations_media_categorie_programme.media_categorie_programme_id
WHERE
  formations_media_categorie_programme.formations_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.updated_at AS updated_at_3, t0.filename AS filename_4, t0.url AS url_5, t0.type AS type_6, t0.theme_id AS theme_id_7 FROM media_categorie_programme t0 INNER JOIN formations_media_categorie_programme ON t0.id = formations_media_categorie_programme.media_categorie_programme_id WHERE formations_media_categorie_programme.formations_id = 2092;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 69)
8	App\Controller\SiteWeb\SiteWebController->apiPlanning (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

2.70 ms
(11.91%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.capacite AS capacite_4, t0.nombre_jour AS nombre_jour_5, t0.nombre_heure AS nombre_heure_6, t0.statut AS statut_7, t0.domaine_id AS domaine_id_8 FROM formations t0 WHERE t0.id = ?

Parameters:

[
  2092
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.capacite AS capacite_4,
  t0.nombre_jour AS nombre_jour_5,
  t0.nombre_heure AS nombre_heure_6,
  t0.statut AS statut_7,
  t0.domaine_id AS domaine_id_8
FROM
  formations t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.capacite AS capacite_4, t0.nombre_jour AS nombre_jour_5, t0.nombre_heure AS nombre_heure_6, t0.statut AS statut_7, t0.domaine_id AS domaine_id_8 FROM formations t0 WHERE t0.id = 2092;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Formations\Formations::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Formations\Formations->__get (line 123)
8	App\Entity\Formations\Formations->getCapacite (line 50)
9	App\Controller\SiteWeb\SiteWebController->apiPlanning (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.29 ms
(5.69%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.background AS background_4, t0.color_event AS color_event_5, t0.background_event AS background_event_6, t0.type_session AS type_session_7, t0.filename AS filename_8 FROM bdd_themes t0 WHERE t0.id = ?

Parameters:

[
  25
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.background AS background_4,
  t0.color_event AS color_event_5,
  t0.background_event AS background_event_6,
  t0.type_session AS type_session_7,
  t0.filename AS filename_8
FROM
  bdd_themes t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.background AS background_4, t0.color_event AS color_event_5, t0.background_event AS background_event_6, t0.type_session AS type_session_7, t0.filename AS filename_8 FROM bdd_themes t0 WHERE t0.id = 25;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Bdd\BddThemes::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Bdd\BddThemes->__get (line 59)
8	App\Entity\Bdd\BddThemes->getName (line 75)
9	App\Controller\SiteWeb\SiteWebController->apiPlanning (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.59 ms
(2.59%)

SELECT s0_.id AS id_0, s0_.numero AS numero_1, s0_.code AS code_2, s0_.etat AS etat_3, s0_.formation_id AS formation_id_4, s0_.type_id AS type_id_5, s0_.adresse_centre_id AS adresse_centre_id_6 FROM sessions s0_ LEFT JOIN formations f1_ ON s0_.formation_id = f1_.id LEFT JOIN bdd_themes b2_ ON f1_.domaine_id = b2_.id LEFT JOIN session_dates s3_ ON s0_.id = s3_.session_id WHERE s3_.premier_jour = ? AND s3_.date_start > ? AND f1_.domaine_id <> ? AND f1_.domaine_id <> ? AND f1_.domaine_id <> ? AND f1_.domaine_id <> ? AND s0_.type_id = ? AND s0_.adresse_centre_id = ? AND s0_.etat = ? GROUP BY s0_.id ORDER BY s3_.date_start ASC

Parameters:

[
  1
  "2025-08-13 00:00:00"
  3
  5
  6
  7
  1
  1
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.numero AS numero_1,
  s0_.code AS code_2,
  s0_.etat AS etat_3,
  s0_.formation_id AS formation_id_4,
  s0_.type_id AS type_id_5,
  s0_.adresse_centre_id AS adresse_centre_id_6
FROM
  sessions s0_
  LEFT JOIN formations f1_ ON s0_.formation_id = f1_.id
  LEFT JOIN bdd_themes b2_ ON f1_.domaine_id = b2_.id
  LEFT JOIN session_dates s3_ ON s0_.id = s3_.session_id
WHERE
  s3_.premier_jour = ?
  AND s3_.date_start > ?
  AND f1_.domaine_id <> ?
  AND f1_.domaine_id <> ?
  AND f1_.domaine_id <> ?
  AND f1_.domaine_id <> ?
  AND s0_.type_id = ?
  AND s0_.adresse_centre_id = ?
  AND s0_.etat = ?
GROUP BY
  s0_.id
ORDER BY
  s3_.date_start ASC

SELECT s0_.id AS id_0, s0_.numero AS numero_1, s0_.code AS code_2, s0_.etat AS etat_3, s0_.formation_id AS formation_id_4, s0_.type_id AS type_id_5, s0_.adresse_centre_id AS adresse_centre_id_6 FROM sessions s0_ LEFT JOIN formations f1_ ON s0_.formation_id = f1_.id LEFT JOIN bdd_themes b2_ ON f1_.domaine_id = b2_.id LEFT JOIN session_dates s3_ ON s0_.id = s3_.session_id WHERE s3_.premier_jour = 1 AND s3_.date_start > '2025-08-13 00:00:00' AND f1_.domaine_id <> 3 AND f1_.domaine_id <> 5 AND f1_.domaine_id <> 6 AND f1_.domaine_id <> 7 AND s0_.type_id = 1 AND s0_.adresse_centre_id = 1 AND s0_.etat = 1 GROUP BY s0_.id ORDER BY s3_.date_start ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 46)
7	App\Repository\Sessions\SessionsRepository->findForCalendrier (line 41)
8	App\Controller\SiteWeb\SiteWebController->apiPlanning (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.28 ms
(1.22%)

SELECT t0.id AS id_1, t0.token AS token_2 FROM bdd_api t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.token AS token_2
FROM
  bdd_api t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.token AS token_2 FROM bdd_api t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 33)
7	App\Controller\SiteWeb\SiteWebController->apiPlanning (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.23 ms
(1.02%)

SELECT t0.id AS id_1, t0.lien AS lien_2, t0.name AS name_3, t0.nom AS nom_4, t0.numero AS numero_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.logo AS logo_8, t0.telephone AS telephone_9, t0.mail AS mail_10, t0.site_web AS site_web_11, t0.footer_text_x AS footer_text_x_12, t0.footer_text_second_x AS footer_text_second_x_13, t0.footer_text_y AS footer_text_y_14, t0.footer_text_second_y AS footer_text_second_y_15, t0.footer_text AS footer_text_16, t0.footer_text_second AS footer_text_second_17, t0.mail_envoi AS mail_envoi_18, t0.statut_actif AS statut_actif_19 FROM bdd_centres t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.lien AS lien_2,
  t0.name AS name_3,
  t0.nom AS nom_4,
  t0.numero AS numero_5,
  t0.code_postal AS code_postal_6,
  t0.ville AS ville_7,
  t0.logo AS logo_8,
  t0.telephone AS telephone_9,
  t0.mail AS mail_10,
  t0.site_web AS site_web_11,
  t0.footer_text_x AS footer_text_x_12,
  t0.footer_text_second_x AS footer_text_second_x_13,
  t0.footer_text_y AS footer_text_y_14,
  t0.footer_text_second_y AS footer_text_second_y_15,
  t0.footer_text AS footer_text_16,
  t0.footer_text_second AS footer_text_second_17,
  t0.mail_envoi AS mail_envoi_18,
  t0.statut_actif AS statut_actif_19
FROM
  bdd_centres t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.lien AS lien_2, t0.name AS name_3, t0.nom AS nom_4, t0.numero AS numero_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.logo AS logo_8, t0.telephone AS telephone_9, t0.mail AS mail_10, t0.site_web AS site_web_11, t0.footer_text_x AS footer_text_x_12, t0.footer_text_second_x AS footer_text_second_x_13, t0.footer_text_y AS footer_text_y_14, t0.footer_text_second_y AS footer_text_second_y_15, t0.footer_text AS footer_text_16, t0.footer_text_second AS footer_text_second_17, t0.mail_envoi AS mail_envoi_18, t0.statut_actif AS statut_actif_19 FROM bdd_centres t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 39)
7	App\Controller\SiteWeb\SiteWebController->apiPlanning (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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.

Entities Mapping

Class	Mapping errors
App\Entity\Bdd\Api\BddApi	No errors.
App\Entity\Bdd\BddCentres	No errors.
App\Entity\Sessions\Sessions	The field App\Entity\Sessions\Sessions#stagiaires is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sessions\SessionStagiaire#session does not contain the required 'inversedBy="stagiaires"' attribute.
App\Entity\Formations\Formations	No errors.
App\Entity\Bdd\BddThemes	No errors.
App\Entity\Sessions\SessionDates	No errors.
App\Entity\Bdd\BddSessionType	No errors.
App\Entity\Sessions\SessionClientOrder	No errors.
App\Entity\Sessions\SessionStagiaire	No errors.
App\Entity\Media\MediaCategorieProgramme	No errors.

Symfony Profiler

GET https://api-pvg.click-app.fr/old-api/WH5kEDfKFeY226YPl0RdWheevVSvT1Xd9Jf2KJkbsKHH5RL9BKClGF06VhI2x7Te/site/planning

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping