Symfony Profiler

Query Metrics

31 Database Queries

16 Different statements

18.51 ms Query time

5 Invalid entities

46 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.27 ms
(33.85%)

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\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 96)
4	Doctrine\ORM\EntityRepository->findAll (line 27)
5	App\Controller\SejourparthemeController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.71 ms
(9.26%)

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

1.36 ms
(7.33%)

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

1.23 ms
(6.67%)

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.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.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.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.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.IDTheme = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1848)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1793)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
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 1272)
9	Twig\Extension\CoreExtension::length (line 176)
10	__TwigTemplate_e7e8ec96605fb018f53553027f27b59b->{closure} (line 1)
11	array_filter (line 1966)
12	Twig\Extension\CoreExtension::filter (line 176)
13	__TwigTemplate_e7e8ec96605fb018f53553027f27b59b->block_body (line 446)
14	Twig\Template->yieldBlock (line 572)
15	__TwigTemplate_a89b8e977156382020d9ea0618e3e2f8->doDisplay (line 402)
16	Twig\Template->yield (line 55)
17	__TwigTemplate_e7e8ec96605fb018f53553027f27b59b->doDisplay (line 402)
18	Twig\Template->yield (line 358)
19	Twig\Template->display (line 373)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 333)
22	Twig\Environment->render (line 448)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
26	App\Controller\SejourparthemeController->index (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

1.16 ms
(6.24%)

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\DBAL\Connection->executeQuery (line 1848)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1793)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 179)
8	App\Entity\Sejour->getTarifmin (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 562)
10	__TwigTemplate_e7e8ec96605fb018f53553027f27b59b->block_body (line 446)
11	Twig\Template->yieldBlock (line 572)
12	__TwigTemplate_a89b8e977156382020d9ea0618e3e2f8->doDisplay (line 402)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_e7e8ec96605fb018f53553027f27b59b->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
23	App\Controller\SejourparthemeController->index (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.79 ms
(4.25%)

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

0.77 ms
(4.14%)

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\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\Catalogue::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Catalogue->__get (line 61)
8	App\Entity\Catalogue->getCouleuretiquette (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 431)
10	__TwigTemplate_e7e8ec96605fb018f53553027f27b59b->block_body (line 446)
11	Twig\Template->yieldBlock (line 572)
12	__TwigTemplate_a89b8e977156382020d9ea0618e3e2f8->doDisplay (line 402)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_e7e8ec96605fb018f53553027f27b59b->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
23	App\Controller\SejourparthemeController->index (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.75 ms
(4.05%)

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

0.64 ms
(3.45%)

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\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\Region::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Region->__get (line 34)
8	App\Entity\Region->getLibelleregion (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 546)
10	__TwigTemplate_e7e8ec96605fb018f53553027f27b59b->block_body (line 446)
11	Twig\Template->yieldBlock (line 572)
12	__TwigTemplate_a89b8e977156382020d9ea0618e3e2f8->doDisplay (line 402)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_e7e8ec96605fb018f53553027f27b59b->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
23	App\Controller\SejourparthemeController->index (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.62 ms
(3.36%)

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\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\Categorieoffre::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Categorieoffre->__get (line 49)
8	App\Entity\Categorieoffre->getCouleuretiquette (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 467)
10	__TwigTemplate_e7e8ec96605fb018f53553027f27b59b->block_body (line 446)
11	Twig\Template->yieldBlock (line 572)
12	__TwigTemplate_a89b8e977156382020d9ea0618e3e2f8->doDisplay (line 402)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_e7e8ec96605fb018f53553027f27b59b->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
23	App\Controller\SejourparthemeController->index (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.61 ms
(3.32%)

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\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\Typelogement::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Typelogement->__get (line 31)
8	App\Entity\Typelogement->getLibelletypelogement (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 489)
10	__TwigTemplate_e7e8ec96605fb018f53553027f27b59b->block_body (line 446)
11	Twig\Template->yieldBlock (line 572)
12	__TwigTemplate_a89b8e977156382020d9ea0618e3e2f8->doDisplay (line 402)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_e7e8ec96605fb018f53553027f27b59b->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
23	App\Controller\SejourparthemeController->index (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.59 ms
(3.18%)

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_ 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_.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_
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_.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_ WHERE s0_.EstVisible = 1 AND s0_.IDTheme = '4' AND s0_.IDSejour IN ('2', '16') ORDER BY s0_.NomSejour 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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerUweWW8b\PaginatorProxy9cc2a8f->paginate (line 50)
16	App\Controller\SejourparthemeController->index (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.57 ms
(3.08%)

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_ 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_.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_
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_.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_ WHERE s0_.EstVisible = 1 AND s0_.IDTheme = '1' AND s0_.IDSejour IN ('3') ORDER BY s0_.NomSejour 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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerUweWW8b\PaginatorProxy9cc2a8f->paginate (line 50)
16	App\Controller\SejourparthemeController->index (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.57 ms
(3.07%)

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\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\Typeprestation::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Typeprestation->__get (line 31)
8	App\Entity\Typeprestation->getLibelleprestation (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 526)
10	__TwigTemplate_e7e8ec96605fb018f53553027f27b59b->block_body (line 446)
11	Twig\Template->yieldBlock (line 572)
12	__TwigTemplate_a89b8e977156382020d9ea0618e3e2f8->doDisplay (line 402)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_e7e8ec96605fb018f53553027f27b59b->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
23	App\Controller\SejourparthemeController->index (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.45 ms
(2.43%)

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\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 23)
4	App\Service\AvisTwigService->getAvis (line 1909)
5	Twig\Extension\CoreExtension::getAttribute (line 60)
6	__TwigTemplate_9e78097f628c21c65b91969aec35edc3->doDisplay (line 402)
7	Twig\Template->yield (line 614)
8	__TwigTemplate_e7e8ec96605fb018f53553027f27b59b->block_body (line 446)
9	Twig\Template->yieldBlock (line 572)
10	__TwigTemplate_a89b8e977156382020d9ea0618e3e2f8->doDisplay (line 402)
11	Twig\Template->yield (line 55)
12	__TwigTemplate_e7e8ec96605fb018f53553027f27b59b->doDisplay (line 402)
13	Twig\Template->yield (line 358)
14	Twig\Template->display (line 373)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 333)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
21	App\Controller\SejourparthemeController->index (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.43 ms
(2.32%)

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\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 30)
4	App\Controller\SejourparthemeController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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.

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