https://iaa-tunisie.tn/releve?id=644

Method
GET
HTTP Status
200
IP
197.0.205.251
Profiled on
Token
b800f6

Query Metrics

53 Database Queries
7 Different statements
14.64 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.42 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.reset_password_token AS reset_password_token_5, t0.civilite AS civilite_6, t0.cin AS cin_7, t0.nom AS nom_8, t0.prenom AS prenom_9, t0.date_naissance AS date_naissance_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.tel AS tel_14, t0.fax AS fax_15, t0.etat_activation AS etat_activation_16, t0.niveau AS niveau_17, t0.specialite AS specialite_18, t0.experience AS experience_19, t0.type AS type_20, t0.diplome AS diplome_21, t0.institution AS institution_22, t0.poste AS poste_23, t0.nationnalite AS nationnalite_24, t0.cv AS cv_25, t0.photo_de_profil AS photo_de_profil_26, t0.updated_at AS updated_at_27, t0.email AS email_28, t0.organization_id AS organization_id_29 FROM `user` t0 WHERE t0.id = ?
Parameters: 
[
  644
]
View formatted query    View runnable query    Explain query
2 0.23 ms 
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.attestation AS attestation_3, t0.groupe AS groupe_4, t0.candidat_id AS candidat_id_5, t0.cycle_id AS cycle_id_6, t0.session_id AS session_id_7 FROM inscription t0 WHERE t0.candidat_id = ?
Parameters: 
[
  644
]
View formatted query    View runnable query    Explain query
3 0.23 ms 
SELECT t0.id AS id_1, t0.note AS note_2, t0.inscription_id AS inscription_id_3, t0.module_id AS module_id_4 FROM inscription_module t0 WHERE t0.inscription_id = ?
Parameters: 
[
  293
]
View formatted query    View runnable query    Explain query
4 0.47 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  1
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
5 0.16 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
6 0.36 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  2
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
7 0.17 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
8 0.36 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  4
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
9 0.18 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
10 0.41 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  5
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
11 0.18 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
12 0.33 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  6
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
13 0.15 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query
14 0.51 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  7
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
15 0.21 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  7
]
View formatted query    View runnable query    Explain query
16 0.52 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  8
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
17 0.19 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query
18 0.31 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  9
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
19 0.15 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query
20 0.40 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  10
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
21 0.15 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
22 0.37 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  11
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
23 0.15 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query
24 0.48 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  12
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
25 0.19 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  12
]
View formatted query    View runnable query    Explain query
26 0.32 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  13
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
27 0.17 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query
28 0.34 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  14
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
29 0.14 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  14
]
View formatted query    View runnable query    Explain query
30 0.39 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  15
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
31 0.14 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query
32 0.43 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  16
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
33 0.22 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query
34 0.37 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  17
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
35 0.18 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query
36 0.33 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  18
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
37 0.18 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  18
]
View formatted query    View runnable query    Explain query
38 0.33 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  19
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
39 0.16 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  19
]
View formatted query    View runnable query    Explain query
40 0.31 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  20
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
41 0.20 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  20
]
View formatted query    View runnable query    Explain query
42 0.43 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  21
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
43 0.15 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  21
]
View formatted query    View runnable query    Explain query
44 0.37 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  22
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
45 0.17 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  22
]
View formatted query    View runnable query    Explain query
46 0.33 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  23
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
47 0.17 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  23
]
View formatted query    View runnable query    Explain query
48 0.32 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  24
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
49 0.17 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  24
]
View formatted query    View runnable query    Explain query
50 0.40 ms 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters: 
[
  25
  5
  3
  "3"
]
View formatted query    View runnable query    Explain query
51 0.23 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters: 
[
  25
]
View formatted query    View runnable query    Explain query
52 0.22 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.tarif_particulier AS tarif_particulier_3, t0.tarif_entreprise AS tarif_entreprise_4, t0.tarif_etrange AS tarif_etrange_5, t0.etat AS etat_6, t0.exchange_rate AS exchange_rate_7, t0.vat_rate AS vat_rate_8 FROM session t0 WHERE t0.id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
53 0.16 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.date_debut AS date_debut_3, t0.etat AS etat_4 FROM cycle t0 WHERE t0.id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query

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\User No errors.
App\Entity\Organization No errors.
App\Entity\Engagement No errors.
App\Entity\Inscription No errors.
App\Entity\Certificat No errors.
App\Entity\ServiceUsage No errors.
App\Entity\Cycle No errors.
App\Entity\Session No errors.
App\Entity\FactureCandidat No errors.
App\Entity\InscriptionModule No errors.
App\Entity\Module No errors.