Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

24 Database Queries

19 Different statements

541.98 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT t0.id_societe_prestataire AS id_societe_prestataire_1, t0.raison_sociale AS raison_sociale_2, t0.contact_facturation AS contact_facturation_3, t0.adresse AS adresse_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.pays AS pays_7, t0.telephone AS telephone_8, t0.fax AS fax_9, t0.login_utilisateur AS login_utilisateur_10, t0.mail_contact AS mail_contact_11, t0.etat_abonnement AS etat_abonnement_12, t0.reference_abonnement AS reference_abonnement_13, t0.relance_fin_carte AS relance_fin_carte_14, t0.type_pays AS type_pays_15, t0.numero_tva AS numero_tva_16, t0.complement_abonnement AS complement_abonnement_17, t0.mode_reglement_abonnement AS mode_reglement_abonnement_18, t0.nb_prestations_sans_cb AS nb_prestations_sans_cb_19, t0.nb_coordonnees_par_service AS nb_coordonnees_par_service_20, t0.parametres_blog_site AS parametres_blog_site_21, t0.code_acces_blog AS code_acces_blog_22, t0.abonnements_autres_services AS abonnements_autres_services_23, t0.date_debut_referencement AS date_debut_referencement_24, t0.date_fin_referencement AS date_fin_referencement_25, t0.cession_droit_auteur AS cession_droit_auteur_26, t0.segments_classements_concernes AS segments_classements_concernes_27 FROM fusacq_dbo.societes_prestataire t0 WHERE t0.id_societe_prestataire = ?
SELECT c.adresse, c.code_postal, c.ville, c.pays, c.telephone, c.fax, c.email_contact1, c.nom_contact1
                    FROM fusacq_dbo.coordonnees_service_prestataire c
                    WHERE c.id_societe_prestataire = ?
                    UNION ALL
                    SELECT c2.adresse, c2.code_postal, c2.ville, c2.pays, c2.telephone, c2.fax, c2.email_contact1, c2.nom_contact1
                    FROM fusacq_dbo.coordonnees_service_prestataire c2
                    INNER JOIN fusacq_dbo.services_prestataire s ON s.id_service_prestataire = c2.id_service_prestataire
                    WHERE s.id_societe_prestataire = ?
                    LIMIT 1
SELECT t0.id_coordonnees AS id_coordonnees_1, t0.id_service_prestataire AS id_service_prestataire_2, t0.id_societe_prestataire AS id_societe_prestataire_3, t0.adresse AS adresse_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.pays AS pays_7, t0.nom_contact1 AS nom_contact1_8, t0.email_contact1 AS email_contact1_9, t0.nom_contact2 AS nom_contact2_10, t0.email_contact2 AS email_contact2_11, t0.telephone AS telephone_12, t0.indicatif_telephone AS indicatif_telephone_13, t0.fax AS fax_14, t0.telephone_contact1 AS telephone_contact1_15, t0.indicatif_telephone_contact1 AS indicatif_telephone_contact1_16, t0.telephone_contact2 AS telephone_contact2_17, t0.indicatif_telephone_contact2 AS indicatif_telephone_contact2_18 FROM fusacq_dbo.coordonnees_service_prestataire t0 WHERE t0.id_societe_prestataire = ? LIMIT 1
SELECT t0.id_service_prestataire AS id_service_prestataire_1, t0.id_societe_prestataire AS id_societe_prestataire_2, t0.id_langue AS id_langue_3, t0.titre_service AS titre_service_4, t0.nom_contact1 AS nom_contact1_5, t0.email_contact1 AS email_contact1_6, t0.nom_contact2 AS nom_contact2_7, t0.email_contact2 AS email_contact2_8, t0.url_site_web AS url_site_web_9, t0.url_site_web_visible AS url_site_web_visible_10, t0.tel AS tel_11, t0.fax AS fax_12, t0.description_service AS description_service_13, t0.resume_service AS resume_service_14, t0.nom_commercial_societe AS nom_commercial_societe_15, t0.statut AS statut_16, t0.id_secteur_activite AS id_secteur_activite_17, t0.id_secteur_new AS id_secteur_new_18, t0.id_localisation_prestataire AS id_localisation_prestataire_19, t0.cout_mensuel AS cout_mensuel_20, t0.date_demande_publication AS date_demande_publication_21, t0.deja_publique AS deja_publique_22, t0.date_mise_en_ligne AS date_mise_en_ligne_23, t0.gratuite_service AS gratuite_service_24, t0.montant_gratuite AS montant_gratuite_25, t0.adresse AS adresse_26, t0.code_postal AS code_postal_27, t0.ville AS ville_28, t0.pays AS pays_29, t0.contact_si_autre_service AS contact_si_autre_service_30, t0.resume_newsletter AS resume_newsletter_31, t0.nb_apparitions_newsletter AS nb_apparitions_newsletter_32, t0.localisation_pour_referencement AS localisation_pour_referencement_33, t0.titre_newsletter AS titre_newsletter_34, t0.inscription_partenaire AS inscription_partenaire_35, t0.date_fin_gratuite_estimee AS date_fin_gratuite_estimee_36, t0.suivi_prestation AS suivi_prestation_37, t0.remuneration_partenaire_si_gratuite AS remuneration_partenaire_si_gratuite_38, t0.numero_adherent_cncfa AS numero_adherent_cncfa_39, t0.id_reseau AS id_reseau_40, t0.visibilite AS visibilite_41, t0.utiliser_artviper AS utiliser_artviper_42, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_43, t0.url_vignette AS url_vignette_44, t0.date_derniere_mise_en_avant AS date_derniere_mise_en_avant_45, t0.id_pays AS id_pays_46 FROM fusacq_dbo.services_prestataire t0 WHERE t0.id_societe_prestataire = ? LIMIT 1
SELECT t0.id_societe AS id_societe_1, t0.id_societe_news AS id_societe_news_2, t0.id_participation AS id_participation_3, t0.mode_participation AS mode_participation_4, t0.deja_publique AS deja_publique_5, t0.raison_sociale AS raison_sociale_6, t0.raison_sociale_formatee AS raison_sociale_formatee_7, t0.nom_president AS nom_president_8, t0.nom_directeur_general AS nom_directeur_general_9, t0.adresse AS adresse_10, t0.ville AS ville_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.id_pays AS id_pays_15, t0.devise AS devise_16, t0.id_region AS id_region_17, t0.filiales_bureaux AS filiales_bureaux_18, t0.id_secteur_activite AS id_secteur_activite_19, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20, t0.site_internet AS site_internet_21, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22, t0.mail_contact AS mail_contact_23, t0.resume_activite AS resume_activite_24, t0.description_activite AS description_activite_25, t0.mots_cles AS mots_cles_26, t0.strategie_developpement AS strategie_developpement_27, t0.marge_brute_n AS marge_brute_n_28, t0.resultat_exploitation_n AS resultat_exploitation_n_29, t0.resultat_net_n AS resultat_net_n_30, t0.ca_n AS ca_n_31, t0.nb_personnes_n AS nb_personnes_n_32, t0.annee_n AS annee_n_33, t0.date_mise_a_jour AS date_mise_a_jour_34, t0.fichier_joint AS fichier_joint_35, t0.commentaire_interne AS commentaire_interne_36, t0.societe_cotee AS societe_cotee_37, t0.login_demande_publication AS login_demande_publication_38, t0.date_relance AS date_relance_39, t0.relance_mise_a_jour AS relance_mise_a_jour_40, t0.numero_siren AS numero_siren_41, t0.montant_total_investi AS montant_total_investi_42, t0.capital_total_investisseur AS capital_total_investisseur_43, t0.titre_newsletter AS titre_newsletter_44, t0.resume_newsletter AS resume_newsletter_45, t0.date_dernier_investissement AS date_dernier_investissement_46, t0.type_profil_participation AS type_profil_participation_47, t0.mode_societe AS mode_societe_48, t0.utiliser_artviper AS utiliser_artviper_49, t0.numero_siret AS numero_siret_50, t0.code_naf AS code_naf_51, t0.vignette AS vignette_52, t0.vignette_small AS vignette_small_53, t0.ca_n_inf AS ca_n_inf_54, t0.ca_n_sup AS ca_n_sup_55, t0.id_societe_mere AS id_societe_mere_56, t0.date_maj_administrateur AS date_maj_administrateur_57, t0.administrateur AS administrateur_58, t0.etat_resume AS etat_resume_59, t0.afficher_vendeur AS afficher_vendeur_60, t0.afficher_acheteur AS afficher_acheteur_61 FROM fusacq_dbo.societes t0 WHERE t0.raison_sociale = ? LIMIT 1
SELECT t0.id_societe AS id_societe_1, t0.id_societe_news AS id_societe_news_2, t0.id_participation AS id_participation_3, t0.mode_participation AS mode_participation_4, t0.deja_publique AS deja_publique_5, t0.raison_sociale AS raison_sociale_6, t0.raison_sociale_formatee AS raison_sociale_formatee_7, t0.nom_president AS nom_president_8, t0.nom_directeur_general AS nom_directeur_general_9, t0.adresse AS adresse_10, t0.ville AS ville_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.id_pays AS id_pays_15, t0.devise AS devise_16, t0.id_region AS id_region_17, t0.filiales_bureaux AS filiales_bureaux_18, t0.id_secteur_activite AS id_secteur_activite_19, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20, t0.site_internet AS site_internet_21, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22, t0.mail_contact AS mail_contact_23, t0.resume_activite AS resume_activite_24, t0.description_activite AS description_activite_25, t0.mots_cles AS mots_cles_26, t0.strategie_developpement AS strategie_developpement_27, t0.marge_brute_n AS marge_brute_n_28, t0.resultat_exploitation_n AS resultat_exploitation_n_29, t0.resultat_net_n AS resultat_net_n_30, t0.ca_n AS ca_n_31, t0.nb_personnes_n AS nb_personnes_n_32, t0.annee_n AS annee_n_33, t0.date_mise_a_jour AS date_mise_a_jour_34, t0.fichier_joint AS fichier_joint_35, t0.commentaire_interne AS commentaire_interne_36, t0.societe_cotee AS societe_cotee_37, t0.login_demande_publication AS login_demande_publication_38, t0.date_relance AS date_relance_39, t0.relance_mise_a_jour AS relance_mise_a_jour_40, t0.numero_siren AS numero_siren_41, t0.montant_total_investi AS montant_total_investi_42, t0.capital_total_investisseur AS capital_total_investisseur_43, t0.titre_newsletter AS titre_newsletter_44, t0.resume_newsletter AS resume_newsletter_45, t0.date_dernier_investissement AS date_dernier_investissement_46, t0.type_profil_participation AS type_profil_participation_47, t0.mode_societe AS mode_societe_48, t0.utiliser_artviper AS utiliser_artviper_49, t0.numero_siret AS numero_siret_50, t0.code_naf AS code_naf_51, t0.vignette AS vignette_52, t0.vignette_small AS vignette_small_53, t0.ca_n_inf AS ca_n_inf_54, t0.ca_n_sup AS ca_n_sup_55, t0.id_societe_mere AS id_societe_mere_56, t0.date_maj_administrateur AS date_maj_administrateur_57, t0.administrateur AS administrateur_58, t0.etat_resume AS etat_resume_59, t0.afficher_vendeur AS afficher_vendeur_60, t0.afficher_acheteur AS afficher_acheteur_61 FROM fusacq_dbo.societes t0 WHERE t0.id_societe = ?
SELECT DISTINCT b0_.id_operation AS id_operation_0, b1_.id_actualite AS id_actualite_1, b1_.date_mise_en_ligne AS date_mise_en_ligne_2, b1_.titre_actualite AS titre_actualite_3, b1_.provenance_flux_actualite AS provenance_flux_actualite_4, b1_.autorisation_blog AS autorisation_blog_5 FROM fusacq_dbo.buzz_roles b0_ LEFT JOIN fusacq_dbo.buzz_actualites b1_ ON (b0_.id_operation = b1_.id_operation) WHERE b1_.mode_actualite = ? AND b1_.mode_actualite <> ? AND b1_.date_mise_en_ligne IS NOT NULL AND b1_.date_mise_en_ligne <> ? AND SUBSTRING(b1_.date_mise_en_ligne FROM 1 FOR 8) <= ? AND b1_.autorisation_blog <> ? AND ((b0_.id_acteur = ? AND b0_.table_sql_acteur = ?) OR (b0_.id_acteur_passif = ? AND b0_.table_sql_acteur_passif = ?)) ORDER BY b1_.date_mise_en_ligne DESC LIMIT 1000
SELECT b0_.id_operation AS id_operation_0, b0_.provenance_flux_actualite AS provenance_flux_actualite_1, b0_.visibilite_flux AS visibilite_flux_2 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
SELECT b0_.id_secteur_activite AS id_secteur_activite_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_operation = ? LIMIT 1
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.description_activite AS description_activite_2, a0_.date_parution AS date_parution_3, a0_.date_parution_initiale AS date_parution_initiale_4, a0_.id_secteur_activite AS id_secteur_activite_5, a0_.code_naf_oseo_nouveau AS code_naf_oseo_nouveau_6, a0_.ca_n AS ca_n_7, a0_.id_departement AS id_departement_8, a0_.id_region AS id_region_9, a0_.id_pays AS id_pays_10, a0_.zone_geographique AS zone_geographique_11 FROM buzz_lien_operations_annonces_vendeur b1_ LEFT JOIN fusacq_dbo.annonces_vendeur a0_ ON (b1_.id_annonce = a0_.id_annonce_vendeur) WHERE b1_.id_operation = ? ORDER BY a0_.ca_n DESC LIMIT 5
SELECT b0_.id_secteur_activite AS id_secteur_activite_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_operation = ? LIMIT 1
SELECT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.ca_max AS ca_max_2, a0_.id_region AS id_region_3, a0_.id_pays AS id_pays_4, a0_.id_departement AS id_departement_5, a0_.autres_localisations AS autres_localisations_6 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.id_secteur_activite = ? AND a0_.mode_annonce = ? AND a0_.tpe_pme = ? ORDER BY a0_.date_parution_initiale DESC LIMIT 5
SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.nom_secteur_activite AS nom_secteur_activite_1, s0_.nom_secteur_activite AS nom_secteur_activite_2 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite = ?
SELECT t0.id_operation AS id_operation_1, t0.titre_operation AS titre_operation_2, t0.type_operation AS type_operation_3, t0.mots_cles AS mots_cles_4, t0.personne_physique_impliquee AS personne_physique_impliquee_5, t0.societe_impliquee AS societe_impliquee_6, t0.fonds_implique AS fonds_implique_7, t0.suivi_operation AS suivi_operation_8, t0.date_operation AS date_operation_9, t0.id_secteur_activite AS id_secteur_activite_10, t0.id_localisation AS id_localisation_11, t0.id_localisation_2 AS id_localisation_2_12, t0.id_actualite_principale AS id_actualite_principale_13, t0.visibilite_sur_annonces_fusacq AS visibilite_sur_annonces_fusacq_14, t0.code_naf AS code_naf_15, t0.montant_operation AS montant_operation_16, t0.ca_societe_achetee AS ca_societe_achetee_17, t0.mode_operation AS mode_operation_18, t0.mots_cles_valides AS mots_cles_valides_19, t0.check_rattrapage AS check_rattrapage_20, t0.pct_capital_achete AS pct_capital_achete_21, t0.maj_min_capital AS maj_min_capital_22, t0.fourchette_ca AS fourchette_ca_23, t0.nb_compte_classement AS nb_compte_classement_24, t0.montant_compte_classement AS montant_compte_classement_25 FROM fusacq_dbo.buzz_operations t0 WHERE t0.id_operation = ?
SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.description_activite AS description_activite_2, a0_.date_parution AS date_parution_3, a0_.date_parution_initiale AS date_parution_initiale_4, a0_.id_secteur_activite AS id_secteur_activite_5, a0_.code_naf_oseo_nouveau AS code_naf_oseo_nouveau_6, a0_.ca_n AS ca_n_7, a0_.id_departement AS id_departement_8, a0_.id_region AS id_region_9, a0_.id_pays AS id_pays_10, a0_.zone_geographique AS zone_geographique_11 FROM buzz_lien_operations_annonces_vendeur b1_ LEFT JOIN fusacq_dbo.annonces_vendeur a0_ ON (b1_.id_annonce = a0_.id_annonce_vendeur) WHERE b1_.id_operation = ? ORDER BY a0_.ca_n DESC LIMIT 5
SELECT b0_.id_secteur_activite AS id_secteur_activite_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_operation = ? LIMIT 1
SELECT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.ca_max AS ca_max_2, a0_.id_region AS id_region_3, a0_.id_pays AS id_pays_4, a0_.id_departement AS id_departement_5, a0_.autres_localisations AS autres_localisations_6 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.id_secteur_activite = ? AND a0_.mode_annonce = ? AND a0_.tpe_pme = ? ORDER BY a0_.date_parution_initiale DESC LIMIT 5
SELECT id_localisation, id_localisation_2 FROM fusacq_dbo.buzz_operations WHERE id_operation = ? LIMIT 1
SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.nom_secteur_activite AS nom_secteur_activite_1, s0_.nom_secteur_activite AS nom_secteur_activite_2 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite = ?
SELECT * FROM ((
            SELECT DISTINCT
                ba.id_actualite,
                ba.date_mise_en_ligne,
                ba.titre_actualite,
                ba.sous_titre,
                ba.provenance_flux_actualite,
                ba.id_message_blog,
                ba.id_societe_prestataire,
                ba.visibilite_flux
            FROM fusacq_dbo.buzz_operations bo
            INNER JOIN fusacq_dbo.buzz_actualites ba ON bo.id_actualite_principale = ba.id_actualite
            WHERE ba.mode_actualite = 'publique'
            AND (
                (ba.provenance_flux_actualite = 'blog' AND ba.visibilite_flux LIKE '%collaborative%')
                OR ba.provenance_flux_actualite != 'blog'
            )
            AND bo.id_actualite_principale IS NOT NULL
            AND ba.id_actualite IS NOT NULL
            AND bo.id_secteur_activite = 60607
        ) UNION (
            SELECT DISTINCT
                ba.id_actualite,
                ba.date_mise_en_ligne,
                ba.titre_actualite,
                ba.sous_titre,
                ba.provenance_flux_actualite,
                ba.id_message_blog,
                ba.id_societe_prestataire,
                ba.visibilite_flux
            FROM fusacq_dbo.buzz_actualites ba
            INNER JOIN fusacq_dbo.buzz_operations bo ON ba.id_operation = bo.id_operation
            WHERE ba.mode_actualite = 'publique'
            AND (
                (ba.provenance_flux_actualite = 'blog' AND ba.visibilite_flux LIKE '%collaborative%')
                OR ba.provenance_flux_actualite != 'blog'
            )
            AND ba.id_operation IS NOT NULL
            AND bo.id_secteur_activite = 60607
        )) AS combined WHERE id_actualite != 86944 ORDER BY date_mise_en_ligne DESC LIMIT 5
SELECT t0.id_localisation AS id_localisation_1, t0.dept AS dept_2, t0.nom_localisation AS nom_localisation_3, t0.id_localisation_pere AS id_localisation_pere_4, t0.prefixe AS prefixe_5, t0.recherche AS recherche_6 FROM fusacq_dbo.localisations t0 WHERE t0.id_localisation = ?
SELECT
                id,
                titre_annonce,
                date_parution_initiale_complete,
                date_parution_initiale,
                type_annonce,
                date_tri
            FROM (
                SELECT
                    id_annonce_vendeur AS id,
                    titre_annonce,
                    date_parution_initiale_complete,
                    date_parution_initiale,
                    'V' AS type_annonce,
                    CASE 
                        WHEN date_parution_initiale_complete IS NOT NULL 
                             AND date_parution_initiale_complete != '' 
                             AND LENGTH(date_parution_initiale_complete) >= 12 
                             AND LENGTH(date_parution_initiale_complete) <= 14
                        THEN 
                            CASE 
                                WHEN LENGTH(date_parution_initiale_complete) = 14 
                                THEN date_parution_initiale_complete
                                ELSE CONCAT(date_parution_initiale_complete, '00')
                            END
                        ELSE CONCAT(date_parution_initiale, '000000')
                    END AS date_tri
                FROM annonces_vendeur
                WHERE mode_annonce = 'publique'
                AND tpe_pme = 'oui'
                AND visible_dernieres_annonces IS NULL
                AND date_parution_initiale IS NOT NULL
                UNION ALL
                SELECT
                    id_annonce_acheteur AS id,
                    titre_annonce,
                    date_parution_initiale_complete,
                    date_parution_initiale,
                    'A' AS type_annonce,
                    CASE 
                        WHEN date_parution_initiale_complete IS NOT NULL 
                             AND date_parution_initiale_complete != '' 
                             AND LENGTH(date_parution_initiale_complete) >= 12 
                             AND LENGTH(date_parution_initiale_complete) <= 14
                        THEN 
                            CASE 
                                WHEN LENGTH(date_parution_initiale_complete) = 14 
                                THEN date_parution_initiale_complete
                                ELSE CONCAT(date_parution_initiale_complete, '00')
                            END
                        ELSE CONCAT(date_parution_initiale, '000000')
                    END AS date_tri
                FROM annonces_acheteur
                WHERE mode_annonce = 'publique'
                AND tpe_pme = 'oui'
                AND date_parution_initiale IS NOT NULL
                UNION ALL
                SELECT
                    id_repreneur AS id,
                    titre_profil AS titre_annonce,
                    date_parution_initiale_complete,
                    date_parution_initiale,
                    'R' AS type_annonce,
                    CASE 
                        WHEN date_parution_initiale_complete IS NOT NULL 
                             AND date_parution_initiale_complete != '' 
                             AND LENGTH(date_parution_initiale_complete) >= 12 
                             AND LENGTH(date_parution_initiale_complete) <= 14
                        THEN 
                            CASE 
                                WHEN LENGTH(date_parution_initiale_complete) = 14 
                                THEN date_parution_initiale_complete
                                ELSE CONCAT(date_parution_initiale_complete, '00')
                            END
                        ELSE CONCAT(date_parution_initiale, '000000')
                    END AS date_tri
                FROM annuaire_repreneurs
                WHERE mode_profil = 'publique'
                AND date_parution_initiale IS NOT NULL
            ) AS en_direct
            ORDER BY date_tri DESC, id DESC
            LIMIT :limit
SELECT id_actualite, jour, mois, type_actualite, titre_actualite, date_mise_en_ligne
        FROM (
            SELECT
                id_actualite,
                SUBSTRING(date_mise_en_ligne, 7, 2) AS jour,
                SUBSTRING(date_mise_en_ligne, 5, 2) AS mois,
                type_actualite,
                titre_actualite,
                date_mise_en_ligne,
                ROW_NUMBER() OVER (PARTITION BY type_actualite ORDER BY date_mise_en_ligne DESC) AS rn
            FROM buzz_actualites
            WHERE
                provenance_flux_actualite = 'blog'
                AND mode_actualite = 'publique'
                AND date_mise_en_ligne <= :now
                AND id_localisation LIKE CONCAT(:idPays, '%')
        ) t
        WHERE rn <= 2
        ORDER BY date_mise_en_ligne DESC, id_actualite DESC

#▲	Time	Info
1	10.19 ms	SELECT t0.id_societe_prestataire AS id_societe_prestataire_1, t0.raison_sociale AS raison_sociale_2, t0.contact_facturation AS contact_facturation_3, t0.adresse AS adresse_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.pays AS pays_7, t0.telephone AS telephone_8, t0.fax AS fax_9, t0.login_utilisateur AS login_utilisateur_10, t0.mail_contact AS mail_contact_11, t0.etat_abonnement AS etat_abonnement_12, t0.reference_abonnement AS reference_abonnement_13, t0.relance_fin_carte AS relance_fin_carte_14, t0.type_pays AS type_pays_15, t0.numero_tva AS numero_tva_16, t0.complement_abonnement AS complement_abonnement_17, t0.mode_reglement_abonnement AS mode_reglement_abonnement_18, t0.nb_prestations_sans_cb AS nb_prestations_sans_cb_19, t0.nb_coordonnees_par_service AS nb_coordonnees_par_service_20, t0.parametres_blog_site AS parametres_blog_site_21, t0.code_acces_blog AS code_acces_blog_22, t0.abonnements_autres_services AS abonnements_autres_services_23, t0.date_debut_referencement AS date_debut_referencement_24, t0.date_fin_referencement AS date_fin_referencement_25, t0.cession_droit_auteur AS cession_droit_auteur_26, t0.segments_classements_concernes AS segments_classements_concernes_27 FROM fusacq_dbo.societes_prestataire t0 WHERE t0.id_societe_prestataire = ? Parameters: [`"2808"`] View formatted query View runnable query Explain query SELECT t0.id_societe_prestataire AS id_societe_prestataire_1, t0.raison_sociale AS raison_sociale_2, t0.contact_facturation AS contact_facturation_3, t0.adresse AS adresse_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.pays AS pays_7, t0.telephone AS telephone_8, t0.fax AS fax_9, t0.login_utilisateur AS login_utilisateur_10, t0.mail_contact AS mail_contact_11, t0.etat_abonnement AS etat_abonnement_12, t0.reference_abonnement AS reference_abonnement_13, t0.relance_fin_carte AS relance_fin_carte_14, t0.type_pays AS type_pays_15, t0.numero_tva AS numero_tva_16, t0.complement_abonnement AS complement_abonnement_17, t0.mode_reglement_abonnement AS mode_reglement_abonnement_18, t0.nb_prestations_sans_cb AS nb_prestations_sans_cb_19, t0.nb_coordonnees_par_service AS nb_coordonnees_par_service_20, t0.parametres_blog_site AS parametres_blog_site_21, t0.code_acces_blog AS code_acces_blog_22, t0.abonnements_autres_services AS abonnements_autres_services_23, t0.date_debut_referencement AS date_debut_referencement_24, t0.date_fin_referencement AS date_fin_referencement_25, t0.cession_droit_auteur AS cession_droit_auteur_26, t0.segments_classements_concernes AS segments_classements_concernes_27 FROM fusacq_dbo.societes_prestataire t0 WHERE t0.id_societe_prestataire = ? SELECT t0.id_societe_prestataire AS id_societe_prestataire_1, t0.raison_sociale AS raison_sociale_2, t0.contact_facturation AS contact_facturation_3, t0.adresse AS adresse_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.pays AS pays_7, t0.telephone AS telephone_8, t0.fax AS fax_9, t0.login_utilisateur AS login_utilisateur_10, t0.mail_contact AS mail_contact_11, t0.etat_abonnement AS etat_abonnement_12, t0.reference_abonnement AS reference_abonnement_13, t0.relance_fin_carte AS relance_fin_carte_14, t0.type_pays AS type_pays_15, t0.numero_tva AS numero_tva_16, t0.complement_abonnement AS complement_abonnement_17, t0.mode_reglement_abonnement AS mode_reglement_abonnement_18, t0.nb_prestations_sans_cb AS nb_prestations_sans_cb_19, t0.nb_coordonnees_par_service AS nb_coordonnees_par_service_20, t0.parametres_blog_site AS parametres_blog_site_21, t0.code_acces_blog AS code_acces_blog_22, t0.abonnements_autres_services AS abonnements_autres_services_23, t0.date_debut_referencement AS date_debut_referencement_24, t0.date_fin_referencement AS date_fin_referencement_25, t0.cession_droit_auteur AS cession_droit_auteur_26, t0.segments_classements_concernes AS segments_classements_concernes_27 FROM fusacq_dbo.societes_prestataire t0 WHERE t0.id_societe_prestataire = '2808';
2	30.15 ms	SELECT c.adresse, c.code_postal, c.ville, c.pays, c.telephone, c.fax, c.email_contact1, c.nom_contact1 FROM fusacq_dbo.coordonnees_service_prestataire c WHERE c.id_societe_prestataire = ? UNION ALL SELECT c2.adresse, c2.code_postal, c2.ville, c2.pays, c2.telephone, c2.fax, c2.email_contact1, c2.nom_contact1 FROM fusacq_dbo.coordonnees_service_prestataire c2 INNER JOIN fusacq_dbo.services_prestataire s ON s.id_service_prestataire = c2.id_service_prestataire WHERE s.id_societe_prestataire = ? LIMIT 1 Parameters: [`2808 2808`] View formatted query View runnable query Explain query SELECT c.adresse, c.code_postal, c.ville, c.pays, c.telephone, c.fax, c.email_contact1, c.nom_contact1 FROM fusacq_dbo.coordonnees_service_prestataire c WHERE c.id_societe_prestataire = ? UNION ALL SELECT c2.adresse, c2.code_postal, c2.ville, c2.pays, c2.telephone, c2.fax, c2.email_contact1, c2.nom_contact1 FROM fusacq_dbo.coordonnees_service_prestataire c2 INNER JOIN fusacq_dbo.services_prestataire s ON s.id_service_prestataire = c2.id_service_prestataire WHERE s.id_societe_prestataire = ? LIMIT 1 SELECT c.adresse, c.code_postal, c.ville, c.pays, c.telephone, c.fax, c.email_contact1, c.nom_contact1 FROM fusacq_dbo.coordonnees_service_prestataire c WHERE c.id_societe_prestataire = 2808 UNION ALL SELECT c2.adresse, c2.code_postal, c2.ville, c2.pays, c2.telephone, c2.fax, c2.email_contact1, c2.nom_contact1 FROM fusacq_dbo.coordonnees_service_prestataire c2 INNER JOIN fusacq_dbo.services_prestataire s ON s.id_service_prestataire = c2.id_service_prestataire WHERE s.id_societe_prestataire = 2808 LIMIT 1 ;
3	16.31 ms	SELECT t0.id_coordonnees AS id_coordonnees_1, t0.id_service_prestataire AS id_service_prestataire_2, t0.id_societe_prestataire AS id_societe_prestataire_3, t0.adresse AS adresse_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.pays AS pays_7, t0.nom_contact1 AS nom_contact1_8, t0.email_contact1 AS email_contact1_9, t0.nom_contact2 AS nom_contact2_10, t0.email_contact2 AS email_contact2_11, t0.telephone AS telephone_12, t0.indicatif_telephone AS indicatif_telephone_13, t0.fax AS fax_14, t0.telephone_contact1 AS telephone_contact1_15, t0.indicatif_telephone_contact1 AS indicatif_telephone_contact1_16, t0.telephone_contact2 AS telephone_contact2_17, t0.indicatif_telephone_contact2 AS indicatif_telephone_contact2_18 FROM fusacq_dbo.coordonnees_service_prestataire t0 WHERE t0.id_societe_prestataire = ? LIMIT 1 Parameters: [`2808`] View formatted query View runnable query Explain query SELECT t0.id_coordonnees AS id_coordonnees_1, t0.id_service_prestataire AS id_service_prestataire_2, t0.id_societe_prestataire AS id_societe_prestataire_3, t0.adresse AS adresse_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.pays AS pays_7, t0.nom_contact1 AS nom_contact1_8, t0.email_contact1 AS email_contact1_9, t0.nom_contact2 AS nom_contact2_10, t0.email_contact2 AS email_contact2_11, t0.telephone AS telephone_12, t0.indicatif_telephone AS indicatif_telephone_13, t0.fax AS fax_14, t0.telephone_contact1 AS telephone_contact1_15, t0.indicatif_telephone_contact1 AS indicatif_telephone_contact1_16, t0.telephone_contact2 AS telephone_contact2_17, t0.indicatif_telephone_contact2 AS indicatif_telephone_contact2_18 FROM fusacq_dbo.coordonnees_service_prestataire t0 WHERE t0.id_societe_prestataire = ? LIMIT 1 SELECT t0.id_coordonnees AS id_coordonnees_1, t0.id_service_prestataire AS id_service_prestataire_2, t0.id_societe_prestataire AS id_societe_prestataire_3, t0.adresse AS adresse_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.pays AS pays_7, t0.nom_contact1 AS nom_contact1_8, t0.email_contact1 AS email_contact1_9, t0.nom_contact2 AS nom_contact2_10, t0.email_contact2 AS email_contact2_11, t0.telephone AS telephone_12, t0.indicatif_telephone AS indicatif_telephone_13, t0.fax AS fax_14, t0.telephone_contact1 AS telephone_contact1_15, t0.indicatif_telephone_contact1 AS indicatif_telephone_contact1_16, t0.telephone_contact2 AS telephone_contact2_17, t0.indicatif_telephone_contact2 AS indicatif_telephone_contact2_18 FROM fusacq_dbo.coordonnees_service_prestataire t0 WHERE t0.id_societe_prestataire = 2808 LIMIT 1;
4	23.73 ms	SELECT t0.id_service_prestataire AS id_service_prestataire_1, t0.id_societe_prestataire AS id_societe_prestataire_2, t0.id_langue AS id_langue_3, t0.titre_service AS titre_service_4, t0.nom_contact1 AS nom_contact1_5, t0.email_contact1 AS email_contact1_6, t0.nom_contact2 AS nom_contact2_7, t0.email_contact2 AS email_contact2_8, t0.url_site_web AS url_site_web_9, t0.url_site_web_visible AS url_site_web_visible_10, t0.tel AS tel_11, t0.fax AS fax_12, t0.description_service AS description_service_13, t0.resume_service AS resume_service_14, t0.nom_commercial_societe AS nom_commercial_societe_15, t0.statut AS statut_16, t0.id_secteur_activite AS id_secteur_activite_17, t0.id_secteur_new AS id_secteur_new_18, t0.id_localisation_prestataire AS id_localisation_prestataire_19, t0.cout_mensuel AS cout_mensuel_20, t0.date_demande_publication AS date_demande_publication_21, t0.deja_publique AS deja_publique_22, t0.date_mise_en_ligne AS date_mise_en_ligne_23, t0.gratuite_service AS gratuite_service_24, t0.montant_gratuite AS montant_gratuite_25, t0.adresse AS adresse_26, t0.code_postal AS code_postal_27, t0.ville AS ville_28, t0.pays AS pays_29, t0.contact_si_autre_service AS contact_si_autre_service_30, t0.resume_newsletter AS resume_newsletter_31, t0.nb_apparitions_newsletter AS nb_apparitions_newsletter_32, t0.localisation_pour_referencement AS localisation_pour_referencement_33, t0.titre_newsletter AS titre_newsletter_34, t0.inscription_partenaire AS inscription_partenaire_35, t0.date_fin_gratuite_estimee AS date_fin_gratuite_estimee_36, t0.suivi_prestation AS suivi_prestation_37, t0.remuneration_partenaire_si_gratuite AS remuneration_partenaire_si_gratuite_38, t0.numero_adherent_cncfa AS numero_adherent_cncfa_39, t0.id_reseau AS id_reseau_40, t0.visibilite AS visibilite_41, t0.utiliser_artviper AS utiliser_artviper_42, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_43, t0.url_vignette AS url_vignette_44, t0.date_derniere_mise_en_avant AS date_derniere_mise_en_avant_45, t0.id_pays AS id_pays_46 FROM fusacq_dbo.services_prestataire t0 WHERE t0.id_societe_prestataire = ? LIMIT 1 Parameters: [`2808`] View formatted query View runnable query Explain query SELECT t0.id_service_prestataire AS id_service_prestataire_1, t0.id_societe_prestataire AS id_societe_prestataire_2, t0.id_langue AS id_langue_3, t0.titre_service AS titre_service_4, t0.nom_contact1 AS nom_contact1_5, t0.email_contact1 AS email_contact1_6, t0.nom_contact2 AS nom_contact2_7, t0.email_contact2 AS email_contact2_8, t0.url_site_web AS url_site_web_9, t0.url_site_web_visible AS url_site_web_visible_10, t0.tel AS tel_11, t0.fax AS fax_12, t0.description_service AS description_service_13, t0.resume_service AS resume_service_14, t0.nom_commercial_societe AS nom_commercial_societe_15, t0.statut AS statut_16, t0.id_secteur_activite AS id_secteur_activite_17, t0.id_secteur_new AS id_secteur_new_18, t0.id_localisation_prestataire AS id_localisation_prestataire_19, t0.cout_mensuel AS cout_mensuel_20, t0.date_demande_publication AS date_demande_publication_21, t0.deja_publique AS deja_publique_22, t0.date_mise_en_ligne AS date_mise_en_ligne_23, t0.gratuite_service AS gratuite_service_24, t0.montant_gratuite AS montant_gratuite_25, t0.adresse AS adresse_26, t0.code_postal AS code_postal_27, t0.ville AS ville_28, t0.pays AS pays_29, t0.contact_si_autre_service AS contact_si_autre_service_30, t0.resume_newsletter AS resume_newsletter_31, t0.nb_apparitions_newsletter AS nb_apparitions_newsletter_32, t0.localisation_pour_referencement AS localisation_pour_referencement_33, t0.titre_newsletter AS titre_newsletter_34, t0.inscription_partenaire AS inscription_partenaire_35, t0.date_fin_gratuite_estimee AS date_fin_gratuite_estimee_36, t0.suivi_prestation AS suivi_prestation_37, t0.remuneration_partenaire_si_gratuite AS remuneration_partenaire_si_gratuite_38, t0.numero_adherent_cncfa AS numero_adherent_cncfa_39, t0.id_reseau AS id_reseau_40, t0.visibilite AS visibilite_41, t0.utiliser_artviper AS utiliser_artviper_42, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_43, t0.url_vignette AS url_vignette_44, t0.date_derniere_mise_en_avant AS date_derniere_mise_en_avant_45, t0.id_pays AS id_pays_46 FROM fusacq_dbo.services_prestataire t0 WHERE t0.id_societe_prestataire = ? LIMIT 1 SELECT t0.id_service_prestataire AS id_service_prestataire_1, t0.id_societe_prestataire AS id_societe_prestataire_2, t0.id_langue AS id_langue_3, t0.titre_service AS titre_service_4, t0.nom_contact1 AS nom_contact1_5, t0.email_contact1 AS email_contact1_6, t0.nom_contact2 AS nom_contact2_7, t0.email_contact2 AS email_contact2_8, t0.url_site_web AS url_site_web_9, t0.url_site_web_visible AS url_site_web_visible_10, t0.tel AS tel_11, t0.fax AS fax_12, t0.description_service AS description_service_13, t0.resume_service AS resume_service_14, t0.nom_commercial_societe AS nom_commercial_societe_15, t0.statut AS statut_16, t0.id_secteur_activite AS id_secteur_activite_17, t0.id_secteur_new AS id_secteur_new_18, t0.id_localisation_prestataire AS id_localisation_prestataire_19, t0.cout_mensuel AS cout_mensuel_20, t0.date_demande_publication AS date_demande_publication_21, t0.deja_publique AS deja_publique_22, t0.date_mise_en_ligne AS date_mise_en_ligne_23, t0.gratuite_service AS gratuite_service_24, t0.montant_gratuite AS montant_gratuite_25, t0.adresse AS adresse_26, t0.code_postal AS code_postal_27, t0.ville AS ville_28, t0.pays AS pays_29, t0.contact_si_autre_service AS contact_si_autre_service_30, t0.resume_newsletter AS resume_newsletter_31, t0.nb_apparitions_newsletter AS nb_apparitions_newsletter_32, t0.localisation_pour_referencement AS localisation_pour_referencement_33, t0.titre_newsletter AS titre_newsletter_34, t0.inscription_partenaire AS inscription_partenaire_35, t0.date_fin_gratuite_estimee AS date_fin_gratuite_estimee_36, t0.suivi_prestation AS suivi_prestation_37, t0.remuneration_partenaire_si_gratuite AS remuneration_partenaire_si_gratuite_38, t0.numero_adherent_cncfa AS numero_adherent_cncfa_39, t0.id_reseau AS id_reseau_40, t0.visibilite AS visibilite_41, t0.utiliser_artviper AS utiliser_artviper_42, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_43, t0.url_vignette AS url_vignette_44, t0.date_derniere_mise_en_avant AS date_derniere_mise_en_avant_45, t0.id_pays AS id_pays_46 FROM fusacq_dbo.services_prestataire t0 WHERE t0.id_societe_prestataire = 2808 LIMIT 1;
5	106.66 ms	SELECT t0.id_societe AS id_societe_1, t0.id_societe_news AS id_societe_news_2, t0.id_participation AS id_participation_3, t0.mode_participation AS mode_participation_4, t0.deja_publique AS deja_publique_5, t0.raison_sociale AS raison_sociale_6, t0.raison_sociale_formatee AS raison_sociale_formatee_7, t0.nom_president AS nom_president_8, t0.nom_directeur_general AS nom_directeur_general_9, t0.adresse AS adresse_10, t0.ville AS ville_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.id_pays AS id_pays_15, t0.devise AS devise_16, t0.id_region AS id_region_17, t0.filiales_bureaux AS filiales_bureaux_18, t0.id_secteur_activite AS id_secteur_activite_19, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20, t0.site_internet AS site_internet_21, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22, t0.mail_contact AS mail_contact_23, t0.resume_activite AS resume_activite_24, t0.description_activite AS description_activite_25, t0.mots_cles AS mots_cles_26, t0.strategie_developpement AS strategie_developpement_27, t0.marge_brute_n AS marge_brute_n_28, t0.resultat_exploitation_n AS resultat_exploitation_n_29, t0.resultat_net_n AS resultat_net_n_30, t0.ca_n AS ca_n_31, t0.nb_personnes_n AS nb_personnes_n_32, t0.annee_n AS annee_n_33, t0.date_mise_a_jour AS date_mise_a_jour_34, t0.fichier_joint AS fichier_joint_35, t0.commentaire_interne AS commentaire_interne_36, t0.societe_cotee AS societe_cotee_37, t0.login_demande_publication AS login_demande_publication_38, t0.date_relance AS date_relance_39, t0.relance_mise_a_jour AS relance_mise_a_jour_40, t0.numero_siren AS numero_siren_41, t0.montant_total_investi AS montant_total_investi_42, t0.capital_total_investisseur AS capital_total_investisseur_43, t0.titre_newsletter AS titre_newsletter_44, t0.resume_newsletter AS resume_newsletter_45, t0.date_dernier_investissement AS date_dernier_investissement_46, t0.type_profil_participation AS type_profil_participation_47, t0.mode_societe AS mode_societe_48, t0.utiliser_artviper AS utiliser_artviper_49, t0.numero_siret AS numero_siret_50, t0.code_naf AS code_naf_51, t0.vignette AS vignette_52, t0.vignette_small AS vignette_small_53, t0.ca_n_inf AS ca_n_inf_54, t0.ca_n_sup AS ca_n_sup_55, t0.id_societe_mere AS id_societe_mere_56, t0.date_maj_administrateur AS date_maj_administrateur_57, t0.administrateur AS administrateur_58, t0.etat_resume AS etat_resume_59, t0.afficher_vendeur AS afficher_vendeur_60, t0.afficher_acheteur AS afficher_acheteur_61 FROM fusacq_dbo.societes t0 WHERE t0.raison_sociale = ? LIMIT 1 Parameters: [`"Alain Chemaly"`] View formatted query View runnable query Explain query SELECT t0.id_societe AS id_societe_1, t0.id_societe_news AS id_societe_news_2, t0.id_participation AS id_participation_3, t0.mode_participation AS mode_participation_4, t0.deja_publique AS deja_publique_5, t0.raison_sociale AS raison_sociale_6, t0.raison_sociale_formatee AS raison_sociale_formatee_7, t0.nom_president AS nom_president_8, t0.nom_directeur_general AS nom_directeur_general_9, t0.adresse AS adresse_10, t0.ville AS ville_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.id_pays AS id_pays_15, t0.devise AS devise_16, t0.id_region AS id_region_17, t0.filiales_bureaux AS filiales_bureaux_18, t0.id_secteur_activite AS id_secteur_activite_19, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20, t0.site_internet AS site_internet_21, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22, t0.mail_contact AS mail_contact_23, t0.resume_activite AS resume_activite_24, t0.description_activite AS description_activite_25, t0.mots_cles AS mots_cles_26, t0.strategie_developpement AS strategie_developpement_27, t0.marge_brute_n AS marge_brute_n_28, t0.resultat_exploitation_n AS resultat_exploitation_n_29, t0.resultat_net_n AS resultat_net_n_30, t0.ca_n AS ca_n_31, t0.nb_personnes_n AS nb_personnes_n_32, t0.annee_n AS annee_n_33, t0.date_mise_a_jour AS date_mise_a_jour_34, t0.fichier_joint AS fichier_joint_35, t0.commentaire_interne AS commentaire_interne_36, t0.societe_cotee AS societe_cotee_37, t0.login_demande_publication AS login_demande_publication_38, t0.date_relance AS date_relance_39, t0.relance_mise_a_jour AS relance_mise_a_jour_40, t0.numero_siren AS numero_siren_41, t0.montant_total_investi AS montant_total_investi_42, t0.capital_total_investisseur AS capital_total_investisseur_43, t0.titre_newsletter AS titre_newsletter_44, t0.resume_newsletter AS resume_newsletter_45, t0.date_dernier_investissement AS date_dernier_investissement_46, t0.type_profil_participation AS type_profil_participation_47, t0.mode_societe AS mode_societe_48, t0.utiliser_artviper AS utiliser_artviper_49, t0.numero_siret AS numero_siret_50, t0.code_naf AS code_naf_51, t0.vignette AS vignette_52, t0.vignette_small AS vignette_small_53, t0.ca_n_inf AS ca_n_inf_54, t0.ca_n_sup AS ca_n_sup_55, t0.id_societe_mere AS id_societe_mere_56, t0.date_maj_administrateur AS date_maj_administrateur_57, t0.administrateur AS administrateur_58, t0.etat_resume AS etat_resume_59, t0.afficher_vendeur AS afficher_vendeur_60, t0.afficher_acheteur AS afficher_acheteur_61 FROM fusacq_dbo.societes t0 WHERE t0.raison_sociale = ? LIMIT 1 SELECT t0.id_societe AS id_societe_1, t0.id_societe_news AS id_societe_news_2, t0.id_participation AS id_participation_3, t0.mode_participation AS mode_participation_4, t0.deja_publique AS deja_publique_5, t0.raison_sociale AS raison_sociale_6, t0.raison_sociale_formatee AS raison_sociale_formatee_7, t0.nom_president AS nom_president_8, t0.nom_directeur_general AS nom_directeur_general_9, t0.adresse AS adresse_10, t0.ville AS ville_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.id_pays AS id_pays_15, t0.devise AS devise_16, t0.id_region AS id_region_17, t0.filiales_bureaux AS filiales_bureaux_18, t0.id_secteur_activite AS id_secteur_activite_19, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20, t0.site_internet AS site_internet_21, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22, t0.mail_contact AS mail_contact_23, t0.resume_activite AS resume_activite_24, t0.description_activite AS description_activite_25, t0.mots_cles AS mots_cles_26, t0.strategie_developpement AS strategie_developpement_27, t0.marge_brute_n AS marge_brute_n_28, t0.resultat_exploitation_n AS resultat_exploitation_n_29, t0.resultat_net_n AS resultat_net_n_30, t0.ca_n AS ca_n_31, t0.nb_personnes_n AS nb_personnes_n_32, t0.annee_n AS annee_n_33, t0.date_mise_a_jour AS date_mise_a_jour_34, t0.fichier_joint AS fichier_joint_35, t0.commentaire_interne AS commentaire_interne_36, t0.societe_cotee AS societe_cotee_37, t0.login_demande_publication AS login_demande_publication_38, t0.date_relance AS date_relance_39, t0.relance_mise_a_jour AS relance_mise_a_jour_40, t0.numero_siren AS numero_siren_41, t0.montant_total_investi AS montant_total_investi_42, t0.capital_total_investisseur AS capital_total_investisseur_43, t0.titre_newsletter AS titre_newsletter_44, t0.resume_newsletter AS resume_newsletter_45, t0.date_dernier_investissement AS date_dernier_investissement_46, t0.type_profil_participation AS type_profil_participation_47, t0.mode_societe AS mode_societe_48, t0.utiliser_artviper AS utiliser_artviper_49, t0.numero_siret AS numero_siret_50, t0.code_naf AS code_naf_51, t0.vignette AS vignette_52, t0.vignette_small AS vignette_small_53, t0.ca_n_inf AS ca_n_inf_54, t0.ca_n_sup AS ca_n_sup_55, t0.id_societe_mere AS id_societe_mere_56, t0.date_maj_administrateur AS date_maj_administrateur_57, t0.administrateur AS administrateur_58, t0.etat_resume AS etat_resume_59, t0.afficher_vendeur AS afficher_vendeur_60, t0.afficher_acheteur AS afficher_acheteur_61 FROM fusacq_dbo.societes t0 WHERE t0.raison_sociale = 'Alain Chemaly' LIMIT 1;
6	10.02 ms	SELECT t0.id_societe AS id_societe_1, t0.id_societe_news AS id_societe_news_2, t0.id_participation AS id_participation_3, t0.mode_participation AS mode_participation_4, t0.deja_publique AS deja_publique_5, t0.raison_sociale AS raison_sociale_6, t0.raison_sociale_formatee AS raison_sociale_formatee_7, t0.nom_president AS nom_president_8, t0.nom_directeur_general AS nom_directeur_general_9, t0.adresse AS adresse_10, t0.ville AS ville_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.id_pays AS id_pays_15, t0.devise AS devise_16, t0.id_region AS id_region_17, t0.filiales_bureaux AS filiales_bureaux_18, t0.id_secteur_activite AS id_secteur_activite_19, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20, t0.site_internet AS site_internet_21, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22, t0.mail_contact AS mail_contact_23, t0.resume_activite AS resume_activite_24, t0.description_activite AS description_activite_25, t0.mots_cles AS mots_cles_26, t0.strategie_developpement AS strategie_developpement_27, t0.marge_brute_n AS marge_brute_n_28, t0.resultat_exploitation_n AS resultat_exploitation_n_29, t0.resultat_net_n AS resultat_net_n_30, t0.ca_n AS ca_n_31, t0.nb_personnes_n AS nb_personnes_n_32, t0.annee_n AS annee_n_33, t0.date_mise_a_jour AS date_mise_a_jour_34, t0.fichier_joint AS fichier_joint_35, t0.commentaire_interne AS commentaire_interne_36, t0.societe_cotee AS societe_cotee_37, t0.login_demande_publication AS login_demande_publication_38, t0.date_relance AS date_relance_39, t0.relance_mise_a_jour AS relance_mise_a_jour_40, t0.numero_siren AS numero_siren_41, t0.montant_total_investi AS montant_total_investi_42, t0.capital_total_investisseur AS capital_total_investisseur_43, t0.titre_newsletter AS titre_newsletter_44, t0.resume_newsletter AS resume_newsletter_45, t0.date_dernier_investissement AS date_dernier_investissement_46, t0.type_profil_participation AS type_profil_participation_47, t0.mode_societe AS mode_societe_48, t0.utiliser_artviper AS utiliser_artviper_49, t0.numero_siret AS numero_siret_50, t0.code_naf AS code_naf_51, t0.vignette AS vignette_52, t0.vignette_small AS vignette_small_53, t0.ca_n_inf AS ca_n_inf_54, t0.ca_n_sup AS ca_n_sup_55, t0.id_societe_mere AS id_societe_mere_56, t0.date_maj_administrateur AS date_maj_administrateur_57, t0.administrateur AS administrateur_58, t0.etat_resume AS etat_resume_59, t0.afficher_vendeur AS afficher_vendeur_60, t0.afficher_acheteur AS afficher_acheteur_61 FROM fusacq_dbo.societes t0 WHERE t0.id_societe = ? Parameters: [`2808`] View formatted query View runnable query Explain query SELECT t0.id_societe AS id_societe_1, t0.id_societe_news AS id_societe_news_2, t0.id_participation AS id_participation_3, t0.mode_participation AS mode_participation_4, t0.deja_publique AS deja_publique_5, t0.raison_sociale AS raison_sociale_6, t0.raison_sociale_formatee AS raison_sociale_formatee_7, t0.nom_president AS nom_president_8, t0.nom_directeur_general AS nom_directeur_general_9, t0.adresse AS adresse_10, t0.ville AS ville_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.id_pays AS id_pays_15, t0.devise AS devise_16, t0.id_region AS id_region_17, t0.filiales_bureaux AS filiales_bureaux_18, t0.id_secteur_activite AS id_secteur_activite_19, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20, t0.site_internet AS site_internet_21, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22, t0.mail_contact AS mail_contact_23, t0.resume_activite AS resume_activite_24, t0.description_activite AS description_activite_25, t0.mots_cles AS mots_cles_26, t0.strategie_developpement AS strategie_developpement_27, t0.marge_brute_n AS marge_brute_n_28, t0.resultat_exploitation_n AS resultat_exploitation_n_29, t0.resultat_net_n AS resultat_net_n_30, t0.ca_n AS ca_n_31, t0.nb_personnes_n AS nb_personnes_n_32, t0.annee_n AS annee_n_33, t0.date_mise_a_jour AS date_mise_a_jour_34, t0.fichier_joint AS fichier_joint_35, t0.commentaire_interne AS commentaire_interne_36, t0.societe_cotee AS societe_cotee_37, t0.login_demande_publication AS login_demande_publication_38, t0.date_relance AS date_relance_39, t0.relance_mise_a_jour AS relance_mise_a_jour_40, t0.numero_siren AS numero_siren_41, t0.montant_total_investi AS montant_total_investi_42, t0.capital_total_investisseur AS capital_total_investisseur_43, t0.titre_newsletter AS titre_newsletter_44, t0.resume_newsletter AS resume_newsletter_45, t0.date_dernier_investissement AS date_dernier_investissement_46, t0.type_profil_participation AS type_profil_participation_47, t0.mode_societe AS mode_societe_48, t0.utiliser_artviper AS utiliser_artviper_49, t0.numero_siret AS numero_siret_50, t0.code_naf AS code_naf_51, t0.vignette AS vignette_52, t0.vignette_small AS vignette_small_53, t0.ca_n_inf AS ca_n_inf_54, t0.ca_n_sup AS ca_n_sup_55, t0.id_societe_mere AS id_societe_mere_56, t0.date_maj_administrateur AS date_maj_administrateur_57, t0.administrateur AS administrateur_58, t0.etat_resume AS etat_resume_59, t0.afficher_vendeur AS afficher_vendeur_60, t0.afficher_acheteur AS afficher_acheteur_61 FROM fusacq_dbo.societes t0 WHERE t0.id_societe = ? SELECT t0.id_societe AS id_societe_1, t0.id_societe_news AS id_societe_news_2, t0.id_participation AS id_participation_3, t0.mode_participation AS mode_participation_4, t0.deja_publique AS deja_publique_5, t0.raison_sociale AS raison_sociale_6, t0.raison_sociale_formatee AS raison_sociale_formatee_7, t0.nom_president AS nom_president_8, t0.nom_directeur_general AS nom_directeur_general_9, t0.adresse AS adresse_10, t0.ville AS ville_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.id_pays AS id_pays_15, t0.devise AS devise_16, t0.id_region AS id_region_17, t0.filiales_bureaux AS filiales_bureaux_18, t0.id_secteur_activite AS id_secteur_activite_19, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20, t0.site_internet AS site_internet_21, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22, t0.mail_contact AS mail_contact_23, t0.resume_activite AS resume_activite_24, t0.description_activite AS description_activite_25, t0.mots_cles AS mots_cles_26, t0.strategie_developpement AS strategie_developpement_27, t0.marge_brute_n AS marge_brute_n_28, t0.resultat_exploitation_n AS resultat_exploitation_n_29, t0.resultat_net_n AS resultat_net_n_30, t0.ca_n AS ca_n_31, t0.nb_personnes_n AS nb_personnes_n_32, t0.annee_n AS annee_n_33, t0.date_mise_a_jour AS date_mise_a_jour_34, t0.fichier_joint AS fichier_joint_35, t0.commentaire_interne AS commentaire_interne_36, t0.societe_cotee AS societe_cotee_37, t0.login_demande_publication AS login_demande_publication_38, t0.date_relance AS date_relance_39, t0.relance_mise_a_jour AS relance_mise_a_jour_40, t0.numero_siren AS numero_siren_41, t0.montant_total_investi AS montant_total_investi_42, t0.capital_total_investisseur AS capital_total_investisseur_43, t0.titre_newsletter AS titre_newsletter_44, t0.resume_newsletter AS resume_newsletter_45, t0.date_dernier_investissement AS date_dernier_investissement_46, t0.type_profil_participation AS type_profil_participation_47, t0.mode_societe AS mode_societe_48, t0.utiliser_artviper AS utiliser_artviper_49, t0.numero_siret AS numero_siret_50, t0.code_naf AS code_naf_51, t0.vignette AS vignette_52, t0.vignette_small AS vignette_small_53, t0.ca_n_inf AS ca_n_inf_54, t0.ca_n_sup AS ca_n_sup_55, t0.id_societe_mere AS id_societe_mere_56, t0.date_maj_administrateur AS date_maj_administrateur_57, t0.administrateur AS administrateur_58, t0.etat_resume AS etat_resume_59, t0.afficher_vendeur AS afficher_vendeur_60, t0.afficher_acheteur AS afficher_acheteur_61 FROM fusacq_dbo.societes t0 WHERE t0.id_societe = 2808;
7	10.71 ms	SELECT DISTINCT b0_.id_operation AS id_operation_0, b1_.id_actualite AS id_actualite_1, b1_.date_mise_en_ligne AS date_mise_en_ligne_2, b1_.titre_actualite AS titre_actualite_3, b1_.provenance_flux_actualite AS provenance_flux_actualite_4, b1_.autorisation_blog AS autorisation_blog_5 FROM fusacq_dbo.buzz_roles b0_ LEFT JOIN fusacq_dbo.buzz_actualites b1_ ON (b0_.id_operation = b1_.id_operation) WHERE b1_.mode_actualite = ? AND b1_.mode_actualite <> ? AND b1_.date_mise_en_ligne IS NOT NULL AND b1_.date_mise_en_ligne <> ? AND SUBSTRING(b1_.date_mise_en_ligne FROM 1 FOR 8) <= ? AND b1_.autorisation_blog <> ? AND ((b0_.id_acteur = ? AND b0_.table_sql_acteur = ?) OR (b0_.id_acteur_passif = ? AND b0_.table_sql_acteur_passif = ?)) ORDER BY b1_.date_mise_en_ligne DESC LIMIT 1000 Parameters: [`"publique" "supprime" "" "20260403" "non" "2808" "societes_news" "2808" "societes_news"`] View formatted query View runnable query Explain query SELECT DISTINCT b0_.id_operation AS id_operation_0, b1_.id_actualite AS id_actualite_1, b1_.date_mise_en_ligne AS date_mise_en_ligne_2, b1_.titre_actualite AS titre_actualite_3, b1_.provenance_flux_actualite AS provenance_flux_actualite_4, b1_.autorisation_blog AS autorisation_blog_5 FROM fusacq_dbo.buzz_roles b0_ LEFT JOIN fusacq_dbo.buzz_actualites b1_ ON ( b0_.id_operation = b1_.id_operation ) WHERE b1_.mode_actualite = ? AND b1_.mode_actualite <> ? AND b1_.date_mise_en_ligne IS NOT NULL AND b1_.date_mise_en_ligne <> ? AND SUBSTRING( b1_.date_mise_en_ligne FROM 1 FOR 8 ) <= ? AND b1_.autorisation_blog <> ? AND ( ( b0_.id_acteur = ? AND b0_.table_sql_acteur = ? ) OR ( b0_.id_acteur_passif = ? AND b0_.table_sql_acteur_passif = ? ) ) ORDER BY b1_.date_mise_en_ligne DESC LIMIT 1000 SELECT DISTINCT b0_.id_operation AS id_operation_0, b1_.id_actualite AS id_actualite_1, b1_.date_mise_en_ligne AS date_mise_en_ligne_2, b1_.titre_actualite AS titre_actualite_3, b1_.provenance_flux_actualite AS provenance_flux_actualite_4, b1_.autorisation_blog AS autorisation_blog_5 FROM fusacq_dbo.buzz_roles b0_ LEFT JOIN fusacq_dbo.buzz_actualites b1_ ON (b0_.id_operation = b1_.id_operation) WHERE b1_.mode_actualite = 'publique' AND b1_.mode_actualite <> 'supprime' AND b1_.date_mise_en_ligne IS NOT NULL AND b1_.date_mise_en_ligne <> '' AND SUBSTRING(b1_.date_mise_en_ligne FROM 1 FOR 8) <= '20260403' AND b1_.autorisation_blog <> 'non' AND ((b0_.id_acteur = '2808' AND b0_.table_sql_acteur = 'societes_news') OR (b0_.id_acteur_passif = '2808' AND b0_.table_sql_acteur_passif = 'societes_news')) ORDER BY b1_.date_mise_en_ligne DESC LIMIT 1000;
8	9.87 ms	SELECT b0_.id_operation AS id_operation_0, b0_.provenance_flux_actualite AS provenance_flux_actualite_1, b0_.visibilite_flux AS visibilite_flux_2 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1 Parameters: [`86944`] View formatted query View runnable query Explain query SELECT b0_.id_operation AS id_operation_0, b0_.provenance_flux_actualite AS provenance_flux_actualite_1, b0_.visibilite_flux AS visibilite_flux_2 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1 SELECT b0_.id_operation AS id_operation_0, b0_.provenance_flux_actualite AS provenance_flux_actualite_1, b0_.visibilite_flux AS visibilite_flux_2 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 86944 LIMIT 1;
9	9.90 ms	SELECT b0_.id_secteur_activite AS id_secteur_activite_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_operation = ? LIMIT 1 Parameters: [`11212`] View formatted query View runnable query Explain query SELECT b0_.id_secteur_activite AS id_secteur_activite_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_operation = ? LIMIT 1 SELECT b0_.id_secteur_activite AS id_secteur_activite_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_operation = 11212 LIMIT 1;
10	9.94 ms	SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1 Parameters: [`86944`] View formatted query View runnable query Explain query SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1 SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 86944 LIMIT 1;
11	10.54 ms	SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.description_activite AS description_activite_2, a0_.date_parution AS date_parution_3, a0_.date_parution_initiale AS date_parution_initiale_4, a0_.id_secteur_activite AS id_secteur_activite_5, a0_.code_naf_oseo_nouveau AS code_naf_oseo_nouveau_6, a0_.ca_n AS ca_n_7, a0_.id_departement AS id_departement_8, a0_.id_region AS id_region_9, a0_.id_pays AS id_pays_10, a0_.zone_geographique AS zone_geographique_11 FROM buzz_lien_operations_annonces_vendeur b1_ LEFT JOIN fusacq_dbo.annonces_vendeur a0_ ON (b1_.id_annonce = a0_.id_annonce_vendeur) WHERE b1_.id_operation = ? ORDER BY a0_.ca_n DESC LIMIT 5 Parameters: [`11212`] View formatted query View runnable query Explain query SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.description_activite AS description_activite_2, a0_.date_parution AS date_parution_3, a0_.date_parution_initiale AS date_parution_initiale_4, a0_.id_secteur_activite AS id_secteur_activite_5, a0_.code_naf_oseo_nouveau AS code_naf_oseo_nouveau_6, a0_.ca_n AS ca_n_7, a0_.id_departement AS id_departement_8, a0_.id_region AS id_region_9, a0_.id_pays AS id_pays_10, a0_.zone_geographique AS zone_geographique_11 FROM buzz_lien_operations_annonces_vendeur b1_ LEFT JOIN fusacq_dbo.annonces_vendeur a0_ ON ( b1_.id_annonce = a0_.id_annonce_vendeur ) WHERE b1_.id_operation = ? ORDER BY a0_.ca_n DESC LIMIT 5 SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.description_activite AS description_activite_2, a0_.date_parution AS date_parution_3, a0_.date_parution_initiale AS date_parution_initiale_4, a0_.id_secteur_activite AS id_secteur_activite_5, a0_.code_naf_oseo_nouveau AS code_naf_oseo_nouveau_6, a0_.ca_n AS ca_n_7, a0_.id_departement AS id_departement_8, a0_.id_region AS id_region_9, a0_.id_pays AS id_pays_10, a0_.zone_geographique AS zone_geographique_11 FROM buzz_lien_operations_annonces_vendeur b1_ LEFT JOIN fusacq_dbo.annonces_vendeur a0_ ON (b1_.id_annonce = a0_.id_annonce_vendeur) WHERE b1_.id_operation = 11212 ORDER BY a0_.ca_n DESC LIMIT 5;
12	9.91 ms	SELECT b0_.id_secteur_activite AS id_secteur_activite_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_operation = ? LIMIT 1 Parameters: [`11212`] View formatted query View runnable query Explain query SELECT b0_.id_secteur_activite AS id_secteur_activite_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_operation = ? LIMIT 1 SELECT b0_.id_secteur_activite AS id_secteur_activite_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_operation = 11212 LIMIT 1;
13	10.28 ms	SELECT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.ca_max AS ca_max_2, a0_.id_region AS id_region_3, a0_.id_pays AS id_pays_4, a0_.id_departement AS id_departement_5, a0_.autres_localisations AS autres_localisations_6 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.id_secteur_activite = ? AND a0_.mode_annonce = ? AND a0_.tpe_pme = ? ORDER BY a0_.date_parution_initiale DESC LIMIT 5 Parameters: [`60607 "publique" "oui"`] View formatted query View runnable query Explain query SELECT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.ca_max AS ca_max_2, a0_.id_region AS id_region_3, a0_.id_pays AS id_pays_4, a0_.id_departement AS id_departement_5, a0_.autres_localisations AS autres_localisations_6 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.id_secteur_activite = ? AND a0_.mode_annonce = ? AND a0_.tpe_pme = ? ORDER BY a0_.date_parution_initiale DESC LIMIT 5 SELECT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.ca_max AS ca_max_2, a0_.id_region AS id_region_3, a0_.id_pays AS id_pays_4, a0_.id_departement AS id_departement_5, a0_.autres_localisations AS autres_localisations_6 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.id_secteur_activite = 60607 AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' ORDER BY a0_.date_parution_initiale DESC LIMIT 5;
14	9.92 ms	SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.nom_secteur_activite AS nom_secteur_activite_1, s0_.nom_secteur_activite AS nom_secteur_activite_2 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite = ? Parameters: [`60607`] 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_secteur_activite AS nom_secteur_activite_2 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite = ? SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.nom_secteur_activite AS nom_secteur_activite_1, s0_.nom_secteur_activite AS nom_secteur_activite_2 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite = 60607;
15	10.06 ms	SELECT t0.id_operation AS id_operation_1, t0.titre_operation AS titre_operation_2, t0.type_operation AS type_operation_3, t0.mots_cles AS mots_cles_4, t0.personne_physique_impliquee AS personne_physique_impliquee_5, t0.societe_impliquee AS societe_impliquee_6, t0.fonds_implique AS fonds_implique_7, t0.suivi_operation AS suivi_operation_8, t0.date_operation AS date_operation_9, t0.id_secteur_activite AS id_secteur_activite_10, t0.id_localisation AS id_localisation_11, t0.id_localisation_2 AS id_localisation_2_12, t0.id_actualite_principale AS id_actualite_principale_13, t0.visibilite_sur_annonces_fusacq AS visibilite_sur_annonces_fusacq_14, t0.code_naf AS code_naf_15, t0.montant_operation AS montant_operation_16, t0.ca_societe_achetee AS ca_societe_achetee_17, t0.mode_operation AS mode_operation_18, t0.mots_cles_valides AS mots_cles_valides_19, t0.check_rattrapage AS check_rattrapage_20, t0.pct_capital_achete AS pct_capital_achete_21, t0.maj_min_capital AS maj_min_capital_22, t0.fourchette_ca AS fourchette_ca_23, t0.nb_compte_classement AS nb_compte_classement_24, t0.montant_compte_classement AS montant_compte_classement_25 FROM fusacq_dbo.buzz_operations t0 WHERE t0.id_operation = ? Parameters: [`11212`] View formatted query View runnable query Explain query SELECT t0.id_operation AS id_operation_1, t0.titre_operation AS titre_operation_2, t0.type_operation AS type_operation_3, t0.mots_cles AS mots_cles_4, t0.personne_physique_impliquee AS personne_physique_impliquee_5, t0.societe_impliquee AS societe_impliquee_6, t0.fonds_implique AS fonds_implique_7, t0.suivi_operation AS suivi_operation_8, t0.date_operation AS date_operation_9, t0.id_secteur_activite AS id_secteur_activite_10, t0.id_localisation AS id_localisation_11, t0.id_localisation_2 AS id_localisation_2_12, t0.id_actualite_principale AS id_actualite_principale_13, t0.visibilite_sur_annonces_fusacq AS visibilite_sur_annonces_fusacq_14, t0.code_naf AS code_naf_15, t0.montant_operation AS montant_operation_16, t0.ca_societe_achetee AS ca_societe_achetee_17, t0.mode_operation AS mode_operation_18, t0.mots_cles_valides AS mots_cles_valides_19, t0.check_rattrapage AS check_rattrapage_20, t0.pct_capital_achete AS pct_capital_achete_21, t0.maj_min_capital AS maj_min_capital_22, t0.fourchette_ca AS fourchette_ca_23, t0.nb_compte_classement AS nb_compte_classement_24, t0.montant_compte_classement AS montant_compte_classement_25 FROM fusacq_dbo.buzz_operations t0 WHERE t0.id_operation = ? SELECT t0.id_operation AS id_operation_1, t0.titre_operation AS titre_operation_2, t0.type_operation AS type_operation_3, t0.mots_cles AS mots_cles_4, t0.personne_physique_impliquee AS personne_physique_impliquee_5, t0.societe_impliquee AS societe_impliquee_6, t0.fonds_implique AS fonds_implique_7, t0.suivi_operation AS suivi_operation_8, t0.date_operation AS date_operation_9, t0.id_secteur_activite AS id_secteur_activite_10, t0.id_localisation AS id_localisation_11, t0.id_localisation_2 AS id_localisation_2_12, t0.id_actualite_principale AS id_actualite_principale_13, t0.visibilite_sur_annonces_fusacq AS visibilite_sur_annonces_fusacq_14, t0.code_naf AS code_naf_15, t0.montant_operation AS montant_operation_16, t0.ca_societe_achetee AS ca_societe_achetee_17, t0.mode_operation AS mode_operation_18, t0.mots_cles_valides AS mots_cles_valides_19, t0.check_rattrapage AS check_rattrapage_20, t0.pct_capital_achete AS pct_capital_achete_21, t0.maj_min_capital AS maj_min_capital_22, t0.fourchette_ca AS fourchette_ca_23, t0.nb_compte_classement AS nb_compte_classement_24, t0.montant_compte_classement AS montant_compte_classement_25 FROM fusacq_dbo.buzz_operations t0 WHERE t0.id_operation = 11212;
16	10.63 ms	SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.description_activite AS description_activite_2, a0_.date_parution AS date_parution_3, a0_.date_parution_initiale AS date_parution_initiale_4, a0_.id_secteur_activite AS id_secteur_activite_5, a0_.code_naf_oseo_nouveau AS code_naf_oseo_nouveau_6, a0_.ca_n AS ca_n_7, a0_.id_departement AS id_departement_8, a0_.id_region AS id_region_9, a0_.id_pays AS id_pays_10, a0_.zone_geographique AS zone_geographique_11 FROM buzz_lien_operations_annonces_vendeur b1_ LEFT JOIN fusacq_dbo.annonces_vendeur a0_ ON (b1_.id_annonce = a0_.id_annonce_vendeur) WHERE b1_.id_operation = ? ORDER BY a0_.ca_n DESC LIMIT 5 Parameters: [`11212`] View formatted query View runnable query Explain query SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.description_activite AS description_activite_2, a0_.date_parution AS date_parution_3, a0_.date_parution_initiale AS date_parution_initiale_4, a0_.id_secteur_activite AS id_secteur_activite_5, a0_.code_naf_oseo_nouveau AS code_naf_oseo_nouveau_6, a0_.ca_n AS ca_n_7, a0_.id_departement AS id_departement_8, a0_.id_region AS id_region_9, a0_.id_pays AS id_pays_10, a0_.zone_geographique AS zone_geographique_11 FROM buzz_lien_operations_annonces_vendeur b1_ LEFT JOIN fusacq_dbo.annonces_vendeur a0_ ON ( b1_.id_annonce = a0_.id_annonce_vendeur ) WHERE b1_.id_operation = ? ORDER BY a0_.ca_n DESC LIMIT 5 SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.description_activite AS description_activite_2, a0_.date_parution AS date_parution_3, a0_.date_parution_initiale AS date_parution_initiale_4, a0_.id_secteur_activite AS id_secteur_activite_5, a0_.code_naf_oseo_nouveau AS code_naf_oseo_nouveau_6, a0_.ca_n AS ca_n_7, a0_.id_departement AS id_departement_8, a0_.id_region AS id_region_9, a0_.id_pays AS id_pays_10, a0_.zone_geographique AS zone_geographique_11 FROM buzz_lien_operations_annonces_vendeur b1_ LEFT JOIN fusacq_dbo.annonces_vendeur a0_ ON (b1_.id_annonce = a0_.id_annonce_vendeur) WHERE b1_.id_operation = 11212 ORDER BY a0_.ca_n DESC LIMIT 5;
17	9.87 ms	SELECT b0_.id_secteur_activite AS id_secteur_activite_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_operation = ? LIMIT 1 Parameters: [`11212`] View formatted query View runnable query Explain query SELECT b0_.id_secteur_activite AS id_secteur_activite_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_operation = ? LIMIT 1 SELECT b0_.id_secteur_activite AS id_secteur_activite_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_operation = 11212 LIMIT 1;
18	10.31 ms	SELECT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.ca_max AS ca_max_2, a0_.id_region AS id_region_3, a0_.id_pays AS id_pays_4, a0_.id_departement AS id_departement_5, a0_.autres_localisations AS autres_localisations_6 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.id_secteur_activite = ? AND a0_.mode_annonce = ? AND a0_.tpe_pme = ? ORDER BY a0_.date_parution_initiale DESC LIMIT 5 Parameters: [`60607 "publique" "oui"`] View formatted query View runnable query Explain query SELECT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.ca_max AS ca_max_2, a0_.id_region AS id_region_3, a0_.id_pays AS id_pays_4, a0_.id_departement AS id_departement_5, a0_.autres_localisations AS autres_localisations_6 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.id_secteur_activite = ? AND a0_.mode_annonce = ? AND a0_.tpe_pme = ? ORDER BY a0_.date_parution_initiale DESC LIMIT 5 SELECT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.ca_max AS ca_max_2, a0_.id_region AS id_region_3, a0_.id_pays AS id_pays_4, a0_.id_departement AS id_departement_5, a0_.autres_localisations AS autres_localisations_6 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.id_secteur_activite = 60607 AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' ORDER BY a0_.date_parution_initiale DESC LIMIT 5;
19	9.96 ms	SELECT id_localisation, id_localisation_2 FROM fusacq_dbo.buzz_operations WHERE id_operation = ? LIMIT 1 Parameters: [`11212`] View formatted query View runnable query Explain query SELECT id_localisation, id_localisation_2 FROM fusacq_dbo.buzz_operations WHERE id_operation = ? LIMIT 1 SELECT id_localisation, id_localisation_2 FROM fusacq_dbo.buzz_operations WHERE id_operation = 11212 LIMIT 1;
20	9.97 ms	SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.nom_secteur_activite AS nom_secteur_activite_1, s0_.nom_secteur_activite AS nom_secteur_activite_2 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite = ? Parameters: [`60607`] 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_secteur_activite AS nom_secteur_activite_2 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite = ? SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.nom_secteur_activite AS nom_secteur_activite_1, s0_.nom_secteur_activite AS nom_secteur_activite_2 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite = 60607;
21	36.04 ms	SELECT * FROM (( SELECT DISTINCT ba.id_actualite, ba.date_mise_en_ligne, ba.titre_actualite, ba.sous_titre, ba.provenance_flux_actualite, ba.id_message_blog, ba.id_societe_prestataire, ba.visibilite_flux FROM fusacq_dbo.buzz_operations bo INNER JOIN fusacq_dbo.buzz_actualites ba ON bo.id_actualite_principale = ba.id_actualite WHERE ba.mode_actualite = 'publique' AND ( (ba.provenance_flux_actualite = 'blog' AND ba.visibilite_flux LIKE '%collaborative%') OR ba.provenance_flux_actualite != 'blog' ) AND bo.id_actualite_principale IS NOT NULL AND ba.id_actualite IS NOT NULL AND bo.id_secteur_activite = 60607 ) UNION ( SELECT DISTINCT ba.id_actualite, ba.date_mise_en_ligne, ba.titre_actualite, ba.sous_titre, ba.provenance_flux_actualite, ba.id_message_blog, ba.id_societe_prestataire, ba.visibilite_flux FROM fusacq_dbo.buzz_actualites ba INNER JOIN fusacq_dbo.buzz_operations bo ON ba.id_operation = bo.id_operation WHERE ba.mode_actualite = 'publique' AND ( (ba.provenance_flux_actualite = 'blog' AND ba.visibilite_flux LIKE '%collaborative%') OR ba.provenance_flux_actualite != 'blog' ) AND ba.id_operation IS NOT NULL AND bo.id_secteur_activite = 60607 )) AS combined WHERE id_actualite != 86944 ORDER BY date_mise_en_ligne DESC LIMIT 5 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM ( ( SELECT DISTINCT ba.id_actualite, ba.date_mise_en_ligne, ba.titre_actualite, ba.sous_titre, ba.provenance_flux_actualite, ba.id_message_blog, ba.id_societe_prestataire, ba.visibilite_flux FROM fusacq_dbo.buzz_operations bo INNER JOIN fusacq_dbo.buzz_actualites ba ON bo.id_actualite_principale = ba.id_actualite WHERE ba.mode_actualite = 'publique' AND ( ( ba.provenance_flux_actualite = 'blog' AND ba.visibilite_flux LIKE '%collaborative%' ) OR ba.provenance_flux_actualite != 'blog' ) AND bo.id_actualite_principale IS NOT NULL AND ba.id_actualite IS NOT NULL AND bo.id_secteur_activite = 60607 ) UNION ( SELECT DISTINCT ba.id_actualite, ba.date_mise_en_ligne, ba.titre_actualite, ba.sous_titre, ba.provenance_flux_actualite, ba.id_message_blog, ba.id_societe_prestataire, ba.visibilite_flux FROM fusacq_dbo.buzz_actualites ba INNER JOIN fusacq_dbo.buzz_operations bo ON ba.id_operation = bo.id_operation WHERE ba.mode_actualite = 'publique' AND ( ( ba.provenance_flux_actualite = 'blog' AND ba.visibilite_flux LIKE '%collaborative%' ) OR ba.provenance_flux_actualite != 'blog' ) AND ba.id_operation IS NOT NULL AND bo.id_secteur_activite = 60607 ) ) AS combined WHERE id_actualite != 86944 ORDER BY date_mise_en_ligne DESC LIMIT 5 SELECT * FROM (( SELECT DISTINCT ba.id_actualite, ba.date_mise_en_ligne, ba.titre_actualite, ba.sous_titre, ba.provenance_flux_actualite, ba.id_message_blog, ba.id_societe_prestataire, ba.visibilite_flux FROM fusacq_dbo.buzz_operations bo INNER JOIN fusacq_dbo.buzz_actualites ba ON bo.id_actualite_principale = ba.id_actualite WHERE ba.mode_actualite = 'publique' AND ( (ba.provenance_flux_actualite = 'blog' AND ba.visibilite_flux LIKE '%collaborative%') OR ba.provenance_flux_actualite != 'blog' ) AND bo.id_actualite_principale IS NOT NULL AND ba.id_actualite IS NOT NULL AND bo.id_secteur_activite = 60607 ) UNION ( SELECT DISTINCT ba.id_actualite, ba.date_mise_en_ligne, ba.titre_actualite, ba.sous_titre, ba.provenance_flux_actualite, ba.id_message_blog, ba.id_societe_prestataire, ba.visibilite_flux FROM fusacq_dbo.buzz_actualites ba INNER JOIN fusacq_dbo.buzz_operations bo ON ba.id_operation = bo.id_operation WHERE ba.mode_actualite = 'publique' AND ( (ba.provenance_flux_actualite = 'blog' AND ba.visibilite_flux LIKE '%collaborative%') OR ba.provenance_flux_actualite != 'blog' ) AND ba.id_operation IS NOT NULL AND bo.id_secteur_activite = 60607 )) AS combined WHERE id_actualite != 86944 ORDER BY date_mise_en_ligne DESC LIMIT 5;
22	9.90 ms	SELECT t0.id_localisation AS id_localisation_1, t0.dept AS dept_2, t0.nom_localisation AS nom_localisation_3, t0.id_localisation_pere AS id_localisation_pere_4, t0.prefixe AS prefixe_5, t0.recherche AS recherche_6 FROM fusacq_dbo.localisations t0 WHERE t0.id_localisation = ? Parameters: [`"33_22"`] View formatted query View runnable query Explain query SELECT t0.id_localisation AS id_localisation_1, t0.dept AS dept_2, t0.nom_localisation AS nom_localisation_3, t0.id_localisation_pere AS id_localisation_pere_4, t0.prefixe AS prefixe_5, t0.recherche AS recherche_6 FROM fusacq_dbo.localisations t0 WHERE t0.id_localisation = ? SELECT t0.id_localisation AS id_localisation_1, t0.dept AS dept_2, t0.nom_localisation AS nom_localisation_3, t0.id_localisation_pere AS id_localisation_pere_4, t0.prefixe AS prefixe_5, t0.recherche AS recherche_6 FROM fusacq_dbo.localisations t0 WHERE t0.id_localisation = '33_22';
23	43.68 ms	SELECT id, titre_annonce, date_parution_initiale_complete, date_parution_initiale, type_annonce, date_tri FROM ( SELECT id_annonce_vendeur AS id, titre_annonce, date_parution_initiale_complete, date_parution_initiale, 'V' AS type_annonce, CASE WHEN date_parution_initiale_complete IS NOT NULL AND date_parution_initiale_complete != '' AND LENGTH(date_parution_initiale_complete) >= 12 AND LENGTH(date_parution_initiale_complete) <= 14 THEN CASE WHEN LENGTH(date_parution_initiale_complete) = 14 THEN date_parution_initiale_complete ELSE CONCAT(date_parution_initiale_complete, '00') END ELSE CONCAT(date_parution_initiale, '000000') END AS date_tri FROM annonces_vendeur WHERE mode_annonce = 'publique' AND tpe_pme = 'oui' AND visible_dernieres_annonces IS NULL AND date_parution_initiale IS NOT NULL UNION ALL SELECT id_annonce_acheteur AS id, titre_annonce, date_parution_initiale_complete, date_parution_initiale, 'A' AS type_annonce, CASE WHEN date_parution_initiale_complete IS NOT NULL AND date_parution_initiale_complete != '' AND LENGTH(date_parution_initiale_complete) >= 12 AND LENGTH(date_parution_initiale_complete) <= 14 THEN CASE WHEN LENGTH(date_parution_initiale_complete) = 14 THEN date_parution_initiale_complete ELSE CONCAT(date_parution_initiale_complete, '00') END ELSE CONCAT(date_parution_initiale, '000000') END AS date_tri FROM annonces_acheteur WHERE mode_annonce = 'publique' AND tpe_pme = 'oui' AND date_parution_initiale IS NOT NULL UNION ALL SELECT id_repreneur AS id, titre_profil AS titre_annonce, date_parution_initiale_complete, date_parution_initiale, 'R' AS type_annonce, CASE WHEN date_parution_initiale_complete IS NOT NULL AND date_parution_initiale_complete != '' AND LENGTH(date_parution_initiale_complete) >= 12 AND LENGTH(date_parution_initiale_complete) <= 14 THEN CASE WHEN LENGTH(date_parution_initiale_complete) = 14 THEN date_parution_initiale_complete ELSE CONCAT(date_parution_initiale_complete, '00') END ELSE CONCAT(date_parution_initiale, '000000') END AS date_tri FROM annuaire_repreneurs WHERE mode_profil = 'publique' AND date_parution_initiale IS NOT NULL ) AS en_direct ORDER BY date_tri DESC, id DESC LIMIT :limit Parameters: [`"limit" => 5`] View formatted query View runnable query Explain query SELECT id, titre_annonce, date_parution_initiale_complete, date_parution_initiale, type_annonce, date_tri FROM ( SELECT id_annonce_vendeur AS id, titre_annonce, date_parution_initiale_complete, date_parution_initiale, 'V' AS type_annonce, CASE WHEN date_parution_initiale_complete IS NOT NULL AND date_parution_initiale_complete != '' AND LENGTH( date_parution_initiale_complete ) >= 12 AND LENGTH( date_parution_initiale_complete ) <= 14 THEN CASE WHEN LENGTH( date_parution_initiale_complete ) = 14 THEN date_parution_initiale_complete ELSE CONCAT( date_parution_initiale_complete, '00' ) END ELSE CONCAT( date_parution_initiale, '000000' ) END AS date_tri FROM annonces_vendeur WHERE mode_annonce = 'publique' AND tpe_pme = 'oui' AND visible_dernieres_annonces IS NULL AND date_parution_initiale IS NOT NULL UNION ALL SELECT id_annonce_acheteur AS id, titre_annonce, date_parution_initiale_complete, date_parution_initiale, 'A' AS type_annonce, CASE WHEN date_parution_initiale_complete IS NOT NULL AND date_parution_initiale_complete != '' AND LENGTH( date_parution_initiale_complete ) >= 12 AND LENGTH( date_parution_initiale_complete ) <= 14 THEN CASE WHEN LENGTH( date_parution_initiale_complete ) = 14 THEN date_parution_initiale_complete ELSE CONCAT( date_parution_initiale_complete, '00' ) END ELSE CONCAT( date_parution_initiale, '000000' ) END AS date_tri FROM annonces_acheteur WHERE mode_annonce = 'publique' AND tpe_pme = 'oui' AND date_parution_initiale IS NOT NULL UNION ALL SELECT id_repreneur AS id, titre_profil AS titre_annonce, date_parution_initiale_complete, date_parution_initiale, 'R' AS type_annonce, CASE WHEN date_parution_initiale_complete IS NOT NULL AND date_parution_initiale_complete != '' AND LENGTH( date_parution_initiale_complete ) >= 12 AND LENGTH( date_parution_initiale_complete ) <= 14 THEN CASE WHEN LENGTH( date_parution_initiale_complete ) = 14 THEN date_parution_initiale_complete ELSE CONCAT( date_parution_initiale_complete, '00' ) END ELSE CONCAT( date_parution_initiale, '000000' ) END AS date_tri FROM annuaire_repreneurs WHERE mode_profil = 'publique' AND date_parution_initiale IS NOT NULL ) AS en_direct ORDER BY date_tri DESC, id DESC LIMIT :limit SELECT id, titre_annonce, date_parution_initiale_complete, date_parution_initiale, type_annonce, date_tri FROM ( SELECT id_annonce_vendeur AS id, titre_annonce, date_parution_initiale_complete, date_parution_initiale, 'V' AS type_annonce, CASE WHEN date_parution_initiale_complete IS NOT NULL AND date_parution_initiale_complete != '' AND LENGTH(date_parution_initiale_complete) >= 12 AND LENGTH(date_parution_initiale_complete) <= 14 THEN CASE WHEN LENGTH(date_parution_initiale_complete) = 14 THEN date_parution_initiale_complete ELSE CONCAT(date_parution_initiale_complete, '00') END ELSE CONCAT(date_parution_initiale, '000000') END AS date_tri FROM annonces_vendeur WHERE mode_annonce = 'publique' AND tpe_pme = 'oui' AND visible_dernieres_annonces IS NULL AND date_parution_initiale IS NOT NULL UNION ALL SELECT id_annonce_acheteur AS id, titre_annonce, date_parution_initiale_complete, date_parution_initiale, 'A' AS type_annonce, CASE WHEN date_parution_initiale_complete IS NOT NULL AND date_parution_initiale_complete != '' AND LENGTH(date_parution_initiale_complete) >= 12 AND LENGTH(date_parution_initiale_complete) <= 14 THEN CASE WHEN LENGTH(date_parution_initiale_complete) = 14 THEN date_parution_initiale_complete ELSE CONCAT(date_parution_initiale_complete, '00') END ELSE CONCAT(date_parution_initiale, '000000') END AS date_tri FROM annonces_acheteur WHERE mode_annonce = 'publique' AND tpe_pme = 'oui' AND date_parution_initiale IS NOT NULL UNION ALL SELECT id_repreneur AS id, titre_profil AS titre_annonce, date_parution_initiale_complete, date_parution_initiale, 'R' AS type_annonce, CASE WHEN date_parution_initiale_complete IS NOT NULL AND date_parution_initiale_complete != '' AND LENGTH(date_parution_initiale_complete) >= 12 AND LENGTH(date_parution_initiale_complete) <= 14 THEN CASE WHEN LENGTH(date_parution_initiale_complete) = 14 THEN date_parution_initiale_complete ELSE CONCAT(date_parution_initiale_complete, '00') END ELSE CONCAT(date_parution_initiale, '000000') END AS date_tri FROM annuaire_repreneurs WHERE mode_profil = 'publique' AND date_parution_initiale IS NOT NULL ) AS en_direct ORDER BY date_tri DESC, id DESC LIMIT 5 ;
24	113.42 ms	SELECT id_actualite, jour, mois, type_actualite, titre_actualite, date_mise_en_ligne FROM ( SELECT id_actualite, SUBSTRING(date_mise_en_ligne, 7, 2) AS jour, SUBSTRING(date_mise_en_ligne, 5, 2) AS mois, type_actualite, titre_actualite, date_mise_en_ligne, ROW_NUMBER() OVER (PARTITION BY type_actualite ORDER BY date_mise_en_ligne DESC) AS rn FROM buzz_actualites WHERE provenance_flux_actualite = 'blog' AND mode_actualite = 'publique' AND date_mise_en_ligne <= :now AND id_localisation LIKE CONCAT(:idPays, '%') ) t WHERE rn <= 2 ORDER BY date_mise_en_ligne DESC, id_actualite DESC Parameters: [`"idPays" => "33" "now" => "20260403161215"`] View formatted query View runnable query Explain query SELECT id_actualite, jour, mois, type_actualite, titre_actualite, date_mise_en_ligne FROM ( SELECT id_actualite, SUBSTRING(date_mise_en_ligne, 7, 2) AS jour, SUBSTRING(date_mise_en_ligne, 5, 2) AS mois, type_actualite, titre_actualite, date_mise_en_ligne, ROW_NUMBER() OVER ( PARTITION BY type_actualite ORDER BY date_mise_en_ligne DESC ) AS rn FROM buzz_actualites WHERE provenance_flux_actualite = 'blog' AND mode_actualite = 'publique' AND date_mise_en_ligne <= :now AND id_localisation LIKE CONCAT(:idPays, '%') ) t WHERE rn <= 2 ORDER BY date_mise_en_ligne DESC, id_actualite DESC SELECT id_actualite, jour, mois, type_actualite, titre_actualite, date_mise_en_ligne FROM ( SELECT id_actualite, SUBSTRING(date_mise_en_ligne, 7, 2) AS jour, SUBSTRING(date_mise_en_ligne, 5, 2) AS mois, type_actualite, titre_actualite, date_mise_en_ligne, ROW_NUMBER() OVER (PARTITION BY type_actualite ORDER BY date_mise_en_ligne DESC) AS rn FROM buzz_actualites WHERE provenance_flux_actualite = 'blog' AND mode_actualite = 'publique' AND date_mise_en_ligne <= '20260403161215' AND id_localisation LIKE CONCAT('33', '%') ) t WHERE rn <= 2 ORDER BY date_mise_en_ligne DESC, id_actualite DESC ;

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\SocietesPrestataire	No errors.
App\Entity\CoordonneesServicePrestataire	No errors.
App\Entity\ServicesPrestataire	No errors.
App\Entity\Societes	No errors.
App\Entity\BuzzActualites	No errors.
App\Entity\BuzzRoles	No errors.
App\Entity\BuzzOperations	No errors.
App\Entity\BuzzLienOperationsAnnoncesVendeur	No errors.
App\Entity\AnnoncesVendeur	No errors.
App\Entity\Localisations	No errors.
App\Entity\AnnoncesAcheteur	No errors.
App\Entity\SecteursActivite	No errors.
App\Entity\Translation	No errors.

Symfony Profiler

https://preprod.fusacq.com/buzz/actualite-societe-imaxio-2808_fr_?idActualite=86944

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping