Symfony Profiler

SELECT
  t0.titel AS titel_1,
  t0.img_logo AS img_logo_2,
  t0.img_banner AS img_banner_3,
  t0.adresse AS adresse_4,
  t0.rubriken AS rubriken_5,
  t0.zielgruppen AS zielgruppen_6,
  t0.html_head AS html_head_7,
  t0.html_footer AS html_footer_8,
  t0.dfxCss AS dfxCss_9,
  t0.lengthTeaser AS lengthTeaser_10,
  t0.maxLengthLead AS maxLengthLead_11,
  t0.maxLengthBeschreibung AS maxLengthBeschreibung_12,
  t0.itemsListe AS itemsListe_13,
  t0.dfxWidth AS dfxWidth_14,
  t0.dfxAlign AS dfxAlign_15,
  t0.imgWidth AS imgWidth_16,
  t0.imgHeight AS imgHeight_17,
  t0.imgPrevWidth AS imgPrevWidth_18,
  t0.imgPrevHeight AS imgPrevHeight_19,
  t0.navListe AS navListe_20,
  t0.navDetail AS navDetail_21,
  t0.navWidth AS navWidth_22,
  t0.archivTage AS archivTage_23,
  t0.navPos AS navPos_24,
  t0.filterKalender AS filterKalender_25,
  t0.filterRubrik AS filterRubrik_26,
  t0.filterZielgruppe AS filterZielgruppe_27,
  t0.filterDatum AS filterDatum_28,
  t0.filterSuche AS filterSuche_29,
  t0.filterNat AS filterNat_30,
  t0.filterPlzarea AS filterPlzarea_31,
  t0.filterUmkreis AS filterUmkreis_32,
  t0.filterOrt AS filterOrt_33,
  t0.filterRegion AS filterRegion_34,
  t0.filterLocation AS filterLocation_35,
  t0.filterVeranstalter AS filterVeranstalter_36,
  t0.filterDozenten AS filterDozenten_37,
  t0.feldSubtitel AS feldSubtitel_38,
  t0.feldLead AS feldLead_39,
  t0.feldBeschreibung AS feldBeschreibung_40,
  t0.feldEintritt AS feldEintritt_41,
  t0.feldImg AS feldImg_42,
  t0.feldGalerie AS feldGalerie_43,
  t0.feldVideo AS feldVideo_44,
  t0.imgListe AS imgListe_45,
  t0.feldPdf AS feldPdf_46,
  t0.feldMedia AS feldMedia_47,
  t0.feldNat AS feldNat_48,
  t0.feldRegion AS feldRegion_49,
  t0.feldPlz AS feldPlz_50,
  t0.feldOrt AS feldOrt_51,
  t0.feldOrtdb AS feldOrtdb_52,
  t0.feldKarten AS feldKarten_53,
  t0.feldAnmeldung AS feldAnmeldung_54,
  t0.feldPlatzlimit AS feldPlatzlimit_55,
  t0.showPlatzlimit AS showPlatzlimit_56,
  t0.feldLocation AS feldLocation_57,
  t0.feldVeranstalter AS feldVeranstalter_58,
  t0.feldDozenten AS feldDozenten_59,
  t0.feldLink AS feldLink_60,
  t0.feldTicketlink AS feldTicketlink_61,
  t0.feldOnlinetermin AS feldOnlinetermin_62,
  t0.showPlz AS showPlz_63,
  t0.showOrt AS showOrt_64,
  t0.showLokal AS showLokal_65,
  t0.showStrasse AS showStrasse_66,
  t0.allowInputAll AS allowInputAll_67,
  t0.allowPubAll AS allowPubAll_68,
  t0.allowPubMetaAll AS allowPubMetaAll_69,
  t0.allowPubGroupAll AS allowPubGroupAll_70,
  t0.PubMetaAll AS PubMetaAll_71,
  t0.PubGroupAll AS PubGroupAll_72,
  t0.InheritMeta AS InheritMeta_73,
  t0.InheritGroup AS InheritGroup_74,
  t0.InheritZielgruppenMeta AS InheritZielgruppenMeta_75,
  t0.InheritZielgruppenGroup AS InheritZielgruppenGroup_76,
  t0.infoToAdmin AS infoToAdmin_77,
  t0.sprache AS sprache_78,
  t0.allowSocial AS allowSocial_79,
  t0.allowRemind AS allowRemind_80,
  t0.allowMail AS allowMail_81,
  t0.allowExport AS allowExport_82,
  t0.allowPrint AS allowPrint_83,
  t0.useIcons AS useIcons_84,
  t0.useMap AS useMap_85,
  t0.allowApi AS allowApi_86,
  t0.maxApiItems AS maxApiItems_87,
  t0.pageApiItems AS pageApiItems_88,
  t0.initZoom AS initZoom_89,
  t0.dfxTpl AS dfxTpl_90,
  t0.dfxTplVersion AS dfxTplVersion_91,
  t0.dfxTplDetail AS dfxTplDetail_92,
  t0.zwueDatum AS zwueDatum_93,
  t0.dfxFarbe AS dfxFarbe_94,
  t0.dfxFarbeEigen AS dfxFarbeEigen_95,
  t0.dfxFarbeRaster AS dfxFarbeRaster_96,
  t0.dfxFarbeRasterEigen AS dfxFarbeRasterEigen_97,
  t0.bgDatefix AS bgDatefix_98,
  t0.bgNav AS bgNav_99,
  t0.trennzeichen AS trennzeichen_100,
  t0.dfxFontType AS dfxFontType_101,
  t0.dfxFontSize AS dfxFontSize_102,
  t0.dfxFontColor AS dfxFontColor_103,
  t0.ownFont AS ownFont_104,
  t0.paginationTop AS paginationTop_105,
  t0.paginationBottom AS paginationBottom_106,
  t0.dfxRadius AS dfxRadius_107,
  t0.isMeta AS isMeta_108,
  t0.isGroup AS isGroup_109,
  t0.toGroup AS toGroup_110,
  t0.frontendUrl AS frontendUrl_111,
  t0.datenschutzUrl AS datenschutzUrl_112,
  t0.impressumUrl AS impressumUrl_113,
  t0.id AS id_114,
  t0.user_id AS user_id_115
FROM
  pool_dfx_konf t0
WHERE
  t0.id = ?

SELECT t0.titel AS titel_1, t0.img_logo AS img_logo_2, t0.img_banner AS img_banner_3, t0.adresse AS adresse_4, t0.rubriken AS rubriken_5, t0.zielgruppen AS zielgruppen_6, t0.html_head AS html_head_7, t0.html_footer AS html_footer_8, t0.dfxCss AS dfxCss_9, t0.lengthTeaser AS lengthTeaser_10, t0.maxLengthLead AS maxLengthLead_11, t0.maxLengthBeschreibung AS maxLengthBeschreibung_12, t0.itemsListe AS itemsListe_13, t0.dfxWidth AS dfxWidth_14, t0.dfxAlign AS dfxAlign_15, t0.imgWidth AS imgWidth_16, t0.imgHeight AS imgHeight_17, t0.imgPrevWidth AS imgPrevWidth_18, t0.imgPrevHeight AS imgPrevHeight_19, t0.navListe AS navListe_20, t0.navDetail AS navDetail_21, t0.navWidth AS navWidth_22, t0.archivTage AS archivTage_23, t0.navPos AS navPos_24, t0.filterKalender AS filterKalender_25, t0.filterRubrik AS filterRubrik_26, t0.filterZielgruppe AS filterZielgruppe_27, t0.filterDatum AS filterDatum_28, t0.filterSuche AS filterSuche_29, t0.filterNat AS filterNat_30, t0.filterPlzarea AS filterPlzarea_31, t0.filterUmkreis AS filterUmkreis_32, t0.filterOrt AS filterOrt_33, t0.filterRegion AS filterRegion_34, t0.filterLocation AS filterLocation_35, t0.filterVeranstalter AS filterVeranstalter_36, t0.filterDozenten AS filterDozenten_37, t0.feldSubtitel AS feldSubtitel_38, t0.feldLead AS feldLead_39, t0.feldBeschreibung AS feldBeschreibung_40, t0.feldEintritt AS feldEintritt_41, t0.feldImg AS feldImg_42, t0.feldGalerie AS feldGalerie_43, t0.feldVideo AS feldVideo_44, t0.imgListe AS imgListe_45, t0.feldPdf AS feldPdf_46, t0.feldMedia AS feldMedia_47, t0.feldNat AS feldNat_48, t0.feldRegion AS feldRegion_49, t0.feldPlz AS feldPlz_50, t0.feldOrt AS feldOrt_51, t0.feldOrtdb AS feldOrtdb_52, t0.feldKarten AS feldKarten_53, t0.feldAnmeldung AS feldAnmeldung_54, t0.feldPlatzlimit AS feldPlatzlimit_55, t0.showPlatzlimit AS showPlatzlimit_56, t0.feldLocation AS feldLocation_57, t0.feldVeranstalter AS feldVeranstalter_58, t0.feldDozenten AS feldDozenten_59, t0.feldLink AS feldLink_60, t0.feldTicketlink AS feldTicketlink_61, t0.feldOnlinetermin AS feldOnlinetermin_62, t0.showPlz AS showPlz_63, t0.showOrt AS showOrt_64, t0.showLokal AS showLokal_65, t0.showStrasse AS showStrasse_66, t0.allowInputAll AS allowInputAll_67, t0.allowPubAll AS allowPubAll_68, t0.allowPubMetaAll AS allowPubMetaAll_69, t0.allowPubGroupAll AS allowPubGroupAll_70, t0.PubMetaAll AS PubMetaAll_71, t0.PubGroupAll AS PubGroupAll_72, t0.InheritMeta AS InheritMeta_73, t0.InheritGroup AS InheritGroup_74, t0.InheritZielgruppenMeta AS InheritZielgruppenMeta_75, t0.InheritZielgruppenGroup AS InheritZielgruppenGroup_76, t0.infoToAdmin AS infoToAdmin_77, t0.sprache AS sprache_78, t0.allowSocial AS allowSocial_79, t0.allowRemind AS allowRemind_80, t0.allowMail AS allowMail_81, t0.allowExport AS allowExport_82, t0.allowPrint AS allowPrint_83, t0.useIcons AS useIcons_84, t0.useMap AS useMap_85, t0.allowApi AS allowApi_86, t0.maxApiItems AS maxApiItems_87, t0.pageApiItems AS pageApiItems_88, t0.initZoom AS initZoom_89, t0.dfxTpl AS dfxTpl_90, t0.dfxTplVersion AS dfxTplVersion_91, t0.dfxTplDetail AS dfxTplDetail_92, t0.zwueDatum AS zwueDatum_93, t0.dfxFarbe AS dfxFarbe_94, t0.dfxFarbeEigen AS dfxFarbeEigen_95, t0.dfxFarbeRaster AS dfxFarbeRaster_96, t0.dfxFarbeRasterEigen AS dfxFarbeRasterEigen_97, t0.bgDatefix AS bgDatefix_98, t0.bgNav AS bgNav_99, t0.trennzeichen AS trennzeichen_100, t0.dfxFontType AS dfxFontType_101, t0.dfxFontSize AS dfxFontSize_102, t0.dfxFontColor AS dfxFontColor_103, t0.ownFont AS ownFont_104, t0.paginationTop AS paginationTop_105, t0.paginationBottom AS paginationBottom_106, t0.dfxRadius AS dfxRadius_107, t0.isMeta AS isMeta_108, t0.isGroup AS isGroup_109, t0.toGroup AS toGroup_110, t0.frontendUrl AS frontendUrl_111, t0.datenschutzUrl AS datenschutzUrl_112, t0.impressumUrl AS impressumUrl_113, t0.id AS id_114, t0.user_id AS user_id_115 FROM pool_dfx_konf t0 WHERE t0.id = 1;

SELECT
  p0_.nat AS nat_0
FROM
  pool_dfx_termine p0_
GROUP BY
  p0_.nat,
  p0_.user_id,
  p0_.id,
  p0_.user_id,
  p0_.id_location,
  p0_.id_veranstalter,
  p0_.id_ort,
  p0_.id_region,
  p0_.kalender_id
ORDER BY
  p0_.nat ASC

SELECT p0_.nat AS nat_0 FROM pool_dfx_termine p0_ GROUP BY p0_.nat, p0_.user_id, p0_.id, p0_.user_id, p0_.id_location, p0_.id_veranstalter, p0_.id_ort, p0_.id_region, p0_.kalender_id ORDER BY p0_.nat ASC;

SELECT
  p0_.ort AS ort_0
FROM
  pool_dfx_termine p0_
GROUP BY
  p0_.ort,
  p0_.user_id,
  p0_.id,
  p0_.user_id,
  p0_.id_location,
  p0_.id_veranstalter,
  p0_.id_ort,
  p0_.id_region,
  p0_.kalender_id
ORDER BY
  p0_.ort ASC

SELECT p0_.ort AS ort_0 FROM pool_dfx_termine p0_ GROUP BY p0_.ort, p0_.user_id, p0_.id, p0_.user_id, p0_.id_location, p0_.id_veranstalter, p0_.id_ort, p0_.id_region, p0_.kalender_id ORDER BY p0_.ort ASC;

SELECT
  p0_.lokal AS lokal_0
FROM
  pool_dfx_termine p0_
GROUP BY
  p0_.lokal,
  p0_.user_id,
  p0_.id,
  p0_.user_id,
  p0_.id_location,
  p0_.id_veranstalter,
  p0_.id_ort,
  p0_.id_region,
  p0_.kalender_id
ORDER BY
  p0_.lokal ASC

SELECT p0_.lokal AS lokal_0 FROM pool_dfx_termine p0_ GROUP BY p0_.lokal, p0_.user_id, p0_.id, p0_.user_id, p0_.id_location, p0_.id_veranstalter, p0_.id_ort, p0_.id_region, p0_.kalender_id ORDER BY p0_.lokal ASC;

SELECT
  p0_.veranstalter AS veranstalter_0
FROM
  pool_dfx_termine p0_
GROUP BY
  p0_.veranstalter,
  p0_.user_id,
  p0_.id,
  p0_.user_id,
  p0_.id_location,
  p0_.id_veranstalter,
  p0_.id_ort,
  p0_.id_region,
  p0_.kalender_id
ORDER BY
  p0_.veranstalter ASC

SELECT p0_.veranstalter AS veranstalter_0 FROM pool_dfx_termine p0_ GROUP BY p0_.veranstalter, p0_.user_id, p0_.id, p0_.user_id, p0_.id_location, p0_.id_veranstalter, p0_.id_ort, p0_.id_region, p0_.kalender_id ORDER BY p0_.veranstalter ASC;

SELECT
  p0_.datum_von AS datum_von_0
FROM
  pool_dfx_termine p0_
WHERE
  p0_.pub = 1
  AND p0_.pub_meta = 1
  AND (
    MONTH(p0_.datum_von) = ?
    AND YEAR(p0_.datum_von) = ?
  )
GROUP BY
  p0_.datum_von
ORDER BY
  p0_.datum_von ASC

SELECT p0_.datum_von AS datum_von_0 FROM pool_dfx_termine p0_ WHERE p0_.pub = 1 AND p0_.pub_meta = 1 AND (MONTH(p0_.datum_von) = 9 AND YEAR(p0_.datum_von) = 2904) GROUP BY p0_.datum_von ORDER BY p0_.datum_von ASC;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  pool_dfx_termine p0_
WHERE
  p0_.pub = 1
  AND p0_.pub_meta = 1
  AND (
    MONTH(p0_.datum_von) = ?
    AND YEAR(p0_.datum_von) = ?
  )

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM pool_dfx_termine p0_ WHERE p0_.pub = 1 AND p0_.pub_meta = 1 AND (MONTH(p0_.datum_von) = 9 AND YEAR(p0_.datum_von) = 2904);

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.datum_von AS datum_von_1,
  p0_.zeit AS zeit_2
FROM
  pool_dfx_termine p0_
WHERE
  p0_.pub = 1
  AND p0_.pub_meta = 1
  AND (
    MONTH(p0_.datum_von) = ?
    AND YEAR(p0_.datum_von) = ?
  )
ORDER BY
  p0_.datum_von ASC,
  p0_.zeit ASC
LIMIT
  20

SELECT DISTINCT p0_.id AS id_0, p0_.datum_von AS datum_von_1, p0_.zeit AS zeit_2 FROM pool_dfx_termine p0_ WHERE p0_.pub = 1 AND p0_.pub_meta = 1 AND (MONTH(p0_.datum_von) = 9 AND YEAR(p0_.datum_von) = 2904) ORDER BY p0_.datum_von ASC, p0_.zeit ASC LIMIT 20;

SELECT
  t0.dfx_day AS dfx_day_1,
  t0.nfx_day AS nfx_day_2,
  t0.dfx_sum AS dfx_sum_3,
  t0.nfx_sum AS nfx_sum_4,
  t0.dfx_api_day AS dfx_api_day_5,
  t0.dfx_api_sum AS dfx_api_sum_6,
  t0.dfx_datum_start AS dfx_datum_start_7,
  t0.dfx_last_log AS dfx_last_log_8,
  t0.nfx_last_log AS nfx_last_log_9,
  t0.dfx_status AS dfx_status_10,
  t0.init AS init_11,
  t0.id AS id_12,
  t0.kunden_id AS kunden_id_13,
  t0.user_id AS user_id_14,
  t0.kalender_id AS kalender_id_15
FROM
  pool_dfx_nfx_counter t0
WHERE
  t0.kalender_id = ?
LIMIT
  1

SELECT t0.dfx_day AS dfx_day_1, t0.nfx_day AS nfx_day_2, t0.dfx_sum AS dfx_sum_3, t0.nfx_sum AS nfx_sum_4, t0.dfx_api_day AS dfx_api_day_5, t0.dfx_api_sum AS dfx_api_sum_6, t0.dfx_datum_start AS dfx_datum_start_7, t0.dfx_last_log AS dfx_last_log_8, t0.nfx_last_log AS nfx_last_log_9, t0.dfx_status AS dfx_status_10, t0.init AS init_11, t0.id AS id_12, t0.kunden_id AS kunden_id_13, t0.user_id AS user_id_14, t0.kalender_id AS kalender_id_15 FROM pool_dfx_nfx_counter t0 WHERE t0.kalender_id = 1 LIMIT 1;

SELECT
  DAY(
    MAX(p0_.dfx_last_log)
  ) AS sclr_0
FROM
  pool_dfx_nfx_counter p0_

SELECT DAY(MAX(p0_.dfx_last_log)) AS sclr_0 FROM pool_dfx_nfx_counter p0_;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO pool_dfx_logs (ip, host, agent, zeit, kalender_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO pool_dfx_logs (ip, host, agent, zeit, kalender_id) VALUES ('172.22.3.23', 'dfx70.kalender-soest.de', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '2026-08-22 00:26:36', 1);

UPDATE
  pool_dfx_nfx_counter
SET
  dfx_day = ?,
  dfx_sum = ?,
  dfx_last_log = ?
WHERE
  id = ?

UPDATE pool_dfx_nfx_counter SET dfx_day = 207, dfx_sum = 3472763, dfx_last_log = '2026-08-22 00:26:36' WHERE id = 1;

"COMMIT"

"COMMIT";

SELECT
  p0_.dfx_day AS dfx_day_0,
  p0_.nfx_day AS nfx_day_1,
  p0_.dfx_sum AS dfx_sum_2,
  p0_.nfx_sum AS nfx_sum_3,
  p0_.dfx_api_day AS dfx_api_day_4,
  p0_.dfx_api_sum AS dfx_api_sum_5,
  p0_.dfx_datum_start AS dfx_datum_start_6,
  p0_.dfx_last_log AS dfx_last_log_7,
  p0_.nfx_last_log AS nfx_last_log_8,
  p0_.dfx_status AS dfx_status_9,
  p0_.init AS init_10,
  p0_.id AS id_11,
  p0_.kunden_id AS kunden_id_12,
  p0_.user_id AS user_id_13,
  p0_.kalender_id AS kalender_id_14
FROM
  pool_dfx_nfx_counter p0_
WHERE
  p0_.kalender_id > 0
  AND DATEDIFF(CURRENT_DATE, p0_.dfx_last_log) < 366
ORDER BY
  p0_.id ASC

SELECT p0_.dfx_day AS dfx_day_0, p0_.nfx_day AS nfx_day_1, p0_.dfx_sum AS dfx_sum_2, p0_.nfx_sum AS nfx_sum_3, p0_.dfx_api_day AS dfx_api_day_4, p0_.dfx_api_sum AS dfx_api_sum_5, p0_.dfx_datum_start AS dfx_datum_start_6, p0_.dfx_last_log AS dfx_last_log_7, p0_.nfx_last_log AS nfx_last_log_8, p0_.dfx_status AS dfx_status_9, p0_.init AS init_10, p0_.id AS id_11, p0_.kunden_id AS kunden_id_12, p0_.user_id AS user_id_13, p0_.kalender_id AS kalender_id_14 FROM pool_dfx_nfx_counter p0_ WHERE p0_.kalender_id > 0 AND DATEDIFF(CURRENT_DATE, p0_.dfx_last_log) < 366 ORDER BY p0_.id ASC;

SELECT
  p0_.datum AS datum_0,
  p0_.datum_von AS datum_von_1,
  p0_.datumSerie AS datumSerie_2,
  p0_.zeit AS zeit_3,
  p0_.zeit_bis AS zeit_bis_4,
  p0_.nat AS nat_5,
  p0_.plz AS plz_6,
  p0_.ort AS ort_7,
  p0_.lokal AS lokal_8,
  p0_.lokal_strasse AS lokal_strasse_9,
  p0_.lg AS lg_10,
  p0_.bg AS bg_11,
  p0_.veranstalter AS veranstalter_12,
  p0_.eintritt AS eintritt_13,
  p0_.rubrik AS rubrik_14,
  p0_.zielgruppe AS zielgruppe_15,
  p0_.titel AS titel_16,
  p0_.subtitel AS subtitel_17,
  p0_.lead AS lead_18,
  p0_.beschreibung AS beschreibung_19,
  p0_.status AS status_20,
  p0_.link AS link_21,
  p0_.linktext AS linktext_22,
  p0_.ticketlink AS ticketlink_23,
  p0_.ticketlinktext AS ticketlinktext_24,
  p0_.konferenzlink AS konferenzlink_25,
  p0_.konferenzlinktext AS konferenzlinktext_26,
  p0_.pdf AS pdf_27,
  p0_.pdflinktext AS pdflinktext_28,
  p0_.media AS media_29,
  p0_.medialinktext AS medialinktext_30,
  p0_.mediatyp AS mediatyp_31,
  p0_.img AS img_32,
  p0_.img2 AS img2_33,
  p0_.img3 AS img3_34,
  p0_.img4 AS img4_35,
  p0_.img5 AS img5_36,
  p0_.imgtext AS imgtext_37,
  p0_.imgcopyright AS imgcopyright_38,
  p0_.imgcopycheck AS imgcopycheck_39,
  p0_.imgtext2 AS imgtext2_40,
  p0_.imgcopyright2 AS imgcopyright2_41,
  p0_.imgcopycheck2 AS imgcopycheck2_42,
  p0_.video AS video_43,
  p0_.mail AS mail_44,
  p0_.mail_typ AS mail_typ_45,
  p0_.pub AS pub_46,
  p0_.pub_meta AS pub_meta_47,
  p0_.pub_group AS pub_group_48,
  p0_.code AS code_49,
  p0_.init AS init_50,
  p0_.extid AS extid_51,
  p0_.autor AS autor_52,
  p0_.online AS online_53,
  p0_.counter AS counter_54,
  p0_.nl AS nl_55,
  p0_.nl_sent AS nl_sent_56,
  p0_.serie AS serie_57,
  p0_.plaetze_gesamt AS plaetze_gesamt_58,
  p0_.plaetze_aktuell AS plaetze_aktuell_59,
  p0_.karten_tpl AS karten_tpl_60,
  p0_.karten_kat AS karten_kat_61,
  p0_.anmeldeschluss AS anmeldeschluss_62,
  p0_.archiv AS archiv_63,
  p0_.exportflag AS exportflag_64,
  p0_.filter_1 AS filter_1_65,
  p0_.filter_2 AS filter_2_66,
  p0_.filter_3 AS filter_3_67,
  p0_.filter_4 AS filter_4_68,
  p0_.filter_5 AS filter_5_69,
  p0_.filter_6 AS filter_6_70,
  p0_.filter_7 AS filter_7_71,
  p0_.filter_8 AS filter_8_72,
  p0_.filter_9 AS filter_9_73,
  p0_.filter_10 AS filter_10_74,
  p0_.filter_11 AS filter_11_75,
  p0_.filter_12 AS filter_12_76,
  p0_.filter_13 AS filter_13_77,
  p0_.filter_14 AS filter_14_78,
  p0_.filter_15 AS filter_15_79,
  p0_.text_1 AS text_1_80,
  p0_.text_2 AS text_2_81,
  p0_.text_3 AS text_3_82,
  p0_.text_4 AS text_4_83,
  p0_.text_5 AS text_5_84,
  p0_.text_6 AS text_6_85,
  p0_.text_7 AS text_7_86,
  p0_.text_8 AS text_8_87,
  p0_.text_9 AS text_9_88,
  p0_.text_10 AS text_10_89,
  p0_.textbox_1 AS textbox_1_90,
  p0_.textbox_2 AS textbox_2_91,
  p0_.options_radio AS options_radio_92,
  p0_.options_menue AS options_menue_93,
  p0_.options_checkboxes AS options_checkboxes_94,
  p0_.options_menue_multi AS options_menue_multi_95,
  p0_.datum_3 AS datum_3_96,
  p0_.datenschutz AS datenschutz_97,
  p0_.datum_input AS datum_input_98,
  p0_.datum_modified AS datum_modified_99,
  p0_.id AS id_100,
  p0_.user_id AS user_id_101,
  p0_.id_location AS id_location_102,
  p0_.id_veranstalter AS id_veranstalter_103,
  p0_.id_ort AS id_ort_104,
  p0_.id_region AS id_region_105,
  p0_.kalender_id AS kalender_id_106
FROM
  pool_dfx_termine p0_
WHERE
  p0_.kalender_id = ?
  AND DATEDIFF(CURRENT_DATE, p0_.datum) > ?
  AND p0_.archiv <> 1

SELECT p0_.datum AS datum_0, p0_.datum_von AS datum_von_1, p0_.datumSerie AS datumSerie_2, p0_.zeit AS zeit_3, p0_.zeit_bis AS zeit_bis_4, p0_.nat AS nat_5, p0_.plz AS plz_6, p0_.ort AS ort_7, p0_.lokal AS lokal_8, p0_.lokal_strasse AS lokal_strasse_9, p0_.lg AS lg_10, p0_.bg AS bg_11, p0_.veranstalter AS veranstalter_12, p0_.eintritt AS eintritt_13, p0_.rubrik AS rubrik_14, p0_.zielgruppe AS zielgruppe_15, p0_.titel AS titel_16, p0_.subtitel AS subtitel_17, p0_.lead AS lead_18, p0_.beschreibung AS beschreibung_19, p0_.status AS status_20, p0_.link AS link_21, p0_.linktext AS linktext_22, p0_.ticketlink AS ticketlink_23, p0_.ticketlinktext AS ticketlinktext_24, p0_.konferenzlink AS konferenzlink_25, p0_.konferenzlinktext AS konferenzlinktext_26, p0_.pdf AS pdf_27, p0_.pdflinktext AS pdflinktext_28, p0_.media AS media_29, p0_.medialinktext AS medialinktext_30, p0_.mediatyp AS mediatyp_31, p0_.img AS img_32, p0_.img2 AS img2_33, p0_.img3 AS img3_34, p0_.img4 AS img4_35, p0_.img5 AS img5_36, p0_.imgtext AS imgtext_37, p0_.imgcopyright AS imgcopyright_38, p0_.imgcopycheck AS imgcopycheck_39, p0_.imgtext2 AS imgtext2_40, p0_.imgcopyright2 AS imgcopyright2_41, p0_.imgcopycheck2 AS imgcopycheck2_42, p0_.video AS video_43, p0_.mail AS mail_44, p0_.mail_typ AS mail_typ_45, p0_.pub AS pub_46, p0_.pub_meta AS pub_meta_47, p0_.pub_group AS pub_group_48, p0_.code AS code_49, p0_.init AS init_50, p0_.extid AS extid_51, p0_.autor AS autor_52, p0_.online AS online_53, p0_.counter AS counter_54, p0_.nl AS nl_55, p0_.nl_sent AS nl_sent_56, p0_.serie AS serie_57, p0_.plaetze_gesamt AS plaetze_gesamt_58, p0_.plaetze_aktuell AS plaetze_aktuell_59, p0_.karten_tpl AS karten_tpl_60, p0_.karten_kat AS karten_kat_61, p0_.anmeldeschluss AS anmeldeschluss_62, p0_.archiv AS archiv_63, p0_.exportflag AS exportflag_64, p0_.filter_1 AS filter_1_65, p0_.filter_2 AS filter_2_66, p0_.filter_3 AS filter_3_67, p0_.filter_4 AS filter_4_68, p0_.filter_5 AS filter_5_69, p0_.filter_6 AS filter_6_70, p0_.filter_7 AS filter_7_71, p0_.filter_8 AS filter_8_72, p0_.filter_9 AS filter_9_73, p0_.filter_10 AS filter_10_74, p0_.filter_11 AS filter_11_75, p0_.filter_12 AS filter_12_76, p0_.filter_13 AS filter_13_77, p0_.filter_14 AS filter_14_78, p0_.filter_15 AS filter_15_79, p0_.text_1 AS text_1_80, p0_.text_2 AS text_2_81, p0_.text_3 AS text_3_82, p0_.text_4 AS text_4_83, p0_.text_5 AS text_5_84, p0_.text_6 AS text_6_85, p0_.text_7 AS text_7_86, p0_.text_8 AS text_8_87, p0_.text_9 AS text_9_88, p0_.text_10 AS text_10_89, p0_.textbox_1 AS textbox_1_90, p0_.textbox_2 AS textbox_2_91, p0_.options_radio AS options_radio_92, p0_.options_menue AS options_menue_93, p0_.options_checkboxes AS options_checkboxes_94, p0_.options_menue_multi AS options_menue_multi_95, p0_.datum_3 AS datum_3_96, p0_.datenschutz AS datenschutz_97, p0_.datum_input AS datum_input_98, p0_.datum_modified AS datum_modified_99, p0_.id AS id_100, p0_.user_id AS user_id_101, p0_.id_location AS id_location_102, p0_.id_veranstalter AS id_veranstalter_103, p0_.id_ort AS id_ort_104, p0_.id_region AS id_region_105, p0_.kalender_id AS kalender_id_106 FROM pool_dfx_termine p0_ WHERE p0_.kalender_id = 1 AND DATEDIFF(CURRENT_DATE, p0_.datum) > 30 AND p0_.archiv <> 1;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  pool_dfx_termine p0_
  INNER JOIN pool_dfx_konf p1_ ON p0_.kalender_id = p1_.id
WHERE
  p1_.id = ?
  AND p0_.id <> ?
  AND (
    p0_.img = ?
    OR p0_.img2 = ?
    OR p0_.img3 = ?
    OR p0_.img4 = ?
    OR p0_.img5 = ?
  )

SELECT COUNT(p0_.id) AS sclr_0 FROM pool_dfx_termine p0_ INNER JOIN pool_dfx_konf p1_ ON p0_.kalender_id = p1_.id WHERE p1_.id = 1 AND p0_.id <> 35127 AND (p0_.img = '17e2544d3e_Screenshot_20240424_154558_Instagram.jpg' OR p0_.img2 = '17e2544d3e_Screenshot_20240424_154558_Instagram.jpg' OR p0_.img3 = '17e2544d3e_Screenshot_20240424_154558_Instagram.jpg' OR p0_.img4 = '17e2544d3e_Screenshot_20240424_154558_Instagram.jpg' OR p0_.img5 = '17e2544d3e_Screenshot_20240424_154558_Instagram.jpg');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO pool_dfx_logs_tag (
  datum, hits, hits_api, kalender_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO pool_dfx_logs_tag (datum, hits, hits_api, kalender_id) VALUES ('2026-08-21', 207, 0, 1);

DELETE FROM
  pool_dfx_termine
WHERE
  id = ?

DELETE FROM pool_dfx_termine WHERE id = 35127;

"COMMIT"

"COMMIT";

SELECT
  t0.titel AS titel_1,
  t0.img_logo AS img_logo_2,
  t0.img_banner AS img_banner_3,
  t0.adresse AS adresse_4,
  t0.rubriken AS rubriken_5,
  t0.zielgruppen AS zielgruppen_6,
  t0.html_head AS html_head_7,
  t0.html_footer AS html_footer_8,
  t0.dfxCss AS dfxCss_9,
  t0.lengthTeaser AS lengthTeaser_10,
  t0.maxLengthLead AS maxLengthLead_11,
  t0.maxLengthBeschreibung AS maxLengthBeschreibung_12,
  t0.itemsListe AS itemsListe_13,
  t0.dfxWidth AS dfxWidth_14,
  t0.dfxAlign AS dfxAlign_15,
  t0.imgWidth AS imgWidth_16,
  t0.imgHeight AS imgHeight_17,
  t0.imgPrevWidth AS imgPrevWidth_18,
  t0.imgPrevHeight AS imgPrevHeight_19,
  t0.navListe AS navListe_20,
  t0.navDetail AS navDetail_21,
  t0.navWidth AS navWidth_22,
  t0.archivTage AS archivTage_23,
  t0.navPos AS navPos_24,
  t0.filterKalender AS filterKalender_25,
  t0.filterRubrik AS filterRubrik_26,
  t0.filterZielgruppe AS filterZielgruppe_27,
  t0.filterDatum AS filterDatum_28,
  t0.filterSuche AS filterSuche_29,
  t0.filterNat AS filterNat_30,
  t0.filterPlzarea AS filterPlzarea_31,
  t0.filterUmkreis AS filterUmkreis_32,
  t0.filterOrt AS filterOrt_33,
  t0.filterRegion AS filterRegion_34,
  t0.filterLocation AS filterLocation_35,
  t0.filterVeranstalter AS filterVeranstalter_36,
  t0.filterDozenten AS filterDozenten_37,
  t0.feldSubtitel AS feldSubtitel_38,
  t0.feldLead AS feldLead_39,
  t0.feldBeschreibung AS feldBeschreibung_40,
  t0.feldEintritt AS feldEintritt_41,
  t0.feldImg AS feldImg_42,
  t0.feldGalerie AS feldGalerie_43,
  t0.feldVideo AS feldVideo_44,
  t0.imgListe AS imgListe_45,
  t0.feldPdf AS feldPdf_46,
  t0.feldMedia AS feldMedia_47,
  t0.feldNat AS feldNat_48,
  t0.feldRegion AS feldRegion_49,
  t0.feldPlz AS feldPlz_50,
  t0.feldOrt AS feldOrt_51,
  t0.feldOrtdb AS feldOrtdb_52,
  t0.feldKarten AS feldKarten_53,
  t0.feldAnmeldung AS feldAnmeldung_54,
  t0.feldPlatzlimit AS feldPlatzlimit_55,
  t0.showPlatzlimit AS showPlatzlimit_56,
  t0.feldLocation AS feldLocation_57,
  t0.feldVeranstalter AS feldVeranstalter_58,
  t0.feldDozenten AS feldDozenten_59,
  t0.feldLink AS feldLink_60,
  t0.feldTicketlink AS feldTicketlink_61,
  t0.feldOnlinetermin AS feldOnlinetermin_62,
  t0.showPlz AS showPlz_63,
  t0.showOrt AS showOrt_64,
  t0.showLokal AS showLokal_65,
  t0.showStrasse AS showStrasse_66,
  t0.allowInputAll AS allowInputAll_67,
  t0.allowPubAll AS allowPubAll_68,
  t0.allowPubMetaAll AS allowPubMetaAll_69,
  t0.allowPubGroupAll AS allowPubGroupAll_70,
  t0.PubMetaAll AS PubMetaAll_71,
  t0.PubGroupAll AS PubGroupAll_72,
  t0.InheritMeta AS InheritMeta_73,
  t0.InheritGroup AS InheritGroup_74,
  t0.InheritZielgruppenMeta AS InheritZielgruppenMeta_75,
  t0.InheritZielgruppenGroup AS InheritZielgruppenGroup_76,
  t0.infoToAdmin AS infoToAdmin_77,
  t0.sprache AS sprache_78,
  t0.allowSocial AS allowSocial_79,
  t0.allowRemind AS allowRemind_80,
  t0.allowMail AS allowMail_81,
  t0.allowExport AS allowExport_82,
  t0.allowPrint AS allowPrint_83,
  t0.useIcons AS useIcons_84,
  t0.useMap AS useMap_85,
  t0.allowApi AS allowApi_86,
  t0.maxApiItems AS maxApiItems_87,
  t0.pageApiItems AS pageApiItems_88,
  t0.initZoom AS initZoom_89,
  t0.dfxTpl AS dfxTpl_90,
  t0.dfxTplVersion AS dfxTplVersion_91,
  t0.dfxTplDetail AS dfxTplDetail_92,
  t0.zwueDatum AS zwueDatum_93,
  t0.dfxFarbe AS dfxFarbe_94,
  t0.dfxFarbeEigen AS dfxFarbeEigen_95,
  t0.dfxFarbeRaster AS dfxFarbeRaster_96,
  t0.dfxFarbeRasterEigen AS dfxFarbeRasterEigen_97,
  t0.bgDatefix AS bgDatefix_98,
  t0.bgNav AS bgNav_99,
  t0.trennzeichen AS trennzeichen_100,
  t0.dfxFontType AS dfxFontType_101,
  t0.dfxFontSize AS dfxFontSize_102,
  t0.dfxFontColor AS dfxFontColor_103,
  t0.ownFont AS ownFont_104,
  t0.paginationTop AS paginationTop_105,
  t0.paginationBottom AS paginationBottom_106,
  t0.dfxRadius AS dfxRadius_107,
  t0.isMeta AS isMeta_108,
  t0.isGroup AS isGroup_109,
  t0.toGroup AS toGroup_110,
  t0.frontendUrl AS frontendUrl_111,
  t0.datenschutzUrl AS datenschutzUrl_112,
  t0.impressumUrl AS impressumUrl_113,
  t0.id AS id_114,
  t0.user_id AS user_id_115
FROM
  pool_dfx_konf t0
WHERE
  t0.id = ?