Symfony Profiler

Query Metrics

12 Database Queries

10 Different statements

20.47 ms Query time

0 Invalid entities

6 Managed entities

Queries


SELECT t0.id AS id_1, t0.extId AS extId_2, t0.visibility AS visibility_3, t0.score AS score_4, t0.name AS name_5, t0.teamId AS teamId_6, t0.website AS website_7, t0.domain AS domain_8, t0.slug AS slug_9, t0.status AS status_10, t0.editStatus AS editStatus_11, t0.stage AS stage_12, t0.source AS source_13, t0.runway AS runway_14, t0.fundingSinceProgram AS fundingSinceProgram_15, t0.partnerTags AS partnerTags_16, t0.lastCheckDate AS lastCheckDate_17, t0.alumniStatus AS alumniStatus_18, t0.logoUrl AS logoUrl_19, t0.logoBackground AS logoBackground_20, t0.imageLink AS imageLink_21, t0.currentPitchDeckUrl AS currentPitchDeckUrl_22, t0.kiAccelerator AS kiAccelerator_23, t0.todos AS todos_24, t0.industry AS industry_25, t0.industryCondensed AS industryCondensed_26, t0.customerFocus AS customerFocus_27, t0.BusinessModel AS BusinessModel_28, t0.tags AS tags_29, t0.oneSentencePitch AS oneSentencePitch_30, t0.oneSentencePitchEn AS oneSentencePitchEn_31, t0.foundationYear AS foundationYear_32, t0.location AS location_33, t0.city AS city_34, t0.employeesCount AS employeesCount_35, t0.funding AS funding_36, t0.investors AS investors_37, t0.revenue AS revenue_38, t0.contactPerson AS contactPerson_39, t0.contactEmail AS contactEmail_40, t0.contactTelefon AS contactTelefon_41, t0.xing AS xing_42, t0.linkedin AS linkedin_43, t0.facebook AS facebook_44, t0.twitter AS twitter_45, t0.instagram AS instagram_46, t0.tiktok AS tiktok_47, t0.threads AS threads_48, t0.youtube AS youtube_49, t0.description AS description_50, t0.publicDetailHtml AS publicDetailHtml_51, t0.publicDetailHtmlEn AS publicDetailHtmlEn_52, t0.internalDetailHtml AS internalDetailHtml_53, t0.internalDetailHtmlEn AS internalDetailHtmlEn_54, t0.gsPublicSummary AS gsPublicSummary_55, t0.gsIndustries AS gsIndustries_56, t0.gsKeywords AS gsKeywords_57, t0.gsProfile AS gsProfile_58, t0.comments AS comments_59, t0.history AS history_60, t0.lastChangeUser AS lastChangeUser_61, t0.createdAt AS createdAt_62, t0.lastModified AS lastModified_63, t0.lastChangedBy AS lastChangedBy_64 FROM sp_startup_profiles t0 WHERE t0.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.startupId AS startupId_2, t0.location AS location_3, t0.locationSecond AS locationSecond_4, t0.name AS name_5, t0.shortName AS shortName_6, t0.previousName AS previousName_7, t0.person AS person_8, t0.phone AS phone_9, t0.addressFieldOne AS addressFieldOne_10, t0.addressFieldTwo AS addressFieldTwo_11, t0.addressCountryCode AS addressCountryCode_12, t0.addressPostalCode AS addressPostalCode_13, t0.addressCity AS addressCity_14, t0.spTeamId AS spTeamId_15, t0.accountEmail AS accountEmail_16, t0.connectEmail AS connectEmail_17, t0.status AS status_18, t0.hasCommunityMembership AS hasCommunityMembership_19, t0.isTransponderAllowed AS isTransponderAllowed_20, t0.jobPostingEnabled AS jobPostingEnabled_21, t0.jobPostingNoExpiry AS jobPostingNoExpiry_22, t0.jobCompanyType AS jobCompanyType_23, t0.hasStartupMembership AS hasStartupMembership_24, t0.isIncludeInUpdateType AS isIncludeInUpdateType_25, t0.isCompany AS isCompany_26, t0.isAddressComplete AS isAddressComplete_27, t0.isDebitor AS isDebitor_28, t0.type AS type_29, t0.internalDescription AS internalDescription_30, t0.monsumCustomerType AS monsumCustomerType_31, t0.homepage AS homepage_32, t0.logoURL AS logoURL_33, t0.industries AS industries_34, t0.description AS description_35, t0.note AS note_36, t0.tags AS tags_37, t0.categories AS categories_38, t0.alertNote AS alertNote_39, t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_40, t0.monthlyExtraBudget AS monthlyExtraBudget_41, t0.sameDayBudget AS sameDayBudget_42, t0.sameDayBudgetUsed AS sameDayBudgetUsed_43, t0.sameDayExtraBudget AS sameDayExtraBudget_44, t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_45, t0.communityBudget AS communityBudget_46, t0.communityBudgetUsed AS communityBudgetUsed_47, t0.meetingRoomsBudget AS meetingRoomsBudget_48, t0.conferenceRoomsBudget AS conferenceRoomsBudget_49, t0.coffeeCoinsBudget AS coffeeCoinsBudget_50, t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_51, t0.meetingRoomsBooked AS meetingRoomsBooked_52, t0.conferenceRoomsBooked AS conferenceRoomsBooked_53, t0.todayRoomsBooked AS todayRoomsBooked_54, t0.nDedicatedDesks AS nDedicatedDesks_55, t0.nFlexibleDesks AS nFlexibleDesks_56, t0.nBasicMemberships AS nBasicMemberships_57, t0.nEmployees AS nEmployees_58, t0.nTransponders AS nTransponders_59, t0.nTiefgarage AS nTiefgarage_60, t0.editStatus AS editStatus_61, t0.xing AS xing_62, t0.linkedin AS linkedin_63, t0.facebook AS facebook_64, t0.twitter AS twitter_65, t0.instagram AS instagram_66, t0.enterDate AS enterDate_67, t0.lastChangeDate AS lastChangeDate_68, t0.lastModified AS lastModified_69, t0.lastInvoiceDate AS lastInvoiceDate_70, t0.exitDate AS exitDate_71, t0.isRedundant AS isRedundant_72, t0.gsStatus AS gsStatus_73, t0.gsBatchNo AS gsBatchNo_74, t0.gsNote AS gsNote_75, t0.gsIdeenblattDate AS gsIdeenblattDate_76, t0.gsJuryDate AS gsJuryDate_77, t0.gsCoachMemberId AS gsCoachMemberId_78, t0.gsCoachMemberName AS gsCoachMemberName_79, t0.spContactPerson AS spContactPerson_80, t0.memberTag AS memberTag_81, t0.actionTag AS actionTag_82, t0.createdAt AS createdAt_83, t0.lastChangeUser AS lastChangeUser_84, t0.history AS history_85, t0.treatAsSubscribed AS treatAsSubscribed_86, t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_87, t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_88, t0.treatAsSubscribedReason AS treatAsSubscribedReason_89, t0.searchAliases AS searchAliases_90 FROM sp_teams t0 WHERE t0.id = ? LIMIT 1
SELECT s0_.id AS id_0, s0_.owner AS owner_1, s0_.type AS type_2, s0_.externalId AS externalId_3, s0_.score AS score_4, s0_.name AS name_5, s0_.title AS title_6, s0_.imageLink AS imageLink_7, s0_.categories AS categories_8, s0_.tags AS tags_9, s0_.isActive AS isActive_10, s0_.lastModified AS lastModified_11, s0_.lastChangeUser AS lastChangeUser_12, s0_.createdAt AS createdAt_13, s0_.rankingScore AS rankingScore_14, s0_.eventStartDate AS eventStartDate_15, s0_.jobEndDate AS jobEndDate_16, s0_.rankingUpdatedAt AS rankingUpdatedAt_17 FROM sp_content_feed s0_ WHERE s0_.tags LIKE ? ORDER BY s0_.score DESC
SELECT t0.id AS id_1, t0.programId AS programId_2, t0.eventId AS eventId_3, t0.productId AS productId_4, t0.batchNumber AS batchNumber_5, t0.url AS url_6, t0.name AS name_7, t0.slug AS slug_8, t0.alias AS alias_9, t0.status AS status_10, t0.focusStatus AS focusStatus_11, t0.lang AS lang_12, t0.priceInEuroCent AS priceInEuroCent_13, t0.isTaxIncluded AS isTaxIncluded_14, t0.discount100MemberTags AS discount100MemberTags_15, t0.discount50MemberTags AS discount50MemberTags_16, t0.discount20MemberTags AS discount20MemberTags_17, t0.askForTeam AS askForTeam_18, t0.hasEvent AS hasEvent_19, t0.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_20, t0.hasIncludeTermsConsent AS hasIncludeTermsConsent_21, t0.hasIncludeLinkedIn AS hasIncludeLinkedIn_22, t0.hasIncludePhone AS hasIncludePhone_23, t0.hasRequirePhone AS hasRequirePhone_24, t0.hasFollowUp AS hasFollowUp_25, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, t0.isFutureEvent AS isFutureEvent_28, t0.visibility AS visibility_29, t0.access AS access_30, t0.tags AS tags_31, t0.typeformLink AS typeformLink_32, t0.zoomLink AS zoomLink_33, t0.bgImageUrl AS bgImageUrl_34, t0.startDate AS startDate_35, t0.endDate AS endDate_36, t0.taxBehavior AS taxBehavior_37, t0.paymentProvider AS paymentProvider_38, t0.isFreeForKiCampus AS isFreeForKiCampus_39, t0.isFreeForCommunity AS isFreeForCommunity_40, t0.registrationMode AS registrationMode_41, t0.externalRegistrationUrl AS externalRegistrationUrl_42, t0.externalPlatform AS externalPlatform_43, t0.registrationHeadline AS registrationHeadline_44, t0.registrationSubtitle AS registrationSubtitle_45, t0.registrationButtonText AS registrationButtonText_46, t0.registrationPriceHtml AS registrationPriceHtml_47, t0.registrationRedirectUrl AS registrationRedirectUrl_48, t0.lumaEventApiId AS lumaEventApiId_49, t0.meetupEventId AS meetupEventId_50, t0.meetupEventUrl AS meetupEventUrl_51, t0.mailDesignTemplate AS mailDesignTemplate_52, t0.senderMail AS senderMail_53, t0.fromName AS fromName_54, t0.recipientMonitoringMail AS recipientMonitoringMail_55, t0.confirmationMailSubject AS confirmationMailSubject_56, t0.confirmationMailContent AS confirmationMailContent_57, t0.adminNotificationMailSubject AS adminNotificationMailSubject_58, t0.adminNotificationMailContent AS adminNotificationMailContent_59, t0.reminderMailTemplateId AS reminderMailTemplateId_60, t0.reminderSenderEmail AS reminderSenderEmail_61, t0.reminderMailSendDate AS reminderMailSendDate_62, t0.reminderMailSubject AS reminderMailSubject_63, t0.reminderMailContent AS reminderMailContent_64, t0.$reminderMailStatus AS reminderMailStatus_65, t0.surveyId AS surveyId_66, t0.surveyMailTemplateId AS surveyMailTemplateId_67, t0.surveyBulkMailId AS surveyBulkMailId_68, t0.template AS template_69, t0.pageTemplate AS pageTemplate_70, t0.footerTemplate AS footerTemplate_71, t0.email AS email_72, t0.emailSubject AS emailSubject_73, t0.emailContent AS emailContent_74, t0.landingPageContent AS landingPageContent_75, t0.landingPageDescription AS landingPageDescription_76, t0.landingPageCss AS landingPageCss_77, t0.landingPageJs AS landingPageJs_78, t0.landingPageFooterTemplate AS landingPageFooterTemplate_79, t0.landingPageTitle AS landingPageTitle_80, t0.landingPageTwig AS landingPageTwig_81, t0.title AS title_82, t0.teaser AS teaser_83, t0.navbar AS navbar_84, t0.content AS content_85, t0.contentTwig AS contentTwig_86, t0.content_blocks AS content_blocks_87, t0.content_blocks_en AS content_blocks_en_88, t0.ctaContent AS ctaContent_89, t0.postCtaContent AS postCtaContent_90, t0.tagline AS tagline_91, t0.seoTitle AS seoTitle_92, t0.seoDescription AS seoDescription_93, t0.seoKeyword AS seoKeyword_94, t0.imagelink AS imagelink_95, t0.bgImagelink AS bgImagelink_96, t0.additionalCss AS additionalCss_97, t0.additionalJs AS additionalJs_98, t0.navbarEn AS navbarEn_99, t0.teaserEn AS teaserEn_100, t0.contentEn AS contentEn_101, t0.contentTwigEn AS contentTwigEn_102, t0.postCtaContentEn AS postCtaContentEn_103, t0.seoTitleEn AS seoTitleEn_104, t0.seoDescriptionEn AS seoDescriptionEn_105, t0.seoKeywordEn AS seoKeywordEn_106, t0.trainer AS trainer_107, t0.videolink AS videolink_108, t0.goToPage AS goToPage_109, t0.phrasesDe AS phrasesDe_110, t0.phrasesEn AS phrasesEn_111, t0.settings AS settings_112, t0.capacity AS capacity_113, t0.asssesmentDimensions AS asssesmentDimensions_114, t0.start AS start_115, t0.end AS end_116, t0.pitchTopic AS pitchTopic_117, t0.pitchImageLink AS pitchImageLink_118, t0.pitchVideoLink AS pitchVideoLink_119, t0.pitchPartner AS pitchPartner_120, t0.pitchPartnerId AS pitchPartnerId_121, t0.pitchDescription AS pitchDescription_122, t0.followUpPageContent AS followUpPageContent_123, t0.followUpPageDescription AS followUpPageDescription_124, t0.followUpPageCss AS followUpPageCss_125, t0.followUpPageJs AS followUpPageJs_126, t0.followUpPageFooterTemplate AS followUpPageFooterTemplate_127, t0.followUpPageTitle AS followUpPageTitle_128, t0.followUpDescription AS followUpDescription_129, t0.followUpVideoLink AS followUpVideoLink_130, t0.followUpPresentation AS followUpPresentation_131, t0.followUpSkoolUrl AS followUpSkoolUrl_132, t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_133, t0.followUpCtaText AS followUpCtaText_134, t0.followUpCtaUrl AS followUpCtaUrl_135, t0.followUpDocuments AS followUpDocuments_136, t0.followUpPhotos AS followUpPhotos_137, t0.followUpExtraLinks AS followUpExtraLinks_138, t0.followUpChecklist AS followUpChecklist_139, t0.pitchDate AS pitchDate_140, t0.pitchTime AS pitchTime_141, t0.prepitchDate AS prepitchDate_142, t0.scoutingEndDate AS scoutingEndDate_143, t0.applicationStartDate AS applicationStartDate_144, t0.applicationEndDate AS applicationEndDate_145, t0.interviewInviteStartDate AS interviewInviteStartDate_146, t0.interviewInviteEndDate AS interviewInviteEndDate_147, t0.interviewStartDate AS interviewStartDate_148, t0.interviewEndDate AS interviewEndDate_149, t0.decisionDate AS decisionDate_150, t0.contractDeadlineDate AS contractDeadlineDate_151, t0.finalReportDate AS finalReportDate_152, t0.applicationFormState AS applicationFormState_153, t0.googleCalendarUrl AS googleCalendarUrl_154, t0.city AS city_155, t0.applicationsCount AS applicationsCount_156, t0.startedCount AS startedCount_157, t0.appliedCount AS appliedCount_158, t0.approvedCount AS approvedCount_159, t0.rejectedCount AS rejectedCount_160, t0.$skoolWebhook AS skoolWebhook_161, t0.zapierWebhook AS zapierWebhook_162, t0.history AS history_163, t0.createdAt AS createdAt_164, t0.lastModified AS lastModified_165, t0.lastChangeUser AS lastChangeUser_166, t0.programId AS programId_167, t0.assessmentTeamId AS assessmentTeamId_168 FROM sp_batches t0 WHERE t0.id = ?
SELECT s0_.startupName AS startupName_0, s0_.pitchPosition AS pitchPosition_1, s0_.programName AS programName_2, s0_.batchName AS batchName_3, s1_.pitchDate AS pitchDate_4, s1_.city AS city_5 FROM sp_applications s0_ INNER JOIN sp_batches s1_ ON (s0_.batchId = s1_.id) WHERE s0_.startupId = ? AND s0_.programId = ?
SELECT s0_.id AS id_0, s0_.score AS score_1, s0_.completenessScore AS completenessScore_2, s0_.status AS status_3, s0_.location AS location_4, s0_.salutation AS salutation_5, s0_.title AS title_6, s0_.jobTitle AS jobTitle_7, s0_.firstName AS firstName_8, s0_.lastName AS lastName_9, s0_.name AS name_10, s0_.sortName AS sortName_11, s0_.email AS email_12, s0_.secondaryEmail AS secondaryEmail_13, s0_.phone AS phone_14, s0_.hasCommunityMembership AS hasCommunityMembership_15, s0_.utm_source AS utm_source_16, s0_.utm_medium AS utm_medium_17, s0_.utm_campaign AS utm_campaign_18, s0_.utm_term AS utm_term_19, s0_.utm_content AS utm_content_20, s0_.birthday AS birthday_21, s0_.addressFieldOne AS addressFieldOne_22, s0_.addressFieldTwo AS addressFieldTwo_23, s0_.addressCountryCode AS addressCountryCode_24, s0_.addressPostalCode AS addressPostalCode_25, s0_.addressCity AS addressCity_26, s0_.teamId AS teamId_27, s0_.teamName AS teamName_28, s0_.company AS company_29, s0_.history AS history_30, s0_.tags AS tags_31, s0_.annotation AS annotation_32, s0_.mentorBuckets AS mentorBuckets_33, s0_.areasOfExpertise AS areasOfExpertise_34, s0_.mentor_firma AS mentor_firma_35, s0_.mentor_firma_url AS mentor_firma_url_36, s0_.mentor_locations AS mentor_locations_37, s0_.mentor_profile AS mentor_profile_38, s0_.mentor_note AS mentor_note_39, s0_.mentor_admin_rating AS mentor_admin_rating_40, s0_.active AS active_41, s0_.tiefgarage AS tiefgarage_42, s0_.transponder AS transponder_43, s0_.isTransponderAllowed AS isTransponderAllowed_44, s0_.imageLink AS imageLink_45, s0_.homepage AS homepage_46, s0_.xing AS xing_47, s0_.pipedriveId AS pipedriveId_48, s0_.linkedin AS linkedin_49, s0_.facebook AS facebook_50, s0_.instagram AS instagram_51, s0_.tiktok AS tiktok_52, s0_.threads AS threads_53, s0_.youtube AS youtube_54, s0_.twitter AS twitter_55, s0_.github AS github_56, s0_.reachableLocation AS reachableLocation_57, s0_.skills AS skills_58, s0_.description AS description_59, s0_.isVisibleInNetworking AS isVisibleInNetworking_60, s0_.gender AS gender_61, s0_.currentFocus AS currentFocus_62, s0_.networkingConsentAt AS networkingConsentAt_63, s0_.networkingConsentVersion AS networkingConsentVersion_64, s0_.networkingConsentRevokedAt AS networkingConsentRevokedAt_65, s0_.touchpoints AS touchpoints_66, s0_.isAddressComplete AS isAddressComplete_67, s0_.hasMailchimp AS hasMailchimp_68, s0_.hasKiNewsletter AS hasKiNewsletter_69, s0_.hubspotSyncPending AS hubspotSyncPending_70, s0_.enterDate AS enterDate_71, s0_.exitDate AS exitDate_72, s0_.physicalMembershipStarted AS physicalMembershipStarted_73, s0_.physicalMembershipEnded AS physicalMembershipEnded_74, s0_.lastModified AS lastModified_75, s0_.lastChangeUser AS lastChangeUser_76, s0_.onboardingCompletedAt AS onboardingCompletedAt_77, s0_.nAiWebinarsAttended AS nAiWebinarsAttended_78, s0_.nAiWebinarsApplied AS nAiWebinarsApplied_79, s0_.nAiEventsAttended AS nAiEventsAttended_80, s0_.nAiEventsApplied AS nAiEventsApplied_81, s0_.nPaidAttended AS nPaidAttended_82, s0_.nPaidApplied AS nPaidApplied_83, s0_.nKiEinstiegAttended AS nKiEinstiegAttended_84, s0_.nKiEinstiegApplied AS nKiEinstiegApplied_85, s0_.nPromptEngineeringAttended AS nPromptEngineeringAttended_86, s0_.nPromptEngineeringApplied AS nPromptEngineeringApplied_87, s0_.nEcodynamicsAttended AS nEcodynamicsAttended_88, s0_.nEcodynamicsApplied AS nEcodynamicsApplied_89, s0_.nBbqApplied AS nBbqApplied_90, s0_.nAiFridayApplied AS nAiFridayApplied_91, s0_.nAiGatheringApplied AS nAiGatheringApplied_92, s0_.nAiGatheringAttended AS nAiGatheringAttended_93, s0_.aiSs24Applied AS aiSs24Applied_94, s0_.aiSs24Booked AS aiSs24Booked_95, s0_.interestedIn AS interestedIn_96, s0_.interests AS interests_97, s0_.mentorMetadata AS mentorMetadata_98, s0_.eventParticipations AS eventParticipations_99, s0_.kiKompetenz AS kiKompetenz_100, s0_.mentorOwnerId AS mentorOwnerId_101 FROM sp_members s0_, sp_member_teams s1_ WHERE s0_.id = s1_.member_id AND s1_.team_id = ? ORDER BY s0_.firstName ASC, s0_.lastName ASC
SELECT t0.id AS id_1, t0.startupId AS startupId_2, t0.programId AS programId_3, t0.batchId AS batchId_4, t0.metaLeadId AS metaLeadId_5, t0.metaFormId AS metaFormId_6, t0.utm_source AS utm_source_7, t0.utm_medium AS utm_medium_8, t0.utm_campaign AS utm_campaign_9, t0.utm_term AS utm_term_10, t0.utm_content AS utm_content_11, t0.votesRegistered AS votesRegistered_12, t0.programName AS programName_13, t0.programSlug AS programSlug_14, t0.batchName AS batchName_15, t0.batchSlug AS batchSlug_16, t0.template AS template_17, t0.teamId AS teamId_18, t0.memberId AS memberId_19, t0.lang AS lang_20, t0.startupName AS startupName_21, t0.visibility AS visibility_22, t0.firstName AS firstName_23, t0.lastName AS lastName_24, t0.person AS person_25, t0.email AS email_26, t0.secondaryEmail AS secondaryEmail_27, t0.phone AS phone_28, t0.linkedin AS linkedin_29, t0.telegram AS telegram_30, t0.discord AS discord_31, t0.wallet AS wallet_32, t0.teamSize AS teamSize_33, t0.city AS city_34, t0.startupStage AS startupStage_35, t0.industry AS industry_36, t0.track AS track_37, t0.projectCategory AS projectCategory_38, t0.blockchain AS blockchain_39, t0.recommendedBy AS recommendedBy_40, t0.editStatus AS editStatus_41, t0.editMessage AS editMessage_42, t0.applicationStatus AS applicationStatus_43, t0.reviewStatus AS reviewStatus_44, t0.pendingDecision AS pendingDecision_45, t0.isNewMember AS isNewMember_46, t0.hasConfirmationMailSent AS hasConfirmationMailSent_47, t0.hasTermsAccepted AS hasTermsAccepted_48, t0.batchStatus AS batchStatus_49, t0.selectionStatus AS selectionStatus_50, t0.participationStatus AS participationStatus_51, t0.coachMemberId AS coachMemberId_52, t0.participationStartedAt AS participationStartedAt_53, t0.participationCompletedAt AS participationCompletedAt_54, t0.pitchPosition AS pitchPosition_55, t0.pitchImageLink AS pitchImageLink_56, t0.pitchVideoLink AS pitchVideoLink_57, t0.linkPitchDeck AS linkPitchDeck_58, t0.publicIdPitchDeck AS publicIdPitchDeck_59, t0.ideaPaperUrl AS ideaPaperUrl_60, t0.publicIdIdeaPaper AS publicIdIdeaPaper_61, t0.websiteUrl AS websiteUrl_62, t0.fulltime AS fulltime_63, t0.language AS language_64, t0.mvpStatus AS mvpStatus_65, t0.dealroomUrl AS dealroomUrl_66, t0.podioId AS podioId_67, t0.podioItemId AS podioItemId_68, t0.podioUrl AS podioUrl_69, t0.ideaPitch AS ideaPitch_70, t0.createdAt AS createdAt_71, t0.lastModified AS lastModified_72, t0.deletedAt AS deletedAt_73, t0.lastChangeUser AS lastChangeUser_74, t0.history AS history_75, t0.extraFields AS extraFields_76, t0.adminNotes AS adminNotes_77, t0.ratingJudge1 AS ratingJudge1_78, t0.ratingJudge2 AS ratingJudge2_79, t0.ratingJudge3 AS ratingJudge3_80, t0.ratingJudge4 AS ratingJudge4_81, t0.ratingJudge5 AS ratingJudge5_82, t0.ratingAverage AS ratingAverage_83, t0.ratingUpdatedAt AS ratingUpdatedAt_84, t0.memberTagsAtRegistration AS memberTagsAtRegistration_85, t0.wasCommunityMemberAtRegistration AS wasCommunityMemberAtRegistration_86, t0.wasPhysicalMemberAtRegistration AS wasPhysicalMemberAtRegistration_87, t0.memberUtmSourceAtRegistration AS memberUtmSourceAtRegistration_88, t0.kiKompetenzAtRegistration AS kiKompetenzAtRegistration_89, t0.pendingMemberData AS pendingMemberData_90, t0.pendingTeamData AS pendingTeamData_91, t0.resumeToken AS resumeToken_92, t0.resumeTokenExpiresAt AS resumeTokenExpiresAt_93, t0.isMemberCreated AS isMemberCreated_94, t0.isTeamCreated AS isTeamCreated_95 FROM sp_applications t0 WHERE t0.teamId = ? AND t0.programId IN (?, ?, ?)
SELECT s0_.id AS id_0, s0_.name AS name_1, s1_.type AS type_2, s0_.email AS email_3 FROM sp_member_teams s1_ INNER JOIN sp_members s0_ ON (s1_.member_id = s0_.id) WHERE s1_.team_id = ?
SELECT s0_.id AS id_0, s0_.owner AS owner_1, s0_.type AS type_2, s0_.externalId AS externalId_3, s0_.score AS score_4, s0_.name AS name_5, s0_.title AS title_6, s0_.imageLink AS imageLink_7, s0_.categories AS categories_8, s0_.tags AS tags_9, s0_.isActive AS isActive_10, s0_.lastModified AS lastModified_11, s0_.lastChangeUser AS lastChangeUser_12, s0_.createdAt AS createdAt_13, s0_.rankingScore AS rankingScore_14, s0_.eventStartDate AS eventStartDate_15, s0_.jobEndDate AS jobEndDate_16, s0_.rankingUpdatedAt AS rankingUpdatedAt_17 FROM sp_content_feed s0_ WHERE s0_.tags LIKE ? ORDER BY s0_.score DESC
SELECT t0.id AS id_1, t0.programId AS programId_2, t0.eventId AS eventId_3, t0.productId AS productId_4, t0.batchNumber AS batchNumber_5, t0.url AS url_6, t0.name AS name_7, t0.slug AS slug_8, t0.alias AS alias_9, t0.status AS status_10, t0.focusStatus AS focusStatus_11, t0.lang AS lang_12, t0.priceInEuroCent AS priceInEuroCent_13, t0.isTaxIncluded AS isTaxIncluded_14, t0.discount100MemberTags AS discount100MemberTags_15, t0.discount50MemberTags AS discount50MemberTags_16, t0.discount20MemberTags AS discount20MemberTags_17, t0.askForTeam AS askForTeam_18, t0.hasEvent AS hasEvent_19, t0.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_20, t0.hasIncludeTermsConsent AS hasIncludeTermsConsent_21, t0.hasIncludeLinkedIn AS hasIncludeLinkedIn_22, t0.hasIncludePhone AS hasIncludePhone_23, t0.hasRequirePhone AS hasRequirePhone_24, t0.hasFollowUp AS hasFollowUp_25, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, t0.isFutureEvent AS isFutureEvent_28, t0.visibility AS visibility_29, t0.access AS access_30, t0.tags AS tags_31, t0.typeformLink AS typeformLink_32, t0.zoomLink AS zoomLink_33, t0.bgImageUrl AS bgImageUrl_34, t0.startDate AS startDate_35, t0.endDate AS endDate_36, t0.taxBehavior AS taxBehavior_37, t0.paymentProvider AS paymentProvider_38, t0.isFreeForKiCampus AS isFreeForKiCampus_39, t0.isFreeForCommunity AS isFreeForCommunity_40, t0.registrationMode AS registrationMode_41, t0.externalRegistrationUrl AS externalRegistrationUrl_42, t0.externalPlatform AS externalPlatform_43, t0.registrationHeadline AS registrationHeadline_44, t0.registrationSubtitle AS registrationSubtitle_45, t0.registrationButtonText AS registrationButtonText_46, t0.registrationPriceHtml AS registrationPriceHtml_47, t0.registrationRedirectUrl AS registrationRedirectUrl_48, t0.lumaEventApiId AS lumaEventApiId_49, t0.meetupEventId AS meetupEventId_50, t0.meetupEventUrl AS meetupEventUrl_51, t0.mailDesignTemplate AS mailDesignTemplate_52, t0.senderMail AS senderMail_53, t0.fromName AS fromName_54, t0.recipientMonitoringMail AS recipientMonitoringMail_55, t0.confirmationMailSubject AS confirmationMailSubject_56, t0.confirmationMailContent AS confirmationMailContent_57, t0.adminNotificationMailSubject AS adminNotificationMailSubject_58, t0.adminNotificationMailContent AS adminNotificationMailContent_59, t0.reminderMailTemplateId AS reminderMailTemplateId_60, t0.reminderSenderEmail AS reminderSenderEmail_61, t0.reminderMailSendDate AS reminderMailSendDate_62, t0.reminderMailSubject AS reminderMailSubject_63, t0.reminderMailContent AS reminderMailContent_64, t0.$reminderMailStatus AS reminderMailStatus_65, t0.surveyId AS surveyId_66, t0.surveyMailTemplateId AS surveyMailTemplateId_67, t0.surveyBulkMailId AS surveyBulkMailId_68, t0.template AS template_69, t0.pageTemplate AS pageTemplate_70, t0.footerTemplate AS footerTemplate_71, t0.email AS email_72, t0.emailSubject AS emailSubject_73, t0.emailContent AS emailContent_74, t0.landingPageContent AS landingPageContent_75, t0.landingPageDescription AS landingPageDescription_76, t0.landingPageCss AS landingPageCss_77, t0.landingPageJs AS landingPageJs_78, t0.landingPageFooterTemplate AS landingPageFooterTemplate_79, t0.landingPageTitle AS landingPageTitle_80, t0.landingPageTwig AS landingPageTwig_81, t0.title AS title_82, t0.teaser AS teaser_83, t0.navbar AS navbar_84, t0.content AS content_85, t0.contentTwig AS contentTwig_86, t0.content_blocks AS content_blocks_87, t0.content_blocks_en AS content_blocks_en_88, t0.ctaContent AS ctaContent_89, t0.postCtaContent AS postCtaContent_90, t0.tagline AS tagline_91, t0.seoTitle AS seoTitle_92, t0.seoDescription AS seoDescription_93, t0.seoKeyword AS seoKeyword_94, t0.imagelink AS imagelink_95, t0.bgImagelink AS bgImagelink_96, t0.additionalCss AS additionalCss_97, t0.additionalJs AS additionalJs_98, t0.navbarEn AS navbarEn_99, t0.teaserEn AS teaserEn_100, t0.contentEn AS contentEn_101, t0.contentTwigEn AS contentTwigEn_102, t0.postCtaContentEn AS postCtaContentEn_103, t0.seoTitleEn AS seoTitleEn_104, t0.seoDescriptionEn AS seoDescriptionEn_105, t0.seoKeywordEn AS seoKeywordEn_106, t0.trainer AS trainer_107, t0.videolink AS videolink_108, t0.goToPage AS goToPage_109, t0.phrasesDe AS phrasesDe_110, t0.phrasesEn AS phrasesEn_111, t0.settings AS settings_112, t0.capacity AS capacity_113, t0.asssesmentDimensions AS asssesmentDimensions_114, t0.start AS start_115, t0.end AS end_116, t0.pitchTopic AS pitchTopic_117, t0.pitchImageLink AS pitchImageLink_118, t0.pitchVideoLink AS pitchVideoLink_119, t0.pitchPartner AS pitchPartner_120, t0.pitchPartnerId AS pitchPartnerId_121, t0.pitchDescription AS pitchDescription_122, t0.followUpPageContent AS followUpPageContent_123, t0.followUpPageDescription AS followUpPageDescription_124, t0.followUpPageCss AS followUpPageCss_125, t0.followUpPageJs AS followUpPageJs_126, t0.followUpPageFooterTemplate AS followUpPageFooterTemplate_127, t0.followUpPageTitle AS followUpPageTitle_128, t0.followUpDescription AS followUpDescription_129, t0.followUpVideoLink AS followUpVideoLink_130, t0.followUpPresentation AS followUpPresentation_131, t0.followUpSkoolUrl AS followUpSkoolUrl_132, t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_133, t0.followUpCtaText AS followUpCtaText_134, t0.followUpCtaUrl AS followUpCtaUrl_135, t0.followUpDocuments AS followUpDocuments_136, t0.followUpPhotos AS followUpPhotos_137, t0.followUpExtraLinks AS followUpExtraLinks_138, t0.followUpChecklist AS followUpChecklist_139, t0.pitchDate AS pitchDate_140, t0.pitchTime AS pitchTime_141, t0.prepitchDate AS prepitchDate_142, t0.scoutingEndDate AS scoutingEndDate_143, t0.applicationStartDate AS applicationStartDate_144, t0.applicationEndDate AS applicationEndDate_145, t0.interviewInviteStartDate AS interviewInviteStartDate_146, t0.interviewInviteEndDate AS interviewInviteEndDate_147, t0.interviewStartDate AS interviewStartDate_148, t0.interviewEndDate AS interviewEndDate_149, t0.decisionDate AS decisionDate_150, t0.contractDeadlineDate AS contractDeadlineDate_151, t0.finalReportDate AS finalReportDate_152, t0.applicationFormState AS applicationFormState_153, t0.googleCalendarUrl AS googleCalendarUrl_154, t0.city AS city_155, t0.applicationsCount AS applicationsCount_156, t0.startedCount AS startedCount_157, t0.appliedCount AS appliedCount_158, t0.approvedCount AS approvedCount_159, t0.rejectedCount AS rejectedCount_160, t0.$skoolWebhook AS skoolWebhook_161, t0.zapierWebhook AS zapierWebhook_162, t0.history AS history_163, t0.createdAt AS createdAt_164, t0.lastModified AS lastModified_165, t0.lastChangeUser AS lastChangeUser_166, t0.programId AS programId_167, t0.assessmentTeamId AS assessmentTeamId_168 FROM sp_batches t0 WHERE t0.id = ?
SELECT s0_.id AS id_0, s0_.location AS location_1, s0_.$location_optional AS location_optional_2, s0_.jobType AS jobType_3, s0_.companyName AS companyName_4, s0_.description AS description_5, s0_.logoUrl AS logoUrl_6, s0_.startingDate AS startingDate_7, s0_.endDate AS endDate_8, s0_.companyType AS companyType_9, s0_.jobUrl AS jobUrl_10, s0_.categories AS categories_11, s0_.tags AS tags_12, s0_.applyTarget AS applyTarget_13, s0_.history AS history_14, s0_.lastChangeUser AS lastChangeUser_15, s0_.lastModified AS lastModified_16, s0_.createdAt AS createdAt_17, s0_.seniority AS seniority_18, s0_.locationType AS locationType_19, s0_.brandColor AS brandColor_20, s0_.tasks AS tasks_21, s0_.requirements AS requirements_22, s0_.status AS status_23, s0_.extendedAt AS extendedAt_24, s0_.reminderSentAt AS reminderSentAt_25, s0_.teamId AS teamId_26 FROM sp_jobs s0_ WHERE s0_.teamId = ? AND s0_.status = ? AND s0_.startingDate <= ? AND ((s0_.endDate IS NULL OR s0_.endDate >= ?)) ORDER BY s0_.startingDate DESC
SELECT s0_.id AS id_0, s0_.startupId AS startupId_1, s0_.url AS url_2, s0_.title AS title_3, s0_.publishedAt AS publishedAt_4, s0_.isActive AS isActive_5, s0_.submittedBy AS submittedBy_6, s0_.createdAt AS createdAt_7 FROM sp_startup_news_links s0_ WHERE s0_.startupId = ? AND s0_.isActive = 1 ORDER BY s0_.publishedAt DESC, s0_.createdAt DESC

#▲	Time	Info
1	0.61 ms	SELECT t0.id AS id_1, t0.extId AS extId_2, t0.visibility AS visibility_3, t0.score AS score_4, t0.name AS name_5, t0.teamId AS teamId_6, t0.website AS website_7, t0.domain AS domain_8, t0.slug AS slug_9, t0.status AS status_10, t0.editStatus AS editStatus_11, t0.stage AS stage_12, t0.source AS source_13, t0.runway AS runway_14, t0.fundingSinceProgram AS fundingSinceProgram_15, t0.partnerTags AS partnerTags_16, t0.lastCheckDate AS lastCheckDate_17, t0.alumniStatus AS alumniStatus_18, t0.logoUrl AS logoUrl_19, t0.logoBackground AS logoBackground_20, t0.imageLink AS imageLink_21, t0.currentPitchDeckUrl AS currentPitchDeckUrl_22, t0.kiAccelerator AS kiAccelerator_23, t0.todos AS todos_24, t0.industry AS industry_25, t0.industryCondensed AS industryCondensed_26, t0.customerFocus AS customerFocus_27, t0.BusinessModel AS BusinessModel_28, t0.tags AS tags_29, t0.oneSentencePitch AS oneSentencePitch_30, t0.oneSentencePitchEn AS oneSentencePitchEn_31, t0.foundationYear AS foundationYear_32, t0.location AS location_33, t0.city AS city_34, t0.employeesCount AS employeesCount_35, t0.funding AS funding_36, t0.investors AS investors_37, t0.revenue AS revenue_38, t0.contactPerson AS contactPerson_39, t0.contactEmail AS contactEmail_40, t0.contactTelefon AS contactTelefon_41, t0.xing AS xing_42, t0.linkedin AS linkedin_43, t0.facebook AS facebook_44, t0.twitter AS twitter_45, t0.instagram AS instagram_46, t0.tiktok AS tiktok_47, t0.threads AS threads_48, t0.youtube AS youtube_49, t0.description AS description_50, t0.publicDetailHtml AS publicDetailHtml_51, t0.publicDetailHtmlEn AS publicDetailHtmlEn_52, t0.internalDetailHtml AS internalDetailHtml_53, t0.internalDetailHtmlEn AS internalDetailHtmlEn_54, t0.gsPublicSummary AS gsPublicSummary_55, t0.gsIndustries AS gsIndustries_56, t0.gsKeywords AS gsKeywords_57, t0.gsProfile AS gsProfile_58, t0.comments AS comments_59, t0.history AS history_60, t0.lastChangeUser AS lastChangeUser_61, t0.createdAt AS createdAt_62, t0.lastModified AS lastModified_63, t0.lastChangedBy AS lastChangedBy_64 FROM sp_startup_profiles t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"3001037"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.extId AS extId_2, t0.visibility AS visibility_3, t0.score AS score_4, t0.name AS name_5, t0.teamId AS teamId_6, t0.website AS website_7, t0.domain AS domain_8, t0.slug AS slug_9, t0.status AS status_10, t0.editStatus AS editStatus_11, t0.stage AS stage_12, t0.source AS source_13, t0.runway AS runway_14, t0.fundingSinceProgram AS fundingSinceProgram_15, t0.partnerTags AS partnerTags_16, t0.lastCheckDate AS lastCheckDate_17, t0.alumniStatus AS alumniStatus_18, t0.logoUrl AS logoUrl_19, t0.logoBackground AS logoBackground_20, t0.imageLink AS imageLink_21, t0.currentPitchDeckUrl AS currentPitchDeckUrl_22, t0.kiAccelerator AS kiAccelerator_23, t0.todos AS todos_24, t0.industry AS industry_25, t0.industryCondensed AS industryCondensed_26, t0.customerFocus AS customerFocus_27, t0.BusinessModel AS BusinessModel_28, t0.tags AS tags_29, t0.oneSentencePitch AS oneSentencePitch_30, t0.oneSentencePitchEn AS oneSentencePitchEn_31, t0.foundationYear AS foundationYear_32, t0.location AS location_33, t0.city AS city_34, t0.employeesCount AS employeesCount_35, t0.funding AS funding_36, t0.investors AS investors_37, t0.revenue AS revenue_38, t0.contactPerson AS contactPerson_39, t0.contactEmail AS contactEmail_40, t0.contactTelefon AS contactTelefon_41, t0.xing AS xing_42, t0.linkedin AS linkedin_43, t0.facebook AS facebook_44, t0.twitter AS twitter_45, t0.instagram AS instagram_46, t0.tiktok AS tiktok_47, t0.threads AS threads_48, t0.youtube AS youtube_49, t0.description AS description_50, t0.publicDetailHtml AS publicDetailHtml_51, t0.publicDetailHtmlEn AS publicDetailHtmlEn_52, t0.internalDetailHtml AS internalDetailHtml_53, t0.internalDetailHtmlEn AS internalDetailHtmlEn_54, t0.gsPublicSummary AS gsPublicSummary_55, t0.gsIndustries AS gsIndustries_56, t0.gsKeywords AS gsKeywords_57, t0.gsProfile AS gsProfile_58, t0.comments AS comments_59, t0.history AS history_60, t0.lastChangeUser AS lastChangeUser_61, t0.createdAt AS createdAt_62, t0.lastModified AS lastModified_63, t0.lastChangedBy AS lastChangedBy_64 FROM sp_startup_profiles t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.extId AS extId_2, t0.visibility AS visibility_3, t0.score AS score_4, t0.name AS name_5, t0.teamId AS teamId_6, t0.website AS website_7, t0.domain AS domain_8, t0.slug AS slug_9, t0.status AS status_10, t0.editStatus AS editStatus_11, t0.stage AS stage_12, t0.source AS source_13, t0.runway AS runway_14, t0.fundingSinceProgram AS fundingSinceProgram_15, t0.partnerTags AS partnerTags_16, t0.lastCheckDate AS lastCheckDate_17, t0.alumniStatus AS alumniStatus_18, t0.logoUrl AS logoUrl_19, t0.logoBackground AS logoBackground_20, t0.imageLink AS imageLink_21, t0.currentPitchDeckUrl AS currentPitchDeckUrl_22, t0.kiAccelerator AS kiAccelerator_23, t0.todos AS todos_24, t0.industry AS industry_25, t0.industryCondensed AS industryCondensed_26, t0.customerFocus AS customerFocus_27, t0.BusinessModel AS BusinessModel_28, t0.tags AS tags_29, t0.oneSentencePitch AS oneSentencePitch_30, t0.oneSentencePitchEn AS oneSentencePitchEn_31, t0.foundationYear AS foundationYear_32, t0.location AS location_33, t0.city AS city_34, t0.employeesCount AS employeesCount_35, t0.funding AS funding_36, t0.investors AS investors_37, t0.revenue AS revenue_38, t0.contactPerson AS contactPerson_39, t0.contactEmail AS contactEmail_40, t0.contactTelefon AS contactTelefon_41, t0.xing AS xing_42, t0.linkedin AS linkedin_43, t0.facebook AS facebook_44, t0.twitter AS twitter_45, t0.instagram AS instagram_46, t0.tiktok AS tiktok_47, t0.threads AS threads_48, t0.youtube AS youtube_49, t0.description AS description_50, t0.publicDetailHtml AS publicDetailHtml_51, t0.publicDetailHtmlEn AS publicDetailHtmlEn_52, t0.internalDetailHtml AS internalDetailHtml_53, t0.internalDetailHtmlEn AS internalDetailHtmlEn_54, t0.gsPublicSummary AS gsPublicSummary_55, t0.gsIndustries AS gsIndustries_56, t0.gsKeywords AS gsKeywords_57, t0.gsProfile AS gsProfile_58, t0.comments AS comments_59, t0.history AS history_60, t0.lastChangeUser AS lastChangeUser_61, t0.createdAt AS createdAt_62, t0.lastModified AS lastModified_63, t0.lastChangedBy AS lastChangedBy_64 FROM sp_startup_profiles t0 WHERE t0.id = '3001037' LIMIT 1;
2	0.51 ms	SELECT t0.id AS id_1, t0.startupId AS startupId_2, t0.location AS location_3, t0.locationSecond AS locationSecond_4, t0.name AS name_5, t0.shortName AS shortName_6, t0.previousName AS previousName_7, t0.person AS person_8, t0.phone AS phone_9, t0.addressFieldOne AS addressFieldOne_10, t0.addressFieldTwo AS addressFieldTwo_11, t0.addressCountryCode AS addressCountryCode_12, t0.addressPostalCode AS addressPostalCode_13, t0.addressCity AS addressCity_14, t0.spTeamId AS spTeamId_15, t0.accountEmail AS accountEmail_16, t0.connectEmail AS connectEmail_17, t0.status AS status_18, t0.hasCommunityMembership AS hasCommunityMembership_19, t0.isTransponderAllowed AS isTransponderAllowed_20, t0.jobPostingEnabled AS jobPostingEnabled_21, t0.jobPostingNoExpiry AS jobPostingNoExpiry_22, t0.jobCompanyType AS jobCompanyType_23, t0.hasStartupMembership AS hasStartupMembership_24, t0.isIncludeInUpdateType AS isIncludeInUpdateType_25, t0.isCompany AS isCompany_26, t0.isAddressComplete AS isAddressComplete_27, t0.isDebitor AS isDebitor_28, t0.type AS type_29, t0.internalDescription AS internalDescription_30, t0.monsumCustomerType AS monsumCustomerType_31, t0.homepage AS homepage_32, t0.logoURL AS logoURL_33, t0.industries AS industries_34, t0.description AS description_35, t0.note AS note_36, t0.tags AS tags_37, t0.categories AS categories_38, t0.alertNote AS alertNote_39, t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_40, t0.monthlyExtraBudget AS monthlyExtraBudget_41, t0.sameDayBudget AS sameDayBudget_42, t0.sameDayBudgetUsed AS sameDayBudgetUsed_43, t0.sameDayExtraBudget AS sameDayExtraBudget_44, t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_45, t0.communityBudget AS communityBudget_46, t0.communityBudgetUsed AS communityBudgetUsed_47, t0.meetingRoomsBudget AS meetingRoomsBudget_48, t0.conferenceRoomsBudget AS conferenceRoomsBudget_49, t0.coffeeCoinsBudget AS coffeeCoinsBudget_50, t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_51, t0.meetingRoomsBooked AS meetingRoomsBooked_52, t0.conferenceRoomsBooked AS conferenceRoomsBooked_53, t0.todayRoomsBooked AS todayRoomsBooked_54, t0.nDedicatedDesks AS nDedicatedDesks_55, t0.nFlexibleDesks AS nFlexibleDesks_56, t0.nBasicMemberships AS nBasicMemberships_57, t0.nEmployees AS nEmployees_58, t0.nTransponders AS nTransponders_59, t0.nTiefgarage AS nTiefgarage_60, t0.editStatus AS editStatus_61, t0.xing AS xing_62, t0.linkedin AS linkedin_63, t0.facebook AS facebook_64, t0.twitter AS twitter_65, t0.instagram AS instagram_66, t0.enterDate AS enterDate_67, t0.lastChangeDate AS lastChangeDate_68, t0.lastModified AS lastModified_69, t0.lastInvoiceDate AS lastInvoiceDate_70, t0.exitDate AS exitDate_71, t0.isRedundant AS isRedundant_72, t0.gsStatus AS gsStatus_73, t0.gsBatchNo AS gsBatchNo_74, t0.gsNote AS gsNote_75, t0.gsIdeenblattDate AS gsIdeenblattDate_76, t0.gsJuryDate AS gsJuryDate_77, t0.gsCoachMemberId AS gsCoachMemberId_78, t0.gsCoachMemberName AS gsCoachMemberName_79, t0.spContactPerson AS spContactPerson_80, t0.memberTag AS memberTag_81, t0.actionTag AS actionTag_82, t0.createdAt AS createdAt_83, t0.lastChangeUser AS lastChangeUser_84, t0.history AS history_85, t0.treatAsSubscribed AS treatAsSubscribed_86, t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_87, t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_88, t0.treatAsSubscribedReason AS treatAsSubscribedReason_89, t0.searchAliases AS searchAliases_90 FROM sp_teams t0 WHERE t0.id = ? LIMIT 1 Parameters: [`16802`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.startupId AS startupId_2, t0.location AS location_3, t0.locationSecond AS locationSecond_4, t0.name AS name_5, t0.shortName AS shortName_6, t0.previousName AS previousName_7, t0.person AS person_8, t0.phone AS phone_9, t0.addressFieldOne AS addressFieldOne_10, t0.addressFieldTwo AS addressFieldTwo_11, t0.addressCountryCode AS addressCountryCode_12, t0.addressPostalCode AS addressPostalCode_13, t0.addressCity AS addressCity_14, t0.spTeamId AS spTeamId_15, t0.accountEmail AS accountEmail_16, t0.connectEmail AS connectEmail_17, t0.status AS status_18, t0.hasCommunityMembership AS hasCommunityMembership_19, t0.isTransponderAllowed AS isTransponderAllowed_20, t0.jobPostingEnabled AS jobPostingEnabled_21, t0.jobPostingNoExpiry AS jobPostingNoExpiry_22, t0.jobCompanyType AS jobCompanyType_23, t0.hasStartupMembership AS hasStartupMembership_24, t0.isIncludeInUpdateType AS isIncludeInUpdateType_25, t0.isCompany AS isCompany_26, t0.isAddressComplete AS isAddressComplete_27, t0.isDebitor AS isDebitor_28, t0.type AS type_29, t0.internalDescription AS internalDescription_30, t0.monsumCustomerType AS monsumCustomerType_31, t0.homepage AS homepage_32, t0.logoURL AS logoURL_33, t0.industries AS industries_34, t0.description AS description_35, t0.note AS note_36, t0.tags AS tags_37, t0.categories AS categories_38, t0.alertNote AS alertNote_39, t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_40, t0.monthlyExtraBudget AS monthlyExtraBudget_41, t0.sameDayBudget AS sameDayBudget_42, t0.sameDayBudgetUsed AS sameDayBudgetUsed_43, t0.sameDayExtraBudget AS sameDayExtraBudget_44, t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_45, t0.communityBudget AS communityBudget_46, t0.communityBudgetUsed AS communityBudgetUsed_47, t0.meetingRoomsBudget AS meetingRoomsBudget_48, t0.conferenceRoomsBudget AS conferenceRoomsBudget_49, t0.coffeeCoinsBudget AS coffeeCoinsBudget_50, t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_51, t0.meetingRoomsBooked AS meetingRoomsBooked_52, t0.conferenceRoomsBooked AS conferenceRoomsBooked_53, t0.todayRoomsBooked AS todayRoomsBooked_54, t0.nDedicatedDesks AS nDedicatedDesks_55, t0.nFlexibleDesks AS nFlexibleDesks_56, t0.nBasicMemberships AS nBasicMemberships_57, t0.nEmployees AS nEmployees_58, t0.nTransponders AS nTransponders_59, t0.nTiefgarage AS nTiefgarage_60, t0.editStatus AS editStatus_61, t0.xing AS xing_62, t0.linkedin AS linkedin_63, t0.facebook AS facebook_64, t0.twitter AS twitter_65, t0.instagram AS instagram_66, t0.enterDate AS enterDate_67, t0.lastChangeDate AS lastChangeDate_68, t0.lastModified AS lastModified_69, t0.lastInvoiceDate AS lastInvoiceDate_70, t0.exitDate AS exitDate_71, t0.isRedundant AS isRedundant_72, t0.gsStatus AS gsStatus_73, t0.gsBatchNo AS gsBatchNo_74, t0.gsNote AS gsNote_75, t0.gsIdeenblattDate AS gsIdeenblattDate_76, t0.gsJuryDate AS gsJuryDate_77, t0.gsCoachMemberId AS gsCoachMemberId_78, t0.gsCoachMemberName AS gsCoachMemberName_79, t0.spContactPerson AS spContactPerson_80, t0.memberTag AS memberTag_81, t0.actionTag AS actionTag_82, t0.createdAt AS createdAt_83, t0.lastChangeUser AS lastChangeUser_84, t0.history AS history_85, t0.treatAsSubscribed AS treatAsSubscribed_86, t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_87, t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_88, t0.treatAsSubscribedReason AS treatAsSubscribedReason_89, t0.searchAliases AS searchAliases_90 FROM sp_teams t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.startupId AS startupId_2, t0.location AS location_3, t0.locationSecond AS locationSecond_4, t0.name AS name_5, t0.shortName AS shortName_6, t0.previousName AS previousName_7, t0.person AS person_8, t0.phone AS phone_9, t0.addressFieldOne AS addressFieldOne_10, t0.addressFieldTwo AS addressFieldTwo_11, t0.addressCountryCode AS addressCountryCode_12, t0.addressPostalCode AS addressPostalCode_13, t0.addressCity AS addressCity_14, t0.spTeamId AS spTeamId_15, t0.accountEmail AS accountEmail_16, t0.connectEmail AS connectEmail_17, t0.status AS status_18, t0.hasCommunityMembership AS hasCommunityMembership_19, t0.isTransponderAllowed AS isTransponderAllowed_20, t0.jobPostingEnabled AS jobPostingEnabled_21, t0.jobPostingNoExpiry AS jobPostingNoExpiry_22, t0.jobCompanyType AS jobCompanyType_23, t0.hasStartupMembership AS hasStartupMembership_24, t0.isIncludeInUpdateType AS isIncludeInUpdateType_25, t0.isCompany AS isCompany_26, t0.isAddressComplete AS isAddressComplete_27, t0.isDebitor AS isDebitor_28, t0.type AS type_29, t0.internalDescription AS internalDescription_30, t0.monsumCustomerType AS monsumCustomerType_31, t0.homepage AS homepage_32, t0.logoURL AS logoURL_33, t0.industries AS industries_34, t0.description AS description_35, t0.note AS note_36, t0.tags AS tags_37, t0.categories AS categories_38, t0.alertNote AS alertNote_39, t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_40, t0.monthlyExtraBudget AS monthlyExtraBudget_41, t0.sameDayBudget AS sameDayBudget_42, t0.sameDayBudgetUsed AS sameDayBudgetUsed_43, t0.sameDayExtraBudget AS sameDayExtraBudget_44, t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_45, t0.communityBudget AS communityBudget_46, t0.communityBudgetUsed AS communityBudgetUsed_47, t0.meetingRoomsBudget AS meetingRoomsBudget_48, t0.conferenceRoomsBudget AS conferenceRoomsBudget_49, t0.coffeeCoinsBudget AS coffeeCoinsBudget_50, t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_51, t0.meetingRoomsBooked AS meetingRoomsBooked_52, t0.conferenceRoomsBooked AS conferenceRoomsBooked_53, t0.todayRoomsBooked AS todayRoomsBooked_54, t0.nDedicatedDesks AS nDedicatedDesks_55, t0.nFlexibleDesks AS nFlexibleDesks_56, t0.nBasicMemberships AS nBasicMemberships_57, t0.nEmployees AS nEmployees_58, t0.nTransponders AS nTransponders_59, t0.nTiefgarage AS nTiefgarage_60, t0.editStatus AS editStatus_61, t0.xing AS xing_62, t0.linkedin AS linkedin_63, t0.facebook AS facebook_64, t0.twitter AS twitter_65, t0.instagram AS instagram_66, t0.enterDate AS enterDate_67, t0.lastChangeDate AS lastChangeDate_68, t0.lastModified AS lastModified_69, t0.lastInvoiceDate AS lastInvoiceDate_70, t0.exitDate AS exitDate_71, t0.isRedundant AS isRedundant_72, t0.gsStatus AS gsStatus_73, t0.gsBatchNo AS gsBatchNo_74, t0.gsNote AS gsNote_75, t0.gsIdeenblattDate AS gsIdeenblattDate_76, t0.gsJuryDate AS gsJuryDate_77, t0.gsCoachMemberId AS gsCoachMemberId_78, t0.gsCoachMemberName AS gsCoachMemberName_79, t0.spContactPerson AS spContactPerson_80, t0.memberTag AS memberTag_81, t0.actionTag AS actionTag_82, t0.createdAt AS createdAt_83, t0.lastChangeUser AS lastChangeUser_84, t0.history AS history_85, t0.treatAsSubscribed AS treatAsSubscribed_86, t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_87, t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_88, t0.treatAsSubscribedReason AS treatAsSubscribedReason_89, t0.searchAliases AS searchAliases_90 FROM sp_teams t0 WHERE t0.id = 16802 LIMIT 1;
3	2.49 ms	SELECT s0_.id AS id_0, s0_.owner AS owner_1, s0_.type AS type_2, s0_.externalId AS externalId_3, s0_.score AS score_4, s0_.name AS name_5, s0_.title AS title_6, s0_.imageLink AS imageLink_7, s0_.categories AS categories_8, s0_.tags AS tags_9, s0_.isActive AS isActive_10, s0_.lastModified AS lastModified_11, s0_.lastChangeUser AS lastChangeUser_12, s0_.createdAt AS createdAt_13, s0_.rankingScore AS rankingScore_14, s0_.eventStartDate AS eventStartDate_15, s0_.jobEndDate AS jobEndDate_16, s0_.rankingUpdatedAt AS rankingUpdatedAt_17 FROM sp_content_feed s0_ WHERE s0_.tags LIKE ? ORDER BY s0_.score DESC Parameters: [`"%"holybag"%"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.owner AS owner_1, s0_.type AS type_2, s0_.externalId AS externalId_3, s0_.score AS score_4, s0_.name AS name_5, s0_.title AS title_6, s0_.imageLink AS imageLink_7, s0_.categories AS categories_8, s0_.tags AS tags_9, s0_.isActive AS isActive_10, s0_.lastModified AS lastModified_11, s0_.lastChangeUser AS lastChangeUser_12, s0_.createdAt AS createdAt_13, s0_.rankingScore AS rankingScore_14, s0_.eventStartDate AS eventStartDate_15, s0_.jobEndDate AS jobEndDate_16, s0_.rankingUpdatedAt AS rankingUpdatedAt_17 FROM sp_content_feed s0_ WHERE s0_.tags LIKE ? ORDER BY s0_.score DESC SELECT s0_.id AS id_0, s0_.owner AS owner_1, s0_.type AS type_2, s0_.externalId AS externalId_3, s0_.score AS score_4, s0_.name AS name_5, s0_.title AS title_6, s0_.imageLink AS imageLink_7, s0_.categories AS categories_8, s0_.tags AS tags_9, s0_.isActive AS isActive_10, s0_.lastModified AS lastModified_11, s0_.lastChangeUser AS lastChangeUser_12, s0_.createdAt AS createdAt_13, s0_.rankingScore AS rankingScore_14, s0_.eventStartDate AS eventStartDate_15, s0_.jobEndDate AS jobEndDate_16, s0_.rankingUpdatedAt AS rankingUpdatedAt_17 FROM sp_content_feed s0_ WHERE s0_.tags LIKE '%\"holybag\"%' ORDER BY s0_.score DESC;
4	0.74 ms	SELECT t0.id AS id_1, t0.programId AS programId_2, t0.eventId AS eventId_3, t0.productId AS productId_4, t0.batchNumber AS batchNumber_5, t0.url AS url_6, t0.name AS name_7, t0.slug AS slug_8, t0.alias AS alias_9, t0.status AS status_10, t0.focusStatus AS focusStatus_11, t0.lang AS lang_12, t0.priceInEuroCent AS priceInEuroCent_13, t0.isTaxIncluded AS isTaxIncluded_14, t0.discount100MemberTags AS discount100MemberTags_15, t0.discount50MemberTags AS discount50MemberTags_16, t0.discount20MemberTags AS discount20MemberTags_17, t0.askForTeam AS askForTeam_18, t0.hasEvent AS hasEvent_19, t0.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_20, t0.hasIncludeTermsConsent AS hasIncludeTermsConsent_21, t0.hasIncludeLinkedIn AS hasIncludeLinkedIn_22, t0.hasIncludePhone AS hasIncludePhone_23, t0.hasRequirePhone AS hasRequirePhone_24, t0.hasFollowUp AS hasFollowUp_25, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, t0.isFutureEvent AS isFutureEvent_28, t0.visibility AS visibility_29, t0.access AS access_30, t0.tags AS tags_31, t0.typeformLink AS typeformLink_32, t0.zoomLink AS zoomLink_33, t0.bgImageUrl AS bgImageUrl_34, t0.startDate AS startDate_35, t0.endDate AS endDate_36, t0.taxBehavior AS taxBehavior_37, t0.paymentProvider AS paymentProvider_38, t0.isFreeForKiCampus AS isFreeForKiCampus_39, t0.isFreeForCommunity AS isFreeForCommunity_40, t0.registrationMode AS registrationMode_41, t0.externalRegistrationUrl AS externalRegistrationUrl_42, t0.externalPlatform AS externalPlatform_43, t0.registrationHeadline AS registrationHeadline_44, t0.registrationSubtitle AS registrationSubtitle_45, t0.registrationButtonText AS registrationButtonText_46, t0.registrationPriceHtml AS registrationPriceHtml_47, t0.registrationRedirectUrl AS registrationRedirectUrl_48, t0.lumaEventApiId AS lumaEventApiId_49, t0.meetupEventId AS meetupEventId_50, t0.meetupEventUrl AS meetupEventUrl_51, t0.mailDesignTemplate AS mailDesignTemplate_52, t0.senderMail AS senderMail_53, t0.fromName AS fromName_54, t0.recipientMonitoringMail AS recipientMonitoringMail_55, t0.confirmationMailSubject AS confirmationMailSubject_56, t0.confirmationMailContent AS confirmationMailContent_57, t0.adminNotificationMailSubject AS adminNotificationMailSubject_58, t0.adminNotificationMailContent AS adminNotificationMailContent_59, t0.reminderMailTemplateId AS reminderMailTemplateId_60, t0.reminderSenderEmail AS reminderSenderEmail_61, t0.reminderMailSendDate AS reminderMailSendDate_62, t0.reminderMailSubject AS reminderMailSubject_63, t0.reminderMailContent AS reminderMailContent_64, t0.$reminderMailStatus AS reminderMailStatus_65, t0.surveyId AS surveyId_66, t0.surveyMailTemplateId AS surveyMailTemplateId_67, t0.surveyBulkMailId AS surveyBulkMailId_68, t0.template AS template_69, t0.pageTemplate AS pageTemplate_70, t0.footerTemplate AS footerTemplate_71, t0.email AS email_72, t0.emailSubject AS emailSubject_73, t0.emailContent AS emailContent_74, t0.landingPageContent AS landingPageContent_75, t0.landingPageDescription AS landingPageDescription_76, t0.landingPageCss AS landingPageCss_77, t0.landingPageJs AS landingPageJs_78, t0.landingPageFooterTemplate AS landingPageFooterTemplate_79, t0.landingPageTitle AS landingPageTitle_80, t0.landingPageTwig AS landingPageTwig_81, t0.title AS title_82, t0.teaser AS teaser_83, t0.navbar AS navbar_84, t0.content AS content_85, t0.contentTwig AS contentTwig_86, t0.content_blocks AS content_blocks_87, t0.content_blocks_en AS content_blocks_en_88, t0.ctaContent AS ctaContent_89, t0.postCtaContent AS postCtaContent_90, t0.tagline AS tagline_91, t0.seoTitle AS seoTitle_92, t0.seoDescription AS seoDescription_93, t0.seoKeyword AS seoKeyword_94, t0.imagelink AS imagelink_95, t0.bgImagelink AS bgImagelink_96, t0.additionalCss AS additionalCss_97, t0.additionalJs AS additionalJs_98, t0.navbarEn AS navbarEn_99, t0.teaserEn AS teaserEn_100, t0.contentEn AS contentEn_101, t0.contentTwigEn AS contentTwigEn_102, t0.postCtaContentEn AS postCtaContentEn_103, t0.seoTitleEn AS seoTitleEn_104, t0.seoDescriptionEn AS seoDescriptionEn_105, t0.seoKeywordEn AS seoKeywordEn_106, t0.trainer AS trainer_107, t0.videolink AS videolink_108, t0.goToPage AS goToPage_109, t0.phrasesDe AS phrasesDe_110, t0.phrasesEn AS phrasesEn_111, t0.settings AS settings_112, t0.capacity AS capacity_113, t0.asssesmentDimensions AS asssesmentDimensions_114, t0.start AS start_115, t0.end AS end_116, t0.pitchTopic AS pitchTopic_117, t0.pitchImageLink AS pitchImageLink_118, t0.pitchVideoLink AS pitchVideoLink_119, t0.pitchPartner AS pitchPartner_120, t0.pitchPartnerId AS pitchPartnerId_121, t0.pitchDescription AS pitchDescription_122, t0.followUpPageContent AS followUpPageContent_123, t0.followUpPageDescription AS followUpPageDescription_124, t0.followUpPageCss AS followUpPageCss_125, t0.followUpPageJs AS followUpPageJs_126, t0.followUpPageFooterTemplate AS followUpPageFooterTemplate_127, t0.followUpPageTitle AS followUpPageTitle_128, t0.followUpDescription AS followUpDescription_129, t0.followUpVideoLink AS followUpVideoLink_130, t0.followUpPresentation AS followUpPresentation_131, t0.followUpSkoolUrl AS followUpSkoolUrl_132, t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_133, t0.followUpCtaText AS followUpCtaText_134, t0.followUpCtaUrl AS followUpCtaUrl_135, t0.followUpDocuments AS followUpDocuments_136, t0.followUpPhotos AS followUpPhotos_137, t0.followUpExtraLinks AS followUpExtraLinks_138, t0.followUpChecklist AS followUpChecklist_139, t0.pitchDate AS pitchDate_140, t0.pitchTime AS pitchTime_141, t0.prepitchDate AS prepitchDate_142, t0.scoutingEndDate AS scoutingEndDate_143, t0.applicationStartDate AS applicationStartDate_144, t0.applicationEndDate AS applicationEndDate_145, t0.interviewInviteStartDate AS interviewInviteStartDate_146, t0.interviewInviteEndDate AS interviewInviteEndDate_147, t0.interviewStartDate AS interviewStartDate_148, t0.interviewEndDate AS interviewEndDate_149, t0.decisionDate AS decisionDate_150, t0.contractDeadlineDate AS contractDeadlineDate_151, t0.finalReportDate AS finalReportDate_152, t0.applicationFormState AS applicationFormState_153, t0.googleCalendarUrl AS googleCalendarUrl_154, t0.city AS city_155, t0.applicationsCount AS applicationsCount_156, t0.startedCount AS startedCount_157, t0.appliedCount AS appliedCount_158, t0.approvedCount AS approvedCount_159, t0.rejectedCount AS rejectedCount_160, t0.$skoolWebhook AS skoolWebhook_161, t0.zapierWebhook AS zapierWebhook_162, t0.history AS history_163, t0.createdAt AS createdAt_164, t0.lastModified AS lastModified_165, t0.lastChangeUser AS lastChangeUser_166, t0.programId AS programId_167, t0.assessmentTeamId AS assessmentTeamId_168 FROM sp_batches t0 WHERE t0.id = ? Parameters: [`154`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.programId AS programId_2, t0.eventId AS eventId_3, t0.productId AS productId_4, t0.batchNumber AS batchNumber_5, t0.url AS url_6, t0.name AS name_7, t0.slug AS slug_8, t0.alias AS alias_9, t0.status AS status_10, t0.focusStatus AS focusStatus_11, t0.lang AS lang_12, t0.priceInEuroCent AS priceInEuroCent_13, t0.isTaxIncluded AS isTaxIncluded_14, t0.discount100MemberTags AS discount100MemberTags_15, t0.discount50MemberTags AS discount50MemberTags_16, t0.discount20MemberTags AS discount20MemberTags_17, t0.askForTeam AS askForTeam_18, t0.hasEvent AS hasEvent_19, t0.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_20, t0.hasIncludeTermsConsent AS hasIncludeTermsConsent_21, t0.hasIncludeLinkedIn AS hasIncludeLinkedIn_22, t0.hasIncludePhone AS hasIncludePhone_23, t0.hasRequirePhone AS hasRequirePhone_24, t0.hasFollowUp AS hasFollowUp_25, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, t0.isFutureEvent AS isFutureEvent_28, t0.visibility AS visibility_29, t0.access AS access_30, t0.tags AS tags_31, t0.typeformLink AS typeformLink_32, t0.zoomLink AS zoomLink_33, t0.bgImageUrl AS bgImageUrl_34, t0.startDate AS startDate_35, t0.endDate AS endDate_36, t0.taxBehavior AS taxBehavior_37, t0.paymentProvider AS paymentProvider_38, t0.isFreeForKiCampus AS isFreeForKiCampus_39, t0.isFreeForCommunity AS isFreeForCommunity_40, t0.registrationMode AS registrationMode_41, t0.externalRegistrationUrl AS externalRegistrationUrl_42, t0.externalPlatform AS externalPlatform_43, t0.registrationHeadline AS registrationHeadline_44, t0.registrationSubtitle AS registrationSubtitle_45, t0.registrationButtonText AS registrationButtonText_46, t0.registrationPriceHtml AS registrationPriceHtml_47, t0.registrationRedirectUrl AS registrationRedirectUrl_48, t0.lumaEventApiId AS lumaEventApiId_49, t0.meetupEventId AS meetupEventId_50, t0.meetupEventUrl AS meetupEventUrl_51, t0.mailDesignTemplate AS mailDesignTemplate_52, t0.senderMail AS senderMail_53, t0.fromName AS fromName_54, t0.recipientMonitoringMail AS recipientMonitoringMail_55, t0.confirmationMailSubject AS confirmationMailSubject_56, t0.confirmationMailContent AS confirmationMailContent_57, t0.adminNotificationMailSubject AS adminNotificationMailSubject_58, t0.adminNotificationMailContent AS adminNotificationMailContent_59, t0.reminderMailTemplateId AS reminderMailTemplateId_60, t0.reminderSenderEmail AS reminderSenderEmail_61, t0.reminderMailSendDate AS reminderMailSendDate_62, t0.reminderMailSubject AS reminderMailSubject_63, t0.reminderMailContent AS reminderMailContent_64, t0.$reminderMailStatus AS reminderMailStatus_65, t0.surveyId AS surveyId_66, t0.surveyMailTemplateId AS surveyMailTemplateId_67, t0.surveyBulkMailId AS surveyBulkMailId_68, t0.template AS template_69, t0.pageTemplate AS pageTemplate_70, t0.footerTemplate AS footerTemplate_71, t0.email AS email_72, t0.emailSubject AS emailSubject_73, t0.emailContent AS emailContent_74, t0.landingPageContent AS landingPageContent_75, t0.landingPageDescription AS landingPageDescription_76, t0.landingPageCss AS landingPageCss_77, t0.landingPageJs AS landingPageJs_78, t0.landingPageFooterTemplate AS landingPageFooterTemplate_79, t0.landingPageTitle AS landingPageTitle_80, t0.landingPageTwig AS landingPageTwig_81, t0.title AS title_82, t0.teaser AS teaser_83, t0.navbar AS navbar_84, t0.content AS content_85, t0.contentTwig AS contentTwig_86, t0.content_blocks AS content_blocks_87, t0.content_blocks_en AS content_blocks_en_88, t0.ctaContent AS ctaContent_89, t0.postCtaContent AS postCtaContent_90, t0.tagline AS tagline_91, t0.seoTitle AS seoTitle_92, t0.seoDescription AS seoDescription_93, t0.seoKeyword AS seoKeyword_94, t0.imagelink AS imagelink_95, t0.bgImagelink AS bgImagelink_96, t0.additionalCss AS additionalCss_97, t0.additionalJs AS additionalJs_98, t0.navbarEn AS navbarEn_99, t0.teaserEn AS teaserEn_100, t0.contentEn AS contentEn_101, t0.contentTwigEn AS contentTwigEn_102, t0.postCtaContentEn AS postCtaContentEn_103, t0.seoTitleEn AS seoTitleEn_104, t0.seoDescriptionEn AS seoDescriptionEn_105, t0.seoKeywordEn AS seoKeywordEn_106, t0.trainer AS trainer_107, t0.videolink AS videolink_108, t0.goToPage AS goToPage_109, t0.phrasesDe AS phrasesDe_110, t0.phrasesEn AS phrasesEn_111, t0.settings AS settings_112, t0.capacity AS capacity_113, t0.asssesmentDimensions AS asssesmentDimensions_114, t0.start AS start_115, t0.end AS end_116, t0.pitchTopic AS pitchTopic_117, t0.pitchImageLink AS pitchImageLink_118, t0.pitchVideoLink AS pitchVideoLink_119, t0.pitchPartner AS pitchPartner_120, t0.pitchPartnerId AS pitchPartnerId_121, t0.pitchDescription AS pitchDescription_122, t0.followUpPageContent AS followUpPageContent_123, t0.followUpPageDescription AS followUpPageDescription_124, t0.followUpPageCss AS followUpPageCss_125, t0.followUpPageJs AS followUpPageJs_126, t0.followUpPageFooterTemplate AS followUpPageFooterTemplate_127, t0.followUpPageTitle AS followUpPageTitle_128, t0.followUpDescription AS followUpDescription_129, t0.followUpVideoLink AS followUpVideoLink_130, t0.followUpPresentation AS followUpPresentation_131, t0.followUpSkoolUrl AS followUpSkoolUrl_132, t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_133, t0.followUpCtaText AS followUpCtaText_134, t0.followUpCtaUrl AS followUpCtaUrl_135, t0.followUpDocuments AS followUpDocuments_136, t0.followUpPhotos AS followUpPhotos_137, t0.followUpExtraLinks AS followUpExtraLinks_138, t0.followUpChecklist AS followUpChecklist_139, t0.pitchDate AS pitchDate_140, t0.pitchTime AS pitchTime_141, t0.prepitchDate AS prepitchDate_142, t0.scoutingEndDate AS scoutingEndDate_143, t0.applicationStartDate AS applicationStartDate_144, t0.applicationEndDate AS applicationEndDate_145, t0.interviewInviteStartDate AS interviewInviteStartDate_146, t0.interviewInviteEndDate AS interviewInviteEndDate_147, t0.interviewStartDate AS interviewStartDate_148, t0.interviewEndDate AS interviewEndDate_149, t0.decisionDate AS decisionDate_150, t0.contractDeadlineDate AS contractDeadlineDate_151, t0.finalReportDate AS finalReportDate_152, t0.applicationFormState AS applicationFormState_153, t0.googleCalendarUrl AS googleCalendarUrl_154, t0.city AS city_155, t0.applicationsCount AS applicationsCount_156, t0.startedCount AS startedCount_157, t0.appliedCount AS appliedCount_158, t0.approvedCount AS approvedCount_159, t0.rejectedCount AS rejectedCount_160, t0.$skoolWebhook AS skoolWebhook_161, t0.zapierWebhook AS zapierWebhook_162, t0.history AS history_163, t0.createdAt AS createdAt_164, t0.lastModified AS lastModified_165, t0.lastChangeUser AS lastChangeUser_166, t0.programId AS programId_167, t0.assessmentTeamId AS assessmentTeamId_168 FROM sp_batches t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.programId AS programId_2, t0.eventId AS eventId_3, t0.productId AS productId_4, t0.batchNumber AS batchNumber_5, t0.url AS url_6, t0.name AS name_7, t0.slug AS slug_8, t0.alias AS alias_9, t0.status AS status_10, t0.focusStatus AS focusStatus_11, t0.lang AS lang_12, t0.priceInEuroCent AS priceInEuroCent_13, t0.isTaxIncluded AS isTaxIncluded_14, t0.discount100MemberTags AS discount100MemberTags_15, t0.discount50MemberTags AS discount50MemberTags_16, t0.discount20MemberTags AS discount20MemberTags_17, t0.askForTeam AS askForTeam_18, t0.hasEvent AS hasEvent_19, t0.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_20, t0.hasIncludeTermsConsent AS hasIncludeTermsConsent_21, t0.hasIncludeLinkedIn AS hasIncludeLinkedIn_22, t0.hasIncludePhone AS hasIncludePhone_23, t0.hasRequirePhone AS hasRequirePhone_24, t0.hasFollowUp AS hasFollowUp_25, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, t0.isFutureEvent AS isFutureEvent_28, t0.visibility AS visibility_29, t0.access AS access_30, t0.tags AS tags_31, t0.typeformLink AS typeformLink_32, t0.zoomLink AS zoomLink_33, t0.bgImageUrl AS bgImageUrl_34, t0.startDate AS startDate_35, t0.endDate AS endDate_36, t0.taxBehavior AS taxBehavior_37, t0.paymentProvider AS paymentProvider_38, t0.isFreeForKiCampus AS isFreeForKiCampus_39, t0.isFreeForCommunity AS isFreeForCommunity_40, t0.registrationMode AS registrationMode_41, t0.externalRegistrationUrl AS externalRegistrationUrl_42, t0.externalPlatform AS externalPlatform_43, t0.registrationHeadline AS registrationHeadline_44, t0.registrationSubtitle AS registrationSubtitle_45, t0.registrationButtonText AS registrationButtonText_46, t0.registrationPriceHtml AS registrationPriceHtml_47, t0.registrationRedirectUrl AS registrationRedirectUrl_48, t0.lumaEventApiId AS lumaEventApiId_49, t0.meetupEventId AS meetupEventId_50, t0.meetupEventUrl AS meetupEventUrl_51, t0.mailDesignTemplate AS mailDesignTemplate_52, t0.senderMail AS senderMail_53, t0.fromName AS fromName_54, t0.recipientMonitoringMail AS recipientMonitoringMail_55, t0.confirmationMailSubject AS confirmationMailSubject_56, t0.confirmationMailContent AS confirmationMailContent_57, t0.adminNotificationMailSubject AS adminNotificationMailSubject_58, t0.adminNotificationMailContent AS adminNotificationMailContent_59, t0.reminderMailTemplateId AS reminderMailTemplateId_60, t0.reminderSenderEmail AS reminderSenderEmail_61, t0.reminderMailSendDate AS reminderMailSendDate_62, t0.reminderMailSubject AS reminderMailSubject_63, t0.reminderMailContent AS reminderMailContent_64, t0.$reminderMailStatus AS reminderMailStatus_65, t0.surveyId AS surveyId_66, t0.surveyMailTemplateId AS surveyMailTemplateId_67, t0.surveyBulkMailId AS surveyBulkMailId_68, t0.template AS template_69, t0.pageTemplate AS pageTemplate_70, t0.footerTemplate AS footerTemplate_71, t0.email AS email_72, t0.emailSubject AS emailSubject_73, t0.emailContent AS emailContent_74, t0.landingPageContent AS landingPageContent_75, t0.landingPageDescription AS landingPageDescription_76, t0.landingPageCss AS landingPageCss_77, t0.landingPageJs AS landingPageJs_78, t0.landingPageFooterTemplate AS landingPageFooterTemplate_79, t0.landingPageTitle AS landingPageTitle_80, t0.landingPageTwig AS landingPageTwig_81, t0.title AS title_82, t0.teaser AS teaser_83, t0.navbar AS navbar_84, t0.content AS content_85, t0.contentTwig AS contentTwig_86, t0.content_blocks AS content_blocks_87, t0.content_blocks_en AS content_blocks_en_88, t0.ctaContent AS ctaContent_89, t0.postCtaContent AS postCtaContent_90, t0.tagline AS tagline_91, t0.seoTitle AS seoTitle_92, t0.seoDescription AS seoDescription_93, t0.seoKeyword AS seoKeyword_94, t0.imagelink AS imagelink_95, t0.bgImagelink AS bgImagelink_96, t0.additionalCss AS additionalCss_97, t0.additionalJs AS additionalJs_98, t0.navbarEn AS navbarEn_99, t0.teaserEn AS teaserEn_100, t0.contentEn AS contentEn_101, t0.contentTwigEn AS contentTwigEn_102, t0.postCtaContentEn AS postCtaContentEn_103, t0.seoTitleEn AS seoTitleEn_104, t0.seoDescriptionEn AS seoDescriptionEn_105, t0.seoKeywordEn AS seoKeywordEn_106, t0.trainer AS trainer_107, t0.videolink AS videolink_108, t0.goToPage AS goToPage_109, t0.phrasesDe AS phrasesDe_110, t0.phrasesEn AS phrasesEn_111, t0.settings AS settings_112, t0.capacity AS capacity_113, t0.asssesmentDimensions AS asssesmentDimensions_114, t0.start AS start_115, t0.end AS end_116, t0.pitchTopic AS pitchTopic_117, t0.pitchImageLink AS pitchImageLink_118, t0.pitchVideoLink AS pitchVideoLink_119, t0.pitchPartner AS pitchPartner_120, t0.pitchPartnerId AS pitchPartnerId_121, t0.pitchDescription AS pitchDescription_122, t0.followUpPageContent AS followUpPageContent_123, t0.followUpPageDescription AS followUpPageDescription_124, t0.followUpPageCss AS followUpPageCss_125, t0.followUpPageJs AS followUpPageJs_126, t0.followUpPageFooterTemplate AS followUpPageFooterTemplate_127, t0.followUpPageTitle AS followUpPageTitle_128, t0.followUpDescription AS followUpDescription_129, t0.followUpVideoLink AS followUpVideoLink_130, t0.followUpPresentation AS followUpPresentation_131, t0.followUpSkoolUrl AS followUpSkoolUrl_132, t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_133, t0.followUpCtaText AS followUpCtaText_134, t0.followUpCtaUrl AS followUpCtaUrl_135, t0.followUpDocuments AS followUpDocuments_136, t0.followUpPhotos AS followUpPhotos_137, t0.followUpExtraLinks AS followUpExtraLinks_138, t0.followUpChecklist AS followUpChecklist_139, t0.pitchDate AS pitchDate_140, t0.pitchTime AS pitchTime_141, t0.prepitchDate AS prepitchDate_142, t0.scoutingEndDate AS scoutingEndDate_143, t0.applicationStartDate AS applicationStartDate_144, t0.applicationEndDate AS applicationEndDate_145, t0.interviewInviteStartDate AS interviewInviteStartDate_146, t0.interviewInviteEndDate AS interviewInviteEndDate_147, t0.interviewStartDate AS interviewStartDate_148, t0.interviewEndDate AS interviewEndDate_149, t0.decisionDate AS decisionDate_150, t0.contractDeadlineDate AS contractDeadlineDate_151, t0.finalReportDate AS finalReportDate_152, t0.applicationFormState AS applicationFormState_153, t0.googleCalendarUrl AS googleCalendarUrl_154, t0.city AS city_155, t0.applicationsCount AS applicationsCount_156, t0.startedCount AS startedCount_157, t0.appliedCount AS appliedCount_158, t0.approvedCount AS approvedCount_159, t0.rejectedCount AS rejectedCount_160, t0.$skoolWebhook AS skoolWebhook_161, t0.zapierWebhook AS zapierWebhook_162, t0.history AS history_163, t0.createdAt AS createdAt_164, t0.lastModified AS lastModified_165, t0.lastChangeUser AS lastChangeUser_166, t0.programId AS programId_167, t0.assessmentTeamId AS assessmentTeamId_168 FROM sp_batches t0 WHERE t0.id = 154;
5	2.89 ms	SELECT s0_.startupName AS startupName_0, s0_.pitchPosition AS pitchPosition_1, s0_.programName AS programName_2, s0_.batchName AS batchName_3, s1_.pitchDate AS pitchDate_4, s1_.city AS city_5 FROM sp_applications s0_ INNER JOIN sp_batches s1_ ON (s0_.batchId = s1_.id) WHERE s0_.startupId = ? AND s0_.programId = ? Parameters: [`"3001037" 1`] View formatted query View runnable query Explain query SELECT s0_.startupName AS startupName_0, s0_.pitchPosition AS pitchPosition_1, s0_.programName AS programName_2, s0_.batchName AS batchName_3, s1_.pitchDate AS pitchDate_4, s1_.city AS city_5 FROM sp_applications s0_ INNER JOIN sp_batches s1_ ON (s0_.batchId = s1_.id) WHERE s0_.startupId = ? AND s0_.programId = ? SELECT s0_.startupName AS startupName_0, s0_.pitchPosition AS pitchPosition_1, s0_.programName AS programName_2, s0_.batchName AS batchName_3, s1_.pitchDate AS pitchDate_4, s1_.city AS city_5 FROM sp_applications s0_ INNER JOIN sp_batches s1_ ON (s0_.batchId = s1_.id) WHERE s0_.startupId = '3001037' AND s0_.programId = 1;
6	1.28 ms	SELECT s0_.id AS id_0, s0_.score AS score_1, s0_.completenessScore AS completenessScore_2, s0_.status AS status_3, s0_.location AS location_4, s0_.salutation AS salutation_5, s0_.title AS title_6, s0_.jobTitle AS jobTitle_7, s0_.firstName AS firstName_8, s0_.lastName AS lastName_9, s0_.name AS name_10, s0_.sortName AS sortName_11, s0_.email AS email_12, s0_.secondaryEmail AS secondaryEmail_13, s0_.phone AS phone_14, s0_.hasCommunityMembership AS hasCommunityMembership_15, s0_.utm_source AS utm_source_16, s0_.utm_medium AS utm_medium_17, s0_.utm_campaign AS utm_campaign_18, s0_.utm_term AS utm_term_19, s0_.utm_content AS utm_content_20, s0_.birthday AS birthday_21, s0_.addressFieldOne AS addressFieldOne_22, s0_.addressFieldTwo AS addressFieldTwo_23, s0_.addressCountryCode AS addressCountryCode_24, s0_.addressPostalCode AS addressPostalCode_25, s0_.addressCity AS addressCity_26, s0_.teamId AS teamId_27, s0_.teamName AS teamName_28, s0_.company AS company_29, s0_.history AS history_30, s0_.tags AS tags_31, s0_.annotation AS annotation_32, s0_.mentorBuckets AS mentorBuckets_33, s0_.areasOfExpertise AS areasOfExpertise_34, s0_.mentor_firma AS mentor_firma_35, s0_.mentor_firma_url AS mentor_firma_url_36, s0_.mentor_locations AS mentor_locations_37, s0_.mentor_profile AS mentor_profile_38, s0_.mentor_note AS mentor_note_39, s0_.mentor_admin_rating AS mentor_admin_rating_40, s0_.active AS active_41, s0_.tiefgarage AS tiefgarage_42, s0_.transponder AS transponder_43, s0_.isTransponderAllowed AS isTransponderAllowed_44, s0_.imageLink AS imageLink_45, s0_.homepage AS homepage_46, s0_.xing AS xing_47, s0_.pipedriveId AS pipedriveId_48, s0_.linkedin AS linkedin_49, s0_.facebook AS facebook_50, s0_.instagram AS instagram_51, s0_.tiktok AS tiktok_52, s0_.threads AS threads_53, s0_.youtube AS youtube_54, s0_.twitter AS twitter_55, s0_.github AS github_56, s0_.reachableLocation AS reachableLocation_57, s0_.skills AS skills_58, s0_.description AS description_59, s0_.isVisibleInNetworking AS isVisibleInNetworking_60, s0_.gender AS gender_61, s0_.currentFocus AS currentFocus_62, s0_.networkingConsentAt AS networkingConsentAt_63, s0_.networkingConsentVersion AS networkingConsentVersion_64, s0_.networkingConsentRevokedAt AS networkingConsentRevokedAt_65, s0_.touchpoints AS touchpoints_66, s0_.isAddressComplete AS isAddressComplete_67, s0_.hasMailchimp AS hasMailchimp_68, s0_.hasKiNewsletter AS hasKiNewsletter_69, s0_.hubspotSyncPending AS hubspotSyncPending_70, s0_.enterDate AS enterDate_71, s0_.exitDate AS exitDate_72, s0_.physicalMembershipStarted AS physicalMembershipStarted_73, s0_.physicalMembershipEnded AS physicalMembershipEnded_74, s0_.lastModified AS lastModified_75, s0_.lastChangeUser AS lastChangeUser_76, s0_.onboardingCompletedAt AS onboardingCompletedAt_77, s0_.nAiWebinarsAttended AS nAiWebinarsAttended_78, s0_.nAiWebinarsApplied AS nAiWebinarsApplied_79, s0_.nAiEventsAttended AS nAiEventsAttended_80, s0_.nAiEventsApplied AS nAiEventsApplied_81, s0_.nPaidAttended AS nPaidAttended_82, s0_.nPaidApplied AS nPaidApplied_83, s0_.nKiEinstiegAttended AS nKiEinstiegAttended_84, s0_.nKiEinstiegApplied AS nKiEinstiegApplied_85, s0_.nPromptEngineeringAttended AS nPromptEngineeringAttended_86, s0_.nPromptEngineeringApplied AS nPromptEngineeringApplied_87, s0_.nEcodynamicsAttended AS nEcodynamicsAttended_88, s0_.nEcodynamicsApplied AS nEcodynamicsApplied_89, s0_.nBbqApplied AS nBbqApplied_90, s0_.nAiFridayApplied AS nAiFridayApplied_91, s0_.nAiGatheringApplied AS nAiGatheringApplied_92, s0_.nAiGatheringAttended AS nAiGatheringAttended_93, s0_.aiSs24Applied AS aiSs24Applied_94, s0_.aiSs24Booked AS aiSs24Booked_95, s0_.interestedIn AS interestedIn_96, s0_.interests AS interests_97, s0_.mentorMetadata AS mentorMetadata_98, s0_.eventParticipations AS eventParticipations_99, s0_.kiKompetenz AS kiKompetenz_100, s0_.mentorOwnerId AS mentorOwnerId_101 FROM sp_members s0_, sp_member_teams s1_ WHERE s0_.id = s1_.member_id AND s1_.team_id = ? ORDER BY s0_.firstName ASC, s0_.lastName ASC Parameters: [`16802`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.score AS score_1, s0_.completenessScore AS completenessScore_2, s0_.status AS status_3, s0_.location AS location_4, s0_.salutation AS salutation_5, s0_.title AS title_6, s0_.jobTitle AS jobTitle_7, s0_.firstName AS firstName_8, s0_.lastName AS lastName_9, s0_.name AS name_10, s0_.sortName AS sortName_11, s0_.email AS email_12, s0_.secondaryEmail AS secondaryEmail_13, s0_.phone AS phone_14, s0_.hasCommunityMembership AS hasCommunityMembership_15, s0_.utm_source AS utm_source_16, s0_.utm_medium AS utm_medium_17, s0_.utm_campaign AS utm_campaign_18, s0_.utm_term AS utm_term_19, s0_.utm_content AS utm_content_20, s0_.birthday AS birthday_21, s0_.addressFieldOne AS addressFieldOne_22, s0_.addressFieldTwo AS addressFieldTwo_23, s0_.addressCountryCode AS addressCountryCode_24, s0_.addressPostalCode AS addressPostalCode_25, s0_.addressCity AS addressCity_26, s0_.teamId AS teamId_27, s0_.teamName AS teamName_28, s0_.company AS company_29, s0_.history AS history_30, s0_.tags AS tags_31, s0_.annotation AS annotation_32, s0_.mentorBuckets AS mentorBuckets_33, s0_.areasOfExpertise AS areasOfExpertise_34, s0_.mentor_firma AS mentor_firma_35, s0_.mentor_firma_url AS mentor_firma_url_36, s0_.mentor_locations AS mentor_locations_37, s0_.mentor_profile AS mentor_profile_38, s0_.mentor_note AS mentor_note_39, s0_.mentor_admin_rating AS mentor_admin_rating_40, s0_.active AS active_41, s0_.tiefgarage AS tiefgarage_42, s0_.transponder AS transponder_43, s0_.isTransponderAllowed AS isTransponderAllowed_44, s0_.imageLink AS imageLink_45, s0_.homepage AS homepage_46, s0_.xing AS xing_47, s0_.pipedriveId AS pipedriveId_48, s0_.linkedin AS linkedin_49, s0_.facebook AS facebook_50, s0_.instagram AS instagram_51, s0_.tiktok AS tiktok_52, s0_.threads AS threads_53, s0_.youtube AS youtube_54, s0_.twitter AS twitter_55, s0_.github AS github_56, s0_.reachableLocation AS reachableLocation_57, s0_.skills AS skills_58, s0_.description AS description_59, s0_.isVisibleInNetworking AS isVisibleInNetworking_60, s0_.gender AS gender_61, s0_.currentFocus AS currentFocus_62, s0_.networkingConsentAt AS networkingConsentAt_63, s0_.networkingConsentVersion AS networkingConsentVersion_64, s0_.networkingConsentRevokedAt AS networkingConsentRevokedAt_65, s0_.touchpoints AS touchpoints_66, s0_.isAddressComplete AS isAddressComplete_67, s0_.hasMailchimp AS hasMailchimp_68, s0_.hasKiNewsletter AS hasKiNewsletter_69, s0_.hubspotSyncPending AS hubspotSyncPending_70, s0_.enterDate AS enterDate_71, s0_.exitDate AS exitDate_72, s0_.physicalMembershipStarted AS physicalMembershipStarted_73, s0_.physicalMembershipEnded AS physicalMembershipEnded_74, s0_.lastModified AS lastModified_75, s0_.lastChangeUser AS lastChangeUser_76, s0_.onboardingCompletedAt AS onboardingCompletedAt_77, s0_.nAiWebinarsAttended AS nAiWebinarsAttended_78, s0_.nAiWebinarsApplied AS nAiWebinarsApplied_79, s0_.nAiEventsAttended AS nAiEventsAttended_80, s0_.nAiEventsApplied AS nAiEventsApplied_81, s0_.nPaidAttended AS nPaidAttended_82, s0_.nPaidApplied AS nPaidApplied_83, s0_.nKiEinstiegAttended AS nKiEinstiegAttended_84, s0_.nKiEinstiegApplied AS nKiEinstiegApplied_85, s0_.nPromptEngineeringAttended AS nPromptEngineeringAttended_86, s0_.nPromptEngineeringApplied AS nPromptEngineeringApplied_87, s0_.nEcodynamicsAttended AS nEcodynamicsAttended_88, s0_.nEcodynamicsApplied AS nEcodynamicsApplied_89, s0_.nBbqApplied AS nBbqApplied_90, s0_.nAiFridayApplied AS nAiFridayApplied_91, s0_.nAiGatheringApplied AS nAiGatheringApplied_92, s0_.nAiGatheringAttended AS nAiGatheringAttended_93, s0_.aiSs24Applied AS aiSs24Applied_94, s0_.aiSs24Booked AS aiSs24Booked_95, s0_.interestedIn AS interestedIn_96, s0_.interests AS interests_97, s0_.mentorMetadata AS mentorMetadata_98, s0_.eventParticipations AS eventParticipations_99, s0_.kiKompetenz AS kiKompetenz_100, s0_.mentorOwnerId AS mentorOwnerId_101 FROM sp_members s0_, sp_member_teams s1_ WHERE s0_.id = s1_.member_id AND s1_.team_id = ? ORDER BY s0_.firstName ASC, s0_.lastName ASC SELECT s0_.id AS id_0, s0_.score AS score_1, s0_.completenessScore AS completenessScore_2, s0_.status AS status_3, s0_.location AS location_4, s0_.salutation AS salutation_5, s0_.title AS title_6, s0_.jobTitle AS jobTitle_7, s0_.firstName AS firstName_8, s0_.lastName AS lastName_9, s0_.name AS name_10, s0_.sortName AS sortName_11, s0_.email AS email_12, s0_.secondaryEmail AS secondaryEmail_13, s0_.phone AS phone_14, s0_.hasCommunityMembership AS hasCommunityMembership_15, s0_.utm_source AS utm_source_16, s0_.utm_medium AS utm_medium_17, s0_.utm_campaign AS utm_campaign_18, s0_.utm_term AS utm_term_19, s0_.utm_content AS utm_content_20, s0_.birthday AS birthday_21, s0_.addressFieldOne AS addressFieldOne_22, s0_.addressFieldTwo AS addressFieldTwo_23, s0_.addressCountryCode AS addressCountryCode_24, s0_.addressPostalCode AS addressPostalCode_25, s0_.addressCity AS addressCity_26, s0_.teamId AS teamId_27, s0_.teamName AS teamName_28, s0_.company AS company_29, s0_.history AS history_30, s0_.tags AS tags_31, s0_.annotation AS annotation_32, s0_.mentorBuckets AS mentorBuckets_33, s0_.areasOfExpertise AS areasOfExpertise_34, s0_.mentor_firma AS mentor_firma_35, s0_.mentor_firma_url AS mentor_firma_url_36, s0_.mentor_locations AS mentor_locations_37, s0_.mentor_profile AS mentor_profile_38, s0_.mentor_note AS mentor_note_39, s0_.mentor_admin_rating AS mentor_admin_rating_40, s0_.active AS active_41, s0_.tiefgarage AS tiefgarage_42, s0_.transponder AS transponder_43, s0_.isTransponderAllowed AS isTransponderAllowed_44, s0_.imageLink AS imageLink_45, s0_.homepage AS homepage_46, s0_.xing AS xing_47, s0_.pipedriveId AS pipedriveId_48, s0_.linkedin AS linkedin_49, s0_.facebook AS facebook_50, s0_.instagram AS instagram_51, s0_.tiktok AS tiktok_52, s0_.threads AS threads_53, s0_.youtube AS youtube_54, s0_.twitter AS twitter_55, s0_.github AS github_56, s0_.reachableLocation AS reachableLocation_57, s0_.skills AS skills_58, s0_.description AS description_59, s0_.isVisibleInNetworking AS isVisibleInNetworking_60, s0_.gender AS gender_61, s0_.currentFocus AS currentFocus_62, s0_.networkingConsentAt AS networkingConsentAt_63, s0_.networkingConsentVersion AS networkingConsentVersion_64, s0_.networkingConsentRevokedAt AS networkingConsentRevokedAt_65, s0_.touchpoints AS touchpoints_66, s0_.isAddressComplete AS isAddressComplete_67, s0_.hasMailchimp AS hasMailchimp_68, s0_.hasKiNewsletter AS hasKiNewsletter_69, s0_.hubspotSyncPending AS hubspotSyncPending_70, s0_.enterDate AS enterDate_71, s0_.exitDate AS exitDate_72, s0_.physicalMembershipStarted AS physicalMembershipStarted_73, s0_.physicalMembershipEnded AS physicalMembershipEnded_74, s0_.lastModified AS lastModified_75, s0_.lastChangeUser AS lastChangeUser_76, s0_.onboardingCompletedAt AS onboardingCompletedAt_77, s0_.nAiWebinarsAttended AS nAiWebinarsAttended_78, s0_.nAiWebinarsApplied AS nAiWebinarsApplied_79, s0_.nAiEventsAttended AS nAiEventsAttended_80, s0_.nAiEventsApplied AS nAiEventsApplied_81, s0_.nPaidAttended AS nPaidAttended_82, s0_.nPaidApplied AS nPaidApplied_83, s0_.nKiEinstiegAttended AS nKiEinstiegAttended_84, s0_.nKiEinstiegApplied AS nKiEinstiegApplied_85, s0_.nPromptEngineeringAttended AS nPromptEngineeringAttended_86, s0_.nPromptEngineeringApplied AS nPromptEngineeringApplied_87, s0_.nEcodynamicsAttended AS nEcodynamicsAttended_88, s0_.nEcodynamicsApplied AS nEcodynamicsApplied_89, s0_.nBbqApplied AS nBbqApplied_90, s0_.nAiFridayApplied AS nAiFridayApplied_91, s0_.nAiGatheringApplied AS nAiGatheringApplied_92, s0_.nAiGatheringAttended AS nAiGatheringAttended_93, s0_.aiSs24Applied AS aiSs24Applied_94, s0_.aiSs24Booked AS aiSs24Booked_95, s0_.interestedIn AS interestedIn_96, s0_.interests AS interests_97, s0_.mentorMetadata AS mentorMetadata_98, s0_.eventParticipations AS eventParticipations_99, s0_.kiKompetenz AS kiKompetenz_100, s0_.mentorOwnerId AS mentorOwnerId_101 FROM sp_members s0_, sp_member_teams s1_ WHERE s0_.id = s1_.member_id AND s1_.team_id = 16802 ORDER BY s0_.firstName ASC, s0_.lastName ASC;
7	8.03 ms	SELECT t0.id AS id_1, t0.startupId AS startupId_2, t0.programId AS programId_3, t0.batchId AS batchId_4, t0.metaLeadId AS metaLeadId_5, t0.metaFormId AS metaFormId_6, t0.utm_source AS utm_source_7, t0.utm_medium AS utm_medium_8, t0.utm_campaign AS utm_campaign_9, t0.utm_term AS utm_term_10, t0.utm_content AS utm_content_11, t0.votesRegistered AS votesRegistered_12, t0.programName AS programName_13, t0.programSlug AS programSlug_14, t0.batchName AS batchName_15, t0.batchSlug AS batchSlug_16, t0.template AS template_17, t0.teamId AS teamId_18, t0.memberId AS memberId_19, t0.lang AS lang_20, t0.startupName AS startupName_21, t0.visibility AS visibility_22, t0.firstName AS firstName_23, t0.lastName AS lastName_24, t0.person AS person_25, t0.email AS email_26, t0.secondaryEmail AS secondaryEmail_27, t0.phone AS phone_28, t0.linkedin AS linkedin_29, t0.telegram AS telegram_30, t0.discord AS discord_31, t0.wallet AS wallet_32, t0.teamSize AS teamSize_33, t0.city AS city_34, t0.startupStage AS startupStage_35, t0.industry AS industry_36, t0.track AS track_37, t0.projectCategory AS projectCategory_38, t0.blockchain AS blockchain_39, t0.recommendedBy AS recommendedBy_40, t0.editStatus AS editStatus_41, t0.editMessage AS editMessage_42, t0.applicationStatus AS applicationStatus_43, t0.reviewStatus AS reviewStatus_44, t0.pendingDecision AS pendingDecision_45, t0.isNewMember AS isNewMember_46, t0.hasConfirmationMailSent AS hasConfirmationMailSent_47, t0.hasTermsAccepted AS hasTermsAccepted_48, t0.batchStatus AS batchStatus_49, t0.selectionStatus AS selectionStatus_50, t0.participationStatus AS participationStatus_51, t0.coachMemberId AS coachMemberId_52, t0.participationStartedAt AS participationStartedAt_53, t0.participationCompletedAt AS participationCompletedAt_54, t0.pitchPosition AS pitchPosition_55, t0.pitchImageLink AS pitchImageLink_56, t0.pitchVideoLink AS pitchVideoLink_57, t0.linkPitchDeck AS linkPitchDeck_58, t0.publicIdPitchDeck AS publicIdPitchDeck_59, t0.ideaPaperUrl AS ideaPaperUrl_60, t0.publicIdIdeaPaper AS publicIdIdeaPaper_61, t0.websiteUrl AS websiteUrl_62, t0.fulltime AS fulltime_63, t0.language AS language_64, t0.mvpStatus AS mvpStatus_65, t0.dealroomUrl AS dealroomUrl_66, t0.podioId AS podioId_67, t0.podioItemId AS podioItemId_68, t0.podioUrl AS podioUrl_69, t0.ideaPitch AS ideaPitch_70, t0.createdAt AS createdAt_71, t0.lastModified AS lastModified_72, t0.deletedAt AS deletedAt_73, t0.lastChangeUser AS lastChangeUser_74, t0.history AS history_75, t0.extraFields AS extraFields_76, t0.adminNotes AS adminNotes_77, t0.ratingJudge1 AS ratingJudge1_78, t0.ratingJudge2 AS ratingJudge2_79, t0.ratingJudge3 AS ratingJudge3_80, t0.ratingJudge4 AS ratingJudge4_81, t0.ratingJudge5 AS ratingJudge5_82, t0.ratingAverage AS ratingAverage_83, t0.ratingUpdatedAt AS ratingUpdatedAt_84, t0.memberTagsAtRegistration AS memberTagsAtRegistration_85, t0.wasCommunityMemberAtRegistration AS wasCommunityMemberAtRegistration_86, t0.wasPhysicalMemberAtRegistration AS wasPhysicalMemberAtRegistration_87, t0.memberUtmSourceAtRegistration AS memberUtmSourceAtRegistration_88, t0.kiKompetenzAtRegistration AS kiKompetenzAtRegistration_89, t0.pendingMemberData AS pendingMemberData_90, t0.pendingTeamData AS pendingTeamData_91, t0.resumeToken AS resumeToken_92, t0.resumeTokenExpiresAt AS resumeTokenExpiresAt_93, t0.isMemberCreated AS isMemberCreated_94, t0.isTeamCreated AS isTeamCreated_95 FROM sp_applications t0 WHERE t0.teamId = ? AND t0.programId IN (?, ?, ?) Parameters: [`16802 "1" "2" "3"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.startupId AS startupId_2, t0.programId AS programId_3, t0.batchId AS batchId_4, t0.metaLeadId AS metaLeadId_5, t0.metaFormId AS metaFormId_6, t0.utm_source AS utm_source_7, t0.utm_medium AS utm_medium_8, t0.utm_campaign AS utm_campaign_9, t0.utm_term AS utm_term_10, t0.utm_content AS utm_content_11, t0.votesRegistered AS votesRegistered_12, t0.programName AS programName_13, t0.programSlug AS programSlug_14, t0.batchName AS batchName_15, t0.batchSlug AS batchSlug_16, t0.template AS template_17, t0.teamId AS teamId_18, t0.memberId AS memberId_19, t0.lang AS lang_20, t0.startupName AS startupName_21, t0.visibility AS visibility_22, t0.firstName AS firstName_23, t0.lastName AS lastName_24, t0.person AS person_25, t0.email AS email_26, t0.secondaryEmail AS secondaryEmail_27, t0.phone AS phone_28, t0.linkedin AS linkedin_29, t0.telegram AS telegram_30, t0.discord AS discord_31, t0.wallet AS wallet_32, t0.teamSize AS teamSize_33, t0.city AS city_34, t0.startupStage AS startupStage_35, t0.industry AS industry_36, t0.track AS track_37, t0.projectCategory AS projectCategory_38, t0.blockchain AS blockchain_39, t0.recommendedBy AS recommendedBy_40, t0.editStatus AS editStatus_41, t0.editMessage AS editMessage_42, t0.applicationStatus AS applicationStatus_43, t0.reviewStatus AS reviewStatus_44, t0.pendingDecision AS pendingDecision_45, t0.isNewMember AS isNewMember_46, t0.hasConfirmationMailSent AS hasConfirmationMailSent_47, t0.hasTermsAccepted AS hasTermsAccepted_48, t0.batchStatus AS batchStatus_49, t0.selectionStatus AS selectionStatus_50, t0.participationStatus AS participationStatus_51, t0.coachMemberId AS coachMemberId_52, t0.participationStartedAt AS participationStartedAt_53, t0.participationCompletedAt AS participationCompletedAt_54, t0.pitchPosition AS pitchPosition_55, t0.pitchImageLink AS pitchImageLink_56, t0.pitchVideoLink AS pitchVideoLink_57, t0.linkPitchDeck AS linkPitchDeck_58, t0.publicIdPitchDeck AS publicIdPitchDeck_59, t0.ideaPaperUrl AS ideaPaperUrl_60, t0.publicIdIdeaPaper AS publicIdIdeaPaper_61, t0.websiteUrl AS websiteUrl_62, t0.fulltime AS fulltime_63, t0.language AS language_64, t0.mvpStatus AS mvpStatus_65, t0.dealroomUrl AS dealroomUrl_66, t0.podioId AS podioId_67, t0.podioItemId AS podioItemId_68, t0.podioUrl AS podioUrl_69, t0.ideaPitch AS ideaPitch_70, t0.createdAt AS createdAt_71, t0.lastModified AS lastModified_72, t0.deletedAt AS deletedAt_73, t0.lastChangeUser AS lastChangeUser_74, t0.history AS history_75, t0.extraFields AS extraFields_76, t0.adminNotes AS adminNotes_77, t0.ratingJudge1 AS ratingJudge1_78, t0.ratingJudge2 AS ratingJudge2_79, t0.ratingJudge3 AS ratingJudge3_80, t0.ratingJudge4 AS ratingJudge4_81, t0.ratingJudge5 AS ratingJudge5_82, t0.ratingAverage AS ratingAverage_83, t0.ratingUpdatedAt AS ratingUpdatedAt_84, t0.memberTagsAtRegistration AS memberTagsAtRegistration_85, t0.wasCommunityMemberAtRegistration AS wasCommunityMemberAtRegistration_86, t0.wasPhysicalMemberAtRegistration AS wasPhysicalMemberAtRegistration_87, t0.memberUtmSourceAtRegistration AS memberUtmSourceAtRegistration_88, t0.kiKompetenzAtRegistration AS kiKompetenzAtRegistration_89, t0.pendingMemberData AS pendingMemberData_90, t0.pendingTeamData AS pendingTeamData_91, t0.resumeToken AS resumeToken_92, t0.resumeTokenExpiresAt AS resumeTokenExpiresAt_93, t0.isMemberCreated AS isMemberCreated_94, t0.isTeamCreated AS isTeamCreated_95 FROM sp_applications t0 WHERE t0.teamId = ? AND t0.programId IN (?, ?, ?) SELECT t0.id AS id_1, t0.startupId AS startupId_2, t0.programId AS programId_3, t0.batchId AS batchId_4, t0.metaLeadId AS metaLeadId_5, t0.metaFormId AS metaFormId_6, t0.utm_source AS utm_source_7, t0.utm_medium AS utm_medium_8, t0.utm_campaign AS utm_campaign_9, t0.utm_term AS utm_term_10, t0.utm_content AS utm_content_11, t0.votesRegistered AS votesRegistered_12, t0.programName AS programName_13, t0.programSlug AS programSlug_14, t0.batchName AS batchName_15, t0.batchSlug AS batchSlug_16, t0.template AS template_17, t0.teamId AS teamId_18, t0.memberId AS memberId_19, t0.lang AS lang_20, t0.startupName AS startupName_21, t0.visibility AS visibility_22, t0.firstName AS firstName_23, t0.lastName AS lastName_24, t0.person AS person_25, t0.email AS email_26, t0.secondaryEmail AS secondaryEmail_27, t0.phone AS phone_28, t0.linkedin AS linkedin_29, t0.telegram AS telegram_30, t0.discord AS discord_31, t0.wallet AS wallet_32, t0.teamSize AS teamSize_33, t0.city AS city_34, t0.startupStage AS startupStage_35, t0.industry AS industry_36, t0.track AS track_37, t0.projectCategory AS projectCategory_38, t0.blockchain AS blockchain_39, t0.recommendedBy AS recommendedBy_40, t0.editStatus AS editStatus_41, t0.editMessage AS editMessage_42, t0.applicationStatus AS applicationStatus_43, t0.reviewStatus AS reviewStatus_44, t0.pendingDecision AS pendingDecision_45, t0.isNewMember AS isNewMember_46, t0.hasConfirmationMailSent AS hasConfirmationMailSent_47, t0.hasTermsAccepted AS hasTermsAccepted_48, t0.batchStatus AS batchStatus_49, t0.selectionStatus AS selectionStatus_50, t0.participationStatus AS participationStatus_51, t0.coachMemberId AS coachMemberId_52, t0.participationStartedAt AS participationStartedAt_53, t0.participationCompletedAt AS participationCompletedAt_54, t0.pitchPosition AS pitchPosition_55, t0.pitchImageLink AS pitchImageLink_56, t0.pitchVideoLink AS pitchVideoLink_57, t0.linkPitchDeck AS linkPitchDeck_58, t0.publicIdPitchDeck AS publicIdPitchDeck_59, t0.ideaPaperUrl AS ideaPaperUrl_60, t0.publicIdIdeaPaper AS publicIdIdeaPaper_61, t0.websiteUrl AS websiteUrl_62, t0.fulltime AS fulltime_63, t0.language AS language_64, t0.mvpStatus AS mvpStatus_65, t0.dealroomUrl AS dealroomUrl_66, t0.podioId AS podioId_67, t0.podioItemId AS podioItemId_68, t0.podioUrl AS podioUrl_69, t0.ideaPitch AS ideaPitch_70, t0.createdAt AS createdAt_71, t0.lastModified AS lastModified_72, t0.deletedAt AS deletedAt_73, t0.lastChangeUser AS lastChangeUser_74, t0.history AS history_75, t0.extraFields AS extraFields_76, t0.adminNotes AS adminNotes_77, t0.ratingJudge1 AS ratingJudge1_78, t0.ratingJudge2 AS ratingJudge2_79, t0.ratingJudge3 AS ratingJudge3_80, t0.ratingJudge4 AS ratingJudge4_81, t0.ratingJudge5 AS ratingJudge5_82, t0.ratingAverage AS ratingAverage_83, t0.ratingUpdatedAt AS ratingUpdatedAt_84, t0.memberTagsAtRegistration AS memberTagsAtRegistration_85, t0.wasCommunityMemberAtRegistration AS wasCommunityMemberAtRegistration_86, t0.wasPhysicalMemberAtRegistration AS wasPhysicalMemberAtRegistration_87, t0.memberUtmSourceAtRegistration AS memberUtmSourceAtRegistration_88, t0.kiKompetenzAtRegistration AS kiKompetenzAtRegistration_89, t0.pendingMemberData AS pendingMemberData_90, t0.pendingTeamData AS pendingTeamData_91, t0.resumeToken AS resumeToken_92, t0.resumeTokenExpiresAt AS resumeTokenExpiresAt_93, t0.isMemberCreated AS isMemberCreated_94, t0.isTeamCreated AS isTeamCreated_95 FROM sp_applications t0 WHERE t0.teamId = 16802 AND t0.programId IN ('1', '2', '3');
8	0.30 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s1_.type AS type_2, s0_.email AS email_3 FROM sp_member_teams s1_ INNER JOIN sp_members s0_ ON (s1_.member_id = s0_.id) WHERE s1_.team_id = ? Parameters: [`"3001037"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s1_.type AS type_2, s0_.email AS email_3 FROM sp_member_teams s1_ INNER JOIN sp_members s0_ ON (s1_.member_id = s0_.id) WHERE s1_.team_id = ? SELECT s0_.id AS id_0, s0_.name AS name_1, s1_.type AS type_2, s0_.email AS email_3 FROM sp_member_teams s1_ INNER JOIN sp_members s0_ ON (s1_.member_id = s0_.id) WHERE s1_.team_id = '3001037';
9	2.41 ms	SELECT s0_.id AS id_0, s0_.owner AS owner_1, s0_.type AS type_2, s0_.externalId AS externalId_3, s0_.score AS score_4, s0_.name AS name_5, s0_.title AS title_6, s0_.imageLink AS imageLink_7, s0_.categories AS categories_8, s0_.tags AS tags_9, s0_.isActive AS isActive_10, s0_.lastModified AS lastModified_11, s0_.lastChangeUser AS lastChangeUser_12, s0_.createdAt AS createdAt_13, s0_.rankingScore AS rankingScore_14, s0_.eventStartDate AS eventStartDate_15, s0_.jobEndDate AS jobEndDate_16, s0_.rankingUpdatedAt AS rankingUpdatedAt_17 FROM sp_content_feed s0_ WHERE s0_.tags LIKE ? ORDER BY s0_.score DESC Parameters: [`"%"holybag"%"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.owner AS owner_1, s0_.type AS type_2, s0_.externalId AS externalId_3, s0_.score AS score_4, s0_.name AS name_5, s0_.title AS title_6, s0_.imageLink AS imageLink_7, s0_.categories AS categories_8, s0_.tags AS tags_9, s0_.isActive AS isActive_10, s0_.lastModified AS lastModified_11, s0_.lastChangeUser AS lastChangeUser_12, s0_.createdAt AS createdAt_13, s0_.rankingScore AS rankingScore_14, s0_.eventStartDate AS eventStartDate_15, s0_.jobEndDate AS jobEndDate_16, s0_.rankingUpdatedAt AS rankingUpdatedAt_17 FROM sp_content_feed s0_ WHERE s0_.tags LIKE ? ORDER BY s0_.score DESC SELECT s0_.id AS id_0, s0_.owner AS owner_1, s0_.type AS type_2, s0_.externalId AS externalId_3, s0_.score AS score_4, s0_.name AS name_5, s0_.title AS title_6, s0_.imageLink AS imageLink_7, s0_.categories AS categories_8, s0_.tags AS tags_9, s0_.isActive AS isActive_10, s0_.lastModified AS lastModified_11, s0_.lastChangeUser AS lastChangeUser_12, s0_.createdAt AS createdAt_13, s0_.rankingScore AS rankingScore_14, s0_.eventStartDate AS eventStartDate_15, s0_.jobEndDate AS jobEndDate_16, s0_.rankingUpdatedAt AS rankingUpdatedAt_17 FROM sp_content_feed s0_ WHERE s0_.tags LIKE '%\"holybag\"%' ORDER BY s0_.score DESC;
10	0.62 ms	SELECT t0.id AS id_1, t0.programId AS programId_2, t0.eventId AS eventId_3, t0.productId AS productId_4, t0.batchNumber AS batchNumber_5, t0.url AS url_6, t0.name AS name_7, t0.slug AS slug_8, t0.alias AS alias_9, t0.status AS status_10, t0.focusStatus AS focusStatus_11, t0.lang AS lang_12, t0.priceInEuroCent AS priceInEuroCent_13, t0.isTaxIncluded AS isTaxIncluded_14, t0.discount100MemberTags AS discount100MemberTags_15, t0.discount50MemberTags AS discount50MemberTags_16, t0.discount20MemberTags AS discount20MemberTags_17, t0.askForTeam AS askForTeam_18, t0.hasEvent AS hasEvent_19, t0.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_20, t0.hasIncludeTermsConsent AS hasIncludeTermsConsent_21, t0.hasIncludeLinkedIn AS hasIncludeLinkedIn_22, t0.hasIncludePhone AS hasIncludePhone_23, t0.hasRequirePhone AS hasRequirePhone_24, t0.hasFollowUp AS hasFollowUp_25, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, t0.isFutureEvent AS isFutureEvent_28, t0.visibility AS visibility_29, t0.access AS access_30, t0.tags AS tags_31, t0.typeformLink AS typeformLink_32, t0.zoomLink AS zoomLink_33, t0.bgImageUrl AS bgImageUrl_34, t0.startDate AS startDate_35, t0.endDate AS endDate_36, t0.taxBehavior AS taxBehavior_37, t0.paymentProvider AS paymentProvider_38, t0.isFreeForKiCampus AS isFreeForKiCampus_39, t0.isFreeForCommunity AS isFreeForCommunity_40, t0.registrationMode AS registrationMode_41, t0.externalRegistrationUrl AS externalRegistrationUrl_42, t0.externalPlatform AS externalPlatform_43, t0.registrationHeadline AS registrationHeadline_44, t0.registrationSubtitle AS registrationSubtitle_45, t0.registrationButtonText AS registrationButtonText_46, t0.registrationPriceHtml AS registrationPriceHtml_47, t0.registrationRedirectUrl AS registrationRedirectUrl_48, t0.lumaEventApiId AS lumaEventApiId_49, t0.meetupEventId AS meetupEventId_50, t0.meetupEventUrl AS meetupEventUrl_51, t0.mailDesignTemplate AS mailDesignTemplate_52, t0.senderMail AS senderMail_53, t0.fromName AS fromName_54, t0.recipientMonitoringMail AS recipientMonitoringMail_55, t0.confirmationMailSubject AS confirmationMailSubject_56, t0.confirmationMailContent AS confirmationMailContent_57, t0.adminNotificationMailSubject AS adminNotificationMailSubject_58, t0.adminNotificationMailContent AS adminNotificationMailContent_59, t0.reminderMailTemplateId AS reminderMailTemplateId_60, t0.reminderSenderEmail AS reminderSenderEmail_61, t0.reminderMailSendDate AS reminderMailSendDate_62, t0.reminderMailSubject AS reminderMailSubject_63, t0.reminderMailContent AS reminderMailContent_64, t0.$reminderMailStatus AS reminderMailStatus_65, t0.surveyId AS surveyId_66, t0.surveyMailTemplateId AS surveyMailTemplateId_67, t0.surveyBulkMailId AS surveyBulkMailId_68, t0.template AS template_69, t0.pageTemplate AS pageTemplate_70, t0.footerTemplate AS footerTemplate_71, t0.email AS email_72, t0.emailSubject AS emailSubject_73, t0.emailContent AS emailContent_74, t0.landingPageContent AS landingPageContent_75, t0.landingPageDescription AS landingPageDescription_76, t0.landingPageCss AS landingPageCss_77, t0.landingPageJs AS landingPageJs_78, t0.landingPageFooterTemplate AS landingPageFooterTemplate_79, t0.landingPageTitle AS landingPageTitle_80, t0.landingPageTwig AS landingPageTwig_81, t0.title AS title_82, t0.teaser AS teaser_83, t0.navbar AS navbar_84, t0.content AS content_85, t0.contentTwig AS contentTwig_86, t0.content_blocks AS content_blocks_87, t0.content_blocks_en AS content_blocks_en_88, t0.ctaContent AS ctaContent_89, t0.postCtaContent AS postCtaContent_90, t0.tagline AS tagline_91, t0.seoTitle AS seoTitle_92, t0.seoDescription AS seoDescription_93, t0.seoKeyword AS seoKeyword_94, t0.imagelink AS imagelink_95, t0.bgImagelink AS bgImagelink_96, t0.additionalCss AS additionalCss_97, t0.additionalJs AS additionalJs_98, t0.navbarEn AS navbarEn_99, t0.teaserEn AS teaserEn_100, t0.contentEn AS contentEn_101, t0.contentTwigEn AS contentTwigEn_102, t0.postCtaContentEn AS postCtaContentEn_103, t0.seoTitleEn AS seoTitleEn_104, t0.seoDescriptionEn AS seoDescriptionEn_105, t0.seoKeywordEn AS seoKeywordEn_106, t0.trainer AS trainer_107, t0.videolink AS videolink_108, t0.goToPage AS goToPage_109, t0.phrasesDe AS phrasesDe_110, t0.phrasesEn AS phrasesEn_111, t0.settings AS settings_112, t0.capacity AS capacity_113, t0.asssesmentDimensions AS asssesmentDimensions_114, t0.start AS start_115, t0.end AS end_116, t0.pitchTopic AS pitchTopic_117, t0.pitchImageLink AS pitchImageLink_118, t0.pitchVideoLink AS pitchVideoLink_119, t0.pitchPartner AS pitchPartner_120, t0.pitchPartnerId AS pitchPartnerId_121, t0.pitchDescription AS pitchDescription_122, t0.followUpPageContent AS followUpPageContent_123, t0.followUpPageDescription AS followUpPageDescription_124, t0.followUpPageCss AS followUpPageCss_125, t0.followUpPageJs AS followUpPageJs_126, t0.followUpPageFooterTemplate AS followUpPageFooterTemplate_127, t0.followUpPageTitle AS followUpPageTitle_128, t0.followUpDescription AS followUpDescription_129, t0.followUpVideoLink AS followUpVideoLink_130, t0.followUpPresentation AS followUpPresentation_131, t0.followUpSkoolUrl AS followUpSkoolUrl_132, t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_133, t0.followUpCtaText AS followUpCtaText_134, t0.followUpCtaUrl AS followUpCtaUrl_135, t0.followUpDocuments AS followUpDocuments_136, t0.followUpPhotos AS followUpPhotos_137, t0.followUpExtraLinks AS followUpExtraLinks_138, t0.followUpChecklist AS followUpChecklist_139, t0.pitchDate AS pitchDate_140, t0.pitchTime AS pitchTime_141, t0.prepitchDate AS prepitchDate_142, t0.scoutingEndDate AS scoutingEndDate_143, t0.applicationStartDate AS applicationStartDate_144, t0.applicationEndDate AS applicationEndDate_145, t0.interviewInviteStartDate AS interviewInviteStartDate_146, t0.interviewInviteEndDate AS interviewInviteEndDate_147, t0.interviewStartDate AS interviewStartDate_148, t0.interviewEndDate AS interviewEndDate_149, t0.decisionDate AS decisionDate_150, t0.contractDeadlineDate AS contractDeadlineDate_151, t0.finalReportDate AS finalReportDate_152, t0.applicationFormState AS applicationFormState_153, t0.googleCalendarUrl AS googleCalendarUrl_154, t0.city AS city_155, t0.applicationsCount AS applicationsCount_156, t0.startedCount AS startedCount_157, t0.appliedCount AS appliedCount_158, t0.approvedCount AS approvedCount_159, t0.rejectedCount AS rejectedCount_160, t0.$skoolWebhook AS skoolWebhook_161, t0.zapierWebhook AS zapierWebhook_162, t0.history AS history_163, t0.createdAt AS createdAt_164, t0.lastModified AS lastModified_165, t0.lastChangeUser AS lastChangeUser_166, t0.programId AS programId_167, t0.assessmentTeamId AS assessmentTeamId_168 FROM sp_batches t0 WHERE t0.id = ? Parameters: [`154`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.programId AS programId_2, t0.eventId AS eventId_3, t0.productId AS productId_4, t0.batchNumber AS batchNumber_5, t0.url AS url_6, t0.name AS name_7, t0.slug AS slug_8, t0.alias AS alias_9, t0.status AS status_10, t0.focusStatus AS focusStatus_11, t0.lang AS lang_12, t0.priceInEuroCent AS priceInEuroCent_13, t0.isTaxIncluded AS isTaxIncluded_14, t0.discount100MemberTags AS discount100MemberTags_15, t0.discount50MemberTags AS discount50MemberTags_16, t0.discount20MemberTags AS discount20MemberTags_17, t0.askForTeam AS askForTeam_18, t0.hasEvent AS hasEvent_19, t0.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_20, t0.hasIncludeTermsConsent AS hasIncludeTermsConsent_21, t0.hasIncludeLinkedIn AS hasIncludeLinkedIn_22, t0.hasIncludePhone AS hasIncludePhone_23, t0.hasRequirePhone AS hasRequirePhone_24, t0.hasFollowUp AS hasFollowUp_25, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, t0.isFutureEvent AS isFutureEvent_28, t0.visibility AS visibility_29, t0.access AS access_30, t0.tags AS tags_31, t0.typeformLink AS typeformLink_32, t0.zoomLink AS zoomLink_33, t0.bgImageUrl AS bgImageUrl_34, t0.startDate AS startDate_35, t0.endDate AS endDate_36, t0.taxBehavior AS taxBehavior_37, t0.paymentProvider AS paymentProvider_38, t0.isFreeForKiCampus AS isFreeForKiCampus_39, t0.isFreeForCommunity AS isFreeForCommunity_40, t0.registrationMode AS registrationMode_41, t0.externalRegistrationUrl AS externalRegistrationUrl_42, t0.externalPlatform AS externalPlatform_43, t0.registrationHeadline AS registrationHeadline_44, t0.registrationSubtitle AS registrationSubtitle_45, t0.registrationButtonText AS registrationButtonText_46, t0.registrationPriceHtml AS registrationPriceHtml_47, t0.registrationRedirectUrl AS registrationRedirectUrl_48, t0.lumaEventApiId AS lumaEventApiId_49, t0.meetupEventId AS meetupEventId_50, t0.meetupEventUrl AS meetupEventUrl_51, t0.mailDesignTemplate AS mailDesignTemplate_52, t0.senderMail AS senderMail_53, t0.fromName AS fromName_54, t0.recipientMonitoringMail AS recipientMonitoringMail_55, t0.confirmationMailSubject AS confirmationMailSubject_56, t0.confirmationMailContent AS confirmationMailContent_57, t0.adminNotificationMailSubject AS adminNotificationMailSubject_58, t0.adminNotificationMailContent AS adminNotificationMailContent_59, t0.reminderMailTemplateId AS reminderMailTemplateId_60, t0.reminderSenderEmail AS reminderSenderEmail_61, t0.reminderMailSendDate AS reminderMailSendDate_62, t0.reminderMailSubject AS reminderMailSubject_63, t0.reminderMailContent AS reminderMailContent_64, t0.$reminderMailStatus AS reminderMailStatus_65, t0.surveyId AS surveyId_66, t0.surveyMailTemplateId AS surveyMailTemplateId_67, t0.surveyBulkMailId AS surveyBulkMailId_68, t0.template AS template_69, t0.pageTemplate AS pageTemplate_70, t0.footerTemplate AS footerTemplate_71, t0.email AS email_72, t0.emailSubject AS emailSubject_73, t0.emailContent AS emailContent_74, t0.landingPageContent AS landingPageContent_75, t0.landingPageDescription AS landingPageDescription_76, t0.landingPageCss AS landingPageCss_77, t0.landingPageJs AS landingPageJs_78, t0.landingPageFooterTemplate AS landingPageFooterTemplate_79, t0.landingPageTitle AS landingPageTitle_80, t0.landingPageTwig AS landingPageTwig_81, t0.title AS title_82, t0.teaser AS teaser_83, t0.navbar AS navbar_84, t0.content AS content_85, t0.contentTwig AS contentTwig_86, t0.content_blocks AS content_blocks_87, t0.content_blocks_en AS content_blocks_en_88, t0.ctaContent AS ctaContent_89, t0.postCtaContent AS postCtaContent_90, t0.tagline AS tagline_91, t0.seoTitle AS seoTitle_92, t0.seoDescription AS seoDescription_93, t0.seoKeyword AS seoKeyword_94, t0.imagelink AS imagelink_95, t0.bgImagelink AS bgImagelink_96, t0.additionalCss AS additionalCss_97, t0.additionalJs AS additionalJs_98, t0.navbarEn AS navbarEn_99, t0.teaserEn AS teaserEn_100, t0.contentEn AS contentEn_101, t0.contentTwigEn AS contentTwigEn_102, t0.postCtaContentEn AS postCtaContentEn_103, t0.seoTitleEn AS seoTitleEn_104, t0.seoDescriptionEn AS seoDescriptionEn_105, t0.seoKeywordEn AS seoKeywordEn_106, t0.trainer AS trainer_107, t0.videolink AS videolink_108, t0.goToPage AS goToPage_109, t0.phrasesDe AS phrasesDe_110, t0.phrasesEn AS phrasesEn_111, t0.settings AS settings_112, t0.capacity AS capacity_113, t0.asssesmentDimensions AS asssesmentDimensions_114, t0.start AS start_115, t0.end AS end_116, t0.pitchTopic AS pitchTopic_117, t0.pitchImageLink AS pitchImageLink_118, t0.pitchVideoLink AS pitchVideoLink_119, t0.pitchPartner AS pitchPartner_120, t0.pitchPartnerId AS pitchPartnerId_121, t0.pitchDescription AS pitchDescription_122, t0.followUpPageContent AS followUpPageContent_123, t0.followUpPageDescription AS followUpPageDescription_124, t0.followUpPageCss AS followUpPageCss_125, t0.followUpPageJs AS followUpPageJs_126, t0.followUpPageFooterTemplate AS followUpPageFooterTemplate_127, t0.followUpPageTitle AS followUpPageTitle_128, t0.followUpDescription AS followUpDescription_129, t0.followUpVideoLink AS followUpVideoLink_130, t0.followUpPresentation AS followUpPresentation_131, t0.followUpSkoolUrl AS followUpSkoolUrl_132, t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_133, t0.followUpCtaText AS followUpCtaText_134, t0.followUpCtaUrl AS followUpCtaUrl_135, t0.followUpDocuments AS followUpDocuments_136, t0.followUpPhotos AS followUpPhotos_137, t0.followUpExtraLinks AS followUpExtraLinks_138, t0.followUpChecklist AS followUpChecklist_139, t0.pitchDate AS pitchDate_140, t0.pitchTime AS pitchTime_141, t0.prepitchDate AS prepitchDate_142, t0.scoutingEndDate AS scoutingEndDate_143, t0.applicationStartDate AS applicationStartDate_144, t0.applicationEndDate AS applicationEndDate_145, t0.interviewInviteStartDate AS interviewInviteStartDate_146, t0.interviewInviteEndDate AS interviewInviteEndDate_147, t0.interviewStartDate AS interviewStartDate_148, t0.interviewEndDate AS interviewEndDate_149, t0.decisionDate AS decisionDate_150, t0.contractDeadlineDate AS contractDeadlineDate_151, t0.finalReportDate AS finalReportDate_152, t0.applicationFormState AS applicationFormState_153, t0.googleCalendarUrl AS googleCalendarUrl_154, t0.city AS city_155, t0.applicationsCount AS applicationsCount_156, t0.startedCount AS startedCount_157, t0.appliedCount AS appliedCount_158, t0.approvedCount AS approvedCount_159, t0.rejectedCount AS rejectedCount_160, t0.$skoolWebhook AS skoolWebhook_161, t0.zapierWebhook AS zapierWebhook_162, t0.history AS history_163, t0.createdAt AS createdAt_164, t0.lastModified AS lastModified_165, t0.lastChangeUser AS lastChangeUser_166, t0.programId AS programId_167, t0.assessmentTeamId AS assessmentTeamId_168 FROM sp_batches t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.programId AS programId_2, t0.eventId AS eventId_3, t0.productId AS productId_4, t0.batchNumber AS batchNumber_5, t0.url AS url_6, t0.name AS name_7, t0.slug AS slug_8, t0.alias AS alias_9, t0.status AS status_10, t0.focusStatus AS focusStatus_11, t0.lang AS lang_12, t0.priceInEuroCent AS priceInEuroCent_13, t0.isTaxIncluded AS isTaxIncluded_14, t0.discount100MemberTags AS discount100MemberTags_15, t0.discount50MemberTags AS discount50MemberTags_16, t0.discount20MemberTags AS discount20MemberTags_17, t0.askForTeam AS askForTeam_18, t0.hasEvent AS hasEvent_19, t0.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_20, t0.hasIncludeTermsConsent AS hasIncludeTermsConsent_21, t0.hasIncludeLinkedIn AS hasIncludeLinkedIn_22, t0.hasIncludePhone AS hasIncludePhone_23, t0.hasRequirePhone AS hasRequirePhone_24, t0.hasFollowUp AS hasFollowUp_25, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, t0.isFutureEvent AS isFutureEvent_28, t0.visibility AS visibility_29, t0.access AS access_30, t0.tags AS tags_31, t0.typeformLink AS typeformLink_32, t0.zoomLink AS zoomLink_33, t0.bgImageUrl AS bgImageUrl_34, t0.startDate AS startDate_35, t0.endDate AS endDate_36, t0.taxBehavior AS taxBehavior_37, t0.paymentProvider AS paymentProvider_38, t0.isFreeForKiCampus AS isFreeForKiCampus_39, t0.isFreeForCommunity AS isFreeForCommunity_40, t0.registrationMode AS registrationMode_41, t0.externalRegistrationUrl AS externalRegistrationUrl_42, t0.externalPlatform AS externalPlatform_43, t0.registrationHeadline AS registrationHeadline_44, t0.registrationSubtitle AS registrationSubtitle_45, t0.registrationButtonText AS registrationButtonText_46, t0.registrationPriceHtml AS registrationPriceHtml_47, t0.registrationRedirectUrl AS registrationRedirectUrl_48, t0.lumaEventApiId AS lumaEventApiId_49, t0.meetupEventId AS meetupEventId_50, t0.meetupEventUrl AS meetupEventUrl_51, t0.mailDesignTemplate AS mailDesignTemplate_52, t0.senderMail AS senderMail_53, t0.fromName AS fromName_54, t0.recipientMonitoringMail AS recipientMonitoringMail_55, t0.confirmationMailSubject AS confirmationMailSubject_56, t0.confirmationMailContent AS confirmationMailContent_57, t0.adminNotificationMailSubject AS adminNotificationMailSubject_58, t0.adminNotificationMailContent AS adminNotificationMailContent_59, t0.reminderMailTemplateId AS reminderMailTemplateId_60, t0.reminderSenderEmail AS reminderSenderEmail_61, t0.reminderMailSendDate AS reminderMailSendDate_62, t0.reminderMailSubject AS reminderMailSubject_63, t0.reminderMailContent AS reminderMailContent_64, t0.$reminderMailStatus AS reminderMailStatus_65, t0.surveyId AS surveyId_66, t0.surveyMailTemplateId AS surveyMailTemplateId_67, t0.surveyBulkMailId AS surveyBulkMailId_68, t0.template AS template_69, t0.pageTemplate AS pageTemplate_70, t0.footerTemplate AS footerTemplate_71, t0.email AS email_72, t0.emailSubject AS emailSubject_73, t0.emailContent AS emailContent_74, t0.landingPageContent AS landingPageContent_75, t0.landingPageDescription AS landingPageDescription_76, t0.landingPageCss AS landingPageCss_77, t0.landingPageJs AS landingPageJs_78, t0.landingPageFooterTemplate AS landingPageFooterTemplate_79, t0.landingPageTitle AS landingPageTitle_80, t0.landingPageTwig AS landingPageTwig_81, t0.title AS title_82, t0.teaser AS teaser_83, t0.navbar AS navbar_84, t0.content AS content_85, t0.contentTwig AS contentTwig_86, t0.content_blocks AS content_blocks_87, t0.content_blocks_en AS content_blocks_en_88, t0.ctaContent AS ctaContent_89, t0.postCtaContent AS postCtaContent_90, t0.tagline AS tagline_91, t0.seoTitle AS seoTitle_92, t0.seoDescription AS seoDescription_93, t0.seoKeyword AS seoKeyword_94, t0.imagelink AS imagelink_95, t0.bgImagelink AS bgImagelink_96, t0.additionalCss AS additionalCss_97, t0.additionalJs AS additionalJs_98, t0.navbarEn AS navbarEn_99, t0.teaserEn AS teaserEn_100, t0.contentEn AS contentEn_101, t0.contentTwigEn AS contentTwigEn_102, t0.postCtaContentEn AS postCtaContentEn_103, t0.seoTitleEn AS seoTitleEn_104, t0.seoDescriptionEn AS seoDescriptionEn_105, t0.seoKeywordEn AS seoKeywordEn_106, t0.trainer AS trainer_107, t0.videolink AS videolink_108, t0.goToPage AS goToPage_109, t0.phrasesDe AS phrasesDe_110, t0.phrasesEn AS phrasesEn_111, t0.settings AS settings_112, t0.capacity AS capacity_113, t0.asssesmentDimensions AS asssesmentDimensions_114, t0.start AS start_115, t0.end AS end_116, t0.pitchTopic AS pitchTopic_117, t0.pitchImageLink AS pitchImageLink_118, t0.pitchVideoLink AS pitchVideoLink_119, t0.pitchPartner AS pitchPartner_120, t0.pitchPartnerId AS pitchPartnerId_121, t0.pitchDescription AS pitchDescription_122, t0.followUpPageContent AS followUpPageContent_123, t0.followUpPageDescription AS followUpPageDescription_124, t0.followUpPageCss AS followUpPageCss_125, t0.followUpPageJs AS followUpPageJs_126, t0.followUpPageFooterTemplate AS followUpPageFooterTemplate_127, t0.followUpPageTitle AS followUpPageTitle_128, t0.followUpDescription AS followUpDescription_129, t0.followUpVideoLink AS followUpVideoLink_130, t0.followUpPresentation AS followUpPresentation_131, t0.followUpSkoolUrl AS followUpSkoolUrl_132, t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_133, t0.followUpCtaText AS followUpCtaText_134, t0.followUpCtaUrl AS followUpCtaUrl_135, t0.followUpDocuments AS followUpDocuments_136, t0.followUpPhotos AS followUpPhotos_137, t0.followUpExtraLinks AS followUpExtraLinks_138, t0.followUpChecklist AS followUpChecklist_139, t0.pitchDate AS pitchDate_140, t0.pitchTime AS pitchTime_141, t0.prepitchDate AS prepitchDate_142, t0.scoutingEndDate AS scoutingEndDate_143, t0.applicationStartDate AS applicationStartDate_144, t0.applicationEndDate AS applicationEndDate_145, t0.interviewInviteStartDate AS interviewInviteStartDate_146, t0.interviewInviteEndDate AS interviewInviteEndDate_147, t0.interviewStartDate AS interviewStartDate_148, t0.interviewEndDate AS interviewEndDate_149, t0.decisionDate AS decisionDate_150, t0.contractDeadlineDate AS contractDeadlineDate_151, t0.finalReportDate AS finalReportDate_152, t0.applicationFormState AS applicationFormState_153, t0.googleCalendarUrl AS googleCalendarUrl_154, t0.city AS city_155, t0.applicationsCount AS applicationsCount_156, t0.startedCount AS startedCount_157, t0.appliedCount AS appliedCount_158, t0.approvedCount AS approvedCount_159, t0.rejectedCount AS rejectedCount_160, t0.$skoolWebhook AS skoolWebhook_161, t0.zapierWebhook AS zapierWebhook_162, t0.history AS history_163, t0.createdAt AS createdAt_164, t0.lastModified AS lastModified_165, t0.lastChangeUser AS lastChangeUser_166, t0.programId AS programId_167, t0.assessmentTeamId AS assessmentTeamId_168 FROM sp_batches t0 WHERE t0.id = 154;
11	0.34 ms	SELECT s0_.id AS id_0, s0_.location AS location_1, s0_.$location_optional AS location_optional_2, s0_.jobType AS jobType_3, s0_.companyName AS companyName_4, s0_.description AS description_5, s0_.logoUrl AS logoUrl_6, s0_.startingDate AS startingDate_7, s0_.endDate AS endDate_8, s0_.companyType AS companyType_9, s0_.jobUrl AS jobUrl_10, s0_.categories AS categories_11, s0_.tags AS tags_12, s0_.applyTarget AS applyTarget_13, s0_.history AS history_14, s0_.lastChangeUser AS lastChangeUser_15, s0_.lastModified AS lastModified_16, s0_.createdAt AS createdAt_17, s0_.seniority AS seniority_18, s0_.locationType AS locationType_19, s0_.brandColor AS brandColor_20, s0_.tasks AS tasks_21, s0_.requirements AS requirements_22, s0_.status AS status_23, s0_.extendedAt AS extendedAt_24, s0_.reminderSentAt AS reminderSentAt_25, s0_.teamId AS teamId_26 FROM sp_jobs s0_ WHERE s0_.teamId = ? AND s0_.status = ? AND s0_.startingDate <= ? AND ((s0_.endDate IS NULL OR s0_.endDate >= ?)) ORDER BY s0_.startingDate DESC Parameters: [`16802 "approved" "2026-08-08 14:21:56" "2026-08-08 00:00:00"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.location AS location_1, s0_.$location_optional AS location_optional_2, s0_.jobType AS jobType_3, s0_.companyName AS companyName_4, s0_.description AS description_5, s0_.logoUrl AS logoUrl_6, s0_.startingDate AS startingDate_7, s0_.endDate AS endDate_8, s0_.companyType AS companyType_9, s0_.jobUrl AS jobUrl_10, s0_.categories AS categories_11, s0_.tags AS tags_12, s0_.applyTarget AS applyTarget_13, s0_.history AS history_14, s0_.lastChangeUser AS lastChangeUser_15, s0_.lastModified AS lastModified_16, s0_.createdAt AS createdAt_17, s0_.seniority AS seniority_18, s0_.locationType AS locationType_19, s0_.brandColor AS brandColor_20, s0_.tasks AS tasks_21, s0_.requirements AS requirements_22, s0_.status AS status_23, s0_.extendedAt AS extendedAt_24, s0_.reminderSentAt AS reminderSentAt_25, s0_.teamId AS teamId_26 FROM sp_jobs s0_ WHERE s0_.teamId = ? AND s0_.status = ? AND s0_.startingDate <= ? AND ( ( s0_.endDate IS NULL OR s0_.endDate >= ? ) ) ORDER BY s0_.startingDate DESC SELECT s0_.id AS id_0, s0_.location AS location_1, s0_.$location_optional AS location_optional_2, s0_.jobType AS jobType_3, s0_.companyName AS companyName_4, s0_.description AS description_5, s0_.logoUrl AS logoUrl_6, s0_.startingDate AS startingDate_7, s0_.endDate AS endDate_8, s0_.companyType AS companyType_9, s0_.jobUrl AS jobUrl_10, s0_.categories AS categories_11, s0_.tags AS tags_12, s0_.applyTarget AS applyTarget_13, s0_.history AS history_14, s0_.lastChangeUser AS lastChangeUser_15, s0_.lastModified AS lastModified_16, s0_.createdAt AS createdAt_17, s0_.seniority AS seniority_18, s0_.locationType AS locationType_19, s0_.brandColor AS brandColor_20, s0_.tasks AS tasks_21, s0_.requirements AS requirements_22, s0_.status AS status_23, s0_.extendedAt AS extendedAt_24, s0_.reminderSentAt AS reminderSentAt_25, s0_.teamId AS teamId_26 FROM sp_jobs s0_ WHERE s0_.teamId = 16802 AND s0_.status = 'approved' AND s0_.startingDate <= '2026-08-08 14:21:56' AND ((s0_.endDate IS NULL OR s0_.endDate >= '2026-08-08 00:00:00')) ORDER BY s0_.startingDate DESC;
12	0.23 ms	SELECT s0_.id AS id_0, s0_.startupId AS startupId_1, s0_.url AS url_2, s0_.title AS title_3, s0_.publishedAt AS publishedAt_4, s0_.isActive AS isActive_5, s0_.submittedBy AS submittedBy_6, s0_.createdAt AS createdAt_7 FROM sp_startup_news_links s0_ WHERE s0_.startupId = ? AND s0_.isActive = 1 ORDER BY s0_.publishedAt DESC, s0_.createdAt DESC Parameters: [`3001037`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.startupId AS startupId_1, s0_.url AS url_2, s0_.title AS title_3, s0_.publishedAt AS publishedAt_4, s0_.isActive AS isActive_5, s0_.submittedBy AS submittedBy_6, s0_.createdAt AS createdAt_7 FROM sp_startup_news_links s0_ WHERE s0_.startupId = ? AND s0_.isActive = 1 ORDER BY s0_.publishedAt DESC, s0_.createdAt DESC SELECT s0_.id AS id_0, s0_.startupId AS startupId_1, s0_.url AS url_2, s0_.title AS title_3, s0_.publishedAt AS publishedAt_4, s0_.isActive AS isActive_5, s0_.submittedBy AS submittedBy_6, s0_.createdAt AS createdAt_7 FROM sp_startup_news_links s0_ WHERE s0_.startupId = 3001037 AND s0_.isActive = 1 ORDER BY s0_.publishedAt DESC, s0_.createdAt DESC;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\StartPlatz\Bundle\MemberBundle\Entity\Member	2
App\StartPlatz\Bundle\StartupBundle\Entity\Startup	1
App\StartPlatz\Bundle\MemberBundle\Entity\Team	1
App\StartPlatz\Bundle\AlphaBundle\Entity\Feed	1
App\StartPlatz\Bundle\StartupBundle\Entity\Application	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\StartupBundle\Entity\Startup	No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\MemberTeam	No errors.
App\StartPlatz\Bundle\AlphaBundle\Entity\Feed	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Batch	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Program	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Application	No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\Member	No errors.
App\StartPlatz\Bundle\AllmedaBundle\Entity\BatchApplicationAssessment	No errors.
App\StartPlatz\Bundle\AlphaBundle\Entity\Job	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\StartupNewsLink	No errors.

Symfony Profiler

GET https://www.staging.startplatz.de/startup/3001037-holybag

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping