Query Metrics
5
Database Queries
5
Different statements
40.50 ms
Query time
0
Invalid entities
21
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
23.24 ms (57.37%) |
1 |
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
Parameters:
[ "01a0bf6e-7534-7811-95ba-5a03539ef3c8" "MERGED" "CANCELLED" ]
|
||||||||||||||||||||||||||||
|
6.80 ms (16.78%) |
1 |
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
Parameters:
[ "01a0bf6e-7534-7811-95ba-5a03539ef3c8" "MERGED" "CANCELLED" ]
|
||||||||||||||||||||||||||||
|
4.24 ms (10.48%) |
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.94 ms (9.74%) |
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.28 ms (5.63%) |
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\Feature\Domain\Feature | 13 |
| App\Agent\Domain\AgentProfile | 2 |
| App\Prompt\Domain\PromptTemplate | 2 |
| App\User\Domain\User | 1 |
| App\Project\Domain\Project | 1 |
| App\Project\Domain\ProjectMember | 1 |
| App\Repository\Domain\GitRepository | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\User\Domain\User | No errors. |
| App\Project\Domain\ProjectInstructions | No errors. |
| App\Project\Domain\ProjectSettings | No errors. |
| App\Project\Domain\Project | No errors. |
| App\Project\Domain\ProjectMember | No errors. |
| App\Feature\Domain\Feature | No errors. |
| App\Repository\Domain\GitRepository | No errors. |
| App\Agent\Domain\AgentProfile | No errors. |
| App\Runner\Domain\Runner | No errors. |
| App\Prompt\Domain\PromptTemplate | No errors. |
| App\Feature\Domain\FeatureDependency | No errors. |