GET https://togostud.prosysct.com/paiement/new/1420

Query Metrics

17 Database Queries
10 Different statements
4.45 ms Query time
0 Invalid entities
12 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.30 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 = ?
Parameters:
[
  6
]
2 0.29 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 = ?
Parameters:
[
  1420
]
3 0.20 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 = ?
Parameters:
[
  6
]
4 0.28 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 = ?
Parameters:
[
  1777
]
5 0.25 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
Parameters:
[
  2
  4
  11
]
6 0.43 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 = ?
Parameters:
[
  1777
]
7 0.34 ms
SELECT SUM(p0_.montant) AS sclr_0 FROM paiement p0_ WHERE p0_.inscription_id = ? AND p0_.type_paiement = ? AND p0_.statut = ?
Parameters:
[
  1420
  "scolarite"
  "valide"
]
8 0.22 ms
SELECT SUM(p0_.montant) AS sclr_0 FROM paiement p0_ WHERE p0_.inscription_id = ? AND p0_.type_paiement = ? AND p0_.statut = ?
Parameters:
[
  1420
  "inscription"
  "valide"
]
9 0.24 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
Parameters:
[
  2
  4
  11
]
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:
[
  1420
  "scolarite"
  "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:
[
  1420
  "inscription"
  "valide"
]
12 0.23 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
Parameters:
[
  2
  4
  11
]
13 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:
[
  1420
  "scolarite"
  "valide"
]
14 0.22 ms
SELECT SUM(p0_.montant) AS sclr_0 FROM paiement p0_ WHERE p0_.inscription_id = ? AND p0_.type_paiement = ? AND p0_.statut = ?
Parameters:
[
  1420
  "inscription"
  "valide"
]
15 0.39 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 = ?
Parameters:
[
  31
]
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 = ?
Parameters:
[
  2
]
17 0.23 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 = ?
Parameters:
[
  4
]

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\User 1
App\Entity\Compte 1
App\Entity\Inscription 1
App\Entity\AnneeScolaire 1
App\Entity\Eleve 1
App\Entity\TypeClasse 1
App\Entity\Classe 1
App\Entity\Annexe 1
App\Entity\Ville 1
App\Entity\Prefecture 1
App\Entity\TarifScolariteClasse 1
App\Entity\TypeCompte 1

Entities Mapping