Query Metrics
10
Database Queries
9
Different statements
10.12 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.69 ms (0.00%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.79 ms (0.00%) |
1 |
SELECT a0_.id AS id_0, a0_.token AS token_1, a0_.expires_at AS expires_at_2, a0_.user_id AS user_id_3 FROM api_token a0_ WHERE a0_.token = ?
Parameters:
[
"sol5f02v5f-ghol56328q-tgk85d63v8-d0319b1180-s85d41f239"
]
|
|
1.29 ms (0.00%) |
2 |
SELECT count(p0_.id) AS sclr_0 FROM partage_sejour_alert p0_ INNER JOIN organisateur o1_ ON p0_.organisateur_id = o1_.id INNER JOIN instance i2_ ON p0_.origin_instance_id = i2_.id WHERE p0_.dest_instance_id = ? AND p0_.readed = 0
Parameters:
[
27
]
|
|
0.81 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.username AS username_4, t0.email AS email_5, t0.password AS password_6, t0.salt AS salt_7, t0.last_link_requested_at AS last_link_requested_at_8, t0.instance_id AS instance_id_9, t0.role_group_id AS role_group_id_10 FROM user t0 WHERE t0.id = ?
Parameters:
[
34
]
|
|
0.61 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.module AS module_3 FROM role t0 INNER JOIN role_role_group ON t0.id = role_role_group.role_id WHERE role_role_group.role_group_id = ?
Parameters:
[
2
]
|
|
0.59 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rolename AS rolename_3 FROM role_group t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.56 ms (0.00%) |
1 |
SELECT o0_.nom AS nom_0, p1_.sujet AS sujet_1, i2_.name AS name_2, p1_.message AS message_3, DATE_FORMAT (p1_.date_create,'%d/%m/%Y %h:%i:%s') AS sclr_4, p1_.id AS id_5 FROM partage_sejour_alert p1_ INNER JOIN organisateur o0_ ON p1_.organisateur_id = o0_.id INNER JOIN instance i2_ ON p1_.origin_instance_id = i2_.id WHERE p1_.dest_instance_id = ? AND p1_.readed = 0
Parameters:
[
27
]
|
|
0.48 ms (0.00%) |
1 |
INSERT INTO api_logs (date_time, url, method, request_ip, api_key, authenticated, ressource, ressource_id, params, has_exception, exception_class, exception_message, exception_code, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "2026-03-01 17:55:39" 2 => "/api/partageSejourAlert?method=alert&alldisplay=0" 3 => "GET" 4 => "10.42.154.147" 5 => "sol5f02v5f-ghol56328q-tgk85d63v8-d0319b1180-s85d41f239" 6 => 1 7 => "partageSejourAlert" 8 => null 9 => "a:2:{s:3:"get";a:2:{s:6:"method";s:5:"alert";s:10:"alldisplay";s:1:"0";}s:4:"post";a:0:{}}" 10 => 0 11 => null 12 => null 13 => null 14 => 34 ] |
|
0.29 ms (0.00%) |
1 |
"START TRANSACTION"
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\ApiToken | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Instance | No errors. |
| App\Entity\RoleGroup | No errors. |
| App\Entity\Role | No errors. |
| App\Entity\ApiLogs | No errors. |
| App\Entity\PartageSejourAlert | No errors. |
| App\Entity\Organisateur |
|