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
  s.id_repreneur AS idRepreneur,
  s.titre_profil AS titreProfil,
  s.date_parution_initiale AS dateParutionInitiale,
  s.ville,
  s.id_localisations_recherchees AS idLocalisationsRecherchees,
  s.titre_societe_recherchee AS titreSocieteRecherchee,
  COALESCE(d.devise, 'EUR') AS devise,
  d.montant_apport,
  s.montant_apport AS montantApport
FROM
  fusacq_dbo.annuaire_repreneurs s
  LEFT JOIN fusacq_dbo.annuaire_repreneurs_details d ON d.id_repreneur = s.id_repreneur
WHERE
  s.mode_profil = 'publique'
  AND s.id_pays = '01'
UNION
SELECT
  s.id_repreneur AS idRepreneur,
  s.titre_profil AS titreProfil,
  s.date_parution_initiale AS dateParutionInitiale,
  s.ville,
  s.id_localisations_recherchees AS idLocalisationsRecherchees,
  s.titre_societe_recherchee AS titreSocieteRecherchee,
  COALESCE(d.devise, 'EUR') AS devise,
  d.montant_apport,
  s.montant_apport AS montantApport
FROM
  fusacq_dbo.annuaire_repreneurs s
  LEFT JOIN fusacq_dbo.annuaire_repreneurs_details d ON d.id_repreneur = s.id_repreneur
WHERE
  s.mode_profil = 'publique'
  AND (
    s.id_localisations_recherchees LIKE '%,01,%'
    OR s.id_localisations_recherchees LIKE '%,01'
    OR s.id_localisations_recherchees LIKE '01,%'
  )
UNION
SELECT
  s.id_repreneur AS idRepreneur,
  s.titre_profil AS titreProfil,
  s.date_parution_initiale AS dateParutionInitiale,
  s.ville,
  s.id_localisations_recherchees AS idLocalisationsRecherchees,
  s.titre_societe_recherchee AS titreSocieteRecherchee,
  COALESCE(d.devise, 'EUR') AS devise,
  d.montant_apport,
  s.montant_apport AS montantApport
FROM
  fusacq_dbo.annuaire_repreneurs s
  LEFT JOIN fusacq_dbo.annuaire_repreneurs_details d ON d.id_repreneur = s.id_repreneur
WHERE
  s.mode_profil = 'publique'
  AND s.id_pays = '33'
LIMIT
  5

SELECT s.id_repreneur AS idRepreneur,s.titre_profil AS titreProfil  ,s.date_parution_initiale  AS dateParutionInitiale,s.ville,s.id_localisations_recherchees AS idLocalisationsRecherchees,s.titre_societe_recherchee AS titreSocieteRecherchee,COALESCE(d.devise, 'EUR') AS devise,d.montant_apport,s.montant_apport AS  montantApport
            FROM  fusacq_dbo.annuaire_repreneurs s
            LEFT JOIN fusacq_dbo.annuaire_repreneurs_details d ON  d.id_repreneur = s.id_repreneur
            WHERE  s.mode_profil='publique' AND  s.id_pays = '01' 
            UNION
            SELECT s.id_repreneur AS idRepreneur,s.titre_profil AS titreProfil  ,s.date_parution_initiale  AS dateParutionInitiale,s.ville,s.id_localisations_recherchees AS idLocalisationsRecherchees,s.titre_societe_recherchee AS titreSocieteRecherchee,COALESCE(d.devise, 'EUR') AS devise,d.montant_apport,s.montant_apport AS  montantApport
            FROM  fusacq_dbo.annuaire_repreneurs s
            LEFT JOIN fusacq_dbo.annuaire_repreneurs_details d ON  d.id_repreneur = s.id_repreneur
            WHERE  s.mode_profil='publique' AND  ( s.id_localisations_recherchees LIKE '%,01,%' OR s.id_localisations_recherchees LIKE '%,01' OR s.id_localisations_recherchees LIKE '01,%'  )
            UNION
            SELECT s.id_repreneur AS idRepreneur,s.titre_profil AS titreProfil  ,s.date_parution_initiale  AS dateParutionInitiale,s.ville,s.id_localisations_recherchees AS idLocalisationsRecherchees,s.titre_societe_recherchee AS titreSocieteRecherchee,COALESCE(d.devise, 'EUR') AS devise,d.montant_apport,s.montant_apport AS  montantApport
            FROM  fusacq_dbo.annuaire_repreneurs s
            LEFT JOIN fusacq_dbo.annuaire_repreneurs_details d ON  d.id_repreneur = s.id_repreneur
            WHERE  s.mode_profil='publique' AND  s.id_pays = '33'  
            LIMIT 5 
            ;