Symfony Profiler

Query Metrics

16 Database Queries

7 Different statements

182.51 ms Query time

3 Invalid entities

1207 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

82.03 ms
(44.95%)

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:

[
  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
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 = 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 106)
7	Proxies\__CG__\App\Entity\Composant->initializeLazyObject (line 20)
8	Proxies\__CG__\App\Entity\Composant->__load (line 3029)
9	Doctrine\ORM\UnitOfWork->initializeObject (line 562)
10	Doctrine\ORM\EntityManager->initializeObject (line 89)
11	Symfony\Bridge\Doctrine\Form\ChoiceList\IdReader->getIdValue (line 49)
12	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->Symfony\Component\Form\ChoiceList\Loader\{closure} (line 1)
13	array_map (line 49)
14	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadValuesForChoices (line 81)
15	Symfony\Component\Form\ChoiceList\LazyChoiceList->getValuesForChoices (line 32)
16	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->transform (line 980)
17	Symfony\Component\Form\Form->normToView (line 295)
18	Symfony\Component\Form\Form->setData (line 50)
19	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 317)
20	Symfony\Component\Form\Form->setData (line 50)
21	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 766)
22	Symfony\Component\Form\Form->add (line 116)
23	Symfony\Component\Form\Extension\Core\EventListener\ResizeFormListener->postSetData (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 28)
26	Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch (line 322)
27	Symfony\Component\Form\Form->setData (line 50)
28	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 317)
29	Symfony\Component\Form\Form->setData (line 406)
30	Symfony\Component\Form\Form->initialize (line 171)
31	Symfony\Component\Form\FormBuilder->getForm (line 26)
32	Symfony\Component\Form\FormFactory->create (line 351)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 100)
34	App\Controller\AssociationController->edit (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 5)

40.64 ms
(22.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 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_ea7384f09436bb5d79e7bb4c36c081f9->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 110)
35	App\Controller\AssociationController->edit (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.78 ms
(10.84%)

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.ean13 AS ean13_2, p0_.old AS old_3, p0_.bundle AS bundle_4, p0_.is_active AS is_active_5, p0_.reference AS reference_6, p0_.qr_code_path AS qr_code_path_7, p0_.is_surveillance AS is_surveillance_8, p0_.is_france AS is_france_9, p0_.is_active_produit AS is_active_produit_10, p0_.is_coupure_produit AS is_coupure_produit_11, p0_.is_in_active_produit AS is_in_active_produit_12, p0_.date_debut AS date_debut_13, p0_.date_fin AS date_fin_14 FROM produit p0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.ean13 AS ean13_2,
  p0_.old AS old_3,
  p0_.bundle AS bundle_4,
  p0_.is_active AS is_active_5,
  p0_.reference AS reference_6,
  p0_.qr_code_path AS qr_code_path_7,
  p0_.is_surveillance AS is_surveillance_8,
  p0_.is_france AS is_france_9,
  p0_.is_active_produit AS is_active_produit_10,
  p0_.is_coupure_produit AS is_coupure_produit_11,
  p0_.is_in_active_produit AS is_in_active_produit_12,
  p0_.date_debut AS date_debut_13,
  p0_.date_fin AS date_fin_14
FROM
  produit p0_

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.ean13 AS ean13_2, p0_.old AS old_3, p0_.bundle AS bundle_4, p0_.is_active AS is_active_5, p0_.reference AS reference_6, p0_.qr_code_path AS qr_code_path_7, p0_.is_surveillance AS is_surveillance_8, p0_.is_france AS is_france_9, p0_.is_active_produit AS is_active_produit_10, p0_.is_coupure_produit AS is_coupure_produit_11, p0_.is_in_active_produit AS is_in_active_produit_12, p0_.date_debut AS date_debut_13, p0_.date_fin AS date_fin_14 FROM produit p0_;

#	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 110)
24	App\Controller\AssociationController->edit (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)

10.20 ms
(5.59%)

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:

[
  "4"
]

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 = '4';

#	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)

10.07 ms
(5.52%)

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:

[
  4
]

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 = 4;

#	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 559)
7	Doctrine\ORM\PersistentCollection->__clone (line 270)
8	Symfony\Component\Form\Form->setData (line 50)
9	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 317)
10	Symfony\Component\Form\Form->setData (line 406)
11	Symfony\Component\Form\Form->initialize (line 171)
12	Symfony\Component\Form\FormBuilder->getForm (line 26)
13	Symfony\Component\Form\FormFactory->create (line 351)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 100)
15	App\Controller\AssociationController->edit (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

10.04 ms
(5.50%)

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_ ORDER BY c0_.nom ASC

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_
ORDER BY
  c0_.nom ASC

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_ ORDER BY c0_.nom ASC;

#	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 110)
29	App\Controller\AssociationController->edit (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.76 ms
(5.34%)

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:

[
  4
]

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 = 4;

#	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 106)
7	Proxies\__CG__\App\Entity\Produit->initializeLazyObject (line 20)
8	Proxies\__CG__\App\Entity\Produit->__load (line 3029)
9	Doctrine\ORM\UnitOfWork->initializeObject (line 562)
10	Doctrine\ORM\EntityManager->initializeObject (line 89)
11	Symfony\Bridge\Doctrine\Form\ChoiceList\IdReader->getIdValue (line 49)
12	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->Symfony\Component\Form\ChoiceList\Loader\{closure} (line 1)
13	array_map (line 49)
14	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadValuesForChoices (line 81)
15	Symfony\Component\Form\ChoiceList\LazyChoiceList->getValuesForChoices (line 32)
16	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->transform (line 980)
17	Symfony\Component\Form\Form->normToView (line 295)
18	Symfony\Component\Form\Form->setData (line 50)
19	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 317)
20	Symfony\Component\Form\Form->setData (line 406)
21	Symfony\Component\Form\Form->initialize (line 171)
22	Symfony\Component\Form\FormBuilder->getForm (line 26)
23	Symfony\Component\Form\FormFactory->create (line 351)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 100)
25	App\Controller\AssociationController->edit (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	686
App\Entity\Produit	267
App\Entity\Composant	224
App\Entity\Fournisseur	21
App\Entity\Qt	8
App\Entity\Association	1

Entities Mapping

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

Symfony Profiler

GET https://app-prod.fr/association/4/edit

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping