Symfony Profiler

SELECT
  DISTINCT (s0_.id_service_prestataire) AS sclr_0,
  s0_.id_localisation_prestataire AS id_localisation_prestataire_1,
  s0_.titre_service AS titre_service_2,
  s0_.id_societe_prestataire AS id_societe_prestataire_3,
  s0_.nom_commercial_societe AS nom_commercial_societe_4,
  s0_.id_pays AS id_pays_5,
  s0_.date_mise_en_ligne AS date_mise_en_ligne_6,
  s0_.statut AS statut_7,
  s0_.resume_service AS resume_service_8,
  s0_.description_service AS description_service_9,
  s0_.url_site_web_visible AS url_site_web_visible_10,
  s0_.url_site_web AS url_site_web_11,
  s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_12,
  s0_.utiliser_artviper AS utiliser_artviper_13,
  s0_.id_secteur_new AS id_secteur_new_14,
  c1_.code_postal AS code_postal_15,
  c1_.adresse AS adresse_16,
  c1_.ville AS ville_17,
  c1_.pays AS pays_18,
  c1_.nom_contact1 AS nom_contact1_19,
  c1_.email_contact1 AS email_contact1_20,
  c1_.nom_contact2 AS nom_contact2_21,
  c1_.email_contact2 AS email_contact2_22,
  c1_.telephone AS telephone_23,
  c1_.indicatif_telephone AS indicatif_telephone_24,
  c1_.telephone_contact1 AS telephone_contact1_25,
  c1_.indicatif_telephone_contact1 AS indicatif_telephone_contact1_26,
  c1_.telephone_contact2 AS telephone_contact2_27,
  c1_.indicatif_telephone_contact2 AS indicatif_telephone_contact2_28
FROM
  fusacq_dbo.services_prestataire s0_
  LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (
    s0_.id_secteur_new = s2_.pointe_vers
  )
  LEFT JOIN localisations_prestataire l3_ ON (
    s0_.id_localisation_prestataire = l3_.id_localisation_prestataire
  )
  LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (
    s0_.id_service_prestataire = c1_.id_service_prestataire
  )
WHERE
  s0_.id_service_prestataire = ?
LIMIT
  1

SELECT DISTINCT (s0_.id_service_prestataire) AS sclr_0, s0_.id_localisation_prestataire AS id_localisation_prestataire_1, s0_.titre_service AS titre_service_2, s0_.id_societe_prestataire AS id_societe_prestataire_3, s0_.nom_commercial_societe AS nom_commercial_societe_4, s0_.id_pays AS id_pays_5, s0_.date_mise_en_ligne AS date_mise_en_ligne_6, s0_.statut AS statut_7, s0_.resume_service AS resume_service_8, s0_.description_service AS description_service_9, s0_.url_site_web_visible AS url_site_web_visible_10, s0_.url_site_web AS url_site_web_11, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_12, s0_.utiliser_artviper AS utiliser_artviper_13, s0_.id_secteur_new AS id_secteur_new_14, c1_.code_postal AS code_postal_15, c1_.adresse AS adresse_16, c1_.ville AS ville_17, c1_.pays AS pays_18, c1_.nom_contact1 AS nom_contact1_19, c1_.email_contact1 AS email_contact1_20, c1_.nom_contact2 AS nom_contact2_21, c1_.email_contact2 AS email_contact2_22, c1_.telephone AS telephone_23, c1_.indicatif_telephone AS indicatif_telephone_24, c1_.telephone_contact1 AS telephone_contact1_25, c1_.indicatif_telephone_contact1 AS indicatif_telephone_contact1_26, c1_.telephone_contact2 AS telephone_contact2_27, c1_.indicatif_telephone_contact2 AS indicatif_telephone_contact2_28 FROM fusacq_dbo.services_prestataire s0_ LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (s0_.id_secteur_new = s2_.pointe_vers) LEFT JOIN localisations_prestataire l3_ ON (s0_.id_localisation_prestataire = l3_.id_localisation_prestataire) LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (s0_.id_service_prestataire = c1_.id_service_prestataire) WHERE s0_.id_service_prestataire = 1732 LIMIT 1;

SELECT
  c0_.id_certification_expert AS id_certification_expert_0,
  c0_.id_societe_prestataire AS id_societe_prestataire_1,
  c0_.valeur_certification AS valeur_certification_2,
  t1_.nom_certification AS nom_certification_3,
  t1_.nom_affichage_certification AS nom_affichage_certification_4,
  t1_.legende AS legende_5
FROM
  fusacq_dbo.certification_expert c0_
  LEFT JOIN fusacq_dbo.type_certification_expert t1_ ON (
    c0_.id_type_certification = t1_.id_type_certification
  )
WHERE
  c0_.id_societe_prestataire = ?

SELECT c0_.id_certification_expert AS id_certification_expert_0, c0_.id_societe_prestataire AS id_societe_prestataire_1, c0_.valeur_certification AS valeur_certification_2, t1_.nom_certification AS nom_certification_3, t1_.nom_affichage_certification AS nom_affichage_certification_4, t1_.legende AS legende_5 FROM fusacq_dbo.certification_expert c0_ LEFT JOIN fusacq_dbo.type_certification_expert t1_ ON (c0_.id_type_certification = t1_.id_type_certification) WHERE c0_.id_societe_prestataire = 2420;

SELECT
  l0_.id_service_prestataire AS id_service_prestataire_0,
  l0_.id_membre AS id_membre_1,
  l0_.id_lien AS id_lien_2,
  e1_.prenom AS prenom_3,
  e1_.nom AS nom_4,
  e1_.fonction AS fonction_5,
  e1_.photo AS photo_6,
  e1_.parcours AS parcours_7,
  e1_.reecriture_url AS reecriture_url_8,
  l0_.ordre AS ordre_9,
  e1_.genre AS genre_10
FROM
  fusacq_dbo.liens_equipes_services_prestataire l0_
  LEFT JOIN fusacq_dbo.equipes_prestataire e1_ ON (l0_.id_membre = e1_.id_membre)
WHERE
  e1_.id_societe_prestataire = ?
  AND l0_.id_service_prestataire = ?
  AND e1_.mode_equipe = ?
ORDER BY
  l0_.ordre ASC
LIMIT
  10000

SELECT l0_.id_service_prestataire AS id_service_prestataire_0, l0_.id_membre AS id_membre_1, l0_.id_lien AS id_lien_2, e1_.prenom AS prenom_3, e1_.nom AS nom_4, e1_.fonction AS fonction_5, e1_.photo AS photo_6, e1_.parcours AS parcours_7, e1_.reecriture_url AS reecriture_url_8, l0_.ordre AS ordre_9, e1_.genre AS genre_10 FROM fusacq_dbo.liens_equipes_services_prestataire l0_ LEFT JOIN fusacq_dbo.equipes_prestataire e1_ ON (l0_.id_membre = e1_.id_membre) WHERE e1_.id_societe_prestataire = 2420 AND l0_.id_service_prestataire = 1732 AND e1_.mode_equipe = 'publique' ORDER BY l0_.ordre ASC LIMIT 10000;

SELECT
  DISTINCT (b0_.id_actualite) AS sclr_0,
  b1_.titre_actualite AS titre_actualite_1,
  b1_.mode_actualite AS mode_actualite_2,
  b1_.titre_actualite AS titre_actualite_3,
  b1_.description_actualite AS description_actualite_4,
  b1_.date_mise_en_ligne AS date_mise_en_ligne_5,
  b1_.date_creation AS date_creation_6,
  b1_.date_reception AS date_reception_7,
  b1_.date_evenement AS date_evenement_8,
  b1_.id_message_blog AS id_message_blog_9
FROM
  fusacq_dbo.buzz_liens_actualites_blog_prestations_equipes b0_
  LEFT JOIN fusacq_dbo.buzz_actualites b1_ ON (
    b0_.id_actualite = b1_.id_actualite
  )
  LEFT JOIN fusacq_dbo.reseaux r2_ ON (b1_.id_reseau = r2_.id_reseau)
WHERE
  (
    b0_.id_service_prestataire = 1732
    AND b1_.id_societe_prestataire = 2420
    AND b1_.provenance_flux_actualite = 'blog'
    AND b1_.mode_actualite = 'publique'
    AND b1_.date_mise_en_ligne < 20260414103130
  )
  OR r2_.id_service_prestataire = 1732
ORDER BY
  b1_.date_mise_en_ligne DESC

SELECT DISTINCT (b0_.id_actualite) AS sclr_0, b1_.titre_actualite AS titre_actualite_1, b1_.mode_actualite AS mode_actualite_2, b1_.titre_actualite AS titre_actualite_3, b1_.description_actualite AS description_actualite_4, b1_.date_mise_en_ligne AS date_mise_en_ligne_5, b1_.date_creation AS date_creation_6, b1_.date_reception AS date_reception_7, b1_.date_evenement AS date_evenement_8, b1_.id_message_blog AS id_message_blog_9 FROM fusacq_dbo.buzz_liens_actualites_blog_prestations_equipes b0_ LEFT JOIN fusacq_dbo.buzz_actualites b1_ ON (b0_.id_actualite = b1_.id_actualite) LEFT JOIN fusacq_dbo.reseaux r2_ ON (b1_.id_reseau = r2_.id_reseau) WHERE (b0_.id_service_prestataire = 1732 AND b1_.id_societe_prestataire = 2420 AND b1_.provenance_flux_actualite = 'blog' AND b1_.mode_actualite = 'publique' AND b1_.date_mise_en_ligne < 20260414103130) OR r2_.id_service_prestataire = 1732 ORDER BY b1_.date_mise_en_ligne DESC;

SELECT
  e0_.id_membre AS id_membre_0,
  s1_.raison_sociale AS raison_sociale_1,
  s1_.adresse AS adresse_2,
  s1_.code_postal AS code_postal_3,
  s1_.ville AS ville_4,
  s1_.pays AS pays_5,
  s1_.telephone AS telephone_6,
  e0_.prenom AS prenom_7,
  e0_.nom AS nom_8,
  e0_.fonction AS fonction_9,
  e0_.photo AS photo_10,
  e0_.parcours AS parcours_11,
  e0_.reecriture_url AS reecriture_url_12,
  e0_.genre AS genre_13
FROM
  fusacq_dbo.equipes_prestataire e0_
  LEFT JOIN fusacq_dbo.societes_prestataire s1_ ON (
    e0_.id_societe_prestataire = s1_.id_societe_prestataire
  )
WHERE
  e0_.id_membre = ?
  AND e0_.mode_equipe = ?
LIMIT
  1

SELECT e0_.id_membre AS id_membre_0, s1_.raison_sociale AS raison_sociale_1, s1_.adresse AS adresse_2, s1_.code_postal AS code_postal_3, s1_.ville AS ville_4, s1_.pays AS pays_5, s1_.telephone AS telephone_6, e0_.prenom AS prenom_7, e0_.nom AS nom_8, e0_.fonction AS fonction_9, e0_.photo AS photo_10, e0_.parcours AS parcours_11, e0_.reecriture_url AS reecriture_url_12, e0_.genre AS genre_13 FROM fusacq_dbo.equipes_prestataire e0_ LEFT JOIN fusacq_dbo.societes_prestataire s1_ ON (e0_.id_societe_prestataire = s1_.id_societe_prestataire) WHERE e0_.id_membre = 2561 AND e0_.mode_equipe = 'publique' LIMIT 1;

SELECT
  DISTINCT b0_.id_role AS id_role_0,
  b0_.id_type_role AS id_type_role_1,
  b1_.nom_role AS nom_role_2,
  b2_.id_operation AS id_operation_3,
  b0_.id_acteur AS id_acteur_4,
  b3_.id_actualite AS id_actualite_5,
  b3_.date_mise_en_ligne AS date_mise_en_ligne_6,
  b3_.titre_actualite AS titre_actualite_7
FROM
  fusacq_dbo.buzz_roles b0_
  LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (
    b0_.id_operation = b2_.id_operation
  )
  LEFT JOIN fusacq_dbo.buzz_actualites b3_ ON (
    b2_.id_actualite_principale = b3_.id_actualite
  )
  LEFT JOIN fusacq_dbo.buzz_types_roles b1_ ON (
    b1_.id_type_role = b0_.id_type_role
  )
WHERE
  b3_.mode_actualite = ?
  AND b0_.id_membre = ?
  AND b0_.table_sql_acteur = ?
GROUP BY
  b3_.date_mise_en_ligne
ORDER BY
  b3_.date_mise_en_ligne DESC

SELECT DISTINCT b0_.id_role AS id_role_0, b0_.id_type_role AS id_type_role_1, b1_.nom_role AS nom_role_2, b2_.id_operation AS id_operation_3, b0_.id_acteur AS id_acteur_4, b3_.id_actualite AS id_actualite_5, b3_.date_mise_en_ligne AS date_mise_en_ligne_6, b3_.titre_actualite AS titre_actualite_7 FROM fusacq_dbo.buzz_roles b0_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b0_.id_operation = b2_.id_operation) LEFT JOIN fusacq_dbo.buzz_actualites b3_ ON (b2_.id_actualite_principale = b3_.id_actualite) LEFT JOIN fusacq_dbo.buzz_types_roles b1_ ON (b1_.id_type_role = b0_.id_type_role) WHERE b3_.mode_actualite = 'publique' AND b0_.id_membre = 2561 AND b0_.table_sql_acteur = 'services_prestataire' GROUP BY b3_.date_mise_en_ligne ORDER BY b3_.date_mise_en_ligne DESC;

SELECT
  DISTINCT 0 AS sclr_0,
  0 AS sclr_1,
  0 AS sclr_2,
  b0_.id_actualite AS id_actualite_3,
  0 AS sclr_4,
  b1_.date_mise_en_ligne AS date_mise_en_ligne_5,
  b1_.titre_actualite AS titre_actualite_6
FROM
  fusacq_dbo.buzz_liens_actualites_blog_prestations_equipes b0_
  INNER JOIN fusacq_dbo.buzz_actualites b1_ ON (
    b0_.id_actualite = b1_.id_actualite
  )
WHERE
  b0_.id_membre = ?
  AND b1_.mode_actualite = ?
  AND b1_.type_actualite NOT LIKE ?
ORDER BY
  b1_.date_mise_en_ligne DESC

SELECT DISTINCT 0 AS sclr_0, 0 AS sclr_1, 0 AS sclr_2, b0_.id_actualite AS id_actualite_3, 0 AS sclr_4, b1_.date_mise_en_ligne AS date_mise_en_ligne_5, b1_.titre_actualite AS titre_actualite_6 FROM fusacq_dbo.buzz_liens_actualites_blog_prestations_equipes b0_ INNER JOIN fusacq_dbo.buzz_actualites b1_ ON (b0_.id_actualite = b1_.id_actualite) WHERE b0_.id_membre = 2561 AND b1_.mode_actualite = 'publique' AND b1_.type_actualite NOT LIKE 'reference' ORDER BY b1_.date_mise_en_ligne DESC;

SELECT
  DISTINCT (s0_.id_service_prestataire) AS sclr_0,
  s0_.id_localisation_prestataire AS id_localisation_prestataire_1,
  s0_.titre_service AS titre_service_2,
  s0_.nom_commercial_societe AS nom_commercial_societe_3,
  s0_.date_mise_en_ligne AS date_mise_en_ligne_4,
  s0_.resume_service AS resume_service_5,
  s0_.url_site_web AS url_site_web_6,
  s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7,
  s0_.utiliser_artviper AS utiliser_artviper_8,
  c1_.code_postal AS code_postal_9,
  c1_.ville AS ville_10,
  c1_.nom_contact1 AS nom_contact1_11
FROM
  fusacq_dbo.services_prestataire s0_
  LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (
    s0_.id_secteur_new = s2_.pointe_vers
  )
  LEFT JOIN localisations_prestataire l3_ ON (
    s0_.id_localisation_prestataire = l3_.id_localisation_prestataire
  )
  LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (
    s0_.id_service_prestataire = c1_.id_service_prestataire
  )
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'
ORDER BY
  s0_.date_mise_en_ligne DESC,
  s0_.id_service_prestataire DESC
LIMIT
  3

SELECT DISTINCT (s0_.id_service_prestataire) AS sclr_0, s0_.id_localisation_prestataire AS id_localisation_prestataire_1, s0_.titre_service AS titre_service_2, s0_.nom_commercial_societe AS nom_commercial_societe_3, s0_.date_mise_en_ligne AS date_mise_en_ligne_4, s0_.resume_service AS resume_service_5, s0_.url_site_web AS url_site_web_6, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7, s0_.utiliser_artviper AS utiliser_artviper_8, c1_.code_postal AS code_postal_9, c1_.ville AS ville_10, c1_.nom_contact1 AS nom_contact1_11 FROM fusacq_dbo.services_prestataire s0_ LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (s0_.id_secteur_new = s2_.pointe_vers) LEFT JOIN localisations_prestataire l3_ ON (s0_.id_localisation_prestataire = l3_.id_localisation_prestataire) LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (s0_.id_service_prestataire = c1_.id_service_prestataire) WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%' ORDER BY s0_.date_mise_en_ligne DESC, s0_.id_service_prestataire DESC LIMIT 3;

SELECT
  DISTINCT (s0_.id_service_prestataire) AS sclr_0,
  s0_.id_localisation_prestataire AS id_localisation_prestataire_1,
  s0_.titre_service AS titre_service_2,
  s0_.nom_commercial_societe AS nom_commercial_societe_3,
  s0_.date_mise_en_ligne AS date_mise_en_ligne_4,
  s0_.resume_service AS resume_service_5,
  s0_.url_site_web AS url_site_web_6,
  s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7,
  s0_.utiliser_artviper AS utiliser_artviper_8,
  c1_.code_postal AS code_postal_9,
  c1_.ville AS ville_10,
  c1_.nom_contact1 AS nom_contact1_11
FROM
  fusacq_dbo.services_prestataire s0_
  LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (
    s0_.id_secteur_new = s2_.pointe_vers
  )
  LEFT JOIN localisations_prestataire l3_ ON (
    s0_.id_localisation_prestataire = l3_.id_localisation_prestataire
  )
  LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (
    s0_.id_service_prestataire = c1_.id_service_prestataire
  )
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'
ORDER BY
  s0_.date_mise_en_ligne DESC,
  s0_.id_service_prestataire DESC
LIMIT
  3

SELECT DISTINCT (s0_.id_service_prestataire) AS sclr_0, s0_.id_localisation_prestataire AS id_localisation_prestataire_1, s0_.titre_service AS titre_service_2, s0_.nom_commercial_societe AS nom_commercial_societe_3, s0_.date_mise_en_ligne AS date_mise_en_ligne_4, s0_.resume_service AS resume_service_5, s0_.url_site_web AS url_site_web_6, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7, s0_.utiliser_artviper AS utiliser_artviper_8, c1_.code_postal AS code_postal_9, c1_.ville AS ville_10, c1_.nom_contact1 AS nom_contact1_11 FROM fusacq_dbo.services_prestataire s0_ LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (s0_.id_secteur_new = s2_.pointe_vers) LEFT JOIN localisations_prestataire l3_ ON (s0_.id_localisation_prestataire = l3_.id_localisation_prestataire) LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (s0_.id_service_prestataire = c1_.id_service_prestataire) WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%' ORDER BY s0_.date_mise_en_ligne DESC, s0_.id_service_prestataire DESC LIMIT 3;

SELECT
  s0_.id_service_prestataire AS id_service_prestataire_0
FROM
  fusacq_dbo.services_prestataire s0_
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'

SELECT s0_.id_service_prestataire AS id_service_prestataire_0 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%';

SELECT
  s0_.id_service_prestataire AS id_service_prestataire_0
FROM
  fusacq_dbo.services_prestataire s0_
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'

SELECT s0_.id_service_prestataire AS id_service_prestataire_0 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%';

SELECT
  DISTINCT (s0_.id_service_prestataire) AS sclr_0,
  s0_.id_localisation_prestataire AS id_localisation_prestataire_1,
  s0_.titre_service AS titre_service_2,
  s0_.id_societe_prestataire AS id_societe_prestataire_3,
  s0_.nom_commercial_societe AS nom_commercial_societe_4,
  s0_.id_pays AS id_pays_5,
  s0_.date_mise_en_ligne AS date_mise_en_ligne_6,
  s0_.statut AS statut_7,
  s0_.resume_service AS resume_service_8,
  s0_.description_service AS description_service_9,
  s0_.url_site_web_visible AS url_site_web_visible_10,
  s0_.url_site_web AS url_site_web_11,
  s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_12,
  s0_.utiliser_artviper AS utiliser_artviper_13,
  s0_.id_secteur_new AS id_secteur_new_14,
  c1_.code_postal AS code_postal_15,
  c1_.adresse AS adresse_16,
  c1_.ville AS ville_17,
  c1_.pays AS pays_18,
  c1_.nom_contact1 AS nom_contact1_19,
  c1_.email_contact1 AS email_contact1_20,
  c1_.nom_contact2 AS nom_contact2_21,
  c1_.email_contact2 AS email_contact2_22,
  c1_.telephone AS telephone_23,
  c1_.indicatif_telephone AS indicatif_telephone_24,
  c1_.telephone_contact1 AS telephone_contact1_25,
  c1_.indicatif_telephone_contact1 AS indicatif_telephone_contact1_26,
  c1_.telephone_contact2 AS telephone_contact2_27,
  c1_.indicatif_telephone_contact2 AS indicatif_telephone_contact2_28
FROM
  fusacq_dbo.services_prestataire s0_
  LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (
    s0_.id_secteur_new = s2_.pointe_vers
  )
  LEFT JOIN localisations_prestataire l3_ ON (
    s0_.id_localisation_prestataire = l3_.id_localisation_prestataire
  )
  LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (
    s0_.id_service_prestataire = c1_.id_service_prestataire
  )
WHERE
  s0_.id_service_prestataire = ?
LIMIT
  1

SELECT DISTINCT (s0_.id_service_prestataire) AS sclr_0, s0_.id_localisation_prestataire AS id_localisation_prestataire_1, s0_.titre_service AS titre_service_2, s0_.id_societe_prestataire AS id_societe_prestataire_3, s0_.nom_commercial_societe AS nom_commercial_societe_4, s0_.id_pays AS id_pays_5, s0_.date_mise_en_ligne AS date_mise_en_ligne_6, s0_.statut AS statut_7, s0_.resume_service AS resume_service_8, s0_.description_service AS description_service_9, s0_.url_site_web_visible AS url_site_web_visible_10, s0_.url_site_web AS url_site_web_11, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_12, s0_.utiliser_artviper AS utiliser_artviper_13, s0_.id_secteur_new AS id_secteur_new_14, c1_.code_postal AS code_postal_15, c1_.adresse AS adresse_16, c1_.ville AS ville_17, c1_.pays AS pays_18, c1_.nom_contact1 AS nom_contact1_19, c1_.email_contact1 AS email_contact1_20, c1_.nom_contact2 AS nom_contact2_21, c1_.email_contact2 AS email_contact2_22, c1_.telephone AS telephone_23, c1_.indicatif_telephone AS indicatif_telephone_24, c1_.telephone_contact1 AS telephone_contact1_25, c1_.indicatif_telephone_contact1 AS indicatif_telephone_contact1_26, c1_.telephone_contact2 AS telephone_contact2_27, c1_.indicatif_telephone_contact2 AS indicatif_telephone_contact2_28 FROM fusacq_dbo.services_prestataire s0_ LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (s0_.id_secteur_new = s2_.pointe_vers) LEFT JOIN localisations_prestataire l3_ ON (s0_.id_localisation_prestataire = l3_.id_localisation_prestataire) LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (s0_.id_service_prestataire = c1_.id_service_prestataire) WHERE s0_.id_service_prestataire = 1732 LIMIT 1;

SELECT
  c0_.id_certification_expert AS id_certification_expert_0,
  c0_.id_societe_prestataire AS id_societe_prestataire_1,
  c0_.valeur_certification AS valeur_certification_2,
  t1_.nom_certification AS nom_certification_3,
  t1_.nom_affichage_certification AS nom_affichage_certification_4,
  t1_.legende AS legende_5
FROM
  fusacq_dbo.certification_expert c0_
  LEFT JOIN fusacq_dbo.type_certification_expert t1_ ON (
    c0_.id_type_certification = t1_.id_type_certification
  )
WHERE
  c0_.id_societe_prestataire = ?

SELECT c0_.id_certification_expert AS id_certification_expert_0, c0_.id_societe_prestataire AS id_societe_prestataire_1, c0_.valeur_certification AS valeur_certification_2, t1_.nom_certification AS nom_certification_3, t1_.nom_affichage_certification AS nom_affichage_certification_4, t1_.legende AS legende_5 FROM fusacq_dbo.certification_expert c0_ LEFT JOIN fusacq_dbo.type_certification_expert t1_ ON (c0_.id_type_certification = t1_.id_type_certification) WHERE c0_.id_societe_prestataire = 2420;

SELECT
  e0_.prenom AS prenom_0,
  e0_.nom AS nom_1
FROM
  fusacq_dbo.equipes_prestataire e0_
  LEFT JOIN fusacq_dbo.societes_prestataire s1_ ON (
    e0_.id_societe_prestataire = s1_.id_societe_prestataire
  )
WHERE
  e0_.id_membre = ?
  AND e0_.mode_equipe = ?
LIMIT
  1

SELECT e0_.prenom AS prenom_0, e0_.nom AS nom_1 FROM fusacq_dbo.equipes_prestataire e0_ LEFT JOIN fusacq_dbo.societes_prestataire s1_ ON (e0_.id_societe_prestataire = s1_.id_societe_prestataire) WHERE e0_.id_membre = 2561 AND e0_.mode_equipe = 'publique' LIMIT 1;

SELECT
  s0_.id_secteur_new AS id_secteur_new_0
FROM
  fusacq_dbo.services_prestataire s0_
WHERE
  s0_.id_service_prestataire = ?
LIMIT
  1

SELECT s0_.id_secteur_new AS id_secteur_new_0 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = 1732 LIMIT 1;

SELECT
  s0_.id_secteur_activite AS id_secteur_activite_0,
  s0_.chemin_secteurs_peres AS chemin_secteurs_peres_1
FROM
  fusacq_dbo.secteurs_activite_prestataire_new s0_
WHERE
  s0_.pointe_vers = ?
ORDER BY
  s0_.id_secteur_activite ASC

SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.chemin_secteurs_peres AS chemin_secteurs_peres_1 FROM fusacq_dbo.secteurs_activite_prestataire_new s0_ WHERE s0_.pointe_vers = 189 ORDER BY s0_.id_secteur_activite ASC;

SELECT
  s0_.nom_secteur_activite AS nom_secteur_activite_0,
  s0_.id_secteur_activite AS id_secteur_activite_1,
  s0_.id_secteur_activite_pere AS id_secteur_activite_pere_2,
  s1_.nom_secteur_activite AS nom_secteur_activite_3,
  (
    SELECT
      s2_.nom_secteur_activite
    FROM
      fusacq_dbo.secteurs_activite_prestataire_new s2_
    WHERE
      s2_.id_secteur_activite = ?
  ) AS sclr_4
FROM
  fusacq_dbo.secteurs_activite_prestataire_new s0_
  LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s1_ ON (
    s0_.id_secteur_activite_pere = s1_.id_secteur_activite
  )
WHERE
  s0_.id_secteur_activite IN (
    SELECT
      s3_.id_secteur_activite_pere
    FROM
      fusacq_dbo.secteurs_activite_prestataire_new s3_
    WHERE
      s3_.id_secteur_activite IN (?)
  )

SELECT s0_.nom_secteur_activite AS nom_secteur_activite_0, s0_.id_secteur_activite AS id_secteur_activite_1, s0_.id_secteur_activite_pere AS id_secteur_activite_pere_2, s1_.nom_secteur_activite AS nom_secteur_activite_3, (SELECT s2_.nom_secteur_activite FROM fusacq_dbo.secteurs_activite_prestataire_new s2_ WHERE s2_.id_secteur_activite = '259,273') AS sclr_4 FROM fusacq_dbo.secteurs_activite_prestataire_new s0_ LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s1_ ON (s0_.id_secteur_activite_pere = s1_.id_secteur_activite) WHERE s0_.id_secteur_activite IN (SELECT s3_.id_secteur_activite_pere FROM fusacq_dbo.secteurs_activite_prestataire_new s3_ WHERE s3_.id_secteur_activite IN ('259,273'));

SELECT
  s0_.id_secteur_new AS id_secteur_new_0
FROM
  fusacq_dbo.services_prestataire s0_
WHERE
  s0_.id_service_prestataire = ?
LIMIT
  1

SELECT s0_.id_secteur_new AS id_secteur_new_0 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = 1732 LIMIT 1;

SELECT
  s0_.nom_secteur_activite AS nom_secteur_activite_0,
  s0_.id_secteur_activite AS id_secteur_activite_1,
  s0_.id_secteur_activite_pere AS id_secteur_activite_pere_2
FROM
  fusacq_dbo.secteurs_activite_prestataire_new s0_
WHERE
  s0_.pointe_vers IN (189)
LIMIT
  1

SELECT s0_.nom_secteur_activite AS nom_secteur_activite_0, s0_.id_secteur_activite AS id_secteur_activite_1, s0_.id_secteur_activite_pere AS id_secteur_activite_pere_2 FROM fusacq_dbo.secteurs_activite_prestataire_new s0_ WHERE s0_.pointe_vers IN (189) LIMIT 1;