Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

4.68 ms Query time

0 Invalid entities

38 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.56 ms
(54.70%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.subtitle AS subtitle_2, p0_.image_path AS image_path_3, p0_.paragraph AS paragraph_4, p0_.layout AS layout_5, p0_.is_main AS is_main_6, p0_.created_at AS created_at_7, p0_.page AS page_8, p0_.font_title AS font_title_9, p0_.font_title_size AS font_title_size_10, p0_.font_title_bold AS font_title_bold_11, p0_.font_title_italic AS font_title_italic_12, p0_.font_title_underline AS font_title_underline_13, p0_.font_subtitle AS font_subtitle_14, p0_.font_subtitle_size AS font_subtitle_size_15, p0_.font_subtitle_bold AS font_subtitle_bold_16, p0_.font_subtitle_italic AS font_subtitle_italic_17, p0_.font_subtitle_underline AS font_subtitle_underline_18, p0_.font_paragraph AS font_paragraph_19, p0_.font_paragraph_size AS font_paragraph_size_20, p0_.font_paragraph_bold AS font_paragraph_bold_21, p0_.font_paragraph_italic AS font_paragraph_italic_22, p0_.font_paragraph_underline AS font_paragraph_underline_23, p0_.position AS position_24, p0_.image_rotation AS image_rotation_25, p0_.date AS date_26 FROM post p0_ WHERE p0_.page = ? ORDER BY p0_.is_main DESC, p0_.position ASC, p0_.created_at DESC

Parameters:

[
  "unsere-naechsten-termine"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.subtitle AS subtitle_2,
  p0_.image_path AS image_path_3,
  p0_.paragraph AS paragraph_4,
  p0_.layout AS layout_5,
  p0_.is_main AS is_main_6,
  p0_.created_at AS created_at_7,
  p0_.page AS page_8,
  p0_.font_title AS font_title_9,
  p0_.font_title_size AS font_title_size_10,
  p0_.font_title_bold AS font_title_bold_11,
  p0_.font_title_italic AS font_title_italic_12,
  p0_.font_title_underline AS font_title_underline_13,
  p0_.font_subtitle AS font_subtitle_14,
  p0_.font_subtitle_size AS font_subtitle_size_15,
  p0_.font_subtitle_bold AS font_subtitle_bold_16,
  p0_.font_subtitle_italic AS font_subtitle_italic_17,
  p0_.font_subtitle_underline AS font_subtitle_underline_18,
  p0_.font_paragraph AS font_paragraph_19,
  p0_.font_paragraph_size AS font_paragraph_size_20,
  p0_.font_paragraph_bold AS font_paragraph_bold_21,
  p0_.font_paragraph_italic AS font_paragraph_italic_22,
  p0_.font_paragraph_underline AS font_paragraph_underline_23,
  p0_.position AS position_24,
  p0_.image_rotation AS image_rotation_25,
  p0_.date AS date_26
FROM
  post p0_
WHERE
  p0_.page = ?
ORDER BY
  p0_.is_main DESC,
  p0_.position ASC,
  p0_.created_at DESC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.subtitle AS subtitle_2, p0_.image_path AS image_path_3, p0_.paragraph AS paragraph_4, p0_.layout AS layout_5, p0_.is_main AS is_main_6, p0_.created_at AS created_at_7, p0_.page AS page_8, p0_.font_title AS font_title_9, p0_.font_title_size AS font_title_size_10, p0_.font_title_bold AS font_title_bold_11, p0_.font_title_italic AS font_title_italic_12, p0_.font_title_underline AS font_title_underline_13, p0_.font_subtitle AS font_subtitle_14, p0_.font_subtitle_size AS font_subtitle_size_15, p0_.font_subtitle_bold AS font_subtitle_bold_16, p0_.font_subtitle_italic AS font_subtitle_italic_17, p0_.font_subtitle_underline AS font_subtitle_underline_18, p0_.font_paragraph AS font_paragraph_19, p0_.font_paragraph_size AS font_paragraph_size_20, p0_.font_paragraph_bold AS font_paragraph_bold_21, p0_.font_paragraph_italic AS font_paragraph_italic_22, p0_.font_paragraph_underline AS font_paragraph_underline_23, p0_.position AS position_24, p0_.image_rotation AS image_rotation_25, p0_.date AS date_26 FROM post p0_ WHERE p0_.page = 'unsere-naechsten-termine' ORDER BY p0_.is_main DESC, p0_.position ASC, p0_.created_at DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\PostRepository->findByPage (line 59)
7	App\Controller\PageController->unsereTerrnine (line 93)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 14)

2.12 ms
(45.30%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.reset_token AS reset_token_8, t0.reset_token_expires_at AS reset_token_expires_at_9, t0.login_count AS login_count_10, t0.last_login_at AS last_login_at_11, t0.last_seen_at AS last_seen_at_12 FROM `user` t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.reset_token AS reset_token_8,
  t0.reset_token_expires_at AS reset_token_expires_at_9,
  t0.login_count AS login_count_10,
  t0.last_login_at AS last_login_at_11,
  t0.last_seen_at AS last_seen_at_12
FROM
  `user` t0

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.reset_token AS reset_token_8, t0.reset_token_expires_at AS reset_token_expires_at_9, t0.login_count AS login_count_10, t0.last_login_at AS last_login_at_11, t0.last_seen_at AS last_seen_at_12 FROM `user` t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Twig\AppExtension->getGlobals (line 18)
6	Twig\ExtensionSet->getGlobals (line 361)
7	Twig\Environment->getGlobals (line 908)
8	Twig\Template->yield (line 398)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
16	App\Controller\PageController->unsereTerrnine (line 92)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 14)

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
App\Entity\User	38

Entities Mapping

Class	Mapping errors
App\Entity\Post	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://teutonia.kreilos.fr/unsere-naechsten-termine

Configuration Settings

Theme

Page Width