Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.55 ms Query time

0 Invalid entities

120 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.52 ms

SELECT k0_.locale AS locale_0, k0_.domain AS domain_1 FROM kuma_translation k0_ GROUP BY k0_.locale, k0_.domain

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  k0_.locale AS locale_0,
  k0_.domain AS domain_1
FROM
  kuma_translation k0_
GROUP BY
  k0_.locale,
  k0_.domain

SELECT k0_.locale AS locale_0, k0_.domain AS domain_1 FROM kuma_translation k0_ GROUP BY k0_.locale, k0_.domain;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 918)
6	Kunstmaan\TranslatorBundle\Repository\TranslationRepository->getAllDomainsByLocale (line 25)
7	Kunstmaan\TranslatorBundle\Service\Translator\Translator->addResourcesFromDatabaseAndCacheThem (line 93)
8	Kunstmaan\TranslatorBundle\Service\Translator\Translator->addDatabaseResources (line 60)
9	ContainerBnUFf9h\App_KernelDevDebugContainer->getTranslator_DefaultService (line 1987)
10	ContainerBnUFf9h\App_KernelDevDebugContainer::getTranslatorService (line 1693)
11	ContainerBnUFf9h\App_KernelDevDebugContainer::getKunstmaanAdmin_AdminLocale_ListenerService (line 2550)
12	ContainerBnUFf9h\App_KernelDevDebugContainer::{closure:ContainerBnUFf9h\App_KernelDevDebugContainer::getEventDispatcherService():1222} (line 1222)
13	Symfony\Component\EventDispatcher\EventDispatcher::sortListeners (line 235)
14	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 70)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 276)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 133)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 208)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.35 ms

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DATABASE()

SELECT DATABASE();

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 627)
2	Doctrine\DBAL\Connection->getDatabase (line 267)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->getSchemaSearchPaths (line 1721)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->createSchemaConfig (line 1678)
5	Symfony\Component\Security\Acl\Dbal\Schema->createSchemaConfig (line 170)
6	Symfony\Component\Security\Acl\Dbal\Schema->__construct (line 34)
7	ContainerBnUFf9h\getSecurity_Acl_Dbal_SchemaService->do (line 31)
8	ContainerBnUFf9h\App_KernelDevDebugContainer::load (line 834)
9	ContainerBnUFf9h\getSecurity_Acl_Dbal_SchemaListenerService->do (line 23)
10	ContainerBnUFf9h\App_KernelDevDebugContainer::load (line 834)
11	Symfony\Component\DependencyInjection\Container->getService (line 404)
12	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 40)
13	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 181)
14	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 92)
15	Gedmo\Tree\Entity\Repository\AbstractTreeRepository->__construct (line 53)
16	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getOrCreateRepository (line 116)
17	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->doGetRepository (line 93)
18	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository (line 40)
19	Doctrine\ORM\EntityManager->getRepository (line 839)
20	Kunstmaan\NodeBundle\Helper\NodeMenu->init (line 178)
21	Kunstmaan\NodeBundle\Helper\NodeMenu->getTopNodes (line 211)
22	Twig\Extension\CoreExtension->getAttribute (line 1919)
23	__TwigTemplate_a04b48be567c6823b61257675759d7ad::doDisplay (line 56)
24	Twig\Template->yield (line 402)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
32	Kunstmaan\SitemapBundle\Controller\SitemapController->sitemapAction (line 48)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 208)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 29)
38	require_once (line 5)

1.68 ms

SELECT k0_.lft AS lft_0, k0_.lvl AS lvl_1, k0_.rgt AS rgt_2, k0_.deleted AS deleted_3, k0_.hidden_from_nav AS hidden_from_nav_4, k0_.ref_entity_name AS ref_entity_name_5, k0_.internal_name AS internal_name_6, k0_.id AS id_7, k1_.lang AS lang_8, k1_.online AS online_9, k1_.title AS title_10, k1_.slug AS slug_11, k1_.url AS url_12, k1_.weight AS weight_13, k1_.created AS created_14, k1_.updated AS updated_15, k1_.id AS id_16, k2_.type AS type_17, k2_.owner AS owner_18, k2_.created AS created_19, k2_.updated AS updated_20, k2_.ref_id AS ref_id_21, k2_.ref_entity_name AS ref_entity_name_22, k2_.id AS id_23, k0_.parent_id AS parent_id_24, k1_.node_id AS node_id_25, k1_.public_node_version_id AS public_node_version_id_26, k2_.node_translation_id AS node_translation_id_27, k2_.origin_id AS origin_id_28 FROM kuma_nodes k0_ LEFT JOIN kuma_node_translations k1_ ON k0_.id = k1_.node_id AND (k1_.lang = ?) LEFT JOIN kuma_node_versions k2_ ON k1_.public_node_version_id = k2_.id AND (k1_.public_node_version_id = k2_.id) WHERE k0_.deleted = ? ORDER BY k1_.weight ASC, k1_.title ASC

Parameters:

[
  "fr"
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  k0_.lft AS lft_0,
  k0_.lvl AS lvl_1,
  k0_.rgt AS rgt_2,
  k0_.deleted AS deleted_3,
  k0_.hidden_from_nav AS hidden_from_nav_4,
  k0_.ref_entity_name AS ref_entity_name_5,
  k0_.internal_name AS internal_name_6,
  k0_.id AS id_7,
  k1_.lang AS lang_8,
  k1_.online AS online_9,
  k1_.title AS title_10,
  k1_.slug AS slug_11,
  k1_.url AS url_12,
  k1_.weight AS weight_13,
  k1_.created AS created_14,
  k1_.updated AS updated_15,
  k1_.id AS id_16,
  k2_.type AS type_17,
  k2_.owner AS owner_18,
  k2_.created AS created_19,
  k2_.updated AS updated_20,
  k2_.ref_id AS ref_id_21,
  k2_.ref_entity_name AS ref_entity_name_22,
  k2_.id AS id_23,
  k0_.parent_id AS parent_id_24,
  k1_.node_id AS node_id_25,
  k1_.public_node_version_id AS public_node_version_id_26,
  k2_.node_translation_id AS node_translation_id_27,
  k2_.origin_id AS origin_id_28
FROM
  kuma_nodes k0_
  LEFT JOIN kuma_node_translations k1_ ON k0_.id = k1_.node_id
  AND (k1_.lang = ?)
  LEFT JOIN kuma_node_versions k2_ ON k1_.public_node_version_id = k2_.id
  AND (
    k1_.public_node_version_id = k2_.id
  )
WHERE
  k0_.deleted = ?
ORDER BY
  k1_.weight ASC,
  k1_.title ASC

SELECT k0_.lft AS lft_0, k0_.lvl AS lvl_1, k0_.rgt AS rgt_2, k0_.deleted AS deleted_3, k0_.hidden_from_nav AS hidden_from_nav_4, k0_.ref_entity_name AS ref_entity_name_5, k0_.internal_name AS internal_name_6, k0_.id AS id_7, k1_.lang AS lang_8, k1_.online AS online_9, k1_.title AS title_10, k1_.slug AS slug_11, k1_.url AS url_12, k1_.weight AS weight_13, k1_.created AS created_14, k1_.updated AS updated_15, k1_.id AS id_16, k2_.type AS type_17, k2_.owner AS owner_18, k2_.created AS created_19, k2_.updated AS updated_20, k2_.ref_id AS ref_id_21, k2_.ref_entity_name AS ref_entity_name_22, k2_.id AS id_23, k0_.parent_id AS parent_id_24, k1_.node_id AS node_id_25, k1_.public_node_version_id AS public_node_version_id_26, k2_.node_translation_id AS node_translation_id_27, k2_.origin_id AS origin_id_28 FROM kuma_nodes k0_ LEFT JOIN kuma_node_translations k1_ ON k0_.id = k1_.node_id AND (k1_.lang = 'fr') LEFT JOIN kuma_node_versions k2_ ON k1_.public_node_version_id = k2_.id AND (k1_.public_node_version_id = k2_.id) WHERE k0_.deleted = 0 ORDER BY k1_.weight ASC, k1_.title ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	Kunstmaan\NodeBundle\Repository\NodeRepository->getChildNodes (line 113)
7	Kunstmaan\NodeBundle\Helper\NodeMenu->init (line 181)
8	Kunstmaan\NodeBundle\Helper\NodeMenu->getTopNodes (line 211)
9	Twig\Extension\CoreExtension->getAttribute (line 1919)
10	__TwigTemplate_a04b48be567c6823b61257675759d7ad::doDisplay (line 56)
11	Twig\Template->yield (line 402)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
19	Kunstmaan\SitemapBundle\Controller\SitemapController->sitemapAction (line 48)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 208)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	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
Kunstmaan\NodeBundle\Entity\NodeVersion	48
Kunstmaan\NodeBundle\Entity\Node	36
Kunstmaan\NodeBundle\Entity\NodeTranslation	36

Entities Mapping

Class	Mapping errors
Kunstmaan\RedirectBundle\Entity\Redirect	No errors.
Kunstmaan\TranslatorBundle\Entity\Translation	No errors.
Kunstmaan\PagePartBundle\Entity\PageTemplateConfiguration	No errors.
Kunstmaan\NodeBundle\Entity\Node	No errors.
Kunstmaan\NodeBundle\Entity\NodeTranslation	No errors.
Kunstmaan\NodeBundle\Entity\NodeVersion	No errors.

Symfony Profiler

GET https://www.stag.cciangazidja.com/sitemap-fr.xml

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping