GET https://adbs.spontaneit.fr/reseau/annuaire

Query Metrics

5 Database Queries
4 Different statements
12.26 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 6.26 ms
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.password AS password_3, u0_.nb_post AS nb_post_4, u0_.role AS role_5, u0_.non_beneficiaire AS non_beneficiaire_6, u0_.avatar_url AS avatar_url_7, u0_.date_create AS date_create_8, u0_.date_update AS date_update_9, u0_.civilite AS civilite_10, u0_.prenom AS prenom_11, u0_.nom AS nom_12, u0_.organisme AS organisme_13, u0_.telephone_perso AS telephone_perso_14, u0_.annee_naissance AS annee_naissance_15, u0_.biographie AS biographie_16, u0_.activites AS activites_17, u0_.numero_adherent AS numero_adherent_18, u0_.banned AS banned_19, u0_.opt_in AS opt_in_20, u0_.actif AS actif_21, u0_.referent AS referent_22, u0_.anonyme AS anonyme_23, u0_.newsletter AS newsletter_24, u0_.fiche_individuelle_id AS fiche_individuelle_id_25, u0_.date_expiration AS date_expiration_26, u0_.paiement AS paiement_27, u0_.formule AS formule_28, u0_.adresse AS adresse_29, u0_.codepostal AS codepostal_30, u0_.ville AS ville_31, u0_.pays AS pays_32, u0_.dolibarr_id AS dolibarr_id_33, u0_.date_fin_validite AS date_fin_validite_34, u0_.statut_adhesion AS statut_adhesion_35, u0_.image_name AS image_name_36, u0_.parcours_pro AS parcours_pro_37, u0_.password_token AS password_token_38, u0_.attente_validation AS attente_validation_39, u0_.referent_user_id AS referent_user_id_40, u0_.entreprise_id AS entreprise_id_41, u0_.newsletter_jour_id AS newsletter_jour_id_42 FROM `user` u0_ WHERE u0_.actif = 1 AND u0_.statut_adhesion = 'valide' AND u0_.anonyme = 0 AND u0_.email NOT LIKE ? AND u0_.date_fin_validite >= ? ORDER BY u0_.nom ASC
Parameters:
[
  "%.adbs"
  "2025-05-09 05:09:29"
]
2 1.85 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.alias AS alias_4, t0.groupe_id AS groupe_id_5 FROM segment t0 WHERE t0.type = ? ORDER BY t0.name ASC
Parameters:
[
  "Secteur"
]
3 1.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.alias AS alias_4, t0.groupe_id AS groupe_id_5 FROM segment t0 WHERE t0.type = ? ORDER BY t0.name ASC
Parameters:
[
  "Thématique"
]
4 1.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.numero AS numero_3, t0.alias AS alias_4 FROM departement t0 ORDER BY t0.numero ASC
Parameters:
[]
5 1.23 ms
SELECT DISTINCT u0_.pays AS pays_0 FROM `user` u0_ WHERE u0_.actif = 1 AND u0_.statut_adhesion = 'valide' AND u0_.anonyme = 0 AND u0_.email NOT LIKE ? ORDER BY u0_.pays ASC
Parameters:
[
  "%.adbs"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\FicheOrganisme No errors.
App\Entity\NewsletterJour No errors.
App\Entity\Groupe No errors.
App\Entity\UserFacture No errors.
App\Entity\Segment No errors.
App\Entity\CompteRenduReunion No errors.
App\Entity\Evenement No errors.
App\Entity\Communique No errors.
App\Entity\PageCms No errors.
App\Entity\PortraitPro No errors.
App\Entity\Article No errors.
App\Entity\ActivitePrincipale No errors.
App\Entity\SecteurActivite
  • The association App\Entity\SecteurActivite#ficheOrganismes refers to the owning side field App\Entity\FicheOrganisme#secteurs which does not exist.
App\Entity\FicheAdresse
  • The association App\Entity\FicheAdresse#ficheOrganismes refers to the owning side field App\Entity\FicheOrganisme#adresses which does not exist.
App\Entity\Emploi No errors.
App\Entity\Document No errors.
App\Entity\Forum No errors.
App\Entity\ForumSub No errors.
App\Entity\ForumThread No errors.
App\Entity\ForumPost No errors.
App\Entity\ForumPostReport No errors.
App\Entity\ForumPostVote No errors.
App\Entity\ArticleCommentaire No errors.
App\Entity\EvenementCommentaire No errors.
App\Entity\UserGroupeException No errors.
App\Entity\CompteRenduReunionCommentaire No errors.
App\Entity\Departement No errors.