Symfony Profiler

SELECT
  s0_.id_secteur_activite AS id_secteur_activite_0,
  s0_.nom_secteur_activite AS nom_secteur_activite_1
FROM
  fusacq_dbo.secteurs_activite s0_
WHERE
  s0_.id_secteur_activite_pere = 0
  AND (
    s0_.obsolete <> ?
    OR s0_.obsolete IS NULL
  )
ORDER BY
  s0_.nom_secteur_activite ASC

SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.nom_secteur_activite AS nom_secteur_activite_1 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite_pere = 0 AND (s0_.obsolete <> 'oui' OR s0_.obsolete IS NULL) ORDER BY s0_.nom_secteur_activite ASC;

SELECT
  s0_.id_secteur_activite AS id_secteur_activite_0,
  s0_.nom_secteur_activite AS nom_secteur_activite_1
FROM
  fusacq_dbo.secteurs_activite s0_
WHERE
  s0_.id_secteur_activite_pere = 0
  AND (
    s0_.obsolete <> ?
    OR s0_.obsolete IS NULL
  )
ORDER BY
  s0_.nom_secteur_activite ASC

SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.nom_secteur_activite AS nom_secteur_activite_1 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite_pere = 0 AND (s0_.obsolete <> 'oui' OR s0_.obsolete IS NULL) ORDER BY s0_.nom_secteur_activite ASC;

SELECT
  COUNT(DISTINCT a0_.id_repreneur) AS sclr_0
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 ?
  )

SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = 'publique' AND (a0_.id_secteur_activite_recherche LIKE '%,30903' OR a0_.id_secteur_activite_recherche LIKE '30903,%' OR a0_.id_secteur_activite_recherche LIKE '%,30903,%');

SELECT
  DISTINCT a0_.id_repreneur AS id_repreneur_0,
  a0_.montant_apport AS montant_apport_1,
  a0_.id_repreneur AS id_repreneur_2
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
  10

SELECT DISTINCT a0_.id_repreneur AS id_repreneur_0, a0_.montant_apport AS montant_apport_1, a0_.id_repreneur AS id_repreneur_2 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = 'publique' AND (a0_.id_secteur_activite_recherche LIKE '%,30903' OR a0_.id_secteur_activite_recherche LIKE '30903,%' OR a0_.id_secteur_activite_recherche LIKE '%,30903,%') ORDER BY a0_.montant_apport DESC, a0_.id_repreneur DESC LIMIT 10;

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 ?
  )
  AND a0_.id_repreneur IN (?)
ORDER BY
  a0_.montant_apport DESC,
  a0_.id_repreneur DESC

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 '%,30903' OR a0_.id_secteur_activite_recherche LIKE '30903,%' OR a0_.id_secteur_activite_recherche LIKE '%,30903,%') AND a0_.id_repreneur IN (305870) ORDER BY a0_.montant_apport DESC, a0_.id_repreneur DESC;

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_
  LEFT JOIN fusacq_dbo.periodes_annonce_prioritaire p1_ ON (
    a0_.id_period_annonce_prioritaire = p1_.id_period_annonce_prioritaire
  )
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 ?
  )
  AND (
    a0_.id_period_annonce_prioritaire <> 0
  )
  AND (
    NULLIF(
      a0_.id_period_annonce_prioritaire,
      ''
    ) IS NOT NULL
  )
  AND (
    a0_.etat_annonce_prioritaire = 'active'
  )
  AND (p1_.etat = 'active')
ORDER BY
  a0_.date_debut_annonce_prioritaire DESC,
  a0_.id_repreneur DESC

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_ LEFT JOIN fusacq_dbo.periodes_annonce_prioritaire p1_ ON (a0_.id_period_annonce_prioritaire = p1_.id_period_annonce_prioritaire) WHERE a0_.mode_profil = 'publique' AND (a0_.id_secteur_activite_recherche LIKE '%,30903' OR a0_.id_secteur_activite_recherche LIKE '30903,%' OR a0_.id_secteur_activite_recherche LIKE '%,30903,%') AND (a0_.id_period_annonce_prioritaire <> 0) AND (NULLIF(a0_.id_period_annonce_prioritaire, '') IS NOT NULL) AND (a0_.etat_annonce_prioritaire = 'active') AND (p1_.etat = 'active') ORDER BY a0_.date_debut_annonce_prioritaire DESC, a0_.id_repreneur DESC;