Query Metrics
4
Database Queries
1
Different statements
4202.86 ms
Query time
1
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
4202.86 ms (100.00%) |
4 |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.firstname AS firstname_13, t0.lastname AS lastname_14, t0.address1 AS address1_15, t0.city AS city_16, t0.idToken AS idToken_17, t0.accessToken AS accessToken_18, t0.state AS state_19, t0.country AS country_20, t0.zip AS zip_21, t0.phone AS phone_22, t0.phone2 AS phone2_23, t0.phone3 AS phone3_24, t0.franchisee AS franchisee_25, t0.franchisee_number AS franchisee_number_26, t0.receivenewsletter AS receivenewsletter_27, t0.receivesms AS receivesms_28, t0.signedagreement AS signedagreement_29, t0.address2 AS address2_30, t0.facebook_id AS facebook_id_31, t0.google_id AS google_id_32, t0.twitter_id AS twitter_id_33, t0.email2 AS email2_34, t0.email3 AS email3_35, t0.home_fax AS home_fax_36, t0.work_fax AS work_fax_37, t0.companyName AS companyName_38, t0.website AS website_39, t0.photo AS photo_40, t0.updatedAt AS updatedAt_41, t0.pathandnameofphoto AS pathandnameofphoto_42, t0.timezone AS timezone_43, t0.autoRealtorReports AS autoRealtorReports_44, t0.buyerAgentViewReport AS buyerAgentViewReport_45, t0.sellerAgentViewReports AS sellerAgentViewReports_46, t0.otherAgentViewReport AS otherAgentViewReport_47, t0.shareCloudTransfers AS shareCloudTransfers_48, t0.doNotLockUnpaid AS doNotLockUnpaid_49, t0.doNotLockUnsigned AS doNotLockUnsigned_50, t0.createdAt AS createdAt_51, t0.preinspection AS preinspection_52, t0.agentDisableConcierge AS agentDisableConcierge_53, t0.newAccountNotified AS newAccountNotified_54, t0.needsPasswordReset AS needsPasswordReset_55, t0.locked AS locked_56, t57.id AS id_58, t57.address AS address_59, t57.city AS city_60, t57.state AS state_61, t57.zip AS zip_62, t57.birthday AS birthday_63, t57.hobby AS hobby_64, t57.restaurant AS restaurant_65, t57.user_id AS user_id_66, t57.contact_id AS contact_id_67, t0.isnCredentials_id AS isnCredentials_id_68, t69.id AS id_70, t69.browser AS browser_71, t69.device AS device_72, t69.accomplish AS accomplish_73, t69.useful AS useful_74, t69.confusing AS confusing_75, t69.price AS price_76, t69.stopUsing AS stopUsing_77, t69.workAsExpected AS workAsExpected_78, t69.friend AS friend_79, t69.user_id AS user_id_80, t81.id AS id_82, t81.sent AS sent_83, t81.opened AS opened_84, t81.clicked AS clicked_85, t81.bounced AS bounced_86, t81.blocked AS blocked_87, t81.notCustomerViewed AS notCustomerViewed_88, t81.notAgentViewed AS notAgentViewed_89, t81.user_id AS user_id_90, t0.officeSettings_id AS officeSettings_id_91, t92.id AS id_93, t92.apiKey AS apiKey_94, t92.apiSecretKey AS apiSecretKey_95, t92.user_id AS user_id_96 FROM User t0 LEFT JOIN SweepstakesAgentInfo t57 ON t57.user_id = t0.id LEFT JOIN BetaQuestions t69 ON t69.user_id = t0.id LEFT JOIN InspectorNotificationSettings t81 ON t81.user_id = t0.id LEFT JOIN ApiKeys t92 ON t92.user_id = t0.id WHERE t0.username = ? LIMIT 1
Parameters:
[
"ftd4@verizon.net"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| bbp | doctrine.dbal.bbp_connection |
| housemaster | doctrine.dbal.housemaster_connection |
Entity Managers
| Name | Service |
|---|---|
| inertia | doctrine.orm.inertia_entity_manager |
| default | doctrine.orm.default_entity_manager |
| bbp | doctrine.orm.bbp_entity_manager |
| housemaster | doctrine.orm.housemaster_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
inertia entity manager
No loaded entities.
default entity manager
bbp entity manager
No loaded entities.
housemaster entity manager
No loaded entities.