https://datefix.hotze-fussball.de/js/kalender?cb%3Dall%26dfxp%3D6%26filter%3D=&dfxp=9&filter=

Query Metrics

15 Database Queries
15 Different statements
25.51 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
10.05 ms
(39.38%)
1
SELECT p0_.nat AS nat_0 FROM pool_dfx_termine p0_ WHERE p0_.pub = 1 AND p0_.kalender_id IN (?) AND p0_.pub_group = 1 GROUP BY p0_.nat, p0_.id ORDER BY p0_.nat ASC
Parameters:
[
  [
    1
    1
  ]
]
2.47 ms
(9.67%)
1
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM pool_dfx_termine p0_ WHERE p0_.kalender_id IN (?) AND p0_.pub = 1 AND p0_.datum_von >= CURRENT_DATE
Parameters:
[
  [
    1
  ]
]
2.33 ms
(9.13%)
1
INSERT INTO pool_dfx_logs (ip, host, agent, zeit, kalender_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  1 => "85.13.162.66"
  2 => "datefix.hotze-fussball.de"
  3 => "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (HTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
  4 => "2026-11-16 02:36:46"
  5 => 1
]
1.87 ms
(7.33%)
1
SELECT p0_.datum_von AS datum_von_0 FROM pool_dfx_termine p0_ WHERE p0_.kalender_id IN (?) AND p0_.pub = 1 AND (MONTH(p0_.datum_von) = ? AND YEAR(p0_.datum_von) = ?) GROUP BY p0_.datum_von ORDER BY p0_.datum_von ASC
Parameters:
[
  [
    1
  ]
  "11"
  "2026"
]
1.65 ms
(6.46%)
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.konto AS konto_5, t0.nfx_konto AS nfx_konto_6, t0.rss_dfx_day AS rss_dfx_day_7, t0.rss_nfx_day AS rss_nfx_day_8, t0.rss_dfx_sum AS rss_dfx_sum_9, t0.rss_nfx_sum AS rss_nfx_sum_10, t0.rss_konto AS rss_konto_11, t0.dfx_datum_start AS dfx_datum_start_12, t0.nfx_datum_start AS nfx_datum_start_13, t0.dfx_datum_ende AS dfx_datum_ende_14, t0.nfx_datum_ende AS nfx_datum_ende_15, t0.dfx_version AS dfx_version_16, t0.nfx_version AS nfx_version_17, t0.banner_pos AS banner_pos_18, t0.banner_group AS banner_group_19, t0.banner_country AS banner_country_20, t0.banner_typ AS banner_typ_21, t0.dfx_last_log AS dfx_last_log_22, t0.nfx_last_log AS nfx_last_log_23, t0.dfx_status AS dfx_status_24, t0.nfx_status AS nfx_status_25, t0.init AS init_26, t0.id AS id_27, t0.kunden_id AS kunden_id_28, t0.user_id AS user_id_29, t0.kalender_id AS kalender_id_30 FROM pool_dfx_nfx_counter t0 WHERE t0.kalender_id = ? LIMIT 1
Parameters:
[
  1
]
1.37 ms
(5.39%)
1
SELECT p0_.veranstalter AS veranstalter_0 FROM pool_dfx_termine p0_ WHERE p0_.pub = 1 AND p0_.kalender_id IN (?) AND p0_.pub_group = 1 GROUP BY p0_.veranstalter, p0_.id ORDER BY p0_.veranstalter ASC
Parameters:
[
  [
    1
    1
  ]
]
1.28 ms
(5.00%)
1
SELECT t0.titel AS titel_1, t0.kuerzel AS kuerzel_2, t0.img_logo AS img_logo_3, t0.adresse AS adresse_4, t0.visdp AS visdp_5, t0.rubriken AS rubriken_6, t0.zielgruppen AS zielgruppen_7, t0.twigListe AS twigListe_8, t0.twigDetail AS twigDetail_9, t0.ownTwigListe AS ownTwigListe_10, t0.ownTwigDetail AS ownTwigDetail_11, t0.dfxLess AS dfxLess_12, t0.dfxCss AS dfxCss_13, t0.ownCss AS ownCss_14, t0.ownLess AS ownLess_15, t0.lengthTeaser AS lengthTeaser_16, t0.maxLengthLead AS maxLengthLead_17, t0.maxLengthBeschreibung AS maxLengthBeschreibung_18, t0.itemsListe AS itemsListe_19, t0.dfxWidth AS dfxWidth_20, t0.dfxAlign AS dfxAlign_21, t0.imgWidth AS imgWidth_22, t0.imgHeight AS imgHeight_23, t0.imgPrevWidth AS imgPrevWidth_24, t0.imgPrevHeight AS imgPrevHeight_25, t0.imgLightboxWidth AS imgLightboxWidth_26, t0.imgLightboxHeight AS imgLightboxHeight_27, t0.navListe AS navListe_28, t0.navDetail AS navDetail_29, t0.navWidth AS navWidth_30, t0.archivTage AS archivTage_31, t0.navPos AS navPos_32, t0.filterKalender AS filterKalender_33, t0.filterRubrik AS filterRubrik_34, t0.filterZielgruppe AS filterZielgruppe_35, t0.filterDatum AS filterDatum_36, t0.filterSuche AS filterSuche_37, t0.filterNat AS filterNat_38, t0.filterPlzarea AS filterPlzarea_39, t0.filterUmkreis AS filterUmkreis_40, t0.filterOrt AS filterOrt_41, t0.filterRegion AS filterRegion_42, t0.filterLocation AS filterLocation_43, t0.filterVeranstalter AS filterVeranstalter_44, t0.filterDozenten AS filterDozenten_45, t0.feldSubtitel AS feldSubtitel_46, t0.feldLead AS feldLead_47, t0.feldBeschreibung AS feldBeschreibung_48, t0.feldEintritt AS feldEintritt_49, t0.feldImg AS feldImg_50, t0.feldGalerie AS feldGalerie_51, t0.feldVideo AS feldVideo_52, t0.imgListe AS imgListe_53, t0.feldPdf AS feldPdf_54, t0.feldMedia AS feldMedia_55, t0.feldNat AS feldNat_56, t0.feldRegion AS feldRegion_57, t0.feldPlz AS feldPlz_58, t0.feldOrt AS feldOrt_59, t0.feldOrtdb AS feldOrtdb_60, t0.feldKarten AS feldKarten_61, t0.feldAnmeldung AS feldAnmeldung_62, t0.feldPlatzlimit AS feldPlatzlimit_63, t0.showPlatzlimit AS showPlatzlimit_64, t0.feldLocation AS feldLocation_65, t0.feldVeranstalter AS feldVeranstalter_66, t0.feldDozenten AS feldDozenten_67, t0.feldLink AS feldLink_68, t0.feldTicketlink AS feldTicketlink_69, t0.feldOnlinetermin AS feldOnlinetermin_70, t0.showPlz AS showPlz_71, t0.showOrt AS showOrt_72, t0.showLokal AS showLokal_73, t0.showStrasse AS showStrasse_74, t0.allowInputAll AS allowInputAll_75, t0.allowPubAll AS allowPubAll_76, t0.allowPubMetaAll AS allowPubMetaAll_77, t0.allowPubGroupAll AS allowPubGroupAll_78, t0.PubMetaAll AS PubMetaAll_79, t0.PubGroupAll AS PubGroupAll_80, t0.InheritMeta AS InheritMeta_81, t0.InheritGroup AS InheritGroup_82, t0.InheritZielgruppenMeta AS InheritZielgruppenMeta_83, t0.InheritZielgruppenGroup AS InheritZielgruppenGroup_84, t0.infoToAdmin AS infoToAdmin_85, t0.sprache AS sprache_86, t0.allowSocial AS allowSocial_87, t0.allowRemind AS allowRemind_88, t0.allowMail AS allowMail_89, t0.allowExport AS allowExport_90, t0.allowPrint AS allowPrint_91, t0.useIcons AS useIcons_92, t0.useMap AS useMap_93, t0.useRss AS useRss_94, t0.dfxTpl AS dfxTpl_95, t0.dfxTplVersion AS dfxTplVersion_96, t0.dfxTplDetail AS dfxTplDetail_97, t0.zwueDatum AS zwueDatum_98, t0.dfxFarbe AS dfxFarbe_99, t0.dfxFarbeEigen AS dfxFarbeEigen_100, t0.dfxFarbeRaster AS dfxFarbeRaster_101, t0.dfxFarbeRasterEigen AS dfxFarbeRasterEigen_102, t0.bgDatefix AS bgDatefix_103, t0.bgNav AS bgNav_104, t0.trennzeichen AS trennzeichen_105, t0.dfxFontType AS dfxFontType_106, t0.dfxFontSize AS dfxFontSize_107, t0.dfxFontColor AS dfxFontColor_108, t0.ownFont AS ownFont_109, t0.paginationTop AS paginationTop_110, t0.paginationBottom AS paginationBottom_111, t0.dfxRadius AS dfxRadius_112, t0.isMeta AS isMeta_113, t0.isGroup AS isGroup_114, t0.toGroup AS toGroup_115, t0.frontendUrl AS frontendUrl_116, t0.datenschutzUrl AS datenschutzUrl_117, t0.impressumUrl AS impressumUrl_118, t0.frontendZeichensatz AS frontendZeichensatz_119, t0.backendZeichensatz AS backendZeichensatz_120, t0.frontendDoctype AS frontendDoctype_121, t0.id AS id_122, t0.user_id AS user_id_123 FROM pool_dfx_konf t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.22 ms
(4.80%)
1
SELECT t0.allow_map AS allow_map_1, t0.mapkey AS mapkey_2, t0.init_zoom AS init_zoom_3, t0.init_long AS init_long_4, t0.init_lat AS init_lat_5, t0.tileserver AS tileserver_6, t0.mapset AS mapset_7, t0.copyright AS copyright_8, t0.global AS global_9, t0.modified AS modified_10, t0.id AS id_11, t0.kalender_id AS kalender_id_12 FROM pool_dfx_map t0 WHERE t0.kalender_id = ? LIMIT 1
Parameters:
[
  1
]
1.02 ms
(4.01%)
1
SELECT p0_.ort AS ort_0 FROM pool_dfx_termine p0_ WHERE p0_.pub = 1 AND p0_.kalender_id IN (?) AND p0_.pub_group = 1 GROUP BY p0_.ort, p0_.id ORDER BY p0_.ort ASC
Parameters:
[
  [
    1
    1
  ]
]
0.81 ms
(3.18%)
1
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_.kalender_id IN (?) AND p0_.pub = 1 AND p0_.datum_von >= CURRENT_DATE ORDER BY p0_.datum_von ASC, p0_.zeit ASC LIMIT 20 OFFSET 160
Parameters:
[
  [
    1
  ]
]
0.63 ms
(2.49%)
1
SELECT p0_.lokal AS lokal_0 FROM pool_dfx_termine p0_ WHERE p0_.pub = 1 AND p0_.kalender_id IN (?) AND p0_.pub_group = 1 GROUP BY p0_.lokal, p0_.id ORDER BY p0_.lokal ASC
Parameters:
[
  [
    1
    1
  ]
]
0.34 ms
(1.35%)
1
UPDATE pool_dfx_nfx_counter SET dfx_day = ?, dfx_sum = ?, dfx_last_log = ? WHERE id = ?
Parameters:
[
  1
  176124
  "2026-11-16 02:36:46"
  1
]
0.26 ms
(1.02%)
1
SELECT DAY(MAX(p0_.dfx_last_log)) AS sclr_0 FROM pool_dfx_nfx_counter p0_
Parameters:
[]
0.12 ms
(0.49%)
1
"COMMIT"
Parameters:
[]
0.08 ms
(0.31%)
1
"START TRANSACTION"
Parameters:
[]

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\DfxKonf No errors.
App\Entity\DfxNfxUser No errors.
App\Entity\DfxTermine No errors.
App\Entity\DfxRegion No errors.
App\Entity\DfxVeranstalter No errors.
App\Entity\DfxOrte No errors.
App\Entity\DfxLocation No errors.
App\Entity\DfxNfxCounter No errors.
App\Entity\DfxNfxKunden No errors.
App\Entity\DfxLogs No errors.
App\Entity\DfxMap No errors.