Symfony Profiler

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

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_period_annonce_prioritaire <> ''
  AND a0_.id_period_annonce_prioritaire IS NOT NULL
  AND a0_.etat_annonce_prioritaire = 'active'

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_period_annonce_prioritaire <> '' AND a0_.id_period_annonce_prioritaire IS NOT NULL AND a0_.etat_annonce_prioritaire = 'active';

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
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_period_annonce_prioritaire <> ''
  AND a0_.id_period_annonce_prioritaire IS NOT NULL
  AND a0_.etat_annonce_prioritaire = 'active'
  AND (
    a0_.type_raprochement = 'acquisition'
    OR a0_.type_raprochement IS NULL
  )
ORDER BY
  a0_.ca_max DESC
LIMIT
  5

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 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_period_annonce_prioritaire <> '' AND a0_.id_period_annonce_prioritaire IS NOT NULL AND a0_.etat_annonce_prioritaire = 'active' AND (a0_.type_raprochement = 'acquisition' OR a0_.type_raprochement IS NULL) ORDER BY a0_.ca_max DESC LIMIT 5;

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 = 'acquisition'
    OR a0_.type_raprochement IS NULL
  )

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 = 'acquisition' OR a0_.type_raprochement IS NULL);

SELECT
  DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0,
  a0_.date_parution_initiale AS date_parution_initiale_1,
  a0_.id_annonce_acheteur AS id_annonce_acheteur_2
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 = 'acquisition'
    OR a0_.type_raprochement IS NULL
  )
ORDER BY
  a0_.date_parution_initiale DESC,
  a0_.id_annonce_acheteur DESC
LIMIT
  10

SELECT DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.date_parution_initiale AS date_parution_initiale_1, a0_.id_annonce_acheteur AS id_annonce_acheteur_2 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 = 'acquisition' OR a0_.type_raprochement IS NULL) ORDER BY a0_.date_parution_initiale DESC, a0_.id_annonce_acheteur DESC LIMIT 10;

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
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 = 'acquisition'
    OR a0_.type_raprochement IS NULL
  )
  AND a0_.id_annonce_acheteur IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  a0_.date_parution_initiale 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 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 = 'acquisition' OR a0_.type_raprochement IS NULL) AND a0_.id_annonce_acheteur IN (18176, 18173, 18172, 18171, 17967, 18167, 18162, 18129, 18158, 18149) ORDER BY a0_.date_parution_initiale DESC, a0_.id_annonce_acheteur DESC;