Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.46 ms Query time

0 Invalid entities

41 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.32 ms
(53.66%)

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:

[
  "geselliges"
]

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 = 'geselliges' 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->geselliges (line 101)
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)

1.14 ms
(46.34%)

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->geselliges (line 100)
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
App\Entity\Post	3

Entities Mapping

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

Symfony Profiler

GET https://teutonia.kreilos.fr/geselliges

Configuration Settings

Theme

Page Width