Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation 1
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Emails
• EasyAdmin
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2 FROM symfony_demo_tag t0 WHERE t0.name = ? LIMIT 1

[
  "jazz"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  symfony_demo_tag t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM symfony_demo_tag t0 WHERE t0.name = 'jazz' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.filename AS filename_3, t0.alt_text AS alt_text_4, t0.updateup AS updateup_5, t0.page AS page_6, t0.numero AS numero_7, t0.lien AS lien_8 FROM media t0 WHERE t0.page = ? ORDER BY t0.numero ASC

[
  "sidebar"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.filename AS filename_3,
  t0.alt_text AS alt_text_4,
  t0.updateup AS updateup_5,
  t0.page AS page_6,
  t0.numero AS numero_7,
  t0.lien AS lien_8
FROM
  media t0
WHERE
  t0.page = ?
ORDER BY
  t0.numero ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.filename AS filename_3, t0.alt_text AS alt_text_4, t0.updateup AS updateup_5, t0.page AS page_6, t0.numero AS numero_7, t0.lien AS lien_8 FROM media t0 WHERE t0.page = 'sidebar' ORDER BY t0.numero ASC;

SELECT DISTINCT s0_.id AS id_0, s0_.published_at AS published_at_1 FROM symfony_demo_post s0_ INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE EXISTS (SELECT 1 FROM symfony_demo_post_tag s4_ WHERE s4_.post_id = s0_.id AND s4_.tag_id IN (?)) ORDER BY s0_.published_at DESC LIMIT 10

[
  3
]

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.published_at AS published_at_1
FROM
  symfony_demo_post s0_
  INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id
  LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id
  LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id
WHERE
  EXISTS (
    SELECT
      1
    FROM
      symfony_demo_post_tag s4_
    WHERE
      s4_.post_id = s0_.id
      AND s4_.tag_id IN (?)
  )
ORDER BY
  s0_.published_at DESC
LIMIT
  10

SELECT DISTINCT s0_.id AS id_0, s0_.published_at AS published_at_1 FROM symfony_demo_post s0_ INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE EXISTS (SELECT 1 FROM symfony_demo_post_tag s4_ WHERE s4_.post_id = s0_.id AND s4_.tag_id IN (3)) ORDER BY s0_.published_at DESC LIMIT 10;

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.summary AS summary_3, s0_.content AS content_4, s0_.published_at AS published_at_5, s0_.filename AS filename_6, s1_.id AS id_7, s1_.full_name AS full_name_8, s1_.username AS username_9, s1_.email AS email_10, s1_.password AS password_11, s1_.roles AS roles_12, s2_.id AS id_13, s2_.name AS name_14, s0_.author_id AS author_id_15 FROM symfony_demo_post s0_ INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE EXISTS (SELECT 1 FROM symfony_demo_post_tag s4_ WHERE s4_.post_id = s0_.id AND s4_.tag_id IN (?)) AND s0_.id IN (?, ?, ?) ORDER BY s0_.published_at DESC, s2_.name ASC

[
  3
  40
  38
  36
]

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.slug AS slug_2,
  s0_.summary AS summary_3,
  s0_.content AS content_4,
  s0_.published_at AS published_at_5,
  s0_.filename AS filename_6,
  s1_.id AS id_7,
  s1_.full_name AS full_name_8,
  s1_.username AS username_9,
  s1_.email AS email_10,
  s1_.password AS password_11,
  s1_.roles AS roles_12,
  s2_.id AS id_13,
  s2_.name AS name_14,
  s0_.author_id AS author_id_15
FROM
  symfony_demo_post s0_
  INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id
  LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id
  LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id
WHERE
  EXISTS (
    SELECT
      1
    FROM
      symfony_demo_post_tag s4_
    WHERE
      s4_.post_id = s0_.id
      AND s4_.tag_id IN (?)
  )
  AND s0_.id IN (?, ?, ?)
ORDER BY
  s0_.published_at DESC,
  s2_.name ASC

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.summary AS summary_3, s0_.content AS content_4, s0_.published_at AS published_at_5, s0_.filename AS filename_6, s1_.id AS id_7, s1_.full_name AS full_name_8, s1_.username AS username_9, s1_.email AS email_10, s1_.password AS password_11, s1_.roles AS roles_12, s2_.id AS id_13, s2_.name AS name_14, s0_.author_id AS author_id_15 FROM symfony_demo_post s0_ INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE EXISTS (SELECT 1 FROM symfony_demo_post_tag s4_ WHERE s4_.post_id = s0_.id AND s4_.tag_id IN (3)) AND s0_.id IN (40, 38, 36) ORDER BY s0_.published_at DESC, s2_.name ASC;

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM symfony_demo_post s0_ INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE EXISTS (SELECT 1 FROM symfony_demo_post_tag s4_ WHERE s4_.post_id = s0_.id AND s4_.tag_id IN (?))

[
  3
]

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  symfony_demo_post s0_
  INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id
  LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id
  LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id
WHERE
  EXISTS (
    SELECT
      1
    FROM
      symfony_demo_post_tag s4_
    WHERE
      s4_.post_id = s0_.id
      AND s4_.tag_id IN (?)
  )

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM symfony_demo_post s0_ INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE EXISTS (SELECT 1 FROM symfony_demo_post_tag s4_ WHERE s4_.post_id = s0_.id AND s4_.tag_id IN (3));