GET https://www.fw-demoserver-1.de/nachrichten/nmz-berichtearchiv?page=2

Query Metrics

28 Database Queries
8 Different statements
29.97 ms Query time
0 Invalid entities
80 Managed entities

Grouped Statements

Show all queries

Time Count Info
22.32 ms
(74.48%)
21
SELECT t0.id AS id_1, t0.title AS title_2, t0.path AS path_3, t0.html_content AS html_content_4, t0.article_description AS article_description_5, t0.article_preview_slideshow_html AS article_preview_slideshow_html_6, t0.article_tag_ids AS article_tag_ids_7, t0.article AS article_8, t0.hide_current_information AS hide_current_information_9, t0.visibility AS visibility_10, t0.author AS author_11, t0.article_section AS article_section_12, t0.creation_time AS creation_time_13, t0.edit_time AS edit_time_14 FROM pages t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
  "landesverband"
]
1.94 ms
(6.48%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.path AS path_2, p0_.html_content AS html_content_3, p0_.article_description AS article_description_4, p0_.article_preview_slideshow_html AS article_preview_slideshow_html_5, p0_.article_tag_ids AS article_tag_ids_6, p0_.article AS article_7, p0_.hide_current_information AS hide_current_information_8, p0_.visibility AS visibility_9, p0_.author AS author_10, p0_.article_section AS article_section_11, p0_.creation_time AS creation_time_12, p0_.edit_time AS edit_time_13 FROM pages p0_ WHERE p0_.article = ? AND p0_.path <> ? AND p0_.visibility IN (?) AND p0_.article_section = ? ORDER BY p0_.creation_time DESC, p0_.edit_time DESC, p0_.id DESC LIMIT 20 OFFSET 20
Parameters:
[
  1
  "artikel"
  "all"
  "nmz_archive"
]
1.41 ms
(4.70%)
1
SELECT DISTINCT p0_.author AS author_0 FROM pages p0_ WHERE p0_.article = ? AND p0_.path <> ? AND p0_.visibility IN (?) AND p0_.author IS NOT NULL AND TRIM(p0_.author) <> ? AND p0_.article_section = ? ORDER BY p0_.author ASC
Parameters:
[
  1
  "artikel"
  "all"
  ""
  "nmz_archive"
]
1.39 ms
(4.63%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.path AS path_2, p0_.html_content AS html_content_3, p0_.article_description AS article_description_4, p0_.article_preview_slideshow_html AS article_preview_slideshow_html_5, p0_.article_tag_ids AS article_tag_ids_6, p0_.article AS article_7, p0_.hide_current_information AS hide_current_information_8, p0_.visibility AS visibility_9, p0_.author AS author_10, p0_.article_section AS article_section_11, p0_.creation_time AS creation_time_12, p0_.edit_time AS edit_time_13 FROM pages p0_ WHERE p0_.article = ? AND p0_.path <> ? AND p0_.visibility IN (?) ORDER BY p0_.creation_time DESC, p0_.edit_time DESC, p0_.id DESC LIMIT 3
Parameters:
[
  1
  "artikel"
  "all"
]
1.21 ms
(4.05%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM article_tag t0 ORDER BY t0.name ASC, t0.id ASC
Parameters:
[]
0.58 ms
(1.93%)
1
SELECT COUNT(p0_.id) AS sclr_0 FROM pages p0_ WHERE p0_.article = ? AND p0_.path <> ? AND p0_.visibility IN (?) AND p0_.article_section = ?
Parameters:
[
  1
  "artikel"
  "all"
  "nmz_archive"
]
0.58 ms
(1.92%)
1
SELECT t0.id AS id_1, t0.slot_key AS slot_key_2, t0.label AS label_3, t0.html_content AS html_content_4, t0.author AS author_5, t0.creation_time AS creation_time_6, t0.edit_time AS edit_time_7 FROM specialPages t0
Parameters:
[]
0.54 ms
(1.81%)
1
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.target_path AS target_path_2, m0_.sort_order AS sort_order_3, m1_.id AS id_4, m1_.name AS name_5, m1_.target_path AS target_path_6, m1_.sort_order AS sort_order_7, m0_.parent_id AS parent_id_8, m1_.parent_id AS parent_id_9 FROM Menu m0_ LEFT JOIN Menu m1_ ON m0_.parent_id = m1_.id ORDER BY m0_.sort_order ASC, m0_.id ASC
Parameters:
[]

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\Page 38
App\Entity\Menu 23
App\Entity\SpecialPage 17
App\Entity\ArticleTag 2

Entities Mapping

Class Mapping errors
App\Entity\ArticleTag No errors.
App\Entity\Page No errors.
App\Entity\Menu No errors.
App\Entity\SpecialPage No errors.