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

Query Metrics

87 Database Queries
9 Different statements
989.08 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 26.20 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%"
  "20260418135410"
  "expertise"
]
2 48.00 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 640
Parameters:
[
  "publique"
  "supprime"
  "blog"
  "%horsflux%"
  "33%"
  "20260418135410"
  "expertise"
]
3 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:
[
  1161
]
4 10.20 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  188850
]
5 10.32 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  188850
]
6 10.43 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:
[
  188850
]
7 10.59 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:
[
  188850
]
8 10.06 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:
[
  1548
]
9 9.92 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  188834
]
10 10.08 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  188834
]
11 10.08 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:
[
  188834
]
12 10.06 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:
[
  188834
]
13 10.04 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
]
14 10.10 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:
[
  188763
]
15 10.18 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:
[
  188763
]
16 10.11 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:
[
  958
]
17 10.15 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  188761
]
18 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:
[
  188761
]
19 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_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:
[
  188761
]
20 10.56 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:
[
  188761
]
21 10.32 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
]
22 10.27 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  183146
]
23 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:
[
  183146
]
24 10.35 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:
[
  183146
]
25 10.51 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:
[
  183146
]
26 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:
[
  1592
]
27 10.38 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:
[
  188669
]
28 10.54 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:
[
  188669
]
29 10.26 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:
[
  1161
]
30 10.22 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  188461
]
31 10.32 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  188461
]
32 10.39 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:
[
  188461
]
33 10.51 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:
[
  188461
]
34 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:
[
  1161
]
35 10.21 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  188460
]
36 10.25 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  188460
]
37 10.32 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:
[
  188460
]
38 10.49 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:
[
  188460
]
39 10.27 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
]
40 10.41 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:
[
  183164
]
41 10.51 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:
[
  183164
]
42 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:
[
  1161
]
43 10.23 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  188459
]
44 10.29 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  188459
]
45 10.37 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:
[
  188459
]
46 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:
[
  188459
]
47 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:
[
  1553
]
48 10.22 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  188440
]
49 10.28 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  188440
]
50 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:
[
  188440
]
51 10.43 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:
[
  188440
]
52 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:
[
  214
]
53 10.26 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:
[
  188306
]
54 10.38 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:
[
  188306
]
55 10.12 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:
[
  1548
]
56 10.10 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  186095
]
57 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:
[
  186095
]
58 10.24 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:
[
  186095
]
59 10.38 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:
[
  186095
]
60 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:
[
  776
]
61 10.24 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:
[
  183190
]
62 10.43 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:
[
  183190
]
63 10.12 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
]
64 10.28 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:
[
  183161
]
65 10.43 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:
[
  183161
]
66 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:
[
  1548
]
67 10.17 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  185576
]
68 10.23 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  185576
]
69 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:
[
  185576
]
70 10.42 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:
[
  185576
]
71 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:
[
  776
]
72 10.34 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:
[
  183150
]
73 10.43 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:
[
  183150
]
74 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:
[
  994
]
75 10.15 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  185454
]
76 10.20 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  185454
]
77 10.31 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:
[
  185454
]
78 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_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:
[
  185454
]
79 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:
[
  776
]
80 10.26 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:
[
  183145
]
81 10.37 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:
[
  183145
]
82 10.10 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
]
83 10.25 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:
[
  183144
]
84 10.35 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:
[
  183144
]
85 12.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 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_.type_actualite = ? AND b0_.id_localisation LIKE ? ORDER BY b0_.date_mise_en_ligne DESC LIMIT 3
Parameters:
[
  "publique"
  "supprime"
  "juridique_et_fiscale"
  "33%"
]
86 31.29 ms
SELECT DISTINCT (s0_.id_service_prestataire) AS sclr_0, s0_.id_localisation_prestataire AS id_localisation_prestataire_1, s0_.titre_service AS titre_service_2, s0_.nom_commercial_societe AS nom_commercial_societe_3, s0_.date_mise_en_ligne AS date_mise_en_ligne_4, s0_.resume_service AS resume_service_5, s0_.url_site_web AS url_site_web_6, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7, s0_.utiliser_artviper AS utiliser_artviper_8, c1_.code_postal AS code_postal_9, c1_.ville AS ville_10, c1_.nom_contact1 AS nom_contact1_11 FROM fusacq_dbo.services_prestataire s0_ LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (s0_.id_secteur_new = s2_.pointe_vers) LEFT JOIN localisations_prestataire l3_ ON (s0_.id_localisation_prestataire = l3_.id_localisation_prestataire) LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (s0_.id_service_prestataire = c1_.id_service_prestataire) WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%' ORDER BY s0_.date_mise_en_ligne DESC, s0_.id_service_prestataire DESC LIMIT 3
Parameters:
[]
87 28.79 ms
SELECT DISTINCT (s0_.id_service_prestataire) AS sclr_0, s0_.id_localisation_prestataire AS id_localisation_prestataire_1, s0_.titre_service AS titre_service_2, s0_.nom_commercial_societe AS nom_commercial_societe_3, s0_.date_mise_en_ligne AS date_mise_en_ligne_4, s0_.resume_service AS resume_service_5, s0_.url_site_web AS url_site_web_6, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7, s0_.utiliser_artviper AS utiliser_artviper_8, c1_.code_postal AS code_postal_9, c1_.ville AS ville_10, c1_.nom_contact1 AS nom_contact1_11 FROM fusacq_dbo.services_prestataire s0_ LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (s0_.id_secteur_new = s2_.pointe_vers) LEFT JOIN localisations_prestataire l3_ ON (s0_.id_localisation_prestataire = l3_.id_localisation_prestataire) LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (s0_.id_service_prestataire = c1_.id_service_prestataire) WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%' ORDER BY s0_.date_mise_en_ligne DESC, s0_.id_service_prestataire DESC LIMIT 3
Parameters:
[]

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.