| 1 |
0.35 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_active AS is_active_8, t0.avatar AS avatar_9, t0.reset_password_token AS reset_password_token_10, t0.reset_password_requested_at AS reset_password_requested_at_11, t0.compte_id AS compte_id_12, t0.profil_id AS profil_id_13 FROM app_user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_active AS is_active_8, t0.avatar AS avatar_9, t0.reset_password_token AS reset_password_token_10, t0.reset_password_requested_at AS reset_password_requested_at_11, t0.compte_id AS compte_id_12, t0.profil_id AS profil_id_13 FROM app_user t0 WHERE t0.id = 6;
|
| 2 |
0.37 ms |
SELECT t0.id AS id_1, t0.date_inscription AS date_inscription_2, t0.frais_inscription AS frais_inscription_3, t0.transport AS transport_4, t0.statut_scolarite AS statut_scolarite_5, t0.mode_paiement_scolarite AS mode_paiement_scolarite_6, t0.est_nouveau AS est_nouveau_7, t0.montant_exceptionnel AS montant_exceptionnel_8, t0.observation_remise AS observation_remise_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.annee_scolaire_id AS annee_scolaire_id_12, t0.eleve_id AS eleve_id_13, t0.classe_id AS classe_id_14, t0.affected_class_id AS affected_class_id_15, t0.annexe_id AS annexe_id_16 FROM inscription t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.date_inscription AS date_inscription_2, t0.frais_inscription AS frais_inscription_3, t0.transport AS transport_4, t0.statut_scolarite AS statut_scolarite_5, t0.mode_paiement_scolarite AS mode_paiement_scolarite_6, t0.est_nouveau AS est_nouveau_7, t0.montant_exceptionnel AS montant_exceptionnel_8, t0.observation_remise AS observation_remise_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.annee_scolaire_id AS annee_scolaire_id_12, t0.eleve_id AS eleve_id_13, t0.classe_id AS classe_id_14, t0.affected_class_id AS affected_class_id_15, t0.annexe_id AS annexe_id_16 FROM inscription t0 WHERE t0.id = 1424;
|
| 3 |
0.29 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.mail AS mail_3, t0.tel AS tel_4, t0.adresse AS adresse_5, t0.devise AS devise_6, t0.logo AS logo_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.ville_id AS ville_id_10, t0.compte_id AS compte_id_11 FROM annexe t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.mail AS mail_3, t0.tel AS tel_4, t0.adresse AS adresse_5, t0.devise AS devise_6, t0.logo AS logo_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.ville_id AS ville_id_10, t0.compte_id AS compte_id_11 FROM annexe t0 WHERE t0.id = 6;
|
| 4 |
0.30 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.nom AS nom_3, t0.prenoms AS prenoms_4, t0.sexe AS sexe_5, t0.naissance AS naissance_6, t0.lieu_naissance AS lieu_naissance_7, t0.pays_naissance AS pays_naissance_8, t0.nationalite AS nationalite_9, t0.situation_familiale AS situation_familiale_10, t0.situation_handicap AS situation_handicap_11, t0.provenance AS provenance_12, t0.classe_anterieure AS classe_anterieure_13, t0.pere_nom AS pere_nom_14, t0.pere_prenoms AS pere_prenoms_15, t0.pere_telephone AS pere_telephone_16, t0.pere_metier AS pere_metier_17, t0.mere_nom AS mere_nom_18, t0.mere_prenoms AS mere_prenoms_19, t0.mere_telephone AS mere_telephone_20, t0.mere_metier AS mere_metier_21, t0.type_tuteur AS type_tuteur_22, t0.tuteur_nom AS tuteur_nom_23, t0.tuteur_prenoms AS tuteur_prenoms_24, t0.tuteur_telephone AS tuteur_telephone_25, t0.tuteur_metier AS tuteur_metier_26, t0.photo AS photo_27, t0.etat AS etat_28, t0.date_depart AS date_depart_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.prefecture_naissance_id AS prefecture_naissance_id_32 FROM eleve t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.nom AS nom_3, t0.prenoms AS prenoms_4, t0.sexe AS sexe_5, t0.naissance AS naissance_6, t0.lieu_naissance AS lieu_naissance_7, t0.pays_naissance AS pays_naissance_8, t0.nationalite AS nationalite_9, t0.situation_familiale AS situation_familiale_10, t0.situation_handicap AS situation_handicap_11, t0.provenance AS provenance_12, t0.classe_anterieure AS classe_anterieure_13, t0.pere_nom AS pere_nom_14, t0.pere_prenoms AS pere_prenoms_15, t0.pere_telephone AS pere_telephone_16, t0.pere_metier AS pere_metier_17, t0.mere_nom AS mere_nom_18, t0.mere_prenoms AS mere_prenoms_19, t0.mere_telephone AS mere_telephone_20, t0.mere_metier AS mere_metier_21, t0.type_tuteur AS type_tuteur_22, t0.tuteur_nom AS tuteur_nom_23, t0.tuteur_prenoms AS tuteur_prenoms_24, t0.tuteur_telephone AS tuteur_telephone_25, t0.tuteur_metier AS tuteur_metier_26, t0.photo AS photo_27, t0.etat AS etat_28, t0.date_depart AS date_depart_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.prefecture_naissance_id AS prefecture_naissance_id_32 FROM eleve t0 WHERE t0.id = 1781;
|
| 5 |
0.32 ms |
SELECT t0.id AS id_1, t0.montant_base AS montant_base_2, t0.montant_1enft_unique AS montant_1enft_unique_3, t0.montant_1enft_tranches AS montant_1enft_tranches_4, t0.montant_2_3enft_unique AS montant_2_3enft_unique_5, t0.montant_2_3enft_tranches AS montant_2_3enft_tranches_6, t0.montant_4plus_unique AS montant_4plus_unique_7, t0.montant_4plus_tranches AS montant_4plus_tranches_8, t0.montant_inscription_nouveau AS montant_inscription_nouveau_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.annee_scolaire_id AS annee_scolaire_id_12, t0.compte_id AS compte_id_13, t0.type_classe_id AS type_classe_id_14 FROM tarif_scolarite_classe t0 WHERE t0.annee_scolaire_id = ? AND t0.compte_id = ? AND t0.type_classe_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.montant_base AS montant_base_2, t0.montant_1enft_unique AS montant_1enft_unique_3, t0.montant_1enft_tranches AS montant_1enft_tranches_4, t0.montant_2_3enft_unique AS montant_2_3enft_unique_5, t0.montant_2_3enft_tranches AS montant_2_3enft_tranches_6, t0.montant_4plus_unique AS montant_4plus_unique_7, t0.montant_4plus_tranches AS montant_4plus_tranches_8, t0.montant_inscription_nouveau AS montant_inscription_nouveau_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.annee_scolaire_id AS annee_scolaire_id_12, t0.compte_id AS compte_id_13, t0.type_classe_id AS type_classe_id_14 FROM tarif_scolarite_classe t0 WHERE t0.annee_scolaire_id = 2 AND t0.compte_id = 4 AND t0.type_classe_id = 10 LIMIT 1;
|
| 6 |
0.39 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.nom AS nom_3, t0.prenoms AS prenoms_4, t0.sexe AS sexe_5, t0.naissance AS naissance_6, t0.lieu_naissance AS lieu_naissance_7, t0.pays_naissance AS pays_naissance_8, t0.nationalite AS nationalite_9, t0.situation_familiale AS situation_familiale_10, t0.situation_handicap AS situation_handicap_11, t0.provenance AS provenance_12, t0.classe_anterieure AS classe_anterieure_13, t0.pere_nom AS pere_nom_14, t0.pere_prenoms AS pere_prenoms_15, t0.pere_telephone AS pere_telephone_16, t0.pere_metier AS pere_metier_17, t0.mere_nom AS mere_nom_18, t0.mere_prenoms AS mere_prenoms_19, t0.mere_telephone AS mere_telephone_20, t0.mere_metier AS mere_metier_21, t0.type_tuteur AS type_tuteur_22, t0.tuteur_nom AS tuteur_nom_23, t0.tuteur_prenoms AS tuteur_prenoms_24, t0.tuteur_telephone AS tuteur_telephone_25, t0.tuteur_metier AS tuteur_metier_26, t0.photo AS photo_27, t0.etat AS etat_28, t0.date_depart AS date_depart_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.prefecture_naissance_id AS prefecture_naissance_id_32 FROM eleve t0 INNER JOIN eleve_fratrie ON t0.id = eleve_fratrie.frere_soeur_id WHERE eleve_fratrie.eleve_id = ?
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.nom AS nom_3, t0.prenoms AS prenoms_4, t0.sexe AS sexe_5, t0.naissance AS naissance_6, t0.lieu_naissance AS lieu_naissance_7, t0.pays_naissance AS pays_naissance_8, t0.nationalite AS nationalite_9, t0.situation_familiale AS situation_familiale_10, t0.situation_handicap AS situation_handicap_11, t0.provenance AS provenance_12, t0.classe_anterieure AS classe_anterieure_13, t0.pere_nom AS pere_nom_14, t0.pere_prenoms AS pere_prenoms_15, t0.pere_telephone AS pere_telephone_16, t0.pere_metier AS pere_metier_17, t0.mere_nom AS mere_nom_18, t0.mere_prenoms AS mere_prenoms_19, t0.mere_telephone AS mere_telephone_20, t0.mere_metier AS mere_metier_21, t0.type_tuteur AS type_tuteur_22, t0.tuteur_nom AS tuteur_nom_23, t0.tuteur_prenoms AS tuteur_prenoms_24, t0.tuteur_telephone AS tuteur_telephone_25, t0.tuteur_metier AS tuteur_metier_26, t0.photo AS photo_27, t0.etat AS etat_28, t0.date_depart AS date_depart_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.prefecture_naissance_id AS prefecture_naissance_id_32 FROM eleve t0 INNER JOIN eleve_fratrie ON t0.id = eleve_fratrie.frere_soeur_id WHERE eleve_fratrie.eleve_id = 1781;
|
| 7 |
0.26 ms |
SELECT SUM(p0_.montant) AS sclr_0 FROM paiement p0_ WHERE p0_.inscription_id = ? AND p0_.type_paiement = ? AND p0_.statut = ?
Parameters: [
1424
"scolarite"
"valide"
]
SELECT SUM(p0_.montant) AS sclr_0 FROM paiement p0_ WHERE p0_.inscription_id = 1424 AND p0_.type_paiement = 'scolarite' AND p0_.statut = 'valide';
|
| 8 |
0.17 ms |
SELECT SUM(p0_.montant) AS sclr_0 FROM paiement p0_ WHERE p0_.inscription_id = ? AND p0_.type_paiement = ? AND p0_.statut = ?
Parameters: [
1424
"inscription"
"valide"
]
SELECT SUM(p0_.montant) AS sclr_0 FROM paiement p0_ WHERE p0_.inscription_id = 1424 AND p0_.type_paiement = 'inscription' AND p0_.statut = 'valide';
|
| 9 |
0.22 ms |
SELECT t0.id AS id_1, t0.montant_base AS montant_base_2, t0.montant_1enft_unique AS montant_1enft_unique_3, t0.montant_1enft_tranches AS montant_1enft_tranches_4, t0.montant_2_3enft_unique AS montant_2_3enft_unique_5, t0.montant_2_3enft_tranches AS montant_2_3enft_tranches_6, t0.montant_4plus_unique AS montant_4plus_unique_7, t0.montant_4plus_tranches AS montant_4plus_tranches_8, t0.montant_inscription_nouveau AS montant_inscription_nouveau_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.annee_scolaire_id AS annee_scolaire_id_12, t0.compte_id AS compte_id_13, t0.type_classe_id AS type_classe_id_14 FROM tarif_scolarite_classe t0 WHERE t0.annee_scolaire_id = ? AND t0.compte_id = ? AND t0.type_classe_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.montant_base AS montant_base_2, t0.montant_1enft_unique AS montant_1enft_unique_3, t0.montant_1enft_tranches AS montant_1enft_tranches_4, t0.montant_2_3enft_unique AS montant_2_3enft_unique_5, t0.montant_2_3enft_tranches AS montant_2_3enft_tranches_6, t0.montant_4plus_unique AS montant_4plus_unique_7, t0.montant_4plus_tranches AS montant_4plus_tranches_8, t0.montant_inscription_nouveau AS montant_inscription_nouveau_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.annee_scolaire_id AS annee_scolaire_id_12, t0.compte_id AS compte_id_13, t0.type_classe_id AS type_classe_id_14 FROM tarif_scolarite_classe t0 WHERE t0.annee_scolaire_id = 2 AND t0.compte_id = 4 AND t0.type_classe_id = 10 LIMIT 1;
|
| 10 |
0.21 ms |
SELECT SUM(p0_.montant) AS sclr_0 FROM paiement p0_ WHERE p0_.inscription_id = ? AND p0_.type_paiement = ? AND p0_.statut = ?
Parameters: [
1424
"scolarite"
"valide"
]
SELECT SUM(p0_.montant) AS sclr_0 FROM paiement p0_ WHERE p0_.inscription_id = 1424 AND p0_.type_paiement = 'scolarite' AND p0_.statut = 'valide';
|
| 11 |
0.19 ms |
SELECT SUM(p0_.montant) AS sclr_0 FROM paiement p0_ WHERE p0_.inscription_id = ? AND p0_.type_paiement = ? AND p0_.statut = ?
Parameters: [
1424
"inscription"
"valide"
]
SELECT SUM(p0_.montant) AS sclr_0 FROM paiement p0_ WHERE p0_.inscription_id = 1424 AND p0_.type_paiement = 'inscription' AND p0_.statut = 'valide';
|
| 12 |
0.18 ms |
SELECT t0.id AS id_1, t0.montant_base AS montant_base_2, t0.montant_1enft_unique AS montant_1enft_unique_3, t0.montant_1enft_tranches AS montant_1enft_tranches_4, t0.montant_2_3enft_unique AS montant_2_3enft_unique_5, t0.montant_2_3enft_tranches AS montant_2_3enft_tranches_6, t0.montant_4plus_unique AS montant_4plus_unique_7, t0.montant_4plus_tranches AS montant_4plus_tranches_8, t0.montant_inscription_nouveau AS montant_inscription_nouveau_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.annee_scolaire_id AS annee_scolaire_id_12, t0.compte_id AS compte_id_13, t0.type_classe_id AS type_classe_id_14 FROM tarif_scolarite_classe t0 WHERE t0.annee_scolaire_id = ? AND t0.compte_id = ? AND t0.type_classe_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.montant_base AS montant_base_2, t0.montant_1enft_unique AS montant_1enft_unique_3, t0.montant_1enft_tranches AS montant_1enft_tranches_4, t0.montant_2_3enft_unique AS montant_2_3enft_unique_5, t0.montant_2_3enft_tranches AS montant_2_3enft_tranches_6, t0.montant_4plus_unique AS montant_4plus_unique_7, t0.montant_4plus_tranches AS montant_4plus_tranches_8, t0.montant_inscription_nouveau AS montant_inscription_nouveau_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.annee_scolaire_id AS annee_scolaire_id_12, t0.compte_id AS compte_id_13, t0.type_classe_id AS type_classe_id_14 FROM tarif_scolarite_classe t0 WHERE t0.annee_scolaire_id = 2 AND t0.compte_id = 4 AND t0.type_classe_id = 10 LIMIT 1;
|
| 13 |
0.16 ms |
SELECT SUM(p0_.montant) AS sclr_0 FROM paiement p0_ WHERE p0_.inscription_id = ? AND p0_.type_paiement = ? AND p0_.statut = ?
Parameters: [
1424
"scolarite"
"valide"
]
SELECT SUM(p0_.montant) AS sclr_0 FROM paiement p0_ WHERE p0_.inscription_id = 1424 AND p0_.type_paiement = 'scolarite' AND p0_.statut = 'valide';
|
| 14 |
0.20 ms |
SELECT SUM(p0_.montant) AS sclr_0 FROM paiement p0_ WHERE p0_.inscription_id = ? AND p0_.type_paiement = ? AND p0_.statut = ?
Parameters: [
1424
"inscription"
"valide"
]
SELECT SUM(p0_.montant) AS sclr_0 FROM paiement p0_ WHERE p0_.inscription_id = 1424 AND p0_.type_paiement = 'inscription' AND p0_.statut = 'valide';
|
| 15 |
0.42 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.statut AS statut_5, t0.capacite AS capacite_6, t0.compte_id AS compte_id_7, t0.type_id AS type_id_8, t0.annexe_id AS annexe_id_9 FROM classe t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.statut AS statut_5, t0.capacite AS capacite_6, t0.compte_id AS compte_id_7, t0.type_id AS type_id_8, t0.annexe_id AS annexe_id_9 FROM classe t0 WHERE t0.id = 30;
|
| 16 |
0.19 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.statut AS statut_5 FROM annee_scolaire t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.statut AS statut_5 FROM annee_scolaire t0 WHERE t0.id = 2;
|
| 17 |
0.47 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.mail AS mail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.type_id AS type_id_6 FROM compte t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.mail AS mail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.type_id AS type_id_6 FROM compte t0 WHERE t0.id = 4;
|