Query Metrics
7
Database Queries
7
Different statements
13.61 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.38 ms (24.84%) |
1 |
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:
[
"cafe-innovdam"
]
|
|
2.53 ms (18.61%) |
1 |
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:
[
"cafe-innovdam"
]
|
|
2.39 ms (17.58%) |
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 INNER JOIN evenement_groupe ON t0.id = evenement_groupe.groupe_id WHERE evenement_groupe.evenement_id = ?
Parameters:
[
287569
]
|
|
1.77 ms (13.03%) |
1 |
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:
[
287569
]
|
|
1.72 ms (12.66%) |
1 |
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:
[
287569
]
|
|
0.93 ms (6.86%) |
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:
[
"secteur-audiovisuel"
]
|
|
0.87 ms (6.42%) |
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:
[
1095
]
|
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. |