Symfony Profiler

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

Query Metrics

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 COUNT(*) FROM (SELECT u.id, u.nickname, u.fake, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, c.text, c.reply_to, p.title, p.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.author_id = ?) AND (c.approved = 1)) tmp

[
  16
]

SELECT
  COUNT(*)
FROM
  (
    SELECT
      u.id,
      u.nickname,
      u.fake,
      TRIM(
        CONCAT(u.name_first, ' ', u.name_last)
      ) AS name,
      c.text,
      c.reply_to,
      p.title,
      p.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.author_id = ?)
      AND (c.approved = 1)
  ) tmp

SELECT COUNT(*) FROM (SELECT u.id, u.nickname, u.fake, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, c.text, c.reply_to, p.title, p.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.author_id = 16) AND (c.approved = 1)) tmp;

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 u.id, u.nickname, u.fake, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, c.text, c.reply_to, p.title, p.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.author_id = ?) AND (c.approved = 1) ORDER BY c.date desc LIMIT 10

[
  16
]

SELECT
  u.id,
  u.nickname,
  u.fake,
  TRIM(
    CONCAT(u.name_first, ' ', u.name_last)
  ) AS name,
  c.text,
  c.reply_to,
  p.title,
  p.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.author_id = ?)
  AND (c.approved = 1)
ORDER BY
  c.date desc
LIMIT
  10

SELECT u.id, u.nickname, u.fake, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, c.text, c.reply_to, p.title, p.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.author_id = 16) AND (c.approved = 1) ORDER BY c.date desc LIMIT 10;

SELECT t0.id AS id_1, t0.nickname AS nickname_2, t0.email AS email_3, t0.birth AS birth_4, t0.gender AS gender_5, t0.ethnicity AS ethnicity_6, t0.avatar AS avatar_7, t0.about AS about_8, t0.homepage AS homepage_9, t0.reg_date AS reg_date_10, t0.role AS role_11, t0.status AS status_12, t0.viewed AS viewed_13, t0.fake AS fake_14, t0.photos_dir_num AS photos_dir_num_15, t0.name_first AS name_first_16, t0.name_last AS name_last_17, t0.location_ip AS location_ip_18, t0.location_country AS location_country_19, t0.location_state AS location_state_20, t0.location_city AS location_city_21, t0.location_country_code AS location_country_code_22, t23.id AS id_24, t23.dark_theme AS dark_theme_25, t23.show_social_links_in_profile AS show_social_links_in_profile_26, t23.user_id AS user_id_27 FROM user_users t0 LEFT JOIN user_settings t23 ON t23.user_id = t0.id WHERE t0.nickname = ? LIMIT 1

[
  "funnygerald"
]

SELECT
  t0.id AS id_1,
  t0.nickname AS nickname_2,
  t0.email AS email_3,
  t0.birth AS birth_4,
  t0.gender AS gender_5,
  t0.ethnicity AS ethnicity_6,
  t0.avatar AS avatar_7,
  t0.about AS about_8,
  t0.homepage AS homepage_9,
  t0.reg_date AS reg_date_10,
  t0.role AS role_11,
  t0.status AS status_12,
  t0.viewed AS viewed_13,
  t0.fake AS fake_14,
  t0.photos_dir_num AS photos_dir_num_15,
  t0.name_first AS name_first_16,
  t0.name_last AS name_last_17,
  t0.location_ip AS location_ip_18,
  t0.location_country AS location_country_19,
  t0.location_state AS location_state_20,
  t0.location_city AS location_city_21,
  t0.location_country_code AS location_country_code_22,
  t23.id AS id_24,
  t23.dark_theme AS dark_theme_25,
  t23.show_social_links_in_profile AS show_social_links_in_profile_26,
  t23.user_id AS user_id_27
FROM
  user_users t0
  LEFT JOIN user_settings t23 ON t23.user_id = t0.id
WHERE
  t0.nickname = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nickname AS nickname_2, t0.email AS email_3, t0.birth AS birth_4, t0.gender AS gender_5, t0.ethnicity AS ethnicity_6, t0.avatar AS avatar_7, t0.about AS about_8, t0.homepage AS homepage_9, t0.reg_date AS reg_date_10, t0.role AS role_11, t0.status AS status_12, t0.viewed AS viewed_13, t0.fake AS fake_14, t0.photos_dir_num AS photos_dir_num_15, t0.name_first AS name_first_16, t0.name_last AS name_last_17, t0.location_ip AS location_ip_18, t0.location_country AS location_country_19, t0.location_state AS location_state_20, t0.location_city AS location_city_21, t0.location_country_code AS location_country_code_22, t23.id AS id_24, t23.dark_theme AS dark_theme_25, t23.show_social_links_in_profile AS show_social_links_in_profile_26, t23.user_id AS user_id_27 FROM user_users t0 LEFT JOIN user_settings t23 ON t23.user_id = t0.id WHERE t0.nickname = 'funnygerald' LIMIT 1;

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 t0.id AS id_1, t0.network AS network_2, t0.identity AS identity_3, t0.nickname AS nickname_4, t0.json AS json_5, t0.user_id AS user_id_6 FROM user_networks t0 WHERE t0.user_id = ?

[
  16
]

SELECT
  t0.id AS id_1,
  t0.network AS network_2,
  t0.identity AS identity_3,
  t0.nickname AS nickname_4,
  t0.json AS json_5,
  t0.user_id AS user_id_6
FROM
  user_networks t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.network AS network_2, t0.identity AS identity_3, t0.nickname AS nickname_4, t0.json AS json_5, t0.user_id AS user_id_6 FROM user_networks t0 WHERE t0.user_id = 16;