GET https://adbs.spontaneit.fr/reseau/groupes/secteur-atce/cycle-de-conferences-droit-dauteur-et-rgpd

Query Metrics

8 Database Queries
8 Different statements
10.55 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.image_name AS image_name_4, t0.introduction AS introduction_5, t0.insert_html AS insert_html_6, t0.description AS description_7, t0.date_create AS date_create_8, t0.date_update AS date_update_9, t0.commentaire_accepte AS commentaire_accepte_10, t0.reserve_adherent AS reserve_adherent_11, t0.signature AS signature_12, t0.date_publication AS date_publication_13, t0.filename AS filename_14, t0.filename2 AS filename2_15, t0.filename3 AS filename3_16, t0.filename4 AS filename4_17, t0.filename5 AS filename5_18, t0.type_id AS type_id_19, t0.auteur_id AS auteur_id_20, t0.statut_id AS statut_id_21 FROM article t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
  "cycle-de-conferences-droit-dauteur-et-rgpd"
]
2 1.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
  "secteur-atce"
]
3 1.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM groupe_type t0 WHERE t0.id = ?
Parameters:
[
  1095
]
4 1.52 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.password AS password_4, t0.nb_post AS nb_post_5, t0.role AS role_6, t0.non_beneficiaire AS non_beneficiaire_7, t0.avatar_url AS avatar_url_8, t0.date_create AS date_create_9, t0.date_update AS date_update_10, t0.civilite AS civilite_11, t0.prenom AS prenom_12, t0.nom AS nom_13, t0.organisme AS organisme_14, t0.telephone_perso AS telephone_perso_15, t0.annee_naissance AS annee_naissance_16, t0.biographie AS biographie_17, t0.activites AS activites_18, t0.numero_adherent AS numero_adherent_19, t0.banned AS banned_20, t0.opt_in AS opt_in_21, t0.actif AS actif_22, t0.referent AS referent_23, t0.anonyme AS anonyme_24, t0.newsletter AS newsletter_25, t0.fiche_individuelle_id AS fiche_individuelle_id_26, t0.date_expiration AS date_expiration_27, t0.paiement AS paiement_28, t0.formule AS formule_29, t0.adresse AS adresse_30, t0.codepostal AS codepostal_31, t0.ville AS ville_32, t0.pays AS pays_33, t0.dolibarr_id AS dolibarr_id_34, t0.date_fin_validite AS date_fin_validite_35, t0.statut_adhesion AS statut_adhesion_36, t0.image_name AS image_name_37, t0.parcours_pro AS parcours_pro_38, t0.password_token AS password_token_39, t0.attente_validation AS attente_validation_40, t0.referent_user_id AS referent_user_id_41, t0.entreprise_id AS entreprise_id_42, t0.newsletter_jour_id AS newsletter_jour_id_43 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  7519
]
5 1.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
  47
]
6 1.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lien AS lien_3 FROM article_lien t0 INNER JOIN article_article_lien ON t0.id = article_article_lien.article_lien_id WHERE article_article_lien.article_id = ?
Parameters:
[
  47
]
7 1.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.libelle AS libelle_3, t0.ordre AS ordre_4 FROM article_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
8 1.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.date_create AS date_create_4, t0.date_update AS date_update_5, t0.alias AS alias_6 FROM thematique t0 INNER JOIN article_thematique ON t0.id = article_thematique.thematique_id WHERE article_thematique.article_id = ?
Parameters:
[
  47
]

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\Article No errors.
App\Entity\ArticleType No errors.
App\Entity\User No errors.
App\Entity\Statut No errors.
App\Entity\Groupe No errors.
App\Entity\Thematique No errors.
App\Entity\ArticleLien No errors.
App\Entity\ArticleCommentaire No errors.
App\Entity\GroupeType No errors.
App\Entity\Segment No errors.
App\Entity\Evenement No errors.
App\Entity\UserGroupeException No errors.
App\Entity\Partenaire No errors.
App\Entity\CompteRenduReunion No errors.
App\Entity\FicheOrganisme No errors.
App\Entity\NewsletterJour No errors.
App\Entity\UserFacture No errors.
App\Entity\Communique No errors.
App\Entity\PageCms No errors.
App\Entity\PortraitPro 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\EvenementCommentaire No errors.
App\Entity\CompteRenduReunionCommentaire No errors.