Query Metrics
8
Database Queries
8
Different statements
5.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.90 ms (36.83%) |
1 |
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_.filter_1 AS filter_1_24, p0_.filter_2 AS filter_2_25, p0_.filter_3 AS filter_3_26, p0_.filter_4 AS filter_4_27, p0_.filter_5 AS filter_5_28, p0_.filter_6 AS filter_6_29, p0_.filter_7 AS filter_7_30, p0_.filter_8 AS filter_8_31, p0_.filter_9 AS filter_9_32, p0_.filter_10 AS filter_10_33, p0_.text_1 AS text_1_34, p0_.text_2 AS text_2_35, p0_.text_3 AS text_3_36, p0_.text_4 AS text_4_37, p0_.text_5 AS text_5_38, p0_.text_6 AS text_6_39, p0_.text_7 AS text_7_40, p0_.text_8 AS text_8_41, p0_.text_9 AS text_9_42, p0_.text_10 AS text_10_43, p0_.textbox_1 AS textbox_1_44, p0_.textbox_2 AS textbox_2_45, p0_.datum_input AS datum_input_46, p0_.datum_modified AS datum_modified_47, p0_.id AS id_48, p0_.id_region AS id_region_49, p0_.id_ort AS id_ort_50, p0_.id_veranstalter AS id_veranstalter_51, p0_.kalender_id AS kalender_id_52, p0_.user_id AS user_id_53 FROM pool_dfx_location p0_ WHERE p0_.kalender_id IN (?) ORDER BY p0_.name ASC
Parameters:
[
[
1
1
]
]
|
|
1.08 ms (21.03%) |
1 |
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_.filter_1 AS filter_1_23, p0_.filter_2 AS filter_2_24, p0_.filter_3 AS filter_3_25, p0_.filter_4 AS filter_4_26, p0_.filter_5 AS filter_5_27, p0_.filter_6 AS filter_6_28, p0_.filter_7 AS filter_7_29, p0_.filter_8 AS filter_8_30, p0_.filter_9 AS filter_9_31, p0_.filter_10 AS filter_10_32, p0_.text_1 AS text_1_33, p0_.text_2 AS text_2_34, p0_.text_3 AS text_3_35, p0_.text_4 AS text_4_36, p0_.text_5 AS text_5_37, p0_.text_6 AS text_6_38, p0_.text_7 AS text_7_39, p0_.text_8 AS text_8_40, p0_.text_9 AS text_9_41, p0_.text_10 AS text_10_42, p0_.textbox_1 AS textbox_1_43, p0_.textbox_2 AS textbox_2_44, p0_.datum_input AS datum_input_45, p0_.datum_modified AS datum_modified_46, p0_.id AS id_47, p0_.id_region AS id_region_48, p0_.user_id AS user_id_49, p0_.id_ort AS id_ort_50, p0_.id_location AS id_location_51, p0_.kalender_id AS kalender_id_52 FROM pool_dfx_veranstalter p0_ WHERE p0_.kalender_id IN (?) ORDER BY p0_.name ASC
Parameters:
[
[
1
1
]
]
|
|
0.55 ms (10.68%) |
1 |
SELECT p0_.vorname AS vorname_0, p0_.name AS name_1, p0_.strasse AS strasse_2, p0_.nat AS nat_3, p0_.plz AS plz_4, p0_.ort AS ort_5, p0_.lg AS lg_6, p0_.bg AS bg_7, p0_.telefon AS telefon_8, p0_.fax AS fax_9, p0_.email AS email_10, p0_.www AS www_11, p0_.ansprech AS ansprech_12, p0_.img_doz AS img_doz_13, p0_.img_doz_pos AS img_doz_pos_14, p0_.info AS info_15, p0_.zusatz AS zusatz_16, p0_.datum_input AS datum_input_17, p0_.datum_modified AS datum_modified_18, p0_.id AS id_19, p0_.id_veranstalter AS id_veranstalter_20, p0_.user_id AS user_id_21, p0_.id_location AS id_location_22, p0_.kalender_id AS kalender_id_23 FROM pool_dfx_dozenten p0_ WHERE p0_.kalender_id IN (?) ORDER BY p0_.name ASC
Parameters:
[
[
1
1
]
]
|
|
0.40 ms (7.73%) |
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
]
|
|
0.39 ms (7.65%) |
1 |
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:
[] |
|
0.34 ms (6.60%) |
1 |
SELECT p0_.plz AS plz_0, p0_.ort AS ort_1, p0_.lg AS lg_2, p0_.bg AS bg_3, p0_.id AS id_4, p0_.kalender_id AS kalender_id_5, p0_.region_id AS region_id_6 FROM pool_dfx_orte p0_ ORDER BY p0_.ort ASC
Parameters:
[] |
|
0.25 ms (4.78%) |
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
]
|
|
0.24 ms (4.70%) |
1 |
SELECT t0.username AS username_1, t0.roles AS roles_2, t0.password AS password_3, t0.email AS email_4, t0.name_lang AS name_lang_5, t0.init AS init_6, t0.id AS id_7, t0.kalender_id AS kalender_id_8, t0.kunden_id AS kunden_id_9 FROM pool_dfx_nfx_user t0 WHERE t0.id = ?
Parameters:
[
108
]
|
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\DfxNfxUser | No errors. |
| App\Entity\DfxKonf | No errors. |
| App\Entity\DfxNfxKunden | No errors. |
| App\Entity\DfxMap | No errors. |
| App\Entity\DfxRegion | No errors. |
| App\Entity\DfxOrte | No errors. |
| App\Entity\DfxVeranstalter | No errors. |
| App\Entity\DfxLocation | No errors. |
| App\Entity\DfxDozenten | No errors. |