Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

31.86 ms Query time

0 Invalid entities

5 Managed entities

Queries

Group similar statements

#▲

Time

Info

7.54 ms

SELECT t0.id AS id_1, t0.montant AS montant_2, t0.reference AS reference_3, t0.order_number AS order_number_4, t0.etat AS etat_5, t0.devise AS devise_6, t0.telephone AS telephone_7, t0.envois AS envois_8, t0.date AS date_9, t0.statut AS statut_10, t0.membre_id AS membre_id_11 FROM transaction t0 WHERE t0.id = ?

Parameters:

[
  "1455"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.montant AS montant_2,
  t0.reference AS reference_3,
  t0.order_number AS order_number_4,
  t0.etat AS etat_5,
  t0.devise AS devise_6,
  t0.telephone AS telephone_7,
  t0.envois AS envois_8,
  t0.date AS date_9,
  t0.statut AS statut_10,
  t0.membre_id AS membre_id_11
FROM
  transaction t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.montant AS montant_2, t0.reference AS reference_3, t0.order_number AS order_number_4, t0.etat AS etat_5, t0.devise AS devise_6, t0.telephone AS telephone_7, t0.envois AS envois_8, t0.date AS date_9, t0.statut AS statut_10, t0.membre_id AS membre_id_11 FROM transaction t0 WHERE t0.id = '1455';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 119)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

15.67 ms

SELECT t0.id AS id_1, t0.adhesion AS adhesion_2, t0.photo AS photo_3, t0.cadre AS cadre_4, t0.carte AS carte_5, t0.federation_id AS federation_id_6, t0.user_id AS user_id_7 FROM membre t0 WHERE t0.id = ?

Parameters:

[
  6263
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.adhesion AS adhesion_2,
  t0.photo AS photo_3,
  t0.cadre AS cadre_4,
  t0.carte AS carte_5,
  t0.federation_id AS federation_id_6,
  t0.user_id AS user_id_7
FROM
  membre t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.adhesion AS adhesion_2, t0.photo AS photo_3, t0.cadre AS cadre_4, t0.carte AS carte_5, t0.federation_id AS federation_id_6, t0.user_id AS user_id_7 FROM membre t0 WHERE t0.id = 6263;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 367)
5	Proxies\__CG__\App\Entity\Membre::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Membre->__get (line 83)
8	App\Entity\Membre->getUser (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 177)
10	__TwigTemplate_19c815e02c7053ca967da640749b63d1->block_body (line 446)
11	Twig\Template->yieldBlock (line 617)
12	__TwigTemplate_6cdd3af3572437aac5b1ed9305a97f9b->doDisplay (line 402)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_19c815e02c7053ca967da640749b63d1->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 144)
23	App\Controller\TransactionController->show (line 181)
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)

7.82 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t5.id AS id_6, t5.adhesion AS adhesion_7, t5.photo AS photo_8, t5.cadre AS cadre_9, t5.carte AS carte_10, t5.federation_id AS federation_id_11, t5.user_id AS user_id_12, t0.personne_id AS personne_id_13 FROM `user` t0 LEFT JOIN membre t5 ON t5.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  6577
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t5.id AS id_6,
  t5.adhesion AS adhesion_7,
  t5.photo AS photo_8,
  t5.cadre AS cadre_9,
  t5.carte AS carte_10,
  t5.federation_id AS federation_id_11,
  t5.user_id AS user_id_12,
  t0.personne_id AS personne_id_13
FROM
  `user` t0
  LEFT JOIN membre t5 ON t5.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t5.id AS id_6, t5.adhesion AS adhesion_7, t5.photo AS photo_8, t5.cadre AS cadre_9, t5.carte AS carte_10, t5.federation_id AS federation_id_11, t5.user_id AS user_id_12, t0.personne_id AS personne_id_13 FROM `user` t0 LEFT JOIN membre t5 ON t5.user_id = t0.id WHERE t0.id = 6577;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 367)
5	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\User->__get (line 132)
8	App\Entity\User->getPersonne (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 180)
10	__TwigTemplate_19c815e02c7053ca967da640749b63d1->block_body (line 446)
11	Twig\Template->yieldBlock (line 617)
12	__TwigTemplate_6cdd3af3572437aac5b1ed9305a97f9b->doDisplay (line 402)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_19c815e02c7053ca967da640749b63d1->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 144)
23	App\Controller\TransactionController->show (line 181)
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)

0.83 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.postnom AS postnom_3, t0.prenom AS prenom_4, t0.date_naissance AS date_naissance_5, t0.lieu_naissance AS lieu_naissance_6, t0.sexe AS sexe_7, t0.etat_civil AS etat_civil_8, t0.fonction AS fonction_9, t0.niveau_etude AS niveau_etude_10, t0.adresse AS adresse_11, t0.telephone AS telephone_12, t0.province AS province_13, t0.district AS district_14, t0.secteur AS secteur_15, t0.commune AS commune_16, t0.quartier AS quartier_17, t0.territoire AS territoire_18, t0.telephone2 AS telephone2_19 FROM personne t0 WHERE t0.id = ?

Parameters:

[
  6470
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.postnom AS postnom_3,
  t0.prenom AS prenom_4,
  t0.date_naissance AS date_naissance_5,
  t0.lieu_naissance AS lieu_naissance_6,
  t0.sexe AS sexe_7,
  t0.etat_civil AS etat_civil_8,
  t0.fonction AS fonction_9,
  t0.niveau_etude AS niveau_etude_10,
  t0.adresse AS adresse_11,
  t0.telephone AS telephone_12,
  t0.province AS province_13,
  t0.district AS district_14,
  t0.secteur AS secteur_15,
  t0.commune AS commune_16,
  t0.quartier AS quartier_17,
  t0.territoire AS territoire_18,
  t0.telephone2 AS telephone2_19
FROM
  personne t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.postnom AS postnom_3, t0.prenom AS prenom_4, t0.date_naissance AS date_naissance_5, t0.lieu_naissance AS lieu_naissance_6, t0.sexe AS sexe_7, t0.etat_civil AS etat_civil_8, t0.fonction AS fonction_9, t0.niveau_etude AS niveau_etude_10, t0.adresse AS adresse_11, t0.telephone AS telephone_12, t0.province AS province_13, t0.district AS district_14, t0.secteur AS secteur_15, t0.commune AS commune_16, t0.quartier AS quartier_17, t0.territoire AS territoire_18, t0.telephone2 AS telephone2_19 FROM personne t0 WHERE t0.id = 6470;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 367)
5	Proxies\__CG__\App\Entity\Personne::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Personne->__get (line 77)
8	App\Entity\Personne->getNom (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 183)
10	__TwigTemplate_19c815e02c7053ca967da640749b63d1->block_body (line 446)
11	Twig\Template->yieldBlock (line 617)
12	__TwigTemplate_6cdd3af3572437aac5b1ed9305a97f9b->doDisplay (line 402)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_19c815e02c7053ca967da640749b63d1->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 144)
23	App\Controller\TransactionController->show (line 181)
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)

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\Transaction	1
App\Entity\Membre	1
App\Entity\Federation	1
App\Entity\User	1
App\Entity\Personne	1

Entities Mapping

Class	Mapping errors
App\Entity\Transaction	No errors.
App\Entity\Membre	No errors.
App\Entity\Federation	No errors.
App\Entity\User	No errors.
App\Entity\Cotisation	No errors.
App\Entity\Carte	No errors.
App\Entity\Personne	No errors.
App\Entity\Province	No errors.
App\Entity\Communique	No errors.

Symfony Profiler

GET https://www.mlcapp.org/transaction/1455

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping