Symfony Profiler

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

Query Metrics

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_.setup_token AS setup_token_11, u1_.setup_token_expires_at AS setup_token_expires_at_12 FROM note n0_ LEFT JOIN `user` u1_ ON n0_.author_id = u1_.id WHERE n0_.is_public = 1 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_.setup_token AS setup_token_11,
          u1_.setup_token_expires_at AS setup_token_expires_at_12
        FROM
          note n0_
          LEFT JOIN `user` u1_ ON n0_.author_id = u1_.id
        WHERE
          n0_.is_public = 1
        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_.setup_token AS setup_token_11, u1_.setup_token_expires_at AS setup_token_expires_at_12 FROM note n0_ LEFT JOIN `user` u1_ ON n0_.author_id = u1_.id WHERE n0_.is_public = 1 ORDER BY n0_.updated_at DESC) dctrn_result) dctrn_table;

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.setup_token AS setup_token_6, t0.setup_token_expires_at AS setup_token_expires_at_7 FROM `user` t0

[]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.setup_token AS setup_token_6,
  t0.setup_token_expires_at AS setup_token_expires_at_7
FROM
  `user` t0

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.setup_token AS setup_token_6, t0.setup_token_expires_at AS setup_token_expires_at_7 FROM `user` t0;

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.parasite_words AS parasite_words_6, t0.last_imported_at AS last_imported_at_7 FROM category t0

[]

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.parasite_words AS parasite_words_6,
  t0.last_imported_at AS last_imported_at_7
FROM
  category t0

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.parasite_words AS parasite_words_6, t0.last_imported_at AS last_imported_at_7 FROM category t0;

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_.setup_token AS setup_token_11, u1_.setup_token_expires_at AS setup_token_expires_at_12 FROM note n0_ LEFT JOIN `user` u1_ ON n0_.author_id = u1_.id WHERE n0_.is_public = 1) 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_.setup_token AS setup_token_11,
          u1_.setup_token_expires_at AS setup_token_expires_at_12
        FROM
          note n0_
          LEFT JOIN `user` u1_ ON n0_.author_id = u1_.id
        WHERE
          n0_.is_public = 1
      ) 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_.setup_token AS setup_token_11, u1_.setup_token_expires_at AS setup_token_expires_at_12 FROM note n0_ LEFT JOIN `user` u1_ ON n0_.author_id = u1_.id WHERE n0_.is_public = 1) 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_.setup_token AS setup_token_11, u1_.setup_token_expires_at AS setup_token_expires_at_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_.id IN (?) ORDER BY n0_.updated_at DESC

[
  2
]

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_.setup_token AS setup_token_11,
  u1_.setup_token_expires_at AS setup_token_expires_at_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_.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_.setup_token AS setup_token_11, u1_.setup_token_expires_at AS setup_token_expires_at_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_.id IN (2) ORDER BY n0_.updated_at DESC;