Symfony Profiler

Query Metrics

21 Database Queries

10 Different statements

7.98 ms Query time

5 Invalid entities

382 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.57 ms
(44.67%)

SELECT s0_.IDSejour AS IDSejour_0, s0_.NomSejour AS NomSejour_1, s0_.DescriptionCourte AS DescriptionCourte_2, s0_.Ville AS Ville_3, s0_.CP AS CP_4, s0_.DescriptionLongue AS DescriptionLongue_5, s0_.DescriptionRegion AS DescriptionRegion_6, s0_.ConseilsVisites AS ConseilsVisites_7, s0_.DureeSejour AS DureeSejour_8, s0_.NbreJour AS NbreJour_9, s0_.NbreNuit AS NbreNuit_10, s0_.motCle AS motCle_11, s0_.EstCoupDeCoeur AS EstCoupDeCoeur_12, s0_.RangCoupDeCoeur AS RangCoupDeCoeur_13, s0_.EstNouveaute AS EstNouveaute_14, s0_.ImageMiseEnAvant AS ImageMiseEnAvant_15, s0_.TarifSejour AS TarifSejour_16, s0_.NoteGenerale AS NoteGenerale_17, s0_.EstVisible AS EstVisible_18, s0_.DateCreation AS DateCreation_19, s0_.DateModification AS DateModification_20, s0_.IDRegion AS IDRegion_21, s0_.IDTheme AS IDTheme_22, s0_.IDCategorieOffre AS IDCategorieOffre_23, s0_.IDHebergement AS IDHebergement_24, s0_.IDTypeFormule AS IDTypeFormule_25, s0_.IDTypePrestation AS IDTypePrestation_26, s0_.IDTypeEtatsejour AS IDTypeEtatsejour_27, s0_.IDTypeLogement AS IDTypeLogement_28 FROM Sejour s0_ LEFT JOIN Avis a1_ ON s0_.IDSejour = a1_.IDSejour WHERE s0_.EstVisible = ? GROUP BY s0_.IDSejour, s0_.NomSejour, s0_.DescriptionCourte, s0_.Ville, s0_.CP, s0_.DescriptionLongue, s0_.DescriptionRegion, s0_.ConseilsVisites, s0_.DureeSejour, s0_.NbreJour, s0_.NbreNuit, s0_.motCle, s0_.EstCoupDeCoeur, s0_.RangCoupDeCoeur, s0_.EstNouveaute, s0_.ImageMiseEnAvant, s0_.TarifSejour, s0_.NoteGenerale, s0_.EstVisible, s0_.DateCreation, s0_.DateModification, s0_.IDRegion, s0_.IDTheme, s0_.IDCategorieOffre, s0_.IDHebergement, s0_.IDTypeFormule, s0_.IDTypePrestation, s0_.IDTypeEtatsejour, s0_.IDTypeLogement ORDER BY s0_.NomSejour ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.IDSejour AS IDSejour_0,
  s0_.NomSejour AS NomSejour_1,
  s0_.DescriptionCourte AS DescriptionCourte_2,
  s0_.Ville AS Ville_3,
  s0_.CP AS CP_4,
  s0_.DescriptionLongue AS DescriptionLongue_5,
  s0_.DescriptionRegion AS DescriptionRegion_6,
  s0_.ConseilsVisites AS ConseilsVisites_7,
  s0_.DureeSejour AS DureeSejour_8,
  s0_.NbreJour AS NbreJour_9,
  s0_.NbreNuit AS NbreNuit_10,
  s0_.motCle AS motCle_11,
  s0_.EstCoupDeCoeur AS EstCoupDeCoeur_12,
  s0_.RangCoupDeCoeur AS RangCoupDeCoeur_13,
  s0_.EstNouveaute AS EstNouveaute_14,
  s0_.ImageMiseEnAvant AS ImageMiseEnAvant_15,
  s0_.TarifSejour AS TarifSejour_16,
  s0_.NoteGenerale AS NoteGenerale_17,
  s0_.EstVisible AS EstVisible_18,
  s0_.DateCreation AS DateCreation_19,
  s0_.DateModification AS DateModification_20,
  s0_.IDRegion AS IDRegion_21,
  s0_.IDTheme AS IDTheme_22,
  s0_.IDCategorieOffre AS IDCategorieOffre_23,
  s0_.IDHebergement AS IDHebergement_24,
  s0_.IDTypeFormule AS IDTypeFormule_25,
  s0_.IDTypePrestation AS IDTypePrestation_26,
  s0_.IDTypeEtatsejour AS IDTypeEtatsejour_27,
  s0_.IDTypeLogement AS IDTypeLogement_28
FROM
  Sejour s0_
  LEFT JOIN Avis a1_ ON s0_.IDSejour = a1_.IDSejour
WHERE
  s0_.EstVisible = ?
GROUP BY
  s0_.IDSejour,
  s0_.NomSejour,
  s0_.DescriptionCourte,
  s0_.Ville,
  s0_.CP,
  s0_.DescriptionLongue,
  s0_.DescriptionRegion,
  s0_.ConseilsVisites,
  s0_.DureeSejour,
  s0_.NbreJour,
  s0_.NbreNuit,
  s0_.motCle,
  s0_.EstCoupDeCoeur,
  s0_.RangCoupDeCoeur,
  s0_.EstNouveaute,
  s0_.ImageMiseEnAvant,
  s0_.TarifSejour,
  s0_.NoteGenerale,
  s0_.EstVisible,
  s0_.DateCreation,
  s0_.DateModification,
  s0_.IDRegion,
  s0_.IDTheme,
  s0_.IDCategorieOffre,
  s0_.IDHebergement,
  s0_.IDTypeFormule,
  s0_.IDTypePrestation,
  s0_.IDTypeEtatsejour,
  s0_.IDTypeLogement
ORDER BY
  s0_.NomSejour ASC

SELECT s0_.IDSejour AS IDSejour_0, s0_.NomSejour AS NomSejour_1, s0_.DescriptionCourte AS DescriptionCourte_2, s0_.Ville AS Ville_3, s0_.CP AS CP_4, s0_.DescriptionLongue AS DescriptionLongue_5, s0_.DescriptionRegion AS DescriptionRegion_6, s0_.ConseilsVisites AS ConseilsVisites_7, s0_.DureeSejour AS DureeSejour_8, s0_.NbreJour AS NbreJour_9, s0_.NbreNuit AS NbreNuit_10, s0_.motCle AS motCle_11, s0_.EstCoupDeCoeur AS EstCoupDeCoeur_12, s0_.RangCoupDeCoeur AS RangCoupDeCoeur_13, s0_.EstNouveaute AS EstNouveaute_14, s0_.ImageMiseEnAvant AS ImageMiseEnAvant_15, s0_.TarifSejour AS TarifSejour_16, s0_.NoteGenerale AS NoteGenerale_17, s0_.EstVisible AS EstVisible_18, s0_.DateCreation AS DateCreation_19, s0_.DateModification AS DateModification_20, s0_.IDRegion AS IDRegion_21, s0_.IDTheme AS IDTheme_22, s0_.IDCategorieOffre AS IDCategorieOffre_23, s0_.IDHebergement AS IDHebergement_24, s0_.IDTypeFormule AS IDTypeFormule_25, s0_.IDTypePrestation AS IDTypePrestation_26, s0_.IDTypeEtatsejour AS IDTypeEtatsejour_27, s0_.IDTypeLogement AS IDTypeLogement_28 FROM Sejour s0_ LEFT JOIN Avis a1_ ON s0_.IDSejour = a1_.IDSejour WHERE s0_.EstVisible = 1 GROUP BY s0_.IDSejour, s0_.NomSejour, s0_.DescriptionCourte, s0_.Ville, s0_.CP, s0_.DescriptionLongue, s0_.DescriptionRegion, s0_.ConseilsVisites, s0_.DureeSejour, s0_.NbreJour, s0_.NbreNuit, s0_.motCle, s0_.EstCoupDeCoeur, s0_.RangCoupDeCoeur, s0_.EstNouveaute, s0_.ImageMiseEnAvant, s0_.TarifSejour, s0_.NoteGenerale, s0_.EstVisible, s0_.DateCreation, s0_.DateModification, s0_.IDRegion, s0_.IDTheme, s0_.IDCategorieOffre, s0_.IDHebergement, s0_.IDTypeFormule, s0_.IDTypePrestation, s0_.IDTypeEtatsejour, s0_.IDTypeLogement ORDER BY s0_.NomSejour ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Controller\Sejour2pour1Controller->index (line 69)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

1.52 ms
(19.02%)

SELECT t0.IDDateSejour AS IDDateSejour_1, t0.DatDebut AS DatDebut_2, t0.DatDepart AS DatDepart_3, t0.CoutNuitee AS CoutNuitee_4, t0.DureeSejour AS DureeSejour_5, t0.CoutSejour AS CoutSejour_6, t0.IDSejour AS IDSejour_7 FROM DateSejour t0 WHERE t0.IDSejour = ? ORDER BY t0.DatDebut DESC

Parameters:

[
  28
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDDateSejour AS IDDateSejour_1,
  t0.DatDebut AS DatDebut_2,
  t0.DatDepart AS DatDepart_3,
  t0.CoutNuitee AS CoutNuitee_4,
  t0.DureeSejour AS DureeSejour_5,
  t0.CoutSejour AS CoutSejour_6,
  t0.IDSejour AS IDSejour_7
FROM
  DateSejour t0
WHERE
  t0.IDSejour = ?
ORDER BY
  t0.DatDebut DESC

SELECT t0.IDDateSejour AS IDDateSejour_1, t0.DatDebut AS DatDebut_2, t0.DatDepart AS DatDepart_3, t0.CoutNuitee AS CoutNuitee_4, t0.DureeSejour AS DureeSejour_5, t0.CoutSejour AS CoutSejour_6, t0.IDSejour AS IDSejour_7 FROM DateSejour t0 WHERE t0.IDSejour = 28 ORDER BY t0.DatDebut DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Entity\Sejour->getTarifmin (line 179)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_77fd1c198309d7a95539a2c2e832b810::block_body (line 686)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_52b91791cf6aaf3de23e7cf3e8d096f4->doDisplay (line 572)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_77fd1c198309d7a95539a2c2e832b810->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
22	App\Controller\Sejour2pour1Controller->index (line 90)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 197)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.84 ms
(10.51%)

SELECT t0.IDAvis AS IDAvis_1, t0.LibelleAvis AS LibelleAvis_2, t0.DateAvis AS DateAvis_3, t0.Commentaire AS Commentaire_4, t0.note AS note_5, t0.EstActif AS EstActif_6, t0.IDSejour AS IDSejour_7, t0.id AS id_8, t0.IDDateSejour AS IDDateSejour_9 FROM Avis t0 WHERE t0.EstActif = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDAvis AS IDAvis_1,
  t0.LibelleAvis AS LibelleAvis_2,
  t0.DateAvis AS DateAvis_3,
  t0.Commentaire AS Commentaire_4,
  t0.note AS note_5,
  t0.EstActif AS EstActif_6,
  t0.IDSejour AS IDSejour_7,
  t0.id AS id_8,
  t0.IDDateSejour AS IDDateSejour_9
FROM
  Avis t0
WHERE
  t0.EstActif = ?

SELECT t0.IDAvis AS IDAvis_1, t0.LibelleAvis AS LibelleAvis_2, t0.DateAvis AS DateAvis_3, t0.Commentaire AS Commentaire_4, t0.note AS note_5, t0.EstActif AS EstActif_6, t0.IDSejour AS IDSejour_7, t0.id AS id_8, t0.IDDateSejour AS IDDateSejour_9 FROM Avis t0 WHERE t0.EstActif = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Service\AvisTwigService->getAvis (line 23)
4	Twig\Extension\CoreExtension->getAttribute (line 1913)
5	__TwigTemplate_f25a98a53b993fac172a4d6eb5bd096d::doDisplay (line 60)
6	Twig\Template->yield (line 402)
7	__TwigTemplate_77fd1c198309d7a95539a2c2e832b810->block_body (line 756)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_52b91791cf6aaf3de23e7cf3e8d096f4->doDisplay (line 572)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_77fd1c198309d7a95539a2c2e832b810->doDisplay (line 55)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
20	App\Controller\Sejour2pour1Controller->index (line 90)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 197)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.50 ms
(6.21%)

SELECT t0.IDSejour AS IDSejour_1, t0.NomSejour AS NomSejour_2, t0.DescriptionCourte AS DescriptionCourte_3, t0.Ville AS Ville_4, t0.CP AS CP_5, t0.DescriptionLongue AS DescriptionLongue_6, t0.DescriptionRegion AS DescriptionRegion_7, t0.ConseilsVisites AS ConseilsVisites_8, t0.DureeSejour AS DureeSejour_9, t0.NbreJour AS NbreJour_10, t0.NbreNuit AS NbreNuit_11, t0.motCle AS motCle_12, t0.EstCoupDeCoeur AS EstCoupDeCoeur_13, t0.RangCoupDeCoeur AS RangCoupDeCoeur_14, t0.EstNouveaute AS EstNouveaute_15, t0.ImageMiseEnAvant AS ImageMiseEnAvant_16, t0.TarifSejour AS TarifSejour_17, t0.NoteGenerale AS NoteGenerale_18, t0.EstVisible AS EstVisible_19, t0.DateCreation AS DateCreation_20, t0.DateModification AS DateModification_21, t0.IDRegion AS IDRegion_22, t0.IDTheme AS IDTheme_23, t0.IDCategorieOffre AS IDCategorieOffre_24, t0.IDHebergement AS IDHebergement_25, t0.IDTypeFormule AS IDTypeFormule_26, t0.IDTypePrestation AS IDTypePrestation_27, t0.IDTypeEtatsejour AS IDTypeEtatsejour_28, t0.IDTypeLogement AS IDTypeLogement_29 FROM Sejour t0 WHERE t0.EstVisible = ? ORDER BY t0.NomSejour ASC LIMIT 12

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDSejour AS IDSejour_1,
  t0.NomSejour AS NomSejour_2,
  t0.DescriptionCourte AS DescriptionCourte_3,
  t0.Ville AS Ville_4,
  t0.CP AS CP_5,
  t0.DescriptionLongue AS DescriptionLongue_6,
  t0.DescriptionRegion AS DescriptionRegion_7,
  t0.ConseilsVisites AS ConseilsVisites_8,
  t0.DureeSejour AS DureeSejour_9,
  t0.NbreJour AS NbreJour_10,
  t0.NbreNuit AS NbreNuit_11,
  t0.motCle AS motCle_12,
  t0.EstCoupDeCoeur AS EstCoupDeCoeur_13,
  t0.RangCoupDeCoeur AS RangCoupDeCoeur_14,
  t0.EstNouveaute AS EstNouveaute_15,
  t0.ImageMiseEnAvant AS ImageMiseEnAvant_16,
  t0.TarifSejour AS TarifSejour_17,
  t0.NoteGenerale AS NoteGenerale_18,
  t0.EstVisible AS EstVisible_19,
  t0.DateCreation AS DateCreation_20,
  t0.DateModification AS DateModification_21,
  t0.IDRegion AS IDRegion_22,
  t0.IDTheme AS IDTheme_23,
  t0.IDCategorieOffre AS IDCategorieOffre_24,
  t0.IDHebergement AS IDHebergement_25,
  t0.IDTypeFormule AS IDTypeFormule_26,
  t0.IDTypePrestation AS IDTypePrestation_27,
  t0.IDTypeEtatsejour AS IDTypeEtatsejour_28,
  t0.IDTypeLogement AS IDTypeLogement_29
FROM
  Sejour t0
WHERE
  t0.EstVisible = ?
ORDER BY
  t0.NomSejour ASC
LIMIT
  12

SELECT t0.IDSejour AS IDSejour_1, t0.NomSejour AS NomSejour_2, t0.DescriptionCourte AS DescriptionCourte_3, t0.Ville AS Ville_4, t0.CP AS CP_5, t0.DescriptionLongue AS DescriptionLongue_6, t0.DescriptionRegion AS DescriptionRegion_7, t0.ConseilsVisites AS ConseilsVisites_8, t0.DureeSejour AS DureeSejour_9, t0.NbreJour AS NbreJour_10, t0.NbreNuit AS NbreNuit_11, t0.motCle AS motCle_12, t0.EstCoupDeCoeur AS EstCoupDeCoeur_13, t0.RangCoupDeCoeur AS RangCoupDeCoeur_14, t0.EstNouveaute AS EstNouveaute_15, t0.ImageMiseEnAvant AS ImageMiseEnAvant_16, t0.TarifSejour AS TarifSejour_17, t0.NoteGenerale AS NoteGenerale_18, t0.EstVisible AS EstVisible_19, t0.DateCreation AS DateCreation_20, t0.DateModification AS DateModification_21, t0.IDRegion AS IDRegion_22, t0.IDTheme AS IDTheme_23, t0.IDCategorieOffre AS IDCategorieOffre_24, t0.IDHebergement AS IDHebergement_25, t0.IDTypeFormule AS IDTypeFormule_26, t0.IDTypePrestation AS IDTypePrestation_27, t0.IDTypeEtatsejour AS IDTypeEtatsejour_28, t0.IDTypeLogement AS IDTypeLogement_29 FROM Sejour t0 WHERE t0.EstVisible = 1 ORDER BY t0.NomSejour ASC LIMIT 12;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Controller\Sejour2pour1Controller->index (line 30)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 197)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.37 ms
(4.68%)

SELECT t0.IDTypeLogement AS IDTypeLogement_1, t0.LibelleTypeLogement AS LibelleTypeLogement_2 FROM TypeLogement t0 WHERE t0.IDTypeLogement = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDTypeLogement AS IDTypeLogement_1,
  t0.LibelleTypeLogement AS LibelleTypeLogement_2
FROM
  TypeLogement t0
WHERE
  t0.IDTypeLogement = ?

SELECT t0.IDTypeLogement AS IDTypeLogement_1, t0.LibelleTypeLogement AS LibelleTypeLogement_2 FROM TypeLogement t0 WHERE t0.IDTypeLogement = '1';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Typelogement::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Typelogement->__get (line 184)
7	App\Entity\Typelogement->getLibelletypelogement (line 31)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_77fd1c198309d7a95539a2c2e832b810::block_body (line 612)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_52b91791cf6aaf3de23e7cf3e8d096f4->doDisplay (line 572)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_77fd1c198309d7a95539a2c2e832b810->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
22	App\Controller\Sejour2pour1Controller->index (line 90)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 197)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.31 ms
(3.85%)

SELECT t0.IDTypeFormule AS IDTypeFormule_1, t0.NomTypeFormule AS NomTypeFormule_2, t0.CouleurEtiquette AS CouleurEtiquette_3, t0.EstActif AS EstActif_4 FROM Catalogue t0 WHERE t0.IDTypeFormule = ?

Parameters:

[
  "9"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDTypeFormule AS IDTypeFormule_1,
  t0.NomTypeFormule AS NomTypeFormule_2,
  t0.CouleurEtiquette AS CouleurEtiquette_3,
  t0.EstActif AS EstActif_4
FROM
  Catalogue t0
WHERE
  t0.IDTypeFormule = ?

SELECT t0.IDTypeFormule AS IDTypeFormule_1, t0.NomTypeFormule AS NomTypeFormule_2, t0.CouleurEtiquette AS CouleurEtiquette_3, t0.EstActif AS EstActif_4 FROM Catalogue t0 WHERE t0.IDTypeFormule = '9';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Catalogue::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Catalogue->__get (line 184)
7	App\Entity\Catalogue->getCouleuretiquette (line 61)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_77fd1c198309d7a95539a2c2e832b810::block_body (line 564)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_52b91791cf6aaf3de23e7cf3e8d096f4->doDisplay (line 572)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_77fd1c198309d7a95539a2c2e832b810->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
22	App\Controller\Sejour2pour1Controller->index (line 90)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 197)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.24 ms
(3.00%)

SELECT t0.IDBanner AS IDBanner_1, t0.ImageBanner AS ImageBanner_2, t0.TitreBanner AS TitreBanner_3, t0.SoustitreBanner AS SoustitreBanner_4, t0.Libelle AS Libelle_5, t0.AltImageBanner AS AltImageBanner_6 FROM Banner t0 WHERE t0.Libelle = ? LIMIT 1

Parameters:

[
  "sejour2pour1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDBanner AS IDBanner_1,
  t0.ImageBanner AS ImageBanner_2,
  t0.TitreBanner AS TitreBanner_3,
  t0.SoustitreBanner AS SoustitreBanner_4,
  t0.Libelle AS Libelle_5,
  t0.AltImageBanner AS AltImageBanner_6
FROM
  Banner t0
WHERE
  t0.Libelle = ?
LIMIT
  1

SELECT t0.IDBanner AS IDBanner_1, t0.ImageBanner AS ImageBanner_2, t0.TitreBanner AS TitreBanner_3, t0.SoustitreBanner AS SoustitreBanner_4, t0.Libelle AS Libelle_5, t0.AltImageBanner AS AltImageBanner_6 FROM Banner t0 WHERE t0.Libelle = 'sejour2pour1' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Controller\Sejour2pour1Controller->index (line 39)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 197)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.24 ms
(2.97%)

SELECT t0.IDTypePrestation AS IDTypePrestation_1, t0.LibellePrestation AS LibellePrestation_2 FROM TypePrestation t0 WHERE t0.IDTypePrestation = ?

Parameters:

[
  "2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDTypePrestation AS IDTypePrestation_1,
  t0.LibellePrestation AS LibellePrestation_2
FROM
  TypePrestation t0
WHERE
  t0.IDTypePrestation = ?

SELECT t0.IDTypePrestation AS IDTypePrestation_1, t0.LibellePrestation AS LibellePrestation_2 FROM TypePrestation t0 WHERE t0.IDTypePrestation = '2';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Typeprestation::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Typeprestation->__get (line 184)
7	App\Entity\Typeprestation->getLibelleprestation (line 31)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_77fd1c198309d7a95539a2c2e832b810::block_body (line 652)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_52b91791cf6aaf3de23e7cf3e8d096f4->doDisplay (line 572)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_77fd1c198309d7a95539a2c2e832b810->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
22	App\Controller\Sejour2pour1Controller->index (line 90)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 197)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.22 ms
(2.78%)

SELECT t0.IDRegion AS IDRegion_1, t0.LibelleRegion AS LibelleRegion_2, t0.AncienNom AS AncienNom_3 FROM Region t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDRegion AS IDRegion_1,
  t0.LibelleRegion AS LibelleRegion_2,
  t0.AncienNom AS AncienNom_3
FROM
  Region t0

SELECT t0.IDRegion AS IDRegion_1, t0.LibelleRegion AS LibelleRegion_2, t0.AncienNom AS AncienNom_3 FROM Region t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\ORM\EntityRepository->findAll (line 96)
4	App\Controller\Sejour2pour1Controller->index (line 27)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.18 ms
(2.31%)

SELECT t0.IDCategorieOffre AS IDCategorieOffre_1, t0.LibelleCategorieOffre AS LibelleCategorieOffre_2, t0.CouleurEtiquette AS CouleurEtiquette_3, t0.Commentaire AS Commentaire_4 FROM CategorieOffre t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDCategorieOffre AS IDCategorieOffre_1,
  t0.LibelleCategorieOffre AS LibelleCategorieOffre_2,
  t0.CouleurEtiquette AS CouleurEtiquette_3,
  t0.Commentaire AS Commentaire_4
FROM
  CategorieOffre t0

SELECT t0.IDCategorieOffre AS IDCategorieOffre_1, t0.LibelleCategorieOffre AS LibelleCategorieOffre_2, t0.CouleurEtiquette AS CouleurEtiquette_3, t0.Commentaire AS Commentaire_4 FROM CategorieOffre t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\ORM\EntityRepository->findAll (line 96)
4	App\Controller\Sejour2pour1Controller->index (line 28)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	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\Datesejour	212
App\Entity\Sejour	68
App\Entity\Hebergement	68
App\Entity\Region	14
App\Entity\Typelogement	6
App\Entity\Catalogue	5
App\Entity\Categorieoffre	3
App\Entity\Theme	3
App\Entity\Typeprestation	2
App\Entity\Banner	1

Entities Mapping

Class	Mapping errors
App\Entity\Region	No errors.
App\Entity\Categorieoffre	No errors.
App\Entity\Sejour	The field App\Entity\Sejour#galeries is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Galeriesejour#idsejour does not contain the required 'inversedBy: "galeries"' attribute. The field App\Entity\Sejour#reservations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Reservation#idsejour does not contain the required 'inversedBy: "reservations"' attribute. The field App\Entity\Sejour#blogs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Blog#idsejour does not contain the required 'inversedBy: "blogs"' attribute.
App\Entity\Theme	The field App\Entity\Theme#sejours is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sejour#idtheme does not contain the required 'inversedBy: "sejours"' attribute.
App\Entity\Hebergement	The field App\Entity\Hebergement#sejours is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sejour#idhebergement does not contain the required 'inversedBy: "sejours"' attribute.
App\Entity\Catalogue	No errors.
App\Entity\Typeprestation	No errors.
App\Entity\Typeetatsejour	No errors.
App\Entity\Typelogement	No errors.
App\Entity\Avis	No errors.
App\Entity\Datesejour	The field App\Entity\Datesejour#paniers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PanierSejour#iddatesejour does not contain the required 'inversedBy: "paniers"' attribute. The field App\Entity\Datesejour#avis is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Avis#iddatesejour does not contain the required 'inversedBy: "avis"' attribute.
App\Entity\Galeriesejour	No errors.
App\Entity\Reservation	The field App\Entity\Reservation#factures is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Facture#idreservation does not contain the required 'inversedBy: "factures"' attribute. The field App\Entity\Reservation#paiements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Paiement#idreservation does not contain the required 'inversedBy: "paiements"' attribute.
App\Entity\Blog	No errors.
App\Entity\Banner	No errors.
App\Entity\PanierSejour	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://www.arcanciane.fr/sejour2pour1?page=4

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping