Query Metrics
3
Database Queries
3
Different statements
3.38 ms
Query time
1
Invalid entities
1
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.36 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.mobile_phone AS mobile_phone_8, t0.address AS address_9, t0.city AS city_10, t0.postal_code AS postal_code_11, t0.birth_date AS birth_date_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14, t0.last_login_at AS last_login_at_15, t0.last_inactivity_alert_sent_at AS last_inactivity_alert_sent_at_16, t0.first_login_token AS first_login_token_17, t0.first_login_token_expires_at AS first_login_token_expires_at_18, t0.reset_password_code AS reset_password_code_19, t0.reset_password_code_expires_at AS reset_password_code_expires_at_20, t0.consents AS consents_21, t0.organization_id AS organization_id_22, t0.company_id AS company_id_23, t24.id AS id_25, t24.first_name AS first_name_26, t24.last_name AS last_name_27, t24.email AS email_28, t24.phone AS phone_29, t24.birth_date AS birth_date_30, t24.address AS address_31, t24.city AS city_32, t24.postal_code AS postal_code_33, t24.profession AS profession_34, t24.monthly_income AS monthly_income_35, t24.emergency_contact_name AS emergency_contact_name_36, t24.emergency_contact_phone AS emergency_contact_phone_37, t24.notes AS notes_38, t24.created_at AS created_at_39, t24.updated_at AS updated_at_40, t24.is_demo AS is_demo_41, t24.status AS status_42, t24.organization_id AS organization_id_43, t24.company_id AS company_id_44, t24.user_id AS user_id_45, t46.id AS id_47, t46.first_name AS first_name_48, t46.last_name AS last_name_49, t46.email AS email_50, t46.phone AS phone_51, t46.address AS address_52, t46.city AS city_53, t46.postal_code AS postal_code_54, t46.owner_type AS owner_type_55, t46.siret AS siret_56, t46.bank_account AS bank_account_57, t46.commission_rate AS commission_rate_58, t46.notes AS notes_59, t46.created_at AS created_at_60, t46.updated_at AS updated_at_61, t46.organization_id AS organization_id_62, t46.company_id AS company_id_63, t46.user_id AS user_id_64, t65.id AS id_66, t65.first_name AS first_name_67, t65.last_name AS last_name_68, t65.email AS email_69, t65.phone AS phone_70, t65.address AS address_71, t65.city AS city_72, t65.postal_code AS postal_code_73, t65.commune AS commune_74, t65.neighborhood AS neighborhood_75, t65.lot_number AS lot_number_76, t65.ownership_percentage AS ownership_percentage_77, t65.e_releve_enabled AS e_releve_enabled_78, t65.e_reco_enabled AS e_reco_enabled_79, t65.auto_debit_enabled AS auto_debit_enabled_80, t65.iban AS iban_81, t65.bic AS bic_82, t65.notes AS notes_83, t65.created_at AS created_at_84, t65.updated_at AS updated_at_85, t65.is_demo AS is_demo_86, t65.status AS status_87, t65.departure_date AS departure_date_88, t65.is_administrator AS is_administrator_89, t65.organization_id AS organization_id_90, t65.company_id AS company_id_91, t65.syndic_id AS syndic_id_92, t65.user_id AS user_id_93 FROM `user` t0 LEFT JOIN tenant t24 ON t24.user_id = t0.id LEFT JOIN owner t46 ON t46.user_id = t0.id LEFT JOIN co_owner t65 ON t65.user_id = t0.id WHERE t0.id = ?
Parameters:
[
60
]
|
||||||||||||||||||||||||||||||||
| 2 | 0.73 ms |
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.message AS message_2, n0_.type AS type_3, n0_.icon AS icon_4, n0_.is_read AS is_read_5, n0_.read_at AS read_at_6, n0_.route AS route_7, n0_.route_params AS route_params_8, n0_.data AS data_9, n0_.created_at AS created_at_10, n0_.user_id AS user_id_11, n0_.organization_id AS organization_id_12, n0_.company_id AS company_id_13 FROM notification n0_ WHERE n0_.user_id = ? AND n0_.is_read = ? ORDER BY n0_.created_at DESC LIMIT 5
Parameters:
[ 60 0 ]
|
||||||||||||||||||||||||||||||||
| 3 | 0.29 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ WHERE n0_.user_id = ? AND n0_.is_read = ?
Parameters:
[ 60 0 ]
|
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\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Organization | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\Tenant | No errors. |
| App\Entity\Owner | No errors. |
| App\Entity\CoOwner | No errors. |
| App\Entity\Syndic | No errors. |
| App\Entity\Property |
|
| App\Entity\Notification | No errors. |