Symfony Profiler

[
  "route" => "api_project_board"
  "route_parameters" => [
    "_route" => "api_project_board"
    "_format" => "json"
    "_controller" => "App\Feature\UI\Http\BoardController"
    "id" => "01a0bf6e-7534-7811-95ba-5a03539ef3c8"
  ]
  "request_uri" => "https://agent.ws-thiele.de/api/projects/01a0bf6e-7534-7811-95ba-5a03539ef3c8/board"
  "method" => "GET"
]

[
  "firewall_name" => "api"
  "authenticators" => 1
]

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

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

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

[
  "params" => [
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "database"
    "port" => 5432
    "user" => "app"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "18"
    "defaultTableOptions" => []
    "dbname" => "app"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.display_name AS display_name_3, t0.password AS password_4, t0.roles AS roles_5, t0.active AS active_6, t0.last_login_at AS last_login_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM users t0 WHERE t0.id = ?"
  "params" => [
    1 => "01a0bf09-6ed6-700d-8571-9d4f693ac070"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#777
      +name: "STRING"
    }
  ]
]

[
  "provider" => "App\User\Infrastructure\Security\UserProvider"
  "username" => "maik-thiele@gmx.net"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.feature_key_prefix AS feature_key_prefix_5, t0.last_feature_number AS last_feature_number_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.instructions_general AS instructions_general_9, t0.instructions_architecture AS instructions_architecture_10, t0.instructions_coding_standards AS instructions_coding_standards_11, t0.instructions_testing_rules AS instructions_testing_rules_12, t0.instructions_git_rules AS instructions_git_rules_13, t0.instructions_security_rules AS instructions_security_rules_14, t0.instructions_documentation AS instructions_documentation_15, t0.settings_require_human_merge_approval AS settings_require_human_merge_approval_16, t0.settings_prevent_self_review AS settings_prevent_self_review_17 FROM projects t0 WHERE t0.id = ?"
  "params" => [
    1 => "01a0bf6e-7534-7811-95ba-5a03539ef3c8"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#777
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.role AS role_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.project_id AS project_id_5, t0.user_id AS user_id_6 FROM project_members t0 WHERE t0.project_id = ?"
  "params" => [
    1 => "01a0bf6e-7534-7811-95ba-5a03539ef3c8"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#777
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT CASE WHEN f0_.priority = 'CRITICAL' THEN 0 WHEN f0_.priority = 'HIGH' THEN 1 WHEN f0_.priority = 'MEDIUM' THEN 2 ELSE 3 END AS sclr_0, f0_.id AS id_1, f0_.number AS number_2, f0_.title AS title_3, f0_.description AS description_4, f0_.technical_description AS technical_description_5, f0_.acceptance_criteria AS acceptance_criteria_6, f0_.priority AS priority_7, f0_.status AS status_8, f0_.base_branch AS base_branch_9, f0_.feature_branch AS feature_branch_10, f0_.tags AS tags_11, f0_.merge_approved_at AS merge_approved_at_12, f0_.version AS version_13, f0_.created_at AS created_at_14, f0_.updated_at AS updated_at_15, g1_.id AS id_16, g1_.name AS name_17, g1_.provider AS provider_18, g1_.clone_url AS clone_url_19, g1_.default_branch AS default_branch_20, g1_.branch_pattern AS branch_pattern_21, g1_.pull_request_target_branch AS pull_request_target_branch_22, g1_.local_path AS local_path_23, g1_.auto_create_pull_request AS auto_create_pull_request_24, g1_.delete_branch_after_merge AS delete_branch_after_merge_25, g1_.active AS active_26, g1_.created_at AS created_at_27, g1_.updated_at AS updated_at_28, a2_.id AS id_29, a2_.name AS name_30, a2_.type AS type_31, a2_.role AS role_32, a2_.executable AS executable_33, a2_.default_arguments AS default_arguments_34, a2_.max_runtime_seconds AS max_runtime_seconds_35, a2_.enabled AS enabled_36, a2_.created_at AS created_at_37, a2_.updated_at AS updated_at_38, a3_.id AS id_39, a3_.name AS name_40, a3_.type AS type_41, a3_.role AS role_42, a3_.executable AS executable_43, a3_.default_arguments AS default_arguments_44, a3_.max_runtime_seconds AS max_runtime_seconds_45, a3_.enabled AS enabled_46, a3_.created_at AS created_at_47, a3_.updated_at AS updated_at_48, u4_.id AS id_49, u4_.email AS email_50, u4_.display_name AS display_name_51, u4_.password AS password_52, u4_.roles AS roles_53, u4_.active AS active_54, u4_.last_login_at AS last_login_at_55, u4_.created_at AS created_at_56, u4_.updated_at AS updated_at_57, f0_.project_id AS project_id_58, f0_.repository_id AS repository_id_59, f0_.implementation_agent_id AS implementation_agent_id_60, f0_.review_agent_id AS review_agent_id_61, f0_.assignee_id AS assignee_id_62, f0_.created_by_id AS created_by_id_63, f0_.merge_approved_by_id AS merge_approved_by_id_64, g1_.project_id AS project_id_65, a2_.project_id AS project_id_66, a2_.preferred_runner_id AS preferred_runner_id_67, a2_.prompt_template_id AS prompt_template_id_68, a3_.project_id AS project_id_69, a3_.preferred_runner_id AS preferred_runner_id_70, a3_.prompt_template_id AS prompt_template_id_71 FROM features f0_ LEFT JOIN git_repositories g1_ ON f0_.repository_id = g1_.id LEFT JOIN agent_profiles a2_ ON f0_.implementation_agent_id = a2_.id LEFT JOIN agent_profiles a3_ ON f0_.review_agent_id = a3_.id LEFT JOIN users u4_ ON f0_.assignee_id = u4_.id WHERE f0_.project_id = ? AND f0_.status NOT IN (?, ?) ORDER BY sclr_0 ASC, f0_.number ASC"
  "params" => [
    1 => "01a0bf6e-7534-7811-95ba-5a03539ef3c8"
    2 => "MERGED"
    3 => "CANCELLED"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#777
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#777}
    3 => Doctrine\DBAL\ParameterType {#777}
  ]
]

[
  "sql" => "SELECT f0_.id AS id_0, f0_.number AS number_1, f0_.title AS title_2, f0_.description AS description_3, f0_.technical_description AS technical_description_4, f0_.acceptance_criteria AS acceptance_criteria_5, f0_.priority AS priority_6, f0_.status AS status_7, f0_.base_branch AS base_branch_8, f0_.feature_branch AS feature_branch_9, f0_.tags AS tags_10, f0_.merge_approved_at AS merge_approved_at_11, f0_.version AS version_12, f0_.created_at AS created_at_13, f0_.updated_at AS updated_at_14, g1_.id AS id_15, g1_.name AS name_16, g1_.provider AS provider_17, g1_.clone_url AS clone_url_18, g1_.default_branch AS default_branch_19, g1_.branch_pattern AS branch_pattern_20, g1_.pull_request_target_branch AS pull_request_target_branch_21, g1_.local_path AS local_path_22, g1_.auto_create_pull_request AS auto_create_pull_request_23, g1_.delete_branch_after_merge AS delete_branch_after_merge_24, g1_.active AS active_25, g1_.created_at AS created_at_26, g1_.updated_at AS updated_at_27, a2_.id AS id_28, a2_.name AS name_29, a2_.type AS type_30, a2_.role AS role_31, a2_.executable AS executable_32, a2_.default_arguments AS default_arguments_33, a2_.max_runtime_seconds AS max_runtime_seconds_34, a2_.enabled AS enabled_35, a2_.created_at AS created_at_36, a2_.updated_at AS updated_at_37, a3_.id AS id_38, a3_.name AS name_39, a3_.type AS type_40, a3_.role AS role_41, a3_.executable AS executable_42, a3_.default_arguments AS default_arguments_43, a3_.max_runtime_seconds AS max_runtime_seconds_44, a3_.enabled AS enabled_45, a3_.created_at AS created_at_46, a3_.updated_at AS updated_at_47, u4_.id AS id_48, u4_.email AS email_49, u4_.display_name AS display_name_50, u4_.password AS password_51, u4_.roles AS roles_52, u4_.active AS active_53, u4_.last_login_at AS last_login_at_54, u4_.created_at AS created_at_55, u4_.updated_at AS updated_at_56, f0_.project_id AS project_id_57, f0_.repository_id AS repository_id_58, f0_.implementation_agent_id AS implementation_agent_id_59, f0_.review_agent_id AS review_agent_id_60, f0_.assignee_id AS assignee_id_61, f0_.created_by_id AS created_by_id_62, f0_.merge_approved_by_id AS merge_approved_by_id_63, g1_.project_id AS project_id_64, a2_.project_id AS project_id_65, a2_.preferred_runner_id AS preferred_runner_id_66, a2_.prompt_template_id AS prompt_template_id_67, a3_.project_id AS project_id_68, a3_.preferred_runner_id AS preferred_runner_id_69, a3_.prompt_template_id AS prompt_template_id_70 FROM features f0_ LEFT JOIN git_repositories g1_ ON f0_.repository_id = g1_.id LEFT JOIN agent_profiles a2_ ON f0_.implementation_agent_id = a2_.id LEFT JOIN agent_profiles a3_ ON f0_.review_agent_id = a3_.id LEFT JOIN users u4_ ON f0_.assignee_id = u4_.id WHERE f0_.project_id = ? AND f0_.status IN (?, ?) ORDER BY f0_.updated_at DESC LIMIT 50"
  "params" => [
    1 => "01a0bf6e-7534-7811-95ba-5a03539ef3c8"
    2 => "MERGED"
    3 => "CANCELLED"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#777
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#777}
    3 => Doctrine\DBAL\ParameterType {#777}
  ]
]

[
  "key" => "_security_app"
]