Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

4.83 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.67 ms
(34.58%)

"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 433)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\Service\LogService->log (line 54)
5	App\EventListener\ApiResourceResponseListener->__invoke (line 61)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
10	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 6)

1.17 ms
(24.31%)

INSERT INTO log (type, data, method, endpoint, http_status, duration, keywords, position, id, created_at, access_point_id, application_id, client_id, participant_id, tenant_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "api_resource_request"
  "{"endpoint":"\/api\/tenants\/{id}.{_format}","path":"\/api\/tenants\/1f0f2b37-d2d8-6a14-970e-1fae92ab525e","method":"GET","class":"App\\Entity\\Tenant","payload_content":"","response_status":200,"response_content":"{\"client\":{\"id\":\"1f0f1e95-871d-6d6c-9238-c76791cfa0f7\"},\"application\":{\"id\":\"1f0affb7-9aba-6bd2-9389-a58a9e3402d9\"},\"token\":\"mmOzfxb7RMCFrn3P-NZC14NPb4DBw1KA0DGfqcszHtumOmcvYbHQ28x4pd1YioiFcYD0_LkhKPSuujL_nzls5A\",\"expires_at\":\"2026-03-01T10:30:02+01:00\",\"id\":\"1f0f2b37-d2d8-6a14-970e-1fae92ab525e\"}"}"
  "GET"
  "/api/tenants/{id}.{_format}"
  200
  0.11468982696533
  "apiresourcerequest get apitenantsidformat 200 011468982696533 optipro endpointapitenantsidformatpathapitenants1f0f2b37d2d86a14970e1fae92ab525emethodgetclassappentitytenantpayloadcontentresponsestatus200responsecontentclientid1f0f1e95871d6d6c9238c76791cfa0f7applicationid1f0affb79aba6bd29389a58a9e3402d9tokenmmozfxb7rmcfrn3pnzc14npb4dbw1ka0dgfqcszhtumomcvybhq28x4pd1yioifcyd0lkhkpsuujlnzls5aexpiresat20260301t1030020100id1f0f2b37d2d86a14970e1fae92ab525e"
  null
  "1f10d903-fbb4-6bf6-b34f-99ea8a6a9487"
  "2026-02-19 13:41:02"
  null
  "1f0affb7-9aba-6bd2-9389-a58a9e3402d9"
  null
  null
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO log (
  type, data, method, endpoint, http_status,
  duration, keywords, position, id,
  created_at, access_point_id, application_id,
  client_id, participant_id, tenant_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO log (type, data, method, endpoint, http_status, duration, keywords, position, id, created_at, access_point_id, application_id, client_id, participant_id, tenant_id) VALUES ('api_resource_request', '{\"endpoint\":\"\\/api\\/tenants\\/{id}.{_format}\",\"path\":\"\\/api\\/tenants\\/1f0f2b37-d2d8-6a14-970e-1fae92ab525e\",\"method\":\"GET\",\"class\":\"App\\\\Entity\\\\Tenant\",\"payload_content\":\"\",\"response_status\":200,\"response_content\":\"{\\\"client\\\":{\\\"id\\\":\\\"1f0f1e95-871d-6d6c-9238-c76791cfa0f7\\\"},\\\"application\\\":{\\\"id\\\":\\\"1f0affb7-9aba-6bd2-9389-a58a9e3402d9\\\"},\\\"token\\\":\\\"mmOzfxb7RMCFrn3P-NZC14NPb4DBw1KA0DGfqcszHtumOmcvYbHQ28x4pd1YioiFcYD0_LkhKPSuujL_nzls5A\\\",\\\"expires_at\\\":\\\"2026-03-01T10:30:02+01:00\\\",\\\"id\\\":\\\"1f0f2b37-d2d8-6a14-970e-1fae92ab525e\\\"}\"}', 'GET', '/api/tenants/{id}.{_format}', 200, 0.11468982696533, 'apiresourcerequest get apitenantsidformat 200 011468982696533 optipro endpointapitenantsidformatpathapitenants1f0f2b37d2d86a14970e1fae92ab525emethodgetclassappentitytenantpayloadcontentresponsestatus200responsecontentclientid1f0f1e95871d6d6c9238c76791cfa0f7applicationid1f0affb79aba6bd29389a58a9e3402d9tokenmmozfxb7rmcfrn3pnzc14npb4dbw1ka0dgfqcszhtumomcvybhq28x4pd1yioifcyd0lkhkpsuujlnzls5aexpiresat20260301t1030020100id1f0f2b37d2d86a14970e1fae92ab525e', NULL, '1f10d903-fbb4-6bf6-b34f-99ea8a6a9487', '2026-02-19 13:41:02', NULL, '1f0affb7-9aba-6bd2-9389-a58a9e3402d9', NULL, NULL, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\LogService->log (line 54)
7	App\EventListener\ApiResourceResponseListener->__invoke (line 61)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 182)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 6)

1.02 ms
(21.10%)

SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.revoked AS revoked_4, t0.expires_at AS expires_at_5, t0.used_at AS used_at_6, t0.value AS value_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.application_id AS application_id_11 FROM application_token t0 WHERE t0.value = ? AND t0.enabled = ? AND t0.revoked = ? LIMIT 1

Parameters:

[
  "GPPy0oEmq0e-G73kgd2KpsZYfXpFGzy1GVWn476AWyo0IvkXOsZVwM9LT4Q89zeZNYXKSqMfInft1EaWxctp5w"
  1
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.enabled AS enabled_3,
  t0.revoked AS revoked_4,
  t0.expires_at AS expires_at_5,
  t0.used_at AS used_at_6,
  t0.value AS value_7,
  t0.id AS id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.application_id AS application_id_11
FROM
  application_token t0
WHERE
  t0.value = ?
  AND t0.enabled = ?
  AND t0.revoked = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.revoked AS revoked_4, t0.expires_at AS expires_at_5, t0.used_at AS used_at_6, t0.value AS value_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.application_id AS application_id_11 FROM application_token t0 WHERE t0.value = 'GPPy0oEmq0e-G73kgd2KpsZYfXpFGzy1GVWn476AWyo0IvkXOsZVwM9LT4Q89zeZNYXKSqMfInft1EaWxctp5w' AND t0.enabled = 1 AND t0.revoked = 0 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Security\BearerAuthenticator->authenticate (line 46)
5	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 74)
6	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 185)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
9	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
12	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 6)

0.71 ms
(14.60%)

SELECT t0_.url AS url_0, t0_.token AS token_1, t0_.enabled AS enabled_2, t0_.revoked AS revoked_3, t0_.expires_at AS expires_at_4, t0_.data AS data_5, t0_.id AS id_6, t0_.created_at AS created_at_7, t0_.updated_at AS updated_at_8, c1_.name AS name_9, c1_.data AS data_10, c1_.keywords AS keywords_11, c1_.id AS id_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, a2_.code AS code_15, a2_.name AS name_16, a2_.description AS description_17, a2_.enabled AS enabled_18, a2_.data AS data_19, a2_.id AS id_20, a2_.created_at AS created_at_21, a2_.updated_at AS updated_at_22, t0_.client_id AS client_id_23, t0_.application_id AS application_id_24, a2_.creator_id AS creator_id_25 FROM tenant t0_ INNER JOIN client c1_ ON t0_.client_id = c1_.id INNER JOIN application a2_ ON t0_.application_id = a2_.id WHERE t0_.id = ?

Parameters:

[
  "1f0f2b37-d2d8-6a14-970e-1fae92ab525e"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.url AS url_0,
  t0_.token AS token_1,
  t0_.enabled AS enabled_2,
  t0_.revoked AS revoked_3,
  t0_.expires_at AS expires_at_4,
  t0_.data AS data_5,
  t0_.id AS id_6,
  t0_.created_at AS created_at_7,
  t0_.updated_at AS updated_at_8,
  c1_.name AS name_9,
  c1_.data AS data_10,
  c1_.keywords AS keywords_11,
  c1_.id AS id_12,
  c1_.created_at AS created_at_13,
  c1_.updated_at AS updated_at_14,
  a2_.code AS code_15,
  a2_.name AS name_16,
  a2_.description AS description_17,
  a2_.enabled AS enabled_18,
  a2_.data AS data_19,
  a2_.id AS id_20,
  a2_.created_at AS created_at_21,
  a2_.updated_at AS updated_at_22,
  t0_.client_id AS client_id_23,
  t0_.application_id AS application_id_24,
  a2_.creator_id AS creator_id_25
FROM
  tenant t0_
  INNER JOIN client c1_ ON t0_.client_id = c1_.id
  INNER JOIN application a2_ ON t0_.application_id = a2_.id
WHERE
  t0_.id = ?

SELECT t0_.url AS url_0, t0_.token AS token_1, t0_.enabled AS enabled_2, t0_.revoked AS revoked_3, t0_.expires_at AS expires_at_4, t0_.data AS data_5, t0_.id AS id_6, t0_.created_at AS created_at_7, t0_.updated_at AS updated_at_8, c1_.name AS name_9, c1_.data AS data_10, c1_.keywords AS keywords_11, c1_.id AS id_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, a2_.code AS code_15, a2_.name AS name_16, a2_.description AS description_17, a2_.enabled AS enabled_18, a2_.data AS data_19, a2_.id AS id_20, a2_.created_at AS created_at_21, a2_.updated_at AS updated_at_22, t0_.client_id AS client_id_23, t0_.application_id AS application_id_24, a2_.creator_id AS creator_id_25 FROM tenant t0_ INNER JOIN client c1_ ON t0_.client_id = c1_.id INNER JOIN application a2_ ON t0_.application_id = a2_.id WHERE t0_.id = '1f0f2b37-d2d8-6a14-970e-1fae92ab525e';

#	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->getOneOrNullResult (line 737)
6	ApiPlatform\Doctrine\Orm\State\ItemProvider->provide (line 89)
7	ApiPlatform\State\CallableProvider->provide (line 43)
8	ApiPlatform\State\Provider\ReadProvider->provide (line 84)
9	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
10	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
11	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 50)
12	ApiPlatform\State\Provider\DeserializeProvider->provide (line 60)
13	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
14	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 32)
15	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
16	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 102)
17	ApiPlatform\State\Provider\ParameterProvider->provide (line 102)
18	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 56)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 83)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 6)

0.23 ms
(4.66%)

SELECT t0.code AS code_1, t0.name AS name_2, t0.description AS description_3, t0.enabled AS enabled_4, t0.data AS data_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.creator_id AS creator_id_9 FROM application t0 WHERE t0.id = ?

Parameters:

[
  "1f0affb7-9aba-6bd2-9389-a58a9e3402d9"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.enabled AS enabled_4,
  t0.data AS data_5,
  t0.id AS id_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.creator_id AS creator_id_9
FROM
  application t0
WHERE
  t0.id = ?

SELECT t0.code AS code_1, t0.name AS name_2, t0.description AS description_3, t0.enabled AS enabled_4, t0.data AS data_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.creator_id AS creator_id_9 FROM application t0 WHERE t0.id = '1f0affb7-9aba-6bd2-9389-a58a9e3402d9';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Application::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Application->__get (line 153)
7	App\Entity\Application->isEnabled (line 106)
8	App\Security\BearerAuthenticator->authenticate (line 56)
9	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 74)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 185)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
13	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
14	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
15	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
16	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
17	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 6)

0.04 ms
(0.75%)

"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 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\LogService->log (line 54)
4	App\EventListener\ApiResourceResponseListener->__invoke (line 61)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
9	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 6)

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\ApplicationToken	1
App\Entity\Application	1
App\Entity\Tenant	1
App\Entity\Client	1
App\Entity\Log	1

Entities Mapping

Class	Mapping errors
App\Entity\ApplicationToken	No errors.
App\Entity\Application	No errors.
App\Entity\User	No errors.
App\Entity\ApplicationWebhook	No errors.
App\Entity\Tenant	No errors.
App\Entity\Route	No errors.
App\Entity\Log	No errors.
App\Entity\Client	No errors.
App\Entity\Participant	No errors.
App\Entity\AccessPoint	No errors.

Symfony Profiler

GET https://optipol-dev.easy2pdf.com/api/tenants/1f0f2b37-d2d8-6a14-970e-1fae92ab525e

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping