Symfony Profiler

Query Metrics

8 Database Queries

6 Different statements

22.18 ms Query time

0 Invalid entities

22 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.67 ms
(48.09%)

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM activity a0_ INNER JOIN project p1_ ON (a0_.project_id = p1_.id) INNER JOIN contract c2_ ON (p1_.contract_id = c2_.id) INNER JOIN client c3_ ON (c2_.client_id = c3_.id) INNER JOIN activity_type a4_ ON (a0_.activity_type_id = a4_.id)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  activity a0_
  INNER JOIN project p1_ ON (a0_.project_id = p1_.id)
  INNER JOIN contract c2_ ON (p1_.contract_id = c2_.id)
  INNER JOIN client c3_ ON (c2_.client_id = c3_.id)
  INNER JOIN activity_type a4_ ON (a0_.activity_type_id = a4_.id)

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM activity a0_ INNER JOIN project p1_ ON (a0_.project_id = p1_.id) INNER JOIN contract c2_ ON (p1_.contract_id = c2_.id) INNER JOIN client c3_ ON (c2_.client_id = c3_.id) INNER JOIN activity_type a4_ ON (a0_.activity_type_id = a4_.id);

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	Container9BWS3ur\PaginatorProxyBa079e5->paginate (line 20)
15	App\Common\PaginationData->init (line 134)
16	App\Controller\Activity\ActivityIndex->__invoke (line 35)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

3.68 ms
(16.59%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.cdn_code AS cdn_code_2, a0_.for_region AS for_region_3, a0_.cdn_name AS cdn_name_4, a0_.api_uri AS api_uri_5, a0_.use_total AS use_total_6, a0_.unit_id AS unit_id_7 FROM activity_type a0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.cdn_code AS cdn_code_2,
  a0_.for_region AS for_region_3,
  a0_.cdn_name AS cdn_name_4,
  a0_.api_uri AS api_uri_5,
  a0_.use_total AS use_total_6,
  a0_.unit_id AS unit_id_7
FROM
  activity_type a0_

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.cdn_code AS cdn_code_2, a0_.for_region AS for_region_3, a0_.cdn_name AS cdn_name_4, a0_.api_uri AS api_uri_5, a0_.use_total AS use_total_6, a0_.unit_id AS unit_id_7 FROM activity_type a0_;

#	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\ActivityTypeRepository->getAll (line 49)
7	App\Filter\ActivityFilter->getActivityTypeOptions (line 20)
8	App\Filter\ActivityFilter->config (line 37)
9	App\Filter\FilterAbstract->__construct (line 35)
10	App\Filter\ActivityFilter->__construct (line 12)
11	Container9BWS3ur\getActivityIndexService->do (line 28)
12	Container9BWS3ur\App_KernelDevDebugContainer::load (line 774)
13	Symfony\Component\DependencyInjection\Container->make (line 221)
14	Symfony\Component\DependencyInjection\Container::get (line 203)
15	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
16	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
17	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 115)
18	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
19	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	require_once (line 5)

2.63 ms
(11.87%)

SELECT DISTINCT a0_.id AS id_0 FROM activity a0_ INNER JOIN project p1_ ON (a0_.project_id = p1_.id) INNER JOIN contract c2_ ON (p1_.contract_id = c2_.id) INNER JOIN client c3_ ON (c2_.client_id = c3_.id) INNER JOIN activity_type a4_ ON (a0_.activity_type_id = a4_.id) LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT a0_.id AS id_0
FROM
  activity a0_
  INNER JOIN project p1_ ON (a0_.project_id = p1_.id)
  INNER JOIN contract c2_ ON (p1_.contract_id = c2_.id)
  INNER JOIN client c3_ ON (c2_.client_id = c3_.id)
  INNER JOIN activity_type a4_ ON (a0_.activity_type_id = a4_.id)
LIMIT
  20

SELECT DISTINCT a0_.id AS id_0 FROM activity a0_ INNER JOIN project p1_ ON (a0_.project_id = p1_.id) INNER JOIN contract c2_ ON (p1_.contract_id = c2_.id) INNER JOIN client c3_ ON (c2_.client_id = c3_.id) INNER JOIN activity_type a4_ ON (a0_.activity_type_id = a4_.id) LIMIT 20;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	Container9BWS3ur\PaginatorProxyBa079e5->paginate (line 20)
15	App\Common\PaginationData->init (line 134)
16	App\Controller\Activity\ActivityIndex->__invoke (line 35)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

2.40 ms
(10.82%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.rus_name AS rus_name_4, t0.env AS env_5 FROM settings t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "current_month"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.rus_name AS rus_name_4,
  t0.env AS env_5
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.rus_name AS rus_name_4, t0.env AS env_5 FROM settings t0 WHERE t0.name = 'current_month' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\ORM\EntityRepository->resolveMagicCall (line 235)
4	Doctrine\ORM\EntityRepository->__call (line 158)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 95)
6	App\Repository\SettingsRepository->getCurrentMonth (line 55)
7	App\Repository\SettingsRepository->checkClosingPeriod (line 240)
8	App\Controller\Activity\ActivityIndex->{closure:App\Controller\Activity\ActivityIndex::__invoke():38} (line 41)
9	array_walk (line 38)
10	App\Controller\Activity\ActivityIndex::__invoke (line 38)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

2.26 ms
(10.19%)

SELECT a0_.id AS id_0, CONCAT(c1_.name, CONCAT(' (', CONCAT(c1_.email, ')'))) AS sclr_1, p2_.short_name AS short_name_2, a0_.year AS year_3, a0_.month AS month_4, a3_.name AS name_5, a0_.json_data AS json_data_6 FROM activity a0_ INNER JOIN project p2_ ON (a0_.project_id = p2_.id) INNER JOIN contract c4_ ON (p2_.contract_id = c4_.id) INNER JOIN client c1_ ON (c4_.client_id = c1_.id) INNER JOIN activity_type a3_ ON (a0_.activity_type_id = a3_.id) WHERE a0_.id IN (?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  CONCAT(
    c1_.name,
    CONCAT(
      ' (',
      CONCAT(c1_.email, ')')
    )
  ) AS sclr_1,
  p2_.short_name AS short_name_2,
  a0_.year AS year_3,
  a0_.month AS month_4,
  a3_.name AS name_5,
  a0_.json_data AS json_data_6
FROM
  activity a0_
  INNER JOIN project p2_ ON (a0_.project_id = p2_.id)
  INNER JOIN contract c4_ ON (p2_.contract_id = c4_.id)
  INNER JOIN client c1_ ON (c4_.client_id = c1_.id)
  INNER JOIN activity_type a3_ ON (a0_.activity_type_id = a3_.id)
WHERE
  a0_.id IN (?, ?)

SELECT a0_.id AS id_0, CONCAT(c1_.name, CONCAT(' (', CONCAT(c1_.email, ')'))) AS sclr_1, p2_.short_name AS short_name_2, a0_.year AS year_3, a0_.month AS month_4, a3_.name AS name_5, a0_.json_data AS json_data_6 FROM activity a0_ INNER JOIN project p2_ ON (a0_.project_id = p2_.id) INNER JOIN contract c4_ ON (p2_.contract_id = c4_.id) INNER JOIN client c1_ ON (c4_.client_id = c1_.id) INNER JOIN activity_type a3_ ON (a0_.activity_type_id = a3_.id) WHERE a0_.id IN (1, 2);

#	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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	Container9BWS3ur\PaginatorProxyBa079e5->paginate (line 20)
15	App\Common\PaginationData->init (line 134)
16	App\Controller\Activity\ActivityIndex->__invoke (line 35)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

0.54 ms
(2.43%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_id AS token_id_5, t0.token_password AS token_password_6, t0.blocked AS blocked_7, t0.token_auth AS token_auth_8 FROM users t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.token_id AS token_id_5,
  t0.token_password AS token_password_6,
  t0.blocked AS blocked_7,
  t0.token_auth AS token_auth_8
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_id AS token_id_5, t0.token_password AS token_password_6, t0.blocked AS blocked_7, t0.token_auth AS token_auth_8 FROM users t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

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\Entity\ActivityType	13
App\Entity\Unit	6
App\Entity\Settings	2
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\ActivityType	No errors.
App\Entity\Unit	No errors.
App\Entity\Activity	No errors.
App\Entity\Project	No errors.
App\Entity\Contract	No errors.
App\Entity\Client	No errors.
App\Entity\Settings	No errors.

Symfony Profiler

GET https://whatwedo.gp.dev.cdnnow.net/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping