Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

81 Database Queries

18 Different statements

1355.70 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 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 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 d0_.value AS value_0 FROM partage_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 GROUP BY s0_.id_societe
SELECT DISTINCT s0_.id_societe AS id_societe_0, s0_.ca_n AS ca_n_1, s0_.date_dernier_investissement AS date_dernier_investissement_2, s0_.id_societe AS id_societe_3 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 GROUP BY s0_.id_societe ORDER BY s0_.ca_n DESC, s0_.date_dernier_investissement ASC, s0_.id_societe DESC LIMIT 10
SELECT s0_.id_societe AS id_societe_0, s0_.id_societe_news AS id_societe_news_1, s0_.id_participation AS id_participation_2, s0_.mode_participation AS mode_participation_3, s0_.deja_publique AS deja_publique_4, s0_.raison_sociale AS raison_sociale_5, s0_.raison_sociale_formatee AS raison_sociale_formatee_6, s0_.nom_president AS nom_president_7, s0_.nom_directeur_general AS nom_directeur_general_8, s0_.adresse AS adresse_9, s0_.ville AS ville_10, s0_.code_postal AS code_postal_11, s0_.telephone AS telephone_12, s0_.fax AS fax_13, s0_.id_pays AS id_pays_14, s0_.devise AS devise_15, s0_.id_region AS id_region_16, s0_.filiales_bureaux AS filiales_bureaux_17, s0_.id_secteur_activite AS id_secteur_activite_18, s0_.id_secteur_activite_fonds AS id_secteur_activite_fonds_19, s0_.site_internet AS site_internet_20, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_21, s0_.mail_contact AS mail_contact_22, s0_.resume_activite AS resume_activite_23, s0_.description_activite AS description_activite_24, s0_.mots_cles AS mots_cles_25, s0_.strategie_developpement AS strategie_developpement_26, s0_.marge_brute_n AS marge_brute_n_27, s0_.resultat_exploitation_n AS resultat_exploitation_n_28, s0_.resultat_net_n AS resultat_net_n_29, s0_.ca_n AS ca_n_30, s0_.nb_personnes_n AS nb_personnes_n_31, s0_.annee_n AS annee_n_32, s0_.date_mise_a_jour AS date_mise_a_jour_33, s0_.fichier_joint AS fichier_joint_34, s0_.commentaire_interne AS commentaire_interne_35, s0_.societe_cotee AS societe_cotee_36, s0_.login_demande_publication AS login_demande_publication_37, s0_.date_relance AS date_relance_38, s0_.relance_mise_a_jour AS relance_mise_a_jour_39, s0_.numero_siren AS numero_siren_40, s0_.montant_total_investi AS montant_total_investi_41, s0_.capital_total_investisseur AS capital_total_investisseur_42, s0_.titre_newsletter AS titre_newsletter_43, s0_.resume_newsletter AS resume_newsletter_44, s0_.date_dernier_investissement AS date_dernier_investissement_45, s0_.type_profil_participation AS type_profil_participation_46, s0_.mode_societe AS mode_societe_47, s0_.utiliser_artviper AS utiliser_artviper_48, s0_.numero_siret AS numero_siret_49, s0_.code_naf AS code_naf_50, s0_.vignette AS vignette_51, s0_.vignette_small AS vignette_small_52, s0_.ca_n_inf AS ca_n_inf_53, s0_.ca_n_sup AS ca_n_sup_54, s0_.id_societe_mere AS id_societe_mere_55, s0_.date_maj_administrateur AS date_maj_administrateur_56, s0_.administrateur AS administrateur_57, s0_.etat_resume AS etat_resume_58, s0_.afficher_vendeur AS afficher_vendeur_59, s0_.afficher_acheteur AS afficher_acheteur_60 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 AND s0_.id_societe IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY s0_.id_societe ORDER BY s0_.ca_n DESC, s0_.date_dernier_investissement ASC, s0_.id_societe DESC
SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC
SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC
SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC
SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC
SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC
SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC
SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC
SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC
SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC
SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC
SELECT d0_.value AS value_0 FROM partage_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 t0.id_societe AS id_societe_1, t0.id_societe_news AS id_societe_news_2, t0.id_participation AS id_participation_3, t0.mode_participation AS mode_participation_4, t0.deja_publique AS deja_publique_5, t0.raison_sociale AS raison_sociale_6, t0.raison_sociale_formatee AS raison_sociale_formatee_7, t0.nom_president AS nom_president_8, t0.nom_directeur_general AS nom_directeur_general_9, t0.adresse AS adresse_10, t0.ville AS ville_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.id_pays AS id_pays_15, t0.devise AS devise_16, t0.id_region AS id_region_17, t0.filiales_bureaux AS filiales_bureaux_18, t0.id_secteur_activite AS id_secteur_activite_19, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20, t0.site_internet AS site_internet_21, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22, t0.mail_contact AS mail_contact_23, t0.resume_activite AS resume_activite_24, t0.description_activite AS description_activite_25, t0.mots_cles AS mots_cles_26, t0.strategie_developpement AS strategie_developpement_27, t0.marge_brute_n AS marge_brute_n_28, t0.resultat_exploitation_n AS resultat_exploitation_n_29, t0.resultat_net_n AS resultat_net_n_30, t0.ca_n AS ca_n_31, t0.nb_personnes_n AS nb_personnes_n_32, t0.annee_n AS annee_n_33, t0.date_mise_a_jour AS date_mise_a_jour_34, t0.fichier_joint AS fichier_joint_35, t0.commentaire_interne AS commentaire_interne_36, t0.societe_cotee AS societe_cotee_37, t0.login_demande_publication AS login_demande_publication_38, t0.date_relance AS date_relance_39, t0.relance_mise_a_jour AS relance_mise_a_jour_40, t0.numero_siren AS numero_siren_41, t0.montant_total_investi AS montant_total_investi_42, t0.capital_total_investisseur AS capital_total_investisseur_43, t0.titre_newsletter AS titre_newsletter_44, t0.resume_newsletter AS resume_newsletter_45, t0.date_dernier_investissement AS date_dernier_investissement_46, t0.type_profil_participation AS type_profil_participation_47, t0.mode_societe AS mode_societe_48, t0.utiliser_artviper AS utiliser_artviper_49, t0.numero_siret AS numero_siret_50, t0.code_naf AS code_naf_51, t0.vignette AS vignette_52, t0.vignette_small AS vignette_small_53, t0.ca_n_inf AS ca_n_inf_54, t0.ca_n_sup AS ca_n_sup_55, t0.id_societe_mere AS id_societe_mere_56, t0.date_maj_administrateur AS date_maj_administrateur_57, t0.administrateur AS administrateur_58, t0.etat_resume AS etat_resume_59, t0.afficher_vendeur AS afficher_vendeur_60, t0.afficher_acheteur AS afficher_acheteur_61 FROM fusacq_dbo.societes t0 WHERE t0.id_societe = ? LIMIT 1
SELECT s0_.raison_sociale AS raison_sociale_0, s0_.id_societe AS id_societe_1, l1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_2 FROM fusacq_dbo.societes s0_ LEFT JOIN fusacq_dbo.lien_participations_fonds l1_ ON (s0_.id_societe = l1_.id_participation) WHERE s0_.id_societe = ? AND l1_.id_gestionnaire_fonds <> ? LIMIT 10000

#▲	Time	Info
1	11.28 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_13%"`] 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_13%' ORDER BY v0_.population DESC LIMIT 3;
2	10.56 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: [`"60316" "33_13_11"`] 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 = '60316' AND (a0_.id_departement = '33_13_11');
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: [`"60316" "33_13_11"`] 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 = '60316' AND (a0_.id_departement = '33_13_11');
4	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';
5	10.38 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_maximale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON ( p1_.id_parametre_site = d0_.id_parametre_site ) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
6	10.33 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.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_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.51 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: [`"11%"`] 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 '11%') AND s0_.afficher_vendeur = 1;
9	10.01 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: [`"60316" "33_13_11" "33_13_11%" "%,33_13_11%"`] 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 = '60316' AND ((a0_.id_departement = '33_13_11' OR a0_.autres_localisations LIKE '33_13_11%' OR a0_.autres_localisations LIKE '%,33_13_11%'));
10	10.12 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: [`"60316" "33_13_30"`] 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 = '60316' AND (a0_.id_departement = '33_13_30');
11	16.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 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: [`"60316" "33_13_30"`] 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 = '60316' AND (a0_.id_departement = '33_13_30');
12	10.13 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.26 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_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.28 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_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.18 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	75.44 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: [`"30%"`] 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 '30%') AND s0_.afficher_vendeur = 1;
17	9.91 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: [`"60316" "33_13_30" "33_13_30%" "%,33_13_30%"`] 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 = '60316' AND ((a0_.id_departement = '33_13_30' OR a0_.autres_localisations LIKE '33_13_30%' OR a0_.autres_localisations LIKE '%,33_13_30%'));
18	10.10 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: [`"60316" "33_13_34"`] 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 = '60316' AND (a0_.id_departement = '33_13_34');
19	10.31 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: [`"60316" "33_13_34"`] 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 = '60316' AND (a0_.id_departement = '33_13_34');
20	10.14 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.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_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	9.89 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_minimale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON ( p1_.id_parametre_site = d0_.id_parametre_site ) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
23	9.86 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_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	67.64 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: [`"34%"`] 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 '34%') AND s0_.afficher_vendeur = 1;
25	9.89 ms	SELECT COUNT(DISTINCT a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND a0_.id_secteur_activite = ? AND ((a0_.id_departement = ? OR a0_.autres_localisations LIKE ? OR a0_.autres_localisations LIKE ?)) Parameters: [`"60316" "33_13_34" "33_13_34%" "%,33_13_34%"`] 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 = '60316' AND ((a0_.id_departement = '33_13_34' OR a0_.autres_localisations LIKE '33_13_34%' OR a0_.autres_localisations LIKE '%,33_13_34%'));
26	10.11 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: [`"60316" "33_13_48"`] 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 = '60316' AND (a0_.id_departement = '33_13_48');
27	10.16 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: [`"60316" "33_13_48"`] 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 = '60316' AND (a0_.id_departement = '33_13_48');
28	9.87 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_minimale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON ( p1_.id_parametre_site = d0_.id_parametre_site ) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
29	9.86 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_maximale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON ( p1_.id_parametre_site = d0_.id_parametre_site ) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
30	9.85 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_minimale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON ( p1_.id_parametre_site = d0_.id_parametre_site ) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
31	9.85 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	82.22 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: [`"48%"`] 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 '48%') AND s0_.afficher_vendeur = 1;
33	9.82 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: [`"60316" "33_13_48" "33_13_48%" "%,33_13_48%"`] 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 = '60316' AND ((a0_.id_departement = '33_13_48' OR a0_.autres_localisations LIKE '33_13_48%' OR a0_.autres_localisations LIKE '%,33_13_48%'));
34	10.31 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: [`"60316" "33_13_66"`] 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 = '60316' AND (a0_.id_departement = '33_13_66');
35	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 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: [`"60316" "33_13_66"`] 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 = '60316' AND (a0_.id_departement = '33_13_66');
36	10.14 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_minimale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON ( p1_.id_parametre_site = d0_.id_parametre_site ) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
37	9.84 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_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	9.96 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_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	9.89 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	60.93 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: [`"66%"`] 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 '66%') AND s0_.afficher_vendeur = 1;
41	9.73 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: [`"60316" "33_13_66" "33_13_66%" "%,33_13_66%"`] 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 = '60316' AND ((a0_.id_departement = '33_13_66' OR a0_.autres_localisations LIKE '33_13_66%' OR a0_.autres_localisations LIKE '%,33_13_66%'));
42	9.80 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite = ? AND (a0_.id_departement = ?) Parameters: [`"60316" "33_13_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 = '60316' AND (a0_.id_departement = '33_13_99');
43	10.80 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL 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: [`"60316" "33_13_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 = '60316' AND (a0_.id_departement = '33_13_99');
44	10.08 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_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.13 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.23 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.24 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	64.93 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;
49	9.77 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: [`"60316" "33_13_99" "33_13_99%" "%,33_13_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 = '60316' AND ((a0_.id_departement = '33_13_99' OR a0_.autres_localisations LIKE '33_13_99%' OR a0_.autres_localisations LIKE '%,33_13_99%'));
50	9.77 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;
51	9.81 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: [`"603"`] 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 = '603' LIMIT 1;
52	9.86 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: [`"60316"`] 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 = '60316' LIMIT 1;
53	9.96 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: [`"60316" "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 = '60316' AND (s0_.obsolete <> 'oui' OR s0_.obsolete IS NULL) ORDER BY s0_.nom_secteur_activite ASC;
54	10.75 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: [`"60316" "33_13"`] 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 = '60316' AND (a0_.id_region = '33_13');
55	10.90 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: [`"60316" "33_13"`] 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 = '60316' AND (a0_.id_region = '33_13');
56	10.30 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';
57	10.33 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';
58	10.22 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';
59	10.29 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';
60	70.83 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_13"`] 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_13') AND s0_.afficher_vendeur = 1;
61	10.00 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: [`"60316" "33_13" "33_99" "33_13%" "%,33_13%" "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 = '60316' AND ((a0_.id_region = '33_13' OR a0_.id_region = '33_99' OR a0_.autres_localisations LIKE '33_13%' OR a0_.autres_localisations LIKE '%,33_13%') 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')));
62	9.93 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	9.99 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_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	10.14 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';
65	10.29 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';
66	67.61 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 GROUP BY s0_.id_societe Parameters: [`"33_13"`] 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 GROUP BY s0_.id_societe 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_13') AND s0_.afficher_vendeur = 1 GROUP BY s0_.id_societe;
67	42.99 ms	SELECT DISTINCT s0_.id_societe AS id_societe_0, s0_.ca_n AS ca_n_1, s0_.date_dernier_investissement AS date_dernier_investissement_2, s0_.id_societe AS id_societe_3 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 GROUP BY s0_.id_societe ORDER BY s0_.ca_n DESC, s0_.date_dernier_investissement ASC, s0_.id_societe DESC LIMIT 10 Parameters: [`"33_13"`] View formatted query View runnable query Explain query SELECT DISTINCT s0_.id_societe AS id_societe_0, s0_.ca_n AS ca_n_1, s0_.date_dernier_investissement AS date_dernier_investissement_2, s0_.id_societe AS id_societe_3 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 GROUP BY s0_.id_societe ORDER BY s0_.ca_n DESC, s0_.date_dernier_investissement ASC, s0_.id_societe DESC LIMIT 10 SELECT DISTINCT s0_.id_societe AS id_societe_0, s0_.ca_n AS ca_n_1, s0_.date_dernier_investissement AS date_dernier_investissement_2, s0_.id_societe AS id_societe_3 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_13') AND s0_.afficher_vendeur = 1 GROUP BY s0_.id_societe ORDER BY s0_.ca_n DESC, s0_.date_dernier_investissement ASC, s0_.id_societe DESC LIMIT 10;
68	20.23 ms	SELECT s0_.id_societe AS id_societe_0, s0_.id_societe_news AS id_societe_news_1, s0_.id_participation AS id_participation_2, s0_.mode_participation AS mode_participation_3, s0_.deja_publique AS deja_publique_4, s0_.raison_sociale AS raison_sociale_5, s0_.raison_sociale_formatee AS raison_sociale_formatee_6, s0_.nom_president AS nom_president_7, s0_.nom_directeur_general AS nom_directeur_general_8, s0_.adresse AS adresse_9, s0_.ville AS ville_10, s0_.code_postal AS code_postal_11, s0_.telephone AS telephone_12, s0_.fax AS fax_13, s0_.id_pays AS id_pays_14, s0_.devise AS devise_15, s0_.id_region AS id_region_16, s0_.filiales_bureaux AS filiales_bureaux_17, s0_.id_secteur_activite AS id_secteur_activite_18, s0_.id_secteur_activite_fonds AS id_secteur_activite_fonds_19, s0_.site_internet AS site_internet_20, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_21, s0_.mail_contact AS mail_contact_22, s0_.resume_activite AS resume_activite_23, s0_.description_activite AS description_activite_24, s0_.mots_cles AS mots_cles_25, s0_.strategie_developpement AS strategie_developpement_26, s0_.marge_brute_n AS marge_brute_n_27, s0_.resultat_exploitation_n AS resultat_exploitation_n_28, s0_.resultat_net_n AS resultat_net_n_29, s0_.ca_n AS ca_n_30, s0_.nb_personnes_n AS nb_personnes_n_31, s0_.annee_n AS annee_n_32, s0_.date_mise_a_jour AS date_mise_a_jour_33, s0_.fichier_joint AS fichier_joint_34, s0_.commentaire_interne AS commentaire_interne_35, s0_.societe_cotee AS societe_cotee_36, s0_.login_demande_publication AS login_demande_publication_37, s0_.date_relance AS date_relance_38, s0_.relance_mise_a_jour AS relance_mise_a_jour_39, s0_.numero_siren AS numero_siren_40, s0_.montant_total_investi AS montant_total_investi_41, s0_.capital_total_investisseur AS capital_total_investisseur_42, s0_.titre_newsletter AS titre_newsletter_43, s0_.resume_newsletter AS resume_newsletter_44, s0_.date_dernier_investissement AS date_dernier_investissement_45, s0_.type_profil_participation AS type_profil_participation_46, s0_.mode_societe AS mode_societe_47, s0_.utiliser_artviper AS utiliser_artviper_48, s0_.numero_siret AS numero_siret_49, s0_.code_naf AS code_naf_50, s0_.vignette AS vignette_51, s0_.vignette_small AS vignette_small_52, s0_.ca_n_inf AS ca_n_inf_53, s0_.ca_n_sup AS ca_n_sup_54, s0_.id_societe_mere AS id_societe_mere_55, s0_.date_maj_administrateur AS date_maj_administrateur_56, s0_.administrateur AS administrateur_57, s0_.etat_resume AS etat_resume_58, s0_.afficher_vendeur AS afficher_vendeur_59, s0_.afficher_acheteur AS afficher_acheteur_60 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 AND s0_.id_societe IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY s0_.id_societe ORDER BY s0_.ca_n DESC, s0_.date_dernier_investissement ASC, s0_.id_societe DESC Parameters: [`"33_13" 9071 27621 30711 12227 5476 44396 31640 33816 24684 10070`] View formatted query View runnable query Explain query SELECT s0_.id_societe AS id_societe_0, s0_.id_societe_news AS id_societe_news_1, s0_.id_participation AS id_participation_2, s0_.mode_participation AS mode_participation_3, s0_.deja_publique AS deja_publique_4, s0_.raison_sociale AS raison_sociale_5, s0_.raison_sociale_formatee AS raison_sociale_formatee_6, s0_.nom_president AS nom_president_7, s0_.nom_directeur_general AS nom_directeur_general_8, s0_.adresse AS adresse_9, s0_.ville AS ville_10, s0_.code_postal AS code_postal_11, s0_.telephone AS telephone_12, s0_.fax AS fax_13, s0_.id_pays AS id_pays_14, s0_.devise AS devise_15, s0_.id_region AS id_region_16, s0_.filiales_bureaux AS filiales_bureaux_17, s0_.id_secteur_activite AS id_secteur_activite_18, s0_.id_secteur_activite_fonds AS id_secteur_activite_fonds_19, s0_.site_internet AS site_internet_20, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_21, s0_.mail_contact AS mail_contact_22, s0_.resume_activite AS resume_activite_23, s0_.description_activite AS description_activite_24, s0_.mots_cles AS mots_cles_25, s0_.strategie_developpement AS strategie_developpement_26, s0_.marge_brute_n AS marge_brute_n_27, s0_.resultat_exploitation_n AS resultat_exploitation_n_28, s0_.resultat_net_n AS resultat_net_n_29, s0_.ca_n AS ca_n_30, s0_.nb_personnes_n AS nb_personnes_n_31, s0_.annee_n AS annee_n_32, s0_.date_mise_a_jour AS date_mise_a_jour_33, s0_.fichier_joint AS fichier_joint_34, s0_.commentaire_interne AS commentaire_interne_35, s0_.societe_cotee AS societe_cotee_36, s0_.login_demande_publication AS login_demande_publication_37, s0_.date_relance AS date_relance_38, s0_.relance_mise_a_jour AS relance_mise_a_jour_39, s0_.numero_siren AS numero_siren_40, s0_.montant_total_investi AS montant_total_investi_41, s0_.capital_total_investisseur AS capital_total_investisseur_42, s0_.titre_newsletter AS titre_newsletter_43, s0_.resume_newsletter AS resume_newsletter_44, s0_.date_dernier_investissement AS date_dernier_investissement_45, s0_.type_profil_participation AS type_profil_participation_46, s0_.mode_societe AS mode_societe_47, s0_.utiliser_artviper AS utiliser_artviper_48, s0_.numero_siret AS numero_siret_49, s0_.code_naf AS code_naf_50, s0_.vignette AS vignette_51, s0_.vignette_small AS vignette_small_52, s0_.ca_n_inf AS ca_n_inf_53, s0_.ca_n_sup AS ca_n_sup_54, s0_.id_societe_mere AS id_societe_mere_55, s0_.date_maj_administrateur AS date_maj_administrateur_56, s0_.administrateur AS administrateur_57, s0_.etat_resume AS etat_resume_58, s0_.afficher_vendeur AS afficher_vendeur_59, s0_.afficher_acheteur AS afficher_acheteur_60 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 AND s0_.id_societe IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY s0_.id_societe ORDER BY s0_.ca_n DESC, s0_.date_dernier_investissement ASC, s0_.id_societe DESC SELECT s0_.id_societe AS id_societe_0, s0_.id_societe_news AS id_societe_news_1, s0_.id_participation AS id_participation_2, s0_.mode_participation AS mode_participation_3, s0_.deja_publique AS deja_publique_4, s0_.raison_sociale AS raison_sociale_5, s0_.raison_sociale_formatee AS raison_sociale_formatee_6, s0_.nom_president AS nom_president_7, s0_.nom_directeur_general AS nom_directeur_general_8, s0_.adresse AS adresse_9, s0_.ville AS ville_10, s0_.code_postal AS code_postal_11, s0_.telephone AS telephone_12, s0_.fax AS fax_13, s0_.id_pays AS id_pays_14, s0_.devise AS devise_15, s0_.id_region AS id_region_16, s0_.filiales_bureaux AS filiales_bureaux_17, s0_.id_secteur_activite AS id_secteur_activite_18, s0_.id_secteur_activite_fonds AS id_secteur_activite_fonds_19, s0_.site_internet AS site_internet_20, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_21, s0_.mail_contact AS mail_contact_22, s0_.resume_activite AS resume_activite_23, s0_.description_activite AS description_activite_24, s0_.mots_cles AS mots_cles_25, s0_.strategie_developpement AS strategie_developpement_26, s0_.marge_brute_n AS marge_brute_n_27, s0_.resultat_exploitation_n AS resultat_exploitation_n_28, s0_.resultat_net_n AS resultat_net_n_29, s0_.ca_n AS ca_n_30, s0_.nb_personnes_n AS nb_personnes_n_31, s0_.annee_n AS annee_n_32, s0_.date_mise_a_jour AS date_mise_a_jour_33, s0_.fichier_joint AS fichier_joint_34, s0_.commentaire_interne AS commentaire_interne_35, s0_.societe_cotee AS societe_cotee_36, s0_.login_demande_publication AS login_demande_publication_37, s0_.date_relance AS date_relance_38, s0_.relance_mise_a_jour AS relance_mise_a_jour_39, s0_.numero_siren AS numero_siren_40, s0_.montant_total_investi AS montant_total_investi_41, s0_.capital_total_investisseur AS capital_total_investisseur_42, s0_.titre_newsletter AS titre_newsletter_43, s0_.resume_newsletter AS resume_newsletter_44, s0_.date_dernier_investissement AS date_dernier_investissement_45, s0_.type_profil_participation AS type_profil_participation_46, s0_.mode_societe AS mode_societe_47, s0_.utiliser_artviper AS utiliser_artviper_48, s0_.numero_siret AS numero_siret_49, s0_.code_naf AS code_naf_50, s0_.vignette AS vignette_51, s0_.vignette_small AS vignette_small_52, s0_.ca_n_inf AS ca_n_inf_53, s0_.ca_n_sup AS ca_n_sup_54, s0_.id_societe_mere AS id_societe_mere_55, s0_.date_maj_administrateur AS date_maj_administrateur_56, s0_.administrateur AS administrateur_57, s0_.etat_resume AS etat_resume_58, s0_.afficher_vendeur AS afficher_vendeur_59, s0_.afficher_acheteur AS afficher_acheteur_60 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_13') AND s0_.afficher_vendeur = 1 AND s0_.id_societe IN (9071, 27621, 30711, 12227, 5476, 44396, 31640, 33816, 24684, 10070) GROUP BY s0_.id_societe ORDER BY s0_.ca_n DESC, s0_.date_dernier_investissement ASC, s0_.id_societe DESC;
69	10.75 ms	SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC Parameters: [`9071`] View formatted query View runnable query Explain query SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON ( s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds ) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = 9071 AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC;
70	10.67 ms	SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC Parameters: [`27621`] View formatted query View runnable query Explain query SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON ( s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds ) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = 27621 AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC;
71	10.76 ms	SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC Parameters: [`30711`] View formatted query View runnable query Explain query SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON ( s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds ) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = 30711 AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC;
72	10.74 ms	SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC Parameters: [`12227`] View formatted query View runnable query Explain query SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON ( s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds ) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = 12227 AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC;
73	10.92 ms	SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC Parameters: [`5476`] View formatted query View runnable query Explain query SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON ( s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds ) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = 5476 AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC;
74	10.68 ms	SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC Parameters: [`44396`] View formatted query View runnable query Explain query SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON ( s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds ) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = 44396 AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC;
75	10.83 ms	SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC Parameters: [`31640`] View formatted query View runnable query Explain query SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON ( s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds ) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = 31640 AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC;
76	10.72 ms	SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC Parameters: [`33816`] View formatted query View runnable query Explain query SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON ( s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds ) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = 33816 AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC;
77	17.11 ms	SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC Parameters: [`24684`] View formatted query View runnable query Explain query SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON ( s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds ) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = 24684 AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC;
78	10.73 ms	SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC Parameters: [`10070`] View formatted query View runnable query Explain query SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON ( s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds ) WHERE l0_.id_participation = ? AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = 10070 AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC;
79	10.22 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: [`"id_participation_exemple" "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 = 'id_participation_exemple' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
80	10.39 ms	SELECT t0.id_societe AS id_societe_1, t0.id_societe_news AS id_societe_news_2, t0.id_participation AS id_participation_3, t0.mode_participation AS mode_participation_4, t0.deja_publique AS deja_publique_5, t0.raison_sociale AS raison_sociale_6, t0.raison_sociale_formatee AS raison_sociale_formatee_7, t0.nom_president AS nom_president_8, t0.nom_directeur_general AS nom_directeur_general_9, t0.adresse AS adresse_10, t0.ville AS ville_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.id_pays AS id_pays_15, t0.devise AS devise_16, t0.id_region AS id_region_17, t0.filiales_bureaux AS filiales_bureaux_18, t0.id_secteur_activite AS id_secteur_activite_19, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20, t0.site_internet AS site_internet_21, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22, t0.mail_contact AS mail_contact_23, t0.resume_activite AS resume_activite_24, t0.description_activite AS description_activite_25, t0.mots_cles AS mots_cles_26, t0.strategie_developpement AS strategie_developpement_27, t0.marge_brute_n AS marge_brute_n_28, t0.resultat_exploitation_n AS resultat_exploitation_n_29, t0.resultat_net_n AS resultat_net_n_30, t0.ca_n AS ca_n_31, t0.nb_personnes_n AS nb_personnes_n_32, t0.annee_n AS annee_n_33, t0.date_mise_a_jour AS date_mise_a_jour_34, t0.fichier_joint AS fichier_joint_35, t0.commentaire_interne AS commentaire_interne_36, t0.societe_cotee AS societe_cotee_37, t0.login_demande_publication AS login_demande_publication_38, t0.date_relance AS date_relance_39, t0.relance_mise_a_jour AS relance_mise_a_jour_40, t0.numero_siren AS numero_siren_41, t0.montant_total_investi AS montant_total_investi_42, t0.capital_total_investisseur AS capital_total_investisseur_43, t0.titre_newsletter AS titre_newsletter_44, t0.resume_newsletter AS resume_newsletter_45, t0.date_dernier_investissement AS date_dernier_investissement_46, t0.type_profil_participation AS type_profil_participation_47, t0.mode_societe AS mode_societe_48, t0.utiliser_artviper AS utiliser_artviper_49, t0.numero_siret AS numero_siret_50, t0.code_naf AS code_naf_51, t0.vignette AS vignette_52, t0.vignette_small AS vignette_small_53, t0.ca_n_inf AS ca_n_inf_54, t0.ca_n_sup AS ca_n_sup_55, t0.id_societe_mere AS id_societe_mere_56, t0.date_maj_administrateur AS date_maj_administrateur_57, t0.administrateur AS administrateur_58, t0.etat_resume AS etat_resume_59, t0.afficher_vendeur AS afficher_vendeur_60, t0.afficher_acheteur AS afficher_acheteur_61 FROM fusacq_dbo.societes t0 WHERE t0.id_societe = ? LIMIT 1 Parameters: [`"41562"`] View formatted query View runnable query Explain query SELECT t0.id_societe AS id_societe_1, t0.id_societe_news AS id_societe_news_2, t0.id_participation AS id_participation_3, t0.mode_participation AS mode_participation_4, t0.deja_publique AS deja_publique_5, t0.raison_sociale AS raison_sociale_6, t0.raison_sociale_formatee AS raison_sociale_formatee_7, t0.nom_president AS nom_president_8, t0.nom_directeur_general AS nom_directeur_general_9, t0.adresse AS adresse_10, t0.ville AS ville_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.id_pays AS id_pays_15, t0.devise AS devise_16, t0.id_region AS id_region_17, t0.filiales_bureaux AS filiales_bureaux_18, t0.id_secteur_activite AS id_secteur_activite_19, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20, t0.site_internet AS site_internet_21, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22, t0.mail_contact AS mail_contact_23, t0.resume_activite AS resume_activite_24, t0.description_activite AS description_activite_25, t0.mots_cles AS mots_cles_26, t0.strategie_developpement AS strategie_developpement_27, t0.marge_brute_n AS marge_brute_n_28, t0.resultat_exploitation_n AS resultat_exploitation_n_29, t0.resultat_net_n AS resultat_net_n_30, t0.ca_n AS ca_n_31, t0.nb_personnes_n AS nb_personnes_n_32, t0.annee_n AS annee_n_33, t0.date_mise_a_jour AS date_mise_a_jour_34, t0.fichier_joint AS fichier_joint_35, t0.commentaire_interne AS commentaire_interne_36, t0.societe_cotee AS societe_cotee_37, t0.login_demande_publication AS login_demande_publication_38, t0.date_relance AS date_relance_39, t0.relance_mise_a_jour AS relance_mise_a_jour_40, t0.numero_siren AS numero_siren_41, t0.montant_total_investi AS montant_total_investi_42, t0.capital_total_investisseur AS capital_total_investisseur_43, t0.titre_newsletter AS titre_newsletter_44, t0.resume_newsletter AS resume_newsletter_45, t0.date_dernier_investissement AS date_dernier_investissement_46, t0.type_profil_participation AS type_profil_participation_47, t0.mode_societe AS mode_societe_48, t0.utiliser_artviper AS utiliser_artviper_49, t0.numero_siret AS numero_siret_50, t0.code_naf AS code_naf_51, t0.vignette AS vignette_52, t0.vignette_small AS vignette_small_53, t0.ca_n_inf AS ca_n_inf_54, t0.ca_n_sup AS ca_n_sup_55, t0.id_societe_mere AS id_societe_mere_56, t0.date_maj_administrateur AS date_maj_administrateur_57, t0.administrateur AS administrateur_58, t0.etat_resume AS etat_resume_59, t0.afficher_vendeur AS afficher_vendeur_60, t0.afficher_acheteur AS afficher_acheteur_61 FROM fusacq_dbo.societes t0 WHERE t0.id_societe = ? LIMIT 1 SELECT t0.id_societe AS id_societe_1, t0.id_societe_news AS id_societe_news_2, t0.id_participation AS id_participation_3, t0.mode_participation AS mode_participation_4, t0.deja_publique AS deja_publique_5, t0.raison_sociale AS raison_sociale_6, t0.raison_sociale_formatee AS raison_sociale_formatee_7, t0.nom_president AS nom_president_8, t0.nom_directeur_general AS nom_directeur_general_9, t0.adresse AS adresse_10, t0.ville AS ville_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.id_pays AS id_pays_15, t0.devise AS devise_16, t0.id_region AS id_region_17, t0.filiales_bureaux AS filiales_bureaux_18, t0.id_secteur_activite AS id_secteur_activite_19, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20, t0.site_internet AS site_internet_21, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22, t0.mail_contact AS mail_contact_23, t0.resume_activite AS resume_activite_24, t0.description_activite AS description_activite_25, t0.mots_cles AS mots_cles_26, t0.strategie_developpement AS strategie_developpement_27, t0.marge_brute_n AS marge_brute_n_28, t0.resultat_exploitation_n AS resultat_exploitation_n_29, t0.resultat_net_n AS resultat_net_n_30, t0.ca_n AS ca_n_31, t0.nb_personnes_n AS nb_personnes_n_32, t0.annee_n AS annee_n_33, t0.date_mise_a_jour AS date_mise_a_jour_34, t0.fichier_joint AS fichier_joint_35, t0.commentaire_interne AS commentaire_interne_36, t0.societe_cotee AS societe_cotee_37, t0.login_demande_publication AS login_demande_publication_38, t0.date_relance AS date_relance_39, t0.relance_mise_a_jour AS relance_mise_a_jour_40, t0.numero_siren AS numero_siren_41, t0.montant_total_investi AS montant_total_investi_42, t0.capital_total_investisseur AS capital_total_investisseur_43, t0.titre_newsletter AS titre_newsletter_44, t0.resume_newsletter AS resume_newsletter_45, t0.date_dernier_investissement AS date_dernier_investissement_46, t0.type_profil_participation AS type_profil_participation_47, t0.mode_societe AS mode_societe_48, t0.utiliser_artviper AS utiliser_artviper_49, t0.numero_siret AS numero_siret_50, t0.code_naf AS code_naf_51, t0.vignette AS vignette_52, t0.vignette_small AS vignette_small_53, t0.ca_n_inf AS ca_n_inf_54, t0.ca_n_sup AS ca_n_sup_55, t0.id_societe_mere AS id_societe_mere_56, t0.date_maj_administrateur AS date_maj_administrateur_57, t0.administrateur AS administrateur_58, t0.etat_resume AS etat_resume_59, t0.afficher_vendeur AS afficher_vendeur_60, t0.afficher_acheteur AS afficher_acheteur_61 FROM fusacq_dbo.societes t0 WHERE t0.id_societe = '41562' LIMIT 1;
81	10.22 ms	SELECT s0_.raison_sociale AS raison_sociale_0, s0_.id_societe AS id_societe_1, l1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_2 FROM fusacq_dbo.societes s0_ LEFT JOIN fusacq_dbo.lien_participations_fonds l1_ ON (s0_.id_societe = l1_.id_participation) WHERE s0_.id_societe = ? AND l1_.id_gestionnaire_fonds <> ? LIMIT 10000 Parameters: [`"41562" "null"`] View formatted query View runnable query Explain query SELECT s0_.raison_sociale AS raison_sociale_0, s0_.id_societe AS id_societe_1, l1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_2 FROM fusacq_dbo.societes s0_ LEFT JOIN fusacq_dbo.lien_participations_fonds l1_ ON ( s0_.id_societe = l1_.id_participation ) WHERE s0_.id_societe = ? AND l1_.id_gestionnaire_fonds <> ? LIMIT 10000 SELECT s0_.raison_sociale AS raison_sociale_0, s0_.id_societe AS id_societe_1, l1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_2 FROM fusacq_dbo.societes s0_ LEFT JOIN fusacq_dbo.lien_participations_fonds l1_ ON (s0_.id_societe = l1_.id_participation) WHERE s0_.id_societe = '41562' AND l1_.id_gestionnaire_fonds <> 'null' LIMIT 10000;

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\SocieteGestionnaireFonds	No errors.
App\Entity\Translation	No errors.

Symfony Profiler

https://preprod.fusacq.com/cible-potentielle-fab-distribution-de-piscines-languedoc-roussillon,r33_13,60316_fr_?page=1

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping