Symfony Profiler

SELECT
  v0_.nom_ville AS nom_ville_0
FROM
  fusacq_dbo.villes v0_
WHERE
  v0_.code_departement LIKE ?
ORDER BY
  v0_.population DESC
LIMIT
  3

SELECT v0_.nom_ville AS nom_ville_0 FROM fusacq_dbo.villes v0_ WHERE v0_.code_departement LIKE '33_16_99%' ORDER BY v0_.population DESC LIMIT 3;

SELECT
  t0.id_secteur_activite AS id_secteur_activite_1,
  t0.nom_secteur_activite AS nom_secteur_activite_2,
  t0.obsolete AS obsolete_3,
  t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4,
  t0.site_partenaire AS site_partenaire_5,
  t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6,
  t0.id_secteur_activite_pere AS id_secteur_activite_pere_7,
  t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8,
  t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9,
  t0.nom_pour_TITLE AS nom_pour_TITLE_10,
  t0.rare AS rare_11,
  t0.recherche AS recherche_12
FROM
  fusacq_dbo.secteurs_activite t0
WHERE
  t0.id_secteur_activite = ?
LIMIT
  1

SELECT t0.id_secteur_activite AS id_secteur_activite_1, t0.nom_secteur_activite AS nom_secteur_activite_2, t0.obsolete AS obsolete_3, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4, t0.site_partenaire AS site_partenaire_5, t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6, t0.id_secteur_activite_pere AS id_secteur_activite_pere_7, t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8, t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9, t0.nom_pour_TITLE AS nom_pour_TITLE_10, t0.rare AS rare_11, t0.recherche AS recherche_12 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = '6' LIMIT 1;

SELECT
  t0.id_secteur_activite AS id_secteur_activite_1,
  t0.nom_secteur_activite AS nom_secteur_activite_2,
  t0.obsolete AS obsolete_3,
  t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4,
  t0.site_partenaire AS site_partenaire_5,
  t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6,
  t0.id_secteur_activite_pere AS id_secteur_activite_pere_7,
  t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8,
  t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9,
  t0.nom_pour_TITLE AS nom_pour_TITLE_10,
  t0.rare AS rare_11,
  t0.recherche AS recherche_12
FROM
  fusacq_dbo.secteurs_activite t0
WHERE
  t0.id_secteur_activite = ?
LIMIT
  1

SELECT t0.id_secteur_activite AS id_secteur_activite_1, t0.nom_secteur_activite AS nom_secteur_activite_2, t0.obsolete AS obsolete_3, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4, t0.site_partenaire AS site_partenaire_5, t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6, t0.id_secteur_activite_pere AS id_secteur_activite_pere_7, t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8, t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9, t0.nom_pour_TITLE AS nom_pour_TITLE_10, t0.rare AS rare_11, t0.recherche AS recherche_12 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = '614' LIMIT 1;

SELECT
  t0.id_secteur_activite AS id_secteur_activite_1,
  t0.nom_secteur_activite AS nom_secteur_activite_2,
  t0.obsolete AS obsolete_3,
  t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4,
  t0.site_partenaire AS site_partenaire_5,
  t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6,
  t0.id_secteur_activite_pere AS id_secteur_activite_pere_7,
  t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8,
  t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9,
  t0.nom_pour_TITLE AS nom_pour_TITLE_10,
  t0.rare AS rare_11,
  t0.recherche AS recherche_12
FROM
  fusacq_dbo.secteurs_activite t0
WHERE
  t0.id_secteur_activite = ?
LIMIT
  1

SELECT t0.id_secteur_activite AS id_secteur_activite_1, t0.nom_secteur_activite AS nom_secteur_activite_2, t0.obsolete AS obsolete_3, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4, t0.site_partenaire AS site_partenaire_5, t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6, t0.id_secteur_activite_pere AS id_secteur_activite_pere_7, t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8, t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9, t0.nom_pour_TITLE AS nom_pour_TITLE_10, t0.rare AS rare_11, t0.recherche AS recherche_12 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = '61499' LIMIT 1;

SELECT
  s0_.id_secteur_activite AS id_secteur_activite_0,
  s0_.nom_secteur_activite AS nom_secteur_activite_1,
  s0_.nom_pour_TITLE AS nom_pour_TITLE_2
FROM
  fusacq_dbo.secteurs_activite s0_
WHERE
  s0_.id_secteur_activite_pere = ?
  AND (
    s0_.obsolete <> ?
    OR s0_.obsolete IS NULL
  )
ORDER BY
  s0_.nom_secteur_activite ASC

SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.nom_secteur_activite AS nom_secteur_activite_1, s0_.nom_pour_TITLE AS nom_pour_TITLE_2 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite_pere = '61499' AND (s0_.obsolete <> 'oui' OR s0_.obsolete IS NULL) ORDER BY s0_.nom_secteur_activite ASC;

SELECT
  COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.date_parution_initiale IS NOT NULL
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND a0_.id_secteur_activite = ?
  AND (a0_.id_departement = ?)

SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite = '61499' AND (a0_.id_departement = '33_16_99');

SELECT
  COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  (
    a0_.date_parution_initiale IS NOT NULL
    OR a0_.date_parution_initiale_elite IS NOT NULL
  )
  AND (
    a0_.mode_annonce = 'publique'
    OR a0_.mode_annonce = 'publique_elite'
  )
  AND a0_.tpe_pme = 'oui'
  AND a0_.statuts LIKE '99%'
  AND a0_.id_secteur_activite = ?
  AND (a0_.id_departement = ?)

SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND a0_.id_secteur_activite = '61499' AND (a0_.id_departement = '33_16_99');

SELECT
  d0_.value AS value_0
FROM
  partage_dbo.data_parametre_site d0_
  LEFT JOIN partage_dbo.parametre_site p1_ ON (
    p1_.id_parametre_site = d0_.id_parametre_site
  )
WHERE
  p1_.nom = ?
  AND p1_.valide = ?
  AND d0_.code_pays = ?
  AND d0_.plateforme = ?

SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

SELECT
  d0_.value AS value_0
FROM
  partage_dbo.data_parametre_site d0_
  LEFT JOIN partage_dbo.parametre_site p1_ ON (
    p1_.id_parametre_site = d0_.id_parametre_site
  )
WHERE
  p1_.nom = ?
  AND p1_.valide = ?
  AND d0_.code_pays = ?
  AND d0_.plateforme = ?

SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

SELECT
  d0_.value AS value_0
FROM
  partage_dbo.data_parametre_site d0_
  LEFT JOIN partage_dbo.parametre_site p1_ ON (
    p1_.id_parametre_site = d0_.id_parametre_site
  )
WHERE
  p1_.nom = ?
  AND p1_.valide = ?
  AND d0_.code_pays = ?
  AND d0_.plateforme = ?

SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

SELECT
  d0_.value AS value_0
FROM
  partage_dbo.data_parametre_site d0_
  LEFT JOIN partage_dbo.parametre_site p1_ ON (
    p1_.id_parametre_site = d0_.id_parametre_site
  )
WHERE
  p1_.nom = ?
  AND p1_.valide = ?
  AND d0_.code_pays = ?
  AND d0_.plateforme = ?

SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

SELECT
  COUNT(DISTINCT s0_.id_societe) AS sclr_0
FROM
  fusacq_dbo.societes s0_
  INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (
    l1_.id_participation = s0_.id_societe
  )
WHERE
  (l1_.mode = 'publique')
  AND (
    s0_.mode_participation = 'publique'
  )
  AND (s0_.mode_societe = 'publique')
  AND (s0_.id_pays <> '00')
  AND s0_.ca_n < 300000
  AND l1_.date_investissement >= 201104
  AND l1_.date_investissement <= 202104
  AND (s0_.code_postal LIKE ?)
  AND s0_.afficher_vendeur = 1

SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE '99%') AND s0_.afficher_vendeur = 1;

SELECT
  COUNT(
    DISTINCT a0_.id_annonce_acheteur
  ) AS sclr_0
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.date_parution_initiale IS NOT NULL
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND a0_.type_raprochement = 'partenaire'
  AND a0_.id_secteur_activite = ?
  AND (
    (
      a0_.id_departement = ?
      OR a0_.autres_localisations LIKE ?
      OR a0_.autres_localisations LIKE ?
    )
  )

SELECT COUNT(DISTINCT a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND a0_.id_secteur_activite = '61499' AND ((a0_.id_departement = '33_16_99' OR a0_.autres_localisations LIKE '33_16_99%' OR a0_.autres_localisations LIKE '%,33_16_99%'));

SELECT
  d0_.value AS value_0
FROM
  partage_dbo.data_parametre_site d0_
  LEFT JOIN partage_dbo.parametre_site p1_ ON (
    p1_.id_parametre_site = d0_.id_parametre_site
  )
WHERE
  p1_.nom = ?
  AND p1_.valide = ?
  AND d0_.code_pays = ?
  AND d0_.plateforme = ?

SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

SELECT
  d0_.value AS value_0
FROM
  partage_dbo.data_parametre_site d0_
  LEFT JOIN partage_dbo.parametre_site p1_ ON (
    p1_.id_parametre_site = d0_.id_parametre_site
  )
WHERE
  p1_.nom = ?
  AND p1_.valide = ?
  AND d0_.code_pays = ?
  AND d0_.plateforme = ?

SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

SELECT
  d0_.value AS value_0
FROM
  partage_dbo.data_parametre_site d0_
  LEFT JOIN partage_dbo.parametre_site p1_ ON (
    p1_.id_parametre_site = d0_.id_parametre_site
  )
WHERE
  p1_.nom = ?
  AND p1_.valide = ?
  AND d0_.code_pays = ?
  AND d0_.plateforme = ?

SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

SELECT
  d0_.value AS value_0
FROM
  partage_dbo.data_parametre_site d0_
  LEFT JOIN partage_dbo.parametre_site p1_ ON (
    p1_.id_parametre_site = d0_.id_parametre_site
  )
WHERE
  p1_.nom = ?
  AND p1_.valide = ?
  AND d0_.code_pays = ?
  AND d0_.plateforme = ?

SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

SELECT
  COUNT(DISTINCT s0_.id_societe) AS sclr_0
FROM
  fusacq_dbo.societes s0_
  INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (
    l1_.id_participation = s0_.id_societe
  )
WHERE
  (l1_.mode = 'publique')
  AND (
    s0_.mode_participation = 'publique'
  )
  AND (s0_.mode_societe = 'publique')
  AND (s0_.id_pays <> '00')
  AND s0_.ca_n < 300000
  AND l1_.date_investissement >= 201104
  AND l1_.date_investissement <= 202104
  AND (s0_.code_postal LIKE ?)
  AND s0_.afficher_vendeur = 1
GROUP BY
  s0_.id_societe

SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE '99%') AND s0_.afficher_vendeur = 1 GROUP BY s0_.id_societe;

SELECT
  DISTINCT s0_.id_societe AS id_societe_0,
  s0_.ca_n AS ca_n_1,
  s0_.date_dernier_investissement AS date_dernier_investissement_2,
  s0_.id_societe AS id_societe_3
FROM
  fusacq_dbo.societes s0_
  INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (
    l1_.id_participation = s0_.id_societe
  )
WHERE
  (l1_.mode = 'publique')
  AND (
    s0_.mode_participation = 'publique'
  )
  AND (s0_.mode_societe = 'publique')
  AND (s0_.id_pays <> '00')
  AND s0_.ca_n < 300000
  AND l1_.date_investissement >= 201104
  AND l1_.date_investissement <= 202104
  AND (s0_.code_postal LIKE ?)
  AND s0_.afficher_vendeur = 1
GROUP BY
  s0_.id_societe
ORDER BY
  s0_.ca_n DESC,
  s0_.date_dernier_investissement ASC,
  s0_.id_societe DESC
LIMIT
  10

SELECT DISTINCT s0_.id_societe AS id_societe_0, s0_.ca_n AS ca_n_1, s0_.date_dernier_investissement AS date_dernier_investissement_2, s0_.id_societe AS id_societe_3 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE '99%') AND s0_.afficher_vendeur = 1 GROUP BY s0_.id_societe ORDER BY s0_.ca_n DESC, s0_.date_dernier_investissement ASC, s0_.id_societe DESC LIMIT 10;

SELECT
  d0_.value AS value_0
FROM
  partage_dbo.data_parametre_site d0_
  LEFT JOIN partage_dbo.parametre_site p1_ ON (
    p1_.id_parametre_site = d0_.id_parametre_site
  )
WHERE
  p1_.nom = ?
  AND p1_.valide = ?
  AND d0_.code_pays = ?
  AND d0_.plateforme = ?

SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'id_participation_exemple' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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 = ?
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.id_societe = '41562' LIMIT 1;

SELECT
  s0_.raison_sociale AS raison_sociale_0,
  s0_.id_societe AS id_societe_1,
  l1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_2
FROM
  fusacq_dbo.societes s0_
  LEFT JOIN fusacq_dbo.lien_participations_fonds l1_ ON (
    s0_.id_societe = l1_.id_participation
  )
WHERE
  s0_.id_societe = ?
  AND l1_.id_gestionnaire_fonds <> ?
LIMIT
  10000

SELECT s0_.raison_sociale AS raison_sociale_0, s0_.id_societe AS id_societe_1, l1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_2 FROM fusacq_dbo.societes s0_ LEFT JOIN fusacq_dbo.lien_participations_fonds l1_ ON (s0_.id_societe = l1_.id_participation) WHERE s0_.id_societe = '41562' AND l1_.id_gestionnaire_fonds <> 'null' LIMIT 10000;