Symfony Profiler

SELECT
  t0.public_id AS public_id_1,
  t0.email AS email_2,
  t0.email_confirmed AS email_confirmed_3,
  t0.password AS password_4,
  t0.enabled AS enabled_5,
  t0.has_notifications AS has_notifications_6,
  t0.phone AS phone_7,
  t0.phone_confirmed AS phone_confirmed_8,
  t0.photo_path AS photo_path_9,
  t0.first_name AS first_name_10,
  t0.middle_name AS middle_name_11,
  t0.last_name AS last_name_12,
  t0.birthday AS birthday_13,
  t0.gender AS gender_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.id AS id_17,
  t0.city_id AS city_id_18
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.public_id AS public_id_1, t0.email AS email_2, t0.email_confirmed AS email_confirmed_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.has_notifications AS has_notifications_6, t0.phone AS phone_7, t0.phone_confirmed AS phone_confirmed_8, t0.photo_path AS photo_path_9, t0.first_name AS first_name_10, t0.middle_name AS middle_name_11, t0.last_name AS last_name_12, t0.birthday AS birthday_13, t0.gender AS gender_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.id AS id_17, t0.city_id AS city_id_18 FROM users t0 WHERE t0.id = '1ef3d1dc-2f23-67b8-b501-831e21aeedaf';

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 = '1ef3d1dc-2f23-67b8-b501-831e21aeedaf';

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 = 'izhevsk' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  MIN(v1_.salary_min) AS sclr_2,
  MIN(v1_.salary_max) AS sclr_3,
  MAX(v1_.salary_min) AS sclr_4,
  MAX(v1_.salary_max) AS sclr_5,
  COUNT(v1_.id) AS sclr_6
FROM
  specialization s0_
  LEFT JOIN vacancies v1_ ON (
    v1_.specialization_id = s0_.id
    AND v1_.status = ?
    AND v1_.city_id = ?
  )
WHERE
  s0_.metadata_slug IS NOT NULL
  AND s0_.metadata_slug <> ''
GROUP BY
  s0_.id
ORDER BY
  COUNT(v1_.id) DESC
LIMIT
  11

SELECT s0_.id AS id_0, s0_.name AS name_1, MIN(v1_.salary_min) AS sclr_2, MIN(v1_.salary_max) AS sclr_3, MAX(v1_.salary_min) AS sclr_4, MAX(v1_.salary_max) AS sclr_5, COUNT(v1_.id) AS sclr_6 FROM specialization s0_ LEFT JOIN vacancies v1_ ON (v1_.specialization_id = s0_.id AND v1_.status = 'public' AND v1_.city_id = '1ef3ab2d-2b26-6b22-a5fa-8f4f45f98ab7') WHERE s0_.metadata_slug IS NOT NULL AND s0_.metadata_slug <> '' GROUP BY s0_.id ORDER BY COUNT(v1_.id) DESC LIMIT 11;

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

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;

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 (?)
ORDER BY
  v0_.published_at DESC
LIMIT
  9

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 ('1ef3ab2d-2b26-6b22-a5fa-8f4f45f98ab7') ORDER BY v0_.published_at DESC LIMIT 9;

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 = '1f0a658d-cbf3-6196-8f6e-35b64fd719e2';

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 = '1f0818e6-1b2c-6646-a75d-f56f9ba83f1b';

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 = '1f0c8f46-3c8c-687e-a79d-4519587e957e';

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 = '1f0b0d18-7991-683e-92b0-db5aa88adb38';

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 = '1f09546a-14b1-63dc-adb9-2d1f49a3a9e5';

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 = '1f0b0140-672e-6f72-a6a7-65ca7f579153';

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 = '1f0b011e-b26d-6db6-a4c9-534b285b29bb';

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 = '1f0ada6b-a027-66d6-9cda-eba44fc68b50';

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 = '1f0691f0-3f24-696e-9e20-258ce6770167';

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
  INNER JOIN city_related_cities ON t0.id = city_related_cities.related_city_id
WHERE
  city_related_cities.city_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 INNER JOIN city_related_cities ON t0.id = city_related_cities.related_city_id WHERE city_related_cities.city_id = '1ef3ab2d-2b26-6b22-a5fa-8f4f45f98ab7';

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  companies c0_
WHERE
  c0_.city_id IN (?)
  AND c0_.confirmed = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM companies c0_ WHERE c0_.city_id IN ('1ef3ab2d-2b26-6b22-a5fa-8f4f45f98ab7') AND c0_.confirmed = 1;

SELECT
  c0_.public_id AS public_id_0,
  c0_.title AS title_1,
  c0_.inn AS inn_2,
  c0_.description AS description_3,
  c0_.logo_path AS logo_path_4,
  c0_.confirmed AS confirmed_5,
  c0_.contract_path AS contract_path_6,
  c0_.rating AS rating_7,
  c0_.site AS site_8,
  c0_.created_at AS created_at_9,
  c0_.updated_at AS updated_at_10,
  c0_.id AS id_11,
  (
    SELECT
      COUNT(DISTINCT v1_.id) AS sclr_13
    FROM
      vacancies v1_
      INNER JOIN company_employer c2_ ON v1_.manager_id = c2_.user_id
    WHERE
      v1_.status = ?
      AND c2_.company_id = c0_.id
  ) AS sclr_12,
  c0_.city_id AS city_id_14,
  c0_.category_id AS category_id_15
FROM
  companies c0_
WHERE
  c0_.city_id IN (?)
  AND c0_.confirmed = ?
ORDER BY
  sclr_12 DESC
LIMIT
  6

SELECT c0_.public_id AS public_id_0, c0_.title AS title_1, c0_.inn AS inn_2, c0_.description AS description_3, c0_.logo_path AS logo_path_4, c0_.confirmed AS confirmed_5, c0_.contract_path AS contract_path_6, c0_.rating AS rating_7, c0_.site AS site_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.id AS id_11, (SELECT COUNT(DISTINCT v1_.id) AS sclr_13 FROM vacancies v1_ INNER JOIN company_employer c2_ ON v1_.manager_id = c2_.user_id WHERE v1_.status = 'public' AND c2_.company_id = c0_.id) AS sclr_12, c0_.city_id AS city_id_14, c0_.category_id AS category_id_15 FROM companies c0_ WHERE c0_.city_id IN ('1ef3ab2d-2b26-6b22-a5fa-8f4f45f98ab7') AND c0_.confirmed = 1 ORDER BY sclr_12 DESC LIMIT 6;

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 = '1f031766-5d70-6a4c-bb6b-63d94574b27e';

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 = '1f0b57da-22df-6a24-9b3c-d7c0536d16e2';

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 = '1f0b4ad7-ddf4-6e5a-95d4-f5d7c5310fe3';

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 = '1f0b300a-5ed5-659e-98b3-69cbd3693daa';

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 = '1f0a29d3-c291-6328-acfe-d5db93a2a51c';