Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  forum_category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM forum_category t0;

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.created_at AS created_at_2,
  f0_.updated_at AS updated_at_3,
  f0_.is_pinned AS is_pinned_4,
  f0_.is_solved AS is_solved_5,
  f0_.tags AS tags_6,
  f1_.id AS id_7,
  f1_.name AS name_8,
  f1_.slug AS slug_9,
  f2_.id AS id_10,
  f2_.content AS content_11,
  f2_.created_at AS created_at_12,
  f2_.is_solution AS is_solution_13,
  f0_.category_id AS category_id_14,
  f0_.author_id AS author_id_15,
  f2_.topic_id AS topic_id_16,
  f2_.author_id AS author_id_17
FROM
  forum_topic f0_
  LEFT JOIN forum_category f1_ ON f0_.category_id = f1_.id
  LEFT JOIN forum_post f2_ ON f0_.id = f2_.topic_id
ORDER BY
  f0_.is_pinned DESC,
  f0_.updated_at DESC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.created_at AS created_at_2, f0_.updated_at AS updated_at_3, f0_.is_pinned AS is_pinned_4, f0_.is_solved AS is_solved_5, f0_.tags AS tags_6, f1_.id AS id_7, f1_.name AS name_8, f1_.slug AS slug_9, f2_.id AS id_10, f2_.content AS content_11, f2_.created_at AS created_at_12, f2_.is_solution AS is_solution_13, f0_.category_id AS category_id_14, f0_.author_id AS author_id_15, f2_.topic_id AS topic_id_16, f2_.author_id AS author_id_17 FROM forum_topic f0_ LEFT JOIN forum_category f1_ ON f0_.category_id = f1_.id LEFT JOIN forum_post f2_ ON f0_.id = f2_.topic_id ORDER BY f0_.is_pinned DESC, f0_.updated_at DESC;

SELECT
  t0.id AS id_5,
  t0.username AS username_6,
  t0.last_name AS last_name_7,
  t0.first_name AS first_name_8,
  t0.roles AS roles_9,
  t0.password AS password_10,
  t0.email AS email_11,
  t0.activated AS activated_12,
  t0.tmp_code AS tmp_code_13,
  t0.tmp_code_date AS tmp_code_date_14,
  t0.signature AS signature_15,
  t0.uuid AS uuid_16,
  t0.phone_number AS phone_number_17,
  t0.avatar_id AS avatar_id_18,
  t0.dtype,
  t1.password_save AS password_save_19,
  t1.documents AS documents_20,
  t1.diploma AS diploma_21,
  t1.tutorial_completed AS tutorial_completed_22,
  t1.financial_aid AS financial_aid_23,
  t1.cohort_id AS cohort_id_24,
  t2.role AS role_25,
  t2.entrance_code AS entrance_code_26,
  t2.entrance_code_date AS entrance_code_date_27,
  t2.responsible_id AS responsible_id_28,
  t3.role AS role_29,
  t3.entrance_code AS entrance_code_30,
  t3.entrance_code_date AS entrance_code_date_31,
  t3.sector_id AS sector_id_32,
  t4.role AS role_33,
  t4.entrance_code AS entrance_code_34,
  t4.entrance_code_date AS entrance_code_date_35,
  t4.coordinator_id AS coordinator_id_36
FROM
  user t0
  LEFT JOIN trainee t1 ON t0.id = t1.id
  LEFT JOIN coordinator t2 ON t0.id = t2.id
  LEFT JOIN responsible t3 ON t0.id = t3.id
  LEFT JOIN trainer t4 ON t0.id = t4.id
WHERE
  t0.id = ?

SELECT t0.id AS id_5, t0.username AS username_6, t0.last_name AS last_name_7, t0.first_name AS first_name_8, t0.roles AS roles_9, t0.password AS password_10, t0.email AS email_11, t0.activated AS activated_12, t0.tmp_code AS tmp_code_13, t0.tmp_code_date AS tmp_code_date_14, t0.signature AS signature_15, t0.uuid AS uuid_16, t0.phone_number AS phone_number_17, t0.avatar_id AS avatar_id_18, t0.dtype, t1.password_save AS password_save_19, t1.documents AS documents_20, t1.diploma AS diploma_21, t1.tutorial_completed AS tutorial_completed_22, t1.financial_aid AS financial_aid_23, t1.cohort_id AS cohort_id_24, t2.role AS role_25, t2.entrance_code AS entrance_code_26, t2.entrance_code_date AS entrance_code_date_27, t2.responsible_id AS responsible_id_28, t3.role AS role_29, t3.entrance_code AS entrance_code_30, t3.entrance_code_date AS entrance_code_date_31, t3.sector_id AS sector_id_32, t4.role AS role_33, t4.entrance_code AS entrance_code_34, t4.entrance_code_date AS entrance_code_date_35, t4.coordinator_id AS coordinator_id_36 FROM user t0 LEFT JOIN trainee t1 ON t0.id = t1.id LEFT JOIN coordinator t2 ON t0.id = t2.id LEFT JOIN responsible t3 ON t0.id = t3.id LEFT JOIN trainer t4 ON t0.id = t4.id WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.category AS category_2,
  t0.registry_number AS registry_number_3,
  t0.job AS job_4,
  t0.qualification AS qualification_5,
  t0.contract_label AS contract_label_6,
  t0.nationality AS nationality_7,
  t0.birth_date AS birth_date_8,
  t0.sex AS sex_9,
  t0.hired_at AS hired_at_10,
  t0.left_at AS left_at_11,
  t0.notes AS notes_12,
  t0.created_at AS created_at_13,
  t0.user_id AS user_id_14
FROM
  collaborator t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.category AS category_2, t0.registry_number AS registry_number_3, t0.job AS job_4, t0.qualification AS qualification_5, t0.contract_label AS contract_label_6, t0.nationality AS nationality_7, t0.birth_date AS birth_date_8, t0.sex AS sex_9, t0.hired_at AS hired_at_10, t0.left_at AS left_at_11, t0.notes AS notes_12, t0.created_at AS created_at_13, t0.user_id AS user_id_14 FROM collaborator t0 WHERE t0.user_id = 1;

SELECT
  t0.id AS id_5,
  t0.username AS username_6,
  t0.last_name AS last_name_7,
  t0.first_name AS first_name_8,
  t0.roles AS roles_9,
  t0.password AS password_10,
  t0.email AS email_11,
  t0.activated AS activated_12,
  t0.tmp_code AS tmp_code_13,
  t0.tmp_code_date AS tmp_code_date_14,
  t0.signature AS signature_15,
  t0.uuid AS uuid_16,
  t0.phone_number AS phone_number_17,
  t0.avatar_id AS avatar_id_18,
  t0.dtype,
  t1.password_save AS password_save_19,
  t1.documents AS documents_20,
  t1.diploma AS diploma_21,
  t1.tutorial_completed AS tutorial_completed_22,
  t1.financial_aid AS financial_aid_23,
  t1.cohort_id AS cohort_id_24,
  t2.role AS role_25,
  t2.entrance_code AS entrance_code_26,
  t2.entrance_code_date AS entrance_code_date_27,
  t2.responsible_id AS responsible_id_28,
  t3.role AS role_29,
  t3.entrance_code AS entrance_code_30,
  t3.entrance_code_date AS entrance_code_date_31,
  t3.sector_id AS sector_id_32,
  t4.role AS role_33,
  t4.entrance_code AS entrance_code_34,
  t4.entrance_code_date AS entrance_code_date_35,
  t4.coordinator_id AS coordinator_id_36
FROM
  user t0
  LEFT JOIN trainee t1 ON t0.id = t1.id
  LEFT JOIN coordinator t2 ON t0.id = t2.id
  LEFT JOIN responsible t3 ON t0.id = t3.id
  LEFT JOIN trainer t4 ON t0.id = t4.id
WHERE
  t0.id = ?

SELECT t0.id AS id_5, t0.username AS username_6, t0.last_name AS last_name_7, t0.first_name AS first_name_8, t0.roles AS roles_9, t0.password AS password_10, t0.email AS email_11, t0.activated AS activated_12, t0.tmp_code AS tmp_code_13, t0.tmp_code_date AS tmp_code_date_14, t0.signature AS signature_15, t0.uuid AS uuid_16, t0.phone_number AS phone_number_17, t0.avatar_id AS avatar_id_18, t0.dtype, t1.password_save AS password_save_19, t1.documents AS documents_20, t1.diploma AS diploma_21, t1.tutorial_completed AS tutorial_completed_22, t1.financial_aid AS financial_aid_23, t1.cohort_id AS cohort_id_24, t2.role AS role_25, t2.entrance_code AS entrance_code_26, t2.entrance_code_date AS entrance_code_date_27, t2.responsible_id AS responsible_id_28, t3.role AS role_29, t3.entrance_code AS entrance_code_30, t3.entrance_code_date AS entrance_code_date_31, t3.sector_id AS sector_id_32, t4.role AS role_33, t4.entrance_code AS entrance_code_34, t4.entrance_code_date AS entrance_code_date_35, t4.coordinator_id AS coordinator_id_36 FROM user t0 LEFT JOIN trainee t1 ON t0.id = t1.id LEFT JOIN coordinator t2 ON t0.id = t2.id LEFT JOIN responsible t3 ON t0.id = t3.id LEFT JOIN trainer t4 ON t0.id = t4.id WHERE t0.id = 106;

SELECT
  t0.id AS id_1,
  t0.category AS category_2,
  t0.registry_number AS registry_number_3,
  t0.job AS job_4,
  t0.qualification AS qualification_5,
  t0.contract_label AS contract_label_6,
  t0.nationality AS nationality_7,
  t0.birth_date AS birth_date_8,
  t0.sex AS sex_9,
  t0.hired_at AS hired_at_10,
  t0.left_at AS left_at_11,
  t0.notes AS notes_12,
  t0.created_at AS created_at_13,
  t0.user_id AS user_id_14
FROM
  collaborator t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.category AS category_2, t0.registry_number AS registry_number_3, t0.job AS job_4, t0.qualification AS qualification_5, t0.contract_label AS contract_label_6, t0.nationality AS nationality_7, t0.birth_date AS birth_date_8, t0.sex AS sex_9, t0.hired_at AS hired_at_10, t0.left_at AS left_at_11, t0.notes AS notes_12, t0.created_at AS created_at_13, t0.user_id AS user_id_14 FROM collaborator t0 WHERE t0.user_id = 106;

SELECT
  t0.id AS id_5,
  t0.username AS username_6,
  t0.last_name AS last_name_7,
  t0.first_name AS first_name_8,
  t0.roles AS roles_9,
  t0.password AS password_10,
  t0.email AS email_11,
  t0.activated AS activated_12,
  t0.tmp_code AS tmp_code_13,
  t0.tmp_code_date AS tmp_code_date_14,
  t0.signature AS signature_15,
  t0.uuid AS uuid_16,
  t0.phone_number AS phone_number_17,
  t0.avatar_id AS avatar_id_18,
  t0.dtype,
  t1.password_save AS password_save_19,
  t1.documents AS documents_20,
  t1.diploma AS diploma_21,
  t1.tutorial_completed AS tutorial_completed_22,
  t1.financial_aid AS financial_aid_23,
  t1.cohort_id AS cohort_id_24,
  t2.role AS role_25,
  t2.entrance_code AS entrance_code_26,
  t2.entrance_code_date AS entrance_code_date_27,
  t2.responsible_id AS responsible_id_28,
  t3.role AS role_29,
  t3.entrance_code AS entrance_code_30,
  t3.entrance_code_date AS entrance_code_date_31,
  t3.sector_id AS sector_id_32,
  t4.role AS role_33,
  t4.entrance_code AS entrance_code_34,
  t4.entrance_code_date AS entrance_code_date_35,
  t4.coordinator_id AS coordinator_id_36
FROM
  user t0
  LEFT JOIN trainee t1 ON t0.id = t1.id
  LEFT JOIN coordinator t2 ON t0.id = t2.id
  LEFT JOIN responsible t3 ON t0.id = t3.id
  LEFT JOIN trainer t4 ON t0.id = t4.id
WHERE
  t0.id = ?

SELECT t0.id AS id_5, t0.username AS username_6, t0.last_name AS last_name_7, t0.first_name AS first_name_8, t0.roles AS roles_9, t0.password AS password_10, t0.email AS email_11, t0.activated AS activated_12, t0.tmp_code AS tmp_code_13, t0.tmp_code_date AS tmp_code_date_14, t0.signature AS signature_15, t0.uuid AS uuid_16, t0.phone_number AS phone_number_17, t0.avatar_id AS avatar_id_18, t0.dtype, t1.password_save AS password_save_19, t1.documents AS documents_20, t1.diploma AS diploma_21, t1.tutorial_completed AS tutorial_completed_22, t1.financial_aid AS financial_aid_23, t1.cohort_id AS cohort_id_24, t2.role AS role_25, t2.entrance_code AS entrance_code_26, t2.entrance_code_date AS entrance_code_date_27, t2.responsible_id AS responsible_id_28, t3.role AS role_29, t3.entrance_code AS entrance_code_30, t3.entrance_code_date AS entrance_code_date_31, t3.sector_id AS sector_id_32, t4.role AS role_33, t4.entrance_code AS entrance_code_34, t4.entrance_code_date AS entrance_code_date_35, t4.coordinator_id AS coordinator_id_36 FROM user t0 LEFT JOIN trainee t1 ON t0.id = t1.id LEFT JOIN coordinator t2 ON t0.id = t2.id LEFT JOIN responsible t3 ON t0.id = t3.id LEFT JOIN trainer t4 ON t0.id = t4.id WHERE t0.id = 23;

SELECT
  t0.id AS id_1,
  t0.category AS category_2,
  t0.registry_number AS registry_number_3,
  t0.job AS job_4,
  t0.qualification AS qualification_5,
  t0.contract_label AS contract_label_6,
  t0.nationality AS nationality_7,
  t0.birth_date AS birth_date_8,
  t0.sex AS sex_9,
  t0.hired_at AS hired_at_10,
  t0.left_at AS left_at_11,
  t0.notes AS notes_12,
  t0.created_at AS created_at_13,
  t0.user_id AS user_id_14
FROM
  collaborator t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.category AS category_2, t0.registry_number AS registry_number_3, t0.job AS job_4, t0.qualification AS qualification_5, t0.contract_label AS contract_label_6, t0.nationality AS nationality_7, t0.birth_date AS birth_date_8, t0.sex AS sex_9, t0.hired_at AS hired_at_10, t0.left_at AS left_at_11, t0.notes AS notes_12, t0.created_at AS created_at_13, t0.user_id AS user_id_14 FROM collaborator t0 WHERE t0.user_id = 23;

SELECT
  t0.id AS id_5,
  t0.username AS username_6,
  t0.last_name AS last_name_7,
  t0.first_name AS first_name_8,
  t0.roles AS roles_9,
  t0.password AS password_10,
  t0.email AS email_11,
  t0.activated AS activated_12,
  t0.tmp_code AS tmp_code_13,
  t0.tmp_code_date AS tmp_code_date_14,
  t0.signature AS signature_15,
  t0.uuid AS uuid_16,
  t0.phone_number AS phone_number_17,
  t0.avatar_id AS avatar_id_18,
  t0.dtype,
  t1.password_save AS password_save_19,
  t1.documents AS documents_20,
  t1.diploma AS diploma_21,
  t1.tutorial_completed AS tutorial_completed_22,
  t1.financial_aid AS financial_aid_23,
  t1.cohort_id AS cohort_id_24,
  t2.role AS role_25,
  t2.entrance_code AS entrance_code_26,
  t2.entrance_code_date AS entrance_code_date_27,
  t2.responsible_id AS responsible_id_28,
  t3.role AS role_29,
  t3.entrance_code AS entrance_code_30,
  t3.entrance_code_date AS entrance_code_date_31,
  t3.sector_id AS sector_id_32,
  t4.role AS role_33,
  t4.entrance_code AS entrance_code_34,
  t4.entrance_code_date AS entrance_code_date_35,
  t4.coordinator_id AS coordinator_id_36
FROM
  user t0
  LEFT JOIN trainee t1 ON t0.id = t1.id
  LEFT JOIN coordinator t2 ON t0.id = t2.id
  LEFT JOIN responsible t3 ON t0.id = t3.id
  LEFT JOIN trainer t4 ON t0.id = t4.id
WHERE
  t0.id = ?

SELECT t0.id AS id_5, t0.username AS username_6, t0.last_name AS last_name_7, t0.first_name AS first_name_8, t0.roles AS roles_9, t0.password AS password_10, t0.email AS email_11, t0.activated AS activated_12, t0.tmp_code AS tmp_code_13, t0.tmp_code_date AS tmp_code_date_14, t0.signature AS signature_15, t0.uuid AS uuid_16, t0.phone_number AS phone_number_17, t0.avatar_id AS avatar_id_18, t0.dtype, t1.password_save AS password_save_19, t1.documents AS documents_20, t1.diploma AS diploma_21, t1.tutorial_completed AS tutorial_completed_22, t1.financial_aid AS financial_aid_23, t1.cohort_id AS cohort_id_24, t2.role AS role_25, t2.entrance_code AS entrance_code_26, t2.entrance_code_date AS entrance_code_date_27, t2.responsible_id AS responsible_id_28, t3.role AS role_29, t3.entrance_code AS entrance_code_30, t3.entrance_code_date AS entrance_code_date_31, t3.sector_id AS sector_id_32, t4.role AS role_33, t4.entrance_code AS entrance_code_34, t4.entrance_code_date AS entrance_code_date_35, t4.coordinator_id AS coordinator_id_36 FROM user t0 LEFT JOIN trainee t1 ON t0.id = t1.id LEFT JOIN coordinator t2 ON t0.id = t2.id LEFT JOIN responsible t3 ON t0.id = t3.id LEFT JOIN trainer t4 ON t0.id = t4.id WHERE t0.id = 24;

SELECT
  t0.id AS id_1,
  t0.category AS category_2,
  t0.registry_number AS registry_number_3,
  t0.job AS job_4,
  t0.qualification AS qualification_5,
  t0.contract_label AS contract_label_6,
  t0.nationality AS nationality_7,
  t0.birth_date AS birth_date_8,
  t0.sex AS sex_9,
  t0.hired_at AS hired_at_10,
  t0.left_at AS left_at_11,
  t0.notes AS notes_12,
  t0.created_at AS created_at_13,
  t0.user_id AS user_id_14
FROM
  collaborator t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.category AS category_2, t0.registry_number AS registry_number_3, t0.job AS job_4, t0.qualification AS qualification_5, t0.contract_label AS contract_label_6, t0.nationality AS nationality_7, t0.birth_date AS birth_date_8, t0.sex AS sex_9, t0.hired_at AS hired_at_10, t0.left_at AS left_at_11, t0.notes AS notes_12, t0.created_at AS created_at_13, t0.user_id AS user_id_14 FROM collaborator t0 WHERE t0.user_id = 24;

SELECT
  t0.id AS id_1,
  t0.origin AS origin_2,
  t0.message AS message_3,
  t0.link AS link_4,
  t0.date AS date_5,
  t0.category AS category_6,
  t0.user_id AS user_id_7
FROM
  notification t0
WHERE
  t0.category = ?
  AND t0.user_id IS NULL
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category = 'homework_to_do' AND t0.user_id IS NULL ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.origin AS origin_2,
  t0.message AS message_3,
  t0.link AS link_4,
  t0.date AS date_5,
  t0.category AS category_6,
  t0.user_id AS user_id_7
FROM
  notification t0
WHERE
  t0.category = ?
  AND t0.user_id IS NULL
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category = 'new_message' AND t0.user_id IS NULL ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.origin AS origin_2,
  t0.message AS message_3,
  t0.link AS link_4,
  t0.date AS date_5,
  t0.category AS category_6,
  t0.user_id AS user_id_7
FROM
  notification t0
WHERE
  t0.category IN (?, ?, ?)
  AND t0.user_id IS NULL
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category IN ('internship_approval', 'internship_to_seal', 'internship_rejected') AND t0.user_id IS NULL ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.origin AS origin_2,
  t0.message AS message_3,
  t0.link AS link_4,
  t0.date AS date_5,
  t0.category AS category_6,
  t0.user_id AS user_id_7
FROM
  notification t0
WHERE
  t0.category = ?
  AND t0.user_id IS NULL
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category = 'new_document' AND t0.user_id IS NULL ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.origin AS origin_2,
  t0.message AS message_3,
  t0.link AS link_4,
  t0.date AS date_5,
  t0.category AS category_6,
  t0.user_id AS user_id_7
FROM
  notification t0
WHERE
  t0.category IN (?, ?, ?)
  AND t0.user_id IS NULL
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category IN ('planning_added', 'planning_updated', 'planning_removed') AND t0.user_id IS NULL ORDER BY t0.date DESC;