Symfony Profiler

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
  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
  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,
  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
  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
  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
  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
  DISTINCT (s0_.id_service_prestataire) AS sclr_0,
  l1_.nom_localisation AS nom_localisation_1,
  s0_.id_localisation_prestataire AS id_localisation_prestataire_2,
  s0_.titre_service AS titre_service_3,
  s0_.nom_commercial_societe AS nom_commercial_societe_4,
  s0_.date_mise_en_ligne AS date_mise_en_ligne_5,
  s0_.resume_service AS resume_service_6,
  s0_.url_site_web_visible AS url_site_web_visible_7,
  s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_8,
  s0_.utiliser_artviper AS utiliser_artviper_9,
  c2_.code_postal AS code_postal_10,
  c2_.ville AS ville_11,
  c2_.nom_contact1 AS nom_contact1_12
FROM
  fusacq_dbo.services_prestataire s0_
  LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s3_ ON (
    (
      s0_.id_secteur_new = s3_.pointe_vers
    )
  )
  LEFT JOIN localisations_prestataire l4_ ON (
    (
      s0_.id_localisation_prestataire = l4_.id_localisation_prestataire
    )
  )
  LEFT JOIN fusacq_dbo.localisations l1_ ON (
    (
      l1_.id_localisation = l4_.id_localisation_prestataire
    )
  )
  LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c2_ ON (
    (
      s0_.id_service_prestataire = c2_.id_service_prestataire
    )
  )
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite = 'prestataire'
  AND (
    l4_.id_localisation_prestataire LIKE '%33%'
    OR l4_.id_localisation_prestataire = ''
    OR l4_.id_localisation_prestataire IS NULL
  )
ORDER BY
  s0_.date_mise_en_ligne DESC,
  s0_.id_service_prestataire DESC
LIMIT
  5

SELECT DISTINCT (s0_.id_service_prestataire) AS sclr_0, l1_.nom_localisation AS nom_localisation_1, s0_.id_localisation_prestataire AS id_localisation_prestataire_2, s0_.titre_service AS titre_service_3, s0_.nom_commercial_societe AS nom_commercial_societe_4, s0_.date_mise_en_ligne AS date_mise_en_ligne_5, s0_.resume_service AS resume_service_6, s0_.url_site_web_visible AS url_site_web_visible_7, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_8, s0_.utiliser_artviper AS utiliser_artviper_9, c2_.code_postal AS code_postal_10, c2_.ville AS ville_11, c2_.nom_contact1 AS nom_contact1_12 FROM fusacq_dbo.services_prestataire s0_ LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s3_ ON ((s0_.id_secteur_new = s3_.pointe_vers)) LEFT JOIN localisations_prestataire l4_ ON ((s0_.id_localisation_prestataire = l4_.id_localisation_prestataire)) LEFT JOIN fusacq_dbo.localisations l1_ ON ((l1_.id_localisation = l4_.id_localisation_prestataire)) LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c2_ ON ((s0_.id_service_prestataire = c2_.id_service_prestataire)) WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite = 'prestataire' AND (l4_.id_localisation_prestataire LIKE '%33%' OR l4_.id_localisation_prestataire = '' OR l4_.id_localisation_prestataire IS NULL) ORDER BY s0_.date_mise_en_ligne DESC, s0_.id_service_prestataire DESC LIMIT 5;

SELECT
  b0_.id_actualite AS id_actualite_0,
  b0_.titre_actualite AS titre_actualite_1,
  b0_.description_actualite AS description_actualite_2,
  b0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_3,
  s1_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_4,
  b0_.date_mise_en_ligne AS date_mise_en_ligne_5
FROM
  fusacq_dbo.buzz_actualites b0_
  LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (
    b0_.id_operation = b2_.id_operation
  )
  LEFT JOIN fusacq_dbo.services_prestataire s1_ ON (
    b0_.id_service_principal = s1_.id_service_prestataire
  )
WHERE
  SUBSTRING(
    b0_.id_localisation
    FROM
      1 FOR 2
  ) = '33'
  AND b0_.mode_actualite = ?
  AND b2_.type_operation = ?
  AND b0_.date_mise_en_ligne <= ?
ORDER BY
  b0_.date_mise_en_ligne DESC
LIMIT
  5

SELECT b0_.id_actualite AS id_actualite_0, b0_.titre_actualite AS titre_actualite_1, b0_.description_actualite AS description_actualite_2, b0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_3, s1_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_4, b0_.date_mise_en_ligne AS date_mise_en_ligne_5 FROM fusacq_dbo.buzz_actualites b0_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b0_.id_operation = b2_.id_operation) LEFT JOIN fusacq_dbo.services_prestataire s1_ ON (b0_.id_service_principal = s1_.id_service_prestataire) WHERE SUBSTRING(b0_.id_localisation FROM 1 FOR 2) = '33' AND b0_.mode_actualite = 'publique' AND b2_.type_operation = 'fusion_acquisition' AND b0_.date_mise_en_ligne <= '20260413153207' ORDER BY b0_.date_mise_en_ligne DESC LIMIT 5;

SELECT
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?

SELECT photo_actualite FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 258627;

SELECT
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?

SELECT photo_actualite FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 258627;

SELECT
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?

SELECT photo_actualite FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 258625;

SELECT
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?

SELECT photo_actualite FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 258625;

SELECT
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?

SELECT photo_actualite FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 258624;

SELECT
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?

SELECT photo_actualite FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 258624;

SELECT
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?

SELECT photo_actualite FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 258609;

SELECT
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?

SELECT photo_actualite FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 258609;

SELECT
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?

SELECT photo_actualite FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 258608;

SELECT
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?

SELECT photo_actualite FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 258608;

SELECT
  b0_.id_actualite AS id_actualite_0,
  b0_.date_mise_en_ligne AS date_mise_en_ligne_1,
  b0_.titre_actualite AS titre_actualite_2
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.provenance_flux_actualite = ?
  AND b0_.mode_actualite LIKE ?
  AND b0_.visibilite_flux LIKE ?
  AND b0_.date_mise_en_ligne <= ?
  AND SUBSTRING(
    b0_.id_localisation
    FROM
      1 FOR 2
  ) = ?
ORDER BY
  b0_.date_mise_en_ligne DESC
LIMIT
  5

SELECT b0_.id_actualite AS id_actualite_0, b0_.date_mise_en_ligne AS date_mise_en_ligne_1, b0_.titre_actualite AS titre_actualite_2 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.provenance_flux_actualite = 'blog' AND b0_.mode_actualite LIKE 'publique' AND b0_.visibilite_flux LIKE '%horsflux%' AND b0_.date_mise_en_ligne <= '20260413153207' AND SUBSTRING(b0_.id_localisation FROM 1 FOR 2) = '33' ORDER BY b0_.date_mise_en_ligne DESC LIMIT 5;

SELECT
  q0_.id_question AS id_question_0,
  q0_.question AS question_1,
  q0_.date_parution AS date_parution_2
FROM
  fusacq_dbo.questions_semaine q0_
WHERE
  q0_.mode = 'publique'
  AND q0_.date_parution <= 20260413
ORDER BY
  q0_.date_parution DESC
LIMIT
  1

SELECT q0_.id_question AS id_question_0, q0_.question AS question_1, q0_.date_parution AS date_parution_2 FROM fusacq_dbo.questions_semaine q0_ WHERE q0_.mode = 'publique' AND q0_.date_parution <= 20260413 ORDER BY q0_.date_parution DESC LIMIT 1;

SELECT
  b0_.id_question AS id_question_0,
  b0_.date_publication AS date_publication_1,
  b0_.question AS question_2
FROM
  fusacq_dbo.base_connaissance b0_
WHERE
  (
    b0_.mode = 'publique'
    AND b0_.visibilite_autres_sites LIKE '%fusacq%'
    AND b0_.date_publication < 20260413
  )
ORDER BY
  RAND() ASC
LIMIT
  1

SELECT b0_.id_question AS id_question_0, b0_.date_publication AS date_publication_1, b0_.question AS question_2 FROM fusacq_dbo.base_connaissance b0_ WHERE (b0_.mode = 'publique' AND b0_.visibilite_autres_sites LIKE '%fusacq%' AND b0_.date_publication < 20260413) ORDER BY RAND() ASC LIMIT 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 = 'nb_annonces_publiques_PDC' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';