Query Metrics
3
Database Queries
3
Different statements
17.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
13.59 ms (78.25%) |
1 |
SELECT count(DISTINCT f0_.id) AS sclr_0 FROM formations f0_ INNER JOIN themes t1_ ON (f0_.theme_id = t1_.id) INNER JOIN villes v2_ ON (f0_.ville_id = v2_.id) INNER JOIN thematiques t3_ ON (t1_.thematique_id = t3_.id)
Parameters:
[] |
|
2.54 ms (14.60%) |
1 |
SELECT DISTINCT f0_.id AS id_0, f0_.created_at AS created_at_1 FROM formations f0_ INNER JOIN themes t1_ ON (f0_.theme_id = t1_.id) INNER JOIN villes v2_ ON (f0_.ville_id = v2_.id) INNER JOIN thematiques t3_ ON (t1_.thematique_id = t3_.id) ORDER BY f0_.created_at DESC LIMIT 12
Parameters:
[] |
|
1.24 ms (7.15%) |
1 |
SELECT f0_.id AS id_0, f0_.dates_session AS dates_session_1, f0_.prix AS prix_2, f0_.devise AS devise_3, t1_.nom AS nom_4, t2_.nom AS nom_5, v3_.nom AS nom_6, v3_.pays AS pays_7, f0_.created_at AS created_at_8, t1_.slug AS slug_9 FROM formations f0_ INNER JOIN themes t1_ ON (f0_.theme_id = t1_.id) INNER JOIN villes v3_ ON (f0_.ville_id = v3_.id) INNER JOIN thematiques t2_ ON (t1_.thematique_id = t2_.id) WHERE f0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY f0_.created_at DESC
Parameters:
[ 42 47 29 34 26 39 31 44 36 49 41 46 ] |
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\Formations | No errors. |
| App\Entity\Themes | No errors. |
| App\Entity\Villes | No errors. |
| App\Entity\Thematiques | No errors. |