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

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

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

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.code AS code_3
FROM
  param_fonction t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM param_fonction t0 WHERE t0.id = 2;

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 param_filiere p4_ ON p3_.filiere_id = p4_.id
  INNER JOIN user_employe u5_ ON p3_.responsable_id = u5_.id
  LEFT JOIN user_personne u6_ ON u5_.id = u6_.id
  LEFT JOIN user_utilisateur u7_ ON c0_.caissiere_id = u7_.id
WHERE
  c0_.etat = ?
  AND c0_.etudiant_id = ?
  AND p3_.annee_scolaire_id = ?
  AND u1_.etat = ?

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 param_filiere p4_ ON p3_.filiere_id = p4_.id INNER JOIN user_employe u5_ ON p3_.responsable_id = u5_.id LEFT JOIN user_personne u6_ ON u5_.id = u6_.id LEFT JOIN user_utilisateur u7_ ON c0_.caissiere_id = u7_.id WHERE c0_.etat = 'attente_paiement' AND c0_.etudiant_id = 1663 AND p3_.annee_scolaire_id = 11 AND u1_.etat = 'complete';

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 param_filiere p4_ ON p3_.filiere_id = p4_.id
  INNER JOIN user_employe u5_ ON p3_.responsable_id = u5_.id
  LEFT JOIN user_personne u6_ ON u5_.id = u6_.id
  LEFT JOIN user_utilisateur u7_ ON c0_.caissiere_id = u7_.id
WHERE
  c0_.etat = ?
  AND c0_.etudiant_id = ?
  AND p3_.annee_scolaire_id = ?
  AND u1_.etat = ?

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 param_filiere p4_ ON p3_.filiere_id = p4_.id INNER JOIN user_employe u5_ ON p3_.responsable_id = u5_.id LEFT JOIN user_personne u6_ ON u5_.id = u6_.id LEFT JOIN user_utilisateur u7_ ON c0_.caissiere_id = u7_.id WHERE c0_.etat = 'attente_paiement' AND c0_.etudiant_id = 1663 AND p3_.annee_scolaire_id = 11 AND u1_.etat = 'complete';

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,
  p4_.id AS id_42,
  p4_.code AS code_43,
  p4_.libelle AS libelle_44,
  p4_.description AS description_45,
  p4_.montant_preinscription AS montant_preinscription_46,
  u5_.id AS id_47,
  u5_.nom AS nom_48,
  u5_.prenom AS prenom_49,
  u5_.date_naissance AS date_naissance_50,
  u5_.lieu_naissance AS lieu_naissance_51,
  u5_.email AS email_52,
  u5_.contact AS contact_53,
  u6_.id AS id_54,
  u6_.username AS username_55,
  u6_.roles AS roles_56,
  u6_.reset_token AS reset_token_57,
  u6_.password AS password_58,
  u6_.email AS email_59,
  c0_.niveau_id AS niveau_id_60,
  c0_.etudiant_id AS etudiant_id_61,
  c0_.utilisateur_id AS utilisateur_id_62,
  c0_.caissiere_id AS caissiere_id_63,
  u1_.discr AS discr_64,
  u1_.genre_id AS genre_id_65,
  u1_.civilite_id AS civilite_id_66,
  u1_.fonction_id AS fonction_id_67,
  u2_.filiere_id AS filiere_id_68,
  u2_.pays_id AS pays_id_69,
  u2_.nationalite_id AS nationalite_id_70,
  p3_.filiere_id AS filiere_id_71,
  p3_.responsable_id AS responsable_id_72,
  p3_.promotion_id AS promotion_id_73,
  p3_.annee_scolaire_id AS annee_scolaire_id_74,
  p4_.fichier_id AS fichier_id_75,
  u5_.discr AS discr_76,
  u5_.genre_id AS genre_id_77,
  u5_.civilite_id AS civilite_id_78,
  u5_.fonction_id AS fonction_id_79,
  u6_.personne_id AS personne_id_80
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 param_filiere p4_ ON p3_.filiere_id = p4_.id
  INNER JOIN user_employe u7_ ON p3_.responsable_id = u7_.id
  LEFT JOIN user_personne u5_ ON u7_.id = u5_.id
  LEFT JOIN user_utilisateur u6_ ON c0_.caissiere_id = u6_.id
WHERE
  c0_.etat = ?
  AND c0_.etudiant_id = ?
  AND p3_.annee_scolaire_id = ?
  AND u2_.etat = ?
ORDER BY
  c0_.date_preinscription DESC
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, p4_.id AS id_42, p4_.code AS code_43, p4_.libelle AS libelle_44, p4_.description AS description_45, p4_.montant_preinscription AS montant_preinscription_46, u5_.id AS id_47, u5_.nom AS nom_48, u5_.prenom AS prenom_49, u5_.date_naissance AS date_naissance_50, u5_.lieu_naissance AS lieu_naissance_51, u5_.email AS email_52, u5_.contact AS contact_53, u6_.id AS id_54, u6_.username AS username_55, u6_.roles AS roles_56, u6_.reset_token AS reset_token_57, u6_.password AS password_58, u6_.email AS email_59, c0_.niveau_id AS niveau_id_60, c0_.etudiant_id AS etudiant_id_61, c0_.utilisateur_id AS utilisateur_id_62, c0_.caissiere_id AS caissiere_id_63, u1_.discr AS discr_64, u1_.genre_id AS genre_id_65, u1_.civilite_id AS civilite_id_66, u1_.fonction_id AS fonction_id_67, u2_.filiere_id AS filiere_id_68, u2_.pays_id AS pays_id_69, u2_.nationalite_id AS nationalite_id_70, p3_.filiere_id AS filiere_id_71, p3_.responsable_id AS responsable_id_72, p3_.promotion_id AS promotion_id_73, p3_.annee_scolaire_id AS annee_scolaire_id_74, p4_.fichier_id AS fichier_id_75, u5_.discr AS discr_76, u5_.genre_id AS genre_id_77, u5_.civilite_id AS civilite_id_78, u5_.fonction_id AS fonction_id_79, u6_.personne_id AS personne_id_80 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 param_filiere p4_ ON p3_.filiere_id = p4_.id INNER JOIN user_employe u7_ ON p3_.responsable_id = u7_.id LEFT JOIN user_personne u5_ ON u7_.id = u5_.id LEFT JOIN user_utilisateur u6_ ON c0_.caissiere_id = u6_.id WHERE c0_.etat = 'attente_paiement' AND c0_.etudiant_id = 1663 AND p3_.annee_scolaire_id = 11 AND u2_.etat = 'complete' ORDER BY c0_.date_preinscription DESC LIMIT 50;

SELECT
  t0.id AS id_1,
  t0.montant AS montant_2,
  t0.date_paiement AS date_paiement_3,
  t0.utilisateur_id AS utilisateur_id_4,
  t0.preinscription_id AS preinscription_id_5,
  t0.mode_paiement_id AS mode_paiement_id_6
FROM
  compta_info_preinscription t0
WHERE
  t0.preinscription_id = ?

SELECT t0.id AS id_1, t0.montant AS montant_2, t0.date_paiement AS date_paiement_3, t0.utilisateur_id AS utilisateur_id_4, t0.preinscription_id AS preinscription_id_5, t0.mode_paiement_id AS mode_paiement_id_6 FROM compta_info_preinscription t0 WHERE t0.preinscription_id = 2250;

SELECT
  t0.id AS id_1,
  t0.preinscription_id AS preinscription_id_2,
  t0.deliberation_id AS deliberation_id_3
FROM
  dir_deliberation_preinscription t0
WHERE
  t0.preinscription_id = ?

SELECT t0.id AS id_1, t0.preinscription_id AS preinscription_id_2, t0.deliberation_id AS deliberation_id_3 FROM dir_deliberation_preinscription t0 WHERE t0.preinscription_id = 2250;

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

SELECT
  t0.id AS id_1,
  t0.size AS size_2,
  t0.path AS path_3,
  t0.alt AS alt_4,
  t0.date_creation AS date_creation_5,
  t0.url AS url_6
FROM
  param_fichier t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.size AS size_2, t0.path AS path_3, t0.alt AS alt_4, t0.date_creation AS date_creation_5, t0.url AS url_6 FROM param_fichier t0 WHERE t0.id IN (5463);

SELECT
  t0.id AS id_1,
  t0.montant AS montant_2,
  t0.date_paiement AS date_paiement_3,
  t0.utilisateur_id AS utilisateur_id_4,
  t0.preinscription_id AS preinscription_id_5,
  t0.mode_paiement_id AS mode_paiement_id_6
FROM
  compta_info_preinscription t0
WHERE
  t0.preinscription_id = ?

SELECT t0.id AS id_1, t0.montant AS montant_2, t0.date_paiement AS date_paiement_3, t0.utilisateur_id AS utilisateur_id_4, t0.preinscription_id AS preinscription_id_5, t0.mode_paiement_id AS mode_paiement_id_6 FROM compta_info_preinscription t0 WHERE t0.preinscription_id = 2252;

SELECT
  t0.id AS id_1,
  t0.preinscription_id AS preinscription_id_2,
  t0.deliberation_id AS deliberation_id_3
FROM
  dir_deliberation_preinscription t0
WHERE
  t0.preinscription_id = ?

SELECT t0.id AS id_1, t0.preinscription_id AS preinscription_id_2, t0.deliberation_id AS deliberation_id_3 FROM dir_deliberation_preinscription t0 WHERE t0.preinscription_id = 2252;

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

SELECT
  t0.id AS id_1,
  t0.size AS size_2,
  t0.path AS path_3,
  t0.alt AS alt_4,
  t0.date_creation AS date_creation_5,
  t0.url AS url_6
FROM
  param_fichier t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.size AS size_2, t0.path AS path_3, t0.alt AS alt_4, t0.date_creation AS date_creation_5, t0.url AS url_6 FROM param_fichier t0 WHERE t0.id IN (5462);