Symfony Profiler

[
  "route" => "utilisateurs_show"
  "route_parameters" => [
    "_route" => "utilisateurs_show"
    "_controller" => "App\Controller\UtilisateursController::show"
    "id" => "91466"
  ]
  "request_uri" => "https://admin25.fusacq.com/utilisateurs/91466"
  "method" => "GET"
]

[
  "firewall_name" => "admin"
  "authenticators" => 3
]

[
  "firewall_name" => "admin"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "admin"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "admin"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "admin"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "admin"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "key" => "_security_admin"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\RememberMeToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "51.210.34.241"
    "port" => 3306
    "user" => "fusacqrw"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "fusacq_dbo"
    "serverVersion" => "8.0"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.created_at AS created_at_7, t0.last_login_at AS last_login_at_8, t0.is_active AS is_active_9 FROM partage_dbo.user_admin25 t0 WHERE t0.id = ?"
  "params" => [
    1 => 23
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "sophie@fusacq.com"
]

[
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.device_id AS device_id_1, a0_.expires_at AS expires_at_2, a0_.last_used_at AS last_used_at_3, a0_.user_id AS user_id_4 FROM partage_dbo.admin_trusted_device a0_ WHERE a0_.user_id = ? AND a0_.device_id = ? AND a0_.expires_at > ? LIMIT 1"
  "params" => [
    1 => 23
    2 => "110446c56d04a4b24fbe068dc357b97b79ee70260f213b3b3b75f7f20263263f"
    3 => "2026-04-08 13:54:02"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "UPDATE partage_dbo.admin_trusted_device SET last_used_at = ? WHERE id = ?"
  "params" => [
    1 => "2026-04-08 13:54:02"
    2 => 38
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "sql" => "SELECT t0.id_utilisateur AS id_utilisateur_1, t0.email_utilisateur AS email_utilisateur_2, t0.login_utilisateur AS login_utilisateur_3, t0.password_encrypted_utilisateur AS password_encrypted_utilisateur_4, t0.civilite AS civilite_5, t0.type_utilisateur AS type_utilisateur_6, t0.nom_utilisateur AS nom_utilisateur_7, t0.prenom_utilisateur AS prenom_utilisateur_8, t0.telephone_utilisateur AS telephone_utilisateur_9, t0.indicatif_tel AS indicatif_tel_10, t0.societe_utilisateur AS societe_utilisateur_11, t0.factur_nom_societe AS factur_nom_societe_12, t0.factur_adresse AS factur_adresse_13, t0.factur_code_postal AS factur_code_postal_14, t0.factur_ville AS factur_ville_15, t0.factur_pays AS factur_pays_16, t0.factur_id_pays AS factur_id_pays_17, t0.tva_intracommunautaire AS tva_intracommunautaire_18, t0.non_assujetti_tva AS non_assujetti_tva_19, t0.identifiant_entreprise AS identifiant_entreprise_20, t0.langue_utilisee AS langue_utilisee_21, t0.id_societe_prestataire AS id_societe_prestataire_22, t0.association_societe_prestataire AS association_societe_prestataire_23, t0.id_gestionnaire_fonds AS id_gestionnaire_fonds_24, t0.id_client_publicite AS id_client_publicite_25, t0.id_structure AS id_structure_26, t0.provenance_connexion_fusacq AS provenance_connexion_fusacq_27, t0.id_region AS id_region_28, t0.adresse_utilisateur AS adresse_utilisateur_29, t0.site_partenaire AS site_partenaire_30, t0.ville_utilisateur AS ville_utilisateur_31, t0.code_postal_utilisateur AS code_postal_utilisateur_32, t0.site_derniere_connexion AS site_derniere_connexion_33, t0.mode_utilisateur AS mode_utilisateur_34, t0.date_demande_inscription AS date_demande_inscription_35, t0.date_inscription_reelle AS date_inscription_reelle_36, t0.plateforme_inscription AS plateforme_inscription_37, t0.inscription_partenaire AS inscription_partenaire_38, t0.suivi AS suivi_39, t0.date_relance AS date_relance_40, t0.etat_relance AS etat_relance_41, t0.mode_reglement_franchise AS mode_reglement_franchise_42, t0.pays_utilisateur AS pays_utilisateur_43, t0.type_utilisateur_commerce AS type_utilisateur_commerce_44, t0.type_utilisateur_franchise AS type_utilisateur_franchise_45, t0.contact_suite_inscription AS contact_suite_inscription_46 FROM fusacq_dbo.utilisateurs t0 WHERE t0.id_utilisateur = ?"
  "params" => [
    1 => 91466
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT d0_.id_droit_acces AS id_droit_acces_0, d0_.date_fin_acces AS date_fin_acces_1, d0_.relance AS relance_2, d0_.date_relance AS date_relance_3, d0_.id_utilisateur AS id_utilisateur_4, d0_.id_service AS id_service_5, d0_.nb_utilisations_restantes AS nb_utilisations_restantes_6, d0_.id_service AS id_service_7 FROM droits_acces d0_ WHERE d0_.id_utilisateur = ? AND d0_.id_service = ?"
  "params" => [
    1 => 91466
    2 => 50
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT responsable_relance FROM fusacq_dbo.detail_utilisateurs WHERE id_utilisateur = ? LIMIT 1"
  "params" => [
    91466
  ]
  "types" => []
]

[
  "sql" => "SELECT telephone_utilisateur FROM fusacq_dbo.utilisateurs WHERE id_utilisateur = ?"
  "params" => [
    91466
  ]
  "types" => []
]

[
  "sql" => """
    \r\n
                SELECT DISTINCT LOWER(nom_administrateur) as nom_admin \r\n
                FROM commerces_dbo.statistiques_administrateurs\r\n
                WHERE date_traitement >= :date_min \r\n
                AND nom_administrateur IS NOT NULL \r\n
                AND nom_administrateur <> 'NULL'\r\n
            
    """
  "params" => [
    "date_min" => "20240408000000"
  ]
  "types" => []
]

[
  "sql" => """
    \r\n
                SELECT DISTINCT LOWER(username) as username \r\n
                FROM partage_dbo.users \r\n
                ORDER BY username\r\n
            
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    SELECT id_interet_service, interet_service \r\n
                        FROM fusacq_dbo.interet_services_fusacq \r\n
                        ORDER BY interet_service
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    SELECT id_interet_service \r\n
                        FROM fusacq_dbo.lien_utilisateurs_interet_services_fusacq \r\n
                        WHERE id_utilisateur = :id_utilisateur \r\n
                        LIMIT 1
    """
  "params" => [
    "id_utilisateur" => 91466
  ]
  "types" => []
]

[
  "sql" => """
    SELECT lien_salesforce \r\n
                        FROM fusacq_dbo.detail_utilisateurs \r\n
                        WHERE id_utilisateur = :id_utilisateur \r\n
                        LIMIT 1
    """
  "params" => [
    "id_utilisateur" => 91466
  ]
  "types" => []
]

[
  "sql" => """
    SELECT cc.*, du.id_compte_client\r\n
                        FROM fusacq_dbo.comptes_clients cc\r\n
                        LEFT JOIN fusacq_dbo.detail_utilisateurs du ON cc.id_compte_client = du.id_compte_client\r\n
                        WHERE du.id_utilisateur = :id_utilisateur\r\n
                        LIMIT 1
    """
  "params" => [
    "id_utilisateur" => 91466
  ]
  "types" => []
]

[
  "sql" => """
    SELECT id_compte_client, nom_compte_client \r\n
                        FROM fusacq_dbo.comptes_clients \r\n
                        ORDER BY nom_compte_client ASC
    """
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT t0.id_utilisateur AS id_utilisateur_1, t0.email_utilisateur AS email_utilisateur_2, t0.login_utilisateur AS login_utilisateur_3, t0.password_encrypted_utilisateur AS password_encrypted_utilisateur_4, t0.civilite AS civilite_5, t0.type_utilisateur AS type_utilisateur_6, t0.nom_utilisateur AS nom_utilisateur_7, t0.prenom_utilisateur AS prenom_utilisateur_8, t0.telephone_utilisateur AS telephone_utilisateur_9, t0.indicatif_tel AS indicatif_tel_10, t0.societe_utilisateur AS societe_utilisateur_11, t0.factur_nom_societe AS factur_nom_societe_12, t0.factur_adresse AS factur_adresse_13, t0.factur_code_postal AS factur_code_postal_14, t0.factur_ville AS factur_ville_15, t0.factur_pays AS factur_pays_16, t0.factur_id_pays AS factur_id_pays_17, t0.tva_intracommunautaire AS tva_intracommunautaire_18, t0.non_assujetti_tva AS non_assujetti_tva_19, t0.identifiant_entreprise AS identifiant_entreprise_20, t0.langue_utilisee AS langue_utilisee_21, t0.id_societe_prestataire AS id_societe_prestataire_22, t0.association_societe_prestataire AS association_societe_prestataire_23, t0.id_gestionnaire_fonds AS id_gestionnaire_fonds_24, t0.id_client_publicite AS id_client_publicite_25, t0.id_structure AS id_structure_26, t0.provenance_connexion_fusacq AS provenance_connexion_fusacq_27, t0.id_region AS id_region_28, t0.adresse_utilisateur AS adresse_utilisateur_29, t0.site_partenaire AS site_partenaire_30, t0.ville_utilisateur AS ville_utilisateur_31, t0.code_postal_utilisateur AS code_postal_utilisateur_32, t0.site_derniere_connexion AS site_derniere_connexion_33, t0.mode_utilisateur AS mode_utilisateur_34, t0.date_demande_inscription AS date_demande_inscription_35, t0.date_inscription_reelle AS date_inscription_reelle_36, t0.plateforme_inscription AS plateforme_inscription_37, t0.inscription_partenaire AS inscription_partenaire_38, t0.suivi AS suivi_39, t0.date_relance AS date_relance_40, t0.etat_relance AS etat_relance_41, t0.mode_reglement_franchise AS mode_reglement_franchise_42, t0.pays_utilisateur AS pays_utilisateur_43, t0.type_utilisateur_commerce AS type_utilisateur_commerce_44, t0.type_utilisateur_franchise AS type_utilisateur_franchise_45, t0.contact_suite_inscription AS contact_suite_inscription_46 FROM fusacq_dbo.utilisateurs t0 WHERE t0.id_utilisateur = ?"
  "params" => [
    1 => 91466
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    SELECT factur_nom_societe as raison_sociale\r\n
                        FROM fusacq_dbo.utilisateurs\r\n
                        WHERE id_utilisateur = :id_utilisateur\r\n
                        LIMIT 1
    """
  "params" => [
    "id_utilisateur" => 91466
  ]
  "types" => []
]

[
  "sql" => """
    SELECT sp.id_societe_prestataire, u.factur_nom_societe as raison_sociale, sp.login_utilisateur\r\n
                        FROM fusacq_dbo.societes_prestataire sp\r\n
                        LEFT JOIN fusacq_dbo.utilisateurs u ON u.login_utilisateur = sp.login_utilisateur\r\n
                        ORDER BY u.factur_nom_societe
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    SELECT id_gestionnaire_fonds, nom_societe\r\n
                        FROM fusacq_dbo.societe_gestionnaire_fonds\r\n
                        ORDER BY nom_societe
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    SELECT id_client, nom_client\r\n
                        FROM fusacq_dbo.clients_publicite\r\n
                        ORDER BY nom_client
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    SELECT id_chambre, nom_chambre\r\n
                        FROM fusacq_dbo.chambres_syndicales_uimm\r\n
                        ORDER BY nom_chambre ASC
    """
]

[
  "sql" => """
    SELECT id_entites_organisation_professionnelle, nom\r\n
                        FROM fusacq_dbo.entites_organisation_professionnelle\r\n
                        ORDER BY nom ASC
    """
]

[
  "sql" => """
    SELECT id_chambre_syndicale_uimm, id_entites_organisation_professionnelle\r\n
                        FROM fusacq_dbo.detail_utilisateurs_partenaire\r\n
                        WHERE id_utilisateur = ?
    """
  "params" => [
    1 => 91466
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT nom_service, code_service, id_service\r\n
                        FROM fusacq_dbo.services\r\n
                        WHERE mode_service IS NULL\r\n
                        AND marketing_auto IS NULL\r\n
                        ORDER BY nom_service
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    SELECT nom_service, code_service, id_service, marketing_auto\r\n
                        FROM fusacq_dbo.services\r\n
                        WHERE marketing_auto IS NOT NULL\r\n
                        ORDER BY nom_service
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    SELECT da.id_droit_acces, da.date_debut_acces, da.date_fin_acces, \r\n
                               da.nb_utilisations_restantes, da.id_utilisateur, da.id_service, \r\n
                               se.nom_service, se.code_service\r\n
                        FROM fusacq_dbo.droits_acces da, fusacq_dbo.services se\r\n
                        WHERE da.id_utilisateur = :id_utilisateur\r\n
                        AND se.id_service = da.id_service\r\n
                        AND se.marketing_auto IS NULL\r\n
                        ORDER BY se.nom_service
    """
  "params" => [
    "id_utilisateur" => 91466
  ]
  "types" => []
]

[
  "sql" => """
    SELECT da.id_droit_acces, da.date_fin_acces, da.nb_utilisations_restantes, \r\n
                               da.id_utilisateur, da.id_service, se.nom_service, se.code_service\r\n
                        FROM fusacq_dbo.droits_acces da, fusacq_dbo.services se\r\n
                        WHERE da.id_utilisateur = :id_utilisateur\r\n
                        AND se.id_service = da.id_service\r\n
                        AND se.marketing_auto IS NOT NULL\r\n
                        ORDER BY se.nom_service
    """
  "params" => [
    "id_utilisateur" => 91466
  ]
  "types" => []
]

[
  "sql" => """
    SELECT da.id_droit_acces, da.date_debut_acces, da.date_fin_acces, \r\n
                               da.nb_utilisations_restantes, da.id_utilisateur, da.id_service, \r\n
                               se.nom_service, se.code_service\r\n
                        FROM fusacq_dbo.droits_acces da, fusacq_dbo.services se\r\n
                        WHERE da.id_utilisateur = :id_utilisateur\r\n
                        AND se.id_service = da.id_service\r\n
                        AND se.marketing_auto IS NULL\r\n
                        ORDER BY se.nom_service
    """
  "params" => [
    "id_utilisateur" => 91466
  ]
  "types" => []
]

[
  "sql" => """
    SELECT da.id_droit_acces, da.date_fin_acces, da.nb_utilisations_restantes, \r\n
                               da.id_utilisateur, da.id_service, se.nom_service, se.code_service\r\n
                        FROM fusacq_dbo.droits_acces da, fusacq_dbo.services se\r\n
                        WHERE da.id_utilisateur = :id_utilisateur\r\n
                        AND se.id_service = da.id_service\r\n
                        AND se.marketing_auto IS NOT NULL\r\n
                        ORDER BY se.nom_service
    """
  "params" => [
    "id_utilisateur" => 91466
  ]
  "types" => []
]

[
  "sql" => """
    SELECT COUNT(*) AS NB \r\n
                        FROM fusacq_dbo.investisseurs_prives \r\n
                        WHERE id_utilisateur = :id_utilisateur
    """
  "params" => [
    "id_utilisateur" => 91466
  ]
  "types" => []
]

[
  "sql" => """
    SELECT COUNT(*) AS NB \r\n
                        FROM fusacq_dbo.investisseurs_prives \r\n
                        WHERE id_utilisateur = :id_utilisateur \r\n
                        AND mode = 'publique'
    """
  "params" => [
    "id_utilisateur" => 91466
  ]
  "types" => []
]

[
  "sql" => """
    SELECT *\r\n
                        FROM fusacq_dbo.utilisateurs_interactions\r\n
                        WHERE id_utilisateur = :id_utilisateur\r\n
                        LIMIT 1
    """
  "params" => [
    "id_utilisateur" => 91466
  ]
  "types" => []
]

[
  "sql" => """
    SELECT *\r\n
                        FROM fusacq_dbo.statistiques_connexion_utilisateurs\r\n
                        WHERE id_utilisateur = :id_utilisateur\r\n
                        LIMIT 1
    """
  "params" => [
    "id_utilisateur" => 91466
  ]
  "types" => []
]

[
  "sql" => """
    SELECT nom_localisation\r\n
                        FROM fusacq_dbo.localisations\r\n
                        WHERE id_localisation = :id_region\r\n
                        LIMIT 1
    """
  "params" => [
    "id_region" => "33_12"
  ]
  "types" => []
]

[
  "sql" => """
    SELECT id, nom \r\n
                        FROM partage_dbo.type_suivi \r\n
                        ORDER BY id ASC
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    SELECT su.id_suivi, su.date_suivi, su.nom_administrateur, su.detail_action, su.id_type_suivi\r\n
                        FROM fusacq_dbo.suivi_utilisateur su\r\n
                        WHERE su.id_utilisateur = :id_utilisateur
    """
  "params" => [
    "id_utilisateur" => 91466
  ]
  "types" => []
]

[
  "sql" => "SELECT nom FROM partage_dbo.type_suivi WHERE id IN (3,5) ORDER BY id ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT nom FROM partage_dbo.type_suivi WHERE id IN (5) ORDER BY id ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT nom FROM partage_dbo.type_suivi WHERE id IN (6) ORDER BY id ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT nom FROM partage_dbo.type_suivi WHERE id IN (6) ORDER BY id ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT nom FROM partage_dbo.type_suivi WHERE id IN (4) ORDER BY id ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT nom FROM partage_dbo.type_suivi WHERE id IN (4) ORDER BY id ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT nom FROM partage_dbo.type_suivi WHERE id IN (2) ORDER BY id ASC"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT nom FROM partage_dbo.type_suivi WHERE id IN (2) ORDER BY id ASC"
  "params" => []
  "types" => []
]

[
  "sql" => """
    SELECT COUNT(*) as nb \r\n
                            FROM fusacq_dbo.annonces_vendeur \r\n
                            WHERE login_utilisateur = :login_utilisateur
    """
  "params" => [
    "login_utilisateur" => "91466"
  ]
  "types" => []
]

[
  "sql" => """
    SELECT COUNT(*) as nb \r\n
                            FROM fusacq_dbo.annonces_acheteur \r\n
                            WHERE login_utilisateur = :login_utilisateur
    """
  "params" => [
    "login_utilisateur" => "91466"
  ]
  "types" => []
]

[
  "sql" => """
    SELECT COUNT(*) as nb \r\n
                         FROM fusacq_dbo.annuaire_repreneurs \r\n
                         WHERE id_repreneur = :id_utilisateur \r\n
                         AND mode_profil = 'attente'
    """
  "params" => [
    "id_utilisateur" => 91466
  ]
  "types" => []
]

[
  "sql" => """
    SELECT COUNT(*) AS NB \r\n
                        FROM fusacq_dbo.investisseurs_prives \r\n
                        WHERE id_utilisateur = :id_utilisateur
    """
  "params" => [
    "id_utilisateur" => 91466
  ]
  "types" => []
]

[
  "sql" => """
    SELECT COUNT(*) as nb \r\n
                          FROM commerces_dbo.annonces \r\n
                          WHERE id_utilisateur = :id_utilisateur
    """
  "params" => [
    "id_utilisateur" => 91466
  ]
  "types" => []
]

[
  "sql" => """
    SELECT dc.prix_mise_en_relation, cm.mode_reglement, cm.date_livraison\r\n
                               FROM fusacq_dbo.details_commande dc\r\n
                               JOIN fusacq_dbo.annonces_vendeur av ON dc.id_annonce = av.id_annonce_vendeur\r\n
                               JOIN fusacq_dbo.commandes cm ON cm.id_commande = dc.id_commande\r\n
                               WHERE dc.type_annonce = 'vendeur'\r\n
                                 AND av.login_utilisateur = ?\r\n
                                 AND (cm.etat = 'facture_envoyee' OR cm.etat = 'information_transmise')
    """
  "params" => [
    1 => "91466"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT dc.prix_mise_en_relation, cm.mode_reglement, cm.date_livraison\r\n
                                FROM fusacq_dbo.details_commande dc\r\n
                                JOIN fusacq_dbo.annonces_acheteur aa ON dc.id_annonce = aa.id_annonce_acheteur\r\n
                                JOIN fusacq_dbo.commandes cm ON cm.id_commande = dc.id_commande\r\n
                                WHERE dc.type_annonce = 'acheteur'\r\n
                                  AND aa.login_utilisateur = ?\r\n
                                  AND (cm.etat = 'facture_envoyee' OR cm.etat = 'information_transmise')
    """
  "params" => [
    1 => "91466"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT dc.note_mer\r\n
                            FROM fusacq_dbo.details_commande dc, fusacq_dbo.annonces_vendeur av\r\n
                            WHERE (dc.note_mer IS NOT NULL)\r\n
                            AND dc.type_annonce='vendeur'\r\n
                            AND (dc.id_annonce=av.id_annonce_vendeur)\r\n
                            AND av.login_utilisateur=:login_utilisateur
    """
  "params" => [
    "login_utilisateur" => "91466"
  ]
  "types" => []
]

[
  "sql" => """
    SELECT dc.note_mer\r\n
                            FROM fusacq_dbo.details_commande dc, fusacq_dbo.annonces_acheteur aa\r\n
                            WHERE (dc.note_mer IS NOT NULL)\r\n
                            AND dc.type_annonce='acheteur'\r\n
                            AND (dc.id_annonce=aa.id_annonce_acheteur)\r\n
                            AND aa.login_utilisateur=:login_utilisateur
    """
  "params" => [
    "login_utilisateur" => "91466"
  ]
  "types" => []
]

[
  "sql" => """
    SELECT DISTINCT etat_relance \r\n
                        FROM fusacq_dbo.utilisateurs \r\n
                        WHERE etat_relance IS NOT NULL \r\n
                        AND etat_relance != '' \r\n
                        AND etat_relance != 'undefined'
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    SELECT dc.prix_mise_en_relation, dc.commentaire_fusacq, dc.id_detail_cmde, dc.demande_recredit,\r\n
                        dc.commentaire_qualite_mer, dc.note_mer, dc.traitement_retour_qualite, dc.type_annonce, \r\n
                        av.nom_contact, av.telephone, av.id_annonce_vendeur,\r\n
                        cm.mode_reglement, av.titre_annonce, cm.date_livraison, av.id_region, av.id_departement, \r\n
                        av.zone_geographique, av.publi_annonce\r\n
                        FROM fusacq_dbo.annonces_vendeur av, fusacq_dbo.commandes cm, fusacq_dbo.details_commande dc\r\n
                        WHERE cm.etat != 'avortee'\r\n
                        AND dc.id_cpte_utilisateur = :login_utilisateur\r\n
                        AND dc.id_commande = cm.id_commande\r\n
                        AND dc.id_cpte_utilisateur = cm.id_cpte_utilisateur\r\n
                        AND dc.id_annonce = av.id_annonce_vendeur\r\n
                        AND dc.type_annonce = 'vendeur'\r\n
                        AND cm.date_livraison >= :date_commandes_depart\r\n
                        ORDER BY dc.id_detail_cmde DESC
    """
  "params" => [
    "login_utilisateur" => "91466"
    "date_commandes_depart" => 20150326
  ]
  "types" => []
]

[
  "sql" => """
    SELECT dc.prix_mise_en_relation, dc.commentaire_fusacq, dc.id_detail_cmde, dc.demande_recredit,\r\n
                        dc.commentaire_qualite_mer, dc.note_mer, dc.traitement_retour_qualite, aa.nom_contact, \r\n
                        aa.telephone, aa.id_annonce_acheteur, cm.mode_reglement, aa.titre_annonce,\r\n
                        cm.date_livraison, aa.id_region, aa.id_departement\r\n
                        FROM fusacq_dbo.annonces_acheteur aa, fusacq_dbo.commandes cm, fusacq_dbo.details_commande dc\r\n
                        WHERE cm.etat != 'avortee'\r\n
                        AND dc.id_cpte_utilisateur = :login_utilisateur\r\n
                        AND dc.id_commande = cm.id_commande\r\n
                        AND dc.id_cpte_utilisateur = cm.id_cpte_utilisateur\r\n
                        AND dc.id_annonce = aa.id_annonce_acheteur\r\n
                        AND dc.type_annonce = 'acheteur'\r\n
                        AND cm.date_livraison >= :date_commandes_depart\r\n
                        ORDER BY cm.date_livraison DESC
    """
  "params" => [
    "login_utilisateur" => "91466"
    "date_commandes_depart" => 20150326
  ]
  "types" => []
]

[
  "sql" => """
    SELECT dc.prix_mise_en_relation, dc.commentaire_fusacq, dc.id_detail_cmde, dc.demande_recredit,\r\n
                        dc.commentaire_qualite_mer, dc.note_mer, dc.traitement_retour_qualite, aa.nom as nom_contact, \r\n
                        aa.telephone, aa.id_repreneur, cm.mode_reglement, aa.titre_profil as titre_annonce,\r\n
                        cm.date_livraison, aa.code_postal\r\n
                        FROM fusacq_dbo.annuaire_repreneurs aa, fusacq_dbo.commandes cm, fusacq_dbo.details_commande dc\r\n
                        WHERE cm.etat != 'avortee'\r\n
                        AND dc.id_cpte_utilisateur = :login_utilisateur\r\n
                        AND dc.id_commande = cm.id_commande\r\n
                        AND dc.id_cpte_utilisateur = cm.id_cpte_utilisateur\r\n
                        AND dc.id_annonce = aa.id_repreneur\r\n
                        AND dc.type_annonce = 'repreneur'\r\n
                        AND cm.date_livraison >= :date_commandes_depart
    """
  "params" => [
    "login_utilisateur" => "91466"
    "date_commandes_depart" => 20150326
  ]
  "types" => []
]

[
  "sql" => """
    SELECT dc.prix_mise_en_relation, dc.commentaire_fusacq, dc.id_detail_cmde, dc.demande_recredit,\r\n
                        dc.commentaire_qualite_mer, dc.note_mer, dc.traitement_retour_qualite, aa.nom_contact, \r\n
                        aa.telephone_contact, aa.id_investisseur, cm.mode_reglement, aa.titre_investisseur as titre_annonce,\r\n
                        cm.date_livraison\r\n
                        FROM fusacq_dbo.investisseurs_prives aa, fusacq_dbo.commandes cm, fusacq_dbo.details_commande dc\r\n
                        WHERE cm.etat != 'avortee'\r\n
                        AND dc.id_cpte_utilisateur = :login_utilisateur\r\n
                        AND dc.id_commande = cm.id_commande\r\n
                        AND dc.id_cpte_utilisateur = cm.id_cpte_utilisateur\r\n
                        AND dc.id_annonce = aa.id_investisseur\r\n
                        AND dc.type_annonce = 'investisseur_prive'\r\n
                        AND cm.date_livraison >= :date_commandes_depart
    """
  "params" => [
    "login_utilisateur" => "91466"
    "date_commandes_depart" => 20150326
  ]
  "types" => []
]

[
  "sql" => """
    SELECT dc.prix_mise_en_relation, dc.commentaire_fusacq, dc.id_detail_cmde, dc.demande_recredit,\r\n
                        dc.commentaire_qualite_mer, dc.note_mer, dc.traitement_retour_qualite, dc.type_annonce,\r\n
                        s.nom_president as nom_contact, s.telephone, s.id_societe,\r\n
                        cm.mode_reglement, s.raison_sociale, cm.date_livraison, s.id_region, s.id_pays\r\n
                        FROM fusacq_dbo.societes s, fusacq_dbo.commandes cm, fusacq_dbo.details_commande dc\r\n
                        WHERE cm.etat != 'avortee'\r\n
                        AND dc.id_cpte_utilisateur = :login_utilisateur\r\n
                        AND dc.id_commande = cm.id_commande\r\n
                        AND dc.id_cpte_utilisateur = cm.id_cpte_utilisateur\r\n
                        AND dc.id_annonce = s.id_societe\r\n
                        AND dc.type_annonce = 'participation'\r\n
                        AND cm.date_livraison >= :date_commandes_depart\r\n
                        ORDER BY dc.id_detail_cmde DESC
    """
  "params" => [
    "login_utilisateur" => "91466"
    "date_commandes_depart" => 20150326
  ]
  "types" => []
]

[
  "sql" => """
    SELECT dc.prix_mise_en_relation, dc.commentaire_fusacq, dc.id_detail_cmde, dc.demande_recredit,\r\n
                        dc.commentaire_qualite_mer, dc.note_mer, dc.traitement_retour_qualite, dc.type_annonce,\r\n
                        s.nom_contact, s.telephone, s.id_gestionnaire_fonds,\r\n
                        cm.mode_reglement, s.nom_societe, cm.date_livraison, s.id_region, s.id_pays\r\n
                        FROM fusacq_dbo.societe_gestionnaire_fonds s, fusacq_dbo.commandes cm, fusacq_dbo.details_commande dc\r\n
                        WHERE cm.etat != 'avortee'\r\n
                        AND dc.id_cpte_utilisateur = :login_utilisateur\r\n
                        AND dc.id_commande = cm.id_commande\r\n
                        AND dc.id_cpte_utilisateur = cm.id_cpte_utilisateur\r\n
                        AND dc.id_annonce = s.id_gestionnaire_fonds\r\n
                        AND dc.type_annonce = 'fonds'\r\n
                        AND cm.date_livraison >= :date_commandes_depart\r\n
                        ORDER BY dc.id_detail_cmde DESC
    """
  "params" => [
    "login_utilisateur" => "91466"
    "date_commandes_depart" => 20150326
  ]
  "types" => []
]

[
  "sql" => """
    SELECT dc.prix_mise_en_relation, dc.commentaire_fusacq, dc.id_detail_cmde, dc.demande_recredit,\r\n
                        dc.commentaire_qualite_mer, dc.note_mer, dc.traitement_retour_qualite, dc.type_annonce,\r\n
                        v.id_valorisation, av.titre_annonce, v.nom_contact, v.telephone,\r\n
                        cm.mode_reglement, cm.date_livraison, v.id_region, v.id_pays\r\n
                        FROM fusacq_dbo.valorisations v, fusacq_dbo.commandes cm, fusacq_dbo.details_commande dc, \r\n
                             fusacq_dbo.annonces_vendeur av\r\n
                        WHERE cm.etat != 'avortee'\r\n
                        AND dc.id_cpte_utilisateur = :login_utilisateur\r\n
                        AND dc.id_commande = cm.id_commande\r\n
                        AND v.id_annonce_vendeur = av.id_annonce_vendeur\r\n
                        AND dc.id_cpte_utilisateur = cm.id_cpte_utilisateur\r\n
                        AND dc.id_annonce = v.id_valorisation\r\n
                        AND dc.type_annonce = 'valorisation'\r\n
                        AND cm.date_livraison >= :date_commandes_depart\r\n
                        ORDER BY dc.id_detail_cmde DESC
    """
  "params" => [
    "login_utilisateur" => "91466"
    "date_commandes_depart" => 20150326
  ]
  "types" => []
]

[
  "sql" => """
    SELECT dc.prix_mise_en_relation, dc.commentaire_fusacq, dc.id_detail_cmde, dc.demande_recredit,\r\n
                        dc.commentaire_qualite_mer, dc.note_mer, dc.traitement_retour_qualite, dc.type_annonce,\r\n
                        s.nom_president as nom_contact, s.telephone, s.id_societe,\r\n
                        cm.mode_reglement, s.raison_sociale, cm.date_livraison, s.id_region, s.id_pays\r\n
                        FROM fusacq_dbo.societes s, fusacq_dbo.commandes cm, fusacq_dbo.details_commande dc\r\n
                        WHERE cm.etat != 'avortee'\r\n
                        AND dc.id_cpte_utilisateur = :login_utilisateur\r\n
                        AND dc.id_commande = cm.id_commande\r\n
                        AND dc.id_cpte_utilisateur = cm.id_cpte_utilisateur\r\n
                        AND dc.id_annonce = s.id_societe\r\n
                        AND dc.type_annonce = 'acquereur_historique'\r\n
                        AND cm.date_livraison >= :date_commandes_depart\r\n
                        ORDER BY dc.id_detail_cmde DESC
    """
  "params" => [
    "login_utilisateur" => "91466"
    "date_commandes_depart" => 20150326
  ]
  "types" => []
]

[
  "sql" => """
    SELECT dc.prix_mise_en_relation, dc.commentaire_fusacq, dc.id_detail_cmde, dc.demande_recredit,\r\n
                        dc.commentaire_qualite_mer, dc.note_mer, dc.traitement_retour_qualite, dc.type_annonce, \r\n
                        av.nom_contact, av.telephone, av.id_annonce_vendeur,\r\n
                        cm.mode_reglement, av.titre_annonce, cm.date_livraison, av.id_region, av.id_departement, \r\n
                        av.zone_geographique, av.publi_annonce\r\n
                        FROM fusacq_dbo.annonces_vendeur av, fusacq_dbo.commandes cm, fusacq_dbo.details_commande dc\r\n
                        WHERE cm.etat != 'avortee'\r\n
                        AND dc.id_cpte_utilisateur = :login_utilisateur\r\n
                        AND dc.id_commande = cm.id_commande\r\n
                        AND dc.id_cpte_utilisateur = cm.id_cpte_utilisateur\r\n
                        AND dc.id_annonce = av.id_annonce_vendeur\r\n
                        AND dc.type_annonce = 'vendeur'\r\n
                        AND cm.date_livraison >= :date_commandes_depart\r\n
                        ORDER BY dc.id_detail_cmde DESC
    """
  "params" => [
    "login_utilisateur" => "91466"
    "date_commandes_depart" => 20250408
  ]
  "types" => []
]

[
  "sql" => """
    SELECT dc.prix_mise_en_relation, dc.commentaire_fusacq, dc.id_detail_cmde, dc.demande_recredit,\r\n
                        dc.commentaire_qualite_mer, dc.note_mer, dc.traitement_retour_qualite, aa.nom_contact, \r\n
                        aa.telephone, aa.id_annonce_acheteur, cm.mode_reglement, aa.titre_annonce,\r\n
                        cm.date_livraison, aa.id_region, aa.id_departement\r\n
                        FROM fusacq_dbo.annonces_acheteur aa, fusacq_dbo.commandes cm, fusacq_dbo.details_commande dc\r\n
                        WHERE cm.etat != 'avortee'\r\n
                        AND dc.id_cpte_utilisateur = :login_utilisateur\r\n
                        AND dc.id_commande = cm.id_commande\r\n
                        AND dc.id_cpte_utilisateur = cm.id_cpte_utilisateur\r\n
                        AND dc.id_annonce = aa.id_annonce_acheteur\r\n
                        AND dc.type_annonce = 'acheteur'\r\n
                        AND cm.date_livraison >= :date_commandes_depart\r\n
                        ORDER BY cm.date_livraison DESC
    """
  "params" => [
    "login_utilisateur" => "91466"
    "date_commandes_depart" => 20250408
  ]
  "types" => []
]

[
  "sql" => """
    SELECT dc.prix_mise_en_relation, dc.commentaire_fusacq, dc.id_detail_cmde, dc.demande_recredit,\r\n
                        dc.commentaire_qualite_mer, dc.note_mer, dc.traitement_retour_qualite, aa.nom as nom_contact, \r\n
                        aa.telephone, aa.id_repreneur, cm.mode_reglement, aa.titre_profil as titre_annonce,\r\n
                        cm.date_livraison, aa.code_postal\r\n
                        FROM fusacq_dbo.annuaire_repreneurs aa, fusacq_dbo.commandes cm, fusacq_dbo.details_commande dc\r\n
                        WHERE cm.etat != 'avortee'\r\n
                        AND dc.id_cpte_utilisateur = :login_utilisateur\r\n
                        AND dc.id_commande = cm.id_commande\r\n
                        AND dc.id_cpte_utilisateur = cm.id_cpte_utilisateur\r\n
                        AND dc.id_annonce = aa.id_repreneur\r\n
                        AND dc.type_annonce = 'repreneur'\r\n
                        AND cm.date_livraison >= :date_commandes_depart
    """
  "params" => [
    "login_utilisateur" => "91466"
    "date_commandes_depart" => 20250408
  ]
  "types" => []
]

[
  "sql" => """
    SELECT dc.prix_mise_en_relation, dc.commentaire_fusacq, dc.id_detail_cmde, dc.demande_recredit,\r\n
                        dc.commentaire_qualite_mer, dc.note_mer, dc.traitement_retour_qualite, aa.nom_contact, \r\n
                        aa.telephone_contact, aa.id_investisseur, cm.mode_reglement, aa.titre_investisseur as titre_annonce,\r\n
                        cm.date_livraison\r\n
                        FROM fusacq_dbo.investisseurs_prives aa, fusacq_dbo.commandes cm, fusacq_dbo.details_commande dc\r\n
                        WHERE cm.etat != 'avortee'\r\n
                        AND dc.id_cpte_utilisateur = :login_utilisateur\r\n
                        AND dc.id_commande = cm.id_commande\r\n
                        AND dc.id_cpte_utilisateur = cm.id_cpte_utilisateur\r\n
                        AND dc.id_annonce = aa.id_investisseur\r\n
                        AND dc.type_annonce = 'investisseur_prive'\r\n
                        AND cm.date_livraison >= :date_commandes_depart
    """
  "params" => [
    "login_utilisateur" => "91466"
    "date_commandes_depart" => 20250408
  ]
  "types" => []
]

[
  "sql" => """
    SELECT dc.prix_mise_en_relation, dc.commentaire_fusacq, dc.id_detail_cmde, dc.demande_recredit,\r\n
                        dc.commentaire_qualite_mer, dc.note_mer, dc.traitement_retour_qualite, dc.type_annonce,\r\n
                        s.nom_president as nom_contact, s.telephone, s.id_societe,\r\n
                        cm.mode_reglement, s.raison_sociale, cm.date_livraison, s.id_region, s.id_pays\r\n
                        FROM fusacq_dbo.societes s, fusacq_dbo.commandes cm, fusacq_dbo.details_commande dc\r\n
                        WHERE cm.etat != 'avortee'\r\n
                        AND dc.id_cpte_utilisateur = :login_utilisateur\r\n
                        AND dc.id_commande = cm.id_commande\r\n
                        AND dc.id_cpte_utilisateur = cm.id_cpte_utilisateur\r\n
                        AND dc.id_annonce = s.id_societe\r\n
                        AND dc.type_annonce = 'participation'\r\n
                        AND cm.date_livraison >= :date_commandes_depart\r\n
                        ORDER BY dc.id_detail_cmde DESC
    """
  "params" => [
    "login_utilisateur" => "91466"
    "date_commandes_depart" => 20250408
  ]
  "types" => []
]

[
  "sql" => """
    SELECT dc.prix_mise_en_relation, dc.commentaire_fusacq, dc.id_detail_cmde, dc.demande_recredit,\r\n
                        dc.commentaire_qualite_mer, dc.note_mer, dc.traitement_retour_qualite, dc.type_annonce,\r\n
                        s.nom_contact, s.telephone, s.id_gestionnaire_fonds,\r\n
                        cm.mode_reglement, s.nom_societe, cm.date_livraison, s.id_region, s.id_pays\r\n
                        FROM fusacq_dbo.societe_gestionnaire_fonds s, fusacq_dbo.commandes cm, fusacq_dbo.details_commande dc\r\n
                        WHERE cm.etat != 'avortee'\r\n
                        AND dc.id_cpte_utilisateur = :login_utilisateur\r\n
                        AND dc.id_commande = cm.id_commande\r\n
                        AND dc.id_cpte_utilisateur = cm.id_cpte_utilisateur\r\n
                        AND dc.id_annonce = s.id_gestionnaire_fonds\r\n
                        AND dc.type_annonce = 'fonds'\r\n
                        AND cm.date_livraison >= :date_commandes_depart\r\n
                        ORDER BY dc.id_detail_cmde DESC
    """
  "params" => [
    "login_utilisateur" => "91466"
    "date_commandes_depart" => 20250408
  ]
  "types" => []
]

[
  "sql" => """
    SELECT dc.prix_mise_en_relation, dc.commentaire_fusacq, dc.id_detail_cmde, dc.demande_recredit,\r\n
                        dc.commentaire_qualite_mer, dc.note_mer, dc.traitement_retour_qualite, dc.type_annonce,\r\n
                        v.id_valorisation, av.titre_annonce, v.nom_contact, v.telephone,\r\n
                        cm.mode_reglement, cm.date_livraison, v.id_region, v.id_pays\r\n
                        FROM fusacq_dbo.valorisations v, fusacq_dbo.commandes cm, fusacq_dbo.details_commande dc, \r\n
                             fusacq_dbo.annonces_vendeur av\r\n
                        WHERE cm.etat != 'avortee'\r\n
                        AND dc.id_cpte_utilisateur = :login_utilisateur\r\n
                        AND dc.id_commande = cm.id_commande\r\n
                        AND v.id_annonce_vendeur = av.id_annonce_vendeur\r\n
                        AND dc.id_cpte_utilisateur = cm.id_cpte_utilisateur\r\n
                        AND dc.id_annonce = v.id_valorisation\r\n
                        AND dc.type_annonce = 'valorisation'\r\n
                        AND cm.date_livraison >= :date_commandes_depart\r\n
                        ORDER BY dc.id_detail_cmde DESC
    """
  "params" => [
    "login_utilisateur" => "91466"
    "date_commandes_depart" => 20250408
  ]
  "types" => []
]

[
  "sql" => """
    SELECT dc.prix_mise_en_relation, dc.commentaire_fusacq, dc.id_detail_cmde, dc.demande_recredit,\r\n
                        dc.commentaire_qualite_mer, dc.note_mer, dc.traitement_retour_qualite, dc.type_annonce,\r\n
                        s.nom_president as nom_contact, s.telephone, s.id_societe,\r\n
                        cm.mode_reglement, s.raison_sociale, cm.date_livraison, s.id_region, s.id_pays\r\n
                        FROM fusacq_dbo.societes s, fusacq_dbo.commandes cm, fusacq_dbo.details_commande dc\r\n
                        WHERE cm.etat != 'avortee'\r\n
                        AND dc.id_cpte_utilisateur = :login_utilisateur\r\n
                        AND dc.id_commande = cm.id_commande\r\n
                        AND dc.id_cpte_utilisateur = cm.id_cpte_utilisateur\r\n
                        AND dc.id_annonce = s.id_societe\r\n
                        AND dc.type_annonce = 'acquereur_historique'\r\n
                        AND cm.date_livraison >= :date_commandes_depart\r\n
                        ORDER BY dc.id_detail_cmde DESC
    """
  "params" => [
    "login_utilisateur" => "91466"
    "date_commandes_depart" => 20250408
  ]
  "types" => []
]

[
  "sql" => """
    SELECT c.id_contact, c.id_annonce, c.mode_contact, c.date_demande, c.date_refus, c.date_acceptation,\r\n
                        a.date_parution_initiale, a.date_suppression_attente, a.mode_annonce, a.deja_publique, \r\n
                        a.id_pays, a.id_region, a.id_departement, a.code_postal, a.id_ville, a.nom_ville, \r\n
                        a.proximite_ville, a.surface, a.id_secteur_activite_niveau1, a.liste_ids_secteurs_activite,\r\n
                        a.nom_secteur_activite_affichage, a.prenom_contact, a.nom_contact, a.id_utilisateur as id_deposant,\r\n
                        a.destinataire_demandes, a.titre_annonce\r\n
                        FROM commerces_dbo.contacts c\r\n
                        LEFT JOIN commerces_dbo.annonces a ON c.id_annonce = a.id_annonce\r\n
                        WHERE c.id_utilisateur = :id_utilisateur\r\n
                        ORDER BY \r\n
                            CASE c.mode_contact \r\n
                                WHEN 'attente' THEN 1 \r\n
                                WHEN 'demande' THEN 2 \r\n
                                WHEN 'accepte' THEN 3 \r\n
                                WHEN 'refuse' THEN 4 \r\n
                                ELSE 5 \r\n
                            END, \r\n
                            c.id_annonce DESC
    """
  "params" => [
    "id_utilisateur" => 91466
  ]
  "types" => []
]

[
  "sql" => """
    SELECT cc.*, du.id_compte_client\r\n
                        FROM fusacq_dbo.comptes_clients cc\r\n
                        LEFT JOIN fusacq_dbo.detail_utilisateurs du ON cc.id_compte_client = du.id_compte_client\r\n
                        WHERE du.id_utilisateur = :id_utilisateur\r\n
                        LIMIT 1
    """
  "params" => [
    "id_utilisateur" => 91466
  ]
  "types" => []
]

[
  "sql" => "DELETE FROM fusacq_dbo.sso_token WHERE expires_at < ? AND used_by IS NULL"
  "params" => [
    1 => "2026-04-08 00:00:00"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(s0_.id) AS sclr_0 FROM fusacq_dbo.sso_token s0_ WHERE s0_.jti = ?"
  "params" => [
    1 => "7bcf336500df746441496de2853081d4ffa937c3eaf8dd683a6f3a578dcb5f1e"
  ]
  "types" => [
    1 => 2
  ]
]