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 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 COUNT(*) FROM (SELECT u.id, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.email, u.avatar, u.reg_date, u.role, u.status, u.fake, u.photos_dir_num, u.location_ip, u.location_country, u.location_state, u.location_city, u.location_country_code, s.show_social_links_in_profile, (SELECT COUNT(c.id) FROM blog_post_comments c WHERE u.id = c.author_id) AS blog_comments_count FROM user_users u INNER JOIN user_settings s ON u.id = s.user_id) tmp

[]

SELECT
  COUNT(*)
FROM
  (
    SELECT
      u.id,
      TRIM(
        CONCAT(u.name_first, ' ', u.name_last)
      ) AS name,
      u.nickname,
      u.email,
      u.avatar,
      u.reg_date,
      u.role,
      u.status,
      u.fake,
      u.photos_dir_num,
      u.location_ip,
      u.location_country,
      u.location_state,
      u.location_city,
      u.location_country_code,
      s.show_social_links_in_profile,
      (
        SELECT
          COUNT(c.id)
        FROM
          blog_post_comments c
        WHERE
          u.id = c.author_id
      ) AS blog_comments_count
    FROM
      user_users u
      INNER JOIN user_settings s ON u.id = s.user_id
  ) tmp

SELECT COUNT(*) FROM (SELECT u.id, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.email, u.avatar, u.reg_date, u.role, u.status, u.fake, u.photos_dir_num, u.location_ip, u.location_country, u.location_state, u.location_city, u.location_country_code, s.show_social_links_in_profile, (SELECT COUNT(c.id) FROM blog_post_comments c WHERE u.id = c.author_id) AS blog_comments_count FROM user_users u INNER JOIN user_settings s ON u.id = s.user_id) tmp;

SELECT u.id, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.email, u.avatar, u.reg_date, u.role, u.status, u.fake, u.photos_dir_num, u.location_ip, u.location_country, u.location_state, u.location_city, u.location_country_code, s.show_social_links_in_profile, (SELECT COUNT(c.id) FROM blog_post_comments c WHERE u.id = c.author_id) AS blog_comments_count FROM user_users u INNER JOIN user_settings s ON u.id = s.user_id ORDER BY id desc LIMIT 9

[]

SELECT
  u.id,
  TRIM(
    CONCAT(u.name_first, ' ', u.name_last)
  ) AS name,
  u.nickname,
  u.email,
  u.avatar,
  u.reg_date,
  u.role,
  u.status,
  u.fake,
  u.photos_dir_num,
  u.location_ip,
  u.location_country,
  u.location_state,
  u.location_city,
  u.location_country_code,
  s.show_social_links_in_profile,
  (
    SELECT
      COUNT(c.id)
    FROM
      blog_post_comments c
    WHERE
      u.id = c.author_id
  ) AS blog_comments_count
FROM
  user_users u
  INNER JOIN user_settings s ON u.id = s.user_id
ORDER BY
  id desc
LIMIT
  9

SELECT u.id, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.email, u.avatar, u.reg_date, u.role, u.status, u.fake, u.photos_dir_num, u.location_ip, u.location_country, u.location_state, u.location_city, u.location_country_code, s.show_social_links_in_profile, (SELECT COUNT(c.id) FROM blog_post_comments c WHERE u.id = c.author_id) AS blog_comments_count FROM user_users u INNER JOIN user_settings s ON u.id = s.user_id ORDER BY id desc LIMIT 9;

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 21

[]

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

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

SELECT user_id, network, identity, nickname FROM user_networks WHERE user_id IN(?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  87
  82
  79
  78
  77
  75
  73
  71
  65
]

SELECT
  user_id,
  network,
  identity,
  nickname
FROM
  user_networks
WHERE
  user_id IN(?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT user_id, network, identity, nickname FROM user_networks WHERE user_id IN(87, 82, 79, 78, 77, 75, 73, 71, 65);