Symfony Profiler

Query Metrics

106 Database Queries

12 Different statements

981.28 ms Query time

0 Invalid entities

95 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

444.91 ms
(45.34%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.external_url AS external_url_3, t0.target AS target_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8, t0.menu_id AS menu_id_9, t0.url_alias_id AS url_alias_id_10 FROM menu_link t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC

Parameters:

[
  676
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.external_url AS external_url_3,
  t0.target AS target_4,
  t0.position AS position_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.parent_id AS parent_id_8,
  t0.menu_id AS menu_id_9,
  t0.url_alias_id AS url_alias_id_10
FROM
  menu_link t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.external_url AS external_url_3, t0.target AS target_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8, t0.menu_id AS menu_id_9, t0.url_alias_id AS url_alias_id_10 FROM menu_link t0 WHERE t0.parent_id = 676 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Repository\MenuLinkRepository->buildNode (line 54)
5	App\Repository\MenuLinkRepository->App\Repository\{closure} (line 35)
6	array_map (line 35)
7	App\Repository\MenuLinkRepository::findTreeForMenu (line 35)
8	App\Twig\NavigationExtension->menuTree (line 49)
9	__TwigTemplate_453b7a83bfe39055b6ac274bdc1785d2->{closure} (line 127)
10	Twig\Extension\CoreExtension->captureOutput (line 2140)
11	__TwigTemplate_453b7a83bfe39055b6ac274bdc1785d2::macro_render (line 119)
12	__TwigTemplate_c45deb949de43a7f8cbda0d18aa6ba24->doDisplay (line 78)
13	Twig\Template->yield (line 411)
14	__TwigTemplate_525ea427e1045890109d836a466ec5ef->block_body (line 90)
15	Twig\Template->yieldBlock (line 458)
16	__TwigTemplate_24f73696464343efad806d743be1601c->doDisplay (line 111)
17	Twig\Template->yield (line 411)
18	__TwigTemplate_525ea427e1045890109d836a466ec5ef->doDisplay (line 60)
19	Twig\Template->yield (line 411)
20	__TwigTemplate_33529af58949218f1c46b8b4ea269a34->doDisplay (line 65)
21	Twig\Template->yield (line 411)
22	Twig\Template->display (line 366)
23	Twig\Template->render (line 381)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
29	App\Controller\DestinationController->continent (line 66)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	App\Resolver\ContinentUrlAliasResolver->resolve (line 44)
33	App\Controller\UrlAliasController->resolve (line 100)
34	App\Controller\UrlAliasController->__invoke (line 60)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 193)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
39	require_once (line 32)
40	require_once (line 5)

169.71 ms
(17.30%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.path AS path_3, t0.entity_type AS entity_type_4, t0.entity_id AS entity_id_5, t0.route_name AS route_name_6, t0.pathauto AS pathauto_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM url_alias t0 WHERE t0.id = ?

Parameters:

[
  8806
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.path AS path_3,
  t0.entity_type AS entity_type_4,
  t0.entity_id AS entity_id_5,
  t0.route_name AS route_name_6,
  t0.pathauto AS pathauto_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.parent_id AS parent_id_10
FROM
  url_alias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.path AS path_3, t0.entity_type AS entity_type_4, t0.entity_id AS entity_id_5, t0.route_name AS route_name_6, t0.pathauto AS pathauto_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM url_alias t0 WHERE t0.id = 8806;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\UrlAlias::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\UrlAlias->__get (line 153)
7	App\Entity\UrlAlias->getPath (line 122)
8	Twig\Extension\CoreExtension->getAttribute (line 1928)
9	__TwigTemplate_453b7a83bfe39055b6ac274bdc1785d2::{closure} (line 89)
10	Twig\Extension\CoreExtension->captureOutput (line 2140)
11	__TwigTemplate_453b7a83bfe39055b6ac274bdc1785d2::macro_href (line 79)
12	__TwigTemplate_a4c08b1a6080548243b58bfba9d97640->doDisplay (line 67)
13	Twig\Template->yield (line 411)
14	__TwigTemplate_453b7a83bfe39055b6ac274bdc1785d2->{closure} (line 127)
15	Twig\Extension\CoreExtension->captureOutput (line 2140)
16	__TwigTemplate_453b7a83bfe39055b6ac274bdc1785d2::macro_render (line 119)
17	__TwigTemplate_c45deb949de43a7f8cbda0d18aa6ba24->doDisplay (line 78)
18	Twig\Template->yield (line 411)
19	__TwigTemplate_525ea427e1045890109d836a466ec5ef->block_body (line 90)
20	Twig\Template->yieldBlock (line 458)
21	__TwigTemplate_24f73696464343efad806d743be1601c->doDisplay (line 111)
22	Twig\Template->yield (line 411)
23	__TwigTemplate_525ea427e1045890109d836a466ec5ef->doDisplay (line 60)
24	Twig\Template->yield (line 411)
25	__TwigTemplate_33529af58949218f1c46b8b4ea269a34->doDisplay (line 65)
26	Twig\Template->yield (line 411)
27	Twig\Template->display (line 366)
28	Twig\Template->render (line 381)
29	Twig\TemplateWrapper->render (line 51)
30	Twig\Environment->render (line 333)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
34	App\Controller\DestinationController->continent (line 66)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	App\Resolver\ContinentUrlAliasResolver->resolve (line 44)
38	App\Controller\UrlAliasController->resolve (line 100)
39	App\Controller\UrlAliasController->__invoke (line 60)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
42	Symfony\Component\HttpKernel\Kernel->handle (line 193)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
44	require_once (line 32)
45	require_once (line 5)

95.95 ms
(9.78%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3 FROM menu t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "topbar"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.label AS label_3
FROM
  menu t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3 FROM menu t0 WHERE t0.name = 'topbar' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Twig\NavigationExtension->menuTree (line 47)
5	__TwigTemplate_453b7a83bfe39055b6ac274bdc1785d2->{closure} (line 127)
6	Twig\Extension\CoreExtension->captureOutput (line 2140)
7	__TwigTemplate_453b7a83bfe39055b6ac274bdc1785d2::macro_render (line 119)
8	__TwigTemplate_c45deb949de43a7f8cbda0d18aa6ba24->doDisplay (line 78)
9	Twig\Template->yield (line 411)
10	__TwigTemplate_525ea427e1045890109d836a466ec5ef->block_body (line 90)
11	Twig\Template->yieldBlock (line 458)
12	__TwigTemplate_24f73696464343efad806d743be1601c->doDisplay (line 111)
13	Twig\Template->yield (line 411)
14	__TwigTemplate_525ea427e1045890109d836a466ec5ef->doDisplay (line 60)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_33529af58949218f1c46b8b4ea269a34->doDisplay (line 65)
17	Twig\Template->yield (line 411)
18	Twig\Template->display (line 366)
19	Twig\Template->render (line 381)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
25	App\Controller\DestinationController->continent (line 66)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	App\Resolver\ContinentUrlAliasResolver->resolve (line 44)
29	App\Controller\UrlAliasController->resolve (line 100)
30	App\Controller\UrlAliasController->__invoke (line 60)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 193)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
35	require_once (line 32)
36	require_once (line 5)

78.38 ms
(7.99%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.path AS path_3, t0.entity_type AS entity_type_4, t0.entity_id AS entity_id_5, t0.route_name AS route_name_6, t0.pathauto AS pathauto_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM url_alias t0 WHERE t0.entity_type = ? AND t0.entity_id = ? LIMIT 1

Parameters:

[
  "continent"
  49
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.path AS path_3,
  t0.entity_type AS entity_type_4,
  t0.entity_id AS entity_id_5,
  t0.route_name AS route_name_6,
  t0.pathauto AS pathauto_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.parent_id AS parent_id_10
FROM
  url_alias t0
WHERE
  t0.entity_type = ?
  AND t0.entity_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.path AS path_3, t0.entity_type AS entity_type_4, t0.entity_id AS entity_id_5, t0.route_name AS route_name_6, t0.pathauto AS pathauto_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM url_alias t0 WHERE t0.entity_type = 'continent' AND t0.entity_id = 49 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Entity\Destination\Continent->loadUrlAliasFields (line 70)
5	Doctrine\ORM\Event\ListenersInvoker->invoke (line 80)
6	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
7	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3214)
8	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 49)
9	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
11	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
12	Doctrine\ORM\EntityManager->find (line 366)
13	Doctrine\ORM\EntityRepository->find (line 86)
14	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
15	App\Resolver\ContinentUrlAliasResolver->resolve (line 31)
16	App\Controller\UrlAliasController->resolve (line 100)
17	App\Controller\UrlAliasController->__invoke (line 60)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
22	require_once (line 32)
23	require_once (line 5)

48.95 ms
(4.99%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.external_url AS external_url_3, t0.target AS target_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8, t0.menu_id AS menu_id_9, t0.url_alias_id AS url_alias_id_10 FROM menu_link t0 WHERE t0.menu_id = ? AND t0.parent_id IS NULL ORDER BY t0.position ASC

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.external_url AS external_url_3,
  t0.target AS target_4,
  t0.position AS position_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.parent_id AS parent_id_8,
  t0.menu_id AS menu_id_9,
  t0.url_alias_id AS url_alias_id_10
FROM
  menu_link t0
WHERE
  t0.menu_id = ?
  AND t0.parent_id IS NULL
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.external_url AS external_url_3, t0.target AS target_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8, t0.menu_id AS menu_id_9, t0.url_alias_id AS url_alias_id_10 FROM menu_link t0 WHERE t0.menu_id = 4 AND t0.parent_id IS NULL ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Repository\MenuLinkRepository->findTreeForMenu (line 33)
5	App\Twig\NavigationExtension->menuTree (line 49)
6	__TwigTemplate_453b7a83bfe39055b6ac274bdc1785d2->{closure} (line 127)
7	Twig\Extension\CoreExtension->captureOutput (line 2140)
8	__TwigTemplate_453b7a83bfe39055b6ac274bdc1785d2::macro_render (line 119)
9	__TwigTemplate_c45deb949de43a7f8cbda0d18aa6ba24->doDisplay (line 78)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_525ea427e1045890109d836a466ec5ef->block_body (line 90)
12	Twig\Template->yieldBlock (line 458)
13	__TwigTemplate_24f73696464343efad806d743be1601c->doDisplay (line 111)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_525ea427e1045890109d836a466ec5ef->doDisplay (line 60)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_33529af58949218f1c46b8b4ea269a34->doDisplay (line 65)
18	Twig\Template->yield (line 411)
19	Twig\Template->display (line 366)
20	Twig\Template->render (line 381)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
26	App\Controller\DestinationController->continent (line 66)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	App\Resolver\ContinentUrlAliasResolver->resolve (line 44)
30	App\Controller\UrlAliasController->resolve (line 100)
31	App\Controller\UrlAliasController->__invoke (line 60)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 193)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
36	require_once (line 32)
37	require_once (line 5)

33.45 ms
(3.41%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.external_url AS external_url_3, t0.target AS target_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8, t0.menu_id AS menu_id_9, t0.url_alias_id AS url_alias_id_10 FROM menu_link t0 WHERE t0.url_alias_id = ? ORDER BY t0.id ASC LIMIT 1

Parameters:

[
  8819
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.external_url AS external_url_3,
  t0.target AS target_4,
  t0.position AS position_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.parent_id AS parent_id_8,
  t0.menu_id AS menu_id_9,
  t0.url_alias_id AS url_alias_id_10
FROM
  menu_link t0
WHERE
  t0.url_alias_id = ?
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.external_url AS external_url_3, t0.target AS target_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8, t0.menu_id AS menu_id_9, t0.url_alias_id AS url_alias_id_10 FROM menu_link t0 WHERE t0.url_alias_id = 8819 ORDER BY t0.id ASC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Repository\MenuLinkRepository->findFirstForUrlAlias (line 48)
5	App\Entity\Content->loadMenuLinkFields (line 53)
6	Doctrine\ORM\Event\ListenersInvoker->invoke (line 80)
7	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
8	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3214)
9	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 49)
10	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
11	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
12	Doctrine\ORM\EntityRepository->findOneBy (line 125)
13	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
14	App\Twig\NavigationExtension->contentPageUrl (line 86)
15	__TwigTemplate_ac17d7eba8c0dc484121197c7bb20642->doDisplay (line 110)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_525ea427e1045890109d836a466ec5ef->block_body (line 100)
18	Twig\Template->yieldBlock (line 458)
19	__TwigTemplate_24f73696464343efad806d743be1601c->doDisplay (line 111)
20	Twig\Template->yield (line 411)
21	__TwigTemplate_525ea427e1045890109d836a466ec5ef->doDisplay (line 60)
22	Twig\Template->yield (line 411)
23	__TwigTemplate_33529af58949218f1c46b8b4ea269a34->doDisplay (line 65)
24	Twig\Template->yield (line 411)
25	Twig\Template->display (line 366)
26	Twig\Template->render (line 381)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
32	App\Controller\DestinationController->continent (line 66)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	App\Resolver\ContinentUrlAliasResolver->resolve (line 44)
36	App\Controller\UrlAliasController->resolve (line 100)
37	App\Controller\UrlAliasController->__invoke (line 60)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
40	Symfony\Component\HttpKernel\Kernel->handle (line 193)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
42	require_once (line 32)
43	require_once (line 5)

32.17 ms
(3.28%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_h1 AS title_h1_3, t0.body AS body_4, t0.image AS image_5, t0.show_header_image AS show_header_image_6, t0.layout AS layout_7, t0.pinned AS pinned_8, t0.created_at AS created_at_9, t0.published_at AS published_at_10, t0.updated_at AS updated_at_11, t0.published AS published_12, t0.archived AS archived_13, t0.exclude_from_search AS exclude_from_search_14, t0.seo_title AS seo_title_15, t0.seo_description AS seo_description_16, t0.seo_keywords AS seo_keywords_17, t0.seo_canonical AS seo_canonical_18, t0.seo_key AS seo_key_19, t0.seo_robots AS seo_robots_20, t0.seo_sitemap AS seo_sitemap_21 FROM content t0 WHERE t0.title = ? AND t0.published = ? LIMIT 1

Parameters:

[
  "Politique de Cookies"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.title_h1 AS title_h1_3,
  t0.body AS body_4,
  t0.image AS image_5,
  t0.show_header_image AS show_header_image_6,
  t0.layout AS layout_7,
  t0.pinned AS pinned_8,
  t0.created_at AS created_at_9,
  t0.published_at AS published_at_10,
  t0.updated_at AS updated_at_11,
  t0.published AS published_12,
  t0.archived AS archived_13,
  t0.exclude_from_search AS exclude_from_search_14,
  t0.seo_title AS seo_title_15,
  t0.seo_description AS seo_description_16,
  t0.seo_keywords AS seo_keywords_17,
  t0.seo_canonical AS seo_canonical_18,
  t0.seo_key AS seo_key_19,
  t0.seo_robots AS seo_robots_20,
  t0.seo_sitemap AS seo_sitemap_21
FROM
  content t0
WHERE
  t0.title = ?
  AND t0.published = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_h1 AS title_h1_3, t0.body AS body_4, t0.image AS image_5, t0.show_header_image AS show_header_image_6, t0.layout AS layout_7, t0.pinned AS pinned_8, t0.created_at AS created_at_9, t0.published_at AS published_at_10, t0.updated_at AS updated_at_11, t0.published AS published_12, t0.archived AS archived_13, t0.exclude_from_search AS exclude_from_search_14, t0.seo_title AS seo_title_15, t0.seo_description AS seo_description_16, t0.seo_keywords AS seo_keywords_17, t0.seo_canonical AS seo_canonical_18, t0.seo_key AS seo_key_19, t0.seo_robots AS seo_robots_20, t0.seo_sitemap AS seo_sitemap_21 FROM content t0 WHERE t0.title = 'Politique de Cookies' AND t0.published = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Twig\NavigationExtension->contentPageUrl (line 86)
5	__TwigTemplate_ac17d7eba8c0dc484121197c7bb20642->doDisplay (line 110)
6	Twig\Template->yield (line 411)
7	__TwigTemplate_525ea427e1045890109d836a466ec5ef->block_body (line 100)
8	Twig\Template->yieldBlock (line 458)
9	__TwigTemplate_24f73696464343efad806d743be1601c->doDisplay (line 111)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_525ea427e1045890109d836a466ec5ef->doDisplay (line 60)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_33529af58949218f1c46b8b4ea269a34->doDisplay (line 65)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\DestinationController->continent (line 66)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	App\Resolver\ContinentUrlAliasResolver->resolve (line 44)
26	App\Controller\UrlAliasController->resolve (line 100)
27	App\Controller\UrlAliasController->__invoke (line 60)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 193)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
32	require_once (line 32)
33	require_once (line 5)

31.53 ms
(3.21%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.path AS path_3, t0.entity_type AS entity_type_4, t0.entity_id AS entity_id_5, t0.route_name AS route_name_6, t0.pathauto AS pathauto_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM url_alias t0 WHERE t0.path = ? LIMIT 1

Parameters:

[
  "destinations/oceanie"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.path AS path_3,
  t0.entity_type AS entity_type_4,
  t0.entity_id AS entity_id_5,
  t0.route_name AS route_name_6,
  t0.pathauto AS pathauto_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.parent_id AS parent_id_10
FROM
  url_alias t0
WHERE
  t0.path = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.path AS path_3, t0.entity_type AS entity_type_4, t0.entity_id AS entity_id_5, t0.route_name AS route_name_6, t0.pathauto AS pathauto_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM url_alias t0 WHERE t0.path = 'destinations/oceanie' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\UrlAliasController->__invoke (line 58)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

30.29 ms
(3.09%)

SELECT t0.id AS id_1, t0.slot AS slot_2, t0.content_id AS content_id_3 FROM content_display_slot t0 WHERE t0.content_id = ?

Parameters:

[
  348
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slot AS slot_2,
  t0.content_id AS content_id_3
FROM
  content_display_slot t0
WHERE
  t0.content_id = ?

SELECT t0.id AS id_1, t0.slot AS slot_2, t0.content_id AS content_id_3 FROM content_display_slot t0 WHERE t0.content_id = 348;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Entity\Content->loadDisplaySlots (line 121)
5	Doctrine\ORM\Event\ListenersInvoker->invoke (line 80)
6	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
7	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3214)
8	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 49)
9	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
11	Doctrine\ORM\EntityRepository->findOneBy (line 125)
12	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
13	App\Twig\NavigationExtension->contentPageUrl (line 86)
14	__TwigTemplate_ac17d7eba8c0dc484121197c7bb20642->doDisplay (line 110)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_525ea427e1045890109d836a466ec5ef->block_body (line 100)
17	Twig\Template->yieldBlock (line 458)
18	__TwigTemplate_24f73696464343efad806d743be1601c->doDisplay (line 111)
19	Twig\Template->yield (line 411)
20	__TwigTemplate_525ea427e1045890109d836a466ec5ef->doDisplay (line 60)
21	Twig\Template->yield (line 411)
22	__TwigTemplate_33529af58949218f1c46b8b4ea269a34->doDisplay (line 65)
23	Twig\Template->yield (line 411)
24	Twig\Template->display (line 366)
25	Twig\Template->render (line 381)
26	Twig\TemplateWrapper->render (line 51)
27	Twig\Environment->render (line 333)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
31	App\Controller\DestinationController->continent (line 66)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	App\Resolver\ContinentUrlAliasResolver->resolve (line 44)
35	App\Controller\UrlAliasController->resolve (line 100)
36	App\Controller\UrlAliasController->__invoke (line 60)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
39	Symfony\Component\HttpKernel\Kernel->handle (line 193)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
41	require_once (line 32)
42	require_once (line 5)

10.08 ms
(1.03%)

SELECT t0.id AS id_1, t0.old_path AS old_path_2, t0.target_url AS target_url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.target_alias_id AS target_alias_id_6 FROM url_redirect t0 WHERE t0.old_path = ? LIMIT 1

Parameters:

[
  "destinations/oceanie"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.old_path AS old_path_2,
  t0.target_url AS target_url_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.target_alias_id AS target_alias_id_6
FROM
  url_redirect t0
WHERE
  t0.old_path = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.old_path AS old_path_2, t0.target_url AS target_url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.target_alias_id AS target_alias_id_6 FROM url_redirect t0 WHERE t0.old_path = 'destinations/oceanie' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\UrlAliasController->__invoke (line 53)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

4.32 ms
(0.44%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.title_h1 AS title_h1_4, t0.body AS body_5, t0.intro AS intro_6, t0.image_content AS image_content_7, t0.image AS image_8, t0.main_menu AS main_menu_9, t0.active AS active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.position AS position_13, t0.seo_title AS seo_title_14, t0.seo_description AS seo_description_15, t0.seo_keywords AS seo_keywords_16, t0.seo_canonical AS seo_canonical_17, t0.seo_key AS seo_key_18, t0.seo_robots AS seo_robots_19, t0.seo_sitemap AS seo_sitemap_20 FROM continent t0 WHERE t0.id = ?

Parameters:

[
  49
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.title_h1 AS title_h1_4,
  t0.body AS body_5,
  t0.intro AS intro_6,
  t0.image_content AS image_content_7,
  t0.image AS image_8,
  t0.main_menu AS main_menu_9,
  t0.active AS active_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.position AS position_13,
  t0.seo_title AS seo_title_14,
  t0.seo_description AS seo_description_15,
  t0.seo_keywords AS seo_keywords_16,
  t0.seo_canonical AS seo_canonical_17,
  t0.seo_key AS seo_key_18,
  t0.seo_robots AS seo_robots_19,
  t0.seo_sitemap AS seo_sitemap_20
FROM
  continent t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.title_h1 AS title_h1_4, t0.body AS body_5, t0.intro AS intro_6, t0.image_content AS image_content_7, t0.image AS image_8, t0.main_menu AS main_menu_9, t0.active AS active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.position AS position_13, t0.seo_title AS seo_title_14, t0.seo_description AS seo_description_15, t0.seo_keywords AS seo_keywords_16, t0.seo_canonical AS seo_canonical_17, t0.seo_key AS seo_key_18, t0.seo_robots AS seo_robots_19, t0.seo_sitemap AS seo_sitemap_20 FROM continent t0 WHERE t0.id = 49;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Resolver\ContinentUrlAliasResolver->resolve (line 31)
7	App\Controller\UrlAliasController->resolve (line 100)
8	App\Controller\UrlAliasController->__invoke (line 60)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

1.53 ms
(0.16%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.title_h1 AS title_h1_4, t0.body AS body_5, t0.intro AS intro_6, t0.image_content AS image_content_7, t0.image AS image_8, t0.main_menu AS main_menu_9, t0.active AS active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.position AS position_13, t0.seo_title AS seo_title_14, t0.seo_description AS seo_description_15, t0.seo_keywords AS seo_keywords_16, t0.seo_canonical AS seo_canonical_17, t0.seo_key AS seo_key_18, t0.seo_robots AS seo_robots_19, t0.seo_sitemap AS seo_sitemap_20, t0.continent_id AS continent_id_21 FROM country t0 WHERE t0.continent_id = ?

Parameters:

[
  49
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.title_h1 AS title_h1_4,
  t0.body AS body_5,
  t0.intro AS intro_6,
  t0.image_content AS image_content_7,
  t0.image AS image_8,
  t0.main_menu AS main_menu_9,
  t0.active AS active_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.position AS position_13,
  t0.seo_title AS seo_title_14,
  t0.seo_description AS seo_description_15,
  t0.seo_keywords AS seo_keywords_16,
  t0.seo_canonical AS seo_canonical_17,
  t0.seo_key AS seo_key_18,
  t0.seo_robots AS seo_robots_19,
  t0.seo_sitemap AS seo_sitemap_20,
  t0.continent_id AS continent_id_21
FROM
  country t0
WHERE
  t0.continent_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.title_h1 AS title_h1_4, t0.body AS body_5, t0.intro AS intro_6, t0.image_content AS image_content_7, t0.image AS image_8, t0.main_menu AS main_menu_9, t0.active AS active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.position AS position_13, t0.seo_title AS seo_title_14, t0.seo_description AS seo_description_15, t0.seo_keywords AS seo_keywords_16, t0.seo_canonical AS seo_canonical_17, t0.seo_key AS seo_key_18, t0.seo_robots AS seo_robots_19, t0.seo_sitemap AS seo_sitemap_20, t0.continent_id AS continent_id_21 FROM country t0 WHERE t0.continent_id = 49;

#	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 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 159)
7	App\Controller\DestinationController->continent (line 72)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	App\Resolver\ContinentUrlAliasResolver->resolve (line 44)
11	App\Controller\UrlAliasController->resolve (line 100)
12	App\Controller\UrlAliasController->__invoke (line 60)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
17	require_once (line 32)
18	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
legacy_east	doctrine.dbal.legacy_east_connection
legacy_west	doctrine.dbal.legacy_west_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\MenuLink	57
App\Entity\UrlAlias	31
App\Entity\Menu	3
App\Entity\Content	2
App\Entity\Destination\Continent	1
App\Entity\Destination\Country	1

Entities Mapping

Class	Mapping errors
App\Entity\UrlRedirect	No errors.
App\Entity\UrlAlias	No errors.
App\Entity\Embeddable\Seo	No errors.
App\Entity\Destination\Continent	No errors.
App\Entity\Destination\Country	No errors.
App\Entity\Destination\Region	No errors.
App\Entity\Embeddable\Stay	No errors.
App\Entity\Embeddable\EcoImpact	No errors.
App\Entity\TravelDescription	No errors.
App\Entity\Menu	No errors.
App\Entity\MenuLink	No errors.
App\Entity\Content	No errors.
App\Entity\Content\ContentGallery	No errors.
App\Entity\Content\ContentTab	No errors.
App\Entity\Structural\ContentDisplaySlot	No errors.

Symfony Profiler

GET https://www.leroy.goconcept8.be/destinations/oceanie

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping