Symfony Profiler

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

Query Metrics

SELECT 
                au.*
            FROM app_user au
            WHERE au.email = :username

[
  "username" => "vedran.hudec@gmail.com"
]

SELECT
  au.*
FROM
  app_user au
WHERE
  au.email = :username

SELECT 
                au.*
            FROM app_user au
            WHERE au.email = 'vedran.hudec@gmail.com';

SELECT 
                aa.*, au.full_name as author_name, au.alias as author_alias
            FROM app_article aa
            INNER JOIN app_user au on aa.author_id = au.id
            WHERE is_published = true and is_deleted = false and aa.author_id = :author_id
            ORDER BY is_pinned desc NULLS LAST, aa.created_at desc

[
  "author_id" => "97205913-94aa-46fc-aa35-1c50704edfd6"
]

SELECT
  aa.*,
  au.full_name as author_name,
  au.alias as author_alias
FROM
  app_article aa
  INNER JOIN app_user au on aa.author_id = au.id
WHERE
  is_published = true
  and is_deleted = false
  and aa.author_id = :author_id
ORDER BY
  is_pinned desc NULLS LAST,
  aa.created_at desc

SELECT 
                aa.*, au.full_name as author_name, au.alias as author_alias
            FROM app_article aa
            INNER JOIN app_user au on aa.author_id = au.id
            WHERE is_published = true and is_deleted = false and aa.author_id = '97205913-94aa-46fc-aa35-1c50704edfd6'
            ORDER BY is_pinned desc NULLS LAST, aa.created_at desc;

SELECT 
                r.name
            FROM app_user_roles r
            INNER JOIN app_assigned_user_roles ar ON ar.role_id = r.id AND ar.user_id = :user_id

[
  "user_id" => "97205913-94aa-46fc-aa35-1c50704edfd6"
]

SELECT
  r.name
FROM
  app_user_roles r
  INNER JOIN app_assigned_user_roles ar ON ar.role_id = r.id
  AND ar.user_id = :user_id

SELECT 
                r.name
            FROM app_user_roles r
            INNER JOIN app_assigned_user_roles ar ON ar.role_id = r.id AND ar.user_id = '97205913-94aa-46fc-aa35-1c50704edfd6';

SELECT a.password FROM app_user 
            INNER JOIN app_user_auth a on app_user.id = a.user_id
            WHERE app_user.id = :user_id and app_user.is_locked = false

[
  "user_id" => "97205913-94aa-46fc-aa35-1c50704edfd6"
]

SELECT
  a.password
FROM
  app_user
  INNER JOIN app_user_auth a on app_user.id = a.user_id
WHERE
  app_user.id = :user_id
  and app_user.is_locked = false

SELECT a.password FROM app_user 
            INNER JOIN app_user_auth a on app_user.id = a.user_id
            WHERE app_user.id = '97205913-94aa-46fc-aa35-1c50704edfd6' and app_user.is_locked = false;