Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

19.25 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.50 ms
(38.95%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.type AS type_2, a0_.role AS role_3, a0_.executable AS executable_4, a0_.default_arguments AS default_arguments_5, a0_.max_runtime_seconds AS max_runtime_seconds_6, a0_.enabled AS enabled_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.project_id AS project_id_10, a0_.preferred_runner_id AS preferred_runner_id_11, a0_.prompt_template_id AS prompt_template_id_12 FROM agent_profiles a0_ WHERE a0_.project_id = ? ORDER BY a0_.name ASC

Parameters:

[
  "01a0bf6e-7534-7811-95ba-5a03539ef3c8"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.type AS type_2,
  a0_.role AS role_3,
  a0_.executable AS executable_4,
  a0_.default_arguments AS default_arguments_5,
  a0_.max_runtime_seconds AS max_runtime_seconds_6,
  a0_.enabled AS enabled_7,
  a0_.created_at AS created_at_8,
  a0_.updated_at AS updated_at_9,
  a0_.project_id AS project_id_10,
  a0_.preferred_runner_id AS preferred_runner_id_11,
  a0_.prompt_template_id AS prompt_template_id_12
FROM
  agent_profiles a0_
WHERE
  a0_.project_id = ?
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.type AS type_2, a0_.role AS role_3, a0_.executable AS executable_4, a0_.default_arguments AS default_arguments_5, a0_.max_runtime_seconds AS max_runtime_seconds_6, a0_.enabled AS enabled_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.project_id AS project_id_10, a0_.preferred_runner_id AS preferred_runner_id_11, a0_.prompt_template_id AS prompt_template_id_12 FROM agent_profiles a0_ WHERE a0_.project_id = '01a0bf6e-7534-7811-95ba-5a03539ef3c8' ORDER BY a0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Agent\Infrastructure\Doctrine\DoctrineAgentProfileRepository->findByProject (line 42)
7	App\Agent\UI\Http\AgentProfileController->list (line 44)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
10	Symfony\Component\HttpKernel\Kernel->handle (line 143)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 7)

4.96 ms
(25.78%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = '01a0bf09-6ed6-700d-8571-9d4f693ac070';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 376)
4	App\User\Infrastructure\Doctrine\DoctrineUserRepository->find (line 28)
5	App\User\Infrastructure\Security\UserProvider->refreshUser (line 42)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 231)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
9	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
10	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
11	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 162)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
18	Symfony\Component\HttpKernel\Kernel->handle (line 143)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
20	require_once (line 32)
21	require_once (line 7)

4.30 ms
(22.34%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = '01a0bf6e-7534-7811-95ba-5a03539ef3c8';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 376)
4	Doctrine\ORM\EntityRepository->find (line 87)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->findById (line 77)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
9	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 179)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
12	Symfony\Component\HttpKernel\Kernel->handle (line 143)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 7)

2.49 ms
(12.93%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = '01a0bf6e-7534-7811-95ba-5a03539ef3c8';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->findFirst (line 184)
7	App\Project\Domain\Project->memberFor (line 222)
8	App\Project\Domain\Project->roleOf (line 227)
9	App\Project\Infrastructure\Security\ProjectVoter->voteOnAttribute (line 34)
10	Symfony\Component\Security\Core\Authorization\Voter\Voter->vote (line 52)
11	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 35)
12	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 89)
13	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 36)
14	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 73)
15	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 57)
16	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 54)
17	Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener->processAttribute (line 94)
18	Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener->onKernelControllerAttribute (line 49)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
23	Symfony\Component\HttpKernel\EventListener\ControllerAttributesListener->beforeController (line 59)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
30	Symfony\Component\HttpKernel\Kernel->handle (line 143)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
32	require_once (line 32)
33	require_once (line 7)

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\Agent\Domain\AgentProfile	2
App\Prompt\Domain\PromptTemplate	2
App\User\Domain\User	1
App\Project\Domain\Project	1
App\Project\Domain\ProjectMember	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\Agent\Domain\AgentProfile	No errors.
App\Runner\Domain\Runner	No errors.
App\Prompt\Domain\PromptTemplate	No errors.

GET https://agent.ws-thiele.de/api/projects/01a0bf6e-7534-7811-95ba-5a03539ef3c8/agent-profiles

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping