Symfony Profiler

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
  a0_.id_pays AS id_pays_0,
  l1_.nom_localisation AS nom_localisation_1
FROM
  fusacq_dbo.annonces_vendeur a0_
  LEFT JOIN fusacq_dbo.localisations l1_ ON (
    l1_.id_localisation = a0_.id_pays
  )
WHERE
  a0_.mode_annonce = 'publique'
  AND a0_.id_pays <> '00'
GROUP BY
  a0_.id_pays
ORDER BY
  l1_.nom_localisation ASC

SELECT a0_.id_pays AS id_pays_0, l1_.nom_localisation AS nom_localisation_1 FROM fusacq_dbo.annonces_vendeur a0_ LEFT JOIN fusacq_dbo.localisations l1_ ON (l1_.id_localisation = a0_.id_pays) WHERE a0_.mode_annonce = 'publique' AND a0_.id_pays <> '00' GROUP BY a0_.id_pays ORDER BY l1_.nom_localisation ASC;

SELECT
  a0_.id_pays AS id_pays_0,
  a0_.autres_localisations AS autres_localisations_1
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.mode_annonce = 'publique'
  AND (
    (
      a0_.type_raprochement = 'acquisition'
      OR a0_.type_raprochement IS NULL
    )
  )

SELECT a0_.id_pays AS id_pays_0, a0_.autres_localisations AS autres_localisations_1 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.mode_annonce = 'publique' AND ((a0_.type_raprochement = 'acquisition' OR a0_.type_raprochement IS NULL));

SELECT
  l.nom_localisation,
  s0_.id_service_prestataire,
  s0_.titre_service,
  s0_.src_image_si_artviper_desactive,
  s0_.url_site_web,
  s0_.date_mise_en_ligne,
  s0_.titre_service AS titre_service_0
FROM
  fusacq_dbo.recherche_mots_cles_prestataire r1_
  LEFT JOIN fusacq_dbo.services_prestataire s0_ ON (
    s0_.id_service_prestataire = r1_.id_service_prestataire
  )
  LEFT JOIN fusacq_dbo.localisations l ON (
    l.id_localisation = r1_.id_localisation_prestataire
  )
WHERE
  NULLIF(s0_.id_service_prestataire, '') IS NOT NULL
  AND r1_.type IN ('societe', 'secteur', 'service')
  AND (
    s0_.id_pays = 41
    OR s0_.pays = 41
  )
UNION
SELECT
  l.nom_localisation,
  s0_.id_service_prestataire,
  s0_.titre_service,
  s0_.src_image_si_artviper_desactive,
  s0_.url_site_web,
  s0_.date_mise_en_ligne,
  s0_.titre_service AS titre_service_0
FROM
  fusacq_dbo.recherche_mots_cles_prestataire r1_
  LEFT JOIN fusacq_dbo.services_prestataire s0_ ON (
    s0_.id_service_prestataire = r1_.id_service_prestataire
  )
  LEFT JOIN fusacq_dbo.localisations l ON (
    l.id_localisation = r1_.id_localisation_prestataire
  )
WHERE
  NULLIF(s0_.id_service_prestataire, '') IS NOT NULL
  AND r1_.type IN ('societe', 'secteur', 'service')
  AND (
    r1_.id_localisation_prestataire LIKE '41,%'
    OR r1_.id_localisation_prestataire LIKE '%,41,%'
    OR r1_.id_localisation_prestataire LIKE '%,41'
  )
UNION
SELECT
  l.nom_localisation,
  s0_.id_service_prestataire,
  s0_.titre_service,
  s0_.src_image_si_artviper_desactive,
  s0_.url_site_web,
  s0_.date_mise_en_ligne,
  s0_.titre_service AS titre_service_0
FROM
  fusacq_dbo.recherche_mots_cles_prestataire r1_
  LEFT JOIN fusacq_dbo.services_prestataire s0_ ON (
    s0_.id_service_prestataire = r1_.id_service_prestataire
  )
  LEFT JOIN fusacq_dbo.localisations l ON (
    l.id_localisation = r1_.id_localisation_prestataire
  )
WHERE
  NULLIF(s0_.id_service_prestataire, '') IS NOT NULL
  AND r1_.type IN ('societe', 'secteur', 'service')
  AND (
    s0_.id_pays = 33
    OR s0_.pays = 33
  )
LIMIT
  5

SELECT l.nom_localisation  ,s0_.id_service_prestataire,s0_.titre_service, s0_.src_image_si_artviper_desactive,s0_.url_site_web, s0_.date_mise_en_ligne , s0_.titre_service AS titre_service_0  
            FROM fusacq_dbo.recherche_mots_cles_prestataire r1_ 
            LEFT JOIN  fusacq_dbo.services_prestataire s0_ ON (s0_.id_service_prestataire = r1_.id_service_prestataire) 
            LEFT JOIN  fusacq_dbo.localisations l  ON (l.id_localisation = r1_.id_localisation_prestataire) 
            WHERE    NULLIF(s0_.id_service_prestataire, '') IS NOT NULL AND r1_.type IN ('societe', 'secteur', 'service') 
            AND  (s0_.id_pays =41 OR s0_.pays =41) 
            UNION
            SELECT l.nom_localisation  ,s0_.id_service_prestataire,s0_.titre_service, s0_.src_image_si_artviper_desactive,s0_.url_site_web, s0_.date_mise_en_ligne , s0_.titre_service AS titre_service_0  
            FROM fusacq_dbo.recherche_mots_cles_prestataire r1_ 
            LEFT JOIN  fusacq_dbo.services_prestataire s0_ ON (s0_.id_service_prestataire = r1_.id_service_prestataire) 
            LEFT JOIN  fusacq_dbo.localisations l  ON (l.id_localisation = r1_.id_localisation_prestataire) 
            WHERE    NULLIF(s0_.id_service_prestataire, '') IS NOT NULL AND r1_.type IN ('societe', 'secteur', 'service') 
            AND  (r1_.id_localisation_prestataire LIKE '41,%' OR r1_.id_localisation_prestataire LIKE '%,41,%' OR r1_.id_localisation_prestataire LIKE '%,41' ) 
            UNION 
            SELECT l.nom_localisation  ,s0_.id_service_prestataire,s0_.titre_service, s0_.src_image_si_artviper_desactive,s0_.url_site_web, s0_.date_mise_en_ligne , s0_.titre_service AS titre_service_0  
            FROM fusacq_dbo.recherche_mots_cles_prestataire r1_ 
            LEFT JOIN  fusacq_dbo.services_prestataire s0_ ON (s0_.id_service_prestataire = r1_.id_service_prestataire) 
            LEFT JOIN  fusacq_dbo.localisations l  ON (l.id_localisation = r1_.id_localisation_prestataire) 
            WHERE    NULLIF(s0_.id_service_prestataire, '') IS NOT NULL AND r1_.type IN ('societe', 'secteur', 'service') 
            AND  (s0_.id_pays =33 OR s0_.pays =33)
            LIMIT 5 ;

SELECT
  i0_.id_localisations_recherchees AS id_localisations_recherchees_0
FROM
  fusacq_dbo.investisseurs_prives i0_
WHERE
  i0_.mode = 'publique'
  AND i0_.id_localisations_recherchees IS NOT NULL

SELECT i0_.id_localisations_recherchees AS id_localisations_recherchees_0 FROM fusacq_dbo.investisseurs_prives i0_ WHERE i0_.mode = 'publique' AND i0_.id_localisations_recherchees IS NOT NULL;

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