Symfony Profiler

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

Query Metrics

ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,'

[]

ALTER SESSION
SET
  NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,'

ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,';

SELECT u0_.id AS ID_0, u0_.username AS USERNAME_1, u0_.userscu AS USERSCU_2, u0_.created_at AS CREATED_AT_3, u0_.updated_at AS UPDATED_AT_4, u0_.deleted AS DELETED_5, u0_.role_id AS ROLE_ID_6 FROM users u0_ WHERE u0_.userscu = ?

[
  "hjosedes"
]

SELECT
  u0_.id AS ID_0,
  u0_.username AS USERNAME_1,
  u0_.userscu AS USERSCU_2,
  u0_.created_at AS CREATED_AT_3,
  u0_.updated_at AS UPDATED_AT_4,
  u0_.deleted AS DELETED_5,
  u0_.role_id AS ROLE_ID_6
FROM
  users u0_
WHERE
  u0_.userscu = ?

SELECT u0_.id AS ID_0, u0_.username AS USERNAME_1, u0_.userscu AS USERSCU_2, u0_.created_at AS CREATED_AT_3, u0_.updated_at AS UPDATED_AT_4, u0_.deleted AS DELETED_5, u0_.role_id AS ROLE_ID_6 FROM users u0_ WHERE u0_.userscu = 'hjosedes';

SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.created_at AS CREATED_AT_3 FROM roles t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS ID_1,
  t0.name AS NAME_2,
  t0.created_at AS CREATED_AT_3
FROM
  roles t0
WHERE
  t0.id = ?

SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.created_at AS CREATED_AT_3 FROM roles t0 WHERE t0.id = 2;

SELECT a.* FROM (SELECT u0_.id AS ID_0, u0_.username AS USERNAME_1, u0_.userscu AS USERSCU_2, u0_.created_at AS CREATED_AT_3, u0_.updated_at AS UPDATED_AT_4, u0_.deleted AS DELETED_5, u0_.role_id AS ROLE_ID_6 FROM users u0_ ORDER BY u0_.id ASC) a WHERE ROWNUM <= 20

[]

SELECT
  a.*
FROM
  (
    SELECT
      u0_.id AS ID_0,
      u0_.username AS USERNAME_1,
      u0_.userscu AS USERSCU_2,
      u0_.created_at AS CREATED_AT_3,
      u0_.updated_at AS UPDATED_AT_4,
      u0_.deleted AS DELETED_5,
      u0_.role_id AS ROLE_ID_6
    FROM
      users u0_
    ORDER BY
      u0_.id ASC
  ) a
WHERE
  ROWNUM <= 20

SELECT a.* FROM (SELECT u0_.id AS ID_0, u0_.username AS USERNAME_1, u0_.userscu AS USERSCU_2, u0_.created_at AS CREATED_AT_3, u0_.updated_at AS UPDATED_AT_4, u0_.deleted AS DELETED_5, u0_.role_id AS ROLE_ID_6 FROM users u0_ ORDER BY u0_.id ASC) a WHERE ROWNUM <= 20;

SELECT COUNT(u0_.id) AS SCLR_0 FROM users u0_

[]

SELECT
  COUNT(u0_.id) AS SCLR_0
FROM
  users u0_

SELECT COUNT(u0_.id) AS SCLR_0 FROM users u0_;