Symfony Profiler

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 = '1f13ed2d-4c34-6848-830c-8fd73e5529dd' 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 = ?
  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 = '1f13ed2d-4c34-6848-830c-8fd73e5529dd' AND v0_.published_at IS NOT NULL AND v0_.status = 'public' AND v0_.is_anonymous = false;

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-02ce-7735-a338-b8d423026ffb';

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

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

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 = '1f14d320-0a12-66ca-b305-0f6fd9e93104';

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

SELECT DISTINCT v0_.public_id AS public_id_0, v0_.title AS title_1, v0_.description AS description_2, v0_.payment_period AS payment_period_3, v0_.payment_format AS payment_format_4, v0_.address AS address_5, v0_.salary_min AS salary_min_6, v0_.salary_max AS salary_max_7, v0_.experience AS experience_8, v0_.employment AS employment_9, v0_.schedule AS schedule_10, v0_.rate AS rate_11, v0_.status AS status_12, v0_.phone AS phone_13, v0_.show_phone AS show_phone_14, v0_.from14_years AS from14_years_15, v0_.is_anonymous AS is_anonymous_16, v0_.with_physical_disabilities AS with_physical_disabilities_17, v0_.autopublish AS autopublish_18, v0_.published_at AS published_at_19, v0_.created_at AS created_at_20, v0_.updated_at AS updated_at_21, v0_.archived_at AS archived_at_22, v0_.id AS id_23, v0_.moderation_id AS moderation_id_24, v0_.manager_id AS manager_id_25, v0_.specialization_id AS specialization_id_26, v0_.city_id AS city_id_27 FROM vacancies v0_ INNER JOIN company_employer c1_ ON v0_.manager_id = c1_.user_id WHERE v0_.status = 'public' AND v0_.published_at IS NOT NULL AND v0_.city_id IN ('019256cb-02ce-7735-a338-b8d423026ffb', '019256cb-02ce-7735-a338-b8d423026ffb') AND v0_.specialization_id IN ('1ef3d043-cd26-65d6-a041-f58a4137242f') AND v0_.id NOT IN ('1f14d320-0a12-66ca-b305-0f6fd9e93104') ORDER BY v0_.published_at DESC LIMIT 6;

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

SELECT v0_.title AS title_0, v0_.salary_min AS salary_min_1, v0_.salary_max AS salary_max_2, v0_.published_at AS published_at_3, v0_.status AS status_4, v0_.description AS description_5, v0_.experience AS experience_6, v0_.schedule AS schedule_7, v0_.employment AS employment_8, c1_.name AS name_9 FROM vacancies v0_ INNER JOIN company_employer c2_ ON v0_.manager_id = c2_.user_id INNER JOIN city c1_ ON v0_.city_id = c1_.id WHERE c2_.company_id = '1f13ed2d-4c34-6848-830c-8fd73e5529dd' AND v0_.published_at IS NOT NULL AND v0_.status = 'public' AND v0_.is_anonymous = false ORDER BY v0_.published_at DESC LIMIT 5;

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

INSERT INTO vacancy_view (created_at, id, vacancy_id, manager_id, user_id) VALUES ('2026-07-10 15:38:38', '1f17c756-b803-6c5c-8842-f121679cbd82', '1f14d320-0a12-66ca-b305-0f6fd9e93104', '1f14d2fa-0f62-6f06-8d51-e9af0e3dacbc', NULL);

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 = '1f13ed2d-4c34-6848-830c-8fd73e5529dd' AND f1_.moderation_status IN ('moderation', 'accepted');

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 = '1f13ed2d-4c34-6848-830c-8fd73e5529dd';

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-02ce-7735-a338-b8d423026ffb') AND v0_.specialization_id IN ('1ef3d043-cd26-65d6-a041-f58a4137242f') AND v0_.id NOT IN ('1f14d320-0a12-66ca-b305-0f6fd9e93104');

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 = '1f14d2fa-0f62-6f06-8d51-e9af0e3dacbc';

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 = '1f13ed2d-4c34-6848-830c-8fd73e5529dd';

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 = '1ef3d043-cd26-65d6-a041-f58a4137242f';

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 = '1ef3d043-cd26-65d6-a041-f58a4137242f';

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

SELECT COUNT(view.id) FROM vacancy_view view
    LEFT JOIN vacancies v ON v.id = view.vacancy_id
    WHERE view.vacancy_id = '1f14d320-0a12-66ca-b305-0f6fd9e93104'
    AND v.status = 'public'
    AND view.created_at > date_trunc('day', now())
    AND view.created_at < now();

"COMMIT"

"COMMIT";

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

SELECT DISTINCT v0_.public_id AS public_id_0, v0_.title AS title_1, v0_.description AS description_2, v0_.payment_period AS payment_period_3, v0_.payment_format AS payment_format_4, v0_.address AS address_5, v0_.salary_min AS salary_min_6, v0_.salary_max AS salary_max_7, v0_.experience AS experience_8, v0_.employment AS employment_9, v0_.schedule AS schedule_10, v0_.rate AS rate_11, v0_.status AS status_12, v0_.phone AS phone_13, v0_.show_phone AS show_phone_14, v0_.from14_years AS from14_years_15, v0_.is_anonymous AS is_anonymous_16, v0_.with_physical_disabilities AS with_physical_disabilities_17, v0_.autopublish AS autopublish_18, v0_.published_at AS published_at_19, v0_.created_at AS created_at_20, v0_.updated_at AS updated_at_21, v0_.archived_at AS archived_at_22, v0_.id AS id_23, v0_.moderation_id AS moderation_id_24, v0_.manager_id AS manager_id_25, v0_.specialization_id AS specialization_id_26, v0_.city_id AS city_id_27 FROM vacancies v0_ INNER JOIN company_employer c1_ ON v0_.manager_id = c1_.user_id WHERE v0_.status = 'public' AND v0_.published_at IS NOT NULL AND v0_.city_id IN ('019256cb-02ce-7735-a338-b8d423026ffb') AND v0_.specialization_id IN ('1ef3ac0f-fd7c-6bf2-b3f2-cd2330489748') AND v0_.id NOT IN ('1f14d320-0a12-66ca-b305-0f6fd9e93104', '1f16a42d-6b27-662e-a377-57a18c157c99', '1f11eba3-d0b7-6288-a354-0187cf41fad7', '1f14d580-0268-620a-97f3-7144aebc4924') ORDER BY v0_.published_at DESC LIMIT 3;

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 = '1ef50b18-9ad2-6254-9b7f-c3b6dda9436c';

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

SELECT COUNT(view.id) FROM vacancy_view view
    LEFT JOIN vacancies v ON v.id = view.vacancy_id
    WHERE view.vacancy_id = '1f14d320-0a12-66ca-b305-0f6fd9e93104'
    AND v.status = 'public';

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

SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM category t0 WHERE t0.id = '1ef3abcb-4a67-6222-9a21-b3b3ebef6355';