Symfony Profiler

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;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.contract_start AS contract_start_4,
  t0.contract_end AS contract_end_5,
  t0.os_start AS os_start_6,
  t0.os_end AS os_end_7,
  t0.contract_number AS contract_number_8,
  t0.total_value AS total_value_9,
  t0.initial_value AS initial_value_10,
  t0.is_reform AS is_reform_11,
  t0.photo_path AS photo_path_12,
  t0.status AS status_13,
  t0.concluded_at AS concluded_at_14,
  t0.created_at AS created_at_15,
  t0.responsible_fiscal_id AS responsible_fiscal_id_16
FROM
  obras t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.contract_start AS contract_start_4, t0.contract_end AS contract_end_5, t0.os_start AS os_start_6, t0.os_end AS os_end_7, t0.contract_number AS contract_number_8, t0.total_value AS total_value_9, t0.initial_value AS initial_value_10, t0.is_reform AS is_reform_11, t0.photo_path AS photo_path_12, t0.status AS status_13, t0.concluded_at AS concluded_at_14, t0.created_at AS created_at_15, t0.responsible_fiscal_id AS responsible_fiscal_id_16 FROM obras t0 WHERE t0.id = '1';

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  relatorios r0_
WHERE
  r0_.obra_id = ?

SELECT COUNT(r0_.id) AS sclr_0 FROM relatorios r0_ WHERE r0_.obra_id = 1;

SELECT
  r0_.id AS id_0,
  r0_.title AS title_1,
  r0_.description AS description_2,
  r0_.visit_date AS visit_date_3,
  r0_.photos AS photos_4,
  r0_.is_conclusion AS is_conclusion_5,
  r0_.is_aditivo AS is_aditivo_6,
  r0_.aditivo_contract_days AS aditivo_contract_days_7,
  r0_.aditivo_os_days AS aditivo_os_days_8,
  r0_.aditivo_value AS aditivo_value_9,
  r0_.is_supressao AS is_supressao_10,
  r0_.supressao_value AS supressao_value_11,
  r0_.glosa_value AS glosa_value_12,
  r0_.medicao_value AS medicao_value_13,
  r0_.previous_contract_end AS previous_contract_end_14,
  r0_.previous_os_end AS previous_os_end_15,
  r0_.previous_total_value AS previous_total_value_16,
  r0_.created_at AS created_at_17,
  u1_.id AS id_18,
  u1_.email AS email_19,
  u1_.roles AS roles_20,
  u1_.password AS password_21,
  u1_.name AS name_22,
  u1_.created_at AS created_at_23,
  r0_.obra_id AS obra_id_24,
  r0_.created_by_id AS created_by_id_25
FROM
  relatorios r0_
  LEFT JOIN users u1_ ON r0_.created_by_id = u1_.id
WHERE
  r0_.obra_id = ?
ORDER BY
  r0_.visit_date DESC,
  r0_.created_at DESC
LIMIT
  10

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.description AS description_2, r0_.visit_date AS visit_date_3, r0_.photos AS photos_4, r0_.is_conclusion AS is_conclusion_5, r0_.is_aditivo AS is_aditivo_6, r0_.aditivo_contract_days AS aditivo_contract_days_7, r0_.aditivo_os_days AS aditivo_os_days_8, r0_.aditivo_value AS aditivo_value_9, r0_.is_supressao AS is_supressao_10, r0_.supressao_value AS supressao_value_11, r0_.glosa_value AS glosa_value_12, r0_.medicao_value AS medicao_value_13, r0_.previous_contract_end AS previous_contract_end_14, r0_.previous_os_end AS previous_os_end_15, r0_.previous_total_value AS previous_total_value_16, r0_.created_at AS created_at_17, u1_.id AS id_18, u1_.email AS email_19, u1_.roles AS roles_20, u1_.password AS password_21, u1_.name AS name_22, u1_.created_at AS created_at_23, r0_.obra_id AS obra_id_24, r0_.created_by_id AS created_by_id_25 FROM relatorios r0_ LEFT JOIN users u1_ ON r0_.created_by_id = u1_.id WHERE r0_.obra_id = 1 ORDER BY r0_.visit_date DESC, r0_.created_at DESC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.visit_date AS visit_date_4,
  t0.photos AS photos_5,
  t0.is_conclusion AS is_conclusion_6,
  t0.is_aditivo AS is_aditivo_7,
  t0.aditivo_contract_days AS aditivo_contract_days_8,
  t0.aditivo_os_days AS aditivo_os_days_9,
  t0.aditivo_value AS aditivo_value_10,
  t0.is_supressao AS is_supressao_11,
  t0.supressao_value AS supressao_value_12,
  t0.glosa_value AS glosa_value_13,
  t0.medicao_value AS medicao_value_14,
  t0.previous_contract_end AS previous_contract_end_15,
  t0.previous_os_end AS previous_os_end_16,
  t0.previous_total_value AS previous_total_value_17,
  t0.created_at AS created_at_18,
  t0.obra_id AS obra_id_19,
  t0.created_by_id AS created_by_id_20
FROM
  relatorios t0
WHERE
  t0.obra_id = ?
ORDER BY
  t0.visit_date DESC,
  t0.created_at DESC

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.visit_date AS visit_date_4, t0.photos AS photos_5, t0.is_conclusion AS is_conclusion_6, t0.is_aditivo AS is_aditivo_7, t0.aditivo_contract_days AS aditivo_contract_days_8, t0.aditivo_os_days AS aditivo_os_days_9, t0.aditivo_value AS aditivo_value_10, t0.is_supressao AS is_supressao_11, t0.supressao_value AS supressao_value_12, t0.glosa_value AS glosa_value_13, t0.medicao_value AS medicao_value_14, t0.previous_contract_end AS previous_contract_end_15, t0.previous_os_end AS previous_os_end_16, t0.previous_total_value AS previous_total_value_17, t0.created_at AS created_at_18, t0.obra_id AS obra_id_19, t0.created_by_id AS created_by_id_20 FROM relatorios t0 WHERE t0.obra_id = 1 ORDER BY t0.visit_date DESC, 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 = ?
  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_.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_.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_.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 = 1;