Symfony Profiler

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

Query Metrics

SELECT COUNT(*) FROM (SELECT p.id, p.title, p.cover, p.text, p.url, p.published, p.date, c.id AS category_id, c.name AS category_name, a.url AS author_url, a.name AS author_name, a.avatar AS author_avatar, (SELECT COUNT(m.id) FROM blog_post_comments m WHERE m.post_id = p.id AND m.approved = 1) AS comments_count, (SELECT COUNT(i.id) FROM blog_post_images i WHERE i.post_id = p.id) AS images_count FROM blog_posts p INNER JOIN blog_categories c ON p.category_id = c.id INNER JOIN blog_authors a ON p.author_id = a.id WHERE p.published = ?) tmp

[
  1
]

SELECT
  COUNT(*)
FROM
  (
    SELECT
      p.id,
      p.title,
      p.cover,
      p.text,
      p.url,
      p.published,
      p.date,
      c.id AS category_id,
      c.name AS category_name,
      a.url AS author_url,
      a.name AS author_name,
      a.avatar AS author_avatar,
      (
        SELECT
          COUNT(m.id)
        FROM
          blog_post_comments m
        WHERE
          m.post_id = p.id
          AND m.approved = 1
      ) AS comments_count,
      (
        SELECT
          COUNT(i.id)
        FROM
          blog_post_images i
        WHERE
          i.post_id = p.id
      ) AS images_count
    FROM
      blog_posts p
      INNER JOIN blog_categories c ON p.category_id = c.id
      INNER JOIN blog_authors a ON p.author_id = a.id
    WHERE
      p.published = ?
  ) tmp

SELECT COUNT(*) FROM (SELECT p.id, p.title, p.cover, p.text, p.url, p.published, p.date, c.id AS category_id, c.name AS category_name, a.url AS author_url, a.name AS author_name, a.avatar AS author_avatar, (SELECT COUNT(m.id) FROM blog_post_comments m WHERE m.post_id = p.id AND m.approved = 1) AS comments_count, (SELECT COUNT(i.id) FROM blog_post_images i WHERE i.post_id = p.id) AS images_count FROM blog_posts p INNER JOIN blog_categories c ON p.category_id = c.id INNER JOIN blog_authors a ON p.author_id = a.id WHERE p.published = 1) tmp;

SELECT p.id, p.title, p.cover, p.text, p.url, p.published, p.date, c.id AS category_id, c.name AS category_name, a.url AS author_url, a.name AS author_name, a.avatar AS author_avatar, (SELECT COUNT(m.id) FROM blog_post_comments m WHERE m.post_id = p.id AND m.approved = 1) AS comments_count, (SELECT COUNT(i.id) FROM blog_post_images i WHERE i.post_id = p.id) AS images_count FROM blog_posts p INNER JOIN blog_categories c ON p.category_id = c.id INNER JOIN blog_authors a ON p.author_id = a.id WHERE p.published = ? ORDER BY p.priority, date desc LIMIT 10

[
  1
]

SELECT
  p.id,
  p.title,
  p.cover,
  p.text,
  p.url,
  p.published,
  p.date,
  c.id AS category_id,
  c.name AS category_name,
  a.url AS author_url,
  a.name AS author_name,
  a.avatar AS author_avatar,
  (
    SELECT
      COUNT(m.id)
    FROM
      blog_post_comments m
    WHERE
      m.post_id = p.id
      AND m.approved = 1
  ) AS comments_count,
  (
    SELECT
      COUNT(i.id)
    FROM
      blog_post_images i
    WHERE
      i.post_id = p.id
  ) AS images_count
FROM
  blog_posts p
  INNER JOIN blog_categories c ON p.category_id = c.id
  INNER JOIN blog_authors a ON p.author_id = a.id
WHERE
  p.published = ?
ORDER BY
  p.priority,
  date desc
LIMIT
  10

SELECT p.id, p.title, p.cover, p.text, p.url, p.published, p.date, c.id AS category_id, c.name AS category_name, a.url AS author_url, a.name AS author_name, a.avatar AS author_avatar, (SELECT COUNT(m.id) FROM blog_post_comments m WHERE m.post_id = p.id AND m.approved = 1) AS comments_count, (SELECT COUNT(i.id) FROM blog_post_images i WHERE i.post_id = p.id) AS images_count FROM blog_posts p INNER JOIN blog_categories c ON p.category_id = c.id INNER JOIN blog_authors a ON p.author_id = a.id WHERE p.published = 1 ORDER BY p.priority, date desc LIMIT 10;

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 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 id, name FROM blog_categories

[]

SELECT
  id,
  name
FROM
  blog_categories

SELECT id, name FROM blog_categories;

SELECT COUNT(`id`) FROM `blog_posts_published_ids`

[]

SELECT
  COUNT(`id`)
FROM
  `blog_posts_published_ids`

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

SELECT id FROM blog_posts WHERE (published = 1) AND (priority = 1) ORDER BY RAND() ASC LIMIT 7

[]

SELECT
  id
FROM
  blog_posts
WHERE
  (published = 1)
  AND (priority = 1)
ORDER BY
  RAND() ASC
LIMIT
  7

SELECT id FROM blog_posts WHERE (published = 1) AND (priority = 1) ORDER BY RAND() ASC LIMIT 7;

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 AND m.approved = 1) 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(NULL)

[]

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
      AND m.approved = 1
  ) 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(NULL)

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 AND m.approved = 1) 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(NULL);

SELECT id, name FROM blog_tag_names ORDER BY RAND() ASC LIMIT 14

[]

SELECT
  id,
  name
FROM
  blog_tag_names
ORDER BY
  RAND() ASC
LIMIT
  14

SELECT id, name FROM blog_tag_names ORDER BY RAND() ASC LIMIT 14;

SELECT COUNT(`id`) FROM `blog_posts_published_ids`

[]

SELECT
  COUNT(`id`)
FROM
  `blog_posts_published_ids`

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

SELECT id FROM blog_posts WHERE (published = 1) AND (priority = 1) ORDER BY RAND() ASC LIMIT 2

[]

SELECT
  id
FROM
  blog_posts
WHERE
  (published = 1)
  AND (priority = 1)
ORDER BY
  RAND() ASC
LIMIT
  2

SELECT id FROM blog_posts WHERE (published = 1) AND (priority = 1) ORDER BY RAND() ASC LIMIT 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 AND m.approved = 1) 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(NULL)

[]

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
      AND m.approved = 1
  ) 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(NULL)

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 AND m.approved = 1) 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(NULL);