Query Metrics
104
Database Queries
12
Different statements
587.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
299.00 ms (50.85%) |
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
]
|
|
151.53 ms (25.77%) |
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"
]
|
|
56.20 ms (9.56%) |
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
]
|
|
17.81 ms (3.03%) |
2 |
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:
[
1
]
|
|
16.08 ms (2.74%) |
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 = ? AND t0.active = ? LIMIT 1
Parameters:
[ "gerer-les-agressions-dans-commerce" 1 ] |
|
14.50 ms (2.47%) |
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:
[] |
|
11.30 ms (1.92%) |
1 |
SELECT f0_.id AS id_0, f0_.titre AS titre_1, f0_.reference AS reference_2, f0_.duree_valeur AS duree_valeur_3, f0_.duree_unite AS duree_unite_4, f0_.objectifs AS objectifs_5, f0_.programme AS programme_6, f0_.prerequis AS prerequis_7, f0_.evaluation AS evaluation_8, f0_.public AS public_9, f0_.methode AS methode_10, f0_.active AS active_11, f0_.inter_prix AS inter_prix_12, f0_.inter_active AS inter_active_13, f0_.intra_prix AS intra_prix_14, f0_.intra_active AS intra_active_15, f0_.slug AS slug_16, f0_.description AS description_17, f0_.intro AS intro_18, f0_.intro_devis AS intro_devis_19, f0_.description60chr AS description60chr_20, f0_.support_ppt AS support_ppt_21, f0_.support_pdf AS support_pdf_22, f0_.autoevaluation AS autoevaluation_23, f0_.evaluation_finale AS evaluation_finale_24, f0_.date_maj AS date_maj_25, f0_.ordre AS ordre_26, f0_.favoris AS favoris_27, f0_.texte_bas AS texte_bas_28, f0_.faq AS faq_29, f0_.categorie_id AS categorie_id_30 FROM formation f0_ WHERE f0_.id <> ? AND f0_.active = 1 AND f0_.categorie_id = ? ORDER BY f0_.ordre ASC
Parameters:
[ 512 66 ] |
|
7.27 ms (1.24%) |
1 |
SELECT f0_.id AS id_0, f0_.date_debut AS date_debut_1, f0_.date_fin AS date_fin_2, f0_.formation_id AS formation_id_3 FROM formation_date f0_ WHERE f0_.formation_id = ? AND f0_.date_debut > ? ORDER BY f0_.date_debut ASC
Parameters:
[ 512 "2026-05-06 16:05:51" ] |
|
6.11 ms (1.04%) |
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
]
|
|
3.75 ms (0.64%) |
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:
[
66
]
|
|
3.34 ms (0.57%) |
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.06 ms (0.18%) |
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. |