Symfony Profiler

SELECT
  t0.id_utilisateur AS id_utilisateur_1,
  t0.login_utilisateur AS login_utilisateur_2,
  t0.password_encrypted_utilisateur AS password_encrypted_utilisateur_3,
  t0.is_verified AS is_verified_4,
  t0.mode_utilisateur AS mode_utilisateur_5,
  t0.type_abonnement AS type_abonnement_6,
  t0.date_demande_inscription AS date_demande_inscription_7,
  t0.date_demande_inscription_complete AS date_demande_inscription_complete_8,
  t0.date_relance AS date_relance_9,
  t0.date_inscription_reelle AS date_inscription_reelle_10,
  t0.langue_utilisee AS langue_utilisee_11,
  t0.type_utilisateur AS type_utilisateur_12,
  t0.nom_utilisateur AS nom_utilisateur_13,
  t0.prenom_utilisateur AS prenom_utilisateur_14,
  t0.email_utilisateur AS email_utilisateur_15,
  t0.societe_utilisateur AS societe_utilisateur_16,
  t0.rcs_utilisateur AS rcs_utilisateur_17,
  t0.relance_mail_utilisateur AS relance_mail_utilisateur_18,
  t0.pieces_necessaires AS pieces_necessaires_19,
  t0.pays_utilisateur AS pays_utilisateur_20,
  t0.region_utilisateur AS region_utilisateur_21,
  t0.ville_utilisateur AS ville_utilisateur_22,
  t0.code_postal_utilisateur AS code_postal_utilisateur_23,
  t0.adresse_utilisateur AS adresse_utilisateur_24,
  t0.commentaire_utilisateur AS commentaire_utilisateur_25,
  t0.litige_utilisateur AS litige_utilisateur_26,
  t0.compte_facturation AS compte_facturation_27,
  t0.factur_nom_societe AS factur_nom_societe_28,
  t0.factur_adresse AS factur_adresse_29,
  t0.factur_code_postal AS factur_code_postal_30,
  t0.factur_ville AS factur_ville_31,
  t0.factur_pays AS factur_pays_32,
  t0.factur_id_pays AS factur_id_pays_33,
  t0.id_type_structure AS id_type_structure_34,
  t0.telephone_utilisateur AS telephone_utilisateur_35,
  t0.indicatif_tel AS indicatif_tel_36,
  t0.id_structure AS id_structure_37,
  t0.id_gestionnaire_fonds AS id_gestionnaire_fonds_38,
  t0.fonction_utilisateur AS fonction_utilisateur_39,
  t0.lien_internet AS lien_internet_40,
  t0.tva_intracommunautaire AS tva_intracommunautaire_41,
  t0.id_client_publicite AS id_client_publicite_42,
  t0.inscription_partenaire AS inscription_partenaire_43,
  t0.site_partenaire AS site_partenaire_44,
  t0.provenance_connexion_fusacq AS provenance_connexion_fusacq_45,
  t0.suivi AS suivi_46,
  t0.date_derniere_connexion AS date_derniere_connexion_47,
  t0.date_desinscription_fusacq AS date_desinscription_fusacq_48,
  t0.type_commande AS type_commande_49,
  t0.date_derniere_commande AS date_derniere_commande_50,
  t0.date_dernier_depot_annonce AS date_dernier_depot_annonce_51,
  t0.etat_relance AS etat_relance_52,
  t0.agence_utilisateur AS agence_utilisateur_53,
  t0.cookie_authentification AS cookie_authentification_54,
  t0.id_pays_utilisateur AS id_pays_utilisateur_55,
  t0.id_region AS id_region_56,
  t0.contact_suite_inscription AS contact_suite_inscription_57,
  t0.id_societe_prestataire AS id_societe_prestataire_58,
  t0.association_societe_prestataire AS association_societe_prestataire_59,
  t0.mail_note_qualite_mer AS mail_note_qualite_mer_60,
  t0.provenance_notoriete_fusacq AS provenance_notoriete_fusacq_61,
  t0.id_reseau_commerce AS id_reseau_commerce_62,
  t0.montant_contact_defaut AS montant_contact_defaut_63,
  t0.montant_contact_international_defaut AS montant_contact_international_defaut_64,
  t0.type_utilisateur_commerce AS type_utilisateur_commerce_65,
  t0.annee_naissance AS annee_naissance_66,
  t0.civilite AS civilite_67,
  t0.inscription_validee AS inscription_validee_68,
  t0.plateforme_inscription AS plateforme_inscription_69,
  t0.frequence_envoi_alertes_commerces AS frequence_envoi_alertes_commerces_70,
  t0.date_dernier_envoi_alerte_commerces AS date_dernier_envoi_alerte_commerces_71,
  t0.mode_reglement_commerce AS mode_reglement_commerce_72,
  t0.id_agence_commerce AS id_agence_commerce_73,
  t0.provenance_connexion_commerces AS provenance_connexion_commerces_74,
  t0.importer_annonces_pdc_sur_ce_compte AS importer_annonces_pdc_sur_ce_compte_75,
  t0.email_invalide AS email_invalide_76,
  t0.personne_societe AS personne_societe_77,
  t0.type_utilisateur_franchise AS type_utilisateur_franchise_78,
  t0.mode_reglement_franchise AS mode_reglement_franchise_79,
  t0.montant_cv_defaut AS montant_cv_defaut_80,
  t0.montant_cv_international_defaut AS montant_cv_international_defaut_81,
  t0.id_cv AS id_cv_82,
  t0.telephone_utilisateur_back AS telephone_utilisateur_back_83,
  t0.site_derniere_connexion AS site_derniere_connexion_84,
  t0.date_derniere_notification_propose_cv_pdc AS date_derniere_notification_propose_cv_pdc_85,
  t0.devise AS devise_86,
  t0.id_pays_tarif_applicable AS id_pays_tarif_applicable_87,
  t0.identifiant_entreprise AS identifiant_entreprise_88,
  t0.non_assujetti_tva AS non_assujetti_tva_89
FROM
  fusacq_dbo.utilisateurs t0
WHERE
  t0.id_utilisateur = ?

SELECT t0.id_utilisateur AS id_utilisateur_1, t0.login_utilisateur AS login_utilisateur_2, t0.password_encrypted_utilisateur AS password_encrypted_utilisateur_3, t0.is_verified AS is_verified_4, t0.mode_utilisateur AS mode_utilisateur_5, t0.type_abonnement AS type_abonnement_6, t0.date_demande_inscription AS date_demande_inscription_7, t0.date_demande_inscription_complete AS date_demande_inscription_complete_8, t0.date_relance AS date_relance_9, t0.date_inscription_reelle AS date_inscription_reelle_10, t0.langue_utilisee AS langue_utilisee_11, t0.type_utilisateur AS type_utilisateur_12, t0.nom_utilisateur AS nom_utilisateur_13, t0.prenom_utilisateur AS prenom_utilisateur_14, t0.email_utilisateur AS email_utilisateur_15, t0.societe_utilisateur AS societe_utilisateur_16, t0.rcs_utilisateur AS rcs_utilisateur_17, t0.relance_mail_utilisateur AS relance_mail_utilisateur_18, t0.pieces_necessaires AS pieces_necessaires_19, t0.pays_utilisateur AS pays_utilisateur_20, t0.region_utilisateur AS region_utilisateur_21, t0.ville_utilisateur AS ville_utilisateur_22, t0.code_postal_utilisateur AS code_postal_utilisateur_23, t0.adresse_utilisateur AS adresse_utilisateur_24, t0.commentaire_utilisateur AS commentaire_utilisateur_25, t0.litige_utilisateur AS litige_utilisateur_26, t0.compte_facturation AS compte_facturation_27, t0.factur_nom_societe AS factur_nom_societe_28, t0.factur_adresse AS factur_adresse_29, t0.factur_code_postal AS factur_code_postal_30, t0.factur_ville AS factur_ville_31, t0.factur_pays AS factur_pays_32, t0.factur_id_pays AS factur_id_pays_33, t0.id_type_structure AS id_type_structure_34, t0.telephone_utilisateur AS telephone_utilisateur_35, t0.indicatif_tel AS indicatif_tel_36, t0.id_structure AS id_structure_37, t0.id_gestionnaire_fonds AS id_gestionnaire_fonds_38, t0.fonction_utilisateur AS fonction_utilisateur_39, t0.lien_internet AS lien_internet_40, t0.tva_intracommunautaire AS tva_intracommunautaire_41, t0.id_client_publicite AS id_client_publicite_42, t0.inscription_partenaire AS inscription_partenaire_43, t0.site_partenaire AS site_partenaire_44, t0.provenance_connexion_fusacq AS provenance_connexion_fusacq_45, t0.suivi AS suivi_46, t0.date_derniere_connexion AS date_derniere_connexion_47, t0.date_desinscription_fusacq AS date_desinscription_fusacq_48, t0.type_commande AS type_commande_49, t0.date_derniere_commande AS date_derniere_commande_50, t0.date_dernier_depot_annonce AS date_dernier_depot_annonce_51, t0.etat_relance AS etat_relance_52, t0.agence_utilisateur AS agence_utilisateur_53, t0.cookie_authentification AS cookie_authentification_54, t0.id_pays_utilisateur AS id_pays_utilisateur_55, t0.id_region AS id_region_56, t0.contact_suite_inscription AS contact_suite_inscription_57, t0.id_societe_prestataire AS id_societe_prestataire_58, t0.association_societe_prestataire AS association_societe_prestataire_59, t0.mail_note_qualite_mer AS mail_note_qualite_mer_60, t0.provenance_notoriete_fusacq AS provenance_notoriete_fusacq_61, t0.id_reseau_commerce AS id_reseau_commerce_62, t0.montant_contact_defaut AS montant_contact_defaut_63, t0.montant_contact_international_defaut AS montant_contact_international_defaut_64, t0.type_utilisateur_commerce AS type_utilisateur_commerce_65, t0.annee_naissance AS annee_naissance_66, t0.civilite AS civilite_67, t0.inscription_validee AS inscription_validee_68, t0.plateforme_inscription AS plateforme_inscription_69, t0.frequence_envoi_alertes_commerces AS frequence_envoi_alertes_commerces_70, t0.date_dernier_envoi_alerte_commerces AS date_dernier_envoi_alerte_commerces_71, t0.mode_reglement_commerce AS mode_reglement_commerce_72, t0.id_agence_commerce AS id_agence_commerce_73, t0.provenance_connexion_commerces AS provenance_connexion_commerces_74, t0.importer_annonces_pdc_sur_ce_compte AS importer_annonces_pdc_sur_ce_compte_75, t0.email_invalide AS email_invalide_76, t0.personne_societe AS personne_societe_77, t0.type_utilisateur_franchise AS type_utilisateur_franchise_78, t0.mode_reglement_franchise AS mode_reglement_franchise_79, t0.montant_cv_defaut AS montant_cv_defaut_80, t0.montant_cv_international_defaut AS montant_cv_international_defaut_81, t0.id_cv AS id_cv_82, t0.telephone_utilisateur_back AS telephone_utilisateur_back_83, t0.site_derniere_connexion AS site_derniere_connexion_84, t0.date_derniere_notification_propose_cv_pdc AS date_derniere_notification_propose_cv_pdc_85, t0.devise AS devise_86, t0.id_pays_tarif_applicable AS id_pays_tarif_applicable_87, t0.identifiant_entreprise AS identifiant_entreprise_88, t0.non_assujetti_tva AS non_assujetti_tva_89 FROM fusacq_dbo.utilisateurs t0 WHERE t0.id_utilisateur = 19;

SELECT
  COUNT(a0_.id_annonce_acheteur) AS sclr_0
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.login_utilisateur = ?
  AND a0_.mode_annonce = ?
  AND a0_.deja_publique = ?

SELECT COUNT(a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.login_utilisateur = 'damien' AND a0_.mode_annonce = 'attente_envoi' AND a0_.deja_publique = 'non';

SELECT
  COUNT(a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.login_utilisateur = ?
  AND a0_.mode_annonce = ?
  AND a0_.deja_publique = ?

SELECT COUNT(a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.login_utilisateur = 'damien' AND a0_.mode_annonce = 'attente_envoi' AND a0_.deja_publique = 'non';

SELECT
  COUNT(a0_.id_annonce_acheteur) AS sclr_0
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.login_utilisateur = ?
  AND a0_.mode_annonce = ?
  AND a0_.deja_publique = ?

SELECT COUNT(a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.login_utilisateur = 'damien' AND a0_.mode_annonce = 'attente_envoi' AND a0_.deja_publique = 'oui';

SELECT
  COUNT(a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.login_utilisateur = ?
  AND a0_.mode_annonce = ?
  AND a0_.deja_publique = ?

SELECT COUNT(a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.login_utilisateur = 'damien' AND a0_.mode_annonce = 'attente_envoi' AND a0_.deja_publique = 'oui';

SELECT
  COUNT(a0_.id_annonce_acheteur) AS sclr_0
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.login_utilisateur = ?
  AND a0_.mode_annonce = ?

SELECT COUNT(a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.login_utilisateur = 'damien' AND a0_.mode_annonce = 'demande_publication';

SELECT
  COUNT(a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.login_utilisateur = ?
  AND a0_.mode_annonce = ?

SELECT COUNT(a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.login_utilisateur = 'damien' AND a0_.mode_annonce = 'demande_publication';

SELECT
  COUNT(a0_.id_annonce_acheteur) AS sclr_0
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.login_utilisateur = ?
  AND a0_.mode_annonce = ?

SELECT COUNT(a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.login_utilisateur = 'damien' AND a0_.mode_annonce = 'publique';

SELECT
  COUNT(a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.login_utilisateur = ?
  AND a0_.mode_annonce = ?

SELECT COUNT(a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.login_utilisateur = 'damien' AND a0_.mode_annonce = 'publique';

SELECT
  a0_.id_repreneur AS id_repreneur_0,
  a0_.login AS login_1,
  a0_.mode_profil AS mode_profil_2,
  a0_.nom AS nom_3,
  a0_.prenom AS prenom_4,
  a0_.adresse AS adresse_5,
  a0_.code_postal AS code_postal_6,
  a0_.ville AS ville_7,
  a0_.id_pays AS id_pays_8,
  a0_.telephone AS telephone_9,
  a0_.indicatif_telephone AS indicatif_telephone_10,
  a0_.email AS email_11,
  a0_.annee_naissance AS annee_naissance_12,
  a0_.description_societe_recherchee AS description_societe_recherchee_13,
  a0_.mots_cles_activite AS mots_cles_activite_14,
  a0_.id_secteur_activite_recherche AS id_secteur_activite_recherche_15,
  a0_.localisations_recherchees AS localisations_recherchees_16,
  a0_.valeur_min_entreprise AS valeur_min_entreprise_17,
  a0_.valeur_max_entreprise AS valeur_max_entreprise_18,
  a0_.montant_apport AS montant_apport_19,
  a0_.formation AS formation_20,
  a0_.parcours_professionnel AS parcours_professionnel_21,
  a0_.competences AS competences_22,
  a0_.competences_recherchees AS competences_recherchees_23,
  a0_.mobile_geographiquement AS mobile_geographiquement_24,
  a0_.commentaires AS commentaires_25,
  a0_.date_mise_a_jour AS date_mise_a_jour_26,
  a0_.visible_annuaire AS visible_annuaire_27,
  a0_.consultable_fp AS consultable_fp_28,
  a0_.consultable_ce AS consultable_ce_29,
  a0_.date_parution AS date_parution_30,
  a0_.date_parution_initiale AS date_parution_initiale_31,
  a0_.date_parution_initiale_complete AS date_parution_initiale_complete_32,
  a0_.relance_mise_a_jour AS relance_mise_a_jour_33,
  a0_.date_relance AS date_relance_34,
  a0_.deja_publique AS deja_publique_35,
  a0_.titre_societe_recherchee AS titre_societe_recherchee_36,
  a0_.id_localisations_recherchees AS id_localisations_recherchees_37,
  a0_.demarche AS demarche_38,
  a0_.complements_demarche AS complements_demarche_39,
  a0_.titre_profil AS titre_profil_40,
  a0_.pourcentage_hauteur_popup AS pourcentage_hauteur_popup_41,
  a0_.publication_newsletter_buzz AS publication_newsletter_buzz_42,
  a0_.mots_cle_recherche AS mots_cle_recherche_43,
  a0_.statut AS statut_44,
  a0_.id_period_annonce_prioritaire AS id_period_annonce_prioritaire_45,
  a0_.etat_annonce_prioritaire AS etat_annonce_prioritaire_46,
  a0_.date_debut_annonce_prioritaire AS date_debut_annonce_prioritaire_47,
  a0_.date_arret_annonce_prioritaire AS date_arret_annonce_prioritaire_48,
  a0_.suivi AS suivi_49,
  a0_.is_international AS is_international_50
FROM
  fusacq_dbo.annuaire_repreneurs a0_
WHERE
  a0_.login = ?
LIMIT
  1

SELECT a0_.id_repreneur AS id_repreneur_0, a0_.login AS login_1, a0_.mode_profil AS mode_profil_2, a0_.nom AS nom_3, a0_.prenom AS prenom_4, a0_.adresse AS adresse_5, a0_.code_postal AS code_postal_6, a0_.ville AS ville_7, a0_.id_pays AS id_pays_8, a0_.telephone AS telephone_9, a0_.indicatif_telephone AS indicatif_telephone_10, a0_.email AS email_11, a0_.annee_naissance AS annee_naissance_12, a0_.description_societe_recherchee AS description_societe_recherchee_13, a0_.mots_cles_activite AS mots_cles_activite_14, a0_.id_secteur_activite_recherche AS id_secteur_activite_recherche_15, a0_.localisations_recherchees AS localisations_recherchees_16, a0_.valeur_min_entreprise AS valeur_min_entreprise_17, a0_.valeur_max_entreprise AS valeur_max_entreprise_18, a0_.montant_apport AS montant_apport_19, a0_.formation AS formation_20, a0_.parcours_professionnel AS parcours_professionnel_21, a0_.competences AS competences_22, a0_.competences_recherchees AS competences_recherchees_23, a0_.mobile_geographiquement AS mobile_geographiquement_24, a0_.commentaires AS commentaires_25, a0_.date_mise_a_jour AS date_mise_a_jour_26, a0_.visible_annuaire AS visible_annuaire_27, a0_.consultable_fp AS consultable_fp_28, a0_.consultable_ce AS consultable_ce_29, a0_.date_parution AS date_parution_30, a0_.date_parution_initiale AS date_parution_initiale_31, a0_.date_parution_initiale_complete AS date_parution_initiale_complete_32, a0_.relance_mise_a_jour AS relance_mise_a_jour_33, a0_.date_relance AS date_relance_34, a0_.deja_publique AS deja_publique_35, a0_.titre_societe_recherchee AS titre_societe_recherchee_36, a0_.id_localisations_recherchees AS id_localisations_recherchees_37, a0_.demarche AS demarche_38, a0_.complements_demarche AS complements_demarche_39, a0_.titre_profil AS titre_profil_40, a0_.pourcentage_hauteur_popup AS pourcentage_hauteur_popup_41, a0_.publication_newsletter_buzz AS publication_newsletter_buzz_42, a0_.mots_cle_recherche AS mots_cle_recherche_43, a0_.statut AS statut_44, a0_.id_period_annonce_prioritaire AS id_period_annonce_prioritaire_45, a0_.etat_annonce_prioritaire AS etat_annonce_prioritaire_46, a0_.date_debut_annonce_prioritaire AS date_debut_annonce_prioritaire_47, a0_.date_arret_annonce_prioritaire AS date_arret_annonce_prioritaire_48, a0_.suivi AS suivi_49, a0_.is_international AS is_international_50 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.login = 'damien' LIMIT 1;

SELECT
  d0_.id_utilisateur AS id_utilisateur_0
FROM
  fusacq_dbo.droits_acces d0_
WHERE
  d0_.id_service IN ('81', '82')
  AND d0_.id_utilisateur = ?
  AND (
    NULLIF(d0_.date_debut_acces, '') IS NULL
    OR d0_.date_debut_acces <= '20260416'
  )
  AND (
    NULLIF(d0_.date_fin_acces, '') IS NULL
    OR d0_.date_fin_acces >= '20260416'
  )
  AND (
    NULLIF(
      d0_.nb_utilisations_restantes, ''
    ) IS NULL
    OR d0_.nb_utilisations_restantes > 0
  )

SELECT d0_.id_utilisateur AS id_utilisateur_0 FROM fusacq_dbo.droits_acces d0_ WHERE d0_.id_service IN ('81', '82') AND d0_.id_utilisateur = 19 AND (NULLIF(d0_.date_debut_acces, '') IS NULL OR d0_.date_debut_acces <= '20260416') AND (NULLIF(d0_.date_fin_acces, '') IS NULL OR d0_.date_fin_acces >= '20260416') AND (NULLIF(d0_.nb_utilisations_restantes, '') IS NULL OR d0_.nb_utilisations_restantes > 0);