Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

123 Database Queries

18 Different statements

2028.99 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_secteur_activite = ? 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_secteur_activite = ? 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 >= 201104 AND l1_.date_investissement <= 202104 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_secteur_activite = ? 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_secteur_activite = ? 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_secteur_activite = ? 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 >= 201104 AND l1_.date_investissement <= 202104 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_secteur_activite = ? 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_secteur_activite = ? 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_secteur_activite = ? 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 >= 201104 AND l1_.date_investissement <= 202104 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_secteur_activite = ? 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_secteur_activite = ? 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_secteur_activite = ? 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 >= 201104 AND l1_.date_investissement <= 202104 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_secteur_activite = ? 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_secteur_activite = ? 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_secteur_activite = ? 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 >= 201104 AND l1_.date_investissement <= 202104 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_secteur_activite = ? 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_secteur_activite = ? 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_secteur_activite = ? 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 >= 201104 AND l1_.date_investissement <= 202104 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_secteur_activite = ? 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_secteur_activite = ? 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_secteur_activite = ? 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 >= 201104 AND l1_.date_investissement <= 202104 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_secteur_activite = ? 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_secteur_activite = ? 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_secteur_activite = ? 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 >= 201104 AND l1_.date_investissement <= 202104 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_secteur_activite = ? 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_secteur_activite = ? 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_secteur_activite = ? 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 >= 201104 AND l1_.date_investissement <= 202104 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_secteur_activite = ? 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_secteur_activite = ? 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_secteur_activite = ? 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 >= 201104 AND l1_.date_investissement <= 202104 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_secteur_activite = ? 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_secteur_activite = ? 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_secteur_activite = ? 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 >= 201104 AND l1_.date_investissement <= 202104 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_secteur_activite = ? 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_secteur_activite = ? 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_secteur_activite = ? 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 >= 201104 AND l1_.date_investissement <= 202104 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_secteur_activite = ? 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_secteur_activite = ? 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_secteur_activite = ? 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 >= 201104 AND l1_.date_investissement <= 202104 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_secteur_activite = ? AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?))
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 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = ? LIMIT 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 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = ? LIMIT 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 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = ? LIMIT 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
SELECT DISTINCT a0_.mode_annonce AS mode_annonce_0, a0_.id_annonce_vendeur AS id_annonce_vendeur_1, a0_.titre_annonce AS titre_annonce_2, a0_.date_parution_initiale AS date_parution_initiale_3, a0_.date_parution AS date_parution_4, a0_.date_parution_initiale_elite AS date_parution_initiale_elite_5, a0_.date_parution_elite AS date_parution_elite_6, a0_.date_fin_publique_elite AS date_fin_publique_elite_7, a0_.ca_n AS ca_n_8, a0_.id_pays AS id_pays_9, a0_.id_region AS id_region_10, a0_.zone_geographique AS zone_geographique_11, a0_.id_departement AS id_departement_12, a0_.statuts AS statuts_13, a0_.id_langue AS id_langue_14, a0_.id_secteur_activite AS id_secteur_activite_15 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale_elite IS NOT NULL AND a0_.mode_annonce = 'publique_elite' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite = ? AND (a0_.id_region = ?) ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC
SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale_elite IS NOT NULL AND a0_.mode_annonce = 'publique_elite' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite = ? AND (a0_.id_region = ?) ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC
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_secteur_activite = ? 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_secteur_activite = ? 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 >= 201104 AND l1_.date_investissement <= 202104 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_secteur_activite = ? 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_.id_secteur_activite = ? 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 NOT LIKE '99%' AND a0_.id_secteur_activite = ? 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 NOT LIKE '99%' AND a0_.id_secteur_activite = ? 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 NOT LIKE '99%' AND a0_.id_secteur_activite = ? AND (a0_.id_region = ?) ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC LIMIT 10

#▲	Time	Info
1	11.70 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: [`"33_23%"`] 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 '33_23%' ORDER BY v0_.population DESC LIMIT 3;
2	10.82 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_971"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_971');
3	10.85 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_971"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_971');
4	10.75 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	10.72 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.71 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.78 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	62.62 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 Parameters: [`"971%"`] 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 >= 201104 AND l1_.date_investissement <= 202104 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE '971%') AND s0_.afficher_vendeur = 1;
9	10.37 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_secteur_activite = ? AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"60799" "33_23_971" "33_23_971%" "%,33_23_971%"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND ((a0_.id_departement = '33_23_971' OR a0_.autres_localisations LIKE '33_23_971%' OR a0_.autres_localisations LIKE '%,33_23_971%'));
10	10.41 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_973"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_973');
11	10.48 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_973"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_973');
12	10.55 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.75 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.74 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.74 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	63.56 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 Parameters: [`"973%"`] 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 >= 201104 AND l1_.date_investissement <= 202104 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE '973%') AND s0_.afficher_vendeur = 1;
17	10.38 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_secteur_activite = ? AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"60799" "33_23_973" "33_23_973%" "%,33_23_973%"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND ((a0_.id_departement = '33_23_973' OR a0_.autres_localisations LIKE '33_23_973%' OR a0_.autres_localisations LIKE '%,33_23_973%'));
18	10.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 AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_974"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_974');
19	10.42 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_974"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_974');
20	10.44 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.54 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.73 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	10.71 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	63.14 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 Parameters: [`"974%"`] 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 >= 201104 AND l1_.date_investissement <= 202104 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE '974%') AND s0_.afficher_vendeur = 1;
25	10.27 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_secteur_activite = ? AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"60799" "33_23_974" "33_23_974%" "%,33_23_974%"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND ((a0_.id_departement = '33_23_974' OR a0_.autres_localisations LIKE '33_23_974%' OR a0_.autres_localisations LIKE '%,33_23_974%'));
26	10.32 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_972"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_972');
27	10.38 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_972"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_972');
28	10.40 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.65 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	10.70 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	10.64 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	62.41 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 Parameters: [`"972%"`] 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 >= 201104 AND l1_.date_investissement <= 202104 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE '972%') AND s0_.afficher_vendeur = 1;
33	10.26 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_secteur_activite = ? AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"60799" "33_23_972" "33_23_972%" "%,33_23_972%"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND ((a0_.id_departement = '33_23_972' OR a0_.autres_localisations LIKE '33_23_972%' OR a0_.autres_localisations LIKE '%,33_23_972%'));
34	10.23 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_976"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_976');
35	10.30 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_976"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_976');
36	10.35 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	10.51 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.63 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.64 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	64.70 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 Parameters: [`"976%"`] 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 >= 201104 AND l1_.date_investissement <= 202104 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE '976%') AND s0_.afficher_vendeur = 1;
41	10.26 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_secteur_activite = ? AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"60799" "33_23_976" "33_23_976%" "%,33_23_976%"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND ((a0_.id_departement = '33_23_976' OR a0_.autres_localisations LIKE '33_23_976%' OR a0_.autres_localisations LIKE '%,33_23_976%'));
42	10.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 AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_988"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_988');
43	10.39 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_988"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_988');
44	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_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	10.44 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	10.63 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	10.63 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	61.96 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 Parameters: [`"988%"`] 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 >= 201104 AND l1_.date_investissement <= 202104 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE '988%') AND s0_.afficher_vendeur = 1;
49	10.26 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_secteur_activite = ? AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"60799" "33_23_988" "33_23_988%" "%,33_23_988%"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND ((a0_.id_departement = '33_23_988' OR a0_.autres_localisations LIKE '33_23_988%' OR a0_.autres_localisations LIKE '%,33_23_988%'));
50	10.32 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_987"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_987');
51	10.43 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_987"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_987');
52	10.47 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.62 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.67 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.64 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	60.74 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 Parameters: [`"987%"`] 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 >= 201104 AND l1_.date_investissement <= 202104 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE '987%') AND s0_.afficher_vendeur = 1;
57	10.76 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_secteur_activite = ? AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"60799" "33_23_987" "33_23_987%" "%,33_23_987%"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND ((a0_.id_departement = '33_23_987' OR a0_.autres_localisations LIKE '33_23_987%' OR a0_.autres_localisations LIKE '%,33_23_987%'));
58	10.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 AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_977"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_977');
59	10.49 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_977"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_977');
60	10.51 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';
61	10.63 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';
62	10.66 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';
63	10.67 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';
64	61.87 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 Parameters: [`"977%"`] 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 >= 201104 AND l1_.date_investissement <= 202104 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE '977%') AND s0_.afficher_vendeur = 1;
65	10.27 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_secteur_activite = ? AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"60799" "33_23_977" "33_23_977%" "%,33_23_977%"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND ((a0_.id_departement = '33_23_977' OR a0_.autres_localisations LIKE '33_23_977%' OR a0_.autres_localisations LIKE '%,33_23_977%'));
66	10.32 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_978"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_978');
67	10.36 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_978"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_978');
68	10.47 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';
69	10.68 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';
70	10.67 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';
71	10.67 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';
72	65.15 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 Parameters: [`"978%"`] 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 >= 201104 AND l1_.date_investissement <= 202104 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE '978%') AND s0_.afficher_vendeur = 1;
73	10.30 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_secteur_activite = ? AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"60799" "33_23_978" "33_23_978%" "%,33_23_978%"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND ((a0_.id_departement = '33_23_978' OR a0_.autres_localisations LIKE '33_23_978%' OR a0_.autres_localisations LIKE '%,33_23_978%'));
74	10.39 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_975"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_975');
75	10.45 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_975"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_975');
76	10.53 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';
77	10.69 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';
78	10.69 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';
79	10.68 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';
80	64.38 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 Parameters: [`"975%"`] 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 >= 201104 AND l1_.date_investissement <= 202104 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE '975%') AND s0_.afficher_vendeur = 1;
81	10.24 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_secteur_activite = ? AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"60799" "33_23_975" "33_23_975%" "%,33_23_975%"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND ((a0_.id_departement = '33_23_975' OR a0_.autres_localisations LIKE '33_23_975%' OR a0_.autres_localisations LIKE '%,33_23_975%'));
82	10.30 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_984"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_984');
83	10.35 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_984"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_984');
84	10.49 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';
85	10.65 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';
86	10.66 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';
87	10.65 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';
88	62.35 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 Parameters: [`"984%"`] 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 >= 201104 AND l1_.date_investissement <= 202104 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE '984%') AND s0_.afficher_vendeur = 1;
89	10.22 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_secteur_activite = ? AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"60799" "33_23_984" "33_23_984%" "%,33_23_984%"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND ((a0_.id_departement = '33_23_984' OR a0_.autres_localisations LIKE '33_23_984%' OR a0_.autres_localisations LIKE '%,33_23_984%'));
90	10.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 AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_986"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_986');
91	10.33 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_986"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_986');
92	10.41 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';
93	10.73 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';
94	10.73 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';
95	10.73 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';
96	60.28 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE ?) AND s0_.afficher_vendeur = 1 Parameters: [`"986%"`] 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 >= 201104 AND l1_.date_investissement <= 202104 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE '986%') AND s0_.afficher_vendeur = 1;
97	10.28 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_secteur_activite = ? AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"60799" "33_23_986" "33_23_986%" "%,33_23_986%"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND ((a0_.id_departement = '33_23_986' OR a0_.autres_localisations LIKE '33_23_986%' OR a0_.autres_localisations LIKE '%,33_23_986%'));
98	10.25 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_99');
99	10.33 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_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60799" "33_23_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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_departement = '33_23_99');
100	10.39 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';
101	10.75 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';
102	10.70 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';
103	10.74 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';
104	63.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 >= 201104 AND l1_.date_investissement <= 202104 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 >= 201104 AND l1_.date_investissement <= 202104 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.code_postal LIKE '99%') AND s0_.afficher_vendeur = 1;
105	10.26 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_secteur_activite = ? AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"60799" "33_23_99" "33_23_99%" "%,33_23_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_secteur_activite = ? 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_secteur_activite = '60799' AND ((a0_.id_departement = '33_23_99' OR a0_.autres_localisations LIKE '33_23_99%' OR a0_.autres_localisations LIKE '%,33_23_99%'));
106	10.19 ms	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 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = ? LIMIT 1 Parameters: [`"6"`] View formatted query View runnable query Explain query 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 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = ? LIMIT 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 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = '6' LIMIT 1;
107	10.19 ms	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 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = ? LIMIT 1 Parameters: [`"607"`] View formatted query View runnable query Explain query 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 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = ? LIMIT 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 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = '607' LIMIT 1;
108	10.25 ms	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 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = ? LIMIT 1 Parameters: [`"60799"`] View formatted query View runnable query Explain query 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 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = ? LIMIT 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 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = '60799' LIMIT 1;
109	10.46 ms	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: [`"60799" "oui"`] View formatted query View runnable query Explain query 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 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 = '60799' AND (s0_.obsolete <> 'oui' OR s0_.obsolete IS NULL) ORDER BY s0_.nom_secteur_activite ASC;
110	10.79 ms	SELECT DISTINCT a0_.mode_annonce AS mode_annonce_0, a0_.id_annonce_vendeur AS id_annonce_vendeur_1, a0_.titre_annonce AS titre_annonce_2, a0_.date_parution_initiale AS date_parution_initiale_3, a0_.date_parution AS date_parution_4, a0_.date_parution_initiale_elite AS date_parution_initiale_elite_5, a0_.date_parution_elite AS date_parution_elite_6, a0_.date_fin_publique_elite AS date_fin_publique_elite_7, a0_.ca_n AS ca_n_8, a0_.id_pays AS id_pays_9, a0_.id_region AS id_region_10, a0_.zone_geographique AS zone_geographique_11, a0_.id_departement AS id_departement_12, a0_.statuts AS statuts_13, a0_.id_langue AS id_langue_14, a0_.id_secteur_activite AS id_secteur_activite_15 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale_elite IS NOT NULL AND a0_.mode_annonce = 'publique_elite' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite = ? AND (a0_.id_region = ?) ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC Parameters: [`"60799" "33_23"`] View formatted query View runnable query Explain query SELECT DISTINCT a0_.mode_annonce AS mode_annonce_0, a0_.id_annonce_vendeur AS id_annonce_vendeur_1, a0_.titre_annonce AS titre_annonce_2, a0_.date_parution_initiale AS date_parution_initiale_3, a0_.date_parution AS date_parution_4, a0_.date_parution_initiale_elite AS date_parution_initiale_elite_5, a0_.date_parution_elite AS date_parution_elite_6, a0_.date_fin_publique_elite AS date_fin_publique_elite_7, a0_.ca_n AS ca_n_8, a0_.id_pays AS id_pays_9, a0_.id_region AS id_region_10, a0_.zone_geographique AS zone_geographique_11, a0_.id_departement AS id_departement_12, a0_.statuts AS statuts_13, a0_.id_langue AS id_langue_14, a0_.id_secteur_activite AS id_secteur_activite_15 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale_elite IS NOT NULL AND a0_.mode_annonce = 'publique_elite' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite = ? AND (a0_.id_region = ?) ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC SELECT DISTINCT a0_.mode_annonce AS mode_annonce_0, a0_.id_annonce_vendeur AS id_annonce_vendeur_1, a0_.titre_annonce AS titre_annonce_2, a0_.date_parution_initiale AS date_parution_initiale_3, a0_.date_parution AS date_parution_4, a0_.date_parution_initiale_elite AS date_parution_initiale_elite_5, a0_.date_parution_elite AS date_parution_elite_6, a0_.date_fin_publique_elite AS date_fin_publique_elite_7, a0_.ca_n AS ca_n_8, a0_.id_pays AS id_pays_9, a0_.id_region AS id_region_10, a0_.zone_geographique AS zone_geographique_11, a0_.id_departement AS id_departement_12, a0_.statuts AS statuts_13, a0_.id_langue AS id_langue_14, a0_.id_secteur_activite AS id_secteur_activite_15 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale_elite IS NOT NULL AND a0_.mode_annonce = 'publique_elite' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite = '60799' AND (a0_.id_region = '33_23') ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC;
111	10.71 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale_elite IS NOT NULL AND a0_.mode_annonce = 'publique_elite' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite = ? AND (a0_.id_region = ?) ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC Parameters: [`"60799" "33_23"`] 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_elite IS NOT NULL AND a0_.mode_annonce = 'publique_elite' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite = ? AND (a0_.id_region = ?) ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale_elite IS NOT NULL AND a0_.mode_annonce = 'publique_elite' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite = '60799' AND (a0_.id_region = '33_23') ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC;
112	10.79 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_secteur_activite = ? AND (a0_.id_region = ?) Parameters: [`"60799" "33_23"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_region = '33_23');
113	10.89 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_secteur_activite = ? AND (a0_.id_region = ?) Parameters: [`"60799" "33_23"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND (a0_.id_region = '33_23');
114	10.69 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';
115	10.68 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';
116	10.66 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';
117	10.67 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';
118	63.65 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.id_region = ?) AND s0_.afficher_vendeur = 1 Parameters: [`"33_23"`] 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 >= 201104 AND l1_.date_investissement <= 202104 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 >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.id_region = '33_23') AND s0_.afficher_vendeur = 1;
119	10.31 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_secteur_activite = ? 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: [`"60799" "33_23" "33_99" "33_23%" "%,33_23%" "33" "33" "33%" "%,33%" "%,33"`] 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_secteur_activite = ? 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_secteur_activite = '60799' AND ((a0_.id_region = '33_23' OR a0_.id_region = '33_99' OR a0_.autres_localisations LIKE '33_23%' OR a0_.autres_localisations LIKE '%,33_23%') OR ((a0_.id_region LIKE '' OR a0_.id_region IS NULL) AND (a0_.id_pays = '33' OR a0_.autres_localisations LIKE '33' OR a0_.autres_localisations LIKE '33%' OR a0_.autres_localisations LIKE '%,33%' OR a0_.autres_localisations LIKE '%,33')));
120	10.38 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_.id_secteur_activite = ? AND (a0_.id_region = ?) ORDER BY a0_.date_debut_annonce_prioritaire ASC Parameters: [`"60799" "33_23"`] 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_.id_secteur_activite = ? 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_.id_secteur_activite = '60799' AND (a0_.id_region = '33_23') ORDER BY a0_.date_debut_annonce_prioritaire ASC;
121	10.55 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 NOT LIKE '99%' AND a0_.id_secteur_activite = ? AND (a0_.id_region = ?) ORDER BY a0_.date_debut_annonce_prioritaire ASC LIMIT 5 Parameters: [`"60799" "33_23"`] 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 NOT LIKE '99%' AND a0_.id_secteur_activite = ? 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 NOT LIKE '99%' AND a0_.id_secteur_activite = '60799' AND (a0_.id_region = '33_23') ORDER BY a0_.date_debut_annonce_prioritaire ASC LIMIT 5;
122	10.64 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 NOT LIKE '99%' AND a0_.id_secteur_activite = ? AND (a0_.id_region = ?) Parameters: [`"60799" "33_23"`] 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 NOT LIKE '99%' AND a0_.id_secteur_activite = ? 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 NOT LIKE '99%' AND a0_.id_secteur_activite = '60799' AND (a0_.id_region = '33_23');
123	10.86 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 NOT LIKE '99%' AND a0_.id_secteur_activite = ? AND (a0_.id_region = ?) ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC LIMIT 10 Parameters: [`"60799" "33_23"`] 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 NOT LIKE '99%' AND a0_.id_secteur_activite = ? 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 NOT LIKE '99%' AND a0_.id_secteur_activite = '60799' AND (a0_.id_region = '33_23') 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\SecteursActivite	No errors.
App\Entity\Translation	No errors.

Symfony Profiler

https://preprod.fusacq.com/cession-entreprise-autres-dom-tom,r33_23,60799_fr_

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping