Symfony Profiler

Query Metrics

50 Database Queries

26 Different statements

288.33 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

117.73 ms
(40.83%)

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 {#2311
    __toString(): "1efa4fda-ec5e-6260-a6ea-a5e92c8b6911"
  }
]

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 = '1efa4fda-ec5e-6260-a6ea-a5e92c8b6911' AND v0_.published_at IS NOT NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1026)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 125)
8	App\Infrastructure\Company\Service\CompanyManager->App\Infrastructure\Company\Service\{closure} (line 32)
9	Kenny1911\Memoizer\Memoizer->memoize (line 116)
10	App\Infrastructure\Company\Service\CompanyManager->getCompanyInfo (line 43)
11	App\Util\RaberuVariable\CompanyHelper->getInfo (line 1871)
12	Twig\Extension\CoreExtension::getAttribute (line 56)
13	__TwigTemplate_b036ba0cabc5c3f474355ccc5dd57368->doDisplay (line 387)
14	Twig\Template->yield (line 343)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 51)
17	Twig\TemplateWrapper->render (line 320)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 216)
22	App\Controller\VacancyController->vacancyPublic (line 173)
23	App\Controller\VacancyController->vacancy (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

102.98 ms
(35.72%)

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 {#2311
    __toString(): "1efa4fda-ec5e-6260-a6ea-a5e92c8b6911"
  }
  "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 = '1efa4fda-ec5e-6260-a6ea-a5e92c8b6911' AND v0_.published_at IS NOT NULL AND v0_.status = 'public' AND v0_.is_anonymous = false;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1026)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 138)
8	App\Infrastructure\Company\Service\CompanyManager->App\Infrastructure\Company\Service\{closure} (line 32)
9	Kenny1911\Memoizer\Memoizer->memoize (line 116)
10	App\Infrastructure\Company\Service\CompanyManager->getCompanyInfo (line 43)
11	App\Util\RaberuVariable\CompanyHelper->getInfo (line 1871)
12	Twig\Extension\CoreExtension::getAttribute (line 56)
13	__TwigTemplate_b036ba0cabc5c3f474355ccc5dd57368->doDisplay (line 387)
14	Twig\Template->yield (line 343)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 51)
17	Twig\TemplateWrapper->render (line 320)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 216)
22	App\Controller\VacancyController->vacancyPublic (line 173)
23	App\Controller\VacancyController->vacancy (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

8.28 ms
(2.87%)

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:

[
  "1f0b768e-057f-6254-b851-670e02292dcf"
]

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 = '1f0b768e-057f-6254-b851-670e02292dcf';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1120)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1042)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 3169)
5	Doctrine\ORM\UnitOfWork->createEntity (line 173)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 65)
7	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 272)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 787)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
11	Doctrine\ORM\EntityManager->find (line 196)
12	Doctrine\ORM\EntityRepository->find (line 53)
13	App\Infrastructure\Vacancy\Repository\VacancyRepository->find (line 166)
14	App\Controller\VacancyController->vacancy (line 181)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

6.93 ms
(2.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-02f6-709f-a86c-8e08c83f9741"
]

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-02f6-709f-a86c-8e08c83f9741';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Domain\City\City::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Domain\City\City->__get (line 63)
8	App\Domain\City\City->getName (line 313)
9	App\Controller\VacancyController->vacancyToJson (line 214)
10	App\Controller\VacancyController->vacancyPublic (line 173)
11	App\Controller\VacancyController->vacancy (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

6.39 ms
(2.22%)

SELECT COUNT(DISTINCT v0_.id) AS sclr_0 FROM vacancies_resume_request v0_ INNER JOIN resumes r1_ ON v0_.resume_id = r1_.id INNER JOIN vacancies v2_ ON v0_.vacancy_id = v2_.id INNER JOIN company_employer c3_ ON v2_.manager_id = c3_.user_id WHERE v0_.vacancy_id = ? AND v0_.source = ? AND v0_.created_at >= ? AND v0_.created_at <= ?

Parameters:

[
  Symfony\Component\Uid\UuidV6 {#1418
    __toString(): "1f0b768e-057f-6254-b851-670e02292dcf"
  }
  "applicantRequest"
  "2026-01-08 00:00:00"
  "2026-01-08 23:59:59"
]

View formatted query View runnable query View query backtrace

SELECT
  COUNT(DISTINCT v0_.id) AS sclr_0
FROM
  vacancies_resume_request v0_
  INNER JOIN resumes r1_ ON v0_.resume_id = r1_.id
  INNER JOIN vacancies v2_ ON v0_.vacancy_id = v2_.id
  INNER JOIN company_employer c3_ ON v2_.manager_id = c3_.user_id
WHERE
  v0_.vacancy_id = ?
  AND v0_.source = ?
  AND v0_.created_at >= ?
  AND v0_.created_at <= ?

SELECT COUNT(DISTINCT v0_.id) AS sclr_0 FROM vacancies_resume_request v0_ INNER JOIN resumes r1_ ON v0_.resume_id = r1_.id INNER JOIN vacancies v2_ ON v0_.vacancy_id = v2_.id INNER JOIN company_employer c3_ ON v2_.manager_id = c3_.user_id WHERE v0_.vacancy_id = '1f0b768e-057f-6254-b851-670e02292dcf' AND v0_.source = 'applicantRequest' AND v0_.created_at >= '2026-01-08 00:00:00' AND v0_.created_at <= '2026-01-08 23:59:59';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1026)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 91)
8	App\Infrastructure\VacancyResumeRequest\Repository\VacancyResumeRepository->countByFilter (line 219)
9	App\Domain\Statistic\Service\BaseVacancySnapshotManager->getRequestsCount (line 185)
10	App\Domain\Statistic\Service\BaseVacancySnapshotManager->createSnapshot (line 169)
11	App\Domain\Statistic\Service\BaseVacancySnapshotManager->getCurrentDateSnapshot (line 116)
12	App\Domain\Statistic\Service\BaseVacancySnapshotManager->syncView (line 56)
13	App\Infrastructure\Statistic\Doctrine\Listener\SnapShotSubscriber->postPersist (line 63)
14	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 98)
15	Doctrine\ORM\Event\ListenersInvoker->invoke (line 1216)
16	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
17	Doctrine\ORM\UnitOfWork->commit (line 414)
18	Doctrine\ORM\EntityManager->flush (line 46)
19	App\Infrastructure\Vacancy\Repository\EventRepository->save (line 29)
20	App\Domain\Vacancy\Service\MainEventManager->viewVacancy (line 56)
21	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->App\Infrastructure\Vacancy\Service\{closure} (line 87)
22	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewEvent (line 56)
23	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewVacancy (line 191)
24	App\Controller\VacancyController->vacancyPublic (line 173)
25	App\Controller\VacancyController->vacancy (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

5.86 ms
(2.03%)

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_.show_phone AS show_phone_13, v0_.from14_years AS from14_years_14, v0_.is_anonymous AS is_anonymous_15, v0_.with_physical_disabilities AS with_physical_disabilities_16, v0_.autopublish AS autopublish_17, v0_.published_at AS published_at_18, v0_.created_at AS created_at_19, v0_.updated_at AS updated_at_20, v0_.archived_at AS archived_at_21, v0_.id AS id_22, v0_.moderation_id AS moderation_id_23, v0_.manager_id AS manager_id_24, v0_.specialization_id AS specialization_id_25, v0_.city_id AS city_id_26 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 {#1859
    __toString(): "019256cb-02f6-709f-a86c-8e08c83f9741"
  }
  Symfony\Component\Uid\UuidV7 {#1859}
  Symfony\Component\Uid\UuidV6 {#1818
    __toString(): "1ef3ac6f-1373-65b4-b5e0-45410f7dcdf4"
  }
  Symfony\Component\Uid\UuidV6 {#1418
    __toString(): "1f0b768e-057f-6254-b851-670e02292dcf"
  }
]

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_.show_phone AS show_phone_13,
  v0_.from14_years AS from14_years_14,
  v0_.is_anonymous AS is_anonymous_15,
  v0_.with_physical_disabilities AS with_physical_disabilities_16,
  v0_.autopublish AS autopublish_17,
  v0_.published_at AS published_at_18,
  v0_.created_at AS created_at_19,
  v0_.updated_at AS updated_at_20,
  v0_.archived_at AS archived_at_21,
  v0_.id AS id_22,
  v0_.moderation_id AS moderation_id_23,
  v0_.manager_id AS manager_id_24,
  v0_.specialization_id AS specialization_id_25,
  v0_.city_id AS city_id_26
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_.show_phone AS show_phone_13, v0_.from14_years AS from14_years_14, v0_.is_anonymous AS is_anonymous_15, v0_.with_physical_disabilities AS with_physical_disabilities_16, v0_.autopublish AS autopublish_17, v0_.published_at AS published_at_18, v0_.created_at AS created_at_19, v0_.updated_at AS updated_at_20, v0_.archived_at AS archived_at_21, v0_.id AS id_22, v0_.moderation_id AS moderation_id_23, v0_.manager_id AS manager_id_24, v0_.specialization_id AS specialization_id_25, v0_.city_id AS city_id_26 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-02f6-709f-a86c-8e08c83f9741', '019256cb-02f6-709f-a86c-8e08c83f9741') AND v0_.specialization_id IN ('1ef3ac6f-1373-65b4-b5e0-45410f7dcdf4') AND v0_.id NOT IN ('1f0b768e-057f-6254-b851-670e02292dcf') ORDER BY v0_.published_at DESC LIMIT 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 154)
7	App\Infrastructure\Vacancy\Repository\VacancyRepository->findByPublicFilter (line 309)
8	App\Domain\Vacancy\Service\MainVacancyManager->findByPublicFilters (line 291)
9	App\Domain\Vacancy\Service\MainVacancyManager->getSimilarVacancies (line 156)
10	App\Domain\Vacancy\Service\CompanyConfirmationVacancyManager->getSimilarVacancies (line 131)
11	App\Infrastructure\Vacancy\Service\TransactionalVacancyManager->getSimilarVacancies (line 208)
12	App\Controller\VacancyController->vacancyPublic (line 173)
13	App\Controller\VacancyController->vacancy (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

5.38 ms
(1.86%)

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.show_phone AS show_phone_14, t0.from14_years AS from14_years_15, t0.is_anonymous AS is_anonymous_16, t0.with_physical_disabilities AS with_physical_disabilities_17, t0.autopublish AS autopublish_18, t0.published_at AS published_at_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.archived_at AS archived_at_22, t0.id AS id_23, t0.moderation_id AS moderation_id_24, t0.manager_id AS manager_id_25, t0.specialization_id AS specialization_id_26, t0.city_id AS city_id_27 FROM vacancies t0 WHERE t0.id = ?

Parameters:

[
  "1f0b768e-057f-6254-b851-670e02292dcf"
]

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.show_phone AS show_phone_14,
  t0.from14_years AS from14_years_15,
  t0.is_anonymous AS is_anonymous_16,
  t0.with_physical_disabilities AS with_physical_disabilities_17,
  t0.autopublish AS autopublish_18,
  t0.published_at AS published_at_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.archived_at AS archived_at_22,
  t0.id AS id_23,
  t0.moderation_id AS moderation_id_24,
  t0.manager_id AS manager_id_25,
  t0.specialization_id AS specialization_id_26,
  t0.city_id AS city_id_27
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.show_phone AS show_phone_14, t0.from14_years AS from14_years_15, t0.is_anonymous AS is_anonymous_16, t0.with_physical_disabilities AS with_physical_disabilities_17, t0.autopublish AS autopublish_18, t0.published_at AS published_at_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.archived_at AS archived_at_22, t0.id AS id_23, t0.moderation_id AS moderation_id_24, t0.manager_id AS manager_id_25, t0.specialization_id AS specialization_id_26, t0.city_id AS city_id_27 FROM vacancies t0 WHERE t0.id = '1f0b768e-057f-6254-b851-670e02292dcf';

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

5.12 ms
(1.78%)

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_used_quotes_start AS count_used_quotes_start_8, v0_.count_used_quotes_end AS count_used_quotes_end_9, v0_.amount_quotes_price_start AS amount_quotes_price_start_10, v0_.amount_quotes_price_end AS amount_quotes_price_end_11, v0_.created_at AS created_at_12, v0_.updated_at AS updated_at_13, v0_.id AS id_14, v0_.vacancy_id AS vacancy_id_15, v0_.company_id AS company_id_16, v0_.city_start_id AS city_start_id_17, v0_.city_end_id AS city_end_id_18, v0_.manager_start_id AS manager_start_id_19, v0_.manager_end_id AS manager_end_id_20, v0_.specialization_start_id AS specialization_start_id_21, v0_.specialization_end_id AS specialization_end_id_22 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 {#2056
    __toString(): "1efa4fda-ec5e-6260-a6ea-a5e92c8b6911"
  }
  "public"
  "archive"
  "public"
  "archive"
  Symfony\Component\Uid\UuidV6 {#1418
    __toString(): "1f0b768e-057f-6254-b851-670e02292dcf"
  }
  "2026-01-08 00:00:00"
  "2026-01-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_used_quotes_start AS count_used_quotes_start_8,
  v0_.count_used_quotes_end AS count_used_quotes_end_9,
  v0_.amount_quotes_price_start AS amount_quotes_price_start_10,
  v0_.amount_quotes_price_end AS amount_quotes_price_end_11,
  v0_.created_at AS created_at_12,
  v0_.updated_at AS updated_at_13,
  v0_.id AS id_14,
  v0_.vacancy_id AS vacancy_id_15,
  v0_.company_id AS company_id_16,
  v0_.city_start_id AS city_start_id_17,
  v0_.city_end_id AS city_end_id_18,
  v0_.manager_start_id AS manager_start_id_19,
  v0_.manager_end_id AS manager_end_id_20,
  v0_.specialization_start_id AS specialization_start_id_21,
  v0_.specialization_end_id AS specialization_end_id_22
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_used_quotes_start AS count_used_quotes_start_8, v0_.count_used_quotes_end AS count_used_quotes_end_9, v0_.amount_quotes_price_start AS amount_quotes_price_start_10, v0_.amount_quotes_price_end AS amount_quotes_price_end_11, v0_.created_at AS created_at_12, v0_.updated_at AS updated_at_13, v0_.id AS id_14, v0_.vacancy_id AS vacancy_id_15, v0_.company_id AS company_id_16, v0_.city_start_id AS city_start_id_17, v0_.city_end_id AS city_end_id_18, v0_.manager_start_id AS manager_start_id_19, v0_.manager_end_id AS manager_end_id_20, v0_.specialization_start_id AS specialization_start_id_21, v0_.specialization_end_id AS specialization_end_id_22 FROM vacancy_snapshot v0_ WHERE v0_.company_id = '1efa4fda-ec5e-6260-a6ea-a5e92c8b6911' AND (v0_.status_start IN ('public', 'archive') OR v0_.status_end IN ('public', 'archive')) AND v0_.vacancy_id = '1f0b768e-057f-6254-b851-670e02292dcf' AND v0_.created_at >= '2026-01-08 00:00:00' AND v0_.created_at <= '2026-01-08 23:59:59';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 174)
7	App\Infrastructure\Statistic\Repository\Snapshot\SnapshotRepository->findByVacancyAndDate (line 166)
8	App\Domain\Statistic\Service\BaseVacancySnapshotManager->getCurrentDateSnapshot (line 116)
9	App\Domain\Statistic\Service\BaseVacancySnapshotManager->syncView (line 56)
10	App\Infrastructure\Statistic\Doctrine\Listener\SnapShotSubscriber->postPersist (line 63)
11	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 98)
12	Doctrine\ORM\Event\ListenersInvoker->invoke (line 1216)
13	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
14	Doctrine\ORM\UnitOfWork->commit (line 414)
15	Doctrine\ORM\EntityManager->flush (line 46)
16	App\Infrastructure\Vacancy\Repository\EventRepository->save (line 29)
17	App\Domain\Vacancy\Service\MainEventManager->viewVacancy (line 56)
18	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->App\Infrastructure\Vacancy\Service\{closure} (line 87)
19	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewEvent (line 56)
20	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewVacancy (line 191)
21	App\Controller\VacancyController->vacancyPublic (line 173)
22	App\Controller\VacancyController->vacancy (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

4.76 ms
(1.65%)

INSERT INTO vacancy_snapshot (status_start, status_end, count_view_start, count_view_end, count_phone_view_start, count_phone_view_end, count_request_start, count_request_end, count_used_quotes_start, count_used_quotes_end, amount_quotes_price_start, amount_quotes_price_end, created_at, updated_at, id, vacancy_id, company_id, city_start_id, city_end_id, manager_start_id, manager_end_id, specialization_start_id, specialization_end_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "public"
  "public"
  1
  1
  0
  0
  0
  0
  0
  0
  0
  0
  "2026-01-08 11:45:36"
  "2026-01-08 11:45:36"
  "1f0ec878-c421-6c36-87d3-4f6eb3c388ca"
  "1f0b768e-057f-6254-b851-670e02292dcf"
  "1efa4fda-ec5e-6260-a6ea-a5e92c8b6911"
  "019256cb-02f6-709f-a86c-8e08c83f9741"
  "019256cb-02f6-709f-a86c-8e08c83f9741"
  "1efa4fda-ec5b-6b50-a799-a5e92c8b6911"
  "1efa4fda-ec5b-6b50-a799-a5e92c8b6911"
  "1ef3ac6f-1373-65b4-b5e0-45410f7dcdf4"
  "1ef3ac6f-1373-65b4-b5e0-45410f7dcdf4"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO vacancy_snapshot (
  status_start, status_end, count_view_start,
  count_view_end, count_phone_view_start,
  count_phone_view_end, count_request_start,
  count_request_end, count_used_quotes_start,
  count_used_quotes_end, amount_quotes_price_start,
  amount_quotes_price_end, created_at,
  updated_at, id, vacancy_id, company_id,
  city_start_id, city_end_id, manager_start_id,
  manager_end_id, specialization_start_id,
  specialization_end_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO vacancy_snapshot (status_start, status_end, count_view_start, count_view_end, count_phone_view_start, count_phone_view_end, count_request_start, count_request_end, count_used_quotes_start, count_used_quotes_end, amount_quotes_price_start, amount_quotes_price_end, created_at, updated_at, id, vacancy_id, company_id, city_start_id, city_end_id, manager_start_id, manager_end_id, specialization_start_id, specialization_end_id) VALUES ('public', 'public', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, '2026-01-08 11:45:36', '2026-01-08 11:45:36', '1f0ec878-c421-6c36-87d3-4f6eb3c388ca', '1f0b768e-057f-6254-b851-670e02292dcf', '1efa4fda-ec5e-6260-a6ea-a5e92c8b6911', '019256cb-02f6-709f-a86c-8e08c83f9741', '019256cb-02f6-709f-a86c-8e08c83f9741', '1efa4fda-ec5b-6b50-a799-a5e92c8b6911', '1efa4fda-ec5b-6b50-a799-a5e92c8b6911', '1ef3ac6f-1373-65b4-b5e0-45410f7dcdf4', '1ef3ac6f-1373-65b4-b5e0-45410f7dcdf4');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 288)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1185)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 187)
7	App\Infrastructure\Statistic\Repository\Snapshot\SnapshotRepository->persist (line 190)
8	App\Domain\Statistic\Service\BaseVacancySnapshotManager->createSnapshot (line 169)
9	App\Domain\Statistic\Service\BaseVacancySnapshotManager->getCurrentDateSnapshot (line 116)
10	App\Domain\Statistic\Service\BaseVacancySnapshotManager->syncView (line 56)
11	App\Infrastructure\Statistic\Doctrine\Listener\SnapShotSubscriber->postPersist (line 63)
12	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 98)
13	Doctrine\ORM\Event\ListenersInvoker->invoke (line 1216)
14	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
15	Doctrine\ORM\UnitOfWork->commit (line 414)
16	Doctrine\ORM\EntityManager->flush (line 46)
17	App\Infrastructure\Vacancy\Repository\EventRepository->save (line 29)
18	App\Domain\Vacancy\Service\MainEventManager->viewVacancy (line 56)
19	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->App\Infrastructure\Vacancy\Service\{closure} (line 87)
20	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewEvent (line 56)
21	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewVacancy (line 191)
22	App\Controller\VacancyController->vacancyPublic (line 173)
23	App\Controller\VacancyController->vacancy (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

3.65 ms
(1.27%)

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 {#2056
    __toString(): "1efa4fda-ec5e-6260-a6ea-a5e92c8b6911"
  }
  "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 = '1efa4fda-ec5e-6260-a6ea-a5e92c8b6911' AND f1_.moderation_status IN ('moderation', 'accepted');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1026)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 70)
8	App\Infrastructure\Feedback\Repository\BaseFeedbackRepository->countByFilter (line 143)
9	App\Infrastructure\Company\Service\CompanyManager->App\Infrastructure\Company\Service\{closure} (line 32)
10	Kenny1911\Memoizer\Memoizer->memoize (line 116)
11	App\Infrastructure\Company\Service\CompanyManager->getCompanyInfo (line 43)
12	App\Util\RaberuVariable\CompanyHelper->getInfo (line 1871)
13	Twig\Extension\CoreExtension::getAttribute (line 56)
14	__TwigTemplate_b036ba0cabc5c3f474355ccc5dd57368->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 216)
23	App\Controller\VacancyController->vacancyPublic (line 173)
24	App\Controller\VacancyController->vacancy (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

2.93 ms
(1.02%)

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

Parameters:

[
  "2026-01-08 11:45:36"
  "1f0ec878-c3a9-6308-a8a1-4f6eb3c388ca"
  "1f0b768e-057f-6254-b851-670e02292dcf"
  "1efa4fda-ec5b-6b50-a799-a5e92c8b6911"
  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-01-08 11:45:36', '1f0ec878-c3a9-6308-a8a1-4f6eb3c388ca', '1f0b768e-057f-6254-b851-670e02292dcf', '1efa4fda-ec5b-6b50-a799-a5e92c8b6911', NULL);

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

2.90 ms
(1.01%)

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 {#1859
    __toString(): "019256cb-02f6-709f-a86c-8e08c83f9741"
  }
  Symfony\Component\Uid\UuidV6 {#1818
    __toString(): "1ef3ac6f-1373-65b4-b5e0-45410f7dcdf4"
  }
  Symfony\Component\Uid\UuidV6 {#1418
    __toString(): "1f0b768e-057f-6254-b851-670e02292dcf"
  }
]

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-02f6-709f-a86c-8e08c83f9741') AND v0_.specialization_id IN ('1ef3ac6f-1373-65b4-b5e0-45410f7dcdf4') AND v0_.id NOT IN ('1f0b768e-057f-6254-b851-670e02292dcf');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1026)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 167)
8	App\Infrastructure\Vacancy\Repository\VacancyRepository->countByPublicFilter (line 206)
9	App\Controller\VacancyController->vacancyPublic (line 173)
10	App\Controller\VacancyController->vacancy (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

1.64 ms
(0.57%)

SELECT COUNT(c0_.id) AS sclr_0 FROM companies_vacancy_quota c0_ WHERE c0_.vacancy_id = ? AND c0_.published_at >= ? AND c0_.published_at <= ?

Parameters:

[
  Symfony\Component\Uid\UuidV6 {#1418
    __toString(): "1f0b768e-057f-6254-b851-670e02292dcf"
  }
  "2026-01-08 00:00:00"
  "2026-01-08 23:59:59"
]

View formatted query View runnable query View query backtrace

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  companies_vacancy_quota c0_
WHERE
  c0_.vacancy_id = ?
  AND c0_.published_at >= ?
  AND c0_.published_at <= ?

SELECT COUNT(c0_.id) AS sclr_0 FROM companies_vacancy_quota c0_ WHERE c0_.vacancy_id = '1f0b768e-057f-6254-b851-670e02292dcf' AND c0_.published_at >= '2026-01-08 00:00:00' AND c0_.published_at <= '2026-01-08 23:59:59';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1026)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 46)
8	App\Infrastructure\VacancyQuota\Repository\VacancyQuotaRepository->countByFilter (line 233)
9	App\Domain\Statistic\Service\BaseVacancySnapshotManager->getQuotaCount (line 186)
10	App\Domain\Statistic\Service\BaseVacancySnapshotManager->createSnapshot (line 169)
11	App\Domain\Statistic\Service\BaseVacancySnapshotManager->getCurrentDateSnapshot (line 116)
12	App\Domain\Statistic\Service\BaseVacancySnapshotManager->syncView (line 56)
13	App\Infrastructure\Statistic\Doctrine\Listener\SnapShotSubscriber->postPersist (line 63)
14	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 98)
15	Doctrine\ORM\Event\ListenersInvoker->invoke (line 1216)
16	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
17	Doctrine\ORM\UnitOfWork->commit (line 414)
18	Doctrine\ORM\EntityManager->flush (line 46)
19	App\Infrastructure\Vacancy\Repository\EventRepository->save (line 29)
20	App\Domain\Vacancy\Service\MainEventManager->viewVacancy (line 56)
21	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->App\Infrastructure\Vacancy\Service\{closure} (line 87)
22	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewEvent (line 56)
23	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewVacancy (line 191)
24	App\Controller\VacancyController->vacancyPublic (line 173)
25	App\Controller\VacancyController->vacancy (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.56 ms
(0.54%)

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:

[
  "1ef3ac6f-1373-65b4-b5e0-45410f7dcdf4"
]

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 = '1ef3ac6f-1373-65b4-b5e0-45410f7dcdf4';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1120)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1042)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 281)
8	App\Domain\Vacancy\Service\MainVacancyManager->getSimilarVacancies (line 156)
9	App\Domain\Vacancy\Service\CompanyConfirmationVacancyManager->getSimilarVacancies (line 131)
10	App\Infrastructure\Vacancy\Service\TransactionalVacancyManager->getSimilarVacancies (line 208)
11	App\Controller\VacancyController->vacancyPublic (line 173)
12	App\Controller\VacancyController->vacancy (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

1.50 ms
(0.52%)

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:

[
  "1f0b768e-4365-6a00-8e25-0f2fb8b7cf67"
]

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 = '1f0b768e-4365-6a00-8e25-0f2fb8b7cf67';

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

1.49 ms
(0.52%)

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.slug = ? LIMIT 1

Parameters:

[
  "krasnodar"
]

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.slug = ?
LIMIT
  1

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.slug = 'krasnodar' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 112)
4	App\Infrastructure\City\Service\CitySelectorManager->getUrlCity (line 1871)
5	Twig\Extension\CoreExtension::getAttribute (line 79)
6	__TwigTemplate_b036ba0cabc5c3f474355ccc5dd57368->doDisplay (line 387)
7	Twig\Template->yield (line 343)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 51)
10	Twig\TemplateWrapper->render (line 320)
11	Twig\Environment->render (line 448)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 216)
15	App\Controller\VacancyController->vacancyPublic (line 173)
16	App\Controller\VacancyController->vacancy (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.41 ms
(0.49%)

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

Parameters:

[
  Symfony\Component\Uid\UuidV6 {#1418
    __toString(): "1f0b768e-057f-6254-b851-670e02292dcf"
  }
  "2026-01-08 00:00:00"
  "2026-01-08 23:59:59"
]

View formatted query View runnable query View query backtrace

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

SELECT COUNT(v0_.id) AS sclr_0 FROM vacancy_phone_view v0_ WHERE v0_.vacancy_id = '1f0b768e-057f-6254-b851-670e02292dcf' AND v0_.created_at >= '2026-01-08 00:00:00' AND v0_.created_at <= '2026-01-08 23:59:59';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1026)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 39)
8	App\Infrastructure\Vacancy\Repository\EventRepository->countEventByFilter (line 206)
9	App\Domain\Statistic\Service\BaseVacancySnapshotManager->getEventView (line 184)
10	App\Domain\Statistic\Service\BaseVacancySnapshotManager->createSnapshot (line 169)
11	App\Domain\Statistic\Service\BaseVacancySnapshotManager->getCurrentDateSnapshot (line 116)
12	App\Domain\Statistic\Service\BaseVacancySnapshotManager->syncView (line 56)
13	App\Infrastructure\Statistic\Doctrine\Listener\SnapShotSubscriber->postPersist (line 63)
14	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 98)
15	Doctrine\ORM\Event\ListenersInvoker->invoke (line 1216)
16	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
17	Doctrine\ORM\UnitOfWork->commit (line 414)
18	Doctrine\ORM\EntityManager->flush (line 46)
19	App\Infrastructure\Vacancy\Repository\EventRepository->save (line 29)
20	App\Domain\Vacancy\Service\MainEventManager->viewVacancy (line 56)
21	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->App\Infrastructure\Vacancy\Service\{closure} (line 87)
22	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewEvent (line 56)
23	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewVacancy (line 191)
24	App\Controller\VacancyController->vacancyPublic (line 173)
25	App\Controller\VacancyController->vacancy (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.37 ms
(0.48%)

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 {#1418
    __toString(): "1f0b768e-057f-6254-b851-670e02292dcf"
  }
  "2026-01-08 00:00:00"
  "2026-01-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 = '1f0b768e-057f-6254-b851-670e02292dcf' AND v0_.created_at >= '2026-01-08 00:00:00' AND v0_.created_at <= '2026-01-08 23:59:59';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1026)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 39)
8	App\Infrastructure\Vacancy\Repository\EventRepository->countEventByFilter (line 206)
9	App\Domain\Statistic\Service\BaseVacancySnapshotManager->getEventView (line 183)
10	App\Domain\Statistic\Service\BaseVacancySnapshotManager->createSnapshot (line 169)
11	App\Domain\Statistic\Service\BaseVacancySnapshotManager->getCurrentDateSnapshot (line 116)
12	App\Domain\Statistic\Service\BaseVacancySnapshotManager->syncView (line 56)
13	App\Infrastructure\Statistic\Doctrine\Listener\SnapShotSubscriber->postPersist (line 63)
14	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 98)
15	Doctrine\ORM\Event\ListenersInvoker->invoke (line 1216)
16	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
17	Doctrine\ORM\UnitOfWork->commit (line 414)
18	Doctrine\ORM\EntityManager->flush (line 46)
19	App\Infrastructure\Vacancy\Repository\EventRepository->save (line 29)
20	App\Domain\Vacancy\Service\MainEventManager->viewVacancy (line 56)
21	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->App\Infrastructure\Vacancy\Service\{closure} (line 87)
22	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewEvent (line 56)
23	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewVacancy (line 191)
24	App\Controller\VacancyController->vacancyPublic (line 173)
25	App\Controller\VacancyController->vacancy (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.25 ms
(0.43%)

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:

[
  "1ef50b44-b944-6d00-8022-2748bc57dc17"
]

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 = '1ef50b44-b944-6d00-8022-2748bc57dc17';

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

1.21 ms
(0.42%)

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:

[
  "1efa4fda-ec5e-6260-a6ea-a5e92c8b6911"
]

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 = '1efa4fda-ec5e-6260-a6ea-a5e92c8b6911';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Domain\Company\Company::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Domain\Company\Company->__get (line 170)
8	App\Domain\Company\Company->getSite (line 261)
9	App\Controller\VacancyController->vacancyToJson (line 214)
10	App\Controller\VacancyController->vacancyPublic (line 173)
11	App\Controller\VacancyController->vacancy (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.85 ms
(0.29%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 476)
3	Doctrine\ORM\UnitOfWork->commit (line 414)
4	Doctrine\ORM\EntityManager->flush (line 46)
5	App\Infrastructure\Vacancy\Repository\EventRepository->save (line 29)
6	App\Domain\Vacancy\Service\MainEventManager->viewVacancy (line 56)
7	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->App\Infrastructure\Vacancy\Service\{closure} (line 87)
8	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewEvent (line 56)
9	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewVacancy (line 191)
10	App\Controller\VacancyController->vacancyPublic (line 173)
11	App\Controller\VacancyController->vacancy (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.82 ms
(0.29%)

SELECT SUM(c0_.cost) AS sclr_0 FROM companies_vacancy_quota c0_ WHERE c0_.vacancy_id = ? AND c0_.published_at >= ? AND c0_.published_at <= ?

Parameters:

[
  Symfony\Component\Uid\UuidV6 {#1418
    __toString(): "1f0b768e-057f-6254-b851-670e02292dcf"
  }
  "2026-01-08 00:00:00"
  "2026-01-08 23:59:59"
]

View formatted query View runnable query View query backtrace

SELECT
  SUM(c0_.cost) AS sclr_0
FROM
  companies_vacancy_quota c0_
WHERE
  c0_.vacancy_id = ?
  AND c0_.published_at >= ?
  AND c0_.published_at <= ?

SELECT SUM(c0_.cost) AS sclr_0 FROM companies_vacancy_quota c0_ WHERE c0_.vacancy_id = '1f0b768e-057f-6254-b851-670e02292dcf' AND c0_.published_at >= '2026-01-08 00:00:00' AND c0_.published_at <= '2026-01-08 23:59:59';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1026)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 58)
8	App\Infrastructure\VacancyQuota\Repository\VacancyQuotaRepository->amountCostByFilter (line 247)
9	App\Domain\Statistic\Service\BaseVacancySnapshotManager->getQuotaSum (line 187)
10	App\Domain\Statistic\Service\BaseVacancySnapshotManager->createSnapshot (line 169)
11	App\Domain\Statistic\Service\BaseVacancySnapshotManager->getCurrentDateSnapshot (line 116)
12	App\Domain\Statistic\Service\BaseVacancySnapshotManager->syncView (line 56)
13	App\Infrastructure\Statistic\Doctrine\Listener\SnapShotSubscriber->postPersist (line 63)
14	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 98)
15	Doctrine\ORM\Event\ListenersInvoker->invoke (line 1216)
16	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
17	Doctrine\ORM\UnitOfWork->commit (line 414)
18	Doctrine\ORM\EntityManager->flush (line 46)
19	App\Infrastructure\Vacancy\Repository\EventRepository->save (line 29)
20	App\Domain\Vacancy\Service\MainEventManager->viewVacancy (line 56)
21	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->App\Infrastructure\Vacancy\Service\{closure} (line 87)
22	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewEvent (line 56)
23	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewVacancy (line 191)
24	App\Controller\VacancyController->vacancyPublic (line 173)
25	App\Controller\VacancyController->vacancy (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.80 ms
(0.28%)

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

Parameters:

[
  "1efa4fda-ec5e-6260-a6ea-a5e92c8b6911"
]

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 = '1efa4fda-ec5e-6260-a6ea-a5e92c8b6911';

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

0.67 ms
(0.23%)

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:

[
  "1efa4fda-ec5b-6b50-a799-a5e92c8b6911"
]

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 = '1efa4fda-ec5b-6b50-a799-a5e92c8b6911';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Domain\Employer\Employer::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Domain\Employer\Employer->__get (line 60)
8	App\Domain\Employer\Employer->getCompany (line 158)
9	App\Domain\Vacancy\Vacancy->getCompany (line 168)
10	App\Infrastructure\Statistic\Repository\Snapshot\SnapshotRepository->findByVacancyAndDate (line 166)
11	App\Domain\Statistic\Service\BaseVacancySnapshotManager->getCurrentDateSnapshot (line 116)
12	App\Domain\Statistic\Service\BaseVacancySnapshotManager->syncView (line 56)
13	App\Infrastructure\Statistic\Doctrine\Listener\SnapShotSubscriber->postPersist (line 63)
14	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 98)
15	Doctrine\ORM\Event\ListenersInvoker->invoke (line 1216)
16	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
17	Doctrine\ORM\UnitOfWork->commit (line 414)
18	Doctrine\ORM\EntityManager->flush (line 46)
19	App\Infrastructure\Vacancy\Repository\EventRepository->save (line 29)
20	App\Domain\Vacancy\Service\MainEventManager->viewVacancy (line 56)
21	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->App\Infrastructure\Vacancy\Service\{closure} (line 87)
22	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewEvent (line 56)
23	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewVacancy (line 191)
24	App\Controller\VacancyController->vacancyPublic (line 173)
25	App\Controller\VacancyController->vacancy (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.66 ms
(0.23%)

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:

[
  "1ef3ac6f-1373-65b4-b5e0-45410f7dcdf4"
]

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 = '1ef3ac6f-1373-65b4-b5e0-45410f7dcdf4';

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

0.20 ms
(0.07%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 426)
2	Doctrine\ORM\UnitOfWork->commit (line 414)
3	Doctrine\ORM\EntityManager->flush (line 46)
4	App\Infrastructure\Vacancy\Repository\EventRepository->save (line 29)
5	App\Domain\Vacancy\Service\MainEventManager->viewVacancy (line 56)
6	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->App\Infrastructure\Vacancy\Service\{closure} (line 87)
7	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewEvent (line 56)
8	App\Infrastructure\Vacancy\Service\RequestSessionEventManager->viewVacancy (line 191)
9	App\Controller\VacancyController->vacancyPublic (line 173)
10	App\Controller\VacancyController->vacancy (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (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.

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\Statistic\VacancySnapshot	No errors.
App\Domain\VacancyResumeRequest\VacancyResumeRequest	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\ResetPasswordRequest	No errors.
App\Domain\User\ConfirmRequest	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\Vacancy\Event\View	No errors.
App\Domain\Vacancy\Event\ViewPhone	No errors.
App\Domain\Vacancy\Event\Publication	No errors.
App\Domain\Vacancy\Event\History	No errors.
App\Domain\VacancyQuota\VacancyQuota	No errors.
App\Domain\VacancyResumeRequest\Event\VacancyResumeRequestEvent	No errors.
App\Domain\VacancyResumeRequest\Event\VacancyResumeRequestEditEvent	No errors.
App\Domain\VacancyResumeRequest\Event\VacancyResumeRequestCreateEvent	No errors.
App\Domain\Language\Language	No errors.
App\Domain\Resume\LanguageKnowledge	No errors.
App\Domain\Resume\Education	No errors.
App\Domain\Resume\PreviousJob	No errors.
App\Domain\Resume\Comment	No errors.
App\Domain\Act\Act	No errors.
App\Domain\Bill\Bill	No errors.
App\Domain\Cart\Cart	No errors.
App\Domain\Cart\CartBuyOrder	No errors.
App\Domain\Feedback\Feedback	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\Notification	No errors.
App\Domain\Notification\Site\Settings	No errors.
App\Domain\AuthProviders\UserAuthProviders	No errors.
App\Domain\Contract\Contract	No errors.

Symfony Profiler

GET https://raberu.raduga.red/krasnodar/vacancy/1f0b768e-057f-6254-b851-670e02292dcf

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping