Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1

[
  "api_token"
]

SELECT
  t0.id AS id_1,
  t0.setting AS setting_2,
  t0.default_value AS default_value_3,
  t0.description AS description_4
FROM
  cms_settings t0
WHERE
  t0.setting = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = 'api_token' LIMIT 1;

SELECT
    d.id,
    d.title,
    d.slug,
    d.created_at AS createdAt,
    p.content    AS firstPostContent,
    COALESCE(u.username, 'Inconnu') AS authorName
FROM forum_discussions d
INNER JOIN forum_discussion_tag dt ON dt.discussion_id = d.id
INNER JOIN forum_tags t            ON t.id = dt.tag_id
LEFT JOIN forum_posts p            ON p.id = d.first_post_id
LEFT JOIN forum_users u            ON u.id = d.user_id
WHERE t.slug = :tagSlug
  AND d.hidden_at IS NULL
ORDER BY d.created_at DESC
LIMIT :limit

[
  "tagSlug" => "news"
  "limit" => 50
]

SELECT
  d.id,
  d.title,
  d.slug,
  d.created_at AS createdAt,
  p.content AS firstPostContent,
  COALESCE(u.username, 'Inconnu') AS authorName
FROM
  forum_discussions d
  INNER JOIN forum_discussion_tag dt ON dt.discussion_id = d.id
  INNER JOIN forum_tags t ON t.id = dt.tag_id
  LEFT JOIN forum_posts p ON p.id = d.first_post_id
  LEFT JOIN forum_users u ON u.id = d.user_id
WHERE
  t.slug = :tagSlug
  AND d.hidden_at IS NULL
ORDER BY
  d.created_at DESC
LIMIT
  :limit

SELECT
    d.id,
    d.title,
    d.slug,
    d.created_at AS createdAt,
    p.content    AS firstPostContent,
    COALESCE(u.username, 'Inconnu') AS authorName
FROM forum_discussions d
INNER JOIN forum_discussion_tag dt ON dt.discussion_id = d.id
INNER JOIN forum_tags t            ON t.id = dt.tag_id
LEFT JOIN forum_posts p            ON p.id = d.first_post_id
LEFT JOIN forum_users u            ON u.id = d.user_id
WHERE t.slug = 'news'
  AND d.hidden_at IS NULL
ORDER BY d.created_at DESC
LIMIT 50;