Symfony Profiler

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

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 = 257968 AND b0_.mode_actualite <> 'supprime' LIMIT 1;

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

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 = 257968 LIMIT 1;

SELECT
  b0_.id_operation AS id_operation_0,
  b0_.id_secteur_activite AS id_secteur_activite_1,
  b0_.id_localisation AS id_localisation_2
FROM
  fusacq_dbo.buzz_operations b0_
WHERE
  b0_.id_operation = ?
LIMIT
  1

SELECT b0_.id_operation AS id_operation_0, b0_.id_secteur_activite AS id_secteur_activite_1, b0_.id_localisation AS id_localisation_2 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_operation = 43058 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,
  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)

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 = 43058
            AND br.table_sql_acteur <> 'societes_news'
            ORDER BY br.id_type_role, COALESCE(ep.nom, ep_passif.nom)
        ;

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

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 = 43058
                AND LOWER(btr.nom_role) NOT LIKE '%conseil%'
                AND (
                    btr.nom_role LIKE '%quéreur%'
                    OR btr.nom_role LIKE '%quereur%'
                )
                LIMIT 1
            ;

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

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

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

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

SELECT
  id_societe AS id,
  raison_sociale AS nom
FROM
  societes
WHERE
  id_societe IN (50288)

SELECT id_societe AS id, raison_sociale AS nom FROM societes WHERE id_societe IN (50288);