Symfony Profiler

SELECT
  COUNT(DISTINCT a0_.id_repreneur) AS sclr_0
FROM
  fusacq_dbo.annuaire_repreneurs a0_
WHERE
  (a0_.mode_profil = 'publique')
  AND (
    a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
  )

SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE (a0_.mode_profil = 'publique') AND (a0_.id_localisations_recherchees LIKE '46,%' OR a0_.id_localisations_recherchees LIKE '46' OR a0_.id_localisations_recherchees LIKE '%,46,%' OR a0_.id_localisations_recherchees LIKE '%,46' OR a0_.id_localisations_recherchees LIKE '%,46_01%' OR a0_.id_localisations_recherchees LIKE '46_01%');

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_region = ?
      OR a0_.id_region = ?
      OR a0_.autres_localisations LIKE ?
      OR a0_.autres_localisations LIKE ?
    )
    OR (
      (
        a0_.id_region LIKE ''
        OR a0_.id_region IS NULL
      )
      AND (
        a0_.id_pays = ?
        OR a0_.autres_localisations LIKE ?
        OR a0_.autres_localisations LIKE ?
        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_region = '46_01' OR a0_.id_region = '46_99' OR a0_.autres_localisations LIKE '46_01%' OR a0_.autres_localisations LIKE '%,46_01%') OR ((a0_.id_region LIKE '' OR a0_.id_region IS NULL) AND (a0_.id_pays = '46' OR a0_.autres_localisations LIKE '46' OR a0_.autres_localisations LIKE '46%' OR a0_.autres_localisations LIKE '%,46%' OR a0_.autres_localisations LIKE '%,46')));

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_.id_region = ?)

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_.id_region = '46_01');

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_.id_region = ?
      OR a0_.id_region = ?
      OR a0_.autres_localisations LIKE ?
      OR a0_.autres_localisations LIKE ?
    )
    OR (
      (
        a0_.id_region LIKE ''
        OR a0_.id_region IS NULL
      )
      AND (
        a0_.id_pays = ?
        OR a0_.autres_localisations LIKE ?
        OR a0_.autres_localisations LIKE ?
        OR a0_.autres_localisations LIKE ?
        OR a0_.autres_localisations LIKE ?
      )
    )
  )
  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_.id_region = '46_01' OR a0_.id_region = '46_99' OR a0_.autres_localisations LIKE '46_01%' OR a0_.autres_localisations LIKE '%,46_01%') OR ((a0_.id_region LIKE '' OR a0_.id_region IS NULL) AND (a0_.id_pays = '46' OR a0_.autres_localisations LIKE '46' OR a0_.autres_localisations LIKE '46%' OR a0_.autres_localisations LIKE '%,46%' OR a0_.autres_localisations LIKE '%,46'))) AND (a0_.demarche LIKE '%reprise_majoritaire%' OR a0_.demarche LIKE '%association_minoritaire%') AND (a0_.investissement_possible = 'oui');

SELECT
  COUNT(DISTINCT i0_.id_investisseur) AS sclr_0
FROM
  fusacq_dbo.investisseurs_prives i0_
WHERE
  i0_.mode = 'publique'
  AND (
    i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees IS NULL
  )
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_.id_localisations_recherchees LIKE '%,46_01%' OR i0_.id_localisations_recherchees LIKE '%,46,%' OR i0_.id_localisations_recherchees LIKE '%,46' OR i0_.id_localisations_recherchees IS NULL) ORDER BY i0_.id_investisseur DESC;

SELECT
  COUNT(l0_.id_localisation) AS sclr_0
FROM
  fusacq_dbo.localisations l0_
WHERE
  l0_.id_localisation_pere = ?
  AND l0_.id_localisation NOT LIKE ?

SELECT COUNT(l0_.id_localisation) AS sclr_0 FROM fusacq_dbo.localisations l0_ WHERE l0_.id_localisation_pere = '590' AND l0_.id_localisation NOT LIKE '%_99';

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%'
  )
  AND (
    a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
  )

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%') AND (a0_.id_localisations_recherchees LIKE '%,46%' OR a0_.id_localisations_recherchees LIKE '46%');

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

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_.id_pays = ?)

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_.id_pays = 46);

SELECT
  DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0,
  CASE WHEN (
    a0_.id_pays = ?
    AND (
      a0_.id_region = ''
      OR a0_.id_region IS NULL
      OR a0_.id_region = ?
    )
    AND (
      a0_.id_departement = ''
      OR a0_.id_departement IS NULL
    )
  )
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ? THEN 4 WHEN (
    a0_.id_pays = ?
    AND (
      a0_.id_departement = ''
      OR a0_.id_departement IS NULL
    )
  )
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ? THEN 3 WHEN a0_.id_pays = ?
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ? THEN 2 ELSE 1 END AS sclr_1,
  a0_.ca_max AS ca_max_2,
  a0_.id_annonce_acheteur AS id_annonce_acheteur_3
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_pays = ?
    OR a0_.autres_localisations LIKE ?
    OR a0_.autres_localisations LIKE ?
  )
ORDER BY
  sclr_1 DESC,
  a0_.ca_max DESC,
  a0_.id_annonce_acheteur DESC
LIMIT
  10

SELECT DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, CASE WHEN (a0_.id_pays = 46 AND (a0_.id_region = '' OR a0_.id_region IS NULL OR a0_.id_region = '46_99') AND (a0_.id_departement = '' OR a0_.id_departement IS NULL)) OR a0_.autres_localisations LIKE 46 OR a0_.autres_localisations LIKE '46,%' OR a0_.autres_localisations LIKE '%,46,%' OR a0_.autres_localisations LIKE '%,46' THEN 4 WHEN (a0_.id_pays = 46 AND (a0_.id_departement = '' OR a0_.id_departement IS NULL)) OR a0_.autres_localisations LIKE '46%' OR a0_.autres_localisations LIKE '%,46%' THEN 3 WHEN a0_.id_pays = 46 OR a0_.autres_localisations LIKE '46%' OR a0_.autres_localisations LIKE '%,46%' THEN 2 ELSE 1 END AS sclr_1, a0_.ca_max AS ca_max_2, a0_.id_annonce_acheteur AS id_annonce_acheteur_3 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_pays = 46 OR a0_.autres_localisations LIKE '46%' OR a0_.autres_localisations LIKE '%,46%') ORDER BY sclr_1 DESC, a0_.ca_max DESC, a0_.id_annonce_acheteur DESC LIMIT 10;

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_pays = ?
    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_pays = 46 OR a0_.autres_localisations LIKE '46%' OR a0_.autres_localisations LIKE '%,46%');

SELECT
  DISTINCT 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_pays = ?
    OR a0_.autres_localisations LIKE ?
    OR a0_.autres_localisations LIKE ?
  )

SELECT DISTINCT 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_pays = 46 OR a0_.autres_localisations LIKE '46%' OR a0_.autres_localisations LIKE '%,46%');

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 '46%' ORDER BY v0_.population DESC LIMIT 3;

SELECT
  COUNT(DISTINCT i0_.id_investisseur) AS sclr_0
FROM
  fusacq_dbo.investisseurs_prives i0_
WHERE
  i0_.mode = 'publique'
  AND (
    i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees IS NULL
  )
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_.id_localisations_recherchees LIKE '%,46%' OR i0_.id_localisations_recherchees IS NULL) ORDER BY i0_.id_investisseur DESC;

SELECT
  DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0,
  a0_.titre_annonce AS titre_annonce_1,
  a0_.date_parution_initiale AS date_parution_initiale_2,
  a0_.date_parution AS date_parution_3,
  a0_.ca_max AS ca_max_4,
  a0_.apport_perso_repreneur AS apport_perso_repreneur_5,
  a0_.id_pays AS id_pays_6,
  a0_.id_region AS id_region_7,
  a0_.id_departement AS id_departement_8,
  a0_.autres_localisations AS autres_localisations_9,
  a0_.type_acquereur AS type_acquereur_10,
  a0_.id_langue AS id_langue_11,
  CASE WHEN (
    a0_.id_pays = ?
    AND (
      a0_.id_region = ''
      OR a0_.id_region IS NULL
      OR a0_.id_region = ?
    )
    AND (
      a0_.id_departement = ''
      OR a0_.id_departement IS NULL
    )
  )
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ? THEN 4 WHEN (
    a0_.id_pays = ?
    AND (
      a0_.id_departement = ''
      OR a0_.id_departement IS NULL
    )
  )
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ? THEN 3 WHEN a0_.id_pays = ?
  OR a0_.autres_localisations LIKE ?
  OR a0_.autres_localisations LIKE ? THEN 2 ELSE 1 END AS sclr_12
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_pays = ?
    OR a0_.autres_localisations LIKE ?
    OR a0_.autres_localisations LIKE ?
  )
  AND a0_.id_annonce_acheteur IN (?)
ORDER BY
  sclr_12 DESC,
  a0_.ca_max DESC,
  a0_.id_annonce_acheteur DESC

SELECT DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.date_parution_initiale AS date_parution_initiale_2, a0_.date_parution AS date_parution_3, a0_.ca_max AS ca_max_4, a0_.apport_perso_repreneur AS apport_perso_repreneur_5, a0_.id_pays AS id_pays_6, a0_.id_region AS id_region_7, a0_.id_departement AS id_departement_8, a0_.autres_localisations AS autres_localisations_9, a0_.type_acquereur AS type_acquereur_10, a0_.id_langue AS id_langue_11, CASE WHEN (a0_.id_pays = 46 AND (a0_.id_region = '' OR a0_.id_region IS NULL OR a0_.id_region = '46_99') AND (a0_.id_departement = '' OR a0_.id_departement IS NULL)) OR a0_.autres_localisations LIKE 46 OR a0_.autres_localisations LIKE '46,%' OR a0_.autres_localisations LIKE '%,46,%' OR a0_.autres_localisations LIKE '%,46' THEN 4 WHEN (a0_.id_pays = 46 AND (a0_.id_departement = '' OR a0_.id_departement IS NULL)) OR a0_.autres_localisations LIKE '46%' OR a0_.autres_localisations LIKE '%,46%' THEN 3 WHEN a0_.id_pays = 46 OR a0_.autres_localisations LIKE '46%' OR a0_.autres_localisations LIKE '%,46%' THEN 2 ELSE 1 END AS sclr_12 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_pays = 46 OR a0_.autres_localisations LIKE '46%' OR a0_.autres_localisations LIKE '%,46%') AND a0_.id_annonce_acheteur IN (16959) ORDER BY sclr_12 DESC, a0_.ca_max DESC, a0_.id_annonce_acheteur DESC;