Query Metrics
4
Database Queries
4
Different statements
5.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.73 ms (32.94%) |
1 |
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:
[
"region-occitanie--pyrenees"
]
|
|
1.25 ms (23.81%) |
1 |
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.avatar_url AS avatar_url_7, t0.date_create AS date_create_8, t0.date_update AS date_update_9, t0.civilite AS civilite_10, t0.prenom AS prenom_11, t0.nom AS nom_12, t0.organisme AS organisme_13, t0.telephone_perso AS telephone_perso_14, t0.annee_naissance AS annee_naissance_15, t0.biographie AS biographie_16, t0.activites AS activites_17, t0.numero_adherent AS numero_adherent_18, t0.banned AS banned_19, t0.opt_in AS opt_in_20, t0.actif AS actif_21, t0.referent AS referent_22, t0.anonyme AS anonyme_23, t0.newsletter AS newsletter_24, t0.fiche_individuelle_id AS fiche_individuelle_id_25, t0.date_expiration AS date_expiration_26, t0.paiement AS paiement_27, t0.formule AS formule_28, t0.adresse AS adresse_29, t0.codepostal AS codepostal_30, t0.ville AS ville_31, t0.pays AS pays_32, t0.dolibarr_id AS dolibarr_id_33, t0.date_fin_validite AS date_fin_validite_34, t0.statut_adhesion AS statut_adhesion_35, t0.image_name AS image_name_36, t0.parcours_pro AS parcours_pro_37, t0.password_token AS password_token_38, t0.attente_validation AS attente_validation_39, t0.referent_user_id AS referent_user_id_40, t0.entreprise_id AS entreprise_id_41, t0.newsletter_jour_id AS newsletter_jour_id_42 FROM `user` t0 INNER JOIN user_groupe ON t0.id = user_groupe.user_id WHERE user_groupe.groupe_id = ?
Parameters:
[
115
]
|
|
1.17 ms (22.20%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM groupe_type t0 WHERE t0.id = ?
Parameters:
[
6
]
|
|
1.11 ms (21.04%) |
1 |
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 ORDER BY t0.ordre 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\Groupe | No errors. |
| App\Entity\GroupeType | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Thematique | No errors. |
| App\Entity\Segment | No errors. |
| App\Entity\Evenement | No errors. |
| App\Entity\Article | 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\ArticleType | No errors. |