Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.resume AS resume_2,
  t0.situation_professionelle AS situation_professionelle_3,
  t0.diplome AS diplome_4,
  t0.niveau_education AS niveau_education_5,
  t0.short_description AS short_description_6,
  t0.balance AS balance_7,
  t0.google_access_token AS google_access_token_8,
  t0.google_refresh_token AS google_refresh_token_9,
  t0.token_expires_at AS token_expires_at_10,
  t0.years_experience AS years_experience_11,
  t0.specialite AS specialite_12,
  t0.user_id AS user_id_13
FROM
  professeur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.resume AS resume_2, t0.situation_professionelle AS situation_professionelle_3, t0.diplome AS diplome_4, t0.niveau_education AS niveau_education_5, t0.short_description AS short_description_6, t0.balance AS balance_7, t0.google_access_token AS google_access_token_8, t0.google_refresh_token AS google_refresh_token_9, t0.token_expires_at AS token_expires_at_10, t0.years_experience AS years_experience_11, t0.specialite AS specialite_12, t0.user_id AS user_id_13 FROM professeur t0 WHERE t0.id = '79';

SELECT
  t0_.id AS id_0,
  t0_.rating AS rating_1,
  t0_.comment AS comment_2,
  t0_.status AS status_3,
  t0_.created_at AS created_at_4,
  t0_.validated_at AS validated_at_5,
  t0_.admin_notes AS admin_notes_6,
  s1_.id AS id_7,
  s1_.role AS role_8,
  s1_.solde AS solde_9,
  u2_.id AS id_10,
  u2_.email AS email_11,
  u2_.roles AS roles_12,
  u2_.password AS password_13,
  u2_.is_verified AS is_verified_14,
  u2_.first_name AS first_name_15,
  u2_.last_name AS last_name_16,
  u2_.gender AS gender_17,
  u2_.avatar AS avatar_18,
  u2_.phone AS phone_19,
  u2_.user_type AS user_type_20,
  u2_.dob AS dob_21,
  u2_.created_at AS created_at_22,
  u2_.updated_at AS updated_at_23,
  t0_.student_id AS student_id_24,
  t0_.professeur_id AS professeur_id_25,
  t0_.validated_by_id AS validated_by_id_26,
  s1_.user_id AS user_id_27,
  s1_.niveau_id AS niveau_id_28
FROM
  teacher_review t0_
  LEFT JOIN student s1_ ON t0_.student_id = s1_.id
  LEFT JOIN user u2_ ON s1_.user_id = u2_.id
WHERE
  t0_.professeur_id = ?
  AND t0_.status = ?
ORDER BY
  t0_.created_at DESC
LIMIT
  3

SELECT t0_.id AS id_0, t0_.rating AS rating_1, t0_.comment AS comment_2, t0_.status AS status_3, t0_.created_at AS created_at_4, t0_.validated_at AS validated_at_5, t0_.admin_notes AS admin_notes_6, s1_.id AS id_7, s1_.role AS role_8, s1_.solde AS solde_9, u2_.id AS id_10, u2_.email AS email_11, u2_.roles AS roles_12, u2_.password AS password_13, u2_.is_verified AS is_verified_14, u2_.first_name AS first_name_15, u2_.last_name AS last_name_16, u2_.gender AS gender_17, u2_.avatar AS avatar_18, u2_.phone AS phone_19, u2_.user_type AS user_type_20, u2_.dob AS dob_21, u2_.created_at AS created_at_22, u2_.updated_at AS updated_at_23, t0_.student_id AS student_id_24, t0_.professeur_id AS professeur_id_25, t0_.validated_by_id AS validated_by_id_26, s1_.user_id AS user_id_27, s1_.niveau_id AS niveau_id_28 FROM teacher_review t0_ LEFT JOIN student s1_ ON t0_.student_id = s1_.id LEFT JOIN user u2_ ON s1_.user_id = u2_.id WHERE t0_.professeur_id = 79 AND t0_.status = 'approved' ORDER BY t0_.created_at DESC LIMIT 3;

SELECT
  COUNT(t0_.id) AS sclr_0,
  AVG(t0_.rating) AS sclr_1,
  SUM(
    CASE WHEN t0_.rating = 5 THEN
      1
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(
    CASE WHEN t0_.rating = 4 THEN
      1
    ELSE
      0
    END
  ) AS sclr_3,
  SUM(
    CASE WHEN t0_.rating = 3 THEN
      1
    ELSE
      0
    END
  ) AS sclr_4,
  SUM(
    CASE WHEN t0_.rating = 2 THEN
      1
    ELSE
      0
    END
  ) AS sclr_5,
  SUM(
    CASE WHEN t0_.rating = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_6
FROM
  teacher_review t0_
WHERE
  t0_.professeur_id = ?
  AND t0_.status = ?

SELECT COUNT(t0_.id) AS sclr_0, AVG(t0_.rating) AS sclr_1, SUM(CASE WHEN t0_.rating = 5 THEN 1 ELSE 0 END) AS sclr_2, SUM(CASE WHEN t0_.rating = 4 THEN 1 ELSE 0 END) AS sclr_3, SUM(CASE WHEN t0_.rating = 3 THEN 1 ELSE 0 END) AS sclr_4, SUM(CASE WHEN t0_.rating = 2 THEN 1 ELSE 0 END) AS sclr_5, SUM(CASE WHEN t0_.rating = 1 THEN 1 ELSE 0 END) AS sclr_6 FROM teacher_review t0_ WHERE t0_.professeur_id = 79 AND t0_.status = 'approved';

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.gender AS gender_8,
  t0.avatar AS avatar_9,
  t0.phone AS phone_10,
  t0.user_type AS user_type_11,
  t0.dob AS dob_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t15.id AS id_16,
  t15.resume AS resume_17,
  t15.situation_professionelle AS situation_professionelle_18,
  t15.diplome AS diplome_19,
  t15.niveau_education AS niveau_education_20,
  t15.short_description AS short_description_21,
  t15.balance AS balance_22,
  t15.google_access_token AS google_access_token_23,
  t15.google_refresh_token AS google_refresh_token_24,
  t15.token_expires_at AS token_expires_at_25,
  t15.years_experience AS years_experience_26,
  t15.specialite AS specialite_27,
  t15.user_id AS user_id_28,
  t29.id AS id_30,
  t29.role AS role_31,
  t29.solde AS solde_32,
  t29.user_id AS user_id_33,
  t29.niveau_id AS niveau_id_34
FROM
  user t0
  LEFT JOIN professeur t15 ON t15.user_id = t0.id
  LEFT JOIN student t29 ON t29.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.gender AS gender_8, t0.avatar AS avatar_9, t0.phone AS phone_10, t0.user_type AS user_type_11, t0.dob AS dob_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t15.id AS id_16, t15.resume AS resume_17, t15.situation_professionelle AS situation_professionelle_18, t15.diplome AS diplome_19, t15.niveau_education AS niveau_education_20, t15.short_description AS short_description_21, t15.balance AS balance_22, t15.google_access_token AS google_access_token_23, t15.google_refresh_token AS google_refresh_token_24, t15.token_expires_at AS token_expires_at_25, t15.years_experience AS years_experience_26, t15.specialite AS specialite_27, t15.user_id AS user_id_28, t29.id AS id_30, t29.role AS role_31, t29.solde AS solde_32, t29.user_id AS user_id_33, t29.niveau_id AS niveau_id_34 FROM user t0 LEFT JOIN professeur t15 ON t15.user_id = t0.id LEFT JOIN student t29 ON t29.user_id = t0.id WHERE t0.id = 124;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.status AS status_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.short_description AS short_description_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.slug AS slug_9,
  t0.is_validated AS is_validated_10,
  t0.professeur_id AS professeur_id_11,
  t0.niveau_id AS niveau_id_12,
  t0.matiere_id AS matiere_id_13
FROM
  cours t0
WHERE
  t0.professeur_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.status AS status_3, t0.description AS description_4, t0.price AS price_5, t0.short_description AS short_description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.slug AS slug_9, t0.is_validated AS is_validated_10, t0.professeur_id AS professeur_id_11, t0.niveau_id AS niveau_id_12, t0.matiere_id AS matiere_id_13 FROM cours t0 WHERE t0.professeur_id = 79;

SELECT
  t0.id AS id_1,
  t0.matiere_name AS matiere_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.slug AS slug_5,
  t0.image AS image_6,
  t0.color AS color_7
FROM
  matiere t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.matiere_name AS matiere_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.slug AS slug_5, t0.image AS image_6, t0.color AS color_7 FROM matiere t0 WHERE t0.id = 4;