Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

0.44 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.13 ms
(30.88%)

SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id WHERE u1_.is_active = 1 AND (EXISTS (SELECT p2_.id FROM presentation_product p2_ INNER JOIN promotion_product p3_ ON p2_.id = p3_.id_presentation_product INNER JOIN promotion p4_ ON p3_.id_promotion = p4_.id WHERE p2_.id_product = p0_.id AND p4_.date_from <= ? AND p4_.date_to >= ?)) AND p0_.id_added_by_user = ?

Parameters:

[
  "2026-04-28 00:00:00"
  "2026-04-28 00:00:00"
  "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
  u1_.is_active = 1
  AND (
    EXISTS (
      SELECT
        p2_.id
      FROM
        presentation_product p2_
        INNER JOIN promotion_product p3_ ON p2_.id = p3_.id_presentation_product
        INNER JOIN promotion p4_ ON p3_.id_promotion = p4_.id
      WHERE
        p2_.id_product = p0_.id
        AND p4_.date_from <= ?
        AND p4_.date_to >= ?
    )
  )
  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 u1_.is_active = 1 AND (EXISTS (SELECT p2_.id FROM presentation_product p2_ INNER JOIN promotion_product p3_ ON p2_.id = p3_.id_presentation_product INNER JOIN promotion p4_ ON p3_.id_promotion = p4_.id WHERE p2_.id_product = p0_.id AND p4_.date_from <= '2026-04-28 00:00:00' AND p4_.date_to >= '2026-04-28 00:00:00')) 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 40)
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)

0.12 ms
(28.15%)

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.description AS description_3, u0_.image AS image_4, u0_.tin AS tin_5, u0_.street AS street_6, u0_.postal_code AS postal_code_7, u0_.city AS city_8, u0_.bank_account_number AS bank_account_number_9, u0_.id_user AS id_user_10 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_.image AS image_4,
  u0_.tin AS tin_5,
  u0_.street AS street_6,
  u0_.postal_code AS postal_code_7,
  u0_.city AS city_8,
  u0_.bank_account_number AS bank_account_number_9,
  u0_.id_user AS id_user_10
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_.image AS image_4, u0_.tin AS tin_5, u0_.street AS street_6, u0_.postal_code AS postal_code_7, u0_.city AS city_8, u0_.bank_account_number AS bank_account_number_9, u0_.id_user AS id_user_10 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	ContainerOTJ3ABv\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.10 ms
(23.13%)

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	ContainerOTJ3ABv\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.08 ms
(17.84%)

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	ContainerOTJ3ABv\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)

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	No errors.
App\Modules\User\Entity\User	No errors.
App\Admin\Modules\Presentation\Entity\PresentationProduct	No errors.
App\Admin\Modules\Product\Entity\Product	No errors.
App\Admin\Modules\Promotion\Entity\PromotionProduct	No errors.
App\Admin\Modules\Promotion\Entity\Promotion	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping