Symfony Profiler

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.slug AS slug_2,
  b0_.content AS content_3,
  b0_.excerpt AS excerpt_4,
  b0_.featured_image AS featured_image_5,
  b0_.image_alt AS image_alt_6,
  b0_.status AS status_7,
  b0_.published_at AS published_at_8,
  b0_.created_at AS created_at_9,
  b0_.updated_at AS updated_at_10,
  b0_.tags AS tags_11,
  b0_.reading_time AS reading_time_12,
  b0_.view_count AS view_count_13,
  b0_.is_featured AS is_featured_14,
  b0_.allow_comments AS allow_comments_15,
  b0_.seo_title AS seo_title_16,
  b0_.seo_description AS seo_description_17,
  b0_.seo_keywords AS seo_keywords_18,
  b0_.seo_no_index AS seo_no_index_19,
  b0_.seo_no_follow AS seo_no_follow_20,
  b0_.author_id AS author_id_21,
  b0_.category_id AS category_id_22
FROM
  blog_post b0_
  LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id
  LEFT JOIN user u2_ ON b0_.author_id = u2_.id
WHERE
  b0_.slug = ?
  AND b0_.status = ?
  AND b0_.published_at <= ?

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.content AS content_3, b0_.excerpt AS excerpt_4, b0_.featured_image AS featured_image_5, b0_.image_alt AS image_alt_6, b0_.status AS status_7, b0_.published_at AS published_at_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.tags AS tags_11, b0_.reading_time AS reading_time_12, b0_.view_count AS view_count_13, b0_.is_featured AS is_featured_14, b0_.allow_comments AS allow_comments_15, b0_.seo_title AS seo_title_16, b0_.seo_description AS seo_description_17, b0_.seo_keywords AS seo_keywords_18, b0_.seo_no_index AS seo_no_index_19, b0_.seo_no_follow AS seo_no_follow_20, b0_.author_id AS author_id_21, b0_.category_id AS category_id_22 FROM blog_post b0_ LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id LEFT JOIN user u2_ ON b0_.author_id = u2_.id WHERE b0_.slug = 'les-avantages-fiscaux-de-l-investissement-locatif' AND b0_.status = 'published' AND b0_.published_at <= '2025-12-14 13:06:51';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  blog_post
SET
  view_count = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE blog_post SET view_count = 328, updated_at = '2025-12-14 13:06:51' WHERE id = 2;

"COMMIT"

"COMMIT";

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.slug AS slug_2,
  b0_.content AS content_3,
  b0_.excerpt AS excerpt_4,
  b0_.featured_image AS featured_image_5,
  b0_.image_alt AS image_alt_6,
  b0_.status AS status_7,
  b0_.published_at AS published_at_8,
  b0_.created_at AS created_at_9,
  b0_.updated_at AS updated_at_10,
  b0_.tags AS tags_11,
  b0_.reading_time AS reading_time_12,
  b0_.view_count AS view_count_13,
  b0_.is_featured AS is_featured_14,
  b0_.allow_comments AS allow_comments_15,
  b0_.seo_title AS seo_title_16,
  b0_.seo_description AS seo_description_17,
  b0_.seo_keywords AS seo_keywords_18,
  b0_.seo_no_index AS seo_no_index_19,
  b0_.seo_no_follow AS seo_no_follow_20,
  b0_.author_id AS author_id_21,
  b0_.category_id AS category_id_22
FROM
  blog_post b0_
  LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id
  LEFT JOIN user u2_ ON b0_.author_id = u2_.id
WHERE
  b0_.status = ?
  AND b0_.published_at <= ?
  AND b0_.id <> ?
  AND b0_.category_id = ?
ORDER BY
  b0_.published_at DESC
LIMIT
  4

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.content AS content_3, b0_.excerpt AS excerpt_4, b0_.featured_image AS featured_image_5, b0_.image_alt AS image_alt_6, b0_.status AS status_7, b0_.published_at AS published_at_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.tags AS tags_11, b0_.reading_time AS reading_time_12, b0_.view_count AS view_count_13, b0_.is_featured AS is_featured_14, b0_.allow_comments AS allow_comments_15, b0_.seo_title AS seo_title_16, b0_.seo_description AS seo_description_17, b0_.seo_keywords AS seo_keywords_18, b0_.seo_no_index AS seo_no_index_19, b0_.seo_no_follow AS seo_no_follow_20, b0_.author_id AS author_id_21, b0_.category_id AS category_id_22 FROM blog_post b0_ LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id LEFT JOIN user u2_ ON b0_.author_id = u2_.id WHERE b0_.status = 'published' AND b0_.published_at <= '2025-12-14 13:06:51' AND b0_.id <> 2 AND b0_.category_id = 4 ORDER BY b0_.published_at DESC LIMIT 4;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.slug AS slug_2,
  b0_.content AS content_3,
  b0_.excerpt AS excerpt_4,
  b0_.featured_image AS featured_image_5,
  b0_.image_alt AS image_alt_6,
  b0_.status AS status_7,
  b0_.published_at AS published_at_8,
  b0_.created_at AS created_at_9,
  b0_.updated_at AS updated_at_10,
  b0_.tags AS tags_11,
  b0_.reading_time AS reading_time_12,
  b0_.view_count AS view_count_13,
  b0_.is_featured AS is_featured_14,
  b0_.allow_comments AS allow_comments_15,
  b0_.seo_title AS seo_title_16,
  b0_.seo_description AS seo_description_17,
  b0_.seo_keywords AS seo_keywords_18,
  b0_.seo_no_index AS seo_no_index_19,
  b0_.seo_no_follow AS seo_no_follow_20,
  b0_.author_id AS author_id_21,
  b0_.category_id AS category_id_22
FROM
  blog_post b0_
  LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id
  LEFT JOIN user u2_ ON b0_.author_id = u2_.id
WHERE
  b0_.status = ?
  AND b0_.published_at <= ?
ORDER BY
  b0_.published_at DESC
LIMIT
  5

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.content AS content_3, b0_.excerpt AS excerpt_4, b0_.featured_image AS featured_image_5, b0_.image_alt AS image_alt_6, b0_.status AS status_7, b0_.published_at AS published_at_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.tags AS tags_11, b0_.reading_time AS reading_time_12, b0_.view_count AS view_count_13, b0_.is_featured AS is_featured_14, b0_.allow_comments AS allow_comments_15, b0_.seo_title AS seo_title_16, b0_.seo_description AS seo_description_17, b0_.seo_keywords AS seo_keywords_18, b0_.seo_no_index AS seo_no_index_19, b0_.seo_no_follow AS seo_no_follow_20, b0_.author_id AS author_id_21, b0_.category_id AS category_id_22 FROM blog_post b0_ LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id LEFT JOIN user u2_ ON b0_.author_id = u2_.id WHERE b0_.status = 'published' AND b0_.published_at <= '2025-12-14 13:06:51' ORDER BY b0_.published_at DESC LIMIT 5;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.slug AS slug_2,
  b0_.description AS description_3,
  b0_.color AS color_4,
  b0_.icon AS icon_5,
  b0_.image AS image_6,
  b0_.is_active AS is_active_7,
  b0_.sort_order AS sort_order_8,
  b0_.created_at AS created_at_9,
  b0_.updated_at AS updated_at_10,
  b0_.seo_title AS seo_title_11,
  b0_.seo_description AS seo_description_12,
  b0_.seo_keywords AS seo_keywords_13,
  COUNT(b1_.id) AS sclr_14
FROM
  blog_category b0_
  LEFT JOIN blog_post b1_ ON b0_.id = b1_.category_id
  LEFT JOIN user u2_ ON b1_.author_id = u2_.id
WHERE
  b0_.is_active = ?
  AND (
    b1_.status = ?
    OR b1_.status IS NULL
  )
  AND (
    b1_.published_at <= ?
    OR b1_.published_at IS NULL
  )
GROUP BY
  b0_.id
ORDER BY
  b0_.sort_order ASC,
  b0_.name ASC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.color AS color_4, b0_.icon AS icon_5, b0_.image AS image_6, b0_.is_active AS is_active_7, b0_.sort_order AS sort_order_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.seo_title AS seo_title_11, b0_.seo_description AS seo_description_12, b0_.seo_keywords AS seo_keywords_13, COUNT(b1_.id) AS sclr_14 FROM blog_category b0_ LEFT JOIN blog_post b1_ ON b0_.id = b1_.category_id LEFT JOIN user u2_ ON b1_.author_id = u2_.id WHERE b0_.is_active = 1 AND (b1_.status = 'published' OR b1_.status IS NULL) AND (b1_.published_at <= '2025-12-14 13:06:51' OR b1_.published_at IS NULL) GROUP BY b0_.id ORDER BY b0_.sort_order ASC, b0_.name ASC;

SELECT
  b0_.tags AS tags_0
FROM
  blog_post b0_
WHERE
  b0_.status = ?
  AND b0_.published_at <= ?

SELECT b0_.tags AS tags_0 FROM blog_post b0_ WHERE b0_.status = 'published' AND b0_.published_at <= '2025-12-14 13:06:51';

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.is_active AS is_active_9,
  t0.last_login_at AS last_login_at_10
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.roles AS roles_5, t0.password AS password_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.last_login_at AS last_login_at_10 FROM user t0 WHERE t0.id = 1;