Query Metrics

5 Database Queries
5 Different statements
112.98 ms Query time
0 Invalid entities
3 Managed entities

Grouped Statements

Show all queries

Time Count Info
101.18 ms
(89.55%)
1
SELECT a0_.id AS id_0, a0_.agent_name_snapshot AS agent_name_snapshot_1, a0_.agent_type_snapshot AS agent_type_snapshot_2, a0_.agent_executable_snapshot AS agent_executable_snapshot_3, a0_.agent_default_arguments_snapshot AS agent_default_arguments_snapshot_4, a0_.agent_max_runtime_seconds_snapshot AS agent_max_runtime_seconds_snapshot_5, a0_.preferred_runner_id_snapshot AS preferred_runner_id_snapshot_6, a0_.type AS type_7, a0_.status AS status_8, a0_.prompt_snapshot AS prompt_snapshot_9, a0_.agents_markdown_snapshot AS agents_markdown_snapshot_10, a0_.claude_markdown_snapshot AS claude_markdown_snapshot_11, a0_.prompt_template_version_id AS prompt_template_version_id_12, a0_.project_instruction_version_id AS project_instruction_version_id_13, a0_.working_directory AS working_directory_14, a0_.branch AS branch_15, a0_.base_commit_hash AS base_commit_hash_16, a0_.commit_hash AS commit_hash_17, a0_.result AS result_18, a0_.error AS error_19, a0_.exit_code AS exit_code_20, a0_.claimed_at AS claimed_at_21, a0_.lease_expires_at AS lease_expires_at_22, a0_.started_at AS started_at_23, a0_.finished_at AS finished_at_24, a0_.cancel_requested_at AS cancel_requested_at_25, a0_.created_at AS created_at_26, a0_.updated_at AS updated_at_27, f1_.id AS id_28, f1_.number AS number_29, f1_.title AS title_30, f1_.description AS description_31, f1_.technical_description AS technical_description_32, f1_.acceptance_criteria AS acceptance_criteria_33, f1_.priority AS priority_34, f1_.status AS status_35, f1_.base_branch AS base_branch_36, f1_.feature_branch AS feature_branch_37, f1_.tags AS tags_38, f1_.merge_approved_at AS merge_approved_at_39, f1_.version AS version_40, f1_.created_at AS created_at_41, f1_.updated_at AS updated_at_42, a2_.id AS id_43, a2_.name AS name_44, a2_.type AS type_45, a2_.role AS role_46, a2_.executable AS executable_47, a2_.default_arguments AS default_arguments_48, a2_.max_runtime_seconds AS max_runtime_seconds_49, a2_.enabled AS enabled_50, a2_.created_at AS created_at_51, a2_.updated_at AS updated_at_52, r3_.id AS id_53, r3_.name AS name_54, r3_.hostname AS hostname_55, r3_.operating_system AS operating_system_56, r3_.architecture AS architecture_57, r3_.runner_version AS runner_version_58, r3_.git_version AS git_version_59, r3_.max_parallel_jobs AS max_parallel_jobs_60, r3_.available_slots AS available_slots_61, r3_.active_jobs AS active_jobs_62, r3_.status AS status_63, r3_.disabled AS disabled_64, r3_.authentication_token_id AS authentication_token_id_65, r3_.authentication_token_hash AS authentication_token_hash_66, r3_.authentication_token_prefix AS authentication_token_prefix_67, r3_.last_heartbeat_at AS last_heartbeat_at_68, r3_.last_authenticated_at AS last_authenticated_at_69, r3_.created_at AS created_at_70, r3_.updated_at AS updated_at_71, a0_.feature_id AS feature_id_72, a0_.agent_profile_id AS agent_profile_id_73, a0_.runner_id AS runner_id_74, f1_.project_id AS project_id_75, f1_.repository_id AS repository_id_76, f1_.implementation_agent_id AS implementation_agent_id_77, f1_.review_agent_id AS review_agent_id_78, f1_.assignee_id AS assignee_id_79, f1_.created_by_id AS created_by_id_80, f1_.merge_approved_by_id AS merge_approved_by_id_81, a2_.project_id AS project_id_82, a2_.preferred_runner_id AS preferred_runner_id_83, a2_.prompt_template_id AS prompt_template_id_84, r3_.project_id AS project_id_85 FROM agent_runs a0_ INNER JOIN features f1_ ON a0_.feature_id = f1_.id LEFT JOIN agent_profiles a2_ ON a0_.agent_profile_id = a2_.id LEFT JOIN runners r3_ ON a0_.runner_id = r3_.id WHERE f1_.project_id = ? AND a0_.status IN (?, ?, ?, ?) ORDER BY a0_.created_at DESC, a0_.id DESC LIMIT 200
Parameters:
[
  "01a0bf6e-7534-7811-95ba-5a03539ef3c8"
  "QUEUED"
  "ASSIGNED"
  "STARTING"
  "RUNNING"
]
4.17 ms
(3.69%)
1
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 = ?
Parameters:
[
  "01a0bf09-6ed6-700d-8571-9d4f693ac070"
]
3.55 ms
(3.14%)
1
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 = ?
Parameters:
[
  "01a0bf6e-7534-7811-95ba-5a03539ef3c8"
]
2.04 ms
(1.81%)
1
SELECT COUNT(a0_.id) AS sclr_0 FROM agent_runs a0_ INNER JOIN features f1_ ON a0_.feature_id = f1_.id WHERE f1_.project_id = ? AND a0_.status IN (?, ?, ?, ?)
Parameters:
[
  "01a0bf6e-7534-7811-95ba-5a03539ef3c8"
  "QUEUED"
  "ASSIGNED"
  "STARTING"
  "RUNNING"
]
2.04 ms
(1.80%)
1
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 = ?
Parameters:
[
  "01a0bf6e-7534-7811-95ba-5a03539ef3c8"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\User\Domain\User 1
App\Project\Domain\Project 1
App\Project\Domain\ProjectMember 1