Symfony Profiler

Query Metrics

9 Database Queries

5 Different statements

120.49 ms Query time

3 Invalid entities

713 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

59.53 ms
(49.40%)

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 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
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 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 236)
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_231daf671cf1b3774d4c94fdb9c44126->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 92)
35	App\Controller\AssociationController->show (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)

29.92 ms
(24.83%)

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 FROM composant t0 WHERE t0.id = ?

Parameters:

[
  307
]

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
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 FROM composant t0 WHERE t0.id = 307;

#	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 129)
8	App\Entity\Composant->getNom (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 143)
10	__TwigTemplate_231daf671cf1b3774d4c94fdb9c44126->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_231daf671cf1b3774d4c94fdb9c44126->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 92)
25	App\Controller\AssociationController->show (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)

10.65 ms
(8.84%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.old AS old_4, t0.bundle AS bundle_5, t0.is_active AS is_active_6, t0.reference AS reference_7, t0.qr_code_path AS qr_code_path_8, t0.is_surveillance AS is_surveillance_9, t0.is_france AS is_france_10, t0.is_active_produit AS is_active_produit_11, t0.is_coupure_produit AS is_coupure_produit_12, t0.is_in_active_produit AS is_in_active_produit_13, t0.date_debut AS date_debut_14, t0.date_fin AS date_fin_15 FROM produit t0 WHERE t0.id = ?

Parameters:

[
  269
]

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.old AS old_4,
  t0.bundle AS bundle_5,
  t0.is_active AS is_active_6,
  t0.reference AS reference_7,
  t0.qr_code_path AS qr_code_path_8,
  t0.is_surveillance AS is_surveillance_9,
  t0.is_france AS is_france_10,
  t0.is_active_produit AS is_active_produit_11,
  t0.is_coupure_produit AS is_coupure_produit_12,
  t0.is_in_active_produit AS is_in_active_produit_13,
  t0.date_debut AS date_debut_14,
  t0.date_fin AS date_fin_15
FROM
  produit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.old AS old_4, t0.bundle AS bundle_5, t0.is_active AS is_active_6, t0.reference AS reference_7, t0.qr_code_path AS qr_code_path_8, t0.is_surveillance AS is_surveillance_9, t0.is_france AS is_france_10, t0.is_active_produit AS is_active_produit_11, t0.is_coupure_produit AS is_coupure_produit_12, t0.is_in_active_produit AS is_in_active_produit_13, t0.date_debut AS date_debut_14, t0.date_fin AS date_fin_15 FROM produit t0 WHERE t0.id = 269;

#	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\Produit::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\Produit->__get (line 88)
8	App\Entity\Produit->getNom (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 119)
10	__TwigTemplate_231daf671cf1b3774d4c94fdb9c44126->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_231daf671cf1b3774d4c94fdb9c44126->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 92)
25	App\Controller\AssociationController->show (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)

10.47 ms
(8.69%)

SELECT t0.id AS id_1, t0.produit_reference AS produit_reference_2, t0.is_active_produit AS is_active_produit_3, t0.is_coupure_produit AS is_coupure_produit_4, t0.is_in_active_produit AS is_in_active_produit_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.produit_id AS produit_id_8 FROM association t0 WHERE t0.id = ?

Parameters:

[
  "1912"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.produit_reference AS produit_reference_2,
  t0.is_active_produit AS is_active_produit_3,
  t0.is_coupure_produit AS is_coupure_produit_4,
  t0.is_in_active_produit AS is_in_active_produit_5,
  t0.date_debut AS date_debut_6,
  t0.date_fin AS date_fin_7,
  t0.produit_id AS produit_id_8
FROM
  association t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.produit_reference AS produit_reference_2, t0.is_active_produit AS is_active_produit_3, t0.is_coupure_produit AS is_coupure_produit_4, t0.is_in_active_produit AS is_in_active_produit_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.produit_id AS produit_id_8 FROM association t0 WHERE t0.id = '1912';

#	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 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 69)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

9.93 ms
(8.24%)

SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.composants_id AS composants_id_3, t0.association_id AS association_id_4 FROM qt t0 WHERE t0.association_id = ?

Parameters:

[
  1912
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.quantite AS quantite_2,
  t0.composants_id AS composants_id_3,
  t0.association_id AS association_id_4
FROM
  qt t0
WHERE
  t0.association_id = ?

SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.composants_id AS composants_id_3, t0.association_id AS association_id_4 FROM qt t0 WHERE t0.association_id = 1912;

#	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 128)
10	__TwigTemplate_231daf671cf1b3774d4c94fdb9c44126->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_231daf671cf1b3774d4c94fdb9c44126->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 92)
25	App\Controller\AssociationController->show (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)

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	702
App\Entity\Qt	3
App\Entity\Composant	3
App\Entity\Fournisseur	3
App\Entity\Association	1
App\Entity\Produit	1

Entities Mapping

Class	Mapping errors
App\Entity\Association	No errors.
App\Entity\Produit	No errors.
App\Entity\Qt	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\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\Commande	The mappings App\Entity\Commande#fournisseurs and App\Entity\Fournisseur#commandes are inconsistent with each other.
App\Entity\QtCommande	No errors.
App\Entity\Mouvement	No errors.

Symfony Profiler

GET https://app-prod.fr/association/1912

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping