Symfony Profiler

Query Metrics

10 Database Queries

5 Different statements

19.09 ms Query time

3 Invalid entities

4834 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.50 ms
(60.27%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.ref AS ref_4, t0.old_id_web AS old_id_web_5, t0.is_etat_end AS is_etat_end_6, t0.is_etat_one AS is_etat_one_7, t0.is_accep AS is_accep_8, t0.quantite AS quantite_9, t0.num_commande AS num_commande_10, t0.num_facture AS num_facture_11, t0.date AS date_12, t0.is_en_livraison AS is_en_livraison_13, t0.date_delivery AS date_delivery_14, t0.is_relivraison AS is_relivraison_15 FROM mouvement_web t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.ean13 AS ean13_3,
  t0.ref AS ref_4,
  t0.old_id_web AS old_id_web_5,
  t0.is_etat_end AS is_etat_end_6,
  t0.is_etat_one AS is_etat_one_7,
  t0.is_accep AS is_accep_8,
  t0.quantite AS quantite_9,
  t0.num_commande AS num_commande_10,
  t0.num_facture AS num_facture_11,
  t0.date AS date_12,
  t0.is_en_livraison AS is_en_livraison_13,
  t0.date_delivery AS date_delivery_14,
  t0.is_relivraison AS is_relivraison_15
FROM
  mouvement_web t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.ref AS ref_4, t0.old_id_web AS old_id_web_5, t0.is_etat_end AS is_etat_end_6, t0.is_etat_one AS is_etat_one_7, t0.is_accep AS is_accep_8, t0.quantite AS quantite_9, t0.num_commande AS num_commande_10, t0.num_facture AS num_facture_11, t0.date AS date_12, t0.is_en_livraison AS is_en_livraison_13, t0.date_delivery AS date_delivery_14, t0.is_relivraison AS is_relivraison_15 FROM mouvement_web t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 23)
6	App\Twig\Components\BellNotif->getMouvements (line 1909)
7	Twig\Extension\CoreExtension::getAttribute (line 59)
8	__TwigTemplate_84f68b0e3be382a626e80fc525ea2017->doDisplay (line 402)
9	Twig\Template->yield (line 358)
10	Twig\Template->display (line 373)
11	Twig\Template->render (line 77)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
14	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 245)
15	__TwigTemplate_67cb56fe31a7f1c33caf1e9c1ca3a9c3->doDisplay (line 402)
16	Twig\Template->yield (line 358)
17	Twig\Template->display (line 373)
18	Twig\Template->render (line 77)
19	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
20	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
21	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 247)
22	__TwigTemplate_65aad7421501b7d281d908ea5b868879->block_body (line 446)
23	Twig\Template->yieldBlock (line 109)
24	__TwigTemplate_65aad7421501b7d281d908ea5b868879->doDisplay (line 402)
25	Twig\Template->yield (line 54)
26	__TwigTemplate_6fff53ade2e82191ec33c34760a4c6f6->doDisplay (line 402)
27	Twig\Template->yield (line 358)
28	Twig\Template->display (line 373)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 333)
31	Twig\Environment->render (line 459)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 26)
35	App\Controller\CommandeController->index (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 5)

2.10 ms
(10.98%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = ?

Parameters:

[
  88
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.contact AS contact_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5,
  t0.adresse AS adresse_6,
  t0.ville AS ville_7,
  t0.code_postal AS code_postal_8,
  t0.pays AS pays_9,
  t0.site_web AS site_web_10,
  t0.ref_fournisseur AS ref_fournisseur_11
FROM
  fournisseur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = 88;

#	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\Fournisseur::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\Fournisseur->__get (line 85)
8	App\Entity\Fournisseur->getNom (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 144)
10	__TwigTemplate_6fff53ade2e82191ec33c34760a4c6f6->block_content (line 446)
11	Twig\Template->yieldBlock (line 252)
12	__TwigTemplate_65aad7421501b7d281d908ea5b868879->block_body (line 446)
13	Twig\Template->yieldBlock (line 109)
14	__TwigTemplate_65aad7421501b7d281d908ea5b868879->doDisplay (line 402)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_6fff53ade2e82191ec33c34760a4c6f6->doDisplay (line 402)
17	Twig\Template->yield (line 358)
18	Twig\Template->display (line 373)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 333)
21	Twig\Environment->render (line 459)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 26)
25	App\Controller\CommandeController->index (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.96 ms
(10.26%)

SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.ht AS ht_3, t0.quantite_recu AS quantite_recu_4, t0.date AS date_5, t0.composants_id AS composants_id_6, t0.commande_id AS commande_id_7 FROM qt_commande t0 WHERE t0.commande_id = ?

Parameters:

[
  70
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.quantite AS quantite_2,
  t0.ht AS ht_3,
  t0.quantite_recu AS quantite_recu_4,
  t0.date AS date_5,
  t0.composants_id AS composants_id_6,
  t0.commande_id AS commande_id_7
FROM
  qt_commande t0
WHERE
  t0.commande_id = ?

SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.ht AS ht_3, t0.quantite_recu AS quantite_recu_4, t0.date AS date_5, t0.composants_id AS composants_id_6, t0.commande_id AS commande_id_7 FROM qt_commande t0 WHERE t0.commande_id = 70;

#	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 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1417)
9	Twig\Extension\CoreExtension::testEmpty (line 149)
10	__TwigTemplate_6fff53ade2e82191ec33c34760a4c6f6->block_content (line 446)
11	Twig\Template->yieldBlock (line 252)
12	__TwigTemplate_65aad7421501b7d281d908ea5b868879->block_body (line 446)
13	Twig\Template->yieldBlock (line 109)
14	__TwigTemplate_65aad7421501b7d281d908ea5b868879->doDisplay (line 402)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_6fff53ade2e82191ec33c34760a4c6f6->doDisplay (line 402)
17	Twig\Template->yield (line 358)
18	Twig\Template->display (line 373)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 333)
21	Twig\Environment->render (line 459)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 26)
25	App\Controller\CommandeController->index (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.93 ms
(10.11%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?

Parameters:

[
  205
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.ean13 AS ean13_3,
  t0.quantite AS quantite_4,
  t0.alerte AS alerte_5,
  t0.categorie AS categorie_6,
  t0.nomenclature AS nomenclature_7,
  t0.ht AS ht_8,
  t0.taxe AS taxe_9,
  t0.dlc AS dlc_10,
  t0.is_france AS is_france_11,
  t0.qt_tempo AS qt_tempo_12,
  t0.qt_site AS qt_site_13,
  t0.qt_appro AS qt_appro_14,
  t0.is_bouquet AS is_bouquet_15,
  t0.qr_code_path AS qr_code_path_16,
  t0.reffj AS reffj_17,
  t0.is_surveillance AS is_surveillance_18,
  t0.is_active_produit AS is_active_produit_19,
  t0.is_coupure_produit AS is_coupure_produit_20,
  t0.is_in_active_produit AS is_in_active_produit_21,
  t0.date_debut AS date_debut_22,
  t0.date_fin AS date_fin_23,
  t0.fournisseurs_id AS fournisseurs_id_24,
  t0.qt_id AS qt_id_25,
  t0.commande_id AS commande_id_26,
  t0.association_id AS association_id_27
FROM
  composant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = 205;

#	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\Composant::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\Composant->__get (line 149)
8	App\Entity\Composant->getNom (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 159)
10	__TwigTemplate_6fff53ade2e82191ec33c34760a4c6f6->block_content (line 446)
11	Twig\Template->yieldBlock (line 252)
12	__TwigTemplate_65aad7421501b7d281d908ea5b868879->block_body (line 446)
13	Twig\Template->yieldBlock (line 109)
14	__TwigTemplate_65aad7421501b7d281d908ea5b868879->doDisplay (line 402)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_6fff53ade2e82191ec33c34760a4c6f6->doDisplay (line 402)
17	Twig\Template->yield (line 358)
18	Twig\Template->display (line 373)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 333)
21	Twig\Environment->render (line 459)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 26)
25	App\Controller\CommandeController->index (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.60 ms
(8.38%)

SELECT t0.id AS id_1, t0.num_commande AS num_commande_2, t0.date AS date_3, t0.dateliv AS dateliv_4, t0.is_recu AS is_recu_5, t0.pdf_path AS pdf_path_6, t0.motif AS motif_7, t0.nom_fournisseur AS nom_fournisseur_8, t0.is_archive AS is_archive_9, t0.fournisseurs_id AS fournisseurs_id_10 FROM commande t0 WHERE t0.is_archive = ? ORDER BY t0.id DESC

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.num_commande AS num_commande_2,
  t0.date AS date_3,
  t0.dateliv AS dateliv_4,
  t0.is_recu AS is_recu_5,
  t0.pdf_path AS pdf_path_6,
  t0.motif AS motif_7,
  t0.nom_fournisseur AS nom_fournisseur_8,
  t0.is_archive AS is_archive_9,
  t0.fournisseurs_id AS fournisseurs_id_10
FROM
  commande t0
WHERE
  t0.is_archive = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.num_commande AS num_commande_2, t0.date AS date_3, t0.dateliv AS dateliv_4, t0.is_recu AS is_recu_5, t0.pdf_path AS pdf_path_6, t0.motif AS motif_7, t0.nom_fournisseur AS nom_fournisseur_8, t0.is_archive AS is_archive_9, t0.fournisseurs_id AS fournisseurs_id_10 FROM commande t0 WHERE t0.is_archive = 0 ORDER BY t0.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 25)
5	App\Controller\CommandeController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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\MouvementWeb	4826
App\Entity\Commande	2
App\Entity\Fournisseur	2
App\Entity\QtCommande	2
App\Entity\Composant	2

Entities Mapping

Class	Mapping errors
App\Entity\Commande	The mappings App\Entity\Commande#fournisseurs and App\Entity\Fournisseur#commandes are inconsistent with each other.
App\Entity\Fournisseur	The association App\Entity\Fournisseur#composants refers to the owning side field App\Entity\Composant#fournisseur which does not exist. The association App\Entity\Fournisseur#commandes refers to the owning side field App\Entity\Commande#fournisseur which does not exist. The association App\Entity\Fournisseur#qtCommandes refers to the owning side field App\Entity\QtCommande#fournisseur which does not exist.
App\Entity\QtCommande	No errors.
App\Entity\MouvementWeb	No errors.
App\Entity\MouvementTransporteur	No errors.
App\Entity\MouvementWebAccessoires	No errors.
App\Entity\Composant	The mappings App\Entity\Composant#fournisseurs and App\Entity\Fournisseur#composants are inconsistent with each other. The field App\Entity\Composant#qt is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Qt#composants does not contain the required 'mappedBy="qt"' attribute. If association App\Entity\Composant#qt is many-to-one, then the inversed side App\Entity\Qt#composants has to be one-to-many. The association App\Entity\Composant#commande refers to the inverse side field App\Entity\Commande#countCommande which does not exist.
App\Entity\Qt	No errors.
App\Entity\Association	No errors.
App\Entity\Mouvement	No errors.
App\Entity\SousComposants	No errors.

Symfony Profiler

GET https://www.app-test.fr/commande

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping