https://preprod.fusacq.com/buzz/en-direct-des-experts_fr_?page=35

Query Metrics

64 Database Queries
9 Different statements
766.12 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 77.96 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 <= ?
Parameters:
[
  "publique"
  "supprime"
  "blog"
  "%horsflux%"
  "33%"
  "20260416125758"
]
2 33.63 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 <= ? ORDER BY b0_.date_mise_en_ligne DESC LIMIT 20 OFFSET 680
Parameters:
[
  "publique"
  "supprime"
  "blog"
  "%horsflux%"
  "33%"
  "20260416125758"
]
3 10.24 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1356
]
4 10.75 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:
[
  42304
  256549
  "publique"
]
5 10.44 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:
[
  42304
]
6 10.43 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1470
]
7 11.13 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:
[
  40876
  253451
  "publique"
]
8 10.54 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:
[
  40876
]
9 10.42 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1470
]
10 11.10 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:
[
  40874
  253448
  "publique"
]
11 10.47 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:
[
  40874
]
12 10.35 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  905
]
13 10.41 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  253443
]
14 10.44 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  253443
]
15 10.43 ms
SELECT sa.image_filename 
                FROM fusacq_dbo.buzz_actualites ba
                LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_operation = bo.id_operation
                LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                WHERE ba.id_actualite = ?
                AND ba.id_operation IS NOT NULL
                AND sa.image_filename IS NOT NULL 
                AND sa.image_filename != ""
                LIMIT 1
Parameters:
[
  253443
]
16 10.67 ms
SELECT sa.image_filename 
                FROM fusacq_dbo.buzz_actualites ba
                LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_actualite = bo.id_actualite_principale
                LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                WHERE ba.id_actualite = ?
                AND sa.image_filename IS NOT NULL 
                AND sa.image_filename != ""
                LIMIT 1
Parameters:
[
  253443
]
17 10.35 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  905
]
18 11.02 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:
[
  40869
  253441
  "publique"
]
19 10.44 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:
[
  40869
]
20 10.30 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1894
]
21 11.03 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:
[
  42674
  257222
  "publique"
]
22 10.48 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:
[
  42674
]
23 10.35 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1938
]
24 10.97 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:
[
  41450
  254687
  "publique"
]
25 10.46 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:
[
  41450
]
26 10.32 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1497
]
27 11.00 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:
[
  42777
  257375
  "publique"
]
28 10.39 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:
[
  42777
]
29 10.31 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  870
]
30 10.97 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:
[
  42027
  255957
  "publique"
]
31 10.43 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:
[
  42027
]
32 10.27 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  2173
]
33 11.03 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:
[
  41528
  254854
  "publique"
]
34 10.43 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:
[
  41528
]
35 10.33 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  593
]
36 11.01 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:
[
  40849
  253407
  "publique"
]
37 10.40 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:
[
  40849
]
38 10.30 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1384
]
39 11.05 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:
[
  40842
  253399
  "publique"
]
40 10.43 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:
[
  40842
]
41 10.32 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1838
]
42 11.06 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:
[
  40821
  253374
  "publique"
]
43 10.37 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:
[
  40821
]
44 10.21 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  994
]
45 11.01 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:
[
  40831
  253383
  "publique"
]
46 10.41 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:
[
  40831
]
47 10.24 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  222
]
48 10.98 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:
[
  40836
  253388
  "publique"
]
49 10.39 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:
[
  40836
]
50 10.29 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1706
]
51 11.03 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:
[
  40835
  253386
  "publique"
]
52 10.41 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:
[
  40835
]
53 10.31 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  994
]
54 11.05 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:
[
  40828
  253381
  "publique"
]
55 10.48 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:
[
  40828
]
56 10.39 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1838
]
57 11.00 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:
[
  40819
  253373
  "publique"
]
58 10.41 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:
[
  40819
]
59 10.32 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1824
]
60 10.28 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  253355
]
61 10.36 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  253355
]
62 10.43 ms
SELECT sa.image_filename 
                FROM fusacq_dbo.buzz_actualites ba
                LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_operation = bo.id_operation
                LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                WHERE ba.id_actualite = ?
                AND ba.id_operation IS NOT NULL
                AND sa.image_filename IS NOT NULL 
                AND sa.image_filename != ""
                LIMIT 1
Parameters:
[
  253355
]
63 10.55 ms
SELECT sa.image_filename 
                FROM fusacq_dbo.buzz_actualites ba
                LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_actualite = bo.id_actualite_principale
                LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                WHERE ba.id_actualite = ?
                AND sa.image_filename IS NOT NULL 
                AND sa.image_filename != ""
                LIMIT 1
Parameters:
[
  253355
]
64 10.33 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1194
]

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