Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

18.03 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.33 ms
(46.23%)

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.hostname AS hostname_2, r0_.operating_system AS operating_system_3, r0_.architecture AS architecture_4, r0_.runner_version AS runner_version_5, r0_.git_version AS git_version_6, r0_.max_parallel_jobs AS max_parallel_jobs_7, r0_.available_slots AS available_slots_8, r0_.active_jobs AS active_jobs_9, r0_.status AS status_10, r0_.disabled AS disabled_11, r0_.authentication_token_id AS authentication_token_id_12, r0_.authentication_token_hash AS authentication_token_hash_13, r0_.authentication_token_prefix AS authentication_token_prefix_14, r0_.last_heartbeat_at AS last_heartbeat_at_15, r0_.last_authenticated_at AS last_authenticated_at_16, r0_.created_at AS created_at_17, r0_.updated_at AS updated_at_18, r1_.id AS id_19, r1_.name AS name_20, r1_.available AS available_21, r1_.version AS version_22, r1_.authenticated AS authenticated_23, r0_.project_id AS project_id_24, r1_.runner_id AS runner_id_25 FROM runners r0_ LEFT JOIN runner_capabilities r1_ ON r0_.id = r1_.runner_id WHERE r0_.project_id = ? ORDER BY r0_.name ASC

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.hostname AS hostname_2,
  r0_.operating_system AS operating_system_3,
  r0_.architecture AS architecture_4,
  r0_.runner_version AS runner_version_5,
  r0_.git_version AS git_version_6,
  r0_.max_parallel_jobs AS max_parallel_jobs_7,
  r0_.available_slots AS available_slots_8,
  r0_.active_jobs AS active_jobs_9,
  r0_.status AS status_10,
  r0_.disabled AS disabled_11,
  r0_.authentication_token_id AS authentication_token_id_12,
  r0_.authentication_token_hash AS authentication_token_hash_13,
  r0_.authentication_token_prefix AS authentication_token_prefix_14,
  r0_.last_heartbeat_at AS last_heartbeat_at_15,
  r0_.last_authenticated_at AS last_authenticated_at_16,
  r0_.created_at AS created_at_17,
  r0_.updated_at AS updated_at_18,
  r1_.id AS id_19,
  r1_.name AS name_20,
  r1_.available AS available_21,
  r1_.version AS version_22,
  r1_.authenticated AS authenticated_23,
  r0_.project_id AS project_id_24,
  r1_.runner_id AS runner_id_25
FROM
  runners r0_
  LEFT JOIN runner_capabilities r1_ ON r0_.id = r1_.runner_id
WHERE
  r0_.project_id = ?
ORDER BY
  r0_.name ASC

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.hostname AS hostname_2, r0_.operating_system AS operating_system_3, r0_.architecture AS architecture_4, r0_.runner_version AS runner_version_5, r0_.git_version AS git_version_6, r0_.max_parallel_jobs AS max_parallel_jobs_7, r0_.available_slots AS available_slots_8, r0_.active_jobs AS active_jobs_9, r0_.status AS status_10, r0_.disabled AS disabled_11, r0_.authentication_token_id AS authentication_token_id_12, r0_.authentication_token_hash AS authentication_token_hash_13, r0_.authentication_token_prefix AS authentication_token_prefix_14, r0_.last_heartbeat_at AS last_heartbeat_at_15, r0_.last_authenticated_at AS last_authenticated_at_16, r0_.created_at AS created_at_17, r0_.updated_at AS updated_at_18, r1_.id AS id_19, r1_.name AS name_20, r1_.available AS available_21, r1_.version AS version_22, r1_.authenticated AS authenticated_23, r0_.project_id AS project_id_24, r1_.runner_id AS runner_id_25 FROM runners r0_ LEFT JOIN runner_capabilities r1_ ON r0_.id = r1_.runner_id WHERE r0_.project_id = '01a0bf6e-7534-7811-95ba-5a03539ef3c8' ORDER BY r0_.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\Runner\Infrastructure\Doctrine\DoctrineRunnerRepository->findByProject (line 60)
7	App\Runner\UI\Http\RunnerManagementController->list (line 51)
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)

3.84 ms
(21.31%)

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)

3.73 ms
(20.68%)

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)

2.12 ms
(11.78%)

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\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\Runner\Domain\Runner	No errors.
App\Runner\Domain\RunnerCapability	No errors.

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping