Query Metrics
104
Database Queries
12
Different statements
151.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
87.78 ms (57.82%) |
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.84 ms (14.38%) |
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.51 ms (13.51%) |
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"
]
|
|
6.08 ms (4.01%) |
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:
[] |
|
5.11 ms (3.37%) |
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:
[
"cse-ssct-pour-les-entreprises-moins-300-salaries"
]
|
|
2.71 ms (1.79%) |
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
]
|
|
1.92 ms (1.27%) |
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
]
|
|
1.38 ms (0.91%) |
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.37 ms (0.90%) |
1 |
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.date_fin AS date_fin_3, t0.formation_id AS formation_id_4 FROM formation_date t0 WHERE t0.formation_id = ?
Parameters:
[
447
]
|
|
1.11 ms (0.73%) |
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:
[
51
]
|
|
1.06 ms (0.70%) |
1 |
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.date_fin AS date_fin_3, t0.formation_id AS formation_id_4 FROM formation_date t0 WHERE t0.id = ? AND t0.formation_id = ? LIMIT 1
Parameters:
[ "14505" 447 ] |
|
0.94 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\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. |