Symfony Profiler

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 = ?

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 = 1;

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 = ?

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 = 6;

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 = ?

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 = 'Payer' AND p0_.etat = 'Payer' AND p0_.annee_exercice_id = 6;

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

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;

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 = ?

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 = 11;

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 = ?

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 = 43;

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 = ?

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 = 43;

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 = ?

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 = 2;

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 = ?

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 = 1;

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 = ?

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 = 3;

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

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 = '43' AND p1_.annee_exercice_id = '6' GROUP BY t0_.lib;

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 = ?

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 = '43';

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 = ?

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 = 6 AND p0_.adherent_id = '43';

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 = ?

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 = 6 AND p0_.adherent_id = '43';

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 = ?

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 = 43;

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

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 = '6' AND p0_.type_prestation_id = '9' AND p0_.adherent_id = '43' ORDER BY p0_.id DESC;

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

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 = '6' ORDER BY a0_.id DESC LIMIT 1;