Query Metrics
7
Database Queries
4
Different statements
5.65 ms
Query time
0
Invalid entities
81
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.81 ms (32.10%) |
2 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.totp_secret AS totp_secret_5, t0.totp_recovery_codes AS totp_recovery_codes_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.birthdate AS birthdate_9, t0.engagement_start_date AS engagement_start_date_10, t0.email AS email_11, t0.sdis_email AS sdis_email_12, t0.hierarchical_rank AS hierarchical_rank_13, t0.birth_place AS birth_place_14, t0.address AS address_15, t0.city AS city_16, t0.zip_code AS zip_code_17, t0.civil_status AS civil_status_18, t0.land_line_phone_number AS land_line_phone_number_19, t0.mobile_phone_number AS mobile_phone_number_20, t0.partner_firstname AS partner_firstname_21, t0.partner_lastname AS partner_lastname_22, t0.number_of_children AS number_of_children_23, t0.maiden_name AS maiden_name_24, t0.gender AS gender_25, t0.personnel_number AS personnel_number_26, t0.profile_sheet AS profile_sheet_27, t0.portrait AS portrait_28, t0.is_active AS is_active_29, t0.is_retired AS is_retired_30, t0.latitude AS latitude_31, t0.longitude AS longitude_32, t0.address_geocoded_at AS address_geocoded_at_33, t0.password_changed_at AS password_changed_at_34, t0.temporary_password_expires_at AS temporary_password_expires_at_35, t0.login_count AS login_count_36, t0.last_login_at AS last_login_at_37, t0.last_seen_at AS last_seen_at_38, t0.operational_team_id AS operational_team_id_39 FROM `user` t0 INNER JOIN center_function_user ON t0.id = center_function_user.user_id WHERE center_function_user.center_function_id = ?
Parameters:
[
24
]
|
||||||||||||||||||||||||||||||||||
|
1.44 ms (25.55%) |
2 |
SELECT t0.name AS name_1, t0.value AS value_2 FROM site_setting t0 WHERE t0.name = ?
Parameters:
[
"public_access"
]
|
||||||||||||||||||||||||||||||||||
|
1.24 ms (21.93%) |
2 |
SELECT t0.id AS id_1, t0.group_key AS group_key_2, t0.label AS label_3, t0.max_holders AS max_holders_4, t0.sort_order AS sort_order_5, t0.managed_by AS managed_by_6, t0.parent_id AS parent_id_7 FROM center_function t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
"Président"
]
|
||||||||||||||||||||||||||||||||||
|
1.15 ms (20.42%) |
1 |
SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.code AS code_2, a0_.locked AS locked_3, a0_.sort_order AS sort_order_4, a0_.pages AS pages_5, c1_.id AS id_6, c1_.group_key AS group_key_7, c1_.label AS label_8, c1_.max_holders AS max_holders_9, c1_.sort_order AS sort_order_10, c1_.managed_by AS managed_by_11, a0_.center_function_id AS center_function_id_12, c1_.parent_id AS parent_id_13 FROM access_role a0_ LEFT JOIN center_function c1_ ON a0_.center_function_id = c1_.id ORDER BY a0_.sort_order ASC, a0_.label ASC
Parameters:
[] |
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\AccessRole | 42 |
| App\Entity\CenterFunction | 33 |
| App\Entity\User | 3 |
| App\Entity\OperationalTeam | 2 |
| App\Entity\SiteSetting | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\SiteSetting | No errors. |
| App\Entity\CenterFunction | No errors. |
| App\Entity\User | No errors. |
| App\Entity\OperationalTeam | No errors. |
| App\Entity\Qualification | No errors. |
| App\Entity\AccessRole | No errors. |
| App\Entity\UserPageOverride | No errors. |