http://www.urnerwochenblatt.hostify2.webtech.ch/dossier/

Method
GET
HTTP Status
200
IP
172.18.0.5
Profiled on
Token
435600

Query Metrics

22 Database Queries
9 Different statements
18.76 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.56 ms 
SELECT t0.bezeichnung AS bezeichnung_1, t0.sort AS sort_2, t0.url_slug AS url_slug_3, t0.id AS id_4 FROM dossier t0 ORDER BY t0.sort ASC, t0.bezeichnung ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 2.13 ms 
SELECT a.id FROM artikel AS a WHERE a.dossier_id IN ('a026df08-2c4b-41bf-bd67-dfc81857247d') AND ((a.status_id = 'publish' AND a.publish_at <= '2025-12-07 07:36:38')) ORDER BY a.publish_at DESC LIMIT 2 OFFSET 0
Parameters: 
[]
View formatted query    View runnable query    Explain query
3 0.72 ms 
SELECT a0_.titel AS titel_0, a0_.spitzmarke AS spitzmarke_1, a0_.`lead` AS lead_2, a0_.contentHtml AS contentHtml_3, a0_.video_url AS video_url_4, a0_.rubrik_ids AS rubrik_ids_5, a0_.kanal_ids AS kanal_ids_6, a0_.status_id AS status_id_7, a0_.typ_id AS typ_id_8, a0_.assettyp_id AS assettyp_id_9, a0_.authored_at AS authored_at_10, a0_.publish_at AS publish_at_11, a0_.edit_at AS edit_at_12, a0_.storage_contents AS storage_contents_13, a0_.url_slug AS url_slug_14, a0_.is_lead_artikel AS is_lead_artikel_15, a0_.is_lead_gallery_artikel AS is_lead_gallery_artikel_16, a0_.pushed_to_twitter_at AS pushed_to_twitter_at_17, a0_.pr_pinned_until AS pr_pinned_until_18, a0_.id AS id_19, a0_.dossier_id AS dossier_id_20, a0_.redaktor_id AS redaktor_id_21 FROM artikel a0_ WHERE a0_.id IN (?, ?)
Parameters: 
[
  "ef7582a6-fc21-47d2-9b01-13f1583cfda6"
  "61bd3c89-bc53-464a-a78d-5b3957fd934f"
]
View formatted query    View runnable query    Explain query
4 0.67 ms 
SELECT t0.titel AS titel_1, t0.spitzmarke AS spitzmarke_2, t0.`lead` AS lead_3, t0.contentHtml AS contentHtml_4, t0.video_url AS video_url_5, t0.rubrik_ids AS rubrik_ids_6, t0.kanal_ids AS kanal_ids_7, t0.status_id AS status_id_8, t0.typ_id AS typ_id_9, t0.assettyp_id AS assettyp_id_10, t0.authored_at AS authored_at_11, t0.publish_at AS publish_at_12, t0.edit_at AS edit_at_13, t0.storage_contents AS storage_contents_14, t0.url_slug AS url_slug_15, t0.is_lead_artikel AS is_lead_artikel_16, t0.is_lead_gallery_artikel AS is_lead_gallery_artikel_17, t0.pushed_to_twitter_at AS pushed_to_twitter_at_18, t0.pr_pinned_until AS pr_pinned_until_19, t0.id AS id_20, t0.dossier_id AS dossier_id_21, t0.redaktor_id AS redaktor_id_22 FROM artikel t0 INNER JOIN lnk_artikel_artikel ON t0.id = lnk_artikel_artikel.verwandter_artikel_id WHERE lnk_artikel_artikel.artikel_id = ?
Parameters: 
[
  "61bd3c89-bc53-464a-a78d-5b3957fd934f"
]
View formatted query    View runnable query    Explain query
5 0.66 ms 
SELECT t0.titel AS titel_1, t0.spitzmarke AS spitzmarke_2, t0.`lead` AS lead_3, t0.contentHtml AS contentHtml_4, t0.video_url AS video_url_5, t0.rubrik_ids AS rubrik_ids_6, t0.kanal_ids AS kanal_ids_7, t0.status_id AS status_id_8, t0.typ_id AS typ_id_9, t0.assettyp_id AS assettyp_id_10, t0.authored_at AS authored_at_11, t0.publish_at AS publish_at_12, t0.edit_at AS edit_at_13, t0.storage_contents AS storage_contents_14, t0.url_slug AS url_slug_15, t0.is_lead_artikel AS is_lead_artikel_16, t0.is_lead_gallery_artikel AS is_lead_gallery_artikel_17, t0.pushed_to_twitter_at AS pushed_to_twitter_at_18, t0.pr_pinned_until AS pr_pinned_until_19, t0.id AS id_20, t0.dossier_id AS dossier_id_21, t0.redaktor_id AS redaktor_id_22 FROM artikel t0 INNER JOIN lnk_artikel_artikel ON t0.id = lnk_artikel_artikel.verwandter_artikel_id WHERE lnk_artikel_artikel.artikel_id = ?
Parameters: 
[
  "ef7582a6-fc21-47d2-9b01-13f1583cfda6"
]
View formatted query    View runnable query    Explain query
6 1.95 ms 
SELECT a.id FROM artikel AS a WHERE a.dossier_id IN ('92f7f68f-53b6-40e5-a52d-f5d4dec153a3') AND ((a.status_id = 'publish' AND a.publish_at <= '2025-12-07 07:36:38')) ORDER BY a.publish_at DESC LIMIT 2 OFFSET 0
Parameters: 
[]
View formatted query    View runnable query    Explain query
7 0.74 ms 
SELECT a0_.titel AS titel_0, a0_.spitzmarke AS spitzmarke_1, a0_.`lead` AS lead_2, a0_.contentHtml AS contentHtml_3, a0_.video_url AS video_url_4, a0_.rubrik_ids AS rubrik_ids_5, a0_.kanal_ids AS kanal_ids_6, a0_.status_id AS status_id_7, a0_.typ_id AS typ_id_8, a0_.assettyp_id AS assettyp_id_9, a0_.authored_at AS authored_at_10, a0_.publish_at AS publish_at_11, a0_.edit_at AS edit_at_12, a0_.storage_contents AS storage_contents_13, a0_.url_slug AS url_slug_14, a0_.is_lead_artikel AS is_lead_artikel_15, a0_.is_lead_gallery_artikel AS is_lead_gallery_artikel_16, a0_.pushed_to_twitter_at AS pushed_to_twitter_at_17, a0_.pr_pinned_until AS pr_pinned_until_18, a0_.id AS id_19, a0_.dossier_id AS dossier_id_20, a0_.redaktor_id AS redaktor_id_21 FROM artikel a0_ WHERE a0_.id IN (?, ?)
Parameters: 
[
  "5abd4e9b-7291-41e8-b8db-b889c64b5cfa"
  "6dd0bad2-95d1-41d0-978b-0a179238078e"
]
View formatted query    View runnable query    Explain query
8 0.61 ms 
SELECT t0.titel AS titel_1, t0.spitzmarke AS spitzmarke_2, t0.`lead` AS lead_3, t0.contentHtml AS contentHtml_4, t0.video_url AS video_url_5, t0.rubrik_ids AS rubrik_ids_6, t0.kanal_ids AS kanal_ids_7, t0.status_id AS status_id_8, t0.typ_id AS typ_id_9, t0.assettyp_id AS assettyp_id_10, t0.authored_at AS authored_at_11, t0.publish_at AS publish_at_12, t0.edit_at AS edit_at_13, t0.storage_contents AS storage_contents_14, t0.url_slug AS url_slug_15, t0.is_lead_artikel AS is_lead_artikel_16, t0.is_lead_gallery_artikel AS is_lead_gallery_artikel_17, t0.pushed_to_twitter_at AS pushed_to_twitter_at_18, t0.pr_pinned_until AS pr_pinned_until_19, t0.id AS id_20, t0.dossier_id AS dossier_id_21, t0.redaktor_id AS redaktor_id_22 FROM artikel t0 INNER JOIN lnk_artikel_artikel ON t0.id = lnk_artikel_artikel.verwandter_artikel_id WHERE lnk_artikel_artikel.artikel_id = ?
Parameters: 
[
  "5abd4e9b-7291-41e8-b8db-b889c64b5cfa"
]
View formatted query    View runnable query    Explain query
9 0.54 ms 
SELECT t0.titel AS titel_1, t0.spitzmarke AS spitzmarke_2, t0.`lead` AS lead_3, t0.contentHtml AS contentHtml_4, t0.video_url AS video_url_5, t0.rubrik_ids AS rubrik_ids_6, t0.kanal_ids AS kanal_ids_7, t0.status_id AS status_id_8, t0.typ_id AS typ_id_9, t0.assettyp_id AS assettyp_id_10, t0.authored_at AS authored_at_11, t0.publish_at AS publish_at_12, t0.edit_at AS edit_at_13, t0.storage_contents AS storage_contents_14, t0.url_slug AS url_slug_15, t0.is_lead_artikel AS is_lead_artikel_16, t0.is_lead_gallery_artikel AS is_lead_gallery_artikel_17, t0.pushed_to_twitter_at AS pushed_to_twitter_at_18, t0.pr_pinned_until AS pr_pinned_until_19, t0.id AS id_20, t0.dossier_id AS dossier_id_21, t0.redaktor_id AS redaktor_id_22 FROM artikel t0 INNER JOIN lnk_artikel_artikel ON t0.id = lnk_artikel_artikel.verwandter_artikel_id WHERE lnk_artikel_artikel.artikel_id = ?
Parameters: 
[
  "6dd0bad2-95d1-41d0-978b-0a179238078e"
]
View formatted query    View runnable query    Explain query
10 0.63 ms 
SELECT a.id FROM artikel AS a WHERE a.dossier_id IN ('b2941630-09ea-4a72-ab46-3d9c1869938e') AND ((a.status_id = 'publish' AND a.publish_at <= '2025-12-07 07:36:38')) ORDER BY a.publish_at DESC LIMIT 2 OFFSET 0
Parameters: 
[]
View formatted query    View runnable query    Explain query
11 0.60 ms 
SELECT a0_.titel AS titel_0, a0_.spitzmarke AS spitzmarke_1, a0_.`lead` AS lead_2, a0_.contentHtml AS contentHtml_3, a0_.video_url AS video_url_4, a0_.rubrik_ids AS rubrik_ids_5, a0_.kanal_ids AS kanal_ids_6, a0_.status_id AS status_id_7, a0_.typ_id AS typ_id_8, a0_.assettyp_id AS assettyp_id_9, a0_.authored_at AS authored_at_10, a0_.publish_at AS publish_at_11, a0_.edit_at AS edit_at_12, a0_.storage_contents AS storage_contents_13, a0_.url_slug AS url_slug_14, a0_.is_lead_artikel AS is_lead_artikel_15, a0_.is_lead_gallery_artikel AS is_lead_gallery_artikel_16, a0_.pushed_to_twitter_at AS pushed_to_twitter_at_17, a0_.pr_pinned_until AS pr_pinned_until_18, a0_.id AS id_19, a0_.dossier_id AS dossier_id_20, a0_.redaktor_id AS redaktor_id_21 FROM artikel a0_ WHERE a0_.id IN (?, ?)
Parameters: 
[
  "53f85b9e-7cc1-4b5c-8693-90a98b8cfe0e"
  "d0b38480-f3b5-4f61-9f3f-d6c5d9b4a4c2"
]
View formatted query    View runnable query    Explain query
12 0.82 ms 
SELECT t0.titel AS titel_1, t0.spitzmarke AS spitzmarke_2, t0.`lead` AS lead_3, t0.contentHtml AS contentHtml_4, t0.video_url AS video_url_5, t0.rubrik_ids AS rubrik_ids_6, t0.kanal_ids AS kanal_ids_7, t0.status_id AS status_id_8, t0.typ_id AS typ_id_9, t0.assettyp_id AS assettyp_id_10, t0.authored_at AS authored_at_11, t0.publish_at AS publish_at_12, t0.edit_at AS edit_at_13, t0.storage_contents AS storage_contents_14, t0.url_slug AS url_slug_15, t0.is_lead_artikel AS is_lead_artikel_16, t0.is_lead_gallery_artikel AS is_lead_gallery_artikel_17, t0.pushed_to_twitter_at AS pushed_to_twitter_at_18, t0.pr_pinned_until AS pr_pinned_until_19, t0.id AS id_20, t0.dossier_id AS dossier_id_21, t0.redaktor_id AS redaktor_id_22 FROM artikel t0 INNER JOIN lnk_artikel_artikel ON t0.id = lnk_artikel_artikel.verwandter_artikel_id WHERE lnk_artikel_artikel.artikel_id = ?
Parameters: 
[
  "53f85b9e-7cc1-4b5c-8693-90a98b8cfe0e"
]
View formatted query    View runnable query    Explain query
13 0.64 ms 
SELECT t0.titel AS titel_1, t0.spitzmarke AS spitzmarke_2, t0.`lead` AS lead_3, t0.contentHtml AS contentHtml_4, t0.video_url AS video_url_5, t0.rubrik_ids AS rubrik_ids_6, t0.kanal_ids AS kanal_ids_7, t0.status_id AS status_id_8, t0.typ_id AS typ_id_9, t0.assettyp_id AS assettyp_id_10, t0.authored_at AS authored_at_11, t0.publish_at AS publish_at_12, t0.edit_at AS edit_at_13, t0.storage_contents AS storage_contents_14, t0.url_slug AS url_slug_15, t0.is_lead_artikel AS is_lead_artikel_16, t0.is_lead_gallery_artikel AS is_lead_gallery_artikel_17, t0.pushed_to_twitter_at AS pushed_to_twitter_at_18, t0.pr_pinned_until AS pr_pinned_until_19, t0.id AS id_20, t0.dossier_id AS dossier_id_21, t0.redaktor_id AS redaktor_id_22 FROM artikel t0 INNER JOIN lnk_artikel_artikel ON t0.id = lnk_artikel_artikel.verwandter_artikel_id WHERE lnk_artikel_artikel.artikel_id = ?
Parameters: 
[
  "d0b38480-f3b5-4f61-9f3f-d6c5d9b4a4c2"
]
View formatted query    View runnable query    Explain query
14 0.52 ms 
SELECT t0.vorname AS vorname_1, t0.nachname AS nachname_2, t0.kurzzeichen AS kurzzeichen_3, t0.funktion AS funktion_4, t0.email AS email_5, t0.sort AS sort_6, t0.is_visible_on_frontend AS is_visible_on_frontend_7, t0.portrait_image AS portrait_image_8, t0.id AS id_9 FROM redaktor t0 WHERE t0.id = ?
Parameters: 
[
  "cca3b5cd-2372-49b8-8d7a-436732cf55e7"
]
View formatted query    View runnable query    Explain query
15 1.76 ms 
SELECT a.id FROM artikel AS a WHERE a.dossier_id IN ('6d94358c-80f3-4214-96b3-be35c042b78d') AND ((a.status_id = 'publish' AND a.publish_at <= '2025-12-07 07:36:38')) ORDER BY a.publish_at DESC LIMIT 2 OFFSET 0
Parameters: 
[]
View formatted query    View runnable query    Explain query
16 0.63 ms 
SELECT a0_.titel AS titel_0, a0_.spitzmarke AS spitzmarke_1, a0_.`lead` AS lead_2, a0_.contentHtml AS contentHtml_3, a0_.video_url AS video_url_4, a0_.rubrik_ids AS rubrik_ids_5, a0_.kanal_ids AS kanal_ids_6, a0_.status_id AS status_id_7, a0_.typ_id AS typ_id_8, a0_.assettyp_id AS assettyp_id_9, a0_.authored_at AS authored_at_10, a0_.publish_at AS publish_at_11, a0_.edit_at AS edit_at_12, a0_.storage_contents AS storage_contents_13, a0_.url_slug AS url_slug_14, a0_.is_lead_artikel AS is_lead_artikel_15, a0_.is_lead_gallery_artikel AS is_lead_gallery_artikel_16, a0_.pushed_to_twitter_at AS pushed_to_twitter_at_17, a0_.pr_pinned_until AS pr_pinned_until_18, a0_.id AS id_19, a0_.dossier_id AS dossier_id_20, a0_.redaktor_id AS redaktor_id_21 FROM artikel a0_ WHERE a0_.id IN (?, ?)
Parameters: 
[
  "3c76150f-21f8-4ea2-806d-0757bc345672"
  "8e42422f-bbab-479e-b1d6-7c5a49a52f6e"
]
View formatted query    View runnable query    Explain query
17 0.68 ms 
SELECT t0.titel AS titel_1, t0.spitzmarke AS spitzmarke_2, t0.`lead` AS lead_3, t0.contentHtml AS contentHtml_4, t0.video_url AS video_url_5, t0.rubrik_ids AS rubrik_ids_6, t0.kanal_ids AS kanal_ids_7, t0.status_id AS status_id_8, t0.typ_id AS typ_id_9, t0.assettyp_id AS assettyp_id_10, t0.authored_at AS authored_at_11, t0.publish_at AS publish_at_12, t0.edit_at AS edit_at_13, t0.storage_contents AS storage_contents_14, t0.url_slug AS url_slug_15, t0.is_lead_artikel AS is_lead_artikel_16, t0.is_lead_gallery_artikel AS is_lead_gallery_artikel_17, t0.pushed_to_twitter_at AS pushed_to_twitter_at_18, t0.pr_pinned_until AS pr_pinned_until_19, t0.id AS id_20, t0.dossier_id AS dossier_id_21, t0.redaktor_id AS redaktor_id_22 FROM artikel t0 INNER JOIN lnk_artikel_artikel ON t0.id = lnk_artikel_artikel.verwandter_artikel_id WHERE lnk_artikel_artikel.artikel_id = ?
Parameters: 
[
  "3c76150f-21f8-4ea2-806d-0757bc345672"
]
View formatted query    View runnable query    Explain query
18 0.59 ms 
SELECT t0.titel AS titel_1, t0.spitzmarke AS spitzmarke_2, t0.`lead` AS lead_3, t0.contentHtml AS contentHtml_4, t0.video_url AS video_url_5, t0.rubrik_ids AS rubrik_ids_6, t0.kanal_ids AS kanal_ids_7, t0.status_id AS status_id_8, t0.typ_id AS typ_id_9, t0.assettyp_id AS assettyp_id_10, t0.authored_at AS authored_at_11, t0.publish_at AS publish_at_12, t0.edit_at AS edit_at_13, t0.storage_contents AS storage_contents_14, t0.url_slug AS url_slug_15, t0.is_lead_artikel AS is_lead_artikel_16, t0.is_lead_gallery_artikel AS is_lead_gallery_artikel_17, t0.pushed_to_twitter_at AS pushed_to_twitter_at_18, t0.pr_pinned_until AS pr_pinned_until_19, t0.id AS id_20, t0.dossier_id AS dossier_id_21, t0.redaktor_id AS redaktor_id_22 FROM artikel t0 INNER JOIN lnk_artikel_artikel ON t0.id = lnk_artikel_artikel.verwandter_artikel_id WHERE lnk_artikel_artikel.artikel_id = ?
Parameters: 
[
  "8e42422f-bbab-479e-b1d6-7c5a49a52f6e"
]
View formatted query    View runnable query    Explain query
19 0.70 ms 
SELECT t0.code AS code_1, t0.contentHtml AS contentHtml_2, t0.content_html_editable AS content_html_editable_3, t0.content_text AS content_text_4, t0.content_text_editable AS content_text_editable_5, t0.content_description AS content_description_6, t0.content_image AS content_image_7, t0.content_image_editable AS content_image_editable_8, t0.edit_sysadmin_only AS edit_sysadmin_only_9, t0.is_visible_on_frontend AS is_visible_on_frontend_10, t0.edit_at AS edit_at_11, t0.id AS id_12 FROM content t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "UW-AD-WIDEBOARD"
]
View formatted query    View runnable query    Explain query
20 0.48 ms 
SELECT t0.code AS code_1, t0.contentHtml AS contentHtml_2, t0.content_html_editable AS content_html_editable_3, t0.content_text AS content_text_4, t0.content_text_editable AS content_text_editable_5, t0.content_description AS content_description_6, t0.content_image AS content_image_7, t0.content_image_editable AS content_image_editable_8, t0.edit_sysadmin_only AS edit_sysadmin_only_9, t0.is_visible_on_frontend AS is_visible_on_frontend_10, t0.edit_at AS edit_at_11, t0.id AS id_12 FROM content t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "UW-AD-WIDEBOARD-MOBILE"
]
View formatted query    View runnable query    Explain query
21 0.59 ms 
SELECT t0.code AS code_1, t0.contentHtml AS contentHtml_2, t0.content_html_editable AS content_html_editable_3, t0.content_text AS content_text_4, t0.content_text_editable AS content_text_editable_5, t0.content_description AS content_description_6, t0.content_image AS content_image_7, t0.content_image_editable AS content_image_editable_8, t0.edit_sysadmin_only AS edit_sysadmin_only_9, t0.is_visible_on_frontend AS is_visible_on_frontend_10, t0.edit_at AS edit_at_11, t0.id AS id_12 FROM content t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "UW-AD-RECTANGLE"
]
View formatted query    View runnable query    Explain query
22 0.54 ms 
SELECT t0.code AS code_1, t0.contentHtml AS contentHtml_2, t0.content_html_editable AS content_html_editable_3, t0.content_text AS content_text_4, t0.content_text_editable AS content_text_editable_5, t0.content_description AS content_description_6, t0.content_image AS content_image_7, t0.content_image_editable AS content_image_editable_8, t0.edit_sysadmin_only AS edit_sysadmin_only_9, t0.is_visible_on_frontend AS is_visible_on_frontend_10, t0.edit_at AS edit_at_11, t0.id AS id_12 FROM content t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "UW-AD-HALFPAGE"
]
View formatted query    View runnable query    Explain query

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.

Entities Mapping

Class Mapping errors
App\Entity\Dossier\Dossier No errors.
App\Entity\Artikel\Artikel No errors.
App\Entity\Redaktor\Redaktor No errors.
App\Entity\Content\Content No errors.