Symfony Profiler

Query Metrics

25 Database Queries

12 Different statements

10.82 ms Query time

0 Invalid entities

46 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.30 ms
(30.47%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.expired_at AS expired_at_4, t0.code AS code_5, t0.description AS description_6, t0.gift AS gift_7, t0.shipping_free AS shipping_free_8, t0.discount_amount AS discount_amount_9, t0.discount_unit AS discount_unit_10, t0.click_count AS click_count_11, t0.merchant_id AS merchant_id_12 FROM coupon t0 WHERE t0.merchant_id = ?

Parameters:

[
  41
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.expired_at AS expired_at_4,
  t0.code AS code_5,
  t0.description AS description_6,
  t0.gift AS gift_7,
  t0.shipping_free AS shipping_free_8,
  t0.discount_amount AS discount_amount_9,
  t0.discount_unit AS discount_unit_10,
  t0.click_count AS click_count_11,
  t0.merchant_id AS merchant_id_12
FROM
  coupon t0
WHERE
  t0.merchant_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.expired_at AS expired_at_4, t0.code AS code_5, t0.description AS description_6, t0.gift AS gift_7, t0.shipping_free AS shipping_free_8, t0.discount_amount AS discount_amount_9, t0.discount_unit AS discount_unit_10, t0.click_count AS click_count_11, t0.merchant_id AS merchant_id_12 FROM coupon t0 WHERE t0.merchant_id = 41;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Service\Merchant\BestMerchantService->computeScore (line 18)
8	App\Service\Merchant\BestMerchantService->updateScore (line 33)
9	App\Controller\Front\MerchantController->show (line 74)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

1.55 ms
(14.33%)

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.31 ms
(12.15%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 432)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\Controller\Front\MerchantController->show (line 72)
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)

1.02 ms
(9.39%)

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.content AS content_2, n0_.created_at AS created_at_3, n0_.image AS image_4, n0_.enabled AS enabled_5, n0_.category_id AS category_id_6, n0_.merchant_id AS merchant_id_7 FROM news n0_ WHERE n0_.enabled = ? AND n0_.merchant_id = ? ORDER BY n0_.id DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.content AS content_2,
  n0_.created_at AS created_at_3,
  n0_.image AS image_4,
  n0_.enabled AS enabled_5,
  n0_.category_id AS category_id_6,
  n0_.merchant_id AS merchant_id_7
FROM
  news n0_
WHERE
  n0_.enabled = ?
  AND n0_.merchant_id = ?
ORDER BY
  n0_.id DESC

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.content AS content_2, n0_.created_at AS created_at_3, n0_.image AS image_4, n0_.enabled AS enabled_5, n0_.category_id AS category_id_6, n0_.merchant_id AS merchant_id_7 FROM news n0_ WHERE n0_.enabled = 1 AND n0_.merchant_id = 41 ORDER BY n0_.id DESC;

#	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\NewsRepository->findByCriterias (line 61)
7	App\Controller\Front\MerchantController->show (line 100)
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.97 ms
(8.97%)

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)

0.58 ms
(5.35%)

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-04-23 12:47:53"
  "2026-04-16 12:47:53"
]

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-04-23 12:47:53' 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-16 12:47:53' 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\MerchantController->show (line 80)
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.45 ms
(4.18%)

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_ INNER JOIN merchant m1_ ON c0_.merchant_id = m1_.id WHERE (c0_.expired_at > ? OR c0_.expired_at IS NULL) AND m1_.category_id = ? AND c0_.merchant_id NOT IN (?) ORDER BY c0_.id DESC

Parameters:

[
  "2026-04-16 12:47:53"
  61
  41
]

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_
  INNER JOIN merchant m1_ ON c0_.merchant_id = m1_.id
WHERE
  (
    c0_.expired_at > ?
    OR c0_.expired_at IS NULL
  )
  AND m1_.category_id = ?
  AND c0_.merchant_id NOT IN (?)
ORDER BY
  c0_.id DESC

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_ INNER JOIN merchant m1_ ON c0_.merchant_id = m1_.id WHERE (c0_.expired_at > '2026-04-16 12:47:53' OR c0_.expired_at IS NULL) AND m1_.category_id = 61 AND c0_.merchant_id NOT IN (41) ORDER BY c0_.id DESC;

#	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->findByCriterias (line 82)
7	App\Controller\Front\MerchantController->show (line 90)
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.39 ms
(3.57%)

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\MerchantController->show (line 83)
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.36 ms
(3.33%)

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) AND c0_.merchant_id = ? ORDER BY c0_.id DESC

Parameters:

[
  "2026-04-16 12:47:53"
  41
]

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
  )
  AND c0_.merchant_id = ?
ORDER BY
  c0_.id DESC

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-16 12:47:53' OR c0_.expired_at IS NULL) AND c0_.merchant_id = 41 ORDER BY c0_.id DESC;

#	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->findByCriterias (line 82)
7	App\Controller\Front\MerchantController->show (line 85)
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.35 ms
(3.26%)

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 4

Parameters:

[
  "2026-04-23 12:47:53"
  "2026-04-16 12:47:53"
]

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
  4

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-04-23 12:47:53' 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-16 12:47:53' ORDER BY sclr_11 DESC, discount_amount_12 DESC, sclr_13 DESC, c0_.id DESC LIMIT 4;

#	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\MerchantController->show (line 97)
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.34 ms
(3.13%)

UPDATE merchant SET visit_count = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  merchant
SET
  visit_count = ?
WHERE
  id = ?

UPDATE merchant SET visit_count = 11 WHERE id = 41;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1139)
4	Doctrine\ORM\UnitOfWork->commit (line 407)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\Front\MerchantController->show (line 72)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.20 ms
(1.86%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 381)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\Front\MerchantController->show (line 72)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 197)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	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	14
App\Entity\Coupon	12

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/boutiques/codes-promos-electromax-41.html

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping