Query Metrics
7
Database Queries
7
Different statements
7.30 ms
Query time
0
Invalid entities
4
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.11 ms (28.89%) |
1 |
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.value AS value_2, u0_.text_color AS text_color_3, u0_.bg_color AS bg_color_4, u0_.priority AS priority_5, u0_.deleted_at AS deleted_at_6, u0_.created_at AS created_at_7, u0_.updated_at AS updated_at_8 FROM user_status u0_ WHERE u0_.deleted_at IS NULL
Parameters:
[] |
|
1.47 ms (20.11%) |
1 |
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.date_from AS date_from_2, e0_.date_to AS date_to_3, MONTH(e0_.date_to) AS sclr_4, YEAR(e0_.date_to) AS sclr_5 FROM event e0_ LEFT JOIN event_type e1_ ON e0_.event_type_id = e1_.id LEFT JOIN category c2_ ON e0_.category_id = c2_.id WHERE e0_.deleted_at IS NULL AND e0_.date_to < ? ORDER BY e0_.date_to ASC
Parameters:
[
"2026-11-03 18:37:13"
]
|
|
1.41 ms (19.26%) |
1 |
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.branch AS branch_7, t0.is_sso AS is_sso_8, t0.societe AS societe_9, t0.code_branche AS code_branche_10, t0.code_regate AS code_regate_11, t0.poste_vlpuser AS poste_vlpuser_12, t0.poste_vlp_site AS poste_vlp_site_13, t0.deleted_at AS deleted_at_14, t0.reset_token AS reset_token_15, t0.password_requested_at AS password_requested_at_16, t0.code AS code_17, t0.push_notification_enabled AS push_notification_enabled_18, t0.email_notification_enabled AS email_notification_enabled_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.status_id AS status_id_22, t0.default_site_id AS default_site_id_23 FROM user t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
0.66 ms (9.02%) |
1 |
SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN user_status u1_ ON u0_.status_id = u1_.id WHERE u0_.deleted_at IS NULL
Parameters:
[] |
|
0.65 ms (8.95%) |
1 |
SELECT MIN(YEAR(e0_.date_to)) AS sclr_0, YEAR(CURRENT_DATE) AS sclr_1 FROM event e0_
Parameters:
[] |
|
0.56 ms (7.64%) |
1 |
SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.last_name AS last_name_2, u0_.email AS email_3, u0_.roles AS roles_4, u1_.name AS name_5, u1_.bg_color AS bg_color_6, u1_.text_color AS text_color_7 FROM user u0_ LEFT JOIN user_status u1_ ON u0_.status_id = u1_.id WHERE u0_.deleted_at IS NULL AND u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY u0_.id DESC
Parameters:
[ 35 32 31 30 29 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 ] |
|
0.45 ms (6.13%) |
1 |
SELECT DISTINCT u0_.id AS id_0, u0_.id AS id_1 FROM user u0_ LEFT JOIN user_status u1_ ON u0_.status_id = u1_.id WHERE u0_.deleted_at IS NULL ORDER BY u0_.id DESC LIMIT 20
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\User\UserStatus | 2 |
| App\Entity\User\User | 1 |
| App\Entity\User\Site | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User\User | No errors. |
| App\Entity\User\UserStatus | No errors. |
| App\Entity\User\Site | No errors. |
| App\Entity\User\UserStatusHistory | No errors. |
| App\Entity\Event\Event | No errors. |
| App\Entity\UserEvent\UserEvent | No errors. |
| App\Entity\Email\EmailHistory | No errors. |
| App\Entity\UserEvent\UserEventHistory | No errors. |
| App\Entity\User\UserSite | No errors. |
| App\Entity\Event\EventType | No errors. |
| App\Entity\Event\Category | No errors. |