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
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
7.25 ms (22.61%) |
14 |
"COMMIT"
Parameters:
[] |
|
7.20 ms (22.45%) |
14 |
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 ] |
|
4.94 ms (15.40%) |
14 |
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
]
|
|
4.53 ms (14.13%) |
1 |
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"
]
|
|
3.53 ms (11.01%) |
13 |
UPDATE JAZ_DASHBOARD_HEADER SET ordre = ? WHERE id = ?
Parameters:
[ 0 298 ] |
|
1.31 ms (4.07%) |
14 |
"START TRANSACTION"
Parameters:
[] |
|
0.94 ms (2.92%) |
2 |
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 ] |
|
0.42 ms (1.32%) |
1 |
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
]
|
|
0.40 ms (1.25%) |
1 |
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
]
|
|
0.37 ms (1.15%) |
1 |
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" ] |
|
0.36 ms (1.11%) |
1 |
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
]
|
|
0.35 ms (1.10%) |
1 |
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
]
|
|
0.26 ms (0.81%) |
1 |
DELETE FROM JAZ_DASHBOARD_HEADER WHERE id = ?
Parameters:
[
295
]
|
|
0.21 ms (0.66%) |
1 |
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" ] |
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. |