Symfony Profiler

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

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

SELECT
  b0_.id AS id_0,
  b0_.title_public AS title_public_1,
  b0_.description_public AS description_public_2,
  b0_.text_public AS text_public_3,
  b0_.created_at AS created_at_4,
  b0_.updated_at AS updated_at_5,
  b0_.published_at AS published_at_6,
  b0_.like_count AS like_count_7,
  b0_.dislike_count AS dislike_count_8,
  b0_.view_count AS view_count_9,
  b0_.photo AS photo_10,
  b0_.photo_alt AS photo_alt_11,
  b0_.photo_title AS photo_title_12,
  b0_.category AS category_13,
  b0_.slug AS slug_14,
  b0_.title_meta AS title_meta_15,
  b0_.description_meta AS description_meta_16,
  b0_.show_in_category AS show_in_category_17,
  b0_.show_in_widget AS show_in_widget_18,
  b0_.sitemap_inclusion AS sitemap_inclusion_19,
  b0_.sitemap_priority AS sitemap_priority_20,
  b0_.sitemap_frequency AS sitemap_frequency_21,
  b0_.admin AS admin_22,
  b0_.author_id AS author_id_23
FROM
  blog b0_
WHERE
  b0_.slug = ?
  AND b0_.published_at IS NOT NULL

SELECT b0_.id AS id_0, b0_.title_public AS title_public_1, b0_.description_public AS description_public_2, b0_.text_public AS text_public_3, b0_.created_at AS created_at_4, b0_.updated_at AS updated_at_5, b0_.published_at AS published_at_6, b0_.like_count AS like_count_7, b0_.dislike_count AS dislike_count_8, b0_.view_count AS view_count_9, b0_.photo AS photo_10, b0_.photo_alt AS photo_alt_11, b0_.photo_title AS photo_title_12, b0_.category AS category_13, b0_.slug AS slug_14, b0_.title_meta AS title_meta_15, b0_.description_meta AS description_meta_16, b0_.show_in_category AS show_in_category_17, b0_.show_in_widget AS show_in_widget_18, b0_.sitemap_inclusion AS sitemap_inclusion_19, b0_.sitemap_priority AS sitemap_priority_20, b0_.sitemap_frequency AS sitemap_frequency_21, b0_.admin AS admin_22, b0_.author_id AS author_id_23 FROM blog b0_ WHERE b0_.slug = '38-samykh-atmosfernykh-terras-peterburga-vidy-na-nevu-verandy-v-tsentre-i-uyutnyye-dvoriki' AND b0_.published_at IS NOT NULL;

SELECT
  t0.id AS id_1,
  t0.tag AS tag_2,
  t0.slug AS slug_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.published_at AS published_at_6,
  t0.sitemap_inclusion AS sitemap_inclusion_7,
  t0.sitemap_priority AS sitemap_priority_8,
  t0.sitemap_frequency AS sitemap_frequency_9,
  t0.admin AS admin_10
FROM
  blog_tags t0
  INNER JOIN blog_blog_tags ON t0.id = blog_blog_tags.blog_tag_id
WHERE
  blog_blog_tags.blog_id = ?

SELECT t0.id AS id_1, t0.tag AS tag_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.published_at AS published_at_6, t0.sitemap_inclusion AS sitemap_inclusion_7, t0.sitemap_priority AS sitemap_priority_8, t0.sitemap_frequency AS sitemap_frequency_9, t0.admin AS admin_10 FROM blog_tags t0 INNER JOIN blog_blog_tags ON t0.id = blog_blog_tags.blog_tag_id WHERE blog_blog_tags.blog_id = '1f17c1fc-bf39-6d78-af52-19b7e3f242dd';

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 = '1f1699dc-e205-6454-a1b1-b57492e6ed10';

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 = '1f15f4bf-4514-6e14-b4aa-035af11127cd';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.photo AS photo_3,
  t0.position AS position_4,
  t0.created_at AS created_at_5,
  t0.published_at AS published_at_6,
  t0.admin AS admin_7
FROM
  blog_authors t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.published_at AS published_at_6, t0.admin AS admin_7 FROM blog_authors t0 WHERE t0.id = '1f17b5e4-244a-64bc-a266-1dada717e5a3';

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 = '1f0f3c6f-c004-6e58-b5ad-0bcc0e6d21f4';

SELECT
  t0.id AS id_1,
  t0.tag AS tag_2,
  t0.name AS name_3,
  t0.position AS position_4,
  t0.blog_id AS blog_id_5
FROM
  blog_anchors t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.tag AS tag_2, t0.name AS name_3, t0.position AS position_4, t0.blog_id AS blog_id_5 FROM blog_anchors t0 WHERE t0.blog_id = '1f17c1fc-bf39-6d78-af52-19b7e3f242dd';

SELECT
  b0_.id AS id_0,
  b0_.title_public AS title_public_1,
  b0_.description_public AS description_public_2,
  b0_.text_public AS text_public_3,
  b0_.created_at AS created_at_4,
  b0_.updated_at AS updated_at_5,
  b0_.published_at AS published_at_6,
  b0_.like_count AS like_count_7,
  b0_.dislike_count AS dislike_count_8,
  b0_.view_count AS view_count_9,
  b0_.photo AS photo_10,
  b0_.photo_alt AS photo_alt_11,
  b0_.photo_title AS photo_title_12,
  b0_.category AS category_13,
  b0_.slug AS slug_14,
  b0_.title_meta AS title_meta_15,
  b0_.description_meta AS description_meta_16,
  b0_.show_in_category AS show_in_category_17,
  b0_.show_in_widget AS show_in_widget_18,
  b0_.sitemap_inclusion AS sitemap_inclusion_19,
  b0_.sitemap_priority AS sitemap_priority_20,
  b0_.sitemap_frequency AS sitemap_frequency_21,
  b0_.admin AS admin_22,
  b0_.author_id AS author_id_23
FROM
  blog b0_
WHERE
  b0_.category = ?
  AND b0_.show_in_category = ?
  AND b0_.published_at IS NOT NULL
ORDER BY
  b0_.published_at DESC
LIMIT
  7

SELECT b0_.id AS id_0, b0_.title_public AS title_public_1, b0_.description_public AS description_public_2, b0_.text_public AS text_public_3, b0_.created_at AS created_at_4, b0_.updated_at AS updated_at_5, b0_.published_at AS published_at_6, b0_.like_count AS like_count_7, b0_.dislike_count AS dislike_count_8, b0_.view_count AS view_count_9, b0_.photo AS photo_10, b0_.photo_alt AS photo_alt_11, b0_.photo_title AS photo_title_12, b0_.category AS category_13, b0_.slug AS slug_14, b0_.title_meta AS title_meta_15, b0_.description_meta AS description_meta_16, b0_.show_in_category AS show_in_category_17, b0_.show_in_widget AS show_in_widget_18, b0_.sitemap_inclusion AS sitemap_inclusion_19, b0_.sitemap_priority AS sitemap_priority_20, b0_.sitemap_frequency AS sitemap_frequency_21, b0_.admin AS admin_22, b0_.author_id AS author_id_23 FROM blog b0_ WHERE b0_.category = 'employer' AND b0_.show_in_category = 1 AND b0_.published_at IS NOT NULL ORDER BY b0_.published_at DESC LIMIT 7;

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 = '1ef3ab2d-2b26-6b22-a5fa-8f4f45f98ab7';

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
  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 = '1f0f3c6f-c004-6e58-b5ad-0bcc0e6d21f4';

"COMMIT"

"COMMIT";

UPDATE
  blog
SET
  view_count = ?
WHERE
  id = ?

UPDATE blog SET view_count = 56 WHERE id = '1f17c1fc-bf39-6d78-af52-19b7e3f242dd';

"START TRANSACTION"

"START TRANSACTION";