Symfony Profiler

SELECT
  DISTINCT s0_.nom_societe AS nom_societe_0,
  s0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1
FROM
  fusacq_dbo.societe_gestionnaire_fonds s0_
  INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (
    l1_.id_gestionnaire_fonds = s0_.id_gestionnaire_fonds
  )
  INNER JOIN fusacq_dbo.societes s2_ ON (
    s2_.id_participation = l1_.id_participation
  )
WHERE
  s2_.mode_participation = 'publique'
  AND l1_.mode = 'publique'
ORDER BY
  s0_.nom_societe ASC

SELECT DISTINCT s0_.nom_societe AS nom_societe_0, s0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1 FROM fusacq_dbo.societe_gestionnaire_fonds s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_gestionnaire_fonds = s0_.id_gestionnaire_fonds) INNER JOIN fusacq_dbo.societes s2_ ON (s2_.id_participation = l1_.id_participation) WHERE s2_.mode_participation = 'publique' AND l1_.mode = 'publique' ORDER BY s0_.nom_societe ASC;

SELECT
  s0_.id_pays AS id_pays_0,
  l1_.nom_localisation AS nom_localisation_1
FROM
  fusacq_dbo.societes s0_
  LEFT JOIN fusacq_dbo.lien_participations_fonds l2_ ON (
    l2_.id_participation = s0_.id_societe
  )
  LEFT JOIN fusacq_dbo.localisations l1_ ON (
    l1_.id_localisation = s0_.id_pays
  )
WHERE
  l2_.mode = 'publique'
  AND s0_.mode_participation = 'publique'
  AND s0_.mode_societe = 'publique'
  AND s0_.id_pays <> '00'
GROUP BY
  s0_.id_pays
ORDER BY
  l1_.nom_localisation ASC

SELECT s0_.id_pays AS id_pays_0, l1_.nom_localisation AS nom_localisation_1 FROM fusacq_dbo.societes s0_ LEFT JOIN fusacq_dbo.lien_participations_fonds l2_ ON (l2_.id_participation = s0_.id_societe) LEFT JOIN fusacq_dbo.localisations l1_ ON (l1_.id_localisation = s0_.id_pays) WHERE l2_.mode = 'publique' AND s0_.mode_participation = 'publique' AND s0_.mode_societe = 'publique' AND s0_.id_pays <> '00' GROUP BY s0_.id_pays ORDER BY l1_.nom_localisation ASC;

SELECT
  s0_.id_secteur_activite AS id_secteur_activite_0,
  s0_.nom_secteur_activite AS nom_secteur_activite_1
FROM
  fusacq_dbo.secteurs_activite s0_
WHERE
  s0_.id_secteur_activite_pere = 0
  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 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite_pere = 0 AND (s0_.obsolete <> 'oui' OR s0_.obsolete IS NULL) ORDER BY s0_.nom_secteur_activite ASC;

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';