GET https://www.parcours-connect.cpam-du-gard.fr/public/pratique/69?parcours=52&pratique=69

Query Metrics

7 Database Queries
7 Different statements
19.15 ms Query time
0 Invalid entities
21 Managed entities

Queries

Group similar statements

# Time Info
1 2.86 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.contenu AS contenu_4, t0.position AS position_5, t0.rubrique_id AS rubrique_id_6 FROM pratique t0 WHERE t0.id = ?
Parameters:
[
  "69"
]
2 2.88 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.logo AS logo_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_online AS is_online_7, t0.couleur_id AS couleur_id_8 FROM parcours t0 WHERE t0.id = ?
Parameters:
[
  "52"
]
3 4.00 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.type AS type_3, t0.url AS url_4, t0.filename AS filename_5, t0.original_filename AS original_filename_6, t0.mime_type AS mime_type_7, t0.file_size AS file_size_8, t0.uploaded_at AS uploaded_at_9, t0.question AS question_10, t0.reponse AS reponse_11, t0.description AS description_12, t0.informations_complementaires_type AS informations_complementaires_type_13, t0.informations_complementaires_contenu AS informations_complementaires_contenu_14, t0.facturation_type AS facturation_type_15, t0.facturation_contenu AS facturation_contenu_16, t0.definition_type AS definition_type_17, t0.definition_contenu AS definition_contenu_18, t0.icone1 AS icone1_19, t0.icone2 AS icone2_20, t0.updated_at AS updated_at_21 FROM fiche_outil t0 INNER JOIN pratique_fiche_outil ON t0.id = pratique_fiche_outil.fiche_outil_id WHERE pratique_fiche_outil.pratique_id = ?
Parameters:
[
  69
]
4 1.92 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.slug AS slug_3, t0.description AS description_4, t0.contenu AS contenu_5, t0.pratique_id AS pratique_id_6, t0.etape_id AS etape_id_7 FROM fiche_outil_niv2 t0 WHERE t0.pratique_id = ?
Parameters:
[
  69
]
5 2.35 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.position AS position_4, t0.type AS type_5, t0.contenu AS contenu_6, t0.parcours_id AS parcours_id_7 FROM rubrique t0 WHERE t0.id = ?
Parameters:
[
  126
]
6 3.14 ms
SELECT r0_.id AS id_0, r0_.titre AS titre_1, r0_.description AS description_2, r0_.position AS position_3, r0_.type AS type_4, r0_.contenu AS contenu_5, p1_.id AS id_6, p1_.titre AS titre_7, p1_.description AS description_8, p1_.contenu AS contenu_9, p1_.position AS position_10, e2_.id AS id_11, e2_.titre AS titre_12, e2_.description AS description_13, e2_.contenu AS contenu_14, e2_.position AS position_15, e2_.logo AS logo_16, e2_.icon_filename AS icon_filename_17, e2_.updated_at AS updated_at_18, r0_.parcours_id AS parcours_id_19, p1_.rubrique_id AS rubrique_id_20, e2_.rubrique_id AS rubrique_id_21 FROM rubrique r0_ LEFT JOIN pratique p1_ ON r0_.id = p1_.rubrique_id LEFT JOIN etape e2_ ON r0_.id = e2_.rubrique_id WHERE r0_.parcours_id = ? ORDER BY r0_.position ASC, p1_.position ASC, e2_.position ASC
Parameters:
[
  52
]
7 2.01 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_rgb AS code_rgb_3 FROM couleur t0 WHERE t0.id = ?
Parameters:
[
  1
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Pratique 6
App\Entity\Etape 6
App\Entity\Rubrique 3
App\Entity\FicheOutil 3
App\Entity\Parcours 1
App\Entity\Couleur 1
App\Entity\FicheOutilNiv2 1

Entities Mapping

Class Mapping errors
App\Entity\FicheOutil No errors.
App\Entity\Pratique No errors.
App\Entity\Etape No errors.
App\Entity\Rubrique No errors.
App\Entity\FicheOutilNiv2 No errors.
App\Entity\Parcours No errors.
App\Entity\Couleur No errors.