Query Metrics
1
Database Queries
1
Different statements
1549.97 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
1549.97 ms (100.00%) |
1 |
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:
[
"anthony.back@housemaster.com"
]
|
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
| Class | Mapping errors |
|---|---|
| FOS\UserBundle\Model\User | No errors. |
| App\AppBundle\Entity\User | No errors. |
| App\AppBundle\Entity\SweepstakesAgentInfo | No errors. |
| App\AppBundle\Entity\SweepstakesContact | No errors. |
| App\AppBundle\Entity\IsnCredentials | No errors. |
| App\AppBundle\Entity\BetaQuestions | No errors. |
| App\AppBundle\Entity\InspectorNotificationSettings | No errors. |
| App\AppBundle\Entity\OfficeSettings | No errors. |
| App\AppBundle\Entity\ApiKeys | No errors. |
bbp entity manager
No loaded entities.
housemaster entity manager
No loaded entities.