Symfony Profiler

Query Metrics

78 Database Queries

18 Different statements

21.61 ms Query time

7 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.16 ms
(23.88%)

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 55)
15	__TwigTemplate_325649ef74fa6c77aa535d864dc7fb9e->doDisplay (line 387)
16	Twig\Template->yield (line 55)
17	__TwigTemplate_87b41ad65d1871ef12e077735f687773->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 396)
26	App\Controller\FrontController->regulatedInformationPage (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)

2.95 ms
(13.64%)

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 55)
17	__TwigTemplate_325649ef74fa6c77aa535d864dc7fb9e->doDisplay (line 387)
18	Twig\Template->yield (line 55)
19	__TwigTemplate_87b41ad65d1871ef12e077735f687773->doDisplay (line 387)
20	Twig\Template->yield (line 343)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 35)
23	Twig\TemplateWrapper->render (line 320)
24	Twig\Environment->render (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
28	App\Controller\FrontController->regulatedInformationPage (line 178)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

2.81 ms
(12.99%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.document_name AS document_name_3, t0.document_size AS document_size_4, t0.document_updated_at AS document_updated_at_5, t0.youtube_link AS youtube_link_6, t0.updated_at AS updated_at_7, t0.document_update_name AS document_update_name_8, t0.document_update_size AS document_update_size_9, t0.document_update_updated_at AS document_update_updated_at_10, t0.document_update_date AS document_update_date_11, t12.download_number AS download_number_13, t12.created_at AS created_at_14, t12.start_at AS start_at_15, t12.end_at AS end_at_16, t12.ref AS ref_17, t12.first_apparition_at AS first_apparition_at_18, t12.id AS id_19, t12.category_id AS category_id_20, t12.translation_en_id AS translation_en_id_21, t12.translation_fr_id AS translation_fr_id_22, t12.translation_us_id AS translation_us_id_23, t12.translation_es_id AS translation_es_id_24, t12.translation_de_id AS translation_de_id_25, t12.translation_pt_id AS translation_pt_id_26, t27.download_number AS download_number_28, t27.created_at AS created_at_29, t27.start_at AS start_at_30, t27.end_at AS end_at_31, t27.ref AS ref_32, t27.first_apparition_at AS first_apparition_at_33, t27.id AS id_34, t27.category_id AS category_id_35, t27.translation_en_id AS translation_en_id_36, t27.translation_fr_id AS translation_fr_id_37, t27.translation_us_id AS translation_us_id_38, t27.translation_es_id AS translation_es_id_39, t27.translation_de_id AS translation_de_id_40, t27.translation_pt_id AS translation_pt_id_41, t42.download_number AS download_number_43, t42.created_at AS created_at_44, t42.start_at AS start_at_45, t42.end_at AS end_at_46, t42.ref AS ref_47, t42.first_apparition_at AS first_apparition_at_48, t42.id AS id_49, t42.category_id AS category_id_50, t42.translation_en_id AS translation_en_id_51, t42.translation_fr_id AS translation_fr_id_52, t42.translation_us_id AS translation_us_id_53, t42.translation_es_id AS translation_es_id_54, t42.translation_de_id AS translation_de_id_55, t42.translation_pt_id AS translation_pt_id_56, t57.download_number AS download_number_58, t57.created_at AS created_at_59, t57.start_at AS start_at_60, t57.end_at AS end_at_61, t57.ref AS ref_62, t57.first_apparition_at AS first_apparition_at_63, t57.id AS id_64, t57.category_id AS category_id_65, t57.translation_en_id AS translation_en_id_66, t57.translation_fr_id AS translation_fr_id_67, t57.translation_us_id AS translation_us_id_68, t57.translation_es_id AS translation_es_id_69, t57.translation_de_id AS translation_de_id_70, t57.translation_pt_id AS translation_pt_id_71, t72.download_number AS download_number_73, t72.created_at AS created_at_74, t72.start_at AS start_at_75, t72.end_at AS end_at_76, t72.ref AS ref_77, t72.first_apparition_at AS first_apparition_at_78, t72.id AS id_79, t72.category_id AS category_id_80, t72.translation_en_id AS translation_en_id_81, t72.translation_fr_id AS translation_fr_id_82, t72.translation_us_id AS translation_us_id_83, t72.translation_es_id AS translation_es_id_84, t72.translation_de_id AS translation_de_id_85, t72.translation_pt_id AS translation_pt_id_86, t87.download_number AS download_number_88, t87.created_at AS created_at_89, t87.start_at AS start_at_90, t87.end_at AS end_at_91, t87.ref AS ref_92, t87.first_apparition_at AS first_apparition_at_93, t87.id AS id_94, t87.category_id AS category_id_95, t87.translation_en_id AS translation_en_id_96, t87.translation_fr_id AS translation_fr_id_97, t87.translation_us_id AS translation_us_id_98, t87.translation_es_id AS translation_es_id_99, t87.translation_de_id AS translation_de_id_100, t87.translation_pt_id AS translation_pt_id_101 FROM document t0 LEFT JOIN document_global t12 ON t12.translation_en_id = t0.id LEFT JOIN document_global t27 ON t27.translation_fr_id = t0.id LEFT JOIN document_global t42 ON t42.translation_us_id = t0.id LEFT JOIN document_global t57 ON t57.translation_es_id = t0.id LEFT JOIN document_global t72 ON t72.translation_de_id = t0.id LEFT JOIN document_global t87 ON t87.translation_pt_id = t0.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.document_name AS document_name_3,
  t0.document_size AS document_size_4,
  t0.document_updated_at AS document_updated_at_5,
  t0.youtube_link AS youtube_link_6,
  t0.updated_at AS updated_at_7,
  t0.document_update_name AS document_update_name_8,
  t0.document_update_size AS document_update_size_9,
  t0.document_update_updated_at AS document_update_updated_at_10,
  t0.document_update_date AS document_update_date_11,
  t12.download_number AS download_number_13,
  t12.created_at AS created_at_14,
  t12.start_at AS start_at_15,
  t12.end_at AS end_at_16,
  t12.ref AS ref_17,
  t12.first_apparition_at AS first_apparition_at_18,
  t12.id AS id_19,
  t12.category_id AS category_id_20,
  t12.translation_en_id AS translation_en_id_21,
  t12.translation_fr_id AS translation_fr_id_22,
  t12.translation_us_id AS translation_us_id_23,
  t12.translation_es_id AS translation_es_id_24,
  t12.translation_de_id AS translation_de_id_25,
  t12.translation_pt_id AS translation_pt_id_26,
  t27.download_number AS download_number_28,
  t27.created_at AS created_at_29,
  t27.start_at AS start_at_30,
  t27.end_at AS end_at_31,
  t27.ref AS ref_32,
  t27.first_apparition_at AS first_apparition_at_33,
  t27.id AS id_34,
  t27.category_id AS category_id_35,
  t27.translation_en_id AS translation_en_id_36,
  t27.translation_fr_id AS translation_fr_id_37,
  t27.translation_us_id AS translation_us_id_38,
  t27.translation_es_id AS translation_es_id_39,
  t27.translation_de_id AS translation_de_id_40,
  t27.translation_pt_id AS translation_pt_id_41,
  t42.download_number AS download_number_43,
  t42.created_at AS created_at_44,
  t42.start_at AS start_at_45,
  t42.end_at AS end_at_46,
  t42.ref AS ref_47,
  t42.first_apparition_at AS first_apparition_at_48,
  t42.id AS id_49,
  t42.category_id AS category_id_50,
  t42.translation_en_id AS translation_en_id_51,
  t42.translation_fr_id AS translation_fr_id_52,
  t42.translation_us_id AS translation_us_id_53,
  t42.translation_es_id AS translation_es_id_54,
  t42.translation_de_id AS translation_de_id_55,
  t42.translation_pt_id AS translation_pt_id_56,
  t57.download_number AS download_number_58,
  t57.created_at AS created_at_59,
  t57.start_at AS start_at_60,
  t57.end_at AS end_at_61,
  t57.ref AS ref_62,
  t57.first_apparition_at AS first_apparition_at_63,
  t57.id AS id_64,
  t57.category_id AS category_id_65,
  t57.translation_en_id AS translation_en_id_66,
  t57.translation_fr_id AS translation_fr_id_67,
  t57.translation_us_id AS translation_us_id_68,
  t57.translation_es_id AS translation_es_id_69,
  t57.translation_de_id AS translation_de_id_70,
  t57.translation_pt_id AS translation_pt_id_71,
  t72.download_number AS download_number_73,
  t72.created_at AS created_at_74,
  t72.start_at AS start_at_75,
  t72.end_at AS end_at_76,
  t72.ref AS ref_77,
  t72.first_apparition_at AS first_apparition_at_78,
  t72.id AS id_79,
  t72.category_id AS category_id_80,
  t72.translation_en_id AS translation_en_id_81,
  t72.translation_fr_id AS translation_fr_id_82,
  t72.translation_us_id AS translation_us_id_83,
  t72.translation_es_id AS translation_es_id_84,
  t72.translation_de_id AS translation_de_id_85,
  t72.translation_pt_id AS translation_pt_id_86,
  t87.download_number AS download_number_88,
  t87.created_at AS created_at_89,
  t87.start_at AS start_at_90,
  t87.end_at AS end_at_91,
  t87.ref AS ref_92,
  t87.first_apparition_at AS first_apparition_at_93,
  t87.id AS id_94,
  t87.category_id AS category_id_95,
  t87.translation_en_id AS translation_en_id_96,
  t87.translation_fr_id AS translation_fr_id_97,
  t87.translation_us_id AS translation_us_id_98,
  t87.translation_es_id AS translation_es_id_99,
  t87.translation_de_id AS translation_de_id_100,
  t87.translation_pt_id AS translation_pt_id_101
FROM
  document t0
  LEFT JOIN document_global t12 ON t12.translation_en_id = t0.id
  LEFT JOIN document_global t27 ON t27.translation_fr_id = t0.id
  LEFT JOIN document_global t42 ON t42.translation_us_id = t0.id
  LEFT JOIN document_global t57 ON t57.translation_es_id = t0.id
  LEFT JOIN document_global t72 ON t72.translation_de_id = t0.id
  LEFT JOIN document_global t87 ON t87.translation_pt_id = t0.id

SELECT t0.id AS id_1, t0.title AS title_2, t0.document_name AS document_name_3, t0.document_size AS document_size_4, t0.document_updated_at AS document_updated_at_5, t0.youtube_link AS youtube_link_6, t0.updated_at AS updated_at_7, t0.document_update_name AS document_update_name_8, t0.document_update_size AS document_update_size_9, t0.document_update_updated_at AS document_update_updated_at_10, t0.document_update_date AS document_update_date_11, t12.download_number AS download_number_13, t12.created_at AS created_at_14, t12.start_at AS start_at_15, t12.end_at AS end_at_16, t12.ref AS ref_17, t12.first_apparition_at AS first_apparition_at_18, t12.id AS id_19, t12.category_id AS category_id_20, t12.translation_en_id AS translation_en_id_21, t12.translation_fr_id AS translation_fr_id_22, t12.translation_us_id AS translation_us_id_23, t12.translation_es_id AS translation_es_id_24, t12.translation_de_id AS translation_de_id_25, t12.translation_pt_id AS translation_pt_id_26, t27.download_number AS download_number_28, t27.created_at AS created_at_29, t27.start_at AS start_at_30, t27.end_at AS end_at_31, t27.ref AS ref_32, t27.first_apparition_at AS first_apparition_at_33, t27.id AS id_34, t27.category_id AS category_id_35, t27.translation_en_id AS translation_en_id_36, t27.translation_fr_id AS translation_fr_id_37, t27.translation_us_id AS translation_us_id_38, t27.translation_es_id AS translation_es_id_39, t27.translation_de_id AS translation_de_id_40, t27.translation_pt_id AS translation_pt_id_41, t42.download_number AS download_number_43, t42.created_at AS created_at_44, t42.start_at AS start_at_45, t42.end_at AS end_at_46, t42.ref AS ref_47, t42.first_apparition_at AS first_apparition_at_48, t42.id AS id_49, t42.category_id AS category_id_50, t42.translation_en_id AS translation_en_id_51, t42.translation_fr_id AS translation_fr_id_52, t42.translation_us_id AS translation_us_id_53, t42.translation_es_id AS translation_es_id_54, t42.translation_de_id AS translation_de_id_55, t42.translation_pt_id AS translation_pt_id_56, t57.download_number AS download_number_58, t57.created_at AS created_at_59, t57.start_at AS start_at_60, t57.end_at AS end_at_61, t57.ref AS ref_62, t57.first_apparition_at AS first_apparition_at_63, t57.id AS id_64, t57.category_id AS category_id_65, t57.translation_en_id AS translation_en_id_66, t57.translation_fr_id AS translation_fr_id_67, t57.translation_us_id AS translation_us_id_68, t57.translation_es_id AS translation_es_id_69, t57.translation_de_id AS translation_de_id_70, t57.translation_pt_id AS translation_pt_id_71, t72.download_number AS download_number_73, t72.created_at AS created_at_74, t72.start_at AS start_at_75, t72.end_at AS end_at_76, t72.ref AS ref_77, t72.first_apparition_at AS first_apparition_at_78, t72.id AS id_79, t72.category_id AS category_id_80, t72.translation_en_id AS translation_en_id_81, t72.translation_fr_id AS translation_fr_id_82, t72.translation_us_id AS translation_us_id_83, t72.translation_es_id AS translation_es_id_84, t72.translation_de_id AS translation_de_id_85, t72.translation_pt_id AS translation_pt_id_86, t87.download_number AS download_number_88, t87.created_at AS created_at_89, t87.start_at AS start_at_90, t87.end_at AS end_at_91, t87.ref AS ref_92, t87.first_apparition_at AS first_apparition_at_93, t87.id AS id_94, t87.category_id AS category_id_95, t87.translation_en_id AS translation_en_id_96, t87.translation_fr_id AS translation_fr_id_97, t87.translation_us_id AS translation_us_id_98, t87.translation_es_id AS translation_es_id_99, t87.translation_de_id AS translation_de_id_100, t87.translation_pt_id AS translation_pt_id_101 FROM document t0 LEFT JOIN document_global t12 ON t12.translation_en_id = t0.id LEFT JOIN document_global t27 ON t27.translation_fr_id = t0.id LEFT JOIN document_global t42 ON t42.translation_us_id = t0.id LEFT JOIN document_global t57 ON t57.translation_es_id = t0.id LEFT JOIN document_global t72 ON t72.translation_de_id = t0.id LEFT JOIN document_global t87 ON t87.translation_pt_id = t0.id;

#	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 20)
5	App\Service\AllDocumentsUpdater->updateAll (line 390)
6	App\Controller\FrontController->regulatedInformationPage (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)

2.32 ms
(10.72%)

SELECT t0.download_number AS download_number_1, t0.created_at AS created_at_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.ref AS ref_5, t0.first_apparition_at AS first_apparition_at_6, t0.id AS id_7, t0.category_id AS category_id_8, t0.translation_en_id AS translation_en_id_9, t0.translation_fr_id AS translation_fr_id_10, t0.translation_us_id AS translation_us_id_11, t0.translation_es_id AS translation_es_id_12, t0.translation_de_id AS translation_de_id_13, t0.translation_pt_id AS translation_pt_id_14 FROM document_global t0 WHERE t0.category_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.download_number AS download_number_1,
  t0.created_at AS created_at_2,
  t0.start_at AS start_at_3,
  t0.end_at AS end_at_4,
  t0.ref AS ref_5,
  t0.first_apparition_at AS first_apparition_at_6,
  t0.id AS id_7,
  t0.category_id AS category_id_8,
  t0.translation_en_id AS translation_en_id_9,
  t0.translation_fr_id AS translation_fr_id_10,
  t0.translation_us_id AS translation_us_id_11,
  t0.translation_es_id AS translation_es_id_12,
  t0.translation_de_id AS translation_de_id_13,
  t0.translation_pt_id AS translation_pt_id_14
FROM
  document_global t0
WHERE
  t0.category_id = ?

SELECT t0.download_number AS download_number_1, t0.created_at AS created_at_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.ref AS ref_5, t0.first_apparition_at AS first_apparition_at_6, t0.id AS id_7, t0.category_id AS category_id_8, t0.translation_en_id AS translation_en_id_9, t0.translation_fr_id AS translation_fr_id_10, t0.translation_us_id AS translation_us_id_11, t0.translation_es_id AS translation_es_id_12, t0.translation_de_id AS translation_de_id_13, t0.translation_pt_id AS translation_pt_id_14 FROM document_global t0 WHERE t0.category_id = 1;

#	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 1)
8	IteratorIterator->__construct (line 1922)
9	Twig\Extension\CoreExtension::filter (line 69)
10	__TwigTemplate_df8b1b237350baa773abd696473a3336->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 136)
17	__TwigTemplate_87b41ad65d1871ef12e077735f687773->block_content (line 431)
18	Twig\Template->yieldBlock (line 86)
19	__TwigTemplate_325649ef74fa6c77aa535d864dc7fb9e->block_body (line 431)
20	Twig\Template->yieldBlock (line 263)
21	__TwigTemplate_b9ceb83130e3a11866601ee9b2e1010f->doDisplay (line 387)
22	Twig\Template->yield (line 55)
23	__TwigTemplate_325649ef74fa6c77aa535d864dc7fb9e->doDisplay (line 387)
24	Twig\Template->yield (line 55)
25	__TwigTemplate_87b41ad65d1871ef12e077735f687773->doDisplay (line 387)
26	Twig\Template->yield (line 343)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 35)
29	Twig\TemplateWrapper->render (line 320)
30	Twig\Environment->render (line 431)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
34	App\Controller\FrontController->regulatedInformationPage (line 178)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 5)

1.94 ms
(8.99%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3 FROM document_category t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.position AS position_3
FROM
  document_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3 FROM document_category t0 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\Investor\DocumentCategory::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\Investor\DocumentCategory->__get (line 42)
8	App\Entity\Investor\DocumentCategory->getTitle (line 94)
9	App\Entity\Investor\DocumentCategoryGlobal->__call (line 183)
10	App\Entity\Investor\DocumentCategoryGlobal->__toString (line 115)
11	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 81)
12	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
14	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 136)
15	__TwigTemplate_87b41ad65d1871ef12e077735f687773->block_content (line 431)
16	Twig\Template->yieldBlock (line 86)
17	__TwigTemplate_325649ef74fa6c77aa535d864dc7fb9e->block_body (line 431)
18	Twig\Template->yieldBlock (line 263)
19	__TwigTemplate_b9ceb83130e3a11866601ee9b2e1010f->doDisplay (line 387)
20	Twig\Template->yield (line 55)
21	__TwigTemplate_325649ef74fa6c77aa535d864dc7fb9e->doDisplay (line 387)
22	Twig\Template->yield (line 55)
23	__TwigTemplate_87b41ad65d1871ef12e077735f687773->doDisplay (line 387)
24	Twig\Template->yield (line 343)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 35)
27	Twig\TemplateWrapper->render (line 320)
28	Twig\Environment->render (line 431)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
32	App\Controller\FrontController->regulatedInformationPage (line 178)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 5)

1.37 ms
(6.33%)

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 55)
15	__TwigTemplate_325649ef74fa6c77aa535d864dc7fb9e->doDisplay (line 387)
16	Twig\Template->yield (line 55)
17	__TwigTemplate_87b41ad65d1871ef12e077735f687773->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 396)
26	App\Controller\FrontController->regulatedInformationPage (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.12 ms
(5.18%)

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 55)
15	__TwigTemplate_325649ef74fa6c77aa535d864dc7fb9e->doDisplay (line 387)
16	Twig\Template->yield (line 55)
17	__TwigTemplate_87b41ad65d1871ef12e077735f687773->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 396)
26	App\Controller\FrontController->regulatedInformationPage (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.06 ms
(4.88%)

SELECT t0.intro_title AS intro_title_1, t0.intro_summary AS intro_summary_2, t0.id AS id_3, t0.header_picture_name AS header_picture_name_4, t0.header_picture_size AS header_picture_size_5, t0.header_picture_updated_at AS header_picture_updated_at_6, t0.header_picture_alt AS header_picture_alt_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.end_block1_id AS end_block1_id_10, t0.end_block2_id AS end_block2_id_11, t12.id AS id_13, t12.translation_en_id AS translation_en_id_14, t12.translation_fr_id AS translation_fr_id_15, t12.translation_us_id AS translation_us_id_16, t12.translation_es_id AS translation_es_id_17, t12.translation_de_id AS translation_de_id_18, t12.translation_pt_id AS translation_pt_id_19, t20.id AS id_21, t20.translation_en_id AS translation_en_id_22, t20.translation_fr_id AS translation_fr_id_23, t20.translation_us_id AS translation_us_id_24, t20.translation_es_id AS translation_es_id_25, t20.translation_de_id AS translation_de_id_26, t20.translation_pt_id AS translation_pt_id_27, t28.id AS id_29, t28.translation_en_id AS translation_en_id_30, t28.translation_fr_id AS translation_fr_id_31, t28.translation_us_id AS translation_us_id_32, t28.translation_es_id AS translation_es_id_33, t28.translation_de_id AS translation_de_id_34, t28.translation_pt_id AS translation_pt_id_35, t36.id AS id_37, t36.translation_en_id AS translation_en_id_38, t36.translation_fr_id AS translation_fr_id_39, t36.translation_us_id AS translation_us_id_40, t36.translation_es_id AS translation_es_id_41, t36.translation_de_id AS translation_de_id_42, t36.translation_pt_id AS translation_pt_id_43, t44.id AS id_45, t44.translation_en_id AS translation_en_id_46, t44.translation_fr_id AS translation_fr_id_47, t44.translation_us_id AS translation_us_id_48, t44.translation_es_id AS translation_es_id_49, t44.translation_de_id AS translation_de_id_50, t44.translation_pt_id AS translation_pt_id_51, t52.id AS id_53, t52.translation_en_id AS translation_en_id_54, t52.translation_fr_id AS translation_fr_id_55, t52.translation_us_id AS translation_us_id_56, t52.translation_es_id AS translation_es_id_57, t52.translation_de_id AS translation_de_id_58, t52.translation_pt_id AS translation_pt_id_59 FROM regulated_information_page t0 LEFT JOIN regulated_information_page_global t12 ON t12.translation_en_id = t0.id LEFT JOIN regulated_information_page_global t20 ON t20.translation_fr_id = t0.id LEFT JOIN regulated_information_page_global t28 ON t28.translation_us_id = t0.id LEFT JOIN regulated_information_page_global t36 ON t36.translation_es_id = t0.id LEFT JOIN regulated_information_page_global t44 ON t44.translation_de_id = t0.id LEFT JOIN regulated_information_page_global t52 ON t52.translation_pt_id = t0.id WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.intro_title AS intro_title_1,
  t0.intro_summary AS intro_summary_2,
  t0.id AS id_3,
  t0.header_picture_name AS header_picture_name_4,
  t0.header_picture_size AS header_picture_size_5,
  t0.header_picture_updated_at AS header_picture_updated_at_6,
  t0.header_picture_alt AS header_picture_alt_7,
  t0.meta_title AS meta_title_8,
  t0.meta_description AS meta_description_9,
  t0.end_block1_id AS end_block1_id_10,
  t0.end_block2_id AS end_block2_id_11,
  t12.id AS id_13,
  t12.translation_en_id AS translation_en_id_14,
  t12.translation_fr_id AS translation_fr_id_15,
  t12.translation_us_id AS translation_us_id_16,
  t12.translation_es_id AS translation_es_id_17,
  t12.translation_de_id AS translation_de_id_18,
  t12.translation_pt_id AS translation_pt_id_19,
  t20.id AS id_21,
  t20.translation_en_id AS translation_en_id_22,
  t20.translation_fr_id AS translation_fr_id_23,
  t20.translation_us_id AS translation_us_id_24,
  t20.translation_es_id AS translation_es_id_25,
  t20.translation_de_id AS translation_de_id_26,
  t20.translation_pt_id AS translation_pt_id_27,
  t28.id AS id_29,
  t28.translation_en_id AS translation_en_id_30,
  t28.translation_fr_id AS translation_fr_id_31,
  t28.translation_us_id AS translation_us_id_32,
  t28.translation_es_id AS translation_es_id_33,
  t28.translation_de_id AS translation_de_id_34,
  t28.translation_pt_id AS translation_pt_id_35,
  t36.id AS id_37,
  t36.translation_en_id AS translation_en_id_38,
  t36.translation_fr_id AS translation_fr_id_39,
  t36.translation_us_id AS translation_us_id_40,
  t36.translation_es_id AS translation_es_id_41,
  t36.translation_de_id AS translation_de_id_42,
  t36.translation_pt_id AS translation_pt_id_43,
  t44.id AS id_45,
  t44.translation_en_id AS translation_en_id_46,
  t44.translation_fr_id AS translation_fr_id_47,
  t44.translation_us_id AS translation_us_id_48,
  t44.translation_es_id AS translation_es_id_49,
  t44.translation_de_id AS translation_de_id_50,
  t44.translation_pt_id AS translation_pt_id_51,
  t52.id AS id_53,
  t52.translation_en_id AS translation_en_id_54,
  t52.translation_fr_id AS translation_fr_id_55,
  t52.translation_us_id AS translation_us_id_56,
  t52.translation_es_id AS translation_es_id_57,
  t52.translation_de_id AS translation_de_id_58,
  t52.translation_pt_id AS translation_pt_id_59
FROM
  regulated_information_page t0
  LEFT JOIN regulated_information_page_global t12 ON t12.translation_en_id = t0.id
  LEFT JOIN regulated_information_page_global t20 ON t20.translation_fr_id = t0.id
  LEFT JOIN regulated_information_page_global t28 ON t28.translation_us_id = t0.id
  LEFT JOIN regulated_information_page_global t36 ON t36.translation_es_id = t0.id
  LEFT JOIN regulated_information_page_global t44 ON t44.translation_de_id = t0.id
  LEFT JOIN regulated_information_page_global t52 ON t52.translation_pt_id = t0.id
WHERE
  t0.id = ?

SELECT t0.intro_title AS intro_title_1, t0.intro_summary AS intro_summary_2, t0.id AS id_3, t0.header_picture_name AS header_picture_name_4, t0.header_picture_size AS header_picture_size_5, t0.header_picture_updated_at AS header_picture_updated_at_6, t0.header_picture_alt AS header_picture_alt_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.end_block1_id AS end_block1_id_10, t0.end_block2_id AS end_block2_id_11, t12.id AS id_13, t12.translation_en_id AS translation_en_id_14, t12.translation_fr_id AS translation_fr_id_15, t12.translation_us_id AS translation_us_id_16, t12.translation_es_id AS translation_es_id_17, t12.translation_de_id AS translation_de_id_18, t12.translation_pt_id AS translation_pt_id_19, t20.id AS id_21, t20.translation_en_id AS translation_en_id_22, t20.translation_fr_id AS translation_fr_id_23, t20.translation_us_id AS translation_us_id_24, t20.translation_es_id AS translation_es_id_25, t20.translation_de_id AS translation_de_id_26, t20.translation_pt_id AS translation_pt_id_27, t28.id AS id_29, t28.translation_en_id AS translation_en_id_30, t28.translation_fr_id AS translation_fr_id_31, t28.translation_us_id AS translation_us_id_32, t28.translation_es_id AS translation_es_id_33, t28.translation_de_id AS translation_de_id_34, t28.translation_pt_id AS translation_pt_id_35, t36.id AS id_37, t36.translation_en_id AS translation_en_id_38, t36.translation_fr_id AS translation_fr_id_39, t36.translation_us_id AS translation_us_id_40, t36.translation_es_id AS translation_es_id_41, t36.translation_de_id AS translation_de_id_42, t36.translation_pt_id AS translation_pt_id_43, t44.id AS id_45, t44.translation_en_id AS translation_en_id_46, t44.translation_fr_id AS translation_fr_id_47, t44.translation_us_id AS translation_us_id_48, t44.translation_es_id AS translation_es_id_49, t44.translation_de_id AS translation_de_id_50, t44.translation_pt_id AS translation_pt_id_51, t52.id AS id_53, t52.translation_en_id AS translation_en_id_54, t52.translation_fr_id AS translation_fr_id_55, t52.translation_us_id AS translation_us_id_56, t52.translation_es_id AS translation_es_id_57, t52.translation_de_id AS translation_de_id_58, t52.translation_pt_id AS translation_pt_id_59 FROM regulated_information_page t0 LEFT JOIN regulated_information_page_global t12 ON t12.translation_en_id = t0.id LEFT JOIN regulated_information_page_global t20 ON t20.translation_fr_id = t0.id LEFT JOIN regulated_information_page_global t28 ON t28.translation_us_id = t0.id LEFT JOIN regulated_information_page_global t36 ON t36.translation_es_id = t0.id LEFT JOIN regulated_information_page_global t44 ON t44.translation_de_id = t0.id LEFT JOIN regulated_information_page_global t52 ON t52.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\Investor\RegulatedInformationPage::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\Investor\RegulatedInformationPage->__get (line 25)
8	App\Entity\Investor\RegulatedInformationPage->getMetaTitle (line 94)
9	App\Entity\Investor\RegulatedInformationPageGlobal->__call (line 1861)
10	Twig\Extension\CoreExtension::getAttribute (line 89)
11	__TwigTemplate_b9ceb83130e3a11866601ee9b2e1010f->doDisplay (line 387)
12	Twig\Template->yield (line 55)
13	__TwigTemplate_325649ef74fa6c77aa535d864dc7fb9e->doDisplay (line 387)
14	Twig\Template->yield (line 55)
15	__TwigTemplate_87b41ad65d1871ef12e077735f687773->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 396)
24	App\Controller\FrontController->regulatedInformationPage (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.73 ms
(3.39%)

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 55)
13	__TwigTemplate_325649ef74fa6c77aa535d864dc7fb9e->doDisplay (line 387)
14	Twig\Template->yield (line 55)
15	__TwigTemplate_87b41ad65d1871ef12e077735f687773->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 396)
24	App\Controller\FrontController->regulatedInformationPage (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.50 ms
(2.33%)

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 55)
20	__TwigTemplate_325649ef74fa6c77aa535d864dc7fb9e->doDisplay (line 387)
21	Twig\Template->yield (line 55)
22	__TwigTemplate_87b41ad65d1871ef12e077735f687773->doDisplay (line 387)
23	Twig\Template->yield (line 343)
24	Twig\Template->display (line 358)
25	Twig\Template->render (line 35)
26	Twig\TemplateWrapper->render (line 320)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
31	App\Controller\FrontController->regulatedInformationPage (line 178)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

0.32 ms
(1.49%)

SELECT t0.filter_year AS filter_year_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 document_category_global t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.filter_year AS filter_year_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
  document_category_global t0

SELECT t0.filter_year AS filter_year_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 document_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 394)
5	App\Controller\FrontController->regulatedInformationPage (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.29 ms
(1.35%)

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:

[
  5
]

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 = 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\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 96)
17	__TwigTemplate_325649ef74fa6c77aa535d864dc7fb9e->block_body (line 431)
18	Twig\Template->yieldBlock (line 263)
19	__TwigTemplate_b9ceb83130e3a11866601ee9b2e1010f->doDisplay (line 387)
20	Twig\Template->yield (line 55)
21	__TwigTemplate_325649ef74fa6c77aa535d864dc7fb9e->doDisplay (line 387)
22	Twig\Template->yield (line 55)
23	__TwigTemplate_87b41ad65d1871ef12e077735f687773->doDisplay (line 387)
24	Twig\Template->yield (line 343)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 35)
27	Twig\TemplateWrapper->render (line 320)
28	Twig\Environment->render (line 431)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
32	App\Controller\FrontController->regulatedInformationPage (line 178)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 5)

0.26 ms
(1.18%)

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_regulated_information_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_regulated_information_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.17 ms
(0.81%)

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.17 ms
(0.77%)

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 regulated_information_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
  regulated_information_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 regulated_information_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 387)
6	App\Controller\FrontController->regulatedInformationPage (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.16 ms
(0.76%)

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 55)
10	__TwigTemplate_325649ef74fa6c77aa535d864dc7fb9e->doDisplay (line 387)
11	Twig\Template->yield (line 55)
12	__TwigTemplate_87b41ad65d1871ef12e077735f687773->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 320)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
21	App\Controller\FrontController->regulatedInformationPage (line 178)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.15 ms
(0.68%)

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 55)
10	__TwigTemplate_325649ef74fa6c77aa535d864dc7fb9e->doDisplay (line 387)
11	Twig\Template->yield (line 55)
12	__TwigTemplate_87b41ad65d1871ef12e077735f687773->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 320)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
21	App\Controller\FrontController->regulatedInformationPage (line 178)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.13 ms
(0.62%)

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 55)
10	__TwigTemplate_325649ef74fa6c77aa535d864dc7fb9e->doDisplay (line 387)
11	Twig\Template->yield (line 55)
12	__TwigTemplate_87b41ad65d1871ef12e077735f687773->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 320)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
21	App\Controller\FrontController->regulatedInformationPage (line 178)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	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\Investor\RegulatedInformationPageGlobal	No errors.
App\Entity\Investor\RegulatedInformationPage	The field App\Entity\Investor\RegulatedInformationPage#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Investor\RegulatedInformationPageGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\Investor\RegulatedInformationPage#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Investor\RegulatedInformationPageGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute. The field App\Entity\Investor\RegulatedInformationPage#translatedUs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Investor\RegulatedInformationPageGlobal#translationUs does not contain the required 'inversedBy="translatedUs"' attribute. The field App\Entity\Investor\RegulatedInformationPage#translatedEs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Investor\RegulatedInformationPageGlobal#translationEs does not contain the required 'inversedBy="translatedEs"' attribute. The field App\Entity\Investor\RegulatedInformationPage#translatedDe is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Investor\RegulatedInformationPageGlobal#translationDe does not contain the required 'inversedBy="translatedDe"' attribute. The field App\Entity\Investor\RegulatedInformationPage#translatedPt is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Investor\RegulatedInformationPageGlobal#translationPt does not contain the required 'inversedBy="translatedPt"' attribute.
App\Entity\Investor\Document	The field App\Entity\Investor\Document#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Investor\DocumentGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\Investor\Document#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Investor\DocumentGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute. The field App\Entity\Investor\Document#translatedUs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Investor\DocumentGlobal#translationUs does not contain the required 'inversedBy="translatedUs"' attribute. The field App\Entity\Investor\Document#translatedEs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Investor\DocumentGlobal#translationEs does not contain the required 'inversedBy="translatedEs"' attribute. The field App\Entity\Investor\Document#translatedDe is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Investor\DocumentGlobal#translationDe does not contain the required 'inversedBy="translatedDe"' attribute. The field App\Entity\Investor\Document#translatedPt is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Investor\DocumentGlobal#translationPt does not contain the required 'inversedBy="translatedPt"' attribute.
App\Entity\Investor\DocumentGlobal	No errors.
App\Entity\Investor\DocumentCategoryGlobal	No errors.
App\Entity\Investor\DocumentCategory	No errors.
App\Entity\Investor\EndBlock	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/regulated-information

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping