Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.password AS password_2,
  u0_.first_name AS first_name_3,
  u0_.last_name AS last_name_4,
  u0_.date_of_birth AS date_of_birth_5,
  u0_.is_active AS is_active_6,
  u0_.confirmation_token AS confirmation_token_7,
  u0_.password_reset_token AS password_reset_token_8,
  u0_.last_login_at AS last_login_at_9,
  u0_.phone_number AS phone_number_10,
  u0_.fonction AS fonction_11,
  u0_.sex AS sex_12,
  u0_.avatar AS avatar_13,
  u0_.created_at AS created_at_14,
  u0_.updated_at AS updated_at_15,
  u0_.deleted_at AS deleted_at_16,
  u0_.id AS id_17,
  u0_.email AS email_18,
  u0_.password AS password_19,
  u0_.first_name AS first_name_20,
  u0_.last_name AS last_name_21,
  u0_.date_of_birth AS date_of_birth_22,
  u0_.is_active AS is_active_23,
  u0_.confirmation_token AS confirmation_token_24,
  u0_.password_reset_token AS password_reset_token_25,
  u0_.last_login_at AS last_login_at_26,
  u0_.phone_number AS phone_number_27,
  u0_.fonction AS fonction_28,
  u0_.sex AS sex_29,
  u0_.avatar AS avatar_30,
  u0_.created_at AS created_at_31,
  u0_.updated_at AS updated_at_32,
  u0_.deleted_at AS deleted_at_33,
  r1_.id AS id_34,
  r1_.code AS code_35,
  r1_.name AS name_36,
  r1_.description AS description_37,
  r1_.is_default AS is_default_38,
  r1_.created_at AS created_at_39,
  r1_.updated_at AS updated_at_40,
  r1_.deleted_at AS deleted_at_41,
  p2_.id AS id_42,
  p2_.code AS code_43,
  p2_.name AS name_44,
  p2_.description AS description_45,
  p2_.created_at AS created_at_46,
  p2_.updated_at AS updated_at_47,
  p2_.deleted_at AS deleted_at_48,
  u0_.user_preference_id AS user_preference_id_49,
  u0_.department_id AS department_id_50,
  u0_.organization_id AS organization_id_51,
  r1_.department_id AS department_id_52,
  r1_.organization_id AS organization_id_53,
  p2_.permission_group_id AS permission_group_id_54
FROM
  user u0_
  LEFT JOIN user_role u3_ ON u0_.id = u3_.user_id
  LEFT JOIN role r1_ ON r1_.id = u3_.role_id
  AND (r1_.deleted_at IS NULL)
  LEFT JOIN role_permission r4_ ON r1_.id = r4_.role_id
  LEFT JOIN permission p2_ ON p2_.id = r4_.permission_id
  AND (p2_.deleted_at IS NULL)
WHERE
  (u0_.id = ?)
  AND (u0_.deleted_at IS NULL)

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.date_of_birth AS date_of_birth_5, u0_.is_active AS is_active_6, u0_.confirmation_token AS confirmation_token_7, u0_.password_reset_token AS password_reset_token_8, u0_.last_login_at AS last_login_at_9, u0_.phone_number AS phone_number_10, u0_.fonction AS fonction_11, u0_.sex AS sex_12, u0_.avatar AS avatar_13, u0_.created_at AS created_at_14, u0_.updated_at AS updated_at_15, u0_.deleted_at AS deleted_at_16, u0_.id AS id_17, u0_.email AS email_18, u0_.password AS password_19, u0_.first_name AS first_name_20, u0_.last_name AS last_name_21, u0_.date_of_birth AS date_of_birth_22, u0_.is_active AS is_active_23, u0_.confirmation_token AS confirmation_token_24, u0_.password_reset_token AS password_reset_token_25, u0_.last_login_at AS last_login_at_26, u0_.phone_number AS phone_number_27, u0_.fonction AS fonction_28, u0_.sex AS sex_29, u0_.avatar AS avatar_30, u0_.created_at AS created_at_31, u0_.updated_at AS updated_at_32, u0_.deleted_at AS deleted_at_33, r1_.id AS id_34, r1_.code AS code_35, r1_.name AS name_36, r1_.description AS description_37, r1_.is_default AS is_default_38, r1_.created_at AS created_at_39, r1_.updated_at AS updated_at_40, r1_.deleted_at AS deleted_at_41, p2_.id AS id_42, p2_.code AS code_43, p2_.name AS name_44, p2_.description AS description_45, p2_.created_at AS created_at_46, p2_.updated_at AS updated_at_47, p2_.deleted_at AS deleted_at_48, u0_.user_preference_id AS user_preference_id_49, u0_.department_id AS department_id_50, u0_.organization_id AS organization_id_51, r1_.department_id AS department_id_52, r1_.organization_id AS organization_id_53, p2_.permission_group_id AS permission_group_id_54 FROM user u0_ LEFT JOIN user_role u3_ ON u0_.id = u3_.user_id LEFT JOIN role r1_ ON r1_.id = u3_.role_id AND (r1_.deleted_at IS NULL) LEFT JOIN role_permission r4_ ON r1_.id = r4_.role_id LEFT JOIN permission p2_ ON p2_.id = r4_.permission_id AND (p2_.deleted_at IS NULL) WHERE (u0_.id = 1) AND (u0_.deleted_at IS NULL);

SELECT
  u0_.id AS id_0,
  u0_.assignment_type AS assignment_type_1,
  u0_.created_at AS created_at_2,
  u0_.updated_at AS updated_at_3,
  u0_.deleted_at AS deleted_at_4,
  p1_.id AS id_5,
  p1_.name AS name_6,
  p1_.description AS description_7,
  p1_.acronym AS acronym_8,
  p1_.type AS type_9,
  p1_.status AS status_10,
  p1_.start_date AS start_date_11,
  p1_.end_date AS end_date_12,
  p1_.progress AS progress_13,
  p1_.currency AS currency_14,
  p1_.created_at AS created_at_15,
  p1_.updated_at AS updated_at_16,
  p1_.deleted_at AS deleted_at_17,
  c2_.id AS id_18,
  c2_.name AS name_19,
  c2_.acronym AS acronym_20,
  c2_.weighting AS weighting_21,
  c2_.duration AS duration_22,
  c2_.status AS status_23,
  c2_.description AS description_24,
  c2_.budget AS budget_25,
  c2_.start_date AS start_date_26,
  c2_.end_date AS end_date_27,
  c2_.progress AS progress_28,
  c2_.remaining_duration AS remaining_duration_29,
  c2_.created_at AS created_at_30,
  c2_.updated_at AS updated_at_31,
  c2_.deleted_at AS deleted_at_32,
  a3_.id AS id_33,
  a3_.name AS name_34,
  a3_.acronym AS acronym_35,
  a3_.weighting AS weighting_36,
  a3_.status AS status_37,
  a3_.budget AS budget_38,
  a3_.description AS description_39,
  a3_.lft AS lft_40,
  a3_.lvl AS lvl_41,
  a3_.rgt AS rgt_42,
  a3_.duration AS duration_43,
  a3_.start_date AS start_date_44,
  a3_.end_date AS end_date_45,
  a3_.progress AS progress_46,
  a3_.remaining_duration AS remaining_duration_47,
  a3_.absolute_weight AS absolute_weight_48,
  a3_.created_at AS created_at_49,
  a3_.updated_at AS updated_at_50,
  a3_.deleted_at AS deleted_at_51,
  u0_.user_id AS user_id_52,
  u0_.project_id AS project_id_53,
  u0_.component_id AS component_id_54,
  u0_.activity_id AS activity_id_55,
  u0_.reported_problem_id AS reported_problem_id_56,
  p1_.department_id AS department_id_57,
  p1_.program_id AS program_id_58,
  c2_.project_id AS project_id_59,
  a3_.component_id AS component_id_60,
  a3_.tree_root AS tree_root_61,
  a3_.parent_id AS parent_id_62
FROM
  user_assignment u0_
  LEFT JOIN project p1_ ON u0_.project_id = p1_.id
  AND (p1_.deleted_at IS NULL)
  LEFT JOIN component c2_ ON u0_.component_id = c2_.id
  AND (c2_.deleted_at IS NULL)
  LEFT JOIN activity a3_ ON u0_.activity_id = a3_.id
  AND (a3_.deleted_at IS NULL)
WHERE
  (
    u0_.assignment_type = ?
    AND u0_.user_id = ?
  )
  AND (u0_.deleted_at IS NULL)

SELECT u0_.id AS id_0, u0_.assignment_type AS assignment_type_1, u0_.created_at AS created_at_2, u0_.updated_at AS updated_at_3, u0_.deleted_at AS deleted_at_4, p1_.id AS id_5, p1_.name AS name_6, p1_.description AS description_7, p1_.acronym AS acronym_8, p1_.type AS type_9, p1_.status AS status_10, p1_.start_date AS start_date_11, p1_.end_date AS end_date_12, p1_.progress AS progress_13, p1_.currency AS currency_14, p1_.created_at AS created_at_15, p1_.updated_at AS updated_at_16, p1_.deleted_at AS deleted_at_17, c2_.id AS id_18, c2_.name AS name_19, c2_.acronym AS acronym_20, c2_.weighting AS weighting_21, c2_.duration AS duration_22, c2_.status AS status_23, c2_.description AS description_24, c2_.budget AS budget_25, c2_.start_date AS start_date_26, c2_.end_date AS end_date_27, c2_.progress AS progress_28, c2_.remaining_duration AS remaining_duration_29, c2_.created_at AS created_at_30, c2_.updated_at AS updated_at_31, c2_.deleted_at AS deleted_at_32, a3_.id AS id_33, a3_.name AS name_34, a3_.acronym AS acronym_35, a3_.weighting AS weighting_36, a3_.status AS status_37, a3_.budget AS budget_38, a3_.description AS description_39, a3_.lft AS lft_40, a3_.lvl AS lvl_41, a3_.rgt AS rgt_42, a3_.duration AS duration_43, a3_.start_date AS start_date_44, a3_.end_date AS end_date_45, a3_.progress AS progress_46, a3_.remaining_duration AS remaining_duration_47, a3_.absolute_weight AS absolute_weight_48, a3_.created_at AS created_at_49, a3_.updated_at AS updated_at_50, a3_.deleted_at AS deleted_at_51, u0_.user_id AS user_id_52, u0_.project_id AS project_id_53, u0_.component_id AS component_id_54, u0_.activity_id AS activity_id_55, u0_.reported_problem_id AS reported_problem_id_56, p1_.department_id AS department_id_57, p1_.program_id AS program_id_58, c2_.project_id AS project_id_59, a3_.component_id AS component_id_60, a3_.tree_root AS tree_root_61, a3_.parent_id AS parent_id_62 FROM user_assignment u0_ LEFT JOIN project p1_ ON u0_.project_id = p1_.id AND (p1_.deleted_at IS NULL) LEFT JOIN component c2_ ON u0_.component_id = c2_.id AND (c2_.deleted_at IS NULL) LEFT JOIN activity a3_ ON u0_.activity_id = a3_.id AND (a3_.deleted_at IS NULL) WHERE (u0_.assignment_type = 'WISHLIST' AND u0_.user_id = 1) AND (u0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.reference_date AS reference_date_2,
  t0.date_justification AS date_justification_3,
  t0.finished AS finished_4,
  t0.actual_step AS actual_step_5,
  t0.finished_at AS finished_at_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.project_id AS project_id_9
FROM
  follow_up_initialization t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.reference_date AS reference_date_2, t0.date_justification AS date_justification_3, t0.finished AS finished_4, t0.actual_step AS actual_step_5, t0.finished_at AS finished_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.project_id AS project_id_9 FROM follow_up_initialization t0 WHERE t0.project_id = 1;

SELECT
  t0.id AS id_1,
  t0.assignment_type AS assignment_type_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.deleted_at AS deleted_at_5,
  t0.user_id AS user_id_6,
  t0.project_id AS project_id_7,
  t0.component_id AS component_id_8,
  t0.activity_id AS activity_id_9,
  t0.reported_problem_id AS reported_problem_id_10
FROM
  user_assignment t0
WHERE
  t0.project_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.assignment_type AS assignment_type_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.user_id AS user_id_6, t0.project_id AS project_id_7, t0.component_id AS component_id_8, t0.activity_id AS activity_id_9, t0.reported_problem_id AS reported_problem_id_10 FROM user_assignment t0 WHERE t0.project_id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.allocated_budget AS allocated_budget_3,
  t0.funding_type AS funding_type_4,
  t0.funding_partner AS funding_partner_5,
  t0.comment AS comment_6,
  t0.identity_number AS identity_number_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.project_id AS project_id_11,
  t0.program_id AS program_id_12
FROM
  budget_line t0
WHERE
  t0.project_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.allocated_budget AS allocated_budget_3, t0.funding_type AS funding_type_4, t0.funding_partner AS funding_partner_5, t0.comment AS comment_6, t0.identity_number AS identity_number_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.project_id AS project_id_11, t0.program_id AS program_id_12 FROM budget_line t0 WHERE t0.project_id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  u0_.id AS id_0,
  u0_.assignment_type AS assignment_type_1,
  u0_.created_at AS created_at_2,
  u0_.updated_at AS updated_at_3,
  u0_.deleted_at AS deleted_at_4,
  p1_.id AS id_5,
  p1_.name AS name_6,
  p1_.description AS description_7,
  p1_.acronym AS acronym_8,
  p1_.type AS type_9,
  p1_.status AS status_10,
  p1_.start_date AS start_date_11,
  p1_.end_date AS end_date_12,
  p1_.progress AS progress_13,
  p1_.currency AS currency_14,
  p1_.created_at AS created_at_15,
  p1_.updated_at AS updated_at_16,
  p1_.deleted_at AS deleted_at_17,
  c2_.id AS id_18,
  c2_.name AS name_19,
  c2_.acronym AS acronym_20,
  c2_.weighting AS weighting_21,
  c2_.duration AS duration_22,
  c2_.status AS status_23,
  c2_.description AS description_24,
  c2_.budget AS budget_25,
  c2_.start_date AS start_date_26,
  c2_.end_date AS end_date_27,
  c2_.progress AS progress_28,
  c2_.remaining_duration AS remaining_duration_29,
  c2_.created_at AS created_at_30,
  c2_.updated_at AS updated_at_31,
  c2_.deleted_at AS deleted_at_32,
  a3_.id AS id_33,
  a3_.name AS name_34,
  a3_.acronym AS acronym_35,
  a3_.weighting AS weighting_36,
  a3_.status AS status_37,
  a3_.budget AS budget_38,
  a3_.description AS description_39,
  a3_.lft AS lft_40,
  a3_.lvl AS lvl_41,
  a3_.rgt AS rgt_42,
  a3_.duration AS duration_43,
  a3_.start_date AS start_date_44,
  a3_.end_date AS end_date_45,
  a3_.progress AS progress_46,
  a3_.remaining_duration AS remaining_duration_47,
  a3_.absolute_weight AS absolute_weight_48,
  a3_.created_at AS created_at_49,
  a3_.updated_at AS updated_at_50,
  a3_.deleted_at AS deleted_at_51,
  u0_.user_id AS user_id_52,
  u0_.project_id AS project_id_53,
  u0_.component_id AS component_id_54,
  u0_.activity_id AS activity_id_55,
  u0_.reported_problem_id AS reported_problem_id_56,
  p1_.department_id AS department_id_57,
  p1_.program_id AS program_id_58,
  c2_.project_id AS project_id_59,
  a3_.component_id AS component_id_60,
  a3_.tree_root AS tree_root_61,
  a3_.parent_id AS parent_id_62
FROM
  user_assignment u0_
  LEFT JOIN project p1_ ON u0_.project_id = p1_.id
  AND (p1_.deleted_at IS NULL)
  LEFT JOIN component c2_ ON u0_.component_id = c2_.id
  AND (c2_.deleted_at IS NULL)
  LEFT JOIN activity a3_ ON u0_.activity_id = a3_.id
  AND (a3_.deleted_at IS NULL)
WHERE
  (
    u0_.assignment_type = ?
    AND u0_.user_id = ?
  )
  AND (u0_.deleted_at IS NULL)

SELECT u0_.id AS id_0, u0_.assignment_type AS assignment_type_1, u0_.created_at AS created_at_2, u0_.updated_at AS updated_at_3, u0_.deleted_at AS deleted_at_4, p1_.id AS id_5, p1_.name AS name_6, p1_.description AS description_7, p1_.acronym AS acronym_8, p1_.type AS type_9, p1_.status AS status_10, p1_.start_date AS start_date_11, p1_.end_date AS end_date_12, p1_.progress AS progress_13, p1_.currency AS currency_14, p1_.created_at AS created_at_15, p1_.updated_at AS updated_at_16, p1_.deleted_at AS deleted_at_17, c2_.id AS id_18, c2_.name AS name_19, c2_.acronym AS acronym_20, c2_.weighting AS weighting_21, c2_.duration AS duration_22, c2_.status AS status_23, c2_.description AS description_24, c2_.budget AS budget_25, c2_.start_date AS start_date_26, c2_.end_date AS end_date_27, c2_.progress AS progress_28, c2_.remaining_duration AS remaining_duration_29, c2_.created_at AS created_at_30, c2_.updated_at AS updated_at_31, c2_.deleted_at AS deleted_at_32, a3_.id AS id_33, a3_.name AS name_34, a3_.acronym AS acronym_35, a3_.weighting AS weighting_36, a3_.status AS status_37, a3_.budget AS budget_38, a3_.description AS description_39, a3_.lft AS lft_40, a3_.lvl AS lvl_41, a3_.rgt AS rgt_42, a3_.duration AS duration_43, a3_.start_date AS start_date_44, a3_.end_date AS end_date_45, a3_.progress AS progress_46, a3_.remaining_duration AS remaining_duration_47, a3_.absolute_weight AS absolute_weight_48, a3_.created_at AS created_at_49, a3_.updated_at AS updated_at_50, a3_.deleted_at AS deleted_at_51, u0_.user_id AS user_id_52, u0_.project_id AS project_id_53, u0_.component_id AS component_id_54, u0_.activity_id AS activity_id_55, u0_.reported_problem_id AS reported_problem_id_56, p1_.department_id AS department_id_57, p1_.program_id AS program_id_58, c2_.project_id AS project_id_59, a3_.component_id AS component_id_60, a3_.tree_root AS tree_root_61, a3_.parent_id AS parent_id_62 FROM user_assignment u0_ LEFT JOIN project p1_ ON u0_.project_id = p1_.id AND (p1_.deleted_at IS NULL) LEFT JOIN component c2_ ON u0_.component_id = c2_.id AND (c2_.deleted_at IS NULL) LEFT JOIN activity a3_ ON u0_.activity_id = a3_.id AND (a3_.deleted_at IS NULL) WHERE (u0_.assignment_type = 'RESPONSIBLE' AND u0_.user_id = 1) AND (u0_.deleted_at IS NULL);

SELECT
  u0_.id AS id_0,
  u0_.assignment_type AS assignment_type_1,
  u0_.created_at AS created_at_2,
  u0_.updated_at AS updated_at_3,
  u0_.deleted_at AS deleted_at_4,
  p1_.id AS id_5,
  p1_.name AS name_6,
  p1_.description AS description_7,
  p1_.acronym AS acronym_8,
  p1_.type AS type_9,
  p1_.status AS status_10,
  p1_.start_date AS start_date_11,
  p1_.end_date AS end_date_12,
  p1_.progress AS progress_13,
  p1_.currency AS currency_14,
  p1_.created_at AS created_at_15,
  p1_.updated_at AS updated_at_16,
  p1_.deleted_at AS deleted_at_17,
  c2_.id AS id_18,
  c2_.name AS name_19,
  c2_.acronym AS acronym_20,
  c2_.weighting AS weighting_21,
  c2_.duration AS duration_22,
  c2_.status AS status_23,
  c2_.description AS description_24,
  c2_.budget AS budget_25,
  c2_.start_date AS start_date_26,
  c2_.end_date AS end_date_27,
  c2_.progress AS progress_28,
  c2_.remaining_duration AS remaining_duration_29,
  c2_.created_at AS created_at_30,
  c2_.updated_at AS updated_at_31,
  c2_.deleted_at AS deleted_at_32,
  a3_.id AS id_33,
  a3_.name AS name_34,
  a3_.acronym AS acronym_35,
  a3_.weighting AS weighting_36,
  a3_.status AS status_37,
  a3_.budget AS budget_38,
  a3_.description AS description_39,
  a3_.lft AS lft_40,
  a3_.lvl AS lvl_41,
  a3_.rgt AS rgt_42,
  a3_.duration AS duration_43,
  a3_.start_date AS start_date_44,
  a3_.end_date AS end_date_45,
  a3_.progress AS progress_46,
  a3_.remaining_duration AS remaining_duration_47,
  a3_.absolute_weight AS absolute_weight_48,
  a3_.created_at AS created_at_49,
  a3_.updated_at AS updated_at_50,
  a3_.deleted_at AS deleted_at_51,
  u0_.user_id AS user_id_52,
  u0_.project_id AS project_id_53,
  u0_.component_id AS component_id_54,
  u0_.activity_id AS activity_id_55,
  u0_.reported_problem_id AS reported_problem_id_56,
  p1_.department_id AS department_id_57,
  p1_.program_id AS program_id_58,
  c2_.project_id AS project_id_59,
  a3_.component_id AS component_id_60,
  a3_.tree_root AS tree_root_61,
  a3_.parent_id AS parent_id_62
FROM
  user_assignment u0_
  LEFT JOIN project p1_ ON u0_.project_id = p1_.id
  AND (p1_.deleted_at IS NULL)
  LEFT JOIN component c2_ ON u0_.component_id = c2_.id
  AND (c2_.deleted_at IS NULL)
  LEFT JOIN activity a3_ ON u0_.activity_id = a3_.id
  AND (a3_.deleted_at IS NULL)
WHERE
  (
    u0_.assignment_type = ?
    AND u0_.user_id = ?
  )
  AND (u0_.deleted_at IS NULL)

SELECT u0_.id AS id_0, u0_.assignment_type AS assignment_type_1, u0_.created_at AS created_at_2, u0_.updated_at AS updated_at_3, u0_.deleted_at AS deleted_at_4, p1_.id AS id_5, p1_.name AS name_6, p1_.description AS description_7, p1_.acronym AS acronym_8, p1_.type AS type_9, p1_.status AS status_10, p1_.start_date AS start_date_11, p1_.end_date AS end_date_12, p1_.progress AS progress_13, p1_.currency AS currency_14, p1_.created_at AS created_at_15, p1_.updated_at AS updated_at_16, p1_.deleted_at AS deleted_at_17, c2_.id AS id_18, c2_.name AS name_19, c2_.acronym AS acronym_20, c2_.weighting AS weighting_21, c2_.duration AS duration_22, c2_.status AS status_23, c2_.description AS description_24, c2_.budget AS budget_25, c2_.start_date AS start_date_26, c2_.end_date AS end_date_27, c2_.progress AS progress_28, c2_.remaining_duration AS remaining_duration_29, c2_.created_at AS created_at_30, c2_.updated_at AS updated_at_31, c2_.deleted_at AS deleted_at_32, a3_.id AS id_33, a3_.name AS name_34, a3_.acronym AS acronym_35, a3_.weighting AS weighting_36, a3_.status AS status_37, a3_.budget AS budget_38, a3_.description AS description_39, a3_.lft AS lft_40, a3_.lvl AS lvl_41, a3_.rgt AS rgt_42, a3_.duration AS duration_43, a3_.start_date AS start_date_44, a3_.end_date AS end_date_45, a3_.progress AS progress_46, a3_.remaining_duration AS remaining_duration_47, a3_.absolute_weight AS absolute_weight_48, a3_.created_at AS created_at_49, a3_.updated_at AS updated_at_50, a3_.deleted_at AS deleted_at_51, u0_.user_id AS user_id_52, u0_.project_id AS project_id_53, u0_.component_id AS component_id_54, u0_.activity_id AS activity_id_55, u0_.reported_problem_id AS reported_problem_id_56, p1_.department_id AS department_id_57, p1_.program_id AS program_id_58, c2_.project_id AS project_id_59, a3_.component_id AS component_id_60, a3_.tree_root AS tree_root_61, a3_.parent_id AS parent_id_62 FROM user_assignment u0_ LEFT JOIN project p1_ ON u0_.project_id = p1_.id AND (p1_.deleted_at IS NULL) LEFT JOIN component c2_ ON u0_.component_id = c2_.id AND (c2_.deleted_at IS NULL) LEFT JOIN activity a3_ ON u0_.activity_id = a3_.id AND (a3_.deleted_at IS NULL) WHERE (u0_.assignment_type = 'MONITOR' AND u0_.user_id = 1) AND (u0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.message AS message_2,
  t0.is_read AS is_read_3,
  t0.read_at AS read_at_4,
  t0.author AS author_5,
  t0.icon AS icon_6,
  t0.subject_link AS subject_link_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.user_id AS user_id_11,
  t0.project_id AS project_id_12
FROM
  notification t0
WHERE
  t0.user_id = ?
  AND t0.is_read = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.message AS message_2, t0.is_read AS is_read_3, t0.read_at AS read_at_4, t0.author AS author_5, t0.icon AS icon_6, t0.subject_link AS subject_link_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.user_id AS user_id_11, t0.project_id AS project_id_12 FROM notification t0 WHERE t0.user_id = 1 AND t0.is_read = 0 AND ((t0.deleted_at IS NULL)) ORDER BY t0.id DESC;

SELECT
  t0.id AS id_1,
  t0.color_scheme AS color_scheme_2,
  t0.menu_position AS menu_position_3,
  t0.left_sidebar_color AS left_sidebar_color_4,
  t0.left_sidebar_size AS left_sidebar_size_5,
  t0.topbar AS topbar_6,
  t0.width AS width_7,
  t0.completed_tours AS completed_tours_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11
FROM
  user_preference t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.color_scheme AS color_scheme_2, t0.menu_position AS menu_position_3, t0.left_sidebar_color AS left_sidebar_color_4, t0.left_sidebar_size AS left_sidebar_size_5, t0.topbar AS topbar_6, t0.width AS width_7, t0.completed_tours AS completed_tours_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11 FROM user_preference t0 WHERE t0.id = 18 AND ((t0.deleted_at IS NULL));