Symfony Profiler

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

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 = 'API' LIMIT 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

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 = 'celine.fabbro@detecnet.fr' AND t0.deleted_at IS NULL LIMIT 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

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 = 138 ORDER BY t0.id DESC LIMIT 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

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 = 'DYNASLUX' LIMIT 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

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 = 138 AND t0.produit_id = 2 AND t0.is_active = 1 LIMIT 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

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 = 23 AND t0.produit_id = 2 AND t0.is_active = 1 LIMIT 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

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 = 28 AND t0.produit_id = 2 AND t0.is_active = 1 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  JAZ_USER
SET
  updated_at = ?,
  updated_by = ?
WHERE
  id = ?

UPDATE JAZ_USER SET updated_at = '2026-10-26 14:09:29', updated_by = 'API' WHERE id = 138;

"COMMIT"

"COMMIT";

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 = ?

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 = 28;

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 = ?

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 = 4;

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 = ?

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 = 138;

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 = ?

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 = 28;

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 = ?

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 = 38;

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 = ?

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 = 40;

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 = ?

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 = 138;

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 = ?

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 = 138;

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 = ?

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 = 138;

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 = ?

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 = 21;