Query Metrics

9 Database Queries
9 Different statements
118.31 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 10.65 ms
SELECT * FROM fusacq_dbo.buzz_actualites WHERE id_actualite = ? AND mode_actualite != ? LIMIT 1
Parameters:
[
  204167
  "supprime"
]
2 10.15 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  204167
]
3 10.22 ms
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? LIMIT 1
Parameters:
[
  204167
]
4 10.33 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:
[
  204167
]
5 10.45 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:
[
  204167
]
6 10.16 ms
SELECT provenance_flux_actualite, visibilite_flux FROM fusacq_dbo.buzz_actualites WHERE id_actualite = ? LIMIT 1
Parameters:
[
  204167
]
7 10.17 ms
SELECT b0_.id_operation AS id_operation_0, b0_.provenance_flux_actualite AS provenance_flux_actualite_1, b0_.visibilite_flux AS visibilite_flux_2 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
  204167
]
8 10.29 ms
SELECT b0_.id_secteur_activite AS id_secteur_activite_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = ? AND b0_.id_secteur_activite IS NOT NULL LIMIT 1
Parameters:
[
  204167
]
9 35.89 ms
SELECT b0_.id_secteur_activite AS id_secteur_activite_0, COUNT(b0_.id_operation) AS sclr_1 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_secteur_activite IS NOT NULL GROUP BY b0_.id_secteur_activite ORDER BY sclr_1 DESC LIMIT 1
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.

Entities Mapping

Class Mapping errors
App\Entity\BuzzActualites No errors.
App\Entity\BuzzOperations No errors.
App\Entity\Translation No errors.