Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception 1
• Logs 15
• 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 t0.refresh_token AS refresh_token_1, t0.username AS username_2, t0.valid AS valid_3, t0.id AS id_4 FROM app_refresh_token t0 WHERE t0.refresh_token = ? LIMIT 1

[
  "ff9d0412c67cd42c666f2007aecd92f9de183da13ab5fb12557b3fb5b45a9933421a6649ec44dc354e9a643470c87d83b7ccbfbb188f9c358234b26ec1d73937"
]

SELECT
  t0.refresh_token AS refresh_token_1,
  t0.username AS username_2,
  t0.valid AS valid_3,
  t0.id AS id_4
FROM
  app_refresh_token t0
WHERE
  t0.refresh_token = ?
LIMIT
  1

SELECT t0.refresh_token AS refresh_token_1, t0.username AS username_2, t0.valid AS valid_3, t0.id AS id_4 FROM app_refresh_token t0 WHERE t0.refresh_token = 'ff9d0412c67cd42c666f2007aecd92f9de183da13ab5fb12557b3fb5b45a9933421a6649ec44dc354e9a643470c87d83b7ccbfbb188f9c358234b26ec1d73937' LIMIT 1;

SELECT NEXTVAL('app_refresh_token_id_seq')

[]

SELECT
  NEXTVAL('app_refresh_token_id_seq')

SELECT NEXTVAL('app_refresh_token_id_seq');