Query Metrics
11
Database Queries
4
Different statements
37.70 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 29.68 ms |
SELECT a.id FROM artikel AS a WHERE a.typ_id IN ('PR') AND ((a.status_id = 'publish' AND a.publish_at <= '2025-12-07 07:40:46')) ORDER BY a.publish_at DESC LIMIT 13 OFFSET 0
Parameters:
[] |
| 2 | 1.99 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:
[ "f8974c18-4c05-4bb7-98ef-f8870ab7eabf" "3c2cdaed-9127-4d9a-90d6-bd8fe72ee894" "46146ebc-6588-4a29-804a-3b839b76ecdd" "4b917ef0-4e04-4f6c-a314-8475a969b755" "a67ab41c-0bb5-4011-9b98-148a9d72a8fa" "eba709a2-e66b-493e-9675-7803de484534" ] |
| 3 | 0.85 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:
[
"3c2cdaed-9127-4d9a-90d6-bd8fe72ee894"
]
|
| 4 | 0.74 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:
[
"46146ebc-6588-4a29-804a-3b839b76ecdd"
]
|
| 5 | 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:
[
"4b917ef0-4e04-4f6c-a314-8475a969b755"
]
|
| 6 | 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:
[
"a67ab41c-0bb5-4011-9b98-148a9d72a8fa"
]
|
| 7 | 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:
[
"eba709a2-e66b-493e-9675-7803de484534"
]
|
| 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:
[
"f8974c18-4c05-4bb7-98ef-f8870ab7eabf"
]
|
| 9 | 0.68 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"
]
|
| 10 | 0.62 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"
]
|
| 11 | 0.63 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"
]
|
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. |