Symfony Profiler

Query Metrics

32 Database Queries

9 Different statements

7.54 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.38 ms
(44.91%)

SELECT t0.code AS code_1, t0.rate AS rate_2, t0.updated_at AS updated_at_3 FROM currency_rates t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.rate AS rate_2,
  t0.updated_at AS updated_at_3
FROM
  currency_rates t0

SELECT t0.code AS code_1, t0.rate AS rate_2, t0.updated_at AS updated_at_3 FROM currency_rates t0;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->traceFunction (line 246)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->query (line 117)
3	Doctrine\DBAL\Connection->executeQuery (line 804)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
5	Doctrine\ORM\EntityRepository->findBy (line 110)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
7	Doctrine\ORM\EntityRepository->findAll (line 96)
8	App\Repository\CurrencyRateRepository->asMap (line 25)
9	App\Service\Currency\CurrencyConverter->convert (line 24)
10	App\Twig\AppExtension->price (line 101)
11	__TwigTemplate_2b002a0295293d0f7ac15ba378c8cbad->block_title (line 92)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_72ff5be9fc0d644930f3d35de6346f9f->doDisplay (line 78)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_2b002a0295293d0f7ac15ba378c8cbad->doDisplay (line 60)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\Public\ProductController->show (line 90)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

2.31 ms
(30.61%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->traceFunction (line 246)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->commit (line 165)
3	Doctrine\DBAL\Connection->commit (line 1083)
4	Doctrine\ORM\UnitOfWork->commit (line 434)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\Public\ProductController->show (line 85)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.36 ms
(4.75%)

SELECT o0_.id AS id_0, o0_.customer_email AS customer_email_1, o0_.status AS status_2, o0_.status_history AS status_history_3, o0_.subtotal_cents AS subtotal_cents_4, o0_.vat_rate AS vat_rate_5, o0_.vat_cents AS vat_cents_6, o0_.total_cents AS total_cents_7, o0_.tip_cents AS tip_cents_8, o0_.donation_cents AS donation_cents_9, o0_.currency AS currency_10, o0_.payment_method AS payment_method_11, o0_.shipping AS shipping_12, o0_.items AS items_13, o0_.carrier AS carrier_14, o0_.tracking_number AS tracking_number_15, o0_.created_at AS created_at_16 FROM orders o0_ WHERE o0_.status IN (?, ?, ?, ?) AND o0_.created_at >= ?

Parameters:

[
  "paid"
  "prepared"
  "shipped"
  "delivered"
  "2025-05-09 05:07:50"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.customer_email AS customer_email_1,
  o0_.status AS status_2,
  o0_.status_history AS status_history_3,
  o0_.subtotal_cents AS subtotal_cents_4,
  o0_.vat_rate AS vat_rate_5,
  o0_.vat_cents AS vat_cents_6,
  o0_.total_cents AS total_cents_7,
  o0_.tip_cents AS tip_cents_8,
  o0_.donation_cents AS donation_cents_9,
  o0_.currency AS currency_10,
  o0_.payment_method AS payment_method_11,
  o0_.shipping AS shipping_12,
  o0_.items AS items_13,
  o0_.carrier AS carrier_14,
  o0_.tracking_number AS tracking_number_15,
  o0_.created_at AS created_at_16
FROM
  orders o0_
WHERE
  o0_.status IN (?, ?, ?, ?)
  AND o0_.created_at >= ?

SELECT o0_.id AS id_0, o0_.customer_email AS customer_email_1, o0_.status AS status_2, o0_.status_history AS status_history_3, o0_.subtotal_cents AS subtotal_cents_4, o0_.vat_rate AS vat_rate_5, o0_.vat_cents AS vat_cents_6, o0_.total_cents AS total_cents_7, o0_.tip_cents AS tip_cents_8, o0_.donation_cents AS donation_cents_9, o0_.currency AS currency_10, o0_.payment_method AS payment_method_11, o0_.shipping AS shipping_12, o0_.items AS items_13, o0_.carrier AS carrier_14, o0_.tracking_number AS tracking_number_15, o0_.created_at AS created_at_16 FROM orders o0_ WHERE o0_.status IN ('paid', 'prepared', 'shipped', 'delivered') AND o0_.created_at >= '2025-05-09 05:07:50';

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getResult (line 688)
8	App\Repository\OrderRepository->coBoughtSlugs (line 49)
9	App\Controller\Public\ProductController->show (line 48)
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.31 ms
(4.13%)

SELECT r0_.id AS id_0, r0_.customer_email AS customer_email_1, r0_.customer_display_name AS customer_display_name_2, r0_.product_slug AS product_slug_3, r0_.seller_slug AS seller_slug_4, r0_.rating AS rating_5, r0_.body AS body_6, r0_.published AS published_7, r0_.image_urls AS image_urls_8, r0_.created_at AS created_at_9 FROM reviews r0_ WHERE r0_.product_slug = ? AND r0_.published = 1 ORDER BY r0_.created_at DESC

Parameters:

[
  "orchard-10"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.customer_email AS customer_email_1,
  r0_.customer_display_name AS customer_display_name_2,
  r0_.product_slug AS product_slug_3,
  r0_.seller_slug AS seller_slug_4,
  r0_.rating AS rating_5,
  r0_.body AS body_6,
  r0_.published AS published_7,
  r0_.image_urls AS image_urls_8,
  r0_.created_at AS created_at_9
FROM
  reviews r0_
WHERE
  r0_.product_slug = ?
  AND r0_.published = 1
ORDER BY
  r0_.created_at DESC

SELECT r0_.id AS id_0, r0_.customer_email AS customer_email_1, r0_.customer_display_name AS customer_display_name_2, r0_.product_slug AS product_slug_3, r0_.seller_slug AS seller_slug_4, r0_.rating AS rating_5, r0_.body AS body_6, r0_.published AS published_7, r0_.image_urls AS image_urls_8, r0_.created_at AS created_at_9 FROM reviews r0_ WHERE r0_.product_slug = 'orchard-10' AND r0_.published = 1 ORDER BY r0_.created_at DESC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getResult (line 688)
8	App\Repository\ReviewRepository->forProduct (line 29)
9	App\Controller\Public\ProductController->show (line 56)
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.30 ms
(4.01%)

SELECT t0.id AS id_1, t0.product_slug AS product_slug_2, t0.day AS day_3, t0.views AS views_4 FROM product_views t0 WHERE t0.product_slug = ? AND t0.day = ? LIMIT 1

Parameters:

[
  "orchard-10"
  "2026-05-09"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.product_slug AS product_slug_2,
  t0.day AS day_3,
  t0.views AS views_4
FROM
  product_views t0
WHERE
  t0.product_slug = ?
  AND t0.day = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.product_slug AS product_slug_2, t0.day AS day_3, t0.views AS views_4 FROM product_views t0 WHERE t0.product_slug = 'orchard-10' AND t0.day = '2026-05-09' LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\EntityRepository->findOneBy (line 125)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
6	App\Repository\ProductViewRepository->findByPair (line 23)
7	App\Controller\Public\ProductController->show (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.27 ms
(3.64%)

SELECT COUNT(r0_.id) AS sclr_0, AVG(r0_.rating) AS sclr_1 FROM reviews r0_ WHERE r0_.product_slug = ? AND r0_.published = 1

Parameters:

[
  "orchard-10"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(r0_.id) AS sclr_0,
  AVG(r0_.rating) AS sclr_1
FROM
  reviews r0_
WHERE
  r0_.product_slug = ?
  AND r0_.published = 1

SELECT COUNT(r0_.id) AS sclr_0, AVG(r0_.rating) AS sclr_1 FROM reviews r0_ WHERE r0_.product_slug = 'orchard-10' AND r0_.published = 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
8	App\Repository\ReviewRepository->aggregateForProduct (line 39)
9	App\Controller\Public\ProductController->show (line 57)
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.23 ms
(3.08%)

UPDATE product_views SET views = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  product_views
SET
  views = ?
WHERE
  id = ?

UPDATE product_views SET views = 2 WHERE id = 77;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeStatement (line 905)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
5	Doctrine\ORM\UnitOfWork->executeUpdates (line 1141)
6	Doctrine\ORM\UnitOfWork->commit (line 409)
7	Doctrine\ORM\EntityManager->flush (line 268)
8	App\Controller\Public\ProductController->show (line 85)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.19 ms
(2.47%)

SELECT c0_.code AS code_0, c0_.rate AS rate_1, c0_.updated_at AS updated_at_2 FROM currency_rates c0_ ORDER BY c0_.updated_at DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.code AS code_0,
  c0_.rate AS rate_1,
  c0_.updated_at AS updated_at_2
FROM
  currency_rates c0_
ORDER BY
  c0_.updated_at DESC
LIMIT
  1

SELECT c0_.code AS code_0, c0_.rate AS rate_1, c0_.updated_at AS updated_at_2 FROM currency_rates c0_ ORDER BY c0_.updated_at DESC LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->traceFunction (line 246)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->query (line 117)
3	Doctrine\DBAL\Connection->executeQuery (line 804)
4	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
5	Doctrine\ORM\Query->_doExecute (line 296)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
7	Doctrine\ORM\AbstractQuery->execute (line 886)
8	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
9	App\Repository\CurrencyRateRepository->latestUpdatedAt (line 36)
10	App\EventSubscriber\CurrencyTwigGlobalSubscriber->onController (line 72)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	require_once (line 5)

0.18 ms
(2.41%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->traceFunction (line 246)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->beginTransaction (line 155)
3	Doctrine\DBAL\Connection->beginTransaction (line 1058)
4	Doctrine\ORM\UnitOfWork->commit (line 383)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\Public\ProductController->show (line 85)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	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\ProductView	1

Entities Mapping

Class	Mapping errors
App\Entity\CurrencyRate	No errors.
App\Entity\Order	No errors.
App\Entity\Review	No errors.
App\Entity\ProductView	No errors.

Symfony Profiler

GET https://next.mironova.art/it/products/orchard-10/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping