Symfony Profiler

Query Metrics

40 Database Queries

9 Different statements

79.45 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

27.88 ms
(35.10%)

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

Parameters:

[
  "public"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE status = 'public' ORDER BY created_at DESC LIMIT 0;

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
2	Sl\Vacancy\Read\DbalRepository->findByFilter (line 186)
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 30)
7	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
8	Trollbus\DoctrineORMBridge\Flusher\FlusherMiddleware->handle (line 24)
9	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
10	Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware->handle (line 21)
11	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
12	Trollbus\MessageBus\Logging\LogMiddleware->handle (line 32)
13	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
14	Trollbus\MessageBus\MessageId\CausationIdMiddleware->handle (line 25)
15	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
16	Trollbus\MessageBus\MessageId\CorrelationIdMiddleware->handle (line 29)
17	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
18	Trollbus\MessageBus\MessageId\MessageIdMiddleware->handle (line 24)
19	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
20	Trollbus\MessageBus\CreatedAt\CreatedAtMiddleware->handle (line 25)
21	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
22	Trollbus\MessageBus\Middleware\Pipeline->handle (line 45)
23	Trollbus\MessageBus\MessageBus::handleContext (line 57)
24	Trollbus\MessageBus\MessageContext->dispatch (line 57)
25	Sl\Vacancy\PublicationInfo\Manager->countPublicationInfoViewsByFilter (line 59)
26	Trollbus\MessageBus\Handler\CallableHandler->handle (line 36)
27	Trollbus\MessageBus\Middleware\Pipeline->continue (line 80)
28	Trollbus\MessageBus\DeferredEvent\DeferEventsMiddleware->handle (line 26)
29	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
30	Trollbus\DoctrineORMBridge\Flusher\FlusherMiddleware->handle (line 28)
31	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
32	Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware->{closure:Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware::handle():26} (line 26)
33	Trollbus\DoctrineORMBridge\Transaction\DoctrineTransactionProvider::{closure:Trollbus\DoctrineORMBridge\Transaction\DoctrineTransactionProvider::wrapInTransaction():51} (line 51)
34	Doctrine\DBAL\Connection::transactional (line 1290)
35	Trollbus\DoctrineORMBridge\Transaction\DoctrineTransactionProvider->wrapInTransaction (line 51)
36	Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware->handle (line 26)
37	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
38	Trollbus\MessageBus\Logging\LogMiddleware->handle (line 32)
39	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
40	Trollbus\MessageBus\MessageId\CausationIdMiddleware->handle (line 25)
41	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
42	Trollbus\MessageBus\MessageId\CorrelationIdMiddleware->handle (line 29)
43	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
44	Trollbus\MessageBus\MessageId\MessageIdMiddleware->handle (line 24)
45	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
46	Trollbus\MessageBus\CreatedAt\CreatedAtMiddleware->handle (line 25)
47	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
48	Trollbus\MessageBus\Middleware\Pipeline->handle (line 45)
49	Trollbus\MessageBus\MessageBus::handleContext (line 57)
50	Trollbus\MessageBus\MessageBus->dispatch (line 31)
51	Sl\Gateway\Vacancy\Controller->{closure:Sl\Gateway\Vacancy\Controller::list():84} (line 84)
52	call_user_func (line 30)
53	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackPagination::getPaginationCount (line 30)
54	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackSubscriber->items (line 18)
55	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
56	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
57	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
58	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
59	Knp\Component\Pager\Paginator->paginate (line 97)
60	ContainerXOns4iC\PaginatorProxy9db41e8->paginate (line 20)
61	Sl\ItOps\Pager\Paginator->paginate (line 54)
62	Sl\Gateway\Shared\Util\ControllerHelper->paginate (line 280)
63	Sl\Gateway\Vacancy\Controller->list (line 83)
64	Sl\ItOps\Symfony\ControllerMiddleware\Pipeline->__invoke (line 55)
65	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
66	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
67	Symfony\Component\HttpKernel\Kernel->handle (line 182)
68	Baldinof\RoadRunnerBundle\Http\KernelHandler->handle (line 41)
69	Generator->current (line 85)
70	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
71	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 63)
72	Baldinof\RoadRunnerBundle\Integration\Doctrine\DoctrineORMMiddleware->process (line 44)
73	Generator->current (line 85)
74	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
75	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
76	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
77	Generator->current (line 127)
78	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
79	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 33)
80	require_once (line 29)
81	require_once (line 5)

15.14 ms
(19.06%)

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

Parameters:

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#6940
    __toString(): "01997a4f-2b13-7280-9de8-be6b58ffd5b1"
  }
]

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 = '01997a4f-2b13-7280-9de8-be6b58ffd5b1' ORDER BY created_at DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
2	Sl\Vacancy\Read\DbalRepository->findByFilter (line 186)
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\Vacancy\Controller->{closure:{closure:Sl\Gateway\Vacancy\Controller::list():85}:86} (line 86)
31	array_map (line 85)
32	Sl\Gateway\Vacancy\Controller::{closure:Sl\Gateway\Vacancy\Controller::list():85} (line 85)
33	call_user_func (line 38)
34	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackPagination::getPaginationItems (line 38)
35	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackSubscriber->items (line 20)
36	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
37	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
38	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
39	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
40	Knp\Component\Pager\Paginator->paginate (line 97)
41	ContainerXOns4iC\PaginatorProxy9db41e8->paginate (line 20)
42	Sl\ItOps\Pager\Paginator->paginate (line 54)
43	Sl\Gateway\Shared\Util\ControllerHelper->paginate (line 280)
44	Sl\Gateway\Vacancy\Controller->list (line 83)
45	Sl\ItOps\Symfony\ControllerMiddleware\Pipeline->__invoke (line 55)
46	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
47	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
48	Symfony\Component\HttpKernel\Kernel->handle (line 182)
49	Baldinof\RoadRunnerBundle\Http\KernelHandler->handle (line 41)
50	Generator->current (line 85)
51	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
52	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 63)
53	Baldinof\RoadRunnerBundle\Integration\Doctrine\DoctrineORMMiddleware->process (line 44)
54	Generator->current (line 85)
55	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
56	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
57	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
58	Generator->current (line 127)
59	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
60	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 33)
61	require_once (line 29)
62	require_once (line 5)

15.07 ms
(18.97%)

SELECT * FROM company_view WHERE id = ?

Parameters:

[
  "01997a4e-cf54-7124-8097-5acd4ff2fef6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  company_view
WHERE
  id = ?

SELECT * FROM company_view WHERE id = '01997a4e-cf54-7124-8097-5acd4ff2fef6';

#	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\Shared\Util\DtoManager->getVacancyCardDto (line 51)
30	Sl\Gateway\Vacancy\Controller->{closure:{closure:Sl\Gateway\Vacancy\Controller::list():85}:86} (line 86)
31	array_map (line 85)
32	Sl\Gateway\Vacancy\Controller::{closure:Sl\Gateway\Vacancy\Controller::list():85} (line 85)
33	call_user_func (line 38)
34	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackPagination::getPaginationItems (line 38)
35	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackSubscriber->items (line 20)
36	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
37	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
38	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
39	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
40	Knp\Component\Pager\Paginator->paginate (line 97)
41	ContainerXOns4iC\PaginatorProxy9db41e8->paginate (line 20)
42	Sl\ItOps\Pager\Paginator->paginate (line 54)
43	Sl\Gateway\Shared\Util\ControllerHelper->paginate (line 280)
44	Sl\Gateway\Vacancy\Controller->list (line 83)
45	Sl\ItOps\Symfony\ControllerMiddleware\Pipeline->__invoke (line 55)
46	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
47	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
48	Symfony\Component\HttpKernel\Kernel->handle (line 182)
49	Baldinof\RoadRunnerBundle\Http\KernelHandler->handle (line 41)
50	Generator->current (line 85)
51	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
52	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 63)
53	Baldinof\RoadRunnerBundle\Integration\Doctrine\DoctrineORMMiddleware->process (line 44)
54	Generator->current (line 85)
55	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
56	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
57	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
58	Generator->current (line 127)
59	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
60	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 33)
61	require_once (line 29)
62	require_once (line 5)

7.52 ms
(9.46%)

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

Parameters:

[
  "public"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE status = 'public' ORDER BY created_at DESC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
2	Sl\Vacancy\Read\DbalRepository->findByFilter (line 186)
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 30)
7	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
8	Trollbus\DoctrineORMBridge\Flusher\FlusherMiddleware->handle (line 24)
9	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
10	Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware->handle (line 21)
11	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
12	Trollbus\MessageBus\Logging\LogMiddleware->handle (line 32)
13	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
14	Trollbus\MessageBus\MessageId\CausationIdMiddleware->handle (line 25)
15	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
16	Trollbus\MessageBus\MessageId\CorrelationIdMiddleware->handle (line 29)
17	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
18	Trollbus\MessageBus\MessageId\MessageIdMiddleware->handle (line 24)
19	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
20	Trollbus\MessageBus\CreatedAt\CreatedAtMiddleware->handle (line 25)
21	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
22	Trollbus\MessageBus\Middleware\Pipeline->handle (line 45)
23	Trollbus\MessageBus\MessageBus::handleContext (line 57)
24	Trollbus\MessageBus\MessageContext->dispatch (line 57)
25	Sl\Vacancy\PublicationInfo\Manager->findPublicationInfoViewsByFilter (line 48)
26	Trollbus\MessageBus\Handler\CallableHandler->handle (line 36)
27	Trollbus\MessageBus\Middleware\Pipeline->continue (line 80)
28	Trollbus\MessageBus\DeferredEvent\DeferEventsMiddleware->handle (line 26)
29	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
30	Trollbus\DoctrineORMBridge\Flusher\FlusherMiddleware->handle (line 28)
31	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
32	Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware->{closure:Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware::handle():26} (line 26)
33	Trollbus\DoctrineORMBridge\Transaction\DoctrineTransactionProvider::{closure:Trollbus\DoctrineORMBridge\Transaction\DoctrineTransactionProvider::wrapInTransaction():51} (line 51)
34	Doctrine\DBAL\Connection::transactional (line 1290)
35	Trollbus\DoctrineORMBridge\Transaction\DoctrineTransactionProvider->wrapInTransaction (line 51)
36	Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware->handle (line 26)
37	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
38	Trollbus\MessageBus\Logging\LogMiddleware->handle (line 32)
39	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
40	Trollbus\MessageBus\MessageId\CausationIdMiddleware->handle (line 25)
41	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
42	Trollbus\MessageBus\MessageId\CorrelationIdMiddleware->handle (line 29)
43	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
44	Trollbus\MessageBus\MessageId\MessageIdMiddleware->handle (line 24)
45	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
46	Trollbus\MessageBus\CreatedAt\CreatedAtMiddleware->handle (line 25)
47	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
48	Trollbus\MessageBus\Middleware\Pipeline->handle (line 45)
49	Trollbus\MessageBus\MessageBus::handleContext (line 57)
50	Trollbus\MessageBus\MessageBus->dispatch (line 31)
51	Sl\Gateway\Vacancy\Controller->{closure:Sl\Gateway\Vacancy\Controller::list():85} (line 87)
52	call_user_func (line 38)
53	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackPagination::getPaginationItems (line 38)
54	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackSubscriber->items (line 20)
55	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
56	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
57	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
58	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
59	Knp\Component\Pager\Paginator->paginate (line 97)
60	ContainerXOns4iC\PaginatorProxy9db41e8->paginate (line 20)
61	Sl\ItOps\Pager\Paginator->paginate (line 54)
62	Sl\Gateway\Shared\Util\ControllerHelper->paginate (line 280)
63	Sl\Gateway\Vacancy\Controller->list (line 83)
64	Sl\ItOps\Symfony\ControllerMiddleware\Pipeline->__invoke (line 55)
65	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
66	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
67	Symfony\Component\HttpKernel\Kernel->handle (line 182)
68	Baldinof\RoadRunnerBundle\Http\KernelHandler->handle (line 41)
69	Generator->current (line 85)
70	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
71	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 63)
72	Baldinof\RoadRunnerBundle\Integration\Doctrine\DoctrineORMMiddleware->process (line 44)
73	Generator->current (line 85)
74	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
75	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
76	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
77	Generator->current (line 127)
78	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
79	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 33)
80	require_once (line 29)
81	require_once (line 5)

5.76 ms
(7.25%)

SELECT COUNT(id) FROM vacancy_read WHERE id = ?

Parameters:

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#6940
    __toString(): "01997a4f-2b13-7280-9de8-be6b58ffd5b1"
  }
]

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 = '01997a4f-2b13-7280-9de8-be6b58ffd5b1';

#	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 128)
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\Vacancy\Controller->{closure:{closure:Sl\Gateway\Vacancy\Controller::list():85}:86} (line 86)
32	array_map (line 85)
33	Sl\Gateway\Vacancy\Controller::{closure:Sl\Gateway\Vacancy\Controller::list():85} (line 85)
34	call_user_func (line 38)
35	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackPagination::getPaginationItems (line 38)
36	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackSubscriber->items (line 20)
37	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
38	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
39	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
40	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
41	Knp\Component\Pager\Paginator->paginate (line 97)
42	ContainerXOns4iC\PaginatorProxy9db41e8->paginate (line 20)
43	Sl\ItOps\Pager\Paginator->paginate (line 54)
44	Sl\Gateway\Shared\Util\ControllerHelper->paginate (line 280)
45	Sl\Gateway\Vacancy\Controller->list (line 83)
46	Sl\ItOps\Symfony\ControllerMiddleware\Pipeline->__invoke (line 55)
47	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
48	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
49	Symfony\Component\HttpKernel\Kernel->handle (line 182)
50	Baldinof\RoadRunnerBundle\Http\KernelHandler->handle (line 41)
51	Generator->current (line 85)
52	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
53	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 63)
54	Baldinof\RoadRunnerBundle\Integration\Doctrine\DoctrineORMMiddleware->process (line 44)
55	Generator->current (line 85)
56	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
57	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
58	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
59	Generator->current (line 127)
60	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
61	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 33)
62	require_once (line 29)
63	require_once (line 5)

3.88 ms
(4.88%)

SELECT COUNT(id) FROM vacancy_read WHERE status = ?

Parameters:

[
  "public"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id)
FROM
  vacancy_read
WHERE
  status = ?

SELECT COUNT(id) FROM vacancy_read WHERE status = 'public';

#	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 128)
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 30)
8	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
9	Trollbus\DoctrineORMBridge\Flusher\FlusherMiddleware->handle (line 24)
10	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
11	Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware->handle (line 21)
12	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
13	Trollbus\MessageBus\Logging\LogMiddleware->handle (line 32)
14	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
15	Trollbus\MessageBus\MessageId\CausationIdMiddleware->handle (line 25)
16	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
17	Trollbus\MessageBus\MessageId\CorrelationIdMiddleware->handle (line 29)
18	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
19	Trollbus\MessageBus\MessageId\MessageIdMiddleware->handle (line 24)
20	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
21	Trollbus\MessageBus\CreatedAt\CreatedAtMiddleware->handle (line 25)
22	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
23	Trollbus\MessageBus\Middleware\Pipeline->handle (line 45)
24	Trollbus\MessageBus\MessageBus::handleContext (line 57)
25	Trollbus\MessageBus\MessageContext->dispatch (line 57)
26	Sl\Vacancy\PublicationInfo\Manager->countPublicationInfoViewsByFilter (line 59)
27	Trollbus\MessageBus\Handler\CallableHandler->handle (line 36)
28	Trollbus\MessageBus\Middleware\Pipeline->continue (line 80)
29	Trollbus\MessageBus\DeferredEvent\DeferEventsMiddleware->handle (line 26)
30	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
31	Trollbus\DoctrineORMBridge\Flusher\FlusherMiddleware->handle (line 28)
32	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
33	Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware->{closure:Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware::handle():26} (line 26)
34	Trollbus\DoctrineORMBridge\Transaction\DoctrineTransactionProvider::{closure:Trollbus\DoctrineORMBridge\Transaction\DoctrineTransactionProvider::wrapInTransaction():51} (line 51)
35	Doctrine\DBAL\Connection::transactional (line 1290)
36	Trollbus\DoctrineORMBridge\Transaction\DoctrineTransactionProvider->wrapInTransaction (line 51)
37	Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware->handle (line 26)
38	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
39	Trollbus\MessageBus\Logging\LogMiddleware->handle (line 32)
40	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
41	Trollbus\MessageBus\MessageId\CausationIdMiddleware->handle (line 25)
42	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
43	Trollbus\MessageBus\MessageId\CorrelationIdMiddleware->handle (line 29)
44	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
45	Trollbus\MessageBus\MessageId\MessageIdMiddleware->handle (line 24)
46	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
47	Trollbus\MessageBus\CreatedAt\CreatedAtMiddleware->handle (line 25)
48	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
49	Trollbus\MessageBus\Middleware\Pipeline->handle (line 45)
50	Trollbus\MessageBus\MessageBus::handleContext (line 57)
51	Trollbus\MessageBus\MessageBus->dispatch (line 31)
52	Sl\Gateway\Vacancy\Controller->{closure:Sl\Gateway\Vacancy\Controller::list():84} (line 84)
53	call_user_func (line 30)
54	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackPagination::getPaginationCount (line 30)
55	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackSubscriber->items (line 18)
56	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
57	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
58	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
59	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
60	Knp\Component\Pager\Paginator->paginate (line 97)
61	ContainerXOns4iC\PaginatorProxy9db41e8->paginate (line 20)
62	Sl\ItOps\Pager\Paginator->paginate (line 54)
63	Sl\Gateway\Shared\Util\ControllerHelper->paginate (line 280)
64	Sl\Gateway\Vacancy\Controller->list (line 83)
65	Sl\ItOps\Symfony\ControllerMiddleware\Pipeline->__invoke (line 55)
66	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
67	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
68	Symfony\Component\HttpKernel\Kernel->handle (line 182)
69	Baldinof\RoadRunnerBundle\Http\KernelHandler->handle (line 41)
70	Generator->current (line 85)
71	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
72	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 63)
73	Baldinof\RoadRunnerBundle\Integration\Doctrine\DoctrineORMMiddleware->process (line 44)
74	Generator->current (line 85)
75	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
76	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
77	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
78	Generator->current (line 127)
79	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
80	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 33)
81	require_once (line 29)
82	require_once (line 5)

1.48 ms
(1.86%)

"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\Vacancy\Controller->{closure:Sl\Gateway\Vacancy\Controller::list():84} (line 84)
20	call_user_func (line 30)
21	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackPagination::getPaginationCount (line 30)
22	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackSubscriber->items (line 18)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
27	Knp\Component\Pager\Paginator->paginate (line 97)
28	ContainerXOns4iC\PaginatorProxy9db41e8->paginate (line 20)
29	Sl\ItOps\Pager\Paginator->paginate (line 54)
30	Sl\Gateway\Shared\Util\ControllerHelper->paginate (line 280)
31	Sl\Gateway\Vacancy\Controller->list (line 83)
32	Sl\ItOps\Symfony\ControllerMiddleware\Pipeline->__invoke (line 55)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 182)
36	Baldinof\RoadRunnerBundle\Http\KernelHandler->handle (line 41)
37	Generator->current (line 85)
38	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
39	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 63)
40	Baldinof\RoadRunnerBundle\Integration\Doctrine\DoctrineORMMiddleware->process (line 44)
41	Generator->current (line 85)
42	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
43	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
44	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
45	Generator->current (line 127)
46	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
47	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 33)
48	require_once (line 29)
49	require_once (line 5)

1.40 ms
(1.76%)

"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\Vacancy\Controller->{closure:Sl\Gateway\Vacancy\Controller::list():84} (line 84)
19	call_user_func (line 30)
20	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackPagination::getPaginationCount (line 30)
21	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackSubscriber->items (line 18)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
26	Knp\Component\Pager\Paginator->paginate (line 97)
27	ContainerXOns4iC\PaginatorProxy9db41e8->paginate (line 20)
28	Sl\ItOps\Pager\Paginator->paginate (line 54)
29	Sl\Gateway\Shared\Util\ControllerHelper->paginate (line 280)
30	Sl\Gateway\Vacancy\Controller->list (line 83)
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 182)
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\Http\MiddlewareStack->handle (line 33)
44	Generator->current (line 127)
45	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
46	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 33)
47	require_once (line 29)
48	require_once (line 5)

1.32 ms
(1.66%)

SELECT id
FROM vacancy_publication
WHERE vacancy_id = ?
ORDER BY published_at DESC
OFFSET 0 LIMIT 1

Parameters:

[
  "01997a4f-2b13-7280-9de8-be6b58ffd5b1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id
FROM
  vacancy_publication
WHERE
  vacancy_id = ?
ORDER BY
  published_at DESC
OFFSET
  0
LIMIT
  1

SELECT id
FROM vacancy_publication
WHERE vacancy_id = '01997a4f-2b13-7280-9de8-be6b58ffd5b1'
ORDER BY published_at DESC
OFFSET 0 LIMIT 1;

#	File/Call
1	Sl\Vacancy\PublicationInfo\DbalRepository->getVacancyPublicationId (line 33)
2	Sl\Vacancy\PublicationInfo\Manager->vacancyToPublicationInfoView (line 72)
3	array_map (line 54)
4	Sl\Vacancy\PublicationInfo\Manager::findPublicationInfoViewsByFilter (line 54)
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\Vacancy\Controller->{closure:Sl\Gateway\Vacancy\Controller::list():85} (line 87)
31	call_user_func (line 38)
32	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackPagination::getPaginationItems (line 38)
33	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackSubscriber->items (line 20)
34	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
35	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
36	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
37	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
38	Knp\Component\Pager\Paginator->paginate (line 97)
39	ContainerXOns4iC\PaginatorProxy9db41e8->paginate (line 20)
40	Sl\ItOps\Pager\Paginator->paginate (line 54)
41	Sl\Gateway\Shared\Util\ControllerHelper->paginate (line 280)
42	Sl\Gateway\Vacancy\Controller->list (line 83)
43	Sl\ItOps\Symfony\ControllerMiddleware\Pipeline->__invoke (line 55)
44	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
45	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
46	Symfony\Component\HttpKernel\Kernel->handle (line 182)
47	Baldinof\RoadRunnerBundle\Http\KernelHandler->handle (line 41)
48	Generator->current (line 85)
49	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
50	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 63)
51	Baldinof\RoadRunnerBundle\Integration\Doctrine\DoctrineORMMiddleware->process (line 44)
52	Generator->current (line 85)
53	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
54	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
55	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
56	Generator->current (line 127)
57	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
58	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 33)
59	require_once (line 29)
60	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/vacancies

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping