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 u.id AS user_id, u.nickname AS user_nickname, u.avatar AS user_avatar, u.photos_dir_num AS user_photos_dir_num, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS user_name, u.fake AS user_fake, c.text, c.reply_to, p.title AS post_title, p.url AS post_url FROM blog_post_comments c INNER JOIN user_users u ON c.author_id = u.id INNER JOIN blog_posts p ON c.post_id = p.id WHERE (c.approved = 1) AND (u.name_first <> '') ORDER BY c.id desc LIMIT 9

[]

SELECT
  u.id AS user_id,
  u.nickname AS user_nickname,
  u.avatar AS user_avatar,
  u.photos_dir_num AS user_photos_dir_num,
  TRIM(
    CONCAT(u.name_first, ' ', u.name_last)
  ) AS user_name,
  u.fake AS user_fake,
  c.text,
  c.reply_to,
  p.title AS post_title,
  p.url AS post_url
FROM
  blog_post_comments c
  INNER JOIN user_users u ON c.author_id = u.id
  INNER JOIN blog_posts p ON c.post_id = p.id
WHERE
  (c.approved = 1)
  AND (u.name_first <> '')
ORDER BY
  c.id desc
LIMIT
  9

SELECT u.id AS user_id, u.nickname AS user_nickname, u.avatar AS user_avatar, u.photos_dir_num AS user_photos_dir_num, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS user_name, u.fake AS user_fake, c.text, c.reply_to, p.title AS post_title, p.url AS post_url FROM blog_post_comments c INNER JOIN user_users u ON c.author_id = u.id INNER JOIN blog_posts p ON c.post_id = p.id WHERE (c.approved = 1) AND (u.name_first <> '') ORDER BY c.id desc LIMIT 9;

SELECT AVG(rating) FROM site_testimonials WHERE approved = 1

[]

SELECT
  AVG(rating)
FROM
  site_testimonials
WHERE
  approved = 1

SELECT AVG(rating) FROM site_testimonials WHERE approved = 1;

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 COUNT(`id`) FROM `blog_posts_published_ids`

[]

SELECT
  COUNT(`id`)
FROM
  `blog_posts_published_ids`

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

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 u.id, u.nickname, u.photos_dir_num, u.avatar, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.fake FROM user_users u WHERE u.name_first <> "" ORDER BY id desc LIMIT 10

[]

SELECT
  u.id,
  u.nickname,
  u.photos_dir_num,
  u.avatar,
  TRIM(
    CONCAT(u.name_first, ' ', u.name_last)
  ) AS name,
  u.fake
FROM
  user_users u
WHERE
  u.name_first <> ""
ORDER BY
  id desc
LIMIT
  10

SELECT u.id, u.nickname, u.photos_dir_num, u.avatar, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.fake FROM user_users u WHERE u.name_first <> "" ORDER BY id desc LIMIT 10;

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

[]

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

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

SELECT id FROM site_testimonials WHERE approved = 1

[]

SELECT
  id
FROM
  site_testimonials
WHERE
  approved = 1

SELECT id FROM site_testimonials WHERE approved = 1;

SELECT COUNT(id) FROM site_testimonials WHERE approved = 1

[]

SELECT
  COUNT(id)
FROM
  site_testimonials
WHERE
  approved = 1

SELECT COUNT(id) FROM site_testimonials WHERE approved = 1;

SELECT t.id, t.author_id, t.rating, t.text, t.date, t.approved, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS user_name, u.nickname AS user_nickname, u.avatar AS user_avatar, u.photos_dir_num, u.fake AS user_fake FROM site_testimonials t INNER JOIN user_users u ON t.author_id = u.id WHERE t.id IN(?, ?, ?, ?, ?, ?, ?, ?)

[
  9
  7
  14
  8
  3
  11
  10
  12
]

SELECT
  t.id,
  t.author_id,
  t.rating,
  t.text,
  t.date,
  t.approved,
  TRIM(
    CONCAT(u.name_first, ' ', u.name_last)
  ) AS user_name,
  u.nickname AS user_nickname,
  u.avatar AS user_avatar,
  u.photos_dir_num,
  u.fake AS user_fake
FROM
  site_testimonials t
  INNER JOIN user_users u ON t.author_id = u.id
WHERE
  t.id IN(?, ?, ?, ?, ?, ?, ?, ?)

SELECT t.id, t.author_id, t.rating, t.text, t.date, t.approved, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS user_name, u.nickname AS user_nickname, u.avatar AS user_avatar, u.photos_dir_num, u.fake AS user_fake FROM site_testimonials t INNER JOIN user_users u ON t.author_id = u.id WHERE t.id IN(9, 7, 14, 8, 3, 11, 10, 12);