Query Metrics
10
Database Queries
10
Different statements
2.69 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.66 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.pdfSerie AS pdfSerie_29, t0.pdflinktext AS pdflinktext_30, t0.media AS media_31, t0.mediaSerie AS mediaSerie_32, t0.medialinktext AS medialinktext_33, t0.mediatyp AS mediatyp_34, t0.img AS img_35, t0.imgSerie AS imgSerie_36, t0.img2 AS img2_37, t0.imgSerie2 AS imgSerie2_38, t0.img3 AS img3_39, t0.imgSerie3 AS imgSerie3_40, t0.img4 AS img4_41, t0.imgSerie4 AS imgSerie4_42, t0.img5 AS img5_43, t0.imgSerie5 AS imgSerie5_44, t0.imgtext AS imgtext_45, t0.imgcopyright AS imgcopyright_46, t0.imgcopycheck AS imgcopycheck_47, t0.imgtext2 AS imgtext2_48, t0.imgcopyright2 AS imgcopyright2_49, t0.imgcopycheck2 AS imgcopycheck2_50, t0.video AS video_51, t0.mail AS mail_52, t0.mail_typ AS mail_typ_53, t0.pub AS pub_54, t0.pub_meta AS pub_meta_55, t0.pub_group AS pub_group_56, t0.code AS code_57, t0.init AS init_58, t0.autor AS autor_59, t0.online AS online_60, t0.counter AS counter_61, t0.nl AS nl_62, t0.nl_sent AS nl_sent_63, t0.serie AS serie_64, t0.plaetze_gesamt AS plaetze_gesamt_65, t0.plaetze_aktuell AS plaetze_aktuell_66, t0.karten_tpl AS karten_tpl_67, t0.karten_kat AS karten_kat_68, t0.anmeldeschluss AS anmeldeschluss_69, t0.archiv AS archiv_70, t0.exportflag AS exportflag_71, t0.filter_1 AS filter_1_72, t0.filter_2 AS filter_2_73, t0.filter_3 AS filter_3_74, t0.filter_4 AS filter_4_75, t0.filter_5 AS filter_5_76, t0.filter_6 AS filter_6_77, t0.filter_7 AS filter_7_78, t0.filter_8 AS filter_8_79, t0.filter_9 AS filter_9_80, t0.filter_10 AS filter_10_81, t0.filter_11 AS filter_11_82, t0.filter_12 AS filter_12_83, t0.filter_13 AS filter_13_84, t0.filter_14 AS filter_14_85, t0.filter_15 AS filter_15_86, t0.text_1 AS text_1_87, t0.text_2 AS text_2_88, t0.text_3 AS text_3_89, t0.text_4 AS text_4_90, t0.text_5 AS text_5_91, t0.text_6 AS text_6_92, t0.text_7 AS text_7_93, t0.text_8 AS text_8_94, t0.text_9 AS text_9_95, t0.text_10 AS text_10_96, t0.textbox_1 AS textbox_1_97, t0.textbox_2 AS textbox_2_98, t0.options_radio AS options_radio_99, t0.options_menue AS options_menue_100, t0.options_checkboxes AS options_checkboxes_101, t0.options_menue_multi AS options_menue_multi_102, t0.datum_3 AS datum_3_103, t0.datenschutz AS datenschutz_104, t0.datum_input AS datum_input_105, t0.datum_modified AS datum_modified_106, t0.id AS id_107, t0.user_id AS user_id_108, t0.id_location AS id_location_109, t0.id_veranstalter AS id_veranstalter_110, t0.id_ort AS id_ort_111, t0.id_region AS id_region_112, t0.kalender_id AS kalender_id_113 FROM pool_dfx_termine t0 WHERE t0.id = ?
Parameters:
[
"28218"
]
|
2 | 0.52 ms |
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
]
|
3 | 0.27 ms |
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
]
|
4 | 0.22 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.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
]
|
5 | 0.23 ms |
SELECT DAY(MAX(p0_.dfx_last_log)) AS sclr_0 FROM pool_dfx_nfx_counter p0_
Parameters:
[] |
6 | 0.06 ms |
"START TRANSACTION"
Parameters:
[] |
7 | 0.16 ms |
INSERT INTO pool_dfx_logs (ip, host, agent, zeit, kalender_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ 1 => "85.13.142.111" 2 => "datefix.hotze-fussball.de" 3 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)" 4 => "2025-07-08 18:48:55" 5 => 1 ] |
8 | 0.19 ms |
UPDATE pool_dfx_nfx_counter SET dfx_day = ?, dfx_sum = ?, dfx_last_log = ? WHERE id = ?
Parameters:
[ 120 92276 "2025-07-08 18:48:55" 1 ] |
9 | 0.27 ms |
UPDATE pool_dfx_termine SET counter = ? WHERE id = ?
Parameters:
[ 13 28218 ] |
10 | 0.12 ms |
"COMMIT"
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\DfxTermine | No errors. |
App\Entity\DfxNfxUser | No errors. |
App\Entity\DfxLocation | No errors. |
App\Entity\DfxVeranstalter | No errors. |
App\Entity\DfxOrte | No errors. |
App\Entity\DfxRegion | No errors. |
App\Entity\DfxKonf | No errors. |
App\Entity\DfxDozenten | No errors. |
App\Entity\DfxMap | No errors. |
App\Entity\DfxNfxCounter | No errors. |
App\Entity\DfxNfxKunden | No errors. |
App\Entity\DfxLogs | No errors. |