Symfony Profiler

Query Metrics

25 Database Queries

10 Different statements

4.37 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.95 ms
(44.67%)

SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.update_at AS update_at_3, t0.uuid AS uuid_4, t0.insales_order_id AS insales_order_id_5, t0.insales_key AS insales_key_6, t0.insales_comment AS insales_comment_7, t0.insales_currency AS insales_currency_8, t0.insales_number AS insales_number_9, t0.insales_items AS insales_items_10, t0.insales_client AS insales_client_11, t0.insales_total_price AS insales_total_price_12, t0.insales_items_price AS insales_items_price_13, t0.insales_payed AS insales_payed_14, t0.insales_transaction_id AS insales_transaction_id_15, t0.insales_delivery_price AS insales_delivery_price_16, t0.insales_delivery_name AS insales_delivery_name_17, t0.bspb_id AS bspb_id_18, t0.bspb_password AS bspb_password_19, t0.bspb_hpp_url AS bspb_hpp_url_20, t0.bspb_redirect_url AS bspb_redirect_url_21, t0.bspb_access_token AS bspb_access_token_22, t0.bspb_status AS bspb_status_23, t0.bspb_prev_status AS bspb_prev_status_24, t0.bspb_last_cli_update AS bspb_last_cli_update_25, t0.bspb_payment_date AS bspb_payment_date_26, t0.bspb_payment_sum AS bspb_payment_sum_27, t0.bspb_items AS bspb_items_28, t0.bspb_refund AS bspb_refund_29, t0.bspb_refund_date AS bspb_refund_date_30, t0.application_id AS application_id_31 FROM orders t0 WHERE t0.application_id = ? AND t0.insales_order_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.create_at AS create_at_2,
  t0.update_at AS update_at_3,
  t0.uuid AS uuid_4,
  t0.insales_order_id AS insales_order_id_5,
  t0.insales_key AS insales_key_6,
  t0.insales_comment AS insales_comment_7,
  t0.insales_currency AS insales_currency_8,
  t0.insales_number AS insales_number_9,
  t0.insales_items AS insales_items_10,
  t0.insales_client AS insales_client_11,
  t0.insales_total_price AS insales_total_price_12,
  t0.insales_items_price AS insales_items_price_13,
  t0.insales_payed AS insales_payed_14,
  t0.insales_transaction_id AS insales_transaction_id_15,
  t0.insales_delivery_price AS insales_delivery_price_16,
  t0.insales_delivery_name AS insales_delivery_name_17,
  t0.bspb_id AS bspb_id_18,
  t0.bspb_password AS bspb_password_19,
  t0.bspb_hpp_url AS bspb_hpp_url_20,
  t0.bspb_redirect_url AS bspb_redirect_url_21,
  t0.bspb_access_token AS bspb_access_token_22,
  t0.bspb_status AS bspb_status_23,
  t0.bspb_prev_status AS bspb_prev_status_24,
  t0.bspb_last_cli_update AS bspb_last_cli_update_25,
  t0.bspb_payment_date AS bspb_payment_date_26,
  t0.bspb_payment_sum AS bspb_payment_sum_27,
  t0.bspb_items AS bspb_items_28,
  t0.bspb_refund AS bspb_refund_29,
  t0.bspb_refund_date AS bspb_refund_date_30,
  t0.application_id AS application_id_31
FROM
  orders t0
WHERE
  t0.application_id = ?
  AND t0.insales_order_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.update_at AS update_at_3, t0.uuid AS uuid_4, t0.insales_order_id AS insales_order_id_5, t0.insales_key AS insales_key_6, t0.insales_comment AS insales_comment_7, t0.insales_currency AS insales_currency_8, t0.insales_number AS insales_number_9, t0.insales_items AS insales_items_10, t0.insales_client AS insales_client_11, t0.insales_total_price AS insales_total_price_12, t0.insales_items_price AS insales_items_price_13, t0.insales_payed AS insales_payed_14, t0.insales_transaction_id AS insales_transaction_id_15, t0.insales_delivery_price AS insales_delivery_price_16, t0.insales_delivery_name AS insales_delivery_name_17, t0.bspb_id AS bspb_id_18, t0.bspb_password AS bspb_password_19, t0.bspb_hpp_url AS bspb_hpp_url_20, t0.bspb_redirect_url AS bspb_redirect_url_21, t0.bspb_access_token AS bspb_access_token_22, t0.bspb_status AS bspb_status_23, t0.bspb_prev_status AS bspb_prev_status_24, t0.bspb_last_cli_update AS bspb_last_cli_update_25, t0.bspb_payment_date AS bspb_payment_date_26, t0.bspb_payment_sum AS bspb_payment_sum_27, t0.bspb_items AS bspb_items_28, t0.bspb_refund AS bspb_refund_29, t0.bspb_refund_date AS bspb_refund_date_30, t0.application_id AS application_id_31 FROM orders t0 WHERE t0.application_id = 1 AND t0.insales_order_id = 128213691 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 78)
4	App\Core\Infrastructure\Repository\OrderRepository->findOneByInsalesOrderId (line 25)
5	App\Core\Application\Query\Order\GetByInsalesId\GetByInsalesIdQueryHandler->__invoke (line 152)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 91)
7	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 71)
8	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 33)
9	Symfony\Bridge\Doctrine\Messenger\DoctrineTransactionMiddleware->handleForManager (line 45)
10	Symfony\Bridge\Doctrine\Messenger\AbstractDoctrineMiddleware->handle (line 45)
11	Symfony\Component\Messenger\Middleware\ValidationMiddleware->handle (line 34)
12	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
13	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
14	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
15	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
16	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
17	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
18	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 40)
19	App\Core\Infrastructure\Handler\Handler->handle (line 54)
20	App\Core\Ports\Http\Payment\PaymentOrderAction->__invoke (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.40 ms
(9.25%)

"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 29)
2	Symfony\Bridge\Doctrine\Messenger\DoctrineTransactionMiddleware->handleForManager (line 45)
3	Symfony\Bridge\Doctrine\Messenger\AbstractDoctrineMiddleware->handle (line 45)
4	Symfony\Component\Messenger\Middleware\ValidationMiddleware->handle (line 34)
5	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
6	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
7	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
8	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
9	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
10	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
11	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 40)
12	App\Core\Infrastructure\Handler\Handler->handle (line 45)
13	App\Core\Ports\Http\Payment\PaymentOrderAction->__invoke (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.39 ms
(8.97%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 35)
3	Symfony\Bridge\Doctrine\Messenger\DoctrineTransactionMiddleware->handleForManager (line 45)
4	Symfony\Bridge\Doctrine\Messenger\AbstractDoctrineMiddleware->handle (line 45)
5	Symfony\Component\Messenger\Middleware\ValidationMiddleware->handle (line 34)
6	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
7	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
8	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
9	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
10	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
11	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
12	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 40)
13	App\Core\Infrastructure\Handler\Handler->handle (line 45)
14	App\Core\Ports\Http\Payment\PaymentOrderAction->__invoke (line 181)
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)

0.36 ms
(8.24%)

SELECT t0.install_errors AS install_errors_1, t0.id AS id_2, t0.create_at AS create_at_3, t0.update_at AS update_at_4, t0.uuid AS uuid_5, t0.insales_login AS insales_login_6, t0.insales_password AS insales_password_7, t0.insales_host AS insales_host_8, t0.insales_connected AS insales_connected_9, t0.insales_widget_token AS insales_widget_token_10, t0.insales_payment_id AS insales_payment_id_11, t0.insales_payment_password AS insales_payment_password_12, t0.bspb_ssl_key AS bspb_ssl_key_13, t0.bspb_ssl_cert AS bspb_ssl_cert_14, t0.bspb_url AS bspb_url_15, t0.bspb_scheme AS bspb_scheme_16, t0.bspb_merchant AS bspb_merchant_17, t0.bspb_password AS bspb_password_18, t0.bspb_en_log AS bspb_en_log_19, t0.bspb_en_no_basket_form AS bspb_en_no_basket_form_20, t0.bspb_is_ofd AS bspb_is_ofd_21, t22.email AS email_23, t22.password AS password_24, t22.password_reset_token AS password_reset_token_25, t22.id AS id_26, t22.create_at AS create_at_27, t22.update_at AS update_at_28, t22.active AS active_29, t22.uuid AS uuid_30, t22.application_id AS application_id_31 FROM application t0 LEFT JOIN users t22 ON t22.application_id = t0.id WHERE t0.uuid = ? LIMIT 1

Parameters:

[
  "01938874-4d1f-7070-bf0a-a939b19bc3e9"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.install_errors AS install_errors_1,
  t0.id AS id_2,
  t0.create_at AS create_at_3,
  t0.update_at AS update_at_4,
  t0.uuid AS uuid_5,
  t0.insales_login AS insales_login_6,
  t0.insales_password AS insales_password_7,
  t0.insales_host AS insales_host_8,
  t0.insales_connected AS insales_connected_9,
  t0.insales_widget_token AS insales_widget_token_10,
  t0.insales_payment_id AS insales_payment_id_11,
  t0.insales_payment_password AS insales_payment_password_12,
  t0.bspb_ssl_key AS bspb_ssl_key_13,
  t0.bspb_ssl_cert AS bspb_ssl_cert_14,
  t0.bspb_url AS bspb_url_15,
  t0.bspb_scheme AS bspb_scheme_16,
  t0.bspb_merchant AS bspb_merchant_17,
  t0.bspb_password AS bspb_password_18,
  t0.bspb_en_log AS bspb_en_log_19,
  t0.bspb_en_no_basket_form AS bspb_en_no_basket_form_20,
  t0.bspb_is_ofd AS bspb_is_ofd_21,
  t22.email AS email_23,
  t22.password AS password_24,
  t22.password_reset_token AS password_reset_token_25,
  t22.id AS id_26,
  t22.create_at AS create_at_27,
  t22.update_at AS update_at_28,
  t22.active AS active_29,
  t22.uuid AS uuid_30,
  t22.application_id AS application_id_31
FROM
  application t0
  LEFT JOIN users t22 ON t22.application_id = t0.id
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.install_errors AS install_errors_1, t0.id AS id_2, t0.create_at AS create_at_3, t0.update_at AS update_at_4, t0.uuid AS uuid_5, t0.insales_login AS insales_login_6, t0.insales_password AS insales_password_7, t0.insales_host AS insales_host_8, t0.insales_connected AS insales_connected_9, t0.insales_widget_token AS insales_widget_token_10, t0.insales_payment_id AS insales_payment_id_11, t0.insales_payment_password AS insales_payment_password_12, t0.bspb_ssl_key AS bspb_ssl_key_13, t0.bspb_ssl_cert AS bspb_ssl_cert_14, t0.bspb_url AS bspb_url_15, t0.bspb_scheme AS bspb_scheme_16, t0.bspb_merchant AS bspb_merchant_17, t0.bspb_password AS bspb_password_18, t0.bspb_en_log AS bspb_en_log_19, t0.bspb_en_no_basket_form AS bspb_en_no_basket_form_20, t0.bspb_is_ofd AS bspb_is_ofd_21, t22.email AS email_23, t22.password AS password_24, t22.password_reset_token AS password_reset_token_25, t22.id AS id_26, t22.create_at AS create_at_27, t22.update_at AS update_at_28, t22.active AS active_29, t22.uuid AS uuid_30, t22.application_id AS application_id_31 FROM application t0 LEFT JOIN users t22 ON t22.application_id = t0.id WHERE t0.uuid = '01938874-4d1f-7070-bf0a-a939b19bc3e9' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 72)
4	App\Core\Infrastructure\Repository\ApplicationRepository->findOneByUuid (line 22)
5	App\Core\Application\Query\Application\GetApplication\GetApplicationQueryHandler->__invoke (line 152)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 91)
7	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 71)
8	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 33)
9	Symfony\Bridge\Doctrine\Messenger\DoctrineTransactionMiddleware->handleForManager (line 45)
10	Symfony\Bridge\Doctrine\Messenger\AbstractDoctrineMiddleware->handle (line 45)
11	Symfony\Component\Messenger\Middleware\ValidationMiddleware->handle (line 34)
12	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
13	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
14	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
15	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
16	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
17	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
18	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 40)
19	App\Core\Infrastructure\Handler\Handler->handle (line 45)
20	App\Core\Ports\Http\Payment\PaymentOrderAction->__invoke (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.30 ms
(6.89%)

UPDATE orders SET bspb_id = ?, bspb_password = ?, bspb_hpp_url = ?, bspb_redirect_url = ?, bspb_access_token = ?, bspb_payment_sum = ?, bspb_items = ?, update_at = ? WHERE id = ?

Parameters:

[
  "2000000014546"
  "1oed3eg0dhciy"
  "https://pgtest.bspb.ru/flex"
  "https://pgtest.bspb.ru/flex?id=2000000014546&password=1oed3eg0dhciy"
  "0-MtX_dQ57ciaHibfMJdlL0c3xE62zuAk4bcTpq80ytxg"
  1225.0
  "[{"is_delivery":false,"title":"Ward\u00e9 EDP","unit":"pce","full_sale_price":1000.0,"quantity":1},{"is_delivery":true,"title":"fivepost","unit":"255","full_sale_price":225.0,"quantity":1}]"
  "2025-01-20 14:11:15"
  15
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  orders
SET
  bspb_id = ?,
  bspb_password = ?,
  bspb_hpp_url = ?,
  bspb_redirect_url = ?,
  bspb_access_token = ?,
  bspb_payment_sum = ?,
  bspb_items = ?,
  update_at = ?
WHERE
  id = ?

UPDATE orders SET bspb_id = '2000000014546', bspb_password = '1oed3eg0dhciy', bspb_hpp_url = 'https://pgtest.bspb.ru/flex', bspb_redirect_url = 'https://pgtest.bspb.ru/flex?id=2000000014546&password=1oed3eg0dhciy', bspb_access_token = '0-MtX_dQ57ciaHibfMJdlL0c3xE62zuAk4bcTpq80ytxg', bspb_payment_sum = 1225, bspb_items = '[{\"is_delivery\":false,\"title\":\"Ward\\u00e9 EDP\",\"unit\":\"pce\",\"full_sale_price\":1000.0,\"quantity\":1},{\"is_delivery\":true,\"title\":\"fivepost\",\"unit\":\"255\",\"full_sale_price\":225.0,\"quantity\":1}]', update_at = '2025-01-20 14:11:15' WHERE id = 15;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 58)
7	App\Core\Infrastructure\Repository\OrderRepository->update (line 170)
8	App\Core\Application\Command\Bspb\CreateOrder\CreateOrderCommandHandler->__invoke (line 152)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 91)
10	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 71)
11	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 33)
12	Symfony\Bridge\Doctrine\Messenger\DoctrineTransactionMiddleware->handleForManager (line 45)
13	Symfony\Bridge\Doctrine\Messenger\AbstractDoctrineMiddleware->handle (line 45)
14	Symfony\Component\Messenger\Middleware\ValidationMiddleware->handle (line 34)
15	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
16	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
17	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
18	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
19	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
20	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
21	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 40)
22	App\Core\Infrastructure\Handler\Handler->handle (line 90)
23	App\Core\Ports\Http\Payment\PaymentOrderAction->__invoke (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.28 ms
(6.48%)

INSERT INTO orders (create_at, update_at, uuid, insales_order_id, insales_key, insales_comment, insales_currency, insales_number, insales_items, insales_client, insales_total_price, insales_items_price, insales_payed, insales_transaction_id, insales_delivery_price, insales_delivery_name, bspb_id, bspb_password, bspb_hpp_url, bspb_redirect_url, bspb_access_token, bspb_status, bspb_prev_status, bspb_last_cli_update, bspb_payment_date, bspb_payment_sum, bspb_items, bspb_refund, bspb_refund_date, application_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "2025-01-20 14:11:14"
  "2025-01-20 14:11:14"
  "01948368-db43-795a-9314-993f855b615d"
  128213691
  "7fac0878fd5f3f361a70d7a478dcfbab"
  ""
  "RUB"
  "1617"
  "[{"id":702463322,"order_id":128213691,"sale_price":2000.0,"full_sale_price":1000.0,"total_price":2000.0,"full_total_price":1000.0,"discounts_amount":1000.0,"quantity":1,"reserved_quantity":1,"weight":"0.1","dimensions":null,"variant_id":748932689,"product_id":451752125,"sku":"192295","barcode":null,"title":"Ward\u00e9 EDP","unit":"pce","comment":null,"updated_at":"2025-01-20T14:11:09.000+03:00","created_at":"2025-01-20T14:11:09.000+03:00","bundle_id":null,"vat":20,"fiscal_product_type":1,"requires_marking":null,"marking_codes":null,"accessory_lines":[],"external_variant_id":"192295"}]"
  "{"id":85829521,"email":"a@mail.ru","name":"\u0424\u044b\u0432\u0430 \u0424\u044b\u0432\u0430","phone":"89000000000","created_at":"2025-01-20T14:11:09.000+03:00","updated_at":"2025-01-20T14:11:09.000+03:00","comment":null,"registered":false,"subscribe":true,"client_group_id":null,"surname":"","middlename":null,"bonus_points":0,"type":"Client::Individual","correspondent_account":null,"settlement_account":null,"consent_to_personal_data":null,"o_auth_provider":null,"messenger_subscription":null,"contact_name":"\u0424\u044b\u0432\u0430 \u0424\u044b\u0432\u0430","progressive_discount":null,"group_discount":null,"ip_addr":"46.160.232.219","fields_values":[]}"
  1225.0
  1000.0
  0
  null
  225.0
  "fivepost"
  null
  null
  null
  null
  null
  "NEW"
  "NEW"
  null
  null
  null
  null
  0
  null
  1
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO orders (
  create_at, update_at, uuid, insales_order_id,
  insales_key, insales_comment, insales_currency,
  insales_number, insales_items, insales_client,
  insales_total_price, insales_items_price,
  insales_payed, insales_transaction_id,
  insales_delivery_price, insales_delivery_name,
  bspb_id, bspb_password, bspb_hpp_url,
  bspb_redirect_url, bspb_access_token,
  bspb_status, bspb_prev_status, bspb_last_cli_update,
  bspb_payment_date, bspb_payment_sum,
  bspb_items, bspb_refund, bspb_refund_date,
  application_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO orders (create_at, update_at, uuid, insales_order_id, insales_key, insales_comment, insales_currency, insales_number, insales_items, insales_client, insales_total_price, insales_items_price, insales_payed, insales_transaction_id, insales_delivery_price, insales_delivery_name, bspb_id, bspb_password, bspb_hpp_url, bspb_redirect_url, bspb_access_token, bspb_status, bspb_prev_status, bspb_last_cli_update, bspb_payment_date, bspb_payment_sum, bspb_items, bspb_refund, bspb_refund_date, application_id) VALUES ('2025-01-20 14:11:14', '2025-01-20 14:11:14', '01948368-db43-795a-9314-993f855b615d', 128213691, '7fac0878fd5f3f361a70d7a478dcfbab', '', 'RUB', '1617', '[{\"id\":702463322,\"order_id\":128213691,\"sale_price\":2000.0,\"full_sale_price\":1000.0,\"total_price\":2000.0,\"full_total_price\":1000.0,\"discounts_amount\":1000.0,\"quantity\":1,\"reserved_quantity\":1,\"weight\":\"0.1\",\"dimensions\":null,\"variant_id\":748932689,\"product_id\":451752125,\"sku\":\"192295\",\"barcode\":null,\"title\":\"Ward\\u00e9 EDP\",\"unit\":\"pce\",\"comment\":null,\"updated_at\":\"2025-01-20T14:11:09.000+03:00\",\"created_at\":\"2025-01-20T14:11:09.000+03:00\",\"bundle_id\":null,\"vat\":20,\"fiscal_product_type\":1,\"requires_marking\":null,\"marking_codes\":null,\"accessory_lines\":[],\"external_variant_id\":\"192295\"}]', '{\"id\":85829521,\"email\":\"a@mail.ru\",\"name\":\"\\u0424\\u044b\\u0432\\u0430 \\u0424\\u044b\\u0432\\u0430\",\"phone\":\"89000000000\",\"created_at\":\"2025-01-20T14:11:09.000+03:00\",\"updated_at\":\"2025-01-20T14:11:09.000+03:00\",\"comment\":null,\"registered\":false,\"subscribe\":true,\"client_group_id\":null,\"surname\":\"\",\"middlename\":null,\"bonus_points\":0,\"type\":\"Client::Individual\",\"correspondent_account\":null,\"settlement_account\":null,\"consent_to_personal_data\":null,\"o_auth_provider\":null,\"messenger_subscription\":null,\"contact_name\":\"\\u0424\\u044b\\u0432\\u0430 \\u0424\\u044b\\u0432\\u0430\",\"progressive_discount\":null,\"group_discount\":null,\"ip_addr\":\"46.160.232.219\",\"fields_values\":[]}', 1225, 1000, 0, NULL, 225, 'fivepost', NULL, NULL, NULL, NULL, NULL, 'NEW', 'NEW', NULL, NULL, NULL, NULL, 0, NULL, 1);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 251)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1051)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 400)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 58)
7	App\Core\Infrastructure\Repository\OrderRepository->update (line 75)
8	App\Core\Application\Command\Insales\Order\DownloadOrder\DownloadOrderCommandHandler->__invoke (line 152)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 91)
10	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 71)
11	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 33)
12	Symfony\Bridge\Doctrine\Messenger\DoctrineTransactionMiddleware->handleForManager (line 45)
13	Symfony\Bridge\Doctrine\Messenger\AbstractDoctrineMiddleware->handle (line 45)
14	Symfony\Component\Messenger\Middleware\ValidationMiddleware->handle (line 34)
15	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
16	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
17	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
18	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
19	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
20	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
21	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 40)
22	App\Core\Infrastructure\Handler\Handler->handle (line 65)
23	App\Core\Ports\Http\Payment\PaymentOrderAction->__invoke (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.26 ms
(5.93%)

SAVEPOINT DOCTRINE_2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 1611)
2	Doctrine\DBAL\Connection->createSavepoint (line 1401)
3	Doctrine\DBAL\Connection->beginTransaction (line 379)
4	Doctrine\ORM\UnitOfWork->commit (line 264)
5	Doctrine\ORM\EntityManager->flush (line 58)
6	App\Core\Infrastructure\Repository\OrderRepository->update (line 75)
7	App\Core\Application\Command\Insales\Order\DownloadOrder\DownloadOrderCommandHandler->__invoke (line 152)
8	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 91)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 71)
10	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 33)
11	Symfony\Bridge\Doctrine\Messenger\DoctrineTransactionMiddleware->handleForManager (line 45)
12	Symfony\Bridge\Doctrine\Messenger\AbstractDoctrineMiddleware->handle (line 45)
13	Symfony\Component\Messenger\Middleware\ValidationMiddleware->handle (line 34)
14	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
15	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
16	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
17	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
18	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
19	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
20	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 40)
21	App\Core\Infrastructure\Handler\Handler->handle (line 65)
22	App\Core\Ports\Http\Payment\PaymentOrderAction->__invoke (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.17 ms
(3.92%)

RELEASE SAVEPOINT DOCTRINE_2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 1645)
2	Doctrine\DBAL\Connection->releaseSavepoint (line 1456)
3	Doctrine\DBAL\Connection->commit (line 430)
4	Doctrine\ORM\UnitOfWork->commit (line 264)
5	Doctrine\ORM\EntityManager->flush (line 58)
6	App\Core\Infrastructure\Repository\OrderRepository->update (line 75)
7	App\Core\Application\Command\Insales\Order\DownloadOrder\DownloadOrderCommandHandler->__invoke (line 152)
8	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 91)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 71)
10	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 33)
11	Symfony\Bridge\Doctrine\Messenger\DoctrineTransactionMiddleware->handleForManager (line 45)
12	Symfony\Bridge\Doctrine\Messenger\AbstractDoctrineMiddleware->handle (line 45)
13	Symfony\Component\Messenger\Middleware\ValidationMiddleware->handle (line 34)
14	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
15	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
16	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
17	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
18	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
19	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
20	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 40)
21	App\Core\Infrastructure\Handler\Handler->handle (line 65)
22	App\Core\Ports\Http\Payment\PaymentOrderAction->__invoke (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.15 ms
(3.52%)

UPDATE orders SET insales_transaction_id = ?, update_at = ? WHERE id = ?

Parameters:

[
  "28512767"
  "2025-01-20 14:11:15"
  15
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  orders
SET
  insales_transaction_id = ?,
  update_at = ?
WHERE
  id = ?

UPDATE orders SET insales_transaction_id = '28512767', update_at = '2025-01-20 14:11:15' WHERE id = 15;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 58)
7	App\Core\Infrastructure\Repository\OrderRepository->update (line 28)
8	App\Core\Application\Command\Insales\Order\CheckPaymentOrder\CheckPaymentOrderCommandHandler->__invoke (line 152)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 91)
10	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 71)
11	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 33)
12	Symfony\Bridge\Doctrine\Messenger\DoctrineTransactionMiddleware->handleForManager (line 45)
13	Symfony\Bridge\Doctrine\Messenger\AbstractDoctrineMiddleware->handle (line 45)
14	Symfony\Component\Messenger\Middleware\ValidationMiddleware->handle (line 34)
15	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
16	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
17	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
18	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
19	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
20	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
21	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 40)
22	App\Core\Infrastructure\Handler\Handler->handle (line 81)
23	App\Core\Ports\Http\Payment\PaymentOrderAction->__invoke (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.09 ms
(2.13%)

"ROLLBACK"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"ROLLBACK"

"ROLLBACK";

#	File/Call
1	Doctrine\DBAL\Connection->rollBack (line 52)
2	Symfony\Bridge\Doctrine\Messenger\DoctrineTransactionMiddleware->handleForManager (line 45)
3	Symfony\Bridge\Doctrine\Messenger\AbstractDoctrineMiddleware->handle (line 45)
4	Symfony\Component\Messenger\Middleware\ValidationMiddleware->handle (line 34)
5	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
6	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
7	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
8	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
9	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
10	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
11	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 40)
12	App\Core\Infrastructure\Handler\Handler->handle (line 54)
13	App\Core\Ports\Http\Payment\PaymentOrderAction->__invoke (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	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\Core\Domain\Model\User	No errors.
App\Core\Domain\Model\Embedded\Application\Insales	No errors.
App\Core\Domain\Model\Embedded\Application\Bspb	No errors.
App\Core\Domain\Model\Application	No errors.
App\Core\Domain\Model\Embedded\Order\Insales	No errors.
App\Core\Domain\Model\Embedded\Order\Bspb	No errors.
App\Core\Domain\Model\Order	No errors.

Symfony Profiler

POST https://bspb.insales.services.ipol.tech/payment/01938874-4d1f-7070-bf0a-a939b19bc3e9/order

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping