Symfony Profiler

SELECT
  id_actualite,
  jour,
  mois,
  type_actualite,
  titre_actualite,
  date_mise_en_ligne
FROM
  (
    SELECT
      id_actualite,
      SUBSTRING(date_mise_en_ligne, 7, 2) AS jour,
      SUBSTRING(date_mise_en_ligne, 5, 2) AS mois,
      type_actualite,
      titre_actualite,
      date_mise_en_ligne,
      ROW_NUMBER() OVER (
        PARTITION BY
          type_actualite
        ORDER BY
          date_mise_en_ligne DESC
      ) AS rn
    FROM
      buzz_actualites
    WHERE
      provenance_flux_actualite = 'blog'
      AND mode_actualite = 'publique'
      AND date_mise_en_ligne <= :now
      AND id_localisation LIKE CONCAT(:idPays, '%')
  ) t
WHERE
  rn <= 2
ORDER BY
  date_mise_en_ligne DESC,
  id_actualite DESC

SELECT id_actualite, jour, mois, type_actualite, titre_actualite, date_mise_en_ligne
        FROM (
            SELECT
                id_actualite,
                SUBSTRING(date_mise_en_ligne, 7, 2) AS jour,
                SUBSTRING(date_mise_en_ligne, 5, 2) AS mois,
                type_actualite,
                titre_actualite,
                date_mise_en_ligne,
                ROW_NUMBER() OVER (PARTITION BY type_actualite ORDER BY date_mise_en_ligne DESC) AS rn
            FROM buzz_actualites
            WHERE
                provenance_flux_actualite = 'blog'
                AND mode_actualite = 'publique'
                AND date_mise_en_ligne <= '20260403171054'
                AND id_localisation LIKE CONCAT('33', '%')
        ) t
        WHERE rn <= 2
        ORDER BY date_mise_en_ligne DESC, id_actualite DESC
    ;

SELECT
  t0.id_societe AS id_societe_1,
  t0.id_societe_news AS id_societe_news_2,
  t0.id_participation AS id_participation_3,
  t0.mode_participation AS mode_participation_4,
  t0.deja_publique AS deja_publique_5,
  t0.raison_sociale AS raison_sociale_6,
  t0.raison_sociale_formatee AS raison_sociale_formatee_7,
  t0.nom_president AS nom_president_8,
  t0.nom_directeur_general AS nom_directeur_general_9,
  t0.adresse AS adresse_10,
  t0.ville AS ville_11,
  t0.code_postal AS code_postal_12,
  t0.telephone AS telephone_13,
  t0.fax AS fax_14,
  t0.id_pays AS id_pays_15,
  t0.devise AS devise_16,
  t0.id_region AS id_region_17,
  t0.filiales_bureaux AS filiales_bureaux_18,
  t0.id_secteur_activite AS id_secteur_activite_19,
  t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20,
  t0.site_internet AS site_internet_21,
  t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22,
  t0.mail_contact AS mail_contact_23,
  t0.resume_activite AS resume_activite_24,
  t0.description_activite AS description_activite_25,
  t0.mots_cles AS mots_cles_26,
  t0.strategie_developpement AS strategie_developpement_27,
  t0.marge_brute_n AS marge_brute_n_28,
  t0.resultat_exploitation_n AS resultat_exploitation_n_29,
  t0.resultat_net_n AS resultat_net_n_30,
  t0.ca_n AS ca_n_31,
  t0.nb_personnes_n AS nb_personnes_n_32,
  t0.annee_n AS annee_n_33,
  t0.date_mise_a_jour AS date_mise_a_jour_34,
  t0.fichier_joint AS fichier_joint_35,
  t0.commentaire_interne AS commentaire_interne_36,
  t0.societe_cotee AS societe_cotee_37,
  t0.login_demande_publication AS login_demande_publication_38,
  t0.date_relance AS date_relance_39,
  t0.relance_mise_a_jour AS relance_mise_a_jour_40,
  t0.numero_siren AS numero_siren_41,
  t0.montant_total_investi AS montant_total_investi_42,
  t0.capital_total_investisseur AS capital_total_investisseur_43,
  t0.titre_newsletter AS titre_newsletter_44,
  t0.resume_newsletter AS resume_newsletter_45,
  t0.date_dernier_investissement AS date_dernier_investissement_46,
  t0.type_profil_participation AS type_profil_participation_47,
  t0.mode_societe AS mode_societe_48,
  t0.utiliser_artviper AS utiliser_artviper_49,
  t0.numero_siret AS numero_siret_50,
  t0.code_naf AS code_naf_51,
  t0.vignette AS vignette_52,
  t0.vignette_small AS vignette_small_53,
  t0.ca_n_inf AS ca_n_inf_54,
  t0.ca_n_sup AS ca_n_sup_55,
  t0.id_societe_mere AS id_societe_mere_56,
  t0.date_maj_administrateur AS date_maj_administrateur_57,
  t0.administrateur AS administrateur_58,
  t0.etat_resume AS etat_resume_59,
  t0.afficher_vendeur AS afficher_vendeur_60,
  t0.afficher_acheteur AS afficher_acheteur_61
FROM
  fusacq_dbo.societes t0
WHERE
  t0.raison_sociale = ?
LIMIT
  1

SELECT t0.id_societe AS id_societe_1, t0.id_societe_news AS id_societe_news_2, t0.id_participation AS id_participation_3, t0.mode_participation AS mode_participation_4, t0.deja_publique AS deja_publique_5, t0.raison_sociale AS raison_sociale_6, t0.raison_sociale_formatee AS raison_sociale_formatee_7, t0.nom_president AS nom_president_8, t0.nom_directeur_general AS nom_directeur_general_9, t0.adresse AS adresse_10, t0.ville AS ville_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.id_pays AS id_pays_15, t0.devise AS devise_16, t0.id_region AS id_region_17, t0.filiales_bureaux AS filiales_bureaux_18, t0.id_secteur_activite AS id_secteur_activite_19, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20, t0.site_internet AS site_internet_21, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22, t0.mail_contact AS mail_contact_23, t0.resume_activite AS resume_activite_24, t0.description_activite AS description_activite_25, t0.mots_cles AS mots_cles_26, t0.strategie_developpement AS strategie_developpement_27, t0.marge_brute_n AS marge_brute_n_28, t0.resultat_exploitation_n AS resultat_exploitation_n_29, t0.resultat_net_n AS resultat_net_n_30, t0.ca_n AS ca_n_31, t0.nb_personnes_n AS nb_personnes_n_32, t0.annee_n AS annee_n_33, t0.date_mise_a_jour AS date_mise_a_jour_34, t0.fichier_joint AS fichier_joint_35, t0.commentaire_interne AS commentaire_interne_36, t0.societe_cotee AS societe_cotee_37, t0.login_demande_publication AS login_demande_publication_38, t0.date_relance AS date_relance_39, t0.relance_mise_a_jour AS relance_mise_a_jour_40, t0.numero_siren AS numero_siren_41, t0.montant_total_investi AS montant_total_investi_42, t0.capital_total_investisseur AS capital_total_investisseur_43, t0.titre_newsletter AS titre_newsletter_44, t0.resume_newsletter AS resume_newsletter_45, t0.date_dernier_investissement AS date_dernier_investissement_46, t0.type_profil_participation AS type_profil_participation_47, t0.mode_societe AS mode_societe_48, t0.utiliser_artviper AS utiliser_artviper_49, t0.numero_siret AS numero_siret_50, t0.code_naf AS code_naf_51, t0.vignette AS vignette_52, t0.vignette_small AS vignette_small_53, t0.ca_n_inf AS ca_n_inf_54, t0.ca_n_sup AS ca_n_sup_55, t0.id_societe_mere AS id_societe_mere_56, t0.date_maj_administrateur AS date_maj_administrateur_57, t0.administrateur AS administrateur_58, t0.etat_resume AS etat_resume_59, t0.afficher_vendeur AS afficher_vendeur_60, t0.afficher_acheteur AS afficher_acheteur_61 FROM fusacq_dbo.societes t0 WHERE t0.raison_sociale = 'SO PARTNERS' LIMIT 1;

SELECT
  id,
  titre_annonce,
  date_parution_initiale_complete,
  date_parution_initiale,
  type_annonce,
  date_tri
FROM
  (
    SELECT
      id_annonce_vendeur AS id,
      titre_annonce,
      date_parution_initiale_complete,
      date_parution_initiale,
      'V' AS type_annonce,
      CASE WHEN date_parution_initiale_complete IS NOT NULL
      AND date_parution_initiale_complete != ''
      AND LENGTH(
        date_parution_initiale_complete
      ) >= 12
      AND LENGTH(
        date_parution_initiale_complete
      ) <= 14 THEN CASE WHEN LENGTH(
        date_parution_initiale_complete
      ) = 14 THEN date_parution_initiale_complete ELSE CONCAT(
        date_parution_initiale_complete,
        '00'
      ) END ELSE CONCAT(
        date_parution_initiale, '000000'
      ) END AS date_tri
    FROM
      annonces_vendeur
    WHERE
      mode_annonce = 'publique'
      AND tpe_pme = 'oui'
      AND visible_dernieres_annonces IS NULL
      AND date_parution_initiale IS NOT NULL
    UNION ALL
    SELECT
      id_annonce_acheteur AS id,
      titre_annonce,
      date_parution_initiale_complete,
      date_parution_initiale,
      'A' AS type_annonce,
      CASE WHEN date_parution_initiale_complete IS NOT NULL
      AND date_parution_initiale_complete != ''
      AND LENGTH(
        date_parution_initiale_complete
      ) >= 12
      AND LENGTH(
        date_parution_initiale_complete
      ) <= 14 THEN CASE WHEN LENGTH(
        date_parution_initiale_complete
      ) = 14 THEN date_parution_initiale_complete ELSE CONCAT(
        date_parution_initiale_complete,
        '00'
      ) END ELSE CONCAT(
        date_parution_initiale, '000000'
      ) END AS date_tri
    FROM
      annonces_acheteur
    WHERE
      mode_annonce = 'publique'
      AND tpe_pme = 'oui'
      AND date_parution_initiale IS NOT NULL
    UNION ALL
    SELECT
      id_repreneur AS id,
      titre_profil AS titre_annonce,
      date_parution_initiale_complete,
      date_parution_initiale,
      'R' AS type_annonce,
      CASE WHEN date_parution_initiale_complete IS NOT NULL
      AND date_parution_initiale_complete != ''
      AND LENGTH(
        date_parution_initiale_complete
      ) >= 12
      AND LENGTH(
        date_parution_initiale_complete
      ) <= 14 THEN CASE WHEN LENGTH(
        date_parution_initiale_complete
      ) = 14 THEN date_parution_initiale_complete ELSE CONCAT(
        date_parution_initiale_complete,
        '00'
      ) END ELSE CONCAT(
        date_parution_initiale, '000000'
      ) END AS date_tri
    FROM
      annuaire_repreneurs
    WHERE
      mode_profil = 'publique'
      AND date_parution_initiale IS NOT NULL
  ) AS en_direct
ORDER BY
  date_tri DESC,
  id DESC
LIMIT
  :limit

SELECT
                id,
                titre_annonce,
                date_parution_initiale_complete,
                date_parution_initiale,
                type_annonce,
                date_tri
            FROM (
                SELECT
                    id_annonce_vendeur AS id,
                    titre_annonce,
                    date_parution_initiale_complete,
                    date_parution_initiale,
                    'V' AS type_annonce,
                    CASE 
                        WHEN date_parution_initiale_complete IS NOT NULL 
                             AND date_parution_initiale_complete != '' 
                             AND LENGTH(date_parution_initiale_complete) >= 12 
                             AND LENGTH(date_parution_initiale_complete) <= 14
                        THEN 
                            CASE 
                                WHEN LENGTH(date_parution_initiale_complete) = 14 
                                THEN date_parution_initiale_complete
                                ELSE CONCAT(date_parution_initiale_complete, '00')
                            END
                        ELSE CONCAT(date_parution_initiale, '000000')
                    END AS date_tri
                FROM annonces_vendeur
                WHERE mode_annonce = 'publique'
                AND tpe_pme = 'oui'
                AND visible_dernieres_annonces IS NULL
                AND date_parution_initiale IS NOT NULL
                UNION ALL
                SELECT
                    id_annonce_acheteur AS id,
                    titre_annonce,
                    date_parution_initiale_complete,
                    date_parution_initiale,
                    'A' AS type_annonce,
                    CASE 
                        WHEN date_parution_initiale_complete IS NOT NULL 
                             AND date_parution_initiale_complete != '' 
                             AND LENGTH(date_parution_initiale_complete) >= 12 
                             AND LENGTH(date_parution_initiale_complete) <= 14
                        THEN 
                            CASE 
                                WHEN LENGTH(date_parution_initiale_complete) = 14 
                                THEN date_parution_initiale_complete
                                ELSE CONCAT(date_parution_initiale_complete, '00')
                            END
                        ELSE CONCAT(date_parution_initiale, '000000')
                    END AS date_tri
                FROM annonces_acheteur
                WHERE mode_annonce = 'publique'
                AND tpe_pme = 'oui'
                AND date_parution_initiale IS NOT NULL
                UNION ALL
                SELECT
                    id_repreneur AS id,
                    titre_profil AS titre_annonce,
                    date_parution_initiale_complete,
                    date_parution_initiale,
                    'R' AS type_annonce,
                    CASE 
                        WHEN date_parution_initiale_complete IS NOT NULL 
                             AND date_parution_initiale_complete != '' 
                             AND LENGTH(date_parution_initiale_complete) >= 12 
                             AND LENGTH(date_parution_initiale_complete) <= 14
                        THEN 
                            CASE 
                                WHEN LENGTH(date_parution_initiale_complete) = 14 
                                THEN date_parution_initiale_complete
                                ELSE CONCAT(date_parution_initiale_complete, '00')
                            END
                        ELSE CONCAT(date_parution_initiale, '000000')
                    END AS date_tri
                FROM annuaire_repreneurs
                WHERE mode_profil = 'publique'
                AND date_parution_initiale IS NOT NULL
            ) AS en_direct
            ORDER BY date_tri DESC, id DESC
            LIMIT 5
        ;

SELECT
  a0_.id_annonce_vendeur AS id_annonce_vendeur_0,
  a0_.titre_annonce AS titre_annonce_1,
  a0_.description_activite AS description_activite_2,
  a0_.date_parution AS date_parution_3,
  a0_.date_parution_initiale AS date_parution_initiale_4,
  a0_.id_secteur_activite AS id_secteur_activite_5,
  a0_.code_naf_oseo_nouveau AS code_naf_oseo_nouveau_6,
  a0_.ca_n AS ca_n_7,
  a0_.id_departement AS id_departement_8,
  a0_.id_region AS id_region_9,
  a0_.id_pays AS id_pays_10,
  a0_.zone_geographique AS zone_geographique_11
FROM
  buzz_lien_operations_annonces_vendeur b1_
  LEFT JOIN fusacq_dbo.annonces_vendeur a0_ ON (
    b1_.id_annonce = a0_.id_annonce_vendeur
  )
WHERE
  b1_.id_operation = ?
ORDER BY
  a0_.ca_n DESC
LIMIT
  5

SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.description_activite AS description_activite_2, a0_.date_parution AS date_parution_3, a0_.date_parution_initiale AS date_parution_initiale_4, a0_.id_secteur_activite AS id_secteur_activite_5, a0_.code_naf_oseo_nouveau AS code_naf_oseo_nouveau_6, a0_.ca_n AS ca_n_7, a0_.id_departement AS id_departement_8, a0_.id_region AS id_region_9, a0_.id_pays AS id_pays_10, a0_.zone_geographique AS zone_geographique_11 FROM buzz_lien_operations_annonces_vendeur b1_ LEFT JOIN fusacq_dbo.annonces_vendeur a0_ ON (b1_.id_annonce = a0_.id_annonce_vendeur) WHERE b1_.id_operation = 12517 ORDER BY a0_.ca_n DESC LIMIT 5;

SELECT
  a0_.id_annonce_acheteur AS id_annonce_acheteur_0,
  a0_.titre_annonce AS titre_annonce_1,
  a0_.ca_max AS ca_max_2,
  a0_.id_region AS id_region_3,
  a0_.id_pays AS id_pays_4,
  a0_.id_departement AS id_departement_5,
  a0_.autres_localisations AS autres_localisations_6
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.id_secteur_activite = ?
  AND a0_.mode_annonce = ?
  AND a0_.tpe_pme = ?
ORDER BY
  a0_.date_parution_initiale DESC
LIMIT
  5

SELECT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.ca_max AS ca_max_2, a0_.id_region AS id_region_3, a0_.id_pays AS id_pays_4, a0_.id_departement AS id_departement_5, a0_.autres_localisations AS autres_localisations_6 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.id_secteur_activite = NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' ORDER BY a0_.date_parution_initiale DESC LIMIT 5;

SELECT
  b0_.id_secteur_activite AS id_secteur_activite_0
FROM
  fusacq_dbo.buzz_operations b0_
WHERE
  b0_.id_operation = ?
LIMIT
  1

SELECT b0_.id_secteur_activite AS id_secteur_activite_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_operation = 12517 LIMIT 1;

SELECT
  provenance_flux_actualite,
  visibilite_flux
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?
LIMIT
  1

SELECT provenance_flux_actualite, visibilite_flux FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 99091 LIMIT 1;

SELECT
  DISTINCT b0_.id_operation AS id_operation_0,
  b1_.id_actualite AS id_actualite_1,
  b1_.date_mise_en_ligne AS date_mise_en_ligne_2,
  b1_.titre_actualite AS titre_actualite_3,
  b1_.provenance_flux_actualite AS provenance_flux_actualite_4,
  b1_.autorisation_blog AS autorisation_blog_5
FROM
  fusacq_dbo.buzz_roles b0_
  LEFT JOIN fusacq_dbo.buzz_actualites b1_ ON (
    b0_.id_operation = b1_.id_operation
  )
WHERE
  b1_.mode_actualite = ?
  AND b1_.mode_actualite <> ?
  AND b1_.date_mise_en_ligne IS NOT NULL
  AND b1_.date_mise_en_ligne <> ?
  AND SUBSTRING(
    b1_.date_mise_en_ligne
    FROM
      1 FOR 8
  ) <= ?
  AND b1_.autorisation_blog <> ?
  AND (
    (
      b0_.id_acteur = ?
      AND b0_.table_sql_acteur = ?
    )
    OR (
      b0_.id_acteur_passif = ?
      AND b0_.table_sql_acteur_passif = ?
    )
  )
ORDER BY
  b1_.date_mise_en_ligne DESC
LIMIT
  1000

SELECT DISTINCT b0_.id_operation AS id_operation_0, b1_.id_actualite AS id_actualite_1, b1_.date_mise_en_ligne AS date_mise_en_ligne_2, b1_.titre_actualite AS titre_actualite_3, b1_.provenance_flux_actualite AS provenance_flux_actualite_4, b1_.autorisation_blog AS autorisation_blog_5 FROM fusacq_dbo.buzz_roles b0_ LEFT JOIN fusacq_dbo.buzz_actualites b1_ ON (b0_.id_operation = b1_.id_operation) WHERE b1_.mode_actualite = 'publique' AND b1_.mode_actualite <> 'supprime' AND b1_.date_mise_en_ligne IS NOT NULL AND b1_.date_mise_en_ligne <> '' AND SUBSTRING(b1_.date_mise_en_ligne FROM 1 FOR 8) <= '20260403' AND b1_.autorisation_blog <> 'non' AND ((b0_.id_acteur = '887' AND b0_.table_sql_acteur = 'societes_news') OR (b0_.id_acteur_passif = '887' AND b0_.table_sql_acteur_passif = 'societes_news')) ORDER BY b1_.date_mise_en_ligne DESC LIMIT 1000;

SELECT
  b0_.id_actualite AS id_actualite_0,
  b0_.date_mise_en_ligne AS date_mise_en_ligne_1,
  b0_.titre_actualite AS titre_actualite_2,
  s1_.resume_service AS resume_service_3
FROM
  fusacq_dbo.buzz_actualites b0_
  LEFT JOIN fusacq_dbo.services_prestataire s1_ ON (
    b0_.id_service_principal = s1_.id_service_prestataire
  )
WHERE
  b0_.date_mise_en_ligne IS NOT NULL
  AND b0_.id_societe_prestataire = ?
  AND b0_.mode_actualite = ?
  AND b0_.mode_actualite <> ?
  AND b0_.date_mise_en_ligne <= ?
ORDER BY
  b0_.date_mise_en_ligne DESC
LIMIT
  1000

SELECT b0_.id_actualite AS id_actualite_0, b0_.date_mise_en_ligne AS date_mise_en_ligne_1, b0_.titre_actualite AS titre_actualite_2, s1_.resume_service AS resume_service_3 FROM fusacq_dbo.buzz_actualites b0_ LEFT JOIN fusacq_dbo.services_prestataire s1_ ON (b0_.id_service_principal = s1_.id_service_prestataire) WHERE b0_.date_mise_en_ligne IS NOT NULL AND b0_.id_societe_prestataire = 887 AND b0_.mode_actualite = 'publique' AND b0_.mode_actualite <> 'supprime' AND b0_.date_mise_en_ligne <= '20260403171053' ORDER BY b0_.date_mise_en_ligne DESC LIMIT 1000;

SELECT
  id_actualite,
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_operation = ?
  AND id_actualite != ?
  AND mode_actualite = ?
  AND photo_actualite IS NOT NULL
  AND photo_actualite != ""
  AND photo_actualite != "NULL"
ORDER BY
  date_mise_en_ligne DESC
LIMIT
  1

SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = 12517 
                AND id_actualite != 99091 
                AND mode_actualite = 'publique'
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
            ;

SELECT
  sa.image_filename
FROM
  fusacq_dbo.buzz_actualites ba
  LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_operation = bo.id_operation
  LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
WHERE
  ba.id_actualite = ?
  AND ba.id_operation IS NOT NULL
  AND sa.image_filename IS NOT NULL
  AND sa.image_filename != ""
LIMIT
  1

SELECT sa.image_filename 
                FROM fusacq_dbo.buzz_actualites ba
                LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_operation = bo.id_operation
                LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                WHERE ba.id_actualite = 99091
                AND ba.id_operation IS NOT NULL
                AND sa.image_filename IS NOT NULL 
                AND sa.image_filename != ""
                LIMIT 1
            ;

SELECT
  t0.id_service_prestataire AS id_service_prestataire_1,
  t0.id_societe_prestataire AS id_societe_prestataire_2,
  t0.id_langue AS id_langue_3,
  t0.titre_service AS titre_service_4,
  t0.nom_contact1 AS nom_contact1_5,
  t0.email_contact1 AS email_contact1_6,
  t0.nom_contact2 AS nom_contact2_7,
  t0.email_contact2 AS email_contact2_8,
  t0.url_site_web AS url_site_web_9,
  t0.url_site_web_visible AS url_site_web_visible_10,
  t0.tel AS tel_11,
  t0.fax AS fax_12,
  t0.description_service AS description_service_13,
  t0.resume_service AS resume_service_14,
  t0.nom_commercial_societe AS nom_commercial_societe_15,
  t0.statut AS statut_16,
  t0.id_secteur_activite AS id_secteur_activite_17,
  t0.id_secteur_new AS id_secteur_new_18,
  t0.id_localisation_prestataire AS id_localisation_prestataire_19,
  t0.cout_mensuel AS cout_mensuel_20,
  t0.date_demande_publication AS date_demande_publication_21,
  t0.deja_publique AS deja_publique_22,
  t0.date_mise_en_ligne AS date_mise_en_ligne_23,
  t0.gratuite_service AS gratuite_service_24,
  t0.montant_gratuite AS montant_gratuite_25,
  t0.adresse AS adresse_26,
  t0.code_postal AS code_postal_27,
  t0.ville AS ville_28,
  t0.pays AS pays_29,
  t0.contact_si_autre_service AS contact_si_autre_service_30,
  t0.resume_newsletter AS resume_newsletter_31,
  t0.nb_apparitions_newsletter AS nb_apparitions_newsletter_32,
  t0.localisation_pour_referencement AS localisation_pour_referencement_33,
  t0.titre_newsletter AS titre_newsletter_34,
  t0.inscription_partenaire AS inscription_partenaire_35,
  t0.date_fin_gratuite_estimee AS date_fin_gratuite_estimee_36,
  t0.suivi_prestation AS suivi_prestation_37,
  t0.remuneration_partenaire_si_gratuite AS remuneration_partenaire_si_gratuite_38,
  t0.numero_adherent_cncfa AS numero_adherent_cncfa_39,
  t0.id_reseau AS id_reseau_40,
  t0.visibilite AS visibilite_41,
  t0.utiliser_artviper AS utiliser_artviper_42,
  t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_43,
  t0.url_vignette AS url_vignette_44,
  t0.date_derniere_mise_en_avant AS date_derniere_mise_en_avant_45,
  t0.id_pays AS id_pays_46
FROM
  fusacq_dbo.services_prestataire t0
WHERE
  t0.id_service_prestataire = ?
LIMIT
  1

SELECT t0.id_service_prestataire AS id_service_prestataire_1, t0.id_societe_prestataire AS id_societe_prestataire_2, t0.id_langue AS id_langue_3, t0.titre_service AS titre_service_4, t0.nom_contact1 AS nom_contact1_5, t0.email_contact1 AS email_contact1_6, t0.nom_contact2 AS nom_contact2_7, t0.email_contact2 AS email_contact2_8, t0.url_site_web AS url_site_web_9, t0.url_site_web_visible AS url_site_web_visible_10, t0.tel AS tel_11, t0.fax AS fax_12, t0.description_service AS description_service_13, t0.resume_service AS resume_service_14, t0.nom_commercial_societe AS nom_commercial_societe_15, t0.statut AS statut_16, t0.id_secteur_activite AS id_secteur_activite_17, t0.id_secteur_new AS id_secteur_new_18, t0.id_localisation_prestataire AS id_localisation_prestataire_19, t0.cout_mensuel AS cout_mensuel_20, t0.date_demande_publication AS date_demande_publication_21, t0.deja_publique AS deja_publique_22, t0.date_mise_en_ligne AS date_mise_en_ligne_23, t0.gratuite_service AS gratuite_service_24, t0.montant_gratuite AS montant_gratuite_25, t0.adresse AS adresse_26, t0.code_postal AS code_postal_27, t0.ville AS ville_28, t0.pays AS pays_29, t0.contact_si_autre_service AS contact_si_autre_service_30, t0.resume_newsletter AS resume_newsletter_31, t0.nb_apparitions_newsletter AS nb_apparitions_newsletter_32, t0.localisation_pour_referencement AS localisation_pour_referencement_33, t0.titre_newsletter AS titre_newsletter_34, t0.inscription_partenaire AS inscription_partenaire_35, t0.date_fin_gratuite_estimee AS date_fin_gratuite_estimee_36, t0.suivi_prestation AS suivi_prestation_37, t0.remuneration_partenaire_si_gratuite AS remuneration_partenaire_si_gratuite_38, t0.numero_adherent_cncfa AS numero_adherent_cncfa_39, t0.id_reseau AS id_reseau_40, t0.visibilite AS visibilite_41, t0.utiliser_artviper AS utiliser_artviper_42, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_43, t0.url_vignette AS url_vignette_44, t0.date_derniere_mise_en_avant AS date_derniere_mise_en_avant_45, t0.id_pays AS id_pays_46 FROM fusacq_dbo.services_prestataire t0 WHERE t0.id_service_prestataire = 743 LIMIT 1;

SELECT
  sa.image_filename
FROM
  fusacq_dbo.buzz_actualites ba
  LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_actualite = bo.id_actualite_principale
  LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
WHERE
  ba.id_actualite = ?
  AND sa.image_filename IS NOT NULL
  AND sa.image_filename != ""
LIMIT
  1

SELECT sa.image_filename 
                FROM fusacq_dbo.buzz_actualites ba
                LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_actualite = bo.id_actualite_principale
                LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                WHERE ba.id_actualite = 99091
                AND sa.image_filename IS NOT NULL 
                AND sa.image_filename != ""
                LIMIT 1
            ;

SELECT
  sa.image_filename
FROM
  fusacq_dbo.buzz_operations bo
  LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
WHERE
  bo.id_operation = ?
  AND sa.image_filename IS NOT NULL
  AND sa.image_filename != ""
LIMIT
  1

SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = 12517
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
                ;

SELECT
  id_localisation,
  id_localisation_2
FROM
  fusacq_dbo.buzz_operations
WHERE
  id_operation = ?
LIMIT
  1

SELECT id_localisation, id_localisation_2 FROM fusacq_dbo.buzz_operations WHERE id_operation = 12517 LIMIT 1;

SELECT
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?

SELECT photo_actualite FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 99091;

SELECT
  ep.id_membre
FROM
  services_prestataire sp
  LEFT JOIN equipes_prestataire ep ON sp.id_societe_prestataire = ep.id_societe_prestataire
WHERE
  sp.id_service_prestataire = :idServicePrestataire
LIMIT
  1

SELECT ep.id_membre 
                        FROM services_prestataire sp 
                        LEFT JOIN equipes_prestataire ep ON sp.id_societe_prestataire = ep.id_societe_prestataire 
                        WHERE sp.id_service_prestataire = 743 
                        LIMIT 1;

SELECT
  t0.id_actualite AS id_actualite_1,
  t0.nb_affichages AS nb_affichages_2
FROM
  fusacq_dbo.statistiques_nb_consultations_actualites_buzz t0
WHERE
  t0.id_actualite = ?
LIMIT
  1

SELECT t0.id_actualite AS id_actualite_1, t0.nb_affichages AS nb_affichages_2 FROM fusacq_dbo.statistiques_nb_consultations_actualites_buzz t0 WHERE t0.id_actualite = 99091 LIMIT 1;

SELECT
  b0_.id_actualite AS id_actualite_0,
  b0_.date_mise_en_ligne AS date_mise_en_ligne_1,
  b0_.titre_actualite AS titre_actualite_2
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.date_mise_en_ligne IS NOT NULL
  AND b0_.id_societe_prestataire = ?
  AND b0_.provenance_flux_actualite = ?
  AND b0_.mode_actualite = ?
  AND b0_.mode_actualite <> ?
  AND b0_.date_mise_en_ligne < ?
ORDER BY
  b0_.date_mise_en_ligne DESC
LIMIT
  5

SELECT b0_.id_actualite AS id_actualite_0, b0_.date_mise_en_ligne AS date_mise_en_ligne_1, b0_.titre_actualite AS titre_actualite_2 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.date_mise_en_ligne IS NOT NULL AND b0_.id_societe_prestataire = 887 AND b0_.provenance_flux_actualite = 'blog' AND b0_.mode_actualite = 'publique' AND b0_.mode_actualite <> 'supprime' AND b0_.date_mise_en_ligne < '20260403171053' ORDER BY b0_.date_mise_en_ligne DESC LIMIT 5;

SELECT
  c.adresse,
  c.code_postal,
  c.ville,
  c.pays,
  c.telephone,
  c.fax,
  c.email_contact1,
  c.nom_contact1
FROM
  fusacq_dbo.coordonnees_service_prestataire c
WHERE
  c.id_societe_prestataire = ?
UNION ALL
SELECT
  c2.adresse,
  c2.code_postal,
  c2.ville,
  c2.pays,
  c2.telephone,
  c2.fax,
  c2.email_contact1,
  c2.nom_contact1
FROM
  fusacq_dbo.coordonnees_service_prestataire c2
  INNER JOIN fusacq_dbo.services_prestataire s ON s.id_service_prestataire = c2.id_service_prestataire
WHERE
  s.id_societe_prestataire = ?
LIMIT
  1

SELECT c.adresse, c.code_postal, c.ville, c.pays, c.telephone, c.fax, c.email_contact1, c.nom_contact1
                    FROM fusacq_dbo.coordonnees_service_prestataire c
                    WHERE c.id_societe_prestataire = 887
                    UNION ALL
                    SELECT c2.adresse, c2.code_postal, c2.ville, c2.pays, c2.telephone, c2.fax, c2.email_contact1, c2.nom_contact1
                    FROM fusacq_dbo.coordonnees_service_prestataire c2
                    INNER JOIN fusacq_dbo.services_prestataire s ON s.id_service_prestataire = c2.id_service_prestataire
                    WHERE s.id_societe_prestataire = 887
                    LIMIT 1
                ;

SELECT
  t0.id_coordonnees AS id_coordonnees_1,
  t0.id_service_prestataire AS id_service_prestataire_2,
  t0.id_societe_prestataire AS id_societe_prestataire_3,
  t0.adresse AS adresse_4,
  t0.code_postal AS code_postal_5,
  t0.ville AS ville_6,
  t0.pays AS pays_7,
  t0.nom_contact1 AS nom_contact1_8,
  t0.email_contact1 AS email_contact1_9,
  t0.nom_contact2 AS nom_contact2_10,
  t0.email_contact2 AS email_contact2_11,
  t0.telephone AS telephone_12,
  t0.indicatif_telephone AS indicatif_telephone_13,
  t0.fax AS fax_14,
  t0.telephone_contact1 AS telephone_contact1_15,
  t0.indicatif_telephone_contact1 AS indicatif_telephone_contact1_16,
  t0.telephone_contact2 AS telephone_contact2_17,
  t0.indicatif_telephone_contact2 AS indicatif_telephone_contact2_18
FROM
  fusacq_dbo.coordonnees_service_prestataire t0
WHERE
  t0.id_service_prestataire = ?
LIMIT
  1

SELECT t0.id_coordonnees AS id_coordonnees_1, t0.id_service_prestataire AS id_service_prestataire_2, t0.id_societe_prestataire AS id_societe_prestataire_3, t0.adresse AS adresse_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.pays AS pays_7, t0.nom_contact1 AS nom_contact1_8, t0.email_contact1 AS email_contact1_9, t0.nom_contact2 AS nom_contact2_10, t0.email_contact2 AS email_contact2_11, t0.telephone AS telephone_12, t0.indicatif_telephone AS indicatif_telephone_13, t0.fax AS fax_14, t0.telephone_contact1 AS telephone_contact1_15, t0.indicatif_telephone_contact1 AS indicatif_telephone_contact1_16, t0.telephone_contact2 AS telephone_contact2_17, t0.indicatif_telephone_contact2 AS indicatif_telephone_contact2_18 FROM fusacq_dbo.coordonnees_service_prestataire t0 WHERE t0.id_service_prestataire = 743 LIMIT 1;

SELECT
  br.id_type_role,
  btr.nom_role,
  br.table_sql_acteur,
  br.table_sql_acteur_passif,
  br.id_membre,
  br.id_membre_passif,
  br.id_acteur,
  br.id_acteur_passif,
  -- Données des équipes (acteur actif)

  ep.nom AS nom_equipe,
  ep.prenom AS prenom_equipe,
  ep.photo AS photo_miniature_equipe,
  ep.mode_equipe,
  -- Données des équipes (acteur passif)

  ep_passif.nom AS nom_equipe_passif,
  ep_passif.prenom AS prenom_equipe_passif,
  ep_passif.photo AS photo_miniature_equipe_passif,
  ep_passif.mode_equipe AS mode_equipe_passif,
  -- Données des services prestataires (acteur actif)

  sp.nom_commercial_societe AS nom_commercial_societe_prestation,
  sp.statut AS statut_prestation,
  -- Données des services prestataires (acteur passif)

  sp_passif.nom_commercial_societe AS nom_commercial_societe_prestation_passif,
  sp_passif.statut AS statut_prestation_passif,
  -- Données des fonds (acteur actif)

  sgf.nom_societe AS nom_societe_fonds,
  -- Données des fonds (acteur passif)

  sgf_passif.nom_societe AS nom_societe_fonds_passif,
  -- Données des sociétés (acteur actif)

  s.raison_sociale AS nom_societe,
  -- Données des sociétés (acteur passif)

  s_passif.raison_sociale AS nom_societe_passif,
  -- societes_news = id vers societes (même schéma que l’admin Buzz / classes_operation.php)

  s_news_act.raison_sociale AS nom_societe_news_actif,
  s_news_pass.raison_sociale AS nom_societe_news_passif
FROM
  buzz_roles br
  LEFT JOIN buzz_types_roles btr ON br.id_type_role = btr.id_type_role -- JOINs pour les acteurs actifs

  LEFT JOIN equipes_prestataire ep ON br.id_membre = ep.id_membre
  LEFT JOIN services_prestataire sp ON br.id_acteur = sp.id_service_prestataire
  AND br.table_sql_acteur = 'services_prestataire'
  LEFT JOIN societe_gestionnaire_fonds sgf ON br.id_acteur = sgf.id_gestionnaire_fonds
  AND br.table_sql_acteur = 'societe_gestionnaire_fonds'
  LEFT JOIN societes s ON br.id_acteur = s.id_societe
  AND br.table_sql_acteur = 'societes'
  LEFT JOIN societes s_news_act ON br.id_acteur = s_news_act.id_societe
  AND br.table_sql_acteur = 'societes_news' -- JOINs pour les acteurs passifs

  LEFT JOIN equipes_prestataire ep_passif ON br.id_membre_passif = ep_passif.id_membre
  LEFT JOIN services_prestataire sp_passif ON br.id_acteur_passif = sp_passif.id_service_prestataire
  AND br.table_sql_acteur_passif = 'services_prestataire'
  LEFT JOIN societe_gestionnaire_fonds sgf_passif ON br.id_acteur_passif = sgf_passif.id_gestionnaire_fonds
  AND br.table_sql_acteur_passif = 'societe_gestionnaire_fonds'
  LEFT JOIN societes s_passif ON br.id_acteur_passif = s_passif.id_societe
  AND br.table_sql_acteur_passif = 'societes'
  LEFT JOIN societes s_news_pass ON br.id_acteur_passif = s_news_pass.id_societe
  AND br.table_sql_acteur_passif = 'societes_news'
WHERE
  br.id_operation = :idOperation
  AND br.table_sql_acteur <> 'societes_news'
ORDER BY
  br.id_type_role,
  COALESCE(ep.nom, ep_passif.nom)

SELECT 
                br.id_type_role,
                btr.nom_role,
                br.table_sql_acteur,
                br.table_sql_acteur_passif,
                br.id_membre,
                br.id_membre_passif,
                br.id_acteur,
                br.id_acteur_passif,
                -- Données des équipes (acteur actif)

                ep.nom AS nom_equipe,
                ep.prenom AS prenom_equipe,
                ep.photo AS photo_miniature_equipe,
                ep.mode_equipe,
                -- Données des équipes (acteur passif)

                ep_passif.nom AS nom_equipe_passif,
                ep_passif.prenom AS prenom_equipe_passif,
                ep_passif.photo AS photo_miniature_equipe_passif,
                ep_passif.mode_equipe AS mode_equipe_passif,
                -- Données des services prestataires (acteur actif)

                sp.nom_commercial_societe AS nom_commercial_societe_prestation,
                sp.statut AS statut_prestation,
                -- Données des services prestataires (acteur passif)

                sp_passif.nom_commercial_societe AS nom_commercial_societe_prestation_passif,
                sp_passif.statut AS statut_prestation_passif,
                -- Données des fonds (acteur actif)

                sgf.nom_societe AS nom_societe_fonds,
                -- Données des fonds (acteur passif)

                sgf_passif.nom_societe AS nom_societe_fonds_passif,
                -- Données des sociétés (acteur actif)

                s.raison_sociale AS nom_societe,
                -- Données des sociétés (acteur passif)

                s_passif.raison_sociale AS nom_societe_passif,
                -- societes_news = id vers societes (même schéma que l’admin Buzz / classes_operation.php)

                s_news_act.raison_sociale AS nom_societe_news_actif,
                s_news_pass.raison_sociale AS nom_societe_news_passif
            FROM buzz_roles br
            LEFT JOIN buzz_types_roles btr ON br.id_type_role = btr.id_type_role
            -- JOINs pour les acteurs actifs

            LEFT JOIN equipes_prestataire ep ON br.id_membre = ep.id_membre
            LEFT JOIN services_prestataire sp ON br.id_acteur = sp.id_service_prestataire AND br.table_sql_acteur = 'services_prestataire'
            LEFT JOIN societe_gestionnaire_fonds sgf ON br.id_acteur = sgf.id_gestionnaire_fonds AND br.table_sql_acteur = 'societe_gestionnaire_fonds'
            LEFT JOIN societes s ON br.id_acteur = s.id_societe AND br.table_sql_acteur = 'societes'
            LEFT JOIN societes s_news_act ON br.id_acteur = s_news_act.id_societe AND br.table_sql_acteur = 'societes_news'
            -- JOINs pour les acteurs passifs

            LEFT JOIN equipes_prestataire ep_passif ON br.id_membre_passif = ep_passif.id_membre
            LEFT JOIN services_prestataire sp_passif ON br.id_acteur_passif = sp_passif.id_service_prestataire AND br.table_sql_acteur_passif = 'services_prestataire'
            LEFT JOIN societe_gestionnaire_fonds sgf_passif ON br.id_acteur_passif = sgf_passif.id_gestionnaire_fonds AND br.table_sql_acteur_passif = 'societe_gestionnaire_fonds'
            LEFT JOIN societes s_passif ON br.id_acteur_passif = s_passif.id_societe AND br.table_sql_acteur_passif = 'societes'
            LEFT JOIN societes s_news_pass ON br.id_acteur_passif = s_news_pass.id_societe AND br.table_sql_acteur_passif = 'societes_news'
            WHERE br.id_operation = 12517
            AND br.table_sql_acteur <> 'societes_news'
            ORDER BY br.id_type_role, COALESCE(ep.nom, ep_passif.nom)
        ;