Symfony Profiler

SELECT
  t0.id_gestionnaire_fonds AS id_gestionnaire_fonds_1,
  t0.mode AS mode_2,
  t0.nom_societe AS nom_societe_3,
  t0.adresse_societe AS adresse_societe_4,
  t0.code_postal_societe AS code_postal_societe_5,
  t0.ville_societe AS ville_societe_6,
  t0.site_internet AS site_internet_7,
  t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_8,
  t0.nom_contact AS nom_contact_9,
  t0.mail_contact AS mail_contact_10,
  t0.telephone AS telephone_11,
  t0.indicatif AS indicatif_12,
  t0.fax AS fax_13,
  t0.id_pays AS id_pays_14,
  t0.id_region AS id_region_15,
  t0.id_autres_localisations AS id_autres_localisations_16,
  t0.date_mise_a_jour AS date_mise_a_jour_17,
  t0.fichier_joint AS fichier_joint_18,
  t0.strategie_globale_investissement AS strategie_globale_investissement_19,
  t0.login_demande_publication AS login_demande_publication_20,
  t0.date_relance_suivi AS date_relance_suivi_21,
  t0.suivi AS suivi_22,
  t0.societe_active AS societe_active_23,
  t0.type_utilisation AS type_utilisation_24,
  t0.date_relance AS date_relance_25,
  t0.relance_mise_a_jour AS relance_mise_a_jour_26,
  t0.login_resp_tache AS login_resp_tache_27,
  t0.logos AS logos_28,
  t0.date_derniere_MAJ_participations AS date_derniere_MAJ_participations_29,
  t0.id_service_prestataire_associe AS id_service_prestataire_associe_30,
  t0.montant_investissement_min AS montant_investissement_min_31,
  t0.montant_investissement_min_devise AS montant_investissement_min_devise_32,
  t0.montant_investissement_max AS montant_investissement_max_33,
  t0.montant_investissement_max_devise AS montant_investissement_max_devise_34,
  t0.devise AS devise_35,
  t0.taux_change AS taux_change_36,
  t0.type_investissement AS type_investissement_37,
  t0.stade_investissement AS stade_investissement_38,
  t0.etat_fusacq_bot_actu AS etat_fusacq_bot_actu_39,
  t0.suivi_bot_actu AS suivi_bot_actu_40,
  t0.etat_fusacq_bot_part AS etat_fusacq_bot_part_41,
  t0.suivi_bot_part AS suivi_bot_part_42,
  t0.date_relance_respo AS date_relance_respo_43,
  t0.date_valide_respo AS date_valide_respo_44,
  t0.id_secteur_activite AS id_secteur_activite_45,
  t0.mail_respon_maj AS mail_respon_maj_46,
  t0.regions_ciblees AS regions_ciblees_47,
  t0.pays_ciblees AS pays_ciblees_48,
  t0.utiliser_artviper AS utiliser_artviper_49
FROM
  fusacq_dbo.societe_gestionnaire_fonds t0
WHERE
  t0.mode = ?
  AND t0.id_gestionnaire_fonds = ?
LIMIT
  1

SELECT t0.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, t0.mode AS mode_2, t0.nom_societe AS nom_societe_3, t0.adresse_societe AS adresse_societe_4, t0.code_postal_societe AS code_postal_societe_5, t0.ville_societe AS ville_societe_6, t0.site_internet AS site_internet_7, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_8, t0.nom_contact AS nom_contact_9, t0.mail_contact AS mail_contact_10, t0.telephone AS telephone_11, t0.indicatif AS indicatif_12, t0.fax AS fax_13, t0.id_pays AS id_pays_14, t0.id_region AS id_region_15, t0.id_autres_localisations AS id_autres_localisations_16, t0.date_mise_a_jour AS date_mise_a_jour_17, t0.fichier_joint AS fichier_joint_18, t0.strategie_globale_investissement AS strategie_globale_investissement_19, t0.login_demande_publication AS login_demande_publication_20, t0.date_relance_suivi AS date_relance_suivi_21, t0.suivi AS suivi_22, t0.societe_active AS societe_active_23, t0.type_utilisation AS type_utilisation_24, t0.date_relance AS date_relance_25, t0.relance_mise_a_jour AS relance_mise_a_jour_26, t0.login_resp_tache AS login_resp_tache_27, t0.logos AS logos_28, t0.date_derniere_MAJ_participations AS date_derniere_MAJ_participations_29, t0.id_service_prestataire_associe AS id_service_prestataire_associe_30, t0.montant_investissement_min AS montant_investissement_min_31, t0.montant_investissement_min_devise AS montant_investissement_min_devise_32, t0.montant_investissement_max AS montant_investissement_max_33, t0.montant_investissement_max_devise AS montant_investissement_max_devise_34, t0.devise AS devise_35, t0.taux_change AS taux_change_36, t0.type_investissement AS type_investissement_37, t0.stade_investissement AS stade_investissement_38, t0.etat_fusacq_bot_actu AS etat_fusacq_bot_actu_39, t0.suivi_bot_actu AS suivi_bot_actu_40, t0.etat_fusacq_bot_part AS etat_fusacq_bot_part_41, t0.suivi_bot_part AS suivi_bot_part_42, t0.date_relance_respo AS date_relance_respo_43, t0.date_valide_respo AS date_valide_respo_44, t0.id_secteur_activite AS id_secteur_activite_45, t0.mail_respon_maj AS mail_respon_maj_46, t0.regions_ciblees AS regions_ciblees_47, t0.pays_ciblees AS pays_ciblees_48, t0.utiliser_artviper AS utiliser_artviper_49 FROM fusacq_dbo.societe_gestionnaire_fonds t0 WHERE t0.mode = 'publique' AND t0.id_gestionnaire_fonds = '307' LIMIT 1;

SELECT
  b0_.id_actualite AS id_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
  INNER JOIN fusacq_dbo.buzz_roles b1_ ON (
    b0_.id_operation = b1_.id_operation
  )
WHERE
  b1_.id_type_role = 3
  AND b1_.id_acteur = ?
  AND b0_.mode_actualite = 'publique'

SELECT b0_.id_actualite AS id_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b0_.id_operation = b1_.id_operation) WHERE b1_.id_type_role = 3 AND b1_.id_acteur = '307' AND b0_.mode_actualite = 'publique';

SELECT
  b0_.id_actualite AS id_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_fonds_bot = ?
  AND b0_.mode_actualite = 'publique'

SELECT b0_.id_actualite AS id_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_fonds_bot = '307' AND b0_.mode_actualite = 'publique';

SELECT
  s0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_0,
  s0_.nom_societe AS nom_societe_1,
  s0_.nom_contact AS nom_contact_2,
  s0_.id_pays AS id_pays_3,
  s0_.id_region AS id_region_4,
  s0_.adresse_societe AS adresse_societe_5,
  s0_.ville_societe AS ville_societe_6,
  s0_.code_postal_societe AS code_postal_societe_7,
  s0_.telephone AS telephone_8,
  s0_.indicatif AS indicatif_9,
  COUNT(s1_.id_societe) AS sclr_10,
  MAX(l2_.date_investissement) AS sclr_11,
  s0_.site_internet AS site_internet_12,
  s0_.mail_contact AS mail_contact_13
FROM
  fusacq_dbo.societe_gestionnaire_fonds s0_
  INNER JOIN fusacq_dbo.lien_participations_fonds l2_ ON (
    l2_.id_gestionnaire_fonds = s0_.id_gestionnaire_fonds
  )
  INNER JOIN fusacq_dbo.societes s1_ ON (
    s1_.id_societe = l2_.id_participation
  )
WHERE
  s1_.mode_participation = 'publique'
  AND l2_.mode = 'publique'
  AND s0_.mode = 'publique'
  AND s1_.mode_societe = 'publique'
  AND s0_.stade_investissement LIKE '%4%'
  AND (s0_.id_region = ?)
GROUP BY
  s0_.id_gestionnaire_fonds
ORDER BY
  sclr_10 DESC,
  s0_.id_gestionnaire_fonds DESC
LIMIT
  1 OFFSET 76

SELECT s0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_0, s0_.nom_societe AS nom_societe_1, s0_.nom_contact AS nom_contact_2, s0_.id_pays AS id_pays_3, s0_.id_region AS id_region_4, s0_.adresse_societe AS adresse_societe_5, s0_.ville_societe AS ville_societe_6, s0_.code_postal_societe AS code_postal_societe_7, s0_.telephone AS telephone_8, s0_.indicatif AS indicatif_9, COUNT(s1_.id_societe) AS sclr_10, MAX(l2_.date_investissement) AS sclr_11, s0_.site_internet AS site_internet_12, s0_.mail_contact AS mail_contact_13 FROM fusacq_dbo.societe_gestionnaire_fonds s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l2_ ON (l2_.id_gestionnaire_fonds = s0_.id_gestionnaire_fonds) INNER JOIN fusacq_dbo.societes s1_ ON (s1_.id_societe = l2_.id_participation) WHERE s1_.mode_participation = 'publique' AND l2_.mode = 'publique' AND s0_.mode = 'publique' AND s1_.mode_societe = 'publique' AND s0_.stade_investissement LIKE '%4%' AND (s0_.id_region = '33_12') GROUP BY s0_.id_gestionnaire_fonds ORDER BY sclr_10 DESC, s0_.id_gestionnaire_fonds DESC LIMIT 1 OFFSET 76;

SELECT
  s0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_0,
  s0_.nom_societe AS nom_societe_1,
  s0_.nom_contact AS nom_contact_2,
  s0_.id_pays AS id_pays_3,
  s0_.id_region AS id_region_4,
  s0_.adresse_societe AS adresse_societe_5,
  s0_.ville_societe AS ville_societe_6,
  s0_.code_postal_societe AS code_postal_societe_7,
  s0_.telephone AS telephone_8,
  s0_.indicatif AS indicatif_9,
  COUNT(s1_.id_societe) AS sclr_10,
  MAX(l2_.date_investissement) AS sclr_11,
  s0_.site_internet AS site_internet_12,
  s0_.mail_contact AS mail_contact_13
FROM
  fusacq_dbo.societe_gestionnaire_fonds s0_
  INNER JOIN fusacq_dbo.lien_participations_fonds l2_ ON (
    l2_.id_gestionnaire_fonds = s0_.id_gestionnaire_fonds
  )
  INNER JOIN fusacq_dbo.societes s1_ ON (
    s1_.id_societe = l2_.id_participation
  )
WHERE
  s1_.mode_participation = 'publique'
  AND l2_.mode = 'publique'
  AND s0_.mode = 'publique'
  AND s1_.mode_societe = 'publique'
  AND s0_.stade_investissement LIKE '%4%'
  AND (s0_.id_region = ?)
GROUP BY
  s0_.id_gestionnaire_fonds
ORDER BY
  sclr_10 DESC,
  s0_.id_gestionnaire_fonds DESC
LIMIT
  1 OFFSET 78

SELECT s0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_0, s0_.nom_societe AS nom_societe_1, s0_.nom_contact AS nom_contact_2, s0_.id_pays AS id_pays_3, s0_.id_region AS id_region_4, s0_.adresse_societe AS adresse_societe_5, s0_.ville_societe AS ville_societe_6, s0_.code_postal_societe AS code_postal_societe_7, s0_.telephone AS telephone_8, s0_.indicatif AS indicatif_9, COUNT(s1_.id_societe) AS sclr_10, MAX(l2_.date_investissement) AS sclr_11, s0_.site_internet AS site_internet_12, s0_.mail_contact AS mail_contact_13 FROM fusacq_dbo.societe_gestionnaire_fonds s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l2_ ON (l2_.id_gestionnaire_fonds = s0_.id_gestionnaire_fonds) INNER JOIN fusacq_dbo.societes s1_ ON (s1_.id_societe = l2_.id_participation) WHERE s1_.mode_participation = 'publique' AND l2_.mode = 'publique' AND s0_.mode = 'publique' AND s1_.mode_societe = 'publique' AND s0_.stade_investissement LIKE '%4%' AND (s0_.id_region = '33_12') GROUP BY s0_.id_gestionnaire_fonds ORDER BY sclr_10 DESC, s0_.id_gestionnaire_fonds DESC LIMIT 1 OFFSET 78;

SELECT
  COUNT(
    DISTINCT l0_.id_lien_participations_fonds
  ) AS sclr_0
FROM
  fusacq_dbo.societes s1_
  INNER JOIN fusacq_dbo.lien_participations_fonds l0_ ON (
    s1_.id_societe = l0_.id_participation
  )
  INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s2_ ON (
    l0_.id_gestionnaire_fonds = s2_.id_gestionnaire_fonds
  )
WHERE
  l0_.id_gestionnaire_fonds = ?
  AND (
    l0_.mode = 'publique'
    AND s1_.mode_participation = 'publique'
    AND s1_.mode_societe = 'publique'
  )
  AND s2_.mode = 'publique'
  AND (s2_.id_region = ?)

SELECT COUNT(DISTINCT l0_.id_lien_participations_fonds) AS sclr_0 FROM fusacq_dbo.societes s1_ INNER JOIN fusacq_dbo.lien_participations_fonds l0_ ON (s1_.id_societe = l0_.id_participation) INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s2_ ON (l0_.id_gestionnaire_fonds = s2_.id_gestionnaire_fonds) WHERE l0_.id_gestionnaire_fonds = '307' AND (l0_.mode = 'publique' AND s1_.mode_participation = 'publique' AND s1_.mode_societe = 'publique') AND s2_.mode = 'publique' AND (s2_.id_region = '33_12');

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