GET https://admin.dieng-consulting.com/inscription?classe=&concours=&cycle=&groupe=&q=KANE&section=&statut=

Response
200 OK
Browse referrer URL
IP
2001:4278:14:f25f:4884:b2cb:2037:2d30
Profiled on
Token
3ace3a

Query Metrics

7 Database Queries
7 Different statements
4.46 ms Query time
0 Invalid entities
68 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
2.82 ms
(63.20%) 		1 
SELECT i0_.id AS id_0, i0_.reference_inscription AS reference_inscription_1, i0_.observations AS observations_2, i0_.statut AS statut_3, i0_.date_inscription AS date_inscription_4, i0_.date_validation AS date_validation_5, i0_.frais_inscription AS frais_inscription_6, i0_.exonere AS exonere_7, i0_.motif_exoneration AS motif_exoneration_8, i0_.created_at AS created_at_9, i0_.updated_at AS updated_at_10, i0_.deleted_at AS deleted_at_11, e1_.id AS id_12, e1_.prenom AS prenom_13, e1_.nom AS nom_14, e1_.numero_matricule AS numero_matricule_15, e1_.sexe AS sexe_16, e1_.date_naissance AS date_naissance_17, e1_.lieu_naissance AS lieu_naissance_18, e1_.nationalite AS nationalite_19, e1_.telephone AS telephone_20, e1_.email AS email_21, e1_.adresse AS adresse_22, e1_.responsable AS responsable_23, e1_.telephone_responsable AS telephone_responsable_24, e1_.telephone_secondaire AS telephone_secondaire_25, e1_.profession AS profession_26, e1_.photo AS photo_27, e1_.lieu_urgence AS lieu_urgence_28, e1_.observations AS observations_29, e1_.statut AS statut_30, e1_.created_at AS created_at_31, e1_.updated_at AS updated_at_32, e1_.deleted_at AS deleted_at_33, c2_.id AS id_34, c2_.nom AS nom_35, c2_.description AS description_36, c2_.avec_cycles AS avec_cycles_37, c2_.avec_sections AS avec_sections_38, c2_.frais_inscription_defaut AS frais_inscription_defaut_39, c2_.mensualite_reference AS mensualite_reference_40, c2_.active AS active_41, c2_.created_at AS created_at_42, c2_.updated_at AS updated_at_43, c2_.deleted_at AS deleted_at_44, c3_.id AS id_45, c3_.nom AS nom_46, c3_.description AS description_47, c3_.ordre AS ordre_48, c3_.active AS active_49, c3_.created_at AS created_at_50, c3_.updated_at AS updated_at_51, c3_.deleted_at AS deleted_at_52, s4_.id AS id_53, s4_.nom AS nom_54, s4_.description AS description_55, s4_.ordre AS ordre_56, s4_.active AS active_57, s4_.created_at AS created_at_58, s4_.updated_at AS updated_at_59, s4_.deleted_at AS deleted_at_60, c5_.id AS id_61, c5_.nom AS nom_62, c5_.description AS description_63, c5_.ordre AS ordre_64, c5_.active AS active_65, c5_.created_at AS created_at_66, c5_.updated_at AS updated_at_67, c5_.deleted_at AS deleted_at_68, g6_.id AS id_69, g6_.nom AS nom_70, g6_.description AS description_71, g6_.code AS code_72, g6_.effectif_max AS effectif_max_73, g6_.active AS active_74, g6_.salle AS salle_75, g6_.created_at AS created_at_76, g6_.updated_at AS updated_at_77, g6_.deleted_at AS deleted_at_78, u7_.id AS id_79, u7_.email AS email_80, u7_.roles AS roles_81, u7_.password AS password_82, u7_.enabled AS enabled_83, u7_.first_name AS first_name_84, u7_.last_name AS last_name_85, u7_.phone AS phone_86, u7_.last_login_at AS last_login_at_87, u7_.created_at AS created_at_88, u7_.updated_at AS updated_at_89, u7_.deleted_at AS deleted_at_90, i0_.eleve_id AS eleve_id_91, i0_.concours_id AS concours_id_92, i0_.cycle_id AS cycle_id_93, i0_.section_id AS section_id_94, i0_.classe_id AS classe_id_95, i0_.groupe_id AS groupe_id_96, i0_.agent_id AS agent_id_97, e1_.groupe_id AS groupe_id_98, c3_.concours_id AS concours_id_99, s4_.cycle_id AS cycle_id_100, c5_.concours_id AS concours_id_101, g6_.referent_id AS referent_id_102, g6_.classe_id AS classe_id_103 FROM inscription i0_ LEFT JOIN eleve e1_ ON i0_.eleve_id = e1_.id LEFT JOIN concours c2_ ON i0_.concours_id = c2_.id LEFT JOIN cycle c3_ ON i0_.cycle_id = c3_.id LEFT JOIN section s4_ ON i0_.section_id = s4_.id LEFT JOIN classe c5_ ON i0_.classe_id = c5_.id LEFT JOIN groupe g6_ ON i0_.groupe_id = g6_.id LEFT JOIN `user` u7_ ON i0_.agent_id = u7_.id WHERE i0_.deleted_at IS NULL AND (e1_.prenom LIKE ? OR e1_.nom LIKE ? OR i0_.reference_inscription LIKE ?) ORDER BY c2_.nom ASC, e1_.nom ASC, e1_.prenom ASC
Parameters: 
[
  "%KANE%"
  "%KANE%"
  "%KANE%"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(7.36%) 		1 
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: 
[
  5
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(6.59%) 		1 
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.description AS description_2, c0_.avec_cycles AS avec_cycles_3, c0_.avec_sections AS avec_sections_4, c0_.frais_inscription_defaut AS frais_inscription_defaut_5, c0_.mensualite_reference AS mensualite_reference_6, c0_.active AS active_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.deleted_at AS deleted_at_10 FROM concours c0_ WHERE c0_.deleted_at IS NULL ORDER BY c0_.nom ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(5.90%) 		1 
SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.description AS description_2, s0_.ordre AS ordre_3, s0_.active AS active_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.deleted_at AS deleted_at_7, s0_.cycle_id AS cycle_id_8 FROM section s0_ WHERE s0_.deleted_at IS NULL ORDER BY s0_.nom ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(5.78%) 		1 
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_ WHERE g0_.deleted_at IS NULL AND g0_.active = 1 ORDER BY g0_.nom ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.25 ms
(5.68%) 		1 
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.description AS description_2, c0_.ordre AS ordre_3, c0_.active AS active_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.concours_id AS concours_id_8 FROM cycle c0_ WHERE c0_.deleted_at IS NULL ORDER BY c0_.nom ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(5.49%) 		1 
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.description AS description_2, c0_.ordre AS ordre_3, c0_.active AS active_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.concours_id AS concours_id_8 FROM classe c0_ WHERE c0_.deleted_at IS NULL ORDER BY c0_.nom ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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\Cycle 24
App\Entity\Section 13
App\Entity\Groupe 10
App\Entity\Concours 8
App\Entity\Classe 5
App\Entity\Inscription 3
App\Entity\Eleve 3
App\Entity\User 2

Entities Mapping

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