Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.description AS description_2,
  t0_.created_at AS created_at_3,
  t0_.due_at AS due_at_4,
  t0_.due_in_days AS due_in_days_5,
  t0_.accepted_at AS accepted_at_6,
  t0_.color AS color_7,
  t0_.icon AS icon_8,
  t0_.urgency AS urgency_9,
  t0_.is_visit_task AS is_visit_task_10,
  t0_.completed_at AS completed_at_11,
  t0_.extension_requested_at AS extension_requested_at_12,
  t0_.extension_requested_due_at AS extension_requested_due_at_13,
  t0_.extension_reason AS extension_reason_14,
  u1_.id AS id_15,
  u1_.email AS email_16,
  u1_.roles AS roles_17,
  u1_.password AS password_18,
  u1_.name AS name_19,
  u1_.created_at AS created_at_20,
  u2_.id AS id_21,
  u2_.email AS email_22,
  u2_.roles AS roles_23,
  u2_.password AS password_24,
  u2_.name AS name_25,
  u2_.created_at AS created_at_26,
  o3_.id AS id_27,
  o3_.name AS name_28,
  o3_.description AS description_29,
  o3_.contract_start AS contract_start_30,
  o3_.contract_end AS contract_end_31,
  o3_.os_start AS os_start_32,
  o3_.os_end AS os_end_33,
  o3_.contract_number AS contract_number_34,
  o3_.total_value AS total_value_35,
  o3_.initial_value AS initial_value_36,
  o3_.is_reform AS is_reform_37,
  o3_.photo_path AS photo_path_38,
  o3_.status AS status_39,
  o3_.concluded_at AS concluded_at_40,
  o3_.created_at AS created_at_41,
  t0_.created_by_id AS created_by_id_42,
  t0_.assigned_to_id AS assigned_to_id_43,
  t0_.obra_id AS obra_id_44,
  t0_.extension_requested_by_id AS extension_requested_by_id_45,
  o3_.responsible_fiscal_id AS responsible_fiscal_id_46
FROM
  tasks t0_
  LEFT JOIN users u1_ ON t0_.assigned_to_id = u1_.id
  LEFT JOIN users u2_ ON t0_.created_by_id = u2_.id
  LEFT JOIN obras o3_ ON t0_.obra_id = o3_.id
WHERE
  t0_.assigned_to_id = ?
  AND t0_.accepted_at IS NULL
  AND t0_.completed_at IS NULL
  AND t0_.is_visit_task = 0
ORDER BY
  t0_.created_at DESC

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.created_at AS created_at_3, t0_.due_at AS due_at_4, t0_.due_in_days AS due_in_days_5, t0_.accepted_at AS accepted_at_6, t0_.color AS color_7, t0_.icon AS icon_8, t0_.urgency AS urgency_9, t0_.is_visit_task AS is_visit_task_10, t0_.completed_at AS completed_at_11, t0_.extension_requested_at AS extension_requested_at_12, t0_.extension_requested_due_at AS extension_requested_due_at_13, t0_.extension_reason AS extension_reason_14, u1_.id AS id_15, u1_.email AS email_16, u1_.roles AS roles_17, u1_.password AS password_18, u1_.name AS name_19, u1_.created_at AS created_at_20, u2_.id AS id_21, u2_.email AS email_22, u2_.roles AS roles_23, u2_.password AS password_24, u2_.name AS name_25, u2_.created_at AS created_at_26, o3_.id AS id_27, o3_.name AS name_28, o3_.description AS description_29, o3_.contract_start AS contract_start_30, o3_.contract_end AS contract_end_31, o3_.os_start AS os_start_32, o3_.os_end AS os_end_33, o3_.contract_number AS contract_number_34, o3_.total_value AS total_value_35, o3_.initial_value AS initial_value_36, o3_.is_reform AS is_reform_37, o3_.photo_path AS photo_path_38, o3_.status AS status_39, o3_.concluded_at AS concluded_at_40, o3_.created_at AS created_at_41, t0_.created_by_id AS created_by_id_42, t0_.assigned_to_id AS assigned_to_id_43, t0_.obra_id AS obra_id_44, t0_.extension_requested_by_id AS extension_requested_by_id_45, o3_.responsible_fiscal_id AS responsible_fiscal_id_46 FROM tasks t0_ LEFT JOIN users u1_ ON t0_.assigned_to_id = u1_.id LEFT JOIN users u2_ ON t0_.created_by_id = u2_.id LEFT JOIN obras o3_ ON t0_.obra_id = o3_.id WHERE t0_.assigned_to_id = 2 AND t0_.accepted_at IS NULL AND t0_.completed_at IS NULL AND t0_.is_visit_task = 0 ORDER BY t0_.created_at DESC;

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.description AS description_2,
  t0_.created_at AS created_at_3,
  t0_.due_at AS due_at_4,
  t0_.due_in_days AS due_in_days_5,
  t0_.accepted_at AS accepted_at_6,
  t0_.color AS color_7,
  t0_.icon AS icon_8,
  t0_.urgency AS urgency_9,
  t0_.is_visit_task AS is_visit_task_10,
  t0_.completed_at AS completed_at_11,
  t0_.extension_requested_at AS extension_requested_at_12,
  t0_.extension_requested_due_at AS extension_requested_due_at_13,
  t0_.extension_reason AS extension_reason_14,
  u1_.id AS id_15,
  u1_.email AS email_16,
  u1_.roles AS roles_17,
  u1_.password AS password_18,
  u1_.name AS name_19,
  u1_.created_at AS created_at_20,
  o2_.id AS id_21,
  o2_.name AS name_22,
  o2_.description AS description_23,
  o2_.contract_start AS contract_start_24,
  o2_.contract_end AS contract_end_25,
  o2_.os_start AS os_start_26,
  o2_.os_end AS os_end_27,
  o2_.contract_number AS contract_number_28,
  o2_.total_value AS total_value_29,
  o2_.initial_value AS initial_value_30,
  o2_.is_reform AS is_reform_31,
  o2_.photo_path AS photo_path_32,
  o2_.status AS status_33,
  o2_.concluded_at AS concluded_at_34,
  o2_.created_at AS created_at_35,
  t0_.created_by_id AS created_by_id_36,
  t0_.assigned_to_id AS assigned_to_id_37,
  t0_.obra_id AS obra_id_38,
  t0_.extension_requested_by_id AS extension_requested_by_id_39,
  o2_.responsible_fiscal_id AS responsible_fiscal_id_40
FROM
  tasks t0_
  LEFT JOIN users u1_ ON t0_.assigned_to_id = u1_.id
  LEFT JOIN obras o2_ ON t0_.obra_id = o2_.id
WHERE
  t0_.assigned_to_id = ?
  AND t0_.accepted_at IS NOT NULL
  AND t0_.completed_at IS NULL
  AND t0_.due_at IS NOT NULL
  AND t0_.due_at >= ?
  AND t0_.due_at <= ?
  AND t0_.is_visit_task = 0
ORDER BY
  t0_.due_at ASC

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.created_at AS created_at_3, t0_.due_at AS due_at_4, t0_.due_in_days AS due_in_days_5, t0_.accepted_at AS accepted_at_6, t0_.color AS color_7, t0_.icon AS icon_8, t0_.urgency AS urgency_9, t0_.is_visit_task AS is_visit_task_10, t0_.completed_at AS completed_at_11, t0_.extension_requested_at AS extension_requested_at_12, t0_.extension_requested_due_at AS extension_requested_due_at_13, t0_.extension_reason AS extension_reason_14, u1_.id AS id_15, u1_.email AS email_16, u1_.roles AS roles_17, u1_.password AS password_18, u1_.name AS name_19, u1_.created_at AS created_at_20, o2_.id AS id_21, o2_.name AS name_22, o2_.description AS description_23, o2_.contract_start AS contract_start_24, o2_.contract_end AS contract_end_25, o2_.os_start AS os_start_26, o2_.os_end AS os_end_27, o2_.contract_number AS contract_number_28, o2_.total_value AS total_value_29, o2_.initial_value AS initial_value_30, o2_.is_reform AS is_reform_31, o2_.photo_path AS photo_path_32, o2_.status AS status_33, o2_.concluded_at AS concluded_at_34, o2_.created_at AS created_at_35, t0_.created_by_id AS created_by_id_36, t0_.assigned_to_id AS assigned_to_id_37, t0_.obra_id AS obra_id_38, t0_.extension_requested_by_id AS extension_requested_by_id_39, o2_.responsible_fiscal_id AS responsible_fiscal_id_40 FROM tasks t0_ LEFT JOIN users u1_ ON t0_.assigned_to_id = u1_.id LEFT JOIN obras o2_ ON t0_.obra_id = o2_.id WHERE t0_.assigned_to_id = 2 AND t0_.accepted_at IS NOT NULL AND t0_.completed_at IS NULL AND t0_.due_at IS NOT NULL AND t0_.due_at >= '2026-05-11 00:00:00' AND t0_.due_at <= '2026-05-14 00:00:00' AND t0_.is_visit_task = 0 ORDER BY t0_.due_at ASC;

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.description AS description_2,
  t0_.created_at AS created_at_3,
  t0_.due_at AS due_at_4,
  t0_.due_in_days AS due_in_days_5,
  t0_.accepted_at AS accepted_at_6,
  t0_.color AS color_7,
  t0_.icon AS icon_8,
  t0_.urgency AS urgency_9,
  t0_.is_visit_task AS is_visit_task_10,
  t0_.completed_at AS completed_at_11,
  t0_.extension_requested_at AS extension_requested_at_12,
  t0_.extension_requested_due_at AS extension_requested_due_at_13,
  t0_.extension_reason AS extension_reason_14,
  u1_.id AS id_15,
  u1_.email AS email_16,
  u1_.roles AS roles_17,
  u1_.password AS password_18,
  u1_.name AS name_19,
  u1_.created_at AS created_at_20,
  o2_.id AS id_21,
  o2_.name AS name_22,
  o2_.description AS description_23,
  o2_.contract_start AS contract_start_24,
  o2_.contract_end AS contract_end_25,
  o2_.os_start AS os_start_26,
  o2_.os_end AS os_end_27,
  o2_.contract_number AS contract_number_28,
  o2_.total_value AS total_value_29,
  o2_.initial_value AS initial_value_30,
  o2_.is_reform AS is_reform_31,
  o2_.photo_path AS photo_path_32,
  o2_.status AS status_33,
  o2_.concluded_at AS concluded_at_34,
  o2_.created_at AS created_at_35,
  t0_.created_by_id AS created_by_id_36,
  t0_.assigned_to_id AS assigned_to_id_37,
  t0_.obra_id AS obra_id_38,
  t0_.extension_requested_by_id AS extension_requested_by_id_39,
  o2_.responsible_fiscal_id AS responsible_fiscal_id_40
FROM
  tasks t0_
  LEFT JOIN users u1_ ON t0_.assigned_to_id = u1_.id
  LEFT JOIN obras o2_ ON t0_.obra_id = o2_.id
WHERE
  t0_.assigned_to_id = ?
  AND t0_.accepted_at IS NOT NULL
  AND t0_.completed_at IS NULL
  AND t0_.due_at IS NOT NULL
  AND t0_.due_at < ?
  AND t0_.is_visit_task = 0
ORDER BY
  t0_.due_at ASC

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.created_at AS created_at_3, t0_.due_at AS due_at_4, t0_.due_in_days AS due_in_days_5, t0_.accepted_at AS accepted_at_6, t0_.color AS color_7, t0_.icon AS icon_8, t0_.urgency AS urgency_9, t0_.is_visit_task AS is_visit_task_10, t0_.completed_at AS completed_at_11, t0_.extension_requested_at AS extension_requested_at_12, t0_.extension_requested_due_at AS extension_requested_due_at_13, t0_.extension_reason AS extension_reason_14, u1_.id AS id_15, u1_.email AS email_16, u1_.roles AS roles_17, u1_.password AS password_18, u1_.name AS name_19, u1_.created_at AS created_at_20, o2_.id AS id_21, o2_.name AS name_22, o2_.description AS description_23, o2_.contract_start AS contract_start_24, o2_.contract_end AS contract_end_25, o2_.os_start AS os_start_26, o2_.os_end AS os_end_27, o2_.contract_number AS contract_number_28, o2_.total_value AS total_value_29, o2_.initial_value AS initial_value_30, o2_.is_reform AS is_reform_31, o2_.photo_path AS photo_path_32, o2_.status AS status_33, o2_.concluded_at AS concluded_at_34, o2_.created_at AS created_at_35, t0_.created_by_id AS created_by_id_36, t0_.assigned_to_id AS assigned_to_id_37, t0_.obra_id AS obra_id_38, t0_.extension_requested_by_id AS extension_requested_by_id_39, o2_.responsible_fiscal_id AS responsible_fiscal_id_40 FROM tasks t0_ LEFT JOIN users u1_ ON t0_.assigned_to_id = u1_.id LEFT JOIN obras o2_ ON t0_.obra_id = o2_.id WHERE t0_.assigned_to_id = 2 AND t0_.accepted_at IS NOT NULL AND t0_.completed_at IS NULL AND t0_.due_at IS NOT NULL AND t0_.due_at < '2026-05-11 00:00:00' AND t0_.is_visit_task = 0 ORDER BY t0_.due_at ASC;

SELECT
  t0_.id AS id_0,
  t0_.type AS type_1,
  t0_.created_at AS created_at_2,
  t0_.read_at AS read_at_3,
  t1_.id AS id_4,
  t1_.title AS title_5,
  t1_.description AS description_6,
  t1_.created_at AS created_at_7,
  t1_.due_at AS due_at_8,
  t1_.due_in_days AS due_in_days_9,
  t1_.accepted_at AS accepted_at_10,
  t1_.color AS color_11,
  t1_.icon AS icon_12,
  t1_.urgency AS urgency_13,
  t1_.is_visit_task AS is_visit_task_14,
  t1_.completed_at AS completed_at_15,
  t1_.extension_requested_at AS extension_requested_at_16,
  t1_.extension_requested_due_at AS extension_requested_due_at_17,
  t1_.extension_reason AS extension_reason_18,
  u2_.id AS id_19,
  u2_.email AS email_20,
  u2_.roles AS roles_21,
  u2_.password AS password_22,
  u2_.name AS name_23,
  u2_.created_at AS created_at_24,
  t0_.user_id AS user_id_25,
  t0_.task_id AS task_id_26,
  t0_.actor_id AS actor_id_27,
  t1_.created_by_id AS created_by_id_28,
  t1_.assigned_to_id AS assigned_to_id_29,
  t1_.obra_id AS obra_id_30,
  t1_.extension_requested_by_id AS extension_requested_by_id_31
FROM
  task_notifications t0_
  LEFT JOIN tasks t1_ ON t0_.task_id = t1_.id
  LEFT JOIN users u2_ ON t0_.actor_id = u2_.id
WHERE
  t0_.user_id = ?
  AND t0_.read_at IS NULL
ORDER BY
  t0_.created_at DESC
LIMIT
  30

SELECT t0_.id AS id_0, t0_.type AS type_1, t0_.created_at AS created_at_2, t0_.read_at AS read_at_3, t1_.id AS id_4, t1_.title AS title_5, t1_.description AS description_6, t1_.created_at AS created_at_7, t1_.due_at AS due_at_8, t1_.due_in_days AS due_in_days_9, t1_.accepted_at AS accepted_at_10, t1_.color AS color_11, t1_.icon AS icon_12, t1_.urgency AS urgency_13, t1_.is_visit_task AS is_visit_task_14, t1_.completed_at AS completed_at_15, t1_.extension_requested_at AS extension_requested_at_16, t1_.extension_requested_due_at AS extension_requested_due_at_17, t1_.extension_reason AS extension_reason_18, u2_.id AS id_19, u2_.email AS email_20, u2_.roles AS roles_21, u2_.password AS password_22, u2_.name AS name_23, u2_.created_at AS created_at_24, t0_.user_id AS user_id_25, t0_.task_id AS task_id_26, t0_.actor_id AS actor_id_27, t1_.created_by_id AS created_by_id_28, t1_.assigned_to_id AS assigned_to_id_29, t1_.obra_id AS obra_id_30, t1_.extension_requested_by_id AS extension_requested_by_id_31 FROM task_notifications t0_ LEFT JOIN tasks t1_ ON t0_.task_id = t1_.id LEFT JOIN users u2_ ON t0_.actor_id = u2_.id WHERE t0_.user_id = 2 AND t0_.read_at IS NULL ORDER BY t0_.created_at DESC LIMIT 30;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.created_at AS created_at_6
FROM
  users t0
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.name AS name_5, t0.created_at AS created_at_6 FROM users t0 WHERE t0.id = 2;