Symfony Profiler

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 = '1f0c43f1-e52c-67f4-8c1c-adf97876518d';

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 = '1f0c43f1-e52c-67f4-8c1c-adf97876518d';

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 = '1f0c43f3-82b3-63d2-b774-276732139062';

"START TRANSACTION"

"START TRANSACTION";

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 09:59:40', '1f0ec78b-f867-61b4-a94d-1bec229d4ea1', '1f0c43f1-e52c-67f4-8c1c-adf97876518d', '1ef44e90-5a09-65b4-a70e-7b53ceb5a598', NULL);

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 = '1ef44e90-5a09-65b4-a70e-7b53ceb5a598';

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 = '1ef44e90-5a0c-69a8-804a-7b53ceb5a598' AND (v0_.status_start IN ('public', 'archive') OR v0_.status_end IN ('public', 'archive')) AND v0_.vacancy_id = '1f0c43f1-e52c-67f4-8c1c-adf97876518d' AND v0_.created_at >= '2026-01-08 00:00:00' AND v0_.created_at <= '2026-01-08 23:59:59';

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 = '1f0c43f1-e52c-67f4-8c1c-adf97876518d' AND v0_.created_at >= '2026-01-08 00:00:00' AND v0_.created_at <= '2026-01-08 23:59:59';

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 = '1f0c43f1-e52c-67f4-8c1c-adf97876518d' AND v0_.created_at >= '2026-01-08 00:00:00' AND v0_.created_at <= '2026-01-08 23:59:59';

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 = '1f0c43f1-e52c-67f4-8c1c-adf97876518d' AND v0_.source = 'applicantRequest' AND v0_.created_at >= '2026-01-08 00:00:00' AND v0_.created_at <= '2026-01-08 23:59:59';

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 = '1f0c43f1-e52c-67f4-8c1c-adf97876518d' AND c0_.published_at >= '2026-01-08 00:00:00' AND c0_.published_at <= '2026-01-08 23:59:59';

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 = '1f0c43f1-e52c-67f4-8c1c-adf97876518d' AND c0_.published_at >= '2026-01-08 00:00:00' AND c0_.published_at <= '2026-01-08 23:59:59';

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 09:59:40', '2026-01-08 09:59:40', '1f0ec78b-f8f1-6206-b356-1bec229d4ea1', '1f0c43f1-e52c-67f4-8c1c-adf97876518d', '1ef44e90-5a0c-69a8-804a-7b53ceb5a598', '019256cb-02ef-722d-9da1-1cfd87feeaa9', '019256cb-02ef-722d-9da1-1cfd87feeaa9', '1ef44e90-5a09-65b4-a70e-7b53ceb5a598', '1ef44e90-5a09-65b4-a70e-7b53ceb5a598', '1ef3d1d4-a78b-6f8c-8201-f53d19e979f3', '1ef3d1d4-a78b-6f8c-8201-f53d19e979f3');

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 = '1f0c43f1-e52c-67f4-8c1c-adf97876518d' AND v0_.created_at >= '2026-01-08 00:00:00' AND v0_.created_at <= '2026-01-08 23:59:59';

"COMMIT"

"COMMIT";

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-02ef-722d-9da1-1cfd87feeaa9') AND v0_.specialization_id IN ('1ef3d1d4-a78b-6f8c-8201-f53d19e979f3') AND v0_.id NOT IN ('1f0c43f1-e52c-67f4-8c1c-adf97876518d');

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 = '1ef3d1d4-a78b-6f8c-8201-f53d19e979f3';

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 = '1ef3d1d4-a78b-6f8c-8201-f53d19e979f3';

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-02ef-722d-9da1-1cfd87feeaa9', '019256cb-02ef-722d-9da1-1cfd87feeaa9') AND v0_.specialization_id IN ('1ef3d1d4-a78b-6f8c-8201-f53d19e979f3') AND v0_.id NOT IN ('1f0c43f1-e52c-67f4-8c1c-adf97876518d') ORDER BY v0_.published_at DESC LIMIT 6;

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 = '1f08444b-6ad4-6b72-9af9-93cebac12539';

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
  5