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

Query Metrics

64 Database Queries
7 Different statements
757.34 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 73.98 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%"
  "20260418122752"
]
2 36.69 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 800
Parameters:
[
  "publique"
  "supprime"
  "blog"
  "%horsflux%"
  "33%"
  "20260418122752"
]
3 10.09 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  476
]
4 10.57 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:
[
  41625
  255072
  "publique"
]
5 10.25 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:
[
  41625
]
6 10.22 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  1896
]
7 10.96 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:
[
  41013
  253780
  "publique"
]
8 10.36 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:
[
  41013
]
9 10.24 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  1470
]
10 10.40 ms
SELECT s0_.image_filename AS image_filename_0 FROM fusacq_dbo.buzz_actualites b1_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b1_.id_operation = b2_.id_operation) LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b2_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_actualite = ? AND b1_.id_operation IS NOT NULL AND s0_.image_filename IS NOT NULL AND s0_.image_filename <> '' LIMIT 1
Parameters:
[
  252584
]
11 10.50 ms
SELECT s0_.image_filename AS image_filename_0 FROM fusacq_dbo.buzz_actualites b1_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b1_.id_actualite = b2_.id_actualite_principale) LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b2_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_actualite = ? AND s0_.image_filename IS NOT NULL AND s0_.image_filename <> '' LIMIT 1
Parameters:
[
  252584
]
12 10.23 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  875
]
13 10.96 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:
[
  41681
  255198
  "publique"
]
14 10.28 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:
[
  41681
]
15 10.16 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  1925
]
16 10.89 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:
[
  40424
  252521
  "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:
[
  40424
]
18 10.15 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  1833
]
19 10.90 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:
[
  42562
  257043
  "publique"
]
20 10.29 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:
[
  42562
]
21 10.17 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  1732
]
22 10.86 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:
[
  40423
  252520
  "publique"
]
23 10.26 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:
[
  40423
]
24 10.30 ms
SELECT s0_.image_filename AS image_filename_0 FROM fusacq_dbo.buzz_actualites b1_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b1_.id_operation = b2_.id_operation) LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b2_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_actualite = ? AND b1_.id_operation IS NOT NULL AND s0_.image_filename IS NOT NULL AND s0_.image_filename <> '' LIMIT 1
Parameters:
[
  252520
]
25 10.44 ms
SELECT s0_.image_filename AS image_filename_0 FROM fusacq_dbo.buzz_actualites b1_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b1_.id_actualite = b2_.id_actualite_principale) LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b2_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_actualite = ? AND s0_.image_filename IS NOT NULL AND s0_.image_filename <> '' LIMIT 1
Parameters:
[
  252520
]
26 10.15 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  216
]
27 10.81 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:
[
  40422
  252513
  "publique"
]
28 10.25 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:
[
  40422
]
29 10.15 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  776
]
30 10.30 ms
SELECT s0_.image_filename AS image_filename_0 FROM fusacq_dbo.buzz_actualites b1_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b1_.id_operation = b2_.id_operation) LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b2_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_actualite = ? AND b1_.id_operation IS NOT NULL AND s0_.image_filename IS NOT NULL AND s0_.image_filename <> '' LIMIT 1
Parameters:
[
  252432
]
31 10.46 ms
SELECT s0_.image_filename AS image_filename_0 FROM fusacq_dbo.buzz_actualites b1_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b1_.id_actualite = b2_.id_actualite_principale) LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b2_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_actualite = ? AND s0_.image_filename IS NOT NULL AND s0_.image_filename <> '' LIMIT 1
Parameters:
[
  252432
]
32 10.17 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  1938
]
33 10.84 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:
[
  41447
  254684
  "publique"
]
34 10.29 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:
[
  41447
]
35 10.15 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  2058
]
36 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:
[
  42712
  257285
  "publique"
]
37 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:
[
  42712
]
38 10.14 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  973
]
39 10.90 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:
[
  41749
  255340
  "publique"
]
40 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:
[
  41749
]
41 10.20 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  203
]
42 10.96 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:
[
  42836
  257494
  "publique"
]
43 10.38 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:
[
  42836
]
44 10.24 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  876
]
45 10.99 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:
[
  41887
  255646
  "publique"
]
46 10.34 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:
[
  41887
]
47 10.19 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  776
]
48 10.33 ms
SELECT s0_.image_filename AS image_filename_0 FROM fusacq_dbo.buzz_actualites b1_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b1_.id_operation = b2_.id_operation) LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b2_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_actualite = ? AND b1_.id_operation IS NOT NULL AND s0_.image_filename IS NOT NULL AND s0_.image_filename <> '' LIMIT 1
Parameters:
[
  252430
]
49 10.48 ms
SELECT s0_.image_filename AS image_filename_0 FROM fusacq_dbo.buzz_actualites b1_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b1_.id_actualite = b2_.id_actualite_principale) LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b2_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_actualite = ? AND s0_.image_filename IS NOT NULL AND s0_.image_filename <> '' LIMIT 1
Parameters:
[
  252430
]
50 10.18 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  1833
]
51 10.89 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:
[
  42563
  257044
  "publique"
]
52 10.24 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:
[
  42563
]
53 10.13 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  147
]
54 10.88 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:
[
  40388
  252438
  "publique"
]
55 10.28 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:
[
  40388
]
56 10.21 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  262
]
57 10.92 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:
[
  41489
  254766
  "publique"
]
58 10.32 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:
[
  41489
]
59 10.17 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  1983
]
60 10.89 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:
[
  41192
  254166
  "publique"
]
61 10.29 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:
[
  41192
]
62 10.18 ms
SELECT s0_.id_service_prestataire AS id_service_prestataire_0, s0_.titre_service AS titre_service_1, s0_.nom_commercial_societe AS nom_commercial_societe_2 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.id_service_prestataire = ?
Parameters:
[
  1732
]
63 10.97 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:
[
  40346
  252369
  "publique"
]
64 10.28 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:
[
  40346
]

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