Symfony Profiler

Query Metrics

25 Database Queries

4 Different statements

17.69 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.18 ms
(40.62%)

SELECT t0.id AS id_1, t0.remarque AS remarque_2, t0.heure_debut AS heure_debut_3, t0.heure_fin AS heure_fin_4, t0.soutenance_id AS soutenance_id_5 FROM calendrier t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.remarque AS remarque_2,
  t0.heure_debut AS heure_debut_3,
  t0.heure_fin AS heure_fin_4,
  t0.soutenance_id AS soutenance_id_5
FROM
  calendrier t0

SELECT t0.id AS id_1, t0.remarque AS remarque_2, t0.heure_debut AS heure_debut_3, t0.heure_fin AS heure_fin_4, t0.soutenance_id AS soutenance_id_5 FROM calendrier t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 17)
6	App\Controller\AccueilController->index (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

5.17 ms
(29.23%)

SELECT t0.id AS id_1, t0.date_soutenance AS date_soutenance_2, t0.president AS president_3, t0.examinateur AS examinateur_4, t0.resultat AS resultat_5, t0.annee_soutenance AS annee_soutenance_6, t0.these_id AS these_id_7, t0.salle_id AS salle_id_8 FROM soutenance t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_soutenance AS date_soutenance_2,
  t0.president AS president_3,
  t0.examinateur AS examinateur_4,
  t0.resultat AS resultat_5,
  t0.annee_soutenance AS annee_soutenance_6,
  t0.these_id AS these_id_7,
  t0.salle_id AS salle_id_8
FROM
  soutenance t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_soutenance AS date_soutenance_2, t0.president AS president_3, t0.examinateur AS examinateur_4, t0.resultat AS resultat_5, t0.annee_soutenance AS annee_soutenance_6, t0.these_id AS these_id_7, t0.salle_id AS salle_id_8 FROM soutenance t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 59)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
6	Proxies\__CG__\App\Entity\Soutenance->__get (line 70)
7	App\Entity\Soutenance->getDateSoutenance (line 1629)
8	Twig\Extension\CoreExtension::getAttribute (line 112)
9	__TwigTemplate_03816e396d0f2a9f34baf2a881691812->block_body (line 430)
10	Twig\Template->yieldBlock (line 233)
11	__TwigTemplate_55624124af4c7b7c97243269ff05dfb4->doDisplay (line 360)
12	Twig\Template->yield (line 50)
13	__TwigTemplate_03816e396d0f2a9f34baf2a881691812->doDisplay (line 360)
14	Twig\Template->yield (line 335)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 307)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 19)
21	App\Controller\AccueilController->index (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

3.06 ms
(17.32%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.date_naissance AS date_naissance_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.date_inscription AS date_inscription_7, t0.adresse AS adresse_8, t0.filiere_id AS filiere_id_9 FROM etudiant t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.date_naissance AS date_naissance_4,
  t0.email AS email_5,
  t0.telephone AS telephone_6,
  t0.date_inscription AS date_inscription_7,
  t0.adresse AS adresse_8,
  t0.filiere_id AS filiere_id_9
FROM
  etudiant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.date_naissance AS date_naissance_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.date_inscription AS date_inscription_7, t0.adresse AS adresse_8, t0.filiere_id AS filiere_id_9 FROM etudiant t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 59)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
6	Proxies\__CG__\App\Entity\Etudiant->__get (line 68)
7	App\Entity\Etudiant->getNom (line 1629)
8	Twig\Extension\CoreExtension::getAttribute (line 151)
9	__TwigTemplate_03816e396d0f2a9f34baf2a881691812->block_body (line 430)
10	Twig\Template->yieldBlock (line 233)
11	__TwigTemplate_55624124af4c7b7c97243269ff05dfb4->doDisplay (line 360)
12	Twig\Template->yield (line 50)
13	__TwigTemplate_03816e396d0f2a9f34baf2a881691812->doDisplay (line 360)
14	Twig\Template->yield (line 335)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 307)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 19)
21	App\Controller\AccueilController->index (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

2.27 ms
(12.83%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.statut AS statut_5, t0.description AS description_6, t0.etudiant_id AS etudiant_id_7, t0.superviseur_id AS superviseur_id_8, t0.etudiant2_id AS etudiant2_id_9 FROM these t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.date_debut AS date_debut_3,
  t0.date_fin AS date_fin_4,
  t0.statut AS statut_5,
  t0.description AS description_6,
  t0.etudiant_id AS etudiant_id_7,
  t0.superviseur_id AS superviseur_id_8,
  t0.etudiant2_id AS etudiant2_id_9
FROM
  these t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.statut AS statut_5, t0.description AS description_6, t0.etudiant_id AS etudiant_id_7, t0.superviseur_id AS superviseur_id_8, t0.etudiant2_id AS etudiant2_id_9 FROM these t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 59)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
6	Proxies\__CG__\App\Entity\These->__get (line 49)
7	App\Entity\These->getTitre (line 1629)
8	Twig\Extension\CoreExtension::getAttribute (line 120)
9	__TwigTemplate_03816e396d0f2a9f34baf2a881691812->block_body (line 430)
10	Twig\Template->yieldBlock (line 233)
11	__TwigTemplate_55624124af4c7b7c97243269ff05dfb4->doDisplay (line 360)
12	Twig\Template->yield (line 50)
13	__TwigTemplate_03816e396d0f2a9f34baf2a881691812->doDisplay (line 360)
14	Twig\Template->yield (line 335)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 307)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 19)
21	App\Controller\AccueilController->index (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	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\Calendrier	No errors.
App\Entity\Soutenance	The association App\Entity\Soutenance#these refers to the inverse side field App\Entity\These#soutenances which does not exist.
App\Entity\These	No errors.
App\Entity\Salle	No errors.
App\Entity\Etudiant	No errors.
App\Entity\Superviseur	No errors.
App\Entity\Filiere	No errors.

Symfony Profiler

GET https://soutenance.manosphone.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping