Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

16.93 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

5.40 ms

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.09 ms

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.38 ms

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)

5.06 ms

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.provider AS provider_2, g0_.clone_url AS clone_url_3, g0_.default_branch AS default_branch_4, g0_.branch_pattern AS branch_pattern_5, g0_.pull_request_target_branch AS pull_request_target_branch_6, g0_.local_path AS local_path_7, g0_.auto_create_pull_request AS auto_create_pull_request_8, g0_.delete_branch_after_merge AS delete_branch_after_merge_9, g0_.active AS active_10, g0_.created_at AS created_at_11, g0_.updated_at AS updated_at_12, g0_.project_id AS project_id_13 FROM git_repositories g0_ WHERE g0_.project_id = ? ORDER BY g0_.name ASC

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.id AS id_0,
  g0_.name AS name_1,
  g0_.provider AS provider_2,
  g0_.clone_url AS clone_url_3,
  g0_.default_branch AS default_branch_4,
  g0_.branch_pattern AS branch_pattern_5,
  g0_.pull_request_target_branch AS pull_request_target_branch_6,
  g0_.local_path AS local_path_7,
  g0_.auto_create_pull_request AS auto_create_pull_request_8,
  g0_.delete_branch_after_merge AS delete_branch_after_merge_9,
  g0_.active AS active_10,
  g0_.created_at AS created_at_11,
  g0_.updated_at AS updated_at_12,
  g0_.project_id AS project_id_13
FROM
  git_repositories g0_
WHERE
  g0_.project_id = ?
ORDER BY
  g0_.name ASC

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.provider AS provider_2, g0_.clone_url AS clone_url_3, g0_.default_branch AS default_branch_4, g0_.branch_pattern AS branch_pattern_5, g0_.pull_request_target_branch AS pull_request_target_branch_6, g0_.local_path AS local_path_7, g0_.auto_create_pull_request AS auto_create_pull_request_8, g0_.delete_branch_after_merge AS delete_branch_after_merge_9, g0_.active AS active_10, g0_.created_at AS created_at_11, g0_.updated_at AS updated_at_12, g0_.project_id AS project_id_13 FROM git_repositories g0_ WHERE g0_.project_id = '01a0bf6e-7534-7811-95ba-5a03539ef3c8' ORDER BY g0_.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\Repository\Infrastructure\Doctrine\DoctrineGitRepositoryRepository->findByProject (line 42)
7	App\Repository\UI\Http\GitRepositoryController->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)

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
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\Repository\Domain\GitRepository	No errors.

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping