Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

10.36 ms Query time

0 Invalid entities

389 Managed entities

Queries

Group similar statements

#▲

Time

Info

3.51 ms

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_.date DESC, p0_.created_at DESC

Parameters:

[
  "konzerte-und-aktivitaeten"
]

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_.date DESC,
  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 = 'konzerte-und-aktivitaeten' ORDER BY p0_.date DESC, 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->findByPageOrderedByDate (line 70)
7	App\Controller\PageController->konzerteUndAktivitaeten (line 34)
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)

5.70 ms

SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.date AS date_2, k0_.location AS location_3, k0_.custom_songs AS custom_songs_4, k0_.song_order AS song_order_5, k0_.video_links AS video_links_6, k0_.plakat_path AS plakat_path_7, k0_.programm_vorderseite AS programm_vorderseite_8, k0_.programm_rueckseite AS programm_rueckseite_9, k0_.kritik_path AS kritik_path_10, k0_.song_notes AS song_notes_11, k0_.introduction AS introduction_12, s1_.id AS id_13, s1_.song_name AS song_name_14, s1_.composer AS composer_15, s1_.arrangeur AS arrangeur_16, s1_.composition_year AS composition_year_17, s1_.duration AS duration_18, s1_.background AS background_19, s1_.keywords AS keywords_20, s1_.etikett AS etikett_21, s1_.etikett_color AS etikett_color_22, s1_.etikett_number AS etikett_number_23, s1_.folder AS folder_24, s1_.dropboxlink AS dropboxlink_25, s1_.is_aktuelle_proben AS is_aktuelle_proben_26, s1_.aktuelle_dropboxlink AS aktuelle_dropboxlink_27, s1_.sort_order AS sort_order_28, s1_.parent_id AS parent_id_29 FROM konzert k0_ LEFT JOIN konzert_song k2_ ON k0_.id = k2_.konzert_id LEFT JOIN song s1_ ON s1_.id = k2_.song_id ORDER BY k0_.date DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  k0_.id AS id_0,
  k0_.name AS name_1,
  k0_.date AS date_2,
  k0_.location AS location_3,
  k0_.custom_songs AS custom_songs_4,
  k0_.song_order AS song_order_5,
  k0_.video_links AS video_links_6,
  k0_.plakat_path AS plakat_path_7,
  k0_.programm_vorderseite AS programm_vorderseite_8,
  k0_.programm_rueckseite AS programm_rueckseite_9,
  k0_.kritik_path AS kritik_path_10,
  k0_.song_notes AS song_notes_11,
  k0_.introduction AS introduction_12,
  s1_.id AS id_13,
  s1_.song_name AS song_name_14,
  s1_.composer AS composer_15,
  s1_.arrangeur AS arrangeur_16,
  s1_.composition_year AS composition_year_17,
  s1_.duration AS duration_18,
  s1_.background AS background_19,
  s1_.keywords AS keywords_20,
  s1_.etikett AS etikett_21,
  s1_.etikett_color AS etikett_color_22,
  s1_.etikett_number AS etikett_number_23,
  s1_.folder AS folder_24,
  s1_.dropboxlink AS dropboxlink_25,
  s1_.is_aktuelle_proben AS is_aktuelle_proben_26,
  s1_.aktuelle_dropboxlink AS aktuelle_dropboxlink_27,
  s1_.sort_order AS sort_order_28,
  s1_.parent_id AS parent_id_29
FROM
  konzert k0_
  LEFT JOIN konzert_song k2_ ON k0_.id = k2_.konzert_id
  LEFT JOIN song s1_ ON s1_.id = k2_.song_id
ORDER BY
  k0_.date DESC

SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.date AS date_2, k0_.location AS location_3, k0_.custom_songs AS custom_songs_4, k0_.song_order AS song_order_5, k0_.video_links AS video_links_6, k0_.plakat_path AS plakat_path_7, k0_.programm_vorderseite AS programm_vorderseite_8, k0_.programm_rueckseite AS programm_rueckseite_9, k0_.kritik_path AS kritik_path_10, k0_.song_notes AS song_notes_11, k0_.introduction AS introduction_12, s1_.id AS id_13, s1_.song_name AS song_name_14, s1_.composer AS composer_15, s1_.arrangeur AS arrangeur_16, s1_.composition_year AS composition_year_17, s1_.duration AS duration_18, s1_.background AS background_19, s1_.keywords AS keywords_20, s1_.etikett AS etikett_21, s1_.etikett_color AS etikett_color_22, s1_.etikett_number AS etikett_number_23, s1_.folder AS folder_24, s1_.dropboxlink AS dropboxlink_25, s1_.is_aktuelle_proben AS is_aktuelle_proben_26, s1_.aktuelle_dropboxlink AS aktuelle_dropboxlink_27, s1_.sort_order AS sort_order_28, s1_.parent_id AS parent_id_29 FROM konzert k0_ LEFT JOIN konzert_song k2_ ON k0_.id = k2_.konzert_id LEFT JOIN song s1_ ON s1_.id = k2_.song_id ORDER BY k0_.date 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\KonzertRepository->findAllOrdered (line 26)
7	App\Controller\PageController->konzerteUndAktivitaeten (line 35)
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.15 ms

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->konzerteUndAktivitaeten (line 57)
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\SongKeyword	262
App\Entity\Konzert	45
App\Entity\Post	44
App\Entity\User	38

Entities Mapping

Class	Mapping errors
App\Entity\Post	No errors.
App\Entity\Konzert	No errors.
App\Entity\SongKeyword	No errors.
App\Entity\Style	No errors.
App\Entity\SongLink	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://teutonia.kreilos.fr/konzerte-und-aktivitaeten

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping