Symfony Profiler

Query Metrics

11 Database Queries

8 Different statements

107.36 ms Query time

0 Invalid entities

1125 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 1188
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.hasFollowUp AS hasFollowUp_24, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_25, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_26, t0.isFutureEvent AS isFutureEvent_27, t0.visibility AS visibility_28, t0.access AS access_29, t0.tags AS tags_30, t0.typeformLink AS typeformLink_31, t0.zoomLink AS zoomLink_32, t0.bgImageUrl AS bgImageUrl_33, t0.startDate AS startDate_34, t0.endDate AS endDate_35, t0.taxBehavior AS taxBehavior_36, t0.paymentProvider AS paymentProvider_37, t0.isFreeForKiCampus AS isFreeForKiCampus_38, t0.isFreeForCommunity AS isFreeForCommunity_39, t0.registrationMode AS registrationMode_40, t0.externalRegistrationUrl AS externalRegistrationUrl_41, t0.externalPlatform AS externalPlatform_42, t0.registrationHeadline AS registrationHeadline_43, t0.registrationSubtitle AS registrationSubtitle_44, t0.registrationButtonText AS registrationButtonText_45, t0.registrationPriceHtml AS registrationPriceHtml_46, t0.registrationRedirectUrl AS registrationRedirectUrl_47, t0.lumaEventApiId AS lumaEventApiId_48, t0.meetupEventId AS meetupEventId_49, t0.meetupEventUrl AS meetupEventUrl_50, t0.mailDesignTemplate AS mailDesignTemplate_51, t0.senderMail AS senderMail_52, t0.fromName AS fromName_53, t0.recipientMonitoringMail AS recipientMonitoringMail_54, t0.confirmationMailSubject AS confirmationMailSubject_55, t0.confirmationMailContent AS confirmationMailContent_56, t0.adminNotificationMailSubject AS adminNotificationMailSubject_57, t0.adminNotificationMailContent AS adminNotificationMailContent_58, t0.reminderMailTemplateId AS reminderMailTemplateId_59, t0.reminderSenderEmail AS reminderSenderEmail_60, t0.reminderMailSendDate AS reminderMailSendDate_61, t0.reminderMailSubject AS reminderMailSubject_62, t0.reminderMailContent AS reminderMailContent_63, t0.$reminderMailStatus AS reminderMailStatus_64, t0.surveyId AS surveyId_65, t0.surveyMailTemplateId AS surveyMailTemplateId_66, t0.surveyBulkMailId AS surveyBulkMailId_67, t0.template AS template_68, t0.pageTemplate AS pageTemplate_69, t0.footerTemplate AS footerTemplate_70, t0.email AS email_71, t0.emailSubject AS emailSubject_72, t0.emailContent AS emailContent_73, t0.landingPageContent AS landingPageContent_74, t0.landingPageDescription AS landingPageDescription_75, t0.landingPageCss AS landingPageCss_76, t0.landingPageJs AS landingPageJs_77, t0.landingPageFooterTemplate AS landingPageFooterTemplate_78, t0.landingPageTitle AS landingPageTitle_79, t0.landingPageTwig AS landingPageTwig_80, t0.title AS title_81, t0.teaser AS teaser_82, t0.navbar AS navbar_83, t0.content AS content_84, t0.contentTwig AS contentTwig_85, t0.ctaContent AS ctaContent_86, t0.postCtaContent AS postCtaContent_87, t0.tagline AS tagline_88, t0.seoTitle AS seoTitle_89, t0.seoDescription AS seoDescription_90, t0.seoKeyword AS seoKeyword_91, t0.imagelink AS imagelink_92, t0.bgImagelink AS bgImagelink_93, t0.additionalCss AS additionalCss_94, t0.additionalJs AS additionalJs_95, t0.navbarEn AS navbarEn_96, t0.teaserEn AS teaserEn_97, t0.contentEn AS contentEn_98, t0.contentTwigEn AS contentTwigEn_99, t0.postCtaContentEn AS postCtaContentEn_100, t0.seoTitleEn AS seoTitleEn_101, t0.seoDescriptionEn AS seoDescriptionEn_102, t0.seoKeywordEn AS seoKeywordEn_103, t0.trainer AS trainer_104, t0.videolink AS videolink_105, t0.goToPage AS goToPage_106, t0.phrasesDe AS phrasesDe_107, t0.phrasesEn AS phrasesEn_108, t0.settings AS settings_109, t0.capacity AS capacity_110, t0.asssesmentDimensions AS asssesmentDimensions_111, t0.start AS start_112, t0.end AS end_113, t0.pitchTopic AS pitchTopic_114, t0.pitchImageLink AS pitchImageLink_115, t0.pitchVideoLink AS pitchVideoLink_116, t0.pitchPartner AS pitchPartner_117, t0.pitchPartnerId AS pitchPartnerId_118, t0.pitchDescription AS pitchDescription_119, t0.followUpPageContent AS followUpPageContent_120, t0.followUpPageDescription AS followUpPageDescription_121, t0.followUpPageCss AS followUpPageCss_122, t0.followUpPageJs AS followUpPageJs_123, t0.followUpPageFooterTemplate AS followUpPageFooterTemplate_124, t0.followUpPageTitle AS followUpPageTitle_125, t0.followUpDescription AS followUpDescription_126, t0.followUpVideoLink AS followUpVideoLink_127, t0.followUpPresentation AS followUpPresentation_128, t0.followUpSkoolUrl AS followUpSkoolUrl_129, t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_130, t0.followUpCtaText AS followUpCtaText_131, t0.followUpCtaUrl AS followUpCtaUrl_132, t0.followUpDocuments AS followUpDocuments_133, t0.followUpPhotos AS followUpPhotos_134, t0.followUpExtraLinks AS followUpExtraLinks_135, t0.followUpChecklist AS followUpChecklist_136, t0.pitchDate AS pitchDate_137, t0.pitchTime AS pitchTime_138, t0.prepitchDate AS prepitchDate_139, t0.city AS city_140, t0.applicationsCount AS applicationsCount_141, t0.startedCount AS startedCount_142, t0.appliedCount AS appliedCount_143, t0.approvedCount AS approvedCount_144, t0.rejectedCount AS rejectedCount_145, t0.$skoolWebhook AS skoolWebhook_146, t0.zapierWebhook AS zapierWebhook_147, t0.history AS history_148, t0.createdAt AS createdAt_149, t0.lastModified AS lastModified_150, t0.lastChangeUser AS lastChangeUser_151, t0.programId AS programId_152, t0.assessmentTeamId AS assessmentTeamId_153 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.hasStartupMembership AS hasStartupMembership_21, t0.isIncludeInUpdateType AS isIncludeInUpdateType_22, t0.isCompany AS isCompany_23, t0.isAddressComplete AS isAddressComplete_24, t0.isDebitor AS isDebitor_25, t0.type AS type_26, t0.internalDescription AS internalDescription_27, t0.monsumCustomerType AS monsumCustomerType_28, t0.homepage AS homepage_29, t0.logoURL AS logoURL_30, t0.industries AS industries_31, t0.description AS description_32, t0.note AS note_33, t0.tags AS tags_34, t0.categories AS categories_35, t0.alertNote AS alertNote_36, t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_37, t0.monthlyExtraBudget AS monthlyExtraBudget_38, t0.sameDayBudget AS sameDayBudget_39, t0.sameDayBudgetUsed AS sameDayBudgetUsed_40, t0.sameDayExtraBudget AS sameDayExtraBudget_41, t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_42, t0.communityBudget AS communityBudget_43, t0.communityBudgetUsed AS communityBudgetUsed_44, t0.meetingRoomsBudget AS meetingRoomsBudget_45, t0.conferenceRoomsBudget AS conferenceRoomsBudget_46, t0.coffeeCoinsBudget AS coffeeCoinsBudget_47, t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_48, t0.meetingRoomsBooked AS meetingRoomsBooked_49, t0.conferenceRoomsBooked AS conferenceRoomsBooked_50, t0.todayRoomsBooked AS todayRoomsBooked_51, t0.nDedicatedDesks AS nDedicatedDesks_52, t0.nFlexibleDesks AS nFlexibleDesks_53, t0.nBasicMemberships AS nBasicMemberships_54, t0.nEmployees AS nEmployees_55, t0.nTransponders AS nTransponders_56, t0.nTiefgarage AS nTiefgarage_57, t0.editStatus AS editStatus_58, t0.xing AS xing_59, t0.linkedin AS linkedin_60, t0.facebook AS facebook_61, t0.twitter AS twitter_62, t0.instagram AS instagram_63, t0.enterDate AS enterDate_64, t0.lastChangeDate AS lastChangeDate_65, t0.lastModified AS lastModified_66, t0.lastInvoiceDate AS lastInvoiceDate_67, t0.exitDate AS exitDate_68, t0.isRedundant AS isRedundant_69, t0.gsStatus AS gsStatus_70, t0.gsBatchNo AS gsBatchNo_71, t0.gsNote AS gsNote_72, t0.gsIdeenblattDate AS gsIdeenblattDate_73, t0.gsJuryDate AS gsJuryDate_74, t0.gsCoachMemberId AS gsCoachMemberId_75, t0.gsCoachMemberName AS gsCoachMemberName_76, t0.spContactPerson AS spContactPerson_77, t0.memberTag AS memberTag_78, t0.actionTag AS actionTag_79, t0.createdAt AS createdAt_80, t0.lastChangeUser AS lastChangeUser_81, t0.history AS history_82, t0.treatAsSubscribed AS treatAsSubscribed_83, t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_84, t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_85, t0.treatAsSubscribedReason AS treatAsSubscribedReason_86, t0.searchAliases AS searchAliases_87 FROM sp_teams t0 WHERE (t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR t0.id IS NULL)

#▲	Time	Info
1	0.57 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	8.64 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 1188 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 1188 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 1188;
3	0.50 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	0.81 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.hasFollowUp AS hasFollowUp_24, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_25, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_26, t0.isFutureEvent AS isFutureEvent_27, t0.visibility AS visibility_28, t0.access AS access_29, t0.tags AS tags_30, t0.typeformLink AS typeformLink_31, t0.zoomLink AS zoomLink_32, t0.bgImageUrl AS bgImageUrl_33, t0.startDate AS startDate_34, t0.endDate AS endDate_35, t0.taxBehavior AS taxBehavior_36, t0.paymentProvider AS paymentProvider_37, t0.isFreeForKiCampus AS isFreeForKiCampus_38, t0.isFreeForCommunity AS isFreeForCommunity_39, t0.registrationMode AS registrationMode_40, t0.externalRegistrationUrl AS externalRegistrationUrl_41, t0.externalPlatform AS externalPlatform_42, t0.registrationHeadline AS registrationHeadline_43, t0.registrationSubtitle AS registrationSubtitle_44, t0.registrationButtonText AS registrationButtonText_45, t0.registrationPriceHtml AS registrationPriceHtml_46, t0.registrationRedirectUrl AS registrationRedirectUrl_47, t0.lumaEventApiId AS lumaEventApiId_48, t0.meetupEventId AS meetupEventId_49, t0.meetupEventUrl AS meetupEventUrl_50, t0.mailDesignTemplate AS mailDesignTemplate_51, t0.senderMail AS senderMail_52, t0.fromName AS fromName_53, t0.recipientMonitoringMail AS recipientMonitoringMail_54, t0.confirmationMailSubject AS confirmationMailSubject_55, t0.confirmationMailContent AS confirmationMailContent_56, t0.adminNotificationMailSubject AS adminNotificationMailSubject_57, t0.adminNotificationMailContent AS adminNotificationMailContent_58, t0.reminderMailTemplateId AS reminderMailTemplateId_59, t0.reminderSenderEmail AS reminderSenderEmail_60, t0.reminderMailSendDate AS reminderMailSendDate_61, t0.reminderMailSubject AS reminderMailSubject_62, t0.reminderMailContent AS reminderMailContent_63, t0.$reminderMailStatus AS reminderMailStatus_64, t0.surveyId AS surveyId_65, t0.surveyMailTemplateId AS surveyMailTemplateId_66, t0.surveyBulkMailId AS surveyBulkMailId_67, t0.template AS template_68, t0.pageTemplate AS pageTemplate_69, t0.footerTemplate AS footerTemplate_70, t0.email AS email_71, t0.emailSubject AS emailSubject_72, t0.emailContent AS emailContent_73, t0.landingPageContent AS landingPageContent_74, t0.landingPageDescription AS landingPageDescription_75, t0.landingPageCss AS landingPageCss_76, t0.landingPageJs AS landingPageJs_77, t0.landingPageFooterTemplate AS landingPageFooterTemplate_78, t0.landingPageTitle AS landingPageTitle_79, t0.landingPageTwig AS landingPageTwig_80, t0.title AS title_81, t0.teaser AS teaser_82, t0.navbar AS navbar_83, t0.content AS content_84, t0.contentTwig AS contentTwig_85, t0.ctaContent AS ctaContent_86, t0.postCtaContent AS postCtaContent_87, t0.tagline AS tagline_88, t0.seoTitle AS seoTitle_89, t0.seoDescription AS seoDescription_90, t0.seoKeyword AS seoKeyword_91, t0.imagelink AS imagelink_92, t0.bgImagelink AS bgImagelink_93, t0.additionalCss AS additionalCss_94, t0.additionalJs AS additionalJs_95, t0.navbarEn AS navbarEn_96, t0.teaserEn AS teaserEn_97, t0.contentEn AS contentEn_98, t0.contentTwigEn AS contentTwigEn_99, t0.postCtaContentEn AS postCtaContentEn_100, t0.seoTitleEn AS seoTitleEn_101, t0.seoDescriptionEn AS seoDescriptionEn_102, t0.seoKeywordEn AS seoKeywordEn_103, t0.trainer AS trainer_104, t0.videolink AS videolink_105, t0.goToPage AS goToPage_106, t0.phrasesDe AS phrasesDe_107, t0.phrasesEn AS phrasesEn_108, t0.settings AS settings_109, t0.capacity AS capacity_110, t0.asssesmentDimensions AS asssesmentDimensions_111, t0.start AS start_112, t0.end AS end_113, t0.pitchTopic AS pitchTopic_114, t0.pitchImageLink AS pitchImageLink_115, t0.pitchVideoLink AS pitchVideoLink_116, t0.pitchPartner AS pitchPartner_117, t0.pitchPartnerId AS pitchPartnerId_118, t0.pitchDescription AS pitchDescription_119, t0.followUpPageContent AS followUpPageContent_120, t0.followUpPageDescription AS followUpPageDescription_121, t0.followUpPageCss AS followUpPageCss_122, t0.followUpPageJs AS followUpPageJs_123, t0.followUpPageFooterTemplate AS followUpPageFooterTemplate_124, t0.followUpPageTitle AS followUpPageTitle_125, t0.followUpDescription AS followUpDescription_126, t0.followUpVideoLink AS followUpVideoLink_127, t0.followUpPresentation AS followUpPresentation_128, t0.followUpSkoolUrl AS followUpSkoolUrl_129, t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_130, t0.followUpCtaText AS followUpCtaText_131, t0.followUpCtaUrl AS followUpCtaUrl_132, t0.followUpDocuments AS followUpDocuments_133, t0.followUpPhotos AS followUpPhotos_134, t0.followUpExtraLinks AS followUpExtraLinks_135, t0.followUpChecklist AS followUpChecklist_136, t0.pitchDate AS pitchDate_137, t0.pitchTime AS pitchTime_138, t0.prepitchDate AS prepitchDate_139, t0.city AS city_140, t0.applicationsCount AS applicationsCount_141, t0.startedCount AS startedCount_142, t0.appliedCount AS appliedCount_143, t0.approvedCount AS approvedCount_144, t0.rejectedCount AS rejectedCount_145, t0.$skoolWebhook AS skoolWebhook_146, t0.zapierWebhook AS zapierWebhook_147, t0.history AS history_148, t0.createdAt AS createdAt_149, t0.lastModified AS lastModified_150, t0.lastChangeUser AS lastChangeUser_151, t0.programId AS programId_152, t0.assessmentTeamId AS assessmentTeamId_153 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.hasFollowUp AS hasFollowUp_24, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_25, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_26, t0.isFutureEvent AS isFutureEvent_27, t0.visibility AS visibility_28, t0.access AS access_29, t0.tags AS tags_30, t0.typeformLink AS typeformLink_31, t0.zoomLink AS zoomLink_32, t0.bgImageUrl AS bgImageUrl_33, t0.startDate AS startDate_34, t0.endDate AS endDate_35, t0.taxBehavior AS taxBehavior_36, t0.paymentProvider AS paymentProvider_37, t0.isFreeForKiCampus AS isFreeForKiCampus_38, t0.isFreeForCommunity AS isFreeForCommunity_39, t0.registrationMode AS registrationMode_40, t0.externalRegistrationUrl AS externalRegistrationUrl_41, t0.externalPlatform AS externalPlatform_42, t0.registrationHeadline AS registrationHeadline_43, t0.registrationSubtitle AS registrationSubtitle_44, t0.registrationButtonText AS registrationButtonText_45, t0.registrationPriceHtml AS registrationPriceHtml_46, t0.registrationRedirectUrl AS registrationRedirectUrl_47, t0.lumaEventApiId AS lumaEventApiId_48, t0.meetupEventId AS meetupEventId_49, t0.meetupEventUrl AS meetupEventUrl_50, t0.mailDesignTemplate AS mailDesignTemplate_51, t0.senderMail AS senderMail_52, t0.fromName AS fromName_53, t0.recipientMonitoringMail AS recipientMonitoringMail_54, t0.confirmationMailSubject AS confirmationMailSubject_55, t0.confirmationMailContent AS confirmationMailContent_56, t0.adminNotificationMailSubject AS adminNotificationMailSubject_57, t0.adminNotificationMailContent AS adminNotificationMailContent_58, t0.reminderMailTemplateId AS reminderMailTemplateId_59, t0.reminderSenderEmail AS reminderSenderEmail_60, t0.reminderMailSendDate AS reminderMailSendDate_61, t0.reminderMailSubject AS reminderMailSubject_62, t0.reminderMailContent AS reminderMailContent_63, t0.$reminderMailStatus AS reminderMailStatus_64, t0.surveyId AS surveyId_65, t0.surveyMailTemplateId AS surveyMailTemplateId_66, t0.surveyBulkMailId AS surveyBulkMailId_67, t0.template AS template_68, t0.pageTemplate AS pageTemplate_69, t0.footerTemplate AS footerTemplate_70, t0.email AS email_71, t0.emailSubject AS emailSubject_72, t0.emailContent AS emailContent_73, t0.landingPageContent AS landingPageContent_74, t0.landingPageDescription AS landingPageDescription_75, t0.landingPageCss AS landingPageCss_76, t0.landingPageJs AS landingPageJs_77, t0.landingPageFooterTemplate AS landingPageFooterTemplate_78, t0.landingPageTitle AS landingPageTitle_79, t0.landingPageTwig AS landingPageTwig_80, t0.title AS title_81, t0.teaser AS teaser_82, t0.navbar AS navbar_83, t0.content AS content_84, t0.contentTwig AS contentTwig_85, t0.ctaContent AS ctaContent_86, t0.postCtaContent AS postCtaContent_87, t0.tagline AS tagline_88, t0.seoTitle AS seoTitle_89, t0.seoDescription AS seoDescription_90, t0.seoKeyword AS seoKeyword_91, t0.imagelink AS imagelink_92, t0.bgImagelink AS bgImagelink_93, t0.additionalCss AS additionalCss_94, t0.additionalJs AS additionalJs_95, t0.navbarEn AS navbarEn_96, t0.teaserEn AS teaserEn_97, t0.contentEn AS contentEn_98, t0.contentTwigEn AS contentTwigEn_99, t0.postCtaContentEn AS postCtaContentEn_100, t0.seoTitleEn AS seoTitleEn_101, t0.seoDescriptionEn AS seoDescriptionEn_102, t0.seoKeywordEn AS seoKeywordEn_103, t0.trainer AS trainer_104, t0.videolink AS videolink_105, t0.goToPage AS goToPage_106, t0.phrasesDe AS phrasesDe_107, t0.phrasesEn AS phrasesEn_108, t0.settings AS settings_109, t0.capacity AS capacity_110, t0.asssesmentDimensions AS asssesmentDimensions_111, t0.start AS start_112, t0.end AS end_113, t0.pitchTopic AS pitchTopic_114, t0.pitchImageLink AS pitchImageLink_115, t0.pitchVideoLink AS pitchVideoLink_116, t0.pitchPartner AS pitchPartner_117, t0.pitchPartnerId AS pitchPartnerId_118, t0.pitchDescription AS pitchDescription_119, t0.followUpPageContent AS followUpPageContent_120, t0.followUpPageDescription AS followUpPageDescription_121, t0.followUpPageCss AS followUpPageCss_122, t0.followUpPageJs AS followUpPageJs_123, t0.followUpPageFooterTemplate AS followUpPageFooterTemplate_124, t0.followUpPageTitle AS followUpPageTitle_125, t0.followUpDescription AS followUpDescription_126, t0.followUpVideoLink AS followUpVideoLink_127, t0.followUpPresentation AS followUpPresentation_128, t0.followUpSkoolUrl AS followUpSkoolUrl_129, t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_130, t0.followUpCtaText AS followUpCtaText_131, t0.followUpCtaUrl AS followUpCtaUrl_132, t0.followUpDocuments AS followUpDocuments_133, t0.followUpPhotos AS followUpPhotos_134, t0.followUpExtraLinks AS followUpExtraLinks_135, t0.followUpChecklist AS followUpChecklist_136, t0.pitchDate AS pitchDate_137, t0.pitchTime AS pitchTime_138, t0.prepitchDate AS prepitchDate_139, t0.city AS city_140, t0.applicationsCount AS applicationsCount_141, t0.startedCount AS startedCount_142, t0.appliedCount AS appliedCount_143, t0.approvedCount AS approvedCount_144, t0.rejectedCount AS rejectedCount_145, t0.$skoolWebhook AS skoolWebhook_146, t0.zapierWebhook AS zapierWebhook_147, t0.history AS history_148, t0.createdAt AS createdAt_149, t0.lastModified AS lastModified_150, t0.lastChangeUser AS lastChangeUser_151, t0.programId AS programId_152, t0.assessmentTeamId AS assessmentTeamId_153 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.hasFollowUp AS hasFollowUp_24, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_25, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_26, t0.isFutureEvent AS isFutureEvent_27, t0.visibility AS visibility_28, t0.access AS access_29, t0.tags AS tags_30, t0.typeformLink AS typeformLink_31, t0.zoomLink AS zoomLink_32, t0.bgImageUrl AS bgImageUrl_33, t0.startDate AS startDate_34, t0.endDate AS endDate_35, t0.taxBehavior AS taxBehavior_36, t0.paymentProvider AS paymentProvider_37, t0.isFreeForKiCampus AS isFreeForKiCampus_38, t0.isFreeForCommunity AS isFreeForCommunity_39, t0.registrationMode AS registrationMode_40, t0.externalRegistrationUrl AS externalRegistrationUrl_41, t0.externalPlatform AS externalPlatform_42, t0.registrationHeadline AS registrationHeadline_43, t0.registrationSubtitle AS registrationSubtitle_44, t0.registrationButtonText AS registrationButtonText_45, t0.registrationPriceHtml AS registrationPriceHtml_46, t0.registrationRedirectUrl AS registrationRedirectUrl_47, t0.lumaEventApiId AS lumaEventApiId_48, t0.meetupEventId AS meetupEventId_49, t0.meetupEventUrl AS meetupEventUrl_50, t0.mailDesignTemplate AS mailDesignTemplate_51, t0.senderMail AS senderMail_52, t0.fromName AS fromName_53, t0.recipientMonitoringMail AS recipientMonitoringMail_54, t0.confirmationMailSubject AS confirmationMailSubject_55, t0.confirmationMailContent AS confirmationMailContent_56, t0.adminNotificationMailSubject AS adminNotificationMailSubject_57, t0.adminNotificationMailContent AS adminNotificationMailContent_58, t0.reminderMailTemplateId AS reminderMailTemplateId_59, t0.reminderSenderEmail AS reminderSenderEmail_60, t0.reminderMailSendDate AS reminderMailSendDate_61, t0.reminderMailSubject AS reminderMailSubject_62, t0.reminderMailContent AS reminderMailContent_63, t0.$reminderMailStatus AS reminderMailStatus_64, t0.surveyId AS surveyId_65, t0.surveyMailTemplateId AS surveyMailTemplateId_66, t0.surveyBulkMailId AS surveyBulkMailId_67, t0.template AS template_68, t0.pageTemplate AS pageTemplate_69, t0.footerTemplate AS footerTemplate_70, t0.email AS email_71, t0.emailSubject AS emailSubject_72, t0.emailContent AS emailContent_73, t0.landingPageContent AS landingPageContent_74, t0.landingPageDescription AS landingPageDescription_75, t0.landingPageCss AS landingPageCss_76, t0.landingPageJs AS landingPageJs_77, t0.landingPageFooterTemplate AS landingPageFooterTemplate_78, t0.landingPageTitle AS landingPageTitle_79, t0.landingPageTwig AS landingPageTwig_80, t0.title AS title_81, t0.teaser AS teaser_82, t0.navbar AS navbar_83, t0.content AS content_84, t0.contentTwig AS contentTwig_85, t0.ctaContent AS ctaContent_86, t0.postCtaContent AS postCtaContent_87, t0.tagline AS tagline_88, t0.seoTitle AS seoTitle_89, t0.seoDescription AS seoDescription_90, t0.seoKeyword AS seoKeyword_91, t0.imagelink AS imagelink_92, t0.bgImagelink AS bgImagelink_93, t0.additionalCss AS additionalCss_94, t0.additionalJs AS additionalJs_95, t0.navbarEn AS navbarEn_96, t0.teaserEn AS teaserEn_97, t0.contentEn AS contentEn_98, t0.contentTwigEn AS contentTwigEn_99, t0.postCtaContentEn AS postCtaContentEn_100, t0.seoTitleEn AS seoTitleEn_101, t0.seoDescriptionEn AS seoDescriptionEn_102, t0.seoKeywordEn AS seoKeywordEn_103, t0.trainer AS trainer_104, t0.videolink AS videolink_105, t0.goToPage AS goToPage_106, t0.phrasesDe AS phrasesDe_107, t0.phrasesEn AS phrasesEn_108, t0.settings AS settings_109, t0.capacity AS capacity_110, t0.asssesmentDimensions AS asssesmentDimensions_111, t0.start AS start_112, t0.end AS end_113, t0.pitchTopic AS pitchTopic_114, t0.pitchImageLink AS pitchImageLink_115, t0.pitchVideoLink AS pitchVideoLink_116, t0.pitchPartner AS pitchPartner_117, t0.pitchPartnerId AS pitchPartnerId_118, t0.pitchDescription AS pitchDescription_119, t0.followUpPageContent AS followUpPageContent_120, t0.followUpPageDescription AS followUpPageDescription_121, t0.followUpPageCss AS followUpPageCss_122, t0.followUpPageJs AS followUpPageJs_123, t0.followUpPageFooterTemplate AS followUpPageFooterTemplate_124, t0.followUpPageTitle AS followUpPageTitle_125, t0.followUpDescription AS followUpDescription_126, t0.followUpVideoLink AS followUpVideoLink_127, t0.followUpPresentation AS followUpPresentation_128, t0.followUpSkoolUrl AS followUpSkoolUrl_129, t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_130, t0.followUpCtaText AS followUpCtaText_131, t0.followUpCtaUrl AS followUpCtaUrl_132, t0.followUpDocuments AS followUpDocuments_133, t0.followUpPhotos AS followUpPhotos_134, t0.followUpExtraLinks AS followUpExtraLinks_135, t0.followUpChecklist AS followUpChecklist_136, t0.pitchDate AS pitchDate_137, t0.pitchTime AS pitchTime_138, t0.prepitchDate AS prepitchDate_139, t0.city AS city_140, t0.applicationsCount AS applicationsCount_141, t0.startedCount AS startedCount_142, t0.appliedCount AS appliedCount_143, t0.approvedCount AS approvedCount_144, t0.rejectedCount AS rejectedCount_145, t0.$skoolWebhook AS skoolWebhook_146, t0.zapierWebhook AS zapierWebhook_147, t0.history AS history_148, t0.createdAt AS createdAt_149, t0.lastModified AS lastModified_150, t0.lastChangeUser AS lastChangeUser_151, t0.programId AS programId_152, t0.assessmentTeamId AS assessmentTeamId_153 FROM sp_batches t0 WHERE t0.programId = 3 AND t0.focusStatus = '2_current' LIMIT 1;
5	3.06 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	2.78 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	2.83 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	7.00 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.56 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	1.83 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	69.80 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.hasStartupMembership AS hasStartupMembership_21, t0.isIncludeInUpdateType AS isIncludeInUpdateType_22, t0.isCompany AS isCompany_23, t0.isAddressComplete AS isAddressComplete_24, t0.isDebitor AS isDebitor_25, t0.type AS type_26, t0.internalDescription AS internalDescription_27, t0.monsumCustomerType AS monsumCustomerType_28, t0.homepage AS homepage_29, t0.logoURL AS logoURL_30, t0.industries AS industries_31, t0.description AS description_32, t0.note AS note_33, t0.tags AS tags_34, t0.categories AS categories_35, t0.alertNote AS alertNote_36, t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_37, t0.monthlyExtraBudget AS monthlyExtraBudget_38, t0.sameDayBudget AS sameDayBudget_39, t0.sameDayBudgetUsed AS sameDayBudgetUsed_40, t0.sameDayExtraBudget AS sameDayExtraBudget_41, t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_42, t0.communityBudget AS communityBudget_43, t0.communityBudgetUsed AS communityBudgetUsed_44, t0.meetingRoomsBudget AS meetingRoomsBudget_45, t0.conferenceRoomsBudget AS conferenceRoomsBudget_46, t0.coffeeCoinsBudget AS coffeeCoinsBudget_47, t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_48, t0.meetingRoomsBooked AS meetingRoomsBooked_49, t0.conferenceRoomsBooked AS conferenceRoomsBooked_50, t0.todayRoomsBooked AS todayRoomsBooked_51, t0.nDedicatedDesks AS nDedicatedDesks_52, t0.nFlexibleDesks AS nFlexibleDesks_53, t0.nBasicMemberships AS nBasicMemberships_54, t0.nEmployees AS nEmployees_55, t0.nTransponders AS nTransponders_56, t0.nTiefgarage AS nTiefgarage_57, t0.editStatus AS editStatus_58, t0.xing AS xing_59, t0.linkedin AS linkedin_60, t0.facebook AS facebook_61, t0.twitter AS twitter_62, t0.instagram AS instagram_63, t0.enterDate AS enterDate_64, t0.lastChangeDate AS lastChangeDate_65, t0.lastModified AS lastModified_66, t0.lastInvoiceDate AS lastInvoiceDate_67, t0.exitDate AS exitDate_68, t0.isRedundant AS isRedundant_69, t0.gsStatus AS gsStatus_70, t0.gsBatchNo AS gsBatchNo_71, t0.gsNote AS gsNote_72, t0.gsIdeenblattDate AS gsIdeenblattDate_73, t0.gsJuryDate AS gsJuryDate_74, t0.gsCoachMemberId AS gsCoachMemberId_75, t0.gsCoachMemberName AS gsCoachMemberName_76, t0.spContactPerson AS spContactPerson_77, t0.memberTag AS memberTag_78, t0.actionTag AS actionTag_79, t0.createdAt AS createdAt_80, t0.lastChangeUser AS lastChangeUser_81, t0.history AS history_82, t0.treatAsSubscribed AS treatAsSubscribed_83, t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_84, t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_85, t0.treatAsSubscribedReason AS treatAsSubscribedReason_86, t0.searchAliases AS searchAliases_87 FROM sp_teams t0 WHERE (t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR t0.id IS NULL) Parameters: [11025 16713 26302 25978 25280 25282 25279 20456 24161 10590 23807 22905 17320 18111 14813 12442 11654 24218 22426 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 23729 23663 23653 16209 20155 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.hasStartupMembership AS hasStartupMembership_21, t0.isIncludeInUpdateType AS isIncludeInUpdateType_22, t0.isCompany AS isCompany_23, t0.isAddressComplete AS isAddressComplete_24, t0.isDebitor AS isDebitor_25, t0.type AS type_26, t0.internalDescription AS internalDescription_27, t0.monsumCustomerType AS monsumCustomerType_28, t0.homepage AS homepage_29, t0.logoURL AS logoURL_30, t0.industries AS industries_31, t0.description AS description_32, t0.note AS note_33, t0.tags AS tags_34, t0.categories AS categories_35, t0.alertNote AS alertNote_36, t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_37, t0.monthlyExtraBudget AS monthlyExtraBudget_38, t0.sameDayBudget AS sameDayBudget_39, t0.sameDayBudgetUsed AS sameDayBudgetUsed_40, t0.sameDayExtraBudget AS sameDayExtraBudget_41, t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_42, t0.communityBudget AS communityBudget_43, t0.communityBudgetUsed AS communityBudgetUsed_44, t0.meetingRoomsBudget AS meetingRoomsBudget_45, t0.conferenceRoomsBudget AS conferenceRoomsBudget_46, t0.coffeeCoinsBudget AS coffeeCoinsBudget_47, t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_48, t0.meetingRoomsBooked AS meetingRoomsBooked_49, t0.conferenceRoomsBooked AS conferenceRoomsBooked_50, t0.todayRoomsBooked AS todayRoomsBooked_51, t0.nDedicatedDesks AS nDedicatedDesks_52, t0.nFlexibleDesks AS nFlexibleDesks_53, t0.nBasicMemberships AS nBasicMemberships_54, t0.nEmployees AS nEmployees_55, t0.nTransponders AS nTransponders_56, t0.nTiefgarage AS nTiefgarage_57, t0.editStatus AS editStatus_58, t0.xing AS xing_59, t0.linkedin AS linkedin_60, t0.facebook AS facebook_61, t0.twitter AS twitter_62, t0.instagram AS instagram_63, t0.enterDate AS enterDate_64, t0.lastChangeDate AS lastChangeDate_65, t0.lastModified AS lastModified_66, t0.lastInvoiceDate AS lastInvoiceDate_67, t0.exitDate AS exitDate_68, t0.isRedundant AS isRedundant_69, t0.gsStatus AS gsStatus_70, t0.gsBatchNo AS gsBatchNo_71, t0.gsNote AS gsNote_72, t0.gsIdeenblattDate AS gsIdeenblattDate_73, t0.gsJuryDate AS gsJuryDate_74, t0.gsCoachMemberId AS gsCoachMemberId_75, t0.gsCoachMemberName AS gsCoachMemberName_76, t0.spContactPerson AS spContactPerson_77, t0.memberTag AS memberTag_78, t0.actionTag AS actionTag_79, t0.createdAt AS createdAt_80, t0.lastChangeUser AS lastChangeUser_81, t0.history AS history_82, t0.treatAsSubscribed AS treatAsSubscribed_83, t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_84, t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_85, t0.treatAsSubscribedReason AS treatAsSubscribedReason_86, t0.searchAliases AS searchAliases_87 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.hasStartupMembership AS hasStartupMembership_21, t0.isIncludeInUpdateType AS isIncludeInUpdateType_22, t0.isCompany AS isCompany_23, t0.isAddressComplete AS isAddressComplete_24, t0.isDebitor AS isDebitor_25, t0.type AS type_26, t0.internalDescription AS internalDescription_27, t0.monsumCustomerType AS monsumCustomerType_28, t0.homepage AS homepage_29, t0.logoURL AS logoURL_30, t0.industries AS industries_31, t0.description AS description_32, t0.note AS note_33, t0.tags AS tags_34, t0.categories AS categories_35, t0.alertNote AS alertNote_36, t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_37, t0.monthlyExtraBudget AS monthlyExtraBudget_38, t0.sameDayBudget AS sameDayBudget_39, t0.sameDayBudgetUsed AS sameDayBudgetUsed_40, t0.sameDayExtraBudget AS sameDayExtraBudget_41, t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_42, t0.communityBudget AS communityBudget_43, t0.communityBudgetUsed AS communityBudgetUsed_44, t0.meetingRoomsBudget AS meetingRoomsBudget_45, t0.conferenceRoomsBudget AS conferenceRoomsBudget_46, t0.coffeeCoinsBudget AS coffeeCoinsBudget_47, t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_48, t0.meetingRoomsBooked AS meetingRoomsBooked_49, t0.conferenceRoomsBooked AS conferenceRoomsBooked_50, t0.todayRoomsBooked AS todayRoomsBooked_51, t0.nDedicatedDesks AS nDedicatedDesks_52, t0.nFlexibleDesks AS nFlexibleDesks_53, t0.nBasicMemberships AS nBasicMemberships_54, t0.nEmployees AS nEmployees_55, t0.nTransponders AS nTransponders_56, t0.nTiefgarage AS nTiefgarage_57, t0.editStatus AS editStatus_58, t0.xing AS xing_59, t0.linkedin AS linkedin_60, t0.facebook AS facebook_61, t0.twitter AS twitter_62, t0.instagram AS instagram_63, t0.enterDate AS enterDate_64, t0.lastChangeDate AS lastChangeDate_65, t0.lastModified AS lastModified_66, t0.lastInvoiceDate AS lastInvoiceDate_67, t0.exitDate AS exitDate_68, t0.isRedundant AS isRedundant_69, t0.gsStatus AS gsStatus_70, t0.gsBatchNo AS gsBatchNo_71, t0.gsNote AS gsNote_72, t0.gsIdeenblattDate AS gsIdeenblattDate_73, t0.gsJuryDate AS gsJuryDate_74, t0.gsCoachMemberId AS gsCoachMemberId_75, t0.gsCoachMemberName AS gsCoachMemberName_76, t0.spContactPerson AS spContactPerson_77, t0.memberTag AS memberTag_78, t0.actionTag AS actionTag_79, t0.createdAt AS createdAt_80, t0.lastChangeUser AS lastChangeUser_81, t0.history AS history_82, t0.treatAsSubscribed AS treatAsSubscribed_83, t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_84, t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_85, t0.treatAsSubscribedReason AS treatAsSubscribedReason_86, t0.searchAliases AS searchAliases_87 FROM sp_teams t0 WHERE (t0.id IN (11025, 16713, 26302, 25978, 25280, 25282, 25279, 20456, 24161, 10590, 23807, 22905, 17320, 18111, 14813, 12442, 11654, 24218, 22426, 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, 23729, 23663, 23653, 16209, 20155, 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	1122
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 http://www.staging.startplatz.de/startups

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping