Query Metrics
36
Database Queries
23
Different statements
488.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
110.82 ms (22.70%) |
11 |
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"
]
|
|
76.13 ms (15.60%) |
1 |
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:
[
"bdc1a613249cd7b7104e797d4e1b3bbc"
]
|
|
61.48 ms (12.59%) |
1 |
SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201104 AND l1_.date_investissement <= 202104 AND s0_.afficher_vendeur = 1
Parameters:
[] |
|
41.43 ms (8.49%) |
4 |
SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_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" ] |
|
10.83 ms (2.22%) |
1 |
SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 87596 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise'
Parameters:
[] |
|
10.82 ms (2.22%) |
1 |
SELECT DISTINCT a0_.mode_annonce AS mode_annonce_0, a0_.id_annonce_vendeur AS id_annonce_vendeur_1, a0_.titre_annonce AS titre_annonce_2, a0_.date_parution_initiale AS date_parution_initiale_3, a0_.date_parution AS date_parution_4, a0_.date_parution_initiale_elite AS date_parution_initiale_elite_5, a0_.date_parution_elite AS date_parution_elite_6, a0_.date_fin_publique_elite AS date_fin_publique_elite_7, a0_.ca_n AS ca_n_8, a0_.id_pays AS id_pays_9, a0_.id_region AS id_region_10, a0_.zone_geographique AS zone_geographique_11, a0_.id_departement AS id_departement_12, a0_.statuts AS statuts_13, a0_.id_langue AS id_langue_14, a0_.id_secteur_activite AS id_secteur_activite_15 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts NOT LIKE '99%' AND a0_.id_secteur_activite = ? AND a0_.id_annonce_vendeur IN (?, ?, ?, ?) ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC
Parameters:
[ "50603" 89021 87596 72593 67568 ] |
|
10.64 ms (2.18%) |
1 |
SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 89021 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise' AND c0_.date_livraison >= 20260407
Parameters:
[] |
|
10.64 ms (2.18%) |
1 |
SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 67568 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise' AND c0_.date_livraison >= 20260407
Parameters:
[] |
|
10.63 ms (2.18%) |
1 |
SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 72593 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise' AND c0_.date_livraison >= 20260407
Parameters:
[] |
|
10.61 ms (2.17%) |
1 |
SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 87596 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise' AND c0_.date_livraison >= 20260407
Parameters:
[] |
|
10.58 ms (2.17%) |
1 |
SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 72593 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise'
Parameters:
[] |
|
10.56 ms (2.16%) |
1 |
SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 67568 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise'
Parameters:
[] |
|
10.54 ms (2.16%) |
1 |
SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 89021 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise'
Parameters:
[] |
|
10.45 ms (2.14%) |
1 |
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:
[
"50603"
]
|
|
10.43 ms (2.14%) |
1 |
SELECT DISTINCT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.ca_n AS ca_n_1, a0_.id_annonce_vendeur AS id_annonce_vendeur_2 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts NOT LIKE '99%' AND a0_.id_secteur_activite = ? ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC LIMIT 10
Parameters:
[
"50603"
]
|
|
10.32 ms (2.11%) |
1 |
SELECT DISTINCT a0_.mode_annonce AS mode_annonce_0, a0_.id_annonce_vendeur AS id_annonce_vendeur_1, a0_.titre_annonce AS titre_annonce_2, a0_.date_parution_initiale AS date_parution_initiale_3, a0_.date_parution AS date_parution_4, a0_.date_parution_initiale_elite AS date_parution_initiale_elite_5, a0_.date_parution_elite AS date_parution_elite_6, a0_.date_fin_publique_elite AS date_fin_publique_elite_7, a0_.ca_n AS ca_n_8, a0_.id_pays AS id_pays_9, a0_.id_region AS id_region_10, a0_.zone_geographique AS zone_geographique_11, a0_.id_departement AS id_departement_12, a0_.statuts AS statuts_13, a0_.id_langue AS id_langue_14, a0_.id_secteur_activite AS id_secteur_activite_15 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale_elite IS NOT NULL AND a0_.mode_annonce = 'publique_elite' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite = ? ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC
Parameters:
[
"50603"
]
|
|
10.31 ms (2.11%) |
1 |
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:
[
"50603"
]
|
|
10.26 ms (2.10%) |
1 |
SELECT DISTINCT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts NOT LIKE '99%' AND a0_.id_secteur_activite = ?
Parameters:
[
"50603"
]
|
|
10.25 ms (2.10%) |
1 |
SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale_elite IS NOT NULL AND a0_.mode_annonce = 'publique_elite' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite = ? ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC
Parameters:
[
"50603"
]
|
|
10.14 ms (2.08%) |
1 |
SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.nom_secteur_activite AS nom_secteur_activite_1, s0_.nom_pour_TITLE AS nom_pour_TITLE_2 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite_pere = ? AND (s0_.obsolete <> ? OR s0_.obsolete IS NULL) ORDER BY s0_.nom_secteur_activite ASC
Parameters:
[ "50603" "oui" ] |
|
10.14 ms (2.08%) |
1 |
SELECT DISTINCT a0_.date_fin_publique_elite AS date_fin_publique_elite_0, a0_.mode_annonce AS mode_annonce_1, a0_.id_annonce_vendeur AS id_annonce_vendeur_2, a0_.titre_annonce AS titre_annonce_3, a0_.date_parution_initiale AS date_parution_initiale_4, a0_.date_parution AS date_parution_5, a0_.ca_n AS ca_n_6, a0_.id_pays AS id_pays_7, a0_.id_region AS id_region_8, a0_.zone_geographique AS zone_geographique_9, a0_.id_departement AS id_departement_10, a0_.statuts AS statuts_11, a0_.id_secteur_activite AS id_secteur_activite_12 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.id_period_annonce_prioritaire <> '' AND a0_.id_period_annonce_prioritaire IS NOT NULL AND a0_.etat_annonce_prioritaire = 'active' AND a0_.statuts NOT LIKE '99%' AND a0_.id_secteur_activite = ? ORDER BY a0_.date_debut_annonce_prioritaire ASC LIMIT 5
Parameters:
[
"50603"
]
|
|
10.06 ms (2.06%) |
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 = ?
Parameters:
[
"50603"
]
|
|
10.06 ms (2.06%) |
1 |
SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.id_period_annonce_prioritaire <> '' AND a0_.id_period_annonce_prioritaire IS NOT NULL AND a0_.etat_annonce_prioritaire = 'active' AND a0_.id_secteur_activite = ? ORDER BY a0_.date_debut_annonce_prioritaire ASC
Parameters:
[
"50603"
]
|
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\Commandes | No errors. |
| App\Entity\DetailsCommande | No errors. |
| App\Entity\Translation | No errors. |