Symfony Profiler

Query Metrics

15 Database Queries

10 Different statements

11.92 ms Query time

0 Invalid entities

28 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.71 ms
(22.71%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.description AS description_4, t0.reference_index AS reference_index_5, t0.reference AS reference_6, t0.the_album_id AS the_album_id_7 FROM partenaires_partenaire t0 WHERE t0.the_album_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.reference_index AS reference_index_5,
  t0.reference AS reference_6,
  t0.the_album_id AS the_album_id_7
FROM
  partenaires_partenaire t0
WHERE
  t0.the_album_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.description AS description_4, t0.reference_index AS reference_index_5, t0.reference AS reference_6, t0.the_album_id AS the_album_id_7 FROM partenaires_partenaire t0 WHERE t0.the_album_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 839)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2457)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 171)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 948)
9	Doctrine\ORM\AbstractQuery->execute (line 891)
10	Doctrine\ORM\AbstractQuery->getResult (line 689)
11	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
12	iterator_to_array (line 45)
13	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
18	Knp\Component\Pager\Paginator->paginate (line 97)
19	ContainerMHugtRe\PaginatorProxyBa079e5->paginate (line 20)
20	App\Service\Paginators\PaginatorService->paginate (line 26)
21	App\Controller\Visiteur\Albums\AlbumController->index (line 24)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

2.44 ms
(20.46%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.has_uploaded_file AS has_uploaded_file_3, t0.filename AS filename_4, t0.folder AS folder_5, t0.the_property_id AS the_property_id_6, t0.the_type_id AS the_type_id_7, t0.nom AS nom_8, t0.size AS size_9, t0.reference_index AS reference_index_10, t0.reference AS reference_11, t0.the_users_user_avatar_id AS the_users_user_avatar_id_12, t0.the_contacts_coordonnee_logo_id AS the_contacts_coordonnee_logo_id_13, t0.the_partenaires_partenaire_image_id AS the_partenaires_partenaire_image_id_14, t0.the_actualites_actualite_image_id AS the_actualites_actualite_image_id_15, t0.the_pages_page_header_id AS the_pages_page_header_id_16, t0.the_pages_page_image_image_id AS the_pages_page_image_image_id_17 FROM fichiers_fichier t0 WHERE t0.the_actualites_actualite_image_id = ?

Parameters:

[
  40
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.has_uploaded_file AS has_uploaded_file_3,
  t0.filename AS filename_4,
  t0.folder AS folder_5,
  t0.the_property_id AS the_property_id_6,
  t0.the_type_id AS the_type_id_7,
  t0.nom AS nom_8,
  t0.size AS size_9,
  t0.reference_index AS reference_index_10,
  t0.reference AS reference_11,
  t0.the_users_user_avatar_id AS the_users_user_avatar_id_12,
  t0.the_contacts_coordonnee_logo_id AS the_contacts_coordonnee_logo_id_13,
  t0.the_partenaires_partenaire_image_id AS the_partenaires_partenaire_image_id_14,
  t0.the_actualites_actualite_image_id AS the_actualites_actualite_image_id_15,
  t0.the_pages_page_header_id AS the_pages_page_header_id_16,
  t0.the_pages_page_image_image_id AS the_pages_page_image_image_id_17
FROM
  fichiers_fichier t0
WHERE
  t0.the_actualites_actualite_image_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.has_uploaded_file AS has_uploaded_file_3, t0.filename AS filename_4, t0.folder AS folder_5, t0.the_property_id AS the_property_id_6, t0.the_type_id AS the_type_id_7, t0.nom AS nom_8, t0.size AS size_9, t0.reference_index AS reference_index_10, t0.reference AS reference_11, t0.the_users_user_avatar_id AS the_users_user_avatar_id_12, t0.the_contacts_coordonnee_logo_id AS the_contacts_coordonnee_logo_id_13, t0.the_partenaires_partenaire_image_id AS the_partenaires_partenaire_image_id_14, t0.the_actualites_actualite_image_id AS the_actualites_actualite_image_id_15, t0.the_pages_page_header_id AS the_pages_page_header_id_16, t0.the_pages_page_image_image_id AS the_pages_page_image_image_id_17 FROM fichiers_fichier t0 WHERE t0.the_actualites_actualite_image_id = 40;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 839)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2457)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 171)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 948)
9	Doctrine\ORM\AbstractQuery->execute (line 891)
10	Doctrine\ORM\AbstractQuery->getResult (line 689)
11	App\Repository\Actualites\ActualiteRepository->findLast (line 42)
12	App\Twig\Visiteur\Menus\FooterComponent->getListActualite (line 27)
13	Twig\Extension\CoreExtension->getAttribute (line 1909)
14	__TwigTemplate_8f46a1988948fb0d63c62fef30dd5b71::doDisplay (line 58)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
19	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
20	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
21	__TwigTemplate_9d18229d9fb951494426f81a51380b7d->doDisplay (line 117)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_1aa3f0764e5517552f0f2664a4007d03->doDisplay (line 52)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_fe802fcc4bd0c1764bc4637c176ccbe4->doDisplay (line 53)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Twig\TemplateWrapper->render (line 51)
30	Twig\Environment->render (line 333)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
34	App\Controller\Visiteur\Albums\AlbumController->index (line 21)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 182)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 29)
40	require_once (line 5)

1.25 ms
(10.45%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.sous_titre AS sous_titre_3, t0.slug AS slug_4, t0.has_breadcrumb AS has_breadcrumb_5, t0.the_type_id AS the_type_id_6, t0.reference_index AS reference_index_7, t0.reference AS reference_8, t9.id AS id_10, t9.url AS url_11, t9.has_uploaded_file AS has_uploaded_file_12, t9.filename AS filename_13, t9.folder AS folder_14, t9.the_property_id AS the_property_id_15, t9.the_type_id AS the_type_id_16, t9.nom AS nom_17, t9.size AS size_18, t9.reference_index AS reference_index_19, t9.reference AS reference_20, t9.the_users_user_avatar_id AS the_users_user_avatar_id_21, t9.the_contacts_coordonnee_logo_id AS the_contacts_coordonnee_logo_id_22, t9.the_partenaires_partenaire_image_id AS the_partenaires_partenaire_image_id_23, t9.the_actualites_actualite_image_id AS the_actualites_actualite_image_id_24, t9.the_pages_page_header_id AS the_pages_page_header_id_25, t9.the_pages_page_image_image_id AS the_pages_page_image_image_id_26, t0.the_seo_id AS the_seo_id_27 FROM pages_page t0 LEFT JOIN fichiers_fichier t9 ON t9.the_pages_page_header_id = t0.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.sous_titre AS sous_titre_3,
  t0.slug AS slug_4,
  t0.has_breadcrumb AS has_breadcrumb_5,
  t0.the_type_id AS the_type_id_6,
  t0.reference_index AS reference_index_7,
  t0.reference AS reference_8,
  t9.id AS id_10,
  t9.url AS url_11,
  t9.has_uploaded_file AS has_uploaded_file_12,
  t9.filename AS filename_13,
  t9.folder AS folder_14,
  t9.the_property_id AS the_property_id_15,
  t9.the_type_id AS the_type_id_16,
  t9.nom AS nom_17,
  t9.size AS size_18,
  t9.reference_index AS reference_index_19,
  t9.reference AS reference_20,
  t9.the_users_user_avatar_id AS the_users_user_avatar_id_21,
  t9.the_contacts_coordonnee_logo_id AS the_contacts_coordonnee_logo_id_22,
  t9.the_partenaires_partenaire_image_id AS the_partenaires_partenaire_image_id_23,
  t9.the_actualites_actualite_image_id AS the_actualites_actualite_image_id_24,
  t9.the_pages_page_header_id AS the_pages_page_header_id_25,
  t9.the_pages_page_image_image_id AS the_pages_page_image_image_id_26,
  t0.the_seo_id AS the_seo_id_27
FROM
  pages_page t0
  LEFT JOIN fichiers_fichier t9 ON t9.the_pages_page_header_id = t0.id

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.sous_titre AS sous_titre_3, t0.slug AS slug_4, t0.has_breadcrumb AS has_breadcrumb_5, t0.the_type_id AS the_type_id_6, t0.reference_index AS reference_index_7, t0.reference AS reference_8, t9.id AS id_10, t9.url AS url_11, t9.has_uploaded_file AS has_uploaded_file_12, t9.filename AS filename_13, t9.folder AS folder_14, t9.the_property_id AS the_property_id_15, t9.the_type_id AS the_type_id_16, t9.nom AS nom_17, t9.size AS size_18, t9.reference_index AS reference_index_19, t9.reference AS reference_20, t9.the_users_user_avatar_id AS the_users_user_avatar_id_21, t9.the_contacts_coordonnee_logo_id AS the_contacts_coordonnee_logo_id_22, t9.the_partenaires_partenaire_image_id AS the_partenaires_partenaire_image_id_23, t9.the_actualites_actualite_image_id AS the_actualites_actualite_image_id_24, t9.the_pages_page_header_id AS the_pages_page_header_id_25, t9.the_pages_page_image_image_id AS the_pages_page_image_image_id_26, t0.the_seo_id AS the_seo_id_27 FROM pages_page t0 LEFT JOIN fichiers_fichier t9 ON t9.the_pages_page_header_id = t0.id;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Provider\Pages\PageProvider->getListPage (line 26)
6	App\Provider\Pages\PageProvider->getThePage (line 50)
7	__TwigTemplate_9d18229d9fb951494426f81a51380b7d->doDisplay (line 53)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_1aa3f0764e5517552f0f2664a4007d03->doDisplay (line 52)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_fe802fcc4bd0c1764bc4637c176ccbe4->doDisplay (line 53)
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 459)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
20	App\Controller\Visiteur\Albums\AlbumController->index (line 21)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.96 ms
(8.05%)

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM albums_album a0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  albums_album a0_

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM albums_album a0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 725)
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 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerMHugtRe\PaginatorProxyBa079e5->paginate (line 20)
15	App\Service\Paginators\PaginatorService->paginate (line 26)
16	App\Controller\Visiteur\Albums\AlbumController->index (line 24)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.91 ms
(7.61%)

SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.slug AS slug_2, a0_.resume AS resume_3, a0_.texte AS texte_4, a0_.the_datetime AS the_datetime_5, a0_.reference_index AS reference_index_6, a0_.reference AS reference_7 FROM actualites_actualite a0_ ORDER BY a0_.the_datetime DESC LIMIT 3

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.nom AS nom_1,
  a0_.slug AS slug_2,
  a0_.resume AS resume_3,
  a0_.texte AS texte_4,
  a0_.the_datetime AS the_datetime_5,
  a0_.reference_index AS reference_index_6,
  a0_.reference AS reference_7
FROM
  actualites_actualite a0_
ORDER BY
  a0_.the_datetime DESC
LIMIT
  3

SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.slug AS slug_2, a0_.resume AS resume_3, a0_.texte AS texte_4, a0_.the_datetime AS the_datetime_5, a0_.reference_index AS reference_index_6, a0_.reference AS reference_7 FROM actualites_actualite a0_ ORDER BY a0_.the_datetime DESC LIMIT 3;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\Actualites\ActualiteRepository->findLast (line 42)
7	App\Twig\Visiteur\Menus\FooterComponent->getListActualite (line 27)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_8f46a1988948fb0d63c62fef30dd5b71::doDisplay (line 58)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
16	__TwigTemplate_9d18229d9fb951494426f81a51380b7d->doDisplay (line 117)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_1aa3f0764e5517552f0f2664a4007d03->doDisplay (line 52)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_fe802fcc4bd0c1764bc4637c176ccbe4->doDisplay (line 53)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
29	App\Controller\Visiteur\Albums\AlbumController->index (line 21)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 182)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 29)
35	require_once (line 5)

0.90 ms
(7.52%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.mot_cles AS mot_cles_4, t5.id AS id_6, t5.nom AS nom_7, t5.sous_titre AS sous_titre_8, t5.slug AS slug_9, t5.has_breadcrumb AS has_breadcrumb_10, t5.the_type_id AS the_type_id_11, t5.reference_index AS reference_index_12, t5.reference AS reference_13, t5.the_seo_id AS the_seo_id_14 FROM seos_seo t0 LEFT JOIN pages_page t5 ON t5.the_seo_id = t0.id WHERE t0.id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.mot_cles AS mot_cles_4,
  t5.id AS id_6,
  t5.nom AS nom_7,
  t5.sous_titre AS sous_titre_8,
  t5.slug AS slug_9,
  t5.has_breadcrumb AS has_breadcrumb_10,
  t5.the_type_id AS the_type_id_11,
  t5.reference_index AS reference_index_12,
  t5.reference AS reference_13,
  t5.the_seo_id AS the_seo_id_14
FROM
  seos_seo t0
  LEFT JOIN pages_page t5 ON t5.the_seo_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.mot_cles AS mot_cles_4, t5.id AS id_6, t5.nom AS nom_7, t5.sous_titre AS sous_titre_8, t5.slug AS slug_9, t5.has_breadcrumb AS has_breadcrumb_10, t5.the_type_id AS the_type_id_11, t5.reference_index AS reference_index_12, t5.reference AS reference_13, t5.the_seo_id AS the_seo_id_14 FROM seos_seo t0 LEFT JOIN pages_page t5 ON t5.the_seo_id = t0.id WHERE t0.id = 7;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():288} (line 289)
4	Proxies\__CG__\App\Entity\Seos\Seo::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():365}:366} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Seos\Seo->__get (line 153)
7	App\Entity\Seos\Seo->getTitle (line 37)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_47728f06c2ca25ff9b13f87e4a341bff::doDisplay (line 72)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Extension\CoreExtension->include (line 1520)
15	__TwigTemplate_9d18229d9fb951494426f81a51380b7d::doDisplay (line 62)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_1aa3f0764e5517552f0f2664a4007d03->doDisplay (line 52)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_fe802fcc4bd0c1764bc4637c176ccbe4->doDisplay (line 53)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
28	App\Controller\Visiteur\Albums\AlbumController->index (line 21)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 5)

0.78 ms
(6.54%)

SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.slug AS slug_2, a0_.reference_index AS reference_index_3, a0_.reference AS reference_4 FROM albums_album a0_ WHERE a0_.id IN (?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.nom AS nom_1,
  a0_.slug AS slug_2,
  a0_.reference_index AS reference_index_3,
  a0_.reference AS reference_4
FROM
  albums_album a0_
WHERE
  a0_.id IN (?, ?, ?, ?)

SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.slug AS slug_2, a0_.reference_index AS reference_index_3, a0_.reference AS reference_4 FROM albums_album a0_ WHERE a0_.id IN (1, 2, 3, 4);

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
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 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerMHugtRe\PaginatorProxyBa079e5->paginate (line 20)
15	App\Service\Paginators\PaginatorService->paginate (line 26)
16	App\Controller\Visiteur\Albums\AlbumController->index (line 24)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.70 ms
(5.90%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.class_icon AS class_icon_4, t0.url AS url_5 FROM contacts_reseau_social t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.slug AS slug_3,
  t0.class_icon AS class_icon_4,
  t0.url AS url_5
FROM
  contacts_reseau_social t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.class_icon AS class_icon_4, t0.url AS url_5 FROM contacts_reseau_social t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Provider\Contacts\ReseauSocialProvider->getListReseauSocial (line 20)
6	App\Twig\Visiteur\Menus\NavbarComponent->getListReseauSocial (line 19)
7	Twig\Extension\CoreExtension->getAttribute (line 1909)
8	__TwigTemplate_4fd9be266afdf795847dcf544eb4be49::doDisplay (line 58)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
14	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
15	__TwigTemplate_9d18229d9fb951494426f81a51380b7d->doDisplay (line 74)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_1aa3f0764e5517552f0f2664a4007d03->doDisplay (line 52)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_fe802fcc4bd0c1764bc4637c176ccbe4->doDisplay (line 53)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
28	App\Controller\Visiteur\Albums\AlbumController->index (line 21)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 5)

0.66 ms
(5.52%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.texte AS texte_4, t0.reference_index AS reference_index_5, t0.reference AS reference_6 FROM textes_texte t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.slug AS slug_3,
  t0.texte AS texte_4,
  t0.reference_index AS reference_index_5,
  t0.reference AS reference_6
FROM
  textes_texte t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.texte AS texte_4, t0.reference_index AS reference_index_5, t0.reference AS reference_6 FROM textes_texte t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Provider\Textes\TexteProvider->getListTexte (line 22)
6	App\Provider\Textes\TexteProvider->getTheTexte (line 35)
7	App\Twig\Visiteur\Menus\FooterComponent->getTheTexteAPropos (line 39)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_8f46a1988948fb0d63c62fef30dd5b71::doDisplay (line 244)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
16	__TwigTemplate_9d18229d9fb951494426f81a51380b7d->doDisplay (line 117)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_1aa3f0764e5517552f0f2664a4007d03->doDisplay (line 52)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_fe802fcc4bd0c1764bc4637c176ccbe4->doDisplay (line 53)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
29	App\Controller\Visiteur\Albums\AlbumController->index (line 21)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 182)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 29)
35	require_once (line 5)

0.63 ms
(5.25%)

SELECT DISTINCT a0_.id AS id_0 FROM albums_album a0_ LIMIT 4

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT a0_.id AS id_0
FROM
  albums_album a0_
LIMIT
  4

SELECT DISTINCT a0_.id AS id_0 FROM albums_album a0_ LIMIT 4;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 725)
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 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerMHugtRe\PaginatorProxyBa079e5->paginate (line 20)
15	App\Service\Paginators\PaginatorService->paginate (line 26)
16	App\Controller\Visiteur\Albums\AlbumController->index (line 24)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	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\Pages\Page	8
App\Entity\Seos\Seo	8
App\Entity\Albums\Album	4
App\Entity\Contacts\ReseauSocial	3
App\Entity\Actualites\Actualite	3
App\Entity\Textes\Texte	2

Entities Mapping

Class	Mapping errors
App\Entity\Users\Login	No errors.
App\Entity\Users\User	No errors.
App\Entity\Albums\Album	No errors.
App\Entity\Partenaires\Partenaire	No errors.
App\Entity\Albums\AlbumMedia	No errors.
App\Entity\Pages\Page	No errors.
App\Entity\Fichiers\Fichier	No errors.
App\Entity\Contacts\Coordonnee	No errors.
App\Entity\Actualites\Actualite	No errors.
App\Entity\Pages\PageBloc	No errors.
App\Entity\Pages\PageImage	No errors.
App\Entity\Seos\Seo	No errors.
App\Entity\Contacts\ReseauSocial	No errors.
App\Entity\Textes\Texte	No errors.

Symfony Profiler

GET https://les-creolines.fpdev.fr/albums

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping