Symfony Profiler

Query Metrics

66 Database Queries

16 Different statements

13.23 ms Query time

5 Invalid entities

977 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.95 ms
(44.99%)

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:

[
  5
]

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 = 5 ORDER BY t0.DatDebut DESC;

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

1.09 ms
(8.20%)

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

Parameters:

[
  "13"
]

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 = '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 289)
4	Proxies\__CG__\App\Entity\Region::Doctrine\ORM\Proxy\{closure} (line 367)
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 1913)
9	__TwigTemplate_024e0900c6a6e37680f5bf58f43c11ba::block_body (line 546)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_52b91791cf6aaf3de23e7cf3e8d096f4->doDisplay (line 572)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_024e0900c6a6e37680f5bf58f43c11ba->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
22	App\Controller\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 197)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

1.08 ms
(8.14%)

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\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1272)
9	__TwigTemplate_024e0900c6a6e37680f5bf58f43c11ba::{closure} (line 176)
10	array_filter (line 1970)
11	Twig\Extension\CoreExtension::filter (line 1970)
12	__TwigTemplate_024e0900c6a6e37680f5bf58f43c11ba::block_body (line 176)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_52b91791cf6aaf3de23e7cf3e8d096f4->doDisplay (line 572)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_024e0900c6a6e37680f5bf58f43c11ba->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 448)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
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 197)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 29)
31	require_once (line 5)

0.83 ms
(6.28%)

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

Parameters:

[
  "5"
]

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

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

0.70 ms
(5.31%)

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	Container3Yt8a7t\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 197)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.58 ms
(4.37%)

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

Parameters:

[
  "9"
]

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.43 ms
(3.24%)

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	Container3Yt8a7t\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 197)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.43 ms
(3.21%)

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:

[
  "3"
]

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Categorieoffre::Doctrine\ORM\Proxy\{closure} (line 367)
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 1913)
9	__TwigTemplate_024e0900c6a6e37680f5bf58f43c11ba::block_body (line 467)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_52b91791cf6aaf3de23e7cf3e8d096f4->doDisplay (line 572)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_024e0900c6a6e37680f5bf58f43c11ba->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
22	App\Controller\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 197)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.39 ms
(2.93%)

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"
  "5"
  "6"
  "7"
  "9"
  "11"
  "15"
  "19"
  "20"
  "21"
  "22"
  "29"
  "18"
]

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 ('5', '6', '7', '9', '11', '15', '19', '20', '21', '22', '29', '18') 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	Container3Yt8a7t\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 197)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.36 ms
(2.75%)

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
  "5"
  "68"
  "10"
  "14"
  "27"
  "40"
  "49"
  "55"
  "71"
  "64"
]

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 = '5' AND s0_.IDSejour IN ('68', '10', '14', '27', '40', '49', '55', '71', '64') 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	Container3Yt8a7t\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 197)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.29 ms
(2.21%)

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"
  "53"
  "54"
  "56"
  "57"
  "61"
  "62"
  "63"
]

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 ('53', '54', '56', '57', '61', '62', '63') 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	Container3Yt8a7t\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 197)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.26 ms
(1.96%)

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

Parameters:

[
  "2"
]

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.25 ms
(1.90%)

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 OFFSET 24

Parameters:

[
  1
  "4"
]

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
OFFSET
  24

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

#	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	Container3Yt8a7t\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 197)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.24 ms
(1.81%)

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 197)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.19 ms
(1.40%)

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

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.17 ms
(1.30%)

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 197)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (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	810
App\Entity\Sejour	68
App\Entity\Hebergement	68
App\Entity\Region	11
App\Entity\Typelogement	6
App\Entity\Catalogue	5
App\Entity\Theme	3
App\Entity\Categorieoffre	3
App\Entity\Typeprestation	2
App\Entity\Banner	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.

Symfony Profiler

GET https://www.arcanciane.fr/sejourpartheme?page_4=3

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping