Symfony Profiler

Query Metrics

31 Database Queries

16 Different statements

11.45 ms Query time

5 Invalid entities

46 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.51 ms
(13.20%)

SELECT count(DISTINCT s0_.IDSejour) AS sclr_0 FROM Sejour s0_ WHERE s0_.EstVisible = ? AND s0_.IDTheme = ?

Parameters:

[
  1
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT s0_.IDSejour) AS sclr_0
FROM
  Sejour s0_
WHERE
  s0_.EstVisible = ?
  AND s0_.IDTheme = ?

SELECT count(DISTINCT s0_.IDSejour) AS sclr_0 FROM Sejour s0_ WHERE s0_.EstVisible = 1 AND s0_.IDTheme = '1';

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerLFAs10p\PaginatorProxy9cc2a8f->paginate (line 25)
15	App\Controller\SejourparthemeController->index (line 50)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 208)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

1.16 ms
(10.18%)

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.Metatitle AS Metatitle_19, t0.Metadescription AS Metadescription_20, t0.Metakeywords AS Metakeywords_21, t0.lienaafficher AS lienaafficher_22, t0.EstVisible AS EstVisible_23, t0.DateCreation AS DateCreation_24, t0.DateModification AS DateModification_25, t0.IDRegion AS IDRegion_26, t0.IDTheme AS IDTheme_27, t0.IDCategorieOffre AS IDCategorieOffre_28, t0.IDHebergement AS IDHebergement_29, t0.IDTypeFormule AS IDTypeFormule_30, t0.IDTypePrestation AS IDTypePrestation_31, t0.IDTypeEtatsejour AS IDTypeEtatsejour_32, t0.IDTypeLogement AS IDTypeLogement_33 FROM Sejour t0 WHERE t0.IDTheme = ?

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.Metatitle AS Metatitle_19,
  t0.Metadescription AS Metadescription_20,
  t0.Metakeywords AS Metakeywords_21,
  t0.lienaafficher AS lienaafficher_22,
  t0.EstVisible AS EstVisible_23,
  t0.DateCreation AS DateCreation_24,
  t0.DateModification AS DateModification_25,
  t0.IDRegion AS IDRegion_26,
  t0.IDTheme AS IDTheme_27,
  t0.IDCategorieOffre AS IDCategorieOffre_28,
  t0.IDHebergement AS IDHebergement_29,
  t0.IDTypeFormule AS IDTypeFormule_30,
  t0.IDTypePrestation AS IDTypePrestation_31,
  t0.IDTypeEtatsejour AS IDTypeEtatsejour_32,
  t0.IDTypeLogement AS IDTypeLogement_33
FROM
  Sejour t0
WHERE
  t0.IDTheme = ?

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.Metatitle AS Metatitle_19, t0.Metadescription AS Metadescription_20, t0.Metakeywords AS Metakeywords_21, t0.lienaafficher AS lienaafficher_22, t0.EstVisible AS EstVisible_23, t0.DateCreation AS DateCreation_24, t0.DateModification AS DateModification_25, t0.IDRegion AS IDRegion_26, t0.IDTheme AS IDTheme_27, t0.IDCategorieOffre AS IDCategorieOffre_28, t0.IDHebergement AS IDHebergement_29, t0.IDTypeFormule AS IDTypeFormule_30, t0.IDTypePrestation AS IDTypePrestation_31, t0.IDTypeEtatsejour AS IDTypeEtatsejour_32, t0.IDTypeLogement AS IDTypeLogement_33 FROM Sejour t0 WHERE t0.IDTheme = 1;

#	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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f::{closure} (line 176)
10	array_filter (line 1976)
11	Twig\Extension\CoreExtension::filter (line 1976)
12	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f::block_body (line 176)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_5bab8f5296afed25c0fb3a6aacace00d->doDisplay (line 575)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f->doDisplay (line 55)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
25	App\Controller\SejourparthemeController->index (line 61)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 208)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 29)
31	require_once (line 5)

0.97 ms
(8.47%)

SELECT DISTINCT s0_.IDSejour AS IDSejour_0, s0_.NomSejour AS NomSejour_1 FROM Sejour s0_ WHERE s0_.EstVisible = ? AND s0_.IDTheme = ? ORDER BY s0_.NomSejour ASC LIMIT 12

Parameters:

[
  1
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT s0_.IDSejour AS IDSejour_0,
  s0_.NomSejour AS NomSejour_1
FROM
  Sejour s0_
WHERE
  s0_.EstVisible = ?
  AND s0_.IDTheme = ?
ORDER BY
  s0_.NomSejour ASC
LIMIT
  12

SELECT DISTINCT s0_.IDSejour AS IDSejour_0, s0_.NomSejour AS NomSejour_1 FROM Sejour s0_ WHERE s0_.EstVisible = 1 AND s0_.IDTheme = '1' ORDER BY s0_.NomSejour ASC LIMIT 12;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerLFAs10p\PaginatorProxy9cc2a8f->paginate (line 25)
15	App\Controller\SejourparthemeController->index (line 50)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 208)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.96 ms
(8.43%)

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:

[
  3
]

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 = 3 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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\Sejour->getTarifmin (line 193)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f::block_body (line 562)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_5bab8f5296afed25c0fb3a6aacace00d->doDisplay (line 575)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f->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 452)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
22	App\Controller\SejourparthemeController->index (line 61)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.77 ms
(6.72%)

SELECT t0.IDTheme AS IDTheme_1, t0.LibelleTheme AS LibelleTheme_2, t0.Commentaire AS Commentaire_3, t0.ImageFond AS ImageFond_4, t0.IconeTheme AS IconeTheme_5, t0.couleurTheme AS couleurTheme_6 FROM Theme t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDTheme AS IDTheme_1,
  t0.LibelleTheme AS LibelleTheme_2,
  t0.Commentaire AS Commentaire_3,
  t0.ImageFond AS ImageFond_4,
  t0.IconeTheme AS IconeTheme_5,
  t0.couleurTheme AS couleurTheme_6
FROM
  Theme t0

SELECT t0.IDTheme AS IDTheme_1, t0.LibelleTheme AS LibelleTheme_2, t0.Commentaire AS Commentaire_3, t0.ImageFond AS ImageFond_4, t0.IconeTheme AS IconeTheme_5, t0.couleurTheme AS couleurTheme_6 FROM Theme 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\SejourparthemeController->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 208)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.71 ms
(6.23%)

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_.Metatitle AS Metatitle_18, s0_.Metadescription AS Metadescription_19, s0_.Metakeywords AS Metakeywords_20, s0_.lienaafficher AS lienaafficher_21, s0_.EstVisible AS EstVisible_22, s0_.DateCreation AS DateCreation_23, s0_.DateModification AS DateModification_24, s0_.IDRegion AS IDRegion_25, s0_.IDTheme AS IDTheme_26, s0_.IDCategorieOffre AS IDCategorieOffre_27, s0_.IDHebergement AS IDHebergement_28, s0_.IDTypeFormule AS IDTypeFormule_29, s0_.IDTypePrestation AS IDTypePrestation_30, s0_.IDTypeEtatsejour AS IDTypeEtatsejour_31, s0_.IDTypeLogement AS IDTypeLogement_32 FROM Sejour s0_ WHERE s0_.EstVisible = ? AND s0_.IDTheme = ? AND s0_.IDSejour IN (?, ?) ORDER BY s0_.NomSejour ASC

Parameters:

[
  1
  "4"
  "2"
  "16"
]

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_.Metatitle AS Metatitle_18,
  s0_.Metadescription AS Metadescription_19,
  s0_.Metakeywords AS Metakeywords_20,
  s0_.lienaafficher AS lienaafficher_21,
  s0_.EstVisible AS EstVisible_22,
  s0_.DateCreation AS DateCreation_23,
  s0_.DateModification AS DateModification_24,
  s0_.IDRegion AS IDRegion_25,
  s0_.IDTheme AS IDTheme_26,
  s0_.IDCategorieOffre AS IDCategorieOffre_27,
  s0_.IDHebergement AS IDHebergement_28,
  s0_.IDTypeFormule AS IDTypeFormule_29,
  s0_.IDTypePrestation AS IDTypePrestation_30,
  s0_.IDTypeEtatsejour AS IDTypeEtatsejour_31,
  s0_.IDTypeLogement AS IDTypeLogement_32
FROM
  Sejour s0_
WHERE
  s0_.EstVisible = ?
  AND s0_.IDTheme = ?
  AND s0_.IDSejour IN (?, ?)
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_.Metatitle AS Metatitle_18, s0_.Metadescription AS Metadescription_19, s0_.Metakeywords AS Metakeywords_20, s0_.lienaafficher AS lienaafficher_21, s0_.EstVisible AS EstVisible_22, s0_.DateCreation AS DateCreation_23, s0_.DateModification AS DateModification_24, s0_.IDRegion AS IDRegion_25, s0_.IDTheme AS IDTheme_26, s0_.IDCategorieOffre AS IDCategorieOffre_27, s0_.IDHebergement AS IDHebergement_28, s0_.IDTypeFormule AS IDTypeFormule_29, s0_.IDTypePrestation AS IDTypePrestation_30, s0_.IDTypeEtatsejour AS IDTypeEtatsejour_31, s0_.IDTypeLogement AS IDTypeLogement_32 FROM Sejour s0_ WHERE s0_.EstVisible = 1 AND s0_.IDTheme = '4' AND s0_.IDSejour IN ('2', '16') 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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerLFAs10p\PaginatorProxy9cc2a8f->paginate (line 25)
15	App\Controller\SejourparthemeController->index (line 50)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 208)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.69 ms
(6.05%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.EstActif AS EstActif_6, t0.EstDecouverte AS EstDecouverte_7, t0.nomuser AS nomuser_8, t0.photo AS photo_9, t0.Hidden AS Hidden_10, t0.IDTypeUtilisateur AS IDTypeUtilisateur_11, t0.IDDistributeur AS IDDistributeur_12, t0.IDClient AS IDClient_13, t0.IDAdherent AS IDAdherent_14 FROM user t0 WHERE t0.id = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.EstActif AS EstActif_6,
  t0.EstDecouverte AS EstDecouverte_7,
  t0.nomuser AS nomuser_8,
  t0.photo AS photo_9,
  t0.Hidden AS Hidden_10,
  t0.IDTypeUtilisateur AS IDTypeUtilisateur_11,
  t0.IDDistributeur AS IDDistributeur_12,
  t0.IDClient AS IDClient_13,
  t0.IDAdherent AS IDAdherent_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.EstActif AS EstActif_6, t0.EstDecouverte AS EstDecouverte_7, t0.nomuser AS nomuser_8, t0.photo AS photo_9, t0.Hidden AS Hidden_10, t0.IDTypeUtilisateur AS IDTypeUtilisateur_11, t0.IDDistributeur AS IDDistributeur_12, t0.IDClient AS IDClient_13, t0.IDAdherent AS IDAdherent_14 FROM user t0 WHERE t0.id = 13;

#	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 295)
4	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\User->__get (line 184)
7	App\Entity\User->getIdadherent (line 283)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_eed092d2c5a6e4f0baf841b0ba9d48a3::doDisplay (line 88)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f->block_body (line 614)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_5bab8f5296afed25c0fb3a6aacace00d->doDisplay (line 575)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f->doDisplay (line 55)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
24	App\Controller\SejourparthemeController->index (line 61)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 208)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.68 ms
(5.95%)

SELECT t0.IDAdherent AS IDAdherent_1, t0.NumAdherent AS NumAdherent_2, t0.NomAdherent AS NomAdherent_3, t0.PrenomAdherent AS PrenomAdherent_4, t0.DateNaiss AS DateNaiss_5, t0.Profession AS Profession_6, t0.Adresse AS Adresse_7, t0.Suite AS Suite_8, t0.CP AS CP_9, t0.Ville AS Ville_10, t0.TelDom AS TelDom_11, t0.TelBur AS TelBur_12, t0.Fax AS Fax_13, t0.Email AS Email_14, t0.Observation AS Observation_15, t0.EstActif AS EstActif_16, t0.GiftReservationCurrentYear AS GiftReservationCurrentYear_17, t0.isAdherent1 AS isAdherent1_18, t0.DateCreation AS DateCreation_19, t0.IDCivilite AS IDCivilite_20, t0.IDPays AS IDPays_21 FROM Adherent t0 WHERE t0.IDAdherent = ?

Parameters:

[
  "21"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDAdherent AS IDAdherent_1,
  t0.NumAdherent AS NumAdherent_2,
  t0.NomAdherent AS NomAdherent_3,
  t0.PrenomAdherent AS PrenomAdherent_4,
  t0.DateNaiss AS DateNaiss_5,
  t0.Profession AS Profession_6,
  t0.Adresse AS Adresse_7,
  t0.Suite AS Suite_8,
  t0.CP AS CP_9,
  t0.Ville AS Ville_10,
  t0.TelDom AS TelDom_11,
  t0.TelBur AS TelBur_12,
  t0.Fax AS Fax_13,
  t0.Email AS Email_14,
  t0.Observation AS Observation_15,
  t0.EstActif AS EstActif_16,
  t0.GiftReservationCurrentYear AS GiftReservationCurrentYear_17,
  t0.isAdherent1 AS isAdherent1_18,
  t0.DateCreation AS DateCreation_19,
  t0.IDCivilite AS IDCivilite_20,
  t0.IDPays AS IDPays_21
FROM
  Adherent t0
WHERE
  t0.IDAdherent = ?

SELECT t0.IDAdherent AS IDAdherent_1, t0.NumAdherent AS NumAdherent_2, t0.NomAdherent AS NomAdherent_3, t0.PrenomAdherent AS PrenomAdherent_4, t0.DateNaiss AS DateNaiss_5, t0.Profession AS Profession_6, t0.Adresse AS Adresse_7, t0.Suite AS Suite_8, t0.CP AS CP_9, t0.Ville AS Ville_10, t0.TelDom AS TelDom_11, t0.TelBur AS TelBur_12, t0.Fax AS Fax_13, t0.Email AS Email_14, t0.Observation AS Observation_15, t0.EstActif AS EstActif_16, t0.GiftReservationCurrentYear AS GiftReservationCurrentYear_17, t0.isAdherent1 AS isAdherent1_18, t0.DateCreation AS DateCreation_19, t0.IDCivilite AS IDCivilite_20, t0.IDPays AS IDPays_21 FROM Adherent t0 WHERE t0.IDAdherent = '21';

#	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 295)
4	Proxies\__CG__\App\Entity\Adherent::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Adherent->__get (line 184)
7	App\Entity\Adherent->getPrenomadherent (line 128)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_eed092d2c5a6e4f0baf841b0ba9d48a3::doDisplay (line 91)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f->block_body (line 614)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_5bab8f5296afed25c0fb3a6aacace00d->doDisplay (line 575)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f->doDisplay (line 55)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
24	App\Controller\SejourparthemeController->index (line 61)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 208)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.64 ms
(5.55%)

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

Parameters:

[
  "1"
]

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
WHERE
  t0.IDCategorieOffre = ?

SELECT t0.IDCategorieOffre AS IDCategorieOffre_1, t0.LibelleCategorieOffre AS LibelleCategorieOffre_2, t0.CouleurEtiquette AS CouleurEtiquette_3, t0.Commentaire AS Commentaire_4 FROM CategorieOffre t0 WHERE t0.IDCategorieOffre = '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 295)
4	Proxies\__CG__\App\Entity\Categorieoffre::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Categorieoffre->__get (line 184)
7	App\Entity\Categorieoffre->getCouleuretiquette (line 49)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f::block_body (line 467)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_5bab8f5296afed25c0fb3a6aacace00d->doDisplay (line 575)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f->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 452)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
22	App\Controller\SejourparthemeController->index (line 61)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.61 ms
(5.36%)

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:

[
  "14"
]

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

#	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 295)
4	Proxies\__CG__\App\Entity\Catalogue::Doctrine\ORM\Proxy\{closure} (line 373)
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 1919)
9	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f::block_body (line 431)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_5bab8f5296afed25c0fb3a6aacace00d->doDisplay (line 575)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f->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 452)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
22	App\Controller\SejourparthemeController->index (line 61)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.53 ms
(4.60%)

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

Parameters:

[
  "4"
]

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

#	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 295)
4	Proxies\__CG__\App\Entity\Typelogement::Doctrine\ORM\Proxy\{closure} (line 373)
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 1919)
9	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f::block_body (line 489)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_5bab8f5296afed25c0fb3a6aacace00d->doDisplay (line 575)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f->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 452)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
22	App\Controller\SejourparthemeController->index (line 61)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.51 ms
(4.44%)

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

Parameters:

[
  "11"
]

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
WHERE
  t0.IDRegion = ?

SELECT t0.IDRegion AS IDRegion_1, t0.LibelleRegion AS LibelleRegion_2, t0.AncienNom AS AncienNom_3 FROM Region t0 WHERE t0.IDRegion = '11';

#	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 295)
4	Proxies\__CG__\App\Entity\Region::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Region->__get (line 184)
7	App\Entity\Region->getLibelleregion (line 34)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f::block_body (line 546)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_5bab8f5296afed25c0fb3a6aacace00d->doDisplay (line 575)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f->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 452)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
22	App\Controller\SejourparthemeController->index (line 61)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.50 ms
(4.34%)

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_.Metatitle AS Metatitle_18, s0_.Metadescription AS Metadescription_19, s0_.Metakeywords AS Metakeywords_20, s0_.lienaafficher AS lienaafficher_21, s0_.EstVisible AS EstVisible_22, s0_.DateCreation AS DateCreation_23, s0_.DateModification AS DateModification_24, s0_.IDRegion AS IDRegion_25, s0_.IDTheme AS IDTheme_26, s0_.IDCategorieOffre AS IDCategorieOffre_27, s0_.IDHebergement AS IDHebergement_28, s0_.IDTypeFormule AS IDTypeFormule_29, s0_.IDTypePrestation AS IDTypePrestation_30, s0_.IDTypeEtatsejour AS IDTypeEtatsejour_31, s0_.IDTypeLogement AS IDTypeLogement_32 FROM Sejour s0_ WHERE s0_.EstVisible = ? AND s0_.IDTheme = ? AND s0_.IDSejour IN (?) ORDER BY s0_.NomSejour ASC

Parameters:

[
  1
  "1"
  "3"
]

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_.Metatitle AS Metatitle_18,
  s0_.Metadescription AS Metadescription_19,
  s0_.Metakeywords AS Metakeywords_20,
  s0_.lienaafficher AS lienaafficher_21,
  s0_.EstVisible AS EstVisible_22,
  s0_.DateCreation AS DateCreation_23,
  s0_.DateModification AS DateModification_24,
  s0_.IDRegion AS IDRegion_25,
  s0_.IDTheme AS IDTheme_26,
  s0_.IDCategorieOffre AS IDCategorieOffre_27,
  s0_.IDHebergement AS IDHebergement_28,
  s0_.IDTypeFormule AS IDTypeFormule_29,
  s0_.IDTypePrestation AS IDTypePrestation_30,
  s0_.IDTypeEtatsejour AS IDTypeEtatsejour_31,
  s0_.IDTypeLogement AS IDTypeLogement_32
FROM
  Sejour s0_
WHERE
  s0_.EstVisible = ?
  AND s0_.IDTheme = ?
  AND s0_.IDSejour IN (?)
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_.Metatitle AS Metatitle_18, s0_.Metadescription AS Metadescription_19, s0_.Metakeywords AS Metakeywords_20, s0_.lienaafficher AS lienaafficher_21, s0_.EstVisible AS EstVisible_22, s0_.DateCreation AS DateCreation_23, s0_.DateModification AS DateModification_24, s0_.IDRegion AS IDRegion_25, s0_.IDTheme AS IDTheme_26, s0_.IDCategorieOffre AS IDCategorieOffre_27, s0_.IDHebergement AS IDHebergement_28, s0_.IDTypeFormule AS IDTypeFormule_29, s0_.IDTypePrestation AS IDTypePrestation_30, s0_.IDTypeEtatsejour AS IDTypeEtatsejour_31, s0_.IDTypeLogement AS IDTypeLogement_32 FROM Sejour s0_ WHERE s0_.EstVisible = 1 AND s0_.IDTheme = '1' AND s0_.IDSejour IN ('3') 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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerLFAs10p\PaginatorProxy9cc2a8f->paginate (line 25)
15	App\Controller\SejourparthemeController->index (line 50)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 208)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.46 ms
(4.04%)

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

Parameters:

[
  "1"
]

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 = '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 295)
4	Proxies\__CG__\App\Entity\Typeprestation::Doctrine\ORM\Proxy\{closure} (line 373)
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 1919)
9	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f::block_body (line 526)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_5bab8f5296afed25c0fb3a6aacace00d->doDisplay (line 575)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f->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 452)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
22	App\Controller\SejourparthemeController->index (line 61)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.38 ms
(3.34%)

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:

[
  "sejourpartheme"
]

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 = 'sejourpartheme' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Controller\SejourparthemeController->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 208)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.35 ms
(3.08%)

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 1919)
5	__TwigTemplate_eed092d2c5a6e4f0baf841b0ba9d48a3::doDisplay (line 60)
6	Twig\Template->yield (line 402)
7	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f->block_body (line 614)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_5bab8f5296afed25c0fb3a6aacace00d->doDisplay (line 575)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_b688ed5bcb7de2c9d1eb208c1ed8e07f->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 452)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
20	App\Controller\SejourparthemeController->index (line 61)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 208)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	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	18
App\Entity\Theme	3
App\Entity\Sejour	3
App\Entity\Hebergement	3
App\Entity\Region	2
App\Entity\Categorieoffre	2
App\Entity\Catalogue	2
App\Entity\Typeprestation	2
App\Entity\Typelogement	2
App\Entity\Avis	2
App\Entity\User	2
App\Entity\Adherent	2
App\Entity\Banner	1
App\Entity\Civilite	1
App\Entity\Pays	1

Entities Mapping

Class	Mapping 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\Banner	No errors.
App\Entity\Region	No errors.
App\Entity\Categorieoffre	No errors.
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\PanierSejour	No errors.
App\Entity\User	No errors.
App\Entity\Typeutilisateur	No errors.
App\Entity\Distributeur	No errors.
App\Entity\Client	No errors.
App\Entity\Adherent	No errors.
App\Entity\Notification	No errors.
App\Entity\Civilite	No errors.
App\Entity\Pays	No errors.
App\Entity\ReservationOld	No errors.

Symfony Profiler

GET https://newarcanciane.devsoft-pro.com/sejourpartheme

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping