GET https://admin.dieng-consulting.com/groupe

Query Metrics

18 Database Queries
6 Different statements
5.33 ms Query time
0 Invalid entities
347 Managed entities

Queries

Group similar statements

# Time Info
1 0.38 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.last_login_at AS last_login_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.32 ms
SELECT count(DISTINCT g0_.id) AS sclr_0 FROM groupe g0_ LEFT JOIN classe c1_ ON g0_.classe_id = c1_.id WHERE g0_.deleted_at IS NULL
Parameters:
[]
3 0.25 ms
SELECT DISTINCT g0_.id AS id_0, g0_.created_at AS created_at_1 FROM groupe g0_ LEFT JOIN classe c1_ ON g0_.classe_id = c1_.id WHERE g0_.deleted_at IS NULL ORDER BY g0_.created_at DESC LIMIT 20
Parameters:
[]
4 0.32 ms
SELECT g0_.id AS id_0, g0_.nom AS nom_1, g0_.description AS description_2, g0_.code AS code_3, g0_.effectif_max AS effectif_max_4, g0_.active AS active_5, g0_.salle AS salle_6, g0_.created_at AS created_at_7, g0_.updated_at AS updated_at_8, g0_.deleted_at AS deleted_at_9, g0_.referent_id AS referent_id_10, g0_.classe_id AS classe_id_11 FROM groupe g0_ LEFT JOIN classe c1_ ON g0_.classe_id = c1_.id WHERE g0_.deleted_at IS NULL AND g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY g0_.created_at DESC
Parameters:
[
  9
  8
  7
  6
  5
  4
  3
  2
  1
]
5 0.44 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.ordre AS ordre_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.concours_id AS concours_id_9 FROM classe t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.40 ms
SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_id = ?
Parameters:
[
  9
]
7 0.41 ms
SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_id = ?
Parameters:
[
  8
]
8 0.33 ms
SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_id = ?
Parameters:
[
  7
]
9 0.20 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.ordre AS ordre_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.concours_id AS concours_id_9 FROM classe t0 WHERE t0.id = ?
Parameters:
[
  5
]
10 0.20 ms
SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_id = ?
Parameters:
[
  6
]
11 0.23 ms
SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_id = ?
Parameters:
[
  5
]
12 0.19 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.ordre AS ordre_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.concours_id AS concours_id_9 FROM classe t0 WHERE t0.id = ?
Parameters:
[
  2
]
13 0.27 ms
SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_id = ?
Parameters:
[
  4
]
14 0.22 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.ordre AS ordre_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.concours_id AS concours_id_9 FROM classe t0 WHERE t0.id = ?
Parameters:
[
  4
]
15 0.32 ms
SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_id = ?
Parameters:
[
  3
]
16 0.24 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.ordre AS ordre_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.concours_id AS concours_id_9 FROM classe t0 WHERE t0.id = ?
Parameters:
[
  3
]
17 0.27 ms
SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_id = ?
Parameters:
[
  2
]
18 0.32 ms
SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_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\Inscription 161
App\Entity\Eleve 160
App\Entity\Groupe 9
App\Entity\Cycle 6
App\Entity\Classe 5
App\Entity\Concours 3
App\Entity\Section 2
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Groupe No errors.
App\Entity\Classe No errors.
App\Entity\Eleve No errors.
App\Entity\Inscription No errors.
App\Entity\Concours No errors.
App\Entity\Cycle No errors.
App\Entity\Section No errors.