Symfony Profiler

Query Metrics

4 Database Queries

2 Different statements

71.19 ms Query time

3 Invalid entities

923 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

51.36 ms
(72.15%)

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_c9ae1c7dc563e4b8872c7ea8262ba8c0->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 30)
35	App\Controller\ComposantStockOutController->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)

19.83 ms
(27.85%)

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

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.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

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;

#	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 15)
6	App\Controller\ComposantStockOutController->index (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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	678
App\Entity\Composant	224
App\Entity\Fournisseur	21

Entities Mapping

Class	Mapping 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\Qt	No errors.
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.
App\Entity\MouvementWeb	No errors.
App\Entity\MouvementTransporteur	No errors.
App\Entity\MouvementWebAccessoires	No errors.

Symfony Profiler

GET https://app-prod.fr/composant/stock/out

Configuration Settings

Theme

Page Width