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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
5.20 ms
(27.75%)
8
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"
]
2.69 ms
(14.33%)
4
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"
]
2.31 ms
(12.30%)
4
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"
]
2.13 ms
(11.37%)
1
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:
[]
1.95 ms
(10.40%)
1
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:
[]
1.76 ms
(9.39%)
1
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:
[]
1.56 ms
(8.31%)
1
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:
[]
0.63 ms
(3.35%)
1
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:
[]
0.52 ms
(2.79%)
1
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"
]

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