https://preprod.fusacq.com/buzz/en-direct-des-experts_fr_?page=39&type=reference

Query Metrics

60 Database Queries
5 Different statements
735.19 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 91.59 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_.provenance_flux_actualite = ? AND b0_.visibilite_flux LIKE ? AND b0_.id_localisation LIKE ? AND b0_.date_mise_en_ligne <= ? AND b0_.type_actualite = ?
Parameters:
[
  "publique"
  "supprime"
  "blog"
  "%horsflux%"
  "33%"
  "20260416133600"
  "reference"
]
2 45.36 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_.id_societe_prestataire AS id_societe_prestataire_10, b0_.id_service_principal AS id_service_principal_11, b0_.id_operation AS id_operation_12, b0_.photo_actualite AS photo_actualite_13 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_.type_actualite = ? ORDER BY b0_.date_mise_en_ligne DESC LIMIT 20 OFFSET 760
Parameters:
[
  "publique"
  "supprime"
  "blog"
  "%horsflux%"
  "33%"
  "20260416133600"
  "reference"
]
3 10.00 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1119
]
4 10.50 ms
SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = ? 
                AND id_actualite != ? 
                AND mode_actualite = ?
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
Parameters:
[
  39899
  251388
  "publique"
]
5 10.09 ms
SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = ?
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
Parameters:
[
  39899
]
6 10.11 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1100
]
7 10.82 ms
SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = ? 
                AND id_actualite != ? 
                AND mode_actualite = ?
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
Parameters:
[
  39888
  251378
  "publique"
]
8 10.24 ms
SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = ?
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
Parameters:
[
  39888
]
9 10.11 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  203
]
10 10.86 ms
SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = ? 
                AND id_actualite != ? 
                AND mode_actualite = ?
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
Parameters:
[
  39893
  251381
  "publique"
]
11 10.23 ms
SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = ?
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
Parameters:
[
  39893
]
12 10.11 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  199
]
13 10.80 ms
SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = ? 
                AND id_actualite != ? 
                AND mode_actualite = ?
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
Parameters:
[
  39886
  251366
  "publique"
]
14 10.15 ms
SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = ?
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
Parameters:
[
  39886
]
15 9.98 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  905
]
16 10.72 ms
SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = ? 
                AND id_actualite != ? 
                AND mode_actualite = ?
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
Parameters:
[
  39885
  251363
  "publique"
]
17 10.15 ms
SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = ?
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
Parameters:
[
  39885
]
18 10.06 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1833
]
19 10.02 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1463
]
20 10.72 ms
SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = ? 
                AND id_actualite != ? 
                AND mode_actualite = ?
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
Parameters:
[
  39797
  251222
  "publique"
]
21 10.13 ms
SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = ?
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
Parameters:
[
  39797
]
22 10.01 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1518
]
23 10.71 ms
SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = ? 
                AND id_actualite != ? 
                AND mode_actualite = ?
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
Parameters:
[
  40512
  252699
  "publique"
]
24 10.14 ms
SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = ?
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
Parameters:
[
  40512
]
25 10.02 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  205
]
26 10.69 ms
SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = ? 
                AND id_actualite != ? 
                AND mode_actualite = ?
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
Parameters:
[
  39880
  251355
  "publique"
]
27 10.13 ms
SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = ?
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
Parameters:
[
  39880
]
28 10.03 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  2073
]
29 10.70 ms
SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = ? 
                AND id_actualite != ? 
                AND mode_actualite = ?
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
Parameters:
[
  39855
  251303
  "publique"
]
30 10.14 ms
SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = ?
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
Parameters:
[
  39855
]
31 10.03 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1588
]
32 10.69 ms
SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = ? 
                AND id_actualite != ? 
                AND mode_actualite = ?
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
Parameters:
[
  39772
  251188
  "publique"
]
33 10.14 ms
SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = ?
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
Parameters:
[
  39772
]
34 10.02 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1024
]
35 10.70 ms
SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = ? 
                AND id_actualite != ? 
                AND mode_actualite = ?
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
Parameters:
[
  39860
  251310
  "publique"
]
36 10.13 ms
SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = ?
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
Parameters:
[
  39860
]
37 10.02 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  677
]
38 10.71 ms
SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = ? 
                AND id_actualite != ? 
                AND mode_actualite = ?
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
Parameters:
[
  39863
  251314
  "publique"
]
39 10.14 ms
SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = ?
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
Parameters:
[
  39863
]
40 10.03 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1371
]
41 10.70 ms
SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = ? 
                AND id_actualite != ? 
                AND mode_actualite = ?
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
Parameters:
[
  39825
  251261
  "publique"
]
42 10.14 ms
SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = ?
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
Parameters:
[
  39825
]
43 10.03 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  136
]
44 10.73 ms
SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = ? 
                AND id_actualite != ? 
                AND mode_actualite = ?
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
Parameters:
[
  40979
  253707
  "publique"
]
45 10.15 ms
SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = ?
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
Parameters:
[
  40979
]
46 10.05 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1655
]
47 10.72 ms
SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = ? 
                AND id_actualite != ? 
                AND mode_actualite = ?
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
Parameters:
[
  39850
  251298
  "publique"
]
48 10.19 ms
SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = ?
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
Parameters:
[
  39850
]
49 10.06 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  474
]
50 10.78 ms
SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = ? 
                AND id_actualite != ? 
                AND mode_actualite = ?
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
Parameters:
[
  39867
  251332
  "publique"
]
51 10.28 ms
SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = ?
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
Parameters:
[
  39867
]
52 10.11 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1052
]
53 10.82 ms
SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = ? 
                AND id_actualite != ? 
                AND mode_actualite = ?
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
Parameters:
[
  39831
  251278
  "publique"
]
54 10.26 ms
SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = ?
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
Parameters:
[
  39831
]
55 10.10 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1251
]
56 10.78 ms
SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = ? 
                AND id_actualite != ? 
                AND mode_actualite = ?
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
Parameters:
[
  39716
  251088
  "publique"
]
57 10.19 ms
SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = ?
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
Parameters:
[
  39716
]
58 10.10 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1790
]
59 10.82 ms
SELECT id_actualite, photo_actualite 
                FROM fusacq_dbo.buzz_actualites 
                WHERE id_operation = ? 
                AND id_actualite != ? 
                AND mode_actualite = ?
                AND photo_actualite IS NOT NULL 
                AND photo_actualite != ""
                AND photo_actualite != "NULL"
                ORDER BY date_mise_en_ligne DESC
                LIMIT 1
Parameters:
[
  39828
  251266
  "publique"
]
60 10.23 ms
SELECT sa.image_filename 
                    FROM fusacq_dbo.buzz_operations bo
                    LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                    WHERE bo.id_operation = ?
                    AND sa.image_filename IS NOT NULL 
                    AND sa.image_filename != ""
                    LIMIT 1
Parameters:
[
  39828
]

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\Translation No errors.