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
  t0.id AS id_1,
  t0.name AS name_2,
  t0.acronym AS acronym_3,
  t0.weighting AS weighting_4,
  t0.status AS status_5,
  t0.budget AS budget_6,
  t0.description AS description_7,
  t0.lft AS lft_8,
  t0.lvl AS lvl_9,
  t0.rgt AS rgt_10,
  t0.duration AS duration_11,
  t0.start_date AS start_date_12,
  t0.end_date AS end_date_13,
  t0.progress AS progress_14,
  t0.remaining_duration AS remaining_duration_15,
  t0.absolute_weight AS absolute_weight_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t0.component_id AS component_id_20,
  t0.tree_root AS tree_root_21,
  t0.parent_id AS parent_id_22
FROM
  activity t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.weighting AS weighting_4, t0.status AS status_5, t0.budget AS budget_6, t0.description AS description_7, t0.lft AS lft_8, t0.lvl AS lvl_9, t0.rgt AS rgt_10, t0.duration AS duration_11, t0.start_date AS start_date_12, t0.end_date AS end_date_13, t0.progress AS progress_14, t0.remaining_duration AS remaining_duration_15, t0.absolute_weight AS absolute_weight_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.component_id AS component_id_20, t0.tree_root AS tree_root_21, t0.parent_id AS parent_id_22 FROM activity t0 WHERE t0.id = '71' AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.acronym AS acronym_3,
  t0.weighting AS weighting_4,
  t0.duration AS duration_5,
  t0.status AS status_6,
  t0.description AS description_7,
  t0.budget AS budget_8,
  t0.start_date AS start_date_9,
  t0.end_date AS end_date_10,
  t0.progress AS progress_11,
  t0.remaining_duration AS remaining_duration_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.deleted_at AS deleted_at_15,
  t0.project_id AS project_id_16
FROM
  component t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.weighting AS weighting_4, t0.duration AS duration_5, t0.status AS status_6, t0.description AS description_7, t0.budget AS budget_8, t0.start_date AS start_date_9, t0.end_date AS end_date_10, t0.progress AS progress_11, t0.remaining_duration AS remaining_duration_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.project_id AS project_id_16 FROM component t0 WHERE t0.id = 17 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.acronym AS acronym_4,
  t0.type AS type_5,
  t0.status AS status_6,
  t0.start_date AS start_date_7,
  t0.end_date AS end_date_8,
  t0.progress AS progress_9,
  t0.currency AS currency_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t0.department_id AS department_id_14,
  t0.program_id AS program_id_15,
  t16.id AS id_17,
  t16.reference_date AS reference_date_18,
  t16.date_justification AS date_justification_19,
  t16.finished AS finished_20,
  t16.actual_step AS actual_step_21,
  t16.finished_at AS finished_at_22,
  t16.created_at AS created_at_23,
  t16.updated_at AS updated_at_24,
  t16.project_id AS project_id_25
FROM
  project t0
  LEFT JOIN follow_up_initialization t16 ON t16.project_id = t0.id
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.acronym AS acronym_4, t0.type AS type_5, t0.status AS status_6, t0.start_date AS start_date_7, t0.end_date AS end_date_8, t0.progress AS progress_9, t0.currency AS currency_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.department_id AS department_id_14, t0.program_id AS program_id_15, t16.id AS id_17, t16.reference_date AS reference_date_18, t16.date_justification AS date_justification_19, t16.finished AS finished_20, t16.actual_step AS actual_step_21, t16.finished_at AS finished_at_22, t16.created_at AS created_at_23, t16.updated_at AS updated_at_24, t16.project_id AS project_id_25 FROM project t0 LEFT JOIN follow_up_initialization t16 ON t16.project_id = t0.id WHERE t0.id = 15 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.abbreviation AS abbreviation_3,
  t0.lft AS lft_4,
  t0.lvl AS lvl_5,
  t0.rgt AS rgt_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.organization_id AS organization_id_10,
  t0.tree_root AS tree_root_11,
  t0.parent_id AS parent_id_12
FROM
  department t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.lft AS lft_4, t0.lvl AS lvl_5, t0.rgt AS rgt_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.organization_id AS organization_id_10, t0.tree_root AS tree_root_11, t0.parent_id AS parent_id_12 FROM department t0 WHERE t0.id = 19 AND ((t0.deleted_at IS NULL));

SELECT
  SUM(a0_.weighting) AS sclr_0
FROM
  activity a0_
WHERE
  (
    a0_.parent_id IS NULL
    AND a0_.component_id = ?
  )
  AND (a0_.deleted_at IS NULL)

SELECT SUM(a0_.weighting) AS sclr_0 FROM activity a0_ WHERE (a0_.parent_id IS NULL AND a0_.component_id = 17) AND (a0_.deleted_at IS NULL);

SELECT
  SUM(a0_.budget) AS sclr_0
FROM
  activity a0_
WHERE
  (
    a0_.parent_id IS NULL
    AND a0_.component_id = ?
  )
  AND (a0_.deleted_at IS NULL)

SELECT SUM(a0_.budget) AS sclr_0 FROM activity a0_ WHERE (a0_.parent_id IS NULL AND a0_.component_id = 17) AND (a0_.deleted_at IS NULL);

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  activity
SET
  start_date = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE activity SET start_date = '2025-03-01', updated_at = '2026-02-02 14:21:17' WHERE id = 71;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.acronym AS acronym_3,
  t0.weighting AS weighting_4,
  t0.status AS status_5,
  t0.budget AS budget_6,
  t0.description AS description_7,
  t0.lft AS lft_8,
  t0.lvl AS lvl_9,
  t0.rgt AS rgt_10,
  t0.duration AS duration_11,
  t0.start_date AS start_date_12,
  t0.end_date AS end_date_13,
  t0.progress AS progress_14,
  t0.remaining_duration AS remaining_duration_15,
  t0.absolute_weight AS absolute_weight_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t0.component_id AS component_id_20,
  t0.tree_root AS tree_root_21,
  t0.parent_id AS parent_id_22
FROM
  activity t0
WHERE
  t0.parent_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.weighting AS weighting_4, t0.status AS status_5, t0.budget AS budget_6, t0.description AS description_7, t0.lft AS lft_8, t0.lvl AS lvl_9, t0.rgt AS rgt_10, t0.duration AS duration_11, t0.start_date AS start_date_12, t0.end_date AS end_date_13, t0.progress AS progress_14, t0.remaining_duration AS remaining_duration_15, t0.absolute_weight AS absolute_weight_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.component_id AS component_id_20, t0.tree_root AS tree_root_21, t0.parent_id AS parent_id_22 FROM activity t0 WHERE t0.parent_id = 71 AND ((t0.deleted_at IS NULL)) ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.feature_name AS feature_name_2,
  t0.value AS value_3,
  t0.is_enabled AS is_enabled_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.project_id AS project_id_8
FROM
  project_settings t0
WHERE
  t0.project_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.feature_name AS feature_name_2, t0.value AS value_3, t0.is_enabled AS is_enabled_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.project_id AS project_id_8 FROM project_settings t0 WHERE t0.project_id = 15 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.planned_date AS planned_date_2,
  t0.title AS title_3,
  t0.planned_progress AS planned_progress_4,
  t0.actual_date AS actual_date_5,
  t0.actual_progress AS actual_progress_6,
  t0.last_planned_progress AS last_planned_progress_7,
  t0.status AS status_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11,
  t0.activity_id AS activity_id_12
FROM
  milestone t0
WHERE
  t0.activity_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.planned_date AS planned_date_2, t0.title AS title_3, t0.planned_progress AS planned_progress_4, t0.actual_date AS actual_date_5, t0.actual_progress AS actual_progress_6, t0.last_planned_progress AS last_planned_progress_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.activity_id AS activity_id_12 FROM milestone t0 WHERE t0.activity_id = 71 AND ((t0.deleted_at IS NULL));

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

UPDATE
  milestone
SET
  deleted_at = ?
WHERE
  id = ?

UPDATE milestone SET deleted_at = '2026-02-02 14:21:17' WHERE id = 330;

UPDATE
  milestone
SET
  deleted_at = ?
WHERE
  id = ?

UPDATE milestone SET deleted_at = '2026-02-02 14:21:17' WHERE id = 331;

UPDATE
  milestone
SET
  deleted_at = ?
WHERE
  id = ?

UPDATE milestone SET deleted_at = '2026-02-02 14:21:17' WHERE id = 332;

UPDATE
  milestone
SET
  deleted_at = ?
WHERE
  id = ?

UPDATE milestone SET deleted_at = '2026-02-02 14:21:17' WHERE id = 333;

UPDATE
  milestone
SET
  deleted_at = ?
WHERE
  id = ?

UPDATE milestone SET deleted_at = '2026-02-02 14:21:17' WHERE id = 334;

UPDATE
  milestone
SET
  deleted_at = ?
WHERE
  id = ?

UPDATE milestone SET deleted_at = '2026-02-02 14:21:17' WHERE id = 335;

UPDATE
  milestone
SET
  deleted_at = ?
WHERE
  id = ?

UPDATE milestone SET deleted_at = '2026-02-02 14:21:17' WHERE id = 336;

UPDATE
  milestone
SET
  deleted_at = ?
WHERE
  id = ?

UPDATE milestone SET deleted_at = '2026-02-02 14:21:17' WHERE id = 337;

UPDATE
  milestone
SET
  deleted_at = ?
WHERE
  id = ?

UPDATE milestone SET deleted_at = '2026-02-02 14:21:17' WHERE id = 338;

UPDATE
  milestone
SET
  deleted_at = ?
WHERE
  id = ?

UPDATE milestone SET deleted_at = '2026-02-02 14:21:17' WHERE id = 339;

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;