Query Metrics
102
Database Queries
10
Different statements
145.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
87.82 ms (60.34%) |
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.89 ms (15.04%) |
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.43 ms (14.03%) |
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"
]
|
|
3.85 ms (2.65%) |
1 |
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.slug = ? LIMIT 1
Parameters:
[
"hygiene-alimentaire-maitriser-methode-haccp"
]
|
|
2.79 ms (1.91%) |
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:
[
2
]
|
|
2.71 ms (1.86%) |
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.60 ms (1.79%) |
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_
Parameters:
[] |
|
1.38 ms (0.95%) |
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:
[] |
|
1.11 ms (0.77%) |
1 |
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.id = ?
Parameters:
[
18
]
|
|
0.96 ms (0.66%) |
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\Formation | No errors. |
| App\Entity\Categorie | No errors. |
| App\Entity\Inscription | No errors. |
| App\Entity\FormationDate | No errors. |
| App\Entity\EvalQuestion | No errors. |
| App\Entity\Theme | No errors. |
| App\Entity\Actu | No errors. |
| App\Entity\Dossier | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\DossierCategorie | No errors. |