https://veekingfr.hop-linweb-20.sos-data.fr/coach/jeanne-doe/cours

Query Metrics

8 Database Queries
4 Different statements
2.89 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.61 ms
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:
[
  "jeanne-doe"
]
2 0.66 ms
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:
[
  1
]
3 0.32 ms
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:
[
  8
]
4 0.42 ms
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:
[
  7
]
5 0.23 ms
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:
[
  8
]
6 0.19 ms
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:
[
  9
]
7 0.17 ms
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
]
8 0.28 ms
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.