Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

6 Database Queries

4 Different statements

39.57 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = ? AND a0_.status = ?
SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = ? AND a0_.status = ?
SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = ? AND a0_.id <> ? AND a0_.status = ?
SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = ? AND a0_.id <> ? AND a0_.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 asp_events e
            INNER JOIN aab_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 asp_events e
            INNER JOIN aab_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	9.61 ms	SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = ? AND a0_.status = ? Parameters: [`"#jubilaeum-10-jahre-startplatz" "publish"`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = ? AND a0_.status = ? SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = '#jubilaeum-10-jahre-startplatz' AND a0_.status = 'publish';
2	9.35 ms	SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = ? AND a0_.status = ? Parameters: [`"#jubilaeum-10-jahre-startplatz" "publish"`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = ? AND a0_.status = ? SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = '#jubilaeum-10-jahre-startplatz' AND a0_.status = 'publish';
3	9.36 ms	SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = ? AND a0_.id <> ? AND a0_.status = ? Parameters: [`"#jubilaeum-10-jahre-startplatz" 5641 "publish"`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = ? AND a0_.id <> ? AND a0_.status = ? SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = '#jubilaeum-10-jahre-startplatz' AND a0_.id <> 5641 AND a0_.status = 'publish';
4	9.16 ms	SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = ? AND a0_.id <> ? AND a0_.status = ? Parameters: [`"#jubilaeum-10-jahre-startplatz" 5641 "publish"`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = ? AND a0_.id <> ? AND a0_.status = ? SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = '#jubilaeum-10-jahre-startplatz' AND a0_.id <> 5641 AND a0_.status = 'publish';
5	1.17 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 asp_events e INNER JOIN aab_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" => "#jubilaeum-10-jahre-startplatz"`] 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 asp_events e INNER JOIN aab_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 asp_events e INNER JOIN aab_batches b ON b.eventId = e.id WHERE e.seriesTag = '#jubilaeum-10-jahre-startplatz' 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.92 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 asp_events e INNER JOIN aab_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" => "#jubilaeum-10-jahre-startplatz"`] 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 asp_events e INNER JOIN aab_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 asp_events e INNER JOIN aab_batches b ON b.eventId = e.id WHERE e.seriesTag = '#jubilaeum-10-jahre-startplatz' 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\UserBundle\Entity\User	No errors.
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/%23jubilaeum-10-jahre-startplatz

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping