Symfony Profiler

Query Metrics

6 Database Queries

3 Different statements

10.81 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.24 ms
(48.52%)

SELECT t0.id AS id_1, t0.name_fr AS name_fr_2, t0.title_fr AS title_fr_3, t0.description_fr AS description_fr_4, t0.image_name_fr AS image_name_fr_5, t0.image_responsive_name_fr AS image_responsive_name_fr_6, t0.name_de AS name_de_7, t0.title_de AS title_de_8, t0.description_de AS description_de_9, t0.image_name_de AS image_name_de_10, t0.image_responsive_name_de AS image_responsive_name_de_11, t0.name_en AS name_en_12, t0.title_en AS title_en_13, t0.description_en AS description_en_14, t0.image_name_en AS image_name_en_15, t0.image_responsive_name_en AS image_responsive_name_en_16, t0.code AS code_17, t0.intro_fr AS intro_fr_18, t0.intro_de AS intro_de_19, t0.intro_en AS intro_en_20, t0.render_field AS render_field_21, t0.slug_fr AS slug_fr_22, t0.slug_en AS slug_en_23, t0.slug_de AS slug_de_24, t0.link_url_fr AS link_url_fr_25, t0.link_url_en AS link_url_en_26, t0.link_url_de AS link_url_de_27, t0.link_text_fr AS link_text_fr_28, t0.link_text_en AS link_text_en_29, t0.link_text_de AS link_text_de_30, t0.updated_at AS updated_at_31, t0.meta_description_fr AS meta_description_fr_32, t0.meta_description_en AS meta_description_en_33, t0.meta_description_de AS meta_description_de_34, t0.meta_image_fr AS meta_image_fr_35, t0.meta_image_en AS meta_image_en_36, t0.meta_image_de AS meta_image_de_37, t38.id AS id_39, t38.name AS name_40, t38.created_at AS created_at_41, t38.updated_at AS updated_at_42, t38.image_name AS image_name_43, t38.enabled AS enabled_44, t38.slug_fr AS slug_fr_45, t38.slug_de AS slug_de_46, t38.slug_en AS slug_en_47, t38.code AS code_48, t38.order_page AS order_page_49, t38.translation_id AS translation_id_50, t38.category_id AS category_id_51, t52.id AS id_53, t52.name AS name_54, t52.category_order AS category_order_55, t52.translation_id AS translation_id_56, t57.id AS id_58, t57.name AS name_59, t57.created_at AS created_at_60, t57.updated_at AS updated_at_61, t57.publish_at AS publish_at_62, t57.image_name AS image_name_63, t57.enabled AS enabled_64, t57.author AS author_65, t57.event_at AS event_at_66, t57.translation_id AS translation_id_67, t57.category_id AS category_id_68, t57.created_by_id AS created_by_id_69, t70.id AS id_71, t70.name AS name_72, t70.slug_fr AS slug_fr_73, t70.slug_en AS slug_en_74, t70.translation_id AS translation_id_75 FROM translation t0 LEFT JOIN page t38 ON t38.translation_id = t0.id LEFT JOIN page_category t52 ON t52.translation_id = t0.id LEFT JOIN post t57 ON t57.translation_id = t0.id LEFT JOIN category t70 ON t70.translation_id = t0.id WHERE t0.id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name_fr AS name_fr_2,
  t0.title_fr AS title_fr_3,
  t0.description_fr AS description_fr_4,
  t0.image_name_fr AS image_name_fr_5,
  t0.image_responsive_name_fr AS image_responsive_name_fr_6,
  t0.name_de AS name_de_7,
  t0.title_de AS title_de_8,
  t0.description_de AS description_de_9,
  t0.image_name_de AS image_name_de_10,
  t0.image_responsive_name_de AS image_responsive_name_de_11,
  t0.name_en AS name_en_12,
  t0.title_en AS title_en_13,
  t0.description_en AS description_en_14,
  t0.image_name_en AS image_name_en_15,
  t0.image_responsive_name_en AS image_responsive_name_en_16,
  t0.code AS code_17,
  t0.intro_fr AS intro_fr_18,
  t0.intro_de AS intro_de_19,
  t0.intro_en AS intro_en_20,
  t0.render_field AS render_field_21,
  t0.slug_fr AS slug_fr_22,
  t0.slug_en AS slug_en_23,
  t0.slug_de AS slug_de_24,
  t0.link_url_fr AS link_url_fr_25,
  t0.link_url_en AS link_url_en_26,
  t0.link_url_de AS link_url_de_27,
  t0.link_text_fr AS link_text_fr_28,
  t0.link_text_en AS link_text_en_29,
  t0.link_text_de AS link_text_de_30,
  t0.updated_at AS updated_at_31,
  t0.meta_description_fr AS meta_description_fr_32,
  t0.meta_description_en AS meta_description_en_33,
  t0.meta_description_de AS meta_description_de_34,
  t0.meta_image_fr AS meta_image_fr_35,
  t0.meta_image_en AS meta_image_en_36,
  t0.meta_image_de AS meta_image_de_37,
  t38.id AS id_39,
  t38.name AS name_40,
  t38.created_at AS created_at_41,
  t38.updated_at AS updated_at_42,
  t38.image_name AS image_name_43,
  t38.enabled AS enabled_44,
  t38.slug_fr AS slug_fr_45,
  t38.slug_de AS slug_de_46,
  t38.slug_en AS slug_en_47,
  t38.code AS code_48,
  t38.order_page AS order_page_49,
  t38.translation_id AS translation_id_50,
  t38.category_id AS category_id_51,
  t52.id AS id_53,
  t52.name AS name_54,
  t52.category_order AS category_order_55,
  t52.translation_id AS translation_id_56,
  t57.id AS id_58,
  t57.name AS name_59,
  t57.created_at AS created_at_60,
  t57.updated_at AS updated_at_61,
  t57.publish_at AS publish_at_62,
  t57.image_name AS image_name_63,
  t57.enabled AS enabled_64,
  t57.author AS author_65,
  t57.event_at AS event_at_66,
  t57.translation_id AS translation_id_67,
  t57.category_id AS category_id_68,
  t57.created_by_id AS created_by_id_69,
  t70.id AS id_71,
  t70.name AS name_72,
  t70.slug_fr AS slug_fr_73,
  t70.slug_en AS slug_en_74,
  t70.translation_id AS translation_id_75
FROM
  translation t0
  LEFT JOIN page t38 ON t38.translation_id = t0.id
  LEFT JOIN page_category t52 ON t52.translation_id = t0.id
  LEFT JOIN post t57 ON t57.translation_id = t0.id
  LEFT JOIN category t70 ON t70.translation_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_fr AS name_fr_2, t0.title_fr AS title_fr_3, t0.description_fr AS description_fr_4, t0.image_name_fr AS image_name_fr_5, t0.image_responsive_name_fr AS image_responsive_name_fr_6, t0.name_de AS name_de_7, t0.title_de AS title_de_8, t0.description_de AS description_de_9, t0.image_name_de AS image_name_de_10, t0.image_responsive_name_de AS image_responsive_name_de_11, t0.name_en AS name_en_12, t0.title_en AS title_en_13, t0.description_en AS description_en_14, t0.image_name_en AS image_name_en_15, t0.image_responsive_name_en AS image_responsive_name_en_16, t0.code AS code_17, t0.intro_fr AS intro_fr_18, t0.intro_de AS intro_de_19, t0.intro_en AS intro_en_20, t0.render_field AS render_field_21, t0.slug_fr AS slug_fr_22, t0.slug_en AS slug_en_23, t0.slug_de AS slug_de_24, t0.link_url_fr AS link_url_fr_25, t0.link_url_en AS link_url_en_26, t0.link_url_de AS link_url_de_27, t0.link_text_fr AS link_text_fr_28, t0.link_text_en AS link_text_en_29, t0.link_text_de AS link_text_de_30, t0.updated_at AS updated_at_31, t0.meta_description_fr AS meta_description_fr_32, t0.meta_description_en AS meta_description_en_33, t0.meta_description_de AS meta_description_de_34, t0.meta_image_fr AS meta_image_fr_35, t0.meta_image_en AS meta_image_en_36, t0.meta_image_de AS meta_image_de_37, t38.id AS id_39, t38.name AS name_40, t38.created_at AS created_at_41, t38.updated_at AS updated_at_42, t38.image_name AS image_name_43, t38.enabled AS enabled_44, t38.slug_fr AS slug_fr_45, t38.slug_de AS slug_de_46, t38.slug_en AS slug_en_47, t38.code AS code_48, t38.order_page AS order_page_49, t38.translation_id AS translation_id_50, t38.category_id AS category_id_51, t52.id AS id_53, t52.name AS name_54, t52.category_order AS category_order_55, t52.translation_id AS translation_id_56, t57.id AS id_58, t57.name AS name_59, t57.created_at AS created_at_60, t57.updated_at AS updated_at_61, t57.publish_at AS publish_at_62, t57.image_name AS image_name_63, t57.enabled AS enabled_64, t57.author AS author_65, t57.event_at AS event_at_66, t57.translation_id AS translation_id_67, t57.category_id AS category_id_68, t57.created_by_id AS created_by_id_69, t70.id AS id_71, t70.name AS name_72, t70.slug_fr AS slug_fr_73, t70.slug_en AS slug_en_74, t70.translation_id AS translation_id_75 FROM translation t0 LEFT JOIN page t38 ON t38.translation_id = t0.id LEFT JOIN page_category t52 ON t52.translation_id = t0.id LEFT JOIN post t57 ON t57.translation_id = t0.id LEFT JOIN category t70 ON t70.translation_id = t0.id WHERE t0.id = 9;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Translation::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Translation->__get (line 555)
8	App\Entity\Translation->getSlugByLocale (line 98)
9	App\Controller\SitemapController->sitemap (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

3.02 ms
(27.93%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5, t0.enabled AS enabled_6, t0.slug_fr AS slug_fr_7, t0.slug_de AS slug_de_8, t0.slug_en AS slug_en_9, t0.code AS code_10, t0.order_page AS order_page_11, t0.translation_id AS translation_id_12, t0.category_id AS category_id_13 FROM page 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.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.image_name AS image_name_5,
  t0.enabled AS enabled_6,
  t0.slug_fr AS slug_fr_7,
  t0.slug_de AS slug_de_8,
  t0.slug_en AS slug_en_9,
  t0.code AS code_10,
  t0.order_page AS order_page_11,
  t0.translation_id AS translation_id_12,
  t0.category_id AS category_id_13
FROM
  page t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5, t0.enabled AS enabled_6, t0.slug_fr AS slug_fr_7, t0.slug_de AS slug_de_8, t0.slug_en AS slug_en_9, t0.code AS code_10, t0.order_page AS order_page_11, t0.translation_id AS translation_id_12, t0.category_id AS category_id_13 FROM page t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 68)
6	App\Controller\SitemapController->sitemap (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

2.54 ms
(23.55%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.publish_at AS publish_at_4, p0_.image_name AS image_name_5, p0_.enabled AS enabled_6, p0_.author AS author_7, p0_.event_at AS event_at_8, p0_.translation_id AS translation_id_9, p0_.category_id AS category_id_10, p0_.created_by_id AS created_by_id_11 FROM post p0_ INNER JOIN translation t1_ ON p0_.translation_id = t1_.id WHERE p0_.enabled = 1 AND p0_.publish_at <= ? ORDER BY p0_.event_at DESC, p0_.publish_at DESC

Parameters:

[
  "2026-04-18 14:55:59"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.created_at AS created_at_2,
  p0_.updated_at AS updated_at_3,
  p0_.publish_at AS publish_at_4,
  p0_.image_name AS image_name_5,
  p0_.enabled AS enabled_6,
  p0_.author AS author_7,
  p0_.event_at AS event_at_8,
  p0_.translation_id AS translation_id_9,
  p0_.category_id AS category_id_10,
  p0_.created_by_id AS created_by_id_11
FROM
  post p0_
  INNER JOIN translation t1_ ON p0_.translation_id = t1_.id
WHERE
  p0_.enabled = 1
  AND p0_.publish_at <= ?
ORDER BY
  p0_.event_at DESC,
  p0_.publish_at DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.publish_at AS publish_at_4, p0_.image_name AS image_name_5, p0_.enabled AS enabled_6, p0_.author AS author_7, p0_.event_at AS event_at_8, p0_.translation_id AS translation_id_9, p0_.category_id AS category_id_10, p0_.created_by_id AS created_by_id_11 FROM post p0_ INNER JOIN translation t1_ ON p0_.translation_id = t1_.id WHERE p0_.enabled = 1 AND p0_.publish_at <= '2026-04-18 14:55:59' ORDER BY p0_.event_at DESC, p0_.publish_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 73)
7	App\Repository\PostRepository->findAllPublic (line 93)
8	App\Controller\SitemapController->sitemap (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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.

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\Translation	No errors.
App\Entity\PageCategory	No errors.
App\Entity\Bloc	No errors.
App\Entity\UsefulLink	No errors.
App\Entity\Post	No errors.
App\Entity\Category	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://staging.goldenfluteclassic.ch/fr/sitemap.xml

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping