GET https://a2fm-aura.test.genesii.fr/formations

Query Metrics

4 Database Queries
4 Different statements
7.97 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.06 ms
(63.46%)
1
SELECT t0_.id AS id_0, t0_.libelle AS libelle_1 FROM theme_session t0_ INNER JOIN session s1_ ON t0_.id = s1_.theme_id WHERE s1_.dateheure_debut + 3 >= ? OR s1_.dateheure_debut IS NULL ORDER BY t0_.id ASC
Parameters:
[
  "2026-01-13 06:01:09"
]
2.14 ms
(26.91%)
1
SELECT t0.id AS id_1, t0.dateheure_inscription AS dateheure_inscription_2, t0.individu_id AS individu_id_3, t0.session_id AS session_id_4, t0.statut_id AS statut_id_5 FROM stagiaire t0 WHERE t0.session_id = ?
Parameters:
[
  4
]
0.48 ms
(6.00%)
1
SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.dateheure_debut AS dateheure_debut_2, s0_.objectifs AS objectifs_3, s0_.nb_participants_max AS nb_participants_max_4, s0_.cible AS cible_5, s0_.numero_action AS numero_action_6, s0_.description AS description_7, s0_.organisme_id AS organisme_id_8, s0_.duree_id AS duree_id_9, s0_.lieu_id AS lieu_id_10, s0_.theme_id AS theme_id_11, s0_.responsable_id AS responsable_id_12 FROM session s0_ INNER JOIN theme_session t1_ ON s0_.theme_id = t1_.id ORDER BY s0_.id ASC
Parameters:
[]
0.29 ms
(3.63%)
1
SELECT t0.id AS id_1, t0.voie AS voie_2, t0.voie_suite AS voie_suite_3, t0.code_postal AS code_postal_4, t0.ville AS ville_5 FROM adresse t0 WHERE t0.id = ?
Parameters:
[
  50
]

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\ThemeSession No errors.
App\Entity\Session No errors.
App\Entity\Organisme No errors.
App\Entity\DureeSession No errors.
App\Entity\Adresse No errors.
App\Entity\Utilisateur No errors.
App\Entity\Stagiaire No errors.
App\Entity\Formateur No errors.
App\Entity\Individu No errors.
App\Entity\StatutStagiaire No errors.