http://www.staging.startplatz.de/en/accelerator/experts-in-residence

Method
GET
HTTP Status
200
IP
172.22.0.12
Profiled on
Token
19f0d8

Query Metrics

17 Database Queries
3 Different statements
8.19 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
6.04 ms
(73.71%) 		15 
SELECT t0.id AS id_1, t0.spMemberId AS spMemberId_2, t0.score AS score_3, t0.completenessScore AS completenessScore_4, t0.status AS status_5, t0.location AS location_6, t0.salutation AS salutation_7, t0.title AS title_8, t0.jobTitle AS jobTitle_9, t0.firstName AS firstName_10, t0.lastName AS lastName_11, t0.name AS name_12, t0.sortName AS sortName_13, t0.email AS email_14, t0.secondaryEmail AS secondaryEmail_15, t0.phone AS phone_16, t0.hasCommunityMembership AS hasCommunityMembership_17, t0.aiMemberValid AS aiMemberValid_18, t0.aiMemberStatus AS aiMemberStatus_19, t0.aiMemberReason AS aiMemberReason_20, t0.aiMemberStart AS aiMemberStart_21, t0.aiMemberEnd AS aiMemberEnd_22, t0.utm_source AS utm_source_23, t0.utm_medium AS utm_medium_24, t0.utm_campaign AS utm_campaign_25, t0.utm_term AS utm_term_26, t0.utm_content AS utm_content_27, t0.birthday AS birthday_28, t0.addressFieldOne AS addressFieldOne_29, t0.addressFieldTwo AS addressFieldTwo_30, t0.addressCountryCode AS addressCountryCode_31, t0.addressPostalCode AS addressPostalCode_32, t0.addressCity AS addressCity_33, t0.teamId AS teamId_34, t0.teamName AS teamName_35, t0.company AS company_36, t0.history AS history_37, t0.tags AS tags_38, t0.annotation AS annotation_39, t0.mentorBuckets AS mentorBuckets_40, t0.areasOfExpertise AS areasOfExpertise_41, t0.mentor_firma AS mentor_firma_42, t0.mentor_firma_url AS mentor_firma_url_43, t0.mentor_locations AS mentor_locations_44, t0.mentor_profile AS mentor_profile_45, t0.mentor_note AS mentor_note_46, t0.mentor_admin_rating AS mentor_admin_rating_47, t0.active AS active_48, t0.tiefgarage AS tiefgarage_49, t0.transponder AS transponder_50, t0.isTransponderAllowed AS isTransponderAllowed_51, t0.imageLink AS imageLink_52, t0.homepage AS homepage_53, t0.xing AS xing_54, t0.pipedriveId AS pipedriveId_55, t0.linkedin AS linkedin_56, t0.facebook AS facebook_57, t0.instagram AS instagram_58, t0.twitter AS twitter_59, t0.skills AS skills_60, t0.description AS description_61, t0.touchpoints AS touchpoints_62, t0.isAddressComplete AS isAddressComplete_63, t0.hasMailchimp AS hasMailchimp_64, t0.hasKiNewsletter AS hasKiNewsletter_65, t0.hubspotSyncPending AS hubspotSyncPending_66, t0.enterDate AS enterDate_67, t0.exitDate AS exitDate_68, t0.physicalMembershipStarted AS physicalMembershipStarted_69, t0.physicalMembershipEnded AS physicalMembershipEnded_70, t0.lastModified AS lastModified_71, t0.lastChangeUser AS lastChangeUser_72, t0.nAiWebinarsAttended AS nAiWebinarsAttended_73, t0.nAiWebinarsApplied AS nAiWebinarsApplied_74, t0.nAiEventsAttended AS nAiEventsAttended_75, t0.nAiEventsApplied AS nAiEventsApplied_76, t0.nPaidAttended AS nPaidAttended_77, t0.nPaidApplied AS nPaidApplied_78, t0.nKiEinstiegAttended AS nKiEinstiegAttended_79, t0.nKiEinstiegApplied AS nKiEinstiegApplied_80, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_81, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_82, t0.nEcodynamicsAttended AS nEcodynamicsAttended_83, t0.nEcodynamicsApplied AS nEcodynamicsApplied_84, t0.nBbqApplied AS nBbqApplied_85, t0.nAiFridayApplied AS nAiFridayApplied_86, t0.nAiGatheringApplied AS nAiGatheringApplied_87, t0.nAiGatheringAttended AS nAiGatheringAttended_88, t0.aiSs24Applied AS aiSs24Applied_89, t0.aiSs24Booked AS aiSs24Booked_90, t0.interestedIn AS interestedIn_91, t0.interests AS interests_92, t0.mentorMetadata AS mentorMetadata_93, t0.eventParticipations AS eventParticipations_94, t0.kiKompetenz AS kiKompetenz_95, t0.mentorOwnerId AS mentorOwnerId_96 FROM sp_members t0 WHERE t0.id = ?
Parameters: 
[
  102480
]
View formatted query    View runnable query    Explain query
1.57 ms
(19.18%) 		1 
SELECT s0_.id AS id_0, s0_.category AS category_1, s0_.firma AS firma_2, s0_.firmaUrl AS firmaUrl_3, s0_.locations AS locations_4, s0_.profileDe AS profileDe_5, s0_.profileEn AS profileEn_6, s0_.bioDe AS bioDe_7, s0_.bioEn AS bioEn_8, s0_.mainFocusDe AS mainFocusDe_9, s0_.mainFocusEn AS mainFocusEn_10, s0_.areasOfExpertise AS areasOfExpertise_11, s0_.expertiseAreas AS expertiseAreas_12, s0_.connectModes AS connectModes_13, s0_.calendlyLink AS calendlyLink_14, s0_.adminRating AS adminRating_15, s0_.note AS note_16, s0_.status AS status_17, s0_.metadata AS metadata_18, s0_.createdAt AS createdAt_19, s0_.updatedAt AS updatedAt_20, s0_.memberId AS memberId_21, s0_.ownerId AS ownerId_22 FROM sp_mentors s0_ INNER JOIN sp_members s1_ ON s0_.memberId = s1_.id WHERE s0_.category = ? AND s0_.status = ? ORDER BY s1_.lastName ASC, s1_.firstName ASC LIMIT 20
Parameters: 
[
  "experts"
  "active"
]
View formatted query    View runnable query    Explain query
0.58 ms
(7.11%) 		1 
SELECT post_content
                    FROM wp_posts
                    WHERE post_name = :slug
                    AND post_status = 'publish'
                    AND post_type = 'page'
                    LIMIT 1
Parameters: 
[
  "slug" => "accelerator-global-menu-en"
]
View formatted query    View runnable query    Explain query

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\MetaBundle\Entity\Tag No errors.
App\StartPlatz\Bundle\UserBundle\Entity\User No errors.
App\StartPlatz\Bundle\UserBundle\Entity\LoginToken No errors.
App\StartPlatz\Bundle\MentorsBundle\Entity\Mentor No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\Member No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\MemberTeam No errors.