Symfony Profiler

Query Metrics

66 Database Queries

23 Different statements

35.55 ms Query time

2 Invalid entities

124 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.38 ms
(29.21%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.title AS title_8, t0.catchphrase AS catchphrase_9, t0.slug AS slug_10, t0.link AS link_11, t0.canonical_url AS canonical_url_12, t0.publication_start_at AS publication_start_at_13, t0.publication_end_at AS publication_end_at_14, t0.parameters AS parameters_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.og_title AS og_title_18, t0.og_description AS og_description_19, t0.og_image AS og_image_20, t0.twitter_title AS twitter_title_21, t0.twitter_description AS twitter_description_22, t0.twitter_image AS twitter_image_23, t0.robots AS robots_24, t0.language_id AS language_id_25, t0.object_id AS object_id_26, t0.type_id AS type_id_27, t0.builder_data_id AS builder_data_id_28 FROM page_translation t0 WHERE t0.object_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.language_id ASC, t0.position ASC

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.position AS position_5,
  t0.hidden AS hidden_6,
  t0.enabled AS enabled_7,
  t0.title AS title_8,
  t0.catchphrase AS catchphrase_9,
  t0.slug AS slug_10,
  t0.link AS link_11,
  t0.canonical_url AS canonical_url_12,
  t0.publication_start_at AS publication_start_at_13,
  t0.publication_end_at AS publication_end_at_14,
  t0.parameters AS parameters_15,
  t0.meta_title AS meta_title_16,
  t0.meta_description AS meta_description_17,
  t0.og_title AS og_title_18,
  t0.og_description AS og_description_19,
  t0.og_image AS og_image_20,
  t0.twitter_title AS twitter_title_21,
  t0.twitter_description AS twitter_description_22,
  t0.twitter_image AS twitter_image_23,
  t0.robots AS robots_24,
  t0.language_id AS language_id_25,
  t0.object_id AS object_id_26,
  t0.type_id AS type_id_27,
  t0.builder_data_id AS builder_data_id_28
FROM
  page_translation t0
WHERE
  t0.object_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.language_id ASC,
  t0.position ASC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.title AS title_8, t0.catchphrase AS catchphrase_9, t0.slug AS slug_10, t0.link AS link_11, t0.canonical_url AS canonical_url_12, t0.publication_start_at AS publication_start_at_13, t0.publication_end_at AS publication_end_at_14, t0.parameters AS parameters_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.og_title AS og_title_18, t0.og_description AS og_description_19, t0.og_image AS og_image_20, t0.twitter_title AS twitter_title_21, t0.twitter_description AS twitter_description_22, t0.twitter_image AS twitter_image_23, t0.robots AS robots_24, t0.language_id AS language_id_25, t0.object_id AS object_id_26, t0.type_id AS type_id_27, t0.builder_data_id AS builder_data_id_28 FROM page_translation t0 WHERE t0.object_id = 7 AND ((t0.deleted_at IS NULL)) ORDER BY t0.language_id ASC, t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	Koredge\ContentBundle\Orm\MappedSuperclass\Translation->getTranslation (line 82)
8	Koredge\ContentBundle\Service\SiteService->handleRequest (line 48)
9	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 182)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 5)

3.37 ms
(9.49%)

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.position AS position_4, t0.hidden AS hidden_5, t0.id AS id_6, t0.enabled AS enabled_7, t0.content AS content_8, t0.parameters AS parameters_9, t0.builder_block_type_id AS builder_block_type_id_10, t0.builder_section_id AS builder_section_id_11 FROM builder_block t0 WHERE t0.builder_section_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  109
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.position AS position_4,
  t0.hidden AS hidden_5,
  t0.id AS id_6,
  t0.enabled AS enabled_7,
  t0.content AS content_8,
  t0.parameters AS parameters_9,
  t0.builder_block_type_id AS builder_block_type_id_10,
  t0.builder_section_id AS builder_section_id_11
FROM
  builder_block t0
WHERE
  t0.builder_section_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.position AS position_4, t0.hidden AS hidden_5, t0.id AS id_6, t0.enabled AS enabled_7, t0.content AS content_8, t0.parameters AS parameters_9, t0.builder_block_type_id AS builder_block_type_id_10, t0.builder_section_id AS builder_section_id_11 FROM builder_block t0 WHERE t0.builder_section_id = 109 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	Koredge\BuilderBundle\Orm\Entity\BuilderSection->getBuilderBlocks (line 82)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_085fe6cc5072ef56b62ca81e377aa40f::doDisplay (line 84)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099->block_body (line 447)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_39928d8dc55ffded8716cb2222b379de->doDisplay (line 121)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099->doDisplay (line 55)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Koredge\ContentBundle\Service\SiteService->handleRequest (line 57)
22	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 182)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

2.37 ms
(6.68%)

SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.deleted_at AS deleted_at_2, s0_.position AS position_3, s0_.hidden AS hidden_4, s0_.id AS id_5, s0_.name AS name_6, s0_.domain AS domain_7, s0_.recaptcha_public_key AS recaptcha_public_key_8, s0_.recaptcha_secret_key AS recaptcha_secret_key_9, s0_.owner AS owner_10, s0_.siret AS siret_11, s0_.intracommunity_vat AS intracommunity_vat_12, s0_.rcs AS rcs_13, s0_.capital AS capital_14, s0_.registered_office AS registered_office_15, s0_.cmp AS cmp_16, s0_.meta_title AS meta_title_17, s0_.meta_description AS meta_description_18, s0_.theme_slug AS theme_slug_19, s0_.custom_css AS custom_css_20, s0_.enabled AS enabled_21, s0_.default_language_id AS default_language_id_22, s0_.license_id AS license_id_23 FROM site s0_ WHERE (s0_.domain = ?) AND (s0_.deleted_at IS NULL)

Parameters:

[
  "preprod.olivier-ciappuccini-osteopathe.fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.created_at AS created_at_0,
  s0_.updated_at AS updated_at_1,
  s0_.deleted_at AS deleted_at_2,
  s0_.position AS position_3,
  s0_.hidden AS hidden_4,
  s0_.id AS id_5,
  s0_.name AS name_6,
  s0_.domain AS domain_7,
  s0_.recaptcha_public_key AS recaptcha_public_key_8,
  s0_.recaptcha_secret_key AS recaptcha_secret_key_9,
  s0_.owner AS owner_10,
  s0_.siret AS siret_11,
  s0_.intracommunity_vat AS intracommunity_vat_12,
  s0_.rcs AS rcs_13,
  s0_.capital AS capital_14,
  s0_.registered_office AS registered_office_15,
  s0_.cmp AS cmp_16,
  s0_.meta_title AS meta_title_17,
  s0_.meta_description AS meta_description_18,
  s0_.theme_slug AS theme_slug_19,
  s0_.custom_css AS custom_css_20,
  s0_.enabled AS enabled_21,
  s0_.default_language_id AS default_language_id_22,
  s0_.license_id AS license_id_23
FROM
  site s0_
WHERE
  (s0_.domain = ?)
  AND (s0_.deleted_at IS NULL)

SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.deleted_at AS deleted_at_2, s0_.position AS position_3, s0_.hidden AS hidden_4, s0_.id AS id_5, s0_.name AS name_6, s0_.domain AS domain_7, s0_.recaptcha_public_key AS recaptcha_public_key_8, s0_.recaptcha_secret_key AS recaptcha_secret_key_9, s0_.owner AS owner_10, s0_.siret AS siret_11, s0_.intracommunity_vat AS intracommunity_vat_12, s0_.rcs AS rcs_13, s0_.capital AS capital_14, s0_.registered_office AS registered_office_15, s0_.cmp AS cmp_16, s0_.meta_title AS meta_title_17, s0_.meta_description AS meta_description_18, s0_.theme_slug AS theme_slug_19, s0_.custom_css AS custom_css_20, s0_.enabled AS enabled_21, s0_.default_language_id AS default_language_id_22, s0_.license_id AS license_id_23 FROM site s0_ WHERE (s0_.domain = 'preprod.olivier-ciappuccini-osteopathe.fr') AND (s0_.deleted_at IS NULL);

#	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	Koredge\SiteBundle\Repository\SiteRepository->findOneByDomain (line 27)
7	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 81)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

2.13 ms
(5.98%)

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.position AS position_4, t0.hidden AS hidden_5, t0.id AS id_6, t0.enabled AS enabled_7, t0.templates AS templates_8, t0.parameters AS parameters_9, t0.picture AS picture_10, t0.name AS name_11, t0.description AS description_12, t0.type AS type_13, t0.default_params AS default_params_14 FROM builder_block_type t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  199
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.position AS position_4,
  t0.hidden AS hidden_5,
  t0.id AS id_6,
  t0.enabled AS enabled_7,
  t0.templates AS templates_8,
  t0.parameters AS parameters_9,
  t0.picture AS picture_10,
  t0.name AS name_11,
  t0.description AS description_12,
  t0.type AS type_13,
  t0.default_params AS default_params_14
FROM
  builder_block_type t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.position AS position_4, t0.hidden AS hidden_5, t0.id AS id_6, t0.enabled AS enabled_7, t0.templates AS templates_8, t0.parameters AS parameters_9, t0.picture AS picture_10, t0.name AS name_11, t0.description AS description_12, t0.type AS type_13, t0.default_params AS default_params_14 FROM builder_block_type t0 WHERE t0.id = 199 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():288} (line 289)
4	Proxies\__CG__\Koredge\BuilderBundle\Orm\Entity\BuilderBlockType::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():365}:366} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Koredge\BuilderBundle\Orm\Entity\BuilderBlockType->__isset (line 258)
7	Koredge\BuilderBundle\Orm\Entity\BuilderBlockType->getTemplate (line 73)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_085fe6cc5072ef56b62ca81e377aa40f::doDisplay (line 104)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099->block_body (line 447)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_39928d8dc55ffded8716cb2222b379de->doDisplay (line 121)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099->doDisplay (line 55)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Koredge\ContentBundle\Service\SiteService->handleRequest (line 57)
22	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 182)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

2.09 ms
(5.87%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.name AS name_8, t0.language_id AS language_id_9, t0.object_id AS object_id_10 FROM menu_item_translation t0 WHERE t0.object_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  17
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.position AS position_5,
  t0.hidden AS hidden_6,
  t0.enabled AS enabled_7,
  t0.name AS name_8,
  t0.language_id AS language_id_9,
  t0.object_id AS object_id_10
FROM
  menu_item_translation t0
WHERE
  t0.object_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.name AS name_8, t0.language_id AS language_id_9, t0.object_id AS object_id_10 FROM menu_item_translation t0 WHERE t0.object_id = 17 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->isEmpty (line 446)
9	Koredge\ContentBundle\Orm\Entity\MenuItem->getName (line 215)
10	Twig\Extension\CoreExtension->getAttribute (line 1909)
11	__TwigTemplate_a588148a5eedb7b14c8ef63572f4be6f::{closure:__TwigTemplate_a588148a5eedb7b14c8ef63572f4be6f::macro_render():199} (line 348)
12	Twig\Extension\CoreExtension->captureOutput (line 2106)
13	__TwigTemplate_a588148a5eedb7b14c8ef63572f4be6f::macro_render (line 199)
14	__TwigTemplate_a588148a5eedb7b14c8ef63572f4be6f->doDisplay (line 149)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_39928d8dc55ffded8716cb2222b379de->doDisplay (line 108)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099->doDisplay (line 55)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Koredge\ContentBundle\Service\SiteService->handleRequest (line 57)
25	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
26	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
27	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
28	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
29	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 182)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 29)
35	require_once (line 5)

1.99 ms
(5.60%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.resource AS resource_8, t0.repository AS repository_9, t0.tree_left AS tree_left_10, t0.tree_right AS tree_right_11, t0.tree_level AS tree_level_12, t0.menu_id AS menu_id_13, t0.root_id AS root_id_14, t0.menu_item_id AS menu_item_id_15 FROM menu_item t0 WHERE t0.menu_item_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC

Parameters:

[
  17
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.position AS position_5,
  t0.hidden AS hidden_6,
  t0.enabled AS enabled_7,
  t0.resource AS resource_8,
  t0.repository AS repository_9,
  t0.tree_left AS tree_left_10,
  t0.tree_right AS tree_right_11,
  t0.tree_level AS tree_level_12,
  t0.menu_id AS menu_id_13,
  t0.root_id AS root_id_14,
  t0.menu_item_id AS menu_item_id_15
FROM
  menu_item t0
WHERE
  t0.menu_item_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.resource AS resource_8, t0.repository AS repository_9, t0.tree_left AS tree_left_10, t0.tree_right AS tree_right_11, t0.tree_level AS tree_level_12, t0.menu_id AS menu_id_13, t0.root_id AS root_id_14, t0.menu_item_id AS menu_item_id_15 FROM menu_item t0 WHERE t0.menu_item_id = 17 AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->testEmpty (line 1417)
9	__TwigTemplate_a588148a5eedb7b14c8ef63572f4be6f::{closure:__TwigTemplate_a588148a5eedb7b14c8ef63572f4be6f::macro_render():199} (line 253)
10	Twig\Extension\CoreExtension->captureOutput (line 2106)
11	__TwigTemplate_a588148a5eedb7b14c8ef63572f4be6f::macro_render (line 199)
12	__TwigTemplate_a588148a5eedb7b14c8ef63572f4be6f->doDisplay (line 149)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_39928d8dc55ffded8716cb2222b379de->doDisplay (line 108)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099->doDisplay (line 55)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Koredge\ContentBundle\Service\SiteService->handleRequest (line 57)
23	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	require_once (line 5)

1.70 ms
(4.79%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.site_id AS site_id_8 FROM menu t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.position AS position_5,
  t0.hidden AS hidden_6,
  t0.enabled AS enabled_7,
  t0.site_id AS site_id_8
FROM
  menu t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.site_id AS site_id_8 FROM menu t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():288} (line 289)
4	Proxies\__CG__\Koredge\ContentBundle\Orm\Entity\Menu::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():365}:366} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Koredge\ContentBundle\Orm\Entity\Menu->__get (line 153)
7	Koredge\ContentBundle\Orm\Entity\Menu->getSite (line 114)
8	Koredge\ContentBundle\Twig\CmsExtension->{closure:Koredge\ContentBundle\Twig\CmsExtension::getMenusFromZone():146} (line 147)
9	array_filter (line 379)
10	Doctrine\Common\Collections\ArrayCollection::filter (line 379)
11	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 239)
12	Koredge\ContentBundle\Twig\CmsExtension->getMenusFromZone (line 146)
13	__TwigTemplate_a588148a5eedb7b14c8ef63572f4be6f->doDisplay (line 48)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_39928d8dc55ffded8716cb2222b379de->doDisplay (line 108)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099->doDisplay (line 55)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Koredge\ContentBundle\Service\SiteService->handleRequest (line 57)
24	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 5)

1.10 ms
(3.09%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.title AS title_8, t0.menu_id AS menu_id_9, t0.zone_id AS zone_id_10 FROM menu_zone t0 WHERE t0.zone_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.position AS position_5,
  t0.hidden AS hidden_6,
  t0.enabled AS enabled_7,
  t0.title AS title_8,
  t0.menu_id AS menu_id_9,
  t0.zone_id AS zone_id_10
FROM
  menu_zone t0
WHERE
  t0.zone_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.title AS title_8, t0.menu_id AS menu_id_9, t0.zone_id AS zone_id_10 FROM menu_zone t0 WHERE t0.zone_id = 1 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 237)
7	Koredge\ContentBundle\Twig\CmsExtension->getMenusFromZone (line 146)
8	__TwigTemplate_a588148a5eedb7b14c8ef63572f4be6f->doDisplay (line 48)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_39928d8dc55ffded8716cb2222b379de->doDisplay (line 108)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099->doDisplay (line 55)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Koredge\ContentBundle\Service\SiteService->handleRequest (line 57)
19	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

1.05 ms
(2.96%)

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.position AS position_4, t0.hidden AS hidden_5, t0.id AS id_6, t0.enabled AS enabled_7, t0.name AS name_8, t0.columns AS columns_9, t0.picture AS picture_10, t0.template AS template_11, t0.parameters AS parameters_12 FROM builder_layout t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  64
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.position AS position_4,
  t0.hidden AS hidden_5,
  t0.id AS id_6,
  t0.enabled AS enabled_7,
  t0.name AS name_8,
  t0.columns AS columns_9,
  t0.picture AS picture_10,
  t0.template AS template_11,
  t0.parameters AS parameters_12
FROM
  builder_layout t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.position AS position_4, t0.hidden AS hidden_5, t0.id AS id_6, t0.enabled AS enabled_7, t0.name AS name_8, t0.columns AS columns_9, t0.picture AS picture_10, t0.template AS template_11, t0.parameters AS parameters_12 FROM builder_layout t0 WHERE t0.id = 64 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():288} (line 289)
4	Proxies\__CG__\Koredge\BuilderBundle\Orm\Entity\BuilderLayout::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():365}:366} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Koredge\BuilderBundle\Orm\Entity\BuilderLayout->__get (line 153)
7	Koredge\BuilderBundle\Orm\Entity\BuilderLayout->getTemplate (line 76)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099::block_body (line 447)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_39928d8dc55ffded8716cb2222b379de->doDisplay (line 121)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Koredge\ContentBundle\Service\SiteService->handleRequest (line 57)
20	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

1.02 ms
(2.88%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM zone t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  zone t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM zone t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Koredge\ContentBundle\Twig\CmsExtension->getMenusFromZone (line 141)
7	__TwigTemplate_a588148a5eedb7b14c8ef63572f4be6f->doDisplay (line 48)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_39928d8dc55ffded8716cb2222b379de->doDisplay (line 108)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099->doDisplay (line 55)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Koredge\ContentBundle\Service\SiteService->handleRequest (line 57)
18	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.82 ms
(2.30%)

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.position AS position_4, t0.hidden AS hidden_5, t0.icon AS icon_6, t0.id AS id_7, t0.name AS name_8 FROM social_media t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.position AS position_4,
  t0.hidden AS hidden_5,
  t0.icon AS icon_6,
  t0.id AS id_7,
  t0.name AS name_8
FROM
  social_media t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.position AS position_4, t0.hidden AS hidden_5, t0.icon AS icon_6, t0.id AS id_7, t0.name AS name_8 FROM social_media t0 WHERE t0.id = 3 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():288} (line 289)
4	Proxies\__CG__\Koredge\SiteBundle\Orm\Entity\Site\SocialMedia::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():365}:366} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Koredge\SiteBundle\Orm\Entity\Site\SocialMedia->__isset (line 258)
7	Koredge\SiteBundle\Orm\Entity\Site\SocialMedia->__toString (line 66)
8	__TwigTemplate_961056bb6676da07ce6940d53aaf82d9->doDisplay (line 116)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_39928d8dc55ffded8716cb2222b379de->doDisplay (line 129)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099->doDisplay (line 55)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Koredge\ContentBundle\Service\SiteService->handleRequest (line 57)
19	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.79 ms
(2.21%)

SELECT t0.id AS id_1, t0.id AS id_2 FROM document_site_extension t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.id AS id_2
FROM
  document_site_extension t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id AS id_2 FROM document_site_extension t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Koredge\DocumentBundle\Repository\Site\SiteRepository->findForBaseSite (line 28)
7	Koredge\DocumentBundle\EventListener\Site\SiteListener->postLoad (line 27)
8	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
9	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
10	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
11	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3203)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 177)
14	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
15	Doctrine\ORM\AbstractQuery->execute (line 886)
16	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
17	Koredge\SiteBundle\Repository\SiteRepository->findOneByDomain (line 27)
18	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 81)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.75 ms
(2.11%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.resource AS resource_8, t0.repository AS repository_9, t0.tree_left AS tree_left_10, t0.tree_right AS tree_right_11, t0.tree_level AS tree_level_12, t0.menu_id AS menu_id_13, t0.root_id AS root_id_14, t0.menu_item_id AS menu_item_id_15 FROM menu_item t0 WHERE t0.menu_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.position AS position_5,
  t0.hidden AS hidden_6,
  t0.enabled AS enabled_7,
  t0.resource AS resource_8,
  t0.repository AS repository_9,
  t0.tree_left AS tree_left_10,
  t0.tree_right AS tree_right_11,
  t0.tree_level AS tree_level_12,
  t0.menu_id AS menu_id_13,
  t0.root_id AS root_id_14,
  t0.menu_item_id AS menu_item_id_15
FROM
  menu_item t0
WHERE
  t0.menu_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.resource AS resource_8, t0.repository AS repository_9, t0.tree_left AS tree_left_10, t0.tree_right AS tree_right_11, t0.tree_level AS tree_level_12, t0.menu_id AS menu_id_13, t0.root_id AS root_id_14, t0.menu_item_id AS menu_item_id_15 FROM menu_item t0 WHERE t0.menu_id = 6 AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	__TwigTemplate_a588148a5eedb7b14c8ef63572f4be6f->doDisplay (line 143)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_39928d8dc55ffded8716cb2222b379de->doDisplay (line 108)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099->doDisplay (line 55)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Koredge\ContentBundle\Service\SiteService->handleRequest (line 57)
18	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.73 ms
(2.06%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.tree_left AS tree_left_8, t0.tree_right AS tree_right_9, t0.tree_level AS tree_level_10, t0.parent_id AS parent_id_11, t0.site_id AS site_id_12, t0.root_id AS root_id_13 FROM page t0 WHERE ((t0.deleted_at IS NULL))

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.position AS position_5,
  t0.hidden AS hidden_6,
  t0.enabled AS enabled_7,
  t0.tree_left AS tree_left_8,
  t0.tree_right AS tree_right_9,
  t0.tree_level AS tree_level_10,
  t0.parent_id AS parent_id_11,
  t0.site_id AS site_id_12,
  t0.root_id AS root_id_13
FROM
  page t0
WHERE
  (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.tree_left AS tree_left_8, t0.tree_right AS tree_right_9, t0.tree_level AS tree_level_10, t0.parent_id AS parent_id_11, t0.site_id AS site_id_12, t0.root_id AS root_id_13 FROM page t0 WHERE ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	Koredge\ContentBundle\Service\SiteService->handleRequest (line 45)
6	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.72 ms
(2.02%)

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.position AS position_4, t0.hidden AS hidden_5, t0.address AS address_6, t0.address2 AS address2_7, t0.city AS city_8, t0.fax AS fax_9, t0.id AS id_10, t0.name AS name_11, t0.phone AS phone_12, t0.portable AS portable_13, t0.type AS type_14, t0.zipcode AS zipcode_15, t0.country AS country_16, t0.company AS company_17, t0.contact_mail AS contact_mail_18, t0.mail_tester AS mail_tester_19, t0.schedules AS schedules_20, t0.site_id AS site_id_21 FROM site_address t0 WHERE t0.site_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.position AS position_4,
  t0.hidden AS hidden_5,
  t0.address AS address_6,
  t0.address2 AS address2_7,
  t0.city AS city_8,
  t0.fax AS fax_9,
  t0.id AS id_10,
  t0.name AS name_11,
  t0.phone AS phone_12,
  t0.portable AS portable_13,
  t0.type AS type_14,
  t0.zipcode AS zipcode_15,
  t0.country AS country_16,
  t0.company AS company_17,
  t0.contact_mail AS contact_mail_18,
  t0.mail_tester AS mail_tester_19,
  t0.schedules AS schedules_20,
  t0.site_id AS site_id_21
FROM
  site_address t0
WHERE
  t0.site_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.position AS position_4, t0.hidden AS hidden_5, t0.address AS address_6, t0.address2 AS address2_7, t0.city AS city_8, t0.fax AS fax_9, t0.id AS id_10, t0.name AS name_11, t0.phone AS phone_12, t0.portable AS portable_13, t0.type AS type_14, t0.zipcode AS zipcode_15, t0.country AS country_16, t0.company AS company_17, t0.contact_mail AS contact_mail_18, t0.mail_tester AS mail_tester_19, t0.schedules AS schedules_20, t0.site_id AS site_id_21 FROM site_address t0 WHERE t0.site_id = 2 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 108)
7	Doctrine\ORM\PersistentCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->offsetExists (line 420)
9	Twig\Extension\CoreExtension->getAttribute (line 1698)
10	__TwigTemplate_a588148a5eedb7b14c8ef63572f4be6f::doDisplay (line 62)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_39928d8dc55ffded8716cb2222b379de->doDisplay (line 108)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099->doDisplay (line 55)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Koredge\ContentBundle\Service\SiteService->handleRequest (line 57)
21	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 182)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 29)
31	require_once (line 5)

0.68 ms
(1.92%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.image AS image_8, t0.image_type_id AS image_type_id_9, t0.page_translation_id AS page_translation_id_10 FROM page_image t0 WHERE t0.page_translation_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  24
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.position AS position_5,
  t0.hidden AS hidden_6,
  t0.enabled AS enabled_7,
  t0.image AS image_8,
  t0.image_type_id AS image_type_id_9,
  t0.page_translation_id AS page_translation_id_10
FROM
  page_image t0
WHERE
  t0.page_translation_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.image AS image_8, t0.image_type_id AS image_type_id_9, t0.page_translation_id AS page_translation_id_10 FROM page_image t0 WHERE t0.page_translation_id = 24 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099->block_body (line 388)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_39928d8dc55ffded8716cb2222b379de->doDisplay (line 121)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099->doDisplay (line 55)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Koredge\ContentBundle\Service\SiteService->handleRequest (line 57)
18	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.67 ms
(1.89%)

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.position AS position_4, t0.hidden AS hidden_5, t0.id AS id_6, t0.url AS url_7, t0.site_id AS site_id_8, t0.social_media_id AS social_media_id_9 FROM site_social_media t0 WHERE t0.site_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.position AS position_4,
  t0.hidden AS hidden_5,
  t0.id AS id_6,
  t0.url AS url_7,
  t0.site_id AS site_id_8,
  t0.social_media_id AS social_media_id_9
FROM
  site_social_media t0
WHERE
  t0.site_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.position AS position_4, t0.hidden AS hidden_5, t0.id AS id_6, t0.url AS url_7, t0.site_id AS site_id_8, t0.social_media_id AS social_media_id_9 FROM site_social_media t0 WHERE t0.site_id = 2 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1272)
9	__TwigTemplate_961056bb6676da07ce6940d53aaf82d9::doDisplay (line 106)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_39928d8dc55ffded8716cb2222b379de->doDisplay (line 129)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Koredge\ContentBundle\Service\SiteService->handleRequest (line 57)
20	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.66 ms
(1.87%)

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.position AS position_4, t0.hidden AS hidden_5, t0.id AS id_6, t0.enabled AS enabled_7, t0.parameters AS parameters_8, t0.content AS content_9, t0.builder_layout_id AS builder_layout_id_10, t0.builder_data_id AS builder_data_id_11 FROM builder_section t0 WHERE t0.builder_data_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC

Parameters:

[
  24
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.position AS position_4,
  t0.hidden AS hidden_5,
  t0.id AS id_6,
  t0.enabled AS enabled_7,
  t0.parameters AS parameters_8,
  t0.content AS content_9,
  t0.builder_layout_id AS builder_layout_id_10,
  t0.builder_data_id AS builder_data_id_11
FROM
  builder_section t0
WHERE
  t0.builder_data_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.position ASC

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.position AS position_4, t0.hidden AS hidden_5, t0.id AS id_6, t0.enabled AS enabled_7, t0.parameters AS parameters_8, t0.content AS content_9, t0.builder_layout_id AS builder_layout_id_10, t0.builder_data_id AS builder_data_id_11 FROM builder_section t0 WHERE t0.builder_data_id = 24 AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	Koredge\BuilderBundle\Orm\Entity\BuilderData->getBuilderSections (line 37)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099::block_body (line 430)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_39928d8dc55ffded8716cb2222b379de->doDisplay (line 121)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Koredge\ContentBundle\Service\SiteService->handleRequest (line 57)
20	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.64 ms
(1.81%)

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.position AS position_4, t0.hidden AS hidden_5, t0.id AS id_6, t0.name AS name_7, t0.code AS code_8, t0.enabled AS enabled_9 FROM core.language t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.position AS position_4,
  t0.hidden AS hidden_5,
  t0.id AS id_6,
  t0.name AS name_7,
  t0.code AS code_8,
  t0.enabled AS enabled_9
FROM
  core.language t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.position AS position_4, t0.hidden AS hidden_5, t0.id AS id_6, t0.name AS name_7, t0.code AS code_8, t0.enabled AS enabled_9 FROM core.language t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():288} (line 289)
4	Proxies\__CG__\Koredge\CoreBundle\Orm\Entity\Language::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():365}:366} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Koredge\CoreBundle\Orm\Entity\Language->__get (line 153)
7	Koredge\CoreBundle\Orm\Entity\Language->getCode (line 66)
8	Koredge\ContentBundle\Orm\MappedSuperclass\Translation->getTranslation (line 83)
9	Koredge\ContentBundle\Service\SiteService->handleRequest (line 48)
10	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 182)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	require_once (line 5)

0.52 ms
(1.45%)

SELECT t0.id AS id_1, t0.id AS id_2 FROM gallery_site_extension t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.id AS id_2
FROM
  gallery_site_extension t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id AS id_2 FROM gallery_site_extension t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Koredge\GalleryBundle\Repository\Site\SiteRepository->findForBaseSite (line 28)
7	Koredge\GalleryBundle\EventListener\Site\SiteListener->postLoad (line 27)
8	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
9	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
10	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
11	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3203)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 177)
14	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
15	Doctrine\ORM\AbstractQuery->execute (line 886)
16	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
17	Koredge\SiteBundle\Repository\SiteRepository->findOneByDomain (line 27)
18	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 81)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.47 ms
(1.31%)

SELECT t0.id AS id_1, t0.id AS id_2 FROM team_site_extension t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.id AS id_2
FROM
  team_site_extension t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id AS id_2 FROM team_site_extension t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Koredge\TeamBundle\Repository\Site\SiteRepository->findForBaseSite (line 28)
7	Koredge\TeamBundle\EventListener\Site\SiteListener->postLoad (line 27)
8	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
9	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
10	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
11	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3203)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 177)
14	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
15	Doctrine\ORM\AbstractQuery->execute (line 886)
16	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
17	Koredge\SiteBundle\Repository\SiteRepository->findOneByDomain (line 27)
18	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 81)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.46 ms
(1.31%)

SELECT t0.id AS id_1 FROM builder_data t0 WHERE t0.id = ?

Parameters:

[
  24
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1
FROM
  builder_data t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1 FROM builder_data t0 WHERE t0.id = 24;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():288} (line 289)
4	Proxies\__CG__\Koredge\BuilderBundle\Orm\Entity\BuilderData::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():365}:366} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Koredge\BuilderBundle\Orm\Entity\BuilderData->__get (line 153)
7	Koredge\BuilderBundle\Orm\Entity\BuilderData->getBuilderSections (line 37)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099::block_body (line 430)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_39928d8dc55ffded8716cb2222b379de->doDisplay (line 121)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_c0e92db7baaab90d4058fdf659d2d099->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Koredge\ContentBundle\Service\SiteService->handleRequest (line 57)
20	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.43 ms
(1.20%)

SELECT t0.id AS id_1, t0.id AS id_2 FROM faq_site_extension t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.id AS id_2
FROM
  faq_site_extension t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id AS id_2 FROM faq_site_extension t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Koredge\FaqBundle\Repository\Site\SiteRepository->findForBaseSite (line 28)
7	Koredge\FaqBundle\EventListener\Site\SiteListener->postLoad (line 27)
8	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
9	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
10	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
11	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3203)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 177)
14	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
15	Doctrine\ORM\AbstractQuery->execute (line 886)
16	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
17	Koredge\SiteBundle\Repository\SiteRepository->findOneByDomain (line 27)
18	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 81)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	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
Koredge\ContentBundle\Orm\Entity\Page	21
Koredge\ContentBundle\Orm\Entity\Translations\PageTranslation	20
Koredge\BuilderBundle\Orm\Entity\BuilderData	20
Koredge\BuilderBundle\Orm\Entity\BuilderBlock	9
Koredge\BuilderBundle\Orm\Entity\BuilderSection	8
Koredge\ContentBundle\Orm\Entity\Translations\MenuItemTranslation	5
Koredge\BuilderBundle\Orm\Entity\BuilderBlockType	5
Koredge\ContentBundle\Orm\Entity\MenuZone	4
Koredge\ContentBundle\Orm\Entity\Menu	4
Koredge\ContentBundle\Orm\Entity\MenuItem	4
Koredge\SiteBundle\Orm\Entity\Site\Site	3
Koredge\ContentBundle\Orm\Entity\Type	3
Koredge\ContentBundle\Orm\Entity\Zone	2
Koredge\BuilderBundle\Orm\Entity\BuilderLayout	2
Koredge\SiteBundle\Orm\Entity\Site\SiteSocialMedia	2
Koredge\SiteBundle\Orm\Entity\Site\SocialMedia	2
Koredge\SiteBundle\Orm\Entity\Core\Language	1
Koredge\CoreBundle\Orm\Entity\License	1
Koredge\DocumentBundle\Orm\Entity\Site\Site	1
Koredge\GalleryBundle\Orm\Entity\Site\Site	1
Koredge\FaqBundle\Orm\Entity\Site\Site	1
Koredge\TeamBundle\Orm\Entity\Site\Site	1
Koredge\CoreBundle\Orm\Entity\Language	1
Koredge\SiteBundle\Orm\Entity\Site\SiteAddress	1
Koredge\ContentBundle\Orm\Entity\PageImage	1
Koredge\ContentBundle\Orm\Entity\PageImageType	1

Entities Mapping

Class	Mapping errors
Koredge\CoreBundle\Orm\Entity\Common	No errors.
Koredge\SiteBundle\Orm\Entity\Site\Site	No errors.
Koredge\SiteBundle\Orm\Entity\Core\Language	No errors.
Koredge\CoreBundle\Orm\Entity\License	No errors.
Koredge\SiteBundle\Orm\Entity\Site\SiteSocialMedia	No errors.
Koredge\SiteBundle\Orm\Entity\Common\Address	No errors.
Koredge\SiteBundle\Orm\Entity\Site\SiteAddress	No errors.
Koredge\ContentBundle\Orm\MappedSuperclass\Entity	No errors.
Koredge\ContentBundle\Orm\MappedSuperclass\Translation	No errors.
Koredge\ContentBundle\Orm\Entity\Module	No errors.
Koredge\ContentBundle\Orm\Entity\Page	The mappings Koredge\ContentBundle\Orm\Entity\Page#parent and Koredge\ContentBundle\Orm\Entity\Page#childrens are inconsistent with each other. The association Koredge\ContentBundle\Orm\Entity\Page#childrens refers to the owning side field Koredge\ContentBundle\Orm\Entity\Page#page which does not exist.
Koredge\SiteBundle\Orm\Entity\Site\Translations\SiteTranslation	No errors.
Koredge\DocumentBundle\Orm\Entity\Site\Site	No errors.
Koredge\DocumentBundle\Orm\Entity\Category	No errors.
Koredge\GalleryBundle\Orm\Entity\Site\Site	No errors.
Koredge\GalleryBundle\Orm\Entity\Album	No errors.
Koredge\FaqBundle\Orm\Entity\Site\Site	No errors.
Koredge\FaqBundle\Orm\Entity\Category	No errors.
Koredge\TeamBundle\Orm\Entity\Site\Site	No errors.
Koredge\TeamBundle\Orm\Entity\Category	No errors.
Koredge\ContentBundle\Orm\MappedSuperclass\ObjectTranslation	No errors.
Koredge\ContentBundle\Orm\Entity\Translations\PageTranslation	No errors.
Koredge\CoreBundle\Orm\Entity\Language	No errors.
Koredge\ContentBundle\Orm\Entity\Type	No errors.
Koredge\BuilderBundle\Orm\Entity\BuilderData	No errors.
Koredge\ContentBundle\Orm\Entity\PageImage	No errors.
Koredge\CoreBundle\Orm\Entity\CoreUser	No errors.
Koredge\ContentBundle\Orm\Entity\Zone	No errors.
Koredge\ContentBundle\Orm\Entity\MenuZone	No errors.
Koredge\ContentBundle\Orm\Entity\Menu	The association Koredge\ContentBundle\Orm\Entity\Menu#site refers to the inverse side field Koredge\SiteBundle\Orm\Entity\Site\Site#menus which does not exist.
Koredge\ContentBundle\Orm\Entity\MenuItem	No errors.
Koredge\ContentBundle\Orm\Entity\Translations\MenuTranslation	No errors.
Koredge\ContentBundle\Orm\Entity\Translations\MenuItemTranslation	No errors.
Koredge\ContentBundle\Orm\Entity\PageImageType	No errors.
Koredge\BuilderBundle\Orm\MappedSuperclass\Entity	No errors.
Koredge\BuilderBundle\Orm\Entity\BuilderCommon	No errors.
Koredge\BuilderBundle\Orm\Entity\BuilderSection	No errors.
Koredge\BuilderBundle\Orm\Entity\BuilderLayout	No errors.
Koredge\BuilderBundle\Orm\Entity\BuilderBlock	No errors.
Koredge\BuilderBundle\Orm\Entity\BuilderBlockType	No errors.
Koredge\BuilderBundle\Orm\Entity\Translations\BuilderBlockTypeTranslation	No errors.
Koredge\SiteBundle\Orm\Entity\Site\SocialMedia	No errors.

Symfony Profiler

GET http://preprod.olivier-ciappuccini-osteopathe.fr/formations

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping