Symfony Profiler

Query Metrics

128 Database Queries

24 Different statements

14.59 ms Query time

3 Invalid entities

319 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

3.88 ms
(26.61%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1

Parameters:

[
  "LOGO_PATH"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.label = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = 'LOGO_PATH' 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\Service\Configuration\ConfigurationService->getConfiguration (line 18)
5	App\Service\Context\AbstractPageProvider->getLogoPath (line 27)
6	App\Service\Context\AbstractPageProvider->getBaseArray (line 44)
7	App\Service\Context\HomePageProvider->getVariables (line 32)
8	App\EventSubscriber\PageContextSubscriber->onKernelController (line 32)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
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 35)
17	require_once (line 29)
18	require_once (line 5)

1.16 ms
(7.95%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.og_title AS og_title_6, t0.twitter_card AS twitter_card_7, t0.page_type AS page_type_8, t0.og_image_id AS og_image_id_9, t0.twitter_image_id AS twitter_image_id_10 FROM seo_meta_data t0 WHERE t0.id = ?

Parameters:

[
  955
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.title AS title_3,
  t0.meta_description AS meta_description_4,
  t0.meta_keywords AS meta_keywords_5,
  t0.og_title AS og_title_6,
  t0.twitter_card AS twitter_card_7,
  t0.page_type AS page_type_8,
  t0.og_image_id AS og_image_id_9,
  t0.twitter_image_id AS twitter_image_id_10
FROM
  seo_meta_data t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.og_title AS og_title_6, t0.twitter_card AS twitter_card_7, t0.page_type AS page_type_8, t0.og_image_id AS og_image_id_9, t0.twitter_image_id AS twitter_image_id_10 FROM seo_meta_data t0 WHERE t0.id = 955;

#	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->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\SeoMetaData::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\SeoMetaData->__get (line 153)
7	App\Entity\SeoMetaData->getUrl (line 69)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_b1a8c33db99641ee2f8d7f9a950981db::doDisplay (line 58)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Extension\CoreExtension->include (line 1526)
15	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661::doDisplay (line 121)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_0ae3b04df313a401692a2b98f6182764->doDisplay (line 56)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
26	App\Controller\Front\HomeController->index (line 28)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

1.10 ms
(7.55%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4, t0.route AS route_5, t0.position AS position_6, t0.enabled AS enabled_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.path AS path_10, t0.has_link AS has_link_11, t0.parent_id AS parent_id_12, t0.menu_id AS menu_id_13 FROM menu_item t0 WHERE t0.parent_id = ?

Parameters:

[
  37
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.type AS type_3,
  t0.url AS url_4,
  t0.route AS route_5,
  t0.position AS position_6,
  t0.enabled AS enabled_7,
  t0.updated_at AS updated_at_8,
  t0.created_at AS created_at_9,
  t0.path AS path_10,
  t0.has_link AS has_link_11,
  t0.parent_id AS parent_id_12,
  t0.menu_id AS menu_id_13
FROM
  menu_item t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4, t0.route AS route_5, t0.position AS position_6, t0.enabled AS enabled_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.path AS path_10, t0.has_link AS has_link_11, t0.parent_id AS parent_id_12, t0.menu_id AS menu_id_13 FROM menu_item t0 WHERE t0.parent_id = 37;

#	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 2729)
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 1278)
9	__TwigTemplate_a259854e9cef8f3af6df5b68bb1c9d8e::{closure:__TwigTemplate_a259854e9cef8f3af6df5b68bb1c9d8e::macro_render_menu():137} (line 172)
10	Twig\Extension\CoreExtension->captureOutput (line 2116)
11	__TwigTemplate_a259854e9cef8f3af6df5b68bb1c9d8e::macro_render_menu (line 137)
12	__TwigTemplate_a259854e9cef8f3af6df5b68bb1c9d8e->{closure:__TwigTemplate_a259854e9cef8f3af6df5b68bb1c9d8e::macro_render_menu():137} (line 217)
13	Twig\Extension\CoreExtension->captureOutput (line 2116)
14	__TwigTemplate_a259854e9cef8f3af6df5b68bb1c9d8e::macro_render_menu (line 137)
15	__TwigTemplate_a259854e9cef8f3af6df5b68bb1c9d8e->doDisplay (line 82)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
20	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
21	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
22	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661->block_header (line 285)
23	Twig\Template->yieldBlock (line 446)
24	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661->doDisplay (line 116)
25	Twig\Template->yield (line 402)
26	__TwigTemplate_0ae3b04df313a401692a2b98f6182764->doDisplay (line 56)
27	Twig\Template->yield (line 402)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 373)
30	Twig\TemplateWrapper->render (line 51)
31	Twig\Environment->render (line 333)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
35	App\Controller\Front\HomeController->index (line 28)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
38	Symfony\Component\HttpKernel\Kernel->handle (line 193)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
40	require_once (line 29)
41	require_once (line 5)

0.95 ms
(6.52%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.cygest_code AS cygest_code_5, t0.cygest_name AS cygest_name_6, t0.days AS days_7, t0.nights AS nights_8, t0.soon AS soon_9, t0.is_health_situation AS is_health_situation_10, t0.description_introduction AS description_introduction_11, t0.description_resume AS description_resume_12, t0.description_body AS description_body_13, t0.camping_car_circuit AS camping_car_circuit_14, t0.average_distance AS average_distance_15, t0.days_without_driving AS days_without_driving_16, t0.youtube AS youtube_17, t0.our_prices_include AS our_prices_include_18, t0.our_prices_does_not_include AS our_prices_does_not_include_19, t0.rates_details AS rates_details_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.enabled AS enabled_23, t0.is_archive AS is_archive_24, t0.we_like AS we_like_25, t0.scale AS scale_26, t0.is_upon_request AS is_upon_request_27, t0.is_new AS is_new_28, t0.is_pre_registration_allowed AS is_pre_registration_allowed_29, t0.reservation_limit AS reservation_limit_30, t0.is_animal_forbidden AS is_animal_forbidden_31, t0.author_id AS author_id_32, t33.id AS id_34, t33.path AS path_35, t33.alt AS alt_36, t33.title AS title_37, t33.destination_id AS destination_id_38, t39.id AS id_40, t39.path AS path_41, t39.alt AS alt_42, t39.title AS title_43, t39.destination_id AS destination_id_44, t0.type_id AS type_id_45, t0.seo_id AS seo_id_46 FROM destination t0 LEFT JOIN destination_map t33 ON t33.destination_id = t0.id LEFT JOIN destination_hero t39 ON t39.destination_id = t0.id WHERE t0.id = ?

Parameters:

[
  40
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.subtitle AS subtitle_4,
  t0.cygest_code AS cygest_code_5,
  t0.cygest_name AS cygest_name_6,
  t0.days AS days_7,
  t0.nights AS nights_8,
  t0.soon AS soon_9,
  t0.is_health_situation AS is_health_situation_10,
  t0.description_introduction AS description_introduction_11,
  t0.description_resume AS description_resume_12,
  t0.description_body AS description_body_13,
  t0.camping_car_circuit AS camping_car_circuit_14,
  t0.average_distance AS average_distance_15,
  t0.days_without_driving AS days_without_driving_16,
  t0.youtube AS youtube_17,
  t0.our_prices_include AS our_prices_include_18,
  t0.our_prices_does_not_include AS our_prices_does_not_include_19,
  t0.rates_details AS rates_details_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.enabled AS enabled_23,
  t0.is_archive AS is_archive_24,
  t0.we_like AS we_like_25,
  t0.scale AS scale_26,
  t0.is_upon_request AS is_upon_request_27,
  t0.is_new AS is_new_28,
  t0.is_pre_registration_allowed AS is_pre_registration_allowed_29,
  t0.reservation_limit AS reservation_limit_30,
  t0.is_animal_forbidden AS is_animal_forbidden_31,
  t0.author_id AS author_id_32,
  t33.id AS id_34,
  t33.path AS path_35,
  t33.alt AS alt_36,
  t33.title AS title_37,
  t33.destination_id AS destination_id_38,
  t39.id AS id_40,
  t39.path AS path_41,
  t39.alt AS alt_42,
  t39.title AS title_43,
  t39.destination_id AS destination_id_44,
  t0.type_id AS type_id_45,
  t0.seo_id AS seo_id_46
FROM
  destination t0
  LEFT JOIN destination_map t33 ON t33.destination_id = t0.id
  LEFT JOIN destination_hero t39 ON t39.destination_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.cygest_code AS cygest_code_5, t0.cygest_name AS cygest_name_6, t0.days AS days_7, t0.nights AS nights_8, t0.soon AS soon_9, t0.is_health_situation AS is_health_situation_10, t0.description_introduction AS description_introduction_11, t0.description_resume AS description_resume_12, t0.description_body AS description_body_13, t0.camping_car_circuit AS camping_car_circuit_14, t0.average_distance AS average_distance_15, t0.days_without_driving AS days_without_driving_16, t0.youtube AS youtube_17, t0.our_prices_include AS our_prices_include_18, t0.our_prices_does_not_include AS our_prices_does_not_include_19, t0.rates_details AS rates_details_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.enabled AS enabled_23, t0.is_archive AS is_archive_24, t0.we_like AS we_like_25, t0.scale AS scale_26, t0.is_upon_request AS is_upon_request_27, t0.is_new AS is_new_28, t0.is_pre_registration_allowed AS is_pre_registration_allowed_29, t0.reservation_limit AS reservation_limit_30, t0.is_animal_forbidden AS is_animal_forbidden_31, t0.author_id AS author_id_32, t33.id AS id_34, t33.path AS path_35, t33.alt AS alt_36, t33.title AS title_37, t33.destination_id AS destination_id_38, t39.id AS id_40, t39.path AS path_41, t39.alt AS alt_42, t39.title AS title_43, t39.destination_id AS destination_id_44, t0.type_id AS type_id_45, t0.seo_id AS seo_id_46 FROM destination t0 LEFT JOIN destination_map t33 ON t33.destination_id = t0.id LEFT JOIN destination_hero t39 ON t39.destination_id = t0.id WHERE t0.id = 40;

#	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->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\Destination\Destination::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Destination\Destination->__get (line 153)
7	App\Entity\Destination\Destination->isEnabled (line 485)
8	App\Entity\Destination\Destination->isShowable (line 792)
9	Twig\Extension\CoreExtension->getAttribute (line 1919)
10	__TwigTemplate_b733e140a31b57a22ec486091c41cb25::{closure:__TwigTemplate_b733e140a31b57a22ec486091c41cb25::doDisplay():48} (line 48)
11	array_filter (line 1976)
12	Twig\Extension\CoreExtension::filter (line 1976)
13	__TwigTemplate_b733e140a31b57a22ec486091c41cb25::doDisplay (line 48)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Extension\CoreExtension->include (line 1526)
19	__TwigTemplate_0ae3b04df313a401692a2b98f6182764::block_body (line 190)
20	Twig\Template->yieldBlock (line 446)
21	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661->doDisplay (line 152)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_0ae3b04df313a401692a2b98f6182764->doDisplay (line 56)
24	Twig\Template->yield (line 402)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
32	App\Controller\Front\HomeController->index (line 28)
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 35)
37	require_once (line 29)
38	require_once (line 5)

0.87 ms
(5.94%)

SELECT t0.id AS id_1, t0.id_crypt AS id_crypt_2, t0.name AS name_3, t0.starting_point AS starting_point_4, t0.days AS days_5, t0.is_complete AS is_complete_6, t0.is_last_spot AS is_last_spot_7, t0.guides AS guides_8, t0.date_from AS date_from_9, t0.start_date AS start_date_10, t0.date_to AS date_to_11, t0.registration_deadline AS registration_deadline_12, t0.formalities AS formalities_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.enabled AS enabled_16, t0.is_promoted AS is_promoted_17, t0.is_pre_registered_notified AS is_pre_registered_notified_18, t0.destination_id AS destination_id_19 FROM travel t0 WHERE t0.destination_id = ? ORDER BY t0.date_from DESC

Parameters:

[
  40
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.id_crypt AS id_crypt_2,
  t0.name AS name_3,
  t0.starting_point AS starting_point_4,
  t0.days AS days_5,
  t0.is_complete AS is_complete_6,
  t0.is_last_spot AS is_last_spot_7,
  t0.guides AS guides_8,
  t0.date_from AS date_from_9,
  t0.start_date AS start_date_10,
  t0.date_to AS date_to_11,
  t0.registration_deadline AS registration_deadline_12,
  t0.formalities AS formalities_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.enabled AS enabled_16,
  t0.is_promoted AS is_promoted_17,
  t0.is_pre_registered_notified AS is_pre_registered_notified_18,
  t0.destination_id AS destination_id_19
FROM
  travel t0
WHERE
  t0.destination_id = ?
ORDER BY
  t0.date_from DESC

SELECT t0.id AS id_1, t0.id_crypt AS id_crypt_2, t0.name AS name_3, t0.starting_point AS starting_point_4, t0.days AS days_5, t0.is_complete AS is_complete_6, t0.is_last_spot AS is_last_spot_7, t0.guides AS guides_8, t0.date_from AS date_from_9, t0.start_date AS start_date_10, t0.date_to AS date_to_11, t0.registration_deadline AS registration_deadline_12, t0.formalities AS formalities_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.enabled AS enabled_16, t0.is_promoted AS is_promoted_17, t0.is_pre_registered_notified AS is_pre_registered_notified_18, t0.destination_id AS destination_id_19 FROM travel t0 WHERE t0.destination_id = 40 ORDER BY t0.date_from DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
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\Destination\Destination->getReservableTravels (line 767)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_b768acca2fa64864b0caaea1799ce517::doDisplay (line 112)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_b733e140a31b57a22ec486091c41cb25___43569303->doDisplay (line 372)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b733e140a31b57a22ec486091c41cb25->doDisplay (line 101)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Extension\CoreExtension->include (line 1526)
19	__TwigTemplate_0ae3b04df313a401692a2b98f6182764::block_body (line 190)
20	Twig\Template->yieldBlock (line 446)
21	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661->doDisplay (line 152)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_0ae3b04df313a401692a2b98f6182764->doDisplay (line 56)
24	Twig\Template->yield (line 402)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
32	App\Controller\Front\HomeController->index (line 28)
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 35)
37	require_once (line 29)
38	require_once (line 5)

0.70 ms
(4.79%)

SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.title AS title_4, t0.position AS position_5, t0.legend AS legend_6, t0.destination_id AS destination_id_7 FROM destination_image t0 WHERE t0.destination_id = ? ORDER BY t0.position ASC

Parameters:

[
  40
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.alt AS alt_3,
  t0.title AS title_4,
  t0.position AS position_5,
  t0.legend AS legend_6,
  t0.destination_id AS destination_id_7
FROM
  destination_image t0
WHERE
  t0.destination_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.title AS title_4, t0.position AS position_5, t0.legend AS legend_6, t0.destination_id AS destination_id_7 FROM destination_image t0 WHERE t0.destination_id = 40 ORDER BY t0.position ASC;

#	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 2729)
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 1278)
9	__TwigTemplate_b733e140a31b57a22ec486091c41cb25___43569303::block_picture (line 396)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_b768acca2fa64864b0caaea1799ce517->doDisplay (line 62)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b733e140a31b57a22ec486091c41cb25___43569303->doDisplay (line 372)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_b733e140a31b57a22ec486091c41cb25->doDisplay (line 101)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Extension\CoreExtension->include (line 1526)
21	__TwigTemplate_0ae3b04df313a401692a2b98f6182764::block_body (line 190)
22	Twig\Template->yieldBlock (line 446)
23	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661->doDisplay (line 152)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_0ae3b04df313a401692a2b98f6182764->doDisplay (line 56)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Twig\TemplateWrapper->render (line 51)
30	Twig\Environment->render (line 333)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
34	App\Controller\Front\HomeController->index (line 28)
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 35)
39	require_once (line 29)
40	require_once (line 5)

0.60 ms
(4.10%)

SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.title AS title_4, t0.post_id AS post_id_5 FROM post_image t0 WHERE t0.post_id = ?

Parameters:

[
  60
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.alt AS alt_3,
  t0.title AS title_4,
  t0.post_id AS post_id_5
FROM
  post_image t0
WHERE
  t0.post_id = ?

SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.title AS title_4, t0.post_id AS post_id_5 FROM post_image t0 WHERE t0.post_id = 60;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getResult (line 688)
11	App\Repository\Post\PostRepository->findPaginated (line 64)
12	App\Controller\Front\HomeController->index (line 32)
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 35)
17	require_once (line 29)
18	require_once (line 5)

0.56 ms
(3.81%)

SELECT t1.id AS id_2, t1.path AS path_3, t1.name AS name_4, t1.mime_type AS mime_type_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t0.destination_id AS destination_id_8, t1.discr FROM destination_hero_video t0 INNER JOIN video t1 ON t0.id = t1.id WHERE t0.destination_id = ?

Parameters:

[
  40
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.path AS path_3,
  t1.name AS name_4,
  t1.mime_type AS mime_type_5,
  t1.created_at AS created_at_6,
  t1.updated_at AS updated_at_7,
  t0.destination_id AS destination_id_8,
  t1.discr
FROM
  destination_hero_video t0
  INNER JOIN video t1 ON t0.id = t1.id
WHERE
  t0.destination_id = ?

SELECT t1.id AS id_2, t1.path AS path_3, t1.name AS name_4, t1.mime_type AS mime_type_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t0.destination_id AS destination_id_8, t1.discr FROM destination_hero_video t0 INNER JOIN video t1 ON t0.id = t1.id WHERE t0.destination_id = 40;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
10	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
11	Proxies\__CG__\App\Entity\Destination\Destination::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
12	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
13	Proxies\__CG__\App\Entity\Destination\Destination->__get (line 153)
14	App\Entity\Destination\Destination->isEnabled (line 485)
15	App\Entity\Destination\Destination->isShowable (line 792)
16	Twig\Extension\CoreExtension->getAttribute (line 1919)
17	__TwigTemplate_b733e140a31b57a22ec486091c41cb25::{closure:__TwigTemplate_b733e140a31b57a22ec486091c41cb25::doDisplay():48} (line 48)
18	array_filter (line 1976)
19	Twig\Extension\CoreExtension::filter (line 1976)
20	__TwigTemplate_b733e140a31b57a22ec486091c41cb25::doDisplay (line 48)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Extension\CoreExtension->include (line 1526)
26	__TwigTemplate_0ae3b04df313a401692a2b98f6182764::block_body (line 190)
27	Twig\Template->yieldBlock (line 446)
28	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661->doDisplay (line 152)
29	Twig\Template->yield (line 402)
30	__TwigTemplate_0ae3b04df313a401692a2b98f6182764->doDisplay (line 56)
31	Twig\Template->yield (line 402)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
39	App\Controller\Front\HomeController->index (line 28)
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 35)
44	require_once (line 29)
45	require_once (line 5)

0.50 ms
(3.43%)

SELECT t0.id AS id_1, t0.is_activate AS is_activate_2, t0.ips AS ips_3, t0.message AS message_4 FROM maintenance t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.is_activate AS is_activate_2,
  t0.ips AS ips_3,
  t0.message AS message_4
FROM
  maintenance t0
LIMIT
  1

SELECT t0.id AS id_1, t0.is_activate AS is_activate_2, t0.ips AS ips_3, t0.message AS message_4 FROM maintenance t0 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\EventListener\MaintenanceListener->onKernelRequest (line 29)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
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 35)
13	require_once (line 29)
14	require_once (line 5)

0.48 ms
(3.32%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.content AS content_3, t0.name AS name_4 FROM cms_block t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "fullwidth_slider"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.content AS content_3,
  t0.name AS name_4
FROM
  cms_block t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.content AS content_3, t0.name AS name_4 FROM cms_block t0 WHERE t0.code = 'fullwidth_slider' 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\Components\Cms\BlockComponent->getBlocks (line 28)
5	Twig\Extension\CoreExtension->getAttribute (line 1919)
6	__TwigTemplate_aad9c7c0f0f32eaa45607cce9da454dc::doDisplay (line 49)
7	Twig\Template->yield (line 402)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
11	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
12	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
13	__TwigTemplate_0ae3b04df313a401692a2b98f6182764->block_body (line 168)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661->doDisplay (line 152)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_0ae3b04df313a401692a2b98f6182764->doDisplay (line 56)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
26	App\Controller\Front\HomeController->index (line 28)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

0.47 ms
(3.25%)

SELECT t1.id AS id_2, t1.path AS path_3, t1.name AS name_4, t1.mime_type AS mime_type_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t0.destination_id AS destination_id_8, t1.discr FROM destination_video t0 INNER JOIN video t1 ON t0.id = t1.id WHERE t0.destination_id = ?

Parameters:

[
  40
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.path AS path_3,
  t1.name AS name_4,
  t1.mime_type AS mime_type_5,
  t1.created_at AS created_at_6,
  t1.updated_at AS updated_at_7,
  t0.destination_id AS destination_id_8,
  t1.discr
FROM
  destination_video t0
  INNER JOIN video t1 ON t0.id = t1.id
WHERE
  t0.destination_id = ?

SELECT t1.id AS id_2, t1.path AS path_3, t1.name AS name_4, t1.mime_type AS mime_type_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t0.destination_id AS destination_id_8, t1.discr FROM destination_video t0 INNER JOIN video t1 ON t0.id = t1.id WHERE t0.destination_id = 40;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
10	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
11	Proxies\__CG__\App\Entity\Destination\Destination::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
12	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
13	Proxies\__CG__\App\Entity\Destination\Destination->__get (line 153)
14	App\Entity\Destination\Destination->isEnabled (line 485)
15	App\Entity\Destination\Destination->isShowable (line 792)
16	Twig\Extension\CoreExtension->getAttribute (line 1919)
17	__TwigTemplate_b733e140a31b57a22ec486091c41cb25::{closure:__TwigTemplate_b733e140a31b57a22ec486091c41cb25::doDisplay():48} (line 48)
18	array_filter (line 1976)
19	Twig\Extension\CoreExtension::filter (line 1976)
20	__TwigTemplate_b733e140a31b57a22ec486091c41cb25::doDisplay (line 48)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Extension\CoreExtension->include (line 1526)
26	__TwigTemplate_0ae3b04df313a401692a2b98f6182764::block_body (line 190)
27	Twig\Template->yieldBlock (line 446)
28	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661->doDisplay (line 152)
29	Twig\Template->yield (line 402)
30	__TwigTemplate_0ae3b04df313a401692a2b98f6182764->doDisplay (line 56)
31	Twig\Template->yield (line 402)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
39	App\Controller\Front\HomeController->index (line 28)
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 35)
44	require_once (line 29)
45	require_once (line 5)

0.42 ms
(2.89%)

SELECT t0_.id AS id_0, t0_.id_crypt AS id_crypt_1, t0_.name AS name_2, t0_.starting_point AS starting_point_3, t0_.days AS days_4, t0_.is_complete AS is_complete_5, t0_.is_last_spot AS is_last_spot_6, t0_.guides AS guides_7, t0_.date_from AS date_from_8, t0_.start_date AS start_date_9, t0_.date_to AS date_to_10, t0_.registration_deadline AS registration_deadline_11, t0_.formalities AS formalities_12, t0_.created_at AS created_at_13, t0_.updated_at AS updated_at_14, t0_.enabled AS enabled_15, t0_.is_promoted AS is_promoted_16, t0_.is_pre_registered_notified AS is_pre_registered_notified_17, t0_.destination_id AS destination_id_18 FROM travel t0_ LEFT JOIN destination d1_ ON t0_.destination_id = d1_.id LEFT JOIN seo_meta_data s2_ ON d1_.seo_id = s2_.id WHERE t0_.date_to > ? AND s2_.url IS NOT NULL AND t0_.registration_deadline > ? AND t0_.enabled = 1 AND d1_.enabled = 1 AND d1_.is_archive = 0 AND d1_.scale IS NOT NULL ORDER BY t0_.date_from ASC LIMIT 16

Parameters:

[
  "2026-03-15 17:24:58"
  "2026-03-15 17:24:58"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.id_crypt AS id_crypt_1,
  t0_.name AS name_2,
  t0_.starting_point AS starting_point_3,
  t0_.days AS days_4,
  t0_.is_complete AS is_complete_5,
  t0_.is_last_spot AS is_last_spot_6,
  t0_.guides AS guides_7,
  t0_.date_from AS date_from_8,
  t0_.start_date AS start_date_9,
  t0_.date_to AS date_to_10,
  t0_.registration_deadline AS registration_deadline_11,
  t0_.formalities AS formalities_12,
  t0_.created_at AS created_at_13,
  t0_.updated_at AS updated_at_14,
  t0_.enabled AS enabled_15,
  t0_.is_promoted AS is_promoted_16,
  t0_.is_pre_registered_notified AS is_pre_registered_notified_17,
  t0_.destination_id AS destination_id_18
FROM
  travel t0_
  LEFT JOIN destination d1_ ON t0_.destination_id = d1_.id
  LEFT JOIN seo_meta_data s2_ ON d1_.seo_id = s2_.id
WHERE
  t0_.date_to > ?
  AND s2_.url IS NOT NULL
  AND t0_.registration_deadline > ?
  AND t0_.enabled = 1
  AND d1_.enabled = 1
  AND d1_.is_archive = 0
  AND d1_.scale IS NOT NULL
ORDER BY
  t0_.date_from ASC
LIMIT
  16

SELECT t0_.id AS id_0, t0_.id_crypt AS id_crypt_1, t0_.name AS name_2, t0_.starting_point AS starting_point_3, t0_.days AS days_4, t0_.is_complete AS is_complete_5, t0_.is_last_spot AS is_last_spot_6, t0_.guides AS guides_7, t0_.date_from AS date_from_8, t0_.start_date AS start_date_9, t0_.date_to AS date_to_10, t0_.registration_deadline AS registration_deadline_11, t0_.formalities AS formalities_12, t0_.created_at AS created_at_13, t0_.updated_at AS updated_at_14, t0_.enabled AS enabled_15, t0_.is_promoted AS is_promoted_16, t0_.is_pre_registered_notified AS is_pre_registered_notified_17, t0_.destination_id AS destination_id_18 FROM travel t0_ LEFT JOIN destination d1_ ON t0_.destination_id = d1_.id LEFT JOIN seo_meta_data s2_ ON d1_.seo_id = s2_.id WHERE t0_.date_to > '2026-03-15 17:24:58' AND s2_.url IS NOT NULL AND t0_.registration_deadline > '2026-03-15 17:24:58' AND t0_.enabled = 1 AND d1_.enabled = 1 AND d1_.is_archive = 0 AND d1_.scale IS NOT NULL ORDER BY t0_.date_from ASC LIMIT 16;

#	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\Travel\TravelRepository->findAllNextDepartures (line 68)
7	App\Controller\Front\HomeController->index (line 31)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.38 ms
(2.60%)

SELECT t0.id AS id_1, t0.id_crypt AS id_crypt_2, t0.name AS name_3, t0.starting_point AS starting_point_4, t0.days AS days_5, t0.is_complete AS is_complete_6, t0.is_last_spot AS is_last_spot_7, t0.guides AS guides_8, t0.date_from AS date_from_9, t0.start_date AS start_date_10, t0.date_to AS date_to_11, t0.registration_deadline AS registration_deadline_12, t0.formalities AS formalities_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.enabled AS enabled_16, t0.is_promoted AS is_promoted_17, t0.is_pre_registered_notified AS is_pre_registered_notified_18, t0.destination_id AS destination_id_19 FROM travel t0 WHERE t0.is_promoted = ? AND t0.enabled = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.id_crypt AS id_crypt_2,
  t0.name AS name_3,
  t0.starting_point AS starting_point_4,
  t0.days AS days_5,
  t0.is_complete AS is_complete_6,
  t0.is_last_spot AS is_last_spot_7,
  t0.guides AS guides_8,
  t0.date_from AS date_from_9,
  t0.start_date AS start_date_10,
  t0.date_to AS date_to_11,
  t0.registration_deadline AS registration_deadline_12,
  t0.formalities AS formalities_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.enabled AS enabled_16,
  t0.is_promoted AS is_promoted_17,
  t0.is_pre_registered_notified AS is_pre_registered_notified_18,
  t0.destination_id AS destination_id_19
FROM
  travel t0
WHERE
  t0.is_promoted = ?
  AND t0.enabled = ?

SELECT t0.id AS id_1, t0.id_crypt AS id_crypt_2, t0.name AS name_3, t0.starting_point AS starting_point_4, t0.days AS days_5, t0.is_complete AS is_complete_6, t0.is_last_spot AS is_last_spot_7, t0.guides AS guides_8, t0.date_from AS date_from_9, t0.start_date AS start_date_10, t0.date_to AS date_to_11, t0.registration_deadline AS registration_deadline_12, t0.formalities AS formalities_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.enabled AS enabled_16, t0.is_promoted AS is_promoted_17, t0.is_pre_registered_notified AS is_pre_registered_notified_18, t0.destination_id AS destination_id_19 FROM travel t0 WHERE t0.is_promoted = 1 AND t0.enabled = 1;

#	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\Front\HomeController->index (line 30)
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 35)
9	require_once (line 29)
10	require_once (line 5)

0.35 ms
(2.40%)

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.type AS type_2, m0_.url AS url_3, m0_.route AS route_4, m0_.position AS position_5, m0_.enabled AS enabled_6, m0_.updated_at AS updated_at_7, m0_.created_at AS created_at_8, m0_.path AS path_9, m0_.has_link AS has_link_10, m1_.id AS id_11, m1_.title AS title_12, m1_.type AS type_13, m1_.url AS url_14, m1_.route AS route_15, m1_.position AS position_16, m1_.enabled AS enabled_17, m1_.updated_at AS updated_at_18, m1_.created_at AS created_at_19, m1_.path AS path_20, m1_.has_link AS has_link_21, m0_.parent_id AS parent_id_22, m0_.menu_id AS menu_id_23, m1_.parent_id AS parent_id_24, m1_.menu_id AS menu_id_25 FROM menu_item m0_ LEFT JOIN menu_item m1_ ON m0_.id = m1_.parent_id LEFT JOIN menu m2_ ON m0_.menu_id = m2_.id LEFT JOIN menu_type m3_ ON m2_.type_id = m3_.id WHERE m0_.parent_id IS NULL AND m0_.enabled = 1 AND m3_.name LIKE '%MENU%' ORDER BY m0_.position ASC, m1_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.type AS type_2,
  m0_.url AS url_3,
  m0_.route AS route_4,
  m0_.position AS position_5,
  m0_.enabled AS enabled_6,
  m0_.updated_at AS updated_at_7,
  m0_.created_at AS created_at_8,
  m0_.path AS path_9,
  m0_.has_link AS has_link_10,
  m1_.id AS id_11,
  m1_.title AS title_12,
  m1_.type AS type_13,
  m1_.url AS url_14,
  m1_.route AS route_15,
  m1_.position AS position_16,
  m1_.enabled AS enabled_17,
  m1_.updated_at AS updated_at_18,
  m1_.created_at AS created_at_19,
  m1_.path AS path_20,
  m1_.has_link AS has_link_21,
  m0_.parent_id AS parent_id_22,
  m0_.menu_id AS menu_id_23,
  m1_.parent_id AS parent_id_24,
  m1_.menu_id AS menu_id_25
FROM
  menu_item m0_
  LEFT JOIN menu_item m1_ ON m0_.id = m1_.parent_id
  LEFT JOIN menu m2_ ON m0_.menu_id = m2_.id
  LEFT JOIN menu_type m3_ ON m2_.type_id = m3_.id
WHERE
  m0_.parent_id IS NULL
  AND m0_.enabled = 1
  AND m3_.name LIKE '%MENU%'
ORDER BY
  m0_.position ASC,
  m1_.position ASC

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.type AS type_2, m0_.url AS url_3, m0_.route AS route_4, m0_.position AS position_5, m0_.enabled AS enabled_6, m0_.updated_at AS updated_at_7, m0_.created_at AS created_at_8, m0_.path AS path_9, m0_.has_link AS has_link_10, m1_.id AS id_11, m1_.title AS title_12, m1_.type AS type_13, m1_.url AS url_14, m1_.route AS route_15, m1_.position AS position_16, m1_.enabled AS enabled_17, m1_.updated_at AS updated_at_18, m1_.created_at AS created_at_19, m1_.path AS path_20, m1_.has_link AS has_link_21, m0_.parent_id AS parent_id_22, m0_.menu_id AS menu_id_23, m1_.parent_id AS parent_id_24, m1_.menu_id AS menu_id_25 FROM menu_item m0_ LEFT JOIN menu_item m1_ ON m0_.id = m1_.parent_id LEFT JOIN menu m2_ ON m0_.menu_id = m2_.id LEFT JOIN menu_type m3_ ON m2_.type_id = m3_.id WHERE m0_.parent_id IS NULL AND m0_.enabled = 1 AND m3_.name LIKE '%MENU%' ORDER BY m0_.position ASC, m1_.position ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\MenuItemRepository->findFullTree (line 45)
7	App\Twig\Components\Front\NavigationComponent->mount (line 20)
8	ReflectionMethod->invoke (line 174)
9	Symfony\UX\TwigComponent\ComponentFactory->mount (line 174)
10	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 96)
11	Symfony\UX\TwigComponent\ComponentFactory->create (line 84)
12	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
13	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
14	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661->block_header (line 285)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661->doDisplay (line 116)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_0ae3b04df313a401692a2b98f6182764->doDisplay (line 56)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
27	App\Controller\Front\HomeController->index (line 28)
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 35)
32	require_once (line 29)
33	require_once (line 5)

0.31 ms
(2.09%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.og_title AS og_title_6, t0.twitter_card AS twitter_card_7, t0.page_type AS page_type_8, t0.og_image_id AS og_image_id_9, t0.twitter_image_id AS twitter_image_id_10 FROM seo_meta_data t0 WHERE t0.page_type = ? LIMIT 1

Parameters:

[
  "home"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.title AS title_3,
  t0.meta_description AS meta_description_4,
  t0.meta_keywords AS meta_keywords_5,
  t0.og_title AS og_title_6,
  t0.twitter_card AS twitter_card_7,
  t0.page_type AS page_type_8,
  t0.og_image_id AS og_image_id_9,
  t0.twitter_image_id AS twitter_image_id_10
FROM
  seo_meta_data t0
WHERE
  t0.page_type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.og_title AS og_title_6, t0.twitter_card AS twitter_card_7, t0.page_type AS page_type_8, t0.og_image_id AS og_image_id_9, t0.twitter_image_id AS twitter_image_id_10 FROM seo_meta_data t0 WHERE t0.page_type = 'home' 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\Service\Context\HomePageProvider->getVariables (line 34)
5	App\EventSubscriber\PageContextSubscriber->onKernelController (line 32)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
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 35)
14	require_once (line 29)
15	require_once (line 5)

0.30 ms
(2.03%)

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.type AS type_2, m0_.url AS url_3, m0_.route AS route_4, m0_.position AS position_5, m0_.enabled AS enabled_6, m0_.updated_at AS updated_at_7, m0_.created_at AS created_at_8, m0_.path AS path_9, m0_.has_link AS has_link_10, m0_.parent_id AS parent_id_11, m0_.menu_id AS menu_id_12 FROM menu_item m0_ INNER JOIN menu m1_ ON m0_.menu_id = m1_.id WHERE m1_.type_id = ? AND m0_.parent_id IS NULL AND m0_.enabled = 1 ORDER BY m0_.position ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.type AS type_2,
  m0_.url AS url_3,
  m0_.route AS route_4,
  m0_.position AS position_5,
  m0_.enabled AS enabled_6,
  m0_.updated_at AS updated_at_7,
  m0_.created_at AS created_at_8,
  m0_.path AS path_9,
  m0_.has_link AS has_link_10,
  m0_.parent_id AS parent_id_11,
  m0_.menu_id AS menu_id_12
FROM
  menu_item m0_
  INNER JOIN menu m1_ ON m0_.menu_id = m1_.id
WHERE
  m1_.type_id = ?
  AND m0_.parent_id IS NULL
  AND m0_.enabled = 1
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.type AS type_2, m0_.url AS url_3, m0_.route AS route_4, m0_.position AS position_5, m0_.enabled AS enabled_6, m0_.updated_at AS updated_at_7, m0_.created_at AS created_at_8, m0_.path AS path_9, m0_.has_link AS has_link_10, m0_.parent_id AS parent_id_11, m0_.menu_id AS menu_id_12 FROM menu_item m0_ INNER JOIN menu m1_ ON m0_.menu_id = m1_.id WHERE m1_.type_id = 2 AND m0_.parent_id IS NULL AND m0_.enabled = 1 ORDER BY m0_.position ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\MenuItemRepository->findEnabledRootItemsByMenuType (line 75)
7	App\Twig\Components\Front\FooterMenuComponent->getItems (line 22)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_221a570eb5bbb4d26aa25bd1b57c63ae::doDisplay (line 54)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
16	__TwigTemplate_0a9dc15e764b24e011482ce50a23a97c->doDisplay (line 92)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Extension\CoreExtension->include (line 1526)
22	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661::block_footer (line 335)
23	Twig\Template->yieldBlock (line 446)
24	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661->doDisplay (line 158)
25	Twig\Template->yield (line 402)
26	__TwigTemplate_0ae3b04df313a401692a2b98f6182764->doDisplay (line 56)
27	Twig\Template->yield (line 402)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 373)
30	Twig\TemplateWrapper->render (line 51)
31	Twig\Environment->render (line 333)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
35	App\Controller\Front\HomeController->index (line 28)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
38	Symfony\Component\HttpKernel\Kernel->handle (line 193)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
40	require_once (line 29)
41	require_once (line 5)

0.28 ms
(1.91%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.type AS type_3, t0.position AS position_4, t0.enabled AS enabled_5 FROM social_network t0 WHERE t0.enabled = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.type AS type_3,
  t0.position AS position_4,
  t0.enabled AS enabled_5
FROM
  social_network t0
WHERE
  t0.enabled = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.type AS type_3, t0.position AS position_4, t0.enabled AS enabled_5 FROM social_network t0 WHERE t0.enabled = 1;

#	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\Twig\Components\Extensions\ConfigExtension->getSocialNetworks (line 40)
5	__TwigTemplate_17fbe1297bed4097cd4c59385a36cfc9->doDisplay (line 60)
6	Twig\Template->yield (line 402)
7	Twig\Template->display (line 358)
8	Twig\Template->render (line 373)
9	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
10	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
11	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
12	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661->block_header (line 276)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661->doDisplay (line 116)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_0ae3b04df313a401692a2b98f6182764->doDisplay (line 56)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
25	App\Controller\Front\HomeController->index (line 28)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 29)
31	require_once (line 5)

0.27 ms
(1.88%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.enabled AS enabled_5, t0.content AS content_6, t0.seo_id AS seo_id_7 FROM cms t0 WHERE t0.id = ?

Parameters:

[
  "13"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.enabled AS enabled_5,
  t0.content AS content_6,
  t0.seo_id AS seo_id_7
FROM
  cms t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.enabled AS enabled_5, t0.content AS content_6, t0.seo_id AS seo_id_7 FROM cms t0 WHERE t0.id = '13';

#	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\Twig\Components\Extensions\ConfigExtension->getPage (line 76)
7	__TwigTemplate_b1a8c33db99641ee2f8d7f9a950981db->doDisplay (line 50)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Extension\CoreExtension->include (line 1526)
13	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661::doDisplay (line 121)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_0ae3b04df313a401692a2b98f6182764->doDisplay (line 56)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
24	App\Controller\Front\HomeController->index (line 28)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.24 ms
(1.61%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.summary AS summary_2, p0_.content AS content_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.enabled AS enabled_6, p0_.published_at AS published_at_7, p0_.category_id AS category_id_8, p0_.seo_id AS seo_id_9 FROM post p0_ WHERE p0_.enabled = 1 AND (p0_.published_at IS NULL OR p0_.published_at <= ?) ORDER BY p0_.published_at DESC, p0_.created_at DESC LIMIT 4

Parameters:

[
  "2026-03-15 17:24:58"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.summary AS summary_2,
  p0_.content AS content_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  p0_.enabled AS enabled_6,
  p0_.published_at AS published_at_7,
  p0_.category_id AS category_id_8,
  p0_.seo_id AS seo_id_9
FROM
  post p0_
WHERE
  p0_.enabled = 1
  AND (
    p0_.published_at IS NULL
    OR p0_.published_at <= ?
  )
ORDER BY
  p0_.published_at DESC,
  p0_.created_at DESC
LIMIT
  4

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.summary AS summary_2, p0_.content AS content_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.enabled AS enabled_6, p0_.published_at AS published_at_7, p0_.category_id AS category_id_8, p0_.seo_id AS seo_id_9 FROM post p0_ WHERE p0_.enabled = 1 AND (p0_.published_at IS NULL OR p0_.published_at <= '2026-03-15 17:24:58') ORDER BY p0_.published_at DESC, p0_.created_at DESC 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\Post\PostRepository->findPaginated (line 64)
7	App\Controller\Front\HomeController->index (line 32)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.23 ms
(1.60%)

SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.title AS title_4, t0.name AS name_5, t0.link AS link_6, t0.display_home_page AS display_home_page_7, t0.display_partners_page AS display_partners_page_8, t0.description AS description_9, t0.highlighted AS highlighted_10, t0.description_highlighted_public AS description_highlighted_public_11, t0.description_highlighted_private AS description_highlighted_private_12, t0.position AS position_13, t0.enabled AS enabled_14, t0.category_id AS category_id_15 FROM partner t0 WHERE t0.display_home_page = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.alt AS alt_3,
  t0.title AS title_4,
  t0.name AS name_5,
  t0.link AS link_6,
  t0.display_home_page AS display_home_page_7,
  t0.display_partners_page AS display_partners_page_8,
  t0.description AS description_9,
  t0.highlighted AS highlighted_10,
  t0.description_highlighted_public AS description_highlighted_public_11,
  t0.description_highlighted_private AS description_highlighted_private_12,
  t0.position AS position_13,
  t0.enabled AS enabled_14,
  t0.category_id AS category_id_15
FROM
  partner t0
WHERE
  t0.display_home_page = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.title AS title_4, t0.name AS name_5, t0.link AS link_6, t0.display_home_page AS display_home_page_7, t0.display_partners_page AS display_partners_page_8, t0.description AS description_9, t0.highlighted AS highlighted_10, t0.description_highlighted_public AS description_highlighted_public_11, t0.description_highlighted_private AS description_highlighted_private_12, t0.position AS position_13, t0.enabled AS enabled_14, t0.category_id AS category_id_15 FROM partner t0 WHERE t0.display_home_page = 1 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\Controller\Front\HomeController->index (line 29)
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 35)
9	require_once (line 29)
10	require_once (line 5)

0.17 ms
(1.17%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_items AS sub_items_3 FROM menu_type t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "Footer"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sub_items AS sub_items_3
FROM
  menu_type t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_items AS sub_items_3 FROM menu_type t0 WHERE t0.name = 'Footer' 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\Components\Front\FooterMenuComponent->getItems (line 21)
5	Twig\Extension\CoreExtension->getAttribute (line 1919)
6	__TwigTemplate_221a570eb5bbb4d26aa25bd1b57c63ae::doDisplay (line 54)
7	Twig\Template->yield (line 402)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
11	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
12	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
13	__TwigTemplate_0a9dc15e764b24e011482ce50a23a97c->doDisplay (line 92)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Extension\CoreExtension->include (line 1526)
19	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661::block_footer (line 335)
20	Twig\Template->yieldBlock (line 446)
21	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661->doDisplay (line 158)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_0ae3b04df313a401692a2b98f6182764->doDisplay (line 56)
24	Twig\Template->yield (line 402)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
32	App\Controller\Front\HomeController->index (line 28)
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 35)
37	require_once (line 29)
38	require_once (line 5)

0.15 ms
(1.02%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.filter AS filter_3, t0.enabled AS enabled_4 FROM post_category 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.filter AS filter_3,
  t0.enabled AS enabled_4
FROM
  post_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.filter AS filter_3, t0.enabled AS enabled_4 FROM post_category 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->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\Post\PostCategory::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Post\PostCategory->__get (line 153)
7	App\Entity\Post\PostCategory->getName (line 45)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_070d62247f16b712a248bf3636142e0b::doDisplay (line 95)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Extension\CoreExtension->include (line 1526)
15	__TwigTemplate_26d9b8782ee2716acf8c215315bcc132::doDisplay (line 104)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Extension\CoreExtension->include (line 1526)
21	__TwigTemplate_0ae3b04df313a401692a2b98f6182764::block_body (line 221)
22	Twig\Template->yieldBlock (line 446)
23	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661->doDisplay (line 152)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_0ae3b04df313a401692a2b98f6182764->doDisplay (line 56)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Twig\TemplateWrapper->render (line 51)
30	Twig\Environment->render (line 333)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
34	App\Controller\Front\HomeController->index (line 28)
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 35)
39	require_once (line 29)
40	require_once (line 5)

0.13 ms
(0.91%)

SELECT t0.id AS id_1, t0.stars AS stars_2, t0.name AS name_3, t0.content AS content_4, t0.position AS position_5 FROM review t0 ORDER BY t0.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.stars AS stars_2,
  t0.name AS name_3,
  t0.content AS content_4,
  t0.position AS position_5
FROM
  review t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.stars AS stars_2, t0.name AS name_3, t0.content AS content_4, t0.position AS position_5 FROM review t0 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\Controller\Front\HomeController->index (line 33)
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 35)
9	require_once (line 29)
10	require_once (line 5)

0.09 ms
(0.61%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.archived AS archived_5, t0.thumbnail AS thumbnail_6, t0.filename AS filename_7 FROM file t0 WHERE t0.id = ?

Parameters:

[
  "13"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.archived AS archived_5,
  t0.thumbnail AS thumbnail_6,
  t0.filename AS filename_7
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.archived AS archived_5, t0.thumbnail AS thumbnail_6, t0.filename AS filename_7 FROM file t0 WHERE t0.id = '13';

#	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\Twig\Components\Extensions\ConfigExtension->getFileByConfig (line 64)
7	__TwigTemplate_17fbe1297bed4097cd4c59385a36cfc9->doDisplay (line 129)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
12	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
13	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
14	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661->block_header (line 276)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_bd43828e6275a6689f7c7c2e8d49f661->doDisplay (line 116)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_0ae3b04df313a401692a2b98f6182764->doDisplay (line 56)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
27	App\Controller\Front\HomeController->index (line 28)
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 35)
32	require_once (line 29)
33	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
old_db	doctrine.dbal.old_db_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\Destination\DestinationImage	95
App\Entity\Travel\Travel	62
App\Entity\Menu\MenuItem	34
App\Entity\Configuration	21
App\Entity\Partner\Partner	21
App\Entity\Destination\Destination	18
App\Entity\SeoMetaData	14
App\Entity\Partner\PartnerCategory	8
App\Entity\User\Review	6
App\Entity\Destination\DestinationMap	6
App\Entity\Cms\Block	5
App\Entity\Destination\DestinationHero	5
App\Entity\Post\Post	4
App\Entity\Post\PostImage	4
App\Entity\Config\SocialNetwork	3
App\Entity\Cms\Cms	3
App\Entity\Destination\DestinationType	3
App\Entity\Post\PostCategory	2
App\Entity\Menu\Menu	2
App\Entity\Maintenance	1
App\Entity\File	1
App\Entity\Menu\MenuType	1

Entities Mapping

Class	Mapping errors
App\Entity\Maintenance	No errors.
App\Entity\Configuration	No errors.
App\Entity\SeoMetaData	No errors.
App\Entity\FileSuperClass	No errors.
App\Entity\Image	No errors.
App\Entity\SeoImage	No errors.
App\Entity\Partner\Partner	No errors.
App\Entity\Partner\PartnerCategory	No errors.
App\Entity\Travel\Travel	No errors.
App\Entity\Destination\Destination	The field App\Entity\Destination\Destination#suggestions is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Destination\Destination#suggestions does not contain the required 'mappedBy: "suggestions"' attribute.
App\Entity\Travel\Option	No errors.
App\Entity\Travel\Rate	No errors.
App\Entity\Post\Post	No errors.
App\Entity\Post\PostCategory	No errors.
App\Entity\Post\PostImage	No errors.
App\Entity\User\Review	No errors.
App\Entity\Config\SocialNetwork	No errors.
App\Entity\File	No errors.
App\Entity\Menu\MenuItem	No errors.
App\Entity\Menu\Menu	No errors.
App\Entity\Menu\MenuType	No errors.
App\Entity\Cms\Cms	No errors.
App\Entity\Cms\Block	No errors.
App\Entity\User	The association App\Entity\User#parent refers to the inverse side field App\Entity\User#children which does not exist. The mappings App\Entity\User#subAccounts and App\Entity\User#parent are inconsistent with each other.
App\Entity\Destination\DestinationMap	No errors.
App\Entity\Destination\DestinationHero	No errors.
App\Entity\Video	No errors.
App\Entity\File\Video	No errors.
App\Entity\Destination\DestinationHeroVideo	No errors.
App\Entity\Destination\DestinationVideo	No errors.
App\Entity\Destination\DestinationType	No errors.
App\Entity\Destination\DestinationImage	No errors.
App\Entity\Destination\DestinationFile	No errors.
App\Entity\Destination\DestinationDay	No errors.
App\Entity\Appearance\Pictogram	No errors.
App\Entity\Country	The mappings App\Entity\Country#zone and App\Entity\Zone#countries are inconsistent with each other.
App\Entity\Destination\DestinationQnA	No errors.

Symfony Profiler

GET https://dev.thelliervoyages.com/

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