Symfony Profiler

Query Metrics

7 Database Queries

5 Different statements

0.88 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.21 ms
(24.18%)

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.id = ?

Parameters:

[
  1
]

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.id = ?

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.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Core\Domain\Model\Application::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Core\Domain\Model\Application->__get (line 43)
8	App\Core\Domain\Model\Application->getInsales (line 92)
9	App\Core\Ports\Http\Configuration\InsalesAction->__invoke (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.19 ms
(21.21%)

SELECT t0.email AS email_1, t0.password AS password_2, t0.password_reset_token AS password_reset_token_3, t0.id AS id_4, t0.create_at AS create_at_5, t0.update_at AS update_at_6, t0.active AS active_7, t0.uuid AS uuid_8, t0.application_id AS application_id_9 FROM users t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.email AS email_1,
  t0.password AS password_2,
  t0.password_reset_token AS password_reset_token_3,
  t0.id AS id_4,
  t0.create_at AS create_at_5,
  t0.update_at AS update_at_6,
  t0.active AS active_7,
  t0.uuid AS uuid_8,
  t0.application_id AS application_id_9
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.email AS email_1, t0.password AS password_2, t0.password_reset_token AS password_reset_token_3, t0.id AS id_4, t0.create_at AS create_at_5, t0.update_at AS update_at_6, t0.active AS active_7, t0.uuid AS uuid_8, t0.application_id AS application_id_9 FROM users t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.17 ms
(18.93%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1423)
2	Doctrine\DBAL\Connection->commit (line 33)
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 40)
14	App\Core\Ports\Http\Configuration\InsalesAction->__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.16 ms
(18.57%)

SELECT t0.email AS email_1, t0.password AS password_2, t0.password_reset_token AS password_reset_token_3, t0.id AS id_4, t0.create_at AS create_at_5, t0.update_at AS update_at_6, t0.active AS active_7, t0.uuid AS uuid_8, t0.application_id AS application_id_9 FROM users t0 WHERE t0.uuid = ? LIMIT 1

Parameters:

[
  "01937c92-bfcd-721e-bed5-c9841e94092a"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.email AS email_1,
  t0.password AS password_2,
  t0.password_reset_token AS password_reset_token_3,
  t0.id AS id_4,
  t0.create_at AS create_at_5,
  t0.update_at AS update_at_6,
  t0.active AS active_7,
  t0.uuid AS uuid_8,
  t0.application_id AS application_id_9
FROM
  users t0
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.email AS email_1, t0.password AS password_2, t0.password_reset_token AS password_reset_token_3, t0.id AS id_4, t0.create_at AS create_at_5, t0.update_at AS update_at_6, t0.active AS active_7, t0.uuid AS uuid_8, t0.application_id AS application_id_9 FROM users t0 WHERE t0.uuid = '01937c92-bfcd-721e-bed5-c9841e94092a' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 67)
4	App\Core\Infrastructure\Repository\UserRepository->findOneByUuid (line 23)
5	App\Core\Application\Query\User\GetByUuid\GetByUuidQueryHandler->__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 31)
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 40)
20	App\Core\Ports\Http\Configuration\InsalesAction->__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.15 ms
(17.11%)

"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 40)
13	App\Core\Ports\Http\Configuration\InsalesAction->__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.

Symfony Profiler

GET https://bspb.insales.services.ipol.tech/configuration/01937c92-bfcd-721e-bed5-c9841e94092a/insales

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping