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_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
  DISTINCT a0_.id_repreneur AS id_repreneur_0,
  a0_.date_parution_initiale AS date_parution_initiale_1,
  a0_.id_repreneur AS id_repreneur_2
FROM
  fusacq_dbo.annuaire_repreneurs a0_
WHERE
  (a0_.mode_profil = 'publique')
  AND (
    a0_.demarche LIKE '%3%'
    OR a0_.demarche LIKE '%4%'
  )
ORDER BY
  a0_.date_parution_initiale DESC,
  a0_.id_repreneur DESC
LIMIT
  10

SELECT DISTINCT a0_.id_repreneur AS id_repreneur_0, a0_.date_parution_initiale AS date_parution_initiale_1, a0_.id_repreneur AS id_repreneur_2 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE (a0_.mode_profil = 'publique') AND (a0_.demarche LIKE '%3%' OR a0_.demarche LIKE '%4%') ORDER BY a0_.date_parution_initiale DESC, a0_.id_repreneur DESC LIMIT 10;

SELECT
  a0_.id_repreneur AS id_repreneur_0,
  a0_.titre_societe_recherchee AS titre_societe_recherchee_1,
  a0_.titre_profil AS titre_profil_2,
  a0_.id_localisations_recherchees AS id_localisations_recherchees_3,
  a0_.annee_naissance AS annee_naissance_4,
  a0_.montant_apport AS montant_apport_5,
  a0_.ville AS ville_6
FROM
  fusacq_dbo.annuaire_repreneurs a0_
WHERE
  (a0_.mode_profil = 'publique')
  AND (
    a0_.demarche LIKE '%3%'
    OR a0_.demarche LIKE '%4%'
  )
  AND a0_.id_repreneur IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  a0_.date_parution_initiale DESC,
  a0_.id_repreneur DESC

SELECT a0_.id_repreneur AS id_repreneur_0, a0_.titre_societe_recherchee AS titre_societe_recherchee_1, a0_.titre_profil AS titre_profil_2, a0_.id_localisations_recherchees AS id_localisations_recherchees_3, a0_.annee_naissance AS annee_naissance_4, a0_.montant_apport AS montant_apport_5, a0_.ville AS ville_6 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE (a0_.mode_profil = 'publique') AND (a0_.demarche LIKE '%3%' OR a0_.demarche LIKE '%4%') AND a0_.id_repreneur IN (310350, 309595, 308676, 307554, 310011, 297501, 309696, 309689, 309641, 309055) ORDER BY a0_.date_parution_initiale DESC, a0_.id_repreneur DESC;