http://www.staging.startplatz.de/startup/3000844-circuly

Query Metrics

8 Database Queries
7 Different statements
135.26 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
96.87 ms
(71.62%)
1
SELECT t0.id AS id_1, t0.startupId AS startupId_2, t0.programId AS programId_3, t0.batchId AS batchId_4, t0.utm_source AS utm_source_5, t0.utm_medium AS utm_medium_6, t0.utm_campaign AS utm_campaign_7, t0.utm_term AS utm_term_8, t0.utm_content AS utm_content_9, t0.votesRegistered AS votesRegistered_10, t0.programName AS programName_11, t0.programSlug AS programSlug_12, t0.batchName AS batchName_13, t0.batchSlug AS batchSlug_14, t0.template AS template_15, t0.teamId AS teamId_16, t0.memberId AS memberId_17, t0.lang AS lang_18, t0.startupName AS startupName_19, t0.visibility AS visibility_20, t0.firstName AS firstName_21, t0.lastName AS lastName_22, t0.person AS person_23, t0.email AS email_24, t0.secondaryEmail AS secondaryEmail_25, t0.phone AS phone_26, t0.linkedin AS linkedin_27, t0.telegram AS telegram_28, t0.discord AS discord_29, t0.wallet AS wallet_30, t0.priceinEuroCent AS priceinEuroCent_31, t0.realPriceinEuroCent AS realPriceinEuroCent_32, t0.discountPercent AS discountPercent_33, t0.discountReason AS discountReason_34, t0.teamSize AS teamSize_35, t0.city AS city_36, t0.startupStage AS startupStage_37, t0.industry AS industry_38, t0.track AS track_39, t0.projectCategory AS projectCategory_40, t0.blockchain AS blockchain_41, t0.recommendedBy AS recommendedBy_42, t0.editStatus AS editStatus_43, t0.editMessage AS editMessage_44, t0.applicationStatus AS applicationStatus_45, t0.reviewStatus AS reviewStatus_46, t0.applicantType AS applicantType_47, t0.canReadList AS canReadList_48, t0.isSitting AS isSitting_49, t0.isNewMember AS isNewMember_50, t0.hasNewsletterPermissionGiven AS hasNewsletterPermissionGiven_51, t0.hasConfirmationMailSent AS hasConfirmationMailSent_52, t0.hasTermsAccepted AS hasTermsAccepted_53, t0.hasPaid AS hasPaid_54, t0.hasVolunteerAgreed AS hasVolunteerAgreed_55, t0.hasEmailValidated AS hasEmailValidated_56, t0.batchStatus AS batchStatus_57, t0.selectionStatus AS selectionStatus_58, t0.participationStatus AS participationStatus_59, t0.coachMemberId AS coachMemberId_60, t0.participationStartedAt AS participationStartedAt_61, t0.participationCompletedAt AS participationCompletedAt_62, t0.pitchPosition AS pitchPosition_63, t0.pitchImageLink AS pitchImageLink_64, t0.pitchVideoLink AS pitchVideoLink_65, t0.linkPitchDeck AS linkPitchDeck_66, t0.publicIdPitchDeck AS publicIdPitchDeck_67, t0.ideaPaperUrl AS ideaPaperUrl_68, t0.publicIdIdeaPaper AS publicIdIdeaPaper_69, t0.websiteUrl AS websiteUrl_70, t0.fulltime AS fulltime_71, t0.language AS language_72, t0.mvpStatus AS mvpStatus_73, t0.dealroomUrl AS dealroomUrl_74, t0.podioId AS podioId_75, t0.podioItemId AS podioItemId_76, t0.podioUrl AS podioUrl_77, t0.ideaPitch AS ideaPitch_78, t0.createdAt AS createdAt_79, t0.lastModified AS lastModified_80, t0.deletedAt AS deletedAt_81, t0.lastChangeUser AS lastChangeUser_82, t0.history AS history_83, t0.extraFields AS extraFields_84, t0.adminNotes AS adminNotes_85, t0.ratingJudge1 AS ratingJudge1_86, t0.ratingJudge2 AS ratingJudge2_87, t0.ratingJudge3 AS ratingJudge3_88, t0.ratingJudge4 AS ratingJudge4_89, t0.ratingJudge5 AS ratingJudge5_90, t0.ratingAverage AS ratingAverage_91, t0.ratingUpdatedAt AS ratingUpdatedAt_92, t0.memberTagsAtRegistration AS memberTagsAtRegistration_93, t0.wasCommunityMemberAtRegistration AS wasCommunityMemberAtRegistration_94, t0.wasPhysicalMemberAtRegistration AS wasPhysicalMemberAtRegistration_95, t0.memberUtmSourceAtRegistration AS memberUtmSourceAtRegistration_96, t0.kiKompetenzAtRegistration AS kiKompetenzAtRegistration_97, t0.pendingMemberData AS pendingMemberData_98, t0.pendingTeamData AS pendingTeamData_99, t0.resumeToken AS resumeToken_100, t0.resumeTokenExpiresAt AS resumeTokenExpiresAt_101, t0.isMemberCreated AS isMemberCreated_102, t0.isTeamCreated AS isTeamCreated_103 FROM sp_applications t0 WHERE t0.teamId = ? AND t0.programId IN (?) AND ((t0.deletedAt IS NULL))
Parameters:
[
  16347
  [
    "1"
    "2"
    "3"
  ]
]
30.77 ms
(22.75%)
1
SELECT s0_.startupName AS startupName_0, s0_.pitchPosition AS pitchPosition_1, s0_.programName AS programName_2, s0_.batchName AS batchName_3, s1_.pitchDate AS pitchDate_4, s1_.city AS city_5 FROM sp_applications s0_ INNER JOIN sp_batches s1_ ON (s0_.batchId = s1_.id) WHERE (s0_.startupId = ? AND s0_.programId = ?) AND (s0_.deletedAt IS NULL)
Parameters:
[
  "3000844"
  1
]
4.86 ms
(3.60%)
2
SELECT s0_.id AS id_0, s0_.owner AS owner_1, s0_.type AS type_2, s0_.externalId AS externalId_3, s0_.score AS score_4, s0_.name AS name_5, s0_.title AS title_6, s0_.imageLink AS imageLink_7, s0_.categories AS categories_8, s0_.tags AS tags_9, s0_.isActive AS isActive_10, s0_.lastModified AS lastModified_11, s0_.lastChangeUser AS lastChangeUser_12, s0_.createdAt AS createdAt_13, s0_.rankingScore AS rankingScore_14, s0_.eventStartDate AS eventStartDate_15, s0_.jobEndDate AS jobEndDate_16, s0_.rankingUpdatedAt AS rankingUpdatedAt_17 FROM sp_content_feed s0_ WHERE s0_.tags LIKE ? ORDER BY s0_.score DESC
Parameters:
[
  "%"circuly"%"
]
1.37 ms
(1.02%)
1
SELECT s0_.id AS id_0, s0_.spMemberId AS spMemberId_1, s0_.score AS score_2, s0_.completenessScore AS completenessScore_3, s0_.status AS status_4, s0_.location AS location_5, s0_.salutation AS salutation_6, s0_.title AS title_7, s0_.jobTitle AS jobTitle_8, s0_.firstName AS firstName_9, s0_.lastName AS lastName_10, s0_.name AS name_11, s0_.sortName AS sortName_12, s0_.email AS email_13, s0_.secondaryEmail AS secondaryEmail_14, s0_.phone AS phone_15, s0_.hasCommunityMembership AS hasCommunityMembership_16, s0_.aiMemberValid AS aiMemberValid_17, s0_.aiMemberStatus AS aiMemberStatus_18, s0_.aiMemberReason AS aiMemberReason_19, s0_.aiMemberStart AS aiMemberStart_20, s0_.aiMemberEnd AS aiMemberEnd_21, s0_.utm_source AS utm_source_22, s0_.utm_medium AS utm_medium_23, s0_.utm_campaign AS utm_campaign_24, s0_.utm_term AS utm_term_25, s0_.utm_content AS utm_content_26, s0_.birthday AS birthday_27, s0_.addressFieldOne AS addressFieldOne_28, s0_.addressFieldTwo AS addressFieldTwo_29, s0_.addressCountryCode AS addressCountryCode_30, s0_.addressPostalCode AS addressPostalCode_31, s0_.addressCity AS addressCity_32, s0_.teamId AS teamId_33, s0_.teamName AS teamName_34, s0_.company AS company_35, s0_.history AS history_36, s0_.tags AS tags_37, s0_.annotation AS annotation_38, s0_.mentorBuckets AS mentorBuckets_39, s0_.areasOfExpertise AS areasOfExpertise_40, s0_.mentor_firma AS mentor_firma_41, s0_.mentor_firma_url AS mentor_firma_url_42, s0_.mentor_locations AS mentor_locations_43, s0_.mentor_profile AS mentor_profile_44, s0_.mentor_note AS mentor_note_45, s0_.mentor_admin_rating AS mentor_admin_rating_46, s0_.active AS active_47, s0_.tiefgarage AS tiefgarage_48, s0_.transponder AS transponder_49, s0_.isTransponderAllowed AS isTransponderAllowed_50, s0_.imageLink AS imageLink_51, s0_.homepage AS homepage_52, s0_.xing AS xing_53, s0_.pipedriveId AS pipedriveId_54, s0_.linkedin AS linkedin_55, s0_.facebook AS facebook_56, s0_.instagram AS instagram_57, s0_.twitter AS twitter_58, s0_.skills AS skills_59, s0_.description AS description_60, s0_.touchpoints AS touchpoints_61, s0_.isAddressComplete AS isAddressComplete_62, s0_.hasMailchimp AS hasMailchimp_63, s0_.hasKiNewsletter AS hasKiNewsletter_64, s0_.hubspotSyncPending AS hubspotSyncPending_65, s0_.enterDate AS enterDate_66, s0_.exitDate AS exitDate_67, s0_.physicalMembershipStarted AS physicalMembershipStarted_68, s0_.physicalMembershipEnded AS physicalMembershipEnded_69, s0_.lastModified AS lastModified_70, s0_.lastChangeUser AS lastChangeUser_71, s0_.nAiWebinarsAttended AS nAiWebinarsAttended_72, s0_.nAiWebinarsApplied AS nAiWebinarsApplied_73, s0_.nAiEventsAttended AS nAiEventsAttended_74, s0_.nAiEventsApplied AS nAiEventsApplied_75, s0_.nPaidAttended AS nPaidAttended_76, s0_.nPaidApplied AS nPaidApplied_77, s0_.nKiEinstiegAttended AS nKiEinstiegAttended_78, s0_.nKiEinstiegApplied AS nKiEinstiegApplied_79, s0_.nPromptEngineeringAttended AS nPromptEngineeringAttended_80, s0_.nPromptEngineeringApplied AS nPromptEngineeringApplied_81, s0_.nEcodynamicsAttended AS nEcodynamicsAttended_82, s0_.nEcodynamicsApplied AS nEcodynamicsApplied_83, s0_.nBbqApplied AS nBbqApplied_84, s0_.nAiFridayApplied AS nAiFridayApplied_85, s0_.nAiGatheringApplied AS nAiGatheringApplied_86, s0_.nAiGatheringAttended AS nAiGatheringAttended_87, s0_.aiSs24Applied AS aiSs24Applied_88, s0_.aiSs24Booked AS aiSs24Booked_89, s0_.interestedIn AS interestedIn_90, s0_.interests AS interests_91, s0_.mentorMetadata AS mentorMetadata_92, s0_.eventParticipations AS eventParticipations_93, s0_.kiKompetenz AS kiKompetenz_94, s0_.mentorOwnerId AS mentorOwnerId_95 FROM sp_members s0_, sp_member_teams s1_ WHERE s0_.id = s1_.member_id AND s1_.team_id = ? ORDER BY s0_.firstName ASC, s0_.lastName ASC
Parameters:
[
  16347
]
0.66 ms
(0.49%)
1
SELECT t0.id AS id_1, t0.extId AS extId_2, t0.visibility AS visibility_3, t0.score AS score_4, t0.name AS name_5, t0.teamId AS teamId_6, t0.website AS website_7, t0.domain AS domain_8, t0.slug AS slug_9, t0.status AS status_10, t0.editStatus AS editStatus_11, t0.stage AS stage_12, t0.logoUrl AS logoUrl_13, t0.logoBackground AS logoBackground_14, t0.imageLink AS imageLink_15, t0.currentPitchDeckUrl AS currentPitchDeckUrl_16, t0.kiAccelerator AS kiAccelerator_17, t0.todos AS todos_18, t0.industry AS industry_19, t0.industryCondensed AS industryCondensed_20, t0.customerFocus AS customerFocus_21, t0.BusinessModel AS BusinessModel_22, t0.tags AS tags_23, t0.oneSentencePitch AS oneSentencePitch_24, t0.oneSentencePitchEn AS oneSentencePitchEn_25, t0.foundationYear AS foundationYear_26, t0.location AS location_27, t0.city AS city_28, t0.employeesCount AS employeesCount_29, t0.funding AS funding_30, t0.investors AS investors_31, t0.revenue AS revenue_32, t0.contactPerson AS contactPerson_33, t0.contactEmail AS contactEmail_34, t0.contactTelefon AS contactTelefon_35, t0.xing AS xing_36, t0.linkedin AS linkedin_37, t0.facebook AS facebook_38, t0.twitter AS twitter_39, t0.instagram AS instagram_40, t0.description AS description_41, t0.publicDetailHtml AS publicDetailHtml_42, t0.publicDetailHtmlEn AS publicDetailHtmlEn_43, t0.internalDetailHtml AS internalDetailHtml_44, t0.internalDetailHtmlEn AS internalDetailHtmlEn_45, t0.gsPublicSummary AS gsPublicSummary_46, t0.gsIndustries AS gsIndustries_47, t0.gsKeywords AS gsKeywords_48, t0.gsProfile AS gsProfile_49, t0.comments AS comments_50, t0.history AS history_51, t0.lastChangeUser AS lastChangeUser_52, t0.createdAt AS createdAt_53, t0.lastModified AS lastModified_54, t0.lastChangedBy AS lastChangedBy_55 FROM sp_startup_profiles t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "3000844"
]
0.44 ms
(0.33%)
1
SELECT t0.id AS id_1, t0.startupId AS startupId_2, t0.location AS location_3, t0.locationSecond AS locationSecond_4, t0.name AS name_5, t0.shortName AS shortName_6, t0.previousName AS previousName_7, t0.person AS person_8, t0.phone AS phone_9, t0.addressFieldOne AS addressFieldOne_10, t0.addressFieldTwo AS addressFieldTwo_11, t0.addressCountryCode AS addressCountryCode_12, t0.addressPostalCode AS addressPostalCode_13, t0.addressCity AS addressCity_14, t0.spTeamId AS spTeamId_15, t0.accountEmail AS accountEmail_16, t0.connectEmail AS connectEmail_17, t0.status AS status_18, t0.active AS active_19, t0.hasCommunityMembership AS hasCommunityMembership_20, t0.isTransponderAllowed AS isTransponderAllowed_21, t0.hasStartupMembership AS hasStartupMembership_22, t0.isIncludeInUpdateType AS isIncludeInUpdateType_23, t0.isCompany AS isCompany_24, t0.isAddressComplete AS isAddressComplete_25, t0.isDebitor AS isDebitor_26, t0.type AS type_27, t0.internalDescription AS internalDescription_28, t0.monsumCustomerType AS monsumCustomerType_29, t0.homepage AS homepage_30, t0.logoURL AS logoURL_31, t0.industries AS industries_32, t0.description AS description_33, t0.note AS note_34, t0.tags AS tags_35, t0.categories AS categories_36, t0.alertNote AS alertNote_37, t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_38, t0.monthlyExtraBudget AS monthlyExtraBudget_39, t0.sameDayBudget AS sameDayBudget_40, t0.sameDayBudgetUsed AS sameDayBudgetUsed_41, t0.sameDayExtraBudget AS sameDayExtraBudget_42, t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_43, t0.communityBudget AS communityBudget_44, t0.communityBudgetUsed AS communityBudgetUsed_45, t0.meetingRoomsBudget AS meetingRoomsBudget_46, t0.conferenceRoomsBudget AS conferenceRoomsBudget_47, t0.coffeeCoinsBudget AS coffeeCoinsBudget_48, t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_49, t0.meetingRoomsBooked AS meetingRoomsBooked_50, t0.conferenceRoomsBooked AS conferenceRoomsBooked_51, t0.todayRoomsBooked AS todayRoomsBooked_52, t0.nDedicatedDesks AS nDedicatedDesks_53, t0.nFlexibleDesks AS nFlexibleDesks_54, t0.nBasicMemberships AS nBasicMemberships_55, t0.nEmployees AS nEmployees_56, t0.nTransponders AS nTransponders_57, t0.nTiefgarage AS nTiefgarage_58, t0.editStatus AS editStatus_59, t0.xing AS xing_60, t0.linkedin AS linkedin_61, t0.facebook AS facebook_62, t0.twitter AS twitter_63, t0.instagram AS instagram_64, t0.enterDate AS enterDate_65, t0.lastChangeDate AS lastChangeDate_66, t0.lastModified AS lastModified_67, t0.lastInvoiceDate AS lastInvoiceDate_68, t0.exitDate AS exitDate_69, t0.isRedundant AS isRedundant_70, t0.gsStatus AS gsStatus_71, t0.gsBatchNo AS gsBatchNo_72, t0.gsNote AS gsNote_73, t0.gsIdeenblattDate AS gsIdeenblattDate_74, t0.gsJuryDate AS gsJuryDate_75, t0.gsCoachMemberId AS gsCoachMemberId_76, t0.gsCoachMemberName AS gsCoachMemberName_77, t0.spContactPerson AS spContactPerson_78, t0.memberTag AS memberTag_79, t0.zapierWebhook AS zapierWebhook_80, t0.actionTag AS actionTag_81, t0.createdAt AS createdAt_82, t0.lastChangeUser AS lastChangeUser_83, t0.history AS history_84, t0.treatAsSubscribed AS treatAsSubscribed_85, t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_86, t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_87, t0.treatAsSubscribedReason AS treatAsSubscribedReason_88, t0.searchAliases AS searchAliases_89 FROM sp_teams t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  16347
]
0.27 ms
(0.20%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s1_.type AS type_2, s0_.email AS email_3 FROM sp_member_teams s1_ INNER JOIN sp_members s0_ ON (s1_.member_id = s0_.id) WHERE s1_.team_id = ?
Parameters:
[
  "3000844"
]

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.

Entities Mapping

Class Mapping errors
App\StartPlatz\Bundle\UserBundle\Entity\User No errors.
App\StartPlatz\Bundle\UserBundle\Entity\LoginToken No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\Team No errors.
App\StartPlatz\Ecosystem\Participation\Entity\Participation No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Application
  • The field 'App\StartPlatz\Bundle\StartupBundle\Entity\Application#ratingAverage' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field App\StartPlatz\Bundle\StartupBundle\Entity\Application#assessments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\StartPlatz\Bundle\AllmedaBundle\Entity\BatchApplicationAssessment#application does not contain the required 'inversedBy="assessments"' attribute.
App\StartPlatz\Bundle\StartupBundle\Entity\Startup No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\MemberTeam No errors.
App\StartPlatz\Bundle\AlphaBundle\Entity\Feed No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Batch No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\Member No errors.