Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

8.10 ms Query time

12 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.01 ms
(24.76%)

SELECT t0.id AS id_1, t0.date_preinscription AS date_preinscription_2, t0.etat AS etat_3, t0.code AS code_4, t0.etat_deliberation AS etat_deliberation_5, t0.date_validation AS date_validation_6, t0.commentaire AS commentaire_7, t0.montant AS montant_8, t0.niveau_id AS niveau_id_9, t0.etudiant_id AS etudiant_id_10, t0.utilisateur_id AS utilisateur_id_11, t12.id AS id_13, t12.montant AS montant_14, t12.date_paiement AS date_paiement_15, t12.utilisateur_id AS utilisateur_id_16, t12.preinscription_id AS preinscription_id_17, t12.mode_paiement_id AS mode_paiement_id_18, t19.id AS id_20, t19.preinscription_id AS preinscription_id_21, t19.deliberation_id AS deliberation_id_22, t0.caissiere_id AS caissiere_id_23 FROM compta_preinscription t0 LEFT JOIN compta_info_preinscription t12 ON t12.preinscription_id = t0.id LEFT JOIN dir_deliberation_preinscription t19 ON t19.preinscription_id = t0.id WHERE t0.id = ?

Parameters:

[
  "2255"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_preinscription AS date_preinscription_2,
  t0.etat AS etat_3,
  t0.code AS code_4,
  t0.etat_deliberation AS etat_deliberation_5,
  t0.date_validation AS date_validation_6,
  t0.commentaire AS commentaire_7,
  t0.montant AS montant_8,
  t0.niveau_id AS niveau_id_9,
  t0.etudiant_id AS etudiant_id_10,
  t0.utilisateur_id AS utilisateur_id_11,
  t12.id AS id_13,
  t12.montant AS montant_14,
  t12.date_paiement AS date_paiement_15,
  t12.utilisateur_id AS utilisateur_id_16,
  t12.preinscription_id AS preinscription_id_17,
  t12.mode_paiement_id AS mode_paiement_id_18,
  t19.id AS id_20,
  t19.preinscription_id AS preinscription_id_21,
  t19.deliberation_id AS deliberation_id_22,
  t0.caissiere_id AS caissiere_id_23
FROM
  compta_preinscription t0
  LEFT JOIN compta_info_preinscription t12 ON t12.preinscription_id = t0.id
  LEFT JOIN dir_deliberation_preinscription t19 ON t19.preinscription_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_preinscription AS date_preinscription_2, t0.etat AS etat_3, t0.code AS code_4, t0.etat_deliberation AS etat_deliberation_5, t0.date_validation AS date_validation_6, t0.commentaire AS commentaire_7, t0.montant AS montant_8, t0.niveau_id AS niveau_id_9, t0.etudiant_id AS etudiant_id_10, t0.utilisateur_id AS utilisateur_id_11, t12.id AS id_13, t12.montant AS montant_14, t12.date_paiement AS date_paiement_15, t12.utilisateur_id AS utilisateur_id_16, t12.preinscription_id AS preinscription_id_17, t12.mode_paiement_id AS mode_paiement_id_18, t19.id AS id_20, t19.preinscription_id AS preinscription_id_21, t19.deliberation_id AS deliberation_id_22, t0.caissiere_id AS caissiere_id_23 FROM compta_preinscription t0 LEFT JOIN compta_info_preinscription t12 ON t12.preinscription_id = t0.id LEFT JOIN dir_deliberation_preinscription t19 ON t19.preinscription_id = t0.id WHERE t0.id = '2255';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 142)
6	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->find (line 91)
7	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->apply (line 84)
8	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->applyConverter (line 48)
9	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->apply (line 72)
10	Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener->onKernelController (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

1.22 ms
(15.07%)

SELECT t0.id AS id_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.date_naissance AS date_naissance_6, t0.lieu_naissance AS lieu_naissance_7, t0.email AS email_8, t0.contact AS contact_9, t0.genre_id AS genre_id_10, t0.civilite_id AS civilite_id_11, t0.fonction_id AS fonction_id_12, t0.discr, t2.ville AS ville_13, t2.adresse AS adresse_14, t2.boite AS boite_15, t2.fax AS fax_16, t2.employeur AS employeur_17, t2.bailleur AS bailleur_18, t2.parent AS parent_19, t2.autre AS autre_20, t2.radio AS radio_21, t2.presse AS presse_22, t2.affiche AS affiche_23, t2.ministere AS ministere_24, t2.mailing AS mailing_25, t2.site_web AS site_web_26, t2.vous_meme AS vous_meme_27, t2.professeur AS professeur_28, t2.ami_collegue AS ami_collegue_29, t2.autre_existence AS autre_existence_30, t2.etat AS etat_31, t2.numero_whatsapp AS numero_whatsapp_32, t2.statut_travail AS statut_travail_33, t2.travail AS travail_34, t2.statut_etudiant AS statut_etudiant_35, t2.filiere_id AS filiere_id_36, t2.pays_id AS pays_id_37, t2.nationalite_id AS nationalite_id_38 FROM user_personne t0 LEFT JOIN user_employe t1 ON t0.id = t1.id LEFT JOIN user_etudiant t2 ON t0.id = t2.id WHERE t0.id = ?

Parameters:

[
  1592
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_3,
  t0.nom AS nom_4,
  t0.prenom AS prenom_5,
  t0.date_naissance AS date_naissance_6,
  t0.lieu_naissance AS lieu_naissance_7,
  t0.email AS email_8,
  t0.contact AS contact_9,
  t0.genre_id AS genre_id_10,
  t0.civilite_id AS civilite_id_11,
  t0.fonction_id AS fonction_id_12,
  t0.discr,
  t2.ville AS ville_13,
  t2.adresse AS adresse_14,
  t2.boite AS boite_15,
  t2.fax AS fax_16,
  t2.employeur AS employeur_17,
  t2.bailleur AS bailleur_18,
  t2.parent AS parent_19,
  t2.autre AS autre_20,
  t2.radio AS radio_21,
  t2.presse AS presse_22,
  t2.affiche AS affiche_23,
  t2.ministere AS ministere_24,
  t2.mailing AS mailing_25,
  t2.site_web AS site_web_26,
  t2.vous_meme AS vous_meme_27,
  t2.professeur AS professeur_28,
  t2.ami_collegue AS ami_collegue_29,
  t2.autre_existence AS autre_existence_30,
  t2.etat AS etat_31,
  t2.numero_whatsapp AS numero_whatsapp_32,
  t2.statut_travail AS statut_travail_33,
  t2.travail AS travail_34,
  t2.statut_etudiant AS statut_etudiant_35,
  t2.filiere_id AS filiere_id_36,
  t2.pays_id AS pays_id_37,
  t2.nationalite_id AS nationalite_id_38
FROM
  user_personne t0
  LEFT JOIN user_employe t1 ON t0.id = t1.id
  LEFT JOIN user_etudiant t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.date_naissance AS date_naissance_6, t0.lieu_naissance AS lieu_naissance_7, t0.email AS email_8, t0.contact AS contact_9, t0.genre_id AS genre_id_10, t0.civilite_id AS civilite_id_11, t0.fonction_id AS fonction_id_12, t0.discr, t2.ville AS ville_13, t2.adresse AS adresse_14, t2.boite AS boite_15, t2.fax AS fax_16, t2.employeur AS employeur_17, t2.bailleur AS bailleur_18, t2.parent AS parent_19, t2.autre AS autre_20, t2.radio AS radio_21, t2.presse AS presse_22, t2.affiche AS affiche_23, t2.ministere AS ministere_24, t2.mailing AS mailing_25, t2.site_web AS site_web_26, t2.vous_meme AS vous_meme_27, t2.professeur AS professeur_28, t2.ami_collegue AS ami_collegue_29, t2.autre_existence AS autre_existence_30, t2.etat AS etat_31, t2.numero_whatsapp AS numero_whatsapp_32, t2.statut_travail AS statut_travail_33, t2.travail AS travail_34, t2.statut_etudiant AS statut_etudiant_35, t2.filiere_id AS filiere_id_36, t2.pays_id AS pays_id_37, t2.nationalite_id AS nationalite_id_38 FROM user_personne t0 LEFT JOIN user_employe t1 ON t0.id = t1.id LEFT JOIN user_etudiant t2 ON t0.id = t2.id WHERE t0.id = 1592;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 820)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 3099)
4	Doctrine\ORM\UnitOfWork->createEntity (line 173)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 65)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 272)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 784)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
10	Doctrine\ORM\EntityManager->find (line 196)
11	Doctrine\ORM\EntityRepository->find (line 92)
12	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
13	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
14	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
15	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
16	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
17	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
18	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 45)
19	Stof\DoctrineExtensionsBundle\EventListener\BlameListener->onKernelRequest (line 116)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

1.22 ms
(15.02%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.actif AS actif_5, t0.verrou AS verrou_6, t0.numero AS numero_7 FROM annee_scolaire t0 WHERE t0.id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.date_debut AS date_debut_3,
  t0.date_fin AS date_fin_4,
  t0.actif AS actif_5,
  t0.verrou AS verrou_6,
  t0.numero AS numero_7
FROM
  annee_scolaire t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.actif AS actif_5, t0.verrou AS verrou_6, t0.numero AS numero_7 FROM annee_scolaire t0 WHERE t0.id = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\AnneeScolaire::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
7	Proxies\__CG__\App\Entity\AnneeScolaire->__get (line 75)
8	App\Entity\AnneeScolaire->getLibelle (line 1754)
9	Twig\Extension\CoreExtension::getAttribute (line 204)
10	__TwigTemplate_041013ae08fa26aba7fd422d6259c3d8->doDisplay (line 393)
11	Twig\Template->yield (line 349)
12	Twig\Template->display (line 364)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 306)
15	Twig\Environment->render (line 243)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 110)
17	App\Controller\Comptabilite\NiveauEtudiantController->renderPdf (line 710)
18	App\Controller\Comptabilite\NiveauEtudiantController->imprimerComptabilite (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

1.00 ms
(12.30%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.montant_preinscription AS montant_preinscription_5, t0.fichier_id AS fichier_id_6, t7.id AS id_8, t7.size AS size_9, t7.path AS path_10, t7.alt AS alt_11, t7.date_creation AS date_creation_12, t7.url AS url_13 FROM param_filiere t0 LEFT JOIN param_fichier t7 ON t0.fichier_id = t7.id WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4,
  t0.montant_preinscription AS montant_preinscription_5,
  t0.fichier_id AS fichier_id_6,
  t7.id AS id_8,
  t7.size AS size_9,
  t7.path AS path_10,
  t7.alt AS alt_11,
  t7.date_creation AS date_creation_12,
  t7.url AS url_13
FROM
  param_filiere t0
  LEFT JOIN param_fichier t7 ON t0.fichier_id = t7.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.montant_preinscription AS montant_preinscription_5, t0.fichier_id AS fichier_id_6, t7.id AS id_8, t7.size AS size_9, t7.path AS path_10, t7.alt AS alt_11, t7.date_creation AS date_creation_12, t7.url AS url_13 FROM param_filiere t0 LEFT JOIN param_fichier t7 ON t0.fichier_id = t7.id WHERE t0.id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Filiere::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
7	Proxies\__CG__\App\Entity\Filiere->__get (line 134)
8	App\Entity\Filiere->getMontantPreinscription (line 1754)
9	Twig\Extension\CoreExtension::getAttribute (line 233)
10	__TwigTemplate_041013ae08fa26aba7fd422d6259c3d8->doDisplay (line 393)
11	Twig\Template->yield (line 349)
12	Twig\Template->display (line 364)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 306)
15	Twig\Environment->render (line 243)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 110)
17	App\Controller\Comptabilite\NiveauEtudiantController->renderPdf (line 710)
18	App\Controller\Comptabilite\NiveauEtudiantController->imprimerComptabilite (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.96 ms
(11.82%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.reset_token AS reset_token_4, t0.password AS password_5, t0.email AS email_6, t0.personne_id AS personne_id_7 FROM user_utilisateur t0 WHERE t0.id = ?

Parameters:

[
  1482
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.reset_token AS reset_token_4,
  t0.password AS password_5,
  t0.email AS email_6,
  t0.personne_id AS personne_id_7
FROM
  user_utilisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.reset_token AS reset_token_4, t0.password AS password_5, t0.email AS email_6, t0.personne_id AS personne_id_7 FROM user_utilisateur t0 WHERE t0.id = 1482;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 45)
13	Stof\DoctrineExtensionsBundle\EventListener\BlameListener->onKernelRequest (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.95 ms
(11.75%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.passage_examen AS passage_examen_4, t0.filiere_id AS filiere_id_5, t0.responsable_id AS responsable_id_6, t0.promotion_id AS promotion_id_7, t0.annee_scolaire_id AS annee_scolaire_id_8 FROM param_niveau t0 WHERE t0.id = ?

Parameters:

[
  113
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.passage_examen AS passage_examen_4,
  t0.filiere_id AS filiere_id_5,
  t0.responsable_id AS responsable_id_6,
  t0.promotion_id AS promotion_id_7,
  t0.annee_scolaire_id AS annee_scolaire_id_8
FROM
  param_niveau t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.passage_examen AS passage_examen_4, t0.filiere_id AS filiere_id_5, t0.responsable_id AS responsable_id_6, t0.promotion_id AS promotion_id_7, t0.annee_scolaire_id AS annee_scolaire_id_8 FROM param_niveau t0 WHERE t0.id = 113;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Niveau::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
7	Proxies\__CG__\App\Entity\Niveau->__get (line 330)
8	App\Entity\Niveau->getAnneeScolaire (line 1754)
9	Twig\Extension\CoreExtension::getAttribute (line 204)
10	__TwigTemplate_041013ae08fa26aba7fd422d6259c3d8->doDisplay (line 393)
11	Twig\Template->yield (line 349)
12	Twig\Template->display (line 364)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 306)
15	Twig\Environment->render (line 243)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 110)
17	App\Controller\Comptabilite\NiveauEtudiantController->renderPdf (line 710)
18	App\Controller\Comptabilite\NiveauEtudiantController->imprimerComptabilite (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.75 ms
(9.29%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.reset_token AS reset_token_4, t0.password AS password_5, t0.email AS email_6, t0.personne_id AS personne_id_7 FROM user_utilisateur t0 WHERE t0.personne_id = ?

Parameters:

[
  1592
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.reset_token AS reset_token_4,
  t0.password AS password_5,
  t0.email AS email_6,
  t0.personne_id AS personne_id_7
FROM
  user_utilisateur t0
WHERE
  t0.personne_id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.reset_token AS reset_token_4, t0.password AS password_5, t0.email AS email_6, t0.personne_id AS personne_id_7 FROM user_utilisateur t0 WHERE t0.personne_id = 1592;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 873)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 3027)
4	Doctrine\ORM\UnitOfWork->createEntity (line 173)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 65)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 272)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 784)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 820)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 3099)
10	Doctrine\ORM\UnitOfWork->createEntity (line 173)
11	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 65)
12	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 272)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 784)
14	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
16	Doctrine\ORM\EntityManager->find (line 196)
17	Doctrine\ORM\EntityRepository->find (line 92)
18	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
19	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
20	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
21	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
22	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
23	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
24	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 45)
25	Stof\DoctrineExtensionsBundle\EventListener\BlameListener->onKernelRequest (line 116)
26	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
27	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
28	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
29	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	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\Utilisateur	The field App\Entity\Utilisateur#infoInscriptions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\InfoInscription#utilisateur does not contain the required 'inversedBy="infoInscriptions"' attribute.
App\Entity\Personne	No errors.
App\Entity\Employe	No errors.
App\Entity\Etudiant	The association App\Entity\Etudiant#filiere refers to the inverse side field App\Entity\Filiere#etudiants which does not exist. The field App\Entity\Etudiant#inscriptions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Inscription#etudiant does not contain the required 'inversedBy="inscriptions"' attribute.
App\Entity\Genre	No errors.
App\Entity\Civilite	No errors.
App\Entity\Fonction	No errors.
App\Entity\Filiere	No errors.
App\Entity\Pays	No errors.
App\Entity\Nationalite	No errors.
App\Entity\NiveauEtudiant	The association App\Entity\NiveauEtudiant#niveau refers to the inverse side field App\Entity\Niveau#niveauEtudiants which does not exist.
App\Entity\Preinscription	No errors.
App\Entity\Inscription	No errors.
App\Entity\Document	No errors.
App\Entity\CursusUniversitaire	No errors.
App\Entity\CursusProfessionnel	No errors.
App\Entity\Stage	No errors.
App\Entity\InfoEtudiant	No errors.
App\Entity\Note	The association App\Entity\Note#valeurNoteExamens refers to the owning side field App\Entity\ValeurNoteExamen#note which is not defined as association, but as field. The association App\Entity\Note#valeurNoteExamens refers to the owning side field App\Entity\ValeurNoteExamen#note which does not exist.
App\Entity\MoyenneMatiere	The association App\Entity\MoyenneMatiere#ue refers to the inverse side field App\Entity\UniteEnseignement#moyenneMatieres which does not exist.
App\Entity\BlocEcheancier	No errors.
App\Entity\EncartBac	No errors.
App\Entity\LigneRattrapage	No errors.
App\Entity\DecisionResume	No errors.
App\Entity\DecisionExamen	No errors.
App\Entity\UtilisateurGroupe	No errors.
App\Entity\InfoInscription	No errors.
App\Entity\Decision	No errors.
App\Entity\Niveau	The field App\Entity\Niveau#inscriptions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Inscription#niveau does not contain the required 'inversedBy="inscriptions"' attribute.
App\Entity\InfoPreinscription	No errors.
App\Entity\NaturePaiement	No errors.
App\Entity\DeliberationPreinscription	No errors.
App\Entity\Deliberation	No errors.
App\Entity\Promotion	No errors.
App\Entity\AnneeScolaire	No errors.
App\Entity\Frais	No errors.
App\Entity\InfoNiveau	No errors.
App\Entity\UniteEnseignement	No errors.
App\Entity\Classe	No errors.
App\Entity\Examen	No errors.
App\Entity\Session	The association App\Entity\Session#moyenneMatieres refers to the owning side field App\Entity\MoyenneMatiere#session which does not exist.
App\Entity\EcheancierNiveau	No errors.
App\Entity\NiveauxCaisse	No errors.
App\Entity\Semestre	No errors.
App\Entity\Cours	No errors.
App\Entity\Controle	The association App\Entity\Controle#ue refers to the inverse side field App\Entity\UniteEnseignement#controles which does not exist.
App\Entity\Fichier	No errors.
App\Entity\FraisInscription	No errors.
App\Entity\Echeancier	No errors.
App\Entity\InscriptionUeValidation	No errors.
App\Entity\ValeurNote	No errors.
App\Entity\ValeurNoteExamen	No errors.
App\Entity\Matiere	The mappings App\Entity\Matiere#controleExamens and App\Entity\ControleExamen#matiere are inconsistent with each other.
App\Entity\EcheancierProvisoire	No errors.
App\Entity\FraisBloc	No errors.
App\Entity\Mention	No errors.
App\Entity\Rattrapage	No errors.
App\Entity\ValeurNoteRattrapage	No errors.
App\Entity\Groupe	No errors.
App\Entity\TypeFrais	No errors.
App\Entity\Caisse	No errors.
App\Entity\LigneDeliberation	No errors.
App\Entity\MatiereUe	No errors.
App\Entity\CoursParent	No errors.
App\Entity\ControleExamen	The association App\Entity\ControleExamen#ue refers to the inverse side field App\Entity\UniteEnseignement#controleExamens which does not exist.
App\Entity\MatiereExamen	No errors.
App\Entity\GroupeType	No errors.
App\Entity\TypeControle	No errors.
App\Entity\Versement	No errors.
App\Entity\CoefValeurNote	No errors.
App\Entity\NoteExamen	The association App\Entity\NoteExamen#etudiant refers to the inverse side field App\Entity\Etudiant#noteExamens which does not exist.
App\Entity\TypeMatiere	No errors.
App\Entity\GroupeRattrapage	No errors.
App\Entity\GroupeTypeExamen	No errors.
App\Entity\TypeEvaluation	No errors.
App\Entity\Test	No errors.
App\Entity\Lamine	No errors.
App\Entity\Validation	No errors.
App\Entity\TypeDocument	No errors.
App\Entity\UniteFormation	No errors.
App\Entity\EvaluationValeurNote	The association App\Entity\EvaluationValeurNote#note refers to the inverse side field App\Entity\Note#evaluationValeurNotes which does not exist. The association App\Entity\EvaluationValeurNote#utilisateur refers to the inverse side field App\Entity\Utilisateur#evaluationValeurNotes which does not exist.
App\Entity\Paiement	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://ufrseg.logicielspourtous.com/comptabilite/niveau/etudiant/2255/imprime/comptabilite

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping