Query Metrics
19
Database Queries
19
Different statements
452.49 ms
Query time
0
Invalid entities
331
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.49 ms |
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 = ?
Parameters:
[
1
]
|
| 2 | 1.29 ms |
SELECT t0.datum AS datum_1, t0.datum_von AS datum_von_2, t0.datumSerie AS datumSerie_3, t0.zeit AS zeit_4, t0.zeit_bis AS zeit_bis_5, t0.nat AS nat_6, t0.plz AS plz_7, t0.ort AS ort_8, t0.lokal AS lokal_9, t0.lokal_strasse AS lokal_strasse_10, t0.lg AS lg_11, t0.bg AS bg_12, t0.veranstalter AS veranstalter_13, t0.eintritt AS eintritt_14, t0.rubrik AS rubrik_15, t0.zielgruppe AS zielgruppe_16, t0.titel AS titel_17, t0.subtitel AS subtitel_18, t0.lead AS lead_19, t0.beschreibung AS beschreibung_20, t0.status AS status_21, t0.link AS link_22, t0.linktext AS linktext_23, t0.ticketlink AS ticketlink_24, t0.ticketlinktext AS ticketlinktext_25, t0.konferenzlink AS konferenzlink_26, t0.konferenzlinktext AS konferenzlinktext_27, t0.pdf AS pdf_28, t0.pdflinktext AS pdflinktext_29, t0.media AS media_30, t0.medialinktext AS medialinktext_31, t0.mediatyp AS mediatyp_32, t0.img AS img_33, t0.img2 AS img2_34, t0.img3 AS img3_35, t0.img4 AS img4_36, t0.img5 AS img5_37, t0.imgtext AS imgtext_38, t0.imgcopyright AS imgcopyright_39, t0.imgcopycheck AS imgcopycheck_40, t0.imgtext2 AS imgtext2_41, t0.imgcopyright2 AS imgcopyright2_42, t0.imgcopycheck2 AS imgcopycheck2_43, t0.video AS video_44, t0.mail AS mail_45, t0.mail_typ AS mail_typ_46, t0.pub AS pub_47, t0.pub_meta AS pub_meta_48, t0.pub_group AS pub_group_49, t0.code AS code_50, t0.init AS init_51, t0.extid AS extid_52, t0.autor AS autor_53, t0.online AS online_54, t0.counter AS counter_55, t0.nl AS nl_56, t0.nl_sent AS nl_sent_57, t0.serie AS serie_58, t0.plaetze_gesamt AS plaetze_gesamt_59, t0.plaetze_aktuell AS plaetze_aktuell_60, t0.karten_tpl AS karten_tpl_61, t0.karten_kat AS karten_kat_62, t0.anmeldeschluss AS anmeldeschluss_63, t0.archiv AS archiv_64, t0.exportflag AS exportflag_65, t0.filter_1 AS filter_1_66, t0.filter_2 AS filter_2_67, t0.filter_3 AS filter_3_68, t0.filter_4 AS filter_4_69, t0.filter_5 AS filter_5_70, t0.filter_6 AS filter_6_71, t0.filter_7 AS filter_7_72, t0.filter_8 AS filter_8_73, t0.filter_9 AS filter_9_74, t0.filter_10 AS filter_10_75, t0.filter_11 AS filter_11_76, t0.filter_12 AS filter_12_77, t0.filter_13 AS filter_13_78, t0.filter_14 AS filter_14_79, t0.filter_15 AS filter_15_80, t0.text_1 AS text_1_81, t0.text_2 AS text_2_82, t0.text_3 AS text_3_83, t0.text_4 AS text_4_84, t0.text_5 AS text_5_85, t0.text_6 AS text_6_86, t0.text_7 AS text_7_87, t0.text_8 AS text_8_88, t0.text_9 AS text_9_89, t0.text_10 AS text_10_90, t0.textbox_1 AS textbox_1_91, t0.textbox_2 AS textbox_2_92, t0.options_radio AS options_radio_93, t0.options_menue AS options_menue_94, t0.options_checkboxes AS options_checkboxes_95, t0.options_menue_multi AS options_menue_multi_96, t0.datum_3 AS datum_3_97, t0.datenschutz AS datenschutz_98, t0.datum_input AS datum_input_99, t0.datum_modified AS datum_modified_100, t0.id AS id_101, t0.user_id AS user_id_102, t0.id_location AS id_location_103, t0.id_veranstalter AS id_veranstalter_104, t0.id_ort AS id_ort_105, t0.id_region AS id_region_106, t0.kalender_id AS kalender_id_107 FROM pool_dfx_termine t0 WHERE t0.id = ?
Parameters:
[
48081
]
|
| 3 | 66.62 ms |
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
Parameters:
[] |
| 4 | 99.55 ms |
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
Parameters:
[] |
| 5 | 129.41 ms |
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
Parameters:
[] |
| 6 | 122.11 ms |
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
Parameters:
[] |
| 7 | 11.61 ms |
SELECT p0_.datum_von AS datum_von_0 FROM pool_dfx_termine p0_ WHERE p0_.kalender_id = ? AND 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
Parameters:
[ 1 2 2027 ] |
| 8 | 0.70 ms |
SELECT p0_.region AS region_0, p0_.id AS id_1, p0_.kalender_id AS kalender_id_2 FROM pool_dfx_region p0_ ORDER BY p0_.region ASC
Parameters:
[] |
| 9 | 7.17 ms |
SELECT p0_.name AS name_0, p0_.strasse AS strasse_1, p0_.nat AS nat_2, p0_.plz AS plz_3, p0_.ort AS ort_4, p0_.lg AS lg_5, p0_.bg AS bg_6, p0_.telefon AS telefon_7, p0_.mobil AS mobil_8, p0_.fax AS fax_9, p0_.email AS email_10, p0_.www AS www_11, p0_.ansprech AS ansprech_12, p0_.img_ver AS img_ver_13, p0_.img_ver_pos AS img_ver_pos_14, p0_.img2 AS img2_15, p0_.img3 AS img3_16, p0_.img4 AS img4_17, p0_.img5 AS img5_18, p0_.imgtext AS imgtext_19, p0_.imgcopyright AS imgcopyright_20, p0_.imgcopycheck AS imgcopycheck_21, p0_.zusatz AS zusatz_22, p0_.extid AS extid_23, p0_.code AS code_24, p0_.filter_1 AS filter_1_25, p0_.filter_2 AS filter_2_26, p0_.filter_3 AS filter_3_27, p0_.filter_4 AS filter_4_28, p0_.filter_5 AS filter_5_29, p0_.filter_6 AS filter_6_30, p0_.filter_7 AS filter_7_31, p0_.filter_8 AS filter_8_32, p0_.filter_9 AS filter_9_33, p0_.filter_10 AS filter_10_34, p0_.text_1 AS text_1_35, p0_.text_2 AS text_2_36, p0_.text_3 AS text_3_37, p0_.text_4 AS text_4_38, p0_.text_5 AS text_5_39, p0_.text_6 AS text_6_40, p0_.text_7 AS text_7_41, p0_.text_8 AS text_8_42, p0_.text_9 AS text_9_43, p0_.text_10 AS text_10_44, p0_.textbox_1 AS textbox_1_45, p0_.textbox_2 AS textbox_2_46, p0_.datum_input AS datum_input_47, p0_.datum_modified AS datum_modified_48, p0_.id AS id_49, p0_.id_region AS id_region_50, p0_.user_id AS user_id_51, p0_.id_ort AS id_ort_52, p0_.id_location AS id_location_53, p0_.kalender_id AS kalender_id_54 FROM pool_dfx_veranstalter p0_ ORDER BY p0_.name ASC
Parameters:
[] |
| 10 | 3.04 ms |
SELECT p0_.name AS name_0, p0_.strasse AS strasse_1, p0_.nat AS nat_2, p0_.plz AS plz_3, p0_.ort AS ort_4, p0_.lg AS lg_5, p0_.bg AS bg_6, p0_.telefon AS telefon_7, p0_.mobil AS mobil_8, p0_.fax AS fax_9, p0_.www AS www_10, p0_.ansprech AS ansprech_11, p0_.email AS email_12, p0_.raumnr AS raumnr_13, p0_.zusatz AS zusatz_14, p0_.img_loc AS img_loc_15, p0_.img_loc_pos AS img_loc_pos_16, p0_.img2 AS img2_17, p0_.img3 AS img3_18, p0_.img4 AS img4_19, p0_.img5 AS img5_20, p0_.imgtext AS imgtext_21, p0_.imgcopyright AS imgcopyright_22, p0_.imgcopycheck AS imgcopycheck_23, p0_.extid AS extid_24, p0_.code AS code_25, p0_.filter_1 AS filter_1_26, p0_.filter_2 AS filter_2_27, p0_.filter_3 AS filter_3_28, p0_.filter_4 AS filter_4_29, p0_.filter_5 AS filter_5_30, p0_.filter_6 AS filter_6_31, p0_.filter_7 AS filter_7_32, p0_.filter_8 AS filter_8_33, p0_.filter_9 AS filter_9_34, p0_.filter_10 AS filter_10_35, p0_.text_1 AS text_1_36, p0_.text_2 AS text_2_37, p0_.text_3 AS text_3_38, p0_.text_4 AS text_4_39, p0_.text_5 AS text_5_40, p0_.text_6 AS text_6_41, p0_.text_7 AS text_7_42, p0_.text_8 AS text_8_43, p0_.text_9 AS text_9_44, p0_.text_10 AS text_10_45, p0_.textbox_1 AS textbox_1_46, p0_.textbox_2 AS textbox_2_47, p0_.datum_input AS datum_input_48, p0_.datum_modified AS datum_modified_49, p0_.id AS id_50, p0_.id_region AS id_region_51, p0_.id_ort AS id_ort_52, p0_.id_veranstalter AS id_veranstalter_53, p0_.kalender_id AS kalender_id_54, p0_.user_id AS user_id_55 FROM pool_dfx_location p0_ ORDER BY p0_.name ASC
Parameters:
[] |
| 11 | 1.45 ms |
SELECT p0_.datum_von AS datum_von_0, p0_.zeit AS zeit_1, p0_.id AS id_2, p0_.user_id AS user_id_3, p0_.id_location AS id_location_4, p0_.id_veranstalter AS id_veranstalter_5, p0_.id_ort AS id_ort_6, p0_.id_region AS id_region_7, p0_.kalender_id AS kalender_id_8 FROM pool_dfx_termine p0_ WHERE p0_.code = ? AND p0_.datum_von >= CURRENT_DATE ORDER BY p0_.datum_von ASC LIMIT 20
Parameters:
[
"2dfVAyb0Yvh3oROT6pas"
]
|
| 12 | 0.74 ms |
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
Parameters:
[
1
]
|
| 13 | 2.29 ms |
SELECT DAY(MAX(p0_.dfx_last_log)) AS sclr_0 FROM pool_dfx_nfx_counter p0_
Parameters:
[] |
| 14 | 0.68 ms |
"START TRANSACTION"
Parameters:
[] |
| 15 | 0.82 ms |
INSERT INTO pool_dfx_logs (ip, host, agent, zeit, kalender_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "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-04-25 02:03:04" 1 ] |
| 16 | 0.80 ms |
UPDATE pool_dfx_termine SET counter = ? WHERE id = ?
Parameters:
[ 225 48081 ] |
| 17 | 0.63 ms |
UPDATE pool_dfx_nfx_counter SET dfx_day = ?, dfx_sum = ?, dfx_last_log = ? WHERE id = ?
Parameters:
[ 988 2984858 "2026-04-25 02:03:04" 1 ] |
| 18 | 1.16 ms |
"COMMIT"
Parameters:
[] |
| 19 | 0.93 ms |
SELECT p0_.kurztitel AS kurztitel_0, p0_.id AS id_1 FROM pool_dfx_news p0_ WHERE p0_.menueeintrag = 1 AND p0_.kalender_id = ? AND p0_.pub = 1 ORDER BY p0_.reihenfolge ASC
Parameters:
[
1
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\DfxVeranstalter | 126 |
| App\Entity\DfxLocation | 125 |
| App\Entity\DfxNfxUser | 28 |
| App\Entity\DfxKonf | 23 |
| App\Entity\DfxTermine | 20 |
| App\Entity\DfxRegion | 6 |
| App\Entity\DfxNfxCounter | 1 |
| App\Entity\DfxNfxKunden | 1 |
| App\Entity\DfxLogs | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\DfxKonf | No errors. |
| App\Entity\DfxNfxUser | No errors. |
| App\Entity\DfxTermine | No errors. |
| App\Entity\DfxLocation | No errors. |
| App\Entity\DfxVeranstalter | No errors. |
| App\Entity\DfxOrte | No errors. |
| App\Entity\DfxRegion | No errors. |
| App\Entity\DfxNfxCounter | No errors. |
| App\Entity\DfxNfxKunden | No errors. |
| App\Entity\DfxLogs | No errors. |
| App\Entity\DfxNews | No errors. |