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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
3.81 ms
(47.71%)
1
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_.avatar_url AS avatar_url_6, u0_.date_create AS date_create_7, u0_.date_update AS date_update_8, u0_.civilite AS civilite_9, u0_.prenom AS prenom_10, u0_.nom AS nom_11, u0_.organisme AS organisme_12, u0_.telephone_perso AS telephone_perso_13, u0_.annee_naissance AS annee_naissance_14, u0_.biographie AS biographie_15, u0_.activites AS activites_16, u0_.numero_adherent AS numero_adherent_17, u0_.banned AS banned_18, u0_.opt_in AS opt_in_19, u0_.actif AS actif_20, u0_.referent AS referent_21, u0_.anonyme AS anonyme_22, u0_.newsletter AS newsletter_23, u0_.fiche_individuelle_id AS fiche_individuelle_id_24, u0_.date_expiration AS date_expiration_25, u0_.paiement AS paiement_26, u0_.formule AS formule_27, u0_.adresse AS adresse_28, u0_.codepostal AS codepostal_29, u0_.ville AS ville_30, u0_.pays AS pays_31, u0_.dolibarr_id AS dolibarr_id_32, u0_.date_fin_validite AS date_fin_validite_33, u0_.statut_adhesion AS statut_adhesion_34, u0_.image_name AS image_name_35, u0_.parcours_pro AS parcours_pro_36, u0_.password_token AS password_token_37, u0_.attente_validation AS attente_validation_38, u0_.referent_user_id AS referent_user_id_39, u0_.entreprise_id AS entreprise_id_40, u0_.newsletter_jour_id AS newsletter_jour_id_41 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"
  "2024-10-22 01:39:27"
]
1.99 ms
(24.88%)
2
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"
]
1.11 ms
(13.88%)
1
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"
]
1.08 ms
(13.52%)
1
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:
[]

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.