Symfony Profiler

[
  "route" => "app_notifications_sync"
  "route_parameters" => [
    "_route" => "app_notifications_sync"
    "_controller" => "App\Controller\NotificationController::sync"
  ]
  "request_uri" => "https://obrahoje.com.br/notificacoes/sync"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "u660091116_ObraHoje"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "u660091116_ObraHoje"
    "serverVersion" => "10.11.10-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#724
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "gestor@gestor.com"
]

[
  "sql" => "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"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#724
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 2
    2 => "2026-05-11 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#724
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#903
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 2
    2 => "2026-05-11 00:00:00"
    3 => "2026-05-14 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#724
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#903
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#903}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#724
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]