Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

64 Database Queries

14 Different statements

1136.71 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT t0.id_secteur_activite AS id_secteur_activite_1, t0.nom_secteur_activite AS nom_secteur_activite_2, t0.obsolete AS obsolete_3, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4, t0.site_partenaire AS site_partenaire_5, t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6, t0.id_secteur_activite_pere AS id_secteur_activite_pere_7, t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8, t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9, t0.nom_pour_TITLE AS nom_pour_TITLE_10, t0.rare AS rare_11, t0.recherche AS recherche_12, t0.image_filename AS image_filename_13 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = ? LIMIT 1
SELECT t0.id_secteur_activite AS id_secteur_activite_1, t0.nom_secteur_activite AS nom_secteur_activite_2, t0.obsolete AS obsolete_3, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4, t0.site_partenaire AS site_partenaire_5, t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6, t0.id_secteur_activite_pere AS id_secteur_activite_pere_7, t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8, t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9, t0.nom_pour_TITLE AS nom_pour_TITLE_10, t0.rare AS rare_11, t0.recherche AS recherche_12, t0.image_filename AS image_filename_13 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = ? LIMIT 1
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 = ?
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 = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.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 = ?
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 = ?
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 = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.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 = ?
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 = ?
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 = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.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 = ?
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 = ?
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 = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.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 = ?
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 = ?
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 = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.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 = ?
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 = ?
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 = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ?
SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.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 = ?
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 LIKE ?
SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND a0_.id_secteur_activite 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 >= 201105 AND l1_.date_investissement <= 202105 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 LIKE ?
SELECT DISTINCT COUNT(DISTINCT a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND a0_.id_secteur_activite LIKE ?
SELECT DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.ca_max AS ca_max_1, a0_.id_annonce_acheteur AS id_annonce_acheteur_2 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND a0_.id_secteur_activite LIKE ? ORDER BY a0_.ca_max DESC, a0_.id_annonce_acheteur DESC LIMIT 10
SELECT DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.date_parution_initiale AS date_parution_initiale_2, a0_.date_parution AS date_parution_3, a0_.ca_max AS ca_max_4, a0_.apport_perso_repreneur AS apport_perso_repreneur_5, a0_.id_pays AS id_pays_6, a0_.id_region AS id_region_7, a0_.id_departement AS id_departement_8, a0_.autres_localisations AS autres_localisations_9, a0_.type_acquereur AS type_acquereur_10, a0_.id_langue AS id_langue_11 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND a0_.id_secteur_activite LIKE ? AND a0_.id_annonce_acheteur IN (?, ?, ?) ORDER BY a0_.ca_max DESC, a0_.id_annonce_acheteur DESC
SELECT t0_.id_translation AS id_translation_0, t0_.md5_fr AS md5_fr_1, t0_.texte_fr AS texte_fr_2, t0_.contexte_fr AS contexte_fr_3, t0_.md5_en AS md5_en_4, t0_.texte_en AS texte_en_5, t0_.contexte_en AS contexte_en_6, t0_.md5_fr_ca AS md5_fr_ca_7, t0_.texte_fr_ca AS texte_fr_ca_8, t0_.contexte_fr_ca AS contexte_fr_ca_9, t0_.md5_generique AS md5_generique_10, t0_.texte_generique AS texte_generique_11, t0_.contexte_generique AS contexte_generique_12, t0_.md5_es AS md5_es_13, t0_.texte_es AS texte_es_14, t0_.contexte_es AS contexte_es_15, t0_.md5_de AS md5_de_16, t0_.texte_de AS texte_de_17, t0_.contexte_de AS contexte_de_18, t0_.md5_nl AS md5_nl_19, t0_.texte_nl AS texte_nl_20, t0_.contexte_nl AS contexte_nl_21, t0_.md5_it AS md5_it_22, t0_.texte_it AS texte_it_23, t0_.contexte_it AS contexte_it_24, t0_.etat_en AS etat_en_25, t0_.etat_es AS etat_es_26, t0_.etat_de AS etat_de_27, t0_.etat_nl AS etat_nl_28, t0_.etat_it AS etat_it_29, t0_.etat_fr_ca AS etat_fr_ca_30, t0_.traduit_deepl AS traduit_deepl_31, t0_.created_at AS created_at_32, t0_.page_url AS page_url_33, t0_.etat_fr_ch AS etat_fr_ch_34, t0_.md5_fr_ch AS md5_fr_ch_35, t0_.texte_fr_ch AS texte_fr_ch_36, t0_.contexte_fr_ch AS contexte_fr_ch_37 FROM partage_dbo.translation t1_, partage_dbo.translation t0_ WHERE t0_.md5_generique = ?
SELECT t0_.id_translation AS id_translation_0, t0_.md5_fr AS md5_fr_1, t0_.texte_fr AS texte_fr_2, t0_.contexte_fr AS contexte_fr_3, t0_.md5_en AS md5_en_4, t0_.texte_en AS texte_en_5, t0_.contexte_en AS contexte_en_6, t0_.md5_fr_ca AS md5_fr_ca_7, t0_.texte_fr_ca AS texte_fr_ca_8, t0_.contexte_fr_ca AS contexte_fr_ca_9, t0_.md5_generique AS md5_generique_10, t0_.texte_generique AS texte_generique_11, t0_.contexte_generique AS contexte_generique_12, t0_.md5_es AS md5_es_13, t0_.texte_es AS texte_es_14, t0_.contexte_es AS contexte_es_15, t0_.md5_de AS md5_de_16, t0_.texte_de AS texte_de_17, t0_.contexte_de AS contexte_de_18, t0_.md5_nl AS md5_nl_19, t0_.texte_nl AS texte_nl_20, t0_.contexte_nl AS contexte_nl_21, t0_.md5_it AS md5_it_22, t0_.texte_it AS texte_it_23, t0_.contexte_it AS contexte_it_24, t0_.etat_en AS etat_en_25, t0_.etat_es AS etat_es_26, t0_.etat_de AS etat_de_27, t0_.etat_nl AS etat_nl_28, t0_.etat_it AS etat_it_29, t0_.etat_fr_ca AS etat_fr_ca_30, t0_.traduit_deepl AS traduit_deepl_31, t0_.created_at AS created_at_32, t0_.page_url AS page_url_33, t0_.etat_fr_ch AS etat_fr_ch_34, t0_.md5_fr_ch AS md5_fr_ch_35, t0_.texte_fr_ch AS texte_fr_ch_36, t0_.contexte_fr_ch AS contexte_fr_ch_37 FROM partage_dbo.translation t1_, partage_dbo.translation t0_ WHERE t0_.md5_generique = ?

#▲	Time	Info
1	10.01 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, t0.image_filename AS image_filename_13 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = ? LIMIT 1 Parameters: [`"5"`] 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, t0.image_filename AS image_filename_13 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, t0.image_filename AS image_filename_13 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = '5' LIMIT 1;
2	9.98 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, t0.image_filename AS image_filename_13 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = ? LIMIT 1 Parameters: [`"502"`] 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, t0.image_filename AS image_filename_13 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, t0.image_filename AS image_filename_13 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = '502' LIMIT 1;
3	10.08 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: [`"502" "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 = '502' AND (s0_.obsolete <> 'oui' OR s0_.obsolete IS NULL) ORDER BY s0_.nom_secteur_activite ASC;
4	10.24 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 = ? Parameters: [`"50299"`] 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 = ? 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 = '50299';
5	10.22 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 = ? Parameters: [`"50299"`] 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 = ? 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 = '50299';
6	10.17 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.09 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	10.12 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';
9	10.17 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';
10	51.53 ms	SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1 Parameters: [] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON ( l1_.id_participation = s0_.id_societe ) WHERE (l1_.mode = 'publique') AND ( s0_.mode_participation = 'publique' ) AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1 SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1;
11	10.17 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 = ? Parameters: [`"50299"`] 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 = ? 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 = '50299';
12	10.19 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 = ? Parameters: [`"50202"`] 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 = ? 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 = '50202';
13	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 = ? Parameters: [`"50202"`] 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 = ? 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 = '50202';
14	10.19 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.17 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	10.11 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';
17	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_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';
18	73.18 ms	SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1 Parameters: [] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON ( l1_.id_participation = s0_.id_societe ) WHERE (l1_.mode = 'publique') AND ( s0_.mode_participation = 'publique' ) AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1 SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1;
19	10.06 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 = ? Parameters: [`"50202"`] 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 = ? 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 = '50202';
20	10.13 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 = ? Parameters: [`"50204"`] 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 = ? 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 = '50204';
21	10.18 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 = ? Parameters: [`"50204"`] 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 = ? 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 = '50204';
22	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';
23	10.11 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	10.10 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_minimale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON ( p1_.id_parametre_site = d0_.id_parametre_site ) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
25	10.03 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';
26	68.75 ms	SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1 Parameters: [] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON ( l1_.id_participation = s0_.id_societe ) WHERE (l1_.mode = 'publique') AND ( s0_.mode_participation = 'publique' ) AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1 SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1;
27	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 = ? Parameters: [`"50204"`] 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 = ? 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 = '50204';
28	10.35 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite = ? Parameters: [`"50205"`] 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 = ? 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 = '50205';
29	10.52 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 = ? Parameters: [`"50205"`] 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 = ? 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 = '50205';
30	10.12 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.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';
32	10.11 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';
33	10.09 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';
34	56.66 ms	SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1 Parameters: [] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON ( l1_.id_participation = s0_.id_societe ) WHERE (l1_.mode = 'publique') AND ( s0_.mode_participation = 'publique' ) AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1 SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1;
35	10.13 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 = ? Parameters: [`"50205"`] 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 = ? 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 = '50205';
36	10.05 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 = ? Parameters: [`"50203"`] 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 = ? 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 = '50203';
37	10.17 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL 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 = ? Parameters: [`"50203"`] 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 = ? 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 = '50203';
38	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_minimale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON ( p1_.id_parametre_site = d0_.id_parametre_site ) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
39	10.27 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_maximale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON ( p1_.id_parametre_site = d0_.id_parametre_site ) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
40	10.42 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';
41	10.45 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';
42	59.76 ms	SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1 Parameters: [] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON ( l1_.id_participation = s0_.id_societe ) WHERE (l1_.mode = 'publique') AND ( s0_.mode_participation = 'publique' ) AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1 SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1;
43	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 = ? Parameters: [`"50203"`] 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 = ? 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 = '50203';
44	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 = ? Parameters: [`"50201"`] 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 = ? 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 = '50201';
45	10.25 ms	SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL 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 = ? Parameters: [`"50201"`] 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 = ? 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 = '50201';
46	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';
47	10.28 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_maximale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON ( p1_.id_parametre_site = d0_.id_parametre_site ) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
48	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';
49	10.40 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_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';
50	57.58 ms	SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1 Parameters: [] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON ( l1_.id_participation = s0_.id_societe ) WHERE (l1_.mode = 'publique') AND ( s0_.mode_participation = 'publique' ) AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1 SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1;
51	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 = ? Parameters: [`"50201"`] 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 = ? 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 = '50201';
52	19.51 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 LIKE ? Parameters: [`"502%"`] 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 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 LIKE '502%';
53	24.72 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 LIKE ? Parameters: [`"502%"`] 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 LIKE ? SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND a0_.id_secteur_activite LIKE '502%';
54	10.10 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_minimale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON ( p1_.id_parametre_site = d0_.id_parametre_site ) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
55	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';
56	10.40 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_minimale_investissement_participation" "oui" "fr" "FUSACQ"`] View formatted query View runnable query Explain query SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON ( p1_.id_parametre_site = d0_.id_parametre_site ) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';
57	10.39 ms	SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = ? AND p1_.valide = ? AND d0_.code_pays = ? AND d0_.plateforme = ? Parameters: [`"anciennete_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	59.56 ms	SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1 Parameters: [] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON ( l1_.id_participation = s0_.id_societe ) WHERE (l1_.mode = 'publique') AND ( s0_.mode_participation = 'publique' ) AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1 SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201105 AND l1_.date_investissement <= 202105 AND s0_.afficher_vendeur = 1;
59	10.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 LIKE ? Parameters: [`"502%"`] 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 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 LIKE '502%';
60	11.02 ms	SELECT DISTINCT COUNT(DISTINCT a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND a0_.id_secteur_activite LIKE ? Parameters: [`"502%"`] View formatted query View runnable query Explain query SELECT DISTINCT COUNT( DISTINCT a0_.id_annonce_acheteur ) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND a0_.id_secteur_activite LIKE ? SELECT DISTINCT COUNT(DISTINCT a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND a0_.id_secteur_activite LIKE '502%';
61	11.64 ms	SELECT DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.ca_max AS ca_max_1, a0_.id_annonce_acheteur AS id_annonce_acheteur_2 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND a0_.id_secteur_activite LIKE ? ORDER BY a0_.ca_max DESC, a0_.id_annonce_acheteur DESC LIMIT 10 Parameters: [`"502%"`] View formatted query View runnable query Explain query SELECT DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.ca_max AS ca_max_1, a0_.id_annonce_acheteur AS id_annonce_acheteur_2 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND a0_.id_secteur_activite LIKE ? ORDER BY a0_.ca_max DESC, a0_.id_annonce_acheteur DESC LIMIT 10 SELECT DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.ca_max AS ca_max_1, a0_.id_annonce_acheteur AS id_annonce_acheteur_2 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND a0_.id_secteur_activite LIKE '502%' ORDER BY a0_.ca_max DESC, a0_.id_annonce_acheteur DESC LIMIT 10;
62	10.40 ms	SELECT DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.date_parution_initiale AS date_parution_initiale_2, a0_.date_parution AS date_parution_3, a0_.ca_max AS ca_max_4, a0_.apport_perso_repreneur AS apport_perso_repreneur_5, a0_.id_pays AS id_pays_6, a0_.id_region AS id_region_7, a0_.id_departement AS id_departement_8, a0_.autres_localisations AS autres_localisations_9, a0_.type_acquereur AS type_acquereur_10, a0_.id_langue AS id_langue_11 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND a0_.id_secteur_activite LIKE ? AND a0_.id_annonce_acheteur IN (?, ?, ?) ORDER BY a0_.ca_max DESC, a0_.id_annonce_acheteur DESC Parameters: [`"502%" 17678 15968 17999`] View formatted query View runnable query Explain query SELECT DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.date_parution_initiale AS date_parution_initiale_2, a0_.date_parution AS date_parution_3, a0_.ca_max AS ca_max_4, a0_.apport_perso_repreneur AS apport_perso_repreneur_5, a0_.id_pays AS id_pays_6, a0_.id_region AS id_region_7, a0_.id_departement AS id_departement_8, a0_.autres_localisations AS autres_localisations_9, a0_.type_acquereur AS type_acquereur_10, a0_.id_langue AS id_langue_11 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND a0_.id_secteur_activite LIKE ? AND a0_.id_annonce_acheteur IN (?, ?, ?) ORDER BY a0_.ca_max DESC, a0_.id_annonce_acheteur DESC SELECT DISTINCT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.date_parution_initiale AS date_parution_initiale_2, a0_.date_parution AS date_parution_3, a0_.ca_max AS ca_max_4, a0_.apport_perso_repreneur AS apport_perso_repreneur_5, a0_.id_pays AS id_pays_6, a0_.id_region AS id_region_7, a0_.id_departement AS id_departement_8, a0_.autres_localisations AS autres_localisations_9, a0_.type_acquereur AS type_acquereur_10, a0_.id_langue AS id_langue_11 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND a0_.id_secteur_activite LIKE '502%' AND a0_.id_annonce_acheteur IN (17678, 15968, 17999) ORDER BY a0_.ca_max DESC, a0_.id_annonce_acheteur DESC;
63	85.39 ms	SELECT t0_.id_translation AS id_translation_0, t0_.md5_fr AS md5_fr_1, t0_.texte_fr AS texte_fr_2, t0_.contexte_fr AS contexte_fr_3, t0_.md5_en AS md5_en_4, t0_.texte_en AS texte_en_5, t0_.contexte_en AS contexte_en_6, t0_.md5_fr_ca AS md5_fr_ca_7, t0_.texte_fr_ca AS texte_fr_ca_8, t0_.contexte_fr_ca AS contexte_fr_ca_9, t0_.md5_generique AS md5_generique_10, t0_.texte_generique AS texte_generique_11, t0_.contexte_generique AS contexte_generique_12, t0_.md5_es AS md5_es_13, t0_.texte_es AS texte_es_14, t0_.contexte_es AS contexte_es_15, t0_.md5_de AS md5_de_16, t0_.texte_de AS texte_de_17, t0_.contexte_de AS contexte_de_18, t0_.md5_nl AS md5_nl_19, t0_.texte_nl AS texte_nl_20, t0_.contexte_nl AS contexte_nl_21, t0_.md5_it AS md5_it_22, t0_.texte_it AS texte_it_23, t0_.contexte_it AS contexte_it_24, t0_.etat_en AS etat_en_25, t0_.etat_es AS etat_es_26, t0_.etat_de AS etat_de_27, t0_.etat_nl AS etat_nl_28, t0_.etat_it AS etat_it_29, t0_.etat_fr_ca AS etat_fr_ca_30, t0_.traduit_deepl AS traduit_deepl_31, t0_.created_at AS created_at_32, t0_.page_url AS page_url_33, t0_.etat_fr_ch AS etat_fr_ch_34, t0_.md5_fr_ch AS md5_fr_ch_35, t0_.texte_fr_ch AS texte_fr_ch_36, t0_.contexte_fr_ch AS contexte_fr_ch_37 FROM partage_dbo.translation t1_, partage_dbo.translation t0_ WHERE t0_.md5_generique = ? Parameters: [`"9f93482084a0fbffc33329d68a102d08"`] View formatted query View runnable query Explain query SELECT t0_.id_translation AS id_translation_0, t0_.md5_fr AS md5_fr_1, t0_.texte_fr AS texte_fr_2, t0_.contexte_fr AS contexte_fr_3, t0_.md5_en AS md5_en_4, t0_.texte_en AS texte_en_5, t0_.contexte_en AS contexte_en_6, t0_.md5_fr_ca AS md5_fr_ca_7, t0_.texte_fr_ca AS texte_fr_ca_8, t0_.contexte_fr_ca AS contexte_fr_ca_9, t0_.md5_generique AS md5_generique_10, t0_.texte_generique AS texte_generique_11, t0_.contexte_generique AS contexte_generique_12, t0_.md5_es AS md5_es_13, t0_.texte_es AS texte_es_14, t0_.contexte_es AS contexte_es_15, t0_.md5_de AS md5_de_16, t0_.texte_de AS texte_de_17, t0_.contexte_de AS contexte_de_18, t0_.md5_nl AS md5_nl_19, t0_.texte_nl AS texte_nl_20, t0_.contexte_nl AS contexte_nl_21, t0_.md5_it AS md5_it_22, t0_.texte_it AS texte_it_23, t0_.contexte_it AS contexte_it_24, t0_.etat_en AS etat_en_25, t0_.etat_es AS etat_es_26, t0_.etat_de AS etat_de_27, t0_.etat_nl AS etat_nl_28, t0_.etat_it AS etat_it_29, t0_.etat_fr_ca AS etat_fr_ca_30, t0_.traduit_deepl AS traduit_deepl_31, t0_.created_at AS created_at_32, t0_.page_url AS page_url_33, t0_.etat_fr_ch AS etat_fr_ch_34, t0_.md5_fr_ch AS md5_fr_ch_35, t0_.texte_fr_ch AS texte_fr_ch_36, t0_.contexte_fr_ch AS contexte_fr_ch_37 FROM partage_dbo.translation t1_, partage_dbo.translation t0_ WHERE t0_.md5_generique = ? SELECT t0_.id_translation AS id_translation_0, t0_.md5_fr AS md5_fr_1, t0_.texte_fr AS texte_fr_2, t0_.contexte_fr AS contexte_fr_3, t0_.md5_en AS md5_en_4, t0_.texte_en AS texte_en_5, t0_.contexte_en AS contexte_en_6, t0_.md5_fr_ca AS md5_fr_ca_7, t0_.texte_fr_ca AS texte_fr_ca_8, t0_.contexte_fr_ca AS contexte_fr_ca_9, t0_.md5_generique AS md5_generique_10, t0_.texte_generique AS texte_generique_11, t0_.contexte_generique AS contexte_generique_12, t0_.md5_es AS md5_es_13, t0_.texte_es AS texte_es_14, t0_.contexte_es AS contexte_es_15, t0_.md5_de AS md5_de_16, t0_.texte_de AS texte_de_17, t0_.contexte_de AS contexte_de_18, t0_.md5_nl AS md5_nl_19, t0_.texte_nl AS texte_nl_20, t0_.contexte_nl AS contexte_nl_21, t0_.md5_it AS md5_it_22, t0_.texte_it AS texte_it_23, t0_.contexte_it AS contexte_it_24, t0_.etat_en AS etat_en_25, t0_.etat_es AS etat_es_26, t0_.etat_de AS etat_de_27, t0_.etat_nl AS etat_nl_28, t0_.etat_it AS etat_it_29, t0_.etat_fr_ca AS etat_fr_ca_30, t0_.traduit_deepl AS traduit_deepl_31, t0_.created_at AS created_at_32, t0_.page_url AS page_url_33, t0_.etat_fr_ch AS etat_fr_ch_34, t0_.md5_fr_ch AS md5_fr_ch_35, t0_.texte_fr_ch AS texte_fr_ch_36, t0_.contexte_fr_ch AS contexte_fr_ch_37 FROM partage_dbo.translation t1_, partage_dbo.translation t0_ WHERE t0_.md5_generique = '9f93482084a0fbffc33329d68a102d08';
64	37.68 ms	SELECT t0_.id_translation AS id_translation_0, t0_.md5_fr AS md5_fr_1, t0_.texte_fr AS texte_fr_2, t0_.contexte_fr AS contexte_fr_3, t0_.md5_en AS md5_en_4, t0_.texte_en AS texte_en_5, t0_.contexte_en AS contexte_en_6, t0_.md5_fr_ca AS md5_fr_ca_7, t0_.texte_fr_ca AS texte_fr_ca_8, t0_.contexte_fr_ca AS contexte_fr_ca_9, t0_.md5_generique AS md5_generique_10, t0_.texte_generique AS texte_generique_11, t0_.contexte_generique AS contexte_generique_12, t0_.md5_es AS md5_es_13, t0_.texte_es AS texte_es_14, t0_.contexte_es AS contexte_es_15, t0_.md5_de AS md5_de_16, t0_.texte_de AS texte_de_17, t0_.contexte_de AS contexte_de_18, t0_.md5_nl AS md5_nl_19, t0_.texte_nl AS texte_nl_20, t0_.contexte_nl AS contexte_nl_21, t0_.md5_it AS md5_it_22, t0_.texte_it AS texte_it_23, t0_.contexte_it AS contexte_it_24, t0_.etat_en AS etat_en_25, t0_.etat_es AS etat_es_26, t0_.etat_de AS etat_de_27, t0_.etat_nl AS etat_nl_28, t0_.etat_it AS etat_it_29, t0_.etat_fr_ca AS etat_fr_ca_30, t0_.traduit_deepl AS traduit_deepl_31, t0_.created_at AS created_at_32, t0_.page_url AS page_url_33, t0_.etat_fr_ch AS etat_fr_ch_34, t0_.md5_fr_ch AS md5_fr_ch_35, t0_.texte_fr_ch AS texte_fr_ch_36, t0_.contexte_fr_ch AS contexte_fr_ch_37 FROM partage_dbo.translation t1_, partage_dbo.translation t0_ WHERE t0_.md5_generique = ? Parameters: [`"c5ca20536254a7a2a353335a761ec6c4"`] View formatted query View runnable query Explain query SELECT t0_.id_translation AS id_translation_0, t0_.md5_fr AS md5_fr_1, t0_.texte_fr AS texte_fr_2, t0_.contexte_fr AS contexte_fr_3, t0_.md5_en AS md5_en_4, t0_.texte_en AS texte_en_5, t0_.contexte_en AS contexte_en_6, t0_.md5_fr_ca AS md5_fr_ca_7, t0_.texte_fr_ca AS texte_fr_ca_8, t0_.contexte_fr_ca AS contexte_fr_ca_9, t0_.md5_generique AS md5_generique_10, t0_.texte_generique AS texte_generique_11, t0_.contexte_generique AS contexte_generique_12, t0_.md5_es AS md5_es_13, t0_.texte_es AS texte_es_14, t0_.contexte_es AS contexte_es_15, t0_.md5_de AS md5_de_16, t0_.texte_de AS texte_de_17, t0_.contexte_de AS contexte_de_18, t0_.md5_nl AS md5_nl_19, t0_.texte_nl AS texte_nl_20, t0_.contexte_nl AS contexte_nl_21, t0_.md5_it AS md5_it_22, t0_.texte_it AS texte_it_23, t0_.contexte_it AS contexte_it_24, t0_.etat_en AS etat_en_25, t0_.etat_es AS etat_es_26, t0_.etat_de AS etat_de_27, t0_.etat_nl AS etat_nl_28, t0_.etat_it AS etat_it_29, t0_.etat_fr_ca AS etat_fr_ca_30, t0_.traduit_deepl AS traduit_deepl_31, t0_.created_at AS created_at_32, t0_.page_url AS page_url_33, t0_.etat_fr_ch AS etat_fr_ch_34, t0_.md5_fr_ch AS md5_fr_ch_35, t0_.texte_fr_ch AS texte_fr_ch_36, t0_.contexte_fr_ch AS contexte_fr_ch_37 FROM partage_dbo.translation t1_, partage_dbo.translation t0_ WHERE t0_.md5_generique = ? SELECT t0_.id_translation AS id_translation_0, t0_.md5_fr AS md5_fr_1, t0_.texte_fr AS texte_fr_2, t0_.contexte_fr AS contexte_fr_3, t0_.md5_en AS md5_en_4, t0_.texte_en AS texte_en_5, t0_.contexte_en AS contexte_en_6, t0_.md5_fr_ca AS md5_fr_ca_7, t0_.texte_fr_ca AS texte_fr_ca_8, t0_.contexte_fr_ca AS contexte_fr_ca_9, t0_.md5_generique AS md5_generique_10, t0_.texte_generique AS texte_generique_11, t0_.contexte_generique AS contexte_generique_12, t0_.md5_es AS md5_es_13, t0_.texte_es AS texte_es_14, t0_.contexte_es AS contexte_es_15, t0_.md5_de AS md5_de_16, t0_.texte_de AS texte_de_17, t0_.contexte_de AS contexte_de_18, t0_.md5_nl AS md5_nl_19, t0_.texte_nl AS texte_nl_20, t0_.contexte_nl AS contexte_nl_21, t0_.md5_it AS md5_it_22, t0_.texte_it AS texte_it_23, t0_.contexte_it AS contexte_it_24, t0_.etat_en AS etat_en_25, t0_.etat_es AS etat_es_26, t0_.etat_de AS etat_de_27, t0_.etat_nl AS etat_nl_28, t0_.etat_it AS etat_it_29, t0_.etat_fr_ca AS etat_fr_ca_30, t0_.traduit_deepl AS traduit_deepl_31, t0_.created_at AS created_at_32, t0_.page_url AS page_url_33, t0_.etat_fr_ch AS etat_fr_ch_34, t0_.md5_fr_ch AS md5_fr_ch_35, t0_.texte_fr_ch AS texte_fr_ch_36, t0_.contexte_fr_ch AS contexte_fr_ch_37 FROM partage_dbo.translation t1_, partage_dbo.translation t0_ WHERE t0_.md5_generique = 'c5ca20536254a7a2a353335a761ec6c4';

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\SecteursActivite	No errors.
App\Entity\AnnoncesVendeur	No errors.
App\Entity\Societes	No errors.
App\Entity\AnnoncesAcheteur	No errors.
App\Entity\DataParametreSite	No errors.
App\Entity\ParametreSite	No errors.
App\Entity\LienParticipationsFonds	No errors.
App\Entity\Translation	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping