Symfony Profiler

SELECT
  t0_.id_translation AS id_translation_0,
  t0_.md5_fr AS md5_fr_1,
  t0_.texte_fr AS texte_fr_2,
  t0_.contexte_fr AS contexte_fr_3,
  t0_.md5_en AS md5_en_4,
  t0_.texte_en AS texte_en_5,
  t0_.contexte_en AS contexte_en_6,
  t0_.md5_fr_ca AS md5_fr_ca_7,
  t0_.texte_fr_ca AS texte_fr_ca_8,
  t0_.contexte_fr_ca AS contexte_fr_ca_9,
  t0_.md5_generique AS md5_generique_10,
  t0_.texte_generique AS texte_generique_11,
  t0_.contexte_generique AS contexte_generique_12,
  t0_.md5_es AS md5_es_13,
  t0_.texte_es AS texte_es_14,
  t0_.contexte_es AS contexte_es_15,
  t0_.md5_de AS md5_de_16,
  t0_.texte_de AS texte_de_17,
  t0_.contexte_de AS contexte_de_18,
  t0_.md5_nl AS md5_nl_19,
  t0_.texte_nl AS texte_nl_20,
  t0_.contexte_nl AS contexte_nl_21,
  t0_.md5_it AS md5_it_22,
  t0_.texte_it AS texte_it_23,
  t0_.contexte_it AS contexte_it_24,
  t0_.etat_en AS etat_en_25,
  t0_.etat_es AS etat_es_26,
  t0_.etat_de AS etat_de_27,
  t0_.etat_nl AS etat_nl_28,
  t0_.etat_it AS etat_it_29,
  t0_.etat_fr_ca AS etat_fr_ca_30,
  t0_.traduit_deepl AS traduit_deepl_31,
  t0_.created_at AS created_at_32,
  t0_.page_url AS page_url_33,
  t0_.etat_fr_ch AS etat_fr_ch_34,
  t0_.md5_fr_ch AS md5_fr_ch_35,
  t0_.texte_fr_ch AS texte_fr_ch_36,
  t0_.contexte_fr_ch AS contexte_fr_ch_37
FROM
  partage_dbo.translation t1_,
  partage_dbo.translation t0_
WHERE
  t0_.md5_generique = ?

SELECT t0_.id_translation AS id_translation_0, t0_.md5_fr AS md5_fr_1, t0_.texte_fr AS texte_fr_2, t0_.contexte_fr AS contexte_fr_3, t0_.md5_en AS md5_en_4, t0_.texte_en AS texte_en_5, t0_.contexte_en AS contexte_en_6, t0_.md5_fr_ca AS md5_fr_ca_7, t0_.texte_fr_ca AS texte_fr_ca_8, t0_.contexte_fr_ca AS contexte_fr_ca_9, t0_.md5_generique AS md5_generique_10, t0_.texte_generique AS texte_generique_11, t0_.contexte_generique AS contexte_generique_12, t0_.md5_es AS md5_es_13, t0_.texte_es AS texte_es_14, t0_.contexte_es AS contexte_es_15, t0_.md5_de AS md5_de_16, t0_.texte_de AS texte_de_17, t0_.contexte_de AS contexte_de_18, t0_.md5_nl AS md5_nl_19, t0_.texte_nl AS texte_nl_20, t0_.contexte_nl AS contexte_nl_21, t0_.md5_it AS md5_it_22, t0_.texte_it AS texte_it_23, t0_.contexte_it AS contexte_it_24, t0_.etat_en AS etat_en_25, t0_.etat_es AS etat_es_26, t0_.etat_de AS etat_de_27, t0_.etat_nl AS etat_nl_28, t0_.etat_it AS etat_it_29, t0_.etat_fr_ca AS etat_fr_ca_30, t0_.traduit_deepl AS traduit_deepl_31, t0_.created_at AS created_at_32, t0_.page_url AS page_url_33, t0_.etat_fr_ch AS etat_fr_ch_34, t0_.md5_fr_ch AS md5_fr_ch_35, t0_.texte_fr_ch AS texte_fr_ch_36, t0_.contexte_fr_ch AS contexte_fr_ch_37 FROM partage_dbo.translation t1_, partage_dbo.translation t0_ WHERE t0_.md5_generique = '8e54701ff978e7faa5263430593608c8';

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 = 'partenaire'
  AND (
    (
      a0_.id_pays = 01
      OR a0_.autres_localisations LIKE '01%'
      OR a0_.autres_localisations LIKE '%,01%'
    )
  )
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 = 'partenaire' AND ((a0_.id_pays = 01 OR a0_.autres_localisations LIKE '01%' OR a0_.autres_localisations LIKE '%,01%')) 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 = 17678 AND t0_.code_langue = 'FR';

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