Symfony Profiler

Query Metrics

6 Database Queries

3 Different statements

3.27 ms Query time

0 Invalid entities

0 Managed entities

Time▼

Count

Info

1.46 ms
(44.82%)

SELECT COUNT(id) FROM equipment_audit at

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id)
FROM
  equipment_audit at

SELECT COUNT(id) FROM equipment_audit at;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1106)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
3	DH\Auditor\Provider\Doctrine\Persistence\Reader\Query->count (line 111)
4	Twig\Extension\CoreExtension->getAttribute (line 1909)
5	__TwigTemplate_6823a832028dc5c6ad362e71dfa76f61::block_dh_auditor_content (line 154)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_4ea97660c9345cf52c099c308f48f93b->doDisplay (line 87)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_6823a832028dc5c6ad362e71dfa76f61->doDisplay (line 57)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	DH\AuditorBundle\Controller\ViewerController->renderView (line 105)
16	DH\AuditorBundle\Controller\ViewerController->listAuditsAction (line 53)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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)

1.40 ms
(42.96%)

SELECT COUNT(id) FROM partners_audit at WHERE discriminator = ?

Parameters:

[
  "App\Entity\Partner\ConsumableSupplier"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id)
FROM
  partners_audit at
WHERE
  discriminator = ?

SELECT COUNT(id) FROM partners_audit at WHERE discriminator = 'App\\Entity\\Partner\\ConsumableSupplier';

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
2	DH\Auditor\Provider\Doctrine\Persistence\Reader\Query->count (line 111)
3	Twig\Extension\CoreExtension->getAttribute (line 1909)
4	__TwigTemplate_6823a832028dc5c6ad362e71dfa76f61::block_dh_auditor_content (line 154)
5	Twig\Template->yieldBlock (line 446)
6	__TwigTemplate_4ea97660c9345cf52c099c308f48f93b->doDisplay (line 87)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_6823a832028dc5c6ad362e71dfa76f61->doDisplay (line 57)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Environment->render (line 333)
14	DH\AuditorBundle\Controller\ViewerController->renderView (line 105)
15	DH\AuditorBundle\Controller\ViewerController->listAuditsAction (line 53)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.40 ms
(12.21%)

SELECT COUNT(id) FROM user_audit at

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id)
FROM
  user_audit at

SELECT COUNT(id) FROM user_audit at;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1106)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
3	DH\Auditor\Provider\Doctrine\Persistence\Reader\Query->count (line 111)
4	Twig\Extension\CoreExtension->getAttribute (line 1909)
5	__TwigTemplate_6823a832028dc5c6ad362e71dfa76f61::block_dh_auditor_content (line 154)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_4ea97660c9345cf52c099c308f48f93b->doDisplay (line 87)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_6823a832028dc5c6ad362e71dfa76f61->doDisplay (line 57)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	DH\AuditorBundle\Controller\ViewerController->renderView (line 105)
16	DH\AuditorBundle\Controller\ViewerController->listAuditsAction (line 53)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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)

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.