Symfony Profiler

Query Metrics

8 Database Queries

8 Different statements

2.19 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.61 ms
(27.93%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.full_name AS full_name_4, t0.email AS email_5, t0.active AS active_6, t0.verified AS verified_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.role_id AS role_id_11 FROM user t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.full_name AS full_name_4,
  t0.email AS email_5,
  t0.active AS active_6,
  t0.verified AS verified_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.role_id AS role_id_11
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.full_name AS full_name_4, t0.email AS email_5, t0.active AS active_6, t0.verified AS verified_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.role_id AS role_id_11 FROM user t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
9	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 61)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.34 ms
(15.68%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.issue_year AS issue_year_3, t0.expiry_date AS expiry_date_4, t0.description AS description_5, t0.standard_pdf_id AS standard_pdf_id_6, t0.replacement_standard_id AS replacement_standard_id_7 FROM standard t0 WHERE t0.code = ? LIMIT 2

Parameters:

[
  "EN IEC 60598-1:2021"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.issue_year AS issue_year_3,
  t0.expiry_date AS expiry_date_4,
  t0.description AS description_5,
  t0.standard_pdf_id AS standard_pdf_id_6,
  t0.replacement_standard_id AS replacement_standard_id_7
FROM
  standard t0
WHERE
  t0.code = ?
LIMIT
  2

SELECT t0.id AS id_1, t0.code AS code_2, t0.issue_year AS issue_year_3, t0.expiry_date AS expiry_date_4, t0.description AS description_5, t0.standard_pdf_id AS standard_pdf_id_6, t0.replacement_standard_id AS replacement_standard_id_7 FROM standard t0 WHERE t0.code = 'EN IEC 60598-1:2021' LIMIT 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntityValidator->validate (line 155)
4	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateInGroup (line 747)
5	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateClassNode (line 480)
6	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateObject (line 296)
7	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validate (line 126)
8	Symfony\Component\Form\Extension\Validator\Constraints\FormValidator->validate (line 105)
9	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateInGroup (line 747)
10	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateClassNode (line 480)
11	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateObject (line 296)
12	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validate (line 126)
13	Symfony\Component\Validator\Validator\RecursiveValidator->validate (line 81)
14	Symfony\Component\Validator\Validator\TraceableValidator->validate (line 58)
15	Symfony\Component\Form\Extension\Validator\EventListener\ValidationListener->validateForm (line 43)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch (line 28)
19	Symfony\Component\Form\Form->submit (line 585)
20	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 107)
21	Symfony\Component\Form\Form->handleRequest (line 414)
22	App\Controller\Test\StandardCRUDController->create (line 28)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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 5)

0.27 ms
(12.52%)

INSERT INTO app_file (path, name, mime_type, size, uploaded_at) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  "pdfs/standards/"
  "EN-IEC-60598-1-2021-RLV-en-69ef6f92de118.pdf"
  "application/pdf"
  10142239
  "2026-04-27 17:15:46"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO app_file (
  path, name, mime_type, size, uploaded_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO app_file (path, name, mime_type, size, uploaded_at) VALUES ('pdfs/standards/', 'EN-IEC-60598-1-2021-RLV-en-69ef6f92de118.pdf', 'application/pdf', 10142239, '2026-04-27 17:15:46');

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 255)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1059)
4	Doctrine\ORM\UnitOfWork->commit (line 402)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\Test\StandardCRUDController->create (line 50)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.22 ms
(10.10%)

"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 1391)
2	Doctrine\ORM\UnitOfWork->commit (line 381)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\Controller\Test\StandardCRUDController->create (line 50)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.21 ms
(9.64%)

INSERT INTO standard (code, issue_year, expiry_date, description, standard_pdf_id, replacement_standard_id) VALUES (?, ?, ?, ?, ?, ?)

Parameters:

[
  "EN IEC 60598-1:2021"
  2021
  null
  null
  42
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO standard (
  code, issue_year, expiry_date, description,
  standard_pdf_id, replacement_standard_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO standard (code, issue_year, expiry_date, description, standard_pdf_id, replacement_standard_id) VALUES ('EN IEC 60598-1:2021', 2021, NULL, NULL, 42, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 255)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1059)
4	Doctrine\ORM\UnitOfWork->commit (line 402)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\Test\StandardCRUDController->create (line 50)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.19 ms
(8.68%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM role t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  role t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM role t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\User\Role::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\User\Role->__get (line 153)
7	App\Entity\User\Role->getName (line 34)
8	App\Entity\User\User->getRoles (line 172)
9	Symfony\Component\Security\Http\Firewall\ContextListener->hasUserChanged (line 318)
10	Symfony\Component\Security\Http\Firewall\ContextListener::refreshUser (line 217)
11	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
13	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
14	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 61)
15	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
16	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.19 ms
(8.50%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	DH\Auditor\Provider\Doctrine\Auditing\DBAL\Middleware\AuditorConnection->commit (line 29)
2	Doctrine\DBAL\Connection->doCommit (line 1502)
3	Doctrine\DBAL\Connection->commit (line 1454)
4	Doctrine\ORM\UnitOfWork->commit (line 432)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\Test\StandardCRUDController->create (line 50)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.15 ms
(6.95%)

INSERT INTO standard_paragraph (paragraph, standard_id) VALUES (?, ?)

Parameters:

[
  "§10.2 & §10.2.1 & §4.9.2"
  29
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO standard_paragraph (paragraph, standard_id)
VALUES
  (?, ?)

INSERT INTO standard_paragraph (paragraph, standard_id) VALUES ('§10.2 & §10.2.1 & §4.9.2', 29);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 255)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1059)
4	Doctrine\ORM\UnitOfWork->commit (line 402)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\Test\StandardCRUDController->create (line 50)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
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\User\User	1
App\Entity\User\Role	1
App\Entity\Common\AppFile	1
App\Entity\Test\Standard	1
App\Entity\Test\StandardParagraph	1

Entities Mapping

Class	Mapping errors
App\Entity\User\User	No errors.
App\Entity\User\Role	No errors.
App\Entity\Test\Standard	No errors.
App\Entity\Common\AppFile	No errors.
App\Entity\Test\StandardParagraph	No errors.
App\Entity\Test\StandardAmd	No errors.
App\Entity\Test\TechnicalProcedure	No errors.
App\Entity\Test\TechnicalProcedureUnit	No errors.
App\Entity\Maintenance\MaintenanceOperation	No errors.
App\Entity\Maintenance\Calibration	No errors.
App\Entity\Maintenance\PreventiveMaintenance	No errors.
App\Entity\Maintenance\CorrectiveMaintenance	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Test\TechnicalProcedureBlock	No errors.
App\Entity\Test\TestType	No errors.
App\Entity\Test\TestCategory	No errors.
App\Entity\Common\Country	No errors.
App\Entity\Common\ContactInfo	No errors.
App\Entity\Partner\Partner	No errors.
App\Entity\Partner\ConsumableSupplier	No errors.
App\Entity\Partner\Supplier	No errors.
App\Entity\Partner\CalibrationLab	No errors.
App\Entity\Partner\PartnerCategory	No errors.
App\Entity\Partner\ServiceProvider	No errors.
App\Entity\Partner\Manufacturer	No errors.
App\Entity\Equipment\RelatedPart	No errors.
App\Entity\Equipment\Certificate	No errors.
App\Entity\Equipment\Unit	No errors.
App\Entity\Equipment\TechnicalFeature	No errors.
App\Entity\Equipment\TechnicalData	No errors.
App\Entity\Equipment\Consumable	No errors.
App\Entity\Equipment\ConsumableCategory	No errors.
App\Entity\Equipment\Place	No errors.
App\Entity\Equipment\EquipmentCategory	No errors.
App\Entity\Equipment\Equipment	No errors.
App\Entity\Equipment\UnitCategory	No errors.

Symfony Profiler

POST https://strange-jones.95-216-76-58.plesk.page/en/test/standard/create

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping