Query Metrics

126 Database Queries
18 Different statements
5650.74 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
807.88 ms
(14.30%)
3
SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe) INNER JOIN fusacq_dbo.buzz_operations b2_ ON (b2_.id_operation = b1_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (b2_.id_actualite_principale = b3_.id_actualite) WHERE b1_.id_type_role = ? AND b3_.mode_actualite = ? AND (b1_.table_sql_acteur = ? OR b1_.table_sql_acteur_passif = ?) AND b2_.type_operation = 'fusion_acquisition' AND b3_.date_mise_en_ligne <= 20260420191137 AND s0_.afficher_acheteur = 1 AND b2_.date_operation <= ?
Parameters:
[
  "1"
  "publique"
  "societes_news"
  "societes_news"
  "20260420"
]
732.15 ms
(12.96%)
12
SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201104 AND l1_.date_investissement <= 202104 AND s0_.afficher_acheteur = 1
Parameters:
[]
622.37 ms
(11.01%)
12
SELECT COUNT(DISTINCT s0_.id_gestionnaire_fonds) AS sclr_0 FROM fusacq_dbo.societe_gestionnaire_fonds s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_gestionnaire_fonds = s0_.id_gestionnaire_fonds) INNER JOIN fusacq_dbo.societes s2_ ON (s2_.id_societe = l1_.id_participation) WHERE s2_.mode_participation = 'publique' AND l1_.mode = 'publique' AND s0_.mode = 'publique' AND s2_.mode_societe = 'publique' AND s0_.stade_investissement LIKE '%4%'
Parameters:
[]
572.07 ms
(10.12%)
2
SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe) INNER JOIN fusacq_dbo.buzz_operations b2_ ON (b2_.id_operation = b1_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (b2_.id_actualite_principale = b3_.id_actualite) WHERE b1_.id_type_role = ? AND b3_.mode_actualite = ? AND (b1_.table_sql_acteur = ? OR b1_.table_sql_acteur_passif = ?) AND b2_.type_operation = 'fusion_acquisition' AND b3_.date_mise_en_ligne <= 20260420191139 AND s0_.afficher_acheteur = 1 AND b2_.date_operation <= ?
Parameters:
[
  "1"
  "publique"
  "societes_news"
  "societes_news"
  "20260420"
]
551.83 ms
(9.77%)
2
SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe) INNER JOIN fusacq_dbo.buzz_operations b2_ ON (b2_.id_operation = b1_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (b2_.id_actualite_principale = b3_.id_actualite) WHERE b1_.id_type_role = ? AND b3_.mode_actualite = ? AND (b1_.table_sql_acteur = ? OR b1_.table_sql_acteur_passif = ?) AND b2_.type_operation = 'fusion_acquisition' AND b3_.date_mise_en_ligne <= 20260420191140 AND s0_.afficher_acheteur = 1 AND b2_.date_operation <= ?
Parameters:
[
  "1"
  "publique"
  "societes_news"
  "societes_news"
  "20260420"
]
531.57 ms
(9.41%)
2
SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe) INNER JOIN fusacq_dbo.buzz_operations b2_ ON (b2_.id_operation = b1_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (b2_.id_actualite_principale = b3_.id_actualite) WHERE b1_.id_type_role = ? AND b3_.mode_actualite = ? AND (b1_.table_sql_acteur = ? OR b1_.table_sql_acteur_passif = ?) AND b2_.type_operation = 'fusion_acquisition' AND b3_.date_mise_en_ligne <= 20260420191138 AND s0_.afficher_acheteur = 1 AND b2_.date_operation <= ?
Parameters:
[
  "1"
  "publique"
  "societes_news"
  "societes_news"
  "20260420"
]
485.31 ms
(8.59%)
2
SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe) INNER JOIN fusacq_dbo.buzz_operations b2_ ON (b2_.id_operation = b1_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (b2_.id_actualite_principale = b3_.id_actualite) WHERE b1_.id_type_role = ? AND b3_.mode_actualite = ? AND (b1_.table_sql_acteur = ? OR b1_.table_sql_acteur_passif = ?) AND b2_.type_operation = 'fusion_acquisition' AND b3_.date_mise_en_ligne <= 20260420191136 AND s0_.afficher_acheteur = 1 AND b2_.date_operation <= ?
Parameters:
[
  "1"
  "publique"
  "societes_news"
  "societes_news"
  "20260420"
]
483.23 ms
(8.55%)
48
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 = ?
Parameters:
[
  "anciennete_minimale_investissement_participation"
  "oui"
  "fr"
  "FUSACQ"
]
304.49 ms
(5.39%)
1
SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe) INNER JOIN fusacq_dbo.buzz_operations b2_ ON (b2_.id_operation = b1_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (b2_.id_actualite_principale = b3_.id_actualite) WHERE b1_.id_type_role = ? AND b3_.mode_actualite = ? AND (b1_.table_sql_acteur = ? OR b1_.table_sql_acteur_passif = ?) AND b2_.type_operation = 'fusion_acquisition' AND b3_.date_mise_en_ligne <= 20260420191135 AND s0_.afficher_acheteur = 1 AND b2_.date_operation <= ?
Parameters:
[
  "1"
  "publique"
  "societes_news"
  "societes_news"
  "20260420"
]
226.67 ms
(4.01%)
12
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 ? OR a0_.id_secteur_activite_recherche LIKE ? OR a0_.id_secteur_activite_recherche LIKE ?)
Parameters:
[
  "%,399,%"
  "399,%"
  "%,399"
]
133.83 ms
(2.37%)
12
SELECT COUNT(DISTINCT a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite LIKE ?
Parameters:
[
  "399%"
]
133.80 ms
(2.37%)
12
SELECT COUNT(DISTINCT a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND a0_.id_secteur_activite LIKE ?
Parameters:
[
  "399%"
]
11.72 ms
(0.21%)
1
SELECT DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.ca_max AS ca_max_1, a0_.id_annonce_acheteur AS id_annonce_acheteur_2 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.type_raprochement = 'acquisition' OR a0_.type_raprochement IS NULL) AND a0_.id_secteur_activite LIKE ? ORDER BY a0_.ca_max DESC, a0_.id_annonce_acheteur DESC LIMIT 10 OFFSET 50
Parameters:
[
  "3%"
]
11.42 ms
(0.20%)
1
SELECT DISTINCT COUNT(DISTINCT a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.type_raprochement = 'acquisition' OR a0_.type_raprochement IS NULL) AND a0_.id_secteur_activite LIKE ?
Parameters:
[
  "3%"
]
11.19 ms
(0.20%)
1
SELECT COUNT(DISTINCT a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.id_period_annonce_prioritaire <> '' AND a0_.id_period_annonce_prioritaire IS NOT NULL AND a0_.etat_annonce_prioritaire = 'active' AND a0_.id_secteur_activite LIKE ?
Parameters:
[
  "3%"
]
10.56 ms
(0.19%)
1
SELECT DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.date_parution_initiale AS date_parution_initiale_2, a0_.date_parution AS date_parution_3, a0_.ca_max AS ca_max_4, a0_.apport_perso_repreneur AS apport_perso_repreneur_5, a0_.id_pays AS id_pays_6, a0_.id_region AS id_region_7, a0_.id_departement AS id_departement_8, a0_.autres_localisations AS autres_localisations_9, a0_.type_acquereur AS type_acquereur_10, a0_.id_langue AS id_langue_11 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.type_raprochement = 'acquisition' OR a0_.type_raprochement IS NULL) AND a0_.id_secteur_activite LIKE ? AND a0_.id_annonce_acheteur IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.ca_max DESC, a0_.id_annonce_acheteur DESC
Parameters:
[
  "3%"
  18081
  18080
  18079
  18009
  17862
  17765
  17736
  17430
  17279
  16252
]
10.38 ms
(0.18%)
1
SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.nom_secteur_activite AS nom_secteur_activite_1, s0_.nom_pour_TITLE AS nom_pour_TITLE_2 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite_pere = ? AND (s0_.obsolete <> ? OR s0_.obsolete IS NULL) ORDER BY s0_.nom_secteur_activite ASC
Parameters:
[
  "3"
  "oui"
]
10.24 ms
(0.18%)
1
SELECT t0.id_secteur_activite AS id_secteur_activite_1, t0.nom_secteur_activite AS nom_secteur_activite_2, t0.obsolete AS obsolete_3, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4, t0.site_partenaire AS site_partenaire_5, t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6, t0.id_secteur_activite_pere AS id_secteur_activite_pere_7, t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8, t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9, t0.nom_pour_TITLE AS nom_pour_TITLE_10, t0.rare AS rare_11, t0.recherche AS recherche_12, t0.image_filename AS image_filename_13 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = ? LIMIT 1
Parameters:
[
  "3"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.