Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

1.17 ms Query time

0 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.26 ms
(22.24%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.filiere AS filiere_3, t0.type_apport AS type_apport_4, t0.methode_saisie AS methode_saisie_5, t0.poids_kg AS poids_kg_6, t0.quantite AS quantite_7, t0.poids_calcule_kg AS poids_calcule_kg_8, t0.description AS description_9, t0.prix_estime AS prix_estime_10, t0.chemin_photo AS chemin_photo_11, t0.statut AS statut_12, t0.etiquette_imprimee AS etiquette_imprimee_13, t0.date_reception AS date_reception_14, t0.trimestre_reception AS trimestre_reception_15, t0.annee_reception AS annee_reception_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.site_id AS site_id_19, t0.cree_par_id AS cree_par_id_20, t0.categorie_id AS categorie_id_21, t0.sous_categorie_id AS sous_categorie_id_22, t0.partenaire_id AS partenaire_id_23, t24.id AS id_25, t24.type_sortie AS type_sortie_26, t24.date_sortie AS date_sortie_27, t24.trimestre_sortie AS trimestre_sortie_28, t24.annee_sortie AS annee_sortie_29, t24.type_dea AS type_dea_30, t24.created_at AS created_at_31, t24.article_id AS article_id_32, t24.enregistre_par_id AS enregistre_par_id_33 FROM article t0 LEFT JOIN sortie_article t24 ON t24.article_id = t0.id WHERE t0.id = ?

Parameters:

[
  b"\x01ž»ÛRwzµ•gÞ¾ïª©ÿ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.filiere AS filiere_3,
  t0.type_apport AS type_apport_4,
  t0.methode_saisie AS methode_saisie_5,
  t0.poids_kg AS poids_kg_6,
  t0.quantite AS quantite_7,
  t0.poids_calcule_kg AS poids_calcule_kg_8,
  t0.description AS description_9,
  t0.prix_estime AS prix_estime_10,
  t0.chemin_photo AS chemin_photo_11,
  t0.statut AS statut_12,
  t0.etiquette_imprimee AS etiquette_imprimee_13,
  t0.date_reception AS date_reception_14,
  t0.trimestre_reception AS trimestre_reception_15,
  t0.annee_reception AS annee_reception_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.site_id AS site_id_19,
  t0.cree_par_id AS cree_par_id_20,
  t0.categorie_id AS categorie_id_21,
  t0.sous_categorie_id AS sous_categorie_id_22,
  t0.partenaire_id AS partenaire_id_23,
  t24.id AS id_25,
  t24.type_sortie AS type_sortie_26,
  t24.date_sortie AS date_sortie_27,
  t24.trimestre_sortie AS trimestre_sortie_28,
  t24.annee_sortie AS annee_sortie_29,
  t24.type_dea AS type_dea_30,
  t24.created_at AS created_at_31,
  t24.article_id AS article_id_32,
  t24.enregistre_par_id AS enregistre_par_id_33
FROM
  article t0
  LEFT JOIN sortie_article t24 ON t24.article_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.filiere AS filiere_3, t0.type_apport AS type_apport_4, t0.methode_saisie AS methode_saisie_5, t0.poids_kg AS poids_kg_6, t0.quantite AS quantite_7, t0.poids_calcule_kg AS poids_calcule_kg_8, t0.description AS description_9, t0.prix_estime AS prix_estime_10, t0.chemin_photo AS chemin_photo_11, t0.statut AS statut_12, t0.etiquette_imprimee AS etiquette_imprimee_13, t0.date_reception AS date_reception_14, t0.trimestre_reception AS trimestre_reception_15, t0.annee_reception AS annee_reception_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.site_id AS site_id_19, t0.cree_par_id AS cree_par_id_20, t0.categorie_id AS categorie_id_21, t0.sous_categorie_id AS sous_categorie_id_22, t0.partenaire_id AS partenaire_id_23, t24.id AS id_25, t24.type_sortie AS type_sortie_26, t24.date_sortie AS date_sortie_27, t24.trimestre_sortie AS trimestre_sortie_28, t24.annee_sortie AS annee_sortie_29, t24.type_dea AS type_dea_30, t24.created_at AS created_at_31, t24.article_id AS article_id_32, t24.enregistre_par_id AS enregistre_par_id_33 FROM article t0 LEFT JOIN sortie_article t24 ON t24.article_id = t0.id WHERE t0.id = 0x019EBBDB52777AB59567DEBEEFAAA9FF;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	App\Controller\SortieController->index (line 39)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
9	Symfony\Component\HttpKernel\Kernel->handle (line 143)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
11	require_once (line 32)
12	require_once (line 5)

0.24 ms
(20.82%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.actif AS actif_7, t0.created_at AS created_at_8, t0.site_id AS site_id_9 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  b"\x01žºx~±t&¡ð…n\x05½ûy"
]

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,
  t0.prenom AS prenom_5,
  t0.nom AS nom_6,
  t0.actif AS actif_7,
  t0.created_at AS created_at_8,
  t0.site_id AS site_id_9
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.actif AS actif_7, t0.created_at AS created_at_8, t0.site_id AS site_id_9 FROM `user` t0 WHERE t0.id = 0x019EBA787EB17426A1F0856E05BDFB79;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 97)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 227)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 162)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
19	Symfony\Component\HttpKernel\Kernel->handle (line 143)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
21	require_once (line 32)
22	require_once (line 5)

0.24 ms
(20.63%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.adresse AS adresse_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.actif AS actif_7, t0.imprimante_ip AS imprimante_ip_8, t0.imprimante_port AS imprimante_port_9, t0.created_at AS created_at_10, t0.organisation_id AS organisation_id_11 FROM site t0 WHERE t0.id = ?

Parameters:

[
  b"\x01žºƒADv\x1Ež,‹Ú]\x06š\x15"
]

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.adresse AS adresse_4,
  t0.code_postal AS code_postal_5,
  t0.ville AS ville_6,
  t0.actif AS actif_7,
  t0.imprimante_ip AS imprimante_ip_8,
  t0.imprimante_port AS imprimante_port_9,
  t0.created_at AS created_at_10,
  t0.organisation_id AS organisation_id_11
FROM
  site t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.adresse AS adresse_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.actif AS actif_7, t0.imprimante_ip AS imprimante_ip_8, t0.imprimante_port AS imprimante_port_9, t0.created_at AS created_at_10, t0.organisation_id AS organisation_id_11 FROM site t0 WHERE t0.id = 0x019EBA834144761E9E2C8BDA5D069A15;

#	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 1794)
5	__TwigTemplate_a077acae774e57057c129511cb520250::doDisplay (line 104)
6	Twig\Template->yield (line 411)
7	__TwigTemplate_cf52a7fb87ab14bea630a38c993c1ae9->doDisplay (line 55)
8	Twig\Template->yield (line 411)
9	Twig\Template->display (line 366)
10	Twig\Template->render (line 381)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
16	App\Controller\SortieController->index (line 89)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
19	Symfony\Component\HttpKernel\Kernel->handle (line 143)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
21	require_once (line 32)
22	require_once (line 5)

0.24 ms
(20.29%)

SELECT t0.id AS id_1, t0.filiere AS filiere_2, t0.code AS code_3, t0.libelle AS libelle_4, t0.ordre AS ordre_5, t0.actif AS actif_6 FROM categorie_article t0 WHERE t0.id = ?

Parameters:

[
  b"\x01žº†ùÿq£•Áø„ÝKÔC"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filiere AS filiere_2,
  t0.code AS code_3,
  t0.libelle AS libelle_4,
  t0.ordre AS ordre_5,
  t0.actif AS actif_6
FROM
  categorie_article t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filiere AS filiere_2, t0.code AS code_3, t0.libelle AS libelle_4, t0.ordre AS ordre_5, t0.actif AS actif_6 FROM categorie_article t0 WHERE t0.id = 0x019EBA86F9FF71A395C1F884DD4BD443;

#	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	App\Entity\CategorieArticle::getLibelle (line 54)
5	Twig\Extension\CoreExtension->getAttribute (line 1918)
6	__TwigTemplate_cf52a7fb87ab14bea630a38c993c1ae9::block_body (line 226)
7	Twig\Template->yieldBlock (line 456)
8	__TwigTemplate_a077acae774e57057c129511cb520250->doDisplay (line 137)
9	Twig\Template->yield (line 411)
10	__TwigTemplate_cf52a7fb87ab14bea630a38c993c1ae9->doDisplay (line 55)
11	Twig\Template->yield (line 411)
12	Twig\Template->display (line 366)
13	Twig\Template->render (line 381)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
19	App\Controller\SortieController->index (line 89)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
22	Symfony\Component\HttpKernel\Kernel->handle (line 143)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
24	require_once (line 32)
25	require_once (line 5)

0.19 ms
(16.02%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.ordre AS ordre_4, t0.actif AS actif_5, t0.categorie_id AS categorie_id_6 FROM sous_categorie_article t0 WHERE t0.id = ?

Parameters:

[
  b"\x01žº†ùÿrg•Áø„àëz\x06"
]

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.ordre AS ordre_4,
  t0.actif AS actif_5,
  t0.categorie_id AS categorie_id_6
FROM
  sous_categorie_article t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.ordre AS ordre_4, t0.actif AS actif_5, t0.categorie_id AS categorie_id_6 FROM sous_categorie_article t0 WHERE t0.id = 0x019EBA86F9FF726795C1F884E0EB7A06;

#	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	App\Entity\SousCategorieArticle::getLibelle (line 53)
5	Twig\Extension\CoreExtension->getAttribute (line 1918)
6	__TwigTemplate_cf52a7fb87ab14bea630a38c993c1ae9::block_body (line 229)
7	Twig\Template->yieldBlock (line 456)
8	__TwigTemplate_a077acae774e57057c129511cb520250->doDisplay (line 137)
9	Twig\Template->yield (line 411)
10	__TwigTemplate_cf52a7fb87ab14bea630a38c993c1ae9->doDisplay (line 55)
11	Twig\Template->yield (line 411)
12	Twig\Template->display (line 366)
13	Twig\Template->render (line 381)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
19	App\Controller\SortieController->index (line 89)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
22	Symfony\Component\HttpKernel\Kernel->handle (line 143)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
24	require_once (line 32)
25	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\User	1
App\Entity\Site	1
App\Entity\Article	1
App\Entity\CategorieArticle	1
App\Entity\SousCategorieArticle	1
App\Entity\Organisation	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Site	No errors.
App\Entity\Article	No errors.
App\Entity\CategorieArticle	No errors.
App\Entity\SousCategorieArticle	No errors.
App\Entity\Partenaire	No errors.
App\Entity\SortieArticle	No errors.
App\Entity\Organisation	No errors.
App\Entity\Abaque	No errors.

GET https://trouvascan.swack.fr/sortie/019ebbdb-5277-7ab5-9567-debeefaaa9ff

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping