Query Metrics

102 Database Queries
7 Different statements
1122.70 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 32.28 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%"
  "20260416101354"
  "expertise"
]
2 44.99 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 660
Parameters:
[
  "publique"
  "supprime"
  "blog"
  "%horsflux%"
  "33%"
  "20260416101354"
  "expertise"
]
3 10.40 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  776
]
4 10.36 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  183291
]
5 10.33 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  183291
]
6 10.31 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:
[
  183291
]
7 10.31 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:
[
  183291
]
8 10.19 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  776
]
9 10.11 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  183289
]
10 10.16 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  183289
]
11 10.27 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:
[
  183289
]
12 10.36 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:
[
  183289
]
13 10.15 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  776
]
14 10.13 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  183292
]
15 10.17 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  183292
]
16 10.29 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:
[
  183292
]
17 10.32 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:
[
  183292
]
18 10.18 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  776
]
19 10.35 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  183296
]
20 10.35 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  183296
]
21 10.46 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:
[
  183296
]
22 10.60 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:
[
  183296
]
23 10.32 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  776
]
24 10.13 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  183300
]
25 10.30 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  183300
]
26 10.47 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:
[
  183300
]
27 10.63 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:
[
  183300
]
28 10.32 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1161
]
29 10.35 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  185037
]
30 10.43 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  185037
]
31 10.48 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:
[
  185037
]
32 10.65 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:
[
  185037
]
33 10.27 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1161
]
34 10.30 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  185036
]
35 10.37 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  185036
]
36 10.49 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:
[
  185036
]
37 10.63 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:
[
  185036
]
38 10.24 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  776
]
39 10.21 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  183299
]
40 10.37 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  183299
]
41 10.47 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:
[
  183299
]
42 10.58 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:
[
  183299
]
43 10.32 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  776
]
44 10.32 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  183301
]
45 10.37 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  183301
]
46 10.48 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:
[
  183301
]
47 10.62 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:
[
  183301
]
48 10.33 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  776
]
49 10.33 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  183303
]
50 10.38 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  183303
]
51 10.46 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:
[
  183303
]
52 10.64 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:
[
  183303
]
53 10.34 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  776
]
54 10.33 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  183236
]
55 10.34 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  183236
]
56 10.48 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:
[
  183236
]
57 10.68 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:
[
  183236
]
58 10.29 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1548
]
59 10.34 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  184799
]
60 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:
[
  184799
]
61 10.45 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:
[
  184799
]
62 10.64 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:
[
  184799
]
63 10.40 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  776
]
64 10.28 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  183302
]
65 10.39 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  183302
]
66 10.48 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:
[
  183302
]
67 10.57 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:
[
  183302
]
68 10.26 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  776
]
69 10.32 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  183199
]
70 10.35 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  183199
]
71 10.39 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:
[
  183199
]
72 10.46 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:
[
  183199
]
73 10.29 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  1548
]
74 10.21 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  184644
]
75 10.26 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  184644
]
76 10.36 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:
[
  184644
]
77 10.49 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:
[
  184644
]
78 10.20 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  776
]
79 10.20 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  183198
]
80 10.27 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  183198
]
81 10.38 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:
[
  183198
]
82 10.54 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:
[
  183198
]
83 10.28 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  776
]
84 10.27 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  183197
]
85 10.34 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  183197
]
86 10.40 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:
[
  183197
]
87 10.54 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:
[
  183197
]
88 10.23 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  776
]
89 10.22 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  183193
]
90 18.71 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  183193
]
91 10.48 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:
[
  183193
]
92 10.70 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:
[
  183193
]
93 10.17 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  776
]
94 10.25 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  183227
]
95 10.31 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  183227
]
96 10.45 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:
[
  183227
]
97 10.63 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:
[
  183227
]
98 10.33 ms
SELECT nom_commercial_societe, titre_service FROM fusacq_dbo.services_prestataire WHERE id_service_prestataire = ? LIMIT 1
Parameters:
[
  776
]
99 10.33 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  183226
]
100 10.34 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  183226
]
101 10.46 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:
[
  183226
]
102 10.58 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:
[
  183226
]

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.