Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.99 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.44 ms
(44.75%)

SELECT t0.id AS id_1, t0.prix AS prix_2, t0.stock AS stock_3, t0.qte_vendu AS qte_vendu_4, t0.qte_approvisionne AS qte_approvisionne_5, t0.qte_retourne AS qte_retourne_6, t0.nb_reportion AS nb_reportion_7, t0.stock_en_portion AS stock_en_portion_8, t0.reference_systeme AS reference_systeme_9, t0.reference_manuel AS reference_manuel_10, t0.cree_le AS cree_le_11, t0.modifie_le AS modifie_le_12, t0.service_id AS service_id_13, t0.produit_id AS produit_id_14 FROM prix_aapplique t0 WHERE t0.id = ?

Parameters:

[
  b"\x01ù╗■,My&Ø\x1A┤\x18\x1F¯î\x04"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.prix AS prix_2,
  t0.stock AS stock_3,
  t0.qte_vendu AS qte_vendu_4,
  t0.qte_approvisionne AS qte_approvisionne_5,
  t0.qte_retourne AS qte_retourne_6,
  t0.nb_reportion AS nb_reportion_7,
  t0.stock_en_portion AS stock_en_portion_8,
  t0.reference_systeme AS reference_systeme_9,
  t0.reference_manuel AS reference_manuel_10,
  t0.cree_le AS cree_le_11,
  t0.modifie_le AS modifie_le_12,
  t0.service_id AS service_id_13,
  t0.produit_id AS produit_id_14
FROM
  prix_aapplique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.prix AS prix_2, t0.stock AS stock_3, t0.qte_vendu AS qte_vendu_4, t0.qte_approvisionne AS qte_approvisionne_5, t0.qte_retourne AS qte_retourne_6, t0.nb_reportion AS nb_reportion_7, t0.stock_en_portion AS stock_en_portion_8, t0.reference_systeme AS reference_systeme_9, t0.reference_manuel AS reference_manuel_10, t0.cree_le AS cree_le_11, t0.modifie_le AS modifie_le_12, t0.service_id AS service_id_13, t0.produit_id AS produit_id_14 FROM prix_aapplique t0 WHERE t0.id = 0x0197BBFE2C4D79269D1AB4181FEE8C04;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 116)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 87)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 36)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 170)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.33 ms
(33.19%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.prix_ht AS prix_ht_3, t0.prix_achat AS prix_achat_4, t0.description AS description_5, t0.code_barre AS code_barre_6, t0.code_barre_fournisseur AS code_barre_fournisseur_7, t0.stock_actuel AS stock_actuel_8, t0.qte_reapprovissement AS qte_reapprovissement_9, t0.qte_mini AS qte_mini_10, t0.qte_vente AS qte_vente_11, t0.qte_rebus AS qte_rebus_12, t0.prix_revient AS prix_revient_13, t0.est_matiere_premiere AS est_matiere_premiere_14, t0.est_stockable AS est_stockable_15, t0.est_disponible AS est_disponible_16, t0.unite AS unite_17, t0.unite_detail AS unite_detail_18, t0.nbre_unite AS nbre_unite_19, t0.stock_alerte AS stock_alerte_20, t0.reference_systeme AS reference_systeme_21, t0.reference_manuel AS reference_manuel_22, t0.cree_le AS cree_le_23, t0.modifie_le AS modifie_le_24, t0.famille_id AS famille_id_25, t26.id AS id_27, t26.qte_en_stock AS qte_en_stock_28, t26.auteur_modif AS auteur_modif_29, t26.date_modif AS date_modif_30, t26.produit_id AS produit_id_31 FROM produit t0 LEFT JOIN stock t26 ON t26.produit_id = t0.id WHERE t0.id = ?

Parameters:

[
  b"\x01ù╗■,My&Ø\x1A┤\x18 dfv"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.prix_ht AS prix_ht_3,
  t0.prix_achat AS prix_achat_4,
  t0.description AS description_5,
  t0.code_barre AS code_barre_6,
  t0.code_barre_fournisseur AS code_barre_fournisseur_7,
  t0.stock_actuel AS stock_actuel_8,
  t0.qte_reapprovissement AS qte_reapprovissement_9,
  t0.qte_mini AS qte_mini_10,
  t0.qte_vente AS qte_vente_11,
  t0.qte_rebus AS qte_rebus_12,
  t0.prix_revient AS prix_revient_13,
  t0.est_matiere_premiere AS est_matiere_premiere_14,
  t0.est_stockable AS est_stockable_15,
  t0.est_disponible AS est_disponible_16,
  t0.unite AS unite_17,
  t0.unite_detail AS unite_detail_18,
  t0.nbre_unite AS nbre_unite_19,
  t0.stock_alerte AS stock_alerte_20,
  t0.reference_systeme AS reference_systeme_21,
  t0.reference_manuel AS reference_manuel_22,
  t0.cree_le AS cree_le_23,
  t0.modifie_le AS modifie_le_24,
  t0.famille_id AS famille_id_25,
  t26.id AS id_27,
  t26.qte_en_stock AS qte_en_stock_28,
  t26.auteur_modif AS auteur_modif_29,
  t26.date_modif AS date_modif_30,
  t26.produit_id AS produit_id_31
FROM
  produit t0
  LEFT JOIN stock t26 ON t26.produit_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.prix_ht AS prix_ht_3, t0.prix_achat AS prix_achat_4, t0.description AS description_5, t0.code_barre AS code_barre_6, t0.code_barre_fournisseur AS code_barre_fournisseur_7, t0.stock_actuel AS stock_actuel_8, t0.qte_reapprovissement AS qte_reapprovissement_9, t0.qte_mini AS qte_mini_10, t0.qte_vente AS qte_vente_11, t0.qte_rebus AS qte_rebus_12, t0.prix_revient AS prix_revient_13, t0.est_matiere_premiere AS est_matiere_premiere_14, t0.est_stockable AS est_stockable_15, t0.est_disponible AS est_disponible_16, t0.unite AS unite_17, t0.unite_detail AS unite_detail_18, t0.nbre_unite AS nbre_unite_19, t0.stock_alerte AS stock_alerte_20, t0.reference_systeme AS reference_systeme_21, t0.reference_manuel AS reference_manuel_22, t0.cree_le AS cree_le_23, t0.modifie_le AS modifie_le_24, t0.famille_id AS famille_id_25, t26.id AS id_27, t26.qte_en_stock AS qte_en_stock_28, t26.auteur_modif AS auteur_modif_29, t26.date_modif AS date_modif_30, t26.produit_id AS produit_id_31 FROM produit t0 LEFT JOIN stock t26 ON t26.produit_id = t0.id WHERE t0.id = 0x0197BBFE2C4D79269D1AB41820646676;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 61)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
6	Proxies\__CG__\App\Entity\Produit->__get (line 497)
7	App\Entity\Produit->getImagesProduits (line 1629)
8	Twig\Extension\CoreExtension::getAttribute (line 75)
9	__TwigTemplate_29ee88e7a3db29668036559fd246cb49->block_body (line 430)
10	Twig\Template->yieldBlock (line 212)
11	__TwigTemplate_e4e0219b24a74ebb7778bd46d052627d->doDisplay (line 360)
12	Twig\Template->yield (line 49)
13	__TwigTemplate_29ee88e7a3db29668036559fd246cb49->doDisplay (line 360)
14	Twig\Template->yield (line 335)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 307)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 172)
21	App\Controller\AccueilController->chambres (line 178)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.22 ms
(22.06%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.produit_id AS produit_id_3 FROM images_produit t0 WHERE t0.produit_id = ?

Parameters:

[
  b"\x01ù╗■,My&Ø\x1A┤\x18 dfv"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.produit_id AS produit_id_3
FROM
  images_produit t0
WHERE
  t0.produit_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.produit_id AS produit_id_3 FROM images_produit t0 WHERE t0.produit_id = 0x0197BBFE2C4D79269D1AB41820646676;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2708)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
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 1137)
9	Twig\Extension\CoreExtension::length (line 75)
10	__TwigTemplate_29ee88e7a3db29668036559fd246cb49->block_body (line 430)
11	Twig\Template->yieldBlock (line 212)
12	__TwigTemplate_e4e0219b24a74ebb7778bd46d052627d->doDisplay (line 360)
13	Twig\Template->yield (line 49)
14	__TwigTemplate_29ee88e7a3db29668036559fd246cb49->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 307)
18	Twig\Environment->render (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 172)
22	App\Controller\AccueilController->chambres (line 178)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	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.

Entities Mapping

Class	Mapping errors
App\Entity\PrixAApplique	No errors.
App\Entity\Services	No errors.
App\Entity\Produit	No errors.
App\Entity\LigneFacture	No errors.
App\Entity\LigneDemandeProduitService	No errors.
App\Entity\Famille	No errors.
App\Entity\Stock	No errors.
App\Entity\LigneEntreeStock	No errors.
App\Entity\MouvementStock	No errors.
App\Entity\ImagesProduit	No errors.
App\Entity\LigneSortiesStock	No errors.
App\Entity\AffectationMateriel	No errors.
App\Entity\LigneInventaire	No errors.

Symfony Profiler

GET https://reservation.complexehotelierlabonte.com/hebergement/details/0197bbfe-2c4d-7926-9d1a-b4181fee8c04

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping