Symfony Profiler

Query Metrics

11 Database Queries

8 Different statements

154.77 ms Query time

0 Invalid entities

1127 Managed entities

Queries


SELECT COUNT(s0_.id) AS sclr_0 FROM sp_startup_profiles s0_ WHERE s0_.visibility = ?
SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = ? ORDER BY s0_.lastModified DESC LIMIT 1204
SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37, t0.publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0.slug = ? LIMIT 1
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.programId = ? AND t0.focusStatus = ? LIMIT 1
SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = ? ORDER BY s0_.lastModified DESC LIMIT 128
SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = ? ORDER BY s0_.lastModified DESC LIMIT 128
SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = ? ORDER BY s0_.lastModified DESC LIMIT 128
SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = ? ORDER BY s0_.lastModified DESC LIMIT 1280
SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = ? ORDER BY s0_.lastModified DESC LIMIT 1280
SELECT s0_.industry AS industry_0, COUNT(s0_.id) AS sclr_1 FROM sp_startup_profiles s0_ WHERE s0_.visibility = ? GROUP BY s0_.industry ORDER BY s0_.industry ASC
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 IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR t0.id IS NULL)

#▲	Time	Info
1	0.70 ms	SELECT COUNT(s0_.id) AS sclr_0 FROM sp_startup_profiles s0_ WHERE s0_.visibility = ? Parameters: [`"public"`] View formatted query View runnable query Explain query SELECT COUNT(s0_.id) AS sclr_0 FROM sp_startup_profiles s0_ WHERE s0_.visibility = ? SELECT COUNT(s0_.id) AS sclr_0 FROM sp_startup_profiles s0_ WHERE s0_.visibility = 'public';
2	10.35 ms	SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = ? ORDER BY s0_.lastModified DESC LIMIT 1204 Parameters: [`"public"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = ? ORDER BY s0_.lastModified DESC LIMIT 1204 SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = 'public' ORDER BY s0_.lastModified DESC LIMIT 1204;
3	0.56 ms	SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37, t0.publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0.slug = ? LIMIT 1 Parameters: [`"startups"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37, t0.publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37, t0.publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0.slug = 'startups' LIMIT 1;
4	1.10 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.programId = ? AND t0.focusStatus = ? LIMIT 1 Parameters: [`3 "2_current"`] 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.programId = ? AND t0.focusStatus = ? LIMIT 1 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.programId = 3 AND t0.focusStatus = '2_current' LIMIT 1;
5	4.97 ms	SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = ? ORDER BY s0_.lastModified DESC LIMIT 128 Parameters: [`"public"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = ? ORDER BY s0_.lastModified DESC LIMIT 128 SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = 'public' ORDER BY s0_.lastModified DESC LIMIT 128;
6	4.59 ms	SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = ? ORDER BY s0_.lastModified DESC LIMIT 128 Parameters: [`"public"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = ? ORDER BY s0_.lastModified DESC LIMIT 128 SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = 'public' ORDER BY s0_.lastModified DESC LIMIT 128;
7	4.32 ms	SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = ? ORDER BY s0_.lastModified DESC LIMIT 128 Parameters: [`"public"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = ? ORDER BY s0_.lastModified DESC LIMIT 128 SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = 'public' ORDER BY s0_.lastModified DESC LIMIT 128;
8	9.10 ms	SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = ? ORDER BY s0_.lastModified DESC LIMIT 1280 Parameters: [`"public"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = ? ORDER BY s0_.lastModified DESC LIMIT 1280 SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = 'public' ORDER BY s0_.lastModified DESC LIMIT 1280;
9	9.61 ms	SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = ? ORDER BY s0_.lastModified DESC LIMIT 1280 Parameters: [`"public"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = ? ORDER BY s0_.lastModified DESC LIMIT 1280 SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = 'public' ORDER BY s0_.lastModified DESC LIMIT 1280;
10	3.28 ms	SELECT s0_.industry AS industry_0, COUNT(s0_.id) AS sclr_1 FROM sp_startup_profiles s0_ WHERE s0_.visibility = ? GROUP BY s0_.industry ORDER BY s0_.industry ASC Parameters: [`"public"`] View formatted query View runnable query Explain query SELECT s0_.industry AS industry_0, COUNT(s0_.id) AS sclr_1 FROM sp_startup_profiles s0_ WHERE s0_.visibility = ? GROUP BY s0_.industry ORDER BY s0_.industry ASC SELECT s0_.industry AS industry_0, COUNT(s0_.id) AS sclr_1 FROM sp_startup_profiles s0_ WHERE s0_.visibility = 'public' GROUP BY s0_.industry ORDER BY s0_.industry ASC;
11	106.19 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 IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR t0.id IS NULL) Parameters: [17320 22426 26733 20155 26241 23729 11025 16713 26302 25978 25280 25282 25279 20456 24161 10590 23807 22905 18111 14813 12442 11654 24218 25281 25278 25277 23156 24803 24147 25135 25142 23864 23342 21764 24598 23612 23873 24615 24604 24573 17291 22516 23127 23143 22465 20949 18380 23803 23356 24167 22428 24319 24136 21556 23732 20040 14284 13810 14298 14797 10897 10576 11689 15245 10827 14622 15414 15474 16277 10128 10029 15249 15040 14286 15572 10490 13427 15479 14333 15618 11481 15083 13429 15264 11653 10427 15323 10426 10514 15427 15009 15235 10273 14787 23989 23638 15151 16439 10921 10259 10335 10184 10493 10507 17266 14848 18399 17128 16100 17414 16967 11977 10421 23912 18703 10030 14473 18515 23808 14292 13575 20628 22196 23579 23946 23192 23315 16021 10059 21708 18437 22279 18133 22304 23492 10062 14676 14711 23474 11652 20867 23089 22860 23806 22880 20930 10346 17176 23001 21915 23063 22460 11715 23526 23751 10170 23486 18936 18798 23083 19649 23311 23738 23663 23653 16209 22551 20654 19777 21846 21102 20860 23124 23139 23105 23074 23084 21912 21110 17764 21250 11171 16531 13264 22515 20726 22528 21204 16061 18554 11106 19083 16697 20619 13677 24376 21849 21848 21863 21675 21821 21806 21736 21827 21033 21003 20593 21727 21712 21706 21692 21070 21716 14658 19915 16641 19763 16340 16803 20009 21064 16802 21308 16801 19614 19840 16799 19839 19743 16797 19495 19651 19510 19846 10158 19577 19498 19860 10178 19696 10159 19745 10252 19770 10387 15808 19802 17810 19645 19863 19484 19901 19782 19610 19711 10542 19784 19656 10405 19817 17811 15402 19838 19847 16991 19914 19849 11447 16796 19606 19829 19785 19546 17815 19636 17075 16635 16341 19588 21577 19923 10580 10371 17009 19823 19781 19795 13500 14794 19578 19599 19831 19773 19729 19507 13385 19642 10628 13811 14585 19918 19707 10975 19528 19775 19675 19519 19868 17311 19822 19752 19830 19872 19732 17312 19756 15094 20651 17313 19894 19605 19668 19522 19909 19618 19535 19673 15359 19666 19882 19718 19612 19644 19616 17575 19828 15752 19820 13766 19893 19567 19818 19685 19643 19702 19701 19698 19721 14782 19913 19857 15278 19758 19553 19734 19493 19911 19737 16103 21575 17314 16202 16211 16745 16184 16380 16494 15847 16430 15375 16576 17070 16653 16912 16901 16790 19928 19924 16642 17146 17142 17078 17217 17225 15820 17353 17390 17368 17554 16601 17833 17864 18068 18093 17940 18775 18766 16726 19858 11978 17455 16724 17753 17498 18041 19081 21332 19445 20264 17413 16087 20635 19068 19160 19156 19118 20051 20274 19368 20385 16424 20474 20495 20755 20674 17853 20811 20820 20983 18395 17803 21098 21076 21045 21434 21297 21270 21266 21185 21268 17507 17371 17578 20968 17754 17190 16428 18155 18153 18128 17653 17634 17573 16942 17380 16717 18549 18548 18547 18546 17860 21458 17733 17073 17344 18919 18915 18916 18918 18920 20873 20028 18921 18917 20470 20468 19276 19274 19275 14472 14754 13334 15150 15145 14534 15165 14294 14287 14790 16427 14795 14789 15504 15486 14792 16431 16429 20469 19273 19015 20026 20029 20027 19293 20030 20197 20031 20140 20295 20294 20296 17428 18808 20465 20466 20467 20590 18301 20297 14297 16638 16530 20571 20866 20908 21130 20885 14279 13291 19370 19360 19374 19416 21115 14651 17442 13452 13625 15758 16426 18411 19710 10113 10002 10539 10317 10008 14509 12035 15684 18122 16711 20248 10394 10432 16994 10466 15771 19303 18675 17457 18438 10512 18082 17643 10219 16622 19195 15740 15332 17486 16302 11233 13488 16962 16432 14891 14350 20245 19695 19458 19581 18409 19805 25866 19789 15783 16585 25873 10483 11824 19564 19597 16490 19525 14069 19548 25884 19791 16197 25877 15259 17202 11842 25910 19855 19919 19920 19917 19910 19908 19906 19903 19902 19899 19900 19898 19896 19895 19892 19891 19888 19886 19887 19884 19885 19883 19880 19881 19877 19874 19873 19871 19869 19870 19867 19865 19861 19862 19859 19856 19852 19853 19851 19848 19844 19841 19834 19835 19833 19827 19825 19821 19815 19816 19814 19813 19812 19810 19811 19808 19809 19807 19804 19803 19801 19798 19799 19796 19797 19793 19794 19790 19788 19787 19786 19783 19780 19778 19779 19776 19771 19772 19768 19769 19766 19767 19764 19765 19762 19759 19757 19753 19751 19750 19748 19746 19747 19740 19738 19739 19735 19733 19731 19730 19727 19726 19724 19725 19722 19719 19716 19712 19709 19705 19706 19704 19700 19699 19694 19692 19693 19691 19689 19687 19688 19686 19684 19680 19681 19679 19677 19674 19672 19670 19667 19664 19665 19663 19661 19659 19654 19655 19652 19650 19646 19647 19640 19637 19638 19634 19635 19633 19631 19629 19630 19627 19628 19626 19624 19625 19622 19623 19621 19619 19620 19615 19613 19609 19608 19607 19603 19604 19601 19602 19600 19598 19595 19594 19592 19591 19589 19590 19586 19585 19579 19575 19576 19572 19571 19570 19568 19566 19565 19563 19561 19562 19559 19557 19555 19554 19552 19550 19551 19549 19547 19544 19545 19542 19543 19541 19539 19538 19536 19534 19530 19531 19529 19527 19526 19524 19523 19521 19520 19518 19517 19515 19514 19512 19513 19509 19508 19506 19505 19503 19501 19500 19499 19497 19494 19492 19490 19488 19486 19485 19483 19481 19480 15489 17882 17878 17881 17880 17879 17895 17693 17739 17707 18372 18275 18327 18300 18351 18325 18326 17832 18056 10050 17386 16612 17319 17318 17023 16371 16279 16425 25912 25905 15352 15540 10229 25852 16725 13312 15825 15435 15531 11858 16206 14796 11463 11196 10516 11583 13321 10502 16298 16205 14288 15326 16189 25913 25916 25899 25903 25904 13656 25891 25892 25893 25894 25895 13312 25886 14364 25881 25876 25878 25872 25870 25867 25868 25850 25846 25843 16722 16723 12264 16561 16515 16714 16715 16719 16273 16183 16304 16343 16347 16590 16571 16190 16194 16198 16199 16200 16210 16218 13884 25919 16116 25901 13771 15223 14289 15357 15358 10092 25898 15353 25900 14296 10824 14793 14206 16061 10898 11446 14285 14295 25885 15526 25887 11216 25888 25889 13292 11226 25890 13563 15140 13770 15621 15856 14282 15476 10237 10096 25880 15093 13767 15398 25874 25861 25862 14786 15777 15713 11412 15707 15575 14788 15530 15533 14967 15816 14820 25848 14890 25851 25855 14005 15541 13430 15426 13302 11448 15319 10541 16012 25839 14783 14784 14785 10518 11194 11232 13768 13760 25875 11126 15530 25906 25908 25909 10068 10685 13778 13831 15178 25914 25917 25897 16345 15304 25915 16204 16589 25911 11716 16112 16284 16459 16580 16557 25902 16061 25907 16398 16186 16208 16251 25882 14208 25883 16173 17275 10040 10615 11050 11557 13173 15713 25865 16230 16591 16587 16544 16539 16419 16124 16151 13840 16207 25871 16264 16166 16379 16578 16579 16548 25869 16215 16492 16575 16553 25859 14786 25863 25864 25918 16348 16196 16201 16203 16213 16397 16550 16292 16102 10037 25857 25858 15532 25845 25849 25853 25854 25856 25844 17279 11349 25840 25841 25842 25838 13151 25847 25860 25879 25896] 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 IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) OR t0.id IS NULL ) 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 IN (17320, 22426, 26733, 20155, 26241, 23729, 11025, 16713, 26302, 25978, 25280, 25282, 25279, 20456, 24161, 10590, 23807, 22905, 18111, 14813, 12442, 11654, 24218, 25281, 25278, 25277, 23156, 24803, 24147, 25135, 25142, 23864, 23342, 21764, 24598, 23612, 23873, 24615, 24604, 24573, 17291, 22516, 23127, 23143, 22465, 20949, 18380, 23803, 23356, 24167, 22428, 24319, 24136, 21556, 23732, 20040, 14284, 13810, 14298, 14797, 10897, 10576, 11689, 15245, 10827, 14622, 15414, 15474, 16277, 10128, 10029, 15249, 15040, 14286, 15572, 10490, 13427, 15479, 14333, 15618, 11481, 15083, 13429, 15264, 11653, 10427, 15323, 10426, 10514, 15427, 15009, 15235, 10273, 14787, 23989, 23638, 15151, 16439, 10921, 10259, 10335, 10184, 10493, 10507, 17266, 14848, 18399, 17128, 16100, 17414, 16967, 11977, 10421, 23912, 18703, 10030, 14473, 18515, 23808, 14292, 13575, 20628, 22196, 23579, 23946, 23192, 23315, 16021, 10059, 21708, 18437, 22279, 18133, 22304, 23492, 10062, 14676, 14711, 23474, 11652, 20867, 23089, 22860, 23806, 22880, 20930, 10346, 17176, 23001, 21915, 23063, 22460, 11715, 23526, 23751, 10170, 23486, 18936, 18798, 23083, 19649, 23311, 23738, 23663, 23653, 16209, 22551, 20654, 19777, 21846, 21102, 20860, 23124, 23139, 23105, 23074, 23084, 21912, 21110, 17764, 21250, 11171, 16531, 13264, 22515, 20726, 22528, 21204, 16061, 18554, 11106, 19083, 16697, 20619, 13677, 24376, 21849, 21848, 21863, 21675, 21821, 21806, 21736, 21827, 21033, 21003, 20593, 21727, 21712, 21706, 21692, 21070, 21716, 14658, 19915, 16641, 19763, 16340, 16803, 20009, 21064, 16802, 21308, 16801, 19614, 19840, 16799, 19839, 19743, 16797, 19495, 19651, 19510, 19846, 10158, 19577, 19498, 19860, 10178, 19696, 10159, 19745, 10252, 19770, 10387, 15808, 19802, 17810, 19645, 19863, 19484, 19901, 19782, 19610, 19711, 10542, 19784, 19656, 10405, 19817, 17811, 15402, 19838, 19847, 16991, 19914, 19849, 11447, 16796, 19606, 19829, 19785, 19546, 17815, 19636, 17075, 16635, 16341, 19588, 21577, 19923, 10580, 10371, 17009, 19823, 19781, 19795, 13500, 14794, 19578, 19599, 19831, 19773, 19729, 19507, 13385, 19642, 10628, 13811, 14585, 19918, 19707, 10975, 19528, 19775, 19675, 19519, 19868, 17311, 19822, 19752, 19830, 19872, 19732, 17312, 19756, 15094, 20651, 17313, 19894, 19605, 19668, 19522, 19909, 19618, 19535, 19673, 15359, 19666, 19882, 19718, 19612, 19644, 19616, 17575, 19828, 15752, 19820, 13766, 19893, 19567, 19818, 19685, 19643, 19702, 19701, 19698, 19721, 14782, 19913, 19857, 15278, 19758, 19553, 19734, 19493, 19911, 19737, 16103, 21575, 17314, 16202, 16211, 16745, 16184, 16380, 16494, 15847, 16430, 15375, 16576, 17070, 16653, 16912, 16901, 16790, 19928, 19924, 16642, 17146, 17142, 17078, 17217, 17225, 15820, 17353, 17390, 17368, 17554, 16601, 17833, 17864, 18068, 18093, 17940, 18775, 18766, 16726, 19858, 11978, 17455, 16724, 17753, 17498, 18041, 19081, 21332, 19445, 20264, 17413, 16087, 20635, 19068, 19160, 19156, 19118, 20051, 20274, 19368, 20385, 16424, 20474, 20495, 20755, 20674, 17853, 20811, 20820, 20983, 18395, 17803, 21098, 21076, 21045, 21434, 21297, 21270, 21266, 21185, 21268, 17507, 17371, 17578, 20968, 17754, 17190, 16428, 18155, 18153, 18128, 17653, 17634, 17573, 16942, 17380, 16717, 18549, 18548, 18547, 18546, 17860, 21458, 17733, 17073, 17344, 18919, 18915, 18916, 18918, 18920, 20873, 20028, 18921, 18917, 20470, 20468, 19276, 19274, 19275, 14472, 14754, 13334, 15150, 15145, 14534, 15165, 14294, 14287, 14790, 16427, 14795, 14789, 15504, 15486, 14792, 16431, 16429, 20469, 19273, 19015, 20026, 20029, 20027, 19293, 20030, 20197, 20031, 20140, 20295, 20294, 20296, 17428, 18808, 20465, 20466, 20467, 20590, 18301, 20297, 14297, 16638, 16530, 20571, 20866, 20908, 21130, 20885, 14279, 13291, 19370, 19360, 19374, 19416, 21115, 14651, 17442, 13452, 13625, 15758, 16426, 18411, 19710, 10113, 10002, 10539, 10317, 10008, 14509, 12035, 15684, 18122, 16711, 20248, 10394, 10432, 16994, 10466, 15771, 19303, 18675, 17457, 18438, 10512, 18082, 17643, 10219, 16622, 19195, 15740, 15332, 17486, 16302, 11233, 13488, 16962, 16432, 14891, 14350, 20245, 19695, 19458, 19581, 18409, 19805, 25866, 19789, 15783, 16585, 25873, 10483, 11824, 19564, 19597, 16490, 19525, 14069, 19548, 25884, 19791, 16197, 25877, 15259, 17202, 11842, 25910, 19855, 19919, 19920, 19917, 19910, 19908, 19906, 19903, 19902, 19899, 19900, 19898, 19896, 19895, 19892, 19891, 19888, 19886, 19887, 19884, 19885, 19883, 19880, 19881, 19877, 19874, 19873, 19871, 19869, 19870, 19867, 19865, 19861, 19862, 19859, 19856, 19852, 19853, 19851, 19848, 19844, 19841, 19834, 19835, 19833, 19827, 19825, 19821, 19815, 19816, 19814, 19813, 19812, 19810, 19811, 19808, 19809, 19807, 19804, 19803, 19801, 19798, 19799, 19796, 19797, 19793, 19794, 19790, 19788, 19787, 19786, 19783, 19780, 19778, 19779, 19776, 19771, 19772, 19768, 19769, 19766, 19767, 19764, 19765, 19762, 19759, 19757, 19753, 19751, 19750, 19748, 19746, 19747, 19740, 19738, 19739, 19735, 19733, 19731, 19730, 19727, 19726, 19724, 19725, 19722, 19719, 19716, 19712, 19709, 19705, 19706, 19704, 19700, 19699, 19694, 19692, 19693, 19691, 19689, 19687, 19688, 19686, 19684, 19680, 19681, 19679, 19677, 19674, 19672, 19670, 19667, 19664, 19665, 19663, 19661, 19659, 19654, 19655, 19652, 19650, 19646, 19647, 19640, 19637, 19638, 19634, 19635, 19633, 19631, 19629, 19630, 19627, 19628, 19626, 19624, 19625, 19622, 19623, 19621, 19619, 19620, 19615, 19613, 19609, 19608, 19607, 19603, 19604, 19601, 19602, 19600, 19598, 19595, 19594, 19592, 19591, 19589, 19590, 19586, 19585, 19579, 19575, 19576, 19572, 19571, 19570, 19568, 19566, 19565, 19563, 19561, 19562, 19559, 19557, 19555, 19554, 19552, 19550, 19551, 19549, 19547, 19544, 19545, 19542, 19543, 19541, 19539, 19538, 19536, 19534, 19530, 19531, 19529, 19527, 19526, 19524, 19523, 19521, 19520, 19518, 19517, 19515, 19514, 19512, 19513, 19509, 19508, 19506, 19505, 19503, 19501, 19500, 19499, 19497, 19494, 19492, 19490, 19488, 19486, 19485, 19483, 19481, 19480, 15489, 17882, 17878, 17881, 17880, 17879, 17895, 17693, 17739, 17707, 18372, 18275, 18327, 18300, 18351, 18325, 18326, 17832, 18056, 10050, 17386, 16612, 17319, 17318, 17023, 16371, 16279, 16425, 25912, 25905, 15352, 15540, 10229, 25852, 16725, 13312, 15825, 15435, 15531, 11858, 16206, 14796, 11463, 11196, 10516, 11583, 13321, 10502, 16298, 16205, 14288, 15326, 16189, 25913, 25916, 25899, 25903, 25904, 13656, 25891, 25892, 25893, 25894, 25895, 13312, 25886, 14364, 25881, 25876, 25878, 25872, 25870, 25867, 25868, 25850, 25846, 25843, 16722, 16723, 12264, 16561, 16515, 16714, 16715, 16719, 16273, 16183, 16304, 16343, 16347, 16590, 16571, 16190, 16194, 16198, 16199, 16200, 16210, 16218, 13884, 25919, 16116, 25901, 13771, 15223, 14289, 15357, 15358, 10092, 25898, 15353, 25900, 14296, 10824, 14793, 14206, 16061, 10898, 11446, 14285, 14295, 25885, 15526, 25887, 11216, 25888, 25889, 13292, 11226, 25890, 13563, 15140, 13770, 15621, 15856, 14282, 15476, 10237, 10096, 25880, 15093, 13767, 15398, 25874, 25861, 25862, 14786, 15777, 15713, 11412, 15707, 15575, 14788, 15530, 15533, 14967, 15816, 14820, 25848, 14890, 25851, 25855, 14005, 15541, 13430, 15426, 13302, 11448, 15319, 10541, 16012, 25839, 14783, 14784, 14785, 10518, 11194, 11232, 13768, 13760, 25875, 11126, 15530, 25906, 25908, 25909, 10068, 10685, 13778, 13831, 15178, 25914, 25917, 25897, 16345, 15304, 25915, 16204, 16589, 25911, 11716, 16112, 16284, 16459, 16580, 16557, 25902, 16061, 25907, 16398, 16186, 16208, 16251, 25882, 14208, 25883, 16173, 17275, 10040, 10615, 11050, 11557, 13173, 15713, 25865, 16230, 16591, 16587, 16544, 16539, 16419, 16124, 16151, 13840, 16207, 25871, 16264, 16166, 16379, 16578, 16579, 16548, 25869, 16215, 16492, 16575, 16553, 25859, 14786, 25863, 25864, 25918, 16348, 16196, 16201, 16203, 16213, 16397, 16550, 16292, 16102, 10037, 25857, 25858, 15532, 25845, 25849, 25853, 25854, 25856, 25844, 17279, 11349, 25840, 25841, 25842, 25838, 13151, 25847, 25860, 25879, 25896) OR t0.id IS NULL);

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\Team	1124
App\StartPlatz\Bundle\AlphaBundle\Entity\Page	1
App\StartPlatz\Bundle\StartupBundle\Entity\Batch	1
App\StartPlatz\Bundle\StartupBundle\Entity\Program	1

Entities Mapping

Class	Mapping errors
App\StartPlatz\Bundle\UserBundle\Entity\User	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Startup	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\StartupRelevance	No errors.
App\StartPlatz\Bundle\AlphaBundle\Entity\Page	No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\Option	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Batch	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Program	No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\Team	No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\MemberTeam	No errors.

Symfony Profiler

GET https://www.staging.startplatz.de/en/startups

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping