Symfony Profiler

Query Metrics

21 Database Queries

11 Different statements

53.22 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

26.95 ms
(50.64%)

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

Parameters:

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#11356
    __toString(): "019afd4a-6c33-7214-9577-4909759e3b3c"
  }
  "public"
]

View formatted query View runnable query View query backtrace

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

SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE (id = '019afd4a-6c33-7214-9577-4909759e3b3c') AND (status = 'public') 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 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->getPublicationInfoViewByVacancy (line 25)
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->info (line 110)
52	Sl\ItOps\Symfony\ControllerMiddleware\Pipeline->__invoke (line 55)
53	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
54	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
55	Symfony\Component\HttpKernel\Kernel->handle (line 193)
56	Baldinof\RoadRunnerBundle\Http\KernelHandler->handle (line 41)
57	Generator->current (line 85)
58	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
59	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 63)
60	Baldinof\RoadRunnerBundle\Integration\Doctrine\DoctrineORMMiddleware->process (line 44)
61	Generator->current (line 85)
62	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
63	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
64	Baldinof\RoadRunnerBundle\Integration\Xdebug\XdebugTriggerMiddleware->process (line 25)
65	Generator->current (line 85)
66	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
67	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
68	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
69	Generator->current (line 127)
70	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
71	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 36)
72	require_once (line 32)
73	require_once (line 5)

10.38 ms
(19.50%)

SELECT * FROM company_view WHERE id = ?

Parameters:

[
  "019afd3d-8061-730a-997b-e9c9a37eb323"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  company_view
WHERE
  id = ?

SELECT * FROM company_view WHERE id = '019afd3d-8061-730a-997b-e9c9a37eb323';

#	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\Shared\Util\DtoManager->getVacancyCardDto (line 48)
30	Sl\Gateway\Vacancy\Controller->info (line 113)
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)

4.41 ms
(8.29%)

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

Parameters:

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#11287
    __toString(): "019afd4a-6c33-7214-9577-4909759e3b3c"
  }
]

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 = '019afd4a-6c33-7214-9577-4909759e3b3c' 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\DbalRepository->findById (line 139)
4	Sl\Vacancy\Read\Handler->findById (line 45)
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 36)
31	Sl\Gateway\Vacancy\Controller->info (line 113)
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 193)
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\Integration\Xdebug\XdebugTriggerMiddleware->process (line 25)
45	Generator->current (line 85)
46	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
47	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
48	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
49	Generator->current (line 127)
50	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
51	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 36)
52	require_once (line 32)
53	require_once (line 5)

4.17 ms
(7.84%)

SELECT * FROM deal_read d WHERE (d.vacancy_id = ?) AND (d.is_closed = ?) ORDER BY d.created_at DESC LIMIT 4

Parameters:

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#11287
    __toString(): "019afd4a-6c33-7214-9577-4909759e3b3c"
  }
  0
]

View formatted query View runnable query View query backtrace

SELECT
  *
FROM
  deal_read d
WHERE
  (d.vacancy_id = ?)
  AND (d.is_closed = ?)
ORDER BY
  d.created_at DESC
LIMIT
  4

SELECT * FROM deal_read d WHERE (d.vacancy_id = '019afd4a-6c33-7214-9577-4909759e3b3c') AND (d.is_closed = 0) ORDER BY d.created_at DESC LIMIT 4;

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
2	Sl\Deal\Read\Deal\DbalRepository->findDeals (line 197)
3	Sl\Deal\Read\Deal\Handlers->findDeals (line 36)
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\Vacancy\Controller->info (line 180)
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.23 ms
(4.19%)

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

Parameters:

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#11356
    __toString(): "019afd4a-6c33-7214-9577-4909759e3b3c"
  }
  "public"
]

View formatted query View runnable query View query backtrace

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

SELECT COUNT(id) FROM vacancy_read WHERE (id = '019afd4a-6c33-7214-9577-4909759e3b3c') AND (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 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 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->getPublicationInfoViewByVacancy (line 25)
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->info (line 110)
53	Sl\ItOps\Symfony\ControllerMiddleware\Pipeline->__invoke (line 55)
54	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
55	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
56	Symfony\Component\HttpKernel\Kernel->handle (line 193)
57	Baldinof\RoadRunnerBundle\Http\KernelHandler->handle (line 41)
58	Generator->current (line 85)
59	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
60	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 63)
61	Baldinof\RoadRunnerBundle\Integration\Doctrine\DoctrineORMMiddleware->process (line 44)
62	Generator->current (line 85)
63	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
64	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
65	Baldinof\RoadRunnerBundle\Integration\Xdebug\XdebugTriggerMiddleware->process (line 25)
66	Generator->current (line 85)
67	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
68	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
69	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
70	Generator->current (line 127)
71	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
72	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 36)
73	require_once (line 32)
74	require_once (line 5)

1.64 ms
(3.09%)

SELECT COUNT(d.id) FROM deal_read d WHERE (d.vacancy_id = ?) AND (d.is_closed = ?)

Parameters:

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#11287
    __toString(): "019afd4a-6c33-7214-9577-4909759e3b3c"
  }
  0
]

View formatted query View runnable query View query backtrace

SELECT
  COUNT(d.id)
FROM
  deal_read d
WHERE
  (d.vacancy_id = ?)
  AND (d.is_closed = ?)

SELECT COUNT(d.id) FROM deal_read d WHERE (d.vacancy_id = '019afd4a-6c33-7214-9577-4909759e3b3c') AND (d.is_closed = 0);

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
2	Sl\Deal\Read\Deal\DbalRepository->countDeals (line 214)
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\Vacancy\Controller->info (line 167)
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)

1.25 ms
(2.35%)

SELECT * FROM workerman_information_read WHERE id = ?

Parameters:

[
  "019afc87-9572-7310-8906-f04bdbaeaab9"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  workerman_information_read
WHERE
  id = ?

SELECT * FROM workerman_information_read WHERE id = '019afc87-9572-7310-8906-f04bdbaeaab9';

#	File/Call
1	Sl\Workerman\Read\Profile\DbalRepository->find (line 143)
2	Sl\Workerman\Read\Profile\Handler->getWorkermanProfile (line 22)
3	Trollbus\MessageBus\Handler\CallableHandler->handle (line 36)
4	Trollbus\MessageBus\Middleware\Pipeline->continue (line 80)
5	Trollbus\MessageBus\DeferredEvent\DeferEventsMiddleware->handle (line 26)
6	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
7	Trollbus\DoctrineORMBridge\Flusher\FlusherMiddleware->handle (line 28)
8	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
9	Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware->{closure:Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware::handle():26} (line 26)
10	Trollbus\DoctrineORMBridge\Transaction\DoctrineTransactionProvider::{closure:Trollbus\DoctrineORMBridge\Transaction\DoctrineTransactionProvider::wrapInTransaction():51} (line 51)
11	Doctrine\DBAL\Connection::transactional (line 1290)
12	Trollbus\DoctrineORMBridge\Transaction\DoctrineTransactionProvider->wrapInTransaction (line 51)
13	Trollbus\MessageBus\Transaction\WrapInTransactionMiddleware->handle (line 26)
14	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
15	Trollbus\MessageBus\Logging\LogMiddleware->handle (line 32)
16	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
17	Trollbus\MessageBus\MessageId\CausationIdMiddleware->handle (line 25)
18	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
19	Trollbus\MessageBus\MessageId\CorrelationIdMiddleware->handle (line 29)
20	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
21	Trollbus\MessageBus\MessageId\MessageIdMiddleware->handle (line 24)
22	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
23	Trollbus\MessageBus\CreatedAt\CreatedAtMiddleware->handle (line 25)
24	Trollbus\MessageBus\Middleware\Pipeline->continue (line 75)
25	Trollbus\MessageBus\Middleware\Pipeline->handle (line 45)
26	Trollbus\MessageBus\MessageBus::handleContext (line 57)
27	Trollbus\MessageBus\MessageBus->dispatch (line 31)
28	Sl\Gateway\Vacancy\Controller->{closure:Sl\Gateway\Vacancy\Controller::info():171} (line 172)
29	array_map (line 170)
30	Sl\Gateway\Vacancy\Controller::info (line 170)
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)

0.91 ms
(1.72%)

"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->info (line 110)
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)

0.57 ms
(1.08%)

"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->info (line 110)
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)

0.41 ms
(0.77%)

SELECT job_title_id, job_title, description
FROM workerman_information_previous_job_read
WHERE workerman_id = ?

Parameters:

[
  "019afc87-9572-7310-8906-f04bdbaeaab9"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  job_title_id,
  job_title,
  description
FROM
  workerman_information_previous_job_read
WHERE
  workerman_id = ?

SELECT job_title_id, job_title, description
FROM workerman_information_previous_job_read
WHERE workerman_id = '019afc87-9572-7310-8906-f04bdbaeaab9';

#	File/Call
1	Sl\Workerman\Read\Profile\DbalRepository->getWorkermanWorkExperience (line 167)
2	Sl\Workerman\Read\Profile\DbalRepository->{closure:Sl\Workerman\Read\Profile\DbalRepository::hydrateProfile():232} (line 232)
3	Sl\ItOps\Doctrine\Collection\CallbackCollection->doInitialize (line 29)
4	Doctrine\Common\Collections\AbstractLazyCollection->initialize (line 402)
5	Doctrine\Common\Collections\AbstractLazyCollection->get (line 120)
6	Sl\Gateway\Vacancy\Controller->{closure:Sl\Gateway\Vacancy\Controller::info():171} (line 177)
7	array_map (line 170)
8	Sl\Gateway\Vacancy\Controller::info (line 170)
9	Sl\ItOps\Symfony\ControllerMiddleware\Pipeline->__invoke (line 55)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Baldinof\RoadRunnerBundle\Http\KernelHandler->handle (line 41)
14	Generator->current (line 85)
15	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
16	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 63)
17	Baldinof\RoadRunnerBundle\Integration\Doctrine\DoctrineORMMiddleware->process (line 44)
18	Generator->current (line 85)
19	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
20	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
21	Baldinof\RoadRunnerBundle\Integration\Xdebug\XdebugTriggerMiddleware->process (line 25)
22	Generator->current (line 85)
23	Baldinof\RoadRunnerBundle\Http\Runner->getResponse (line 85)
24	Baldinof\RoadRunnerBundle\Http\Runner->handle (line 71)
25	Baldinof\RoadRunnerBundle\Http\MiddlewareStack->handle (line 33)
26	Generator->current (line 127)
27	Baldinof\RoadRunnerBundle\Worker\HttpWorker->start (line 127)
28	Baldinof\RoadRunnerBundle\Runtime\Runner->run (line 36)
29	require_once (line 32)
30	require_once (line 5)

0.29 ms
(0.54%)

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

Parameters:

[
  "019afd4a-6c33-7214-9577-4909759e3b3c"
]

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 = '019afd4a-6c33-7214-9577-4909759e3b3c'
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	Sl\Vacancy\PublicationInfo\Manager->getPublicationInfoViewByVacancy (line 40)
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\Vacancy\Controller->info (line 110)
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)

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/vacancy/019afd4a-6c33-7214-9577-4909759e3b3c

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping