Query Metrics
9
Database Queries
7
Different statements
206.38 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 10.81 ms |
SELECT t0.id_societe AS id_societe_1, t0.id_societe_news AS id_societe_news_2, t0.id_participation AS id_participation_3, t0.mode_participation AS mode_participation_4, t0.deja_publique AS deja_publique_5, t0.raison_sociale AS raison_sociale_6, t0.raison_sociale_formatee AS raison_sociale_formatee_7, t0.nom_president AS nom_president_8, t0.nom_directeur_general AS nom_directeur_general_9, t0.adresse AS adresse_10, t0.ville AS ville_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.id_pays AS id_pays_15, t0.devise AS devise_16, t0.id_region AS id_region_17, t0.filiales_bureaux AS filiales_bureaux_18, t0.id_secteur_activite AS id_secteur_activite_19, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20, t0.site_internet AS site_internet_21, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22, t0.mail_contact AS mail_contact_23, t0.resume_activite AS resume_activite_24, t0.description_activite AS description_activite_25, t0.mots_cles AS mots_cles_26, t0.strategie_developpement AS strategie_developpement_27, t0.marge_brute_n AS marge_brute_n_28, t0.resultat_exploitation_n AS resultat_exploitation_n_29, t0.resultat_net_n AS resultat_net_n_30, t0.ca_n AS ca_n_31, t0.nb_personnes_n AS nb_personnes_n_32, t0.annee_n AS annee_n_33, t0.date_mise_a_jour AS date_mise_a_jour_34, t0.fichier_joint AS fichier_joint_35, t0.commentaire_interne AS commentaire_interne_36, t0.societe_cotee AS societe_cotee_37, t0.login_demande_publication AS login_demande_publication_38, t0.date_relance AS date_relance_39, t0.relance_mise_a_jour AS relance_mise_a_jour_40, t0.numero_siren AS numero_siren_41, t0.montant_total_investi AS montant_total_investi_42, t0.capital_total_investisseur AS capital_total_investisseur_43, t0.titre_newsletter AS titre_newsletter_44, t0.resume_newsletter AS resume_newsletter_45, t0.date_dernier_investissement AS date_dernier_investissement_46, t0.type_profil_participation AS type_profil_participation_47, t0.mode_societe AS mode_societe_48, t0.utiliser_artviper AS utiliser_artviper_49, t0.numero_siret AS numero_siret_50, t0.code_naf AS code_naf_51, t0.vignette AS vignette_52, t0.vignette_small AS vignette_small_53, t0.ca_n_inf AS ca_n_inf_54, t0.ca_n_sup AS ca_n_sup_55, t0.id_societe_mere AS id_societe_mere_56, t0.date_maj_administrateur AS date_maj_administrateur_57, t0.administrateur AS administrateur_58, t0.etat_resume AS etat_resume_59, t0.afficher_vendeur AS afficher_vendeur_60, t0.afficher_acheteur AS afficher_acheteur_61 FROM fusacq_dbo.societes t0 WHERE t0.id_societe = ? LIMIT 1
Parameters:
[
"43718"
]
|
| 2 | 10.41 ms |
SELECT s0_.raison_sociale AS raison_sociale_0, s0_.id_societe AS id_societe_1, l1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_2 FROM fusacq_dbo.societes s0_ LEFT JOIN fusacq_dbo.lien_participations_fonds l1_ ON (s0_.id_societe = l1_.id_participation) WHERE s0_.id_societe = ? AND l1_.id_gestionnaire_fonds <> ? LIMIT 10000
Parameters:
[ "43718" "null" ] |
| 3 | 11.37 ms |
SELECT b0_.id_actualite AS id_actualite_0, b0_.date_mise_en_ligne AS date_mise_en_ligne_1, b0_.titre_actualite AS titre_actualite_2, b0_.provenance_flux_actualite AS provenance_flux_actualite_3, b0_.autorisation_blog AS autorisation_blog_4 FROM fusacq_dbo.buzz_roles b1_ INNER JOIN fusacq_dbo.buzz_operations b2_ ON (b2_.id_operation = b1_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b0_ ON (b2_.id_actualite_principale = b0_.id_actualite) WHERE b1_.id_acteur = ? AND b1_.id_type_role = ? AND b0_.mode_actualite = ? AND (b1_.table_sql_acteur = ? OR b1_.table_sql_acteur_passif = ?) AND b2_.type_operation = 'fusion_acquisition' AND b0_.date_mise_en_ligne <= 20260414122425 AND b2_.date_operation >= ? AND b2_.date_operation <= ? GROUP BY b2_.id_actualite_principale ORDER BY b0_.date_mise_en_ligne DESC
Parameters:
[ "43718" "1" "publique" "societes_news" "societes_news" "20000101" "20261231" ] |
| 4 | 11.51 ms |
SELECT DISTINCT (b0_.id_actualite) AS sclr_0, b0_.id_actualite AS id_actualite_1, b0_.date_mise_en_ligne AS date_mise_en_ligne_2, b0_.titre_actualite AS titre_actualite_3, b0_.provenance_flux_actualite AS provenance_flux_actualite_4, b0_.autorisation_blog AS autorisation_blog_5 FROM fusacq_dbo.buzz_roles b1_ INNER JOIN fusacq_dbo.buzz_operations b2_ ON (b2_.id_operation = b1_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b0_ ON (b2_.id_actualite_principale = b0_.id_actualite) WHERE b0_.mode_actualite = ? AND b1_.id_type_role = ? AND b2_.type_operation = ? AND b0_.date_mise_en_ligne <= ? AND ((b1_.id_acteur = ? AND b1_.table_sql_acteur = 'societes_news') OR (b1_.id_acteur_passif = ? AND b1_.table_sql_acteur_passif = 'societes_news')) ORDER BY b0_.date_mise_en_ligne DESC LIMIT 10000
Parameters:
[ "publique" 1 "fusion_acquisition" "20260414" "43718" "43718" ] |
| 5 | 75.64 ms |
SELECT s0_.id_societe AS id_societe_0, COUNT(b1_.id_operation) AS sclr_1, s0_.raison_sociale AS raison_sociale_2, s0_.ca_n AS ca_n_3, s0_.code_postal AS code_postal_4, s0_.id_pays AS id_pays_5, s0_.id_region AS id_region_6, s0_.adresse AS adresse_7, s0_.resume_activite AS resume_activite_8, b2_.id_actualite AS id_actualite_9, b2_.titre_actualite AS titre_actualite_10, b2_.date_mise_en_ligne AS date_mise_en_ligne_11, b2_.type_actualite AS type_actualite_12, b2_.provenance_flux_actualite AS provenance_flux_actualite_13 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.buzz_roles b3_ ON (b3_.id_acteur = s0_.id_societe) INNER JOIN fusacq_dbo.buzz_operations b1_ ON (b1_.id_operation = b3_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b2_ ON (b1_.id_actualite_principale = b2_.id_actualite) WHERE b3_.id_type_role = ? AND b2_.mode_actualite = ? AND (b3_.table_sql_acteur = ? OR b3_.table_sql_acteur_passif = ?) AND b1_.type_operation = 'fusion_acquisition' AND b2_.date_mise_en_ligne <= 20260414122425 AND s0_.afficher_acheteur = 1 AND b1_.date_operation >= ? AND b1_.date_operation <= ? AND (b1_.id_secteur_activite LIKE ?) GROUP BY s0_.id_societe ORDER BY b2_.date_mise_en_ligne DESC, s0_.id_societe DESC LIMIT 1 OFFSET 6
Parameters:
[ "1" "publique" "societes_news" "societes_news" "20000101" "20261231" "302%" ] |
| 6 | 56.25 ms |
SELECT s0_.id_societe AS id_societe_0, COUNT(b1_.id_operation) AS sclr_1, s0_.raison_sociale AS raison_sociale_2, s0_.ca_n AS ca_n_3, s0_.code_postal AS code_postal_4, s0_.id_pays AS id_pays_5, s0_.id_region AS id_region_6, s0_.adresse AS adresse_7, s0_.resume_activite AS resume_activite_8, b2_.id_actualite AS id_actualite_9, b2_.titre_actualite AS titre_actualite_10, b2_.date_mise_en_ligne AS date_mise_en_ligne_11, b2_.type_actualite AS type_actualite_12, b2_.provenance_flux_actualite AS provenance_flux_actualite_13 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.buzz_roles b3_ ON (b3_.id_acteur = s0_.id_societe) INNER JOIN fusacq_dbo.buzz_operations b1_ ON (b1_.id_operation = b3_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b2_ ON (b1_.id_actualite_principale = b2_.id_actualite) WHERE b3_.id_type_role = ? AND b2_.mode_actualite = ? AND (b3_.table_sql_acteur = ? OR b3_.table_sql_acteur_passif = ?) AND b1_.type_operation = 'fusion_acquisition' AND b2_.date_mise_en_ligne <= 20260414122425 AND s0_.afficher_acheteur = 1 AND b1_.date_operation >= ? AND b1_.date_operation <= ? AND (b1_.id_secteur_activite LIKE ?) GROUP BY s0_.id_societe ORDER BY b2_.date_mise_en_ligne DESC, s0_.id_societe DESC LIMIT 1 OFFSET 8
Parameters:
[ "1" "publique" "societes_news" "societes_news" "20000101" "20261231" "302%" ] |
| 7 | 10.05 ms |
SELECT t0.id_secteur_activite AS id_secteur_activite_1, t0.nom_secteur_activite AS nom_secteur_activite_2, t0.obsolete AS obsolete_3, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4, t0.site_partenaire AS site_partenaire_5, t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6, t0.id_secteur_activite_pere AS id_secteur_activite_pere_7, t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8, t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9, t0.nom_pour_TITLE AS nom_pour_TITLE_10, t0.rare AS rare_11, t0.recherche AS recherche_12 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = ? LIMIT 1
Parameters:
[
50205
]
|
| 8 | 10.16 ms |
SELECT t0.id_secteur_activite AS id_secteur_activite_1, t0.nom_secteur_activite AS nom_secteur_activite_2, t0.obsolete AS obsolete_3, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4, t0.site_partenaire AS site_partenaire_5, t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6, t0.id_secteur_activite_pere AS id_secteur_activite_pere_7, t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8, t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9, t0.nom_pour_TITLE AS nom_pour_TITLE_10, t0.rare AS rare_11, t0.recherche AS recherche_12 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = ? LIMIT 1
Parameters:
[
"502"
]
|
| 9 | 10.18 ms |
SELECT t0.id_secteur_activite AS id_secteur_activite_1, t0.nom_secteur_activite AS nom_secteur_activite_2, t0.obsolete AS obsolete_3, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4, t0.site_partenaire AS site_partenaire_5, t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6, t0.id_secteur_activite_pere AS id_secteur_activite_pere_7, t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8, t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9, t0.nom_pour_TITLE AS nom_pour_TITLE_10, t0.rare AS rare_11, t0.recherche AS recherche_12 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = ? LIMIT 1
Parameters:
[
"5"
]
|
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\Societes | No errors. |
| App\Entity\LienParticipationsFonds | No errors. |
| App\Entity\BuzzOperations | No errors. |
| App\Entity\BuzzRoles | No errors. |
| App\Entity\BuzzActualites | No errors. |
| App\Entity\SecteursActivite | No errors. |
| App\Entity\Translation | No errors. |