Query Metrics
7
Database Queries
7
Different statements
2.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.69 ms (25.86%) |
1 |
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.slug AS slug_3, t0.type AS type_4, t0.duree AS duree_5, t0.prixpresentiel AS prixpresentiel_6, t0.prixvirtuelle AS prixvirtuelle_7, t0.devise AS devise_8, t0.adminsid AS adminsid_9, t0.createdat AS createdat_10, t0.updatedat AS updatedat_11 FROM certyous t0
Parameters:
[] |
|
0.54 ms (20.25%) |
1 |
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM certyous c0_
Parameters:
[] |
|
0.41 ms (15.57%) |
1 |
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.slug AS slug_3, t0.image AS image_4, t0.ville AS ville_5, t0.devise AS devise_6, t0.datedebut AS datedebut_7, t0.datefin AS datefin_8, t0.prix AS prix_9, t0.texte AS texte_10, t0.adminsid AS adminsid_11, t0.createdat AS createdat_12, t0.updatedat AS updatedat_13 FROM managements t0 ORDER BY t0.id DESC LIMIT 5
Parameters:
[] |
|
0.34 ms (12.89%) |
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.31 ms (11.61%) |
1 |
SELECT c0_.id AS id_0, c0_.prixpresentiel AS prixpresentiel_1, c0_.prixvirtuelle AS prixvirtuelle_2, c0_.devise AS devise_3, c0_.theme AS theme_4, c0_.duree AS duree_5, c0_.slug AS slug_6, c0_.type AS type_7, c0_.createdat AS createdat_8 FROM certyous c0_ WHERE c0_.id IN (?, ?, ?, ?, ?)
Parameters:
[ 1 2 3 5 6 ] |
|
0.21 ms (7.85%) |
1 |
SELECT c0_.id AS id_0, c0_.prixpresentiel AS prixpresentiel_1, c0_.prixvirtuelle AS prixvirtuelle_2, c0_.devise AS devise_3, c0_.theme AS theme_4, c0_.duree AS duree_5, c0_.slug AS slug_6, c0_.type AS type_7, c0_.createdat AS createdat_8 FROM certyous c0_
Parameters:
[] |
|
0.16 ms (5.97%) |
1 |
SELECT DISTINCT c0_.id AS id_0 FROM certyous c0_ LIMIT 12
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\Certyous | No errors. |
| App\Entity\Managements | No errors. |
| App\Entity\Mentions | No errors. |