Symfony Profiler

Query Metrics

33 Database Queries

20 Different statements

22.21 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.01 ms
(27.08%)

SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC

Parameters:

[
  "/cmf/sudcms/routes/en"
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/sudcms/routes/en') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 1268)
3	Jackalope\Transport\DoctrineDBAL\Client->getNodesData (line 1196)
4	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 189)
5	Jackalope\ObjectManager->getNodeByPath (line 228)
6	Jackalope\Session->getNode (line 78)
7	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
8	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 35)
9	Sulu\Component\PHPCR\SessionManager\SessionManager->getRouteNode (line 371)
10	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->getWebspaceRouteNode (line 244)
11	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 207)
12	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 153)
13	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 97)
14	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
15	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
16	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
17	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
18	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 105)
19	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 58)
20	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 116)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 71)

3.59 ms
(16.15%)

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="main"]) > 0')) AND n0.path LIKE '/cmf/sudcms/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC

Parameters:

[
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0.path AS n0_path,
  n0.identifier AS n0_identifier,
  n0.props AS n0_props
FROM
  phpcr_nodes n0
WHERE
  n0.workspace_name = ?
  AND n0.type IN ('nt:unstructured', 'rep:root')
  AND (
    (
      EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0'
      )
      OR EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0'
      )
    )
    AND (
      (
        (
          0 != FIND_IN_SET(
            '2',
            REPLACE(
              EXTRACTVALUE(
                n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'
              ),
              ' ',
              ','
            )
          )
          OR EXTRACTVALUE(
            n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]'
          ) = '1'
        )
        AND EXTRACTVALUE(
          n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="main"]) > 0'
        )
      )
      AND n0.path LIKE '/cmf/sudcms/contents/%'
    )
  )
ORDER BY
  CAST(
    EXTRACTVALUE(
      n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]'
    ) AS DECIMAL
  ) ASC,
  EXTRACTVALUE(
    n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]'
  ) ASC

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="main"]) > 0')) AND n0.path LIKE '/cmf/sudcms/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 54)
4	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 144)
5	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 82)
6	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->treeRootNavigationFunction (line 67)
7	Sulu\Component\Cache\Memoize->memoizeById (line 51)
8	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 48)
9	__TwigTemplate_1398d6ea03bd7f0175dfc3a704e1c381->doDisplay (line 388)
10	Twig\Template->yield (line 228)
11	__TwigTemplate_d554bcbcc673dcd2d3933da887638971->block_header (line 432)
12	Twig\Template->yieldBlock (line 477)
13	Twig\Template->yieldParentBlock (line 79)
14	__TwigTemplate_ab7d118df15182d70ff2f5c9b10b4091->block_header (line 432)
15	Twig\Template->yieldBlock (line 106)
16	__TwigTemplate_d554bcbcc673dcd2d3933da887638971->doDisplay (line 388)
17	Twig\Template->yield (line 55)
18	__TwigTemplate_ab7d118df15182d70ff2f5c9b10b4091->doDisplay (line 388)
19	Twig\Template->yield (line 344)
20	Twig\Template->display (line 359)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 334)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
26	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
27	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 71)

1.86 ms
(8.40%)

SELECT t0.id AS id_1, t0.animation_menu AS animation_menu_2, t0.type_menu AS type_menu_3, t0.activate_click_parent_page_menu AS activate_click_parent_page_menu_4, t0.nb_child_in_menu AS nb_child_in_menu_5, t0.display_logo_desktop AS display_logo_desktop_6, t0.display_logo_mobile AS display_logo_mobile_7, t0.display_name AS display_name_8, t0.display_social_media_in_navbar AS display_social_media_in_navbar_9, t0.created AS created_10, t0.changed AS changed_11, t0.navbar_background_color_id AS navbar_background_color_id_12, t0.background_color_id AS background_color_id_13, t0.second_background_color_id AS second_background_color_id_14, t0.third_background_color_id AS third_background_color_id_15, t0.divider_color_id AS divider_color_id_16, t0.text_color_id AS text_color_id_17, t0.second_text_color_id AS second_text_color_id_18, t0.text_background_hover_color_id AS text_background_hover_color_id_19, t0.second_text_background_hover_color_id AS second_text_background_hover_color_id_20, t0.text_hover_color_id AS text_hover_color_id_21, t0.second_text_hover_color_id AS second_text_hover_color_id_22, t0.burger_open_color_id AS burger_open_color_id_23, t0.burger_close_color_id AS burger_close_color_id_24, t0.social_media_color_id AS social_media_color_id_25, t0.social_media_color_hover_id AS social_media_color_hover_id_26, t0.social_media_color_background_id AS social_media_color_background_id_27, t0.image_id AS image_id_28, t0.idUsersCreator AS idUsersCreator_29, t0.idUsersChanger AS idUsersChanger_30 FROM sudcms_website_settings_menu t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.animation_menu AS animation_menu_2,
  t0.type_menu AS type_menu_3,
  t0.activate_click_parent_page_menu AS activate_click_parent_page_menu_4,
  t0.nb_child_in_menu AS nb_child_in_menu_5,
  t0.display_logo_desktop AS display_logo_desktop_6,
  t0.display_logo_mobile AS display_logo_mobile_7,
  t0.display_name AS display_name_8,
  t0.display_social_media_in_navbar AS display_social_media_in_navbar_9,
  t0.created AS created_10,
  t0.changed AS changed_11,
  t0.navbar_background_color_id AS navbar_background_color_id_12,
  t0.background_color_id AS background_color_id_13,
  t0.second_background_color_id AS second_background_color_id_14,
  t0.third_background_color_id AS third_background_color_id_15,
  t0.divider_color_id AS divider_color_id_16,
  t0.text_color_id AS text_color_id_17,
  t0.second_text_color_id AS second_text_color_id_18,
  t0.text_background_hover_color_id AS text_background_hover_color_id_19,
  t0.second_text_background_hover_color_id AS second_text_background_hover_color_id_20,
  t0.text_hover_color_id AS text_hover_color_id_21,
  t0.second_text_hover_color_id AS second_text_hover_color_id_22,
  t0.burger_open_color_id AS burger_open_color_id_23,
  t0.burger_close_color_id AS burger_close_color_id_24,
  t0.social_media_color_id AS social_media_color_id_25,
  t0.social_media_color_hover_id AS social_media_color_hover_id_26,
  t0.social_media_color_background_id AS social_media_color_background_id_27,
  t0.image_id AS image_id_28,
  t0.idUsersCreator AS idUsersCreator_29,
  t0.idUsersChanger AS idUsersChanger_30
FROM
  sudcms_website_settings_menu t0
LIMIT
  1

SELECT t0.id AS id_1, t0.animation_menu AS animation_menu_2, t0.type_menu AS type_menu_3, t0.activate_click_parent_page_menu AS activate_click_parent_page_menu_4, t0.nb_child_in_menu AS nb_child_in_menu_5, t0.display_logo_desktop AS display_logo_desktop_6, t0.display_logo_mobile AS display_logo_mobile_7, t0.display_name AS display_name_8, t0.display_social_media_in_navbar AS display_social_media_in_navbar_9, t0.created AS created_10, t0.changed AS changed_11, t0.navbar_background_color_id AS navbar_background_color_id_12, t0.background_color_id AS background_color_id_13, t0.second_background_color_id AS second_background_color_id_14, t0.third_background_color_id AS third_background_color_id_15, t0.divider_color_id AS divider_color_id_16, t0.text_color_id AS text_color_id_17, t0.second_text_color_id AS second_text_color_id_18, t0.text_background_hover_color_id AS text_background_hover_color_id_19, t0.second_text_background_hover_color_id AS second_text_background_hover_color_id_20, t0.text_hover_color_id AS text_hover_color_id_21, t0.second_text_hover_color_id AS second_text_hover_color_id_22, t0.burger_open_color_id AS burger_open_color_id_23, t0.burger_close_color_id AS burger_close_color_id_24, t0.social_media_color_id AS social_media_color_id_25, t0.social_media_color_hover_id AS social_media_color_hover_id_26, t0.social_media_color_background_id AS social_media_color_background_id_27, t0.image_id AS image_id_28, t0.idUsersCreator AS idUsersCreator_29, t0.idUsersChanger AS idUsersChanger_30 FROM sudcms_website_settings_menu t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 59)
4	Otd\SudcmsConfigBundle\Twig\WebsiteSettingsExtension->websiteSettings (line 39)
5	Otd\SudcmsConfigBundle\Twig\WebsiteSettingsExtension->getGlobals (line 352)
6	Twig\ExtensionSet->getGlobals (line 901)
7	Twig\Environment->getGlobals (line 384)
8	Twig\Template->yield (line 344)
9	Twig\Template->display (line 359)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 334)
12	Twig\Environment->render (line 448)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
15	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
16	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 71)

1.72 ms
(7.75%)

SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC

Parameters:

[
  "/cmf/sudcms/routes/en"
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  phpcr_nodes
WHERE
  path = ?
  AND workspace_name = ?
ORDER BY
  depth,
  sort_order ASC

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/sudcms/routes/en'
                AND workspace_name = 'default_live'
              ORDER BY depth, sort_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1190)
2	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 189)
3	Jackalope\ObjectManager->getNodeByPath (line 228)
4	Jackalope\Session->getNode (line 78)
5	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
6	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 35)
7	Sulu\Component\PHPCR\SessionManager\SessionManager->getRouteNode (line 371)
8	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->getWebspaceRouteNode (line 244)
9	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 207)
10	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 153)
11	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 97)
12	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
13	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
14	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
15	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
16	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 105)
17	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 58)
18	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 116)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 71)

1.22 ms
(5.51%)

SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  phpcr_type_nodes.name AS node_name,
  phpcr_type_nodes.is_abstract AS node_abstract,
  phpcr_type_nodes.is_mixin AS node_mixin,
  phpcr_type_nodes.queryable AS node_queryable,
  phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
  phpcr_type_nodes.primary_item AS node_primary_item_name,
  phpcr_type_nodes.supertypes AS declared_super_type_names,
  phpcr_type_props.name AS property_name,
  phpcr_type_props.auto_created AS property_auto_created,
  phpcr_type_props.mandatory AS property_mandatory,
  phpcr_type_props.protected AS property_protected,
  phpcr_type_props.on_parent_version AS property_on_parent_version,
  phpcr_type_props.required_type AS property_required_type,
  phpcr_type_props.multiple AS property_multiple,
  phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
  phpcr_type_props.query_orderable AS property_query_orderable,
  phpcr_type_props.default_value as property_default_value,
  phpcr_type_childs.name AS child_name,
  phpcr_type_childs.auto_created AS child_auto_created,
  phpcr_type_childs.mandatory AS child_mandatory,
  phpcr_type_childs.protected AS child_protected,
  phpcr_type_childs.on_parent_version AS child_on_parent_version,
  phpcr_type_childs.default_type AS child_default_type,
  phpcr_type_childs.primary_types AS child_primary_types
FROM
  phpcr_type_nodes
  LEFT JOIN phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
  LEFT JOIN phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id

SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 1938)
3	Jackalope\Transport\DoctrineDBAL\Client->fetchUserNodeTypes (line 1889)
4	Jackalope\Transport\DoctrineDBAL\Client->getNodeTypes (line 627)
5	Jackalope\ObjectManager->getNodeTypes (line 639)
6	Jackalope\ObjectManager->getNodeType (line 101)
7	Jackalope\NodeType\NodeTypeManager->fetchNodeTypes (line 219)
8	Jackalope\NodeType\NodeTypeManager->getNodeType (line 1287)
9	Jackalope\Transport\DoctrineDBAL\Client->getNodesData (line 1196)
10	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 189)
11	Jackalope\ObjectManager->getNodeByPath (line 228)
12	Jackalope\Session->getNode (line 78)
13	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
14	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 35)
15	Sulu\Component\PHPCR\SessionManager\SessionManager->getRouteNode (line 371)
16	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->getWebspaceRouteNode (line 244)
17	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 207)
18	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 153)
19	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 97)
20	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
21	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
22	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
23	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
24	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 105)
25	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 58)
26	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 116)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
33	Symfony\Component\HttpKernel\Kernel->handle (line 71)

1.07 ms
(4.81%)

SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
            FROM phpcr_nodes WHERE workspace_name = ? AND identifier IN (?)

Parameters:

[
  "default_live"
  "80d5df40-b6bb-4a49-a75d-c20919ef9fbd"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND identifier IN (?)

SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
            FROM phpcr_nodes WHERE workspace_name = 'default_live' AND identifier IN ('80d5df40-b6bb-4a49-a75d-c20919ef9fbd');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 1439)
3	Jackalope\Transport\DoctrineDBAL\Client->getNodesByIdentifier (line 581)
4	Jackalope\ObjectManager->getNodesByIdentifier (line 790)
5	Jackalope\Property->getReferencedNodes (line 424)
6	Jackalope\Property->getNode (line 211)
7	Jackalope\Property->getValue (line 763)
8	Jackalope\Node->getPropertyValue (line 253)
9	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 207)
10	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 153)
11	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 97)
12	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
13	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
14	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
15	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
16	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 105)
17	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 58)
18	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 116)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 71)

0.98 ms
(4.39%)

SELECT t0.title AS title_1, t0.description AS description_2, t0.copyright AS copyright_3, t0.credits AS credits_4, t0.locale AS locale_5, t0.id AS id_6, t0.idFileVersions AS idFileVersions_7 FROM me_file_version_meta t0 WHERE t0.idFileVersions = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.title AS title_1,
  t0.description AS description_2,
  t0.copyright AS copyright_3,
  t0.credits AS credits_4,
  t0.locale AS locale_5,
  t0.id AS id_6,
  t0.idFileVersions AS idFileVersions_7
FROM
  me_file_version_meta t0
WHERE
  t0.idFileVersions = ?

SELECT t0.title AS title_1, t0.description AS description_2, t0.copyright AS copyright_3, t0.credits AS credits_4, t0.locale AS locale_5, t0.id AS id_6, t0.idFileVersions AS idFileVersions_7 FROM me_file_version_meta t0 WHERE t0.idFileVersions = 13;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1928)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1869)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 961)
8	Sulu\Bundle\MediaBundle\Api\Media->getLocalizedMeta (line 247)
9	Sulu\Bundle\MediaBundle\Api\Media->getTitle (line 1882)
10	Twig\Extension\CoreExtension::getAttribute (line 152)
11	__TwigTemplate_1398d6ea03bd7f0175dfc3a704e1c381->doDisplay (line 388)
12	Twig\Template->yield (line 228)
13	__TwigTemplate_d554bcbcc673dcd2d3933da887638971->block_header (line 432)
14	Twig\Template->yieldBlock (line 477)
15	Twig\Template->yieldParentBlock (line 79)
16	__TwigTemplate_ab7d118df15182d70ff2f5c9b10b4091->block_header (line 432)
17	Twig\Template->yieldBlock (line 106)
18	__TwigTemplate_d554bcbcc673dcd2d3933da887638971->doDisplay (line 388)
19	Twig\Template->yield (line 55)
20	__TwigTemplate_ab7d118df15182d70ff2f5c9b10b4091->doDisplay (line 388)
21	Twig\Template->yield (line 344)
22	Twig\Template->display (line 359)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 334)
25	Twig\Environment->render (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
28	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
29	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 71)

0.97 ms
(4.39%)

SELECT s0_.id AS id_0, s0_.text AS text_1, s0_.start_date AS start_date_2, s0_.end_date AS end_date_3, s0_.is_active AS is_active_4, s0_.type AS type_5, s0_.locale AS locale_6, s0_.created AS created_7, s0_.changed AS changed_8, s0_.idUsersCreator AS idUsersCreator_9, s0_.idUsersChanger AS idUsersChanger_10 FROM sudcms_flash_info s0_ WHERE (s0_.start_date <= ? OR s0_.start_date IS NULL) AND (s0_.end_date >= ? OR s0_.end_date IS NULL) AND s0_.is_active = ? AND s0_.locale = ?

Parameters:

[
  "2025-06-16 01:13:15"
  "2025-06-16 01:13:15"
  1
  "en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.text AS text_1,
  s0_.start_date AS start_date_2,
  s0_.end_date AS end_date_3,
  s0_.is_active AS is_active_4,
  s0_.type AS type_5,
  s0_.locale AS locale_6,
  s0_.created AS created_7,
  s0_.changed AS changed_8,
  s0_.idUsersCreator AS idUsersCreator_9,
  s0_.idUsersChanger AS idUsersChanger_10
FROM
  sudcms_flash_info s0_
WHERE
  (
    s0_.start_date <= ?
    OR s0_.start_date IS NULL
  )
  AND (
    s0_.end_date >= ?
    OR s0_.end_date IS NULL
  )
  AND s0_.is_active = ?
  AND s0_.locale = ?

SELECT s0_.id AS id_0, s0_.text AS text_1, s0_.start_date AS start_date_2, s0_.end_date AS end_date_3, s0_.is_active AS is_active_4, s0_.type AS type_5, s0_.locale AS locale_6, s0_.created AS created_7, s0_.changed AS changed_8, s0_.idUsersCreator AS idUsersCreator_9, s0_.idUsersChanger AS idUsersChanger_10 FROM sudcms_flash_info s0_ WHERE (s0_.start_date <= '2025-06-16 01:13:15' OR s0_.start_date IS NULL) AND (s0_.end_date >= '2025-06-16 01:13:15' OR s0_.end_date IS NULL) AND s0_.is_active = 1 AND s0_.locale = 'en';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 40)
7	Otd\SudcmsFlashInfoBundle\Repository\FlashInfoRepository->findFlashInfoByDate (line 46)
8	Otd\SudcmsFlashInfoBundle\Twig\FlashInfoExtension->flashInfo (line 48)
9	__TwigTemplate_03f6f92aaf6429a09ecadc77d016368e->doDisplay (line 388)
10	Twig\Template->yield (line 103)
11	__TwigTemplate_d554bcbcc673dcd2d3933da887638971->doDisplay (line 388)
12	Twig\Template->yield (line 55)
13	__TwigTemplate_ab7d118df15182d70ff2f5c9b10b4091->doDisplay (line 388)
14	Twig\Template->yield (line 344)
15	Twig\Template->display (line 359)
16	Twig\Template->render (line 51)
17	Twig\TemplateWrapper->render (line 334)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
21	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
22	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 71)

0.73 ms
(3.30%)

SELECT t0.name AS name_1, t0.version AS version_2, t0.subVersion AS subVersion_3, t0.size AS size_4, t0.downloadCounter AS downloadCounter_5, t0.storageOptions AS storageOptions_6, t0.mimeType AS mimeType_7, t0.properties AS properties_8, t0.focusPointX AS focusPointX_9, t0.focusPointY AS focusPointY_10, t0.id AS id_11, t0.created AS created_12, t0.changed AS changed_13, t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14, t0.idFiles AS idFiles_15, t0.idUsersCreator AS idUsersCreator_16, t0.idUsersChanger AS idUsersChanger_17 FROM me_file_versions t0 WHERE t0.idFiles = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.version AS version_2,
  t0.subVersion AS subVersion_3,
  t0.size AS size_4,
  t0.downloadCounter AS downloadCounter_5,
  t0.storageOptions AS storageOptions_6,
  t0.mimeType AS mimeType_7,
  t0.properties AS properties_8,
  t0.focusPointX AS focusPointX_9,
  t0.focusPointY AS focusPointY_10,
  t0.id AS id_11,
  t0.created AS created_12,
  t0.changed AS changed_13,
  t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14,
  t0.idFiles AS idFiles_15,
  t0.idUsersCreator AS idUsersCreator_16,
  t0.idUsersChanger AS idUsersChanger_17
FROM
  me_file_versions t0
WHERE
  t0.idFiles = ?

SELECT t0.name AS name_1, t0.version AS version_2, t0.subVersion AS subVersion_3, t0.size AS size_4, t0.downloadCounter AS downloadCounter_5, t0.storageOptions AS storageOptions_6, t0.mimeType AS mimeType_7, t0.properties AS properties_8, t0.focusPointX AS focusPointX_9, t0.focusPointY AS focusPointY_10, t0.id AS id_11, t0.created AS created_12, t0.changed AS changed_13, t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14, t0.idFiles AS idFiles_15, t0.idUsersCreator AS idUsersCreator_16, t0.idUsersChanger AS idUsersChanger_17 FROM me_file_versions t0 WHERE t0.idFiles = 13;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1928)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1869)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 128)
8	Sulu\Bundle\MediaBundle\Entity\File->getFileVersion (line 873)
9	Sulu\Bundle\MediaBundle\Api\Media->getFileVersion (line 440)
10	Sulu\Bundle\MediaBundle\Api\Media->getName (line 785)
11	Sulu\Bundle\MediaBundle\Media\Manager\MediaManager->addFormatsAndUrl (line 106)
12	Sulu\Bundle\MediaBundle\Twig\MediaTwigExtension->resolveMediaObject (line 53)
13	Sulu\Bundle\MediaBundle\Twig\MediaTwigExtension->resolveMediaFunction (line 52)
14	__TwigTemplate_1398d6ea03bd7f0175dfc3a704e1c381->doDisplay (line 388)
15	Twig\Template->yield (line 228)
16	__TwigTemplate_d554bcbcc673dcd2d3933da887638971->block_header (line 432)
17	Twig\Template->yieldBlock (line 477)
18	Twig\Template->yieldParentBlock (line 79)
19	__TwigTemplate_ab7d118df15182d70ff2f5c9b10b4091->block_header (line 432)
20	Twig\Template->yieldBlock (line 106)
21	__TwigTemplate_d554bcbcc673dcd2d3933da887638971->doDisplay (line 388)
22	Twig\Template->yield (line 55)
23	__TwigTemplate_ab7d118df15182d70ff2f5c9b10b4091->doDisplay (line 388)
24	Twig\Template->yield (line 344)
25	Twig\Template->display (line 359)
26	Twig\Template->render (line 51)
27	Twig\TemplateWrapper->render (line 334)
28	Twig\Environment->render (line 448)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
31	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
32	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 181)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
35	Symfony\Component\HttpKernel\Kernel->handle (line 71)

0.69 ms
(3.11%)

SELECT t0.version AS version_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idMedia AS idMedia_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM me_files t0 WHERE t0.idMedia = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.version AS version_1,
  t0.id AS id_2,
  t0.created AS created_3,
  t0.changed AS changed_4,
  t0.idMedia AS idMedia_5,
  t0.idUsersCreator AS idUsersCreator_6,
  t0.idUsersChanger AS idUsersChanger_7
FROM
  me_files t0
WHERE
  t0.idMedia = ?

SELECT t0.version AS version_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idMedia AS idMedia_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM me_files t0 WHERE t0.idMedia = 13;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1928)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1869)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 866)
8	Sulu\Bundle\MediaBundle\Api\Media->getFileVersion (line 440)
9	Sulu\Bundle\MediaBundle\Api\Media->getName (line 785)
10	Sulu\Bundle\MediaBundle\Media\Manager\MediaManager->addFormatsAndUrl (line 106)
11	Sulu\Bundle\MediaBundle\Twig\MediaTwigExtension->resolveMediaObject (line 53)
12	Sulu\Bundle\MediaBundle\Twig\MediaTwigExtension->resolveMediaFunction (line 52)
13	__TwigTemplate_1398d6ea03bd7f0175dfc3a704e1c381->doDisplay (line 388)
14	Twig\Template->yield (line 228)
15	__TwigTemplate_d554bcbcc673dcd2d3933da887638971->block_header (line 432)
16	Twig\Template->yieldBlock (line 477)
17	Twig\Template->yieldParentBlock (line 79)
18	__TwigTemplate_ab7d118df15182d70ff2f5c9b10b4091->block_header (line 432)
19	Twig\Template->yieldBlock (line 106)
20	__TwigTemplate_d554bcbcc673dcd2d3933da887638971->doDisplay (line 388)
21	Twig\Template->yield (line 55)
22	__TwigTemplate_ab7d118df15182d70ff2f5c9b10b4091->doDisplay (line 388)
23	Twig\Template->yield (line 344)
24	Twig\Template->display (line 359)
25	Twig\Template->render (line 51)
26	Twig\TemplateWrapper->render (line 334)
27	Twig\Environment->render (line 448)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
30	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
31	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
34	Symfony\Component\HttpKernel\Kernel->handle (line 71)

0.63 ms
(2.82%)

SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 WHERE t0.id = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.changed AS changed_3,
  t0.idMediaTypes AS idMediaTypes_4,
  t0.idPreviewImage AS idPreviewImage_5,
  t0.idCollections AS idCollections_6,
  t0.idUsersCreator AS idUsersCreator_7,
  t0.idUsersChanger AS idUsersChanger_8
FROM
  me_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 WHERE t0.id = 13;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\Sulu\Bundle\MediaBundle\Entity\Media::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\Sulu\Bundle\MediaBundle\Entity\Media->__get (line 115)
8	Sulu\Bundle\MediaBundle\Entity\Media->getPreviewImage (line 756)
9	Sulu\Bundle\MediaBundle\Media\Manager\MediaManager->addFormatsAndUrl (line 106)
10	Sulu\Bundle\MediaBundle\Twig\MediaTwigExtension->resolveMediaObject (line 53)
11	Sulu\Bundle\MediaBundle\Twig\MediaTwigExtension->resolveMediaFunction (line 52)
12	__TwigTemplate_1398d6ea03bd7f0175dfc3a704e1c381->doDisplay (line 388)
13	Twig\Template->yield (line 228)
14	__TwigTemplate_d554bcbcc673dcd2d3933da887638971->block_header (line 432)
15	Twig\Template->yieldBlock (line 477)
16	Twig\Template->yieldParentBlock (line 79)
17	__TwigTemplate_ab7d118df15182d70ff2f5c9b10b4091->block_header (line 432)
18	Twig\Template->yieldBlock (line 106)
19	__TwigTemplate_d554bcbcc673dcd2d3933da887638971->doDisplay (line 388)
20	Twig\Template->yield (line 55)
21	__TwigTemplate_ab7d118df15182d70ff2f5c9b10b4091->doDisplay (line 388)
22	Twig\Template->yield (line 344)
23	Twig\Template->display (line 359)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 334)
26	Twig\Environment->render (line 448)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
29	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
30	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
33	Symfony\Component\HttpKernel\Kernel->handle (line 71)

0.55 ms
(2.47%)

SELECT 1 FROM phpcr_workspaces WHERE name = ?

Parameters:

[
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  1
FROM
  phpcr_workspaces
WHERE
  name = ?

SELECT 1 FROM phpcr_workspaces WHERE name = 'default_live';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 958)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 400)
3	Jackalope\Transport\DoctrineDBAL\Client->workspaceExists (line 333)
4	Jackalope\Transport\DoctrineDBAL\Client->login (line 438)
5	Jackalope\Transport\DoctrineDBAL\Client->assertLoggedIn (line 1167)
6	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 189)
7	Jackalope\ObjectManager->getNodeByPath (line 228)
8	Jackalope\Session->getNode (line 78)
9	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
10	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 35)
11	Sulu\Component\PHPCR\SessionManager\SessionManager->getRouteNode (line 371)
12	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->getWebspaceRouteNode (line 244)
13	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 207)
14	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 153)
15	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 97)
16	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
17	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
18	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
19	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
20	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 105)
21	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 58)
22	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 116)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 71)

0.46 ms
(2.07%)

SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC

Parameters:

[
  "sudcms.otidea.com/{localization}"
  "dev"
  "sudcms"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.title AS title_0,
  w0_.webspace_key AS webspace_key_1,
  w0_.all_domains AS all_domains_2,
  w0_.content AS content_3,
  w0_.type AS type_4,
  w0_.id AS id_5,
  w1_.url AS url_6,
  w1_.environment AS environment_7,
  w1_.id AS id_8
FROM
  we_analytics w0_
  LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics
  LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain
WHERE
  (
    w0_.all_domains = 1
    OR (
      w1_.url = ?
      AND w1_.environment = ?
    )
  )
  AND w0_.webspace_key = ?
ORDER BY
  w0_.id ASC

SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = 'sudcms.otidea.com/{localization}' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'sudcms' ORDER BY w0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 66)
7	Sulu\Bundle\WebsiteBundle\Entity\AnalyticsRepository->findByUrl (line 109)
8	Sulu\Bundle\WebsiteBundle\EventListener\AppendAnalyticsListener->onResponse (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 214)
13	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 202)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 71)

0.43 ms
(1.92%)

SELECT t0.id AS id_1, t0.duration AS duration_2, t0.timezone AS timezone_3, t0.created AS created_4, t0.changed AS changed_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM sudcms_flash_info_settings t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.duration AS duration_2,
  t0.timezone AS timezone_3,
  t0.created AS created_4,
  t0.changed AS changed_5,
  t0.idUsersCreator AS idUsersCreator_6,
  t0.idUsersChanger AS idUsersChanger_7
FROM
  sudcms_flash_info_settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.duration AS duration_2, t0.timezone AS timezone_3, t0.created AS created_4, t0.changed AS changed_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM sudcms_flash_info_settings t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 37)
4	Otd\SudcmsFlashInfoBundle\Twig\FlashInfoExtension->flashInfo (line 48)
5	__TwigTemplate_03f6f92aaf6429a09ecadc77d016368e->doDisplay (line 388)
6	Twig\Template->yield (line 103)
7	__TwigTemplate_d554bcbcc673dcd2d3933da887638971->doDisplay (line 388)
8	Twig\Template->yield (line 55)
9	__TwigTemplate_ab7d118df15182d70ff2f5c9b10b4091->doDisplay (line 388)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 334)
14	Twig\Environment->render (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
17	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
18	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 71)

0.26 ms
(1.18%)

SELECT t0.id AS id_1, t0.server_node AS server_node_2, t0.breadcrumb AS breadcrumb_3, t0.fancybox_duration AS fancybox_duration_4, t0.fancybox_show_progress AS fancybox_show_progress_5, t0.fancybox_show_dots AS fancybox_show_dots_6, t0.created AS created_7, t0.changed AS changed_8, t0.background_color_id AS background_color_id_9, t0.default_image_id AS default_image_id_10, t0.idUsersCreator AS idUsersCreator_11, t0.idUsersChanger AS idUsersChanger_12 FROM sudcms_website_settings_general t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.server_node AS server_node_2,
  t0.breadcrumb AS breadcrumb_3,
  t0.fancybox_duration AS fancybox_duration_4,
  t0.fancybox_show_progress AS fancybox_show_progress_5,
  t0.fancybox_show_dots AS fancybox_show_dots_6,
  t0.created AS created_7,
  t0.changed AS changed_8,
  t0.background_color_id AS background_color_id_9,
  t0.default_image_id AS default_image_id_10,
  t0.idUsersCreator AS idUsersCreator_11,
  t0.idUsersChanger AS idUsersChanger_12
FROM
  sudcms_website_settings_general t0
LIMIT
  1

SELECT t0.id AS id_1, t0.server_node AS server_node_2, t0.breadcrumb AS breadcrumb_3, t0.fancybox_duration AS fancybox_duration_4, t0.fancybox_show_progress AS fancybox_show_progress_5, t0.fancybox_show_dots AS fancybox_show_dots_6, t0.created AS created_7, t0.changed AS changed_8, t0.background_color_id AS background_color_id_9, t0.default_image_id AS default_image_id_10, t0.idUsersCreator AS idUsersCreator_11, t0.idUsersChanger AS idUsersChanger_12 FROM sudcms_website_settings_general t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 62)
4	Otd\SudcmsConfigBundle\Twig\WebsiteSettingsExtension->websiteSettings (line 39)
5	Otd\SudcmsConfigBundle\Twig\WebsiteSettingsExtension->getGlobals (line 352)
6	Twig\ExtensionSet->getGlobals (line 901)
7	Twig\Environment->getGlobals (line 384)
8	Twig\Template->yield (line 344)
9	Twig\Template->display (line 359)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 334)
12	Twig\Environment->render (line 448)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
15	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
16	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 71)

0.25 ms
(1.14%)

SELECT t0.id AS id_1, t0.shape AS shape_2, t0.radius AS radius_3, t0.title_align AS title_align_4, t0.list_style_ul_level1 AS list_style_ul_level1_5, t0.list_style_ul_level2 AS list_style_ul_level2_6, t0.list_style_ul_level3 AS list_style_ul_level3_7, t0.list_style_ol_level1 AS list_style_ol_level1_8, t0.list_style_ol_level2 AS list_style_ol_level2_9, t0.list_style_ol_level3 AS list_style_ol_level3_10, t0.created AS created_11, t0.changed AS changed_12, t0.title_font_id AS title_font_id_13, t0.sub_title_font_id AS sub_title_font_id_14, t0.paragraph_font_id AS paragraph_font_id_15, t0.idUsersCreator AS idUsersCreator_16, t0.idUsersChanger AS idUsersChanger_17 FROM sudcms_website_settings_blocks t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.shape AS shape_2,
  t0.radius AS radius_3,
  t0.title_align AS title_align_4,
  t0.list_style_ul_level1 AS list_style_ul_level1_5,
  t0.list_style_ul_level2 AS list_style_ul_level2_6,
  t0.list_style_ul_level3 AS list_style_ul_level3_7,
  t0.list_style_ol_level1 AS list_style_ol_level1_8,
  t0.list_style_ol_level2 AS list_style_ol_level2_9,
  t0.list_style_ol_level3 AS list_style_ol_level3_10,
  t0.created AS created_11,
  t0.changed AS changed_12,
  t0.title_font_id AS title_font_id_13,
  t0.sub_title_font_id AS sub_title_font_id_14,
  t0.paragraph_font_id AS paragraph_font_id_15,
  t0.idUsersCreator AS idUsersCreator_16,
  t0.idUsersChanger AS idUsersChanger_17
FROM
  sudcms_website_settings_blocks t0
LIMIT
  1

SELECT t0.id AS id_1, t0.shape AS shape_2, t0.radius AS radius_3, t0.title_align AS title_align_4, t0.list_style_ul_level1 AS list_style_ul_level1_5, t0.list_style_ul_level2 AS list_style_ul_level2_6, t0.list_style_ul_level3 AS list_style_ul_level3_7, t0.list_style_ol_level1 AS list_style_ol_level1_8, t0.list_style_ol_level2 AS list_style_ol_level2_9, t0.list_style_ol_level3 AS list_style_ol_level3_10, t0.created AS created_11, t0.changed AS changed_12, t0.title_font_id AS title_font_id_13, t0.sub_title_font_id AS sub_title_font_id_14, t0.paragraph_font_id AS paragraph_font_id_15, t0.idUsersCreator AS idUsersCreator_16, t0.idUsersChanger AS idUsersChanger_17 FROM sudcms_website_settings_blocks t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 60)
4	Otd\SudcmsConfigBundle\Twig\WebsiteSettingsExtension->websiteSettings (line 39)
5	Otd\SudcmsConfigBundle\Twig\WebsiteSettingsExtension->getGlobals (line 352)
6	Twig\ExtensionSet->getGlobals (line 901)
7	Twig\Environment->getGlobals (line 384)
8	Twig\Template->yield (line 344)
9	Twig\Template->display (line 359)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 334)
12	Twig\Environment->render (line 448)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
15	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
16	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 71)

0.22 ms
(1.01%)

SELECT prefix, uri FROM phpcr_namespaces

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  prefix,
  uri
FROM
  phpcr_namespaces

SELECT prefix, uri FROM phpcr_namespaces;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 517)
2	Jackalope\Transport\DoctrineDBAL\Client->getNamespacesObject (line 507)
3	Jackalope\Transport\DoctrineDBAL\Client->getNamespaces (line 502)
4	Jackalope\Transport\DoctrineDBAL\Client->getNamespacePrefixes (line 1168)
5	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 189)
6	Jackalope\ObjectManager->getNodeByPath (line 228)
7	Jackalope\Session->getNode (line 78)
8	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
9	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 35)
10	Sulu\Component\PHPCR\SessionManager\SessionManager->getRouteNode (line 371)
11	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->getWebspaceRouteNode (line 244)
12	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 207)
13	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 153)
14	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 97)
15	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
16	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
17	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
18	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
19	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 105)
20	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 58)
21	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 116)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 71)

0.22 ms
(0.97%)

SELECT t0.id AS id_1, t0.google_api_font_family AS google_api_font_family_2, t0.created AS created_3, t0.changed AS changed_4, t0.idUsersCreator AS idUsersCreator_5, t0.idUsersChanger AS idUsersChanger_6 FROM sudcms_website_settings_fonts t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.google_api_font_family AS google_api_font_family_2,
  t0.created AS created_3,
  t0.changed AS changed_4,
  t0.idUsersCreator AS idUsersCreator_5,
  t0.idUsersChanger AS idUsersChanger_6
FROM
  sudcms_website_settings_fonts t0

SELECT t0.id AS id_1, t0.google_api_font_family AS google_api_font_family_2, t0.created AS created_3, t0.changed AS changed_4, t0.idUsersCreator AS idUsersCreator_5, t0.idUsersChanger AS idUsersChanger_6 FROM sudcms_website_settings_fonts t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 63)
5	Otd\SudcmsConfigBundle\Twig\WebsiteSettingsExtension->websiteSettings (line 39)
6	Otd\SudcmsConfigBundle\Twig\WebsiteSettingsExtension->getGlobals (line 352)
7	Twig\ExtensionSet->getGlobals (line 901)
8	Twig\Environment->getGlobals (line 384)
9	Twig\Template->yield (line 344)
10	Twig\Template->display (line 359)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 334)
13	Twig\Environment->render (line 448)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
16	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
17	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 71)

0.20 ms
(0.89%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.hexadecimal_color AS hexadecimal_color_3, t0.created AS created_4, t0.changed AS changed_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM sudcms_website_settings_colors t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.hexadecimal_color AS hexadecimal_color_3,
  t0.created AS created_4,
  t0.changed AS changed_5,
  t0.idUsersCreator AS idUsersCreator_6,
  t0.idUsersChanger AS idUsersChanger_7
FROM
  sudcms_website_settings_colors t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.hexadecimal_color AS hexadecimal_color_3, t0.created AS created_4, t0.changed AS changed_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM sudcms_website_settings_colors t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 61)
5	Otd\SudcmsConfigBundle\Twig\WebsiteSettingsExtension->websiteSettings (line 39)
6	Otd\SudcmsConfigBundle\Twig\WebsiteSettingsExtension->getGlobals (line 352)
7	Twig\ExtensionSet->getGlobals (line 901)
8	Twig\Environment->getGlobals (line 384)
9	Twig\Template->yield (line 344)
10	Twig\Template->display (line 359)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 334)
13	Twig\Environment->render (line 448)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
16	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
17	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 71)

0.14 ms
(0.64%)

SELECT t0.id AS id_1, t0.css_class AS css_class_2, t0.font_family AS font_family_3, t0.font_style AS font_style_4, t0.font_weight AS font_weight_5, t0.created AS created_6, t0.changed AS changed_7, t0.font_id AS font_id_8, t0.idUsersCreator AS idUsersCreator_9, t0.idUsersChanger AS idUsersChanger_10 FROM sudcms_website_settings_fonts_properties t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.css_class AS css_class_2,
  t0.font_family AS font_family_3,
  t0.font_style AS font_style_4,
  t0.font_weight AS font_weight_5,
  t0.created AS created_6,
  t0.changed AS changed_7,
  t0.font_id AS font_id_8,
  t0.idUsersCreator AS idUsersCreator_9,
  t0.idUsersChanger AS idUsersChanger_10
FROM
  sudcms_website_settings_fonts_properties t0

SELECT t0.id AS id_1, t0.css_class AS css_class_2, t0.font_family AS font_family_3, t0.font_style AS font_style_4, t0.font_weight AS font_weight_5, t0.created AS created_6, t0.changed AS changed_7, t0.font_id AS font_id_8, t0.idUsersCreator AS idUsersCreator_9, t0.idUsersChanger AS idUsersChanger_10 FROM sudcms_website_settings_fonts_properties t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 64)
5	Otd\SudcmsConfigBundle\Twig\WebsiteSettingsExtension->websiteSettings (line 39)
6	Otd\SudcmsConfigBundle\Twig\WebsiteSettingsExtension->getGlobals (line 352)
7	Twig\ExtensionSet->getGlobals (line 901)
8	Twig\Environment->getGlobals (line 384)
9	Twig\Template->yield (line 344)
10	Twig\Template->display (line 359)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 334)
13	Twig\Environment->render (line 448)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
16	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
17	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 71)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
Sulu\Bundle\MediaBundle\Entity\Collection	No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem	No errors.
Sulu\Bundle\FormBundle\Entity\Form	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle	No errors.
Sulu\Bundle\SecurityBundle\Entity\Group	No errors.
Sulu\Bundle\SecurityBundle\Entity\User	No errors.
Otd\SudcmsConfigBundle\Entity\WebsiteSettingsMenu	No errors.
Otd\SudcmsConfigBundle\Entity\WebsiteSettingsColors	No errors.
Sulu\Bundle\MediaBundle\Entity\Media	No errors.
Otd\SudcmsConfigBundle\Entity\WebsiteSettingsBlocks	No errors.
Otd\SudcmsConfigBundle\Entity\WebsiteSettingsFontsProperties	No errors.
Otd\SudcmsConfigBundle\Entity\WebsiteSettingsBlocksColors	No errors.
Otd\SudcmsConfigBundle\Entity\WebsiteSettingsButtonsStyles	No errors.
Otd\SudcmsConfigBundle\Entity\WebsiteSettingsGeneral	No errors.
Otd\SudcmsConfigBundle\Entity\WebsiteSettingsFonts	No errors.
Otd\SudcmsFlashInfoBundle\Entity\FlashInfoSettings	No errors.
Otd\SudcmsFlashInfoBundle\Entity\FlashInfo	No errors.
Sulu\Bundle\MediaBundle\Entity\MediaType	No errors.
Sulu\Bundle\MediaBundle\Entity\File	No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersion	No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionMeta	No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionContentLanguage	No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionPublishLanguage	No errors.
Sulu\Bundle\MediaBundle\Entity\FormatOptions	No errors.
Sulu\Bundle\TagBundle\Entity\Tag	No errors.
Sulu\Bundle\CategoryBundle\Entity\Category	No errors.
Sulu\Bundle\WebsiteBundle\Entity\Analytics	No errors.
Sulu\Bundle\WebsiteBundle\Entity\Domain	No errors.

Symfony Profiler

GET https://sudcms.otidea.com/en

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping