Symfony Profiler

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 = 'po-chesnoku-ili-po-maionezu-uznaite-kakoi-vy-sous' AND b0_.published_at IS NOT NULL;

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 = '1f17a9c4-f1f2-6c9c-a6a3-77c6aa6e0220';

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 = '1f17e8d0-c587-6d88-adba-61bd245d458f';

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 = '1f17e8d0-c587-6d88-adba-61bd245d458f';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  blog
SET
  view_count = ?
WHERE
  id = ?

UPDATE blog SET view_count = 13 WHERE id = '1f17e8d0-c587-6d88-adba-61bd245d458f';

"COMMIT"

"COMMIT";

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.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 = '1f17c226-52c2-6850-bfc4-6defc0369c78';

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 = '1f17e8e0-55be-6406-9852-bd10d7b534fc';

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 = '1f17e8e0-55be-6406-9852-bd10d7b534fc';

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 = '1f17e8dd-7bb7-6390-8220-b38262a9234e';

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 = '1f17e8dd-7bb7-6390-8220-b38262a9234e';

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 = '1f17e8d8-32f7-6790-aee8-7df6ad3a2643';

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 = '1f17e8d8-32f7-6790-aee8-7df6ad3a2643';

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 = '1f17ab16-ba51-6376-94c3-bd41f77a0afd';

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 = '1f17e8d5-cf1c-652e-bbeb-89308a61a83f';

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 = '1f17e8d5-cf1c-652e-bbeb-89308a61a83f';

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 = '1f17e8d3-adf6-65ae-8947-e7cdf9a0999d';

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 = '1f17e8d3-adf6-65ae-8947-e7cdf9a0999d';

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 = '1f17e8cc-7876-6d86-9214-2777ff457477';

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 = '1f17e8cc-7876-6d86-9214-2777ff457477';

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
  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;