Symfony Profiler

Query Metrics

7 Database Queries

6 Different statements

64.28 ms Query time

0 Invalid entities

2 Managed entities

Queries


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_.title_en AS title_en_5, s0_.slug AS slug_6, s0_.lang AS lang_7, s0_.imagelink AS imagelink_8, s0_.videolink AS videolink_9, s0_.bgImagelink AS bgImagelink_10, s0_.tagline AS tagline_11, s0_.headerTextColor AS headerTextColor_12, s0_.spResponsiblePerson AS spResponsiblePerson_13, s0_.organization AS organization_14, s0_.organizerName AS organizerName_15, s0_.organizerEmail AS organizerEmail_16, s0_.venueName AS venueName_17, s0_.venueAddress AS venueAddress_18, s0_.showFullVenue AS showFullVenue_19, s0_.ticketing AS ticketing_20, s0_.applicationUrl AS applicationUrl_21, s0_.alert AS alert_22, s0_.trainer AS trainer_23, s0_.speakers AS speakers_24, s0_.teaser AS teaser_25, s0_.navbar AS navbar_26, s0_.stripePriceId AS stripePriceId_27, s0_.stripeProductId AS stripeProductId_28, s0_.stripeAccount AS stripeAccount_29, s0_.priceInEuroCent AS priceInEuroCent_30, s0_.isTaxIncluded AS isTaxIncluded_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isSinglePage AS isSinglePage_34, s0_.isFormalLanguage AS isFormalLanguage_35, s0_.isMultiBatchEvent AS isMultiBatchEvent_36, s0_.isFeatured AS isFeatured_37, s0_.capacity AS capacity_38, s0_.targetCapacity AS targetCapacity_39, s0_.twigFile AS twigFile_40, s0_.additionalCss AS additionalCss_41, s0_.content AS content_42, s0_.contentTwig AS contentTwig_43, s0_.ctaContent AS ctaContent_44, s0_.postCtaContent AS postCtaContent_45, s0_.tags AS tags_46, s0_.seriesTag AS seriesTag_47, s0_.feedbackFormId AS feedbackFormId_48, s0_.type AS type_49, s0_.location AS location_50, s0_.startDate AS startDate_51, s0_.endDate AS endDate_52, s0_.duration AS duration_53, s0_.status AS status_54, s0_.settings AS settings_55, s0_.displayStartDate AS displayStartDate_56, s0_.seoTitle AS seoTitle_57, s0_.seoKeyword AS seoKeyword_58, s0_.seoDescription AS seoDescription_59, s0_.navbar_en AS navbar_en_60, s0_.teaser_en AS teaser_en_61, s0_.content_en AS content_en_62, s0_.content_twig_en AS content_twig_en_63, s0_.post_cta_content_en AS post_cta_content_en_64, s0_.seo_title_en AS seo_title_en_65, s0_.seo_description_en AS seo_description_en_66, s0_.seo_keyword_en AS seo_keyword_en_67, s0_.has_english_version AS has_english_version_68, s0_.additional_js AS additional_js_69, s0_.metaPixelId AS metaPixelId_70, s0_.createDate AS createDate_71, s0_.lastChangeDate AS lastChangeDate_72, s0_.lastChangeUser AS lastChangeUser_73, s0_.publicId AS publicId_74, s0_.isExternalSubmission AS isExternalSubmission_75, s0_.createdBy AS createdBy_76, s0_.lastModified AS lastModified_77, s0_.createdAt AS createdAt_78, s0_.orgaNote AS orgaNote_79, s0_.calendarSyncedAt AS calendarSyncedAt_80, s0_.logisticsRoom AS logisticsRoom_81, s0_.logisticsCatering AS logisticsCatering_82, s0_.logisticsEquipment AS logisticsEquipment_83, s0_.logisticsHelpers AS logisticsHelpers_84, s0_.history AS history_85, s0_.todoHistory AS todoHistory_86 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.status = ?
SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.productId AS productId_2, s0_.eventDateNumber AS eventDateNumber_3, s0_.name AS name_4, s0_.slug AS slug_5, s0_.url AS url_6, s0_.status AS status_7, s0_.visibility AS visibility_8, s0_.access AS access_9, s0_.tags AS tags_10, s0_.lang AS lang_11, s0_.template AS template_12, s0_.pageTemplate AS pageTemplate_13, s0_.priceInEuroCent AS priceInEuroCent_14, s0_.start AS start_15, s0_.end AS end_16, s0_.startDate AS startDate_17, s0_.endDate AS endDate_18, s0_.createdAt AS createdAt_19, s0_.lastModified AS lastModified_20, s0_.lastChangeUser AS lastChangeUser_21, s0_.askForTeam AS askForTeam_22, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_23, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_24, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_25, s0_.hasIncludePhone AS hasIncludePhone_26, s0_.hasFollowUp AS hasFollowUp_27, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_28, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_29, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_30, s0_.isFreeForKiCampus AS isFreeForKiCampus_31, s0_.isFreeForCommunity AS isFreeForCommunity_32, s0_.isTaxIncluded AS isTaxIncluded_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.typeformLink AS typeformLink_35, s0_.zoomLink AS zoomLink_36, s0_.goToPage AS goToPage_37, s0_.city AS city_38, s0_.mailDesignTemplate AS mailDesignTemplate_39, s0_.senderMail AS senderMail_40, s0_.fromName AS fromName_41, s0_.recipientMonitoringMail AS recipientMonitoringMail_42, s0_.confirmationMailSubject AS confirmationMailSubject_43, s0_.confirmationMailContent AS confirmationMailContent_44, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_45, s0_.adminNotificationMailContent AS adminNotificationMailContent_46, s0_.reminderSenderEmail AS reminderSenderEmail_47, s0_.reminderMailSendDate AS reminderMailSendDate_48, s0_.reminderMailSubject AS reminderMailSubject_49, s0_.reminderMailContent AS reminderMailContent_50, s0_.reminderMailStatus AS reminderMailStatus_51, s0_.surveyId AS surveyId_52, s0_.surveyMailTemplateId AS surveyMailTemplateId_53, s0_.surveyBulkMailId AS surveyBulkMailId_54, s0_.applicationsCount AS applicationsCount_55, s0_.startedCount AS startedCount_56, s0_.appliedCount AS appliedCount_57, s0_.approvedCount AS approvedCount_58, s0_.rejectedCount AS rejectedCount_59, s0_.stripeAccount AS stripeAccount_60, s0_.stripePriceId AS stripePriceId_61, s0_.stripeProductId AS stripeProductId_62, s0_.stripePriceIdLive AS stripePriceIdLive_63, s0_.stripePriceIdTest AS stripePriceIdTest_64, s0_.stripeProductIdLive AS stripeProductIdLive_65, s0_.stripeProductIdTest AS stripeProductIdTest_66, s0_.taxBehavior AS taxBehavior_67, s0_.paymentProvider AS paymentProvider_68, s0_.registrationMode AS registrationMode_69, s0_.externalRegistrationUrl AS externalRegistrationUrl_70, s0_.externalPlatform AS externalPlatform_71, s0_.lumaEventApiId AS lumaEventApiId_72, s0_.meetupEventId AS meetupEventId_73, s0_.meetupEventUrl AS meetupEventUrl_74, s0_.registrationHeadline AS registrationHeadline_75, s0_.registrationSubtitle AS registrationSubtitle_76, s0_.registrationButtonText AS registrationButtonText_77, s0_.registrationPriceHtml AS registrationPriceHtml_78, s0_.registrationRedirectUrl AS registrationRedirectUrl_79, s0_.registrationTone AS registrationTone_80, s0_.remoteSessionText AS remoteSessionText_81, s0_.autoApprovalTag AS autoApprovalTag_82, s0_.capacity AS capacity_83, s0_.title AS title_84, s0_.teaser AS teaser_85, s0_.navbar AS navbar_86, s0_.content AS content_87, s0_.contentTwig AS contentTwig_88, s0_.ctaContent AS ctaContent_89, s0_.postCtaContent AS postCtaContent_90, s0_.tagline AS tagline_91, s0_.seoTitle AS seoTitle_92, s0_.seoDescription AS seoDescription_93, s0_.seoKeyword AS seoKeyword_94, s0_.imagelink AS imagelink_95, s0_.bgImagelink AS bgImagelink_96, s0_.videolink AS videolink_97, s0_.additionalCss AS additionalCss_98, s0_.additionalJs AS additionalJs_99, s0_.trainer AS trainer_100, s0_.venueName AS venueName_101, s0_.venueAddress AS venueAddress_102, s0_.whereOverride AS whereOverride_103, s0_.showFullVenue AS showFullVenue_104, s0_.navbarEn AS navbarEn_105, s0_.teaserEn AS teaserEn_106, s0_.contentEn AS contentEn_107, s0_.contentTwigEn AS contentTwigEn_108, s0_.postCtaContentEn AS postCtaContentEn_109, s0_.seoTitleEn AS seoTitleEn_110, s0_.seoDescriptionEn AS seoDescriptionEn_111, s0_.seoKeywordEn AS seoKeywordEn_112, s0_.email AS email_113, s0_.landingPageContent AS landingPageContent_114, s0_.landingPageDescription AS landingPageDescription_115, s0_.landingPageCss AS landingPageCss_116, s0_.landingPageJs AS landingPageJs_117, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_118, s0_.landingPageTitle AS landingPageTitle_119, s0_.followUpDescription AS followUpDescription_120, s0_.followUpVideoLink AS followUpVideoLink_121, s0_.followUpPresentation AS followUpPresentation_122, s0_.followUpPageContent AS followUpPageContent_123, s0_.followUpPageCss AS followUpPageCss_124, s0_.followUpPageTitle AS followUpPageTitle_125, s0_.followUpSkoolUrl AS followUpSkoolUrl_126, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_127, s0_.followUpCtaText AS followUpCtaText_128, s0_.followUpCtaUrl AS followUpCtaUrl_129, s0_.followUpDocuments AS followUpDocuments_130, s0_.followUpPhotos AS followUpPhotos_131, s0_.followUpExtraLinks AS followUpExtraLinks_132, s0_.history AS history_133, s0_.settings AS settings_134, s0_.skoolWebhook AS skoolWebhook_135, s0_.zapierWebhook AS zapierWebhook_136, s0_.metaLeadFormId AS metaLeadFormId_137, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_138 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND s0_.startDate > ? ORDER BY s0_.startDate ASC LIMIT 1
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_.title_en AS title_en_5, s0_.slug AS slug_6, s0_.lang AS lang_7, s0_.imagelink AS imagelink_8, s0_.videolink AS videolink_9, s0_.bgImagelink AS bgImagelink_10, s0_.tagline AS tagline_11, s0_.headerTextColor AS headerTextColor_12, s0_.spResponsiblePerson AS spResponsiblePerson_13, s0_.organization AS organization_14, s0_.organizerName AS organizerName_15, s0_.organizerEmail AS organizerEmail_16, s0_.venueName AS venueName_17, s0_.venueAddress AS venueAddress_18, s0_.showFullVenue AS showFullVenue_19, s0_.ticketing AS ticketing_20, s0_.applicationUrl AS applicationUrl_21, s0_.alert AS alert_22, s0_.trainer AS trainer_23, s0_.speakers AS speakers_24, s0_.teaser AS teaser_25, s0_.navbar AS navbar_26, s0_.stripePriceId AS stripePriceId_27, s0_.stripeProductId AS stripeProductId_28, s0_.stripeAccount AS stripeAccount_29, s0_.priceInEuroCent AS priceInEuroCent_30, s0_.isTaxIncluded AS isTaxIncluded_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isSinglePage AS isSinglePage_34, s0_.isFormalLanguage AS isFormalLanguage_35, s0_.isMultiBatchEvent AS isMultiBatchEvent_36, s0_.isFeatured AS isFeatured_37, s0_.capacity AS capacity_38, s0_.targetCapacity AS targetCapacity_39, s0_.twigFile AS twigFile_40, s0_.additionalCss AS additionalCss_41, s0_.content AS content_42, s0_.contentTwig AS contentTwig_43, s0_.ctaContent AS ctaContent_44, s0_.postCtaContent AS postCtaContent_45, s0_.tags AS tags_46, s0_.seriesTag AS seriesTag_47, s0_.feedbackFormId AS feedbackFormId_48, s0_.type AS type_49, s0_.location AS location_50, s0_.startDate AS startDate_51, s0_.endDate AS endDate_52, s0_.duration AS duration_53, s0_.status AS status_54, s0_.settings AS settings_55, s0_.displayStartDate AS displayStartDate_56, s0_.seoTitle AS seoTitle_57, s0_.seoKeyword AS seoKeyword_58, s0_.seoDescription AS seoDescription_59, s0_.navbar_en AS navbar_en_60, s0_.teaser_en AS teaser_en_61, s0_.content_en AS content_en_62, s0_.content_twig_en AS content_twig_en_63, s0_.post_cta_content_en AS post_cta_content_en_64, s0_.seo_title_en AS seo_title_en_65, s0_.seo_description_en AS seo_description_en_66, s0_.seo_keyword_en AS seo_keyword_en_67, s0_.has_english_version AS has_english_version_68, s0_.additional_js AS additional_js_69, s0_.metaPixelId AS metaPixelId_70, s0_.createDate AS createDate_71, s0_.lastChangeDate AS lastChangeDate_72, s0_.lastChangeUser AS lastChangeUser_73, s0_.publicId AS publicId_74, s0_.isExternalSubmission AS isExternalSubmission_75, s0_.createdBy AS createdBy_76, s0_.lastModified AS lastModified_77, s0_.createdAt AS createdAt_78, s0_.orgaNote AS orgaNote_79, s0_.calendarSyncedAt AS calendarSyncedAt_80, s0_.logisticsRoom AS logisticsRoom_81, s0_.logisticsCatering AS logisticsCatering_82, s0_.logisticsEquipment AS logisticsEquipment_83, s0_.logisticsHelpers AS logisticsHelpers_84, s0_.history AS history_85, s0_.todoHistory AS todoHistory_86 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_.title_en AS title_en_5, s0_.slug AS slug_6, s0_.lang AS lang_7, s0_.imagelink AS imagelink_8, s0_.videolink AS videolink_9, s0_.bgImagelink AS bgImagelink_10, s0_.tagline AS tagline_11, s0_.headerTextColor AS headerTextColor_12, s0_.spResponsiblePerson AS spResponsiblePerson_13, s0_.organization AS organization_14, s0_.organizerName AS organizerName_15, s0_.organizerEmail AS organizerEmail_16, s0_.venueName AS venueName_17, s0_.venueAddress AS venueAddress_18, s0_.showFullVenue AS showFullVenue_19, s0_.ticketing AS ticketing_20, s0_.applicationUrl AS applicationUrl_21, s0_.alert AS alert_22, s0_.trainer AS trainer_23, s0_.speakers AS speakers_24, s0_.teaser AS teaser_25, s0_.navbar AS navbar_26, s0_.stripePriceId AS stripePriceId_27, s0_.stripeProductId AS stripeProductId_28, s0_.stripeAccount AS stripeAccount_29, s0_.priceInEuroCent AS priceInEuroCent_30, s0_.isTaxIncluded AS isTaxIncluded_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isSinglePage AS isSinglePage_34, s0_.isFormalLanguage AS isFormalLanguage_35, s0_.isMultiBatchEvent AS isMultiBatchEvent_36, s0_.isFeatured AS isFeatured_37, s0_.capacity AS capacity_38, s0_.targetCapacity AS targetCapacity_39, s0_.twigFile AS twigFile_40, s0_.additionalCss AS additionalCss_41, s0_.content AS content_42, s0_.contentTwig AS contentTwig_43, s0_.ctaContent AS ctaContent_44, s0_.postCtaContent AS postCtaContent_45, s0_.tags AS tags_46, s0_.seriesTag AS seriesTag_47, s0_.feedbackFormId AS feedbackFormId_48, s0_.type AS type_49, s0_.location AS location_50, s0_.startDate AS startDate_51, s0_.endDate AS endDate_52, s0_.duration AS duration_53, s0_.status AS status_54, s0_.settings AS settings_55, s0_.displayStartDate AS displayStartDate_56, s0_.seoTitle AS seoTitle_57, s0_.seoKeyword AS seoKeyword_58, s0_.seoDescription AS seoDescription_59, s0_.navbar_en AS navbar_en_60, s0_.teaser_en AS teaser_en_61, s0_.content_en AS content_en_62, s0_.content_twig_en AS content_twig_en_63, s0_.post_cta_content_en AS post_cta_content_en_64, s0_.seo_title_en AS seo_title_en_65, s0_.seo_description_en AS seo_description_en_66, s0_.seo_keyword_en AS seo_keyword_en_67, s0_.has_english_version AS has_english_version_68, s0_.additional_js AS additional_js_69, s0_.metaPixelId AS metaPixelId_70, s0_.createDate AS createDate_71, s0_.lastChangeDate AS lastChangeDate_72, s0_.lastChangeUser AS lastChangeUser_73, s0_.publicId AS publicId_74, s0_.isExternalSubmission AS isExternalSubmission_75, s0_.createdBy AS createdBy_76, s0_.lastModified AS lastModified_77, s0_.createdAt AS createdAt_78, s0_.orgaNote AS orgaNote_79, s0_.calendarSyncedAt AS calendarSyncedAt_80, s0_.logisticsRoom AS logisticsRoom_81, s0_.logisticsCatering AS logisticsCatering_82, s0_.logisticsEquipment AS logisticsEquipment_83, s0_.logisticsHelpers AS logisticsHelpers_84, s0_.history AS history_85, s0_.todoHistory AS todoHistory_86 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.id <> ? AND s0_.status = ?
SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.productId AS productId_2, s0_.eventDateNumber AS eventDateNumber_3, s0_.name AS name_4, s0_.slug AS slug_5, s0_.url AS url_6, s0_.status AS status_7, s0_.visibility AS visibility_8, s0_.access AS access_9, s0_.tags AS tags_10, s0_.lang AS lang_11, s0_.template AS template_12, s0_.pageTemplate AS pageTemplate_13, s0_.priceInEuroCent AS priceInEuroCent_14, s0_.start AS start_15, s0_.end AS end_16, s0_.startDate AS startDate_17, s0_.endDate AS endDate_18, s0_.createdAt AS createdAt_19, s0_.lastModified AS lastModified_20, s0_.lastChangeUser AS lastChangeUser_21, s0_.askForTeam AS askForTeam_22, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_23, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_24, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_25, s0_.hasIncludePhone AS hasIncludePhone_26, s0_.hasFollowUp AS hasFollowUp_27, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_28, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_29, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_30, s0_.isFreeForKiCampus AS isFreeForKiCampus_31, s0_.isFreeForCommunity AS isFreeForCommunity_32, s0_.isTaxIncluded AS isTaxIncluded_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.typeformLink AS typeformLink_35, s0_.zoomLink AS zoomLink_36, s0_.goToPage AS goToPage_37, s0_.city AS city_38, s0_.mailDesignTemplate AS mailDesignTemplate_39, s0_.senderMail AS senderMail_40, s0_.fromName AS fromName_41, s0_.recipientMonitoringMail AS recipientMonitoringMail_42, s0_.confirmationMailSubject AS confirmationMailSubject_43, s0_.confirmationMailContent AS confirmationMailContent_44, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_45, s0_.adminNotificationMailContent AS adminNotificationMailContent_46, s0_.reminderSenderEmail AS reminderSenderEmail_47, s0_.reminderMailSendDate AS reminderMailSendDate_48, s0_.reminderMailSubject AS reminderMailSubject_49, s0_.reminderMailContent AS reminderMailContent_50, s0_.reminderMailStatus AS reminderMailStatus_51, s0_.surveyId AS surveyId_52, s0_.surveyMailTemplateId AS surveyMailTemplateId_53, s0_.surveyBulkMailId AS surveyBulkMailId_54, s0_.applicationsCount AS applicationsCount_55, s0_.startedCount AS startedCount_56, s0_.appliedCount AS appliedCount_57, s0_.approvedCount AS approvedCount_58, s0_.rejectedCount AS rejectedCount_59, s0_.stripeAccount AS stripeAccount_60, s0_.stripePriceId AS stripePriceId_61, s0_.stripeProductId AS stripeProductId_62, s0_.stripePriceIdLive AS stripePriceIdLive_63, s0_.stripePriceIdTest AS stripePriceIdTest_64, s0_.stripeProductIdLive AS stripeProductIdLive_65, s0_.stripeProductIdTest AS stripeProductIdTest_66, s0_.taxBehavior AS taxBehavior_67, s0_.paymentProvider AS paymentProvider_68, s0_.registrationMode AS registrationMode_69, s0_.externalRegistrationUrl AS externalRegistrationUrl_70, s0_.externalPlatform AS externalPlatform_71, s0_.lumaEventApiId AS lumaEventApiId_72, s0_.meetupEventId AS meetupEventId_73, s0_.meetupEventUrl AS meetupEventUrl_74, s0_.registrationHeadline AS registrationHeadline_75, s0_.registrationSubtitle AS registrationSubtitle_76, s0_.registrationButtonText AS registrationButtonText_77, s0_.registrationPriceHtml AS registrationPriceHtml_78, s0_.registrationRedirectUrl AS registrationRedirectUrl_79, s0_.registrationTone AS registrationTone_80, s0_.remoteSessionText AS remoteSessionText_81, s0_.autoApprovalTag AS autoApprovalTag_82, s0_.capacity AS capacity_83, s0_.title AS title_84, s0_.teaser AS teaser_85, s0_.navbar AS navbar_86, s0_.content AS content_87, s0_.contentTwig AS contentTwig_88, s0_.ctaContent AS ctaContent_89, s0_.postCtaContent AS postCtaContent_90, s0_.tagline AS tagline_91, s0_.seoTitle AS seoTitle_92, s0_.seoDescription AS seoDescription_93, s0_.seoKeyword AS seoKeyword_94, s0_.imagelink AS imagelink_95, s0_.bgImagelink AS bgImagelink_96, s0_.videolink AS videolink_97, s0_.additionalCss AS additionalCss_98, s0_.additionalJs AS additionalJs_99, s0_.trainer AS trainer_100, s0_.venueName AS venueName_101, s0_.venueAddress AS venueAddress_102, s0_.whereOverride AS whereOverride_103, s0_.showFullVenue AS showFullVenue_104, s0_.navbarEn AS navbarEn_105, s0_.teaserEn AS teaserEn_106, s0_.contentEn AS contentEn_107, s0_.contentTwigEn AS contentTwigEn_108, s0_.postCtaContentEn AS postCtaContentEn_109, s0_.seoTitleEn AS seoTitleEn_110, s0_.seoDescriptionEn AS seoDescriptionEn_111, s0_.seoKeywordEn AS seoKeywordEn_112, s0_.email AS email_113, s0_.landingPageContent AS landingPageContent_114, s0_.landingPageDescription AS landingPageDescription_115, s0_.landingPageCss AS landingPageCss_116, s0_.landingPageJs AS landingPageJs_117, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_118, s0_.landingPageTitle AS landingPageTitle_119, s0_.followUpDescription AS followUpDescription_120, s0_.followUpVideoLink AS followUpVideoLink_121, s0_.followUpPresentation AS followUpPresentation_122, s0_.followUpPageContent AS followUpPageContent_123, s0_.followUpPageCss AS followUpPageCss_124, s0_.followUpPageTitle AS followUpPageTitle_125, s0_.followUpSkoolUrl AS followUpSkoolUrl_126, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_127, s0_.followUpCtaText AS followUpCtaText_128, s0_.followUpCtaUrl AS followUpCtaUrl_129, s0_.followUpDocuments AS followUpDocuments_130, s0_.followUpPhotos AS followUpPhotos_131, s0_.followUpExtraLinks AS followUpExtraLinks_132, s0_.history AS history_133, s0_.settings AS settings_134, s0_.skoolWebhook AS skoolWebhook_135, s0_.zapierWebhook AS zapierWebhook_136, s0_.metaLeadFormId AS metaLeadFormId_137, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_138 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND s0_.status = ? AND s0_.access = ? AND (s0_.startDate IS NOT NULL AND s0_.startDate >= ?) ORDER BY s0_.startDate ASC LIMIT 1
SELECT 
                b.id as batch_id,
                b.eventId as event_id,
                b.name as batch_name,
                b.slug as batch_slug,
                b.startDate 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_event_dates b ON b.eventId = e.id
            WHERE e.seriesTag = ?
            AND e.status = 'publish'
            AND b.status = 'active'
            AND e.isMultiBatchEvent = 1
            AND b.startDate > NOW()
         ORDER BY b.startDate 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) 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_event_dates b ON b.eventId = e.id
            WHERE e.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())
            )
         ORDER BY COALESCE(b.endDate, b.startDate) DESC

#▲	Time	Info
1	22.03 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_.title_en AS title_en_5, s0_.slug AS slug_6, s0_.lang AS lang_7, s0_.imagelink AS imagelink_8, s0_.videolink AS videolink_9, s0_.bgImagelink AS bgImagelink_10, s0_.tagline AS tagline_11, s0_.headerTextColor AS headerTextColor_12, s0_.spResponsiblePerson AS spResponsiblePerson_13, s0_.organization AS organization_14, s0_.organizerName AS organizerName_15, s0_.organizerEmail AS organizerEmail_16, s0_.venueName AS venueName_17, s0_.venueAddress AS venueAddress_18, s0_.showFullVenue AS showFullVenue_19, s0_.ticketing AS ticketing_20, s0_.applicationUrl AS applicationUrl_21, s0_.alert AS alert_22, s0_.trainer AS trainer_23, s0_.speakers AS speakers_24, s0_.teaser AS teaser_25, s0_.navbar AS navbar_26, s0_.stripePriceId AS stripePriceId_27, s0_.stripeProductId AS stripeProductId_28, s0_.stripeAccount AS stripeAccount_29, s0_.priceInEuroCent AS priceInEuroCent_30, s0_.isTaxIncluded AS isTaxIncluded_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isSinglePage AS isSinglePage_34, s0_.isFormalLanguage AS isFormalLanguage_35, s0_.isMultiBatchEvent AS isMultiBatchEvent_36, s0_.isFeatured AS isFeatured_37, s0_.capacity AS capacity_38, s0_.targetCapacity AS targetCapacity_39, s0_.twigFile AS twigFile_40, s0_.additionalCss AS additionalCss_41, s0_.content AS content_42, s0_.contentTwig AS contentTwig_43, s0_.ctaContent AS ctaContent_44, s0_.postCtaContent AS postCtaContent_45, s0_.tags AS tags_46, s0_.seriesTag AS seriesTag_47, s0_.feedbackFormId AS feedbackFormId_48, s0_.type AS type_49, s0_.location AS location_50, s0_.startDate AS startDate_51, s0_.endDate AS endDate_52, s0_.duration AS duration_53, s0_.status AS status_54, s0_.settings AS settings_55, s0_.displayStartDate AS displayStartDate_56, s0_.seoTitle AS seoTitle_57, s0_.seoKeyword AS seoKeyword_58, s0_.seoDescription AS seoDescription_59, s0_.navbar_en AS navbar_en_60, s0_.teaser_en AS teaser_en_61, s0_.content_en AS content_en_62, s0_.content_twig_en AS content_twig_en_63, s0_.post_cta_content_en AS post_cta_content_en_64, s0_.seo_title_en AS seo_title_en_65, s0_.seo_description_en AS seo_description_en_66, s0_.seo_keyword_en AS seo_keyword_en_67, s0_.has_english_version AS has_english_version_68, s0_.additional_js AS additional_js_69, s0_.metaPixelId AS metaPixelId_70, s0_.createDate AS createDate_71, s0_.lastChangeDate AS lastChangeDate_72, s0_.lastChangeUser AS lastChangeUser_73, s0_.publicId AS publicId_74, s0_.isExternalSubmission AS isExternalSubmission_75, s0_.createdBy AS createdBy_76, s0_.lastModified AS lastModified_77, s0_.createdAt AS createdAt_78, s0_.orgaNote AS orgaNote_79, s0_.calendarSyncedAt AS calendarSyncedAt_80, s0_.logisticsRoom AS logisticsRoom_81, s0_.logisticsCatering AS logisticsCatering_82, s0_.logisticsEquipment AS logisticsEquipment_83, s0_.logisticsHelpers AS logisticsHelpers_84, s0_.history AS history_85, s0_.todoHistory AS todoHistory_86 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.status = ? Parameters: [`"TechTuesday" "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_.title_en AS title_en_5, s0_.slug AS slug_6, s0_.lang AS lang_7, s0_.imagelink AS imagelink_8, s0_.videolink AS videolink_9, s0_.bgImagelink AS bgImagelink_10, s0_.tagline AS tagline_11, s0_.headerTextColor AS headerTextColor_12, s0_.spResponsiblePerson AS spResponsiblePerson_13, s0_.organization AS organization_14, s0_.organizerName AS organizerName_15, s0_.organizerEmail AS organizerEmail_16, s0_.venueName AS venueName_17, s0_.venueAddress AS venueAddress_18, s0_.showFullVenue AS showFullVenue_19, s0_.ticketing AS ticketing_20, s0_.applicationUrl AS applicationUrl_21, s0_.alert AS alert_22, s0_.trainer AS trainer_23, s0_.speakers AS speakers_24, s0_.teaser AS teaser_25, s0_.navbar AS navbar_26, s0_.stripePriceId AS stripePriceId_27, s0_.stripeProductId AS stripeProductId_28, s0_.stripeAccount AS stripeAccount_29, s0_.priceInEuroCent AS priceInEuroCent_30, s0_.isTaxIncluded AS isTaxIncluded_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isSinglePage AS isSinglePage_34, s0_.isFormalLanguage AS isFormalLanguage_35, s0_.isMultiBatchEvent AS isMultiBatchEvent_36, s0_.isFeatured AS isFeatured_37, s0_.capacity AS capacity_38, s0_.targetCapacity AS targetCapacity_39, s0_.twigFile AS twigFile_40, s0_.additionalCss AS additionalCss_41, s0_.content AS content_42, s0_.contentTwig AS contentTwig_43, s0_.ctaContent AS ctaContent_44, s0_.postCtaContent AS postCtaContent_45, s0_.tags AS tags_46, s0_.seriesTag AS seriesTag_47, s0_.feedbackFormId AS feedbackFormId_48, s0_.type AS type_49, s0_.location AS location_50, s0_.startDate AS startDate_51, s0_.endDate AS endDate_52, s0_.duration AS duration_53, s0_.status AS status_54, s0_.settings AS settings_55, s0_.displayStartDate AS displayStartDate_56, s0_.seoTitle AS seoTitle_57, s0_.seoKeyword AS seoKeyword_58, s0_.seoDescription AS seoDescription_59, s0_.navbar_en AS navbar_en_60, s0_.teaser_en AS teaser_en_61, s0_.content_en AS content_en_62, s0_.content_twig_en AS content_twig_en_63, s0_.post_cta_content_en AS post_cta_content_en_64, s0_.seo_title_en AS seo_title_en_65, s0_.seo_description_en AS seo_description_en_66, s0_.seo_keyword_en AS seo_keyword_en_67, s0_.has_english_version AS has_english_version_68, s0_.additional_js AS additional_js_69, s0_.metaPixelId AS metaPixelId_70, s0_.createDate AS createDate_71, s0_.lastChangeDate AS lastChangeDate_72, s0_.lastChangeUser AS lastChangeUser_73, s0_.publicId AS publicId_74, s0_.isExternalSubmission AS isExternalSubmission_75, s0_.createdBy AS createdBy_76, s0_.lastModified AS lastModified_77, s0_.createdAt AS createdAt_78, s0_.orgaNote AS orgaNote_79, s0_.calendarSyncedAt AS calendarSyncedAt_80, s0_.logisticsRoom AS logisticsRoom_81, s0_.logisticsCatering AS logisticsCatering_82, s0_.logisticsEquipment AS logisticsEquipment_83, s0_.logisticsHelpers AS logisticsHelpers_84, s0_.history AS history_85, s0_.todoHistory AS todoHistory_86 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_.title_en AS title_en_5, s0_.slug AS slug_6, s0_.lang AS lang_7, s0_.imagelink AS imagelink_8, s0_.videolink AS videolink_9, s0_.bgImagelink AS bgImagelink_10, s0_.tagline AS tagline_11, s0_.headerTextColor AS headerTextColor_12, s0_.spResponsiblePerson AS spResponsiblePerson_13, s0_.organization AS organization_14, s0_.organizerName AS organizerName_15, s0_.organizerEmail AS organizerEmail_16, s0_.venueName AS venueName_17, s0_.venueAddress AS venueAddress_18, s0_.showFullVenue AS showFullVenue_19, s0_.ticketing AS ticketing_20, s0_.applicationUrl AS applicationUrl_21, s0_.alert AS alert_22, s0_.trainer AS trainer_23, s0_.speakers AS speakers_24, s0_.teaser AS teaser_25, s0_.navbar AS navbar_26, s0_.stripePriceId AS stripePriceId_27, s0_.stripeProductId AS stripeProductId_28, s0_.stripeAccount AS stripeAccount_29, s0_.priceInEuroCent AS priceInEuroCent_30, s0_.isTaxIncluded AS isTaxIncluded_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isSinglePage AS isSinglePage_34, s0_.isFormalLanguage AS isFormalLanguage_35, s0_.isMultiBatchEvent AS isMultiBatchEvent_36, s0_.isFeatured AS isFeatured_37, s0_.capacity AS capacity_38, s0_.targetCapacity AS targetCapacity_39, s0_.twigFile AS twigFile_40, s0_.additionalCss AS additionalCss_41, s0_.content AS content_42, s0_.contentTwig AS contentTwig_43, s0_.ctaContent AS ctaContent_44, s0_.postCtaContent AS postCtaContent_45, s0_.tags AS tags_46, s0_.seriesTag AS seriesTag_47, s0_.feedbackFormId AS feedbackFormId_48, s0_.type AS type_49, s0_.location AS location_50, s0_.startDate AS startDate_51, s0_.endDate AS endDate_52, s0_.duration AS duration_53, s0_.status AS status_54, s0_.settings AS settings_55, s0_.displayStartDate AS displayStartDate_56, s0_.seoTitle AS seoTitle_57, s0_.seoKeyword AS seoKeyword_58, s0_.seoDescription AS seoDescription_59, s0_.navbar_en AS navbar_en_60, s0_.teaser_en AS teaser_en_61, s0_.content_en AS content_en_62, s0_.content_twig_en AS content_twig_en_63, s0_.post_cta_content_en AS post_cta_content_en_64, s0_.seo_title_en AS seo_title_en_65, s0_.seo_description_en AS seo_description_en_66, s0_.seo_keyword_en AS seo_keyword_en_67, s0_.has_english_version AS has_english_version_68, s0_.additional_js AS additional_js_69, s0_.metaPixelId AS metaPixelId_70, s0_.createDate AS createDate_71, s0_.lastChangeDate AS lastChangeDate_72, s0_.lastChangeUser AS lastChangeUser_73, s0_.publicId AS publicId_74, s0_.isExternalSubmission AS isExternalSubmission_75, s0_.createdBy AS createdBy_76, s0_.lastModified AS lastModified_77, s0_.createdAt AS createdAt_78, s0_.orgaNote AS orgaNote_79, s0_.calendarSyncedAt AS calendarSyncedAt_80, s0_.logisticsRoom AS logisticsRoom_81, s0_.logisticsCatering AS logisticsCatering_82, s0_.logisticsEquipment AS logisticsEquipment_83, s0_.logisticsHelpers AS logisticsHelpers_84, s0_.history AS history_85, s0_.todoHistory AS todoHistory_86 FROM sp_event_events s0_ WHERE s0_.seriesTag = 'TechTuesday' AND s0_.status = 'publish';
2	0.90 ms	SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.productId AS productId_2, s0_.eventDateNumber AS eventDateNumber_3, s0_.name AS name_4, s0_.slug AS slug_5, s0_.url AS url_6, s0_.status AS status_7, s0_.visibility AS visibility_8, s0_.access AS access_9, s0_.tags AS tags_10, s0_.lang AS lang_11, s0_.template AS template_12, s0_.pageTemplate AS pageTemplate_13, s0_.priceInEuroCent AS priceInEuroCent_14, s0_.start AS start_15, s0_.end AS end_16, s0_.startDate AS startDate_17, s0_.endDate AS endDate_18, s0_.createdAt AS createdAt_19, s0_.lastModified AS lastModified_20, s0_.lastChangeUser AS lastChangeUser_21, s0_.askForTeam AS askForTeam_22, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_23, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_24, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_25, s0_.hasIncludePhone AS hasIncludePhone_26, s0_.hasFollowUp AS hasFollowUp_27, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_28, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_29, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_30, s0_.isFreeForKiCampus AS isFreeForKiCampus_31, s0_.isFreeForCommunity AS isFreeForCommunity_32, s0_.isTaxIncluded AS isTaxIncluded_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.typeformLink AS typeformLink_35, s0_.zoomLink AS zoomLink_36, s0_.goToPage AS goToPage_37, s0_.city AS city_38, s0_.mailDesignTemplate AS mailDesignTemplate_39, s0_.senderMail AS senderMail_40, s0_.fromName AS fromName_41, s0_.recipientMonitoringMail AS recipientMonitoringMail_42, s0_.confirmationMailSubject AS confirmationMailSubject_43, s0_.confirmationMailContent AS confirmationMailContent_44, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_45, s0_.adminNotificationMailContent AS adminNotificationMailContent_46, s0_.reminderSenderEmail AS reminderSenderEmail_47, s0_.reminderMailSendDate AS reminderMailSendDate_48, s0_.reminderMailSubject AS reminderMailSubject_49, s0_.reminderMailContent AS reminderMailContent_50, s0_.reminderMailStatus AS reminderMailStatus_51, s0_.surveyId AS surveyId_52, s0_.surveyMailTemplateId AS surveyMailTemplateId_53, s0_.surveyBulkMailId AS surveyBulkMailId_54, s0_.applicationsCount AS applicationsCount_55, s0_.startedCount AS startedCount_56, s0_.appliedCount AS appliedCount_57, s0_.approvedCount AS approvedCount_58, s0_.rejectedCount AS rejectedCount_59, s0_.stripeAccount AS stripeAccount_60, s0_.stripePriceId AS stripePriceId_61, s0_.stripeProductId AS stripeProductId_62, s0_.stripePriceIdLive AS stripePriceIdLive_63, s0_.stripePriceIdTest AS stripePriceIdTest_64, s0_.stripeProductIdLive AS stripeProductIdLive_65, s0_.stripeProductIdTest AS stripeProductIdTest_66, s0_.taxBehavior AS taxBehavior_67, s0_.paymentProvider AS paymentProvider_68, s0_.registrationMode AS registrationMode_69, s0_.externalRegistrationUrl AS externalRegistrationUrl_70, s0_.externalPlatform AS externalPlatform_71, s0_.lumaEventApiId AS lumaEventApiId_72, s0_.meetupEventId AS meetupEventId_73, s0_.meetupEventUrl AS meetupEventUrl_74, s0_.registrationHeadline AS registrationHeadline_75, s0_.registrationSubtitle AS registrationSubtitle_76, s0_.registrationButtonText AS registrationButtonText_77, s0_.registrationPriceHtml AS registrationPriceHtml_78, s0_.registrationRedirectUrl AS registrationRedirectUrl_79, s0_.registrationTone AS registrationTone_80, s0_.remoteSessionText AS remoteSessionText_81, s0_.autoApprovalTag AS autoApprovalTag_82, s0_.capacity AS capacity_83, s0_.title AS title_84, s0_.teaser AS teaser_85, s0_.navbar AS navbar_86, s0_.content AS content_87, s0_.contentTwig AS contentTwig_88, s0_.ctaContent AS ctaContent_89, s0_.postCtaContent AS postCtaContent_90, s0_.tagline AS tagline_91, s0_.seoTitle AS seoTitle_92, s0_.seoDescription AS seoDescription_93, s0_.seoKeyword AS seoKeyword_94, s0_.imagelink AS imagelink_95, s0_.bgImagelink AS bgImagelink_96, s0_.videolink AS videolink_97, s0_.additionalCss AS additionalCss_98, s0_.additionalJs AS additionalJs_99, s0_.trainer AS trainer_100, s0_.venueName AS venueName_101, s0_.venueAddress AS venueAddress_102, s0_.whereOverride AS whereOverride_103, s0_.showFullVenue AS showFullVenue_104, s0_.navbarEn AS navbarEn_105, s0_.teaserEn AS teaserEn_106, s0_.contentEn AS contentEn_107, s0_.contentTwigEn AS contentTwigEn_108, s0_.postCtaContentEn AS postCtaContentEn_109, s0_.seoTitleEn AS seoTitleEn_110, s0_.seoDescriptionEn AS seoDescriptionEn_111, s0_.seoKeywordEn AS seoKeywordEn_112, s0_.email AS email_113, s0_.landingPageContent AS landingPageContent_114, s0_.landingPageDescription AS landingPageDescription_115, s0_.landingPageCss AS landingPageCss_116, s0_.landingPageJs AS landingPageJs_117, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_118, s0_.landingPageTitle AS landingPageTitle_119, s0_.followUpDescription AS followUpDescription_120, s0_.followUpVideoLink AS followUpVideoLink_121, s0_.followUpPresentation AS followUpPresentation_122, s0_.followUpPageContent AS followUpPageContent_123, s0_.followUpPageCss AS followUpPageCss_124, s0_.followUpPageTitle AS followUpPageTitle_125, s0_.followUpSkoolUrl AS followUpSkoolUrl_126, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_127, s0_.followUpCtaText AS followUpCtaText_128, s0_.followUpCtaUrl AS followUpCtaUrl_129, s0_.followUpDocuments AS followUpDocuments_130, s0_.followUpPhotos AS followUpPhotos_131, s0_.followUpExtraLinks AS followUpExtraLinks_132, s0_.history AS history_133, s0_.settings AS settings_134, s0_.skoolWebhook AS skoolWebhook_135, s0_.zapierWebhook AS zapierWebhook_136, s0_.metaLeadFormId AS metaLeadFormId_137, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_138 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND s0_.startDate > ? ORDER BY s0_.startDate ASC LIMIT 1 Parameters: [`7026 "2026-06-11 06:32:48"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.productId AS productId_2, s0_.eventDateNumber AS eventDateNumber_3, s0_.name AS name_4, s0_.slug AS slug_5, s0_.url AS url_6, s0_.status AS status_7, s0_.visibility AS visibility_8, s0_.access AS access_9, s0_.tags AS tags_10, s0_.lang AS lang_11, s0_.template AS template_12, s0_.pageTemplate AS pageTemplate_13, s0_.priceInEuroCent AS priceInEuroCent_14, s0_.start AS start_15, s0_.end AS end_16, s0_.startDate AS startDate_17, s0_.endDate AS endDate_18, s0_.createdAt AS createdAt_19, s0_.lastModified AS lastModified_20, s0_.lastChangeUser AS lastChangeUser_21, s0_.askForTeam AS askForTeam_22, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_23, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_24, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_25, s0_.hasIncludePhone AS hasIncludePhone_26, s0_.hasFollowUp AS hasFollowUp_27, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_28, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_29, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_30, s0_.isFreeForKiCampus AS isFreeForKiCampus_31, s0_.isFreeForCommunity AS isFreeForCommunity_32, s0_.isTaxIncluded AS isTaxIncluded_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.typeformLink AS typeformLink_35, s0_.zoomLink AS zoomLink_36, s0_.goToPage AS goToPage_37, s0_.city AS city_38, s0_.mailDesignTemplate AS mailDesignTemplate_39, s0_.senderMail AS senderMail_40, s0_.fromName AS fromName_41, s0_.recipientMonitoringMail AS recipientMonitoringMail_42, s0_.confirmationMailSubject AS confirmationMailSubject_43, s0_.confirmationMailContent AS confirmationMailContent_44, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_45, s0_.adminNotificationMailContent AS adminNotificationMailContent_46, s0_.reminderSenderEmail AS reminderSenderEmail_47, s0_.reminderMailSendDate AS reminderMailSendDate_48, s0_.reminderMailSubject AS reminderMailSubject_49, s0_.reminderMailContent AS reminderMailContent_50, s0_.reminderMailStatus AS reminderMailStatus_51, s0_.surveyId AS surveyId_52, s0_.surveyMailTemplateId AS surveyMailTemplateId_53, s0_.surveyBulkMailId AS surveyBulkMailId_54, s0_.applicationsCount AS applicationsCount_55, s0_.startedCount AS startedCount_56, s0_.appliedCount AS appliedCount_57, s0_.approvedCount AS approvedCount_58, s0_.rejectedCount AS rejectedCount_59, s0_.stripeAccount AS stripeAccount_60, s0_.stripePriceId AS stripePriceId_61, s0_.stripeProductId AS stripeProductId_62, s0_.stripePriceIdLive AS stripePriceIdLive_63, s0_.stripePriceIdTest AS stripePriceIdTest_64, s0_.stripeProductIdLive AS stripeProductIdLive_65, s0_.stripeProductIdTest AS stripeProductIdTest_66, s0_.taxBehavior AS taxBehavior_67, s0_.paymentProvider AS paymentProvider_68, s0_.registrationMode AS registrationMode_69, s0_.externalRegistrationUrl AS externalRegistrationUrl_70, s0_.externalPlatform AS externalPlatform_71, s0_.lumaEventApiId AS lumaEventApiId_72, s0_.meetupEventId AS meetupEventId_73, s0_.meetupEventUrl AS meetupEventUrl_74, s0_.registrationHeadline AS registrationHeadline_75, s0_.registrationSubtitle AS registrationSubtitle_76, s0_.registrationButtonText AS registrationButtonText_77, s0_.registrationPriceHtml AS registrationPriceHtml_78, s0_.registrationRedirectUrl AS registrationRedirectUrl_79, s0_.registrationTone AS registrationTone_80, s0_.remoteSessionText AS remoteSessionText_81, s0_.autoApprovalTag AS autoApprovalTag_82, s0_.capacity AS capacity_83, s0_.title AS title_84, s0_.teaser AS teaser_85, s0_.navbar AS navbar_86, s0_.content AS content_87, s0_.contentTwig AS contentTwig_88, s0_.ctaContent AS ctaContent_89, s0_.postCtaContent AS postCtaContent_90, s0_.tagline AS tagline_91, s0_.seoTitle AS seoTitle_92, s0_.seoDescription AS seoDescription_93, s0_.seoKeyword AS seoKeyword_94, s0_.imagelink AS imagelink_95, s0_.bgImagelink AS bgImagelink_96, s0_.videolink AS videolink_97, s0_.additionalCss AS additionalCss_98, s0_.additionalJs AS additionalJs_99, s0_.trainer AS trainer_100, s0_.venueName AS venueName_101, s0_.venueAddress AS venueAddress_102, s0_.whereOverride AS whereOverride_103, s0_.showFullVenue AS showFullVenue_104, s0_.navbarEn AS navbarEn_105, s0_.teaserEn AS teaserEn_106, s0_.contentEn AS contentEn_107, s0_.contentTwigEn AS contentTwigEn_108, s0_.postCtaContentEn AS postCtaContentEn_109, s0_.seoTitleEn AS seoTitleEn_110, s0_.seoDescriptionEn AS seoDescriptionEn_111, s0_.seoKeywordEn AS seoKeywordEn_112, s0_.email AS email_113, s0_.landingPageContent AS landingPageContent_114, s0_.landingPageDescription AS landingPageDescription_115, s0_.landingPageCss AS landingPageCss_116, s0_.landingPageJs AS landingPageJs_117, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_118, s0_.landingPageTitle AS landingPageTitle_119, s0_.followUpDescription AS followUpDescription_120, s0_.followUpVideoLink AS followUpVideoLink_121, s0_.followUpPresentation AS followUpPresentation_122, s0_.followUpPageContent AS followUpPageContent_123, s0_.followUpPageCss AS followUpPageCss_124, s0_.followUpPageTitle AS followUpPageTitle_125, s0_.followUpSkoolUrl AS followUpSkoolUrl_126, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_127, s0_.followUpCtaText AS followUpCtaText_128, s0_.followUpCtaUrl AS followUpCtaUrl_129, s0_.followUpDocuments AS followUpDocuments_130, s0_.followUpPhotos AS followUpPhotos_131, s0_.followUpExtraLinks AS followUpExtraLinks_132, s0_.history AS history_133, s0_.settings AS settings_134, s0_.skoolWebhook AS skoolWebhook_135, s0_.zapierWebhook AS zapierWebhook_136, s0_.metaLeadFormId AS metaLeadFormId_137, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_138 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND s0_.startDate > ? ORDER BY s0_.startDate ASC LIMIT 1 SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.productId AS productId_2, s0_.eventDateNumber AS eventDateNumber_3, s0_.name AS name_4, s0_.slug AS slug_5, s0_.url AS url_6, s0_.status AS status_7, s0_.visibility AS visibility_8, s0_.access AS access_9, s0_.tags AS tags_10, s0_.lang AS lang_11, s0_.template AS template_12, s0_.pageTemplate AS pageTemplate_13, s0_.priceInEuroCent AS priceInEuroCent_14, s0_.start AS start_15, s0_.end AS end_16, s0_.startDate AS startDate_17, s0_.endDate AS endDate_18, s0_.createdAt AS createdAt_19, s0_.lastModified AS lastModified_20, s0_.lastChangeUser AS lastChangeUser_21, s0_.askForTeam AS askForTeam_22, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_23, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_24, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_25, s0_.hasIncludePhone AS hasIncludePhone_26, s0_.hasFollowUp AS hasFollowUp_27, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_28, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_29, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_30, s0_.isFreeForKiCampus AS isFreeForKiCampus_31, s0_.isFreeForCommunity AS isFreeForCommunity_32, s0_.isTaxIncluded AS isTaxIncluded_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.typeformLink AS typeformLink_35, s0_.zoomLink AS zoomLink_36, s0_.goToPage AS goToPage_37, s0_.city AS city_38, s0_.mailDesignTemplate AS mailDesignTemplate_39, s0_.senderMail AS senderMail_40, s0_.fromName AS fromName_41, s0_.recipientMonitoringMail AS recipientMonitoringMail_42, s0_.confirmationMailSubject AS confirmationMailSubject_43, s0_.confirmationMailContent AS confirmationMailContent_44, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_45, s0_.adminNotificationMailContent AS adminNotificationMailContent_46, s0_.reminderSenderEmail AS reminderSenderEmail_47, s0_.reminderMailSendDate AS reminderMailSendDate_48, s0_.reminderMailSubject AS reminderMailSubject_49, s0_.reminderMailContent AS reminderMailContent_50, s0_.reminderMailStatus AS reminderMailStatus_51, s0_.surveyId AS surveyId_52, s0_.surveyMailTemplateId AS surveyMailTemplateId_53, s0_.surveyBulkMailId AS surveyBulkMailId_54, s0_.applicationsCount AS applicationsCount_55, s0_.startedCount AS startedCount_56, s0_.appliedCount AS appliedCount_57, s0_.approvedCount AS approvedCount_58, s0_.rejectedCount AS rejectedCount_59, s0_.stripeAccount AS stripeAccount_60, s0_.stripePriceId AS stripePriceId_61, s0_.stripeProductId AS stripeProductId_62, s0_.stripePriceIdLive AS stripePriceIdLive_63, s0_.stripePriceIdTest AS stripePriceIdTest_64, s0_.stripeProductIdLive AS stripeProductIdLive_65, s0_.stripeProductIdTest AS stripeProductIdTest_66, s0_.taxBehavior AS taxBehavior_67, s0_.paymentProvider AS paymentProvider_68, s0_.registrationMode AS registrationMode_69, s0_.externalRegistrationUrl AS externalRegistrationUrl_70, s0_.externalPlatform AS externalPlatform_71, s0_.lumaEventApiId AS lumaEventApiId_72, s0_.meetupEventId AS meetupEventId_73, s0_.meetupEventUrl AS meetupEventUrl_74, s0_.registrationHeadline AS registrationHeadline_75, s0_.registrationSubtitle AS registrationSubtitle_76, s0_.registrationButtonText AS registrationButtonText_77, s0_.registrationPriceHtml AS registrationPriceHtml_78, s0_.registrationRedirectUrl AS registrationRedirectUrl_79, s0_.registrationTone AS registrationTone_80, s0_.remoteSessionText AS remoteSessionText_81, s0_.autoApprovalTag AS autoApprovalTag_82, s0_.capacity AS capacity_83, s0_.title AS title_84, s0_.teaser AS teaser_85, s0_.navbar AS navbar_86, s0_.content AS content_87, s0_.contentTwig AS contentTwig_88, s0_.ctaContent AS ctaContent_89, s0_.postCtaContent AS postCtaContent_90, s0_.tagline AS tagline_91, s0_.seoTitle AS seoTitle_92, s0_.seoDescription AS seoDescription_93, s0_.seoKeyword AS seoKeyword_94, s0_.imagelink AS imagelink_95, s0_.bgImagelink AS bgImagelink_96, s0_.videolink AS videolink_97, s0_.additionalCss AS additionalCss_98, s0_.additionalJs AS additionalJs_99, s0_.trainer AS trainer_100, s0_.venueName AS venueName_101, s0_.venueAddress AS venueAddress_102, s0_.whereOverride AS whereOverride_103, s0_.showFullVenue AS showFullVenue_104, s0_.navbarEn AS navbarEn_105, s0_.teaserEn AS teaserEn_106, s0_.contentEn AS contentEn_107, s0_.contentTwigEn AS contentTwigEn_108, s0_.postCtaContentEn AS postCtaContentEn_109, s0_.seoTitleEn AS seoTitleEn_110, s0_.seoDescriptionEn AS seoDescriptionEn_111, s0_.seoKeywordEn AS seoKeywordEn_112, s0_.email AS email_113, s0_.landingPageContent AS landingPageContent_114, s0_.landingPageDescription AS landingPageDescription_115, s0_.landingPageCss AS landingPageCss_116, s0_.landingPageJs AS landingPageJs_117, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_118, s0_.landingPageTitle AS landingPageTitle_119, s0_.followUpDescription AS followUpDescription_120, s0_.followUpVideoLink AS followUpVideoLink_121, s0_.followUpPresentation AS followUpPresentation_122, s0_.followUpPageContent AS followUpPageContent_123, s0_.followUpPageCss AS followUpPageCss_124, s0_.followUpPageTitle AS followUpPageTitle_125, s0_.followUpSkoolUrl AS followUpSkoolUrl_126, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_127, s0_.followUpCtaText AS followUpCtaText_128, s0_.followUpCtaUrl AS followUpCtaUrl_129, s0_.followUpDocuments AS followUpDocuments_130, s0_.followUpPhotos AS followUpPhotos_131, s0_.followUpExtraLinks AS followUpExtraLinks_132, s0_.history AS history_133, s0_.settings AS settings_134, s0_.skoolWebhook AS skoolWebhook_135, s0_.zapierWebhook AS zapierWebhook_136, s0_.metaLeadFormId AS metaLeadFormId_137, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_138 FROM sp_event_dates s0_ WHERE s0_.eventId = 7026 AND s0_.startDate > '2026-06-11 06:32:48' ORDER BY s0_.startDate ASC LIMIT 1;
3	19.31 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_.title_en AS title_en_5, s0_.slug AS slug_6, s0_.lang AS lang_7, s0_.imagelink AS imagelink_8, s0_.videolink AS videolink_9, s0_.bgImagelink AS bgImagelink_10, s0_.tagline AS tagline_11, s0_.headerTextColor AS headerTextColor_12, s0_.spResponsiblePerson AS spResponsiblePerson_13, s0_.organization AS organization_14, s0_.organizerName AS organizerName_15, s0_.organizerEmail AS organizerEmail_16, s0_.venueName AS venueName_17, s0_.venueAddress AS venueAddress_18, s0_.showFullVenue AS showFullVenue_19, s0_.ticketing AS ticketing_20, s0_.applicationUrl AS applicationUrl_21, s0_.alert AS alert_22, s0_.trainer AS trainer_23, s0_.speakers AS speakers_24, s0_.teaser AS teaser_25, s0_.navbar AS navbar_26, s0_.stripePriceId AS stripePriceId_27, s0_.stripeProductId AS stripeProductId_28, s0_.stripeAccount AS stripeAccount_29, s0_.priceInEuroCent AS priceInEuroCent_30, s0_.isTaxIncluded AS isTaxIncluded_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isSinglePage AS isSinglePage_34, s0_.isFormalLanguage AS isFormalLanguage_35, s0_.isMultiBatchEvent AS isMultiBatchEvent_36, s0_.isFeatured AS isFeatured_37, s0_.capacity AS capacity_38, s0_.targetCapacity AS targetCapacity_39, s0_.twigFile AS twigFile_40, s0_.additionalCss AS additionalCss_41, s0_.content AS content_42, s0_.contentTwig AS contentTwig_43, s0_.ctaContent AS ctaContent_44, s0_.postCtaContent AS postCtaContent_45, s0_.tags AS tags_46, s0_.seriesTag AS seriesTag_47, s0_.feedbackFormId AS feedbackFormId_48, s0_.type AS type_49, s0_.location AS location_50, s0_.startDate AS startDate_51, s0_.endDate AS endDate_52, s0_.duration AS duration_53, s0_.status AS status_54, s0_.settings AS settings_55, s0_.displayStartDate AS displayStartDate_56, s0_.seoTitle AS seoTitle_57, s0_.seoKeyword AS seoKeyword_58, s0_.seoDescription AS seoDescription_59, s0_.navbar_en AS navbar_en_60, s0_.teaser_en AS teaser_en_61, s0_.content_en AS content_en_62, s0_.content_twig_en AS content_twig_en_63, s0_.post_cta_content_en AS post_cta_content_en_64, s0_.seo_title_en AS seo_title_en_65, s0_.seo_description_en AS seo_description_en_66, s0_.seo_keyword_en AS seo_keyword_en_67, s0_.has_english_version AS has_english_version_68, s0_.additional_js AS additional_js_69, s0_.metaPixelId AS metaPixelId_70, s0_.createDate AS createDate_71, s0_.lastChangeDate AS lastChangeDate_72, s0_.lastChangeUser AS lastChangeUser_73, s0_.publicId AS publicId_74, s0_.isExternalSubmission AS isExternalSubmission_75, s0_.createdBy AS createdBy_76, s0_.lastModified AS lastModified_77, s0_.createdAt AS createdAt_78, s0_.orgaNote AS orgaNote_79, s0_.calendarSyncedAt AS calendarSyncedAt_80, s0_.logisticsRoom AS logisticsRoom_81, s0_.logisticsCatering AS logisticsCatering_82, s0_.logisticsEquipment AS logisticsEquipment_83, s0_.logisticsHelpers AS logisticsHelpers_84, s0_.history AS history_85, s0_.todoHistory AS todoHistory_86 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.id <> ? AND s0_.status = ? Parameters: [`"TechTuesday" 7026 "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_.title_en AS title_en_5, s0_.slug AS slug_6, s0_.lang AS lang_7, s0_.imagelink AS imagelink_8, s0_.videolink AS videolink_9, s0_.bgImagelink AS bgImagelink_10, s0_.tagline AS tagline_11, s0_.headerTextColor AS headerTextColor_12, s0_.spResponsiblePerson AS spResponsiblePerson_13, s0_.organization AS organization_14, s0_.organizerName AS organizerName_15, s0_.organizerEmail AS organizerEmail_16, s0_.venueName AS venueName_17, s0_.venueAddress AS venueAddress_18, s0_.showFullVenue AS showFullVenue_19, s0_.ticketing AS ticketing_20, s0_.applicationUrl AS applicationUrl_21, s0_.alert AS alert_22, s0_.trainer AS trainer_23, s0_.speakers AS speakers_24, s0_.teaser AS teaser_25, s0_.navbar AS navbar_26, s0_.stripePriceId AS stripePriceId_27, s0_.stripeProductId AS stripeProductId_28, s0_.stripeAccount AS stripeAccount_29, s0_.priceInEuroCent AS priceInEuroCent_30, s0_.isTaxIncluded AS isTaxIncluded_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isSinglePage AS isSinglePage_34, s0_.isFormalLanguage AS isFormalLanguage_35, s0_.isMultiBatchEvent AS isMultiBatchEvent_36, s0_.isFeatured AS isFeatured_37, s0_.capacity AS capacity_38, s0_.targetCapacity AS targetCapacity_39, s0_.twigFile AS twigFile_40, s0_.additionalCss AS additionalCss_41, s0_.content AS content_42, s0_.contentTwig AS contentTwig_43, s0_.ctaContent AS ctaContent_44, s0_.postCtaContent AS postCtaContent_45, s0_.tags AS tags_46, s0_.seriesTag AS seriesTag_47, s0_.feedbackFormId AS feedbackFormId_48, s0_.type AS type_49, s0_.location AS location_50, s0_.startDate AS startDate_51, s0_.endDate AS endDate_52, s0_.duration AS duration_53, s0_.status AS status_54, s0_.settings AS settings_55, s0_.displayStartDate AS displayStartDate_56, s0_.seoTitle AS seoTitle_57, s0_.seoKeyword AS seoKeyword_58, s0_.seoDescription AS seoDescription_59, s0_.navbar_en AS navbar_en_60, s0_.teaser_en AS teaser_en_61, s0_.content_en AS content_en_62, s0_.content_twig_en AS content_twig_en_63, s0_.post_cta_content_en AS post_cta_content_en_64, s0_.seo_title_en AS seo_title_en_65, s0_.seo_description_en AS seo_description_en_66, s0_.seo_keyword_en AS seo_keyword_en_67, s0_.has_english_version AS has_english_version_68, s0_.additional_js AS additional_js_69, s0_.metaPixelId AS metaPixelId_70, s0_.createDate AS createDate_71, s0_.lastChangeDate AS lastChangeDate_72, s0_.lastChangeUser AS lastChangeUser_73, s0_.publicId AS publicId_74, s0_.isExternalSubmission AS isExternalSubmission_75, s0_.createdBy AS createdBy_76, s0_.lastModified AS lastModified_77, s0_.createdAt AS createdAt_78, s0_.orgaNote AS orgaNote_79, s0_.calendarSyncedAt AS calendarSyncedAt_80, s0_.logisticsRoom AS logisticsRoom_81, s0_.logisticsCatering AS logisticsCatering_82, s0_.logisticsEquipment AS logisticsEquipment_83, s0_.logisticsHelpers AS logisticsHelpers_84, s0_.history AS history_85, s0_.todoHistory AS todoHistory_86 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_.title_en AS title_en_5, s0_.slug AS slug_6, s0_.lang AS lang_7, s0_.imagelink AS imagelink_8, s0_.videolink AS videolink_9, s0_.bgImagelink AS bgImagelink_10, s0_.tagline AS tagline_11, s0_.headerTextColor AS headerTextColor_12, s0_.spResponsiblePerson AS spResponsiblePerson_13, s0_.organization AS organization_14, s0_.organizerName AS organizerName_15, s0_.organizerEmail AS organizerEmail_16, s0_.venueName AS venueName_17, s0_.venueAddress AS venueAddress_18, s0_.showFullVenue AS showFullVenue_19, s0_.ticketing AS ticketing_20, s0_.applicationUrl AS applicationUrl_21, s0_.alert AS alert_22, s0_.trainer AS trainer_23, s0_.speakers AS speakers_24, s0_.teaser AS teaser_25, s0_.navbar AS navbar_26, s0_.stripePriceId AS stripePriceId_27, s0_.stripeProductId AS stripeProductId_28, s0_.stripeAccount AS stripeAccount_29, s0_.priceInEuroCent AS priceInEuroCent_30, s0_.isTaxIncluded AS isTaxIncluded_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isSinglePage AS isSinglePage_34, s0_.isFormalLanguage AS isFormalLanguage_35, s0_.isMultiBatchEvent AS isMultiBatchEvent_36, s0_.isFeatured AS isFeatured_37, s0_.capacity AS capacity_38, s0_.targetCapacity AS targetCapacity_39, s0_.twigFile AS twigFile_40, s0_.additionalCss AS additionalCss_41, s0_.content AS content_42, s0_.contentTwig AS contentTwig_43, s0_.ctaContent AS ctaContent_44, s0_.postCtaContent AS postCtaContent_45, s0_.tags AS tags_46, s0_.seriesTag AS seriesTag_47, s0_.feedbackFormId AS feedbackFormId_48, s0_.type AS type_49, s0_.location AS location_50, s0_.startDate AS startDate_51, s0_.endDate AS endDate_52, s0_.duration AS duration_53, s0_.status AS status_54, s0_.settings AS settings_55, s0_.displayStartDate AS displayStartDate_56, s0_.seoTitle AS seoTitle_57, s0_.seoKeyword AS seoKeyword_58, s0_.seoDescription AS seoDescription_59, s0_.navbar_en AS navbar_en_60, s0_.teaser_en AS teaser_en_61, s0_.content_en AS content_en_62, s0_.content_twig_en AS content_twig_en_63, s0_.post_cta_content_en AS post_cta_content_en_64, s0_.seo_title_en AS seo_title_en_65, s0_.seo_description_en AS seo_description_en_66, s0_.seo_keyword_en AS seo_keyword_en_67, s0_.has_english_version AS has_english_version_68, s0_.additional_js AS additional_js_69, s0_.metaPixelId AS metaPixelId_70, s0_.createDate AS createDate_71, s0_.lastChangeDate AS lastChangeDate_72, s0_.lastChangeUser AS lastChangeUser_73, s0_.publicId AS publicId_74, s0_.isExternalSubmission AS isExternalSubmission_75, s0_.createdBy AS createdBy_76, s0_.lastModified AS lastModified_77, s0_.createdAt AS createdAt_78, s0_.orgaNote AS orgaNote_79, s0_.calendarSyncedAt AS calendarSyncedAt_80, s0_.logisticsRoom AS logisticsRoom_81, s0_.logisticsCatering AS logisticsCatering_82, s0_.logisticsEquipment AS logisticsEquipment_83, s0_.logisticsHelpers AS logisticsHelpers_84, s0_.history AS history_85, s0_.todoHistory AS todoHistory_86 FROM sp_event_events s0_ WHERE s0_.seriesTag = 'TechTuesday' AND s0_.id <> 7026 AND s0_.status = 'publish';
4	19.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_.title_en AS title_en_5, s0_.slug AS slug_6, s0_.lang AS lang_7, s0_.imagelink AS imagelink_8, s0_.videolink AS videolink_9, s0_.bgImagelink AS bgImagelink_10, s0_.tagline AS tagline_11, s0_.headerTextColor AS headerTextColor_12, s0_.spResponsiblePerson AS spResponsiblePerson_13, s0_.organization AS organization_14, s0_.organizerName AS organizerName_15, s0_.organizerEmail AS organizerEmail_16, s0_.venueName AS venueName_17, s0_.venueAddress AS venueAddress_18, s0_.showFullVenue AS showFullVenue_19, s0_.ticketing AS ticketing_20, s0_.applicationUrl AS applicationUrl_21, s0_.alert AS alert_22, s0_.trainer AS trainer_23, s0_.speakers AS speakers_24, s0_.teaser AS teaser_25, s0_.navbar AS navbar_26, s0_.stripePriceId AS stripePriceId_27, s0_.stripeProductId AS stripeProductId_28, s0_.stripeAccount AS stripeAccount_29, s0_.priceInEuroCent AS priceInEuroCent_30, s0_.isTaxIncluded AS isTaxIncluded_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isSinglePage AS isSinglePage_34, s0_.isFormalLanguage AS isFormalLanguage_35, s0_.isMultiBatchEvent AS isMultiBatchEvent_36, s0_.isFeatured AS isFeatured_37, s0_.capacity AS capacity_38, s0_.targetCapacity AS targetCapacity_39, s0_.twigFile AS twigFile_40, s0_.additionalCss AS additionalCss_41, s0_.content AS content_42, s0_.contentTwig AS contentTwig_43, s0_.ctaContent AS ctaContent_44, s0_.postCtaContent AS postCtaContent_45, s0_.tags AS tags_46, s0_.seriesTag AS seriesTag_47, s0_.feedbackFormId AS feedbackFormId_48, s0_.type AS type_49, s0_.location AS location_50, s0_.startDate AS startDate_51, s0_.endDate AS endDate_52, s0_.duration AS duration_53, s0_.status AS status_54, s0_.settings AS settings_55, s0_.displayStartDate AS displayStartDate_56, s0_.seoTitle AS seoTitle_57, s0_.seoKeyword AS seoKeyword_58, s0_.seoDescription AS seoDescription_59, s0_.navbar_en AS navbar_en_60, s0_.teaser_en AS teaser_en_61, s0_.content_en AS content_en_62, s0_.content_twig_en AS content_twig_en_63, s0_.post_cta_content_en AS post_cta_content_en_64, s0_.seo_title_en AS seo_title_en_65, s0_.seo_description_en AS seo_description_en_66, s0_.seo_keyword_en AS seo_keyword_en_67, s0_.has_english_version AS has_english_version_68, s0_.additional_js AS additional_js_69, s0_.metaPixelId AS metaPixelId_70, s0_.createDate AS createDate_71, s0_.lastChangeDate AS lastChangeDate_72, s0_.lastChangeUser AS lastChangeUser_73, s0_.publicId AS publicId_74, s0_.isExternalSubmission AS isExternalSubmission_75, s0_.createdBy AS createdBy_76, s0_.lastModified AS lastModified_77, s0_.createdAt AS createdAt_78, s0_.orgaNote AS orgaNote_79, s0_.calendarSyncedAt AS calendarSyncedAt_80, s0_.logisticsRoom AS logisticsRoom_81, s0_.logisticsCatering AS logisticsCatering_82, s0_.logisticsEquipment AS logisticsEquipment_83, s0_.logisticsHelpers AS logisticsHelpers_84, s0_.history AS history_85, s0_.todoHistory AS todoHistory_86 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.id <> ? AND s0_.status = ? Parameters: [`"TechTuesday" 7026 "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_.title_en AS title_en_5, s0_.slug AS slug_6, s0_.lang AS lang_7, s0_.imagelink AS imagelink_8, s0_.videolink AS videolink_9, s0_.bgImagelink AS bgImagelink_10, s0_.tagline AS tagline_11, s0_.headerTextColor AS headerTextColor_12, s0_.spResponsiblePerson AS spResponsiblePerson_13, s0_.organization AS organization_14, s0_.organizerName AS organizerName_15, s0_.organizerEmail AS organizerEmail_16, s0_.venueName AS venueName_17, s0_.venueAddress AS venueAddress_18, s0_.showFullVenue AS showFullVenue_19, s0_.ticketing AS ticketing_20, s0_.applicationUrl AS applicationUrl_21, s0_.alert AS alert_22, s0_.trainer AS trainer_23, s0_.speakers AS speakers_24, s0_.teaser AS teaser_25, s0_.navbar AS navbar_26, s0_.stripePriceId AS stripePriceId_27, s0_.stripeProductId AS stripeProductId_28, s0_.stripeAccount AS stripeAccount_29, s0_.priceInEuroCent AS priceInEuroCent_30, s0_.isTaxIncluded AS isTaxIncluded_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isSinglePage AS isSinglePage_34, s0_.isFormalLanguage AS isFormalLanguage_35, s0_.isMultiBatchEvent AS isMultiBatchEvent_36, s0_.isFeatured AS isFeatured_37, s0_.capacity AS capacity_38, s0_.targetCapacity AS targetCapacity_39, s0_.twigFile AS twigFile_40, s0_.additionalCss AS additionalCss_41, s0_.content AS content_42, s0_.contentTwig AS contentTwig_43, s0_.ctaContent AS ctaContent_44, s0_.postCtaContent AS postCtaContent_45, s0_.tags AS tags_46, s0_.seriesTag AS seriesTag_47, s0_.feedbackFormId AS feedbackFormId_48, s0_.type AS type_49, s0_.location AS location_50, s0_.startDate AS startDate_51, s0_.endDate AS endDate_52, s0_.duration AS duration_53, s0_.status AS status_54, s0_.settings AS settings_55, s0_.displayStartDate AS displayStartDate_56, s0_.seoTitle AS seoTitle_57, s0_.seoKeyword AS seoKeyword_58, s0_.seoDescription AS seoDescription_59, s0_.navbar_en AS navbar_en_60, s0_.teaser_en AS teaser_en_61, s0_.content_en AS content_en_62, s0_.content_twig_en AS content_twig_en_63, s0_.post_cta_content_en AS post_cta_content_en_64, s0_.seo_title_en AS seo_title_en_65, s0_.seo_description_en AS seo_description_en_66, s0_.seo_keyword_en AS seo_keyword_en_67, s0_.has_english_version AS has_english_version_68, s0_.additional_js AS additional_js_69, s0_.metaPixelId AS metaPixelId_70, s0_.createDate AS createDate_71, s0_.lastChangeDate AS lastChangeDate_72, s0_.lastChangeUser AS lastChangeUser_73, s0_.publicId AS publicId_74, s0_.isExternalSubmission AS isExternalSubmission_75, s0_.createdBy AS createdBy_76, s0_.lastModified AS lastModified_77, s0_.createdAt AS createdAt_78, s0_.orgaNote AS orgaNote_79, s0_.calendarSyncedAt AS calendarSyncedAt_80, s0_.logisticsRoom AS logisticsRoom_81, s0_.logisticsCatering AS logisticsCatering_82, s0_.logisticsEquipment AS logisticsEquipment_83, s0_.logisticsHelpers AS logisticsHelpers_84, s0_.history AS history_85, s0_.todoHistory AS todoHistory_86 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_.title_en AS title_en_5, s0_.slug AS slug_6, s0_.lang AS lang_7, s0_.imagelink AS imagelink_8, s0_.videolink AS videolink_9, s0_.bgImagelink AS bgImagelink_10, s0_.tagline AS tagline_11, s0_.headerTextColor AS headerTextColor_12, s0_.spResponsiblePerson AS spResponsiblePerson_13, s0_.organization AS organization_14, s0_.organizerName AS organizerName_15, s0_.organizerEmail AS organizerEmail_16, s0_.venueName AS venueName_17, s0_.venueAddress AS venueAddress_18, s0_.showFullVenue AS showFullVenue_19, s0_.ticketing AS ticketing_20, s0_.applicationUrl AS applicationUrl_21, s0_.alert AS alert_22, s0_.trainer AS trainer_23, s0_.speakers AS speakers_24, s0_.teaser AS teaser_25, s0_.navbar AS navbar_26, s0_.stripePriceId AS stripePriceId_27, s0_.stripeProductId AS stripeProductId_28, s0_.stripeAccount AS stripeAccount_29, s0_.priceInEuroCent AS priceInEuroCent_30, s0_.isTaxIncluded AS isTaxIncluded_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isSinglePage AS isSinglePage_34, s0_.isFormalLanguage AS isFormalLanguage_35, s0_.isMultiBatchEvent AS isMultiBatchEvent_36, s0_.isFeatured AS isFeatured_37, s0_.capacity AS capacity_38, s0_.targetCapacity AS targetCapacity_39, s0_.twigFile AS twigFile_40, s0_.additionalCss AS additionalCss_41, s0_.content AS content_42, s0_.contentTwig AS contentTwig_43, s0_.ctaContent AS ctaContent_44, s0_.postCtaContent AS postCtaContent_45, s0_.tags AS tags_46, s0_.seriesTag AS seriesTag_47, s0_.feedbackFormId AS feedbackFormId_48, s0_.type AS type_49, s0_.location AS location_50, s0_.startDate AS startDate_51, s0_.endDate AS endDate_52, s0_.duration AS duration_53, s0_.status AS status_54, s0_.settings AS settings_55, s0_.displayStartDate AS displayStartDate_56, s0_.seoTitle AS seoTitle_57, s0_.seoKeyword AS seoKeyword_58, s0_.seoDescription AS seoDescription_59, s0_.navbar_en AS navbar_en_60, s0_.teaser_en AS teaser_en_61, s0_.content_en AS content_en_62, s0_.content_twig_en AS content_twig_en_63, s0_.post_cta_content_en AS post_cta_content_en_64, s0_.seo_title_en AS seo_title_en_65, s0_.seo_description_en AS seo_description_en_66, s0_.seo_keyword_en AS seo_keyword_en_67, s0_.has_english_version AS has_english_version_68, s0_.additional_js AS additional_js_69, s0_.metaPixelId AS metaPixelId_70, s0_.createDate AS createDate_71, s0_.lastChangeDate AS lastChangeDate_72, s0_.lastChangeUser AS lastChangeUser_73, s0_.publicId AS publicId_74, s0_.isExternalSubmission AS isExternalSubmission_75, s0_.createdBy AS createdBy_76, s0_.lastModified AS lastModified_77, s0_.createdAt AS createdAt_78, s0_.orgaNote AS orgaNote_79, s0_.calendarSyncedAt AS calendarSyncedAt_80, s0_.logisticsRoom AS logisticsRoom_81, s0_.logisticsCatering AS logisticsCatering_82, s0_.logisticsEquipment AS logisticsEquipment_83, s0_.logisticsHelpers AS logisticsHelpers_84, s0_.history AS history_85, s0_.todoHistory AS todoHistory_86 FROM sp_event_events s0_ WHERE s0_.seriesTag = 'TechTuesday' AND s0_.id <> 7026 AND s0_.status = 'publish';
5	0.92 ms	SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.productId AS productId_2, s0_.eventDateNumber AS eventDateNumber_3, s0_.name AS name_4, s0_.slug AS slug_5, s0_.url AS url_6, s0_.status AS status_7, s0_.visibility AS visibility_8, s0_.access AS access_9, s0_.tags AS tags_10, s0_.lang AS lang_11, s0_.template AS template_12, s0_.pageTemplate AS pageTemplate_13, s0_.priceInEuroCent AS priceInEuroCent_14, s0_.start AS start_15, s0_.end AS end_16, s0_.startDate AS startDate_17, s0_.endDate AS endDate_18, s0_.createdAt AS createdAt_19, s0_.lastModified AS lastModified_20, s0_.lastChangeUser AS lastChangeUser_21, s0_.askForTeam AS askForTeam_22, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_23, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_24, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_25, s0_.hasIncludePhone AS hasIncludePhone_26, s0_.hasFollowUp AS hasFollowUp_27, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_28, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_29, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_30, s0_.isFreeForKiCampus AS isFreeForKiCampus_31, s0_.isFreeForCommunity AS isFreeForCommunity_32, s0_.isTaxIncluded AS isTaxIncluded_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.typeformLink AS typeformLink_35, s0_.zoomLink AS zoomLink_36, s0_.goToPage AS goToPage_37, s0_.city AS city_38, s0_.mailDesignTemplate AS mailDesignTemplate_39, s0_.senderMail AS senderMail_40, s0_.fromName AS fromName_41, s0_.recipientMonitoringMail AS recipientMonitoringMail_42, s0_.confirmationMailSubject AS confirmationMailSubject_43, s0_.confirmationMailContent AS confirmationMailContent_44, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_45, s0_.adminNotificationMailContent AS adminNotificationMailContent_46, s0_.reminderSenderEmail AS reminderSenderEmail_47, s0_.reminderMailSendDate AS reminderMailSendDate_48, s0_.reminderMailSubject AS reminderMailSubject_49, s0_.reminderMailContent AS reminderMailContent_50, s0_.reminderMailStatus AS reminderMailStatus_51, s0_.surveyId AS surveyId_52, s0_.surveyMailTemplateId AS surveyMailTemplateId_53, s0_.surveyBulkMailId AS surveyBulkMailId_54, s0_.applicationsCount AS applicationsCount_55, s0_.startedCount AS startedCount_56, s0_.appliedCount AS appliedCount_57, s0_.approvedCount AS approvedCount_58, s0_.rejectedCount AS rejectedCount_59, s0_.stripeAccount AS stripeAccount_60, s0_.stripePriceId AS stripePriceId_61, s0_.stripeProductId AS stripeProductId_62, s0_.stripePriceIdLive AS stripePriceIdLive_63, s0_.stripePriceIdTest AS stripePriceIdTest_64, s0_.stripeProductIdLive AS stripeProductIdLive_65, s0_.stripeProductIdTest AS stripeProductIdTest_66, s0_.taxBehavior AS taxBehavior_67, s0_.paymentProvider AS paymentProvider_68, s0_.registrationMode AS registrationMode_69, s0_.externalRegistrationUrl AS externalRegistrationUrl_70, s0_.externalPlatform AS externalPlatform_71, s0_.lumaEventApiId AS lumaEventApiId_72, s0_.meetupEventId AS meetupEventId_73, s0_.meetupEventUrl AS meetupEventUrl_74, s0_.registrationHeadline AS registrationHeadline_75, s0_.registrationSubtitle AS registrationSubtitle_76, s0_.registrationButtonText AS registrationButtonText_77, s0_.registrationPriceHtml AS registrationPriceHtml_78, s0_.registrationRedirectUrl AS registrationRedirectUrl_79, s0_.registrationTone AS registrationTone_80, s0_.remoteSessionText AS remoteSessionText_81, s0_.autoApprovalTag AS autoApprovalTag_82, s0_.capacity AS capacity_83, s0_.title AS title_84, s0_.teaser AS teaser_85, s0_.navbar AS navbar_86, s0_.content AS content_87, s0_.contentTwig AS contentTwig_88, s0_.ctaContent AS ctaContent_89, s0_.postCtaContent AS postCtaContent_90, s0_.tagline AS tagline_91, s0_.seoTitle AS seoTitle_92, s0_.seoDescription AS seoDescription_93, s0_.seoKeyword AS seoKeyword_94, s0_.imagelink AS imagelink_95, s0_.bgImagelink AS bgImagelink_96, s0_.videolink AS videolink_97, s0_.additionalCss AS additionalCss_98, s0_.additionalJs AS additionalJs_99, s0_.trainer AS trainer_100, s0_.venueName AS venueName_101, s0_.venueAddress AS venueAddress_102, s0_.whereOverride AS whereOverride_103, s0_.showFullVenue AS showFullVenue_104, s0_.navbarEn AS navbarEn_105, s0_.teaserEn AS teaserEn_106, s0_.contentEn AS contentEn_107, s0_.contentTwigEn AS contentTwigEn_108, s0_.postCtaContentEn AS postCtaContentEn_109, s0_.seoTitleEn AS seoTitleEn_110, s0_.seoDescriptionEn AS seoDescriptionEn_111, s0_.seoKeywordEn AS seoKeywordEn_112, s0_.email AS email_113, s0_.landingPageContent AS landingPageContent_114, s0_.landingPageDescription AS landingPageDescription_115, s0_.landingPageCss AS landingPageCss_116, s0_.landingPageJs AS landingPageJs_117, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_118, s0_.landingPageTitle AS landingPageTitle_119, s0_.followUpDescription AS followUpDescription_120, s0_.followUpVideoLink AS followUpVideoLink_121, s0_.followUpPresentation AS followUpPresentation_122, s0_.followUpPageContent AS followUpPageContent_123, s0_.followUpPageCss AS followUpPageCss_124, s0_.followUpPageTitle AS followUpPageTitle_125, s0_.followUpSkoolUrl AS followUpSkoolUrl_126, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_127, s0_.followUpCtaText AS followUpCtaText_128, s0_.followUpCtaUrl AS followUpCtaUrl_129, s0_.followUpDocuments AS followUpDocuments_130, s0_.followUpPhotos AS followUpPhotos_131, s0_.followUpExtraLinks AS followUpExtraLinks_132, s0_.history AS history_133, s0_.settings AS settings_134, s0_.skoolWebhook AS skoolWebhook_135, s0_.zapierWebhook AS zapierWebhook_136, s0_.metaLeadFormId AS metaLeadFormId_137, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_138 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND s0_.status = ? AND s0_.access = ? AND (s0_.startDate IS NOT NULL AND s0_.startDate >= ?) ORDER BY s0_.startDate ASC LIMIT 1 Parameters: [`7026 "active" "anonymous" "2026-06-11 00:00:00"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.productId AS productId_2, s0_.eventDateNumber AS eventDateNumber_3, s0_.name AS name_4, s0_.slug AS slug_5, s0_.url AS url_6, s0_.status AS status_7, s0_.visibility AS visibility_8, s0_.access AS access_9, s0_.tags AS tags_10, s0_.lang AS lang_11, s0_.template AS template_12, s0_.pageTemplate AS pageTemplate_13, s0_.priceInEuroCent AS priceInEuroCent_14, s0_.start AS start_15, s0_.end AS end_16, s0_.startDate AS startDate_17, s0_.endDate AS endDate_18, s0_.createdAt AS createdAt_19, s0_.lastModified AS lastModified_20, s0_.lastChangeUser AS lastChangeUser_21, s0_.askForTeam AS askForTeam_22, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_23, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_24, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_25, s0_.hasIncludePhone AS hasIncludePhone_26, s0_.hasFollowUp AS hasFollowUp_27, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_28, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_29, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_30, s0_.isFreeForKiCampus AS isFreeForKiCampus_31, s0_.isFreeForCommunity AS isFreeForCommunity_32, s0_.isTaxIncluded AS isTaxIncluded_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.typeformLink AS typeformLink_35, s0_.zoomLink AS zoomLink_36, s0_.goToPage AS goToPage_37, s0_.city AS city_38, s0_.mailDesignTemplate AS mailDesignTemplate_39, s0_.senderMail AS senderMail_40, s0_.fromName AS fromName_41, s0_.recipientMonitoringMail AS recipientMonitoringMail_42, s0_.confirmationMailSubject AS confirmationMailSubject_43, s0_.confirmationMailContent AS confirmationMailContent_44, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_45, s0_.adminNotificationMailContent AS adminNotificationMailContent_46, s0_.reminderSenderEmail AS reminderSenderEmail_47, s0_.reminderMailSendDate AS reminderMailSendDate_48, s0_.reminderMailSubject AS reminderMailSubject_49, s0_.reminderMailContent AS reminderMailContent_50, s0_.reminderMailStatus AS reminderMailStatus_51, s0_.surveyId AS surveyId_52, s0_.surveyMailTemplateId AS surveyMailTemplateId_53, s0_.surveyBulkMailId AS surveyBulkMailId_54, s0_.applicationsCount AS applicationsCount_55, s0_.startedCount AS startedCount_56, s0_.appliedCount AS appliedCount_57, s0_.approvedCount AS approvedCount_58, s0_.rejectedCount AS rejectedCount_59, s0_.stripeAccount AS stripeAccount_60, s0_.stripePriceId AS stripePriceId_61, s0_.stripeProductId AS stripeProductId_62, s0_.stripePriceIdLive AS stripePriceIdLive_63, s0_.stripePriceIdTest AS stripePriceIdTest_64, s0_.stripeProductIdLive AS stripeProductIdLive_65, s0_.stripeProductIdTest AS stripeProductIdTest_66, s0_.taxBehavior AS taxBehavior_67, s0_.paymentProvider AS paymentProvider_68, s0_.registrationMode AS registrationMode_69, s0_.externalRegistrationUrl AS externalRegistrationUrl_70, s0_.externalPlatform AS externalPlatform_71, s0_.lumaEventApiId AS lumaEventApiId_72, s0_.meetupEventId AS meetupEventId_73, s0_.meetupEventUrl AS meetupEventUrl_74, s0_.registrationHeadline AS registrationHeadline_75, s0_.registrationSubtitle AS registrationSubtitle_76, s0_.registrationButtonText AS registrationButtonText_77, s0_.registrationPriceHtml AS registrationPriceHtml_78, s0_.registrationRedirectUrl AS registrationRedirectUrl_79, s0_.registrationTone AS registrationTone_80, s0_.remoteSessionText AS remoteSessionText_81, s0_.autoApprovalTag AS autoApprovalTag_82, s0_.capacity AS capacity_83, s0_.title AS title_84, s0_.teaser AS teaser_85, s0_.navbar AS navbar_86, s0_.content AS content_87, s0_.contentTwig AS contentTwig_88, s0_.ctaContent AS ctaContent_89, s0_.postCtaContent AS postCtaContent_90, s0_.tagline AS tagline_91, s0_.seoTitle AS seoTitle_92, s0_.seoDescription AS seoDescription_93, s0_.seoKeyword AS seoKeyword_94, s0_.imagelink AS imagelink_95, s0_.bgImagelink AS bgImagelink_96, s0_.videolink AS videolink_97, s0_.additionalCss AS additionalCss_98, s0_.additionalJs AS additionalJs_99, s0_.trainer AS trainer_100, s0_.venueName AS venueName_101, s0_.venueAddress AS venueAddress_102, s0_.whereOverride AS whereOverride_103, s0_.showFullVenue AS showFullVenue_104, s0_.navbarEn AS navbarEn_105, s0_.teaserEn AS teaserEn_106, s0_.contentEn AS contentEn_107, s0_.contentTwigEn AS contentTwigEn_108, s0_.postCtaContentEn AS postCtaContentEn_109, s0_.seoTitleEn AS seoTitleEn_110, s0_.seoDescriptionEn AS seoDescriptionEn_111, s0_.seoKeywordEn AS seoKeywordEn_112, s0_.email AS email_113, s0_.landingPageContent AS landingPageContent_114, s0_.landingPageDescription AS landingPageDescription_115, s0_.landingPageCss AS landingPageCss_116, s0_.landingPageJs AS landingPageJs_117, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_118, s0_.landingPageTitle AS landingPageTitle_119, s0_.followUpDescription AS followUpDescription_120, s0_.followUpVideoLink AS followUpVideoLink_121, s0_.followUpPresentation AS followUpPresentation_122, s0_.followUpPageContent AS followUpPageContent_123, s0_.followUpPageCss AS followUpPageCss_124, s0_.followUpPageTitle AS followUpPageTitle_125, s0_.followUpSkoolUrl AS followUpSkoolUrl_126, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_127, s0_.followUpCtaText AS followUpCtaText_128, s0_.followUpCtaUrl AS followUpCtaUrl_129, s0_.followUpDocuments AS followUpDocuments_130, s0_.followUpPhotos AS followUpPhotos_131, s0_.followUpExtraLinks AS followUpExtraLinks_132, s0_.history AS history_133, s0_.settings AS settings_134, s0_.skoolWebhook AS skoolWebhook_135, s0_.zapierWebhook AS zapierWebhook_136, s0_.metaLeadFormId AS metaLeadFormId_137, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_138 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND s0_.status = ? AND s0_.access = ? AND ( s0_.startDate IS NOT NULL AND s0_.startDate >= ? ) ORDER BY s0_.startDate ASC LIMIT 1 SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.productId AS productId_2, s0_.eventDateNumber AS eventDateNumber_3, s0_.name AS name_4, s0_.slug AS slug_5, s0_.url AS url_6, s0_.status AS status_7, s0_.visibility AS visibility_8, s0_.access AS access_9, s0_.tags AS tags_10, s0_.lang AS lang_11, s0_.template AS template_12, s0_.pageTemplate AS pageTemplate_13, s0_.priceInEuroCent AS priceInEuroCent_14, s0_.start AS start_15, s0_.end AS end_16, s0_.startDate AS startDate_17, s0_.endDate AS endDate_18, s0_.createdAt AS createdAt_19, s0_.lastModified AS lastModified_20, s0_.lastChangeUser AS lastChangeUser_21, s0_.askForTeam AS askForTeam_22, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_23, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_24, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_25, s0_.hasIncludePhone AS hasIncludePhone_26, s0_.hasFollowUp AS hasFollowUp_27, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_28, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_29, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_30, s0_.isFreeForKiCampus AS isFreeForKiCampus_31, s0_.isFreeForCommunity AS isFreeForCommunity_32, s0_.isTaxIncluded AS isTaxIncluded_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.typeformLink AS typeformLink_35, s0_.zoomLink AS zoomLink_36, s0_.goToPage AS goToPage_37, s0_.city AS city_38, s0_.mailDesignTemplate AS mailDesignTemplate_39, s0_.senderMail AS senderMail_40, s0_.fromName AS fromName_41, s0_.recipientMonitoringMail AS recipientMonitoringMail_42, s0_.confirmationMailSubject AS confirmationMailSubject_43, s0_.confirmationMailContent AS confirmationMailContent_44, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_45, s0_.adminNotificationMailContent AS adminNotificationMailContent_46, s0_.reminderSenderEmail AS reminderSenderEmail_47, s0_.reminderMailSendDate AS reminderMailSendDate_48, s0_.reminderMailSubject AS reminderMailSubject_49, s0_.reminderMailContent AS reminderMailContent_50, s0_.reminderMailStatus AS reminderMailStatus_51, s0_.surveyId AS surveyId_52, s0_.surveyMailTemplateId AS surveyMailTemplateId_53, s0_.surveyBulkMailId AS surveyBulkMailId_54, s0_.applicationsCount AS applicationsCount_55, s0_.startedCount AS startedCount_56, s0_.appliedCount AS appliedCount_57, s0_.approvedCount AS approvedCount_58, s0_.rejectedCount AS rejectedCount_59, s0_.stripeAccount AS stripeAccount_60, s0_.stripePriceId AS stripePriceId_61, s0_.stripeProductId AS stripeProductId_62, s0_.stripePriceIdLive AS stripePriceIdLive_63, s0_.stripePriceIdTest AS stripePriceIdTest_64, s0_.stripeProductIdLive AS stripeProductIdLive_65, s0_.stripeProductIdTest AS stripeProductIdTest_66, s0_.taxBehavior AS taxBehavior_67, s0_.paymentProvider AS paymentProvider_68, s0_.registrationMode AS registrationMode_69, s0_.externalRegistrationUrl AS externalRegistrationUrl_70, s0_.externalPlatform AS externalPlatform_71, s0_.lumaEventApiId AS lumaEventApiId_72, s0_.meetupEventId AS meetupEventId_73, s0_.meetupEventUrl AS meetupEventUrl_74, s0_.registrationHeadline AS registrationHeadline_75, s0_.registrationSubtitle AS registrationSubtitle_76, s0_.registrationButtonText AS registrationButtonText_77, s0_.registrationPriceHtml AS registrationPriceHtml_78, s0_.registrationRedirectUrl AS registrationRedirectUrl_79, s0_.registrationTone AS registrationTone_80, s0_.remoteSessionText AS remoteSessionText_81, s0_.autoApprovalTag AS autoApprovalTag_82, s0_.capacity AS capacity_83, s0_.title AS title_84, s0_.teaser AS teaser_85, s0_.navbar AS navbar_86, s0_.content AS content_87, s0_.contentTwig AS contentTwig_88, s0_.ctaContent AS ctaContent_89, s0_.postCtaContent AS postCtaContent_90, s0_.tagline AS tagline_91, s0_.seoTitle AS seoTitle_92, s0_.seoDescription AS seoDescription_93, s0_.seoKeyword AS seoKeyword_94, s0_.imagelink AS imagelink_95, s0_.bgImagelink AS bgImagelink_96, s0_.videolink AS videolink_97, s0_.additionalCss AS additionalCss_98, s0_.additionalJs AS additionalJs_99, s0_.trainer AS trainer_100, s0_.venueName AS venueName_101, s0_.venueAddress AS venueAddress_102, s0_.whereOverride AS whereOverride_103, s0_.showFullVenue AS showFullVenue_104, s0_.navbarEn AS navbarEn_105, s0_.teaserEn AS teaserEn_106, s0_.contentEn AS contentEn_107, s0_.contentTwigEn AS contentTwigEn_108, s0_.postCtaContentEn AS postCtaContentEn_109, s0_.seoTitleEn AS seoTitleEn_110, s0_.seoDescriptionEn AS seoDescriptionEn_111, s0_.seoKeywordEn AS seoKeywordEn_112, s0_.email AS email_113, s0_.landingPageContent AS landingPageContent_114, s0_.landingPageDescription AS landingPageDescription_115, s0_.landingPageCss AS landingPageCss_116, s0_.landingPageJs AS landingPageJs_117, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_118, s0_.landingPageTitle AS landingPageTitle_119, s0_.followUpDescription AS followUpDescription_120, s0_.followUpVideoLink AS followUpVideoLink_121, s0_.followUpPresentation AS followUpPresentation_122, s0_.followUpPageContent AS followUpPageContent_123, s0_.followUpPageCss AS followUpPageCss_124, s0_.followUpPageTitle AS followUpPageTitle_125, s0_.followUpSkoolUrl AS followUpSkoolUrl_126, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_127, s0_.followUpCtaText AS followUpCtaText_128, s0_.followUpCtaUrl AS followUpCtaUrl_129, s0_.followUpDocuments AS followUpDocuments_130, s0_.followUpPhotos AS followUpPhotos_131, s0_.followUpExtraLinks AS followUpExtraLinks_132, s0_.history AS history_133, s0_.settings AS settings_134, s0_.skoolWebhook AS skoolWebhook_135, s0_.zapierWebhook AS zapierWebhook_136, s0_.metaLeadFormId AS metaLeadFormId_137, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_138 FROM sp_event_dates s0_ WHERE s0_.eventId = 7026 AND s0_.status = 'active' AND s0_.access = 'anonymous' AND (s0_.startDate IS NOT NULL AND s0_.startDate >= '2026-06-11 00:00:00') ORDER BY s0_.startDate ASC LIMIT 1;
6	1.10 ms	SELECT b.id as batch_id, b.eventId as event_id, b.name as batch_name, b.slug as batch_slug, b.startDate 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_event_dates b ON b.eventId = e.id WHERE e.seriesTag = ? AND e.status = 'publish' AND b.status = 'active' AND e.isMultiBatchEvent = 1 AND b.startDate > NOW() ORDER BY b.startDate ASC Parameters: [`"TechTuesday"`] 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, b.startDate 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_event_dates b ON b.eventId = e.id WHERE e.seriesTag = ? AND e.status = 'publish' AND b.status = 'active' AND e.isMultiBatchEvent = 1 AND b.startDate > NOW() ORDER BY b.startDate ASC SELECT b.id as batch_id, b.eventId as event_id, b.name as batch_name, b.slug as batch_slug, b.startDate 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_event_dates b ON b.eventId = e.id WHERE e.seriesTag = 'TechTuesday' AND e.status = 'publish' AND b.status = 'active' AND e.isMultiBatchEvent = 1 AND b.startDate > NOW() ORDER BY b.startDate ASC;
7	0.81 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) 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_event_dates b ON b.eventId = e.id WHERE e.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()) ) ORDER BY COALESCE(b.endDate, b.startDate) DESC Parameters: [`"TechTuesday"`] 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) 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_event_dates b ON b.eventId = e.id WHERE e.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() ) ) ORDER BY COALESCE(b.endDate, b.startDate) 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) 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_event_dates b ON b.eventId = e.id WHERE e.seriesTag = 'TechTuesday' 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()) ) ORDER BY COALESCE(b.endDate, b.startDate) 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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\StartPlatz\Bundle\EventBundle\Entity\Event	1
App\StartPlatz\Bundle\EventBundle\Entity\EventDate	1

Entities Mapping

Class	Mapping errors
App\StartPlatz\Bundle\UserBundle\Entity\User	No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\Team	No errors.
App\StartPlatz\Bundle\EventBundle\Entity\Event	No errors.
App\StartPlatz\Bundle\EventBundle\Entity\EventDate	No errors.

Symfony Profiler

GET http://www.staging.startplatz.de/event-series/TechTuesday

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping