1
0.74 ms
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . enabled AS enabled_5 , t0 . first_name AS first_name_6 , t0 . last_name AS last_name_7 , t0 . phone AS phone_8 , t0 . last_login_at AS last_login_at_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 FROM `user` t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . enabled AS enabled_5 , t0 . first_name AS first_name_6 , t0 . last_name AS last_name_7 , t0 . phone AS phone_8 , t0 . last_login_at AS last_login_at_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 FROM `user` t0 WHERE t0 . id = 5 ;
Copy
2
0.69 ms
SELECT count (DISTINCT g0_ . id ) AS sclr_0 FROM groupe g0_ LEFT JOIN classe c1_ ON g0_ . classe_id = c1_ . id WHERE g0_ . deleted_at IS NULL
SELECT count (DISTINCT g0_ . id ) AS sclr_0 FROM groupe g0_ LEFT JOIN classe c1_ ON g0_ . classe_id = c1_ . id WHERE g0_ . deleted_at IS NULL ;
Copy
3
0.47 ms
SELECT DISTINCT g0_ . id AS id_0 , g0_ . created_at AS created_at_1 FROM groupe g0_ LEFT JOIN classe c1_ ON g0_ . classe_id = c1_ . id WHERE g0_ . deleted_at IS NULL ORDER BY g0_ . created_at DESC LIMIT 20
SELECT DISTINCT g0_ . id AS id_0 , g0_ . created_at AS created_at_1 FROM groupe g0_ LEFT JOIN classe c1_ ON g0_ . classe_id = c1_ . id WHERE g0_ . deleted_at IS NULL ORDER BY g0_ . created_at DESC LIMIT 20 ;
Copy
4
0.47 ms
SELECT g0_ . id AS id_0 , g0_ . nom AS nom_1 , g0_ . description AS description_2 , g0_ . code AS code_3 , g0_ . effectif_max AS effectif_max_4 , g0_ . active AS active_5 , g0_ . salle AS salle_6 , g0_ . created_at AS created_at_7 , g0_ . updated_at AS updated_at_8 , g0_ . deleted_at AS deleted_at_9 , g0_ . referent_id AS referent_id_10 , g0_ . classe_id AS classe_id_11 FROM groupe g0_ LEFT JOIN classe c1_ ON g0_ . classe_id = c1_ . id WHERE g0_ . deleted_at IS NULL AND g0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY g0_ . created_at DESC
Parameters :
[
9
8
7
6
5
4
3
2
1
]
SELECT g0_ . id AS id_0 , g0_ . nom AS nom_1 , g0_ . description AS description_2 , g0_ . code AS code_3 , g0_ . effectif_max AS effectif_max_4 , g0_ . active AS active_5 , g0_ . salle AS salle_6 , g0_ . created_at AS created_at_7 , g0_ . updated_at AS updated_at_8 , g0_ . deleted_at AS deleted_at_9 , g0_ . referent_id AS referent_id_10 , g0_ . classe_id AS classe_id_11 FROM groupe g0_ LEFT JOIN classe c1_ ON g0_ . classe_id = c1_ . id WHERE g0_ . deleted_at IS NULL AND g0_ . id IN (9 , 8 , 7 , 6 , 5 , 4 , 3 , 2 , 1 ) ORDER BY g0_ . created_at DESC ;
Copy
5
0.60 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . description AS description_3 , t0 . ordre AS ordre_4 , t0 . active AS active_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . deleted_at AS deleted_at_8 , t0 . concours_id AS concours_id_9 FROM classe t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . description AS description_3 , t0 . ordre AS ordre_4 , t0 . active AS active_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . deleted_at AS deleted_at_8 , t0 . concours_id AS concours_id_9 FROM classe t0 WHERE t0 . id = 1 ;
Copy
6
0.69 ms
SELECT t0 . id AS id_1 , t0 . reference_inscription AS reference_inscription_2 , t0 . observations AS observations_3 , t0 . statut AS statut_4 , t0 . date_inscription AS date_inscription_5 , t0 . date_validation AS date_validation_6 , t0 . frais_inscription AS frais_inscription_7 , t0 . exonere AS exonere_8 , t0 . motif_exoneration AS motif_exoneration_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . eleve_id AS eleve_id_13 , t0 . concours_id AS concours_id_14 , t0 . cycle_id AS cycle_id_15 , t0 . section_id AS section_id_16 , t0 . classe_id AS classe_id_17 , t0 . groupe_id AS groupe_id_18 , t0 . agent_id AS agent_id_19 FROM inscription t0 WHERE t0 . groupe_id = ?
SELECT t0 . id AS id_1 , t0 . reference_inscription AS reference_inscription_2 , t0 . observations AS observations_3 , t0 . statut AS statut_4 , t0 . date_inscription AS date_inscription_5 , t0 . date_validation AS date_validation_6 , t0 . frais_inscription AS frais_inscription_7 , t0 . exonere AS exonere_8 , t0 . motif_exoneration AS motif_exoneration_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . eleve_id AS eleve_id_13 , t0 . concours_id AS concours_id_14 , t0 . cycle_id AS cycle_id_15 , t0 . section_id AS section_id_16 , t0 . classe_id AS classe_id_17 , t0 . groupe_id AS groupe_id_18 , t0 . agent_id AS agent_id_19 FROM inscription t0 WHERE t0 . groupe_id = 9 ;
Copy
7
0.50 ms
SELECT t0 . id AS id_1 , t0 . reference_inscription AS reference_inscription_2 , t0 . observations AS observations_3 , t0 . statut AS statut_4 , t0 . date_inscription AS date_inscription_5 , t0 . date_validation AS date_validation_6 , t0 . frais_inscription AS frais_inscription_7 , t0 . exonere AS exonere_8 , t0 . motif_exoneration AS motif_exoneration_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . eleve_id AS eleve_id_13 , t0 . concours_id AS concours_id_14 , t0 . cycle_id AS cycle_id_15 , t0 . section_id AS section_id_16 , t0 . classe_id AS classe_id_17 , t0 . groupe_id AS groupe_id_18 , t0 . agent_id AS agent_id_19 FROM inscription t0 WHERE t0 . groupe_id = ?
SELECT t0 . id AS id_1 , t0 . reference_inscription AS reference_inscription_2 , t0 . observations AS observations_3 , t0 . statut AS statut_4 , t0 . date_inscription AS date_inscription_5 , t0 . date_validation AS date_validation_6 , t0 . frais_inscription AS frais_inscription_7 , t0 . exonere AS exonere_8 , t0 . motif_exoneration AS motif_exoneration_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . eleve_id AS eleve_id_13 , t0 . concours_id AS concours_id_14 , t0 . cycle_id AS cycle_id_15 , t0 . section_id AS section_id_16 , t0 . classe_id AS classe_id_17 , t0 . groupe_id AS groupe_id_18 , t0 . agent_id AS agent_id_19 FROM inscription t0 WHERE t0 . groupe_id = 8 ;
Copy
8
0.38 ms
SELECT t0 . id AS id_1 , t0 . reference_inscription AS reference_inscription_2 , t0 . observations AS observations_3 , t0 . statut AS statut_4 , t0 . date_inscription AS date_inscription_5 , t0 . date_validation AS date_validation_6 , t0 . frais_inscription AS frais_inscription_7 , t0 . exonere AS exonere_8 , t0 . motif_exoneration AS motif_exoneration_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . eleve_id AS eleve_id_13 , t0 . concours_id AS concours_id_14 , t0 . cycle_id AS cycle_id_15 , t0 . section_id AS section_id_16 , t0 . classe_id AS classe_id_17 , t0 . groupe_id AS groupe_id_18 , t0 . agent_id AS agent_id_19 FROM inscription t0 WHERE t0 . groupe_id = ?
SELECT t0 . id AS id_1 , t0 . reference_inscription AS reference_inscription_2 , t0 . observations AS observations_3 , t0 . statut AS statut_4 , t0 . date_inscription AS date_inscription_5 , t0 . date_validation AS date_validation_6 , t0 . frais_inscription AS frais_inscription_7 , t0 . exonere AS exonere_8 , t0 . motif_exoneration AS motif_exoneration_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . eleve_id AS eleve_id_13 , t0 . concours_id AS concours_id_14 , t0 . cycle_id AS cycle_id_15 , t0 . section_id AS section_id_16 , t0 . classe_id AS classe_id_17 , t0 . groupe_id AS groupe_id_18 , t0 . agent_id AS agent_id_19 FROM inscription t0 WHERE t0 . groupe_id = 7 ;
Copy
9
0.29 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . description AS description_3 , t0 . ordre AS ordre_4 , t0 . active AS active_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . deleted_at AS deleted_at_8 , t0 . concours_id AS concours_id_9 FROM classe t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . description AS description_3 , t0 . ordre AS ordre_4 , t0 . active AS active_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . deleted_at AS deleted_at_8 , t0 . concours_id AS concours_id_9 FROM classe t0 WHERE t0 . id = 5 ;
Copy
10
0.31 ms
SELECT t0 . id AS id_1 , t0 . reference_inscription AS reference_inscription_2 , t0 . observations AS observations_3 , t0 . statut AS statut_4 , t0 . date_inscription AS date_inscription_5 , t0 . date_validation AS date_validation_6 , t0 . frais_inscription AS frais_inscription_7 , t0 . exonere AS exonere_8 , t0 . motif_exoneration AS motif_exoneration_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . eleve_id AS eleve_id_13 , t0 . concours_id AS concours_id_14 , t0 . cycle_id AS cycle_id_15 , t0 . section_id AS section_id_16 , t0 . classe_id AS classe_id_17 , t0 . groupe_id AS groupe_id_18 , t0 . agent_id AS agent_id_19 FROM inscription t0 WHERE t0 . groupe_id = ?
SELECT t0 . id AS id_1 , t0 . reference_inscription AS reference_inscription_2 , t0 . observations AS observations_3 , t0 . statut AS statut_4 , t0 . date_inscription AS date_inscription_5 , t0 . date_validation AS date_validation_6 , t0 . frais_inscription AS frais_inscription_7 , t0 . exonere AS exonere_8 , t0 . motif_exoneration AS motif_exoneration_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . eleve_id AS eleve_id_13 , t0 . concours_id AS concours_id_14 , t0 . cycle_id AS cycle_id_15 , t0 . section_id AS section_id_16 , t0 . classe_id AS classe_id_17 , t0 . groupe_id AS groupe_id_18 , t0 . agent_id AS agent_id_19 FROM inscription t0 WHERE t0 . groupe_id = 6 ;
Copy
11
0.36 ms
SELECT t0 . id AS id_1 , t0 . reference_inscription AS reference_inscription_2 , t0 . observations AS observations_3 , t0 . statut AS statut_4 , t0 . date_inscription AS date_inscription_5 , t0 . date_validation AS date_validation_6 , t0 . frais_inscription AS frais_inscription_7 , t0 . exonere AS exonere_8 , t0 . motif_exoneration AS motif_exoneration_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . eleve_id AS eleve_id_13 , t0 . concours_id AS concours_id_14 , t0 . cycle_id AS cycle_id_15 , t0 . section_id AS section_id_16 , t0 . classe_id AS classe_id_17 , t0 . groupe_id AS groupe_id_18 , t0 . agent_id AS agent_id_19 FROM inscription t0 WHERE t0 . groupe_id = ?
SELECT t0 . id AS id_1 , t0 . reference_inscription AS reference_inscription_2 , t0 . observations AS observations_3 , t0 . statut AS statut_4 , t0 . date_inscription AS date_inscription_5 , t0 . date_validation AS date_validation_6 , t0 . frais_inscription AS frais_inscription_7 , t0 . exonere AS exonere_8 , t0 . motif_exoneration AS motif_exoneration_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . eleve_id AS eleve_id_13 , t0 . concours_id AS concours_id_14 , t0 . cycle_id AS cycle_id_15 , t0 . section_id AS section_id_16 , t0 . classe_id AS classe_id_17 , t0 . groupe_id AS groupe_id_18 , t0 . agent_id AS agent_id_19 FROM inscription t0 WHERE t0 . groupe_id = 5 ;
Copy
12
0.27 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . description AS description_3 , t0 . ordre AS ordre_4 , t0 . active AS active_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . deleted_at AS deleted_at_8 , t0 . concours_id AS concours_id_9 FROM classe t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . description AS description_3 , t0 . ordre AS ordre_4 , t0 . active AS active_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . deleted_at AS deleted_at_8 , t0 . concours_id AS concours_id_9 FROM classe t0 WHERE t0 . id = 2 ;
Copy
13
0.39 ms
SELECT t0 . id AS id_1 , t0 . reference_inscription AS reference_inscription_2 , t0 . observations AS observations_3 , t0 . statut AS statut_4 , t0 . date_inscription AS date_inscription_5 , t0 . date_validation AS date_validation_6 , t0 . frais_inscription AS frais_inscription_7 , t0 . exonere AS exonere_8 , t0 . motif_exoneration AS motif_exoneration_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . eleve_id AS eleve_id_13 , t0 . concours_id AS concours_id_14 , t0 . cycle_id AS cycle_id_15 , t0 . section_id AS section_id_16 , t0 . classe_id AS classe_id_17 , t0 . groupe_id AS groupe_id_18 , t0 . agent_id AS agent_id_19 FROM inscription t0 WHERE t0 . groupe_id = ?
SELECT t0 . id AS id_1 , t0 . reference_inscription AS reference_inscription_2 , t0 . observations AS observations_3 , t0 . statut AS statut_4 , t0 . date_inscription AS date_inscription_5 , t0 . date_validation AS date_validation_6 , t0 . frais_inscription AS frais_inscription_7 , t0 . exonere AS exonere_8 , t0 . motif_exoneration AS motif_exoneration_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . eleve_id AS eleve_id_13 , t0 . concours_id AS concours_id_14 , t0 . cycle_id AS cycle_id_15 , t0 . section_id AS section_id_16 , t0 . classe_id AS classe_id_17 , t0 . groupe_id AS groupe_id_18 , t0 . agent_id AS agent_id_19 FROM inscription t0 WHERE t0 . groupe_id = 4 ;
Copy
14
0.32 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . description AS description_3 , t0 . ordre AS ordre_4 , t0 . active AS active_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . deleted_at AS deleted_at_8 , t0 . concours_id AS concours_id_9 FROM classe t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . description AS description_3 , t0 . ordre AS ordre_4 , t0 . active AS active_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . deleted_at AS deleted_at_8 , t0 . concours_id AS concours_id_9 FROM classe t0 WHERE t0 . id = 4 ;
Copy
15
0.37 ms
SELECT t0 . id AS id_1 , t0 . reference_inscription AS reference_inscription_2 , t0 . observations AS observations_3 , t0 . statut AS statut_4 , t0 . date_inscription AS date_inscription_5 , t0 . date_validation AS date_validation_6 , t0 . frais_inscription AS frais_inscription_7 , t0 . exonere AS exonere_8 , t0 . motif_exoneration AS motif_exoneration_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . eleve_id AS eleve_id_13 , t0 . concours_id AS concours_id_14 , t0 . cycle_id AS cycle_id_15 , t0 . section_id AS section_id_16 , t0 . classe_id AS classe_id_17 , t0 . groupe_id AS groupe_id_18 , t0 . agent_id AS agent_id_19 FROM inscription t0 WHERE t0 . groupe_id = ?
SELECT t0 . id AS id_1 , t0 . reference_inscription AS reference_inscription_2 , t0 . observations AS observations_3 , t0 . statut AS statut_4 , t0 . date_inscription AS date_inscription_5 , t0 . date_validation AS date_validation_6 , t0 . frais_inscription AS frais_inscription_7 , t0 . exonere AS exonere_8 , t0 . motif_exoneration AS motif_exoneration_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . eleve_id AS eleve_id_13 , t0 . concours_id AS concours_id_14 , t0 . cycle_id AS cycle_id_15 , t0 . section_id AS section_id_16 , t0 . classe_id AS classe_id_17 , t0 . groupe_id AS groupe_id_18 , t0 . agent_id AS agent_id_19 FROM inscription t0 WHERE t0 . groupe_id = 3 ;
Copy
16
0.31 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . description AS description_3 , t0 . ordre AS ordre_4 , t0 . active AS active_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . deleted_at AS deleted_at_8 , t0 . concours_id AS concours_id_9 FROM classe t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . description AS description_3 , t0 . ordre AS ordre_4 , t0 . active AS active_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . deleted_at AS deleted_at_8 , t0 . concours_id AS concours_id_9 FROM classe t0 WHERE t0 . id = 3 ;
Copy
17
0.28 ms
SELECT t0 . id AS id_1 , t0 . reference_inscription AS reference_inscription_2 , t0 . observations AS observations_3 , t0 . statut AS statut_4 , t0 . date_inscription AS date_inscription_5 , t0 . date_validation AS date_validation_6 , t0 . frais_inscription AS frais_inscription_7 , t0 . exonere AS exonere_8 , t0 . motif_exoneration AS motif_exoneration_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . eleve_id AS eleve_id_13 , t0 . concours_id AS concours_id_14 , t0 . cycle_id AS cycle_id_15 , t0 . section_id AS section_id_16 , t0 . classe_id AS classe_id_17 , t0 . groupe_id AS groupe_id_18 , t0 . agent_id AS agent_id_19 FROM inscription t0 WHERE t0 . groupe_id = ?
SELECT t0 . id AS id_1 , t0 . reference_inscription AS reference_inscription_2 , t0 . observations AS observations_3 , t0 . statut AS statut_4 , t0 . date_inscription AS date_inscription_5 , t0 . date_validation AS date_validation_6 , t0 . frais_inscription AS frais_inscription_7 , t0 . exonere AS exonere_8 , t0 . motif_exoneration AS motif_exoneration_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . eleve_id AS eleve_id_13 , t0 . concours_id AS concours_id_14 , t0 . cycle_id AS cycle_id_15 , t0 . section_id AS section_id_16 , t0 . classe_id AS classe_id_17 , t0 . groupe_id AS groupe_id_18 , t0 . agent_id AS agent_id_19 FROM inscription t0 WHERE t0 . groupe_id = 2 ;
Copy
18
0.29 ms
SELECT t0 . id AS id_1 , t0 . reference_inscription AS reference_inscription_2 , t0 . observations AS observations_3 , t0 . statut AS statut_4 , t0 . date_inscription AS date_inscription_5 , t0 . date_validation AS date_validation_6 , t0 . frais_inscription AS frais_inscription_7 , t0 . exonere AS exonere_8 , t0 . motif_exoneration AS motif_exoneration_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . eleve_id AS eleve_id_13 , t0 . concours_id AS concours_id_14 , t0 . cycle_id AS cycle_id_15 , t0 . section_id AS section_id_16 , t0 . classe_id AS classe_id_17 , t0 . groupe_id AS groupe_id_18 , t0 . agent_id AS agent_id_19 FROM inscription t0 WHERE t0 . groupe_id = ?
SELECT t0 . id AS id_1 , t0 . reference_inscription AS reference_inscription_2 , t0 . observations AS observations_3 , t0 . statut AS statut_4 , t0 . date_inscription AS date_inscription_5 , t0 . date_validation AS date_validation_6 , t0 . frais_inscription AS frais_inscription_7 , t0 . exonere AS exonere_8 , t0 . motif_exoneration AS motif_exoneration_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . eleve_id AS eleve_id_13 , t0 . concours_id AS concours_id_14 , t0 . cycle_id AS cycle_id_15 , t0 . section_id AS section_id_16 , t0 . classe_id AS classe_id_17 , t0 . groupe_id AS groupe_id_18 , t0 . agent_id AS agent_id_19 FROM inscription t0 WHERE t0 . groupe_id = 1 ;
Copy