Query Metrics

13 Database Queries
11 Different statements
17.53 ms Query time
0 Invalid entities
6 Managed entities

Grouped Statements

Show all queries

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