Symfony Profiler

Query Metrics

34 Database Queries

10 Different statements

59.39 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

16.88 ms
(28.42%)

SELECT * FROM company_view WHERE id = ?

Parameters:

[
  "019d5364-2179-73eb-a978-c26d17484b89"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  company_view
WHERE
  id = ?

SELECT * FROM company_view WHERE id = '019d5364-2179-73eb-a978-c26d17484b89';

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
2	Sl\Employer\Company\Read\DbalRepository->findById (line 99)
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->info (line 45)
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 193)
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\Integration\Xdebug\XdebugTriggerMiddleware->process (line 25)
43	Generator->current (line 85)
44	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
45	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
46	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
47	Generator->current (line 127)
48	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
49	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 36)
50	require_once (line 32)
51	require_once (line 5)

8.29 ms
(13.96%)

SELECT * FROM company_feedback_read f WHERE f.company_id = ? ORDER BY f.created_at DESC LIMIT 3

Parameters:

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#19545
    __toString(): "019d5364-2179-73eb-a978-c26d17484b89"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  *
FROM
  company_feedback_read f
WHERE
  f.company_id = ?
ORDER BY
  f.created_at DESC
LIMIT
  3

SELECT * FROM company_feedback_read f WHERE f.company_id = '019d5364-2179-73eb-a978-c26d17484b89' ORDER BY f.created_at DESC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
2	Sl\Employer\Company\Feedback\Read\DbalRepository->findByFilter (line 133)
3	Sl\Employer\Company\Feedback\Read\Manager->findByFilter (line 29)
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->info (line 60)
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 193)
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\Integration\Xdebug\XdebugTriggerMiddleware->process (line 25)
43	Generator->current (line 85)
44	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
45	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
46	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
47	Generator->current (line 127)
48	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
49	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 36)
50	require_once (line 32)
51	require_once (line 5)

8.12 ms
(13.68%)

SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE (status = ?) AND (company_id = ?) ORDER BY created_at DESC LIMIT 10

Parameters:

[
  "public"
  "019d5364-2179-73eb-a978-c26d17484b89"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *,
  ST_AsEWKT(coordinates) AS coordinates
FROM
  vacancy_read
WHERE
  (status = ?)
  AND (company_id = ?)
ORDER BY
  created_at DESC
LIMIT
  10

SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE (status = 'public') AND (company_id = '019d5364-2179-73eb-a978-c26d17484b89') ORDER BY created_at DESC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
2	Sl\Vacancy\Read\DbalRepository->findByFilter (line 188)
3	Sl\Vacancy\Read\Handler->findItemsByFilter (line 35)
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->info (line 73)
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 193)
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\Integration\Xdebug\XdebugTriggerMiddleware->process (line 25)
43	Generator->current (line 85)
44	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
45	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
46	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
47	Generator->current (line 127)
48	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
49	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 36)
50	require_once (line 32)
51	require_once (line 5)

7.47 ms
(12.57%)

SELECT COUNT(f.id) FROM company_feedback_read f WHERE f.company_id = ?

Parameters:

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#19545
    __toString(): "019d5364-2179-73eb-a978-c26d17484b89"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  COUNT(f.id)
FROM
  company_feedback_read f
WHERE
  f.company_id = ?

SELECT COUNT(f.id) FROM company_feedback_read f WHERE f.company_id = '019d5364-2179-73eb-a978-c26d17484b89';

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
2	Sl\Employer\Company\Feedback\Read\DbalRepository->countByFilter (line 153)
3	Sl\Employer\Company\Feedback\Read\Manager->countByFilter (line 34)
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->info (line 53)
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 193)
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\Integration\Xdebug\XdebugTriggerMiddleware->process (line 25)
43	Generator->current (line 85)
44	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
45	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
46	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
47	Generator->current (line 127)
48	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
49	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 36)
50	require_once (line 32)
51	require_once (line 5)

5.79 ms
(9.75%)

SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE id = ? ORDER BY created_at DESC LIMIT 1

Parameters:

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#19664
    __toString(): "019d5367-e342-70e2-b367-8a51c0fb7764"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  *,
  ST_AsEWKT(coordinates) AS coordinates
FROM
  vacancy_read
WHERE
  id = ?
ORDER BY
  created_at DESC
LIMIT
  1

SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE id = '019d5367-e342-70e2-b367-8a51c0fb7764' ORDER BY created_at DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
2	Sl\Vacancy\Read\DbalRepository->findByFilter (line 188)
3	Sl\Vacancy\Read\Handler->findByFilter (line 24)
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\Shared\Util\DtoManager->getVacancyCardDto (line 37)
30	Sl\Gateway\Company\Controller->{closure:Sl\Gateway\Company\Controller::info():83} (line 83)
31	array_map (line 83)
32	Sl\Gateway\Company\Controller::info (line 83)
33	Sl\ItOps\Symfony\ControllerMiddleware\Pipeline->__invoke (line 55)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 193)
37	Baldinof\RoadRunnerBundle\Http\KernelHandler->handle (line 41)
38	Generator->current (line 85)
39	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
40	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 63)
41	Baldinof\RoadRunnerBundle\Integration\Doctrine\DoctrineORMMiddleware->process (line 44)
42	Generator->current (line 85)
43	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
44	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
45	Baldinof\RoadRunnerBundle\Integration\Xdebug\XdebugTriggerMiddleware->process (line 25)
46	Generator->current (line 85)
47	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
48	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
49	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
50	Generator->current (line 127)
51	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
52	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 36)
53	require_once (line 32)
54	require_once (line 5)

3.93 ms
(6.62%)

SELECT COUNT(id) FROM vacancy_read WHERE (status = ?) AND (company_id = ?)

Parameters:

[
  "public"
  "019d5364-2179-73eb-a978-c26d17484b89"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id)
FROM
  vacancy_read
WHERE
  (status = ?)
  AND (company_id = ?)

SELECT COUNT(id) FROM vacancy_read WHERE (status = 'public') AND (company_id = '019d5364-2179-73eb-a978-c26d17484b89');

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

3.08 ms
(5.19%)

SELECT COUNT(d.id) FROM deal_read d WHERE d.company_id = ?

Parameters:

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#19545
    __toString(): "019d5364-2179-73eb-a978-c26d17484b89"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  COUNT(d.id)
FROM
  deal_read d
WHERE
  d.company_id = ?

SELECT COUNT(d.id) FROM deal_read d WHERE d.company_id = '019d5364-2179-73eb-a978-c26d17484b89';

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
2	Sl\Deal\Read\Deal\DbalRepository->countDeals (line 207)
3	Sl\Deal\Read\Deal\Handlers->countDeals (line 44)
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->info (line 81)
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 193)
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\Integration\Xdebug\XdebugTriggerMiddleware->process (line 25)
43	Generator->current (line 85)
44	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
45	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
46	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
47	Generator->current (line 127)
48	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
49	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 36)
50	require_once (line 32)
51	require_once (line 5)

2.21 ms
(3.73%)

SELECT COUNT(id) FROM vacancy_read WHERE id = ?

Parameters:

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#19664
    __toString(): "019d5367-e342-70e2-b367-8a51c0fb7764"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  COUNT(id)
FROM
  vacancy_read
WHERE
  id = ?

SELECT COUNT(id) FROM vacancy_read WHERE id = '019d5367-e342-70e2-b367-8a51c0fb7764';

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

1.96 ms
(3.31%)

"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->info (line 45)
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 193)
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\Integration\Xdebug\XdebugTriggerMiddleware->process (line 25)
33	Generator->current (line 85)
34	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
35	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
36	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
37	Generator->current (line 127)
38	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
39	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 36)
40	require_once (line 32)
41	require_once (line 5)

1.65 ms
(2.78%)

"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->info (line 45)
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 193)
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\Integration\Xdebug\XdebugTriggerMiddleware->process (line 25)
32	Generator->current (line 85)
33	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
34	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
35	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
36	Generator->current (line 127)
37	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
38	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 36)
39	require_once (line 32)
40	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
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
Sl\ItOps\JWT\Refresh\RefreshToken	No errors.

Symfony Profiler

GET https://sl.raduga.red/company/019d5364-2179-73eb-a978-c26d17484b89

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping