https://www.ama64.fr/formations/afficher/convocations/67

Query Metrics

66 Database Queries
15 Different statements
13.39 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 1.05 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.organisation AS organisation_7, t0.etat AS etat_8 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  68
]
2 0.20 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.etat AS etat_5, t0.heure_convoc1er_jour AS heure_convoc1er_jour_6, t0.site_id AS site_id_7, t0.bloc_id AS bloc_id_8, t0.referent_id AS referent_id_9, t0.formateur_referent_id AS formateur_referent_id_10, t0.cfc_id AS cfc_id_11, t0.assistant_id AS assistant_id_12, t0.proviseurs_id AS proviseurs_id_13 FROM formations t0 WHERE t0.id = ?
Parameters:
[
  "67"
]
3 0.17 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.colors AS colors_3 FROM formations_etats t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 0.09 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.colors AS colors_3 FROM convocations_etats t0
Parameters:
[]
5 0.10 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.colors AS colors_3 FROM convocations_reponses t0
Parameters:
[]
6 0.92 ms
SELECT c0_.id AS id_0, c0_.date_convoc AS date_convoc_1, c0_.date_expiration AS date_expiration_2, c0_.etat AS etat_3, c0_.observations AS observations_4, c0_.date_creation AS date_creation_5, c0_.reponse_precision AS reponse_precision_6, c0_.date_reponse AS date_reponse_7, c0_.date_traitement_reponse AS date_traitement_reponse_8, c0_.observations_reponse AS observations_reponse_9, c0_.bulletin_reponse_scan AS bulletin_reponse_scan_10, c0_.fin_convocation AS fin_convocation_11, c0_.stagiaire_id AS stagiaire_id_12, c0_.formation_id AS formation_id_13, c0_.reponse_id AS reponse_id_14 FROM convocations c0_ LEFT JOIN formations f1_ ON c0_.formation_id = f1_.id WHERE f1_.id = ? AND c0_.etat = 1
Parameters:
[
  "67"
]
7 0.18 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.domaine AS domaine_3, t0.duree AS duree_4, t0.etat AS etat_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.matin_horaire_debut AS matin_horaire_debut_8, t0.matin_horaire_fin AS matin_horaire_fin_9, t0.apres_midi_horaire_debut AS apres_midi_horaire_debut_10, t0.apres_midi_horaire_fin AS apres_midi_horaire_fin_11, t0.duree_non_compta AS duree_non_compta_12, t0.facultatif AS facultatif_13, t0.validation_presences AS validation_presences_14, t0.demi_journee AS demi_journee_15, t0.psc1_groupe1 AS psc1_groupe1_16, t0.psc1_groupe2 AS psc1_groupe2_17, t0.blocs_id AS blocs_id_18, t0.formation_id AS formation_id_19, t0.formateur_id AS formateur_id_20, t0.salle_id AS salle_id_21 FROM plannings_formations t0 WHERE t0.formation_id = ?
Parameters:
[
  67
]
8 1.53 ms
SELECT c0_.id AS id_0, c0_.date_convoc AS date_convoc_1, c0_.date_expiration AS date_expiration_2, c0_.etat AS etat_3, c0_.observations AS observations_4, c0_.date_creation AS date_creation_5, c0_.reponse_precision AS reponse_precision_6, c0_.date_reponse AS date_reponse_7, c0_.date_traitement_reponse AS date_traitement_reponse_8, c0_.observations_reponse AS observations_reponse_9, c0_.bulletin_reponse_scan AS bulletin_reponse_scan_10, c0_.fin_convocation AS fin_convocation_11, c0_.stagiaire_id AS stagiaire_id_12, c0_.formation_id AS formation_id_13, c0_.reponse_id AS reponse_id_14 FROM convocations c0_ LEFT JOIN stagiaires s1_ ON c0_.stagiaire_id = s1_.id LEFT JOIN formations f2_ ON c0_.formation_id = f2_.id WHERE f2_.id = ? ORDER BY s1_.nom ASC
Parameters:
[
  "67"
]
9 0.11 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.nbre_heures AS nbre_heures_3, t0.etat AS etat_4, t0.num_bloc AS num_bloc_5 FROM blocs t0 WHERE t0.id = ?
Parameters:
[
  53
]
10 0.11 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.convocations_id AS convocations_id_6 FROM stagiaires_reports t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  643
  1
]
11 0.11 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.formations_id AS formations_id_6 FROM stagiaires_absences t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  643
  1
]
12 0.10 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.convocations_id AS convocations_id_6 FROM stagiaires_reports t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  759
  1
]
13 0.09 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.formations_id AS formations_id_6 FROM stagiaires_absences t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  759
  1
]
14 0.07 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.convocations_id AS convocations_id_6 FROM stagiaires_reports t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  760
  1
]
15 0.06 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.formations_id AS formations_id_6 FROM stagiaires_absences t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  760
  1
]
16 0.06 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.convocations_id AS convocations_id_6 FROM stagiaires_reports t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  690
  1
]
17 0.07 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.formations_id AS formations_id_6 FROM stagiaires_absences t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  690
  1
]
18 0.06 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.convocations_id AS convocations_id_6 FROM stagiaires_reports t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  762
  1
]
19 0.08 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.formations_id AS formations_id_6 FROM stagiaires_absences t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  762
  1
]
20 0.07 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.convocations_id AS convocations_id_6 FROM stagiaires_reports t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  763
  1
]
21 0.09 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.formations_id AS formations_id_6 FROM stagiaires_absences t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  763
  1
]
22 0.06 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.convocations_id AS convocations_id_6 FROM stagiaires_reports t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  764
  1
]
23 0.09 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.formations_id AS formations_id_6 FROM stagiaires_absences t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  764
  1
]
24 0.07 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.convocations_id AS convocations_id_6 FROM stagiaires_reports t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  765
  1
]
25 0.08 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.formations_id AS formations_id_6 FROM stagiaires_absences t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  765
  1
]
26 0.08 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.convocations_id AS convocations_id_6 FROM stagiaires_reports t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  766
  1
]
27 0.06 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.formations_id AS formations_id_6 FROM stagiaires_absences t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  766
  1
]
28 0.08 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.convocations_id AS convocations_id_6 FROM stagiaires_reports t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  767
  1
]
29 0.06 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.formations_id AS formations_id_6 FROM stagiaires_absences t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  767
  1
]
30 0.06 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.convocations_id AS convocations_id_6 FROM stagiaires_reports t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  768
  1
]
31 0.08 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.formations_id AS formations_id_6 FROM stagiaires_absences t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  768
  1
]
32 0.07 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.convocations_id AS convocations_id_6 FROM stagiaires_reports t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  769
  1
]
33 0.06 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.formations_id AS formations_id_6 FROM stagiaires_absences t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  769
  1
]
34 0.06 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.convocations_id AS convocations_id_6 FROM stagiaires_reports t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  770
  1
]
35 0.06 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.formations_id AS formations_id_6 FROM stagiaires_absences t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  770
  1
]
36 0.07 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.convocations_id AS convocations_id_6 FROM stagiaires_reports t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  771
  1
]
37 0.08 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.formations_id AS formations_id_6 FROM stagiaires_absences t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  771
  1
]
38 0.12 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.convocations_id AS convocations_id_6 FROM stagiaires_reports t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  775
  1
]
39 0.09 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.formations_id AS formations_id_6 FROM stagiaires_absences t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  775
  1
]
40 0.07 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.convocations_id AS convocations_id_6 FROM stagiaires_reports t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  773
  1
]
41 0.07 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.formations_id AS formations_id_6 FROM stagiaires_absences t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  773
  1
]
42 0.07 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.convocations_id AS convocations_id_6 FROM stagiaires_reports t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  774
  1
]
43 0.06 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.formations_id AS formations_id_6 FROM stagiaires_absences t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  774
  1
]
44 0.08 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.convocations_id AS convocations_id_6 FROM stagiaires_reports t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  772
  1
]
45 0.07 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.num_bloc AS num_bloc_4, t0.stagiaires_id AS stagiaires_id_5, t0.formations_id AS formations_id_6 FROM stagiaires_absences t0 WHERE t0.stagiaires_id = ? AND t0.num_bloc = ?
Parameters:
[
  772
  1
]
46 0.85 ms
SELECT c0_.id AS id_0, c0_.date_convoc AS date_convoc_1, c0_.date_expiration AS date_expiration_2, c0_.etat AS etat_3, c0_.observations AS observations_4, c0_.date_creation AS date_creation_5, c0_.reponse_precision AS reponse_precision_6, c0_.date_reponse AS date_reponse_7, c0_.date_traitement_reponse AS date_traitement_reponse_8, c0_.observations_reponse AS observations_reponse_9, c0_.bulletin_reponse_scan AS bulletin_reponse_scan_10, c0_.fin_convocation AS fin_convocation_11, c0_.stagiaire_id AS stagiaire_id_12, c0_.formation_id AS formation_id_13, c0_.reponse_id AS reponse_id_14 FROM convocations c0_ INNER JOIN formations f1_ ON c0_.formation_id = f1_.id WHERE f1_.id = 67 AND c0_.etat = 1 AND c0_.reponse_id IS NULL
Parameters:
[]
47 1.00 ms
SELECT t0.id AS id_1, t0.date_convoc AS date_convoc_2, t0.date_expiration AS date_expiration_3, t0.etat AS etat_4, t0.observations AS observations_5, t0.date_creation AS date_creation_6, t0.reponse_precision AS reponse_precision_7, t0.date_reponse AS date_reponse_8, t0.date_traitement_reponse AS date_traitement_reponse_9, t0.observations_reponse AS observations_reponse_10, t0.bulletin_reponse_scan AS bulletin_reponse_scan_11, t0.fin_convocation AS fin_convocation_12, t0.stagiaire_id AS stagiaire_id_13, t0.formation_id AS formation_id_14, t0.reponse_id AS reponse_id_15 FROM convocations t0 WHERE t0.formation_id = ?
Parameters:
[
  67
]
48 0.41 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.etat AS etat_3, t0.formations_id AS formations_id_4, t0.stagiaires_id AS stagiaires_id_5 FROM inscriptions_formations t0 WHERE t0.formations_id = ?
Parameters:
[
  67
]
49 0.39 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.adresse1 AS adresse1_5, t0.adresse2 AS adresse2_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.etat AS etat_9, t0.date_creation AS date_creation_10, t0.agrement_num AS agrement_num_11, t0.domaine AS domaine_12, t0.diplome1 AS diplome1_13, t0.diplome2 AS diplome2_14, t0.diplome3 AS diplome3_15, t0.telephone AS telephone_16, t0.dispense_domaine1 AS dispense_domaine1_17, t0.dispense_domaine2 AS dispense_domaine2_18, t0.dispense_domaine3 AS dispense_domaine3_19, t0.agrement_date_fin AS agrement_date_fin_20, t0.accueil240h AS accueil240h_21, t0.agence_id AS agence_id_22 FROM stagiaires t0 WHERE t0.id = ?
Parameters:
[
  643
]
50 0.30 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.adresse1 AS adresse1_5, t0.adresse2 AS adresse2_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.etat AS etat_9, t0.date_creation AS date_creation_10, t0.agrement_num AS agrement_num_11, t0.domaine AS domaine_12, t0.diplome1 AS diplome1_13, t0.diplome2 AS diplome2_14, t0.diplome3 AS diplome3_15, t0.telephone AS telephone_16, t0.dispense_domaine1 AS dispense_domaine1_17, t0.dispense_domaine2 AS dispense_domaine2_18, t0.dispense_domaine3 AS dispense_domaine3_19, t0.agrement_date_fin AS agrement_date_fin_20, t0.accueil240h AS accueil240h_21, t0.agence_id AS agence_id_22 FROM stagiaires t0 WHERE t0.id = ?
Parameters:
[
  759
]
51 0.21 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.adresse1 AS adresse1_5, t0.adresse2 AS adresse2_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.etat AS etat_9, t0.date_creation AS date_creation_10, t0.agrement_num AS agrement_num_11, t0.domaine AS domaine_12, t0.diplome1 AS diplome1_13, t0.diplome2 AS diplome2_14, t0.diplome3 AS diplome3_15, t0.telephone AS telephone_16, t0.dispense_domaine1 AS dispense_domaine1_17, t0.dispense_domaine2 AS dispense_domaine2_18, t0.dispense_domaine3 AS dispense_domaine3_19, t0.agrement_date_fin AS agrement_date_fin_20, t0.accueil240h AS accueil240h_21, t0.agence_id AS agence_id_22 FROM stagiaires t0 WHERE t0.id = ?
Parameters:
[
  760
]
52 0.23 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.adresse1 AS adresse1_5, t0.adresse2 AS adresse2_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.etat AS etat_9, t0.date_creation AS date_creation_10, t0.agrement_num AS agrement_num_11, t0.domaine AS domaine_12, t0.diplome1 AS diplome1_13, t0.diplome2 AS diplome2_14, t0.diplome3 AS diplome3_15, t0.telephone AS telephone_16, t0.dispense_domaine1 AS dispense_domaine1_17, t0.dispense_domaine2 AS dispense_domaine2_18, t0.dispense_domaine3 AS dispense_domaine3_19, t0.agrement_date_fin AS agrement_date_fin_20, t0.accueil240h AS accueil240h_21, t0.agence_id AS agence_id_22 FROM stagiaires t0 WHERE t0.id = ?
Parameters:
[
  690
]
53 0.40 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.adresse1 AS adresse1_5, t0.adresse2 AS adresse2_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.etat AS etat_9, t0.date_creation AS date_creation_10, t0.agrement_num AS agrement_num_11, t0.domaine AS domaine_12, t0.diplome1 AS diplome1_13, t0.diplome2 AS diplome2_14, t0.diplome3 AS diplome3_15, t0.telephone AS telephone_16, t0.dispense_domaine1 AS dispense_domaine1_17, t0.dispense_domaine2 AS dispense_domaine2_18, t0.dispense_domaine3 AS dispense_domaine3_19, t0.agrement_date_fin AS agrement_date_fin_20, t0.accueil240h AS accueil240h_21, t0.agence_id AS agence_id_22 FROM stagiaires t0 WHERE t0.id = ?
Parameters:
[
  762
]
54 0.25 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.adresse1 AS adresse1_5, t0.adresse2 AS adresse2_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.etat AS etat_9, t0.date_creation AS date_creation_10, t0.agrement_num AS agrement_num_11, t0.domaine AS domaine_12, t0.diplome1 AS diplome1_13, t0.diplome2 AS diplome2_14, t0.diplome3 AS diplome3_15, t0.telephone AS telephone_16, t0.dispense_domaine1 AS dispense_domaine1_17, t0.dispense_domaine2 AS dispense_domaine2_18, t0.dispense_domaine3 AS dispense_domaine3_19, t0.agrement_date_fin AS agrement_date_fin_20, t0.accueil240h AS accueil240h_21, t0.agence_id AS agence_id_22 FROM stagiaires t0 WHERE t0.id = ?
Parameters:
[
  763
]
55 0.20 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.adresse1 AS adresse1_5, t0.adresse2 AS adresse2_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.etat AS etat_9, t0.date_creation AS date_creation_10, t0.agrement_num AS agrement_num_11, t0.domaine AS domaine_12, t0.diplome1 AS diplome1_13, t0.diplome2 AS diplome2_14, t0.diplome3 AS diplome3_15, t0.telephone AS telephone_16, t0.dispense_domaine1 AS dispense_domaine1_17, t0.dispense_domaine2 AS dispense_domaine2_18, t0.dispense_domaine3 AS dispense_domaine3_19, t0.agrement_date_fin AS agrement_date_fin_20, t0.accueil240h AS accueil240h_21, t0.agence_id AS agence_id_22 FROM stagiaires t0 WHERE t0.id = ?
Parameters:
[
  764
]
56 0.19 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.adresse1 AS adresse1_5, t0.adresse2 AS adresse2_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.etat AS etat_9, t0.date_creation AS date_creation_10, t0.agrement_num AS agrement_num_11, t0.domaine AS domaine_12, t0.diplome1 AS diplome1_13, t0.diplome2 AS diplome2_14, t0.diplome3 AS diplome3_15, t0.telephone AS telephone_16, t0.dispense_domaine1 AS dispense_domaine1_17, t0.dispense_domaine2 AS dispense_domaine2_18, t0.dispense_domaine3 AS dispense_domaine3_19, t0.agrement_date_fin AS agrement_date_fin_20, t0.accueil240h AS accueil240h_21, t0.agence_id AS agence_id_22 FROM stagiaires t0 WHERE t0.id = ?
Parameters:
[
  765
]
57 0.19 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.adresse1 AS adresse1_5, t0.adresse2 AS adresse2_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.etat AS etat_9, t0.date_creation AS date_creation_10, t0.agrement_num AS agrement_num_11, t0.domaine AS domaine_12, t0.diplome1 AS diplome1_13, t0.diplome2 AS diplome2_14, t0.diplome3 AS diplome3_15, t0.telephone AS telephone_16, t0.dispense_domaine1 AS dispense_domaine1_17, t0.dispense_domaine2 AS dispense_domaine2_18, t0.dispense_domaine3 AS dispense_domaine3_19, t0.agrement_date_fin AS agrement_date_fin_20, t0.accueil240h AS accueil240h_21, t0.agence_id AS agence_id_22 FROM stagiaires t0 WHERE t0.id = ?
Parameters:
[
  766
]
58 0.27 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.adresse1 AS adresse1_5, t0.adresse2 AS adresse2_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.etat AS etat_9, t0.date_creation AS date_creation_10, t0.agrement_num AS agrement_num_11, t0.domaine AS domaine_12, t0.diplome1 AS diplome1_13, t0.diplome2 AS diplome2_14, t0.diplome3 AS diplome3_15, t0.telephone AS telephone_16, t0.dispense_domaine1 AS dispense_domaine1_17, t0.dispense_domaine2 AS dispense_domaine2_18, t0.dispense_domaine3 AS dispense_domaine3_19, t0.agrement_date_fin AS agrement_date_fin_20, t0.accueil240h AS accueil240h_21, t0.agence_id AS agence_id_22 FROM stagiaires t0 WHERE t0.id = ?
Parameters:
[
  767
]
59 0.23 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.adresse1 AS adresse1_5, t0.adresse2 AS adresse2_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.etat AS etat_9, t0.date_creation AS date_creation_10, t0.agrement_num AS agrement_num_11, t0.domaine AS domaine_12, t0.diplome1 AS diplome1_13, t0.diplome2 AS diplome2_14, t0.diplome3 AS diplome3_15, t0.telephone AS telephone_16, t0.dispense_domaine1 AS dispense_domaine1_17, t0.dispense_domaine2 AS dispense_domaine2_18, t0.dispense_domaine3 AS dispense_domaine3_19, t0.agrement_date_fin AS agrement_date_fin_20, t0.accueil240h AS accueil240h_21, t0.agence_id AS agence_id_22 FROM stagiaires t0 WHERE t0.id = ?
Parameters:
[
  768
]
60 0.15 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.adresse1 AS adresse1_5, t0.adresse2 AS adresse2_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.etat AS etat_9, t0.date_creation AS date_creation_10, t0.agrement_num AS agrement_num_11, t0.domaine AS domaine_12, t0.diplome1 AS diplome1_13, t0.diplome2 AS diplome2_14, t0.diplome3 AS diplome3_15, t0.telephone AS telephone_16, t0.dispense_domaine1 AS dispense_domaine1_17, t0.dispense_domaine2 AS dispense_domaine2_18, t0.dispense_domaine3 AS dispense_domaine3_19, t0.agrement_date_fin AS agrement_date_fin_20, t0.accueil240h AS accueil240h_21, t0.agence_id AS agence_id_22 FROM stagiaires t0 WHERE t0.id = ?
Parameters:
[
  769
]
61 0.28 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.adresse1 AS adresse1_5, t0.adresse2 AS adresse2_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.etat AS etat_9, t0.date_creation AS date_creation_10, t0.agrement_num AS agrement_num_11, t0.domaine AS domaine_12, t0.diplome1 AS diplome1_13, t0.diplome2 AS diplome2_14, t0.diplome3 AS diplome3_15, t0.telephone AS telephone_16, t0.dispense_domaine1 AS dispense_domaine1_17, t0.dispense_domaine2 AS dispense_domaine2_18, t0.dispense_domaine3 AS dispense_domaine3_19, t0.agrement_date_fin AS agrement_date_fin_20, t0.accueil240h AS accueil240h_21, t0.agence_id AS agence_id_22 FROM stagiaires t0 WHERE t0.id = ?
Parameters:
[
  770
]
62 0.18 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.adresse1 AS adresse1_5, t0.adresse2 AS adresse2_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.etat AS etat_9, t0.date_creation AS date_creation_10, t0.agrement_num AS agrement_num_11, t0.domaine AS domaine_12, t0.diplome1 AS diplome1_13, t0.diplome2 AS diplome2_14, t0.diplome3 AS diplome3_15, t0.telephone AS telephone_16, t0.dispense_domaine1 AS dispense_domaine1_17, t0.dispense_domaine2 AS dispense_domaine2_18, t0.dispense_domaine3 AS dispense_domaine3_19, t0.agrement_date_fin AS agrement_date_fin_20, t0.accueil240h AS accueil240h_21, t0.agence_id AS agence_id_22 FROM stagiaires t0 WHERE t0.id = ?
Parameters:
[
  771
]
63 0.13 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.adresse1 AS adresse1_5, t0.adresse2 AS adresse2_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.etat AS etat_9, t0.date_creation AS date_creation_10, t0.agrement_num AS agrement_num_11, t0.domaine AS domaine_12, t0.diplome1 AS diplome1_13, t0.diplome2 AS diplome2_14, t0.diplome3 AS diplome3_15, t0.telephone AS telephone_16, t0.dispense_domaine1 AS dispense_domaine1_17, t0.dispense_domaine2 AS dispense_domaine2_18, t0.dispense_domaine3 AS dispense_domaine3_19, t0.agrement_date_fin AS agrement_date_fin_20, t0.accueil240h AS accueil240h_21, t0.agence_id AS agence_id_22 FROM stagiaires t0 WHERE t0.id = ?
Parameters:
[
  775
]
64 0.18 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.adresse1 AS adresse1_5, t0.adresse2 AS adresse2_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.etat AS etat_9, t0.date_creation AS date_creation_10, t0.agrement_num AS agrement_num_11, t0.domaine AS domaine_12, t0.diplome1 AS diplome1_13, t0.diplome2 AS diplome2_14, t0.diplome3 AS diplome3_15, t0.telephone AS telephone_16, t0.dispense_domaine1 AS dispense_domaine1_17, t0.dispense_domaine2 AS dispense_domaine2_18, t0.dispense_domaine3 AS dispense_domaine3_19, t0.agrement_date_fin AS agrement_date_fin_20, t0.accueil240h AS accueil240h_21, t0.agence_id AS agence_id_22 FROM stagiaires t0 WHERE t0.id = ?
Parameters:
[
  773
]
65 0.15 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.adresse1 AS adresse1_5, t0.adresse2 AS adresse2_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.etat AS etat_9, t0.date_creation AS date_creation_10, t0.agrement_num AS agrement_num_11, t0.domaine AS domaine_12, t0.diplome1 AS diplome1_13, t0.diplome2 AS diplome2_14, t0.diplome3 AS diplome3_15, t0.telephone AS telephone_16, t0.dispense_domaine1 AS dispense_domaine1_17, t0.dispense_domaine2 AS dispense_domaine2_18, t0.dispense_domaine3 AS dispense_domaine3_19, t0.agrement_date_fin AS agrement_date_fin_20, t0.accueil240h AS accueil240h_21, t0.agence_id AS agence_id_22 FROM stagiaires t0 WHERE t0.id = ?
Parameters:
[
  774
]
66 0.14 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.adresse1 AS adresse1_5, t0.adresse2 AS adresse2_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.etat AS etat_9, t0.date_creation AS date_creation_10, t0.agrement_num AS agrement_num_11, t0.domaine AS domaine_12, t0.diplome1 AS diplome1_13, t0.diplome2 AS diplome2_14, t0.diplome3 AS diplome3_15, t0.telephone AS telephone_16, t0.dispense_domaine1 AS dispense_domaine1_17, t0.dispense_domaine2 AS dispense_domaine2_18, t0.dispense_domaine3 AS dispense_domaine3_19, t0.agrement_date_fin AS agrement_date_fin_20, t0.accueil240h AS accueil240h_21, t0.agence_id AS agence_id_22 FROM stagiaires t0 WHERE t0.id = ?
Parameters:
[
  772
]

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\Sites No errors.
App\Entity\Formations No errors.
App\Entity\Convocations No errors.
App\Entity\FormationsEtats No errors.
App\Entity\ConvocationsEtats No errors.
App\Entity\StagiairesReports No errors.
App\Entity\StagiairesAbsences No errors.
App\Entity\ConvocationsReponses No errors.
App\Entity\Blocs No errors.
App\Entity\Formateurs No errors.
App\Entity\CFC No errors.
App\Entity\Assistants No errors.
App\Entity\Proviseurs No errors.
App\Entity\PlanningsFormations
  • The mappings App\Entity\PlanningsFormations#salle and App\Entity\Salles#planningFormation are inconsistent with each other.
App\Entity\InscriptionsFormations No errors.
App\Entity\Evaluations No errors.
App\Entity\Stagiaires No errors.
App\Entity\Salles
  • The association App\Entity\Salles#planningFormation refers to the owning side field App\Entity\PlanningsFormations#salles which does not exist.
App\Entity\PlagesFormations No errors.
App\Entity\PlanningsTypes No errors.
App\Entity\Agences
  • The association App\Entity\Agences#stagiaires refers to the owning side field App\Entity\Stagiaires#agences which does not exist.
App\Entity\Commentaires No errors.
App\Entity\Contentieux No errors.