Query Metrics
14
Database Queries
10
Different statements
79.46 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
52.00 ms (65.44%) |
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.projectCategory AS projectCategory_39, t0.blockchain AS blockchain_40, t0.recommendedBy AS recommendedBy_41, t0.editStatus AS editStatus_42, t0.editMessage AS editMessage_43, t0.applicationStatus AS applicationStatus_44, t0.reviewStatus AS reviewStatus_45, t0.applicantType AS applicantType_46, t0.canReadList AS canReadList_47, t0.isSitting AS isSitting_48, t0.isNewMember AS isNewMember_49, t0.hasNewsletterPermissionGiven AS hasNewsletterPermissionGiven_50, t0.hasConfirmationMailSent AS hasConfirmationMailSent_51, t0.hasTermsAccepted AS hasTermsAccepted_52, t0.hasPaid AS hasPaid_53, t0.hasVolunteerAgreed AS hasVolunteerAgreed_54, t0.hasEmailValidated AS hasEmailValidated_55, t0.batchStatus AS batchStatus_56, t0.pitchPosition AS pitchPosition_57, t0.pitchImageLink AS pitchImageLink_58, t0.pitchVideoLink AS pitchVideoLink_59, t0.linkPitchDeck AS linkPitchDeck_60, t0.publicIdPitchDeck AS publicIdPitchDeck_61, t0.websiteUrl AS websiteUrl_62, t0.fulltime AS fulltime_63, t0.language AS language_64, t0.mvpStatus AS mvpStatus_65, t0.dealroomUrl AS dealroomUrl_66, t0.podioId AS podioId_67, t0.podioItemId AS podioItemId_68, t0.podioUrl AS podioUrl_69, t0.ideaPitch AS ideaPitch_70, t0.createdAt AS createdAt_71, t0.lastModified AS lastModified_72, t0.lastChangeUser AS lastChangeUser_73, t0.history AS history_74, t0.extraFields AS extraFields_75, t0.adminNotes AS adminNotes_76, t0.ratingJudge1 AS ratingJudge1_77, t0.ratingJudge2 AS ratingJudge2_78, t0.ratingJudge3 AS ratingJudge3_79, t0.ratingJudge4 AS ratingJudge4_80, t0.ratingJudge5 AS ratingJudge5_81, t0.ratingAverage AS ratingAverage_82, t0.ratingUpdatedAt AS ratingUpdatedAt_83, t0.memberTagsAtRegistration AS memberTagsAtRegistration_84, t0.wasCommunityMemberAtRegistration AS wasCommunityMemberAtRegistration_85, t0.wasPhysicalMemberAtRegistration AS wasPhysicalMemberAtRegistration_86, t0.memberUtmSourceAtRegistration AS memberUtmSourceAtRegistration_87, t0.kiKompetenzAtRegistration AS kiKompetenzAtRegistration_88 FROM aab_applications t0 WHERE t0.teamId = ? AND t0.programId IN (?)
Parameters:
[ 19612 [ "1" "2" "3" ] ] |
|
18.79 ms (23.65%) |
1 |
SELECT a0_.startupName AS startupName_0, a0_.pitchPosition AS pitchPosition_1, a0_.programName AS programName_2, a0_.batchName AS batchName_3, a1_.pitchDate AS pitchDate_4, a1_.city AS city_5 FROM aab_applications a0_ INNER JOIN aab_batches a1_ ON (a0_.batchId = a1_.id) WHERE a0_.startupId = ? AND a0_.programId = ?
Parameters:
[ "3000226" 1 ] |
|
3.67 ms (4.62%) |
2 |
SELECT a0_.id AS id_0, a0_.owner AS owner_1, a0_.type AS type_2, a0_.externalId AS externalId_3, a0_.score AS score_4, a0_.name AS name_5, a0_.title AS title_6, a0_.imageLink AS imageLink_7, a0_.categories AS categories_8, a0_.tags AS tags_9, a0_.isActive AS isActive_10, a0_.lastModified AS lastModified_11, a0_.lastChangeUser AS lastChangeUser_12, a0_.createdAt AS createdAt_13 FROM aaa_feed a0_ WHERE a0_.tags LIKE ? ORDER BY a0_.score DESC
Parameters:
[
"%"fairlanguage"%"
]
|
|
1.28 ms (1.61%) |
1 |
SELECT a0_.id AS id_0, a0_.spMemberId AS spMemberId_1, a0_.score AS score_2, a0_.completenessScore AS completenessScore_3, a0_.status AS status_4, a0_.location AS location_5, a0_.salutation AS salutation_6, a0_.title AS title_7, a0_.jobTitle AS jobTitle_8, a0_.firstName AS firstName_9, a0_.lastName AS lastName_10, a0_.name AS name_11, a0_.sortName AS sortName_12, a0_.email AS email_13, a0_.secondaryEmail AS secondaryEmail_14, a0_.phone AS phone_15, a0_.hasCommunityMembership AS hasCommunityMembership_16, a0_.aiMemberValid AS aiMemberValid_17, a0_.aiMemberStatus AS aiMemberStatus_18, a0_.aiMemberReason AS aiMemberReason_19, a0_.aiMemberStart AS aiMemberStart_20, a0_.aiMemberEnd AS aiMemberEnd_21, a0_.utm_source AS utm_source_22, a0_.utm_medium AS utm_medium_23, a0_.utm_campaign AS utm_campaign_24, a0_.utm_term AS utm_term_25, a0_.utm_content AS utm_content_26, a0_.birthday AS birthday_27, a0_.addressFieldOne AS addressFieldOne_28, a0_.addressFieldTwo AS addressFieldTwo_29, a0_.addressCountryCode AS addressCountryCode_30, a0_.addressPostalCode AS addressPostalCode_31, a0_.addressCity AS addressCity_32, a0_.teamId AS teamId_33, a0_.teamName AS teamName_34, a0_.company AS company_35, a0_.history AS history_36, a0_.tags AS tags_37, a0_.annotation AS annotation_38, a0_.mentorBuckets AS mentorBuckets_39, a0_.areasOfExpertise AS areasOfExpertise_40, a0_.mentor_firma AS mentor_firma_41, a0_.mentor_firma_url AS mentor_firma_url_42, a0_.mentor_locations AS mentor_locations_43, a0_.mentor_profile AS mentor_profile_44, a0_.mentor_note AS mentor_note_45, a0_.mentor_admin_rating AS mentor_admin_rating_46, a0_.active AS active_47, a0_.tiefgarage AS tiefgarage_48, a0_.transponder AS transponder_49, a0_.isTransponderAllowed AS isTransponderAllowed_50, a0_.imageLink AS imageLink_51, a0_.homepage AS homepage_52, a0_.xing AS xing_53, a0_.pipedriveId AS pipedriveId_54, a0_.linkedin AS linkedin_55, a0_.facebook AS facebook_56, a0_.instagram AS instagram_57, a0_.twitter AS twitter_58, a0_.skills AS skills_59, a0_.description AS description_60, a0_.touchpoints AS touchpoints_61, a0_.isAddressComplete AS isAddressComplete_62, a0_.hasMailchimp AS hasMailchimp_63, a0_.hasKiNewsletter AS hasKiNewsletter_64, a0_.enterDate AS enterDate_65, a0_.exitDate AS exitDate_66, a0_.physicalMembershipStarted AS physicalMembershipStarted_67, a0_.physicalMembershipEnded AS physicalMembershipEnded_68, a0_.lastModified AS lastModified_69, a0_.lastChangeUser AS lastChangeUser_70, a0_.nAiWebinarsAttended AS nAiWebinarsAttended_71, a0_.nAiWebinarsApplied AS nAiWebinarsApplied_72, a0_.nAiEventsAttended AS nAiEventsAttended_73, a0_.nAiEventsApplied AS nAiEventsApplied_74, a0_.nPaidAttended AS nPaidAttended_75, a0_.nPaidApplied AS nPaidApplied_76, a0_.nKiEinstiegAttended AS nKiEinstiegAttended_77, a0_.nKiEinstiegApplied AS nKiEinstiegApplied_78, a0_.nPromptEngineeringAttended AS nPromptEngineeringAttended_79, a0_.nPromptEngineeringApplied AS nPromptEngineeringApplied_80, a0_.nEcodynamicsAttended AS nEcodynamicsAttended_81, a0_.nEcodynamicsApplied AS nEcodynamicsApplied_82, a0_.nBbqApplied AS nBbqApplied_83, a0_.nAiFridayApplied AS nAiFridayApplied_84, a0_.nAiGatheringApplied AS nAiGatheringApplied_85, a0_.nAiGatheringAttended AS nAiGatheringAttended_86, a0_.aiSs24Applied AS aiSs24Applied_87, a0_.aiSs24Booked AS aiSs24Booked_88, a0_.interestedIn AS interestedIn_89, a0_.interests AS interests_90, a0_.mentorMetadata AS mentorMetadata_91, a0_.eventParticipations AS eventParticipations_92, a0_.kiKompetenz AS kiKompetenz_93, a0_.mentorOwnerId AS mentorOwnerId_94 FROM aaa_sp_members a0_, aaa_sp_members_teams a1_ WHERE a0_.id = a1_.member_id AND a1_.team_id = ? ORDER BY a0_.firstName ASC, a0_.lastName ASC
Parameters:
[
19612
]
|
|
1.18 ms (1.48%) |
2 |
SELECT p.guid FROM wp_posts p, wp_postmeta m WHERE m.meta_value = p.id AND m.post_id = :id AND m.meta_key = '_thumbnail_id'
Parameters:
[ ":id" => 63982 ] |
|
0.65 ms (0.82%) |
2 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.externalId AS externalId_3, t0.score AS score_4, t0.feedItemsCount AS feedItemsCount_5, t0.name AS name_6, t0.title AS title_7, t0.imageLink AS imageLink_8, t0.targetUrl AS targetUrl_9, t0.categories AS categories_10, t0.tags AS tags_11, t0.isActive AS isActive_12, t0.lastModified AS lastModified_13, t0.createdAt AS createdAt_14 FROM aaa_actors t0 WHERE t0.externalId = ? LIMIT 1
Parameters:
[
3000226
]
|
|
0.56 ms (0.70%) |
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.imageLink AS imageLink_14, t0.startplatz AS startplatz_15, t0.gruenderstipendium AS gruenderstipendium_16, t0.gsJury AS gsJury_17, t0.gsStatus AS gsStatus_18, t0.accelerator AS accelerator_19, t0.batch AS batch_20, t0.batchFirst AS batchFirst_21, t0.batchLast AS batchLast_22, t0.batchYear AS batchYear_23, t0.hasCertificate AS hasCertificate_24, t0.hasBadgeStartplatz AS hasBadgeStartplatz_25, t0.rheinlandPitch AS rheinlandPitch_26, t0.rheinlandPitchStatus AS rheinlandPitchStatus_27, t0.rheinlandPitchBestResult AS rheinlandPitchBestResult_28, t0.rheinlandPitchHistory AS rheinlandPitchHistory_29, t0.pitchNumber AS pitchNumber_30, t0.pitchDate AS pitchDate_31, t0.pitchTopic AS pitchTopic_32, t0.todos AS todos_33, t0.industry AS industry_34, t0.industryCondensed AS industryCondensed_35, t0.customerFocus AS customerFocus_36, t0.BusinessModel AS BusinessModel_37, t0.tags AS tags_38, t0.oneSentencePitch AS oneSentencePitch_39, t0.foundationYear AS foundationYear_40, t0.location AS location_41, t0.city AS city_42, t0.employeesCount AS employeesCount_43, t0.funding AS funding_44, t0.investors AS investors_45, t0.revenue AS revenue_46, t0.contactPerson AS contactPerson_47, t0.contactEmail AS contactEmail_48, t0.contactTelefon AS contactTelefon_49, t0.xing AS xing_50, t0.linkedin AS linkedin_51, t0.facebook AS facebook_52, t0.twitter AS twitter_53, t0.instagram AS instagram_54, t0.description AS description_55, t0.comments AS comments_56, t0.history AS history_57, t0.lastChangeUser AS lastChangeUser_58, t0.createdAt AS createdAt_59, t0.lastModified AS lastModified_60, t0.lastChangedBy AS lastChangedBy_61 FROM aaa_startups t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"3000226"
]
|
|
0.52 ms (0.65%) |
2 |
SELECT * FROM wp_posts WHERE ID = :id
Parameters:
[ ":id" => 63982 ] |
|
0.46 ms (0.57%) |
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 FROM aaa_sp_teams t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
19612
]
|
|
0.36 ms (0.46%) |
1 |
SELECT a0_.id AS id_0, a0_.name AS name_1, a1_.type AS type_2, a0_.email AS email_3 FROM aaa_sp_members_teams a1_ INNER JOIN aaa_sp_members a0_ ON (a1_.member_id = a0_.id) WHERE a1_.team_id = ?
Parameters:
[
"3000226"
]
|
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\MemberBundle\Entity\Team | No errors. |
| App\StartPlatz\Bundle\StartupBundle\Entity\Startup | No errors. |
| App\StartPlatz\Bundle\MemberBundle\Entity\MemberTeam | No errors. |
| App\StartPlatz\Bundle\AlphaBundle\Entity\Feed | No errors. |
| App\StartPlatz\Bundle\MetaBundle\Entity\MetaPost | No errors. |
| App\StartPlatz\Bundle\StartupBundle\Entity\Application |
|
| App\StartPlatz\Bundle\StartupBundle\Entity\Batch | No errors. |
| App\StartPlatz\Bundle\MemberBundle\Entity\Member | No errors. |
| App\StartPlatz\Bundle\AllmedaBundle\Entity\BatchApplicationAssessment | No errors. |
| App\StartPlatz\Bundle\AlphaBundle\Entity\Actor | No errors. |