Symfony Profiler

SELECT
  *
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?
  AND mode_actualite != ?
LIMIT
  1

SELECT * FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 256604 AND mode_actualite != 'supprime' LIMIT 1;

SELECT
  t0.id_actualite AS id_actualite_1,
  t0.date_creation AS date_creation_2,
  t0.date_reception AS date_reception_3,
  t0.date_mise_en_ligne AS date_mise_en_ligne_4,
  t0.date_evenement AS date_evenement_5,
  t0.titre_actualite AS titre_actualite_6,
  t0.sous_titre AS sous_titre_7,
  t0.description_actualite AS description_actualite_8,
  t0.provenance_flux_actualite AS provenance_flux_actualite_9,
  t0.type_actualite AS type_actualite_10,
  t0.nom_fichier_xml AS nom_fichier_xml_11,
  t0.id_message_blog AS id_message_blog_12,
  t0.id_societe_prestataire AS id_societe_prestataire_13,
  t0.id_service_principal AS id_service_principal_14,
  t0.id_operation AS id_operation_15,
  t0.mode_actualite AS mode_actualite_16,
  t0.modifie_par_utilisateur AS modifie_par_utilisateur_17,
  t0.deja_publique AS deja_publique_18,
  t0.id_actualite_redirection AS id_actualite_redirection_19,
  t0.site_internet AS site_internet_20,
  t0.pour_en_savoir_plus AS pour_en_savoir_plus_21,
  t0.societe_source AS societe_source_22,
  t0.mots_cles AS mots_cles_23,
  t0.a_la_une AS a_la_une_24,
  t0.parution_franchises AS parution_franchises_25,
  t0.a_la_une_du_jour AS a_la_une_du_jour_26,
  t0.selection_we AS selection_we_27,
  t0.a_la_une_accueil AS a_la_une_accueil_28,
  t0.a_la_une_news_actu AS a_la_une_news_actu_29,
  t0.utiliser_artviper AS utiliser_artviper_30,
  t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_31,
  t0.visibilite_flux AS visibilite_flux_32,
  t0.personne_physique_impliquee AS personne_physique_impliquee_33,
  t0.societe_impliquee AS societe_impliquee_34,
  t0.fonds_implique AS fonds_implique_35,
  t0.id_localisation AS id_localisation_36,
  t0.id_secteur_activite AS id_secteur_activite_37,
  t0.vignette AS vignette_38,
  t0.vignette_small AS vignette_small_39,
  t0.alerte_envoyee AS alerte_envoyee_40,
  t0.id_participation AS id_participation_41,
  t0.id_participation_temporaire AS id_participation_temporaire_42,
  t0.id_operation_temporaire AS id_operation_temporaire_43,
  t0.id_fonds_bot AS id_fonds_bot_44,
  t0.souhaite_classement AS souhaite_classement_45,
  t0.souhaite_reseau AS souhaite_reseau_46,
  t0.souhaite_prestation AS souhaite_prestation_47,
  t0.souhaite_nom_reseau AS souhaite_nom_reseau_48,
  t0.autorisation_blog AS autorisation_blog_49,
  t0.contact_validation AS contact_validation_50,
  t0.commentaires_blog AS commentaires_blog_51,
  t0.apparition_classement AS apparition_classement_52,
  t0.classement_reseau AS classement_reseau_53,
  t0.classement_prestation AS classement_prestation_54,
  t0.id_reseau AS id_reseau_55,
  t0.suivi_classement AS suivi_classement_56,
  t0.is_description_html AS is_description_html_57,
  t0.is_forum_active AS is_forum_active_58,
  t0.actu_ess AS actu_ess_59,
  t0.suivi_actualite AS suivi_actualite_60,
  t0.date_validation AS date_validation_61,
  t0.indexe_google AS indexe_google_62
FROM
  fusacq_dbo.buzz_actualites t0
WHERE
  t0.id_actualite = ?

SELECT t0.id_actualite AS id_actualite_1, t0.date_creation AS date_creation_2, t0.date_reception AS date_reception_3, t0.date_mise_en_ligne AS date_mise_en_ligne_4, t0.date_evenement AS date_evenement_5, t0.titre_actualite AS titre_actualite_6, t0.sous_titre AS sous_titre_7, t0.description_actualite AS description_actualite_8, t0.provenance_flux_actualite AS provenance_flux_actualite_9, t0.type_actualite AS type_actualite_10, t0.nom_fichier_xml AS nom_fichier_xml_11, t0.id_message_blog AS id_message_blog_12, t0.id_societe_prestataire AS id_societe_prestataire_13, t0.id_service_principal AS id_service_principal_14, t0.id_operation AS id_operation_15, t0.mode_actualite AS mode_actualite_16, t0.modifie_par_utilisateur AS modifie_par_utilisateur_17, t0.deja_publique AS deja_publique_18, t0.id_actualite_redirection AS id_actualite_redirection_19, t0.site_internet AS site_internet_20, t0.pour_en_savoir_plus AS pour_en_savoir_plus_21, t0.societe_source AS societe_source_22, t0.mots_cles AS mots_cles_23, t0.a_la_une AS a_la_une_24, t0.parution_franchises AS parution_franchises_25, t0.a_la_une_du_jour AS a_la_une_du_jour_26, t0.selection_we AS selection_we_27, t0.a_la_une_accueil AS a_la_une_accueil_28, t0.a_la_une_news_actu AS a_la_une_news_actu_29, t0.utiliser_artviper AS utiliser_artviper_30, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_31, t0.visibilite_flux AS visibilite_flux_32, t0.personne_physique_impliquee AS personne_physique_impliquee_33, t0.societe_impliquee AS societe_impliquee_34, t0.fonds_implique AS fonds_implique_35, t0.id_localisation AS id_localisation_36, t0.id_secteur_activite AS id_secteur_activite_37, t0.vignette AS vignette_38, t0.vignette_small AS vignette_small_39, t0.alerte_envoyee AS alerte_envoyee_40, t0.id_participation AS id_participation_41, t0.id_participation_temporaire AS id_participation_temporaire_42, t0.id_operation_temporaire AS id_operation_temporaire_43, t0.id_fonds_bot AS id_fonds_bot_44, t0.souhaite_classement AS souhaite_classement_45, t0.souhaite_reseau AS souhaite_reseau_46, t0.souhaite_prestation AS souhaite_prestation_47, t0.souhaite_nom_reseau AS souhaite_nom_reseau_48, t0.autorisation_blog AS autorisation_blog_49, t0.contact_validation AS contact_validation_50, t0.commentaires_blog AS commentaires_blog_51, t0.apparition_classement AS apparition_classement_52, t0.classement_reseau AS classement_reseau_53, t0.classement_prestation AS classement_prestation_54, t0.id_reseau AS id_reseau_55, t0.suivi_classement AS suivi_classement_56, t0.is_description_html AS is_description_html_57, t0.is_forum_active AS is_forum_active_58, t0.actu_ess AS actu_ess_59, t0.suivi_actualite AS suivi_actualite_60, t0.date_validation AS date_validation_61, t0.indexe_google AS indexe_google_62 FROM fusacq_dbo.buzz_actualites t0 WHERE t0.id_actualite = 256604;

SELECT
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?

SELECT photo_actualite FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 256604;

SELECT
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?

SELECT photo_actualite FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 256604;

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

SELECT
  t0.id_operation AS id_operation_1,
  t0.titre_operation AS titre_operation_2,
  t0.type_operation AS type_operation_3,
  t0.mots_cles AS mots_cles_4,
  t0.personne_physique_impliquee AS personne_physique_impliquee_5,
  t0.societe_impliquee AS societe_impliquee_6,
  t0.fonds_implique AS fonds_implique_7,
  t0.suivi_operation AS suivi_operation_8,
  t0.date_operation AS date_operation_9,
  t0.id_secteur_activite AS id_secteur_activite_10,
  t0.id_localisation AS id_localisation_11,
  t0.id_localisation_2 AS id_localisation_2_12,
  t0.id_actualite_principale AS id_actualite_principale_13,
  t0.visibilite_sur_annonces_fusacq AS visibilite_sur_annonces_fusacq_14,
  t0.code_naf AS code_naf_15,
  t0.montant_operation AS montant_operation_16,
  t0.ca_societe_achetee AS ca_societe_achetee_17,
  t0.mode_operation AS mode_operation_18,
  t0.mots_cles_valides AS mots_cles_valides_19,
  t0.check_rattrapage AS check_rattrapage_20,
  t0.pct_capital_achete AS pct_capital_achete_21,
  t0.maj_min_capital AS maj_min_capital_22,
  t0.fourchette_ca AS fourchette_ca_23,
  t0.nb_compte_classement AS nb_compte_classement_24,
  t0.montant_compte_classement AS montant_compte_classement_25
FROM
  fusacq_dbo.buzz_operations t0
WHERE
  t0.id_operation = ?

SELECT t0.id_operation AS id_operation_1, t0.titre_operation AS titre_operation_2, t0.type_operation AS type_operation_3, t0.mots_cles AS mots_cles_4, t0.personne_physique_impliquee AS personne_physique_impliquee_5, t0.societe_impliquee AS societe_impliquee_6, t0.fonds_implique AS fonds_implique_7, t0.suivi_operation AS suivi_operation_8, t0.date_operation AS date_operation_9, t0.id_secteur_activite AS id_secteur_activite_10, t0.id_localisation AS id_localisation_11, t0.id_localisation_2 AS id_localisation_2_12, t0.id_actualite_principale AS id_actualite_principale_13, t0.visibilite_sur_annonces_fusacq AS visibilite_sur_annonces_fusacq_14, t0.code_naf AS code_naf_15, t0.montant_operation AS montant_operation_16, t0.ca_societe_achetee AS ca_societe_achetee_17, t0.mode_operation AS mode_operation_18, t0.mots_cles_valides AS mots_cles_valides_19, t0.check_rattrapage AS check_rattrapage_20, t0.pct_capital_achete AS pct_capital_achete_21, t0.maj_min_capital AS maj_min_capital_22, t0.fourchette_ca AS fourchette_ca_23, t0.nb_compte_classement AS nb_compte_classement_24, t0.montant_compte_classement AS montant_compte_classement_25 FROM fusacq_dbo.buzz_operations t0 WHERE t0.id_operation = 42333;

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

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

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

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 = 42333 ORDER BY a0_.ca_n 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 = 42333 LIMIT 1;

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 = 30106 AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' ORDER BY a0_.date_parution_initiale DESC LIMIT 5;

SELECT
  s0_.id_secteur_activite AS id_secteur_activite_0,
  s0_.nom_secteur_activite AS nom_secteur_activite_1,
  s0_.nom_secteur_activite AS nom_secteur_activite_2
FROM
  fusacq_dbo.secteurs_activite s0_
WHERE
  s0_.id_secteur_activite = ?

SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.nom_secteur_activite AS nom_secteur_activite_1, s0_.nom_secteur_activite AS nom_secteur_activite_2 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite = 30106;