https://preprod.fusacq.com/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CSecurityController%253A%253Alogin

Method
GET
HTTP Status
200
IP
47.128.43.26
Profiled on
Token
db2950

Query Metrics

21 Database Queries
19 Different statements
329.12 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 10.80 ms 
SELECT b0_.id_actualite AS id_actualite_0, b0_.date_creation AS date_creation_1, b0_.date_reception AS date_reception_2, b0_.date_mise_en_ligne AS date_mise_en_ligne_3, b0_.date_evenement AS date_evenement_4, b0_.titre_actualite AS titre_actualite_5, b0_.sous_titre AS sous_titre_6, b0_.description_actualite AS description_actualite_7, b0_.provenance_flux_actualite AS provenance_flux_actualite_8, b0_.type_actualite AS type_actualite_9, b0_.nom_fichier_xml AS nom_fichier_xml_10, b0_.id_message_blog AS id_message_blog_11, b0_.id_societe_prestataire AS id_societe_prestataire_12, b0_.id_service_principal AS id_service_principal_13, b0_.id_operation AS id_operation_14, b0_.mode_actualite AS mode_actualite_15, b0_.modifie_par_utilisateur AS modifie_par_utilisateur_16, b0_.deja_publique AS deja_publique_17, b0_.id_actualite_redirection AS id_actualite_redirection_18, b0_.site_internet AS site_internet_19, b0_.pour_en_savoir_plus AS pour_en_savoir_plus_20, b0_.societe_source AS societe_source_21, b0_.mots_cles AS mots_cles_22, b0_.a_la_une AS a_la_une_23, b0_.parution_franchises AS parution_franchises_24, b0_.a_la_une_du_jour AS a_la_une_du_jour_25, b0_.selection_we AS selection_we_26, b0_.a_la_une_accueil AS a_la_une_accueil_27, b0_.a_la_une_news_actu AS a_la_une_news_actu_28, b0_.utiliser_artviper AS utiliser_artviper_29, b0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_30, b0_.visibilite_flux AS visibilite_flux_31, b0_.personne_physique_impliquee AS personne_physique_impliquee_32, b0_.societe_impliquee AS societe_impliquee_33, b0_.fonds_implique AS fonds_implique_34, b0_.id_localisation AS id_localisation_35, b0_.id_secteur_activite AS id_secteur_activite_36, b0_.vignette AS vignette_37, b0_.vignette_small AS vignette_small_38, b0_.photo_actualite AS photo_actualite_39, b0_.alerte_envoyee AS alerte_envoyee_40, b0_.id_participation AS id_participation_41, b0_.id_participation_temporaire AS id_participation_temporaire_42, b0_.id_operation_temporaire AS id_operation_temporaire_43, b0_.id_fonds_bot AS id_fonds_bot_44, b0_.souhaite_classement AS souhaite_classement_45, b0_.souhaite_reseau AS souhaite_reseau_46, b0_.souhaite_prestation AS souhaite_prestation_47, b0_.souhaite_nom_reseau AS souhaite_nom_reseau_48, b0_.autorisation_blog AS autorisation_blog_49, b0_.contact_validation AS contact_validation_50, b0_.commentaires_blog AS commentaires_blog_51, b0_.apparition_classement AS apparition_classement_52, b0_.classement_reseau AS classement_reseau_53, b0_.classement_prestation AS classement_prestation_54, b0_.id_reseau AS id_reseau_55, b0_.suivi_classement AS suivi_classement_56, b0_.is_description_html AS is_description_html_57, b0_.is_forum_active AS is_forum_active_58, b0_.actu_ess AS actu_ess_59, b0_.suivi_actualite AS suivi_actualite_60, b0_.date_validation AS date_validation_61, b0_.indexe_google AS indexe_google_62 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? AND b0_.mode_actualite <> ? LIMIT 1
Parameters: 
[
  190185
  "supprime"
]
View formatted query    View runnable query    Explain query
2 10.36 ms 
SELECT t0.id_societe_prestataire AS id_societe_prestataire_1, t0.raison_sociale AS raison_sociale_2, t0.contact_facturation AS contact_facturation_3, t0.adresse AS adresse_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.pays AS pays_7, t0.telephone AS telephone_8, t0.fax AS fax_9, t0.login_utilisateur AS login_utilisateur_10, t0.mail_contact AS mail_contact_11, t0.etat_abonnement AS etat_abonnement_12, t0.reference_abonnement AS reference_abonnement_13, t0.relance_fin_carte AS relance_fin_carte_14, t0.type_pays AS type_pays_15, t0.numero_tva AS numero_tva_16, t0.complement_abonnement AS complement_abonnement_17, t0.mode_reglement_abonnement AS mode_reglement_abonnement_18, t0.nb_prestations_sans_cb AS nb_prestations_sans_cb_19, t0.nb_coordonnees_par_service AS nb_coordonnees_par_service_20, t0.parametres_blog_site AS parametres_blog_site_21, t0.code_acces_blog AS code_acces_blog_22, t0.abonnements_autres_services AS abonnements_autres_services_23, t0.date_debut_referencement AS date_debut_referencement_24, t0.date_fin_referencement AS date_fin_referencement_25, t0.cession_droit_auteur AS cession_droit_auteur_26, t0.segments_classements_concernes AS segments_classements_concernes_27 FROM fusacq_dbo.societes_prestataire t0 WHERE t0.id_societe_prestataire = ?
Parameters: 
[
  978
]
View formatted query    View runnable query    Explain query
3 12.41 ms 
SELECT c0_.adresse AS adresse_0, c0_.code_postal AS code_postal_1, c0_.ville AS ville_2, c0_.pays AS pays_3, c0_.telephone AS telephone_4, c0_.fax AS fax_5, c0_.email_contact1 AS email_contact1_6, c0_.nom_contact1 AS nom_contact1_7 FROM fusacq_dbo.coordonnees_service_prestataire c0_ WHERE c0_.id_societe_prestataire = ? LIMIT 1
Parameters: 
[
  978
]
View formatted query    View runnable query    Explain query
4 102.16 ms 
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
Parameters: 
[
  "CAPITAL TRANSMISSION PME"
]
View formatted query    View runnable query    Explain query
5 10.14 ms 
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
Parameters: 
[
  961
]
View formatted query    View runnable query    Explain query
6 10.61 ms 
SELECT e0_.id_membre AS id_membre_0 FROM fusacq_dbo.services_prestataire s1_ LEFT JOIN fusacq_dbo.equipes_prestataire e0_ ON (s1_.id_societe_prestataire = e0_.id_societe_prestataire) WHERE s1_.id_service_prestataire = ? LIMIT 1
Parameters: 
[
  961
]
View formatted query    View runnable query    Explain query
7 11.56 ms 
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
Parameters: 
[
  961
]
View formatted query    View runnable query    Explain query
8 10.74 ms 
SELECT b0_.id_actualite AS id_actualite_0, b0_.photo_actualite AS photo_actualite_1 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_operation = ? AND b0_.id_actualite <> ? AND b0_.mode_actualite = ? AND b0_.photo_actualite IS NOT NULL AND b0_.photo_actualite <> '' AND b0_.photo_actualite <> 'NULL' ORDER BY b0_.date_mise_en_ligne DESC LIMIT 1
Parameters: 
[
  23553
  190185
  "publique"
]
View formatted query    View runnable query    Explain query
9 10.27 ms 
SELECT s0_.image_filename AS image_filename_0 FROM fusacq_dbo.buzz_operations b1_ LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b1_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_operation = ? AND s0_.image_filename IS NOT NULL AND s0_.image_filename <> '' LIMIT 1
Parameters: 
[
  23553
]
View formatted query    View runnable query    Explain query
10 10.55 ms 
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.id_societe = ?
Parameters: 
[
  978
]
View formatted query    View runnable query    Explain query
11 11.49 ms 
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
Parameters: 
[
  "publique"
  "supprime"
  ""
  "20260416"
  "non"
  "978"
  "societes_news"
  "978"
  "societes_news"
]
View formatted query    View runnable query    Explain query
12 11.39 ms 
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
Parameters: 
[
  "publique"
  "supprime"
  ""
  "20260416"
  "non"
  "978"
  "societes_news"
  "978"
  "societes_news"
]
View formatted query    View runnable query    Explain query
13 21.54 ms 
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
Parameters: 
[
  978
  "publique"
  "supprime"
  "20260416164128"
]
View formatted query    View runnable query    Explain query
14 10.49 ms 
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
Parameters: 
[
  961
]
View formatted query    View runnable query    Explain query
15 10.13 ms 
SELECT b0_.provenance_flux_actualite AS provenance_flux_actualite_0, b0_.visibilite_flux AS visibilite_flux_1 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters: 
[
  190185
]
View formatted query    View runnable query    Explain query
16 11.54 ms 
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
Parameters: 
[
  978
  "blog"
  "publique"
  "supprime"
  "20260416164128"
]
View formatted query    View runnable query    Explain query
17 11.38 ms 
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,
                ep.nom AS nom_equipe,
                ep.prenom AS prenom_equipe,
                ep.photo AS photo_miniature_equipe,
                ep.mode_equipe,
                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,
                sp.nom_commercial_societe AS nom_commercial_societe_prestation,
                sp.statut AS statut_prestation,
                sp_passif.nom_commercial_societe AS nom_commercial_societe_prestation_passif,
                sp_passif.statut AS statut_prestation_passif,
                sgf.nom_societe AS nom_societe_fonds,
                sgf_passif.nom_societe AS nom_societe_fonds_passif,
                s.raison_sociale AS nom_societe,
                s_passif.raison_sociale AS nom_societe_passif,
                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)
Parameters: 
[
  "idOperation" => 23553
]
View formatted query    View runnable query    Explain query
18 10.47 ms 
SELECT s.raison_sociale AS nom
                FROM buzz_roles br
                INNER JOIN buzz_types_roles btr ON br.id_type_role = btr.id_type_role
                INNER JOIN societes s ON br.id_acteur = s.id_societe AND br.table_sql_acteur = 'societes_news'
                WHERE br.id_operation = :idOperation
                AND LOWER(btr.nom_role) NOT LIKE '%conseil%'
                AND (
                    btr.nom_role LIKE '%quéreur%'
                    OR btr.nom_role LIKE '%quereur%'
                )
                LIMIT 1
Parameters: 
[
  "idOperation" => 23553
]
View formatted query    View runnable query    Explain query
19 10.53 ms 
SELECT s.raison_sociale AS nom
                FROM buzz_roles br
                INNER JOIN buzz_types_roles btr ON br.id_type_role = btr.id_type_role
                INNER JOIN societes s ON br.id_acteur = s.id_societe AND br.table_sql_acteur = 'societes_news'
                WHERE br.id_operation = :idOperation
                AND LOWER(btr.nom_role) NOT LIKE '%conseil%'
                AND (
                    LOWER(btr.nom_role) LIKE '%vendeur%'
                    OR btr.nom_role LIKE '%cédant%'
                    OR btr.nom_role LIKE '%cedant%'
                )
                LIMIT 1
Parameters: 
[
  "idOperation" => 23553
]
View formatted query    View runnable query    Explain query
20 10.46 ms 
SELECT DISTINCT
                CASE WHEN br.table_sql_acteur = 'societes_news' THEN br.id_acteur END AS id_societe_news_1,
                CASE WHEN br.table_sql_acteur_passif = 'societes_news' THEN br.id_acteur_passif END AS id_societe_news_2,
                o.id_actualite_principale
            FROM buzz_roles br
            LEFT JOIN buzz_operations o ON br.id_operation = o.id_operation
            WHERE br.id_operation = :idOperation
Parameters: 
[
  "idOperation" => 23553
]
View formatted query    View runnable query    Explain query
21 10.10 ms 
SELECT id_societe AS id, raison_sociale AS nom FROM societes WHERE id_societe IN (33755)
Parameters: 
[]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\BuzzActualites No errors.
App\Entity\SocietesPrestataire No errors.
App\Entity\CoordonneesServicePrestataire No errors.
App\Entity\Societes No errors.
App\Entity\ServicesPrestataire No errors.
App\Entity\EquipesPrestataire No errors.
App\Entity\BuzzOperations No errors.
App\Entity\SecteursActivite No errors.
App\Entity\BuzzRoles No errors.
App\Entity\Translation No errors.