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 02:02:06' 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_
  INNER JOIN post_group p1_ ON p0_.group_id = p1_.id
WHERE
  p0_.locale = ?
  AND p0_.status = ?
  AND p0_.published_at <= ?
  AND p0_.slug = ?

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_ INNER JOIN post_group p1_ ON p0_.group_id = p1_.id WHERE p0_.locale = 'en' AND p0_.status = 'published' AND p0_.published_at <= '2026-11-04 02:02:06' AND p0_.slug = 'content-translations';

SELECT
  t0.id AS id_1,
  t0.cover_mode AS cover_mode_2,
  t0.cover_color AS cover_color_3,
  t0.cover_glyph AS cover_glyph_4,
  t0.cover_image AS cover_image_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  post_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cover_mode AS cover_mode_2, t0.cover_color AS cover_color_3, t0.cover_glyph AS cover_glyph_4, t0.cover_image AS cover_image_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM post_group t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.title AS title_3,
  t0.slug AS slug_4,
  t0.excerpt AS excerpt_5,
  t0.content_html AS content_html_6,
  t0.content_text AS content_text_7,
  t0.toc AS toc_8,
  t0.reading_minutes AS reading_minutes_9,
  t0.status AS status_10,
  t0.published_at AS published_at_11,
  t0.seo_title AS seo_title_12,
  t0.seo_description AS seo_description_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.group_id AS group_id_16,
  t0.author_id AS author_id_17
FROM
  post t0
WHERE
  t0.group_id = ?
ORDER BY
  t0.locale DESC

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.slug AS slug_4, t0.excerpt AS excerpt_5, t0.content_html AS content_html_6, t0.content_text AS content_text_7, t0.toc AS toc_8, t0.reading_minutes AS reading_minutes_9, t0.status AS status_10, t0.published_at AS published_at_11, t0.seo_title AS seo_title_12, t0.seo_description AS seo_description_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.group_id AS group_id_16, t0.author_id AS author_id_17 FROM post t0 WHERE t0.group_id = 1 ORDER BY t0.locale DESC;

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
  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,
  COUNT(b1_.id) AS sclr_15,
  p0_.group_id AS group_id_16,
  p0_.author_id AS author_id_17
FROM
  post p0_
  INNER JOIN post_group p2_ ON p0_.group_id = p2_.id
  INNER JOIN post_group_tag p3_ ON p2_.id = p3_.post_group_id
  INNER JOIN blog_tag b1_ ON b1_.id = p3_.blog_tag_id
WHERE
  p0_.locale = ?
  AND p0_.status = ?
  AND p0_.published_at <= ?
  AND b1_.id IN (?, ?)
  AND p0_.id <> ?
GROUP BY
  p0_.id
ORDER BY
  sclr_15 DESC,
  p0_.published_at DESC
LIMIT
  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, COUNT(b1_.id) AS sclr_15, p0_.group_id AS group_id_16, p0_.author_id AS author_id_17 FROM post p0_ INNER JOIN post_group p2_ ON p0_.group_id = p2_.id INNER JOIN post_group_tag p3_ ON p2_.id = p3_.post_group_id INNER JOIN blog_tag b1_ ON b1_.id = p3_.blog_tag_id WHERE p0_.locale = 'en' AND p0_.status = 'published' AND p0_.published_at <= '2026-11-04 02:02:06' AND b1_.id IN (1, 2) AND p0_.id <> 2 GROUP BY p0_.id ORDER BY sclr_15 DESC, p0_.published_at DESC LIMIT 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,
  p0_.group_id AS group_id_15,
  p0_.author_id AS author_id_16
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 p0_.id NOT IN (?)
ORDER BY
  p0_.published_at DESC,
  p0_.id DESC
LIMIT
  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, p0_.group_id AS group_id_15, p0_.author_id AS author_id_16 FROM post p0_ INNER JOIN post_group p1_ ON p0_.group_id = p1_.id WHERE p0_.locale = 'en' AND p0_.status = 'published' AND p0_.published_at <= '2026-11-04 02:02:06' AND p0_.id NOT IN (2) ORDER BY p0_.published_at DESC, p0_.id DESC LIMIT 2;

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 = 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
  t0.id AS id_1,
  t0.position AS position_2,
  t0.bio AS bio_3,
  t0.locale AS locale_4,
  t0.user_id AS user_id_5
FROM
  user_profile t0
WHERE
  t0.user_id = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.position AS position_2, t0.bio AS bio_3, t0.locale AS locale_4, t0.user_id AS user_id_5 FROM user_profile t0 WHERE t0.user_id = 1 AND t0.locale = 'en' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.bio AS bio_3,
  t0.locale AS locale_4,
  t0.user_id AS user_id_5
FROM
  user_profile t0
WHERE
  t0.user_id = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.position AS position_2, t0.bio AS bio_3, t0.locale AS locale_4, t0.user_id AS user_id_5 FROM user_profile t0 WHERE t0.user_id = 1 AND t0.locale = 'uk' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.password AS password_4,
  t0.is_active AS is_active_5,
  t0.must_change_password AS must_change_password_6,
  t0.admin_locale AS admin_locale_7,
  t0.security_stamp AS security_stamp_8,
  t0.last_login_at AS last_login_at_9,
  t0.password_changed_at AS password_changed_at_10,
  t0.avatar AS avatar_11,
  t0.created_at AS created_at_12,
  t0.role_id AS role_id_13
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.must_change_password AS must_change_password_6, t0.admin_locale AS admin_locale_7, t0.security_stamp AS security_stamp_8, t0.last_login_at AS last_login_at_9, t0.password_changed_at AS password_changed_at_10, t0.avatar AS avatar_11, t0.created_at AS created_at_12, t0.role_id AS role_id_13 FROM "user" t0 WHERE t0.id = 1;

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