Query Metrics
2
Database Queries
2
Different statements
2.28 ms
Query time
0
Invalid entities
7
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.60 ms |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.totp_secret AS totp_secret_4, u0_.totp_recovery_codes AS totp_recovery_codes_5, u0_.firstname AS firstname_6, u0_.lastname AS lastname_7, u0_.birthdate AS birthdate_8, u0_.engagement_start_date AS engagement_start_date_9, u0_.email AS email_10, u0_.sdis_email AS sdis_email_11, u0_.hierarchical_rank AS hierarchical_rank_12, u0_.birth_place AS birth_place_13, u0_.address AS address_14, u0_.city AS city_15, u0_.zip_code AS zip_code_16, u0_.civil_status AS civil_status_17, u0_.land_line_phone_number AS land_line_phone_number_18, u0_.mobile_phone_number AS mobile_phone_number_19, u0_.partner_firstname AS partner_firstname_20, u0_.partner_lastname AS partner_lastname_21, u0_.number_of_children AS number_of_children_22, u0_.maiden_name AS maiden_name_23, u0_.gender AS gender_24, u0_.personnel_number AS personnel_number_25, u0_.profile_sheet AS profile_sheet_26, u0_.portrait AS portrait_27, u0_.is_active AS is_active_28, u0_.is_retired AS is_retired_29, u0_.latitude AS latitude_30, u0_.longitude AS longitude_31, u0_.address_geocoded_at AS address_geocoded_at_32, u0_.password_changed_at AS password_changed_at_33, u0_.temporary_password_expires_at AS temporary_password_expires_at_34, u0_.login_count AS login_count_35, u0_.last_login_at AS last_login_at_36, u0_.last_seen_at AS last_seen_at_37, a1_.id AS id_38, a1_.label AS label_39, a1_.code AS code_40, a1_.locked AS locked_41, a1_.sort_order AS sort_order_42, a1_.pages AS pages_43, c2_.id AS id_44, c2_.group_key AS group_key_45, c2_.label AS label_46, c2_.max_holders AS max_holders_47, c2_.sort_order AS sort_order_48, c2_.managed_by AS managed_by_49, u3_.id AS id_50, u3_.page_code AS page_code_51, u3_.granted AS granted_52, o4_.id AS id_53, o4_.number AS number_54, o4_.logo AS logo_55, o4_.color AS color_56, u0_.operational_team_id AS operational_team_id_57, a1_.center_function_id AS center_function_id_58, c2_.parent_id AS parent_id_59, u3_.user_id AS user_id_60 FROM `user` u0_ LEFT JOIN access_role_user a5_ ON u0_.id = a5_.user_id LEFT JOIN access_role a1_ ON a1_.id = a5_.access_role_id LEFT JOIN center_function_user c6_ ON u0_.id = c6_.user_id LEFT JOIN center_function c2_ ON c2_.id = c6_.center_function_id LEFT JOIN user_page_override u3_ ON u0_.id = u3_.user_id LEFT JOIN operational_team o4_ ON u0_.operational_team_id = o4_.id WHERE u0_.id = ?
Parameters:
[
21
]
|
| 2 | 0.68 ms |
SELECT t0.name AS name_1, t0.value AS value_2 FROM site_setting t0 WHERE t0.name = ?
Parameters:
[
"public_access"
]
|
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\CenterFunction | 4 |
| App\Entity\User | 1 |
| App\Entity\OperationalTeam | 1 |
| App\Entity\SiteSetting | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\AccessRole | No errors. |
| App\Entity\CenterFunction | No errors. |
| App\Entity\UserPageOverride | No errors. |
| App\Entity\OperationalTeam | No errors. |
| App\Entity\Qualification | No errors. |
| App\Entity\SiteSetting | No errors. |