Symfony Profiler

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_.demarche LIKE '%reprise_majoritaire%'
    OR a0_.demarche LIKE '%association_minoritaire%'
  )
  AND (
    a0_.investissement_possible = 'oui'
  )

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_.demarche LIKE '%reprise_majoritaire%' OR a0_.demarche LIKE '%association_minoritaire%') AND (a0_.investissement_possible = 'oui');

SELECT
  COUNT(DISTINCT a0_.id_repreneur) AS sclr_0
FROM
  fusacq_dbo.annuaire_repreneurs a0_
WHERE
  (a0_.mode_profil = 'publique')
  AND (
    a0_.demarche LIKE '%3%'
    OR a0_.demarche LIKE '%4%'
  )

SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE (a0_.mode_profil = 'publique') AND (a0_.demarche LIKE '%3%' OR a0_.demarche LIKE '%4%');

SELECT
  COUNT(
    DISTINCT s0_.id_gestionnaire_fonds
  ) AS sclr_0
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_societe = l1_.id_participation
  )
WHERE
  s2_.mode_participation = 'publique'
  AND l1_.mode = 'publique'
  AND s0_.mode = 'publique'
  AND s2_.mode_societe = 'publique'
  AND s0_.stade_investissement LIKE '%4%'
  AND (s0_.stade_investissement LIKE ?)

SELECT COUNT(DISTINCT s0_.id_gestionnaire_fonds) AS sclr_0 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_societe = l1_.id_participation) WHERE s2_.mode_participation = 'publique' AND l1_.mode = 'publique' AND s0_.mode = 'publique' AND s2_.mode_societe = 'publique' AND s0_.stade_investissement LIKE '%4%' AND (s0_.stade_investissement LIKE '%,4,%');

SELECT
  COUNT(DISTINCT i0_.id_investisseur) AS sclr_0
FROM
  fusacq_dbo.investisseurs_prives i0_
WHERE
  i0_.mode = 'publique'
  AND (i0_.stade_investissement LIKE ?)
ORDER BY
  i0_.id_investisseur DESC

SELECT COUNT(DISTINCT i0_.id_investisseur) AS sclr_0 FROM fusacq_dbo.investisseurs_prives i0_ WHERE i0_.mode = 'publique' AND (i0_.stade_investissement LIKE '%,4%') ORDER BY i0_.id_investisseur DESC;

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'

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

SELECT
  COUNT(
    DISTINCT s0_.id_gestionnaire_fonds
  ) AS sclr_0
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_societe = l1_.id_participation
  )
WHERE
  s2_.mode_participation = 'publique'
  AND l1_.mode = 'publique'
  AND s0_.mode = 'publique'
  AND s2_.mode_societe = 'publique'
  AND s0_.stade_investissement LIKE '%4%'
  AND (s0_.stade_investissement LIKE ?)
GROUP BY
  s0_.id_gestionnaire_fonds

SELECT COUNT(DISTINCT s0_.id_gestionnaire_fonds) AS sclr_0 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_societe = l1_.id_participation) WHERE s2_.mode_participation = 'publique' AND l1_.mode = 'publique' AND s0_.mode = 'publique' AND s2_.mode_societe = 'publique' AND s0_.stade_investissement LIKE '%4%' AND (s0_.stade_investissement LIKE '%,4,%') GROUP BY s0_.id_gestionnaire_fonds;

SELECT
  DISTINCT s0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_0,
  COUNT(s1_.id_societe) AS sclr_1,
  s0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_2
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%'
  AND (s0_.stade_investissement LIKE ?)
GROUP BY
  s0_.id_gestionnaire_fonds
ORDER BY
  sclr_1 DESC,
  s0_.id_gestionnaire_fonds DESC
LIMIT
  10 OFFSET 20

SELECT DISTINCT s0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_0, COUNT(s1_.id_societe) AS sclr_1, s0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_2 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%' AND (s0_.stade_investissement LIKE '%,4,%') GROUP BY s0_.id_gestionnaire_fonds ORDER BY sclr_1 DESC, s0_.id_gestionnaire_fonds DESC LIMIT 10 OFFSET 20;

SELECT
  s0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_0,
  s0_.nom_societe AS nom_societe_1,
  s0_.nom_contact AS nom_contact_2,
  s0_.id_pays AS id_pays_3,
  s0_.id_region AS id_region_4,
  s0_.adresse_societe AS adresse_societe_5,
  s0_.ville_societe AS ville_societe_6,
  s0_.code_postal_societe AS code_postal_societe_7,
  s0_.telephone AS telephone_8,
  s0_.indicatif AS indicatif_9,
  COUNT(s1_.id_societe) AS sclr_10,
  MAX(l2_.date_investissement) AS sclr_11,
  s0_.site_internet AS site_internet_12,
  s0_.mail_contact AS mail_contact_13
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%'
  AND (s0_.stade_investissement LIKE ?)
  AND s0_.id_gestionnaire_fonds IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  s0_.id_gestionnaire_fonds
ORDER BY
  sclr_10 DESC,
  s0_.id_gestionnaire_fonds DESC

SELECT s0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_0, s0_.nom_societe AS nom_societe_1, s0_.nom_contact AS nom_contact_2, s0_.id_pays AS id_pays_3, s0_.id_region AS id_region_4, s0_.adresse_societe AS adresse_societe_5, s0_.ville_societe AS ville_societe_6, s0_.code_postal_societe AS code_postal_societe_7, s0_.telephone AS telephone_8, s0_.indicatif AS indicatif_9, COUNT(s1_.id_societe) AS sclr_10, MAX(l2_.date_investissement) AS sclr_11, s0_.site_internet AS site_internet_12, s0_.mail_contact AS mail_contact_13 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%' AND (s0_.stade_investissement LIKE '%,4,%') AND s0_.id_gestionnaire_fonds IN (438, 430, 470, 94, 233, 444, 229, 499, 553, 111) GROUP BY s0_.id_gestionnaire_fonds ORDER BY sclr_10 DESC, s0_.id_gestionnaire_fonds DESC;