Query Metrics
63
Database Queries
17
Different statements
82.06 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.29 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email_compte AS email_compte_5, t0.verfier AS verfier_6, t0.env AS env_7 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 2 | 0.68 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.numero_adhesion AS numero_adhesion_4, t0.email AS email_5, t0.salaire_brute AS salaire_brute_6, t0.rip AS rip_7, t0.forfait_telecom AS forfait_telecom_8, t0.nom_prenom AS nom_prenom_9, t0.matricule AS matricule_10, t0.rang AS rang_11, t0.etat AS etat_12, t0.marier AS marier_13, t0.conjoint AS conjoint_14, t0.fin_forfait AS fin_forfait_15, t0.user_compte_id AS user_compte_id_16, t17.id AS id_18, t17.immatriculation AS immatriculation_19, t17.marque AS marque_20, t17.modele AS modele_21, t17.couleur AS couleur_22, t17.mois_debut AS mois_debut_23, t17.mois_fin AS mois_fin_24, t17.adherent_id AS adherent_id_25, t17.parking_id AS parking_id_26 FROM adherent t0 LEFT JOIN vehicule t17 ON t17.adherent_id = t0.id WHERE t0.id = ?
Parameters:
[
"43"
]
|
| 3 | 0.55 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 4 | 0.39 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 5 | 0.67 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE p0_.etat <> 'Bloquer' AND p0_.annee_exercice_id = ? AND p0_.adherent_id = ?
Parameters:
[ 6 "43" ] |
| 6 | 0.86 ms |
SELECT t0_.lib AS lib_0, SUM(p1_.valeur_payer) AS sclr_1, SUM(p1_.valeur) AS sclr_2, SUM(p1_.valeur) - SUM(p1_.valeur_payer) AS sclr_3 FROM prestation p1_ INNER JOIN type_prestation t0_ ON p1_.type_prestation_id = t0_.id AND (p1_.type_prestation_id = t0_.id) WHERE p1_.etat <> 'Bloquer' AND p1_.adherent_id = ? AND p1_.annee_exercice_id = ? GROUP BY t0_.lib
Parameters:
[ "43" "6" ] |
| 7 | 0.43 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 8 | 1.85 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE t1_.palfont = 1 AND p0_.etat <> 'Bloquer' AND p0_.annee_exercice_id = ?
Parameters:
[
6
]
|
| 9 | 0.40 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 10 | 1.74 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE t1_.palfont = 1 AND p0_.etat <> 'Bloquer' AND p0_.etat = ? AND p0_.etat = ? AND p0_.annee_exercice_id = ?
Parameters:
[ "Payer" "Payer" 6 ] |
| 11 | 0.41 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 12 | 1.74 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE t1_.palfont = 1 AND p0_.etat <> 'Bloquer' AND p0_.annee_exercice_id = ?
Parameters:
[
6
]
|
| 13 | 0.42 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 14 | 1.79 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE t1_.palfont = 1 AND p0_.etat <> 'Bloquer' AND p0_.annee_exercice_id = ?
Parameters:
[
6
]
|
| 15 | 0.42 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 16 | 1.89 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE t1_.palfont = 1 AND p0_.etat <> 'Bloquer' AND p0_.etat = ? AND p0_.etat = ? AND p0_.annee_exercice_id = ?
Parameters:
[ "Payer" "Payer" 6 ] |
| 17 | 0.45 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 18 | 1.77 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE t1_.palfont = 1 AND p0_.etat <> 'Bloquer' AND p0_.annee_exercice_id = ?
Parameters:
[
6
]
|
| 19 | 0.41 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 20 | 1.94 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE t1_.palfont = 1 AND p0_.etat <> 'Bloquer' AND p0_.annee_exercice_id = ?
Parameters:
[
6
]
|
| 21 | 0.44 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 22 | 1.72 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE t1_.palfont = 1 AND p0_.etat <> 'Bloquer' AND p0_.etat = ? AND p0_.etat = ? AND p0_.annee_exercice_id = ?
Parameters:
[ "Valider" "Valider" 6 ] |
| 23 | 0.46 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 24 | 1.87 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE t1_.palfont = 1 AND p0_.etat <> 'Bloquer' AND p0_.annee_exercice_id = ?
Parameters:
[
6
]
|
| 25 | 0.41 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 26 | 1.74 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE t1_.palfont = 1 AND p0_.etat <> 'Bloquer' AND p0_.annee_exercice_id = ?
Parameters:
[
6
]
|
| 27 | 0.39 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 28 | 1.72 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE t1_.palfont = 1 AND p0_.etat <> 'Bloquer' AND p0_.etat = ? AND p0_.etat = ? AND p0_.annee_exercice_id = ?
Parameters:
[ "Valider" "Valider" 6 ] |
| 29 | 0.39 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 30 | 1.73 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE t1_.palfont = 1 AND p0_.etat <> 'Bloquer' AND p0_.annee_exercice_id = ?
Parameters:
[
6
]
|
| 31 | 0.39 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 32 | 1.86 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE t1_.palfont = 1 AND p0_.etat <> 'Bloquer' AND p0_.annee_exercice_id = ?
Parameters:
[
6
]
|
| 33 | 0.48 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 34 | 1.75 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE t1_.palfont = 1 AND p0_.etat <> 'Bloquer' AND p0_.etat = ? AND p0_.etat = ? AND p0_.annee_exercice_id = ?
Parameters:
[ "cour" "cour" 6 ] |
| 35 | 0.41 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 36 | 1.75 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE t1_.palfont = 1 AND p0_.etat <> 'Bloquer' AND p0_.annee_exercice_id = ?
Parameters:
[
6
]
|
| 37 | 0.39 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 38 | 1.71 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE t1_.palfont = 1 AND p0_.etat <> 'Bloquer' AND p0_.annee_exercice_id = ?
Parameters:
[
6
]
|
| 39 | 0.39 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 40 | 1.81 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE t1_.palfont = 1 AND p0_.etat <> 'Bloquer' AND p0_.etat = ? AND p0_.etat = ? AND p0_.annee_exercice_id = ?
Parameters:
[ "cour" "cour" 6 ] |
| 41 | 0.40 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 42 | 1.70 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE t1_.palfont = 1 AND p0_.etat <> 'Bloquer' AND p0_.annee_exercice_id = ?
Parameters:
[
6
]
|
| 43 | 0.43 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ ORDER BY a0_.annee DESC LIMIT 1
Parameters:
[] |
| 44 | 0.41 ms |
SELECT a0_.id AS id_0, a0_.annee AS annee_1, a0_.palafon AS palafon_2, a0_.date_insertion AS date_insertion_3, a0_.amicale_id AS amicale_id_4 FROM annee_exercice a0_ WHERE a0_.id = ? ORDER BY a0_.id DESC LIMIT 1
Parameters:
[
"6"
]
|
| 45 | 0.65 ms |
SELECT SUM(p0_.valeur_payer) AS sclr_0 FROM prestation p0_ INNER JOIN type_prestation t1_ ON p0_.type_prestation_id = t1_.id AND (p0_.type_prestation_id = t1_.id) WHERE t1_.palfont = 1 AND p0_.etat <> 'Bloquer' AND p0_.annee_exercice_id = ? AND p0_.adherent_id = ?
Parameters:
[ 6 "43" ] |
| 46 | 0.59 ms |
SELECT p0_.id AS id_0, p0_.valeur AS valeur_1, p0_.etat AS etat_2, p0_.valeur_payer AS valeur_payer_3, p0_.date_insertion AS date_insertion_4, p0_.mois AS mois_5, p0_.nb_mois AS nb_mois_6, p0_.montant_mois AS montant_mois_7, p0_.adherent_id AS adherent_id_8, p0_.type_prestation_id AS type_prestation_id_9, p0_.annee_exercice_id AS annee_exercice_id_10, p0_.parking_id AS parking_id_11, p0_.enfant_id AS enfant_id_12 FROM prestation p0_ WHERE p0_.annee_exercice_id = ? AND p0_.type_prestation_id = ? AND p0_.adherent_id = ? ORDER BY p0_.id DESC
Parameters:
[ "6" "9" "43" ] |
| 47 | 0.63 ms |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.etat AS etat_3, t0.valeur_payer AS valeur_payer_4, t0.date_insertion AS date_insertion_5, t0.mois AS mois_6, t0.nb_mois AS nb_mois_7, t0.montant_mois AS montant_mois_8, t0.adherent_id AS adherent_id_9, t0.type_prestation_id AS type_prestation_id_10, t0.annee_exercice_id AS annee_exercice_id_11, t0.parking_id AS parking_id_12, t0.enfant_id AS enfant_id_13 FROM prestation t0 WHERE t0.adherent_id = ?
Parameters:
[
43
]
|
| 48 | 0.43 ms |
SELECT t0.id AS id_1, t0.lib AS lib_2, t0.description AS description_3, t0.etat AS etat_4, t0.taux AS taux_5, t0.valeut_max AS valeut_max_6, t0.perodisite AS perodisite_7, t0.palfont AS palfont_8 FROM type_prestation t0 WHERE t0.id = ?
Parameters:
[
11
]
|
| 49 | 0.38 ms |
SELECT t0.id AS id_1, t0.annee AS annee_2, t0.palafon AS palafon_3, t0.date_insertion AS date_insertion_4, t0.amicale_id AS amicale_id_5 FROM annee_exercice t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 50 | 0.38 ms |
SELECT t0.id AS id_1, t0.lib AS lib_2, t0.description AS description_3, t0.etat AS etat_4, t0.taux AS taux_5, t0.valeut_max AS valeut_max_6, t0.perodisite AS perodisite_7, t0.palfont AS palfont_8 FROM type_prestation t0 WHERE t0.id = ?
Parameters:
[
15
]
|
| 51 | 0.41 ms |
SELECT t0.id AS id_1, t0.lib AS lib_2, t0.description AS description_3, t0.etat AS etat_4, t0.taux AS taux_5, t0.valeut_max AS valeut_max_6, t0.perodisite AS perodisite_7, t0.palfont AS palfont_8 FROM type_prestation t0 WHERE t0.id = ?
Parameters:
[
17
]
|
| 52 | 0.42 ms |
SELECT t0.id AS id_1, t0.annee AS annee_2, t0.palafon AS palafon_3, t0.date_insertion AS date_insertion_4, t0.amicale_id AS amicale_id_5 FROM annee_exercice t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 53 | 0.38 ms |
SELECT t0.id AS id_1, t0.lib AS lib_2, t0.description AS description_3, t0.etat AS etat_4, t0.taux AS taux_5, t0.valeut_max AS valeut_max_6, t0.perodisite AS perodisite_7, t0.palfont AS palfont_8 FROM type_prestation t0 WHERE t0.id = ?
Parameters:
[
18
]
|
| 54 | 0.46 ms |
SELECT t0.id AS id_1, t0.annee AS annee_2, t0.palafon AS palafon_3, t0.date_insertion AS date_insertion_4, t0.amicale_id AS amicale_id_5 FROM annee_exercice t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 55 | 0.57 ms |
SELECT t0.id AS id_1, t0.lib AS lib_2, t0.description AS description_3, t0.etat AS etat_4, t0.taux AS taux_5, t0.valeut_max AS valeut_max_6, t0.perodisite AS perodisite_7, t0.palfont AS palfont_8 FROM type_prestation t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 56 | 0.45 ms |
SELECT t0.id AS id_1, t0.annee AS annee_2, t0.palafon AS palafon_3, t0.date_insertion AS date_insertion_4, t0.amicale_id AS amicale_id_5 FROM annee_exercice t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 57 | 0.38 ms |
SELECT t0.id AS id_1, t0.lib AS lib_2, t0.description AS description_3, t0.etat AS etat_4, t0.taux AS taux_5, t0.valeut_max AS valeut_max_6, t0.perodisite AS perodisite_7, t0.palfont AS palfont_8 FROM type_prestation t0 WHERE t0.id = ?
Parameters:
[
16
]
|
| 58 | 2.27 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.date_naissance AS date_naissance_4, t0.adherent_id AS adherent_id_5, t0.class_etude_id AS class_etude_id_6 FROM enfant t0 WHERE t0.adherent_id = ?
Parameters:
[
43
]
|
| 59 | 1.01 ms |
SELECT t0.id AS id_1, t0.lib AS lib_2, t0.motant_inscription AS motant_inscription_3, t0.montant_reuissite AS montant_reuissite_4 FROM classe_etude t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 60 | 0.68 ms |
SELECT t0.id AS id_1, t0.lib AS lib_2, t0.motant_inscription AS motant_inscription_3, t0.montant_reuissite AS montant_reuissite_4 FROM classe_etude t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 61 | 2.34 ms |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.date AS date_3, t0.etat AS etat_4, t0.valeur_restante AS valeur_restante_5, t0.adherent_id AS adherent_id_6, t0.type_prestation_id AS type_prestation_id_7, t0.facture_id AS facture_id_8 FROM dette t0 WHERE t0.adherent_id = ?
Parameters:
[
43
]
|
| 62 | 24.41 ms |
SELECT t0.id AS id_1, t0.lib AS lib_2, t0.decription AS decription_3, t0.date_insertion AS date_insertion_4, t0.valeur AS valeur_5, t0.valeur_payer AS valeur_payer_6, t0.mantant_payer_par_ladherent AS mantant_payer_par_ladherent_7, t0.mantant_payer_par_amicale AS mantant_payer_par_amicale_8, t0.montant_htc AS montant_htc_9, t0.tva AS tva_10, t0.adherent_id AS adherent_id_11, t0.fournisseur_id AS fournisseur_id_12 FROM facture t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 63 | 0.43 ms |
SELECT t0.id AS id_1, t0.lib AS lib_2, t0.description AS description_3, t0.etat AS etat_4, t0.taux AS taux_5, t0.valeut_max AS valeut_max_6, t0.perodisite AS perodisite_7, t0.palfont AS palfont_8 FROM type_prestation t0 WHERE t0.id = ?
Parameters:
[
8
]
|
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\Adherent | No errors. |
| App\Entity\Vehicule | No errors. |
| App\Entity\Parking | No errors. |
| App\Entity\Prestation | No errors. |
| App\Entity\Facture | No errors. |
| App\Entity\Dette |
|
| App\Entity\Prime | No errors. |
| App\Entity\Enfant | No errors. |
| App\Entity\AnneeExercice | No errors. |
| App\Entity\Amicale | No errors. |
| App\Entity\Verssement | No errors. |
| App\Entity\TypePrestation | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\PrimeTypePrestation | No errors. |
| App\Entity\ClasseEtude | No errors. |
| App\Entity\RempoursementDette | No errors. |
| App\Entity\Fournisseur | No errors. |