Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

4.90 ms Query time

0 Invalid entities

26 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.79 ms
(36.52%)

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM category c0_ LEFT JOIN merchant m1_ ON c0_.id = m1_.category_id LEFT JOIN coupon c2_ ON m1_.id = c2_.merchant_id AND (c2_.expired_at > ? OR c2_.expired_at IS NULL) GROUP BY c0_.id

Parameters:

[
  "2026-08-19 13:31:56"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  category c0_
  LEFT JOIN merchant m1_ ON c0_.id = m1_.category_id
  LEFT JOIN coupon c2_ ON m1_.id = c2_.merchant_id
  AND (
    c2_.expired_at > ?
    OR c2_.expired_at IS NULL
  )
GROUP BY
  c0_.id

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM category c0_ LEFT JOIN merchant m1_ ON c0_.id = m1_.category_id LEFT JOIN coupon c2_ ON m1_.id = c2_.merchant_id AND (c2_.expired_at > '2026-08-19 13:31:56' OR c2_.expired_at IS NULL) GROUP BY c0_.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 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerX6s23VI\PaginatorProxy9cc2a8f->paginate (line 25)
15	App\Controller\Front\CategoryController->index (line 26)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 197)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.84 ms
(17.13%)

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.description AS description_2, m0_.image AS image_3, m0_.enabled AS enabled_4, m0_.score AS score_5, m0_.visit_count AS visit_count_6, m0_.url_tracking AS url_tracking_7, m0_.manual_boost AS manual_boost_8, m0_.category_id AS category_id_9 FROM merchant m0_ WHERE m0_.enabled = ? ORDER BY m0_.visit_count + m0_.manual_boost DESC LIMIT 6

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.description AS description_2,
  m0_.image AS image_3,
  m0_.enabled AS enabled_4,
  m0_.score AS score_5,
  m0_.visit_count AS visit_count_6,
  m0_.url_tracking AS url_tracking_7,
  m0_.manual_boost AS manual_boost_8,
  m0_.category_id AS category_id_9
FROM
  merchant m0_
WHERE
  m0_.enabled = ?
ORDER BY
  m0_.visit_count + m0_.manual_boost DESC
LIMIT
  6

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.description AS description_2, m0_.image AS image_3, m0_.enabled AS enabled_4, m0_.score AS score_5, m0_.visit_count AS visit_count_6, m0_.url_tracking AS url_tracking_7, m0_.manual_boost AS manual_boost_8, m0_.category_id AS category_id_9 FROM merchant m0_ WHERE m0_.enabled = 1 ORDER BY m0_.visit_count + m0_.manual_boost DESC LIMIT 6;

#	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\MerchantRepository->findTopMerchants (line 85)
7	App\EventSubscriber\GlobalVariablesSubscriber->onKernelController (line 24)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 169)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 197)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

0.78 ms
(15.90%)

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.enabled AS enabled_3, COUNT(c1_.id) AS sclr_4, c0_.parent_id AS parent_id_5 FROM category c0_ LEFT JOIN merchant m2_ ON c0_.id = m2_.category_id LEFT JOIN coupon c1_ ON m2_.id = c1_.merchant_id AND (c1_.expired_at > ? OR c1_.expired_at IS NULL) WHERE c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY c0_.id ORDER BY c0_.title ASC

Parameters:

[
  "2026-08-19 13:31:56"
  67
  68
  71
  75
  79
  74
  61
  77
  80
  63
  73
  66
  76
  78
  72
  64
  65
  62
  70
  69
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.description AS description_2,
  c0_.enabled AS enabled_3,
  COUNT(c1_.id) AS sclr_4,
  c0_.parent_id AS parent_id_5
FROM
  category c0_
  LEFT JOIN merchant m2_ ON c0_.id = m2_.category_id
  LEFT JOIN coupon c1_ ON m2_.id = c1_.merchant_id
  AND (
    c1_.expired_at > ?
    OR c1_.expired_at IS NULL
  )
WHERE
  c0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
GROUP BY
  c0_.id
ORDER BY
  c0_.title ASC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.enabled AS enabled_3, COUNT(c1_.id) AS sclr_4, c0_.parent_id AS parent_id_5 FROM category c0_ LEFT JOIN merchant m2_ ON c0_.id = m2_.category_id LEFT JOIN coupon c1_ ON m2_.id = c1_.merchant_id AND (c1_.expired_at > '2026-08-19 13:31:56' OR c1_.expired_at IS NULL) WHERE c0_.id IN (67, 68, 71, 75, 79, 74, 61, 77, 80, 63, 73, 66, 76, 78, 72, 64, 65, 62, 70, 69) GROUP BY c0_.id ORDER BY c0_.title 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 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerX6s23VI\PaginatorProxy9cc2a8f->paginate (line 25)
15	App\Controller\Front\CategoryController->index (line 26)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 197)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.58 ms
(11.74%)

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.enabled AS enabled_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN merchant m1_ ON c0_.id = m1_.category_id WHERE c0_.enabled = ? GROUP BY c0_.title, c0_.id ORDER BY m1_.score DESC LIMIT 16

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.description AS description_2,
  c0_.enabled AS enabled_3,
  c0_.parent_id AS parent_id_4
FROM
  category c0_
  INNER JOIN merchant m1_ ON c0_.id = m1_.category_id
WHERE
  c0_.enabled = ?
GROUP BY
  c0_.title,
  c0_.id
ORDER BY
  m1_.score DESC
LIMIT
  16

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.enabled AS enabled_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN merchant m1_ ON c0_.id = m1_.category_id WHERE c0_.enabled = 1 GROUP BY c0_.title, c0_.id ORDER BY m1_.score DESC LIMIT 16;

#	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\CategoryRepository->findTopCategoriesByMerchantScore (line 83)
7	App\Controller\Front\CategoryController->index (line 32)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.52 ms
(10.52%)

SELECT DISTINCT c0_.id AS id_0, c0_.title AS title_1 FROM category c0_ LEFT JOIN merchant m1_ ON c0_.id = m1_.category_id LEFT JOIN coupon c2_ ON m1_.id = c2_.merchant_id AND (c2_.expired_at > ? OR c2_.expired_at IS NULL) GROUP BY c0_.id ORDER BY c0_.title ASC LIMIT 36

Parameters:

[
  "2026-08-19 13:31:56"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.title AS title_1
FROM
  category c0_
  LEFT JOIN merchant m1_ ON c0_.id = m1_.category_id
  LEFT JOIN coupon c2_ ON m1_.id = c2_.merchant_id
  AND (
    c2_.expired_at > ?
    OR c2_.expired_at IS NULL
  )
GROUP BY
  c0_.id
ORDER BY
  c0_.title ASC
LIMIT
  36

SELECT DISTINCT c0_.id AS id_0, c0_.title AS title_1 FROM category c0_ LEFT JOIN merchant m1_ ON c0_.id = m1_.category_id LEFT JOIN coupon c2_ ON m1_.id = c2_.merchant_id AND (c2_.expired_at > '2026-08-19 13:31:56' OR c2_.expired_at IS NULL) GROUP BY c0_.id ORDER BY c0_.title ASC LIMIT 36;

#	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 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerX6s23VI\PaginatorProxy9cc2a8f->paginate (line 25)
15	App\Controller\Front\CategoryController->index (line 26)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 197)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.40 ms
(8.20%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.enabled AS enabled_4, t0.parent_id AS parent_id_5 FROM category t0 WHERE t0.enabled = ? ORDER BY t0.title ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.enabled AS enabled_4,
  t0.parent_id AS parent_id_5
FROM
  category t0
WHERE
  t0.enabled = ?
ORDER BY
  t0.title ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.enabled AS enabled_4, t0.parent_id AS parent_id_5 FROM category t0 WHERE t0.enabled = 1 ORDER BY t0.title ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\EventSubscriber\GlobalVariablesSubscriber->onKernelController (line 25)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 169)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 197)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	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\Category	20
App\Entity\Merchant	6

Entities Mapping

Class	Mapping errors
App\Entity\Merchant	No errors.
App\Entity\Category	No errors.
App\Entity\Coupon	No errors.
App\Entity\News	No errors.

Symfony Profiler

GET https://www.mitsitsy.e-tsena.net/code-promos-par-categories.html

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping