Symfony Profiler

Query Metrics

8 Database Queries

6 Different statements

30.93 ms Query time

5 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.19 ms
(32.95%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1422)
2	Doctrine\DBAL\Connection->commit (line 475)
3	Doctrine\ORM\UnitOfWork->commit (line 403)
4	Doctrine\ORM\EntityManager->flush (line 209)
5	App\Shop\Order\Service\OrderService->place (line 194)
6	App\Shop\Order\Service\OrderService->create (line 168)
7	App\Shop\Order\Service\OrderService->getOrder (line 114)
8	App\Shop\Order\Controller\OrderController->checkoutConfirm (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

6.56 ms
(21.21%)

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.locales AS locales_2, c0_.active AS active_3, c0_.code AS code_4, c0_.deleted_at AS deleted_at_5, c0_.currency_id AS currency_id_6 FROM country c0_ WHERE (c0_.slug = ?) AND (c0_.deleted_at IS NULL)

Parameters:

[
  "RU"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.slug AS slug_1,
  c0_.locales AS locales_2,
  c0_.active AS active_3,
  c0_.code AS code_4,
  c0_.deleted_at AS deleted_at_5,
  c0_.currency_id AS currency_id_6
FROM
  country c0_
WHERE
  (c0_.slug = ?)
  AND (c0_.deleted_at IS NULL)

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.locales AS locales_2, c0_.active AS active_3, c0_.code AS code_4, c0_.deleted_at AS deleted_at_5, c0_.currency_id AS currency_id_6 FROM country c0_ WHERE (c0_.slug = 'RU') AND (c0_.deleted_at IS NULL);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 38)
7	App\Geo\Repository\CountryRepository->findOneByCode (line 29)
8	App\Geo\Service\CountryService->getCountry (line 152)
9	App\Locale\Service\LocaleService->getCurrentCountry (line 33)
10	App\Shop\Price\Service\CurrencyService->getCurrentCurrency (line 28)
11	App\Shop\Price\Event\Subscriber\RequestSubscriber->onKernelRequest (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

5.12 ms
(16.57%)

INSERT INTO `order` (promo_code, status, cancel_reason, state, tax_invoice, country, city, fiscal_number, event_hash, price, insurance_amount, total, discount, paid_amount, fee, net, commission, profit, paid, paid_at, created_at, published_at, expired_at, canceled_at, edited_at, deleted_at, hash, user_id, currency_id, payment_method_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  null
  "new"
  null
  "draft"
  0
  null
  null
  null
  null
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  null
  "2024-09-28 22:19:47"
  null
  null
  null
  "2024-09-28 22:19:47"
  null
  null
  null
  1
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO `order` (
  promo_code, status, cancel_reason,
  state, tax_invoice, country, city,
  fiscal_number, event_hash, price,
  insurance_amount, total, discount,
  paid_amount, fee, net, commission,
  profit, paid, paid_at, created_at,
  published_at, expired_at, canceled_at,
  edited_at, deleted_at, hash, user_id,
  currency_id, payment_method_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO `order` (promo_code, status, cancel_reason, state, tax_invoice, country, city, fiscal_number, event_hash, price, insurance_amount, total, discount, paid_amount, fee, net, commission, profit, paid, paid_at, created_at, published_at, expired_at, canceled_at, edited_at, deleted_at, hash, user_id, currency_id, payment_method_id) VALUES (NULL, 'new', NULL, 'draft', 0, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2024-09-28 22:19:47', NULL, NULL, NULL, '2024-09-28 22:19:47', NULL, NULL, NULL, 1, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 280)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1182)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 446)
5	Doctrine\ORM\UnitOfWork->commit (line 403)
6	Doctrine\ORM\EntityManager->flush (line 209)
7	App\Shop\Order\Service\OrderService->place (line 194)
8	App\Shop\Order\Service\OrderService->create (line 168)
9	App\Shop\Order\Service\OrderService->getOrder (line 114)
10	App\Shop\Order\Controller\OrderController->checkoutConfirm (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

4.19 ms
(13.54%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.sign AS sign_3, t0.active AS active_4, t0.deleted_at AS deleted_at_5 FROM currency t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.sign AS sign_3,
  t0.active AS active_4,
  t0.deleted_at AS deleted_at_5
FROM
  currency t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.code AS code_2, t0.sign AS sign_3, t0.active AS active_4, t0.deleted_at AS deleted_at_5 FROM currency t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Shop\Price\Entity\Currency::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Shop\Price\Entity\Currency->__get (line 56)
8	App\Shop\Price\Entity\Currency->getCode (line 63)
9	App\Shop\Price\Service\CurrencyService->saveUserCurrency (line 29)
10	App\Shop\Price\Event\Subscriber\RequestSubscriber->onKernelRequest (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

2.50 ms
(8.08%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 427)
2	Doctrine\ORM\UnitOfWork->commit (line 403)
3	Doctrine\ORM\EntityManager->flush (line 209)
4	App\Shop\Order\Service\OrderService->place (line 194)
5	App\Shop\Order\Service\OrderService->create (line 168)
6	App\Shop\Order\Service\OrderService->getOrder (line 114)
7	App\Shop\Order\Controller\OrderController->checkoutConfirm (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

2.37 ms
(7.65%)

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ LEFT JOIN country c1_ ON c0_.id = c1_.currency_id AND (c1_.deleted_at IS NULL) WHERE (c1_.id = ?) AND (c0_.deleted_at IS NULL) LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.sign AS sign_2,
  c0_.active AS active_3,
  c0_.deleted_at AS deleted_at_4
FROM
  currency c0_
  LEFT JOIN country c1_ ON c0_.id = c1_.currency_id
  AND (c1_.deleted_at IS NULL)
WHERE
  (c1_.id = ?)
  AND (c0_.deleted_at IS NULL)
LIMIT
  1

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ LEFT JOIN country c1_ ON c0_.id = c1_.currency_id AND (c1_.deleted_at IS NULL) WHERE (c1_.id = 1) AND (c0_.deleted_at IS NULL) LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 50)
7	App\Shop\Price\Repository\CurrencyRepository->findDefault (line 95)
8	App\Shop\Price\Service\CurrencyService->getUserCurrency (line 184)
9	App\Shop\Order\Service\OrderService->create (line 168)
10	App\Shop\Order\Service\OrderService->getOrder (line 114)
11	App\Shop\Order\Controller\OrderController->checkoutConfirm (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	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.

Entities Mapping

Class	Mapping errors
App\Geo\Entity\Country	The association App\Geo\Entity\Country#paymentMethods refers to the owning side field App\Shop\Payment\Entity\PaymentMethod#country which does not exist. If association App\Geo\Entity\Country#currency is many-to-one, then the inversed side App\Shop\Price\Entity\Currency#countries has to be one-to-many.
App\Shop\Price\Entity\Currency	No errors.
App\Shop\Payment\Entity\PaymentMethod	The mappings App\Shop\Payment\Entity\PaymentMethod#countries and App\Geo\Entity\Country#paymentMethods are inconsistent with each other.
App\Geo\Entity\CountryTranslation	No errors.
App\Shop\Order\Entity\Order	The mappings App\Shop\Order\Entity\Order#user and App\User\Entity\User#orders are inconsistent with each other.
App\Shop\Order\Entity\OrderProduct	The association App\Shop\Order\Entity\OrderProduct#product refers to the inverse side field App\Shop\Catalog\Entity\Product#orderProducts which does not exist.
App\Shop\Payment\Entity\Payment	No errors.
App\User\Entity\User	The association App\User\Entity\User#orders refers to the owning side field App\Shop\Order\Entity\Order#client which does not exist.

Symfony Profiler

GET https://dev.front.garmon.io/ru/order/checkout/concert-in-lisbon-25-september-2024-lissabon-portugaliya

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping