Symfony Profiler

Query Metrics

36 Database Queries

21 Different statements

17.50 ms Query time

2 Invalid entities

48 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.87 ms
(10.70%)

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:

[
  20
]

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 = 20 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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Koredge\ContentBundle\Orm\MappedSuperclass\Translation->getTranslation (line 82)
8	Koredge\ContentBundle\Orm\Entity\Page->getRoute (line 231)
9	Twig\Extension\CoreExtension->getAttribute (line 1919)
10	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c::{closure:__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c::macro_render():327} (line 342)
11	Twig\Extension\CoreExtension->captureOutput (line 2116)
12	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c::macro_render (line 327)
13	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c->doDisplay (line 123)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_dd7a0595bee6c5fdd5ecd4a0daf09601->doDisplay (line 164)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_befc58283d6f27b0631504ed12891cd0->doDisplay (line 64)
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->handleHome (line 228)
24	Koredge\ContentBundle\Service\SiteService->handleRequest (line 45)
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 129)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 193)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 32)
35	require_once (line 5)

1.59 ms
(9.09%)

SELECT s0_.deleted_at AS deleted_at_0, s0_.hidden AS hidden_1, s0_.position AS position_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_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_.map_embed AS map_embed_17, s0_.meta_title AS meta_title_18, s0_.meta_description AS meta_description_19, s0_.theme_slug AS theme_slug_20, s0_.custom_css AS custom_css_21, s0_.enabled AS enabled_22, s0_.created_by_id AS created_by_id_23, s0_.updated_by_id AS updated_by_id_24, s0_.default_language_id AS default_language_id_25, s0_.license_id AS license_id_26 FROM site s0_ WHERE (s0_.domain = ?) AND (s0_.deleted_at IS NULL)

Parameters:

[
  "preprod.scieriedugroschene.fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.deleted_at AS deleted_at_0,
  s0_.hidden AS hidden_1,
  s0_.position AS position_2,
  s0_.created_at AS created_at_3,
  s0_.updated_at AS updated_at_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_.map_embed AS map_embed_17,
  s0_.meta_title AS meta_title_18,
  s0_.meta_description AS meta_description_19,
  s0_.theme_slug AS theme_slug_20,
  s0_.custom_css AS custom_css_21,
  s0_.enabled AS enabled_22,
  s0_.created_by_id AS created_by_id_23,
  s0_.updated_by_id AS updated_by_id_24,
  s0_.default_language_id AS default_language_id_25,
  s0_.license_id AS license_id_26
FROM
  site s0_
WHERE
  (s0_.domain = ?)
  AND (s0_.deleted_at IS NULL)

SELECT s0_.deleted_at AS deleted_at_0, s0_.hidden AS hidden_1, s0_.position AS position_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_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_.map_embed AS map_embed_17, s0_.meta_title AS meta_title_18, s0_.meta_description AS meta_description_19, s0_.theme_slug AS theme_slug_20, s0_.custom_css AS custom_css_21, s0_.enabled AS enabled_22, s0_.created_by_id AS created_by_id_23, s0_.updated_by_id AS updated_by_id_24, s0_.default_language_id AS default_language_id_25, s0_.license_id AS license_id_26 FROM site s0_ WHERE (s0_.domain = 'preprod.scieriedugroschene.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 129)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

1.42 ms
(8.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.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:

[
  13
]

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 = 13 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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
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 1919)
11	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c::{closure:__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c::macro_render():327} (line 514)
12	Twig\Extension\CoreExtension->captureOutput (line 2116)
13	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c::macro_render (line 327)
14	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c->doDisplay (line 123)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_dd7a0595bee6c5fdd5ecd4a0daf09601->doDisplay (line 164)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_befc58283d6f27b0631504ed12891cd0->doDisplay (line 64)
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->handleHome (line 228)
25	Koredge\ContentBundle\Service\SiteService->handleRequest (line 45)
26	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 193)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 32)
36	require_once (line 5)

1.36 ms
(7.76%)

SELECT DISTINCT id_0, MIN(sclr_10) AS dctrn_minrownum FROM (SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.deleted_at AS deleted_at_3, p0_.position AS position_4, p0_.hidden AS hidden_5, p0_.enabled AS enabled_6, p0_.tree_left AS tree_left_7, p0_.tree_right AS tree_right_8, p0_.tree_level AS tree_level_9, ROW_NUMBER() OVER(ORDER BY p0_.id DESC) AS sclr_10 FROM page p0_ INNER JOIN page_module p2_ ON p0_.id = p2_.page_id INNER JOIN module m1_ ON m1_.id = p2_.module_id AND (m1_.deleted_at IS NULL) WHERE (m1_.id = ?) AND (p0_.deleted_at IS NULL)) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 3

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0,
  MIN(sclr_10) AS dctrn_minrownum
FROM
  (
    SELECT
      p0_.id AS id_0,
      p0_.created_at AS created_at_1,
      p0_.updated_at AS updated_at_2,
      p0_.deleted_at AS deleted_at_3,
      p0_.position AS position_4,
      p0_.hidden AS hidden_5,
      p0_.enabled AS enabled_6,
      p0_.tree_left AS tree_left_7,
      p0_.tree_right AS tree_right_8,
      p0_.tree_level AS tree_level_9,
      ROW_NUMBER() OVER(
        ORDER BY
          p0_.id DESC
      ) AS sclr_10
    FROM
      page p0_
      INNER JOIN page_module p2_ ON p0_.id = p2_.page_id
      INNER JOIN module m1_ ON m1_.id = p2_.module_id
      AND (m1_.deleted_at IS NULL)
    WHERE
      (m1_.id = ?)
      AND (p0_.deleted_at IS NULL)
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  3

SELECT DISTINCT id_0, MIN(sclr_10) AS dctrn_minrownum FROM (SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.deleted_at AS deleted_at_3, p0_.position AS position_4, p0_.hidden AS hidden_5, p0_.enabled AS enabled_6, p0_.tree_left AS tree_left_7, p0_.tree_right AS tree_right_8, p0_.tree_level AS tree_level_9, ROW_NUMBER() OVER(ORDER BY p0_.id DESC) AS sclr_10 FROM page p0_ INNER JOIN page_module p2_ ON p0_.id = p2_.page_id INNER JOIN module m1_ ON m1_.id = p2_.module_id AND (m1_.deleted_at IS NULL) WHERE (m1_.id = 1) AND (p0_.deleted_at IS NULL)) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 3;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 57)
8	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 260)
9	Pagerfanta\Pagerfanta->getCurrentPageResults (line 249)
10	Koredge\ContentBundle\Service\SiteService->handleHome (line 222)
11	Koredge\ContentBundle\Service\SiteService->handleRequest (line 45)
12	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
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)

1.35 ms
(7.69%)

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:

[
  13
]

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 = 13 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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->testEmpty (line 1423)
9	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c::{closure:__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c::macro_isChildActive():264} (line 273)
10	Twig\Extension\CoreExtension->captureOutput (line 2116)
11	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c::macro_isChildActive (line 264)
12	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c->{closure:__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c::macro_render():327} (line 387)
13	Twig\Extension\CoreExtension->captureOutput (line 2116)
14	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c::macro_render (line 327)
15	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c->doDisplay (line 123)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_dd7a0595bee6c5fdd5ecd4a0daf09601->doDisplay (line 164)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_befc58283d6f27b0631504ed12891cd0->doDisplay (line 64)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Koredge\ContentBundle\Service\SiteService->handleHome (line 228)
26	Koredge\ContentBundle\Service\SiteService->handleRequest (line 45)
27	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
28	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
29	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
30	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
31	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 193)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 32)
37	require_once (line 5)

1.23 ms
(7.03%)

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.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  20
]

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.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.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.id = 20 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\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->getMenuItem (line 167)
7	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c->{closure:__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c::macro_render():327} (line 336)
8	Twig\Extension\CoreExtension->captureOutput (line 2116)
9	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c::macro_render (line 327)
10	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c->doDisplay (line 123)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_dd7a0595bee6c5fdd5ecd4a0daf09601->doDisplay (line 164)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_befc58283d6f27b0631504ed12891cd0->doDisplay (line 64)
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->handleHome (line 228)
21	Koredge\ContentBundle\Service\SiteService->handleRequest (line 45)
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 129)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

1.06 ms
(6.03%)

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::getProxy():217} (line 223)
4	Koredge\ContentBundle\Orm\Entity\Menu::getSite (line 114)
5	Koredge\ContentBundle\Twig\CmsExtension->{closure:Koredge\ContentBundle\Twig\CmsExtension::getMenusFromZone():146} (line 147)
6	array_filter (line 380)
7	Doctrine\Common\Collections\ArrayCollection::filter (line 380)
8	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 241)
9	Koredge\ContentBundle\Twig\CmsExtension->getMenusFromZone (line 146)
10	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c->doDisplay (line 48)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_dd7a0595bee6c5fdd5ecd4a0daf09601->doDisplay (line 164)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_befc58283d6f27b0631504ed12891cd0->doDisplay (line 64)
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->handleHome (line 228)
21	Koredge\ContentBundle\Service\SiteService->handleRequest (line 45)
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 129)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

0.74 ms
(4.24%)

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_4067e2ac3179d6001e8c3d5453f0a51c->doDisplay (line 48)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_dd7a0595bee6c5fdd5ecd4a0daf09601->doDisplay (line 164)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_befc58283d6f27b0631504ed12891cd0->doDisplay (line 64)
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->handleHome (line 228)
18	Koredge\ContentBundle\Service\SiteService->handleRequest (line 45)
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 129)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

0.67 ms
(3.85%)

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:

[
  5
]

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 = 5 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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c->doDisplay (line 117)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_dd7a0595bee6c5fdd5ecd4a0daf09601->doDisplay (line 164)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_befc58283d6f27b0631504ed12891cd0->doDisplay (line 64)
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->handleHome (line 228)
18	Koredge\ContentBundle\Service\SiteService->handleRequest (line 45)
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 129)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

0.63 ms
(3.62%)

SELECT t0.deleted_at AS deleted_at_1, t0.hidden AS hidden_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_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.created_by_id AS created_by_id_21, t0.updated_by_id AS updated_by_id_22, t0.site_id AS site_id_23 FROM site_address t0 WHERE t0.site_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.hidden AS hidden_2,
  t0.position AS position_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_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.created_by_id AS created_by_id_21,
  t0.updated_by_id AS updated_by_id_22,
  t0.site_id AS site_id_23
FROM
  site_address t0
WHERE
  t0.site_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.hidden AS hidden_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_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.created_by_id AS created_by_id_21, t0.updated_by_id AS updated_by_id_22, t0.site_id AS site_id_23 FROM site_address t0 WHERE t0.site_id = 4 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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 110)
7	Doctrine\ORM\PersistentCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->offsetExists (line 420)
9	Twig\Extension\CoreExtension->getAttribute (line 1704)
10	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c::doDisplay (line 149)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_dd7a0595bee6c5fdd5ecd4a0daf09601->doDisplay (line 164)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_befc58283d6f27b0631504ed12891cd0->doDisplay (line 64)
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->handleHome (line 228)
21	Koredge\ContentBundle\Service\SiteService->handleRequest (line 45)
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 129)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

0.59 ms
(3.37%)

SELECT t0.deleted_at AS deleted_at_1, t0.hidden AS hidden_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.cover AS cover_6, t0.date AS date_7, t0.description AS description_8, t0.id AS id_9, t0.name AS name_10, t0.enabled AS enabled_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.site_id AS site_id_14, t0.parent_id AS parent_id_15 FROM album t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.hidden AS hidden_2,
  t0.position AS position_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.cover AS cover_6,
  t0.date AS date_7,
  t0.description AS description_8,
  t0.id AS id_9,
  t0.name AS name_10,
  t0.enabled AS enabled_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13,
  t0.site_id AS site_id_14,
  t0.parent_id AS parent_id_15
FROM
  album t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.hidden AS hidden_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.cover AS cover_6, t0.date AS date_7, t0.description AS description_8, t0.id AS id_9, t0.name AS name_10, t0.enabled AS enabled_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.site_id AS site_id_14, t0.parent_id AS parent_id_15 FROM album t0 WHERE t0.id = 2 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\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Koredge\GalleryBundle\Twig\GalleryExtension->getAlbumById (line 44)
7	__TwigTemplate_d24912014a5744d1f826c36077755313->doDisplay (line 48)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_befc58283d6f27b0631504ed12891cd0->block_body (line 359)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_dd7a0595bee6c5fdd5ecd4a0daf09601->doDisplay (line 170)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_befc58283d6f27b0631504ed12891cd0->doDisplay (line 64)
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->handleHome (line 228)
20	Koredge\ContentBundle\Service\SiteService->handleRequest (line 45)
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 129)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.54 ms
(3.10%)

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.upload_path AS upload_path_8, t0.code AS code_9 FROM module t0 WHERE t0.code = ? AND ((t0.deleted_at IS NULL)) LIMIT 1

Parameters:

[
  "news"
]

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.upload_path AS upload_path_8,
  t0.code AS code_9
FROM
  module t0
WHERE
  t0.code = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

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.upload_path AS upload_path_8, t0.code AS code_9 FROM module t0 WHERE t0.code = 'news' AND ((t0.deleted_at IS NULL)) LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Koredge\ContentBundle\Service\NewsService->getNewsModule (line 71)
5	Koredge\ContentBundle\Service\NewsService->handleNewsHomeRequest (line 47)
6	Koredge\ContentBundle\Service\SiteService->handleHome (line 217)
7	Koredge\ContentBundle\Service\SiteService->handleRequest (line 45)
8	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	require_once (line 5)

0.54 ms
(3.10%)

SELECT t0.deleted_at AS deleted_at_1, t0.hidden AS hidden_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.name AS name_7, t0.code AS code_8, t0.enabled AS enabled_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 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.deleted_at AS deleted_at_1,
  t0.hidden AS hidden_2,
  t0.position AS position_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6,
  t0.name AS name_7,
  t0.code AS code_8,
  t0.enabled AS enabled_9,
  t0.created_by_id AS created_by_id_10,
  t0.updated_by_id AS updated_by_id_11
FROM
  core.language t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.hidden AS hidden_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.name AS name_7, t0.code AS code_8, t0.enabled AS enabled_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 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::getProxy():217} (line 223)
4	Koredge\CoreBundle\Orm\Entity\Language::getCode (line 66)
5	Koredge\ContentBundle\Orm\MappedSuperclass\Translation->getTranslation (line 83)
6	Koredge\ContentBundle\Orm\Entity\Page->getRoute (line 231)
7	Twig\Extension\CoreExtension->getAttribute (line 1919)
8	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c::{closure:__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c::macro_render():327} (line 342)
9	Twig\Extension\CoreExtension->captureOutput (line 2116)
10	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c::macro_render (line 327)
11	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c->doDisplay (line 123)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_dd7a0595bee6c5fdd5ecd4a0daf09601->doDisplay (line 164)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_befc58283d6f27b0631504ed12891cd0->doDisplay (line 64)
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->handleHome (line 228)
22	Koredge\ContentBundle\Service\SiteService->handleRequest (line 45)
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 129)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 193)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 5)

0.54 ms
(3.10%)

SELECT t0.deleted_at AS deleted_at_1, t0.hidden AS hidden_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.alt AS alt_6, t0.file AS file_7, t0.id AS id_8, t0.enabled AS enabled_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.album_id AS album_id_12, t0.site_id AS site_id_13 FROM picture t0 WHERE t0.album_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.hidden AS hidden_2,
  t0.position AS position_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.alt AS alt_6,
  t0.file AS file_7,
  t0.id AS id_8,
  t0.enabled AS enabled_9,
  t0.created_by_id AS created_by_id_10,
  t0.updated_by_id AS updated_by_id_11,
  t0.album_id AS album_id_12,
  t0.site_id AS site_id_13
FROM
  picture t0
WHERE
  t0.album_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.hidden AS hidden_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.alt AS alt_6, t0.file AS file_7, t0.id AS id_8, t0.enabled AS enabled_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.album_id AS album_id_12, t0.site_id AS site_id_13 FROM picture t0 WHERE t0.album_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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	__TwigTemplate_d24912014a5744d1f826c36077755313->doDisplay (line 64)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_befc58283d6f27b0631504ed12891cd0->block_body (line 359)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_dd7a0595bee6c5fdd5ecd4a0daf09601->doDisplay (line 170)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_befc58283d6f27b0631504ed12891cd0->doDisplay (line 64)
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->handleHome (line 228)
20	Koredge\ContentBundle\Service\SiteService->handleRequest (line 45)
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 129)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.54 ms
(3.06%)

SELECT t0.deleted_at AS deleted_at_1, t0.hidden AS hidden_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.url AS url_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.site_id AS site_id_10, t0.social_media_id AS social_media_id_11 FROM site_social_media t0 WHERE t0.site_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.hidden AS hidden_2,
  t0.position AS position_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6,
  t0.url AS url_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.site_id AS site_id_10,
  t0.social_media_id AS social_media_id_11
FROM
  site_social_media t0
WHERE
  t0.site_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.hidden AS hidden_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.url AS url_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.site_id AS site_id_10, t0.social_media_id AS social_media_id_11 FROM site_social_media t0 WHERE t0.site_id = 4 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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 110)
7	Doctrine\ORM\PersistentCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->offsetExists (line 420)
9	Twig\Extension\CoreExtension->getAttribute (line 1704)
10	__TwigTemplate_be1312821093734b59325251c36bbbcc::doDisplay (line 111)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_dd7a0595bee6c5fdd5ecd4a0daf09601->doDisplay (line 177)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_befc58283d6f27b0631504ed12891cd0->doDisplay (line 64)
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->handleHome (line 228)
21	Koredge\ContentBundle\Service\SiteService->handleRequest (line 45)
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 129)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

0.53 ms
(3.05%)

SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.deleted_at AS deleted_at_3, p0_.position AS position_4, p0_.hidden AS hidden_5, p0_.enabled AS enabled_6, p0_.tree_left AS tree_left_7, p0_.tree_right AS tree_right_8, p0_.tree_level AS tree_level_9, p0_.parent_id AS parent_id_10, p0_.site_id AS site_id_11, p0_.root_id AS root_id_12 FROM page p0_ INNER JOIN page_module p2_ ON p0_.id = p2_.page_id INNER JOIN module m1_ ON m1_.id = p2_.module_id AND (m1_.deleted_at IS NULL) WHERE (m1_.id = ? AND p0_.id IN (?)) AND (p0_.deleted_at IS NULL) ORDER BY p0_.id DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.created_at AS created_at_1,
  p0_.updated_at AS updated_at_2,
  p0_.deleted_at AS deleted_at_3,
  p0_.position AS position_4,
  p0_.hidden AS hidden_5,
  p0_.enabled AS enabled_6,
  p0_.tree_left AS tree_left_7,
  p0_.tree_right AS tree_right_8,
  p0_.tree_level AS tree_level_9,
  p0_.parent_id AS parent_id_10,
  p0_.site_id AS site_id_11,
  p0_.root_id AS root_id_12
FROM
  page p0_
  INNER JOIN page_module p2_ ON p0_.id = p2_.page_id
  INNER JOIN module m1_ ON m1_.id = p2_.module_id
  AND (m1_.deleted_at IS NULL)
WHERE
  (
    m1_.id = ?
    AND p0_.id IN (?)
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.deleted_at AS deleted_at_3, p0_.position AS position_4, p0_.hidden AS hidden_5, p0_.enabled AS enabled_6, p0_.tree_left AS tree_left_7, p0_.tree_right AS tree_right_8, p0_.tree_level AS tree_level_9, p0_.parent_id AS parent_id_10, p0_.site_id AS site_id_11, p0_.root_id AS root_id_12 FROM page p0_ INNER JOIN page_module p2_ ON p0_.id = p2_.page_id INNER JOIN module m1_ ON m1_.id = p2_.module_id AND (m1_.deleted_at IS NULL) WHERE (m1_.id = 1 AND p0_.id IN (9)) AND (p0_.deleted_at IS NULL) ORDER BY p0_.id DESC;

#	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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 57)
8	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 260)
9	Pagerfanta\Pagerfanta->getCurrentPageResults (line 249)
10	Koredge\ContentBundle\Service\SiteService->handleHome (line 222)
11	Koredge\ContentBundle\Service\SiteService->handleRequest (line 45)
12	Koredge\SiteBundle\EventListener\SiteContextListener->onKernelRequest (line 105)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
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.52 ms
(2.95%)

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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 239)
7	Koredge\ContentBundle\Twig\CmsExtension->getMenusFromZone (line 146)
8	__TwigTemplate_4067e2ac3179d6001e8c3d5453f0a51c->doDisplay (line 48)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_dd7a0595bee6c5fdd5ecd4a0daf09601->doDisplay (line 164)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_befc58283d6f27b0631504ed12891cd0->doDisplay (line 64)
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->handleHome (line 228)
19	Koredge\ContentBundle\Service\SiteService->handleRequest (line 45)
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 129)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

0.48 ms
(2.75%)

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

Parameters:

[
  4
]

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 = 4;

#	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 3210)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
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 129)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.46 ms
(2.64%)

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

Parameters:

[
  4
]

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 = 4;

#	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 3210)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
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 129)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.45 ms
(2.56%)

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

Parameters:

[
  4
]

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 = 4;

#	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 3210)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
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 129)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.39 ms
(2.21%)

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

Parameters:

[
  4
]

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 = 4;

#	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 3210)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
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 129)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
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	5
Koredge\GalleryBundle\Orm\Entity\Picture	5
Koredge\ContentBundle\Orm\Entity\MenuItem	4
Koredge\ContentBundle\Orm\Entity\Translations\PageTranslation	4
Koredge\BuilderBundle\Orm\Entity\BuilderData	4
Koredge\ContentBundle\Orm\Entity\Translations\MenuItemTranslation	4
Koredge\SiteBundle\Orm\Entity\Site\Site	3
Koredge\ContentBundle\Orm\Entity\MenuZone	3
Koredge\ContentBundle\Orm\Entity\Menu	3
Koredge\ContentBundle\Orm\Entity\Type	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\ContentBundle\Orm\Entity\Module	1
Koredge\ContentBundle\Orm\Entity\Zone	1
Koredge\CoreBundle\Orm\Entity\Language	1
Koredge\SiteBundle\Orm\Entity\Site\SiteAddress	1
Koredge\GalleryBundle\Orm\Entity\Album	1

Entities Mapping

Class	Mapping errors
Koredge\CoreBundle\Orm\Entity\Common	No errors.
Koredge\SiteBundle\Orm\Entity\Site\Site	No errors.
Koredge\CoreBundle\Orm\Entity\CoreUser	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\ModuleTranslation	No errors.
Koredge\ContentBundle\Orm\Entity\Translations\PageTranslation	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\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\GalleryBundle\Orm\Entity\Picture	No errors.
Koredge\GalleryBundle\Orm\Entity\Translations\AlbumTranslation	No errors.
Koredge\GalleryBundle\Orm\Entity\Translations\PictureTranslation	No errors.
Koredge\SiteBundle\Orm\Entity\Site\SocialMedia	No errors.

Symfony Profiler

GET http://preprod.scieriedugroschene.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping