Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

61 Database Queries

14 Different statements

1197.61 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT v0_.nom_ville AS nom_ville_0 FROM fusacq_dbo.villes v0_ WHERE v0_.code_departement LIKE ? ORDER BY v0_.population DESC LIMIT 3
SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = ?)
SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = ?)
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 = ? 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 = ? 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 = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 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_.type_raprochement = 'partenaire' AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?))
SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = ?)
SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = ?)
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 = ? 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 = ? 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 = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 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_.type_raprochement = 'partenaire' AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?))
SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = ?)
SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = ?)
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 = ? 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 = ? 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 = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 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_.type_raprochement = 'partenaire' AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?))
SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = ?)
SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = ?)
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 = ? 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 = ? 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 = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 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_.type_raprochement = 'partenaire' AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?))
SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = ?)
SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = ?)
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 = ? 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 = ? 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 = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 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_.type_raprochement = 'partenaire' AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?))
SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = ?)
SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = ?)
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 = ? 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 = ? 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 = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 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_.type_raprochement = 'partenaire' AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?))
SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_region = ?)
SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_region = ?)
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 = ? 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 = ? 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 = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.id_region = ?) AND s0_.afficher_vendeur = 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_.type_raprochement = 'partenaire' AND ((a0_.id_region = ? OR a0_.id_region = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?) OR ((a0_.id_region LIKE '' OR a0_.id_region IS NULL) AND (a0_.id_pays = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)))
SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') 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_.statuts LIKE '99%' AND (a0_.id_region = ?) ORDER BY a0_.date_debut_annonce_prioritaire ASC
SELECT DISTINCT a0_.date_fin_publique_elite AS date_fin_publique_elite_0, a0_.mode_annonce AS mode_annonce_1, a0_.id_annonce_vendeur AS id_annonce_vendeur_2, a0_.titre_annonce AS titre_annonce_3, a0_.date_parution_initiale AS date_parution_initiale_4, a0_.date_parution AS date_parution_5, a0_.ca_n AS ca_n_6, a0_.id_pays AS id_pays_7, a0_.id_region AS id_region_8, a0_.zone_geographique AS zone_geographique_9, a0_.id_departement AS id_departement_10, a0_.statuts AS statuts_11, a0_.id_secteur_activite AS id_secteur_activite_12 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') 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_.statuts LIKE '99%' AND (a0_.id_region = ?) ORDER BY a0_.date_debut_annonce_prioritaire ASC LIMIT 5
SELECT DISTINCT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_region = ?)
SELECT DISTINCT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.ca_n AS ca_n_1, a0_.id_annonce_vendeur AS id_annonce_vendeur_2 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_region = ?) ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC LIMIT 10

#▲	Time	Info
1	11.02 ms	SELECT v0_.nom_ville AS nom_ville_0 FROM fusacq_dbo.villes v0_ WHERE v0_.code_departement LIKE ? ORDER BY v0_.population DESC LIMIT 3 Parameters: [`"32_02%"`] View formatted query View runnable query Explain query SELECT v0_.nom_ville AS nom_ville_0 FROM fusacq_dbo.villes v0_ WHERE v0_.code_departement LIKE ? ORDER BY v0_.population DESC LIMIT 3 SELECT v0_.nom_ville AS nom_ville_0 FROM fusacq_dbo.villes v0_ WHERE v0_.code_departement LIKE '32_02%' ORDER BY v0_.population DESC LIMIT 3;
2	24.65 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = ?) Parameters: [`"32_02_01"`] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = ?) SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = '32_02_01');
3	21.34 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = ?) Parameters: [`"32_02_01"`] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE ( a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL ) AND ( a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite' ) AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = ?) SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = '32_02_01');
4	9.92 ms	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"`] View formatted query View runnable query Explain query 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 = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
5	9.94 ms	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_maximale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query 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 = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
6	10.06 ms	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"`] View formatted query View runnable query Explain query 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 = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
7	10.27 ms	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_maximale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query 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 = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
8	93.16 ms	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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 Parameters: [`"01%"`] View formatted query View runnable query Explain query 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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE '01%') AND s0_.afficher_vendeur = 1;
9	11.11 ms	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_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"32_02_01" "32_02_01%" "%,32_02_01%"`] View formatted query View runnable query Explain query 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_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? ) ) 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_departement = '32_02_01' OR a0_.autres_localisations LIKE '32_02_01%' OR a0_.autres_localisations LIKE '%,32_02_01%'));
10	19.80 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = ?) Parameters: [`"32_02_02"`] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = ?) SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = '32_02_02');
11	24.44 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = ?) Parameters: [`"32_02_02"`] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE ( a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL ) AND ( a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite' ) AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = ?) SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = '32_02_02');
12	10.00 ms	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"`] View formatted query View runnable query Explain query 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 = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
13	10.08 ms	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_maximale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query 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 = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
14	10.36 ms	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"`] View formatted query View runnable query Explain query 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 = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
15	10.38 ms	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_maximale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query 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 = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
16	69.99 ms	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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 Parameters: [`"02%"`] View formatted query View runnable query Explain query 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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE '02%') AND s0_.afficher_vendeur = 1;
17	10.89 ms	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_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"32_02_02" "32_02_02%" "%,32_02_02%"`] View formatted query View runnable query Explain query 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_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? ) ) 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_departement = '32_02_02' OR a0_.autres_localisations LIKE '32_02_02%' OR a0_.autres_localisations LIKE '%,32_02_02%'));
18	19.06 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = ?) Parameters: [`"32_02_03"`] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = ?) SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = '32_02_03');
19	28.67 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = ?) Parameters: [`"32_02_03"`] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE ( a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL ) AND ( a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite' ) AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = ?) SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = '32_02_03');
20	10.05 ms	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"`] View formatted query View runnable query Explain query 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 = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
21	10.46 ms	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_maximale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query 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 = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
22	10.15 ms	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"`] View formatted query View runnable query Explain query 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 = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
23	9.91 ms	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_maximale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query 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 = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
24	59.08 ms	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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 Parameters: [`"03%"`] View formatted query View runnable query Explain query 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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE '03%') AND s0_.afficher_vendeur = 1;
25	10.87 ms	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_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"32_02_03" "32_02_03%" "%,32_02_03%"`] View formatted query View runnable query Explain query 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_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? ) ) 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_departement = '32_02_03' OR a0_.autres_localisations LIKE '32_02_03%' OR a0_.autres_localisations LIKE '%,32_02_03%'));
26	19.97 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = ?) Parameters: [`"32_02_04"`] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = ?) SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = '32_02_04');
27	28.02 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = ?) Parameters: [`"32_02_04"`] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE ( a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL ) AND ( a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite' ) AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = ?) SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = '32_02_04');
28	10.10 ms	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"`] View formatted query View runnable query Explain query 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 = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
29	10.06 ms	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_maximale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query 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 = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
30	9.86 ms	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"`] View formatted query View runnable query Explain query 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 = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
31	9.76 ms	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_maximale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query 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 = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
32	52.26 ms	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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 Parameters: [`"04%"`] View formatted query View runnable query Explain query 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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE '04%') AND s0_.afficher_vendeur = 1;
33	10.96 ms	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_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"32_02_04" "32_02_04%" "%,32_02_04%"`] View formatted query View runnable query Explain query 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_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? ) ) 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_departement = '32_02_04' OR a0_.autres_localisations LIKE '32_02_04%' OR a0_.autres_localisations LIKE '%,32_02_04%'));
34	21.17 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = ?) Parameters: [`"32_02_05"`] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = ?) SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = '32_02_05');
35	23.86 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = ?) Parameters: [`"32_02_05"`] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE ( a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL ) AND ( a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite' ) AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = ?) SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = '32_02_05');
36	9.87 ms	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"`] View formatted query View runnable query Explain query 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 = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
37	9.95 ms	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_maximale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query 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 = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
38	10.26 ms	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"`] View formatted query View runnable query Explain query 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 = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
39	10.20 ms	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_maximale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query 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 = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
40	65.17 ms	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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 Parameters: [`"05%"`] View formatted query View runnable query Explain query 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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE '05%') AND s0_.afficher_vendeur = 1;
41	10.89 ms	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_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"32_02_05" "32_02_05%" "%,32_02_05%"`] View formatted query View runnable query Explain query 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_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? ) ) 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_departement = '32_02_05' OR a0_.autres_localisations LIKE '32_02_05%' OR a0_.autres_localisations LIKE '%,32_02_05%'));
42	20.26 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = ?) Parameters: [`"32_02_99"`] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = ?) SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = '32_02_99');
43	32.28 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = ?) Parameters: [`"32_02_99"`] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE ( a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL ) AND ( a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite' ) AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = ?) SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = '32_02_99');
44	9.99 ms	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"`] View formatted query View runnable query Explain query 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 = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
45	9.96 ms	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_maximale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query 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 = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
46	9.84 ms	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"`] View formatted query View runnable query Explain query 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 = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
47	9.88 ms	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_maximale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query 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 = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
48	78.80 ms	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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 Parameters: [`"99%"`] View formatted query View runnable query Explain query 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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.code_postal LIKE '99%') AND s0_.afficher_vendeur = 1;
49	11.57 ms	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_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"32_02_99" "32_02_99%" "%,32_02_99%"`] View formatted query View runnable query Explain query 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_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? ) ) 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_departement = '32_02_99' OR a0_.autres_localisations LIKE '32_02_99%' OR a0_.autres_localisations LIKE '%,32_02_99%'));
50	9.92 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_region = ?) Parameters: [`"32_02"`] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_region = ?) SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_region = '32_02');
51	10.01 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_region = ?) Parameters: [`"32_02"`] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE ( a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL ) AND ( a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite' ) AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_region = ?) SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_region = '32_02');
52	10.05 ms	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"`] View formatted query View runnable query Explain query 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 = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
53	10.25 ms	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_maximale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query 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 = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
54	10.27 ms	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"`] View formatted query View runnable query Explain query 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 = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
55	10.28 ms	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_maximale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query 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 = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
56	64.73 ms	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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.id_region = ?) AND s0_.afficher_vendeur = 1 Parameters: [`"32_02"`] View formatted query View runnable query Explain query 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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.id_region = ?) AND s0_.afficher_vendeur = 1 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 >= 201105 AND l1_.date_investissement <= 202105 AND (s0_.id_region = '32_02') AND s0_.afficher_vendeur = 1;
57	11.04 ms	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_region = ? OR a0_.id_region = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?) OR ((a0_.id_region LIKE '' OR a0_.id_region IS NULL) AND (a0_.id_pays = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?))) Parameters: [`"32_02" "32_99" "32_02%" "%,32_02%" "32" "32" "32%" "%,32%" "%,32"`] View formatted query View runnable query Explain query 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_region = ? OR a0_.id_region = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? ) OR ( ( a0_.id_region LIKE '' OR a0_.id_region IS NULL ) AND ( a0_.id_pays = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ? ) ) ) 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_region = '32_02' OR a0_.id_region = '32_99' OR a0_.autres_localisations LIKE '32_02%' OR a0_.autres_localisations LIKE '%,32_02%') OR ((a0_.id_region LIKE '' OR a0_.id_region IS NULL) AND (a0_.id_pays = '32' OR a0_.autres_localisations LIKE '32' OR a0_.autres_localisations LIKE '32%' OR a0_.autres_localisations LIKE '%,32%' OR a0_.autres_localisations LIKE '%,32')));
58	9.93 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') 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_.statuts LIKE '99%' AND (a0_.id_region = ?) ORDER BY a0_.date_debut_annonce_prioritaire ASC Parameters: [`"32_02"`] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE ( a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL ) AND ( a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite' ) 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_.statuts LIKE '99%' AND (a0_.id_region = ?) ORDER BY a0_.date_debut_annonce_prioritaire ASC SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') 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_.statuts LIKE '99%' AND (a0_.id_region = '32_02') ORDER BY a0_.date_debut_annonce_prioritaire ASC;
59	10.09 ms	SELECT DISTINCT a0_.date_fin_publique_elite AS date_fin_publique_elite_0, a0_.mode_annonce AS mode_annonce_1, a0_.id_annonce_vendeur AS id_annonce_vendeur_2, a0_.titre_annonce AS titre_annonce_3, a0_.date_parution_initiale AS date_parution_initiale_4, a0_.date_parution AS date_parution_5, a0_.ca_n AS ca_n_6, a0_.id_pays AS id_pays_7, a0_.id_region AS id_region_8, a0_.zone_geographique AS zone_geographique_9, a0_.id_departement AS id_departement_10, a0_.statuts AS statuts_11, a0_.id_secteur_activite AS id_secteur_activite_12 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') 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_.statuts LIKE '99%' AND (a0_.id_region = ?) ORDER BY a0_.date_debut_annonce_prioritaire ASC LIMIT 5 Parameters: [`"32_02"`] View formatted query View runnable query Explain query SELECT DISTINCT a0_.date_fin_publique_elite AS date_fin_publique_elite_0, a0_.mode_annonce AS mode_annonce_1, a0_.id_annonce_vendeur AS id_annonce_vendeur_2, a0_.titre_annonce AS titre_annonce_3, a0_.date_parution_initiale AS date_parution_initiale_4, a0_.date_parution AS date_parution_5, a0_.ca_n AS ca_n_6, a0_.id_pays AS id_pays_7, a0_.id_region AS id_region_8, a0_.zone_geographique AS zone_geographique_9, a0_.id_departement AS id_departement_10, a0_.statuts AS statuts_11, a0_.id_secteur_activite AS id_secteur_activite_12 FROM fusacq_dbo.annonces_vendeur a0_ WHERE ( a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL ) AND ( a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite' ) 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_.statuts LIKE '99%' AND (a0_.id_region = ?) ORDER BY a0_.date_debut_annonce_prioritaire ASC LIMIT 5 SELECT DISTINCT a0_.date_fin_publique_elite AS date_fin_publique_elite_0, a0_.mode_annonce AS mode_annonce_1, a0_.id_annonce_vendeur AS id_annonce_vendeur_2, a0_.titre_annonce AS titre_annonce_3, a0_.date_parution_initiale AS date_parution_initiale_4, a0_.date_parution AS date_parution_5, a0_.ca_n AS ca_n_6, a0_.id_pays AS id_pays_7, a0_.id_region AS id_region_8, a0_.zone_geographique AS zone_geographique_9, a0_.id_departement AS id_departement_10, a0_.statuts AS statuts_11, a0_.id_secteur_activite AS id_secteur_activite_12 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') 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_.statuts LIKE '99%' AND (a0_.id_region = '32_02') ORDER BY a0_.date_debut_annonce_prioritaire ASC LIMIT 5;
60	10.10 ms	SELECT DISTINCT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_region = ?) Parameters: [`"32_02"`] View formatted query View runnable query Explain query SELECT DISTINCT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE ( a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL ) AND ( a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite' ) AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_region = ?) SELECT DISTINCT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_region = '32_02');
61	10.32 ms	SELECT DISTINCT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.ca_n AS ca_n_1, a0_.id_annonce_vendeur AS id_annonce_vendeur_2 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_region = ?) ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC LIMIT 10 Parameters: [`"32_02"`] View formatted query View runnable query Explain query SELECT DISTINCT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.ca_n AS ca_n_1, a0_.id_annonce_vendeur AS id_annonce_vendeur_2 FROM fusacq_dbo.annonces_vendeur a0_ WHERE ( a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL ) AND ( a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite' ) AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_region = ?) ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC LIMIT 10 SELECT DISTINCT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.ca_n AS ca_n_1, a0_.id_annonce_vendeur AS id_annonce_vendeur_2 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_region = '32_02') ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC LIMIT 10;

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.

Entities Mapping

Class	Mapping errors
App\Entity\Villes	No errors.
App\Entity\AnnoncesVendeur	No errors.
App\Entity\Societes	No errors.
App\Entity\AnnoncesAcheteur	No errors.
App\Entity\DataParametreSite	No errors.
App\Entity\ParametreSite	No errors.
App\Entity\LienParticipationsFonds	No errors.
App\Entity\Translation	No errors.

Symfony Profiler

https://preprod.fusacq.com/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CCoreController%253A%253Amenu

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping