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 = 1579 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 = 1844;

SELECT
  t0.id_statistique_mensuelle AS id_statistique_mensuelle_1,
  t0.id_service_prestataire AS id_service_prestataire_2,
  t0.nb_affichages_fiche AS nb_affichages_fiche_3,
  t0.nb_clics_site_internet AS nb_clics_site_internet_4,
  t0.nb_contacts_generes AS nb_contacts_generes_5,
  t0.date_mois AS date_mois_6,
  t0.nb_aff_fiche_recherche AS nb_aff_fiche_recherche_7,
  t0.nb_aff_fiche_dernieres AS nb_aff_fiche_dernieres_8,
  t0.nb_aff_fiche_newsletter AS nb_aff_fiche_newsletter_9,
  t0.nb_aff_fiche_mail AS nb_aff_fiche_mail_10,
  t0.nb_aff_fiche_annonce_vente AS nb_aff_fiche_annonce_vente_11,
  t0.nb_aff_fiche_annonce_achat AS nb_aff_fiche_annonce_achat_12,
  t0.nb_aff_fiche_fonds AS nb_aff_fiche_fonds_13,
  t0.nb_aff_fiche_menu_gauche_consultation_annonce_vendeur AS nb_aff_fiche_menu_gauche_consultation_annonce_vendeur_14,
  t0.site_partenaire AS site_partenaire_15,
  t0.nb_clics_url_vignette AS nb_clics_url_vignette_16
FROM
  fusacq_dbo.statistiques_mensuelles_prestataire t0
WHERE
  t0.id_service_prestataire = ?
  AND t0.date_mois = ?
LIMIT
  1

SELECT t0.id_statistique_mensuelle AS id_statistique_mensuelle_1, t0.id_service_prestataire AS id_service_prestataire_2, t0.nb_affichages_fiche AS nb_affichages_fiche_3, t0.nb_clics_site_internet AS nb_clics_site_internet_4, t0.nb_contacts_generes AS nb_contacts_generes_5, t0.date_mois AS date_mois_6, t0.nb_aff_fiche_recherche AS nb_aff_fiche_recherche_7, t0.nb_aff_fiche_dernieres AS nb_aff_fiche_dernieres_8, t0.nb_aff_fiche_newsletter AS nb_aff_fiche_newsletter_9, t0.nb_aff_fiche_mail AS nb_aff_fiche_mail_10, t0.nb_aff_fiche_annonce_vente AS nb_aff_fiche_annonce_vente_11, t0.nb_aff_fiche_annonce_achat AS nb_aff_fiche_annonce_achat_12, t0.nb_aff_fiche_fonds AS nb_aff_fiche_fonds_13, t0.nb_aff_fiche_menu_gauche_consultation_annonce_vendeur AS nb_aff_fiche_menu_gauche_consultation_annonce_vendeur_14, t0.site_partenaire AS site_partenaire_15, t0.nb_clics_url_vignette AS nb_clics_url_vignette_16 FROM fusacq_dbo.statistiques_mensuelles_prestataire t0 WHERE t0.id_service_prestataire = '1579' AND t0.date_mois = '202604' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  fusacq_dbo.statistiques_mensuelles_prestataire
SET
  nb_affichages_fiche = ?
WHERE
  id_statistique_mensuelle = ?

UPDATE fusacq_dbo.statistiques_mensuelles_prestataire SET nb_affichages_fiche = 28 WHERE id_statistique_mensuelle = 155930;

"COMMIT"

"COMMIT";

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 = 1844 AND l0_.id_service_prestataire = 1579 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 = 1579
    AND b1_.id_societe_prestataire = 1844
    AND b1_.provenance_flux_actualite = 'blog'
    AND b1_.mode_actualite = 'publique'
    AND b1_.date_mise_en_ligne < 20260414014249
  )
  OR r2_.id_service_prestataire = 1579
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 = 1579 AND b1_.id_societe_prestataire = 1844 AND b1_.provenance_flux_actualite = 'blog' AND b1_.mode_actualite = 'publique' AND b1_.date_mise_en_ligne < 20260414014249) OR r2_.id_service_prestataire = 1579 ORDER BY b1_.date_mise_en_ligne DESC;

SELECT
  s0_.nom_secteur_activite AS nom_secteur_activite_0
FROM
  fusacq_dbo.secteurs_activite_prestataire_new s0_
WHERE
  s0_.id_secteur_activite IN (161)
LIMIT
  1

SELECT s0_.nom_secteur_activite AS nom_secteur_activite_0 FROM fusacq_dbo.secteurs_activite_prestataire_new s0_ WHERE s0_.id_secteur_activite IN (161) 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_.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%';