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
  a0_.id_annonce_acheteur AS id_annonce_acheteur_0,
  a0_.titre_annonce AS titre_annonce_1,
  a0_.ca_societe AS ca_societe_2,
  a0_.ca_max AS ca_max_3,
  a0_.apport_perso_repreneur AS apport_perso_repreneur_4,
  a0_.date_parution_initiale AS date_parution_initiale_5,
  a0_.id_pays AS id_pays_6,
  a0_.id_region AS id_region_7,
  a0_.id_departement AS id_departement_8,
  a0_.id_langue AS id_langue_9
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND a0_.date_parution_initiale IS NOT NULL
  AND (
    (
      a0_.type_raprochement = 'acquisition'
      OR a0_.type_raprochement IS NULL
    )
  )
  AND (
    (
      a0_.id_pays = 41
      OR a0_.autres_localisations LIKE '41%'
      OR a0_.autres_localisations LIKE '%,41%'
    )
  )
ORDER BY
  a0_.date_parution_initiale DESC
LIMIT
  5

SELECT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.ca_societe AS ca_societe_2, a0_.ca_max AS ca_max_3, a0_.apport_perso_repreneur AS apport_perso_repreneur_4, a0_.date_parution_initiale AS date_parution_initiale_5, a0_.id_pays AS id_pays_6, a0_.id_region AS id_region_7, a0_.id_departement AS id_departement_8, a0_.id_langue AS id_langue_9 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.date_parution_initiale IS NOT NULL AND ((a0_.type_raprochement = 'acquisition' OR a0_.type_raprochement IS NULL)) AND ((a0_.id_pays = 41 OR a0_.autres_localisations LIKE '41%' OR a0_.autres_localisations LIKE '%,41%')) ORDER BY a0_.date_parution_initiale DESC LIMIT 5;

SELECT
  t0_.id_translate_annonce_acheteur AS id_translate_annonce_acheteur_0,
  t0_.id_annonce_acheteur AS id_annonce_acheteur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cles AS mots_cles_5,
  t0_.mots_cle_recherche AS mots_cle_recherche_6,
  t0_.description_activite_societe AS description_activite_societe_7,
  t0_.raison_achat AS raison_achat_8,
  t0_.elements_complementaires AS elements_complementaires_9,
  t0_.code_langue AS code_langue_10
FROM
  fusacq_dbo.translate_annonce_acheteur t0_
WHERE
  t0_.id_annonce_acheteur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_acheteur AS id_translate_annonce_acheteur_0, t0_.id_annonce_acheteur AS id_annonce_acheteur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cles AS mots_cles_5, t0_.mots_cle_recherche AS mots_cle_recherche_6, t0_.description_activite_societe AS description_activite_societe_7, t0_.raison_achat AS raison_achat_8, t0_.elements_complementaires AS elements_complementaires_9, t0_.code_langue AS code_langue_10 FROM fusacq_dbo.translate_annonce_acheteur t0_ WHERE t0_.id_annonce_acheteur = 18103 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_acheteur AS id_translate_annonce_acheteur_0,
  t0_.id_annonce_acheteur AS id_annonce_acheteur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cles AS mots_cles_5,
  t0_.mots_cle_recherche AS mots_cle_recherche_6,
  t0_.description_activite_societe AS description_activite_societe_7,
  t0_.raison_achat AS raison_achat_8,
  t0_.elements_complementaires AS elements_complementaires_9,
  t0_.code_langue AS code_langue_10
FROM
  fusacq_dbo.translate_annonce_acheteur t0_
WHERE
  t0_.id_annonce_acheteur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_acheteur AS id_translate_annonce_acheteur_0, t0_.id_annonce_acheteur AS id_annonce_acheteur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cles AS mots_cles_5, t0_.mots_cle_recherche AS mots_cle_recherche_6, t0_.description_activite_societe AS description_activite_societe_7, t0_.raison_achat AS raison_achat_8, t0_.elements_complementaires AS elements_complementaires_9, t0_.code_langue AS code_langue_10 FROM fusacq_dbo.translate_annonce_acheteur t0_ WHERE t0_.id_annonce_acheteur = 17439 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_acheteur AS id_translate_annonce_acheteur_0,
  t0_.id_annonce_acheteur AS id_annonce_acheteur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cles AS mots_cles_5,
  t0_.mots_cle_recherche AS mots_cle_recherche_6,
  t0_.description_activite_societe AS description_activite_societe_7,
  t0_.raison_achat AS raison_achat_8,
  t0_.elements_complementaires AS elements_complementaires_9,
  t0_.code_langue AS code_langue_10
FROM
  fusacq_dbo.translate_annonce_acheteur t0_
WHERE
  t0_.id_annonce_acheteur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_acheteur AS id_translate_annonce_acheteur_0, t0_.id_annonce_acheteur AS id_annonce_acheteur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cles AS mots_cles_5, t0_.mots_cle_recherche AS mots_cle_recherche_6, t0_.description_activite_societe AS description_activite_societe_7, t0_.raison_achat AS raison_achat_8, t0_.elements_complementaires AS elements_complementaires_9, t0_.code_langue AS code_langue_10 FROM fusacq_dbo.translate_annonce_acheteur t0_ WHERE t0_.id_annonce_acheteur = 17461 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_acheteur AS id_translate_annonce_acheteur_0,
  t0_.id_annonce_acheteur AS id_annonce_acheteur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cles AS mots_cles_5,
  t0_.mots_cle_recherche AS mots_cle_recherche_6,
  t0_.description_activite_societe AS description_activite_societe_7,
  t0_.raison_achat AS raison_achat_8,
  t0_.elements_complementaires AS elements_complementaires_9,
  t0_.code_langue AS code_langue_10
FROM
  fusacq_dbo.translate_annonce_acheteur t0_
WHERE
  t0_.id_annonce_acheteur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_acheteur AS id_translate_annonce_acheteur_0, t0_.id_annonce_acheteur AS id_annonce_acheteur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cles AS mots_cles_5, t0_.mots_cle_recherche AS mots_cle_recherche_6, t0_.description_activite_societe AS description_activite_societe_7, t0_.raison_achat AS raison_achat_8, t0_.elements_complementaires AS elements_complementaires_9, t0_.code_langue AS code_langue_10 FROM fusacq_dbo.translate_annonce_acheteur t0_ WHERE t0_.id_annonce_acheteur = 17983 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_acheteur AS id_translate_annonce_acheteur_0,
  t0_.id_annonce_acheteur AS id_annonce_acheteur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cles AS mots_cles_5,
  t0_.mots_cle_recherche AS mots_cle_recherche_6,
  t0_.description_activite_societe AS description_activite_societe_7,
  t0_.raison_achat AS raison_achat_8,
  t0_.elements_complementaires AS elements_complementaires_9,
  t0_.code_langue AS code_langue_10
FROM
  fusacq_dbo.translate_annonce_acheteur t0_
WHERE
  t0_.id_annonce_acheteur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_acheteur AS id_translate_annonce_acheteur_0, t0_.id_annonce_acheteur AS id_annonce_acheteur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cles AS mots_cles_5, t0_.mots_cle_recherche AS mots_cle_recherche_6, t0_.description_activite_societe AS description_activite_societe_7, t0_.raison_achat AS raison_achat_8, t0_.elements_complementaires AS elements_complementaires_9, t0_.code_langue AS code_langue_10 FROM fusacq_dbo.translate_annonce_acheteur t0_ WHERE t0_.id_annonce_acheteur = 17822 AND t0_.code_langue = 'FR';