GET https://www.fw-demoserver-1.de/nachrichten?page=7&tag%5B0%5D=6

Query Metrics

27 Database Queries
7 Different statements
26.51 ms Query time
0 Invalid entities
77 Managed entities

Queries

Group similar statements

# Time Info
1 1.45 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM article_tag t0 ORDER BY t0.name ASC, t0.id ASC
Parameters:
[]
2 1.63 ms
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) <> ? ORDER BY p0_.author ASC
Parameters:
[
  1
  "artikel"
  "all"
  ""
]
3 1.59 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM pages p0_ WHERE p0_.article = ? AND p0_.path <> ? AND p0_.visibility IN (?) AND ((p0_.article_tag_ids = ? OR p0_.article_tag_ids LIKE ? OR p0_.article_tag_ids LIKE ? OR p0_.article_tag_ids LIKE ?))
Parameters:
[
  1
  "artikel"
  "all"
  "[6]"
  "[6,%"
  "%,6,%"
  "%,6]"
]
4 3.19 ms
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_tag_ids = ? OR p0_.article_tag_ids LIKE ? OR p0_.article_tag_ids LIKE ? OR p0_.article_tag_ids LIKE ?)) ORDER BY p0_.creation_time DESC, p0_.edit_time DESC, p0_.id DESC LIMIT 20 OFFSET 120
Parameters:
[
  1
  "artikel"
  "all"
  "[6]"
  "[6,%"
  "%,6,%"
  "%,6]"
]
5 1.23 ms
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:
[]
6 0.76 ms
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"
]
7 0.64 ms
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:
[
  "leistungen"
]
8 0.66 ms
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/vorstand"
]
9 0.53 ms
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/mitarbeiter"
]
10 0.63 ms
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/rechtliche_bestimmungen"
]
11 0.71 ms
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:
[
  "bezirksgruppen"
]
12 0.53 ms
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:
[
  "bezirksgruppen/braunschweig"
]
13 0.50 ms
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:
[
  "bezirksgruppen/goettingen"
]
14 1.14 ms
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:
[
  "bezirksgruppen/hannover"
]
15 1.25 ms
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:
[
  "bezirksgruppen/nordost"
]
16 0.78 ms
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:
[
  "bezirksgruppen/nordwest"
]
17 0.64 ms
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:
[
  "bezirksgruppen/osnabrueck"
]
18 0.85 ms
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:
[
  "nachrichten"
]
19 1.09 ms
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:
[
  "nachrichten/zur-diskussion"
]
20 1.17 ms
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:
[
  "nachrichten/veranstaltungen-der-zentrale"
]
21 1.10 ms
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:
[
  "nachrichten/aus-den-bezirksgruppen"
]
22 1.03 ms
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:
[
  "nachrichten/nmz-berichtearchiv"
]
23 0.98 ms
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:
[
  "musikersuche"
]
24 0.62 ms
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:
[
  "mitglied-werden"
]
25 0.47 ms
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:
[
  "kontakt"
]
26 0.66 ms
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:
[
  "fuer-mitglieder"
]
27 0.67 ms
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:
[]

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 35
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.