Query Metrics
87
Database Queries
31
Different statements
60.75 ms
Query time
0
Invalid entities
0
Cache hits
5
Cache misses
8
Cache puts
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
20.18 ms (33.23%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.civility AS civility_5, t0.lastname AS lastname_6, t0.firstname AS firstname_7, t0.token AS token_8, t0.api_token AS api_token_9, t0.email AS email_10, t0.email2 AS email2_11, t0.token_valid_until AS token_valid_until_12, t0.token_externe AS token_externe_13, t0.lft AS lft_14, t0.rgt AS rgt_15, t0.niveau AS niveau_16, t0.code_interlocuteur AS code_interlocuteur_17, t0.reset_token AS reset_token_18, t0.reset_token_valid_until AS reset_token_valid_until_19, t0.fonction AS fonction_20, t0.telephone AS telephone_21, t0.telephone2 AS telephone2_22, t0.google_authenticator_secret AS google_authenticator_secret_23, t0.type AS type_24, t0.nb_echec AS nb_echec_25, t0.created_by AS created_by_26, t0.updated_by AS updated_by_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.deleted_at AS deleted_at_30, t0.department_id AS department_id_31, t0.manager_id AS manager_id_32, t0.assistant_id AS assistant_id_33, t0.root_id AS root_id_34, t0.parent_id AS parent_id_35 FROM JAZ_USER t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
"API"
]
|
|
18.20 ms (29.97%) |
54 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.create_description AS create_description_4, t0.update_description AS update_description_5, t0.read_description AS read_description_6, t0.delete_description AS delete_description_7, t0.execute_description AS execute_description_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.produit_id AS produit_id_14 FROM JAZ_DROIT t0 WHERE t0.id = ?
Parameters:
[
20
]
|
|
7.07 ms (11.64%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.10 ms (1.82%) |
2 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t9.id AS id_10, t9.name AS name_11, t9.uuid AS uuid_12, t9.type AS type_13, t9.logo AS logo_14, t9.url AS url_15, t9.switch_url AS switch_url_16, t9.reset_password_url AS reset_password_url_17, t9.init_password_url AS init_password_url_18, t9.echec_password_url AS echec_password_url_19, t9.sync_prestation_url AS sync_prestation_url_20, t9.sync_branch_url AS sync_branch_url_21, t9.retry_url AS retry_url_22, t9.secret AS secret_23, t9.import_enabled AS import_enabled_24, t9.created_by AS created_by_25, t9.updated_by AS updated_by_26, t9.created_at AS created_at_27, t9.updated_at AS updated_at_28, t9.deleted_at AS deleted_at_29, t9.proprietaire_id AS proprietaire_id_30 FROM JAZ_PROPRIETAIRE t0 LEFT JOIN JAZ_PRODUIT t9 ON t9.proprietaire_id = t0.id INNER JOIN JAZ_PROP_BRANCH_ADRESSE ON t0.id = JAZ_PROP_BRANCH_ADRESSE.proprietaire_id WHERE JAZ_PROP_BRANCH_ADRESSE.branch_adresse_id = ?
Parameters:
[
38
]
|
|
1.00 ms (1.65%) |
2 |
SELECT t0.id AS id_1, t0.has_read AS has_read_2, t0.has_update AS has_update_3, t0.has_create AS has_create_4, t0.has_delete AS has_delete_5, t0.has_execute AS has_execute_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.profil_id AS profil_id_12, t0.droit_id AS droit_id_13 FROM JAZ_PROFIL_DROIT t0 WHERE t0.profil_id = ?
Parameters:
[
21
]
|
|
1.00 ms (1.64%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.civility AS civility_5, t0.lastname AS lastname_6, t0.firstname AS firstname_7, t0.token AS token_8, t0.api_token AS api_token_9, t0.email AS email_10, t0.email2 AS email2_11, t0.token_valid_until AS token_valid_until_12, t0.token_externe AS token_externe_13, t0.lft AS lft_14, t0.rgt AS rgt_15, t0.niveau AS niveau_16, t0.code_interlocuteur AS code_interlocuteur_17, t0.reset_token AS reset_token_18, t0.reset_token_valid_until AS reset_token_valid_until_19, t0.fonction AS fonction_20, t0.telephone AS telephone_21, t0.telephone2 AS telephone2_22, t0.google_authenticator_secret AS google_authenticator_secret_23, t0.type AS type_24, t0.nb_echec AS nb_echec_25, t0.created_by AS created_by_26, t0.updated_by AS updated_by_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.deleted_at AS deleted_at_30, t0.department_id AS department_id_31, t0.manager_id AS manager_id_32, t0.assistant_id AS assistant_id_33, t0.root_id AS root_id_34, t0.parent_id AS parent_id_35 FROM JAZ_USER t0 WHERE t0.username = ? AND t0.deleted_at IS NULL LIMIT 1
Parameters:
[
"celine.fabbro@detecnet.fr"
]
|
|
0.75 ms (1.24%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.produit_id AS produit_id_9 FROM JAZ_PROFIL t0 WHERE t0.id = ?
Parameters:
[
21
]
|
|
0.65 ms (1.07%) |
1 |
SELECT t0.id AS id_1, t0.password AS password_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.from_user_id AS from_user_id_5 FROM JAZ_USED_PASSWORD t0 WHERE t0.from_user_id = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
138
]
|
|
0.64 ms (1.05%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.civility AS civility_5, t0.lastname AS lastname_6, t0.firstname AS firstname_7, t0.token AS token_8, t0.api_token AS api_token_9, t0.email AS email_10, t0.email2 AS email2_11, t0.token_valid_until AS token_valid_until_12, t0.token_externe AS token_externe_13, t0.lft AS lft_14, t0.rgt AS rgt_15, t0.niveau AS niveau_16, t0.code_interlocuteur AS code_interlocuteur_17, t0.reset_token AS reset_token_18, t0.reset_token_valid_until AS reset_token_valid_until_19, t0.fonction AS fonction_20, t0.telephone AS telephone_21, t0.telephone2 AS telephone2_22, t0.google_authenticator_secret AS google_authenticator_secret_23, t0.type AS type_24, t0.nb_echec AS nb_echec_25, t0.created_by AS created_by_26, t0.updated_by AS updated_by_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.deleted_at AS deleted_at_30, t0.department_id AS department_id_31, t0.manager_id AS manager_id_32, t0.assistant_id AS assistant_id_33, t0.root_id AS root_id_34, t0.parent_id AS parent_id_35 FROM JAZ_USER t0 INNER JOIN JAZ_ACCESS_USERS ON t0.id = JAZ_ACCESS_USERS.user_target WHERE JAZ_ACCESS_USERS.user_source = ?
Parameters:
[
138
]
|
|
0.63 ms (1.04%) |
1 |
SELECT t0.id AS id_1, t0.code_client_divalto AS code_client_divalto_2, t0.code_client_sage AS code_client_sage_3, t0.code_finacca AS code_finacca_4, t0.mnemonique AS mnemonique_5, t0.commentaires_administratif AS commentaires_administratif_6, t0.client_sous_contrat AS client_sous_contrat_7, t0.type_de_contrat AS type_de_contrat_8, t0.condition_article_st AS condition_article_st_9, t0.commentaires_production AS commentaires_production_10, t0.date_creation AS date_creation_11, t0.date_cloture AS date_cloture_12, t0.statut AS statut_13, t0.nom_inter_facture AS nom_inter_facture_14, t0.prenom_inter_facture AS prenom_inter_facture_15, t0.telephone AS telephone_16, t0.mail AS mail_17, t0.is_active AS is_active_18, t0.is_default AS is_default_19, t0.type_facturation AS type_facturation_20, t0.is_sage AS is_sage_21, t0.created_by AS created_by_22, t0.updated_by AS updated_by_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.deleted_at AS deleted_at_26, t0.recurrence AS recurrence_27, t0.recurrence_debut AS recurrence_debut_28, t0.recurrence_fin AS recurrence_fin_29, t0.last_process AS last_process_30, t0.next_process AS next_process_31, t0.branch_id AS branch_id_32, t0.proprietaire_id AS proprietaire_id_33 FROM JAZ_BRANCH_PROPRIETAIRE t0 WHERE t0.branch_id = ?
Parameters:
[
28
]
|
|
0.57 ms (0.93%) |
1 |
SELECT t0.id AS id_1, t0.has_db_auth AS has_db_auth_2, t0.is_active AS is_active_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.branch_id AS branch_id_9, t0.produit_id AS produit_id_10 FROM JAZ_BRANCH_PRODUIT t0 WHERE t0.branch_id = ? AND t0.produit_id = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ 28 2 1 ] |
|
0.55 ms (0.91%) |
1 |
UPDATE JAZ_USER SET updated_by = ?, updated_at = ? WHERE id = ?
Parameters:
[ null "2026-10-26 13:36:56" 138 ] |
|
0.53 ms (0.87%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t9.id AS id_10, t9.name AS name_11, t9.uuid AS uuid_12, t9.type AS type_13, t9.logo AS logo_14, t9.url AS url_15, t9.switch_url AS switch_url_16, t9.reset_password_url AS reset_password_url_17, t9.init_password_url AS init_password_url_18, t9.echec_password_url AS echec_password_url_19, t9.sync_prestation_url AS sync_prestation_url_20, t9.sync_branch_url AS sync_branch_url_21, t9.retry_url AS retry_url_22, t9.secret AS secret_23, t9.import_enabled AS import_enabled_24, t9.created_by AS created_by_25, t9.updated_by AS updated_by_26, t9.created_at AS created_at_27, t9.updated_at AS updated_at_28, t9.deleted_at AS deleted_at_29, t9.proprietaire_id AS proprietaire_id_30 FROM JAZ_PROPRIETAIRE t0 LEFT JOIN JAZ_PRODUIT t9 ON t9.proprietaire_id = t0.id WHERE t0.id = ?
Parameters:
[
4
]
|
|
0.53 ms (0.87%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.niveau AS niveau_4, t0.lft AS lft_5, t0.rgt AS rgt_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.branch_id AS branch_id_12, t0.parent_id AS parent_id_13, t0.root_id AS root_id_14 FROM JAZ_DEPARTMENT t0 INNER JOIN JAZ_ACCESS_DEPARTMENTS ON t0.id = JAZ_ACCESS_DEPARTMENTS.department_id WHERE JAZ_ACCESS_DEPARTMENTS.user_id = ?
Parameters:
[
138
]
|
|
0.52 ms (0.86%) |
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:
[
"DYNASLUX"
]
|
|
0.52 ms (0.86%) |
1 |
SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.mnemonique AS mnemonique_3, t0.siren AS siren_4, t0.siret AS siret_5, t0.is_active AS is_active_6, t0.niveau AS niveau_7, t0.lft AS lft_8, t0.rgt AS rgt_9, t0.code_naf AS code_naf_10, t0.telephone AS telephone_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.type_id AS type_id_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19, t0.is_proprietaire_id AS is_proprietaire_id_20 FROM JAZ_BRANCH t0 WHERE t0.id = ?
Parameters:
[
28
]
|
|
0.51 ms (0.84%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.niveau AS niveau_4, t0.lft AS lft_5, t0.rgt AS rgt_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.branch_id AS branch_id_12, t0.parent_id AS parent_id_13, t0.root_id AS root_id_14 FROM JAZ_DEPARTMENT t0 WHERE t0.id = ?
Parameters:
[
23
]
|
|
0.50 ms (0.83%) |
1 |
SELECT t0.id AS id_1, t0.has_db_auth AS has_db_auth_2, t0.is_active AS is_active_3, t0.cgu_accepted_at AS cgu_accepted_at_4, t0.cgv_accepted_at AS cgv_accepted_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.user_id AS user_id_11, t0.produit_id AS produit_id_12, t0.default_proprietaire_id AS default_proprietaire_id_13 FROM JAZ_USER_PRODUIT t0 WHERE t0.user_id = ? AND t0.produit_id = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ 138 2 1 ] |
|
0.49 ms (0.81%) |
1 |
SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.mnemonique AS mnemonique_3, t0.siren AS siren_4, t0.siret AS siret_5, t0.is_active AS is_active_6, t0.niveau AS niveau_7, t0.lft AS lft_8, t0.rgt AS rgt_9, t0.code_naf AS code_naf_10, t0.telephone AS telephone_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.type_id AS type_id_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19, t0.is_proprietaire_id AS is_proprietaire_id_20 FROM JAZ_BRANCH t0 INNER JOIN JAZ_ACCESS_BRANCHES ON t0.id = JAZ_ACCESS_BRANCHES.branch_id WHERE JAZ_ACCESS_BRANCHES.user_id = ?
Parameters:
[
138
]
|
|
0.46 ms (0.76%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_client AS nom_client_3, t0.code_postal AS code_postal_4, t0.ville AS ville_5, t0.adresse1 AS adresse1_6, t0.adresse2 AS adresse2_7, t0.adresse3 AS adresse3_8, t0.adresse4 AS adresse4_9, t0.rue AS rue_10, t0.pays AS pays_11, t0.code_tva AS code_tva_12, t0.code_tva_intracom AS code_tva_intracom_13, t0.type AS type_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.branch_id AS branch_id_20 FROM JAZ_BRANCH_ADRESSE t0 WHERE t0.branch_id = ?
Parameters:
[
28
]
|
|
0.46 ms (0.76%) |
1 |
SELECT t0.id AS id_1, t0.has_db_auth AS has_db_auth_2, t0.is_active AS is_active_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.department_id AS department_id_9, t0.produit_id AS produit_id_10 FROM JAZ_DEPARTMENT_PRODUIT t0 WHERE t0.department_id = ? AND t0.produit_id = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ 23 2 1 ] |
|
0.45 ms (0.75%) |
1 |
SELECT t0.id AS id_1, t0.has_db_auth AS has_db_auth_2, t0.is_active AS is_active_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.branch_id AS branch_id_9, t0.produit_id AS produit_id_10 FROM JAZ_BRANCH_PRODUIT t0 WHERE t0.branch_id = ? AND t0.produit_id = ? LIMIT 1
Parameters:
[ 28 2 ] |
|
0.45 ms (0.74%) |
1 |
SELECT j0_.id AS id_0, j0_.name AS name_1, j0_.author AS author_2, j0_.is_private AS is_private_3, j0_.ordre AS ordre_4, j0_.produit_id AS produit_id_5 FROM JAZ_DASHBOARD j0_ INNER JOIN JAZ_USER_DASHBOARD j1_ ON (j1_.dashboard_id = j0_.id) WHERE j0_.produit_id = ? AND j1_.user_id = ? ORDER BY j0_.ordre ASC
Parameters:
[ 2 138 ] |
|
0.45 ms (0.74%) |
1 |
SELECT j0_.id AS id_0, j0_.has_db_auth AS has_db_auth_1, j0_.is_active AS is_active_2, j0_.cgu_accepted_at AS cgu_accepted_at_3, j0_.cgv_accepted_at AS cgv_accepted_at_4, j0_.created_by AS created_by_5, j0_.updated_by AS updated_by_6, j0_.created_at AS created_at_7, j0_.updated_at AS updated_at_8, j0_.deleted_at AS deleted_at_9, j0_.user_id AS user_id_10, j0_.produit_id AS produit_id_11, j0_.default_proprietaire_id AS default_proprietaire_id_12 FROM JAZ_USER_PRODUIT j0_ INNER JOIN JAZ_PRODUIT j1_ ON j0_.produit_id = j1_.id WHERE j0_.user_id = ? AND j1_.name = ?
Parameters:
[ 138 "DYNASLUX" ] |
|
0.42 ms (0.70%) |
1 |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.code_interlocuteur AS code_interlocuteur_3, t0.creation_date AS creation_date_4, t0.closure_date AS closure_date_5, t0.is_dest_fact AS is_dest_fact_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.user__id AS user__id_12, t0.proprietaire_id AS proprietaire_id_13, t0.branch_adresse_id AS branch_adresse_id_14 FROM JAZ_USER_PROPRIETAIRE t0 WHERE t0.user__id = ?
Parameters:
[
138
]
|
|
0.42 ms (0.68%) |
1 |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.user_id_id AS user_id_id_8, t0.profil_id AS profil_id_9 FROM JAZ_USER_PROFIL t0 WHERE t0.user_id_id = ?
Parameters:
[
138
]
|
|
0.41 ms (0.68%) |
1 |
SELECT j0_.options AS options_0 FROM JAZ_PERIMETRE_SYSTEM j0_ WHERE j0_.deleted_at IS NULL AND j0_.is_active = 1 AND EXISTS (SELECT 1 FROM JAZ_USER_PERIMETRE_SYSTEM j1_ WHERE j1_.perimetre_system_id = j0_.id AND j1_.user_id IN (?)) AND j0_.produit_id = ? LIMIT 1
Parameters:
[ 138 2 ] |
|
0.41 ms (0.67%) |
1 |
SELECT t0.id AS id_1, t0.has_db_auth AS has_db_auth_2, t0.is_active AS is_active_3, t0.cgu_accepted_at AS cgu_accepted_at_4, t0.cgv_accepted_at AS cgv_accepted_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.user_id AS user_id_11, t0.produit_id AS produit_id_12, t0.default_proprietaire_id AS default_proprietaire_id_13 FROM JAZ_USER_PRODUIT t0 WHERE t0.user_id = ? AND t0.produit_id = ? LIMIT 1
Parameters:
[ 138 2 ] |
|
0.36 ms (0.59%) |
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.id = ?
Parameters:
[
3
]
|
|
0.33 ms (0.54%) |
1 |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.options AS options_3, t0.options_key AS options_key_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.department_fonctionnalite_id AS department_fonctionnalite_id_10, t0.user__id AS user__id_11 FROM JAZ_USER_FONCTIONNALITE t0 WHERE t0.user__id = ?
Parameters:
[
138
]
|
|
0.17 ms (0.28%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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
0
Hits
5
Misses
8
Puts
Number of cache misses
| Region | Misses |
|---|---|
| jaz_user_region | 2 |
| jaz_department_region | 2 |
| jaz_branch_region | 1 |
Number of cache puts
| Region | Puts |
|---|---|
| jaz_user_region | 5 |
| jaz_department_region | 2 |
| jaz_branch_region | 1 |
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\UsedPassword | No errors. |
| App\Entity\Admin\DepartmentFonctionnalite | No errors. |
| App\Entity\Admin\DepartmentProduit | 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\BranchProduit | No errors. |
| Gedmo\Loggable\Entity\LogEntry | No errors. |
| App\Entity\Admin\BranchType | No errors. |
| App\Entity\Admin\BranchContact | No errors. |
| App\Entity\Admin\BranchAdresse | No errors. |
| App\Entity\Admin\BranchDocument | No errors. |
| App\Entity\Admin\BranchProprietaire | No errors. |
| App\Entity\Admin\PrestationSystem | No errors. |
| App\Entity\Admin\BranchProprietaireCommentaire | No errors. |
| App\Entity\Admin\PrestationDetail | No errors. |
| App\Entity\Admin\ProfilDroit | No errors. |
| App\Entity\Admin\Dashboard | No errors. |