Query Metrics
5
Database Queries
4
Different statements
4.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.67 ms (41.60%) |
1 |
SELECT p0_.id AS id_0, p0_.content AS content_1, p0_.created_at AS created_at_2, p0_.is_brouillon AS is_brouillon_3, p0_.adresseip AS adresseip_4, p0_.is_statut AS is_statut_5, c1_.id AS id_6, c1_.nom AS nom_7, c1_.ordre AS ordre_8, c1_.photo AS photo_9, m2_.id AS id_10, m2_.email AS email_11, m2_.username AS username_12, m2_.roles AS roles_13, m2_.password AS password_14, m2_.created_at AS created_at_15, m2_.updated_at AS updated_at_16, m2_.is_verified AS is_verified_17, p0_.membre_id AS membre_id_18, p0_.categorie_id AS categorie_id_19 FROM posts p0_ INNER JOIN categories c1_ ON p0_.categorie_id = c1_.id INNER JOIN membres m2_ ON p0_.membre_id = m2_.id ORDER BY p0_.created_at DESC
Parameters:
[] |
|
1.09 ms (27.01%) |
2 |
SELECT DATABASE()
Parameters:
[] |
|
0.85 ms (21.10%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"idtm7391_secret"
]
|
|
0.41 ms (10.29%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ordre AS ordre_3, t0.photo AS photo_4 FROM categories t0
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\Posts | No errors. |
| App\Entity\Categories | No errors. |
| App\Entity\Membres | No errors. |
| App\Entity\Likes | No errors. |
| App\Entity\Messages | No errors. |