Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.rubrikname AS rubrikname_2,
  t0.beschreibung AS beschreibung_3
FROM
  vsrubrik t0
ORDER BY
  t0.rubrikname ASC

SELECT t0.id AS id_1, t0.rubrikname AS rubrikname_2, t0.beschreibung AS beschreibung_3 FROM vsrubrik t0 ORDER BY t0.rubrikname ASC;

SELECT
  id
FROM
  vs
WHERE
  (
    status_id IN (3)
  )
  AND (
    (
      typ_id = 1
      AND startdatum >= '2025-12-07'
      AND startdatum <= '2025-12-11'
    )
  )
ORDER BY
  startdatum asc,
  beginnzeit ASC

SELECT id FROM vs WHERE (status_id IN (3)) AND ((typ_id =1 AND startdatum >='2025-12-07' AND startdatum <='2025-12-11')) ORDER BY startdatum asc, beginnzeit ASC;

SELECT
  v0_.id AS id_0,
  v0_.typname AS typname_1,
  v1_.id AS id_2,
  v1_.uuid AS uuid_3,
  v1_.titel AS titel_4,
  v1_.adresse AS adresse_5,
  v1_.beschreibung AS beschreibung_6,
  v1_.beginnzeit AS beginnzeit_7,
  v1_.endzeit AS endzeit_8,
  v1_.startdatum AS startdatum_9,
  v1_.enddatum AS enddatum_10,
  v1_.url AS url_11,
  v1_.videolink AS videolink_12,
  v1_.googlemaps AS googlemaps_13,
  v1_.ticketsbestellen AS ticketsbestellen_14,
  v1_.export_uristier AS export_uristier_15,
  v1_.export_uw AS export_uw_16,
  v1_.export_1_enddatum AS export_1_enddatum_17,
  v1_.kveranstalter AS kveranstalter_18,
  v1_.kname AS kname_19,
  v1_.kvorname AS kvorname_20,
  v1_.kstrasse AS kstrasse_21,
  v1_.kplz AS kplz_22,
  v1_.kort AS kort_23,
  v1_.ktel AS ktel_24,
  v1_.kemail AS kemail_25,
  v1_.kkontaktieren AS kkontaktieren_26,
  v1_.kbemerkung AS kbemerkung_27,
  v1_.lastupdate AS lastupdate_28,
  v1_.vs_image AS vs_image_29,
  v2_.id AS id_30,
  v2_.aboname AS aboname_31,
  v2_.aboname_short AS aboname_short_32,
  v2_.max_length_vs_titel AS max_length_vs_titel_33,
  v2_.max_length_vs_beschreibung AS max_length_vs_beschreibung_34,
  v3_.id AS id_35,
  v3_.statusname AS statusname_36,
  v0_.id AS id_37,
  v0_.typname AS typname_38,
  v4_.id AS id_39,
  v4_.regionname AS regionname_40,
  v1_.region_id AS region_id_41,
  v1_.rubrik_id AS rubrik_id_42,
  v1_.status_id AS status_id_43,
  v1_.abo_id AS abo_id_44,
  v1_.typ_id AS typ_id_45,
  v1_.beginn_auswahl_id AS beginn_auswahl_id_46
FROM
  vs v1_
  LEFT JOIN vsabo v2_ ON v1_.abo_id = v2_.id
  LEFT JOIN vsstatus v3_ ON v1_.status_id = v3_.id
  LEFT JOIN vstyp v0_ ON v1_.typ_id = v0_.id
  LEFT JOIN vsregion v4_ ON v1_.region_id = v4_.id
WHERE
  v1_.id IN (
    14653, 14326, 13491, 13149, 14292, 12612,
    12583
  )

SELECT v0_.id AS id_0, v0_.typname AS typname_1, v1_.id AS id_2, v1_.uuid AS uuid_3, v1_.titel AS titel_4, v1_.adresse AS adresse_5, v1_.beschreibung AS beschreibung_6, v1_.beginnzeit AS beginnzeit_7, v1_.endzeit AS endzeit_8, v1_.startdatum AS startdatum_9, v1_.enddatum AS enddatum_10, v1_.url AS url_11, v1_.videolink AS videolink_12, v1_.googlemaps AS googlemaps_13, v1_.ticketsbestellen AS ticketsbestellen_14, v1_.export_uristier AS export_uristier_15, v1_.export_uw AS export_uw_16, v1_.export_1_enddatum AS export_1_enddatum_17, v1_.kveranstalter AS kveranstalter_18, v1_.kname AS kname_19, v1_.kvorname AS kvorname_20, v1_.kstrasse AS kstrasse_21, v1_.kplz AS kplz_22, v1_.kort AS kort_23, v1_.ktel AS ktel_24, v1_.kemail AS kemail_25, v1_.kkontaktieren AS kkontaktieren_26, v1_.kbemerkung AS kbemerkung_27, v1_.lastupdate AS lastupdate_28, v1_.vs_image AS vs_image_29, v2_.id AS id_30, v2_.aboname AS aboname_31, v2_.aboname_short AS aboname_short_32, v2_.max_length_vs_titel AS max_length_vs_titel_33, v2_.max_length_vs_beschreibung AS max_length_vs_beschreibung_34, v3_.id AS id_35, v3_.statusname AS statusname_36, v0_.id AS id_37, v0_.typname AS typname_38, v4_.id AS id_39, v4_.regionname AS regionname_40, v1_.region_id AS region_id_41, v1_.rubrik_id AS rubrik_id_42, v1_.status_id AS status_id_43, v1_.abo_id AS abo_id_44, v1_.typ_id AS typ_id_45, v1_.beginn_auswahl_id AS beginn_auswahl_id_46 FROM vs v1_ LEFT JOIN vsabo v2_ ON v1_.abo_id = v2_.id LEFT JOIN vsstatus v3_ ON v1_.status_id = v3_.id LEFT JOIN vstyp v0_ ON v1_.typ_id = v0_.id LEFT JOIN vsregion v4_ ON v1_.region_id = v4_.id WHERE v1_.id IN (14653, 14326, 13491, 13149, 14292, 12612, 12583);

SELECT
  id
FROM
  vs
WHERE
  (
    status_id IN (3)
  )
  AND (
    (
      typ_id = 2
      AND startdatum <= '2025-12-11'
      AND enddatum >= '2025-12-07'
    )
    OR (
      typ_id = 3
      AND startdatum <= '2025-12-11'
      AND enddatum >= '2025-12-07'
    )
  )
ORDER BY
  startdatum desc,
  beginnzeit ASC

SELECT id FROM vs WHERE (status_id IN (3)) AND ((typ_id =2 AND startdatum <= '2025-12-11' AND enddatum >= '2025-12-07') OR (typ_id =3 AND startdatum <= '2025-12-11' AND enddatum >= '2025-12-07')) ORDER BY startdatum desc, beginnzeit ASC;

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 = 'ACCORDION_VERANSTALTUNGEN' 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 = ?
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 = 'UW-AD-WIDEBOARD' 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 = ?
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 = 'UW-AD-WIDEBOARD-MOBILE' LIMIT 1;