Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

6.65 ms Query time

0 Invalid entities

0 Managed entities

Time▼

Count

Info

6.39 ms
(96.02%)

SELECT COUNT(id) FROM user_audit at WHERE object_id = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id)
FROM
  user_audit at
WHERE
  object_id = ?

SELECT COUNT(id) FROM user_audit at WHERE object_id = '1';

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
2	DH\Auditor\Provider\Doctrine\Persistence\Reader\Query->count (line 111)
3	DH\Auditor\Provider\Doctrine\Persistence\Reader\Reader->paginate (line 127)
4	DH\AuditorBundle\Controller\ViewerController->showEntityHistoryAction (line 87)
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.26 ms
(3.98%)

SELECT * FROM user_audit at WHERE object_id = ? ORDER BY created_at DESC, id DESC LIMIT 50

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  user_audit at
WHERE
  object_id = ?
ORDER BY
  created_at DESC,
  id DESC
LIMIT
  50

SELECT * FROM user_audit at WHERE object_id = '1' ORDER BY created_at DESC, id DESC LIMIT 50;

#	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->paginate (line 133)
4	DH\AuditorBundle\Controller\ViewerController->showEntityHistoryAction (line 87)
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)

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Amount of managed objects

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.