Query Metrics
4
Database Queries
4
Different statements
5.51 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.48 ms (26.91%) |
1 |
SELECT t0.id AS id_1, t0.section AS section_2, t0.name AS name_3, t0.alias AS alias_4, t0.meta_description AS meta_description_5, t0.introduction AS introduction_6, t0.description AS description_7, t0.illustration_detail_name AS illustration_detail_name_8, t0.piece_jointe_name AS piece_jointe_name_9, t0.date_publication AS date_publication_10, t0.date_update AS date_update_11, t0.menu_contextuel AS menu_contextuel_12, t0.menu_contextuel_ordre AS menu_contextuel_ordre_13, t0.user_create_id AS user_create_id_14 FROM page_cms t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"etudes-emploi"
]
|
1.42 ms (25.83%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.commune AS commune_3, t0.nombre_heures_hebdo AS nombre_heures_hebdo_4, t0.date AS date_5, t0.description AS description_6, t0.profil_recherche AS profil_recherche_7, t0.salaire AS salaire_8, t0.employeur AS employeur_9, t0.modalites_candidature AS modalites_candidature_10, t0.coordonnees AS coordonnees_11, t0.source AS source_12, t0.alias AS alias_13, t0.date_create AS date_create_14, t0.date_update AS date_update_15, t0.reference AS reference_16, t0.published AS published_17, t0.date_publication AS date_publication_18, t0.filename AS filename_19, t0.filelabel AS filelabel_20, t0.diplome_id AS diplome_id_21, t0.statut_id AS statut_id_22, t0.user_update_id AS user_update_id_23, t0.user_create_id AS user_create_id_24, t0.pays_id AS pays_id_25, t0.tempstravail_id AS tempstravail_id_26, t0.responsabilite_id AS responsabilite_id_27 FROM emploi t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"etudes-emploi"
]
|
1.40 ms (25.32%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lien AS lien_3 FROM page_cms_lien t0 INNER JOIN page_cms_page_cms_lien ON t0.id = page_cms_page_cms_lien.page_cms_lien_id WHERE page_cms_page_cms_lien.page_cms_id = ?
Parameters:
[
16
]
|
1.21 ms (21.94%) |
1 |
SELECT p0_.name AS name_0, p0_.alias AS alias_1 FROM page_cms p0_ WHERE p0_.menu_contextuel = ? ORDER BY p0_.menu_contextuel_ordre ASC
Parameters:
[
"observatoire"
]
|
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\Emploi | No errors. |
App\Entity\EmploiDiplome | No errors. |
App\Entity\EmploiStatut | No errors. |
App\Entity\User | No errors. |
App\Entity\EmploiPays | No errors. |
App\Entity\EmploiTempsTravail | No errors. |
App\Entity\EmploiResponsabilite | No errors. |
App\Entity\PageCms | No errors. |
App\Entity\PageCmsLien | No errors. |