https://dev-jazmin.dynaslux.lu/api/dashboard/manage

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

Show all queries

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.