Symfony Profiler

Query Metrics

178 Database Queries

35 Different statements

47.54 ms Query time

0 Invalid entities

154 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

12.07 ms
(25.39%)

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_7fff67980e99c9cf4b645ec8552d0a46->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\TravelDescriptionController->show (line 60)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

8.92 ms
(18.77%)

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_7fff67980e99c9cf4b645ec8552d0a46->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\TravelDescriptionController->show (line 60)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

3.86 ms
(8.13%)

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:

[
  "travel-description"
  7336
]

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 = 'travel-description' AND t0.entity_id = 7336 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\TravelDescription->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\TravelDescriptionUrlAliasResolver->resolve (line 39)
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)

3.70 ms
(7.78%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.width AS width_4, t0.height AS height_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM image_style t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "header-small"
]

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,
  t0.width AS width_4,
  t0.height AS height_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  image_style t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.width AS width_4, t0.height AS height_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM image_style t0 WHERE t0.name = 'header-small' 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\ImageStyleRepository->findByName (line 21)
5	App\Media\ImageStyleResolver->resolve (line 31)
6	App\Media\ResponsiveImageResolver->resolveBreakpoints (line 129)
7	App\Media\ResponsiveImageResolver->picture (line 37)
8	__TwigTemplate_7fff67980e99c9cf4b645ec8552d0a46->block_content (line 260)
9	Twig\Template->yieldBlock (line 458)
10	__TwigTemplate_525ea427e1045890109d836a466ec5ef->block_body (line 95)
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_7fff67980e99c9cf4b645ec8552d0a46->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\TravelDescriptionController->show (line 60)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

2.41 ms
(5.07%)

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.description AS description_4, t0.description2 AS description2_5, t0.address AS address_6, t0.zip AS zip_7, t0.coordinates AS coordinates_8, t0.map_url AS map_url_9, t0.note AS note_10, t0.active AS active_11, t0.imported_at AS imported_at_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.country_id AS country_id_15 FROM departure_location t0 WHERE t0.id = ?

Parameters:

[
  421
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.external_id AS external_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.description2 AS description2_5,
  t0.address AS address_6,
  t0.zip AS zip_7,
  t0.coordinates AS coordinates_8,
  t0.map_url AS map_url_9,
  t0.note AS note_10,
  t0.active AS active_11,
  t0.imported_at AS imported_at_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.country_id AS country_id_15
FROM
  departure_location t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.description AS description_4, t0.description2 AS description2_5, t0.address AS address_6, t0.zip AS zip_7, t0.coordinates AS coordinates_8, t0.map_url AS map_url_9, t0.note AS note_10, t0.active AS active_11, t0.imported_at AS imported_at_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.country_id AS country_id_15 FROM departure_location t0 WHERE t0.id = 421;

#	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\Imported\DepartureLocation::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Imported\DepartureLocation->__get (line 153)
7	App\Entity\Imported\DepartureLocation->getName (line 90)
8	Twig\Extension\CoreExtension->getAttribute (line 1928)
9	__TwigTemplate_7fff67980e99c9cf4b645ec8552d0a46::block_content (line 852)
10	Twig\Template->yieldBlock (line 458)
11	__TwigTemplate_525ea427e1045890109d836a466ec5ef->block_body (line 95)
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_7fff67980e99c9cf4b645ec8552d0a46->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\TravelDescriptionController->show (line 60)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

2.40 ms
(5.05%)

SELECT t0.id AS id_1, t0.stage AS stage_2, t0.title AS title_3, t0.content AS content_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.travel_description_id AS travel_description_id_8 FROM travel_programme_item t0 WHERE t0.travel_description_id = ?

Parameters:

[
  7336
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.stage AS stage_2,
  t0.title AS title_3,
  t0.content AS content_4,
  t0.position AS position_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.travel_description_id AS travel_description_id_8
FROM
  travel_programme_item t0
WHERE
  t0.travel_description_id = ?

SELECT t0.id AS id_1, t0.stage AS stage_2, t0.title AS title_3, t0.content AS content_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.travel_description_id AS travel_description_id_8 FROM travel_programme_item t0 WHERE t0.travel_description_id = 7336;

#	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\TravelDescriptionController->show (line 82)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

1.16 ms
(2.43%)

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:

[
  "voyager/voyages-leroy/foret-noire-2"
]

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 = 'voyager/voyages-leroy/foret-noire-2' 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)

0.95 ms
(1.99%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.subtitle AS subtitle_2, t0_.intro AS intro_3, t0_.thumb_label AS thumb_label_4, t0_.image AS image_5, t0_.image_header AS image_header_6, t0_.tooltip AS tooltip_7, t0_.tooltip_link AS tooltip_link_8, t0_.highlighted AS highlighted_9, t0_.active AS active_10, t0_.position AS position_11, t0_.created_at AS created_at_12, t0_.updated_at AS updated_at_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_.taxonomy_id AS taxonomy_id_21, t0_.logo_id AS logo_id_22 FROM travel_term t0_ WHERE EXISTS (SELECT 1 FROM travel_description_travel_term t1_ WHERE t1_.travel_term_id = t0_.id AND t1_.travel_description_id IN (?)) AND t0_.active = 1 ORDER BY t0_.position ASC LIMIT 4

Parameters:

[
  7336
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.subtitle AS subtitle_2,
  t0_.intro AS intro_3,
  t0_.thumb_label AS thumb_label_4,
  t0_.image AS image_5,
  t0_.image_header AS image_header_6,
  t0_.tooltip AS tooltip_7,
  t0_.tooltip_link AS tooltip_link_8,
  t0_.highlighted AS highlighted_9,
  t0_.active AS active_10,
  t0_.position AS position_11,
  t0_.created_at AS created_at_12,
  t0_.updated_at AS updated_at_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_.taxonomy_id AS taxonomy_id_21,
  t0_.logo_id AS logo_id_22
FROM
  travel_term t0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      travel_description_travel_term t1_
    WHERE
      t1_.travel_term_id = t0_.id
      AND t1_.travel_description_id IN (?)
  )
  AND t0_.active = 1
ORDER BY
  t0_.position ASC
LIMIT
  4

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.subtitle AS subtitle_2, t0_.intro AS intro_3, t0_.thumb_label AS thumb_label_4, t0_.image AS image_5, t0_.image_header AS image_header_6, t0_.tooltip AS tooltip_7, t0_.tooltip_link AS tooltip_link_8, t0_.highlighted AS highlighted_9, t0_.active AS active_10, t0_.position AS position_11, t0_.created_at AS created_at_12, t0_.updated_at AS updated_at_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_.taxonomy_id AS taxonomy_id_21, t0_.logo_id AS logo_id_22 FROM travel_term t0_ WHERE EXISTS (SELECT 1 FROM travel_description_travel_term t1_ WHERE t1_.travel_term_id = t0_.id AND t1_.travel_description_id IN (7336)) AND t0_.active = 1 ORDER BY t0_.position ASC 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 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\TravelTermRepository->findByTravelDescription (line 40)
7	App\Controller\TravelDescriptionController->show (line 71)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

0.84 ms
(1.77%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.width AS width_4, t0.height AS height_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM image_style t0 WHERE t0.id = ?

Parameters:

[
  104
]

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,
  t0.width AS width_4,
  t0.height AS height_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  image_style t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.width AS width_4, t0.height AS height_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM image_style t0 WHERE t0.id = 104;

#	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\ImageStyle::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\ImageStyle->__get (line 153)
7	App\Entity\ImageStyle->getName (line 52)
8	App\Media\ResponsiveImageResolver->resolveBreakpoints (line 129)
9	App\Media\ResponsiveImageResolver->picture (line 37)
10	__TwigTemplate_7fff67980e99c9cf4b645ec8552d0a46->block_content (line 260)
11	Twig\Template->yieldBlock (line 458)
12	__TwigTemplate_525ea427e1045890109d836a466ec5ef->block_body (line 95)
13	Twig\Template->yieldBlock (line 458)
14	__TwigTemplate_24f73696464343efad806d743be1601c->doDisplay (line 111)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_525ea427e1045890109d836a466ec5ef->doDisplay (line 60)
17	Twig\Template->yield (line 411)
18	__TwigTemplate_7fff67980e99c9cf4b645ec8552d0a46->doDisplay (line 65)
19	Twig\Template->yield (line 411)
20	Twig\Template->display (line 366)
21	Twig\Template->render (line 381)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
27	App\Controller\TravelDescriptionController->show (line 60)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
31	App\Controller\UrlAliasController->resolve (line 100)
32	App\Controller\UrlAliasController->__invoke (line 60)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 193)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
37	require_once (line 32)
38	require_once (line 5)

0.79 ms
(1.66%)

SELECT t0.id AS id_1, t0.offer_code AS offer_code_2, t0.offer_type AS offer_type_3, t0.unique_price AS unique_price_4, t0.unique_city AS unique_city_5, t0.unique_description AS unique_description_6, t0.unique_division AS unique_division_7, t0.variant_label AS variant_label_8, t0.canonical AS canonical_9, t0.title AS title_10, t0.teaser AS teaser_11, t0.description AS description_12, t0.intro AS intro_13, t0.chapeau1 AS chapeau1_14, t0.chapeau2 AS chapeau2_15, t0.qualite_leo AS qualite_leo_16, t0.entree_site AS entree_site_17, t0.price_comment AS price_comment_18, t0.gifts AS gifts_19, t0.good_to_know AS good_to_know_20, t0.important_info AS important_info_21, t0.duration AS duration_22, t0.duration_only_on_web AS duration_only_on_web_23, t0.minimum_length AS minimum_length_24, t0.is_stay AS is_stay_25, t0.published AS published_26, t0.special_offer_enabled AS special_offer_enabled_27, t0.special_offer_url AS special_offer_url_28, t0.not_in_brochure AS not_in_brochure_29, t0.brochure_page AS brochure_page_30, t0.brochure_column AS brochure_column_31, t0.print_title AS print_title_32, t0.print_intro AS print_intro_33, t0.print_schedule AS print_schedule_34, t0.print_starting_price AS print_starting_price_35, t0.print_price_notes AS print_price_notes_36, t0.print_date AS print_date_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.stay_services AS stay_services_40, t0.stay_room AS stay_room_41, t0.stay_catering AS stay_catering_42, t0.stay_animation AS stay_animation_43, t0.eco_impact_formula AS eco_impact_formula_44, t0.eco_impact_type AS eco_impact_type_45, t0.eco_impact_distance AS eco_impact_distance_46, t0.eco_impact_emissions AS eco_impact_emissions_47, t0.eco_impact_contribution AS eco_impact_contribution_48, t0.seo_title AS seo_title_49, t0.seo_description AS seo_description_50, t0.seo_keywords AS seo_keywords_51, t0.seo_canonical AS seo_canonical_52, t0.seo_key AS seo_key_53, t0.seo_robots AS seo_robots_54, t0.seo_sitemap AS seo_sitemap_55, t0.variant_group_id AS variant_group_id_56, t0.type_id AS type_id_57, t0.brochure_id AS brochure_id_58, t0.print_thematique_id AS print_thematique_id_59 FROM travel_description t0 WHERE t0.id = ?

Parameters:

[
  7336
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.offer_code AS offer_code_2,
  t0.offer_type AS offer_type_3,
  t0.unique_price AS unique_price_4,
  t0.unique_city AS unique_city_5,
  t0.unique_description AS unique_description_6,
  t0.unique_division AS unique_division_7,
  t0.variant_label AS variant_label_8,
  t0.canonical AS canonical_9,
  t0.title AS title_10,
  t0.teaser AS teaser_11,
  t0.description AS description_12,
  t0.intro AS intro_13,
  t0.chapeau1 AS chapeau1_14,
  t0.chapeau2 AS chapeau2_15,
  t0.qualite_leo AS qualite_leo_16,
  t0.entree_site AS entree_site_17,
  t0.price_comment AS price_comment_18,
  t0.gifts AS gifts_19,
  t0.good_to_know AS good_to_know_20,
  t0.important_info AS important_info_21,
  t0.duration AS duration_22,
  t0.duration_only_on_web AS duration_only_on_web_23,
  t0.minimum_length AS minimum_length_24,
  t0.is_stay AS is_stay_25,
  t0.published AS published_26,
  t0.special_offer_enabled AS special_offer_enabled_27,
  t0.special_offer_url AS special_offer_url_28,
  t0.not_in_brochure AS not_in_brochure_29,
  t0.brochure_page AS brochure_page_30,
  t0.brochure_column AS brochure_column_31,
  t0.print_title AS print_title_32,
  t0.print_intro AS print_intro_33,
  t0.print_schedule AS print_schedule_34,
  t0.print_starting_price AS print_starting_price_35,
  t0.print_price_notes AS print_price_notes_36,
  t0.print_date AS print_date_37,
  t0.created_at AS created_at_38,
  t0.updated_at AS updated_at_39,
  t0.stay_services AS stay_services_40,
  t0.stay_room AS stay_room_41,
  t0.stay_catering AS stay_catering_42,
  t0.stay_animation AS stay_animation_43,
  t0.eco_impact_formula AS eco_impact_formula_44,
  t0.eco_impact_type AS eco_impact_type_45,
  t0.eco_impact_distance AS eco_impact_distance_46,
  t0.eco_impact_emissions AS eco_impact_emissions_47,
  t0.eco_impact_contribution AS eco_impact_contribution_48,
  t0.seo_title AS seo_title_49,
  t0.seo_description AS seo_description_50,
  t0.seo_keywords AS seo_keywords_51,
  t0.seo_canonical AS seo_canonical_52,
  t0.seo_key AS seo_key_53,
  t0.seo_robots AS seo_robots_54,
  t0.seo_sitemap AS seo_sitemap_55,
  t0.variant_group_id AS variant_group_id_56,
  t0.type_id AS type_id_57,
  t0.brochure_id AS brochure_id_58,
  t0.print_thematique_id AS print_thematique_id_59
FROM
  travel_description t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.offer_code AS offer_code_2, t0.offer_type AS offer_type_3, t0.unique_price AS unique_price_4, t0.unique_city AS unique_city_5, t0.unique_description AS unique_description_6, t0.unique_division AS unique_division_7, t0.variant_label AS variant_label_8, t0.canonical AS canonical_9, t0.title AS title_10, t0.teaser AS teaser_11, t0.description AS description_12, t0.intro AS intro_13, t0.chapeau1 AS chapeau1_14, t0.chapeau2 AS chapeau2_15, t0.qualite_leo AS qualite_leo_16, t0.entree_site AS entree_site_17, t0.price_comment AS price_comment_18, t0.gifts AS gifts_19, t0.good_to_know AS good_to_know_20, t0.important_info AS important_info_21, t0.duration AS duration_22, t0.duration_only_on_web AS duration_only_on_web_23, t0.minimum_length AS minimum_length_24, t0.is_stay AS is_stay_25, t0.published AS published_26, t0.special_offer_enabled AS special_offer_enabled_27, t0.special_offer_url AS special_offer_url_28, t0.not_in_brochure AS not_in_brochure_29, t0.brochure_page AS brochure_page_30, t0.brochure_column AS brochure_column_31, t0.print_title AS print_title_32, t0.print_intro AS print_intro_33, t0.print_schedule AS print_schedule_34, t0.print_starting_price AS print_starting_price_35, t0.print_price_notes AS print_price_notes_36, t0.print_date AS print_date_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.stay_services AS stay_services_40, t0.stay_room AS stay_room_41, t0.stay_catering AS stay_catering_42, t0.stay_animation AS stay_animation_43, t0.eco_impact_formula AS eco_impact_formula_44, t0.eco_impact_type AS eco_impact_type_45, t0.eco_impact_distance AS eco_impact_distance_46, t0.eco_impact_emissions AS eco_impact_emissions_47, t0.eco_impact_contribution AS eco_impact_contribution_48, t0.seo_title AS seo_title_49, t0.seo_description AS seo_description_50, t0.seo_keywords AS seo_keywords_51, t0.seo_canonical AS seo_canonical_52, t0.seo_key AS seo_key_53, t0.seo_robots AS seo_robots_54, t0.seo_sitemap AS seo_sitemap_55, t0.variant_group_id AS variant_group_id_56, t0.type_id AS type_id_57, t0.brochure_id AS brochure_id_58, t0.print_thematique_id AS print_thematique_id_59 FROM travel_description t0 WHERE t0.id = 7336;

#	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\TravelDescriptionUrlAliasResolver->resolve (line 39)
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)

0.72 ms
(1.51%)

SELECT t0.id AS id_1, t0.date_start AS date_start_2, t0.date_end AS date_end_3, t0.length AS length_4, t0.price AS price_5, t0.price_full AS price_full_6, t0.price_type AS price_type_7, t0.promo_price AS promo_price_8, t0.available AS available_9, t0.length_unit AS length_unit_10, t0.seat_code AS seat_code_11, t0.transport_code AS transport_code_12, t0.imported_at AS imported_at_13, t0.travel_offer_id AS travel_offer_id_14 FROM price_entry t0 WHERE t0.travel_offer_id = ?

Parameters:

[
  2059
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_start AS date_start_2,
  t0.date_end AS date_end_3,
  t0.length AS length_4,
  t0.price AS price_5,
  t0.price_full AS price_full_6,
  t0.price_type AS price_type_7,
  t0.promo_price AS promo_price_8,
  t0.available AS available_9,
  t0.length_unit AS length_unit_10,
  t0.seat_code AS seat_code_11,
  t0.transport_code AS transport_code_12,
  t0.imported_at AS imported_at_13,
  t0.travel_offer_id AS travel_offer_id_14
FROM
  price_entry t0
WHERE
  t0.travel_offer_id = ?

SELECT t0.id AS id_1, t0.date_start AS date_start_2, t0.date_end AS date_end_3, t0.length AS length_4, t0.price AS price_5, t0.price_full AS price_full_6, t0.price_type AS price_type_7, t0.promo_price AS promo_price_8, t0.available AS available_9, t0.length_unit AS length_unit_10, t0.seat_code AS seat_code_11, t0.transport_code AS transport_code_12, t0.imported_at AS imported_at_13, t0.travel_offer_id AS travel_offer_id_14 FROM price_entry t0 WHERE t0.travel_offer_id = 2059;

#	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\Seo\JsonLd\TravelDescriptionPriceResolver->resolveStartingPrice (line 49)
5	App\Controller\TravelDescriptionController->show (line 77)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
9	App\Controller\UrlAliasController->resolve (line 100)
10	App\Controller\UrlAliasController->__invoke (line 60)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
15	require_once (line 32)
16	require_once (line 5)

0.64 ms
(1.35%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.description AS description_4, t0.division AS division_5, t0.imported_at AS imported_at_6 FROM travel_offer t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "DFOREN01"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.code AS code_3,
  t0.description AS description_4,
  t0.division AS division_5,
  t0.imported_at AS imported_at_6
FROM
  travel_offer t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.description AS description_4, t0.division AS division_5, t0.imported_at AS imported_at_6 FROM travel_offer t0 WHERE t0.code = 'DFOREN01' 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\TravelDescriptionRepository->getTravelOffer (line 86)
5	App\Controller\TravelDescriptionController->show (line 51)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
9	App\Controller\UrlAliasController->resolve (line 100)
10	App\Controller\UrlAliasController->__invoke (line 60)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
15	require_once (line 32)
16	require_once (line 5)

0.58 ms
(1.22%)

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_7fff67980e99c9cf4b645ec8552d0a46->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\TravelDescriptionController->show (line 60)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

0.57 ms
(1.20%)

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:

[
  "voyager/voyages-leroy/foret-noire-2"
]

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 = 'voyager/voyages-leroy/foret-noire-2' 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)

0.57 ms
(1.19%)

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:

[
  8000
]

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 = 8000 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\Thematique->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\Persisters\Entity\BasicEntityPersister->loadById (line 756)
13	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
14	Proxies\__CG__\App\Entity\Thematique::Doctrine\ORM\Proxy\{closure} (line 373)
15	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
16	Proxies\__CG__\App\Entity\Thematique->__get (line 153)
17	App\Entity\Thematique->getTitle (line 98)
18	Twig\Extension\CoreExtension->getAttribute (line 1928)
19	__TwigTemplate_7fff67980e99c9cf4b645ec8552d0a46::block_content (line 329)
20	Twig\Template->yieldBlock (line 458)
21	__TwigTemplate_525ea427e1045890109d836a466ec5ef->block_body (line 95)
22	Twig\Template->yieldBlock (line 458)
23	__TwigTemplate_24f73696464343efad806d743be1601c->doDisplay (line 111)
24	Twig\Template->yield (line 411)
25	__TwigTemplate_525ea427e1045890109d836a466ec5ef->doDisplay (line 60)
26	Twig\Template->yield (line 411)
27	__TwigTemplate_7fff67980e99c9cf4b645ec8552d0a46->doDisplay (line 65)
28	Twig\Template->yield (line 411)
29	Twig\Template->display (line 366)
30	Twig\Template->render (line 381)
31	Twig\TemplateWrapper->render (line 51)
32	Twig\Environment->render (line 333)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
36	App\Controller\TravelDescriptionController->show (line 60)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
39	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
40	App\Controller\UrlAliasController->resolve (line 100)
41	App\Controller\UrlAliasController->__invoke (line 60)
42	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
43	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
44	Symfony\Component\HttpKernel\Kernel->handle (line 193)
45	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
46	require_once (line 32)
47	require_once (line 5)

0.51 ms
(1.07%)

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_7fff67980e99c9cf4b645ec8552d0a46->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\TravelDescriptionController->show (line 60)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

0.49 ms
(1.04%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.min_width AS min_width_4 FROM breakpoint t0 WHERE t0.id = ?

Parameters:

[
  1
]

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,
  t0.min_width AS min_width_4
FROM
  breakpoint t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.min_width AS min_width_4 FROM breakpoint t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Breakpoint::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Breakpoint->__get (line 153)
7	App\Entity\Breakpoint->getMinWidth (line 70)
8	App\Media\ResponsiveImageResolver->resolveBreakpoints (line 127)
9	App\Media\ResponsiveImageResolver->picture (line 37)
10	__TwigTemplate_7fff67980e99c9cf4b645ec8552d0a46->block_content (line 260)
11	Twig\Template->yieldBlock (line 458)
12	__TwigTemplate_525ea427e1045890109d836a466ec5ef->block_body (line 95)
13	Twig\Template->yieldBlock (line 458)
14	__TwigTemplate_24f73696464343efad806d743be1601c->doDisplay (line 111)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_525ea427e1045890109d836a466ec5ef->doDisplay (line 60)
17	Twig\Template->yield (line 411)
18	__TwigTemplate_7fff67980e99c9cf4b645ec8552d0a46->doDisplay (line 65)
19	Twig\Template->yield (line 411)
20	Twig\Template->display (line 366)
21	Twig\Template->render (line 381)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
27	App\Controller\TravelDescriptionController->show (line 60)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
31	App\Controller\UrlAliasController->resolve (line 100)
32	App\Controller\UrlAliasController->__invoke (line 60)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 193)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
37	require_once (line 32)
38	require_once (line 5)

0.47 ms
(0.98%)

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.name AS name_2, c0_.title_h1 AS title_h1_3, c0_.body AS body_4, c0_.intro AS intro_5, c0_.image_content AS image_content_6, c0_.image AS image_7, c0_.main_menu AS main_menu_8, c0_.active AS active_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.position AS position_12, c0_.seo_title AS seo_title_13, c0_.seo_description AS seo_description_14, c0_.seo_keywords AS seo_keywords_15, c0_.seo_canonical AS seo_canonical_16, c0_.seo_key AS seo_key_17, c0_.seo_robots AS seo_robots_18, c0_.seo_sitemap AS seo_sitemap_19, c0_.continent_id AS continent_id_20 FROM country c0_ WHERE EXISTS (SELECT 1 FROM travel_description_country t1_ WHERE t1_.country_id = c0_.id AND t1_.travel_description_id IN (?)) LIMIT 1

Parameters:

[
  7336
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.name AS name_2,
  c0_.title_h1 AS title_h1_3,
  c0_.body AS body_4,
  c0_.intro AS intro_5,
  c0_.image_content AS image_content_6,
  c0_.image AS image_7,
  c0_.main_menu AS main_menu_8,
  c0_.active AS active_9,
  c0_.created_at AS created_at_10,
  c0_.updated_at AS updated_at_11,
  c0_.position AS position_12,
  c0_.seo_title AS seo_title_13,
  c0_.seo_description AS seo_description_14,
  c0_.seo_keywords AS seo_keywords_15,
  c0_.seo_canonical AS seo_canonical_16,
  c0_.seo_key AS seo_key_17,
  c0_.seo_robots AS seo_robots_18,
  c0_.seo_sitemap AS seo_sitemap_19,
  c0_.continent_id AS continent_id_20
FROM
  country c0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      travel_description_country t1_
    WHERE
      t1_.country_id = c0_.id
      AND t1_.travel_description_id IN (?)
  )
LIMIT
  1

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.name AS name_2, c0_.title_h1 AS title_h1_3, c0_.body AS body_4, c0_.intro AS intro_5, c0_.image_content AS image_content_6, c0_.image AS image_7, c0_.main_menu AS main_menu_8, c0_.active AS active_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.position AS position_12, c0_.seo_title AS seo_title_13, c0_.seo_description AS seo_description_14, c0_.seo_keywords AS seo_keywords_15, c0_.seo_canonical AS seo_canonical_16, c0_.seo_key AS seo_key_17, c0_.seo_robots AS seo_robots_18, c0_.seo_sitemap AS seo_sitemap_19, c0_.continent_id AS continent_id_20 FROM country c0_ WHERE EXISTS (SELECT 1 FROM travel_description_country t1_ WHERE t1_.country_id = c0_.id AND t1_.travel_description_id IN (7336)) LIMIT 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->getOneOrNullResult (line 737)
6	App\Controller\TravelDescriptionController->resolveDestination (line 150)
7	App\Controller\TravelDescriptionController->show (line 58)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

0.45 ms
(0.95%)

SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.name AS name_2, r0_.title_h1 AS title_h1_3, r0_.period AS period_4, r0_.time_difference AS time_difference_5, r0_.currency AS currency_6, r0_.formalities AS formalities_7, r0_.good_to_know AS good_to_know_8, r0_.body AS body_9, r0_.intro AS intro_10, r0_.image_content AS image_content_11, r0_.image AS image_12, r0_.main_menu AS main_menu_13, r0_.favorite AS favorite_14, r0_.active AS active_15, r0_.created_at AS created_at_16, r0_.updated_at AS updated_at_17, r0_.seo_title AS seo_title_18, r0_.seo_description AS seo_description_19, r0_.seo_keywords AS seo_keywords_20, r0_.seo_canonical AS seo_canonical_21, r0_.seo_key AS seo_key_22, r0_.seo_robots AS seo_robots_23, r0_.seo_sitemap AS seo_sitemap_24 FROM region r0_ WHERE EXISTS (SELECT 1 FROM travel_description_region t1_ WHERE t1_.region_id = r0_.id AND t1_.travel_description_id IN (?))

Parameters:

[
  7336
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.code AS code_1,
  r0_.name AS name_2,
  r0_.title_h1 AS title_h1_3,
  r0_.period AS period_4,
  r0_.time_difference AS time_difference_5,
  r0_.currency AS currency_6,
  r0_.formalities AS formalities_7,
  r0_.good_to_know AS good_to_know_8,
  r0_.body AS body_9,
  r0_.intro AS intro_10,
  r0_.image_content AS image_content_11,
  r0_.image AS image_12,
  r0_.main_menu AS main_menu_13,
  r0_.favorite AS favorite_14,
  r0_.active AS active_15,
  r0_.created_at AS created_at_16,
  r0_.updated_at AS updated_at_17,
  r0_.seo_title AS seo_title_18,
  r0_.seo_description AS seo_description_19,
  r0_.seo_keywords AS seo_keywords_20,
  r0_.seo_canonical AS seo_canonical_21,
  r0_.seo_key AS seo_key_22,
  r0_.seo_robots AS seo_robots_23,
  r0_.seo_sitemap AS seo_sitemap_24
FROM
  region r0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      travel_description_region t1_
    WHERE
      t1_.region_id = r0_.id
      AND t1_.travel_description_id IN (?)
  )

SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.name AS name_2, r0_.title_h1 AS title_h1_3, r0_.period AS period_4, r0_.time_difference AS time_difference_5, r0_.currency AS currency_6, r0_.formalities AS formalities_7, r0_.good_to_know AS good_to_know_8, r0_.body AS body_9, r0_.intro AS intro_10, r0_.image_content AS image_content_11, r0_.image AS image_12, r0_.main_menu AS main_menu_13, r0_.favorite AS favorite_14, r0_.active AS active_15, r0_.created_at AS created_at_16, r0_.updated_at AS updated_at_17, r0_.seo_title AS seo_title_18, r0_.seo_description AS seo_description_19, r0_.seo_keywords AS seo_keywords_20, r0_.seo_canonical AS seo_canonical_21, r0_.seo_key AS seo_key_22, r0_.seo_robots AS seo_robots_23, r0_.seo_sitemap AS seo_sitemap_24 FROM region r0_ WHERE EXISTS (SELECT 1 FROM travel_description_region t1_ WHERE t1_.region_id = r0_.id AND t1_.travel_description_id IN (7336));

#	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	App\Repository\TravelDescriptionRepository->findRelated (line 113)
7	App\Controller\TravelDescriptionController->show (line 96)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

0.43 ms
(0.91%)

SELECT t0.id AS id_1, t0.time AS time_2, t0.imported_at AS imported_at_3, t0.travel_offer_id AS travel_offer_id_4, t0.departure_location_id AS departure_location_id_5 FROM travel_departure_point t0 WHERE t0.travel_offer_id = ?

Parameters:

[
  2059
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.time AS time_2,
  t0.imported_at AS imported_at_3,
  t0.travel_offer_id AS travel_offer_id_4,
  t0.departure_location_id AS departure_location_id_5
FROM
  travel_departure_point t0
WHERE
  t0.travel_offer_id = ?

SELECT t0.id AS id_1, t0.time AS time_2, t0.imported_at AS imported_at_3, t0.travel_offer_id AS travel_offer_id_4, t0.departure_location_id AS departure_location_id_5 FROM travel_departure_point t0 WHERE t0.travel_offer_id = 2059;

#	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\Controller\TravelDescriptionController->show (line 52)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
8	App\Controller\UrlAliasController->resolve (line 100)
9	App\Controller\UrlAliasController->__invoke (line 60)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

0.43 ms
(0.90%)

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.name AS name_2, c0_.title_h1 AS title_h1_3, c0_.body AS body_4, c0_.intro AS intro_5, c0_.image_content AS image_content_6, c0_.image AS image_7, c0_.main_menu AS main_menu_8, c0_.active AS active_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.position AS position_12, c0_.seo_title AS seo_title_13, c0_.seo_description AS seo_description_14, c0_.seo_keywords AS seo_keywords_15, c0_.seo_canonical AS seo_canonical_16, c0_.seo_key AS seo_key_17, c0_.seo_robots AS seo_robots_18, c0_.seo_sitemap AS seo_sitemap_19, c0_.continent_id AS continent_id_20 FROM country c0_ WHERE EXISTS (SELECT 1 FROM travel_description_country t1_ WHERE t1_.country_id = c0_.id AND t1_.travel_description_id IN (?))

Parameters:

[
  7336
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.name AS name_2,
  c0_.title_h1 AS title_h1_3,
  c0_.body AS body_4,
  c0_.intro AS intro_5,
  c0_.image_content AS image_content_6,
  c0_.image AS image_7,
  c0_.main_menu AS main_menu_8,
  c0_.active AS active_9,
  c0_.created_at AS created_at_10,
  c0_.updated_at AS updated_at_11,
  c0_.position AS position_12,
  c0_.seo_title AS seo_title_13,
  c0_.seo_description AS seo_description_14,
  c0_.seo_keywords AS seo_keywords_15,
  c0_.seo_canonical AS seo_canonical_16,
  c0_.seo_key AS seo_key_17,
  c0_.seo_robots AS seo_robots_18,
  c0_.seo_sitemap AS seo_sitemap_19,
  c0_.continent_id AS continent_id_20
FROM
  country c0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      travel_description_country t1_
    WHERE
      t1_.country_id = c0_.id
      AND t1_.travel_description_id IN (?)
  )

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.name AS name_2, c0_.title_h1 AS title_h1_3, c0_.body AS body_4, c0_.intro AS intro_5, c0_.image_content AS image_content_6, c0_.image AS image_7, c0_.main_menu AS main_menu_8, c0_.active AS active_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.position AS position_12, c0_.seo_title AS seo_title_13, c0_.seo_description AS seo_description_14, c0_.seo_keywords AS seo_keywords_15, c0_.seo_canonical AS seo_canonical_16, c0_.seo_key AS seo_key_17, c0_.seo_robots AS seo_robots_18, c0_.seo_sitemap AS seo_sitemap_19, c0_.continent_id AS continent_id_20 FROM country c0_ WHERE EXISTS (SELECT 1 FROM travel_description_country t1_ WHERE t1_.country_id = c0_.id AND t1_.travel_description_id IN (7336));

#	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	App\Repository\TravelDescriptionRepository->findRelated (line 125)
7	App\Controller\TravelDescriptionController->show (line 96)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

0.42 ms
(0.88%)

SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.name AS name_2, r0_.title_h1 AS title_h1_3, r0_.period AS period_4, r0_.time_difference AS time_difference_5, r0_.currency AS currency_6, r0_.formalities AS formalities_7, r0_.good_to_know AS good_to_know_8, r0_.body AS body_9, r0_.intro AS intro_10, r0_.image_content AS image_content_11, r0_.image AS image_12, r0_.main_menu AS main_menu_13, r0_.favorite AS favorite_14, r0_.active AS active_15, r0_.created_at AS created_at_16, r0_.updated_at AS updated_at_17, r0_.seo_title AS seo_title_18, r0_.seo_description AS seo_description_19, r0_.seo_keywords AS seo_keywords_20, r0_.seo_canonical AS seo_canonical_21, r0_.seo_key AS seo_key_22, r0_.seo_robots AS seo_robots_23, r0_.seo_sitemap AS seo_sitemap_24 FROM region r0_ WHERE EXISTS (SELECT 1 FROM travel_description_region t1_ WHERE t1_.region_id = r0_.id AND t1_.travel_description_id IN (?)) LIMIT 1

Parameters:

[
  7336
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.code AS code_1,
  r0_.name AS name_2,
  r0_.title_h1 AS title_h1_3,
  r0_.period AS period_4,
  r0_.time_difference AS time_difference_5,
  r0_.currency AS currency_6,
  r0_.formalities AS formalities_7,
  r0_.good_to_know AS good_to_know_8,
  r0_.body AS body_9,
  r0_.intro AS intro_10,
  r0_.image_content AS image_content_11,
  r0_.image AS image_12,
  r0_.main_menu AS main_menu_13,
  r0_.favorite AS favorite_14,
  r0_.active AS active_15,
  r0_.created_at AS created_at_16,
  r0_.updated_at AS updated_at_17,
  r0_.seo_title AS seo_title_18,
  r0_.seo_description AS seo_description_19,
  r0_.seo_keywords AS seo_keywords_20,
  r0_.seo_canonical AS seo_canonical_21,
  r0_.seo_key AS seo_key_22,
  r0_.seo_robots AS seo_robots_23,
  r0_.seo_sitemap AS seo_sitemap_24
FROM
  region r0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      travel_description_region t1_
    WHERE
      t1_.region_id = r0_.id
      AND t1_.travel_description_id IN (?)
  )
LIMIT
  1

SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.name AS name_2, r0_.title_h1 AS title_h1_3, r0_.period AS period_4, r0_.time_difference AS time_difference_5, r0_.currency AS currency_6, r0_.formalities AS formalities_7, r0_.good_to_know AS good_to_know_8, r0_.body AS body_9, r0_.intro AS intro_10, r0_.image_content AS image_content_11, r0_.image AS image_12, r0_.main_menu AS main_menu_13, r0_.favorite AS favorite_14, r0_.active AS active_15, r0_.created_at AS created_at_16, r0_.updated_at AS updated_at_17, r0_.seo_title AS seo_title_18, r0_.seo_description AS seo_description_19, r0_.seo_keywords AS seo_keywords_20, r0_.seo_canonical AS seo_canonical_21, r0_.seo_key AS seo_key_22, r0_.seo_robots AS seo_robots_23, r0_.seo_sitemap AS seo_sitemap_24 FROM region r0_ WHERE EXISTS (SELECT 1 FROM travel_description_region t1_ WHERE t1_.region_id = r0_.id AND t1_.travel_description_id IN (7336)) LIMIT 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->getOneOrNullResult (line 737)
6	App\Controller\TravelDescriptionController->resolveDestination (line 135)
7	App\Controller\TravelDescriptionController->show (line 58)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

0.42 ms
(0.88%)

SELECT t0.id AS id_1, t0.date_departure AS date_departure_2, t0.available AS available_3, t0.number AS number_4, t0.imported_at AS imported_at_5, t0.travel_offer_id AS travel_offer_id_6, t0.departure_location_id AS departure_location_id_7 FROM departure t0 WHERE t0.travel_offer_id = ? ORDER BY t0.date_departure ASC

Parameters:

[
  2059
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_departure AS date_departure_2,
  t0.available AS available_3,
  t0.number AS number_4,
  t0.imported_at AS imported_at_5,
  t0.travel_offer_id AS travel_offer_id_6,
  t0.departure_location_id AS departure_location_id_7
FROM
  departure t0
WHERE
  t0.travel_offer_id = ?
ORDER BY
  t0.date_departure ASC

SELECT t0.id AS id_1, t0.date_departure AS date_departure_2, t0.available AS available_3, t0.number AS number_4, t0.imported_at AS imported_at_5, t0.travel_offer_id AS travel_offer_id_6, t0.departure_location_id AS departure_location_id_7 FROM departure t0 WHERE t0.travel_offer_id = 2059 ORDER BY t0.date_departure 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\Controller\TravelDescriptionController->show (line 79)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
8	App\Controller\UrlAliasController->resolve (line 100)
9	App\Controller\UrlAliasController->__invoke (line 60)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

0.42 ms
(0.88%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_h1 AS title_h1_3, t0.image AS image_4, t0.content AS content_5, t0.published AS published_6, t0.archived AS archived_7, t0.filter_calendar AS filter_calendar_8, t0.on_homepage AS on_homepage_9, t0.highlighted AS highlighted_10, t0.promoted AS promoted_11, t0.print_tab AS print_tab_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_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 thematique t0 WHERE t0.id = ?

Parameters:

[
  531
]

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.image AS image_4,
  t0.content AS content_5,
  t0.published AS published_6,
  t0.archived AS archived_7,
  t0.filter_calendar AS filter_calendar_8,
  t0.on_homepage AS on_homepage_9,
  t0.highlighted AS highlighted_10,
  t0.promoted AS promoted_11,
  t0.print_tab AS print_tab_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_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
  thematique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_h1 AS title_h1_3, t0.image AS image_4, t0.content AS content_5, t0.published AS published_6, t0.archived AS archived_7, t0.filter_calendar AS filter_calendar_8, t0.on_homepage AS on_homepage_9, t0.highlighted AS highlighted_10, t0.promoted AS promoted_11, t0.print_tab AS print_tab_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_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 thematique t0 WHERE t0.id = 531;

#	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\Thematique::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Thematique->__get (line 153)
7	App\Entity\Thematique->getTitle (line 98)
8	Twig\Extension\CoreExtension->getAttribute (line 1928)
9	__TwigTemplate_7fff67980e99c9cf4b645ec8552d0a46::block_content (line 329)
10	Twig\Template->yieldBlock (line 458)
11	__TwigTemplate_525ea427e1045890109d836a466ec5ef->block_body (line 95)
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_7fff67980e99c9cf4b645ec8552d0a46->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\TravelDescriptionController->show (line 60)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

0.39 ms
(0.81%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.caption AS caption_3, t0.type AS type_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.travel_description_id AS travel_description_id_8 FROM travel_image t0 WHERE t0.travel_description_id = ?

Parameters:

[
  7336
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.caption AS caption_3,
  t0.type AS type_4,
  t0.position AS position_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.travel_description_id AS travel_description_id_8
FROM
  travel_image t0
WHERE
  t0.travel_description_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.caption AS caption_3, t0.type AS type_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.travel_description_id AS travel_description_id_8 FROM travel_image t0 WHERE t0.travel_description_id = 7336;

#	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->getIterator (line 315)
7	App\Seo\JsonLd\TravelDescriptionImageResolver->resolveFirstFilename (line 19)
8	App\Seo\JsonLd\TravelDescriptionImageResolver->resolveFirstPath (line 30)
9	App\Controller\TravelDescriptionController->show (line 56)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
13	App\Controller\UrlAliasController->resolve (line 100)
14	App\Controller\UrlAliasController->__invoke (line 60)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
19	require_once (line 32)
20	require_once (line 5)

0.37 ms
(0.78%)

SELECT t0.id AS id_1, t0.length AS length_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.travel_description_id AS travel_description_id_5 FROM travel_length t0 WHERE t0.travel_description_id = ?

Parameters:

[
  7336
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.length AS length_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.travel_description_id AS travel_description_id_5
FROM
  travel_length t0
WHERE
  t0.travel_description_id = ?

SELECT t0.id AS id_1, t0.length AS length_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.travel_description_id AS travel_description_id_5 FROM travel_length t0 WHERE t0.travel_description_id = 7336;

#	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\Entity\TravelDescription->loadLengthValues (line 1043)
8	Doctrine\ORM\Event\ListenersInvoker->invoke (line 80)
9	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
10	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3214)
11	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 49)
12	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
13	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
14	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
15	Doctrine\ORM\EntityManager->find (line 366)
16	Doctrine\ORM\EntityRepository->find (line 86)
17	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
18	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 39)
19	App\Controller\UrlAliasController->resolve (line 100)
20	App\Controller\UrlAliasController->__invoke (line 60)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
25	require_once (line 32)
26	require_once (line 5)

0.36 ms
(0.76%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.fallback_image_style_id AS fallback_image_style_id_6 FROM responsive_image_style t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "header-full-width"
]

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,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.fallback_image_style_id AS fallback_image_style_id_6
FROM
  responsive_image_style t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.fallback_image_style_id AS fallback_image_style_id_6 FROM responsive_image_style t0 WHERE t0.name = 'header-full-width' 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\ResponsiveImageStyleRepository->findByName (line 21)
5	App\Media\ResponsiveImageResolver->picture (line 36)
6	__TwigTemplate_7fff67980e99c9cf4b645ec8552d0a46->block_content (line 260)
7	Twig\Template->yieldBlock (line 458)
8	__TwigTemplate_525ea427e1045890109d836a466ec5ef->block_body (line 95)
9	Twig\Template->yieldBlock (line 458)
10	__TwigTemplate_24f73696464343efad806d743be1601c->doDisplay (line 111)
11	Twig\Template->yield (line 411)
12	__TwigTemplate_525ea427e1045890109d836a466ec5ef->doDisplay (line 60)
13	Twig\Template->yield (line 411)
14	__TwigTemplate_7fff67980e99c9cf4b645ec8552d0a46->doDisplay (line 65)
15	Twig\Template->yield (line 411)
16	Twig\Template->display (line 366)
17	Twig\Template->render (line 381)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
23	App\Controller\TravelDescriptionController->show (line 60)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
27	App\Controller\UrlAliasController->resolve (line 100)
28	App\Controller\UrlAliasController->__invoke (line 60)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
33	require_once (line 32)
34	require_once (line 5)

0.36 ms
(0.75%)

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_7fff67980e99c9cf4b645ec8552d0a46->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\TravelDescriptionController->show (line 60)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

0.34 ms
(0.71%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.content AS content_4, t0.web_only AS web_only_5, t0.position AS position_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.travel_description_id AS travel_description_id_9 FROM travel_content_tab t0 WHERE t0.travel_description_id = ?

Parameters:

[
  7336
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.subtitle AS subtitle_3,
  t0.content AS content_4,
  t0.web_only AS web_only_5,
  t0.position AS position_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.travel_description_id AS travel_description_id_9
FROM
  travel_content_tab t0
WHERE
  t0.travel_description_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.content AS content_4, t0.web_only AS web_only_5, t0.position AS position_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.travel_description_id AS travel_description_id_9 FROM travel_content_tab t0 WHERE t0.travel_description_id = 7336;

#	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\TravelDescriptionController->show (line 83)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

0.32 ms
(0.67%)

SELECT t0.id AS id_1, t0.similar_link AS similar_link_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.travel_description_id AS travel_description_id_5, t0.thematique_id AS thematique_id_6 FROM travel_thematique t0 WHERE t0.travel_description_id = ?

Parameters:

[
  7336
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.similar_link AS similar_link_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.travel_description_id AS travel_description_id_5,
  t0.thematique_id AS thematique_id_6
FROM
  travel_thematique t0
WHERE
  t0.travel_description_id = ?

SELECT t0.id AS id_1, t0.similar_link AS similar_link_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.travel_description_id AS travel_description_id_5, t0.thematique_id AS thematique_id_6 FROM travel_thematique t0 WHERE t0.travel_description_id = 7336;

#	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->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1281)
9	__TwigTemplate_7fff67980e99c9cf4b645ec8552d0a46::block_content (line 326)
10	Twig\Template->yieldBlock (line 458)
11	__TwigTemplate_525ea427e1045890109d836a466ec5ef->block_body (line 95)
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_7fff67980e99c9cf4b645ec8552d0a46->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\TravelDescriptionController->show (line 60)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

0.30 ms
(0.62%)

SELECT t0.id AS id_1, t0.leonet_hotel_id AS leonet_hotel_id_2, t0.name AS name_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.travel_description_id AS travel_description_id_7 FROM travel_hotel t0 WHERE t0.travel_description_id = ?

Parameters:

[
  7336
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.leonet_hotel_id AS leonet_hotel_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.travel_description_id AS travel_description_id_7
FROM
  travel_hotel t0
WHERE
  t0.travel_description_id = ?

SELECT t0.id AS id_1, t0.leonet_hotel_id AS leonet_hotel_id_2, t0.name AS name_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.travel_description_id AS travel_description_id_7 FROM travel_hotel t0 WHERE t0.travel_description_id = 7336;

#	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->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1281)
9	__TwigTemplate_7fff67980e99c9cf4b645ec8552d0a46::block_content (line 197)
10	Twig\Template->yieldBlock (line 458)
11	__TwigTemplate_525ea427e1045890109d836a466ec5ef->block_body (line 95)
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_7fff67980e99c9cf4b645ec8552d0a46->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\TravelDescriptionController->show (line 60)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

0.26 ms
(0.56%)

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_7fff67980e99c9cf4b645ec8552d0a46->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\TravelDescriptionController->show (line 60)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

0.25 ms
(0.52%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.cta_label AS cta_label_4, t0.external_url AS external_url_5, t0.image AS image_6, t0.mobile_image AS mobile_image_7, t0.slot AS slot_8, t0.published AS published_9, t0.archived AS archived_10, t0.position AS position_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.url_alias_id AS url_alias_id_14 FROM block_content t0 WHERE t0.slot = ? AND t0.published = ? AND t0.archived = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.body AS body_3,
  t0.cta_label AS cta_label_4,
  t0.external_url AS external_url_5,
  t0.image AS image_6,
  t0.mobile_image AS mobile_image_7,
  t0.slot AS slot_8,
  t0.published AS published_9,
  t0.archived AS archived_10,
  t0.position AS position_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.url_alias_id AS url_alias_id_14
FROM
  block_content t0
WHERE
  t0.slot = ?
  AND t0.published = ?
  AND t0.archived = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.cta_label AS cta_label_4, t0.external_url AS external_url_5, t0.image AS image_6, t0.mobile_image AS mobile_image_7, t0.slot AS slot_8, t0.published AS published_9, t0.archived AS archived_10, t0.position AS position_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.url_alias_id AS url_alias_id_14 FROM block_content t0 WHERE t0.slot = 3 AND t0.published = 1 AND t0.archived = 0 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\TravelDescriptionController->show (line 72)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
8	App\Controller\UrlAliasController->resolve (line 100)
9	App\Controller\UrlAliasController->__invoke (line 60)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

0.22 ms
(0.46%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.filename AS filename_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.travel_description_id AS travel_description_id_7 FROM travel_file t0 WHERE t0.travel_description_id = ?

Parameters:

[
  7336
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.filename AS filename_3,
  t0.type AS type_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.travel_description_id AS travel_description_id_7
FROM
  travel_file t0
WHERE
  t0.travel_description_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.filename AS filename_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.travel_description_id AS travel_description_id_7 FROM travel_file t0 WHERE t0.travel_description_id = 7336;

#	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->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1281)
9	__TwigTemplate_7fff67980e99c9cf4b645ec8552d0a46::block_content (line 911)
10	Twig\Template->yieldBlock (line 458)
11	__TwigTemplate_525ea427e1045890109d836a466ec5ef->block_body (line 95)
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_7fff67980e99c9cf4b645ec8552d0a46->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\TravelDescriptionController->show (line 60)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

0.17 ms
(0.36%)

SELECT t0.id AS id_1, t0.multiplier AS multiplier_2, t0.responsive_image_style_id AS responsive_image_style_id_3, t0.breakpoint_id AS breakpoint_id_4, t0.image_style_id AS image_style_id_5 FROM responsive_image_style_mapping t0 WHERE t0.responsive_image_style_id = ?

Parameters:

[
  22
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.multiplier AS multiplier_2,
  t0.responsive_image_style_id AS responsive_image_style_id_3,
  t0.breakpoint_id AS breakpoint_id_4,
  t0.image_style_id AS image_style_id_5
FROM
  responsive_image_style_mapping t0
WHERE
  t0.responsive_image_style_id = ?

SELECT t0.id AS id_1, t0.multiplier AS multiplier_2, t0.responsive_image_style_id AS responsive_image_style_id_3, t0.breakpoint_id AS breakpoint_id_4, t0.image_style_id AS image_style_id_5 FROM responsive_image_style_mapping t0 WHERE t0.responsive_image_style_id = 22;

#	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->getIterator (line 315)
7	App\Media\ResponsiveImageResolver->resolveBreakpoints (line 125)
8	App\Media\ResponsiveImageResolver->picture (line 37)
9	__TwigTemplate_7fff67980e99c9cf4b645ec8552d0a46->block_content (line 260)
10	Twig\Template->yieldBlock (line 458)
11	__TwigTemplate_525ea427e1045890109d836a466ec5ef->block_body (line 95)
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_7fff67980e99c9cf4b645ec8552d0a46->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\TravelDescriptionController->show (line 60)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	App\Resolver\TravelDescriptionUrlAliasResolver->resolve (line 52)
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)

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\Imported\TravelDeparturePoint	11
App\Entity\Imported\DepartureLocation	11
App\Entity\Travel\TravelImage	11
App\Entity\ImageStyle	7
App\Entity\ResponsiveImageStyleMapping	6
App\Entity\Breakpoint	4
App\Entity\Menu	3
App\Entity\Imported\PriceEntry	2
App\Entity\Travel\TravelThematique	2
App\Entity\Thematique	2
App\Entity\Content	2
App\Entity\TravelDescription	1
App\Entity\Imported\TravelOffer	1
App\Entity\BlockContent	1
App\Entity\ResponsiveImageStyle	1
App\Entity\Destination\Country	1

Entities Mapping

Class	Mapping errors
App\Entity\UrlRedirect	No errors.
App\Entity\UrlAlias	No errors.
App\Entity\Embeddable\Stay	No errors.
App\Entity\Embeddable\EcoImpact	No errors.
App\Entity\Embeddable\Seo	No errors.
App\Entity\TravelDescription	No errors.
App\Entity\Structural\TravelVariantGroup	No errors.
App\Entity\Imported\TravelType	No errors.
App\Entity\Brochure	No errors.
App\Entity\Thematique	No errors.
App\Entity\Travel\TravelHotel	No errors.
App\Entity\Travel\TravelProgrammeItem	No errors.
App\Entity\Travel\TravelContentTab	No errors.
App\Entity\Travel\TravelThematique	No errors.
App\Entity\Travel\TravelImage	No errors.
App\Entity\Travel\TravelFile	No errors.
App\Entity\Travel\TravelLength	No errors.
App\Entity\Content	No errors.
App\Entity\Imported\TravelOffer	No errors.
App\Entity\Imported\TravelDeparturePoint	No errors.
App\Entity\Imported\DepartureLocation	No errors.
App\Entity\Destination\Region	No errors.
App\Entity\Destination\Country	No errors.
App\Entity\Destination\Continent	No errors.
App\Entity\TravelTerm	No errors.
App\Entity\TravelTaxonomy	No errors.
App\Entity\Logo	No errors.
App\Entity\BlockContent	No errors.
App\Entity\Imported\PriceEntry	No errors.
App\Entity\Imported\BoardGroup	No errors.
App\Entity\Imported\Departure	No errors.
App\Entity\Menu	No errors.
App\Entity\MenuLink	No errors.
App\Entity\ResponsiveImageStyle	No errors.
App\Entity\ImageStyle	No errors.
App\Entity\ResponsiveImageStyleMapping	No errors.
App\Entity\Breakpoint	No errors.
App\Entity\Content\ContentGallery	No errors.
App\Entity\Content\ContentTab	No errors.
App\Entity\Structural\ContentDisplaySlot	No errors.
App\Entity\Content\ContentPicture	No errors.

Symfony Profiler

GET https://www.leroy.goconcept8.be/voyager/voyages-leroy/foret-noire-2

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