Query Metrics
7
Database Queries
7
Different statements
5.04 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
1.12 ms (22.14%) |
1 |
SELECT s0_.id AS id_0, s0_.start_at AS start_at_1, s0_.end_at AS end_at_2, s0_.user_id AS user_id_3 FROM session_history s0_ WHERE s0_.user_id = ? AND (s0_.start_at BETWEEN ? AND ?) AND s0_.end_at IS NULL
Parameters:
[ 6425 "2026-07-28 00:00:00" "2026-07-28 23:59:59" ] |
|
1.01 ms (19.97%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
6425
]
|
|
0.72 ms (14.31%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM role t0 INNER JOIN role_user ON t0.id = role_user.role_id WHERE role_user.user_id = ?
Parameters:
[
6425
]
|
|
0.67 ms (13.38%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.66 ms (13.01%) |
1 |
UPDATE session_history SET end_at = ? WHERE id = ?
Parameters:
[ "2026-07-28 14:24:16" 614 ] |
|
0.48 ms (9.61%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.email AS email_5, t0.description AS description_6, t0.is_valid AS is_valid_7, t0.full_name AS full_name_8, t0.tel AS tel_9, t0.address AS address_10, t0.city AS city_11, t0.ice AS ice_12, t0.rc AS rc_13, t0.simulate_username AS simulate_username_14, t0.simulate_password AS simulate_password_15, t0.cover_image AS cover_image_16, t0.path_rcimage AS path_rcimage_17, t0.path_ice_image AS path_ice_image_18, t0.path_ifimage AS path_ifimage_19, t0.identifiant_fiscale AS identifiant_fiscale_20, t0.user_id AS user_id_21 FROM vendor t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
6425
]
|
|
0.38 ms (7.58%) |
1 |
"START TRANSACTION"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| salle2 | doctrine.dbal.salle2_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Flexy\ShopBundle\Entity\Vendor\Vendor | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Role | No errors. |
| App\Entity\SessionHistory | No errors. |