Query Metrics
14
Database Queries
12
Different statements
10.66 ms
Query time
3
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.75 ms |
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:
[
"e1061dd87d-be5666ea90-09fdda49de-62166b68cb-223124ac51"
]
|
| 2 | 0.57 ms |
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:
[
54
]
|
| 3 | 0.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rolename AS rolename_3 FROM role_group t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 4 | 0.32 ms |
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:
[
1
]
|
| 5 | 0.42 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.organisateur_id AS organisateur_id_3, t0.destination_id AS destination_id_4 FROM sejour t0 WHERE t0.id = ?
Parameters:
[
"4"
]
|
| 6 | 0.76 ms |
SELECT c0_.id AS id_0, c0_.hash_value AS hash_value_1, c0_.execute AS execute_2, c0_.status AS status_3, c0_.commande_id AS commande_id_4, c0_.allow_execute AS allow_execute_5, c0_.sejour_id AS sejour_id_6, c0_.instance_id AS instance_id_7 FROM commande c0_ WHERE c0_.commande_id = ? AND c0_.instance_id = ?
Parameters:
[ 24640 11 ] |
| 7 | 0.29 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.instance_id AS instance_id_3 FROM organisateur t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 8 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.dbname AS dbname_3, t0.host AS host_4, t0.password AS password_5, t0.dbuser AS dbuser_6, t0.site AS site_7, t0.allow_sync_commande AS allow_sync_commande_8 FROM instance t0 WHERE t0.id = ?
Parameters:
[
18
]
|
| 9 | 0.20 ms |
"START TRANSACTION"
Parameters:
[] |
| 10 | 0.34 ms |
INSERT INTO commande (hash_value, execute, status, commande_id, allow_execute, sejour_id, instance_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "{"depart":"2026-08-092026-08-1533","etat":1,"sejour":"4","commentaire":"cbd17b7fecd27bd417d17096d5d25524","option_echeance":"2026-04-17","formalite":["Fiche Sanitaire","Carnet de vaccinations \u00e0 jour avec nom et pr\u00e9nom de l'enfant","Questionnaire m\u00e9dical","Copie de l'attestation d'assurance maladie"],"produitannexes":[],"commrepreparti":[{"parti":"GALVAN TEJADASebastian2009-12-17","repre":"TEJADAYenisjennytejada1992@gmail.com","options":[],"formalites":[]}]}" 2 => 0 3 => "NEW" 4 => 24640 5 => 1 6 => 4 7 => 11 ] |
| 11 | 2.76 ms |
"COMMIT"
Parameters:
[] |
| 12 | 0.19 ms |
"START TRANSACTION"
Parameters:
[] |
| 13 | 0.32 ms |
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-04-03 14:51:36" 2 => "/api/commande" 3 => "POST" 4 => "10.42.154.147" 5 => "e1061dd87d-be5666ea90-09fdda49de-62166b68cb-223124ac51" 6 => 1 7 => "commande" 8 => null 9 => "a:2:{s:3:"get";a:0:{}s:4:"post";a:0:{}}" 10 => 0 11 => null 12 => null 13 => null 14 => 54 ] |
| 14 | 2.95 ms |
"COMMIT"
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\Sejour |
|
| App\Entity\Organisateur |
|
| App\Entity\Destination |
|
| App\Entity\PartageSejour | No errors. |
| App\Entity\Commande | No errors. |
| App\Entity\PartageSejourAlert | No errors. |
| App\Entity\Enseigne | No errors. |
| App\Entity\CommandeClient | No errors. |