Redirect 302 redirect from POST @app_login (cc0817)

GET https://remplacement.bxl.lire-et-ecrire.be/user/admin-gestion/calendrier?year=2025

Query Metrics

39 Database Queries
7 Different statements
20.87 ms Query time
1 Invalid entities
574 Managed entities

Queries

Group similar statements

# Time Info
1 0.94 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.gsm AS gsm_3, t0.roles AS roles_4, t0.password AS password_5, t0.heures_decimal AS heures_decimal_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.personnel_id AS personnel_id_10 FROM user t0 WHERE t0.id = ?
Parameters:
[
  5
]
2 2.16 ms
SELECT p0_.id AS id_0, p0_.first_name AS first_name_1, p0_.last_name AS last_name_2, p0_.is_archived AS is_archived_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.genre_id AS genre_id_6, p0_.fonction_id AS fonction_id_7, p0_.created_by_id AS created_by_id_8, p0_.updated_by_id AS updated_by_id_9 FROM personnel p0_ INNER JOIN fonction f1_ ON p0_.fonction_id = f1_.id WHERE f1_.label LIKE ? AND ((p0_.is_archived = 0 OR p0_.is_archived IS NULL)) ORDER BY p0_.last_name ASC, p0_.first_name ASC
Parameters:
[
  "%polyvalent%"
]
3 0.37 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.gsm AS gsm_3, t0.roles AS roles_4, t0.password AS password_5, t0.heures_decimal AS heures_decimal_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.personnel_id AS personnel_id_10 FROM user t0 WHERE t0.personnel_id = ?
Parameters:
[
  69
]
4 0.34 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.gsm AS gsm_3, t0.roles AS roles_4, t0.password AS password_5, t0.heures_decimal AS heures_decimal_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.personnel_id AS personnel_id_10 FROM user t0 WHERE t0.personnel_id = ?
Parameters:
[
  9
]
5 0.11 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.gsm AS gsm_3, t0.roles AS roles_4, t0.password AS password_5, t0.heures_decimal AS heures_decimal_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.personnel_id AS personnel_id_10 FROM user t0 WHERE t0.personnel_id = ?
Parameters:
[
  16
]
6 0.23 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.gsm AS gsm_3, t0.roles AS roles_4, t0.password AS password_5, t0.heures_decimal AS heures_decimal_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.personnel_id AS personnel_id_10 FROM user t0 WHERE t0.personnel_id = ?
Parameters:
[
  76
]
7 0.26 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.gsm AS gsm_3, t0.roles AS roles_4, t0.password AS password_5, t0.heures_decimal AS heures_decimal_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.personnel_id AS personnel_id_10 FROM user t0 WHERE t0.personnel_id = ?
Parameters:
[
  48
]
8 0.22 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.gsm AS gsm_3, t0.roles AS roles_4, t0.password AS password_5, t0.heures_decimal AS heures_decimal_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.personnel_id AS personnel_id_10 FROM user t0 WHERE t0.personnel_id = ?
Parameters:
[
  79
]
9 0.40 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.gsm AS gsm_3, t0.roles AS roles_4, t0.password AS password_5, t0.heures_decimal AS heures_decimal_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.personnel_id AS personnel_id_10 FROM user t0 WHERE t0.personnel_id = ?
Parameters:
[
  75
]
10 0.15 ms
SELECT p0_.id AS id_0, p0_.first_name AS first_name_1, p0_.last_name AS last_name_2, p0_.is_archived AS is_archived_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.genre_id AS genre_id_6, p0_.fonction_id AS fonction_id_7, p0_.created_by_id AS created_by_id_8, p0_.updated_by_id AS updated_by_id_9 FROM personnel p0_ INNER JOIN fonction f1_ ON p0_.fonction_id = f1_.id WHERE f1_.label LIKE ? AND ((p0_.is_archived = 0 OR p0_.is_archived IS NULL)) ORDER BY p0_.last_name ASC, p0_.first_name ASC
Parameters:
[
  "%polyvalent%"
]
11 5.57 ms
SELECT p0_.id AS id_0, p0_.commentaire AS commentaire_1, p0_.is_annuler AS is_annuler_2, p0_.raison_annulation AS raison_annulation_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, o1_.id AS id_6, o1_.date AS date_7, o1_.heure_debut AS heure_debut_8, o1_.heure_fin AS heure_fin_9, o1_.is_annuler AS is_annuler_10, o1_.motifs_annuler AS motifs_annuler_11, o1_.commentaire AS commentaire_12, o1_.created_at AS created_at_13, o1_.updated_at AS updated_at_14, o1_.reference_groupe AS reference_groupe_15, o1_.id_groupe AS id_groupe_16, o1_.niveau AS niveau_17, c2_.id AS id_18, c2_.label AS label_19, c2_.created_at AS created_at_20, c2_.updated_at AS updated_at_21, c2_.is_active AS is_active_22, l3_.id AS id_23, l3_.label AS label_24, l3_.siege_address AS siege_address_25, l3_.cours_address AS cours_address_26, l3_.contact AS contact_27, l3_.is_lee AS is_lee_28, l3_.created_at AS created_at_29, l3_.updated_at AS updated_at_30, p4_.id AS id_31, p4_.first_name AS first_name_32, p4_.last_name AS last_name_33, p4_.is_archived AS is_archived_34, p4_.created_at AS created_at_35, p4_.updated_at AS updated_at_36, p0_.offre_id AS offre_id_37, p0_.formateur_polyvalent_id AS formateur_polyvalent_id_38, p0_.created_by_id AS created_by_id_39, p0_.updated_by_id AS updated_by_id_40, o1_.created_by_id AS created_by_id_41, o1_.updated_by_id AS updated_by_id_42, o1_.centre_alpha_id AS centre_alpha_id_43, o1_.formateur_titulaire_id AS formateur_titulaire_id_44, o1_.lieu_id AS lieu_id_45, o1_.motif_remplacement_id AS motif_remplacement_id_46, c2_.created_by_id AS created_by_id_47, c2_.updated_by_id AS updated_by_id_48, l3_.created_by_id AS created_by_id_49, l3_.updated_by_id AS updated_by_id_50, p4_.genre_id AS genre_id_51, p4_.fonction_id AS fonction_id_52, p4_.created_by_id AS created_by_id_53, p4_.updated_by_id AS updated_by_id_54 FROM postuler_offre p0_ INNER JOIN offre o1_ ON p0_.offre_id = o1_.id INNER JOIN centre_alpha c2_ ON o1_.centre_alpha_id = c2_.id LEFT JOIN lieu_formation l3_ ON o1_.lieu_id = l3_.id LEFT JOIN personnel p4_ ON p0_.formateur_polyvalent_id = p4_.id WHERE (o1_.date BETWEEN ? AND ?) AND p0_.formateur_polyvalent_id IN (?, ?, ?, ?, ?, ?, ?) ORDER BY o1_.date DESC, o1_.heure_debut DESC
Parameters:
[
  "2025-09-01 00:00:00"
  "2026-08-31 23:59:59"
  69
  9
  16
  76
  48
  79
  75
]
12 0.65 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  6
]
13 0.46 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  42
]
14 0.20 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  61
]
15 0.36 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  25
]
16 0.34 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  37
]
17 0.37 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  74
]
18 0.31 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  7
]
19 0.34 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  57
]
20 0.32 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  2
]
21 0.49 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  71
]
22 0.32 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  39
]
23 0.30 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  40
]
24 0.27 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  47
]
25 0.28 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  36
]
26 0.29 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  65
]
27 0.34 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  27
]
28 0.29 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  30
]
29 0.31 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  33
]
30 0.39 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  77
]
31 0.28 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  43
]
32 0.31 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  73
]
33 0.41 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  51
]
34 0.34 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  22
]
35 0.30 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  17
]
36 0.51 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  19
]
37 0.43 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?
Parameters:
[
  11
]
38 0.16 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by_id AS created_by_id_5, t0.updated_by_id AS updated_by_id_6 FROM fonction t0 WHERE t0.id = ?
Parameters:
[
  3
]
39 0.74 ms
SELECT t0.id AS id_1, t0.is_coordo AS is_coordo_2, t0.user_id AS user_id_3, t0.centre_id AS centre_id_4 FROM user_centre_autorisation t0 WHERE t0.user_id = ?
Parameters:
[
  5
]

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\PostulerOffre 244
App\Entity\Offre 236
App\Entity\Personnel 33
App\Entity\LieuFormation 21
App\Entity\User 14
App\Entity\MotifAbsence 10
App\Entity\CentreAlpha 5
App\Entity\UserCentreAutorisation 5
App\Entity\Genre 3
App\Entity\Fonction 3

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Personnel
  • The field App\Entity\Personnel#user is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User#personnel does not contain the required 'inversedBy: "user"' attribute.
App\Entity\UserCentreAutorisation No errors.
App\Entity\Fonction No errors.
App\Entity\Genre No errors.
App\Entity\Offre No errors.
App\Entity\PostulerOffre No errors.
App\Entity\CentreAlpha No errors.
App\Entity\LieuFormation No errors.
App\Entity\MotifAbsence No errors.