Symfony Profiler

Query Metrics

80 Database Queries

17 Different statements

279.22 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

115.18 ms
(41.25%)

SELECT s0_.name AS name_0, s0_.metadata_slug AS metadata_slug_1, s0_.metadata_title AS metadata_title_2, s0_.metadata_description AS metadata_description_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.id AS id_6, COUNT(v1_.id) AS sclr_7, SUM(CASE WHEN v1_.city_id = ? THEN 1 ELSE 0 END) AS sclr_8 FROM specialization s0_ LEFT JOIN vacancies v1_ ON (v1_.specialization_id = s0_.id AND v1_.status = ?) WHERE s0_.metadata_slug IS NOT NULL AND s0_.metadata_slug <> '' GROUP BY s0_.id ORDER BY sclr_8 DESC, sclr_7 DESC LIMIT 6

Parameters:

[
  Symfony\Component\Uid\UuidV6 {#2091
    __toString(): "1efe92d4-23a2-686c-a633-85927c91bd49"
  }
  "public"
]

View formatted query View runnable query View query backtrace

SELECT
  s0_.name AS name_0,
  s0_.metadata_slug AS metadata_slug_1,
  s0_.metadata_title AS metadata_title_2,
  s0_.metadata_description AS metadata_description_3,
  s0_.created_at AS created_at_4,
  s0_.updated_at AS updated_at_5,
  s0_.id AS id_6,
  COUNT(v1_.id) AS sclr_7,
  SUM(
    CASE WHEN v1_.city_id = ? THEN
      1
    ELSE
      0
    END
  ) AS sclr_8
FROM
  specialization s0_
  LEFT JOIN vacancies v1_ ON (
    v1_.specialization_id = s0_.id
    AND v1_.status = ?
  )
WHERE
  s0_.metadata_slug IS NOT NULL
  AND s0_.metadata_slug <> ''
GROUP BY
  s0_.id
ORDER BY
  sclr_8 DESC,
  sclr_7 DESC
LIMIT
  6

SELECT s0_.name AS name_0, s0_.metadata_slug AS metadata_slug_1, s0_.metadata_title AS metadata_title_2, s0_.metadata_description AS metadata_description_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.id AS id_6, COUNT(v1_.id) AS sclr_7, SUM(CASE WHEN v1_.city_id = '1efe92d4-23a2-686c-a633-85927c91bd49' THEN 1 ELSE 0 END) AS sclr_8 FROM specialization s0_ LEFT JOIN vacancies v1_ ON (v1_.specialization_id = s0_.id AND v1_.status = 'public') WHERE s0_.metadata_slug IS NOT NULL AND s0_.metadata_slug <> '' GROUP BY s0_.id ORDER BY sclr_8 DESC, sclr_7 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 58)
7	App\Infrastructure\Specialization\Repository\SpecializationRepository->getPopularSpecializationsByCityWithSlug (line 107)
8	App\Controller\VacancyController->list (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

55.16 ms
(19.75%)

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_.id NOT IN (?) ORDER BY v0_.published_at DESC LIMIT 10

Parameters:

[
  "public"
  Symfony\Component\Uid\UuidV6 {#1898
    __toString(): "1efe92d4-23a2-686c-a633-85927c91bd49"
  }
  Symfony\Component\Uid\UuidV6 {#1903
    __toString(): "1f072aa8-ddde-6892-ac87-0996f4dc872e"
  }
]

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_.id NOT IN (?)
ORDER BY
  v0_.published_at DESC
LIMIT
  10

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 ('1efe92d4-23a2-686c-a633-85927c91bd49') AND v0_.id NOT IN ('1f072aa8-ddde-6892-ac87-0996f4dc872e') ORDER BY v0_.published_at DESC LIMIT 10;

#	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 121)
8	App\Controller\VacancyController->App\Controller\{closure} (line 1)
9	call_user_func (line 38)
10	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackPagination->getPaginationItems (line 20)
11	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackSubscriber->items (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
16	Knp\Component\Pager\Paginator->paginate (line 25)
17	ContainerNrVpHps\PaginatorProxy9cc2a8f->paginate (line 118)
18	App\Controller\VacancyController->list (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

18.99 ms
(6.80%)

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_.id NOT IN (?)

Parameters:

[
  "public"
  Symfony\Component\Uid\UuidV6 {#1898
    __toString(): "1efe92d4-23a2-686c-a633-85927c91bd49"
  }
  Symfony\Component\Uid\UuidV6 {#1903
    __toString(): "1f072aa8-ddde-6892-ac87-0996f4dc872e"
  }
]

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_.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 ('1efe92d4-23a2-686c-a633-85927c91bd49') AND v0_.id NOT IN ('1f072aa8-ddde-6892-ac87-0996f4dc872e');

#	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 120)
9	App\Controller\VacancyController->App\Controller\{closure} (line 1)
10	call_user_func (line 30)
11	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackPagination->getPaginationCount (line 18)
12	Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackSubscriber->items (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
17	Knp\Component\Pager\Paginator->paginate (line 25)
18	ContainerNrVpHps\PaginatorProxy9cc2a8f->paginate (line 118)
19	App\Controller\VacancyController->list (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

15.28 ms
(5.47%)

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, (SELECT COUNT(v1_.id) AS sclr_24 FROM vacancy_view v1_ WHERE v1_.vacancy_id = v0_.id) AS sclr_23, v0_.moderation_id AS moderation_id_25, v0_.manager_id AS manager_id_26, v0_.specialization_id AS specialization_id_27, v0_.city_id AS city_id_28 FROM vacancies v0_ INNER JOIN company_employer c2_ ON v0_.manager_id = c2_.user_id WHERE v0_.status = ? AND v0_.published_at IS NOT NULL AND v0_.city_id IN (?) AND v0_.id NOT IN (?) AND v0_.rate = ? ORDER BY sclr_23 ASC LIMIT 6

Parameters:

[
  "public"
  Symfony\Component\Uid\UuidV6 {#1898
    __toString(): "1efe92d4-23a2-686c-a633-85927c91bd49"
  }
  Symfony\Component\Uid\UuidV6 {#1903
    __toString(): "1f072aa8-ddde-6892-ac87-0996f4dc872e"
  }
  "optimum"
]

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,
  (
    SELECT
      COUNT(v1_.id) AS sclr_24
    FROM
      vacancy_view v1_
    WHERE
      v1_.vacancy_id = v0_.id
  ) AS sclr_23,
  v0_.moderation_id AS moderation_id_25,
  v0_.manager_id AS manager_id_26,
  v0_.specialization_id AS specialization_id_27,
  v0_.city_id AS city_id_28
FROM
  vacancies v0_
  INNER JOIN company_employer c2_ ON v0_.manager_id = c2_.user_id
WHERE
  v0_.status = ?
  AND v0_.published_at IS NOT NULL
  AND v0_.city_id IN (?)
  AND v0_.id NOT IN (?)
  AND v0_.rate = ?
ORDER BY
  sclr_23 ASC
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, (SELECT COUNT(v1_.id) AS sclr_24 FROM vacancy_view v1_ WHERE v1_.vacancy_id = v0_.id) AS sclr_23, v0_.moderation_id AS moderation_id_25, v0_.manager_id AS manager_id_26, v0_.specialization_id AS specialization_id_27, v0_.city_id AS city_id_28 FROM vacancies v0_ INNER JOIN company_employer c2_ ON v0_.manager_id = c2_.user_id WHERE v0_.status = 'public' AND v0_.published_at IS NOT NULL AND v0_.city_id IN ('1efe92d4-23a2-686c-a633-85927c91bd49') AND v0_.id NOT IN ('1f072aa8-ddde-6892-ac87-0996f4dc872e') AND v0_.rate = 'optimum' ORDER BY sclr_23 ASC 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 141)
8	App\Controller\VacancyController->list (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

13.74 ms
(4.92%)

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:

[
  "1f072aa8-ddde-6892-ac87-0996f4dc872e"
]

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 = '1f072aa8-ddde-6892-ac87-0996f4dc872e';

#	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 65)
14	App\Controller\VacancyController->list (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)

8.98 ms
(3.22%)

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 {#4268
    __toString(): "1f0c3826-30dd-6478-937c-63f6e21b6e4b"
  }
  "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 = '1f0c3826-30dd-6478-937c-63f6e21b6e4b' 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 50)
13	__TwigTemplate_9a274dda1f14934af0d2ca141d978a20->doDisplay (line 387)
14	Twig\Template->yield (line 610)
15	__TwigTemplate_37598f61e8d3aef2847c0bdb47711912->block_body (line 431)
16	Twig\Template->yieldBlock (line 152)
17	__TwigTemplate_791028594e207f292675a1110a743f1c->doDisplay (line 387)
18	Twig\Template->yield (line 178)
19	__TwigTemplate_37598f61e8d3aef2847c0bdb47711912->doDisplay (line 387)
20	Twig\Template->yield (line 343)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 320)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 149)
28	App\Controller\VacancyController->list (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

8.90 ms
(3.19%)

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 {#4268
    __toString(): "1f0c3826-30dd-6478-937c-63f6e21b6e4b"
  }
]

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 = '1f0c3826-30dd-6478-937c-63f6e21b6e4b' 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 50)
13	__TwigTemplate_9a274dda1f14934af0d2ca141d978a20->doDisplay (line 387)
14	Twig\Template->yield (line 610)
15	__TwigTemplate_37598f61e8d3aef2847c0bdb47711912->block_body (line 431)
16	Twig\Template->yieldBlock (line 152)
17	__TwigTemplate_791028594e207f292675a1110a743f1c->doDisplay (line 387)
18	Twig\Template->yield (line 178)
19	__TwigTemplate_37598f61e8d3aef2847c0bdb47711912->doDisplay (line 387)
20	Twig\Template->yield (line 343)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 320)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 149)
28	App\Controller\VacancyController->list (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

8.35 ms
(2.99%)

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

Parameters:

[
  "US;California;San Francisco"
]

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.db_ip_light_city_id = ?
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.db_ip_light_city_id = 'US;California;San Francisco' 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 45)
4	App\Infrastructure\City\Repository\CityRepository->findByDbIpLightCityId (line 57)
5	App\Util\CityIpDetector\DbIpLiteCityIpDetector->find (line 158)
6	App\Infrastructure\City\Service\CitySelectorManager->getCityByIp (line 48)
7	App\Infrastructure\City\Service\CitySelectorManager->getCity (line 1871)
8	Twig\Extension\CoreExtension::getAttribute (line 146)
9	__TwigTemplate_37598f61e8d3aef2847c0bdb47711912->doDisplay (line 387)
10	Twig\Template->yield (line 343)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 320)
14	Twig\Environment->render (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 149)
18	App\Controller\VacancyController->list (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

6.14 ms
(2.20%)

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:

[
  "1f072aa8-ddde-6892-ac87-0996f4dc872e"
]

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 = '1f072aa8-ddde-6892-ac87-0996f4dc872e';

#	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 65)
7	App\Controller\VacancyController->list (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.94 ms
(2.13%)

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:

[
  "1efe8531-6dd3-641e-8109-25a48a817cda"
]

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 = '1efe8531-6dd3-641e-8109-25a48a817cda';

#	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 120)
6	App\Infrastructure\City\Service\CitySelectorManager->getPopularCities (line 1871)
7	Twig\Extension\CoreExtension::getAttribute (line 868)
8	__TwigTemplate_7187af1de881327dcb07992dea06b5a9->block_header (line 431)
9	Twig\Template->yieldBlock (line 66)
10	__TwigTemplate_7187af1de881327dcb07992dea06b5a9->doDisplay (line 387)
11	Twig\Template->yield (line 150)
12	__TwigTemplate_791028594e207f292675a1110a743f1c->doDisplay (line 387)
13	Twig\Template->yield (line 178)
14	__TwigTemplate_37598f61e8d3aef2847c0bdb47711912->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 149)
23	App\Controller\VacancyController->list (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)

5.78 ms
(2.07%)

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:

[
  "moscow"
]

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 = 'moscow' 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 33)
4	App\Infrastructure\City\Repository\CityRepository->getBySlug (line 75)
5	App\Controller\VacancyController->list (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

5.54 ms
(1.99%)

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 {#4268
    __toString(): "1f0c3826-30dd-6478-937c-63f6e21b6e4b"
  }
  "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 = '1f0c3826-30dd-6478-937c-63f6e21b6e4b' 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 50)
14	__TwigTemplate_9a274dda1f14934af0d2ca141d978a20->doDisplay (line 387)
15	Twig\Template->yield (line 610)
16	__TwigTemplate_37598f61e8d3aef2847c0bdb47711912->block_body (line 431)
17	Twig\Template->yieldBlock (line 152)
18	__TwigTemplate_791028594e207f292675a1110a743f1c->doDisplay (line 387)
19	Twig\Template->yield (line 178)
20	__TwigTemplate_37598f61e8d3aef2847c0bdb47711912->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 320)
25	Twig\Environment->render (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 149)
29	App\Controller\VacancyController->list (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

4.11 ms
(1.47%)

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:

[
  "1f0c3826-30dd-6478-937c-63f6e21b6e4b"
]

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 = '1f0c3826-30dd-6478-937c-63f6e21b6e4b';

#	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 76)
8	App\Domain\Company\Company->getTitle (line 146)
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 50)
14	__TwigTemplate_9a274dda1f14934af0d2ca141d978a20->doDisplay (line 387)
15	Twig\Template->yield (line 610)
16	__TwigTemplate_37598f61e8d3aef2847c0bdb47711912->block_body (line 431)
17	Twig\Template->yieldBlock (line 152)
18	__TwigTemplate_791028594e207f292675a1110a743f1c->doDisplay (line 387)
19	Twig\Template->yield (line 178)
20	__TwigTemplate_37598f61e8d3aef2847c0bdb47711912->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 320)
25	Twig\Environment->render (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 149)
29	App\Controller\VacancyController->list (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

2.93 ms
(1.05%)

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:

[
  "1f0c3826-30d9-688c-b709-63f6e21b6e4b"
]

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 = '1f0c3826-30d9-688c-b709-63f6e21b6e4b';

#	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 1871)
9	Twig\Extension\CoreExtension::getAttribute (line 50)
10	__TwigTemplate_9a274dda1f14934af0d2ca141d978a20->doDisplay (line 387)
11	Twig\Template->yield (line 610)
12	__TwigTemplate_37598f61e8d3aef2847c0bdb47711912->block_body (line 431)
13	Twig\Template->yieldBlock (line 152)
14	__TwigTemplate_791028594e207f292675a1110a743f1c->doDisplay (line 387)
15	Twig\Template->yield (line 178)
16	__TwigTemplate_37598f61e8d3aef2847c0bdb47711912->doDisplay (line 387)
17	Twig\Template->yield (line 343)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 320)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 149)
25	App\Controller\VacancyController->list (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)

2.51 ms
(0.90%)

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

Parameters:

[
  "1f0c3826-30dd-6478-937c-63f6e21b6e4b"
]

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 = '1f0c3826-30dd-6478-937c-63f6e21b6e4b';

#	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 76)
20	App\Domain\Company\Company->getTitle (line 146)
21	App\Infrastructure\Company\Service\CompanyManager->App\Infrastructure\Company\Service\{closure} (line 32)
22	Kenny1911\Memoizer\Memoizer->memoize (line 116)
23	App\Infrastructure\Company\Service\CompanyManager->getCompanyInfo (line 43)
24	App\Util\RaberuVariable\CompanyHelper->getInfo (line 1871)
25	Twig\Extension\CoreExtension::getAttribute (line 50)
26	__TwigTemplate_9a274dda1f14934af0d2ca141d978a20->doDisplay (line 387)
27	Twig\Template->yield (line 610)
28	__TwigTemplate_37598f61e8d3aef2847c0bdb47711912->block_body (line 431)
29	Twig\Template->yieldBlock (line 152)
30	__TwigTemplate_791028594e207f292675a1110a743f1c->doDisplay (line 387)
31	Twig\Template->yield (line 178)
32	__TwigTemplate_37598f61e8d3aef2847c0bdb47711912->doDisplay (line 387)
33	Twig\Template->yield (line 343)
34	Twig\Template->display (line 358)
35	Twig\Template->render (line 51)
36	Twig\TemplateWrapper->render (line 320)
37	Twig\Environment->render (line 448)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 149)
41	App\Controller\VacancyController->list (line 181)
42	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
43	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
44	Symfony\Component\HttpKernel\Kernel->handle (line 35)
45	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
46	require_once (line 5)

1.19 ms
(0.42%)

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:

[
  "1ef50b3a-cad2-66f8-abb1-cffe2bddeb45"
]

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 = '1ef50b3a-cad2-66f8-abb1-cffe2bddeb45';

#	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 51)
9	App\Form\SuggestType\Suggest\CitySuggester->transformObject (line 44)
10	Sirian\SuggestBundle\Suggest\DoctrineSuggester->transform (line 35)
11	Sirian\SuggestBundle\Form\DataTransformer\SuggestTransformer->transform (line 992)
12	Symfony\Component\Form\Form->normToView (line 301)
13	Symfony\Component\Form\Form->setData (line 50)
14	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 323)
15	Symfony\Component\Form\Form->setData (line 412)
16	Symfony\Component\Form\Form->initialize (line 176)
17	Symfony\Component\Form\FormBuilder->getForm (line 28)
18	Symfony\Component\Form\FormFactory->create (line 340)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 128)
20	App\Controller\AbstractController->createForm (line 109)
21	App\Controller\VacancyController->list (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.50 ms
(0.18%)

SELECT c0_.name AS name_0, c0_.name_prepositional AS name_prepositional_1, c0_.banner_path AS banner_path_2, c0_.slug AS slug_3, c0_.db_ip_light_city_id AS db_ip_light_city_id_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.id AS id_7, c0_.metadata_title AS metadata_title_8, c0_.metadata_description AS metadata_description_9, c0_.metadata_keywords AS metadata_keywords_10, c0_.region_id AS region_id_11 FROM city c0_ WHERE c0_.id IN (?)

Parameters:

[
  "1efe92d4-23a2-686c-a633-85927c91bd49"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.name AS name_0,
  c0_.name_prepositional AS name_prepositional_1,
  c0_.banner_path AS banner_path_2,
  c0_.slug AS slug_3,
  c0_.db_ip_light_city_id AS db_ip_light_city_id_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6,
  c0_.id AS id_7,
  c0_.metadata_title AS metadata_title_8,
  c0_.metadata_description AS metadata_description_9,
  c0_.metadata_keywords AS metadata_keywords_10,
  c0_.region_id AS region_id_11
FROM
  city c0_
WHERE
  c0_.id IN (?)

SELECT c0_.name AS name_0, c0_.name_prepositional AS name_prepositional_1, c0_.banner_path AS banner_path_2, c0_.slug AS slug_3, c0_.db_ip_light_city_id AS db_ip_light_city_id_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.id AS id_7, c0_.metadata_title AS metadata_title_8, c0_.metadata_description AS metadata_description_9, c0_.metadata_keywords AS metadata_keywords_10, c0_.region_id AS region_id_11 FROM city c0_ WHERE c0_.id IN ('1efe92d4-23a2-686c-a633-85927c91bd49');

#	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 100)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntitiesByIds (line 37)
8	Sirian\SuggestBundle\Suggest\DoctrineSuggester->reverseTransform (line 76)
9	Sirian\SuggestBundle\Form\DataTransformer\SuggestTransformer->reverseTransform (line 1014)
10	Symfony\Component\Form\Form->viewToNorm (line 558)
11	Symfony\Component\Form\Form->submit (line 499)
12	Symfony\Component\Form\Form->submit (line 110)
13	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 420)
14	Symfony\Component\Form\Form->handleRequest (line 110)
15	App\Controller\VacancyController->list (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	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/moscow/vacancies?vacancyId=1f072aa8-ddde-6892-ac87-0996f4dc872e

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping