Query Metrics

17 Database Queries
10 Different statements
7.63 ms Query time
0 Invalid entities
88 Managed entities

Queries

Group similar statements

core connection

# Time Info
1 0.49 ms
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 = ?
Parameters:
[
  1
]
2 0.39 ms
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 = ?
Parameters:
[
  1
]
3 0.45 ms
SELECT s0_.valeur AS valeur_0 FROM services_parameters s0_ WHERE s0_.reference = ?
Parameters:
[
  "BREVO_API_KEY"
]
4 0.40 ms
SELECT s0_.valeur AS valeur_0 FROM services_parameters s0_ WHERE s0_.reference = ?
Parameters:
[
  "OVH_S3_REGION"
]
5 0.34 ms
SELECT s0_.valeur AS valeur_0 FROM services_parameters s0_ WHERE s0_.reference = ?
Parameters:
[
  "OVH_S3_ACCESS_KEY"
]
6 0.34 ms
SELECT s0_.valeur AS valeur_0 FROM services_parameters s0_ WHERE s0_.reference = ?
Parameters:
[
  "OVH_S3_SECRET_KEY"
]
7 0.32 ms
SELECT s0_.valeur AS valeur_0 FROM services_parameters s0_ WHERE s0_.reference = ?
Parameters:
[
  "OVH_S3_ENDPOINT"
]
8 0.54 ms
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
Parameters:
[]
9 0.43 ms
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
Parameters:
[]
10 0.31 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM statut_dossier t0
Parameters:
[]

tenant connection

# Time Info
1 0.56 ms
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 = ?
Parameters:
[
  1
]
2 0.62 ms
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
Parameters:
[
  1
  2
]
3 0.48 ms
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
Parameters:
[]
4 0.61 ms
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 = ?
Parameters:
[
  1
]
5 0.44 ms
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 = ?
Parameters:
[
  3
]
6 0.46 ms
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 = ?
Parameters:
[
  1
]
7 0.44 ms
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 = ?
Parameters:
[
  2
]

Database Connections

Name Service
core doctrine.dbal.core_connection
tenant doctrine.dbal.tenant_connection

Entity Managers

Name Service
core doctrine.orm.core_entity_manager
tenant doctrine.orm.tenant_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

core entity manager

Class Amount of managed objects
App\Entity\Global\FormeJuridique 58
App\Entity\Global\StatutDossier 4
App\Entity\Global\User 1
App\Entity\Global\Civilite 1
App\Entity\Global\Tenant 1
App\Entity\Global\Domiciliataire 1

tenant entity manager

Class Amount of managed objects
App\Entity\Tenant\Dossier 8
App\Entity\Tenant\PersonnePhysique 8
App\Entity\Tenant\UserCentreAcces 3
App\Entity\Tenant\Centre 3

Entities Mapping

core entity manager

Class Mapping errors
App\Entity\Global\User No errors.
App\Entity\Global\Civilite No errors.
App\Entity\Global\Tenant No errors.
App\Entity\Global\Domiciliataire No errors.
App\Entity\Global\ServicesParameter No errors.
App\Entity\Global\FormeJuridique No errors.
App\Entity\Global\StatutDossier No errors.

tenant entity manager

Class Mapping errors
App\Entity\Tenant\UserCentreAcces No errors.
App\Entity\Tenant\Dossier No errors.
App\Entity\Tenant\Centre No errors.
App\Entity\Tenant\PersonnePhysique No errors.