Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.email_secours AS email_secours_3,
  t0.nom AS nom_4,
  t0.prenom AS prenom_5,
  t0.telephone_portable AS telephone_portable_6,
  t0.photo AS photo_7,
  t0.password AS password_8,
  t0.statut AS statut_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.totp_secret AS totp_secret_13,
  t0.is_two_factor_enabled AS is_two_factor_enabled_14,
  t0.password_reset_code AS password_reset_code_15,
  t0.password_reset_expires_at AS password_reset_expires_at_16,
  t0.email_auth_enabled AS email_auth_enabled_17,
  t0.email_auth_code AS email_auth_code_18,
  t0.email_auth_code_generated_at AS email_auth_code_generated_at_19,
  t0.preferred_2fa AS preferred_2fa_20,
  t0.civilite_id AS civilite_id_21
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.email_secours AS email_secours_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.telephone_portable AS telephone_portable_6, t0.photo AS photo_7, t0.password AS password_8, t0.statut AS statut_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.totp_secret AS totp_secret_13, t0.is_two_factor_enabled AS is_two_factor_enabled_14, t0.password_reset_code AS password_reset_code_15, t0.password_reset_expires_at  AS password_reset_expires_at_16, t0.email_auth_enabled AS email_auth_enabled_17, t0.email_auth_code AS email_auth_code_18, t0.email_auth_code_generated_at AS email_auth_code_generated_at_19, t0.preferred_2fa AS preferred_2fa_20, t0.civilite_id AS civilite_id_21 FROM users t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.db_driver AS db_driver_3,
  t0.db_host AS db_host_4,
  t0.db_port AS db_port_5,
  t0.db_name AS db_name_6,
  t0.db_user AS db_user_7,
  t0.db_password AS db_password_8,
  t0.status AS status_9,
  t0.created_at AS created_at_10,
  t0.bucket AS bucket_11,
  t0.domiciliataire_id AS domiciliataire_id_12
FROM
  tenants t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.db_driver AS db_driver_3, t0.db_host AS db_host_4, t0.db_port AS db_port_5, t0.db_name AS db_name_6, t0.db_user AS db_user_7, t0.db_password AS db_password_8, t0.status AS status_9, t0.created_at AS created_at_10, t0.bucket AS bucket_11, t0.domiciliataire_id AS domiciliataire_id_12 FROM tenants t0 WHERE t0.id = 1;

SELECT
  s0_.valeur AS valeur_0
FROM
  services_parameters s0_
WHERE
  s0_.reference = ?

SELECT s0_.valeur AS valeur_0 FROM services_parameters s0_ WHERE s0_.reference = 'BREVO_API_KEY';

SELECT
  s0_.valeur AS valeur_0
FROM
  services_parameters s0_
WHERE
  s0_.reference = ?

SELECT s0_.valeur AS valeur_0 FROM services_parameters s0_ WHERE s0_.reference = 'OVH_S3_REGION';

SELECT
  s0_.valeur AS valeur_0
FROM
  services_parameters s0_
WHERE
  s0_.reference = ?

SELECT s0_.valeur AS valeur_0 FROM services_parameters s0_ WHERE s0_.reference = 'OVH_S3_ACCESS_KEY';

SELECT
  s0_.valeur AS valeur_0
FROM
  services_parameters s0_
WHERE
  s0_.reference = ?

SELECT s0_.valeur AS valeur_0 FROM services_parameters s0_ WHERE s0_.reference = 'OVH_S3_SECRET_KEY';

SELECT
  s0_.valeur AS valeur_0
FROM
  services_parameters s0_
WHERE
  s0_.reference = ?

SELECT s0_.valeur AS valeur_0 FROM services_parameters s0_ WHERE s0_.reference = 'OVH_S3_ENDPOINT';

SELECT
  t0.id AS id_1,
  t0.code_insee AS code_insee_2,
  t0.code_abrege AS code_abrege_3,
  t0.libelle AS libelle_4,
  t0.categorie AS categorie_5,
  t0.actif AS actif_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  formes_juridiques t0
WHERE
  t0.code_abrege IS NULL
ORDER BY
  t0.libelle ASC

SELECT t0.id AS id_1, t0.code_insee AS code_insee_2, t0.code_abrege AS code_abrege_3, t0.libelle AS libelle_4, t0.categorie AS categorie_5, t0.actif AS actif_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM formes_juridiques t0 WHERE t0.code_abrege IS NULL ORDER BY t0.libelle ASC;

SELECT
  f0_.id AS id_0,
  f0_.code_insee AS code_insee_1,
  f0_.code_abrege AS code_abrege_2,
  f0_.libelle AS libelle_3,
  f0_.categorie AS categorie_4,
  f0_.actif AS actif_5,
  f0_.created_at AS created_at_6,
  f0_.updated_at AS updated_at_7
FROM
  formes_juridiques f0_
WHERE
  f0_.code_abrege IS NOT NULL
ORDER BY
  f0_.code_abrege ASC

SELECT f0_.id AS id_0, f0_.code_insee AS code_insee_1, f0_.code_abrege AS code_abrege_2, f0_.libelle AS libelle_3, f0_.categorie AS categorie_4, f0_.actif AS actif_5, f0_.created_at AS created_at_6, f0_.updated_at AS updated_at_7 FROM formes_juridiques f0_ WHERE f0_.code_abrege IS NOT NULL ORDER BY f0_.code_abrege ASC;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  statut_dossier t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM statut_dossier t0;

SELECT
  COUNT(*)
FROM
  memberships t0
WHERE
  t0.user_id = ?
  AND t0.is_enabled = ?

SELECT COUNT(*) FROM memberships t0 WHERE t0.user_id = 1 AND t0.is_enabled = 1;

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2,
  t0.centre_id AS centre_id_3
FROM
  users_centres_access t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.centre_id AS centre_id_3 FROM users_centres_access t0 WHERE t0.user_id = 1;

SELECT
  d0_.id AS id_0,
  d0_.code_dossier AS code_dossier_1,
  d0_.domiciliataire_id AS domiciliataire_id_2,
  d0_.nom_societe AS nom_societe_3,
  d0_.nom_commercial AS nom_commercial_4,
  d0_.siren AS siren_5,
  d0_.siret AS siret_6,
  d0_.tva_intracom AS tva_intracom_7,
  d0_.forme_juridique_id AS forme_juridique_id_8,
  d0_.capital_social AS capital_social_9,
  d0_.secteur_activite_id AS secteur_activite_id_10,
  d0_.activite AS activite_11,
  d0_.statut_id AS statut_id_12,
  d0_.origine_siege AS origine_siege_13,
  d0_.email_comptable AS email_comptable_14,
  d0_.contact_principal_id AS contact_principal_id_15,
  d0_.site_internet_societe AS site_internet_societe_16,
  d0_.stripe_customer_id AS stripe_customer_id_17,
  d0_.created_by AS created_by_18,
  d0_.logo AS logo_19,
  d0_.created_at AS created_at_20,
  d0_.updated_at AS updated_at_21,
  d0_.centre_id AS centre_id_22
FROM
  dossiers d0_
WHERE
  d0_.centre_id IN (?, ?)
ORDER BY
  d0_.code_dossier ASC

SELECT d0_.id AS id_0, d0_.code_dossier AS code_dossier_1, d0_.domiciliataire_id AS domiciliataire_id_2, d0_.nom_societe AS nom_societe_3, d0_.nom_commercial AS nom_commercial_4, d0_.siren AS siren_5, d0_.siret AS siret_6, d0_.tva_intracom AS tva_intracom_7, d0_.forme_juridique_id AS forme_juridique_id_8, d0_.capital_social AS capital_social_9, d0_.secteur_activite_id AS secteur_activite_id_10, d0_.activite AS activite_11, d0_.statut_id AS statut_id_12, d0_.origine_siege AS origine_siege_13, d0_.email_comptable AS email_comptable_14, d0_.contact_principal_id AS contact_principal_id_15, d0_.site_internet_societe AS site_internet_societe_16, d0_.stripe_customer_id AS stripe_customer_id_17, d0_.created_by AS created_by_18, d0_.logo AS logo_19, d0_.created_at AS created_at_20, d0_.updated_at AS updated_at_21, d0_.centre_id AS centre_id_22 FROM dossiers d0_ WHERE d0_.centre_id IN (1, 2) ORDER BY d0_.code_dossier ASC;

SELECT
  t0.id AS id_1,
  t0.domiciliataire_id AS domiciliataire_id_2,
  t0.civilite_id AS civilite_id_3,
  t0.nom AS nom_4,
  t0.nom_jeune_fille AS nom_jeune_fille_5,
  t0.prenom AS prenom_6,
  t0.photo AS photo_7,
  t0.date_naissance AS date_naissance_8,
  t0.lieu_naissance AS lieu_naissance_9,
  t0.nationalite_id AS nationalite_id_10,
  t0.adresse AS adresse_11,
  t0.complement_adresse AS complement_adresse_12,
  t0.code_postal AS code_postal_13,
  t0.ville AS ville_14,
  t0.pays_id AS pays_id_15,
  t0.email AS email_16,
  t0.tel_fixe AS tel_fixe_17,
  t0.tel_portable AS tel_portable_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20
FROM
  personnes_physiques t0

SELECT t0.id AS id_1, t0.domiciliataire_id AS domiciliataire_id_2, t0.civilite_id AS civilite_id_3, t0.nom AS nom_4, t0.nom_jeune_fille AS nom_jeune_fille_5, t0.prenom AS prenom_6, t0.photo AS photo_7, t0.date_naissance AS date_naissance_8, t0.lieu_naissance AS lieu_naissance_9, t0.nationalite_id AS nationalite_id_10, t0.adresse AS adresse_11, t0.complement_adresse AS complement_adresse_12, t0.code_postal AS code_postal_13, t0.ville AS ville_14, t0.pays_id AS pays_id_15, t0.email AS email_16, t0.tel_fixe AS tel_fixe_17, t0.tel_portable AS tel_portable_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20 FROM personnes_physiques t0;

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2,
  t0.centre_id AS centre_id_3
FROM
  users_centres_access t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.centre_id AS centre_id_3 FROM users_centres_access t0 WHERE t0.user_id = 1;

SELECT
  t0.id AS id_1,
  t0.domiciliataire_id AS domiciliataire_id_2,
  t0.nom_commercial AS nom_commercial_3,
  t0.denomination_interne AS denomination_interne_4,
  t0.adresse AS adresse_5,
  t0.code_postal AS code_postal_6,
  t0.ville AS ville_7,
  t0.pays_id AS pays_id_8,
  t0.latitude AS latitude_9,
  t0.longitude AS longitude_10,
  t0.email AS email_11,
  t0.telephone AS telephone_12,
  t0.siret AS siret_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  centres t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.domiciliataire_id AS domiciliataire_id_2, t0.nom_commercial AS nom_commercial_3, t0.denomination_interne AS denomination_interne_4, t0.adresse AS adresse_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.pays_id AS pays_id_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.email AS email_11, t0.telephone AS telephone_12, t0.siret AS siret_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM centres t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.domiciliataire_id AS domiciliataire_id_2,
  t0.nom_commercial AS nom_commercial_3,
  t0.denomination_interne AS denomination_interne_4,
  t0.adresse AS adresse_5,
  t0.code_postal AS code_postal_6,
  t0.ville AS ville_7,
  t0.pays_id AS pays_id_8,
  t0.latitude AS latitude_9,
  t0.longitude AS longitude_10,
  t0.email AS email_11,
  t0.telephone AS telephone_12,
  t0.siret AS siret_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  centres t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.domiciliataire_id AS domiciliataire_id_2, t0.nom_commercial AS nom_commercial_3, t0.denomination_interne AS denomination_interne_4, t0.adresse AS adresse_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.pays_id AS pays_id_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.email AS email_11, t0.telephone AS telephone_12, t0.siret AS siret_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM centres t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.domiciliataire_id AS domiciliataire_id_2,
  t0.nom_commercial AS nom_commercial_3,
  t0.denomination_interne AS denomination_interne_4,
  t0.adresse AS adresse_5,
  t0.code_postal AS code_postal_6,
  t0.ville AS ville_7,
  t0.pays_id AS pays_id_8,
  t0.latitude AS latitude_9,
  t0.longitude AS longitude_10,
  t0.email AS email_11,
  t0.telephone AS telephone_12,
  t0.siret AS siret_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  centres t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.domiciliataire_id AS domiciliataire_id_2, t0.nom_commercial AS nom_commercial_3, t0.denomination_interne AS denomination_interne_4, t0.adresse AS adresse_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.pays_id AS pays_id_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.email AS email_11, t0.telephone AS telephone_12, t0.siret AS siret_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM centres t0 WHERE t0.id = 2;