Query Metrics
8
Database Queries
8
Different statements
7.82 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.58 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:
[
"secteur-recherche--reunion-de-rentree"
]
|
2 | 0.96 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:
[
"secteur-recherche--reunion-de-rentree"
]
|
3 | 0.98 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-recherche-"
]
|
4 | 1.26 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 | 0.97 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:
[
292421
]
|
6 | 0.72 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:
[
292421
]
|
7 | 0.66 ms |
SELECT t0.id AS id_1, t0.commentaire AS commentaire_2, t0.date AS date_3, t0.visible AS visible_4, t0.auteur_id AS auteur_id_5, t0.parent_id AS parent_id_6, t0.evenement_id AS evenement_id_7 FROM evenement_commentaire t0 WHERE t0.evenement_id = ?
Parameters:
[
292421
]
|
8 | 0.69 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:
[
292421
]
|
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. |