Symfony Profiler

Query Metrics

6 Database Queries

3 Different statements

8.16 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.46 ms
(79.19%)

SELECT * FROM user_audit at WHERE transaction_hash = ? ORDER BY created_at DESC, id DESC

Parameters:

[
  "77305fcc727b422f2dafb8d00a83def3461dc23e"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  user_audit at
WHERE
  transaction_hash = ?
ORDER BY
  created_at DESC,
  id DESC

SELECT * FROM user_audit at WHERE transaction_hash = '77305fcc727b422f2dafb8d00a83def3461dc23e' ORDER BY created_at DESC, id DESC;

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
2	DH\Auditor\Provider\Doctrine\Persistence\Reader\Query->execute (line 85)
3	DH\Auditor\Provider\Doctrine\Persistence\Reader\Reader->getAuditsByTransactionHash (line 107)
4	DH\AuditorBundle\Controller\ViewerController->showTransactionAction (line 62)
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)

1.26 ms
(15.40%)

SELECT * FROM partners_audit at WHERE (discriminator = ?) AND (transaction_hash = ?) ORDER BY created_at DESC, id DESC

Parameters:

[
  "App\Entity\Partner\ConsumableSupplier"
  "77305fcc727b422f2dafb8d00a83def3461dc23e"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  partners_audit at
WHERE
  (discriminator = ?)
  AND (transaction_hash = ?)
ORDER BY
  created_at DESC,
  id DESC

SELECT * FROM partners_audit at WHERE (discriminator = 'App\\Entity\\Partner\\ConsumableSupplier') AND (transaction_hash = '77305fcc727b422f2dafb8d00a83def3461dc23e') ORDER BY created_at DESC, id DESC;

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
2	DH\Auditor\Provider\Doctrine\Persistence\Reader\Query->execute (line 85)
3	DH\Auditor\Provider\Doctrine\Persistence\Reader\Reader->getAuditsByTransactionHash (line 107)
4	DH\AuditorBundle\Controller\ViewerController->showTransactionAction (line 62)
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.44 ms
(5.41%)

SELECT * FROM equipment_audit at WHERE transaction_hash = ? ORDER BY created_at DESC, id DESC

Parameters:

[
  "77305fcc727b422f2dafb8d00a83def3461dc23e"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  equipment_audit at
WHERE
  transaction_hash = ?
ORDER BY
  created_at DESC,
  id DESC

SELECT * FROM equipment_audit at WHERE transaction_hash = '77305fcc727b422f2dafb8d00a83def3461dc23e' ORDER BY created_at DESC, id DESC;

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
2	DH\Auditor\Provider\Doctrine\Persistence\Reader\Query->execute (line 85)
3	DH\Auditor\Provider\Doctrine\Persistence\Reader\Reader->getAuditsByTransactionHash (line 107)
4	DH\AuditorBundle\Controller\ViewerController->showTransactionAction (line 62)
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)

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

Entities Mapping

Class	Mapping 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\User\Role	No errors.
App\Entity\User\User	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Test\TestType	No errors.
App\Entity\Test\TestCategory	No errors.
App\Entity\Common\Country	No errors.
App\Entity\Common\AppFile	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

GET https://strange-jones.95-216-76-58.plesk.page/audit/transaction/77305fcc727b422f2dafb8d00a83def3461dc23e

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping