Symfony Profiler

Query Metrics

58 Database Queries

18 Different statements

13.59 ms Query time

6 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.84 ms
(35.61%)

SELECT t0.id AS id_1, t0.disable AS disable_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.description AS description_5, t0.info_text AS info_text_6, t0.features_text AS features_text_7, t0.features_pdf_name AS features_pdf_name_8, t0.features_pdf_size AS features_pdf_size_9, t0.features_pdf_updated_at AS features_pdf_updated_at_10, t0.features_pdf_title AS features_pdf_title_11, t0.products_range_text AS products_range_text_12, t0.products_range_pdf_name AS products_range_pdf_name_13, t0.products_range_pdf_size AS products_range_pdf_size_14, t0.products_range_pdf_updated_at AS products_range_pdf_updated_at_15, t0.products_range_pdf_title AS products_range_pdf_title_16, t0.regulatory_notices_text AS regulatory_notices_text_17, t0.contact_email AS contact_email_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.slug AS slug_21, t22.published AS published_23, t22.available_on_pwa AS available_on_pwa_24, t22.id AS id_25, t22.position AS position_26, t22.category_id AS category_id_27, t22.homepage_id AS homepage_id_28, t22.translation_en_id AS translation_en_id_29, t22.translation_fr_id AS translation_fr_id_30, t22.translation_us_id AS translation_us_id_31, t22.translation_es_id AS translation_es_id_32, t22.translation_de_id AS translation_de_id_33, t22.translation_pt_id AS translation_pt_id_34, t35.published AS published_36, t35.available_on_pwa AS available_on_pwa_37, t35.id AS id_38, t35.position AS position_39, t35.category_id AS category_id_40, t35.homepage_id AS homepage_id_41, t35.translation_en_id AS translation_en_id_42, t35.translation_fr_id AS translation_fr_id_43, t35.translation_us_id AS translation_us_id_44, t35.translation_es_id AS translation_es_id_45, t35.translation_de_id AS translation_de_id_46, t35.translation_pt_id AS translation_pt_id_47, t48.published AS published_49, t48.available_on_pwa AS available_on_pwa_50, t48.id AS id_51, t48.position AS position_52, t48.category_id AS category_id_53, t48.homepage_id AS homepage_id_54, t48.translation_en_id AS translation_en_id_55, t48.translation_fr_id AS translation_fr_id_56, t48.translation_us_id AS translation_us_id_57, t48.translation_es_id AS translation_es_id_58, t48.translation_de_id AS translation_de_id_59, t48.translation_pt_id AS translation_pt_id_60, t61.published AS published_62, t61.available_on_pwa AS available_on_pwa_63, t61.id AS id_64, t61.position AS position_65, t61.category_id AS category_id_66, t61.homepage_id AS homepage_id_67, t61.translation_en_id AS translation_en_id_68, t61.translation_fr_id AS translation_fr_id_69, t61.translation_us_id AS translation_us_id_70, t61.translation_es_id AS translation_es_id_71, t61.translation_de_id AS translation_de_id_72, t61.translation_pt_id AS translation_pt_id_73, t74.published AS published_75, t74.available_on_pwa AS available_on_pwa_76, t74.id AS id_77, t74.position AS position_78, t74.category_id AS category_id_79, t74.homepage_id AS homepage_id_80, t74.translation_en_id AS translation_en_id_81, t74.translation_fr_id AS translation_fr_id_82, t74.translation_us_id AS translation_us_id_83, t74.translation_es_id AS translation_es_id_84, t74.translation_de_id AS translation_de_id_85, t74.translation_pt_id AS translation_pt_id_86, t87.published AS published_88, t87.available_on_pwa AS available_on_pwa_89, t87.id AS id_90, t87.position AS position_91, t87.category_id AS category_id_92, t87.homepage_id AS homepage_id_93, t87.translation_en_id AS translation_en_id_94, t87.translation_fr_id AS translation_fr_id_95, t87.translation_us_id AS translation_us_id_96, t87.translation_es_id AS translation_es_id_97, t87.translation_de_id AS translation_de_id_98, t87.translation_pt_id AS translation_pt_id_99 FROM product t0 LEFT JOIN product_global t22 ON t22.translation_en_id = t0.id LEFT JOIN product_global t35 ON t35.translation_fr_id = t0.id LEFT JOIN product_global t48 ON t48.translation_us_id = t0.id LEFT JOIN product_global t61 ON t61.translation_es_id = t0.id LEFT JOIN product_global t74 ON t74.translation_de_id = t0.id LEFT JOIN product_global t87 ON t87.translation_pt_id = t0.id WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.disable AS disable_2,
  t0.title AS title_3,
  t0.sub_title AS sub_title_4,
  t0.description AS description_5,
  t0.info_text AS info_text_6,
  t0.features_text AS features_text_7,
  t0.features_pdf_name AS features_pdf_name_8,
  t0.features_pdf_size AS features_pdf_size_9,
  t0.features_pdf_updated_at AS features_pdf_updated_at_10,
  t0.features_pdf_title AS features_pdf_title_11,
  t0.products_range_text AS products_range_text_12,
  t0.products_range_pdf_name AS products_range_pdf_name_13,
  t0.products_range_pdf_size AS products_range_pdf_size_14,
  t0.products_range_pdf_updated_at AS products_range_pdf_updated_at_15,
  t0.products_range_pdf_title AS products_range_pdf_title_16,
  t0.regulatory_notices_text AS regulatory_notices_text_17,
  t0.contact_email AS contact_email_18,
  t0.meta_title AS meta_title_19,
  t0.meta_description AS meta_description_20,
  t0.slug AS slug_21,
  t22.published AS published_23,
  t22.available_on_pwa AS available_on_pwa_24,
  t22.id AS id_25,
  t22.position AS position_26,
  t22.category_id AS category_id_27,
  t22.homepage_id AS homepage_id_28,
  t22.translation_en_id AS translation_en_id_29,
  t22.translation_fr_id AS translation_fr_id_30,
  t22.translation_us_id AS translation_us_id_31,
  t22.translation_es_id AS translation_es_id_32,
  t22.translation_de_id AS translation_de_id_33,
  t22.translation_pt_id AS translation_pt_id_34,
  t35.published AS published_36,
  t35.available_on_pwa AS available_on_pwa_37,
  t35.id AS id_38,
  t35.position AS position_39,
  t35.category_id AS category_id_40,
  t35.homepage_id AS homepage_id_41,
  t35.translation_en_id AS translation_en_id_42,
  t35.translation_fr_id AS translation_fr_id_43,
  t35.translation_us_id AS translation_us_id_44,
  t35.translation_es_id AS translation_es_id_45,
  t35.translation_de_id AS translation_de_id_46,
  t35.translation_pt_id AS translation_pt_id_47,
  t48.published AS published_49,
  t48.available_on_pwa AS available_on_pwa_50,
  t48.id AS id_51,
  t48.position AS position_52,
  t48.category_id AS category_id_53,
  t48.homepage_id AS homepage_id_54,
  t48.translation_en_id AS translation_en_id_55,
  t48.translation_fr_id AS translation_fr_id_56,
  t48.translation_us_id AS translation_us_id_57,
  t48.translation_es_id AS translation_es_id_58,
  t48.translation_de_id AS translation_de_id_59,
  t48.translation_pt_id AS translation_pt_id_60,
  t61.published AS published_62,
  t61.available_on_pwa AS available_on_pwa_63,
  t61.id AS id_64,
  t61.position AS position_65,
  t61.category_id AS category_id_66,
  t61.homepage_id AS homepage_id_67,
  t61.translation_en_id AS translation_en_id_68,
  t61.translation_fr_id AS translation_fr_id_69,
  t61.translation_us_id AS translation_us_id_70,
  t61.translation_es_id AS translation_es_id_71,
  t61.translation_de_id AS translation_de_id_72,
  t61.translation_pt_id AS translation_pt_id_73,
  t74.published AS published_75,
  t74.available_on_pwa AS available_on_pwa_76,
  t74.id AS id_77,
  t74.position AS position_78,
  t74.category_id AS category_id_79,
  t74.homepage_id AS homepage_id_80,
  t74.translation_en_id AS translation_en_id_81,
  t74.translation_fr_id AS translation_fr_id_82,
  t74.translation_us_id AS translation_us_id_83,
  t74.translation_es_id AS translation_es_id_84,
  t74.translation_de_id AS translation_de_id_85,
  t74.translation_pt_id AS translation_pt_id_86,
  t87.published AS published_88,
  t87.available_on_pwa AS available_on_pwa_89,
  t87.id AS id_90,
  t87.position AS position_91,
  t87.category_id AS category_id_92,
  t87.homepage_id AS homepage_id_93,
  t87.translation_en_id AS translation_en_id_94,
  t87.translation_fr_id AS translation_fr_id_95,
  t87.translation_us_id AS translation_us_id_96,
  t87.translation_es_id AS translation_es_id_97,
  t87.translation_de_id AS translation_de_id_98,
  t87.translation_pt_id AS translation_pt_id_99
FROM
  product t0
  LEFT JOIN product_global t22 ON t22.translation_en_id = t0.id
  LEFT JOIN product_global t35 ON t35.translation_fr_id = t0.id
  LEFT JOIN product_global t48 ON t48.translation_us_id = t0.id
  LEFT JOIN product_global t61 ON t61.translation_es_id = t0.id
  LEFT JOIN product_global t74 ON t74.translation_de_id = t0.id
  LEFT JOIN product_global t87 ON t87.translation_pt_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.disable AS disable_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.description AS description_5, t0.info_text AS info_text_6, t0.features_text AS features_text_7, t0.features_pdf_name AS features_pdf_name_8, t0.features_pdf_size AS features_pdf_size_9, t0.features_pdf_updated_at AS features_pdf_updated_at_10, t0.features_pdf_title AS features_pdf_title_11, t0.products_range_text AS products_range_text_12, t0.products_range_pdf_name AS products_range_pdf_name_13, t0.products_range_pdf_size AS products_range_pdf_size_14, t0.products_range_pdf_updated_at AS products_range_pdf_updated_at_15, t0.products_range_pdf_title AS products_range_pdf_title_16, t0.regulatory_notices_text AS regulatory_notices_text_17, t0.contact_email AS contact_email_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.slug AS slug_21, t22.published AS published_23, t22.available_on_pwa AS available_on_pwa_24, t22.id AS id_25, t22.position AS position_26, t22.category_id AS category_id_27, t22.homepage_id AS homepage_id_28, t22.translation_en_id AS translation_en_id_29, t22.translation_fr_id AS translation_fr_id_30, t22.translation_us_id AS translation_us_id_31, t22.translation_es_id AS translation_es_id_32, t22.translation_de_id AS translation_de_id_33, t22.translation_pt_id AS translation_pt_id_34, t35.published AS published_36, t35.available_on_pwa AS available_on_pwa_37, t35.id AS id_38, t35.position AS position_39, t35.category_id AS category_id_40, t35.homepage_id AS homepage_id_41, t35.translation_en_id AS translation_en_id_42, t35.translation_fr_id AS translation_fr_id_43, t35.translation_us_id AS translation_us_id_44, t35.translation_es_id AS translation_es_id_45, t35.translation_de_id AS translation_de_id_46, t35.translation_pt_id AS translation_pt_id_47, t48.published AS published_49, t48.available_on_pwa AS available_on_pwa_50, t48.id AS id_51, t48.position AS position_52, t48.category_id AS category_id_53, t48.homepage_id AS homepage_id_54, t48.translation_en_id AS translation_en_id_55, t48.translation_fr_id AS translation_fr_id_56, t48.translation_us_id AS translation_us_id_57, t48.translation_es_id AS translation_es_id_58, t48.translation_de_id AS translation_de_id_59, t48.translation_pt_id AS translation_pt_id_60, t61.published AS published_62, t61.available_on_pwa AS available_on_pwa_63, t61.id AS id_64, t61.position AS position_65, t61.category_id AS category_id_66, t61.homepage_id AS homepage_id_67, t61.translation_en_id AS translation_en_id_68, t61.translation_fr_id AS translation_fr_id_69, t61.translation_us_id AS translation_us_id_70, t61.translation_es_id AS translation_es_id_71, t61.translation_de_id AS translation_de_id_72, t61.translation_pt_id AS translation_pt_id_73, t74.published AS published_75, t74.available_on_pwa AS available_on_pwa_76, t74.id AS id_77, t74.position AS position_78, t74.category_id AS category_id_79, t74.homepage_id AS homepage_id_80, t74.translation_en_id AS translation_en_id_81, t74.translation_fr_id AS translation_fr_id_82, t74.translation_us_id AS translation_us_id_83, t74.translation_es_id AS translation_es_id_84, t74.translation_de_id AS translation_de_id_85, t74.translation_pt_id AS translation_pt_id_86, t87.published AS published_88, t87.available_on_pwa AS available_on_pwa_89, t87.id AS id_90, t87.position AS position_91, t87.category_id AS category_id_92, t87.homepage_id AS homepage_id_93, t87.translation_en_id AS translation_en_id_94, t87.translation_fr_id AS translation_fr_id_95, t87.translation_us_id AS translation_us_id_96, t87.translation_es_id AS translation_es_id_97, t87.translation_de_id AS translation_de_id_98, t87.translation_pt_id AS translation_pt_id_99 FROM product t0 LEFT JOIN product_global t22 ON t22.translation_en_id = t0.id LEFT JOIN product_global t35 ON t35.translation_fr_id = t0.id LEFT JOIN product_global t48 ON t48.translation_us_id = t0.id LEFT JOIN product_global t61 ON t61.translation_es_id = t0.id LEFT JOIN product_global t74 ON t74.translation_de_id = t0.id LEFT JOIN product_global t87 ON t87.translation_pt_id = t0.id WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Product\Product::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\Product\Product->__get (line 161)
8	App\Entity\Product\Product->isDisable (line 94)
9	App\Entity\Product\ProductGlobal->__call (line 72)
10	App\Twig\AppExtension->getHeaderNavLinks (line 52)
11	__TwigTemplate_6181214b782d879a6aada1fbbba20314->doDisplay (line 387)
12	Twig\Template->yield (line 222)
13	__TwigTemplate_b9ceb83130e3a11866601ee9b2e1010f->doDisplay (line 387)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->doDisplay (line 387)
16	Twig\Template->yield (line 343)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 320)
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 297)
24	App\Controller\FrontController->aboutUsPage (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

2.53 ms
(18.60%)

SELECT t0.id AS id_1, t0.picture_name AS picture_name_2, t0.picture_size AS picture_size_3, t0.picture_updated_at AS picture_updated_at_4, t0.picture_alt AS picture_alt_5, t0.video_link AS video_link_6, t0.position AS position_7, t0.product_feature_id AS product_feature_id_8, t0.product_products_range_id AS product_products_range_id_9, t0.product_id AS product_id_10 FROM product_media t0 WHERE t0.product_id = ? ORDER BY t0.position ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.picture_name AS picture_name_2,
  t0.picture_size AS picture_size_3,
  t0.picture_updated_at AS picture_updated_at_4,
  t0.picture_alt AS picture_alt_5,
  t0.video_link AS video_link_6,
  t0.position AS position_7,
  t0.product_feature_id AS product_feature_id_8,
  t0.product_products_range_id AS product_products_range_id_9,
  t0.product_id AS product_id_10
FROM
  product_media t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.picture_name AS picture_name_2, t0.picture_size AS picture_size_3, t0.picture_updated_at AS picture_updated_at_4, t0.picture_alt AS picture_alt_5, t0.video_link AS video_link_6, t0.position AS position_7, t0.product_feature_id AS product_feature_id_8, t0.product_products_range_id AS product_products_range_id_9, t0.product_id AS product_id_10 FROM product_media t0 WHERE t0.product_id = 2 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 95)
9	App\Entity\Product\ProductGlobal->__call (line 1861)
10	Twig\Extension\CoreExtension::getAttribute (line 237)
11	__TwigTemplate_6181214b782d879a6aada1fbbba20314->block_header (line 431)
12	Twig\Template->yieldBlock (line 57)
13	__TwigTemplate_6181214b782d879a6aada1fbbba20314->doDisplay (line 387)
14	Twig\Template->yield (line 222)
15	__TwigTemplate_b9ceb83130e3a11866601ee9b2e1010f->doDisplay (line 387)
16	Twig\Template->yield (line 54)
17	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->doDisplay (line 387)
18	Twig\Template->yield (line 343)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 35)
21	Twig\TemplateWrapper->render (line 320)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 297)
26	App\Controller\FrontController->aboutUsPage (line 178)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

1.44 ms
(10.58%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.intro_title AS intro_title_3, t0.intro_text AS intro_text_4, t0.intro_picture_name AS intro_picture_name_5, t0.intro_picture_size AS intro_picture_size_6, t0.intro_picture_updated_at AS intro_picture_updated_at_7, t0.intro_picture_alt AS intro_picture_alt_8, t0.intro_video_link AS intro_video_link_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.slug AS slug_12, t13.picture_name AS picture_name_14, t13.picture_size AS picture_size_15, t13.picture_updated_at AS picture_updated_at_16, t13.picture_alt AS picture_alt_17, t13.id AS id_18, t13.parent_id AS parent_id_19, t13.translation_en_id AS translation_en_id_20, t13.translation_fr_id AS translation_fr_id_21, t13.translation_us_id AS translation_us_id_22, t13.translation_es_id AS translation_es_id_23, t13.translation_de_id AS translation_de_id_24, t13.translation_pt_id AS translation_pt_id_25, t26.picture_name AS picture_name_27, t26.picture_size AS picture_size_28, t26.picture_updated_at AS picture_updated_at_29, t26.picture_alt AS picture_alt_30, t26.id AS id_31, t26.parent_id AS parent_id_32, t26.translation_en_id AS translation_en_id_33, t26.translation_fr_id AS translation_fr_id_34, t26.translation_us_id AS translation_us_id_35, t26.translation_es_id AS translation_es_id_36, t26.translation_de_id AS translation_de_id_37, t26.translation_pt_id AS translation_pt_id_38, t39.picture_name AS picture_name_40, t39.picture_size AS picture_size_41, t39.picture_updated_at AS picture_updated_at_42, t39.picture_alt AS picture_alt_43, t39.id AS id_44, t39.parent_id AS parent_id_45, t39.translation_en_id AS translation_en_id_46, t39.translation_fr_id AS translation_fr_id_47, t39.translation_us_id AS translation_us_id_48, t39.translation_es_id AS translation_es_id_49, t39.translation_de_id AS translation_de_id_50, t39.translation_pt_id AS translation_pt_id_51, t52.picture_name AS picture_name_53, t52.picture_size AS picture_size_54, t52.picture_updated_at AS picture_updated_at_55, t52.picture_alt AS picture_alt_56, t52.id AS id_57, t52.parent_id AS parent_id_58, t52.translation_en_id AS translation_en_id_59, t52.translation_fr_id AS translation_fr_id_60, t52.translation_us_id AS translation_us_id_61, t52.translation_es_id AS translation_es_id_62, t52.translation_de_id AS translation_de_id_63, t52.translation_pt_id AS translation_pt_id_64, t65.picture_name AS picture_name_66, t65.picture_size AS picture_size_67, t65.picture_updated_at AS picture_updated_at_68, t65.picture_alt AS picture_alt_69, t65.id AS id_70, t65.parent_id AS parent_id_71, t65.translation_en_id AS translation_en_id_72, t65.translation_fr_id AS translation_fr_id_73, t65.translation_us_id AS translation_us_id_74, t65.translation_es_id AS translation_es_id_75, t65.translation_de_id AS translation_de_id_76, t65.translation_pt_id AS translation_pt_id_77, t78.picture_name AS picture_name_79, t78.picture_size AS picture_size_80, t78.picture_updated_at AS picture_updated_at_81, t78.picture_alt AS picture_alt_82, t78.id AS id_83, t78.parent_id AS parent_id_84, t78.translation_en_id AS translation_en_id_85, t78.translation_fr_id AS translation_fr_id_86, t78.translation_us_id AS translation_us_id_87, t78.translation_es_id AS translation_es_id_88, t78.translation_de_id AS translation_de_id_89, t78.translation_pt_id AS translation_pt_id_90 FROM product_category t0 LEFT JOIN product_category_global t13 ON t13.translation_en_id = t0.id LEFT JOIN product_category_global t26 ON t26.translation_fr_id = t0.id LEFT JOIN product_category_global t39 ON t39.translation_us_id = t0.id LEFT JOIN product_category_global t52 ON t52.translation_es_id = t0.id LEFT JOIN product_category_global t65 ON t65.translation_de_id = t0.id LEFT JOIN product_category_global t78 ON t78.translation_pt_id = t0.id WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.intro_title AS intro_title_3,
  t0.intro_text AS intro_text_4,
  t0.intro_picture_name AS intro_picture_name_5,
  t0.intro_picture_size AS intro_picture_size_6,
  t0.intro_picture_updated_at AS intro_picture_updated_at_7,
  t0.intro_picture_alt AS intro_picture_alt_8,
  t0.intro_video_link AS intro_video_link_9,
  t0.meta_title AS meta_title_10,
  t0.meta_description AS meta_description_11,
  t0.slug AS slug_12,
  t13.picture_name AS picture_name_14,
  t13.picture_size AS picture_size_15,
  t13.picture_updated_at AS picture_updated_at_16,
  t13.picture_alt AS picture_alt_17,
  t13.id AS id_18,
  t13.parent_id AS parent_id_19,
  t13.translation_en_id AS translation_en_id_20,
  t13.translation_fr_id AS translation_fr_id_21,
  t13.translation_us_id AS translation_us_id_22,
  t13.translation_es_id AS translation_es_id_23,
  t13.translation_de_id AS translation_de_id_24,
  t13.translation_pt_id AS translation_pt_id_25,
  t26.picture_name AS picture_name_27,
  t26.picture_size AS picture_size_28,
  t26.picture_updated_at AS picture_updated_at_29,
  t26.picture_alt AS picture_alt_30,
  t26.id AS id_31,
  t26.parent_id AS parent_id_32,
  t26.translation_en_id AS translation_en_id_33,
  t26.translation_fr_id AS translation_fr_id_34,
  t26.translation_us_id AS translation_us_id_35,
  t26.translation_es_id AS translation_es_id_36,
  t26.translation_de_id AS translation_de_id_37,
  t26.translation_pt_id AS translation_pt_id_38,
  t39.picture_name AS picture_name_40,
  t39.picture_size AS picture_size_41,
  t39.picture_updated_at AS picture_updated_at_42,
  t39.picture_alt AS picture_alt_43,
  t39.id AS id_44,
  t39.parent_id AS parent_id_45,
  t39.translation_en_id AS translation_en_id_46,
  t39.translation_fr_id AS translation_fr_id_47,
  t39.translation_us_id AS translation_us_id_48,
  t39.translation_es_id AS translation_es_id_49,
  t39.translation_de_id AS translation_de_id_50,
  t39.translation_pt_id AS translation_pt_id_51,
  t52.picture_name AS picture_name_53,
  t52.picture_size AS picture_size_54,
  t52.picture_updated_at AS picture_updated_at_55,
  t52.picture_alt AS picture_alt_56,
  t52.id AS id_57,
  t52.parent_id AS parent_id_58,
  t52.translation_en_id AS translation_en_id_59,
  t52.translation_fr_id AS translation_fr_id_60,
  t52.translation_us_id AS translation_us_id_61,
  t52.translation_es_id AS translation_es_id_62,
  t52.translation_de_id AS translation_de_id_63,
  t52.translation_pt_id AS translation_pt_id_64,
  t65.picture_name AS picture_name_66,
  t65.picture_size AS picture_size_67,
  t65.picture_updated_at AS picture_updated_at_68,
  t65.picture_alt AS picture_alt_69,
  t65.id AS id_70,
  t65.parent_id AS parent_id_71,
  t65.translation_en_id AS translation_en_id_72,
  t65.translation_fr_id AS translation_fr_id_73,
  t65.translation_us_id AS translation_us_id_74,
  t65.translation_es_id AS translation_es_id_75,
  t65.translation_de_id AS translation_de_id_76,
  t65.translation_pt_id AS translation_pt_id_77,
  t78.picture_name AS picture_name_79,
  t78.picture_size AS picture_size_80,
  t78.picture_updated_at AS picture_updated_at_81,
  t78.picture_alt AS picture_alt_82,
  t78.id AS id_83,
  t78.parent_id AS parent_id_84,
  t78.translation_en_id AS translation_en_id_85,
  t78.translation_fr_id AS translation_fr_id_86,
  t78.translation_us_id AS translation_us_id_87,
  t78.translation_es_id AS translation_es_id_88,
  t78.translation_de_id AS translation_de_id_89,
  t78.translation_pt_id AS translation_pt_id_90
FROM
  product_category t0
  LEFT JOIN product_category_global t13 ON t13.translation_en_id = t0.id
  LEFT JOIN product_category_global t26 ON t26.translation_fr_id = t0.id
  LEFT JOIN product_category_global t39 ON t39.translation_us_id = t0.id
  LEFT JOIN product_category_global t52 ON t52.translation_es_id = t0.id
  LEFT JOIN product_category_global t65 ON t65.translation_de_id = t0.id
  LEFT JOIN product_category_global t78 ON t78.translation_pt_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.intro_title AS intro_title_3, t0.intro_text AS intro_text_4, t0.intro_picture_name AS intro_picture_name_5, t0.intro_picture_size AS intro_picture_size_6, t0.intro_picture_updated_at AS intro_picture_updated_at_7, t0.intro_picture_alt AS intro_picture_alt_8, t0.intro_video_link AS intro_video_link_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.slug AS slug_12, t13.picture_name AS picture_name_14, t13.picture_size AS picture_size_15, t13.picture_updated_at AS picture_updated_at_16, t13.picture_alt AS picture_alt_17, t13.id AS id_18, t13.parent_id AS parent_id_19, t13.translation_en_id AS translation_en_id_20, t13.translation_fr_id AS translation_fr_id_21, t13.translation_us_id AS translation_us_id_22, t13.translation_es_id AS translation_es_id_23, t13.translation_de_id AS translation_de_id_24, t13.translation_pt_id AS translation_pt_id_25, t26.picture_name AS picture_name_27, t26.picture_size AS picture_size_28, t26.picture_updated_at AS picture_updated_at_29, t26.picture_alt AS picture_alt_30, t26.id AS id_31, t26.parent_id AS parent_id_32, t26.translation_en_id AS translation_en_id_33, t26.translation_fr_id AS translation_fr_id_34, t26.translation_us_id AS translation_us_id_35, t26.translation_es_id AS translation_es_id_36, t26.translation_de_id AS translation_de_id_37, t26.translation_pt_id AS translation_pt_id_38, t39.picture_name AS picture_name_40, t39.picture_size AS picture_size_41, t39.picture_updated_at AS picture_updated_at_42, t39.picture_alt AS picture_alt_43, t39.id AS id_44, t39.parent_id AS parent_id_45, t39.translation_en_id AS translation_en_id_46, t39.translation_fr_id AS translation_fr_id_47, t39.translation_us_id AS translation_us_id_48, t39.translation_es_id AS translation_es_id_49, t39.translation_de_id AS translation_de_id_50, t39.translation_pt_id AS translation_pt_id_51, t52.picture_name AS picture_name_53, t52.picture_size AS picture_size_54, t52.picture_updated_at AS picture_updated_at_55, t52.picture_alt AS picture_alt_56, t52.id AS id_57, t52.parent_id AS parent_id_58, t52.translation_en_id AS translation_en_id_59, t52.translation_fr_id AS translation_fr_id_60, t52.translation_us_id AS translation_us_id_61, t52.translation_es_id AS translation_es_id_62, t52.translation_de_id AS translation_de_id_63, t52.translation_pt_id AS translation_pt_id_64, t65.picture_name AS picture_name_66, t65.picture_size AS picture_size_67, t65.picture_updated_at AS picture_updated_at_68, t65.picture_alt AS picture_alt_69, t65.id AS id_70, t65.parent_id AS parent_id_71, t65.translation_en_id AS translation_en_id_72, t65.translation_fr_id AS translation_fr_id_73, t65.translation_us_id AS translation_us_id_74, t65.translation_es_id AS translation_es_id_75, t65.translation_de_id AS translation_de_id_76, t65.translation_pt_id AS translation_pt_id_77, t78.picture_name AS picture_name_79, t78.picture_size AS picture_size_80, t78.picture_updated_at AS picture_updated_at_81, t78.picture_alt AS picture_alt_82, t78.id AS id_83, t78.parent_id AS parent_id_84, t78.translation_en_id AS translation_en_id_85, t78.translation_fr_id AS translation_fr_id_86, t78.translation_us_id AS translation_us_id_87, t78.translation_es_id AS translation_es_id_88, t78.translation_de_id AS translation_de_id_89, t78.translation_pt_id AS translation_pt_id_90 FROM product_category t0 LEFT JOIN product_category_global t13 ON t13.translation_en_id = t0.id LEFT JOIN product_category_global t26 ON t26.translation_fr_id = t0.id LEFT JOIN product_category_global t39 ON t39.translation_us_id = t0.id LEFT JOIN product_category_global t52 ON t52.translation_es_id = t0.id LEFT JOIN product_category_global t65 ON t65.translation_de_id = t0.id LEFT JOIN product_category_global t78 ON t78.translation_pt_id = t0.id WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Product\ProductCategory::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\Product\ProductCategory->__get (line 22)
8	App\Entity\Product\ProductCategory->getSlug (line 94)
9	App\Entity\Product\ProductCategoryGlobal->__call (line 68)
10	App\Twig\AppExtension->getHeaderNavLinks (line 52)
11	__TwigTemplate_6181214b782d879a6aada1fbbba20314->doDisplay (line 387)
12	Twig\Template->yield (line 222)
13	__TwigTemplate_b9ceb83130e3a11866601ee9b2e1010f->doDisplay (line 387)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->doDisplay (line 387)
16	Twig\Template->yield (line 343)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 320)
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 297)
24	App\Controller\FrontController->aboutUsPage (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.86 ms
(6.33%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.slug AS slug_5, t0.header_picture_name AS header_picture_name_6, t0.header_picture_size AS header_picture_size_7, t0.header_picture_updated_at AS header_picture_updated_at_8, t0.header_picture_alt AS header_picture_alt_9, t10.event AS event_11, t10.id AS id_12, t10.translation_en_id AS translation_en_id_13, t10.translation_fr_id AS translation_fr_id_14, t10.translation_us_id AS translation_us_id_15, t10.translation_es_id AS translation_es_id_16, t10.translation_de_id AS translation_de_id_17, t10.translation_pt_id AS translation_pt_id_18, t19.event AS event_20, t19.id AS id_21, t19.translation_en_id AS translation_en_id_22, t19.translation_fr_id AS translation_fr_id_23, t19.translation_us_id AS translation_us_id_24, t19.translation_es_id AS translation_es_id_25, t19.translation_de_id AS translation_de_id_26, t19.translation_pt_id AS translation_pt_id_27, t28.event AS event_29, t28.id AS id_30, t28.translation_en_id AS translation_en_id_31, t28.translation_fr_id AS translation_fr_id_32, t28.translation_us_id AS translation_us_id_33, t28.translation_es_id AS translation_es_id_34, t28.translation_de_id AS translation_de_id_35, t28.translation_pt_id AS translation_pt_id_36, t37.event AS event_38, t37.id AS id_39, t37.translation_en_id AS translation_en_id_40, t37.translation_fr_id AS translation_fr_id_41, t37.translation_us_id AS translation_us_id_42, t37.translation_es_id AS translation_es_id_43, t37.translation_de_id AS translation_de_id_44, t37.translation_pt_id AS translation_pt_id_45, t46.event AS event_47, t46.id AS id_48, t46.translation_en_id AS translation_en_id_49, t46.translation_fr_id AS translation_fr_id_50, t46.translation_us_id AS translation_us_id_51, t46.translation_es_id AS translation_es_id_52, t46.translation_de_id AS translation_de_id_53, t46.translation_pt_id AS translation_pt_id_54, t55.event AS event_56, t55.id AS id_57, t55.translation_en_id AS translation_en_id_58, t55.translation_fr_id AS translation_fr_id_59, t55.translation_us_id AS translation_us_id_60, t55.translation_es_id AS translation_es_id_61, t55.translation_de_id AS translation_de_id_62, t55.translation_pt_id AS translation_pt_id_63 FROM article_category t0 LEFT JOIN article_category_global t10 ON t10.translation_en_id = t0.id LEFT JOIN article_category_global t19 ON t19.translation_fr_id = t0.id LEFT JOIN article_category_global t28 ON t28.translation_us_id = t0.id LEFT JOIN article_category_global t37 ON t37.translation_es_id = t0.id LEFT JOIN article_category_global t46 ON t46.translation_de_id = t0.id LEFT JOIN article_category_global t55 ON t55.translation_pt_id = t0.id WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.slug AS slug_5,
  t0.header_picture_name AS header_picture_name_6,
  t0.header_picture_size AS header_picture_size_7,
  t0.header_picture_updated_at AS header_picture_updated_at_8,
  t0.header_picture_alt AS header_picture_alt_9,
  t10.event AS event_11,
  t10.id AS id_12,
  t10.translation_en_id AS translation_en_id_13,
  t10.translation_fr_id AS translation_fr_id_14,
  t10.translation_us_id AS translation_us_id_15,
  t10.translation_es_id AS translation_es_id_16,
  t10.translation_de_id AS translation_de_id_17,
  t10.translation_pt_id AS translation_pt_id_18,
  t19.event AS event_20,
  t19.id AS id_21,
  t19.translation_en_id AS translation_en_id_22,
  t19.translation_fr_id AS translation_fr_id_23,
  t19.translation_us_id AS translation_us_id_24,
  t19.translation_es_id AS translation_es_id_25,
  t19.translation_de_id AS translation_de_id_26,
  t19.translation_pt_id AS translation_pt_id_27,
  t28.event AS event_29,
  t28.id AS id_30,
  t28.translation_en_id AS translation_en_id_31,
  t28.translation_fr_id AS translation_fr_id_32,
  t28.translation_us_id AS translation_us_id_33,
  t28.translation_es_id AS translation_es_id_34,
  t28.translation_de_id AS translation_de_id_35,
  t28.translation_pt_id AS translation_pt_id_36,
  t37.event AS event_38,
  t37.id AS id_39,
  t37.translation_en_id AS translation_en_id_40,
  t37.translation_fr_id AS translation_fr_id_41,
  t37.translation_us_id AS translation_us_id_42,
  t37.translation_es_id AS translation_es_id_43,
  t37.translation_de_id AS translation_de_id_44,
  t37.translation_pt_id AS translation_pt_id_45,
  t46.event AS event_47,
  t46.id AS id_48,
  t46.translation_en_id AS translation_en_id_49,
  t46.translation_fr_id AS translation_fr_id_50,
  t46.translation_us_id AS translation_us_id_51,
  t46.translation_es_id AS translation_es_id_52,
  t46.translation_de_id AS translation_de_id_53,
  t46.translation_pt_id AS translation_pt_id_54,
  t55.event AS event_56,
  t55.id AS id_57,
  t55.translation_en_id AS translation_en_id_58,
  t55.translation_fr_id AS translation_fr_id_59,
  t55.translation_us_id AS translation_us_id_60,
  t55.translation_es_id AS translation_es_id_61,
  t55.translation_de_id AS translation_de_id_62,
  t55.translation_pt_id AS translation_pt_id_63
FROM
  article_category t0
  LEFT JOIN article_category_global t10 ON t10.translation_en_id = t0.id
  LEFT JOIN article_category_global t19 ON t19.translation_fr_id = t0.id
  LEFT JOIN article_category_global t28 ON t28.translation_us_id = t0.id
  LEFT JOIN article_category_global t37 ON t37.translation_es_id = t0.id
  LEFT JOIN article_category_global t46 ON t46.translation_de_id = t0.id
  LEFT JOIN article_category_global t55 ON t55.translation_pt_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.slug AS slug_5, t0.header_picture_name AS header_picture_name_6, t0.header_picture_size AS header_picture_size_7, t0.header_picture_updated_at AS header_picture_updated_at_8, t0.header_picture_alt AS header_picture_alt_9, t10.event AS event_11, t10.id AS id_12, t10.translation_en_id AS translation_en_id_13, t10.translation_fr_id AS translation_fr_id_14, t10.translation_us_id AS translation_us_id_15, t10.translation_es_id AS translation_es_id_16, t10.translation_de_id AS translation_de_id_17, t10.translation_pt_id AS translation_pt_id_18, t19.event AS event_20, t19.id AS id_21, t19.translation_en_id AS translation_en_id_22, t19.translation_fr_id AS translation_fr_id_23, t19.translation_us_id AS translation_us_id_24, t19.translation_es_id AS translation_es_id_25, t19.translation_de_id AS translation_de_id_26, t19.translation_pt_id AS translation_pt_id_27, t28.event AS event_29, t28.id AS id_30, t28.translation_en_id AS translation_en_id_31, t28.translation_fr_id AS translation_fr_id_32, t28.translation_us_id AS translation_us_id_33, t28.translation_es_id AS translation_es_id_34, t28.translation_de_id AS translation_de_id_35, t28.translation_pt_id AS translation_pt_id_36, t37.event AS event_38, t37.id AS id_39, t37.translation_en_id AS translation_en_id_40, t37.translation_fr_id AS translation_fr_id_41, t37.translation_us_id AS translation_us_id_42, t37.translation_es_id AS translation_es_id_43, t37.translation_de_id AS translation_de_id_44, t37.translation_pt_id AS translation_pt_id_45, t46.event AS event_47, t46.id AS id_48, t46.translation_en_id AS translation_en_id_49, t46.translation_fr_id AS translation_fr_id_50, t46.translation_us_id AS translation_us_id_51, t46.translation_es_id AS translation_es_id_52, t46.translation_de_id AS translation_de_id_53, t46.translation_pt_id AS translation_pt_id_54, t55.event AS event_56, t55.id AS id_57, t55.translation_en_id AS translation_en_id_58, t55.translation_fr_id AS translation_fr_id_59, t55.translation_us_id AS translation_us_id_60, t55.translation_es_id AS translation_es_id_61, t55.translation_de_id AS translation_de_id_62, t55.translation_pt_id AS translation_pt_id_63 FROM article_category t0 LEFT JOIN article_category_global t10 ON t10.translation_en_id = t0.id LEFT JOIN article_category_global t19 ON t19.translation_fr_id = t0.id LEFT JOIN article_category_global t28 ON t28.translation_us_id = t0.id LEFT JOIN article_category_global t37 ON t37.translation_es_id = t0.id LEFT JOIN article_category_global t46 ON t46.translation_de_id = t0.id LEFT JOIN article_category_global t55 ON t55.translation_pt_id = t0.id WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Blog\ArticleCategory::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\Blog\ArticleCategory->__get (line 50)
8	App\Entity\Blog\ArticleCategory->getTitle (line 94)
9	App\Entity\Blog\ArticleCategoryGlobal->__call (line 94)
10	App\Twig\AppExtension->getHeaderNavLinks (line 52)
11	__TwigTemplate_6181214b782d879a6aada1fbbba20314->doDisplay (line 387)
12	Twig\Template->yield (line 222)
13	__TwigTemplate_b9ceb83130e3a11866601ee9b2e1010f->doDisplay (line 387)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->doDisplay (line 387)
16	Twig\Template->yield (line 343)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 320)
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 297)
24	App\Controller\FrontController->aboutUsPage (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.74 ms
(5.48%)

SELECT t0.published AS published_1, t0.available_on_pwa AS available_on_pwa_2, t0.id AS id_3, t0.position AS position_4, t0.category_id AS category_id_5, t0.homepage_id AS homepage_id_6, t0.translation_en_id AS translation_en_id_7, t0.translation_fr_id AS translation_fr_id_8, t0.translation_us_id AS translation_us_id_9, t0.translation_es_id AS translation_es_id_10, t0.translation_de_id AS translation_de_id_11, t0.translation_pt_id AS translation_pt_id_12 FROM product_global t0 WHERE t0.category_id = ? ORDER BY t0.position ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.published AS published_1,
  t0.available_on_pwa AS available_on_pwa_2,
  t0.id AS id_3,
  t0.position AS position_4,
  t0.category_id AS category_id_5,
  t0.homepage_id AS homepage_id_6,
  t0.translation_en_id AS translation_en_id_7,
  t0.translation_fr_id AS translation_fr_id_8,
  t0.translation_us_id AS translation_us_id_9,
  t0.translation_es_id AS translation_es_id_10,
  t0.translation_de_id AS translation_de_id_11,
  t0.translation_pt_id AS translation_pt_id_12
FROM
  product_global t0
WHERE
  t0.category_id = ?
ORDER BY
  t0.position ASC

SELECT t0.published AS published_1, t0.available_on_pwa AS available_on_pwa_2, t0.id AS id_3, t0.position AS position_4, t0.category_id AS category_id_5, t0.homepage_id AS homepage_id_6, t0.translation_en_id AS translation_en_id_7, t0.translation_fr_id AS translation_fr_id_8, t0.translation_us_id AS translation_us_id_9, t0.translation_es_id AS translation_es_id_10, t0.translation_de_id AS translation_de_id_11, t0.translation_pt_id AS translation_pt_id_12 FROM product_global t0 WHERE t0.category_id = 2 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 71)
8	App\Twig\AppExtension->getHeaderNavLinks (line 52)
9	__TwigTemplate_6181214b782d879a6aada1fbbba20314->doDisplay (line 387)
10	Twig\Template->yield (line 222)
11	__TwigTemplate_b9ceb83130e3a11866601ee9b2e1010f->doDisplay (line 387)
12	Twig\Template->yield (line 54)
13	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->doDisplay (line 387)
14	Twig\Template->yield (line 343)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 35)
17	Twig\TemplateWrapper->render (line 320)
18	Twig\Environment->render (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 297)
22	App\Controller\FrontController->aboutUsPage (line 178)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.61 ms
(4.51%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.icon_name AS icon_name_4, t0.icon_size AS icon_size_5, t0.icon_updated_at AS icon_updated_at_6, t0.icon_alt AS icon_alt_7 FROM footer_icon t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.text AS text_3,
  t0.icon_name AS icon_name_4,
  t0.icon_size AS icon_size_5,
  t0.icon_updated_at AS icon_updated_at_6,
  t0.icon_alt AS icon_alt_7
FROM
  footer_icon t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.icon_name AS icon_name_4, t0.icon_size AS icon_size_5, t0.icon_updated_at AS icon_updated_at_6, t0.icon_alt AS icon_alt_7 FROM footer_icon t0 WHERE t0.id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\FooterIcon::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 79)
7	Proxies\__CG__\App\Entity\FooterIcon->__load (line 79)
8	Vich\UploaderBundle\Mapping\PropertyMappingFactory->fromField (line 138)
9	Vich\UploaderBundle\Storage\AbstractStorage->getFilename (line 68)
10	Vich\UploaderBundle\Storage\FileSystemStorage->resolveUri (line 35)
11	Vich\UploaderBundle\Templating\Helper\UploaderHelper->asset (line 89)
12	App\Entity\FooterIconGlobal->__call (line 1861)
13	Twig\Extension\CoreExtension::getAttribute (line 90)
14	__TwigTemplate_d64331db3d6ec0e18a55bb01c8d9ba59->block_footer (line 431)
15	Twig\Template->yieldBlock (line 54)
16	__TwigTemplate_d64331db3d6ec0e18a55bb01c8d9ba59->doDisplay (line 387)
17	Twig\Template->yield (line 268)
18	__TwigTemplate_b9ceb83130e3a11866601ee9b2e1010f->doDisplay (line 387)
19	Twig\Template->yield (line 54)
20	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 35)
24	Twig\TemplateWrapper->render (line 320)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 297)
29	App\Controller\FrontController->aboutUsPage (line 178)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.46 ms
(3.41%)

SELECT t0.intro_picture1_name AS intro_picture1_name_1, t0.intro_picture1_size AS intro_picture1_size_2, t0.intro_picture1_updated_at AS intro_picture1_updated_at_3, t0.pdf_file_size AS pdf_file_size_4, t0.pdf_name AS pdf_name_5, t0.pdf_name_user AS pdf_name_user_6, t0.pdf_file_updated_at AS pdf_file_updated_at_7, t0.intro_picture1_alt AS intro_picture1_alt_8, t0.intro_picture2_name AS intro_picture2_name_9, t0.intro_picture2_size AS intro_picture2_size_10, t0.intro_picture2_updated_at AS intro_picture2_updated_at_11, t0.youtube_name AS youtube_name_12, t0.intro_picture2_alt AS intro_picture2_alt_13, t0.intro_over_title AS intro_over_title_14, t0.intro_title AS intro_title_15, t0.intro_text AS intro_text_16, t0.intro_text2 AS intro_text2_17, t0.distrib_over_title AS distrib_over_title_18, t0.distrib_title AS distrib_title_19, t0.distrib_map_name AS distrib_map_name_20, t0.distrib_map_size AS distrib_map_size_21, t0.distrib_map_updated_at AS distrib_map_updated_at_22, t0.distrib_map_alt AS distrib_map_alt_23, t0.values_over_title AS values_over_title_24, t0.values_title AS values_title_25, t0.commitment_over_title AS commitment_over_title_26, t0.commitment_title AS commitment_title_27, t0.certif_title AS certif_title_28, t0.certif_summary AS certif_summary_29, t0.id AS id_30, t0.header_picture_name AS header_picture_name_31, t0.header_picture_size AS header_picture_size_32, t0.header_picture_updated_at AS header_picture_updated_at_33, t0.header_picture_alt AS header_picture_alt_34, t0.meta_title AS meta_title_35, t0.meta_description AS meta_description_36, t0.end_block1_id AS end_block1_id_37, t0.end_block2_id AS end_block2_id_38, t39.id AS id_40, t39.translation_en_id AS translation_en_id_41, t39.translation_fr_id AS translation_fr_id_42, t39.translation_us_id AS translation_us_id_43, t39.translation_es_id AS translation_es_id_44, t39.translation_de_id AS translation_de_id_45, t39.translation_pt_id AS translation_pt_id_46, t47.id AS id_48, t47.translation_en_id AS translation_en_id_49, t47.translation_fr_id AS translation_fr_id_50, t47.translation_us_id AS translation_us_id_51, t47.translation_es_id AS translation_es_id_52, t47.translation_de_id AS translation_de_id_53, t47.translation_pt_id AS translation_pt_id_54, t55.id AS id_56, t55.translation_en_id AS translation_en_id_57, t55.translation_fr_id AS translation_fr_id_58, t55.translation_us_id AS translation_us_id_59, t55.translation_es_id AS translation_es_id_60, t55.translation_de_id AS translation_de_id_61, t55.translation_pt_id AS translation_pt_id_62, t63.id AS id_64, t63.translation_en_id AS translation_en_id_65, t63.translation_fr_id AS translation_fr_id_66, t63.translation_us_id AS translation_us_id_67, t63.translation_es_id AS translation_es_id_68, t63.translation_de_id AS translation_de_id_69, t63.translation_pt_id AS translation_pt_id_70, t71.id AS id_72, t71.translation_en_id AS translation_en_id_73, t71.translation_fr_id AS translation_fr_id_74, t71.translation_us_id AS translation_us_id_75, t71.translation_es_id AS translation_es_id_76, t71.translation_de_id AS translation_de_id_77, t71.translation_pt_id AS translation_pt_id_78, t79.id AS id_80, t79.translation_en_id AS translation_en_id_81, t79.translation_fr_id AS translation_fr_id_82, t79.translation_us_id AS translation_us_id_83, t79.translation_es_id AS translation_es_id_84, t79.translation_de_id AS translation_de_id_85, t79.translation_pt_id AS translation_pt_id_86 FROM about_us_page t0 LEFT JOIN about_us_page_global t39 ON t39.translation_en_id = t0.id LEFT JOIN about_us_page_global t47 ON t47.translation_fr_id = t0.id LEFT JOIN about_us_page_global t55 ON t55.translation_us_id = t0.id LEFT JOIN about_us_page_global t63 ON t63.translation_es_id = t0.id LEFT JOIN about_us_page_global t71 ON t71.translation_de_id = t0.id LEFT JOIN about_us_page_global t79 ON t79.translation_pt_id = t0.id WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.intro_picture1_name AS intro_picture1_name_1,
  t0.intro_picture1_size AS intro_picture1_size_2,
  t0.intro_picture1_updated_at AS intro_picture1_updated_at_3,
  t0.pdf_file_size AS pdf_file_size_4,
  t0.pdf_name AS pdf_name_5,
  t0.pdf_name_user AS pdf_name_user_6,
  t0.pdf_file_updated_at AS pdf_file_updated_at_7,
  t0.intro_picture1_alt AS intro_picture1_alt_8,
  t0.intro_picture2_name AS intro_picture2_name_9,
  t0.intro_picture2_size AS intro_picture2_size_10,
  t0.intro_picture2_updated_at AS intro_picture2_updated_at_11,
  t0.youtube_name AS youtube_name_12,
  t0.intro_picture2_alt AS intro_picture2_alt_13,
  t0.intro_over_title AS intro_over_title_14,
  t0.intro_title AS intro_title_15,
  t0.intro_text AS intro_text_16,
  t0.intro_text2 AS intro_text2_17,
  t0.distrib_over_title AS distrib_over_title_18,
  t0.distrib_title AS distrib_title_19,
  t0.distrib_map_name AS distrib_map_name_20,
  t0.distrib_map_size AS distrib_map_size_21,
  t0.distrib_map_updated_at AS distrib_map_updated_at_22,
  t0.distrib_map_alt AS distrib_map_alt_23,
  t0.values_over_title AS values_over_title_24,
  t0.values_title AS values_title_25,
  t0.commitment_over_title AS commitment_over_title_26,
  t0.commitment_title AS commitment_title_27,
  t0.certif_title AS certif_title_28,
  t0.certif_summary AS certif_summary_29,
  t0.id AS id_30,
  t0.header_picture_name AS header_picture_name_31,
  t0.header_picture_size AS header_picture_size_32,
  t0.header_picture_updated_at AS header_picture_updated_at_33,
  t0.header_picture_alt AS header_picture_alt_34,
  t0.meta_title AS meta_title_35,
  t0.meta_description AS meta_description_36,
  t0.end_block1_id AS end_block1_id_37,
  t0.end_block2_id AS end_block2_id_38,
  t39.id AS id_40,
  t39.translation_en_id AS translation_en_id_41,
  t39.translation_fr_id AS translation_fr_id_42,
  t39.translation_us_id AS translation_us_id_43,
  t39.translation_es_id AS translation_es_id_44,
  t39.translation_de_id AS translation_de_id_45,
  t39.translation_pt_id AS translation_pt_id_46,
  t47.id AS id_48,
  t47.translation_en_id AS translation_en_id_49,
  t47.translation_fr_id AS translation_fr_id_50,
  t47.translation_us_id AS translation_us_id_51,
  t47.translation_es_id AS translation_es_id_52,
  t47.translation_de_id AS translation_de_id_53,
  t47.translation_pt_id AS translation_pt_id_54,
  t55.id AS id_56,
  t55.translation_en_id AS translation_en_id_57,
  t55.translation_fr_id AS translation_fr_id_58,
  t55.translation_us_id AS translation_us_id_59,
  t55.translation_es_id AS translation_es_id_60,
  t55.translation_de_id AS translation_de_id_61,
  t55.translation_pt_id AS translation_pt_id_62,
  t63.id AS id_64,
  t63.translation_en_id AS translation_en_id_65,
  t63.translation_fr_id AS translation_fr_id_66,
  t63.translation_us_id AS translation_us_id_67,
  t63.translation_es_id AS translation_es_id_68,
  t63.translation_de_id AS translation_de_id_69,
  t63.translation_pt_id AS translation_pt_id_70,
  t71.id AS id_72,
  t71.translation_en_id AS translation_en_id_73,
  t71.translation_fr_id AS translation_fr_id_74,
  t71.translation_us_id AS translation_us_id_75,
  t71.translation_es_id AS translation_es_id_76,
  t71.translation_de_id AS translation_de_id_77,
  t71.translation_pt_id AS translation_pt_id_78,
  t79.id AS id_80,
  t79.translation_en_id AS translation_en_id_81,
  t79.translation_fr_id AS translation_fr_id_82,
  t79.translation_us_id AS translation_us_id_83,
  t79.translation_es_id AS translation_es_id_84,
  t79.translation_de_id AS translation_de_id_85,
  t79.translation_pt_id AS translation_pt_id_86
FROM
  about_us_page t0
  LEFT JOIN about_us_page_global t39 ON t39.translation_en_id = t0.id
  LEFT JOIN about_us_page_global t47 ON t47.translation_fr_id = t0.id
  LEFT JOIN about_us_page_global t55 ON t55.translation_us_id = t0.id
  LEFT JOIN about_us_page_global t63 ON t63.translation_es_id = t0.id
  LEFT JOIN about_us_page_global t71 ON t71.translation_de_id = t0.id
  LEFT JOIN about_us_page_global t79 ON t79.translation_pt_id = t0.id
WHERE
  t0.id = ?

SELECT t0.intro_picture1_name AS intro_picture1_name_1, t0.intro_picture1_size AS intro_picture1_size_2, t0.intro_picture1_updated_at AS intro_picture1_updated_at_3, t0.pdf_file_size AS pdf_file_size_4, t0.pdf_name AS pdf_name_5, t0.pdf_name_user AS pdf_name_user_6, t0.pdf_file_updated_at AS pdf_file_updated_at_7, t0.intro_picture1_alt AS intro_picture1_alt_8, t0.intro_picture2_name AS intro_picture2_name_9, t0.intro_picture2_size AS intro_picture2_size_10, t0.intro_picture2_updated_at AS intro_picture2_updated_at_11, t0.youtube_name AS youtube_name_12, t0.intro_picture2_alt AS intro_picture2_alt_13, t0.intro_over_title AS intro_over_title_14, t0.intro_title AS intro_title_15, t0.intro_text AS intro_text_16, t0.intro_text2 AS intro_text2_17, t0.distrib_over_title AS distrib_over_title_18, t0.distrib_title AS distrib_title_19, t0.distrib_map_name AS distrib_map_name_20, t0.distrib_map_size AS distrib_map_size_21, t0.distrib_map_updated_at AS distrib_map_updated_at_22, t0.distrib_map_alt AS distrib_map_alt_23, t0.values_over_title AS values_over_title_24, t0.values_title AS values_title_25, t0.commitment_over_title AS commitment_over_title_26, t0.commitment_title AS commitment_title_27, t0.certif_title AS certif_title_28, t0.certif_summary AS certif_summary_29, t0.id AS id_30, t0.header_picture_name AS header_picture_name_31, t0.header_picture_size AS header_picture_size_32, t0.header_picture_updated_at AS header_picture_updated_at_33, t0.header_picture_alt AS header_picture_alt_34, t0.meta_title AS meta_title_35, t0.meta_description AS meta_description_36, t0.end_block1_id AS end_block1_id_37, t0.end_block2_id AS end_block2_id_38, t39.id AS id_40, t39.translation_en_id AS translation_en_id_41, t39.translation_fr_id AS translation_fr_id_42, t39.translation_us_id AS translation_us_id_43, t39.translation_es_id AS translation_es_id_44, t39.translation_de_id AS translation_de_id_45, t39.translation_pt_id AS translation_pt_id_46, t47.id AS id_48, t47.translation_en_id AS translation_en_id_49, t47.translation_fr_id AS translation_fr_id_50, t47.translation_us_id AS translation_us_id_51, t47.translation_es_id AS translation_es_id_52, t47.translation_de_id AS translation_de_id_53, t47.translation_pt_id AS translation_pt_id_54, t55.id AS id_56, t55.translation_en_id AS translation_en_id_57, t55.translation_fr_id AS translation_fr_id_58, t55.translation_us_id AS translation_us_id_59, t55.translation_es_id AS translation_es_id_60, t55.translation_de_id AS translation_de_id_61, t55.translation_pt_id AS translation_pt_id_62, t63.id AS id_64, t63.translation_en_id AS translation_en_id_65, t63.translation_fr_id AS translation_fr_id_66, t63.translation_us_id AS translation_us_id_67, t63.translation_es_id AS translation_es_id_68, t63.translation_de_id AS translation_de_id_69, t63.translation_pt_id AS translation_pt_id_70, t71.id AS id_72, t71.translation_en_id AS translation_en_id_73, t71.translation_fr_id AS translation_fr_id_74, t71.translation_us_id AS translation_us_id_75, t71.translation_es_id AS translation_es_id_76, t71.translation_de_id AS translation_de_id_77, t71.translation_pt_id AS translation_pt_id_78, t79.id AS id_80, t79.translation_en_id AS translation_en_id_81, t79.translation_fr_id AS translation_fr_id_82, t79.translation_us_id AS translation_us_id_83, t79.translation_es_id AS translation_es_id_84, t79.translation_de_id AS translation_de_id_85, t79.translation_pt_id AS translation_pt_id_86 FROM about_us_page t0 LEFT JOIN about_us_page_global t39 ON t39.translation_en_id = t0.id LEFT JOIN about_us_page_global t47 ON t47.translation_fr_id = t0.id LEFT JOIN about_us_page_global t55 ON t55.translation_us_id = t0.id LEFT JOIN about_us_page_global t63 ON t63.translation_es_id = t0.id LEFT JOIN about_us_page_global t71 ON t71.translation_de_id = t0.id LEFT JOIN about_us_page_global t79 ON t79.translation_pt_id = t0.id WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\AboutUs\AboutUsPage::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\AboutUs\AboutUsPage->__get (line 25)
8	App\Entity\AboutUs\AboutUsPage->getMetaTitle (line 94)
9	App\Entity\AboutUs\AboutUsPageGlobal->__call (line 1861)
10	Twig\Extension\CoreExtension::getAttribute (line 89)
11	__TwigTemplate_b9ceb83130e3a11866601ee9b2e1010f->doDisplay (line 387)
12	Twig\Template->yield (line 54)
13	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->doDisplay (line 387)
14	Twig\Template->yield (line 343)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 35)
17	Twig\TemplateWrapper->render (line 320)
18	Twig\Environment->render (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 297)
22	App\Controller\FrontController->aboutUsPage (line 178)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.32 ms
(2.32%)

SELECT s0_.id AS id_0, s0_.page_name AS page_name_1, s0_.route AS route_2, s0_.h1_enabled AS h1_enabled_3, s0_.translation_en_id AS translation_en_id_4, s0_.translation_fr_id AS translation_fr_id_5, s0_.translation_us_id AS translation_us_id_6, s0_.translation_es_id AS translation_es_id_7, s0_.translation_de_id AS translation_de_id_8, s0_.translation_pt_id AS translation_pt_id_9 FROM seopage_global s0_ WHERE s0_.route = ?

Parameters:

[
  "app_about_us_page_index"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.page_name AS page_name_1,
  s0_.route AS route_2,
  s0_.h1_enabled AS h1_enabled_3,
  s0_.translation_en_id AS translation_en_id_4,
  s0_.translation_fr_id AS translation_fr_id_5,
  s0_.translation_us_id AS translation_us_id_6,
  s0_.translation_es_id AS translation_es_id_7,
  s0_.translation_de_id AS translation_de_id_8,
  s0_.translation_pt_id AS translation_pt_id_9
FROM
  seopage_global s0_
WHERE
  s0_.route = ?

SELECT s0_.id AS id_0, s0_.page_name AS page_name_1, s0_.route AS route_2, s0_.h1_enabled AS h1_enabled_3, s0_.translation_en_id AS translation_en_id_4, s0_.translation_fr_id AS translation_fr_id_5, s0_.translation_us_id AS translation_us_id_6, s0_.translation_es_id AS translation_es_id_7, s0_.translation_de_id AS translation_de_id_8, s0_.translation_pt_id AS translation_pt_id_9 FROM seopage_global s0_ WHERE s0_.route = 'app_about_us_page_index';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 959)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 48)
7	App\Repository\SEOPageGlobalRepository->findExistingRoute (line 36)
8	App\EventSubscriber\TwigEventSubscriber->onRequest (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.28 ms
(2.02%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.picture_name AS picture_name_4, t0.picture_size AS picture_size_5, t0.picture_updated_at AS picture_updated_at_6, t0.picture_alt AS picture_alt_7, t0.link AS link_8, t0.link_title AS link_title_9 FROM end_block t0 WHERE t0.id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.summary AS summary_3,
  t0.picture_name AS picture_name_4,
  t0.picture_size AS picture_size_5,
  t0.picture_updated_at AS picture_updated_at_6,
  t0.picture_alt AS picture_alt_7,
  t0.link AS link_8,
  t0.link_title AS link_title_9
FROM
  end_block t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.picture_name AS picture_name_4, t0.picture_size AS picture_size_5, t0.picture_updated_at AS picture_updated_at_6, t0.picture_alt AS picture_alt_7, t0.link AS link_8, t0.link_title AS link_title_9 FROM end_block t0 WHERE t0.id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Investor\EndBlock::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\Investor\EndBlock->__get (line 83)
8	App\Entity\Investor\EndBlock->getPictureName (line 1861)
9	Twig\Extension\CoreExtension::getAttribute (line 49)
10	__TwigTemplate_cfc8d078730186b06b044a8f7aa8263e->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
15	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
16	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 498)
17	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->block_body (line 431)
18	Twig\Template->yieldBlock (line 263)
19	__TwigTemplate_b9ceb83130e3a11866601ee9b2e1010f->doDisplay (line 387)
20	Twig\Template->yield (line 54)
21	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->doDisplay (line 387)
22	Twig\Template->yield (line 343)
23	Twig\Template->display (line 358)
24	Twig\Template->render (line 35)
25	Twig\TemplateWrapper->render (line 320)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 297)
30	App\Controller\FrontController->aboutUsPage (line 178)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

0.21 ms
(1.55%)

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address_street AS address_street_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.legal_site_name AS legal_site_name_7, t0.legal_siret AS legal_siret_8, t0.legal_siren AS legal_siren_9, t0.legal_rcs AS legal_rcs_10, t0.legal_address AS legal_address_11, t0.legal_zipcode AS legal_zipcode_12, t0.legal_city AS legal_city_13, t0.legal_phone AS legal_phone_14, t0.legal_email AS legal_email_15, t0.legal_publication_owner AS legal_publication_owner_16, t0.legal_site_url AS legal_site_url_17, t0.default_title AS default_title_18, t0.default_meta_desc AS default_meta_desc_19 FROM site_settings t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.email AS email_3,
  t0.address_street AS address_street_4,
  t0.zipcode AS zipcode_5,
  t0.city AS city_6,
  t0.legal_site_name AS legal_site_name_7,
  t0.legal_siret AS legal_siret_8,
  t0.legal_siren AS legal_siren_9,
  t0.legal_rcs AS legal_rcs_10,
  t0.legal_address AS legal_address_11,
  t0.legal_zipcode AS legal_zipcode_12,
  t0.legal_city AS legal_city_13,
  t0.legal_phone AS legal_phone_14,
  t0.legal_email AS legal_email_15,
  t0.legal_publication_owner AS legal_publication_owner_16,
  t0.legal_site_url AS legal_site_url_17,
  t0.default_title AS default_title_18,
  t0.default_meta_desc AS default_meta_desc_19
FROM
  site_settings t0

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address_street AS address_street_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.legal_site_name AS legal_site_name_7, t0.legal_siret AS legal_siret_8, t0.legal_siren AS legal_siren_9, t0.legal_rcs AS legal_rcs_10, t0.legal_address AS legal_address_11, t0.legal_zipcode AS legal_zipcode_12, t0.legal_city AS legal_city_13, t0.legal_phone AS legal_phone_14, t0.legal_email AS legal_email_15, t0.legal_publication_owner AS legal_publication_owner_16, t0.legal_site_url AS legal_site_url_17, t0.default_title AS default_title_18, t0.default_meta_desc AS default_meta_desc_19 FROM site_settings t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 41)
5	App\EventSubscriber\TwigEventSubscriber->onRequest (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.18 ms
(1.35%)

SELECT t0.picture_name AS picture_name_1, t0.picture_size AS picture_size_2, t0.picture_updated_at AS picture_updated_at_3, t0.picture_alt AS picture_alt_4, t0.id AS id_5, t0.parent_id AS parent_id_6, t0.translation_en_id AS translation_en_id_7, t0.translation_fr_id AS translation_fr_id_8, t0.translation_us_id AS translation_us_id_9, t0.translation_es_id AS translation_es_id_10, t0.translation_de_id AS translation_de_id_11, t0.translation_pt_id AS translation_pt_id_12 FROM product_category_global t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.picture_name AS picture_name_1,
  t0.picture_size AS picture_size_2,
  t0.picture_updated_at AS picture_updated_at_3,
  t0.picture_alt AS picture_alt_4,
  t0.id AS id_5,
  t0.parent_id AS parent_id_6,
  t0.translation_en_id AS translation_en_id_7,
  t0.translation_fr_id AS translation_fr_id_8,
  t0.translation_us_id AS translation_us_id_9,
  t0.translation_es_id AS translation_es_id_10,
  t0.translation_de_id AS translation_de_id_11,
  t0.translation_pt_id AS translation_pt_id_12
FROM
  product_category_global t0

SELECT t0.picture_name AS picture_name_1, t0.picture_size AS picture_size_2, t0.picture_updated_at AS picture_updated_at_3, t0.picture_alt AS picture_alt_4, t0.id AS id_5, t0.parent_id AS parent_id_6, t0.translation_en_id AS translation_en_id_7, t0.translation_fr_id AS translation_fr_id_8, t0.translation_us_id AS translation_us_id_9, t0.translation_es_id AS translation_es_id_10, t0.translation_de_id AS translation_de_id_11, t0.translation_pt_id AS translation_pt_id_12 FROM product_category_global t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 62)
5	App\Twig\AppExtension->getHeaderNavLinks (line 52)
6	__TwigTemplate_6181214b782d879a6aada1fbbba20314->doDisplay (line 387)
7	Twig\Template->yield (line 222)
8	__TwigTemplate_b9ceb83130e3a11866601ee9b2e1010f->doDisplay (line 387)
9	Twig\Template->yield (line 54)
10	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 320)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 297)
19	App\Controller\FrontController->aboutUsPage (line 178)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.18 ms
(1.32%)

SELECT t0.id AS id_1, t0.logo_name AS logo_name_2, t0.logo_size AS logo_size_3, t0.logo_updated_at AS logo_updated_at_4, t0.logo_alt AS logo_alt_5, t0.title AS title_6, t0.text AS text_7, t0.position AS position_8, t0.about_us_page_id AS about_us_page_id_9 FROM about_us_commitment t0 WHERE t0.about_us_page_id = ? 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.logo_name AS logo_name_2,
  t0.logo_size AS logo_size_3,
  t0.logo_updated_at AS logo_updated_at_4,
  t0.logo_alt AS logo_alt_5,
  t0.title AS title_6,
  t0.text AS text_7,
  t0.position AS position_8,
  t0.about_us_page_id AS about_us_page_id_9
FROM
  about_us_commitment t0
WHERE
  t0.about_us_page_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.logo_name AS logo_name_2, t0.logo_size AS logo_size_3, t0.logo_updated_at AS logo_updated_at_4, t0.logo_alt AS logo_alt_5, t0.title AS title_6, t0.text AS text_7, t0.position AS position_8, t0.about_us_page_id AS about_us_page_id_9 FROM about_us_commitment t0 WHERE t0.about_us_page_id = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 95)
9	App\Entity\AboutUs\AboutUsPageGlobal->__call (line 1861)
10	Twig\Extension\CoreExtension::getAttribute (line 389)
11	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->block_body (line 431)
12	Twig\Template->yieldBlock (line 263)
13	__TwigTemplate_b9ceb83130e3a11866601ee9b2e1010f->doDisplay (line 387)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->doDisplay (line 387)
16	Twig\Template->yield (line 343)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 320)
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 297)
24	App\Controller\FrontController->aboutUsPage (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.18 ms
(1.30%)

SELECT t0.id AS id_1, t0.year AS year_2, t0.title AS title_3, t0.text AS text_4, t0.about_us_page_id AS about_us_page_id_5 FROM about_us_historical_datum t0 WHERE t0.about_us_page_id = ? ORDER BY t0.year ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.year AS year_2,
  t0.title AS title_3,
  t0.text AS text_4,
  t0.about_us_page_id AS about_us_page_id_5
FROM
  about_us_historical_datum t0
WHERE
  t0.about_us_page_id = ?
ORDER BY
  t0.year ASC

SELECT t0.id AS id_1, t0.year AS year_2, t0.title AS title_3, t0.text AS text_4, t0.about_us_page_id AS about_us_page_id_5 FROM about_us_historical_datum t0 WHERE t0.about_us_page_id = 1 ORDER BY t0.year ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 95)
9	App\Entity\AboutUs\AboutUsPageGlobal->__call (line 1861)
10	Twig\Extension\CoreExtension::getAttribute (line 236)
11	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->block_body (line 431)
12	Twig\Template->yieldBlock (line 263)
13	__TwigTemplate_b9ceb83130e3a11866601ee9b2e1010f->doDisplay (line 387)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->doDisplay (line 387)
16	Twig\Template->yield (line 343)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 320)
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 297)
24	App\Controller\FrontController->aboutUsPage (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.17 ms
(1.27%)

SELECT t0.id AS id_1, t0.logo_name AS logo_name_2, t0.logo_size AS logo_size_3, t0.logo_updated_at AS logo_updated_at_4, t0.logo_alt AS logo_alt_5, t0.title AS title_6, t0.text AS text_7, t0.position AS position_8, t0.about_us_page_id AS about_us_page_id_9 FROM about_us_value t0 WHERE t0.about_us_page_id = ? 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.logo_name AS logo_name_2,
  t0.logo_size AS logo_size_3,
  t0.logo_updated_at AS logo_updated_at_4,
  t0.logo_alt AS logo_alt_5,
  t0.title AS title_6,
  t0.text AS text_7,
  t0.position AS position_8,
  t0.about_us_page_id AS about_us_page_id_9
FROM
  about_us_value t0
WHERE
  t0.about_us_page_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.logo_name AS logo_name_2, t0.logo_size AS logo_size_3, t0.logo_updated_at AS logo_updated_at_4, t0.logo_alt AS logo_alt_5, t0.title AS title_6, t0.text AS text_7, t0.position AS position_8, t0.about_us_page_id AS about_us_page_id_9 FROM about_us_value t0 WHERE t0.about_us_page_id = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 95)
9	App\Entity\AboutUs\AboutUsPageGlobal->__call (line 1861)
10	Twig\Extension\CoreExtension::getAttribute (line 340)
11	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->block_body (line 431)
12	Twig\Template->yieldBlock (line 263)
13	__TwigTemplate_b9ceb83130e3a11866601ee9b2e1010f->doDisplay (line 387)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->doDisplay (line 387)
16	Twig\Template->yield (line 343)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 320)
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 297)
24	App\Controller\FrontController->aboutUsPage (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.15 ms
(1.14%)

SELECT t0.id AS id_1, t0.logo_name AS logo_name_2, t0.logo_size AS logo_size_3, t0.logo_updated_at AS logo_updated_at_4, t0.logo_alt AS logo_alt_5, t0.position AS position_6, t0.about_us_page_id AS about_us_page_id_7 FROM about_us_certif t0 WHERE t0.about_us_page_id = ? 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.logo_name AS logo_name_2,
  t0.logo_size AS logo_size_3,
  t0.logo_updated_at AS logo_updated_at_4,
  t0.logo_alt AS logo_alt_5,
  t0.position AS position_6,
  t0.about_us_page_id AS about_us_page_id_7
FROM
  about_us_certif t0
WHERE
  t0.about_us_page_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.logo_name AS logo_name_2, t0.logo_size AS logo_size_3, t0.logo_updated_at AS logo_updated_at_4, t0.logo_alt AS logo_alt_5, t0.position AS position_6, t0.about_us_page_id AS about_us_page_id_7 FROM about_us_certif t0 WHERE t0.about_us_page_id = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 95)
9	App\Entity\AboutUs\AboutUsPageGlobal->__call (line 1861)
10	Twig\Extension\CoreExtension::getAttribute (line 465)
11	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->block_body (line 431)
12	Twig\Template->yieldBlock (line 263)
13	__TwigTemplate_b9ceb83130e3a11866601ee9b2e1010f->doDisplay (line 387)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->doDisplay (line 387)
16	Twig\Template->yield (line 343)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 320)
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 297)
24	App\Controller\FrontController->aboutUsPage (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.15 ms
(1.12%)

SELECT t0.id AS id_1, t0.translation_en_id AS translation_en_id_2, t0.translation_fr_id AS translation_fr_id_3, t0.translation_us_id AS translation_us_id_4, t0.translation_es_id AS translation_es_id_5, t0.translation_de_id AS translation_de_id_6, t0.translation_pt_id AS translation_pt_id_7 FROM about_us_page_global t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.translation_en_id AS translation_en_id_2,
  t0.translation_fr_id AS translation_fr_id_3,
  t0.translation_us_id AS translation_us_id_4,
  t0.translation_es_id AS translation_es_id_5,
  t0.translation_de_id AS translation_de_id_6,
  t0.translation_pt_id AS translation_pt_id_7
FROM
  about_us_page_global t0

SELECT t0.id AS id_1, t0.translation_en_id AS translation_en_id_2, t0.translation_fr_id AS translation_fr_id_3, t0.translation_us_id AS translation_us_id_4, t0.translation_es_id AS translation_es_id_5, t0.translation_de_id AS translation_de_id_6, t0.translation_pt_id AS translation_pt_id_7 FROM about_us_page_global t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 19)
5	Cofondateur\SocleTechniqueBundle\Repository\LoneEntityRepository->findUnique (line 295)
6	App\Controller\FrontController->aboutUsPage (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.15 ms
(1.08%)

SELECT t0.event AS event_1, t0.id AS id_2, t0.translation_en_id AS translation_en_id_3, t0.translation_fr_id AS translation_fr_id_4, t0.translation_us_id AS translation_us_id_5, t0.translation_es_id AS translation_es_id_6, t0.translation_de_id AS translation_de_id_7, t0.translation_pt_id AS translation_pt_id_8 FROM article_category_global t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.event AS event_1,
  t0.id AS id_2,
  t0.translation_en_id AS translation_en_id_3,
  t0.translation_fr_id AS translation_fr_id_4,
  t0.translation_us_id AS translation_us_id_5,
  t0.translation_es_id AS translation_es_id_6,
  t0.translation_de_id AS translation_de_id_7,
  t0.translation_pt_id AS translation_pt_id_8
FROM
  article_category_global t0

SELECT t0.event AS event_1, t0.id AS id_2, t0.translation_en_id AS translation_en_id_3, t0.translation_fr_id AS translation_fr_id_4, t0.translation_us_id AS translation_us_id_5, t0.translation_es_id AS translation_es_id_6, t0.translation_de_id AS translation_de_id_7, t0.translation_pt_id AS translation_pt_id_8 FROM article_category_global t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 86)
5	App\Twig\AppExtension->getHeaderNavLinks (line 52)
6	__TwigTemplate_6181214b782d879a6aada1fbbba20314->doDisplay (line 387)
7	Twig\Template->yield (line 222)
8	__TwigTemplate_b9ceb83130e3a11866601ee9b2e1010f->doDisplay (line 387)
9	Twig\Template->yield (line 54)
10	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 320)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 297)
19	App\Controller\FrontController->aboutUsPage (line 178)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.14 ms
(1.02%)

SELECT t0.id AS id_1, t0.translation_en_id AS translation_en_id_2, t0.translation_fr_id AS translation_fr_id_3, t0.translation_us_id AS translation_us_id_4, t0.translation_es_id AS translation_es_id_5, t0.translation_de_id AS translation_de_id_6, t0.translation_pt_id AS translation_pt_id_7 FROM footer_icon_global t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.translation_en_id AS translation_en_id_2,
  t0.translation_fr_id AS translation_fr_id_3,
  t0.translation_us_id AS translation_us_id_4,
  t0.translation_es_id AS translation_es_id_5,
  t0.translation_de_id AS translation_de_id_6,
  t0.translation_pt_id AS translation_pt_id_7
FROM
  footer_icon_global t0

SELECT t0.id AS id_1, t0.translation_en_id AS translation_en_id_2, t0.translation_fr_id AS translation_fr_id_3, t0.translation_us_id AS translation_us_id_4, t0.translation_es_id AS translation_es_id_5, t0.translation_de_id AS translation_de_id_6, t0.translation_pt_id AS translation_pt_id_7 FROM footer_icon_global t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 142)
5	App\Twig\AppExtension->getFooterIcons (line 52)
6	__TwigTemplate_d64331db3d6ec0e18a55bb01c8d9ba59->doDisplay (line 387)
7	Twig\Template->yield (line 268)
8	__TwigTemplate_b9ceb83130e3a11866601ee9b2e1010f->doDisplay (line 387)
9	Twig\Template->yield (line 54)
10	__TwigTemplate_b10455759cd784217ac7552152ebbc1a->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 320)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 297)
19	App\Controller\FrontController->aboutUsPage (line 178)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	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\SEOPageGlobal	No errors.
App\Entity\SEOPage	The field App\Entity\SEOPage#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\SEOPage#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute. The field App\Entity\SEOPage#translatedUs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationUs does not contain the required 'inversedBy="translatedUs"' attribute. The field App\Entity\SEOPage#translatedEs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationEs does not contain the required 'inversedBy="translatedEs"' attribute. The field App\Entity\SEOPage#translatedDe is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationDe does not contain the required 'inversedBy="translatedDe"' attribute. The field App\Entity\SEOPage#translatedPt is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationPt does not contain the required 'inversedBy="translatedPt"' attribute.
Cofondateur\SocleTechniqueBundle\Entity\SiteSettings	No errors.
App\Entity\SiteSettings	No errors.
App\Entity\AboutUs\AboutUsPageGlobal	No errors.
App\Entity\AboutUs\AboutUsPage	The field App\Entity\AboutUs\AboutUsPage#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AboutUs\AboutUsPageGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\AboutUs\AboutUsPage#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AboutUs\AboutUsPageGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute. The field App\Entity\AboutUs\AboutUsPage#translatedUs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AboutUs\AboutUsPageGlobal#translationUs does not contain the required 'inversedBy="translatedUs"' attribute. The field App\Entity\AboutUs\AboutUsPage#translatedEs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AboutUs\AboutUsPageGlobal#translationEs does not contain the required 'inversedBy="translatedEs"' attribute. The field App\Entity\AboutUs\AboutUsPage#translatedDe is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AboutUs\AboutUsPageGlobal#translationDe does not contain the required 'inversedBy="translatedDe"' attribute. The field App\Entity\AboutUs\AboutUsPage#translatedPt is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AboutUs\AboutUsPageGlobal#translationPt does not contain the required 'inversedBy="translatedPt"' attribute.
App\Entity\Investor\EndBlock	No errors.
App\Entity\AboutUs\AboutUsHistoricalDatum	No errors.
App\Entity\AboutUs\AboutUsValue	No errors.
App\Entity\AboutUs\AboutUsCommitment	No errors.
App\Entity\AboutUs\AboutUsCertif	No errors.
App\Entity\Product\ProductCategoryGlobal	No errors.
App\Entity\Product\ProductCategory	The field App\Entity\Product\ProductCategory#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductCategoryGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\Product\ProductCategory#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductCategoryGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute. The field App\Entity\Product\ProductCategory#translatedUs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductCategoryGlobal#translationUs does not contain the required 'inversedBy="translatedUs"' attribute. The field App\Entity\Product\ProductCategory#translatedEs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductCategoryGlobal#translationEs does not contain the required 'inversedBy="translatedEs"' attribute. The field App\Entity\Product\ProductCategory#translatedDe is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductCategoryGlobal#translationDe does not contain the required 'inversedBy="translatedDe"' attribute. The field App\Entity\Product\ProductCategory#translatedPt is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductCategoryGlobal#translationPt does not contain the required 'inversedBy="translatedPt"' attribute.
App\Entity\Product\ProductGlobal	The field App\Entity\Product\ProductGlobal#contact is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Contact#product does not contain the required 'inversedBy="contact"' attribute.
App\Entity\HomepageGlobal	No errors.
App\Entity\Product\Product	The field App\Entity\Product\Product#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\Product\Product#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute. The field App\Entity\Product\Product#translatedUs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationUs does not contain the required 'inversedBy="translatedUs"' attribute. The field App\Entity\Product\Product#translatedEs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationEs does not contain the required 'inversedBy="translatedEs"' attribute. The field App\Entity\Product\Product#translatedDe is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationDe does not contain the required 'inversedBy="translatedDe"' attribute. The field App\Entity\Product\Product#translatedPt is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationPt does not contain the required 'inversedBy="translatedPt"' attribute.
App\Entity\Contact	No errors.
App\Entity\PWA\ProductDocumentationGlobal	No errors.
App\Entity\IFU\IFUDocument	No errors.
App\Entity\Product\ProductMedia	No errors.
App\Entity\PWA\Product3DView	No errors.
App\Entity\PWA\ProductMP4Media	No errors.
App\Entity\PWA\PWAProductMedia	No errors.
App\Entity\Blog\ArticleCategoryGlobal	No errors.
App\Entity\Blog\ArticleCategory	The field App\Entity\Blog\ArticleCategory#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Blog\ArticleCategoryGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\Blog\ArticleCategory#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Blog\ArticleCategoryGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute. The field App\Entity\Blog\ArticleCategory#translatedUs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Blog\ArticleCategoryGlobal#translationUs does not contain the required 'inversedBy="translatedUs"' attribute. The field App\Entity\Blog\ArticleCategory#translatedEs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Blog\ArticleCategoryGlobal#translationEs does not contain the required 'inversedBy="translatedEs"' attribute. The field App\Entity\Blog\ArticleCategory#translatedDe is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Blog\ArticleCategoryGlobal#translationDe does not contain the required 'inversedBy="translatedDe"' attribute. The field App\Entity\Blog\ArticleCategory#translatedPt is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Blog\ArticleCategoryGlobal#translationPt does not contain the required 'inversedBy="translatedPt"' attribute.
App\Entity\Blog\ArticleGlobal	No errors.
App\Entity\FooterIconGlobal	No errors.
App\Entity\FooterIcon	No errors.

Symfony Profiler

GET https://spineway.asb-digital.fr/en/about-us

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping