Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

1.41 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
0.56 ms (39.85%)	1	SELECT t0.name AS name_1, t0.strasse AS strasse_2, t0.nat AS nat_3, t0.plz AS plz_4, t0.ort AS ort_5, t0.lg AS lg_6, t0.bg AS bg_7, t0.telefon AS telefon_8, t0.mobil AS mobil_9, t0.fax AS fax_10, t0.www AS www_11, t0.ansprech AS ansprech_12, t0.email AS email_13, t0.raumnr AS raumnr_14, t0.zusatz AS zusatz_15, t0.img_loc AS img_loc_16, t0.img_loc_pos AS img_loc_pos_17, t0.img2 AS img2_18, t0.img3 AS img3_19, t0.img4 AS img4_20, t0.img5 AS img5_21, t0.imgtext AS imgtext_22, t0.imgcopyright AS imgcopyright_23, t0.imgcopycheck AS imgcopycheck_24, t0.filter_1 AS filter_1_25, t0.filter_2 AS filter_2_26, t0.filter_3 AS filter_3_27, t0.filter_4 AS filter_4_28, t0.filter_5 AS filter_5_29, t0.filter_6 AS filter_6_30, t0.filter_7 AS filter_7_31, t0.filter_8 AS filter_8_32, t0.filter_9 AS filter_9_33, t0.filter_10 AS filter_10_34, t0.text_1 AS text_1_35, t0.text_2 AS text_2_36, t0.text_3 AS text_3_37, t0.text_4 AS text_4_38, t0.text_5 AS text_5_39, t0.text_6 AS text_6_40, t0.text_7 AS text_7_41, t0.text_8 AS text_8_42, t0.text_9 AS text_9_43, t0.text_10 AS text_10_44, t0.textbox_1 AS textbox_1_45, t0.textbox_2 AS textbox_2_46, t0.datum_input AS datum_input_47, t0.datum_modified AS datum_modified_48, t0.id AS id_49, t0.id_region AS id_region_50, t0.id_ort AS id_ort_51, t0.id_veranstalter AS id_veranstalter_52, t0.kalender_id AS kalender_id_53, t0.user_id AS user_id_54 FROM pool_dfx_location t0 WHERE t0.id = ? Parameters: [`"211"`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.strasse AS strasse_2, t0.nat AS nat_3, t0.plz AS plz_4, t0.ort AS ort_5, t0.lg AS lg_6, t0.bg AS bg_7, t0.telefon AS telefon_8, t0.mobil AS mobil_9, t0.fax AS fax_10, t0.www AS www_11, t0.ansprech AS ansprech_12, t0.email AS email_13, t0.raumnr AS raumnr_14, t0.zusatz AS zusatz_15, t0.img_loc AS img_loc_16, t0.img_loc_pos AS img_loc_pos_17, t0.img2 AS img2_18, t0.img3 AS img3_19, t0.img4 AS img4_20, t0.img5 AS img5_21, t0.imgtext AS imgtext_22, t0.imgcopyright AS imgcopyright_23, t0.imgcopycheck AS imgcopycheck_24, t0.filter_1 AS filter_1_25, t0.filter_2 AS filter_2_26, t0.filter_3 AS filter_3_27, t0.filter_4 AS filter_4_28, t0.filter_5 AS filter_5_29, t0.filter_6 AS filter_6_30, t0.filter_7 AS filter_7_31, t0.filter_8 AS filter_8_32, t0.filter_9 AS filter_9_33, t0.filter_10 AS filter_10_34, t0.text_1 AS text_1_35, t0.text_2 AS text_2_36, t0.text_3 AS text_3_37, t0.text_4 AS text_4_38, t0.text_5 AS text_5_39, t0.text_6 AS text_6_40, t0.text_7 AS text_7_41, t0.text_8 AS text_8_42, t0.text_9 AS text_9_43, t0.text_10 AS text_10_44, t0.textbox_1 AS textbox_1_45, t0.textbox_2 AS textbox_2_46, t0.datum_input AS datum_input_47, t0.datum_modified AS datum_modified_48, t0.id AS id_49, t0.id_region AS id_region_50, t0.id_ort AS id_ort_51, t0.id_veranstalter AS id_veranstalter_52, t0.kalender_id AS kalender_id_53, t0.user_id AS user_id_54 FROM pool_dfx_location t0 WHERE t0.id = ? SELECT t0.name AS name_1, t0.strasse AS strasse_2, t0.nat AS nat_3, t0.plz AS plz_4, t0.ort AS ort_5, t0.lg AS lg_6, t0.bg AS bg_7, t0.telefon AS telefon_8, t0.mobil AS mobil_9, t0.fax AS fax_10, t0.www AS www_11, t0.ansprech AS ansprech_12, t0.email AS email_13, t0.raumnr AS raumnr_14, t0.zusatz AS zusatz_15, t0.img_loc AS img_loc_16, t0.img_loc_pos AS img_loc_pos_17, t0.img2 AS img2_18, t0.img3 AS img3_19, t0.img4 AS img4_20, t0.img5 AS img5_21, t0.imgtext AS imgtext_22, t0.imgcopyright AS imgcopyright_23, t0.imgcopycheck AS imgcopycheck_24, t0.filter_1 AS filter_1_25, t0.filter_2 AS filter_2_26, t0.filter_3 AS filter_3_27, t0.filter_4 AS filter_4_28, t0.filter_5 AS filter_5_29, t0.filter_6 AS filter_6_30, t0.filter_7 AS filter_7_31, t0.filter_8 AS filter_8_32, t0.filter_9 AS filter_9_33, t0.filter_10 AS filter_10_34, t0.text_1 AS text_1_35, t0.text_2 AS text_2_36, t0.text_3 AS text_3_37, t0.text_4 AS text_4_38, t0.text_5 AS text_5_39, t0.text_6 AS text_6_40, t0.text_7 AS text_7_41, t0.text_8 AS text_8_42, t0.text_9 AS text_9_43, t0.text_10 AS text_10_44, t0.textbox_1 AS textbox_1_45, t0.textbox_2 AS textbox_2_46, t0.datum_input AS datum_input_47, t0.datum_modified AS datum_modified_48, t0.id AS id_49, t0.id_region AS id_region_50, t0.id_ort AS id_ort_51, t0.id_veranstalter AS id_veranstalter_52, t0.kalender_id AS kalender_id_53, t0.user_id AS user_id_54 FROM pool_dfx_location t0 WHERE t0.id = '211';
0.52 ms (36.74%)	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`] View formatted query View runnable query Explain query 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 = ? 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 = 1;
0.33 ms (23.40%)	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`] View formatted query View runnable query Explain query 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 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 = 1 LIMIT 1;

Time▼

Count

Info

0.56 ms
(39.85%)

SELECT t0.name AS name_1, t0.strasse AS strasse_2, t0.nat AS nat_3, t0.plz AS plz_4, t0.ort AS ort_5, t0.lg AS lg_6, t0.bg AS bg_7, t0.telefon AS telefon_8, t0.mobil AS mobil_9, t0.fax AS fax_10, t0.www AS www_11, t0.ansprech AS ansprech_12, t0.email AS email_13, t0.raumnr AS raumnr_14, t0.zusatz AS zusatz_15, t0.img_loc AS img_loc_16, t0.img_loc_pos AS img_loc_pos_17, t0.img2 AS img2_18, t0.img3 AS img3_19, t0.img4 AS img4_20, t0.img5 AS img5_21, t0.imgtext AS imgtext_22, t0.imgcopyright AS imgcopyright_23, t0.imgcopycheck AS imgcopycheck_24, t0.filter_1 AS filter_1_25, t0.filter_2 AS filter_2_26, t0.filter_3 AS filter_3_27, t0.filter_4 AS filter_4_28, t0.filter_5 AS filter_5_29, t0.filter_6 AS filter_6_30, t0.filter_7 AS filter_7_31, t0.filter_8 AS filter_8_32, t0.filter_9 AS filter_9_33, t0.filter_10 AS filter_10_34, t0.text_1 AS text_1_35, t0.text_2 AS text_2_36, t0.text_3 AS text_3_37, t0.text_4 AS text_4_38, t0.text_5 AS text_5_39, t0.text_6 AS text_6_40, t0.text_7 AS text_7_41, t0.text_8 AS text_8_42, t0.text_9 AS text_9_43, t0.text_10 AS text_10_44, t0.textbox_1 AS textbox_1_45, t0.textbox_2 AS textbox_2_46, t0.datum_input AS datum_input_47, t0.datum_modified AS datum_modified_48, t0.id AS id_49, t0.id_region AS id_region_50, t0.id_ort AS id_ort_51, t0.id_veranstalter AS id_veranstalter_52, t0.kalender_id AS kalender_id_53, t0.user_id AS user_id_54 FROM pool_dfx_location t0 WHERE t0.id = ?

Parameters:

[
  "211"
]

View formatted query View runnable query Explain query

SELECT
  t0.name AS name_1,
  t0.strasse AS strasse_2,
  t0.nat AS nat_3,
  t0.plz AS plz_4,
  t0.ort AS ort_5,
  t0.lg AS lg_6,
  t0.bg AS bg_7,
  t0.telefon AS telefon_8,
  t0.mobil AS mobil_9,
  t0.fax AS fax_10,
  t0.www AS www_11,
  t0.ansprech AS ansprech_12,
  t0.email AS email_13,
  t0.raumnr AS raumnr_14,
  t0.zusatz AS zusatz_15,
  t0.img_loc AS img_loc_16,
  t0.img_loc_pos AS img_loc_pos_17,
  t0.img2 AS img2_18,
  t0.img3 AS img3_19,
  t0.img4 AS img4_20,
  t0.img5 AS img5_21,
  t0.imgtext AS imgtext_22,
  t0.imgcopyright AS imgcopyright_23,
  t0.imgcopycheck AS imgcopycheck_24,
  t0.filter_1 AS filter_1_25,
  t0.filter_2 AS filter_2_26,
  t0.filter_3 AS filter_3_27,
  t0.filter_4 AS filter_4_28,
  t0.filter_5 AS filter_5_29,
  t0.filter_6 AS filter_6_30,
  t0.filter_7 AS filter_7_31,
  t0.filter_8 AS filter_8_32,
  t0.filter_9 AS filter_9_33,
  t0.filter_10 AS filter_10_34,
  t0.text_1 AS text_1_35,
  t0.text_2 AS text_2_36,
  t0.text_3 AS text_3_37,
  t0.text_4 AS text_4_38,
  t0.text_5 AS text_5_39,
  t0.text_6 AS text_6_40,
  t0.text_7 AS text_7_41,
  t0.text_8 AS text_8_42,
  t0.text_9 AS text_9_43,
  t0.text_10 AS text_10_44,
  t0.textbox_1 AS textbox_1_45,
  t0.textbox_2 AS textbox_2_46,
  t0.datum_input AS datum_input_47,
  t0.datum_modified AS datum_modified_48,
  t0.id AS id_49,
  t0.id_region AS id_region_50,
  t0.id_ort AS id_ort_51,
  t0.id_veranstalter AS id_veranstalter_52,
  t0.kalender_id AS kalender_id_53,
  t0.user_id AS user_id_54
FROM
  pool_dfx_location t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.strasse AS strasse_2, t0.nat AS nat_3, t0.plz AS plz_4, t0.ort AS ort_5, t0.lg AS lg_6, t0.bg AS bg_7, t0.telefon AS telefon_8, t0.mobil AS mobil_9, t0.fax AS fax_10, t0.www AS www_11, t0.ansprech AS ansprech_12, t0.email AS email_13, t0.raumnr AS raumnr_14, t0.zusatz AS zusatz_15, t0.img_loc AS img_loc_16, t0.img_loc_pos AS img_loc_pos_17, t0.img2 AS img2_18, t0.img3 AS img3_19, t0.img4 AS img4_20, t0.img5 AS img5_21, t0.imgtext AS imgtext_22, t0.imgcopyright AS imgcopyright_23, t0.imgcopycheck AS imgcopycheck_24, t0.filter_1 AS filter_1_25, t0.filter_2 AS filter_2_26, t0.filter_3 AS filter_3_27, t0.filter_4 AS filter_4_28, t0.filter_5 AS filter_5_29, t0.filter_6 AS filter_6_30, t0.filter_7 AS filter_7_31, t0.filter_8 AS filter_8_32, t0.filter_9 AS filter_9_33, t0.filter_10 AS filter_10_34, t0.text_1 AS text_1_35, t0.text_2 AS text_2_36, t0.text_3 AS text_3_37, t0.text_4 AS text_4_38, t0.text_5 AS text_5_39, t0.text_6 AS text_6_40, t0.text_7 AS text_7_41, t0.text_8 AS text_8_42, t0.text_9 AS text_9_43, t0.text_10 AS text_10_44, t0.textbox_1 AS textbox_1_45, t0.textbox_2 AS textbox_2_46, t0.datum_input AS datum_input_47, t0.datum_modified AS datum_modified_48, t0.id AS id_49, t0.id_region AS id_region_50, t0.id_ort AS id_ort_51, t0.id_veranstalter AS id_veranstalter_52, t0.kalender_id AS kalender_id_53, t0.user_id AS user_id_54 FROM pool_dfx_location t0 WHERE t0.id = '211';

0.52 ms
(36.74%)

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
]

View formatted query View runnable query Explain query

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 = ?

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 = 1;

0.33 ms
(23.40%)

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
]

View formatted query View runnable query Explain query

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

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 = 1 LIMIT 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.

Entities Mapping

Class	Mapping errors
App\Entity\DfxLocation	No errors.
App\Entity\DfxRegion	No errors.
App\Entity\DfxOrte	No errors.
App\Entity\DfxVeranstalter	No errors.
App\Entity\DfxKonf	No errors.
App\Entity\DfxNfxUser	No errors.
App\Entity\DfxDozenten	No errors.
App\Entity\DfxMap	No errors.

Symfony Profiler

https://datefix.hotze-fussball.de/js/kalender/location/211?cb%3Dall=

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping