Symfony Profiler

SELECT
  a.id
FROM
  artikel AS a
WHERE
  a.typ_id IN ('PR')
  AND a.pr_pinned_until >= CURDATE()
  AND (
    a.kanal_ids IS NULL
    OR a.kanal_ids NOT LIKE '%"NOT_IN_ART_STREAM_HOMEPAGE"%'
  )
  AND (
    (
      a.status_id = 'publish'
      AND a.publish_at <= '2025-12-07 04:45:19'
    )
  )
LIMIT
  101
OFFSET
  0

SELECT a.id FROM artikel AS a WHERE a.typ_id IN ('PR') AND a.pr_pinned_until >= CURDATE() AND (a.kanal_ids IS NULL   OR   a.kanal_ids NOT LIKE '%"NOT_IN_ART_STREAM_HOMEPAGE"%') AND ((a.status_id = 'publish' AND a.publish_at <= '2025-12-07 04:45:19'))  LIMIT 101 OFFSET 0;

SELECT
  a.id
FROM
  artikel AS a
WHERE
  a.typ_id IN ('FREE', 'UW+')
  AND (
    a.kanal_ids IS NULL
    OR a.kanal_ids NOT LIKE '%"NOT_IN_ART_STREAM_HOMEPAGE"%'
  )
  AND (
    (
      a.status_id = 'publish'
      AND a.publish_at <= '2025-12-07 04:45:19'
    )
  )
ORDER BY
  a.publish_at DESC
LIMIT
  7
OFFSET
  0

SELECT a.id FROM artikel AS a WHERE a.typ_id IN ('FREE', 'UW+') AND (a.kanal_ids IS NULL   OR   a.kanal_ids NOT LIKE '%"NOT_IN_ART_STREAM_HOMEPAGE"%') AND ((a.status_id = 'publish' AND a.publish_at <= '2025-12-07 04:45:19')) ORDER BY a.publish_at DESC LIMIT 7 OFFSET 0;

SELECT
  a.id
FROM
  artikel AS a
WHERE
  (
    a.video_url IS NOT NULL
    OR a.video_url <> ''
    OR a.assettyp_id = 'IMAGE_GALLERY'
  )
  AND a.typ_id NOT IN ('PR')
  AND (
    (
      a.status_id = 'publish'
      AND a.publish_at <= '2025-12-07 04:45:19'
    )
  )
ORDER BY
  a.publish_at DESC
LIMIT
  4
OFFSET
  0

SELECT a.id FROM artikel AS a WHERE (a.video_url IS NOT NULL  OR  a.video_url <> ''  OR  a.assettyp_id = 'IMAGE_GALLERY') AND a.typ_id NOT IN ('PR') AND ((a.status_id = 'publish' AND a.publish_at <= '2025-12-07 04:45:19')) ORDER BY a.publish_at DESC LIMIT 4 OFFSET 0;

SELECT
  a.id
FROM
  artikel AS a
WHERE
  (
    (
      a.status_id = 'publish'
      AND a.publish_at <= '2025-12-07 04:45:19'
    )
  )
  AND (
    (a.is_lead_gallery_artikel = 1)
  )
ORDER BY
  a.publish_at DESC
LIMIT
  4
OFFSET
  0

SELECT a.id FROM artikel AS a WHERE ((a.status_id = 'publish' AND a.publish_at <= '2025-12-07 04:45:19')) AND ((a.is_lead_gallery_artikel = 1)) ORDER BY a.publish_at DESC LIMIT 4 OFFSET 0;

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 = ?

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 = '2572a41d-6970-4f4f-b7e3-cb4b2fe0f567';

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

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 = 'SERVICE_BOX_VERANSTALTUNGEN' LIMIT 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 = ?

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 = '5a465634-bfa0-4b30-9d5a-f756d6be1e20';

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 (?, ?, ?, ?, ?, ?, ?)

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 ('c47fff1e-2edc-4c9b-a5c4-8962502aad33', '274a6d97-aead-474a-ae27-184420a72c10', '80b0c058-6c61-4a84-b712-f80cf99d9377', '7ce33ec4-5532-4403-9bc5-029a70825747', '2572a41d-6970-4f4f-b7e3-cb4b2fe0f567', '917b7aa4-e7de-474c-9fc5-4f1927a6d17a', 'cd554a45-5b1b-4c7f-a539-3757688d2285');

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 (?, ?, ?, ?)

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 ('47ef7ec4-d34f-4f03-9721-2e5aa2eebbb0', '50a3301f-0aac-4168-8d1e-e5bc7828ad07', '80b0f049-e652-43a5-b80e-1ae745afcfda', '4d91461b-8cb3-4f39-80b4-9ae444e96699');