Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.eventbriteId AS eventbriteId_1,
  s0_.wpPostId AS wpPostId_2,
  s0_.title AS title_3,
  s0_.slug AS slug_4,
  s0_.lang AS lang_5,
  s0_.imagelink AS imagelink_6,
  s0_.videolink AS videolink_7,
  s0_.bgImagelink AS bgImagelink_8,
  s0_.tagline AS tagline_9,
  s0_.headerTextColor AS headerTextColor_10,
  s0_.spResponsiblePerson AS spResponsiblePerson_11,
  s0_.organization AS organization_12,
  s0_.organizerName AS organizerName_13,
  s0_.organizerEmail AS organizerEmail_14,
  s0_.venueName AS venueName_15,
  s0_.venueAddress AS venueAddress_16,
  s0_.ticketing AS ticketing_17,
  s0_.applicationUrl AS applicationUrl_18,
  s0_.alert AS alert_19,
  s0_.trainer AS trainer_20,
  s0_.speakers AS speakers_21,
  s0_.teaser AS teaser_22,
  s0_.navbar AS navbar_23,
  s0_.stripePriceId AS stripePriceId_24,
  s0_.stripeProductId AS stripeProductId_25,
  s0_.stripeAccount AS stripeAccount_26,
  s0_.priceInEuroCent AS priceInEuroCent_27,
  s0_.isTaxIncluded AS isTaxIncluded_28,
  s0_.isFreeForKiCampus AS isFreeForKiCampus_29,
  s0_.isFreeForCommunity AS isFreeForCommunity_30,
  s0_.isSinglePage AS isSinglePage_31,
  s0_.isFormalLanguage AS isFormalLanguage_32,
  s0_.isMultiBatchEvent AS isMultiBatchEvent_33,
  s0_.twigFile AS twigFile_34,
  s0_.additionalCss AS additionalCss_35,
  s0_.content AS content_36,
  s0_.contentTwig AS contentTwig_37,
  s0_.ctaContent AS ctaContent_38,
  s0_.postCtaContent AS postCtaContent_39,
  s0_.tags AS tags_40,
  s0_.seriesTag AS seriesTag_41,
  s0_.type AS type_42,
  s0_.location AS location_43,
  s0_.startDate AS startDate_44,
  s0_.endDate AS endDate_45,
  s0_.duration AS duration_46,
  s0_.status AS status_47,
  s0_.settings AS settings_48,
  s0_.displayStartDate AS displayStartDate_49,
  s0_.seoTitle AS seoTitle_50,
  s0_.seoKeyword AS seoKeyword_51,
  s0_.seoDescription AS seoDescription_52,
  s0_.navbar_en AS navbar_en_53,
  s0_.teaser_en AS teaser_en_54,
  s0_.content_en AS content_en_55,
  s0_.content_twig_en AS content_twig_en_56,
  s0_.post_cta_content_en AS post_cta_content_en_57,
  s0_.seo_title_en AS seo_title_en_58,
  s0_.seo_description_en AS seo_description_en_59,
  s0_.seo_keyword_en AS seo_keyword_en_60,
  s0_.has_english_version AS has_english_version_61,
  s0_.additional_js AS additional_js_62,
  s0_.metaPixelId AS metaPixelId_63,
  s0_.createDate AS createDate_64,
  s0_.lastChangeDate AS lastChangeDate_65,
  s0_.lastChangeUser AS lastChangeUser_66,
  s0_.publicId AS publicId_67,
  s0_.isExternalSubmission AS isExternalSubmission_68,
  s0_.createdBy AS createdBy_69,
  s0_.lastModified AS lastModified_70,
  s0_.createdAt AS createdAt_71,
  s0_.orgaNote AS orgaNote_72,
  s0_.history AS history_73,
  s0_.todoHistory AS todoHistory_74
FROM
  sp_event_events s0_
WHERE
  s0_.seriesTag = ?
  AND s0_.status = ?

SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.wpPostId AS wpPostId_2, s0_.title AS title_3, s0_.slug AS slug_4, s0_.lang AS lang_5, s0_.imagelink AS imagelink_6, s0_.videolink AS videolink_7, s0_.bgImagelink AS bgImagelink_8, s0_.tagline AS tagline_9, s0_.headerTextColor AS headerTextColor_10, s0_.spResponsiblePerson AS spResponsiblePerson_11, s0_.organization AS organization_12, s0_.organizerName AS organizerName_13, s0_.organizerEmail AS organizerEmail_14, s0_.venueName AS venueName_15, s0_.venueAddress AS venueAddress_16, s0_.ticketing AS ticketing_17, s0_.applicationUrl AS applicationUrl_18, s0_.alert AS alert_19, s0_.trainer AS trainer_20, s0_.speakers AS speakers_21, s0_.teaser AS teaser_22, s0_.navbar AS navbar_23, s0_.stripePriceId AS stripePriceId_24, s0_.stripeProductId AS stripeProductId_25, s0_.stripeAccount AS stripeAccount_26, s0_.priceInEuroCent AS priceInEuroCent_27, s0_.isTaxIncluded AS isTaxIncluded_28, s0_.isFreeForKiCampus AS isFreeForKiCampus_29, s0_.isFreeForCommunity AS isFreeForCommunity_30, s0_.isSinglePage AS isSinglePage_31, s0_.isFormalLanguage AS isFormalLanguage_32, s0_.isMultiBatchEvent AS isMultiBatchEvent_33, s0_.twigFile AS twigFile_34, s0_.additionalCss AS additionalCss_35, s0_.content AS content_36, s0_.contentTwig AS contentTwig_37, s0_.ctaContent AS ctaContent_38, s0_.postCtaContent AS postCtaContent_39, s0_.tags AS tags_40, s0_.seriesTag AS seriesTag_41, s0_.type AS type_42, s0_.location AS location_43, s0_.startDate AS startDate_44, s0_.endDate AS endDate_45, s0_.duration AS duration_46, s0_.status AS status_47, s0_.settings AS settings_48, s0_.displayStartDate AS displayStartDate_49, s0_.seoTitle AS seoTitle_50, s0_.seoKeyword AS seoKeyword_51, s0_.seoDescription AS seoDescription_52, s0_.navbar_en AS navbar_en_53, s0_.teaser_en AS teaser_en_54, s0_.content_en AS content_en_55, s0_.content_twig_en AS content_twig_en_56, s0_.post_cta_content_en AS post_cta_content_en_57, s0_.seo_title_en AS seo_title_en_58, s0_.seo_description_en AS seo_description_en_59, s0_.seo_keyword_en AS seo_keyword_en_60, s0_.has_english_version AS has_english_version_61, s0_.additional_js AS additional_js_62, s0_.metaPixelId AS metaPixelId_63, s0_.createDate AS createDate_64, s0_.lastChangeDate AS lastChangeDate_65, s0_.lastChangeUser AS lastChangeUser_66, s0_.publicId AS publicId_67, s0_.isExternalSubmission AS isExternalSubmission_68, s0_.createdBy AS createdBy_69, s0_.lastModified AS lastModified_70, s0_.createdAt AS createdAt_71, s0_.orgaNote AS orgaNote_72, s0_.history AS history_73, s0_.todoHistory AS todoHistory_74 FROM sp_event_events s0_ WHERE s0_.seriesTag = '#konferenzreihe_best_practice_digitalisierung' AND s0_.status = 'publish';

SELECT
  s0_.id AS id_0,
  s0_.eventbriteId AS eventbriteId_1,
  s0_.wpPostId AS wpPostId_2,
  s0_.title AS title_3,
  s0_.slug AS slug_4,
  s0_.lang AS lang_5,
  s0_.imagelink AS imagelink_6,
  s0_.videolink AS videolink_7,
  s0_.bgImagelink AS bgImagelink_8,
  s0_.tagline AS tagline_9,
  s0_.headerTextColor AS headerTextColor_10,
  s0_.spResponsiblePerson AS spResponsiblePerson_11,
  s0_.organization AS organization_12,
  s0_.organizerName AS organizerName_13,
  s0_.organizerEmail AS organizerEmail_14,
  s0_.venueName AS venueName_15,
  s0_.venueAddress AS venueAddress_16,
  s0_.ticketing AS ticketing_17,
  s0_.applicationUrl AS applicationUrl_18,
  s0_.alert AS alert_19,
  s0_.trainer AS trainer_20,
  s0_.speakers AS speakers_21,
  s0_.teaser AS teaser_22,
  s0_.navbar AS navbar_23,
  s0_.stripePriceId AS stripePriceId_24,
  s0_.stripeProductId AS stripeProductId_25,
  s0_.stripeAccount AS stripeAccount_26,
  s0_.priceInEuroCent AS priceInEuroCent_27,
  s0_.isTaxIncluded AS isTaxIncluded_28,
  s0_.isFreeForKiCampus AS isFreeForKiCampus_29,
  s0_.isFreeForCommunity AS isFreeForCommunity_30,
  s0_.isSinglePage AS isSinglePage_31,
  s0_.isFormalLanguage AS isFormalLanguage_32,
  s0_.isMultiBatchEvent AS isMultiBatchEvent_33,
  s0_.twigFile AS twigFile_34,
  s0_.additionalCss AS additionalCss_35,
  s0_.content AS content_36,
  s0_.contentTwig AS contentTwig_37,
  s0_.ctaContent AS ctaContent_38,
  s0_.postCtaContent AS postCtaContent_39,
  s0_.tags AS tags_40,
  s0_.seriesTag AS seriesTag_41,
  s0_.type AS type_42,
  s0_.location AS location_43,
  s0_.startDate AS startDate_44,
  s0_.endDate AS endDate_45,
  s0_.duration AS duration_46,
  s0_.status AS status_47,
  s0_.settings AS settings_48,
  s0_.displayStartDate AS displayStartDate_49,
  s0_.seoTitle AS seoTitle_50,
  s0_.seoKeyword AS seoKeyword_51,
  s0_.seoDescription AS seoDescription_52,
  s0_.navbar_en AS navbar_en_53,
  s0_.teaser_en AS teaser_en_54,
  s0_.content_en AS content_en_55,
  s0_.content_twig_en AS content_twig_en_56,
  s0_.post_cta_content_en AS post_cta_content_en_57,
  s0_.seo_title_en AS seo_title_en_58,
  s0_.seo_description_en AS seo_description_en_59,
  s0_.seo_keyword_en AS seo_keyword_en_60,
  s0_.has_english_version AS has_english_version_61,
  s0_.additional_js AS additional_js_62,
  s0_.metaPixelId AS metaPixelId_63,
  s0_.createDate AS createDate_64,
  s0_.lastChangeDate AS lastChangeDate_65,
  s0_.lastChangeUser AS lastChangeUser_66,
  s0_.publicId AS publicId_67,
  s0_.isExternalSubmission AS isExternalSubmission_68,
  s0_.createdBy AS createdBy_69,
  s0_.lastModified AS lastModified_70,
  s0_.createdAt AS createdAt_71,
  s0_.orgaNote AS orgaNote_72,
  s0_.history AS history_73,
  s0_.todoHistory AS todoHistory_74
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_.wpPostId AS wpPostId_2, s0_.title AS title_3, s0_.slug AS slug_4, s0_.lang AS lang_5, s0_.imagelink AS imagelink_6, s0_.videolink AS videolink_7, s0_.bgImagelink AS bgImagelink_8, s0_.tagline AS tagline_9, s0_.headerTextColor AS headerTextColor_10, s0_.spResponsiblePerson AS spResponsiblePerson_11, s0_.organization AS organization_12, s0_.organizerName AS organizerName_13, s0_.organizerEmail AS organizerEmail_14, s0_.venueName AS venueName_15, s0_.venueAddress AS venueAddress_16, s0_.ticketing AS ticketing_17, s0_.applicationUrl AS applicationUrl_18, s0_.alert AS alert_19, s0_.trainer AS trainer_20, s0_.speakers AS speakers_21, s0_.teaser AS teaser_22, s0_.navbar AS navbar_23, s0_.stripePriceId AS stripePriceId_24, s0_.stripeProductId AS stripeProductId_25, s0_.stripeAccount AS stripeAccount_26, s0_.priceInEuroCent AS priceInEuroCent_27, s0_.isTaxIncluded AS isTaxIncluded_28, s0_.isFreeForKiCampus AS isFreeForKiCampus_29, s0_.isFreeForCommunity AS isFreeForCommunity_30, s0_.isSinglePage AS isSinglePage_31, s0_.isFormalLanguage AS isFormalLanguage_32, s0_.isMultiBatchEvent AS isMultiBatchEvent_33, s0_.twigFile AS twigFile_34, s0_.additionalCss AS additionalCss_35, s0_.content AS content_36, s0_.contentTwig AS contentTwig_37, s0_.ctaContent AS ctaContent_38, s0_.postCtaContent AS postCtaContent_39, s0_.tags AS tags_40, s0_.seriesTag AS seriesTag_41, s0_.type AS type_42, s0_.location AS location_43, s0_.startDate AS startDate_44, s0_.endDate AS endDate_45, s0_.duration AS duration_46, s0_.status AS status_47, s0_.settings AS settings_48, s0_.displayStartDate AS displayStartDate_49, s0_.seoTitle AS seoTitle_50, s0_.seoKeyword AS seoKeyword_51, s0_.seoDescription AS seoDescription_52, s0_.navbar_en AS navbar_en_53, s0_.teaser_en AS teaser_en_54, s0_.content_en AS content_en_55, s0_.content_twig_en AS content_twig_en_56, s0_.post_cta_content_en AS post_cta_content_en_57, s0_.seo_title_en AS seo_title_en_58, s0_.seo_description_en AS seo_description_en_59, s0_.seo_keyword_en AS seo_keyword_en_60, s0_.has_english_version AS has_english_version_61, s0_.additional_js AS additional_js_62, s0_.metaPixelId AS metaPixelId_63, s0_.createDate AS createDate_64, s0_.lastChangeDate AS lastChangeDate_65, s0_.lastChangeUser AS lastChangeUser_66, s0_.publicId AS publicId_67, s0_.isExternalSubmission AS isExternalSubmission_68, s0_.createdBy AS createdBy_69, s0_.lastModified AS lastModified_70, s0_.createdAt AS createdAt_71, s0_.orgaNote AS orgaNote_72, s0_.history AS history_73, s0_.todoHistory AS todoHistory_74 FROM sp_event_events s0_ WHERE s0_.seriesTag = '#konferenzreihe_best_practice_digitalisierung' AND s0_.id <> 4721 AND s0_.status = 'publish';

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;

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;