GET https://training.prixkdo.com/

Query Metrics

28 Database Queries
6 Different statements
8.83 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.44 ms
SELECT t0.id AS id_1, t0.description AS description_2 FROM category t0
Parameters:
[]
2 0.49 ms
SELECT f0_.id AS id_0, f0_.titre AS titre_1, f0_.content AS content_2, f0_.image AS image_3, f0_.price AS price_4, f0_.duree AS duree_5, f0_.created_at AS created_at_6, f0_.updated_at AS updated_at_7, f0_.slug AS slug_8, f0_.user_id AS user_id_9 FROM formation f0_ ORDER BY f0_.id DESC
Parameters:
[]
3 0.62 ms
SELECT t0.id AS id_1, t0.description AS description_2 FROM category t0 INNER JOIN formation_category ON t0.id = formation_category.category_id WHERE formation_category.formation_id = ?
Parameters:
[
  7
]
4 0.35 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.formation_id AS formation_id_3 FROM topic t0 WHERE t0.formation_id = ?
Parameters:
[
  7
]
5 0.40 ms
SELECT t0.id AS id_1, t0.telephone AS telephone_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.email AS email_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.bio AS bio_10, t0.avatar AS avatar_11, t0.is_agree AS is_agree_12, t0.expertise AS expertise_13, t0.profession AS profession_14, t0.last_diplome AS last_diplome_15, t0.other_formation AS other_formation_16, t0.date_naissance AS date_naissance_17 FROM user t0 WHERE t0.id = ?
Parameters:
[
  5
]
6 0.30 ms
SELECT t0.id AS id_1, t0.description AS description_2 FROM category t0 INNER JOIN formation_category ON t0.id = formation_category.category_id WHERE formation_category.formation_id = ?
Parameters:
[
  6
]
7 0.34 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.formation_id AS formation_id_3 FROM topic t0 WHERE t0.formation_id = ?
Parameters:
[
  6
]
8 0.30 ms
SELECT t0.id AS id_1, t0.description AS description_2 FROM category t0 INNER JOIN formation_category ON t0.id = formation_category.category_id WHERE formation_category.formation_id = ?
Parameters:
[
  5
]
9 0.27 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.formation_id AS formation_id_3 FROM topic t0 WHERE t0.formation_id = ?
Parameters:
[
  5
]
10 0.27 ms
SELECT t0.id AS id_1, t0.description AS description_2 FROM category t0 INNER JOIN formation_category ON t0.id = formation_category.category_id WHERE formation_category.formation_id = ?
Parameters:
[
  4
]
11 0.28 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.formation_id AS formation_id_3 FROM topic t0 WHERE t0.formation_id = ?
Parameters:
[
  4
]
12 0.28 ms
SELECT t0.id AS id_1, t0.description AS description_2 FROM category t0 INNER JOIN formation_category ON t0.id = formation_category.category_id WHERE formation_category.formation_id = ?
Parameters:
[
  3
]
13 0.26 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.formation_id AS formation_id_3 FROM topic t0 WHERE t0.formation_id = ?
Parameters:
[
  3
]
14 0.27 ms
SELECT t0.id AS id_1, t0.description AS description_2 FROM category t0 INNER JOIN formation_category ON t0.id = formation_category.category_id WHERE formation_category.formation_id = ?
Parameters:
[
  2
]
15 0.24 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.formation_id AS formation_id_3 FROM topic t0 WHERE t0.formation_id = ?
Parameters:
[
  2
]
16 0.38 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.content AS content_3, t0.image AS image_4, t0.price AS price_5, t0.duree AS duree_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.slug AS slug_9, t0.user_id AS user_id_10 FROM formation t0 INNER JOIN formation_category ON t0.id = formation_category.formation_id WHERE formation_category.category_id = ?
Parameters:
[
  1
]
17 0.30 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.content AS content_3, t0.image AS image_4, t0.price AS price_5, t0.duree AS duree_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.slug AS slug_9, t0.user_id AS user_id_10 FROM formation t0 INNER JOIN formation_category ON t0.id = formation_category.formation_id WHERE formation_category.category_id = ?
Parameters:
[
  2
]
18 0.30 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.content AS content_3, t0.image AS image_4, t0.price AS price_5, t0.duree AS duree_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.slug AS slug_9, t0.user_id AS user_id_10 FROM formation t0 INNER JOIN formation_category ON t0.id = formation_category.formation_id WHERE formation_category.category_id = ?
Parameters:
[
  3
]
19 0.26 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.content AS content_3, t0.image AS image_4, t0.price AS price_5, t0.duree AS duree_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.slug AS slug_9, t0.user_id AS user_id_10 FROM formation t0 INNER JOIN formation_category ON t0.id = formation_category.formation_id WHERE formation_category.category_id = ?
Parameters:
[
  4
]
20 0.26 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.content AS content_3, t0.image AS image_4, t0.price AS price_5, t0.duree AS duree_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.slug AS slug_9, t0.user_id AS user_id_10 FROM formation t0 INNER JOIN formation_category ON t0.id = formation_category.formation_id WHERE formation_category.category_id = ?
Parameters:
[
  5
]
21 0.29 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.content AS content_3, t0.image AS image_4, t0.price AS price_5, t0.duree AS duree_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.slug AS slug_9, t0.user_id AS user_id_10 FROM formation t0 INNER JOIN formation_category ON t0.id = formation_category.formation_id WHERE formation_category.category_id = ?
Parameters:
[
  6
]
22 0.27 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.content AS content_3, t0.image AS image_4, t0.price AS price_5, t0.duree AS duree_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.slug AS slug_9, t0.user_id AS user_id_10 FROM formation t0 INNER JOIN formation_category ON t0.id = formation_category.formation_id WHERE formation_category.category_id = ?
Parameters:
[
  7
]
23 0.30 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.content AS content_3, t0.image AS image_4, t0.price AS price_5, t0.duree AS duree_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.slug AS slug_9, t0.user_id AS user_id_10 FROM formation t0 INNER JOIN formation_category ON t0.id = formation_category.formation_id WHERE formation_category.category_id = ?
Parameters:
[
  8
]
24 0.25 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.content AS content_3, t0.image AS image_4, t0.price AS price_5, t0.duree AS duree_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.slug AS slug_9, t0.user_id AS user_id_10 FROM formation t0 INNER JOIN formation_category ON t0.id = formation_category.formation_id WHERE formation_category.category_id = ?
Parameters:
[
  9
]
25 0.24 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.content AS content_3, t0.image AS image_4, t0.price AS price_5, t0.duree AS duree_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.slug AS slug_9, t0.user_id AS user_id_10 FROM formation t0 INNER JOIN formation_category ON t0.id = formation_category.formation_id WHERE formation_category.category_id = ?
Parameters:
[
  10
]
26 0.25 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.content AS content_3, t0.image AS image_4, t0.price AS price_5, t0.duree AS duree_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.slug AS slug_9, t0.user_id AS user_id_10 FROM formation t0 INNER JOIN formation_category ON t0.id = formation_category.formation_id WHERE formation_category.category_id = ?
Parameters:
[
  11
]
27 0.33 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.content AS content_3, t0.image AS image_4, t0.price AS price_5, t0.duree AS duree_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.slug AS slug_9, t0.user_id AS user_id_10 FROM formation t0 INNER JOIN formation_category ON t0.id = formation_category.formation_id WHERE formation_category.category_id = ?
Parameters:
[
  12
]
28 0.28 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.content AS content_3, t0.image AS image_4, t0.price AS price_5, t0.duree AS duree_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.slug AS slug_9, t0.user_id AS user_id_10 FROM formation t0 INNER JOIN formation_category ON t0.id = formation_category.formation_id WHERE formation_category.category_id = ?
Parameters:
[
  13
]

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\Category No errors.
App\Entity\Formation No errors.
App\Entity\User No errors.
App\Entity\Topic No errors.
App\Entity\Review No errors.
App\Entity\PlageFormation No errors.
App\Entity\ReserveFormation No errors.