Query Metrics
104
Database Queries
11
Different statements
148.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
87.56 ms (58.99%) |
54 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.reference AS reference_3, t0.duree_valeur AS duree_valeur_4, t0.duree_unite AS duree_unite_5, t0.objectifs AS objectifs_6, t0.programme AS programme_7, t0.prerequis AS prerequis_8, t0.evaluation AS evaluation_9, t0.public AS public_10, t0.methode AS methode_11, t0.active AS active_12, t0.inter_prix AS inter_prix_13, t0.inter_active AS inter_active_14, t0.intra_prix AS intra_prix_15, t0.intra_active AS intra_active_16, t0.slug AS slug_17, t0.description AS description_18, t0.intro AS intro_19, t0.intro_devis AS intro_devis_20, t0.description60chr AS description60chr_21, t0.support_ppt AS support_ppt_22, t0.support_pdf AS support_pdf_23, t0.autoevaluation AS autoevaluation_24, t0.evaluation_finale AS evaluation_finale_25, t0.date_maj AS date_maj_26, t0.ordre AS ordre_27, t0.favoris AS favoris_28, t0.texte_bas AS texte_bas_29, t0.faq AS faq_30, t0.categorie_id AS categorie_id_31 FROM formation t0 WHERE t0.categorie_id = ?
Parameters:
[
64
]
|
|
21.58 ms (14.54%) |
19 |
SELECT c0_.id AS id_0, c0_.titre AS titre_1, c0_.titre_menu AS titre_menu_2, c0_.icon AS icon_3, c0_.texte_haut AS texte_haut_4, c0_.texte_bas AS texte_bas_5, c0_.slug AS slug_6, c0_.banner AS banner_7, c0_.ordre AS ordre_8, c0_.parent_id AS parent_id_9 FROM categorie c0_ WHERE c0_.parent_id = ? ORDER BY c0_.ordre DESC
Parameters:
[
64
]
|
|
20.40 ms (13.75%) |
19 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.titre_menu AS titre_menu_3, t0.icon AS icon_4, t0.texte_haut AS texte_haut_5, t0.texte_bas AS texte_bas_6, t0.slug AS slug_7, t0.banner AS banner_8, t0.ordre AS ordre_9, t0.parent_id AS parent_id_10 FROM categorie t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"accueil-pmr-et-psh"
]
|
|
4.91 ms (3.31%) |
2 |
SELECT d0_.id AS id_0, d0_.titre AS titre_1, d0_.chapo AS chapo_2, d0_.texte AS texte_3, d0_.slug AS slug_4, d0_.date AS date_5, d0_.texte_update AS texte_update_6, d0_.date_update AS date_update_7, d0_.description AS description_8, d0_.image AS image_9, d0_.credit AS credit_10, d0_.categorie_id AS categorie_id_11, d0_.catalogue_id AS catalogue_id_12 FROM dossier d0_
Parameters:
[] |
|
2.78 ms (1.87%) |
3 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.texte AS texte_3, t0.slug AS slug_4 FROM dossier_categorie t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
2.71 ms (1.83%) |
2 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.titre_menu AS titre_menu_3, t0.chapo AS chapo_4, t0.texte AS texte_5, t0.ordre AS ordre_6, t0.type AS type_7, t0.img AS img_8, t0.slug AS slug_9 FROM page t0 WHERE t0.type = ? ORDER BY t0.ordre ASC
Parameters:
[
1
]
|
|
2.51 ms (1.69%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.chapo AS chapo_3, t0.texte AS texte_4, t0.slug AS slug_5, t0.date AS date_6, t0.texte_update AS texte_update_7, t0.date_update AS date_update_8, t0.description AS description_9, t0.image AS image_10, t0.credit AS credit_11, t0.categorie_id AS categorie_id_12, t0.catalogue_id AS catalogue_id_13 FROM dossier t0
Parameters:
[] |
|
1.88 ms (1.27%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.chapo AS chapo_3, t0.texte AS texte_4, t0.slug AS slug_5, t0.date AS date_6, t0.texte_update AS texte_update_7, t0.date_update AS date_update_8, t0.description AS description_9, t0.image AS image_10, t0.credit AS credit_11, t0.categorie_id AS categorie_id_12, t0.catalogue_id AS catalogue_id_13 FROM dossier t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"formation-cse-obligatoire-ce-que-employeur-doit-financer-et-comment-eviter-les-erreurs-"
]
|
|
1.80 ms (1.21%) |
1 |
SELECT d0_.id AS id_0, d0_.titre AS titre_1, d0_.chapo AS chapo_2, d0_.texte AS texte_3, d0_.slug AS slug_4, d0_.date AS date_5, d0_.texte_update AS texte_update_6, d0_.date_update AS date_update_7, d0_.description AS description_8, d0_.image AS image_9, d0_.credit AS credit_10, d0_.categorie_id AS categorie_id_11, d0_.catalogue_id AS catalogue_id_12 FROM dossier d0_ WHERE d0_.categorie_id = ? AND d0_.id <> ? ORDER BY d0_.id DESC LIMIT 5
Parameters:
[ 3 31 ] |
|
1.37 ms (0.93%) |
1 |
SELECT c0_.id AS id_0, c0_.titre AS titre_1, c0_.titre_menu AS titre_menu_2, c0_.icon AS icon_3, c0_.texte_haut AS texte_haut_4, c0_.texte_bas AS texte_bas_5, c0_.slug AS slug_6, c0_.banner AS banner_7, c0_.ordre AS ordre_8, c0_.parent_id AS parent_id_9 FROM categorie c0_ WHERE c0_.titre_menu IS NOT NULL ORDER BY c0_.titre ASC
Parameters:
[] |
|
0.92 ms (0.62%) |
1 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.slug AS slug_3, t0.titre AS titre_4, t0.texte AS texte_5, t0.chapo AS chapo_6, t0.texte2 AS texte2_7, t0.titre_listing_formation AS titre_listing_formation_8, t0.titre_listing_dossier AS titre_listing_dossier_9, t0.description AS description_10 FROM theme t0
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\Dossier | No errors. |
| App\Entity\DossierCategorie | No errors. |
| App\Entity\Categorie | No errors. |
| App\Entity\Theme | No errors. |
| App\Entity\Formation | No errors. |
| App\Entity\Inscription | No errors. |
| App\Entity\FormationDate | No errors. |
| App\Entity\EvalQuestion | No errors. |
| App\Entity\Actu | No errors. |
| App\Entity\Page | No errors. |