Symfony Profiler

Query Metrics

23 Database Queries

17 Different statements

15.01 ms Query time

0 Invalid entities

32 Managed entities

Queries


SELECT t0.id AS id_1, t0.eventbriteId AS eventbriteId_2, t0.googleCalendarEventId AS googleCalendarEventId_3, t0.wpPostId AS wpPostId_4, t0.title AS title_5, t0.title_en AS title_en_6, t0.slug AS slug_7, t0.lang AS lang_8, t0.imagelink AS imagelink_9, t0.videolink AS videolink_10, t0.bgImagelink AS bgImagelink_11, t0.tagline AS tagline_12, t0.headerTextColor AS headerTextColor_13, t0.spResponsiblePerson AS spResponsiblePerson_14, t0.organization AS organization_15, t0.organizerName AS organizerName_16, t0.organizerEmail AS organizerEmail_17, t0.venueName AS venueName_18, t0.venueAddress AS venueAddress_19, t0.showFullVenue AS showFullVenue_20, t0.ticketing AS ticketing_21, t0.applicationUrl AS applicationUrl_22, t0.alert AS alert_23, t0.trainer AS trainer_24, t0.speakers AS speakers_25, t0.teaser AS teaser_26, t0.navbar AS navbar_27, t0.stripePriceId AS stripePriceId_28, t0.stripeProductId AS stripeProductId_29, t0.stripeAccount AS stripeAccount_30, t0.priceInEuroCent AS priceInEuroCent_31, t0.isTaxIncluded AS isTaxIncluded_32, t0.isFreeForKiCampus AS isFreeForKiCampus_33, t0.isFreeForCommunity AS isFreeForCommunity_34, t0.isSinglePage AS isSinglePage_35, t0.isFormalLanguage AS isFormalLanguage_36, t0.isMultiBatchEvent AS isMultiBatchEvent_37, t0.isFeatured AS isFeatured_38, t0.isFlagship AS isFlagship_39, t0.capacity AS capacity_40, t0.targetCapacity AS targetCapacity_41, t0.twigFile AS twigFile_42, t0.additionalCss AS additionalCss_43, t0.content AS content_44, t0.contentTwig AS contentTwig_45, t0.content_blocks AS content_blocks_46, t0.content_blocks_en AS content_blocks_en_47, t0.ctaContent AS ctaContent_48, t0.postCtaContent AS postCtaContent_49, t0.tags AS tags_50, t0.seriesTag AS seriesTag_51, t0.feedbackFormId AS feedbackFormId_52, t0.type AS type_53, t0.location AS location_54, t0.startDate AS startDate_55, t0.endDate AS endDate_56, t0.duration AS duration_57, t0.status AS status_58, t0.publishedAt AS publishedAt_59, t0.publishedBy AS publishedBy_60, t0.settings AS settings_61, t0.displayStartDate AS displayStartDate_62, t0.seoTitle AS seoTitle_63, t0.seoKeyword AS seoKeyword_64, t0.seoDescription AS seoDescription_65, t0.navbar_en AS navbar_en_66, t0.teaser_en AS teaser_en_67, t0.content_en AS content_en_68, t0.content_twig_en AS content_twig_en_69, t0.post_cta_content_en AS post_cta_content_en_70, t0.seo_title_en AS seo_title_en_71, t0.seo_description_en AS seo_description_en_72, t0.seo_keyword_en AS seo_keyword_en_73, t0.has_english_version AS has_english_version_74, t0.additional_js AS additional_js_75, t0.metaPixelId AS metaPixelId_76, t0.createDate AS createDate_77, t0.lastChangeDate AS lastChangeDate_78, t0.lastChangeUser AS lastChangeUser_79, t0.publicId AS publicId_80, t0.isExternalSubmission AS isExternalSubmission_81, t0.createdBy AS createdBy_82, t0.lastModified AS lastModified_83, t0.createdAt AS createdAt_84, t0.orgaNote AS orgaNote_85, t0.calendarSyncedAt AS calendarSyncedAt_86, t0.logisticsRoom AS logisticsRoom_87, t0.logisticsCatering AS logisticsCatering_88, t0.logisticsEquipment AS logisticsEquipment_89, t0.logisticsHelpers AS logisticsHelpers_90, t0.history AS history_91, t0.todoHistory AS todoHistory_92 FROM sp_event_events t0 WHERE t0.slug = ? 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_.isFlagship AS isFlagship_38, s0_.capacity AS capacity_39, s0_.targetCapacity AS targetCapacity_40, s0_.twigFile AS twigFile_41, s0_.additionalCss AS additionalCss_42, s0_.content AS content_43, s0_.contentTwig AS contentTwig_44, s0_.content_blocks AS content_blocks_45, s0_.content_blocks_en AS content_blocks_en_46, s0_.ctaContent AS ctaContent_47, s0_.postCtaContent AS postCtaContent_48, s0_.tags AS tags_49, s0_.seriesTag AS seriesTag_50, s0_.feedbackFormId AS feedbackFormId_51, s0_.type AS type_52, s0_.location AS location_53, s0_.startDate AS startDate_54, s0_.endDate AS endDate_55, s0_.duration AS duration_56, s0_.status AS status_57, s0_.publishedAt AS publishedAt_58, s0_.publishedBy AS publishedBy_59, s0_.settings AS settings_60, s0_.displayStartDate AS displayStartDate_61, s0_.seoTitle AS seoTitle_62, s0_.seoKeyword AS seoKeyword_63, s0_.seoDescription AS seoDescription_64, s0_.navbar_en AS navbar_en_65, s0_.teaser_en AS teaser_en_66, s0_.content_en AS content_en_67, s0_.content_twig_en AS content_twig_en_68, s0_.post_cta_content_en AS post_cta_content_en_69, s0_.seo_title_en AS seo_title_en_70, s0_.seo_description_en AS seo_description_en_71, s0_.seo_keyword_en AS seo_keyword_en_72, s0_.has_english_version AS has_english_version_73, s0_.additional_js AS additional_js_74, s0_.metaPixelId AS metaPixelId_75, s0_.createDate AS createDate_76, s0_.lastChangeDate AS lastChangeDate_77, s0_.lastChangeUser AS lastChangeUser_78, s0_.publicId AS publicId_79, s0_.isExternalSubmission AS isExternalSubmission_80, s0_.createdBy AS createdBy_81, s0_.lastModified AS lastModified_82, s0_.createdAt AS createdAt_83, s0_.orgaNote AS orgaNote_84, s0_.calendarSyncedAt AS calendarSyncedAt_85, s0_.logisticsRoom AS logisticsRoom_86, s0_.logisticsCatering AS logisticsCatering_87, s0_.logisticsEquipment AS logisticsEquipment_88, s0_.logisticsHelpers AS logisticsHelpers_89, s0_.history AS history_90, s0_.todoHistory AS todoHistory_91 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.status = ? ORDER BY s0_.startDate DESC LIMIT 8
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_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = ? ORDER BY s0_.startDate ASC
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_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND (s0_.startDate IS NOT NULL AND s0_.startDate BETWEEN ? AND ?) AND s0_.status IN (?, ?) 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_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND s0_.status = ? AND (s0_.startDate IS NOT NULL AND s0_.startDate >= ?) ORDER BY s0_.startDate ASC LIMIT 10
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_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND (s0_.startDate IS NOT NULL AND s0_.startDate < ?) ORDER BY s0_.startDate DESC LIMIT 10
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.lang AS lang_5, t0.bgImageUrl AS bgImageUrl_6, t0.mailDesignTemplate AS mailDesignTemplate_7, t0.senderMail AS senderMail_8, t0.fromName AS fromName_9, t0.recipientMonitoringMail AS recipientMonitoringMail_10, t0.confirmationMailSubject AS confirmationMailSubject_11, t0.confirmationMailContent AS confirmationMailContent_12, t0.email AS email_13, t0.landingPageContent AS landingPageContent_14, t0.template AS template_15, t0.homepage AS homepage_16, t0.visibility AS visibility_17, t0.access AS access_18, t0.hasEvent AS hasEvent_19, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_20, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_21, t0.eventId AS eventId_22, t0.zoomLink AS zoomLink_23, t0.typeformLink AS typeformLink_24, t0.mailTemplate AS mailTemplate_25, t0.mailSubject AS mailSubject_26, t0.reminderMailTemplateId AS reminderMailTemplateId_27, t0.reminderSenderEmail AS reminderSenderEmail_28, t0.phrasesDe AS phrasesDe_29, t0.phrasesEn AS phrasesEn_30, t0.settings AS settings_31, t0.createdAt AS createdAt_32, t0.lastModified AS lastModified_33, t0.lastChangeUser AS lastChangeUser_34 FROM sp_programs t0 WHERE t0.id = ?
SELECT COUNT(s0_.id) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_.eventDateId = ? AND s0_.applicationStatus = ? AND s0_.deletedAt IS NULL
SELECT COUNT(s0_.id) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_.eventDateId = ? AND s0_.applicationStatus = ? AND s0_.deletedAt IS NULL
SELECT COUNT(s0_.id) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_.eventDateId = ? AND s0_.applicationStatus = ? AND s0_.deletedAt IS NULL
SELECT COUNT(s0_.id) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_.eventDateId = ? AND s0_.applicationStatus = ? AND s0_.deletedAt IS NULL
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.value AS value_3, t0.type AS type_4, t0.category AS category_5, t0.description AS description_6, t0.createdAt AS createdAt_7, t0.updatedAt AS updatedAt_8, t0.updatedBy AS updatedBy_9 FROM sp_system_config t0 WHERE t0.`key` = ? LIMIT 1
"START TRANSACTION"
UPDATE sp_event_dates SET applicationsCount = ?, startedCount = ?, appliedCount = ?, approvedCount = ?, rejectedCount = ?, lastModified = ? WHERE id = ?
"COMMIT"
SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37, t0.publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37, t0.publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37, t0.publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.score AS score_2, t0.completenessScore AS completenessScore_3, t0.status AS status_4, t0.location AS location_5, t0.salutation AS salutation_6, t0.title AS title_7, t0.jobTitle AS jobTitle_8, t0.firstName AS firstName_9, t0.lastName AS lastName_10, t0.name AS name_11, t0.sortName AS sortName_12, t0.email AS email_13, t0.secondaryEmail AS secondaryEmail_14, t0.phone AS phone_15, t0.hasCommunityMembership AS hasCommunityMembership_16, t0.utm_source AS utm_source_17, t0.utm_medium AS utm_medium_18, t0.utm_campaign AS utm_campaign_19, t0.utm_term AS utm_term_20, t0.utm_content AS utm_content_21, t0.birthday AS birthday_22, t0.addressFieldOne AS addressFieldOne_23, t0.addressFieldTwo AS addressFieldTwo_24, t0.addressCountryCode AS addressCountryCode_25, t0.addressPostalCode AS addressPostalCode_26, t0.addressCity AS addressCity_27, t0.teamId AS teamId_28, t0.teamName AS teamName_29, t0.company AS company_30, t0.history AS history_31, t0.tags AS tags_32, t0.annotation AS annotation_33, t0.mentorBuckets AS mentorBuckets_34, t0.areasOfExpertise AS areasOfExpertise_35, t0.mentor_firma AS mentor_firma_36, t0.mentor_firma_url AS mentor_firma_url_37, t0.mentor_locations AS mentor_locations_38, t0.mentor_profile AS mentor_profile_39, t0.mentor_note AS mentor_note_40, t0.mentor_admin_rating AS mentor_admin_rating_41, t0.active AS active_42, t0.tiefgarage AS tiefgarage_43, t0.transponder AS transponder_44, t0.isTransponderAllowed AS isTransponderAllowed_45, t0.imageLink AS imageLink_46, t0.homepage AS homepage_47, t0.xing AS xing_48, t0.pipedriveId AS pipedriveId_49, t0.linkedin AS linkedin_50, t0.facebook AS facebook_51, t0.instagram AS instagram_52, t0.tiktok AS tiktok_53, t0.threads AS threads_54, t0.youtube AS youtube_55, t0.twitter AS twitter_56, t0.github AS github_57, t0.reachableLocation AS reachableLocation_58, t0.skills AS skills_59, t0.description AS description_60, t0.isVisibleInNetworking AS isVisibleInNetworking_61, t0.gender AS gender_62, t0.currentFocus AS currentFocus_63, t0.networkingConsentAt AS networkingConsentAt_64, t0.networkingConsentVersion AS networkingConsentVersion_65, t0.networkingConsentRevokedAt AS networkingConsentRevokedAt_66, t0.touchpoints AS touchpoints_67, t0.isAddressComplete AS isAddressComplete_68, t0.hasMailchimp AS hasMailchimp_69, t0.hasKiNewsletter AS hasKiNewsletter_70, t0.hubspotSyncPending AS hubspotSyncPending_71, t0.enterDate AS enterDate_72, t0.exitDate AS exitDate_73, t0.physicalMembershipStarted AS physicalMembershipStarted_74, t0.physicalMembershipEnded AS physicalMembershipEnded_75, t0.lastModified AS lastModified_76, t0.lastChangeUser AS lastChangeUser_77, t0.onboardingCompletedAt AS onboardingCompletedAt_78, t0.nAiWebinarsAttended AS nAiWebinarsAttended_79, t0.nAiWebinarsApplied AS nAiWebinarsApplied_80, t0.nAiEventsAttended AS nAiEventsAttended_81, t0.nAiEventsApplied AS nAiEventsApplied_82, t0.nPaidAttended AS nPaidAttended_83, t0.nPaidApplied AS nPaidApplied_84, t0.nKiEinstiegAttended AS nKiEinstiegAttended_85, t0.nKiEinstiegApplied AS nKiEinstiegApplied_86, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_87, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_88, t0.nEcodynamicsAttended AS nEcodynamicsAttended_89, t0.nEcodynamicsApplied AS nEcodynamicsApplied_90, t0.nBbqApplied AS nBbqApplied_91, t0.nAiFridayApplied AS nAiFridayApplied_92, t0.nAiGatheringApplied AS nAiGatheringApplied_93, t0.nAiGatheringAttended AS nAiGatheringAttended_94, t0.aiSs24Applied AS aiSs24Applied_95, t0.aiSs24Booked AS aiSs24Booked_96, t0.interestedIn AS interestedIn_97, t0.interests AS interests_98, t0.mentorMetadata AS mentorMetadata_99, t0.eventParticipations AS eventParticipations_100, t0.kiKompetenz AS kiKompetenz_101, t0.mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.score AS score_2, t0.completenessScore AS completenessScore_3, t0.status AS status_4, t0.location AS location_5, t0.salutation AS salutation_6, t0.title AS title_7, t0.jobTitle AS jobTitle_8, t0.firstName AS firstName_9, t0.lastName AS lastName_10, t0.name AS name_11, t0.sortName AS sortName_12, t0.email AS email_13, t0.secondaryEmail AS secondaryEmail_14, t0.phone AS phone_15, t0.hasCommunityMembership AS hasCommunityMembership_16, t0.utm_source AS utm_source_17, t0.utm_medium AS utm_medium_18, t0.utm_campaign AS utm_campaign_19, t0.utm_term AS utm_term_20, t0.utm_content AS utm_content_21, t0.birthday AS birthday_22, t0.addressFieldOne AS addressFieldOne_23, t0.addressFieldTwo AS addressFieldTwo_24, t0.addressCountryCode AS addressCountryCode_25, t0.addressPostalCode AS addressPostalCode_26, t0.addressCity AS addressCity_27, t0.teamId AS teamId_28, t0.teamName AS teamName_29, t0.company AS company_30, t0.history AS history_31, t0.tags AS tags_32, t0.annotation AS annotation_33, t0.mentorBuckets AS mentorBuckets_34, t0.areasOfExpertise AS areasOfExpertise_35, t0.mentor_firma AS mentor_firma_36, t0.mentor_firma_url AS mentor_firma_url_37, t0.mentor_locations AS mentor_locations_38, t0.mentor_profile AS mentor_profile_39, t0.mentor_note AS mentor_note_40, t0.mentor_admin_rating AS mentor_admin_rating_41, t0.active AS active_42, t0.tiefgarage AS tiefgarage_43, t0.transponder AS transponder_44, t0.isTransponderAllowed AS isTransponderAllowed_45, t0.imageLink AS imageLink_46, t0.homepage AS homepage_47, t0.xing AS xing_48, t0.pipedriveId AS pipedriveId_49, t0.linkedin AS linkedin_50, t0.facebook AS facebook_51, t0.instagram AS instagram_52, t0.tiktok AS tiktok_53, t0.threads AS threads_54, t0.youtube AS youtube_55, t0.twitter AS twitter_56, t0.github AS github_57, t0.reachableLocation AS reachableLocation_58, t0.skills AS skills_59, t0.description AS description_60, t0.isVisibleInNetworking AS isVisibleInNetworking_61, t0.gender AS gender_62, t0.currentFocus AS currentFocus_63, t0.networkingConsentAt AS networkingConsentAt_64, t0.networkingConsentVersion AS networkingConsentVersion_65, t0.networkingConsentRevokedAt AS networkingConsentRevokedAt_66, t0.touchpoints AS touchpoints_67, t0.isAddressComplete AS isAddressComplete_68, t0.hasMailchimp AS hasMailchimp_69, t0.hasKiNewsletter AS hasKiNewsletter_70, t0.hubspotSyncPending AS hubspotSyncPending_71, t0.enterDate AS enterDate_72, t0.exitDate AS exitDate_73, t0.physicalMembershipStarted AS physicalMembershipStarted_74, t0.physicalMembershipEnded AS physicalMembershipEnded_75, t0.lastModified AS lastModified_76, t0.lastChangeUser AS lastChangeUser_77, t0.onboardingCompletedAt AS onboardingCompletedAt_78, t0.nAiWebinarsAttended AS nAiWebinarsAttended_79, t0.nAiWebinarsApplied AS nAiWebinarsApplied_80, t0.nAiEventsAttended AS nAiEventsAttended_81, t0.nAiEventsApplied AS nAiEventsApplied_82, t0.nPaidAttended AS nPaidAttended_83, t0.nPaidApplied AS nPaidApplied_84, t0.nKiEinstiegAttended AS nKiEinstiegAttended_85, t0.nKiEinstiegApplied AS nKiEinstiegApplied_86, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_87, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_88, t0.nEcodynamicsAttended AS nEcodynamicsAttended_89, t0.nEcodynamicsApplied AS nEcodynamicsApplied_90, t0.nBbqApplied AS nBbqApplied_91, t0.nAiFridayApplied AS nAiFridayApplied_92, t0.nAiGatheringApplied AS nAiGatheringApplied_93, t0.nAiGatheringAttended AS nAiGatheringAttended_94, t0.aiSs24Applied AS aiSs24Applied_95, t0.aiSs24Booked AS aiSs24Booked_96, t0.interestedIn AS interestedIn_97, t0.interests AS interests_98, t0.mentorMetadata AS mentorMetadata_99, t0.eventParticipations AS eventParticipations_100, t0.kiKompetenz AS kiKompetenz_101, t0.mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0.id = ?
SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.eventDateId AS eventDateId_2, s0_.mentorId AS mentorId_3, s0_.position AS position_4, s0_.durationMinutes AS durationMinutes_5, s0_.role AS role_6, s0_.status AS status_7, s0_.source AS source_8, s0_.talkTitle AS talkTitle_9, s0_.description AS description_10, s0_.contactName AS contactName_11, s0_.contactEmail AS contactEmail_12, s0_.contactCompany AS contactCompany_13, s0_.contactLinkedin AS contactLinkedin_14, s0_.publicVisible AS publicVisible_15, s0_.adminNote AS adminNote_16, s0_.respondedAt AS respondedAt_17, s0_.createdAt AS createdAt_18, s0_.updatedAt AS updatedAt_19 FROM sp_event_program_slots s0_ WHERE s0_.eventId IN (?) AND s0_.publicVisible = 1 AND s0_.status = ? ORDER BY s0_.position ASC, s0_.id ASC
SELECT s0_.eventId AS eventId_0, s0_.eventDateId AS eventDateId_1, COUNT(s0_.id) AS sclr_2 FROM sp_event_program_slots s0_ WHERE s0_.eventId IN (?) AND s0_.status = ? GROUP BY s0_.eventId, s0_.eventDateId
SELECT t0.id AS id_1, t0.metaname AS metaname_2, t0.label AS label_3, t0.metavalue AS metavalue_4, t0.lastModified AS lastModified_5 FROM sp_member_options t0 WHERE t0.metaname = ? LIMIT 1

#▲	Time	Info
1	0.62 ms	SELECT t0.id AS id_1, t0.eventbriteId AS eventbriteId_2, t0.googleCalendarEventId AS googleCalendarEventId_3, t0.wpPostId AS wpPostId_4, t0.title AS title_5, t0.title_en AS title_en_6, t0.slug AS slug_7, t0.lang AS lang_8, t0.imagelink AS imagelink_9, t0.videolink AS videolink_10, t0.bgImagelink AS bgImagelink_11, t0.tagline AS tagline_12, t0.headerTextColor AS headerTextColor_13, t0.spResponsiblePerson AS spResponsiblePerson_14, t0.organization AS organization_15, t0.organizerName AS organizerName_16, t0.organizerEmail AS organizerEmail_17, t0.venueName AS venueName_18, t0.venueAddress AS venueAddress_19, t0.showFullVenue AS showFullVenue_20, t0.ticketing AS ticketing_21, t0.applicationUrl AS applicationUrl_22, t0.alert AS alert_23, t0.trainer AS trainer_24, t0.speakers AS speakers_25, t0.teaser AS teaser_26, t0.navbar AS navbar_27, t0.stripePriceId AS stripePriceId_28, t0.stripeProductId AS stripeProductId_29, t0.stripeAccount AS stripeAccount_30, t0.priceInEuroCent AS priceInEuroCent_31, t0.isTaxIncluded AS isTaxIncluded_32, t0.isFreeForKiCampus AS isFreeForKiCampus_33, t0.isFreeForCommunity AS isFreeForCommunity_34, t0.isSinglePage AS isSinglePage_35, t0.isFormalLanguage AS isFormalLanguage_36, t0.isMultiBatchEvent AS isMultiBatchEvent_37, t0.isFeatured AS isFeatured_38, t0.isFlagship AS isFlagship_39, t0.capacity AS capacity_40, t0.targetCapacity AS targetCapacity_41, t0.twigFile AS twigFile_42, t0.additionalCss AS additionalCss_43, t0.content AS content_44, t0.contentTwig AS contentTwig_45, t0.content_blocks AS content_blocks_46, t0.content_blocks_en AS content_blocks_en_47, t0.ctaContent AS ctaContent_48, t0.postCtaContent AS postCtaContent_49, t0.tags AS tags_50, t0.seriesTag AS seriesTag_51, t0.feedbackFormId AS feedbackFormId_52, t0.type AS type_53, t0.location AS location_54, t0.startDate AS startDate_55, t0.endDate AS endDate_56, t0.duration AS duration_57, t0.status AS status_58, t0.publishedAt AS publishedAt_59, t0.publishedBy AS publishedBy_60, t0.settings AS settings_61, t0.displayStartDate AS displayStartDate_62, t0.seoTitle AS seoTitle_63, t0.seoKeyword AS seoKeyword_64, t0.seoDescription AS seoDescription_65, t0.navbar_en AS navbar_en_66, t0.teaser_en AS teaser_en_67, t0.content_en AS content_en_68, t0.content_twig_en AS content_twig_en_69, t0.post_cta_content_en AS post_cta_content_en_70, t0.seo_title_en AS seo_title_en_71, t0.seo_description_en AS seo_description_en_72, t0.seo_keyword_en AS seo_keyword_en_73, t0.has_english_version AS has_english_version_74, t0.additional_js AS additional_js_75, t0.metaPixelId AS metaPixelId_76, t0.createDate AS createDate_77, t0.lastChangeDate AS lastChangeDate_78, t0.lastChangeUser AS lastChangeUser_79, t0.publicId AS publicId_80, t0.isExternalSubmission AS isExternalSubmission_81, t0.createdBy AS createdBy_82, t0.lastModified AS lastModified_83, t0.createdAt AS createdAt_84, t0.orgaNote AS orgaNote_85, t0.calendarSyncedAt AS calendarSyncedAt_86, t0.logisticsRoom AS logisticsRoom_87, t0.logisticsCatering AS logisticsCatering_88, t0.logisticsEquipment AS logisticsEquipment_89, t0.logisticsHelpers AS logisticsHelpers_90, t0.history AS history_91, t0.todoHistory AS todoHistory_92 FROM sp_event_events t0 WHERE t0.slug = ? LIMIT 1 Parameters: [`"ai-friday-ki-community-meetup-duesseldorf"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.eventbriteId AS eventbriteId_2, t0.googleCalendarEventId AS googleCalendarEventId_3, t0.wpPostId AS wpPostId_4, t0.title AS title_5, t0.title_en AS title_en_6, t0.slug AS slug_7, t0.lang AS lang_8, t0.imagelink AS imagelink_9, t0.videolink AS videolink_10, t0.bgImagelink AS bgImagelink_11, t0.tagline AS tagline_12, t0.headerTextColor AS headerTextColor_13, t0.spResponsiblePerson AS spResponsiblePerson_14, t0.organization AS organization_15, t0.organizerName AS organizerName_16, t0.organizerEmail AS organizerEmail_17, t0.venueName AS venueName_18, t0.venueAddress AS venueAddress_19, t0.showFullVenue AS showFullVenue_20, t0.ticketing AS ticketing_21, t0.applicationUrl AS applicationUrl_22, t0.alert AS alert_23, t0.trainer AS trainer_24, t0.speakers AS speakers_25, t0.teaser AS teaser_26, t0.navbar AS navbar_27, t0.stripePriceId AS stripePriceId_28, t0.stripeProductId AS stripeProductId_29, t0.stripeAccount AS stripeAccount_30, t0.priceInEuroCent AS priceInEuroCent_31, t0.isTaxIncluded AS isTaxIncluded_32, t0.isFreeForKiCampus AS isFreeForKiCampus_33, t0.isFreeForCommunity AS isFreeForCommunity_34, t0.isSinglePage AS isSinglePage_35, t0.isFormalLanguage AS isFormalLanguage_36, t0.isMultiBatchEvent AS isMultiBatchEvent_37, t0.isFeatured AS isFeatured_38, t0.isFlagship AS isFlagship_39, t0.capacity AS capacity_40, t0.targetCapacity AS targetCapacity_41, t0.twigFile AS twigFile_42, t0.additionalCss AS additionalCss_43, t0.content AS content_44, t0.contentTwig AS contentTwig_45, t0.content_blocks AS content_blocks_46, t0.content_blocks_en AS content_blocks_en_47, t0.ctaContent AS ctaContent_48, t0.postCtaContent AS postCtaContent_49, t0.tags AS tags_50, t0.seriesTag AS seriesTag_51, t0.feedbackFormId AS feedbackFormId_52, t0.type AS type_53, t0.location AS location_54, t0.startDate AS startDate_55, t0.endDate AS endDate_56, t0.duration AS duration_57, t0.status AS status_58, t0.publishedAt AS publishedAt_59, t0.publishedBy AS publishedBy_60, t0.settings AS settings_61, t0.displayStartDate AS displayStartDate_62, t0.seoTitle AS seoTitle_63, t0.seoKeyword AS seoKeyword_64, t0.seoDescription AS seoDescription_65, t0.navbar_en AS navbar_en_66, t0.teaser_en AS teaser_en_67, t0.content_en AS content_en_68, t0.content_twig_en AS content_twig_en_69, t0.post_cta_content_en AS post_cta_content_en_70, t0.seo_title_en AS seo_title_en_71, t0.seo_description_en AS seo_description_en_72, t0.seo_keyword_en AS seo_keyword_en_73, t0.has_english_version AS has_english_version_74, t0.additional_js AS additional_js_75, t0.metaPixelId AS metaPixelId_76, t0.createDate AS createDate_77, t0.lastChangeDate AS lastChangeDate_78, t0.lastChangeUser AS lastChangeUser_79, t0.publicId AS publicId_80, t0.isExternalSubmission AS isExternalSubmission_81, t0.createdBy AS createdBy_82, t0.lastModified AS lastModified_83, t0.createdAt AS createdAt_84, t0.orgaNote AS orgaNote_85, t0.calendarSyncedAt AS calendarSyncedAt_86, t0.logisticsRoom AS logisticsRoom_87, t0.logisticsCatering AS logisticsCatering_88, t0.logisticsEquipment AS logisticsEquipment_89, t0.logisticsHelpers AS logisticsHelpers_90, t0.history AS history_91, t0.todoHistory AS todoHistory_92 FROM sp_event_events t0 WHERE t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.eventbriteId AS eventbriteId_2, t0.googleCalendarEventId AS googleCalendarEventId_3, t0.wpPostId AS wpPostId_4, t0.title AS title_5, t0.title_en AS title_en_6, t0.slug AS slug_7, t0.lang AS lang_8, t0.imagelink AS imagelink_9, t0.videolink AS videolink_10, t0.bgImagelink AS bgImagelink_11, t0.tagline AS tagline_12, t0.headerTextColor AS headerTextColor_13, t0.spResponsiblePerson AS spResponsiblePerson_14, t0.organization AS organization_15, t0.organizerName AS organizerName_16, t0.organizerEmail AS organizerEmail_17, t0.venueName AS venueName_18, t0.venueAddress AS venueAddress_19, t0.showFullVenue AS showFullVenue_20, t0.ticketing AS ticketing_21, t0.applicationUrl AS applicationUrl_22, t0.alert AS alert_23, t0.trainer AS trainer_24, t0.speakers AS speakers_25, t0.teaser AS teaser_26, t0.navbar AS navbar_27, t0.stripePriceId AS stripePriceId_28, t0.stripeProductId AS stripeProductId_29, t0.stripeAccount AS stripeAccount_30, t0.priceInEuroCent AS priceInEuroCent_31, t0.isTaxIncluded AS isTaxIncluded_32, t0.isFreeForKiCampus AS isFreeForKiCampus_33, t0.isFreeForCommunity AS isFreeForCommunity_34, t0.isSinglePage AS isSinglePage_35, t0.isFormalLanguage AS isFormalLanguage_36, t0.isMultiBatchEvent AS isMultiBatchEvent_37, t0.isFeatured AS isFeatured_38, t0.isFlagship AS isFlagship_39, t0.capacity AS capacity_40, t0.targetCapacity AS targetCapacity_41, t0.twigFile AS twigFile_42, t0.additionalCss AS additionalCss_43, t0.content AS content_44, t0.contentTwig AS contentTwig_45, t0.content_blocks AS content_blocks_46, t0.content_blocks_en AS content_blocks_en_47, t0.ctaContent AS ctaContent_48, t0.postCtaContent AS postCtaContent_49, t0.tags AS tags_50, t0.seriesTag AS seriesTag_51, t0.feedbackFormId AS feedbackFormId_52, t0.type AS type_53, t0.location AS location_54, t0.startDate AS startDate_55, t0.endDate AS endDate_56, t0.duration AS duration_57, t0.status AS status_58, t0.publishedAt AS publishedAt_59, t0.publishedBy AS publishedBy_60, t0.settings AS settings_61, t0.displayStartDate AS displayStartDate_62, t0.seoTitle AS seoTitle_63, t0.seoKeyword AS seoKeyword_64, t0.seoDescription AS seoDescription_65, t0.navbar_en AS navbar_en_66, t0.teaser_en AS teaser_en_67, t0.content_en AS content_en_68, t0.content_twig_en AS content_twig_en_69, t0.post_cta_content_en AS post_cta_content_en_70, t0.seo_title_en AS seo_title_en_71, t0.seo_description_en AS seo_description_en_72, t0.seo_keyword_en AS seo_keyword_en_73, t0.has_english_version AS has_english_version_74, t0.additional_js AS additional_js_75, t0.metaPixelId AS metaPixelId_76, t0.createDate AS createDate_77, t0.lastChangeDate AS lastChangeDate_78, t0.lastChangeUser AS lastChangeUser_79, t0.publicId AS publicId_80, t0.isExternalSubmission AS isExternalSubmission_81, t0.createdBy AS createdBy_82, t0.lastModified AS lastModified_83, t0.createdAt AS createdAt_84, t0.orgaNote AS orgaNote_85, t0.calendarSyncedAt AS calendarSyncedAt_86, t0.logisticsRoom AS logisticsRoom_87, t0.logisticsCatering AS logisticsCatering_88, t0.logisticsEquipment AS logisticsEquipment_89, t0.logisticsHelpers AS logisticsHelpers_90, t0.history AS history_91, t0.todoHistory AS todoHistory_92 FROM sp_event_events t0 WHERE t0.slug = 'ai-friday-ki-community-meetup-duesseldorf' LIMIT 1;
2	4.88 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_.isFlagship AS isFlagship_38, s0_.capacity AS capacity_39, s0_.targetCapacity AS targetCapacity_40, s0_.twigFile AS twigFile_41, s0_.additionalCss AS additionalCss_42, s0_.content AS content_43, s0_.contentTwig AS contentTwig_44, s0_.content_blocks AS content_blocks_45, s0_.content_blocks_en AS content_blocks_en_46, s0_.ctaContent AS ctaContent_47, s0_.postCtaContent AS postCtaContent_48, s0_.tags AS tags_49, s0_.seriesTag AS seriesTag_50, s0_.feedbackFormId AS feedbackFormId_51, s0_.type AS type_52, s0_.location AS location_53, s0_.startDate AS startDate_54, s0_.endDate AS endDate_55, s0_.duration AS duration_56, s0_.status AS status_57, s0_.publishedAt AS publishedAt_58, s0_.publishedBy AS publishedBy_59, s0_.settings AS settings_60, s0_.displayStartDate AS displayStartDate_61, s0_.seoTitle AS seoTitle_62, s0_.seoKeyword AS seoKeyword_63, s0_.seoDescription AS seoDescription_64, s0_.navbar_en AS navbar_en_65, s0_.teaser_en AS teaser_en_66, s0_.content_en AS content_en_67, s0_.content_twig_en AS content_twig_en_68, s0_.post_cta_content_en AS post_cta_content_en_69, s0_.seo_title_en AS seo_title_en_70, s0_.seo_description_en AS seo_description_en_71, s0_.seo_keyword_en AS seo_keyword_en_72, s0_.has_english_version AS has_english_version_73, s0_.additional_js AS additional_js_74, s0_.metaPixelId AS metaPixelId_75, s0_.createDate AS createDate_76, s0_.lastChangeDate AS lastChangeDate_77, s0_.lastChangeUser AS lastChangeUser_78, s0_.publicId AS publicId_79, s0_.isExternalSubmission AS isExternalSubmission_80, s0_.createdBy AS createdBy_81, s0_.lastModified AS lastModified_82, s0_.createdAt AS createdAt_83, s0_.orgaNote AS orgaNote_84, s0_.calendarSyncedAt AS calendarSyncedAt_85, s0_.logisticsRoom AS logisticsRoom_86, s0_.logisticsCatering AS logisticsCatering_87, s0_.logisticsEquipment AS logisticsEquipment_88, s0_.logisticsHelpers AS logisticsHelpers_89, s0_.history AS history_90, s0_.todoHistory AS todoHistory_91 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.status = ? ORDER BY s0_.startDate DESC LIMIT 8 Parameters: [`"ai-friday" "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_.isFlagship AS isFlagship_38, s0_.capacity AS capacity_39, s0_.targetCapacity AS targetCapacity_40, s0_.twigFile AS twigFile_41, s0_.additionalCss AS additionalCss_42, s0_.content AS content_43, s0_.contentTwig AS contentTwig_44, s0_.content_blocks AS content_blocks_45, s0_.content_blocks_en AS content_blocks_en_46, s0_.ctaContent AS ctaContent_47, s0_.postCtaContent AS postCtaContent_48, s0_.tags AS tags_49, s0_.seriesTag AS seriesTag_50, s0_.feedbackFormId AS feedbackFormId_51, s0_.type AS type_52, s0_.location AS location_53, s0_.startDate AS startDate_54, s0_.endDate AS endDate_55, s0_.duration AS duration_56, s0_.status AS status_57, s0_.publishedAt AS publishedAt_58, s0_.publishedBy AS publishedBy_59, s0_.settings AS settings_60, s0_.displayStartDate AS displayStartDate_61, s0_.seoTitle AS seoTitle_62, s0_.seoKeyword AS seoKeyword_63, s0_.seoDescription AS seoDescription_64, s0_.navbar_en AS navbar_en_65, s0_.teaser_en AS teaser_en_66, s0_.content_en AS content_en_67, s0_.content_twig_en AS content_twig_en_68, s0_.post_cta_content_en AS post_cta_content_en_69, s0_.seo_title_en AS seo_title_en_70, s0_.seo_description_en AS seo_description_en_71, s0_.seo_keyword_en AS seo_keyword_en_72, s0_.has_english_version AS has_english_version_73, s0_.additional_js AS additional_js_74, s0_.metaPixelId AS metaPixelId_75, s0_.createDate AS createDate_76, s0_.lastChangeDate AS lastChangeDate_77, s0_.lastChangeUser AS lastChangeUser_78, s0_.publicId AS publicId_79, s0_.isExternalSubmission AS isExternalSubmission_80, s0_.createdBy AS createdBy_81, s0_.lastModified AS lastModified_82, s0_.createdAt AS createdAt_83, s0_.orgaNote AS orgaNote_84, s0_.calendarSyncedAt AS calendarSyncedAt_85, s0_.logisticsRoom AS logisticsRoom_86, s0_.logisticsCatering AS logisticsCatering_87, s0_.logisticsEquipment AS logisticsEquipment_88, s0_.logisticsHelpers AS logisticsHelpers_89, s0_.history AS history_90, s0_.todoHistory AS todoHistory_91 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.status = ? ORDER BY s0_.startDate DESC LIMIT 8 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_.isFlagship AS isFlagship_38, s0_.capacity AS capacity_39, s0_.targetCapacity AS targetCapacity_40, s0_.twigFile AS twigFile_41, s0_.additionalCss AS additionalCss_42, s0_.content AS content_43, s0_.contentTwig AS contentTwig_44, s0_.content_blocks AS content_blocks_45, s0_.content_blocks_en AS content_blocks_en_46, s0_.ctaContent AS ctaContent_47, s0_.postCtaContent AS postCtaContent_48, s0_.tags AS tags_49, s0_.seriesTag AS seriesTag_50, s0_.feedbackFormId AS feedbackFormId_51, s0_.type AS type_52, s0_.location AS location_53, s0_.startDate AS startDate_54, s0_.endDate AS endDate_55, s0_.duration AS duration_56, s0_.status AS status_57, s0_.publishedAt AS publishedAt_58, s0_.publishedBy AS publishedBy_59, s0_.settings AS settings_60, s0_.displayStartDate AS displayStartDate_61, s0_.seoTitle AS seoTitle_62, s0_.seoKeyword AS seoKeyword_63, s0_.seoDescription AS seoDescription_64, s0_.navbar_en AS navbar_en_65, s0_.teaser_en AS teaser_en_66, s0_.content_en AS content_en_67, s0_.content_twig_en AS content_twig_en_68, s0_.post_cta_content_en AS post_cta_content_en_69, s0_.seo_title_en AS seo_title_en_70, s0_.seo_description_en AS seo_description_en_71, s0_.seo_keyword_en AS seo_keyword_en_72, s0_.has_english_version AS has_english_version_73, s0_.additional_js AS additional_js_74, s0_.metaPixelId AS metaPixelId_75, s0_.createDate AS createDate_76, s0_.lastChangeDate AS lastChangeDate_77, s0_.lastChangeUser AS lastChangeUser_78, s0_.publicId AS publicId_79, s0_.isExternalSubmission AS isExternalSubmission_80, s0_.createdBy AS createdBy_81, s0_.lastModified AS lastModified_82, s0_.createdAt AS createdAt_83, s0_.orgaNote AS orgaNote_84, s0_.calendarSyncedAt AS calendarSyncedAt_85, s0_.logisticsRoom AS logisticsRoom_86, s0_.logisticsCatering AS logisticsCatering_87, s0_.logisticsEquipment AS logisticsEquipment_88, s0_.logisticsHelpers AS logisticsHelpers_89, s0_.history AS history_90, s0_.todoHistory AS todoHistory_91 FROM sp_event_events s0_ WHERE s0_.seriesTag = 'ai-friday' AND s0_.status = 'publish' ORDER BY s0_.startDate DESC LIMIT 8;
3	0.95 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_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = ? ORDER BY s0_.startDate ASC Parameters: [`6738`] 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_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = ? ORDER BY s0_.startDate ASC 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_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = 6738 ORDER BY s0_.startDate ASC;
4	0.68 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_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND (s0_.startDate IS NOT NULL AND s0_.startDate BETWEEN ? AND ?) AND s0_.status IN (?, ?) LIMIT 1 Parameters: [`6738 "2026-08-14 00:00:00" "2026-08-14 23:59:59" "active" "completed"`] 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_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND ( s0_.startDate IS NOT NULL AND s0_.startDate BETWEEN ? AND ? ) AND s0_.status IN (?, ?) 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_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = 6738 AND (s0_.startDate IS NOT NULL AND s0_.startDate BETWEEN '2026-08-14 00:00:00' AND '2026-08-14 23:59:59') AND s0_.status IN ('active', 'completed') LIMIT 1;
5	0.67 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_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND s0_.status = ? AND (s0_.startDate IS NOT NULL AND s0_.startDate >= ?) ORDER BY s0_.startDate ASC LIMIT 10 Parameters: [`6738 "active" "2026-08-07 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_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND s0_.status = ? AND ( s0_.startDate IS NOT NULL AND s0_.startDate >= ? ) ORDER BY s0_.startDate ASC LIMIT 10 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_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = 6738 AND s0_.status = 'active' AND (s0_.startDate IS NOT NULL AND s0_.startDate >= '2026-08-07 00:00:00') ORDER BY s0_.startDate ASC LIMIT 10;
6	0.73 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_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND (s0_.startDate IS NOT NULL AND s0_.startDate < ?) ORDER BY s0_.startDate DESC LIMIT 10 Parameters: [`6738 "2026-08-07 17:09:51"`] 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_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND ( s0_.startDate IS NOT NULL AND s0_.startDate < ? ) ORDER BY s0_.startDate DESC LIMIT 10 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_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = 6738 AND (s0_.startDate IS NOT NULL AND s0_.startDate < '2026-08-07 17:09:51') ORDER BY s0_.startDate DESC LIMIT 10;
7	0.32 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.lang AS lang_5, t0.bgImageUrl AS bgImageUrl_6, t0.mailDesignTemplate AS mailDesignTemplate_7, t0.senderMail AS senderMail_8, t0.fromName AS fromName_9, t0.recipientMonitoringMail AS recipientMonitoringMail_10, t0.confirmationMailSubject AS confirmationMailSubject_11, t0.confirmationMailContent AS confirmationMailContent_12, t0.email AS email_13, t0.landingPageContent AS landingPageContent_14, t0.template AS template_15, t0.homepage AS homepage_16, t0.visibility AS visibility_17, t0.access AS access_18, t0.hasEvent AS hasEvent_19, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_20, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_21, t0.eventId AS eventId_22, t0.zoomLink AS zoomLink_23, t0.typeformLink AS typeformLink_24, t0.mailTemplate AS mailTemplate_25, t0.mailSubject AS mailSubject_26, t0.reminderMailTemplateId AS reminderMailTemplateId_27, t0.reminderSenderEmail AS reminderSenderEmail_28, t0.phrasesDe AS phrasesDe_29, t0.phrasesEn AS phrasesEn_30, t0.settings AS settings_31, t0.createdAt AS createdAt_32, t0.lastModified AS lastModified_33, t0.lastChangeUser AS lastChangeUser_34 FROM sp_programs t0 WHERE t0.id = ? Parameters: [`27`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.lang AS lang_5, t0.bgImageUrl AS bgImageUrl_6, t0.mailDesignTemplate AS mailDesignTemplate_7, t0.senderMail AS senderMail_8, t0.fromName AS fromName_9, t0.recipientMonitoringMail AS recipientMonitoringMail_10, t0.confirmationMailSubject AS confirmationMailSubject_11, t0.confirmationMailContent AS confirmationMailContent_12, t0.email AS email_13, t0.landingPageContent AS landingPageContent_14, t0.template AS template_15, t0.homepage AS homepage_16, t0.visibility AS visibility_17, t0.access AS access_18, t0.hasEvent AS hasEvent_19, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_20, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_21, t0.eventId AS eventId_22, t0.zoomLink AS zoomLink_23, t0.typeformLink AS typeformLink_24, t0.mailTemplate AS mailTemplate_25, t0.mailSubject AS mailSubject_26, t0.reminderMailTemplateId AS reminderMailTemplateId_27, t0.reminderSenderEmail AS reminderSenderEmail_28, t0.phrasesDe AS phrasesDe_29, t0.phrasesEn AS phrasesEn_30, t0.settings AS settings_31, t0.createdAt AS createdAt_32, t0.lastModified AS lastModified_33, t0.lastChangeUser AS lastChangeUser_34 FROM sp_programs t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.lang AS lang_5, t0.bgImageUrl AS bgImageUrl_6, t0.mailDesignTemplate AS mailDesignTemplate_7, t0.senderMail AS senderMail_8, t0.fromName AS fromName_9, t0.recipientMonitoringMail AS recipientMonitoringMail_10, t0.confirmationMailSubject AS confirmationMailSubject_11, t0.confirmationMailContent AS confirmationMailContent_12, t0.email AS email_13, t0.landingPageContent AS landingPageContent_14, t0.template AS template_15, t0.homepage AS homepage_16, t0.visibility AS visibility_17, t0.access AS access_18, t0.hasEvent AS hasEvent_19, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_20, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_21, t0.eventId AS eventId_22, t0.zoomLink AS zoomLink_23, t0.typeformLink AS typeformLink_24, t0.mailTemplate AS mailTemplate_25, t0.mailSubject AS mailSubject_26, t0.reminderMailTemplateId AS reminderMailTemplateId_27, t0.reminderSenderEmail AS reminderSenderEmail_28, t0.phrasesDe AS phrasesDe_29, t0.phrasesEn AS phrasesEn_30, t0.settings AS settings_31, t0.createdAt AS createdAt_32, t0.lastModified AS lastModified_33, t0.lastChangeUser AS lastChangeUser_34 FROM sp_programs t0 WHERE t0.id = 27;
8	0.41 ms	SELECT COUNT(s0_.id) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_.eventDateId = ? AND s0_.applicationStatus = ? AND s0_.deletedAt IS NULL Parameters: [`2337 "started"`] View formatted query View runnable query Explain query SELECT COUNT(s0_.id) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_.eventDateId = ? AND s0_.applicationStatus = ? AND s0_.deletedAt IS NULL SELECT COUNT(s0_.id) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_.eventDateId = 2337 AND s0_.applicationStatus = 'started' AND s0_.deletedAt IS NULL;
9	0.34 ms	SELECT COUNT(s0_.id) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_.eventDateId = ? AND s0_.applicationStatus = ? AND s0_.deletedAt IS NULL Parameters: [`2337 "applied"`] View formatted query View runnable query Explain query SELECT COUNT(s0_.id) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_.eventDateId = ? AND s0_.applicationStatus = ? AND s0_.deletedAt IS NULL SELECT COUNT(s0_.id) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_.eventDateId = 2337 AND s0_.applicationStatus = 'applied' AND s0_.deletedAt IS NULL;
10	0.32 ms	SELECT COUNT(s0_.id) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_.eventDateId = ? AND s0_.applicationStatus = ? AND s0_.deletedAt IS NULL Parameters: [`2337 "approved"`] View formatted query View runnable query Explain query SELECT COUNT(s0_.id) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_.eventDateId = ? AND s0_.applicationStatus = ? AND s0_.deletedAt IS NULL SELECT COUNT(s0_.id) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_.eventDateId = 2337 AND s0_.applicationStatus = 'approved' AND s0_.deletedAt IS NULL;
11	0.30 ms	SELECT COUNT(s0_.id) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_.eventDateId = ? AND s0_.applicationStatus = ? AND s0_.deletedAt IS NULL Parameters: [`2337 "rejected"`] View formatted query View runnable query Explain query SELECT COUNT(s0_.id) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_.eventDateId = ? AND s0_.applicationStatus = ? AND s0_.deletedAt IS NULL SELECT COUNT(s0_.id) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_.eventDateId = 2337 AND s0_.applicationStatus = 'rejected' AND s0_.deletedAt IS NULL;
12	0.25 ms	SELECT t0.id AS id_1, t0.`key` AS key_2, t0.value AS value_3, t0.type AS type_4, t0.category AS category_5, t0.description AS description_6, t0.createdAt AS createdAt_7, t0.updatedAt AS updatedAt_8, t0.updatedBy AS updatedBy_9 FROM sp_system_config t0 WHERE t0.`key` = ? LIMIT 1 Parameters: [`"b135.auto_booking.enabled"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.`key` AS key_2, t0.value AS value_3, t0.type AS type_4, t0.category AS category_5, t0.description AS description_6, t0.createdAt AS createdAt_7, t0.updatedAt AS updatedAt_8, t0.updatedBy AS updatedBy_9 FROM sp_system_config t0 WHERE t0.`key` = ? LIMIT 1 SELECT t0.id AS id_1, t0.`key` AS key_2, t0.value AS value_3, t0.type AS type_4, t0.category AS category_5, t0.description AS description_6, t0.createdAt AS createdAt_7, t0.updatedAt AS updatedAt_8, t0.updatedBy AS updatedBy_9 FROM sp_system_config t0 WHERE t0.`key` = 'b135.auto_booking.enabled' LIMIT 1;
13	0.14 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
14	0.34 ms	UPDATE sp_event_dates SET applicationsCount = ?, startedCount = ?, appliedCount = ?, approvedCount = ?, rejectedCount = ?, lastModified = ? WHERE id = ? Parameters: [`"3" "0" "3" "0" "0" "2026-08-07 17:09:51" 2337`] View formatted query View runnable query Explain query UPDATE sp_event_dates SET applicationsCount = ?, startedCount = ?, appliedCount = ?, approvedCount = ?, rejectedCount = ?, lastModified = ? WHERE id = ? UPDATE sp_event_dates SET applicationsCount = '3', startedCount = '0', appliedCount = '3', approvedCount = '0', rejectedCount = '0', lastModified = '2026-08-07 17:09:51' WHERE id = 2337;
15	1.09 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
16	0.38 ms	SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37, t0.publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0.id = ? Parameters: [`"1164"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37, t0.publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37, t0.publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0.id = '1164';
17	0.33 ms	SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37, t0.publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0.id = ? Parameters: [`"1187"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37, t0.publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37, t0.publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0.id = '1187';
18	0.31 ms	SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37, t0.publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0.id = ? Parameters: [`"1098"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37, t0.publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37, t0.publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0.id = '1098';
19	0.56 ms	SELECT t0.id AS id_1, t0.score AS score_2, t0.completenessScore AS completenessScore_3, t0.status AS status_4, t0.location AS location_5, t0.salutation AS salutation_6, t0.title AS title_7, t0.jobTitle AS jobTitle_8, t0.firstName AS firstName_9, t0.lastName AS lastName_10, t0.name AS name_11, t0.sortName AS sortName_12, t0.email AS email_13, t0.secondaryEmail AS secondaryEmail_14, t0.phone AS phone_15, t0.hasCommunityMembership AS hasCommunityMembership_16, t0.utm_source AS utm_source_17, t0.utm_medium AS utm_medium_18, t0.utm_campaign AS utm_campaign_19, t0.utm_term AS utm_term_20, t0.utm_content AS utm_content_21, t0.birthday AS birthday_22, t0.addressFieldOne AS addressFieldOne_23, t0.addressFieldTwo AS addressFieldTwo_24, t0.addressCountryCode AS addressCountryCode_25, t0.addressPostalCode AS addressPostalCode_26, t0.addressCity AS addressCity_27, t0.teamId AS teamId_28, t0.teamName AS teamName_29, t0.company AS company_30, t0.history AS history_31, t0.tags AS tags_32, t0.annotation AS annotation_33, t0.mentorBuckets AS mentorBuckets_34, t0.areasOfExpertise AS areasOfExpertise_35, t0.mentor_firma AS mentor_firma_36, t0.mentor_firma_url AS mentor_firma_url_37, t0.mentor_locations AS mentor_locations_38, t0.mentor_profile AS mentor_profile_39, t0.mentor_note AS mentor_note_40, t0.mentor_admin_rating AS mentor_admin_rating_41, t0.active AS active_42, t0.tiefgarage AS tiefgarage_43, t0.transponder AS transponder_44, t0.isTransponderAllowed AS isTransponderAllowed_45, t0.imageLink AS imageLink_46, t0.homepage AS homepage_47, t0.xing AS xing_48, t0.pipedriveId AS pipedriveId_49, t0.linkedin AS linkedin_50, t0.facebook AS facebook_51, t0.instagram AS instagram_52, t0.tiktok AS tiktok_53, t0.threads AS threads_54, t0.youtube AS youtube_55, t0.twitter AS twitter_56, t0.github AS github_57, t0.reachableLocation AS reachableLocation_58, t0.skills AS skills_59, t0.description AS description_60, t0.isVisibleInNetworking AS isVisibleInNetworking_61, t0.gender AS gender_62, t0.currentFocus AS currentFocus_63, t0.networkingConsentAt AS networkingConsentAt_64, t0.networkingConsentVersion AS networkingConsentVersion_65, t0.networkingConsentRevokedAt AS networkingConsentRevokedAt_66, t0.touchpoints AS touchpoints_67, t0.isAddressComplete AS isAddressComplete_68, t0.hasMailchimp AS hasMailchimp_69, t0.hasKiNewsletter AS hasKiNewsletter_70, t0.hubspotSyncPending AS hubspotSyncPending_71, t0.enterDate AS enterDate_72, t0.exitDate AS exitDate_73, t0.physicalMembershipStarted AS physicalMembershipStarted_74, t0.physicalMembershipEnded AS physicalMembershipEnded_75, t0.lastModified AS lastModified_76, t0.lastChangeUser AS lastChangeUser_77, t0.onboardingCompletedAt AS onboardingCompletedAt_78, t0.nAiWebinarsAttended AS nAiWebinarsAttended_79, t0.nAiWebinarsApplied AS nAiWebinarsApplied_80, t0.nAiEventsAttended AS nAiEventsAttended_81, t0.nAiEventsApplied AS nAiEventsApplied_82, t0.nPaidAttended AS nPaidAttended_83, t0.nPaidApplied AS nPaidApplied_84, t0.nKiEinstiegAttended AS nKiEinstiegAttended_85, t0.nKiEinstiegApplied AS nKiEinstiegApplied_86, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_87, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_88, t0.nEcodynamicsAttended AS nEcodynamicsAttended_89, t0.nEcodynamicsApplied AS nEcodynamicsApplied_90, t0.nBbqApplied AS nBbqApplied_91, t0.nAiFridayApplied AS nAiFridayApplied_92, t0.nAiGatheringApplied AS nAiGatheringApplied_93, t0.nAiGatheringAttended AS nAiGatheringAttended_94, t0.aiSs24Applied AS aiSs24Applied_95, t0.aiSs24Booked AS aiSs24Booked_96, t0.interestedIn AS interestedIn_97, t0.interests AS interests_98, t0.mentorMetadata AS mentorMetadata_99, t0.eventParticipations AS eventParticipations_100, t0.kiKompetenz AS kiKompetenz_101, t0.mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0.id = ? Parameters: [`"80488"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.score AS score_2, t0.completenessScore AS completenessScore_3, t0.status AS status_4, t0.location AS location_5, t0.salutation AS salutation_6, t0.title AS title_7, t0.jobTitle AS jobTitle_8, t0.firstName AS firstName_9, t0.lastName AS lastName_10, t0.name AS name_11, t0.sortName AS sortName_12, t0.email AS email_13, t0.secondaryEmail AS secondaryEmail_14, t0.phone AS phone_15, t0.hasCommunityMembership AS hasCommunityMembership_16, t0.utm_source AS utm_source_17, t0.utm_medium AS utm_medium_18, t0.utm_campaign AS utm_campaign_19, t0.utm_term AS utm_term_20, t0.utm_content AS utm_content_21, t0.birthday AS birthday_22, t0.addressFieldOne AS addressFieldOne_23, t0.addressFieldTwo AS addressFieldTwo_24, t0.addressCountryCode AS addressCountryCode_25, t0.addressPostalCode AS addressPostalCode_26, t0.addressCity AS addressCity_27, t0.teamId AS teamId_28, t0.teamName AS teamName_29, t0.company AS company_30, t0.history AS history_31, t0.tags AS tags_32, t0.annotation AS annotation_33, t0.mentorBuckets AS mentorBuckets_34, t0.areasOfExpertise AS areasOfExpertise_35, t0.mentor_firma AS mentor_firma_36, t0.mentor_firma_url AS mentor_firma_url_37, t0.mentor_locations AS mentor_locations_38, t0.mentor_profile AS mentor_profile_39, t0.mentor_note AS mentor_note_40, t0.mentor_admin_rating AS mentor_admin_rating_41, t0.active AS active_42, t0.tiefgarage AS tiefgarage_43, t0.transponder AS transponder_44, t0.isTransponderAllowed AS isTransponderAllowed_45, t0.imageLink AS imageLink_46, t0.homepage AS homepage_47, t0.xing AS xing_48, t0.pipedriveId AS pipedriveId_49, t0.linkedin AS linkedin_50, t0.facebook AS facebook_51, t0.instagram AS instagram_52, t0.tiktok AS tiktok_53, t0.threads AS threads_54, t0.youtube AS youtube_55, t0.twitter AS twitter_56, t0.github AS github_57, t0.reachableLocation AS reachableLocation_58, t0.skills AS skills_59, t0.description AS description_60, t0.isVisibleInNetworking AS isVisibleInNetworking_61, t0.gender AS gender_62, t0.currentFocus AS currentFocus_63, t0.networkingConsentAt AS networkingConsentAt_64, t0.networkingConsentVersion AS networkingConsentVersion_65, t0.networkingConsentRevokedAt AS networkingConsentRevokedAt_66, t0.touchpoints AS touchpoints_67, t0.isAddressComplete AS isAddressComplete_68, t0.hasMailchimp AS hasMailchimp_69, t0.hasKiNewsletter AS hasKiNewsletter_70, t0.hubspotSyncPending AS hubspotSyncPending_71, t0.enterDate AS enterDate_72, t0.exitDate AS exitDate_73, t0.physicalMembershipStarted AS physicalMembershipStarted_74, t0.physicalMembershipEnded AS physicalMembershipEnded_75, t0.lastModified AS lastModified_76, t0.lastChangeUser AS lastChangeUser_77, t0.onboardingCompletedAt AS onboardingCompletedAt_78, t0.nAiWebinarsAttended AS nAiWebinarsAttended_79, t0.nAiWebinarsApplied AS nAiWebinarsApplied_80, t0.nAiEventsAttended AS nAiEventsAttended_81, t0.nAiEventsApplied AS nAiEventsApplied_82, t0.nPaidAttended AS nPaidAttended_83, t0.nPaidApplied AS nPaidApplied_84, t0.nKiEinstiegAttended AS nKiEinstiegAttended_85, t0.nKiEinstiegApplied AS nKiEinstiegApplied_86, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_87, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_88, t0.nEcodynamicsAttended AS nEcodynamicsAttended_89, t0.nEcodynamicsApplied AS nEcodynamicsApplied_90, t0.nBbqApplied AS nBbqApplied_91, t0.nAiFridayApplied AS nAiFridayApplied_92, t0.nAiGatheringApplied AS nAiGatheringApplied_93, t0.nAiGatheringAttended AS nAiGatheringAttended_94, t0.aiSs24Applied AS aiSs24Applied_95, t0.aiSs24Booked AS aiSs24Booked_96, t0.interestedIn AS interestedIn_97, t0.interests AS interests_98, t0.mentorMetadata AS mentorMetadata_99, t0.eventParticipations AS eventParticipations_100, t0.kiKompetenz AS kiKompetenz_101, t0.mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.score AS score_2, t0.completenessScore AS completenessScore_3, t0.status AS status_4, t0.location AS location_5, t0.salutation AS salutation_6, t0.title AS title_7, t0.jobTitle AS jobTitle_8, t0.firstName AS firstName_9, t0.lastName AS lastName_10, t0.name AS name_11, t0.sortName AS sortName_12, t0.email AS email_13, t0.secondaryEmail AS secondaryEmail_14, t0.phone AS phone_15, t0.hasCommunityMembership AS hasCommunityMembership_16, t0.utm_source AS utm_source_17, t0.utm_medium AS utm_medium_18, t0.utm_campaign AS utm_campaign_19, t0.utm_term AS utm_term_20, t0.utm_content AS utm_content_21, t0.birthday AS birthday_22, t0.addressFieldOne AS addressFieldOne_23, t0.addressFieldTwo AS addressFieldTwo_24, t0.addressCountryCode AS addressCountryCode_25, t0.addressPostalCode AS addressPostalCode_26, t0.addressCity AS addressCity_27, t0.teamId AS teamId_28, t0.teamName AS teamName_29, t0.company AS company_30, t0.history AS history_31, t0.tags AS tags_32, t0.annotation AS annotation_33, t0.mentorBuckets AS mentorBuckets_34, t0.areasOfExpertise AS areasOfExpertise_35, t0.mentor_firma AS mentor_firma_36, t0.mentor_firma_url AS mentor_firma_url_37, t0.mentor_locations AS mentor_locations_38, t0.mentor_profile AS mentor_profile_39, t0.mentor_note AS mentor_note_40, t0.mentor_admin_rating AS mentor_admin_rating_41, t0.active AS active_42, t0.tiefgarage AS tiefgarage_43, t0.transponder AS transponder_44, t0.isTransponderAllowed AS isTransponderAllowed_45, t0.imageLink AS imageLink_46, t0.homepage AS homepage_47, t0.xing AS xing_48, t0.pipedriveId AS pipedriveId_49, t0.linkedin AS linkedin_50, t0.facebook AS facebook_51, t0.instagram AS instagram_52, t0.tiktok AS tiktok_53, t0.threads AS threads_54, t0.youtube AS youtube_55, t0.twitter AS twitter_56, t0.github AS github_57, t0.reachableLocation AS reachableLocation_58, t0.skills AS skills_59, t0.description AS description_60, t0.isVisibleInNetworking AS isVisibleInNetworking_61, t0.gender AS gender_62, t0.currentFocus AS currentFocus_63, t0.networkingConsentAt AS networkingConsentAt_64, t0.networkingConsentVersion AS networkingConsentVersion_65, t0.networkingConsentRevokedAt AS networkingConsentRevokedAt_66, t0.touchpoints AS touchpoints_67, t0.isAddressComplete AS isAddressComplete_68, t0.hasMailchimp AS hasMailchimp_69, t0.hasKiNewsletter AS hasKiNewsletter_70, t0.hubspotSyncPending AS hubspotSyncPending_71, t0.enterDate AS enterDate_72, t0.exitDate AS exitDate_73, t0.physicalMembershipStarted AS physicalMembershipStarted_74, t0.physicalMembershipEnded AS physicalMembershipEnded_75, t0.lastModified AS lastModified_76, t0.lastChangeUser AS lastChangeUser_77, t0.onboardingCompletedAt AS onboardingCompletedAt_78, t0.nAiWebinarsAttended AS nAiWebinarsAttended_79, t0.nAiWebinarsApplied AS nAiWebinarsApplied_80, t0.nAiEventsAttended AS nAiEventsAttended_81, t0.nAiEventsApplied AS nAiEventsApplied_82, t0.nPaidAttended AS nPaidAttended_83, t0.nPaidApplied AS nPaidApplied_84, t0.nKiEinstiegAttended AS nKiEinstiegAttended_85, t0.nKiEinstiegApplied AS nKiEinstiegApplied_86, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_87, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_88, t0.nEcodynamicsAttended AS nEcodynamicsAttended_89, t0.nEcodynamicsApplied AS nEcodynamicsApplied_90, t0.nBbqApplied AS nBbqApplied_91, t0.nAiFridayApplied AS nAiFridayApplied_92, t0.nAiGatheringApplied AS nAiGatheringApplied_93, t0.nAiGatheringAttended AS nAiGatheringAttended_94, t0.aiSs24Applied AS aiSs24Applied_95, t0.aiSs24Booked AS aiSs24Booked_96, t0.interestedIn AS interestedIn_97, t0.interests AS interests_98, t0.mentorMetadata AS mentorMetadata_99, t0.eventParticipations AS eventParticipations_100, t0.kiKompetenz AS kiKompetenz_101, t0.mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0.id = '80488';
20	0.49 ms	SELECT t0.id AS id_1, t0.score AS score_2, t0.completenessScore AS completenessScore_3, t0.status AS status_4, t0.location AS location_5, t0.salutation AS salutation_6, t0.title AS title_7, t0.jobTitle AS jobTitle_8, t0.firstName AS firstName_9, t0.lastName AS lastName_10, t0.name AS name_11, t0.sortName AS sortName_12, t0.email AS email_13, t0.secondaryEmail AS secondaryEmail_14, t0.phone AS phone_15, t0.hasCommunityMembership AS hasCommunityMembership_16, t0.utm_source AS utm_source_17, t0.utm_medium AS utm_medium_18, t0.utm_campaign AS utm_campaign_19, t0.utm_term AS utm_term_20, t0.utm_content AS utm_content_21, t0.birthday AS birthday_22, t0.addressFieldOne AS addressFieldOne_23, t0.addressFieldTwo AS addressFieldTwo_24, t0.addressCountryCode AS addressCountryCode_25, t0.addressPostalCode AS addressPostalCode_26, t0.addressCity AS addressCity_27, t0.teamId AS teamId_28, t0.teamName AS teamName_29, t0.company AS company_30, t0.history AS history_31, t0.tags AS tags_32, t0.annotation AS annotation_33, t0.mentorBuckets AS mentorBuckets_34, t0.areasOfExpertise AS areasOfExpertise_35, t0.mentor_firma AS mentor_firma_36, t0.mentor_firma_url AS mentor_firma_url_37, t0.mentor_locations AS mentor_locations_38, t0.mentor_profile AS mentor_profile_39, t0.mentor_note AS mentor_note_40, t0.mentor_admin_rating AS mentor_admin_rating_41, t0.active AS active_42, t0.tiefgarage AS tiefgarage_43, t0.transponder AS transponder_44, t0.isTransponderAllowed AS isTransponderAllowed_45, t0.imageLink AS imageLink_46, t0.homepage AS homepage_47, t0.xing AS xing_48, t0.pipedriveId AS pipedriveId_49, t0.linkedin AS linkedin_50, t0.facebook AS facebook_51, t0.instagram AS instagram_52, t0.tiktok AS tiktok_53, t0.threads AS threads_54, t0.youtube AS youtube_55, t0.twitter AS twitter_56, t0.github AS github_57, t0.reachableLocation AS reachableLocation_58, t0.skills AS skills_59, t0.description AS description_60, t0.isVisibleInNetworking AS isVisibleInNetworking_61, t0.gender AS gender_62, t0.currentFocus AS currentFocus_63, t0.networkingConsentAt AS networkingConsentAt_64, t0.networkingConsentVersion AS networkingConsentVersion_65, t0.networkingConsentRevokedAt AS networkingConsentRevokedAt_66, t0.touchpoints AS touchpoints_67, t0.isAddressComplete AS isAddressComplete_68, t0.hasMailchimp AS hasMailchimp_69, t0.hasKiNewsletter AS hasKiNewsletter_70, t0.hubspotSyncPending AS hubspotSyncPending_71, t0.enterDate AS enterDate_72, t0.exitDate AS exitDate_73, t0.physicalMembershipStarted AS physicalMembershipStarted_74, t0.physicalMembershipEnded AS physicalMembershipEnded_75, t0.lastModified AS lastModified_76, t0.lastChangeUser AS lastChangeUser_77, t0.onboardingCompletedAt AS onboardingCompletedAt_78, t0.nAiWebinarsAttended AS nAiWebinarsAttended_79, t0.nAiWebinarsApplied AS nAiWebinarsApplied_80, t0.nAiEventsAttended AS nAiEventsAttended_81, t0.nAiEventsApplied AS nAiEventsApplied_82, t0.nPaidAttended AS nPaidAttended_83, t0.nPaidApplied AS nPaidApplied_84, t0.nKiEinstiegAttended AS nKiEinstiegAttended_85, t0.nKiEinstiegApplied AS nKiEinstiegApplied_86, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_87, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_88, t0.nEcodynamicsAttended AS nEcodynamicsAttended_89, t0.nEcodynamicsApplied AS nEcodynamicsApplied_90, t0.nBbqApplied AS nBbqApplied_91, t0.nAiFridayApplied AS nAiFridayApplied_92, t0.nAiGatheringApplied AS nAiGatheringApplied_93, t0.nAiGatheringAttended AS nAiGatheringAttended_94, t0.aiSs24Applied AS aiSs24Applied_95, t0.aiSs24Booked AS aiSs24Booked_96, t0.interestedIn AS interestedIn_97, t0.interests AS interests_98, t0.mentorMetadata AS mentorMetadata_99, t0.eventParticipations AS eventParticipations_100, t0.kiKompetenz AS kiKompetenz_101, t0.mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0.id = ? Parameters: [`"92602"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.score AS score_2, t0.completenessScore AS completenessScore_3, t0.status AS status_4, t0.location AS location_5, t0.salutation AS salutation_6, t0.title AS title_7, t0.jobTitle AS jobTitle_8, t0.firstName AS firstName_9, t0.lastName AS lastName_10, t0.name AS name_11, t0.sortName AS sortName_12, t0.email AS email_13, t0.secondaryEmail AS secondaryEmail_14, t0.phone AS phone_15, t0.hasCommunityMembership AS hasCommunityMembership_16, t0.utm_source AS utm_source_17, t0.utm_medium AS utm_medium_18, t0.utm_campaign AS utm_campaign_19, t0.utm_term AS utm_term_20, t0.utm_content AS utm_content_21, t0.birthday AS birthday_22, t0.addressFieldOne AS addressFieldOne_23, t0.addressFieldTwo AS addressFieldTwo_24, t0.addressCountryCode AS addressCountryCode_25, t0.addressPostalCode AS addressPostalCode_26, t0.addressCity AS addressCity_27, t0.teamId AS teamId_28, t0.teamName AS teamName_29, t0.company AS company_30, t0.history AS history_31, t0.tags AS tags_32, t0.annotation AS annotation_33, t0.mentorBuckets AS mentorBuckets_34, t0.areasOfExpertise AS areasOfExpertise_35, t0.mentor_firma AS mentor_firma_36, t0.mentor_firma_url AS mentor_firma_url_37, t0.mentor_locations AS mentor_locations_38, t0.mentor_profile AS mentor_profile_39, t0.mentor_note AS mentor_note_40, t0.mentor_admin_rating AS mentor_admin_rating_41, t0.active AS active_42, t0.tiefgarage AS tiefgarage_43, t0.transponder AS transponder_44, t0.isTransponderAllowed AS isTransponderAllowed_45, t0.imageLink AS imageLink_46, t0.homepage AS homepage_47, t0.xing AS xing_48, t0.pipedriveId AS pipedriveId_49, t0.linkedin AS linkedin_50, t0.facebook AS facebook_51, t0.instagram AS instagram_52, t0.tiktok AS tiktok_53, t0.threads AS threads_54, t0.youtube AS youtube_55, t0.twitter AS twitter_56, t0.github AS github_57, t0.reachableLocation AS reachableLocation_58, t0.skills AS skills_59, t0.description AS description_60, t0.isVisibleInNetworking AS isVisibleInNetworking_61, t0.gender AS gender_62, t0.currentFocus AS currentFocus_63, t0.networkingConsentAt AS networkingConsentAt_64, t0.networkingConsentVersion AS networkingConsentVersion_65, t0.networkingConsentRevokedAt AS networkingConsentRevokedAt_66, t0.touchpoints AS touchpoints_67, t0.isAddressComplete AS isAddressComplete_68, t0.hasMailchimp AS hasMailchimp_69, t0.hasKiNewsletter AS hasKiNewsletter_70, t0.hubspotSyncPending AS hubspotSyncPending_71, t0.enterDate AS enterDate_72, t0.exitDate AS exitDate_73, t0.physicalMembershipStarted AS physicalMembershipStarted_74, t0.physicalMembershipEnded AS physicalMembershipEnded_75, t0.lastModified AS lastModified_76, t0.lastChangeUser AS lastChangeUser_77, t0.onboardingCompletedAt AS onboardingCompletedAt_78, t0.nAiWebinarsAttended AS nAiWebinarsAttended_79, t0.nAiWebinarsApplied AS nAiWebinarsApplied_80, t0.nAiEventsAttended AS nAiEventsAttended_81, t0.nAiEventsApplied AS nAiEventsApplied_82, t0.nPaidAttended AS nPaidAttended_83, t0.nPaidApplied AS nPaidApplied_84, t0.nKiEinstiegAttended AS nKiEinstiegAttended_85, t0.nKiEinstiegApplied AS nKiEinstiegApplied_86, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_87, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_88, t0.nEcodynamicsAttended AS nEcodynamicsAttended_89, t0.nEcodynamicsApplied AS nEcodynamicsApplied_90, t0.nBbqApplied AS nBbqApplied_91, t0.nAiFridayApplied AS nAiFridayApplied_92, t0.nAiGatheringApplied AS nAiGatheringApplied_93, t0.nAiGatheringAttended AS nAiGatheringAttended_94, t0.aiSs24Applied AS aiSs24Applied_95, t0.aiSs24Booked AS aiSs24Booked_96, t0.interestedIn AS interestedIn_97, t0.interests AS interests_98, t0.mentorMetadata AS mentorMetadata_99, t0.eventParticipations AS eventParticipations_100, t0.kiKompetenz AS kiKompetenz_101, t0.mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.score AS score_2, t0.completenessScore AS completenessScore_3, t0.status AS status_4, t0.location AS location_5, t0.salutation AS salutation_6, t0.title AS title_7, t0.jobTitle AS jobTitle_8, t0.firstName AS firstName_9, t0.lastName AS lastName_10, t0.name AS name_11, t0.sortName AS sortName_12, t0.email AS email_13, t0.secondaryEmail AS secondaryEmail_14, t0.phone AS phone_15, t0.hasCommunityMembership AS hasCommunityMembership_16, t0.utm_source AS utm_source_17, t0.utm_medium AS utm_medium_18, t0.utm_campaign AS utm_campaign_19, t0.utm_term AS utm_term_20, t0.utm_content AS utm_content_21, t0.birthday AS birthday_22, t0.addressFieldOne AS addressFieldOne_23, t0.addressFieldTwo AS addressFieldTwo_24, t0.addressCountryCode AS addressCountryCode_25, t0.addressPostalCode AS addressPostalCode_26, t0.addressCity AS addressCity_27, t0.teamId AS teamId_28, t0.teamName AS teamName_29, t0.company AS company_30, t0.history AS history_31, t0.tags AS tags_32, t0.annotation AS annotation_33, t0.mentorBuckets AS mentorBuckets_34, t0.areasOfExpertise AS areasOfExpertise_35, t0.mentor_firma AS mentor_firma_36, t0.mentor_firma_url AS mentor_firma_url_37, t0.mentor_locations AS mentor_locations_38, t0.mentor_profile AS mentor_profile_39, t0.mentor_note AS mentor_note_40, t0.mentor_admin_rating AS mentor_admin_rating_41, t0.active AS active_42, t0.tiefgarage AS tiefgarage_43, t0.transponder AS transponder_44, t0.isTransponderAllowed AS isTransponderAllowed_45, t0.imageLink AS imageLink_46, t0.homepage AS homepage_47, t0.xing AS xing_48, t0.pipedriveId AS pipedriveId_49, t0.linkedin AS linkedin_50, t0.facebook AS facebook_51, t0.instagram AS instagram_52, t0.tiktok AS tiktok_53, t0.threads AS threads_54, t0.youtube AS youtube_55, t0.twitter AS twitter_56, t0.github AS github_57, t0.reachableLocation AS reachableLocation_58, t0.skills AS skills_59, t0.description AS description_60, t0.isVisibleInNetworking AS isVisibleInNetworking_61, t0.gender AS gender_62, t0.currentFocus AS currentFocus_63, t0.networkingConsentAt AS networkingConsentAt_64, t0.networkingConsentVersion AS networkingConsentVersion_65, t0.networkingConsentRevokedAt AS networkingConsentRevokedAt_66, t0.touchpoints AS touchpoints_67, t0.isAddressComplete AS isAddressComplete_68, t0.hasMailchimp AS hasMailchimp_69, t0.hasKiNewsletter AS hasKiNewsletter_70, t0.hubspotSyncPending AS hubspotSyncPending_71, t0.enterDate AS enterDate_72, t0.exitDate AS exitDate_73, t0.physicalMembershipStarted AS physicalMembershipStarted_74, t0.physicalMembershipEnded AS physicalMembershipEnded_75, t0.lastModified AS lastModified_76, t0.lastChangeUser AS lastChangeUser_77, t0.onboardingCompletedAt AS onboardingCompletedAt_78, t0.nAiWebinarsAttended AS nAiWebinarsAttended_79, t0.nAiWebinarsApplied AS nAiWebinarsApplied_80, t0.nAiEventsAttended AS nAiEventsAttended_81, t0.nAiEventsApplied AS nAiEventsApplied_82, t0.nPaidAttended AS nPaidAttended_83, t0.nPaidApplied AS nPaidApplied_84, t0.nKiEinstiegAttended AS nKiEinstiegAttended_85, t0.nKiEinstiegApplied AS nKiEinstiegApplied_86, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_87, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_88, t0.nEcodynamicsAttended AS nEcodynamicsAttended_89, t0.nEcodynamicsApplied AS nEcodynamicsApplied_90, t0.nBbqApplied AS nBbqApplied_91, t0.nAiFridayApplied AS nAiFridayApplied_92, t0.nAiGatheringApplied AS nAiGatheringApplied_93, t0.nAiGatheringAttended AS nAiGatheringAttended_94, t0.aiSs24Applied AS aiSs24Applied_95, t0.aiSs24Booked AS aiSs24Booked_96, t0.interestedIn AS interestedIn_97, t0.interests AS interests_98, t0.mentorMetadata AS mentorMetadata_99, t0.eventParticipations AS eventParticipations_100, t0.kiKompetenz AS kiKompetenz_101, t0.mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0.id = '92602';
21	0.36 ms	SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.eventDateId AS eventDateId_2, s0_.mentorId AS mentorId_3, s0_.position AS position_4, s0_.durationMinutes AS durationMinutes_5, s0_.role AS role_6, s0_.status AS status_7, s0_.source AS source_8, s0_.talkTitle AS talkTitle_9, s0_.description AS description_10, s0_.contactName AS contactName_11, s0_.contactEmail AS contactEmail_12, s0_.contactCompany AS contactCompany_13, s0_.contactLinkedin AS contactLinkedin_14, s0_.publicVisible AS publicVisible_15, s0_.adminNote AS adminNote_16, s0_.respondedAt AS respondedAt_17, s0_.createdAt AS createdAt_18, s0_.updatedAt AS updatedAt_19 FROM sp_event_program_slots s0_ WHERE s0_.eventId IN (?) AND s0_.publicVisible = 1 AND s0_.status = ? ORDER BY s0_.position ASC, s0_.id ASC Parameters: [`6738 "confirmed"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.eventDateId AS eventDateId_2, s0_.mentorId AS mentorId_3, s0_.position AS position_4, s0_.durationMinutes AS durationMinutes_5, s0_.role AS role_6, s0_.status AS status_7, s0_.source AS source_8, s0_.talkTitle AS talkTitle_9, s0_.description AS description_10, s0_.contactName AS contactName_11, s0_.contactEmail AS contactEmail_12, s0_.contactCompany AS contactCompany_13, s0_.contactLinkedin AS contactLinkedin_14, s0_.publicVisible AS publicVisible_15, s0_.adminNote AS adminNote_16, s0_.respondedAt AS respondedAt_17, s0_.createdAt AS createdAt_18, s0_.updatedAt AS updatedAt_19 FROM sp_event_program_slots s0_ WHERE s0_.eventId IN (?) AND s0_.publicVisible = 1 AND s0_.status = ? ORDER BY s0_.position ASC, s0_.id ASC SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.eventDateId AS eventDateId_2, s0_.mentorId AS mentorId_3, s0_.position AS position_4, s0_.durationMinutes AS durationMinutes_5, s0_.role AS role_6, s0_.status AS status_7, s0_.source AS source_8, s0_.talkTitle AS talkTitle_9, s0_.description AS description_10, s0_.contactName AS contactName_11, s0_.contactEmail AS contactEmail_12, s0_.contactCompany AS contactCompany_13, s0_.contactLinkedin AS contactLinkedin_14, s0_.publicVisible AS publicVisible_15, s0_.adminNote AS adminNote_16, s0_.respondedAt AS respondedAt_17, s0_.createdAt AS createdAt_18, s0_.updatedAt AS updatedAt_19 FROM sp_event_program_slots s0_ WHERE s0_.eventId IN (6738) AND s0_.publicVisible = 1 AND s0_.status = 'confirmed' ORDER BY s0_.position ASC, s0_.id ASC;
22	0.30 ms	SELECT s0_.eventId AS eventId_0, s0_.eventDateId AS eventDateId_1, COUNT(s0_.id) AS sclr_2 FROM sp_event_program_slots s0_ WHERE s0_.eventId IN (?) AND s0_.status = ? GROUP BY s0_.eventId, s0_.eventDateId Parameters: [`6738 "requested"`] View formatted query View runnable query Explain query SELECT s0_.eventId AS eventId_0, s0_.eventDateId AS eventDateId_1, COUNT(s0_.id) AS sclr_2 FROM sp_event_program_slots s0_ WHERE s0_.eventId IN (?) AND s0_.status = ? GROUP BY s0_.eventId, s0_.eventDateId SELECT s0_.eventId AS eventId_0, s0_.eventDateId AS eventDateId_1, COUNT(s0_.id) AS sclr_2 FROM sp_event_program_slots s0_ WHERE s0_.eventId IN (6738) AND s0_.status = 'requested' GROUP BY s0_.eventId, s0_.eventDateId;
23	0.25 ms	SELECT t0.id AS id_1, t0.metaname AS metaname_2, t0.label AS label_3, t0.metavalue AS metavalue_4, t0.lastModified AS lastModified_5 FROM sp_member_options t0 WHERE t0.metaname = ? LIMIT 1 Parameters: [`"sp.phrases.application.de"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.metaname AS metaname_2, t0.label AS label_3, t0.metavalue AS metavalue_4, t0.lastModified AS lastModified_5 FROM sp_member_options t0 WHERE t0.metaname = ? LIMIT 1 SELECT t0.id AS id_1, t0.metaname AS metaname_2, t0.label AS label_3, t0.metavalue AS metavalue_4, t0.lastModified AS lastModified_5 FROM sp_member_options t0 WHERE t0.metaname = 'sp.phrases.application.de' LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\StartPlatz\Bundle\EventBundle\Entity\EventDate	16
App\StartPlatz\Bundle\EventBundle\Entity\Event	8
App\StartPlatz\Bundle\AlphaBundle\Entity\Page	3
App\StartPlatz\Bundle\MemberBundle\Entity\Member	2
App\StartPlatz\Bundle\StartupBundle\Entity\Program	1
App\StartPlatz\Ecosystem\Config\Runtime\Entity\ConfigSetting	1
App\StartPlatz\Bundle\MemberBundle\Entity\Option	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.
App\StartPlatz\Bundle\StartupBundle\Entity\Program	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Batch	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Application	No errors.
App\StartPlatz\Bundle\EventBundle\Entity\EventRegistration	No errors.
App\StartPlatz\Ecosystem\Config\Runtime\Entity\ConfigSetting	No errors.
App\StartPlatz\Bundle\AlphaBundle\Entity\Page	No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\Member	No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\MemberTeam	No errors.
App\StartPlatz\Bundle\EventBundle\Entity\EventProgramSlot	No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\Option	No errors.

Symfony Profiler

GET https://www.staging.startplatz.de/event/ai-friday-ki-community-meetup-duesseldorf/2026-08-14?tag=ai-friday

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping