Query Metrics
8
Database Queries
8
Different statements
11.75 ms
Query time
3
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.70 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.type_id AS type_id_17, t0.auteur_id AS auteur_id_18, t0.statut_id AS statut_id_19 FROM article t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"n19--un-jour-une-astuce-to-do"
]
|
2 | 1.61 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.pays AS pays_6, t0.adresse1 AS adresse1_7, t0.adresse2 AS adresse2_8, t0.code_postal AS code_postal_9, t0.ville AS ville_10, t0.alias AS alias_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.date_create AS date_create_14, t0.date_update AS date_update_15, t0.introduction AS introduction_16, t0.insert_html AS insert_html_17, t0.image_name AS image_name_18, t0.commentaire_accepte AS commentaire_accepte_19, t0.horaires AS horaires_20, t0.reserve_adherent AS reserve_adherent_21, t0.signature AS signature_22, t0.filename AS filename_23, t0.date_publication AS date_publication_24, t0.filename2 AS filename2_25, t0.filename3 AS filename3_26, t0.rubrique_id AS rubrique_id_27, t0.user_create_id AS user_create_id_28, t0.user_update_id AS user_update_id_29, t0.statut_id AS statut_id_30, t0.auteur_id AS auteur_id_31 FROM evenement t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"n19--un-jour-une-astuce-to-do"
]
|
3 | 1.26 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"
]
|
4 | 1.70 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
]
|
5 | 1.62 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.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 WHERE t0.id = ?
Parameters:
[
7519
]
|
6 | 1.48 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 evenement_groupe ON t0.id = evenement_groupe.groupe_id WHERE evenement_groupe.evenement_id = ?
Parameters:
[
291256
]
|
7 | 1.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lien AS lien_3 FROM evenement_lien t0 INNER JOIN evenement_evenement_lien ON t0.id = evenement_evenement_lien.evenement_lien_id WHERE evenement_evenement_lien.evenement_id = ?
Parameters:
[
291256
]
|
8 | 1.24 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 evenement_type t0 INNER JOIN evenement_evenement_type ON t0.id = evenement_evenement_type.evenement_type_id WHERE evenement_evenement_type.evenement_id = ?
Parameters:
[
291256
]
|
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\Evenement | No errors. |
App\Entity\EvenementRubrique | No errors. |
App\Entity\EvenementType | No errors. |
App\Entity\Metier |
|
App\Entity\Thematique | No errors. |
App\Entity\Groupe | No errors. |
App\Entity\EvenementCommentaire | No errors. |
App\Entity\EvenementLien | No errors. |
App\Entity\GroupeType | No errors. |
App\Entity\Segment | 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 |
|
App\Entity\FicheAdresse |
|
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\CompteRenduReunionCommentaire | No errors. |