Query Metrics
7
Database Queries
7
Different statements
1.85 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.48 ms (26.05%) |
1 |
SELECT t0.id AS id_1, t0.img AS img_2, t0.lien AS lien_3, t0.debut AS debut_4, t0.fin AS fin_5, t0.statut AS statut_6, t0.adminsid AS adminsid_7, t0.createdat AS createdat_8, t0.updatedat AS updatedat_9 FROM popups t0
Parameters:
[] |
|
0.36 ms (19.30%) |
1 |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM popups p0_ WHERE p0_.statut = ?
Parameters:
[
1
]
|
|
0.30 ms (16.21%) |
1 |
SELECT f0_.id AS id_0, f0_.dates_session AS dates_session_1, f0_.annee AS annee_2, f0_.prix AS prix_3, f0_.devise AS devise_4, f0_.image AS image_5, f0_.created_at AS created_at_6, t1_.id AS id_7, t1_.nom AS nom_8, t1_.slug AS slug_9, t1_.description AS description_10, t2_.id AS id_11, t2_.nom AS nom_12, t2_.slug AS slug_13, t2_.description AS description_14, v3_.id AS id_15, v3_.nom AS nom_16, v3_.slug AS slug_17, v3_.image AS image_18, v3_.pays AS pays_19, v3_.texte AS texte_20, v3_.longitude AS longitude_21, v3_.latitude AS latitude_22, v3_.adminsid AS adminsid_23, v3_.created_at AS created_at_24, v3_.updated_at AS updated_at_25, f0_.theme_id AS theme_id_26, f0_.ville_id AS ville_id_27, t1_.thematique_id AS thematique_id_28 FROM formations f0_ INNER JOIN themes t1_ ON f0_.theme_id = t1_.id INNER JOIN thematiques t2_ ON t1_.thematique_id = t2_.id INNER JOIN villes v3_ ON f0_.ville_id = v3_.id WHERE v3_.id = ?
Parameters:
[
"SHANGHAI"
]
|
|
0.23 ms (12.37%) |
1 |
SELECT p0_.id AS id_0, p0_.img AS img_1, p0_.lien AS lien_2, p0_.debut AS debut_3, p0_.fin AS fin_4, p0_.statut AS statut_5, p0_.adminsid AS adminsid_6, p0_.createdat AS createdat_7, p0_.updatedat AS updatedat_8 FROM popups p0_ WHERE p0_.statut = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.createdat DESC
Parameters:
[ 1 31 32 33 34 35 18 4 5 6 7 8 9 ] |
|
0.20 ms (10.74%) |
1 |
SELECT DISTINCT p0_.id AS id_0, p0_.createdat AS createdat_1 FROM popups p0_ WHERE p0_.statut = ? ORDER BY p0_.createdat DESC LIMIT 12 OFFSET 12
Parameters:
[
1
]
|
|
0.15 ms (8.04%) |
1 |
SELECT t0.id AS id_1, t0.titremen AS titremen_2, t0.slug AS slug_3, t0.detailmen AS detailmen_4, t0.statutmen AS statutmen_5, t0.adminsid AS adminsid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM mentions t0
Parameters:
[] |
|
0.13 ms (7.29%) |
1 |
SELECT t0.id AS id_1, t0.img AS img_2, t0.lien AS lien_3, t0.debut AS debut_4, t0.fin AS fin_5, t0.statut AS statut_6, t0.adminsid AS adminsid_7, t0.createdat AS createdat_8, t0.updatedat AS updatedat_9 FROM popups t0 ORDER BY t0.id DESC LIMIT 10
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\Popups | No errors. |
| App\Entity\Formations |
|
| App\Entity\Themes | No errors. |
| App\Entity\Thematiques | No errors. |
| App\Entity\Villes | No errors. |
| App\Entity\Mentions | No errors. |