Symfony Profiler

SELECT
  t0.id_repreneur AS id_repreneur_1,
  t0.login AS login_2,
  t0.mode_profil AS mode_profil_3,
  t0.nom AS nom_4,
  t0.prenom AS prenom_5,
  t0.adresse AS adresse_6,
  t0.code_postal AS code_postal_7,
  t0.ville AS ville_8,
  t0.id_pays AS id_pays_9,
  t0.telephone AS telephone_10,
  t0.indicatif_telephone AS indicatif_telephone_11,
  t0.email AS email_12,
  t0.annee_naissance AS annee_naissance_13,
  t0.description_societe_recherchee AS description_societe_recherchee_14,
  t0.mots_cles_activite AS mots_cles_activite_15,
  t0.id_secteur_activite_recherche AS id_secteur_activite_recherche_16,
  t0.localisations_recherchees AS localisations_recherchees_17,
  t0.valeur_min_entreprise AS valeur_min_entreprise_18,
  t0.valeur_max_entreprise AS valeur_max_entreprise_19,
  t0.montant_apport AS montant_apport_20,
  t0.formation AS formation_21,
  t0.parcours_professionnel AS parcours_professionnel_22,
  t0.competences AS competences_23,
  t0.competences_recherchees AS competences_recherchees_24,
  t0.mobile_geographiquement AS mobile_geographiquement_25,
  t0.commentaires AS commentaires_26,
  t0.date_mise_a_jour AS date_mise_a_jour_27,
  t0.visible_annuaire AS visible_annuaire_28,
  t0.consultable_fp AS consultable_fp_29,
  t0.consultable_ce AS consultable_ce_30,
  t0.date_parution AS date_parution_31,
  t0.date_parution_initiale AS date_parution_initiale_32,
  t0.date_parution_initiale_complete AS date_parution_initiale_complete_33,
  t0.relance_mise_a_jour AS relance_mise_a_jour_34,
  t0.date_relance AS date_relance_35,
  t0.deja_publique AS deja_publique_36,
  t0.titre_societe_recherchee AS titre_societe_recherchee_37,
  t0.id_localisations_recherchees AS id_localisations_recherchees_38,
  t0.demarche AS demarche_39,
  t0.complements_demarche AS complements_demarche_40,
  t0.titre_profil AS titre_profil_41,
  t0.pourcentage_hauteur_popup AS pourcentage_hauteur_popup_42,
  t0.publication_newsletter_buzz AS publication_newsletter_buzz_43,
  t0.mots_cle_recherche AS mots_cle_recherche_44,
  t0.statut AS statut_45,
  t0.id_period_annonce_prioritaire AS id_period_annonce_prioritaire_46,
  t0.etat_annonce_prioritaire AS etat_annonce_prioritaire_47,
  t0.date_debut_annonce_prioritaire AS date_debut_annonce_prioritaire_48,
  t0.date_arret_annonce_prioritaire AS date_arret_annonce_prioritaire_49,
  t0.suivi AS suivi_50,
  t0.is_international AS is_international_51
FROM
  fusacq_dbo.annuaire_repreneurs t0
WHERE
  t0.id_repreneur = ?
LIMIT
  1

SELECT t0.id_repreneur AS id_repreneur_1, t0.login AS login_2, t0.mode_profil AS mode_profil_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.adresse AS adresse_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.id_pays AS id_pays_9, t0.telephone AS telephone_10, t0.indicatif_telephone AS indicatif_telephone_11, t0.email AS email_12, t0.annee_naissance AS annee_naissance_13, t0.description_societe_recherchee AS description_societe_recherchee_14, t0.mots_cles_activite AS mots_cles_activite_15, t0.id_secteur_activite_recherche AS id_secteur_activite_recherche_16, t0.localisations_recherchees AS localisations_recherchees_17, t0.valeur_min_entreprise AS valeur_min_entreprise_18, t0.valeur_max_entreprise AS valeur_max_entreprise_19, t0.montant_apport AS montant_apport_20, t0.formation AS formation_21, t0.parcours_professionnel AS parcours_professionnel_22, t0.competences AS competences_23, t0.competences_recherchees AS competences_recherchees_24, t0.mobile_geographiquement AS mobile_geographiquement_25, t0.commentaires AS commentaires_26, t0.date_mise_a_jour AS date_mise_a_jour_27, t0.visible_annuaire AS visible_annuaire_28, t0.consultable_fp AS consultable_fp_29, t0.consultable_ce AS consultable_ce_30, t0.date_parution AS date_parution_31, t0.date_parution_initiale AS date_parution_initiale_32, t0.date_parution_initiale_complete AS date_parution_initiale_complete_33, t0.relance_mise_a_jour AS relance_mise_a_jour_34, t0.date_relance AS date_relance_35, t0.deja_publique AS deja_publique_36, t0.titre_societe_recherchee AS titre_societe_recherchee_37, t0.id_localisations_recherchees AS id_localisations_recherchees_38, t0.demarche AS demarche_39, t0.complements_demarche AS complements_demarche_40, t0.titre_profil AS titre_profil_41, t0.pourcentage_hauteur_popup AS pourcentage_hauteur_popup_42, t0.publication_newsletter_buzz AS publication_newsletter_buzz_43, t0.mots_cle_recherche AS mots_cle_recherche_44, t0.statut AS statut_45, t0.id_period_annonce_prioritaire AS id_period_annonce_prioritaire_46, t0.etat_annonce_prioritaire AS etat_annonce_prioritaire_47, t0.date_debut_annonce_prioritaire AS date_debut_annonce_prioritaire_48, t0.date_arret_annonce_prioritaire AS date_arret_annonce_prioritaire_49, t0.suivi AS suivi_50, t0.is_international AS is_international_51 FROM fusacq_dbo.annuaire_repreneurs t0 WHERE t0.id_repreneur = '310410' LIMIT 1;

SELECT
  a0_.id_repreneur AS id_repreneur_0,
  a0_.titre_societe_recherchee AS titre_societe_recherchee_1,
  a0_.titre_profil AS titre_profil_2,
  a0_.id_localisations_recherchees AS id_localisations_recherchees_3,
  a0_.annee_naissance AS annee_naissance_4,
  a0_.montant_apport AS montant_apport_5,
  a0_.ville AS ville_6,
  CASE WHEN a0_.id_localisations_recherchees LIKE ?
  OR a0_.id_localisations_recherchees LIKE ?
  OR a0_.id_localisations_recherchees LIKE ?
  OR a0_.id_localisations_recherchees LIKE ? THEN 4 ELSE 1 END AS sclr_7
FROM
  fusacq_dbo.annuaire_repreneurs a0_
WHERE
  (a0_.mode_profil = 'publique')
  AND (
    a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
  )
ORDER BY
  sclr_7 DESC,
  a0_.montant_apport DESC,
  a0_.id_repreneur DESC
LIMIT
  1 OFFSET 311

SELECT a0_.id_repreneur AS id_repreneur_0, a0_.titre_societe_recherchee AS titre_societe_recherchee_1, a0_.titre_profil AS titre_profil_2, a0_.id_localisations_recherchees AS id_localisations_recherchees_3, a0_.annee_naissance AS annee_naissance_4, a0_.montant_apport AS montant_apport_5, a0_.ville AS ville_6, CASE WHEN a0_.id_localisations_recherchees LIKE 33 OR a0_.id_localisations_recherchees LIKE '33,%' OR a0_.id_localisations_recherchees LIKE '%,33,%' OR a0_.id_localisations_recherchees LIKE '%,33' THEN 4 ELSE 1 END AS sclr_7 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE (a0_.mode_profil = 'publique') AND (a0_.id_localisations_recherchees LIKE '%,33%' OR a0_.id_localisations_recherchees LIKE '33%') ORDER BY sclr_7 DESC, a0_.montant_apport DESC, a0_.id_repreneur DESC LIMIT 1 OFFSET 311;

SELECT
  a0_.id_repreneur AS id_repreneur_0,
  a0_.titre_societe_recherchee AS titre_societe_recherchee_1,
  a0_.titre_profil AS titre_profil_2,
  a0_.id_localisations_recherchees AS id_localisations_recherchees_3,
  a0_.annee_naissance AS annee_naissance_4,
  a0_.montant_apport AS montant_apport_5,
  a0_.ville AS ville_6,
  CASE WHEN a0_.id_localisations_recherchees LIKE ?
  OR a0_.id_localisations_recherchees LIKE ?
  OR a0_.id_localisations_recherchees LIKE ?
  OR a0_.id_localisations_recherchees LIKE ? THEN 4 ELSE 1 END AS sclr_7
FROM
  fusacq_dbo.annuaire_repreneurs a0_
WHERE
  (a0_.mode_profil = 'publique')
  AND (
    a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
  )
ORDER BY
  sclr_7 DESC,
  a0_.montant_apport DESC,
  a0_.id_repreneur DESC
LIMIT
  1 OFFSET 313

SELECT a0_.id_repreneur AS id_repreneur_0, a0_.titre_societe_recherchee AS titre_societe_recherchee_1, a0_.titre_profil AS titre_profil_2, a0_.id_localisations_recherchees AS id_localisations_recherchees_3, a0_.annee_naissance AS annee_naissance_4, a0_.montant_apport AS montant_apport_5, a0_.ville AS ville_6, CASE WHEN a0_.id_localisations_recherchees LIKE 33 OR a0_.id_localisations_recherchees LIKE '33,%' OR a0_.id_localisations_recherchees LIKE '%,33,%' OR a0_.id_localisations_recherchees LIKE '%,33' THEN 4 ELSE 1 END AS sclr_7 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE (a0_.mode_profil = 'publique') AND (a0_.id_localisations_recherchees LIKE '%,33%' OR a0_.id_localisations_recherchees LIKE '33%') ORDER BY sclr_7 DESC, a0_.montant_apport DESC, a0_.id_repreneur DESC LIMIT 1 OFFSET 313;

SELECT
  a0_.id_repreneur AS id_repreneur_0,
  a0_.date_parution AS date_parution_1,
  a0_.date_parution_initiale AS date_parution_initiale_2,
  a0_.nom AS nom_3,
  a0_.prenom AS prenom_4,
  a0_.adresse AS adresse_5,
  a0_.code_postal AS code_postal_6,
  a0_.telephone AS telephone_7,
  a0_.indicatif_telephone AS indicatif_telephone_8,
  a0_.email AS email_9,
  a0_.ville AS ville_10,
  a0_.id_pays AS id_pays_11,
  a0_.description_societe_recherchee AS description_societe_recherchee_12,
  a0_.annee_naissance AS annee_naissance_13,
  a0_.formation AS formation_14,
  a0_.parcours_professionnel AS parcours_professionnel_15,
  a0_.competences_recherchees AS competences_recherchees_16,
  a0_.competences AS competences_17,
  a0_.titre_societe_recherchee AS titre_societe_recherchee_18,
  a0_.id_localisations_recherchees AS id_localisations_recherchees_19,
  a0_.valeur_max_entreprise AS valeur_max_entreprise_20,
  a0_.valeur_min_entreprise AS valeur_min_entreprise_21,
  a0_.montant_apport AS montant_apport_22,
  a0_.demarche AS demarche_23,
  a0_.id_secteur_activite_recherche AS id_secteur_activite_recherche_24,
  a0_.mots_cles_activite AS mots_cles_activite_25,
  a0_.complements_demarche AS complements_demarche_26,
  a0_.mots_cle_recherche AS mots_cle_recherche_27,
  a0_.mode_profil AS mode_profil_28
FROM
  fusacq_dbo.annuaire_repreneurs a0_
WHERE
  a0_.id_repreneur = ?
LIMIT
  1

SELECT a0_.id_repreneur AS id_repreneur_0, a0_.date_parution AS date_parution_1, a0_.date_parution_initiale AS date_parution_initiale_2, a0_.nom AS nom_3, a0_.prenom AS prenom_4, a0_.adresse AS adresse_5, a0_.code_postal AS code_postal_6, a0_.telephone AS telephone_7, a0_.indicatif_telephone AS indicatif_telephone_8, a0_.email AS email_9, a0_.ville AS ville_10, a0_.id_pays AS id_pays_11, a0_.description_societe_recherchee AS description_societe_recherchee_12, a0_.annee_naissance AS annee_naissance_13, a0_.formation AS formation_14, a0_.parcours_professionnel AS parcours_professionnel_15, a0_.competences_recherchees AS competences_recherchees_16, a0_.competences AS competences_17, a0_.titre_societe_recherchee AS titre_societe_recherchee_18, a0_.id_localisations_recherchees AS id_localisations_recherchees_19, a0_.valeur_max_entreprise AS valeur_max_entreprise_20, a0_.valeur_min_entreprise AS valeur_min_entreprise_21, a0_.montant_apport AS montant_apport_22, a0_.demarche AS demarche_23, a0_.id_secteur_activite_recherche AS id_secteur_activite_recherche_24, a0_.mots_cles_activite AS mots_cles_activite_25, a0_.complements_demarche AS complements_demarche_26, a0_.mots_cle_recherche AS mots_cle_recherche_27, a0_.mode_profil AS mode_profil_28 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.id_repreneur = 310410 LIMIT 1;

SELECT
  t0.id_secteur_activite AS id_secteur_activite_1,
  t0.nom_secteur_activite AS nom_secteur_activite_2,
  t0.obsolete AS obsolete_3,
  t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4,
  t0.site_partenaire AS site_partenaire_5,
  t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6,
  t0.id_secteur_activite_pere AS id_secteur_activite_pere_7,
  t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8,
  t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9,
  t0.nom_pour_TITLE AS nom_pour_TITLE_10,
  t0.rare AS rare_11,
  t0.recherche AS recherche_12,
  t0.image_filename AS image_filename_13
FROM
  fusacq_dbo.secteurs_activite t0
WHERE
  t0.id_secteur_activite = ?
LIMIT
  1

SELECT t0.id_secteur_activite AS id_secteur_activite_1, t0.nom_secteur_activite AS nom_secteur_activite_2, t0.obsolete AS obsolete_3, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4, t0.site_partenaire AS site_partenaire_5, t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6, t0.id_secteur_activite_pere AS id_secteur_activite_pere_7, t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8, t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9, t0.nom_pour_TITLE AS nom_pour_TITLE_10, t0.rare AS rare_11, t0.recherche AS recherche_12, t0.image_filename AS image_filename_13 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = '30805' LIMIT 1;

SELECT
  t0.id_secteur_activite AS id_secteur_activite_1,
  t0.nom_secteur_activite AS nom_secteur_activite_2,
  t0.obsolete AS obsolete_3,
  t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4,
  t0.site_partenaire AS site_partenaire_5,
  t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6,
  t0.id_secteur_activite_pere AS id_secteur_activite_pere_7,
  t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8,
  t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9,
  t0.nom_pour_TITLE AS nom_pour_TITLE_10,
  t0.rare AS rare_11,
  t0.recherche AS recherche_12,
  t0.image_filename AS image_filename_13
FROM
  fusacq_dbo.secteurs_activite t0
WHERE
  t0.id_secteur_activite = ?
LIMIT
  1

SELECT t0.id_secteur_activite AS id_secteur_activite_1, t0.nom_secteur_activite AS nom_secteur_activite_2, t0.obsolete AS obsolete_3, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4, t0.site_partenaire AS site_partenaire_5, t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6, t0.id_secteur_activite_pere AS id_secteur_activite_pere_7, t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8, t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9, t0.nom_pour_TITLE AS nom_pour_TITLE_10, t0.rare AS rare_11, t0.recherche AS recherche_12, t0.image_filename AS image_filename_13 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = '308' LIMIT 1;

SELECT
  t0.id_secteur_activite AS id_secteur_activite_1,
  t0.nom_secteur_activite AS nom_secteur_activite_2,
  t0.obsolete AS obsolete_3,
  t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4,
  t0.site_partenaire AS site_partenaire_5,
  t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6,
  t0.id_secteur_activite_pere AS id_secteur_activite_pere_7,
  t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8,
  t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9,
  t0.nom_pour_TITLE AS nom_pour_TITLE_10,
  t0.rare AS rare_11,
  t0.recherche AS recherche_12,
  t0.image_filename AS image_filename_13
FROM
  fusacq_dbo.secteurs_activite t0
WHERE
  t0.id_secteur_activite = ?
LIMIT
  1

SELECT t0.id_secteur_activite AS id_secteur_activite_1, t0.nom_secteur_activite AS nom_secteur_activite_2, t0.obsolete AS obsolete_3, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4, t0.site_partenaire AS site_partenaire_5, t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6, t0.id_secteur_activite_pere AS id_secteur_activite_pere_7, t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8, t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9, t0.nom_pour_TITLE AS nom_pour_TITLE_10, t0.rare AS rare_11, t0.recherche AS recherche_12, t0.image_filename AS image_filename_13 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = '3' 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 = 'tarif_MER_CV_repreneur_fusacq' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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_relation_mer_offre_1' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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 = 'tarif_pack_mer_5_fusacq' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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_relation_mer_offre_2' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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 = 'tarif_pack_mer_10_fusacq' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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_relation_mer_offre_3' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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 = 'tarif_pack_mer_20_fusacq' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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_relation_mer_offre_abo_annuel_1' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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 = 'tarif_abo_10_MER_mois_fusacq' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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_relation_mer_offre_abo_annuel_2' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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 = 'tarif_abo_20_MER_mois_fusacq' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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_relation_mer_offre_abo_annuel_3' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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 = 'tarif_abo_30_MER_mois_fusacq' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';