Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

0.54 ms Query time

1 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.12 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.12 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.15 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.15 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.
App\Admin\Modules\Client\Entity\UserClient	No errors.
App\Admin\Modules\Settings\Entity\ProductCategory	No errors.
App\Admin\Modules\Product\Entity\ProductImage	No errors.
App\Admin\Modules\Product\Entity\ProductTag	No errors.
App\Admin\Modules\Presentation\Entity\PresentationProduct	No errors.

Symfony Profiler

GET https://www.testy.skleponline.pl/firmy/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping