Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.39 ms Query time

1 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.41 ms

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user_company u0_ INNER JOIN user u1_ ON u0_.id_user = u1_.id WHERE u1_.is_active = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT u0_.id) AS sclr_0
FROM
  user_company u0_
  INNER JOIN user u1_ ON u0_.id_user = u1_.id
WHERE
  u1_.is_active = 1

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user_company u0_ INNER JOIN user u1_ ON u0_.id_user = u1_.id WHERE u1_.is_active = 1;

#	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	ContainerW9p70Tx\PaginatorProxyBa079e5->paginate (line 20)
15	App\Modules\Company\Controller\CompanyController->list (line 50)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

0.23 ms

SELECT DISTINCT u0_.id AS id_0, u0_.name AS name_1 FROM user_company u0_ INNER JOIN user u1_ ON u0_.id_user = u1_.id WHERE u1_.is_active = 1 ORDER BY u0_.name ASC LIMIT 12

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT u0_.id AS id_0,
  u0_.name AS name_1
FROM
  user_company u0_
  INNER JOIN user u1_ ON u0_.id_user = u1_.id
WHERE
  u1_.is_active = 1
ORDER BY
  u0_.name ASC
LIMIT
  12

SELECT DISTINCT u0_.id AS id_0, u0_.name AS name_1 FROM user_company u0_ INNER JOIN user u1_ ON u0_.id_user = u1_.id WHERE u1_.is_active = 1 ORDER BY u0_.name ASC LIMIT 12;

#	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	ContainerW9p70Tx\PaginatorProxyBa079e5->paginate (line 20)
15	App\Modules\Company\Controller\CompanyController->list (line 50)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

0.22 ms

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.description AS description_3, u0_.logo AS logo_4, u0_.image AS image_5, u0_.tin AS tin_6, u0_.street AS street_7, u0_.postal_code AS postal_code_8, u0_.city AS city_9, u0_.company_data_visible AS company_data_visible_10, u0_.bank_account_number AS bank_account_number_11, u0_.id_user AS id_user_12 FROM user_company u0_ INNER JOIN user u1_ ON u0_.id_user = u1_.id WHERE u1_.is_active = 1 AND u0_.id IN (?) ORDER BY u0_.name ASC

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.slug AS slug_2,
  u0_.description AS description_3,
  u0_.logo AS logo_4,
  u0_.image AS image_5,
  u0_.tin AS tin_6,
  u0_.street AS street_7,
  u0_.postal_code AS postal_code_8,
  u0_.city AS city_9,
  u0_.company_data_visible AS company_data_visible_10,
  u0_.bank_account_number AS bank_account_number_11,
  u0_.id_user AS id_user_12
FROM
  user_company u0_
  INNER JOIN user u1_ ON u0_.id_user = u1_.id
WHERE
  u1_.is_active = 1
  AND u0_.id IN (?)
ORDER BY
  u0_.name ASC

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.description AS description_3, u0_.logo AS logo_4, u0_.image AS image_5, u0_.tin AS tin_6, u0_.street AS street_7, u0_.postal_code AS postal_code_8, u0_.city AS city_9, u0_.company_data_visible AS company_data_visible_10, u0_.bank_account_number AS bank_account_number_11, u0_.id_user AS id_user_12 FROM user_company u0_ INNER JOIN user u1_ ON u0_.id_user = u1_.id WHERE u1_.is_active = 1 AND u0_.id IN ('1') ORDER BY u0_.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	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	ContainerW9p70Tx\PaginatorProxyBa079e5->paginate (line 20)
15	App\Modules\Company\Controller\CompanyController->list (line 50)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

0.54 ms

SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id WHERE p0_.is_active = 1 AND u1_.is_active = 1 AND p0_.id_added_by_user = ?

Parameters:

[
  "3"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  product p0_
  INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id
WHERE
  p0_.is_active = 1
  AND u1_.is_active = 1
  AND p0_.id_added_by_user = ?

SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id WHERE p0_.is_active = 1 AND u1_.is_active = 1 AND p0_.id_added_by_user = '3';

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Modules\Product\Service\ProductRepositoryService->searchCount (line 42)
8	App\Modules\Company\Service\CompanyService->getDetails (line 55)
9	App\Modules\Company\Controller\CompanyController->list (line 60)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	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\Admin\Modules\Company\Entity\UserCompany	1
App\Modules\User\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Admin\Modules\Company\Entity\UserCompany	The field 'App\Admin\Modules\Company\Entity\UserCompany#companyDataVisible' has the property type 'string' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Modules\User\Entity\User	No errors.
App\Admin\Modules\Product\Entity\Product	No errors.

Symfony Profiler

GET https://testy.skleponline.pl/_fragment?_path=_format%3Dhtml%26_locale%3Dpl%26_controller%3DApp%255CModules%255CCart%255CController%255CCartController%253A%253Ac…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping