Query Metrics
45
Database Queries
4
Different statements
475.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
197.20 ms (41.50%) |
20 |
SELECT b0_.autorisation_blog AS autorisation_blog_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
258809
]
|
|
157.40 ms (33.12%) |
16 |
SELECT b0_.titre_operation AS titre_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_operation = ?
Parameters:
[
43469
]
|
|
81.58 ms (17.17%) |
8 |
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_service_prestataire = ?
Parameters:
[
"1706"
]
|
|
39.03 ms (8.21%) |
1 |
SELECT b0_.id_actualite AS id_actualite_0, b0_.id_operation AS id_operation_1, b0_.date_mise_en_ligne AS date_mise_en_ligne_2, b0_.titre_actualite AS titre_actualite_3 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.date_mise_en_ligne IS NOT NULL AND b0_.mode_actualite = ? AND b0_.mode_actualite <> ? AND b0_.provenance_flux_actualite = ? AND b0_.visibilite_flux LIKE ? AND b0_.id_localisation LIKE ? AND b0_.date_mise_en_ligne <= ? AND b0_.id_operation IS NOT NULL ORDER BY b0_.date_mise_en_ligne DESC LIMIT 600
Parameters:
[ "publique" "supprime" "blog" "%horsflux%" "33%" "20260501134411" ] |
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\BuzzActualites | No errors. |
| App\Entity\BuzzOperations | No errors. |
| App\Entity\ServicesPrestataire | No errors. |
| App\Entity\Translation | No errors. |