Symfony Profiler

SELECT
  s0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_0,
  s0_.nom_societe AS nom_societe_1,
  s0_.id_pays AS id_pays_2,
  s0_.id_region AS id_region_3,
  s0_.code_postal_societe AS code_postal_societe_4,
  COUNT(s1_.id_societe) AS sclr_5,
  MAX(l2_.date_investissement) AS sclr_6,
  s0_.pays_ciblees AS pays_ciblees_7,
  s0_.regions_ciblees AS regions_ciblees_8
FROM
  fusacq_dbo.societe_gestionnaire_fonds s0_
  INNER JOIN fusacq_dbo.lien_participations_fonds l2_ ON (
    l2_.id_gestionnaire_fonds = s0_.id_gestionnaire_fonds
  )
  INNER JOIN fusacq_dbo.societes s1_ ON (
    s1_.id_societe = l2_.id_participation
  )
WHERE
  s1_.mode_participation = 'publique'
  AND l2_.mode = 'publique'
  AND s0_.mode = 'publique'
  AND s1_.mode_societe = 'publique'
  AND s0_.stade_investissement LIKE '%4%'
GROUP BY
  s0_.id_gestionnaire_fonds
ORDER BY
  sclr_6 DESC,
  s0_.id_gestionnaire_fonds DESC
LIMIT
  5

SELECT s0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_0, s0_.nom_societe AS nom_societe_1, s0_.id_pays AS id_pays_2, s0_.id_region AS id_region_3, s0_.code_postal_societe AS code_postal_societe_4, COUNT(s1_.id_societe) AS sclr_5, MAX(l2_.date_investissement) AS sclr_6, s0_.pays_ciblees AS pays_ciblees_7, s0_.regions_ciblees AS regions_ciblees_8 FROM fusacq_dbo.societe_gestionnaire_fonds s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l2_ ON (l2_.id_gestionnaire_fonds = s0_.id_gestionnaire_fonds) INNER JOIN fusacq_dbo.societes s1_ ON (s1_.id_societe = l2_.id_participation) WHERE s1_.mode_participation = 'publique' AND l2_.mode = 'publique' AND s0_.mode = 'publique' AND s1_.mode_societe = 'publique' AND s0_.stade_investissement LIKE '%4%' GROUP BY s0_.id_gestionnaire_fonds ORDER BY sclr_6 DESC, s0_.id_gestionnaire_fonds DESC LIMIT 5;