Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

13.34 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

12.09 ms
(90.64%)

SELECT * FROM company_view WHERE id = ?

Parameters:

[
  "01994cfa-365d-73aa-9ffb-ca62bd7fbc63"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  company_view
WHERE
  id = ?

SELECT * FROM company_view WHERE id = '01994cfa-365d-73aa-9ffb-ca62bd7fbc63';

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
2	Sl\Employer\Company\Read\DbalRepository->findById (line 97)
3	Sl\Employer\Company\Read\Manager->findCompanyViewById (line 19)
4	Trollbus\MessageBus\Handler\CallableHandler->handle (line 36)
5	Trollbus\MessageBus\Middleware\Pipeline->continue (line 80)
6	Trollbus\MessageBus\DeferredEvent\DeferEventsMiddleware->handle (line 26)
7	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
8	Trollbus\DoctrineORMBridge\Flusher\FlusherMiddleware->handle (line 28)
9	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
10	Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware->{closure:Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware::handle():26} (line 26)
11	Trollbus\DoctrineORMBridge\Transaction\DoctrineTransactionProvider::{closure:Trollbus\DoctrineORMBridge\Transaction\DoctrineTransactionProvider::wrapInTransaction():51} (line 51)
12	Doctrine\DBAL\Connection::transactional (line 1290)
13	Trollbus\DoctrineORMBridge\Transaction\DoctrineTransactionProvider->wrapInTransaction (line 51)
14	Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware->handle (line 26)
15	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
16	Trollbus\MessageBus\Logging\LogMiddleware->handle (line 32)
17	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
18	Trollbus\MessageBus\MessageId\CausationIdMiddleware->handle (line 25)
19	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
20	Trollbus\MessageBus\MessageId\CorrelationIdMiddleware->handle (line 29)
21	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
22	Trollbus\MessageBus\MessageId\MessageIdMiddleware->handle (line 24)
23	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
24	Trollbus\MessageBus\CreatedAt\CreatedAtMiddleware->handle (line 25)
25	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
26	Trollbus\MessageBus\Middleware\Pipeline->handle (line 45)
27	Trollbus\MessageBus\MessageBus::handleContext (line 57)
28	Trollbus\MessageBus\MessageBus->dispatch (line 31)
29	Sl\Gateway\Company\Controller->logo (line 96)
30	Sl\ItOps\Symfony\ControllerMiddleware\Pipeline->__invoke (line 55)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 182)
34	Baldinof\RoadRunnerBundle\Http\KernelHandler->handle (line 41)
35	Generator->current (line 85)
36	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
37	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 63)
38	Baldinof\RoadRunnerBundle\Integration\Doctrine\DoctrineORMMiddleware->process (line 44)
39	Generator->current (line 85)
40	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
41	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
42	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
43	Generator->current (line 127)
44	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
45	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 33)
46	require_once (line 29)
47	require_once (line 5)

0.85 ms
(6.38%)

SELECT * FROM file_metadata WHERE path = ?

Parameters:

[
  ""
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  file_metadata
WHERE
  path = ?

SELECT * FROM file_metadata WHERE path = '';

#	File/Call
1	Sl\ItOps\FileUploader\DbalFileMetadataRepository->find (line 60)
2	Sl\ItOps\FileUploader\FileStorage->httpResponse (line 115)
3	Sl\Gateway\Company\Controller->logo (line 99)
4	Sl\ItOps\Symfony\ControllerMiddleware\Pipeline->__invoke (line 55)
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	Baldinof\RoadRunnerBundle\Http\KernelHandler->handle (line 41)
9	Generator->current (line 85)
10	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
11	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 63)
12	Baldinof\RoadRunnerBundle\Integration\Doctrine\DoctrineORMMiddleware->process (line 44)
13	Generator->current (line 85)
14	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
15	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
16	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
17	Generator->current (line 127)
18	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
19	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 33)
20	require_once (line 29)
21	require_once (line 5)

0.24 ms
(1.80%)

"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\DBAL\Connection->transactional (line 1301)
3	Trollbus\DoctrineORMBridge\Transaction\DoctrineTransactionProvider->wrapInTransaction (line 51)
4	Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware->handle (line 26)
5	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
6	Trollbus\MessageBus\Logging\LogMiddleware->handle (line 32)
7	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
8	Trollbus\MessageBus\MessageId\CausationIdMiddleware->handle (line 25)
9	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
10	Trollbus\MessageBus\MessageId\CorrelationIdMiddleware->handle (line 29)
11	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
12	Trollbus\MessageBus\MessageId\MessageIdMiddleware->handle (line 24)
13	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
14	Trollbus\MessageBus\CreatedAt\CreatedAtMiddleware->handle (line 25)
15	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
16	Trollbus\MessageBus\Middleware\Pipeline->handle (line 45)
17	Trollbus\MessageBus\MessageBus::handleContext (line 57)
18	Trollbus\MessageBus\MessageBus->dispatch (line 31)
19	Sl\Gateway\Company\Controller->logo (line 96)
20	Sl\ItOps\Symfony\ControllerMiddleware\Pipeline->__invoke (line 55)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Baldinof\RoadRunnerBundle\Http\KernelHandler->handle (line 41)
25	Generator->current (line 85)
26	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
27	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 63)
28	Baldinof\RoadRunnerBundle\Integration\Doctrine\DoctrineORMMiddleware->process (line 44)
29	Generator->current (line 85)
30	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
31	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
32	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
33	Generator->current (line 127)
34	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
35	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 33)
36	require_once (line 29)
37	require_once (line 5)

0.16 ms
(1.18%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->transactional (line 1285)
2	Trollbus\DoctrineORMBridge\Transaction\DoctrineTransactionProvider->wrapInTransaction (line 51)
3	Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware->handle (line 26)
4	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
5	Trollbus\MessageBus\Logging\LogMiddleware->handle (line 32)
6	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
7	Trollbus\MessageBus\MessageId\CausationIdMiddleware->handle (line 25)
8	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
9	Trollbus\MessageBus\MessageId\CorrelationIdMiddleware->handle (line 29)
10	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
11	Trollbus\MessageBus\MessageId\MessageIdMiddleware->handle (line 24)
12	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
13	Trollbus\MessageBus\CreatedAt\CreatedAtMiddleware->handle (line 25)
14	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
15	Trollbus\MessageBus\Middleware\Pipeline->handle (line 45)
16	Trollbus\MessageBus\MessageBus::handleContext (line 57)
17	Trollbus\MessageBus\MessageBus->dispatch (line 31)
18	Sl\Gateway\Company\Controller->logo (line 96)
19	Sl\ItOps\Symfony\ControllerMiddleware\Pipeline->__invoke (line 55)
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	Baldinof\RoadRunnerBundle\Http\KernelHandler->handle (line 41)
24	Generator->current (line 85)
25	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
26	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 63)
27	Baldinof\RoadRunnerBundle\Integration\Doctrine\DoctrineORMMiddleware->process (line 44)
28	Generator->current (line 85)
29	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
30	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
31	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
32	Generator->current (line 127)
33	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
34	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 33)
35	require_once (line 29)
36	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

No loaded entities.

Symfony Profiler

GET https://sl.raduga.red/company/01994cfa-365d-73aa-9ffb-ca62bd7fbc63/logo

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping