Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.is_default AS is_default_2,
  t0.is_enabled AS is_enabled_3,
  t0.position AS position_4,
  t0.code AS code_5,
  t0.name AS name_6
FROM
  language t0
WHERE
  t0.is_enabled = ?
ORDER BY
  t0.position ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.is_enabled AS is_enabled_3, t0.position AS position_4, t0.code AS code_5, t0.name AS name_6 FROM language t0 WHERE t0.is_enabled = 1 ORDER BY t0.position ASC, t0.id ASC;

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.title AS title_2,
  p0_.slug AS slug_3,
  p0_.excerpt AS excerpt_4,
  p0_.content_html AS content_html_5,
  p0_.content_text AS content_text_6,
  p0_.toc AS toc_7,
  p0_.reading_minutes AS reading_minutes_8,
  p0_.status AS status_9,
  p0_.published_at AS published_at_10,
  p0_.seo_title AS seo_title_11,
  p0_.seo_description AS seo_description_12,
  p0_.created_at AS created_at_13,
  p0_.updated_at AS updated_at_14,
  p0_.group_id AS group_id_15,
  p0_.author_id AS author_id_16
FROM
  post p0_
WHERE
  p0_.status = ?
  AND p0_.published_at <= ?
ORDER BY
  p0_.published_at ASC

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.title AS title_2, p0_.slug AS slug_3, p0_.excerpt AS excerpt_4, p0_.content_html AS content_html_5, p0_.content_text AS content_text_6, p0_.toc AS toc_7, p0_.reading_minutes AS reading_minutes_8, p0_.status AS status_9, p0_.published_at AS published_at_10, p0_.seo_title AS seo_title_11, p0_.seo_description AS seo_description_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.group_id AS group_id_15, p0_.author_id AS author_id_16 FROM post p0_ WHERE p0_.status = 'scheduled' AND p0_.published_at <= '2026-11-04 08:20:28' ORDER BY p0_.published_at ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.slug AS slug_3
FROM
  blog_tag t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.position AS position_2, t0.slug AS slug_3 FROM blog_tag t0 WHERE t0.slug = 'databases' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.tag_id AS tag_id_4
FROM
  blog_tag_translation t0
WHERE
  t0.tag_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.tag_id AS tag_id_4 FROM blog_tag_translation t0 WHERE t0.tag_id = 2;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  post p0_
  INNER JOIN post_group p1_ ON p0_.group_id = p1_.id
WHERE
  p0_.locale = ?
  AND p0_.status = ?
  AND p0_.published_at <= ?
  AND EXISTS (
    SELECT
      1
    FROM
      post_group_tag p2_
    WHERE
      p2_.post_group_id = p1_.id
      AND p2_.blog_tag_id IN (?)
  )

SELECT COUNT(p0_.id) AS sclr_0 FROM post p0_ INNER JOIN post_group p1_ ON p0_.group_id = p1_.id WHERE p0_.locale = 'uk' AND p0_.status = 'published' AND p0_.published_at <= '2026-11-04 08:20:28' AND EXISTS (SELECT 1 FROM post_group_tag p2_ WHERE p2_.post_group_id = p1_.id AND p2_.blog_tag_id IN (2));

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.title AS title_2,
  p0_.slug AS slug_3,
  p0_.excerpt AS excerpt_4,
  p0_.content_html AS content_html_5,
  p0_.content_text AS content_text_6,
  p0_.toc AS toc_7,
  p0_.reading_minutes AS reading_minutes_8,
  p0_.status AS status_9,
  p0_.published_at AS published_at_10,
  p0_.seo_title AS seo_title_11,
  p0_.seo_description AS seo_description_12,
  p0_.created_at AS created_at_13,
  p0_.updated_at AS updated_at_14,
  p1_.id AS id_15,
  p1_.cover_mode AS cover_mode_16,
  p1_.cover_color AS cover_color_17,
  p1_.cover_glyph AS cover_glyph_18,
  p1_.cover_image AS cover_image_19,
  p1_.created_at AS created_at_20,
  p1_.updated_at AS updated_at_21,
  p0_.group_id AS group_id_22,
  p0_.author_id AS author_id_23
FROM
  post p0_
  INNER JOIN post_group p1_ ON p0_.group_id = p1_.id
WHERE
  p0_.locale = ?
  AND p0_.status = ?
  AND p0_.published_at <= ?
  AND EXISTS (
    SELECT
      1
    FROM
      post_group_tag p2_
    WHERE
      p2_.post_group_id = p1_.id
      AND p2_.blog_tag_id IN (?)
  )
ORDER BY
  p0_.published_at DESC,
  p0_.id DESC
LIMIT
  10

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.title AS title_2, p0_.slug AS slug_3, p0_.excerpt AS excerpt_4, p0_.content_html AS content_html_5, p0_.content_text AS content_text_6, p0_.toc AS toc_7, p0_.reading_minutes AS reading_minutes_8, p0_.status AS status_9, p0_.published_at AS published_at_10, p0_.seo_title AS seo_title_11, p0_.seo_description AS seo_description_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p1_.id AS id_15, p1_.cover_mode AS cover_mode_16, p1_.cover_color AS cover_color_17, p1_.cover_glyph AS cover_glyph_18, p1_.cover_image AS cover_image_19, p1_.created_at AS created_at_20, p1_.updated_at AS updated_at_21, p0_.group_id AS group_id_22, p0_.author_id AS author_id_23 FROM post p0_ INNER JOIN post_group p1_ ON p0_.group_id = p1_.id WHERE p0_.locale = 'uk' AND p0_.status = 'published' AND p0_.published_at <= '2026-11-04 08:20:28' AND EXISTS (SELECT 1 FROM post_group_tag p2_ WHERE p2_.post_group_id = p1_.id AND p2_.blog_tag_id IN (2)) ORDER BY p0_.published_at DESC, p0_.id DESC LIMIT 10;

SELECT
  b0_.id AS id_0,
  COUNT(p1_.id) AS sclr_1
FROM
  post p1_
  INNER JOIN post_group p2_ ON p1_.group_id = p2_.id
  INNER JOIN post_group_tag p3_ ON p2_.id = p3_.post_group_id
  INNER JOIN blog_tag b0_ ON b0_.id = p3_.blog_tag_id
WHERE
  p1_.locale = ?
  AND p1_.status = ?
  AND p1_.published_at <= ?
GROUP BY
  b0_.id

SELECT b0_.id AS id_0, COUNT(p1_.id) AS sclr_1 FROM post p1_ INNER JOIN post_group p2_ ON p1_.group_id = p2_.id INNER JOIN post_group_tag p3_ ON p2_.id = p3_.post_group_id INNER JOIN blog_tag b0_ ON b0_.id = p3_.blog_tag_id WHERE p1_.locale = 'uk' AND p1_.status = 'published' AND p1_.published_at <= '2026-11-04 08:20:28' GROUP BY b0_.id;

SELECT
  b0_.id AS id_0,
  b0_.position AS position_1,
  b0_.slug AS slug_2,
  b1_.id AS id_3,
  b1_.locale AS locale_4,
  b1_.name AS name_5,
  b1_.tag_id AS tag_id_6
FROM
  blog_tag b0_
  LEFT JOIN blog_tag_translation b1_ ON b0_.id = b1_.tag_id
ORDER BY
  b0_.position ASC,
  b0_.slug ASC

SELECT b0_.id AS id_0, b0_.position AS position_1, b0_.slug AS slug_2, b1_.id AS id_3, b1_.locale AS locale_4, b1_.name AS name_5, b1_.tag_id AS tag_id_6 FROM blog_tag b0_ LEFT JOIN blog_tag_translation b1_ ON b0_.id = b1_.tag_id ORDER BY b0_.position ASC, b0_.slug ASC;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  post p0_
  INNER JOIN post_group p1_ ON p0_.group_id = p1_.id
WHERE
  p0_.locale = ?
  AND p0_.status = ?
  AND p0_.published_at <= ?

SELECT COUNT(p0_.id) AS sclr_0 FROM post p0_ INNER JOIN post_group p1_ ON p0_.group_id = p1_.id WHERE p0_.locale = 'uk' AND p0_.status = 'published' AND p0_.published_at <= '2026-11-04 08:20:28';

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.slug AS slug_3
FROM
  blog_tag t0
  INNER JOIN post_group_tag ON t0.id = post_group_tag.blog_tag_id
WHERE
  post_group_tag.post_group_id = ?
ORDER BY
  t0.position ASC,
  t0.slug ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.slug AS slug_3 FROM blog_tag t0 INNER JOIN post_group_tag ON t0.id = post_group_tag.blog_tag_id WHERE post_group_tag.post_group_id = 1 ORDER BY t0.position ASC, t0.slug ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.method AS method_4,
  t0.is_active AS is_active_5,
  t0.redirect_url AS redirect_url_6,
  t0.notify_emails AS notify_emails_7,
  t0.allowed_domains AS allowed_domains_8,
  t0.honeypot AS honeypot_9,
  t0.rate_limit AS rate_limit_10,
  t0.min_fill_seconds AS min_fill_seconds_11,
  t0.retention_months AS retention_months_12,
  t0.field_labels AS field_labels_13,
  t0.submission_counter AS submission_counter_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.client_id AS client_id_17
FROM
  form t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.method AS method_4, t0.is_active AS is_active_5, t0.redirect_url AS redirect_url_6, t0.notify_emails AS notify_emails_7, t0.allowed_domains AS allowed_domains_8, t0.honeypot AS honeypot_9, t0.rate_limit AS rate_limit_10, t0.min_fill_seconds AS min_fill_seconds_11, t0.retention_months AS retention_months_12, t0.field_labels AS field_labels_13, t0.submission_counter AS submission_counter_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.client_id AS client_id_17 FROM form t0 WHERE t0.id = 1;

SELECT
  MIN(p0_.published_at) AS sclr_0
FROM
  post p0_
WHERE
  p0_.status = ?

SELECT MIN(p0_.published_at) AS sclr_0 FROM post p0_ WHERE p0_.status = 'scheduled';