Query Metrics
79
Database Queries
14
Different statements
32.05 ms
Query time
0
Invalid entities
4
Cache hits
0
Cache misses
0
Cache puts
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 4.53 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.uuid AS uuid_3, t0.type AS type_4, t0.logo AS logo_5, t0.url AS url_6, t0.switch_url AS switch_url_7, t0.reset_password_url AS reset_password_url_8, t0.init_password_url AS init_password_url_9, t0.echec_password_url AS echec_password_url_10, t0.sync_prestation_url AS sync_prestation_url_11, t0.sync_branch_url AS sync_branch_url_12, t0.retry_url AS retry_url_13, t0.secret AS secret_14, t0.import_enabled AS import_enabled_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.deleted_at AS deleted_at_20, t0.proprietaire_id AS proprietaire_id_21 FROM JAZ_PRODUIT t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"NOSE"
]
|
| 2 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.author AS author_3, t0.is_private AS is_private_4, t0.ordre AS ordre_5, t0.produit_id AS produit_id_6 FROM JAZ_DASHBOARD t0 WHERE t0.id = ?
Parameters:
[
16
]
|
| 3 | 0.51 ms |
SELECT t0.id AS id_1, t0.search_id AS search_id_2, t0.icon_color AS icon_color_3, t0.is_default AS is_default_4, t0.principal AS principal_5, t0.pictogramme AS pictogramme_6, t0.dashboard_id AS dashboard_id_7, t0.user_id AS user_id_8 FROM JAZ_USER_DASHBOARD t0 WHERE t0.dashboard_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ 16 138 ] |
| 4 | 0.42 ms |
SELECT t0.id AS id_1, t0.search_id AS search_id_2, t0.icon_color AS icon_color_3, t0.is_default AS is_default_4, t0.principal AS principal_5, t0.pictogramme AS pictogramme_6, t0.dashboard_id AS dashboard_id_7, t0.user_id AS user_id_8 FROM JAZ_USER_DASHBOARD t0 WHERE t0.user_id = ?
Parameters:
[
138
]
|
| 5 | 0.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.produit_id AS produit_id_4 FROM JAZ_HEADER t0 WHERE t0.id = ?
Parameters:
[
170
]
|
| 6 | 0.55 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.dashboard_id AS dashboard_id_3, t0.header_id AS header_id_4 FROM JAZ_DASHBOARD_HEADER t0 WHERE t0.header_id = ? AND t0.dashboard_id = ? LIMIT 1
Parameters:
[ 170 16 ] |
| 7 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
| 8 | 0.33 ms |
UPDATE JAZ_DASHBOARD_HEADER SET ordre = ? WHERE id = ?
Parameters:
[ 0 298 ] |
| 9 | 1.17 ms |
"COMMIT"
Parameters:
[] |
| 10 | 0.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.produit_id AS produit_id_4 FROM JAZ_HEADER t0 WHERE t0.id = ?
Parameters:
[
171
]
|
| 11 | 0.50 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.dashboard_id AS dashboard_id_3, t0.header_id AS header_id_4 FROM JAZ_DASHBOARD_HEADER t0 WHERE t0.header_id = ? AND t0.dashboard_id = ? LIMIT 1
Parameters:
[ 171 16 ] |
| 12 | 0.08 ms |
"START TRANSACTION"
Parameters:
[] |
| 13 | 0.26 ms |
UPDATE JAZ_DASHBOARD_HEADER SET ordre = ? WHERE id = ?
Parameters:
[ 1 299 ] |
| 14 | 0.44 ms |
"COMMIT"
Parameters:
[] |
| 15 | 0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.produit_id AS produit_id_4 FROM JAZ_HEADER t0 WHERE t0.id = ?
Parameters:
[
172
]
|
| 16 | 1.15 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.dashboard_id AS dashboard_id_3, t0.header_id AS header_id_4 FROM JAZ_DASHBOARD_HEADER t0 WHERE t0.header_id = ? AND t0.dashboard_id = ? LIMIT 1
Parameters:
[ 172 16 ] |
| 17 | 0.10 ms |
"START TRANSACTION"
Parameters:
[] |
| 18 | 0.26 ms |
UPDATE JAZ_DASHBOARD_HEADER SET ordre = ? WHERE id = ?
Parameters:
[ 2 296 ] |
| 19 | 0.46 ms |
"COMMIT"
Parameters:
[] |
| 20 | 0.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.produit_id AS produit_id_4 FROM JAZ_HEADER t0 WHERE t0.id = ?
Parameters:
[
167
]
|
| 21 | 0.46 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.dashboard_id AS dashboard_id_3, t0.header_id AS header_id_4 FROM JAZ_DASHBOARD_HEADER t0 WHERE t0.header_id = ? AND t0.dashboard_id = ? LIMIT 1
Parameters:
[ 167 16 ] |
| 22 | 0.09 ms |
"START TRANSACTION"
Parameters:
[] |
| 23 | 0.27 ms |
UPDATE JAZ_DASHBOARD_HEADER SET ordre = ? WHERE id = ?
Parameters:
[ 3 293 ] |
| 24 | 0.47 ms |
"COMMIT"
Parameters:
[] |
| 25 | 0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.produit_id AS produit_id_4 FROM JAZ_HEADER t0 WHERE t0.id = ?
Parameters:
[
173
]
|
| 26 | 0.49 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.dashboard_id AS dashboard_id_3, t0.header_id AS header_id_4 FROM JAZ_DASHBOARD_HEADER t0 WHERE t0.header_id = ? AND t0.dashboard_id = ? LIMIT 1
Parameters:
[ 173 16 ] |
| 27 | 0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.produit_id AS produit_id_4 FROM JAZ_HEADER t0 WHERE t0.id = ?
Parameters:
[
175
]
|
| 28 | 0.46 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.dashboard_id AS dashboard_id_3, t0.header_id AS header_id_4 FROM JAZ_DASHBOARD_HEADER t0 WHERE t0.header_id = ? AND t0.dashboard_id = ? LIMIT 1
Parameters:
[ 175 16 ] |
| 29 | 0.08 ms |
"START TRANSACTION"
Parameters:
[] |
| 30 | 0.30 ms |
UPDATE JAZ_DASHBOARD_HEADER SET ordre = ? WHERE id = ?
Parameters:
[ 5 300 ] |
| 31 | 0.47 ms |
"COMMIT"
Parameters:
[] |
| 32 | 0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.produit_id AS produit_id_4 FROM JAZ_HEADER t0 WHERE t0.id = ?
Parameters:
[
314
]
|
| 33 | 0.37 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.dashboard_id AS dashboard_id_3, t0.header_id AS header_id_4 FROM JAZ_DASHBOARD_HEADER t0 WHERE t0.header_id = ? AND t0.dashboard_id = ? LIMIT 1
Parameters:
[ 314 16 ] |
| 34 | 0.08 ms |
"START TRANSACTION"
Parameters:
[] |
| 35 | 0.25 ms |
UPDATE JAZ_DASHBOARD_HEADER SET ordre = ? WHERE id = ?
Parameters:
[ 6 307 ] |
| 36 | 0.55 ms |
"COMMIT"
Parameters:
[] |
| 37 | 0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.produit_id AS produit_id_4 FROM JAZ_HEADER t0 WHERE t0.id = ?
Parameters:
[
178
]
|
| 38 | 0.45 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.dashboard_id AS dashboard_id_3, t0.header_id AS header_id_4 FROM JAZ_DASHBOARD_HEADER t0 WHERE t0.header_id = ? AND t0.dashboard_id = ? LIMIT 1
Parameters:
[ 178 16 ] |
| 39 | 0.10 ms |
"START TRANSACTION"
Parameters:
[] |
| 40 | 0.27 ms |
UPDATE JAZ_DASHBOARD_HEADER SET ordre = ? WHERE id = ?
Parameters:
[ 7 303 ] |
| 41 | 0.51 ms |
"COMMIT"
Parameters:
[] |
| 42 | 0.67 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.produit_id AS produit_id_4 FROM JAZ_HEADER t0 WHERE t0.id = ?
Parameters:
[
177
]
|
| 43 | 0.45 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.dashboard_id AS dashboard_id_3, t0.header_id AS header_id_4 FROM JAZ_DASHBOARD_HEADER t0 WHERE t0.header_id = ? AND t0.dashboard_id = ? LIMIT 1
Parameters:
[ 177 16 ] |
| 44 | 0.08 ms |
"START TRANSACTION"
Parameters:
[] |
| 45 | 0.25 ms |
UPDATE JAZ_DASHBOARD_HEADER SET ordre = ? WHERE id = ?
Parameters:
[ 8 305 ] |
| 46 | 0.51 ms |
"COMMIT"
Parameters:
[] |
| 47 | 0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.produit_id AS produit_id_4 FROM JAZ_HEADER t0 WHERE t0.id = ?
Parameters:
[
180
]
|
| 48 | 0.46 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.dashboard_id AS dashboard_id_3, t0.header_id AS header_id_4 FROM JAZ_DASHBOARD_HEADER t0 WHERE t0.header_id = ? AND t0.dashboard_id = ? LIMIT 1
Parameters:
[ 180 16 ] |
| 49 | 0.08 ms |
"START TRANSACTION"
Parameters:
[] |
| 50 | 0.25 ms |
UPDATE JAZ_DASHBOARD_HEADER SET ordre = ? WHERE id = ?
Parameters:
[ 9 304 ] |
| 51 | 0.42 ms |
"COMMIT"
Parameters:
[] |
| 52 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.produit_id AS produit_id_4 FROM JAZ_HEADER t0 WHERE t0.id = ?
Parameters:
[
182
]
|
| 53 | 0.43 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.dashboard_id AS dashboard_id_3, t0.header_id AS header_id_4 FROM JAZ_DASHBOARD_HEADER t0 WHERE t0.header_id = ? AND t0.dashboard_id = ? LIMIT 1
Parameters:
[ 182 16 ] |
| 54 | 0.09 ms |
"START TRANSACTION"
Parameters:
[] |
| 55 | 0.25 ms |
UPDATE JAZ_DASHBOARD_HEADER SET ordre = ? WHERE id = ?
Parameters:
[ 10 306 ] |
| 56 | 0.41 ms |
"COMMIT"
Parameters:
[] |
| 57 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.produit_id AS produit_id_4 FROM JAZ_HEADER t0 WHERE t0.id = ?
Parameters:
[
309
]
|
| 58 | 0.49 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.dashboard_id AS dashboard_id_3, t0.header_id AS header_id_4 FROM JAZ_DASHBOARD_HEADER t0 WHERE t0.header_id = ? AND t0.dashboard_id = ? LIMIT 1
Parameters:
[ 309 16 ] |
| 59 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
| 60 | 0.26 ms |
UPDATE JAZ_DASHBOARD_HEADER SET ordre = ? WHERE id = ?
Parameters:
[ 11 301 ] |
| 61 | 0.42 ms |
"COMMIT"
Parameters:
[] |
| 62 | 0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.produit_id AS produit_id_4 FROM JAZ_HEADER t0 WHERE t0.id = ?
Parameters:
[
176
]
|
| 63 | 0.44 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.dashboard_id AS dashboard_id_3, t0.header_id AS header_id_4 FROM JAZ_DASHBOARD_HEADER t0 WHERE t0.header_id = ? AND t0.dashboard_id = ? LIMIT 1
Parameters:
[ 176 16 ] |
| 64 | 0.09 ms |
"START TRANSACTION"
Parameters:
[] |
| 65 | 0.25 ms |
UPDATE JAZ_DASHBOARD_HEADER SET ordre = ? WHERE id = ?
Parameters:
[ 12 302 ] |
| 66 | 0.44 ms |
"COMMIT"
Parameters:
[] |
| 67 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.produit_id AS produit_id_4 FROM JAZ_HEADER t0 WHERE t0.id = ?
Parameters:
[
168
]
|
| 68 | 0.50 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.dashboard_id AS dashboard_id_3, t0.header_id AS header_id_4 FROM JAZ_DASHBOARD_HEADER t0 WHERE t0.header_id = ? AND t0.dashboard_id = ? LIMIT 1
Parameters:
[ 168 16 ] |
| 69 | 0.09 ms |
"START TRANSACTION"
Parameters:
[] |
| 70 | 0.33 ms |
UPDATE JAZ_DASHBOARD_HEADER SET ordre = ? WHERE id = ?
Parameters:
[ 13 294 ] |
| 71 | 0.47 ms |
"COMMIT"
Parameters:
[] |
| 72 | 0.36 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.dashboard_id AS dashboard_id_3, t0.header_id AS header_id_4 FROM JAZ_DASHBOARD_HEADER t0 WHERE t0.dashboard_id = ?
Parameters:
[
16
]
|
| 73 | 0.37 ms |
SELECT MAX(e0_.version) AS sclr_0 FROM ext_log_entries e0_ WHERE e0_.object_id = ? AND e0_.object_class = ?
Parameters:
[ "295" "App\Entity\Admin\DashboardHeader" ] |
| 74 | 0.10 ms |
"START TRANSACTION"
Parameters:
[] |
| 75 | 0.21 ms |
INSERT INTO ext_log_entries (action, logged_at, object_id, object_class, version, data, username) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "remove" 2 => "2026-10-26 16:25:52" 3 => "295" 4 => "App\Entity\Admin\DashboardHeader" 5 => 2 6 => "N;" 7 => "API" ] |
| 76 | 0.26 ms |
DELETE FROM JAZ_DASHBOARD_HEADER WHERE id = ?
Parameters:
[
295
]
|
| 77 | 0.52 ms |
"COMMIT"
Parameters:
[] |
| 78 | 0.43 ms |
SELECT t0.id AS id_1, t0.search_id AS search_id_2, t0.icon_color AS icon_color_3, t0.is_default AS is_default_4, t0.principal AS principal_5, t0.pictogramme AS pictogramme_6, t0.dashboard_id AS dashboard_id_7, t0.user_id AS user_id_8 FROM JAZ_USER_DASHBOARD t0 WHERE t0.dashboard_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ 16 138 ] |
| 79 | 0.35 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.dashboard_id AS dashboard_id_3, t0.header_id AS header_id_4 FROM JAZ_DASHBOARD_HEADER t0 WHERE t0.dashboard_id = ? ORDER BY t0.ordre ASC
Parameters:
[
16
]
|
abi connection
No database queries were performed.
gems connection
No database queries were performed.
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| abi | doctrine.dbal.abi_connection |
| gems | doctrine.dbal.gems_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
4
Hits
0
Misses
0
Puts
Number of cache hits
| Region | Hits |
|---|---|
| jaz_user_region | 4 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Admin\User | No errors. |
| App\Entity\Admin\Department | No errors. |
| App\Entity\Admin\UserProfil | No errors. |
| App\Entity\Admin\UserProduit | No errors. |
| App\Entity\Admin\UserFonctionnalite | No errors. |
| App\Entity\Admin\Branch | No errors. |
| App\Entity\Admin\Perimetre | No errors. |
| App\Entity\Admin\UserDashboard | No errors. |
| App\Entity\Admin\UserDashboardAvailable | No errors. |
| App\Entity\Admin\UserProprietaire | No errors. |
| App\Entity\Admin\UserDeduplication | No errors. |
| App\Entity\Admin\UserDocument | No errors. |
| App\Entity\Admin\PerimetreSystem | No errors. |
| App\Entity\Admin\Produit | No errors. |
| App\Entity\Admin\Proprietaire | No errors. |
| App\Entity\Admin\Droit | No errors. |
| App\Entity\Admin\Profil | No errors. |
| App\Entity\Workflow\Workflow | No errors. |
| App\Entity\Admin\Dashboard | No errors. |
| App\Entity\Admin\DashboardHeader | No errors. |
| App\Entity\Admin\Header | No errors. |
| Gedmo\Loggable\Entity\LogEntry | No errors. |