Query Metrics
20
Database Queries
5
Different statements
91.23 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 78.22 ms |
SELECT a.id FROM artikel AS a WHERE a.typ_id IN ('FREE+') AND ((a.status_id = 'publish' AND a.publish_at <= '2025-12-07 07:38:24')) ORDER BY a.publish_at DESC LIMIT 13 OFFSET 0
Parameters:
[] |
| 2 | 1.35 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:
[ "a065ebbb-3740-4e4f-8b0d-70a320b3ebf2" "942fcc0d-b695-47cf-904f-0cfe7406f0f6" "892ebeeb-5416-43e2-b7c2-6ea69efa1de9" "9e40cb95-c930-496e-89d8-6ba1dbf2d09b" "c5ac1a94-b4dc-4b61-8936-3139b9de0199" "51bf65c2-0748-460b-b1ae-64a0929d4e1a" "15e0f576-eadc-4dd9-babc-6ef44e821476" "811f477f-529d-4750-9e9e-3bbb69d52785" "3991a294-f5f4-481c-b6d0-37776d408704" "4c9397d7-f8e5-4787-93ab-a11b31aefce5" "8c95e3b1-0755-4ef0-85a6-b17b2e517c34" "490a48c5-d56c-424a-ab9c-2cc03767cb77" "aa251c89-0f8b-415a-b657-09e8556a8307" ] |
| 3 | 0.84 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:
[
"15e0f576-eadc-4dd9-babc-6ef44e821476"
]
|
| 4 | 0.70 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:
[
"3991a294-f5f4-481c-b6d0-37776d408704"
]
|
| 5 | 0.55 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:
[
"490a48c5-d56c-424a-ab9c-2cc03767cb77"
]
|
| 6 | 0.72 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:
[
"4c9397d7-f8e5-4787-93ab-a11b31aefce5"
]
|
| 7 | 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:
[
"51bf65c2-0748-460b-b1ae-64a0929d4e1a"
]
|
| 8 | 0.72 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:
[
"811f477f-529d-4750-9e9e-3bbb69d52785"
]
|
| 9 | 0.69 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:
[
"892ebeeb-5416-43e2-b7c2-6ea69efa1de9"
]
|
| 10 | 0.60 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:
[
"dc5e1cc6-31e1-430b-8062-dd5d9bc43f9e"
]
|
| 11 | 0.65 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:
[
"8c95e3b1-0755-4ef0-85a6-b17b2e517c34"
]
|
| 12 | 0.57 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:
[
"942fcc0d-b695-47cf-904f-0cfe7406f0f6"
]
|
| 13 | 0.78 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:
[
"9e40cb95-c930-496e-89d8-6ba1dbf2d09b"
]
|
| 14 | 0.71 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:
[
"a065ebbb-3740-4e4f-8b0d-70a320b3ebf2"
]
|
| 15 | 0.70 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:
[
"aa251c89-0f8b-415a-b657-09e8556a8307"
]
|
| 16 | 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:
[
"c5ac1a94-b4dc-4b61-8936-3139b9de0199"
]
|
| 17 | 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-WIDEBOARD"
]
|
| 18 | 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"
]
|
| 19 | 0.52 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"
]
|
| 20 | 0.51 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"
]
|
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\Artikel\Artikel | No errors. |
| App\Entity\Dossier\Dossier | No errors. |
| App\Entity\Redaktor\Redaktor | No errors. |
| App\Entity\Content\Content | No errors. |