Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 8
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Configuration

Query Metrics

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.excerpt AS excerpt_3, b0_.content AS content_4, b0_.image_path AS image_path_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_.meta_title AS meta_title_11, b0_.meta_description AS meta_description_12, b0_.read_time AS read_time_13, b0_.view_count AS view_count_14, b1_.id AS id_15, b1_.name AS name_16, b1_.slug AS slug_17, b1_.position AS position_18, u2_.id AS id_19, u2_.email AS email_20, u2_.roles AS roles_21, u2_.password AS password_22, u2_.first_name AS first_name_23, u2_.last_name AS last_name_24, u2_.is_active AS is_active_25, u2_.created_at AS created_at_26, b0_.category_id AS category_id_27, b0_.author_id AS author_id_28 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 = ? ORDER BY b0_.published_at DESC LIMIT 9

[
  "published"
]

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.slug AS slug_2,
  b0_.excerpt AS excerpt_3,
  b0_.content AS content_4,
  b0_.image_path AS image_path_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_.meta_title AS meta_title_11,
  b0_.meta_description AS meta_description_12,
  b0_.read_time AS read_time_13,
  b0_.view_count AS view_count_14,
  b1_.id AS id_15,
  b1_.name AS name_16,
  b1_.slug AS slug_17,
  b1_.position AS position_18,
  u2_.id AS id_19,
  u2_.email AS email_20,
  u2_.roles AS roles_21,
  u2_.password AS password_22,
  u2_.first_name AS first_name_23,
  u2_.last_name AS last_name_24,
  u2_.is_active AS is_active_25,
  u2_.created_at AS created_at_26,
  b0_.category_id AS category_id_27,
  b0_.author_id AS author_id_28
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 = ?
ORDER BY
  b0_.published_at DESC
LIMIT
  9

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.excerpt AS excerpt_3, b0_.content AS content_4, b0_.image_path AS image_path_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_.meta_title AS meta_title_11, b0_.meta_description AS meta_description_12, b0_.read_time AS read_time_13, b0_.view_count AS view_count_14, b1_.id AS id_15, b1_.name AS name_16, b1_.slug AS slug_17, b1_.position AS position_18, u2_.id AS id_19, u2_.email AS email_20, u2_.roles AS roles_21, u2_.password AS password_22, u2_.first_name AS first_name_23, u2_.last_name AS last_name_24, u2_.is_active AS is_active_25, u2_.created_at AS created_at_26, b0_.category_id AS category_id_27, b0_.author_id AS author_id_28 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' ORDER BY b0_.published_at DESC LIMIT 9;

SELECT COUNT(b0_.id) AS sclr_0 FROM blog_post b0_ WHERE b0_.status = ?

[
  "published"
]

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  blog_post b0_
WHERE
  b0_.status = ?

SELECT COUNT(b0_.id) AS sclr_0 FROM blog_post b0_ WHERE b0_.status = 'published';

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4 FROM blog_category t0 ORDER BY t0.position ASC

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.position AS position_4
FROM
  blog_category t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4 FROM blog_category t0 ORDER BY t0.position ASC;