Symfony Profiler

SELECT
  t0.id_localisation AS id_localisation_1,
  t0.dept AS dept_2,
  t0.nom_localisation AS nom_localisation_3,
  t0.id_localisation_pere AS id_localisation_pere_4,
  t0.prefixe AS prefixe_5,
  t0.recherche AS recherche_6
FROM
  fusacq_dbo.localisations t0
WHERE
  t0.id_localisation = ?
LIMIT
  1

SELECT t0.id_localisation AS id_localisation_1, t0.dept AS dept_2, t0.nom_localisation AS nom_localisation_3, t0.id_localisation_pere AS id_localisation_pere_4, t0.prefixe AS prefixe_5, t0.recherche AS recherche_6 FROM fusacq_dbo.localisations t0 WHERE t0.id_localisation = '33_21' LIMIT 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_.id_pays = ?)
  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_.id_pays = 33) AND s0_.afficher_vendeur = 1;

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
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 89859 AND t0_.code_langue = 'FR';

SELECT
  a0_.identifiant_profil AS identifiant_profil_0,
  COUNT(DISTINCT a1_.id_annonce_vendeur) AS sclr_1
FROM
  fusacq_dbo.annonces_vendeur a1_
  LEFT JOIN fusacq_dbo.annonces_vendeur_profils_standards a0_ ON (
    a0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND a0_.identifiant_profil IS NOT NULL
GROUP BY
  a0_.identifiant_profil

SELECT a0_.identifiant_profil AS identifiant_profil_0, COUNT(DISTINCT a1_.id_annonce_vendeur) AS sclr_1 FROM fusacq_dbo.annonces_vendeur a1_ LEFT JOIN fusacq_dbo.annonces_vendeur_profils_standards a0_ ON (a0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND a0_.identifiant_profil IS NOT NULL GROUP BY a0_.identifiant_profil;

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_pays = ?)

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_pays = 33);

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_pays = ?)

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_pays = 33);

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_.id_pays NOT LIKE '33%')
  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_.id_pays NOT LIKE '33%') 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_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 = 33 OR a0_.autres_localisations LIKE '33%' OR a0_.autres_localisations LIKE '%,33%');

SELECT
  a0_.id_annonce_vendeur AS id_annonce_vendeur_0,
  a0_.titre_annonce AS titre_annonce_1,
  a0_.ca_n AS ca_n_2,
  a0_.date_parution_initiale AS date_parution_initiale_3,
  a0_.date_parution_initiale_elite AS date_parution_initiale_elite_4,
  a0_.id_pays AS id_pays_5,
  a0_.id_region AS id_region_6,
  a0_.id_departement AS id_departement_7,
  a0_.id_langue AS id_langue_8,
  a0_.date_fin_publique_elite AS date_fin_publique_elite_9
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND a0_.visible_dernieres_annonces IS NULL
  AND a0_.statuts NOT LIKE '99%'
ORDER BY
  a0_.date_parution_initiale_complete DESC
LIMIT
  5

SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.ca_n AS ca_n_2, a0_.date_parution_initiale AS date_parution_initiale_3, a0_.date_parution_initiale_elite AS date_parution_initiale_elite_4, a0_.id_pays AS id_pays_5, a0_.id_region AS id_region_6, a0_.id_departement AS id_departement_7, a0_.id_langue AS id_langue_8, a0_.date_fin_publique_elite AS date_fin_publique_elite_9 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.visible_dernieres_annonces IS NULL AND a0_.statuts NOT LIKE '99%' ORDER BY a0_.date_parution_initiale_complete DESC LIMIT 5;

SELECT
  COUNT(a0_.id_annonce_vendeur) AS sclr_0,
  a0_.id_region AS id_region_1
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_.statuts NOT LIKE '99%'
  AND a0_.id_region LIKE ?
  AND a0_.id_region <> ?
GROUP BY
  a0_.id_region

SELECT COUNT(a0_.id_annonce_vendeur) AS sclr_0, a0_.id_region AS id_region_1 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_.statuts NOT LIKE '99%' AND a0_.id_region LIKE '33_%' AND a0_.id_region <> '33_99' GROUP BY a0_.id_region;

SELECT
  COUNT(a0_.id_annonce_vendeur) AS sclr_0,
  SUBSTRING(
    a0_.id_secteur_activite
    FROM
      1 FOR 3
  ) AS sclr_1
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND a0_.statuts NOT LIKE '99%'
GROUP BY
  sclr_1

SELECT COUNT(a0_.id_annonce_vendeur) AS sclr_0, SUBSTRING(a0_.id_secteur_activite FROM 1 FOR 3) AS sclr_1 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.statuts NOT LIKE '99%' GROUP BY sclr_1;

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_pays NOT LIKE '33%')

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_pays NOT LIKE '33%');

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_pays NOT LIKE '33%')

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_pays NOT LIKE '33%');

SELECT
  a0_.id_annonce_vendeur AS id_annonce_vendeur_0,
  a0_.titre_annonce AS titre_annonce_1,
  a0_.ca_n AS ca_n_2,
  a0_.date_parution_initiale AS date_parution_initiale_3,
  a0_.date_parution_initiale_elite AS date_parution_initiale_elite_4,
  a0_.id_pays AS id_pays_5,
  a0_.id_region AS id_region_6,
  a0_.id_departement AS id_departement_7,
  a0_.id_langue AS id_langue_8,
  a0_.date_fin_publique_elite AS date_fin_publique_elite_9
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.mode_annonce = 'publique_elite'
  AND a0_.tpe_pme = 'oui'
  AND a0_.visible_dernieres_annonces IS NULL
  AND a0_.statuts NOT LIKE '99%'
ORDER BY
  a0_.date_parution_initiale_complete DESC
LIMIT
  5

SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.ca_n AS ca_n_2, a0_.date_parution_initiale AS date_parution_initiale_3, a0_.date_parution_initiale_elite AS date_parution_initiale_elite_4, a0_.id_pays AS id_pays_5, a0_.id_region AS id_region_6, a0_.id_departement AS id_departement_7, a0_.id_langue AS id_langue_8, a0_.date_fin_publique_elite AS date_fin_publique_elite_9 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.mode_annonce = 'publique_elite' AND a0_.tpe_pme = 'oui' AND a0_.visible_dernieres_annonces IS NULL AND a0_.statuts NOT LIKE '99%' ORDER BY a0_.date_parution_initiale_complete DESC LIMIT 5;

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 NOT LIKE '33%'
    AND a0_.autres_localisations NOT LIKE '33_%'
  )

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 NOT LIKE '33%' AND a0_.autres_localisations NOT LIKE '33_%');

SELECT
  s0_.id_secteur_activite AS id_secteur_activite_0,
  s0_.id_secteur_activite_pere AS id_secteur_activite_pere_1,
  s0_.nom_secteur_activite AS nom_secteur_activite_2,
  s0_.nom_pour_TITLE AS nom_pour_TITLE_3
FROM
  fusacq_dbo.secteurs_activite s0_
WHERE
  s0_.id_secteur_activite_pere < 10
  AND (
    s0_.obsolete <> ?
    OR s0_.obsolete IS NULL
  )

SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.id_secteur_activite_pere AS id_secteur_activite_pere_1, s0_.nom_secteur_activite AS nom_secteur_activite_2, s0_.nom_pour_TITLE AS nom_pour_TITLE_3 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite_pere < 10 AND (s0_.obsolete <> 'oui' OR s0_.obsolete IS NULL);

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
  p0_.valeur_parametre AS valeur_parametre_0
FROM
  partage_dbo.parametres_divers p0_
WHERE
  p0_.id_type_parametre_divers = 1
  AND p0_.nom_parametre = 'list_nombres_acueil_fusacq'

SELECT p0_.valeur_parametre AS valeur_parametre_0 FROM partage_dbo.parametres_divers p0_ WHERE p0_.id_type_parametre_divers = 1 AND p0_.nom_parametre = 'list_nombres_acueil_fusacq';