Query Metrics

4 Database Queries
4 Different statements
42.94 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 11.08 ms
SELECT b0_.id_actualite AS id_actualite_0, b0_.date_creation AS date_creation_1, b0_.date_reception AS date_reception_2, b0_.date_mise_en_ligne AS date_mise_en_ligne_3, b0_.date_evenement AS date_evenement_4, b0_.titre_actualite AS titre_actualite_5, b0_.sous_titre AS sous_titre_6, b0_.description_actualite AS description_actualite_7, b0_.provenance_flux_actualite AS provenance_flux_actualite_8, b0_.type_actualite AS type_actualite_9, b0_.nom_fichier_xml AS nom_fichier_xml_10, b0_.id_message_blog AS id_message_blog_11, b0_.id_societe_prestataire AS id_societe_prestataire_12, b0_.id_service_principal AS id_service_principal_13, b0_.id_operation AS id_operation_14, b0_.mode_actualite AS mode_actualite_15, b0_.modifie_par_utilisateur AS modifie_par_utilisateur_16, b0_.deja_publique AS deja_publique_17, b0_.id_actualite_redirection AS id_actualite_redirection_18, b0_.site_internet AS site_internet_19, b0_.pour_en_savoir_plus AS pour_en_savoir_plus_20, b0_.societe_source AS societe_source_21, b0_.mots_cles AS mots_cles_22, b0_.a_la_une AS a_la_une_23, b0_.parution_franchises AS parution_franchises_24, b0_.a_la_une_du_jour AS a_la_une_du_jour_25, b0_.selection_we AS selection_we_26, b0_.a_la_une_accueil AS a_la_une_accueil_27, b0_.a_la_une_news_actu AS a_la_une_news_actu_28, b0_.utiliser_artviper AS utiliser_artviper_29, b0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_30, b0_.visibilite_flux AS visibilite_flux_31, b0_.personne_physique_impliquee AS personne_physique_impliquee_32, b0_.societe_impliquee AS societe_impliquee_33, b0_.fonds_implique AS fonds_implique_34, b0_.id_localisation AS id_localisation_35, b0_.id_secteur_activite AS id_secteur_activite_36, b0_.vignette AS vignette_37, b0_.vignette_small AS vignette_small_38, b0_.photo_actualite AS photo_actualite_39, b0_.alerte_envoyee AS alerte_envoyee_40, b0_.id_participation AS id_participation_41, b0_.id_participation_temporaire AS id_participation_temporaire_42, b0_.id_operation_temporaire AS id_operation_temporaire_43, b0_.id_fonds_bot AS id_fonds_bot_44, b0_.souhaite_classement AS souhaite_classement_45, b0_.souhaite_reseau AS souhaite_reseau_46, b0_.souhaite_prestation AS souhaite_prestation_47, b0_.souhaite_nom_reseau AS souhaite_nom_reseau_48, b0_.autorisation_blog AS autorisation_blog_49, b0_.contact_validation AS contact_validation_50, b0_.commentaires_blog AS commentaires_blog_51, b0_.apparition_classement AS apparition_classement_52, b0_.classement_reseau AS classement_reseau_53, b0_.classement_prestation AS classement_prestation_54, b0_.id_reseau AS id_reseau_55, b0_.suivi_classement AS suivi_classement_56, b0_.is_description_html AS is_description_html_57, b0_.is_forum_active AS is_forum_active_58, b0_.actu_ess AS actu_ess_59, b0_.suivi_actualite AS suivi_actualite_60, b0_.date_validation AS date_validation_61, b0_.indexe_google AS indexe_google_62 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? AND b0_.mode_actualite <> ? LIMIT 1
Parameters:
[
  248316
  "supprime"
]
2 11.08 ms
SELECT b0_.id_actualite AS id_actualite_0, b0_.photo_actualite AS photo_actualite_1 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_operation = ? AND b0_.id_actualite <> ? AND b0_.mode_actualite = ? AND b0_.photo_actualite IS NOT NULL AND b0_.photo_actualite <> '' AND b0_.photo_actualite <> 'NULL' ORDER BY b0_.date_mise_en_ligne DESC LIMIT 1
Parameters:
[
  38446
  248316
  "publique"
]
3 10.51 ms
SELECT s0_.image_filename AS image_filename_0 FROM fusacq_dbo.buzz_operations b1_ LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b1_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_operation = ? AND s0_.image_filename IS NOT NULL AND s0_.image_filename <> '' LIMIT 1
Parameters:
[
  38446
]
4 10.28 ms
SELECT t0.id_actualite AS id_actualite_1, t0.nb_affichages AS nb_affichages_2 FROM fusacq_dbo.statistiques_nb_consultations_actualites_buzz t0 WHERE t0.id_actualite = ? LIMIT 1
Parameters:
[
  248316
]

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.