Query Metrics
7
Database Queries
7
Different statements
13.22 ms
Query time
0
Invalid entities
81
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.72 ms |
SELECT t0.id AS id_1, t0.score AS score_2, t0.completenessScore AS completenessScore_3, t0.status AS status_4, t0.location AS location_5, t0.salutation AS salutation_6, t0.title AS title_7, t0.jobTitle AS jobTitle_8, t0.firstName AS firstName_9, t0.lastName AS lastName_10, t0.name AS name_11, t0.sortName AS sortName_12, t0.email AS email_13, t0.secondaryEmail AS secondaryEmail_14, t0.phone AS phone_15, t0.hasCommunityMembership AS hasCommunityMembership_16, t0.utm_source AS utm_source_17, t0.utm_medium AS utm_medium_18, t0.utm_campaign AS utm_campaign_19, t0.utm_term AS utm_term_20, t0.utm_content AS utm_content_21, t0.birthday AS birthday_22, t0.addressFieldOne AS addressFieldOne_23, t0.addressFieldTwo AS addressFieldTwo_24, t0.addressCountryCode AS addressCountryCode_25, t0.addressPostalCode AS addressPostalCode_26, t0.addressCity AS addressCity_27, t0.teamId AS teamId_28, t0.teamName AS teamName_29, t0.company AS company_30, t0.history AS history_31, t0.tags AS tags_32, t0.annotation AS annotation_33, t0.mentorBuckets AS mentorBuckets_34, t0.areasOfExpertise AS areasOfExpertise_35, t0.mentor_firma AS mentor_firma_36, t0.mentor_firma_url AS mentor_firma_url_37, t0.mentor_locations AS mentor_locations_38, t0.mentor_profile AS mentor_profile_39, t0.mentor_note AS mentor_note_40, t0.mentor_admin_rating AS mentor_admin_rating_41, t0.active AS active_42, t0.tiefgarage AS tiefgarage_43, t0.transponder AS transponder_44, t0.isTransponderAllowed AS isTransponderAllowed_45, t0.imageLink AS imageLink_46, t0.homepage AS homepage_47, t0.xing AS xing_48, t0.pipedriveId AS pipedriveId_49, t0.linkedin AS linkedin_50, t0.facebook AS facebook_51, t0.instagram AS instagram_52, t0.twitter AS twitter_53, t0.skills AS skills_54, t0.description AS description_55, t0.touchpoints AS touchpoints_56, t0.isAddressComplete AS isAddressComplete_57, t0.hasMailchimp AS hasMailchimp_58, t0.hasKiNewsletter AS hasKiNewsletter_59, t0.hubspotSyncPending AS hubspotSyncPending_60, t0.enterDate AS enterDate_61, t0.exitDate AS exitDate_62, t0.physicalMembershipStarted AS physicalMembershipStarted_63, t0.physicalMembershipEnded AS physicalMembershipEnded_64, t0.lastModified AS lastModified_65, t0.lastChangeUser AS lastChangeUser_66, t0.onboardingCompletedAt AS onboardingCompletedAt_67, t0.nAiWebinarsAttended AS nAiWebinarsAttended_68, t0.nAiWebinarsApplied AS nAiWebinarsApplied_69, t0.nAiEventsAttended AS nAiEventsAttended_70, t0.nAiEventsApplied AS nAiEventsApplied_71, t0.nPaidAttended AS nPaidAttended_72, t0.nPaidApplied AS nPaidApplied_73, t0.nKiEinstiegAttended AS nKiEinstiegAttended_74, t0.nKiEinstiegApplied AS nKiEinstiegApplied_75, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_76, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_77, t0.nEcodynamicsAttended AS nEcodynamicsAttended_78, t0.nEcodynamicsApplied AS nEcodynamicsApplied_79, t0.nBbqApplied AS nBbqApplied_80, t0.nAiFridayApplied AS nAiFridayApplied_81, t0.nAiGatheringApplied AS nAiGatheringApplied_82, t0.nAiGatheringAttended AS nAiGatheringAttended_83, t0.aiSs24Applied AS aiSs24Applied_84, t0.aiSs24Booked AS aiSs24Booked_85, t0.interestedIn AS interestedIn_86, t0.interests AS interests_87, t0.mentorMetadata AS mentorMetadata_88, t0.eventParticipations AS eventParticipations_89, t0.kiKompetenz AS kiKompetenz_90, t0.mentorOwnerId AS mentorOwnerId_91 FROM sp_members t0 WHERE t0.email = ? LIMIT 1
Parameters:
[ "" ] |
| 2 | 0.41 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:
[
"partner"
]
|
| 3 | 3.44 ms |
SELECT t0.id AS id_1, t0.attributeId AS attributeId_2, t0.name AS name_3, t0.level AS level_4, t0.code AS code_5, t0.parent AS parent_6, t0.label AS label_7, t0.description AS description_8, t0.note AS note_9, t0.createdAt AS createdAt_10, t0.lastModified AS lastModified_11, t0.history AS history_12, t0.lastChangeUser AS lastChangeUser_13 FROM sp_setting_attributes t0 WHERE t0.name = ? AND t0.parent = ?
Parameters:
[ "page.type" "partner" ] |
| 4 | 3.17 ms |
SELECT s0_.id AS id_0, s0_.category AS category_1, s0_.type AS type_2, s0_.slug AS slug_3, s0_.title AS title_4, s0_.teaser AS teaser_5, s0_.partnerAdminRating AS partnerAdminRating_6, s0_.imagelink AS imagelink_7, s0_.website AS website_8, s0_.tags AS tags_9, s0_.feedTags AS feedTags_10, s0_.logoUrl AS logoUrl_11, s0_.publicId AS publicId_12, s0_.description AS description_13, s0_.relatedInformation AS relatedInformation_14, s0_.redeemPerk AS redeemPerk_15, s0_.targetGroup AS targetGroup_16, s0_.contactPartner AS contactPartner_17, s0_.contactPartnerMemberId AS contactPartnerMemberId_18, s0_.isActive AS isActive_19, s0_.status AS status_20, s0_.visibility AS visibility_21, s0_.teamId AS teamId_22, s0_.teamName AS teamName_23, s0_.titleEN AS titleEN_24, s0_.teaserEN AS teaserEN_25, s0_.descriptionEN AS descriptionEN_26, s0_.relatedInformationEN AS relatedInformationEN_27, s0_.redeemPerkEN AS redeemPerkEN_28, s0_.seoTitle AS seoTitle_29, s0_.seoKeyword AS seoKeyword_30, s0_.seoDescription AS seoDescription_31, s0_.history AS history_32, s0_.lastModified AS lastModified_33, s0_.lastChangeUser AS lastChangeUser_34, s0_.createdAt AS createdAt_35, s0_.additionalHead AS additionalHead_36, s0_.publicCategory AS publicCategory_37 FROM sp_content_pages s0_ WHERE s0_.type IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.isActive = ? AND s0_.status = ? ORDER BY s0_.partnerAdminRating DESC, s0_.lastModified DESC LIMIT 128
Parameters:
[ "corporate-partner" "partner" "service-partner" "accelerator-venture-capital-partner" "accelerator-technology-partner" "accelerator-support-partner" "strategic-partner" "education-partner" "academic-partner" "web3-technology-partner" "web3-investment-partner" "collaborating-partner" "network-partner" 1 "publish" ] |
| 5 | 0.38 ms |
SELECT COUNT(s0_.id) AS sclr_0 FROM sp_content_pages s0_ WHERE s0_.type IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.isActive = ? AND s0_.status = ?
Parameters:
[ "corporate-partner" "partner" "service-partner" "accelerator-venture-capital-partner" "accelerator-technology-partner" "accelerator-support-partner" "strategic-partner" "education-partner" "academic-partner" "web3-technology-partner" "web3-investment-partner" "collaborating-partner" "network-partner" 1 "publish" ] |
| 6 | 3.35 ms |
SELECT s0_.id AS id_0, s0_.category AS category_1, s0_.type AS type_2, s0_.slug AS slug_3, s0_.title AS title_4, s0_.teaser AS teaser_5, s0_.partnerAdminRating AS partnerAdminRating_6, s0_.imagelink AS imagelink_7, s0_.website AS website_8, s0_.tags AS tags_9, s0_.feedTags AS feedTags_10, s0_.logoUrl AS logoUrl_11, s0_.publicId AS publicId_12, s0_.description AS description_13, s0_.relatedInformation AS relatedInformation_14, s0_.redeemPerk AS redeemPerk_15, s0_.targetGroup AS targetGroup_16, s0_.contactPartner AS contactPartner_17, s0_.contactPartnerMemberId AS contactPartnerMemberId_18, s0_.isActive AS isActive_19, s0_.status AS status_20, s0_.visibility AS visibility_21, s0_.teamId AS teamId_22, s0_.teamName AS teamName_23, s0_.titleEN AS titleEN_24, s0_.teaserEN AS teaserEN_25, s0_.descriptionEN AS descriptionEN_26, s0_.relatedInformationEN AS relatedInformationEN_27, s0_.redeemPerkEN AS redeemPerkEN_28, s0_.seoTitle AS seoTitle_29, s0_.seoKeyword AS seoKeyword_30, s0_.seoDescription AS seoDescription_31, s0_.history AS history_32, s0_.lastModified AS lastModified_33, s0_.lastChangeUser AS lastChangeUser_34, s0_.createdAt AS createdAt_35, s0_.additionalHead AS additionalHead_36, s0_.publicCategory AS publicCategory_37 FROM sp_content_pages s0_ WHERE s0_.type IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.isActive = ? AND s0_.status = ?
Parameters:
[ "corporate-partner" "partner" "service-partner" "accelerator-venture-capital-partner" "accelerator-technology-partner" "accelerator-support-partner" "strategic-partner" "education-partner" "academic-partner" "web3-technology-partner" "web3-investment-partner" "collaborating-partner" "network-partner" 1 "publish" ] |
| 7 | 0.76 ms |
SELECT t0.id AS id_1, t0.attributeId AS attributeId_2, t0.name AS name_3, t0.level AS level_4, t0.code AS code_5, t0.parent AS parent_6, t0.label AS label_7, t0.description AS description_8, t0.note AS note_9, t0.createdAt AS createdAt_10, t0.lastModified AS lastModified_11, t0.history AS history_12, t0.lastChangeUser AS lastChangeUser_13 FROM sp_setting_attributes t0 WHERE t0.name = ?
Parameters:
[
"partner.tags"
]
|
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\AlphaBundle\Entity\Page | 58 |
| App\StartPlatz\Bundle\MetaBundle\Entity\Attribute | 23 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\StartPlatz\Bundle\UserBundle\Entity\User | No errors. |
| App\StartPlatz\Bundle\MemberBundle\Entity\Member | No errors. |
| App\StartPlatz\Bundle\AlphaBundle\Entity\Page | No errors. |
| App\StartPlatz\Bundle\MetaBundle\Entity\Attribute | No errors. |