Symfony Profiler

Query Metrics

19 Database Queries

7 Different statements

10.14 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.48 ms
(44.14%)

SELECT t0.id AS id_1, t0.name_fr AS name_fr_2, t0.title_fr AS title_fr_3, t0.description_fr AS description_fr_4, t0.image_name_fr AS image_name_fr_5, t0.image_responsive_name_fr AS image_responsive_name_fr_6, t0.name_de AS name_de_7, t0.title_de AS title_de_8, t0.description_de AS description_de_9, t0.image_name_de AS image_name_de_10, t0.image_responsive_name_de AS image_responsive_name_de_11, t0.name_en AS name_en_12, t0.title_en AS title_en_13, t0.description_en AS description_en_14, t0.image_name_en AS image_name_en_15, t0.image_responsive_name_en AS image_responsive_name_en_16, t0.code AS code_17, t0.intro_fr AS intro_fr_18, t0.intro_de AS intro_de_19, t0.intro_en AS intro_en_20, t0.render_field AS render_field_21, t0.slug_fr AS slug_fr_22, t0.slug_en AS slug_en_23, t0.slug_de AS slug_de_24, t0.link_url_fr AS link_url_fr_25, t0.link_url_en AS link_url_en_26, t0.link_url_de AS link_url_de_27, t0.link_text_fr AS link_text_fr_28, t0.link_text_en AS link_text_en_29, t0.link_text_de AS link_text_de_30, t0.updated_at AS updated_at_31, t0.meta_description_fr AS meta_description_fr_32, t0.meta_description_en AS meta_description_en_33, t0.meta_description_de AS meta_description_de_34, t0.meta_image_fr AS meta_image_fr_35, t0.meta_image_en AS meta_image_en_36, t0.meta_image_de AS meta_image_de_37, t38.id AS id_39, t38.name AS name_40, t38.created_at AS created_at_41, t38.updated_at AS updated_at_42, t38.image_name AS image_name_43, t38.enabled AS enabled_44, t38.slug_fr AS slug_fr_45, t38.slug_de AS slug_de_46, t38.slug_en AS slug_en_47, t38.code AS code_48, t38.order_page AS order_page_49, t38.translation_id AS translation_id_50, t38.category_id AS category_id_51, t52.id AS id_53, t52.name AS name_54, t52.category_order AS category_order_55, t52.translation_id AS translation_id_56, t57.id AS id_58, t57.name AS name_59, t57.created_at AS created_at_60, t57.updated_at AS updated_at_61, t57.publish_at AS publish_at_62, t57.image_name AS image_name_63, t57.enabled AS enabled_64, t57.author AS author_65, t57.event_at AS event_at_66, t57.translation_id AS translation_id_67, t57.category_id AS category_id_68, t57.created_by_id AS created_by_id_69, t70.id AS id_71, t70.name AS name_72, t70.slug_fr AS slug_fr_73, t70.slug_en AS slug_en_74, t70.translation_id AS translation_id_75 FROM translation t0 LEFT JOIN page t38 ON t38.translation_id = t0.id LEFT JOIN page_category t52 ON t52.translation_id = t0.id LEFT JOIN post t57 ON t57.translation_id = t0.id LEFT JOIN category t70 ON t70.translation_id = t0.id WHERE t0.id = ?

Parameters:

[
  30
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name_fr AS name_fr_2,
  t0.title_fr AS title_fr_3,
  t0.description_fr AS description_fr_4,
  t0.image_name_fr AS image_name_fr_5,
  t0.image_responsive_name_fr AS image_responsive_name_fr_6,
  t0.name_de AS name_de_7,
  t0.title_de AS title_de_8,
  t0.description_de AS description_de_9,
  t0.image_name_de AS image_name_de_10,
  t0.image_responsive_name_de AS image_responsive_name_de_11,
  t0.name_en AS name_en_12,
  t0.title_en AS title_en_13,
  t0.description_en AS description_en_14,
  t0.image_name_en AS image_name_en_15,
  t0.image_responsive_name_en AS image_responsive_name_en_16,
  t0.code AS code_17,
  t0.intro_fr AS intro_fr_18,
  t0.intro_de AS intro_de_19,
  t0.intro_en AS intro_en_20,
  t0.render_field AS render_field_21,
  t0.slug_fr AS slug_fr_22,
  t0.slug_en AS slug_en_23,
  t0.slug_de AS slug_de_24,
  t0.link_url_fr AS link_url_fr_25,
  t0.link_url_en AS link_url_en_26,
  t0.link_url_de AS link_url_de_27,
  t0.link_text_fr AS link_text_fr_28,
  t0.link_text_en AS link_text_en_29,
  t0.link_text_de AS link_text_de_30,
  t0.updated_at AS updated_at_31,
  t0.meta_description_fr AS meta_description_fr_32,
  t0.meta_description_en AS meta_description_en_33,
  t0.meta_description_de AS meta_description_de_34,
  t0.meta_image_fr AS meta_image_fr_35,
  t0.meta_image_en AS meta_image_en_36,
  t0.meta_image_de AS meta_image_de_37,
  t38.id AS id_39,
  t38.name AS name_40,
  t38.created_at AS created_at_41,
  t38.updated_at AS updated_at_42,
  t38.image_name AS image_name_43,
  t38.enabled AS enabled_44,
  t38.slug_fr AS slug_fr_45,
  t38.slug_de AS slug_de_46,
  t38.slug_en AS slug_en_47,
  t38.code AS code_48,
  t38.order_page AS order_page_49,
  t38.translation_id AS translation_id_50,
  t38.category_id AS category_id_51,
  t52.id AS id_53,
  t52.name AS name_54,
  t52.category_order AS category_order_55,
  t52.translation_id AS translation_id_56,
  t57.id AS id_58,
  t57.name AS name_59,
  t57.created_at AS created_at_60,
  t57.updated_at AS updated_at_61,
  t57.publish_at AS publish_at_62,
  t57.image_name AS image_name_63,
  t57.enabled AS enabled_64,
  t57.author AS author_65,
  t57.event_at AS event_at_66,
  t57.translation_id AS translation_id_67,
  t57.category_id AS category_id_68,
  t57.created_by_id AS created_by_id_69,
  t70.id AS id_71,
  t70.name AS name_72,
  t70.slug_fr AS slug_fr_73,
  t70.slug_en AS slug_en_74,
  t70.translation_id AS translation_id_75
FROM
  translation t0
  LEFT JOIN page t38 ON t38.translation_id = t0.id
  LEFT JOIN page_category t52 ON t52.translation_id = t0.id
  LEFT JOIN post t57 ON t57.translation_id = t0.id
  LEFT JOIN category t70 ON t70.translation_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_fr AS name_fr_2, t0.title_fr AS title_fr_3, t0.description_fr AS description_fr_4, t0.image_name_fr AS image_name_fr_5, t0.image_responsive_name_fr AS image_responsive_name_fr_6, t0.name_de AS name_de_7, t0.title_de AS title_de_8, t0.description_de AS description_de_9, t0.image_name_de AS image_name_de_10, t0.image_responsive_name_de AS image_responsive_name_de_11, t0.name_en AS name_en_12, t0.title_en AS title_en_13, t0.description_en AS description_en_14, t0.image_name_en AS image_name_en_15, t0.image_responsive_name_en AS image_responsive_name_en_16, t0.code AS code_17, t0.intro_fr AS intro_fr_18, t0.intro_de AS intro_de_19, t0.intro_en AS intro_en_20, t0.render_field AS render_field_21, t0.slug_fr AS slug_fr_22, t0.slug_en AS slug_en_23, t0.slug_de AS slug_de_24, t0.link_url_fr AS link_url_fr_25, t0.link_url_en AS link_url_en_26, t0.link_url_de AS link_url_de_27, t0.link_text_fr AS link_text_fr_28, t0.link_text_en AS link_text_en_29, t0.link_text_de AS link_text_de_30, t0.updated_at AS updated_at_31, t0.meta_description_fr AS meta_description_fr_32, t0.meta_description_en AS meta_description_en_33, t0.meta_description_de AS meta_description_de_34, t0.meta_image_fr AS meta_image_fr_35, t0.meta_image_en AS meta_image_en_36, t0.meta_image_de AS meta_image_de_37, t38.id AS id_39, t38.name AS name_40, t38.created_at AS created_at_41, t38.updated_at AS updated_at_42, t38.image_name AS image_name_43, t38.enabled AS enabled_44, t38.slug_fr AS slug_fr_45, t38.slug_de AS slug_de_46, t38.slug_en AS slug_en_47, t38.code AS code_48, t38.order_page AS order_page_49, t38.translation_id AS translation_id_50, t38.category_id AS category_id_51, t52.id AS id_53, t52.name AS name_54, t52.category_order AS category_order_55, t52.translation_id AS translation_id_56, t57.id AS id_58, t57.name AS name_59, t57.created_at AS created_at_60, t57.updated_at AS updated_at_61, t57.publish_at AS publish_at_62, t57.image_name AS image_name_63, t57.enabled AS enabled_64, t57.author AS author_65, t57.event_at AS event_at_66, t57.translation_id AS translation_id_67, t57.category_id AS category_id_68, t57.created_by_id AS created_by_id_69, t70.id AS id_71, t70.name AS name_72, t70.slug_fr AS slug_fr_73, t70.slug_en AS slug_en_74, t70.translation_id AS translation_id_75 FROM translation t0 LEFT JOIN page t38 ON t38.translation_id = t0.id LEFT JOIN page_category t52 ON t52.translation_id = t0.id LEFT JOIN post t57 ON t57.translation_id = t0.id LEFT JOIN category t70 ON t70.translation_id = t0.id WHERE t0.id = 30;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Translation::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Translation->__get (line 503)
8	App\Entity\Translation->getTitleByLocale (line 1719)
9	Twig\Extension\CoreExtension::getAttribute (line 49)
10	__TwigTemplate_c3adcb0730069fae6f024a7b71d904f7->doDisplay (line 360)
11	Twig\Template->yield (line 335)
12	Twig\Template->render (line 38)
13	Twig\TemplateWrapper->render (line 306)
14	Twig\Environment->render (line 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 59)
18	App\Controller\NewsletterController->newsletter (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

1.41 ms
(13.90%)

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.image_name AS image_name_5, t0.enabled AS enabled_6, t0.slug_fr AS slug_fr_7, t0.slug_de AS slug_de_8, t0.slug_en AS slug_en_9, t0.code AS code_10, t0.order_page AS order_page_11, t0.translation_id AS translation_id_12, t0.category_id AS category_id_13 FROM page t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "newsletter"
]

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.image_name AS image_name_5,
  t0.enabled AS enabled_6,
  t0.slug_fr AS slug_fr_7,
  t0.slug_de AS slug_de_8,
  t0.slug_en AS slug_en_9,
  t0.code AS code_10,
  t0.order_page AS order_page_11,
  t0.translation_id AS translation_id_12,
  t0.category_id AS category_id_13
FROM
  page t0
WHERE
  t0.code = ?
LIMIT
  1

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.image_name AS image_name_5, t0.enabled AS enabled_6, t0.slug_fr AS slug_fr_7, t0.slug_de AS slug_de_8, t0.slug_en AS slug_en_9, t0.code AS code_10, t0.order_page AS order_page_11, t0.translation_id AS translation_id_12, t0.category_id AS category_id_13 FROM page t0 WHERE t0.code = 'newsletter' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 34)
5	App\Controller\NewsletterController->newsletter (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.29 ms
(12.74%)

SELECT t0.id AS id_1, t0.link_order AS link_order_2, t0.type AS type_3, t0.image_name AS image_name_4, t0.updated_at AS updated_at_5, t0.page_id AS page_id_6 FROM useful_link t0 WHERE t0.type = ? ORDER BY t0.link_order ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.link_order AS link_order_2,
  t0.type AS type_3,
  t0.image_name AS image_name_4,
  t0.updated_at AS updated_at_5,
  t0.page_id AS page_id_6
FROM
  useful_link t0
WHERE
  t0.type = ?
ORDER BY
  t0.link_order ASC

SELECT t0.id AS id_1, t0.link_order AS link_order_2, t0.type AS type_3, t0.image_name AS image_name_4, t0.updated_at AS updated_at_5, t0.page_id AS page_id_6 FROM useful_link t0 WHERE t0.type = 1 ORDER BY t0.link_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 34)
5	App\Components\LinkComponent->getLink (line 174)
6	App\Twig\AppExtension->getLinks (line 81)
7	__TwigTemplate_6a3940321b4b1acfe91a488ede756798->doDisplay (line 360)
8	Twig\Template->yield (line 335)
9	Twig\Template->render (line 38)
10	Twig\TemplateWrapper->render (line 1422)
11	Twig\Extension\CoreExtension::include (line 349)
12	__TwigTemplate_32f1eef0214eb98a70422112a98bc829->block_header (line 430)
13	Twig\Template->yieldBlock (line 219)
14	__TwigTemplate_32f1eef0214eb98a70422112a98bc829->doDisplay (line 360)
15	Twig\Template->yield (line 73)
16	__TwigTemplate_c3adcb0730069fae6f024a7b71d904f7->doDisplay (line 360)
17	Twig\Template->yield (line 335)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 306)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 59)
24	App\Controller\NewsletterController->newsletter (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.98 ms
(9.63%)

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.image_name AS image_name_5, t0.enabled AS enabled_6, t0.slug_fr AS slug_fr_7, t0.slug_de AS slug_de_8, t0.slug_en AS slug_en_9, t0.code AS code_10, t0.order_page AS order_page_11, t0.translation_id AS translation_id_12, t0.category_id AS category_id_13 FROM page t0 WHERE t0.category_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.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.image_name AS image_name_5,
  t0.enabled AS enabled_6,
  t0.slug_fr AS slug_fr_7,
  t0.slug_de AS slug_de_8,
  t0.slug_en AS slug_en_9,
  t0.code AS code_10,
  t0.order_page AS order_page_11,
  t0.translation_id AS translation_id_12,
  t0.category_id AS category_id_13
FROM
  page t0
WHERE
  t0.category_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.image_name AS image_name_5, t0.enabled AS enabled_6, t0.slug_fr AS slug_fr_7, t0.slug_de AS slug_de_8, t0.slug_en AS slug_en_9, t0.code AS code_10, t0.order_page AS order_page_11, t0.translation_id AS translation_id_12, t0.category_id AS category_id_13 FROM page t0 WHERE t0.category_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 68)
8	App\Entity\PageCategory->getPagesByAccess (line 1719)
9	Twig\Extension\CoreExtension::getAttribute (line 85)
10	__TwigTemplate_ea457619f63d5f71b3c2d7a3fd6926e1->doDisplay (line 360)
11	Twig\Template->yield (line 335)
12	Twig\Template->render (line 76)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 55)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 60)
15	Symfony\UX\TwigComponent\Twig\ComponentExtension->render (line 44)
16	__TwigTemplate_44de9fa09b40d6f4b30e5d78674240e8->doDisplay (line 360)
17	Twig\Template->yield (line 291)
18	__TwigTemplate_6a3940321b4b1acfe91a488ede756798->doDisplay (line 360)
19	Twig\Template->yield (line 335)
20	Twig\Template->render (line 38)
21	Twig\TemplateWrapper->render (line 1422)
22	Twig\Extension\CoreExtension::include (line 349)
23	__TwigTemplate_32f1eef0214eb98a70422112a98bc829->block_header (line 430)
24	Twig\Template->yieldBlock (line 219)
25	__TwigTemplate_32f1eef0214eb98a70422112a98bc829->doDisplay (line 360)
26	Twig\Template->yield (line 73)
27	__TwigTemplate_c3adcb0730069fae6f024a7b71d904f7->doDisplay (line 360)
28	Twig\Template->yield (line 335)
29	Twig\Template->render (line 38)
30	Twig\TemplateWrapper->render (line 306)
31	Twig\Environment->render (line 431)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 59)
35	App\Controller\NewsletterController->newsletter (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 5)

0.94 ms
(9.30%)

SELECT t0.id AS id_1, t0.name_fr AS name_fr_2, t0.title_fr AS title_fr_3, t0.description_fr AS description_fr_4, t0.image_name_fr AS image_name_fr_5, t0.image_responsive_name_fr AS image_responsive_name_fr_6, t0.name_de AS name_de_7, t0.title_de AS title_de_8, t0.description_de AS description_de_9, t0.image_name_de AS image_name_de_10, t0.image_responsive_name_de AS image_responsive_name_de_11, t0.name_en AS name_en_12, t0.title_en AS title_en_13, t0.description_en AS description_en_14, t0.image_name_en AS image_name_en_15, t0.image_responsive_name_en AS image_responsive_name_en_16, t0.code AS code_17, t0.intro_fr AS intro_fr_18, t0.intro_de AS intro_de_19, t0.intro_en AS intro_en_20, t0.render_field AS render_field_21, t0.slug_fr AS slug_fr_22, t0.slug_en AS slug_en_23, t0.slug_de AS slug_de_24, t0.link_url_fr AS link_url_fr_25, t0.link_url_en AS link_url_en_26, t0.link_url_de AS link_url_de_27, t0.link_text_fr AS link_text_fr_28, t0.link_text_en AS link_text_en_29, t0.link_text_de AS link_text_de_30, t0.updated_at AS updated_at_31, t0.meta_description_fr AS meta_description_fr_32, t0.meta_description_en AS meta_description_en_33, t0.meta_description_de AS meta_description_de_34, t0.meta_image_fr AS meta_image_fr_35, t0.meta_image_en AS meta_image_en_36, t0.meta_image_de AS meta_image_de_37, t38.id AS id_39, t38.name AS name_40, t38.created_at AS created_at_41, t38.updated_at AS updated_at_42, t38.image_name AS image_name_43, t38.enabled AS enabled_44, t38.slug_fr AS slug_fr_45, t38.slug_de AS slug_de_46, t38.slug_en AS slug_en_47, t38.code AS code_48, t38.order_page AS order_page_49, t38.translation_id AS translation_id_50, t38.category_id AS category_id_51, t52.id AS id_53, t52.name AS name_54, t52.category_order AS category_order_55, t52.translation_id AS translation_id_56, t57.id AS id_58, t57.name AS name_59, t57.created_at AS created_at_60, t57.updated_at AS updated_at_61, t57.publish_at AS publish_at_62, t57.image_name AS image_name_63, t57.enabled AS enabled_64, t57.author AS author_65, t57.event_at AS event_at_66, t57.translation_id AS translation_id_67, t57.category_id AS category_id_68, t57.created_by_id AS created_by_id_69, t70.id AS id_71, t70.name AS name_72, t70.slug_fr AS slug_fr_73, t70.slug_en AS slug_en_74, t70.translation_id AS translation_id_75 FROM translation t0 LEFT JOIN page t38 ON t38.translation_id = t0.id LEFT JOIN page_category t52 ON t52.translation_id = t0.id LEFT JOIN post t57 ON t57.translation_id = t0.id LEFT JOIN category t70 ON t70.translation_id = t0.id WHERE t0.code = ? LIMIT 1

Parameters:

[
  "form_newsletter_privacy_message"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name_fr AS name_fr_2,
  t0.title_fr AS title_fr_3,
  t0.description_fr AS description_fr_4,
  t0.image_name_fr AS image_name_fr_5,
  t0.image_responsive_name_fr AS image_responsive_name_fr_6,
  t0.name_de AS name_de_7,
  t0.title_de AS title_de_8,
  t0.description_de AS description_de_9,
  t0.image_name_de AS image_name_de_10,
  t0.image_responsive_name_de AS image_responsive_name_de_11,
  t0.name_en AS name_en_12,
  t0.title_en AS title_en_13,
  t0.description_en AS description_en_14,
  t0.image_name_en AS image_name_en_15,
  t0.image_responsive_name_en AS image_responsive_name_en_16,
  t0.code AS code_17,
  t0.intro_fr AS intro_fr_18,
  t0.intro_de AS intro_de_19,
  t0.intro_en AS intro_en_20,
  t0.render_field AS render_field_21,
  t0.slug_fr AS slug_fr_22,
  t0.slug_en AS slug_en_23,
  t0.slug_de AS slug_de_24,
  t0.link_url_fr AS link_url_fr_25,
  t0.link_url_en AS link_url_en_26,
  t0.link_url_de AS link_url_de_27,
  t0.link_text_fr AS link_text_fr_28,
  t0.link_text_en AS link_text_en_29,
  t0.link_text_de AS link_text_de_30,
  t0.updated_at AS updated_at_31,
  t0.meta_description_fr AS meta_description_fr_32,
  t0.meta_description_en AS meta_description_en_33,
  t0.meta_description_de AS meta_description_de_34,
  t0.meta_image_fr AS meta_image_fr_35,
  t0.meta_image_en AS meta_image_en_36,
  t0.meta_image_de AS meta_image_de_37,
  t38.id AS id_39,
  t38.name AS name_40,
  t38.created_at AS created_at_41,
  t38.updated_at AS updated_at_42,
  t38.image_name AS image_name_43,
  t38.enabled AS enabled_44,
  t38.slug_fr AS slug_fr_45,
  t38.slug_de AS slug_de_46,
  t38.slug_en AS slug_en_47,
  t38.code AS code_48,
  t38.order_page AS order_page_49,
  t38.translation_id AS translation_id_50,
  t38.category_id AS category_id_51,
  t52.id AS id_53,
  t52.name AS name_54,
  t52.category_order AS category_order_55,
  t52.translation_id AS translation_id_56,
  t57.id AS id_58,
  t57.name AS name_59,
  t57.created_at AS created_at_60,
  t57.updated_at AS updated_at_61,
  t57.publish_at AS publish_at_62,
  t57.image_name AS image_name_63,
  t57.enabled AS enabled_64,
  t57.author AS author_65,
  t57.event_at AS event_at_66,
  t57.translation_id AS translation_id_67,
  t57.category_id AS category_id_68,
  t57.created_by_id AS created_by_id_69,
  t70.id AS id_71,
  t70.name AS name_72,
  t70.slug_fr AS slug_fr_73,
  t70.slug_en AS slug_en_74,
  t70.translation_id AS translation_id_75
FROM
  translation t0
  LEFT JOIN page t38 ON t38.translation_id = t0.id
  LEFT JOIN page_category t52 ON t52.translation_id = t0.id
  LEFT JOIN post t57 ON t57.translation_id = t0.id
  LEFT JOIN category t70 ON t70.translation_id = t0.id
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name_fr AS name_fr_2, t0.title_fr AS title_fr_3, t0.description_fr AS description_fr_4, t0.image_name_fr AS image_name_fr_5, t0.image_responsive_name_fr AS image_responsive_name_fr_6, t0.name_de AS name_de_7, t0.title_de AS title_de_8, t0.description_de AS description_de_9, t0.image_name_de AS image_name_de_10, t0.image_responsive_name_de AS image_responsive_name_de_11, t0.name_en AS name_en_12, t0.title_en AS title_en_13, t0.description_en AS description_en_14, t0.image_name_en AS image_name_en_15, t0.image_responsive_name_en AS image_responsive_name_en_16, t0.code AS code_17, t0.intro_fr AS intro_fr_18, t0.intro_de AS intro_de_19, t0.intro_en AS intro_en_20, t0.render_field AS render_field_21, t0.slug_fr AS slug_fr_22, t0.slug_en AS slug_en_23, t0.slug_de AS slug_de_24, t0.link_url_fr AS link_url_fr_25, t0.link_url_en AS link_url_en_26, t0.link_url_de AS link_url_de_27, t0.link_text_fr AS link_text_fr_28, t0.link_text_en AS link_text_en_29, t0.link_text_de AS link_text_de_30, t0.updated_at AS updated_at_31, t0.meta_description_fr AS meta_description_fr_32, t0.meta_description_en AS meta_description_en_33, t0.meta_description_de AS meta_description_de_34, t0.meta_image_fr AS meta_image_fr_35, t0.meta_image_en AS meta_image_en_36, t0.meta_image_de AS meta_image_de_37, t38.id AS id_39, t38.name AS name_40, t38.created_at AS created_at_41, t38.updated_at AS updated_at_42, t38.image_name AS image_name_43, t38.enabled AS enabled_44, t38.slug_fr AS slug_fr_45, t38.slug_de AS slug_de_46, t38.slug_en AS slug_en_47, t38.code AS code_48, t38.order_page AS order_page_49, t38.translation_id AS translation_id_50, t38.category_id AS category_id_51, t52.id AS id_53, t52.name AS name_54, t52.category_order AS category_order_55, t52.translation_id AS translation_id_56, t57.id AS id_58, t57.name AS name_59, t57.created_at AS created_at_60, t57.updated_at AS updated_at_61, t57.publish_at AS publish_at_62, t57.image_name AS image_name_63, t57.enabled AS enabled_64, t57.author AS author_65, t57.event_at AS event_at_66, t57.translation_id AS translation_id_67, t57.category_id AS category_id_68, t57.created_by_id AS created_by_id_69, t70.id AS id_71, t70.name AS name_72, t70.slug_fr AS slug_fr_73, t70.slug_en AS slug_en_74, t70.translation_id AS translation_id_75 FROM translation t0 LEFT JOIN page t38 ON t38.translation_id = t0.id LEFT JOIN page_category t52 ON t52.translation_id = t0.id LEFT JOIN post t57 ON t57.translation_id = t0.id LEFT JOIN category t70 ON t70.translation_id = t0.id WHERE t0.code = 'form_newsletter_privacy_message' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 74)
5	App\Components\TranslationComponent->getTranslationResult (line 35)
6	App\Components\TranslationComponent->App\Components\{closure} (line 48)
7	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
8	Symfony\Component\Cache\LockRegistry::compute (line 102)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
13	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 32)
14	App\Components\TranslationComponent->getTranslation (line 1719)
15	Twig\Extension\CoreExtension::getAttribute (line 47)
16	__TwigTemplate_299b68515fcf69fcacbd032f481044cf->doDisplay (line 360)
17	Twig\Template->yield (line 335)
18	Twig\Template->render (line 76)
19	Symfony\UX\TwigComponent\ComponentRenderer->render (line 55)
20	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 60)
21	Symfony\UX\TwigComponent\Twig\ComponentExtension->render (line 185)
22	__TwigTemplate_1820866636fab40f66e352deab039c6d->doDisplay (line 360)
23	Twig\Template->yield (line 335)
24	Twig\Template->render (line 38)
25	Twig\TemplateWrapper->render (line 1422)
26	Twig\Extension\CoreExtension::include (line 126)
27	__TwigTemplate_c3adcb0730069fae6f024a7b71d904f7->block_body (line 430)
28	Twig\Template->yieldBlock (line 224)
29	__TwigTemplate_32f1eef0214eb98a70422112a98bc829->doDisplay (line 360)
30	Twig\Template->yield (line 73)
31	__TwigTemplate_c3adcb0730069fae6f024a7b71d904f7->doDisplay (line 360)
32	Twig\Template->yield (line 335)
33	Twig\Template->render (line 38)
34	Twig\TemplateWrapper->render (line 306)
35	Twig\Environment->render (line 431)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 59)
39	App\Controller\NewsletterController->newsletter (line 183)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
42	Symfony\Component\HttpKernel\Kernel->handle (line 35)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
44	require_once (line 5)

0.69 ms
(6.84%)

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.image_name AS image_name_5, t0.enabled AS enabled_6, t0.slug_fr AS slug_fr_7, t0.slug_de AS slug_de_8, t0.slug_en AS slug_en_9, t0.code AS code_10, t0.order_page AS order_page_11, t0.translation_id AS translation_id_12, t0.category_id AS category_id_13 FROM page t0 WHERE t0.id = ?

Parameters:

[
  8
]

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.image_name AS image_name_5,
  t0.enabled AS enabled_6,
  t0.slug_fr AS slug_fr_7,
  t0.slug_de AS slug_de_8,
  t0.slug_en AS slug_en_9,
  t0.code AS code_10,
  t0.order_page AS order_page_11,
  t0.translation_id AS translation_id_12,
  t0.category_id AS category_id_13
FROM
  page 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.image_name AS image_name_5, t0.enabled AS enabled_6, t0.slug_fr AS slug_fr_7, t0.slug_de AS slug_de_8, t0.slug_en AS slug_en_9, t0.code AS code_10, t0.order_page AS order_page_11, t0.translation_id AS translation_id_12, t0.category_id AS category_id_13 FROM page t0 WHERE t0.id = 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Page::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Page->__get (line 228)
8	App\Entity\Page->getSlugByLocale (line 1719)
9	Twig\Extension\CoreExtension::getAttribute (line 108)
10	__TwigTemplate_6a3940321b4b1acfe91a488ede756798->doDisplay (line 360)
11	Twig\Template->yield (line 335)
12	Twig\Template->render (line 38)
13	Twig\TemplateWrapper->render (line 1422)
14	Twig\Extension\CoreExtension::include (line 349)
15	__TwigTemplate_32f1eef0214eb98a70422112a98bc829->block_header (line 430)
16	Twig\Template->yieldBlock (line 219)
17	__TwigTemplate_32f1eef0214eb98a70422112a98bc829->doDisplay (line 360)
18	Twig\Template->yield (line 73)
19	__TwigTemplate_c3adcb0730069fae6f024a7b71d904f7->doDisplay (line 360)
20	Twig\Template->yield (line 335)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 306)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 59)
27	App\Controller\NewsletterController->newsletter (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.35 ms
(3.44%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.category_order AS category_order_3, t0.translation_id AS translation_id_4 FROM page_category t0 ORDER BY t0.category_order ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.category_order AS category_order_3,
  t0.translation_id AS translation_id_4
FROM
  page_category t0
ORDER BY
  t0.category_order ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.category_order AS category_order_3, t0.translation_id AS translation_id_4 FROM page_category t0 ORDER BY t0.category_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 18)
5	App\Components\MenuComponent->getMenu (line 1719)
6	Twig\Extension\CoreExtension::getAttribute (line 68)
7	__TwigTemplate_ea457619f63d5f71b3c2d7a3fd6926e1->doDisplay (line 360)
8	Twig\Template->yield (line 335)
9	Twig\Template->render (line 76)
10	Symfony\UX\TwigComponent\ComponentRenderer->render (line 55)
11	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 60)
12	Symfony\UX\TwigComponent\Twig\ComponentExtension->render (line 44)
13	__TwigTemplate_44de9fa09b40d6f4b30e5d78674240e8->doDisplay (line 360)
14	Twig\Template->yield (line 291)
15	__TwigTemplate_6a3940321b4b1acfe91a488ede756798->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 1422)
19	Twig\Extension\CoreExtension::include (line 349)
20	__TwigTemplate_32f1eef0214eb98a70422112a98bc829->block_header (line 430)
21	Twig\Template->yieldBlock (line 219)
22	__TwigTemplate_32f1eef0214eb98a70422112a98bc829->doDisplay (line 360)
23	Twig\Template->yield (line 73)
24	__TwigTemplate_c3adcb0730069fae6f024a7b71d904f7->doDisplay (line 360)
25	Twig\Template->yield (line 335)
26	Twig\Template->render (line 38)
27	Twig\TemplateWrapper->render (line 306)
28	Twig\Environment->render (line 431)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 59)
32	App\Controller\NewsletterController->newsletter (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\Translation	No errors.
App\Entity\PageCategory	No errors.
App\Entity\Bloc	No errors.
App\Entity\UsefulLink	No errors.
App\Entity\Post	No errors.
App\Entity\Category	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://staging.goldenfluteclassic.ch/fr/newsletter/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping