Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

6 Database Queries

4 Different statements

83.67 ms Query time

1 Invalid entities

Queries

Group similar statements


SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.status = ?
SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.status = ?
SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.id <> ? AND s0_.status = ?
SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.id <> ? AND s0_.status = ?
SELECT 
                b.id as batch_id,
                b.eventId as event_id,
                b.name as batch_name,
                b.slug as batch_slug,
                COALESCE(b.startDate, b.pitchDate) as batch_date,
                b.endDate as batch_end_date,
                b.status as batch_status,
                e.id as event_id,
                e.title as event_title,
                e.slug as event_slug,
                e.location,
                e.venueName,
                e.trainer,
                e.isMultiBatchEvent
            FROM sp_event_events e
            INNER JOIN sp_batches b ON b.eventId = e.id
            WHERE e.seriesTag = :seriesTag
            AND e.status = 'publish'
            AND b.status = 'active'
            AND e.isMultiBatchEvent = 1
            AND (
                (b.startDate IS NOT NULL AND b.startDate > NOW()) OR 
                (b.startDate IS NULL AND b.pitchDate > NOW())
            )
         ORDER BY COALESCE(b.startDate, b.pitchDate) ASC
SELECT 
                b.id as batch_id,
                b.eventId as event_id,
                b.name as batch_name,
                b.slug as batch_slug,
                COALESCE(b.endDate, b.startDate, b.pitchDate) as batch_date,
                b.endDate as batch_end_date,
                b.status as batch_status,
                e.id as event_id,
                e.title as event_title,
                e.slug as event_slug,
                e.location,
                e.venueName,
                e.trainer,
                e.isMultiBatchEvent
            FROM sp_event_events e
            INNER JOIN sp_batches b ON b.eventId = e.id
            WHERE e.seriesTag = :seriesTag
            AND e.status = 'publish'
            AND b.status = 'active'
            AND e.isMultiBatchEvent = 1
            AND (
                (b.endDate IS NOT NULL AND b.endDate < NOW()) OR
                (b.endDate IS NULL AND b.startDate IS NOT NULL AND b.startDate < NOW()) OR
                (b.startDate IS NULL AND b.pitchDate < NOW())
            )
         ORDER BY COALESCE(b.endDate, b.startDate, b.pitchDate) DESC

#▲	Time	Info
1	25.02 ms	SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.status = ? Parameters: [`"#konferenzreihe_best_practice_digitalisierung" "publish"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.status = ? SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.seriesTag = '#konferenzreihe_best_practice_digitalisierung' AND s0_.status = 'publish';
2	24.21 ms	SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.status = ? Parameters: [`"#konferenzreihe_best_practice_digitalisierung" "publish"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.status = ? SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.seriesTag = '#konferenzreihe_best_practice_digitalisierung' AND s0_.status = 'publish';
3	19.51 ms	SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.id <> ? AND s0_.status = ? Parameters: [`"#konferenzreihe_best_practice_digitalisierung" 4721 "publish"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.id <> ? AND s0_.status = ? SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.seriesTag = '#konferenzreihe_best_practice_digitalisierung' AND s0_.id <> 4721 AND s0_.status = 'publish';
4	13.58 ms	SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.id <> ? AND s0_.status = ? Parameters: [`"#konferenzreihe_best_practice_digitalisierung" 4721 "publish"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.id <> ? AND s0_.status = ? SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.seriesTag = '#konferenzreihe_best_practice_digitalisierung' AND s0_.id <> 4721 AND s0_.status = 'publish';
5	0.75 ms	SELECT b.id as batch_id, b.eventId as event_id, b.name as batch_name, b.slug as batch_slug, COALESCE(b.startDate, b.pitchDate) as batch_date, b.endDate as batch_end_date, b.status as batch_status, e.id as event_id, e.title as event_title, e.slug as event_slug, e.location, e.venueName, e.trainer, e.isMultiBatchEvent FROM sp_event_events e INNER JOIN sp_batches b ON b.eventId = e.id WHERE e.seriesTag = :seriesTag AND e.status = 'publish' AND b.status = 'active' AND e.isMultiBatchEvent = 1 AND ( (b.startDate IS NOT NULL AND b.startDate > NOW()) OR (b.startDate IS NULL AND b.pitchDate > NOW()) ) ORDER BY COALESCE(b.startDate, b.pitchDate) ASC Parameters: [`"seriesTag" => "#konferenzreihe_best_practice_digitalisierung"`] View formatted query View runnable query Explain query SELECT b.id as batch_id, b.eventId as event_id, b.name as batch_name, b.slug as batch_slug, COALESCE(b.startDate, b.pitchDate) as batch_date, b.endDate as batch_end_date, b.status as batch_status, e.id as event_id, e.title as event_title, e.slug as event_slug, e.location, e.venueName, e.trainer, e.isMultiBatchEvent FROM sp_event_events e INNER JOIN sp_batches b ON b.eventId = e.id WHERE e.seriesTag = :seriesTag AND e.status = 'publish' AND b.status = 'active' AND e.isMultiBatchEvent = 1 AND ( ( b.startDate IS NOT NULL AND b.startDate > NOW() ) OR ( b.startDate IS NULL AND b.pitchDate > NOW() ) ) ORDER BY COALESCE(b.startDate, b.pitchDate) ASC SELECT b.id as batch_id, b.eventId as event_id, b.name as batch_name, b.slug as batch_slug, COALESCE(b.startDate, b.pitchDate) as batch_date, b.endDate as batch_end_date, b.status as batch_status, e.id as event_id, e.title as event_title, e.slug as event_slug, e.location, e.venueName, e.trainer, e.isMultiBatchEvent FROM sp_event_events e INNER JOIN sp_batches b ON b.eventId = e.id WHERE e.seriesTag = '#konferenzreihe_best_practice_digitalisierung' AND e.status = 'publish' AND b.status = 'active' AND e.isMultiBatchEvent = 1 AND ( (b.startDate IS NOT NULL AND b.startDate > NOW()) OR (b.startDate IS NULL AND b.pitchDate > NOW()) ) ORDER BY COALESCE(b.startDate, b.pitchDate) ASC;
6	0.61 ms	SELECT b.id as batch_id, b.eventId as event_id, b.name as batch_name, b.slug as batch_slug, COALESCE(b.endDate, b.startDate, b.pitchDate) as batch_date, b.endDate as batch_end_date, b.status as batch_status, e.id as event_id, e.title as event_title, e.slug as event_slug, e.location, e.venueName, e.trainer, e.isMultiBatchEvent FROM sp_event_events e INNER JOIN sp_batches b ON b.eventId = e.id WHERE e.seriesTag = :seriesTag AND e.status = 'publish' AND b.status = 'active' AND e.isMultiBatchEvent = 1 AND ( (b.endDate IS NOT NULL AND b.endDate < NOW()) OR (b.endDate IS NULL AND b.startDate IS NOT NULL AND b.startDate < NOW()) OR (b.startDate IS NULL AND b.pitchDate < NOW()) ) ORDER BY COALESCE(b.endDate, b.startDate, b.pitchDate) DESC Parameters: [`"seriesTag" => "#konferenzreihe_best_practice_digitalisierung"`] View formatted query View runnable query Explain query SELECT b.id as batch_id, b.eventId as event_id, b.name as batch_name, b.slug as batch_slug, COALESCE( b.endDate, b.startDate, b.pitchDate ) as batch_date, b.endDate as batch_end_date, b.status as batch_status, e.id as event_id, e.title as event_title, e.slug as event_slug, e.location, e.venueName, e.trainer, e.isMultiBatchEvent FROM sp_event_events e INNER JOIN sp_batches b ON b.eventId = e.id WHERE e.seriesTag = :seriesTag AND e.status = 'publish' AND b.status = 'active' AND e.isMultiBatchEvent = 1 AND ( ( b.endDate IS NOT NULL AND b.endDate < NOW() ) OR ( b.endDate IS NULL AND b.startDate IS NOT NULL AND b.startDate < NOW() ) OR ( b.startDate IS NULL AND b.pitchDate < NOW() ) ) ORDER BY COALESCE( b.endDate, b.startDate, b.pitchDate ) DESC SELECT b.id as batch_id, b.eventId as event_id, b.name as batch_name, b.slug as batch_slug, COALESCE(b.endDate, b.startDate, b.pitchDate) as batch_date, b.endDate as batch_end_date, b.status as batch_status, e.id as event_id, e.title as event_title, e.slug as event_slug, e.location, e.venueName, e.trainer, e.isMultiBatchEvent FROM sp_event_events e INNER JOIN sp_batches b ON b.eventId = e.id WHERE e.seriesTag = '#konferenzreihe_best_practice_digitalisierung' AND e.status = 'publish' AND b.status = 'active' AND e.isMultiBatchEvent = 1 AND ( (b.endDate IS NOT NULL AND b.endDate < NOW()) OR (b.endDate IS NULL AND b.startDate IS NOT NULL AND b.startDate < NOW()) OR (b.startDate IS NULL AND b.pitchDate < NOW()) ) ORDER BY COALESCE(b.endDate, b.startDate, b.pitchDate) DESC;

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\StartPlatz\Bundle\MetaBundle\Entity\Tag	No errors.
App\StartPlatz\Bundle\UserBundle\Entity\User	No errors.
App\StartPlatz\Bundle\UserBundle\Entity\LoginToken	No errors.
App\StartPlatz\Bundle\PartnersBundle\Entity\Partner	No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\Team	No errors.
App\StartPlatz\Ecosystem\Participation\Entity\Participation	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Application	The field 'App\StartPlatz\Bundle\StartupBundle\Entity\Application#ratingAverage' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field App\StartPlatz\Bundle\StartupBundle\Entity\Application#assessments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\StartPlatz\Bundle\AllmedaBundle\Entity\BatchApplicationAssessment#application does not contain the required 'inversedBy="assessments"' attribute.
App\StartPlatz\Bundle\EventBundle\Entity\Event	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Batch	No errors.

Symfony Profiler

http://www.staging.startplatz.de/event-series/%23konferenzreihe_best_practice_digitalisierung

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping