Query Metrics
9
Database Queries
9
Different statements
130.83 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 20.50 ms |
SELECT * FROM fusacq_dbo.buzz_actualites WHERE id_actualite = ? AND mode_actualite != ? LIMIT 1
Parameters:
[ 203607 "supprime" ] |
| 2 | 10.34 ms |
SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ? LIMIT 1
Parameters:
[
203607
]
|
| 3 | 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:
[
203607
]
|
| 4 | 10.59 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:
[
203607
]
|
| 5 | 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:
[
203607
]
|
| 6 | 10.34 ms |
SELECT provenance_flux_actualite, visibilite_flux FROM fusacq_dbo.buzz_actualites WHERE id_actualite = ? LIMIT 1
Parameters:
[
203607
]
|
| 7 | 10.43 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:
[
203607
]
|
| 8 | 10.54 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:
[
203607
]
|
| 9 | 37.08 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. |