Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.tagline AS tagline_4, t0.description AS description_5, t0.color_primary AS color_primary_6, t0.color_header_start AS color_header_start_7, t0.color_header_end AS color_header_end_8, t0.logo AS logo_9, t0.position AS position_10, t0.is_active AS is_active_11 FROM project t0 WHERE t0.slug = ? LIMIT 1

[
  "ssh"
]

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.tagline AS tagline_4,
  t0.description AS description_5,
  t0.color_primary AS color_primary_6,
  t0.color_header_start AS color_header_start_7,
  t0.color_header_end AS color_header_end_8,
  t0.logo AS logo_9,
  t0.position AS position_10,
  t0.is_active AS is_active_11
FROM
  project t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.tagline AS tagline_4, t0.description AS description_5, t0.color_primary AS color_primary_6, t0.color_header_start AS color_header_start_7, t0.color_header_end AS color_header_end_8, t0.logo AS logo_9, t0.position AS position_10, t0.is_active AS is_active_11 FROM project t0 WHERE t0.slug = 'ssh' LIMIT 1;

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.content AS content_2, n0_.is_public AS is_public_3, n0_.created_at AS created_at_4, n0_.updated_at AS updated_at_5, u1_.id AS id_6, u1_.email AS email_7, u1_.roles AS roles_8, u1_.password AS password_9, u1_.name AS name_10, u1_.invite_token AS invite_token_11 FROM note n0_ LEFT JOIN `user` u1_ ON n0_.author_id = u1_.id WHERE n0_.is_public = 1 AND n0_.project_id = ? ORDER BY n0_.updated_at DESC) dctrn_result) dctrn_table

[
  3
]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          n0_.id AS id_0,
          n0_.title AS title_1,
          n0_.content AS content_2,
          n0_.is_public AS is_public_3,
          n0_.created_at AS created_at_4,
          n0_.updated_at AS updated_at_5,
          u1_.id AS id_6,
          u1_.email AS email_7,
          u1_.roles AS roles_8,
          u1_.password AS password_9,
          u1_.name AS name_10,
          u1_.invite_token AS invite_token_11
        FROM
          note n0_
          LEFT JOIN `user` u1_ ON n0_.author_id = u1_.id
        WHERE
          n0_.is_public = 1
          AND n0_.project_id = ?
        ORDER BY
          n0_.updated_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.content AS content_2, n0_.is_public AS is_public_3, n0_.created_at AS created_at_4, n0_.updated_at AS updated_at_5, u1_.id AS id_6, u1_.email AS email_7, u1_.roles AS roles_8, u1_.password AS password_9, u1_.name AS name_10, u1_.invite_token AS invite_token_11 FROM note n0_ LEFT JOIN `user` u1_ ON n0_.author_id = u1_.id WHERE n0_.is_public = 1 AND n0_.project_id = 3 ORDER BY n0_.updated_at DESC) dctrn_result) dctrn_table;

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.label ASC

[
  3
]

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.label AS label_3,
  t0.focus AS focus_4,
  t0.keywords AS keywords_5,
  t0.position AS position_6,
  t0.last_imported_at AS last_imported_at_7,
  t0.project_id AS project_id_8
FROM
  category t0
WHERE
  t0.project_id = ?
ORDER BY
  t0.position ASC,
  t0.label ASC

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 WHERE t0.project_id = 3 ORDER BY t0.position ASC, t0.label ASC;

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, updated_at_5 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.content AS content_2, n0_.is_public AS is_public_3, n0_.created_at AS created_at_4, n0_.updated_at AS updated_at_5, u1_.id AS id_6, u1_.email AS email_7, u1_.roles AS roles_8, u1_.password AS password_9, u1_.name AS name_10, u1_.invite_token AS invite_token_11 FROM note n0_ LEFT JOIN `user` u1_ ON n0_.author_id = u1_.id WHERE n0_.is_public = 1 AND n0_.project_id = ?) dctrn_result_inner ORDER BY updated_at_5 DESC) dctrn_result LIMIT 15

[
  3
]

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      updated_at_5
    FROM
      (
        SELECT
          n0_.id AS id_0,
          n0_.title AS title_1,
          n0_.content AS content_2,
          n0_.is_public AS is_public_3,
          n0_.created_at AS created_at_4,
          n0_.updated_at AS updated_at_5,
          u1_.id AS id_6,
          u1_.email AS email_7,
          u1_.roles AS roles_8,
          u1_.password AS password_9,
          u1_.name AS name_10,
          u1_.invite_token AS invite_token_11
        FROM
          note n0_
          LEFT JOIN `user` u1_ ON n0_.author_id = u1_.id
        WHERE
          n0_.is_public = 1
          AND n0_.project_id = ?
      ) dctrn_result_inner
    ORDER BY
      updated_at_5 DESC
  ) dctrn_result
LIMIT
  15

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, updated_at_5 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.content AS content_2, n0_.is_public AS is_public_3, n0_.created_at AS created_at_4, n0_.updated_at AS updated_at_5, u1_.id AS id_6, u1_.email AS email_7, u1_.roles AS roles_8, u1_.password AS password_9, u1_.name AS name_10, u1_.invite_token AS invite_token_11 FROM note n0_ LEFT JOIN `user` u1_ ON n0_.author_id = u1_.id WHERE n0_.is_public = 1 AND n0_.project_id = 3) dctrn_result_inner ORDER BY updated_at_5 DESC) dctrn_result LIMIT 15;

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.content AS content_2, n0_.is_public AS is_public_3, n0_.created_at AS created_at_4, n0_.updated_at AS updated_at_5, u1_.id AS id_6, u1_.email AS email_7, u1_.roles AS roles_8, u1_.password AS password_9, u1_.name AS name_10, u1_.invite_token AS invite_token_11, n0_.project_id AS project_id_12, n0_.author_id AS author_id_13 FROM note n0_ LEFT JOIN `user` u1_ ON n0_.author_id = u1_.id WHERE n0_.is_public = 1 AND n0_.project_id = ? AND n0_.id IN (?, ?, ?) ORDER BY n0_.updated_at DESC

[
  3
  3
  4
  5
]

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.content AS content_2,
  n0_.is_public AS is_public_3,
  n0_.created_at AS created_at_4,
  n0_.updated_at AS updated_at_5,
  u1_.id AS id_6,
  u1_.email AS email_7,
  u1_.roles AS roles_8,
  u1_.password AS password_9,
  u1_.name AS name_10,
  u1_.invite_token AS invite_token_11,
  n0_.project_id AS project_id_12,
  n0_.author_id AS author_id_13
FROM
  note n0_
  LEFT JOIN `user` u1_ ON n0_.author_id = u1_.id
WHERE
  n0_.is_public = 1
  AND n0_.project_id = ?
  AND n0_.id IN (?, ?, ?)
ORDER BY
  n0_.updated_at DESC

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.content AS content_2, n0_.is_public AS is_public_3, n0_.created_at AS created_at_4, n0_.updated_at AS updated_at_5, u1_.id AS id_6, u1_.email AS email_7, u1_.roles AS roles_8, u1_.password AS password_9, u1_.name AS name_10, u1_.invite_token AS invite_token_11, n0_.project_id AS project_id_12, n0_.author_id AS author_id_13 FROM note n0_ LEFT JOIN `user` u1_ ON n0_.author_id = u1_.id WHERE n0_.is_public = 1 AND n0_.project_id = 3 AND n0_.id IN (3, 4, 5) ORDER BY n0_.updated_at DESC;