Symfony Profiler

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

Query Metrics

SELECT a.id, a.name, a.url FROM blog_authors a

[]

SELECT
  a.id,
  a.name,
  a.url
FROM
  blog_authors a

SELECT a.id, a.name, a.url FROM blog_authors a;

SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.url AS url_4, t0.date AS date_5 FROM site_page_pages t0 WHERE t0.url = ? LIMIT 1

[
  "cookie-policy"
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.text AS text_3,
  t0.url AS url_4,
  t0.date AS date_5
FROM
  site_page_pages t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.url AS url_4, t0.date AS date_5 FROM site_page_pages t0 WHERE t0.url = 'cookie-policy' LIMIT 1;

SELECT a.id, a.name, a.url, a.avatar, a.bio, a.facebook, a.twitter, a.linkedin, a.instagram, a.pinterest, (SELECT COUNT(p.id) FROM blog_posts p WHERE a.id = p.author_id) AS posts_count FROM blog_authors a WHERE a.id = ?

[
  1
]

SELECT
  a.id,
  a.name,
  a.url,
  a.avatar,
  a.bio,
  a.facebook,
  a.twitter,
  a.linkedin,
  a.instagram,
  a.pinterest,
  (
    SELECT
      COUNT(p.id)
    FROM
      blog_posts p
    WHERE
      a.id = p.author_id
  ) AS posts_count
FROM
  blog_authors a
WHERE
  a.id = ?

SELECT a.id, a.name, a.url, a.avatar, a.bio, a.facebook, a.twitter, a.linkedin, a.instagram, a.pinterest, (SELECT COUNT(p.id) FROM blog_posts p WHERE a.id = p.author_id) AS posts_count FROM blog_authors a WHERE a.id = 1;

SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2

[]

SELECT
  `post_id`
FROM
  `published_blog_posts_ids`
WHERE
  `id` = 2

SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2;

SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 1

[]

SELECT
  `post_id`
FROM
  `published_blog_posts_ids`
WHERE
  `id` = 1

SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 1;

SELECT p.url, p.title, p.cover, p.date, c.id AS category_id, c.name AS category_name, a.name AS author_name, a.url AS author_url, (SELECT COUNT(m.id) FROM blog_post_comments m WHERE m.post_id = p.id) AS comments_count FROM blog_posts p INNER JOIN blog_authors a ON p.author_id = a.id INNER JOIN blog_categories c ON p.category_id = c.id WHERE p.id IN(?, ?)

[
  1
  2
]

SELECT
  p.url,
  p.title,
  p.cover,
  p.date,
  c.id AS category_id,
  c.name AS category_name,
  a.name AS author_name,
  a.url AS author_url,
  (
    SELECT
      COUNT(m.id)
    FROM
      blog_post_comments m
    WHERE
      m.post_id = p.id
  ) AS comments_count
FROM
  blog_posts p
  INNER JOIN blog_authors a ON p.author_id = a.id
  INNER JOIN blog_categories c ON p.category_id = c.id
WHERE
  p.id IN(?, ?)

SELECT p.url, p.title, p.cover, p.date, c.id AS category_id, c.name AS category_name, a.name AS author_name, a.url AS author_url, (SELECT COUNT(m.id) FROM blog_post_comments m WHERE m.post_id = p.id) AS comments_count FROM blog_posts p INNER JOIN blog_authors a ON p.author_id = a.id INNER JOIN blog_categories c ON p.category_id = c.id WHERE p.id IN(1, 2);

SELECT COUNT(`id`) FROM `published_blog_posts_ids`

[]

SELECT
  COUNT(`id`)
FROM
  `published_blog_posts_ids`

SELECT COUNT(`id`) FROM `published_blog_posts_ids`;