Symfony Profiler

Query Metrics

56 Database Queries

26 Different statements

209.03 ms Query time

0 Invalid entities

70 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

69.59 ms
(33.29%)

SELECT v0_.title AS title_0, v0_.salary_min AS salary_min_1, v0_.salary_max AS salary_max_2, v0_.published_at AS published_at_3, v0_.status AS status_4, v0_.description AS description_5, v0_.experience AS experience_6, v0_.schedule AS schedule_7, v0_.employment AS employment_8, c1_.name AS name_9 FROM vacancies v0_ INNER JOIN company_employer c2_ ON v0_.manager_id = c2_.user_id INNER JOIN city c1_ ON v0_.city_id = c1_.id WHERE c2_.company_id = ? AND v0_.published_at IS NOT NULL AND v0_.status = ? AND v0_.is_anonymous = false ORDER BY v0_.published_at DESC LIMIT 5

Parameters:

[
  Symfony\Component\Uid\UuidV6 {#2574
    __toString(): "1f11eab9-0a82-6bde-977d-c7d0e949dcc1"
  }
  "public"
]

View formatted query View runnable query View query backtrace

SELECT
  v0_.title AS title_0,
  v0_.salary_min AS salary_min_1,
  v0_.salary_max AS salary_max_2,
  v0_.published_at AS published_at_3,
  v0_.status AS status_4,
  v0_.description AS description_5,
  v0_.experience AS experience_6,
  v0_.schedule AS schedule_7,
  v0_.employment AS employment_8,
  c1_.name AS name_9
FROM
  vacancies v0_
  INNER JOIN company_employer c2_ ON v0_.manager_id = c2_.user_id
  INNER JOIN city c1_ ON v0_.city_id = c1_.id
WHERE
  c2_.company_id = ?
  AND v0_.published_at IS NOT NULL
  AND v0_.status = ?
  AND v0_.is_anonymous = false
ORDER BY
  v0_.published_at DESC
LIMIT
  5

SELECT v0_.title AS title_0, v0_.salary_min AS salary_min_1, v0_.salary_max AS salary_max_2, v0_.published_at AS published_at_3, v0_.status AS status_4, v0_.description AS description_5, v0_.experience AS experience_6, v0_.schedule AS schedule_7, v0_.employment AS employment_8, c1_.name AS name_9 FROM vacancies v0_ INNER JOIN company_employer c2_ ON v0_.manager_id = c2_.user_id INNER JOIN city c1_ ON v0_.city_id = c1_.id WHERE c2_.company_id = '1f11eab9-0a82-6bde-977d-c7d0e949dcc1' AND v0_.published_at IS NOT NULL AND v0_.status = 'public' AND v0_.is_anonymous = false ORDER BY v0_.published_at DESC LIMIT 5;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 918)
6	App\Infrastructure\Company\Service\CompanyManager->App\Infrastructure\Company\Service\{closure} (line 164)
7	Kenny1911\Memoizer\Memoizer->memoize (line 32)
8	App\Infrastructure\Company\Service\CompanyManager->getCompanyInfo (line 124)
9	App\Util\RaberuVariable\CompanyHelper->getInfo (line 43)
10	Twig\Extension\CoreExtension->getAttribute (line 1918)
11	__TwigTemplate_20f66c3c34c84777402ebf6a52f6e1f0::doDisplay (line 56)
12	Twig\Template->yield (line 411)
13	Twig\Template->display (line 366)
14	Twig\Template->render (line 381)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
20	App\Controller\VacancyController->vacancyPublic (line 245)
21	App\Controller\VacancyController->vacancy (line 189)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 208)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

43.95 ms
(21.03%)

SELECT COUNT(v0_.id) AS sclr_0 FROM vacancies v0_ INNER JOIN company_employer c1_ ON v0_.manager_id = c1_.user_id WHERE c1_.company_id = ? AND v0_.published_at IS NOT NULL

Parameters:

[
  Symfony\Component\Uid\UuidV6 {#2574
    __toString(): "1f11eab9-0a82-6bde-977d-c7d0e949dcc1"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  vacancies v0_
  INNER JOIN company_employer c1_ ON v0_.manager_id = c1_.user_id
WHERE
  c1_.company_id = ?
  AND v0_.published_at IS NOT NULL

SELECT COUNT(v0_.id) AS sclr_0 FROM vacancies v0_ INNER JOIN company_employer c1_ ON v0_.manager_id = c1_.user_id WHERE c1_.company_id = '1f11eab9-0a82-6bde-977d-c7d0e949dcc1' AND v0_.published_at IS NOT NULL;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 996)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 1025)
7	App\Infrastructure\Company\Service\CompanyManager->App\Infrastructure\Company\Service\{closure} (line 133)
8	Kenny1911\Memoizer\Memoizer->memoize (line 32)
9	App\Infrastructure\Company\Service\CompanyManager->getCompanyInfo (line 124)
10	App\Util\RaberuVariable\CompanyHelper->getInfo (line 43)
11	Twig\Extension\CoreExtension->getAttribute (line 1918)
12	__TwigTemplate_20f66c3c34c84777402ebf6a52f6e1f0::doDisplay (line 56)
13	Twig\Template->yield (line 411)
14	Twig\Template->display (line 366)
15	Twig\Template->render (line 381)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
21	App\Controller\VacancyController->vacancyPublic (line 245)
22	App\Controller\VacancyController->vacancy (line 189)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

28.69 ms
(13.73%)

SELECT COUNT(v0_.id) AS sclr_0 FROM vacancies v0_ INNER JOIN company_employer c1_ ON v0_.manager_id = c1_.user_id WHERE c1_.company_id = ? AND v0_.published_at IS NOT NULL AND v0_.status = ? AND v0_.is_anonymous = false

Parameters:

[
  Symfony\Component\Uid\UuidV6 {#2574
    __toString(): "1f11eab9-0a82-6bde-977d-c7d0e949dcc1"
  }
  "public"
]

View formatted query View runnable query View query backtrace

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  vacancies v0_
  INNER JOIN company_employer c1_ ON v0_.manager_id = c1_.user_id
WHERE
  c1_.company_id = ?
  AND v0_.published_at IS NOT NULL
  AND v0_.status = ?
  AND v0_.is_anonymous = false

SELECT COUNT(v0_.id) AS sclr_0 FROM vacancies v0_ INNER JOIN company_employer c1_ ON v0_.manager_id = c1_.user_id WHERE c1_.company_id = '1f11eab9-0a82-6bde-977d-c7d0e949dcc1' AND v0_.published_at IS NOT NULL AND v0_.status = 'public' AND v0_.is_anonymous = false;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 996)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 1025)
7	App\Infrastructure\Company\Service\CompanyManager->App\Infrastructure\Company\Service\{closure} (line 146)
8	Kenny1911\Memoizer\Memoizer->memoize (line 32)
9	App\Infrastructure\Company\Service\CompanyManager->getCompanyInfo (line 124)
10	App\Util\RaberuVariable\CompanyHelper->getInfo (line 43)
11	Twig\Extension\CoreExtension->getAttribute (line 1918)
12	__TwigTemplate_20f66c3c34c84777402ebf6a52f6e1f0::doDisplay (line 56)
13	Twig\Template->yield (line 411)
14	Twig\Template->display (line 366)
15	Twig\Template->render (line 381)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
21	App\Controller\VacancyController->vacancyPublic (line 245)
22	App\Controller\VacancyController->vacancy (line 189)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

8.50 ms
(4.07%)

SELECT t0.title AS title_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM skill t0 INNER JOIN vacancy_skills ON t0.id = vacancy_skills.skill_id WHERE vacancy_skills.vacancy_id = ?

Parameters:

[
  "1f132273-aae8-67fc-8dcb-15a05c5a7685"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.title AS title_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4
FROM
  skill t0
  INNER JOIN vacancy_skills ON t0.id = vacancy_skills.skill_id
WHERE
  vacancy_skills.vacancy_id = ?

SELECT t0.title AS title_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM skill t0 INNER JOIN vacancy_skills ON t0.id = vacancy_skills.skill_id WHERE vacancy_skills.vacancy_id = '1f132273-aae8-67fc-8dcb-15a05c5a7685';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1143)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1065)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3322)
4	Doctrine\ORM\UnitOfWork->createEntity (line 3186)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 181)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 66)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 276)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 787)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
10	Doctrine\ORM\EntityManager->find (line 530)
11	Doctrine\ORM\EntityRepository->find (line 196)
12	App\Domain\Vacancy\Repository\DoctrineVacancyRepository->find (line 55)
13	App\Controller\VacancyController->vacancy (line 178)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 208)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 5)

7.56 ms
(3.62%)

SELECT t0.public_id AS public_id_1, t0.title AS title_2, t0.description AS description_3, t0.payment_period AS payment_period_4, t0.payment_format AS payment_format_5, t0.address AS address_6, t0.salary_min AS salary_min_7, t0.salary_max AS salary_max_8, t0.experience AS experience_9, t0.employment AS employment_10, t0.schedule AS schedule_11, t0.rate AS rate_12, t0.status AS status_13, t0.phone AS phone_14, t0.show_phone AS show_phone_15, t0.from14_years AS from14_years_16, t0.is_anonymous AS is_anonymous_17, t0.with_physical_disabilities AS with_physical_disabilities_18, t0.autopublish AS autopublish_19, t0.published_at AS published_at_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.archived_at AS archived_at_23, t0.id AS id_24, t0.moderation_id AS moderation_id_25, t0.manager_id AS manager_id_26, t0.specialization_id AS specialization_id_27, t0.city_id AS city_id_28 FROM vacancies t0 WHERE t0.id = ?

Parameters:

[
  "1f132273-aae8-67fc-8dcb-15a05c5a7685"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.public_id AS public_id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.payment_period AS payment_period_4,
  t0.payment_format AS payment_format_5,
  t0.address AS address_6,
  t0.salary_min AS salary_min_7,
  t0.salary_max AS salary_max_8,
  t0.experience AS experience_9,
  t0.employment AS employment_10,
  t0.schedule AS schedule_11,
  t0.rate AS rate_12,
  t0.status AS status_13,
  t0.phone AS phone_14,
  t0.show_phone AS show_phone_15,
  t0.from14_years AS from14_years_16,
  t0.is_anonymous AS is_anonymous_17,
  t0.with_physical_disabilities AS with_physical_disabilities_18,
  t0.autopublish AS autopublish_19,
  t0.published_at AS published_at_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.archived_at AS archived_at_23,
  t0.id AS id_24,
  t0.moderation_id AS moderation_id_25,
  t0.manager_id AS manager_id_26,
  t0.specialization_id AS specialization_id_27,
  t0.city_id AS city_id_28
FROM
  vacancies t0
WHERE
  t0.id = ?

SELECT t0.public_id AS public_id_1, t0.title AS title_2, t0.description AS description_3, t0.payment_period AS payment_period_4, t0.payment_format AS payment_format_5, t0.address AS address_6, t0.salary_min AS salary_min_7, t0.salary_max AS salary_max_8, t0.experience AS experience_9, t0.employment AS employment_10, t0.schedule AS schedule_11, t0.rate AS rate_12, t0.status AS status_13, t0.phone AS phone_14, t0.show_phone AS show_phone_15, t0.from14_years AS from14_years_16, t0.is_anonymous AS is_anonymous_17, t0.with_physical_disabilities AS with_physical_disabilities_18, t0.autopublish AS autopublish_19, t0.published_at AS published_at_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.archived_at AS archived_at_23, t0.id AS id_24, t0.moderation_id AS moderation_id_25, t0.manager_id AS manager_id_26, t0.specialization_id AS specialization_id_27, t0.city_id AS city_id_28 FROM vacancies t0 WHERE t0.id = '1f132273-aae8-67fc-8dcb-15a05c5a7685';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	App\Domain\Vacancy\Repository\DoctrineVacancyRepository->find (line 55)
6	App\Controller\VacancyController->vacancy (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 208)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

7.26 ms
(3.48%)

SELECT v0_.status_start AS status_start_0, v0_.status_end AS status_end_1, v0_.count_view_start AS count_view_start_2, v0_.count_view_end AS count_view_end_3, v0_.count_phone_view_start AS count_phone_view_start_4, v0_.count_phone_view_end AS count_phone_view_end_5, v0_.count_request_start AS count_request_start_6, v0_.count_request_end AS count_request_end_7, v0_.count_company_request_start AS count_company_request_start_8, v0_.count_company_request_end AS count_company_request_end_9, v0_.count_vacancy_favorite_start AS count_vacancy_favorite_start_10, v0_.count_vacancy_favorite_end AS count_vacancy_favorite_end_11, v0_.count_used_quotes_start AS count_used_quotes_start_12, v0_.count_used_quotes_end AS count_used_quotes_end_13, v0_.amount_quotes_price_start AS amount_quotes_price_start_14, v0_.amount_quotes_price_end AS amount_quotes_price_end_15, v0_.created_at AS created_at_16, v0_.updated_at AS updated_at_17, v0_.id AS id_18, v0_.vacancy_id AS vacancy_id_19, v0_.company_id AS company_id_20, v0_.city_start_id AS city_start_id_21, v0_.city_end_id AS city_end_id_22, v0_.manager_start_id AS manager_start_id_23, v0_.manager_end_id AS manager_end_id_24, v0_.specialization_start_id AS specialization_start_id_25, v0_.specialization_end_id AS specialization_end_id_26 FROM vacancy_snapshot v0_ WHERE v0_.company_id = ? AND (v0_.status_start IN (?, ?, ?) OR v0_.status_end IN (?, ?, ?)) AND v0_.vacancy_id = ? AND v0_.created_at >= ? AND v0_.created_at <= ?

Parameters:

[
  Symfony\Component\Uid\UuidV6 {#2510
    __toString(): "1f11eab9-0a82-6bde-977d-c7d0e949dcc1"
  }
  "public"
  "archive"
  "banned"
  "public"
  "archive"
  "banned"
  Symfony\Component\Uid\UuidV6 {#2258
    __toString(): "1f132273-aae8-67fc-8dcb-15a05c5a7685"
  }
  "2026-07-08 00:00:00"
  "2026-07-08 23:59:59"
]

View formatted query View runnable query View query backtrace

SELECT
  v0_.status_start AS status_start_0,
  v0_.status_end AS status_end_1,
  v0_.count_view_start AS count_view_start_2,
  v0_.count_view_end AS count_view_end_3,
  v0_.count_phone_view_start AS count_phone_view_start_4,
  v0_.count_phone_view_end AS count_phone_view_end_5,
  v0_.count_request_start AS count_request_start_6,
  v0_.count_request_end AS count_request_end_7,
  v0_.count_company_request_start AS count_company_request_start_8,
  v0_.count_company_request_end AS count_company_request_end_9,
  v0_.count_vacancy_favorite_start AS count_vacancy_favorite_start_10,
  v0_.count_vacancy_favorite_end AS count_vacancy_favorite_end_11,
  v0_.count_used_quotes_start AS count_used_quotes_start_12,
  v0_.count_used_quotes_end AS count_used_quotes_end_13,
  v0_.amount_quotes_price_start AS amount_quotes_price_start_14,
  v0_.amount_quotes_price_end AS amount_quotes_price_end_15,
  v0_.created_at AS created_at_16,
  v0_.updated_at AS updated_at_17,
  v0_.id AS id_18,
  v0_.vacancy_id AS vacancy_id_19,
  v0_.company_id AS company_id_20,
  v0_.city_start_id AS city_start_id_21,
  v0_.city_end_id AS city_end_id_22,
  v0_.manager_start_id AS manager_start_id_23,
  v0_.manager_end_id AS manager_end_id_24,
  v0_.specialization_start_id AS specialization_start_id_25,
  v0_.specialization_end_id AS specialization_end_id_26
FROM
  vacancy_snapshot v0_
WHERE
  v0_.company_id = ?
  AND (
    v0_.status_start IN (?, ?, ?)
    OR v0_.status_end IN (?, ?, ?)
  )
  AND v0_.vacancy_id = ?
  AND v0_.created_at >= ?
  AND v0_.created_at <= ?

SELECT v0_.status_start AS status_start_0, v0_.status_end AS status_end_1, v0_.count_view_start AS count_view_start_2, v0_.count_view_end AS count_view_end_3, v0_.count_phone_view_start AS count_phone_view_start_4, v0_.count_phone_view_end AS count_phone_view_end_5, v0_.count_request_start AS count_request_start_6, v0_.count_request_end AS count_request_end_7, v0_.count_company_request_start AS count_company_request_start_8, v0_.count_company_request_end AS count_company_request_end_9, v0_.count_vacancy_favorite_start AS count_vacancy_favorite_start_10, v0_.count_vacancy_favorite_end AS count_vacancy_favorite_end_11, v0_.count_used_quotes_start AS count_used_quotes_start_12, v0_.count_used_quotes_end AS count_used_quotes_end_13, v0_.amount_quotes_price_start AS amount_quotes_price_start_14, v0_.amount_quotes_price_end AS amount_quotes_price_end_15, v0_.created_at AS created_at_16, v0_.updated_at AS updated_at_17, v0_.id AS id_18, v0_.vacancy_id AS vacancy_id_19, v0_.company_id AS company_id_20, v0_.city_start_id AS city_start_id_21, v0_.city_end_id AS city_end_id_22, v0_.manager_start_id AS manager_start_id_23, v0_.manager_end_id AS manager_end_id_24, v0_.specialization_start_id AS specialization_start_id_25, v0_.specialization_end_id AS specialization_end_id_26 FROM vacancy_snapshot v0_ WHERE v0_.company_id = '1f11eab9-0a82-6bde-977d-c7d0e949dcc1' AND (v0_.status_start IN ('public', 'archive', 'banned') OR v0_.status_end IN ('public', 'archive', 'banned')) AND v0_.vacancy_id = '1f132273-aae8-67fc-8dcb-15a05c5a7685' AND v0_.created_at >= '2026-07-08 00:00:00' AND v0_.created_at <= '2026-07-08 23:59:59';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Infrastructure\Statistic\Repository\Snapshot\SnapshotRepository->findByVacancyAndDate (line 755)
7	App\Domain\Statistic\Service\BaseVacancySnapshotManager->getCurrentDateSnapshot (line 185)
8	App\Domain\Statistic\Service\BaseVacancySnapshotManager->syncView (line 121)
9	App\Infrastructure\Statistic\Doctrine\Listener\SnapShotSubscriber->postPersist (line 58)
10	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 63)
11	Doctrine\ORM\Event\ListenersInvoker->invoke (line 98)
12	Doctrine\ORM\UnitOfWork->executeInserts (line 1222)
13	Doctrine\ORM\UnitOfWork->commit (line 451)
14	Doctrine\ORM\EntityManager->flush (line 414)
15	App\Domain\Vacancy\Repository\DoctrineEventRepository->save (line 45)
16	App\Domain\Vacancy\Service\MainEventManager->viewVacancy (line 30)
17	App\Domain\Vacancy\Service\RequestSessionEventManager->App\Domain\Vacancy\Service\{closure} (line 56)
18	App\Domain\Vacancy\Service\RequestSessionEventManager->viewEvent (line 87)
19	App\Domain\Vacancy\Service\RequestSessionEventManager->viewVacancy (line 56)
20	App\Controller\VacancyController->vacancyPublic (line 220)
21	App\Controller\VacancyController->vacancy (line 189)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 208)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

7.12 ms
(3.40%)

SELECT t0.name AS name_1, t0.name_prepositional AS name_prepositional_2, t0.banner_path AS banner_path_3, t0.slug AS slug_4, t0.db_ip_light_city_id AS db_ip_light_city_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.metadata_title AS metadata_title_9, t0.metadata_description AS metadata_description_10, t0.metadata_keywords AS metadata_keywords_11, t0.region_id AS region_id_12 FROM city t0 WHERE t0.id = ?

Parameters:

[
  "019256cb-02ed-722a-9abe-5b511159effa"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.name_prepositional AS name_prepositional_2,
  t0.banner_path AS banner_path_3,
  t0.slug AS slug_4,
  t0.db_ip_light_city_id AS db_ip_light_city_id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.id AS id_8,
  t0.metadata_title AS metadata_title_9,
  t0.metadata_description AS metadata_description_10,
  t0.metadata_keywords AS metadata_keywords_11,
  t0.region_id AS region_id_12
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.name_prepositional AS name_prepositional_2, t0.banner_path AS banner_path_3, t0.slug AS slug_4, t0.db_ip_light_city_id AS db_ip_light_city_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.metadata_title AS metadata_title_9, t0.metadata_description AS metadata_description_10, t0.metadata_keywords AS metadata_keywords_11, t0.region_id AS region_id_12 FROM city t0 WHERE t0.id = '019256cb-02ed-722a-9abe-5b511159effa';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Domain\City\City::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Domain\City\City->__get (line 184)
7	App\Domain\City\City->getNamePrepositional (line 80)
8	App\Controller\VacancyController->vacancyPublic (line 198)
9	App\Controller\VacancyController->vacancy (line 189)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

6.19 ms
(2.96%)

SELECT DISTINCT v0_.public_id AS public_id_0, v0_.title AS title_1, v0_.description AS description_2, v0_.payment_period AS payment_period_3, v0_.payment_format AS payment_format_4, v0_.address AS address_5, v0_.salary_min AS salary_min_6, v0_.salary_max AS salary_max_7, v0_.experience AS experience_8, v0_.employment AS employment_9, v0_.schedule AS schedule_10, v0_.rate AS rate_11, v0_.status AS status_12, v0_.phone AS phone_13, v0_.show_phone AS show_phone_14, v0_.from14_years AS from14_years_15, v0_.is_anonymous AS is_anonymous_16, v0_.with_physical_disabilities AS with_physical_disabilities_17, v0_.autopublish AS autopublish_18, v0_.published_at AS published_at_19, v0_.created_at AS created_at_20, v0_.updated_at AS updated_at_21, v0_.archived_at AS archived_at_22, v0_.id AS id_23, v0_.moderation_id AS moderation_id_24, v0_.manager_id AS manager_id_25, v0_.specialization_id AS specialization_id_26, v0_.city_id AS city_id_27 FROM vacancies v0_ INNER JOIN company_employer c1_ ON v0_.manager_id = c1_.user_id WHERE v0_.status = ? AND v0_.published_at IS NOT NULL AND v0_.city_id IN (?, ?) AND v0_.specialization_id IN (?) AND v0_.id NOT IN (?) ORDER BY v0_.published_at DESC LIMIT 6

Parameters:

[
  "public"
  Symfony\Component\Uid\UuidV7 {#2262
    __toString(): "019256cb-02ed-722a-9abe-5b511159effa"
  }
  Symfony\Component\Uid\UuidV7 {#2262}
  Symfony\Component\Uid\UuidV6 {#2261
    __toString(): "1ef3cf54-a5c2-6552-92ee-79f51a8947b1"
  }
  Symfony\Component\Uid\UuidV6 {#2258
    __toString(): "1f132273-aae8-67fc-8dcb-15a05c5a7685"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  DISTINCT v0_.public_id AS public_id_0,
  v0_.title AS title_1,
  v0_.description AS description_2,
  v0_.payment_period AS payment_period_3,
  v0_.payment_format AS payment_format_4,
  v0_.address AS address_5,
  v0_.salary_min AS salary_min_6,
  v0_.salary_max AS salary_max_7,
  v0_.experience AS experience_8,
  v0_.employment AS employment_9,
  v0_.schedule AS schedule_10,
  v0_.rate AS rate_11,
  v0_.status AS status_12,
  v0_.phone AS phone_13,
  v0_.show_phone AS show_phone_14,
  v0_.from14_years AS from14_years_15,
  v0_.is_anonymous AS is_anonymous_16,
  v0_.with_physical_disabilities AS with_physical_disabilities_17,
  v0_.autopublish AS autopublish_18,
  v0_.published_at AS published_at_19,
  v0_.created_at AS created_at_20,
  v0_.updated_at AS updated_at_21,
  v0_.archived_at AS archived_at_22,
  v0_.id AS id_23,
  v0_.moderation_id AS moderation_id_24,
  v0_.manager_id AS manager_id_25,
  v0_.specialization_id AS specialization_id_26,
  v0_.city_id AS city_id_27
FROM
  vacancies v0_
  INNER JOIN company_employer c1_ ON v0_.manager_id = c1_.user_id
WHERE
  v0_.status = ?
  AND v0_.published_at IS NOT NULL
  AND v0_.city_id IN (?, ?)
  AND v0_.specialization_id IN (?)
  AND v0_.id NOT IN (?)
ORDER BY
  v0_.published_at DESC
LIMIT
  6

SELECT DISTINCT v0_.public_id AS public_id_0, v0_.title AS title_1, v0_.description AS description_2, v0_.payment_period AS payment_period_3, v0_.payment_format AS payment_format_4, v0_.address AS address_5, v0_.salary_min AS salary_min_6, v0_.salary_max AS salary_max_7, v0_.experience AS experience_8, v0_.employment AS employment_9, v0_.schedule AS schedule_10, v0_.rate AS rate_11, v0_.status AS status_12, v0_.phone AS phone_13, v0_.show_phone AS show_phone_14, v0_.from14_years AS from14_years_15, v0_.is_anonymous AS is_anonymous_16, v0_.with_physical_disabilities AS with_physical_disabilities_17, v0_.autopublish AS autopublish_18, v0_.published_at AS published_at_19, v0_.created_at AS created_at_20, v0_.updated_at AS updated_at_21, v0_.archived_at AS archived_at_22, v0_.id AS id_23, v0_.moderation_id AS moderation_id_24, v0_.manager_id AS manager_id_25, v0_.specialization_id AS specialization_id_26, v0_.city_id AS city_id_27 FROM vacancies v0_ INNER JOIN company_employer c1_ ON v0_.manager_id = c1_.user_id WHERE v0_.status = 'public' AND v0_.published_at IS NOT NULL AND v0_.city_id IN ('019256cb-02ed-722a-9abe-5b511159effa', '019256cb-02ed-722a-9abe-5b511159effa') AND v0_.specialization_id IN ('1ef3cf54-a5c2-6552-92ee-79f51a8947b1') AND v0_.id NOT IN ('1f132273-aae8-67fc-8dcb-15a05c5a7685') ORDER BY v0_.published_at DESC LIMIT 6;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Domain\Vacancy\Repository\DoctrineVacancyRepository->findByPublicFilter (line 252)
7	App\Domain\Vacancy\Service\MainVacancyManager->findByPublicFilters (line 349)
8	App\Domain\Vacancy\Service\MainVacancyManager->getSimilarVacancies (line 331)
9	App\Domain\Vacancy\Service\CompanyConfirmationVacancyManager->getSimilarVacancies (line 166)
10	App\Domain\Vacancy\Service\TransactionalVacancyManager->getSimilarVacancies (line 136)
11	App\Controller\VacancyController->vacancyPublic (line 237)
12	App\Controller\VacancyController->vacancy (line 189)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 208)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

4.44 ms
(2.12%)

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM company_feedback c0_ INNER JOIN feedback_moderation f1_ ON c0_.moderation_id = f1_.id WHERE c0_.company_id = ? AND f1_.moderation_status IN (?, ?)

Parameters:

[
  Symfony\Component\Uid\UuidV6 {#2510
    __toString(): "1f11eab9-0a82-6bde-977d-c7d0e949dcc1"
  }
  "moderation"
  "accepted"
]

View formatted query View runnable query View query backtrace

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  company_feedback c0_
  INNER JOIN feedback_moderation f1_ ON c0_.moderation_id = f1_.id
WHERE
  c0_.company_id = ?
  AND f1_.moderation_status IN (?, ?)

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM company_feedback c0_ INNER JOIN feedback_moderation f1_ ON c0_.moderation_id = f1_.id WHERE c0_.company_id = '1f11eab9-0a82-6bde-977d-c7d0e949dcc1' AND f1_.moderation_status IN ('moderation', 'accepted');

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 996)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 1025)
7	App\Infrastructure\Feedback\Repository\BaseFeedbackRepository->countByFilter (line 70)
8	App\Infrastructure\Company\Service\CompanyManager->App\Infrastructure\Company\Service\{closure} (line 171)
9	Kenny1911\Memoizer\Memoizer->memoize (line 32)
10	App\Infrastructure\Company\Service\CompanyManager->getCompanyInfo (line 124)
11	App\Util\RaberuVariable\CompanyHelper->getInfo (line 43)
12	Twig\Extension\CoreExtension->getAttribute (line 1918)
13	__TwigTemplate_20f66c3c34c84777402ebf6a52f6e1f0::doDisplay (line 56)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
22	App\Controller\VacancyController->vacancyPublic (line 245)
23	App\Controller\VacancyController->vacancy (line 189)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 208)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

3.40 ms
(1.62%)

INSERT INTO vacancy_view (created_at, id, vacancy_id, manager_id, user_id) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  "2026-07-08 12:54:54"
  "1f17acc3-7586-6bac-970e-834b9e114815"
  "1f132273-aae8-67fc-8dcb-15a05c5a7685"
  "1f12e603-d1db-6406-a1ea-03fed57d5ded"
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO vacancy_view (
  created_at, id, vacancy_id, manager_id,
  user_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO vacancy_view (created_at, id, vacancy_id, manager_id, user_id) VALUES ('2026-07-08 12:54:54', '1f17acc3-7586-6bac-970e-834b9e114815', '1f132273-aae8-67fc-8dcb-15a05c5a7685', '1f12e603-d1db-6406-a1ea-03fed57d5ded', NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 288)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1191)
4	Doctrine\ORM\UnitOfWork->commit (line 451)
5	Doctrine\ORM\EntityManager->flush (line 414)
6	App\Domain\Vacancy\Repository\DoctrineEventRepository->save (line 45)
7	App\Domain\Vacancy\Service\MainEventManager->viewVacancy (line 30)
8	App\Domain\Vacancy\Service\RequestSessionEventManager->App\Domain\Vacancy\Service\{closure} (line 56)
9	App\Domain\Vacancy\Service\RequestSessionEventManager->viewEvent (line 87)
10	App\Domain\Vacancy\Service\RequestSessionEventManager->viewVacancy (line 56)
11	App\Controller\VacancyController->vacancyPublic (line 220)
12	App\Controller\VacancyController->vacancy (line 189)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 208)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

3.22 ms
(1.54%)

SELECT t0.public_id AS public_id_1, t0.title AS title_2, t0.inn AS inn_3, t0.description AS description_4, t0.logo_path AS logo_path_5, t0.confirmed AS confirmed_6, t0.contract_path AS contract_path_7, t0.rating AS rating_8, t0.site AS site_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.id AS id_12, t0.city_id AS city_id_13, t0.category_id AS category_id_14 FROM companies t0 WHERE t0.id = ?

Parameters:

[
  "1f11eab9-0a82-6bde-977d-c7d0e949dcc1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.public_id AS public_id_1,
  t0.title AS title_2,
  t0.inn AS inn_3,
  t0.description AS description_4,
  t0.logo_path AS logo_path_5,
  t0.confirmed AS confirmed_6,
  t0.contract_path AS contract_path_7,
  t0.rating AS rating_8,
  t0.site AS site_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.id AS id_12,
  t0.city_id AS city_id_13,
  t0.category_id AS category_id_14
FROM
  companies t0
WHERE
  t0.id = ?

SELECT t0.public_id AS public_id_1, t0.title AS title_2, t0.inn AS inn_3, t0.description AS description_4, t0.logo_path AS logo_path_5, t0.confirmed AS confirmed_6, t0.contract_path AS contract_path_7, t0.rating AS rating_8, t0.site AS site_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.id AS id_12, t0.city_id AS city_id_13, t0.category_id AS category_id_14 FROM companies t0 WHERE t0.id = '1f11eab9-0a82-6bde-977d-c7d0e949dcc1';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Domain\Company\Company::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Domain\Company\Company->__get (line 184)
7	App\Domain\Company\Company->getTitle (line 76)
8	App\Controller\VacancyController->vacancyToJson (line 295)
9	App\Controller\VacancyController->vacancyPublic (line 243)
10	App\Controller\VacancyController->vacancy (line 189)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 208)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

2.00 ms
(0.96%)

SELECT t0.role AS role_1, t0.position AS position_2, t0.comment AS comment_3, t0.phone AS phone_4, t0.limit_basic AS limit_basic_5, t0.limit_optimum AS limit_optimum_6, t0.user_id AS user_id_7, t0.company_id AS company_id_8 FROM company_employer t0 WHERE t0.user_id = ?

Parameters:

[
  "1f12e603-d1db-6406-a1ea-03fed57d5ded"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.role AS role_1,
  t0.position AS position_2,
  t0.comment AS comment_3,
  t0.phone AS phone_4,
  t0.limit_basic AS limit_basic_5,
  t0.limit_optimum AS limit_optimum_6,
  t0.user_id AS user_id_7,
  t0.company_id AS company_id_8
FROM
  company_employer t0
WHERE
  t0.user_id = ?

SELECT t0.role AS role_1, t0.position AS position_2, t0.comment AS comment_3, t0.phone AS phone_4, t0.limit_basic AS limit_basic_5, t0.limit_optimum AS limit_optimum_6, t0.user_id AS user_id_7, t0.company_id AS company_id_8 FROM company_employer t0 WHERE t0.user_id = '1f12e603-d1db-6406-a1ea-03fed57d5ded';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Domain\Employer\Employer::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Domain\Employer\Employer->__get (line 184)
7	App\Domain\Employer\Employer->getCompany (line 60)
8	App\Domain\Vacancy\Vacancy->getCompany (line 169)
9	App\Infrastructure\Statistic\Repository\Snapshot\SnapshotRepository->findByVacancyAndDate (line 749)
10	App\Domain\Statistic\Service\BaseVacancySnapshotManager->getCurrentDateSnapshot (line 185)
11	App\Domain\Statistic\Service\BaseVacancySnapshotManager->syncView (line 121)
12	App\Infrastructure\Statistic\Doctrine\Listener\SnapShotSubscriber->postPersist (line 58)
13	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 63)
14	Doctrine\ORM\Event\ListenersInvoker->invoke (line 98)
15	Doctrine\ORM\UnitOfWork->executeInserts (line 1222)
16	Doctrine\ORM\UnitOfWork->commit (line 451)
17	Doctrine\ORM\EntityManager->flush (line 414)
18	App\Domain\Vacancy\Repository\DoctrineEventRepository->save (line 45)
19	App\Domain\Vacancy\Service\MainEventManager->viewVacancy (line 30)
20	App\Domain\Vacancy\Service\RequestSessionEventManager->App\Domain\Vacancy\Service\{closure} (line 56)
21	App\Domain\Vacancy\Service\RequestSessionEventManager->viewEvent (line 87)
22	App\Domain\Vacancy\Service\RequestSessionEventManager->viewVacancy (line 56)
23	App\Controller\VacancyController->vacancyPublic (line 220)
24	App\Controller\VacancyController->vacancy (line 189)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 208)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

1.92 ms
(0.92%)

SELECT COUNT(DISTINCT v0_.id) AS sclr_0 FROM vacancies v0_ INNER JOIN company_employer c1_ ON v0_.manager_id = c1_.user_id WHERE v0_.status = ? AND v0_.published_at IS NOT NULL AND v0_.city_id IN (?) AND v0_.specialization_id IN (?) AND v0_.id NOT IN (?)

Parameters:

[
  "public"
  Symfony\Component\Uid\UuidV7 {#2262
    __toString(): "019256cb-02ed-722a-9abe-5b511159effa"
  }
  Symfony\Component\Uid\UuidV6 {#2261
    __toString(): "1ef3cf54-a5c2-6552-92ee-79f51a8947b1"
  }
  Symfony\Component\Uid\UuidV6 {#2258
    __toString(): "1f132273-aae8-67fc-8dcb-15a05c5a7685"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  COUNT(DISTINCT v0_.id) AS sclr_0
FROM
  vacancies v0_
  INNER JOIN company_employer c1_ ON v0_.manager_id = c1_.user_id
WHERE
  v0_.status = ?
  AND v0_.published_at IS NOT NULL
  AND v0_.city_id IN (?)
  AND v0_.specialization_id IN (?)
  AND v0_.id NOT IN (?)

SELECT COUNT(DISTINCT v0_.id) AS sclr_0 FROM vacancies v0_ INNER JOIN company_employer c1_ ON v0_.manager_id = c1_.user_id WHERE v0_.status = 'public' AND v0_.published_at IS NOT NULL AND v0_.city_id IN ('019256cb-02ed-722a-9abe-5b511159effa') AND v0_.specialization_id IN ('1ef3cf54-a5c2-6552-92ee-79f51a8947b1') AND v0_.id NOT IN ('1f132273-aae8-67fc-8dcb-15a05c5a7685');

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 996)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 1025)
7	App\Domain\Vacancy\Repository\DoctrineVacancyRepository->countByPublicFilter (line 272)
8	App\Controller\VacancyController->vacancyPublic (line 235)
9	App\Controller\VacancyController->vacancy (line 189)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

1.70 ms
(0.81%)

SELECT t0.balance AS balance_1, t0.company_id AS company_id_2 FROM company_personal_account t0 WHERE t0.company_id = ?

Parameters:

[
  "1f11eab9-0a82-6bde-977d-c7d0e949dcc1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.balance AS balance_1,
  t0.company_id AS company_id_2
FROM
  company_personal_account t0
WHERE
  t0.company_id = ?

SELECT t0.balance AS balance_1, t0.company_id AS company_id_2 FROM company_personal_account t0 WHERE t0.company_id = '1f11eab9-0a82-6bde-977d-c7d0e949dcc1';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	App\Infrastructure\PersonalAccount\Doctrine\Listener\CompanyPersonalAccountSubscriber->createPersonalAccount (line 55)
6	App\Infrastructure\PersonalAccount\Doctrine\Listener\CompanyPersonalAccountSubscriber->postLoad (line 39)
7	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 63)
8	Doctrine\ORM\Event\ListenersInvoker->invoke (line 98)
9	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 66)
10	Doctrine\ORM\UnitOfWork->hydrationComplete (line 4000)
11	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 55)
12	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 278)
13	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 787)
14	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
15	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
16	Proxies\__CG__\App\Domain\Company\Company::Doctrine\ORM\Proxy\{closure} (line 479)
17	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
18	Proxies\__CG__\App\Domain\Company\Company->__get (line 184)
19	App\Domain\Company\Company->getTitle (line 76)
20	App\Controller\VacancyController->vacancyToJson (line 295)
21	App\Controller\VacancyController->vacancyPublic (line 243)
22	App\Controller\VacancyController->vacancy (line 189)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

1.68 ms
(0.80%)

SELECT DISTINCT v0_.public_id AS public_id_0, v0_.title AS title_1, v0_.description AS description_2, v0_.payment_period AS payment_period_3, v0_.payment_format AS payment_format_4, v0_.address AS address_5, v0_.salary_min AS salary_min_6, v0_.salary_max AS salary_max_7, v0_.experience AS experience_8, v0_.employment AS employment_9, v0_.schedule AS schedule_10, v0_.rate AS rate_11, v0_.status AS status_12, v0_.phone AS phone_13, v0_.show_phone AS show_phone_14, v0_.from14_years AS from14_years_15, v0_.is_anonymous AS is_anonymous_16, v0_.with_physical_disabilities AS with_physical_disabilities_17, v0_.autopublish AS autopublish_18, v0_.published_at AS published_at_19, v0_.created_at AS created_at_20, v0_.updated_at AS updated_at_21, v0_.archived_at AS archived_at_22, v0_.id AS id_23, v0_.moderation_id AS moderation_id_24, v0_.manager_id AS manager_id_25, v0_.specialization_id AS specialization_id_26, v0_.city_id AS city_id_27 FROM vacancies v0_ INNER JOIN company_employer c1_ ON v0_.manager_id = c1_.user_id WHERE v0_.status = ? AND v0_.published_at IS NOT NULL AND v0_.city_id IN (?) AND v0_.specialization_id IN (?, ?, ?, ?) AND v0_.id NOT IN (?, ?, ?, ?, ?, ?) ORDER BY v0_.published_at DESC LIMIT 1

Parameters:

[
  "public"
  Symfony\Component\Uid\UuidV7 {#2262
    __toString(): "019256cb-02ed-722a-9abe-5b511159effa"
  }
  Symfony\Component\Uid\UuidV6 {#2615
    __toString(): "1ef3ac0d-8d10-6f32-a4e6-b79f5efecbee"
  }
  Symfony\Component\Uid\UuidV6 {#2622
    __toString(): "1ef3d02d-4cb5-6606-a32d-f50dab872eab"
  }
  Symfony\Component\Uid\UuidV6 {#2636
    __toString(): "1ef3d045-c324-6eaa-b5a6-7701a4e2e1d7"
  }
  Symfony\Component\Uid\UuidV6 {#2645
    __toString(): "1ef3d03f-c368-6d5e-b99c-657c75994e0e"
  }
  Symfony\Component\Uid\UuidV6 {#2258
    __toString(): "1f132273-aae8-67fc-8dcb-15a05c5a7685"
  }
  Symfony\Component\Uid\UuidV6 {#2706
    __toString(): "1f179d33-d4f4-6c28-a7d3-53cc63a46c52"
  }
  Symfony\Component\Uid\UuidV6 {#2689
    __toString(): "1f132025-f7e4-69ac-b8ed-6d30aba82b26"
  }
  Symfony\Component\Uid\UuidV6 {#2680
    __toString(): "1f14e405-206a-6e40-903c-4d7db34cae96"
  }
  Symfony\Component\Uid\UuidV6 {#2745
    __toString(): "1f14e15f-7412-6a0a-9baa-d395b6d1791a"
  }
  Symfony\Component\Uid\UuidV6 {#2721
    __toString(): "1f13473f-a11a-60e0-b6b7-bd7e4da3a37f"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  DISTINCT v0_.public_id AS public_id_0,
  v0_.title AS title_1,
  v0_.description AS description_2,
  v0_.payment_period AS payment_period_3,
  v0_.payment_format AS payment_format_4,
  v0_.address AS address_5,
  v0_.salary_min AS salary_min_6,
  v0_.salary_max AS salary_max_7,
  v0_.experience AS experience_8,
  v0_.employment AS employment_9,
  v0_.schedule AS schedule_10,
  v0_.rate AS rate_11,
  v0_.status AS status_12,
  v0_.phone AS phone_13,
  v0_.show_phone AS show_phone_14,
  v0_.from14_years AS from14_years_15,
  v0_.is_anonymous AS is_anonymous_16,
  v0_.with_physical_disabilities AS with_physical_disabilities_17,
  v0_.autopublish AS autopublish_18,
  v0_.published_at AS published_at_19,
  v0_.created_at AS created_at_20,
  v0_.updated_at AS updated_at_21,
  v0_.archived_at AS archived_at_22,
  v0_.id AS id_23,
  v0_.moderation_id AS moderation_id_24,
  v0_.manager_id AS manager_id_25,
  v0_.specialization_id AS specialization_id_26,
  v0_.city_id AS city_id_27
FROM
  vacancies v0_
  INNER JOIN company_employer c1_ ON v0_.manager_id = c1_.user_id
WHERE
  v0_.status = ?
  AND v0_.published_at IS NOT NULL
  AND v0_.city_id IN (?)
  AND v0_.specialization_id IN (?, ?, ?, ?)
  AND v0_.id NOT IN (?, ?, ?, ?, ?, ?)
ORDER BY
  v0_.published_at DESC
LIMIT
  1

SELECT DISTINCT v0_.public_id AS public_id_0, v0_.title AS title_1, v0_.description AS description_2, v0_.payment_period AS payment_period_3, v0_.payment_format AS payment_format_4, v0_.address AS address_5, v0_.salary_min AS salary_min_6, v0_.salary_max AS salary_max_7, v0_.experience AS experience_8, v0_.employment AS employment_9, v0_.schedule AS schedule_10, v0_.rate AS rate_11, v0_.status AS status_12, v0_.phone AS phone_13, v0_.show_phone AS show_phone_14, v0_.from14_years AS from14_years_15, v0_.is_anonymous AS is_anonymous_16, v0_.with_physical_disabilities AS with_physical_disabilities_17, v0_.autopublish AS autopublish_18, v0_.published_at AS published_at_19, v0_.created_at AS created_at_20, v0_.updated_at AS updated_at_21, v0_.archived_at AS archived_at_22, v0_.id AS id_23, v0_.moderation_id AS moderation_id_24, v0_.manager_id AS manager_id_25, v0_.specialization_id AS specialization_id_26, v0_.city_id AS city_id_27 FROM vacancies v0_ INNER JOIN company_employer c1_ ON v0_.manager_id = c1_.user_id WHERE v0_.status = 'public' AND v0_.published_at IS NOT NULL AND v0_.city_id IN ('019256cb-02ed-722a-9abe-5b511159effa') AND v0_.specialization_id IN ('1ef3ac0d-8d10-6f32-a4e6-b79f5efecbee', '1ef3d02d-4cb5-6606-a32d-f50dab872eab', '1ef3d045-c324-6eaa-b5a6-7701a4e2e1d7', '1ef3d03f-c368-6d5e-b99c-657c75994e0e') AND v0_.id NOT IN ('1f132273-aae8-67fc-8dcb-15a05c5a7685', '1f179d33-d4f4-6c28-a7d3-53cc63a46c52', '1f132025-f7e4-69ac-b8ed-6d30aba82b26', '1f14e405-206a-6e40-903c-4d7db34cae96', '1f14e15f-7412-6a0a-9baa-d395b6d1791a', '1f13473f-a11a-60e0-b6b7-bd7e4da3a37f') ORDER BY v0_.published_at DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Domain\Vacancy\Repository\DoctrineVacancyRepository->findByPublicFilter (line 252)
7	App\Domain\Vacancy\Service\MainVacancyManager->findByPublicFilters (line 349)
8	App\Domain\Vacancy\Service\MainVacancyManager->getSimilarVacancies (line 331)
9	App\Domain\Vacancy\Service\CompanyConfirmationVacancyManager->getSimilarVacancies (line 166)
10	App\Domain\Vacancy\Service\TransactionalVacancyManager->getSimilarVacancies (line 136)
11	App\Controller\VacancyController->vacancyPublic (line 237)
12	App\Controller\VacancyController->vacancy (line 189)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 208)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

1.60 ms
(0.76%)

SELECT t0.name AS name_1, t0.metadata_slug AS metadata_slug_2, t0.metadata_title AS metadata_title_3, t0.metadata_description AS metadata_description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7 FROM specialization t0 INNER JOIN specialization_related_specializations ON t0.id = specialization_related_specializations.related_specialization_id WHERE specialization_related_specializations.specialization_id = ?

Parameters:

[
  "1ef3cf54-a5c2-6552-92ee-79f51a8947b1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.metadata_slug AS metadata_slug_2,
  t0.metadata_title AS metadata_title_3,
  t0.metadata_description AS metadata_description_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.id AS id_7
FROM
  specialization t0
  INNER JOIN specialization_related_specializations ON t0.id = specialization_related_specializations.related_specialization_id
WHERE
  specialization_related_specializations.specialization_id = ?

SELECT t0.name AS name_1, t0.metadata_slug AS metadata_slug_2, t0.metadata_title AS metadata_title_3, t0.metadata_description AS metadata_description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7 FROM specialization t0 INNER JOIN specialization_related_specializations ON t0.id = specialization_related_specializations.related_specialization_id WHERE specialization_related_specializations.specialization_id = '1ef3cf54-a5c2-6552-92ee-79f51a8947b1';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1143)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1065)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3322)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 159)
7	App\Domain\Vacancy\Service\MainVacancyManager->getSimilarVacancies (line 321)
8	App\Domain\Vacancy\Service\CompanyConfirmationVacancyManager->getSimilarVacancies (line 166)
9	App\Domain\Vacancy\Service\TransactionalVacancyManager->getSimilarVacancies (line 136)
10	App\Controller\VacancyController->vacancyPublic (line 237)
11	App\Controller\VacancyController->vacancy (line 189)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 208)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

1.52 ms
(0.73%)

SELECT t0.name AS name_1, t0.metadata_slug AS metadata_slug_2, t0.metadata_title AS metadata_title_3, t0.metadata_description AS metadata_description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7 FROM specialization t0 WHERE t0.id = ?

Parameters:

[
  "1ef3cf54-a5c2-6552-92ee-79f51a8947b1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.metadata_slug AS metadata_slug_2,
  t0.metadata_title AS metadata_title_3,
  t0.metadata_description AS metadata_description_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.id AS id_7
FROM
  specialization t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.metadata_slug AS metadata_slug_2, t0.metadata_title AS metadata_title_3, t0.metadata_description AS metadata_description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7 FROM specialization t0 WHERE t0.id = '1ef3cf54-a5c2-6552-92ee-79f51a8947b1';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Domain\Specialization\Specialization::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Domain\Specialization\Specialization->__get (line 184)
7	App\Domain\Specialization\Specialization->getRelatedSpecializations (line 69)
8	App\Domain\Vacancy\Service\MainVacancyManager->getSimilarVacancies (line 321)
9	App\Domain\Vacancy\Service\CompanyConfirmationVacancyManager->getSimilarVacancies (line 166)
10	App\Domain\Vacancy\Service\TransactionalVacancyManager->getSimilarVacancies (line 136)
11	App\Controller\VacancyController->vacancyPublic (line 237)
12	App\Controller\VacancyController->vacancy (line 189)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 208)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

1.52 ms
(0.73%)

SELECT t0.id AS id_1, t0.moderation_status AS moderation_status_2, t0.moderation_comment AS moderation_comment_3, t0.moderation_created_at AS moderation_created_at_4, t0.moderation_moderated_at AS moderation_moderated_at_5, t0.vacancy_id AS vacancy_id_6 FROM vacancy_moderation t0 WHERE t0.id = ?

Parameters:

[
  "1f165669-543d-6aec-a1ba-af2bb672909d"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.moderation_status AS moderation_status_2,
  t0.moderation_comment AS moderation_comment_3,
  t0.moderation_created_at AS moderation_created_at_4,
  t0.moderation_moderated_at AS moderation_moderated_at_5,
  t0.vacancy_id AS vacancy_id_6
FROM
  vacancy_moderation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.moderation_status AS moderation_status_2, t0.moderation_comment AS moderation_comment_3, t0.moderation_created_at AS moderation_created_at_4, t0.moderation_moderated_at AS moderation_moderated_at_5, t0.vacancy_id AS vacancy_id_6 FROM vacancy_moderation t0 WHERE t0.id = '1f165669-543d-6aec-a1ba-af2bb672909d';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Domain\Moderation\VacancyModeration::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Domain\Moderation\VacancyModeration->__get (line 184)
7	App\Domain\Moderation\VacancyModeration->getModeration (line 28)
8	App\Controller\VacancyController->vacancyPublic (line 214)
9	App\Controller\VacancyController->vacancy (line 189)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

1.35 ms
(0.65%)

SELECT COUNT(view.id) FROM vacancy_view view
    LEFT JOIN vacancies v ON v.id = view.vacancy_id
    WHERE view.vacancy_id = ?
    AND v.status = ?
    AND view.created_at > date_trunc('day', now())
    AND view.created_at < now()

Parameters:

[
  "1f132273-aae8-67fc-8dcb-15a05c5a7685"
  "public"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(view.id)
FROM
  vacancy_view view
  LEFT JOIN vacancies v ON v.id = view.vacancy_id
WHERE
  view.vacancy_id = ?
  AND v.status = ?
  AND view.created_at > date_trunc(
    'day',
    now()
  )
  AND view.created_at < now()

SELECT COUNT(view.id) FROM vacancy_view view
    LEFT JOIN vacancies v ON v.id = view.vacancy_id
    WHERE view.vacancy_id = '1f132273-aae8-67fc-8dcb-15a05c5a7685'
    AND v.status = 'public'
    AND view.created_at > date_trunc('day', now())
    AND view.created_at < now();

#	File/Call
1	App\Domain\Vacancy\Repository\DoctrineVacancyRepository->todayView (line 425)
2	App\Controller\VacancyController->vacancyPublic (line 254)
3	App\Controller\VacancyController->vacancy (line 189)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 208)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

1.23 ms
(0.59%)

SELECT COUNT(v0_.id) AS sclr_0 FROM vacancy_view v0_ WHERE v0_.vacancy_id = ? AND v0_.created_at >= ? AND v0_.created_at <= ?

Parameters:

[
  Symfony\Component\Uid\UuidV6 {#2258
    __toString(): "1f132273-aae8-67fc-8dcb-15a05c5a7685"
  }
  "2026-07-08 00:00:00"
  "2026-07-08 23:59:59"
]

View formatted query View runnable query View query backtrace

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  vacancy_view v0_
WHERE
  v0_.vacancy_id = ?
  AND v0_.created_at >= ?
  AND v0_.created_at <= ?

SELECT COUNT(v0_.id) AS sclr_0 FROM vacancy_view v0_ WHERE v0_.vacancy_id = '1f132273-aae8-67fc-8dcb-15a05c5a7685' AND v0_.created_at >= '2026-07-08 00:00:00' AND v0_.created_at <= '2026-07-08 23:59:59';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 996)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 1025)
7	App\Domain\Vacancy\Repository\DoctrineEventRepository->countEventByFilter (line 38)
8	App\Domain\Statistic\Service\BaseVacancySnapshotManager->getEventView (line 227)
9	App\Domain\Statistic\Service\BaseVacancySnapshotManager->syncView (line 123)
10	App\Infrastructure\Statistic\Doctrine\Listener\SnapShotSubscriber->postPersist (line 58)
11	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 63)
12	Doctrine\ORM\Event\ListenersInvoker->invoke (line 98)
13	Doctrine\ORM\UnitOfWork->executeInserts (line 1222)
14	Doctrine\ORM\UnitOfWork->commit (line 451)
15	Doctrine\ORM\EntityManager->flush (line 414)
16	App\Domain\Vacancy\Repository\DoctrineEventRepository->save (line 45)
17	App\Domain\Vacancy\Service\MainEventManager->viewVacancy (line 30)
18	App\Domain\Vacancy\Service\RequestSessionEventManager->App\Domain\Vacancy\Service\{closure} (line 56)
19	App\Domain\Vacancy\Service\RequestSessionEventManager->viewEvent (line 87)
20	App\Domain\Vacancy\Service\RequestSessionEventManager->viewVacancy (line 56)
21	App\Controller\VacancyController->vacancyPublic (line 220)
22	App\Controller\VacancyController->vacancy (line 189)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

1.13 ms
(0.54%)

SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?

Parameters:

[
  "1ef50b3c-3914-6f3e-b5bb-cbcce4d57cb5"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = '1ef50b3c-3914-6f3e-b5bb-cbcce4d57cb5';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Domain\City\Region::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Domain\City\Region->__get (line 184)
7	App\Domain\City\Region->getName (line 42)
8	App\Controller\VacancyController->vacancyToJson (line 345)
9	App\Controller\VacancyController->vacancyPublic (line 243)
10	App\Controller\VacancyController->vacancy (line 189)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 208)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.93 ms
(0.45%)

"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\ORM\UnitOfWork->commit (line 480)
3	Doctrine\ORM\EntityManager->flush (line 414)
4	App\Domain\Vacancy\Repository\DoctrineEventRepository->save (line 45)
5	App\Domain\Vacancy\Service\MainEventManager->viewVacancy (line 30)
6	App\Domain\Vacancy\Service\RequestSessionEventManager->App\Domain\Vacancy\Service\{closure} (line 56)
7	App\Domain\Vacancy\Service\RequestSessionEventManager->viewEvent (line 87)
8	App\Domain\Vacancy\Service\RequestSessionEventManager->viewVacancy (line 56)
9	App\Controller\VacancyController->vacancyPublic (line 220)
10	App\Controller\VacancyController->vacancy (line 189)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 208)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.88 ms
(0.42%)

UPDATE vacancy_snapshot SET count_view_end = ?, updated_at = ? WHERE id = ?

Parameters:

[
  2
  "2026-07-08 12:54:54"
  "1f17abc1-80c5-691c-9d01-edda31818f97"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  vacancy_snapshot
SET
  count_view_end = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE vacancy_snapshot SET count_view_end = 2, updated_at = '2026-07-08 12:54:54' WHERE id = '1f17abc1-80c5-691c-9d01-edda31818f97';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 536)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 422)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1283)
4	Doctrine\ORM\UnitOfWork->commit (line 456)
5	Doctrine\ORM\EntityManager->flush (line 414)
6	App\Infrastructure\Statistic\Repository\Snapshot\SnapshotRepository->persist (line 768)
7	App\Domain\Statistic\Service\BaseVacancySnapshotManager->syncView (line 125)
8	App\Infrastructure\Statistic\Doctrine\Listener\SnapShotSubscriber->postPersist (line 58)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 63)
10	Doctrine\ORM\Event\ListenersInvoker->invoke (line 98)
11	Doctrine\ORM\UnitOfWork->executeInserts (line 1222)
12	Doctrine\ORM\UnitOfWork->commit (line 451)
13	Doctrine\ORM\EntityManager->flush (line 414)
14	App\Domain\Vacancy\Repository\DoctrineEventRepository->save (line 45)
15	App\Domain\Vacancy\Service\MainEventManager->viewVacancy (line 30)
16	App\Domain\Vacancy\Service\RequestSessionEventManager->App\Domain\Vacancy\Service\{closure} (line 56)
17	App\Domain\Vacancy\Service\RequestSessionEventManager->viewEvent (line 87)
18	App\Domain\Vacancy\Service\RequestSessionEventManager->viewVacancy (line 56)
19	App\Controller\VacancyController->vacancyPublic (line 220)
20	App\Controller\VacancyController->vacancy (line 189)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 208)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.79 ms
(0.38%)

SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM category t0 WHERE t0.id = ?

Parameters:

[
  "1ef3abc9-eb97-6928-a44d-8111c8106405"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM category t0 WHERE t0.id = '1ef3abc9-eb97-6928-a44d-8111c8106405';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Domain\Category\Category::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Domain\Category\Category->__get (line 184)
7	App\Domain\Category\Category->getName (line 33)
8	App\Infrastructure\Company\Service\CompanyManager->App\Infrastructure\Company\Service\{closure} (line 184)
9	Kenny1911\Memoizer\Memoizer->memoize (line 32)
10	App\Infrastructure\Company\Service\CompanyManager->getCompanyInfo (line 124)
11	App\Util\RaberuVariable\CompanyHelper->getInfo (line 43)
12	Twig\Extension\CoreExtension->getAttribute (line 1918)
13	__TwigTemplate_20f66c3c34c84777402ebf6a52f6e1f0::doDisplay (line 56)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
22	App\Controller\VacancyController->vacancyPublic (line 245)
23	App\Controller\VacancyController->vacancy (line 189)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 208)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.73 ms
(0.35%)

SELECT COUNT(view.id) FROM vacancy_view view
    LEFT JOIN vacancies v ON v.id = view.vacancy_id
    WHERE view.vacancy_id = ?
    AND v.status = ?

Parameters:

[
  "1f132273-aae8-67fc-8dcb-15a05c5a7685"
  "public"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(view.id)
FROM
  vacancy_view view
  LEFT JOIN vacancies v ON v.id = view.vacancy_id
WHERE
  view.vacancy_id = ?
  AND v.status = ?

SELECT COUNT(view.id) FROM vacancy_view view
    LEFT JOIN vacancies v ON v.id = view.vacancy_id
    WHERE view.vacancy_id = '1f132273-aae8-67fc-8dcb-15a05c5a7685'
    AND v.status = 'public';

#	File/Call
1	App\Domain\Vacancy\Repository\DoctrineVacancyRepository->totalView (line 402)
2	App\Controller\VacancyController->vacancyPublic (line 253)
3	App\Controller\VacancyController->vacancy (line 189)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 208)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.12 ms
(0.06%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 430)
2	Doctrine\ORM\EntityManager->flush (line 414)
3	App\Domain\Vacancy\Repository\DoctrineEventRepository->save (line 45)
4	App\Domain\Vacancy\Service\MainEventManager->viewVacancy (line 30)
5	App\Domain\Vacancy\Service\RequestSessionEventManager->App\Domain\Vacancy\Service\{closure} (line 56)
6	App\Domain\Vacancy\Service\RequestSessionEventManager->viewEvent (line 87)
7	App\Domain\Vacancy\Service\RequestSessionEventManager->viewVacancy (line 56)
8	App\Controller\VacancyController->vacancyPublic (line 220)
9	App\Controller\VacancyController->vacancy (line 189)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	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
App\Domain\City\City	15
App\Domain\City\Region	15
App\Domain\Vacancy\Vacancy	7
App\Domain\Moderation\VacancyModeration	7
App\Domain\Specialization\Specialization	5
App\Domain\User\User	4
App\Domain\Employer\Employer	4
App\Domain\Company\Company	4
App\Domain\PersonalAccount\PersonalAccount	4
App\Domain\Category\Category	2
App\Domain\Vacancy\Event\View	1
App\Domain\Statistic\VacancySnapshot	1
App\Domain\Skill\Skill	1

Entities Mapping

Class	Mapping errors
App\Domain\Company\Company	No errors.
App\Domain\Vacancy\Vacancy	No errors.
App\Domain\Resume\Resume	No errors.
App\Domain\Admin\Admin	No errors.
App\Domain\User\User	No errors.
App\Domain\Payer\Payer	No errors.
App\Domain\Payer\JuridicalPayer	No errors.
App\Domain\Order\Position	No errors.
App\Domain\Order\VacancyQuotaPosition	No errors.
App\Domain\Order\Order	No errors.
App\Domain\VacancyImport\VacancyImportHistory	No errors.
App\Domain\VacancyImport\VacancyImport	No errors.
App\Domain\Blog\BlogAnchor	No errors.
App\Domain\Blog\BlogAuthorLog	No errors.
App\Domain\Blog\BlogAuthor	No errors.
App\Domain\Blog\BlogTag	No errors.
App\Domain\Blog\BlogTagLog	No errors.
App\Domain\Blog\Blog	No errors.
App\Domain\Blog\BlogLog	No errors.
App\Domain\AdminAccess\SectionAccess	No errors.
App\Domain\Applicant\Applicant	No errors.
App\Domain\Category\Category	No errors.
App\Domain\City\Metadata	No errors.
App\Domain\City\City	No errors.
App\Domain\City\Region	No errors.
App\Domain\Specialization\Specialization	No errors.
App\Domain\Citizenship\Citizenship	No errors.
App\Domain\EducationInstitution\EducationInstitution	No errors.
App\Domain\Skill\Skill	No errors.
App\Domain\User\ConfirmRequest	No errors.
App\Domain\User\ResetPasswordRequest	No errors.
App\Domain\Company\CompanyAcl	No errors.
App\Domain\PersonalAccount\PersonalAccount\History	No errors.
App\Domain\PersonalAccount\PersonalAccount	No errors.
App\Domain\Employer\EmployerLimit	No errors.
App\Domain\Employer\Employer	No errors.
App\Domain\VacancyQuota\VacancyQuota	No errors.
App\Domain\Language\Language	No errors.
App\Domain\Resume\ResumeSchedule	No errors.
App\Domain\Resume\PreviousJob	No errors.
App\Domain\Resume\Comment	No errors.
App\Domain\Resume\ResumeView	No errors.
App\Domain\Resume\LanguageKnowledge	No errors.
App\Domain\Resume\ResumeEmployment	No errors.
App\Domain\Resume\Course	No errors.
App\Domain\Resume\Education	No errors.
App\Domain\Act\Act	No errors.
App\Domain\Bill\Bill	No errors.
App\Domain\Cart\CartBuyOrder	No errors.
App\Domain\Cart\Cart	No errors.
App\Domain\VacancyResumeRequest\Event\VacancyResumeRequestEvent	No errors.
App\Domain\VacancyResumeRequest\Event\VacancyResumeRequestEditEvent	No errors.
App\Domain\VacancyResumeRequest\VacancyResumeRequest	No errors.
App\Domain\VacancyResumeRequest\Event\VacancyResumeRequestCreateEvent	No errors.
App\Domain\Feedback\Feedback	No errors.
App\Domain\Statistic\VacancySnapshot	No errors.
App\Domain\Statistic\VacancySnapshotArchive	No errors.
App\Domain\News\News	No errors.
App\Domain\PromoCode\PromoCode	No errors.
App\Domain\PromoCode\PromoCodeUsageHistory	No errors.
App\Domain\Moderation\Moderation	No errors.
App\Domain\Moderation\ResumeModeration	No errors.
App\Domain\Moderation\VacancyModeration	No errors.
App\Domain\Moderation\FeedbackModeration	No errors.
App\Domain\Notification\Site\Settings	No errors.
App\Domain\Notification\Site\Notification	No errors.
App\Domain\AuthProviders\UserAuthProviders	No errors.
App\Domain\Contract\Contract	No errors.
App\Domain\Vacancy\Event\History	No errors.
App\Domain\Vacancy\Event\Publication	No errors.
App\Domain\Vacancy\Event\View	No errors.
App\Domain\Vacancy\Event\Favorite	No errors.
App\Domain\Vacancy\Event\ViewPhone	No errors.

Symfony Profiler

GET https://raberu2.itservice18.ru/torzhok/vacancy/1f132273-aae8-67fc-8dcb-15a05c5a7685

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping