Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.reset_token AS reset_token_4,
  t0.password AS password_5,
  t0.email AS email_6,
  t0.personne_id AS personne_id_7
FROM
  user_utilisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.reset_token AS reset_token_4, t0.password AS password_5, t0.email AS email_6, t0.personne_id AS personne_id_7 FROM user_utilisateur t0 WHERE t0.id = 1429;

SELECT
  t0.id AS id_3,
  t0.nom AS nom_4,
  t0.prenom AS prenom_5,
  t0.date_naissance AS date_naissance_6,
  t0.lieu_naissance AS lieu_naissance_7,
  t0.email AS email_8,
  t0.contact AS contact_9,
  t0.genre_id AS genre_id_10,
  t0.civilite_id AS civilite_id_11,
  t0.fonction_id AS fonction_id_12,
  t0.discr,
  t2.ville AS ville_13,
  t2.adresse AS adresse_14,
  t2.boite AS boite_15,
  t2.fax AS fax_16,
  t2.employeur AS employeur_17,
  t2.bailleur AS bailleur_18,
  t2.parent AS parent_19,
  t2.autre AS autre_20,
  t2.radio AS radio_21,
  t2.presse AS presse_22,
  t2.affiche AS affiche_23,
  t2.ministere AS ministere_24,
  t2.mailing AS mailing_25,
  t2.site_web AS site_web_26,
  t2.vous_meme AS vous_meme_27,
  t2.professeur AS professeur_28,
  t2.ami_collegue AS ami_collegue_29,
  t2.autre_existence AS autre_existence_30,
  t2.etat AS etat_31,
  t2.numero_whatsapp AS numero_whatsapp_32,
  t2.statut_travail AS statut_travail_33,
  t2.travail AS travail_34,
  t2.statut_etudiant AS statut_etudiant_35,
  t2.filiere_id AS filiere_id_36,
  t2.pays_id AS pays_id_37,
  t2.nationalite_id AS nationalite_id_38
FROM
  user_personne t0
  LEFT JOIN user_employe t1 ON t0.id = t1.id
  LEFT JOIN user_etudiant t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.date_naissance AS date_naissance_6, t0.lieu_naissance AS lieu_naissance_7, t0.email AS email_8, t0.contact AS contact_9, t0.genre_id AS genre_id_10, t0.civilite_id AS civilite_id_11, t0.fonction_id AS fonction_id_12, t0.discr, t2.ville AS ville_13, t2.adresse AS adresse_14, t2.boite AS boite_15, t2.fax AS fax_16, t2.employeur AS employeur_17, t2.bailleur AS bailleur_18, t2.parent AS parent_19, t2.autre AS autre_20, t2.radio AS radio_21, t2.presse AS presse_22, t2.affiche AS affiche_23, t2.ministere AS ministere_24, t2.mailing AS mailing_25, t2.site_web AS site_web_26, t2.vous_meme AS vous_meme_27, t2.professeur AS professeur_28, t2.ami_collegue AS ami_collegue_29, t2.autre_existence AS autre_existence_30, t2.etat AS etat_31, t2.numero_whatsapp AS numero_whatsapp_32, t2.statut_travail AS statut_travail_33, t2.travail AS travail_34, t2.statut_etudiant AS statut_etudiant_35, t2.filiere_id AS filiere_id_36, t2.pays_id AS pays_id_37, t2.nationalite_id AS nationalite_id_38 FROM user_personne t0 LEFT JOIN user_employe t1 ON t0.id = t1.id LEFT JOIN user_etudiant t2 ON t0.id = t2.id WHERE t0.id = 1539;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.reset_token AS reset_token_4,
  t0.password AS password_5,
  t0.email AS email_6,
  t0.personne_id AS personne_id_7
FROM
  user_utilisateur t0
WHERE
  t0.personne_id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.reset_token AS reset_token_4, t0.password AS password_5, t0.email AS email_6, t0.personne_id AS personne_id_7 FROM user_utilisateur t0 WHERE t0.personne_id = 1539;

SELECT
  t0.id AS id_1,
  t0.utilisateur_id AS utilisateur_id_2,
  t0.groupe_id AS groupe_id_3
FROM
  user_utilisateur_groupe t0
WHERE
  t0.utilisateur_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.utilisateur_id AS utilisateur_id_2, t0.groupe_id AS groupe_id_3 FROM user_utilisateur_groupe t0 WHERE t0.utilisateur_id = 1429 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.roles AS roles_4
FROM
  user_groupe t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.roles AS roles_4 FROM user_groupe t0 WHERE t0.id = 3;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  compta_preinscription c0_
  INNER JOIN user_etudiant u1_ ON c0_.etudiant_id = u1_.id
  LEFT JOIN user_personne u2_ ON u1_.id = u2_.id
  INNER JOIN param_niveau p3_ ON c0_.niveau_id = p3_.id
  INNER JOIN user_employe u4_ ON p3_.responsable_id = u4_.id
  LEFT JOIN user_personne u5_ ON u4_.id = u5_.id
  INNER JOIN param_filiere p6_ ON p3_.filiere_id = p6_.id
WHERE
  c0_.etat = ?
  AND u2_.id = ?
  AND p3_.annee_scolaire_id = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM compta_preinscription c0_ INNER JOIN user_etudiant u1_ ON c0_.etudiant_id = u1_.id LEFT JOIN user_personne u2_ ON u1_.id = u2_.id INNER JOIN param_niveau p3_ ON c0_.niveau_id = p3_.id INNER JOIN user_employe u4_ ON p3_.responsable_id = u4_.id LEFT JOIN user_personne u5_ ON u4_.id = u5_.id INNER JOIN param_filiere p6_ ON p3_.filiere_id = p6_.id WHERE c0_.etat = 'attente_validation' AND u2_.id = 1539 AND p3_.annee_scolaire_id = 11;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  compta_preinscription c0_
  INNER JOIN user_etudiant u1_ ON c0_.etudiant_id = u1_.id
  LEFT JOIN user_personne u2_ ON u1_.id = u2_.id
  INNER JOIN param_niveau p3_ ON c0_.niveau_id = p3_.id
  INNER JOIN user_employe u4_ ON p3_.responsable_id = u4_.id
  LEFT JOIN user_personne u5_ ON u4_.id = u5_.id
  INNER JOIN param_filiere p6_ ON p3_.filiere_id = p6_.id
WHERE
  c0_.etat = ?
  AND u2_.id = ?
  AND p3_.annee_scolaire_id = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM compta_preinscription c0_ INNER JOIN user_etudiant u1_ ON c0_.etudiant_id = u1_.id LEFT JOIN user_personne u2_ ON u1_.id = u2_.id INNER JOIN param_niveau p3_ ON c0_.niveau_id = p3_.id INNER JOIN user_employe u4_ ON p3_.responsable_id = u4_.id LEFT JOIN user_personne u5_ ON u4_.id = u5_.id INNER JOIN param_filiere p6_ ON p3_.filiere_id = p6_.id WHERE c0_.etat = 'attente_validation' AND u2_.id = 1539 AND p3_.annee_scolaire_id = 11;

SELECT
  c0_.id AS id_0,
  c0_.date_preinscription AS date_preinscription_1,
  c0_.etat AS etat_2,
  c0_.code AS code_3,
  c0_.etat_deliberation AS etat_deliberation_4,
  c0_.date_validation AS date_validation_5,
  c0_.commentaire AS commentaire_6,
  c0_.montant AS montant_7,
  u1_.id AS id_8,
  u1_.nom AS nom_9,
  u1_.prenom AS prenom_10,
  u1_.date_naissance AS date_naissance_11,
  u1_.lieu_naissance AS lieu_naissance_12,
  u1_.email AS email_13,
  u1_.contact AS contact_14,
  u2_.ville AS ville_15,
  u2_.adresse AS adresse_16,
  u2_.boite AS boite_17,
  u2_.fax AS fax_18,
  u2_.employeur AS employeur_19,
  u2_.bailleur AS bailleur_20,
  u2_.parent AS parent_21,
  u2_.autre AS autre_22,
  u2_.radio AS radio_23,
  u2_.presse AS presse_24,
  u2_.affiche AS affiche_25,
  u2_.ministere AS ministere_26,
  u2_.mailing AS mailing_27,
  u2_.site_web AS site_web_28,
  u2_.vous_meme AS vous_meme_29,
  u2_.professeur AS professeur_30,
  u2_.ami_collegue AS ami_collegue_31,
  u2_.autre_existence AS autre_existence_32,
  u2_.etat AS etat_33,
  u2_.numero_whatsapp AS numero_whatsapp_34,
  u2_.statut_travail AS statut_travail_35,
  u2_.travail AS travail_36,
  u2_.statut_etudiant AS statut_etudiant_37,
  p3_.id AS id_38,
  p3_.code AS code_39,
  p3_.libelle AS libelle_40,
  p3_.passage_examen AS passage_examen_41,
  u4_.id AS id_42,
  u4_.nom AS nom_43,
  u4_.prenom AS prenom_44,
  u4_.date_naissance AS date_naissance_45,
  u4_.lieu_naissance AS lieu_naissance_46,
  u4_.email AS email_47,
  u4_.contact AS contact_48,
  p5_.id AS id_49,
  p5_.code AS code_50,
  p5_.libelle AS libelle_51,
  p5_.description AS description_52,
  p5_.montant_preinscription AS montant_preinscription_53,
  c0_.niveau_id AS niveau_id_54,
  c0_.etudiant_id AS etudiant_id_55,
  c0_.utilisateur_id AS utilisateur_id_56,
  c0_.caissiere_id AS caissiere_id_57,
  u1_.discr AS discr_58,
  u1_.genre_id AS genre_id_59,
  u1_.civilite_id AS civilite_id_60,
  u1_.fonction_id AS fonction_id_61,
  u2_.filiere_id AS filiere_id_62,
  u2_.pays_id AS pays_id_63,
  u2_.nationalite_id AS nationalite_id_64,
  p3_.filiere_id AS filiere_id_65,
  p3_.responsable_id AS responsable_id_66,
  p3_.promotion_id AS promotion_id_67,
  p3_.annee_scolaire_id AS annee_scolaire_id_68,
  u4_.discr AS discr_69,
  u4_.genre_id AS genre_id_70,
  u4_.civilite_id AS civilite_id_71,
  u4_.fonction_id AS fonction_id_72,
  p5_.fichier_id AS fichier_id_73
FROM
  compta_preinscription c0_
  INNER JOIN user_etudiant u2_ ON c0_.etudiant_id = u2_.id
  LEFT JOIN user_personne u1_ ON u2_.id = u1_.id
  INNER JOIN param_niveau p3_ ON c0_.niveau_id = p3_.id
  INNER JOIN user_employe u6_ ON p3_.responsable_id = u6_.id
  LEFT JOIN user_personne u4_ ON u6_.id = u4_.id
  INNER JOIN param_filiere p5_ ON p3_.filiere_id = p5_.id
WHERE
  c0_.etat = ?
  AND u1_.id = ?
  AND p3_.annee_scolaire_id = ?
LIMIT
  50

SELECT c0_.id AS id_0, c0_.date_preinscription AS date_preinscription_1, c0_.etat AS etat_2, c0_.code AS code_3, c0_.etat_deliberation AS etat_deliberation_4, c0_.date_validation AS date_validation_5, c0_.commentaire AS commentaire_6, c0_.montant AS montant_7, u1_.id AS id_8, u1_.nom AS nom_9, u1_.prenom AS prenom_10, u1_.date_naissance AS date_naissance_11, u1_.lieu_naissance AS lieu_naissance_12, u1_.email AS email_13, u1_.contact AS contact_14, u2_.ville AS ville_15, u2_.adresse AS adresse_16, u2_.boite AS boite_17, u2_.fax AS fax_18, u2_.employeur AS employeur_19, u2_.bailleur AS bailleur_20, u2_.parent AS parent_21, u2_.autre AS autre_22, u2_.radio AS radio_23, u2_.presse AS presse_24, u2_.affiche AS affiche_25, u2_.ministere AS ministere_26, u2_.mailing AS mailing_27, u2_.site_web AS site_web_28, u2_.vous_meme AS vous_meme_29, u2_.professeur AS professeur_30, u2_.ami_collegue AS ami_collegue_31, u2_.autre_existence AS autre_existence_32, u2_.etat AS etat_33, u2_.numero_whatsapp AS numero_whatsapp_34, u2_.statut_travail AS statut_travail_35, u2_.travail AS travail_36, u2_.statut_etudiant AS statut_etudiant_37, p3_.id AS id_38, p3_.code AS code_39, p3_.libelle AS libelle_40, p3_.passage_examen AS passage_examen_41, u4_.id AS id_42, u4_.nom AS nom_43, u4_.prenom AS prenom_44, u4_.date_naissance AS date_naissance_45, u4_.lieu_naissance AS lieu_naissance_46, u4_.email AS email_47, u4_.contact AS contact_48, p5_.id AS id_49, p5_.code AS code_50, p5_.libelle AS libelle_51, p5_.description AS description_52, p5_.montant_preinscription AS montant_preinscription_53, c0_.niveau_id AS niveau_id_54, c0_.etudiant_id AS etudiant_id_55, c0_.utilisateur_id AS utilisateur_id_56, c0_.caissiere_id AS caissiere_id_57, u1_.discr AS discr_58, u1_.genre_id AS genre_id_59, u1_.civilite_id AS civilite_id_60, u1_.fonction_id AS fonction_id_61, u2_.filiere_id AS filiere_id_62, u2_.pays_id AS pays_id_63, u2_.nationalite_id AS nationalite_id_64, p3_.filiere_id AS filiere_id_65, p3_.responsable_id AS responsable_id_66, p3_.promotion_id AS promotion_id_67, p3_.annee_scolaire_id AS annee_scolaire_id_68, u4_.discr AS discr_69, u4_.genre_id AS genre_id_70, u4_.civilite_id AS civilite_id_71, u4_.fonction_id AS fonction_id_72, p5_.fichier_id AS fichier_id_73 FROM compta_preinscription c0_ INNER JOIN user_etudiant u2_ ON c0_.etudiant_id = u2_.id LEFT JOIN user_personne u1_ ON u2_.id = u1_.id INNER JOIN param_niveau p3_ ON c0_.niveau_id = p3_.id INNER JOIN user_employe u6_ ON p3_.responsable_id = u6_.id LEFT JOIN user_personne u4_ ON u6_.id = u4_.id INNER JOIN param_filiere p5_ ON p3_.filiere_id = p5_.id WHERE c0_.etat = 'attente_validation' AND u1_.id = 1539 AND p3_.annee_scolaire_id = 11 LIMIT 50;