Symfony Profiler

Query Metrics

13 Database Queries

2 Different statements

2.50 ms Query time

0 Invalid entities

30 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.79 ms
(71.73%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.main_keyword AS main_keyword_5, t0.title_intent AS title_intent_6, t0.target_audience AS target_audience_7, t0.type AS type_8, t0.schema_markup_type AS schema_markup_type_9, t0.page_id AS page_id_10, t0.image_id AS image_id_11 FROM core_page_details t0 WHERE t0.page_id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.keywords AS keywords_4,
  t0.main_keyword AS main_keyword_5,
  t0.title_intent AS title_intent_6,
  t0.target_audience AS target_audience_7,
  t0.type AS type_8,
  t0.schema_markup_type AS schema_markup_type_9,
  t0.page_id AS page_id_10,
  t0.image_id AS image_id_11
FROM
  core_page_details t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.main_keyword AS main_keyword_5, t0.title_intent AS title_intent_6, t0.target_audience AS target_audience_7, t0.type AS type_8, t0.schema_markup_type AS schema_markup_type_9, t0.page_id AS page_id_10, t0.image_id AS image_id_11 FROM core_page_details t0 WHERE t0.page_id = 10;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 839)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2653)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 269)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 496)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getResult (line 688)
11	Coretecs\CoreManagementBundle\Repository\AbstractPageRepository->findForSitemap (line 117)
12	Coretecs\CoreManagementBundle\Service\PageSitemapCollector->collect (line 32)
13	Coretecs\CoreManagementBundle\Service\XmlSitemapGenerator->generate (line 22)
14	Coretecs\CoreManagementBundle\Controller\SeoController->sitemap (line 47)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 191)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
19	require_once (line 32)
20	require_once (line 5)

0.71 ms
(28.27%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.type AS type_4, c0_.slug AS slug_5, c0_.published_at AS published_at_6, c0_.public AS public_7, c0_.template AS template_8, c0_.exclude_from_sitemap AS exclude_from_sitemap_9, c0_.content_updated_at AS content_updated_at_10, p1_.headline AS headline_11, p1_.intro_text AS intro_text_12, p1_.invalid_text AS invalid_text_13, c3_.id AS id_14, c3_.name AS name_15, c3_.created_at AS created_at_16, c3_.updated_at AS updated_at_17, c3_.type AS type_18, c3_.slug AS slug_19, c3_.published_at AS published_at_20, c3_.public AS public_21, c3_.template AS template_22, c3_.exclude_from_sitemap AS exclude_from_sitemap_23, c3_.content_updated_at AS content_updated_at_24, p4_.headline AS headline_25, p4_.intro_text AS intro_text_26, p4_.invalid_text AS invalid_text_27, c0_.discriminator AS discriminator_28, c0_.author_id AS author_id_29, c0_.parent_page_id AS parent_page_id_30, p1_.player_media_id AS player_media_id_31, c3_.discriminator AS discriminator_32, c3_.author_id AS author_id_33, c3_.parent_page_id AS parent_page_id_34, p4_.player_media_id AS player_media_id_35 FROM core_abstract_page c0_ LEFT JOIN player_seite p1_ ON c0_.id = p1_.id LEFT JOIN core_page c2_ ON c0_.id = c2_.id LEFT JOIN core_abstract_page c3_ ON c0_.parent_page_id = c3_.id LEFT JOIN player_seite p4_ ON c3_.id = p4_.id LEFT JOIN core_page c5_ ON c3_.id = c5_.id WHERE c0_.exclude_from_sitemap = ? AND ((c0_.public = ? OR (c0_.published_at IS NOT NULL AND c0_.published_at <= ?))) ORDER BY c0_.slug ASC

Parameters:

[
  0
  1
  "2026-11-06 19:48:36"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.created_at AS created_at_2,
  c0_.updated_at AS updated_at_3,
  c0_.type AS type_4,
  c0_.slug AS slug_5,
  c0_.published_at AS published_at_6,
  c0_.public AS public_7,
  c0_.template AS template_8,
  c0_.exclude_from_sitemap AS exclude_from_sitemap_9,
  c0_.content_updated_at AS content_updated_at_10,
  p1_.headline AS headline_11,
  p1_.intro_text AS intro_text_12,
  p1_.invalid_text AS invalid_text_13,
  c3_.id AS id_14,
  c3_.name AS name_15,
  c3_.created_at AS created_at_16,
  c3_.updated_at AS updated_at_17,
  c3_.type AS type_18,
  c3_.slug AS slug_19,
  c3_.published_at AS published_at_20,
  c3_.public AS public_21,
  c3_.template AS template_22,
  c3_.exclude_from_sitemap AS exclude_from_sitemap_23,
  c3_.content_updated_at AS content_updated_at_24,
  p4_.headline AS headline_25,
  p4_.intro_text AS intro_text_26,
  p4_.invalid_text AS invalid_text_27,
  c0_.discriminator AS discriminator_28,
  c0_.author_id AS author_id_29,
  c0_.parent_page_id AS parent_page_id_30,
  p1_.player_media_id AS player_media_id_31,
  c3_.discriminator AS discriminator_32,
  c3_.author_id AS author_id_33,
  c3_.parent_page_id AS parent_page_id_34,
  p4_.player_media_id AS player_media_id_35
FROM
  core_abstract_page c0_
  LEFT JOIN player_seite p1_ ON c0_.id = p1_.id
  LEFT JOIN core_page c2_ ON c0_.id = c2_.id
  LEFT JOIN core_abstract_page c3_ ON c0_.parent_page_id = c3_.id
  LEFT JOIN player_seite p4_ ON c3_.id = p4_.id
  LEFT JOIN core_page c5_ ON c3_.id = c5_.id
WHERE
  c0_.exclude_from_sitemap = ?
  AND (
    (
      c0_.public = ?
      OR (
        c0_.published_at IS NOT NULL
        AND c0_.published_at <= ?
      )
    )
  )
ORDER BY
  c0_.slug ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.type AS type_4, c0_.slug AS slug_5, c0_.published_at AS published_at_6, c0_.public AS public_7, c0_.template AS template_8, c0_.exclude_from_sitemap AS exclude_from_sitemap_9, c0_.content_updated_at AS content_updated_at_10, p1_.headline AS headline_11, p1_.intro_text AS intro_text_12, p1_.invalid_text AS invalid_text_13, c3_.id AS id_14, c3_.name AS name_15, c3_.created_at AS created_at_16, c3_.updated_at AS updated_at_17, c3_.type AS type_18, c3_.slug AS slug_19, c3_.published_at AS published_at_20, c3_.public AS public_21, c3_.template AS template_22, c3_.exclude_from_sitemap AS exclude_from_sitemap_23, c3_.content_updated_at AS content_updated_at_24, p4_.headline AS headline_25, p4_.intro_text AS intro_text_26, p4_.invalid_text AS invalid_text_27, c0_.discriminator AS discriminator_28, c0_.author_id AS author_id_29, c0_.parent_page_id AS parent_page_id_30, p1_.player_media_id AS player_media_id_31, c3_.discriminator AS discriminator_32, c3_.author_id AS author_id_33, c3_.parent_page_id AS parent_page_id_34, p4_.player_media_id AS player_media_id_35 FROM core_abstract_page c0_ LEFT JOIN player_seite p1_ ON c0_.id = p1_.id LEFT JOIN core_page c2_ ON c0_.id = c2_.id LEFT JOIN core_abstract_page c3_ ON c0_.parent_page_id = c3_.id LEFT JOIN player_seite p4_ ON c3_.id = p4_.id LEFT JOIN core_page c5_ ON c3_.id = c5_.id WHERE c0_.exclude_from_sitemap = 0 AND ((c0_.public = 1 OR (c0_.published_at IS NOT NULL AND c0_.published_at <= '2026-11-06 19:48:36'))) ORDER BY c0_.slug ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Coretecs\CoreManagementBundle\Repository\AbstractPageRepository->findForSitemap (line 117)
7	Coretecs\CoreManagementBundle\Service\PageSitemapCollector->collect (line 32)
8	Coretecs\CoreManagementBundle\Service\XmlSitemapGenerator->generate (line 22)
9	Coretecs\CoreManagementBundle\Controller\SeoController->sitemap (line 47)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	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
Coretecs\CoreManagementBundle\Entity\AbstractPage	12
Coretecs\CoreManagementBundle\Entity\PageDetails	12
Coretecs\CoreManagementBundle\Entity\Media	5
Coretecs\CoreManagementBundle\Entity\User	1

Entities Mapping

Class	Mapping errors
Coretecs\CoreManagementBundle\Entity\AbstractPage	No errors.
App\Entity\PlayerSeite	No errors.
Coretecs\CoreManagementBundle\Entity\Page	No errors.
Coretecs\CoreManagementBundle\Entity\User	No errors.
Coretecs\CoreManagementBundle\Entity\Media	No errors.
Coretecs\CoreManagementBundle\Entity\PageDetails	No errors.
Coretecs\CoreManagementBundle\Entity\Component	No errors.

Symfony Profiler

GET https://9d-atmung.at/sitemap.xml

Configuration Settings

Theme

Page Width