Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 182
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• JMS Serializer 0
• Configuration

Query Metrics

SELECT b0_.id AS id_0, b0_.updated_date AS updated_date_1, b0_.publish_date AS publish_date_2, b0_.last_updated_operation AS last_updated_operation_3, b0_.last_updated_ip AS last_updated_ip_4, b0_.en_title AS en_title_5, b0_.fr_title AS fr_title_6, b0_.en_content AS en_content_7, b0_.fr_content AS fr_content_8, b0_.active AS active_9, b0_.deleted_ip_address AS deleted_ip_address_10, b0_.deleted_date AS deleted_date_11, CONCAT(u1_.first_name, ' ', u1_.last_name) AS sclr_12, b0_.parent_object_id AS parent_object_id_13, b0_.last_updated_user_id AS last_updated_user_id_14, b0_.deleted_by_user_id AS deleted_by_user_id_15 FROM blogposts b0_ LEFT JOIN users u1_ ON b0_.last_updated_user_id = u1_.id WHERE b0_.active = ? AND b0_.publish_date <= ? AND b0_.parent_object_id IS NULL AND b0_.deleted_date IS NULL ORDER BY b0_.publish_date DESC LIMIT 20

[
  1
  "2025-12-10 02:52:55"
]

SELECT
  b0_.id AS id_0,
  b0_.updated_date AS updated_date_1,
  b0_.publish_date AS publish_date_2,
  b0_.last_updated_operation AS last_updated_operation_3,
  b0_.last_updated_ip AS last_updated_ip_4,
  b0_.en_title AS en_title_5,
  b0_.fr_title AS fr_title_6,
  b0_.en_content AS en_content_7,
  b0_.fr_content AS fr_content_8,
  b0_.active AS active_9,
  b0_.deleted_ip_address AS deleted_ip_address_10,
  b0_.deleted_date AS deleted_date_11,
  CONCAT(
    u1_.first_name, ' ', u1_.last_name
  ) AS sclr_12,
  b0_.parent_object_id AS parent_object_id_13,
  b0_.last_updated_user_id AS last_updated_user_id_14,
  b0_.deleted_by_user_id AS deleted_by_user_id_15
FROM
  blogposts b0_
  LEFT JOIN users u1_ ON b0_.last_updated_user_id = u1_.id
WHERE
  b0_.active = ?
  AND b0_.publish_date <= ?
  AND b0_.parent_object_id IS NULL
  AND b0_.deleted_date IS NULL
ORDER BY
  b0_.publish_date DESC
LIMIT
  20

SELECT b0_.id AS id_0, b0_.updated_date AS updated_date_1, b0_.publish_date AS publish_date_2, b0_.last_updated_operation AS last_updated_operation_3, b0_.last_updated_ip AS last_updated_ip_4, b0_.en_title AS en_title_5, b0_.fr_title AS fr_title_6, b0_.en_content AS en_content_7, b0_.fr_content AS fr_content_8, b0_.active AS active_9, b0_.deleted_ip_address AS deleted_ip_address_10, b0_.deleted_date AS deleted_date_11, CONCAT(u1_.first_name, ' ', u1_.last_name) AS sclr_12, b0_.parent_object_id AS parent_object_id_13, b0_.last_updated_user_id AS last_updated_user_id_14, b0_.deleted_by_user_id AS deleted_by_user_id_15 FROM blogposts b0_ LEFT JOIN users u1_ ON b0_.last_updated_user_id = u1_.id WHERE b0_.active = 1 AND b0_.publish_date <= '2025-12-10 02:52:55' AND b0_.parent_object_id IS NULL AND b0_.deleted_date IS NULL ORDER BY b0_.publish_date DESC LIMIT 20;

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.updated_date AS updated_date_1, b0_.publish_date AS publish_date_2, b0_.last_updated_operation AS last_updated_operation_3, b0_.last_updated_ip AS last_updated_ip_4, b0_.en_title AS en_title_5, b0_.fr_title AS fr_title_6, b0_.en_content AS en_content_7, b0_.fr_content AS fr_content_8, b0_.active AS active_9, b0_.deleted_ip_address AS deleted_ip_address_10, b0_.deleted_date AS deleted_date_11, CONCAT(u1_.first_name, ' ', u1_.last_name) AS sclr_12 FROM blogposts b0_ LEFT JOIN users u1_ ON b0_.last_updated_user_id = u1_.id WHERE b0_.active = ? AND b0_.publish_date <= ? AND b0_.parent_object_id IS NULL AND b0_.deleted_date IS NULL ORDER BY b0_.publish_date DESC) dctrn_result) dctrn_table

[
  1
  "2025-12-10 02:52:55"
]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.updated_date AS updated_date_1,
          b0_.publish_date AS publish_date_2,
          b0_.last_updated_operation AS last_updated_operation_3,
          b0_.last_updated_ip AS last_updated_ip_4,
          b0_.en_title AS en_title_5,
          b0_.fr_title AS fr_title_6,
          b0_.en_content AS en_content_7,
          b0_.fr_content AS fr_content_8,
          b0_.active AS active_9,
          b0_.deleted_ip_address AS deleted_ip_address_10,
          b0_.deleted_date AS deleted_date_11,
          CONCAT(
            u1_.first_name, ' ', u1_.last_name
          ) AS sclr_12
        FROM
          blogposts b0_
          LEFT JOIN users u1_ ON b0_.last_updated_user_id = u1_.id
        WHERE
          b0_.active = ?
          AND b0_.publish_date <= ?
          AND b0_.parent_object_id IS NULL
          AND b0_.deleted_date IS NULL
        ORDER BY
          b0_.publish_date DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.updated_date AS updated_date_1, b0_.publish_date AS publish_date_2, b0_.last_updated_operation AS last_updated_operation_3, b0_.last_updated_ip AS last_updated_ip_4, b0_.en_title AS en_title_5, b0_.fr_title AS fr_title_6, b0_.en_content AS en_content_7, b0_.fr_content AS fr_content_8, b0_.active AS active_9, b0_.deleted_ip_address AS deleted_ip_address_10, b0_.deleted_date AS deleted_date_11, CONCAT(u1_.first_name, ' ', u1_.last_name) AS sclr_12 FROM blogposts b0_ LEFT JOIN users u1_ ON b0_.last_updated_user_id = u1_.id WHERE b0_.active = 1 AND b0_.publish_date <= '2025-12-10 02:52:55' AND b0_.parent_object_id IS NULL AND b0_.deleted_date IS NULL ORDER BY b0_.publish_date DESC) dctrn_result) dctrn_table;