Symfony Profiler

Query Metrics

5 Database Queries

3 Different statements

71.67 ms Query time

3 Invalid entities

963 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

40.76 ms
(56.87%)

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_61eea1de9144a2ab8ee96e016553606c->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 69)
35	App\Controller\CommandeController->new (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)

20.93 ms
(29.21%)

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.ean13 AS ean13_2, c0_.quantite AS quantite_3, c0_.alerte AS alerte_4, c0_.categorie AS categorie_5, c0_.nomenclature AS nomenclature_6, c0_.ht AS ht_7, c0_.taxe AS taxe_8, c0_.dlc AS dlc_9, c0_.is_france AS is_france_10, c0_.qt_tempo AS qt_tempo_11, c0_.qt_site AS qt_site_12, c0_.qt_appro AS qt_appro_13, c0_.is_bouquet AS is_bouquet_14, c0_.qr_code_path AS qr_code_path_15, c0_.reffj AS reffj_16, c0_.is_surveillance AS is_surveillance_17, c0_.is_active_produit AS is_active_produit_18, c0_.is_coupure_produit AS is_coupure_produit_19, c0_.is_in_active_produit AS is_in_active_produit_20, c0_.date_debut AS date_debut_21, c0_.date_fin AS date_fin_22, c0_.fournisseurs_id AS fournisseurs_id_23, c0_.qt_id AS qt_id_24, c0_.commande_id AS commande_id_25 FROM composant c0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.ean13 AS ean13_2,
  c0_.quantite AS quantite_3,
  c0_.alerte AS alerte_4,
  c0_.categorie AS categorie_5,
  c0_.nomenclature AS nomenclature_6,
  c0_.ht AS ht_7,
  c0_.taxe AS taxe_8,
  c0_.dlc AS dlc_9,
  c0_.is_france AS is_france_10,
  c0_.qt_tempo AS qt_tempo_11,
  c0_.qt_site AS qt_site_12,
  c0_.qt_appro AS qt_appro_13,
  c0_.is_bouquet AS is_bouquet_14,
  c0_.qr_code_path AS qr_code_path_15,
  c0_.reffj AS reffj_16,
  c0_.is_surveillance AS is_surveillance_17,
  c0_.is_active_produit AS is_active_produit_18,
  c0_.is_coupure_produit AS is_coupure_produit_19,
  c0_.is_in_active_produit AS is_in_active_produit_20,
  c0_.date_debut AS date_debut_21,
  c0_.date_fin AS date_fin_22,
  c0_.fournisseurs_id AS fournisseurs_id_23,
  c0_.qt_id AS qt_id_24,
  c0_.commande_id AS commande_id_25
FROM
  composant c0_

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.ean13 AS ean13_2, c0_.quantite AS quantite_3, c0_.alerte AS alerte_4, c0_.categorie AS categorie_5, c0_.nomenclature AS nomenclature_6, c0_.ht AS ht_7, c0_.taxe AS taxe_8, c0_.dlc AS dlc_9, c0_.is_france AS is_france_10, c0_.qt_tempo AS qt_tempo_11, c0_.qt_site AS qt_site_12, c0_.qt_appro AS qt_appro_13, c0_.is_bouquet AS is_bouquet_14, c0_.qr_code_path AS qr_code_path_15, c0_.reffj AS reffj_16, c0_.is_surveillance AS is_surveillance_17, c0_.is_active_produit AS is_active_produit_18, c0_.is_coupure_produit AS is_coupure_produit_19, c0_.is_in_active_produit AS is_in_active_produit_20, c0_.date_debut AS date_debut_21, c0_.date_fin AS date_fin_22, c0_.fournisseurs_id AS fournisseurs_id_23, c0_.qt_id AS qt_id_24, c0_.commande_id AS commande_id_25 FROM composant c0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 187)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 234)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 64)
21	Symfony\Component\Form\Extension\Core\Type\CollectionType->buildView (line 107)
22	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
23	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
24	Symfony\Component\Form\Form->createView (line 891)
25	Symfony\Component\Form\Form->createView (line 451)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 69)
29	App\Controller\CommandeController->new (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

9.98 ms
(13.92%)

SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.contact AS contact_2, f0_.email AS email_3, f0_.telephone AS telephone_4, f0_.adresse AS adresse_5, f0_.ville AS ville_6, f0_.code_postal AS code_postal_7, f0_.pays AS pays_8, f0_.site_web AS site_web_9, f0_.ref_fournisseur AS ref_fournisseur_10 FROM fournisseur f0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.nom AS nom_1,
  f0_.contact AS contact_2,
  f0_.email AS email_3,
  f0_.telephone AS telephone_4,
  f0_.adresse AS adresse_5,
  f0_.ville AS ville_6,
  f0_.code_postal AS code_postal_7,
  f0_.pays AS pays_8,
  f0_.site_web AS site_web_9,
  f0_.ref_fournisseur AS ref_fournisseur_10
FROM
  fournisseur f0_

SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.contact AS contact_2, f0_.email AS email_3, f0_.telephone AS telephone_4, f0_.adresse AS adresse_5, f0_.ville AS ville_6, f0_.code_postal AS code_postal_7, f0_.pays AS pays_8, f0_.site_web AS site_web_9, f0_.ref_fournisseur AS ref_fournisseur_10 FROM fournisseur f0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 187)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 234)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 451)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 69)
24	App\Controller\CommandeController->new (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	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	685
App\Entity\Composant	224
App\Entity\Fournisseur	54

Entities Mapping

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

Symfony Profiler

GET https://app-prod.fr/commande/new

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping