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_vendeur AS id_annonce_vendeur_0,
  a0_.titre_annonce AS titre_annonce_1,
  a0_.ca_n AS ca_n_2,
  a0_.date_parution_initiale AS date_parution_initiale_3,
  a0_.date_parution_initiale_elite AS date_parution_initiale_elite_4,
  a0_.id_pays AS id_pays_5,
  a0_.id_region AS id_region_6,
  a0_.id_departement AS id_departement_7,
  a0_.id_langue AS id_langue_8,
  a0_.date_fin_publique_elite AS date_fin_publique_elite_9
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND a0_.visible_dernieres_annonces IS NULL
  AND a0_.statuts NOT LIKE '99%'
ORDER BY
  a0_.date_parution_initiale_complete DESC
LIMIT
  5

SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.ca_n AS ca_n_2, a0_.date_parution_initiale AS date_parution_initiale_3, a0_.date_parution_initiale_elite AS date_parution_initiale_elite_4, a0_.id_pays AS id_pays_5, a0_.id_region AS id_region_6, a0_.id_departement AS id_departement_7, a0_.id_langue AS id_langue_8, a0_.date_fin_publique_elite AS date_fin_publique_elite_9 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.visible_dernieres_annonces IS NULL AND a0_.statuts NOT LIKE '99%' ORDER BY a0_.date_parution_initiale_complete DESC LIMIT 5;

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 90184 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 90008 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 90006 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 90002 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 89977 AND t0_.code_langue = 'FR';

SELECT
  a0_.id_annonce_vendeur AS id_annonce_vendeur_0,
  a0_.titre_annonce AS titre_annonce_1,
  a0_.ca_n AS ca_n_2,
  a0_.date_parution_initiale AS date_parution_initiale_3,
  a0_.date_parution_initiale_elite AS date_parution_initiale_elite_4,
  a0_.id_pays AS id_pays_5,
  a0_.id_region AS id_region_6,
  a0_.id_departement AS id_departement_7,
  a0_.id_langue AS id_langue_8,
  a0_.date_fin_publique_elite AS date_fin_publique_elite_9
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.mode_annonce = 'publique_elite'
  AND a0_.tpe_pme = 'oui'
  AND a0_.visible_dernieres_annonces IS NULL
  AND a0_.statuts NOT LIKE '99%'
ORDER BY
  a0_.date_parution_initiale_complete DESC
LIMIT
  5

SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.ca_n AS ca_n_2, a0_.date_parution_initiale AS date_parution_initiale_3, a0_.date_parution_initiale_elite AS date_parution_initiale_elite_4, a0_.id_pays AS id_pays_5, a0_.id_region AS id_region_6, a0_.id_departement AS id_departement_7, a0_.id_langue AS id_langue_8, a0_.date_fin_publique_elite AS date_fin_publique_elite_9 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.mode_annonce = 'publique_elite' AND a0_.tpe_pme = 'oui' AND a0_.visible_dernieres_annonces IS NULL AND a0_.statuts NOT LIKE '99%' ORDER BY a0_.date_parution_initiale_complete DESC LIMIT 5;

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 90171 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 90124 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 90166 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 90165 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 90140 AND t0_.code_langue = 'FR';