Query Metrics
13
Database Queries
11
Different statements
17.53 ms
Query time
0
Invalid entities
6
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.85 ms (21.99%) |
2 |
"COMMIT"
Parameters:
[] |
|
3.57 ms (20.37%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4, t0.site_id AS site_id_5 FROM user_site t0 WHERE t0.user_id = ?
Parameters:
[
25
]
|
|
2.41 ms (13.74%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.text_color AS text_color_4, t0.bg_color AS bg_color_5, t0.priority AS priority_6, t0.deleted_at AS deleted_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM user_status t0 WHERE t0.value = ? LIMIT 1
Parameters:
[
"valid"
]
|
|
2.04 ms (11.64%) |
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.email = ? LIMIT 1
Parameters:
[
"dorra@yopmail.com"
]
|
|
1.24 ms (7.05%) |
1 |
SELECT t0.refresh_token AS refresh_token_1, t0.username AS username_2, t0.valid AS valid_3, t0.id AS id_4 FROM refresh_tokens t0 WHERE t0.refresh_token = ? LIMIT 1
Parameters:
[
"1883c32e43d8488714e6484b419050e8d872db0cb1bef47c354a5c534bdaa4cbd41ac0037c5a971e05476feb29d3b17566bedd0892ed7c6f036f44fed6046a5d"
]
|
|
1.21 ms (6.88%) |
1 |
UPDATE user SET default_site_id = ?, updated_at = ? WHERE id = ?
Parameters:
[ 7 "2026-11-03 18:36:26" 25 ] |
|
1.17 ms (6.68%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.deleted_at AS deleted_at_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM site t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"750-SEV"
]
|
|
0.94 ms (5.36%) |
1 |
INSERT INTO user_site (created_at, updated_at, user_id, site_id) VALUES (?, ?, ?, ?)
Parameters:
[ "2026-11-03 18:36:26" "2026-11-03 18:36:26" 25 7 ] |
|
0.49 ms (2.78%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
0.37 ms (2.08%) |
1 |
INSERT INTO refresh_tokens (refresh_token, username, valid) VALUES (?, ?, ?)
Parameters:
[ "1883c32e43d8488714e6484b419050e8d872db0cb1bef47c354a5c534bdaa4cbd41ac0037c5a971e05476feb29d3b17566bedd0892ed7c6f036f44fed6046a5d" "dorra@yopmail.com" "2026-12-03 18:36:26" ] |
|
0.25 ms (1.43%) |
1 |
DELETE FROM user_site WHERE id = ?
Parameters:
[
99
]
|
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\Site | 2 |
| App\Entity\User\User | 1 |
| App\Entity\User\UserStatus | 1 |
| App\Entity\User\UserSite | 1 |
| App\Entity\RefreshToken | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken | No errors. |
| App\Entity\RefreshToken | No 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. |