Symfony Profiler

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

SELECT
  a0_.id AS id_0,
  a0_.nom AS nom_1,
  a0_.prenom AS prenom_2,
  a0_.numero_adhesion AS numero_adhesion_3,
  a0_.email AS email_4,
  a0_.salaire_brute AS salaire_brute_5,
  a0_.rip AS rip_6,
  a0_.forfait_telecom AS forfait_telecom_7,
  a0_.nom_prenom AS nom_prenom_8,
  a0_.matricule AS matricule_9,
  a0_.rang AS rang_10,
  a0_.etat AS etat_11,
  a0_.marier AS marier_12,
  a0_.conjoint AS conjoint_13,
  a0_.fin_forfait AS fin_forfait_14,
  a0_.user_compte_id AS user_compte_id_15
FROM
  adherent a0_
WHERE
  a0_.user_compte_id = ?
ORDER BY
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.prenom AS prenom_2, a0_.numero_adhesion AS numero_adhesion_3, a0_.email AS email_4, a0_.salaire_brute AS salaire_brute_5, a0_.rip AS rip_6, a0_.forfait_telecom AS forfait_telecom_7, a0_.nom_prenom AS nom_prenom_8, a0_.matricule AS matricule_9, a0_.rang AS rang_10, a0_.etat AS etat_11, a0_.marier AS marier_12, a0_.conjoint AS conjoint_13, a0_.fin_forfait AS fin_forfait_14, a0_.user_compte_id AS user_compte_id_15 FROM adherent a0_ WHERE a0_.user_compte_id = '120' ORDER BY a0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.immatriculation AS immatriculation_2,
  t0.marque AS marque_3,
  t0.modele AS modele_4,
  t0.couleur AS couleur_5,
  t0.mois_debut AS mois_debut_6,
  t0.mois_fin AS mois_fin_7,
  t0.adherent_id AS adherent_id_8,
  t0.parking_id AS parking_id_9
FROM
  vehicule t0
WHERE
  t0.adherent_id = ?

SELECT t0.id AS id_1, t0.immatriculation AS immatriculation_2, t0.marque AS marque_3, t0.modele AS modele_4, t0.couleur AS couleur_5, t0.mois_debut AS mois_debut_6, t0.mois_fin AS mois_fin_7, t0.adherent_id AS adherent_id_8, t0.parking_id AS parking_id_9 FROM vehicule t0 WHERE t0.adherent_id = 45;

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_.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_ 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_
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
  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 = '45';

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

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

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

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 = '45' ORDER BY p0_.id DESC;

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

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.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 = 4;

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

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

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

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

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