https://preprod.fusacq.com/buzz/actualite-mna-collaborative-du-01_ch_

Query Metrics

27 Database Queries
6 Different statements
320.36 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 11.34 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_.description_actualite AS description_actualite_3, b0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_4, b0_.vignette AS vignette_5, b0_.vignette_small AS vignette_small_6, b0_.id_localisation AS id_localisation_7, b0_.type_actualite AS type_actualite_8, b0_.provenance_flux_actualite AS provenance_flux_actualite_9, b0_.visibilite_flux AS visibilite_flux_10 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.date_mise_en_ligne IS NOT NULL AND b0_.a_la_une = ? AND b0_.mode_actualite = ? AND b0_.mode_actualite <> ? AND (b0_.date_mise_en_ligne BETWEEN ? AND ?) AND b0_.id_localisation LIKE ? ORDER BY b0_.date_mise_en_ligne DESC LIMIT 1
Parameters:
[
  "oui"
  "publique"
  "supprime"
  "20260101000000"
  "20260131235959"
  "41%"
]
2 10.17 ms
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
  257423
]
3 32.45 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_.description_actualite AS description_actualite_3, b0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_4, b0_.vignette AS vignette_5, b0_.vignette_small AS vignette_small_6, b0_.id_localisation AS id_localisation_7, b0_.type_actualite AS type_actualite_8, b0_.provenance_flux_actualite AS provenance_flux_actualite_9, b0_.a_la_une AS a_la_une_10, b0_.a_la_une_du_jour AS a_la_une_du_jour_11 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_.date_mise_en_ligne BETWEEN ? AND ?) AND b0_.date_mise_en_ligne <= ? AND b0_.id_localisation LIKE ? AND b0_.id_actualite NOT IN (?) ORDER BY b0_.date_mise_en_ligne DESC
Parameters:
[
  "publique"
  "supprime"
  "20260101000000"
  "20260131235959"
  "20260420213414"
  "41%"
  257423
]
4 10.15 ms
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
  257353
]
5 10.20 ms
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
  257246
]
6 10.24 ms
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
  257206
]
7 10.19 ms
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
  257124
]
8 10.20 ms
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
  257068
]
9 10.20 ms
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
  257042
]
10 15.22 ms
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
  257032
]
11 10.79 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:
[
  42551
  257032
  "publique"
]
12 10.20 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:
[
  42551
]
13 10.09 ms
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
  256991
]
14 10.11 ms
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
  256889
]
15 10.17 ms
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
  256878
]
16 10.85 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:
[
  42467
  256878
  "publique"
]
17 10.27 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:
[
  42467
]
18 10.14 ms
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
  256875
]
19 10.08 ms
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
  256822
]
20 10.15 ms
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
  256820
]
21 10.16 ms
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
  256819
]
22 12.44 ms
SELECT COUNT(b0_.id_actualite) AS sclr_0 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_.date_mise_en_ligne >= ? AND b0_.date_mise_en_ligne <= ? AND b0_.id_localisation LIKE ?
Parameters:
[
  "publique"
  "supprime"
  "20251001000000"
  "20251031235959"
  "41%"
]
23 13.60 ms
SELECT COUNT(b0_.id_actualite) AS sclr_0 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_.date_mise_en_ligne >= ? AND b0_.date_mise_en_ligne <= ? AND b0_.id_localisation LIKE ?
Parameters:
[
  "publique"
  "supprime"
  "20251101000000"
  "20251131235959"
  "41%"
]
24 12.40 ms
SELECT COUNT(b0_.id_actualite) AS sclr_0 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_.date_mise_en_ligne >= ? AND b0_.date_mise_en_ligne <= ? AND b0_.id_localisation LIKE ?
Parameters:
[
  "publique"
  "supprime"
  "20251201000000"
  "20251231235959"
  "41%"
]
25 12.38 ms
SELECT COUNT(b0_.id_actualite) AS sclr_0 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_.date_mise_en_ligne >= ? AND b0_.date_mise_en_ligne <= ? AND b0_.id_localisation LIKE ?
Parameters:
[
  "publique"
  "supprime"
  "20260101000000"
  "20260131235959"
  "41%"
]
26 12.41 ms
SELECT COUNT(b0_.id_actualite) AS sclr_0 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_.date_mise_en_ligne >= ? AND b0_.date_mise_en_ligne <= ? AND b0_.id_localisation LIKE ?
Parameters:
[
  "publique"
  "supprime"
  "20260201000000"
  "20260231235959"
  "41%"
]
27 13.77 ms
SELECT COUNT(b0_.id_actualite) AS sclr_0 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_.date_mise_en_ligne >= ? AND b0_.date_mise_en_ligne <= ? AND b0_.id_localisation LIKE ?
Parameters:
[
  "publique"
  "supprime"
  "20260301000000"
  "20260331235959"
  "41%"
]

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\Localisations No errors.
App\Entity\BuzzOperations No errors.
App\Entity\SecteursActivite No errors.
App\Entity\Translation No errors.