Symfony Profiler

Query Metrics

10 Database Queries

7 Different statements

8.12 ms Query time

0 Invalid entities

39 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.08 ms
(25.65%)

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)

1.69 ms
(20.79%)

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)

1.64 ms
(20.24%)

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.expired_at AS expired_at_3, c0_.code AS code_4, c0_.description AS description_5, c0_.gift AS gift_6, c0_.shipping_free AS shipping_free_7, c0_.discount_amount AS discount_amount_8, c0_.discount_unit AS discount_unit_9, c0_.click_count AS click_count_10, c0_.merchant_id AS merchant_id_11 FROM coupon c0_ WHERE c0_.expired_at > ? OR c0_.expired_at IS NULL ORDER BY c0_.id DESC LIMIT 10

Parameters:

[
  "2026-04-25 13:22:22"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.expired_at AS expired_at_3,
  c0_.code AS code_4,
  c0_.description AS description_5,
  c0_.gift AS gift_6,
  c0_.shipping_free AS shipping_free_7,
  c0_.discount_amount AS discount_amount_8,
  c0_.discount_unit AS discount_unit_9,
  c0_.click_count AS click_count_10,
  c0_.merchant_id AS merchant_id_11
FROM
  coupon c0_
WHERE
  c0_.expired_at > ?
  OR c0_.expired_at IS NULL
ORDER BY
  c0_.id DESC
LIMIT
  10

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.expired_at AS expired_at_3, c0_.code AS code_4, c0_.description AS description_5, c0_.gift AS gift_6, c0_.shipping_free AS shipping_free_7, c0_.discount_amount AS discount_amount_8, c0_.discount_unit AS discount_unit_9, c0_.click_count AS click_count_10, c0_.merchant_id AS merchant_id_11 FROM coupon c0_ WHERE c0_.expired_at > '2026-04-25 13:22:22' OR c0_.expired_at IS NULL ORDER BY c0_.id DESC LIMIT 10;

#	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\CouponRepository->findLastNonExpired (line 34)
7	App\Controller\Front\HomeController->index (line 25)
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)

1.23 ms
(15.19%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6, t0.category_id AS category_id_7, t0.merchant_id AS merchant_id_8 FROM news t0 ORDER BY t0.created_at DESC LIMIT 2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.created_at AS created_at_4,
  t0.image AS image_5,
  t0.enabled AS enabled_6,
  t0.category_id AS category_id_7,
  t0.merchant_id AS merchant_id_8
FROM
  news t0
ORDER BY
  t0.created_at DESC
LIMIT
  2

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6, t0.category_id AS category_id_7, t0.merchant_id AS merchant_id_8 FROM news t0 ORDER BY t0.created_at DESC LIMIT 2;

#	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\Controller\Front\HomeController->index (line 42)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.95 ms
(11.74%)

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.expired_at AS expired_at_3, c0_.code AS code_4, c0_.description AS description_5, c0_.gift AS gift_6, c0_.shipping_free AS shipping_free_7, c0_.discount_amount AS discount_amount_8, c0_.discount_unit AS discount_unit_9, c0_.click_count AS click_count_10, (CASE WHEN c0_.expired_at IS NOT NULL AND c0_.expired_at <= ? THEN 1 ELSE 0 END) AS sclr_11, c0_.discount_amount AS discount_amount_12, (CASE WHEN c0_.gift = 1 OR c0_.shipping_free = 1 THEN 1 ELSE 0 END) AS sclr_13, c0_.merchant_id AS merchant_id_14 FROM coupon c0_ WHERE c0_.expired_at IS NULL OR c0_.expired_at > ? ORDER BY sclr_11 DESC, discount_amount_12 DESC, sclr_13 DESC, c0_.id DESC LIMIT 8

Parameters:

[
  "2026-05-02 13:22:22"
  "2026-04-25 13:22:22"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.expired_at AS expired_at_3,
  c0_.code AS code_4,
  c0_.description AS description_5,
  c0_.gift AS gift_6,
  c0_.shipping_free AS shipping_free_7,
  c0_.discount_amount AS discount_amount_8,
  c0_.discount_unit AS discount_unit_9,
  c0_.click_count AS click_count_10,
  (
    CASE WHEN c0_.expired_at IS NOT NULL
    AND c0_.expired_at <= ? THEN
      1
    ELSE
      0
    END
  ) AS sclr_11,
  c0_.discount_amount AS discount_amount_12,
  (
    CASE WHEN c0_.gift = 1
    OR c0_.shipping_free = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_13,
  c0_.merchant_id AS merchant_id_14
FROM
  coupon c0_
WHERE
  c0_.expired_at IS NULL
  OR c0_.expired_at > ?
ORDER BY
  sclr_11 DESC,
  discount_amount_12 DESC,
  sclr_13 DESC,
  c0_.id DESC
LIMIT
  8

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.expired_at AS expired_at_3, c0_.code AS code_4, c0_.description AS description_5, c0_.gift AS gift_6, c0_.shipping_free AS shipping_free_7, c0_.discount_amount AS discount_amount_8, c0_.discount_unit AS discount_unit_9, c0_.click_count AS click_count_10, (CASE WHEN c0_.expired_at IS NOT NULL AND c0_.expired_at <= '2026-05-02 13:22:22' THEN 1 ELSE 0 END) AS sclr_11, c0_.discount_amount AS discount_amount_12, (CASE WHEN c0_.gift = 1 OR c0_.shipping_free = 1 THEN 1 ELSE 0 END) AS sclr_13, c0_.merchant_id AS merchant_id_14 FROM coupon c0_ WHERE c0_.expired_at IS NULL OR c0_.expired_at > '2026-04-25 13:22:22' ORDER BY sclr_11 DESC, discount_amount_12 DESC, sclr_13 DESC, c0_.id DESC LIMIT 8;

#	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\CouponRepository->findHotDeals (line 126)
7	App\Controller\Front\HomeController->index (line 33)
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.26 ms
(3.21%)

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_ ORDER BY c0_.title ASC

Parameters:

[]

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_
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, c0_.parent_id AS parent_id_4 FROM category c0_ 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	App\Repository\CategoryRepository->findAllOrderedByTitle (line 38)
7	App\Controller\Front\HomeController->index (line 36)
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.26 ms
(3.18%)

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_.score DESC LIMIT 12

Parameters:

[]

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 = 1
ORDER BY
  m0_.score DESC
LIMIT
  12

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_.score DESC 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->getResult (line 688)
6	App\Repository\MerchantRepository->findBestMerchants (line 31)
7	App\Controller\Front\HomeController->index (line 39)
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)

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	16
App\Entity\Coupon	3

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/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CFront%255CCouponController%253A%253Arender…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping