Query Metrics
5
Database Queries
5
Different statements
3.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.02 ms (31.74%) |
1 |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.statut AS statut_2 FROM categorie_blog c0_ WHERE c0_.statut <> 0
Parameters:
[] |
|
0.76 ms (23.78%) |
1 |
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM blog b0_ INNER JOIN categorie_blog c1_ ON b0_.categorie_id = c1_.id INNER JOIN user u2_ ON b0_.auteur_id = u2_.id WHERE 1 < 2 AND b0_.statut <> 0
Parameters:
[] |
|
0.59 ms (18.29%) |
1 |
SELECT DISTINCT b0_.id AS id_0, b0_.date_publication AS date_publication_1 FROM blog b0_ INNER JOIN categorie_blog c1_ ON b0_.categorie_id = c1_.id INNER JOIN user u2_ ON b0_.auteur_id = u2_.id WHERE 1 < 2 AND b0_.statut <> 0 ORDER BY b0_.date_publication DESC LIMIT 9
Parameters:
[] |
|
0.45 ms (13.99%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.statut AS statut_3, t0.notes AS notes_4, t0.details AS details_5 FROM categorie t0
Parameters:
[] |
|
0.39 ms (12.20%) |
1 |
SELECT t0_.id AS id_0, t0_.nom AS nom_1, t0_.statut AS statut_2 FROM tag_blog t0_ WHERE t0_.statut <> 0
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\CategorieBlog | No errors. |
| App\Entity\TagBlog | No errors. |
| App\Entity\Blog | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Categorie | No errors. |