Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 22
• 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 
                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;

SELECT 
                ap.*, aa.summary
            FROM app_page ap
            INNER JOIN app_article aa on ap.article_id = aa.id
            WHERE ap.page_type = :page_type and ap.is_published = true and ap.link_visible = true

[
  "page_type" => "page"
]

SELECT
  ap.*,
  aa.summary
FROM
  app_page ap
  INNER JOIN app_article aa on ap.article_id = aa.id
WHERE
  ap.page_type = :page_type
  and ap.is_published = true
  and ap.link_visible = true

SELECT 
                ap.*, aa.summary
            FROM app_page ap
            INNER JOIN app_article aa on ap.article_id = aa.id
            WHERE ap.page_type = 'page' and ap.is_published = true and ap.link_visible = true;