Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.image AS image_2,
  c0_.description AS description_3,
  c0_.tags AS tags_4,
  c0_.isValidated AS isValidated_5,
  c0_.slug AS slug_6,
  c0_.views AS views_7,
  c0_.subCategoryId AS subCategoryId_8,
  c0_.niveauId AS niveauId_9,
  c0_.enseignantId AS enseignantId_10
FROM
  cours c0_
WHERE
  c0_.subCategoryId = ?
LIMIT
  3

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.image AS image_2, c0_.description AS description_3, c0_.tags AS tags_4, c0_.isValidated AS isValidated_5, c0_.slug AS slug_6, c0_.views AS views_7, c0_.subCategoryId AS subCategoryId_8, c0_.niveauId AS niveauId_9, c0_.enseignantId AS enseignantId_10 FROM cours c0_ WHERE c0_.subCategoryId = '1' LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.lien AS lien_2,
  t0.type AS type_3,
  t0.coursId AS coursId_4
FROM
  ressources t0
WHERE
  t0.coursId = ?

SELECT t0.id AS id_1, t0.lien AS lien_2, t0.type AS type_3, t0.coursId AS coursId_4 FROM ressources t0 WHERE t0.coursId = 0;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.username AS username_4,
  t0.date_de_naissance AS date_de_naissance_5,
  t0.email AS email_6,
  t0.password AS password_7,
  t0.role AS role_8,
  t0.status AS status_9,
  t0.token AS token_10,
  t0.image AS image_11,
  t0.level_id AS level_id_12
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.username AS username_4, t0.date_de_naissance AS date_de_naissance_5, t0.email AS email_6, t0.password AS password_7, t0.role AS role_8, t0.status AS status_9, t0.token AS token_10, t0.image AS image_11, t0.level_id AS level_id_12 FROM user t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.last_updated AS last_updated_4,
  t0.image AS image_5,
  t0.nbSousCategorie AS nbSousCategorie_6
FROM
  categorie t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.last_updated AS last_updated_4, t0.image AS image_5, t0.nbSousCategorie AS nbSousCategorie_6 FROM categorie t0;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.images AS images_4,
  t0.status AS status_5,
  t0.dateCreation AS dateCreation_6,
  t0.categorieId AS categorieId_7
FROM
  souscategorie t0
WHERE
  t0.categorieId = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.images AS images_4, t0.status AS status_5, t0.dateCreation AS dateCreation_6, t0.categorieId AS categorieId_7 FROM souscategorie t0 WHERE t0.categorieId = 0;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.content AS content_3,
  t0.duree AS duree_4,
  t0.image AS image_5,
  t0.video AS video_6,
  t0.classement AS classement_7,
  t0.coursId AS coursId_8
FROM
  lessons t0
WHERE
  t0.coursId = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.content AS content_3, t0.duree AS duree_4, t0.image AS image_5, t0.video AS video_6, t0.classement AS classement_7, t0.coursId AS coursId_8 FROM lessons t0 WHERE t0.coursId = 0;

SELECT
  t0.id_avi AS id_avi_1,
  t0.note AS note_2,
  t0.message AS message_3,
  t0.date AS date_4,
  t0.id_user AS id_user_5,
  t0.coursId AS coursId_6
FROM
  avis t0
WHERE
  t0.coursId = ?

SELECT t0.id_avi AS id_avi_1, t0.note AS note_2, t0.message AS message_3, t0.date AS date_4, t0.id_user AS id_user_5, t0.coursId AS coursId_6 FROM avis t0 WHERE t0.coursId = 0;

SELECT
  t0.id AS id_1,
  t0.niveau AS niveau_2
FROM
  LEVEL t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.niveau AS niveau_2 FROM LEVEL t0 WHERE t0.id = 1;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  cours c0_
WHERE
  c0_.subCategoryId = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM cours c0_ WHERE c0_.subCategoryId = '1';