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 = '308935' LIMIT 1;

SELECT
  a0_.id_repreneur AS id_repreneur_0,
  a0_.login AS login_1,
  a0_.mode_profil AS mode_profil_2,
  a0_.nom AS nom_3,
  a0_.prenom AS prenom_4,
  a0_.adresse AS adresse_5,
  a0_.code_postal AS code_postal_6,
  a0_.ville AS ville_7,
  a0_.id_pays AS id_pays_8,
  a0_.telephone AS telephone_9,
  a0_.indicatif_telephone AS indicatif_telephone_10,
  a0_.email AS email_11,
  a0_.annee_naissance AS annee_naissance_12,
  a0_.description_societe_recherchee AS description_societe_recherchee_13,
  a0_.mots_cles_activite AS mots_cles_activite_14,
  a0_.id_secteur_activite_recherche AS id_secteur_activite_recherche_15,
  a0_.localisations_recherchees AS localisations_recherchees_16,
  a0_.valeur_min_entreprise AS valeur_min_entreprise_17,
  a0_.valeur_max_entreprise AS valeur_max_entreprise_18,
  a0_.montant_apport AS montant_apport_19,
  a0_.formation AS formation_20,
  a0_.parcours_professionnel AS parcours_professionnel_21,
  a0_.competences AS competences_22,
  a0_.competences_recherchees AS competences_recherchees_23,
  a0_.mobile_geographiquement AS mobile_geographiquement_24,
  a0_.commentaires AS commentaires_25,
  a0_.date_mise_a_jour AS date_mise_a_jour_26,
  a0_.visible_annuaire AS visible_annuaire_27,
  a0_.consultable_fp AS consultable_fp_28,
  a0_.consultable_ce AS consultable_ce_29,
  a0_.date_parution AS date_parution_30,
  a0_.date_parution_initiale AS date_parution_initiale_31,
  a0_.date_parution_initiale_complete AS date_parution_initiale_complete_32,
  a0_.relance_mise_a_jour AS relance_mise_a_jour_33,
  a0_.date_relance AS date_relance_34,
  a0_.deja_publique AS deja_publique_35,
  a0_.titre_societe_recherchee AS titre_societe_recherchee_36,
  a0_.id_localisations_recherchees AS id_localisations_recherchees_37,
  a0_.demarche AS demarche_38,
  a0_.complements_demarche AS complements_demarche_39,
  a0_.titre_profil AS titre_profil_40,
  a0_.pourcentage_hauteur_popup AS pourcentage_hauteur_popup_41,
  a0_.publication_newsletter_buzz AS publication_newsletter_buzz_42,
  a0_.mots_cle_recherche AS mots_cle_recherche_43,
  a0_.statut AS statut_44,
  a0_.id_period_annonce_prioritaire AS id_period_annonce_prioritaire_45,
  a0_.etat_annonce_prioritaire AS etat_annonce_prioritaire_46,
  a0_.date_debut_annonce_prioritaire AS date_debut_annonce_prioritaire_47,
  a0_.date_arret_annonce_prioritaire AS date_arret_annonce_prioritaire_48,
  a0_.suivi AS suivi_49,
  a0_.is_international AS is_international_50
FROM
  fusacq_dbo.annuaire_repreneurs a0_
WHERE
  a0_.mode_profil = ?
  AND (
    a0_.id_secteur_activite_recherche LIKE ?
    OR a0_.id_secteur_activite_recherche LIKE ?
    OR a0_.id_secteur_activite_recherche LIKE ?
  )
ORDER BY
  a0_.montant_apport DESC,
  a0_.id_repreneur DESC
LIMIT
  1 OFFSET 4

SELECT a0_.id_repreneur AS id_repreneur_0, a0_.login AS login_1, a0_.mode_profil AS mode_profil_2, a0_.nom AS nom_3, a0_.prenom AS prenom_4, a0_.adresse AS adresse_5, a0_.code_postal AS code_postal_6, a0_.ville AS ville_7, a0_.id_pays AS id_pays_8, a0_.telephone AS telephone_9, a0_.indicatif_telephone AS indicatif_telephone_10, a0_.email AS email_11, a0_.annee_naissance AS annee_naissance_12, a0_.description_societe_recherchee AS description_societe_recherchee_13, a0_.mots_cles_activite AS mots_cles_activite_14, a0_.id_secteur_activite_recherche AS id_secteur_activite_recherche_15, a0_.localisations_recherchees AS localisations_recherchees_16, a0_.valeur_min_entreprise AS valeur_min_entreprise_17, a0_.valeur_max_entreprise AS valeur_max_entreprise_18, a0_.montant_apport AS montant_apport_19, a0_.formation AS formation_20, a0_.parcours_professionnel AS parcours_professionnel_21, a0_.competences AS competences_22, a0_.competences_recherchees AS competences_recherchees_23, a0_.mobile_geographiquement AS mobile_geographiquement_24, a0_.commentaires AS commentaires_25, a0_.date_mise_a_jour AS date_mise_a_jour_26, a0_.visible_annuaire AS visible_annuaire_27, a0_.consultable_fp AS consultable_fp_28, a0_.consultable_ce AS consultable_ce_29, a0_.date_parution AS date_parution_30, a0_.date_parution_initiale AS date_parution_initiale_31, a0_.date_parution_initiale_complete AS date_parution_initiale_complete_32, a0_.relance_mise_a_jour AS relance_mise_a_jour_33, a0_.date_relance AS date_relance_34, a0_.deja_publique AS deja_publique_35, a0_.titre_societe_recherchee AS titre_societe_recherchee_36, a0_.id_localisations_recherchees AS id_localisations_recherchees_37, a0_.demarche AS demarche_38, a0_.complements_demarche AS complements_demarche_39, a0_.titre_profil AS titre_profil_40, a0_.pourcentage_hauteur_popup AS pourcentage_hauteur_popup_41, a0_.publication_newsletter_buzz AS publication_newsletter_buzz_42, a0_.mots_cle_recherche AS mots_cle_recherche_43, a0_.statut AS statut_44, a0_.id_period_annonce_prioritaire AS id_period_annonce_prioritaire_45, a0_.etat_annonce_prioritaire AS etat_annonce_prioritaire_46, a0_.date_debut_annonce_prioritaire AS date_debut_annonce_prioritaire_47, a0_.date_arret_annonce_prioritaire AS date_arret_annonce_prioritaire_48, a0_.suivi AS suivi_49, a0_.is_international AS is_international_50 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = 'publique' AND (a0_.id_secteur_activite_recherche LIKE '%,70302' OR a0_.id_secteur_activite_recherche LIKE '70302,%' OR a0_.id_secteur_activite_recherche LIKE '%,70302,%') ORDER BY a0_.montant_apport DESC, a0_.id_repreneur DESC LIMIT 1 OFFSET 4;

SELECT
  a0_.id_repreneur AS id_repreneur_0,
  a0_.login AS login_1,
  a0_.mode_profil AS mode_profil_2,
  a0_.nom AS nom_3,
  a0_.prenom AS prenom_4,
  a0_.adresse AS adresse_5,
  a0_.code_postal AS code_postal_6,
  a0_.ville AS ville_7,
  a0_.id_pays AS id_pays_8,
  a0_.telephone AS telephone_9,
  a0_.indicatif_telephone AS indicatif_telephone_10,
  a0_.email AS email_11,
  a0_.annee_naissance AS annee_naissance_12,
  a0_.description_societe_recherchee AS description_societe_recherchee_13,
  a0_.mots_cles_activite AS mots_cles_activite_14,
  a0_.id_secteur_activite_recherche AS id_secteur_activite_recherche_15,
  a0_.localisations_recherchees AS localisations_recherchees_16,
  a0_.valeur_min_entreprise AS valeur_min_entreprise_17,
  a0_.valeur_max_entreprise AS valeur_max_entreprise_18,
  a0_.montant_apport AS montant_apport_19,
  a0_.formation AS formation_20,
  a0_.parcours_professionnel AS parcours_professionnel_21,
  a0_.competences AS competences_22,
  a0_.competences_recherchees AS competences_recherchees_23,
  a0_.mobile_geographiquement AS mobile_geographiquement_24,
  a0_.commentaires AS commentaires_25,
  a0_.date_mise_a_jour AS date_mise_a_jour_26,
  a0_.visible_annuaire AS visible_annuaire_27,
  a0_.consultable_fp AS consultable_fp_28,
  a0_.consultable_ce AS consultable_ce_29,
  a0_.date_parution AS date_parution_30,
  a0_.date_parution_initiale AS date_parution_initiale_31,
  a0_.date_parution_initiale_complete AS date_parution_initiale_complete_32,
  a0_.relance_mise_a_jour AS relance_mise_a_jour_33,
  a0_.date_relance AS date_relance_34,
  a0_.deja_publique AS deja_publique_35,
  a0_.titre_societe_recherchee AS titre_societe_recherchee_36,
  a0_.id_localisations_recherchees AS id_localisations_recherchees_37,
  a0_.demarche AS demarche_38,
  a0_.complements_demarche AS complements_demarche_39,
  a0_.titre_profil AS titre_profil_40,
  a0_.pourcentage_hauteur_popup AS pourcentage_hauteur_popup_41,
  a0_.publication_newsletter_buzz AS publication_newsletter_buzz_42,
  a0_.mots_cle_recherche AS mots_cle_recherche_43,
  a0_.statut AS statut_44,
  a0_.id_period_annonce_prioritaire AS id_period_annonce_prioritaire_45,
  a0_.etat_annonce_prioritaire AS etat_annonce_prioritaire_46,
  a0_.date_debut_annonce_prioritaire AS date_debut_annonce_prioritaire_47,
  a0_.date_arret_annonce_prioritaire AS date_arret_annonce_prioritaire_48,
  a0_.suivi AS suivi_49,
  a0_.is_international AS is_international_50
FROM
  fusacq_dbo.annuaire_repreneurs a0_
WHERE
  a0_.mode_profil = ?
  AND (
    a0_.id_secteur_activite_recherche LIKE ?
    OR a0_.id_secteur_activite_recherche LIKE ?
    OR a0_.id_secteur_activite_recherche LIKE ?
  )
ORDER BY
  a0_.montant_apport DESC,
  a0_.id_repreneur DESC
LIMIT
  1 OFFSET 6

SELECT a0_.id_repreneur AS id_repreneur_0, a0_.login AS login_1, a0_.mode_profil AS mode_profil_2, a0_.nom AS nom_3, a0_.prenom AS prenom_4, a0_.adresse AS adresse_5, a0_.code_postal AS code_postal_6, a0_.ville AS ville_7, a0_.id_pays AS id_pays_8, a0_.telephone AS telephone_9, a0_.indicatif_telephone AS indicatif_telephone_10, a0_.email AS email_11, a0_.annee_naissance AS annee_naissance_12, a0_.description_societe_recherchee AS description_societe_recherchee_13, a0_.mots_cles_activite AS mots_cles_activite_14, a0_.id_secteur_activite_recherche AS id_secteur_activite_recherche_15, a0_.localisations_recherchees AS localisations_recherchees_16, a0_.valeur_min_entreprise AS valeur_min_entreprise_17, a0_.valeur_max_entreprise AS valeur_max_entreprise_18, a0_.montant_apport AS montant_apport_19, a0_.formation AS formation_20, a0_.parcours_professionnel AS parcours_professionnel_21, a0_.competences AS competences_22, a0_.competences_recherchees AS competences_recherchees_23, a0_.mobile_geographiquement AS mobile_geographiquement_24, a0_.commentaires AS commentaires_25, a0_.date_mise_a_jour AS date_mise_a_jour_26, a0_.visible_annuaire AS visible_annuaire_27, a0_.consultable_fp AS consultable_fp_28, a0_.consultable_ce AS consultable_ce_29, a0_.date_parution AS date_parution_30, a0_.date_parution_initiale AS date_parution_initiale_31, a0_.date_parution_initiale_complete AS date_parution_initiale_complete_32, a0_.relance_mise_a_jour AS relance_mise_a_jour_33, a0_.date_relance AS date_relance_34, a0_.deja_publique AS deja_publique_35, a0_.titre_societe_recherchee AS titre_societe_recherchee_36, a0_.id_localisations_recherchees AS id_localisations_recherchees_37, a0_.demarche AS demarche_38, a0_.complements_demarche AS complements_demarche_39, a0_.titre_profil AS titre_profil_40, a0_.pourcentage_hauteur_popup AS pourcentage_hauteur_popup_41, a0_.publication_newsletter_buzz AS publication_newsletter_buzz_42, a0_.mots_cle_recherche AS mots_cle_recherche_43, a0_.statut AS statut_44, a0_.id_period_annonce_prioritaire AS id_period_annonce_prioritaire_45, a0_.etat_annonce_prioritaire AS etat_annonce_prioritaire_46, a0_.date_debut_annonce_prioritaire AS date_debut_annonce_prioritaire_47, a0_.date_arret_annonce_prioritaire AS date_arret_annonce_prioritaire_48, a0_.suivi AS suivi_49, a0_.is_international AS is_international_50 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = 'publique' AND (a0_.id_secteur_activite_recherche LIKE '%,70302' OR a0_.id_secteur_activite_recherche LIKE '70302,%' OR a0_.id_secteur_activite_recherche LIKE '%,70302,%') ORDER BY a0_.montant_apport DESC, a0_.id_repreneur DESC LIMIT 1 OFFSET 6;

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 = 308935 LIMIT 1;