Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

12.55 ms Query time

0 Invalid entities

15 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.51 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.field AS field_2, c0_.controller AS controller_3, c0_.action AS action_4, c0_.type AS type_5, c0_.is_sitemap AS is_sitemap_6, c0_.is_contain_default_content_generator AS is_contain_default_content_generator_7, c0_.sort AS sort_8, c1_.id AS id_9, c1_.path AS path_10, c1_.seo_title AS seo_title_11, c1_.seo_description AS seo_description_12, c1_.seo_image AS seo_image_13, c1_.locale AS locale_14, c2_.id AS id_15, c2_.is_deletable AS is_deletable_16, c2_.sort AS sort_17, c3_.id AS id_18, c3_.name AS name_19, c3_.field AS field_20, c3_.type AS type_21, c4_.id AS id_22, c4_.name AS name_23, c4_.field AS field_24, c4_.type AS type_25, c4_.description AS description_26, c4_.options AS options_27, c4_.is_translation AS is_translation_28, c4_.is_required AS is_required_29, c4_.sort AS sort_30, c5_.id AS id_31, c5_.value AS value_32, c6_.id AS id_33, c6_.translation AS translation_34, c6_.locale AS locale_35, c7_.id AS id_36, c7_.name AS name_37, c7_.field AS field_38, c7_.type AS type_39, c7_.description AS description_40, c7_.options AS options_41, c7_.is_translation AS is_translation_42, c7_.is_required AS is_required_43, c7_.sort AS sort_44, c1_.translatable_id AS translatable_id_45, c2_.cms_generator_id AS cms_generator_id_46, c2_.cms_page_id AS cms_page_id_47, c4_.cms_generator_id AS cms_generator_id_48, c5_.cms_generator_page_id AS cms_generator_page_id_49, c5_.cms_generator_content_id AS cms_generator_content_id_50, c6_.translatable_id AS translatable_id_51, c7_.cms_generator_id AS cms_generator_id_52 FROM cms_page c0_ LEFT JOIN cms_page_translation c1_ ON c0_.id = c1_.translatable_id AND (c1_.locale = ?) LEFT JOIN cms_generator_page c2_ ON c0_.id = c2_.cms_page_id LEFT JOIN cms_generator c3_ ON c2_.cms_generator_id = c3_.id LEFT JOIN cms_generator_content c4_ ON c3_.id = c4_.cms_generator_id LEFT JOIN cms_page_content c5_ ON c2_.id = c5_.cms_generator_page_id LEFT JOIN cms_page_content_translation c6_ ON c5_.id = c6_.translatable_id AND (c6_.locale = ?) LEFT JOIN cms_generator_content c7_ ON c5_.cms_generator_content_id = c7_.id WHERE c0_.field = ? ORDER BY c2_.sort ASC, c4_.sort ASC

Parameters:

[
  "fr"
  "fr"
  "about_faq"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.field AS field_2,
  c0_.controller AS controller_3,
  c0_.action AS action_4,
  c0_.type AS type_5,
  c0_.is_sitemap AS is_sitemap_6,
  c0_.is_contain_default_content_generator AS is_contain_default_content_generator_7,
  c0_.sort AS sort_8,
  c1_.id AS id_9,
  c1_.path AS path_10,
  c1_.seo_title AS seo_title_11,
  c1_.seo_description AS seo_description_12,
  c1_.seo_image AS seo_image_13,
  c1_.locale AS locale_14,
  c2_.id AS id_15,
  c2_.is_deletable AS is_deletable_16,
  c2_.sort AS sort_17,
  c3_.id AS id_18,
  c3_.name AS name_19,
  c3_.field AS field_20,
  c3_.type AS type_21,
  c4_.id AS id_22,
  c4_.name AS name_23,
  c4_.field AS field_24,
  c4_.type AS type_25,
  c4_.description AS description_26,
  c4_.options AS options_27,
  c4_.is_translation AS is_translation_28,
  c4_.is_required AS is_required_29,
  c4_.sort AS sort_30,
  c5_.id AS id_31,
  c5_.value AS value_32,
  c6_.id AS id_33,
  c6_.translation AS translation_34,
  c6_.locale AS locale_35,
  c7_.id AS id_36,
  c7_.name AS name_37,
  c7_.field AS field_38,
  c7_.type AS type_39,
  c7_.description AS description_40,
  c7_.options AS options_41,
  c7_.is_translation AS is_translation_42,
  c7_.is_required AS is_required_43,
  c7_.sort AS sort_44,
  c1_.translatable_id AS translatable_id_45,
  c2_.cms_generator_id AS cms_generator_id_46,
  c2_.cms_page_id AS cms_page_id_47,
  c4_.cms_generator_id AS cms_generator_id_48,
  c5_.cms_generator_page_id AS cms_generator_page_id_49,
  c5_.cms_generator_content_id AS cms_generator_content_id_50,
  c6_.translatable_id AS translatable_id_51,
  c7_.cms_generator_id AS cms_generator_id_52
FROM
  cms_page c0_
  LEFT JOIN cms_page_translation c1_ ON c0_.id = c1_.translatable_id
  AND (c1_.locale = ?)
  LEFT JOIN cms_generator_page c2_ ON c0_.id = c2_.cms_page_id
  LEFT JOIN cms_generator c3_ ON c2_.cms_generator_id = c3_.id
  LEFT JOIN cms_generator_content c4_ ON c3_.id = c4_.cms_generator_id
  LEFT JOIN cms_page_content c5_ ON c2_.id = c5_.cms_generator_page_id
  LEFT JOIN cms_page_content_translation c6_ ON c5_.id = c6_.translatable_id
  AND (c6_.locale = ?)
  LEFT JOIN cms_generator_content c7_ ON c5_.cms_generator_content_id = c7_.id
WHERE
  c0_.field = ?
ORDER BY
  c2_.sort ASC,
  c4_.sort ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.field AS field_2, c0_.controller AS controller_3, c0_.action AS action_4, c0_.type AS type_5, c0_.is_sitemap AS is_sitemap_6, c0_.is_contain_default_content_generator AS is_contain_default_content_generator_7, c0_.sort AS sort_8, c1_.id AS id_9, c1_.path AS path_10, c1_.seo_title AS seo_title_11, c1_.seo_description AS seo_description_12, c1_.seo_image AS seo_image_13, c1_.locale AS locale_14, c2_.id AS id_15, c2_.is_deletable AS is_deletable_16, c2_.sort AS sort_17, c3_.id AS id_18, c3_.name AS name_19, c3_.field AS field_20, c3_.type AS type_21, c4_.id AS id_22, c4_.name AS name_23, c4_.field AS field_24, c4_.type AS type_25, c4_.description AS description_26, c4_.options AS options_27, c4_.is_translation AS is_translation_28, c4_.is_required AS is_required_29, c4_.sort AS sort_30, c5_.id AS id_31, c5_.value AS value_32, c6_.id AS id_33, c6_.translation AS translation_34, c6_.locale AS locale_35, c7_.id AS id_36, c7_.name AS name_37, c7_.field AS field_38, c7_.type AS type_39, c7_.description AS description_40, c7_.options AS options_41, c7_.is_translation AS is_translation_42, c7_.is_required AS is_required_43, c7_.sort AS sort_44, c1_.translatable_id AS translatable_id_45, c2_.cms_generator_id AS cms_generator_id_46, c2_.cms_page_id AS cms_page_id_47, c4_.cms_generator_id AS cms_generator_id_48, c5_.cms_generator_page_id AS cms_generator_page_id_49, c5_.cms_generator_content_id AS cms_generator_content_id_50, c6_.translatable_id AS translatable_id_51, c7_.cms_generator_id AS cms_generator_id_52 FROM cms_page c0_ LEFT JOIN cms_page_translation c1_ ON c0_.id = c1_.translatable_id AND (c1_.locale = 'fr') LEFT JOIN cms_generator_page c2_ ON c0_.id = c2_.cms_page_id LEFT JOIN cms_generator c3_ ON c2_.cms_generator_id = c3_.id LEFT JOIN cms_generator_content c4_ ON c3_.id = c4_.cms_generator_id LEFT JOIN cms_page_content c5_ ON c2_.id = c5_.cms_generator_page_id LEFT JOIN cms_page_content_translation c6_ ON c5_.id = c6_.translatable_id AND (c6_.locale = 'fr') LEFT JOIN cms_generator_content c7_ ON c5_.cms_generator_content_id = c7_.id WHERE c0_.field = 'about_faq' ORDER BY c2_.sort ASC, c4_.sort ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Core\Repository\CmsPageRepository->getOneByField (line 82)
7	App\Core\Service\Page->{closure:App\Core\Service\Page::get():139} (line 140)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():45} (line 48)
9	Symfony\Component\Cache\LockRegistry->compute (line 111)
10	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 53)
15	App\Core\Service\Page->get (line 139)
16	App\Controller\Front\AboutController->faq (line 46)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

0.50 ms

SELECT t0.id AS id_1, t0.is_deletable AS is_deletable_2, t0.sort AS sort_3, t0.cms_generator_id AS cms_generator_id_4, t5.id AS id_6, t5.name AS name_7, t5.field AS field_8, t5.type AS type_9, t0.cms_page_id AS cms_page_id_10, t11.id AS id_12, t11.name AS name_13, t11.field AS field_14, t11.controller AS controller_15, t11.action AS action_16, t11.type AS type_17, t11.is_sitemap AS is_sitemap_18, t11.is_contain_default_content_generator AS is_contain_default_content_generator_19, t11.sort AS sort_20 FROM cms_generator_page t0 INNER JOIN cms_generator t5 ON t0.cms_generator_id = t5.id INNER JOIN cms_page t11 ON t0.cms_page_id = t11.id WHERE t0.cms_generator_id IN (?) ORDER BY t0.sort ASC

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.is_deletable AS is_deletable_2,
  t0.sort AS sort_3,
  t0.cms_generator_id AS cms_generator_id_4,
  t5.id AS id_6,
  t5.name AS name_7,
  t5.field AS field_8,
  t5.type AS type_9,
  t0.cms_page_id AS cms_page_id_10,
  t11.id AS id_12,
  t11.name AS name_13,
  t11.field AS field_14,
  t11.controller AS controller_15,
  t11.action AS action_16,
  t11.type AS type_17,
  t11.is_sitemap AS is_sitemap_18,
  t11.is_contain_default_content_generator AS is_contain_default_content_generator_19,
  t11.sort AS sort_20
FROM
  cms_generator_page t0
  INNER JOIN cms_generator t5 ON t0.cms_generator_id = t5.id
  INNER JOIN cms_page t11 ON t0.cms_page_id = t11.id
WHERE
  t0.cms_generator_id IN (?)
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.is_deletable AS is_deletable_2, t0.sort AS sort_3, t0.cms_generator_id AS cms_generator_id_4, t5.id AS id_6, t5.name AS name_7, t5.field AS field_8, t5.type AS type_9, t0.cms_page_id AS cms_page_id_10, t11.id AS id_12, t11.name AS name_13, t11.field AS field_14, t11.controller AS controller_15, t11.action AS action_16, t11.type AS type_17, t11.is_sitemap AS is_sitemap_18, t11.is_contain_default_content_generator AS is_contain_default_content_generator_19, t11.sort AS sort_20 FROM cms_generator_page t0 INNER JOIN cms_generator t5 ON t0.cms_generator_id = t5.id INNER JOIN cms_page t11 ON t0.cms_page_id = t11.id WHERE t0.cms_generator_id IN (16) ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2677)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2653)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 124)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
7	Doctrine\ORM\AbstractQuery->execute (line 886)
8	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
9	App\Core\Repository\CmsPageRepository->getOneByField (line 82)
10	App\Core\Service\Page->{closure:App\Core\Service\Page::get():139} (line 140)
11	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():45} (line 48)
12	Symfony\Component\Cache\LockRegistry->compute (line 111)
13	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
16	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
17	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 53)
18	App\Core\Service\Page->get (line 139)
19	App\Controller\Front\AboutController->faq (line 46)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	require_once (line 5)

9.54 ms

SELECT f0_.id AS id_0, f0_.sort AS sort_1, f1_.id AS id_2, f1_.title AS title_3, f1_.description AS description_4, f1_.locale AS locale_5, f2_.id AS id_6, f2_.sort AS sort_7, f3_.id AS id_8, f3_.title AS title_9, f3_.description AS description_10, f3_.locale AS locale_11, f1_.translatable_id AS translatable_id_12, f2_.faq_id AS faq_id_13, f3_.translatable_id AS translatable_id_14 FROM faq f0_ LEFT JOIN faq_translation f1_ ON f0_.id = f1_.translatable_id AND (f1_.locale = ?) LEFT JOIN faq_item f2_ ON f0_.id = f2_.faq_id LEFT JOIN faq_item_translation f3_ ON f2_.id = f3_.translatable_id AND (f3_.locale = ?) ORDER BY f0_.sort ASC, f2_.sort ASC

Parameters:

[
  "fr"
  "fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.sort AS sort_1,
  f1_.id AS id_2,
  f1_.title AS title_3,
  f1_.description AS description_4,
  f1_.locale AS locale_5,
  f2_.id AS id_6,
  f2_.sort AS sort_7,
  f3_.id AS id_8,
  f3_.title AS title_9,
  f3_.description AS description_10,
  f3_.locale AS locale_11,
  f1_.translatable_id AS translatable_id_12,
  f2_.faq_id AS faq_id_13,
  f3_.translatable_id AS translatable_id_14
FROM
  faq f0_
  LEFT JOIN faq_translation f1_ ON f0_.id = f1_.translatable_id
  AND (f1_.locale = ?)
  LEFT JOIN faq_item f2_ ON f0_.id = f2_.faq_id
  LEFT JOIN faq_item_translation f3_ ON f2_.id = f3_.translatable_id
  AND (f3_.locale = ?)
ORDER BY
  f0_.sort ASC,
  f2_.sort ASC

SELECT f0_.id AS id_0, f0_.sort AS sort_1, f1_.id AS id_2, f1_.title AS title_3, f1_.description AS description_4, f1_.locale AS locale_5, f2_.id AS id_6, f2_.sort AS sort_7, f3_.id AS id_8, f3_.title AS title_9, f3_.description AS description_10, f3_.locale AS locale_11, f1_.translatable_id AS translatable_id_12, f2_.faq_id AS faq_id_13, f3_.translatable_id AS translatable_id_14 FROM faq f0_ LEFT JOIN faq_translation f1_ ON f0_.id = f1_.translatable_id AND (f1_.locale = 'fr') LEFT JOIN faq_item f2_ ON f0_.id = f2_.faq_id LEFT JOIN faq_item_translation f3_ ON f2_.id = f3_.translatable_id AND (f3_.locale = 'fr') ORDER BY f0_.sort ASC, f2_.sort ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\About\FaqRepository->findAllFaqs (line 37)
7	App\Controller\Front\AboutController->faq (line 48)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\About\Faq	2
App\Entity\About\FaqTranslation	2
App\Entity\About\FaqItem	2
App\Entity\About\FaqItemTranslation	2
App\Core\Entity\CmsPage	1
App\Core\Entity\CmsPageTranslation	1
App\Core\Entity\CmsGeneratorPage	1
App\Core\Entity\CmsGenerator	1
App\Core\Entity\CmsGeneratorContent	1
App\Core\Entity\CmsPageContent	1
App\Core\Entity\CmsPageContentTranslation	1

Entities Mapping

Class	Mapping errors
App\Core\Entity\CmsPage	No errors.
App\Core\Entity\CmsPageTranslation	No errors.
App\Core\Entity\CmsGeneratorPage	No errors.
App\Core\Entity\CmsGenerator	No errors.
App\Core\Entity\CmsGeneratorContent	No errors.
App\Core\Entity\CmsPageContent	No errors.
App\Core\Entity\CmsPageContentTranslation	No errors.
App\Core\Entity\CmsGeneratorFlexiblePage	No errors.
App\Core\Entity\CmsGeneratorEmail	No errors.
App\Core\Entity\CmsEmailContent	No errors.
App\Entity\About\Faq	No errors.
App\Entity\About\FaqTranslation	No errors.
App\Entity\About\FaqItem	No errors.
App\Entity\About\FaqItemTranslation	No errors.

Symfony Profiler

GET https://www.renovaweb.hb-preprod.com/foires-aux-questions

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping