Query Metrics
4
Database Queries
4
Different statements
1.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.65 ms (33.20%) |
1 |
SELECT t1.name AS name_2, t1.status AS status_3, t1.created_at AS created_at_4, t1.updated_at AS updated_at_5, t1.id AS id_6, t1.title AS title_7, t0.prenom AS prenom_8, t0.pseudo AS pseudo_9, t0.description AS description_10, t0.anciennetee AS anciennetee_11, t0.accroche AS accroche_12, t0.img_profil_id AS img_profil_id_13, t0.img_banniere_id AS img_banniere_id_14, t0.user_id AS user_id_15, t1.type FROM coach t0 INNER JOIN post_type t1 ON t0.id = t1.id WHERE t1.name = ? LIMIT 1
Parameters:
[
"jean-foo"
]
|
|
0.59 ms (29.95%) |
1 |
SELECT t2.name AS name_3, t2.status AS status_4, t2.created_at AS created_at_5, t2.updated_at AS updated_at_6, t2.id AS id_7, t2.title AS title_8, t1.prix_ht AS prix_ht_9, t0.description AS description_10, t0.date AS date_11, t0.duree AS duree_12, t0.accroche AS accroche_13, t0.media_id AS media_id_14, t2.type FROM cours t0 INNER JOIN post_type_produit t1 ON t0.id = t1.id INNER JOIN post_type t2 ON t0.id = t2.id INNER JOIN coach_cours ON t0.id = coach_cours.cours_id WHERE coach_cours.coach_id = ?
Parameters:
[
2
]
|
|
0.38 ms (19.19%) |
1 |
SELECT t0.title AS title_1, t0.path AS path_2, t0.type AS type_3, t0.meta AS meta_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7 FROM media t0 WHERE t0.id = ?
Parameters:
[
7
]
|
|
0.35 ms (17.66%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2 FROM skills t0 INNER JOIN cours_skills ON t0.id = cours_skills.skills_id WHERE cours_skills.cours_id = ?
Parameters:
[
10
]
|
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\PostType\PostType | No errors. |
| App\Entity\User\Coach | No errors. |
| App\Entity\Media\Media | No errors. |
| App\Entity\User | No errors. |
| App\Entity\PostType\PostTypeBloc | No errors. |
| App\Entity\PostType\PostTypeProduit | No errors. |
| App\Entity\Boutique\Cours\Cours | No errors. |
| App\Entity\User\Skills | No errors. |
| App\Entity\Boutique\Produit\Produit | No errors. |
| App\Entity\Boutique\Evenement\Evenement | No errors. |
| App\Entity\Boutique\Panier\PanierLigne | No errors. |
| App\Entity\PostType\Actualite\Actualite | No errors. |